{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["A","B","C","D","E"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":19,"comments":2,"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":72,"n_cols":19,"rows_kept":72,"cut":false,"hidden":false,"merged":[[61,14,61,16],[61,5,61,6],[60,16,60,17],[51,2,51,5],[52,2,52,11],[55,2,56,3],[58,6,58,14],[57,2,58,3],[53,15,58,18],[53,6,53,14],[61,7,61,9],[62,7,62,9],[63,7,63,9],[63,5,63,6],[53,2,54,3],[51,6,51,7],[49,2,49,11],[50,5,50,7],[50,2,50,3],[54,6,54,14],[57,6,57,14],[13,6,13,7],[21,6,21,7],[26,5,26,7],[17,5,17,7],[14,6,14,7],[23,6,23,7],[55,10,55,14],[30,5,30,7],[37,5,37,7],[29,5,29,7],[35,5,35,7],[36,5,36,7],[32,5,32,7],[34,6,34,7],[28,5,28,7],[8,2,8,3],[7,11,7,18],[5,17,5,18],[16,2,25,3],[10,2,10,3],[13,2,15,3],[8,5,8,10],[6,17,6,18],[6,12,6,14],[7,5,7,8],[12,13,12,18],[6,15,6,16],[6,2,6,3],[4,2,4,3],[4,5,4,7],[0,15,1,18],[8,15,10,18],[9,5,9,11],[10,5,10,11],[2,15,2,18],[2,7,2,14],[3,17,3,18],[3,15,3,16],[3,13,3,14],[5,13,5,14],[6,10,6,11],[6,5,6,8],[4,11,4,12],[4,14,4,18],[5,15,5,16],[2,2,2,5],[5,5,5,8],[5,2,5,3],[3,2,3,3],[3,5,3,11],[9,2,9,3],[7,2,7,3],[15,6,15,7],[16,5,16,7],[22,6,22,7],[18,5,18,7],[27,5,27,7],[20,5,20,7],[19,5,19,7],[24,6,24,7],[25,6,25,7],[26,2,27,3],[47,10,47,11],[48,10,48,11],[46,10,46,11],[30,2,34,3],[33,5,33,7],[31,5,31,7],[40,2,40,4],[45,2,45,4],[45,10,45,11],[48,2,48,4],[47,2,47,4],[39,2,39,4],[46,2,46,4],[42,2,42,4],[44,2,44,4],[43,2,43,4],[41,2,41,3],[28,2,28,3],[29,2,29,3],[37,2,37,3],[35,2,36,3]]}
[]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,"\n\n"]
[null,null,null,null,null,null,null,"     Reiseregning (fra 01.01.2019) ",null,null,null,null,null,null,null,"Reisenummer"]
[null,null,"Etter og fornavn",null,null,"Andersen, Fjodolf",null,null,null,null,null,null,"Fødselsnr.","29020012345",null,"Ansattnr"]
[null,null,"Dokumenttype",null,null,null,null,null,null,null,"Nummer",null,null,"Land"]
[null,null,"Privatadresse",null,null,"Slottsplassen 1",null,null,null,null,"Postnr.","0010","Poststed","Oslo",null,"Klient "]
[null,null,"Stilling",null,null,"Campusleder",null,null,null,null,"Bankkontonummer",null,"2412 00 12345",null,null,"Firmakode"]
[null,null,"Virksomhet",null,null,"Studentdemokratiet",null,null,null,null,"Avd/tj.sted"]
[null,null,"Regulativ",null,null,null,null,null,null,null,null,"Region",null,"  Dato","  Kl.","De feltene som er merket med grønt og har fortekster i kursiv, skal bare fylles ut dersom du ikke er registrert i lønnssystemet fra før."]
[null,null,"Reisemål",null,null,"Campus Ringerike",null,null,null,null,null,null,"  Utreise","01.01.20","13.00"]
[null,null,"Reiseårsak",null,null,"Møte i ledergruppa",null,null,null,null,null,null,"  Retur","01.01.20","22.30"]
[null,null,"Reiseutlegg / godtgjøringer",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,null,"      OVERFØRT  FRA  BAKSIDEN",null,null,null,null,null,null,null,"              ",null,{"$f":"IF(B!N36=0,0,B!N36)","v":0},"  "]
[null,null,"Kostgodtgjøring uten overnatting, ulegitimert",null,null,"Innland",null,null,null,null,null,{"$f":"IF(AND(K14<>0,G14<>\"\"),VLOOKUP(G14,'C'!C9:F10,4),\"\")","v":""},{"$f":"IF(AND(K14<>0,G14<>\"\"),+K14*L14,0)","v":0}]
[null,null,null,null,null,"Utl. 6-12 timer",null,null,null,null,null,{"$f":"IF(G15<>0,(1/2*(VLOOKUP(G15,'C'!$B$53:$D$220,3,FALSE))),\"\")","v":""},{"$f":"IF(G15<>0,+K15*L15,0)","v":0}]
[null,null,null,null,null,"Utl. > 12 timer",null,null,null,null,null,{"$f":"IF(G16<>0,((VLOOKUP(G16,'C'!$B$53:$D$220,3,FALSE))),\"\")","v":""},{"$f":"IF(K16<>0,+K16*L16,0)","v":0}]
[null,null,"Kostgodtgjøring ved overnatting, ulegitimert ",null,null,"Hotell innland",null,null,null,null,null,{"$f":"IF(K17<>0,'C'!F12,\"\")","v":""},0]
[null,null,null,null,null,"Pensjonat innland *",null,null,null,null,null,{"$f":"IF(K18<>0,'C'!F12,\"\")","v":""},0]
[null,null,null,null,null,"Hybel/brakke/privat innland *",null,null,null,null,null,{"$f":"IF(K19<>0,'C'!F12,\"\")","v":""},0]
[null,null,null,null,null,"Tilleggsdøgn innland 6-12 t",null,null,null,null,0,{"$f":"K20*'C'!F9","v":0},0]
[null,null,null,null,null,"Tilleggsdøgn innland over 12 t",null,null,null,null,null,{"$f":"K21*'C'!F10","v":0},0]
[null,null,null,null,null,"Hotell utland",null,null,null,null,null,{"$f":"IF(G22<>0,VLOOKUP(G22,'C'!$B$53:$D$220,3,FALSE),\"\")","v":""},0]
[null,null,null,null,null,"Hotell utland",null,null,null,null,null,{"$f":"IF(G23<>0,VLOOKUP(G23,'C'!$B$53:$D$220,3,FALSE),\"\")","v":""},0]
[null,null,null,null,null,"Pensj.utl. *",null,null,null,null,null,{"$f":"IF(G24<>0,VLOOKUP(G24,'C'!$B$53:$D$220,3,FALSE),\"\")","v":""},0]
[null,null,null,null,null,"Hy./br./pr. utl *.",null,null,null,null,null,{"$f":"IF(G25<>0,VLOOKUP(G25,'C'!$B$53:$D$220,3,FALSE),\"\")","v":""},0]
[null,null,null,null,null,"Til.døgn 6-12t",null,null,null,null,null,{"$f":"IF(G26<>0,(1/2*(VLOOKUP(G26,'C'!$B$53:$D$220,3,FALSE))),\"\")","v":""},0]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K27<>0,'C'!F6,\"\")","v":""},{"$f":"IF(K27<>0,+K27*L27,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K28<>0,'C'!F7,\"\")","v":""},{"$f":"IF(K28<>0,+K28*L28,0)","v":0}]
[null,null,"Nattillegg, uleg.",null,null,"Innland",null,null,null,null,null,{"$f":"IF(K29<>0,'C'!F17,\"\")","v":""},{"$f":"IF(K29<>0,+K29*L29,0)","v":0}]
[null,null,"Komp. Tillegg",null,null,"Utland*",null,null,null,null,null,{"$f":"IF(K30<>0,'C'!F13,\"\")","v":""},0]
[null,null,"Eget skyssmiddel. Spesifiser reisen på baksiden.",null,null,"Bil ",null,null,null,null,{"$f":"B!J16","v":240},{"$f":"IF(K31<>0,(IF(M9=\"Tromsø\",'C'!F35,'C'!F33)),\"\")","v":4.03},967.2]
[null,null,null,null,null,"Hjem-arbeid  ( skattepl.) *",null,null,null,null,{"$f":"B!J17","v":0},{"$f":"IF(K32<>0,(IF(M9=\"Tromsø\",'C'!F35,'C'!F33)),\"\")","v":""},0]
[null,null,null,null,null,"Km. godtgjørelse utland",null,null,null,null,{"$f":"B!J18","v":0},{"$f":"IF(K33<>0,'C'!F37,\"\")","v":""},0]
[null,null,null,null,null,"Passasjertillegg, se merknadsfelt",null,null,null,null,120,{"$f":"IF(K34<>\"\",'C'!F38,\"\")","v":1},120,"   "]
[null,null,null,null,null,"Annet",null,null,null,null,null,{"$f":"IF(AND(G35<>\"\",K35<>\"\"),VLOOKUP(G35,'C'!C39:F45,4,FALSE),\"\")","v":""},0]
[null,null,"Opphold utover 28 døgn",null,null,"Kostgodtgjøring",null,null,null,null,null,{"$f":"K36*'C'!F20","v":0},0]
[null,null,null,null,null,"Nattillegg",null,null,null,null,null,null,0]
[null,null,"Andre godtgj.",null,null,null,null,null,null,null,null,null,{"$f":"IF(K38<>0,+K38*L38,0)","v":0}]
[null,null,"   TIL  SAMMEN",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(M13:M38)<>0,SUM(M13:M38),0)","v":1087.2}]
[null,null,"Trekk for kost",null,null,"Frokost","Lunsj","Middag"]
[null,null,"6-12 timer",null,null,null,null,null,null,null,null,null,{"$f":"IF(E!G2>M14,M14*-1,IF((E!G2*-1)<>0,(E!G2*-1),0))","v":0}]
[null,null,"over 12 timer",null,null,null,null,null,null,null,null,null,{"$f":"IF(E!G3>M14,M14*-1,IF((E!G3*-1)<>0,(E!G3*-1),0))","v":0}]
[null,null,"Hotell innland",null,null,null,null,null,null,null,null,null,{"$f":"IF((E!G4*-1)<>0,(E!G4*-1),0)","v":0}]
[null,null,"Pensjonat innl. *",null,null,null,null,null,null,null,null,null,{"$f":"IF((E!G5*-1)<>0,(E!G5*-1),0)","v":0}]
[null,null,"Hy../br../pr. innl. *",null,null,null,null,null,null,null,null,null,{"$f":"IF((E!G6*-1)<>0,(E!G6*-1),0)","v":0}]
[null,null,"Hotell utland",null,null,null,null,null,null,null,null,null,{"$f":"IF(ROUND((E!G7*-1),)<>0,ROUND((E!G7*-1),),0)","v":0}]
[null,null,"Hotell utland",null,null,null,null,null,null,null,null,null,{"$f":"IF(ROUND((E!G8*-1),)<>0,ROUND((E!G8*-1),),0)","v":0}]
[null,null,"Pensjonat.utl.*",null,null,null,null,null,null,null,null,null,{"$f":"IF(ROUND((E!G9*-1),)<>0,ROUND((E!G9*-1),),0)","v":0}]
[null,null,"Hy./br./pr.utl. *",null,null,null,null,null,null,null,null,null,{"$f":"IF(ROUND((E!G10*-1),)<>0,ROUND((E!G10*-1),),0)","v":0}]
[null,null,"   Sum reiseoppgjør",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(M39:M49)<>0,SUM(M39:M49),0)","v":1087.2}]
[null,null,"Annet trekk"]
[null,null,"Reiseforskudd utbet.sted"]
[null,null," Totalsum (Trekkpliktige ytelser er merket med *)",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(M50:M52)<>0,SUM(M50:M52),0)","v":1087.2}]
[null,null,"Utstederens underskrift",null,"Dato",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,"02.01.20","Signatur"]
[null,null,"Kontroll",null,"Dato","Dato","Sign.",null,null,null,"Er virksomheten omfattet av nettoføringsordningen?"]
[]
[null,null,"Budsjett- disponering",null,"Dato","Dato","Sign."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-01-01"]
[]
[null,null,null,"REGION",null,"ULEGITIMERT ",null,null,null,null,null,null,null,null,"ANDRE FREMKOMSTMIDLER",null,null,null,"REGULATIV"]
[null,null,null,null,null,"KOSTGODTGJØRELSE"]
[null,null,null,"Tromsø",null,"MED OVERNATTING",null,null,null,null,null,null,null,null,null,null,{"$f":"'C'!#REF!","v":{"$error":"#REF!"}},null,"Tjenestereise"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'C'!F41","v":4.03},null,"Tj.reise dagreise innenlands"]
[null,null,null,null,null,"5-9 timer",null,"8 - 12 timer",null,null,null,"SAP",null,null,null,null,{"$f":"'C'!F39","v":2},null,"Tj.reise (>28 dager)"]
[null,null,null,null,null,"9-12 timer",null,"over 12 timer",null,null,null,null,null,null,null,null,{"$f":"'C'!#REF!","v":{"$error":"#REF!"}},null,"Tj.reise (pensjonat u/kok)"]
[null,null,null,null,null,"over 12 timer",null,null,null,null,null,null,null,null,null,null,{"$f":"'C'!F47","v":0},null,"Tj.reise (hybel/priv. m/kok)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'C'!F48","v":0},null,"Pensj. u/kok (trekkfri)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'C'!F49","v":0},null,"Hybel/priv. med kok (trekkfri)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'C'!F50","v":0},null,"Feltavtale"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'C'!F51","v":0},null,"Feltavtale HINT"]

{"sheet":"B","index":1,"n_rows":66,"n_cols":14,"rows_kept":66,"cut":false,"hidden":false,"merged":[[4,3,4,4],[49,1,49,10],[41,10,41,12],[1,10,1,13],[2,10,2,12],[17,6,17,8],[16,3,16,5],[7,3,7,4],[8,3,8,4],[10,3,10,4],[20,10,20,12],[15,1,16,1],[9,3,9,4],[11,3,11,4],[12,3,12,4],[15,6,15,8],[15,3,15,4],[5,3,5,4],[6,3,6,4],[13,3,13,4],[14,3,14,4],[20,1,20,9],[16,6,16,8],[52,1,59,13],[51,1,51,13],[47,1,47,10],[48,1,48,10],[41,1,41,9]]}
[]
[null,"   Reisespesifikasjon",null,null,null,null,null,null,null,null,"   Reiseutlegg"]
[null,null,"   Fra",null,null,"    Til",null,null," Skyssmiddel",null,"    Fremmed valuta"]
[null,"  Dato","Klokkeslett","   Sted",null,"    Sted","Klokkeslett","Type","Kjøre- form","Km","Valuta","Beløp i valuta"," Kurs","   Beløp"]
[null,"01.01.20","13.00","Bakkenteigen",null,"Drammen","13.45","Bil",null,60,null,null,null,{"$f":"IF(AND(L5<>0,M5<>0),L5*M5,L5)","v":0}]
[null,"01.01.20","13.45","Drammen ",null,"Ringerike","14.45","Bil",null,60,null,null,null,{"$f":"IF(AND(L6<>0,M6<>0),L6*M6,L6)","v":0}]
[null,"01.01.20","20.45","Ringerike ",null,"Drammen","21.45","Bil",null,60,null,null,null,0]
[null,"01.01.20","21.45","Drammen ",null,"Ringerike","22.30","Bil",null,60,null,null,null,0]
[null,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,null,0]
[null,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,null,0]
[null,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,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Hjemmel for bruk av bil"," Dato",null,null,null,"Sum km ",null,null,{"$f":"I63","v":240},null,null,"Delsum",{"$f":"IF(SUM(N5:N15)<>0,SUM(N5:N15),0)","v":0}]
[null,null," Gitt av",null,null,null,"Sum km hjem-arbeid",null,null,{"$f":"I65","v":0}]
[null,null,"   ",null,null,null,"Sum km utland",null,null,{"$f":"I66","v":0}]
[]
[]
[null,"   Utlegg til overnatting, bompenger m.m.",null,null,null,null,null,null,null,null,"  Fremmed valuta"]
[null,"  Dato","Spesifikasjon",null,null,null,null,null,null,"Papir- kvittering","Valuta","Beløp i valuta","  Kurs","Beløp"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(L23<>0,M23<>0),L23*M23,L23)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(L24<>0,M24<>0),L24*M24,L24)","v":0}]
[null,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,null,0]
[null,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,null,0]
[null,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,null,0]
[null,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,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"   ","   ",null,null,null,null,null,null,null,null,null,"Delsum",{"$f":"IF(SUM(N23:N33)<>0,SUM(N23:N33),0)","v":0}]
[]
[null,null,null,null,"  Reiseutlegg - overføres automatisk til forsiden",null,null,null,null,null,null,null,"Sum",{"$f":"IF(OR(N16<>0,N34<>0),N16+N34,0)","v":0}]
[]
[]
[]
[]
[]
[null,"  Betalt av arbeidsgiver",null,null,null,null,null,null,null,null,"  Fremmed valuta"]
[null,"  Dato","Spesifikasjon",null,null,null,null,null,null,null,"Valuta","Beløp i valuta","  Kurs","Beløp"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(L44<>0,M44<>0),L44*M44,L44)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(L45<>0,M45<>0),L45*M45,L45)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(L46<>0,M46<>0),L46*M46,L46)","v":0}]
[]
[null,"   Overnatting (Navn på og sted for hotell, pensjonat e.a. (ikke privat).)"]
[null,"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."]
[]
[]
[null,"   Merknader (Navn på passasjerer må oppgis her.)"]
[null,"Passasjer Drammen- Ringerike: Lykke Sol og Mons Monsen. Passasjer Ringerike- Drammen: Lykke Sol."]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A!R60","v":"2019-01-01"}]
[null,"Tidsintervall",null,"JA/NEI",null,null,null,"Summering av kjøretype"]
[null,null,null,null,null,null,null,null,{"$f":"SUMIF($I$5:$I$15,\"\",$J$5:$J$15)","v":240}]
[null,"5-9 timer",null,"Ja",null,null,null,null,{"$f":"SUMIF($I$5:$I$15,H64,$J$5:$J$15)","v":0}]
[null,"9-12 timer",null,"Nei",null,null,null,"X",{"$f":"SUMIF($I$5:$I$15,H65,$J$5:$J$15)","v":0}]
[null,"over 12 timer",null,null,null,null,null,"U",{"$f":"SUMIF($I$5:$I$15,H66,$J$5:$J$15)","v":0}]

{"sheet":"C","index":2,"n_rows":241,"n_cols":7,"rows_kept":241,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"      SATSTYPE",null,null,null,"Sats","Maks % av godtgjørelse"]
[null,"      Administrativ forpleining"]
[null,"      Administrativ forpleining utland",null,null,null,0]
[null,"      Innland, kostgodtgj. u/overnatting"]
[null,"      Innland, kostgodtgj. u/overnatting","6-12 timer",null,null,307]
[null,"      Innland, kostgodtgj. u/overnatting","over 12 timer",null,null,570]
[null,"      Grense for legitimerte overnattingsutgifter, innland",null,null,null,0]
[null,"      Innland, over 12 kostgodtgj m/overnatting","over 12 timer",null,null,780]
[null,"      Kompensasjonstillegg, utland",null,null,null,531]
[]
[null,"      Trekkfri kostgodtgjørelse for pensjonat",null,null,null,161]
[null,"      Trekkfri kostgodtgjørelse hybel/brakke/priv",null,null,null,89]
[null,"      Innland, ulegitimert  nattillegg",null,null,null,435]
[null,"      Kostgodtgjøring beordring 0-28 døgn",null,null,null,780]
[null,"      Ulegitimert overnatting beordring 0-28 døgn",null,null,null,435]
[null,"      Kostgodtgjørelse beording over 28 døgn",null,null,null,202]
[null,"      Trekk, frokost innland dagreise 6-12",null,null,null,156]
[null,"      Trekk, lunsj, innland dagreise 6-12",null,null,null,234]
[null,"      Trekk, middag, innland dagreise 6-12",null,null,null,390]
[null,"      Trekk, frokost innland dagreise over 12 t",null,null,null,156]
[null,"      Trekk, lunsj, innland dagreise over 12 t",null,null,null,234]
[null,"    Trekk, middag, innland dagreise over 12 t",null,null,null,390]
[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]
[null,"      Trekk prosent frokost utland",null,null,null,0.2]
[null,"      Trekk prosent lunsj utland",null,null,null,0.3]
[null,"      Trekk prosent middag utland",null,null,null,0.5]
[null,"      Km-godtgjørelse 0- 10000 km",null,null,null,4.03]
[null,"      Km-godtgjørelse over 10000 km *",null,null,null,4.03]
[null,"      Kilometergodtgjørelse i Tromsø 0-10000",null,null,null,4.13]
[null,"      Kilometergodtgjørelse Tromsø > 10000",null,null,null,4.13]
[null,"      Kilometergodtgjørelse utland",null,null,null,4.03]
[null,"      Passasjertillegg",null,null,null,1]
[null,"      Km.godtgj.","Moped, motorsykkel opp tom 125 ccm og andre motoriserte fremkomstmidler",null,null,2]
[null,"      Km.godtgj.","Båt med motor",null,null,7.5]
[null,"      Km.godtgj.","EL-bil",null,1061,4.03]
[null,"      Km.godtgj.","Motorsykkel over 125 ccm",null,null,2.95]
[null,"      Km.godtgj.","Snøscooter og ATV",null,null,7.5]
[null,"      Tillegg","Skogs- og anleggsveier",null,null,1]
[null,"      Tillegg","Tilhenger",null,null,1]
[]
[null,null,null,null,1067]
[null,null,null,null,1065]
[null,null,null,null,1062]
[null,null,null,null,1066]
[]
[]
[1,null,null,"Kost"]
[117,"Europa:"]
[118,"Albania",null,360]
[119,"Belgia",null,920]
[120,"Bosnia- Hercegovina",null,490]
[121,"Bulgaria",null,520]
[122,"Danmark",null,1220]
[123,"  København",null,1220]
[124,"Estland",null,670]
[125,"Finland",null,970]
[126,"Frankrike",null,770]
[127,"  Paris",null,940]
[128,"Hellas",null,780]
[129,"Hviterussland",null,380]
[130,"Irland",null,910]
[131,"Island",null,1150]
[null,"Italia",null,790]
[null,"Kosovo",null,370]
[132,"Kroatia",null,610]
[null,"Kypros",null,750]
[133,"Latvia",null,690]
[134,"Liechtenstein",null,1240]
[135,"Litauen",null,530]
[136,"Luxembourg",null,960]
[137,"Makedonia",null,460]
[138,"Malta",null,700]
[139,"Moldova",null,370]
[140,"Monaco",null,1080]
[141,"Montenegro",null,590]
[142,"Nederland",null,790]
[143,"Polen",null,590]
[144,"Portugal",null,630]
[145,"Romania",null,470]
[146,"Russland",null,450]
[147,"  Moskva",null,630]
[148,"  St. Petersburg",null,530]
[149,"Serbia",null,540]
[151,"Slovakia",null,660]
[152,"Slovenia",null,690]
[153,"Spania",null,740]
[154,"Storbritannia",null,760]
[155,"  London",null,900]
[156,"Sveits",null,1110]
[158,"  Zürich",null,1240]
[null,"  Geneve",null,1240]
[159,"Sverige",null,800]
[160,"Tjekkiske republikk",null,560]
[161,"Tyskland",null,780]
[162,"  Berlin",null,840]
[163,"Ukraina",null,440]
[164,"Ungarn",null,600]
[165,"Østerrike",null,840]
[166,"  Wien",null,810]
[null,"Afrika:"]
[null,"Algerie",null,500]
[3,"Angola",null,970]
[4,"Benin",null,690]
[5,"Botswana",null,450]
[6,"Burundi",null,400]
[null,"Egypt",null,340]
[7,"Elfenbenskysten",null,740]
[8,"Eritrea",null,690]
[9,"Etiopia",null,420]
[null,"Gabon",null,940]
[10,"Ghana",null,570]
[11,"Kamerun",null,680]
[12,"Kenya",null,650]
[null,"Kongo",null,720]
[null,"Demokratiske republikken Kongo",null,870]
[13,"Lesotho",null,380]
[14,"Madagaskar",null,330]
[15,"Malawi",null,400]
[16,"Marokko",null,540]
[17,"Mauritius",null,590]
[18,"Mosambik",null,410]
[19,"Namibia",null,450]
[20,"Nigeria",null,640]
[21,"Seychellene",null,760]
[22,"Sudan ",null,250]
[23,"Swaziland",null,380]
[24,"Sør-Afrika",null,450]
[null,"Sør-Sudan",null,540]
[25,"Tanzania",null,490]
[26,"Togo",null,610]
[27,"Zambia",null,460]
[28,"Zimbabwe",null,720]
[29,"Øvrige områder",null,560]
[30,"Amerika:"]
[31,"Argentina",null,580]
[32,"Bahamas",null,1120]
[null,"Barbados",null,1040]
[33,"Bolivia",null,440]
[34,"Brasil",null,560]
[35,"  Rio de Janeiro",null,620]
[36,"Canada ",null,820]
[37,"Chile",null,620]
[38,"Colombia",null,550]
[39,"Costa Rica",null,650]
[40,"Cuba",null,550]
[42,"El Salvador",null,590]
[44,"Guatemala",null,680]
[45,"Guyana",null,640]
[47,"Honduras",null,470]
[null,"Jamaica",null,720]
[48,"Mexico",null,440]
[49,"Nicaragua",null,480]
[50,"Panama",null,650]
[51,"Paraguay",null,460]
[52,"Peru",null,670]
[53,"Puerto Rico",null,880]
[54,"Surinam",null,450]
[55,"Uruguay",null,680]
[56,"USA",null,860]
[57,"  New York",null,1150]
[null,"  San Francisco",null,950]
[58,"  Washington",null,960]
[59,"Venezuela",null,1600]
[60,"Øvrige områder",null,720]
[61,"Asia:"]
[62,"Afghanistan",null,580]
[63,"Armenia",null,440]
[64,"Aserbajdsjan",null,470]
[65,"Bahrain",null,820]
[66,"Bangladesh",null,540]
[67,"Brunei",null,550]
[69,"Filippinene",null,540]
[70,"Forente arabiske emirater",null,1050]
[71,"Georgia",null,380]
[72,"India",null,500]
[74,"Indonesia",null,520]
[75,"Iran",null,460]
[76,"Israel",null,1080]
[78,"Japan",null,730]
[null,"Jemen",null,580]
[79,"Jordan",null,870]
[80,"Kambodsja",null,570]
[81,"Kazakhstan",null,430]
[82,"Kina",null,810]
[83,"  Hong Kong",null,890]
[84,"  Shanghai",null,810]
[85,"Kuwait",null,880]
[87,"Laos",null,460]
[88,"Libanon",null,890]
[89,"Malaysia",null,440]
[90,"Maldivene",null,500]
[91,"Myanmar (Burma)",null,500]
[93,"Nord-Korea",null,520]
[94,"Oman",null,940]
[95,"Pakistan",null,360]
[null,"Palestina",null,920]
[96,"Qatar",null,880]
[97,"Saudi Arabia",null,790]
[98,"Singapore",null,830]
[99,"Sri Lanka",null,410]
[101,"Sør-Korea",null,890]
[103,"Taiwan",null,680]
[104,"Thailand",null,710]
[105,"Tyrkia",null,390]
[106,"  Istanbul",null,430]
[null,"Uzbekistan",null,250]
[107,"Vietnam",null,480]
[109,"Øst Timor",null,610]
[110,"Øvrige områder",null,640]
[111,"Australia og Oceania:"]
[112,"Australia",null,950]
[114,"New Zealand",null,780]
[115,"Papua New Guinea",null,650]
[116,"Øvrige områder",null,790]
[]
[]
[]
[]
[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":false,"merged":[]}

{"sheet":"E","index":4,"n_rows":28,"n_cols":11,"rows_kept":28,"cut":false,"hidden":true,"merged":[[0,0,0,2],[1,0,1,2],[3,0,3,2],[6,0,6,2],[4,0,4,2],[2,0,2,2],[5,0,5,2],[18,0,18,2],[12,0,12,2],[16,0,16,2],[11,0,11,2],[13,0,13,2],[15,0,15,2],[17,0,17,2],[14,0,14,2],[7,0,7,2],[8,0,8,2],[9,0,9,2],[10,0,10,2]]}
["Trekk for kost",null,null,"Frokost","Lunsj","Middag","Sum",null,"Sats",null,"Veiledning"]
["Uten overnatting 6-12",null,null,{"$f":"IF(A!F41<>0,'C'!$F21*A!F41,\"\")","v":""},{"$f":"IF(A!G41<>0,'C'!$F22*A!G41,\"\")","v":""},{"$f":"IF(A!H41<>0,'C'!$F23*A!H41,\"\")","v":""},{"$f":"SUM(D2:F2)","v":0},{"$f":"IF(B!J5=\"\",\"\",+B!J5)","v":60},null,null,"fyll ut hvite felt. "]
["Uten overnatting over 12 t",null,null,{"$f":"IF(A!F42<>0,'C'!$F24*A!F42,\"\")","v":""},{"$f":"IF(A!G42<>0,'C'!$F25*A!G42,\"\")","v":""},{"$f":"IF(A!H42<>0,'C'!$F26*A!H42,\"\")","v":""},{"$f":"SUM(D3:F3)","v":0},{"$f":"IF(B!J6=\"\",\"\",+B!J6)","v":60},null,null,"fyll ut hvite felt. "]
["Hotell innland",null,null,{"$f":"IF(A!F43<>0,'C'!F12*'C'!F27*A!F43,\"\")","v":""},{"$f":"IF(A!G43<>0,'C'!F12*'C'!F28*A!G43,\"\")","v":""},{"$f":"IF(A!H43<>0,'C'!F12*'C'!F29*A!H43,\"\")","v":""},0,{"$f":"IF(B!J6=\"\",\"\",+B!J6)","v":60},null,null,"lagre lokalt"]
["Pensjonat",null,null,{"$f":"IF(A!F44<>0,'C'!F12*'C'!F27*A!F44,\"\")","v":""},{"$f":"IF(A!G44<>0,'C'!F12*'C'!F28*A!G44,\"\")","v":""},{"$f":"IF(A!H44<>0,'C'!F12*'C'!F29*A!H44,\"\")","v":""},{"$f":"SUM(D5:F5)","v":0},{"$f":"IF(B!J5=\"\",\"\",+B!J5)","v":60}]
["Hybel/brakke/privat",null,null,{"$f":"IF(A!F45<>0,'C'!F12*'C'!F27*A!F45,\"\")","v":""},{"$f":"IF(A!G45<>0,'C'!F12*'C'!F28*A!G45,\"\")","v":""},{"$f":"IF(A!H45<>0,'C'!F12*'C'!F29*A!H45,\"\")","v":""},{"$f":"SUM(D6:F6)","v":0},{"$f":"IF(B!J6=\"\",\"\",+B!J6)","v":60}]
["Hotell utland",null,null,{"$f":"IF(A!F46<>0,A!F46*E!I7*'C'!$F$30,\"\")","v":""},{"$f":"IF(A!G46<>0,A!G46*I7*'C'!$F$31,\"\")","v":""},{"$f":"IF(A!H46<>0,I7*A!H46*'C'!$F$32,\"\")","v":""},0,{"$f":"IF(B!J7=\"\",\"\",+B!J7)","v":60},{"$f":"VLOOKUP(A!K46,'C'!$B$54:$D$220,3,FALSE)","v":{"$error":"#N/A"}},null,"hvordan håndtere årsskifte - nullstille akkumulator"]
["Hotell utland",null,null,{"$f":"IF(A!F47<>0,A!F47*E!I8*'C'!$F$30,\"\")","v":""},{"$f":"IF(A!G47<>0,A!G47*I8*'C'!$F$31,\"\")","v":""},{"$f":"IF(A!H47<>0,I8*A!H47*'C'!$F$32,\"\")","v":""},0,{"$f":"IF(B!J8=\"\",\"\",+B!J8)","v":60},{"$f":"VLOOKUP(A!K47,'C'!$B$54:$D$220,3,FALSE)","v":{"$error":"#N/A"}}]
["Pensjonat",null,null,{"$f":"IF(A!F48<>0,A!F48*E!I9*'C'!$F$30,\"\")","v":""},{"$f":"IF(A!G48<>0,A!G48*I9*'C'!$F$31,\"\")","v":""},{"$f":"IF(A!H48<>0,I9*A!H48*'C'!$F$32,\"\")","v":""},0,{"$f":"IF(B!J9=\"\",\"\",+B!J9)","v":""},{"$f":"VLOOKUP(A!K48,'C'!$B$54:$D$220,3,FALSE)","v":{"$error":"#N/A"}}]
["Hybel/brakke/privat",null,null,{"$f":"IF(A!F49<>0,A!F49*E!I10*'C'!$F$30,\"\")","v":""},{"$f":"IF(A!G49<>0,A!G49*I10*'C'!$F$31,\"\")","v":""},{"$f":"IF(A!H49<>0,I10*A!H49*'C'!$F$32,\"\")","v":""},0,{"$f":"IF(B!J10=\"\",\"\",+B!J10)","v":""},{"$f":"VLOOKUP(A!K49,'C'!$B$54:$D$220,3,FALSE)","v":{"$error":"#N/A"}}]
["Nattillegg",null,null,{"$f":"IF(A!#REF!<>0,A!#REF!*E!I11*'C'!$F$30,\"\")","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"},null,{"$f":"VLOOKUP(A!#REF!,'C'!$B$54:$D$220,3,FALSE)","v":{"$error":"#REF!"}}]
["Kostgodtgjøring uten overnatting, 6-12 t.",null,null,1,null,"Her summeres kilometer hjem / arbeid."]
["Kostgodtgjøring uten overnatting, > 12 t.",null,null,1,null,{"$f":"SUMIF(B!I5:J15,\"X\",B!J5:J15)","v":0},null,null,null,"Satser for trekk av kost ved opphold på pensjonat"]
["Kostgodtgjøring med overnatting,  1",null,null,8,null,null,null,null,null,"Frokost",29]
["Kostgodtgjørimg med overnatting, 2",null,null,1,null,"Tromsø",null,null,null,"Lunsj",117]
["Nattillegg, 1",null,null,1,null,"høyere km.sats",null,null,null,"Middag",147]
["Nattillegg, 2",null,null,1,null,{"$f":"IF(A!M9=\"Tromsø\",1,\"\")","v":""},null,null,null,"Satser for trekk av kost ved opphold på hybel/brakke/privat"]
["Trekk for kost utland, 1",null,null,1,null,null,null,null,null,"Frokost",19]
["Trekk for kost utland, 1",null,null,1,null,null,null,null,null,"Lunsj",76]
[null,null,null,null,null,null,null,null,null,"Middag",95]
[]
["Passnummer"]
["Social security number"]
["Tax identification number",null,null,null,null,null,{"$f":"ROUNDDOWN(G9,0)","v":0}]
["VAT identification number"]
[]
["ja"]
["nei"]