{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Instructions for translation","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","Data prep","Output","List_Economy"],"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":"Instructions for translation","index":0,"n_rows":61,"n_cols":4,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
[]
["Instructions for Translation"]
[]
["Total number of English words for translation"]
[{"$f":"SUM(Introduction!C56, 'Planned measures for reopening'!C40, 'Basic information about schools'!C107, 'School reopening status'!C24, 'Qty of additional resources'!C131, Calculators!C235, 'Prices of additional resources'!C101, Funding!C23, Report!C58, 'Items to purchase'!C51, 'Data prep'!A38, Output!A16, List_Economy!C287)","v":8862}]
[]
["How to translate the names of the tabs?"]
["1. Replace the English tab names with the translation"]
["2. Update macros"]
["    1) Under the ribbon \"Developer\" -> Click on \"View Code\" -> Click on \"Sheet 6 (Planned measures for reopening)\" -> Replace each English tab name with its translation"]
["    2) Click on \"Sheet 8 (Qty of additional resources)\" -> Replace each English tab name with its translation                           ",null,null,"                "]
[]
["Planned measures for reopening"]
["There is no need to translate the cells with the dropdown menu (i.e., Cell F24, Cell F26, Cell F27, Cell F28, Cell F31, Cell F32, Cell F34 and Cell F35). "]
[]
["Basic information about schools"]
["1. There is no need to translate the dropdown menu here, i.e., Cell F9"]
["2. For the buttons and checkboxes, "]
["    Under the ribbon \"Developer\" -> Click on \"Design Mode\" -> Click on each button or checkbox to translate the label. "]
["3. For Cell C48, the text that needs to be translated is highlighted in red.  =\"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)&\"\")  &\"\""]
[]
["School reopening status"]
["For texts within a formula, please do not translate the part within \"& &\". "]
["Take Cell 18 as an example. The text that needs to be translated is highlighted in red.  =\"<*The number of school days in all phases should sum up to \"&N_school_days&\".>\""]
[]
["Qty of additional resources"]
["Under the ribbon \"Developer\" -> Click on \"View Code\" -> Click on \"Sheet 8 (Qty of additional resources)\" -> Overwrite \"Must-have + Nice-to-have\" and \"Must-have\" with your translation. "]
[]
["Calculators"]
["There is no need to translate the table of contents. It will be updated automatically. "]
["You might need to reformat the spreadsheet after the translation. "]
[]
["Prices of additional resources"]
["Don't forget to translate Columns J-K. :-)"]
[]
["Funding"]
[]
["Report"]
["For Cell C7, Cell E23, Cell I9, Cell L10, Cell I23, and Cell L24, please do not translate the part within \"& &\". "]
["For the rest of the report, translate the text in red only. "]
[]
["Items to purchase"]
[]
["List_Economy"]
["Only need to replace the country/economy names, marked in red. Please make sure that your translation aligns with the official translation used by the World Bank. "]
[]
["Data prep"]
["Replace the text in red with the translation. "]
[]
["Output"]
["Replace the text in red with the translation. "]
[]
["Format cleaning"]
["After you complete the translation, "]
["1) remove all the cells for word counting, "]
["2) change the color of all the text to black, "]
["3) delete this tab of \"Notes for translation\", "]
["4) hide the spreadsheets of \"Data prep\", \"Output\" and \"List_Economy\". "]
["5) protect each tab using the password cost by clicking on \"Review\" -> \"Protect Sheet\". "]
[]
["If you have any questions on how to translate the tool, please contact Yilin Pan (ypan@worldbank.org). "]

{"sheet":"Introduction","index":1,"n_rows":56,"n_cols":16,"rows_kept":56,"cut":false,"hidden":false,"merged":[[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],[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],[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],[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]]}
[" ",null,"Version 1.0\nAugust 17, 2021"]
[null,null,"Costing Tool for School Reopening and Learning Recovery"]
[null,null,"Introduction"]
[]
[null,null,"1. What is this tool for?"]
[null,null,"Purposes\ni) Estimate the cost of implementing measures to ensure the safety of the education community, recover learning, and support the emotional wellbeing of children, while reaching the most marginalized populations; \nii) Identify sources of additional funding;\niii) Estimate funding gaps, if relevant; and\niv) guide the implementation of school reopening and learning recovery. "]
[null,null,"Audience\nInformation generated from the tool would be useful for government officials, school leaders, international organizations and donors who are involved in the planning, budgeting, and financing of school reopening and learning recovery during and after the pandemic. "]
[null,null,"Users\nWe recommend that government officials or school leaders who are assigned to budgeting and planning for school reopening would collect the data needed for the tool and fill out the spreadsheets. Researchers, international organizations, donors, and foundations can also use the tool to provide technical assistance to governments and to estimate the costs of interventions implemented in response to the COVID-19 pandemic. "]
[]
[null,null,"2. What are the components of the tool?"]
[]
[null,null,null,null,null,null,null,"Purpose of the spreadsheet",null,null,null,"Input",null,null,null,"Output"]
[]
[null,null,null,null,"Introduction",null,null,"Introduces what the tool is for and how to use the tool"]
[null,null,null,null,"Planned measures for reopening",null,null,"Provides a list of measures that help ensure safety operations, sustain learning, support emotional wellbeing and reach the marginalized",null,null,null,"Please check the measures that apply to your context and specify whether they apply to reopened schools or all schools when applicable"]
[null,null,null,null,"Basic information about schools",null,null,"Specifies the cost estimate of interest and describes the context that the cost estimate applies to",null,null,null,"Please describe the school reopening plan to cost out, specify which cost estimate is of interest, and provide some basic information about schools"]
[null,null,null,null,"School reopening status",null,null,"Records the predicted school reopening status during the time period of interest",null,null,null,"Please fill out your predicted estimates of the percentage of schools that provide in-person classes and the percentage of students who attend in-person classes"]
[null,null,null,null,"Quantities of additional resources",null,null,"Sets the parameters that affect the quantities of the additional resources needed",null,null,null,"Please specify your assumptions on resource needs and resource availability"]
[null,null,null,null,"Calculators",null,null,"Facilitates the estimation of the quantities for some resources if you do not have specific numbers",null,null,null,"Please specify your assumptions on resource needs and resource availability"]
[null,null,null,null,"Prices of additional resources",null,null,"Populates the quantities of the additional resources based on the parameters specified in previous pages and guides the users to specify the price of each resource",null,null,null,"Please specify the prices of the additional resources needed",null,null,null,"The quantities of the additional resources are populated automatically"]
[null,null,null,null,"Funding",null,null,"Delineates the funding sources",null,null,null,"Please specify funding available from different sources and the percentage of funding that is subject to reallocation"]
[null,null,null,null,"Report",null,null,"Summarizes the cost of the additional resources needed, the available funding and the financial gap if it exists",null,null,null,null,null,null,null,"A dashboard that summarizes the results is populated automatically"]
[null,null,null,null,"Items to purchase",null,null,"Generates a list of resources that need to be purchased",null,null,null,null,null,null,null,"A list of the materials and equipment that need to be purchased is populated"]
[]
[null,null,"3. How to use the tool?"]
[]
[null,null,"1) Enable macros. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"2) Input cells"]
[null,null,"Following the navigation bar, fill out the input cells on the spreadsheets of \"Planned measures for reopening\", \"Basic information about schools\", \"School reopening status\", \"Quantities of additional resources\", \"Calculators\", \"Prices of additional resources\" and \"Funding\". "]
[]
[null,null,"3) Output cells "]
[null,null,"Formulas are set up in the output cells. Once you hover your mouse cursor over an output cell, you will see a description of the formula. By default, these cells are locked to reduce the possibility of unintentional changes. You can unlock these cells to customize the tool based on your needs. To unlock a spreadsheet, click on \"Review\" -> \"Unprotect Sheet\" and input the password cost."]
[]
[null,null,"4. Help"]
[]
[null,null,"To report bugs, suggest features to add or provide your overall feedback to help us improve the tool, submit a response ",null,null,null,null,null,null,null,null,null,null,"here. "]
[null,null,"For any other questions, please contact Yilin Pan (ypan@worldbank.org).  "]
[]
[null,null,"5.  How to cite this tool?"]
[]
[null,null,"Yilin Pan, Alaka Holla, Nobuyuki Tanaka (2021). \"Costing tool for school reopening plans, version 1.0\". World Bank, Washington DC."]
[]
[]
[]
[null,null,"Word count"]
[null,null,{"$f":"SUM(IF(LEN(TRIM(B1:S53))=0,0,LEN(TRIM(B1:S53))-LEN(SUBSTITUTE(B1:S53,\" \",\"\"))+1))","v":676}]

{"sheet":"Planned measures for reopening","index":2,"n_rows":40,"n_cols":10,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,"<Check the measures that apply to your context>",null,null,"<Specify whether the measures apply to all schools or reopened schools when color-coded>"]
[null,null,null,"Measures","Explanation of the measures","Applicable to","Cost implications",null," "]
[null,null,null,"Pillar 1: Measures related to safe operations"]
[null,null,null,"Establish cleaning and disinfecting measures","Schedule regular cleaning of the school facilities. Clean and disinfect classrooms and spaces used for instruction, common spaces, gyms, toilets, as well as frequently touched surfaces such as door handles, desks, toys, supplies, light switches, doorframes, play equipment, teaching aids used by children, and covers of books. ","Reopened schools","Increase in cost",null,null,"P101"]
[null,null,null,"Provide personal protective equipment ","Enforce the school policy on wearing a mask or a face covering in line with national or local guidance. Provide sufficient medical masks for students and personnel. Introduce students with sensory concerns/tactile sensitivities to face coverings that are most comfortable for them. ","Reopened schools","Increase in cost",null,null,"P102"]
[null,null,null,"Provide hand hygiene materials","Create a schedule for frequent hand hygiene, especially for young children. Ensure handwashing strategies include washing with soap and water for at least 20 seconds. Handwashing/hand hygiene stations should be set up at school entrances and throughout the school (e.g., entrances and exits of gym and sports facilities, bathrooms, cafeteria, and classrooms). ","Reopened schools","Increase in cost",null,null,"P103"]
[null,null,null,"Provide on-site health screenings","Conduct simple health screening for body temperature and high-risk symptoms on entry into the building for all staff, students and visitors. ","Reopened schools","Increase in cost",null,null,"P104"]
[null,null,null,"Monitor symptoms through parent-reported surveys","Develop questionnaire/health survey to monitor history of fever and other symptoms. Parents, guardians, and caregivers can self-report the answers to these questions through existing school health portals or school communication platforms. Schools can also share the results with parents and aid in daily reporting.","Reopened schools","Increase in cost",null,null,"P105"]
[null,null,null,"Limit sharing objects","Ensure adequate supplies to minimize sharing of high touch materials to the extent possible (e.g., assigning each student their own art supplies, equipment) or limit use of supplies and equipment by one group of children at a time and clean and disinfect between use. Avoid sharing electronic devices, toys, books, and other games or learning aids.","Reopened schools","Increase in cost",null,null,"P106"]
[null,null,null,"Ensure spaces, materials, and strategies to maintain physical and social distancing","Increase desk spacing (at least 1.5 meters between desks).\nRepurpose unused or underutilized school (or community) spaces to increase classroom space and facilitate social distancing, including outside spaces. \nStagger arrival and dismissal times, recesses/breaks and lunchbreak. \nMinimize shared break times. ","Reopened schools","Increase in cost",null,null,"P107"]
[null,null,null,"Establish physical barriers and guides","Install physical barriers, such as sneeze guards and partitions. Provide physical guides, such as tape on floors or sidewalks and signs on walls (e.g., guides for creating “one way routes” in hallways). Add physical barriers, such as plastic flexible screens, between bathroom sinks especially when they cannot be at least 6 feet apart. ","Reopened schools","Increase in cost",null,null,"P108"]
[null,null,null,"Train students, teachers, staff, and parents on safe school operations","Educate everyone in the school about COVID-19 prevention and safety protocols. \nExplain to the students the reason for school-related measures (promote cough and sneeze etiquette and discuss need for safety protocols, existence of different sensitivities, hand-hygiene protocols especially after going to the bathroom, before eating, and after blowing your nose, coughing, or sneezing). \nInform parents about the measures the school is putting in place and ask for cooperation to report any cases of COVID-19 that occur in the household and on the importance of monitoring for and responding to the symptoms of COVID-19 at home, protocols for accompanying and picking up students, etc.). Offer weekly updates on these as the pandemic evolves. Broadcast regular announcements on reducing the spread of COVID-19 on PA systems. \nInclude messages (for example, videos) about behaviors that prevent the spread of COVID-19 when communicating with staff and families (such as on school websites, in emails, and on school social media accounts). \nPost signs in highly visible locations (e.g., school entrances, restrooms) that promote everyday protective measures and describe how to stop the spread of germs.","Reopened schools","Increase in cost",null,null,"P109"]
[null,null,null,"Maintain appropriate collaboration and coordination with local public health authorities. ","Provide public health officers with information needed to trace contacts if a case or outbreak occurs in the school as well as with parents. The school officials should notify public health authorities in case of a positive COVID-19 case. Develop a plan with state and local health department to conduct case tracing in the event of a positive case in the school. Ensure students who have been in contact with a COVID-19 case stay home for 14 days. ","Reopened schools","Increase in cost",null,null,"P110"]
[null,null,null,"Adapt transportation","Put in place respiratory and hand hygiene and physical distancing measures in transportation such as school buses, and tips for students on safe commute to and from school, including those using public transport. \nOnly 1 child per seat and at least 1 meter apart in school buses, if possible. If possible, windows of the bus should be kept open. Students, driver and companion must travel with masks. Drivers must keep a daily driving record of the students on board. \nAdvise against crowding during school pick-up or day care. ","Reopened schools","Increase in cost",null,null,"P111"]
[null,null,null,"Adapt ventilation","Ventilation systems should be operating properly and, when possible, circulation of outside air should be increased, for example by opening windows and doors. ","Reopened schools","Increase in cost",null,null,"P112"]
[null,null,null,"Reorganize lunch programs","Consider options such as “grab-and-go” bagged lunches or meal delivery. \nUse disposable food service items (e.g., utensils, dishes). Enhance hygiene and screening for illness among food preparation staff and their close contacts. ","Reopened schools","Increase in cost",null,null,"P113"]
[null,null,null,"Cancel field trips, assemblies, and other large gatherings","Cancel field trips, events, and extracurricular activities that involve the gathering of people. ","All schools, regardless of their reopening status","Potential savings",null,null,"P114"]
[null,null,null,"Pillar 2: Measures to recover learning"]
[null,null,null,"Provide teacher professional development","Provide professional development that is more practical and targeted at meeting specific instruction needs of teachers, for example, training on how to use computers for instructions. ","All schools, regardless of their reopening status","Increase in cost",null,null,"P201"]
[null,null,null,"Continue flexible or partial remote learning approaches","Continue remote learning practices, by blended methods where necessary and possible (e.g., some student groups could take online classes, learn from home through homework assignments, blogs, engage in at-home physical activity). If tele-schooling is not possible, invite students to take textbooks home or arrange to deliver assignments. Consider radio or television broadcasts of lessons, arrange a buddy system for homework with older siblings at home, or with friends by telephone. ","All schools, regardless of their reopening status","Increase in cost",null,null,"P202"]
[null,null,null,"Conduct diagnosis assessments","Prepare teachers to assess learning needs and to meet each student where he/she is. Provide training for teachers’ on how to assess students' needs, well-being and performance. ","Reopened schools","Increase in cost",null,null,"P203"]
[null,null,null,"Increase intensity and differentiation (personalized learning)","Implement large-scale remedial/accelerated learning programs. If possible, hire teaching aids to provide one-to-one or one-to-multiple tutoring sessions. ","Reopened schools","Increase in cost",null,null,"P204"]
[null,null,null,"Extend schedules","Expand schedules, especially for students who are falling behind. If necessary, use summer time to make up some of the missing school days to alleviate the learning loss. ","Reopened schools","Increase in cost",null,null,"P205"]
[null,null,null,"Hire new teachers, reorganize the working shifts or extend the working hours of teachers","Hire new teachers, reorganize the working shifts or extend the working hours of teachers to i) ensure smaller class size and ii) substitute for sick teachers. Reassign most at risk teachers (age, co-morbidities) to distance learning or administrative tasks. ","Reopened schools","Increase in cost",null,null,"P206"]
[null,null,null,"Pillar 3: Measures to support emotional wellbeing and recovery"]
[null,null,null,"Provide dedicated psychosocial support and counselling","In countries where educational institutions have professional counselors or psychologists who would respond to students with psychosocial needs, schools may need to be well prepared for a surge in demand by increasing the number of counselors or extending their service hours. But in countries where schools have no (or few) counselors, teachers may have to take the responsibility to provide students with some psychosocial support. Promote employees and students eating healthy, exercising, getting sleep, and finding time to unwind. Encourage employees and students to talk with people they trust about their concerns and how they are feeling. ","Reopened schools","Increase in cost",null,null,"P301"]
[null,null,null,"Adopt social and emotional learning (SEL) programs","Foster relationships between students, between students and adults at school. Reduce stigma. Support students and teachers’ social and emotional wellbeing. ","Reopened schools","Increase in cost",null,null,"P302"]
[null,null,null,"Pillar 4: Measures to reach the most marginalized"]
[null,null,null,"Provide adequate supports for recovery needs, especially for disadvantaged and vulnerable students","Depending on country context, these include refugees, migrants, minorities, girls, those living in poverty and in remote geographical areas or urban slums, children with disabilities, those who lack nutrition and protection, those exposed to child labor, violence and other adverse conditions, those who are enduring increased hardship and for students who have not been able to participate in online or home-based learning. \nInclude clear face coverings on school supply lists for teachers and staff who regularly interact with students who are deaf or hard of hearing, students learning to read, students with disabilities, and those who rely on lip reading as a part of learning. \nProvide personalized instructions or after-school programs to help students with special needs to catch up. \nFor girls, prevent gender-based violence at school, including providing separate sanitation facilities for girls and boys; eliminating policies that prohibit pregnant girls or young mothers from returning to school; and providing access to gender-equitable sex education. ","Reopened schools","Increase in cost",null,null,"P401"]
[null,null,null,"Conduct reenrollment campaigns and wraparound supports to prevent dropouts","The support would include financial and nonfinancial incentives, e.g., feeding programs, provision of school uniforms, provision of direct cash transfer, or removing or waiving school fees and other barriers preventing school attendance. \nProvide social and emotional support for out-of-school children. Ensure age-appropriate and frequent follow-up and support for children out of school and avoid penalizing or stigmatizing such students. \nEnsure that the enrollment process is easy to navigate and that procedural barriers to re-enrollment are low. ","Reopened schools","Increase in cost",null,null,"P402"]
[null,null,null,"Monitor and plan for absenteeism","Review the usual absenteeism patterns at the school among both students and staff. Alert local health officials about large increases in student and staff absenteeism. ","Reopened schools","Increase in cost",null,null,"P403"]
[]
[]
[null,null,"Word count"]
[null,null,{"$f":"SUM(IF(LEN(TRIM(B1:H37))=0,0,LEN(TRIM(B1:H37))-LEN(SUBSTITUTE(B1:H37,\" \",\"\"))+1))","v":1699}]

{"sheet":"Basic information about schools","index":3,"n_rows":107,"n_cols":19,"rows_kept":107,"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,"<Following the questions and fill out the input cells>"]
[]
[null,null,"Basic school information"]
[]
[null,null,"1. Country/economy",null,null,"India",null,"<Please choose the country/economy from the dropdown list>"]
[]
[null,null,"2. The school reopening plan to cost out"]
[]
[null,null,null,"1) Name of the document"]
[null,null,null,"Guidelines on how to open schools step by step in Malgudi"]
[]
[null,null,null,"2) Link to the document"]
[]
[]
[null,null,null,"3) Which educational levels does the school opening plan apply to?"]
[null,null,null,"K-12"]
[]
[null,null,"3. Which cost estimate is of interest to you?"]
[]
[null,null,null,"1) Are you interested in estimating the cost of reopening schools for the whole country,  a region/province/district, or a school?"]
[]
[]
[null,null,null,null,null,null,"Malgudi","<Please specify the name of the region>"]
[null,null,null,null,null,null,null,"<Please specify the name of the province/state>"]
[null,null,null,null,null,null,null,"<Please specify the name of the district>"]
[null,null,null,null,null,null,null,"<Please specify the name of the school>"]
[]
[]
[null,null,null,"2) Which education level(s) do you want to cost out? For each education level you check, please specify the grade levels that provide in-person classes. "]
[]
[null,null,null,null,null,null,"Ages 3-5","<Please specify the grade levels or age groups>"]
[null,null,null,null,null,null,"K-3","<Please specify the grade levels>"]
[null,null,null,null,null,null,null,"<Please specify the grade levels>"]
[null,null,null,null,null,null,null,"<Please specify the grade levels>"]
[null,null,null,null,null,null,null,"<Please specify the grade levels>"]
[]
[]
[null,null,null,"3) Which time period does the cost estimate apply to, e.g., January - December 2021, the spring semester of 2021, the first quarter of 2021, academic year 2021-2022?"]
[null,null,null,"The Fall sesmeter of 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., the fall sesmeter of 2021"},null,null,90,"days"]
[null,null,null,"Number of school days in an academic year",null,null,180,"days"]
[]
[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., pre-primary education, primary education,    ) in Malgudi, India"}]
[]
[null,null,null,"Students, schools and classes"]
[null,null,null,"Number of students",null,null,2000]
[null,null,null,"Number of schools",null,null,10,"Private schools included "]
[null,null,null,"Number of classes",null,null,100]
[]
[null,null,null,"Number of students per school",null,null,{"$f":"IF(ISERROR(N_student/N_school), \"\", N_student/N_school)","v":200}]
[null,null,null,"Number of students per class",null,null,{"$f":"IF(ISERROR(N_student/N_class), \"\", N_student/N_class)","v":20}]
[null,null,null,"Number of students with special needs",null,null,100]
[]
[]
[null,null,null,null,null,null,"Total",null,"Currently available","Newly hired"]
[null,null,null,"Teachers and school staff",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":256},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":235},{"$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":21}]
[null,null,null,"Number of teachers",null,null,{"$f":"N_teacher_current + N_newly_hired_teacher","v":105},null,100,5,"<Calculator 1.1 helps you estimate the demand of new teachers>"]
[null,null,null,"Number of management staff",null,null,{"$f":"N_management_staff_current + N_newly_hired_management_staff","v":30},null,30,null,"<Assume no new management staff are hired, but this can be overwritten.>"]
[null,null,null,"Number of teaching aids",null,null,{"$f":" N_teaching_aid_current + N_newly_hired_teaching_aid","v":25},null,15,10,"<Calculator 1.2 helps you estimate the demand of teaching aids>"]
[null,null,null,"Number of non-teaching staff"]
[null,null,null,"Cleaning staff",null,null,{"$f":"N_cleaner_current + N_newly_hired_cleaner","v":20},null,20,0,"<Calculator 1.3 helps you estimate the demand of cleaning staff>"]
[null,null,null,"School nurses",null,null,{"$f":"N_nurse_current + N_newly_hired_nurse","v":12},null,10,2,"<Calculator 1.3 helps you estimate the demand of school nurses>"]
[null,null,null,"School bus drivers",null,null,{"$f":"N_driver_current + N_newly_hired_driver","v":10},null,10,null,"<Assume no new bus drivers are hired, but this can be overwritten.>"]
[null,null,null,"Food service staff",null,null,{"$f":"N_food_staff_current + N_newly_hired_food_staff","v":20},null,20,null,"<Assume no new food service staff are hired, but this can be overwritten.>"]
[null,null,null,"Technical support staff",null,null,{"$f":"N_technician_current + N_newly_hired_technician","v":11},null,10,1,"<Calculator 1.3 helps you estimate the demand of technicians>"]
[null,null,null,"Counselors",null,null,{"$f":"N_counselor_current + N_newly_hired_counselor","v":6},null,5,1,"<Calculator 1.3 helps you estimate the demand of counselors>"]
[null,null,null,"Psychologists",null,null,{"$f":"N_psychologist_current + N_newly_hired_psychologist","v":6},null,5,1,"<Calculator 1.3 helps you estimate the demand of psychologists>"]
[null,null,null,"Social workers",null,null,{"$f":"N_social_worker_current + N_newly_hired_social_worker","v":6},null,5,1,"<Calculator 1.3 helps you estimate the demand of social workers>"]
[null,null,null,"Social mobilizers for the enrollment campaign",null,null,{"$f":"N_mobilizer_current + N_newly_hired_mobilizer","v":5},null,5,0,"<Calculator 1.3 helps you estimate the demand of social mobilizers>"]
[null,null,null,"Other",null,null,{"$f":"N_other_staff_current + N_newly_hired_other_staff","v":0},null,0,0]
[]
[]
[null,null,null,"Number of teachers who work closely with students with special needs",null,null,{"$f":"IF(ISERROR(N_teacher * (N_student_special_needs/N_student)), \"\", N_teacher * (N_student_special_needs/N_student))","v":5.25},"<The default setting assumes this number is proportional to the # of students with special needs>"]
[]
[null,null,null,"School bus",null,null,null,null,null,null,null,null,null,null,null,null,null,null,111]
[null,null,null,"% of students who take school buses"]
[null,null,null,null,"In the COVID-19 era",null,0.3,"among those who attend school"]
[null,null,null,null,"In the pre-COVID-19 era",null,0.5,"among those who attend school"]
[null,null,null,"Full capacity of school buses on average",null,null,20,"students per bus"]
[]
[null,null,null,"School lunch",null,null,null,null,null,null,null,null,null,null,null,null,null,null,113]
[null,null,null,"% of schools who have lunch at school now",null,null,0.9,"among those who attend school"]
[]
[null,null,null,"Diagnostic assessments",null,null,null,null,null,null,null,null,null,null,null,null,null,null,203]
[null,null,null,"% of students to test",null,null,0.95]
[]
[null,null,null,"Personalized learning (in the format of tutoring)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,204]
[null,null,null,"% of students who need personalized learning",null,null,0.2]
[]
[null,null,null,"Facilities"]
[null,null,null,"How many classrooms share a restroom?",null,null,4]
[null,null,null,"Teachers in how many classrooms share an office?",null,null,4]
[]
[null,null,"5. In which currency is the cost expressed? ",null,null,null,"MRupee"]
[]
[null,null,"6. In which year do you want to express the cost?",null,null,null,2021]
[]
[null,null,null,"."]
[]
[]
[null,null,"Word count"]
[null,null,{"$f":"SUM(IF(LEN(TRIM(B68:Q104))=0,0,LEN(TRIM(B68:Q104))-LEN(SUBSTITUTE(B68:Q104,\" \",\"\"))+1))","v":261}]

{"sheet":"School reopening status","index":4,"n_rows":24,"n_cols":18,"rows_kept":24,"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]]}
[]
[]
[]
[]
[]
[]
[null,null,{"$f":" \"School reopening status during \"&LOWER('Basic information about schools'!D43)&\"\"","v":"School reopening status during the fall sesmeter of 2021"}]
[null,null,"<If schools or students return to in-person classes in phase, please specify the percentage of schools that provide in-person classes, the percentage of students who attend in-person classes, and the number of school days for each phase. If not, just fill out the three parameters in Phase 1.>"]
[null,null,null,null,null,null,null,"Phase 1",null,"Phase 2",null,"Phase 3",null,"Phase 4",null,"Phase 5",null,{"$f":"\"Average across \"&LOWER('Basic information about schools'!D43)&\"\"","v":"Average across the fall sesmeter of 2021"}]
[null,null,"% of schools that provide in-person classes",null,null,null,null,0.4,null,0.8,null,0.95,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.71666666666666667}]
[]
[null,null,"% of students who attend in-person classes",null,null,null,null,0.5,null,0.85,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.76666666666666672}]
[]
[null,null,"Number of school days (in days)*",null,null,null,null,30,null,30,null,30]
[]
[null,null,"% of teachers and school staff that are present in school **",null,null,null,null,{"$f":"H10","v":0.4},null,{"$f":"J10","v":0.8},null,{"$f":"L10","v":0.95},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.71666666666666667}]
[]
[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,"<**The default setting assumes that the number of teachers and school staff that are present in school is proportional to the number of schools that provide in-person classes. You may revise it based on your context. For example, if larger schools are more likely to reopen, the % of teachers and school staff that are present would be higher than the % of schools that provide in-person classes. If only certain grades go back to in-person classes in these reopened schools, the % of teachers and school staff that are present in schools would be approximate to the % of students who attend in-person classes.>"]
[]
[]
[]
[null,null,"Word count"]
[null,null,{"$f":"SUM(IF(LEN(TRIM(B1:T21))=0,0,LEN(TRIM(B1:T21))-LEN(SUBSTITUTE(B1:T21,\" \",\"\"))+1))","v":241}]

{"sheet":"Qty of additional resources","index":5,"n_rows":131,"n_cols":10,"rows_kept":131,"cut":false,"hidden":false,"merged":[[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],[28,3,29,3],[24,2,26,2],[27,2,38,2],[39,2,45,2],[49,2,54,2],[56,2,59,2],[60,2,67,2],[69,2,74,2],[76,2,82,2],[83,2,93,2],[94,2,97,2],[98,2,99,2],[100,2,101,2],[102,2,103,2],[105,2,110,2],[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],[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]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,"<Check whether the default settings make sense to you. If not, revise based on your context>"]
[null,null,"Checked measures","Additional resources","Parameter settings",null,"Notes"]
[null,null,"Pillar 1: Actions related to safe operations"]
[null,null,"Establish cleaning and disinfecting measures","Disinfectant",null,null,"See Calculator 2.1 for details",null,null,"P101"]
[null,null,null,"Empty containers for diluting cleaning and disinfection products",1,"container(s) per cleaner (goal)"]
[null,null,null,null,0.5,"container(s) per cleaner (current availability)"]
[null,null,null,"Electrostatic disinfectant sprayers",1,"sprayer(s) per cleaner (goal)"]
[null,null,null,null,0.5,"sprayer(s) per cleaner (current availability)"]
[null,null,null,"Mops, buckets and brushes",1,"set(s) per classroom/restroom/office (goal)"]
[null,null,null,null,0.5,"set(s) per classroom/restroom/office (current availability)"]
[null,null,null,"Soap bars",1,"soap bar(s) per classroom/restroom/office"]
[null,null,null,"Water",{"$f":"MAX(IF(Calculators!I90 = 0, Calculators!I90, Calculators!I89/(Calculators!I90/5)), IF(Calculators!I155 = 0, Calculators!I154, Calculators!I154/Calculators!I155)) - 1","v":4},"time(s) more than the water usage in the pre-COVID-19 era","The increase in water usage is mainly caused by higher frequency of cleaning and higher frequency of handwashing . For example, if cleaning was conducted weekly in the pre-COVID-19 era but daily during the COVID-19 era, 4 times more water would be needed (i.e., 1 / (1/5) - 1). If students were required to wash their hands twice a day in the pre-COVID-19 era but five times now, 1.5 times more water would be needed (i.e., 5/2 - 1). The default value is the larger number of these two ratios. "]
[null,null,null,"Rubber gloves for cleaning staff",2,"pair(s) per cleaner (goal)"]
[null,null,null,null,1,"pair(s) per cleaner (current availability)"]
[null,null,null,"Disposable gowns for cleaning staff",1,"set(s) per cleaner per day"]
[null,null,null,"Reusable gowns and caps for cleaning staff",2,"set(s) per cleaner (goal)","One pair for classes and one pair for restroom per cleaner."]
[null,null,null,null,1,"set(s) per cleaner (current availability)"]
[null,null,null,"Newly hired cleaning staff ",{"$f":"N_newly_hired_cleaner","v":0},"FTE(s)"]
[null,null,null,"Overtime payment for cleaning staff",0,"hour(s) per cleaner per day "]
[null,null,"Provide personal protective equipment ","Reusable masks",null,null,"See Calculator 4.1 for details",null,null,"P102"]
[null,null,null,"Disposable masks",null,null,"See Calculator 4.2 for details"]
[null,null,null,"Face shields",1,"face shield(s) per teacher or school staff"]
[null,null,"Provide hand hygiene materials","Alcohol-based antiseptic (at least 60 percent alcohol)",null,null,"See Calculator 3.1 for details",null,null,103]
[null,null,null,"Antiseptic dispensers",2,"dispenser(s) per classroom/restroom/office (goal)"]
[null,null,null,null,1,"dispenser(s) per classroom/restroom/office (current availability)"]
[null,null,null,"Liquid soap",null,null,"See Calculator 3.3 for details"]
[null,null,null,"Paper towels",2,"roll(s) per person (including students, teachers and school staff) per month (i.e., 20 school days) (goal)"]
[null,null,null,null,1,"roll(s) per person (including students, teachers and school staff) per month (i.e., 20 school days) (current availability)"]
[null,null,null,"EPA-registered disposable wipes",2,"package(s) per person per month (i.e., 20 school days) (goal)"]
[null,null,null,null,1,"package(s) per person per month (i.e., 20 school days) (current availability)"]
[null,null,null,"No-touch/foot-pedal trash cans",2,"trash can(s) per classroom/restroom/office (goal)"]
[null,null,null,null,1,"trash can(s) per classroom/restroom/office (current availability)"]
[null,null,null,"Hand dryer ",1,"hand dryer(s) per restroom (goal)"]
[null,null,null,null,1,"hand dryer(s) per restroom (current availability)"]
[null,null,"Provide on-site health screenings","Automatic temperature sensors ",null,null,"See Calculator 5 for details",null,null,"P104"]
[null,null,null,"Oximeters",null,null,"See Calculator 5 for details"]
[null,null,null,"Overtime payment for screening staff who are sufficiently trained in screening procedures",1,"hour(s) per screener per day","See Calculator 5 for the number of screeners needed in a school"]
[null,null,null,"Protective masks and disposable gloves for screening staff",1,"sets per screener per day"]
[null,null,null,"Newly hired full-time nurses",{"$f":"N_newly_hired_nurse","v":2},"FTE(s)"]
[null,null,null,"Overtime payment for full-time nurses",1,"hour(s) per nurse per day"]
[null,null,null,"Emergency room/health clinic/isolation rooms",2,"room(s) per school"]
[null,null,"Monitor symptoms through parent-reported surveys","Overtime payment for technicians to i) set up the online health monitoring and reporting platform and ii) prepare and disseminate daily reporting",0,"hour(s) per technician per day",null,null,null,"P105"]
[null,null,"Limit sharing objects","Teaching or learning materials that need to be purchased to limit sharing",100,"set(s)","Please specify what teaching or learning materials need to be purchased. Add more rows at the end of the table if needed. ",null,null,"P106"]
[null,null,"Ensure spaces, materials, and strategies to maintain physical and social distancing","Rental cost of community unused spaces",0,"square meters per school per day","Rules of thumb to determine the area of space needed: \n1) Maintain a distance of at least 1 square meters between everyone present at school.  \n2) Cohorting denotes having the same small group of students (10 or fewer) stay with the same staff as much as possible.",null,null,"P107"]
[null,null,"Establish physical barriers and guides","Physical barriers in the classrooms",1,"plastic flexible screen per student",null,null,null,"P108"]
[null,null,null,null,0.8,"of all reopened schools choose to install the physical barriers"]
[null,null,null,"Physical barriers between restroom sinks",5,"sink(s) per restroom"]
[null,null,null,null,0.8,"of all reopened schools choose to install the physical barriers"]
[null,null,null,"Tapes to mark signs on floors or sidewalks",10,"tape roll(s) per school"]
[null,null,null,"Posters or signs on walls",10,"poster(s) per school"]
[null,null,"Train students, teachers, staff, and parents on safe school operations","Overtime payment for teachers and staff to participate in the training on safe operations",1,"hour(s) per teacher or staff member",null,null,null,"P109"]
[null,null,"Maintain appropriate collaboration and coordination with local public health authorities. ","Gowns or white scrubs for school nurses",2,"gown(s) or white scrub(s) per nurse (goal)",null,null,null,"P110"]
[null,null,null,null,1,"gown(s) or white scrub(s) per nurse (current availability)"]
[null,null,null,"PPE needed to address suspected cases",1,"set of disposable grown, gloves, and mask per suspected case"]
[null,null,null,null,2,"suspected cases per school per day"]
[null,null,"Adapt transportation","Fog machines for buses",1,"fog machine per bus driver (goal)",null,null,null,"P111"]
[null,null,null,null,0.5,"fog machine per bus driver (current availability)"]
[null,null,null,"Disinfectant for buses",null,null,"See Calculator 2.2"]
[null,null,null,"Automatic temperature sensors to screen student temperature before boarding",1,"temperature sensor(s) per bus driver"]
[null,null,null,"Alcohol-based antiseptic (at least 70 percent alcohol)",null,null,"See Calculator 3.2"]
[null,null,null,"Antiseptic dispensers",2,"dispenser(s) per bus driver (goal)"]
[null,null,null,null,1,"dispenser(s) per bus driver (current availability)"]
[null,null,null,"Additional fuel",0.5,"of typical capacity to adhere to physical distancing guidelines",{"$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,"Adapt ventilation","Updating HVAC systems",0.1,"of reopened schools need to update the HVAC systems","If fans are used instead of HVAC, unlock the spreadsheet and replace HVAC with fans. ",null,null,"P112"]
[null,null,"Reorganize lunch programs","Gowns, aprons and caps for food service workers",1,"set(s) per food service worker (goal)",null,null,null,"P113"]
[null,null,null,null,1,"set(s) per food service worker (current availability)"]
[null,null,null,"Disposable utensils",1,"set(s) per student for whose who have lunch at school (goal)","If a school has been providing disposable utensils, it does not seem that more disposable utensils are needed because of the COVID-19 response. There might be some savings from previous school closure. "]
[null,null,null,null,1,"set(s) per student for whose who have lunch at school (current availability)"]
[null,null,null,"Disposable dishes",1,"disposable dish(es) per student for whose who have lunch at school (goal)","If a school has been providing disposable dishes, it does not seem that more disposable dishes are needed because of the COVID-19 response. There might be some savings from previous school closure. "]
[null,null,null,null,1,"disposable dish(es) per student for whose who have lunch at school (current availability)"]
[null,null,"Pillar 2: Actions to recover learning"]
[null,null,"Provide teacher professional development","Overtime payment for teachers to participate in the training sessions on pedagogy",2,"session(s) per teacher for those who participate in the training sessions on pedagogy",null,null,null,"P201"]
[null,null,null,null,1,"hour(s) per session"]
[null,null,null,null,1,"of all teachers participate in the training sessions on pedagogy"]
[null,null,null,"Compensation for external trainers to provide the training sessions",50,"external trainer(s)"]
[null,null,null,null,20,"session(s) per trainer"]
[null,null,null,null,1,"hour(s) per session"]
[null,null,null,"Materials for teacher professional training",1,"set(s) per teacher"]
[null,null,"Continue flexible or partial remote learning approaches","Remote learning platforms",null,null,"See Calculator 6 for details",null,null,"P202"]
[null,null,null,"Compensation for internet access",0.4,"of all teachers receive compensation for internet access"]
[null,null,null,null,0.5,"of all students receive compensation for internet access"]
[null,null,null,"Compensation for cell phone data plans",0.4,"of all teachers receive compensation for cell phone data plans"]
[null,null,null,null,0.5,"of all students receive compensation for cell phone data plans"]
[null,null,null,"Desktop computers",100,"desktop(s)"]
[null,null,null,"Laptops",200,"laptop(s)"]
[null,null,null,"Tablets",200,"tablet(s)"]
[null,null,null,"Phones",200,"phone(s)"]
[null,null,null,"Newly hired technicians",{"$f":"N_newly_hired_technician","v":1},"FTE(s)"]
[null,null,null,"Overtime payment for technicians or other staff to provide technical assistance",1,"hour(s) per technician per day"]
[null,null,"Conduct diagnosis assessments","License fee of the assessments",1,"license(s)","Specify how the license fee is charged, e.g., by school or by student?",null,null,"P203"]
[null,null,null,"Printing of the assessments (if delivered on paper)",2,"page(s) to print for each tested student"]
[null,null,null,"Compensation for external assessment specialists to develop the assessments and provide training",10,"external assessment specialist(s)"]
[null,null,null,null,10,"hour(s) per assessment specialist"]
[null,null,"Increase intensity and differentiation (personalized learning)","License fees for the remedial or accelerated programs",1,"license(s)","Specify how the license fee is charged. ",null,null,"P204"]
[null,null,null,"Payment for teaching aids to provide personalized learning in the format of tutoring"]
[null,null,"Extend schedules","Overtime payment for teachers to provide instructions",8,"hour(s) per day for those extended days",null,null,null,"P205"]
[null,null,null,null,30,"extended day(s)"]
[null,null,"Hire new teachers, reorganize the working shifts or extend the working hours of teachers","Additional teachers hired to ensure smaller class size and substitute sick colleagues",{"$f":"N_newly_hired_teacher","v":5},"FTE(s)",null,null,null,"P206"]
[null,null,null,"Overtime payment for current teachers to substitute sick colleagues"]
[null,null,"Pillar 3: Actions to support emotional wellbeing and recovery"]
[null,null,"Provide dedicated psychosocial support and counselling","Newly hired counselors",{"$f":"N_newly_hired_counselor","v":1},"FTE(s)",null,null,null,"P301"]
[null,null,null,"Overtime payment for counselors",0,"hour(s) per counselor per day"]
[null,null,null,"Newly hired social workers",{"$f":"N_newly_hired_social_worker","v":1},"FTE(s)"]
[null,null,null,"Overtime payment for social workers",0,"hour(s) per social worker per day"]
[null,null,null,"Newly hired psychologists",{"$f":"N_newly_hired_psychologist","v":1},"FTE(s)"]
[null,null,null,"Overtime payment for psychologists",0,"hour(s) per psychologist per day"]
[null,null,"Adopt social and emotional learning (SEL) programs","Overtime payment for teachers to participate in the training sessions on SEL ",1,"session(s) per teacher for those who participate in the training sessions on SEL",null,null,null,"P302"]
[null,null,null,null,1,"hour(s) per training session"]
[null,null,null,null,0.2,"of all teachers in school participate in the training sessions on SEL"]
[null,null,null,"Overtime payment for teachers to promote SEL",1,"hour(s) per teacher per day for those who work overtime to promote SEL"]
[null,null,null,null,0.2,"of all teachers in school work overtime to promote SEL"]
[null,null,null,"License fees for SEL programs adopted",4,"license(s)","Specify how the license fee is charged, e.g., by school or by student. If a SEL program is developed for the COVID-19 response, please specify the development cost. "]
[null,null,"Pillar 4: Actions to reach the most marginalized"]
[null,null,"Provide adequate supports for recovery needs, especially for disadvantaged and vulnerable students","Special or adapted protective equipment",10,"set(s) per school","Please specify based on the context. For clear facial masks, please see Calculator 3.2",null,null,"P401"]
[null,null,"Conduct reenrollment campaigns and wraparound supports to prevent dropouts","Staff time to design and implement the enrollment campaigns",20,"hour(s) per social mobilizer",null,null,null,"P402"]
[null,null,null,"Transportation cost for the campaigns",120,"trip(s)"]
[null,null,null,"Feeding programs",100,"beneficiary/beneficiaries"]
[null,null,null,"Provision of school uniforms",100,"set(s) of uniform"]
[null,null,null,"Removing or waiving school fees",100,"fee waiver(s)"]
[null,null,null,"<Please specify based on the support provided>"]
[null,null,"Monitor and plan for absenteeism","Overtime payment for staff to monitor and plan for absenteeism (if applicable)",2,"staff members per school for absenteeism monitoring",null,null,null,"P403"]
[null,null,null,null,1,"hour(s) per day"]
[]
[]
[null,null,"Word count"]
[null,null,{"$f":"SUM(IF(LEN(TRIM(B1:H128))=0,0,LEN(TRIM(B1:H128))-LEN(SUBSTITUTE(B1:H128,\" \",\"\"))+1))","v":1759}]

{"sheet":"Calculators","index":6,"n_rows":235,"n_cols":20,"rows_kept":235,"cut":false,"hidden":false,"merged":[[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],[70,3,70,17],[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]]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"<Fill out the input cells>"]
[]
[null,null,"Calculators"]
[]
[null,null,"Table of Contents"]
[]
[null,null,null,{"$f":"C19","v":"Calculator 1. How to estimate the number of new teachers and staff needed"}]
[null,null,null,{"$f":"C70","v":"Calculator 2. How to calculate the quantity of disinfectant needed"}]
[null,null,null,{"$f":"C127","v":"Calculator 3. How to calculate the quantity of antiseptic and liquid soap for handwashing"}]
[null,null,null,{"$f":"C166","v":"Calculator 4. How to calculate the number of masks"}]
[null,null,null,{"$f":"C196","v":"Calculator 5. How to calculate the number of automatic temperature sensors, oximeters and screening staff"}]
[null,null,null,{"$f":"C211","v":"Calculator 6: How to estimate the cost of developing a remote learning platform"}]
[]
[]
[null,null,"Calculator 1. How to estimate the number of new teachers and staff needed"]
[null,null,null,"<Note that the populated numbers only represent the demand of new teachers and staff. The actual numbers that can be newly hired are determined by both the demand and the supply of new teachers and staff. When finalizing these estimates, please take into consideration the feasibility of hiring new teachers and staff in a large scale within a short period of time in your context.>"]
[]
[null,null,null,"1.1. Teachers","a) Ensure smaller class size to maintain social distancing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P206"]
[null,null,null,null,null,"Current class size",null,null,null,null,{"$f":"N_student_per_class","v":20},"students/class"]
[null,null,null,null,null,"Targeted cohort size",null,null,null,null,10,"students/cohort",null,"<Cohorting denotes having the same small group of students (10 or fewer) stay with the same staff as much as possible. >"]
[null,null,null,null,null,"Number of new teachers to hire for this purpose",null,null,null,null,{"$f":"IF(ISERROR((K23/K24 - 1) * N_teacher_current), \"\", (K23/K24 - 1) * N_teacher_current)","v":100},"teachers"]
[]
[null,null,null,null,"b) Substitute for teachers who are on sick leave because of COVID-19 infection or conditions that exhibit similar symptoms"]
[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 the fall sesmeter of 2021"},null,null,null,null,null,null,0.05]
[null,null,null,null,null,"The average days of sick leave",null,null,null,null,null,null,20,"day(s)"]
[null,null,null,null,null,"Number of hours per working day",null,null,null,null,null,null,8,"hour(s)"]
[null,null,null,null,null,"Total number of hours that need to be substituted",null,null,null,null,null,null,{"$f":"M28*N_teacher_current*M29*M30","v":800},"hour(s)"]
[null,null,null,null,null,"% of these hours that can be covered by current teachers",null,null,null,null,null,null,0.1]
[null,null,null,null,null,"Number of new teachers to hire for this purpose",null,null,null,null,null,null,{"$f":"N_hour_substitute*(1-M32)/(8*N_school_days)","v":1},"teacher(s)"]
[]
[null,null,null,null,"Total number of teachers needed to ensure smaller class size and substitute for sick teachers",null,null,null,null,null,null,null,{"$f":"K25+M33","v":101},"teacher(s)"]
[]
[null,null,null,"1.2. Teaching aids to provide personalized learning in the format of tutoring",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P204"]
[]
[null,null,null,null,"The number of hours of tutoring a student needs to attend per day",null,null,null,null,null,null,1,"hour(s) per day"]
[null,null,null,null,"Format of tutoring",null,null,null,null,null,"One aid for",1.5,"student(s)"]
[null,null,null,null,"The total number of working hours for teaching aids",null,null,null,null,null,null,{"$f":"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":204.44444444444446},"hour(s)"]
[null,null,null,null,"Number of working hours per day",null,null,null,null,null,null,8,"hour(s) per day"]
[null,null,null,null,"Number of teaching aids needed in total",null,null,null,null,null,null,{"$f":"L41/L42","v":25.555555555555557},"teaching aid(s)"]
[null,null,null,null,"Number of new teaching aids to hire",null,null,null,null,null,null,{"$f":"IF((L43-'Basic information about schools'!I64)>0, L43-'Basic information about schools'!I64, \"Sufficient number of\")","v":10.555555555555557},"teaching aid(s)"]
[]
[null,null,null,"1.3. Non-teaching staff"]
[]
[null,null,null,"Rules of thumb to determine the quantity",null,null,null,null,null,null,null,"<Leave the cell blank if there is no min requirement>",null,null,null,"<Leave the cell blank if there is no max requirement>"]
[]
[null,null,"Cleaning staff",null,"Serving",1,"school(s),",1,"cleaner(s) per ",150,"students, ","with a min of ",1,{"$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,"School nurses",null,"Serving",1,"school(s),",1,"nurse(s) per ",150,"students, ","with a min of ",1,{"$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,"Technicians",null,"Serving",1,"school(s),",1,"technician(s) per ",150,"students, ","with a min of ",1,{"$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,"Counselors",null,"Serving",2,"school(s),",1,"counselor(s) per",250,"students, ","with a min of ",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,"Psychologists",null,"Serving",2,"school(s),",1,"psychologist(s) per",250,"students, ","with a min of ",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,"Social workers",null,"Serving",5,"school(s),",1,"social worker(s) per",250,"students, ","with a min of ",null,"per 5 schools and a max of",null,null,null,"per 5 schools"]
[null,null,"Social mobilizers",null,"Serving",5,"school(s),",1,"social mobilizer(s) per",500,"students, ","with a min of ",null,"per 5 schools and a max of",null,null,null,"per 5 schools"]
[]
[null,null,null,"Number of students in a school",null,null,null,null,{"$f":"N_student_per_school","v":200},"<The default setting is the average number of students in a school.>"]
[]
[null,null,null,null,"Needed per school",null,"Currently available per school",null,null,"New staff to hire per school"]
[null,null,"Cleaning staff",null,{"$f":"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":"N_cleaner_current/N_school","v":2},null,null,{"$f":"IF(E61-G61 >0, E61-G61, \"The number of staff is sufficient\")","v":"The number of staff is sufficient"}]
[null,null,"School nurses",null,2,null,{"$f":"N_nurse_current/N_school","v":1},null,null,{"$f":"IF(E62-G62 >0, E62-G62, \"The number of staff is sufficient\")","v":1}]
[null,null,"Technicians",null,2,null,{"$f":"N_technician_current / N_school","v":1},null,null,1]
[null,null,"Counselors",null,1,null,{"$f":"N_counselor_current/N_school","v":0.5},null,null,0.5]
[null,null,"Psychologists",null,1,null,{"$f":"N_psychologist_current/N_school","v":0.5},null,null,0.5]
[null,null,"Social workers",null,0.8,null,{"$f":"N_social_worker_current/N_school","v":0.5},null,null,0.30000000000000004]
[null,null,"Social mobilizers",null,0.4,null,{"$f":"N_social_worker_current/N_school","v":0.5},null,null,"The number of staff is sufficient"]
[]
[]
[null,null,"Calculator 2. How to calculate the quantity of disinfectant needed"]
[null,null,null,"<For disinfection, the WHO recommends using sodium hypochlorite (bleach or chlorine) at a concentration of 0.1 percent or 1,000ppm (1 part of 5% strength household\nbleach to 49 parts of water) or solutions containing 70 to 90 percent alcohol.> "]
[null,null,null,"2.1. For a typical school"]
[null,null,null,"Factor 1: Area to be disinfected using spray",null,null,null,null,{"$f":"I79*N_room_per_school","v":450},"square meter(s)",null,"<This is a conservative estimate as we assume that once a school reopens, all the facilities need to be disinfected, regardless how many students come to school.>"]
[]
[null,null,null,"Area of a typical classroom"]
[null,null,null,"Length of the floor for a typical classroom",null,null,null,null,4,"meter(s)"]
[null,null,null,"Width of the floor for a typical classroom",null,null,null,null,3,"meter(s)"]
[null,null,null,"Area of the floor for a typical classroom",null,null,null,null,{"$f":"I76*I77","v":12},"square meter(s)",null,"<Length * width>"]
[null,null,null,"Area of the room (including all walls, floor and ceiling)",null,null,null,null,{"$f":"2.5*I78","v":30},"square meter(s)",null,"<The rule of thumb is 2.5 times of the area of the floor>"]
[]
[null,null,null,"The total number of rooms (including classrooms, bathrooms and offices) to disinfect in a typical school",null,null,null,null,{"$f":"('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},"Room(s)",null,"<Average number of classrooms per school * (1 + 1/classroom-bathroom ratio + 1/classroom-office ratio)>"]
[]
[]
[null,null,null,"Factor 2: Quantity of mixed solution required",null,null,null,null,0.05,"liter(s) per square meter",null,"<See the product label>"]
[]
[null,null,null,"Factor 3: Dilution rate",null,null,null,null,0.05,null,null,"<See the product label. The rate is the amount of the concentrated disinfectant divided by the amount of water needed.>"]
[]
[null,null,null,"Factor 4: Frequency of disinfection"]
[null,null,null,"In the COVID-19 era",null,null,null,null,1,"time(s) per day",null,"<School facilities are recommended to be cleaned and disinfected at least daily.>"]
[null,null,null,"In the pre-COVID-19 era",null,null,null,null,1,"time(s) per week"]
[null,null,null," "]
[null,null,null,"The quantity of disinfectant needed to spray a typical school per day"]
[null,null,null,"In the COVID-19 era",null,null,null,null,{"$f":"I73*I84*I86*I89","v":1.125},"liter(s)",null,"<Factor 1 * Factor 2 * Factor 3 * Factor 4 for the COVID-19 era>"]
[null,null,null,"In the pre-COVID-19 era",null,null,null,null,{"$f":"I73*I84*I86*I90/5","v":0.22500000000000001},"liter(s)",null,"<Factor 1 * Factor 2 * Factor 3 * Factor 4 for the pre-COVID-19 era>"]
[null,null,null,"Gap",null,null,null,null,{"$f":"I93-I94","v":0.9},"liter(s)"]
[]
[]
[null,null,null,"2.2. For a school bus"]
[null,null,null,"Factor 1: Areas to be disinfected using spray",null,null,null,null,{"$f":"I103","v":60.996000000000002},"square meter"]
[null,null,null,null,"Length of the bus",null,null,null,8,"meter",null,"<Mini School Bus: 6.1-7.6 meters; \nMid-Sized School Bus: 7.6-10.7 meters;\nFull-sized school buses: 10.7+ meters>"]
[null,null,null,null,"Width of the bus",null,null,null,2.5499999999999998,"meter"]
[null,null,null,null,"Height of the bus",null,null,null,2.99,"meter"]
[null,null,null,null,"Area of the bus (including all walls, floor, ceiling and seats)",null,null,null,{"$f":"I100*I101*I102","v":60.996000000000002},"square meter",null,"<Length * width * height>"]
[]
[null,null,null,"Factor 2: Quantity of mixed solution required",null,null,null,null,0.05,"Liter per square meter",null,"<See the product label>"]
[]
[null,null,null,"Factor 3: Dilution rate",null,null,null,null,0.05,null,null,"<See the product label. The rate is the amount of the concentrated disinfectant divided by the amount of the water>"]
[]
[null,null,null,"Factor 4: Frequency of disinfection "]
[null,null,null,"In the COVID-19 era",null,null,null,null,{"$f":"1","v":1},"time per trip"]
[null,null,null,"In the pre-COVID-19 era",null,null,null,null,1,"time per week (e.g., 2 trips a day, 5 days per week)"]
[]
[null,null,null,"The quantity of disinfectant needed to spray a bus per trip"]
[null,null,null,"In the COVID-19 era",null,null,null,null,{"$f":"I99*I105*I107*I110","v":0.15249000000000001},"liter(s)",null,"<Factor 1 * Factor 2 * Factor 3 * Factor 4 for the COVID-19 era>"]
[null,null,null,"In the pre-COVID-19 era",null,null,null,null,{"$f":"I99*I105*I107*I111/10","v":1.5249000000000002E-2},"liter(s)",null,"<Factor 1 * Factor 2 * Factor 3 * Factor 4 for the pre-COVID-19 era>"]
[null,null,null,"Gap",null,null,null,null,{"$f":"Disinfectant_bus_per_trip-I115","v":0.137241},"liter(s)"]
[]
[null,null,"Notes. ","If you are not sure about certain numbers, try to overestimate them. "]
[null,null,"Sources.","Addressing disease mitigation in schools, day cares & universities with sanitizers and disinfectants",null,null,null,null,null,null,null,"https://www.youtube.com/watch?v=xhS-AhciAfM&feature=youtu.be"]
[null,null,null,"Guidance for cleaning and disinfecting: Public spaces, workplaces, businesses, schools and homes",null,null,null,null,null,null,null,"https://www.cdc.gov/coronavirus/2019-ncov/community/pdf/reopening_america_guidance.pdf"]
[null,null,null,"Cleaning and disinfection for community facilities",null,null,null,null,null,null,null,"https://www.cdc.gov/coronavirus/2019-ncov/community/organizations/cleaning-disinfection.html"]
[null,null,null,"Calculations and application of disinfection",null,null,null,null,null,null,null,"http://www.fao.org/3/al877e/al877e00.pdf"]
[null,null,null,"Disinfecting cost calculator",null,null,null,null,null,null,null,"https://blog.midwestind.com/disinfecting-cost-calculator/"]
[null,null,null,"What is the average size of a school bus?",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,"Calculator 3. How to calculate the quantity of antiseptic and liquid soap for handwashing"]
[]
[null,null,null,"3.1. Antiseptic for handwashing in school"]
[null,null,null,null,"Factor 1: Amount of antiseptic per handwash",null,null,null,3,"mL","<2-3 mL is recommended>"]
[null,null,null,null,"Factor 2: Frequency of using antiseptic"]
[null,null,null,null,"In the COVID-19 era",null,null,null,5,"times per day per person"]
[null,null,null,null,"In the pre-COVID-19 era",null,null,null,2,"times per day per person"]
[]
[null,null,null,null,"The quantity of antiseptic needed per person per day"]
[null,null,null,null,"In the COVID-19 era",null,null,null,{"$f":"I130*I132","v":15},"mL"]
[null,null,null,null,"In the pre-COVID-19 era",null,null,null,{"$f":"I130*I133","v":6},"mL"]
[null,null,null,null,"Gap",null,null,null,{"$f":"Antiseptic_per_person_per_day-I137","v":9},"mL"]
[]
[null,null,null,"3.2. Antiseptic for handwashing before boarding school buses"]
[null,null,null,null,"Factor 1: Amount of antiseptic per handwash",null,null,null,3,"mL","<2-3 mL is recommended>"]
[null,null,null,null,"Factor 2: Frequency of using antiseptic"]
[null,null,null,null,"In the COVID-19 era",null,null,null,2,"times per day per person"]
[null,null,null,null,"In the pre-COVID-19 era",null,null,null,0,"times per day per person"]
[]
[null,null,null,null,"The quantity of antiseptic needed per person per day"]
[null,null,null,null,"In the COVID-19 era",null,null,null,{"$f":"I141*I143","v":6},"mL","<Factor 1 * Factor 2 for the COVID-19 era>"]
[null,null,null,null,"In the pre-COVID-19 era",null,null,null,{"$f":"I141*I144","v":0},"mL","<Factor 1 * Factor 2 for the pre-COVID-19 era>"]
[null,null,null,null,"Gap",null,null,null,{"$f":"Antiseptic_per_person_per_day_bus-I148","v":6},"mL"]
[]
[null,null,null,"3.3. Liquid soap for handwashing in school"]
[null,null,null,null,"Factor 1: Amount of liquid soap per handwash",null,null,null,3,"mL","<A reasonable range is 1-3 mL>"]
[null,null,null,null,"Factor 2: Frequency of handwashing"]
[null,null,null,null,"In the COVID-19 era",null,null,null,5,"times per day per person"]
[null,null,null,null,"In the pre-COVID-19 era",null,null,null,2,"times per day per person"]
[]
[null,null,null,null,"The quantity of liquid soap needed per person per day"]
[null,null,null,null,"In the COVID-19 era",null,null,null,{"$f":"I152*I154","v":15},"mL","<Factor 1 * Factor 2 for the COVID-19 era>"]
[null,null,null,null,"In the pre-COVID-19 era",null,null,null,{"$f":"I152*I155","v":6},"mL","<Factor 1 * Factor 2 for the pre-COVID-19 era>"]
[null,null,null,null,"Gap",null,null,null,{"$f":"Liquid_soap_per_person_per_day-I159","v":9},"mL"]
[]
[null,null,"Sources.","Quantity of soap as a variable in handwashing",null,null,null,null,null,null,null,"https://pubmed.ncbi.nlm.nih.gov/3654132/"]
[null,null,null,"Hand coverage by alcohol-based handrub varies: Volume and hand size matter",null,null,null,null,null,null,null,"https://www.ajicjournal.org/article/S0196-6553(16)30690-3/abstract"]
[]
[]
[null,null,"Calculator 4. How to calculate the number of masks"]
[]
[null,null,"Advice on the use of masks for children in the community in the context of COVID-19"]
[null,null,"1) Children under five years should not be required to wear masks. \n2) For children between the ages of 6 to 11, the use of mask should be based on:\n    • Whether there is widespread transmission in the area\n    • Ability of the child to safely and appropriately use a mask\n    • Access to clean and replacement masks\n    • Adequate adult supervision\n    • Potential impact on learning and psychosocial development\n    • Specific settings and interactions with persons at higher risk\n3) Children 12 years and older should wear a mask under the same conditions as adults\n4) Teacher and support staff should wear masks when they cannot guarantee at least a 1-meter distance from others or if there is widespread transmission in the area."]
[]
[null,null,null,"4.1. Reusable masks"]
[]
[null,null,null,"Mask type","Eligible population",null,null,"# of people",null,"% present in school",null,"# of masks per person",null,"# of masks in total",null,"Price",null,"Cost"]
[null,null,null,"Small masks","Children aged 3-5 years old",null,null,null,null,{"$f":"pct_student_in_school","v":0.76666666666666672},null,null,null,{"$f":"H174*J174*L174","v":0},null,null,null,{"$f":"N174*P174","v":0}]
[null,null,null,"Medium masks","Children aged 6-11 years old",null,null,null,null,{"$f":"pct_student_in_school","v":0.76666666666666672},null,null,null,{"$f":"H175*J175*L175","v":0},null,null,null,{"$f":"N175*P175","v":0}]
[null,null,null,"Large masks","Students aged 12 years old and above",null,null,null,null,{"$f":"pct_student_in_school","v":0.76666666666666672},null,null,null,0,null,null,null,0]
[null,null,null,"Large masks","Teachers and staff",null,null,{"$f":"N_teacher_and_staff","v":256},null,{"$f":" pct_teacher_staff_in_school","v":0.71666666666666667},null,1,null,183.46666666666667,null,0.5,null,{"$f":"N177*P177","v":91.733333333333334}]
[null,null,null,"Clear masks","Teachers and staff who regularly interact with students who are deaf or hard of hearing, students learning to read, students with disabilities, and those who rely on lip reading as a part of learning",null,null,null,null,{"$f":" pct_teacher_staff_in_school","v":0.71666666666666667},null,null,null,0]
[]
[null,null,null,"Total",null,null,null,null,null,null,null,null,null,{"$f":"SUM(N174:N177)","v":183.46666666666667},null,{"$f":"(N174*P174+N175*P175+N176*P176+N177*P177+N178*P178)/SUM(N174:N178)","v":0.5},null,{"$f":"SUM(R174:R177)","v":91.733333333333334}]
[]
[]
[null,null,null,"4.2. Disposable masks"]
[]
[null,null,null,"Mask type","Eligible population",null,null,"# of people",null,"% present in school",null,"# of masks/person/day",null,"# of masks in total",null,"Price",null,"Cost"]
[null,null,null,"Small masks","Children aged 3-5 years old",null,null,null,null,{"$f":"pct_student_in_school","v":0.76666666666666672},null,null,null,{"$f":"H186*J186*L186* N_school_days","v":0},null,null,null,{"$f":"N186*P186","v":0}]
[null,null,null,"Medium masks","Children aged 6-11 years old",null,null,null,null,{"$f":"pct_student_in_school","v":0.76666666666666672},null,null,null,{"$f":"H187*J187*L187* N_school_days","v":0},null,null,null,{"$f":"N187*P187","v":0}]
[null,null,null,"Large masks","Students aged 12 years old and above",null,null,null,null,{"$f":"pct_student_in_school","v":0.76666666666666672},null,null,null,{"$f":"H188*J188*L188* N_school_days","v":0},null,null,null,0]
[null,null,null,"Large masks","Teachers and staff",null,null,{"$f":"N_teacher_and_staff * pct_teacher_staff_in_school","v":183.46666666666667},null,{"$f":"pct_teacher_staff_in_school","v":0.71666666666666667},null,1,null,{"$f":"H189*J189*L189* N_school_days","v":11833.6},null,null,null,{"$f":"N189*P189","v":0}]
[]
[null,null,null,"Total",null,null,null,null,null,null,null,null,null,{"$f":"SUM(N186:N189)","v":11833.6},null,{"$f":"(N186*P186+N187*P187+N188*P188+N189*P189)/SUM(N186:N189)","v":0},null,{"$f":"SUM(R186:R189)","v":0}]
[]
[null,null,"Sources. ","Advice on the use of masks for children in the community in the context of 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,"Calculator 5. How to calculate the number of automatic temperature sensors, oximeters and screening staff"]
[]
[null,null,null,"Rules of thumb to determine the quantity",null,null,null,null,null,null,null,"<Leave the cell blank if there is no min requirement>",null,null,null,"<Leave the cell blank if there is no max requirement>"]
[null,null,null,"Automatic temperature sensors",null,null,1,"piece(s) per ",150,"students, ","with a min of ",2,"per school and a max of",null,null,10,"per school"]
[null,null,null,"Oximeters",null,null,1,"piece(s) per ",150,"students, ","with a min of ",2,"per school and a max of ",null,null,10,"per school"]
[null,null,null,"Screening staff",null,null,1,"screener(s) per",150,"students, ","with a min of",null,"per school and a max of",null,null,null,"per school"]
[]
[null,null,null,"Number of students in a school",null,null,null,null,{"$f":"'Basic information about schools'!G55","v":200},"<The default setting is the average number of students in a school.>"]
[null,null,null,"Number of automatic temperature sensors needed in a school",null,null,null,null,{"$f":"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,"Number of oximeters needed in a school",null,null,null,null,{"$f":"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,"Number of screening staff needed in a school",null,null,null,null,{"$f":"IF(AND(P201 <>\"\", I$203/I201*G201>P201), P201, IF(AND(L201 <>\"\", I$203/I201*G201 <L201), L201, ROUNDUP(I$203/I201*G201,0)))","v":2}]
[]
[null,null,"Notes. The default setting for the rules of thumb to determine the quantity of automatic temperature sensors and oximeters is based on the school reopening strategy published by the Ministry of Education in Chile (https://sigamosaprendiendo.mineduc.cl/documentos/). "]
[]
[]
[null,null,"Calculator 6: How to estimate the cost of developing a remote learning platform"]
[]
[null,null,null,null,"Who are involved in the phase? ",null,null,"Roles and responsibilities",null,"# of people in the category",null,"# of working days devoted to this task",null,"Average daily rate",null,"Total cost"]
[null,null,"Personnel"]
[null,null,"Content development",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,{"$f":"J216*L216*N216","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Platform development",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,"Maintenance of the platform",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,"Hardware"]
[null,null,"Data storage"]
[null,null,"Other"]
[]
[null,null,"Total",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P215:P223)","v":0}]
[]
[]
[]
[]
[null,null,"Word count"]
[null,null,{"$f":"SUM(IF(LEN(TRIM(B1:S231))=0,0,LEN(TRIM(B1:S231))-LEN(SUBSTITUTE(B1:S231,\" \",\"\"))+1))","v":2127}]

{"sheet":"Prices of additional resources","index":7,"n_rows":101,"n_cols":14,"rows_kept":101,"cut":false,"hidden":false,"merged":[[75,2,76,2],[78,2,83,2],[84,2,86,2],[88,2,89,2],[90,2,95,2],[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]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"<Fill out the price for each resource>",null,null,"<If you are interested in knowing the economic cost, please fill out Columns J and K>"]
[null,null,"Checked measures","Additional resources","Quantity","Unit",{"$f":"\"Price \"&IF('Basic information about schools'!G99=\"\",\"\",\"(in \"&'Basic information about schools'!G99&\")\"&\"\")","v":"Price (in MRupee)"},{"$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 the fall sesmeter of 2021? (Yes/No)"},"If yes, what is the expected lifetime of this resource? (In months)","Economic cost"]
[null,null,"Pillar 1: Measures related to safe operations"]
[null,null,"Establish cleaning and disinfecting measures","Disinfectant",{"$f":"Disinfectant_per_school_per_day_gap * (N_school * pct_school_reopen) * N_school_days","v":580.5},"liter(s)",1,{"$f":"E9*G9","v":580.5},null,null,null,{"$f":"IF(J9 = \"Yes\", H9/K9 * (N_school_days/20), H9)","v":580.5},null,"P101"]
[null,null,null,"Empty containers for diluting cleaning and disinfection products",{"$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":7.166666666666667},"piece(s)",100,{"$f":"E10*G10","v":716.66666666666674},null,"Yes",24,134.375]
[null,null,null,"Electrostatic disinfectant sprayers",{"$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":7.166666666666667},"piece(s)",100,716.66666666666674,null,"Yes",36,89.583333333333343]
[null,null,null,"Mops, buckets and brushes",{"$f":"(N_mop_per_room  - N_mop_per_room_current) * N_school * pct_school_reopen * N_room_per_school","v":53.75},"set(s)",100,5375,null,"Yes",12,2015.625]
[null,null,null,"Soap bars",{"$f":"N_soap_bar_per_room * N_room_per_school * N_school * pct_school_reopen","v":107.5},"piece(s)",100,10750,null,null,null,10750]
[null,null,null,"Water",{"$f":"Water_multiplier * N_school * pct_school_reopen","v":28.666666666666668},"time(s) * school(s)",1,28.666666666666668,null,null,null,28.666666666666668]
[null,null,null,"Rubber gloves for cleaning staff",{"$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":14.333333333333334},"pair(s)",100,1433.3333333333335,null,"Yes",12,537.5]
[null,null,null,"Disposable gowns for cleaning staff",{"$f":"N_disposable_gown_per_cleaner_per_day * N_cleaner * pct_teacher_staff_in_school * N_school_days","v":1290},"set(s)",100,129000,null,null,null,129000]
[null,null,null,"Reusable gowns and caps for cleaning staff",{"$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":14.333333333333334},"set(s)",100,1433.3333333333335,null,"Yes",12,537.5]
[null,null,null,"Newly hired cleaning staff ",{"$f":"N_newly_hired_cleaner *  (N_school_days / N_school_days_per_academic_year)","v":0},"FTE(s)",1000,0,null,null,null,0]
[null,null,null,"Overtime payment for cleaning staff",{"$f":"N_overtime_hour_per_cleaner_per_day * N_cleaner * pct_teacher_staff_in_school * N_school_days","v":0},"hour(s)",1,0,null,null,null,0]
[null,null,"Provide personal protective equipment ","Reusable masks",{"$f":"N_reusable_mask","v":183.46666666666667},"piece(s)",1,183.46666666666667,null,"Yes",12,68.8,null,"P102"]
[null,null,null,"Disposable masks",{"$f":"N_disposable_mask","v":11833.6},"piece(s)",1,11833.6,null,null,null,11833.6]
[null,null,null,"Face shields",{"$f":"N_shield_per_teacher_staff * N_teacher_and_staff * pct_teacher_staff_in_school","v":183.46666666666667},"piece(s)",1,183.46666666666667,null,"Yes",12,68.8]
[null,null,"Provide hand hygiene materials","Alcohol-based antiseptic (at least 60 percent 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":1390.6079999999999},"liter(s)",1,1390.6079999999999,null,null,null,1390.6079999999999,null,"P103"]
[null,null,null,"Antiseptic dispensers",{"$f":"(N_antiseptic_dispenser_per_room - N_antiseptic_dispenser_per_room_current) * N_room_per_school * N_school * pct_school_reopen","v":107.5},"piece(s)",1,107.5,null,"No",null,107.5]
[null,null,null,"Liquid soap",{"$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":1390.6079999999999},"liter(s)",1,1390.6079999999999,null,null,null,1390.6079999999999]
[null,null,null,"Paper towels",{"$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":7725.6000000000013},"roll(s)",1,7725.6000000000013,null,null,null,7725.6000000000013]
[null,null,null,"EPA-registered disposable wipes",{"$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":7725.6000000000013},"package(s)",1,7725.6000000000013,null,null,null,7725.6000000000013]
[null,null,null,"No-touch/foot-pedal trash cans",{"$f":"(N_trash_can_per_room - N_trash_can_per_room_current) * N_room_per_school * N_school * pct_school_reopen","v":107.5},"piece(s)",1,107.5,null,"Yes",36,13.4375]
[null,null,null,"Hand dryer ",{"$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},"piece(s)",10,0,null,"Yes",60,0]
[null,null,"Provide on-site health screenings","Automatic temperature sensors ",{"$f":"N_temp_sensor_per_school * N_school * pct_school_reopen","v":14.333333333333334},"piece(s)",10,143.33333333333334,null,"Yes",36,17.916666666666668,null,"P104"]
[null,null,null,"Oximeter ",{"$f":"N_oximeter_per_school * N_school * pct_school_reopen","v":14.333333333333334},"piece(s)",10,143.33333333333334,null,"Yes",36,17.916666666666668]
[null,null,null,"Overtime payment for screening staff who are sufficiently trained in screening procedures",{"$f":"N_overtime_hour_per_screener_per_day * N_screening_staff_per_school * N_school * pct_school_reopen * N_school_days","v":1290},"hour(s)",20,25800,null,null,null,25800]
[null,null,null,"Protective masks and disposable gloves for screening staff",{"$f":"N_PPE_per_screener_per_day * N_screening_staff_per_school * N_school * pct_school_reopen * N_school_days","v":1290},"set(s)",1,1290,null,null,null,1290]
[null,null,null,"Newly hired full-time nurses",{"$f":"N_newly_hired_nurse* (N_school_days/N_school_days_per_academic_year)","v":1},"FTE(s)",1000,1000,null,null,null,1000]
[null,null,null,"Overtime payment for full-time nurses",{"$f":"N_overtime_hour_per_nurse_per_day * N_nurse * pct_teacher_staff_in_school * N_school_days","v":774},"hour(s)",20,15480,null,null,null,15480]
[null,null,null,"Emergency room/health clinic/isolation rooms",{"$f":"N_isolation_room_per_school * N_school * pct_school_reopen","v":14.333333333333334},"room(s)",1,14.333333333333334,null,null,null,14.333333333333334]
[null,null,"Monitor symptoms through parent-reported surveys","Overtime payment for technicians to i) set up the online health monitoring and reporting platform and ii) prepare and disseminate daily reporting",{"$f":"N_overtime_hour_per_technician_per_day_monitoring * N_technician * pct_teacher_staff_in_school * N_school_days","v":0},"hour(s)",20,0,null,null,null,0,null,"P105"]
[null,null,"Limit sharing objects","Teaching or learning materials that need to be purchased to limit sharing",{"$f":"N_set_TLM","v":100},"set(s)",1,100,null,"Yes",12,37.5,null,"P106"]
[null,null,"Ensure spaces, materials, and strategies to maintain physical and social distancing","Rental cost of community unused spaces",{"$f":"N_space_per_school_per_day * N_school * pct_school_reopen * N_school_days","v":0},"square meter(s) * day(s)",1,0,null,null,null,0,null,"P107"]
[null,null,"Establish physical barriers and guides","Physical barriers in the classrooms",{"$f":"N_physical_screen_per_student * N_student_per_school * (N_school * pct_school_reopen * pct_school_classroom_barrier)","v":1146.666666666667},"piece(s)",10,11466.66666666667,null,"Yes",24,2150.0000000000005,null,"P108"]
[null,null,null,"Physical barriers between restroom sinks",{"$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":68.800000000000011},"piece(s)",10,688.00000000000011,null,"Yes",24,129.00000000000003]
[null,null,null,"Tapes to mark signs on floors or sidewalks",{"$f":"N_tape_per_school * N_school * pct_school_reopen","v":71.666666666666671},"roll(s)",1,71.666666666666671,null,"No",null,71.666666666666671]
[null,null,null,"Posters or signs on walls",{"$f":"N_poster_per_school * N_school * pct_school_reopen","v":71.666666666666671},"poster(s)",10,716.66666666666674,null,"Yes",24,134.375]
[null,null,"Train students, teachers, staff, and parents on safe school operations","Overtime payment for teachers and staff to participate in the training on safe operations",{"$f":"N_overtime_hour_per_teacher_staff_safety_training * N_teacher_and_staff * pct_teacher_staff_in_school","v":183.46666666666667},"hour(s)",20,3669.3333333333335,null,null,null,3669.3333333333335,null,"P109"]
[null,null,"Maintain appropriate collaboration and coordination with local public health authorities. ","Gowns or white scrubs for school nurses",{"$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":11.166666666666668},"piece(s)",1,11.166666666666668,null,"Yes",24,2.0937500000000004,null,"P110"]
[null,null,null,"PPE needed to address suspected cases",{"$f":"N_PPE_per_case * N_suspected_cases_per_school_per_day * N_school * pct_school_reopen * N_school_days","v":1290},"set(s)",1,1290,null,null,null,1290]
[null,null,"Adapt transportation","Fog machines for buses",{"$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":3.5833333333333335},"piece(s)",1,3.5833333333333335,null,"Yes",36,0.44791666666666663,null,"P111"]
[null,null,null,"Disinfectant for buses",{"$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":1.13635548},"liter(s)",1,1.13635548,null,null,null,1.13635548]
[null,null,null,"Automatic temperature sensors to screen student temperature before boarding",{"$f":"N_temperature_sensor_per_bus * N_driver * pct_teacher_staff_in_school","v":7.166666666666667},"piece(s)",10,71.666666666666671,null,"Yes",36,8.9583333333333339]
[null,null,null,"Alcohol-based antiseptic (at least 70 percent alcohol)",{"$f":"Antiseptic_per_person_per_day_bus_gap * (N_student * pct_student_in_school * pct_student_bus) * N_school_days/1000","v":248.40000000000003},"liter(s)",1,248.40000000000003,null,null,null,248.40000000000003]
[null,null,null,"Antiseptic dispensers",{"$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":7.166666666666667},"piece(s)",1,7.166666666666667,null,"No",null,7.166666666666667]
[null,null,null,"Additional fuel ",{"$f":" N_school * pct_school_reopen * (pct_student_bus / pct_student_bus_pre_covid) * (1 / pct_bus_capacity - 1)","v":4.3},"time(s) * school(s)",1,4.3,null,null,null,4.3]
[null,null,"Adapt ventilation","Updating HVAC systems",{"$f":"N_school * pct_school_reopen * pct_school_HVAC_updating","v":0.71666666666666679},"school(s)",1000,716.66666666666674,null,"Yes",36,89.583333333333343,null,"P112"]
[null,null,"Reorganize lunch programs","Gowns, aprons and caps for food service workers",{"$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},"set(s)",1,{"$f":"E54*G54","v":0},null,"Yes",24,0,null,"P113"]
[null,null,null,"Disposable utensils",{"$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},"set(s)",1,0,null,null,null,0]
[null,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)",1,0,null,null,null,0]
[null,null,"Pillar 2: Measures to recover learning"]
[null,null,"Provide teacher professional development","Overtime payment for teachers to participate in the training sessions on pedagogy",{"$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":512},"hour(s)",20,10240,null,null,null,{"$f":"IF(J58 = \"Yes\", H58/K58 * (N_school_days/20), H58)","v":10240},null,"P201"]
[null,null,null,"Compensation for external trainers to provide the training sessions",{"$f":"N_external_trainer * N_session_per_trainer * N_hour_per_PD_session","v":1000},"hour(s)",30,30000,null,"Yes",12,11250]
[null,null,null,"Training materials",{"$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":105},"set(s)",10,1050,null,"Yes",12,393.75]
[null,null,"Continue flexible or partial remote learning approaches","Remote learning platforms",1,"set",{"$f":"Calculators!P229","v":0},0,null,"Yes",12,0,null,"P202"]
[null,null,null,"Compensation for internet access",{"$f":"(pct_teacher_internet * N_teacher + pct_student_internet * N_student) * ROUNDUP((N_school_days/20), 0)","v":5210},"person(s)*months",10,52100,null,null,null,52100]
[null,null,null,"Compensation for cell phone data plans",{"$f":"(pct_teacher_data_plan * N_teacher + pct_student_data_plan * N_student) * ROUNDUP((N_school_days/20), 0)","v":5210},"person(s)*months",10,52100,null,null,null,52100]
[null,null,null,"Desktop computers",{"$f":"N_desktop","v":100},"piece(s)",200,20000,null,"Yes",36,2500]
[null,null,null,"Laptops",{"$f":"N_laptop","v":200},"piece(s)",150,30000,null,"Yes",36,3750]
[null,null,null,"Tablets",{"$f":"N_tablet","v":200},"piece(s)",100,20000,null,"Yes",36,2500]
[null,null,null,"Phones",{"$f":"N_phone","v":200},"piece(s)",100,20000,null,"Yes",36,2500]
[null,null,null,"Newly hired technicians",{"$f":"N_newly_hired_technician * (N_school_days/N_school_days_per_academic_year)","v":0.5},"FTE(s)",1000,500,null,null,null,500]
[null,null,null,"Overtime payment for technicians or other staff to provide technical assistance",{"$f":"N_overtime_hour_per_technician_per_day_tech_support * N_technician * N_school_days","v":990},"hour(s)",20,19800,null,null,null,19800]
[null,null,"Conduct diagnosis assessments","License fee of the assessments",{"$f":"N_license_assessment","v":1},"license(s)",100,100,null,"Yes",12,37.5,null,"P203"]
[null,null,null,"Printing of the assessments (if delivered on paper)",{"$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":2913.3333333333335},"page(s)",1,2913.3333333333335,null,null,null,2913.3333333333335]
[null,null,null,"Compensation for external assessment specialists to develop the assessments and provide training",{"$f":"N_assessment_specialist * N_hour_per_assessment_specialist","v":100},"hour(s)",50,5000,null,"Yes",12,1875]
[null,null,"Increase intensity and differentiation (personalized learning)","License fees for the remedial or accelerated programs",{"$f":"N_license_personalized_learning_program","v":1},"license(s)",500,500,null,"Yes",12,187.5,null,"P204"]
[null,null,null,"Payment for teaching aids to provide personalized learning in the format of tutoring",{"$f":"N_hour_teaching_aid","v":204.44444444444446},"hour(s)",20,{"$f":"E74*G74","v":4088.8888888888891},null,null,null,4088.8888888888891]
[null,null,"Extend schedules","Overtime payment for teachers to provide instructions",{"$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":18060},"hour(s)",20,361200,null,null,null,361200,null,"P205"]
[null,null,"Hire new teachers, reorganize the working shifts or extend the working hours of teachers","Newly hired teachers to ensure smaller class size and substitute sick colleagues",{"$f":" N_newly_hired_teacher * (N_school_days / N_school_days_per_academic_year)","v":2.5},"FTE(s)",1000,2500,null,null,null,2500,null,"P206"]
[null,null,null,"Overtime payment for current teachers to substitute sick colleagues",{"$f":"N_hour_substitute * pct_hour_substitute_by_current_teacher","v":80},"hour(s)",20,1600,null,null,null,1600]
[null,null,"Pillar 3: Measures to support emotional wellbeing and recovery",null,null,null,null,0]
[null,null,"Provide dedicated psychosocial support and counselling","Newly hired counselors",{"$f":" N_newly_hired_counselor * (N_school_days / N_school_days_per_academic_year)","v":0.5},"FTE(s)",2000,1000,null,null,null,{"$f":"IF(J79 = \"Yes\", H79/K79 * (N_school_days/20), H79)","v":1000},null,"P301"]
[null,null,null,"Overtime payment for counselors",{"$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},"hour(s)",30,0,null,null,null,0]
[null,null,null,"Newly hired social workers",{"$f":" N_newly_hired_social_worker * (N_school_days / N_school_days_per_academic_year)","v":0.5},"FTE(s)",2000,1000,null,null,null,1000]
[null,null,null,"Overtime payment for social workers",{"$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},"hour(s)",30,0,null,null,null,0]
[null,null,null,"Newly hired psychologists",{"$f":" N_newly_hired_psychologist * (N_school_days / N_school_days_per_academic_year)","v":0.5},"FTE(s)",2000,1000,null,null,null,1000]
[null,null,null,"Overtime payment for psychologists",{"$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},"hour(s)",30,0,null,null,null,0]
[null,null,"Adopt social and emotional learning (SEL) programs","Overtime payment for teachers to participate in the training sessions on SEL ",{"$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":15.05},"hour(s)",20,301,null,null,null,301,null,"P302"]
[null,null,null,"Overtime payment for teachers to promote SEL",{"$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":1354.5},"hour(s)",30,40635,null,null,null,40635]
[null,null,null,"License fees for SEL programs adopted",{"$f":"N_license_SEL","v":4},"license(s)",2000,8000,null,"Yes",12,3000]
[null,null,"Pillar 4: Measures to reach the most marginalized"]
[null,null,"Provide adequate supports for recovery needs, especially for disadvantaged and vulnerable students","Special or adapted protective equipment",{"$f":"N_adapted_PPE_per_school * N_school * pct_school_reopen","v":71.666666666666671},"set(s)",10,716.66666666666674,null,"No",null,{"$f":"IF(J89 = \"Yes\", H89/K89 * (N_school_days/20), H89)","v":716.66666666666674},null,"P401"]
[null,null,null,"<Please specify other resources based on the support provided>",null,null,null,0,null,null,null,0]
[null,null,"Conduct reenrollment campaigns and wraparound supports to prevent dropouts","Staff time to design and implement the enrollment campaigns",{"$f":"IF(reenrollment_campaign = \"Reopened schools\", N_hour_per_mobilizer * N_mobilizer * pct_teacher_staff_in_school, N_hour_per_mobilizer * N_mobilizer)","v":71.666666666666671},"hour(s)",30,{"$f":"E91*G91","v":2150},null,"Yes",12,806.25,null,"P402"]
[null,null,null,"Transportation cost for the campaigns",{"$f":"N_enrollment_campaign_trips","v":120},"trip(s)",200,24000,null,null,null,24000]
[null,null,null,"Feeding programs",{"$f":"N_feeding_program_beneficiery","v":100},"beneficiary/beneficiaries",500,50000,null,null,null,50000]
[null,null,null,"Provision of school uniforms",{"$f":"N_school_uniforms","v":100},"set(s) of uniform",300,30000,null,"Yes",12,11250]
[null,null,null,"Removing or waiving school fees",{"$f":"N_school_fee_waiver","v":100},"fee waiver(s)",500,50000,null,null,null,50000]
[null,null,null,"<Please specify other resources based on the support provided>",null,null,null,0,null,null,null,0]
[null,null,"Monitor and plan for absenteeism","Overtime payment for staff to monitor and plan for absenteeism",{"$f":"N_staff_member_absenteeism_monitoring * N_overtime_hour_per_person_per_day_monitor_absenteeism * N_school * pct_school_reopen","v":14.333333333333334},"hour(s)",20,286.66666666666669,null,null,null,286.66666666666669,null,"P403"]
[null,null,null,null,null,null,1]
[]
[null,null,"Word count"]
[null,null,{"$f":"SUM(IF(LEN(TRIM(B1:I98))=0,0,LEN(TRIM(B1:I98))-LEN(SUBSTITUTE(B1:I98,\" \",\"\"))+1))","v":1018}]

{"sheet":"Funding","index":8,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,"<Specify funding available from both domestic and external sources and the % of funding subject to reallocation>"]
[]
[null,null,"Funding source","Amount available","% subject to reallocation","Total funding"]
[null,null,"Savings from the cancellation of field trips, events, and extracurricular activities",1000,1,{"$f":"D8*E8","v":1000}]
[null,null,"Savings from previous school closure",1000,1,1000]
[null,null,"External funding",160100,1,160100]
[null,null,"COVID-19 relief package",280000,1,280000]
[null,null,"Donation",1000,1,1000]
[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]
[]
[]
[null,null,"Word count"]
[null,null,{"$f":"SUM(IF(LEN(TRIM(B1:G20))=0,0,LEN(TRIM(B1:G20))-LEN(SUBSTITUTE(B1:G20,\" \",\"\"))+1))","v":71}]

{"sheet":"Report","index":9,"n_rows":58,"n_cols":12,"rows_kept":58,"cut":false,"hidden":false,"merged":[[53,2,53,18],[39,4,48,6],[55,2,55,18],[31,5,32,6],[31,4,32,4],[34,5,35,6],[34,4,35,4]]}
[]
[]
[]
[]
[]
[]
[null,null,"How much does it cost to reopen schools safely?"]
[]
[null,null,null,null,"Context",null,null,null,{"$f":"\"Cost, funding and financial gap to reopen schools safely during \"&LOWER('Basic information about schools'!D43)&\"\"","v":"Cost, funding and financial gap to reopen schools safely during the fall sesmeter of 2021"}]
[null,null,null,null,{"$f":"CHOOSE(Output!C3, Output!C4, Output!C5, Output!C6, Output!C7, Output!C8)","v":"Malgudi, India"},null,null,null,null,null,null,{"$f":"\"(Expressed in \"&'Basic information about schools'!G99&\" in \"&'Basic information about schools'!G101&\" values)\"","v":"(Expressed in MRupee in 2021 values)"}]
[]
[]
[null,null,null,null,"Education levels"]
[null,null,null,{"$f":"_xlfn.ANCHORARRAY(Output!O3)","v":"Pre-primary education (Ages 3-5)"},{"$f":"IF(Output!K3 = TRUE, Output!M3, \"\")","v":"Pre-primary education (Ages 3-5)"}]
[null,null,null,"Primary education (K-3)",{"$f":"IF(Output!K4 = TRUE, Output!M4, \"\")","v":"Primary education (K-3)"}]
[null,null,null,null,{"$f":"IF(Output!K5 = TRUE, Output!M5, \"\")","v":""}]
[null,null,null,null,{"$f":"IF(Output!K6 = TRUE, Output!M6, \"\")","v":""}]
[null,null,null,null,{"$f":"IF(Output!K7 = TRUE, Output!M7, \"\")","v":""}]
[]
[]
[null,null,null,null,"Time period"]
[null,null,null,null,{"$f":"'Basic information about schools'!D43","v":"The Fall sesmeter of 2021"}]
[null,null,null,null,{"$f":"\"(\"&N_school_days&\" school days in total)\"","v":"(90 school days in total)"},null,null,null,{"$f":"\"The financial cost of the additional resources needed to reopen schools safely by pillar\"","v":"The financial cost of the additional resources needed to reopen schools safely by pillar"}]
[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 MRupee in 2021 values)"}]
[]
[null,null,null,null,"Population to serve"]
[null,null,null,null,{"$f":"N_school","v":10},"schools"]
[null,null,null,null,{"$f":"N_student","v":2000},"students"]
[]
[]
[null,null,null,null,"School reopening status"]
[null,null,null,null,{"$f":"\"\"&ROUND(pct_school_reopen, 2) *100&\"%\"","v":"72%"},"of all schools provide in-person classes"]
[]
[]
[null,null,null,null,{"$f":"\"\"&ROUND(pct_student_in_school, 2) *100&\"%\"","v":"77%"},"% all students attend in-person classes"]
[]
[null,null,null,null,null,null,null,null,{"$f":"\"The economic cost of the additional resources needed to reopen schools safely by pillar\"","v":"The economic cost of the additional resources needed to reopen schools safely by pillar"}]
[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 MRupee in 2021 values)"}]
[null,null,null,null,"Notes"]
[null,null,null,null,"1) The baseline is the budget for the same student population in the pre-COVID-19 era. \n2)Financial cost captures the resources that are paid for. Economic cost takes into account the fact that some resources can be used beyond this time period of interest. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"1. More explanation on financial cost and economic cost\nSome resources are purchased during the time period of interest, but can still be used beyond this time period, such as laptops. The financial cost would be the total cost of the purchased laptops without any amortization. If the expected lifetime of these laptops is 3 years, the economic cost of these laptops for one year of use is approximately one third of the financial cost. To estimate economic cost, please fill out Columns J and K in the spreadsheet of \"Prices of additional resources\"."]
[]
[null,null,"2. How to print the report?\nStep 1: Select the area to print\n             Select Cell B7, then with the left mouse button pressed, drag over to Cell T51. \nStep 2: Click File > Print, or press CTRL + P.\nStep 3: Click the Print button and adjust the settings. \n             a) Change to \"Landscape orientations\". \n             b) Select \"Fit sheet on one page\". \n             c) Adjust the margins based on your needs. \n"]
[null,null,"Word count"]
[null,null,{"$f":"SUM(IF(LEN(TRIM(B1:T56))=0,0,LEN(TRIM(B1:T56))-LEN(SUBSTITUTE(B1:T56,\" \",\"\"))+1))","v":333}]

{"sheet":"Items to purchase","index":10,"n_rows":51,"n_cols":7,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,"<A list of materials and equipment that need to be purchased is generated automatically. The quantity represents the total needs, NOT the additional resources needed>"]
[null,null,"Items to purchase (materials and equipment)","Quantity","Unit"]
[null,null,"Disinfectant",{"$f":"Disinfectant_per_school_per_day * (N_school * pct_school_reopen) * N_school_days","v":725.625},"liter(s)",null,"p101"]
[null,null,"Empty containers for diluting cleaning and disinfection products",{"$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":7.166666666666667},"piece(s)"]
[null,null,"Electrostatic disinfectant sprayers",{"$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":7.166666666666667},"piece(s)"]
[null,null,"Mops, buckets and brushes",{"$f":"(N_mop_per_room  - N_mop_per_room_current) * N_school * N_room_per_school * pct_teacher_staff_in_school","v":53.75},"set(s)"]
[null,null,"Soap bars",{"$f":"N_soap_bar_per_room * N_room_per_school * N_school * pct_school_reopen","v":107.5},"piece(s)"]
[null,null,"Rubber gloves for cleaning staff",{"$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":14.333333333333334},"pair(s)"]
[null,null,"Disposable gowns for cleaning staff",{"$f":"N_disposable_gown_per_cleaner_per_day * N_cleaner * pct_school_reopen * N_school_days","v":1290},"set(s)"]
[null,null,"Reusable gowns and caps for cleaning staff",{"$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":14.333333333333334},"set(s)"]
[null,null,"Reusable masks",{"$f":"N_reusable_mask","v":183.46666666666667},"piece(s)",null,"P102"]
[null,null,"Disposable masks",{"$f":"N_disposable_mask","v":11833.6},"piece(s)"]
[null,null,"Face shields",{"$f":"N_shield_per_teacher_staff * N_teacher_and_staff * pct_teacher_staff_in_school","v":183.46666666666667},"piece(s)"]
[null,null,"Alcohol-based antiseptic (at least 60 percent 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":2317.6800000000003},"liter(s)",null,"P103"]
[null,null,"Antiseptic dispensers",{"$f":"(N_antiseptic_dispenser_per_room - N_antiseptic_dispenser_per_room_current) * N_room_per_school * N_school * pct_school_reopen","v":107.5},"piece(s)"]
[null,null,"Liquid soap",{"$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":2317.6800000000003},"liter(s)"]
[null,null,"Paper towels",{"$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":7725.6000000000013},"roll(s)"]
[null,null,"EPA-registered disposable wipes",{"$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":7725.6000000000013},"package(s)"]
[null,null,"No-touch/foot-pedal trash cans",{"$f":"(N_trash_can_per_room - N_trash_can_per_room_current) * N_room_per_school * N_school * pct_school_reopen","v":107.5},"piece(s)"]
[null,null,"Hand dryer ",{"$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},"piece(s)"]
[null,null,"Automatic temperature sensors ",{"$f":"N_temp_sensor_per_school * N_school * pct_school_reopen","v":14.333333333333334},"piece(s)",null,"P104"]
[null,null,"Oximeter ",{"$f":"N_oximeter_per_school * N_school * pct_school_reopen","v":14.333333333333334},"piece(s)"]
[null,null,"Protective masks and disposable gloves for screening staff",{"$f":"N_PPE_per_screener_per_day * N_screening_staff_per_school * N_school * pct_school_reopen * N_school_days","v":1290},"set(s)"]
[null,null,"Physical barriers in the classrooms",{"$f":"N_physical_screen_per_student * N_student_per_school * (N_school * pct_school_reopen * pct_school_classroom_barrier)","v":1146.666666666667},"piece(s)",null,"P108"]
[null,null,"Physical barriers between restroom sinks",{"$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":68.800000000000011},"piece(s)"]
[null,null,"Tapes to mark signs on floors or sidewalks",{"$f":"N_tape_per_school * N_school * pct_school_reopen","v":71.666666666666671},"roll(s)"]
[null,null,"Posters or signs on walls",{"$f":"N_poster_per_school * N_school * pct_school_reopen","v":71.666666666666671},"poster(s)"]
[null,null,"Gowns or white scrubs for school nurses",{"$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":12.6},"piece(s)",null,"P110"]
[null,null,"PPE needed to address suspected cases",{"$f":"N_PPE_per_case * N_suspected_cases_per_school_per_day * N_school * pct_school_reopen * N_school_days","v":1290},"set(s)"]
[null,null,"Fog machines for buses",{"$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":3.5833333333333335},"piece(s)",null,"P111"]
[null,null,"Disinfectant for buses",{"$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":1.2626172000000002},"liter(s)"]
[null,null,"Automatic temperature sensors to screen student temperature before boarding",{"$f":"N_temperature_sensor_per_bus * N_driver * pct_teacher_staff_in_school","v":7.166666666666667},"piece(s)"]
[null,null,"Alcohol-based antiseptic (at least 70 percent alcohol)",{"$f":"Antiseptic_per_person_per_day_bus * (N_student * pct_student_in_school * pct_student_bus) * N_school_days/1000","v":248.40000000000003},"liter(s)"]
[null,null,"Antiseptic dispensers",{"$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":7.166666666666667},"piece(s)"]
[null,null,"Gowns, aprons and caps for food service workers",{"$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},"set(s)",null,"P113"]
[null,null,"Disposable utensils",{"$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},"set(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,"Laptops",{"$f":"N_laptop","v":200},"piece(s)"]
[null,null,"Tablets",{"$f":"N_tablet","v":200},"piece(s)"]
[null,null,"Phones",{"$f":"N_phone","v":200},"piece(s)"]
[null,null,"Special or adapted protective equipment",{"$f":"N_adapted_PPE_per_school * N_school * pct_school_reopen","v":71.666666666666671},"set(s)",null,"P401"]
[]
[]
[null,null,"Word count"]
[null,null,{"$f":"SUM(IF(LEN(TRIM(B1:H48))=0,0,LEN(TRIM(B1:H48))-LEN(SUBSTITUTE(B1:H48,\" \",\"\"))+1))","v":280}]

{"sheet":"Data prep","index":11,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[]
["Financial cost"]
[null,"Total additional cost"]
["Safe operations",{"$f":"_xlfn.AGGREGATE(9, 5, 'Prices of additional resources'!H9:H56)","v":243619.53568881337}]
["Recovering learning",{"$f":"_xlfn.AGGREGATE(9, 5, 'Prices of additional resources'!H58:H77)","v":633692.22222222225}]
["Supporting emotional wellbeing",{"$f":"_xlfn.AGGREGATE(9, 5, 'Prices of additional resources'!H79:H87)","v":51936}]
["Reaching the marginalized",{"$f":"_xlfn.AGGREGATE(9, 5, 'Prices of additional resources'!H89:H97)","v":157153.33333333334}]
["Total",{"$f":"SUM(B4:B7)","v":1086401.0912443688}]
[]
[null,"Total"]
["Additional cost",{"$f":"B8","v":1086401.0912443688}]
["Additional funding available",{"$f":"_xlfn.AGGREGATE(9, 5, Funding!F8:F19)","v":443100}]
["Funding gap",{"$f":"B11-B12","v":643301.09124436881}]
[]
["Figure 1"]
[null,"Bottom block","Top block","Horizontal lines"]
["Additional cost",{"$f":"B11","v":1086401.0912443688},{"$f":"B17-B11","v":0},{"$f":"B13","v":643301.09124436881}]
["Additional funding available",{"$f":"B13","v":643301.09124436881},{"$f":"B12","v":443100},{"$f":"D17","v":643301.09124436881}]
["Funding gap",{"$f":"B13","v":643301.09124436881},{"$f":"B12","v":443100},{"$f":"D17","v":643301.09124436881}]
[]
["Figure 2 & Figure 3"]
[null,"Additional cost","%"]
[{"$f":"A4","v":"Safe operations"},{"$f":"B4","v":243619.53568881337},{"$f":"B23/SUM(B$23:B$26)","v":0.22424456091973402}]
[{"$f":"A5","v":"Recovering learning"},633692.22222222225,{"$f":"B24/SUM(B$23:B$26)","v":0.58329490584033583}]
["Supporting emotional wellbeing",51936,4.7805548446672001E-2]
["Reaching the marginalized",157153.33333333334,0.14465498479325825]
[]
["Economic cost"]
["Figure 4 & Figure 5"]
[null,"Additional cost"]
[{"$f":"A4","v":"Safe operations"},{"$f":"_xlfn.AGGREGATE(9, 5, 'Prices of additional resources'!L9:L56)","v":225462.43152214665}]
[{"$f":"A5","v":"Recovering learning"},{"$f":"_xlfn.AGGREGATE(9, 5, 'Prices of additional resources'!L58:L77)","v":532035.97222222225}]
["Supporting emotional wellbeing",{"$f":"_xlfn.AGGREGATE(9, 5, 'Prices of additional resources'!L79:L87)","v":46936}]
["Reaching the marginalized",{"$f":"_xlfn.AGGREGATE(9, 5, 'Prices of additional resources'!L89:L97)","v":137059.58333333334}]
[]
[]
["Word count"]
[{"$f":"SUM(IF(LEN(TRIM(A4:A19))=0,0,LEN(TRIM(A4:A19))-LEN(SUBSTITUTE(A4:A19,\" \",\"\"))+1))","v":27}]

{"sheet":"Output","index":12,"n_rows":16,"n_cols":15,"rows_kept":16,"cut":false,"hidden":false,"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},"Pre-primary education",{"$f":"_xlfn.CONCAT(L3, \" (\", 'Basic information about schools'!G35, \")\")","v":"Pre-primary education (Ages 3-5)"},null,{"$f":"_xlfn._xlws.FILTER(M3:M7, K3:K7 = TRUE, \"\")","v":"Pre-primary education (Ages 3-5)"}]
[1,"All schools, regardless of their reopening status",{"$f":"'Basic information about schools'!F9","v":"India"},"pre-primary education,","primary education,","lower secondary education,","upper secondary education,","tertiary education",null,null,{"$f":"E3","v":true},"Primary education",{"$f":"_xlfn.CONCAT(L4, \" (\", 'Basic information about schools'!G36, \")\")","v":"Primary education (K-3)"},null,"Primary education (K-3)"]
[2,"Reopened schools",{"$f":"_xlfn.CONCAT('Basic information about schools'!G27, \", \", 'Basic information about schools'!F9)","v":"Malgudi, India"},null,null,null,null,null,null,null,{"$f":"F3","v":false},"Lower secondary education",{"$f":"_xlfn.CONCAT(L5, \" (\", 'Basic information about schools'!G37, \")\")","v":"Lower secondary education ()"}]
[3,null,{"$f":"_xlfn.CONCAT('Basic information about schools'!G28, \", \", 'Basic information about schools'!F9)","v":", India"},null,null,null,null,null,null,null,{"$f":"G3","v":false},"Upper secondary education",{"$f":"_xlfn.CONCAT(L6, \" (\", 'Basic information about schools'!G38, \")\")","v":"Upper secondary education ()"}]
[4,null,{"$f":"_xlfn.CONCAT('Basic information about schools'!G29, \", \", 'Basic information about schools'!F9)","v":", India"},null,null,null,null,null,null,null,{"$f":"H3","v":false},"Tertiary education",{"$f":"_xlfn.CONCAT(L7, \" (\", 'Basic information about schools'!G39, \")\")","v":"Tertiary education ()"}]
[5,null,{"$f":"_xlfn.CONCAT('Basic information about schools'!G30, \", \", 'Basic information about schools'!F9)","v":", India"}]
[6]
[7]
[8]
[9]
[10]
[]
["Word count"]
[{"$f":"SUM(IF(LEN(TRIM(B3:L7))=0,0,LEN(TRIM(B3:L7))-LEN(SUBSTITUTE(B3:L7,\" \",\"\"))+1))","v":52}]

{"sheet":"List_Economy","index":13,"n_rows":287,"n_cols":11,"rows_kept":287,"cut":false,"hidden":false,"merged":[[274,0,274,8],[278,0,278,8],[280,0,280,8]]}
["World Bank list of economies (June 2020)"]
[]
["(Bold indicates a change of classification)",null,null," "]
[]
["x","x","Economy","Code","X","Region","Income group","Lending category","Other",null,"Data prep"]
["x","x","x","x","x","x","x","x","x"]
[1,null,"Afghanistan","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":"India"}]
[2,null,"Albania","ALB",null,"Europe & Central Asia","Upper middle income","IBRD",""]
[3,null,"Algeria","DZA",null,"Middle East & North Africa","Lower middle income","IBRD",""]
[4,null,"American Samoa","ASM",null,"East Asia & Pacific","Upper middle income","..",""]
[5,null,"Andorra","AND",null,"Europe & Central Asia","High income","..",""]
[6,null,"Angola","AGO",null,"Sub-Saharan Africa","Lower middle income","IBRD"]
[7,null,"Antigua and Barbuda","ATG",null,"Latin America & Caribbean","High income","IBRD",""]
[8,null,"Argentina","ARG",null,"Latin America & Caribbean","Upper middle income","IBRD",""]
[9,null,"Armenia","ARM",null,"Europe & Central Asia","Upper middle income","IBRD",""]
[10,null,"Aruba","ABW",null,"Latin America & Caribbean","High income","..",""]
[11,null,"Australia","AUS",null,"East Asia & Pacific","High income","..",""]
[12,null,"Austria","AUT",null,"Europe & Central Asia","High income","..","EMU"]
[13,null,"Azerbaijan","AZE",null,"Europe & Central Asia","Upper middle income","IBRD",""]
[14,null,"Bahamas, The","BHS",null,"Latin America & Caribbean","High income","..",""]
[15,null,"Bahrain","BHR",null,"Middle East & North Africa","High income",".."]
[16,null,"Bangladesh","BGD",null,"South Asia","Lower middle income","IDA",""]
[17,null,"Barbados","BRB",null,"Latin America & Caribbean","High income","..",""]
[18,null,"Belarus","BLR",null,"Europe & Central Asia","Upper middle income","IBRD",""]
[19,null,"Belgium","BEL",null,"Europe & Central Asia","High income","..","EMU"]
[20,null,"Belize","BLZ",null,"Latin America & Caribbean","Upper middle income","IBRD",""]
[21,null,"Benin","BEN",null,"Sub-Saharan Africa","Lower middle income","IDA","HIPC"]
[22,null,"Bermuda","BMU",null,"North America","High income","..",""]
[23,null,"Bhutan","BTN",null,"South Asia","Lower middle income","IDA",""]
[24,null,"Bolivia","BOL",null,"Latin America & Caribbean","Lower middle income","IBRD","HIPC"]
[25,null,"Bosnia and Herzegovina","BIH",null,"Europe & Central Asia","Upper middle income","IBRD",""]
[26,null,"Botswana","BWA",null,"Sub-Saharan Africa","Upper middle income","IBRD",""]
[27,null,"Brazil","BRA",null,"Latin America & Caribbean","Upper middle income","IBRD",""]
[28,null,"British Virgin Islands","VGB",null,"Latin America & Caribbean","High income",".."]
[29,null,"Brunei Darussalam","BRN",null,"East Asia & Pacific","High income","..",""]
[30,null,"Bulgaria","BGR",null,"Europe & Central Asia","Upper middle income","IBRD",""]
[31,null,"Burkina Faso","BFA",null,"Sub-Saharan Africa","Low income","IDA","HIPC"]
[32,null,"Burundi","BDI",null,"Sub-Saharan Africa","Low income","IDA","HIPC"]
[33,null,"Cabo Verde","CPV",null,"Sub-Saharan Africa","Lower middle income","Blend",""]
[34,null,"Cambodia","KHM",null,"East Asia & Pacific","Lower middle income","IDA",""]
[35,null,"Cameroon","CMR",null,"Sub-Saharan Africa","Lower middle income","Blend","HIPC"]
[36,null,"Canada","CAN",null,"North America","High income","..",""]
[37,null,"Cayman Islands","CYM",null,"Latin America & Caribbean","High income","..",""]
[38,null,"Central African Republic","CAF",null,"Sub-Saharan Africa","Low income","IDA","HIPC"]
[39,null,"Chad","TCD",null,"Sub-Saharan Africa","Low income","IDA","HIPC"]
[40,null,"Channel Islands","CHI",null,"Europe & Central Asia","High income","..",""]
[41,null,"Chile","CHL",null,"Latin America & Caribbean","High income","IBRD",""]
[42,null,"China","CHN",null,"East Asia & Pacific","Upper middle income","IBRD",""]
[43,null,"Colombia","COL",null,"Latin America & Caribbean","Upper middle income","IBRD",""]
[44,null,"Comoros","COM",null,"Sub-Saharan Africa","Lower middle income","IDA","HIPC"]
[45,null,"Congo, Dem. Rep.","COD",null,"Sub-Saharan Africa","Low income","IDA","HIPC"]
[46,null,"Congo, Rep.","COG",null,"Sub-Saharan Africa","Lower middle income","Blend","HIPC"]
[47,null,"Costa Rica","CRI",null,"Latin America & Caribbean","Upper middle income","IBRD",""]
[48,null,"Côte d'Ivoire","CIV",null,"Sub-Saharan Africa","Lower middle income","IDA","HIPC"]
[49,null,"Croatia","HRV",null,"Europe & Central Asia","High income","IBRD",""]
[50,null,"Cuba","CUB",null,"Latin America & Caribbean","Upper middle income","..",""]
[51,null,"Curaçao","CUW",null,"Latin America & Caribbean","High income",".."]
[52,null,"Cyprus","CYP",null,"Europe & Central Asia","High income","..","EMU"]
[53,null,"Czech Republic","CZE",null,"Europe & Central Asia","High income","..",""]
[54,null,"Denmark","DNK",null,"Europe & Central Asia","High income","..",""]
[55,null,"Djibouti","DJI",null,"Middle East & North Africa","Lower middle income","IDA",""]
[56,null,"Dominica","DMA",null,"Latin America & Caribbean","Upper middle income","Blend",""]
[57,null,"Dominican Republic","DOM",null,"Latin America & Caribbean","Upper middle income","IBRD",""]
[58,null,"Ecuador","ECU",null,"Latin America & Caribbean","Upper middle income","IBRD",""]
[59,null,"Egypt, Arab Rep.","EGY",null,"Middle East & North Africa","Lower middle income","IBRD",""]
[60,null,"El Salvador","SLV",null,"Latin America & Caribbean","Lower middle income","IBRD",""]
[61,null,"Equatorial Guinea","GNQ",null,"Sub-Saharan Africa","Upper middle income","IBRD",""]
[62,null,"Eritrea","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,"Ethiopia","ETH",null,"Sub-Saharan Africa","Low income","IDA","HIPC"]
[66,null,"Faroe Islands","FRO",null,"Europe & Central Asia","High income","..",""]
[67,null,"Fiji","FJI",null,"East Asia & Pacific","Upper middle income","Blend",""]
[68,null,"Finland","FIN",null,"Europe & Central Asia","High income","..","EMU"]
[69,null,"France","FRA",null,"Europe & Central Asia","High income","..","EMU"]
[70,null,"French Polynesia","PYF",null,"East Asia & Pacific","High income","..",""]
[71,null,"Gabon","GAB",null,"Sub-Saharan Africa","Upper middle income","IBRD",""]
[72,null,"Gambia, The","GMB",null,"Sub-Saharan Africa","Low income","IDA","HIPC"]
[73,null,"Georgia","GEO",null,"Europe & Central Asia","Upper middle income","IBRD",""]
[74,null,"Germany","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,"Greece","GRC",null,"Europe & Central Asia","High income","..","EMU"]
[78,null,"Greenland","GRL",null,"Europe & Central Asia","High income","..",""]
[79,null,"Grenada","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-Bissau","GNB",null,"Sub-Saharan Africa","Low income","IDA","HIPC"]
[84,null,"Guyana","GUY",null,"Latin America & Caribbean","Upper middle income","IDA","HIPC"]
[85,null,"Haiti","HTI",null,"Latin America & Caribbean","Low income","IDA","HIPC"]
[86,null,"Honduras","HND",null,"Latin America & Caribbean","Lower middle income","IDA","HIPC"]
[87,null,"Hong Kong SAR, China","HKG",null,"East Asia & Pacific","High income","..",""]
[88,null,"Hungary","HUN",null,"Europe & Central Asia","High income","..",""]
[89,null,"Iceland","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,"Iran, Islamic Rep.","IRN",null,"Middle East & North Africa","Upper middle income","IBRD",""]
[93,null,"Iraq","IRQ",null,"Middle East & North Africa","Upper middle income","IBRD",""]
[94,null,"Ireland","IRL",null,"Europe & Central Asia","High income","..","EMU"]
[95,null,"Isle of Man","IMN",null,"Europe & Central Asia","High income","..",""]
[96,null,"Israel","ISR",null,"Middle East & North Africa","High income","..",""]
[97,null,"Italy","ITA",null,"Europe & Central Asia","High income","..","EMU"]
[98,null,"Jamaica","JAM",null,"Latin America & Caribbean","Upper middle income","IBRD",""]
[99,null,"Japan","JPN",null,"East Asia & Pacific","High income","..",""]
[100,null,"Jordan","JOR",null,"Middle East & North Africa","Upper middle income","IBRD",""]
[101,null,"Kazakhstan","KAZ",null,"Europe & Central Asia","Upper middle income","IBRD",""]
[102,null,"Kenya","KEN",null,"Sub-Saharan Africa","Lower middle income","Blend"]
[103,null,"Kiribati","KIR",null,"East Asia & Pacific","Lower middle income","IDA",""]
[104,null,"Korea, Dem. People's Rep.","PRK",null,"East Asia & Pacific","Low income","..",""]
[105,null,"Korea, Rep.","KOR",null,"East Asia & Pacific","High income","..",""]
[106,null,"Kosovo","XKX",null,"Europe & Central Asia","Upper middle income","IDA"]
[107,null,"Kuwait","KWT",null,"Middle East & North Africa","High income","..",""]
[108,null,"Kyrgyz Republic","KGZ",null,"Europe & Central Asia","Lower middle income","IDA"]
[109,null,"Lao PDR","LAO",null,"East Asia & Pacific","Lower middle income","IDA"]
[110,null,"Latvia","LVA",null,"Europe & Central Asia","High income","..","EMU"]
[111,null,"Lebanon","LBN",null,"Middle East & North Africa","Upper middle income","IBRD",""]
[112,null,"Lesotho","LSO",null,"Sub-Saharan Africa","Lower middle income","IDA",""]
[113,null,"Liberia","LBR",null,"Sub-Saharan Africa","Low income","IDA","HIPC"]
[114,null,"Libya","LBY",null,"Middle East & North Africa","Upper middle income","IBRD",""]
[115,null,"Liechtenstein","LIE",null,"Europe & Central Asia","High income","..",""]
[116,null,"Lithuania","LTU",null,"Europe & Central Asia","High income","..","EMU"]
[117,null,"Luxembourg","LUX",null,"Europe & Central Asia","High income","..","EMU"]
[118,null,"Macao SAR, China","MAC",null,"East Asia & Pacific","High income","..",""]
[119,null,"Madagascar","MDG",null,"Sub-Saharan Africa","Low income","IDA","HIPC"]
[120,null,"Malawi","MWI",null,"Sub-Saharan Africa","Low income","IDA","HIPC"]
[121,null,"Malaysia","MYS",null,"East Asia & Pacific","Upper middle income","IBRD",""]
[122,null,"Maldives","MDV",null,"South Asia","Upper middle income","IDA"]
[123,null,"Mali","MLI",null,"Sub-Saharan Africa","Low income","IDA","HIPC"]
[124,null,"Malta","MLT",null,"Middle East & North Africa","High income","..","EMU"]
[125,null,"Marshall Islands","MHL",null,"East Asia & Pacific","Upper middle income","IDA",""]
[126,null,"Mauritania","MRT",null,"Sub-Saharan Africa","Lower middle income","IDA","HIPC"]
[127,null,"Mauritius","MUS",null,"Sub-Saharan Africa","High income","IBRD",""]
[128,null,"Mexico","MEX",null,"Latin America & Caribbean","Upper middle income","IBRD",""]
[129,null,"Micronesia, Fed. Sts.","FSM",null,"East Asia & Pacific","Lower middle income","IDA",""]
[130,null,"Moldova","MDA",null,"Europe & Central Asia","Lower middle income","IBRD",""]
[131,null,"Monaco","MCO",null,"Europe & Central Asia","High income","..",""]
[132,null,"Mongolia","MNG",null,"East Asia & Pacific","Lower middle income","IBRD",""]
[133,null,"Montenegro","MNE",null,"Europe & Central Asia","Upper middle income","IBRD",""]
[134,null,"Morocco","MAR",null,"Middle East & North Africa","Lower middle income","IBRD",""]
[135,null,"Mozambique","MOZ",null,"Sub-Saharan Africa","Low income","IDA","HIPC"]
[136,null,"Myanmar","MMR",null,"East Asia & Pacific","Lower middle income","IDA"]
[137,null,"Namibia","NAM",null,"Sub-Saharan Africa","Upper middle income","IBRD",""]
[138,null,"Nauru","NRU",null,"East Asia & Pacific","High income","IBRD"]
[139,null,"Nepal","NPL",null,"South Asia","Lower middle income","IDA"]
[140,null,"Netherlands","NLD",null,"Europe & Central Asia","High income","..","EMU"]
[141,null,"New Caledonia","NCL",null,"East Asia & Pacific","High income","..",""]
[142,null,"New Zealand","NZL",null,"East Asia & Pacific","High income","..",""]
[143,null,"Nicaragua","NIC",null,"Latin America & Caribbean","Lower middle income","IDA","HIPC"]
[144,null,"Niger","NER",null,"Sub-Saharan Africa","Low income","IDA","HIPC"]
[145,null,"Nigeria","NGA",null,"Sub-Saharan Africa","Lower middle income","Blend",""]
[146,null,"North Macedonia","MKD",null,"Europe & Central Asia","Upper middle income","IBRD",""]
[147,null,"Northern Mariana Islands","MNP",null,"East Asia & Pacific","High income","..",""]
[148,null,"Norway","NOR",null,"Europe & Central Asia","High income","..",""]
[149,null,"Oman","OMN",null,"Middle East & North Africa","High income","..",""]
[150,null,"Pakistan","PAK",null,"South Asia","Lower middle income","Blend",""]
[151,null,"Palau","PLW",null,"East Asia & Pacific","High income","IBRD",""]
[152,null,"Panama","PAN",null,"Latin America & Caribbean","High income","IBRD",""]
[153,null,"Papua New Guinea","PNG",null,"East Asia & Pacific","Lower middle income","Blend",""]
[154,null,"Paraguay","PRY",null,"Latin America & Caribbean","Upper middle income","IBRD",""]
[155,null,"Peru","PER",null,"Latin America & Caribbean","Upper middle income","IBRD",""]
[156,null,"Philippines","PHL",null,"East Asia & Pacific","Lower middle income","IBRD",""]
[157,null,"Poland","POL",null,"Europe & Central Asia","High income","IBRD",""]
[158,null,"Portugal","PRT",null,"Europe & Central Asia","High income","..","EMU"]
[159,null,"Puerto Rico","PRI",null,"Latin America & Caribbean","High income","..",""]
[160,null,"Qatar","QAT",null,"Middle East & North Africa","High income","..",""]
[161,null,"Romania","ROU",null,"Europe & Central Asia","High income","IBRD",""]
[162,null,"Russian Federation","RUS",null,"Europe & Central Asia","Upper middle income","IBRD",""]
[163,null,"Rwanda","RWA",null,"Sub-Saharan Africa","Low income","IDA","HIPC"]
[164,null,"Samoa","WSM",null,"East Asia & Pacific","Upper middle income","IDA",""]
[165,null,"San Marino","SMR",null,"Europe & Central Asia","High income","..",""]
[166,null,"São Tomé and Principe","STP",null,"Sub-Saharan Africa","Lower middle income","IDA","HIPC"]
[167,null,"Saudi Arabia","SAU",null,"Middle East & North Africa","High income","..",""]
[168,null,"Senegal","SEN",null,"Sub-Saharan Africa","Lower middle income","IDA","HIPC"]
[169,null,"Serbia","SRB",null,"Europe & Central Asia","Upper middle income","IBRD",""]
[170,null,"Seychelles","SYC",null,"Sub-Saharan Africa","High income","IBRD",""]
[171,null,"Sierra Leone","SLE",null,"Sub-Saharan Africa","Low income","IDA","HIPC"]
[172,null,"Singapore","SGP",null,"East Asia & Pacific","High income","..",""]
[173,null,"Sint Maarten (Dutch part)","SXM",null,"Latin America & Caribbean","High income",".."]
[174,null,"Slovak Republic","SVK",null,"Europe & Central Asia","High income","..","EMU"]
[175,null,"Slovenia","SVN",null,"Europe & Central Asia","High income","..","EMU"]
[176,null,"Solomon Islands","SLB",null,"East Asia & Pacific","Lower middle income","IDA",""]
[177,null,"Somalia","SOM",null,"Sub-Saharan Africa","Low income","IDA","HIPC"]
[178,null,"South Africa","ZAF",null,"Sub-Saharan Africa","Upper middle income","IBRD",""]
[179,null,"South Sudan","SSD",null,"Sub-Saharan Africa","Low income","IDA"]
[180,null,"Spain","ESP",null,"Europe & Central Asia","High income","..","EMU"]
[181,null,"Sri Lanka","LKA",null,"South Asia","Lower middle income","IBRD",""]
[182,null,"St. Kitts and Nevis","KNA",null,"Latin America & Caribbean","High income","IBRD",""]
[183,null,"St. Lucia","LCA",null,"Latin America & Caribbean","Upper middle income","Blend",""]
[184,null,"St. Martin (French part)","MAF",null,"Latin America & Caribbean","High income",".."]
[185,null,"St. Vincent and the Grenadines","VCT",null,"Latin America & Caribbean","Upper middle income","Blend",""]
[186,null,"Sudan","SDN",null,"Sub-Saharan Africa","Low income","IDA","HIPC"]
[187,null,"Suriname","SUR",null,"Latin America & Caribbean","Upper middle income","IBRD",""]
[188,null,"Sweden","SWE",null,"Europe & Central Asia","High income","..",""]
[189,null,"Switzerland","CHE",null,"Europe & Central Asia","High income","..",""]
[190,null,"Syrian Arab Republic","SYR",null,"Middle East & North Africa","Low income","IDA",""]
[191,null,"Taiwan, China","TWN",null,"East Asia & Pacific","High income",".."]
[192,null,"Tajikistan","TJK",null,"Europe & Central Asia","Low income","IDA",""]
[193,null,"Tanzania","TZA",null,"Sub-Saharan Africa","Lower middle income","IDA","HIPC"]
[194,null,"Thailand","THA",null,"East Asia & Pacific","Upper middle income","IBRD",""]
[195,null,"Timor-Leste","TLS",null,"East Asia & Pacific","Lower middle income","Blend"]
[196,null,"Togo","TGO",null,"Sub-Saharan Africa","Low income","IDA","HIPC"]
[197,null,"Tonga","TON",null,"East Asia & Pacific","Upper middle income","IDA",""]
[198,null,"Trinidad and Tobago","TTO",null,"Latin America & Caribbean","High income","IBRD",""]
[199,null,"Tunisia","TUN",null,"Middle East & North Africa","Lower middle income","IBRD",""]
[200,null,"Turkey","TUR",null,"Europe & Central Asia","Upper middle income","IBRD",""]
[201,null,"Turkmenistan","TKM",null,"Europe & Central Asia","Upper middle income","IBRD",""]
[202,null,"Turks and Caicos Islands","TCA",null,"Latin America & Caribbean","High income",".."]
[203,null,"Tuvalu","TUV",null,"East Asia & Pacific","Upper middle income","IDA"]
[204,null,"Uganda","UGA",null,"Sub-Saharan Africa","Low income","IDA","HIPC"]
[205,null,"Ukraine","UKR",null,"Europe & Central Asia","Lower middle income","IBRD",""]
[206,null,"United Arab Emirates","ARE",null,"Middle East & North Africa","High income","..",""]
[207,null,"United Kingdom","GBR",null,"Europe & Central Asia","High income","..",""]
[208,null,"United States","USA",null,"North America","High income","..",""]
[209,null,"Uruguay","URY",null,"Latin America & Caribbean","High income","IBRD",""]
[210,null,"Uzbekistan","UZB",null,"Europe & Central Asia","Lower middle income","Blend",""]
[211,null,"Vanuatu","VUT",null,"East Asia & Pacific","Lower middle income","IDA",""]
[212,null,"Venezuela, RB","VEN",null,"Latin America & Caribbean","Upper middle income","IBRD",""]
[213,null,"Vietnam","VNM",null,"East Asia & Pacific","Lower middle income","IBRD"]
[214,null,"Virgin Islands (U.S.)","VIR",null,"Latin America & Caribbean","High income","..",""]
[215,null,"West Bank and Gaza","PSE",null,"Middle East & North Africa","Lower middle income","..",""]
[216,null,"Yemen, Rep.","YEM",null,"Middle East & North Africa","Low income","IDA"]
[217,null,"Zambia","ZMB",null,"Sub-Saharan Africa","Lower middle income","IDA","HIPC"]
[218,null,"Zimbabwe","ZWE",null,"Sub-Saharan Africa","Lower middle income","Blend",""]
[]
[]
[]
[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,"Word count"]
[null,null,{"$f":"SUM(IF(LEN(TRIM(C7:C224))=0,0,LEN(TRIM(C7:C224))-LEN(SUBSTITUTE(C7:C224,\" \",\"\"))+1))","v":318}]