{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Sammanfattning","Lista över presenter"],"not_rendered":{"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"Sammanfattning","index":0,"n_rows":11,"n_cols":6,"rows_kept":11,"merged":[[0,1,2,1],[0,2,2,3]]}
[null,"helgdag","PRESENTÖVERSIKT",null,"TOTAL BUDGET",{"v":500,"d":"500.00 kr"}]
[{"$nulls":4},"SPENDERAT",{"$f":"IFERROR(SUMIFS(Gåvor[KOSTNAD],Gåvor[KÖPT],\"Ja\"),\"\")","v":{"v":283,"d":"283.00 kr"}}]
[{"$nulls":4},"ÅTERSTÅENDE BUDGET",{"$f":"IFERROR(TotalBudget-F2,\"\")","v":{"v":217,"d":"217.00 kr"}}]
[null,"Justera budget om procentandelen av den planerade budgeten överskrider 100 % (Ja/Nej)?",null,"Ja"]
[null,"MOTTAGARE","PLANERAD PROCENTANDEL AV BUDGET","ÅTERSTÅENDE AVSATTA MEDEL","PLANERAD PROCENTANDEL AV PRESENTER","ÅTERSTÅENDE PRESENTER"]
[null,"Alexander",{"v":0.3,"d":"30%"},{"$f":"IFERROR(IF(Justera_Budget=\"Ja\",Avsatta_Medel_Återstående-SUMIFS(Gåvor[KOSTNAD],Gåvor[MOTTAGARE],Mottagare[[#This Row],[MOTTAGARE]]),(TotalBudget*Mottagare[[#This Row],[PLANERAD PROCENTANDEL AV BUDGET]])-SUMIFS(Gåvor[KOSTNAD],Gåvor[MOTTAGARE],Mottagare[[#This Row],[MOTTAGARE]])),\"\")","v":{"v":45,"d":"45.00 kr"}},3,{"$f":"IFERROR(Mottagare[[#This Row],[PLANERAD PROCENTANDEL AV PRESENTER]]-COUNTIFS(Gåvor[MOTTAGARE],Mottagare[[#This Row],[MOTTAGARE]]), \"\")","v":1}]
[null,"Jeanette",{"v":0.3,"d":"30%"},{"$f":"IFERROR(IF(Justera_Budget=\"Ja\",Avsatta_Medel_Återstående-SUMIFS(Gåvor[KOSTNAD],Gåvor[MOTTAGARE],Mottagare[[#This Row],[MOTTAGARE]]),(TotalBudget*Mottagare[[#This Row],[PLANERAD PROCENTANDEL AV BUDGET]])-SUMIFS(Gåvor[KOSTNAD],Gåvor[MOTTAGARE],Mottagare[[#This Row],[MOTTAGARE]])),\"\")","v":{"v":54,"d":"54.00 kr"}},3,{"$f":"IFERROR(Mottagare[[#This Row],[PLANERAD PROCENTANDEL AV PRESENTER]]-COUNTIFS(Gåvor[MOTTAGARE],Mottagare[[#This Row],[MOTTAGARE]]), \"\")","v":1}]
[null,"Erik",{"v":0.2,"d":"20%"},{"$f":"IFERROR(IF(Justera_Budget=\"Ja\",Avsatta_Medel_Återstående-SUMIFS(Gåvor[KOSTNAD],Gåvor[MOTTAGARE],Mottagare[[#This Row],[MOTTAGARE]]),(TotalBudget*Mottagare[[#This Row],[PLANERAD PROCENTANDEL AV BUDGET]])-SUMIFS(Gåvor[KOSTNAD],Gåvor[MOTTAGARE],Mottagare[[#This Row],[MOTTAGARE]])),\"\")","v":{"v":11,"d":"11.00 kr"}},2,{"$f":"IFERROR(Mottagare[[#This Row],[PLANERAD PROCENTANDEL AV PRESENTER]]-COUNTIFS(Gåvor[MOTTAGARE],Mottagare[[#This Row],[MOTTAGARE]]), \"\")","v":1}]
[null,"Sanna",{"v":0.1,"d":"10%"},{"$f":"IFERROR(IF(Justera_Budget=\"Ja\",Avsatta_Medel_Återstående-SUMIFS(Gåvor[KOSTNAD],Gåvor[MOTTAGARE],Mottagare[[#This Row],[MOTTAGARE]]),(TotalBudget*Mottagare[[#This Row],[PLANERAD PROCENTANDEL AV BUDGET]])-SUMIFS(Gåvor[KOSTNAD],Gåvor[MOTTAGARE],Mottagare[[#This Row],[MOTTAGARE]])),\"\")","v":{"v":-1,"d":"-1.00 kr"}},1,{"$f":"IFERROR(Mottagare[[#This Row],[PLANERAD PROCENTANDEL AV PRESENTER]]-COUNTIFS(Gåvor[MOTTAGARE],Mottagare[[#This Row],[MOTTAGARE]]), \"\")","v":0}]
[null,"Mattias",{"v":0.1,"d":"10%"},{"$f":"IFERROR(IF(Justera_Budget=\"Ja\",Avsatta_Medel_Återstående-SUMIFS(Gåvor[KOSTNAD],Gåvor[MOTTAGARE],Mottagare[[#This Row],[MOTTAGARE]]),(TotalBudget*Mottagare[[#This Row],[PLANERAD PROCENTANDEL AV BUDGET]])-SUMIFS(Gåvor[KOSTNAD],Gåvor[MOTTAGARE],Mottagare[[#This Row],[MOTTAGARE]])),\"\")","v":{"v":0,"d":"0.00 kr"}},1,{"$f":"IFERROR(Mottagare[[#This Row],[PLANERAD PROCENTANDEL AV PRESENTER]]-COUNTIFS(Gåvor[MOTTAGARE],Mottagare[[#This Row],[MOTTAGARE]]), \"\")","v":0}]
[null,"Summa",{"$f":"SUM(Mottagare[PLANERAD PROCENTANDEL AV BUDGET])","v":{"v":1,"d":"100%"}},{"$f":"IFERROR(SUM(Mottagare[ÅTERSTÅENDE AVSATTA MEDEL]),\"\")","v":{"v":109,"d":"109.00 kr"}},{"$f":"SUM(Mottagare[PLANERAD PROCENTANDEL AV PRESENTER])","v":10},{"$f":"SUM(Mottagare[ÅTERSTÅENDE PRESENTER])","v":3}]

{"sheet":"Lista över presenter","index":1,"n_rows":9,"n_cols":6,"rows_kept":9}
[null,"helgdag","LISTA ÖVER PRESENTER"]
[null,"MOTTAGARE","PRESENT","KOSTNAD","KÖPT","INSLAGEN"]
[null,"Jeanette","Dockhus",{"v":36,"d":"36.00 kr"},"Ja","Ja"]
[null,"Erik","Cykel",{"v":89,"d":"89.00 kr"},"Ja"]
[null,"Sanna","Klippboksmaterial",{"v":51,"d":"51.00 kr"},"Ja","Ja"]
[null,"Alexander","Leksakståg",{"v":48,"d":"48.00 kr"}]
[null,"Alexander","Tröja",{"v":57,"d":"57.00 kr"},"Ja"]
[null,"Mattias","Presentkort",{"v":50,"d":"50.00 kr"},"Ja","Ja"]
[null,"Jeanette","Klänning",{"v":60,"d":"60.00 kr"}]