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

{"sheet":"Prognoseeingabe","index":0,"n_rows":29,"n_cols":11,"rows_kept":29}
[{"$nulls":10}," "]
[null,"Firmenintern – Vertraulich"]
[null,"Firmenname"]
[null,"Umsatzprognose"]
[]
[null,"Name Verkaufschance","Vertriebsmitarbeiter","Vertriebsregion","Verkaufskategorie","Prognose","Vertriebsphase","Wahrscheinlichkeit des Verkaufs","Schluss der Prognose","Gewichtete Prognose"]
[null,"Adatum Corporation"," Vertriebsmitarbeiter 1","USA – Nordosten","Consulting",{"v":150000,"d":"150,000.00 €"},"Formale Genehmigung",{"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"," Vertriebsmitarbeiter 2","USA – Südosten","Produkte",{"v":145200,"d":"145,200.00 €"},"Verkaufschance",{"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 House"," Vertriebsmitarbeiter 3","USA – zentraler Norden","Schulung",{"v":162500,"d":"162,500.00 €"},"Identifizierter Bedarf",{"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"," Vertriebsmitarbeiter 4","USA – zentraler Süden","Mischung",{"v":147500,"d":"147,500.00 €"},"Sponsoring",{"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"," Vertriebsmitarbeiter 5","USA – Nordwesten","Prof. Dienstleistungen",{"v":148000,"d":"148,000.00 €"},"Budget validiert",{"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"," Vertriebsmitarbeiter 1","USA – Südwesten","Kundensupport",{"v":175000,"d":"175,000.00 €"},"Bedarfsanalyse",{"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"," Vertriebsmitarbeiter 3","Kanada – Osten","Mischung",{"v":149000,"d":"149,000.00 €"},"Vorgeschlagene Lösung",{"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"," Vertriebsmitarbeiter 5","Kanada – Westen","Schulung",{"v":142000,"d":"142,000.00 €"},"Schriftlicher Vorschlag",{"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."," Vertriebsmitarbeiter 3","EMEA – Frankreich","Mischung",{"v":172500,"d":"172,500.00 €"},"Verbale Genehmigung",{"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"," Vertriebsmitarbeiter 4","EMEA – Deutschland","Produkte",{"v":163500,"d":"163,500.00 €"},"Sponsoring",{"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"," Vertriebsmitarbeiter 5","EMEA – Italien","Produkte",{"v":155500,"d":"155,500.00 €"},"Formale Genehmigung",{"v":1,"d":"100%"},{"$f":"DATE(YEAR(TODAY())+1,12,1)","v":"2020-12-01"},{"v":155500,"d":"155,500.00 €"}]
[null,"Fabrikam, Inc."," Vertriebsmitarbeiter 4","EMEA – Sonstige","Consulting",{"v":166000,"d":"166,000.00 €"},"Verkaufschance",{"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"," Vertriebsmitarbeiter 3","APSA – Asien","Schulung",{"v":180000,"d":"180,000.00 €"},"Budget validiert",{"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"," Vertriebsmitarbeiter 2","APSA – Pazifik","Dienstleistungen",{"v":140000,"d":"140,000.00 €"},"Vorgeschlagene Lösung",{"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"," Vertriebsmitarbeiter 1","APSA – Mexiko","Kundensupport",{"v":155000,"d":"155,000.00 €"},"Sponsoring",{"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."," Vertriebsmitarbeiter 2","APSA – Australien","Prof. Dienstleistungen",{"v":173200,"d":"173,200.00 €"},"Bedarfsanalyse",{"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"," Vertriebsmitarbeiter 5","APSA – Sonstige","Dienstleistungen",{"v":146500,"d":"146,500.00 €"},"Vorgeschlagene Lösung",{"v":0.6,"d":"60%"},{"$f":"DATE(YEAR(TODAY())+1,12,1)","v":"2020-12-01"},{"v":87900,"d":"87,900.00 €"}]
[null,"Margie's Travel"," Vertriebsmitarbeiter 4","USA – Nordosten","Kundensupport",{"v":156750,"d":"156,750.00 €"},"Schriftlicher Vorschlag",{"v":0.7,"d":"70%"},{"$f":"DATE(YEAR(TODAY())+1,11,1)","v":"2020-11-01"},{"v":109725,"d":"109,725.00 €"}]
[null,"Northwind Traders"," Vertriebsmitarbeiter 3","USA – zentraler Süden","Prof. Dienstleistungen",{"v":162000,"d":"162,000.00 €"},"Verbale Genehmigung",{"v":0.9,"d":"90%"},{"$f":"DATE(YEAR(TODAY())+1,2,1)","v":"2020-02-01"},{"v":145800,"d":"145,800.00 €"}]
[null,"Proseware, Inc."," Vertriebsmitarbeiter 4","Kanada – Osten","Mischung",{"v":157000,"d":"157,000.00 €"},"Formale Genehmigung",{"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"," Vertriebsmitarbeiter 3","EMEA – Frankreich","Dienstleistungen",{"v":173000,"d":"173,000.00 €"},"Budget validiert",{"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"," Vertriebsmitarbeiter 5","EMEA – Vereinigtes Königreich","Mischung",{"v":171000,"d":"171,000.00 €"},"Bedarfsanalyse",{"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"," Vertriebsmitarbeiter 1","APSA – Australien","Produkte",{"v":168000,"d":"168,000.00 €"},"Vorgeschlagene Lösung",{"v":0.6,"d":"60%"},{"$f":"DATE(YEAR(TODAY())+1,9,1)","v":"2020-09-01"},{"v":100800,"d":"100,800.00 €"}]

{"sheet":"Umsatzprognose","index":1,"n_rows":20,"n_cols":18,"rows_kept":20}
[{"$nulls":10}," "]
[null,"Firmenintern – Vertraulich"]
[]
[null,"Diagramm „Umsatzprognose“"]
[]
[null,"Anfangsmonat",{"$f":"DATE(YEAR(TODAY())+1,1,1)","v":"2020-01-01"}]
[]
[null,"Monat","Monatliche Prognose","Kumuliert",{"$nulls":11},{"$f":"B8","v":"Monat"},"Monatliche Prognose","Kumuliert"]
[null,{"$f":"DATE(YEAR(Starting_Month),MONTH(Starting_Month)+0,1)","v":"2020-01-01"},{"$f":"SUMIFS(Table_ForecastInput[Gewichtete Prognose],Table_ForecastInput[Schluss der Prognose],\">=\"&Umsatzprognose!B9,Table_ForecastInput[Schluss der Prognose],\"<=\"&DATE(YEAR(Umsatzprognose!B9),MONTH(Umsatzprognose!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[Gewichtete Prognose],Table_ForecastInput[Schluss der Prognose],\">=\"&Umsatzprognose!B10,Table_ForecastInput[Schluss der Prognose],\"<=\"&DATE(YEAR(Umsatzprognose!B10),MONTH(Umsatzprognose!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[Gewichtete Prognose],Table_ForecastInput[Schluss der Prognose],\">=\"&Umsatzprognose!B11,Table_ForecastInput[Schluss der Prognose],\"<=\"&DATE(YEAR(Umsatzprognose!B11),MONTH(Umsatzprognose!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[Gewichtete Prognose],Table_ForecastInput[Schluss der Prognose],\">=\"&Umsatzprognose!B12,Table_ForecastInput[Schluss der Prognose],\"<=\"&DATE(YEAR(Umsatzprognose!B12),MONTH(Umsatzprognose!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[Gewichtete Prognose],Table_ForecastInput[Schluss der Prognose],\">=\"&Umsatzprognose!B13,Table_ForecastInput[Schluss der Prognose],\"<=\"&DATE(YEAR(Umsatzprognose!B13),MONTH(Umsatzprognose!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[Gewichtete Prognose],Table_ForecastInput[Schluss der Prognose],\">=\"&Umsatzprognose!B14,Table_ForecastInput[Schluss der Prognose],\"<=\"&DATE(YEAR(Umsatzprognose!B14),MONTH(Umsatzprognose!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[Gewichtete Prognose],Table_ForecastInput[Schluss der Prognose],\">=\"&Umsatzprognose!B15,Table_ForecastInput[Schluss der Prognose],\"<=\"&DATE(YEAR(Umsatzprognose!B15),MONTH(Umsatzprognose!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[Gewichtete Prognose],Table_ForecastInput[Schluss der Prognose],\">=\"&Umsatzprognose!B16,Table_ForecastInput[Schluss der Prognose],\"<=\"&DATE(YEAR(Umsatzprognose!B16),MONTH(Umsatzprognose!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[Gewichtete Prognose],Table_ForecastInput[Schluss der Prognose],\">=\"&Umsatzprognose!B17,Table_ForecastInput[Schluss der Prognose],\"<=\"&DATE(YEAR(Umsatzprognose!B17),MONTH(Umsatzprognose!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[Gewichtete Prognose],Table_ForecastInput[Schluss der Prognose],\">=\"&Umsatzprognose!B18,Table_ForecastInput[Schluss der Prognose],\"<=\"&DATE(YEAR(Umsatzprognose!B18),MONTH(Umsatzprognose!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[Gewichtete Prognose],Table_ForecastInput[Schluss der Prognose],\">=\"&Umsatzprognose!B19,Table_ForecastInput[Schluss der Prognose],\"<=\"&DATE(YEAR(Umsatzprognose!B19),MONTH(Umsatzprognose!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[Gewichtete Prognose],Table_ForecastInput[Schluss der Prognose],\">=\"&Umsatzprognose!B20,Table_ForecastInput[Schluss der Prognose],\"<=\"&DATE(YEAR(Umsatzprognose!B20),MONTH(Umsatzprognose!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":"Listen","index":2,"n_rows":21,"n_cols":8,"rows_kept":21}
[null,"Listen"]
[]
[null,"Vertriebsmitarbeiter",null,"Vertriebsregionen",null,"Verkaufskategorien",null,"Vertriebsphasen"]
[null," Vertriebsmitarbeiter 1",null,"USA – Nordosten",null,"Consulting",null,"Identifizierter Bedarf"]
[null," Vertriebsmitarbeiter 2",null,"USA – Südosten",null,"Mischung",null,"Verkaufschance"]
[null," Vertriebsmitarbeiter 3",null,"USA – zentraler Norden",null,"Produkte",null,"Bedarfsanalyse"]
[null," Vertriebsmitarbeiter 4",null,"USA – zentraler Süden",null,"Prof. Dienstleistungen",null,"Vorgeschlagene Lösung"]
[null," Vertriebsmitarbeiter 5",null,"USA – Nordwesten",null,"Dienstleistungen",null,"Schriftlicher Vorschlag"]
[{"$nulls":3},"USA – Südwesten",null,"Kundensupport",null,"Verbale Genehmigung"]
[{"$nulls":3},"Kanada – Osten",null,"Schulung",null,"Formale Genehmigung"]
[{"$nulls":3},"Kanada – Westen",{"$nulls":3},"Budget validiert"]
[{"$nulls":3},"EMEA – Frankreich",{"$nulls":3},"Sponsoring"]
[{"$nulls":3},"EMEA – Deutschland"]
[{"$nulls":3},"EMEA – Italien"]
[{"$nulls":3},"EMEA – Sonstige"]
[{"$nulls":3},"APSA – Asien"]
[{"$nulls":3},"APSA – Pazifik"]
[{"$nulls":3},"APSA – Mexiko"]
[{"$nulls":3},"APSA – Australien"]
[{"$nulls":3},"APSA – Sonstige"]
[{"$nulls":3},"EMEA – Vereinigtes Königreich"]