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

{"sheet":"预测输入","index":0,"n_rows":29,"n_cols":11,"rows_kept":29}
[{"$nulls":10}," "]
[null,"HLP Manufacturing INC"]
[null,"销售预测"]
[null,"机密"]
[]
[null,"商机名称","销售\n代理","销售\n区域","销售\n类别","预测金额","销售\n阶段","销售概率","预测\n关闭","加权预测"]
[null,"Adatum Corporation","Rowan Murphy","美国 - 东北地区","咨询",{"v":150000,"d":"¥150,000"},"正式批准",{"v":0.9,"d":"90%"},{"$f":"DATE(YEAR(TODAY())+1,1,1)","v":"2025-01-01"},{"$f":"Table_ForecastInput[[#This Row],[预测金额]]*Table_ForecastInput[[#This Row],[销售概率]]","v":{"v":135000,"d":"¥135,000"}}]
[null,"Adventure Works","Miho Kojima","美国 - 东南地区","产品",{"v":145200,"d":"¥145,200"},"商机",{"v":0.1,"d":"10%"},{"$f":"DATE(YEAR(TODAY())+1,2,1)","v":"2025-02-01"},{"$f":"Table_ForecastInput[[#This Row],[预测金额]]*Table_ForecastInput[[#This Row],[销售概率]]","v":{"v":14520,"d":"¥14,520"}}]
[null,"Alpine Ski House","Cora Thomas","美国 - 中北部地区","培训",{"v":162500,"d":"¥162,500"},"已确定需求",{"v":0.2,"d":"20%"},{"$f":"DATE(YEAR(TODAY())+1,3,1)","v":"2025-03-01"},{"$f":"Table_ForecastInput[[#This Row],[预测金额]]*Table_ForecastInput[[#This Row],[销售概率]]","v":{"v":32500,"d":"¥32,500"}}]
[null,"Baldwin Museum of Science","Ellis Turner","美国 - 中南部地区","混合",{"v":147500,"d":"¥147,500"},"赞助",{"v":0.3,"d":"30%"},{"$f":"DATE(YEAR(TODAY())+1,4,1)","v":"2025-04-01"},{"$f":"Table_ForecastInput[[#This Row],[预测金额]]*Table_ForecastInput[[#This Row],[销售概率]]","v":{"v":44250,"d":"¥44,250"}}]
[null,"Blue Yonder Airlines","Suma Kini","美国 - 西北地区","专业服务",{"v":148000,"d":"¥148,000"},"预算已验证",{"v":0.4,"d":"40%"},{"$f":"DATE(YEAR(TODAY())+1,5,1)","v":"2025-05-01"},{"$f":"Table_ForecastInput[[#This Row],[预测金额]]*Table_ForecastInput[[#This Row],[销售概率]]","v":{"v":59200,"d":"¥59,200"}}]
[null,"City Power & Light","Rowan Murphy","美国 - 西南地区","支持",{"v":175000,"d":"¥175,000"},"需要分析",{"v":0.5,"d":"50%"},{"$f":"DATE(YEAR(TODAY())+1,6,1)","v":"2025-06-01"},{"$f":"Table_ForecastInput[[#This Row],[预测金额]]*Table_ForecastInput[[#This Row],[销售概率]]","v":{"v":87500,"d":"¥87,500"}}]
[null,"Coho Vineyard","Cora Thomas","加拿大 - 东部地区","混合",{"v":149000,"d":"¥149,000"},"已提出解决方案",{"v":0.6,"d":"60%"},{"$f":"DATE(YEAR(TODAY())+1,7,1)","v":"2025-07-01"},{"$f":"Table_ForecastInput[[#This Row],[预测金额]]*Table_ForecastInput[[#This Row],[销售概率]]","v":{"v":89400,"d":"¥89,400"}}]
[null,"Coho Winery","Suma Kini","加拿大 - 西部地区","培训",{"v":142000,"d":"¥142,000"},"书面建议",{"v":0.7,"d":"70%"},{"$f":"DATE(YEAR(TODAY())+1,8,1)","v":"2025-08-01"},{"$f":"Table_ForecastInput[[#This Row],[预测金额]]*Table_ForecastInput[[#This Row],[销售概率]]","v":{"v":99400,"d":"¥99,400"}}]
[null,"Contoso, Ltd.","Cora Thomas","EMEA - 法国","混合",{"v":172500,"d":"¥172,500"},"口头批准",{"v":0.9,"d":"90%"},{"$f":"DATE(YEAR(TODAY())+1,10,1)","v":"2025-10-01"},{"$f":"Table_ForecastInput[[#This Row],[预测金额]]*Table_ForecastInput[[#This Row],[销售概率]]","v":{"v":155250,"d":"¥155,250"}}]
[null,"Contoso Pharmaceuticals","Ellis Turner","EMEA - 德国","产品",{"v":163500,"d":"¥163,500"},"赞助",{"v":0.2,"d":"20%"},{"$f":"DATE(YEAR(TODAY())+1,11,1)","v":"2025-11-01"},{"$f":"Table_ForecastInput[[#This Row],[预测金额]]*Table_ForecastInput[[#This Row],[销售概率]]","v":{"v":32700,"d":"¥32,700"}}]
[null,"Consolidated Messenger","Suma Kini","EMEA - 意大利","产品",{"v":155500,"d":"¥155,500"},"正式批准",{"v":1,"d":"100%"},{"$f":"DATE(YEAR(TODAY())+1,12,1)","v":"2025-12-01"},{"$f":"Table_ForecastInput[[#This Row],[预测金额]]*Table_ForecastInput[[#This Row],[销售概率]]","v":{"v":155500,"d":"¥155,500"}}]
[null,"Fabrikam, Inc.","Ellis Turner","EMEA - 其他","咨询",{"v":166000,"d":"¥166,000"},"商机",{"v":0.1,"d":"10%"},{"$f":"DATE(YEAR(TODAY())+1,1,1)","v":"2025-01-01"},{"$f":"Table_ForecastInput[[#This Row],[预测金额]]*Table_ForecastInput[[#This Row],[销售概率]]","v":{"v":16600,"d":"¥16,600"}}]
[null,"Fourth Coffee","Cora Thomas","APSA - 亚洲","培训",{"v":180000,"d":"¥180,000"},"预算已验证",{"v":0.3,"d":"30%"},{"$f":"DATE(YEAR(TODAY())+1,3,1)","v":"2025-03-01"},{"$f":"Table_ForecastInput[[#This Row],[预测金额]]*Table_ForecastInput[[#This Row],[销售概率]]","v":{"v":54000,"d":"¥54,000"}}]
[null,"Graphic Design Institute","Miho Kojima","APSA - 太平洋地区","服务",{"v":140000,"d":"¥140,000"},"已提出解决方案",{"v":0.6,"d":"60%"},{"$f":"DATE(YEAR(TODAY())+1,5,1)","v":"2025-05-01"},{"$f":"Table_ForecastInput[[#This Row],[预测金额]]*Table_ForecastInput[[#This Row],[销售概率]]","v":{"v":84000,"d":"¥84,000"}}]
[null,"Humongous Insurance","Rowan Murphy","APSA - 墨西哥","支持",{"v":155000,"d":"¥155,000"},"赞助",{"v":0.3,"d":"30%"},{"$f":"DATE(YEAR(TODAY())+1,6,1)","v":"2025-06-01"},{"$f":"Table_ForecastInput[[#This Row],[预测金额]]*Table_ForecastInput[[#This Row],[销售概率]]","v":{"v":46500,"d":"¥46,500"}}]
[null,"Litware, Inc.","Miho Kojima","APSA - 澳大利亚","专业服务",{"v":173200,"d":"¥173,200"},"需要分析",{"v":0.5,"d":"50%"},{"$f":"DATE(YEAR(TODAY())+1,10,1)","v":"2025-10-01"},{"$f":"Table_ForecastInput[[#This Row],[预测金额]]*Table_ForecastInput[[#This Row],[销售概率]]","v":{"v":86600,"d":"¥86,600"}}]
[null,"Lucerne Publishing","Suma Kini","APSA - 其他","服务",{"v":146500,"d":"¥146,500"},"已提出解决方案",{"v":0.6,"d":"60%"},{"$f":"DATE(YEAR(TODAY())+1,12,1)","v":"2025-12-01"},{"$f":"Table_ForecastInput[[#This Row],[预测金额]]*Table_ForecastInput[[#This Row],[销售概率]]","v":{"v":87900,"d":"¥87,900"}}]
[null,"Margie's Travel","Ellis Turner","美国 - 东北地区","支持",{"v":156750,"d":"¥156,750"},"书面建议",{"v":0.7,"d":"70%"},{"$f":"DATE(YEAR(TODAY())+1,11,1)","v":"2025-11-01"},{"$f":"Table_ForecastInput[[#This Row],[预测金额]]*Table_ForecastInput[[#This Row],[销售概率]]","v":{"v":109725,"d":"¥109,725"}}]
[null,"Northwind Traders","Cora Thomas","美国 - 中南部地区","专业服务",{"v":162000,"d":"¥162,000"},"口头批准",{"v":0.9,"d":"90%"},{"$f":"DATE(YEAR(TODAY())+1,2,1)","v":"2025-02-01"},{"$f":"Table_ForecastInput[[#This Row],[预测金额]]*Table_ForecastInput[[#This Row],[销售概率]]","v":{"v":145800,"d":"¥145,800"}}]
[null,"Proseware, Inc.","Ellis Turner","加拿大 - 东部地区","混合",{"v":157000,"d":"¥157,000"},"正式批准",{"v":1,"d":"100%"},{"$f":"DATE(YEAR(TODAY())+1,3,1)","v":"2025-03-01"},{"$f":"Table_ForecastInput[[#This Row],[预测金额]]*Table_ForecastInput[[#This Row],[销售概率]]","v":{"v":157000,"d":"¥157,000"}}]
[null,"School of Fine Art","Miho Kojima","EMEA - 法国","服务",{"v":173000,"d":"¥173,000"},"预算已验证",{"v":0.4,"d":"40%"},{"$f":"DATE(YEAR(TODAY())+1,4,1)","v":"2025-04-01"},{"$f":"Table_ForecastInput[[#This Row],[预测金额]]*Table_ForecastInput[[#This Row],[销售概率]]","v":{"v":69200,"d":"¥69,200"}}]
[null,"Southridge Video","Suma Kini","EMEA - 英国","混合",{"v":171000,"d":"¥171,000"},"需要分析",{"v":0.5,"d":"50%"},{"$f":"DATE(YEAR(TODAY())+1,8,1)","v":"2025-08-01"},{"$f":"Table_ForecastInput[[#This Row],[预测金额]]*Table_ForecastInput[[#This Row],[销售概率]]","v":{"v":85500,"d":"¥85,500"}}]
[null,"Tailspin Toys","Rowan Murphy","APSA - 澳大利亚","产品",{"v":168000,"d":"¥168,000"},"已提出解决方案",{"v":0.6,"d":"60%"},{"$f":"DATE(YEAR(TODAY())+1,9,1)","v":"2025-09-01"},{"$f":"Table_ForecastInput[[#This Row],[预测金额]]*Table_ForecastInput[[#This Row],[销售概率]]","v":{"v":100800,"d":"¥100,800"}}]

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

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