销售排程表

1、【订单明细】中，录入相应资料,确保同一客户，客户名称一致，日期不能为空，未交数量列有公式，自动计算,2、【销售排程】点击查询按钮，选择客户，起止日期，以及进度，自动生成统计表,必看：此模板为宏模板，若下载不能启用宏。可下载插件启用。插件安装后，重新下载打开模板即可正常使用。插件下载地址:https://pan.baidu.com/s/11AUFBYgjQKKMrGHcYOoKuw,销 售 订 单 排 程 表,接单日期客户订单号客户名称客户料号产品名称产品规格单位订单数量单价接单金额PS号客户交期已交,数量未交,数量业务担当备注单据,状态,42889.0PS-5XC-5949-01220*34.1*0.15T0.0210.0PS-50742889.0作废,XC-5949-03220*23.8*0.15T1.022040.0PS-508180.01820.0,XC-6038双面胶216.31*70.25*0.12T2.024040.0PS-509,XC-613737.3*12.11*0.17T4.028040.0PS-510,XC-6039双面胶140.3*129.4*0.12T3.026040.0PS-511,PO-009MD-PAT-015-9999L172.6*46.5*0.3T9.024510.0PS-512,PO-010MD-PAT-001-9999L平底贴纸134*2811.025521.02PS-513,PO-011MD-PAT-024-9999L131.8*26.2*0.4T502.010.025030.04PS-514300.0202.0,PO-012MD-PAT-027-9999L面板贴片134.5*12*0.3T503.013.026549.06PS-515200.0303.0,PO-013MD-PAT-036-9999L172.6*46.5*0.3T504.012.026058.08PS-5164.0,PO-014SP-PAT-140022-AL面板贴片134.5*12*0.3T505.0PS-5175.0,P171215121314PS-51850.0,PO-005ACB-ZIF-322-P01PS-51951.0,PO-006ACB-ZIF-376-P01103.9*69.5*0.178T502.0PS-52052.0,PO-007ACB-ZIF-316-P01503.0PS-52153.0,PO-008BHSK0008-P00193.5*93.5*0.178T504.0PS-52254.0,PO-009505.0PS-52355.0,PO-010ACB-ZIF-324-P02506.0PS-52456.0,PO-011507.0PS-52557.0,PO-012ACB-ZIF-376-P01103.9*69.5*0.178T508.0PS-52658.0,PO-013ACB-ZIF-316-P01509.059.0,42895.0PS-502XC-5949-08220*23.8*0.15T1.02510.042896.060.0440.0,42895.0PS-502XC-5949-01220*34.1*0.15T600.00.0212.042896.061.0539.0,销售排程,客户名称：从42736.0,订单进度：未完成到43131.0,接单日期客户订单号客户名称客户料号产品名称产品规格订单数量未交数量客户交期备注,42890.0PO-001XC-5949-03220*23.8*0.15T2000.01820.042894.0,42895.0PS-502XC-5949-08220*23.8*0.15T500.0440.042896.0,42895.0PS-502XC-5949-01220*34.1*0.15T600.0539.042896.0