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

{"sheet":"Utgiftsrapport","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,"Rapport över resekostnader"]
[]
[null,"Namn","Mikaela Jakobsson","Godkänt av",null,null,"Erna Nilsson",null,"Milersättning per km",null,null,{"v":0.32,"d":"0.32 kr"}]
[]
[null,"Avdelning","Försäljning","Skickat datum",null,null,{"$f":"TODAY()","v":"2018-05-15"},null,"Summa ersättning",null,null,{"$f":"TotalSummaUtläggAttÅterbetala","v":{"v":7756.27744680851,"d":"7,756.28 kr"}}]
[]
[null,"Period",{"$f":"IF(MIN(B10:B13)=MAX(B10:B13),TEXT(MIN(B10:B13),\"ÅÅ-M-D\"),\"Från \"&TEXT(MIN(B10:B13),\"ÅÅ-M-D\")&\" till \"&TEXT(MAX(B10:B13),\"ÅÅ-M-D\"))","v":"Från 18-4-15 till 18-4-20"}]
[]
[null,"Datum","Beskrivning av utgifter","Flygbiljetter","Boende","Marktransport \n(bränsle, hyrbil, taxi)","Måltider och dricks","Konferenser och seminarier","Km","Milersättning","Diverse","Valutaväxlingskurs","Utgiftsvaluta","Summa"]
[null,{"$f":"TODAY()-30","v":"2018-04-15"},"Kundbesök",{"v":3500,"d":"3,500.00"},{"v":1500,"d":"1,500.00"},{"v":450,"d":"450.00"},{"v":120,"d":"120.00"},{"v":500,"d":"500.00"},{"v":35,"d":"35.00"},{"$f":"IF(Utgiftsrapport!I10<>\"\",Utgiftsrapport!I10*KörsträckaVärde,\"\")","v":{"v":11.200000000000001,"d":"11.20"}},null,0.94,"NOK",{"$f":"IFERROR(IF(OR(Utgiftsrapport!$L10=\"\",Utgiftsrapport!$L10=1),SUM(Utgiftsrapport!$J10:$K10,Utgiftsrapport!$D10:$H10)*1,SUM(Utgiftsrapport!$J10:$K10,Utgiftsrapport!$D10:$H10)/Utgiftsrapport!$L10),\"\")","v":{"v":6469.36170212766,"d":"6,469.36 kr"}}]
[null,{"$f":"TODAY()-30","v":"2018-04-15"},"Lunch med kund",{"$nulls":3},{"v":243,"d":"243.00"},null,{"v":12,"d":"12.00"},{"$f":"IF(Utgiftsrapport!I11<>\"\",Utgiftsrapport!I11*KörsträckaVärde,\"\")","v":3.84},null,0.94,"NOK",{"$f":"IFERROR(IF(OR(Utgiftsrapport!$L11=\"\",Utgiftsrapport!$L11=1),SUM(Utgiftsrapport!$J11:$K11,Utgiftsrapport!$D11:$H11)*1,SUM(Utgiftsrapport!$J11:$K11,Utgiftsrapport!$D11:$H11)/Utgiftsrapport!$L11),\"\")","v":{"v":262.59574468085106,"d":"262.60 kr"}}]
[null,"2018-04-15","Eftermiddagsseminarium",{"$nulls":4},{"v":1000,"d":"1,000.00"},{"v":6,"d":"6.00"},{"$f":"IF(Utgiftsrapport!I12<>\"\",Utgiftsrapport!I12*KörsträckaVärde,\"\")","v":1.92},null,{"v":1,"d":"1.00"},"SEK",{"$f":"IFERROR(IF(OR(Utgiftsrapport!$L12=\"\",Utgiftsrapport!$L12=1),SUM(Utgiftsrapport!$J12:$K12,Utgiftsrapport!$D12:$H12)*1,SUM(Utgiftsrapport!$J12:$K12,Utgiftsrapport!$D12:$H12)/Utgiftsrapport!$L12),\"\")","v":{"v":1001.92,"d":"1,001.92 kr"}}]
[null,{"$f":"TODAY()-25","v":"2018-04-20"},"Resa till flygplats",{"$nulls":5},{"v":70,"d":"70.00"},{"$f":"IF(Utgiftsrapport!I13<>\"\",Utgiftsrapport!I13*KörsträckaVärde,\"\")","v":{"v":22.400000000000002,"d":"22.40"}},null,{"v":1,"d":"1.00"},"SEK",{"$f":"IFERROR(IF(OR(Utgiftsrapport!$L13=\"\",Utgiftsrapport!$L13=1),SUM(Utgiftsrapport!$J13:$K13,Utgiftsrapport!$D13:$H13)*1,SUM(Utgiftsrapport!$J13:$K13,Utgiftsrapport!$D13:$H13)/Utgiftsrapport!$L13),\"\")","v":{"v":22.400000000000002,"d":"22.40 kr"}}]
[null,"Summa",null,{"$f":"SUBTOTAL(109,Utgifter[Flygbiljetter])","v":{"v":3500,"d":"3,500.00"}},{"$f":"SUBTOTAL(109,Utgifter[Boende])","v":{"v":1500,"d":"1,500.00"}},{"$f":"SUBTOTAL(109,Utgifter[Marktransport \n(bränsle, hyrbil, taxi)])","v":{"v":450,"d":"450.00"}},{"$f":"SUBTOTAL(109,Utgifter[Måltider och dricks])","v":{"v":363,"d":"363.00"}},{"$f":"SUBTOTAL(109,Utgifter[Konferenser och seminarier])","v":{"v":1500,"d":"1,500.00"}},{"$f":"SUBTOTAL(109,Utgifter[Km])","v":{"v":123,"d":"123.00"}},{"$f":"SUBTOTAL(109,Utgifter[Milersättning])","v":39.36},{"$f":"SUBTOTAL(109,Utgifter[Diverse])","v":{"v":0,"d":"0.00"}},null,null,{"$f":"SUBTOTAL(109,Utgifter[Summa])","v":{"v":7756.27744680851,"d":"7,756.28 kr"}}]