{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Prognoseeingabe","Umsatzprognose","Listen"],"not_rendered":{"charts":1,"images":4,"external_links":2,"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"Prognoseeingabe","index":0,"n_rows":29,"n_cols":11,"rows_kept":29}
[{"$nulls":10}," "]
[null,"HLP Manufacturing INC"]
[null,"Umsatzprognose"]
[null,"Vertraulich"]
[]
[null,"Verkaufschancenname","Verkauf \nAgent","Verkauf \nRegion","Verkauf \nKategorie","Vorhersagebetrag","Verkauf \nPhase","Wahrscheinlichkeit des Verkaufs","Prognose \nschließen","Gewichtete Prognose"]
[null,"Adatum Corporation","Rowan Murphy","USA – Nordosten","Consulting",{"v":150000,"d":"150,000 €"},"Formale Genehmigung",{"v":0.9,"d":"90%"},{"$f":"DATE(YEAR(TODAY())+1,1,1)","v":"2025-01-01"},{"$f":"Table_ForecastInput[[#This Row],[Vorhersagebetrag]]*Table_ForecastInput[[#This Row],[Wahrscheinlichkeit des Verkaufs]]","v":{"v":135000,"d":"135,000 €"}}]
[null,"Adventure Works","Miho Kojima","USA – Südosten","Produkte",{"v":145200,"d":"145,200 €"},"Verkaufschance",{"v":0.1,"d":"10%"},{"$f":"DATE(YEAR(TODAY())+1,2,1)","v":"2025-02-01"},{"$f":"Table_ForecastInput[[#This Row],[Vorhersagebetrag]]*Table_ForecastInput[[#This Row],[Wahrscheinlichkeit des Verkaufs]]","v":{"v":14520,"d":"14,520 €"}}]
[null,"Alpine Ski House","Cora Thomas","USA – zentraler Norden","Schulung",{"v":162500,"d":"162,500 €"},"Identifizierter Bedarf",{"v":0.2,"d":"20%"},{"$f":"DATE(YEAR(TODAY())+1,3,1)","v":"2025-03-01"},{"$f":"Table_ForecastInput[[#This Row],[Vorhersagebetrag]]*Table_ForecastInput[[#This Row],[Wahrscheinlichkeit des Verkaufs]]","v":{"v":32500,"d":"32,500 €"}}]
[null,"Baldwin Museum of Science","Ellis-Turner","USA – zentraler Süden","Mischung",{"v":147500,"d":"147,500 €"},"Sponsoring",{"v":0.3,"d":"30%"},{"$f":"DATE(YEAR(TODAY())+1,4,1)","v":"2025-04-01"},{"$f":"Table_ForecastInput[[#This Row],[Vorhersagebetrag]]*Table_ForecastInput[[#This Row],[Wahrscheinlichkeit des Verkaufs]]","v":{"v":44250,"d":"44,250 €"}}]
[null,"Blue Yonder Airlines","Suma Kini","USA – Nordwesten","Prof. Dienstleistungen",{"v":148000,"d":"148,000 €"},"Budget validiert",{"v":0.4,"d":"40%"},{"$f":"DATE(YEAR(TODAY())+1,5,1)","v":"2025-05-01"},{"$f":"Table_ForecastInput[[#This Row],[Vorhersagebetrag]]*Table_ForecastInput[[#This Row],[Wahrscheinlichkeit des Verkaufs]]","v":{"v":59200,"d":"59,200 €"}}]
[null,"City Power & Light","Rowan Murphy","USA – Südwesten","Support",{"v":175000,"d":"175,000 €"},"Bedarfsanalyse",{"v":0.5,"d":"50%"},{"$f":"DATE(YEAR(TODAY())+1,6,1)","v":"2025-06-01"},{"$f":"Table_ForecastInput[[#This Row],[Vorhersagebetrag]]*Table_ForecastInput[[#This Row],[Wahrscheinlichkeit des Verkaufs]]","v":{"v":87500,"d":"87,500 €"}}]
[null,"Coho Vineyard","Cora Thomas","Kanada – Osten","Mischung",{"v":149000,"d":"149,000 €"},"Vorgeschlagene Lösung",{"v":0.6,"d":"60%"},{"$f":"DATE(YEAR(TODAY())+1,7,1)","v":"2025-07-01"},{"$f":"Table_ForecastInput[[#This Row],[Vorhersagebetrag]]*Table_ForecastInput[[#This Row],[Wahrscheinlichkeit des Verkaufs]]","v":{"v":89400,"d":"89,400 €"}}]
[null,"Coho Winery","Suma Kini","Kanada – Westen","Schulung",{"v":142000,"d":"142,000 €"},"Schriftlicher Vorschlag",{"v":0.7,"d":"70%"},{"$f":"DATE(YEAR(TODAY())+1,8,1)","v":"2025-08-01"},{"$f":"Table_ForecastInput[[#This Row],[Vorhersagebetrag]]*Table_ForecastInput[[#This Row],[Wahrscheinlichkeit des Verkaufs]]","v":{"v":99400,"d":"99,400 €"}}]
[null,"Contoso, Ltd.","Cora Thomas","EMEA – Frankreich","Mischung",{"v":172500,"d":"172,500 €"},"Verbale Genehmigung",{"v":0.9,"d":"90%"},{"$f":"DATE(YEAR(TODAY())+1,10,1)","v":"2025-10-01"},{"$f":"Table_ForecastInput[[#This Row],[Vorhersagebetrag]]*Table_ForecastInput[[#This Row],[Wahrscheinlichkeit des Verkaufs]]","v":{"v":155250,"d":"155,250 €"}}]
[null,"Contoso Pharmaceuticals","Ellis-Turner","EMEA – Deutschland","Produkte",{"v":163500,"d":"163,500 €"},"Sponsoring",{"v":0.2,"d":"20%"},{"$f":"DATE(YEAR(TODAY())+1,11,1)","v":"2025-11-01"},{"$f":"Table_ForecastInput[[#This Row],[Vorhersagebetrag]]*Table_ForecastInput[[#This Row],[Wahrscheinlichkeit des Verkaufs]]","v":{"v":32700,"d":"32,700 €"}}]
[null,"Consolidated Messenger","Suma Kini","EMEA – Italien","Produkte",{"v":155500,"d":"155,500 €"},"Formale Genehmigung",{"v":1,"d":"100%"},{"$f":"DATE(YEAR(TODAY())+1,12,1)","v":"2025-12-01"},{"$f":"Table_ForecastInput[[#This Row],[Vorhersagebetrag]]*Table_ForecastInput[[#This Row],[Wahrscheinlichkeit des Verkaufs]]","v":{"v":155500,"d":"155,500 €"}}]
[null,"Fabrikam, Inc.","Ellis-Turner","EMEA – Sonstige","Consulting",{"v":166000,"d":"166,000 €"},"Verkaufschance",{"v":0.1,"d":"10%"},{"$f":"DATE(YEAR(TODAY())+1,1,1)","v":"2025-01-01"},{"$f":"Table_ForecastInput[[#This Row],[Vorhersagebetrag]]*Table_ForecastInput[[#This Row],[Wahrscheinlichkeit des Verkaufs]]","v":{"v":16600,"d":"16,600 €"}}]
[null,"Fourth Coffee","Cora Thomas","APSA – Asien","Schulung",{"v":180000,"d":"180,000 €"},"Budget validiert",{"v":0.3,"d":"30%"},{"$f":"DATE(YEAR(TODAY())+1,3,1)","v":"2025-03-01"},{"$f":"Table_ForecastInput[[#This Row],[Vorhersagebetrag]]*Table_ForecastInput[[#This Row],[Wahrscheinlichkeit des Verkaufs]]","v":{"v":54000,"d":"54,000 €"}}]
[null,"Graphic Design Institute","Miho Kojima","APSA – Pazifik","Dienstleistungen",{"v":140000,"d":"140,000 €"},"Vorgeschlagene Lösung",{"v":0.6,"d":"60%"},{"$f":"DATE(YEAR(TODAY())+1,5,1)","v":"2025-05-01"},{"$f":"Table_ForecastInput[[#This Row],[Vorhersagebetrag]]*Table_ForecastInput[[#This Row],[Wahrscheinlichkeit des Verkaufs]]","v":{"v":84000,"d":"84,000 €"}}]
[null,"Humongous Insurance","Rowan Murphy","APSA – Mexiko","Support",{"v":155000,"d":"155,000 €"},"Sponsoring",{"v":0.3,"d":"30%"},{"$f":"DATE(YEAR(TODAY())+1,6,1)","v":"2025-06-01"},{"$f":"Table_ForecastInput[[#This Row],[Vorhersagebetrag]]*Table_ForecastInput[[#This Row],[Wahrscheinlichkeit des Verkaufs]]","v":{"v":46500,"d":"46,500 €"}}]
[null,"Litware, Inc.","Miho Kojima","APSA – Australien","Prof. Dienstleistungen",{"v":173200,"d":"173,200 €"},"Bedarfsanalyse",{"v":0.5,"d":"50%"},{"$f":"DATE(YEAR(TODAY())+1,10,1)","v":"2025-10-01"},{"$f":"Table_ForecastInput[[#This Row],[Vorhersagebetrag]]*Table_ForecastInput[[#This Row],[Wahrscheinlichkeit des Verkaufs]]","v":{"v":86600,"d":"86,600 €"}}]
[null,"Lucerne Publishing","Suma Kini","APSA – Sonstige","Dienstleistungen",{"v":146500,"d":"146,500 €"},"Vorgeschlagene Lösung",{"v":0.6,"d":"60%"},{"$f":"DATE(YEAR(TODAY())+1,12,1)","v":"2025-12-01"},{"$f":"Table_ForecastInput[[#This Row],[Vorhersagebetrag]]*Table_ForecastInput[[#This Row],[Wahrscheinlichkeit des Verkaufs]]","v":{"v":87900,"d":"87,900 €"}}]
[null,"Margie's Travel","Ellis-Turner","USA – Nordosten","Kundensupport",{"v":156750,"d":"156,750 €"},"Schriftlicher Vorschlag",{"v":0.7,"d":"70%"},{"$f":"DATE(YEAR(TODAY())+1,11,1)","v":"2025-11-01"},{"$f":"Table_ForecastInput[[#This Row],[Vorhersagebetrag]]*Table_ForecastInput[[#This Row],[Wahrscheinlichkeit des Verkaufs]]","v":{"v":109725,"d":"109,725 €"}}]
[null,"Northwind Traders","Cora Thomas","USA – zentraler Süden","Prof. Dienstleistungen",{"v":162000,"d":"162,000 €"},"Verbale Genehmigung",{"v":0.9,"d":"90%"},{"$f":"DATE(YEAR(TODAY())+1,2,1)","v":"2025-02-01"},{"$f":"Table_ForecastInput[[#This Row],[Vorhersagebetrag]]*Table_ForecastInput[[#This Row],[Wahrscheinlichkeit des Verkaufs]]","v":{"v":145800,"d":"145,800 €"}}]
[null,"Proseware, Inc.","Ellis-Turner","Kanada – Osten","Mischung",{"v":157000,"d":"157,000 €"},"Formale Genehmigung",{"v":1,"d":"100%"},{"$f":"DATE(YEAR(TODAY())+1,3,1)","v":"2025-03-01"},{"$f":"Table_ForecastInput[[#This Row],[Vorhersagebetrag]]*Table_ForecastInput[[#This Row],[Wahrscheinlichkeit des Verkaufs]]","v":{"v":157000,"d":"157,000 €"}}]
[null,"School of Fine Art","Miho Kojima","EMEA – Frankreich","Dienstleistungen",{"v":173000,"d":"173,000 €"},"Budget validiert",{"v":0.4,"d":"40%"},{"$f":"DATE(YEAR(TODAY())+1,4,1)","v":"2025-04-01"},{"$f":"Table_ForecastInput[[#This Row],[Vorhersagebetrag]]*Table_ForecastInput[[#This Row],[Wahrscheinlichkeit des Verkaufs]]","v":{"v":69200,"d":"69,200 €"}}]
[null,"Southridge Video","Suma Kini","EMEA – Vereinigtes Königreich","Mischung",{"v":171000,"d":"171,000 €"},"Bedarfsanalyse",{"v":0.5,"d":"50%"},{"$f":"DATE(YEAR(TODAY())+1,8,1)","v":"2025-08-01"},{"$f":"Table_ForecastInput[[#This Row],[Vorhersagebetrag]]*Table_ForecastInput[[#This Row],[Wahrscheinlichkeit des Verkaufs]]","v":{"v":85500,"d":"85,500 €"}}]
[null,"Tailspin Toys","Rowan Murphy","APSA – Australien","Produkte",{"v":168000,"d":"168,000 €"},"Vorgeschlagene Lösung",{"v":0.6,"d":"60%"},{"$f":"DATE(YEAR(TODAY())+1,9,1)","v":"2025-09-01"},{"$f":"Table_ForecastInput[[#This Row],[Vorhersagebetrag]]*Table_ForecastInput[[#This Row],[Wahrscheinlichkeit des Verkaufs]]","v":{"v":100800,"d":"100,800 €"}}]

{"sheet":"Umsatzprognose","index":1,"n_rows":19,"n_cols":18,"rows_kept":19}
[{"$nulls":14}," "]
[null,{"$f":"Unternehmensname","v":"HLP Manufacturing INC"}]
[null,"Prognosediagramm"]
[null,"Vertraulich"]
[null,"Startmonat",{"$f":"DATE(YEAR(TODAY())+1,1,1)","v":"2025-01-01"}]
[null,"Monat","Monatlich \nPrognose","Kumulativ",{"$nulls":11},{"$f":"B6","v":"Monat"},"Monatliche Prognose","Kumulativ"]
[null,{"$f":"DATE(YEAR(Starting_Month),MONTH(Starting_Month)+0,1)","v":"2025-01-01"},{"$f":"SUMIFS(Table_ForecastInput[Gewichtete Prognose],Table_ForecastInput[Prognose \nschließen],\">=\"&Umsatzprognose!B7,Table_ForecastInput[Prognose \nschließen],\"<=\"&DATE(YEAR(Umsatzprognose!B7),MONTH(Umsatzprognose!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[Gewichtete Prognose],Table_ForecastInput[Prognose \nschließen],\">=\"&Umsatzprognose!B8,Table_ForecastInput[Prognose \nschließen],\"<=\"&DATE(YEAR(Umsatzprognose!B8),MONTH(Umsatzprognose!B8)+1,0))","v":{"v":160320,"d":"160,320 €"}},{"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[Gewichtete Prognose],Table_ForecastInput[Prognose \nschließen],\">=\"&Umsatzprognose!B9,Table_ForecastInput[Prognose \nschließen],\"<=\"&DATE(YEAR(Umsatzprognose!B9),MONTH(Umsatzprognose!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[Gewichtete Prognose],Table_ForecastInput[Prognose \nschließen],\">=\"&Umsatzprognose!B10,Table_ForecastInput[Prognose \nschließen],\"<=\"&DATE(YEAR(Umsatzprognose!B10),MONTH(Umsatzprognose!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[Gewichtete Prognose],Table_ForecastInput[Prognose \nschließen],\">=\"&Umsatzprognose!B11,Table_ForecastInput[Prognose \nschließen],\"<=\"&DATE(YEAR(Umsatzprognose!B11),MONTH(Umsatzprognose!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[Gewichtete Prognose],Table_ForecastInput[Prognose \nschließen],\">=\"&Umsatzprognose!B12,Table_ForecastInput[Prognose \nschließen],\"<=\"&DATE(YEAR(Umsatzprognose!B12),MONTH(Umsatzprognose!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[Gewichtete Prognose],Table_ForecastInput[Prognose \nschließen],\">=\"&Umsatzprognose!B13,Table_ForecastInput[Prognose \nschließen],\"<=\"&DATE(YEAR(Umsatzprognose!B13),MONTH(Umsatzprognose!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[Gewichtete Prognose],Table_ForecastInput[Prognose \nschließen],\">=\"&Umsatzprognose!B14,Table_ForecastInput[Prognose \nschließen],\"<=\"&DATE(YEAR(Umsatzprognose!B14),MONTH(Umsatzprognose!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[Gewichtete Prognose],Table_ForecastInput[Prognose \nschließen],\">=\"&Umsatzprognose!B15,Table_ForecastInput[Prognose \nschließen],\"<=\"&DATE(YEAR(Umsatzprognose!B15),MONTH(Umsatzprognose!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[Gewichtete Prognose],Table_ForecastInput[Prognose \nschließen],\">=\"&Umsatzprognose!B16,Table_ForecastInput[Prognose \nschließen],\"<=\"&DATE(YEAR(Umsatzprognose!B16),MONTH(Umsatzprognose!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[Gewichtete Prognose],Table_ForecastInput[Prognose \nschließen],\">=\"&Umsatzprognose!B17,Table_ForecastInput[Prognose \nschließen],\"<=\"&DATE(YEAR(Umsatzprognose!B17),MONTH(Umsatzprognose!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[Gewichtete Prognose],Table_ForecastInput[Prognose \nschließen],\">=\"&Umsatzprognose!B18,Table_ForecastInput[Prognose \nschließen],\"<=\"&DATE(YEAR(Umsatzprognose!B18),MONTH(Umsatzprognose!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":"Listen","index":2,"n_rows":24,"n_cols":5,"rows_kept":24}
[]
[null,{"$f":"Unternehmensname","v":"HLP Manufacturing INC"}]
[null,"Verkaufslisten"]
[null,"Vertraulich"]
[]
[null,"Vertriebsmitarbeiter","Vertriebsregionen","Verkaufskategorien","Vertriebsphasen"]
[null,"Rowan Murphy","USA – Nordosten","Consulting","Identifizierter Bedarf"]
[null,"Miho Kojima","USA – Südosten","Mischung","Verkaufschance"]
[null,"Cora Thomas","USA – zentraler Norden","Produkte","Bedarfsanalyse"]
[null,"Ellis-Turner","USA – zentraler Süden","Prof. Dienstleistungen","Vorgeschlagene Lösung"]
[null,"Suma Kini","USA – Nordwesten","Dienstleistungen","Schriftlicher Vorschlag"]
[null,null,"USA – Südwesten","Kundensupport","Verbale Genehmigung"]
[null,null,"Kanada – Osten","Schulung","Formale Genehmigung"]
[null,null,"Kanada – Westen",null,"Budget validiert"]
[null,null,"EMEA – Frankreich",null,"Sponsoring"]
[null,null,"EMEA – Deutschland"]
[null,null,"EMEA – Italien"]
[null,null,"EMEA – Sonstige"]
[null,null,"APSA – Asien"]
[null,null,"APSA – Pazifik"]
[null,null,"APSA – Mexiko"]
[null,null,"APSA – Australien"]
[null,null,"APSA – Sonstige"]
[null,null,"EMEA – Vereinigtes Königreich"]