{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Barranquilla","Bogotá","Medellín","Brasilia"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Barranquilla","index":0,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["CIUDAD","PRODUCTOS","AÑO 2017","AÑO 2018","AÑO 2019","AÑO 2020","TOTAL INGRESO"]
["Barranquilla","PIZZA",8500,{"$f":"C2*12%+C2","v":9520},{"$f":"D2*13%+D2","v":10757.6},{"$f":"E2*13%+E2","v":12156.088}]
["Barranquilla","ENTRADAS",20569,{"$f":"C3*12%+C3","v":23037.279999999999},{"$f":"D3*13%+D3","v":26032.126399999997},29416.302831999998]
["Barranquilla","HAMBURGUESAS",9630,10785.6,12187.728000000001,13772.132640000002]
["Barranquilla","MULTIPASES",5263,5894.5599999999995,6660.8527999999997,7526.7636640000001]
["Barranquilla","TIQUETERAS",63215,70800.800000000003,80004.90400000001,90405.541520000013]
["Barranquilla","CRISPETAS",12326,13805.119999999999,15599.785599999999,17627.757728]
["Barranquilla","EVENTOS",32698,36621.760000000002,41382.588800000005,46762.325344000004]
["Barranquilla","COLEGIOS",25963,29078.560000000001,32858.772799999999,37130.413264000003]
["Barranquilla","FIESTAS",45693,51176.160000000003,57829.060800000007,65346.838704000009]
["Barranquilla","EXCLUSIVIDADES",56985,63823.199999999997,72120.216,81495.844079999995]
["Barranquilla","FUNDACIONES",12632,14147.84,15987.0592,18065.376896000002]
["Barranquilla","VACACIONES",42152,47210.239999999998,53347.571199999998,60282.755455999999]
["Barranquilla","PLAN DIVERSIÓN",55963,62678.559999999998,70826.772799999992,80034.253263999984]
["Barranquilla","PASAPORTE ILIMITADO",45632,51107.839999999997,57751.859199999999,65259.600895999996]
["Barranquilla","PLA CUMPLEAÑERO",12325,13804,15598.52,17626.327600000001]

{"sheet":"Bogotá","index":1,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["CIUDAD","PRODUCTOS","AÑO 2017","AÑO 2018","AÑO 2019","AÑO 2020","TOTAL INGRESO"]
["Bogotá","PIZZA",10500,{"$f":"C2*12%+C2","v":11760},{"$f":"D2*13%+D2","v":13288.8},{"$f":"E2*13%+E2","v":15016.343999999999}]
["Bogotá","ENTRADAS",22563,{"$f":"C3*12%+C3","v":25270.560000000001},{"$f":"D3*13%+D3","v":28555.732800000002},32267.978064000003]
["Bogotá","HAMBURGUESAS",10562,11829.44,13367.2672,15105.011936000001]
["Bogotá","MULTIPASES",7526,8429.1200000000008,9524.9056000000019,10763.143328000002]
["Bogotá","TIQUETERAS",66222,74168.639999999999,83810.563200000004,94705.936416000011]
["Bogotá","CRISPETAS",14223,15929.76,18000.628799999999,20340.710543999998]
["Bogotá","EVENTOS",35695,39978.400000000001,45175.592000000004,51048.418960000003]
["Bogotá","COLEGIOS",27963,31318.560000000001,35389.972800000003,39990.669264000004]
["Bogotá","FIESTAS",47859,53602.080000000002,60570.350400000003,68444.495951999997]
["Bogotá","EXCLUSIVIDADES",58632,65667.839999999997,74204.659199999995,83851.264895999993]
["Bogotá","FUNDACIONES",14526,16269.119999999999,18384.105599999999,20774.039327999999]
["Bogotá","VACACIONES",44656,50014.720000000001,56516.633600000001,63863.795967999999]

{"sheet":"Medellín","index":2,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["CIUDAD","PRODUCTOS","AÑO 2017","AÑO 2018","AÑO 2019","AÑO 2020","TOTAL INGRESO"]
["Medellín","PIZZA",8323,{"$f":"C2*12%+C2","v":9321.76},{"$f":"D2*13%+D2","v":10533.5888},{"$f":"E2*13%+E2","v":11902.955344}]
["Medellín","ENTRADAS",20363,{"$f":"C3*12%+C3","v":22806.560000000001},{"$f":"D3*13%+D3","v":25771.412800000002},29121.696464000001]
["Medellín","HAMBURGUESAS",96323,107881.76,121906.3888,137754.21934400001]
["Medellín","MULTIPASES",5963,6678.5599999999995,7546.7727999999997,8527.8532639999994]
["Medellín","TIQUETERAS",59632,66787.839999999997,75470.2592,85281.392896000005]
["Medellín","CRISPETAS",9856,11038.72,12473.7536,14095.341568]
["Medellín","EVENTOS",32659,36578.080000000002,41333.2304,46706.550351999998]
["Medellín","COLEGIOS",25896,29003.52,32773.977599999998,37034.594687999997]
["Medellín","FIESTAS",45852,51354.239999999998,58030.2912,65574.229055999996]
["Medellín","EXCLUSIVIDADES",55632,62307.839999999997,70407.859199999992,79560.880895999988]
["Medellín","FUNDACIONES",13252,14842.24,16771.731199999998,18952.056255999996]
["Medellín","VACACIONES",43526,48749.120000000003,55086.505600000004,62247.751328000006]
["Medellín","PLAN DIVERSIÓN",57632,64547.839999999997,72939.059199999989,82421.136895999982]
["Medellín","PASAPORTE ILIMITADO",47851,53593.120000000003,60560.225600000005,68433.054928000012]

{"sheet":"Brasilia","index":3,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["CIUDAD","PRODUCTOS","AÑO 2017","AÑO 2018","AÑO 2019","AÑO 2020","TOTAL INGRESO"]
["Brasilia","PIZZA",7956,{"$f":"C2*12%+C2","v":8910.7199999999993},{"$f":"D2*13%+D2","v":10069.113599999999},{"$f":"E2*13%+E2","v":11378.098367999999}]
["Brasilia","ENTRADAS",16523,{"$f":"C3*12%+C3","v":18505.759999999998},{"$f":"D3*13%+D3","v":20911.5088},23630.004944]
["Brasilia","HAMBURGUESAS",89632,100387.84,113438.2592,128185.232896]
["Brasilia","MULTIPASES",5000,5600,6328,7150.64]
["Brasilia","TIQUETERAS",50632,56707.839999999997,64079.859199999999,72410.240896000003]
["Brasilia","CRISPETAS",4596,5147.5200000000004,5816.6976000000004,6572.8682880000006]
["Brasilia","EVENTOS",24569,27517.279999999999,31094.526399999999,35136.814831999996]
["Brasilia","COLEGIOS",20256,22686.720000000001,25635.993600000002,28968.672768]
["Brasilia","FIESTAS",41632,46627.839999999997,52689.459199999998,59539.088896000001]
["Brasilia","EXCLUSIVIDADES",49874,55858.879999999997,63120.534399999997,71326.203871999998]
["Brasilia","VACACIONES",39635,44391.199999999997,50162.055999999997,56683.12328]
["Brasilia","PASAPORTE ILIMITADO",41896,46923.519999999997,53023.577599999997,59916.642687999993]
["Brasilia","PLA CUMPLEAÑERO",10479,11736.48,13262.222399999999,14986.311311999998]