{"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":35,"n_cols":9,"rows_kept":35,"merged":[[0,6,0,8],[1,6,1,7],[2,1,2,8],[3,7,3,8]]}
[]
[]
[null,"Presupuesto de evento para \n[Nombre del evento]"]
[{"$nulls":7}," Gastos"]
[]
[{"$nulls":7},"Estimado","Real"]
[null,null,"Gastos totales",{"$nulls":4},{"$f":"SUM(D14,D22,D28,D35,H14,H22,H27)","v":{"v":1145,"d":"1,145.00 €"}},{"$f":"SUM(E14,E22,E28,E35,I14,I22,I27)","v":{"v":395,"d":"395.00 €"}}]
[]
[null,null,"Sitio","Estimado","Real",null,"Aperitivos","Estimado","Real"]
[null,null,"Gastos de sala y auditorio",{"v":500,"d":"500.00 €"},{"v":250,"d":"250.00 €"},null,"Comida"]
[null,null,"Personal del sitio",{"v":400,"d":"400.00 €"},{"v":50,"d":"50.00 €"},null,"Bebidas"]
[null,null,"Equipamiento",{"$nulls":3},"Mantelería"]
[null,null,"Mesas y sillas",{"$nulls":3},"Personal y compensaciones"]
[null,null,"Total",{"$f":"SUBTOTAL(109,Tabla1[Estimado])","v":{"v":900,"d":"900.00 €"}},{"$f":"SUBTOTAL(109,Tabla1[Real])","v":{"v":300,"d":"300.00 €"}},null,"Total",{"$f":"SUBTOTAL(109,Tabla5[Estimado])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Tabla5[Real])","v":{"v":0,"d":"0.00 €"}}]
[]
[null,null,"Decoraciones","Estimado","Real",null,"Programa","Estimado","Real"]
[null,null,"Flores",{"v":200,"d":"200.00 €"},{"v":50,"d":"50.00 €"},null,"Artistas"]
[null,null,"Velas",{"$nulls":3},"Altavoces"]
[null,null,"Iluminación",{"$nulls":3},"Viaje"]
[null,null,"Globos",{"$nulls":3},"Hotel"]
[null,null,"Suministros de papel",{"$nulls":3},"Otros"]
[null,null,"Total",{"$f":"SUBTOTAL(109,Tabla2[Estimado])","v":{"v":200,"d":"200.00 €"}},{"$f":"SUBTOTAL(109,Tabla2[Real])","v":{"v":50,"d":"50.00 €"}},null,"Total",{"$f":"SUBTOTAL(109,Tabla6[Estimado])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Tabla6[Real])","v":{"v":0,"d":"0.00 €"}}]
[]
[null,null,"Publicidad","Estimado","Real",null,"Premios","Estimado","Real"]
[null,null,"Trabajo de gráficos",{"v":45,"d":"45.00 €"},{"v":45,"d":"45.00 €"},null,"Cintas, placas y trofeos"]
[null,null,"Fotocopias e impresión",{"$nulls":3},"Regalos"]
[null,null,"Gastos de envío",{"$nulls":3},"Total",{"$f":"SUBTOTAL(109,Tabla7[Estimado])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Tabla7[Real])","v":{"v":0,"d":"0.00 €"}}]
[null,null,"Total",{"$f":"SUBTOTAL(109,Tabla3[Estimado])","v":{"v":45,"d":"45.00 €"}},{"$f":"SUBTOTAL(109,Tabla3[Real])","v":{"v":45,"d":"45.00 €"}}]
[]
[null,null,"Varios","Estimado","Real"]
[null,null,"Teléfono"]
[null,null,"Transporte"]
[null,null,"Suministros de papelería"]
[null,null,"Servicios de fax"]
[null,null,"Total",{"$f":"SUBTOTAL(109,Tabla4[Estimado])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Tabla4[Real])","v":{"v":0,"d":"0.00 €"}}]

{"sheet":"Ingresos","index":1,"n_rows":36,"n_cols":7,"rows_kept":36,"merged":[[2,1,2,6],[3,5,3,6],[14,1,14,6],[21,1,21,6],[28,1,28,6]]}
[]
[]
[null,"Presupuesto de evento para \n[Nombre del evento]"]
[{"$nulls":5}," Ingresos"]
[]
[{"$nulls":5},"Estimado","Real"]
[null,"Ingresos totales",{"$nulls":3},{"$f":"SUM(F14,F21,F28,F36)","v":{"v":1936,"d":"1,936.00 €"}},{"$f":"SUM(G14,G21,G28,G36)","v":{"v":1831,"d":"1,831.00 €"}}]
[]
[null,"Admisiones"]
[null,"Estimado","Real",null,null,"Estimado","Real"]
[null,300,278,"Adultos @",{"v":5,"d":"5.00 €"},{"$f":"B11*E11","v":{"v":1500,"d":"1,500.00 €"}},{"$f":"C11*E11","v":{"v":1390,"d":"1,390.00 €"}}]
[null,197,195,"Niños @",{"v":2,"d":"2.00 €"},{"$f":"B12*E12","v":{"v":394,"d":"394.00 €"}},{"$f":"C12*E12","v":{"v":390,"d":"390.00 €"}}]
[null,42,51,"Otros @",{"v":1,"d":"1.00 €"},{"$f":"B13*E13","v":{"v":42,"d":"42.00 €"}},{"$f":"C13*E13","v":{"v":51,"d":"51.00 €"}}]
[{"$nulls":5},{"$f":"SUM(F11:F13)","v":{"v":1936,"d":"1,936.00 €"}},{"$f":"SUM(G11:G13)","v":{"v":1831,"d":"1,831.00 €"}}]
[]
[null,"Anuncios de programa"]
[null,"Estimado","Real",null,null,"Estimado","Real"]
[{"$nulls":3},"Portadas @",null,{"$f":"B18*E18","v":{"v":0,"d":"0.00 €"}},{"$f":"C18*E18","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":3},"Medias páginas @",null,{"$f":"B19*E19","v":{"v":0,"d":"0.00 €"}},{"$f":"C19*E19","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":3},"Cuartos de página @",null,{"$f":"B20*E20","v":{"v":0,"d":"0.00 €"}},{"$f":"C20*E20","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":5},{"$f":"SUM(F18:F20)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(G18:G20)","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"Expositores y proveedores"]
[null,"Estimado","Real",null,null,"Estimado","Real"]
[{"$nulls":3},"Stands grandes @",null,{"$f":"B25*E25","v":{"v":0,"d":"0.00 €"}},{"$f":"C25*E25","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":3},"Stands medianos @",null,{"$f":"B26*E26","v":{"v":0,"d":"0.00 €"}},{"$f":"C26*E26","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":3},"Stands pequeños @",null,{"$f":"B27*E27","v":{"v":0,"d":"0.00 €"}},{"$f":"C27*E27","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":5},{"$f":"SUM(F25:F27)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(G25:G27)","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"Venta de productos"]
[null,"Estimado","Real",null,null,"Estimado","Real"]
[{"$nulls":3},"Artículos @",null,{"$f":"B32*E32","v":{"v":0,"d":"0.00 €"}},{"$f":"C32*E32","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":3},"Artículos @",null,{"$f":"B33*E33","v":{"v":0,"d":"0.00 €"}},{"$f":"C33*E33","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":3},"Artículos @",null,{"$f":"B34*E34","v":{"v":0,"d":"0.00 €"}},{"$f":"C34*E34","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":3},"Artículos @",null,{"$f":"B35*E35","v":{"v":0,"d":"0.00 €"}},{"$f":"C35*E35","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":5},{"$f":"SUM(F32:F35)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(G32:G35)","v":{"v":0,"d":"0.00 €"}}]

{"sheet":"Resumen","index":2,"n_rows":9,"n_cols":7,"rows_kept":9,"merged":[[2,1,2,6],[3,5,3,6]]}
[]
[]
[null,"Presupuesto de evento para \n[Nombre del evento]"]
[{"$nulls":5},"Resumen de ganancias y pérdidas"]
[]
[{"$nulls":5},"Estimado","Real"]
[null,"Ingresos totales",{"$nulls":3},{"$f":"Ingresos!F7","v":{"v":1936,"d":"1,936.00 €"}},{"$f":"Ingresos!G7","v":{"v":1831,"d":"1,831.00 €"}}]
[null,"Gastos totales",{"$nulls":3},{"$f":"Gastos!H7","v":{"v":1145,"d":"1,145.00 €"}},{"$f":"Gastos!I7","v":{"v":395,"d":"395.00 €"}}]
[null,"Beneficio total (o pérdida)",{"$nulls":3},{"$f":"F7-F8","v":{"v":791,"d":"791.00 €"}},{"$f":"G7-G8","v":{"v":1436,"d":"1,436.00 €"}}]