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

{"sheet":"informe de gastos","index":0,"n_rows":45,"n_cols":10,"rows_kept":45,"merged":[[18,1,18,9],[27,1,27,9],[35,1,35,9],[40,1,43,4]]}
["NOMBRE DE LA COMPAÑÍA"]
["INFORME DE GASTOS"]
[]
[null,"EMPLEADO:","Cecilia Cornejo",{"$nulls":3},"AUTORIZADO POR:"]
[null,"DEPARTAMENTO:","Ventas"]
[null,"LA SEMANA FINALIZA EL:","2013-03-07",{"$nulls":3},"FECHA:"]
[null,"TASA DE KILOMETRAJE:",{"v":0.67,"d":"0.67 €"}]
[]
[null,null,{"$f":"UPPER(TEXT(C10,\"dddd\"))","v":"VIERNES"},{"$f":"UPPER(TEXT(D10,\"dddd\"))","v":"SÁBADO"},{"$f":"UPPER(TEXT(E10,\"dddd\"))","v":"DOMINGO"},{"$f":"UPPER(TEXT(F10,\"dddd\"))","v":"LUNES"},{"$f":"UPPER(TEXT(G10,\"dddd\"))","v":"MARTES"},{"$f":"UPPER(TEXT(H10,\"dddd\"))","v":"MIÉRCOLES"},{"$f":"UPPER(TEXT(I10,\"dddd\"))","v":"JUEVES"}]
[null,"TRANSPORTE",{"$f":"FinalSemana-6","v":"2013-03-01"},{"$f":"FinalSemana-5","v":"2013-03-02"},{"$f":"FinalSemana-4","v":"2013-03-03"},{"$f":"FinalSemana-3","v":"2013-03-04"},{"$f":"FinalSemana-2","v":"2013-03-05"},{"$f":"FinalSemana-1","v":"2013-03-06"},{"$f":"FinalSemana","v":"2013-03-07"},"TOTAL"]
[null,"Kilómetros recorridos",{"v":145,"d":"145.00 €"},{"$nulls":6},{"$f":"SUM(Transporte[[#This Row],[Día 1]:[Día 7]])","v":{"v":145,"d":"145.00 €"}}]
[null,"Reembolso por kilometraje",{"$f":"C11*TasaKilometraje","v":{"v":97.15,"d":"97.15 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"SUM(Transporte[[#This Row],[Día 1]:[Día 7]])","v":{"v":97.15,"d":"97.15 €"}}]
[null,"Peajes y aparcamiento",{"$nulls":3},{"v":17,"d":"17.00 €"},{"$nulls":3},{"$f":"SUM(Transporte[[#This Row],[Día 1]:[Día 7]])","v":{"v":17,"d":"17.00 €"}}]
[null,"Alquiler de vehículos",{"v":79,"d":"79.00 €"},null,null,{"v":79,"d":"79.00 €"},{"$nulls":3},{"$f":"SUM(Transporte[[#This Row],[Día 1]:[Día 7]])","v":{"v":158,"d":"158.00 €"}}]
[null,"Taxi / limusina",{"$nulls":7},{"$f":"SUM(Transporte[[#This Row],[Día 1]:[Día 7]])","v":{"v":0,"d":"0.00 €"}}]
[null,"Otro (tranvía o autobús)",{"$nulls":7},{"$f":"SUM(Transporte[[#This Row],[Día 1]:[Día 7]])","v":{"v":0,"d":"0.00 €"}}]
[null,"Tarifa aérea",{"$nulls":3},{"v":235,"d":"235.00 €"},{"$nulls":3},{"$f":"SUM(Transporte[[#This Row],[Día 1]:[Día 7]])","v":{"v":235,"d":"235.00 €"}}]
[null,"TOTAL",{"$f":"SUBTOTAL(109,C12:C17)","v":{"v":176.15,"d":"176.15 €"}},{"$f":"SUBTOTAL(109,D12:D17)","v":{"v":0,"d":"0.00 €"}},null,{"$f":"SUBTOTAL(109,F12:F17)","v":{"v":331,"d":"331.00 €"}},{"$f":"SUBTOTAL(109,G12:G17)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,H12:H17)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,I12:I17)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(J12:J17)","v":{"v":507.15,"d":"507.15 €"}}]
[]
[null,"DIETAS Y ALOJAMIENTO"]
[null,"Alojamiento",{"v":145,"d":"145.00 €"},{"$nulls":6},{"$f":"SUM(DietasAlojamiento[[#This Row],[Día 1]:[Día 7]])","v":{"v":145,"d":"145.00 €"}}]
[null,"Desayunos",{"v":11.49,"d":"11.49 €"},{"$nulls":6},{"$f":"SUM(DietasAlojamiento[[#This Row],[Día 1]:[Día 7]])","v":{"v":11.49,"d":"11.49 €"}}]
[null,"Almuerzos",{"v":12,"d":"12.00 €"},{"$nulls":6},{"$f":"SUM(DietasAlojamiento[[#This Row],[Día 1]:[Día 7]])","v":{"v":12,"d":"12.00 €"}}]
[null,"Cenas",{"v":17,"d":"17.00 €"},{"$nulls":6},{"$f":"SUM(DietasAlojamiento[[#This Row],[Día 1]:[Día 7]])","v":{"v":17,"d":"17.00 €"}}]
[null,"Tentempiés",{"$f":"C24*TasaKilometraje","v":{"v":11.39,"d":"11.39 €"}},{"$nulls":6},{"$f":"SUM(DietasAlojamiento[[#This Row],[Día 1]:[Día 7]])","v":{"v":11.39,"d":"11.39 €"}}]
[null,"Subtotal de dietas",{"$f":"SUM(C22:C24)","v":{"v":40.49,"d":"40.49 €"}},{"$f":"SUM(D22:D24)","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"SUM(DietasAlojamiento[[#This Row],[Día 1]:[Día 7]])","v":{"v":40.49,"d":"40.49 €"}}]
[null,"TOTAL",{"$f":"SUBTOTAL(109,C21,C26)","v":{"v":185.49,"d":"185.49 €"}},{"$f":"SUBTOTAL(109,D21,D26)","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"SUBTOTAL(109,J21,J26)","v":{"v":185.49,"d":"185.49 €"}}]
[]
[null,"VARIOS"]
[null,"Suministros",{"$nulls":7},{"$f":"SUM(Otros[[#This Row],[Día 1]:[Día 7]])","v":{"v":0,"d":"0.00 €"}}]
[null,"Material",{"$nulls":7},{"$f":"SUM(Otros[[#This Row],[Día 1]:[Día 7]])","v":{"v":0,"d":"0.00 €"}}]
[null,"Teléfono, fax, Internet",{"$nulls":7},{"$f":"SUM(Otros[[#This Row],[Día 1]:[Día 7]])","v":{"v":0,"d":"0.00 €"}}]
[null,"Otros*",{"$nulls":7},{"$f":"SUM(Otros[[#This Row],[Día 1]:[Día 7]])","v":{"v":0,"d":"0.00 €"}}]
[null,"Personal*",{"$nulls":3},{"v":199,"d":"199.00 €"},{"$nulls":3},{"$f":"SUM(Otros[[#This Row],[Día 1]:[Día 7]])","v":{"v":199,"d":"199.00 €"}}]
[null,"TOTAL",{"$f":"SUBTOTAL(109,Otros[Día 1])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Otros[Día 2])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Otros[Día 3])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Otros[Día 4])","v":{"v":199,"d":"199.00 €"}},{"$f":"SUBTOTAL(109,Otros[Día 5])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Otros[Día 6])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Otros[Día 7])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Otros[Total])","v":{"v":199,"d":"199.00 €"}}]
[]
[null,"TOTALES GENERALES",{"$f":"SUM(Otros[[#Totals],[Día 1]],DietasAlojamiento[[#Totals],[Día 1]],Transporte[[#Totals],[Día 1]])","v":{"v":361.64,"d":"361.64 €"}},{"$f":"SUM(Otros[[#Totals],[Día 2]],DietasAlojamiento[[#Totals],[Día 2]],Transporte[[#Totals],[Día 2]])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(Otros[[#Totals],[Día 3]],DietasAlojamiento[[#Totals],[Día 3]],Transporte[[#Totals],[Día 3]])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(Otros[[#Totals],[Día 4]],DietasAlojamiento[[#Totals],[Día 4]],Transporte[[#Totals],[Día 4]])","v":{"v":530,"d":"530.00 €"}},{"$f":"SUM(Otros[[#Totals],[Día 5]],DietasAlojamiento[[#Totals],[Día 5]],Transporte[[#Totals],[Día 5]])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(Otros[[#Totals],[Día 6]],DietasAlojamiento[[#Totals],[Día 6]],Transporte[[#Totals],[Día 6]])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(Otros[[#Totals],[Día 7]],DietasAlojamiento[[#Totals],[Día 7]],Transporte[[#Totals],[Día 7]])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(Otros[[#Totals],[Total]],DietasAlojamiento[[#Totals],[Total]],Transporte[[#Totals],[Total]])","v":{"v":891.64,"d":"891.64 €"}}]
[]
[{"$nulls":9},"GASTOS TOTALES"]
[null,"*Reservado para la empresa para los elementos \"Personal\" y \"Otros\":",{"$nulls":7},{"$f":"SUM(J18,J27,J35)","v":{"v":891.64,"d":"891.64 €"}}]
[{"$nulls":9},"ANTICIPOS"]
[]
[{"$nulls":9},"REEMBOLSO TOTAL"]
[{"$nulls":9},{"$f":"J40-J42","v":{"v":891.64,"d":"891.64 €"}}]
[{"$nulls":9},"Adjunte todos los recibos."]