{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Meny","Inventar og utstyr","Kjøp av bruktbil","Kjøp av ny bil","Kjøp av lånefin. bil","Liste","Lønn og sos.kostn","Fordeling lønn"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":24,"comments":5,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Meny","index":0,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":false,"merged":[[4,1,5,4]]}
[]
[]
[null,null,"Versjon:",1.1000000000000001]
[]
[null,"MENY"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Sats for SPK:",null,0.13]
[]
[null,"Sats for KLP:",null,0.1133]

{"sheet":"Inventar og utstyr","index":1,"n_rows":60,"n_cols":12,"rows_kept":60,"cut":false,"hidden":false,"merged":[[40,10,40,11],[1,1,2,9],[53,4,53,5],[6,3,6,4]]}
[]
[null,"Kjøp av inventar og utstyr"]
[]
[]
[]
[null,null,"Regnskap:"]
[null,null,"Tekst:","Hva kjøpes inn?"]
[]
[null,null,"Fakturabeløp inkl. mva:",null,{"$f":"IF(D9=\"\",\"Tast inn fakturabeløp inkl. mva\",\"\")","v":"Tast inn fakturabeløp inkl. mva"}]
[]
[null,null,"Eget prosj. nr:",null,{"$f":"IF(D11=\"\",\"Svar ja/nei\",\"\")","v":"Svar ja/nei"}]
[]
[null,null,{"$f":"IF(D11=\"Ja\",\"Prosjektnr:\",\"\")","v":""}]
[]
[]
[null,null,"Hvor skal kostnadene belastes i investeringsregnskapet?"]
[null,null,"Bokføres av:","Konto","Tjeneste","Ansvar ","Prosjekt","Avg.","Beløp"]
[null,null,"Økonomi",null,null,null,{"$f":"IF(D11=\"Ja\",D13,9998)","v":9998},null,{"$f":"D9","v":0}]
[null,null,"Etat/Økonomi","09700",88070,900000,"0000",null,{"$f":"-D9+I21","v":0}]
[null,null,"Etat/Økonomi",15700,{"$f":"E18","v":0},{"$f":"F18","v":0},{"$f":"G18","v":9998},null,{"$f":"D9+I22","v":0}]
[null,null,"Økonomi",{"$f":"IF($H$18<>0,\"0\"&4290,\"\")","v":""},{"$f":"IF(H18<>0,E18,\"\")","v":""},{"$f":"IF(H18<>0,F18,\"\")","v":""},{"$f":"IF(H18<>0,G18,\"\")","v":""},null,{"$f":"IF(H18<>0,D9-(D9/(VLOOKUP(H18,test,2)+1)),0)","v":0}]
[null,null,"Økonomi",{"$f":"IF($H$18<>0,\"0\"&7290,\"\")","v":""},{"$f":"IF(H18<>0,84100,\"\")","v":""},{"$f":"IF(H18<>0,990000,\"\")","v":""},{"$f":"IF(H18<>0,\"0000\",\"\")","v":""},null,{"$f":"IF(H18<>0,-I21,0)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(I18:I22)","v":0}]
[]
[]
[null,null,"Budsjett:"]
[]
[null,null,"Inndekning av kostnader i investeringsregnskapet:"]
[null,null,"Reguleres av:","Konto","Tjeneste","Ansvar ","Prosjekt","Beløp"]
[null,null,"Etat/Økonomi",{"$f":"D18","v":0},{"$f":"E18","v":0},{"$f":"F18","v":0},{"$f":"G18","v":9998},{"$f":"ROUND(I18-I21,-2)","v":0}]
[null,null,"Etat/Økonomi",{"$f":"D19","v":"09700"},{"$f":"E19","v":88070},900000,"0000",{"$f":"ROUND(I19,-2)","v":0}]
[null,null,"Etat/Økonomi",{"$f":"D20","v":15700},0,0,9998,{"$f":"ROUND(I20,-2)","v":0}]
[null,null,"Etat/Økonomi",{"$f":"D21","v":""},"","","",{"$f":"IF(I21<>\"\",ROUND(I21,-2),\"\")","v":0}]
[null,null,"Etat/Økonomi","","","","",{"$f":"IF(I22<>\"\",ROUND(I22,-2),\"\")","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(H30:H34)","v":0}]
[null,null,"Alt.1"]
[null,null,"Hvilke(n) driftskonto(er) skal finansiere investeringen?"]
[null,null,"Reguleres av:","Konto","Tjeneste","Ansvar ","Prosjekt","Mva komp.","Beløp"]
[null,null,"Etat/Økonomi",null,null,null,null,null,{"$f":"-H30-I42-I45-H57-H58-H59","v":0}]
[null,null,"Etat/Økonomi",14290,{"$f":"E39","v":0},{"$f":"F39","v":0},{"$f":"G39","v":0},null,{"$f":"ROUND((I39*(1+VLOOKUP(H39,mvadrift,2))-I39),-2)","v":0}]
[null,null,"Etat/Økonomi",17290,{"$f":"E39","v":0},{"$f":"F39","v":0},{"$f":"G39","v":0},null,{"$f":"-I40","v":0},null,"Kontroll"]
[null,null,"Etat/Økonomi",null,null,null,null,null,null,null,{"$f":"IF((I42-ROUND(I42,-2))<>0,\"Kun beløp i hele 100\",\"\")","v":""},{"$f":"IF(I42>0,\"Beløp skal ha negativt fortegn\",\"\")","v":""}]
[null,null,"Etat/Økonomi",14290,{"$f":"E42","v":0},{"$f":"F42","v":0},{"$f":"G42","v":0},null,{"$f":"ROUND((I42*(1+VLOOKUP(H42,mvadrift,2))-I42),-2)","v":0}]
[null,null,"Etat/Økonomi",17290,{"$f":"E42","v":0},{"$f":"F42","v":0},{"$f":"G42","v":0},null,{"$f":"-I43","v":0}]
[null,null,"Etat/Økonomi",null,null,null,null,null,null,null,{"$f":"IF((I45-ROUND(I45,-2))<>0,\"Kun beløp i hele 100\",\"\")","v":""},{"$f":"IF(I45>0,\"G50 skal være < 0\",\"\")","v":""}]
[null,null,"Etat/Økonomi",14290,{"$f":"E45","v":0},{"$f":"F45","v":0},{"$f":"G45","v":0},null,{"$f":"ROUND((I45*(1+VLOOKUP(H45,mvadrift,2))-I45),-2)","v":0}]
[null,null,"Etat/Økonomi",17290,{"$f":"E45","v":0},{"$f":"F45","v":0},{"$f":"G45","v":0},null,{"$f":"-I46","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(I39:I47)","v":0}]
[null,null,"Alt.2"]
[null,null,"Eventuelt fra lønnskonto/ufordelt konto?"]
[]
[null,null,"Beløp inkl. sos.kostnader:",null,null,null,null,null,null,null,{"$f":"IF((E52-ROUND(E52,-2))<>0,\"Kun beløp i hele 100\",\"\")","v":""},{"$f":"IF(E52>0,\"F54 skal være < 0\",\"\")","v":""}]
[]
[null,null,"Satser:",null,null,null,{"$f":"IF(E54<>\"\",\"\",\"Velg sats for pensjon og arb.giveravgift\")","v":"Velg sats for pensjon og arb.giveravgift"}]
[]
[null,null,"Reguleres av:","Konto","Tjeneste","Ansvar ","Prosjekt","Beløp"]
[null,null,"Etat/Økonomi",null,null,null,null,{"$f":"IF(E52<>\"\",ROUND(E52*VLOOKUP(E54,sosialtabell,2),-2),0)","v":0},null,null,{"$f":"IF((H57-ROUND(H57,-2))<>0,\"Kun beløp i hele 100\",\"\")","v":""},{"$f":"IF(H57>0,\"G60 skal være < 0\",\"\")","v":""}]
[null,null,"Etat/Økonomi",{"$f":"VLOOKUP(E54,sosialtabell,5)","v":{"$error":"#N/A"}},{"$f":"E57","v":0},{"$f":"F57","v":0},{"$f":"G57","v":0},{"$f":"IF(E52<>\"\",ROUND(E52*VLOOKUP(E54,sosialtabell,3),-2),0)","v":0},null,null,{"$f":"IF((H58-ROUND(H58,-2))<>0,\"Kun beløp i hele 100\",\"\")","v":""},{"$f":"IF(H58>0,\"G61 skal være < 0\",\"\")","v":""}]
[null,null,"Etat/Økonomi",10990,{"$f":"E57","v":0},{"$f":"F57","v":0},{"$f":"G57","v":0},{"$f":"ROUND(E52-H57-H58,-2)","v":0},null,null,{"$f":"IF((H59-ROUND(H59,-2))<>0,\"Kun beløp i hele 100\",\"\")","v":""},{"$f":"IF(H59>0,\"G62 skal være < 0\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"SUM(H57:H59)","v":0}]

{"sheet":"Kjøp av bruktbil","index":2,"n_rows":61,"n_cols":12,"rows_kept":61,"cut":false,"hidden":false,"merged":[[1,1,2,9],[54,4,54,5],[41,10,41,11],[6,3,6,4]]}
[]
[null,"Kjøp av bruktbil"]
[]
[]
[]
[null,null,"Regnskap:"]
[null,null,"Tekst:","Hva kjøpes inn?"]
[]
[null,null,"Kjøpesum:",null,{"$f":"IF(D9=\"\",\"Tast inn kjøpspris bruktbil. Evt. innbyttebil skal ikke tas med NB! Ingen mva på bruktbil\",\"\")","v":"Tast inn kjøpspris bruktbil. Evt. innbyttebil skal ikke tas med NB! Ingen mva på bruktbil"}]
[]
[null,null,"Eget prosj.nr:",null,{"$f":"IF(D11=\"\",\"Svar ja/nei\",\"\")","v":"Svar ja/nei"}]
[]
[null,null,{"$f":"IF(D11=\"Ja\",\"Prosjektnr:\",\"\")","v":""}]
[]
[null,null,"Innbyttebil:",null,{"$f":"IF(D15<>\"\",\"\",\"Svar ja/nei\")","v":"Svar ja/nei"}]
[]
[null,null,{"$f":"IF(D15=\"Ja\",\"Salgssum:\",\"\")","v":""}]
[]
[null,null,"Hvor skal kostnadene belastes i investeringsregnskapet?"]
[null,null,"Bokføres av:","Konto","Tjeneste","Ansvar ","Prosjekt","Avg.","Beløp"]
[null,null,"Økonomi","02101",null,null,{"$f":"IF(D11=\"Ja\",D13,9998)","v":9998},0,{"$f":"D9","v":0}]
[null,null,"Etat/Økonomi","09700",88070,900000,"0000",null,{"$f":"-D9+D17","v":0}]
[null,null,"Etat/Økonomi",15700,{"$f":"E21","v":0},{"$f":"F21","v":0},{"$f":"G21","v":9998},null,{"$f":"-I22","v":0}]
[null,null,"Økonomi",{"$f":"IF(D15=\"Ja\",\"06603\",\"\")","v":""},{"$f":"IF(D15=\"Ja\",E23,\"\")","v":""},{"$f":"IF(D15=\"Ja\",F23,\"\")","v":""},{"$f":"IF(D15=\"Ja\",G23,\"\")","v":""},null,{"$f":"IF(D15=\"Ja\",-D17,\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"SUM(I21:I24)","v":0}]
[]
[]
[null,null,"Budsjett:"]
[]
[null,null,"Inndekning av kostnader i investeringsregnskapet:"]
[null,null,"Reguleres av:","Konto","Tjeneste","Ansvar ","Prosjekt","Beløp"]
[null,null,"Etat/Økonomi",{"$f":"D21","v":"02101"},0,0,9998,{"$f":"ROUND(D9,-2)","v":0}]
[null,null,"Etat/Økonomi","09700",88070,900000,"0000",{"$f":"ROUND(I22,-2)","v":0}]
[null,null,"Etat/Økonomi",15700,0,0,9998,{"$f":"-H33","v":0}]
[null,null,"Etat/Økonomi",{"$f":"IF(D24<>\"\",D24,\"\")","v":""},{"$f":"E24","v":""},{"$f":"F24","v":""},{"$f":"G24","v":""},{"$f":"IF(D15=\"Ja\",ROUND(I24,-2),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"SUM(H32:H35)","v":0}]
[null,null,"Alt.1"]
[null,null,"Hvilke(n) driftskonto(er) skal finansiere investeringen?"]
[null,null,"Reguleres av:","Konto","Tjeneste","Ansvar ","Prosjekt","Mva komp.","Beløp"]
[null,null,"Etat/Økonomi",null,null,null,null,null,{"$f":"-H34-I43-I46-H58-H59-H60","v":0}]
[null,null,"Etat/Økonomi",14290,{"$f":"E40","v":0},{"$f":"F40","v":0},{"$f":"G40","v":0},null,{"$f":"ROUND((I40*(1+VLOOKUP(H40,mvadrift,2))-I40),-2)","v":0}]
[null,null,"Etat/Økonomi",17290,{"$f":"E40","v":0},{"$f":"F40","v":0},{"$f":"G40","v":0},null,{"$f":"-I41","v":0},null,"Kontroll"]
[null,null,"Etat/Økonomi",null,null,null,null,null,null,null,{"$f":"IF((I43-ROUND(I43,-2))<>0,\"Kun beløp i hele 100\",\"\")","v":""},{"$f":"IF(I43>0,\"Beløp skal ha negativt fortegn\",\"\")","v":""}]
[null,null,"Etat/Økonomi",14290,{"$f":"E43","v":0},{"$f":"F43","v":0},{"$f":"G43","v":0},null,{"$f":"ROUND((I43*(1+VLOOKUP(H43,mvadrift,2))-I43),-2)","v":0}]
[null,null,"Etat/Økonomi",17290,{"$f":"E43","v":0},{"$f":"F43","v":0},{"$f":"G43","v":0},null,{"$f":"-I44","v":0}]
[null,null,"Etat/Økonomi",null,null,null,null,null,null,null,{"$f":"IF((I46-ROUND(I46,-2))<>0,\"Kun beløp i hele 100\",\"\")","v":""},{"$f":"IF(I46>0,\"G50 skal være < 0\",\"\")","v":""}]
[null,null,"Etat/Økonomi",14290,{"$f":"E46","v":0},{"$f":"F46","v":0},{"$f":"G46","v":0},null,{"$f":"ROUND((I46*(1+VLOOKUP(H46,mvadrift,2))-I46),-2)","v":0}]
[null,null,"Etat/Økonomi",17290,{"$f":"E46","v":0},{"$f":"F46","v":0},{"$f":"G46","v":0},null,{"$f":"-I47","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(I40:I48)","v":0}]
[null,null,"Alt.2"]
[null,null,"Eventuelt fra lønnskonto/ufordelt konto?"]
[]
[null,null,"Beløp inkl. sos.kostnader:",null,null,null,null,null,null,null,{"$f":"IF((E53-ROUND(E53,-2))<>0,\"Kun beløp i hele 100\",\"\")","v":""},{"$f":"IF(E53>0,\"F54 skal være < 0\",\"\")","v":""}]
[]
[null,null,"Satser:",null,null,null,{"$f":"IF(E55<>\"\",\"\",\"Velg sats for pensjon og arb.giveravgift\")","v":"Velg sats for pensjon og arb.giveravgift"}]
[]
[null,null,"Reguleres av:","Konto","Tjeneste","Ansvar ","Prosjekt","Beløp"]
[null,null,"Etat/Økonomi",null,null,null,null,{"$f":"IF(E53<>\"\",ROUND(E53*VLOOKUP(E55,sosialtabell,2),-2),0)","v":0}]
[null,null,"Etat/Økonomi",{"$f":"VLOOKUP(E55,sosialtabell,5)","v":{"$error":"#N/A"}},{"$f":"E58","v":0},{"$f":"F58","v":0},{"$f":"G58","v":0},{"$f":"IF(E53<>\"\",ROUND(E53*VLOOKUP(E55,sosialtabell,3),-2),0)","v":0}]
[null,null,"Etat/Økonomi",10990,{"$f":"E58","v":0},{"$f":"F58","v":0},{"$f":"G58","v":0},{"$f":"IF(E53<>\"\",ROUND(E53*VLOOKUP(E55,sosialtabell,4),-2),0)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(H58:H60)","v":0}]

{"sheet":"Kjøp av ny bil","index":3,"n_rows":65,"n_cols":12,"rows_kept":65,"cut":false,"hidden":false,"merged":[[1,1,2,9],[58,4,58,5],[45,10,45,11],[6,3,6,4]]}
[]
[null,"Kjøp av ny bil, kl. 2"]
[]
[]
[]
[null,null,"Regnskap:"]
[null,null,"Tekst:","Hva kjøpes inn?"]
[]
[null,null,"Kjøpesum:",null,{"$f":"IF(D9=\"\",\"Tast inn kjøpspris på den nye bilen inkl.mva. Evt. innbyttebil skal ikke redusere prisen\",\"\")","v":"Tast inn kjøpspris på den nye bilen inkl.mva. Evt. innbyttebil skal ikke redusere prisen"}]
[]
[null,null,"Eget prosj.nr:",null,{"$f":"IF(D11=\"\",\"Svar ja/nei\",\"\")","v":"Svar ja/nei"}]
[]
[null,null,{"$f":"IF(D11=\"Ja\",\"Prosjektnr:\",\"\")","v":""}]
[]
[null,null,"Innbyttebil:",null,{"$f":"IF(D15<>\"\",\"\",\"Svar ja/nei\")","v":"Svar ja/nei"}]
[]
[null,null,{"$f":"IF(D15=\"Ja\",\"Salgssum:\",\"\")","v":""}]
[]
[null,null,"Hvor skal kostnadene belastes i investeringsregnskapet?"]
[null,null,"Bokføres av:","Konto","Tjeneste","Ansvar ","Prosjekt","Avg.","Beløp"]
[null,null,"Økonomi","02101",null,null,{"$f":"IF(D11=\"Ja\",D13,9998)","v":9998},"D",{"$f":"D9","v":0}]
[null,null,"Etat/Økonomi","09700",88070,900000,"0000",null,{"$f":"-D9+D17+I24","v":0}]
[null,null,"Etat/Økonomi",15700,{"$f":"E21","v":0},{"$f":"F21","v":0},{"$f":"G21","v":9998},null,{"$f":"-I22","v":0}]
[null,null,"Økonomi","04290",{"$f":"E21","v":0},{"$f":"F21","v":0},{"$f":"G21","v":9998},null,{"$f":"I21-(I21/1.25)","v":0}]
[null,null,"Økonomi","07290",84100,990000,"0000",null,{"$f":"-I24","v":0}]
[null,null,"Økonomi",{"$f":"IF(D15=\"Ja\",\"06603\",\"\")","v":""},{"$f":"IF(D15=\"Ja\",E23,\"\")","v":""},{"$f":"IF(D15=\"Ja\",F23,\"\")","v":""},{"$f":"IF(D15=\"Ja\",G23,\"\")","v":""},null,{"$f":"IF(D15=\"Ja\",-D17,\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"SUM(I21:I26)","v":0}]
[]
[]
[null,null,"Budsjett:"]
[]
[null,null,"Inndekning av kostnader i investeringsregnskapet:"]
[null,null,"Reguleres av:","Konto","Tjeneste","Ansvar ","Prosjekt","Beløp"]
[null,null,"Etat/Økonomi",{"$f":"D21","v":"02101"},0,0,9998,{"$f":"ROUND(D9/1.25,-2)","v":0}]
[null,null,"Etat/Økonomi","09700",88070,900000,"0000",{"$f":"ROUND(I22,-2)","v":0}]
[null,null,"Etat/Økonomi",15700,0,0,9998,{"$f":"-H35","v":0}]
[null,null,"Etat/Økonomi",{"$f":"D24","v":"04290"},0,0,9998,{"$f":"ROUND(I24,-2)","v":0}]
[null,null,"Etat/Økonomi","07290",84100,990000,"0000",{"$f":"-H37","v":0}]
[null,null,"Etat/Økonomi",{"$f":"IF(D26<>\"\",D26,\"\")","v":""},{"$f":"E26","v":""},{"$f":"F26","v":""},{"$f":"G26","v":""},{"$f":"IF(D15=\"Ja\",ROUND(I26,-2),0)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(H34:H39)","v":0}]
[null,null,"Alt.1"]
[null,null,"Hvilke(n) driftskonto(er) skal finansiere investeringen?"]
[null,null,"Reguleres av:","Konto","Tjeneste","Ansvar ","Prosjekt","Mva komp.","Beløp"]
[null,null,"Etat/Økonomi",null,null,null,null,null,{"$f":"-H34-H39-I47-I50-H62-H63-H64","v":0}]
[null,null,"Etat/Økonomi",14290,{"$f":"E44","v":0},{"$f":"F44","v":0},{"$f":"G44","v":0},null,{"$f":"ROUND((I44*(1+VLOOKUP(H44,mvadrift,2))-I44),-2)","v":0}]
[null,null,"Etat/Økonomi",17290,{"$f":"E44","v":0},{"$f":"F44","v":0},{"$f":"G44","v":0},null,{"$f":"-I45","v":0},null,"Kontroll"]
[null,null,"Etat/Økonomi",null,null,null,null,null,null,null,{"$f":"IF((I47-ROUND(I47,-2))<>0,\"Kun beløp i hele 100\",\"\")","v":""},{"$f":"IF(I47>0,\"Beløp skal ha negativt fortegn\",\"\")","v":""}]
[null,null,"Etat/Økonomi",14290,{"$f":"E47","v":0},{"$f":"F47","v":0},{"$f":"G47","v":0},null,{"$f":"ROUND((I47*(1+VLOOKUP(H47,mvadrift,2))-I47),-2)","v":0}]
[null,null,"Etat/Økonomi",17290,{"$f":"E47","v":0},{"$f":"F47","v":0},{"$f":"G47","v":0},null,{"$f":"-I48","v":0}]
[null,null,"Etat/Økonomi",null,null,null,null,null,null,null,{"$f":"IF((I50-ROUND(I50,-2))<>0,\"Kun beløp i hele 100\",\"\")","v":""},{"$f":"IF(I50>0,\"G50 skal være < 0\",\"\")","v":""}]
[null,null,"Etat/Økonomi",14290,{"$f":"E50","v":0},{"$f":"F50","v":0},{"$f":"G50","v":0},null,{"$f":"ROUND((I50*(1+VLOOKUP(H50,mvadrift,2))-I50),-2)","v":0}]
[null,null,"Etat/Økonomi",17290,{"$f":"E50","v":0},{"$f":"F50","v":0},{"$f":"G50","v":0},null,{"$f":"-I51","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(I44:I52)","v":0}]
[null,null,"Alt.2"]
[null,null,"Eventuelt fra lønnskonto/ufordelt konto?"]
[]
[null,null,"Beløp inkl. sos.kostnader:",null,null,null,null,null,null,null,{"$f":"IF((E57-ROUND(E57,-2))<>0,\"Kun beløp i hele 100\",\"\")","v":""},{"$f":"IF(E57>0,\"F54 skal være < 0\",\"\")","v":""}]
[]
[null,null,"Satser:",null,null,null,{"$f":"IF(E59<>\"\",\"\",\"Velg sats for pensjon og arb.giveravgift\")","v":"Velg sats for pensjon og arb.giveravgift"}]
[]
[null,null,"Reguleres av:","Konto","Tjeneste","Ansvar ","Prosjekt","Beløp"]
[null,null,"Etat/Økonomi",null,null,null,null,{"$f":"IF(E57<>\"\",ROUND(E57*VLOOKUP(E59,sosialtabell,2),-2),0)","v":0}]
[null,null,"Etat/Økonomi",{"$f":"VLOOKUP(E59,sosialtabell,5)","v":{"$error":"#N/A"}},{"$f":"E62","v":0},{"$f":"F62","v":0},{"$f":"G62","v":0},{"$f":"IF(E57<>\"\",ROUND(E57*VLOOKUP(E59,sosialtabell,3),-2),0)","v":0}]
[null,null,"Etat/Økonomi",10990,{"$f":"E62","v":0},{"$f":"F62","v":0},{"$f":"G62","v":0},{"$f":"IF(E57<>\"\",ROUND(E57*VLOOKUP(E59,sosialtabell,4),-2),0)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(H62:H64)","v":0}]

{"sheet":"Kjøp av lånefin. bil","index":4,"n_rows":38,"n_cols":9,"rows_kept":38,"cut":false,"hidden":false,"merged":[[1,1,2,9],[6,3,6,4]]}
[]
[null,"Kjøp av ny bil, kl. 2 (finansieries av lån godkjent av fylkestinget)."]
[]
[]
[]
[null,null,"Regnskap:"]
[null,null,"Tekst:","Hva kjøpes inn?"]
[]
[null,null,"Kjøpesum:",null,{"$f":"IF(D9=\"\",\"Tast inn kjøpspris på den nye bilen inkl. mva. Evt. innbyttebil skal ikke tas med.\",\"\")","v":"Tast inn kjøpspris på den nye bilen inkl. mva. Evt. innbyttebil skal ikke tas med."}]
[]
[null,null,"Eget prosj.nr:",null,{"$f":"IF(D11=\"\",\"Svar ja/nei\",\"\")","v":"Svar ja/nei"}]
[]
[null,null,{"$f":"IF(D11=\"Ja\",\"Prosjektnr:\",\"\")","v":""}]
[]
[null,null,"Innbyttebil:"]
[]
[null,null,{"$f":"IF(D15=\"Ja\",\"Salgssum:\",\"\")","v":""}]
[]
[null,null,"Hvor skal kostnadene belastes i investeringsregnskapet?"]
[null,null,"Bokføres av:","Konto","Tjeneste","Ansvar ","Prosjekt","Avg.","Beløp"]
[null,null,"Økonomi","02101",null,null,{"$f":"IF(D11=\"Ja\",D13,9998)","v":9998},"D",{"$f":"D9","v":0}]
[null,null,"Etat/Økonomi","09100",87090,900000,"0000",null,{"$f":"-D9+D17+I23","v":0}]
[null,null,"Økonomi","04290",{"$f":"E21","v":0},{"$f":"F21","v":0},{"$f":"G21","v":9998},null,{"$f":"I21-(I21/1.25)","v":0}]
[null,null,"Økonomi","07290",84100,990000,"0000",null,{"$f":"-I23","v":0}]
[null,null,"Økonomi",{"$f":"IF(D15=\"Ja\",\"06603\",\"\")","v":""},{"$f":"IF(D15=\"Ja\",E21,\"\")","v":""},{"$f":"IF(D15=\"Ja\",F21,\"\")","v":""},{"$f":"IF(D15=\"Ja\",G21,\"\")","v":""},null,{"$f":"IF(D15=\"Ja\",-D17,\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"SUM(I21:I25)","v":0}]
[]
[]
[null,null,"Budsjett:"]
[]
[null,null,"Inndekning av kostnader i investeringsregnskapet:"]
[null,null,"Reguleres av:","Konto","Tjeneste","Ansvar ","Prosjekt","Beløp"]
[null,null,"Etat/Økonomi",{"$f":"D21","v":"02101"},0,0,9998,{"$f":"ROUND(D9/1.25,-2)","v":0}]
[null,null,"Etat/Økonomi","09100",87090,900000,"0000",{"$f":"ROUND(I22,-2)","v":0}]
[null,null,"Etat/Økonomi",{"$f":"D23","v":"04290"},{"$f":"E23","v":0},0,9998,{"$f":"ROUND(I23,-2)","v":0}]
[null,null,"Etat/Økonomi",{"$f":"D24","v":"07290"},84100,990000,"0000",{"$f":"-H35","v":0}]
[null,null,"Etat/Økonomi",{"$f":"IF(D25<>\"\",D25,\"\")","v":""},{"$f":"E25","v":""},{"$f":"F25","v":""},{"$f":"G25","v":""},{"$f":"IF(D15=\"Ja\",ROUND(I25,-2),0)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(H33:H37)","v":0}]

{"sheet":"Liste","index":5,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Mva","Mva-koder","Sats"]
[null,"Ja","D",0.25,null,null,null,null,null,"A",0.25]
[null,"Nei","E",0.15,null,null,"KLP",10901,null,"B",0.15]
[null,null,"F",0.12,null,null,"SPK",10911,null,"C",0.12]
[null,null,0,0,null,null,null,null,null,0,0]
[null,null,1,0.25,null,null,"Nord-Troms",0]
[null,null,null,null,null,null,"Øvrige",5.0999999999999997E-2]
[null,null,null,null,null,null,"Tromsø",7.9000000000000001E-2]
[]
[]
[]
[null,null,null,null,null,null,null,"KLP","SPK"]
[null,null,null,null,null,null,"Sats pensjon",0.1133,0.13]

{"sheet":"Lønn og sos.kostn","index":6,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
["Valg","Lønn","Pensjon","AGA","Konto"]
["A - SPK og 7,9 % AGA",{"$f":"'Fordeling lønn'!E6","v":0.82107355864811138},{"$f":"'Fordeling lønn'!E7","v":0.10536779324055666},{"$f":"'Fordeling lønn'!E8","v":7.3558648111332003E-2},10911]
["B - SPK og 5,1 % AGA",{"$f":"'Fordeling lønn'!E15","v":0.84285714285714286},{"$f":"'Fordeling lønn'!E16","v":0.10816326530612246},{"$f":"'Fordeling lønn'!E17","v":4.8979591836734691E-2},10911]
["C - SPK og ingen AGA",{"$f":"'Fordeling lønn'!E24","v":0.88626609442060089},{"$f":"'Fordeling lønn'!E25","v":0.11373390557939914},0,10911]
["D - KLP og 7,9 % AGA",{"$f":"'Fordeling lønn'!J6","v":0.83434343434343439},{"$f":"'Fordeling lønn'!J7","v":9.2929292929292931E-2},{"$f":"'Fordeling lønn'!J8","v":7.2727272727272724E-2},10901]
["E - KLP og 5,1 % AGA",{"$f":"'Fordeling lønn'!J15","v":0.8568464730290456},{"$f":"'Fordeling lønn'!J16","v":9.5435684647302899E-2},{"$f":"'Fordeling lønn'!J17","v":4.7717842323651449E-2},10901]
["F - KLP og ingen AGA",{"$f":"'Fordeling lønn'!J24","v":0.89978213507625271},{"$f":"'Fordeling lønn'!J25","v":0.10021786492374728},{"$f":"'Fordeling lønn'!J26","v":0},10901]

{"sheet":"Fordeling lønn","index":7,"n_rows":37,"n_cols":10,"rows_kept":37,"cut":false,"hidden":true,"merged":[[2,1,2,4],[2,6,2,9]]}
[]
[]
[null,"SPK",null,null,null,null,"KLP"]
[]
[null,"Fordelingsnøkkel mellom lønn, pensjon, arb.giv.avg",null,null,null,null,"Fordelingsnøkkel mellom lønn, pensjon, arb.giv.avg"]
[null,"Lønn inkl. F.p",null,41300,{"$f":"D6/$D$10","v":0.82107355864811138},null,"Lønn inkl. F.p",null,41300,{"$f":"I6/$I$10","v":0.83434343434343439}]
[null,"Pensjon",{"$f":"Meny!D28","v":0.13},{"$f":"ROUND(D6/1.0123*C7,-2)","v":5300},{"$f":"D7/$D$10","v":0.10536779324055666},null,"Pensjon",{"$f":"Meny!D30","v":0.1133},{"$f":"ROUND(I6/1.0123*H7,-2)","v":4600},{"$f":"I7/$I$10","v":9.2929292929292931E-2}]
[null,"Arb.giveravg.",7.9000000000000001E-2,{"$f":"ROUND((D6+D7)*C8,-2)","v":3700},{"$f":"D8/$D$10","v":7.3558648111332003E-2},null,"Arb.giveravg.",7.9000000000000001E-2,{"$f":"ROUND((I6+I7)*H8,-2)","v":3600},{"$f":"I8/$I$10","v":7.2727272727272724E-2}]
[null,"Sykelønnsref",0,{"$f":"ROUND(D6*C9,-2)","v":0},{"$f":"D9/D10","v":0},null,"Sykelønnsref",0,{"$f":"ROUND(I6*H9,-2)","v":0},{"$f":"I9/$I$10","v":0}]
[null,null,null,{"$f":"SUM(D6:D9)","v":50300},{"$f":"SUM(E6:E9)","v":1},null,null,null,{"$f":"SUM(I6:I9)","v":49500},{"$f":"SUM(J6:J9)","v":1}]
[]
[]
[]
[null,"Fordelingsnøkkel mellom lønn, pensjon, arb.giv.avg",null,null,null,null,"Fordelingsnøkkel mellom lønn, pensjon, arb.giv.avg"]
[null,"Lønn inkl. F.p",null,41300,{"$f":"D15/$D$19","v":0.84285714285714286},null,"Lønn inkl. F.p",null,41300,{"$f":"I15/$I$19","v":0.8568464730290456}]
[null,"Pensjon",{"$f":"C7","v":0.13},{"$f":"ROUND(D15/1.0123*C16,-2)","v":5300},{"$f":"D16/$D$19","v":0.10816326530612246},null,"Pensjon",{"$f":"H7","v":0.1133},{"$f":"ROUND(I15/1.0123*H16,-2)","v":4600},{"$f":"I16/$I$19","v":9.5435684647302899E-2}]
[null,"Arb.giveravg.",5.0999999999999997E-2,{"$f":"ROUND((D15+D16)*C17,-2)","v":2400},{"$f":"D17/$D$19","v":4.8979591836734691E-2},null,"Arb.giveravg.",5.0999999999999997E-2,{"$f":"ROUND((I15+I16)*H17,-2)","v":2300},{"$f":"I17/$I$19","v":4.7717842323651449E-2}]
[null,"Sykelønnsref.",0,{"$f":"ROUND(D15*C18,-2)","v":0},{"$f":"D18/D19","v":0},null,"Sykelønnsref.",0,{"$f":"ROUND(I15*H18,-2)","v":0},{"$f":"I18/$I$19","v":0}]
[null,null,null,{"$f":"SUM(D15:D18)","v":49000},{"$f":"SUM(E15:E18)","v":1},null,null,null,{"$f":"SUM(I15:I18)","v":48200},{"$f":"SUM(J15:J18)","v":1}]
[]
[]
[]
[null,"Fordelingsnøkkel mellom lønn, pensjon, arb.giv.avg",null,null,null,null,"Fordelingsnøkkel mellom lønn, pensjon, arb.giv.avg"]
[null,"Lønn inkl. F.p",null,41300,{"$f":"D24/$D$28","v":0.88626609442060089},null,"Lønn inkl. F.p",null,41300,{"$f":"I24/$I$28","v":0.89978213507625271}]
[null,"Pensjon",{"$f":"C7","v":0.13},{"$f":"ROUND(D24/1.0123*C25,-2)","v":5300},{"$f":"D25/$D$28","v":0.11373390557939914},null,"Pensjon",{"$f":"H7","v":0.1133},{"$f":"ROUND(I24/1.0123*H25,-2)","v":4600},{"$f":"I25/$I$28","v":0.10021786492374728}]
[null,"Arb.giveravg.",0,{"$f":"ROUND((D24+D25)*C26,-2)","v":0},{"$f":"D26/$D$28","v":0},null,"Arb.giveravg.",0,{"$f":"ROUND((I24+I25)*H26,-2)","v":0},{"$f":"I26/$I$28","v":0}]
[null,null,0,{"$f":"ROUND(D24*C27,-2)","v":0},{"$f":"D27/D28","v":0},null,null,0,{"$f":"ROUND(I24*H27,-2)","v":0},{"$f":"I27/$I$28","v":0}]
[null,null,null,{"$f":"SUM(D24:D27)","v":46600},{"$f":"SUM(E24:E27)","v":1},null,null,null,{"$f":"SUM(I24:I27)","v":45900},{"$f":"SUM(J24:J27)","v":1}]
[]
[]
[]
[null,"Fordelingsnøkkel mellom lønn, pensjon, arb.giv.avg",null,null,null,null,"Fordelingsnøkkel mellom lønn, pensjon, arb.giv.avg"]
[null,"Lønn inkl. F.p",null,41300,{"$f":"D33/$D$37","v":0.83266129032258063},null,"Lønn inkl. F.p",null,41300,{"$f":"I33/$I$37","v":0.84458077709611457}]
[null,"Pensjon",{"$f":"C7","v":0.13},{"$f":"ROUND(D33/1.0123*C34,-2)","v":5300},{"$f":"D34/$D$37","v":0.10685483870967742},null,"Pensjon",{"$f":"H7","v":0.1133},{"$f":"ROUND(I33/1.0123*H34,-2)","v":4600},{"$f":"I34/$I$37","v":9.4069529652351741E-2}]
[null,"Arb.giveravg.",6.5000000000000002E-2,{"$f":"ROUND((D33+D34)*C35,-2)","v":3000},{"$f":"D35/$D$37","v":6.0483870967741937E-2},null,"Arb.giveravg.",6.5000000000000002E-2,{"$f":"ROUND((I33+I34)*H35,-2)","v":3000},{"$f":"I35/$I$37","v":6.1349693251533742E-2}]
[null,null,0,{"$f":"ROUND(D33*C36,-2)","v":0},{"$f":"D36/$D$37","v":0},null,null,0,{"$f":"ROUND(I33*H36,-2)","v":0},{"$f":"I36/$I$37","v":0}]
[null,null,null,{"$f":"SUM(D33:D36)","v":49600},{"$f":"SUM(E33:E36)","v":1},null,null,null,{"$f":"SUM(I33:I36)","v":48900},{"$f":"SUM(J33:J36)","v":1}]