{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Gastos","Ingresos","Resumen"],"not_rendered":{"charts":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Gastos","index":0,"n_rows":33,"n_cols":7,"rows_kept":33,"merged":[[0,0,0,6],[1,0,1,6],[12,0,12,2],[12,4,12,6],[20,0,20,2],[20,4,20,6],[26,0,26,2]]}
["Presupuesto del evento [Nombre del evento]"]
[" > Gastos"]
[]
[{"$nulls":5},"Calculado","Real"]
["Gastos totales",{"$nulls":4},{"$f":"SUM(B12,B20,B26,B33,F12,F20,F25)","v":{"v":1145,"d":"1,145 €"}},{"$f":"SUM(C12,C20,C26,C33,G12,G20,G25)","v":{"v":395,"d":"395 €"}}]
[]
["Sitio","Calculado","Real",null,"Refrescos","Calculado","Real"]
["Tarifas de habitación",{"v":500,"d":"500 €"},{"v":250,"d":"250 €"},null,"Alimentos"]
["Plantilla",{"v":400,"d":"400 €"},{"v":50,"d":"50 €"},null,"Bebidas"]
["Equipo",{"$nulls":3},"Mantelerías"]
["Mesas y sillas",{"$nulls":3},"Personal y propinas"]
["Total",{"$f":"SUBTOTAL(109,[Calculado])","v":{"v":900,"d":"900 €"}},{"$f":"SUBTOTAL(109,[Real])","v":{"v":300,"d":"300 €"}},null,"Total",{"$f":"SUBTOTAL(109,[Calculado])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,[Real])","v":{"v":0,"d":"0 €"}}]
[]
["Decoración","Calculado","Real",null,"Programa","Calculado","Real"]
["Flores",{"v":200,"d":"200 €"},{"v":50,"d":"50 €"},null,"Intérpretes"]
["Velas",{"$nulls":3},"Altavoces"]
["Iluminación",{"$nulls":3},"Viaje"]
["Globos",{"$nulls":3},"Hotel"]
["Papel",{"$nulls":3},"Otros"]
["Total",{"$f":"SUBTOTAL(109,[Calculado])","v":{"v":200,"d":"200 €"}},{"$f":"SUBTOTAL(109,[Real])","v":{"v":50,"d":"50 €"}},null,"Total",{"$f":"SUBTOTAL(109,[Calculado])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,[Real])","v":{"v":0,"d":"0 €"}}]
[]
["Publicidad","Calculado","Real",null,"Premios","Calculado","Real"]
["Gráficos",{"v":45,"d":"45 €"},{"v":45,"d":"45 €"},null,"Cintas/Placas/Trofeos"]
["Fotocopiado/Impresión",{"$nulls":3},"Regalos"]
["Franqueo",{"$nulls":3},"Total",{"$f":"SUBTOTAL(109,[Calculado])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,[Real])","v":{"v":0,"d":"0 €"}}]
["Total",{"$f":"SUBTOTAL(109,[Calculado])","v":{"v":45,"d":"45 €"}},{"$f":"SUBTOTAL(109,[Real])","v":{"v":45,"d":"45 €"}}]
[]
["Varios","Calculado","Real"]
["Teléfono"]
["Transportes"]
["Artículos de papelería"]
["Servicios de fax"]
["Total",{"$f":"SUBTOTAL(109,[Calculado])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,[Real])","v":{"v":0,"d":"0 €"}}]

{"sheet":"Ingresos","index":1,"n_rows":34,"n_cols":6,"rows_kept":34,"merged":[[0,0,0,5],[1,0,1,5],[12,0,12,5],[19,0,19,5],[26,0,26,5]]}
[{"$f":"Gastos!A1","v":"Presupuesto del evento [Nombre del evento]"}]
[" > Ingresos"]
[]
[{"$nulls":4},"Calculado","Real"]
["Ingresos totales",{"$nulls":3},{"$f":"SUM(E12,E19,E26,E34)","v":{"v":1936,"d":"1,936 €"}},{"$f":"SUM(F12,F19,F26,F34)","v":{"v":1831,"d":"1,831 €"}}]
[]
["Admisiones"]
["Calculado","Real",null,null,"Calculado","Real"]
[{"v":300,"d":"300 €"},{"v":278,"d":"278 €"},"Adultos @",{"v":5,"d":"5 €"},{"$f":"A9*D9","v":{"v":1500,"d":"1,500 €"}},{"$f":"B9*D9","v":{"v":1390,"d":"1,390 €"}}]
[{"v":197,"d":"197 €"},{"v":195,"d":"195 €"},"Niños @",{"v":2,"d":"2 €"},{"$f":"A10*D10","v":{"v":394,"d":"394 €"}},{"$f":"B10*D10","v":{"v":390,"d":"390 €"}}]
[{"v":42,"d":"42 €"},{"v":51,"d":"51 €"},"Otros @",{"v":1,"d":"1 €"},{"$f":"A11*D11","v":{"v":42,"d":"42 €"}},{"$f":"B11*D11","v":{"v":51,"d":"51 €"}}]
[{"$nulls":4},{"$f":"SUM(E9:E11)","v":{"v":1936,"d":"1,936 €"}},{"$f":"SUM(F9:F11)","v":{"v":1831,"d":"1,831 €"}}]
[]
["Anuncios en programas"]
["Calculado","Real",null,null,"Calculado","Real"]
[null,null,"Portadas @",null,{"$f":"A16*D16","v":{"v":0,"d":"0 €"}},{"$f":"B16*D16","v":{"v":0,"d":"0 €"}}]
[null,null,"Media página @",null,{"$f":"A17*D17","v":{"v":0,"d":"0 €"}},{"$f":"B17*D17","v":{"v":0,"d":"0 €"}}]
[null,null,"Un cuarto de página @",null,{"$f":"A18*D18","v":{"v":0,"d":"0 €"}},{"$f":"B18*D18","v":{"v":0,"d":"0 €"}}]
[{"$nulls":4},{"$f":"SUM(E16:E18)","v":{"v":0,"d":"0 €"}},{"$f":"SUM(F16:F18)","v":{"v":0,"d":"0 €"}}]
[]
["Exhibidores/proveedores"]
["Calculado","Real",null,null,"Calculado","Real"]
[null,null,"Cabinas grandes @",null,{"$f":"A23*D23","v":{"v":0,"d":"0 €"}},{"$f":"B23*D23","v":{"v":0,"d":"0 €"}}]
[null,null,"Cabinas normales @",null,{"$f":"A24*D24","v":{"v":0,"d":"0 €"}},{"$f":"B24*D24","v":{"v":0,"d":"0 €"}}]
[null,null,"Cabinas pequeñas @",null,{"$f":"A25*D25","v":{"v":0,"d":"0 €"}},{"$f":"B25*D25","v":{"v":0,"d":"0 €"}}]
[{"$nulls":4},{"$f":"SUM(E23:E25)","v":{"v":0,"d":"0 €"}},{"$f":"SUM(F23:F25)","v":{"v":0,"d":"0 €"}}]
[]
["Venta de artículos"]
["Calculado","Real",null,null,"Calculado","Real"]
[null,null,"Artículos @",null,{"$f":"A30*D30","v":{"v":0,"d":"0 €"}},{"$f":"B30*D30","v":{"v":0,"d":"0 €"}}]
[null,null,"Artículos @",null,{"$f":"A31*D31","v":{"v":0,"d":"0 €"}},{"$f":"B31*D31","v":{"v":0,"d":"0 €"}}]
[null,null,"Artículos @",null,{"$f":"A32*D32","v":{"v":0,"d":"0 €"}},{"$f":"B32*D32","v":{"v":0,"d":"0 €"}}]
[null,null,"Artículos @",null,{"$f":"A33*D33","v":{"v":0,"d":"0 €"}},{"$f":"B33*D33","v":{"v":0,"d":"0 €"}}]
[{"$nulls":4},{"$f":"SUM(E30:E33)","v":{"v":0,"d":"0 €"}},{"$f":"SUM(F30:F33)","v":{"v":0,"d":"0 €"}}]

{"sheet":"Resumen","index":2,"n_rows":7,"n_cols":3,"rows_kept":7,"merged":[[0,0,0,5],[1,0,1,5]]}
[{"$f":"Gastos!A1","v":"Presupuesto del evento [Nombre del evento]"}]
[" > Resumen de beneficios y pérdidas"]
[]
[null,"Calculado","Real"]
["Ingresos totales",{"$f":"Ingresos!E5","v":{"v":1936,"d":"1,936 €"}},{"$f":"Ingresos!F5","v":{"v":1831,"d":"1,831 €"}}]
["Gastos totales",{"$f":"Gastos!F5","v":{"v":1145,"d":"1,145 €"}},{"$f":"Gastos!G5","v":{"v":395,"d":"395 €"}}]
["Beneficio total (o pérdidas)",{"$f":"B5-B6","v":{"v":791,"d":"791 €"}},{"$f":"C5-C6","v":{"v":1436,"d":"1,436 €"}}]