{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Leadgegevens","Verkoopprognose ","Maandelijks Gewogen Prognose"],"not_rendered":{"charts":1,"images":2,"defined_names":9},"read":"whole","date_system":"1900"}

{"sheet":"Leadgegevens","index":0,"n_rows":10,"n_cols":10,"rows_kept":10,"merged":[[2,1,2,2],[3,4,3,8]]}
[]
[]
[null,"Gedetailleerde leadtracker"]
[null,{"$f":"TODAY()","v":"2022-06-22"}]
[null,"Bedrijfsnaam\t\t\t\t\t\t\t\t\t\t",{"$nulls":7},"VERTROUWELIJK"]
[null,"Leadnaam","Contactpersoon Lead","Lead \nBron","Lead \nRegio","Lead \nType","Verkoopkans","Percentage \nverkoopkans","Prognose \nSluiten","Gewogen \nPrognose"]
[null,"Adatum Corporation",null,"Website","Noord","Strategisch",{"v":300000,"d":"€ 300,000.00"},{"v":0.9,"d":"90%"},"Januari",{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Percentage \nverkoopkans]]<>\"\",Leadgegevens[[#This Row],[Percentage \nverkoopkans]]*Leadgegevens[[#This Row],[Verkoopkans]],\"\"),\"\")","v":{"v":270000,"d":"€ 270,000.00"}}]
[null,"Adventure Works",null,"Netwerkbijeenkomst","Zuid","Strategisch",{"v":200000,"d":"€ 200,000.00"},{"v":0.1,"d":"10%"},"Februari",{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Percentage \nverkoopkans]]<>\"\",Leadgegevens[[#This Row],[Percentage \nverkoopkans]]*Leadgegevens[[#This Row],[Verkoopkans]],\"\"),\"\")","v":{"v":20000,"d":"€ 20,000.00"}}]
[null,"Alpine Ski House",null,"Netwerkbijeenkomst","Noord","Tactisch",{"v":100000,"d":"€ 100,000.00"},{"v":0.2,"d":"20%"},"Maart",{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Percentage \nverkoopkans]]<>\"\",Leadgegevens[[#This Row],[Percentage \nverkoopkans]]*Leadgegevens[[#This Row],[Verkoopkans]],\"\"),\"\")","v":{"v":20000,"d":"€ 20,000.00"}}]
[null,"Totaal",{"$nulls":4},{"$f":"SUBTOTAL(109,Leadgegevens[Verkoopkans])","v":{"v":600000,"d":"€ 600,000.00"}},null,null,{"$f":"SUBTOTAL(109,Leadgegevens[Gewogen \nPrognose])","v":{"v":310000,"d":"€ 310,000.00"}}]

{"sheet":"Verkoopprognose ","index":1,"n_rows":15,"n_cols":14,"rows_kept":15,"merged":[[0,5,0,9],[2,1,2,2],[4,12,4,13]]}
[]
[]
[null,"Verkoopprognose"]
[null,{"$f":"BijhoudenDatum","v":"2022-06-22"}]
[null,{"$f":"Leadgegevens!B5:I5","v":"Bedrijfsnaam\t\t\t\t\t\t\t\t\t\t"},{"$nulls":10},"VERTROUWELIJK"]
[null,"Leadnaam","Januari \nPrognose","Februari \nPrognose","Maart \nPrognose","April \nPrognose","Mei \nPrognose","Juni \nPrognose","Juli Prognose","Augustus \nPrognose","September \nPrognose","Oktober \nPrognose","November \nPrognose","December \nPrognose"]
[null,{"$f":"IFERROR(IF(AND(Leadgegevens[[#This Row],[Leadnaam]] <> \"\", ROW(Verkoopprognose[Leadnaam])<>LastEntry),Leadgegevens[Leadnaam], \"\"),\"\")","v":"Adatum Corporation"},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]]= \"Januari\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":{"v":270000,"d":"€ 270,000"}},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"Februari\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":{"v":0,"d":"€ 0"}},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"Maart\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":{"v":0,"d":"€ 0"}},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"April\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":{"v":0,"d":"€ 0"}},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"Mei\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":{"v":0,"d":"€ 0"}},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"Juni\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":{"v":0,"d":"€ 0"}},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"Juli\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":{"v":0,"d":"€ 0"}},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"Augustus\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":{"v":0,"d":"€ 0"}},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"September\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":{"v":0,"d":"€ 0"}},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"Oktober\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":{"v":0,"d":"€ 0"}},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"November\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":{"v":0,"d":"€ 0"}},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"December\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":{"v":0,"d":"€ 0"}}]
[null,{"$f":"IFERROR(IF(AND(Leadgegevens[[#This Row],[Leadnaam]] <> \"\", ROW(Verkoopprognose[Leadnaam])<>LastEntry),Leadgegevens[Leadnaam], \"\"),\"\")","v":"Adventure Works"},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]]= \"Januari\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":{"v":0,"d":"€ 0"}},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"Februari\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":{"v":20000,"d":"€ 20,000"}},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"Maart\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":{"v":0,"d":"€ 0"}},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"April\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":{"v":0,"d":"€ 0"}},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"Mei\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":{"v":0,"d":"€ 0"}},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"Juni\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":{"v":0,"d":"€ 0"}},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"Juli\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":{"v":0,"d":"€ 0"}},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"Augustus\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":{"v":0,"d":"€ 0"}},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"September\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":{"v":0,"d":"€ 0"}},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"Oktober\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":{"v":0,"d":"€ 0"}},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"November\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":{"v":0,"d":"€ 0"}},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"December\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":{"v":0,"d":"€ 0"}}]
[null,{"$f":"IFERROR(IF(AND(Leadgegevens[[#This Row],[Leadnaam]] <> \"\", ROW(Verkoopprognose[Leadnaam])<>LastEntry),Leadgegevens[Leadnaam], \"\"),\"\")","v":"Alpine Ski House"},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]]= \"Januari\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":{"v":0,"d":"€ 0"}},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"Februari\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":{"v":0,"d":"€ 0"}},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"Maart\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":{"v":20000,"d":"€ 20,000"}},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"April\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":{"v":0,"d":"€ 0"}},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"Mei\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":{"v":0,"d":"€ 0"}},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"Juni\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":{"v":0,"d":"€ 0"}},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"Juli\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":{"v":0,"d":"€ 0"}},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"Augustus\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":{"v":0,"d":"€ 0"}},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"September\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":{"v":0,"d":"€ 0"}},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"Oktober\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":{"v":0,"d":"€ 0"}},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"November\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":{"v":0,"d":"€ 0"}},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"December\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":{"v":0,"d":"€ 0"}}]
[null,{"$f":"IFERROR(IF(AND(Leadgegevens[[#This Row],[Leadnaam]] <> \"\", ROW(Verkoopprognose[Leadnaam])<>LastEntry),Leadgegevens[Leadnaam], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]]= \"Januari\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"Februari\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"Maart\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"April\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"Mei\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"Juni\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"Juli\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"Augustus\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"September\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"Oktober\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"November\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"December\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(AND(Leadgegevens[[#This Row],[Leadnaam]] <> \"\", ROW(Verkoopprognose[Leadnaam])<>LastEntry),Leadgegevens[Leadnaam], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]]= \"Januari\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"Februari\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"Maart\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"April\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"Mei\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"Juni\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"Juli\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"Augustus\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"September\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"Oktober\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"November\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"December\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(AND(Leadgegevens[[#This Row],[Leadnaam]] <> \"\", ROW(Verkoopprognose[Leadnaam])<>LastEntry),Leadgegevens[Leadnaam], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]]= \"Januari\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"Februari\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"Maart\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"April\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"Mei\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"Juni\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"Juli\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"Augustus\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"September\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"Oktober\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"November\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"December\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(AND(Leadgegevens[[#This Row],[Leadnaam]] <> \"\", ROW(Verkoopprognose[Leadnaam])<>LastEntry),Leadgegevens[Leadnaam], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]]= \"Januari\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"Februari\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"Maart\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"April\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"Mei\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"Juni\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"Juli\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"Augustus\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"September\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"Oktober\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"November\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] <>\"\",IF(Leadgegevens[[#This Row],[Prognose \nSluiten]] = \"December\",Leadgegevens[Gewogen \nPrognose],0),\"\"),\"\")","v":""}]
[null,"Totaal",{"$f":"SUBTOTAL(109,Verkoopprognose[Januari \nPrognose])","v":{"v":270000,"d":"€ 270,000"}},{"$f":"SUBTOTAL(109,Verkoopprognose[Februari \nPrognose])","v":{"v":20000,"d":"€ 20,000"}},{"$f":"SUBTOTAL(109,Verkoopprognose[Maart \nPrognose])","v":{"v":20000,"d":"€ 20,000"}},{"$f":"SUBTOTAL(109,Verkoopprognose[April \nPrognose])","v":{"v":0,"d":"€ 0"}},{"$f":"SUBTOTAL(109,Verkoopprognose[Mei \nPrognose])","v":{"v":0,"d":"€ 0"}},{"$f":"SUBTOTAL(109,Verkoopprognose[Juni \nPrognose])","v":{"v":0,"d":"€ 0"}},{"$f":"SUBTOTAL(109,Verkoopprognose[Juli Prognose])","v":{"v":0,"d":"€ 0"}},{"$f":"SUBTOTAL(109,Verkoopprognose[Augustus \nPrognose])","v":{"v":0,"d":"€ 0"}},{"$f":"SUBTOTAL(109,Verkoopprognose[September \nPrognose])","v":{"v":0,"d":"€ 0"}},{"$f":"SUBTOTAL(109,Verkoopprognose[Oktober \nPrognose])","v":{"v":0,"d":"€ 0"}},{"$f":"SUBTOTAL(109,Verkoopprognose[November \nPrognose])","v":{"v":0,"d":"€ 0"}},{"$f":"SUBTOTAL(109,Verkoopprognose[December \nPrognose])","v":{"v":0,"d":"€ 0"}}]
[null,"Cumulatief totaal",{"$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":"Maandelijks Gewogen Prognose","index":2,"n_rows":3,"n_cols":2,"rows_kept":3,"merged":[[0,5,0,9]]}
[]
[]
[null,"Maandelijks gewogen prognose"]