{"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":1,"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}]
["TIPO DE ESTABLECIMIENTO/ESTRATEGIA",null,null,null,null,null,null,null,{"$f":"IF(OR(NOMBRE!B4=\"\"),\"Falta TIPO Estab.\",\"\")","v":"Falta TIPO 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(I4>\"\",1,0)","v":1}]
["DEPENDENCIA",null,null,null,null,null,null,null,{"$f":"IF(OR(NOMBRE!B5=\"\"),\"Falta DEPENDENCIA Estab.\",\"\")","v":"Falta DEPENDENCIA 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(I5>\"\",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:",2023,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":5}]
[]
["Versión 1.0: FEBRERO 2023"]
[]
["Director Servicio de Salud o Director 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 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":156,"n_cols":35,"rows_kept":156,"cut":false,"hidden":false,"merged":[[37,16,39,16],[36,14,36,16],[49,14,51,14],[48,12,48,14],[77,16,79,16],[76,14,76,16],[27,0,29,0],[31,0,33,0],[45,0,45,1],[37,13,39,13],[36,3,39,3],[36,12,36,13],[37,15,39,15],[37,6,39,6],[48,10,48,11],[49,4,51,4],[49,9,51,9],[48,3,48,9],[49,3,51,3],[37,14,39,14],[37,11,39,11],[37,12,39,12],[52,15,52,21],[59,15,59,21],[61,15,61,21],[63,15,63,21],[64,15,64,21],[76,0,79,1],[76,2,79,2],[77,10,79,10],[77,11,79,11],[71,0,73,0],[59,0,66,0],[67,0,70,0],[74,0,74,1],[77,14,79,14],[77,12,79,12],[77,13,79,13],[77,15,79,15],[76,12,76,13],[76,5,76,11],[34,0,34,1],[12,0,18,0],[19,0,26,0],[9,5,11,5],[36,0,39,1],[9,6,11,6],[9,3,11,3],[9,4,11,4],[89,2,91,2],[83,0,83,1],[80,0,80,1],[85,0,85,1],[44,0,44,1],[37,5,39,5],[40,0,40,1],[89,5,91,5],[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,13,11,13],[9,10,11,10],[9,12,11,12],[9,9,11,9],[9,7,11,7],[9,8,11,8],[9,14,11,14],[8,12,8,14],[37,8,39,8],[37,7,39,7],[36,4,39,4],[36,5,36,11],[89,13,91,13],[77,8,79,8],[77,9,79,9],[102,0,102,1],[92,0,92,1],[94,0,94,1],[96,0,96,1],[98,0,98,1],[99,0,99,1],[89,6,89,12],[90,4,91,4],[90,11,91,11],[90,12,91,12],[90,9,91,9],[90,10,91,10],[100,0,100,1],[101,0,101,1],[89,3,89,4],[90,3,91,3],[90,6,90,8],[49,12,51,12],[89,0,91,1],[37,9,39,9],[37,10,39,10],[49,13,51,13],[84,0,84,1],[82,0,82,1],[49,10,51,10],[49,11,51,11],[76,3,79,3],[76,4,79,4],[42,0,42,1],[36,2,39,2],[52,0,58,0],[48,0,51,0],[48,1,51,1],[48,2,51,2],[49,8,51,8],[49,5,51,5],[49,6,51,6],[49,7,51,7],[77,5,79,5],[77,6,79,6],[77,7,79,7]]}
["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: 2023"}]
[]
["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","Leche Purita Fortificada (LPF)",{"$f":"SUM(G13:O13)","v":0}]
[null,"Purita +Pro 1",{"$f":"SUM(G14:O14)","v":0}]
[null,"Purita Cereal (PC)",{"$f":"SUM(H15:J15)","v":0}]
[null,"Purita +Pro 2",{"$f":"SUM(I16:J16)","v":0}]
[null,"Purita Mamá (PM)",{"$f":"SUM(M17:O17)+K17","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$AA17&$AB17&$AC17&$AD17","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(K13,K14,K17)=M41,\"\",\" No olvide escribir el Nº Correcto según kg por persona que retira alimento de la sección B en el grupo de Gestantes Normal, Sobrepeso y Obesas\")","v":""},{"$f":"IF(SUM(M13,M14,M17)=(O41*2),\"\",\"No olvide escribir el Nº Correcto según kg por persona que retira alimento de la sección B en el grupo de Madre con hijo/a menor a 6 meses con Lactancia materna exclusiva\")","v":""},{"$f":"IF(SUM(N13,N14,N17)=P41,\"\",\"No olvide escribir el Nº Correcto según kg por persona que retira alimento de la sección B en el grupo de Madre con hijo/a menor a 6 meses con Lactancia materna predominante\")","v":""},{"$f":"IF(SUM(O13,O14,O17)=Q40,\"\",\"No olvide escribir el Nº Correcto según kg por persona que retira alimento de la sección B en el grupo de Madre con hijo/a menor a 6 meses con Formula predominantes o exclusiva\")","v":""},null,{"$f":"IF(SUM(K13,K14,K17)=M41,0,1)","v":0},{"$f":"IF(M13+M14+M17=(O41*2),0,1)","v":0},{"$f":"IF(N13+N14+N17=P41,0,1)","v":0},{"$f":"IF(O13+O14+O17=Q41,0,1)","v":0}]
[null,"Fórmula de Inicio (FI)",{"$f":"SUM(D18:F18)","v":0}]
[null,"Subtotal",{"$f":"SUM(D19:O19)","v":0},{"$f":"SUM(D18)","v":0},{"$f":"SUM(E18)","v":0},{"$f":"SUM(F18)","v":0},{"$f":"SUM(G13:G14)","v":0},{"$f":"SUM(H13:H15)","v":0},{"$f":"SUM(I13:I16)","v":0},{"$f":"SUM(J13:J16)","v":0},{"$f":"SUM(K13:K18)","v":0},{"$f":"SUM(L13:L14)","v":0},{"$f":"SUM(M13:M18)","v":0},{"$f":"SUM(N13:N18)","v":0},{"$f":"SUM(O13:O18)","v":0}]
["Refuerzo","Leche Purita Fortificada (LPF)",{"$f":"SUM(G20:O20)","v":0}]
[null,"Purita +Pro 1",{"$f":"SUM(G21:O21)","v":0}]
[null,"Purita Cereal (PC)",{"$f":"SUM(H22:J22)","v":0}]
[null,"Purita +Pro 2",{"$f":"SUM(I23:J23)","v":0}]
[null,"Mi Sopita (MS)",{"$f":"SUM(E24:J24)","v":0}]
[null,"Purita Mamá (PM)",{"$f":"SUM(L25:O25)","v":0}]
[null,"Fórmula de Inicio (FI)",{"$f":"SUM(D26:F26)","v":0}]
[null,"Subtotal",{"$f":"SUM(D27:O27)","v":0},{"$f":"SUM(D26)","v":0},{"$f":"SUM(E20:E26)","v":0},{"$f":"SUM(F20:F26)","v":0},{"$f":"SUM(G20:G24)","v":0},{"$f":"SUM(H20:H24)","v":0},{"$f":"SUM(I20:I24)","v":0},{"$f":"SUM(J20:J24)","v":0},{"$f":"SUM(K20:K21)","v":0},{"$f":"SUM(L20:L26)","v":0},{"$f":"SUM(M20:M26)","v":0},{"$f":"SUM(N20:N26)","v":0},{"$f":"SUM(O20:O26)","v":0}]
["Prematuros ","Fórmula de Prematuros (FP)",{"$f":"SUM(D28:F28)","v":0}]
[null,"Fórmula de Incio (FI)",{"$f":"SUM(D29:F29)","v":0}]
[null,"Mi Sopita (MS)",{"$f":"SUM(E30:F30)","v":0}]
[null,"Subtotal",{"$f":"SUM(D31:O31)","v":0},{"$f":"SUM(D28:D30)","v":0},{"$f":"SUM(E28:E30)","v":0},{"$f":"SUM(F28:F30)","v":0},0,0,0,0,0,0,0,0,0]
["Alergia a la proteína de la leche de vaca","Fórmula Extensamente Hidrolizada (FEH)",{"$f":"SUM(D32:J32)","v":0}]
[null,"Fórmula Aminoacídica (FAA)",{"$f":"SUM(D33:J33)","v":0}]
[null,"Subtotal",{"$f":"SUM(D34:O34)","v":0},{"$f":"SUM(D32:D33)","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Total",null,{"$f":"SUM(D35:O35)","v":0},{"$f":"+D19+D27+D31+D34","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Sección B: PNAC - Número de personas intrasistema que retiran"]
["Subprogramas",null,"Total","Total Hombre","Total Mujer","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(F41:M41)+SUM(O41:Q41)","v":0}]
["Refuerzo",null,{"$f":"SUM(F42:L42)+SUM(N42:Q42)","v":0}]
["Prematuros ",null,{"$f":"SUM(F43:H43)","v":0}]
["Alergia a la Proteína de la leche de vaca",null,{"$f":"SUM(F44:L44)","v":0}]
["TOTAL",null,{"$f":"SUM(F45:Q45)","v":0},{"$f":"SUM(D41:D44)","v":0},0,0,0,0,0,0,0,0,{"$f":"M41","v":0},{"$f":"N42","v":0},{"$f":"SUM(O41:O42)","v":0},{"$f":"SUM(P41:P42)","v":0},{"$f":"SUM(Q41:Q42)","v":0}]
["Programas Sociales (*)",null,{"$f":"SUM(F46:Q46)","v":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","Leche Purita Fortificada (LPF)",{"$f":"SUM(D53:O53)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA53&\" \"&AB53","v":" "}]
[null,"Purita +Pro 1",{"$f":"SUM(D54:O54)","v":0}]
[null,"Purita Cereal (PC)",{"$f":"SUM(H55:J55)","v":0}]
[null,"Purita +Pro 2",{"$f":"SUM(I56:J56)","v":0}]
[null,"Purita Mamá (PM)",{"$f":"SUM(M57:O57)+K57","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$AA57&$AB57&$AC57&$AD57","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(K53,K54,K57)=M81,\"\",\" No olvide escribir el Nº Correcto según kg por persona que retira alimento de la sección D en el grupo de Gestantes Normal, Sobrepeso y Obesas.\")","v":""},{"$f":"IF(M54+M53+M57=O81*2,\"\",\"No olvide escribir el Nº Correcto según kg por persona que retira alimento de la sección D en el grupo de Madre con hijo/a menor a 6 meses con Lactancia materna exclusiva\")","v":""},{"$f":"IF(N55+N54+N57=P81,\"\",\"No olvide escribir el Nº Correcto según kg por persona que retira alimento de la sección D en el grupo de Madre con hijo/a menor a 6 meses con Lactancia materna predominante\")","v":""},{"$f":"IF(O55+O54+O57=Q81,\"\",\"No olvide escribir el Nº Correcto según kg por persona que retira alimento de la sección D en el grupo de Madre con hijo/a menor a 6 meses con Fórmula predominantes o exclusiva\")","v":""},null,{"$f":"IF(K57+K54+K53=M81,0,1)","v":0},{"$f":"IF(M54+M53+M57=(O81*2),0,1)","v":0},{"$f":"IF(N53+N54+N57=P81,0,1)","v":0},{"$f":"IF(O57+O53+O54=Q81,0,1)","v":0}]
[null,"Fórmula de Inicio (FI)",{"$f":"SUM(D58:F58)","v":0}]
[null,"Subtotal",{"$f":"SUM(D59:O59)","v":0},{"$f":"SUM(D53:D58)","v":0},{"$f":"SUM(E53:E58)","v":0},{"$f":"SUM(F53:F58)","v":0},{"$f":"SUM(G53:G54)","v":0},{"$f":"SUM(H53:H55)","v":0},{"$f":"SUM(I53:I56)","v":0},{"$f":"SUM(J53:J56)","v":0},{"$f":"SUM(K53:K58)","v":0},{"$f":"SUM(L53:L54)","v":0},{"$f":"SUM(M53:M58)","v":0},{"$f":"SUM(N53:N58)","v":0},{"$f":"SUM(O53:O58)","v":0}]
["Refuerzo","Leche Purita Fortificada (LPF)",{"$f":"SUM(D60:O60)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA60&\" \"&AB60","v":" "}]
[null,"Purita +Pro 1",{"$f":"SUM(D61:O61)","v":0}]
[null,"Purita Cereal (PC)",{"$f":"SUM(H62:J62)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA62&\" \"&AB62&\" \"&AC62&\" \"&AD62","v":"   "}]
[null,"Purita +Pro 2",{"$f":"SUM(I63:J63)","v":0}]
[null,"Mi Sopita (MS)",{"$f":"SUM(E64:J64)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA64&\" \"&AB64&\" \"&AC64&\" \"&AD64&\" \"&AA65&\" \"&AB65","v":"     "}]
[null,"Purita Mamá (PM)",{"$f":"SUM(L65:O65)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AC65&\" \"&AD65","v":" "}]
[null,"Fórmula de Inicio (FI)",{"$f":"SUM(D66:F66)","v":0}]
[null,"Subtotal",{"$f":"SUM(D67:O67)","v":0},{"$f":"SUM(D60:D66)","v":0},{"$f":"SUM(E60:E66)","v":0},{"$f":"SUM(F60:F66)","v":0},{"$f":"SUM(G60:G64)","v":0},{"$f":"SUM(H60:H64)","v":0},{"$f":"SUM(I60:I64)","v":0},{"$f":"SUM(J60:J64)","v":0},{"$f":"SUM(K60:K61)","v":0},{"$f":"SUM(L60:L66)","v":0},{"$f":"SUM(M60:M66)","v":0},{"$f":"SUM(N60:N66)","v":0},{"$f":"SUM(O60:O66)","v":0}]
["Prematuros ","Fórmula de Prematuros (FP)",{"$f":"SUM(D68:F68)","v":0}]
[null,"Fórmula de Incio (FI)",{"$f":"SUM(D69:F69)","v":0}]
[null,"Mi Sopita (MS)",{"$f":"SUM(E70:F70)","v":0}]
[null,"Subtotal",{"$f":"SUM(D71:O71)","v":0},{"$f":"SUM(D68:D70)","v":0},{"$f":"SUM(E68:E70)","v":0},{"$f":"SUM(F68:F70)","v":0},0,0,0,0,0,0,0,0,0]
["Alergia a la proteína de la leche de vaca ","Fórmula Extensamente Hidrolizada (FEH)",{"$f":"SUM(D72:J72)","v":0}]
[null,"Fórmula Aminoacídica (FAA)",{"$f":"SUM(D73:J73)","v":0}]
[null,"Subtotal",{"$f":"SUM(D74:O74)","v":0},{"$f":"SUM(D72:D73)","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Total",null,{"$f":"SUM(D75:O75)","v":0},{"$f":"+D59+D67+D71+D74","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Sección D: PNAC - Número de personas extrasistema que retiran"]
["Subprogramas",null,"Total","Total Hombre","Total Mujer","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(F81:M81)+SUM(O81:Q81)","v":0}]
["Refuerzo",null,{"$f":"SUM(F82:L82)+SUM(N82:Q82)","v":0}]
["Prematuros ",null,{"$f":"SUM(F83:H83)","v":0}]
["Alergia a la Proteína de la leche de vaca ",null,{"$f":"SUM(F84:L84)","v":0}]
["Total",null,{"$f":"SUM(F85:Q85)","v":0},{"$f":"SUM(D81:D84)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M81)","v":0},{"$f":"SUM(N82)","v":0},{"$f":"SUM(O81:O82)","v":0},{"$f":"SUM(P81:P82)","v":0},{"$f":"SUM(Q81:Q82)","v":0}]
["Programas Sociales (*)",null,{"$f":"SUM(F86:Q86)","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: \ndemostra-\nciones, dona-\nciones, etc","Traspaso","Total Egresos"]
[null,null,null,null,null,null,"Intrasistema","Extrasistema","Total"]
["Leche Purita Fortificada (LPF)",null,null,null,null,{"$f":"SUM(C93:E93)","v":0},{"$f":"C13+C20","v":0},{"$f":"+C53+C60","v":0},{"$f":"+G93+H93","v":0},null,null,null,{"$f":"SUM(I93:L93)","v":0},{"$f":"F93-M93","v":0}]
["Purita +Pro 1",null,null,null,null,0,{"$f":"C14+C21","v":0},{"$f":"+C54+C61","v":0},0,null,null,null,0,0]
["Purita Cereal (PC)",null,null,null,null,0,{"$f":"C15+C22","v":0},{"$f":"+C55+C62","v":0},0,null,null,null,0,0]
["Purita +Pro 2",null,null,null,null,0,{"$f":"C16+C23","v":0},{"$f":"+C56+C63","v":0},0,null,null,null,0,0]
["Mi Sopita (MS)",null,null,null,null,0,{"$f":"C24+C30","v":0},{"$f":"+C64+C70","v":0},0,null,null,null,0,0]
["Purita Mamá (PM)",null,null,null,null,0,{"$f":"+C17+C25","v":0},{"$f":"+C57+C65","v":0},0,null,null,null,0,0]
["Fórmula de Inicio (FI)",null,null,null,null,0,{"$f":"C18+C26+C29","v":0},{"$f":"+C58+C66+C69","v":0},0,null,null,null,0,0]
["Fórmula Prematuros",null,null,null,null,0,{"$f":"C28","v":0},{"$f":"C68","v":0},0,null,null,null,0,0]
["Fórmula Extensamente Hidrolizada (FEH)",null,null,null,null,0,{"$f":"C32","v":0},{"$f":"C72","v":0},0,null,null,null,0,0]
["Fórmula aminoacídica (FAA)",null,null,null,null,0,{"$f":"C33","v":0},{"$f":"C73","v":0},0,null,null,null,0,0]
["Total (Kg)",null,{"$f":"SUM(C93:C102)","v":0},{"$f":"SUM(D93:D102)","v":0},{"$f":"SUM(E93:E102)","v":0},{"$f":"SUM(F93:F102)","v":0},{"$f":"SUM(G93:G102)","v":0},0,{"$f":"SUM(I93:I102)","v":0},0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"SUM(A8:Q103)","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(AF1:AI155)","v":0}]

{"sheet":"D16","index":2,"n_rows":205,"n_cols":30,"rows_kept":205,"cut":false,"hidden":false,"merged":[[31,0,32,0],[25,5,25,9],[26,2,27,2],[25,0,27,0],[25,1,27,1],[25,2,25,3],[31,1,31,3],[6,0,6,13],[16,0,17,0],[25,10,27,10],[25,4,27,4],[26,3,27,3],[26,9,27,9],[26,5,27,5],[26,6,27,6],[26,7,27,7],[26,8,27,8],[16,1,16,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:  - (  )"}]
[{"$f":"CONCATENATE(\"AÑO: \",NOMBRE!$B$7)","v":"AÑO: 2023"}]
[]
["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":"$AA10&\" \"&$AB10","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(B10<>C10,\"La cantidad distribuída de Crema Años Dorados es distinta a la cantidad distribuída de Bebida Láctea Años Dorados.- \",\"\")","v":""}]
["65 - 69 años con alteración de la funcionalidad",null,null,{"$f":"$AA11&\" \"&$AB11","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 Crema Años Dorados es distinta a la cantidad distribuída de Bebida Láctea Años Dorados.- \",\"\")","v":""}]
["65 - 69 años en programa social (Vínculos, Familia, Calle u otro)",null,null,{"$f":"$AA12&\" \"&$AB12","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["60 - 69 años con tuberculosis",null,null,{"$f":"$AA13&\" \"&$AB13","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["60 - 69 años en ELEAM autorizado o similar",null,null,{"$f":"$AA14&\" \"&$AB14","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["TOTAL",{"$f":"SUM(B10:B14)","v":0},{"$f":"SUM(C10:C14)","v":0}]
["Sección B: PACAM - Número de personas que retiran"]
["Grupo Programático","Sopa/Crema-Bebida Lactea"]
[null,"Total","Total Hombres","Total Mujeres"]
["70 años y más (independiente del motivo de ingreso",{"$f":"SUM(C19:D19)","v":0},null,null,{"$f":"$Z19","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(((B10+C10)/2)<>(C19+D19),\" 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($C19+$D19=0,\"\",IF($B10+$C10=\"\",IF($C19+$D19=\"\",0,1),\"\"))","v":""},{"$f":"IF(C19+D19=0,\"\",IF(B10+C10=0,\"\",IF(((B10+C10)/2)<>C19+D19,1,0)))","v":""}]
["65 - 69 años con alteración de la funcionalidad",{"$f":"SUM(C20:D20)","v":0},null,null,{"$f":"$Z20","v":""},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)<>(C20+D20),\" 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($C20+$D20=0,\"\",IF($B11+$C11=\"\",IF($C20+$D20=\"\",0,1),\"\"))","v":""},{"$f":"IF(C20+D20=0,\"\",IF(B11+C11=0,\"\",IF(((B11+C11)/2)<>C20+D20,1,0)))","v":""}]
["65 - 69 años en programa social (Vínculos, Familia, Calle u otro)",{"$f":"SUM(C21:D21)","v":0},null,null,{"$f":"$Z21","v":""},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)<>(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(C21+D21=0,\"\",IF(B12+C12=0,\"\",IF(((B12+C12)/2)<>C21+D21,1,0)))","v":""}]
["60 - 69 años con tuberculosis",{"$f":"SUM(C22:D22)","v":0},null,null,{"$f":"$Z22","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(((B13+C13)/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(C22+D22=0,\"\",IF(B13+C13=0,\"\",IF(((B13+C13)/2)<>C22+D22,1,0)))","v":""}]
["60 - 69 años en ELEAM autorizado o similar",{"$f":"SUM(C23:D23)","v":0},null,null,{"$f":"$Z23","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(((B14+C14)/2)<>(C23+D23),\" 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(C23+D23=0,\"\",IF(B14+C14=0,\"\",IF(((B14+C14)/2)<>C23+D23,1,0)))","v":""}]
["TOTAL",{"$f":"SUM(B19:B23)","v":0},{"$f":"SUM(C19:C23)","v":0},{"$f":"SUM(D19:D23)","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: \n(demostraciones, \ndonaciones, etc.)","Traspaso","Total egresos"]
[]
["Sopa/Crema",null,null,null,{"$f":"SUM(B29:D29)","v":0},{"$f":"B15","v":0},null,null,null,{"$f":"SUM(F29:I29)","v":0},{"$f":"E29-J29","v":0}]
["Bebida Láctea",null,null,null,{"$f":"SUM(B30:D30)","v":0},{"$f":"C15","v":0},null,null,null,{"$f":"SUM(F30:I30)","v":0},{"$f":"E30-J30","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 Lactea"]
[null,"Total","Total Hombres","Total Mujeres"]
["70 años y más (independiente del motivo de ingreso",{"$f":"SUM(C34:D34)","v":0}]
["65 - 69 años con alteración de la funcionalidad",{"$f":"SUM(C35:D35)","v":0}]
["65 - 69 años en programa social (Vínculos, Familia, Calle u otro)",0]
["60 - 69 años con tuberculosis",0]
["60 - 69 años en ELEAM autorizado o similar",0]
["TOTAL",{"$f":"SUM(B34:B38)","v":0},{"$f":"SUM(C34:C38)","v":0},{"$f":"SUM(D34:D38)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"SUM(A8:N39)","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":"SUM(AD1:AE204)","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'!A156)=0,\"SIN INFORMACIÓN\",\"\")","v":"SIN INFORMACIÓN"},null,null,null,null,null,null,null,"Feriado Legal"]
[null,null,null,"REM16",{"$f":"IF(('D16'!A205)=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'!AF156","v":0}]
[null,null,null,"TOTAL DE ERRORES REM 16",{"$f":"+'D16'!AD205","v":0}]
[null,null,null,"TOTAL DE ERRORES",{"$f":"SUM(E10:E12)","v":3}]
[]
[]
[]
[]
[null,null,null,null,{"$f":"NOMBRE!AG7","v":5}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"NOMBRE!AG7","v":5}]

{"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\",\"\")","v":"ANTES DE EJECUTAR SUS MACROS REVISE LA HOJA CONTROL, EXISTEN ERRORES"}]
[]
[]
[]
[null,"Contraseña para copia del archivo :DEIS"]