{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["¿Cómo usar este archivo","PDCA Ejemplo","Plantilla en blanco","Desplegbales - NO eliminar"],"not_rendered":{"images":5},"read":"whole","date_system":"1900"}

{"sheet":"¿Cómo usar este archivo","index":0,"n_rows":12,"n_cols":1,"rows_kept":12,"merged":[[3,0,3,1],[6,0,6,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,1]]}
[]
["¡Hola!\nEsta plantilla tiene como objetivo ayudarte a gestionar proyectos de mejora con el sistema PDCA."]
[]
["  IMPORTANTE: PARA USARLA DESCÁRGALA EN TU PC O DUPLÍCALA."]
[]
["\n🔎 En este archivo encontrarás:"]
["Plantilla PDCA con un ejemplo y otra en blanco para tu uso."]
[]
["🔎 Instrucciones:"]
["1. Completa solo las celdas no sombreadas. Las celdas sombreadas se llenarán automáticamente."]
["2. Una vez que ingreses la información, la plantilla calculará automáticamente el porcentaje de avance."]
["3. No elimines la pastala de \"Desplegables\" estas sirven para que la plantilla de la información de forma automática."]

{"sheet":"PDCA Ejemplo","index":1,"n_rows":64,"n_cols":9,"rows_kept":64,"merged":[[0,5,1,7],[2,2,2,3],[3,2,3,3],[4,2,4,3],[5,2,5,3],[6,1,6,3],[6,6,6,7],[7,1,7,3],[7,6,7,7],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[16,8,16,9],[17,8,17,9],[18,8,18,9],[19,8,19,9],[20,8,20,9],[21,8,21,9],[22,8,22,9],[23,8,23,9],[24,8,24,9],[25,8,25,9],[26,8,26,9],[28,1,28,2],[28,4,28,5],[29,1,29,2],[29,4,29,5],[30,1,30,2],[30,4,30,5],[31,1,31,2],[31,4,31,5],[32,1,32,2],[32,4,32,5],[33,1,33,2],[33,4,33,5],[34,1,34,2],[34,4,34,5],[35,1,35,2],[35,4,35,5],[36,1,36,2],[36,4,36,5],[37,1,37,2],[37,4,37,5],[38,1,38,2],[38,4,38,5],[39,1,39,2],[39,4,39,5],[40,1,40,2],[40,4,40,5],[41,1,41,2],[41,4,41,5],[42,1,42,2],[42,4,42,5],[43,1,43,2],[43,4,43,5],[44,1,44,2],[44,4,44,5],[45,1,45,2],[45,4,45,5],[46,1,46,2],[46,4,46,5],[47,1,47,2],[47,4,47,5],[48,1,48,2],[48,4,48,5],[49,1,49,2],[49,4,49,5],[50,1,50,2],[50,4,50,5],[51,1,51,2],[51,4,51,5],[52,1,52,2],[52,4,52,5],[53,1,53,2],[53,4,53,5],[54,1,54,2],[54,4,54,5],[55,1,55,2],[55,4,55,5],[56,1,56,2],[56,4,56,5],[57,1,57,2],[57,4,57,5],[58,1,58,2],[58,4,58,5],[59,1,59,2],[59,4,59,5],[60,1,60,2],[60,4,60,5],[61,1,61,2],[61,4,61,5],[62,1,62,2],[62,4,62,5],[63,1,63,2],[63,4,63,5]]}
[null,"Ejemplo de plantilla PDCA"]
[null,"Rellena solo las celdas no sombreadas. Los datos se completarán en las celdas sombreadas.\n\n"]
[null,"Proyecto","Reducir el Tiempo de Resolución de Errores de Software",null,null,"Act","Plan"]
[null,"Proceso","Flujo de Trabajo de Seguimiento y Resolución de Errores",null,null,{"$f":"IFERROR(AVERAGEIFS(G11:G27,B11:B27,F3),\"\")","v":{"v":0.015,"d":"2%"}},{"$f":"IFERROR(AVERAGEIFS(G11:G27,B11:B27,G3),\"\")","v":{"v":0.5166666667,"d":"52%"}}]
[null,"Líder de equipo","Juan Gonzalez",null,null,{"$f":"IFERROR(AVERAGEIFS(G11:G27,B11:B27,F6),\"\")","v":{"v":0.03333333333,"d":"3%"}},{"$f":"IFERROR(AVERAGEIFS(G11:G27,B11:B27,G6),\"\")","v":{"v":0.6,"d":"60%"}}]
[null,"Ciclo Nº",1,null,null,"Check","Do"]
[null,"Project Manager",null,null,"Horas esperadas","Progreso","Actualizado"]
[null,"María Torres",null,null,{"$f":"IF(SUM(F11:F27)=0,\"\",SUM(F11:F27))","v":{"v":66,"d":"66.00"}},{"$f":"IFERROR(AVERAGE(G11:G27),\"\")","v":{"v":0.3329411765,"d":"33%"}},"MM/DD/YY"]
[]
[null,"Etapa PDCA","Acciones","Responsable","Fecha límite","Duración \n(en horas)","% completado","Estado","Conclusiones / Notas"]
[null,"Plan","Analizar el proceso actual de resolución de errores","Equipo","2025-06-19",{"v":6,"d":"6.0"},{"v":1,"d":"100%"},"Completado","Los desarrolladores tienen interpretaciones distintas de la gravedad.\n"]
[null,"Plan","Lluvia de ideas para una resolución más rápida\t","Equipo","MM/DD/YY",{"v":8,"d":"8.0"},{"v":0.1,"d":"10%"},"En proceso","Automatizar la categorización de errores puede ahorrar tiempo.\n"]
[null,"Plan","Seleccionar solución óptima para el seguimiento\t","Equipo","MM/DD/YY",{"v":4,"d":"4.0"},{"v":1,"d":"100%"},"Completado","Implementar etiquetado automático de gravedad en el software.\n"]
[null,"Plan","Desarrollar un plan de acción para los cambios\t","Líder de desarrollo","MM/DD/YY",{"v":4,"d":"4.0"},{"v":1,"d":"100%"},"Completado","Tener responsables claros reduce la confusión en la ejecución.\n"]
[null,"Do","Implementar el nuevo sistema de categorización\t","DevOps","MM/DD/YY",{"v":24,"d":"24.0"},{"v":1,"d":"100%"},"Completado","Problemas iniciales de integración, pero se resolvieron rápidamente."]
[null,"Do","Probar el nuevo sistema en un proyecto piloto\t","Equipo QA","MM/DD/YY",{"v":12,"d":"12.0"},{"v":0.9,"d":"90%"},"En proceso","Los ciclos de retroalimentación del QA fueron más lentos de lo esperado.\n"]
[null,"Do","Recoger retroalimentación de desarrolladores y testers\t","Líder de QA","MM/DD/YY",{"v":1,"d":"1.0"},{"v":0.5,"d":"50%"},"En proceso","Retroalimentación mixta; el sistema necesita ajustes menores.\n"]
[null,"Check","Analizar los datos de resolución de errores post-implementación\t","Líder de QA","MM/DD/YY",{"v":1,"d":"1.0"},{"v":0.1,"d":"10%"},"En proceso"]
[null,"Check","Evaluar si el tiempo de resolución cumple con los objetivos\t","Equipo","MM/DD/YY",{"v":1,"d":"1.0"},{"v":0,"d":"0%"},"No empezado"]
[null,"Check","Compartir resultados con las partes interesadas\t","Gerente","MM/DD/YY",{"v":1,"d":"1.0"},{"v":0,"d":"0%"},"No empezado"]
[null,"Act","Ajustar el algoritmo de categorización según la retroalimentación\t","Líder de desarrollo","MM/DD/YY",{"v":1,"d":"1.0"},{"v":0.06,"d":"6%"},"En proceso"]
[null,"Act","Actualizar la documentación del sistema de seguimiento de errores\t","Líder de equipo","MM/DD/YY",{"v":1,"d":"1.0"},{"v":0,"d":"0%"},"No empezado"]
[null,"Act","Implementar el sistema a nivel organizacional\t","Gerente de TI","MM/DD/YY",{"v":1,"d":"1.0"},{"v":0,"d":"0%"},"No empezado"]
[null,"Act","Capacitar al equipo sobre el proceso actualizado\t","Líder de QA","MM/DD/YY",{"v":1,"d":"1.0"},{"v":0,"d":"0%"},"No empezado"]
[null,"Plan","Pendiente","Name","MM/DD/YY",{"v":0,"d":"0.0"},{"v":0,"d":"0%"},"No empezado"]
[null,"Plan","Pendiente","Name","MM/DD/YY",{"v":0,"d":"0.0"},{"v":0,"d":"0%"},"No empezado"]
[null,"Do","Pendiente","Name","MM/DD/YY",{"v":0,"d":"0.0"},{"v":0,"d":"0%"},"No empezado"]
[null,"Dashboard por Etapa"]
[null,"Plan",null,"Completion","Do",null,"Completion"]
[null,{"$f":"IF(B11=\"plan\",C11,\"\")","v":"Analizar el proceso actual de resolución de errores"},null,{"$f":"IF(B11=\"plan\",G11,\"\")","v":{"v":1,"d":"100%"}},{"$f":"IF(B11=\"Do\",C11,\"\")","v":""},null,{"$f":"IF(B11=\"do\",G11,\"\")","v":""}]
[null,"Lluvia de ideas para una resolución más rápida\t",null,{"v":0.1,"d":"10%"},"",null,""]
[null,"Seleccionar solución óptima para el seguimiento\t",null,{"v":1,"d":"100%"},"",null,""]
[null,"Desarrollar un plan de acción para los cambios\t",null,{"v":1,"d":"100%"},"",null,""]
[null,"",null,"","Implementar el nuevo sistema de categorización\t",null,{"v":1,"d":"100%"}]
[null,"",null,"","Probar el nuevo sistema en un proyecto piloto\t",null,{"v":0.9,"d":"90%"}]
[null,"",null,"","Recoger retroalimentación de desarrolladores y testers\t",null,{"v":0.5,"d":"50%"}]
[null,"",null,"","",null,""]
[null,"",null,"","",null,""]
[null,"",null,"","",null,""]
[null,"",null,"","",null,""]
[null,"",null,"","",null,""]
[null,"",null,"","",null,""]
[null,"",null,"","",null,""]
[null,"Pendiente",null,{"v":0,"d":"0%"},"",null,""]
[null,"Pendiente",null,{"v":0,"d":"0%"},"",null,""]
[null,"",null,"","Pendiente",null,{"v":0,"d":"0%"}]
[null,"Check",null,"Completion","Act",null,"Completion"]
[null,{"$f":"IF(B11=\"Check\",C11,\"\")","v":""},null,{"$f":"IF(B11=\"Check\",G11,\"\")","v":""},{"$f":"IF(B11=\"act\",C11,\"\")","v":""},null,{"$f":"IF(B11=\"act\",G11,\"\")","v":""}]
[null,"",null,"","",null,""]
[null,"",null,"","",null,""]
[null,"",null,"","",null,""]
[null,"",null,"","",null,""]
[null,"",null,"","",null,""]
[null,"",null,"","",null,""]
[null,"Analizar los datos de resolución de errores post-implementación\t",null,{"v":0.1,"d":"10%"},"",null,""]
[null,"Evaluar si el tiempo de resolución cumple con los objetivos\t",null,{"v":0,"d":"0%"},"",null,""]
[null,"Compartir resultados con las partes interesadas\t",null,{"v":0,"d":"0%"},"",null,""]
[null,"",null,"","Ajustar el algoritmo de categorización según la retroalimentación\t",null,{"v":0.06,"d":"6%"}]
[null,"",null,"","Actualizar la documentación del sistema de seguimiento de errores\t",null,{"v":0,"d":"0%"}]
[null,"",null,"","Implementar el sistema a nivel organizacional\t",null,{"v":0,"d":"0%"}]
[null,"",null,"","Capacitar al equipo sobre el proceso actualizado\t",null,{"v":0,"d":"0%"}]
[null,"",null,"","",null,""]
[null,"",null,"","",null,""]
[null,"",null,"","",null,""]

{"sheet":"Plantilla en blanco","index":2,"n_rows":64,"n_cols":9,"rows_kept":64,"merged":[[0,5,1,7],[2,2,2,3],[3,2,3,3],[4,2,4,3],[5,2,5,3],[6,1,6,3],[6,6,6,7],[7,1,7,3],[7,6,7,7],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[16,8,16,9],[17,8,17,9],[18,8,18,9],[19,8,19,9],[20,8,20,9],[21,8,21,9],[22,8,22,9],[23,8,23,9],[24,8,24,9],[25,8,25,9],[26,8,26,9],[28,1,28,2],[28,4,28,5],[29,1,29,2],[29,4,29,5],[30,1,30,2],[30,4,30,5],[31,1,31,2],[31,4,31,5],[32,1,32,2],[32,4,32,5],[33,1,33,2],[33,4,33,5],[34,1,34,2],[34,4,34,5],[35,1,35,2],[35,4,35,5],[36,1,36,2],[36,4,36,5],[37,1,37,2],[37,4,37,5],[38,1,38,2],[38,4,38,5],[39,1,39,2],[39,4,39,5],[40,1,40,2],[40,4,40,5],[41,1,41,2],[41,4,41,5],[42,1,42,2],[42,4,42,5],[43,1,43,2],[43,4,43,5],[44,1,44,2],[44,4,44,5],[45,1,45,2],[45,4,45,5],[46,1,46,2],[46,4,46,5],[47,1,47,2],[47,4,47,5],[48,1,48,2],[48,4,48,5],[49,1,49,2],[49,4,49,5],[50,1,50,2],[50,4,50,5],[51,1,51,2],[51,4,51,5],[52,1,52,2],[52,4,52,5],[53,1,53,2],[53,4,53,5],[54,1,54,2],[54,4,54,5],[55,1,55,2],[55,4,55,5],[56,1,56,2],[56,4,56,5],[57,1,57,2],[57,4,57,5],[58,1,58,2],[58,4,58,5],[59,1,59,2],[59,4,59,5],[60,1,60,2],[60,4,60,5],[61,1,61,2],[61,4,61,5],[62,1,62,2],[62,4,62,5],[63,1,63,2],[63,4,63,5]]}
[null,"Ejemplo de plantilla PDCA"]
[null,"Rellena solo las celdas no sombreadas. Los datos se completarán en las celdas sombreadas.\n\n"]
[null,"Proyecto",{"$nulls":3},"Act","Plan"]
[null,"Proceso",{"$nulls":3},{"$f":"IFERROR(AVERAGEIFS(G11:G27,B11:B27,F3),\"\")","v":{"v":0,"d":"0%"}},{"$f":"IFERROR(AVERAGEIFS(G11:G27,B11:B27,G3),\"\")","v":{"v":0,"d":"0%"}}]
[null,"Líder de equipo",{"$nulls":3},{"$f":"IFERROR(AVERAGEIFS(G11:G27,B11:B27,F6),\"\")","v":{"v":0,"d":"0%"}},{"$f":"IFERROR(AVERAGEIFS(G11:G27,B11:B27,G6),\"\")","v":{"v":0,"d":"0%"}}]
[null,"Ciclo Nº",{"$nulls":3},"Check","Do"]
[null,"Project Manager",null,null,"Horas esperadas","Progreso","Actualizado"]
[null,"María Torres",null,null,{"$f":"IF(SUM(F11:F27)=0,\"\",SUM(F11:F27))","v":""},{"$f":"IFERROR(AVERAGE(G11:G27),\"\")","v":{"v":0,"d":"0%"}},"MM/DD/YY"]
[]
[null,"Etapa PDCA","Acciones","Responsable","Fecha límite","Duración \n(en horas)","% completado","Estado","Conclusiones / Notas"]
[null,"Plan",null,null,"MM/DD/YY",{"v":0,"d":"0.0"},{"v":0,"d":"0%"},"No empezado"]
[null,"Plan",null,null,"MM/DD/YY"]
[null,"Plan",null,null,"MM/DD/YY"]
[null,"Plan",null,null,"MM/DD/YY"]
[null,"Do",null,null,"MM/DD/YY",null,{"v":0,"d":"0%"}]
[null,"Do",null,null,"MM/DD/YY"]
[null,"Do",null,null,"MM/DD/YY"]
[null,"Check",null,null,"MM/DD/YY",null,{"v":0,"d":"0%"}]
[null,"Check",null,null,"MM/DD/YY"]
[null,"Check",null,null,"MM/DD/YY"]
[null,"Act",null,null,"MM/DD/YY",null,{"v":0,"d":"0%"}]
[null,"Act",null,null,"MM/DD/YY"]
[null,"Act",null,null,"MM/DD/YY"]
[null,"Act",null,null,"MM/DD/YY"]
[null,"Plan",null,null,"MM/DD/YY"]
[null,"Plan",null,null,"MM/DD/YY"]
[null,"Do",null,null,"MM/DD/YY"]
[null,"Dashboard por Etapa"]
[null,"Plan",null,"Completion","Do",null,"Completion"]
[null,{"$f":"IF(B11=\"plan\",C11,\"\")","v":""},null,{"$f":"IF(B11=\"plan\",G11,\"\")","v":{"v":0,"d":"0%"}},{"$f":"IF(B11=\"Do\",C11,\"\")","v":""},null,{"$f":"IF(B11=\"do\",G11,\"\")","v":""}]
[null,"",null,"","",null,""]
[null,"",null,"","",null,""]
[null,"",null,"","",null,""]
[null,"",null,"","",null,{"v":0,"d":"0%"}]
[null,"",null,"","",null,""]
[null,"",null,"","",null,""]
[null,"",null,"","",null,""]
[null,"",null,"","",null,""]
[null,"",null,"","",null,""]
[null,"",null,"","",null,""]
[null,"",null,"","",null,""]
[null,"",null,"","",null,""]
[null,"",null,"","",null,""]
[null,"",null,"","",null,""]
[null,"",null,"","",null,""]
[null,"",null,"","",null,""]
[null,"Check",null,"Completion","Act",null,"Completion"]
[null,{"$f":"IF(B11=\"Check\",C11,\"\")","v":""},null,{"$f":"IF(B11=\"Check\",G11,\"\")","v":""},{"$f":"IF(B11=\"act\",C11,\"\")","v":""},null,{"$f":"IF(B11=\"act\",G11,\"\")","v":""}]
[null,"",null,"","",null,""]
[null,"",null,"","",null,""]
[null,"",null,"","",null,""]
[null,"",null,"","",null,""]
[null,"",null,"","",null,""]
[null,"",null,"","",null,""]
[null,"",null,{"v":0,"d":"0%"},"",null,""]
[null,"",null,"","",null,""]
[null,"",null,"","",null,""]
[null,"",null,"","",null,{"v":0,"d":"0%"}]
[null,"",null,"","",null,""]
[null,"",null,"","",null,""]
[null,"",null,"","",null,""]
[null,"",null,"","",null,""]
[null,"",null,"","",null,""]
[null,"",null,"","",null,""]

{"sheet":"Desplegbales - NO eliminar","index":3,"n_rows":6,"n_cols":4,"rows_kept":6}
[null,"DESPLEGABLES CLAVE - NO ELIMINAR"]
[null,"CATEGORY",null,"PRIORITY"]
[null,"Act",null,"Completado"]
[null,"Plan",null,"En proceso"]
[null,"Do",null,"No empezado"]
[null,"Check"]