{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Tablas","CABECERA","BALANCEGENERAL","ESTADORESULTADOS","EVOLUCIONPATRIMONIO","ESTADOFLUJO","NOTASALOSEEFF","PIE"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":135,"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":"Tablas","index":0,"n_rows":14,"n_cols":16,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["tablas"]
[null,null,null,"sector","valor sector","Dictamen","DDJJ original","ESTADO","VERIFICADOS?",null,"PROFESIONAL DEPENDIENTE","TIENE NOTAS",null,"NUEVOMES","CI","VERSION"]
["Marzo","comercial/serv/bancos/seguros",2012,1,true,"LIMPIO",true,"CABECERA",null,{"$f":"I3","v":0},"DEPENDIENTE",{"$f":"INICIONOTASSI","v":"R"},null,"Enero","LP","25.6.2012.2"]
["Junio","industriales",2011,2,true,"CON SALVEDADES",null,"BGRAL",null,0,"PROFESIONAL INDEPENDIENTE",null,null,"Febrero","OR"]
["Septiembre","agroindustriales",2010,3,true,"ABSTENCION DE OPINION",null,"EERR",null,0,"CONSULTORA",null,null,"Marzo","PT"]
["Diciembre","mineras",2009,4,true,"ADVERSO",null,"EVPAT",null,0,null,null,null,"Abril","CB"]
[null,null,2008,"sector v",null,null,null,"EFLUJ",null,0,null,null,null,"Mayo","CH"]
[null,null,2007,1,null,null,null,"PIE",null,0,null,null,null,"Junio","TA"]
[null,null,2006,null,null,null,null,"NOTAS",null,0,null,null,null,"Julio","SC"]
[null,null,2005,null,null,null,null,null,null,null,null,null,null,"Agosto","BE"]
[null,null,2004,null,null,null,null,null,null,null,null,null,null,"Septiembre","PA"]
[null,null,2003,null,null,null,null,null,null,null,null,null,null,"Octubre","EXT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Noviembre"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Diciembre"]

{"sheet":"CABECERA","index":1,"n_rows":39,"n_cols":20,"rows_kept":39,"cut":false,"hidden":false,"merged":[[32,0,32,2],[32,4,32,17],[31,0,31,18],[1,0,1,18],[5,12,5,18],[3,0,3,18],[4,0,4,18],[2,0,2,18],[23,0,23,18],[26,4,26,17],[27,0,27,18],[20,4,20,9],[24,0,24,2],[26,0,26,2],[18,0,20,2],[24,4,24,17],[39,0,39,18],[7,0,7,18],[18,4,18,9],[9,0,9,2],[11,0,11,2],[13,0,13,2],[16,0,16,2],[10,4,10,18],[9,4,9,17],[11,4,11,17],[13,4,13,17],[25,0,25,18],[12,4,12,18],[14,4,14,18],[36,4,36,17],[38,4,38,8],[22,0,22,18],[18,12,18,14],[20,12,20,14],[30,0,30,2],[30,4,30,8],[30,9,30,11],[28,9,28,11],[28,0,28,2],[28,4,28,8],[28,12,28,14],[28,15,28,16],[38,0,38,2],[33,0,33,18],[34,0,34,2],[36,0,36,2],[38,9,38,11],[38,12,38,17],[35,0,35,18],[34,4,34,17]]}
[]
["IMPUESTOS NACIONALES"]
[" F - 605 VER.3"]
["ESTADOS FINANCIEROS"]
["INFORMACIÓN ANUAL                                                                                                    "]
[]
[]
["A. DATOS DEL CONTRIBUYENTE"]
[]
["        NOMBRE Y APELLIDOS O RAZON SOCIAL",null,null,null,"MI EMPRESA"]
[]
["NIT",null,null,null,100000000000]
[]
["NOMBRE Y APELLIDOS REPRESENTANTE LEGAL",null,null,null,"SLASFASFASFASF"]
[]
[null,null,null,null,"Mes de Cierre",null,"Año"]
["GESTIÓN",null,null,null,"DICIEMBRE",null,"2011",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E17=\"Enero\", 1, IF(E17=\"Febrero\", 2, IF(E17=\"Marzo\", 3, IF(E17=\"Abril\", 4, IF(E17=\"Mayo\", 5, IF(E17=\"Junio\", 6, IF(E17=\"Julio\", 7, IF(E17=\"Agosto\", 8, IF(E17=\"Septiembre\", 9, IF(E17=\"Octubre\", 10, IF(E17=\"Noviembre\", 11, IF(E17=\"Diciembre\", 12, \"\"))))))))))))","v":""}]
[]
["SECTOR ECONÓMICO CONFORME A ARTÍCULO 39 DEL DECRETO SUPREMO 24051",null,null,null,"01 COMERCIAL - FINANCIERO - SERVICIOS - SEGUROS - OTRAS",null,null,null,null,null,"R",null,"02 INDUSTRIAL PETROLERA"]
[]
[null,null,null,null,"03 GOMERA - CASTAÑERAS - AGRÍCOLAS - GANADERA -AGROINDUSTRIAL",null,null,null,null,null,null,null,"04 MINERA"]
[]
["B. DATOS DEL RESPONSABLE DE LA ELABORACIÓN Y AUDITORIA EXTERNA DE LOS ESTADOS FINANCIEROS (según corresponda)"]
["RESPONSABLE DE ELABORACIÓN"]
["NOMBRE Y APELLIDO O  RAZON SOCIAL                       DEL PROFESIONAL INDEPENDIENTE O CONSULTORA"]
[]
["NIT"]
[]
["                             NOMBRE Y APELLIDO DEL PROFESIONAL CONTABLE  DE LA EMPRESA",null,null,null,null,null,null,null,null,"CI",null,null,null,null,null,"EXP"]
[null,null,null,null,"Día /Mes/Año"]
["FECHA DE ELABORACIÓN DE LOS EEFF"]
[]
["NOMBRE SISTEMA CONTABLE"]
["RESPONSABLE DE LA AUDITORIA EXTERNA "]
["NOMBRE Y APELLIDO O RAZON SOCIAL "]
[]
["NIT"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Día /Mes/Año"]
["OPINIÓN DEL DICTAMEN",null,null,null,null,null,null,null,null,"FECHA DEL DICTAMEN"]

{"sheet":"BALANCEGENERAL","index":2,"n_rows":48,"n_cols":5,"rows_kept":48,"cut":false,"hidden":false,"merged":[[8,3,8,4],[47,0,47,1],[6,0,6,4],[7,0,7,4],[0,1,0,3],[2,3,2,4],[3,0,3,4],[4,0,4,4],[5,0,5,4]]}
[]
[{"$f":"CABECERA!E31","v":"00:00:00"},null,null,null,"IMPUESTOS NACIONALES"]
[null,null,null,"   F - 605 VER.3"]
["ESTADOS FINANCIEROS"]
["BALANCE GENERAL"]
["EXPRESADO EN BOLIVIANOS"]
[]
["         DATOS SITUACIÓN ECONÓMICA - FINANCIERA  DE LA EMPRESA"]
["         BALANCE GENERAL","AL"]
["DETALLE CUENTAS DE ACTIVO","CÓDIGO","DEBE ","HABER ","GESTIÓN ACTUAL (SALDO) "]
["ACTIVO CORRIENTE",1100,{"$f":"SUM(C12:C15)","v":0},{"$f":"SUM(D12:D15)","v":0},{"$f":"SUM(E12:E15)","v":0}]
[null,null,null,null,{"$f":"IF(OR(AND(C12=\"\", D12<>\"\"),AND(D12=\"\", C12<>\"\")), \"Llene DEBE y HABER\",C12-D12)","v":0}]
[null,null,null,null,{"$f":"IF(OR(AND(C13=\"\", D13<>\"\"),AND(D13=\"\", C13<>\"\")), \"Llene DEBE y HABER\",C13-D13)","v":0}]
[null,null,null,null,{"$f":"IF(OR(AND(C14=\"\", D14<>\"\"),AND(D14=\"\", C14<>\"\")), \"Llene DEBE y HABER\",C14-D14)","v":0}]
["CELDA PROTEGIDA (POR FAVOR NO BORRE ESTA CELDA)",null,null,null,0]
[]
["ACTIVO NO CORRIENTE",1200,{"$f":"SUM(C18:C21)","v":0},{"$f":"SUM(D18:D21)","v":0},{"$f":"SUM(E18:E21)","v":0}]
["Activo Fijo (Art. 22 y 25 D.S. 24051)",1201,null,null,{"$f":"IF(OR(AND(C18=\"\", D18<>\"\"),AND(D18=\"\", C18<>\"\")), \"Llene DEBE y HABER\",C18-D18)","v":0}]
["Depreciación Acumulada Activo Fijo (Art. 22 y 25 D.S. 24051)",1202,null,null,0]
[null,null,null,null,{"$f":"IF(OR(AND(C20=\"\", D20<>\"\"),AND(D20=\"\", C20<>\"\")), \"Llene DEBE y HABER\",C20-D20)","v":0}]
["CELDA PROTEGIDA (POR FAVOR NO BORRE ESTA CELDA)",null,null,null,0]
[]
["TOTALES CUENTAS DE ACTIVO",1000,{"$f":"SUM(C12:C15)+SUM(C18:C21)","v":0},{"$f":"SUM(D12:D15)+SUM(D18:D21)","v":0},{"$f":"SUM(E12:E15)+SUM(E18:E21)","v":0}]
["DETALLE CUENTAS DE PASIVO ","CÓDIGO","DEBE ","HABER ","GESTIÓN ACTUAL (SALDO) "]
["PASIVO CORRIENTE",2100,{"$f":"SUM(C26:C29)","v":0},{"$f":"SUM(D26:D29)","v":0},{"$f":"SUM(E26:E29)","v":0}]
[null,null,null,null,{"$f":"IF(OR(AND(C26=\"\", D26<>\"\"),AND(D26=\"\", C26<>\"\")), \"Llene DEBE y HABER\",D26-C26)","v":0}]
[null,null,null,null,{"$f":"IF(OR(AND(C27=\"\", D27<>\"\"),AND(D27=\"\", C27<>\"\")), \"Llene DEBE y HABER\",D27-C27)","v":0}]
[null,null,null,null,{"$f":"IF(OR(AND(C28=\"\", D28<>\"\"),AND(D28=\"\", C28<>\"\")), \"Llene DEBE y HABER\",D28-C28)","v":0}]
["CELDA PROTEGIDA (POR FAVOR NO BORRE ESTA CELDA)",null,null,null,0]
[]
["PASIVO NO CORRIENTE",2200,{"$f":"SUM(C32:C35)","v":0},{"$f":"SUM(D32:D35)","v":0},{"$f":"SUM(E32:E35)","v":0}]
[null,null,null,null,{"$f":"IF(OR(AND(C32=\"\", D32<>\"\"),AND(D32=\"\", C32<>\"\")), \"Llene DEBE y HABER\",D32-C32)","v":0}]
[null,null,null,null,0]
[null,null,null,null,{"$f":"IF(OR(AND(C34=\"\", D34<>\"\"),AND(D34=\"\", C34<>\"\")), \"Llene DEBE y HABER\",D34-C34)","v":0}]
["CELDA PROTEGIDA (POR FAVOR NO BORRE ESTA CELDA)",null,null,null,0]
[]
["TOTALES CUENTAS DE PASIVO",2000,{"$f":"SUM(C26:C29)+SUM(C32:C35)","v":0},{"$f":"SUM(D26:D29)+SUM(D32:D35)","v":0},{"$f":"SUM(E26:E29)+SUM(E32:E35)","v":0}]
["DETALLE CUENTAS DE PATRIMONIO","CÓDIGO","DEBE ","HABER ","GESTIÓN ACTUAL (SALDO) "]
[null,null,null,null,{"$f":"IF(OR(AND(C39=\"\", D39<>\"\"),AND(D39=\"\", C39<>\"\")), \"Llene DEBE y HABER\",D39-C39)","v":0}]
[null,null,null,null,0]
[null,null,null,null,{"$f":"IF(OR(AND(C41=\"\", D41<>\"\"),AND(D41=\"\", C41<>\"\")), \"Llene DEBE y HABER\",D41-C41)","v":0}]
["CELDA PROTEGIDA (POR FAVOR NO BORRE ESTA CELDA)",null,null,null,0]
[]
["TOTALES CUENTAS DE PATRIMONIO",3000,{"$f":"SUM(C39:C42)","v":0},{"$f":"SUM(D39:D42)","v":0},{"$f":"SUM(E39:E42)","v":0}]
["TOTAL ACTIVO  ",1000,null,null,{"$f":"E23","v":0}]
["TOTAL PASIVO ",2000,null,null,{"$f":"E37","v":0}]
["TOTAL PATRIMONIO",3000,null,null,{"$f":"E44","v":0}]
["TOTAL PASIVO Y PATRIMONIO",null,null,null,{"$f":"SUM(E46:E47)","v":0}]

{"sheet":"ESTADORESULTADOS","index":3,"n_rows":65,"n_cols":5,"rows_kept":65,"cut":false,"hidden":false,"merged":[[0,1,0,3],[66,0,66,4],[65,0,65,4],[7,0,7,4],[2,3,2,4],[6,0,6,4],[3,0,3,4],[4,0,4,4],[5,0,5,4]]}
[]
[null,null,null,null,"IMPUESTOS NACIONALES"]
[null,null,null,"   F - 605 VER.3"]
["ESTADOS FINANCIEROS"]
["ESTADOS DE RESULTADOS          \n(PÉRDIDAS Y GANANCIAS)"]
["EXPRESADO EN BOLIVIANOS"]
[]
["         DATOS DE RESULTADOS DEL ENTE"]
["         ESTADO DE RESULTADOS","DEL",null,"AL",{"$f":"IF(BALANCEGENERAL!D9=\"\",\"Llene la fecha en el BALANCE GENERAL\",BALANCEGENERAL!D9)","v":"Llene la fecha en el BALANCE GENERAL"}]
["DETALLE DE CUENTAS","CÓDIGO","DEBE","HABER","GESTIÓN ACTUAL (SALDO) "]
["INGRESOS",4100,{"$f":"SUM(C12:C15)","v":0},{"$f":"SUM(D12:D15)","v":0},{"$f":"SUM(E12:E15)","v":0}]
[null,null,null,null,{"$f":"IF(OR(AND(C12=\"\", D12<>\"\"),AND(D12=\"\", C12<>\"\")), \"Llene DEBE y HABER\",D12-C12)","v":0}]
[null,null,null,null,{"$f":"IF(OR(AND(C13=\"\", D13<>\"\"),AND(D13=\"\", C13<>\"\")), \"Llene DEBE y HABER\",D13-C13)","v":0}]
[null,null,null,null,{"$f":"IF(OR(AND(C14=\"\", D14<>\"\"),AND(D14=\"\", C14<>\"\")), \"Llene DEBE y HABER\",D14-C14)","v":0}]
["CELDA PROTEGIDA (POR FAVOR NO BORRE ESTA CELDA)",null,null,null,{"$f":"IF(OR(AND(C15=\"\", D15<>\"\"),AND(D15=\"\", C15<>\"\")), \"Llene DEBE y HABER\",D15-C15)","v":0}]
[]
["COSTO DE VENTAS",5100,{"$f":"SUM(C18:C21)","v":0},{"$f":"SUM(D18:D21)","v":0},{"$f":"SUM(E18:E21)","v":0}]
[null,null,null,null,{"$f":"IF(OR(AND(C18=\"\", D18<>\"\"),AND(D18=\"\", C18<>\"\")), \"Llene DEBE y HABER\",C18-D18)","v":0}]
[null,null,null,null,{"$f":"IF(OR(AND(C19=\"\", D19<>\"\"),AND(D19=\"\", C19<>\"\")), \"Llene DEBE y HABER\",C19-D19)","v":0}]
[null,null,null,null,{"$f":"IF(OR(AND(C20=\"\", D20<>\"\"),AND(D20=\"\", C20<>\"\")), \"Llene DEBE y HABER\",C20-D20)","v":0}]
["CELDA PROTEGIDA (POR FAVOR NO BORRE ESTA CELDA)",null,null,null,0]
[]
["UTILIDAD O PÉRDIDA BRUTA",5600,{"$f":"C11-C17","v":0},{"$f":"D11-D17","v":0},{"$f":"E11-E17","v":0}]
["DETALLE DE CUENTAS","CÓDIGO","DEBE","HABER","GESTIÓN ACTUAL (SALDO) "]
["GASTOS",5200,{"$f":"SUM(C26:C31)","v":0},{"$f":"SUM(D26:D31)","v":0},{"$f":"SUM(E26:E31)","v":0}]
["Diferencias de Cambio (Art. 16 D.S. 24051)",5201,null,null,{"$f":"IF(OR(AND(C26=\"\", D26<>\"\"),AND(D26=\"\", C26<>\"\")), \"Llene DEBE y HABER\",C26-D26)","v":0}]
["Previsiones (Art. 17 D.S. 24051)",5202,null,null,0]
["Provisiones (Art. 17 D.S. 24051)",5203,null,null,0]
["Baja de Activos (Art. 30 D.S. 24051)",5204,null,null,0]
[null,null,null,null,{"$f":"IF(OR(AND(C30=\"\", D30<>\"\"),AND(D30=\"\", C30<>\"\")), \"Llene DEBE y HABER\",C30-D30)","v":0}]
["CELDA PROTEGIDA (POR FAVOR NO BORRE ESTA CELDA)",null,null,null,0]
[]
["UTILIDAD O PÉRDIDA OPERATIVA",5700,{"$f":"C23-C25","v":0},{"$f":"D23-D25","v":0},{"$f":"E23-E25","v":0}]
["DETALLE DE CUENTAS","CÓDIGO","DEBE","HABER","GESTIÓN ACTUAL (SALDO) "]
["OTROS INGRESOS",4200,{"$f":"SUM(C36:C39)","v":0},{"$f":"SUM(D36:D39)","v":0},{"$f":"SUM(E36:E39)","v":0}]
["Ajuste por Inflación y Tenencia de Bienes",4201,null,null,{"$f":"IF(OR(AND(C36=\"\", D36<>\"\"),AND(D36=\"\", C36<>\"\")), \"Llene DEBE y HABER\",D36-C36)","v":0}]
[null,null,null,null,{"$f":"IF(OR(AND(C37=\"\", D37<>\"\"),AND(D37=\"\", C37<>\"\")), \"Llene DEBE y HABER\",D37-C37)","v":0}]
[null,null,null,null,{"$f":"IF(OR(AND(C38=\"\", D38<>\"\"),AND(D38=\"\", C38<>\"\")), \"Llene DEBE y HABER\",D38-C38)","v":0}]
["CELDA PROTEGIDA (POR FAVOR NO BORRE ESTA CELDA)",null,null,null,0]
[]
["OTROS GASTOS",5300,{"$f":"SUM(C42:C45)","v":0},{"$f":"SUM(D42:D45)","v":0},{"$f":"SUM(E42:E45)","v":0}]
["Ajuste por inflación y Tenencia de Bienes",5301,null,null,{"$f":"IF(OR(AND(C42=\"\", D42<>\"\"),AND(D42=\"\", C42<>\"\")), \"Llene DEBE y HABER\",C42-D42)","v":0}]
[null,null,null,null,0]
[null,null,null,null,0]
["CELDA PROTEGIDA (POR FAVOR NO BORRE ESTA CELDA)",null,null,null,0]
[]
["INGRESOS FINANCIEROS",4300,{"$f":"SUM(C48:C51)","v":0},{"$f":"SUM(D48:D51)","v":0},{"$f":"SUM(E48:E51)","v":0}]
[null,null,null,null,{"$f":"IF(OR(AND(C48=\"\", D48<>\"\"),AND(D48=\"\", C48<>\"\")), \"Llene DEBE y HABER\",D48-C48)","v":0}]
[null,null,null,null,{"$f":"IF(OR(AND(C49=\"\", D49<>\"\"),AND(D49=\"\", C49<>\"\")), \"Llene DEBE y HABER\",D49-C49)","v":0}]
[null,null,null,null,0]
["CELDA PROTEGIDA (POR FAVOR NO BORRE ESTA CELDA)",null,null,null,0]
[]
["GASTOS FINANCIEROS",5400,{"$f":"SUM(C54:C57)","v":0},{"$f":"SUM(D54:D57)","v":0},{"$f":"SUM(E54:E57)","v":0}]
[null,null,null,null,{"$f":"IF(OR(AND(C54=\"\", D54<>\"\"),AND(D54=\"\", C54<>\"\")), \"Llene DEBE y HABER\",C54-D54)","v":0}]
[null,null,null,null,0]
[null,null,null,null,0]
["CELDA PROTEGIDA (POR FAVOR NO BORRE ESTA CELDA)",null,null,null,0]
[]
["UTILIDAD O PÉRDIDA ANTES DE IMPUESTOS",5800,{"$f":"C33+C35-C41+C47-C53","v":0},{"$f":"D33+D35-D41+D47-D53","v":0},{"$f":"E33+E35-E41+E47-E53","v":0}]
["DETALLE DE CUENTAS","CÓDIGO","DEBE","HABER","GESTIÓN ACTUAL (SALDO) "]
["IMPUESTO SOBRE LAS UTILIDADES",5500,{"$f":"SUM(C62:C62)","v":0},{"$f":"SUM(D62:D62)","v":0},{"$f":"SUM(E62:E62)","v":0}]
["Impuesto sobre las Utilidades de las Empresas",5501,null,null,{"$f":"IF(OR(AND(C62=\"\", D62<>\"\"),AND(D62=\"\", C62<>\"\")), \"Llene DEBE y HABER\",C62-D62)","v":0}]
["UTILIDAD O PÉRDIDA DESPUÉS DE IMPUESTOS",5900,{"$f":"C59-C61","v":0},{"$f":"D59-D61","v":0},{"$f":"E59-E61","v":0}]
["UTILIDAD DE LA GESTIÓN",5000,null,null,{"$f":"IF(E63>=0, E63, 0)","v":0}]
["PÉRDIDA DE LA GESTIÓN",4000,null,null,{"$f":"IF(E63<0, -E63, 0)","v":0}]

{"sheet":"EVOLUCIONPATRIMONIO","index":4,"n_rows":57,"n_cols":5,"rows_kept":57,"cut":false,"hidden":false,"merged":[[0,1,0,3],[7,0,7,4],[2,3,2,4],[6,0,6,4],[3,0,3,4],[4,0,4,4],[5,0,5,4]]}
[]
[null,null,null,null,"IMPUESTOS NACIONALES"]
[null,null,null,"   F - 605 VER.3"]
["ESTADOS FINANCIEROS"]
["ESTADOS DE RESULTADOS ACUMULADOS         \n(ESTADO DE EVOLUCIÓN DEL PATRIMONIO)"]
["EXPRESADO EN BOLIVIANOS"]
[]
["         DATOS COMPORTAMIENTO DEL PATRIMONIO DEL ENTE"]
["         ESTADO DE EVOLUCION DEL PATRIMONIO","DEL",{"$f":"IF(ESTADORESULTADOS!C9=\"\",\"Llene la fecha en el ESTADO DE RESULTADOS\",ESTADORESULTADOS!C9)","v":"Llene la fecha en el ESTADO DE RESULTADOS"},"AL",{"$f":"IF(BALANCEGENERAL!D9=\"\",\"Llene la fecha en el BALANCE GENERAL\",BALANCEGENERAL!D9)","v":"Llene la fecha en el BALANCE GENERAL"}]
["CUENTAS DE CAPITAL","CÓDIGO","DEBE","HABER","GESTIÓN ACTUAL (SALDO) "]
[null,null,null,null,{"$f":"IF(OR(AND(C11=\"\", D11<>\"\"),AND(D11=\"\", C11<>\"\")), \"Llene DEBE y HABER\",D11-C11)","v":0}]
[null,null,null,null,{"$f":"IF(OR(AND(C12=\"\", D12<>\"\"),AND(D12=\"\", C12<>\"\")), \"Llene DEBE y HABER\",D12-C12)","v":0}]
[null,null,null,null,{"$f":"IF(OR(AND(C13=\"\", D13<>\"\"),AND(D13=\"\", C13<>\"\")), \"Llene DEBE y HABER\",D13-C13)","v":0}]
["CELDA PROTEGIDA (POR FAVOR NO BORRE ESTA CELDA)",null,null,null,0]
[]
["TOTALES CUENTAS DE CAPITAL",3101,{"$f":"SUM(C11:C14)","v":0},{"$f":"SUM(D11:D14)","v":0},{"$f":"SUM(E11:E14)","v":0}]
["ACTUALIZACIÓN VALOR CUENTAS DE CAPITAL","CÓDIGO","DEBE","HABER","GESTIÓN ACTUAL (SALDO) "]
[null,null,null,null,{"$f":"IF(OR(AND(C18=\"\", D18<>\"\"),AND(D18=\"\", C18<>\"\")), \"Llene DEBE y HABER\",D18-C18)","v":0}]
[null,null,null,null,0]
[null,null,null,null,0]
["CELDA PROTEGIDA (POR FAVOR NO BORRE ESTA CELDA)",null,null,null,0]
[]
["TOTALES ACTUALIZACIÓN VALOR CUENTAS DE CAPITAL",3102,{"$f":"SUM(C18:C21)","v":0},{"$f":"SUM(D18:D21)","v":0},{"$f":"SUM(E18:E21)","v":0}]
["CUENTAS RESERVAS","CÓDIGO","DEBE","HABER","GESTIÓN ACTUAL (SALDO) "]
[null,null,null,null,{"$f":"IF(OR(AND(C25=\"\", D25<>\"\"),AND(D25=\"\", C25<>\"\")), \"Llene DEBE y HABER\",D25-C25)","v":0}]
[null,null,null,null,0]
[null,null,null,null,0]
["CELDA PROTEGIDA (POR FAVOR NO BORRE ESTA CELDA)",null,null,null,0]
[]
["TOTALES CUENTAS RESERVAS",3201,{"$f":"SUM(C25:C28)","v":0},{"$f":"SUM(D25:D28)","v":0},{"$f":"SUM(E25:E28)","v":0}]
["ACTUALIZACIÓN VALOR CUENTAS DE RESERVA","CÓDIGO","DEBE","HABER","GESTIÓN ACTUAL (SALDO) "]
[null,null,null,null,{"$f":"IF(OR(AND(C32=\"\", D32<>\"\"),AND(D32=\"\", C32<>\"\")), \"Llene DEBE y HABER\",D32-C32)","v":0}]
[null,null,null,null,0]
[null,null,null,null,0]
["CELDA PROTEGIDA (POR FAVOR NO BORRE ESTA CELDA)",null,null,null,0]
[]
["TOTALES ACTUALIZACIÓN VALOR CUENTAS DE RESERVA",3202,{"$f":"SUM(C32:C35)","v":0},{"$f":"SUM(D32:D35)","v":0},{"$f":"SUM(E32:E35)","v":0}]
["CUENTAS  DE RESULTADO","CÓDIGO","DEBE","HABER","GESTIÓN ACTUAL (SALDO) "]
[null,null,null,null,{"$f":"IF(OR(AND(C39=\"\", D39<>\"\"),AND(D39=\"\", C39<>\"\")), \"Llene DEBE y HABER\",D39-C39)","v":0}]
[null,null,null,null,0]
[null,null,null,null,0]
["CELDA PROTEGIDA (POR FAVOR NO BORRE ESTA CELDA)",null,null,null,0]
[]
["TOTALES CUENTAS  DE RESULTADO",3301,{"$f":"SUM(C39:C42)","v":0},{"$f":"SUM(D39:D42)","v":0},{"$f":"SUM(E39:E42)","v":0}]
["ACTUALIZACIÓN VALOR CUENTAS DE RESULTADO","CÓDIGO","DEBE","HABER","GESTIÓN ACTUAL (SALDO) "]
[null,null,null,null,{"$f":"IF(OR(AND(C46=\"\", D46<>\"\"),AND(D46=\"\", C46<>\"\")), \"Llene DEBE y HABER\",D46-C46)","v":0}]
[null,null,null,null,0]
[null,null,null,null,0]
["CELDA PROTEGIDA (POR FAVOR NO BORRE ESTA CELDA)",null,null,null,0]
[]
["TOTALES ACTUALIZACIÓN VALOR CUENTAS DE RESULTADO",3302,{"$f":"SUM(C46:C49)","v":0},{"$f":"SUM(D46:D49)","v":0},{"$f":"SUM(E46:E49)","v":0}]
["TOTAL CUENTAS DE CAPITAL",3100,null,null,{"$f":"E16+E23","v":0}]
["TOTAL CUENTAS DE RESERVAS",3200,null,null,{"$f":"E30+E37","v":0}]
["TOTAL CUENTAS DE RESULTADO",3300,null,null,{"$f":"E44+E51","v":0}]
["PATRIMONIO AL FINAL DE LA GESTIÓN",3400,null,null,{"$f":"SUM(E52:E54)","v":0}]
["PATRIMONIO AL INICIO DE LA GESTIÓN",3500]
["DIFERENCIA EN PATRIMONIO",3600,null,null,{"$f":"E55-E56","v":0}]

{"sheet":"ESTADOFLUJO","index":5,"n_rows":36,"n_cols":5,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,1,0,3],[7,0,7,4],[2,3,2,4],[6,0,6,4],[3,0,3,4],[4,0,4,4],[5,0,5,4]]}
[]
[null,null,null,null,"IMPUESTOS NACIONALES"]
[null,null,null,"   F - 605 VER.3"]
["ESTADOS FINANCIEROS"]
["ESTADOS DE CAMBIOS DE LA SITUACIÓN FINANCIERA                      \n(ESTADO DE FLUJO DE EFECTIVO)"]
["EXPRESADO EN BOLIVIANOS                                                                                           "]
[]
["         DATOS COMPORTAMIENTO DEL EFECTIVO DEL ENTE"]
["            ESTADO DE FLUJO DE EFECTIVO","DEL",{"$f":"IF(ESTADORESULTADOS!C9=\"\",\"Llene la fecha en el ESTADO DE RESULTADOS\",ESTADORESULTADOS!C9)","v":"Llene la fecha en el ESTADO DE RESULTADOS"},"AL",{"$f":"IF(BALANCEGENERAL!D9=\"\",\"Llene la fecha en el BALANCE GENERAL\",BALANCEGENERAL!D9)","v":"Llene la fecha en el BALANCE GENERAL"}]
["FLUJO DE EFECTIVO GENERADO POR ACTIVIDADES OPERATIVAS","CÓDIGO","GESTIÓN ANTERIOR","GESTIÓN ACTUAL","VARIACIÓN"]
[]
[]
[]
["CELDA PROTEGIDA (POR FAVOR NO BORRE ESTA CELDA)"]
[]
["TOTALES FLUJO DE EFECTIVO GENERADO POR ACTIVIDADES OPERATIVAS",1101,{"$f":"SUM(C11:C14)","v":0},{"$f":"SUM(D11:D14)","v":0},{"$f":"SUM(E11:E14)","v":0}]
["FLUJO DE EFECTIVO GENERADO POR INVERSIÓN","CÓDIGO","GESTIÓN ANTERIOR","GESTIÓN ACTUAL","VARIACIÓN"]
[]
[]
[]
["CELDA PROTEGIDA (POR FAVOR NO BORRE ESTA CELDA)"]
[]
["TOTALES FLUJO DE EFECTIVO GENERADO POR INVERSIÓN",1102,{"$f":"SUM(C18:C21)","v":0},{"$f":"SUM(D18:D21)","v":0},{"$f":"SUM(E18:E21)","v":0}]
["FLUJO DE EFECTIVO GENERADO POR FINANCIAMIENTO","CÓDIGO","GESTIÓN ANTERIOR ","GESTIÓN ACTUAL","VARIACIÓN"]
[]
[]
[]
["CELDA PROTEGIDA (POR FAVOR NO BORRE ESTA CELDA)"]
[]
["TOTALES FLUJO DE EFECTIVO GENERADO POR FINANCIAMIENTO",1103,{"$f":"SUM(C25:C28)","v":0},{"$f":"SUM(D25:D28)","v":0},{"$f":"SUM(E25:E28)","v":0}]
["TOTAL EFECTIVO POR OPERACIONES",1101,null,null,{"$f":"E16","v":0}]
["TOTAL EFECTIVO POR INVERSIÓN",1102,null,null,{"$f":"E23","v":0}]
["TOTAL EFECTIVO POR FINANCIAMIENTO",1103,null,null,{"$f":"E30","v":0}]
["DIFERENCIA EFECTIVO GENERADA EN LA GESTIÓN",1104,null,null,{"$f":"SUM(E31:E33)","v":0}]
["SALDO INICIAL EFECTIVO",1105]
["EFECTIVO AL FINAL DE LA GESTIÓN",1106,null,null,{"$f":"E34+E35","v":0}]

{"sheet":"NOTASALOSEEFF","index":6,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[9,4,9,18],[10,2,10,15],[1,0,1,18],[2,0,2,18],[3,0,3,18],[4,0,4,18],[5,12,5,18],[7,0,7,18]]}
[]
["IMPUESTOS NACIONALES"]
["ESTADOS FINANCIEROS"]
["INFORMACIÓN ANUAL                                                                                                    "]
[" FORM - 605 VER.3"]
[]
[]
["NOTAS A LOS ESTADOS FINANCIEROS:"]
[]
[]
[null,"R","Declaro presentar Notas a los Estados Financieros por la Oficina Virtual de conformidad al Artículo 36° del D.S. 24051."]

{"sheet":"PIE","index":7,"n_rows":16,"n_cols":16,"rows_kept":16,"cut":false,"hidden":false,"merged":[[16,1,16,2],[10,13,10,15],[10,1,10,3],[13,1,13,3],[10,5,10,7],[10,9,10,11],[17,4,17,18],[18,4,18,18],[13,5,13,7],[13,9,13,11],[13,13,13,15],[16,5,16,6],[16,9,16,10],[16,13,16,14],[7,0,7,18],[1,0,1,18],[2,0,2,18],[3,0,3,18],[4,0,4,18],[5,12,5,18]]}
[]
["IMPUESTOS NACIONALES"]
["ESTADOS FINANCIEROS"]
["INFORMACIÓN ANUAL                                                                                                    "]
[" FORM - 605 VER.3"]
[]
[]
["FIRMADO POR:"]
[]
[null,"NOMBRE",null,null,null,"NOMBRE",null,null,null,"NOMBRE",null,null,null,"NOMBRE"]
[]
[]
[null,"CARGO",null,null,null,"CARGO",null,null,null,"CARGO",null,null,null,"CARGO"]
[]
[]
[null,"C.I.",null,"EXP",null,"C.I.",null,"EXP",null,"C.I.",null,"EXP",null,"C.I.",null,"EXP"]