{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["Budgetöversikt (hittills i år)","Månatliga utgifter","1000-Kontor","2000-Butik","3000-Personal","4000-Utrustning","5000-Övrigt"],"not_rendered":{"images":1,"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"Budgetöversikt (hittills i år)","index":0,"n_rows":10,"n_cols":6,"rows_kept":10,"merged":[[1,0,1,5]]}
[]
["2006: kostnader jämfört med budget hittills i år"]
[]
["Kontonr","Konto","Faktisk (hittils i år)","Budget (hittills i år)","Återstående budget i kr","Återstående budget %"]
[1000,"Kontor",{"$f":"'Månatliga utgifter'!O5","v":0},{"v":50000,"d":"50,000.00 kr"},{"$f":"SUM(D5-C5)","v":{"v":50000,"d":"50,000.00 kr"}},{"$f":"SUM(Tabell1[Återstående budget i kr]/Tabell1[Budget (hittills i år)])","v":{"v":1,"d":"100.00%"}}]
[2000,"Butik",{"$f":"'Månatliga utgifter'!O6","v":0},{"v":75000,"d":"75,000.00 kr"},{"$f":"SUM(D6-C6)","v":{"v":75000,"d":"75,000.00 kr"}},{"$f":"SUM(Tabell1[Återstående budget i kr]/Tabell1[Budget (hittills i år)])","v":{"v":1,"d":"100.00%"}}]
[3000,"Personal",{"$f":"'Månatliga utgifter'!O7","v":0},{"v":100000,"d":"100,000.00 kr"},{"$f":"SUM(D7-C7)","v":{"v":100000,"d":"100,000.00 kr"}},{"$f":"SUM(Tabell1[Återstående budget i kr]/Tabell1[Budget (hittills i år)])","v":{"v":1,"d":"100.00%"}}]
[4000,"Utrustning",{"$f":"'Månatliga utgifter'!O8","v":0},{"v":25000,"d":"25,000.00 kr"},{"$f":"SUM(D8-C8)","v":{"v":25000,"d":"25,000.00 kr"}},{"$f":"SUM(Tabell1[Återstående budget i kr]/Tabell1[Budget (hittills i år)])","v":{"v":1,"d":"100.00%"}}]
[5000,"Övrigt",{"$f":"'Månatliga utgifter'!O9","v":0},{"v":50000,"d":"50,000.00 kr"},{"$f":"SUM(D9-C9)","v":{"v":50000,"d":"50,000.00 kr"}},{"$f":"SUM(Tabell1[Återstående budget i kr]/Tabell1[Budget (hittills i år)])","v":{"v":1,"d":"100.00%"}}]
["Summa",null,{"$f":"SUBTOTAL(109,Tabell1[Faktisk (hittils i år)])","v":0},{"$f":"SUBTOTAL(109,Tabell1[Budget (hittills i år)])","v":{"v":300000,"d":"300,000.00 kr"}},{"$f":"SUBTOTAL(109,Tabell1[Återstående budget i kr])","v":{"v":300000,"d":"300,000.00 kr"}},{"$f":"Tabell1[[#Totals],[Återstående budget i kr]]/Tabell1[[#Totals],[Budget (hittills i år)]]","v":{"v":1,"d":"100.00%"}}]

{"sheet":"Månatliga utgifter","index":1,"n_rows":10,"n_cols":15,"rows_kept":10,"merged":[[1,0,1,14]]}
[]
["Månatliga utgifter 2006"]
[]
["Kontonr","Konto","jan-06","feb-06","mar-06","apr-06","maj-06","jun-06","jul-06","aug-06","sep-06","okt-06","nov-06","dec-06","Summa 2006"]
[1000,"Kontor",{"$f":"SUMIF('1000-Kontor'!$J:$J,\"=\"&(TEXT(C$4,\"mmm-yy\")),'1000-Kontor'!$E:$E)","v":0},{"$f":"SUMIF('1000-Kontor'!$J:$J,\"=\"&(TEXT(D$4,\"mmm-yy\")),'1000-Kontor'!$E:$E)","v":0},{"$f":"SUMIF('1000-Kontor'!$J:$J,\"=\"&(TEXT(E$4,\"mmm-yy\")),'1000-Kontor'!$E:$E)","v":0},{"$f":"SUMIF('1000-Kontor'!$J:$J,\"=\"&(TEXT(F$4,\"mmm-yy\")),'1000-Kontor'!$E:$E)","v":0},{"$f":"SUMIF('1000-Kontor'!$J:$J,\"=\"&(TEXT(G$4,\"mmm-yy\")),'1000-Kontor'!$E:$E)","v":0},{"$f":"SUMIF('1000-Kontor'!$J:$J,\"=\"&(TEXT(H$4,\"mmm-yy\")),'1000-Kontor'!$E:$E)","v":0},{"$f":"SUMIF('1000-Kontor'!$J:$J,\"=\"&(TEXT(I$4,\"mmm-yy\")),'1000-Kontor'!$E:$E)","v":0},{"$f":"SUMIF('1000-Kontor'!$J:$J,\"=\"&(TEXT(J$4,\"mmm-yy\")),'1000-Kontor'!$E:$E)","v":0},{"$f":"SUMIF('1000-Kontor'!$J:$J,\"=\"&(TEXT(K$4,\"mmm-yy\")),'1000-Kontor'!$E:$E)","v":0},{"$f":"SUMIF('1000-Kontor'!$J:$J,\"=\"&(TEXT(L$4,\"mmm-yy\")),'1000-Kontor'!$E:$E)","v":0},{"$f":"SUMIF('1000-Kontor'!$J:$J,\"=\"&(TEXT(M$4,\"mmm-yy\")),'1000-Kontor'!$E:$E)","v":0},{"$f":"SUMIF('1000-Kontor'!$J:$J,\"=\"&(TEXT(N$4,\"mmm-yy\")),'1000-Kontor'!$E:$E)","v":0},{"$f":"SUM(Tabell2[jan-06]+Tabell2[feb-06]+Tabell2[mar-06]+Tabell2[apr-06]+Tabell2[maj-06]+Tabell2[jun-06]+Tabell2[jul-06]+Tabell2[aug-06]+Tabell2[sep-06]+Tabell2[okt-06]+Tabell2[nov-06]+Tabell2[dec-06])","v":0}]
[2000,"Butik",{"$f":"SUMIF('2000-Butik'!$J:$J,\"=\"&(TEXT(C$4,\"mmm-yy\")),'2000-Butik'!$E:$E)","v":0},{"$f":"SUMIF('2000-Butik'!$J:$J,\"=\"&(TEXT(D$4,\"mmm-yy\")),'2000-Butik'!$E:$E)","v":0},{"$f":"SUMIF('2000-Butik'!$J:$J,\"=\"&(TEXT(E$4,\"mmm-yy\")),'2000-Butik'!$E:$E)","v":0},{"$f":"SUMIF('2000-Butik'!$J:$J,\"=\"&(TEXT(F$4,\"mmm-yy\")),'2000-Butik'!$E:$E)","v":0},{"$f":"SUMIF('2000-Butik'!$J:$J,\"=\"&(TEXT(G$4,\"mmm-yy\")),'2000-Butik'!$E:$E)","v":0},{"$f":"SUMIF('2000-Butik'!$J:$J,\"=\"&(TEXT(H$4,\"mmm-yy\")),'2000-Butik'!$E:$E)","v":0},{"$f":"SUMIF('2000-Butik'!$J:$J,\"=\"&(TEXT(I$4,\"mmm-yy\")),'2000-Butik'!$E:$E)","v":0},{"$f":"SUMIF('2000-Butik'!$J:$J,\"=\"&(TEXT(J$4,\"mmm-yy\")),'2000-Butik'!$E:$E)","v":0},{"$f":"SUMIF('2000-Butik'!$J:$J,\"=\"&(TEXT(K$4,\"mmm-yy\")),'2000-Butik'!$E:$E)","v":0},{"$f":"SUMIF('2000-Butik'!$J:$J,\"=\"&(TEXT(L$4,\"mmm-yy\")),'2000-Butik'!$E:$E)","v":0},{"$f":"SUMIF('2000-Butik'!$J:$J,\"=\"&(TEXT(M$4,\"mmm-yy\")),'2000-Butik'!$E:$E)","v":0},{"$f":"SUMIF('2000-Butik'!$J:$J,\"=\"&(TEXT(N$4,\"mmm-yy\")),'2000-Butik'!$E:$E)","v":0},{"$f":"SUM(Tabell2[jan-06]+Tabell2[feb-06]+Tabell2[mar-06]+Tabell2[apr-06]+Tabell2[maj-06]+Tabell2[jun-06]+Tabell2[jul-06]+Tabell2[aug-06]+Tabell2[sep-06]+Tabell2[okt-06]+Tabell2[nov-06]+Tabell2[dec-06])","v":0}]
[3000,"Personal",{"$f":"SUMIF('3000-Personal'!$J:$J,\"=\"&(TEXT(C$4,\"mmm-yy\")),'3000-Personal'!$E:$E)","v":0},{"$f":"SUMIF('3000-Personal'!$J:$J,\"=\"&(TEXT(D$4,\"mmm-yy\")),'3000-Personal'!$E:$E)","v":0},{"$f":"SUMIF('3000-Personal'!$J:$J,\"=\"&(TEXT(E$4,\"mmm-yy\")),'3000-Personal'!$E:$E)","v":0},{"$f":"SUMIF('3000-Personal'!$J:$J,\"=\"&(TEXT(F$4,\"mmm-yy\")),'3000-Personal'!$E:$E)","v":0},{"$f":"SUMIF('3000-Personal'!$J:$J,\"=\"&(TEXT(G$4,\"mmm-yy\")),'3000-Personal'!$E:$E)","v":0},{"$f":"SUMIF('3000-Personal'!$J:$J,\"=\"&(TEXT(H$4,\"mmm-yy\")),'3000-Personal'!$E:$E)","v":0},{"$f":"SUMIF('3000-Personal'!$J:$J,\"=\"&(TEXT(I$4,\"mmm-yy\")),'3000-Personal'!$E:$E)","v":0},{"$f":"SUMIF('3000-Personal'!$J:$J,\"=\"&(TEXT(J$4,\"mmm-yy\")),'3000-Personal'!$E:$E)","v":0},{"$f":"SUMIF('3000-Personal'!$J:$J,\"=\"&(TEXT(K$4,\"mmm-yy\")),'3000-Personal'!$E:$E)","v":0},{"$f":"SUMIF('3000-Personal'!$J:$J,\"=\"&(TEXT(L$4,\"mmm-yy\")),'3000-Personal'!$E:$E)","v":0},{"$f":"SUMIF('3000-Personal'!$J:$J,\"=\"&(TEXT(M$4,\"mmm-yy\")),'3000-Personal'!$E:$E)","v":0},{"$f":"SUMIF('3000-Personal'!$J:$J,\"=\"&(TEXT(N$4,\"mmm-yy\")),'3000-Personal'!$E:$E)","v":0},{"$f":"SUM(Tabell2[jan-06]+Tabell2[feb-06]+Tabell2[mar-06]+Tabell2[apr-06]+Tabell2[maj-06]+Tabell2[jun-06]+Tabell2[jul-06]+Tabell2[aug-06]+Tabell2[sep-06]+Tabell2[okt-06]+Tabell2[nov-06]+Tabell2[dec-06])","v":0}]
[4000,"Utrustning",{"$f":"SUMIF('4000-Utrustning'!$J:$J,\"=\"&(TEXT(C$4,\"mmm-yy\")),'4000-Utrustning'!$E:$E)","v":0},{"$f":"SUMIF('4000-Utrustning'!$J:$J,\"=\"&(TEXT(D$4,\"mmm-yy\")),'4000-Utrustning'!$E:$E)","v":0},{"$f":"SUMIF('4000-Utrustning'!$J:$J,\"=\"&(TEXT(E$4,\"mmm-yy\")),'4000-Utrustning'!$E:$E)","v":0},{"$f":"SUMIF('4000-Utrustning'!$J:$J,\"=\"&(TEXT(F$4,\"mmm-yy\")),'4000-Utrustning'!$E:$E)","v":0},{"$f":"SUMIF('4000-Utrustning'!$J:$J,\"=\"&(TEXT(G$4,\"mmm-yy\")),'4000-Utrustning'!$E:$E)","v":0},{"$f":"SUMIF('4000-Utrustning'!$J:$J,\"=\"&(TEXT(H$4,\"mmm-yy\")),'4000-Utrustning'!$E:$E)","v":0},{"$f":"SUMIF('4000-Utrustning'!$J:$J,\"=\"&(TEXT(I$4,\"mmm-yy\")),'4000-Utrustning'!$E:$E)","v":0},{"$f":"SUMIF('4000-Utrustning'!$J:$J,\"=\"&(TEXT(J$4,\"mmm-yy\")),'4000-Utrustning'!$E:$E)","v":0},{"$f":"SUMIF('4000-Utrustning'!$J:$J,\"=\"&(TEXT(K$4,\"mmm-yy\")),'4000-Utrustning'!$E:$E)","v":0},{"$f":"SUMIF('4000-Utrustning'!$J:$J,\"=\"&(TEXT(L$4,\"mmm-yy\")),'4000-Utrustning'!$E:$E)","v":0},{"$f":"SUMIF('4000-Utrustning'!$J:$J,\"=\"&(TEXT(M$4,\"mmm-yy\")),'4000-Utrustning'!$E:$E)","v":0},{"$f":"SUMIF('4000-Utrustning'!$J:$J,\"=\"&(TEXT(N$4,\"mmm-yy\")),'4000-Utrustning'!$E:$E)","v":0},{"$f":"SUM(Tabell2[jan-06]+Tabell2[feb-06]+Tabell2[mar-06]+Tabell2[apr-06]+Tabell2[maj-06]+Tabell2[jun-06]+Tabell2[jul-06]+Tabell2[aug-06]+Tabell2[sep-06]+Tabell2[okt-06]+Tabell2[nov-06]+Tabell2[dec-06])","v":0}]
[5000,"Övrigt",{"$f":"SUMIF('5000-Övrigt'!$J:$J,\"=\"&(TEXT(C$4,\"mmm-yy\")),'5000-Övrigt'!$E:$E)","v":0},{"$f":"SUMIF('5000-Övrigt'!$J:$J,\"=\"&(TEXT(D$4,\"mmm-yy\")),'5000-Övrigt'!$E:$E)","v":0},{"$f":"SUMIF('5000-Övrigt'!$J:$J,\"=\"&(TEXT(E$4,\"mmm-yy\")),'5000-Övrigt'!$E:$E)","v":0},{"$f":"SUMIF('5000-Övrigt'!$J:$J,\"=\"&(TEXT(F$4,\"mmm-yy\")),'5000-Övrigt'!$E:$E)","v":0},{"$f":"SUMIF('5000-Övrigt'!$J:$J,\"=\"&(TEXT(G$4,\"mmm-yy\")),'5000-Övrigt'!$E:$E)","v":0},{"$f":"SUMIF('5000-Övrigt'!$J:$J,\"=\"&(TEXT(H$4,\"mmm-yy\")),'5000-Övrigt'!$E:$E)","v":0},{"$f":"SUMIF('5000-Övrigt'!$J:$J,\"=\"&(TEXT(I$4,\"mmm-yy\")),'5000-Övrigt'!$E:$E)","v":0},{"$f":"SUMIF('5000-Övrigt'!$J:$J,\"=\"&(TEXT(J$4,\"mmm-yy\")),'5000-Övrigt'!$E:$E)","v":0},{"$f":"SUMIF('5000-Övrigt'!$J:$J,\"=\"&(TEXT(K$4,\"mmm-yy\")),'5000-Övrigt'!$E:$E)","v":0},{"$f":"SUMIF('5000-Övrigt'!$J:$J,\"=\"&(TEXT(L$4,\"mmm-yy\")),'5000-Övrigt'!$E:$E)","v":0},{"$f":"SUMIF('5000-Övrigt'!$J:$J,\"=\"&(TEXT(M$4,\"mmm-yy\")),'5000-Övrigt'!$E:$E)","v":0},{"$f":"SUMIF('5000-Övrigt'!$J:$J,\"=\"&(TEXT(N$4,\"mmm-yy\")),'5000-Övrigt'!$E:$E)","v":0},{"$f":"SUM(Tabell2[jan-06]+Tabell2[feb-06]+Tabell2[mar-06]+Tabell2[apr-06]+Tabell2[maj-06]+Tabell2[jun-06]+Tabell2[jul-06]+Tabell2[aug-06]+Tabell2[sep-06]+Tabell2[okt-06]+Tabell2[nov-06]+Tabell2[dec-06])","v":0}]
["Summa",null,{"$f":"SUBTOTAL(109,Tabell2[jan-06])","v":0},{"$f":"SUBTOTAL(109,Tabell2[feb-06])","v":0},{"$f":"SUBTOTAL(109,Tabell2[mar-06])","v":0},{"$f":"SUBTOTAL(109,Tabell2[apr-06])","v":0},{"$f":"SUBTOTAL(109,Tabell2[maj-06])","v":0},{"$f":"SUBTOTAL(109,Tabell2[jun-06])","v":0},{"$f":"SUBTOTAL(109,Tabell2[jul-06])","v":0},{"$f":"SUBTOTAL(109,Tabell2[aug-06])","v":0},{"$f":"SUBTOTAL(109,Tabell2[sep-06])","v":0},{"$f":"SUBTOTAL(109,Tabell2[okt-06])","v":0},{"$f":"SUBTOTAL(109,Tabell2[nov-06])","v":0},{"$f":"SUBTOTAL(109,Tabell2[dec-06])","v":0},{"$f":"SUBTOTAL(109,Tabell2[Summa 2006])","v":0}]

{"sheet":"1000-Kontor","index":2,"n_rows":6,"n_cols":10,"rows_kept":6}
["Huvudbok - Utgifter","Fakturadatum","Fakturanummer","Begärd av","Räkningens belopp","Betalningsmottagare","Räkning för","Betalningssätt","Bokföringsdatum","Konstruerat nyckelfält"]
[1000,{"v":38732,"d":"3873200.00%"},1,"David Daniels",{"v":100,"d":"100.00 kr"},"Consolidated Messenger ","Tomma CD-skivor","Kredit",{"v":38737,"d":"3873700.00%"},{"$f":"TEXT(B2,\"mmm-yy\")","v":"Jan-06"}]
[1000,"2006-02-07",5,"David Daniels",{"v":50,"d":"50.00 kr"},"Consolidated Messenger ","Skrivarpatron","Kredit",{"v":38758,"d":"3875800.00%"},{"$f":"TEXT(B3,\"mmm-yy\")","v":"Feb-06"}]
[1000,"2006-02-15",10,"David Daniels",{"v":275,"d":"275.00 kr"},"Acme","Kontor allmänt","Kredit",{"v":38758,"d":"3875800.00%"},{"$f":"TEXT(B4,\"mmm-yy\")","v":"Feb-06"}]
[1000,{"$nulls":8},{"$f":"TEXT(B5,\"mmm-yy\")","v":"Jan-00"}]
["Summa",{"$nulls":3},{"$f":"SUBTOTAL(109,Tabell3[Räkningens belopp])","v":{"v":425,"d":"425.00 kr"}}]

{"sheet":"2000-Butik","index":3,"n_rows":5,"n_cols":10,"rows_kept":5}
["Huvudbok - Utgifter","Fakturadatum","Fakturanummer","Begärd av","Räkningens belopp","Betalningsmottagare","Räkning för","Betalningssätt","Bokföringsdatum","Konstruerat nyckelfält"]
[2000,{"v":38734,"d":"3873400.00%"},2,"Marc Faeber",{"v":550,"d":"550.00 kr"},"Fabrikam, Inc. ","Fönsterbyte i butik","Kredit",{"v":38737,"d":"3873700.00%"},{"$f":"TEXT(B2,\"mmm-yy\")","v":"Jan-06"}]
[2000,"2006-01-19",3,"Marc Faeber",{"v":355.27,"d":"355.27 kr"},"A. Datum Corporation ","Ny kassaapparat","Kredit",{"v":38737,"d":"3873700.00%"},{"$f":"TEXT(B3,\"mmm-yy\")","v":"Jan-06"}]
[2000,{"$nulls":8},{"$f":"TEXT(B4,\"mmm-yy\")","v":"Jan-00"}]
["Summa",{"$nulls":3},{"$f":"SUBTOTAL(109,Tabell4[Räkningens belopp])","v":{"v":905.27,"d":"905.27 kr"}}]

{"sheet":"3000-Personal","index":4,"n_rows":5,"n_cols":10,"rows_kept":5}
["Huvudbok - Utgifter","Fakturadatum","Fakturanummer","Begärd av","Räkningens belopp","Betalningsmottagare","Räkning för","Betalningssätt","Bokföringsdatum","Konstruerat nyckelfält"]
[3000,{"v":38758,"d":"3875800.00%"},6,"Robert O'Hara",{"v":2500,"d":"2,500.00 kr"},"Graphic Design Institute ","kontraktera designer","Check",{"v":38768,"d":"3876800.00%"},{"$f":"TEXT(B2,\"mmm-yy\")","v":"Feb-06"}]
[3000,"2006-02-15",11,"Sandeep Kaliyath",{"v":15000,"d":"15,000.00 kr"},"Adventure Works","kontraktera skribent","Check",{"v":38768,"d":"3876800.00%"},{"$f":"TEXT(B3,\"mmm-yy\")","v":"Feb-06"}]
[3000,{"$nulls":8},{"$f":"TEXT(B4,\"mmm-yy\")","v":"Jan-00"}]
["Summa",{"$nulls":3},{"$f":"SUBTOTAL(109,Tabell5[Räkningens belopp])","v":{"v":17500,"d":"17,500.00 kr"}}]

{"sheet":"4000-Utrustning","index":5,"n_rows":4,"n_cols":10,"rows_kept":4}
["Huvudbok - Utgifter","Fakturadatum","Fakturanummer","Begärd av","Räkningens belopp","Betalningsmottagare","Räkning för","Betalningssätt","Bokföringsdatum","Konstruerat nyckelfält"]
[4000,{"v":38742,"d":"3874200.00%"},5,"Robert Walters",{"v":1854,"d":"1,854.00 kr"},"Trey Research ","Ny bärbar dator","Kredit",{"v":38742,"d":"3874200.00%"},{"$f":"TEXT(B2,\"mmm-yy\")","v":"Jan-06"}]
[4000,{"$nulls":8},{"$f":"TEXT(B3,\"mmm-yy\")","v":"Jan-00"}]
["Summa",{"$nulls":3},{"$f":"SUBTOTAL(109,Tabell6[Räkningens belopp])","v":{"v":1854,"d":"1,854.00 kr"}}]

{"sheet":"5000-Övrigt","index":6,"n_rows":4,"n_cols":10,"rows_kept":4}
["Huvudbok - Utgifter","Fakturadatum","Fakturanummer","Begärd av","Räkningens belopp","Betalningsmottagare","Räkning för","Betalningssätt","Bokföringsdatum","Konstruerat nyckelfält"]
[5000,{"v":38740,"d":"3874000.00%"},4,"Bob Gage",{"v":35.6,"d":"35.60 kr"},"Bob Gage","Taxi","Check",{"v":38740,"d":"3874000.00%"},{"$f":"TEXT(B2,\"mmm-yy\")","v":"Jan-06"}]
[5000,{"$nulls":8},{"$f":"TEXT(B3,\"mmm-yy\")","v":"Jan-00"}]
["Summa",{"$nulls":3},{"$f":"SUBTOTAL(109,Tabell7[Räkningens belopp])","v":{"v":35.6,"d":"35.60 kr"}}]