{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["impuestos","Hoja2"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":2,"defined_names":0,"comments":2,"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":"impuestos","index":0,"n_rows":32,"n_cols":21,"rows_kept":32,"cut":false,"hidden":false,"merged":[[24,0,24,1],[24,12,24,13],[25,0,25,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[14,9,14,10],[15,0,15,1],[15,5,15,6],[16,0,16,1],[22,0,22,1],[23,0,23,1],[12,0,12,1],[12,5,12,6],[13,0,13,1],[13,5,13,6],[14,0,14,1],[14,5,14,6],[8,0,8,1],[8,5,8,6],[9,0,9,1],[10,0,10,1],[10,5,10,6],[11,0,11,1],[5,0,5,1],[5,15,5,16],[6,0,6,1],[6,5,6,6],[6,15,6,16],[7,0,7,1],[0,0,0,1],[3,0,3,1],[3,5,3,6],[3,9,3,10],[3,15,3,16],[4,0,4,1],[4,9,4,10]]}
[{"$f":"M24","v":"MAYO"},null,{"$f":"'[1]Resumen Impuestos'!A6","v":2019},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(7,[1]Santiago!A63:A235,2,FALSE),\"\")","v":""}]
[]
[]
["Impuestos",null,null,null,null,"Otros",null,null,null,"Precios de",null,null,null,null,null,"Periodicos"]
["Gas",null,null,null,null,"Lavanderia",400,null,null,"Caramelos",null,null,null,null,null,null,null,"$ x Unidad","Dias","$ Mensual"]
["Cable",null,965,null,null,"Café",317.61,null,null,"Billiken ","Unidades",null,null,null,null,"Ecos Diarios Semanal",null,50,{"$f":"([1]Santiago!B65-S7)","v":18},{"$f":"R6*S6","v":900},"Final"]
["Telefono",null,null,"Cons. Mes",null,"Diarios y Revistas",null,{"$f":"S10","v":1100},null,11.01,0,{"$f":"J7*K7","v":0},null,null,null,"Ecos Diarios Sabados",null,50,{"$f":"VLOOKUP(A1,'[2]Facturacion Mes'!$A$9:$J$20,10,FALSE)","v":4},{"$f":"R7*S7","v":200},{"$f":"SUM(T6:T7)","v":1100}]
["Luz ",null,null,null,null,"Limpieza",400,null,null,"Misky"]
["Arba Inmobiliario",null,null,null,null,"Caramelos",null,{"$f":"L12","v":0},null,96.79,null,{"$f":"J9*K9","v":0},null,null,null,"Diariero"]
["Tasa inmobiliaria",null,null,null,null,"Gaseosas ",200,null,null,"Arcor",null,null,null,null,null,null,null,null,{"$f":"$U$7","v":1100}]
["Camara Comercial",null,null,null,null,"Panaderia",null,{"$f":"M17","v":800},null,108.89,0,{"$f":"J11*K11","v":0},null,null,null,"Sabados","Retiro","Entrego","Saldo","Por Semana"]
["Cuota seguro",null,2698,null,null,"Cera 8M",406.55,null,null,null,{"$f":"SUM(K7+K9+K11)","v":0},{"$f":"SUM(L7+L9+L11)","v":0},null,null,null,{"$f":"IFERROR(VLOOKUP(7,'[1]Plata Diaria'!A5:B8,2,FALSE),\"\")","v":"2019-05-04"},null,null,{"$f":"IF(P12=\"\",S10,S10+Q12-R12)","v":1100},{"$f":"S10/(COUNT(P12:P16))","v":275}]
["Seg. E Higiene",null,null,null,null,"Otros",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(7,'[1]Plata Diaria'!A9:B13,2,FALSE),\"\")","v":""},null,null,{"$f":"S12-Q13+R13","v":1100}]
["Internet",null,1858,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(7,'[1]Plata Diaria'!A15:B20,2,FALSE),\"\")","v":"2019-05-11"},null,null,{"$f":"S13-Q14+R14","v":1100}]
["AdiCapif",null,150,null,null,null,null,0,null,"Panaderia",null,"x Dia","Dias x Mes",null,null,{"$f":"IFERROR(VLOOKUP(7,'[1]Plata Diaria'!A22:B27,2,FALSE),\"\")","v":"2019-05-18"},null,null,{"$f":"S14-Q15+R15","v":1100}]
["Perfumina",null,null,null,null,null,null,0,null,null,null,100,{"$f":"COUNT(P12:P16)*2","v":8},null,null,{"$f":"IFERROR(VLOOKUP(7,'[1]Plata Diaria'!A29:B37,2,FALSE),\"\")","v":"2019-05-25"}]
[null,null,0,null,null,null,null,{"$f":"SUM(H5:H16)","v":1900},null,null,null,"Final",{"$f":"L16*M16","v":800}]
["Luz Semana",null,{"$f":"SUM(C5:C17)","v":5671}]
[{"$f":"D8/4","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Otros",null,"$ x Unidad","Dias","$ Mensual"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"([1]Santiago!B65-S22)","v":18},{"$f":"R21*S21","v":0},"Final"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S7","v":4},{"$f":"R22*S22","v":0},{"$f":"SUM(T21:T22)","v":0}]
["Gastos Extras",null,null,"Dia","Entrego","Se Debe",null,"Publicidad"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[1]Santiago!A14","v":"MAYO"}]
[null,null,null,null,null,null,null,"Dia","Costo","Entrego","Saldo",null,"Gasto Final"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C$18+H$17+E$30+K31","v":7571}]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cortes del mes"]
[" ",null,null,null,null,null,null,null,null,null,null,null,"$ Diaria",null,null,{"$f":"[1]Santiago!I3","v":42}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$M$26/[1]Santiago!B65","v":344.13636363636363},null,null,"% de los cortes"]
[null,null,{"$f":"SUM(C24:C29)","v":0},null,{"$f":"SUM(E24:E29)","v":0},{"$f":"SUM(F24:F29)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(M32/P28,\"\")","v":3.7244195198740657E-2}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J26:J30)","v":0},null,"Equivalentes en Cortes"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M29/[1]Santiago!B2","v":1.5642561983471075}]

{"sheet":"Hoja2","index":1,"n_rows":39,"n_cols":21,"rows_kept":39,"cut":false,"hidden":false,"merged":[[33,0,33,1],[34,0,34,1],[35,0,35,1],[36,0,36,1],[37,0,37,1],[29,0,29,1],[29,6,29,7],[30,0,30,1],[30,6,30,7],[31,0,31,1],[32,0,32,1],[26,0,26,1],[26,6,26,7],[27,0,27,1],[27,6,27,7],[28,0,28,1],[28,6,28,7]]}
["Resumen Anual de Impuestos"]
[]
[]
[2018,null,"Diciembre",16465.66,null,748.4,5.4,null,180,39.450000000000003,{"$f":"I4/J4","v":4.5627376425855513},1145,"Impuestos"]
["Año","Laborables","Mes","Gasto final","%","Pesos x Dia","Cortes Diarios","%","Valor Corte","Valor Dólar","$ en Dolares","Cortes mes","Equi. en %",null,null,null,null,"enero",200]
[2019,22,"Enero",19292.63,{"$f":"IFERROR((D6-D4)/(ABS(D4)),\"\")","v":0.17168883603815463},877,4.4000000000000004,{"$f":"IFERROR((G6-G4)/ABS(G4),\"\")","v":-0.18518518518518517},200,38.5,{"$f":"IFERROR(I6/J6,\"\")","v":5.1948051948051948},1044,{"$f":"IFERROR((G6*B6)/L6,\"\")","v":9.272030651340997E-2},null,null,null,null,"febrero",200]
[null,20,"Febrero",15478.15,{"$f":"IFERROR(((D7-D6)/ABS(D6)),\"\")","v":-0.19771695201742848},774,3.9,{"$f":"IFERROR(((G7-G6)/ABS(G6)),\"\")","v":-0.11363636363636373},200,38.5,{"$f":"IFERROR(I7/J7,\"\")","v":5.1948051948051948},927,{"$f":"IFERROR((G7*B7)/L7,\"\")","v":8.4142394822006472E-2},null,null,null,null,"marzo",200]
[null,22,"Marzo",18841.23,{"$f":"IFERROR(((D8-D7)/ABS(D7)),\"\")","v":0.21727919680323554},856,4.3,{"$f":"IFERROR(((G8-G7)/ABS(G7)),\"\")","v":0.10256410256410255},200,44.64,4.4802867383512543,981,9.6432212028542297E-2,null,null,null,null,"abril",200]
[null,22,"Abril",13757.51,-0.26981890248141971,625,3.1,-0.27906976744186041,200,46.3,4.3196544276457889,988,6.9028340080971667E-2,null,null,null,null,"mayo",220]
[null,{"$f":"IF(C10=$D$25,[1]Santiago!$B$65,\"\")","v":22},"Mayo",{"$f":"IF(C10=$D$25,impuestos!M26,\"\")","v":7571},-0.44968239165372226,{"$f":"IF(C10=$D$25,impuestos!M29,\"\")","v":344.13636363636363},{"$f":"IF(C10=$D$25,impuestos!M32,\"\")","v":1.5642561983471075},-0.49540122633964273,{"$f":"IF(C10=$D$25,S9,\"\")","v":220},46.5,4.731182795698925,{"$f":"IF(C10=$D$25,impuestos!P28)","v":42},0.81937229437229442,null,null,null,null,"junio"]
[null,{"$f":"IF(C11=$D$25,[1]Santiago!$B$65,\"\")","v":""},"Junio",{"$f":"IF(C11=$D$25,[1]Imuestos!$M$26,\"\")","v":""},"",{"$f":"IF(C11=$D$25,[1]Imuestos!$M$29,\"\")","v":""},{"$f":"IF(C11=$D$25,[1]Imuestos!$M$32,\"\")","v":""},"",{"$f":"IF(C11=$D$25,IF([1]Santiago!$E$11=\"\",[1]Santiago!$B$2,[1]Santiago!$B$2))","v":false},null,"",{"$f":"IF(C11=$D$25,[1]Santiago!$I$3,\"\")","v":""},"",null,null,null,null,"julio"]
[null,{"$f":"IF(C12=$D$25,[1]Santiago!$B$65,\"\")","v":""},"Julio",{"$f":"IF(C12=$D$25,[1]Imuestos!$M$26,\"\")","v":""},"",{"$f":"IF(C12=$D$25,[1]Imuestos!$M$29,\"\")","v":""},{"$f":"IF(C12=$D$25,[1]Imuestos!$M$32,\"\")","v":""},"",{"$f":"IF(C12=$D$25,IF([1]Santiago!$E$11=\"\",[1]Santiago!$B$2,[1]Santiago!$B$2))","v":false},null,"",{"$f":"IF(C12=$D$25,[1]Santiago!$I$3,\"\")","v":""},"",null,null,null,null,"agosto"]
[null,{"$f":"IF(C13=$D$25,[1]Santiago!$B$65,\"\")","v":""},"Agosto",{"$f":"IF(C13=$D$25,[1]Imuestos!$M$26,\"\")","v":""},"",{"$f":"IF(C13=$D$25,[1]Imuestos!$M$29,\"\")","v":""},{"$f":"IF(C13=$D$25,[1]Imuestos!$M$32,\"\")","v":""},"",{"$f":"IF(C13=$D$25,IF([1]Santiago!$E$11=\"\",[1]Santiago!$B$2,[1]Santiago!$B$2))","v":false},null,"",{"$f":"IF(C13=$D$25,[1]Santiago!$I$3,\"\")","v":""},"",null,null,null,null,"septiembre"]
[null,{"$f":"IF(C14=$D$25,[1]Santiago!$B$65,\"\")","v":""},"Septiembre",{"$f":"IF(C14=$D$25,[1]Imuestos!$M$26,\"\")","v":""},"",{"$f":"IF(C14=$D$25,[1]Imuestos!$M$29,\"\")","v":""},{"$f":"IF(C14=$D$25,[1]Imuestos!$M$32,\"\")","v":""},"",{"$f":"IF(C14=$D$25,IF([1]Santiago!$E$11=\"\",[1]Santiago!$B$2,[1]Santiago!$B$2))","v":false},null,"",{"$f":"IF(C14=$D$25,[1]Santiago!$I$3,\"\")","v":""},"",null,null,null,null,"octubre"]
[null,{"$f":"IF(C15=$D$25,[1]Santiago!$B$65,\"\")","v":""},"Octubre",{"$f":"IF(C15=$D$25,[1]Imuestos!$M$26,\"\")","v":""},"",{"$f":"IF(C15=$D$25,[1]Imuestos!$M$29,\"\")","v":""},{"$f":"IF(C15=$D$25,[1]Imuestos!$M$32,\"\")","v":""},"",{"$f":"IF(C15=$D$25,IF([1]Santiago!$E$11=\"\",[1]Santiago!$B$2,[1]Santiago!$B$2))","v":false},null,"",{"$f":"IF(C15=$D$25,[1]Santiago!$I$3,\"\")","v":""},"",null,null,null,null,"noviembre"]
[null,{"$f":"IF(C16=$D$25,[1]Santiago!$B$65,\"\")","v":""},"Noviembre",{"$f":"IF(C16=$D$25,[1]Imuestos!$M$26,\"\")","v":""},"",{"$f":"IF(C16=$D$25,[1]Imuestos!$M$29,\"\")","v":""},{"$f":"IF(C16=$D$25,[1]Imuestos!$M$32,\"\")","v":""},"",{"$f":"IF(C16=$D$25,IF([1]Santiago!$E$11=\"\",[1]Santiago!$B$2,[1]Santiago!$B$2))","v":false},null,"",{"$f":"IF(C16=$D$25,[1]Santiago!$I$3,\"\")","v":""},"",null,null,null,null,"diciembre"]
[null,{"$f":"IF(C17=$D$25,[1]Santiago!$B$65,\"\")","v":""},"Diciembre",{"$f":"IF(C17=$D$25,[1]Imuestos!$M$26,\"\")","v":""},"",{"$f":"IF(C17=$D$25,[1]Imuestos!$M$29,\"\")","v":""},{"$f":"IF(C17=$D$25,[1]Imuestos!$M$32,\"\")","v":""},"",{"$f":"IF(C17=$D$25,IF([1]Santiago!$E$11=\"\",[1]Santiago!$B$2,[1]Santiago!$B$2))","v":false},null,"",{"$f":"IF(C17=$D$25,[1]Santiago!$I$3,\"\")","v":""},""]
[null,null,"Promedios",{"$f":"SUM(D6:D17)/COUNT(D6:D17)","v":14988.103999999998},null,{"$f":"SUM(F6:F17)/COUNT(F6:F17)","v":695.22727272727275},{"$f":"SUM(G6:G17)/COUNT(G6:G17)","v":3.452851239669422},null,null,null,null,{"$f":"SUM(L6:L17)/COUNT(L6:L17)","v":796.4},{"$f":"SUM(M6:M17)/COUNT(M6:M17)","v":0.23233910956344497}]
[]
[]
["Aumento Precios en Porcentajes"]
[null,null,null,null,null,"se actualixa según mes en curso"]
[]
[]
["Mensuales",null,"ENERO",{"$f":"[1]Imuestos!M24","v":"MAYO"},"% Aumento",null,"No Mensuales",null,"ENERO",{"$f":"[1]Imuestos!M24","v":"MAYO"},"% Aumento",null,"Por Periodos"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Gas",null,null,null,null,"Luz"]
["Cable",null,650,{"$f":"[1]Imuestos!C6","v":965},{"$f":"IF(D27=0,\"\",IFERROR((D27-C27)/ABS(C27),\"\"))","v":0.48461538461538461},null,"Arba Inmobiliario",null,779.5,{"$f":"[1]Imuestos!C9","v":0},{"$f":"IF(J27=0,\"\",IFERROR((J27-I27)/ABS(I27),\"\"))","v":""},null,null,2018,2019,"%",null,null,2018,2019,"%"]
["Telefono",null,29.41,{"$f":"[1]Imuestos!C7","v":0},{"$f":"IF(D28=0,\"\",IFERROR((D28-C28)/ABS(C28),\"\"))","v":""},null,"Gaseosa",null,230,{"$f":"[1]Imuestos!G10","v":200},-0.13043478260869565,null,"Enero",400.36,676.28,{"$f":"IF(O28=0,\"\",IFERROR((O28-N28)/ABS(N28),\"\"))","v":0.68917973823558787},null,"Enero",2041.25,3229.27,{"$f":"IF(T28=0,\"\",IFERROR((T28-S28)/ABS(S28),\"\"))","v":0.58200612369871396}]
["Luz ",null,3229.27,{"$f":"[1]Imuestos!D8","v":0},"",null,"Café",null,186,{"$f":"[1]Imuestos!G6","v":317.61},0.70758064516129038,null,"Febrero",400.21,660.5,0.65038354863696568,null,"Febrero",2211.58,3229.27,0.46016422648061572]
["Tasa inmobiliaria",null,342.44,{"$f":"[1]Imuestos!C10","v":0},"",null,"Caramelos",null,76.13,{"$f":"[1]Imuestos!J9","v":96.79},0.2713779062130568,null,"Marzo",397.59,653,0.6423954324806963,null,"Marzo",3210.05,4923.04,0.53363343250105133]
["Camara Comercial",null,100,{"$f":"[1]Imuestos!C11","v":0},"",null,"Cera 8M",null,350,{"$f":"[1]Imuestos!G12","v":406.55},0.16157142857142862,null,"Abril",402.06,668.42,0.66248818584290892,null,"Abril",3210.05,3541.14,0.10314169561221778]
["Cuota seguro",null,2698,{"$f":"[1]Imuestos!C12","v":2698},0,null,null,null,null,null,null,null,"Mayo",534.9,823.56,0.53965227145260797,null,"Mayo",2958.79,4023.26,0.35976530946772167]
["Diarios",null,990,{"$f":"[1]Imuestos!U7","v":1100},0.1111111111111111,null,null,null,null,null,null,null,"Junio",612.6,1034.0899999999999,0.6880346065948415,null,"Junio",2963.82,4082.14,0.37732385907376281]
["Internet",null,900,{"$f":"[1]Imuestos!C14","v":1858},1.0644444444444445,null,null,null,null,null,null,null,"Julio",811.31,{"$f":"[1]Imuestos!C5","v":0},"",null,"Julio",2245.69,{"$f":"[1]Imuestos!D8","v":0},""]
["AdiCapif",null,150,{"$f":"[1]Imuestos!C15","v":150},0,null,null,null,null,null,null,null,"Agosto",857.94,null,"",null,"Agosto",2250.62,null,""]
["Limpieza",null,300,{"$f":"[1]Imuestos!G8","v":400},0.33333333333333331,null,null,null,null,null,null,null,"Septiembre",844.74,null,"",null,"Septiembre",2156.98,null,""]
["Contador",null,600,{"$f":"[1]Monotributos!C10","v":600},0,null,null,null,null,null,null,null,"Octubre",627.03,null,"",null,"Octubre",2156.98,null,""]
["Panaderia",null,800,{"$f":"[1]Imuestos!M17","v":800},0,null,null,null,null,null,null,null,"Noviembre",795.88,null,"",null,"Noviembre",2558.4699999999998,null,""]
["Lavanderia",null,280,{"$f":"[1]Imuestos!G5","v":400},0.42857142857142855,null,null,null,null,null,null,null,"Diciembre",761.9,null,"",null,"Diciembre",2564.6999999999998,null,""]