{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Introduction","Planned measures for reopening","Basic information about schools","School reopening status","Qty of additional resources","Calculators","Prices of additional resources","Funding","Report","Items to purchase","List_Economy","Data prep","Output"],"not_rendered":{"charts":6,"images":36,"macros":1,"external_links":1,"defined_names":218,"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":"Introduction","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],[40,2,40,3],[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\n23 de febrero de 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,"Verifique las medidas que aplican a su contexto y especifique si aplican únicamente a las escuelas reabiertas o a todas las escuelas. "]
[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 planilla: \"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 mueve 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,"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":"Planned measures for reopening","index":1,"n_rows":36,"n_cols":10,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,"<Verificar las medidas que aplican a su contexto>",null,null,"<Indicar si las medidas aplican a todas las escuelas o a las escuelas reabiertas cuando están codificadas por color>"]
[null,null,null,"Medidas","Explicación de las medidas","Aplican a","Consecuencias financieras",null," "]
[null,null,null,"Eje 1:  medidas relacionadas con la seguridad de las operaciones"]
[null,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,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 médicas 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,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,null,"Realizar controles médicos in situ","Realizar un control médico simple a todo el personal, alumnos y visitantes que ingresen al edificio, que incluya temperatura del cuerpo y verifique la existencia de síntomas de alto riesgo. ","Escuelas reabiertas","Aumento en el costo",null,null,"P104"]
[null,null,null,"Monitorear síntomas a través de encuestas realizadas a los padres","Elaborar un/s cuestionario/encuesta de salud para monitorear el historial de fiebre y otros síntomas. Los padres, tutores y cuidadores pueden responder ellos mismos estas preguntas a través de los portales de salud escolares o las plataformas de comunicación de las escuelas. Las escuelas también pueden compartir los resultados con los padres y ayudar con los informes diarios.","Escuelas reabiertas","Aumento en el costo",null,null,"P105"]
[null,null,null,"Limitar el intercambio de objetos","Asegurar, en la medida de lo posible, la existencia de suministros adecuados para minimizar el intercambio de materiales que se tocan con frecuencia (p. ej., asignarle a cada alumno sus propios materiales de arte y equipos) o limitar el uso de suministros y equipos a un grupo de niños por vez, con limpieza y desinfección de por medio. Evitar el intercambio de dispositivos electrónicos, juguetes, libros y otros materiales lúdicos o didácticos.","Escuelas reabiertas","Aumento en el costo",null,null,"P106"]
[null,null,null,"Asegurar los espacios, materiales y estrategias para mantener la distancia física y social","Aumentar el espacio entre escritorios (al menos 1,5 metros entre escritorios).\nReconvertir los espacios escolares (o comunitarios) no utilizados o de bajo uso para incrementar el espacio para las aulas y facilitar el distanciamiento social, incluidos espacios al aire libre. \nEscalonar el horario de ingreso y egreso, los recreos/recesos y la hora del almuerzo. \nMinimizar los recesos compartidos. ","Escuelas reabiertas","Aumento en el costo",null,null,"P107"]
[null,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,null,"Instruir a alumnos, docentes, personal y padres respecto a la seguridad de las operaciones escolares","Educar a todos en la escuela respecto a la prevención y los protocolos de seguridad en torno a la COVID-19. \nExplicarles a los estudiantes la razón de las medidas en la escuela (fomentar los buenos modales al toser o estornudar y discutir la necesidad de protocolos de seguridad, la existencia de diferentes sensibilidades, protocolos de higiene de manos, especialmente luego de ir al baño, antes de comer y después de sonarse la nariz, toser o estornudar). \nComunicar a los padres las medidas que las escuelas están implementando y pedirles su colaboración para informar de cualquier caso de COVID-19 que ocurra en el hogar, así como la importancia de monitorear y responder ante cualquier síntoma de COVID-19 en el hogar, los protocolos para acompañar y recoger a los alumnos, etc.). Brindar actualizaciones semanales a medida que la pandemia evoluciona. Emitir anuncios periódicos sobre la necesidad de reducir la transmisión de COVID-19 por el sistema de altavoces. \nIncluir mensajes (por ejemplo, videos) respecto a los comportamientos que previenen la transmisión de COVID-19 cuando se le habla al personal y las familias (en sitios web escolares, correos electrónicos y en las cuentas de la escuela en las redes sociales). \nColocar letreros en ubicaciones de alta visibilidad (p. ej., entradas a la escuela, baños) que promuevan medidas de protección diarias y que describan cómo frenar la transmisión de gérmenes.","Escuelas reabiertas","Aumento en el costo",null,null,"P109"]
[null,null,null,"Mantener un nivel de colaboración y coordinación apropiados con las autoridades de salud pública locales. ","De aparecer un caso o un brote en la escuela, proporcionarles a los funcionarios de salud pública y a los padres la información necesaria para rastrear contactos. Los funcionarios escolares deben notificar a las autoridades de salud pública de darse un caso positivo de COVID-19. Elaborar un plan junto al departamento de salud regional y local para el seguimiento de casos cuando surja un caso positivo en la escuela. Asegurarse que los alumnos que hayan tenido contacto con un caso de COVID-19 permanezcan en sus casas por 14 días. ","Escuelas reabiertas","Aumento en el costo",null,null,"P110"]
[null,null,null,"Adaptar el transporte","Poner en marcha medidas de higiene respiratoria y de manos y de distanciamiento físico en los medios de transporte como autobuses escolares, así como consejos para que los estudiantes viajen de forma segura hacia y desde la escuela, incluido el uso de transporte público. \nSolo un niño por asiento y una distancia de al menos un metro dentro de los autobuses escolares, de ser posible. También de ser posible, las ventanas del autobús deben permanecer abiertas. Los alumnos, el conductor y el acompañante deben viajar con mascarillas. Los conductores deben llevar un registro diario de los alumnos que viajan. \nDesaconsejar los amontonamientos durante la salida de la escuela o el jardín de infantes. ","Escuelas reabiertas","Aumento en el costo",null,null,"P111"]
[null,null,null,"Adaptar la ventilación","Los sistemas de ventilación deben operar de forma correcta y, de ser posible, debe aumentarse la circulación de aire del exterior, por ejemplo abriendo las ventanas y las puertas.","Escuelas reabiertas","Aumento en el costo",null,null,"P112"]
[null,null,null,"Reorganizar el programa de almuerzo","Tener en cuenta opciones como almuerzos de tipo “tomar y llevar” en una bolsa o la entrega de comida. \nUtilizar artículos descartables para la comida (utensilios, platos). Mejorar la higiene y los controles para identificar enfermedades entre el personal de cocina y sus contactos más cercanos. ","Escuelas reabiertas","Aumento en el costo",null,null,"P113"]
[null,null,null,"Cancelar las excursiones, las asambleas y otras reuniones grandes","Cancelar las excursiones, eventos y actividades extracurriculares que impliquen las reuniones de personas. ","Todas las escuelas, independientemente de su estado de reapertura","Ahorros potenciales",null,null,"P114"]
[null,null,null,"Eje 2: medidas para sostener el aprendizaje"]
[null,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 las instrucciones. ","Todas las escuelas, independientemente de su estado de reapertura","Aumento en el costo",null,null,"P201"]
[null,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,null,"Realizar evaluaciones de diagnóstico","Preparar a los docentes para que evalúen las necesidades de aprendizaje y para encontrarse con cada alumno allí donde se encuentre. Brindar capacitación a los docentes sobre cómo evaluar las necesidades, bienestar y desempeño de los alumnos. ","Escuelas reabiertas","Aumento en el costo",null,null,"P203"]
[null,null,null,"Aumentar la intensidad y la diferenciación (aprendizaje personalizado)","Poner en marcha programas de recuperación y aceleración del aprendizaje a gran escala. De ser posible, contratar auxiliares pedagógicos para proporcionar clases de refuerzo cara a cara o grupales. ","Escuelas reabiertas","Aumento en el costo",null,null,"P204"]
[null,null,null,"Extender los horarios","Extender los horarios, especialmente para aquellos alumnos que se están quedando atrás. De ser necesario, utilizar el verano para recuperar algunos de los días de clase perdidos para mitigar la pérdida de aprendizaje. ","Escuelas reabiertas","Aumento en el costo",null,null,"P205"]
[null,null,null,"Contratar nuevos docentes, reorganizar los turnos de trabajo o extender el horario de trabajo de los docentes","Contratar nuevos docentes, reorganizar los turnos de trabajo o extender el horario de trabajo de los docentes para i) asegurar un tamaño de clase más pequeño y ii) sustituir a los docentes enfermos. Reasignar a la mayoría de los docentes de riesgo (edad, comorbilidades) al aprendizaje a distancia o tareas administrativas. ","Escuelas reabiertas","Aumento en el costo",null,null,"P206"]
[null,null,null,"Eje 3: medidas para apoyar el bienestar y la recuperación emocional"]
[null,null,null,"Proporcionar apoyo y asesoramiento psicosocial exclusivo.","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,null,"Adoptar programas de aprendizaje social y emocional (ASE)","Fomentar las relaciones entre alumnos y entre alumnos y adultos en la escuela. Reducir el estigma. Apoyar el bienestar social y emocional de alumnos y docentes. ","Escuelas reabiertas","Aumento en el costo",null,null,"P302"]
[null,null,null,"Eje 4: medidas para llegar a los más marginados"]
[null,null,null,"Proporcionar apoyo adecuado para las necesidades de recuperación, especialmente entre alumnos desfavorecidos y vulnerables.","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. \nIncluir máscaras faciales transparentes en la lista de suministros escolares para 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. \nProporcionar instrucciones personalizadas o programas extracurriculares para ayudar a los alumnos con necesidades especiales a ponerse al día. ","Escuelas reabiertas","Aumento en el costo",null,null,"P401"]
[null,null,null,"Llevar a cabo campañas de rematriculación y apoyo envolvente para evitar la deserción.","Este apoyo incluye incentivos financieros y no financieros; por ejemplo, programas de alimentación, provisión de uniformes escolares o la eliminación o exención de la matrícula escolar, así como otras barreras para evitar la asistencia escolar. Proporcionar apoyo social y emocional a los niños fuera de la escuela. Asegurar un seguimiento frecuente y acorde a la edad y apoyo para los niños fuera de la escuela y evitar penalizar o estigmatizar a dichos alumnos. ","Escuelas reabiertas","Aumento en el costo",null,null,"P402"]
[null,null,null,"Monitorear y planificar el ausentismo","Revisar los patrones normales de ausentismo escolar tanto en alumnos como en el personal. Alertar a los funcionarios de salud locales respecto a grandes aumentos en el ausentismo de los alumnos o del personal. ","Escuelas reabiertas","Aumento en el costo",null,null,"P403"]

{"sheet":"Basic information about schools","index":2,"n_rows":103,"n_cols":19,"rows_kept":103,"cut":false,"hidden":false,"merged":[[77,3,77,5],[44,3,44,5],[42,3,42,14],[47,2,47,15],[13,3,13,14],[16,3,16,14],[19,3,19,14]]}
[]
[]
[]
[]
[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/economía",null,null,"Storyland",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,"Directrices sobre cómo abrir una escuela paso a paso en Storyland"]
[]
[null,null,null,"2) Enlace al documento."]
[]
[]
[null,null,null,"3) ¿Cuáles son los niveles educativos abarcados por el plan de reapertura de la escuela?"]
[null,null,null,"Jardín de infantes a 12.º grado"]
[]
[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,"Región Neverland","<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>"]
[null,null,null,null,null,null,null,"<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,"Edad 3-5","<Indique los grados o grupos etarios>"]
[null,null,null,null,null,null,"Jardín a 3.º","<Indique los grados>"]
[null,null,null,null,null,null,null,"<Indique los grados>"]
[null,null,null,null,null,null,null,"<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,"El primer semestre de 2021."]
[]
[null,null,null,{"$f":"\"Number of school days during the time period of interest, i.e., \"&LOWER(D43)&\"\"","v":"Number of school days during the time period of interest, i.e., el primer semestre de 2021."},null,null,90,"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. Basic statistics of the education levels of interest (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(Output!H3=TRUE,Output!H4,\"\")&\" ) \"&IF(F9 = \"\", \"\", \"in \"&CHOOSE(Output!C3,Output!C4,Output!C5,Output!C6,Output!C7,Output!C8)&\"\") &\"\"","v":"4. Basic statistics of the education levels of interest (i.e., educación preescolar, educación primaria,    ) in Región Neverland"}]
[]
[null,null,null,"Alumnos, escuelas y clases"]
[null,null,null,"Cantidad de alumnos",null,null,10000]
[null,null,null,"Cantidad de escuelas",null,null,50,"Escuelas privadas incluidas "]
[null,null,null,"Cantidad de clases",null,null,500]
[]
[null,null,null,"Cantidad de alumnos por escuela",null,null,{"$f":"IF(ISERROR(N_student/N_school), \"\", N_student/N_school)","v":200}]
[null,null,null,"Cantidad de alumnos por clase",null,null,{"$f":"IF(ISERROR(N_student/N_class), \"\", N_student/N_class)","v":20}]
[null,null,null,"Cantidad de alumnos con necesidades especiales",null,null,1000]
[]
[]
[null,null,null,null,null,null,"Total",null,"Disponible actualmente","Recién contratados"]
[null,null,null,"Docentes y personal escolar",null,null,{"$f":"SUM(N_teacher, N_management_staff, N_teaching_aid, N_cleaner, N_nurse, N_driver, N_food_staff, N_technician, N_counselor, N_psychologist, N_social_worker, N_mobilizer, N_other_staff)","v":2240},null,{"$f":"SUM(N_teacher_current, N_management_staff_current, N_teaching_aid_current, N_cleaner_current, N_nurse_current, N_driver_current, N_food_staff_current, N_technician_current, N_counselor_current, N_psychologist_current, N_social_worker_current, N_mobilizer_current, N_other_staff_current)","v":2060},{"$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_driver, N_newly_hired_food_staff, N_newly_hired_technician, N_newly_hired_counselor, N_newly_hired_psychologist, N_newly_hired_social_worker, N_newly_hired_mobilizer, N_newly_hired_other_staff)","v":180}]
[null,null,null,"Cantidad de docentes",null,null,{"$f":"N_teacher_current + N_newly_hired_teacher","v":1050},null,1000,50,"<La Calculadora 1.1 le ayuda a calcular la demanda de nuevos docentes>"]
[null,null,null,"Cantidad de personal administrativo",null,null,{"$f":"N_management_staff_current + N_newly_hired_management_staff","v":200},null,200,null,"<Asuma que no se contrata personal administrativo nuevo, pero esto puede ser sobrescrito.>"]
[null,null,null,"Cantidad de auxiliares pedagógicos",null,null,{"$f":"N_teaching_aid_current + N_newly_hired_teaching_aid","v":120},null,100,20,"<La Calculadora 1.2 le ayuda a calcular la demanda de auxiliares pedagógicos>"]
[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":110},null,100,10,"<La Calculadora 1.3 le ayuda a calcular la demanda de personal de limpieza>"]
[null,null,null,"Enfermeras escolares",null,null,{"$f":"N_nurse_current + N_newly_hired_nurse","v":110},null,100,10,"<La Calculadora 1.3 le ayuda a calcular la demanda de enfermeras escolares>"]
[null,null,null,"Conductores de autobús escolares",null,null,{"$f":"N_driver_current + N_newly_hired_driver","v":100},null,100,null,"<Asuma que no se contratan conductores de autobús nuevos, pero esto puede ser sobrescrito.>"]
[null,null,null,"Personal de cocina",null,null,{"$f":"N_food_staff_current + N_newly_hired_food_staff","v":100},null,100,null,"<Asuma que no se contrata personal de cocina nuevo, pero esto puede ser sobrescrito.>"]
[null,null,null,"Personal de apoyo técnico",null,null,{"$f":"N_technician_current + N_newly_hired_technician","v":110},null,100,10,"<La Calculadora 1.3 le ayuda a calcular la demanda de técnicos>"]
[null,null,null,"Asesores",null,null,{"$f":"N_counselor_current + N_newly_hired_counselor","v":100},null,80,20,"<La Calculadora 1.3 le ayuda a calcular la demanda de asesores>"]
[null,null,null,"Psicólogos",null,null,{"$f":"N_psychologist_current + N_newly_hired_psychologist","v":100},null,80,20,"<La Calculadora 1.3 le ayuda a calcular la demanda de psicólogos>"]
[null,null,null,"Trabajadores sociales",null,null,{"$f":"N_social_worker_current + N_newly_hired_social_worker","v":100},null,80,20,"<La Calculadora 1.3 le ayuda a calcular la demanda de trabajadores sociales>"]
[null,null,null,"Movilizadores sociales para la campaña de matriculación",null,null,{"$f":"N_mobilizer_current + N_newly_hired_mobilizer","v":40},null,20,20,"<La Calculadora 1.3 le ayuda a calcular la demanda de movilizadores sociales>"]
[null,null,null,"Otros",null,null,{"$f":"N_other_staff_current + N_newly_hired_other_staff","v":0},null,0,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_special_needs/N_student)), \"\", N_teacher * (N_student_special_needs/N_student))","v":105},"<La configuración predeterminada asume que esta cifra es proporcional al número de alumnos con necesidades especiales>"]
[]
[null,null,null,"Autobús escolar",null,null,null,null,null,null,null,null,null,null,null,null,null,null,111]
[null,null,null,"Porcentaje de alumnos que utilizan autobuses escolares"]
[null,null,null,null,"En la etapa con COVID-19",null,0.3,"entre los que asisten a la escuela"]
[null,null,null,null,"En la etapa pre COVID-19",null,0.5,"entre los que asisten a la escuela"]
[null,null,null,"Capacidad total de los autobuses escolares, en promedio",null,null,20,"alumnos por autobús "]
[]
[null,null,null,"Almuerzo escolar",null,null,null,null,null,null,null,null,null,null,null,null,null,null,113]
[null,null,null,"Porcentaje de escuelas que en este momento brindan un almuerzo escolar",null,null,0.9,"entre los que asisten a la escuela"]
[]
[null,null,null,"Evaluaciones de diagnóstico",null,null,null,null,null,null,null,null,null,null,null,null,null,null,203]
[null,null,null,"Porcentaje de estudiantes que deben testearse",null,null,0.95]
[]
[null,null,null,"Aprendizaje personalizado (en forma de clases de refuerzo)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,204]
[null,null,null,"Porcentaje de alumnos que necesitan aprendizaje personalizado",null,null,0.2]
[]
[null,null,null,"Instalaciones"]
[null,null,null,"¿Cuántos salones de clase comparten un baño?",null,null,4]
[null,null,null,"¿Los docentes de cuántos salones de clase comparten una oficina?",null,null,4]
[]
[null,null,"5. ¿En qué moneda se expresa el costo? ",null,null,null,"Bea"]
[]
[null,null,"6. ¿En qué año desea expresar el costo?",null,null,null,2021]
[]
[null,null,null,"."]

{"sheet":"School reopening status","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":"\"School reopening status during \"&LOWER('Basic information about schools'!D43)&\"\"","v":"School reopening status during el primer semestre de 2021."}]
[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":"\"Average cross \"&LOWER('Basic information about schools'!D43)&\"\"","v":"Average cross el primer semestre de 2021."}]
[null,null,"Porcentaje de escuelas que imparten clases presenciales",null,null,null,null,0.2,null,0.4,null,0.9,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":0.5}]
[]
[null,null,"Porcentaje de alumnos que asisten a clases presenciales",null,null,null,null,0.4,null,0.6,null,0.95,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.65}]
[]
[null,null,"Cantidad de días de escuela (en días)*",null,null,null,null,30,null,30,null,30]
[]
[null,null,"Porcentaje de docentes y personal escolar presente en la escuela**",null,null,null,null,{"$f":"H10","v":0.2},null,{"$f":"J10","v":0.4},null,{"$f":"L10","v":0.9},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":0.5}]
[]
[null,null,{"$f":"\"<*The number of school days in all phases should sum up to \"&N_school_days&\".>\"","v":"<*The number of school days in all phases should sum up to 90.>"}]
[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":249}]

{"sheet":"Qty of additional resources","index":4,"n_rows":127,"n_cols":10,"rows_kept":127,"cut":false,"hidden":false,"merged":[[111,3,113,3],[114,3,115,3],[125,3,126,3],[79,3,81,3],[84,3,85,3],[86,3,87,3],[96,3,97,3],[100,3,101,3],[111,2,116,2],[119,2,124,2],[31,3,32,3],[33,3,34,3],[35,3,36,3],[37,3,38,3],[49,3,50,3],[51,3,52,3],[56,3,57,3],[58,3,59,3],[60,3,61,3],[65,3,66,3],[69,3,70,3],[71,3,72,3],[73,3,74,3],[76,3,78,3],[94,2,97,2],[98,2,99,2],[100,2,101,2],[102,2,103,2],[105,2,110,2],[56,2,59,2],[60,2,67,2],[69,2,74,2],[76,2,82,2],[83,2,93,2],[28,3,29,3],[24,2,26,2],[27,2,38,2],[39,2,45,2],[49,2,54,2],[6,4,6,5],[8,2,23,2],[9,3,10,3],[11,3,12,3],[13,3,14,3],[17,3,18,3],[20,3,21,3]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,"<Verificar si la configuración predeterminada tiene sentido para usted. Caso contrario, revísela en base a 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,null,"Ver Calculadora 2.1 para más detalles",null,null,"P101"]
[null,null,null,"Contenedores vacíos para diluir los productos de limpieza y desinfección",1,"contenedor(es) por limpiador (objetivo)"]
[null,null,null,null,0.5,"contenedor(es) por limpiador (disponibles ahora)"]
[null,null,null,"pulverizadores con desinfectantes electrostáticos",1,"pulverizador(es) por limpiador (objetivo)"]
[null,null,null,null,0.5,"pulverizador(es) por limpiador (disponibles ahora)"]
[null,null,null,"Trapeadores, baldes y cepillos",1,"equipo(s) por aula/baño/oficina (objetivo)"]
[null,null,null,null,0.5,"equipo(s) por aula/baño/oficina (disponibles ahora)"]
[null,null,null,"Barras de jabón",1,"barra(s) de jabón por aula/baño/oficina"]
[null,null,null,"Agua",{"$f":"MAX(Calculators!I89/(Calculators!I90/5), Calculators!I154/Calculators!I155) - 1","v":4},"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,"Guantes de goma para el personal de limpieza",2,"par(es) por limpiador (objetivo)"]
[null,null,null,null,1,"par(es) por limpiador (disponibles ahora)"]
[null,null,null,"Batas desechables para el personal de limpieza",1,"bata(s) por limpiador por día"]
[null,null,null,"Batas y gorras reutilizables para el personal de limpieza",2,"conjunto(s) por limpiador (objetivo)","Un par por aula y un par por baño por limpiador."]
[null,null,null,null,1,"conjunto(s) por limpiador (disponibles ahora)"]
[null,null,null,"Personal de limpieza recién contratado ",{"$f":"N_newly_hired_cleaner","v":10},"empleado(s) a tiempo completo"]
[null,null,null,"Horas extra para el personal de limpieza",0,"hora(s) por limpiador por día "]
[null,null,"Proporcionar equipos de protección personal ","Mascarillas reutilizables",null,null,"Ver Calculadora 4.1 para más detalles",null,null,"P102"]
[null,null,null,"Mascarillas desechables",null,null,"Ver Calculadora 4.2 para más detalles"]
[null,null,null,"Máscaras faciales",1,"máscaras faciales por docente o personal escolar"]
[null,null,"Proporcionar materiales para higienizar las manos","Antisépticos de base alcohólica (al menos 70 por ciento alcohol)",null,null,"Ver Calculadora 3.1 para más detalles",null,null,103]
[null,null,null,"Dispensadores antisépticos",2,"dispensador(s) por aula/baño/oficina (objetivo)"]
[null,null,null,null,1,"dispensador(s) por aula/baño/oficina (disponibles ahora)"]
[null,null,null,"Jabón líquido",null,null,"Ver Calculadora 3.3 para más detalles"]
[null,null,null,"Papel secante",2,"rollo(s) por persona (incluidos docentes, alumnos y personal escolar) por mes (20 días de escuela) (objetivo)"]
[null,null,null,null,1,"rollo(s) por persona (incluidos docentes, alumnos y personal escolar) por mes (20 días de escuela) (disponibles ahora)"]
[null,null,null,"Toallitas descartables registradas en la EPA",2,"paquete(s) por persona por mes (20 días de escuela) (objetivo)"]
[null,null,null,null,1,"paquete(s) por persona por mes (20 días de escuela) (disponibles ahora)"]
[null,null,null,"Botes de basura sin contacto/a pedal",2,"bote(s) de basura por aula/baño/oficina (objetivo)"]
[null,null,null,null,1,"bote(s) de basura por aula/baño/oficina (disponibles ahora)"]
[null,null,null,"Secador de manos ",1,"secador(es) de manos por baño (objetivo)"]
[null,null,null,null,1,"secador(es) de manos por baño (disponibles ahora)"]
[null,null,"Realizar controles médicos in situ","Sensores de temperatura automáticos ",null,null,"Ver Calculadora 5 para más detalles",null,null,"P104"]
[null,null,null,"Oxímetros",null,null,"Ver Calculadora 5 para más detalles"]
[null,null,null,"Horas extra para el personal adecuadamente capacitado para realizar controles médicos",1,"hora(s) por controlador por día","Ver Calculadora 5 para el número de personas necesarias en una escuela"]
[null,null,null,"Máscaras protectoras y guantes desechables para el personal encargado de los controles médicos",1,"conjuntos por controlador por día"]
[null,null,null,"Enfermeras a tiempo completo recién contratadas",{"$f":"N_newly_hired_nurse","v":10},"empleado(s) a tiempo completo"]
[null,null,null,"Horas extra para enfermeras a tiempo completo",1,"hora(s) por enfermera por día"]
[null,null,null,"Sala de emergencia/consultorio médico/salas de aislamiento",2,"sala(s) por escuela"]
[null,null,"Monitorear síntomas a través de encuestas realizadas a los padres","Horas extra para los técnicos encargados de i) poner en marcha el monitoreo de salud en línea y la plataforma para presentar informes, y ii) preparar y difundir los informes diarios.",0,"hora(s) por técnico por día",null,null,null,"P105"]
[null,null,"Limitar el intercambio de objetos","Materiales de enseñanza o aprendizaje que deben adquirirse para minimizar el intercambio.",100,"conjunto(s)","Indicar qué materiales de enseñanza o aprendizaje necesitan ser adquiridos. En caso necesario, agregar más filas al final de la tabla. ",null,null,"P106"]
[null,null,"Asegurar los espacios, materiales y estrategias para mantener la distancia física y social","Costo de alquilar los espacios comunitarios sin utilizar.",0,"metros cuadrados por escuela por día","Reglas generales para determinar la superficie necesaria: \n1) Mantener una distancia de al menos un metro cuadrado entre todas las personas presentes en la escuela.  \n2) La creación de burbujas significa mantener a los mismos grupos pequeños de alumnos (diez o menos) junto al mismo personal por el mayor tiempo posible.",null,null,"P107"]
[null,null,"Establecer barreras y guías físicas","Barreras físicas en las aulas",1,"Pantalla(s) de plástico flexible por alumno",null,null,null,"P108"]
[null,null,null,null,0.8,"de todas las escuelas reabiertas eligen instalar las barreras físicas"]
[null,null,null,"Barreras físicas entre los lavabos del baño",5,"lavabo(s) por baño"]
[null,null,null,null,0.8,"de todas las escuelas reabiertas eligen instalar las barreras físicas"]
[null,null,null,"Cintas para crear señales en los pisos y aceras",10,"rollo(s) de cinta por escuela"]
[null,null,null,"Carteles o señales en las paredes",10,"cartel(es) por escuela"]
[null,null,"Instruir a alumnos, docentes, personal y padres respecto a la seguridad de las operaciones escolares","Horas extra para los docentes y el personal que participen en la capacitación relacionada con la seguridad de las operaciones.",1,"hora(s) por docente o miembro del personal",null,null,null,"P109"]
[null,null,"Mantener un nivel de colaboración y coordinación apropiados con las autoridades de salud pública locales. ","Batas o ropa quirúrgica para las enfermeras escolares",2,"bata(s) o ropa quirúrgica por enfermera (objetivo)",null,null,null,"P110"]
[null,null,null,null,1,"bata(s) o ropa quirúrgica por enfermera (disponibles ahora)"]
[null,null,null,"EPP necesario para atender casos sospechosos",1,"conjuntos de batas, guantes desechables y máscaras por caso sospechoso"]
[null,null,null,null,2,"casos sospechosos por escuela por día"]
[null,null,"Adaptar el transporte","Máquinas de humo para autobuses",1,"máquina de humo por conductor de autobús (objetivo)",null,null,null,"P111"]
[null,null,null,null,0.5,"máquina de humo por conductor de autobús (disponibles ahora)"]
[null,null,null,"Desinfectante para autobuses",null,null,"Ver Calculadora 2.2"]
[null,null,null,"Sensores de temperatura automáticos para controlar la temperatura de los alumnos antes de subir a bordo.",1,"sensor(es) de temperatura por conductor de autobús"]
[null,null,null,"Antisépticos de base alcohólica (al menos 70 por ciento alcohol)",null,null,"Ver Calculadora 3.2"]
[null,null,null,"Dispensadores antisépticos",2,"dispensador(es) por conductor de autobús (objetivo)"]
[null,null,null,null,1,"dispensador(es) por conductor de autobús (disponibles ahora)"]
[null,null,null,"Combustible adicional",0.5,"de la capacidad normal para adherir a las directrices sobre distanciamiento físico",{"$f":"\"Since school buses is runing at \"&ROUND(pct_bus_capacity, 2)*100&\"% of the full capacity, the amount of fuel needed is \"&ROUND(1/pct_bus_capacity,1)&\" times of the amount needed before, or (\"&ROUND(1/pct_bus_capacity,1)& -1&\") times more than the fuel cost in the Pre-COVID-19 era to transport the same number of students.\"","v":"Since school buses is runing at 50% of the full capacity, the amount of fuel needed is 2 times of the amount needed before, or (2-1) times more than the fuel cost in the Pre-COVID-19 era to transport the same number of students."}]
[null,null,"Adaptar la ventilación","Actualizar sistemas de climatización",0.1,"de las escuelas reabiertas deben actualizar sus sistemas de climatización",null,null,null,"P112"]
[null,null,"Reorganizar el programa de almuerzo","Batas, delantales y gorros para el personal de cocina",1,"conjunto(s) por trabajador de cocina (objetivo)",null,null,null,"P113"]
[null,null,null,null,1,"conjunto(s) por trabajador de cocina (disponibles ahora)"]
[null,null,null,"Utensilios desechables",1,"conjunto(s) por alumno para aquellos que almuerzan en la escuela (objetivo)","Si una escuela ha estado proporcionando utensilios desechables, no pareciera que necesitase más debido a la respuesta a la COVID-19. Podrían ahorrarse algunos recursos respecto al anterior cierre escolar. "]
[null,null,null,null,1,"conjunto(s) por alumno para aquellos que almuerzan en la escuela (disponibles ahora)"]
[null,null,null,"Platos desechables",1,"Plato(s) desechable(s) por alumno para aquellos que almuerzan en la escuela (objetivo)","Si una escuela ha estado proporcionando platos desechables, no pareciera que se necesitase más a causa de la respuesta a la COVID-19. Podrían ahorrarse algunos recursos respecto al anterior cierre escolar. "]
[null,null,null,null,1,"plato(s) desechable(s) por alumno para aquellos que almuerzan en la escuela (disponibles ahora)"]
[null,null,"Eje 2: medidas para sostener el aprendizaje"]
[null,null,"Posibilitar el desarrollo profesional de los docentes.","Horas extra para los docentes que participen en las sesiones de capacitación sobre pedagogía",2,"sesiones por docente que participa en las sesiones de capacitación sobre pedagogía",null,null,null,"P201"]
[null,null,null,null,1,"hora(s) por sesión"]
[null,null,null,null,1,"de todos los docentes participan en las sesiones de capacitación sobre pedagogía"]
[null,null,null,"Compensación para los capacitadores externos que proporcionen sesiones de capacitación",50,"capacitador(es) externo(s)"]
[null,null,null,null,20,"sesiones por capacitador"]
[null,null,null,null,1,"hora(s) por sesión"]
[null,null,null,"Materiales para la capacitación profesional de los docentes",1,"conjunto(s) por docente"]
[null,null,"Mantener los enfoques flexibles o parciales de aprendizaje remoto","Plataformas de aprendizaje remotas",null,null,"Ver Calculadora 6 para más detalles",null,null,"P202"]
[null,null,null,"Compensación para acceder a Internet",0.4,"de todos los docentes reciben compensación para acceder a Internet"]
[null,null,null,null,0.5,"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",0.4,"de todos los docentes reciben compensación para planes de datos de los teléfonos celulares"]
[null,null,null,null,0.5,"de todos los alumnos reciben compensación para planes de datos de los teléfonos celulares"]
[null,null,null,"Computadoras de escritorio",100,"computadoras de escritorio"]
[null,null,null,"Computadoras portátiles",200,"computadoras portátiles"]
[null,null,null,"Tabletas",200,"tabletas"]
[null,null,null,"Teléfonos",200,"teléfonos"]
[null,null,null,"Técnicos recién contratados",{"$f":"N_newly_hired_technician","v":10},"empleado(s) a tiempo completo"]
[null,null,null,"Horas extra para técnicos u otro personal que proporcione asistencia técnica",1,"hora(s) por técnico por día"]
[null,null,"Realizar evaluaciones de diagnóstico","Importe de la licencia para las evaluaciones",1,"licencia(s)","Indique cómo se cobra la licencia: p. ej., ¿por escuela o por alumno?",null,null,"P203"]
[null,null,null,"Impresión de las evaluaciones (si se entregan en papel)",2,"página(s) a imprimir por cada alumno evaluado"]
[null,null,null,"Compensación para especialistas en evaluación externos para elaborar las evaluaciones y proporcionar capacitación",10,"especialistas en evaluación externos"]
[null,null,null,null,10,"hora(s) por especialista en evaluación"]
[null,null,"Aumentar la intensidad y la diferenciación (aprendizaje personalizado)","Importe de la licencia para los programas de recuperación y aceleración",1,"licencia(s)","Indique cómo se cobra la licencia. ",null,null,"P204"]
[null,null,null,"Pago para los auxiliares pedagógicos que proporcionan aprendizaje personalizado en forma de clases de refuerzo"]
[null,null,"Extender los horarios","Horas extra para los docentes para proporcionar instrucciones",8,"hora(s) por día para esos días extendidos",null,null,null,"P205"]
[null,null,null,null,30,"día(s) extendidos"]
[null,null,"Contratar nuevos docentes, reorganizar los turnos de trabajo o extender el horario de trabajo de los docentes","Docentes adicionales contratados para asegurar grupos más pequeños y sustituir a colegas enfermos",{"$f":"N_newly_hired_teacher","v":50},"empleado(s) a tiempo completo",null,null,null,"P206"]
[null,null,null,"Horas extra para que los docentes actuales sustituyan a sus colegas enfermos"]
[null,null,"Eje 3: medidas para apoyar el bienestar y la recuperación emocional"]
[null,null,"Proporcionar apoyo y asesoramiento psicosocial exclusivo.","Asesores recién contratados",{"$f":"N_newly_hired_counselor","v":20},"empleado(s) a tiempo completo",null,null,null,"P301"]
[null,null,null,"Horas extra para asesores",0,"hora(s) por asesor por día"]
[null,null,null,"Trabajadores sociales recién contratados",{"$f":"N_newly_hired_social_worker","v":20},"empleado(s) a tiempo completo"]
[null,null,null,"Horas extra para trabajadores sociales",0,"hora(s) por trabajador social por día"]
[null,null,null,"Psicólogos recién contratados",{"$f":"N_newly_hired_psychologist","v":20},"empleado(s) a tiempo completo"]
[null,null,null,"Horas extra para psicólogos",0,"hora(s) por psicólogo por día"]
[null,null,"Adoptar programas de aprendizaje social y emocional (ASE)","Horas extra para los docentes que participen en las sesiones de capacitación ASE ",1,"sesiones por docente que participa en las sesiones de capacitación ASE",null,null,null,"P302"]
[null,null,null,null,1,"hora(s) por sesión de capacitación"]
[null,null,null,null,0.2,"de todos los docentes de la escuela participan en las sesiones de capacitación ASE"]
[null,null,null,"Horas extra para los docentes que promueven el ASE",1,"hora(s) por docente por día para aquellos que trabajan horas extra para promover el ASE"]
[null,null,null,null,0.2,"de todos los docentes de la escuela trabajan horas extra para promover el ASE"]
[null,null,null,"Importe de la licencia para los programas ASE adoptados",4,"licencia(s)","Indique cómo se cobra la licencia: p. ej., ¿por escuela o por alumno? Si se elabora un programa ASE para la respuesta a la COVID-19, indique el costo de elaboración. "]
[null,null,"Eje 4: medidas para llegar a los más marginados"]
[null,null,"Proporcionar apoyo adecuado para las necesidades de recuperación, especialmente entre alumnos desfavorecidos y vulnerables.","Equipo de protección especial o adaptado",10,"conjunto(s) por escuela","Especifique en base al contexto. Para las máscaras faciales transparentes, ver Calculadora 3.2",null,null,"P401"]
[null,null,"Llevar a cabo campañas de rematriculación y apoyo envolvente para evitar la deserción.","Tiempo que le lleva al personal diseñar e implementar las campañas de matriculación",20,"hora(s) por movilizador social",null,null,null,"P402"]
[null,null,null,"Gastos de transporte para las campañas",120,"viaje(s)"]
[null,null,null,"Programas de alimentación",2000,"beneficiario(s)"]
[null,null,null,"Provisión de uniformes escolares",2000,"cantidad de uniformes"]
[null,null,null,"Eliminación o exención de la matrícula escolar",2000,"exenciones de la matrícula escolar"]
[null,null,null,"<Especifique en base al apoyo proporcionado>"]
[null,null,"Monitorear y planificar el ausentismo","Horas extra para que el personal monitoree y planifique el ausentismo (si procede)",2,"miembros del personal para monitorear el ausentismo",null,null,null,"P403"]
[null,null,null,null,1,"hora(s) por día"]

{"sheet":"Calculators","index":5,"n_rows":224,"n_cols":20,"rows_kept":224,"cut":false,"hidden":false,"merged":[[168,2,168,17],[207,2,207,17],[129,4,129,7],[19,3,19,16],[130,4,130,7],[151,4,151,7],[152,4,152,7],[106,11,106,17],[112,3,112,7],[140,4,140,7],[141,4,141,7],[102,11,102,17],[102,4,102,7],[98,3,98,7],[92,3,92,7],[85,11,85,17],[93,3,93,7],[72,11,72,17],[99,11,99,17],[80,11,80,17],[80,3,80,7],[78,11,78,17],[72,3,72,7],[78,3,78,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":"C19","v":"Calculadora 1. Cómo calcular la cantidad de docentes y personal nuevo que se debe contratar."}]
[null,null,null,{"$f":"C70","v":"Calculadora 2. Cómo calcular la cantidad de desinfectante necesario"}]
[null,null,null,{"$f":"C127","v":"Calculadora 3. Cómo calcular la cantidad de antiséptico y jabón líquido para el lavado de manos"}]
[null,null,null,{"$f":"C166","v":"Calculadora 4. Cómo calcular la cantidad de mascarillas"}]
[null,null,null,{"$f":"C196","v":"Calculadora 5. Cómo calcular la cantidad de sensores de temperatura automáticos, oxímetros y personal encargado de los controles médicos"}]
[null,null,null,{"$f":"C211","v":"Calculadora 6: Cómo estimar el costo de desarrollar una plataforma de aprendizaje remoto"}]
[]
[]
[null,null,"Calculadora 1. Cómo calcular la cantidad de docentes y personal nuevo que se debe contratar."]
[null,null,null,"<Tenga en cuenta que los números ingresados únicamente representan la demanda de docentes y personal nuevo. La cantidad real de personas que pueden contratarse por primera vez está determinada tanto por la demanda como la oferta de docentes y personal nuevo. Cuando finalice estos cálculos, tenga en cuenta la viabilidad de contratar docentes y personal nuevo a gran escala en un período corto de tiempo en base a su contexto.>"]
[]
[null,null,null,"1.1. Docentes","a) Asegurar un tamaño de clase más pequeño",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P206"]
[null,null,null,null,null,"Tamaño actual de la clase",null,null,null,null,{"$f":"N_student_per_class","v":20},"alumnos/clase"]
[null,null,null,null,null,"tamaño objetivo de la cohorte",null,null,null,null,10,"alumnos/cohorte",null,"<La creación de burbujas significa mantener a los mismos grupos pequeños de alumnos (diez o menos) junto al mismo personal por el mayor tiempo posible. >"]
[null,null,null,null,null,"Cantidad de nuevos docentes que debe contratarse para este fin",null,null,null,null,{"$f":"IF(ISERROR((K23/K24 - 1) * N_teacher_current), \"\", (K23/K24 - 1) * N_teacher_current)","v":1000},"docentes"]
[]
[null,null,null,null,"b) Sustituir a los docentes enfermos"]
[null,null,null,null,null,{"$f":"\"% of current teachers who may take sick leave during \"&LOWER('Basic information about schools'!D43)&\"\"","v":"% of current teachers who may take sick leave during el primer semestre de 2021."},null,null,null,null,null,null,0.05]
[null,null,null,null,null,"Días promedio de licencia por enfermedad",null,null,null,null,null,null,20,"día(s)"]
[null,null,null,null,null,"Cantidad de horas por día laboral",null,null,null,null,null,null,8,"hora(s)"]
[null,null,null,null,null,"Cantidad total de horas que deben ser sustituidas",null,null,null,null,null,null,{"$f":"M28*N_teacher_current*M29*M30","v":8000},"hora(s)"]
[null,null,null,null,null,"Porcentaje de esas horas que pueden cubrirse con los docentes actuales",null,null,null,null,null,null,0.1]
[null,null,null,null,null,"Cantidad de nuevos docentes que debe contratarse para este fin",null,null,null,null,null,null,{"$f":"IF(ISERROR(N_hour_substitute*(1-M32)/(8*N_school_days)) = TRUE, \"\", N_hour_substitute*(1-M32)/(8*N_school_days))","v":10},"docente(s)"]
[]
[null,null,null,null,"Cantidad total de docentes que deben ser contratados para asegurar grupos más pequeños y sustituir a colegas enfermos",null,null,null,null,null,null,null,{"$f":"IF(ISERROR(K25+M33) = TRUE, \"\", K25+M33)","v":1010},"docente(s)"]
[]
[null,null,null,"1.2. Auxiliares pedagógicos necesarios para proporcionar aprendizaje personalizado en forma de clases de refuerzo",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P204"]
[]
[null,null,null,null,"Cantidad de horas de clase de refuerzo a las que un alumno debe asistir por día",null,null,null,null,null,null,1,"hora(s) por día"]
[null,null,null,null,"Formato de las clases de refuerzo",null,null,null,null,null,"Un auxiliar por cada",1.5,"alumno(s)"]
[null,null,null,null,"Cantidad total de horas laborales para los auxiliares pedagógicos",null,null,null,null,null,null,{"$f":"IF(ISERROR(IF(personalized_learning = \"Reopened schools\", pct_student_personalized_learning * N_student * pct_student_in_school * N_hour_tutoring_per_student_per_day * (1/student_aid_ratio), pct_student_personalized_learning * N_student * N_hour_tutoring_per_student_per_day * (1/student_aid_ratio))) = TRUE, \"\", IF(personalized_learning = \"Reopened schools\", pct_student_personalized_learning * N_student * pct_student_in_school * N_hour_tutoring_per_student_per_day * (1/student_aid_ratio), pct_student_personalized_learning * N_student * N_hour_tutoring_per_student_per_day * (1/student_aid_ratio)))","v":1333.3333333333333},"hora(s)"]
[null,null,null,null,"Cantidad de horas laborales por día",null,null,null,null,null,null,8,"hora(s) por día"]
[null,null,null,null,"Cantidad total de auxiliares pedagógicos necesarios",null,null,null,null,null,null,{"$f":"IF(ISERROR(L41/L42) = TRUE, \"\", L41/L42)","v":166.66666666666666},"auxiliar(es) pedagógico(s)"]
[null,null,null,null,"Cantidad de nuevos auxiliares pedagógicos que se deben contratar",null,null,null,null,null,null,{"$f":"IF(ISERROR(IF((L43-'Basic information about schools'!I64)>0, L43-'Basic information about schools'!I64, \"Sufficient number of\")) = TRUE, \"\", IF((L43-'Basic information about schools'!I64)>0, L43-'Basic information about schools'!I64, \"Sufficient number of\"))","v":66.666666666666657},"auxiliar(es) pedagógico(s)",null,"Cantidad suficiente de"]
[]
[null,null,null,"1.3. Personal no docente"]
[]
[null,null,null,"Reglas generales para determinar la cantidad",null,null,null,null,null,null,null,"<Dejar la celda en blanco si no hay un requisito mínimo>",null,null,null,"<Dejar la celda en blanco si no hay un requisito máximo>"]
[]
[null,null,"Personal de limpieza",null,"Trabajan en",1,"escuela(s),",1,"limpiador(es) por cada ",150,"alumnos, ","con un mín. de ",2,{"$f":"IF(F50>1, \"per \"&F50&\" schools and a max of\", \"per school and a max of\")","v":"per school and a max of"},null,null,10,{"$f":"IF(F50>1, \"per \"&F50&\" schools\", \"per school\")","v":"per school"}]
[null,null,"Enfermeras escolares",null,"Trabajan en",1,"escuela(s),",1,"enfermera(s) por cada ",150,"alumnos, ","con un mín. de ",2,{"$f":"IF(F51>1, \"per \"&F51&\" schools and a max of\", \"per school and a max of\")","v":"per school and a max of"},null,null,10,{"$f":"IF(F51>1, \"per \"&F51&\" schools\", \"per school\")","v":"per school"}]
[null,null,"Técnicos",null,"Trabajan en",1,"escuela(s),",1,"técnico(s) por cada ",150,"alumnos, ","con un mín. de ",2,{"$f":"IF(F52>1, \"per \"&F52&\" schools and a max of\", \"per school and a max of\")","v":"per school and a max of"},null,null,10,"per school"]
[null,null,"Asesores",null,"Trabajan en",2,"escuela(s),",1,"asesor(es) por cada",250,"alumnos, ","con un mín. de ",null,{"$f":"IF(F53>1, \"per \"&F53&\" schools and a max of\", \"per school and a max of\")","v":"per 2 schools and a max of"},null,null,null,"per 2 schools"]
[null,null,"Psicólogos",null,"Trabajan en",2,"escuela(s),",1,"psicólogo(s) por cada",250,"alumnos, ","con un mín. de ",null,{"$f":"IF(F54>1, \"per \"&F54&\" schools and a max of\", \"per school and a max of\")","v":"per 2 schools and a max of"},null,null,null,"per 2 schools"]
[null,null,"Trabajadores sociales",null,"Trabajan en",5,"escuela(s),",1,"trabajador(es) social(es) por cada",250,"alumnos, ","con un mín. de ",null,"per 5 schools and a max of",null,null,null,"per 5 schools"]
[null,null,"Movilizador social",null,"Trabajan en",5,"escuela(s),",1,"movilizador(es) social(es) por cada",500,"alumnos, ","con un mín. de ",null,"per 5 schools and a max of",null,null,null,"per 5 schools"]
[]
[null,null,null,"Cantidad de alumnos en una escuela",null,null,null,null,{"$f":"N_student_per_school","v":200},"<La configuración predeterminada es la cantidad promedio de alumnos en una escuela.>"]
[]
[null,null,null,null,"Necesarios por escuela",null,"Disponibles actualmente por escuela",null,null,"Nuevo personal que debe contratarse por escuela"]
[null,null,"Personal de limpieza",null,{"$f":"IF(ISERROR(IF(AND(Q50 <>\"\", I$58*F50/J50*H50>Q50), Q50, IF(AND(M50 <>\"\", I$58*F50/J50*H50 <M50), M50, ROUNDUP(I$58*F50/J50*H50,0)))/F50) = TRUE, \"\", IF(AND(Q50 <>\"\", I$58*F50/J50*H50>Q50), Q50, IF(AND(M50 <>\"\", I$58*F50/J50*H50 <M50), M50, ROUNDUP(I$58*F50/J50*H50,0)))/F50)","v":2},null,{"$f":"IF(ISERROR(N_cleaner_current/N_school) = TRUE, \"\", N_cleaner_current/N_school)","v":2},null,null,{"$f":"IF(ISERROR(IF(E61-G61 >0, E61-G61, \"The number of staff is sufficient\")) = TRUE, \"\", IF(E61-G61 >0, E61-G61, \"The number of staff is sufficient\"))","v":"The number of staff is sufficient"},null,"La cantidad de personal es suficiente"]
[null,null,"Enfermeras escolares",null,{"$f":"IF(ISERROR(IF(AND(Q51 <>\"\", I$58*F51/J51*H51>Q51), Q51, IF(AND(M51 <>\"\", I$58*F51/J51*H51 <M51), M51, ROUNDUP(I$58*F51/J51*H51,0)))/F51) = TRUE, \"\", IF(AND(Q51 <>\"\", I$58*F51/J51*H51>Q51), Q51, IF(AND(M51 <>\"\", I$58*F51/J51*H51 <M51), M51, ROUNDUP(I$58*F51/J51*H51,0)))/F51)","v":2},null,{"$f":"IF(ISERROR(N_nurse_current/N_school) = TRUE, \"\", N_nurse_current/N_school)","v":2},null,null,{"$f":"IF(ISERROR(IF(E62-G62 >0, E62-G62, \"The number of staff is sufficient\")) = TRUE, \"\", IF(E62-G62 >0, E62-G62, \"The number of staff is sufficient\"))","v":"The number of staff is sufficient"}]
[null,null,"Técnicos",null,2,null,{"$f":"IF(ISERROR(N_technician_current / N_school) = TRUE, \"\", N_technician_current / N_school)","v":2},null,null,"The number of staff is sufficient"]
[null,null,"Asesores",null,1,null,{"$f":"IF(ISERROR(N_counselor_current/N_school) = TRUE, \"\", N_counselor_current/N_school)","v":1.6},null,null,"The number of staff is sufficient"]
[null,null,"Psicólogos",null,1,null,{"$f":"IF(ISERROR(N_psychologist_current/N_school) = TRUE, \"\", N_psychologist_current/N_school)","v":1.6},null,null,"The number of staff is sufficient"]
[null,null,"Trabajadores sociales",null,0.8,null,{"$f":"IF(ISERROR(N_social_worker_current/N_school), \"\", N_social_worker_current/N_school)","v":1.6},null,null,"The number of staff is sufficient"]
[null,null,"Movilizador social",null,0.4,null,{"$f":"IF(ISERROR(N_social_worker_current/N_school) = TRUE, \"\", N_social_worker_current/N_school)","v":1.6},null,null,"The number of staff is sufficient"]
[]
[]
[null,null,"Calculadora 2. Cómo calcular la cantidad de desinfectante necesario"]
[]
[null,null,null,"2.1. Para una escuela típica"]
[null,null,null,"Factor 1: Áreas que deben ser desinfectadas mediante pulverizador",null,null,null,null,{"$f":"IF(ISERROR(I79*N_room_per_school) = TRUE, \"\", I79*N_room_per_school)","v":450},"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,null,null,"Ancho del piso en un salón de clases típico",null,null,null,null,3,"metro(s)"]
[null,null,null,"Superficie del piso en un salón de clases típico",null,null,null,null,{"$f":"I76*I77","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*I78","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(('Basic information about schools'!G53/'Basic information about schools'!G52*(1+1/'Basic information about schools'!G96+1/'Basic information about schools'!G97))) = TRUE, \"\", ('Basic information about schools'!G53/'Basic information about schools'!G52*(1+1/'Basic information about schools'!G96+1/'Basic information about schools'!G97)))","v":15},"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,0.05,"litro(s) por metro cuadrado",null,"<Ver etiqueta del producto>"]
[]
[null,null,null,"Factor 3: Proporción de la dilución",null,null,null,null,0.05,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,1,"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,1,"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(I73*I84*I86*I89) = TRUE, \"\", I73*I84*I86*I89)","v":1.125},"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(I73*I84*I86*I90/5) = TRUE, \"\", I73*I84*I86*I90/5)","v":0.22500000000000001},"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(I93-I94) = TRUE, \"\", I93-I94)","v":0.9},"litro(s)"]
[]
[]
[null,null,null,"2.2. Para un autobús escolar"]
[null,null,null,"Factor 1: Áreas que deben ser desinfectadas mediante pulverizador",null,null,null,null,{"$f":"I103","v":60.996000000000002},"metro(s) cuadrado(s)"]
[null,null,null,null,"Largo del autobús",null,null,null,8,"metros",null,"<Minibús escolar: 6,1-7,6 metros; \nautobús escolar mediano: 7,6-10,7 metros; \nautobús escolar grande: más de 10,7 metros>"]
[null,null,null,null,"Ancho del autobús",null,null,null,2.5499999999999998,"metros"]
[null,null,null,null,"Altura del autobús",null,null,null,2.99,"metros"]
[null,null,null,null,"Superficie del autobús (incluidas paredes, piso, techo y asientos)",null,null,null,{"$f":"I100*I101*I102","v":60.996000000000002},"metro(s) cuadrado(s)",null,"<Largo x ancho x altura>"]
[]
[null,null,null,"Factor 2: Cantidad de solución mixta necesaria",null,null,null,null,0.05,"litro(s) por metro cuadrado",null,"<Ver etiqueta del producto>"]
[]
[null,null,null,"Factor 3: Proporción de la dilución",null,null,null,null,0.05,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,{"$f":"1","v":1},"veces por viaje"]
[null,null,null,"En la etapa pre COVID-19",null,null,null,null,1,"veces por semana (p. ej., dos veces al día, cinco veces por semana)"]
[]
[null,null,null,"La cantidad de desinfectante necesaria para atomizar un autobús por día"]
[null,null,null,"En la etapa con COVID-19",null,null,null,null,{"$f":"I99*I105*I107*I110","v":0.15249000000000001},"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":"I99*I105*I107*I111/10","v":1.5249000000000002E-2},"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":"Disinfectant_bus_per_trip-I115","v":0.137241},"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,null,"¿Cuál es el tamaño promedio de un autobús escolar?",null,null,null,null,null,null,null,"https://www.trackschoolbus.com/blog/what-is-the-average-size-of-a-school-bus/#:~:text=The%20length%20of%20a%20normal,a%20width%20of%206%20feet."]
[]
[]
[null,null,"Calculadora 3. Cómo calcular la cantidad de antiséptico y jabón líquido para el lavado de manos"]
[]
[null,null,null,"3.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","<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,5,"veces por día por persona"]
[null,null,null,null,"En la etapa pre COVID-19",null,null,null,2,"veces por día por persona"]
[]
[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":"I130*I132","v":15},"mL"]
[null,null,null,null,"En la etapa pre COVID-19",null,null,null,{"$f":"I130*I133","v":6},"mL"]
[null,null,null,null,"Brecha",null,null,null,{"$f":"Antiseptic_per_person_per_day-I137","v":9},"mL"]
[]
[null,null,null,"3.2. Antiséptico para el lavado de manos antes de abordar el autobús escolar"]
[null,null,null,null,"Factor 1: Cantidad de antiséptico por lavado de manos",null,null,null,3,"mL","<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,2,"veces por día por persona"]
[null,null,null,null,"En la etapa pre COVID-19",null,null,null,0,"veces por día por persona"]
[]
[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":"I141*I143","v":6},"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":"I141*I144","v":0},"mL","<Factor 1 x Factor 2 para la etapa pre COVID-19>"]
[null,null,null,null,"Brecha",null,null,null,{"$f":"Antiseptic_per_person_per_day_bus-I148","v":6},"mL"]
[]
[null,null,null,"3.3. 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","<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,5,"veces por día por persona"]
[null,null,null,null,"En la etapa pre COVID-19",null,null,null,2,"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":"I152*I154","v":10},"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":"I152*I155","v":4},"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-I159","v":6},"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 4. 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,"4.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",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.65},null,null,null,{"$f":"IF(ISERROR(H174*J174*L174) = TRUE, \"\", H174*J174*L174)","v":0},null,null,null,{"$f":"IF(ISERROR(N174*P174) = TRUE, \"\", N174*P174)","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.65},null,null,null,{"$f":"IF(ISERROR(H175*J175*L175) = TRUE, \"\", H175*J175*L175)","v":0},null,null,null,{"$f":"IF(ISERROR(N175*P175) = TRUE, \"\", N175*P175)","v":0}]
[null,null,null,"Mascarillas grandes","Alumnos mayores de 12 años",null,null,null,null,{"$f":"pct_student_in_school","v":0.65},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":2240},null,{"$f":"pct_teacher_staff_in_school","v":0.5},null,1,null,1120,null,0.5,null,560]
[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,null,null,{"$f":"pct_teacher_staff_in_school","v":0.5},null,null,null,0,null,null,null,0]
[]
[null,null,null,"Total",null,null,null,null,null,null,null,null,null,{"$f":"SUM(N174:N177)","v":1120},null,{"$f":"IF(ISERROR((N174*P174+N175*P175+N176*P176+N177*P177+N178*P178)/SUM(N174:N178)) = TRUE, \"\", (N174*P174+N175*P175+N176*P176+N177*P177+N178*P178)/SUM(N174:N178))","v":0.5},null,{"$f":"SUM(R174:R177)","v":560}]
[]
[]
[null,null,null,"4.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.65},null,null,null,{"$f":"IF(ISERROR(H186*J186*L186* N_school_days) = TRUE, \"\", H186*J186*L186* N_school_days)","v":0},null,null,null,{"$f":"IF(ISERROR(N186*P186) = TRUE, \"\", N186*P186)","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.65},null,null,null,{"$f":"IF(ISERROR(H187*J187*L187* N_school_days) = TRUE, \"\", H187*J187*L187* N_school_days)","v":0},null,null,null,{"$f":"IF(ISERROR(N187*P187) = TRUE, \"\", N187*P187)","v":0}]
[null,null,null,"Mascarillas grandes","Alumnos mayores de 12 años",null,null,null,null,{"$f":"pct_student_in_school","v":0.65},null,null,null,{"$f":"IF(ISERROR(H188*J188*L188* N_school_days) = TRUE, \"\", H188*J188*L188* 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":1120},null,{"$f":"pct_teacher_staff_in_school","v":0.5},null,1,null,{"$f":"IF(ISERROR(H189*J189*L189* N_school_days) = TRUE, \"\", H189*J189*L189* N_school_days)","v":50400},null,null,null,0]
[]
[null,null,null,"Total",null,null,null,null,null,null,null,null,null,{"$f":"SUM(N186:N189)","v":50400},null,{"$f":"IF(ISERROR((N186*P186+N187*P187+N188*P188+N189*P189)/SUM(N186:N189)) = TRUE, \"\", (N186*P186+N187*P187+N188*P188+N189*P189)/SUM(N186:N189))","v":0},null,{"$f":"SUM(R186:R189)","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"]
[]
[]
[null,null,"Calculadora 5. Cómo calcular la cantidad de sensores de temperatura automáticos, oxímetros y personal encargado de los controles médicos"]
[]
[null,null,null,"Reglas generales para determinar la cantidad",null,null,null,null,null,null,null,"<Dejar la celda en blanco si no hay un requisito mínimo>",null,null,null,"<Dejar la celda en blanco si no hay un requisito máximo>"]
[null,null,null,"Sensores de temperatura automáticos",null,null,1,"pieza(s) por cada ",150,"alumnos, ","con un mín. de ",2,"por escuela y un máx. de",null,null,10,"por escuela"]
[null,null,null,"Oxímetros",null,null,1,"pieza(s) por cada ",150,"alumnos, ","con un mín. de ",2,"por escuela y un máx. de ",null,null,10,"por escuela"]
[null,null,null,"Personal encargado de los controles médicos",null,null,1,"controlador(es) por cada",150,"alumnos, ","con un mín. de",null,"por escuela y un máx. de",null,null,null,"por escuela"]
[]
[null,null,null,"Cantidad de alumnos en una escuela",null,null,null,null,{"$f":"'Basic information about schools'!G55","v":200},"<La configuración predeterminada es la cantidad promedio de alumnos en una escuela.>"]
[null,null,null,"Cantidad de sensores de temperatura automáticos necesarios en una escuela",null,null,null,null,{"$f":"IF(ISERROR(IF(AND(P199 <>\"\", I$203/I199*G199>P199), P199, IF(AND(L199 <>\"\", I$203/I199*G199 <L199), L199, ROUNDUP(I$203/I199*G199,0)))) = TRUE, \"\", IF(AND(P199 <>\"\", I$203/I199*G199>P199), P199, IF(AND(L199 <>\"\", I$203/I199*G199 <L199), L199, ROUNDUP(I$203/I199*G199,0))))","v":2}]
[null,null,null,"Cantidad de oxímetros necesarios en una escuela",null,null,null,null,{"$f":"IF(ISERROR(IF(AND(P200 <>\"\", I$203/I200*G200>P200), P200, IF(AND(L200 <>\"\", I$203/I200*G200 <L200), L200, ROUNDUP(I$203/I200*G200,0)))) = TRUE, \"\", IF(AND(P200 <>\"\", I$203/I200*G200>P200), P200, IF(AND(L200 <>\"\", I$203/I200*G200 <L200), L200, ROUNDUP(I$203/I200*G200,0))))","v":2}]
[null,null,null,"Cantidad de personal encargado de los controles médicos necesario en una escuela",null,null,null,null,2]
[]
[null,null,"Notas. La configuración predeterminada de las reglas generales para determinar la cantidad de sensores de temperatura automáticos y oxímetros se basa en la estrategia de reapertura de escuelas publicada por el Ministerio de Educación de Chile (https://sigamosaprendiendo.mineduc.cl/documentos/). "]
[]
[]
[null,null,"Calculadora 6: Cómo estimar el costo de desarrollar una plataforma de aprendizaje remoto"]
[]
[null,null,null,null,"¿Quiénes participan en esta etapa? ",null,null,"Funciones y responsabilidades",null,"Cantidad de personas en la categoría",null,"Porcentaje de tiempo dedicado a la tarea",null,"Nivel salarial promedio",null,"Costo total"]
[null,null,"Desarrollo de contenido",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J214*L214*N214","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J215*L215*N215","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Desarrollo de la plataforma",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Mantenimiento de la plataforma",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,"Total",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P214:P222)","v":0}]

{"sheet":"Prices of additional resources","index":6,"n_rows":101,"n_cols":14,"rows_kept":101,"cut":false,"hidden":false,"merged":[[72,2,73,2],[8,2,18,2],[19,2,21,2],[22,2,28,2],[29,2,35,2],[39,2,42,2],[44,2,45,2],[46,2,51,2],[53,2,55,2],[57,2,59,2],[60,2,68,2],[69,2,71,2],[75,2,76,2],[78,2,83,2],[84,2,86,2],[88,2,89,2],[90,2,95,2]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"<Ingresar el precio de cada recurso>",null,null,"<Si le interesa conocer el costo económico, complete las columnas J y K>"]
[null,null,"Medidas verificadas","Recursos adicionales","Cantidad","Unidad",{"$f":"\"Price \"&IF('Basic information about schools'!G99=\"\",\"\",\"(in \"&'Basic information about schools'!G99&\")\"&\"\")","v":"Price (in Bea)"},{"$f":"\"Total additional cost\"","v":"Total additional cost"},null,{"$f":"\"Can this resource be used beyond \"&LOWER('Basic information about schools'!D43)&\"? (Yes/No)\"","v":"Can this resource be used beyond el primer semestre de 2021.? (Yes/No)"},"Si la respuesta es sí, ¿cuál es la vida útil prevista para este recurso? (en meses)","Costo económico"]
[null,null,"Eje 1: medidas relacionadas con la seguridad de las operaciones"]
[null,null,"Establecer medidas de limpieza y desinfección","Desinfectante",{"$f":"Disinfectant_per_school_per_day_gap * (N_school * pct_school_reopen) * N_school_days","v":2025},"litro(s)",1,{"$f":"E9*G9","v":2025},null,null,null,{"$f":"IF(J9 = \"Yes\", H9/K9 * (N_school_days/20), H9)","v":2025},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":35},"pieza(s)",100,{"$f":"E10*G10","v":3500},null,"Sí",24,3500]
[null,null,null,"pulverizadores con desinfectantes electrostáticos",{"$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":35},"pieza(s)",100,3500,null,"Sí",36,3500]
[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":187.5},"conjunto(s)",100,18750,null,"Sí",12,18750]
[null,null,null,"Barras de jabón",{"$f":"N_soap_bar_per_room * N_room_per_school * N_school * pct_school_reopen","v":375},"pieza(s)",100,37500,null,null,null,37500]
[null,null,null,"Agua",{"$f":"Water_multiplier * N_school * pct_school_reopen","v":100},"vez/veces x escuela(s)",1,100,null,null,null,100]
[null,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":70},"par(es)",100,7000,null,"Sí",12,7000]
[null,null,null,"Batas 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":4950},"conjunto(s)",100,495000,null,null,null,495000]
[null,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":70},"conjunto(s)",100,7000,null,"Sí",12,7000]
[null,null,null,"Personal de limpieza recién contratado ",{"$f":"N_newly_hired_cleaner * (N_school_days / N_school_days_per_academic_year)","v":5},"empleado(s) a tiempo completo",100,500,null,null,null,500]
[null,null,null,"Horas extra para el personal de limpieza",{"$f":"N_overtime_hour_per_cleaner_per_day * N_cleaner * pct_teacher_staff_in_school * N_school_days","v":0},"hora(s)",1,0,null,null,null,0]
[null,null,"Proporcionar equipos de protección personal ","Mascarillas reutilizables",{"$f":"N_reusable_mask","v":1120},"pieza(s)",1,1120,null,"Sí",12,1120,null,"P102"]
[null,null,null,"Mascarillas desechables",{"$f":"N_disposable_mask","v":50400},"pieza(s)",1,50400,null,null,null,50400]
[null,null,null,"Máscaras faciales",{"$f":"N_shield_per_teacher_staff * N_teacher_and_staff * pct_teacher_staff_in_school","v":1120},"pieza(s)",1,1120,null,"Sí",12,1120]
[null,null,"Proporcionar materiales para higienizar las manos","Antisépticos de base alcohólica (al menos 70 por ciento alcohol)",{"$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":6172.2},"litro(s)",1,6172.2,null,null,null,6172.2,null,"P103"]
[null,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":375},"pieza(s)",1,375,null,"No",null,375]
[null,null,null,"Jabón líquido",{"$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":4114.8},"litro(s)",1,4114.8,null,null,null,4114.8]
[null,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":34290},"rollo(s)",1,34290,null,null,null,34290]
[null,null,null,"Toallitas descartables registradas en la EPA",{"$f":"(N_package_wipes_per_person_per_month - N_package_wipes_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":34290},"paquete(s)",1,34290,null,null,null,34290]
[null,null,null,"Botes 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":375},"pieza(s)",1,375,null,"Sí",36,375]
[null,null,null,"Secador de manos ",{"$f":"(N_hand_dryer_per_restroom - N_hand_dryer_per_restroom_current) * ROUNDUP(N_class/N_school/Classroom_restroom_ratio,0) * N_school * pct_school_reopen","v":0},"pieza(s)",1,0,null,"Sí",60,0]
[null,null,"Realizar controles médicos in situ","Sensores de temperatura automáticos ",{"$f":"N_temp_sensor_per_school * N_school * pct_school_reopen","v":50},"pieza(s)",1,50,null,"Sí",36,50,null,"P104"]
[null,null,null,"Oxímetro ",{"$f":"N_oximeter_per_school * N_school * pct_school_reopen","v":50},"pieza(s)",1,50,null,"Sí",36,50]
[null,null,null,"Horas extra para el personal adecuadamente capacitado para realizar controles médicos",{"$f":"N_overtime_hour_per_screener_per_day * N_screening_staff_per_school * N_school * pct_school_reopen * N_school_days","v":4500},"hora(s)",1,4500,null,null,null,4500]
[null,null,null,"Máscaras protectoras y guantes desechables para el personal encargado de los controles médicos",{"$f":"N_PPE_per_screener_per_day * N_screening_staff_per_school * N_school * pct_school_reopen * N_school_days","v":4500},"conjunto(s)",1,4500,null,null,null,4500]
[null,null,null,"Enfermeras a tiempo completo recién contratadas",{"$f":"N_newly_hired_nurse* (N_school_days/N_school_days_per_academic_year)","v":5},"empleado(s) a tiempo completo",1,5,null,null,null,5]
[null,null,null,"Horas extra para enfermeras a tiempo completo",{"$f":"N_overtime_hour_per_nurse_per_day * N_nurse * pct_teacher_staff_in_school * N_school_days","v":4950},"hora(s)",1,4950,null,null,null,4950]
[null,null,null,"Sala de emergencia/consultorio médico/salas de aislamiento",{"$f":"N_isolation_room_per_school * N_school * pct_school_reopen","v":50},"habitaciones",1,50,null,null,null,50]
[null,null,"Monitorear síntomas a través de encuestas realizadas a los padres","Horas extra para los técnicos encargados de i) poner en marcha el monitoreo de salud en línea y la plataforma para presentar informes, y ii) preparar y difundir los informes diarios.",{"$f":"N_overtime_hour_per_technician_per_day_monitoring * N_technician * pct_teacher_staff_in_school * N_school_days","v":0},"hora(s)",1,0,null,null,null,0,null,"P105"]
[null,null,"Limitar el intercambio de objetos","Materiales de enseñanza o aprendizaje que deben adquirirse para minimizar el intercambio.",{"$f":"N_set_TLM","v":100},"conjunto(s)",1,100,null,"Sí",12,100,null,"P106"]
[null,null,"Asegurar los espacios, materiales y estrategias para mantener la distancia física y social","Costo de alquilar los espacios comunitarios sin utilizar.",{"$f":"N_space_per_school_per_day * N_school * pct_school_reopen * N_school_days","v":0},"metro(s) cuadrado(s) x día(s)",1,0,null,null,null,0,null,"P107"]
[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":4000},"pieza(s)",1,4000,null,"Sí",24,4000,null,"P108"]
[null,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":240},"pieza(s)",1,240,null,"Sí",24,240]
[null,null,null,"Cintas para crear señales en los pisos y aceras",{"$f":"N_tape_per_school * N_school * pct_school_reopen","v":250},"rollo(s)",1,250,null,"No",null,250]
[null,null,null,"Carteles o señales en las paredes",{"$f":"N_poster_per_school * N_school * pct_school_reopen","v":250},"cartel(es)",11,2750,null,"Sí",24,2750]
[null,null,"Instruir a alumnos, docentes, personal y padres respecto a la seguridad de las operaciones escolares","Horas extra para los docentes y el personal que participen en la capacitación relacionada con la seguridad de las operaciones.",{"$f":"N_overtime_hour_per_teacher_staff_safety_training * N_teacher_and_staff * pct_teacher_staff_in_school","v":1120},"hora(s)",1,1120,null,null,null,1120,null,"P109"]
[null,null,"Mantener un nivel de colaboración y coordinación apropiados con las autoridades de salud pública locales. ","Batas o ropa quirúrgica para las enfermeras escolares",{"$f":"N_gown_per_nurse * N_newly_hired_nurse + (N_gown_per_nurse - N_gown_per_nurse_current) * N_nurse_current * pct_teacher_staff_in_school","v":70},"pieza(s)",1,70,null,"Sí",24,70,null,"P110"]
[null,null,null,"EPP necesario para atender casos sospechosos",{"$f":"N_PPE_per_case * N_suspected_cases_per_school_per_day * N_school * pct_school_reopen * N_school_days","v":4500},"conjunto(s)",1,4500,null,null,null,4500]
[null,null,"Adaptar el transporte","Máquinas de humo para autobuses",{"$f":"N_fog_machine_per_bus * N_newly_hired_driver + (N_fog_machine_per_bus - N_fog_machine_per_bus_current) * N_driver_current * pct_teacher_staff_in_school","v":25},"pieza(s)",1,25,null,"Sí",36,25,null,"P111"]
[null,null,null,"Desinfectante para autobuses",{"$f":"Disinfectant_bus_per_trip_gap * (N_student * pct_student_in_school * pct_student_bus)/(N_student_full_capacity_school_bus * pct_bus_capacity) * 2 * N_school_days/1000","v":4.8171591000000005},"litro(s)",1,4.8171591000000005,null,null,null,4.8171591000000005]
[null,null,null,"Sensores de temperatura automáticos para controlar la temperatura de los alumnos antes de subir a bordo.",{"$f":"N_temperature_sensor_per_bus * N_driver * pct_teacher_staff_in_school","v":50},"pieza(s)",1,50,null,"Sí",36,50]
[null,null,null,"Antisépticos de base alcohólica (al menos 70 por ciento alcohol)",{"$f":"Antiseptic_per_person_per_day_bus_gap * (N_student * pct_student_in_school * pct_student_bus) * N_school_days/1000","v":1053},"litro(s)",1,1053,null,null,null,1053]
[null,null,null,"Dispensadores antisépticos",{"$f":"N_dispenser_per_bus * N_newly_hired_driver + (N_dispenser_per_bus - N_dispenser_per_bus_current) * N_driver_current * pct_teacher_staff_in_school","v":50},"pieza(s)",1,50,null,"No",null,50]
[null,null,null,"Combustible adicional ",{"$f":"N_school * pct_school_reopen * (pct_student_bus / pct_student_bus_pre_covid) * (1 / pct_bus_capacity - 1)","v":15},"vez/veces x escuela(s)",1,15,null,null,null,15]
[null,null,"Adaptar la ventilación","Actualizar sistemas de climatización",{"$f":"N_school * pct_school_reopen * pct_school_HVAC_updating","v":2.5},"escuela(s)",1,2.5,null,"Sí",36,2.5,null,"P112"]
[null,null,"Reorganizar el programa de almuerzo","Batas, delantales y gorros para el personal de cocina",{"$f":"N_gown_food_worker * N_newly_hired_food_staff + (N_gown_food_worker - N_gown_food_worker_current) * N_food_staff_current * pct_teacher_staff_in_school","v":0},"conjunto(s)",1,{"$f":"E54*G54","v":0},null,"Sí",24,0,null,"P113"]
[null,null,null,"Utensilios desechables",{"$f":"(N_disposable_utensil_per_student - N_disposable_utensil_per_student_current) * N_student * pct_student_in_school * pct_student_lunch * N_school_days","v":0},"conjunto(s)",1,0,null,null,null,0]
[null,null,null,"Platos desechables",{"$f":"(N_disposable_dish_per_student - N_disposable_dish_per_student_current) * N_student * pct_student_in_school * pct_student_lunch * N_school_days","v":0},"conjunto(s)",1,0,null,null,null,0]
[null,null,"Eje 2: medidas para sostener el aprendizaje"]
[null,null,"Posibilitar el desarrollo profesional de los docentes.","Horas extra para los docentes que participen en las sesiones de capacitación sobre pedagogía",{"$f":"IF(teacher_pd = \"Reopened schools\", N_PD_session_per_teacher * N_hour_per_training_session * pct_teacher_PD * pct_teacher_staff_in_school * N_teacher_and_staff, N_PD_session_per_teacher * N_hour_per_training_session * pct_teacher_PD * N_teacher_and_staff)","v":4480},"hora(s)",100,448000,null,null,null,{"$f":"IF(J58 = \"Yes\", H58/K58 * (N_school_days/20), H58)","v":448000},null,"P201"]
[null,null,null,"Compensación para los capacitadores externos que proporcionen sesiones de capacitación",{"$f":"N_external_trainer * N_session_per_trainer * N_hour_per_PD_session","v":1000},"hora(s)",100,100000,null,"Sí",12,100000]
[null,null,null,"Materiales de capacitación",{"$f":"IF(teacher_pd = \"Reopened schools\", N_PD_materials_per_teacher * N_teacher * pct_teacher_PD * pct_teacher_staff_in_school, N_PD_materials_per_teacher * N_teacher * pct_teacher_PD)","v":1050},"conjunto(s)",100,105000,null,"Sí",12,105000]
[null,null,"Mantener los enfoques flexibles o parciales de aprendizaje remoto","Plataformas de aprendizaje remotas",1,"conjunto",1,1,null,"Sí",12,1,null,"P202"]
[null,null,null,"Compensación para acceder a Internet",{"$f":"(pct_teacher_internet * N_teacher + pct_student_internet * N_student) * ROUNDUP((N_school_days/20), 0)","v":27100},"persona(s) x meses",null,0,null,null,null,0]
[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":27100},"persona(s) x meses",null,0,null,null,null,0]
[null,null,null,"Computadoras de escritorio",{"$f":"N_desktop","v":100},"pieza(s)",800,80000,null,"Sí",36,80000]
[null,null,null,"Computadoras portátiles",{"$f":"N_laptop","v":200},"pieza(s)",1000,200000,null,"Sí",36,200000]
[null,null,null,"Tabletas",{"$f":"N_tablet","v":200},"pieza(s)",1000,200000,null,"Sí",36,200000]
[null,null,null,"Teléfonos",{"$f":"N_phone","v":200},"pieza(s)",1000,200000,null,"Sí",36,200000]
[null,null,null,"Técnicos recién contratados",{"$f":"N_newly_hired_technician * (N_school_days/N_school_days_per_academic_year)","v":5},"empleado(s) a tiempo completo",1,5,null,null,null,5]
[null,null,null,"Horas extra para técnicos u otro personal que proporcione asistencia técnica",{"$f":"N_overtime_hour_per_technician_per_day_tech_support * N_technician * N_school_days","v":9900},"hora(s)",1,9900,null,null,null,9900]
[null,null,"Realizar evaluaciones de diagnóstico","Importe de la licencia para las evaluaciones",{"$f":"N_license_assessment","v":1},"licencia(s)",1,1,null,"Sí",12,1,null,"P203"]
[null,null,null,"Impresión de las evaluaciones (si se entregan en papel)",{"$f":"IF(diagnosis_assessment = \"Reopened schools\", N_page_assessment * N_student * pct_student_in_school * pct_student_test, N_page_assessment * N_student * pct_student_test)","v":19000},"página(s)",1,19000,null,null,null,19000]
[null,null,null,"Compensación para especialistas en evaluación externos para elaborar las evaluaciones y proporcionar capacitación",{"$f":"N_assessment_specialist * N_hour_per_assessment_specialist","v":100},"hora(s)",null,0,null,"Sí",12,0]
[null,null,"Aumentar la intensidad y la diferenciación (aprendizaje personalizado)","Importe de la licencia para los programas de recuperación y aceleración",{"$f":"N_license_personalized_learning_program","v":1},"licencia(s)",1,1,null,"Sí",12,1,null,"P204"]
[null,null,null,"Pago para los auxiliares pedagógicos que proporcionan aprendizaje personalizado en forma de clases de refuerzo",{"$f":"N_hour_teaching_aid","v":1333.3333333333333},"hora(s)",1,{"$f":"E74*G74","v":1333.3333333333333},null,null,null,1333.3333333333333]
[null,null,"Extender los horarios","Horas extra para los docentes para proporcionar instrucciones",{"$f":"IF(extend_schedules = \"Reopened schools\", N_hour_per_extended_day * N_extended_day * N_teacher * pct_teacher_staff_in_school, N_hour_per_extended_day * N_extended_day * N_teacher )","v":252000},"hora(s)",1,252000,null,null,null,252000,null,"P205"]
[null,null,"Contratar nuevos docentes, reorganizar los turnos de trabajo o extender el horario de trabajo de los docentes","Docentes recién contratados para asegurar grupos más pequeños y sustituir a colegas enfermos",{"$f":"N_newly_hired_teacher * (N_school_days / N_school_days_per_academic_year)","v":25},"empleado(s) a tiempo completo",1,25,null,null,null,25,null,"P206"]
[null,null,null,"Horas extra para que los docentes actuales sustituyan a sus colegas enfermos",{"$f":"N_hour_substitute * pct_hour_substitute_by_current_teacher","v":800},"hora(s)",10,8000,null,null,null,8000]
[null,null,"Eje 3: medidas para apoyar el bienestar y la recuperación emocional",null,null,null,null,0]
[null,null,"Proporcionar apoyo y asesoramiento psicosocial exclusivo.","Asesores recién contratados",{"$f":"N_newly_hired_counselor * (N_school_days / N_school_days_per_academic_year)","v":10},"empleado(s) a tiempo completo",1,10,null,null,null,{"$f":"IF(J79 = \"Yes\", H79/K79 * (N_school_days/20), H79)","v":10},null,"P301"]
[null,null,null,"Horas extra para asesores",{"$f":"IF(counselling = \"Reopened schools\", N_overtime_hour_per_counselor_per_day * N_counselor * pct_teacher_staff_in_school * N_school_days, N_overtime_hour_per_counselor_per_day * N_counselor * N_school_days)","v":0},"hora(s)",20,0,null,null,null,0]
[null,null,null,"Trabajadores sociales recién contratados",{"$f":"N_newly_hired_social_worker * (N_school_days / N_school_days_per_academic_year)","v":10},"empleado(s) a tiempo completo",1,10,null,null,null,10]
[null,null,null,"Horas extra para trabajadores sociales",{"$f":"IF(counselling = \"Reopened schools\", N_overtime_hour_per_social_worker_per_day * N_social_worker * pct_teacher_staff_in_school * N_school_days, N_overtime_hour_per_social_worker_per_day * N_social_worker * N_school_days)","v":0},"hora(s)",20,0,null,null,null,0]
[null,null,null,"Psicólogos recién contratados",{"$f":"N_newly_hired_psychologist * (N_school_days / N_school_days_per_academic_year)","v":10},"empleado(s) a tiempo completo",1,10,null,null,null,10]
[null,null,null,"Horas extra para psicólogos",{"$f":"IF(counselling = \"Reopened schools\", N_overtime_hour_per_psychologist_per_day * N_psychologist * pct_teacher_staff_in_school * N_school_days, N_overtime_hour_per_psychologist_per_day * N_psychologist * N_school_days)","v":0},"hora(s)",20,0,null,null,null,0]
[null,null,"Adoptar programas de aprendizaje social y emocional (ASE)","Horas extra para los docentes que participen en las sesiones de capacitación ASE ",{"$f":"IF(SEL_programs = \"Reopened schools\", N_SEL_training_per_teacher * N_hour_SEL_training_per_session * N_teacher * pct_teacher_staff_in_school * pct_teacher_SEL_training, N_SEL_training_per_teacher * N_hour_SEL_training_per_session * N_teacher * pct_teacher_SEL_training)","v":210},"hora(s)",20,4200,null,null,null,4200,null,"P302"]
[null,null,null,"Horas extra para los docentes que promueven el ASE",{"$f":"IF(SEL_programs = \"Reopened schools\", N_overtime_hour_per_teacher_per_day_SEL * N_teacher * pct_teacher_staff_in_school * pct_teacher_overtime_SEL * N_school_days, N_overtime_hour_per_teacher_per_day_SEL * N_teacher * pct_teacher_overtime_SEL * N_school_days)","v":18900},"hora(s)",20,378000,null,null,null,378000]
[null,null,null,"Importe de la licencia para los programas ASE adoptados",{"$f":"N_license_SEL","v":4},"licencia(s)",1,4,null,"Sí",12,4]
[null,null,"Eje 4: medidas para llegar a los más marginados"]
[null,null,"Proporcionar apoyo adecuado para las necesidades de recuperación, especialmente entre alumnos desfavorecidos y vulnerables.","Equipo de protección especial o adaptado",{"$f":"N_adapted_PPE_per_school * N_school * pct_school_reopen","v":250},"conjunto(s)",1,250,null,"No",null,{"$f":"IF(J89 = \"Yes\", H89/K89 * (N_school_days/20), H89)","v":250},null,"P401"]
[null,null,null,"<Especifique los recursos adicionales en base al apoyo proporcionado>",null,null,null,0,null,null,null,0]
[null,null,"Llevar a cabo campañas de rematriculación y apoyo envolvente para evitar la deserción.","Tiempo que le lleva al personal diseñar e implementar las campañas de matriculación",{"$f":"IF(reenrollment_campaign = \"Reopened schools\", N_hour_per_mobilizer * N_mobilizer * pct_teacher_staff_in_school, N_hour_per_mobilizer * N_mobilizer)","v":800},"hora(s)",10,{"$f":"E91*G91","v":8000},null,"Sí",12,8000,null,"P402"]
[null,null,null,"Gastos de transporte para las campañas",{"$f":"N_enrollment_campaign_trips","v":120},"viaje(s)",1,120,null,null,null,120]
[null,null,null,"Programas de alimentación",{"$f":"N_feeding_program_beneficiery","v":2000},"beneficiario(s)",100,200000,null,null,null,200000]
[null,null,null,"Provisión de uniformes escolares",{"$f":"N_school_uniforms","v":2000},"cantidad de uniformes",100,200000,null,"Sí",12,200000]
[null,null,null,"Eliminación o exención de la matrícula escolar",{"$f":"N_school_fee_waiver","v":2000},"exenciones de la matrícula escolar",100,200000,null,null,null,200000]
[null,null,null,"<Especifique los recursos adicionales en base al apoyo proporcionado>",null,null,null,0,null,null,null,0]
[null,null,"Monitorear y planificar el ausentismo","Horas extra para que el personal monitoree y planifique el ausentismo",{"$f":"N_staff_member_absenteeism_monitoring * N_overtime_hour_per_person_per_day_monitor_absenteeism * N_school * pct_school_reopen","v":50},"hora(s)",1,50,null,null,null,50,null,"P403"]
[null,null,null,null,null,null,1]
[]
[null,null,"Conteo de palabras"]
[null,null,{"$f":"SUM(IF(LEN(TRIM(B1:D98))=0,0,LEN(TRIM(B1:D98))-LEN(SUBSTITUTE(B1:D98,\" \",\"\"))+1)) + SUM(IF(LEN(TRIM(F1:F98))=0,0,LEN(TRIM(F1:F98))-LEN(SUBSTITUTE(F1:F98,\" \",\"\"))+1)) + SUM(IF(LEN(TRIM(J1:K98))=0,0,LEN(TRIM(J1:K98))-LEN(SUBSTITUTE(J1:K98,\" \",\"\"))+1))","v":1050}]

{"sheet":"Funding","index":7,"n_rows":19,"n_cols":6,"rows_kept":19,"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",10000,1,{"$f":"D8*E8","v":10000}]
[null,null,"Ahorro del anterior cierre escolar",10000,1,10000]
[null,null,"Financiamiento externo",101000,1,101000]
[null,null,"Paquete de ayuda para la COVID-19",800000,1,800000]
[null,null,"Donaciones",10000,1,10000]
[null,null,null,null,null,0]
[null,null,null,null,null,{"$f":"D14*E14","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":"Report","index":8,"n_rows":57,"n_cols":12,"rows_kept":57,"cut":false,"hidden":false,"merged":[[8,8,8,18],[22,8,22,18],[54,2,54,18],[39,4,49,6],[56,2,56,18],[31,5,32,6],[31,4,32,4],[34,5,35,6],[34,4,35,4]]}
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"\"How much does it cost to reopen schools safely\"&IF('Basic information about schools'!F9 <>\"\", \" in \"&'Basic information about schools'!F9&\"\", \"\")&\"?\"","v":"How much does it cost to reopen schools safely in Storyland?"}]
[]
[null,null,null,null,"Contexto",null,null,null,{"$f":"\"Costo, financiamiento y brecha financiera de reabrir las escuelas de forma segura durante el segundo semestre de \"&LOWER('Basic information about schools'!D43)&\"\"","v":"Costo, financiamiento y brecha financiera de reabrir las escuelas de forma segura durante el segundo semestre de el primer semestre de 2021."}]
[null,null,null,null,{"$f":"CHOOSE(Output!C3, Output!C4, Output!C5, Output!C6, Output!C7, Output!C8)","v":"Región Neverland"},null,null,null,null,null,null,{"$f":"\"(Expressed in \"&'Basic information about schools'!G99&\" in \"&'Basic information about schools'!G101&\" values)\"","v":"(Expressed in Bea in 2021 values)"}]
[]
[]
[null,null,null,null,"Niveles educativos"]
[null,null,null,{"$f":"_xlfn.ANCHORARRAY(Output!O3)","v":"Educación preescolar (Edad 3-5)"},{"$f":"_xlfn.ANCHORARRAY(Output!O3)","v":"Educación preescolar (Edad 3-5)"}]
[null,null,null,"Educación primaria (Jardín a 3.º)","Educación primaria (Jardín a 3.º)"]
[]
[]
[]
[]
[]
[null,null,null,null,"Período de tiempo"]
[null,null,null,null,{"$f":"'Basic information about schools'!D43","v":"El primer semestre de 2021."}]
[null,null,null,null,{"$f":"\"(\"&N_school_days&\" días de escuela totales)\"","v":"(90 días de escuela totales)"},null,null,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,null,null,null,null,null,null,null,{"$f":"\"(Expressed in \"&'Basic information about schools'!G99&\" in \"&'Basic information about schools'!G101&\" values)\"","v":"(Expressed in Bea in 2021 values)"}]
[]
[null,null,null,null,"Población objetivo"]
[null,null,null,null,{"$f":"N_school","v":50},"escuelas"]
[null,null,null,null,{"$f":"N_student","v":10000},"alumnos"]
[]
[]
[null,null,null,null,"Estado de la reapertura de escuelas"]
[null,null,null,null,{"$f":"\"\"&ROUND(pct_school_reopen, 2) *100&\"%\"","v":"50%"},"de todas las escuelas imparten clases presenciales"]
[]
[]
[null,null,null,null,{"$f":"\"\"&ROUND(pct_student_in_school, 2) *100&\"%\"","v":"65%"},"por ciento de los alumnos asiste a clases presenciales"]
[]
[null,null,null,null,null,null,null,null,{"$f":"\"El costo económico de los recursos adicionales necesarios para reabrir las escuelas de forma segura por eje\"","v":"El costo económico de los recursos adicionales necesarios para reabrir las escuelas de forma segura por eje"}]
[null,null," ",null,null,null,null,null,null,null,null,{"$f":"\"(Expressed in \"&'Basic information about schools'!G99&\" in \"&'Basic information about schools'!G101&\" values)\"","v":"(Expressed in Bea in 2021 values)"}]
[null,null,null,null,"Notas"]
[null,null,null,null,"1) La base de referencia es el presupuesto para la misma población de alumnos en la etapa pre COVID-19. \n2) El costo financiero abarca los recursos que ya están pagos. El costo económico toma en cuenta el hecho de que algunos recursos pueden ser utilizados posteriormente al período de interés. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"1. Explicación más detallada del costo financiero y el costo económico\nAlgunos recursos se adquieren durante el período de tiempo de interés, pero puede ser usados después del mismo, como las computadoras portátiles. El costo financiero sería el costo total de las computadoras portátiles adquiridas sin amortización alguna. Si la vida útil prevista de estas computadoras portátiles es de tres años, el costo económico de estas para el período de un año es de aproximadamente un tercio del costo financiero. Para calcular el costo económico, complete las columnas J y K en la pestaña “Precios de los recursos adicionales”."]
[]
[null,null,"2. ¿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 T52. \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":"Items to purchase","index":9,"n_rows":47,"n_cols":7,"rows_kept":47,"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",{"$f":"Disinfectant_per_school_per_day * (N_school * pct_school_reopen) * N_school_days","v":2531.25},"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":35},"pieza(s)"]
[null,null,"pulverizadores con desinfectantes electrostáticos",{"$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":35},"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":187.5},"conjunto(s)"]
[null,null,"Barras de jabón",{"$f":"N_soap_bar_per_room * N_room_per_school * N_school * pct_school_reopen","v":375},"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":70},"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":4950},"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":70},"conjunto(s)"]
[null,null,"Mascarillas reutilizables",{"$f":"N_reusable_mask","v":1120},"pieza(s)",null,"P102"]
[null,null,"Mascarillas desechables",{"$f":"N_disposable_mask","v":50400},"pieza(s)"]
[null,null,"Máscaras faciales",{"$f":"N_shield_per_teacher_staff * N_teacher_and_staff * pct_teacher_staff_in_school","v":1120},"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":10287},"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":375},"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":6858},"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":34290},"rollo(s)"]
[null,null,"Toallitas descartables registradas en la EPA",{"$f":"(N_package_wipes_per_person_per_month - N_package_wipes_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":34290},"paquete(s)"]
[null,null,"Botes 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":375},"pieza(s)"]
[null,null,"Secador de manos ",{"$f":"(N_hand_dryer_per_restroom - N_hand_dryer_per_restroom_current)*ROUNDUP(N_class/N_school/Classroom_restroom_ratio,0)*N_school * pct_school_reopen","v":0},"pieza(s)"]
[null,null,"Sensores de temperatura automáticos ",{"$f":"N_temp_sensor_per_school * N_school * pct_school_reopen","v":50},"pieza(s)",null,"P104"]
[null,null,"Oxímetro ",{"$f":"N_oximeter_per_school * N_school * pct_school_reopen","v":50},"pieza(s)"]
[null,null,"Máscaras protectoras y guantes desechables para el personal encargado de los controles médicos",{"$f":"N_PPE_per_screener_per_day * N_screening_staff_per_school * N_school * pct_school_reopen * N_school_days","v":4500},"conjunto(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":4000},"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":240},"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":250},"rollo(s)"]
[null,null,"Carteles o señales en las paredes",{"$f":"N_poster_per_school * N_school * pct_school_reopen","v":250},"cartel(es)"]
[null,null,"Batas o ropa quirúrgica para las enfermeras escolares",{"$f":"N_gown_per_nurse * N_newly_hired_nurse + (N_gown_per_nurse - N_gown_per_nurse_current) * N_nurse * pct_teacher_staff_in_school","v":75},"pieza(s)",null,"P110"]
[null,null,"EPP necesario para atender casos sospechosos",{"$f":"N_PPE_per_case * N_suspected_cases_per_school_per_day * N_school * pct_school_reopen * N_school_days","v":4500},"conjunto(s)"]
[null,null,"Máquinas de humo para autobuses",{"$f":"N_fog_machine_per_bus * N_newly_hired_driver + (N_fog_machine_per_bus - N_fog_machine_per_bus_current) * N_driver * pct_teacher_staff_in_school","v":25},"pieza(s)",null,"P111"]
[null,null,"Desinfectante para autobuses",{"$f":"Disinfectant_bus_per_trip * (N_student * pct_student_in_school * pct_student_bus)/(N_student_full_capacity_school_bus * pct_bus_capacity) * 2 * N_school_days/1000","v":5.3523990000000001},"litro(s)"]
[null,null,"Sensores de temperatura automáticos para controlar la temperatura de los alumnos antes de subir a bordo.",{"$f":"N_temperature_sensor_per_bus * N_driver * pct_teacher_staff_in_school","v":50},"pieza(s)"]
[null,null,"Antisépticos de base alcohólica (al menos 70 por ciento alcohol)",{"$f":"Antiseptic_per_person_per_day_bus * (N_student * pct_student_in_school * pct_student_bus) * N_school_days/1000","v":1053},"litro(s)"]
[null,null,"Dispensadores antisépticos",{"$f":"N_dispenser_per_bus * N_newly_hired_driver + (N_dispenser_per_bus - N_dispenser_per_bus_current) * N_driver_current * pct_teacher_staff_in_school","v":50},"pieza(s)"]
[null,null,"Batas, delantales y gorros para el personal de cocina",{"$f":"N_gown_food_worker * N_newly_hired_food_staff + (N_gown_food_worker - N_gown_food_worker_current) * N_food_staff_current * pct_teacher_staff_in_school","v":0},"conjunto(s)",null,"P113"]
[null,null,"Utensilios desechables",{"$f":"(N_disposable_utensil_per_student - N_disposable_utensil_per_student_current) * N_student * pct_student_in_school * pct_student_lunch * N_school_days","v":0},"conjunto(s)"]
[null,null,"Disposable dishes",{"$f":"(N_disposable_dish_per_student - N_disposable_dish_per_student_current) * N_student * pct_student_in_school * pct_student_lunch * N_school_days","v":0},"set(s)"]
[null,null,"Desktop computers",{"$f":"N_desktop","v":100},"piece(s)",null,"P202"]
[null,null,"Computadoras portátiles",{"$f":"N_laptop","v":200},"pieza(s)"]
[null,null,"Tabletas",{"$f":"N_tablet","v":200},"pieza(s)"]
[null,null,"Teléfonos",{"$f":"N_phone","v":200},"pieza(s)"]
[null,null,"Equipo de protección especial o adaptado",{"$f":"N_adapted_PPE_per_school * N_school * pct_school_reopen","v":250},"conjunto(s)",null,"P401"]

{"sheet":"List_Economy","index":10,"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('Basic information about schools'!F9, $C$7:$C$225)),\"Please check the spelling\")","v":"Storyland"}]
[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":"Data prep","index":11,"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, 'Prices of additional resources'!H9:H56)","v":735467.31715909997}]
["Sustaining learning",{"$f":"_xlfn.AGGREGATE(9, 5, 'Prices of additional resources'!H58:H77)","v":1623266.3333333333}]
["Supporting emotional wellbeing",{"$f":"_xlfn.AGGREGATE(9, 5, 'Prices of additional resources'!H79:H87)","v":382234}]
["Reaching the marginalized",{"$f":"_xlfn.AGGREGATE(9, 5, 'Prices of additional resources'!H89:H97)","v":608420}]
["Total",{"$f":"SUM(B4:B7)","v":3349387.6504924335}]
[]
[null,"Total"]
["Additional cost",{"$f":"B8","v":3349387.6504924335}]
["Additional funding available",{"$f":"_xlfn.AGGREGATE(9, 5, Funding!F8:F19)","v":931000}]
["Funding gap",{"$f":"B11-B12","v":2418387.6504924335}]
[]
["Figure 1"]
[null,"Bottom block","Top block","Horizontal lines"]
["Costo adicional",{"$f":"B11","v":3349387.6504924335},{"$f":"B17-B11","v":0},{"$f":"B13","v":2418387.6504924335}]
["Financiamiento adicional disponible",{"$f":"B13","v":2418387.6504924335},{"$f":"B12","v":931000},{"$f":"D17","v":2418387.6504924335}]
["Brecha de financiamiento",{"$f":"B13","v":2418387.6504924335},{"$f":"B12","v":931000},{"$f":"D17","v":2418387.6504924335}]
[]
["Figure 2 & Figure 3"]
[null,"Additional cost","%"]
["Seguridad de las operaciones",{"$f":"B4","v":735467.31715909997},{"$f":"B23/SUM(B$23:B$26)","v":0.21958262043838675}]
["Sostener el aprendizaje",{"$f":"B5","v":1623266.3333333333},{"$f":"B24/SUM(B$23:B$26)","v":0.48464570325106365}]
["Respaldar el bienestar emocional",382234,0.11412056169246436]
["Llegar a los marginados",608420,0.18165111461808517]
[]
["Economic cost"]
["Figure 4 & Figure 5"]
[null,"Additional cost"]
["Seguridad de las operaciones",{"$f":"_xlfn.AGGREGATE(9, 5, 'Prices of additional resources'!L9:L56)","v":735467.31715909997}]
["Sostener el aprendizaje",{"$f":"_xlfn.AGGREGATE(9, 5, 'Prices of additional resources'!L58:L77)","v":1623266.3333333333}]
["Respaldar el bienestar emocional",{"$f":"_xlfn.AGGREGATE(9, 5, 'Prices of additional resources'!L79:L87)","v":382234}]
["Llegar a los marginados",{"$f":"_xlfn.AGGREGATE(9, 5, 'Prices of additional resources'!L89:L97)","v":608420}]

{"sheet":"Output","index":12,"n_rows":17,"n_cols":15,"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","Basic school information",null,null,"Report"]
["Parameter","Applicable to","Location","Education level: Pre-primary education","Education level: Primary education","Education level: Lower secondary education","Education level: Upper 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,2,true,true,false,false,false,1,null,{"$f":"D3","v":true},"Educación preescolar",{"$f":"_xlfn.CONCAT(L3, \" (\", 'Basic information about schools'!G35, \")\")","v":"Educación preescolar (Edad 3-5)"},null,{"$f":"_xlfn._xlws.FILTER(M3:M7, K3:K7 = TRUE, \"\")","v":"Educación preescolar (Edad 3-5)"}]
[1,"Todas las escuelas, independientemente de su estado de reapertura",{"$f":"'Basic information about schools'!F9","v":"Storyland"},"educación preescolar,","educación primaria,","educación secundaria inferior,","educación secundaria superior,","educación terciaria",null,null,{"$f":"E3","v":true},"Educación primaria",{"$f":"_xlfn.CONCAT(L4, \" (\", 'Basic information about schools'!G36, \")\")","v":"Educación primaria (Jardín a 3.º)"},null,"Educación primaria (Jardín a 3.º)"]
[2,"Escuelas reabiertas",{"$f":"'Basic information about schools'!G27","v":"Región Neverland"},null,null,null,null,null,null,null,{"$f":"F3","v":false},"Educación secundaria inferior",{"$f":"_xlfn.CONCAT(L5, \" (\", 'Basic information about schools'!G37, \")\")","v":"Educación secundaria inferior ()"}]
[3,null,{"$f":"'Basic information about schools'!G28","v":0},null,null,null,null,null,null,null,{"$f":"G3","v":false},"Educación secundaria superior",{"$f":"_xlfn.CONCAT(L6, \" (\", 'Basic information about schools'!G38, \")\")","v":"Educación secundaria superior ()"}]
[4,null,{"$f":"'Basic information about schools'!G29","v":0},null,null,null,null,null,null,null,{"$f":"H3","v":false},"Educación terciaria",{"$f":"_xlfn.CONCAT(L7, \" (\", 'Basic information about schools'!G39, \")\")","v":"Educación terciaria ()"}]
[5,null,{"$f":"'Basic information about schools'!G30","v":0}]
[6]
[7]
[8]
[9]
[10]
[]
[]
[null,"Conteo de palabras"]
[null,{"$f":"SUM(IF(LEN(TRIM(B3:L7))=0,0,LEN(TRIM(B3:L7))-LEN(SUBSTITUTE(B3:L7,\" \",\"\"))+1))","v":52}]