{"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":80,"n_cols":31,"rows_kept":80,"cut":false,"hidden":false,"merged":[[0,21,1,24],[6,21,6,22],[8,11,8,17],[9,11,9,17],[2,21,2,24],[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],[2,12,2,20],[4,7,4,8],[3,11,3,17],[24,7,24,9],[23,7,23,9],[13,12,13,13],[5,7,5,8],[12,7,14,9],[7,11,7,16],[3,21,3,22],[4,21,4,22],[4,19,4,20],[4,11,4,14],[5,16,5,17],[5,11,5,14],[6,17,6,18],[9,22,9,24],[6,11,6,14],[7,22,7,24],[49,11,49,13],[33,12,33,13],[21,12,21,13],[14,12,14,13],[19,12,19,13],[35,11,35,13],[12,12,12,13],[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],[61,11,61,12],[49,7,49,8],[52,7,53,8],[56,12,56,20],[55,12,55,20],[15,7,19,9],[25,7,31,9],[29,11,29,13],[32,7,34,8],[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]]}
[]
[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," Travel Expenses Claim from 22.06.2018"]
[null,null,null,null,null,null,null,"Last name and First name",null,null,null,null,null,null,null,null,null,null,"National Norwegian ID no. (if applicable)",null,null,"Employee number (if applicable)"]
[null,null,null,null,null,null,null,"Home address",null,null,null,null,null,null,null,null,"Postal code",null,"City"]
[null,null,null,null,null,null,null,"Position",null,null,null,null,null,null,null,null,"Bank account"]
[null,null,null,null,null,null,null,"Organization/Institution",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Test på dato"]
[null,null,null,null,null,null,null,"Type of travel",null,null,null,null,null,null,null,null,null,"Region",null,"Date","Time",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,"Destination",null,null,null,null,null,null,null,null,null,null,"Departure",null,null,"No of days",{"$f":"IF(AA18<0,\"The number of days for which subsist. all. is claimed is too high\",\"\")","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,"Purpose of trip",null,null,null,null,null,null,null,null,null,null,"Return",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,"Travel expenses/compensation",null,null,null,null,null,null,null,null,"Number","Rate","Amount","Account","Cost center","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,"Transferred from reverse ",null,null,null,null,"              ",null,{"$f":"IF(B!M39=0,0,B!M39)","v":0}]
[null,null,null,null,null,null,null,"Subsistence allowance, no overnight stay",null,null,"1048/1085","Domestic",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,"Abroad. 6-12 timer",null,null,null,null,null,{"$f":"IF(M14<>0,((VLOOKUP(M14,'C'!$B$55:$E$221,4,FALSE))*0.5),\"\")","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,"Abroad > 12 timer",null,null,null,null,null,{"$f":"IF(M15<>0,((VLOOKUP(M15,'C'!$B$55:$E$221,4,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,"Subsistence allowance, overnight stay",null,null,"1087/1075","Hotell innland",{"$f":"IF($Q$16>0,'C'!G48*$Q16+Q42,\"\")","v":""},{"$f":"IF($Q16>0,(('C'!$F$12-'C'!$G48)*$Q16)+R42,\"\")","v":""},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","B&B/Inn domestic *",{"$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","Bedsit/AirBnB/ priv domestic*",{"$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,"Hotel abroad",null,null,null,null,null,{"$f":"IF(M19<>0,VLOOKUP(M19,'C'!$B$55:$E$221,4,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,"Hotel abroad",null,null,null,null,null,{"$f":"IF(M20<>0,VLOOKUP(M20,'C'!$B$55:$E$221,4,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,159*Q21,0)-Q43","v":0},{"$f":"IF(Q21>0,S21-H21,0)","v":0},null,"1076/1075","B&B/Inn abroad *",null,null,null,null,null,{"$f":"IF(M21<>0,VLOOKUP(M21,'C'!$B$55:$E$221,4,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,88*Q22,0)","v":0},{"$f":"IF(Q22>0,S22-H22,0)","v":0},null,"1073/1075","Bedsit/AirBnB/priv abroad*",null,null,null,null,null,{"$f":"IF(M22<>0,VLOOKUP(M22,'C'!$B$55:$E$221,4,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,"Night supplement",null,null,{"$f":"+'C'!A17","v":1053},"Domestic",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,"Additional compensation ",null,null,{"$f":"+'C'!A13","v":1214},"Abroad*",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,"Use of own means of transport. Please specify the journey on the reverse side.\n",null,null,{"$f":"'C'!A28","v":"1094/1096"},"Car  <10.000 km",{"$f":"'C'!C28*Q26","v":0},{"$f":"'C'!D28*Q26","v":0},null,null,null,{"$f":"'C'!F28","v":3.9},{"$f":"IF(Q26<>0,Q26*R26,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"1202/1206","Car abroad <10.000 km",{"$f":"'C'!C30*Q27","v":0},{"$f":"'C'!D30*Q27","v":0},null,null,null,{"$f":"'C'!F30","v":3.9},{"$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-car <10.000 km",{"$f":"'C'!C32*Q28","v":0},{"$f":"'C'!D32*Q28","v":0},null,null,null,{"$f":"'C'!F32","v":3.9},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-car abroad <10.000 km",{"$f":"'C'!C34*Q29","v":0},{"$f":"'C'!D34*Q29","v":0},null,null,null,{"$f":"'C'!F34","v":3.9},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},"Passengers suppl.(name of passanger(s) should be entered  in the remarks box)",null,null,null,null,null,{"$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,null,{"$f":"IF(Q31>0,'C'!F27,\"\")","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},"Other",null,null,null,null,null,{"$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,"Stay exceeding 28 days\n ",null,null,1269,"Subsistence allowance domestic",null,null,null,null,null,{"$f":"IF(Q33<>0,'C'!$F$12*0.75,\"\")","v":""},0]
[null,null,null,null,null,null,null,null,null,null,1058,"Subsistence allowance abroad",null,null,null,null,null,{"$f":"IF(M34<>0,VLOOKUP(M34,'C'!$B$55:$E$221,4,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.2,0.3,0.5,null,null,"Other compensation",null,null,null,null,null,null,null,null,null,null,0]
[null,"% Innland",0.2,0.3,0.5,null,null,"Total",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,"Deduction for meals",null,null,null,"Breakfast","Lunch","Dinner",null,null,"Tax-free","Taxable"]
[{"$f":"L13","v":"Domestic"},{"$f":"IF(AND($Q$13>0,$M$13<>\"\"),VLOOKUP($M$13,'C'!$C$8:$F$9,4),0)","v":0},{"$f":"ROUND(IF(AND(B39<>0,L39>0),($C$37*754)*L39,0),0)","v":0},{"$f":"ROUND(IF(M39>0,(754*D37),0),0)","v":0},{"$f":"IF(N39>0,(754*E37),0)","v":0},{"$f":"IF(SUM(C39:E39)>B39,B39,SUM(C39:E39))","v":0},null,"No overnight stay",null,null,"1048/1085",null,null,null,null,null,null,null,{"$f":"-F39","v":0}]
[{"$f":"L14","v":"Abroad. 6-12 timer"},{"$f":"IF(AND($Q$14<>0,$M$14<>\"\"),VLOOKUP(M14,'C'!$B$55:$E$221,4,FALSE)*0.5,0)","v":0},{"$f":"IF(L40>0,($B40*C$36)*2,0)","v":0},{"$f":"IF(M40>0,($B40*D$36)*2,0)","v":0},{"$f":"IF(N40>0,($B40*E$36)*2,0)","v":0},{"$f":"SUM(C40:E40)","v":0},null,"Abroad 6-12 timer",null,null,1042,null,null,null,null,null,null,null,0]
["Abroad > 12 timer",{"$f":"IF(AND($Q$15<>0,$M$15<>\"\"),VLOOKUP(M15,'C'!$B$55:$E$221,4,FALSE),0)","v":0},{"$f":"IF(L41>0,($B41*C$36),0)","v":0},0,0,{"$f":"SUM(C41:E41)","v":0},null,"Abroad > 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,"Hotel domestic",null,null,1087,null,null,null,null,null,{"$f":"$S42*Q80","v":0},{"$f":"$S42*R80","v":0},0]
["B&B/Inn domestic *",{"$f":"IF(Q17<>\"\",'C'!$F$12,0)","v":0},{"$f":"(IF(AND(L43>0,$B43<>0),($B43*C$37)*L43,0))","v":0},{"$f":"IF(AND(M43>0,$B43<>0),($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,"B&B/Inn domestic*",null,null,"1076/1075",null,null,null,null,null,{"$f":"$S43*Q70","v":0},{"$f":"$S43*R70","v":0},0]
["Bedsit/AirBnB/ priv domestic*",{"$f":"IF(Q18<>\"\",'C'!$F$12,0)","v":0},{"$f":"(IF(AND(L44>0,$B44<>0),($B44*C$37)*L44,0))","v":0},{"$f":"IF(AND(M44>0,$B44<>0),($B44*D$37)*M44,0)","v":0},{"$f":"IF(AND(N44>0,$B44<>\"\"),($B44*E$37)*N44,0)","v":0},0,null,"Bedsit/AirBnB/priv. domestic*",null,null,"1073/1075",null,null,null,null,null,{"$f":"$S44*Q71","v":0},{"$f":"$S44*R71","v":0},0]
["Hotel abroad",{"$f":"IF(AND($Q$19<>0,$M$19<>\"\"),VLOOKUP(M19,'C'!$B$55:$E$221,4,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,"Hotel abroad",null,null,1052,null,null,null,null,null,null,null,0]
["Hotel abroad",{"$f":"IF(AND($Q$20<>0,$M$20<>\"\"),VLOOKUP(M20,'C'!$B$55:$E$221,4,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,"Hotel abroad",null,null,1052,null,null,null,null,null,null,null,{"$f":"-F46","v":0}]
["B&B/Inn abroad *",{"$f":"IF(AND($Q$21<>0,$M$21<>\"\"),VLOOKUP(M21,'C'!$B$55:$E$221,4,FALSE),0)","v":0},{"$f":"IF(AND(L47>0,C$36<>0),($B47*C$36)*L47,0)","v":0},0,0,0,null,"B&B/Inn abroad*",null,null,"1076/1075",null,null,null,null,null,{"$f":"IF(S47<>0,$S47*Q78,\"\")","v":""},{"$f":"IF(S47<>0,$S47*R78,\"\")","v":""},0]
["Bedsit/AirBnB/priv abroad*",{"$f":"IF(AND($Q$22<>0,$M$22<>\"\"),VLOOKUP(M22,'C'!$B$55:$E$221,4,FALSE),0)","v":0},0,0,0,0,null,"Bedsit/AirBnB/priv. abroad*",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," Total travel expenses",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,"Other deductions"]
[null,null,null,null,null,null,null,"Travel advance",null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,"TOTAL  (tax deductable amounts are marked with *)",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,"Claimant's signature",null,null,null,null,"I, the undersigned, agree that any amount due may be deducted from my salary.",null,null,null,null,null,null,null,null,"The rates and calculations are only included to give an estimate of the expected payment. The actual rates and calculations in the payroll system will be used when paying the travel expenses. The amount due may be smaller due to tax withholding."]
[]
[null,null,null,null,null,null,null,"Attested",null,null,null,"Date","Sign."]
[]
[null,null,null,null,null,null,null,"Authorized",null,null,null,"Date","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 hours",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 hours",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":754},"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":754},{"$f":"L17","v":"B&B/Inn domestic *"},{"$f":"'C'!F15","v":159},{"$f":"$K$69-M70","v":595},null,null,{"$f":"M70/K70","v":0.21087533156498675},{"$f":"N70/K70","v":0.78912466843501328},{"$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":754},{"$f":"L18","v":"Bedsit/AirBnB/ priv domestic*"},{"$f":"'C'!F16","v":88},{"$f":"$K$69-M71","v":666},null,null,{"$f":"M71/K71","v":0.11671087533156499},{"$f":"N71/K71","v":0.88328912466843501},{"$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":31.8},{"$f":"$N$70*K72","v":119},null,null,{"$f":"SUM(M72:P72)","v":150.80000000000001},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":47.699999999999996},{"$f":"$N$70*K73","v":178.5},null,null,{"$f":"SUM(M73:P73)","v":226.2}]
[null,null,null,null,null,null,null,null,null,null,0.5,"Middag pensjonat",79.5,297.5,null,null,377,{"$f":"SUM(Q72:Q74)","v":754}]
[null,null,null,null,null,null,null,null,null,null,0.2,"Frokost brakke",{"$f":"$M$71*K75","v":17.600000000000001},{"$f":"$N$71*K75","v":133.20000000000002},null,null,150.80000000000001,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":26.4},{"$f":"$N$71*K76","v":199.79999999999998},null,null,226.2]
[null,null,null,null,null,null,null,null,null,null,0.5,"Middag brakke",44,333,null,null,377,{"$f":"SUM(Q75:Q77)","v":754}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"R21","v":""},{"$f":"L21","v":"B&B/Inn abroad *"},{"$f":"M70","v":159},{"$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":"Bedsit/AirBnB/priv abroad*"},{"$f":"M71","v":88},{"$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}]
[null,null,null,null,null,null,null,null,null,null,754,"Hotell ",{"$f":"'C'!G48","v":569},{"$f":"+K80-M80","v":185},null,null,{"$f":"+M80/K80","v":0.75464190981432355},{"$f":"+N80/K80","v":0.24535809018567639}]

{"sheet":"B","index":1,"n_rows":79,"n_cols":22,"rows_kept":79,"cut":false,"hidden":false,"merged":[[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],[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],[15,2,15,4],[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],[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]]}
[]
["Journey specifications",null,null,null,null,null,null,null,null,"Expenses"]
["Date ","Time","From ",null,"To","Time","Means of transport",null,"Km","Currency","Amount","Exchange rate","Amount","Comments",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=\"\"),\"Enter number of 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},"",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,"Subtotal (not including comp. for use of own car)",{"$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}]
["Date: ",null,"Use of private car authorized by: ",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,"Total km <10.000 km",null,{"$f":"SUMIF($G$4:$G$14,E67,$I$4:$I$14)","v":0},"Total km abroad <10.000 km",null,{"$f":"SUMIF($G$4:$G$14,E71,$I$4:$I$14)","v":0},"Total km moped <125ccm",null,null,{"$f":"SUMIF($G$4:$G$14,E76,$I$4:$I$14)","v":0}]
[null,null,null,"Total km  >10.000 km",null,{"$f":"SUMIF($G$4:$G$14,E68,$I$4:$I$14)","v":0},"Total km abroad >10.000 km",null,{"$f":"SUMIF($G$4:$G$14,E72,$I$4:$I$14)","v":0},"Total km motorcycle >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,"Total km El-car<10.000 km",null,{"$f":"SUMIF($G$4:$G$14,E69,$I$4:$I$14)","v":0},"Total km El-car abroad <10.000 km",null,{"$f":"SUMIF($G$4:$G$14,E73,$I$4:$I$14)","v":0},"Total km boat < 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,"Total km El-car  >10.000 km",null,{"$f":"SUMIF($G$4:$G$14,E70,$I$4:$I$14)","v":0},"Total km El-car abroad  >10.000 km",null,{"$f":"SUMIF($G$4:$G$14,E74,$I$4:$I$14)","v":0},"Total km boat > 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,"Total km to/from work",null,{"$f":"SUMIF($G$4:$G$14,E75,$I$4:$I$14)","v":0},"Total km passengers",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}]
[]
["Expenses for accommodation, food, toll, etc."]
["  Date","Description (If you stayed at a hotel, please specify the name and the address of the hotel)",null,null,null,null,null,null,"Paper receipts","Currency","Amount","Exchange rate","Amount"]
[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,"Subtotal",{"$f":"IF(SUM(M26:M36)<>0,SUM(M26:M36),0)","v":0}]
[]
[null,null,null,"Travel expenses - automatically transferred to the front page",null,null,null,null,null,null,null,"Total",{"$f":"IF(OR(M15<>0,M37<>0,M48<>0),M15+M37+M48,0)","v":0}]
[]
[]
["Paid by the employer (the amount must be specified as a negative number as it will be subtracted from the total)"]
["  Date","Description",null,null,null,null,null,null,null,"Currency","Amount","Exchange rate","Amount"]
[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}]
[]
["  Accommodation (name and address of the hotel, B&B, etc. (not private))",null,null,null,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(M44:M46)","v":0}]
["If you fail to specify the name and address of your accommodation, tax will be deducted from the amount exceeding The Directorate of Taxes' rate for subsistance allowance not subject to withholding tax for overnight stay in accommodation with cooking facilities."]
[]
[]
["Remarks (Name(s) of passenger(s))"]
[]
[]
[]
[]
[]
[]
[]
[]
["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,"Yes",2,"Plane",0,null,null,2]
["9-12 timer",null,"No",3,"Train",0,null,null,3]
["over 12 timer",null,null,4,"Bus",0,null,null,4]
[null,null,null,5,"Passenger",{"$f":"'C'!F27","v":1},null,null,5]
[null,null,null,6,"Car <10.000km",{"$f":"'C'!F28","v":3.9},{"$f":"'C'!C28","v":3.5},{"$f":"'C'!$D28","v":0.4},6,{"$f":"'C'!A28","v":"1094/1096"}]
[null,null,null,7,"Car >10.000km",{"$f":"'C'!$F$29","v":3.9},{"$f":"'C'!C29","v":3.5},{"$f":"'C'!$D29","v":0.4},7,{"$f":"'C'!A29","v":1097}]
[null,null,null,8,"El-car  <10.000km",{"$f":"'C'!F32","v":3.9},{"$f":"'C'!C32","v":3.5},{"$f":"'C'!D32","v":0.4},8,{"$f":"'C'!A32","v":"1093/1095"}]
[null,null,null,9,"El-car  >10.000km",{"$f":"'C'!F33","v":3.9},{"$f":"'C'!C33","v":3.5},{"$f":"'C'!D33","v":0.4},9,{"$f":"'C'!A33","v":"1221/1223"}]
[null,null,null,10,"Car abroad <10.000km",{"$f":"'C'!F30","v":3.9},{"$f":"'C'!C30","v":3.5},{"$f":"'C'!D30","v":0.4},10,{"$f":"'C'!A30","v":"1202/1206"}]
[null,null,null,11,"Car abroad >10.000km",{"$f":"'C'!F31","v":3.9},{"$f":"'C'!C31","v":3.5},{"$f":"'C'!D31","v":0.4},11,{"$f":"'C'!A31","v":1208}]
[null,null,null,12,"EL-car abroad <10.000km",{"$f":"'C'!F34","v":3.9},{"$f":"'C'!C34","v":3.5},{"$f":"'C'!D34","v":0.4},12,{"$f":"'C'!A34","v":"1203/1225"}]
[null,null,null,13,"El-car abroad >10.000km",{"$f":"'C'!F35","v":3.9},{"$f":"'C'!C35","v":3.5},{"$f":"'C'!D35","v":0.4},13,{"$f":"'C'!A35","v":1222}]
[null,null,null,14,"Car to/from work",{"$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,"Motorcycle >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,"Boat <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,"Boat >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":242,"n_cols":14,"rows_kept":242,"cut":false,"hidden":false,"merged":[[53,8,53,10],[53,11,53,13]]}
[]
[]
[]
[]
["TT-koder","      SATSTYPE",null,null,null,"Sats f.o.m 22.06.2018","Maks % av godtgjørelse","Kommentarer"]
["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 hours",null,null,297,null,"Innenlands kostgodgjøring endret til 6 til 12 timer i 2015; ny sats fra 1/1-17 - 289,-"]
[1085,"Innland, kostgodgj. u/overnatting","over 12 hours",null,null,552,null,"over 12 timer; ny sats fra 1/1-17- 537,-"]
["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,754,null,"Per 1/1-2017 er dette kr.733,-"]
[1214,"Kompensasjonstillegg, utland",null,null,null,515,null,"Per 1/1-2017 er dette kr. 491,-"]
[]
[1076,"Trekkfri kostgodtgjørelse for pensjonat",null,null,null,159,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,88,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,754,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å nattillegg 28 døgn (90%)- feltarbeid"]
[1269,"Kostgodtgjørelse beording over 28 døgn",null,null,null,195,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,{"$f":"ROUND(20%*754,0)","v":151},null,"20% av 754"]
[null,"Trekk, lunsj, innland dagreise",null,null,null,{"$f":"ROUND(30%*754,0)","v":226},null,"30% av 754"]
[null,"Trekk, middag, innland dagreise",null,null,null,{"$f":"50%*754","v":377},null,"50% av 754"]
[null,"Trekk prosent frokost ",null,null,null,0.2]
[null,"Trekk prosent lunsj ",null,null,null,0.3]
[null,"Trekk prosent middag ",null,null,null,0.5]
[1045,"Passasjertillegg","Skattefritt","Skattepliktig",null,1]
["1094/1096","Bil km-godtgjørelse 0-10000 km",3.5,0.4,null,3.9]
[1097,"Bil km-godtgjørelse over 10000 km *",3.5,0.4,null,3.9]
["1202/1206","Bil utland: kilometergodtgjørelse < 10.000",3.5,0.4,null,3.9]
[1208,"Bil utland: kilometergodtgjørelse > 10.000",3.5,0.4,null,3.9]
["1093/1095","EL-bil km.godtgj. 0-10.000 km",3.5,0.4,null,3.9]
["1221/1223","EL-bil km.godtgj. > 10.000 km",3.5,0.4,null,3.9]
["1203/1225","EL-bil utland km.godtgj.  0-10.000 km",3.5,0.4,null,3.9]
[1222,"EL-bil utland km.godtgj.  > 10.000 km",3.5,0.4,null,3.9]
[1094,"Bil hjem - arbeid",{"$f":"F36","v":1.6},0,null,1.6]
[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.5,0.5,null,4]
["1201/1224","Bil kilometergodtgjørelse Tromsø > 10.000",3.5,0.5,null,4]
[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]
[1087,"   Trekkfrie satser hotell",null,null,null,null,569]
[]
[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 utgått 01.01.2016","Kost t.o.m 21.06.2018","Nye satser fra 22.06.18",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,390,330,null,null,null,"1076/1075",315,{"$f":"D57-J57","v":75},"1073/1075",205,{"$f":"D57-M57","v":185}]
[119,"Belgia",2100,900,920,null,null,null,"1076/1075",315,{"$f":"D58-J58","v":585},"1073/1075",205,{"$f":"D58-M58","v":695}]
[120,"Bosnia og Hercegovina",800,430,480,null,null,null,"1076/1075",315,{"$f":"D59-J59","v":115},"1073/1075",205,{"$f":"D59-M59","v":225}]
[121,"Bulgaria",900,420,520,null,null,null,"1076/1075",315,105,"1073/1075",205,215]
[122,"Danmark",1700,800,1190,null,null,null,"1076/1075",315,485,"1073/1075",205,595]
[123,"  København",1750,930,"1190",null,null,null,"1076/1075",315,615,"1073/1075",205,725]
[124,"Estland",1000,600,660,null,null,null,"1076/1075",315,285,"1073/1075",205,395]
[125,"Finland",1500,760,950,null,null,null,"1076/1075",315,445,"1073/1075",205,555]
[126,"Frankrike",1600,780,750,null,null,null,"1076/1075",315,465,"1073/1075",205,575]
[127,"  Paris",2800,900,930,null,null,null,"1076/1075",315,585,"1073/1075",205,695]
[128,"Hellas",1100,630,770,null,null,null,"1076/1075",315,315,"1073/1075",205,425]
[129,"Hviterussland",1200,400,370,null,null,null,"1076/1075",315,85,"1073/1075",205,195]
[130,"Irland",1700,850,890,null,null,null,"1076/1075",315,535,"1073/1075",205,645]
[131,"Island",2100,850,1240,null,null,null,"1076/1075",315,535,"1073/1075",205,645]
[null,"Italia",2100,900,760,null,null,null,"1076/1075",315,585,"1073/1075",205,695]
[null,"Kosovo",700,360,370,null,null,null,"1076/1075",315,45,"1073/1075",205,155]
[132,"Kroatia",1750,740,600,null,null,null,"1076/1075",315,425,"1073/1075",205,535]
[null,"Kypros",1800,700,740,null,null,null,"1076/1075",315,385,"1073/1075",205,495]
[133,"Latvia",1000,650,670,null,null,null,"1076/1075",315,335,"1073/1075",205,445]
[134,"Liechtenstein",1900,1200,1290,null,null,null,"1076/1075",315,885,"1073/1075",205,995]
[135,"Litauen",1000,490,520,null,null,null,"1076/1075",315,{"$f":"D77-J77","v":175},"1073/1075",205,{"$f":"D77-M77","v":285}]
[136,"Luxembourg",1600,800,920,null,null,null,"1076/1075",315,485,"1073/1075",205,595]
[137,"Makedonia",1100,540,450,null,null,null,"1076/1075",315,225,"1073/1075",205,335]
[138,"Malta",1650,700,690,null,null,null,"1076/1075",315,385,"1073/1075",205,495]
[139,"Moldova",1400,380,340,null,null,null,"1076/1075",315,65,"1073/1075",205,175]
[140,"Monaco",2800,1100,1080,null,null,null,"1076/1075",315,785,"1073/1075",205,895]
[141,"Montenegro",1300,500,570,null,null,null,"1076/1075",315,185,"1073/1075",205,295]
[142,"Nederland",1500,650,770,null,null,null,"1076/1075",315,335,"1073/1075",205,445]
[143,"Polen",1900,600,600,null,null,null,"1076/1075",315,285,"1073/1075",205,395]
[144,"Portugal",2500,700,620,null,null,null,"1076/1075",315,385,"1073/1075",205,495]
[145,"Romania",1500,550,470,null,null,null,"1076/1075",315,235,"1073/1075",205,345]
[146,"Russland",1600,650,510,null,null,null,"1076/1075",315,335,"1073/1075",205,445]
[147,"  Moskva",3200,980,710,null,null,null,"1076/1075",315,665,"1073/1075",205,775]
[148,"  St. Petersburg",1600,810,590,null,null,null,"1076/1075",315,495,"1073/1075",205,605]
[149,"Serbia",1500,630,510,null,null,null,"1076/1075",315,315,"1073/1075",205,425]
[151,"Slovakia",1000,600,650,null,null,null,"1076/1075",315,285,"1073/1075",205,395]
[152,"Slovenia",1900,510,670,null,null,null,"1076/1075",315,195,"1073/1075",205,305]
[153,"Spania",1700,880,720,null,null,null,"1076/1075",315,565,"1073/1075",205,675]
[154,"Storbritannia",1400,680,750,null,null,null,"1076/1075",315,365,"1073/1075",205,475]
[155,"  London",2400,1100,900,null,null,null,"1076/1075",315,785,"1073/1075",205,895]
[156,"Sveits",1450,1050,1070,null,null,null,"1076/1075",315,735,"1073/1075",205,845]
[157,"  Genève",4000,1050,1270,null,null,null,"1076/1075",315,735,"1073/1075",205,845]
[158,"  Zürich",3000,1200,1290,null,null,null,"1076/1075",315,885,"1073/1075",205,995]
[159,"Sverige",1900,750,820,null,null,null,"1076/1075",315,435,"1073/1075",205,545]
[160,"Tjekkiske republikk",1800,550,540,null,null,null,"1076/1075",315,235,"1073/1075",205,345]
[161,"Tyskland",1900,750,760,null,null,null,"1076/1075",315,435,"1073/1075",205,545]
[162,"  Berlin",2250,900,850,null,null,null,"1076/1075",315,585,"1073/1075",205,695]
[163,"Ukraina",1400,530,430,null,null,null,"1076/1075",315,215,"1073/1075",205,325]
[164,"Ungarn",2000,640,590,null,null,null,"1076/1075",315,325,"1073/1075",205,435]
[165,"Østerrike",1400,760,830,null,null,null,"1076/1075",315,445,"1073/1075",205,555]
[166,"  Wien",1900,900,810,null,null,null,"1076/1075",315,585,"1073/1075",205,695]
[null,"Afrika:",null,null,null,null,null,null,"1076/1075",315,-315,"1073/1075",205,-205]
[null,"Algerie",1900,700,550,null,null,null,"1076/1075",315,385,"1073/1075",205,495]
[3,"Angola",2650,1270,1320,null,null,null,"1076/1075",315,955,"1073/1075",205,1065]
[4,"Benin",1550,490,670,null,null,null,"1076/1075",315,175,"1073/1075",205,285]
[5,"Botswana",1500,450,420,null,null,null,"1076/1075",315,135,"1073/1075",205,245]
[6,"Burundi",1000,460,430,null,null,null,"1076/1075",315,145,"1073/1075",205,255]
[null,"Demokratiske republikken Kongo",null,null,870]
[null,"Egypt",2400,650,280,null,null,null,"1076/1075",315,335,"1073/1075",205,445]
[7,"Elfenbenskysten",1620,700,710,null,null,null,"1076/1075",315,385,"1073/1075",205,495]
[8,"Eritrea",1050,700,700,null,null,null,"1076/1075",315,385,"1073/1075",205,495]
[9,"Etiopia",2000,450,450,null,null,null,"1076/1075",315,135,"1073/1075",205,245]
[null,"Gabon",null,null,940]
[10,"Ghana",2300,500,630,null,null,null,"1076/1075",315,185,"1073/1075",205,295]
[11,"Kamerun",1800,560,700,null,null,null,"1076/1075",315,245,"1073/1075",205,355]
[12,"Kenya",1600,580,650,null,null,null,"1076/1075",315,265,"1073/1075",205,375]
[13,"Lesotho",1000,350,340,null,null,null,"1076/1075",315,35,"1073/1075",205,145]
[14,"Madagaskar",900,350,350,null,null,null,"1076/1075",315,35,"1073/1075",205,145]
[15,"Malawi",1100,360,340,null,null,null,"1076/1075",315,45,"1073/1075",205,155]
[16,"Marokko",1800,670,540,null,null,null,"1076/1075",315,355,"1073/1075",205,465]
[17,"Mauritius",1150,480,570,null,null,null,"1076/1075",315,165,"1073/1075",205,275]
[18,"Mosambik",2100,690,410,null,null,null,"1076/1075",315,375,"1073/1075",205,485]
[19,"Namibia",1350,360,420,null,null,null,"1076/1075",315,45,"1073/1075",205,155]
[20,"Nigeria",3200,980,680,null,null,null,"1076/1075",315,665,"1073/1075",205,775]
[21,"Seychellene",2500,810,750,null,null,null,"1076/1075",315,495,"1073/1075",205,605]
[22,"Sudan ",1750,800,660,null,null,null,"1076/1075",315,485,"1073/1075",205,595]
[23,"Swasiland",1100,350,360,null,null,null,"1076/1075",315,35,"1073/1075",205,145]
[24,"Sør-Afrika",2500,540,440,null,null,null,"1076/1075",315,225,"1073/1075",205,335]
[null,"Sør-Sudan",1900,580,350,null,null,null,"1076/1075",315,265,"1073/1075",205,375]
[25,"Tanzania",1950,650,520,null,null,null,"1076/1075",315,335,"1073/1075",205,445]
[26,"Togo",1000,500,610,null,null,null,"1076/1075",315,185,"1073/1075",205,295]
[27,"Zambia",1350,600,570,null,null,null,"1076/1075",315,285,"1073/1075",205,395]
[28,"Zimbabwe",1300,590,740,null,null,null,"1076/1075",315,275,"1073/1075",205,385]
[29,"Øvrige områder",1700,580,580,null,null,null,"1076/1075",315,265,"1073/1075",205,375]
[30,"Amerika:",null,null,null,null,null,null,"1076/1075",315,-315,"1073/1075",205,-205]
[31,"Argentina",1600,520,710,null,null,null,"1076/1075",315,205,"1073/1075",205,315]
[32,"Bahamas",2000,940,1150,null,null,null,"1076/1075",315,{"$f":"D143-J143","v":625},"1073/1075",205,{"$f":"D143-M143","v":735}]
[null,"Barbados",1450,860,1070,null,null,null,"1076/1075",315,545,"1073/1075",205,655]
[33,"Bolivia",650,340,430,null,null,null,"1076/1075",315,25,"1073/1075",205,135]
[34,"Brasil",2200,650,640,null,null,null,"1076/1075",315,335,"1073/1075",205,445]
[35,"  Rio de Janeiro",3000,820,720,null,null,null,"1076/1075",315,505,"1073/1075",205,615]
[36,"Canada ",2300,930,790,null,null,null,"1076/1075",315,615,"1073/1075",205,725]
[37,"Chile",1500,720,590,null,null,null,"1076/1075",315,405,"1073/1075",205,515]
[38,"Colombia",2000,500,550,null,null,null,"1076/1075",315,185,"1073/1075",205,295]
[39,"Costa Rica",1000,550,650,null,null,null,"1076/1075",315,235,"1073/1075",205,345]
[40,"Cuba",1100,560,570,null,null,null,"1076/1075",315,245,"1073/1075",205,355]
[42,"El Salvador",1000,440,600,null,null,null,"1076/1075",315,125,"1073/1075",205,235]
[44,"Guatemala",1100,550,720,null,null,null,"1076/1075",315,235,"1073/1075",205,345]
[45,"Guyana",1200,560,690,null,null,null,"1076/1075",315,245,"1073/1075",205,355]
[47,"Honduras",1200,400,490,null,null,null,"1076/1075",315,85,"1073/1075",205,195]
[null,"Jamaica",1200,610,700,null,null,null,"1076/1075",315,295,"1073/1075",205,405]
[48,"Mexico",2200,680,480,null,null,null,"1076/1075",315,365,"1073/1075",205,475]
[49,"Nicaragua",1200,460,530,null,null,null,"1076/1075",315,145,"1073/1075",205,255]
[50,"Panama",1400,500,650,null,null,null,"1076/1075",315,185,"1073/1075",205,295]
[51,"Paraguay",1200,500,460,null,null,null,"1076/1075",315,185,"1073/1075",205,295]
[52,"Peru",1500,750,680,null,null,null,"1076/1075",315,435,"1073/1075",205,545]
[53,"Puerto Rico",1200,700,890,null,null,null,"1076/1075",315,385,"1073/1075",205,495]
[54,"Surinam",1000,550,460,null,null,null,"1076/1075",315,235,"1073/1075",205,345]
[55,"Uruguay",1350,600,750,null,null,null,"1076/1075",315,285,"1073/1075",205,395]
[56,"USA",1750,700,870,null,null,null,"1076/1075",315,385,"1073/1075",205,495]
[57,"  New York",3000,950,1170,null,null,null,"1076/1075",315,635,"1073/1075",205,745]
[null,"San Francisco",2000,1000,980,null,null,null,"1076/1075",315,685,"1073/1075",205,795]
[58,"  Washington DC",3100,1000,990,null,null,null,"1076/1075",315,685,"1073/1075",205,795]
[59,"Venezuela",2400,1600,1600,null,null,null,"1076/1075",315,1285,"1073/1075",205,1395]
[60,"Øvrige områder",1700,710,740,null,null,null,"1076/1075",315,395,"1073/1075",205,505]
[61,"Asia:",null,null,null,null,null,null,"1076/1075",315,-315,"1073/1075",205,-205]
[62,"Afghanistan",2300,500,580,null,null,null,"1076/1075",315,185,"1073/1075",205,295]
[63,"Armenia",1400,500,470,null,null,null,"1076/1075",315,185,"1073/1075",205,295]
[64,"Aserbajdsjan",2650,750,500,null,null,null,"1076/1075",315,435,"1073/1075",205,545]
[65,"Bahrain",1650,800,820,null,null,null,"1076/1075",315,485,"1073/1075",205,595]
[66,"Bangladesh",3000,530,560,null,null,null,"1076/1075",315,215,"1073/1075",205,325]
[67,"Brunei",1000,400,510,null,null,null,"1076/1075",315,85,"1073/1075",205,195]
[69,"Filippinene",2100,700,580,null,null,null,"1076/1075",315,385,"1073/1075",205,495]
[70,"Forente arabiske emirater",1700,1000,1000,null,null,null,"1076/1075",315,685,"1073/1075",205,795]
[71,"Georgia",2200,570,390,null,null,null,"1076/1075",315,255,"1073/1075",205,365]
[72,"India",1700,500,520,null,null,null,"1076/1075",315,185,"1073/1075",205,295]
[74,"Indonesia",2600,550,550,null,null,null,"1076/1075",315,235,"1073/1075",205,345]
[75,"Iran",1600,750,630,null,null,null,"1076/1075",315,435,"1073/1075",205,545]
[76,"Israel",2900,900,1170,null,null,null,"1076/1075",315,585,"1073/1075",205,695]
[78,"Japan",2200,700,770,null,null,null,"1076/1075",315,385,"1073/1075",205,495]
[null,"Jemen",1200,500,580,null,null,null,"1076/1075",315,185,"1073/1075",205,295]
[79,"Jordan",2800,1150,910,null,null,null,"1076/1075",315,835,"1073/1075",205,945]
[80,"Kambodsja",1650,670,570,null,null,null,"1076/1075",315,355,"1073/1075",205,465]
[81,"Kasakhstan",1750,700,450,null,null,null,"1076/1075",315,385,"1073/1075",205,495]
[82,"Kina",2000,730,750,null,null,null,"1076/1075",315,415,"1073/1075",205,525]
[83,"  Hong Kong",3100,1000,920,null,null,null,"1076/1075",315,685,"1073/1075",205,795]
[84,"  Shanghai",2400,870,810,null,null,null,"1076/1075",315,555,"1073/1075",205,665]
[85,"Kuwait",1700,730,900,null,null,null,"1076/1075",315,415,"1073/1075",205,525]
[87,"Laos",1500,500,470,null,null,null,"1076/1075",315,185,"1073/1075",205,295]
[88,"Libanon",2200,890,910,null,null,null,"1076/1075",315,575,"1073/1075",205,685]
[89,"Malaysia",1400,600,420,null,null,null,"1076/1075",315,285,"1073/1075",205,395]
[90,"Maldivene",3000,660,490,null,null,null,"1076/1075",315,345,"1073/1075",205,455]
[91,"Myanmar (Burma)",1700,690,500,null,null,null,"1076/1075",315,375,"1073/1075",205,485]
[93,"Nord-Korea",1000,450,520,null,null,null,"1076/1075",315,135,"1073/1075",205,245]
[94,"Oman",2700,800,980,null,null,null,"1076/1075",315,485,"1073/1075",205,595]
[95,"Pakistan",2100,400,440,null,null,null,"1076/1075",315,85,"1073/1075",205,195]
[null,"Palestina",1400,800,920,null,null,null,"1076/1075",315,485,"1073/1075",205,595]
[96,"Qatar",1600,730,920,null,null,null,"1076/1075",315,415,"1073/1075",205,525]
[97,"Saudi-Arabia",2700,890,790,null,null,null,"1076/1075",315,575,"1073/1075",205,685]
[98,"Singapore",3250,800,810,null,null,null,"1076/1075",315,485,"1073/1075",205,595]
[99,"Sri Lanka",1200,410,440,null,null,null,"1076/1075",315,{"$f":"D207-J207","v":95},"1073/1075",205,{"$f":"D207-M207","v":205}]
[101,"Sør-Korea",2000,1100,880,null,null,null,"1076/1075",315,785,"1073/1075",205,895]
[103,"Taiwan",2700,600,680,null,null,null,"1076/1075",315,285,"1073/1075",205,395]
[104,"Thailand",1400,700,690,null,null,null,"1076/1075",315,385,"1073/1075",205,495]
[105,"Tyrkia",2000,520,460,null,null,null,"1076/1075",315,205,"1073/1075",205,315]
[106,"  Istanbul",2000,650,530,null,null,null,"1076/1075",315,335,"1073/1075",205,445]
[null,"Uzbekistan",1000,400,390,null,null,null,"1076/1075",315,85,"1073/1075",205,195]
[107,"Vietnam",1300,550,480,null,null,null,"1076/1075",315,235,"1073/1075",205,345]
[109,"Øst Timor",850,510,630,null,null,null,"1076/1075",315,195,"1073/1075",205,305]
[110,"Øvrige områder",2000,690,660,null,null,null,"1076/1075",315,375,"1073/1075",205,485]
[111,"Australia og Oceania:",null,null,null,null,null,null,"1076/1075",315,-315,"1073/1075",205,-205]
[112,"Australia",2000,950,960,null,null,null,"1076/1075",315,635,"1073/1075",205,745]
[114,"New Zealand",1250,700,810,null,null,null,"1076/1075",315,385,"1073/1075",205,495]
[115,"Papua Ny-Guinea",2500,630,660,null,null,null,"1076/1075",315,315,"1073/1075",205,425]
[116,"Øvrige områder",1900,740,810,null,null,null,"1076/1075",315,425,"1073/1075",205,535]
[]
[]
[]
[]
[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"]