{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["预测输入","销售额预测","列表"],"not_rendered":{"charts":1,"images":1,"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"预测输入","index":0,"n_rows":29,"n_cols":11,"rows_kept":29}
[{"$nulls":10}," "]
[null,"公司机密"]
[null,"公司名称"]
[null,"销售预测"]
[]
[null,"商机名称","销售代理","销售区域","销售类别","预测金额","销售阶段","销售概率","预测结束","加权预测"]
[null,"Adatum Corporation"," 销售代理 1","美国 - 东北地区","咨询","2310-09-07","正式批准",{"v":0.9,"d":"90%"},{"$f":"DATE(YEAR(TODAY())+1,1,1)","v":"2020-01-01"},"2269-08-12"]
[null,"Adventure Works"," 销售代理 2","美国 - 东南地区","产品","2297-07-16","商机",{"v":0.1,"d":"10%"},{"$f":"DATE(YEAR(TODAY())+1,2,1)","v":"2020-02-01"},"1939-10-02"]
[null,"Alpine Ski House"," 销售代理 3","美国 - 中北部地区","培训","2344-11-27","已确定需求",{"v":0.2,"d":"20%"},{"$f":"DATE(YEAR(TODAY())+1,3,1)","v":"2020-03-01"},"1988-12-23"]
[null,"Baldwin Museum of Science"," 销售代理 4","美国 - 中南部地区","混合","2303-11-03","赞助",{"v":0.3,"d":"30%"},{"$f":"DATE(YEAR(TODAY())+1,4,1)","v":"2020-04-01"},"2021-02-23"]
[null,"Blue Yonder Airlines"," 销售代理 5","美国 - 西北地区","专业服务","2305-03-17","预算已验证",{"v":0.4,"d":"40%"},{"$f":"DATE(YEAR(TODAY())+1,5,1)","v":"2020-05-01"},"2062-01-29"]
[null,"City Power & Light"," 销售代理 1","美国 - 西南地区","支持","2379-02-17","需求分析",{"v":0.5,"d":"50%"},{"$f":"DATE(YEAR(TODAY())+1,6,1)","v":"2020-06-01"},"2139-07-25"]
[null,"Coho Vineyard"," 销售代理 3","加拿大 - 东部地区","混合","2307-12-12","已提出解决方案",{"v":0.6,"d":"60%"},{"$f":"DATE(YEAR(TODAY())+1,7,1)","v":"2020-07-01"},"2144-10-06"]
[null,"Coho Winery"," 销售代理 5","加拿大 - 西部地区","培训","2288-10-11","书面建议",{"v":0.7,"d":"70%"},{"$f":"DATE(YEAR(TODAY())+1,8,1)","v":"2020-08-01"},"2172-02-22"]
[null,"Contoso, Ltd."," 销售代理 3","EMEA - 法国","混合","2372-04-14","口头批准",{"v":0.9,"d":"90%"},{"$f":"DATE(YEAR(TODAY())+1,10,1)","v":"2020-10-01"},"2325-01-21"]
[null,"Contoso Pharmaceuticals"," 销售代理 4","EMEA - 德国","产品","2347-08-24","赞助",{"v":0.2,"d":"20%"},{"$f":"DATE(YEAR(TODAY())+1,11,1)","v":"2020-11-01"},"1989-07-11"]
[null,"Consolidated Messenger"," 销售代理 5","EMEA - 意大利","产品","2325-09-28","正式批准",{"v":1,"d":"100%"},{"$f":"DATE(YEAR(TODAY())+1,12,1)","v":"2020-12-01"},"2325-09-28"]
[null,"Fabrikam, Inc."," 销售代理 4","EMEA - 其他","咨询","2354-06-28","商机",{"v":0.1,"d":"10%"},{"$f":"DATE(YEAR(TODAY())+1,1,1)","v":"2020-01-01"},"1945-06-12"]
[null,"Fourth Coffee"," 销售代理 3","APSA - 亚洲","培训","2392-10-26","预算已验证",{"v":0.3,"d":"30%"},{"$f":"DATE(YEAR(TODAY())+1,3,1)","v":"2020-03-01"},"2047-11-04"]
[null,"Graphic Design Institute"," 销售代理 2","APSA - 太平洋地区","服务","2283-04-21","已提出解决方案",{"v":0.6,"d":"60%"},{"$f":"DATE(YEAR(TODAY())+1,5,1)","v":"2020-05-01"},"2129-12-24"]
[null,"Humongous Insurance"," 销售代理 1","APSA - 墨西哥","支持","2324-05-16","赞助",{"v":0.3,"d":"30%"},{"$f":"DATE(YEAR(TODAY())+1,6,1)","v":"2020-06-01"},"2027-04-23"]
[null,"Litware, Inc."," 销售代理 2","APSA - 澳大利亚","专业服务","2374-03-15","需求分析",{"v":0.5,"d":"50%"},{"$f":"DATE(YEAR(TODAY())+1,10,1)","v":"2020-10-01"},"2137-02-05"]
[null,"Lucerne Publishing"," 销售代理 5","APSA - 其他","服务","2301-02-06","已提出解决方案",{"v":0.6,"d":"60%"},{"$f":"DATE(YEAR(TODAY())+1,12,1)","v":"2020-12-01"},"2140-08-28"]
[null,"Margie's Travel"," 销售代理 4","美国 - 东北地区","支持","2329-03-01","书面建议",{"v":0.7,"d":"70%"},{"$f":"DATE(YEAR(TODAY())+1,11,1)","v":"2020-11-01"},"2200-05-31"]
[null,"Northwind Traders"," 销售代理 3","美国 - 中南部地区","专业服务","2343-07-16","口头批准",{"v":0.9,"d":"90%"},{"$f":"DATE(YEAR(TODAY())+1,2,1)","v":"2020-02-01"},"2299-03-08"]
[null,"Proseware, Inc."," 销售代理 4","加拿大 - 东部地区","混合","2329-11-06","正式批准",{"v":1,"d":"100%"},{"$f":"DATE(YEAR(TODAY())+1,3,1)","v":"2020-03-01"},"2329-11-06"]
[null,"School of Fine Art"," 销售代理 3","EMEA - 法国","服务","2373-08-27","预算已验证",{"v":0.4,"d":"40%"},{"$f":"DATE(YEAR(TODAY())+1,4,1)","v":"2020-04-01"},"2089-06-16"]
[null,"Southridge Video"," 销售代理 5","EMEA - 英国","混合","2368-03-06","需求分析",{"v":0.5,"d":"50%"},{"$f":"DATE(YEAR(TODAY())+1,8,1)","v":"2020-08-01"},"2134-02-01"]
[null,"Tailspin Toys"," 销售代理 1","APSA - 澳大利亚","产品","2359-12-19","已提出解决方案",{"v":0.6,"d":"60%"},{"$f":"DATE(YEAR(TODAY())+1,9,1)","v":"2020-09-01"},"2175-12-23"]

{"sheet":"销售额预测","index":1,"n_rows":20,"n_cols":18,"rows_kept":20}
[{"$nulls":10}," "]
[null,"公司机密"]
[]
[null,"销售预测图"]
[]
[null,"起始月份",{"$f":"DATE(YEAR(TODAY())+1,1,1)","v":"2020-01-01"}]
[]
[null,"月份","月度预测","累积",{"$nulls":11},{"$f":"B8","v":"月份"},"月度预测","累积"]
[null,{"$f":"DATE(YEAR(Starting_Month),MONTH(Starting_Month)+0,1)","v":"2020-01-01"},{"$f":"SUMIFS(Table_ForecastInput[加权预测],Table_ForecastInput[预测结束],\">=\"&销售额预测!B9,Table_ForecastInput[预测结束],\"<=\"&DATE(YEAR(销售额预测!B9),MONTH(销售额预测!B9)+1,0))","v":{"v":151600,"d":"¥151,600"}},{"$f":"IF(ISNUMBER(D8),D8+C9,C9)","v":{"v":151600,"d":"¥151,600"}},{"$nulls":11},{"$f":"B9","v":"2020-01-01"},{"$f":"C9","v":{"v":151600,"d":"¥151,600"}},{"$f":"D9-C9","v":0}]
[null,{"$f":"DATE(YEAR(Starting_Month),MONTH(Starting_Month)+1,1)","v":"2020-02-01"},{"$f":"SUMIFS(Table_ForecastInput[加权预测],Table_ForecastInput[预测结束],\">=\"&销售额预测!B10,Table_ForecastInput[预测结束],\"<=\"&DATE(YEAR(销售额预测!B10),MONTH(销售额预测!B10)+1,0))","v":{"v":160320,"d":"¥160,320"}},{"v":311920,"d":"¥311,920"},{"$nulls":11},"2020-02-01",{"$f":"C10","v":{"v":160320,"d":"¥160,320"}},{"$f":"D10-C10","v":{"v":151600,"d":"¥151,600"}}]
[null,{"$f":"DATE(YEAR(Starting_Month),MONTH(Starting_Month)+2,1)","v":"2020-03-01"},{"$f":"SUMIFS(Table_ForecastInput[加权预测],Table_ForecastInput[预测结束],\">=\"&销售额预测!B11,Table_ForecastInput[预测结束],\"<=\"&DATE(YEAR(销售额预测!B11),MONTH(销售额预测!B11)+1,0))","v":{"v":243500,"d":"¥243,500"}},{"v":555420,"d":"¥555,420"},{"$nulls":11},"2020-03-01",{"v":243500,"d":"¥243,500"},{"v":311920,"d":"¥311,920"}]
[null,{"$f":"DATE(YEAR(Starting_Month),MONTH(Starting_Month)+3,1)","v":"2020-04-01"},{"$f":"SUMIFS(Table_ForecastInput[加权预测],Table_ForecastInput[预测结束],\">=\"&销售额预测!B12,Table_ForecastInput[预测结束],\"<=\"&DATE(YEAR(销售额预测!B12),MONTH(销售额预测!B12)+1,0))","v":{"v":113450,"d":"¥113,450"}},{"v":668870,"d":"¥668,870"},{"$nulls":11},"2020-04-01",{"v":113450,"d":"¥113,450"},{"v":555420,"d":"¥555,420"}]
[null,{"$f":"DATE(YEAR(Starting_Month),MONTH(Starting_Month)+4,1)","v":"2020-05-01"},{"$f":"SUMIFS(Table_ForecastInput[加权预测],Table_ForecastInput[预测结束],\">=\"&销售额预测!B13,Table_ForecastInput[预测结束],\"<=\"&DATE(YEAR(销售额预测!B13),MONTH(销售额预测!B13)+1,0))","v":{"v":143200,"d":"¥143,200"}},{"v":812070,"d":"¥812,070"},{"$nulls":11},"2020-05-01",{"v":143200,"d":"¥143,200"},{"v":668870,"d":"¥668,870"}]
[null,{"$f":"DATE(YEAR(Starting_Month),MONTH(Starting_Month)+5,1)","v":"2020-06-01"},{"$f":"SUMIFS(Table_ForecastInput[加权预测],Table_ForecastInput[预测结束],\">=\"&销售额预测!B14,Table_ForecastInput[预测结束],\"<=\"&DATE(YEAR(销售额预测!B14),MONTH(销售额预测!B14)+1,0))","v":{"v":134000,"d":"¥134,000"}},{"v":946070,"d":"¥946,070"},{"$nulls":11},"2020-06-01",{"v":134000,"d":"¥134,000"},{"v":812070,"d":"¥812,070"}]
[null,{"$f":"DATE(YEAR(Starting_Month),MONTH(Starting_Month)+6,1)","v":"2020-07-01"},{"$f":"SUMIFS(Table_ForecastInput[加权预测],Table_ForecastInput[预测结束],\">=\"&销售额预测!B15,Table_ForecastInput[预测结束],\"<=\"&DATE(YEAR(销售额预测!B15),MONTH(销售额预测!B15)+1,0))","v":{"v":89400,"d":"¥89,400"}},{"v":1035470,"d":"¥1,035,470"},{"$nulls":11},"2020-07-01",{"v":89400,"d":"¥89,400"},{"v":946070,"d":"¥946,070"}]
[null,{"$f":"DATE(YEAR(Starting_Month),MONTH(Starting_Month)+7,1)","v":"2020-08-01"},{"$f":"SUMIFS(Table_ForecastInput[加权预测],Table_ForecastInput[预测结束],\">=\"&销售额预测!B16,Table_ForecastInput[预测结束],\"<=\"&DATE(YEAR(销售额预测!B16),MONTH(销售额预测!B16)+1,0))","v":{"v":184900,"d":"¥184,900"}},{"v":1220370,"d":"¥1,220,370"},{"$nulls":11},"2020-08-01",{"v":184900,"d":"¥184,900"},{"v":1035470,"d":"¥1,035,470"}]
[null,{"$f":"DATE(YEAR(Starting_Month),MONTH(Starting_Month)+8,1)","v":"2020-09-01"},{"$f":"SUMIFS(Table_ForecastInput[加权预测],Table_ForecastInput[预测结束],\">=\"&销售额预测!B17,Table_ForecastInput[预测结束],\"<=\"&DATE(YEAR(销售额预测!B17),MONTH(销售额预测!B17)+1,0))","v":{"v":100800,"d":"¥100,800"}},{"v":1321170,"d":"¥1,321,170"},{"$nulls":11},"2020-09-01",{"v":100800,"d":"¥100,800"},{"v":1220370,"d":"¥1,220,370"}]
[null,{"$f":"DATE(YEAR(Starting_Month),MONTH(Starting_Month)+9,1)","v":"2020-10-01"},{"$f":"SUMIFS(Table_ForecastInput[加权预测],Table_ForecastInput[预测结束],\">=\"&销售额预测!B18,Table_ForecastInput[预测结束],\"<=\"&DATE(YEAR(销售额预测!B18),MONTH(销售额预测!B18)+1,0))","v":{"v":241850,"d":"¥241,850"}},{"v":1563020,"d":"¥1,563,020"},{"$nulls":11},"2020-10-01",{"v":241850,"d":"¥241,850"},{"v":1321170,"d":"¥1,321,170"}]
[null,{"$f":"DATE(YEAR(Starting_Month),MONTH(Starting_Month)+10,1)","v":"2020-11-01"},{"$f":"SUMIFS(Table_ForecastInput[加权预测],Table_ForecastInput[预测结束],\">=\"&销售额预测!B19,Table_ForecastInput[预测结束],\"<=\"&DATE(YEAR(销售额预测!B19),MONTH(销售额预测!B19)+1,0))","v":{"v":142425,"d":"¥142,425"}},{"v":1705445,"d":"¥1,705,445"},{"$nulls":11},"2020-11-01",{"v":142425,"d":"¥142,425"},{"v":1563020,"d":"¥1,563,020"}]
[null,{"$f":"DATE(YEAR(Starting_Month),MONTH(Starting_Month)+11,1)","v":"2020-12-01"},{"$f":"SUMIFS(Table_ForecastInput[加权预测],Table_ForecastInput[预测结束],\">=\"&销售额预测!B20,Table_ForecastInput[预测结束],\"<=\"&DATE(YEAR(销售额预测!B20),MONTH(销售额预测!B20)+1,0))","v":{"v":243400,"d":"¥243,400"}},{"v":1948845,"d":"¥1,948,845"},{"$nulls":11},"2020-12-01",{"v":243400,"d":"¥243,400"},{"v":1705445,"d":"¥1,705,445"}]

{"sheet":"列表","index":2,"n_rows":21,"n_cols":8,"rows_kept":21}
[null,"列表"]
[]
[null,"销售代理",null,"销售区域",null,"销售类别",null,"销售阶段"]
[null," 销售代理 1",null,"美国 - 东北地区",null,"咨询",null,"已确定需求"]
[null," 销售代理 2",null,"美国 - 东南地区",null,"混合",null,"商机"]
[null," 销售代理 3",null,"美国 - 中北部地区",null,"产品",null,"需求分析"]
[null," 销售代理 4",null,"美国 - 中南部地区",null,"专业服务",null,"已提出解决方案"]
[null," 销售代理 5",null,"美国 - 西北地区",null,"服务",null,"书面建议"]
[{"$nulls":3},"美国 - 西南地区",null,"支持",null,"口头批准"]
[{"$nulls":3},"加拿大 - 东部地区",null,"培训",null,"正式批准"]
[{"$nulls":3},"加拿大 - 西部地区",{"$nulls":3},"预算已验证"]
[{"$nulls":3},"EMEA - 法国",{"$nulls":3},"赞助"]
[{"$nulls":3},"EMEA - 德国"]
[{"$nulls":3},"EMEA - 意大利"]
[{"$nulls":3},"EMEA - 其他"]
[{"$nulls":3},"APSA - 亚洲"]
[{"$nulls":3},"APSA - 太平洋地区"]
[{"$nulls":3},"APSA - 墨西哥"]
[{"$nulls":3},"APSA - 澳大利亚"]
[{"$nulls":3},"APSA - 其他"]
[{"$nulls":3},"EMEA - 英国"]