{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Prognose-invoer","Verkoopprognose","Lijsten"],"not_rendered":{"charts":1,"images":4,"external_links":2,"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"Prognose-invoer","index":0,"n_rows":29,"n_cols":11,"rows_kept":29}
[{"$nulls":10}," "]
[null,"HLP Manufacturing INC"]
[null,"Verkoopprognose"]
[null,"Vertrouwelijk"]
[]
[null,"Naam verkoopkans","Verkoop \nverzekeringsagent","Verkoop \nregio","Verkoop \ncategorie","Prognosebedrag","Verkoop fase","Kans op verkoop","Prognose \nsluiten","Gewogen prognose"]
[null,"Adatum Corporation","Rowan Murphy","US - Northeast","Consulting",{"v":150000,"d":"€ 150,000"},"Formele goedkeuring",{"v":0.9,"d":"90%"},{"$f":"DATE(YEAR(TODAY())+1,1,1)","v":"2025-01-01"},{"$f":"Tabel_PrognoseInvoer[[#This Row],[Prognosebedrag]]*Tabel_PrognoseInvoer[[#This Row],[Kans op verkoop]]","v":{"v":135000,"d":"€ 135,000"}}]
[null,"Adventure Works","Miho Kojima","US - Southeast","Producten",{"v":145200,"d":"€ 145,200"},"Verkoopkans",{"v":0.1,"d":"10%"},{"$f":"DATE(YEAR(TODAY())+1,2,1)","v":"2025-02-01"},{"$f":"Tabel_PrognoseInvoer[[#This Row],[Prognosebedrag]]*Tabel_PrognoseInvoer[[#This Row],[Kans op verkoop]]","v":{"v":14520,"d":"€ 14,520"}}]
[null,"Alpine Ski House","Cora Thomas","US - North Central","Training",{"v":162500,"d":"€ 162,500"},"Geïdentificeerde behoefte",{"v":0.2,"d":"20%"},{"$f":"DATE(YEAR(TODAY())+1,3,1)","v":"2025-03-01"},{"$f":"Tabel_PrognoseInvoer[[#This Row],[Prognosebedrag]]*Tabel_PrognoseInvoer[[#This Row],[Kans op verkoop]]","v":{"v":32500,"d":"€ 32,500"}}]
[null,"Baldwin Museum of Science","Ellis Turner","US - South Central","Mix",{"v":147500,"d":"€ 147,500"},"Sponsor",{"v":0.3,"d":"30%"},{"$f":"DATE(YEAR(TODAY())+1,4,1)","v":"2025-04-01"},{"$f":"Tabel_PrognoseInvoer[[#This Row],[Prognosebedrag]]*Tabel_PrognoseInvoer[[#This Row],[Kans op verkoop]]","v":{"v":44250,"d":"€ 44,250"}}]
[null,"Blue Yonder Airlines","Suma Kini","US - Northwest","Prof. Diensten",{"v":148000,"d":"€ 148,000"},"Gevalideerd budget",{"v":0.4,"d":"40%"},{"$f":"DATE(YEAR(TODAY())+1,5,1)","v":"2025-05-01"},{"$f":"Tabel_PrognoseInvoer[[#This Row],[Prognosebedrag]]*Tabel_PrognoseInvoer[[#This Row],[Kans op verkoop]]","v":{"v":59200,"d":"€ 59,200"}}]
[null,"City Power & Light","Rowan Murphy","US - Southwest","Ondersteuning",{"v":175000,"d":"€ 175,000"},"Behoefte-analyse",{"v":0.5,"d":"50%"},{"$f":"DATE(YEAR(TODAY())+1,6,1)","v":"2025-06-01"},{"$f":"Tabel_PrognoseInvoer[[#This Row],[Prognosebedrag]]*Tabel_PrognoseInvoer[[#This Row],[Kans op verkoop]]","v":{"v":87500,"d":"€ 87,500"}}]
[null,"Coho Vineyard","Cora Thomas","Canada - Oost","Mix",{"v":149000,"d":"€ 149,000"},"Voorgestelde oplossing",{"v":0.6,"d":"60%"},{"$f":"DATE(YEAR(TODAY())+1,7,1)","v":"2025-07-01"},{"$f":"Tabel_PrognoseInvoer[[#This Row],[Prognosebedrag]]*Tabel_PrognoseInvoer[[#This Row],[Kans op verkoop]]","v":{"v":89400,"d":"€ 89,400"}}]
[null,"Coho Winery","Suma Kini","Canada - West","Training",{"v":142000,"d":"€ 142,000"},"Schriftelijk voorstel",{"v":0.7,"d":"70%"},{"$f":"DATE(YEAR(TODAY())+1,8,1)","v":"2025-08-01"},{"$f":"Tabel_PrognoseInvoer[[#This Row],[Prognosebedrag]]*Tabel_PrognoseInvoer[[#This Row],[Kans op verkoop]]","v":{"v":99400,"d":"€ 99,400"}}]
[null,"Contoso, Ltd.","Cora Thomas","EMEA - Frankrijk","Mix",{"v":172500,"d":"€ 172,500"},"Verbale goedkeuring",{"v":0.9,"d":"90%"},{"$f":"DATE(YEAR(TODAY())+1,10,1)","v":"2025-10-01"},{"$f":"Tabel_PrognoseInvoer[[#This Row],[Prognosebedrag]]*Tabel_PrognoseInvoer[[#This Row],[Kans op verkoop]]","v":{"v":155250,"d":"€ 155,250"}}]
[null,"Contoso Pharmaceuticals","Ellis Turner","EMEA - Duitsland","Producten",{"v":163500,"d":"€ 163,500"},"Sponsor",{"v":0.2,"d":"20%"},{"$f":"DATE(YEAR(TODAY())+1,11,1)","v":"2025-11-01"},{"$f":"Tabel_PrognoseInvoer[[#This Row],[Prognosebedrag]]*Tabel_PrognoseInvoer[[#This Row],[Kans op verkoop]]","v":{"v":32700,"d":"€ 32,700"}}]
[null,"Consolidated Messenger","Suma Kini","EMEA - Italië","Producten",{"v":155500,"d":"€ 155,500"},"Formele goedkeuring",{"v":1,"d":"100%"},{"$f":"DATE(YEAR(TODAY())+1,12,1)","v":"2025-12-01"},{"$f":"Tabel_PrognoseInvoer[[#This Row],[Prognosebedrag]]*Tabel_PrognoseInvoer[[#This Row],[Kans op verkoop]]","v":{"v":155500,"d":"€ 155,500"}}]
[null,"Fabrikam, Inc.","Ellis Turner","EMEA - Overig","Consulting",{"v":166000,"d":"€ 166,000"},"Verkoopkans",{"v":0.1,"d":"10%"},{"$f":"DATE(YEAR(TODAY())+1,1,1)","v":"2025-01-01"},{"$f":"Tabel_PrognoseInvoer[[#This Row],[Prognosebedrag]]*Tabel_PrognoseInvoer[[#This Row],[Kans op verkoop]]","v":{"v":16600,"d":"€ 16,600"}}]
[null,"Fourth Coffee","Cora Thomas","APSA - Azië","Training",{"v":180000,"d":"€ 180,000"},"Gevalideerd budget",{"v":0.3,"d":"30%"},{"$f":"DATE(YEAR(TODAY())+1,3,1)","v":"2025-03-01"},{"$f":"Tabel_PrognoseInvoer[[#This Row],[Prognosebedrag]]*Tabel_PrognoseInvoer[[#This Row],[Kans op verkoop]]","v":{"v":54000,"d":"€ 54,000"}}]
[null,"Graphic Design Institute","Miho Kojima","APSA - Pacific","Diensten",{"v":140000,"d":"€ 140,000"},"Voorgestelde oplossing",{"v":0.6,"d":"60%"},{"$f":"DATE(YEAR(TODAY())+1,5,1)","v":"2025-05-01"},{"$f":"Tabel_PrognoseInvoer[[#This Row],[Prognosebedrag]]*Tabel_PrognoseInvoer[[#This Row],[Kans op verkoop]]","v":{"v":84000,"d":"€ 84,000"}}]
[null,"Humongous Insurance","Rowan Murphy","APSA - Mexico","Ondersteuning",{"v":155000,"d":"€ 155,000"},"Sponsor",{"v":0.3,"d":"30%"},{"$f":"DATE(YEAR(TODAY())+1,6,1)","v":"2025-06-01"},{"$f":"Tabel_PrognoseInvoer[[#This Row],[Prognosebedrag]]*Tabel_PrognoseInvoer[[#This Row],[Kans op verkoop]]","v":{"v":46500,"d":"€ 46,500"}}]
[null,"Litware, Inc.","Miho Kojima","APSA - Australië","Prof. Diensten",{"v":173200,"d":"€ 173,200"},"Behoefte-analyse",{"v":0.5,"d":"50%"},{"$f":"DATE(YEAR(TODAY())+1,10,1)","v":"2025-10-01"},{"$f":"Tabel_PrognoseInvoer[[#This Row],[Prognosebedrag]]*Tabel_PrognoseInvoer[[#This Row],[Kans op verkoop]]","v":{"v":86600,"d":"€ 86,600"}}]
[null,"Lucerne Publishing","Suma Kini","APSA - Overig","Services",{"v":146500,"d":"€ 146,500"},"Voorgestelde oplossing",{"v":0.6,"d":"60%"},{"$f":"DATE(YEAR(TODAY())+1,12,1)","v":"2025-12-01"},{"$f":"Tabel_PrognoseInvoer[[#This Row],[Prognosebedrag]]*Tabel_PrognoseInvoer[[#This Row],[Kans op verkoop]]","v":{"v":87900,"d":"€ 87,900"}}]
[null,"Maria Reizen","Ellis Turner","US - Northeast","Ondersteuning",{"v":156750,"d":"€ 156,750"},"Schriftelijk voorstel",{"v":0.7,"d":"70%"},{"$f":"DATE(YEAR(TODAY())+1,11,1)","v":"2025-11-01"},{"$f":"Tabel_PrognoseInvoer[[#This Row],[Prognosebedrag]]*Tabel_PrognoseInvoer[[#This Row],[Kans op verkoop]]","v":{"v":109725,"d":"€ 109,725"}}]
[null,"Northwind Handelsonderneming","Cora Thomas","US - South Central","Prof. Diensten",{"v":162000,"d":"€ 162,000"},"Verbale goedkeuring",{"v":0.9,"d":"90%"},{"$f":"DATE(YEAR(TODAY())+1,2,1)","v":"2025-02-01"},{"$f":"Tabel_PrognoseInvoer[[#This Row],[Prognosebedrag]]*Tabel_PrognoseInvoer[[#This Row],[Kans op verkoop]]","v":{"v":145800,"d":"€ 145,800"}}]
[null,"Proseware, Inc.","Ellis Turner","Canada - Oost","Mix",{"v":157000,"d":"€ 157,000"},"Formele goedkeuring",{"v":1,"d":"100%"},{"$f":"DATE(YEAR(TODAY())+1,3,1)","v":"2025-03-01"},{"$f":"Tabel_PrognoseInvoer[[#This Row],[Prognosebedrag]]*Tabel_PrognoseInvoer[[#This Row],[Kans op verkoop]]","v":{"v":157000,"d":"€ 157,000"}}]
[null,"De Kunstacademie","Miho Kojima","EMEA - Frankrijk","Diensten",{"v":173000,"d":"€ 173,000"},"Gevalideerd budget",{"v":0.4,"d":"40%"},{"$f":"DATE(YEAR(TODAY())+1,4,1)","v":"2025-04-01"},{"$f":"Tabel_PrognoseInvoer[[#This Row],[Prognosebedrag]]*Tabel_PrognoseInvoer[[#This Row],[Kans op verkoop]]","v":{"v":69200,"d":"€ 69,200"}}]
[null,"Video Zuiderlaan","Suma Kini","EMEA - Engeland","Mix",{"v":171000,"d":"€ 171,000"},"Behoefte-analyse",{"v":0.5,"d":"50%"},{"$f":"DATE(YEAR(TODAY())+1,8,1)","v":"2025-08-01"},{"$f":"Tabel_PrognoseInvoer[[#This Row],[Prognosebedrag]]*Tabel_PrognoseInvoer[[#This Row],[Kans op verkoop]]","v":{"v":85500,"d":"€ 85,500"}}]
[null,"Tailspin Toys","Rowan Murphy","APSA - Australië","Producten",{"v":168000,"d":"€ 168,000"},"Voorgestelde oplossing",{"v":0.6,"d":"60%"},{"$f":"DATE(YEAR(TODAY())+1,9,1)","v":"2025-09-01"},{"$f":"Tabel_PrognoseInvoer[[#This Row],[Prognosebedrag]]*Tabel_PrognoseInvoer[[#This Row],[Kans op verkoop]]","v":{"v":100800,"d":"€ 100,800"}}]

{"sheet":"Verkoopprognose","index":1,"n_rows":19,"n_cols":18,"rows_kept":19}
[{"$nulls":14}," "]
[null,{"$f":"Bedrijfsnaam","v":"HLP Manufacturing INC"}]
[null,"Voorspellingsgrafiek"]
[null,"Vertrouwelijk"]
[null,"Beginmaand",{"$f":"DATE(YEAR(TODAY())+1,1,1)","v":"2025-01-01"}]
[null,"Maand","Maandelijks prognose","Cumulatief",{"$nulls":11},{"$f":"B6","v":"Maand"},"Maandelijkse prognose","Cumulatief"]
[null,{"$f":"DATE(YEAR(Beginmaand),MONTH(Beginmaand)+0,1)","v":"2025-01-01"},{"$f":"SUMIFS(Tabel_PrognoseInvoer[Gewogen prognose],Tabel_PrognoseInvoer[Prognose \nsluiten],\">=\"&Verkoopprognose!B7,Tabel_PrognoseInvoer[Prognose \nsluiten],\"<=\"&DATE(YEAR(Verkoopprognose!B7),MONTH(Verkoopprognose!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(Beginmaand),MONTH(Beginmaand)+1,1)","v":"2025-02-01"},{"$f":"SUMIFS(Tabel_PrognoseInvoer[Gewogen prognose],Tabel_PrognoseInvoer[Prognose \nsluiten],\">=\"&Verkoopprognose!B8,Tabel_PrognoseInvoer[Prognose \nsluiten],\"<=\"&DATE(YEAR(Verkoopprognose!B8),MONTH(Verkoopprognose!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(Beginmaand),MONTH(Beginmaand)+2,1)","v":"2025-03-01"},{"$f":"SUMIFS(Tabel_PrognoseInvoer[Gewogen prognose],Tabel_PrognoseInvoer[Prognose \nsluiten],\">=\"&Verkoopprognose!B9,Tabel_PrognoseInvoer[Prognose \nsluiten],\"<=\"&DATE(YEAR(Verkoopprognose!B9),MONTH(Verkoopprognose!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(Beginmaand),MONTH(Beginmaand)+3,1)","v":"2025-04-01"},{"$f":"SUMIFS(Tabel_PrognoseInvoer[Gewogen prognose],Tabel_PrognoseInvoer[Prognose \nsluiten],\">=\"&Verkoopprognose!B10,Tabel_PrognoseInvoer[Prognose \nsluiten],\"<=\"&DATE(YEAR(Verkoopprognose!B10),MONTH(Verkoopprognose!B10)+1,0))","v":{"v":113450,"d":"€ 113,450"}},{"$f":"IF(ISNUMBER(D9),D9+C10,C10)","v":{"v":668870,"d":"€ 668,870"}},{"$nulls":11},{"$f":"B10","v":"2025-04-01"},{"$f":"C10","v":{"v":113450,"d":"€ 113,450"}},{"$f":"D10-C10","v":{"v":555420,"d":"€ 555,420"}}]
[null,{"$f":"DATE(YEAR(Beginmaand),MONTH(Beginmaand)+4,1)","v":"2025-05-01"},{"$f":"SUMIFS(Tabel_PrognoseInvoer[Gewogen prognose],Tabel_PrognoseInvoer[Prognose \nsluiten],\">=\"&Verkoopprognose!B11,Tabel_PrognoseInvoer[Prognose \nsluiten],\"<=\"&DATE(YEAR(Verkoopprognose!B11),MONTH(Verkoopprognose!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(Beginmaand),MONTH(Beginmaand)+5,1)","v":"2025-06-01"},{"$f":"SUMIFS(Tabel_PrognoseInvoer[Gewogen prognose],Tabel_PrognoseInvoer[Prognose \nsluiten],\">=\"&Verkoopprognose!B12,Tabel_PrognoseInvoer[Prognose \nsluiten],\"<=\"&DATE(YEAR(Verkoopprognose!B12),MONTH(Verkoopprognose!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(Beginmaand),MONTH(Beginmaand)+6,1)","v":"2025-07-01"},{"$f":"SUMIFS(Tabel_PrognoseInvoer[Gewogen prognose],Tabel_PrognoseInvoer[Prognose \nsluiten],\">=\"&Verkoopprognose!B13,Tabel_PrognoseInvoer[Prognose \nsluiten],\"<=\"&DATE(YEAR(Verkoopprognose!B13),MONTH(Verkoopprognose!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(Beginmaand),MONTH(Beginmaand)+7,1)","v":"2025-08-01"},{"$f":"SUMIFS(Tabel_PrognoseInvoer[Gewogen prognose],Tabel_PrognoseInvoer[Prognose \nsluiten],\">=\"&Verkoopprognose!B14,Tabel_PrognoseInvoer[Prognose \nsluiten],\"<=\"&DATE(YEAR(Verkoopprognose!B14),MONTH(Verkoopprognose!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(Beginmaand),MONTH(Beginmaand)+8,1)","v":"2025-09-01"},{"$f":"SUMIFS(Tabel_PrognoseInvoer[Gewogen prognose],Tabel_PrognoseInvoer[Prognose \nsluiten],\">=\"&Verkoopprognose!B15,Tabel_PrognoseInvoer[Prognose \nsluiten],\"<=\"&DATE(YEAR(Verkoopprognose!B15),MONTH(Verkoopprognose!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(Beginmaand),MONTH(Beginmaand)+9,1)","v":"2025-10-01"},{"$f":"SUMIFS(Tabel_PrognoseInvoer[Gewogen prognose],Tabel_PrognoseInvoer[Prognose \nsluiten],\">=\"&Verkoopprognose!B16,Tabel_PrognoseInvoer[Prognose \nsluiten],\"<=\"&DATE(YEAR(Verkoopprognose!B16),MONTH(Verkoopprognose!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(Beginmaand),MONTH(Beginmaand)+10,1)","v":"2025-11-01"},{"$f":"SUMIFS(Tabel_PrognoseInvoer[Gewogen prognose],Tabel_PrognoseInvoer[Prognose \nsluiten],\">=\"&Verkoopprognose!B17,Tabel_PrognoseInvoer[Prognose \nsluiten],\"<=\"&DATE(YEAR(Verkoopprognose!B17),MONTH(Verkoopprognose!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(Beginmaand),MONTH(Beginmaand)+11,1)","v":"2025-12-01"},{"$f":"SUMIFS(Tabel_PrognoseInvoer[Gewogen prognose],Tabel_PrognoseInvoer[Prognose \nsluiten],\">=\"&Verkoopprognose!B18,Tabel_PrognoseInvoer[Prognose \nsluiten],\"<=\"&DATE(YEAR(Verkoopprognose!B18),MONTH(Verkoopprognose!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":"Lijsten","index":2,"n_rows":24,"n_cols":5,"rows_kept":24}
[]
[null,{"$f":"Bedrijfsnaam","v":"HLP Manufacturing INC"}]
[null,"Verkooplijsten"]
[null,"Vertrouwelijk"]
[]
[null,"Verkoopmedewerkers","Verkoopregio's","Verkoopcategorieën","Verkoopfasen"]
[null,"Rowan Murphy","US - Northeast","Consulting","Geïdentificeerde behoefte"]
[null,"Miho Kojima","US - Southeast","Mix","Verkoopkans"]
[null,"Cora Thomas","US - North Central","Producten","Behoefte-analyse"]
[null,"Ellis Turner","US - South Central","Prof. Diensten","Voorgestelde oplossing"]
[null,"Suma Kini","US - Northwest","Services","Schriftelijk voorstel"]
[null,null,"US - Southwest","Ondersteuning","Verbale goedkeuring"]
[null,null,"Canada - Oost","Training","Formele goedkeuring"]
[null,null,"Canada - West",null,"Gevalideerd budget"]
[null,null,"EMEA - Frankrijk",null,"Sponsor"]
[null,null,"EMEA - Duitsland"]
[null,null,"EMEA - Italië"]
[null,null,"EMEA - Overig"]
[null,null,"APSA - Azië"]
[null,null,"APSA - Pacific"]
[null,null,"APSA - Mexico"]
[null,null,"APSA - Australië"]
[null,null,"APSA - Overig"]
[null,null,"EMEA - Engeland"]