售后服务管理表

售后服务管理 表 关于同志近三年现实表现材料材料类招标技术评分表图表与交易pdf视力表打印pdf用图表说话 pdf 售后订单Aftersalesorders序号受理日期订单编码品名金额售后类型截止日期状态完成日期是否延期备注12023/01/01824.00退货2023/01/281已受理延期售后记录售后总额完成率(%)22023/01/03362.00换货2023/01/252处理中延期183206722.0042.62%32023/01/051688.00退货2023/01/283已完成2023/01/08本月记录上月记录环比变化42023/01/071041.00退货2023/01/253已完成2023/01/133715146.67%52023/01/09311.00换货2023/02/012处理中延期延期记录应完记录延期占比62023/01/11627.00维修2023/02/083已完成2023/01/16396857.35%72023/01/13242.00其他2023/01/221已受理延期82023/01/15478.00维修2023/02/011已受理延期92023/01/171127.00退货2023/01/212处理中延期类型记录金额102023/01/19701.00退货2023/01/233已完成2023/01/21退货8294319.00112023/01/211992.00换货2023/01/283已完成2023/01/27换货4146149.00122023/01/231979.00退货2023/02/102处理中延期维修4043659.00132023/01/25834.00退货2023/02/093已完成2023/01/31其他2022595.00142023/01/27406.00换货2023/02/141已受理延期152023/01/29697.00维修2023/02/261已受理延期162023/01/31927.00其他2023/02/082处理中延期172023/02/021740.00维修2023/02/203已完成2023/02/05状态记录金额182023/02/04425.00退货2023/02/093已完成2023/02/09已受理5355534.00192023/02/061101.00退货2023/02/192处理中延期处理中5260137.00202023/02/081147.00换货2023/03/083已完成2023/02/13已完成7891051.00212023/02/101894.00退货2023/03/101已受理延期222023/02/121480.00退货2023/02/281已受理延期232023/02/141553.00换货2023/02/192处理中延期242023/02/16915.00维修2023/03/053已完成2023/02/19月份受理记录完成记录252023/02/18986.00其他2023/03/163已完成2023/02/251月166262023/02/201650.00维修2023/03/042处理中延期2月146272023/02/22426.00退货2023/03/193已完成2023/02/253月155282023/02/24499.00退货2023/03/031已受理延期4月156292023/02/261314.00换货2023/03/181已受理延期5月3713302023/02/281443.00退货2023/03/112处理中延期6月46312023/03/02615.00退货2023/03/173已完成2023/03/107月52322023/03/041997.00换货2023/03/213已完成2023/03/108月166332023/03/061810.00维修2023/03/172处理中延期9月156342023/03/08914.00其他2023/03/243已完成2023/03/1210月157352023/03/10601.00维修2023/03/151已受理延期11月157362023/03/12794.00退货2023/03/251已受理延期12月167372023/03/141438.00退货2023/04/052处理中延期382023/03/16502.00换货2023/04/093已完成2023/03/21392023/03/181406.00退货2023/03/263已完成延期402023/03/20520.00退货2023/04/182处理中延期查询年度412023/03/22697.00换货2023/04/063已完成2023/03/272023422023/03/24938.00维修2023/04/221已受理延期432023/03/26329.00其他2023/04/041已受理延期442023/03/28724.00维修2023/04/252处理中延期452023/03/301260.00退货2023/04/093已完成2023/04/01462023/04/011492.00退货2023/04/083已完成2023/04/05472023/04/03742.00换货2023/04/182处理中延期482023/04/05710.00退货2023/04/233已完成2023/04/10492023/04/071735.00退货2023/05/021已受理延期502023/04/091463.00换货2023/04/151已受理延期512023/04/11617.00维修2023/05/012处理中延期522023/04/131109.00其他2023/05/043已完成2023/04/15532023/04/151083.00维修2023/04/203已完成2023/04/19542023/04/171332.00退货2023/04/212处理中延期552023/04/191900.00退货2023/04/223已完成2023/04/22562023/04/21966.00换货2023/05/081已受理延期572023/04/231758.00退货2023/05/191已受理延期582023/04/251099.00退货2023/05/122处理中延期592023/04/271661.00换货2023/05/033已完成2023/05/02602023/04/29776.00维修2023/05/233已完成2023/05/02612023/05/01310.00其他2023/05/162处理中延期622023/05/031578.00维修2023/05/223已完成2023/05/06632023/05/05892.00退货2023/06/011已受理642023/05/071659.00退货2023/05/131已受理延期652023/05/091749.00换货2023/05/312处理中662023/05/112037.00退货2023/06/033已完成2023/05/17672023/05/131160.00退货2023/06/093已完成2023/05/19682023/05/151092.00换货2023/05/282处理中延期692023/05/17453.00维修2023/06/083已完成2023/05/19702023/05/191944.00其他2023/06/051已受理712023/05/21389.00维修2023/06/011已受理722023/05/231935.00退货2023/06/062处理中732023/05/25508.00退货2023/06/063已完成2023/06/01742023/05/27829.00换货2023/06/103已完成2023/06/03752023/05/29952.00退货2023/06/112处理中762023/05/31207.00退货2023/06/163已完成2023/06/03772023/06/02518.00换货2023/06/291已受理782023/06/041650.00维修2023/07/031已受理792023/05/11501.00其他2023/06/082处理中802023/05/121719.00维修2023/05/213已完成2023/05/15812023/05/131793.00退货2023/06/103已完成2023/05/21822023/05/141332.00退货2023/06/092处理中832023/05/15786.00换货2023/05/293已完成2023/05/18842023/05/161089.00退货2023/05/281已受理延期852023/05/171916.00退货2023/06/111已受理862023/05/18411.00换货2023/05/292处理中872023/05/19900.00维修2023/06/173已完成2023/05/23882023/05/20411.00其他2023/06/023已完成2023/05/28892023/05/211931.00维修2023/06/012处理中902023/05/22537.00退货2023/06/143已完成2023/05/30912023/05/23714.00退货2023/06/061已受理922023/05/241582.00换货2023/06/101已受理932023/05/251871.00退货2023/06/092处理中942023/05/261725.00退货2023/05/303已完成2023/05/28952023/05/271139.00换货2023/06/133已完成2023/06/03962023/05/28449.00维修2023/06/182处理中972023/05/291287.00其他2023/06/163已完成2023/06/05982023/05/301823.00维修2023/06/021已受理992023/05/31394.00退货2023/06/061已受理1002023/06/011932.00退货2023/06/302处理中1012023/06/02322.00换货2023/06/303已完成2023/06/051022023/07/22681.00退货2023/08/113已完成2023/07/241032023/07/24669.00退货2023/08/232处理中1042023/07/261782.00换货2023/07/293已完成2023/07/30延期1052023/07/281894.00维修2023/08/011已受理1062023/07/302091.00其他2023/08/021已受理1072023/08/011026.00维修2023/08/172处理中1082023/08/03785.00退货2023/08/273已完成2023/08/081092023/08/051451.00退货2023/08/173已完成2023/08/101102023/08/071788.00换货2023/08/122处理中1112023/08/091709.00退货2023/08/203已完成2023/08/111122023/08/111599.00退货2023/08/261已受理1132023/08/132009.00换货2023/08/241已受理1142023/08/15259.00维修2023/08/192处理中1152023/08/171720.00其他2023/09/063已完成2023/08/231162023/08/19732.00维修2023/09/163已完成2023/08/271172023/08/21731.00退货2023/09/112处理中1182023/08/231296.00退货2023/09/183已完成2023/08/261192023/08/251102.00换货2023/09/011已受理1202023/08/27540.00退货2023/09/061已受理1212023/08/292028.00退货2023/09/092处理中1222023/08/31705.00换货2023/09/113已完成2023/09/081232023/09/021670.00维修2023/09/243已完成2023/09/081242023/09/042049.00其他2023/09/232处理中1252023/09/06296.00维修2023/09/193已完成2023/09/131262023/09/08330.00退货2023/09/161已受理1272023/09/10642.00退货2023/09/131已受理1282023/09/121070.00换货2023/10/012处理中1292023/09/141668.00退货2023/09/303已完成2023/09/161302023/09/16343.00退货2023/10/023已完成2023/09/191312023/09/181386.00换货2023/10/082处理中1322023/09/201998.00维修2023/10/183已完成2023/09/241332023/09/221098.00其他2023/10/031已受理1342023/09/24576.00维修2023/10/151已受理1352023/09/26760.00退货2023/10/232处理中1362023/09/281711.00退货2023/10/113已完成2023/10/041372023/09/301627.00换货2023/10/053已完成2023/10/07延期1382023/10/021018.00退货2023/10/252处理中1392023/10/041061.00退货2023/10/223已完成2023/10/111402023/10/06256.00换货2023/10/291已受理1412023/10/08270.00维修2023/10/211已受理1422023/10/101081.00其他2023/10/182处理中1432023/10/121801.00维修2023/11/023已完成2023/10/201442023/10/141676.00退货2023/10/223已完成2023/10/221452023/10/161690.00退货2023/11/012处理中1462023/10/181736.00换货2023/11/113已完成2023/10/261472023/10/20205.00退货2023/11/111已受理1482023/10/221093.00退货2023/11/071已受理1492023/10/24393.00换货2023/10/282处理中1502023/10/26502.00维修2023/11/023已完成2023/10/291512023/10/281733.00其他2023/11/243已完成2023/11/041522023/10/301454.00维修2023/11/092处理中1532023/11/011255.00退货2023/11/303已完成2023/11/061542023/11/031300.00退货2023/11/101已受理1552023/11/051747.00换货2023/11/301已受理1562023/11/071149.00退货2023/12/072处理中1572023/11/09792.00退货2023/12/013已完成2023/11/141582023/11/111740.00换货2023/12/033已完成2023/11/161592023/11/13936.00维修2023/11/182处理中1602023/11/15918.00其他2023/11/233已完成2023/11/181612023/11/17827.00维修2023/12/111已受理1622023/11/191758.00退货2023/12/011已受理1632023/11/211535.00退货2023/12/202处理中1642023/11/231685.00换货2023/12/123已完成2023/11/251652023/11/252004.00退货2023/12/233已完成2023/11/291662023/11/27475.00退货2023/12/122处理中1672023/11/291116.00换货2023/12/173已完成2023/12/051682023/12/011899.00维修2023/12/171已受理1692023/12/03995.00其他2023/12/251已受理1702023/12/051446.00维修2023/12/242处理中1712023/12/071756.00退货2024/01/033已完成2023/12/121722023/12/09733.00退货2023/12/143已完成2023/12/16延期1732023/12/111524.00换货2023/12/312处理中1742023/12/13927.00退货2023/12/183已完成2023/12/181752023/12/15257.00退货2024/01/131已受理1762023/12/17528.00换货2024/01/161已受理1772023/12/191488.00维修2023/12/312处理中1782023/12/211950.00其他2024/01/053已完成2023/12/261792023/12/231037.00维修2023/12/303已完成2023/12/31延期1802023/12/25982.00退货2024/01/112处理中1812023/12/27420.00退货2024/01/263已完成2023/12/301822023/12/29414.00换货2024/01/181已受理1832023/12/311116.00退货2024/01/241已受理0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000数据看板处理状态年度统计辅助查询null·当空白行输入内容，公式无法正常显示，如何处理？1、选中显示数据的单元格2、鼠标放置右下角，当鼠标箭头变成黑色十字形时，下拉单元格，公式会覆盖到空白行区域