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

{"sheet":"Forecast input","index":0,"n_rows":29,"n_cols":11,"rows_kept":29}
[{"$nulls":10}," "]
[null,"HLP Manufacturing INC"]
[null,"Sales forecast"]
[null,"Confidential"]
[]
[null,"Opportunity name","Sales \nagent","Sales \nregion","Sales \ncategory","Forecast amount","Sales \nphase","Probability of sale","Forecast \nclose","Weighted forecast"]
[null,"Adatum Corporation","Rowan Murphy","US - Northeast","Consulting",{"v":150000,"d":"$150,000"},"Formal approval",{"v":0.9,"d":"90%"},{"$f":"DATE(YEAR(TODAY())+1,1,1)","v":"2024-01-01"},{"$f":"Table_ForecastInput[[#This Row],[Forecast amount]]*Table_ForecastInput[[#This Row],[Probability of sale]]","v":{"v":135000,"d":"$135,000"}}]
[null,"Adventure Works","Miho Kojima","US - Southeast","Products",{"v":145200,"d":"$145,200"},"Opportunity",{"v":0.1,"d":"10%"},{"$f":"DATE(YEAR(TODAY())+1,2,1)","v":"2024-02-01"},{"$f":"Table_ForecastInput[[#This Row],[Forecast amount]]*Table_ForecastInput[[#This Row],[Probability of sale]]","v":{"v":14520,"d":"$14,520"}}]
[null,"Alpine Ski House","Cora Thomas","US - North Central","Training",{"v":162500,"d":"$162,500"},"Identified need",{"v":0.2,"d":"20%"},{"$f":"DATE(YEAR(TODAY())+1,3,1)","v":"2024-03-01"},{"$f":"Table_ForecastInput[[#This Row],[Forecast amount]]*Table_ForecastInput[[#This Row],[Probability of sale]]","v":{"v":32500,"d":"$32,500"}}]
[null,"Baldwin Museum of Science","Ellis Turner","US - South Central","Mixture",{"v":147500,"d":"$147,500"},"Sponsorship",{"v":0.3,"d":"30%"},{"$f":"DATE(YEAR(TODAY())+1,4,1)","v":"2024-04-01"},{"$f":"Table_ForecastInput[[#This Row],[Forecast amount]]*Table_ForecastInput[[#This Row],[Probability of sale]]","v":{"v":44250,"d":"$44,250"}}]
[null,"Blue Yonder Airlines","Suma Kini","US - Northwest","Prof. services",{"v":148000,"d":"$148,000"},"Budget validated",{"v":0.4,"d":"40%"},{"$f":"DATE(YEAR(TODAY())+1,5,1)","v":"2024-05-01"},{"$f":"Table_ForecastInput[[#This Row],[Forecast amount]]*Table_ForecastInput[[#This Row],[Probability of sale]]","v":{"v":59200,"d":"$59,200"}}]
[null,"City Power & Light","Rowan Murphy","US - Southwest","Support",{"v":175000,"d":"$175,000"},"Needs analysis",{"v":0.5,"d":"50%"},{"$f":"DATE(YEAR(TODAY())+1,6,1)","v":"2024-06-01"},{"$f":"Table_ForecastInput[[#This Row],[Forecast amount]]*Table_ForecastInput[[#This Row],[Probability of sale]]","v":{"v":87500,"d":"$87,500"}}]
[null,"Coho Vineyard","Cora Thomas","Canada - East","Mixture",{"v":149000,"d":"$149,000"},"Solution proposed",{"v":0.6,"d":"60%"},{"$f":"DATE(YEAR(TODAY())+1,7,1)","v":"2024-07-01"},{"$f":"Table_ForecastInput[[#This Row],[Forecast amount]]*Table_ForecastInput[[#This Row],[Probability of sale]]","v":{"v":89400,"d":"$89,400"}}]
[null,"Coho Winery","Suma Kini","Canada - West","Training",{"v":142000,"d":"$142,000"},"Written proposal",{"v":0.7,"d":"70%"},{"$f":"DATE(YEAR(TODAY())+1,8,1)","v":"2024-08-01"},{"$f":"Table_ForecastInput[[#This Row],[Forecast amount]]*Table_ForecastInput[[#This Row],[Probability of sale]]","v":{"v":99400,"d":"$99,400"}}]
[null,"Contoso, Ltd.","Cora Thomas","EMEA - France","Mixture",{"v":172500,"d":"$172,500"},"Verbal approval",{"v":0.9,"d":"90%"},{"$f":"DATE(YEAR(TODAY())+1,10,1)","v":"2024-10-01"},{"$f":"Table_ForecastInput[[#This Row],[Forecast amount]]*Table_ForecastInput[[#This Row],[Probability of sale]]","v":{"v":155250,"d":"$155,250"}}]
[null,"Contoso Pharmaceuticals","Ellis Turner","EMEA - Germany","Products",{"v":163500,"d":"$163,500"},"Sponsorship",{"v":0.2,"d":"20%"},{"$f":"DATE(YEAR(TODAY())+1,11,1)","v":"2024-11-01"},{"$f":"Table_ForecastInput[[#This Row],[Forecast amount]]*Table_ForecastInput[[#This Row],[Probability of sale]]","v":{"v":32700,"d":"$32,700"}}]
[null,"Consolidated Messenger","Suma Kini","EMEA - Italy","Products",{"v":155500,"d":"$155,500"},"Formal approval",{"v":1,"d":"100%"},{"$f":"DATE(YEAR(TODAY())+1,12,1)","v":"2024-12-01"},{"$f":"Table_ForecastInput[[#This Row],[Forecast amount]]*Table_ForecastInput[[#This Row],[Probability of sale]]","v":{"v":155500,"d":"$155,500"}}]
[null,"Fabrikam, Inc.","Ellis Turner","EMEA - Other","Consulting",{"v":166000,"d":"$166,000"},"Opportunity",{"v":0.1,"d":"10%"},{"$f":"DATE(YEAR(TODAY())+1,1,1)","v":"2024-01-01"},{"$f":"Table_ForecastInput[[#This Row],[Forecast amount]]*Table_ForecastInput[[#This Row],[Probability of sale]]","v":{"v":16600,"d":"$16,600"}}]
[null,"Fourth Coffee","Cora Thomas","APSA - Asia","Training",{"v":180000,"d":"$180,000"},"Budget validated",{"v":0.3,"d":"30%"},{"$f":"DATE(YEAR(TODAY())+1,3,1)","v":"2024-03-01"},{"$f":"Table_ForecastInput[[#This Row],[Forecast amount]]*Table_ForecastInput[[#This Row],[Probability of sale]]","v":{"v":54000,"d":"$54,000"}}]
[null,"Graphic Design Institute","Miho Kojima","APSA - Pacific","Services",{"v":140000,"d":"$140,000"},"Solution proposed",{"v":0.6,"d":"60%"},{"$f":"DATE(YEAR(TODAY())+1,5,1)","v":"2024-05-01"},{"$f":"Table_ForecastInput[[#This Row],[Forecast amount]]*Table_ForecastInput[[#This Row],[Probability of sale]]","v":{"v":84000,"d":"$84,000"}}]
[null,"Humongous Insurance","Rowan Murphy","APSA - Mexico","Support",{"v":155000,"d":"$155,000"},"Sponsorship",{"v":0.3,"d":"30%"},{"$f":"DATE(YEAR(TODAY())+1,6,1)","v":"2024-06-01"},{"$f":"Table_ForecastInput[[#This Row],[Forecast amount]]*Table_ForecastInput[[#This Row],[Probability of sale]]","v":{"v":46500,"d":"$46,500"}}]
[null,"Litware, Inc.","Miho Kojima","APSA - Australia","Prof. services",{"v":173200,"d":"$173,200"},"Needs analysis",{"v":0.5,"d":"50%"},{"$f":"DATE(YEAR(TODAY())+1,10,1)","v":"2024-10-01"},{"$f":"Table_ForecastInput[[#This Row],[Forecast amount]]*Table_ForecastInput[[#This Row],[Probability of sale]]","v":{"v":86600,"d":"$86,600"}}]
[null,"Lucerne Publishing","Suma Kini","APSA - Other","Services",{"v":146500,"d":"$146,500"},"Solution proposed",{"v":0.6,"d":"60%"},{"$f":"DATE(YEAR(TODAY())+1,12,1)","v":"2024-12-01"},{"$f":"Table_ForecastInput[[#This Row],[Forecast amount]]*Table_ForecastInput[[#This Row],[Probability of sale]]","v":{"v":87900,"d":"$87,900"}}]
[null,"Margie's Travel","Ellis Turner","US - Northeast","Support",{"v":156750,"d":"$156,750"},"Written proposal",{"v":0.7,"d":"70%"},{"$f":"DATE(YEAR(TODAY())+1,11,1)","v":"2024-11-01"},{"$f":"Table_ForecastInput[[#This Row],[Forecast amount]]*Table_ForecastInput[[#This Row],[Probability of sale]]","v":{"v":109725,"d":"$109,725"}}]
[null,"Northwind Traders","Cora Thomas","US - South Central","Prof. Services",{"v":162000,"d":"$162,000"},"Verbal approval",{"v":0.9,"d":"90%"},{"$f":"DATE(YEAR(TODAY())+1,2,1)","v":"2024-02-01"},{"$f":"Table_ForecastInput[[#This Row],[Forecast amount]]*Table_ForecastInput[[#This Row],[Probability of sale]]","v":{"v":145800,"d":"$145,800"}}]
[null,"Proseware, Inc.","Ellis Turner","Canada - East","Mixture",{"v":157000,"d":"$157,000"},"Formal approval",{"v":1,"d":"100%"},{"$f":"DATE(YEAR(TODAY())+1,3,1)","v":"2024-03-01"},{"$f":"Table_ForecastInput[[#This Row],[Forecast amount]]*Table_ForecastInput[[#This Row],[Probability of sale]]","v":{"v":157000,"d":"$157,000"}}]
[null,"School of Fine Art","Miho Kojima","EMEA - France","Services",{"v":173000,"d":"$173,000"},"Budget validated",{"v":0.4,"d":"40%"},{"$f":"DATE(YEAR(TODAY())+1,4,1)","v":"2024-04-01"},{"$f":"Table_ForecastInput[[#This Row],[Forecast amount]]*Table_ForecastInput[[#This Row],[Probability of sale]]","v":{"v":69200,"d":"$69,200"}}]
[null,"Southridge Video","Suma Kini","EMEA - UK","Mixture",{"v":171000,"d":"$171,000"},"Needs analysis",{"v":0.5,"d":"50%"},{"$f":"DATE(YEAR(TODAY())+1,8,1)","v":"2024-08-01"},{"$f":"Table_ForecastInput[[#This Row],[Forecast amount]]*Table_ForecastInput[[#This Row],[Probability of sale]]","v":{"v":85500,"d":"$85,500"}}]
[null,"Tailspin Toys","Rowan Murphy","APSA - Australia","Products",{"v":168000,"d":"$168,000"},"Solution proposed",{"v":0.6,"d":"60%"},{"$f":"DATE(YEAR(TODAY())+1,9,1)","v":"2024-09-01"},{"$f":"Table_ForecastInput[[#This Row],[Forecast amount]]*Table_ForecastInput[[#This Row],[Probability of sale]]","v":{"v":100800,"d":"$100,800"}}]

{"sheet":"Sales forecast","index":1,"n_rows":19,"n_cols":18,"rows_kept":19}
[{"$nulls":14}," "]
[null,{"$f":"CompanyName","v":"HLP Manufacturing INC"}]
[null,"Forecast graph"]
[null,"Confidential"]
[null,"Starting month",{"$f":"DATE(YEAR(TODAY())+1,1,1)","v":"2024-01-01"}]
[null,"Month","Monthly \nforecast","Cumulative",{"$nulls":11},{"$f":"B6","v":"Month"},"Monthly Forecast","Cumulative"]
[null,{"$f":"DATE(YEAR(Starting_Month),MONTH(Starting_Month)+0,1)","v":"2024-01-01"},{"$f":"SUMIFS(Table_ForecastInput[Weighted forecast],Table_ForecastInput[Forecast \nclose],\">=\"&'Sales forecast'!B7,Table_ForecastInput[Forecast \nclose],\"<=\"&DATE(YEAR('Sales forecast'!B7),MONTH('Sales forecast'!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":"2024-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":"2024-02-01"},{"$f":"SUMIFS(Table_ForecastInput[Weighted forecast],Table_ForecastInput[Forecast \nclose],\">=\"&'Sales forecast'!B8,Table_ForecastInput[Forecast \nclose],\"<=\"&DATE(YEAR('Sales forecast'!B8),MONTH('Sales forecast'!B8)+1,0))","v":{"v":160320,"d":"$160,320"}},{"v":311920,"d":"$311,920"},{"$nulls":11},"2024-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":"2024-03-01"},{"$f":"SUMIFS(Table_ForecastInput[Weighted forecast],Table_ForecastInput[Forecast \nclose],\">=\"&'Sales forecast'!B9,Table_ForecastInput[Forecast \nclose],\"<=\"&DATE(YEAR('Sales forecast'!B9),MONTH('Sales forecast'!B9)+1,0))","v":{"v":243500,"d":"$243,500"}},{"v":555420,"d":"$555,420"},{"$nulls":11},"2024-03-01",{"v":243500,"d":"$243,500"},{"v":311920,"d":"$311,920"}]
[null,{"$f":"DATE(YEAR(Starting_Month),MONTH(Starting_Month)+3,1)","v":"2024-04-01"},{"$f":"SUMIFS(Table_ForecastInput[Weighted forecast],Table_ForecastInput[Forecast \nclose],\">=\"&'Sales forecast'!B10,Table_ForecastInput[Forecast \nclose],\"<=\"&DATE(YEAR('Sales forecast'!B10),MONTH('Sales forecast'!B10)+1,0))","v":{"v":113450,"d":"$113,450"}},{"v":668870,"d":"$668,870"},{"$nulls":11},"2024-04-01",{"v":113450,"d":"$113,450"},{"v":555420,"d":"$555,420"}]
[null,{"$f":"DATE(YEAR(Starting_Month),MONTH(Starting_Month)+4,1)","v":"2024-05-01"},{"$f":"SUMIFS(Table_ForecastInput[Weighted forecast],Table_ForecastInput[Forecast \nclose],\">=\"&'Sales forecast'!B11,Table_ForecastInput[Forecast \nclose],\"<=\"&DATE(YEAR('Sales forecast'!B11),MONTH('Sales forecast'!B11)+1,0))","v":{"v":143200,"d":"$143,200"}},{"v":812070,"d":"$812,070"},{"$nulls":11},"2024-05-01",{"v":143200,"d":"$143,200"},{"v":668870,"d":"$668,870"}]
[null,{"$f":"DATE(YEAR(Starting_Month),MONTH(Starting_Month)+5,1)","v":"2024-06-01"},{"$f":"SUMIFS(Table_ForecastInput[Weighted forecast],Table_ForecastInput[Forecast \nclose],\">=\"&'Sales forecast'!B12,Table_ForecastInput[Forecast \nclose],\"<=\"&DATE(YEAR('Sales forecast'!B12),MONTH('Sales forecast'!B12)+1,0))","v":{"v":134000,"d":"$134,000"}},{"v":946070,"d":"$946,070"},{"$nulls":11},"2024-06-01",{"v":134000,"d":"$134,000"},{"v":812070,"d":"$812,070"}]
[null,{"$f":"DATE(YEAR(Starting_Month),MONTH(Starting_Month)+6,1)","v":"2024-07-01"},{"$f":"SUMIFS(Table_ForecastInput[Weighted forecast],Table_ForecastInput[Forecast \nclose],\">=\"&'Sales forecast'!B13,Table_ForecastInput[Forecast \nclose],\"<=\"&DATE(YEAR('Sales forecast'!B13),MONTH('Sales forecast'!B13)+1,0))","v":{"v":89400,"d":"$89,400"}},{"v":1035470,"d":"$1,035,470"},{"$nulls":11},"2024-07-01",{"v":89400,"d":"$89,400"},{"v":946070,"d":"$946,070"}]
[null,{"$f":"DATE(YEAR(Starting_Month),MONTH(Starting_Month)+7,1)","v":"2024-08-01"},{"$f":"SUMIFS(Table_ForecastInput[Weighted forecast],Table_ForecastInput[Forecast \nclose],\">=\"&'Sales forecast'!B14,Table_ForecastInput[Forecast \nclose],\"<=\"&DATE(YEAR('Sales forecast'!B14),MONTH('Sales forecast'!B14)+1,0))","v":{"v":184900,"d":"$184,900"}},{"v":1220370,"d":"$1,220,370"},{"$nulls":11},"2024-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":"2024-09-01"},{"$f":"SUMIFS(Table_ForecastInput[Weighted forecast],Table_ForecastInput[Forecast \nclose],\">=\"&'Sales forecast'!B15,Table_ForecastInput[Forecast \nclose],\"<=\"&DATE(YEAR('Sales forecast'!B15),MONTH('Sales forecast'!B15)+1,0))","v":{"v":100800,"d":"$100,800"}},{"v":1321170,"d":"$1,321,170"},{"$nulls":11},"2024-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":"2024-10-01"},{"$f":"SUMIFS(Table_ForecastInput[Weighted forecast],Table_ForecastInput[Forecast \nclose],\">=\"&'Sales forecast'!B16,Table_ForecastInput[Forecast \nclose],\"<=\"&DATE(YEAR('Sales forecast'!B16),MONTH('Sales forecast'!B16)+1,0))","v":{"v":241850,"d":"$241,850"}},{"v":1563020,"d":"$1,563,020"},{"$nulls":11},"2024-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":"2024-11-01"},{"$f":"SUMIFS(Table_ForecastInput[Weighted forecast],Table_ForecastInput[Forecast \nclose],\">=\"&'Sales forecast'!B17,Table_ForecastInput[Forecast \nclose],\"<=\"&DATE(YEAR('Sales forecast'!B17),MONTH('Sales forecast'!B17)+1,0))","v":{"v":142425,"d":"$142,425"}},{"v":1705445,"d":"$1,705,445"},{"$nulls":11},"2024-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":"2024-12-01"},{"$f":"SUMIFS(Table_ForecastInput[Weighted forecast],Table_ForecastInput[Forecast \nclose],\">=\"&'Sales forecast'!B18,Table_ForecastInput[Forecast \nclose],\"<=\"&DATE(YEAR('Sales forecast'!B18),MONTH('Sales forecast'!B18)+1,0))","v":{"v":243400,"d":"$243,400"}},{"v":1948845,"d":"$1,948,845"},{"$nulls":11},"2024-12-01",{"v":243400,"d":"$243,400"},{"v":1705445,"d":"$1,705,445"}]
[{"$nulls":14}," "]

{"sheet":"Lists","index":2,"n_rows":24,"n_cols":5,"rows_kept":24}
[]
[null,{"$f":"CompanyName","v":"HLP Manufacturing INC"}]
[null,"Sales Lists"]
[null,"Confidential"]
[]
[null,"Sales agents","Sales regions","Sales categories","Sales phases"]
[null,"Rowan Murphy","US - Northeast","Consulting","Identified need"]
[null,"Miho Kojima","US - Southeast","Mixture","Opportunity"]
[null,"Cora Thomas","US - North Central","Products","Needs analysis"]
[null,"Ellis Turner","US - South Central","Prof. services","Solution proposed"]
[null,"Suma Kini","US - Northwest","Services","Written proposal"]
[null,null,"US - Southwest","Support","Verbal approval"]
[null,null,"Canada - East","Training","Formal approval"]
[null,null,"Canada - West",null,"Budget validated"]
[null,null,"EMEA - France",null,"Sponsorship"]
[null,null,"EMEA - Germany"]
[null,null,"EMEA - Italy"]
[null,null,"EMEA - Other"]
[null,null,"APSA - Asia"]
[null,null,"APSA - Pacific"]
[null,null,"APSA - Mexico"]
[null,null,"APSA - Australia"]
[null,null,"APSA - Other"]
[null,null,"EMEA - UK"]