{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Plan de Accion PDD"],"not_rendered":{"images":2,"external_links":10,"defined_names":28,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Plan de Accion PDD","index":0,"n_rows":195,"n_cols":20,"rows_kept":195,"merged":[[0,3,3,12],[4,3,5,10],[4,11,5,12],[7,4,7,6],[8,4,8,6],[9,4,9,6],[9,11,9,12],[9,13,9,14],[9,15,9,16],[9,17,9,18],[9,19,9,20],[10,4,10,6],[10,11,10,12],[10,13,10,14],[10,15,10,16],[10,17,10,18],[13,1,13,3],[13,4,13,7],[15,1,15,3],[15,4,15,7],[17,1,17,8],[17,9,17,11],[18,1,18,2],[18,3,18,6],[18,7,18,8],[18,10,18,11],[19,1,22,2],[19,3,22,6],[19,7,19,8],[19,10,19,11],[20,7,20,8],[20,10,20,11],[21,7,21,8],[21,10,21,11],[22,7,22,8],[22,10,22,11],[22,15,22,17],[23,1,23,2],[23,7,23,8],[23,10,23,11],[23,15,23,17],[24,15,24,17],[25,1,27,1],[25,2,27,2],[25,3,26,4],[25,5,27,5],[25,6,27,6],[25,7,25,19],[26,7,27,7],[26,8,26,9],[26,10,26,11],[26,12,26,13],[26,14,26,15],[26,16,27,16],[26,17,27,17],[26,18,27,18],[26,19,27,19],[36,10,36,11],[36,12,36,13],[36,14,36,15],[36,18,36,19],[38,1,38,2],[40,1,40,3],[40,4,40,7],[42,1,42,3],[42,4,42,7],[44,1,44,8],[44,9,44,11],[45,1,45,2],[45,3,45,6],[45,7,45,8],[45,10,45,11],[46,1,47,2],[46,3,47,6],[46,7,46,8],[46,10,46,11],[47,7,47,8],[47,10,47,11],[47,15,47,17],[48,1,48,2],[48,3,48,4],[48,5,48,6],[48,7,48,8],[48,10,48,11],[48,15,48,17],[49,15,49,17],[50,1,52,1],[50,2,52,2],[50,3,51,4],[50,5,52,5],[50,6,52,6],[50,7,50,19],[51,7,52,7],[51,8,51,9],[51,10,51,11],[51,12,51,13],[51,14,51,15],[51,16,52,16],[51,17,52,17],[51,18,52,18],[51,19,52,19],[58,1,58,3],[58,4,58,7],[60,1,60,3],[60,4,60,7],[62,1,62,8],[62,9,62,11],[62,12,63,12],[62,13,63,13],[63,1,63,2],[63,3,63,4],[63,5,63,6],[63,7,63,8],[63,10,63,11],[64,1,70,2],[64,3,70,6],[64,7,64,8],[64,10,64,11],[65,7,65,8],[65,10,65,11],[65,13,70,13],[66,7,66,8],[66,10,66,11],[67,7,67,8],[67,10,67,11],[68,7,68,8],[68,10,68,11],[69,7,69,8],[69,10,69,11],[69,15,69,17],[70,7,70,8],[70,10,70,11],[70,15,70,17],[71,1,71,2],[72,15,72,17],[73,1,75,1],[73,2,75,2],[73,3,74,4],[73,5,75,5],[73,6,75,6],[73,7,73,19],[74,7,75,7],[74,8,74,9],[74,10,74,11],[74,12,74,13],[74,14,74,15],[74,16,75,16],[74,17,75,17],[74,18,75,18],[74,19,75,19],[85,1,85,3],[85,4,85,7],[87,1,87,3],[87,4,87,7],[89,1,89,8],[89,9,89,11],[89,12,90,12],[90,1,90,2],[90,3,90,6],[90,7,90,8],[90,10,90,11],[91,1,91,2],[91,3,91,6],[91,7,91,8],[91,10,91,11],[92,1,92,2],[92,3,92,4],[92,5,92,6],[92,7,92,8],[92,10,92,11],[92,15,92,17],[93,1,93,2],[93,3,93,4],[93,5,93,6],[93,7,93,8],[93,10,93,11],[93,15,93,17],[94,15,94,17],[95,1,97,1],[95,2,97,2],[95,3,96,4],[95,5,97,5],[95,6,97,6],[95,7,95,19],[96,7,97,7],[96,8,96,9],[96,10,96,11],[96,12,96,13],[96,14,96,15],[96,16,97,16],[96,17,97,17],[96,18,97,18],[96,19,97,19],[104,1,104,3],[104,4,104,7],[106,1,106,3],[106,4,106,7],[108,1,108,8],[108,9,108,11],[108,12,109,12],[109,1,109,2],[109,3,109,6],[109,7,109,8],[109,10,109,11],[110,1,110,2],[110,3,110,6],[110,7,110,8],[110,10,110,11],[111,1,111,2],[111,3,111,4],[111,5,111,6],[111,7,111,8],[111,10,111,11],[111,15,111,17],[112,1,112,2],[112,3,112,4],[112,5,112,6],[112,7,112,8],[112,10,112,11],[112,15,112,17],[113,15,113,17],[114,1,116,1],[114,2,116,2],[114,3,115,4],[114,5,116,5],[114,6,116,6],[114,7,114,19],[115,7,116,7],[115,8,115,9],[115,10,115,11],[115,12,115,13],[115,14,115,15],[115,16,116,16],[115,17,116,17],[115,18,116,18],[115,19,116,19],[123,1,123,3],[123,4,123,7],[125,1,125,3],[125,4,125,7],[127,1,127,8],[127,9,127,11],[127,12,128,12],[128,1,128,2],[128,3,128,6],[128,7,128,8],[128,10,128,11],[129,1,131,2],[129,3,131,6],[129,7,129,8],[129,10,129,11],[130,7,130,8],[130,10,130,11],[131,7,131,8],[131,10,131,11],[132,1,132,2],[132,3,132,4],[132,5,132,6],[132,7,132,8],[132,10,132,11],[132,15,132,17],[133,1,133,2],[133,3,133,4],[133,5,133,6],[133,7,133,8],[133,10,133,11],[133,15,133,17],[134,15,134,17],[135,1,137,1],[135,2,137,2],[135,3,136,4],[135,5,137,5],[135,6,137,6],[135,7,135,19],[136,7,137,7],[136,8,136,9],[136,10,136,11],[136,12,136,13],[136,14,136,15],[136,16,137,16],[136,17,137,17],[136,18,137,18],[136,19,137,19],[149,1,149,3],[149,4,149,7],[151,1,151,3],[151,4,151,7],[153,1,153,8],[153,9,153,11],[153,12,154,12],[154,1,154,2],[154,3,154,6],[154,7,154,8],[154,10,154,11],[155,1,155,2],[155,3,155,6],[155,7,155,8],[155,10,155,11],[156,1,156,2],[156,3,156,4],[156,5,156,6],[156,7,156,8],[156,10,156,11],[156,15,156,17],[157,1,157,2],[157,3,157,4],[157,5,157,6],[157,7,157,8],[157,10,157,11],[157,15,157,17],[158,15,158,17],[159,1,161,1],[159,2,161,2],[159,3,160,4],[159,5,161,5],[159,6,161,6],[159,7,159,19],[160,7,161,7],[160,8,160,9],[160,10,160,11],[160,12,160,13],[160,14,160,15],[160,16,161,16],[160,17,161,17],[160,18,161,18],[160,19,161,19],[170,1,170,3],[170,4,170,7],[172,1,172,3],[172,4,172,7],[174,1,174,8],[174,9,174,11],[174,12,175,12],[175,1,175,2],[175,3,175,6],[175,7,175,8],[175,10,175,11],[176,1,176,2],[176,3,176,6],[176,7,176,8],[176,10,176,11],[177,1,177,2],[177,3,177,4],[177,5,177,6],[177,7,177,8],[177,10,177,11],[177,15,177,17],[178,1,178,2],[178,3,178,4],[178,5,178,6],[178,7,178,8],[178,10,178,11],[178,15,178,17],[179,15,179,17],[180,1,182,1],[180,2,182,2],[180,3,181,4],[180,5,182,5],[180,6,182,6],[180,7,180,19],[181,7,182,7],[181,8,181,9],[181,10,181,11],[181,12,181,13],[181,14,181,15],[181,16,182,16],[181,17,182,17],[181,18,182,18],[181,19,182,19],[192,1,192,3],[205,1,205,3]]}
[{"$nulls":3},"PLAN DE ACCIÓN DE PLANEACIÓN ESTRATEGICA VIGENCIA 2025"]
{"$rows_empty":7}
[{"$nulls":10}," META PLAN ESTRATEGICO:     RENTABILIDAD OPERACIONAL"]
[null,null,"PLAN DE ACCIÓN ",2025,{"$nulls":6},"MES",2024,null,2025,null,2026,null,2027,null,"ACUMULADO "]
[{"$nulls":10},"CUMPLIMIENTO %",{"$f":"M16/L16","v":{"v":0,"d":"0%"}},null,{"$f":"O16/N16","v":{"v":0,"d":"0%"}},null,{"$f":"Q16/P16","v":{"v":0,"d":"0%"}},null,{"$f":"S16/R16","v":{"v":0,"d":"0%"}},null,{"$f":"U16/T16","v":{"v":0,"d":"0%"}}]
[{"$nulls":11},"M","E","M","E","M","E","M","E","M"]
[{"$nulls":10},"MARZO",20,null,20,null,20,null,20,null,20]
[null,"PROCESO:",null,null," Gestión Gerencial",{"$nulls":5},"JUNIO ",20,null,20,null,20,null,20,null,20]
[{"$nulls":10},"SEPTIEMBRE ",20,null,20,null,20,null,20,null,20]
[null,"CARGO RESPONSABLE DEL PROCESO:",null,null,"Gerencia General ",{"$nulls":5},"DICIEMBRE",20,null,20,null,20,null,20,null,20]
[]
[null,"PLAN ESTRATEGICO INSTITUCIONAL 2024-2027",{"$nulls":7},"RESPONSABLES",null,null,"TRD"]
[null,"PERSPECTIVA",null,"Objetivo Estrategico",{"$nulls":3},"Resultado Esperado",null,"PROCESO","DEPENDENCIAS"]
[null,"FINANCIERA",null,"1.Generar márgenes de rentabilidad de un 20% cada año que asegurando la sostenibilidad y recuperación del patrimonio.",{"$nulls":3},"1.1. Presupuesto fiscal aprobado",null,"Gestión financiera","Subgerente financiero",null,800]
[{"$nulls":7},"1.2. Lista de precios con márgenes de rentabilidad sostenible ",null,"Gestión Gerencial","Gerencia General ",null,100]
[{"$nulls":7},"1.3. Control del gasto e ingreso mensualizado",null,"Gestión financiera","Subgerente financiero",null,800]
[{"$nulls":7},"1.4. Seguimiento a los estados financieros mensualizado",null,"Gestión financiera","Subgerente financiero",null,800,null,null,"Total ponderado importancia",null,null,{"$f":"SUM(G29:G33)","v":{"v":1,"d":"100%"}}]
[{"$nulls":4},"PESO",{"v":0.1,"d":"10%"},null,"volumen de botellas de 750 vendidas ",null,"Gestion Comercial y de mercadeo ","Subgerente comercial y de mercadeo",null,{"$f":"+[1]OB3!M24","v":0},null,null,"Ejecucion Plan de Accion",null,null,{"$f":"SUM(R29:R33)","v":{"v":0,"d":"0%"}}]
[{"$nulls":15},"Meta anual Plan de Acción",null,null,{"$f":"+SUMPRODUCT(G29:G33,H29:H33)","v":{"v":1,"d":"100%"}}]
[null,"Relación con resultado esperado","ACTIVIDAD","FECHA\n (dd-mm-aa)",null,"INDICADOR DE CUMPLIMIENTO","Peso ponderado de importancia de la actividad","SEGUIMIENTO A  METAS"]
[{"$nulls":7},"META ANUAL","1 TRIMESTRE",null,"2 TRIMESTRE",null,"3 TRIMESTRE",null,"4 TRIMESTRE",null,"Avance acumulado","Avance ponderado","ANÁLISIS RESULTADO","REGISTRO O EVIDENCIA"]
[{"$nulls":3},"INICIO","FIN",{"$nulls":3},"Meta","Avance","Meta","Avance","Meta","Avance","Meta","Avance"]
[null,"1.1","Elaboración del presupuesto fiscal que permita tener control de gasto y generar rentabilidad ","2025-01-01","2025-12-31","Presupusto aprobado Por CODFIS ",{"v":0.15,"d":"15%"},{"$f":"+I29+K29+M29+O29","v":{"v":1,"d":"100%"}},{"v":1,"d":"100%"},null,{"v":0,"d":"0%"},null,{"v":0,"d":"0%"},null,{"v":0,"d":"0%"},null,{"$f":"+J29+L29+N29+P29","v":{"v":0,"d":"0%"}},{"$f":"+(Q29*G29)","v":{"v":0,"d":"0%"}}]
[null,"1.2","Establecer lista de precios con márgenes rentables ","2025-01-01","2025-12-31","Lista de precios  de los productos elaborada",{"v":0.15,"d":"15%"},{"$f":"+I30+K30+M30+O30","v":{"v":1,"d":"100%"}},{"v":0.5,"d":"50%"},{"$nulls":3},{"v":0.5,"d":"50%"},{"$nulls":3},{"$f":"+J30+L30+N30+P30","v":{"v":0,"d":"0%"}},{"$f":"+(Q30*G30)","v":{"v":0,"d":"0%"}}]
[null,"1.3","Seguimiento mensualizado de la ejecución presupuestal para el control del gasto e ingresos ","2025-01-01","2025-12-31","Ejecución presupuestal mensual ",{"v":0.2,"d":"20%"},{"v":1,"d":"100%"},{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0,"d":"0%"},{"$f":"+(Q31*G31)","v":{"v":0,"d":"0%"}}]
[null,"1.4","Cumplimiento de los volumen de botellas de 750 vendidas, en el valle, otros departamentos y el exterior ","2025-01-01","2025-12-31","(Volúmenes de venta realizadas en el periodo / meta de volúmenes de venta del periodo)*100 ",{"v":0.3,"d":"30%"},{"v":0.9999999999999999,"d":"100%"},{"v":0.15,"d":"15%"},null,{"v":0.15,"d":"15%"},null,{"v":0.35,"d":"35%"},null,{"v":0.35,"d":"35%"},null,{"v":0,"d":"0%"},{"$f":"+(Q32*G32)","v":{"v":0,"d":"0%"}}]
[null,"1.5","Seguimiento mensualizado a los estados financieros ","2025-01-01","2025-12-31","Estados financieros mensuales ",{"v":0.2,"d":"20%"},{"v":1,"d":"100%"},{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0,"d":"0%"},{"$f":"+(Q33*G33)","v":{"v":0,"d":"0%"}}]
[]
[]
[{"$nulls":9}," META PLAN ESTRATEGICO:     TRANSFERENCIAS REALIZADAS    CIFRAS EN MILLONES DE PESOS"]
[{"$nulls":9},"MES",2024,null,2025,null,2026,null,2027,null,"ACUMULADO "]
[{"$nulls":9},"CUMPLIMIENTO %",{"$f":"+L43/K43","v":{"$error":"#DIV/0!"}},null,{"$f":"+N43/M43","v":{"$error":"#DIV/0!"}},null,{"$f":"+P43/O43","v":{"$error":"#DIV/0!"}},null,{"$f":"+R43/Q43","v":{"$error":"#DIV/0!"}},null,{"$f":"+T43/S43","v":{"$error":"#DIV/0!"}}]
[null," PLAN DE ACCIÓN",null,2025,{"$nulls":6},"M","E","M","E","M","E","M","E","M","E"]
[{"$nulls":9},"MARZO",{"$nulls":8},{"$f":"+K40+M40+O40+Q40","v":0},{"$f":"+L40+N40+P40+R40","v":0}]
[null,"PROCESO:",null,null," Gestión Gerencial",{"$nulls":4},"JUNIO ",{"$nulls":8},{"$f":"+K41+M41+O41+Q41","v":0},0]
[{"$nulls":9},"SEPTIEMBRE ",{"$nulls":8},0,0]
[null,"CARGO RESPONSABLE DEL PROCESO:",null,null,"Gerencia General ",{"$nulls":4},"DICIEMBRE",{"$nulls":8},0,0]
[]
[null,"PLAN ESTRATEGICO INSTITUCIONAL 2024-2027",{"$nulls":7},"RESPONSABLES",null,null,"TRD"]
[null,"PERSPECTIVA ",null,"Objetivo Estrategico",{"$nulls":3},"Resultado Esperado",null,"PROCESO","DEPENDENCIA"]
[null,"FINANCIERA",null,"2. Incrementar a $537.771 millones las transferencias de la I.L.V. al Departamento durante el periodo de gobierno.",{"$nulls":3},"2.1.  Impuestos liquidados con base a la norma y las ventas realizadas en el periodo respectivo",null,"Gestión financiera","Subgerente financiero\n",null,800]
[{"$nulls":7},"2.2. Impuestos transferidos al Departamento del Valle de acuerdo a la ley",null,"Gestión financiera","Subgerente financiero\n",null,800,null,null,"Total ponderado importancia",null,null,{"$f":"SUM(G54:G56)","v":{"v":1,"d":"100%"}}]
[{"$nulls":3},"PESO ",null,{"v":0.15,"d":"15%"},null,"2.3 volumen de botellas de 750 vendidas ",null,"Gestion Comercial y de mercadeo ","Subgerente comercial y de mercadeo",null,{"$f":"+[1]OB3!M49","v":0},null,null,"Ejecucion Plan de Accion",null,null,{"$f":"SUM(R54:R56)","v":{"v":0,"d":"0.0%"}}]
[{"$nulls":15},"Meta anual Plan de Accion",null,null,{"$f":"+SUMPRODUCT(G54:G56,H54:H56)","v":{"v":0.9999999999999999,"d":"100.0%"}}]
[null,"Relación con resultado esperado","ACTIVIDAD","FECHA\n (dd-mm-aa)",null,"INDICADOR DE CUMPLIMIENTO","Peso ponderado de importancia de la actividad","SEGUIMIENTO A  METAS"]
[{"$nulls":7},"META ANUAL","1 TRIMESTRE",null,"2 TRIMESTRE",null,"3 TRIMESTRE",null,"4 TRIMESTRE",null,"Avance acumulado","Avance ponderado","ANÁLISIS RESULTADO","REGISTRO O EVIDENCIA"]
[{"$nulls":3},"INICIO","FIN",{"$nulls":3},"Meta","Avance","Meta","Avance","Meta","Avance","Meta","Avance"]
[null,"2.1","Liquidación de los impuestos generados por las  venta realizadas en el respectivo periodo ","2025-01-01","2025-12-31","Número de liquidaciones realizadas /Número de liquidaciones de acuerdo a la ley ",{"v":0.1,"d":"10%"},{"$f":"+I54+K54+M54+O54","v":{"v":1,"d":"100%"}},{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"$f":"+J54+L54+N54+P54","v":{"v":0,"d":"0%"}},{"$f":"+(Q54*G54)","v":{"v":0,"d":"0%"}}]
[null,"2.2","Cumplimiento de los volumen de botellas de 750 vendidas ","2025-01-01","2025-12-31","(Volúmenes de venta realizadas en el periodo / meta de volúmenes de venta del periodo)*100 ",{"v":0.8,"d":"80%"},{"$f":"+I55+K55+M55+O55","v":{"v":0.9999999999999999,"d":"100%"}},{"v":0.15,"d":"15%"},null,{"v":0.15,"d":"15%"},null,{"v":0.35,"d":"35%"},null,{"v":0.35,"d":"35%"},null,{"$f":"+J55+L55+N55+P55","v":{"v":0,"d":"0%"}},{"$f":"+(Q55*G55)","v":{"v":0,"d":"0%"}}]
[null,"2.3","Transferencia de los impuestos al Departamento del Valle de acuerdo a la ley","2025-01-01","2025-12-31","transferencias realizadas al departamento del valle/ metas de transferencias realizadas en el periodo*100",{"v":0.1,"d":"10%"},{"$f":"+I56+K56+M56+O56","v":{"v":1,"d":"100%"}},{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"$f":"+J56+L56+N56+P56","v":{"v":0,"d":"0%"}},{"$f":"+(Q56*G56)","v":{"v":0,"d":"0%"}}]
[]
[]
[null,"PROCESO:",null,null," Gestión Gerencial"]
[]
[null,"CARGO RESPONSABLE DEL PROCESO:",null,null,"Gerencia General "]
[]
[null,"PLAN ESTRATÉGICO INSTITUCIONAL 2024-2027",{"$nulls":7},"RESPONSABLES",null,null,"TRD"," ARTICULACIÓN CON LOS OBJETIVO ESPÉCIFICOS DEL PROYECTO MGA"]
[null,"PERSPECTIVA ",null,"Objetivo Estrategico",null,"Objetivo Especifico",null,"Resultado Esperado",null,"PROCESO","DEPENDENCIA"]
[null," FINANCIERA ",null,"3. Incrementar en la Industria de licores del Valle- ILV una estrategia para incrementar sus ventas en 22% durante el periodo de gobierno.",{"$nulls":3},"3.1 Plan de acción ",null,"Gestion Comercial y de mercadeo ","Subgerencia Comercial y de mercadeo ",null,400,"Formular instrumentos que consoliden las estrategias y los planes para sostenimiento de las ventas."]
[{"$nulls":7},"3.2  Diseño de la estrategía de eshibición ",null,"Gestion Comercial y de mercadeo ","Subgerencia Comercial y de mercadeo ",null,400,"Estrategias de mercadeo focalizadas para el posicionamiento de los productos."]
[{"$nulls":7},"3.3 Diseño de actividades de fidelización del consumidor ",null,"Gestion Comercial y de mercadeo ","Subgerencia Comercial y de mercadeo ",null,400]
[{"$nulls":7},"3.4 Diseño y producion de etiquetas para ron marqués",null,"Gestion Comercial y de mercadeo ","Subgerencia Comercial y de mercadeo ",null,400]
[{"$nulls":7},"3.5 Diseño y produccción de etiquetas de Aguardiente ",null,"Gestion Comercial y de mercadeo ","Subgerencia Comercial y de mercadeo ",null,400]
[{"$nulls":7},"3.6 Cumplimiento del presupuesto del ventas del valle ",null,"Gestion Comercial y de mercadeo ","Subgerencia Comercial y de mercadeo ",null,400,null,null,"Total ponderado importancia",null,null,{"$f":"SUM(G77:G83)","v":{"v":1,"d":"100%"}}]
[{"$nulls":7},"3.7 Apoyo a los canales ",null,"Gestion Comercial y de mercadeo ","Subgerencia Comercial y de mercadeo ",null,400,null,null,"Ejecucion Plan de Accion",null,null,{"$f":"SUM(R77:R83)","v":{"v":0,"d":"0.0%"}}]
[{"$nulls":4},"PESO",{"v":0.15,"d":"15%"}]
[{"$nulls":15},"Meta anual Plan de Accion",null,null,{"$f":"+SUMPRODUCT(G77:G83,H77:H83)","v":{"v":1,"d":"100.0%"}}]
[null,"Relación con resultado esperado","ACTIVIDAD ","FECHA\n (dd-mm-aa)",null,"INDICADOR DE CUMPLIMIENTO","Peso ponderado de importancia de la actividad","SEGUIMIENTO A  METAS"]
[{"$nulls":7},"META ANUAL","1 TRIMESTRE",null,"2 TRIMESTRE",null,"3 TRIMESTRE",null,"4 TRIMESTRE",null,"Avance acumulado","Avance ponderado","ANÁLISIS RESULTADO","REGISTRO O EVIDENCIA"]
[{"$nulls":3},"INICIO","FIN",{"$nulls":3},"Meta","Avance","Meta","Avance","Meta","Avance","Meta","Avance"]
[null,"3.1","Elaboración del presupuesto de ventas FORESCAT ","2025-01-01","2025-12-31","Presupuesto de ventas elaborado",{"v":0.1,"d":"10%"},{"$f":"+I77+K77+M77+O77","v":{"v":1,"d":"100%"}},{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"$f":"+J77+L77+N77+P77","v":{"v":0,"d":"0%"}},{"$f":"+(Q77*G77)","v":{"v":0,"d":"0%"}}]
[null,"3.2","Diseñar estrategía de exhibición ","2025-01-01","2025-12-31","Estrategias de exhibición diseñadas",{"v":0.1,"d":"10%"},{"$f":"+I78+K78+M78+O78","v":{"v":1,"d":"100%"}},{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"$f":"+J78+L78+N78+P78","v":{"v":0,"d":"0%"}},{"v":0,"d":"0%"}]
[null,"3.3","Diseñar actividades de fidelización de consumidor ","2025-01-01","2025-12-31","Actividades de consumidor diseñadas",{"v":0.1,"d":"10%"},{"$f":"+I79+K79+M79+O79","v":{"v":1,"d":"100%"}},{"$nulls":6},{"v":1,"d":"100%"},null,{"$f":"+J79+L79+N79+P79","v":{"v":0,"d":"0%"}},{"v":0,"d":"0%"}]
[null,"3.4","Diseño, y producción  de etiquetas en diferentes presentaciones para ron marqués.","2025-01-01","2025-12-31","N° de  etiquetas diseñadas y producidas para ron marqués  /N° de etiquetas a diseñar y producir para ron marqués en el periodo *100",{"v":0.1,"d":"10%"},{"v":1,"d":"100%"},{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0,"d":"0%"},{"v":0,"d":"0%"}]
[null,"3.5","Diseño, y producción  de etiquetas en diferentes presentaciones para Aguardiente blanco","2025-01-01","2025-12-31","N° de  etiquetas diseñadas y producidas para  aguardiente   /N° de etiquetas a diseñar y producir para ron aguaridiente en el periodo *101",{"v":0.1,"d":"10%"},{"v":1,"d":"100%"},{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0,"d":"0%"},{"v":0,"d":"0%"}]
[null,"3.6","Cumplimiento del presupuesto en el Valle del Cauca, en los diferentes canales ","2025-01-01","2025-12-31","ventas ejecutadas en los diferentes canales  /Presupuesto de ventas en los diferentes canales *100",{"v":0.3,"d":"30%"},{"v":1,"d":"100%"},{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0,"d":"0%"},{"v":0,"d":"0%"}]
[null,"3.7","Apoyo a los canales ","2025-01-01","2025-12-31"," Apoyo actividades ejecutadas a los diferentes canales  /Presupuesto de apoyo  e los diferentes canales *101",{"v":0.2,"d":"20%"},{"v":1,"d":"100%"},{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0,"d":"0%"},{"v":0,"d":"0%"}]
[]
[]
[null,"PROCESO:",null,null,"Gestión comercial y de mercadeo"]
[]
[null,"CARGO RESPONSABLE DEL PROCESO:",null,null,"Siubgerente comercial y de mercadeo"]
[]
[null,"PLAN ESTRATEGICO INSTITUCIONAL 2024-2027",{"$nulls":7},"RESPONSABLES",null,null,"TRD"]
[null,"PERSPECTIVA",null,"Objetivo Estrategico",{"$nulls":3},"Resultado Esperado",null,"PROCESO","DEPENDENCIA"]
[null,"SERVICIO AL CLIENTE",null,"4. 'Incrementar a 95% la satisfacción de los grupos de interés al año 2027 ",{"$nulls":3},"satisfacción del cliente en un 95%",null,"Gestión comercial y de mercadeo","Subgerencia comercial y de mercadeo "]
[{"$nulls":15},"Total ponderado importancia",null,null,{"$f":"SUM(G99:G102)","v":{"v":1,"d":"100%"}}]
[{"$nulls":3},"PESO",null,{"v":0.1,"d":"10%"},{"$nulls":9},"Ejecucion Plan de Accion",null,null,{"$f":"SUM(R99:R102)","v":{"v":0,"d":"0.0%"}}]
[{"$nulls":15},"Meta anual Plan de Accion",null,null,{"$f":"+SUMPRODUCT(G99:G102,H99:H102)","v":{"v":1,"d":"100.0%"}}]
[null,"Relación con resultado esperado","ACTIVIDAD","FECHA\n (dd-mm-aa)",null,"INDICADOR DE CUMPLIMIENTO","Peso ponderado de importancia de la actividad","SEGUIMIENTO A  METAS"]
[{"$nulls":7},"META ANUAL","1 TRIMESTRE",null,"2 TRIMESTRE",null,"3 TRIMESTRE",null,"4 TRIMESTRE",null,"Avance acumulado","Avance ponderado","ANÁLISIS RESULTADO","REGISTRO O EVIDENCIA"]
[{"$nulls":3},"INICIO","FIN",{"$nulls":3},"Meta","Avance","Meta","Avance","Meta","Avance","Meta","Avance"]
[null,1,"Estrategias de exhibición y fidelización del consumidor y grupos de interés ","2025-01-01","2025-12-31"," Ejecutadas  /Presupuestadas *100",{"v":0.3,"d":"30%"},{"$f":"+I99+K99+M99+O99","v":{"v":1,"d":"100%"}},{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"$f":"+J99+L99+N99+P99","v":{"v":0,"d":"0%"}},{"$f":"+(Q99*G99)","v":{"v":0,"d":"0%"}}]
[null,2,"Estrategias de comunicación. Redes sociales, influenciadores y otros medios ","2025-01-01","2025-12-31"," Ejecutadas  /Presupuestadas *100",{"v":0.3,"d":"30%"},{"$f":"+I100+K100+M100+O100","v":{"v":1,"d":"100%"}},{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"$f":"+J100+L100+N100+P100","v":{"v":0,"d":"0%"}},{"v":0,"d":"0%"}]
[null,3,"Medición de la satisfación de los grupos de interés ","2025-01-01","2025-12-31","medición realizada",{"v":0.2,"d":"20%"},{"v":1,"d":"100%"},{"$nulls":6},{"v":1,"d":"100%"},null,{"$f":"+J101+L101+N101+P101","v":{"v":0,"d":"0%"}},{"v":0,"d":"0%"}]
[null,4,"Atender requerimientos ciudadanos en oportunidad. ","2025-01-01","2025-12-31","Ejecutadas / solictadas *100",{"v":0.2,"d":"20%"},{"$f":"+I102+K102+M102+O102","v":{"v":1,"d":"100%"}},{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"$f":"+J102+L102+N102+P102","v":{"v":0,"d":"0%"}},{"v":0,"d":"0%"}]
[]
[]
[null,"PROCESO:",null,null,"Gestión Administrativa/Gestión de producciön / Gestios comercial y de mercadeo"]
[]
[null,"CARGO RESPONSABLE DEL PROCESO:",null,null,"Subgerente de producción/subgerente administrativo/Subgerente comecial y de mercadeo"]
[]
[null,"PLAN ESTRATEGICO INSTITUCIONAL 2024-2027",{"$nulls":7},"RESPONSABLES",null,null,"TRD"]
[null,"PERSPECTIVA",null,"Objetivo Estrategico",{"$nulls":3},"Resultado Esperado",null,"PROCESO","DEPENDENCIA"]
[null,"PROCESOS INTERNOS",null,"5. Fortalecer en un 100% los mecanismos de seguridad de los productos.",{"$nulls":3},"6.1  mecanismos de seguridad de los productos  fortalecida",null,"Gestión de producción ","Subgerencia de producción \n"]
[{"$nulls":15},"Total ponderado importancia",null,null,{"$f":"SUM(G118:G121)","v":{"v":1,"d":"100%"}}]
[{"$nulls":3},"PESO ",null,{"v":0.1,"d":"10%"},{"$nulls":9},"Ejecucion Plan de Accion",null,null,{"$f":"SUM(R118:R121)","v":{"v":0,"d":"0.0%"}}]
[{"$nulls":15},"Meta anual Plan de Accion",null,null,{"$f":"+SUMPRODUCT(G118:G121,H118:H121)","v":{"v":1,"d":"100%"}}]
[null,"Relación con resultado esperado","ACTIVIDAD","FECHA\n (dd-mm-aa)",null,"INDICADOR DE CUMPLIMIENTO","Peso ponderado de importancia de la actividad","SEGUIMIENTO A  METAS"]
[{"$nulls":7},"META ANUAL","1 TRIMESTRE",null,"2 TRIMESTRE",null,"3 TRIMESTRE",null,"4 TRIMESTRE",null,"Avance acumulado","Avance ponderado","ANÁLISIS RESULTADO","REGISTRO O EVIDENCIA"]
[{"$nulls":3},"INICIO","FIN",{"$nulls":3},"Meta","Avance","Meta","Avance","Meta","Avance","Meta","Avance"]
[null,"5.1","Campaña de sensibilizacion y capacitacion sobre productos falsificados, adulterados a entes judiciales y comunidad en general ","2025-01-01","2025-12-31","4 reuniones al año ",{"v":0.3,"d":"30%"},{"$f":"+I118+K118+M118+O118","v":{"v":1,"d":"100%"}},{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"$f":"+J118+L118+N118+P118","v":{"v":0,"d":"0%"}},{"$f":"+(Q118*G118)","v":{"v":0,"d":"0%"}}]
[null,"5.2 ","Diseños y compra de material de empaque exclusivo de la ILV","2025-01-01","2025-12-31","4 compras al año",{"v":0.3,"d":"30%"},{"v":1,"d":"100%"},{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"$f":"+J119+L119+N119+P119","v":{"v":0,"d":"0%"}},{"$f":"+(Q119*G119)","v":{"v":0,"d":"0%"}}]
[null,"5.3","Comunicación digital en redes sociales ","2025-01-01","2025-12-31"," Ejecutadas  /Presupuestadas *100",{"v":0.15,"d":"15%"},{"$f":"+I120+K120+M120+O120","v":{"v":1,"d":"100%"}},{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"$f":"+J120+L120+N120+P120","v":{"v":0,"d":"0%"}},{"$f":"+(Q120*G120)","v":{"v":0,"d":"0%"}}]
[null,"5.4","Explosión de materiales y elaboración del presupuesto anual de compras de material de empaque.","2025-01-01","2025-12-31"," 2 veces al añol año",{"v":0.25,"d":"25%"},{"$f":"+I121+K121+M121+O121","v":{"v":1,"d":"100%"}},{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"$f":"+J121+L121+N121+P121","v":{"v":0,"d":"0%"}},{"$f":"+(Q121*G121)","v":{"v":0,"d":"0%"}}]
[]
[]
[null,"PROCESO:",null,null,"Gestión estratégica/ Gestión de producción, ges"]
[]
[null,"CARGO RESPONSABLE DEL PROCESO:"]
[]
[null,"PLAN ESTRATEGICO INSTITUCIONAL 2024-2027",{"$nulls":7},"RESPONSABLES",null,null,"TRD"]
[null,"PERSPECTIVA",null,"Objetivo Estrategico",{"$nulls":3},"Resultado Esperado",null,"PROCESO","DEPENDENCIA"]
[null,"PROCESOS INTERNOS",null,"6. Incrementar a 92% el nivel de desempeño de los   procesos a través del sistema integrado de gestión al año 2027",{"$nulls":3},"Comites de gestión realizados ",null,"Gestiión estratégica ","Subgerente de planeacion\n",null,400]
[{"$nulls":7},"Auditorias internas realizadas ",null,"Gestión estratégica ","Subgerente de planeacion\n",null,400]
[{"$nulls":7},"planeación de la producción realizada",null,"Gestión de Producción ","Subgerente de producción \n",null,400]
[{"$nulls":3},"PESO ",null,{"v":0.1,"d":"10%"},{"$nulls":9},"Total ponderado importancia",null,null,{"$f":"SUM(G139:G147)","v":{"v":0.9999999999999999,"d":"100%"}}]
[{"$nulls":15},"Ejecucion Plan de Accion",null,null,{"$f":"SUM(R139:R146)","v":{"v":0,"d":"0.0%"}}]
[{"$nulls":15},"Meta anual Plan de Accion",null,null,{"$f":"+SUMPRODUCT(G139:G147,H139:H147)","v":{"v":0.9999999999999999,"d":"100.0%"}}]
[null,"Relación con resultado esperado","ACTIVIDAD","FECHA\n (dd-mm-aa)",null,"INDICADOR DE CUMPLIMIENTO","Peso ponderado de importancia de la actividad","SEGUIMIENTO A  METAS"]
[{"$nulls":7},"META ANUAL","1 TRIMESTRE",null,"2 TRIMESTRE",null,"3 TRIMESTRE",null,"4 TRIMESTRE",null,"Avance acumulado","Avance ponderado","ANÁLISIS RESULTADO","REGISTRO O EVIDENCIA"]
[{"$nulls":3},"INICIO","FIN",{"$nulls":3},"Meta","Avance","Meta","Avance","Meta","Avance","Meta","Avance"]
[null,"6.1","Realización de  comités institucionales de gestion y desempeño","2025-01-01","2025-12-31"," Ejecutadas  /Presupuestadas *100",{"v":0.15,"d":"15%"},{"$f":"+I139+K139+M139+O139","v":{"v":1,"d":"100%"}},{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"$f":"+J139+L139+N139+P139","v":{"v":0,"d":"0%"}},{"$f":"+(Q139*G139)","v":{"v":0,"d":"0%"}}]
[null,"6.2","Consulta a páginas especializados a todos los terceros/ SARLAFT","2025-01-01","2025-12-31"," Ejecutadas  /Presupuestadas *100",{"v":0.15,"d":"15%"},{"$f":"+I140+K140+M140+O140","v":{"v":1,"d":"100%"}},{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"$f":"+J140+L140+N140+P140","v":{"v":0,"d":"0%"}},{"v":0,"d":"0%"}]
[null,"6.3","Seguimiento a todos los terceros cada 6 meses ","2025-01-01","2025-12-31"," Ejecutadas  /Presupuestadas *100",{"v":0.05,"d":"5%"},{"$f":"+I141+K141+M141+O141","v":{"v":1,"d":"100%"}},{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"$f":"+J141+L141+N141+P141","v":{"v":0,"d":"0%"}},{"v":0,"d":"0%"}]
[null,"6.4","Actividades de fortalecimiento de sigilv ","2025-01-01","2025-12-31"," Ejecutadas  /Presupuestadas *101",{"v":0.05,"d":"5%"},{"v":1,"d":"100%"},{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0,"d":"0%"},{"v":0,"d":"0%"}]
[null,"6.5","Auditorias internas para el mejoramiento continuo ","2025-01-01","2025-12-31"," Ejecutadas  /Presupuestadas *102",{"v":0.15,"d":"15%"},{"v":1,"d":"100%"},{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0,"d":"0%"},{"v":0,"d":"0%"}]
[null,"6.6","Actividades relacionados con responsabilidad social y empresarial ","2025-01-01","2025-12-31"," Ejecutadas  /Presupuestadas *103",{"v":0.15,"d":"15%"},{"v":1,"d":"100%"},{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0,"d":"0%"},{"v":0,"d":"0%"}]
[null,"6.7","'Planear Presupuesto de producción de licores de acuerdo a ppto de ventas FORCAST","2025-01-01","2025-12-31"," Ejecutadas  /Presupuestadas *100",{"v":0.1,"d":"10%"},{"v":1,"d":"100%"},{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0,"d":"0%"},{"v":0,"d":"0%"}]
[null,"6.8","'Planear Programa de Produccion mensual","2025-01-01","2025-12-31","4 actividades al año",{"v":0.1,"d":"10%"},{"v":1,"d":"100%"},{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0,"d":"0%"},{"v":0,"d":"0%"}]
[null,"6.9","'Planear Requerimiento de necesidades de personal","2025-01-01","2025-12-31","6 actividades al año",{"v":0.1,"d":"10%"},{"v":1,"d":"100%"},{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0,"d":"0%"},{"v":0,"d":"0%"}]
[]
[]
[null,"PROCESO:",null,null,"sistema de Gestión de calidad "]
[]
[null,"CARGO RESPONSABLE DEL PROCESO:",null,null,"Suibgerente de Planeación "]
[]
[null,"PLAN ESTRATEGICO INSTITUCIONAL 2024-2027",{"$nulls":7},"RESPONSABLES",null,null,"TRD"]
[{"$nulls":3},"Objetivo Estrategico",{"$nulls":3},"Resultado Esperado",null,"PROCESO","DEPENDENCIA"]
[null,"PROCESOS INTERNOS ",null,"7. Incrementar a 98% el Desempeño global de la organización al año 2027. ",{"$nulls":3},"Nivel de desempeño global incrementado",null,"Gestion estratéfico, Gestión comercial y de mercadeo, Gestión de producción ","Subgerente de planeación- subgerente de produccion- subgerente comercial y de mercadeo\n"]
[{"$nulls":15},"Total ponderado importancia",null,null,{"$f":"SUM(G163:G168)","v":{"v":1,"d":"100%"}}]
[null,"|",null,"PESO ",null,{"v":0.05,"d":"5%"},{"$nulls":9},"Ejecucion Plan de Accion",null,null,{"$f":"SUM(R163:R168)","v":{"v":0,"d":"0.0%"}}]
[{"$nulls":15},"Meta anual Plan de Accion",null,null,{"$f":"+SUMPRODUCT(G163:G168,H163:H168)","v":{"v":1,"d":"100.0%"}}]
[null,"Relación con resultado esperado","ACTIVIDAD","FECHA\n (dd-mm-aa)",null,"INDICADOR DE CUMPLIMIENTO","Peso ponderado de importancia de la actividad","SEGUIMIENTO A  METAS"]
[{"$nulls":7},"META ANUAL","1 TRIMESTRE",null,"2 TRIMESTRE",null,"3 TRIMESTRE",null,"4 TRIMESTRE",null,"Avance acumulado","Avance ponderado","ANÁLISIS RESULTADO","REGISTRO O EVIDENCIA"]
[{"$nulls":3},"INICIO","FIN",{"$nulls":3},"Meta","Avance","Meta","Avance","Meta","Avance","Meta","Avance"]
[null,"7.1 ","Estrategias de exhibición y fidelización del consumidor ","2025-01-01","2025-12-31"," Ejecutadas  /Presupuestadas *100",{"v":0.25,"d":"25%"},{"$f":"+I163+K163+M163+O163","v":{"v":1,"d":"100%"}},{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"$f":"+J163+L163+N163+P163","v":{"v":0,"d":"0%"}},{"$f":"+(Q163*G163)","v":{"v":0,"d":"0%"}}]
[null,"7.2","Estrategias de comunicación. Redes sociales, influenciadores y otros medios ","2025-01-01","2025-12-31"," Ejecutadas  /Presupuestadas *101",{"v":0.25,"d":"25%"},{"$f":"+I164+K164+M164+O164","v":{"v":1,"d":"100%"}},{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"$f":"+J164+L164+N164+P164","v":{"v":0,"d":"0%"}},{"$f":"+(Q164*G164)","v":{"v":0,"d":"0%"}}]
[null,"7.3","Adquisición de bienes y servicios ","2025-01-01","2025-12-31"," Ejecutadas  /Presupuestadas *102",{"v":0.25,"d":"25%"},{"v":1,"d":"100%"},null,null,{"v":0.5,"d":"50%"},{"$nulls":3},{"v":0.5,"d":"50%"},null,{"v":0,"d":"0%"},{"v":0,"d":"0%"}]
[null,"7.4","Apoyar a los procesos en la elaboracion de planes de accion, indicadores y riesgos cuando lo requieran ","2025-01-01","2025-12-31"," Ejecutadas  /Presupuestadas *99",{"v":0.05,"d":"5%"},{"v":1,"d":"100%"},{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0,"d":"0%"},{"v":0,"d":"0%"}]
[null,"7.5","Consolidar y monitorear el plan de acción institucional, mapa de riesgos, hoja de vida de indicadores, y partes interesadas.","2025-01-01","2025-12-31"," Ejecutadas  /Presupuestadas *100",{"v":0.1,"d":"10%"},{"v":1,"d":"100%"},{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0,"d":"0%"},{"v":0,"d":"0%"}]
[null,"7.6","Medir el cumplimiento del Plan Estratégico y Plan de acción institucional ","2025-01-01","2025-12-31","4 seguimiento al año",{"v":0.1,"d":"10%"},{"v":1,"d":"100%"},{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0,"d":"0%"},{"v":0,"d":"0%"}]
[]
[]
[null,"PROCESO:",null,null,"Gestión de talento humano"]
[]
[null,"CARGO RESPONSABLE DEL PROCESO:",null,null,"Subgerencia administrativa"]
[]
[null,"PLAN ESTRATEGICO INSTITUCIONAL 2024-2027",{"$nulls":7},"RESPONSABLES",null,null,"TRD"]
[null,"PERSPECTIVA",{"$nulls":5},"Resultado Esperado",null,"PROCESO","DEPENDENCIA"]
[null,"CRECIMIENTO Y APRENDIZAJE",null,"8. Asegurar que los empleados reciban capacitación y desarrollo continuo para mejorar sus habilidades y conocimientos.",{"$nulls":3},"Servidores públicos capacitados y desarrollados ",null,"Gestión de talento  humano ","Subgerencia administrativa"]
[{"$nulls":15},"Total ponderado importancia",null,null,{"$f":"SUM(G184:G187)","v":{"v":1,"d":"100%"}}]
[null,"PESO 20%",null,"PESO ",null,{"v":0.25,"d":"25%"},{"$nulls":9},"Ejecucion Plan de Accion",null,null,{"$f":"SUM(R184:R187)","v":{"v":0,"d":"0.0%"}}]
[{"$nulls":15},"Meta anual Plan de Accion",null,null,{"$f":"+SUMPRODUCT(G184:G187,H184:H187)","v":{"v":1,"d":"100.0%"}}]
[null,"Relación con resultado esperado","ACTIVIDAD","FECHA\n (dd-mm-aa)",null,"INDICADOR DE CUMPLIMIENTO","Peso ponderado de importancia de la actividad","SEGUIMIENTO A  METAS"]
[{"$nulls":7},"META ANUAL","1 TRIMESTRE",null,"2 TRIMESTRE",null,"3 TRIMESTRE",null,"4 TRIMESTRE",null,"Avance acumulado","Avance ponderado","ANÁLISIS RESULTADO","REGISTRO O EVIDENCIA"]
[{"$nulls":3},"INICIO","FIN",{"$nulls":3},"Meta","Avance","Meta","Avance","Meta","Avance","Meta","Avance"]
[null,1,"Actividades para fortalecer la competencia de  aprendizaje continuo a los servidores públicos ","2024-01-01","2024-12-31","capacitaciones realizadas",{"v":0.3,"d":"30%"},{"$f":"+I184+K184+M184+O184","v":{"v":1,"d":"100%"}},{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"$f":"+J184+L184+N184+P184","v":{"v":0,"d":"0%"}},{"$f":"+(Q184*G184)","v":{"v":0,"d":"0%"}}]
[null,3,"Elaborar un diagnóstico de la cultura de la innovación y las necesidades de tecnología para la gestión del conocimiento y la innovación en la ILV","2024-01-01","2024-12-31","Diagnóstico de la cultura de la innovación y necesidades de tecnología",{"v":0.15,"d":"15%"},{"$f":"+I185+K185+M185+O185","v":{"v":1,"d":"100%"}},null,null,{"v":1,"d":"100%"},{"$nulls":5},{"$f":"+J185+L185+N185+P185","v":{"v":0,"d":"0%"}},{"v":0,"d":"0%"}]
[null,4,"Implementar el Banco del Conocimiento y el Repositorio de la Memoria Institucional para ofrecer a los usuarios información, contenidos, documentos, aplicativos y publicaciones producidos por la ILV ","2024-01-01","2024-12-31","Documentos y contenidos publicados en el Banco del Conocimiento\nDocumentos y contenidos depositados en el Repositorio Institucional ",{"v":0.25,"d":"25%"},{"v":1,"d":"100%"},null,null,{"v":1,"d":"100%"},{"$nulls":5},{"v":0,"d":"0%"},{"v":0,"d":"0%"}]
[null,6,"Actividades relacionadas con el bienestar social de los servidores publicos coumpliento con la convención colectiva de trabajo ","2024-01-01","2024-12-31","Informe de Seguimiento a Riesgos",{"v":0.3,"d":"30%"},{"v":1,"d":"100%"},{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0,"d":"0%"},{"v":0,"d":"0%"}]
[]
[]
[null,"Aprobado por:  Jose Moreno Barco\n                                 Gerente General"]
[]
[]
[null,"Elaborado por:  Carlos Alarcón Jaramillo - Subgerente de Planeación y Sistemas de Gestión"]
[]
[null,"Fecha:  29/01/2025"]