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

{"sheet":"Presupuesto para gastos","index":0,"n_rows":47,"n_cols":7,"rows_kept":47,"merged":[[0,1,0,4],[0,5,0,6],[16,1,16,6],[47,1,47,6]]}
[null,"Presupuesto para gastos",{"$nulls":3},"CONTOSO, 2013"]
[]
[]
[null," PRESUPUESTO PERSONAL"]
{"$rows_empty":7}
[null,"ESTADO","PERSONAL","PRESUPUESTO","REAL","DIFERENCIA (EUR)","DIFERENCIA (%)"]
[null,{"$f":"IFERROR(tblGastosPersonal[[#This Row],[REAL]]/tblGastosPersonal[[#This Row],[PRESUPUESTO]],\"\")","v":{"v":1.13,"d":"$1.13"}},"Oficina",{"v":500,"d":"500.00 €"},{"v":565,"d":"565.00 €"},{"$f":"tblGastosPersonal[[#This Row],[PRESUPUESTO]]-tblGastosPersonal[[#This Row],[REAL]]","v":{"v":-65,"d":"-65.00 €"}},{"$f":"IFERROR(tblGastosPersonal[DIFERENCIA (EUR)]/tblGastosPersonal[PRESUPUESTO],\"\")","v":{"v":-0.13,"d":"-13%"}}]
[null,{"$f":"IFERROR(tblGastosPersonal[[#This Row],[REAL]]/tblGastosPersonal[[#This Row],[PRESUPUESTO]],\"\")","v":{"v":1.2,"d":"$1.20"}},"Almacén",{"v":125,"d":"125.00 €"},{"v":150,"d":"150.00 €"},{"$f":"tblGastosPersonal[[#This Row],[PRESUPUESTO]]-tblGastosPersonal[[#This Row],[REAL]]","v":{"v":-25,"d":"-25.00 €"}},{"$f":"IFERROR(tblGastosPersonal[DIFERENCIA (EUR)]/tblGastosPersonal[PRESUPUESTO],\"\")","v":{"v":-0.2,"d":"-20%"}}]
[null,{"$f":"IFERROR(tblGastosPersonal[[#This Row],[REAL]]/tblGastosPersonal[[#This Row],[PRESUPUESTO]],\"\")","v":{"v":1,"d":"$1.00"}},"Representantes de ventas",{"v":100,"d":"100.00 €"},{"v":100,"d":"100.00 €"},{"$f":"tblGastosPersonal[[#This Row],[PRESUPUESTO]]-tblGastosPersonal[[#This Row],[REAL]]","v":{"v":0,"d":"0.00 €"}},{"$f":"IFERROR(tblGastosPersonal[DIFERENCIA (EUR)]/tblGastosPersonal[PRESUPUESTO],\"\")","v":{"v":0,"d":"0%"}}]
[null,{"$f":"IFERROR(tblGastosPersonal[[#This Row],[REAL]]/tblGastosPersonal[[#This Row],[PRESUPUESTO]],\"\")","v":{"v":0.9,"d":"$0.90"}},"Otros",{"v":100,"d":"100.00 €"},{"v":90,"d":"90.00 €"},{"$f":"tblGastosPersonal[[#This Row],[PRESUPUESTO]]-tblGastosPersonal[[#This Row],[REAL]]","v":{"v":10,"d":"10.00 €"}},{"$f":"IFERROR(tblGastosPersonal[DIFERENCIA (EUR)]/tblGastosPersonal[PRESUPUESTO],\"\")","v":{"v":0.1,"d":"10%"}}]
[]
[]
[null," PRESUPUESTO PERSONAL"]
{"$rows_empty":7}
[null,"ESTADO","OPERACIÓN","PRESUPUESTO","REAL","DIFERENCIA (EUR)","DIFERENCIA (%)"]
[null,{"$f":"IFERROR(tblGastosOperativos[[#This Row],[REAL]]/tblGastosOperativos[[#This Row],[PRESUPUESTO]],\"\")","v":{"v":0.98,"d":"$0.98"}},"Publicidad",{"v":250,"d":"250.00 €"},{"v":245,"d":"245.00 €"},{"$f":"tblGastosOperativos[[#This Row],[PRESUPUESTO]]-tblGastosOperativos[[#This Row],[REAL]]","v":{"v":5,"d":"5.00 €"}},{"$f":"IFERROR(tblGastosOperativos[[#This Row],[DIFERENCIA (EUR)]]/tblGastosOperativos[[#This Row],[PRESUPUESTO]],\"\")","v":{"v":0.02,"d":"2%"}}]
[null,{"$f":"IFERROR(tblGastosOperativos[[#This Row],[REAL]]/tblGastosOperativos[[#This Row],[PRESUPUESTO]],\"\")","v":{"v":1.2,"d":"$1.20"}},"Deudas",{"v":125,"d":"125.00 €"},{"v":150,"d":"150.00 €"},{"$f":"tblGastosOperativos[[#This Row],[PRESUPUESTO]]-tblGastosOperativos[[#This Row],[REAL]]","v":{"v":-25,"d":"-25.00 €"}},{"$f":"IFERROR(tblGastosOperativos[[#This Row],[DIFERENCIA (EUR)]]/tblGastosOperativos[[#This Row],[PRESUPUESTO]],\"\")","v":{"v":-0.2,"d":"-20%"}}]
[null,{"$f":"IFERROR(tblGastosOperativos[[#This Row],[REAL]]/tblGastosOperativos[[#This Row],[PRESUPUESTO]],\"\")","v":{"v":1,"d":"$1.00"}},"Beneficios",{"v":100,"d":"100.00 €"},{"v":100,"d":"100.00 €"},{"$f":"tblGastosOperativos[[#This Row],[PRESUPUESTO]]-tblGastosOperativos[[#This Row],[REAL]]","v":{"v":0,"d":"0.00 €"}},{"$f":"IFERROR(tblGastosOperativos[[#This Row],[DIFERENCIA (EUR)]]/tblGastosOperativos[[#This Row],[PRESUPUESTO]],\"\")","v":{"v":0,"d":"0%"}}]
[null,{"$f":"IFERROR(tblGastosOperativos[[#This Row],[REAL]]/tblGastosOperativos[[#This Row],[PRESUPUESTO]],\"\")","v":{"v":0.9,"d":"$0.90"}},"Suministros",{"v":100,"d":"100.00 €"},{"v":90,"d":"90.00 €"},{"$f":"tblGastosOperativos[[#This Row],[PRESUPUESTO]]-tblGastosOperativos[[#This Row],[REAL]]","v":{"v":10,"d":"10.00 €"}},{"$f":"IFERROR(tblGastosOperativos[[#This Row],[DIFERENCIA (EUR)]]/tblGastosOperativos[[#This Row],[PRESUPUESTO]],\"\")","v":{"v":0.1,"d":"10%"}}]
[null,{"$f":"IFERROR(tblGastosOperativos[[#This Row],[REAL]]/tblGastosOperativos[[#This Row],[PRESUPUESTO]],\"\")","v":""},"Franqueo",null,null,{"$f":"tblGastosOperativos[[#This Row],[PRESUPUESTO]]-tblGastosOperativos[[#This Row],[REAL]]","v":{"v":0,"d":"0.00 €"}},{"$f":"IFERROR(tblGastosOperativos[[#This Row],[DIFERENCIA (EUR)]]/tblGastosOperativos[[#This Row],[PRESUPUESTO]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblGastosOperativos[[#This Row],[REAL]]/tblGastosOperativos[[#This Row],[PRESUPUESTO]],\"\")","v":""},"Alquiler o hipoteca",null,null,{"$f":"tblGastosOperativos[[#This Row],[PRESUPUESTO]]-tblGastosOperativos[[#This Row],[REAL]]","v":{"v":0,"d":"0.00 €"}},{"$f":"IFERROR(tblGastosOperativos[[#This Row],[DIFERENCIA (EUR)]]/tblGastosOperativos[[#This Row],[PRESUPUESTO]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblGastosOperativos[[#This Row],[REAL]]/tblGastosOperativos[[#This Row],[PRESUPUESTO]],\"\")","v":""},"Gastos de ventas",null,null,{"$f":"tblGastosOperativos[[#This Row],[PRESUPUESTO]]-tblGastosOperativos[[#This Row],[REAL]]","v":{"v":0,"d":"0.00 €"}},{"$f":"IFERROR(tblGastosOperativos[[#This Row],[DIFERENCIA (EUR)]]/tblGastosOperativos[[#This Row],[PRESUPUESTO]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblGastosOperativos[[#This Row],[REAL]]/tblGastosOperativos[[#This Row],[PRESUPUESTO]],\"\")","v":""},"Impuestos",null,null,{"$f":"tblGastosOperativos[[#This Row],[PRESUPUESTO]]-tblGastosOperativos[[#This Row],[REAL]]","v":{"v":0,"d":"0.00 €"}},{"$f":"IFERROR(tblGastosOperativos[[#This Row],[DIFERENCIA (EUR)]]/tblGastosOperativos[[#This Row],[PRESUPUESTO]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblGastosOperativos[[#This Row],[REAL]]/tblGastosOperativos[[#This Row],[PRESUPUESTO]],\"\")","v":""},"Servicios públicos",null,null,{"$f":"tblGastosOperativos[[#This Row],[PRESUPUESTO]]-tblGastosOperativos[[#This Row],[REAL]]","v":{"v":0,"d":"0.00 €"}},{"$f":"IFERROR(tblGastosOperativos[[#This Row],[DIFERENCIA (EUR)]]/tblGastosOperativos[[#This Row],[PRESUPUESTO]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblGastosOperativos[[#This Row],[REAL]]/tblGastosOperativos[[#This Row],[PRESUPUESTO]],\"\")","v":""},"Otros",null,null,{"$f":"tblGastosOperativos[[#This Row],[PRESUPUESTO]]-tblGastosOperativos[[#This Row],[REAL]]","v":{"v":0,"d":"0.00 €"}},{"$f":"IFERROR(tblGastosOperativos[[#This Row],[DIFERENCIA (EUR)]]/tblGastosOperativos[[#This Row],[PRESUPUESTO]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblGastosOperativos[[#This Row],[REAL]]/tblGastosOperativos[[#This Row],[PRESUPUESTO]],\"\")","v":""},"Seguro",null,null,{"$f":"tblGastosOperativos[[#This Row],[PRESUPUESTO]]-tblGastosOperativos[[#This Row],[REAL]]","v":{"v":0,"d":"0.00 €"}},{"$f":"IFERROR(tblGastosOperativos[[#This Row],[DIFERENCIA (EUR)]]/tblGastosOperativos[[#This Row],[PRESUPUESTO]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblGastosOperativos[[#This Row],[REAL]]/tblGastosOperativos[[#This Row],[PRESUPUESTO]],\"\")","v":""},"Interés",null,null,{"$f":"tblGastosOperativos[[#This Row],[PRESUPUESTO]]-tblGastosOperativos[[#This Row],[REAL]]","v":{"v":0,"d":"0.00 €"}},{"$f":"IFERROR(tblGastosOperativos[[#This Row],[DIFERENCIA (EUR)]]/tblGastosOperativos[[#This Row],[PRESUPUESTO]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblGastosOperativos[[#This Row],[REAL]]/tblGastosOperativos[[#This Row],[PRESUPUESTO]],\"\")","v":""},"Teléfono",null,null,{"$f":"tblGastosOperativos[[#This Row],[PRESUPUESTO]]-tblGastosOperativos[[#This Row],[REAL]]","v":{"v":0,"d":"0.00 €"}},{"$f":"IFERROR(tblGastosOperativos[[#This Row],[DIFERENCIA (EUR)]]/tblGastosOperativos[[#This Row],[PRESUPUESTO]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblGastosOperativos[[#This Row],[REAL]]/tblGastosOperativos[[#This Row],[PRESUPUESTO]],\"\")","v":""},"Mantenimiento y reparaciones",null,null,{"$f":"tblGastosOperativos[[#This Row],[PRESUPUESTO]]-tblGastosOperativos[[#This Row],[REAL]]","v":{"v":0,"d":"0.00 €"}},{"$f":"IFERROR(tblGastosOperativos[[#This Row],[DIFERENCIA (EUR)]]/tblGastosOperativos[[#This Row],[PRESUPUESTO]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblGastosOperativos[[#This Row],[REAL]]/tblGastosOperativos[[#This Row],[PRESUPUESTO]],\"\")","v":""},"Gastos jurídicos",null,null,{"$f":"tblGastosOperativos[[#This Row],[PRESUPUESTO]]-tblGastosOperativos[[#This Row],[REAL]]","v":{"v":0,"d":"0.00 €"}},{"$f":"IFERROR(tblGastosOperativos[[#This Row],[DIFERENCIA (EUR)]]/tblGastosOperativos[[#This Row],[PRESUPUESTO]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblGastosOperativos[[#This Row],[REAL]]/tblGastosOperativos[[#This Row],[PRESUPUESTO]],\"\")","v":""},"Depreciación",null,null,{"$f":"tblGastosOperativos[[#This Row],[PRESUPUESTO]]-tblGastosOperativos[[#This Row],[REAL]]","v":{"v":0,"d":"0.00 €"}},{"$f":"IFERROR(tblGastosOperativos[[#This Row],[DIFERENCIA (EUR)]]/tblGastosOperativos[[#This Row],[PRESUPUESTO]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblGastosOperativos[[#This Row],[REAL]]/tblGastosOperativos[[#This Row],[PRESUPUESTO]],\"\")","v":""},"Envío",null,null,{"$f":"tblGastosOperativos[[#This Row],[PRESUPUESTO]]-tblGastosOperativos[[#This Row],[REAL]]","v":{"v":0,"d":"0.00 €"}},{"$f":"IFERROR(tblGastosOperativos[[#This Row],[DIFERENCIA (EUR)]]/tblGastosOperativos[[#This Row],[PRESUPUESTO]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblGastosOperativos[[#This Row],[REAL]]/tblGastosOperativos[[#This Row],[PRESUPUESTO]],\"\")","v":""},"Almacenamiento",null,null,{"$f":"tblGastosOperativos[[#This Row],[PRESUPUESTO]]-tblGastosOperativos[[#This Row],[REAL]]","v":{"v":0,"d":"0.00 €"}},{"$f":"IFERROR(tblGastosOperativos[[#This Row],[DIFERENCIA (EUR)]]/tblGastosOperativos[[#This Row],[PRESUPUESTO]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblGastosOperativos[[#This Row],[REAL]]/tblGastosOperativos[[#This Row],[PRESUPUESTO]],\"\")","v":""},"Otros",null,null,{"$f":"tblGastosOperativos[[#This Row],[PRESUPUESTO]]-tblGastosOperativos[[#This Row],[REAL]]","v":{"v":0,"d":"0.00 €"}},{"$f":"IFERROR(tblGastosOperativos[[#This Row],[DIFERENCIA (EUR)]]/tblGastosOperativos[[#This Row],[PRESUPUESTO]],\"\")","v":""}]
[null,null,"Gastos totales",{"$f":"SUBTOTAL(109,tblGastosOperativos[PRESUPUESTO],tblGastosPersonal[PRESUPUESTO])","v":{"v":1400,"d":"1,400.00 €"}},{"$f":"SUBTOTAL(109,tblGastosOperativos[REAL],tblGastosPersonal[REAL])","v":{"v":1490,"d":"1,490.00 €"}},{"$f":"SUBTOTAL(109,tblGastosOperativos[DIFERENCIA (EUR)],tblGastosPersonal[DIFERENCIA (EUR)])","v":{"v":-90,"d":"-90.00 €"}},{"$f":"IFERROR(SUM(tblGastosOperativos[[#Totals],[DIFERENCIA (EUR)]]/tblGastosOperativos[[#Totals],[PRESUPUESTO]]),\"\")","v":{"v":-0.06428571428571428,"d":"-6%"}}]