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

{"sheet":"Leaddaten","index":0,"n_rows":9,"n_cols":10,"rows_kept":9}
[null,"Firmenname"]
[null,"Detaillierter Lead-Tracker"]
[null,{"$f":"TODAY()","v":"2022-04-02"}]
[{"$nulls":8},{"$f":"Firmenname","v":"Firmenname"},"VERTRAULICH"]
[null,"Name des Leads","Lead-Kontakt","Lead- \nursprung","Lead- \nregion","Lead- \ntyp","Potenzielle Verkaufschance","Verkaufs- \nchance","Prognose- \nschluss","Gewichtet \nPrognose-"]
[null,"A. Datum Corporation",{"$nulls":3},"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",{"$nulls":3},"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",{"$nulls":3},"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":21,"n_cols":14,"rows_kept":21,"merged":[[3,12,3,13]]}
[null,{"$f":"Firmenname","v":"Firmenname"}]
[null,"Prognostizierte Umsätze"]
[null,{"$f":"TrackerDatum","v":"2022-04-02"}]
[{"$nulls":11},{"$f":"Firmenname","v":"Firmenname"},"VERTRAULICH"]
[null,"Name des Leads","Januar \nPrognose","Februar \nPrognose","März \nPrognose","April \nPrognose","Mai \nPrognose","Juni \nPrognose","Juli Prognose","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":"A. Datum 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,{"$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,{"$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 Prognose])","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":"C20","v":{"v":270000,"d":"270,000 €"}},{"$f":"C21+D20","v":{"v":290000,"d":"290,000 €"}},{"v":310000,"d":"310,000 €"},{"v":310000,"d":"310,000 €"},{"v":310000,"d":"310,000 €"},{"v":310000,"d":"310,000 €"},{"v":310000,"d":"310,000 €"},{"v":310000,"d":"310,000 €"},{"v":310000,"d":"310,000 €"},{"v":310000,"d":"310,000 €"},{"v":310000,"d":"310,000 €"},{"v":310000,"d":"310,000 €"}]

{"sheet":"Gewichtete Monatsprognose","index":2,"n_rows":3,"n_cols":2,"rows_kept":3}
[null,{"$f":"Firmenname","v":"Firmenname"}]
[null,"Gewichtete Monatsprognose"]
[null," "]