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

{"sheet":"Informe de gastos","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]]}
[" ","Informe de gastos de viaje"]
[]
[null,"Nombre","Elvira Cano","Autorizado por",null,null,"Íker Arteaga",null,"Reembolso por kilómetro",null,null,{"v":0.32,"d":"0.32 €"}]
[]
[null,"Departamento","Ventas","Fecha de envío",null,null,{"$f":"TODAY()","v":"2018-01-19"},null,"Reembolso total debido",null,null,{"$f":"TotalReembolsoDebido","v":{"v":9917.350303030302,"d":"9,917.35 €"}}]
[]
[null,"Período",{"$f":"IF(MIN(B10:B13)=MAX(B10:B13),TEXT(MIN(B10:B13),\"d/m/aa\"),\"Del \"&TEXT(MIN(B10:B13),\"d/m/aa\")&\" al \"&TEXT(MAX(B10:B13),\"d/m/aa\"))","v":"Del 20/12/17 al 25/12/17"}]
[]
[null,"Fecha","Descripción del gasto","Tarifa aérea","Alojamiento","Transporte \nterrestre \n(gasolina, coche de alquiler o taxi)","Comidas y propinas","Conferencias y seminarios","Kilometraje","Reembolso kilometraje","Varios","Tipo de cambio de moneda","Moneda de los gastos","Total"]
[null,{"$f":"TODAY()-30","v":"2017-12-20"},"Desplazamiento a la oficina del cliente",{"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('Informe de gastos'!I10<>\"\",'Informe de gastos'!I10*TarifaKilometraje,\"\")","v":{"v":11.200000000000001,"d":"11.20"}},null,{"v":0.066,"d":"0.07"},"CAD",{"$f":"IFERROR(IF(OR('Informe de gastos'!$L10=\"\",'Informe de gastos'!$L10=1),SUM('Informe de gastos'!$J10:$K10,'Informe de gastos'!$D10:$H10)*1,SUM('Informe de gastos'!$J10:$K10,'Informe de gastos'!$D10:$H10)/'Informe de gastos'!$L10),\"\")","v":{"v":9366.666666666666,"d":"9,366.67 €"}}]
[null,{"$f":"TODAY()-30","v":"2017-12-20"},"Almuerzo con el cliente",{"$nulls":3},{"v":24.3,"d":"24.30"},null,{"v":12,"d":"12.00"},{"$f":"IF('Informe de gastos'!I11<>\"\",'Informe de gastos'!I11*TarifaKilometraje,\"\")","v":3.84},null,{"v":0.066,"d":"0.07"},"CAD",{"$f":"IFERROR(IF(OR('Informe de gastos'!$L11=\"\",'Informe de gastos'!$L11=1),SUM('Informe de gastos'!$J11:$K11,'Informe de gastos'!$D11:$H11)*1,SUM('Informe de gastos'!$J11:$K11,'Informe de gastos'!$D11:$H11)/'Informe de gastos'!$L11),\"\")","v":{"v":426.3636363636364,"d":"426.36 €"}}]
[null,"2017-12-20","Seminario por la tarde",{"$nulls":4},{"v":100,"d":"100.00"},{"v":6,"d":"6.00"},{"$f":"IF('Informe de gastos'!I12<>\"\",'Informe de gastos'!I12*TarifaKilometraje,\"\")","v":1.92},null,{"v":1,"d":"1.00"},"MXN",{"$f":"IFERROR(IF(OR('Informe de gastos'!$L12=\"\",'Informe de gastos'!$L12=1),SUM('Informe de gastos'!$J12:$K12,'Informe de gastos'!$D12:$H12)*1,SUM('Informe de gastos'!$J12:$K12,'Informe de gastos'!$D12:$H12)/'Informe de gastos'!$L12),\"\")","v":{"v":101.92,"d":"101.92 €"}}]
[null,{"$f":"TODAY()-25","v":"2017-12-25"},"Desplazamiento al aeropuerto",{"$nulls":5},{"v":70,"d":"70.00"},{"$f":"IF('Informe de gastos'!I13<>\"\",'Informe de gastos'!I13*TarifaKilometraje,\"\")","v":{"v":22.400000000000002,"d":"22.40"}},null,{"v":1,"d":"1.00"},"MXN",{"$f":"IFERROR(IF(OR('Informe de gastos'!$L13=\"\",'Informe de gastos'!$L13=1),SUM('Informe de gastos'!$J13:$K13,'Informe de gastos'!$D13:$H13)*1,SUM('Informe de gastos'!$J13:$K13,'Informe de gastos'!$D13:$H13)/'Informe de gastos'!$L13),\"\")","v":{"v":22.400000000000002,"d":"22.40 €"}}]
[null,"Total",null,{"$f":"SUBTOTAL(109,Gastos[Tarifa aérea])","v":{"v":350,"d":"350.00"}},{"$f":"SUBTOTAL(109,Gastos[Alojamiento])","v":{"v":150,"d":"150.00"}},{"$f":"SUBTOTAL(109,Gastos[Transporte \nterrestre \n(gasolina, coche de alquiler o taxi)])","v":{"v":45,"d":"45.00"}},{"$f":"SUBTOTAL(109,Gastos[Comidas y propinas])","v":{"v":36.3,"d":"36.30"}},{"$f":"SUBTOTAL(109,Gastos[Conferencias y seminarios])","v":{"v":150,"d":"150.00"}},{"$f":"SUBTOTAL(109,Gastos[Kilometraje])","v":{"v":123,"d":"123.00"}},{"$f":"SUBTOTAL(109,Gastos[Reembolso kilometraje])","v":39.36},{"$f":"SUBTOTAL(109,Gastos[Varios])","v":{"v":0,"d":"0.00"}},null,null,{"$f":"SUBTOTAL(109,Gastos[Total])","v":{"v":9917.350303030302,"d":"9,917.35 €"}}]