{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Forecast input","Sales forecast","Lists"],"not_rendered":{"charts":1,"images":1,"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Forecast input","index":0,"n_rows":29,"n_cols":11,"rows_kept":29}
[{"$nulls":10}," "]
[null,"Company confidential"]
[null,"Company name"]
[null,"Sales forecast"]
[]
[null,"Opportunity name","Sales Agent","Sales region","Sales category","Forecast amount","Sales phase","Probability of sale","Forecast close","Weighted forecast"]
[null,"Adatum Corporation"," Sales Agent 1","US - Northeast","Consulting",{"v":150000,"d":"£150,000.00"},"Formal approval",{"v":0.9,"d":"90%"},{"$f":"DATE(YEAR(TODAY())+1,1,1)","v":"2020-01-01"},{"v":135000,"d":"£135,000.00"}]
[null,"Adventure Works"," Sales Agent 2","US - Southeast","Products",{"v":145200,"d":"£145,200.00"},"Opportunity",{"v":0.1,"d":"10%"},{"$f":"DATE(YEAR(TODAY())+1,2,1)","v":"2020-02-01"},{"v":14520,"d":"£14,520.00"}]
[null,"Alpine Ski Chalet"," Sales Agent 3","US - North Central","Training",{"v":162500,"d":"£162,500.00"},"Identified need",{"v":0.2,"d":"20%"},{"$f":"DATE(YEAR(TODAY())+1,3,1)","v":"2020-03-01"},{"v":32500,"d":"£32,500.00"}]
[null,"Baldwin Museum of Science"," Sales Agent 4","US - South Central","Mixture",{"v":147500,"d":"£147,500.00"},"Sponsorship",{"v":0.3,"d":"30%"},{"$f":"DATE(YEAR(TODAY())+1,4,1)","v":"2020-04-01"},{"v":44250,"d":"£44,250.00"}]
[null,"Blue Yonder Airlines"," Sales Agent 5","US - Northwest","Prof. services",{"v":148000,"d":"£148,000.00"},"Budget validated",{"v":0.4,"d":"40%"},{"$f":"DATE(YEAR(TODAY())+1,5,1)","v":"2020-05-01"},{"v":59200,"d":"£59,200.00"}]
[null,"City Power & Light"," Sales Agent 1","US - Southwest","Support",{"v":175000,"d":"£175,000.00"},"Needs analysis",{"v":0.5,"d":"50%"},{"$f":"DATE(YEAR(TODAY())+1,6,1)","v":"2020-06-01"},{"v":87500,"d":"£87,500.00"}]
[null,"Coho Vineyard"," Sales Agent 3","Canada - East","Mixture",{"v":149000,"d":"£149,000.00"},"Solution proposed",{"v":0.6,"d":"60%"},{"$f":"DATE(YEAR(TODAY())+1,7,1)","v":"2020-07-01"},{"v":89400,"d":"£89,400.00"}]
[null,"Coho Winery"," Sales Agent 5","Canada - West","Training",{"v":142000,"d":"£142,000.00"},"Written proposal",{"v":0.7,"d":"70%"},{"$f":"DATE(YEAR(TODAY())+1,8,1)","v":"2020-08-01"},{"v":99400,"d":"£99,400.00"}]
[null,"Contoso, Ltd"," Sales Agent 3","EMEA - France","Mixture",{"v":172500,"d":"£172,500.00"},"Verbal approval",{"v":0.9,"d":"90%"},{"$f":"DATE(YEAR(TODAY())+1,10,1)","v":"2020-10-01"},{"v":155250,"d":"£155,250.00"}]
[null,"Contoso pharmaceuticals"," Sales Agent 4","EMEA - Germany","Products",{"v":163500,"d":"£163,500.00"},"Sponsorship",{"v":0.2,"d":"20%"},{"$f":"DATE(YEAR(TODAY())+1,11,1)","v":"2020-11-01"},{"v":32700,"d":"£32,700.00"}]
[null,"Consolidated Messenger"," Sales Agent 5","EMEA - Italy","Products",{"v":155500,"d":"£155,500.00"},"Formal approval",{"v":1,"d":"100%"},{"$f":"DATE(YEAR(TODAY())+1,12,1)","v":"2020-12-01"},{"v":155500,"d":"£155,500.00"}]
[null,"Fabrikam, Inc."," Sales Agent 4","EMEA - Other","Consulting",{"v":166000,"d":"£166,000.00"},"Opportunity",{"v":0.1,"d":"10%"},{"$f":"DATE(YEAR(TODAY())+1,1,1)","v":"2020-01-01"},{"v":16600,"d":"£16,600.00"}]
[null,"Fourth Coffee"," Sales Agent 3","APSA - Asia","Training",{"v":180000,"d":"£180,000.00"},"Budget validated",{"v":0.3,"d":"30%"},{"$f":"DATE(YEAR(TODAY())+1,3,1)","v":"2020-03-01"},{"v":54000,"d":"£54,000.00"}]
[null,"Graphic Design Institute"," Sales Agent 2","APSA - Pacific","Services",{"v":140000,"d":"£140,000.00"},"Solution proposed",{"v":0.6,"d":"60%"},{"$f":"DATE(YEAR(TODAY())+1,5,1)","v":"2020-05-01"},{"v":84000,"d":"£84,000.00"}]
[null,"Humongous Insurance"," Sales Agent 1","APSA - Mexico","Support",{"v":155000,"d":"£155,000.00"},"Sponsorship",{"v":0.3,"d":"30%"},{"$f":"DATE(YEAR(TODAY())+1,6,1)","v":"2020-06-01"},{"v":46500,"d":"£46,500.00"}]
[null,"Litware, Inc."," Sales Agent 2","APSA - Australia","Prof. services",{"v":173200,"d":"£173,200.00"},"Needs analysis",{"v":0.5,"d":"50%"},{"$f":"DATE(YEAR(TODAY())+1,10,1)","v":"2020-10-01"},{"v":86600,"d":"£86,600.00"}]
[null,"Lucerne Publishing"," Sales Agent 5","APSA - Other","Services",{"v":146500,"d":"£146,500.00"},"Solution proposed",{"v":0.6,"d":"60%"},{"$f":"DATE(YEAR(TODAY())+1,12,1)","v":"2020-12-01"},{"v":87900,"d":"£87,900.00"}]
[null,"Zoomis Electronics"," Sales Agent 4","US - Northeast","Support",{"v":156750,"d":"£156,750.00"},"Written proposal",{"v":0.7,"d":"70%"},{"$f":"DATE(YEAR(TODAY())+1,11,1)","v":"2020-11-01"},{"v":109725,"d":"£109,725.00"}]
[null,"Daisychain Toys"," Sales Agent 3","US - South Central","Prof. services",{"v":162000,"d":"£162,000.00"},"Verbal approval",{"v":0.9,"d":"90%"},{"$f":"DATE(YEAR(TODAY())+1,2,1)","v":"2020-02-01"},{"v":145800,"d":"£145,800.00"}]
[null,"Bluetouch Pharmaceuticals Inc."," Sales Agent 4","Canada - East","Mixture",{"v":157000,"d":"£157,000.00"},"Formal approval",{"v":1,"d":"100%"},{"$f":"DATE(YEAR(TODAY())+1,3,1)","v":"2020-03-01"},{"v":157000,"d":"£157,000.00"}]
[null,"School of Fine Art"," Sales Agent 3","EMEA - France","Services",{"v":173000,"d":"£173,000.00"},"Budget validated",{"v":0.4,"d":"40%"},{"$f":"DATE(YEAR(TODAY())+1,4,1)","v":"2020-04-01"},{"v":69200,"d":"£69,200.00"}]
[null,"Southridge Video"," Sales Agent 5","EMEA - UK","Mixture",{"v":171000,"d":"£171,000.00"},"Needs analysis",{"v":0.5,"d":"50%"},{"$f":"DATE(YEAR(TODAY())+1,8,1)","v":"2020-08-01"},{"v":85500,"d":"£85,500.00"}]
[null,"Tailspin Toys"," Sales Agent 1","APSA - Australia","Products",{"v":168000,"d":"£168,000.00"},"Solution proposed",{"v":0.6,"d":"60%"},{"$f":"DATE(YEAR(TODAY())+1,9,1)","v":"2020-09-01"},{"v":100800,"d":"£100,800.00"}]

{"sheet":"Sales forecast","index":1,"n_rows":20,"n_cols":18,"rows_kept":20}
[{"$nulls":10}," "]
[null,"Company confidential"]
[]
[null,"Sales forecast graph"]
[]
[null,"Starting month",{"$f":"DATE(YEAR(TODAY())+1,1,1)","v":"2020-01-01"}]
[]
[null,"Month","Monthly forecast","Cumulative",{"$nulls":11},{"$f":"B8","v":"Month"},"Monthly forecast","Cumulative"]
[null,{"$f":"DATE(YEAR(Starting_Month),MONTH(Starting_Month)+0,1)","v":"2020-01-01"},{"$f":"SUMIFS(Table_ForecastInput[Weighted forecast],Table_ForecastInput[Forecast close],\">=\"&'Sales forecast'!B9,Table_ForecastInput[Forecast close],\"<=\"&DATE(YEAR('Sales forecast'!B9),MONTH('Sales forecast'!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[Weighted forecast],Table_ForecastInput[Forecast close],\">=\"&'Sales forecast'!B10,Table_ForecastInput[Forecast close],\"<=\"&DATE(YEAR('Sales forecast'!B10),MONTH('Sales forecast'!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[Weighted forecast],Table_ForecastInput[Forecast close],\">=\"&'Sales forecast'!B11,Table_ForecastInput[Forecast close],\"<=\"&DATE(YEAR('Sales forecast'!B11),MONTH('Sales forecast'!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[Weighted forecast],Table_ForecastInput[Forecast close],\">=\"&'Sales forecast'!B12,Table_ForecastInput[Forecast close],\"<=\"&DATE(YEAR('Sales forecast'!B12),MONTH('Sales forecast'!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[Weighted forecast],Table_ForecastInput[Forecast close],\">=\"&'Sales forecast'!B13,Table_ForecastInput[Forecast close],\"<=\"&DATE(YEAR('Sales forecast'!B13),MONTH('Sales forecast'!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[Weighted forecast],Table_ForecastInput[Forecast close],\">=\"&'Sales forecast'!B14,Table_ForecastInput[Forecast close],\"<=\"&DATE(YEAR('Sales forecast'!B14),MONTH('Sales forecast'!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[Weighted forecast],Table_ForecastInput[Forecast close],\">=\"&'Sales forecast'!B15,Table_ForecastInput[Forecast close],\"<=\"&DATE(YEAR('Sales forecast'!B15),MONTH('Sales forecast'!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[Weighted forecast],Table_ForecastInput[Forecast close],\">=\"&'Sales forecast'!B16,Table_ForecastInput[Forecast close],\"<=\"&DATE(YEAR('Sales forecast'!B16),MONTH('Sales forecast'!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[Weighted forecast],Table_ForecastInput[Forecast close],\">=\"&'Sales forecast'!B17,Table_ForecastInput[Forecast close],\"<=\"&DATE(YEAR('Sales forecast'!B17),MONTH('Sales forecast'!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[Weighted forecast],Table_ForecastInput[Forecast close],\">=\"&'Sales forecast'!B18,Table_ForecastInput[Forecast close],\"<=\"&DATE(YEAR('Sales forecast'!B18),MONTH('Sales forecast'!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[Weighted forecast],Table_ForecastInput[Forecast close],\">=\"&'Sales forecast'!B19,Table_ForecastInput[Forecast close],\"<=\"&DATE(YEAR('Sales forecast'!B19),MONTH('Sales forecast'!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[Weighted forecast],Table_ForecastInput[Forecast close],\">=\"&'Sales forecast'!B20,Table_ForecastInput[Forecast close],\"<=\"&DATE(YEAR('Sales forecast'!B20),MONTH('Sales forecast'!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":"Lists","index":2,"n_rows":21,"n_cols":8,"rows_kept":21}
[null,"Lists"]
[]
[null,"Sales agents",null,"Sales regions",null,"Sales categories",null,"Sales phases"]
[null," Sales Agent 1",null,"US - Northeast",null,"Consulting",null,"Identified need"]
[null," Sales Agent 2",null,"US - Southeast",null,"Mixture",null,"Opportunity"]
[null," Sales Agent 3",null,"US - North Central",null,"Products",null,"Needs analysis"]
[null," Sales Agent 4",null,"US - South Central",null,"Prof. services",null,"Solution proposed"]
[null," Sales Agent 5",null,"US - Northwest",null,"Services",null,"Written proposal"]
[{"$nulls":3},"US - Southwest",null,"Support",null,"Verbal approval"]
[{"$nulls":3},"Canada - East",null,"Training",null,"Formal approval"]
[{"$nulls":3},"Canada - West",{"$nulls":3},"Budget validated"]
[{"$nulls":3},"EMEA - France",{"$nulls":3},"Sponsorship"]
[{"$nulls":3},"EMEA - Germany"]
[{"$nulls":3},"EMEA - Italy"]
[{"$nulls":3},"EMEA - Other"]
[{"$nulls":3},"APSA - Asia"]
[{"$nulls":3},"APSA - Pacific"]
[{"$nulls":3},"APSA - Mexico"]
[{"$nulls":3},"APSA - Australia"]
[{"$nulls":3},"APSA - Other"]
[{"$nulls":3},"EMEA - UK"]