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

{"sheet":"Oversigt","index":0,"n_rows":11,"n_cols":6,"rows_kept":11,"merged":[[0,1,2,1],[0,2,2,3]]}
[null,"ferie","GAVEREGISTRERING",null,"SAMLET BUDGET",{"v":500,"d":"500.00 kr."}]
[{"$nulls":4},"BRUGT",{"$f":"IFERROR(SUMIFS(Gaver[OMKOSTNING],Gaver[KØBT],\"Ja\"),\"\")","v":{"v":283,"d":"283.00 kr."}}]
[{"$nulls":4},"RESTERENDE BUDGET",{"$f":"IFERROR(TotalBudget-F2,\"\")","v":{"v":217,"d":"217.00 kr."}}]
[null,"Juster budget, hvis % af planlagt budget overstiger 100 % (Ja/Nej)?",null,"Ja"]
[null,"MODTAGER","PLANLAGT % AF BUDGET","RESTERENDE TILDELTE PENGE","PLANLAGT ANTAL GAVER","RESTERENDE GAVER"]
[null,"Adam",{"v":0.3,"d":"30%"},{"$f":"IFERROR(IF(Juster_Budget=\"Ja\",Tildelte_Penge_Resterende-SUMIFS(Gaver[OMKOSTNING],Gaver[MODTAGER],Modtagere[[#This Row],[MODTAGER]]),(TotalBudget*Modtagere[[#This Row],[PLANLAGT % AF BUDGET]])-SUMIFS(Gaver[OMKOSTNING],Gaver[MODTAGER],Modtagere[[#This Row],[MODTAGER]])),\"\")","v":{"v":45,"d":"45.00 kr."}},3,{"$f":"IFERROR(Modtagere[[#This Row],[PLANLAGT ANTAL GAVER]]-COUNTIFS(Gaver[MODTAGER],Modtagere[[#This Row],[MODTAGER]]), \"\")","v":1}]
[null,"Jenny",{"v":0.3,"d":"30%"},{"$f":"IFERROR(IF(Juster_Budget=\"Ja\",Tildelte_Penge_Resterende-SUMIFS(Gaver[OMKOSTNING],Gaver[MODTAGER],Modtagere[[#This Row],[MODTAGER]]),(TotalBudget*Modtagere[[#This Row],[PLANLAGT % AF BUDGET]])-SUMIFS(Gaver[OMKOSTNING],Gaver[MODTAGER],Modtagere[[#This Row],[MODTAGER]])),\"\")","v":{"v":54,"d":"54.00 kr."}},3,{"$f":"IFERROR(Modtagere[[#This Row],[PLANLAGT ANTAL GAVER]]-COUNTIFS(Gaver[MODTAGER],Modtagere[[#This Row],[MODTAGER]]), \"\")","v":1}]
[null,"Brian",{"v":0.2,"d":"20%"},{"$f":"IFERROR(IF(Juster_Budget=\"Ja\",Tildelte_Penge_Resterende-SUMIFS(Gaver[OMKOSTNING],Gaver[MODTAGER],Modtagere[[#This Row],[MODTAGER]]),(TotalBudget*Modtagere[[#This Row],[PLANLAGT % AF BUDGET]])-SUMIFS(Gaver[OMKOSTNING],Gaver[MODTAGER],Modtagere[[#This Row],[MODTAGER]])),\"\")","v":{"v":11,"d":"11.00 kr."}},2,{"$f":"IFERROR(Modtagere[[#This Row],[PLANLAGT ANTAL GAVER]]-COUNTIFS(Gaver[MODTAGER],Modtagere[[#This Row],[MODTAGER]]), \"\")","v":1}]
[null,"Suzanne",{"v":0.1,"d":"10%"},{"$f":"IFERROR(IF(Juster_Budget=\"Ja\",Tildelte_Penge_Resterende-SUMIFS(Gaver[OMKOSTNING],Gaver[MODTAGER],Modtagere[[#This Row],[MODTAGER]]),(TotalBudget*Modtagere[[#This Row],[PLANLAGT % AF BUDGET]])-SUMIFS(Gaver[OMKOSTNING],Gaver[MODTAGER],Modtagere[[#This Row],[MODTAGER]])),\"\")","v":{"v":-1,"d":"-1.00 kr."}},1,{"$f":"IFERROR(Modtagere[[#This Row],[PLANLAGT ANTAL GAVER]]-COUNTIFS(Gaver[MODTAGER],Modtagere[[#This Row],[MODTAGER]]), \"\")","v":0}]
[null,"Marty",{"v":0.1,"d":"10%"},{"$f":"IFERROR(IF(Juster_Budget=\"Ja\",Tildelte_Penge_Resterende-SUMIFS(Gaver[OMKOSTNING],Gaver[MODTAGER],Modtagere[[#This Row],[MODTAGER]]),(TotalBudget*Modtagere[[#This Row],[PLANLAGT % AF BUDGET]])-SUMIFS(Gaver[OMKOSTNING],Gaver[MODTAGER],Modtagere[[#This Row],[MODTAGER]])),\"\")","v":{"v":0,"d":"0.00 kr."}},1,{"$f":"IFERROR(Modtagere[[#This Row],[PLANLAGT ANTAL GAVER]]-COUNTIFS(Gaver[MODTAGER],Modtagere[[#This Row],[MODTAGER]]), \"\")","v":0}]
[null,"I alt",{"$f":"SUM(Modtagere[PLANLAGT % AF BUDGET])","v":{"v":1,"d":"100%"}},{"$f":"IFERROR(SUM(Modtagere[RESTERENDE TILDELTE PENGE]),\"\")","v":{"v":109,"d":"109.00 kr."}},{"$f":"SUM(Modtagere[PLANLAGT ANTAL GAVER])","v":10},{"$f":"SUM(Modtagere[RESTERENDE GAVER])","v":3}]

{"sheet":"Gaveliste","index":1,"n_rows":9,"n_cols":6,"rows_kept":9}
[null,"ferie","GAVELISTE"]
[null,"MODTAGER","GAVE","OMKOSTNING","KØBT","PAKKET IND"]
[null,"Jenny","Dukkehus",{"v":36,"d":"36.00 kr."},"Ja","Ja"]
[null,"Brian","Cykel",{"v":89,"d":"89.00 kr."},"Ja"]
[null,"Suzanne","Scrapbogsmaterialer",{"v":51,"d":"51.00 kr."},"Ja","Ja"]
[null,"Adam","Legetøjstog",{"v":48,"d":"48.00 kr."}]
[null,"Adam","Sweater",{"v":57,"d":"57.00 kr."},"Ja"]
[null,"Marty","Gavekort",{"v":50,"d":"50.00 kr."},"Ja","Ja"]
[null,"Jenny","Kjole",{"v":60,"d":"60.00 kr."}]