{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Resumen del presupuesto mensual","Ingresos","Gastos de personal","Gastos operativos"],"not_rendered":{"charts":1,"images":1,"defined_names":14},"read":"whole","date_system":"1900"}

{"sheet":"Resumen del presupuesto mensual","index":0,"n_rows":17,"n_cols":5,"rows_kept":17,"merged":[[0,1,0,3],[0,6,1,18],[1,1,1,3],[9,1,9,4]]}
[null,"     NOMBRE DE LA COMPAÑÍA",null,null,"FECHA"]
[null,"  PRESUPUESTO MENSUAL"]
[]
[null,"TOTALES DEL PRESUPUESTO","ESTIMADO","REAL","DIFERENCIA"]
[null,"Ingresos",{"$f":"Ingresos[[#Totals],[ESTIMADO]]","v":{"v":63300,"d":"63,300.00"}},{"$f":"Ingresos[[#Totals],[REAL]]","v":{"v":57450,"d":"57,450.00"}},{"$f":"IF('Resumen del presupuesto mensual'!$B5=\"Ingresos\",'Resumen del presupuesto mensual'!$D5-'Resumen del presupuesto mensual'!$C5,'Resumen del presupuesto mensual'!$C5-'Resumen del presupuesto mensual'!$D5)","v":{"v":-5850,"d":"-5,850.00 "}}]
[null,"Gastos de personal",{"$f":"GastosDePersonal[[#Totals],[ESTIMADO]]","v":{"v":18500,"d":"18,500.00"}},{"$f":"GastosDePersonal[[#Totals],[REAL]]","v":{"v":14100,"d":"14,100.00"}},{"$f":"IF('Resumen del presupuesto mensual'!$B6=\"Ingresos\",'Resumen del presupuesto mensual'!$D6-'Resumen del presupuesto mensual'!$C6,'Resumen del presupuesto mensual'!$C6-'Resumen del presupuesto mensual'!$D6)","v":{"v":4400,"d":"4,400.00"}}]
[null,"Gastos operativos",{"$f":"GastosOperativos[[#Totals],[ESTIMADO]]","v":{"v":36000,"d":"36,000.00"}},{"$f":"GastosOperativos[[#Totals],[REAL]]","v":{"v":35530,"d":"35,530.00"}},{"$f":"IF('Resumen del presupuesto mensual'!$B7=\"Ingresos\",'Resumen del presupuesto mensual'!$D7-'Resumen del presupuesto mensual'!$C7,'Resumen del presupuesto mensual'!$C7-'Resumen del presupuesto mensual'!$D7)","v":{"v":470,"d":"470.00"}}]
[null,"Saldo (ingresos menos gastos)",{"$f":"C5-C6-C7","v":{"v":8800,"d":"8,800.00"}},{"$f":"D5-D6-D7","v":{"v":7820,"d":"7,820.00"}},{"$f":"SUBTOTAL(109,Tabla2[DIFERENCIA])","v":{"v":-980,"d":"-980.00 "}}]
[]
[null,"¿CUÁLES SON MIS CINCO MAYORES GASTOS OPERATIVOS?"]
[null,"GASTOS REALES","IMPORTE","% DE LOS GASTOS","15 % DE REDUCCIÓN"]
[null,{"$f":"INDEX(GastosOperativos[],MATCH(CincoGastosPrincipales[[#This Row],[IMPORTE]],GastosOperativos[CINCO IMPORTES PRINCIPALES],0),1)","v":"Mantenimiento y reparaciones"},{"$f":"LARGE(GastosOperativos[CINCO IMPORTES PRINCIPALES],1)","v":4600.000014},{"$f":"CincoGastosPrincipales[[#This Row],[IMPORTE]]/$D$7","v":{"v":0.12946805555868282,"d":"12.9%"}},{"$f":"CincoGastosPrincipales[[#This Row],[IMPORTE]]*0.15","v":690.0000021}]
[null,{"$f":"INDEX(GastosOperativos[],MATCH(CincoGastosPrincipales[[#This Row],[IMPORTE]],GastosOperativos[CINCO IMPORTES PRINCIPALES],0),1)","v":"Suministros"},{"$f":"LARGE(GastosOperativos[CINCO IMPORTES PRINCIPALES],2)","v":4500.00002},{"$f":"CincoGastosPrincipales[[#This Row],[IMPORTE]]/$D$7","v":{"v":0.12665353278919225,"d":"12.7%"}},{"$f":"CincoGastosPrincipales[[#This Row],[IMPORTE]]*0.15","v":675.000003}]
[null,{"$f":"INDEX(GastosOperativos[],MATCH(CincoGastosPrincipales[[#This Row],[IMPORTE]],GastosOperativos[CINCO IMPORTES PRINCIPALES],0),1)","v":"Alquiler o hipoteca"},{"$f":"LARGE(GastosOperativos[CINCO IMPORTES PRINCIPALES],3)","v":4500.000017},{"$f":"CincoGastosPrincipales[[#This Row],[IMPORTE]]/$D$7","v":{"v":0.12665353270475654,"d":"12.7%"}},{"$f":"CincoGastosPrincipales[[#This Row],[IMPORTE]]*0.15","v":675.00000255}]
[null,{"$f":"INDEX(GastosOperativos[],MATCH(CincoGastosPrincipales[[#This Row],[IMPORTE]],GastosOperativos[CINCO IMPORTES PRINCIPALES],0),1)","v":"Impuestos"},{"$f":"LARGE(GastosOperativos[CINCO IMPORTES PRINCIPALES],4)","v":3200.000021},{"$f":"CincoGastosPrincipales[[#This Row],[IMPORTE]]/$D$7","v":{"v":0.09006473461863214,"d":"9.0%"}},{"$f":"CincoGastosPrincipales[[#This Row],[IMPORTE]]*0.15","v":480.00000314999994}]
[null,{"$f":"INDEX(GastosOperativos[],MATCH(CincoGastosPrincipales[[#This Row],[IMPORTE]],GastosOperativos[CINCO IMPORTES PRINCIPALES],0),1)","v":"Publicidad"},{"$f":"LARGE(GastosOperativos[CINCO IMPORTES PRINCIPALES],5)","v":2500.000005},{"$f":"CincoGastosPrincipales[[#This Row],[IMPORTE]]/$D$7","v":{"v":0.07036307359977484,"d":"7.0%"}},{"$f":"CincoGastosPrincipales[[#This Row],[IMPORTE]]*0.15","v":375.00000074999997}]
[null,"Total",{"$f":"SUBTOTAL(109,CincoGastosPrincipales[IMPORTE])","v":{"v":19300.000077000004,"d":"19,300.00"}},{"$f":"SUBTOTAL(109,CincoGastosPrincipales[% DE LOS GASTOS])","v":{"v":0.5432029292710385,"d":"54.3%"}},{"$f":"SUBTOTAL(109,CincoGastosPrincipales[15 % DE REDUCCIÓN])","v":{"v":2895.0000115499997,"d":"2,895.00"}}]

{"sheet":"Ingresos","index":1,"n_rows":8,"n_cols":6,"rows_kept":8,"merged":[[0,1,0,3],[1,1,1,3]]}
[null,"     NOMBRE DE LA COMPAÑÍA",null,null,"FECHA","FECHA"]
[null,"  PRESUPUESTO MENSUAL"]
[]
[null,"INGRESOS","ESTIMADO","REAL","CINCO IMPORTES PRINCIPALES","DIFERENCIA"]
[null,"Ventas netas",60000,54000,{"$f":"Ingresos[[#This Row],[REAL]]+(10^-6)*ROW(Ingresos[[#This Row],[REAL]])","v":54000.000005},{"$f":"Ingresos[[#This Row],[REAL]]-Ingresos[[#This Row],[ESTIMADO]]","v":-6000}]
[null,"Ingresos de intereses",3000,3000,{"$f":"Ingresos[[#This Row],[REAL]]+(10^-6)*ROW(Ingresos[[#This Row],[REAL]])","v":3000.000006},{"$f":"Ingresos[[#This Row],[REAL]]-Ingresos[[#This Row],[ESTIMADO]]","v":0}]
[null,"Ventas de activos (pérdidas y ganancias)",300,450,{"$f":"Ingresos[[#This Row],[REAL]]+(10^-6)*ROW(Ingresos[[#This Row],[REAL]])","v":450.000007},{"$f":"Ingresos[[#This Row],[REAL]]-Ingresos[[#This Row],[ESTIMADO]]","v":150}]
[null,"Ingresos totales",{"$f":"SUBTOTAL(109,Ingresos[ESTIMADO])","v":63300},{"$f":"SUBTOTAL(109,Ingresos[REAL])","v":57450},null,{"$f":"SUBTOTAL(109,Ingresos[DIFERENCIA])","v":-5850}]

{"sheet":"Gastos de personal","index":2,"n_rows":19,"n_cols":6,"rows_kept":19,"merged":[[0,1,0,3],[1,1,1,3]]}
[null,"     NOMBRE DE LA COMPAÑÍA",null,null,"FECHA","FECHA"]
[null,"  PRESUPUESTO MENSUAL"]
[]
[null,"GASTOS DE PERSONAL","ESTIMADO","REAL","CINCO IMPORTES PRINCIPALES","DIFERENCIA"]
[null,"Salarios",9500,9600,{"$f":"GastosDePersonal[[#This Row],[REAL]]+(10^-6)*ROW(GastosDePersonal[[#This Row],[REAL]])","v":9600.000005},{"$f":"GastosDePersonal[[#This Row],[ESTIMADO]]-GastosDePersonal[[#This Row],[REAL]]","v":-100}]
[null,"Prestaciones para empleados",4000,0,{"$f":"GastosDePersonal[[#This Row],[REAL]]+(10^-6)*ROW(GastosDePersonal[[#This Row],[REAL]])","v":6e-06},{"$f":"GastosDePersonal[[#This Row],[ESTIMADO]]-GastosDePersonal[[#This Row],[REAL]]","v":4000}]
[null,"Comisión",5000,4500,{"$f":"GastosDePersonal[[#This Row],[REAL]]+(10^-6)*ROW(GastosDePersonal[[#This Row],[REAL]])","v":4500.000007},{"$f":"GastosDePersonal[[#This Row],[ESTIMADO]]-GastosDePersonal[[#This Row],[REAL]]","v":500}]
[null,"Gastos de personal totales",{"$f":"SUBTOTAL(109,GastosDePersonal[ESTIMADO])","v":18500},{"$f":"SUBTOTAL(109,GastosDePersonal[REAL])","v":14100},null,{"$f":"SUBTOTAL(109,GastosDePersonal[DIFERENCIA])","v":4400}]
{"$rows_empty":10}
[{"$nulls":5}," "]

{"sheet":"Gastos operativos","index":3,"n_rows":25,"n_cols":11,"rows_kept":25,"merged":[[0,1,0,3],[1,1,1,3]]}
[null,"     NOMBRE DE LA COMPAÑÍA",null,null,"FECHA","FECHA"]
[null,"  PRESUPUESTO MENSUAL"]
[]
[null,"GASTOS OPERATIVOS","ESTIMADO","REAL","CINCO IMPORTES PRINCIPALES","DIFERENCIA"]
[null,"Publicidad",3000,2500,{"$f":"GastosOperativos[[#This Row],[REAL]]+(10^-6)*ROW(GastosOperativos[[#This Row],[REAL]])","v":2500.000005},{"$f":"GastosOperativos[[#This Row],[ESTIMADO]]-GastosOperativos[[#This Row],[REAL]]","v":500}]
[null,"Deudas incobrables",2000,2000,{"$f":"GastosOperativos[[#This Row],[REAL]]+(10^-6)*ROW(GastosOperativos[[#This Row],[REAL]])","v":2000.000006},{"$f":"GastosOperativos[[#This Row],[ESTIMADO]]-GastosOperativos[[#This Row],[REAL]]","v":0}]
[null,"Descuentos por pronto pago",1500,2175,{"$f":"GastosOperativos[[#This Row],[REAL]]+(10^-6)*ROW(GastosOperativos[[#This Row],[REAL]])","v":2175.000007},{"$f":"GastosOperativos[[#This Row],[ESTIMADO]]-GastosOperativos[[#This Row],[REAL]]","v":-675}]
[null,"Costes de entrega",2000,1500,{"$f":"GastosOperativos[[#This Row],[REAL]]+(10^-6)*ROW(GastosOperativos[[#This Row],[REAL]])","v":1500.000008},{"$f":"GastosOperativos[[#This Row],[ESTIMADO]]-GastosOperativos[[#This Row],[REAL]]","v":500}]
[null,"Depreciación",1000,1000,{"$f":"GastosOperativos[[#This Row],[REAL]]+(10^-6)*ROW(GastosOperativos[[#This Row],[REAL]])","v":1000.000009},{"$f":"GastosOperativos[[#This Row],[ESTIMADO]]-GastosOperativos[[#This Row],[REAL]]","v":0}]
[null,"Cuotas y suscripciones",500,525,{"$f":"GastosOperativos[[#This Row],[REAL]]+(10^-6)*ROW(GastosOperativos[[#This Row],[REAL]])","v":525.00001},{"$f":"GastosOperativos[[#This Row],[ESTIMADO]]-GastosOperativos[[#This Row],[REAL]]","v":-25}]
[null,"Seguro",1300,1275,{"$f":"GastosOperativos[[#This Row],[REAL]]+(10^-6)*ROW(GastosOperativos[[#This Row],[REAL]])","v":1275.000011},{"$f":"GastosOperativos[[#This Row],[ESTIMADO]]-GastosOperativos[[#This Row],[REAL]]","v":25}]
[null,"Intereses",2000,2200,{"$f":"GastosOperativos[[#This Row],[REAL]]+(10^-6)*ROW(GastosOperativos[[#This Row],[REAL]])","v":2200.000012},{"$f":"GastosOperativos[[#This Row],[ESTIMADO]]-GastosOperativos[[#This Row],[REAL]]","v":-200}]
[null,"Legal y auditoría",1000,800,{"$f":"GastosOperativos[[#This Row],[REAL]]+(10^-6)*ROW(GastosOperativos[[#This Row],[REAL]])","v":800.000013},{"$f":"GastosOperativos[[#This Row],[ESTIMADO]]-GastosOperativos[[#This Row],[REAL]]","v":200}]
[null,"Mantenimiento y reparaciones",4500,4600,{"$f":"GastosOperativos[[#This Row],[REAL]]+(10^-6)*ROW(GastosOperativos[[#This Row],[REAL]])","v":4600.000014},{"$f":"GastosOperativos[[#This Row],[ESTIMADO]]-GastosOperativos[[#This Row],[REAL]]","v":-100}]
[null,"Material de oficina",800,750,{"$f":"GastosOperativos[[#This Row],[REAL]]+(10^-6)*ROW(GastosOperativos[[#This Row],[REAL]])","v":750.000015},{"$f":"GastosOperativos[[#This Row],[ESTIMADO]]-GastosOperativos[[#This Row],[REAL]]","v":50}]
[null,"Franqueo",400,350,{"$f":"GastosOperativos[[#This Row],[REAL]]+(10^-6)*ROW(GastosOperativos[[#This Row],[REAL]])","v":350.000016},{"$f":"GastosOperativos[[#This Row],[ESTIMADO]]-GastosOperativos[[#This Row],[REAL]]","v":50}]
[null,"Alquiler o hipoteca",4100,4500,{"$f":"GastosOperativos[[#This Row],[REAL]]+(10^-6)*ROW(GastosOperativos[[#This Row],[REAL]])","v":4500.000017},{"$f":"GastosOperativos[[#This Row],[ESTIMADO]]-GastosOperativos[[#This Row],[REAL]]","v":-400}]
[null,"Gastos de ventas",350,400,{"$f":"GastosOperativos[[#This Row],[REAL]]+(10^-6)*ROW(GastosOperativos[[#This Row],[REAL]])","v":400.000018},{"$f":"GastosOperativos[[#This Row],[ESTIMADO]]-GastosOperativos[[#This Row],[REAL]]","v":-50}]
[null,"Almacenamiento y envío",900,840,{"$f":"GastosOperativos[[#This Row],[REAL]]+(10^-6)*ROW(GastosOperativos[[#This Row],[REAL]])","v":840.000019},{"$f":"GastosOperativos[[#This Row],[ESTIMADO]]-GastosOperativos[[#This Row],[REAL]]","v":60},{"$nulls":4}," "]
[null,"Suministros",5000,4500,{"$f":"GastosOperativos[[#This Row],[REAL]]+(10^-6)*ROW(GastosOperativos[[#This Row],[REAL]])","v":4500.00002},{"$f":"GastosOperativos[[#This Row],[ESTIMADO]]-GastosOperativos[[#This Row],[REAL]]","v":500}]
[null,"Impuestos",3000,3200,{"$f":"GastosOperativos[[#This Row],[REAL]]+(10^-6)*ROW(GastosOperativos[[#This Row],[REAL]])","v":3200.000021},{"$f":"GastosOperativos[[#This Row],[ESTIMADO]]-GastosOperativos[[#This Row],[REAL]]","v":-200}]
[null,"Teléfono",250,280,{"$f":"GastosOperativos[[#This Row],[REAL]]+(10^-6)*ROW(GastosOperativos[[#This Row],[REAL]])","v":280.000022},{"$f":"GastosOperativos[[#This Row],[ESTIMADO]]-GastosOperativos[[#This Row],[REAL]]","v":-30}]
[null,"Servicios públicos",1400,1385,{"$f":"GastosOperativos[[#This Row],[REAL]]+(10^-6)*ROW(GastosOperativos[[#This Row],[REAL]])","v":1385.000023},{"$f":"GastosOperativos[[#This Row],[ESTIMADO]]-GastosOperativos[[#This Row],[REAL]]","v":15}]
[null,"Otros",1000,750,{"$f":"GastosOperativos[[#This Row],[REAL]]+(10^-6)*ROW(GastosOperativos[[#This Row],[REAL]])","v":750.000024},{"$f":"GastosOperativos[[#This Row],[ESTIMADO]]-GastosOperativos[[#This Row],[REAL]]","v":250}]
[null,"Total de gastos operativos",{"$f":"SUBTOTAL(109,GastosOperativos[ESTIMADO])","v":36000},{"$f":"SUBTOTAL(109,GastosOperativos[REAL])","v":35530},null,{"$f":"SUBTOTAL(109,GastosOperativos[DIFERENCIA])","v":470}]