{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["A","B","C","D","Info"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":22,"comments":3,"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":"A","index":0,"n_rows":79,"n_cols":31,"rows_kept":79,"cut":false,"hidden":false,"merged":[[15,7,19,9],[25,7,31,9],[29,11,29,13],[32,7,34,8],[9,22,9,24],[32,11,32,13],[34,11,34,13],[31,12,31,13],[18,12,18,13],[20,12,20,13],[30,11,30,13],[22,11,22,13],[23,11,23,13],[23,7,23,8],[12,7,14,9],[24,7,24,8],[35,7,35,8],[35,11,35,13],[49,7,49,8],[52,7,53,8],[56,12,56,20],[55,12,55,20],[62,13,62,15],[63,13,63,15],[63,11,63,12],[50,11,50,13],[51,7,51,17],[52,12,52,20],[61,13,61,15],[61,20,61,22],[59,22,59,23],[54,7,55,8],[57,12,57,20],[56,7,57,8],[52,21,57,24],[53,12,53,20],[54,12,54,20],[5,16,5,17],[5,11,5,14],[7,11,7,16],[6,17,6,18],[61,11,61,12],[49,11,49,13],[33,12,33,13],[21,12,21,13],[14,12,14,13],[15,11,15,13],[19,12,19,13],[3,11,3,17],[3,21,3,22],[4,21,4,22],[3,19,3,20],[4,19,4,20],[4,11,4,14],[4,7,4,8],[6,7,6,8],[12,12,12,13],[13,12,13,13],[5,7,5,8],[0,21,1,24],[6,21,6,22],[8,11,8,17],[9,11,9,17],[2,21,2,24],[2,13,2,20],[5,21,5,22],[3,23,3,24],[4,23,4,24],[2,7,2,11],[8,22,8,24],[5,23,5,24],[5,18,5,20],[6,19,6,20],[6,11,6,14],[7,22,7,24]]}
[]
[null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"\n\n"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"     Reiseregning (fra 01.01.17) ",null,null,null,null,null,null,null,"Reisenummer"]
[null,null,null,null,null,null,null,"Etter og fornavn",null,null,null,null,null,null,null,null,null,null,"Fødselsnr.",null,null,"Ansattnr"]
[null,null,null,null,null,null,null,"Privatadresse",null,null,null,null,null,null,null,null,"Postnr.",null,"Poststed",null,null,"Klient "]
[null,null,null,null,null,null,null,"Stilling",null,null,null,null,null,null,null,null,"Bankkontonummer",null,null,null,null,"Firmakode"]
[null,null,null,null,null,null,null,"Virksomhet",null,null,null,null,null,null,null,null,"Avd/tj.sted",null,null,"Skattekommune",null,null,null," Trekk %",null,null,"Test på dato"]
[null,null,null,null,null,null,null,"Regulativ",null,null,null,null,null,null,null,null,null,"Region",null,"  Dato","  Kl.",null,{"$f":"IF(AND(AC28=1,AC34=10),\"Har ikke krav på komp.tillegg\",IF(AND(AC28>1,AC35=20),\"Antall komp.till. er for høyt\",\"\"))","v":""},null,null,null,{"$f":"IF(AND(T9<>\"\",T10<>\"\"),-1,1)","v":1},"Verdien 1 dersom fra og tildato er tomme"]
[null,null,null,null,null,null,null,"Reisemål",null,null,null,null,null,null,null,null,null,null,"  Utreise",null,null,"Ant. Kostdøgn",{"$f":"IF(AA18<0,\"Oppgitt antall kostdøgn er for høyt\",\"\")","v":""},null,null,null,{"$f":"IF(OR($T$9<42005,$T$9>42369),0,1)","v":0},"hvis 1 er utreise dato dato innen 2015"]
[null,null,null,null,null,null,null,"Reiseårsak",null,null,null,null,null,null,null,null,null,null,"  Retur",null,null,{"$f":"IF(AA8=1,0,IF(T9>T10,\"Sjekk dato\",T10-T9+AA15))","v":0},{"$f":"IF(AA8<>1,IF(AND(AA11<2,AA11>0),\"Satser for reise er fra 2015\",\"\"),\"\")","v":""},null,null,null,{"$f":"IF(OR($T$10<42005,$T$10>42369),0,1)","v":0},"hvis 1 er returreise innen 2015"]
[null,null,null,null,null,null,null,"Reiseutlegg / godtgjøringer",null,null,null,null,null,null,null,null,"Antall","Sats","Beløp","Konto","Koststed","K-elem.4","K-elem.5","K-elem.6","K-elem.7",null,{"$f":"SUM(AA9:AA10)","v":0},"hvis 2 er utreise og retur innen 2015"]
[null,null,null,null,null,null,null,null,null,null,1041,"      OVERFØRT  FRA  BAKSIDEN",null,null,null,null,"              ",null,{"$f":"IF(B!M39=0,0,B!M39)","v":0}]
[null,null,null,null,null,null,null,"Kostgodtgjøring uten overnatting, ulegitimert",null,null,"1048/1085","Innland",null,null,null,null,null,{"$f":"IF(AND(Q13<>0,M13<>\"\"),VLOOKUP(M13,'C'!C8:F10,4),\"\")","v":""},{"$f":"IF(AND(Q13<>0,M13<>\"\"),+Q13*R13,0)","v":0},null,null,null,null,null,null,null,"Beregner kostdøgn",{"$f":"T10-T9","v":0},1]
[null,null,null,null,null,null,null,null,null,null,1042,"Utl. 6-12 timer",null,null,null,null,null,{"$f":"IF(M14<>0,((VLOOKUP(M14,'C'!$B$55:$D$219,3,FALSE))*2/3),\"\")","v":""},{"$f":"IF(M14<>0,+Q14*R14,0)","v":0},null,null,null,null,null,null,null,{"$f":"IF(AB13>0,(U10-U9)*24,0)","v":0},"Antall timer inn i nytt døgn"]
[null,null,null,null,null,null,null,null,null,null,1052,"Utl. > 12 timer",null,null,null,null,null,{"$f":"IF(M15<>0,((VLOOKUP(M15,'C'!$B$55:$D$219,3,FALSE))),\"\")","v":""},{"$f":"IF(M15<>0,+Q15*R15,0)","v":0},null,null,null,null,null,null,null,{"$f":"IF($AA$14>=6,1,0)","v":0},"Hvis 6 timer inn i nytt døgn, beregnes nytt kostdøgn"]
[null,null,null,null,null,null,null,"Kostgodtgjøring\n ved overnatting, \nulegitimert ",null,null,{"$f":"+'C'!A12","v":1087},"Hotell innland",null,null,null,null,null,{"$f":"IF(Q16<>0,'C'!$F$12,\"\")","v":""},{"$f":"IF(Q16<>0,+Q16*R16,0)","v":0},null,null,null,null,null,null,null,{"$f":"V10","v":0},"Max. Beregnede kost døgn"]
[null,null,null,null,null,null,null,null,null,null,"1076/1075","Pensj. innland *",{"$f":"IF($Q$17>0,'C'!F15*$Q17+Q43,\"\")","v":""},{"$f":"IF($Q17>0,(('C'!$F$12-'C'!$F$15)*$Q17)+R43,\"\")","v":""},null,null,null,{"$f":"IF(Q17<>0,'C'!F12,\"\")","v":""},0,null,null,null,null,null,null,null,{"$f":"SUM(Q13:Q22)","v":0},"sum oppgitte kostdøgn"]
[null,null,null,null,null,null,null,null,null,null,"1073/1075","Hyb./br./pr innl*",{"$f":"IF($Q$18>0,('C'!F16*$Q18)+Q44,\"\")","v":""},{"$f":"IF($Q18>0,(('C'!$F$12-'C'!$F$16)*$Q18)+R44,\"\")","v":""},null,null,null,{"$f":"IF(Q18<>0,'C'!F12,\"\")","v":""},0,null,null,null,null,null,null,null,{"$f":"IF(Q13=1,0,AA16-AA17)","v":0},"Hvis negativt tall, Oppgitt for mange kostdøgn, skriver feilmelding"]
[null,null,null,null,null,null,null,null,null,null,1052,"Hotell utland",null,null,null,null,null,{"$f":"IF(M19<>0,VLOOKUP(M19,'C'!$B$55:$D$219,3,FALSE),\"\")","v":""},0,null,null,null,null,null,null,null,{"$f":"IF($AA$14>=12,1,0)","v":0},"Hvis 12 timer inn i nytt døgn, beregnes nytt kostdøgn for kompetansetillegg"]
[null,null,null,null,null,null,null,null,null,null,1052,"Hotell utland",null,null,null,null,null,{"$f":"IF(M20<>0,VLOOKUP(M20,'C'!$B$55:$D$219,3,FALSE),\"\")","v":""},0,null,null,null,null,null,null,null,"Hvis reisen varer mindre enn et døgn utbetales kompensasjonstillegg etter 12 timer"]
[null,null,null,null,null,null,null,{"$f":"IF(Q21>0,315*Q21,0)","v":0},{"$f":"IF(Q21>0,S21-H21,0)","v":0},null,"1076/1075","Pensj.utl. *",null,null,null,null,null,{"$f":"IF(M21<>0,VLOOKUP(M21,'C'!$B$55:$D$219,3,FALSE),\"\")","v":""},0,null,null,null,null,null,null,null,"Komp. Tillegg < 1 døgn",null,"kommentar","Hvis 12 timer inn i nytt døgn, får en nytt kompensasjonstilleggsdøgn ved reise under 12 timer"]
[null,null,null,null,null,null,null,{"$f":"IF(Q22>0,205*Q22,0)","v":0},{"$f":"IF(Q22>0,S22-H22,0)","v":0},null,"1073/1075","Hy./br./pr. utl *.",null,null,null,null,null,{"$f":"IF(M22<>0,VLOOKUP(M22,'C'!$B$55:$D$219,3,FALSE),\"\")","v":""},0,null,null,null,null,null,null,null,{"$f":"T9","v":"00:00:00"},"Startdato",{"$f":"IF(AND(AC28=1,AC27>=12),1,0)","v":0},"Reisen varer under et døgn, men mer enn 12 timer = 1 (0 dersom mindre enn 12 timer)"]
[null,null,null,null,null,null,null,null,null,null,null,"Innland: utgår fom 2015",null,null,null,null,null,{"$f":"IF(Q23<>0,'C'!F6,\"\")","v":""},0,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(#REF!=1,AC28>=12),1,0)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,"Nattillegg, uleg.",null,null,{"$f":"+'C'!A17","v":1053},"Innland",null,null,null,null,null,{"$f":"IF(Q24<>0,'C'!F17,\"\")","v":""},0,null,null,null,null,null,null,null,{"$f":"$U$9*24","v":0},"start tidspunkt",{"$f":"AA25-AA24","v":0},"Antall timer mellom start-tidspukt og slutt-tidspunkt"]
[null,null,null,null,null,null,null,"Komp. Tillegg",null,null,{"$f":"+'C'!A13","v":1214},"Utland*",null,{"$f":"IF(Q25>0,IF(AC28=1,AC22,AC32),\"\")","v":""},null,null,null,{"$f":"IF(Q25<>0,'C'!F13,\"\")","v":""},0,null,null,null,null,null,null,null,{"$f":"$U$10*24","v":0},"slutttidspunkt"]
[null,null,null,null,null,null,null,"Eget skyssmiddel. \nSpesifiser reisen\n på baksiden.",null,null,{"$f":"'C'!A28","v":"1094/1096"},"Bil <10.000 km",{"$f":"'C'!C28*Q26","v":0},{"$f":"'C'!D28*Q26","v":0},null,null,{"$f":"B!F18","v":0},{"$f":"'C'!F28","v":4.0999999999999996},{"$f":"IF(Q26<>0,Q26*R26,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"1202/1206","Bil utland <10.000 km",{"$f":"'C'!C30*Q27","v":0},{"$f":"'C'!D30*Q27","v":0},null,null,{"$f":"B!I18","v":0},{"$f":"'C'!F30","v":4.0999999999999996},{"$f":"IF(Q27<>0,Q27*R27,0)","v":0},null,null,null,null,null,null,null,{"$f":"IF(AC27>=12,\"Ja\",\"Nei\")","v":"Nei"},"sum",{"$f":"SUM(AC24:AC25)","v":0},"mer enn 12 timer totalt?"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'C'!A32","v":"1093/1095"},"EL-bil <10.000 km",{"$f":"'C'!C32*Q28","v":0},{"$f":"'C'!D32*Q28","v":0},null,null,{"$f":"B!F20","v":0},{"$f":"'C'!F32","v":4.2},0,null,null,null,null,null,null,null,null,"reisen varer antall døgn :",{"$f":"$T$10-$T$9","v":0}]
[null,null,null,null,null,null,null,null,null,null,"1203/1225","EL-bil utland <10.000 km",{"$f":"'C'!C34*Q29","v":0},{"$f":"'C'!D34*Q29","v":0},null,null,{"$f":"B!I20","v":0},{"$f":"'C'!F34","v":4.0999999999999996},0,null,null,null,null,null,null,null,null,"sum reg. døgn utland  :",{"$f":"SUM(Q19:Q22)","v":0},"Hvis reisen over et døgn utbetales kompensasjonstillegg etter 12 timer inn i nytt døgn"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'C'!A27","v":1045},"Passasjertillegg (navn i merknadsfelt)",null,null,null,null,{"$f":"B!I22","v":0},{"$f":"IF(Q30<>0,'C'!F27,\"\")","v":""},0,null,null,null,null,null,null,null,null,"Registrerte komp. Tillegg",{"$f":"Q25","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B!F22","v":0},{"$f":"IF(Q31>0,'C'!F36,\"\")","v":""},0,null,null,null,null,null,null,null,null,"Beregnet komp.till under et døgn ",{"$f":"AC22","v":0},{"$f":"IF(Q25>AC31,\"Bruker har ikke krav på komp.tillegg for reise under 1 døgn\")","v":false}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(M32<>\"\",Q32<>\"\"),VLOOKUP(M32,B!$E$71:$P$79,6,FALSE))","v":false},"Annet",null,null,null,null,{"$f":"SUMIF(B!G4:H14,M32,B!I4:I14)","v":0},{"$f":"IF(AND(M32<>\"\",Q32<>0),VLOOKUP(M32,B!$E$71:$I$79,2,FALSE),\"\")","v":""},0,null,null,null,null,null,null,null,null,"Beregnet komp.till over et døgn ",{"$f":"IF(AC29<=$V$10,(AC29-1)+AA19,0)","v":-1},{"$f":"IF(AC32=0,\"Bruker har registrert for mange døgn utland enn startdato/sluttdato for reise tilsier\",\"ok\")","v":"ok"},"DENNE MÅ SJEKKES - BLIR FEIL HVIS BRUKER OPPGIR FEILE DØGN"]
[null,"sjekk at denne tabellen fungerer",null,null,null,null,null,"Opphold utover\n 28 døgn",null,null,1269,"Kostgodtgjøring innland",null,null,null,null,null,{"$f":"IF(Q33<>0,'C'!$F$20,\"\")","v":""},0]
[null,null,null,null,null,null,null,null,null,null,1058,"Kostgodtgj. Utland",null,null,null,null,null,{"$f":"IF(M34<>0,VLOOKUP(M34,'C'!$B$55:$D$219,3,FALSE)*0.75,\"\")","v":""},{"$f":"IF(M34<>0,+Q34*R34,0)","v":0},null,null,null,null,null,null,null,null,"Feilmelding komp tillegg under et døgn :",{"$f":"IF($Q$25>0,IF(AC22>=1,0,10))","v":false},{"$f":"IF(AC34=10, \"Feil - 10 Bruker har registrert komp tillegg men har ikke krav på under 1 døgn\",\"\")","v":""}]
[null,"Fratrekk for kost - satser",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q35<>0,'C'!F17*0.75,\"\")","v":""},0,null,null,null,null,null,null,null,null,"Feilmelding komp tillegg over et døgn :",{"$f":"IF(AND($Q$25>0,$AC$29>=1),IF(AC32-Q25<0,20,0))","v":false},{"$f":"IF(AC35=20, \"Feil 20 - Bruker har registrert komp tillegg men har registrert flere enn han har krav på\",\"\")","v":""}]
[null,"% utland",0.1,0.4,0.5,null,null,"Andre godtgj.",null,null,null,null,null,null,null,null,null,null,0]
[null,"% Innland",0.2,0.3,0.5,null,null,"   TIL  SAMMEN",null,null,null,null,null,null,null,null,null,{"$f":"SUM($S$43:$S$44,$S$47:$S$48)","v":0},{"$f":"IF(SUM(S12:S36)<>0,SUM(S12:S36),0)","v":0}]
[null,"Sats","Frokost","Lunch","Middag","Sum",null,"Trekk for kost",null,null,null,"Frokost","Lunsj","Middag",null,null,"Trekkfri","Trekkpl."]
[{"$f":"L13","v":"Innland"},{"$f":"IF(AND($Q$13>0,$M$13<>\"\"),VLOOKUP($M$13,'C'!$C$8:$F$9,4),0)","v":0},{"$f":"IF(AND(B39<>0,L39>0),($B39*$C$37)*L39,0)","v":0},{"$f":"IF(M39>0,($B39*D37),0)","v":0},{"$f":"IF(N39>0,($B39*E37),0)","v":0},{"$f":"SUM(C39:E39)","v":0},null,"Uten overnatting",null,null,"1085/1048",null,null,null,null,null,null,null,{"$f":"-F39","v":0}]
[{"$f":"L14","v":"Utl. 6-12 timer"},{"$f":"IF(AND($Q$14<>0,$M$14<>\"\"),VLOOKUP(M14,'C'!$B$55:$D$219,3,FALSE)*2/3,0)","v":0},{"$f":"IF(L40>0,($B40*C$36),0)","v":0},0,0,{"$f":"SUM(C40:E40)","v":0},null,"Utland 6-12 timer",null,null,1042,null,null,null,null,null,null,null,0]
["Utl. > 12 timer",{"$f":"IF(AND($Q$15<>0,$M$15<>\"\"),VLOOKUP(M15,'C'!$B$55:$D$219,3,FALSE),0)","v":0},0,0,0,{"$f":"SUM(C41:E41)","v":0},null,"Utland > 12 timer",null,null,1052,null,null,null,null,null,null,null,{"$f":"-F41","v":0}]
["Hotell innland",{"$f":"IF(Q16<>\"\",'C'!$F$12,0)","v":0},{"$f":"IF(AND(L42>0,$B42<>0),($B42*C$37)*L42,0)","v":0},{"$f":"IF(AND(M42>0,$B42<>0),($B42*D$37)*M42,0)","v":0},{"$f":"IF(AND(N42>0,$B42<>\"\"),($B42*E$37)*N42,0)","v":0},{"$f":"SUM(C42:E42)","v":0},null,"Hotell innland",null,null,1087,null,null,null,null,null,null,null,0]
["Pensj. innland *",{"$f":"IF(Q17<>\"\",'C'!$F$12,0)","v":0},{"$f":"IF(AND(L43>0,$B43<>\"\"),($B43*C$37)*L43,0)","v":0},{"$f":"IF(AND(M43>0,$B43<>\"\"),($B43*D$37)*M43,0)","v":0},{"$f":"IF(AND(N43>0,$B43<>\"\"),($B43*E$37)*N43,0)","v":0},{"$f":"SUM(C43:E43)","v":0},null,"Pensjonat innl.*",null,null,"1076/1075",null,null,null,null,null,{"$f":"$S43*Q70","v":0},{"$f":"$S43*R70","v":0},0]
["Hyb./br./pr innl*",{"$f":"IF(Q18<>\"\",'C'!$F$12,0)","v":0},0,0,0,0,null,"Hyb./br./pr. innl.*",null,null,"1073/1075",null,null,null,null,null,{"$f":"$S44*Q71","v":0},{"$f":"$S44*R71","v":0},0]
["Hotell utland",{"$f":"IF(AND($Q$19<>0,$M$19<>\"\"),VLOOKUP(M19,'C'!$B$55:$D$219,3,FALSE),0)","v":0},{"$f":"IF(AND(L45>0,C$36<>\"\"),($B45*C$36)*L45,0)","v":0},{"$f":"IF(AND(M45>0,D$36<>\"\"),($B45*D$36)*M45,0)","v":0},{"$f":"IF(AND(N45>0,E$36<>\"\"),($B45*E$36)*N45,0)","v":0},{"$f":"SUM(C45:E45)","v":0},null,"Hotell utland",null,null,1052,null,null,null,null,null,null,null,0]
["Hotell utland",{"$f":"IF(AND($Q$20<>0,$M$20<>\"\"),VLOOKUP(M20,'C'!$B$55:$D$219,3,FALSE),0)","v":0},{"$f":"IF(AND(L46>0,C$36<>\"\"),($B46*C$36)*L46,0)","v":0},{"$f":"IF(AND(M46>0,D$36<>\"\"),($B46*D$36)*M46,0)","v":0},{"$f":"IF(AND(N46>0,E$36<>\"\"),($B46*E$36)*N46,0)","v":0},{"$f":"SUM(C46:E46)","v":0},null,"Hotell utland",null,null,1052,null,null,null,null,null,null,null,{"$f":"-F46","v":0}]
["Pensj.utl. *",{"$f":"IF(AND($Q$21<>0,$M$21<>\"\"),VLOOKUP(M21,'C'!$B$55:$D$219,3,FALSE),0)","v":0},{"$f":"IF(AND(L47>0,C$36<>0),($B47*C$36)*L47,0)","v":0},0,0,0,null,"Pensjonat.utl.*",null,null,"1076/1075",null,null,null,null,null,{"$f":"IF(S47<>0,$S47*Q78,\"\")","v":""},{"$f":"IF(S47<>0,$S47*R78,\"\")","v":""},0]
["Hy./br./pr. utl *.",{"$f":"IF(AND($Q$22<>0,$M$22<>\"\"),VLOOKUP(M22,'C'!$B$55:$D$219,3,FALSE),0)","v":0},0,0,0,0,null,"Hybel./br./pr.utl. *",null,null,"1073/1075",null,null,null,null,null,{"$f":"IF(S48<>0,$S48*Q79,\"\")","v":""},{"$f":"IF(S48<>0,$S48*R79,\"\")","v":""},0]
[null,{"$f":"IF(Q23<>\"\",'C'!$F$12,0)","v":0},{"$f":"IF(AND(L49>0,$B49<>\"\"),($B49*C$37)*L49,0)","v":0},{"$f":"IF(AND(M49>0,$B49<>\"\"),($B49*D$37)*M49,0)","v":0},{"$f":"IF(AND(N49>0,$B49<>\"\"),($B49*E$37)*N49,0)","v":0},0,null,"   Sum reiseoppgjør",null,null,null,{"$f":"SUM(L39:L48)","v":0},{"$f":"SUM(M39:M48)","v":0},0,0,0,null,null,{"$f":"IF(SUM(S37:S48)<>0,SUM(S37:S48),0)","v":0}]
[null,null,null,null,null,null,null,"Annet trekk"]
[null,null,null,null,null,null,null,"Reiseforskudd utbet.sted",null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," Totalsum (Trekkpliktige ytelser er merket med *)",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(S49:S51)<>0,SUM(S49:S51),0)","v":0}]
[null,null,null,null,null,null,null,"Utstederens underskrift",null,null,null,null,"Jeg samtykker i at ev. skyldig beløp kan trekkes i lønn",null,null,null,null,null,null,null,null,"Satsene og beregningene er tatt med for å gi en omtrentlig oversikt over hva som vil bli utbetalt. Det er de satsene og beregningene som ligger i lønnssystemet som vil bli brukt ved utbetalingen av reiseregningen. Utbetalingsbeløpet kan bli mindre pga. forskuddstrekk."]
[]
[null,null,null,null,null,null,null,"Kontroll",null,null,null,"Dato","Sign."]
[]
[null,null,null,null,null,null,null,"Budsjett- disponering",null,null,null,"Dato","Sign."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-01-01"]
[]
[]
[null,null,null,null,null,null,null,null,"REGION",null,null,"ULEGITIMERT ",null,null,null,null,null,null,null,null,"ANDRE FREMKOMSTMIDLER",null,null,null,"REGULATIV"]
[null,null,null,null,null,null,null,null,null,null,null,"KOSTGODTGJØRELSE",null,null,null,null,null,null,null,null,null,null,null,null,"Tjenestereise"]
[null,null,null,null,null,null,null,null,"Tromsø",null,null,"MED OVERNATTING",null,null,null,null,null,null,null,null,null,null,{"$f":"'C'!F39","v":4},null,"Yrkesreise"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'C'!#REF!","v":{"$error":"#REF!"}},null,"Arbeidsreise"]
[null,null,null,null,null,null,null,null,null,null,null,"6-12 timer",null,"8 - 12 timer",null,null,null,"SAP",null,null,null,null,{"$f":"'C'!F43","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,"over 12 timer",null,"over 12 timer",null,null,null,null,null,null,null,null,{"$f":"'C'!F45","v":1.7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'C'!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'C'!F12","v":733},"Kostgodtjørelse","Skattefri","Skattepliktig",null,null,"% skattefri","% skpliktig","Total",null,null,null,{"$f":"'C'!F50","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M70:N70)","v":733},{"$f":"L17","v":"Pensj. innland *"},{"$f":"'C'!F15","v":315},{"$f":"$K$69-M70","v":418},null,null,{"$f":"M70/K70","v":0.42974079126875853},{"$f":"N70/K70","v":0.57025920873124147},{"$f":"SUM(Q70:R70)","v":1},null,null,null,{"$f":"'C'!F51","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M71:N71)","v":733},{"$f":"L18","v":"Hyb./br./pr innl*"},{"$f":"'C'!F16","v":205},{"$f":"$K$69-M71","v":528},null,null,{"$f":"M71/K71","v":0.27967257844474763},{"$f":"N71/K71","v":0.72032742155525242},{"$f":"SUM(Q71:R71)","v":1},null,null,null,{"$f":"'C'!F52","v":0}]
[null,null,null,null,null,null,null,null,null,null,0.2,"Frokost pensjonat",{"$f":"$M$70*K72","v":63},{"$f":"$N$70*K72","v":83.600000000000009},null,null,{"$f":"SUM(M72:P72)","v":146.60000000000002},null,null,null,null,null,{"$f":"'C'!F53","v":0}]
[null,null,null,null,null,null,null,null,null,null,0.3,"Lunch pensjonat",{"$f":"$M$70*K73","v":94.5},{"$f":"$N$70*K73","v":125.39999999999999},null,null,{"$f":"SUM(M73:P73)","v":219.89999999999998}]
[null,null,null,null,null,null,null,null,null,null,0.5,"Middag pensjonat",157.5,209,null,null,366.5,{"$f":"SUM(Q72:Q74)","v":733}]
[null,null,null,null,null,null,null,null,null,null,0.2,"Frokost brakke",{"$f":"$M$71*K75","v":41},{"$f":"$N$71*K75","v":105.60000000000001},null,null,146.60000000000002,null,null,null,null,null,{"$f":"'C'!F56","v":0}]
[null,null,null,null,null,null,null,null,null,null,0.3,"Lunch brakke",{"$f":"$M$71*K76","v":61.5},{"$f":"$N$71*K76","v":158.4},null,null,219.9]
[null,null,null,null,null,null,null,null,null,null,0.5,"Middag brakke",102.5,264,null,null,366.5,{"$f":"SUM(Q75:Q77)","v":733}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"R21","v":""},{"$f":"L21","v":"Pensj.utl. *"},{"$f":"M70","v":315},{"$f":"IF(K78=\"\",\"\",K78-M78)","v":""},null,null,{"$f":"IF(K78=\"\",\"\",M78/K78)","v":""},{"$f":"IF(K78=\"\",\"\",N78/K78)","v":""},{"$f":"SUM(Q78:R78)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"R22","v":""},{"$f":"L22","v":"Hy./br./pr. utl *."},{"$f":"M71","v":205},{"$f":"IF(K79=\"\",\"\",K79-M79)","v":""},null,null,{"$f":"IF(K79=\"\",\"\",M79/K79)","v":""},{"$f":"IF(K79=\"\",\"\",N79/K79)","v":""},{"$f":"SUM(Q79:R79)","v":0}]

{"sheet":"B","index":1,"n_rows":79,"n_cols":22,"rows_kept":79,"cut":false,"hidden":false,"merged":[[11,2,11,3],[2,6,2,7],[8,6,8,7],[9,6,9,7],[10,6,10,7],[11,6,11,7],[3,6,3,7],[10,2,10,3],[3,2,3,3],[4,2,4,3],[1,9,1,12],[6,2,6,3],[7,2,7,3],[9,2,9,3],[8,2,8,3],[4,6,4,7],[5,6,5,7],[6,6,6,7],[7,6,7,7],[5,2,5,3],[12,2,12,3],[13,2,13,3],[23,9,23,11],[34,1,34,7],[33,1,33,7],[28,1,28,7],[24,1,24,7],[23,0,23,8],[25,1,25,7],[26,1,26,7],[27,1,27,7],[13,6,13,7],[12,6,12,7],[15,5,15,8],[52,0,57,12],[48,0,48,9],[29,1,29,7],[51,0,51,12],[35,1,35,7],[32,1,32,7],[42,1,42,8],[41,0,41,8],[44,1,44,8],[47,0,47,9],[49,0,49,9],[45,1,45,8],[43,1,43,8],[30,1,30,7],[41,9,41,11],[31,1,31,7]]}
[]
["   Reisespesifikasjon",null,null,null,null,null,null,null,null,"   Reiseutlegg"]
["  Dato","Klokke slett","Fra sted",null,"Til sted","Klokke slett","Type transportmiddel",null,"Km","Valuta","Beløp i valuta (el. NOK)"," Kurs","   Beløp","Melding",null,"Sats","Skatte-fritt","Skatte-pliktig","Km","Sum km godtgj.","Kontr","Km"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P4>0,T4,IF(AND(K4<>0,L4<>0),K4*L4,K4))","v":0},{"$f":"IF(AND(U4>4,I4=\"\"),\"Fyll ut ant. km\",\"\")","v":""},null,{"$f":"IF(G4=\"\",0,VLOOKUP($G4,$E$62:$F$79,2,FALSE))","v":0},{"$f":"IF(H4=\"\",0,VLOOKUP($G4,$E$62:$F$79,2,FALSE))","v":0},0,{"$f":"IF(U4>4,I4,0)","v":0},{"$f":"P4*S4","v":0},{"$f":"IF(G4=\"\",0,VLOOKUP($G4,$E$62:$I$79,5,FALSE))","v":0},{"$f":"IF(U4>4,I4,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P5>0,T5,IF(AND(K5<>0,L5<>0),K5*L5,K5))","v":0},{"$f":"IF(AND(U5>4,I5=\"\"),\"Fyll ut ant. km\",\"\")","v":""},null,{"$f":"IF(G5=\"\",0,VLOOKUP($G5,$E$62:$F$79,2,FALSE))","v":0},{"$f":"IF(H5=\"\",0,VLOOKUP($G5,$E$62:$F$79,2,FALSE))","v":0},{"$f":"IF(I5=\"\",0,VLOOKUP($G5,$E$62:$F$79,2,FALSE))","v":0},{"$f":"IF(U5>4,I5,0)","v":0},{"$f":"P5*S5","v":0},{"$f":"IF(G5=\"\",0,VLOOKUP($G5,$E$62:$I$79,5,FALSE))","v":0},{"$f":"IF(U5>4,I5,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,"Delsum (ekskl. km godtgj.)",{"$f":"IF(S15>0,SUM(M4:M14)-T15,SUM(M4:M14))","v":0},null,null,null,null,null,{"$f":"SUM(S4:S14)","v":0},{"$f":"SUM(T4:T14)","v":0},{"$f":"SUM(M4:M14)","v":0},{"$f":"SUM(V4:V14)","v":0}]
["Dato: ",null,"Hjemmel for bruk av bil gitt av: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sum km godtgj.",{"$f":"T15","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sum (eksk. km godtgj.)",{"$f":"U15-U16","v":0}]
[null,null,null,"Sum km bil <10.000 km",null,{"$f":"SUMIF($G$4:$G$14,E67,$I$4:$I$14)","v":0},"Sum km bil utland <10.000 km",null,{"$f":"SUMIF($G$4:$G$14,E71,$I$4:$I$14)","v":0},"Sum km Moped <125ccm",null,null,{"$f":"SUMIF($G$4:$G$14,E76,$I$4:$I$14)","v":0}]
[null,null,null,"Sum km bil >10.000 km",null,{"$f":"SUMIF($G$4:$G$14,E68,$I$4:$I$14)","v":0},"Sum km bil utland >10.000 km",null,{"$f":"SUMIF($G$4:$G$14,E72,$I$4:$I$14)","v":0},"Sum km Motorsykkel >125 ccm",null,null,{"$f":"SUMIF($G$4:$G$14,E77,$I$4:$I$14)","v":0},null,null,null,null,null,null,"Sum annet",{"$f":"SUM(M18:M21)","v":0}]
[null,null,null,"Sum km EL-bil <10.000 km",null,{"$f":"SUMIF($G$4:$G$14,E69,$I$4:$I$14)","v":0},"Sum km EL-bil utland <10.000 km",null,{"$f":"SUMIF($G$4:$G$14,E73,$I$4:$I$14)","v":0},"Sum km Båt < 50 hk",null,null,{"$f":"SUMIF($G$4:$G$14,E78,$I$4:$I$14)","v":0},null,null,null,null,null,null,"Sum utland",{"$f":"SUM(I18:I21)","v":0}]
[null,null,null,"Sum km EL-bil > 10.000 km",null,{"$f":"SUMIF($G$4:$G$14,E70,$I$4:$I$14)","v":0},"Sum km EL-bil utland >10.000 km",null,{"$f":"SUMIF($G$4:$G$14,E74,$I$4:$I$14)","v":0},"Sum km Båt > 50hk",null,null,{"$f":"SUMIF($G$4:$G$14,E79,$I$4:$I$14)","v":0},null,null,null,null,null,null,"Totalt",{"$f":"SUM(U19:U20)","v":0}]
[null,null,null,"Sum km bil Hjem-arbeid",null,{"$f":"SUMIF($G$4:$G$14,E75,$I$4:$I$14)","v":0},"Sum passasjertillegg",null,{"$f":"SUMIF($G$4:$G$14,E66,$I$4:$I$14)","v":0},null,null,null,null,null,{"$f":"SUMIF($G$4:$G$14,#REF!,$I$4:$I$14)","v":0}]
[]
["   Utlegg til overnatting, mat, bompenger m.m.",null,null,null,null,null,null,null,null," Valuta eller NOK"]
["  Dato","Spesifikasjon (Dersom du bor på hotell, skal navn og adr. oppgis)",null,null,null,null,null,null,"Papir- kvittering","Valuta","Beløp i valuta eller NOK","  Kurs","Beløp"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(K26<>0,L26<>0),K26*L26,K26)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(K27<>0,L27<>0),K27*L27,K27)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
["   ","   ",null,null,null,null,null,null,null,null,null,"Delsum",{"$f":"IF(SUM(M26:M36)<>0,SUM(M26:M36),0)","v":0}]
[]
[null,null,null,"  Reiseutlegg - overføres automatisk til forsiden",null,null,null,null,null,null,null,"Sum",{"$f":"IF(OR(M15<>0,M37<>0,M48<>0),M15+M37+M48,0)","v":0}]
[]
[]
["  Betalt av arbeidsgiver (beløp må oppgis som negativt tall, da dette kommer til fratrekk på reiseregning)",null,null,null,null,null,null,null,null,"  Fremmed valuta"]
["  Dato","Spesifikasjon",null,null,null,null,null,null,null,"Valuta","Beløp i valuta eller NOK","  Kurs","Beløp"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(K44<>0,L44<>0),K44*L44,K44)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(K45<>0,L45<>0),K45*L45,K45)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(K46<>0,L46<>0),K46*L46,K46)","v":0}]
[]
["   Overnatting (Navn på og sted for hotell, pensjonat e.a. (ikke privat).)",null,null,null,null,null,null,null,null,null,null,"Delsum",{"$f":"SUM(M44:M46)","v":0}]
["Dersom navn og sted på overnattingsstedet ikke oppgis, vil det bli trukket skatt for det beløpet som overstiger Skattedirektoratets forskuddssatser for hybel/brakke med kokemuligheter."]
[]
[]
["   Merknader (Navn på passasjerer må oppgis her.)"]
[]
[]
[]
[]
[]
[]
[]
[]
["Tidsintervall","Kontroll","JA/NEI","Kontroll","Plukkliste transp.type","Sats bil","Skattefritt","Skattepliktig","Kontroll","TT-kode"]
[null,null,null,1,"Taxi",0,null,null,1]
["5-9 timer",null,"Ja",2,"Fly",0,null,null,2]
["9-12 timer",null,"Nei",3,"Tog",0,null,null,3]
["over 12 timer",null,null,4,"Buss",0,null,null,4]
[null,null,null,5,"Passasjer",{"$f":"'C'!F27","v":1},null,null,5]
[null,null,null,6,"Bil <10.000km",{"$f":"'C'!F28","v":4.0999999999999996},{"$f":"'C'!C28","v":3.5},{"$f":"'C'!$D28","v":0.6},6,{"$f":"'C'!A28","v":"1094/1096"}]
[null,null,null,7,"Bil >10.000km",{"$f":"'C'!$F$29","v":3.45},{"$f":"'C'!C29","v":3.45},{"$f":"'C'!$D29","v":0},7,{"$f":"'C'!A29","v":1097}]
[null,null,null,8,"EL-bil  <10.000km",{"$f":"'C'!F32","v":4.2},{"$f":"'C'!C32","v":3.5},{"$f":"'C'!D32","v":0.7},8,{"$f":"'C'!A32","v":"1093/1095"}]
[null,null,null,9,"EL-bil  >10.000km",{"$f":"'C'!F33","v":4.2},{"$f":"'C'!C33","v":3.5},{"$f":"'C'!D33","v":0.7},9,{"$f":"'C'!A33","v":"1221/1223"}]
[null,null,null,10,"Bil utland <10.000km",{"$f":"'C'!F30","v":4.0999999999999996},{"$f":"'C'!C30","v":3.5},{"$f":"'C'!D30","v":0.6},10,{"$f":"'C'!A30","v":"1202/1206"}]
[null,null,null,11,"Bil utland >10.000km",{"$f":"'C'!F31","v":3.45},{"$f":"'C'!C31","v":3.45},{"$f":"'C'!D31","v":0},11,{"$f":"'C'!A31","v":1208}]
[null,null,null,12,"EL-bil utland <10.000km",{"$f":"'C'!F34","v":4.0999999999999996},{"$f":"'C'!C34","v":3.5},{"$f":"'C'!D34","v":0.6},12,{"$f":"'C'!A34","v":"1203/1225"}]
[null,null,null,13,"El_bil utland >10.000km",{"$f":"'C'!F35","v":3.45},{"$f":"'C'!C35","v":3.45},{"$f":"'C'!D35","v":0},13,{"$f":"'C'!A35","v":1222}]
[null,null,null,14,"Bil hjem-arbeid",{"$f":"'C'!F36","v":1.6},{"$f":"'C'!C36","v":1.6},{"$f":"'C'!D36","v":0},14,{"$f":"'C'!A36","v":1094}]
[null,null,null,15,"Moped <125 ccm",{"$f":"'C'!F37","v":1.6},{"$f":"'C'!C37","v":1.6},{"$f":"'C'!D37","v":0},15,{"$f":"'C'!A37","v":1061}]
[null,null,null,16,"Motorsykkel >125 ccm",{"$f":"'C'!F38","v":2.95},{"$f":"'C'!C38","v":2.95},{"$f":"'C'!D38","v":0},16,{"$f":"'C'!A38","v":1063}]
[null,null,null,17,"Båt <50hk",{"$f":"'C'!F39","v":4},{"$f":"'C'!C39","v":4},{"$f":"'C'!D39","v":0},17,{"$f":"'C'!A39","v":1067}]
[null,null,null,18,"Båt >50hk",{"$f":"'C'!F40","v":7.5},{"$f":"'C'!C40","v":7.5},{"$f":"'C'!D40","v":0},18,{"$f":"'C'!A40","v":1068}]

{"sheet":"C","index":2,"n_rows":240,"n_cols":14,"rows_kept":240,"cut":false,"hidden":false,"merged":[[53,8,53,10],[53,11,53,13]]}
[]
[]
[]
[]
["TT-koder","      SATSTYPE",null,null,null,"Sats","Maks % av godtgjørelse","Kommentarer, endringer fra 2014 til 2016"]
["utgår","Administrativ forpleining (utgått 2015)",null,null,null,0,null,"Adminstrativ forpleining innland utgår fom 2015"]
["utgår","Administrativ forpleining utland (utgått 2016)",null,null,null,0,null,"Adminstrativ forpleining utland (kr 100 - fom 2015, utgår fra 1/1-2016)"]
[1048,"Innland, kostgodtgj. u/overnatting","6-12 timer",null,null,289,null,"Innenlands kostgodgjøring endret til 6 til 12 timer i 2015, ny sats 2017"]
[1085,"Innland, kostgodgj. u/overnatting","over 12 timer",null,null,537,null,"over 12 timer, ny sats 2017"]
["utgår","Innland, kostgodgj. u/overnatting (utgått 2015)",null,null,null,0,null,"Kostgodtgjøring innland 9-12 timer utgår i 2015"]
[null,"Grense for legitimerte overnattingsutgifter, innland",null,null,null,1800]
[1087,"Innland, over 12 kostgodtgj m/overnatting","over 12 timer",null,null,733,null,"ny sats 2017"]
[1214,"Kompensasjonstillegg, utland",null,null,null,491,null,"Per 1/1-2017 er dette kr. 491,-"]
[]
[1076,"Trekkfri kostgodtgjørelse for pensjonat",null,null,null,315,null,"Her er kun kr. 315 (fra 2017) skattefritt, resten må det skattes av (gjelder både innland og utland)"]
[1073,"Trekkfri kostgodtgjørelse hybel/brakke/priv",null,null,null,205,null,"Her er kun kr. 205 (fra 2017) skattefritt, resten må det skattes av (gjelder både innland og utland)"]
[1053,"Innland, ulegitimertnattillegg",null,null,null,430]
[null,"Innland, kostgodtgjøring beordring 0-28 døgn",null,null,null,733,null,"Dette brukes ikke, men UiB bruker også kost utover 28 døgn (75%) - feltarbeid"]
[null,"Innland, ulegitimert overnatting beordring 0-28 døgn",null,null,null,430,null,"Dette brukes ikke, men UiB bruker også natt-tillegg utover 28 døgn (90%)-feltarbeid"]
[1269,"Innland, kostgodtgjørelse beording over 28 døgn",null,null,null,190,null,"9.3 Særavtale for reiser utenlands for statens regning,  (kostgodtgjørelse reduseres med 25% av det landet de landet de er i)"]
[null,"Trekk, frokost innland dagreise",null,null,null,0.2]
[null,"Trekk, lunsj, innland dagreise",null,null,null,0.3]
[null,"Trekk, middag, innland dagreise",null,null,null,0.5]
[null,"Trekk prosent frokost innland",null,null,null,0.2]
[null,"Trekk prosent lunsj innland",null,null,null,0.3]
[null,"Trekk prosent middag innland",null,null,null,0.5]
[1045,"Passasjertillegg","Skattefritt","Skattepliktig",null,1]
["1094/1096","Bil km-godtgjørelse 0-10000 km",3.5,0.6,null,4.0999999999999996]
[1097,"Bil km-godtgjørelse over 10000 km *",3.45,0,null,3.45]
["1202/1206","Bil utland: kilometergodtgjørelse < 10.000",3.5,0.6,null,4.0999999999999996]
[1208,"Bil utland: kilometergodtgjørelse > 10.000",3.45,null,null,3.45]
["1093/1095","EL-bil km.godtgj. 0-10.000 km",3.5,0.7,null,4.2]
["1221/1223","EL-bil km.godtgj. > 10.000 km",3.5,0.7,null,4.2]
["1203/1225","EL-bil utland km.godtgj.  0-10.000 km",3.5,0.6,null,4.0999999999999996]
[1222,"EL-bil utland km.godtgj.  > 10.000 km",3.45,0,null,3.45]
[1094,"Bil hjem - arbeid",{"$f":"F36","v":1.6},0,null,1.6,null,"Brukkes ikke"]
[1061,"Moped < 125 ccm km. Godtgjørelse",{"$f":"F37","v":1.6},0,null,1.6]
[1063,"Motorsykkel >125 ccm km.godtgj. ",{"$f":"F38","v":2.95},0,null,2.95]
[1067,"Båt < 50 hk km.godtgj.",{"$f":"F39","v":4},0,null,4]
[1068,"Båt > 50 hk km.godtgj.",{"$f":"F40","v":7.5},0,null,7.5]
["1200/1205","Bil kilometergodtgjørelse i Tromsø 0-10.000",3.8,0.4,null,4.2]
["1201/1224","Bil kilometergodtgjørelse Tromsø > 10.000",3.45,0.1,null,3.55]
[1066,"Andre fremkomstmidler km.godtgj.",{"$f":"F43","v":2},null,null,2]
[1065,"Tillegg: Skogs- og anleggsvei",null,null,null,1]
[null,"Tillegg: Snøscooter",null,null,null,1.7,null,"utgår 2016"]
[1064,"Tillegg: Tilhenger",null,null,null,7.5]
[1062,"      Tillegg",null,null,null,1]
[]
[]
[null,null,null,null,1065]
[null,null,null,null,1062]
[null,null,null,null,1066]
[]
[null,null,null,null,null,null,null,null,"Pensjon utland",null,null,"Hybel/brakke/privat innkv. Utland"]
[1,null,"Makssatser Natt","Kost",null,null,null,null,"TT-kode","Skattefritt","Skattepliktig","TT-kode","Skattefritt","Skattepliktig"]
[117,"Europa:",null,null,null,null,null,null,"1076/1075",null,null,"1073/1075"]
[118,"Albania",1520,500,null,null,null,null,"1076/1075",307,{"$f":"D57-J57","v":193},"1073/1075",200,{"$f":"D57-M57","v":300}]
[119,"Belgia",2100,900,null,null,null,null,"1076/1075",307,{"$f":"D58-J58","v":593},"1073/1075",200,{"$f":"D58-M58","v":700}]
[120,"Bosnia og Hercegovina",800,430,null,null,null,null,"1076/1075",307,{"$f":"D59-J59","v":123},"1073/1075",200,{"$f":"D59-M59","v":230}]
[121,"Bulgaria",900,420,"Ny sats per 1/1-2016",null,null,null,"1076/1075",307,113,"1073/1075",200,220]
[122,"Danmark",1700,800,null,null,null,null,"1076/1075",307,493,"1073/1075",200,600]
[123,"  København",1750,930,null,null,null,null,"1076/1075",307,623,"1073/1075",200,730]
[124,"Estland",1000,600,null,null,null,null,"1076/1075",307,293,"1073/1075",200,400]
[125,"Finland",1500,760,"Ny sats per 1/1-2016",null,null,null,"1076/1075",307,453,"1073/1075",200,560]
[126,"Frankrike",1600,780,null,null,null,null,"1076/1075",307,473,"1073/1075",200,580]
[127,"  Paris",2800,900,null,null,null,null,"1076/1075",307,593,"1073/1075",200,700]
[128,"Hellas",1100,630,"Ny sats per 1/1-2016",null,null,null,"1076/1075",307,323,"1073/1075",200,430]
[129,"Hviterussland",1200,400,null,null,null,null,"1076/1075",307,93,"1073/1075",200,200]
[130,"Irland",1700,850,null,null,null,null,"1076/1075",307,543,"1073/1075",200,650]
[131,"Island",2100,850,null,null,null,null,"1076/1075",307,543,"1073/1075",200,650]
[null,"Italia",2100,900,null,null,null,null,"1076/1075",307,593,"1073/1075",200,700]
[null,"Kosovo",700,360,null,null,null,null,"1076/1075",307,53,"1073/1075",200,160]
[132,"Kroatia",1750,740,"Var tidligere 840, nå redusert til 740?",null,null,null,"1076/1075",307,433,"1073/1075",200,540]
[null,"Kypros",1800,700,null,null,null,null,"1076/1075",307,393,"1073/1075",200,500]
[133,"Latvia",1000,650,null,null,null,null,"1076/1075",307,343,"1073/1075",200,450]
[134,"Liechtenstein",1900,1200,null,null,null,null,"1076/1075",307,893,"1073/1075",200,1000]
[135,"Litauen",1000,490,null,null,null,null,"1076/1075",307,{"$f":"D77-J77","v":183},"1073/1075",200,{"$f":"D77-M77","v":290}]
[136,"Luxembourg",1600,800,null,null,null,null,"1076/1075",307,493,"1073/1075",200,600]
[137,"Makedonia",1100,540,"Var tidligere 610 nå redusert til540?",null,null,null,"1076/1075",307,233,"1073/1075",200,340]
[138,"Malta",1650,700,null,null,null,null,"1076/1075",307,393,"1073/1075",200,500]
[139,"Moldova",1400,380,"Var tidligere 650 nå redusert til 380?",null,null,null,"1076/1075",307,73,"1073/1075",200,180]
[140,"Monaco",2800,1100,null,null,null,null,"1076/1075",307,793,"1073/1075",200,900]
[141,"Montenegro",1300,500,null,null,null,null,"1076/1075",307,193,"1073/1075",200,300]
[142,"Nederland",1500,650,null,null,null,null,"1076/1075",307,343,"1073/1075",200,450]
[143,"Polen",1900,600,null,null,null,null,"1076/1075",307,293,"1073/1075",200,400]
[144,"Portugal",2500,700,"Var tidligere 880 nå redusert til 700",null,null,null,"1076/1075",307,393,"1073/1075",200,500]
[145,"Romania",1500,550,"Var tidligere 820 nå redusert",null,null,null,"1076/1075",307,243,"1073/1075",200,350]
[146,"Russland",1600,650,"Var tidligere 710 nå redusert",null,null,null,"1076/1075",307,343,"1073/1075",200,450]
[147,"  Moskva",3200,980,"Var tidligere 1400 nå redusert",null,null,null,"1076/1075",307,673,"1073/1075",200,780]
[148,"  St. Petersburg",1600,810,"Var tidligere 950 nå redusert",null,null,null,"1076/1075",307,503,"1073/1075",200,610]
[149,"Serbia",1500,630,"Var tidligere 650 nå redusert",null,null,null,"1076/1075",307,323,"1073/1075",200,430]
[151,"Slovakia",1000,600,null,null,null,null,"1076/1075",307,293,"1073/1075",200,400]
[152,"Slovenia",1900,510,"Ny sats per 1/1-2016",null,null,null,"1076/1075",307,203,"1073/1075",200,310]
[153,"Spania",1700,880,"Var tidligere 900 nå redusert",null,null,null,"1076/1075",307,573,"1073/1075",200,680]
[154,"Storbritannia",1400,680,"Ny sats per 1/1-2016",null,null,null,"1076/1075",307,373,"1073/1075",200,480]
[155,"  London",2400,1100,null,null,null,null,"1076/1075",307,793,"1073/1075",200,900]
[156,"Sveits",1450,1050,null,null,null,null,"1076/1075",307,743,"1073/1075",200,850]
[157,"  Genève",4000,1050,null,null,null,null,"1076/1075",307,743,"1073/1075",200,850]
[158,"  Zürich",3000,1200,null,null,null,null,"1076/1075",307,893,"1073/1075",200,1000]
[159,"Sverige",1900,750,null,null,null,null,"1076/1075",307,443,"1073/1075",200,550]
[160,"Tjekkiske republikk",1800,550,null,null,null,null,"1076/1075",307,243,"1073/1075",200,350]
[161,"Tyskland",1900,750,null,null,null,null,"1076/1075",307,443,"1073/1075",200,550]
[162,"  Berlin",2250,900,null,null,null,null,"1076/1075",307,593,"1073/1075",200,700]
[163,"Ukraina",1400,530,null,null,null,null,"1076/1075",307,223,"1073/1075",200,330]
[164,"Ungarn",2000,640,"Var tidligere 650 nå redusert",null,null,null,"1076/1075",307,333,"1073/1075",200,440]
[165,"Østerrike",1400,760,null,null,null,null,"1076/1075",307,453,"1073/1075",200,560]
[166,"  Wien",1900,900,null,null,null,null,"1076/1075",307,593,"1073/1075",200,700]
[null,"Afrika:",null,null,null,null,null,null,"1076/1075",307,-307,"1073/1075",200,-200]
[null,"Algerie",1900,700,"Var tidligere 800 nå redusert",null,null,null,"1076/1075",307,393,"1073/1075",200,500]
[3,"Angola",2650,1270,"Ny sats per 1/1-2016",null,null,null,"1076/1075",307,963,"1073/1075",200,1070]
[4,"Benin",1550,490,"Ny sats per 1/1-2016",null,null,null,"1076/1075",307,183,"1073/1075",200,290]
[5,"Botswana",1500,450,null,null,null,null,"1076/1075",307,143,"1073/1075",200,250]
[6,"Burundi",1000,460,null,null,null,null,"1076/1075",307,153,"1073/1075",200,260]
[null,"Egypt",2400,650,"Var tidligere 680 nå redusert",null,null,null,"1076/1075",307,343,"1073/1075",200,450]
[7,"Elfenbenskysten",1620,700,null,null,null,null,"1076/1075",307,393,"1073/1075",200,500]
[8,"Eritrea",1050,700,null,null,null,null,"1076/1075",307,393,"1073/1075",200,500]
[9,"Etiopia",2000,450,null,null,null,null,"1076/1075",307,143,"1073/1075",200,250]
[10,"Ghana",2300,500,null,null,null,null,"1076/1075",307,193,"1073/1075",200,300]
[11,"Kamerun",1800,560,null,null,null,null,"1076/1075",307,253,"1073/1075",200,360]
[12,"Kenya",1600,580,"Ny sats per 1/1-2016",null,null,null,"1076/1075",307,273,"1073/1075",200,380]
[13,"Lesotho",1000,350,null,null,null,null,"1076/1075",307,43,"1073/1075",200,150]
[14,"Madagaskar",900,350,null,null,null,null,"1076/1075",307,43,"1073/1075",200,150]
[15,"Malawi",1100,360,"Ny sats per 1/1-2016",null,null,null,"1076/1075",307,53,"1073/1075",200,160]
[16,"Marokko",1800,670,"Var tidligere 800 nå redusert",null,null,null,"1076/1075",307,363,"1073/1075",200,470]
[17,"Mauritius",1150,480,"Ny sats per 1/1-2016",null,null,null,"1076/1075",307,173,"1073/1075",200,280]
[18,"Mosambik",2100,690,null,null,null,null,"1076/1075",307,383,"1073/1075",200,490]
[19,"Namibia",1350,360,null,null,null,null,"1076/1075",307,53,"1073/1075",200,160]
[20,"Nigeria",3200,980,null,null,null,null,"1076/1075",307,673,"1073/1075",200,780]
[21,"Seychellene",2500,810,"Var tidligere 1000 nå redusert",null,null,null,"1076/1075",307,503,"1073/1075",200,610]
[22,"Sudan ",1750,800,null,null,null,null,"1076/1075",307,493,"1073/1075",200,600]
[23,"Swasiland",1100,350,null,null,null,null,"1076/1075",307,43,"1073/1075",200,150]
[24,"Sør-Afrika",2500,540,"Var tidligere 1000 nå redusert",null,null,null,"1076/1075",307,233,"1073/1075",200,340]
[null,"Sør-Sudan",1900,580,"Ny sats per 1/1-2016",null,null,null,"1076/1075",307,273,"1073/1075",200,380]
[25,"Tanzania",1950,650,null,null,null,null,"1076/1075",307,343,"1073/1075",200,450]
[26,"Togo",1000,500,"Ny sats per 1/1-2016",null,null,null,"1076/1075",307,193,"1073/1075",200,300]
[27,"Zambia",1350,600,null,null,null,null,"1076/1075",307,293,"1073/1075",200,400]
[28,"Zimbabwe",1300,590,"Ny sats per 1/1-2016",null,null,null,"1076/1075",307,283,"1073/1075",200,390]
[29,"Øvrige områder",1700,580,null,null,null,null,"1076/1075",307,273,"1073/1075",200,380]
[30,"Amerika:",null,null,null,null,null,null,"1076/1075",307,-307,"1073/1075",200,-200]
[31,"Argentina",1600,520,"Ny sats per 1/1-2016",null,null,null,"1076/1075",307,213,"1073/1075",200,320]
[32,"Bahamas",2000,940,"Ny sats per 1/1-2016",null,null,null,"1076/1075",307,{"$f":"D141-J141","v":633},"1073/1075",200,{"$f":"D141-M141","v":740}]
[null,"Barbados",1450,860,"Ny sats per 1/1-2016",null,null,null,"1076/1075",307,553,"1073/1075",200,660]
[33,"Bolivia",650,340,"Ny sats per 1/1-2016",null,null,null,"1076/1075",307,33,"1073/1075",200,140]
[34,"Brasil",2200,650,null,null,null,null,"1076/1075",307,343,"1073/1075",200,450]
[35,"  Rio de Janeiro",3000,820,"Var tidligere 1050 nå redusert",null,null,null,"1076/1075",307,513,"1073/1075",200,620]
[36,"Canada ",2300,930,null,null,null,null,"1076/1075",307,623,"1073/1075",200,730]
[37,"Chile",1500,720,"Ny sats per 1/1-2016",null,null,null,"1076/1075",307,413,"1073/1075",200,520]
[38,"Colombia",2000,500,null,null,null,null,"1076/1075",307,193,"1073/1075",200,300]
[39,"Costa Rica",1000,550,null,null,null,null,"1076/1075",307,243,"1073/1075",200,350]
[40,"Cuba",1100,560,"Ny sats per 1/1-2016",null,null,null,"1076/1075",307,253,"1073/1075",200,360]
[42,"El Salvador",1000,440,null,null,null,null,"1076/1075",307,133,"1073/1075",200,240]
[44,"Guatemala",1100,550,"Ny sats per 1/1-2016",null,null,null,"1076/1075",307,243,"1073/1075",200,350]
[45,"Guyana",1200,560,"Ny sats per 1/1-2016",null,null,null,"1076/1075",307,253,"1073/1075",200,360]
[47,"Honduras",1200,400,null,null,null,null,"1076/1075",307,93,"1073/1075",200,200]
[null,"Jamaica",1200,610,"Ny sats per 1/1-2016",null,null,null,"1076/1075",307,303,"1073/1075",200,410]
[48,"Mexico",2200,680,"Var tidligere 950 nå redusert",null,null,null,"1076/1075",307,373,"1073/1075",200,480]
[49,"Nicaragua",1200,460,null,null,null,null,"1076/1075",307,153,"1073/1075",200,260]
[50,"Panama",1400,500,null,null,null,null,"1076/1075",307,193,"1073/1075",200,300]
[51,"Paraguay",1200,500,null,null,null,null,"1076/1075",307,193,"1073/1075",200,300]
[52,"Peru",1500,750,null,null,null,null,"1076/1075",307,443,"1073/1075",200,550]
[53,"Puerto Rico",1200,700,"Ny sats per 1/1-2016",null,null,null,"1076/1075",307,393,"1073/1075",200,500]
[54,"Surinam",1000,550,"Ny sats per 1/1-2016",null,null,null,"1076/1075",307,243,"1073/1075",200,350]
[55,"Uruguay",1350,600,null,null,null,null,"1076/1075",307,293,"1073/1075",200,400]
[56,"USA",1750,700,null,null,null,null,"1076/1075",307,393,"1073/1075",200,500]
[57,"  New York",3000,950,null,null,null,null,"1076/1075",307,643,"1073/1075",200,750]
[null,"San Francisco",2000,1000,null,null,null,null,"1076/1075",307,693,"1073/1075",200,800]
[58,"  Washington DC",3100,1000,null,null,null,null,"1076/1075",307,693,"1073/1075",200,800]
[59,"Venezuela",2400,1600,"Ny sats per 1/1-2016",null,null,null,"1076/1075",307,1293,"1073/1075",200,1400]
[60,"Øvrige områder",1700,710,"Ny sats per 1/1-2016",null,null,null,"1076/1075",307,403,"1073/1075",200,510]
[61,"Asia:",null,null,null,null,null,null,"1076/1075",307,-307,"1073/1075",200,-200]
[62,"Afghanistan",2300,500,null,null,null,null,"1076/1075",307,193,"1073/1075",200,300]
[63,"Armenia",1400,500,null,null,null,null,"1076/1075",307,193,"1073/1075",200,300]
[64,"Aserbajdsjan",2650,750,null,null,null,null,"1076/1075",307,443,"1073/1075",200,550]
[65,"Bahrain",1650,800,null,null,null,null,"1076/1075",307,493,"1073/1075",200,600]
[66,"Bangladesh",3000,530,"Ny sats per 1/1-2016",null,null,null,"1076/1075",307,223,"1073/1075",200,330]
[67,"Brunei",1000,400,null,null,null,null,"1076/1075",307,93,"1073/1075",200,200]
[69,"Filippinene",2100,700,null,null,null,null,"1076/1075",307,393,"1073/1075",200,500]
[70,"Forente arabiske emirater",1700,1000,null,null,null,null,"1076/1075",307,693,"1073/1075",200,800]
[71,"Georgia",2200,570,"Var tidligere 650 nå redusert",null,null,null,"1076/1075",307,263,"1073/1075",200,370]
[72,"India",1700,500,null,null,null,null,"1076/1075",307,193,"1073/1075",200,300]
[74,"Indonesia",2600,550,null,null,null,null,"1076/1075",307,243,"1073/1075",200,350]
[75,"Iran",1600,750,null,null,null,null,"1076/1075",307,443,"1073/1075",200,550]
[76,"Israel",2900,900,null,null,null,null,"1076/1075",307,593,"1073/1075",200,700]
[78,"Japan",2200,700,null,null,null,null,"1076/1075",307,393,"1073/1075",200,500]
[null,"Jemen",1200,500,null,null,null,null,"1076/1075",307,193,"1073/1075",200,300]
[79,"Jordan",2800,1150,"Var tidligere 1300 nå redusert",null,null,null,"1076/1075",307,843,"1073/1075",200,950]
[80,"Kambodsja",1650,670,"Var tidligere 800 nå redusert",null,null,null,"1076/1075",307,363,"1073/1075",200,470]
[81,"Kasakhstan",1750,700,null,null,null,null,"1076/1075",307,393,"1073/1075",200,500]
[82,"Kina",2000,730,null,null,null,null,"1076/1075",307,423,"1073/1075",200,530]
[83,"  Hong Kong",3100,1000,null,null,null,null,"1076/1075",307,693,"1073/1075",200,800]
[84,"  Shanghai",2400,870,null,null,null,null,"1076/1075",307,563,"1073/1075",200,670]
[85,"Kuwait",1700,730,"Ny sats per 1/1-2016",null,null,null,"1076/1075",307,423,"1073/1075",200,530]
[87,"Laos",1500,500,null,null,null,null,"1076/1075",307,193,"1073/1075",200,300]
[88,"Libanon",2200,890,null,null,null,null,"1076/1075",307,583,"1073/1075",200,690]
[89,"Malaysia",1400,600,"Var tidligere 770 nå redusert",null,null,null,"1076/1075",307,293,"1073/1075",200,400]
[90,"Maldivene",3000,660,"Var tidligere 800 nå redusert",null,null,null,"1076/1075",307,353,"1073/1075",200,460]
[91,"Myanmar (Burma)",1700,690,"Var tidligere 750 nå redusert",null,null,null,"1076/1075",307,383,"1073/1075",200,490]
[93,"Nord-Korea",1000,450,null,null,null,null,"1076/1075",307,143,"1073/1075",200,250]
[94,"Oman",2700,800,null,null,null,null,"1076/1075",307,493,"1073/1075",200,600]
[95,"Pakistan",2100,400,null,null,null,null,"1076/1075",307,93,"1073/1075",200,200]
[null,"Palestina",1400,800,null,null,null,null,"1076/1075",307,493,"1073/1075",200,600]
[96,"Qatar",1600,730,"Ny sats per 1/1-2016",null,null,null,"1076/1075",307,423,"1073/1075",200,530]
[97,"Saudi-Arabia",2700,890,"Var tidligere 1000 nå redusert",null,null,null,"1076/1075",307,583,"1073/1075",200,690]
[98,"Singapore",3250,800,null,null,null,null,"1076/1075",307,493,"1073/1075",200,600]
[99,"Sri Lanka",1200,410,"Ny sats per 1/1-2016",null,null,null,"1076/1075",307,{"$f":"D205-J205","v":103},"1073/1075",200,{"$f":"D205-M205","v":210}]
[101,"Sør-Korea",2000,1100,null,null,null,null,"1076/1075",307,793,"1073/1075",200,900]
[103,"Taiwan",2700,600,null,null,null,null,"1076/1075",307,293,"1073/1075",200,400]
[104,"Thailand",1400,700,null,null,null,null,"1076/1075",307,393,"1073/1075",200,500]
[105,"Tyrkia",2000,520,null,null,null,null,"1076/1075",307,213,"1073/1075",200,320]
[106,"  Istanbul",2000,650,null,null,null,null,"1076/1075",307,343,"1073/1075",200,450]
[null,"Uzbekistan",1000,400,null,null,null,null,"1076/1075",307,93,"1073/1075",200,200]
[107,"Vietnam",1300,550,"Var tidligere 600 nå redusert",null,null,null,"1076/1075",307,243,"1073/1075",200,350]
[109,"Øst Timor",850,510,"Ny sats per 1/1-2016",null,null,null,"1076/1075",307,203,"1073/1075",200,310]
[110,"Øvrige områder",2000,690,null,null,null,null,"1076/1075",307,383,"1073/1075",200,490]
[111,"Australia og Oceania:",null,null,null,null,null,null,"1076/1075",307,-307,"1073/1075",200,-200]
[112,"Australia",2000,950,null,null,null,null,"1076/1075",307,643,"1073/1075",200,750]
[114,"New Zealand",1250,700,null,null,null,null,"1076/1075",307,393,"1073/1075",200,500]
[115,"Papua Ny-Guinea",2500,630,"Ny sats per 1/1-2016",null,null,null,"1076/1075",307,323,"1073/1075",200,430]
[116,"Øvrige områder",1900,740,null,null,null,null,"1076/1075",307,433,"1073/1075",200,540]
[]
[]
[]
[]
[null,"FAD har administrativt fastsatt satser for følgende områder/land slik:"]
[]
[null,"Andorra: ",null,"som for Spania "]
[null,"Azorene",null,"som for Portugal "]
[null,"Færøyene: ",null,"som for Danmark "]
[null,"Gibraltar: ",null,"som for Storbritannia "]
[null,"Grønland: ",null,"som for Danmark "]
[null,"Guernsey (inkl. Alderney og Sark): ",null,"som for Storbritannia "]
[null,"Jersey: ",null,"som for Storbritannia "]
[null,"Kanariøyene: ",null,"som for Spania "]
[null,"Madeira: ",null,"som for Portugal "]
[null,"Man: ",null,"som for Storbritannia "]
[null,"Nord-Irland: ",null,"som for Storbritannia "]
[null,"San Marino: ",null,"som for Italia "]
[null,"Vatikanstaten: ",null,"som for Italia "]
[null,"Åland: ",null,"som for Finland"]
[null,"Øvrige land/områders satser tilsvarer \"Øvrige områder\" under den enkelte verdensdel."]

{"sheet":"D","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Info","index":4,"n_rows":29,"n_cols":2,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Hvordan korrigere satser, ev. skattefrie beløp"]
[]
["Beskyttelse","Regneboken som ligger ute er beskyttet mot endring i låste felt"]
[null,"Beskyttelsen må tas av (se makro for reiseregning)"]
[]
["C-arket","Alle satser som skal oppdateres korrigeres på side C (reiser, kjøregodtgjørelse mm)"]
[null,"Alle formler henviser til sater i dette regnearket, så når det er oppdatert her skal det være oppdatert i hele regnearket"]
[]
["B-arket","Satser og formler for beregninger ligger også i B-arket"]
[null,"Disse er skjult og må vises vha Vis-kommando"]
[null,"Marker start og slutt på kolonner som er skjult, høyre-klikk og velg vis"]
[null,"Beregner korrekt kjøregodkjørelse og plukklister for valg i listebokser"]
[]
["Datavalidering","Plukklistene er satt på vha Datavalidering"]
[null,"Marker området hvor det står listebokser, Velg Data på filmenyen"]
[null,"Da finner du verktøyet \"Datavalidering\" på dette båndet (se bilde)"]
[]
["A-arket","Dette arket inneholder også skjulte kolonner til venstre og høyre i skjemaet"]
[null,"Disse er skjult og må vises vha Vis-kommando"]
[null,"Beregner korrekt kostgodtgjørelse mm"]
[]
[]
[]
[]
[]
["Før ark legges ","Sett på arkbeskyttelse"]
["på web","Test at regnearket fungerer som det skal"]