{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Introducción","Medidas para la reapertura","Información sobre las escuelas","Estado reapertura de escuelas","Monto de los recursos","Precios de los recursos","Calculadoras","Financiamiento","Informe","Artículos que se deben adquirir","Data prep","List_Economy","Output"],"not_rendered":{"charts":3,"images":33,"macros":1,"external_links":1,"defined_names":128,"comments":2,"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":"Introducción","index":0,"n_rows":51,"n_cols":16,"rows_kept":51,"cut":false,"hidden":false,"merged":[[22,7,22,9],[22,15,22,17],[50,2,50,17],[19,4,19,5],[20,4,20,5],[21,4,21,5],[22,4,22,5],[21,15,21,17],[19,7,19,9],[20,7,20,9],[19,11,19,13],[41,2,41,17],[26,2,26,17],[37,2,37,4],[38,2,38,17],[19,15,19,17],[21,7,21,9],[6,2,6,17],[0,2,0,17],[1,2,1,17],[5,2,5,17],[13,7,13,9],[13,11,13,13],[13,15,13,17],[11,11,11,13],[11,15,11,17],[13,4,13,5],[11,7,11,9],[7,2,7,17],[14,7,14,9],[14,11,14,13],[16,11,16,13],[15,11,15,13],[14,4,14,5],[15,4,15,5],[16,4,16,5],[15,7,15,9],[16,7,16,9],[17,4,17,5],[18,4,18,5],[18,11,18,13],[20,11,20,13],[17,11,17,13],[17,7,17,9],[18,7,18,9]]}
[" ",null,"Versión 1.0\n22 de noviembre 2021"]
[null,null,"Herramienta de cálculo de costos para planes de reapertura de escuelas"]
[null,null,"Introducción"]
[]
[null,null,"1. ¿Para qué sirve esta herramienta?"]
[null,null,"Propósitos\n i) Identificar los recursos adicionales y la intensidad de uso necesaria para llevar a cabo el plan de reapertura de escuelas;\nii) calcular el costo de estos recursos adicionales y especificar el financiamiento disponible;\niii) evaluar si existe una brecha de financiamiento, y\niv) guiar la implementación del plan de reapertura de escuelas. "]
[null,null,"Destinatarios\nLa información generada por la herramienta le será útil a funcionarios de gobierno, dirigentes escolares, organizaciones y donantes internacionales implicados en la planificación, presupuestación y financiamiento de la reapertura de escuelas durante la pandemia. "]
[null,null,"Usuarios\nSugerimos que las personas que completen las planillas sean funcionarios de gobierno o dirigentes escolares encargados de calcular los presupuestos para la reapertura de escuelas. Normalmente estas personas trabajan en la unidad de presupuesto. Los investigadores, organizaciones internacionales y donantes también pueden utilizar la herramienta para proporcionar asistencia técnica a los gobiernos. "]
[]
[null,null,"2. ¿Cuáles son los componentes de la herramienta?"]
[]
[null,null,null,null,null,null,null,"Propósito de la planilla",null,null,null,"Entrada",null,null,null,"Salida"]
[]
[null,null,null,null,"Introducción",null,null,"Describe el propósito de la herramienta y cómo utilizarla"]
[null,null,null,null,"Medidas previstas para la reapertura",null,null,"Proporciona una lista de las medidas que contribuyen a garantizar la seguridad de las operaciones, mantener el aprendizaje, respaldar el bienestar emocional y llegar a los marginados."]
[null,null,null,null,"Información básica sobre las escuelas",null,null,"Especifica el costo estimado de interés y describe el contexto en el que se aplica el costo estimado.",null,null,null,"Describa el plan de reapertura de escuelas para calcular el costo, especifique qué costo estimado es de interés y proporcione información básica sobre las escuelas."]
[null,null,null,null,"Estado de la reapertura de escuelas",null,null,"Registra el estado previsto de la reapertura de escuelas durante el período en cuestión.",null,null,null,"Ingrese las estimaciones previstas respecto al porcentaje de escuelas que proporcionan clases presenciales y el porcentaje de alumnos que asisten a clases presenciales."]
[null,null,null,null,"Monto de los recursos adicionales",null,null,"Establece los parámetros que afectan el monto de los recursos adicionales necesarios.",null,null,null,"Detalle sus supuestos en torno a la necesidad de recursos y la disponibilidad de los mismos."]
[null,null,null,null,"Calculadoras",null,null,"Facilita el cálculo de las cantidades de algunos recursos en caso de que no tenga los números específicos.",null,null,null,"Detalle sus supuestos en torno a la necesidad de recursos y la disponibilidad de los mismos."]
[null,null,null,null,"Precios de los recursos adicionales",null,null,"Ingresa el monto de recursos adicionales en función de los parámetros especificados en las páginas anteriores y orienta a los usuarios para que especifiquen el precio de cada recurso.",null,null,null,"Indique los precios de los recursos adicionales necesarios.",null,null,null,"El monto de recursos adicionales se genera de manera automática."]
[null,null,null,null,"Financiamiento",null,null,"Define las fuentes de financiamiento.",null,null,null,"Indique el financiamiento disponible de diversas fuentes y el porcentaje de financiamiento sujeto a reasignaciones."]
[null,null,null,null,"Informe",null,null,"Sintetiza el costo de los recursos adicionales necesarios, el financiamiento disponible y la brecha de financiamiento, en caso de existir.",null,null,null,null,null,null,null,"El tablero que sintetiza los resultados se genera de manera automática."]
[null,null,null,null,"Artículos que se deben adquirir",null,null,"Genera una lista de los recursos que deben ser adquiridos.",null,null,null,null,null,null,null,"Se genera una lista con los materiales y equipos que deben adquirirse."]
[]
[null,null,"3. ¿Cómo utilizar la herramienta?"]
[]
[null,null,"1) Habilitar los macros. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"2) Celdas de entrada."]
[null,null,"Siguiendo la barra de navegación, completar las siguientes celdas en la plantilla: \"medidas previstas para la reapertura\", \"información básica sobre las escuelas\", \"estado de la reapertura de escuelas\", \"monto de los recursos adicionales\", \"calculadoras\", \"precios de los recursos adicionales\" y \"financiamiento\". "]
[]
[null,null,"3) Celdas de salida. "]
[null,null,"Las fórmulas están configuradas en las celdas de salida. Cuando mueva el cursor sobre una celda de salida, verá una descripción de la fórmula. De forma predeterminada, estas celdas están bloqueadas para reducir la posibilidad de cambios involuntarios. Usted puede desbloquear estas celdas para personalizar la herramienta en función de sus necesidades. Para desbloquear una plantilla, haga clic en \"Revisar\" -> \"Desproteger hoja\" e ingresar la contraseña cost."]
[]
[null,null,"4. Ayuda"]
[]
[null,null,"Para informar errores, sugerir funciones para agregar o brindar su opinión general para mejorar la herramienta, envíe un comentario ",null,null,null,null,null,null,null,null,null,null,null,null,"aquí. "]
[null,null,"Para cualquier otra pregunta, póngase en contacto con Yilin Pan (ypan@worldbank.org).  "]
[]
[null,null,"5.  ¿Cómo citar esta herramienta?"]
[]
[null,null,"Yilin Pan, Alaka Holla, Nobuyuki Tanaka (2021). \"Herramienta de cálculo de costos para planes de reapertura de escuelas, versión 1.0\". Banco Mundial, Washington, DC."]

{"sheet":"Medidas para la reapertura","index":1,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,null,null,"<Indicar si las medidas aplican a todas las escuelas o a las escuelas reabiertas cuando están codificadas por color>"]
[null,null,"Medidas","Explicación de las medidas","Aplican a","Consecuencias financieras",null," "]
[null,null,"Eje 1:  medidas relacionadas con la seguridad de las operaciones"]
[null,null,"Establecer medidas de limpieza y desinfección","Programar la limpieza periódica de las instalaciones educativas. Limpiar y desinfectar las aulas y los espacios utilizados para la instrucción, espacios comunes, gimnasios, baños, así como superficies que se tocan con frecuencia como picaportes, escritorios, juguetes, insumos, interruptores de luz, marcos de puertas, equipos de juego, material didáctico utilizado por los niños y portadas de los libros. ","Escuelas reabiertas","Aumento en el costo",null,null,"P101"]
[null,null,"Proporcionar equipos de protección personal ","Hacer cumplir la política de la escuela de utilizar una mascarilla o una máscara, en línea con las directrices nacionales o locales. Proporcionar suficientes mascarillas para los alumnos y el personal. Presentarles a los alumnos con problemas sensoriales o sensibilidades táctiles las máscaras que sean más cómodas para ellos. ","Escuelas reabiertas","Aumento en el costo",null,null,"P102"]
[null,null,"Proporcionar materiales para higienizar las manos","Crear una rutina frecuente para la higienización de manos, en especial para los niños pequeños. Asegurarse que las estrategias de lavado de manos incluyan el lavado con agua y jabón durante al menos 20 segundos. Se deben proporcionar estaciones para el lavado o higiene de manos en las entradas de las escuelas y a lo largo de las instalaciones escolares (p. ej., entradas y salidas de los gimnasios e instalaciones deportivas, baños, comedor y aulas). ","Escuelas reabiertas","Aumento en el costo",null,null,"P103"]
[null,null,"Establecer barreras y guías físicas","Instalar barreras físicas como barreras para estornudos y mamparas. Proporcionar guías físicas, como bandas pintadas en el piso o en la acera y señales en las paredes (como guías para generar “vías de un solo sentido” en los pasillos). Agregar barreras físicas, como pantallas de plástico flexible, entre los lavabos del baño, especialmente cuando no están a un mínimo de dos metros de distancia. ","Escuelas reabiertas","Aumento en el costo",null,null,"P108"]
[null,null,"Eje 2: medidas para sostener el aprendizaje"]
[null,null,"Posibilitar el desarrollo profesional de los docentes.","Posibilitar un desarrollo profesional que sea más práctico y orientado a cumplir con ciertas necesidades específicas de instrucción por parte de los docentes, por ejemplo capacitación sobre cómo utilizar computadoras para el dictado de clases. ","Escuelas reabiertas","Aumento en el costo",null,null,"P201"]
[null,null,"Mantener los enfoques flexibles o parciales de aprendizaje remoto","Mantener las prácticas de aprendizaje remoto mediante métodos combinados donde sea necesario y factible (p. ej., algunos grupos de alumnos pueden tomar clases en línea, aprender en casa a través de la asignación de tareas, blogs, realizar actividades físicas en el hogar). Si la educación a distancia no es posible, invitar a los alumnos a llevar sus libros de texto a casa o disponer lo necesario para enviar tareas. Tener en cuenta la emisión de clases por radio o TV, establecer un sistema de tareas escolares en el hogar con la participación de hermanos mayores, o con amigos por teléfono. ","Todas las escuelas, independientemente de su estado de reapertura","Aumento en el costo",null,null,"P202"]
[null,null,"Preparar material impreso de aprendizaje, incluyendo las evaluaciones","Preparar material impreso (fichas, cuadernillos) para los estudiantes.","Escuelas reabiertas","Aumento en el costo",null,null,"P203"]
[null,null,"Eje 3: medidas para apoyar el bienestar y la recuperación emocional"]
[null,null,"Fortalecer el bienestar socioemocional a través de dinámicas","En los países donde las instituciones educativas cuentan con asesores o psicólogos profesionales para atender a los alumnos con necesidades psicosociales, las escuelas deberían estar preparadas ante un incremento de la demanda aumentando el número de asesores o extendiendo el horario de trabajo. Pero en los países donde las escuelas no cuentan con ningún (o pocos) asesor(es), los docentes podrían tener que asumir la responsabilidad de proporcionarles a los alumnos algún tipo de apoyo psicosocial. Fomentar entre los empleados y los alumnos una alimentación sana, ejercitación, sueño adecuado y el tiempo para relajarse. Alentar a los empleados y alumnos para que hablen con personas de su confianza respecto a sus preocupaciones y sentimientos. ","Escuelas reabiertas","Aumento en el costo",null,null,"P301"]
[null,null,"Proporcionar apoyo psicosocial personalizado","Brindar apoyo psicológico a través de un servicio de psicológos itinerante.","Escuelas reabiertas","Aumento en el costo",null,null,"P302"]
[null,null,"Comunicar acerca de la importancia del bienestar socioemocional","Elaborar y reproducir spots radiales con el objetivo de reducir conductas de riesgo entre los estudiantes de la comunidad educativa.","Todas las escuelas, independientemente de su estado de reapertura","Aumento en el costo",null,null,"P303"]
[null,null,"Eje 4: medidas para llegar a los más vulnerables"]
[null,null,"Proporcionar tutoría y apoyo adecuado a las estudiantes embarazadas y/o madres.","Dependiendo del contexto del país, estos incluyen a refugiados, inmigrantes, minorías, aquellos que viven en la pobreza, en áreas geográficamente remotas o en barrios informales urbanos, niños con discapacidades, aquellos que carecen de nutrición y protección, los expuestos al trabajo infantil, violencia u otras condiciones adversas, los que enfrentan cada vez más dificultades y alumnos que no han podido participar del aprendizaje en línea o en el hogar. \nProporcionar instrucciones personalizadas o programas extracurriculares para ayudar a los alumnos con necesidades especiales a ponerse al día, y a no desertar la escuela. ","Escuelas reabiertas","Aumento en el costo",null,null,"P401"]

{"sheet":"Información sobre las escuelas","index":2,"n_rows":84,"n_cols":16,"rows_kept":84,"cut":false,"hidden":false,"merged":[[70,3,70,5],[41,3,41,5],[39,3,39,12],[44,2,44,12],[13,3,13,12],[16,3,16,12]]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,"<Responda a las preguntas y complete las celdas de entrada>"]
[]
[null,null,"Información básica de las escuelas"]
[]
[null,null,"1. País",null,null,"Perú",null,"<Elija el país/economía de la lista desplegable>"]
[]
[null,null,"2. El plan de reapertura de escuelas al que se le debe calcular el costo"]
[]
[null,null,null,"1) Nombre del documento"]
[null,null,null,"Herramienta de costeo para IIEE nodo de Cusco y Ayacucho Horizontes"]
[]
[null,null,null,"2) ¿Cuáles son los niveles educativos abarcados por el plan de reapertura de la escuela?"]
[null,null,null,"1ro a 5to de secundaria"]
[]
[null,null,"3. ¿Cuál es el costo estimado de interés?"]
[]
[null,null,null,"1) ¿Está interesado en estimar el costo de reabrir las escuelas de todo el país, una región/provincia/distrito o una escuela?"]
[]
[null,null,null,null,null,null,null,"<Indicar el nombre del país>"]
[null,null,null,null,null,null,null,"<Indicar el nombre de la región>"]
[null,null,null,null,null,null,null,"<Indicar el nombre de la provincia/estado>"]
[null,null,null,null,null,null,null,"<Indicar el nombre del distrito o el nombre del grupo>"]
[null,null,null,null,null,null,"Moises Moreno Romero","<Indicar el nombre de la escuela>"]
[]
[]
[null,null,null,"2) ¿A qué niveles educativos desea estimarles el costo? Para cada nivel educativo que marque, indique los grados que imparten clases presenciales. "]
[]
[null,null,null,null,null,null,null,"<Indique los grados o grupos etarios>"]
[null,null,null,null,null,null,null,"<Indique los grados>"]
[null,null,null,null,null,null,"1ro-5to","<Indique los grados>"]
[null,null,null,null,null,null,null,"<Indique los grados>"]
[]
[]
[]
[null,null,null,"3) ¿Qué período de tiempo abarca el costo estimado: p. ej., enero-diciembre 2021, el primer semestre de 2021, el primer trimestre de 2021, el año académico 2021-2022?"]
[null,null,null,2022]
[]
[null,null,null,{"$f":"\"Cantidad de días de escuela en el periodo de interés, por ejemplo: \"&LOWER(D40)&\"\"","v":"Cantidad de días de escuela en el periodo de interés, por ejemplo: 2022"},null,null,180,"días"]
[null,null,null,"Cantidad de días de escuela en un año académico",null,null,180,"días"]
[]
[null,null,{"$f":"\"4. Estadísticas básicas de los niveles educativos de interés (i.e., \"&IF(Output!D3=TRUE,Output!D4,\"\")&\" \"&IF(Output!E3=TRUE,Output!E4,\"\")&\" \"&IF(Output!F3=TRUE,Output!F4,\"\")&\" \"&IF(Output!G3=TRUE,Output!G4,\"\")&\" ) \"&IF(F9 = \"\", \"\", \"in \"&CHOOSE(Output!C3,Output!C4,Output!C5,Output!C6,Output!C7,Output!C8)&\"\") &\"\"","v":"4. Estadísticas básicas de los niveles educativos de interés (i.e.,   educación secundaria,  ) in Moises Moreno Romero"}]
[]
[null,null,null,"Alumnos, escuelas y clases",null,null,null,null,null,null,null,"            "]
[null,null,null,"Cantidad de alumnos",null,null,null,"<Indique el número total de estudiantes>"]
[null,null,null,"Cantidad de escuelas",null,null,1,"<Indique el número de escuelas>",null,"Escuelas privadas incluidas "]
[null,null,null,"Cantidad de clases",null,null,null,"<Indique el número total de aulas>"]
[]
[null,null,null,"Cantidad de alumnos por escuela",null,null,{"$f":"IF(ISERROR(N_student/N_school), \"\", N_student/N_school)","v":0}]
[null,null,null,"Cantidad de alumnos por clase",null,null,{"$f":"IF(ISERROR(N_student/N_class), \"\", N_student/N_class)","v":""}]
[null,null,null,"Cantidad de casos de embarazo adolescente"]
[]
[]
[null,null,null,null,null,null,"Total",null,"Disponible actualmente","Recién incorporados"]
[null,null,null,"Docentes y personal escolar",null,null,{"$f":"SUM(N_teacher, N_management_staff, N_teaching_aid, N_cleaner, N_nurse, N_food_staff, N_technician, N_psychologist, N_other_staff)","v":0},null,{"$f":"SUM(N_teacher_current, N_management_staff_current, N_teaching_aid_current, N_cleaner_current, N_nurse_current, N_food_staff_current, N_technician_current, N_psychologist_current, N_other_staff_current)","v":0},{"$f":"SUM(N_newly_hired_teacher, N_newly_hired_management_staff, N_newly_hired_teaching_aid, N_newly_hired_cleaner, N_newly_hired_nurse, N_newly_hired_food_staff, N_newly_hired_technician, N_newly_hired_psychologist, N_newly_hired_other_staff)","v":0}]
[null,null,null,"Cantidad de docentes (nombrados o contratados)",null,null,{"$f":"N_teacher_current + N_newly_hired_teacher","v":0}]
[null,null,null,"Cantidad de personal administrativo",null,null,{"$f":"N_management_staff_current + N_newly_hired_management_staff","v":0}]
[null,null,null,"Cantidad de auxiliares pedagógicos",null,null,{"$f":"N_teaching_aid_current + N_newly_hired_teaching_aid","v":0}]
[null,null,null,"Cantidad de personal no docente"]
[null,null,null,"Personal de limpieza",null,null,{"$f":"N_cleaner_current + N_newly_hired_cleaner","v":0}]
[null,null,null,"Enfermeras escolares",null,null,{"$f":"N_nurse_current + N_newly_hired_nurse","v":0}]
[null,null,null,"Personal de cocina",null,null,{"$f":"N_food_staff_current + N_newly_hired_food_staff","v":0}]
[null,null,null,"Personal de apoyo técnico",null,null,{"$f":"N_technician_current + N_newly_hired_technician","v":0}]
[null,null,null,"Psicólogos",null,null,0]
[null,null,null,"Otros",null,null,{"$f":"N_other_staff_current + N_newly_hired_other_staff","v":0}]
[]
[]
[null,null,null,"Cantidad de docentes que trabajan junto a los alumnos con necesidades especiales",null,null,{"$f":"IF(ISERROR(N_teacher * (N_student_teen_pregnancy/N_student)), \"\", N_teacher * (N_student_teen_pregnancy/N_student))","v":""},"<La configuración predeterminada asume que esta cifra es proporcional al número de alumnos con necesidades especiales>"]
[]
[null,null,null,"Evaluaciones de diagnóstico",null,null,null,null,null,null,null,null,null,null,null,203]
[null,null,null,"Porcentaje de estudiantes que necesitan ser evaluados"]
[]
[null,null,null,"Instalaciones"]
[null,null,null,"¿Cuántos salones de clase comparten un baño?",null,null,null,"<Dividir el número total de aulas en una escuela entre el número de servicios higiénicos>"]
[null,null,null,"¿Los docentes de cuántos salones de clase comparten una oficina?"]
[]
[null,null,"5. ¿En qué moneda se expresa el costo? ",null,null,null,"Soles"]
[]
[null,null,"6. ¿En qué año desea expresar el costo?",null,null,null,2022]
[]
[null,null,null,"."]

{"sheet":"Estado reapertura de escuelas","index":3,"n_rows":25,"n_cols":18,"rows_kept":25,"cut":false,"hidden":false,"merged":[[15,2,15,6],[7,2,7,18],[8,17,8,18],[18,2,18,18],[17,2,17,18],[11,2,11,6]]}
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"\"Estado de reapertura de las escuelas durante \"&LOWER('Información sobre las escuelas'!D40)&\"\"","v":"Estado de reapertura de las escuelas durante 2022"}]
[null,null,"<Si las escuelas o los alumnos regresan a clases presenciales de forma escalonada, indique el porcentaje de escuelas que imparten clases presenciales, el porcentaje de alumnos que asisten a clases presenciales y el número de días de escuela para cada etapa. Caso contrario, solo complete los tres parámetros de la Fase 1.>"]
[null,null,null,null,null,null,null,"Fase 1",null,"Fase 2",null,"Fase 3",null,"Fase 4",null,"Fase 5",null,{"$f":"\"Promedio durante \"&LOWER('Información sobre las escuelas'!D40)&\"\"","v":"Promedio durante 2022"}]
[null,null,"Porcentaje de escuelas que imparten clases presenciales",null,null,null,null,1,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR((pct_school_reopen_phase1 * N_school_day_phase1 + pct_school_reopen_phase2 * N_school_day_phase2 + pct_school_reopen_phase3 * N_school_day_phase3 + pct_school_reopen_phase4 * N_school_day_phase4 + pct_school_reopen_phase5 * N_school_day_phase5)/(N_school_day_phase1 + N_school_day_phase2 + N_school_day_phase3 + N_school_day_phase4 + N_school_day_phase5)), \"\", (pct_school_reopen_phase1 * N_school_day_phase1 + pct_school_reopen_phase2 * N_school_day_phase2 + pct_school_reopen_phase3 * N_school_day_phase3 + pct_school_reopen_phase4 * N_school_day_phase4 + pct_school_reopen_phase5 * N_school_day_phase5)/(N_school_day_phase1 + N_school_day_phase2 + N_school_day_phase3 + N_school_day_phase4 + N_school_day_phase5))","v":1}]
[]
[null,null,"Porcentaje de alumnos que asisten a clases presenciales",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF( ISERROR((pct_student_in_school_phase1 * N_school_day_phase1 + pct_student_in_school_phase2 * N_school_day_phase2 + pct_student_in_school_phase3 * N_school_day_phase3 + pct_student_in_school_phase4 * N_school_day_phase4 + pct_student_in_school_phase5 * N_school_day_phase5)/(N_school_day_phase1 + N_school_day_phase2 + N_school_day_phase3 + N_school_day_phase4 + N_school_day_phase5)), \"\", (pct_student_in_school_phase1 * N_school_day_phase1 + pct_student_in_school_phase2 * N_school_day_phase2 + pct_student_in_school_phase3 * N_school_day_phase3 + pct_student_in_school_phase4 * N_school_day_phase4 + pct_student_in_school_phase5 * N_school_day_phase5)/(N_school_day_phase1 + N_school_day_phase2 + N_school_day_phase3 + N_school_day_phase4 + N_school_day_phase5))","v":0}]
[]
[null,null,"Cantidad de días de escuela (en días)*",null,null,null,null,180]
[]
[null,null,"Porcentaje de docentes y personal escolar presente en la escuela**",null,null,null,null,{"$f":"H10","v":1},null,{"$f":"J10","v":0},null,{"$f":"L10","v":0},null,{"$f":"N10","v":0},null,{"$f":"P10","v":0},null,{"$f":"IF(ISERROR((pct_teacher_staff_in_school_phase1*N_school_day_phase1+pct_teacher_staff_in_school_phase2*N_school_day_phase2+pct_teacher_staff_in_school_phase3*N_school_day_phase3+pct_teacher_staff_in_school_phase4*N_school_day_phase4+pct_teacher_staff_in_school_phase5*N_school_day_phase5)/(N_school_day_phase1+N_school_day_phase2+N_school_day_phase3+N_school_day_phase4+N_school_day_phase5)),\"\",(pct_teacher_staff_in_school_phase1*N_school_day_phase1+pct_teacher_staff_in_school_phase2*N_school_day_phase2+pct_teacher_staff_in_school_phase3*N_school_day_phase3+pct_teacher_staff_in_school_phase4*N_school_day_phase4+pct_teacher_staff_in_school_phase5*N_school_day_phase5)/(N_school_day_phase1+N_school_day_phase2+N_school_day_phase3+N_school_day_phase4+N_school_day_phase5))","v":1}]
[]
[null,null,{"$f":"\"<*El numero de días de escuela en todas las fases debe sumar \"&N_school_days&\".>\"","v":"<*El numero de días de escuela en todas las fases debe sumar 180.>"}]
[null,null,"<** La configuración predeterminada asume que la cantidad de docentes y personal escolar presente en la escuela es proporcional al número de escuelas que imparten clases presenciales. Usted puede revisar esta cifra en base a su contexto. Por ejemplo, si es más probable que reabran las escuelas más grandes, el porcentaje de docentes y personal escolar presente en la escuela debería ser más elevado que el porcentaje de escuelas que imparten clases presenciales. Si solo son algunos grados los que regresan a clases presenciales en estas escuelas reabiertas, el porcentaje de docentes y personal escolar presente en la escuela debe aproximarse al porcentaje de alumnos que asiste a clases presenciales.>"]
[]
[]
[]
[]
[null,null,"Conteo de palabras"]
[null,null,{"$f":"SUM(IF(LEN(TRIM(B1:T21))=0,0,LEN(TRIM(B1:T21))-LEN(SUBSTITUTE(B1:T21,\" \",\"\"))+1))","v":237}]

{"sheet":"Monto de los recursos","index":4,"n_rows":63,"n_cols":10,"rows_kept":63,"cut":false,"hidden":false,"merged":[[59,2,60,2],[27,3,28,3],[23,2,25,2],[26,2,33,2],[34,2,39,2],[30,3,31,3],[32,3,33,3],[34,3,35,3],[36,3,37,3],[48,3,49,3],[42,2,49,2],[50,2,53,2],[55,2,57,2],[42,3,43,3],[44,3,45,3],[6,4,6,5],[16,3,17,3],[8,2,22,2],[9,3,10,3],[11,3,12,3],[13,3,14,3],[18,3,19,3],[21,3,22,3]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,"<Verifique si la configuración predeterminada tiene sentido para usted. Caso contrario, modifique según su contexto.>"]
[null,null,"Medidas verificadas","Recursos adicionales","Configuración de los parámetros",null,"Notas"]
[null,null,"Eje 1: medidas relacionadas con la seguridad de las operaciones"]
[null,null,"Establecer medidas de limpieza y desinfección","Desinfectante",null,"Ver Calculadora 1 para más detalles","1L por escuela x semana",null,null,"P101"]
[null,null,null,"Contenedores vacíos para diluir los productos de limpieza y desinfección",null,"contenedor(es) por personal de limpieza (objetivo)"]
[null,null,null,null,null,"contenedor(es) por personal de limpieza (disponibles ahora)","<Indicar la cantidad que dispone ahora>"]
[null,null,null,"Pulverizadores, atomizadores o rociadores para desinfectar",null,"pulverizador(es) por personal de limpieza (objetivo)"]
[null,null,null,null,null,"pulverizador(es) por personal de limpieza (disponibles ahora)","<Indicar la cantidad que dispone ahora>"]
[null,null,null,"Trapeadores, baldes y cepillos",null,"equipo(s) por aula/baño/oficina (objetivo)"]
[null,null,null,null,null,"equipo(s) por aula/baño/oficina (disponibles ahora)","<Indicar la cantidad que dispone ahora>"]
[null,null,null,"Barras de jabón",null,"barra(s) de jabón por lavabo/lavatorio"]
[null,null,null,"Agua",{"$f":"MAX(IF(Calculadoras!I36 = 0, Calculadoras!I35, Calculadoras!I35/(Calculadoras!I36/5)), IF(Calculadoras!I69 = 0, Calculadoras!I68, Calculadoras!I68/Calculadoras!I69)) - 1","v":-1},"veces más que la cantidad usada en la etapa pre COVID-19","El aumento en el uso de agua se debe más que nada a una mayor frecuencia de limpieza y lavado de manos. Por ejemplo, si la limpieza se realizaba de forma semanal en la etapa pre COVID-19, pero en la etapa COVID-19 se lleva a cabo de manera diaria, entonces se necesita cuatro veces más agua (1 / (1/5) - 1). Si se les exigía a los alumnos lavarse las manos dos veces al día en la etapa pre COVID-19, pero ahora son cinco veces, entonces se necesita 1,5 veces más agua (5/2 - 1). El valor predeterminado es la cifra más elevada entre estas dos relaciones. "]
[null,null,null,null,null,"barril de agua por escuela por día"]
[null,null,null,"Guantes de jebe/goma para el personal de limpieza",null,"par(es) por personal de limpieza (objetivo)"]
[null,null,null,null,null,"par(es) por personal de limpieza (disponibles ahora)","<Indicar la cantidad que dispone ahora>"]
[null,null,null,"Mandil desechable para el personal de limpieza",null,"mandil(es) por personal de limpieza por día"]
[null,null,null,"Mamelucos y gorras reutilizables para el personal de limpieza",null,"conjunto(s) por personal de limpieza (objetivo)","Un par por aula y un par por baño por limpiador."]
[null,null,null,null,null,"conjunto(s) por personal de limpieza (disponibles ahora)"]
[null,null,"Proporcionar equipos de protección personal ","Mascarillas reutilizables",null,"Ver Calculadora 3.1 para más detalles",null,null,null,"P102"]
[null,null,null,"Mascarillas desechables",null,"Ver Calculadora 3.2 para más detalles"]
[null,null,null,"Protector facial",null,"máscaras faciales por docente o personal escolar"]
[null,null,"Proporcionar materiales para higienizar las manos","Alcohol en gel (con alcohol al 60% como mínimo) o alcohol puro al 70%",null,"Ver Calculadora 2.1 para más detalles",null,null,null,103]
[null,null,null,"Dispensadores antisépticos",null,"dispensador(s) por aula/baño/oficina (objetivo)"]
[null,null,null,null,null,"dispensador(s) por aula/baño/oficina (disponibles ahora)"]
[null,null,null,"Jabón líquido",null,"Ver Calculadora 2.2 para más detalles"]
[null,null,null,"Papel toalla",null,"rollo(s) por persona (incluidos docentes, alumnos y personal escolar) por mes (20 días de escuela) (objetivo)"]
[null,null,null,null,null,"rollo(s) por persona (incluidos docentes, alumnos y personal escolar) por mes (20 días de escuela) (disponibles ahora)","<Indicar la cantidad que dispone ahora>"]
[null,null,null,"Tachos de basura sin contacto (a pedal)",null,"bote(s) de basura por aula"]
[null,null,null,null,null,"bote(s) de basura (disponibles ahora)","<Indicar la cantidad que dispone ahora>"]
[null,null,"Establecer barreras y guías físicas","Barreras físicas en las aulas",null,"Pantalla(s) de plástico flexible por alumno",null,null,null,"P108"]
[null,null,null,null,null,"de todas las escuelas reabiertas eligen instalar las barreras físicas"]
[null,null,null,"Barreras físicas entre los lavatorios del baño",null,"lavabo(s) por baño"]
[null,null,null,null,null,"de todas las escuelas reabiertas eligen instalar las barreras físicas"]
[null,null,null,"Cintas para crear señales en los pisos y aceras",null,"rollo(s) de cinta por escuela"]
[null,null,null,"Carteles o señales en las paredes",null,"cartel(es) por escuela"]
[null,null,"Eje 2: medidas para sostener el aprendizaje"]
[null,null,"Posibilitar el desarrollo profesional de los docentes.","Materiales para la capacitación profesional de los docentes",null,"conjunto(s) por docente",null,null,null,"P201"]
[null,null,"Mantener los enfoques flexibles o parciales de aprendizaje remoto","Compensación para acceder a Internet",null,"de todos los docentes reciben compensación para acceder a Internet",null,null,null,"P202"]
[null,null,null,null,null,"de todos los alumnos reciben compensación para acceder a Internet"]
[null,null,null,"Compensación para planes de datos de los teléfonos celulares",null,"de todos los docentes reciben compensación para planes de datos de los teléfonos celulares"]
[null,null,null,null,null,"de todos los alumnos reciben compensación para planes de datos de los teléfonos celulares"]
[null,null,null,"Teléfonos móviles",null,"teléfonos","Los equipos electrónicos podrían focalizarse en las estudiantes afectadas a manera de préstamo y bajo condición de buen rendimiento "]
[null,null,null,"Access point",null,"access point(s) por escuela"]
[null,null,null,"Traslado a centros comunitarios con acceso a internet",null,"% de docentes y estudiantes que reciben esta asignación"]
[null,null,null,null,null,"viaje por semana","Servicio de movilidad para los docentes y/o estudiantes que no acceden a internet y deben trasladarse a tambos, zonas próximas con conectividad u otro establecimiento para acceder a internet"]
[null,null,"Preparar material impreso de aprendizaje, incluyendo las evaluaciones","Insumo de corte, espiralado y enmicado",null,"Paquete de corte, espiralado y enmicado por escuela","Incluye: \n1 espiraladora para A4 y oficio\n1 guillotina A4\n1 ciento de espirales de 7 mm para 25 hojas\n1 ciento de espirales de 9 mm para 50 hojas\n1 ciento de micas para anillado ",null,null,"P203"]
[null,null,null,"Fotocopiadora",null,"Fotocopiadora por escuela","La fotocopiadora y tinta podrían focalizarse en las escuelas nodo, al mismo tiempo que sirven como centro de servicio para el resto."]
[null,null,null,"Papel  ",null,"Paquete de hojas bond x500 por aula por mes"]
[null,null,null,"Tinta ",null,"Paquete de tinta negra por escuela por mes"]
[null,null,"Eje 3: medidas para apoyar el bienestar y la recuperación emocional"]
[null,null,"Proporcionar apoyo y asesoramiento psicosocial exclusivo.","Desarrollo y/o curación de contenido socioemocional para estudiantes, docentes y familias",null,"Servicio de desarrollo y/o curación de contenido socioemocional (independiente del número de escuelas)",null,null,null,"P301"]
[null,null,null,"Material didáctico para docentes",null,"Paquete de material por docente","Incluye: \n6 papelotes (o papelografos)\n1 paquete de plumones o colores\n1 cuaderno de emociones\n1 madeja de lana o hilo, u otro material similar"]
[null,null,null,"Material didáctico para estudiantes y familias",null,"Paquete de material por hogar","Incluye: \n6 papelotes (o papelografos)\n1 paquete de plumones o colores\n6 hojas de colores\n1 madeja de lana o hilo, u otro material similar"]
[null,null,"Proporcionar apoyo psicosocial personalizado","Contratación de psicólogo/a",null,"Psicólogo/a cada 5 II.EE","Costo de honorarios: s/ 2,500 X mes\nEl profesional visitará 2-3 escuelas por semana (dependiendo de la distancia). Cada escuela recibe 2 visitas al mes."]
[null,null,"Comunicar acerca de la importancia del bienestar socioemocional","Elaboración de spot radial (1 minuto)",null,"Spot nuevo cada dos semanas"]
[null,null,null,"Difusión del spot radial",null,"avisos diarios, de Lunes a Viernes"]
[null,null,"Eje 4: medidas para llegar a los más vulnerables"]
[null,null,"Llevar a cabo campañas de apoyo envolvente para evitar la deserción para estudiantes embarazadas y con hijos pequeños","Gastos de transporte para prestación del servicio en casa",null,"Servicio de movilidad por estudiante afectada por semana (para que la estudiante reciba clases en su domicilio) + seguimiento de clases remotas","Los equipos electrónicos podrían focalizarse en las estudiantes afectadas a manera de préstamo y bajo condición de buen rendimiento ",null,null,"P401"]

{"sheet":"Precios de los recursos","index":5,"n_rows":51,"n_cols":10,"rows_kept":51,"cut":false,"hidden":false,"merged":[[13,3,14,3],[46,2,47,2],[42,2,44,2],[8,2,17,2],[18,2,20,2],[21,2,25,2],[26,2,29,2],[32,2,36,2],[37,2,40,2]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"<Ingresar el precio de cada recurso>"]
[null,null,"Medidas verificadas","Recursos adicionales","Cantidad","Unidad",{"$f":"\"Precio \"&IF('Información sobre las escuelas'!G80=\"\",\"\",\"(en \"&'Información sobre las escuelas'!G80&\")\"&\"\")","v":"Precio (en Soles)"},{"$f":"\"Presupuesto adicional\"","v":"Presupuesto adicional"}]
[null,null,"Eje 1: medidas relacionadas con la seguridad de las operaciones"]
[null,null,"Establecer medidas de limpieza y desinfección","Desinfectante (1L)",{"$f":"Disinfectant_per_school_per_day_gap * (N_school * pct_school_reopen) * N_school_days","v":{"$error":"#VALUE!"}},"litro(s)",null,{"$f":"E9*G9","v":{"$error":"#VALUE!"}},null,"P101"]
[null,null,null,"Contenedores vacíos para diluir los productos de limpieza y desinfección",{"$f":"N_container_per_cleaner * N_newly_hired_cleaner + (N_container_per_cleaner - N_container_per_cleaner_current) * N_cleaner_current * pct_teacher_staff_in_school","v":0},"pieza(s)",null,{"$f":"E10*G10","v":0}]
[null,null,null,"Pulverizador (1.5L)",{"$f":"N_sprayer_per_cleaner * N_newly_hired_cleaner + (N_sprayer_per_cleaner - N_sprayer_per_cleaner_current) * N_cleaner_current * pct_teacher_staff_in_school","v":0},"pieza(s)",null,0]
[null,null,null,"Trapeadores, baldes y cepillos",{"$f":"(N_mop_per_room - N_mop_per_room_current) * N_school * pct_school_reopen * N_room_per_school","v":{"$error":"#VALUE!"}},"conjunto(s)",null,{"$error":"#VALUE!"}]
[null,null,null,"Barras de jabón",{"$f":"N_soap_bar_per_room * N_room_per_school * N_school * pct_school_reopen","v":{"$error":"#VALUE!"}},"pieza(s)",null,{"$error":"#VALUE!"}]
[null,null,null,"Agua",{"$f":"Water_multiplier * N_school * pct_school_reopen","v":-1},"vez/veces x escuela(s)",null,0]
[null,null,null,null,{"$f":"'Monto de los recursos'!E18*N_school_days*N_school *pct_school_reopen","v":0},"barril(es) x escuela por todo el segundo semestre",null,{"$f":"G15*E15","v":0}]
[null,null,null,"Guantes de jebe/goma para el personal de limpieza",{"$f":"N_glove_per_cleaner * N_newly_hired_cleaner + (N_glove_per_cleaner - N_glove_per_cleaner_current) * N_cleaner_current * pct_teacher_staff_in_school","v":0},"par(es)",null,0]
[null,null,null,"Mandiles desechables para el personal de limpieza",{"$f":"N_disposable_gown_per_cleaner_per_day * N_cleaner * pct_teacher_staff_in_school * N_school_days","v":0},"conjunto(s)",null,0]
[null,null,null,"Mamelucos y gorras reutilizables para el personal de limpieza",{"$f":"N_reusable_gown_per_cleaner * N_newly_hired_cleaner + (N_reusable_gown_per_cleaner - N_reusable_gown_per_cleaner_current) * N_cleaner_current * pct_teacher_staff_in_school","v":0},"conjunto(s)",null,0]
[null,null,"Proporcionar equipos de protección personal ","Mascarillas reutilizables",{"$f":"N_reusable_mask","v":0},"pieza(s)",null,0,null,"P102"]
[null,null,null,"Mascarillas desechables",{"$f":"N_disposable_mask","v":0},"pieza(s)",null,0]
[null,null,null,"Protector facial",{"$f":"N_shield_per_teacher_staff * N_teacher_and_staff * pct_teacher_staff_in_school","v":0},"pieza(s)",null,0]
[null,null,"Proporcionar materiales para higienizar las manos","Alcohol en gel (con alcohol al 60% como mínimo) o alcohol puro al 70% (1L)",{"$f":"Antiseptic_per_person_per_day_gap * (N_student * pct_student_in_school + N_teacher_and_staff * pct_teacher_staff_in_school) * N_school_days/1000","v":0},"litro(s)",null,0,null,"P103"]
[null,null,null,"Dispensador de gel",{"$f":"(N_antiseptic_dispenser_per_room - N_antiseptic_dispenser_per_room_current) * N_room_per_school * N_school * pct_school_reopen","v":{"$error":"#VALUE!"}},"pieza(s)",null,{"$error":"#VALUE!"}]
[null,null,null,"Jabón líquido (800 - 900 ml)",{"$f":"Liquid_soap_per_person_per_day_gap * (N_student * pct_student_in_school + N_teacher_and_staff * pct_teacher_staff_in_school) * N_school_days/1000","v":0},"empaque(s)",null,0]
[null,null,null,"Papel toalla",{"$f":"(N_paper_towel_per_person_per_month - N_paper_towel_per_person_per_month_current)/20 * (N_student * pct_student_in_school + N_teacher_and_staff * pct_teacher_staff_in_school) * N_school_days","v":0},"rollo(s)",null,0]
[null,null,null,"Tachos de basura sin contacto/a pedal",{"$f":"(N_trash_can_per_room - N_trash_can_per_room_current) * N_room_per_school * N_school * pct_school_reopen","v":{"$error":"#VALUE!"}},"pieza(s)",null,{"$error":"#VALUE!"}]
[null,null,"Establecer barreras y guías físicas","Barreras físicas en las aulas",{"$f":"N_physical_screen_per_student * N_student_per_school * (N_school * pct_school_reopen * pct_school_classroom_barrier)","v":0},"pieza(s)",15,0,null,"P108"]
[null,null,null,"Barreras físicas entre los lavaderos del baño",{"$f":"(N_sink_per_restroom - 1) * ROUNDUP(N_class/N_school/Classroom_restroom_ratio, 0) * (N_school * pct_school_reopen * pct_school_restroom_barrier)","v":{"$error":"#DIV/0!"}},"pieza(s)",30,{"$error":"#DIV/0!"}]
[null,null,null,"Cintas para crear señales en los pisos y aceras (rollo de 24 ml y 18 metros)",{"$f":"N_tape_per_school * N_school * pct_school_reopen","v":0},"rollo(s)",3.4,0]
[null,null,null,"Carteles o señales en las paredes",{"$f":"N_poster_per_school * N_school * pct_school_reopen","v":0},"cartel(es)",5,0]
[null,null,"Eje 2: medidas para sostener el aprendizaje"]
[null,null,"Posibilitar el desarrollo profesional de los docentes.","Materiales de capacitación",{"$f":"N_PD_materials_per_teacher * N_teacher","v":0},"conjunto(s)",null,0,null,"P201"]
[null,null,"Mantener los enfoques flexibles o parciales de aprendizaje remoto","Compensación para acceder a Internet",{"$f":"(pct_teacher_internet * N_teacher + pct_student_internet * N_student) * ROUNDUP((N_school_days/20), 0)","v":0},"persona(s) por meses",null,0,null,"P202"]
[null,null,null,"Compensación para planes de datos de los teléfonos celulares",{"$f":"(pct_teacher_data_plan * N_teacher + pct_student_data_plan * N_student) * ROUNDUP((N_school_days/20), 0)","v":0},"persona(s) por meses",null,0]
[null,null,null,"Teléfonos",{"$f":"N_phone","v":0},"dispositivo(s)",null,0]
[null,null,null,"Access point (+ instalación y mantenimiento 1er año)",{"$f":"'Monto de los recursos'!E48 * N_school","v":0},"dispositivo(s)",null,0]
[null,null,null,"Traslado a centros comunitarios con acceso a internet",{"$f":"'Monto de los recursos'!E49 * (N_student * (1 - pct_student_in_school) + N_teacher * (1 - pct_teacher_staff_in_school)) * 'Monto de los recursos'!E50 * N_school_days / 5","v":0},"servicio(s) de traslado semanal ",null,{"$f":"G37*E37","v":0}]
[null,null,"Preparar material impreso de aprendizaje, incluyendo las evaluaciones","Insumo de corte, espiralado y enmicado",{"$f":"N_page_assessment*N_school","v":0},"paquetes",null,0,null,"P203"]
[null,null,null,"Fotocopiadora (+instalación y mantenimiento 1er año)",{"$f":"'Monto de los recursos'!E52*N_school","v":0},"equipo",null,0]
[null,null,null,"Papel  ",{"$f":"'Monto de los recursos'!E53 * N_school * N_school_days / 20","v":0},"paquetes x 500 ",null,0]
[null,null,null,"Tinta ",{"$f":"N_tinta_per_school_per_month*N_school*N_school_days / 20","v":0},"pieza(s) por escuela",null,0]
[null,null,"Eje 3: medidas para apoyar el bienestar y la recuperación emocional",null,null,null,null,{"$f":"E42*G42","v":0}]
[null,null,"Proporcionar apoyo y asesoramiento psicosocial exclusivo.","Desarrollo y/o curación de contenido socioemocional para estudiantes, docentes y familias",1,"Servicio de desarrollo y/o curación de contenido socioemocional (independiente del número de escuelas)",null,0,null,"P301"]
[null,null,null,"Material didáctico para docentes",{"$f":"N_psychology_training_package_per_staff*(N_teacher+N_management_staff+N_teaching_aid)","v":0},"paquete de material por docente",null,0]
[null,null,null,"Material didáctico para estudiantes y familias",{"$f":"N_psychology_training_package_per_student*N_student","v":0},"paquete de material por hogar",null,0]
[null,null,"Proporcionar apoyo psicosocial personalizado","Contratación de psicólogo/a",{"$f":"(N_school_days/20)","v":9},"meses",null,{"$f":"G46*E46","v":0}]
[null,null,"Comunicar acerca de la importancia del bienestar socioemocional","Elaboración de 1 spot radial cada 2 semanas (1 minuto)",{"$f":"(N_school_days/5)/2","v":18},"spots radionales elaborados",null,{"$f":"G47*E47","v":0}]
[null,null,null,"Difusión del spot radial por toda la semana (3 veces al día, 5 días de la semana)",{"$f":"N_school_days/5","v":36},"semanas de difusión",null,{"$f":"G48*E48","v":0}]
[null,null,"Eje 4: medidas para llegar a los más vulnerables"]
[null,null,"Llevar a cabo campañas de apoyo envolvente para evitar la deserción para estudiantes embarazadas y con hijos pequeños","Gastos de transporte para prestación del servicio en casa",{"$f":"N_enrollment_campaign_trips*N_student_teen_pregnancy*N_school_days/5","v":0},"conjunto(s)",null,0,null,"P401"]
[null,null,null,null,null,null,1]

{"sheet":"Calculadoras","index":6,"n_rows":107,"n_cols":18,"rows_kept":107,"cut":false,"hidden":false,"merged":[[38,3,38,7],[31,11,31,17],[39,3,39,7],[18,11,18,17],[26,11,26,17],[26,3,26,7],[24,11,24,17],[18,3,18,7],[24,3,24,7],[82,2,82,17],[54,4,54,7],[55,4,55,7],[65,4,65,7],[66,4,66,7]]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"<Completar las celdas de entrada>"]
[]
[null,null,"Calculadoras"]
[]
[null,null,"Índice"]
[]
[null,null,null,{"$f":"C16","v":"Calculadora 1. Cómo calcular la cantidad de desinfectante necesario"}]
[null,null,null,{"$f":"C52","v":"Calculadora 2. Cómo calcular la cantidad de antiséptico y jabón líquido para el lavado de manos"}]
[null,null,null,{"$f":"C80","v":"Calculadora 3. Cómo calcular la cantidad de mascarillas"}]
[]
[]
[null,null,"Calculadora 1. Cómo calcular la cantidad de desinfectante necesario"]
[]
[null,null,null,"Para una escuela típica"]
[null,null,null,"Factor 1: Áreas que deben ser desinfectadas mediante pulverizador",null,null,null,null,{"$f":"IF(ISERROR(I25*N_room_per_school) = TRUE, \"\", I25*N_room_per_school)","v":""},"metro(s) cuadrado(s)",null,"<Este es un cálculo conservador dado que asumimos que una vez que la escuela reabre, todas sus instalaciones deben ser desinfectadas, independientemente de cuántos alumnos asisten a la escuela.>"]
[]
[null,null,null,"Superficie de un salón de clases típico"]
[null,null,null,"Largo del piso en un salón de clases típico",null,null,null,null,4,"metro(s)",null,"<Ingresar dato>"]
[null,null,null,"Ancho del piso en un salón de clases típico",null,null,null,null,3,"metro(s)",null,"<Ingresar dato>"]
[null,null,null,"Superficie del piso en un salón de clases típico",null,null,null,null,{"$f":"I22*I23","v":12},"metro(s) cuadrado(s)",null,"<Largo x ancho>"]
[null,null,null,"Superficie del salón de clases (incluidos paredes, piso y techo)",null,null,null,null,{"$f":"2.5*I24","v":30},"metro(s) cuadrado(s)",null,"<La regla general es 2,5 veces la superficie del piso>"]
[]
[null,null,null,"La cantidad total de habitaciones (incluidos aulas, baños y oficinas) a desinfectar en una escuela típica",null,null,null,null,{"$f":"IF(ISERROR(('Información sobre las escuelas'!G50/'Información sobre las escuelas'!G49*(1+1/'Información sobre las escuelas'!G77+1/'Información sobre las escuelas'!G78))) = TRUE, \"\", ('Información sobre las escuelas'!G50/'Información sobre las escuelas'!G49*(1+1/'Información sobre las escuelas'!G77+1/'Información sobre las escuelas'!G78)))","v":""},"Habitaciones",null,"<Cantidad promedio de aulas por escuela x (1 + 1/relación aulas-baños + 1/relación aulas-oficinas)>"]
[]
[]
[null,null,null,"Factor 2: Cantidad de solución mixta necesaria",null,null,null,null,null,"litro(s) por metro cuadrado",null,"<Ingresar dato según etiqueta del producto>"]
[]
[null,null,null,"Factor 3: Proporción de la dilución",null,null,null,null,null,null,null,"<Ver etiqueta del producto. La relación es la cantidad de desinfectante concentrado dividida por la cantidad de agua necesaria.>"]
[]
[null,null,null,"Factor 4: Frecuencia de la desinfección"]
[null,null,null,"En la etapa con COVID-19",null,null,null,null,null,"vez/veces por día",null,"<Se recomienda limpiar y desinfectar las instalaciones escolares al menos una vez al día.>"]
[null,null,null,"En la etapa pre COVID-19",null,null,null,null,null,"vez/veces por semana"]
[null,null,null," "]
[null,null,null,"La cantidad de desinfectante necesaria para atomizar una escuela típica por día"]
[null,null,null,"En la etapa con COVID-19",null,null,null,null,{"$f":"IF(ISERROR(I19*I30*I32*I35) = TRUE, \"\", I19*I30*I32*I35)","v":""},"litro(s)",null,"<Factor 1 x Factor 2 x Factor 3 x Factor 4 para la etapa con COVID-19>"]
[null,null,null,"En la etapa pre COVID-19",null,null,null,null,{"$f":"IF(ISERROR(I19*I30*I32*I36/5) = TRUE, \"\", I19*I30*I32*I36/5)","v":""},"litro(s)",null,"<Factor 1 x Factor 2 x Factor 3 x Factor 4 para la etapa pre COVID-19>"]
[null,null,null,"Brecha",null,null,null,null,{"$f":"IF(ISERROR(I39-I40) = TRUE, \"\", I39-I40)","v":""},"litro(s)"]
[]
[]
[null,null,"Notas. ","Si usted no está seguro de algunas cifras, intente sobreestimarlas. "]
[null,null,"Fuentes.","Mitigación de enfermedades en escuelas, guarderías y universidades con sanitizantes y desinfectantes",null,null,null,null,null,null,null,"https://www.youtube.com/watch?v=xhS-AhciAfM&feature=youtu.be"]
[null,null,null,"Directrices para limpiar y desinfectar: Espacios públicos, espacios de trabajo, empresas, escuelas y hogares",null,null,null,null,null,null,null,"https://www.cdc.gov/coronavirus/2019-ncov/community/pdf/reopening_america_guidance.pdf"]
[null,null,null,"Limpieza y desinfección de instalaciones comunitarias",null,null,null,null,null,null,null,"https://www.cdc.gov/coronavirus/2019-ncov/community/organizations/cleaning-disinfection.html"]
[null,null,null,"Cálculos y aplicación de desinfectantes",null,null,null,null,null,null,null,"http://www.fao.org/3/al877e/al877e00.pdf"]
[null,null,null,"Calculadora del costo de desinfectar",null,null,null,null,null,null,null,"https://blog.midwestind.com/disinfecting-cost-calculator/"]
[]
[]
[null,null,"Calculadora 2. Cómo calcular la cantidad de antiséptico y jabón líquido para el lavado de manos"]
[]
[null,null,null,"2.1. Antiséptico para el lavado de manos en la escuela"]
[null,null,null,null,"Factor 1: Cantidad de antiséptico por lavado de manos",null,null,null,3,"mL",null,"<Se recomiendan 3 mL>"]
[null,null,null,null,"Factor 2: Frecuencia de uso del antiséptico"]
[null,null,null,null,"En la etapa con COVID-19",null,null,null,null,"veces por día por persona",null,"<Ingresar dato>"]
[null,null,null,null,"En la etapa pre COVID-19",null,null,null,null,"veces por día por persona",null,"<Ingresar dato>"]
[]
[null,null,null,null,"Cantidad de antiséptico necesario por persona por día"]
[null,null,null,null,"En la etapa con COVID-19",null,null,null,{"$f":"I55*I57","v":0},"mL"]
[null,null,null,null,"En la etapa pre COVID-19",null,null,null,{"$f":"I55*I58","v":0},"mL"]
[null,null,null,null,"Brecha",null,null,null,{"$f":"Antiseptic_per_person_per_day-I62","v":0},"mL"]
[]
[null,null,null,"2.2. Jabón líquido para el lavado de manos en la escuela"]
[null,null,null,null,"Factor 1: Cantidad de jabón líquido por lavado de manos",null,null,null,2,"mL",null,"<Un rango razonable es entre 1 y 3 mL>"]
[null,null,null,null,"Factor 2: Frecuencia del lavado de manos"]
[null,null,null,null,"En la etapa con COVID-19",null,null,null,null,"veces por día por persona"]
[null,null,null,null,"En la etapa pre COVID-19",null,null,null,null,"veces por día por persona"]
[]
[null,null,null,null,"Cantidad de jabón líquido necesario por persona por día"]
[null,null,null,null,"En la etapa con COVID-19",null,null,null,{"$f":"I66*I68","v":0},"mL","<Factor 1 x Factor 2 para la etapa con COVID-19>"]
[null,null,null,null,"En la etapa pre COVID-19",null,null,null,{"$f":"I66*I69","v":0},"mL","<Factor 1 x Factor 2 para la etapa pre COVID-19>"]
[null,null,null,null,"Brecha",null,null,null,{"$f":"Liquid_soap_per_person_per_day-I73","v":0},"mL"]
[]
[null,null,"Fuentes.","La cantidad de jabón como una variable en el lavado de manos",null,null,null,null,null,null,null,"https://pubmed.ncbi.nlm.nih.gov/3654132/"]
[null,null,null,"La cobertura de las manos del gel de base alcohólica varía: El volumen y el tamaño de la mano importan",null,null,null,null,null,null,null,"https://www.ajicjournal.org/article/S0196-6553(16)30690-3/abstract"]
[]
[]
[null,null,"Calculadora 3. Cómo calcular la cantidad de mascarillas"]
[]
[null,null,"Consejos para el uso de mascarillas por parte de los niños de la comunidad en el contexto de la pandemia de COVID-19"]
[null,null,"1) Los niños menores de cinco años no deberían tener que utilizar mascarillas. \n2) De los seis a los once años, el uso de la mascarilla debe basarse en:\n    • Si hay una tasa elevada de transmisión en el área\n    • Capacidad del niño de utilizar la mascarilla de forma segura y apropiada\n    • Acceso a mascarillas limpias y de reemplazo\n    • Adecuada supervisión por parte de un adulto\n    • Impacto potencial sobre el aprendizaje y el desarrollo psicosocial\n    • Condiciones específicas e interacciones con personas de mayor riesgo\n3) Los niños de doce años y más deben utilizar una mascarilla bajo las mismas condiciones que los adultos\n4) Los docentes y el personal auxiliar deben utilizar mascarillas cuando no puedan garantizar una distancia de al menos un metro respecto a otras personas o si hay una elevada tasa de transmisión en el área"]
[]
[null,null,null,"3.1. Mascarillas reutilizables"]
[]
[null,null,null,"Tipo de mascarilla","Población elegible",null,null,"Cantidad de personas",null,"Porcentaje presente en la escuela",null,"Cantidad de mascarillas por persona",null,"Cantidad total de mascarillas",null,"Precio unitario",null,"Costo"]
[null,null,null,"Mascarillas pequeñas","Niños de entre 3 y 5 años",null,null,null,null,{"$f":"pct_student_in_school","v":0},null,null,null,{"$f":"IF(ISERROR(H88*J88*L88) = TRUE, \"\", H88*J88*L88)","v":0},null,null,null,{"$f":"IF(ISERROR(N88*P88) = TRUE, \"\", N88*P88)","v":0}]
[null,null,null,"Mascarillas mediana","Niños de entre 6 y 11 años",null,null,null,null,{"$f":"pct_student_in_school","v":0},null,null,null,{"$f":"IF(ISERROR(H89*J89*L89) = TRUE, \"\", H89*J89*L89)","v":0},null,null,null,{"$f":"IF(ISERROR(N89*P89) = TRUE, \"\", N89*P89)","v":0}]
[null,null,null,"Mascarillas grandes","Alumnos mayores de 12 años",null,null,{"$f":"N_student","v":0},null,{"$f":"pct_student_in_school","v":0},null,null,null,0,null,null,null,0]
[null,null,null,"Mascarillas grandes","Docentes y personal escolar",null,null,{"$f":"N_teacher_and_staff","v":0},null,{"$f":"pct_teacher_staff_in_school","v":1},null,null,null,0,null,null,null,0]
[null,null,null,"Máscaras transparentes","Los docentes y el personal que interactúan regularmente con los alumnos que son sordos o tienen dificultades auditivas, alumnos que están aprendiendo a leer, que tienen alguna discapacidad, y los que dependen de la lectura de labios como parte de su aprendizaje.",null,null,0,null,{"$f":"pct_teacher_staff_in_school","v":1},null,null,null,0,null,null,null,0]
[]
[null,null,null,"Total",null,null,null,null,null,null,null,null,null,{"$f":"SUM(N88:N91)","v":0},null,{"$f":"IF(ISERROR((N88*P88+N89*P89+N90*P90+N91*P91+N92*P92)/SUM(N88:N92)) = TRUE, \"\", (N88*P88+N89*P89+N90*P90+N91*P91+N92*P92)/SUM(N88:N92))","v":""},null,{"$f":"SUM(R88:R91)","v":0}]
[]
[]
[null,null,null,"3.2. Mascarillas desechables"]
[]
[null,null,null,"Tipo de mascarilla","Población elegible",null,null,"Cantidad de personas",null,"Porcentaje presente en la escuela",null,"Cantidad de mascarillas por persona por día",null,"Cantidad total de mascarillas",null,"Precio",null,"Costo"]
[null,null,null,"Mascarillas pequeñas","Niños de entre 3 y 5 años",null,null,null,null,{"$f":"pct_student_in_school","v":0},null,null,null,{"$f":"IF(ISERROR(H100*J100*L100* N_school_days) = TRUE, \"\", H100*J100*L100* N_school_days)","v":0},null,null,null,{"$f":"IF(ISERROR(N100*P100) = TRUE, \"\", N100*P100)","v":0}]
[null,null,null,"Mascarillas mediana","Niños de entre 6 y 11 años",null,null,null,null,{"$f":"pct_student_in_school","v":0},null,null,null,{"$f":"IF(ISERROR(H101*J101*L101* N_school_days) = TRUE, \"\", H101*J101*L101* N_school_days)","v":0},null,null,null,{"$f":"IF(ISERROR(N101*P101) = TRUE, \"\", N101*P101)","v":0}]
[null,null,null,"Mascarillas grandes","Alumnos mayores de 12 años",null,null,{"$f":"N_student","v":0},null,{"$f":"pct_student_in_school","v":0},null,null,null,{"$f":"IF(ISERROR(H102*J102*L102* N_school_days) = TRUE, \"\", H102*J102*L102* N_school_days)","v":0},null,null,null,0]
[null,null,null,"Mascarillas grandes","Docentes y personal escolar",null,null,{"$f":"N_teacher_and_staff * pct_teacher_staff_in_school","v":0},null,{"$f":"pct_teacher_staff_in_school","v":1},null,null,null,{"$f":"IF(ISERROR(H103*J103*L103* N_school_days) = TRUE, \"\", H103*J103*L103* N_school_days)","v":0},null,null,null,0]
[]
[null,null,null,"Total",null,null,null,null,null,null,null,null,null,{"$f":"SUM(N100:N103)","v":0},null,{"$f":"IF(ISERROR((N100*P100+N101*P101+N102*P102+N103*P103)/SUM(N100:N103)) = TRUE, \"\", (N100*P100+N101*P101+N102*P102+N103*P103)/SUM(N100:N103))","v":""},null,{"$f":"SUM(R100:R103)","v":0}]
[]
[null,null,"Fuentes. ","Consejos para el uso de mascarillas por parte de los niños de la comunidad en el contexto de la pandemia de COVID-19",null,null,null,null,null,null,null,"https://www.who.int/publications/i/item/WHO-2019-nCoV-IPC_Masks-Children-2020.1"]

{"sheet":"Financiamiento","index":7,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,"<Indique el financiamiento disponible de fuentes domésticas y externas y el porcentaje de financiamiento sujeto a reasignación>"]
[]
[null,null,"Fuente de financiamiento","Monto disponible","Porcentaje sujeto a reasignación","Financiamiento total"]
[null,null,"Ahorro derivado de cancelar las excursiones, eventos y actividades extracurriculares",null,null,{"$f":"D8*E8","v":0}]
[null,null,"Financiamiento externo",null,null,0]
[null,null,"Paquete de ayuda para la COVID-19",null,null,0]
[null,null,"Aportes de padres y madres de familia",null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,{"$f":"D13*E13","v":0}]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]

{"sheet":"Informe","index":8,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":false,"merged":[[8,7,8,17],[22,7,22,17],[41,2,41,17],[26,5,27,6],[26,4,27,4],[29,5,30,6],[29,4,30,4],[33,4,35,6],[9,7,9,17],[23,7,23,17]]}
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"\"How much does it cost to reopen schools safely\"&IF('Información sobre las escuelas'!F9 <>\"\", \" in \"&'Información sobre las escuelas'!F9&\"\", \"\")&\"?\"","v":"How much does it cost to reopen schools safely in Perú?"}]
[]
[null,null,null,null,"Contexto",null,null,{"$f":"\"Costo, financiamiento y brecha financiera de reabrir las escuelas de forma segura durante el segundo semestre de \"&LOWER('Información sobre las escuelas'!D40)&\"\"","v":"Costo, financiamiento y brecha financiera de reabrir las escuelas de forma segura durante el segundo semestre de 2022"}]
[null,null,null,null,{"$f":"CHOOSE(Output!C3, Output!C4, Output!C5, Output!C6, Output!C7, Output!C8)","v":"Moises Moreno Romero"},null,null,{"$f":"\"(Expresado en \"&'Información sobre las escuelas'!G80&\" del \"&'Información sobre las escuelas'!G82&\")\"","v":"(Expresado en Soles del 2022)"}]
[]
[null,null,null,null,"Niveles educativos"]
[null,null,null,null,{"$f":"IF(Output!J3 = TRUE, Output!L3, \"\")","v":""}]
[null,null,null,{"$f":"_xlfn.ANCHORARRAY(Output!N3)","v":"Educación secundaria (1ro-5to)"},{"$f":"IF(Output!J4 = TRUE, Output!L4, \"\")","v":""}]
[null,null,null,null,{"$f":"IF(Output!J5 = TRUE, Output!L5, \"\")","v":"Educación secundaria (1ro-5to)"}]
[null,null,null,null,{"$f":"IF(Output!J6 = TRUE, Output!L6, \"\")","v":""}]
[]
[null,null,null,null,"Período de tiempo"]
[null,null,null,null,{"$f":"'Información sobre las escuelas'!D40","v":2022}]
[null,null,null,null,{"$f":"\"(\"&N_school_days&\" días de escuela totales)\"","v":"(180 días de escuela totales)"}]
[]
[null,null,null,null,"Población objetivo"]
[null,null,null,null,{"$f":"N_school","v":1},"escuelas",null,{"$f":"\"El costo financiero de los recursos adicionales necesarios para reabrir las escuelas de forma segura por eje\"","v":"El costo financiero de los recursos adicionales necesarios para reabrir las escuelas de forma segura por eje"}]
[null,null,null,null,{"$f":"N_student","v":0},"alumnos",null,{"$f":"\"(Expresado en \"&'Información sobre las escuelas'!G80&\" del \"&'Información sobre las escuelas'!G82&\")\"","v":"(Expresado en Soles del 2022)"}]
[]
[null,null,null,null,"Estado de la reapertura de escuelas"]
[null,null,null,null,{"$f":"\"\"&ROUND(pct_school_reopen, 2) *100&\"%\"","v":"100%"},"de todas las escuelas imparten clases presenciales"]
[]
[]
[null,null,null,null,{"$f":"\"\"&ROUND(pct_student_in_school, 2) *100&\"%\"","v":"0%"},"por ciento de los alumnos asiste a clases presenciales"]
[]
[]
[null,null,null,null,"Notas"]
[null,null,null,null," La base de referencia es el presupuesto para la misma población de alumnos en la etapa pre COVID-19. "]
[]
[]
[]
[]
[]
[]
[]
[null,null,"1. ¿Cómo imprimir el informe?\nPaso 1: Seleccionar el área a imprimir\n             Seleccionar la celda B7 y luego, con el botón izquierdo apretado, arrastrar hasta la celda T38. \nPaso 2: Hacer clic en Archivo > Imprimir, o pulse CTRL + P.\nPaso 3: Haga clic en el botón Imprimir y ajuste la configuración. \n             a) Cambie a “Orientación horizontal”. \n             b) Seleccione “Ajustar pestaña en una sola página”. \n             c) Ajuste los márgenes en base a sus necesidades. \n"]

{"sheet":"Artículos que se deben adquirir","index":9,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,"<Se genera automáticamente una lista con los materiales y equipos que deben adquirirse. La cantidad representa las necesidades totales, NO los recursos adicionales necesarios>"]
[null,null,"Artículos que se deben adquirir (materiales y equipos)","Cantidad","Unidad"]
[null,null,"Desinfectante (1L)",{"$f":"Disinfectant_per_school_per_day * (N_school * pct_school_reopen) * N_school_days","v":{"$error":"#VALUE!"}},"litro(s)",null,"p101"]
[null,null,"Contenedores vacíos para diluir los productos de limpieza y desinfección",{"$f":"N_container_per_cleaner * N_newly_hired_cleaner + (N_container_per_cleaner - N_container_per_cleaner_current) * N_cleaner_current * pct_teacher_staff_in_school","v":0},"pieza(s)"]
[null,null,"Pulverizador (1.5L)",{"$f":"N_sprayer_per_cleaner * N_newly_hired_cleaner + (N_sprayer_per_cleaner - N_sprayer_per_cleaner_current) * N_cleaner_current * pct_teacher_staff_in_school","v":0},"pieza(s)"]
[null,null,"Trapeadores, baldes y cepillos",{"$f":"(N_mop_per_room - N_mop_per_room_current) * N_school * N_room_per_school * pct_teacher_staff_in_school","v":{"$error":"#VALUE!"}},"conjunto(s)"]
[null,null,"Barras de jabón",{"$f":"N_soap_bar_per_room * N_room_per_school * N_school * pct_school_reopen","v":{"$error":"#VALUE!"}},"pieza(s)"]
[null,null,"Guantes de goma para el personal de limpieza",{"$f":"N_glove_per_cleaner * N_newly_hired_cleaner + (N_glove_per_cleaner - N_glove_per_cleaner_current) * N_cleaner_current * pct_teacher_staff_in_school","v":0},"par(es)"]
[null,null,"Batas desechables para el personal de limpieza",{"$f":"N_disposable_gown_per_cleaner_per_day * N_cleaner * pct_school_reopen * N_school_days","v":0},"conjunto(s)"]
[null,null,"Batas y gorras reutilizables para el personal de limpieza",{"$f":"N_reusable_gown_per_cleaner * N_newly_hired_cleaner + (N_reusable_gown_per_cleaner - N_reusable_gown_per_cleaner_current) * N_cleaner_current * pct_teacher_staff_in_school","v":0},"conjunto(s)"]
[null,null,"Mascarillas reutilizables",{"$f":"N_reusable_mask","v":0},"pieza(s)",null,"P102"]
[null,null,"Mascarillas desechables",{"$f":"N_disposable_mask","v":0},"pieza(s)"]
[null,null,"Protector facial",{"$f":"N_shield_per_teacher_staff * N_teacher_and_staff * pct_teacher_staff_in_school","v":0},"pieza(s)"]
[null,null,"Antisépticos de base alcohólica (al menos 70 por ciento alcohol)",{"$f":"Antiseptic_per_person_per_day * (N_student * pct_student_in_school + N_teacher_and_staff * pct_teacher_staff_in_school) * N_school_days/1000","v":0},"litro(s)",null,"P103"]
[null,null,"Dispensadores antisépticos",{"$f":"(N_antiseptic_dispenser_per_room - N_antiseptic_dispenser_per_room_current) * N_room_per_school * N_school * pct_school_reopen","v":{"$error":"#VALUE!"}},"pieza(s)"]
[null,null,"Jabón líquido",{"$f":"Liquid_soap_per_person_per_day * (N_student * pct_student_in_school + N_teacher_and_staff * pct_teacher_staff_in_school) * N_school_days/1000","v":0},"litro(s)"]
[null,null,"Papel secante",{"$f":"(N_paper_towel_per_person_per_month - N_paper_towel_per_person_per_month_current)/20 * (N_student * pct_student_in_school + N_teacher_and_staff * pct_teacher_staff_in_school) * N_school_days","v":0},"rollo(s)"]
[null,null,"Tachos de basura sin contacto/a pedal",{"$f":"(N_trash_can_per_room - N_trash_can_per_room_current) * N_room_per_school * N_school * pct_school_reopen","v":{"$error":"#VALUE!"}},"pieza(s)"]
[null,null,"Barreras físicas en las aulas",{"$f":"N_physical_screen_per_student * N_student_per_school * (N_school * pct_school_reopen * pct_school_classroom_barrier)","v":0},"pieza(s)",null,"P108"]
[null,null,"Barreras físicas entre los lavabos del baño",{"$f":"(N_sink_per_restroom - 1) * ROUNDUP(N_class/N_school/Classroom_restroom_ratio, 0) * (N_school * pct_school_reopen * pct_school_restroom_barrier)","v":{"$error":"#DIV/0!"}},"pieza(s)"]
[null,null,"Cintas para crear señales en los pisos y aceras",{"$f":"N_tape_per_school * N_school * pct_school_reopen","v":0},"rollo(s)"]
[null,null,"Carteles o señales en las paredes",{"$f":"N_poster_per_school * N_school * pct_school_reopen","v":0},"cartel(es)"]
[null,null,"Materiales de capacitación",{"$f":"'Precios de los recursos'!E32","v":0},"conjunto(s)",null,"P201"]
[null,null,"Insumo de corte, espiralado y enmicado",{"$f":"'Precios de los recursos'!E38","v":0},"paquetes",null,"P203"]
[null,null,"Fotocopiadora",{"$f":"'Precios de los recursos'!E39","v":0},"equipo"]
[null,null,"Papel  ",{"$f":"'Precios de los recursos'!E40","v":0},"paquetes x 500 "]
[null,null,"Tinta ",{"$f":"'Precios de los recursos'!E41","v":0},"pieza(s)"]

{"sheet":"Data prep","index":10,"n_rows":34,"n_cols":4,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
[]
["Financial cost"]
[null,"Total additional cost"]
["Safe operations",{"$f":"_xlfn.AGGREGATE(9, 5, 'Precios de los recursos'!H9:H30)","v":{"$error":"#VALUE!"}}]
["Sustaining learning",{"$f":"_xlfn.AGGREGATE(9, 5, 'Precios de los recursos'!H32:H41)","v":0}]
["Supporting emotional wellbeing",{"$f":"_xlfn.AGGREGATE(9, 5, 'Precios de los recursos'!H43:H48)","v":0}]
["Reaching the marginalized",{"$f":"_xlfn.AGGREGATE(9, 5, 'Precios de los recursos'!H50:H50)","v":0}]
["Total",{"$f":"SUM(B4:B7)","v":{"$error":"#VALUE!"}}]
[]
[null,"Total"]
["Additional cost",{"$f":"B8","v":{"$error":"#VALUE!"}}]
["Additional funding available",{"$f":"_xlfn.AGGREGATE(9, 5, Financiamiento!F8:F18)","v":0}]
["Funding gap",{"$f":"B11-B12","v":{"$error":"#VALUE!"}}]
[]
["Figure 1"]
[null,"Bottom block","Top block","Horizontal lines"]
["Costo adicional",{"$f":"B11","v":{"$error":"#VALUE!"}},{"$f":"B17-B11","v":{"$error":"#VALUE!"}},{"$f":"B13","v":{"$error":"#VALUE!"}}]
["Financiamiento adicional disponible",{"$f":"B13","v":{"$error":"#VALUE!"}},{"$f":"B12","v":0},{"$f":"D17","v":{"$error":"#VALUE!"}}]
["Brecha de financiamiento",{"$f":"B13","v":{"$error":"#VALUE!"}},{"$f":"B12","v":0},{"$f":"D17","v":{"$error":"#VALUE!"}}]
[]
["Figure 2 & Figure 3"]
[null,"Additional cost","%"]
["Seguridad de las operaciones",{"$f":"B4","v":{"$error":"#VALUE!"}},{"$f":"B23/SUM(B$23:B$26)","v":{"$error":"#VALUE!"}}]
["Sostener el aprendizaje",{"$f":"B5","v":0},{"$f":"B24/SUM(B$23:B$26)","v":{"$error":"#VALUE!"}}]
["Respaldar el bienestar emocional",0,{"$error":"#VALUE!"}]
["Llegar a los marginados",0,{"$error":"#VALUE!"}]
[]
["Economic cost"]
["Figure 4 & Figure 5"]
[null,"Additional cost"]
["Seguridad de las operaciones",{"$f":"_xlfn.AGGREGATE(9, 5, 'Precios de los recursos'!#REF!)","v":{"$error":"#REF!"}}]
["Sostener el aprendizaje",{"$f":"_xlfn.AGGREGATE(9, 5, 'Precios de los recursos'!#REF!)","v":{"$error":"#REF!"}}]
["Respaldar el bienestar emocional",{"$f":"_xlfn.AGGREGATE(9, 5, 'Precios de los recursos'!#REF!)","v":{"$error":"#REF!"}}]
["Llegar a los marginados",{"$f":"_xlfn.AGGREGATE(9, 5, 'Precios de los recursos'!#REF!)","v":{"$error":"#REF!"}}]

{"sheet":"List_Economy","index":11,"n_rows":290,"n_cols":11,"rows_kept":290,"cut":false,"hidden":true,"merged":[[274,0,274,8],[278,0,278,8],[280,0,280,8]]}
["Lista de economías del Banco Mundial (junio de 2020)"]
[]
["(Las negritas indican un cambio en la clasificación)",null,null," "]
[]
["x","x","Economía","Code","X","Region","Income group","Lending category","Other",null,"Data prep"]
["x","x","x","x","x","x","x","x","x"]
[1,null,"Afganistán","AFG",null,"South Asia","Low income","IDA","HIPC",null,{"$f":"_xlfn._xlws.FILTER($C$7:$C$225, ISNUMBER(SEARCH('Información sobre las escuelas'!F9, $C$7:$C$225)),\"Please check the spelling\")","v":"Perú"}]
[2,null,"Albania","ALB",null,"Europe & Central Asia","Upper middle income","IBRD",""]
[3,null,"Alemania","DZA",null,"Middle East & North Africa","Lower middle income","IBRD",""]
[4,null,"Andorra","ASM",null,"East Asia & Pacific","Upper middle income","..",""]
[5,null,"Angola","AND",null,"Europe & Central Asia","High income","..",""]
[6,null,"Antigua y Barbuda","AGO",null,"Sub-Saharan Africa","Lower middle income","IBRD"]
[7,null,"Arabia Saudita","ATG",null,"Latin America & Caribbean","High income","IBRD",""]
[8,null,"Argelia","ARG",null,"Latin America & Caribbean","Upper middle income","IBRD",""]
[9,null,"Argentina","ARM",null,"Europe & Central Asia","Upper middle income","IBRD",""]
[10,null,"Armenia","ABW",null,"Latin America & Caribbean","High income","..",""]
[11,null,"Aruba","AUS",null,"East Asia & Pacific","High income","..",""]
[12,null,"Australia","AUT",null,"Europe & Central Asia","High income","..","EMU"]
[13,null,"Austria","AZE",null,"Europe & Central Asia","Upper middle income","IBRD",""]
[14,null,"Azerbaiyán","BHS",null,"Latin America & Caribbean","High income","..",""]
[15,null,"Bahamas","BHR",null,"Middle East & North Africa","High income",".."]
[16,null,"Bahréin","BGD",null,"South Asia","Lower middle income","IDA",""]
[17,null,"Bangladesh","BRB",null,"Latin America & Caribbean","High income","..",""]
[18,null,"Barbados","BLR",null,"Europe & Central Asia","Upper middle income","IBRD",""]
[19,null,"Belarús","BEL",null,"Europe & Central Asia","High income","..","EMU"]
[20,null,"Bélgica","BLZ",null,"Latin America & Caribbean","Upper middle income","IBRD",""]
[21,null,"Belice","BEN",null,"Sub-Saharan Africa","Lower middle income","IDA","HIPC"]
[22,null,"Benín","BMU",null,"North America","High income","..",""]
[23,null,"Bermudas","BTN",null,"South Asia","Lower middle income","IDA",""]
[24,null,"Bolivia","BOL",null,"Latin America & Caribbean","Lower middle income","IBRD","HIPC"]
[25,null,"Bosnia y Herzegovina","BIH",null,"Europe & Central Asia","Upper middle income","IBRD",""]
[26,null,"Botsuana","BWA",null,"Sub-Saharan Africa","Upper middle income","IBRD",""]
[27,null,"Brasil","BRA",null,"Latin America & Caribbean","Upper middle income","IBRD",""]
[28,null,"Brunei Darussalam","VGB",null,"Latin America & Caribbean","High income",".."]
[29,null,"Bulgaria","BRN",null,"East Asia & Pacific","High income","..",""]
[30,null,"Burkina Faso","BGR",null,"Europe & Central Asia","Upper middle income","IBRD",""]
[31,null,"Burundi","BFA",null,"Sub-Saharan Africa","Low income","IDA","HIPC"]
[32,null,"Bután","BDI",null,"Sub-Saharan Africa","Low income","IDA","HIPC"]
[33,null,"Cabo Verde","CPV",null,"Sub-Saharan Africa","Lower middle income","Blend",""]
[34,null,"Camboya","KHM",null,"East Asia & Pacific","Lower middle income","IDA",""]
[35,null,"Camerún","CMR",null,"Sub-Saharan Africa","Lower middle income","Blend","HIPC"]
[36,null,"Canadá","CAN",null,"North America","High income","..",""]
[37,null,"Catar","CYM",null,"Latin America & Caribbean","High income","..",""]
[38,null,"Chad","CAF",null,"Sub-Saharan Africa","Low income","IDA","HIPC"]
[39,null,"Chile","TCD",null,"Sub-Saharan Africa","Low income","IDA","HIPC"]
[40,null,"China","CHI",null,"Europe & Central Asia","High income","..",""]
[41,null,"Chipre","CHL",null,"Latin America & Caribbean","High income","IBRD",""]
[42,null,"Colombia","CHN",null,"East Asia & Pacific","Upper middle income","IBRD",""]
[43,null,"Comoras","COL",null,"Latin America & Caribbean","Upper middle income","IBRD",""]
[44,null,"Congo, República del","COM",null,"Sub-Saharan Africa","Lower middle income","IDA","HIPC"]
[45,null,"Congo, República Democrática del","COD",null,"Sub-Saharan Africa","Low income","IDA","HIPC"]
[46,null,"Corea, República de","COG",null,"Sub-Saharan Africa","Lower middle income","Blend","HIPC"]
[47,null,"Corea, República Popular Democrática de","CRI",null,"Latin America & Caribbean","Upper middle income","IBRD",""]
[48,null,"Costa Rica","CIV",null,"Sub-Saharan Africa","Lower middle income","IDA","HIPC"]
[49,null,"Côte d’Ivoire","HRV",null,"Europe & Central Asia","High income","IBRD",""]
[50,null,"Croacia","CUB",null,"Latin America & Caribbean","Upper middle income","..",""]
[51,null,"Cuba","CUW",null,"Latin America & Caribbean","High income",".."]
[52,null,"Curazao","CYP",null,"Europe & Central Asia","High income","..","EMU"]
[53,null,"Dinamarca","CZE",null,"Europe & Central Asia","High income","..",""]
[54,null,"Dominica","DNK",null,"Europe & Central Asia","High income","..",""]
[55,null,"Ecuador","DJI",null,"Middle East & North Africa","Lower middle income","IDA",""]
[56,null,"Egipto, República Árabe de","DMA",null,"Latin America & Caribbean","Upper middle income","Blend",""]
[57,null,"El Salvador","DOM",null,"Latin America & Caribbean","Upper middle income","IBRD",""]
[58,null,"Emiratos Árabes Unidos","ECU",null,"Latin America & Caribbean","Upper middle income","IBRD",""]
[59,null,"Eritrea","EGY",null,"Middle East & North Africa","Lower middle income","IBRD",""]
[60,null,"Eslovenia","SLV",null,"Latin America & Caribbean","Lower middle income","IBRD",""]
[61,null,"España","GNQ",null,"Sub-Saharan Africa","Upper middle income","IBRD",""]
[62,null,"Estados Unidos","ERI",null,"Sub-Saharan Africa","Low income","IDA","HIPC"]
[63,null,"Estonia","EST",null,"Europe & Central Asia","High income","..","EMU"]
[64,null,"Eswatini","SWZ",null,"Sub-Saharan Africa","Lower middle income","IBRD",""]
[65,null,"Etiopía","ETH",null,"Sub-Saharan Africa","Low income","IDA","HIPC"]
[66,null,"Federación Rusa","FRO",null,"Europe & Central Asia","High income","..",""]
[67,null,"Filipinas","FJI",null,"East Asia & Pacific","Upper middle income","Blend",""]
[68,null,"Finlandia","FIN",null,"Europe & Central Asia","High income","..","EMU"]
[69,null,"Fiyi","FRA",null,"Europe & Central Asia","High income","..","EMU"]
[70,null,"Francia","PYF",null,"East Asia & Pacific","High income","..",""]
[71,null,"Franja Occidental y Gaza","GAB",null,"Sub-Saharan Africa","Upper middle income","IBRD",""]
[72,null,"Gabón","GMB",null,"Sub-Saharan Africa","Low income","IDA","HIPC"]
[73,null,"Gambia","GEO",null,"Europe & Central Asia","Upper middle income","IBRD",""]
[74,null,"Georgia","DEU",null,"Europe & Central Asia","High income","..","EMU"]
[75,null,"Ghana","GHA",null,"Sub-Saharan Africa","Lower middle income","IDA","HIPC"]
[76,null,"Gibraltar","GIB",null,"Europe & Central Asia","High income",".."]
[77,null,"Granada","GRC",null,"Europe & Central Asia","High income","..","EMU"]
[78,null,"Grecia","GRL",null,"Europe & Central Asia","High income","..",""]
[79,null,"Groenlandia","GRD",null,"Latin America & Caribbean","Upper middle income","Blend",""]
[80,null,"Guam","GUM",null,"East Asia & Pacific","High income","..",""]
[81,null,"Guatemala","GTM",null,"Latin America & Caribbean","Upper middle income","IBRD",""]
[82,null,"Guinea","GIN",null,"Sub-Saharan Africa","Low income","IDA","HIPC"]
[83,null,"Guinea Ecuatorial","GNB",null,"Sub-Saharan Africa","Low income","IDA","HIPC"]
[84,null,"Guinea-Bissau","GUY",null,"Latin America & Caribbean","Upper middle income","IDA","HIPC"]
[85,null,"Guyana","HTI",null,"Latin America & Caribbean","Low income","IDA","HIPC"]
[86,null,"Haití","HND",null,"Latin America & Caribbean","Lower middle income","IDA","HIPC"]
[87,null,"Honduras","HKG",null,"East Asia & Pacific","High income","..",""]
[88,null,"Hong Kong, China, Región Administrativa Especial de","HUN",null,"Europe & Central Asia","High income","..",""]
[89,null,"Hungría","ISL",null,"Europe & Central Asia","High income","..",""]
[90,null,"India","IND",null,"South Asia","Lower middle income","IBRD",""]
[91,null,"Indonesia","IDN",null,"East Asia & Pacific","Upper middle income","IBRD",""]
[92,null,"Irak","IRN",null,"Middle East & North Africa","Upper middle income","IBRD",""]
[93,null,"Irán, República Islámica de","IRQ",null,"Middle East & North Africa","Upper middle income","IBRD",""]
[94,null,"Irlanda","IRL",null,"Europe & Central Asia","High income","..","EMU"]
[95,null,"Isla de Man","IMN",null,"Europe & Central Asia","High income","..",""]
[96,null,"Islandia","ISR",null,"Middle East & North Africa","High income","..",""]
[97,null,"Islas Caimán","ITA",null,"Europe & Central Asia","High income","..","EMU"]
[98,null,"Islas del Canal","JAM",null,"Latin America & Caribbean","Upper middle income","IBRD",""]
[99,null,"Islas Feroe","JPN",null,"East Asia & Pacific","High income","..",""]
[100,null,"Islas Marshall","JOR",null,"Middle East & North Africa","Upper middle income","IBRD",""]
[101,null,"Islas Salomón","KAZ",null,"Europe & Central Asia","Upper middle income","IBRD",""]
[102,null,"Islas Turcas y Caicos","KEN",null,"Sub-Saharan Africa","Lower middle income","Blend"]
[103,null,"Islas Vírgenes (EE. UU.)","KIR",null,"East Asia & Pacific","Lower middle income","IDA",""]
[104,null,"Islas Vírgenes Británicas","PRK",null,"East Asia & Pacific","Low income","..",""]
[105,null,"Israel","KOR",null,"East Asia & Pacific","High income","..",""]
[106,null,"Italia","XKX",null,"Europe & Central Asia","Upper middle income","IDA"]
[107,null,"Jamaica","KWT",null,"Middle East & North Africa","High income","..",""]
[108,null,"Japón","KGZ",null,"Europe & Central Asia","Lower middle income","IDA"]
[109,null,"Jordania","LAO",null,"East Asia & Pacific","Lower middle income","IDA"]
[110,null,"Kazajistán","LVA",null,"Europe & Central Asia","High income","..","EMU"]
[111,null,"Kenia","LBN",null,"Middle East & North Africa","Upper middle income","IBRD",""]
[112,null,"Kirguistán","LSO",null,"Sub-Saharan Africa","Lower middle income","IDA",""]
[113,null,"Kiribati","LBR",null,"Sub-Saharan Africa","Low income","IDA","HIPC"]
[114,null,"Kosovo","LBY",null,"Middle East & North Africa","Upper middle income","IBRD",""]
[115,null,"Kuwait","LIE",null,"Europe & Central Asia","High income","..",""]
[116,null,"Lao, República Democrática Popular","LTU",null,"Europe & Central Asia","High income","..","EMU"]
[117,null,"Lesoto","LUX",null,"Europe & Central Asia","High income","..","EMU"]
[118,null,"Letonia","MAC",null,"East Asia & Pacific","High income","..",""]
[119,null,"Líbano","MDG",null,"Sub-Saharan Africa","Low income","IDA","HIPC"]
[120,null,"Liberia","MWI",null,"Sub-Saharan Africa","Low income","IDA","HIPC"]
[121,null,"Libia","MYS",null,"East Asia & Pacific","Upper middle income","IBRD",""]
[122,null,"Liechtenstein","MDV",null,"South Asia","Upper middle income","IDA"]
[123,null,"Lituania","MLI",null,"Sub-Saharan Africa","Low income","IDA","HIPC"]
[124,null,"Luxemburgo","MLT",null,"Middle East & North Africa","High income","..","EMU"]
[125,null,"Macao, China, Región Administrativa Especial de","MHL",null,"East Asia & Pacific","Upper middle income","IDA",""]
[126,null,"Macedonia del Norte","MRT",null,"Sub-Saharan Africa","Lower middle income","IDA","HIPC"]
[127,null,"Madagascar","MUS",null,"Sub-Saharan Africa","High income","IBRD",""]
[128,null,"Malasia","MEX",null,"Latin America & Caribbean","Upper middle income","IBRD",""]
[129,null,"Malawi","FSM",null,"East Asia & Pacific","Lower middle income","IDA",""]
[130,null,"Maldivas","MDA",null,"Europe & Central Asia","Lower middle income","IBRD",""]
[131,null,"Malí","MCO",null,"Europe & Central Asia","High income","..",""]
[132,null,"Malta","MNG",null,"East Asia & Pacific","Lower middle income","IBRD",""]
[133,null,"Marianas del Norte, Islas","MNE",null,"Europe & Central Asia","Upper middle income","IBRD",""]
[134,null,"Marruecos","MAR",null,"Middle East & North Africa","Lower middle income","IBRD",""]
[135,null,"Mauricio","MOZ",null,"Sub-Saharan Africa","Low income","IDA","HIPC"]
[136,null,"Mauritania","MMR",null,"East Asia & Pacific","Lower middle income","IDA"]
[137,null,"México","NAM",null,"Sub-Saharan Africa","Upper middle income","IBRD",""]
[138,null,"Micronesia, Estados Federados de","NRU",null,"East Asia & Pacific","High income","IBRD"]
[139,null,"Moldavia","NPL",null,"South Asia","Lower middle income","IDA"]
[140,null,"Mónaco","NLD",null,"Europe & Central Asia","High income","..","EMU"]
[141,null,"Mongolia","NCL",null,"East Asia & Pacific","High income","..",""]
[142,null,"Montenegro","NZL",null,"East Asia & Pacific","High income","..",""]
[143,null,"Mozambique","NIC",null,"Latin America & Caribbean","Lower middle income","IDA","HIPC"]
[144,null,"Myanmar","NER",null,"Sub-Saharan Africa","Low income","IDA","HIPC"]
[145,null,"Namibia","NGA",null,"Sub-Saharan Africa","Lower middle income","Blend",""]
[146,null,"Nauru","MKD",null,"Europe & Central Asia","Upper middle income","IBRD",""]
[147,null,"Nepal","MNP",null,"East Asia & Pacific","High income","..",""]
[148,null,"Nicaragua","NOR",null,"Europe & Central Asia","High income","..",""]
[149,null,"Níger","OMN",null,"Middle East & North Africa","High income","..",""]
[150,null,"Nigeria","PAK",null,"South Asia","Lower middle income","Blend",""]
[151,null,"Noruega","PLW",null,"East Asia & Pacific","High income","IBRD",""]
[152,null,"Nueva Caledonia","PAN",null,"Latin America & Caribbean","High income","IBRD",""]
[153,null,"Nueva Zelanda","PNG",null,"East Asia & Pacific","Lower middle income","Blend",""]
[154,null,"Omán","PRY",null,"Latin America & Caribbean","Upper middle income","IBRD",""]
[155,null,"Países Bajos","PER",null,"Latin America & Caribbean","Upper middle income","IBRD",""]
[156,null,"Pakistán","PHL",null,"East Asia & Pacific","Lower middle income","IBRD",""]
[157,null,"Palaos","POL",null,"Europe & Central Asia","High income","IBRD",""]
[158,null,"Panamá","PRT",null,"Europe & Central Asia","High income","..","EMU"]
[159,null,"Papúa Nueva Guinea","PRI",null,"Latin America & Caribbean","High income","..",""]
[160,null,"Paraguay","QAT",null,"Middle East & North Africa","High income","..",""]
[161,null,"Perú","ROU",null,"Europe & Central Asia","High income","IBRD",""]
[162,null,"Polinesia Francesa","RUS",null,"Europe & Central Asia","Upper middle income","IBRD",""]
[163,null,"Polonia","RWA",null,"Sub-Saharan Africa","Low income","IDA","HIPC"]
[164,null,"Portugal","WSM",null,"East Asia & Pacific","Upper middle income","IDA",""]
[165,null,"Puerto Rico","SMR",null,"Europe & Central Asia","High income","..",""]
[166,null,"Reino Unido","STP",null,"Sub-Saharan Africa","Lower middle income","IDA","HIPC"]
[167,null,"República Centroafricana","SAU",null,"Middle East & North Africa","High income","..",""]
[168,null,"República Checa","SEN",null,"Sub-Saharan Africa","Lower middle income","IDA","HIPC"]
[169,null,"República Dominicana","SRB",null,"Europe & Central Asia","Upper middle income","IBRD",""]
[170,null,"República Eslovaca","SYC",null,"Sub-Saharan Africa","High income","IBRD",""]
[171,null,"Ruanda","SLE",null,"Sub-Saharan Africa","Low income","IDA","HIPC"]
[172,null,"Rumania","SGP",null,"East Asia & Pacific","High income","..",""]
[173,null,"Samoa","SXM",null,"Latin America & Caribbean","High income",".."]
[174,null,"Samoa Americana","SVK",null,"Europe & Central Asia","High income","..","EMU"]
[175,null,"San Cristóbal y Nieves","SVN",null,"Europe & Central Asia","High income","..","EMU"]
[176,null,"San Marino","SLB",null,"East Asia & Pacific","Lower middle income","IDA",""]
[177,null,"San Martín (parte francesa)","SOM",null,"Sub-Saharan Africa","Low income","IDA","HIPC"]
[178,null,"San Vicente y las Granadinas","ZAF",null,"Sub-Saharan Africa","Upper middle income","IBRD",""]
[179,null,"Santa Lucía","SSD",null,"Sub-Saharan Africa","Low income","IDA"]
[180,null,"Santo Tomé y Príncipe","ESP",null,"Europe & Central Asia","High income","..","EMU"]
[181,null,"Senegal","LKA",null,"South Asia","Lower middle income","IBRD",""]
[182,null,"Serbia","KNA",null,"Latin America & Caribbean","High income","IBRD",""]
[183,null,"Seychelles","LCA",null,"Latin America & Caribbean","Upper middle income","Blend",""]
[184,null,"Sierra Leona","MAF",null,"Latin America & Caribbean","High income",".."]
[185,null,"Singapur","VCT",null,"Latin America & Caribbean","Upper middle income","Blend",""]
[186,null,"Sint Maarten (parte neerlandesa)","SDN",null,"Sub-Saharan Africa","Low income","IDA","HIPC"]
[187,null,"Siria, República Árabe","SUR",null,"Latin America & Caribbean","Upper middle income","IBRD",""]
[188,null,"Somalia","SWE",null,"Europe & Central Asia","High income","..",""]
[189,null,"Sri Lanka","CHE",null,"Europe & Central Asia","High income","..",""]
[190,null,"Sudáfrica","SYR",null,"Middle East & North Africa","Low income","IDA",""]
[191,null,"Sudán","TWN",null,"East Asia & Pacific","High income",".."]
[192,null,"Sudán del Sur","TJK",null,"Europe & Central Asia","Low income","IDA",""]
[193,null,"Suecia","TZA",null,"Sub-Saharan Africa","Lower middle income","IDA","HIPC"]
[194,null,"Suiza","THA",null,"East Asia & Pacific","Upper middle income","IBRD",""]
[195,null,"Surinam","TLS",null,"East Asia & Pacific","Lower middle income","Blend"]
[196,null,"Tailandia","TGO",null,"Sub-Saharan Africa","Low income","IDA","HIPC"]
[197,null,"Taiwán, China","TON",null,"East Asia & Pacific","Upper middle income","IDA",""]
[198,null,"Tanzania","TTO",null,"Latin America & Caribbean","High income","IBRD",""]
[199,null,"Tayikistán","TUN",null,"Middle East & North Africa","Lower middle income","IBRD",""]
[200,null,"Timor Oriental","TUR",null,"Europe & Central Asia","Upper middle income","IBRD",""]
[201,null,"Togo","TKM",null,"Europe & Central Asia","Upper middle income","IBRD",""]
[202,null,"Tonga","TCA",null,"Latin America & Caribbean","High income",".."]
[203,null,"Trinidad y Tobago","TUV",null,"East Asia & Pacific","Upper middle income","IDA"]
[204,null,"Túnez","UGA",null,"Sub-Saharan Africa","Low income","IDA","HIPC"]
[205,null,"Turkmenistán","UKR",null,"Europe & Central Asia","Lower middle income","IBRD",""]
[206,null,"Turquía","ARE",null,"Middle East & North Africa","High income","..",""]
[207,null,"Tuvalu","GBR",null,"Europe & Central Asia","High income","..",""]
[208,null,"Ucrania","USA",null,"North America","High income","..",""]
[209,null,"Uganda","URY",null,"Latin America & Caribbean","High income","IBRD",""]
[210,null,"Uruguay","UZB",null,"Europe & Central Asia","Lower middle income","Blend",""]
[211,null,"Uzbekistán","VUT",null,"East Asia & Pacific","Lower middle income","IDA",""]
[212,null,"Vanuatu","VEN",null,"Latin America & Caribbean","Upper middle income","IBRD",""]
[213,null,"Venezuela","VNM",null,"East Asia & Pacific","Lower middle income","IBRD"]
[214,null,"Vietnam","VIR",null,"Latin America & Caribbean","High income","..",""]
[215,null,"Yemen, Rep. de","PSE",null,"Middle East & North Africa","Lower middle income","..",""]
[216,null,"Yibuti","YEM",null,"Middle East & North Africa","Low income","IDA"]
[217,null,"Zambia","ZMB",null,"Sub-Saharan Africa","Lower middle income","IDA","HIPC"]
[218,null,"Zimbabue","ZWE",null,"Sub-Saharan Africa","Lower middle income","Blend",""]
[null,null,"Storyland"]
[]
[]
[1,null,"Arab World","ARB"]
[2,null,"Caribbean small states","CSS"]
[3,null,"Central Europe and the Baltics","CEB"]
[4,null,"Early-demographic dividend","EAR"]
[5,null,"East Asia & Pacific","EAS"]
[6,null,"East Asia & Pacific (excluding high income)","EAP"]
[7,null,"East Asia & Pacific (IDA & IBRD)","TEA"]
[8,null,"Euro area","EMU"]
[9,null,"Europe & Central Asia","ECS"]
[10,null,"Europe & Central Asia (excluding high income)","ECA"]
[11,null,"Europe & Central Asia (IDA & IBRD)","TEC"]
[12,null,"European Union","EUU"]
[13,null,"Fragile and conflict affected situations","FCS"]
[14,null,"Heavily indebted poor countries (HIPC)","HPC"]
[15,null,"High income","HIC"]
[16,null,"IBRD only","IBD"]
[17,null,"IDA & IBRD total","IBT"]
[18,null,"IDA blend","IDB"]
[19,null,"IDA only","IDX"]
[20,null,"IDA total","IDA"]
[21,null,"Late-demographic dividend","LTE"]
[22,null,"Latin America & Caribbean","LCN"]
[23,null,"Latin America & Caribbean (excluding high income)","LAC"]
[24,null,"Latin America & Caribbean (IDA & IBRD)","TLA"]
[25,null,"Least developed countries: UN classification","LDC"]
[26,null,"Low & middle income","LMY"]
[27,null,"Low income","LIC"]
[28,null,"Lower middle income","LMC"]
[29,null,"Middle East & North Africa","MEA"]
[30,null,"Middle East & North Africa (excluding high income)","MNA"]
[31,null,"Middle East & North Africa (IDA & IBRD)","TMN"]
[32,null,"Middle income","MIC"]
[33,null,"North America","NAC"]
[34,null,"OECD members","OED"]
[35,null,"Other small states","OSS"]
[36,null,"Pacific island small states","PSS"]
[37,null,"Post-demographic dividend","PST"]
[38,null,"Pre-demographic dividend","PRE"]
[39,null,"Small states","SST"]
[40,null,"South Asia","SAS"]
[41,null,"South Asia (IDA & IBRD)","TSA"]
[42,null,"Sub-Saharan Africa","SSF"]
[43,null,"Sub-Saharan Africa (excluding high income)","SSA"]
[44,null,"Sub-Saharan Africa (IDA & IBRD)","TSS"]
[45,null,"Upper middle income","UMC"]
[46,null,"World","WLD"]
[]
["This table classifies all World Bank member countries (189), and all other economies with populations of more than 30,000. For operational and analytical purposes, economies are divided among income groups according to 2019 gross national income (GNI) per capita, calculated using the World Bank Atlas method. The groups are: low income, $1,035 or less; lower middle income, $1,036 - 4,045; upper middle income, $4,046 - 12,535; and high income, $12,536 or more. The effective operational cutoff for IDA eligibility is $1,185 or less."]
[]
["Geographic classifications in this table cover all income levels."]
[]
["IDA countries are those that lack the financial ability to borrow from IBRD. IDA credits are deeply concessional—interest-free loans and grants for programs aimed at boosting economic growth and improving living conditions. IBRD loans are noncessional. Blend countries are eligible for IDA credits because of their low per capita incomes but are also eligible for IBRD because they are financially creditworthy."]
[]
["Note: The term country, used interchangeably with economy, does not imply political independence but refers to any territory for which authorities report separate social or economic statistics. Income classifications set on 1 July 2020 remain in effect until 1 July 2021. Argentina, which was temporarily unclassified in July 2016 pending release of revised national accounts statistics, was classified as upper middle income for FY17 as of 29 September 2016 based on alternative conversion factors. Also effective 29 September 2016, Syrian Arab Republic is reclassified from IBRD lending category to IDA-only. On 29 March 2017, new country codes were introduced to align World Bank 3-letter codes with ISO 3-letter codes: Andorra (AND), Dem. Rep. Congo (COD), Isle of Man (IMN), Kosovo (XKX), Romania (ROU), Timor-Leste (TLS), and West Bank and Gaza (PSE)."]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Conteo de palabras"]
[null,null,{"$f":"SUM(IF(LEN(TRIM(C7:C225))=0,0,LEN(TRIM(C7:C225))-LEN(SUBSTITUTE(C7:C225,\" \",\"\"))+1))","v":335}]

{"sheet":"Output","index":12,"n_rows":17,"n_cols":14,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["Spreadsheet","Measures","Basic school information","Basic school information","Basic school information","Basic school information","Basic school information",null,null,"Report"]
["Parameter","Applicable to","Location","Education level: Pre-primary education","Education level: Primary education","Education level:  secondary education","Education level: Tertiary education","Private school included",null,"Education levels","Label of education level","Education level + grade level",null,"Filter list"]
["Value",null,5,false,false,true,false,2,null,{"$f":"D3","v":false},"Educación preescolar",{"$f":"_xlfn.CONCAT(K3, \" (\", 'Información sobre las escuelas'!G32, \")\")","v":"Educación preescolar ()"},null,{"$f":"_xlfn._xlws.FILTER(L3:L6, J3:J6 = TRUE, \"\")","v":"Educación secundaria (1ro-5to)"}]
[1,"Todas las escuelas, independientemente de su estado de reapertura",{"$f":"'Información sobre las escuelas'!F9","v":"Perú"},"educación preescolar,","educación primaria,","educación secundaria,","educación terciaria",null,null,{"$f":"E3","v":false},"Educación primaria",{"$f":"_xlfn.CONCAT(K4, \" (\", 'Información sobre las escuelas'!G33, \")\")","v":"Educación primaria ()"}]
[2,"Escuelas reabiertas",{"$f":"'Información sobre las escuelas'!G24","v":0},null,null,null,null,null,null,{"$f":"F3","v":true},"Educación secundaria",{"$f":"_xlfn.CONCAT(K5, \" (\", 'Información sobre las escuelas'!G34, \")\")","v":"Educación secundaria (1ro-5to)"}]
[3,null,{"$f":"'Información sobre las escuelas'!G25","v":0},null,null,null,null,null,null,{"$f":"G3","v":false},"Educación terciaria",{"$f":"_xlfn.CONCAT(K6, \" (\", 'Información sobre las escuelas'!G36, \")\")","v":"Educación terciaria ()"}]
[4,null,{"$f":"'Información sobre las escuelas'!G26","v":0}]
[5,null,{"$f":"'Información sobre las escuelas'!G27","v":"Moises Moreno Romero"}]
[6]
[7]
[8]
[9]
[10]
[]
[]
[null,"Conteo de palabras"]
[null,{"$f":"SUM(IF(LEN(TRIM(B3:K7))=0,0,LEN(TRIM(B3:K7))-LEN(SUBSTITUTE(B3:K7,\" \",\"\"))+1))","v":41}]