{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["NOMBRE","D15","D16","Control","MACROS"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"NOMBRE","index":0,"n_rows":42,"n_cols":33,"rows_kept":42,"cut":false,"hidden":false,"merged":[[16,1,18,1],[0,0,0,1],[0,2,0,6],[8,0,8,1],[14,0,14,1]]}
["DATOS DEL ESTABLECIMIENTO",null,"CÓDIGOS"]
["NOMBRE DE COMUNA",null,null,null,null,null,null,null,{"$f":"IF(OR(NOMBRE!C2=\"\",NOMBRE!E2=\"\",NOMBRE!D2=\"\",NOMBRE!E2=\"\",NOMBRE!F2=\"\",NOMBRE!G2=\"\"),\"Falta Cód. Com.\",\"\")","v":"Falta Cód. Com."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I2>\"\",1,0)","v":1}]
["NOMBRE ESTABLECIMIENTO/ESTRATEGIA",null,null,null,null,null,null,null,{"$f":"IF(OR(NOMBRE!C3=\"\",NOMBRE!D3=\"\",NOMBRE!E3=\"\",NOMBRE!F3=\"\",NOMBRE!G3=\"\",NOMBRE!H3=\"\"),\"Falta Cód. Estab.\",\"\")","v":"Falta Cód. Estab."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I3>\"\",1,0)","v":1}]
[]
[]
["MES:",null,null,null,null,null,null,null,{"$f":"IF(OR(NOMBRE!C6=\"\",NOMBRE!D6=\"\"),\"Falta el Mes\",\"\")","v":"Falta el Mes"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I6>\"\",1,0)","v":1}]
["AÑO:",2025,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,{"$f":"SUM(AG2:AG6)","v":3}]
[]
["Versión 1.1: Marzo 2025"]
[]
["Director/a Servicio de Salud o Director/a Establecimiento",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,"ENERO","Establecimiento de Mayor Complejidad (EMAYC)","SERVICIO DE SALUD"]
["Jefe/a de Estadisticas",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,"FEBRERO","Establecimiento de Mediana Complejidad (EMEDC)","MUNICIPAL"]
[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,"MARZO","Establecimiento de Menor Complejidad (EMENC)","OTRA INSTITUCION (Delegado)"]
[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,"ABRIL","Centros de Diagnóstico Terapeutico (CDT)"]
["MINSAL - DEIS",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,"MAYO","Centro de Referencia de Salud (CRS)"]
[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,"JUNIO","Centro de Salud Familiar"]
[null,"SERIE D",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JULIO","Consultorio General Urbano (CGU)"]
[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,"AGOSTO","Consultorio General Urbano (CGU) - CESFAM"]
[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,"SEPTIEMBRE","Consultorio General Urbano(CGU) con SAPU/SUR/SAR"]
[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,"OCTUBRE","Consultorio General Urbano (CGU) - CESFAM con SAPU/SAR"]
[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,"NOVIEMBRE","Consultorio General Rural (CGR)"]
[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,"DICIEMBRE","Consultorio General Rural (CGR) - CESFAM"]
[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,"Consultorio General Rural (CGR) con SAPU/SAR/SUR"]
[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,"Consultorio General Rural (CGR) - CESFAM con SAPU/SAR/SUR"]
[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,"Posta de Salud Rural (PSR)"]
[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,"Centro Comunitario de Salud Familiar (CECOF)"]
[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,"Consultorio de Salud Mental (COSAM)"]
[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,"Programa de Reparación y Atención Integral de Salud (PRAIS)"]
[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,"Centro de Atención Funcionarios (CAF)"]
[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,"Unidad de Salud de Funcionarios (USF)"]
[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,"ClÍnica Dental Móvil (CDM)"]
[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,"Dirección Servicio de Salud (DSS)"]
[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,"Servicio de Atención Primaria de Urgencia (SAPU)"]
[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,"Servicio de Urgencia Rural (SUR)"]
[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,"Servicio de Alta Resolución SAR"]
[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,"Hospital de Campaña"]
[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,"Centro Oncologico"]
[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,"SAMU"]
[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,"Centro de salud Urbano (CSU)"]
[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,"Centro de Rehabilitación (CR)"]
[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,"Laboratorio Clínico o Dental"]
[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,"Servicio de Atención Primaria de Urgencia Dental (SAPUDENT)"]

{"sheet":"D15","index":1,"n_rows":148,"n_cols":37,"rows_kept":148,"cut":false,"hidden":false,"merged":[[89,0,89,1],[71,15,73,15],[71,16,73,16],[74,0,74,1],[77,0,77,1],[78,0,78,1],[79,0,79,1],[83,0,85,1],[83,2,85,2],[83,3,83,4],[83,5,85,5],[83,6,83,12],[83,13,85,13],[84,3,85,3],[84,4,85,4],[84,6,84,8],[84,9,85,9],[84,10,85,10],[84,11,85,11],[84,12,85,12],[88,0,88,1],[49,0,53,0],[54,0,59,0],[60,0,63,0],[64,0,66,0],[67,0,67,1],[70,0,73,1],[70,2,73,2],[70,3,73,3],[70,4,73,4],[36,0,36,1],[38,0,38,1],[40,0,40,1],[45,0,48,0],[45,1,48,1],[45,2,48,2],[45,3,45,9],[45,10,45,11],[45,12,45,14],[46,3,48,3],[46,4,48,4],[46,5,48,5],[46,6,48,6],[46,7,48,7],[46,8,48,8],[46,9,48,9],[46,10,48,10],[46,11,48,11],[46,12,48,12],[46,13,48,13],[46,14,48,14],[32,4,35,4],[32,5,32,11],[32,12,32,13],[32,14,32,16],[33,5,35,5],[33,6,35,6],[33,7,35,7],[33,8,35,8],[33,9,35,9],[33,10,35,10],[33,11,35,11],[33,12,35,12],[33,13,35,13],[33,14,35,14],[33,15,35,15],[33,16,35,16],[90,0,90,1],[91,0,91,1],[92,0,92,1],[93,0,93,1],[94,0,94,1],[41,0,41,1],[5,0,5,10],[6,0,6,16],[8,0,11,0],[8,1,11,1],[8,2,11,2],[8,3,8,9],[9,11,11,11],[8,10,8,11],[9,10,11,10],[9,12,11,12],[9,9,11,9],[9,7,11,7],[9,8,11,8],[9,14,11,14],[9,13,11,13],[8,12,8,14],[9,5,11,5],[9,6,11,6],[9,3,11,3],[9,4,11,4],[76,0,76,1],[70,5,70,11],[70,12,70,13],[70,14,70,16],[71,5,73,5],[71,6,73,6],[71,7,73,7],[71,8,73,8],[71,9,73,9],[71,10,73,10],[71,11,73,11],[71,12,73,12],[71,13,73,13],[71,14,73,14],[27,0,29,0],[12,0,16,0],[17,0,22,0],[23,0,26,0],[30,0,30,1],[32,0,35,1],[32,2,35,2],[32,3,35,3]]}
["SERVICIO DE SALUD"]
[{"$f":"CONCATENATE(\"COMUNA: \",NOMBRE!$B$2,\"  \",\"( \",NOMBRE!$C$2,NOMBRE!$D$2,NOMBRE!$E$2,NOMBRE!$F$2,NOMBRE!$G$2,\" )\")","v":"COMUNA:   (  )"}]
[{"$f":"CONCATENATE(\"ESTABLECIMIENTO/ESTRATEGIA: \",NOMBRE!$B$3,\"  \",\"( \",NOMBRE!$C$3,NOMBRE!$D$3,NOMBRE!$E$3,NOMBRE!$F$3,NOMBRE!$G$3,NOMBRE!$H$3,\" )\")","v":"ESTABLECIMIENTO/ESTRATEGIA:   (  )"}]
[{"$f":"CONCATENATE(\"MES: \",NOMBRE!$B$6,\"  \",\"( \",NOMBRE!$C$6,NOMBRE!$D$6,\" )\")","v":"MES:   (  )"}]
["AÑO: 2025"]
[]
["REM-D.15 - Programa Nacional de Alimentación Complementaria (PNAC)"]
["Sección A: PNAC - Cantidad distribuida (kg) a personas intrasistema"]
["Subprogramas","Productos","Total","Menores a 6 años",null,null,null,null,null,null,"Gestantes",null,"Persona que amamanta a  hijo/a menor a 12 meses"]
[null,null,null,"0 - 2 meses","3 - 5 meses","6 - 11 meses","12 - 17 meses"," 18 - 23 meses"," 24 - 47 meses"," 48 - 71 meses","Normal, sobrepeso y obesas","Bajo peso","0 a 5 meses con Lactancia Materna exclusiva","0 a 5 meses Lactancia Materna + Fórmula Láctea","6 a 11 meses Lactancia Materna"]
[]
[]
["Básico","Purita +Pro 1 (PP1)",{"$f":"SUM(G13:H13)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(OR(C13<>0),M37=\"\"),\"* No olvide digitar la Sección B, Número de personas intrasistema que retiran, en el grupo de Gestantes:Normal, Sobrepeso y Obesas.\",\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(AND(OR($C13<>0),$M$37=\"\"),1,0)","v":0}]
[null,"Purita +Pro 2 (PP2)",{"$f":"SUM(I14:J14)+K14+M14+N14+O14","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$AA14&$AB14&$AC14&$AD14","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(OR(C14<>0),M37=\"\"),\"* No olvide digitar la Sección B, Número de personas intrasistema que retiran, en el grupo de Gestantes:Normal, Sobrepeso y Obesas.\",\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(AND(OR($C14<>0),$M$37=\"\"),1,0)","v":0}]
[null,"Purita Mamá (PM)",{"$f":"SUM(M15:O15)+K15","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$AA15&$AB15&$AC15&$AD15","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(OR(C15<>0),M37=\"\"),\"* No olvide digitar la Sección B, Número de personas intrasistema que retiran, en el grupo de Gestantes:Normal, Sobrepeso y Obesas.\",\"\")","v":""},null,null,null,null,null,null,0]
[null,"Fórmula de Inicio (FI)",{"$f":"SUM(D16:F16)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(OR(C16<>0),M37=\"\"),\"* No olvide digitar la Sección B, Número de personas intrasistema que retiran, en el grupo de Gestantes:Normal, Sobrepeso y Obesas.\",\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(AND(OR($C16<>0),$M$37=\"\"),1,0)","v":0}]
[null,"Subtotal",{"$f":"SUM(D17:O17)","v":0},{"$f":"SUM(D16)","v":0},{"$f":"SUM(E16)","v":0},{"$f":"SUM(F16)","v":0},{"$f":"SUM(G13)","v":0},{"$f":"SUM(H13)","v":0},{"$f":"SUM(I14)","v":0},{"$f":"SUM(J14)","v":0},{"$f":"SUM(K14:K15)","v":0},null,{"$f":"SUM(M14:M15)","v":0},{"$f":"SUM(N14:N15)","v":0},{"$f":"SUM(O14:O15)","v":0}]
["Refuerzo","Purita +Pro 1 (PP1)",{"$f":"SUM(G18:J18)","v":0}]
[null,"Purita +Pro 2 (PP2)",{"$f":"SUM(L19:O19)","v":0}]
[null,"Mi Sopita (MS)",{"$f":"SUM(E20:J20)","v":0}]
[null,"Purita Mamá (PM)",{"$f":"SUM(L21:O21)","v":0}]
[null,"Fórmula de Inicio (FI)",{"$f":"SUM(D22:F22)","v":0}]
[null,"Subtotal",{"$f":"SUM(D23:O23)","v":0},{"$f":"SUM(D22)","v":0},{"$f":"SUM(E20+E22)","v":0},{"$f":"SUM(F20+F22)","v":0},{"$f":"SUM(G18+G20)","v":0},{"$f":"SUM(H18+H20)","v":0},{"$f":"SUM(I18+I20)","v":0},{"$f":"SUM(J18+J20)","v":0},null,{"$f":"SUM(L19+L21)","v":0},{"$f":"SUM(M19+M21)","v":0},{"$f":"SUM(N19+N21)","v":0},{"$f":"SUM(O19+O21)","v":0}]
["Prematuros ","Fórmula de Prematuros (FP)",{"$f":"SUM(D24:F24)","v":0}]
[null,"Fórmula de Incio (FI)",{"$f":"SUM(D25:F25)","v":0}]
[null,"Mi Sopita (MS)",{"$f":"SUM(E26:F26)","v":0}]
[null,"Subtotal",{"$f":"SUM(D27:O27)","v":0},{"$f":"SUM(D24:D25)","v":0},{"$f":"SUM(E24:E26)","v":0},{"$f":"SUM(F24:F26)","v":0}]
["Alergia a la proteína de la leche de vaca","Fórmula Extensamente Hidrolizada (FEH)",{"$f":"SUM(D28:J28)","v":0}]
[null,"Fórmula Aminoacídica (FAA)",{"$f":"SUM(D29:J29)","v":0}]
[null,"Subtotal",{"$f":"SUM(D30:O30)","v":0},{"$f":"SUM(D28:D29)","v":0},0,0,{"$f":"SUM(G28:G29)","v":0},{"$f":"SUM(H28:H29)","v":0},0,0]
["Total",null,{"$f":"SUM(D31:O31)","v":0},{"$f":"+D17+D23+D27+D30","v":0},{"$f":"+E17+E23+E27+E30","v":0},{"$f":"+F17+F23+F27+F30","v":0},{"$f":"+G17+G23+G30","v":0},{"$f":"+H17+H23+H30","v":0},0,{"$f":"+J17+J23+J30","v":0},{"$f":"K17","v":0},{"$f":"L23","v":0},{"$f":"+M17+M23","v":0},{"$f":"+N17+N23","v":0},{"$f":"+O17+O23","v":0}]
["Sección B: PNAC - Número de personas intrasistema que retiran"]
["Subprogramas",null,"Total","Hombres","Mujeres","Menores a 6 años",null,null,null,null,null,null,"Gestantes",null,"Persona que amamanta a  hijo/a menor a 12 meses"]
[null,null,null,null,null,"0 - 2 meses","3 - 5 meses","6 - 11 meses","12 - 17 meses"," 18 - 23 meses"," 24 - 47 meses"," 48 - 71 meses","Normal, sobrepeso y obesas","Bajo peso","0 a 5 meses con Lactancia Materna exclusiva","0 a 5 meses Lactancia Materna + Fórmula Láctea","6 a 11 meses Lactancia Materna"]
[]
[]
["Básico",null,{"$f":"SUM(F37:Q37)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA37","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AND($C37<>0,$D37=\"\",$E37=\"\"),\"* No olvide ingresar la variable hombres y/o mujeres. Digite CERO si no tiene.\",IF(SUM($D37+$E37)<>$C37, \"*La suma Total de: \"&$F$33&\"\"&\" + \"&$M$33&\"\"&\" + \"&$O$33&\"\"&\" debe ser igual a la suma de Hombres + Mujeres. \",\"\"))","v":""},null,null,null,null,null,null,{"$f":"IF(AND($C37<>0,$D37=\"\",$E37=\"\"),1,IF(SUM($D37+$E37)<>$C37,1,0))","v":0}]
["Refuerzo",null,{"$f":"SUM(F38:Q38)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA38","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AND($C38<>0,$D38=\"\",$E38=\"\"),\"* No olvide ingresar la variable hombres y/o mujeres. Digite CERO si no tiene.\",IF(SUM($D38+$E38)<>$C38, \"*La suma Total de: \"&$F$33&\"\"&\" + \"&$M$33&\"\"&\" + \"&$O$33&\"\"&\" debe ser igual a la suma de Hombres + Mujeres. \",\"\"))","v":""},null,null,null,null,null,null,{"$f":"IF(AND($C38<>0,$D38=\"\",$E38=\"\"),1,IF(SUM($D38+$E38)<>$C38,1,0))","v":0}]
["Prematuros ",null,{"$f":"SUM(F39:H39)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA39","v":""},null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,0]
["Alergia a la Proteína de la leche de vaca",null,{"$f":"SUM(F40:L40)","v":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,0]
["TOTAL",null,{"$f":"SUM(D41:E41)","v":0},{"$f":"SUM(D37:D40)","v":0},{"$f":"SUM(E37:E40)","v":0},0,0,0,{"$f":"SUM(I37:I38)+I40","v":0},0,{"$f":"SUM(K37:K38)+K40","v":0},{"$f":"SUM(L37:L38)+L40","v":0},{"$f":"SUM(M37)","v":0},{"$f":"SUM(N38)","v":0},{"$f":"SUM(O37:O38)","v":0},{"$f":"SUM(P37:P38)","v":0},0]
["Programas Sociales (*)",null,{"$f":"SUM(F42:Q42)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA42","v":""},null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,0]
["Nota: (*) Información referencial, ya incluida en los subprogramas."]
[]
["Sección C: PNAC: Cantidad distribuida (kg) a personas extrasistema (incluye modalidad libre elección)"]
["Subprogramas","Productos","Total","Menores a 6 años",null,null,null,null,null,null,"Gestantes",null,"Persona que amamanta a  hijo/a menor a 12 meses"]
[null,null,null,"0 - 2 meses","3 - 5 meses","6 - 11 meses","12 - 17 meses"," 18 - 23 meses"," 24 - 47 meses"," 48 - 71 meses","Normal, sobrepeso y obesas","Bajo peso","0 a 5 meses con Lactancia Materna exclusiva","0 a 5 meses Lactancia Materna + Fórmula Láctea","6 a 11 meses Lactancia Materna"]
[]
[]
["Básico","Purita +Pro 1 (PP1)",{"$f":"SUM(D50:H50)","v":0}]
[null,"Purita +Pro 2 (PP2)",{"$f":"SUM(I51:J51)+K51+M51+N51+O51","v":0}]
[null,"Purita Mamá (PM)",{"$f":"SUM(M52:O52)+K52","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$AA52&$AB52&$AC52&$AD52","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(SUM(K51,K52)<>0,M75=\"\"),\"* No olvide digitar la Sección D, Nº de personas intrasistema que retiran, en el grupo de Gestantes/Normal, Sobrepeso y Obesas..\",\"\")","v":""},{"$f":"IF(AND(SUM(M51,M52)<>0,O75=\"\"),\"* No olvide digitar la Sección D, Nº de personas intrasistema que retiran, en el grupo Persona que amamanta a  hijo/a menor a 12 meses: 0 a 5 meses con Lactancia Materna Exclusiva.\",\"\")","v":""},{"$f":"IF(AND(SUM(N51,N52)<>0,P75=\"\"),\"* No olvide digitar la Sección D, Nº de personas intrasistema que retiran, en el grupo Persona que amamanta a  hijo/a menor a 12 meses: 0 a 5 meses con Lactancia Materna + Formula Lactea.\",\"\")","v":""},{"$f":"IF(AND(SUM(O51,O52)<>0,Q75=\"\"),\"* No olvide digitar la Sección D, Nº de personas intrasistema que retiran, en el grupo Persona que amamanta a  hijo/a menor a 12 meses: 6 a 11 meses Lactancia Materna.\",\"\")","v":""},null,null,null,{"$f":"IF(AND(OR(K51<>0,K52<>0),M75=\"\"),1,0)","v":0},{"$f":"IF(AND(SUM(M51,M52)<>0,O75=\"\"),1,0)","v":0},{"$f":"IF(AND(SUM(N51,N52)<>0,P75=\"\"),1,0)","v":0},{"$f":"IF(AND(SUM(O51,O52)<>0,Q75=\"\"),1,0)","v":0}]
[null,"Fórmula de Inicio (FI)",{"$f":"SUM(D53:F53)","v":0}]
[null,"Subtotal",{"$f":"SUM(D54:O54)","v":0},{"$f":"SUM(D50+D53)","v":0},{"$f":"SUM(E50+E53)","v":0},{"$f":"SUM(F50+F53)","v":0},{"$f":"SUM(G50)","v":0},{"$f":"SUM(H50)","v":0},{"$f":"SUM(I51)","v":0},{"$f":"SUM(J51)","v":0},{"$f":"SUM(K51:K52)","v":0},null,{"$f":"SUM(M51:M52)","v":0},{"$f":"SUM(N51:N52)","v":0},{"$f":"SUM(O51:O52)","v":0}]
["Refuerzo","Purita +Pro 1 (PP1)",{"$f":"SUM(D55:J55)","v":0}]
[null,"Purita +Pro 2 (PP2)",{"$f":"SUM(L56:O56)","v":0}]
[null,"Mi Sopita (MS)",{"$f":"SUM(E57:J57)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA57&\" \"&AB57&\" \"&AC57&\" \"&AD57&\" \"&AA58&\" \"&AB58","v":"     "}]
[null,"Purita Mamá (PM)",{"$f":"SUM(L58:O58)","v":0}]
[null,"Fórmula de Inicio (FI)",{"$f":"SUM(D59:F59)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AC58&\" \"&AD58","v":" "}]
[null,"Subtotal",{"$f":"SUM(D60:O60)","v":0},{"$f":"SUM(D55+D59)","v":0},{"$f":"SUM(E55+E57+E59)","v":0},{"$f":"SUM(F55+F57+F59)","v":0},{"$f":"SUM(G55+G57)","v":0},{"$f":"SUM(H55+H57)","v":0},{"$f":"SUM(I55+I57)","v":0},{"$f":"SUM(J55+J57)","v":0},null,{"$f":"SUM(L56+L58)","v":0},{"$f":"SUM(M56+M58)","v":0},{"$f":"SUM(N56+N58)","v":0},{"$f":"SUM(O56+O58)","v":0}]
["Prematuros ","Fórmula de Prematuros (FP)",{"$f":"SUM(D61:F61)","v":0}]
[null,"Fórmula de Incio (FI)",{"$f":"SUM(D62:F62)","v":0}]
[null,"Mi Sopita (MS)",{"$f":"SUM(E63:F63)","v":0}]
[null,"Subtotal",{"$f":"SUM(D64:O64)","v":0},{"$f":"SUM(D61:D62)","v":0},{"$f":"SUM(E61:E63)","v":0},{"$f":"SUM(F61:F63)","v":0}]
["Alergia a la proteína de la leche de vaca ","Fórmula Extensamente Hidrolizada (FEH)",{"$f":"SUM(D65:J65)","v":0}]
[null,"Fórmula Aminoacídica (FAA)",{"$f":"SUM(D66:J66)","v":0}]
[null,"Subtotal",{"$f":"SUM(D67:O67)","v":0},{"$f":"SUM(D65:D66)","v":0},0,0,0,0,0,0]
["TOTAL",null,{"$f":"SUM(D68:O68)","v":0},{"$f":"+D54+D60+D64+D67","v":0},0,0,0,0,0,0,{"$f":"+K54","v":0},{"$f":"L60","v":0},0,0,0]
[]
["Sección D: PNAC - Número de personas extrasistema que retiran"]
["Subprogramas",null,"Total","Hombres"," Mujeres","Menores a 6 años",null,null,null,null,null,null,"Gestantes",null,"Persona que amamanta a  hijo/a menor a 12 meses"]
[null,null,null,null,null,"0 - 2 meses","3 - 5 meses","6 - 11 meses","12 - 17 meses"," 18 - 23 meses"," 24 - 47 meses"," 48 - 71 meses","Normal, sobrepeso y obesas","Bajo peso","0 a 5 meses con Lactancia Materna exclusiva","0 a 5 meses Lactancia Materna + Fórmula Láctea","6 a 11 meses Lactancia Materna"]
[]
[]
["Básico",null,{"$f":"SUM(F75:Q75)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA75&AB75&AC75&AD75&AE75&AF75","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AND($C75<>0,$D75=\"\",$E75=\"\"),\"* No olvide ingresar la variable Hombres y/o Mujeres. Digite CERO si no tiene.\",IF(SUM($D75+$E75)<>$C75, \"*La suma Total de: \"&$F$33&\"\"&\" + \"&$M$33&\"\"&\" + \"&$O$33&\"\"&\" debe ser igual a la suma de Hombres + Mujeres. \",\"\"))","v":""},null,null,null,null,null,null,{"$f":"IF(AND($C75<>0,$D75=\"\",$E75=\"\"),1,IF(SUM($D75+$E75)<>$C75,1,0))","v":0}]
["Refuerzo",null,{"$f":"SUM(F76:Q76)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA76&AB76&AC76&AD76&AE76&AF76","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AND($C76<>0,$D76=\"\",$E76=\"\"),\"* No olvide ingresar la variable Hombres y/o Mujeres. Digite CERO si no tiene.\",IF(SUM($D76+$E76)<>$C76, \"*La suma Total de: \"&$F$33&\"\"&\" + \"&$M$33&\"\"&\" + \"&$O$33&\"\"&\" debe ser igual a la suma de Hombres + Mujeres. \",\"\"))","v":""},null,null,null,null,null,null,0]
["Prematuros ",null,{"$f":"SUM(F77:H77)","v":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,0]
["Alergia a la Proteína de la leche de vaca ",null,{"$f":"SUM(F78:L78)","v":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,0]
["TOTAL",null,{"$f":"SUM(D79:E79)","v":0},{"$f":"SUM(D75:D78)","v":0},{"$f":"SUM(E75:E78)","v":0},0,0,0,{"$f":"SUM(I75:I76)+I78","v":0},{"$f":"SUM(J75:J76)+J78","v":0},0,0,{"$f":"SUM(M75)","v":0},{"$f":"SUM(N76)","v":0},{"$f":"SUM(O75:O76)","v":0},{"$f":"SUM(P75:P76)","v":0},0]
["Programas Sociales (*)",null,{"$f":"SUM(F80:Q80)","v":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,{"$f":"IF(AND($C80<>0,$D80=\"\",$E80=\"\"),1,IF(SUM($D80+$E80)<>$C80,1,0))","v":0}]
["Nota: (*) Información referencial, ya incluida en los subprogramas."]
[]
["Sección E: Existencia y movimiento total de productos (Intrasistema y Extrasistema)"]
["Productos",null,"Saldo Mes Anterior","Ingresos",null,"Total Disponible","Egresos",null,null,null,null,null,null,"Saldo mes siguiente"]
[null,null,null,"Proveedor/Operador Logístico","Por traspaso",null,"Distribuido a Población Beneficiaria",null,null,"Mermas (Incluye faltantes)","Otros (demostraciones, donaciones, etc.)","Traspaso","Total Egresos"]
[null,null,null,null,null,null,"Intrasistema","Extrasistema","Total"]
["Purita +Pro 1 (PP1)",null,null,null,null,{"$f":"SUM(C87:E87)","v":0},{"$f":"C13+C18","v":0},{"$f":"+C50+C55","v":0},{"$f":"+G87+H87","v":0},null,null,null,{"$f":"SUM(I87:L87)","v":0},{"$f":"F87-M87","v":0}]
["Purita +Pro 2 (PP2)",null,null,null,null,0,{"$f":"C14+C19","v":0},{"$f":"+C51+C56","v":0},0,null,null,null,{"$f":"SUM(I88:L88)","v":0},0]
["Mi Sopita (MS)",null,null,null,null,0,{"$f":"C20+C26","v":0},{"$f":"+C57+C63","v":0},0,null,null,null,0,0]
["Purita Mamá (PM)",null,null,null,null,0,{"$f":"+C15+C21","v":0},{"$f":"+C52+C58","v":0},0,null,null,null,0,0]
["Fórmula de Inicio (FI)",null,null,null,null,{"$f":"SUM(C91:E91)","v":0},{"$f":"C16+C22+C25","v":0},{"$f":"+C53+C59+C62","v":0},0,null,null,null,0,0]
["Fórmula Prematuros",null,null,null,null,{"$f":"SUM(C92:E92)","v":0},{"$f":"C24","v":0},{"$f":"C61","v":0},{"$f":"+G92+H92","v":0},null,null,null,0,0]
["Fórmula Extensamente Hidrolizada (FEH)",null,null,null,null,0,{"$f":"C28","v":0},{"$f":"C65","v":0},{"$f":"+G93+H93","v":0},null,null,null,0,0]
["Fórmula aminoacídica (FAA)",null,null,null,null,0,{"$f":"C29","v":0},{"$f":"C66","v":0},0,null,null,null,0,0]
["TOTAL (Kg)",null,{"$f":"SUM(C87,C88:C94)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"SUM(C13:C16,C18:C22,C24:C26,C28:C29,C37:C40,C42,C50:C53,C55:C59,C61:C63,C65:C66,C75:C78,C80,C87:C94)","v":0},{"$f":"SUM(AH13:AK80)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"SUM(B8:Q95)","v":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,{"$f":"SUM(AE1:AI147)","v":0}]

{"sheet":"D16","index":2,"n_rows":71,"n_cols":29,"rows_kept":71,"cut":false,"hidden":false,"merged":[[6,0,6,6],[28,10,30,10],[28,4,30,4],[29,3,30,3],[29,9,30,9],[29,5,30,5],[29,6,30,6],[29,7,30,7],[29,8,30,8],[17,0,17,3],[8,0,8,2],[27,0,27,10],[18,0,19,0],[18,1,18,3],[35,0,36,0],[28,5,28,9],[29,2,30,2],[28,0,30,0],[28,1,30,1],[28,2,28,3],[35,1,35,3],[34,0,34,5]]}
["SERVICIO DE SALUD"]
[{"$f":"CONCATENATE(\"COMUNA: \",NOMBRE!$B$2,\"  \",\"( \",NOMBRE!$C$2,NOMBRE!$D$2,NOMBRE!$E$2,NOMBRE!$F$2,NOMBRE!$G$2,\" )\")","v":"COMUNA:   (  )"}]
[{"$f":"CONCATENATE(\"ESTABLECIMIENTO/ESTRATEGIA: \",NOMBRE!$B$3,\"  \",\"( \",NOMBRE!$C$3,NOMBRE!$D$3,NOMBRE!$E$3,NOMBRE!$F$3,NOMBRE!$G$3,NOMBRE!$H$3,\" )\")","v":"ESTABLECIMIENTO/ESTRATEGIA:   (  )"}]
[{"$f":"CONCATENATE(\"MES: \",NOMBRE!$B$6,\"  \",\"( \",NOMBRE!$C$6,NOMBRE!$D$6,\" )\")","v":"MES:   (  )"}]
[{"$f":"CONCATENATE(\"AÑO: \",NOMBRE!$B$7)","v":"AÑO: 2025"}]
[]
["REM-D.16.    Programa de Alimentación Complementaria del Adulto Mayor (PACAM)"]
[]
["Sección A: PACAM - Cantidad distribuida (kg)"]
["Grupo Programático","Sopa/Crema","Bebida Láctea "]
["70 años y más (independiente del motivo de ingreso)",null,null,{"$f":"$AA11","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B11<>C11,\"La cantidad distribuída de Sopa/Crema es distinta a la cantidad distribuída de Bebida Láctea.- \",\"\")","v":""},null,{"$f":"IF($B11<>$C11,1,0)","v":0}]
["65 - 69 años con alteración de la funcionalidad",null,null,{"$f":"$AA12","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B12<>C12,\"La cantidad distribuída de Sopa/Crema es distinta a la cantidad distribuída de Bebida Láctea.- \",\"\")","v":""},null,{"$f":"IF($B12<>$C12,1,0)","v":0}]
["65 - 69 años en programa social (Vínculos, Familia, Calle u otro)",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,0]
["60 - 69 años con tuberculosis",null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B14<>C14,\"La cantidad distribuída de Sopa/Crema es distinta a la cantidad distribuída de Bebida Láctea.- \",\"\")","v":""},null,0]
["60 - 69 años en ELEAM autorizado o similar",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,0]
["TOTAL",{"$f":"SUM(B11:B15)","v":0},{"$f":"SUM(C11:C15)","v":0}]
[]
["Sección B: PACAM - Número de personas que retiran"]
["Grupo Programático","Sopa/Crema - Bebida Láctea"]
[null,"Total","Total Hombres","Total Mujeres"]
["70 años y más (independiente del motivo de ingreso",{"$f":"SUM(C21:D21)","v":0},null,null,{"$f":"$AA21","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(((B11+C11)/2)<>((C21+D21)),\" No olvide que el Nº de personas que retiran debe ser igual al promedio de Kilos que retiran en Seccion A.\",\"\")","v":""},null,{"$f":"IF(((B11+C11)/2)<>((C21+D21)),1,0)","v":0}]
["65 - 69 años con alteración de la funcionalidad",{"$f":"SUM(C22:D22)","v":0},null,null,{"$f":"$AA22","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(((B12+C12)/2)<>((C22+D22)),\" No olvide que el Nº de personas que retiran debe ser igual al promedio de Kilos que retiran en Seccion A.\",\"\")","v":""},null,{"$f":"IF(((B12+C12)/2)<>((C22+D22)),1,0)","v":0}]
["65 - 69 años en programa social (Vínculos, Familia, Calle u otro)",{"$f":"SUM(C23:D23)","v":0},null,null,{"$f":"$AA23","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0]
["60 - 69 años con tuberculosis",{"$f":"SUM(C24:D24)","v":0},null,null,{"$f":"$AA24","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0]
["60 - 69 años en ELEAM autorizado o similar",{"$f":"SUM(C25:D25)","v":0},null,null,{"$f":"$AA25","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0]
["TOTAL",{"$f":"SUM(B21:B25)","v":0},{"$f":"SUM(C21:C25)","v":0},{"$f":"SUM(D21:D25)","v":0}]
[]
["Sección C: Existencia y movimiento de productos"]
["Productos","Saldo mes anterior","Ingresos",null,"Total disponible","Egresos",null,null,null,null,"Saldo mes siguiente"]
[null,null,"Proveedor/Operador Logístico","Por traspaso",null,"Distribuido a población beneficiaria","Mermas (Incluye faltantes)","Otros: (demostraciones, donaciones, etc.)","Traspaso","Total egresos"]
[]
["Sopa/Crema",null,null,null,{"$f":"SUM(B32:D32)","v":0},{"$f":"B16","v":0},null,null,null,{"$f":"SUM(F32:I32)","v":0},{"$f":"E32-J32","v":0}]
["Bebida Láctea",null,null,null,{"$f":"SUM(B33:D33)","v":0},{"$f":"C16","v":0},null,null,null,{"$f":"SUM(F33:I33)","v":0},{"$f":"E33-J33","v":0}]
[]
["Sección D: PACAM - Número de personas que retiran, pertenecientes al PRAIS (incluidos en Sección B)"]
["Grupo Programático","Sopa/Crema - Bebida Láctea"]
[null,"Total","Total Hombres","Total Mujeres"]
["70 años y más (independiente del motivo de ingreso",{"$f":"SUM(C38:D38)","v":0}]
["65 - 69 años con alteración de la funcionalidad",{"$f":"SUM(C39:D39)","v":0}]
["65 - 69 años en programa social (Vínculos, Familia, Calle u otro)",0]
["60 - 69 años con tuberculosis",{"$f":"SUM(C41:D41)","v":0}]
["60 - 69 años en ELEAM autorizado o similar",0]
["TOTAL",{"$f":"SUM(B38:B42)","v":0},{"$f":"SUM(C38:C42)","v":0},{"$f":"SUM(D38:D42)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"SUM(B11:C15,C21:D25,B32:D33,G32:I33,C38:D42)","v":0}]
[{"$f":"SUM(AC11:AC25)","v":0}]

{"sheet":"Control","index":3,"n_rows":100,"n_cols":13,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
[null,null,"NÚMERO DE ERRORES  SEGÚN :"]
[null,null,"A.- OMISIÓN DE INFORMACIÓN"]
[null,null,"B: VALIDACIÓN DE LOS DATOS"]
[null,null,{"$f":"CONCATENATE(\"ESTABLECIMIENTO/ESTRATEGIA: \",NOMBRE!B3,\" - \",\"( \",NOMBRE!C3,NOMBRE!D3,NOMBRE!E3,NOMBRE!F3,NOMBRE!G3,NOMBRE!H3,\" )\")","v":"ESTABLECIMIENTO/ESTRATEGIA:  - (  )"}]
[null,null,null,"REM","REM\nSIN DATOS","CAUSAL","OTRA CAUSAL (indicar)"]
[null,null,null,"HOJA NOMBRE",{"$f":"IF((NOMBRE!AG7)=0,\"\",\"SIN INFORMACIÓN\")","v":"SIN INFORMACIÓN"},null,null,null,null,null,null,null,"Licencia médica"]
[null,null,null,"REM 15",{"$f":"IF(('D15'!A110)=0,\"SIN INFORMACIÓN\",\"\")","v":"SIN INFORMACIÓN"},null,null,null,null,null,null,null,"Feriado Legal"]
[null,null,null,"REM16",{"$f":"IF(('D16'!A70)=0,\"SIN INFORMACIÓN\",\"\")","v":"SIN INFORMACIÓN"},null,null,null,null,null,null,null,"No hubo profesional"]
[null,null,null,null,null,null,null,null,null,null,null,null,"No corresponde REM"]
[null,null,null,"TOTAL REM SIN INFORMACIÓN",{"$f":"COUNTIF(E6:E8,\"SIN INFORMACIÓN\")","v":3},null,null,null,null,null,null,null,"Otra causa justificada"]
[null,null,null,"TOTAL DE ERRORES REM 15",{"$f":"+'D15'!B110","v":0}]
[null,null,null,"TOTAL DE ERRORES REM 16",{"$f":"+'D16'!A71","v":0}]
[null,null,null,"TOTAL DE ERRORES",{"$f":"SUM(E10:E12)","v":3}]
[]
[]
[]
[]
[null,null,null,null,{"$f":"NOMBRE!AG7","v":3}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"NOMBRE!AG7","v":3}]

{"sheet":"MACROS","index":4,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,7],[9,1,10,7]]}
[]
[null,"Hoja de Macros y Utilidades"]
[]
[null,{"$f":"CONCATENATE(\"ESTABLECIMIENTO/ESTRATEGIA: \",NOMBRE!B3,\" - \",\"( \",NOMBRE!C3,NOMBRE!D3,NOMBRE!E3,NOMBRE!F3,NOMBRE!G3,NOMBRE!H3,NOMBRE!I3,\" )\")","v":"ESTABLECIMIENTO/ESTRATEGIA:  - ( Falta Cód. Estab. )"}]
[]
[]
[null,"COPIA Y PEGA A VALORES TODAS LAS HOJAS\nGRABELO CON OTRO NOMBRE"]
[]
[]
[null,{"$f":"IF(Control!E13>0,\"ANTES DE EJECUTAR SUS MACROS REVISE LA HOJA CONTROL, EXISTEN ERRORES QUE DEBE CORREGIR\",\"\")","v":"ANTES DE EJECUTAR SUS MACROS REVISE LA HOJA CONTROL, EXISTEN ERRORES QUE DEBE CORREGIR"}]
[]
[]
[]
[null,"Contraseña para copia del archivo :DEIS"]