{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Udgiftsrapport"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Udgiftsrapport","index":0,"n_rows":14,"n_cols":14,"rows_kept":14,"merged":[[0,1,0,5],[2,3,2,5],[2,6,2,7],[2,8,2,10],[4,3,4,5],[4,6,4,7],[4,8,4,10]]}
[null,"Rejseudgiftsrapport"]
[]
[null,"Navn","Kim Ambercrombie","Godkendt af",null,null,"Yossi Banai",null,"Refusion per kilometer",null,null,{"v":0.32,"d":"kr. 0.32"}]
[]
[null,"Afdeling","Salg","Afleveringsdato",null,null,{"$f":"TODAY()","v":"2018-01-18"},null,"Skyldig refusion i alt",null,null,{"$f":"SamletSkyldigRefusion","v":{"v":11079.235254237288,"d":"kr. 11,079.24"}}]
[]
[null,"Periode",{"$f":"IF(MIN(B10:B13)=MAX(B10:B13),TEXT(MIN(B10:B13),\"d-m-åå\"),\"From \"&TEXT(MIN(B10:B13),\"d-m-åå\")&\" to \"&TEXT(MAX(B10:B13),\"d-m-åå\"))","v":"From 19-12-17 to 24-12-17"}]
[]
[null,"Dato","Beskrivelse af udgifter","Flybilletter","Overnatning","Land \ntransport \n(benzin, lejebil, taxi)","Forplejning og drikkepenge","Konferencer og kurser","Kilometer","Kilometerrefusion","Diverse","Valutakurs","Udgiftsvaluta","Total"]
[null,{"$f":"TODAY()-30","v":"2017-12-19"},"Rejser til kundes kontor",{"v":350,"d":"350.00"},{"v":150,"d":"150.00"},{"v":45,"d":"45.00"},{"v":12,"d":"12.00"},{"v":50,"d":"50.00"},{"v":35,"d":"35.00"},{"$f":"IF(Udgiftsrapport!I10<>\"\",Udgiftsrapport!I10*Kilometertakst,\"\")","v":{"v":11.200000000000001,"d":"11.20"}},null,{"v":0.059,"d":"0.06"},"CAD",{"$f":"IFERROR(IF(OR(Udgiftsrapport!$L10=\"\",Udgiftsrapport!$L10=1),SUM(Udgiftsrapport!$J10:$K10,Udgiftsrapport!$D10:$H10)*1,SUM(Udgiftsrapport!$J10:$K10,Udgiftsrapport!$D10:$H10)/Udgiftsrapport!$L10),\"\")","v":{"v":10477.966101694916,"d":"kr. 10,477.97"}}]
[null,{"$f":"TODAY()-30","v":"2017-12-19"},"Frokost med kunde",{"$nulls":3},{"v":24.3,"d":"24.30"},null,{"v":12,"d":"12.00"},{"$f":"IF(Udgiftsrapport!I11<>\"\",Udgiftsrapport!I11*Kilometertakst,\"\")","v":3.84},null,{"v":0.059,"d":"0.06"},"CAD",{"$f":"IFERROR(IF(OR(Udgiftsrapport!$L11=\"\",Udgiftsrapport!$L11=1),SUM(Udgiftsrapport!$J11:$K11,Udgiftsrapport!$D11:$H11)*1,SUM(Udgiftsrapport!$J11:$K11,Udgiftsrapport!$D11:$H11)/Udgiftsrapport!$L11),\"\")","v":{"v":476.94915254237293,"d":"kr. 476.95"}}]
[null,"2017-12-19","Eftermiddagskursus",{"$nulls":4},{"v":100,"d":"100.00"},{"v":6,"d":"6.00"},{"$f":"IF(Udgiftsrapport!I12<>\"\",Udgiftsrapport!I12*Kilometertakst,\"\")","v":1.92},null,{"v":1,"d":"1.00"},"DKK",{"$f":"IFERROR(IF(OR(Udgiftsrapport!$L12=\"\",Udgiftsrapport!$L12=1),SUM(Udgiftsrapport!$J12:$K12,Udgiftsrapport!$D12:$H12)*1,SUM(Udgiftsrapport!$J12:$K12,Udgiftsrapport!$D12:$H12)/Udgiftsrapport!$L12),\"\")","v":{"v":101.92,"d":"kr. 101.92"}}]
[null,{"$f":"TODAY()-25","v":"2017-12-24"},"Rejse til lufthavn",{"$nulls":5},{"v":70,"d":"70.00"},{"$f":"IF(Udgiftsrapport!I13<>\"\",Udgiftsrapport!I13*Kilometertakst,\"\")","v":{"v":22.400000000000002,"d":"22.40"}},null,{"v":1,"d":"1.00"},"DKK",{"$f":"IFERROR(IF(OR(Udgiftsrapport!$L13=\"\",Udgiftsrapport!$L13=1),SUM(Udgiftsrapport!$J13:$K13,Udgiftsrapport!$D13:$H13)*1,SUM(Udgiftsrapport!$J13:$K13,Udgiftsrapport!$D13:$H13)/Udgiftsrapport!$L13),\"\")","v":{"v":22.400000000000002,"d":"kr. 22.40"}}]
[null,"Total",null,{"$f":"SUBTOTAL(109,Udgifter[Flybilletter])","v":{"v":350,"d":"350.00"}},{"$f":"SUBTOTAL(109,Udgifter[Overnatning])","v":{"v":150,"d":"150.00"}},{"$f":"SUBTOTAL(109,Udgifter[Land \ntransport \n(benzin, lejebil, taxi)])","v":{"v":45,"d":"45.00"}},{"$f":"SUBTOTAL(109,Udgifter[Forplejning og drikkepenge])","v":{"v":36.3,"d":"36.30"}},{"$f":"SUBTOTAL(109,Udgifter[Konferencer og kurser])","v":{"v":150,"d":"150.00"}},{"$f":"SUBTOTAL(109,Udgifter[Kilometer])","v":{"v":123,"d":"123.00"}},{"$f":"SUBTOTAL(109,Udgifter[Kilometerrefusion])","v":39.36},{"$f":"SUBTOTAL(109,Udgifter[Diverse])","v":{"v":0,"d":"0.00"}},null,null,{"$f":"SUBTOTAL(109,Udgifter[Total])","v":{"v":11079.235254237288,"d":"kr. 11,079.24"}}]