{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Gastos","Ingresos","Beneficios y pérdidas"],"not_rendered":{"charts":4,"images":6,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Gastos","index":0,"n_rows":31,"n_cols":9,"rows_kept":31,"merged":[[6,1,7,1]]}
[{"$nulls":8}," "]
[]
[null,"Fiesta por el lanzamiento del producto"]
[null,"DETALLES DE GASTOS"]
[]
[]
[null,"Gastos totales","Estimado","Real",null,"Programa","Estimado","Real"]
[null,null,{"$f":"SiteExpenses[[#Totals],[Estimado]]+DecorationsExpenses[[#Totals],[Estimado]]+PublicityExpenses[[#Totals],[Estimado]]+MiscellaneousExpenses[[#Totals],[Estimado]]+RefreshmentsExpenses[[#Totals],[Estimado]]+ProgramExpenses[[#Totals],[Estimado]]+PrizesExpenses[[#Totals],[Estimado]]","v":{"v":2090,"d":"2,090.00 €"}},{"$f":"SiteExpenses[[#Totals],[Real]]+DecorationsExpenses[[#Totals],[Real]]+PublicityExpenses[[#Totals],[Real]]+MiscellaneousExpenses[[#Totals],[Real]]+RefreshmentsExpenses[[#Totals],[Real]]+ProgramExpenses[[#Totals],[Real]]+PrizesExpenses[[#Totals],[Real]]","v":{"v":1640,"d":"1,640.00 €"}},null,"Artistas",{"v":750,"d":"750.00 €"},{"v":700,"d":"700.00 €"}]
[{"$nulls":5},"Altavoces",{"v":150,"d":"150.00 €"},{"v":0,"d":"0.00 €"}]
[{"$nulls":5},"Viaje"]
[null,"Sitio","Estimado","Real",null,"Hotel"]
[null,"Gastos de sala y auditorio",{"v":500,"d":"500.00 €"},{"v":450,"d":"450.00 €"},null,"Otros"]
[null,"Personal del sitio",{"$nulls":3},"Total",{"$f":"SUBTOTAL(109,ProgramExpenses[Estimado])","v":{"v":900,"d":"900.00 €"}},{"$f":"SUBTOTAL(109,ProgramExpenses[Real])","v":{"v":700,"d":"700.00 €"}}]
[null,"Equipamiento"]
[null,"Mesas y sillas",{"$nulls":3},"Publicidad","Estimado","Real"]
[null,"Total",{"$f":"SUBTOTAL(109,SiteExpenses[Estimado])","v":{"v":500,"d":"500.00 €"}},{"$f":"SUBTOTAL(109,SiteExpenses[Real])","v":{"v":450,"d":"450.00 €"}},null,"Trabajo de gráficos"]
[{"$nulls":5},"Fotocopias e impresión",{"v":20,"d":"20.00 €"},{"v":20,"d":"20.00 €"}]
[null,"Decoraciones","Estimado","Real",null,"Gastos de envío"]
[null,"Flores",{"v":200,"d":"200.00 €"},{"v":100,"d":"100.00 €"},null,"Total",{"$f":"SUBTOTAL(109,PublicityExpenses[Estimado])","v":{"v":20,"d":"20.00 €"}},{"$f":"SUBTOTAL(109,PublicityExpenses[Real])","v":{"v":20,"d":"20.00 €"}}]
[null,"Velas"]
[null,"Iluminación",{"$nulls":3},"Premios","Estimado","Real"]
[null,"Globos",{"$nulls":3},"Cintas de opciones y trofeos"]
[null,"Suministros de papel",{"$nulls":3},"Regalos",{"v":100,"d":"100.00 €"},{"v":100,"d":"100.00 €"}]
[null,"Total",{"$f":"SUBTOTAL(109,DecorationsExpenses[Estimado])","v":{"v":200,"d":"200.00 €"}},{"$f":"SUBTOTAL(109,DecorationsExpenses[Real])","v":{"v":100,"d":"100.00 €"}},null,"Total",{"$f":"SUBTOTAL(109,PrizesExpenses[Estimado])","v":{"v":100,"d":"100.00 €"}},{"$f":"SUBTOTAL(109,PrizesExpenses[Real])","v":{"v":100,"d":"100.00 €"}}]
[]
[null,"Aperitivos","Estimado","Real",null,"Varios","Estimado","Real"]
[null,"Comida",{"$nulls":3},"Teléfono",{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"}]
[null,"Bebidas",{"v":220,"d":"220.00 €"},{"v":120,"d":"120.00 €"},null,"Transporte",{"v":20,"d":"20.00 €"},{"v":20,"d":"20.00 €"}]
[null,"Mantelería",{"v":80,"d":"80.00 €"},{"v":80,"d":"80.00 €"},null,"Suministros de papelería"]
[null,"Personal y compensaciones",{"$nulls":3},"Servicios de fax"]
[null,"Total",{"$f":"SUBTOTAL(109,RefreshmentsExpenses[Estimado])","v":{"v":300,"d":"300.00 €"}},{"$f":"SUBTOTAL(109,RefreshmentsExpenses[Real])","v":{"v":200,"d":"200.00 €"}},null,"Total",{"$f":"SUBTOTAL(109,MiscellaneousExpenses[Estimado])","v":{"v":70,"d":"70.00 €"}},{"$f":"SUBTOTAL(109,MiscellaneousExpenses[Real])","v":{"v":70,"d":"70.00 €"}}]

{"sheet":"Ingresos","index":1,"n_rows":37,"n_cols":8,"rows_kept":37,"merged":[[6,1,7,1],[9,1,9,6],[16,1,16,6],[23,1,23,6],[30,1,30,6]]}
[{"$nulls":7}," "]
[]
[null,{"$f":"Gastos!B3","v":"Fiesta por el lanzamiento del producto"}]
[null,"DETALLES DE INGRESOS"]
[]
[]
[null,"Ingresos totales","Estimado","Real"]
[null,null,{"$f":"SUM(Admisiones[[#Totals],[Ingresos estimados]],AdsInProgram[[#Totals],[Ingresos estimados]],ExhibitorsAndVendors[[#Totals],[Ingresos estimados]],SaleOfItems[[#Totals],[Ingresos estimados]])","v":{"v":4450,"d":"4,450.00 €"}},{"$f":"SUM(Admisiones[[#Totals],[Ingresos reales]],AdsInProgram[[#Totals],[Ingresos reales]],ExhibitorsAndVendors[[#Totals],[Ingresos reales]],SaleOfItems[[#Totals],[Ingresos reales]])","v":{"v":4170,"d":"4,170.00 €"}}]
[]
[null,"Admisiones"]
[null,"Tipo","Estimado","Real","Precio","Ingresos estimados","Ingresos reales"]
[null,"Adultos",30,25,{"v":20,"d":"20.00 €"},{"$f":"C12*E12","v":{"v":600,"d":"600.00 €"}},{"$f":"D12*E12","v":{"v":500,"d":"500.00 €"}}]
[null,"Niños",20,22,{"v":10,"d":"10.00 €"},{"$f":"C13*E13","v":{"v":200,"d":"200.00 €"}},{"$f":"D13*E13","v":{"v":220,"d":"220.00 €"}}]
[null,"Otros",10,10,{"v":10,"d":"10.00 €"},{"$f":"C14*E14","v":{"v":100,"d":"100.00 €"}},{"$f":"D14*E14","v":{"v":100,"d":"100.00 €"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Admisiones[Estimado])","v":60},{"$f":"SUBTOTAL(109,Admisiones[Real])","v":57},null,{"$f":"SUBTOTAL(109,Admisiones[Ingresos estimados])","v":{"v":900,"d":"900.00 €"}},{"$f":"SUBTOTAL(109,Admisiones[Ingresos reales])","v":{"v":820,"d":"820.00 €"}}]
[]
[null,"Anuncios de programa"]
[null,"Tipo","Estimado","Real","Precio","Ingresos estimados","Ingresos reales"]
[null,"Portadas",2,4,{"v":50,"d":"50.00 €"},{"$f":"C19*E19","v":{"v":100,"d":"100.00 €"}},{"$f":"D19*E19","v":{"v":200,"d":"200.00 €"}}]
[null,"Medias páginas",2,2,{"v":30,"d":"30.00 €"},{"$f":"C20*E20","v":{"v":60,"d":"60.00 €"}},{"$f":"D20*E20","v":{"v":60,"d":"60.00 €"}}]
[null,"Cuartos de página",2,2,{"v":20,"d":"20.00 €"},{"$f":"C21*E21","v":{"v":40,"d":"40.00 €"}},{"$f":"D21*E21","v":{"v":40,"d":"40.00 €"}}]
[null,"Total",{"$f":"SUBTOTAL(109,AdsInProgram[Estimado])","v":6},{"$f":"SUBTOTAL(109,AdsInProgram[Real])","v":8},null,{"$f":"SUBTOTAL(109,AdsInProgram[Ingresos estimados])","v":{"v":200,"d":"200.00 €"}},{"$f":"SUBTOTAL(109,AdsInProgram[Ingresos reales])","v":{"v":300,"d":"300.00 €"}}]
[]
[null,"Expositores y proveedores"]
[null,"Tipo","Estimado","Real","Precio","Ingresos estimados","Ingresos reales"]
[null,"Stands grandes",5,5,{"v":300,"d":"300.00 €"},{"$f":"C26*E26","v":{"v":1500,"d":"1,500.00 €"}},{"$f":"D26*E26","v":{"v":1500,"d":"1,500.00 €"}}]
[null,"Stands medianos",5,4,{"v":200,"d":"200.00 €"},{"$f":"C27*E27","v":{"v":1000,"d":"1,000.00 €"}},{"$f":"D27*E27","v":{"v":800,"d":"800.00 €"}}]
[null,"Stands pequeños",1,0,{"v":100,"d":"100.00 €"},{"$f":"C28*E28","v":{"v":100,"d":"100.00 €"}},{"$f":"D28*E28","v":{"v":0,"d":"0.00 €"}}]
[null,"Total",{"$f":"SUBTOTAL(109,ExhibitorsAndVendors[Estimado])","v":11},{"$f":"SUBTOTAL(109,ExhibitorsAndVendors[Real])","v":9},null,{"$f":"SUBTOTAL(109,ExhibitorsAndVendors[Ingresos estimados])","v":{"v":2600,"d":"2,600.00 €"}},{"$f":"SUBTOTAL(109,ExhibitorsAndVendors[Ingresos reales])","v":{"v":2300,"d":"2,300.00 €"}}]
[]
[null,"Ventas de artículos"]
[null,"Tipo","Estimado","Real","Precio","Ingresos estimados","Ingresos reales"]
[null,"Artículo 1",2,2,{"v":150,"d":"150.00 €"},{"$f":"C33*E33","v":{"v":300,"d":"300.00 €"}},{"$f":"D33*E33","v":{"v":300,"d":"300.00 €"}}]
[null,"Artículo 2",5,5,{"v":50,"d":"50.00 €"},{"$f":"C34*E34","v":{"v":250,"d":"250.00 €"}},{"$f":"D34*E34","v":{"v":250,"d":"250.00 €"}}]
[null,"Artículo 3",5,5,{"v":20,"d":"20.00 €"},{"$f":"C35*E35","v":{"v":100,"d":"100.00 €"}},{"$f":"D35*E35","v":{"v":100,"d":"100.00 €"}}]
[null,"Elemento 4",5,5,{"v":20,"d":"20.00 €"},{"$f":"C36*E36","v":{"v":100,"d":"100.00 €"}},{"$f":"D36*E36","v":{"v":100,"d":"100.00 €"}}]
[null,"Total",{"$f":"SUBTOTAL(109,SaleOfItems[Estimado])","v":17},{"$f":"SUBTOTAL(109,SaleOfItems[Real])","v":17},null,{"$f":"SUBTOTAL(109,SaleOfItems[Ingresos estimados])","v":{"v":750,"d":"750.00 €"}},{"$f":"SUBTOTAL(109,SaleOfItems[Ingresos reales])","v":{"v":750,"d":"750.00 €"}}]

{"sheet":"Beneficios y pérdidas","index":2,"n_rows":29,"n_cols":16,"rows_kept":29,"merged":[[28,1,28,3],[28,4,28,6]]}
[{"$nulls":7}," "]
[]
[null,{"$f":"Gastos!B3","v":"Fiesta por el lanzamiento del producto"}]
[null,"RESUMEN DE BENEFICIOS Y PÉRDIDAS"]
[]
[]
[null,"Resumen de gastos","Estimado","Real",null,"Gastos reales",{"$nulls":5},"Clasificación","Gastos","Estimado","Real","Valor de clasificación"]
[null,{"$f":"VLOOKUP(1,$L$8:$O$14,2,FALSE)","v":"Programa"},{"$f":"VLOOKUP(1,$L$8:$O$14,3,FALSE)","v":{"v":900,"d":"900.00 €"}},{"$f":"VLOOKUP(1,$L$8:$O$14,4,FALSE)","v":{"v":700,"d":"700.00 €"}},{"$nulls":7},{"$f":"_xlfn.RANK.AVG(P8,$P$8:$P$14)","v":2},"Sitio",{"$f":"SiteExpenses[[#Totals],[Estimado]]","v":{"v":500,"d":"500 €"}},{"$f":"SiteExpenses[[#Totals],[Real]]","v":{"v":450,"d":"450 €"}},{"$f":"O8+ROW(O8)/10000","v":450.0008}]
[null,{"$f":"VLOOKUP(2,$L$8:$O$14,2,FALSE)","v":"Sitio"},{"$f":"VLOOKUP(2,$L$8:$O$14,3,FALSE)","v":{"v":500,"d":"500.00 €"}},{"$f":"VLOOKUP(2,$L$8:$O$14,4,FALSE)","v":{"v":450,"d":"450.00 €"}},{"$nulls":7},5,"Decoración",{"$f":"DecorationsExpenses[[#Totals],[Estimado]]","v":{"v":200,"d":"200 €"}},{"$f":"DecorationsExpenses[[#Totals],[Real]]","v":{"v":100,"d":"100 €"}},{"$f":"O9+ROW(O9)/10000","v":100.0009}]
[null,{"$f":"VLOOKUP(3,$L$8:$O$14,2,FALSE)","v":"Aperitivos"},{"$f":"VLOOKUP(3,$L$8:$O$14,3,FALSE)","v":{"v":300,"d":"300.00 €"}},{"$f":"VLOOKUP(3,$L$8:$O$14,4,FALSE)","v":{"v":200,"d":"200.00 €"}},{"$nulls":7},3,"Aperitivos",{"$f":"RefreshmentsExpenses[[#Totals],[Estimado]]","v":{"v":300,"d":"300 €"}},{"$f":"RefreshmentsExpenses[[#Totals],[Real]]","v":{"v":200,"d":"200 €"}},{"v":200.001,"d":"200.0010"}]
[null,{"$f":"VLOOKUP(4,$L$8:$O$14,2,FALSE)","v":"Premios"},{"$f":"VLOOKUP(4,$L$8:$O$14,3,FALSE)","v":{"v":100,"d":"100.00 €"}},{"$f":"VLOOKUP(4,$L$8:$O$14,4,FALSE)","v":{"v":100,"d":"100.00 €"}},{"$nulls":7},1,"Programa",{"$f":"ProgramExpenses[[#Totals],[Estimado]]","v":{"v":900,"d":"900 €"}},{"$f":"ProgramExpenses[[#Totals],[Real]]","v":{"v":700,"d":"700 €"}},700.0011]
[null,{"$f":"VLOOKUP(5,$L$8:$O$14,2,FALSE)","v":"Decoración"},{"$f":"VLOOKUP(5,$L$8:$O$14,3,FALSE)","v":{"v":200,"d":"200.00 €"}},{"$f":"VLOOKUP(5,$L$8:$O$14,4,FALSE)","v":{"v":100,"d":"100.00 €"}},{"$nulls":7},7,"Publicidad",{"$f":"PublicityExpenses[[#Totals],[Estimado]]","v":{"v":20,"d":"20 €"}},{"$f":"PublicityExpenses[[#Totals],[Real]]","v":{"v":20,"d":"20 €"}},20.0012]
[null,{"$f":"VLOOKUP(6,$L$8:$O$14,2,FALSE)","v":"Varios"},{"$f":"VLOOKUP(6,$L$8:$O$14,3,FALSE)","v":{"v":70,"d":"70.00 €"}},{"$f":"VLOOKUP(6,$L$8:$O$14,4,FALSE)","v":{"v":70,"d":"70.00 €"}},{"$nulls":7},4,"Premios",{"$f":"PrizesExpenses[[#Totals],[Estimado]]","v":{"v":100,"d":"100 €"}},{"$f":"PrizesExpenses[[#Totals],[Real]]","v":{"v":100,"d":"100 €"}},100.0013]
[null,{"$f":"VLOOKUP(7,$L$8:$O$14,2,FALSE)","v":"Publicidad"},{"$f":"VLOOKUP(7,$L$8:$O$14,3,FALSE)","v":{"v":20,"d":"20.00 €"}},{"$f":"VLOOKUP(7,$L$8:$O$14,4,FALSE)","v":{"v":20,"d":"20.00 €"}},{"$nulls":7},6,"Varios",{"$f":"MiscellaneousExpenses[[#Totals],[Estimado]]","v":{"v":70,"d":"70 €"}},{"$f":"MiscellaneousExpenses[[#Totals],[Real]]","v":{"v":70,"d":"70 €"}},70.0014]
[null,"Total",{"$f":"SUBTOTAL(109,ExpensesSummary[Estimado])","v":{"v":2090,"d":"2,090.00 €"}},{"$f":"SUBTOTAL(109,ExpensesSummary[Real])","v":{"v":1640,"d":"1,640.00 €"}}]
[]
[null,"Resumen de ingresos","Estimado","Real",null,"Ingresos reales",{"$nulls":5},"Clasificación","Ingresos","Estimado","Real","Valor de clasificación"]
[null,{"$f":"VLOOKUP(1,$L$18:$O$21,2,FALSE)","v":"Expositores y proveedores"},{"$f":"VLOOKUP(1,$L$18:$O$21,3,FALSE)","v":{"v":2600,"d":"2,600.00 €"}},{"$f":"VLOOKUP(1,$L$18:$O$21,4,FALSE)","v":{"v":2300,"d":"2,300.00 €"}},{"$nulls":7},{"$f":"_xlfn.RANK.AVG(P18,$P$18:$P$21)","v":2},"Admisiones",{"$f":"Admisiones[[#Totals],[Ingresos estimados]]","v":{"v":900,"d":"900 €"}},{"$f":"Admisiones[[#Totals],[Ingresos reales]]","v":{"v":820,"d":"820 €"}},{"$f":"O18+ROW(O18)/10000","v":820.0018}]
[null,{"$f":"VLOOKUP(2,$L$18:$O$21,2,FALSE)","v":"Admisiones"},{"$f":"VLOOKUP(2,$L$18:$O$21,3,FALSE)","v":{"v":900,"d":"900.00 €"}},{"$f":"VLOOKUP(2,$L$18:$O$21,4,FALSE)","v":{"v":820,"d":"820.00 €"}},{"$nulls":7},{"$f":"_xlfn.RANK.AVG(P19,$P$18:$P$21)","v":4},"Anuncios de programa",{"$f":"AdsInProgram[[#Totals],[Ingresos estimados]]","v":{"v":200,"d":"200 €"}},{"$f":"AdsInProgram[[#Totals],[Ingresos reales]]","v":{"v":300,"d":"300 €"}},300.0019]
[null,"Ventas de artículos",{"$f":"VLOOKUP(3,$L$18:$O$21,3,FALSE)","v":{"v":750,"d":"750.00 €"}},{"$f":"VLOOKUP(3,$L$18:$O$21,4,FALSE)","v":{"v":750,"d":"750.00 €"}},{"$nulls":7},1,"Expositores y proveedores",{"$f":"ExhibitorsAndVendors[[#Totals],[Ingresos estimados]]","v":{"v":2600,"d":"2,600 €"}},{"$f":"ExhibitorsAndVendors[[#Totals],[Ingresos reales]]","v":{"v":2300,"d":"2,300 €"}},{"v":2300.002,"d":"2,300.0020"}]
[null,{"$f":"VLOOKUP(4,$L$18:$O$21,2,FALSE)","v":"Anuncios de programa"},{"$f":"VLOOKUP(4,$L$18:$O$21,3,FALSE)","v":{"v":200,"d":"200.00 €"}},{"$f":"VLOOKUP(4,$L$18:$O$21,4,FALSE)","v":{"v":300,"d":"300.00 €"}},{"$nulls":7},3,"Ventas de artículos",{"$f":"SaleOfItems[[#Totals],[Ingresos estimados]]","v":{"v":750,"d":"750 €"}},{"$f":"SaleOfItems[[#Totals],[Ingresos reales]]","v":{"v":750,"d":"750 €"}},750.0021]
[null,"Total",{"$f":"SUBTOTAL(109,IncomeSummary[Estimado])","v":{"v":4450,"d":"4,450.00 €"}},{"$f":"SUBTOTAL(109,IncomeSummary[Real])","v":{"v":4170,"d":"4,170.00 €"}}]
[]
[null,"Resumen de beneficios y pérdidas","Estimado","Real"]
[null,"Ingresos totales",{"$f":"IncomeSummary[[#Totals],[Estimado]]","v":{"v":4450,"d":"4,450.00 €"}},{"$f":"IncomeSummary[[#Totals],[Real]]","v":{"v":4170,"d":"4,170.00 €"}}]
[null,"Gastos totales",{"$f":"ExpensesSummary[[#Totals],[Estimado]]","v":{"v":2090,"d":"2,090.00 €"}},{"$f":"ExpensesSummary[[#Totals],[Real]]","v":{"v":1640,"d":"1,640.00 €"}}]
[null,"Beneficios o (pérdida)",{"$f":"C25-C26","v":{"v":2360,"d":"2,360.00 €"}},{"$f":"D25-D26","v":{"v":2530,"d":"2,530.00 €"}}]
[]
[null,"Relación entre gastos y beneficios (pérdida)",null,null,"Costos estimados frente a reales"]