{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Inicio","CLASIFICACIÓN","BALANCE CLASIFICADO","EE.RR"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":"Inicio","index":0,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,"PARA COMENZAR A TRABAJAR HABILITE LAS MACROS"]

{"sheet":"CLASIFICACIÓN","index":1,"n_rows":23,"n_cols":26,"rows_kept":23,"cut":false,"hidden":true,"merged":[[19,5,20,7]]}
[null,null,"NIVEL:","PRINCIPIANTE"]
[]
[null,null,"CUENTA","MONTO $","CLASIFICACIÓN","CUENTA","MONTO$","CLASIFICACIÓN"]
[{"$f":"IF(E4=$Z$10,\"CORRECTO\",IF(OR(E4=$Z$5,E4=$Z$6,E4=$Z$7,E4=$Z$8,E4=$Z$9,E4=$Z$11),\"incorrecto\",\"\"))","v":""},null,"Arriendo maquinarias",24,null,"Letras por Cobrar",60,null,{"$f":"IF((H4=$Z$5),\"CORRECTO\",IF(OR(H4=$Z$6,H4=$Z$7,H4=$Z$8,H4=$Z$9,H4=$Z$10,H4=$Z$11),\"incorrecto\",\"\"))","v":""}]
[{"$f":"IF(E5=$Z$5,\"CORRECTO\",IF(OR(E5=$Z$10,E5=$Z$6,E5=$Z$7,E5=$Z$8,E5=$Z$9,E5=$Z$11),\"incorrecto\",\"\"))","v":""},null,"Banco Estado",200,null,"Leyes Sociales",44,null,{"$f":"IF((H5=$Z$10),\"CORRECTO\",IF(OR(H5=$Z$5,H5=$Z$6,H5=$Z$7,H5=$Z$8,H5=$Z$9,H5=$Z$11),\"incorrecto\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Activo corriente"]
[{"$f":"IF(E6=$Z$9,\"CORRECTO\",IF(OR(E6=$Z$10,E6=$Z$6,E6=$Z$7,E6=$Z$5,E6=$Z$8,E6=$Z$11),\"incorrecto\",\"\"))","v":""},null,"Capital",334,null,"Mercadería",420,null,{"$f":"IF((H6=$Z$5),\"CORRECTO\",IF(OR(H6=$Z$6,H6=$Z$7,H6=$Z$8,H6=$Z$9,H6=$Z$10,H6=$Z$11),\"incorrecto\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Activo No corriente"]
[{"$f":"IF(E7=$Z$10,\"CORRECTO\",IF(OR(E7=$Z$5,E7=$Z$6,E7=$Z$7,E7=$Z$8,E7=$Z$9,E7=$Z$11),\"incorrecto\",\"\"))","v":""},null,"Costo de Ventas",1560,null,"Muebles y Equipos",30,null,{"$f":"IF((H7=$Z$6),\"CORRECTO\",IF(OR(H7=$Z$5,H7=$Z$7,H7=$Z$8,H7=$Z$9,H7=$Z$10,H7=$Z$11),\"incorrecto\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pasivo Corriente"]
[{"$f":"IF(E8=$Z$7,\"CORRECTO\",IF(OR(E8=$Z$10,E8=$Z$6,E8=$Z$9,E8=$Z$5,E8=$Z$8,E8=$Z$11),\"incorrecto\",\"\"))","v":""},null,"Depreciación Acumulada Edificio",20,null,"PPM",50,null,{"$f":"IF((H8=$Z$5),\"CORRECTO\",IF(OR(H8=$Z$6,H8=$Z$7,H8=$Z$8,H8=$Z$9,H8=$Z$10,H8=$Z$11),\"incorrecto\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pasivo No Corriente"]
[{"$f":"IF(E9=$Z$7,\"CORRECTO\",IF(OR(E9=$Z$10,E9=$Z$6,E9=$Z$9,E9=$Z$5,E9=$Z$8,E9=$Z$11),\"incorrecto\",\"\"))","v":""},null,"Depreciación Acumulada Muebles y Útiles",10,null,"Préstamo Hipotecario",300,null,{"$f":"IF((H9=$Z$8),\"CORRECTO\",IF(OR(H9=$Z$5,H9=$Z$6,H9=$Z$7,H9=$Z$9,H9=$Z$10,H9=$Z$11),\"incorrecto\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Patrimonio"]
[{"$f":"IF(E10=$Z$5,\"CORRECTO\",IF(OR(E10=$Z$10,E10=$Z$6,E10=$Z$7,E10=$Z$8,E10=$Z$9,E10=$Z$11),\"incorrecto\",\"\"))","v":""},null,"Deudores por Venta",320,null,"Proveedores",246,null,{"$f":"IF((H10=$Z$7),\"CORRECTO\",IF(OR(H10=$Z$5,H10=$Z$6,H10=$Z$8,H10=$Z$9,H10=$Z$10,H10=$Z$11),\"incorrecto\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Resultado Pérdida"]
[{"$f":"IF(E11=$Z$6,\"CORRECTO\",IF(OR(E11=$Z$10,E11=$Z$5,E11=$Z$7,E11=$Z$8,E11=$Z$9,E11=$Z$11),\"incorrecto\",\"\"))","v":""},null,"Edificios ",200,null,"Remuneraciones",378,null,{"$f":"IF((H11=$Z$10),\"CORRECTO\",IF(OR(H11=$Z$5,H11=$Z$6,H11=$Z$7,H11=$Z$8,H11=$Z$9,H11=$Z$11),\"incorrecto\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Resultado Ganancia"]
[{"$f":"IF(E12=$Z$7,\"CORRECTO\",IF(OR(E12=$Z$10,E12=$Z$6,E12=$Z$9,E12=$Z$5,E12=$Z$8,E12=$Z$11),\"incorrecto\",\"\"))","v":""},null,"Impuesto Único",24,null,"Reserva Rev. Capital Propio",24,null,{"$f":"IF((H12=$Z$9),\"CORRECTO\",IF(OR(H12=$Z$5,H12=$Z$6,H12=$Z$7,H12=$Z$8,H12=$Z$10,H12=$Z$11),\"incorrecto\",\"\"))","v":""}]
[{"$f":"IF(E13=$Z$7,\"CORRECTO\",IF(OR(E13=$Z$10,E13=$Z$6,E13=$Z$9,E13=$Z$5,E13=$Z$8,E13=$Z$11),\"incorrecto\",\"\"))","v":""},null,"Instituciones de Previsión",176,null,"Terreno",250,null,{"$f":"IF((H13=$Z$6),\"CORRECTO\",IF(OR(H13=$Z$5,H13=$Z$7,H13=$Z$8,H13=$Z$9,H13=$Z$10,H13=$Z$11),\"incorrecto\",\"\"))","v":""}]
[{"$f":"IF(E14=$Z$6,\"CORRECTO\",IF(OR(E14=$Z$10,E14=$Z$5,E14=$Z$7,E14=$Z$8,E14=$Z$9,E14=$Z$11),\"incorrecto\",\"\"))","v":""},null,"Inversiones Permanentes",56,null,"Utilidad por Venta de Acciones",10,null,{"$f":"IF((H14=$Z$11),\"CORRECTO\",IF(OR(H14=$Z$5,H14=$Z$6,H14=$Z$7,H14=$Z$8,H14=$Z$9,H14=$Z$10),\"incorrecto\",\"\"))","v":""}]
[{"$f":"IF(E15=$Z$5,\"CORRECTO\",IF(OR(E15=$Z$10,E15=$Z$6,E15=$Z$7,E15=$Z$8,E15=$Z$9,E15=$Z$11),\"incorrecto\",\"\"))","v":""},null,"IVA Crédito F.",98,null,"Ventas",2420,null,{"$f":"IF((H15=$Z$11),\"CORRECTO\",IF(OR(H15=$Z$5,H15=$Z$6,H15=$Z$7,H15=$Z$8,H15=$Z$9,H15=$Z$10),\"incorrecto\",\"\"))","v":""}]
[{"$f":"IF(E16=$Z$7,\"CORRECTO\",IF(OR(E16=$Z$10,E16=$Z$6,E16=$Z$9,E16=$Z$5,E16=$Z$8,E16=$Z$11),\"incorrecto\",\"\"))","v":""},null,"IVA Débito Fiscal",126,null,"Impuesto a la renta",null,null,{"$f":"IF((H16=$Z$10),\"CORRECTO\",IF(OR(H16=$Z$5,H16=$Z$6,H16=$Z$7,H16=$Z$8,H16=$Z$9,H16=$Z$11),\"incorrecto\",\"\"))","v":""}]
[{"$f":"IF(E17=$Z$7,\"CORRECTO\",IF(OR(E17=$Z$10,E17=$Z$6,E17=$Z$9,E17=$Z$5,E17=$Z$8,E17=$Z$11),\"incorrecto\",\"\"))","v":""},null,"Provisión impuesto a la renta",106,null,"Utilidad del ejercicio",null,null,{"$f":"IF((H17=$Z$9),\"CORRECTO\",IF(OR(H17=$Z$5,H17=$Z$6,H17=$Z$7,H17=$Z$8,H17=$Z$10,H17=$Z$11),\"incorrecto\",\"\"))","v":""}]
[]
[]
[{"$f":"COUNTIF(A4:A17,\"Correcto\")","v":0},null,null,"CORRECTAS",{"$f":"A20+A22","v":0},{"$f":"IF(E20+E21=28,\"AHORA VE A LA HOJA BALANCE CLASIFICADO\",\"\")","v":""}]
[{"$f":"COUNTIF(A4:A17,\"INCORRECTO\")","v":0},null,null,"INCORRECTAS ",{"$f":"A21+A23","v":0}]
[{"$f":"COUNTIF(I4:I17,\"CORRECTO\")","v":0}]
[{"$f":"COUNTIF(I4:I17,\"INCORRECTO\")","v":0}]

{"sheet":"BALANCE CLASIFICADO","index":2,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":true,"merged":[[3,4,3,5],[3,1,3,2]]}
[]
[null,"ESTADO DE SITUACIÓN FINANCIERA CLASIFICADO"]
[]
[null,"ACTIVOS ",null,null,"PASIVOS"]
[null,"ACTIVOS CORRIENTES",null,null,"PASIVOS CORRIENTES"]
[]
[]
[]
[]
[]
[]
[null,"TOTAL ACTIVOS CORRIENTES",{"$f":"SUM(C6:C11)","v":0}]
[null,"ACTIVOS NO CORRIENTES",null,null,"TOTAL PASIVOS CORRIENTES ",{"$f":"SUM(F6:F12)","v":0}]
[null,null,null,null,"PASIVOS NO CORRIENTES"]
[]
[null,null,null,null,"TOTAL PASIVOS NO CORRIENTES",{"$f":"SUM(F15)","v":0}]
[null,null,null,null,"PATRIMONIO"]
[null,"TOTAL ACTIVOS NO CORRIENTES",{"$f":"SUM(C14:C17)","v":0}]
[null,"TOTAL ACTIVOS",{"$f":"C12+C18","v":0}]
[]
[null,null,null,null,"TOTAL PATRIMONIO",{"$f":"SUM(F18:F20)","v":0}]
[null,null,null,null,"TOTAL PASIVOS ",{"$f":"F13+F16+F21","v":0}]

{"sheet":"EE.RR","index":3,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":true,"merged":[[4,1,4,2],[5,1,5,2],[7,1,7,2],[8,1,8,2]]}
[]
[]
[null,"ESTADO DE RESULTADOS "]
[]
[]
[]
[null,"MARGEN BRUTO "]
[]
[]
[null,"RESULTADO ANTES DE IMPUESTOS "]
[null,"IMPUESTO RENTA"]
[null,"RESULTADO DEL EJERCICIO"]