{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Overzicht","Cadeaulijst"],"not_rendered":{"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"Overzicht","index":0,"n_rows":11,"n_cols":6,"rows_kept":11,"merged":[[0,1,2,1],[0,2,2,3],[3,1,3,2]]}
[null,"Kerstmis","CADEAU-TRACKER",null,"TOTAAL BUDGET",{"v":500,"d":"€ 500.00"}]
[{"$nulls":4},"UITGEGEVEN BEDRAG",{"$f":"IFERROR(SUMIFS(Cadeaus[KOSTEN],Cadeaus[GEKOCHT],\"Ja\"),\"\")","v":{"v":283,"d":"€ 283.00"}}]
[{"$nulls":4},"RESTEREND BUDGET",{"$f":"IFERROR(TotalBudget-F2,\"\")","v":{"v":217,"d":"€ 217.00"}}]
[null,"Budget aanpassen als % van gepland budget 100% overschrijdt (Ja/Nee)?",null,"Ja"]
[null,"ONTVANGER","GEPLAND % VAN BUDGET","RESTEREND TOEGEWEZEN BEDRAG","GEPLAND AANTAL \nCADEAUS","RESTEREND AANTAL \nCADEAUS"]
[null,"Adam",{"v":0.3,"d":"30%"},{"$f":"IFERROR(IF(Adjust_Budget=\"Ja\",Allocated_Money_Remaining-SUMIFS(Cadeaus[KOSTEN],Cadeaus[ONTVANGER],Ontvangers[[#This Row],[ONTVANGER]]),(TotalBudget*Ontvangers[[#This Row],[GEPLAND % VAN BUDGET]])-SUMIFS(Cadeaus[KOSTEN],Cadeaus[ONTVANGER],Ontvangers[[#This Row],[ONTVANGER]])),\"\")","v":{"v":45,"d":"€ 45.00"}},3,{"$f":"IFERROR(Ontvangers[[#This Row],[GEPLAND AANTAL \nCADEAUS]]-COUNTIFS(Cadeaus[ONTVANGER],Ontvangers[[#This Row],[ONTVANGER]]), \"\")","v":1}]
[null,"Jenny",{"v":0.3,"d":"30%"},{"$f":"IFERROR(IF(Adjust_Budget=\"Ja\",Allocated_Money_Remaining-SUMIFS(Cadeaus[KOSTEN],Cadeaus[ONTVANGER],Ontvangers[[#This Row],[ONTVANGER]]),(TotalBudget*Ontvangers[[#This Row],[GEPLAND % VAN BUDGET]])-SUMIFS(Cadeaus[KOSTEN],Cadeaus[ONTVANGER],Ontvangers[[#This Row],[ONTVANGER]])),\"\")","v":{"v":54,"d":"€ 54.00"}},3,{"$f":"IFERROR(Ontvangers[[#This Row],[GEPLAND AANTAL \nCADEAUS]]-COUNTIFS(Cadeaus[ONTVANGER],Ontvangers[[#This Row],[ONTVANGER]]), \"\")","v":1}]
[null,"Brian",{"v":0.2,"d":"20%"},{"$f":"IFERROR(IF(Adjust_Budget=\"Ja\",Allocated_Money_Remaining-SUMIFS(Cadeaus[KOSTEN],Cadeaus[ONTVANGER],Ontvangers[[#This Row],[ONTVANGER]]),(TotalBudget*Ontvangers[[#This Row],[GEPLAND % VAN BUDGET]])-SUMIFS(Cadeaus[KOSTEN],Cadeaus[ONTVANGER],Ontvangers[[#This Row],[ONTVANGER]])),\"\")","v":{"v":11,"d":"€ 11.00"}},2,{"$f":"IFERROR(Ontvangers[[#This Row],[GEPLAND AANTAL \nCADEAUS]]-COUNTIFS(Cadeaus[ONTVANGER],Ontvangers[[#This Row],[ONTVANGER]]), \"\")","v":1}]
[null,"Suzanne",{"v":0.1,"d":"10%"},{"$f":"IFERROR(IF(Adjust_Budget=\"Ja\",Allocated_Money_Remaining-SUMIFS(Cadeaus[KOSTEN],Cadeaus[ONTVANGER],Ontvangers[[#This Row],[ONTVANGER]]),(TotalBudget*Ontvangers[[#This Row],[GEPLAND % VAN BUDGET]])-SUMIFS(Cadeaus[KOSTEN],Cadeaus[ONTVANGER],Ontvangers[[#This Row],[ONTVANGER]])),\"\")","v":{"v":-1,"d":"-€ 1.00"}},1,{"$f":"IFERROR(Ontvangers[[#This Row],[GEPLAND AANTAL \nCADEAUS]]-COUNTIFS(Cadeaus[ONTVANGER],Ontvangers[[#This Row],[ONTVANGER]]), \"\")","v":0}]
[null,"Marty",{"v":0.1,"d":"10%"},{"$f":"IFERROR(IF(Adjust_Budget=\"Ja\",Allocated_Money_Remaining-SUMIFS(Cadeaus[KOSTEN],Cadeaus[ONTVANGER],Ontvangers[[#This Row],[ONTVANGER]]),(TotalBudget*Ontvangers[[#This Row],[GEPLAND % VAN BUDGET]])-SUMIFS(Cadeaus[KOSTEN],Cadeaus[ONTVANGER],Ontvangers[[#This Row],[ONTVANGER]])),\"\")","v":{"v":0,"d":"€ 0.00"}},1,{"$f":"IFERROR(Ontvangers[[#This Row],[GEPLAND AANTAL \nCADEAUS]]-COUNTIFS(Cadeaus[ONTVANGER],Ontvangers[[#This Row],[ONTVANGER]]), \"\")","v":0}]
[null,"Totaal",{"$f":"SUM(Ontvangers[GEPLAND % VAN BUDGET])","v":{"v":1,"d":"100%"}},{"$f":"IFERROR(SUM(Ontvangers[RESTEREND TOEGEWEZEN BEDRAG]),\"\")","v":{"v":109,"d":"€ 109.00"}},{"$f":"SUM(Ontvangers[GEPLAND AANTAL \nCADEAUS])","v":10},{"$f":"SUM(Ontvangers[RESTEREND AANTAL \nCADEAUS])","v":3}]

{"sheet":"Cadeaulijst","index":1,"n_rows":9,"n_cols":6,"rows_kept":9}
[null,"Kerstmis","CADEAULIJST"]
[null,"ONTVANGER","CADEAU","KOSTEN","GEKOCHT","INGEPAKT"]
[null,"Jenny","Poppenhuis",{"v":36,"d":"€ 36.00"},"Ja","Ja"]
[null,"Brian","Fiets",{"v":89,"d":"€ 89.00"},"Ja"]
[null,"Suzanne","Plakboekmaterialen",{"v":51,"d":"€ 51.00"},"Ja","Ja"]
[null,"Adam","Speelgoedtrein",{"v":48,"d":"€ 48.00"}]
[null,"Adam","Trui",{"v":57,"d":"€ 57.00"},"Ja"]
[null,"Marty","Geschenkbon",{"v":50,"d":"€ 50.00"},"Ja","Ja"]
[null,"Jenny","Jurk",{"v":60,"d":"€ 60.00"}]