{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Leaddaten","Prognostizierte Umsätze ","Gewichtete Monatsprognose"],"not_rendered":{"charts":1,"images":2,"defined_names":9},"read":"whole","date_system":"1900"}

{"sheet":"Leaddaten","index":0,"n_rows":10,"n_cols":10,"rows_kept":10,"merged":[[2,1,2,2],[3,4,3,8],[4,1,4,8]]}
[]
[]
[null,"Detaillierter Lead-Tracker"]
[null,{"$f":"TODAY()","v":"2019-10-18"}]
[null,"Firmenname\t\t\t\t\t\t\t\t\t\t",{"$nulls":7},"VERTRAULICH"]
[null,"Name des Leads","Lead-Kontakt","Lead- \nQuelle","Lead \nRegion","Lead \ntyp","Potenzielle Verkaufschance","Verkaufs- \nchance","Prognose- \nschluss","Gewichtet \nPrognose-"]
[null,"Adatum Corporation",null,"Website","Nord","Strategisch",{"v":300000,"d":"300,000.00 €"},{"v":0.9,"d":"90%"},"Januar",{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Verkaufs- \nchance]]<>\"\",LeadDaten[[#This Row],[Verkaufs- \nchance]]*LeadDaten[[#This Row],[Potenzielle Verkaufschance]],\"\"),\"\")","v":{"v":270000,"d":"270,000.00 €"}}]
[null,"Adventure Works",null,"Networking-Veranstaltung","Süd","Strategisch",{"v":200000,"d":"200,000.00 €"},{"v":0.1,"d":"10%"},"Februar",{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Verkaufs- \nchance]]<>\"\",LeadDaten[[#This Row],[Verkaufs- \nchance]]*LeadDaten[[#This Row],[Potenzielle Verkaufschance]],\"\"),\"\")","v":{"v":20000,"d":"20,000.00 €"}}]
[null,"Alpine Skihütte",null,"Networking-Veranstaltung","Nord","Taktisch",{"v":100000,"d":"100,000.00 €"},{"v":0.2,"d":"20%"},"März",{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Verkaufs- \nchance]]<>\"\",LeadDaten[[#This Row],[Verkaufs- \nchance]]*LeadDaten[[#This Row],[Potenzielle Verkaufschance]],\"\"),\"\")","v":{"v":20000,"d":"20,000.00 €"}}]
[null,"Ergebnis",{"$nulls":4},{"$f":"SUBTOTAL(109,LeadDaten[Potenzielle Verkaufschance])","v":{"v":600000,"d":"600,000.00 €"}},null,null,{"$f":"SUBTOTAL(109,LeadDaten[Gewichtet \nPrognose-])","v":{"v":310000,"d":"310,000.00 €"}}]

{"sheet":"Prognostizierte Umsätze ","index":1,"n_rows":15,"n_cols":14,"rows_kept":15,"merged":[[0,5,0,9],[2,1,2,2],[4,1,4,11],[4,12,4,13]]}
[]
[]
[null,"Prognostizierte Umsätze"]
[null,{"$f":"TrackerDatum","v":"2019-10-18"}]
[null,{"$f":"Leaddaten!B5:I5","v":"Firmenname\t\t\t\t\t\t\t\t\t\t"},{"$nulls":10},"VERTRAULICH"]
[null,"Name des Leads","Januar \nPrognose-","Februar \nPrognose-","März \nPrognose-","April \nPrognose-","Mai \nPrognose-","Juni \nPrognose-","Juli\nPrognose-","August \nPrognose-","September \nPrognose-","Oktober \nPrognose-","November \nPrognose-","Dezember \nPrognose-"]
[null,{"$f":"IFERROR(IF(AND(LeadDaten[[#This Row],[Name des Leads]] <> \"\", ROW(PrognostizierteUmsätze[Name des Leads])<>LetzterEintrag),LeadDaten[Name des Leads], \"\"),\"\")","v":"Adatum Corporation"},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"Januar\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":{"v":270000,"d":"270,000 €"}},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"Februar\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":{"v":0,"d":"0 €"}},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"März\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":{"v":0,"d":"0 €"}},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"April\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":{"v":0,"d":"0 €"}},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"Mai\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":{"v":0,"d":"0 €"}},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"Juni\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":{"v":0,"d":"0 €"}},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"Juli\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":{"v":0,"d":"0 €"}},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"August\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":{"v":0,"d":"0 €"}},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"September\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":{"v":0,"d":"0 €"}},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"Oktober\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":{"v":0,"d":"0 €"}},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"November\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":{"v":0,"d":"0 €"}},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"Dezember\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":{"v":0,"d":"0 €"}}]
[null,{"$f":"IFERROR(IF(AND(LeadDaten[[#This Row],[Name des Leads]] <> \"\", ROW(PrognostizierteUmsätze[Name des Leads])<>LetzterEintrag),LeadDaten[Name des Leads], \"\"),\"\")","v":"Adventure Works"},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"Januar\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":{"v":0,"d":"0 €"}},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"Februar\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":{"v":20000,"d":"20,000 €"}},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"März\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":{"v":0,"d":"0 €"}},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"April\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":{"v":0,"d":"0 €"}},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"Mai\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":{"v":0,"d":"0 €"}},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"Juni\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":{"v":0,"d":"0 €"}},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"Juli\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":{"v":0,"d":"0 €"}},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"August\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":{"v":0,"d":"0 €"}},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"September\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":{"v":0,"d":"0 €"}},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"Oktober\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":{"v":0,"d":"0 €"}},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"November\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":{"v":0,"d":"0 €"}},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"Dezember\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":{"v":0,"d":"0 €"}}]
[null,{"$f":"IFERROR(IF(AND(LeadDaten[[#This Row],[Name des Leads]] <> \"\", ROW(PrognostizierteUmsätze[Name des Leads])<>LetzterEintrag),LeadDaten[Name des Leads], \"\"),\"\")","v":"Alpine Skihütte"},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"Januar\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":{"v":0,"d":"0 €"}},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"Februar\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":{"v":0,"d":"0 €"}},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"März\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":{"v":20000,"d":"20,000 €"}},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"April\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":{"v":0,"d":"0 €"}},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"Mai\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":{"v":0,"d":"0 €"}},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"Juni\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":{"v":0,"d":"0 €"}},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"Juli\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":{"v":0,"d":"0 €"}},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"August\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":{"v":0,"d":"0 €"}},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"September\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":{"v":0,"d":"0 €"}},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"Oktober\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":{"v":0,"d":"0 €"}},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"November\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":{"v":0,"d":"0 €"}},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"Dezember\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":{"v":0,"d":"0 €"}}]
[null,{"$f":"IFERROR(IF(AND(LeadDaten[[#This Row],[Name des Leads]] <> \"\", ROW(PrognostizierteUmsätze[Name des Leads])<>LetzterEintrag),LeadDaten[Name des Leads], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"Januar\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"Februar\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"März\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"April\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"Mai\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"Juni\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"Juli\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"August\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"September\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"Oktober\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"November\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"Dezember\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(AND(LeadDaten[[#This Row],[Name des Leads]] <> \"\", ROW(PrognostizierteUmsätze[Name des Leads])<>LetzterEintrag),LeadDaten[Name des Leads], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"Januar\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"Februar\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"März\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"April\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"Mai\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"Juni\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"Juli\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"August\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"September\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"Oktober\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"November\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"Dezember\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(AND(LeadDaten[[#This Row],[Name des Leads]] <> \"\", ROW(PrognostizierteUmsätze[Name des Leads])<>LetzterEintrag),LeadDaten[Name des Leads], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"Januar\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"Februar\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"März\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"April\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"Mai\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"Juni\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"Juli\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"August\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"September\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"Oktober\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"November\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"Dezember\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(AND(LeadDaten[[#This Row],[Name des Leads]] <> \"\", ROW(PrognostizierteUmsätze[Name des Leads])<>LetzterEintrag),LeadDaten[Name des Leads], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"Januar\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"Februar\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"März\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"April\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"Mai\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"Juni\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"Juli\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"August\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"September\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"Oktober\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"November\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadDaten[[#This Row],[Prognose- \nschluss]] <>\"\",IF(LeadDaten[[#This Row],[Prognose- \nschluss]] = \"Dezember\",LeadDaten[Gewichtet \nPrognose-],0),\"\"),\"\")","v":""}]
[null,"Ergebnis",{"$f":"SUBTOTAL(109,PrognostizierteUmsätze[Januar \nPrognose-])","v":{"v":270000,"d":"270,000 €"}},{"$f":"SUBTOTAL(109,PrognostizierteUmsätze[Februar \nPrognose-])","v":{"v":20000,"d":"20,000 €"}},{"$f":"SUBTOTAL(109,PrognostizierteUmsätze[März \nPrognose-])","v":{"v":20000,"d":"20,000 €"}},{"$f":"SUBTOTAL(109,PrognostizierteUmsätze[April \nPrognose-])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,PrognostizierteUmsätze[Mai \nPrognose-])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,PrognostizierteUmsätze[Juni \nPrognose-])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,PrognostizierteUmsätze[Juli\nPrognose-])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,PrognostizierteUmsätze[August \nPrognose-])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,PrognostizierteUmsätze[September \nPrognose-])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,PrognostizierteUmsätze[Oktober \nPrognose-])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,PrognostizierteUmsätze[November \nPrognose-])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,PrognostizierteUmsätze[Dezember \nPrognose-])","v":{"v":0,"d":"0 €"}}]
[null,"Kumulierte Summe",{"$f":"C14","v":{"v":270000,"d":"270,000 €"}},{"$f":"C15+D14","v":{"v":290000,"d":"290,000 €"}},{"$f":"D15+E14","v":{"v":310000,"d":"310,000 €"}},{"$f":"E15+F14","v":{"v":310000,"d":"310,000 €"}},{"$f":"F15+G14","v":{"v":310000,"d":"310,000 €"}},{"$f":"G15+H14","v":{"v":310000,"d":"310,000 €"}},{"$f":"H15+I14","v":{"v":310000,"d":"310,000 €"}},{"$f":"I15+J14","v":{"v":310000,"d":"310,000 €"}},{"$f":"J15+K14","v":{"v":310000,"d":"310,000 €"}},{"$f":"K15+L14","v":{"v":310000,"d":"310,000 €"}},{"$f":"L15+M14","v":{"v":310000,"d":"310,000 €"}},{"$f":"M15+N14","v":{"v":310000,"d":"310,000 €"}}]

{"sheet":"Gewichtete Monatsprognose","index":2,"n_rows":3,"n_cols":2,"rows_kept":3,"merged":[[0,5,0,9]]}
[]
[]
[null,"Gewichtete Monatsprognose"]