{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Information","1.General_Inputs_Plan&Budget","2.Infrastructure_Plan&Budget","3.Equip_Standards_Plan&Budget","4.Equip_Other_Plan&Budget","5.Human_Resources_Plan&Budget","6.Referrals_Plan&Budget","7.Other_Facility_Plan&Budget","8.National_Regional_Plan&Budget","9.Financing_Typology_Analytics","10.Financing_ScaleUp_Scenario"],"not_rendered":{"charts":11,"images":3,"macros":1,"external_links":0,"defined_names":298,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Information","index":0,"n_rows":82,"n_cols":9,"rows_kept":82,"cut":false,"hidden":false,"merged":[[13,0,13,11],[14,0,14,11],[78,0,78,5],[42,0,42,5],[16,0,16,11],[40,0,40,11],[17,0,17,11],[20,0,20,11],[59,0,59,5],[18,0,19,11],[45,8,46,11],[5,0,5,11],[10,0,10,11],[8,0,8,11],[11,0,11,11],[12,0,12,11]]}
[]
[]
[]
[]
[]
["Small and Sick Newborn Planning & Costing Tool"]
[null,null,null,null,"Tool Version: ","Version 3.0"]
[null,null,null,null,"Date of release:","June 2025"]
["Developed by the Global Financing Facility in collaboration with UNICEF to support country planning & budgeting for the scale-up of Level 2 newborn care units"]
[]
["Disclaimers"]
["This is an open-source tool. Any changes in the structure or formulas may result in errors."]
["The GFF and UNICEF are not responsible for the use of the tool or the results produced. These are entirely the responsibility of the user."]
[]
["Contact for questions & feedback: Alison Morgan (GFF) amorgan3@worldbank.org"]
[]
["General Information and tips"]
["The primary objective of the tool is to support planning & budgeting for scaling-up good quality of care at Level 2 newborn care units "]
["The tool covers all the components of the model of care proposed by the WHO-UNICEF Expert and Country Consultation and helps users to unpack ‘what it takes’ and how much it costs to implement country standards for each component."]
[]
["Similar to a planning guide, the tool has been organised step-by-step. Users should go through worksheets and their steps sequentially."]
["A user manual with troubleshooting tips as well as additional information to support the use of the tool are available from the GFF "]
["The tool operates step-by-step, so users should start with the first tab and go through each step, before moving to the following tab. "]
["It is optimized for Excel 365. Using older versions may result in reduced functionality or errors"]
["Before using the tool as a Microsoft Excel file make sure that all Macros are enabled. "]
["To enable macros, go to the Excel menu and select the following:"]
["File -- Options -- Trust Center -- Trust center settings -- Macro Settings -- Enable all macros. "]
["Or select “Enable content” at the prompt when first opening the file."]
["Some office versions block by default all macros from files downloaded from the web"]
["If this happens, close the file and before opening the file select:"]
["Properties -- General -- Unblock"]
["Due to compatibility issues, please do not use Google Drive to store or share this Excel file. "]
["Doing so may corrupt the file or disable essential VBA functions, causing errors in calculations and overall functionality"]
["WARNING: Do not copy and paste data into this workbook. Doing so may insert conflicting code and remove validation. Please enter data manually"]
["Many cells are formatted with special styles and this will occasionally cause Excel to display a \"Slow Workbook\" message, which should be ignored."]
["Cells with formulae and worksheets have been protected.  However users are able to transfer data to other workbooks for further analysis."]
["This workbook contains many named cells. When transferring data with the copy/paste commands, use \"Paste special: Values and numbers format\""]
["Graphs can be edited and copy/paste to other workbooks"]
[]
[]
["TOOL STRUCTURE & NAVIGATION MENU"]
[]
["General Inputs for Planning & Budgeting"]
["In this module the user: "]
["* enters general information on the scale-up;"]
["* selects typologies for costings; ",null,null,null,null,null,null,null,"THE 10 COMPONENTS OF SCALING-UP THE MODEL OF CARE FOR SMALL AND/OR SICK NEWBORNS"]
["* enters basic unit costs for infrastructure, equipment, human resources & referrals "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Planning & Budgeting "]
["These modules are the core of the tool and provide step-by-step guidance  to:"]
["* set country standards applicable to the scale-up components; "]
["* review the standards and associated costs by typology;"]
["* identify & cost supporting system strategies."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Financing"]
["These modules provide financing analytics to support strategic decision-making:"]
["* Using facility typologies to explore cost analytics"]
["* Scale-up scenario & funding implications"]

{"sheet":"1.General_Inputs_Plan&Budget","index":1,"n_rows":315,"n_cols":6,"rows_kept":315,"cut":false,"hidden":false,"merged":[[116,3,116,5],[277,1,277,4],[246,5,246,6],[247,5,247,6],[248,5,248,6],[249,5,249,6],[250,5,250,6],[251,5,251,6],[121,3,121,5],[122,3,122,5],[123,3,123,5],[124,3,124,5],[125,3,125,5],[126,3,126,5],[127,3,127,5],[128,3,128,5],[129,3,129,5],[130,3,130,5],[230,1,230,2],[231,1,231,2],[133,3,133,5],[149,3,149,5],[257,5,257,6],[132,3,132,5],[13,2,13,3],[245,5,245,6],[75,2,75,3],[18,3,20,3],[34,3,37,3],[39,3,42,3],[48,3,51,3],[65,2,65,3],[66,2,66,3],[67,2,67,3],[68,2,68,3],[63,2,63,3],[64,2,64,3],[44,3,46,3],[148,3,148,5],[138,3,138,5],[139,3,139,5],[140,3,140,5],[136,3,136,5],[137,3,137,5],[141,3,141,5],[142,3,142,5],[143,3,143,5],[144,3,144,5],[146,3,146,5],[147,3,147,5],[117,3,117,5],[158,3,158,5],[159,3,159,5],[160,3,160,5],[150,3,150,5],[118,3,118,5],[119,3,119,5],[120,3,120,5],[131,3,131,5],[145,3,145,5],[156,3,156,5],[157,3,157,5],[134,3,134,5],[135,3,135,5],[151,3,151,5],[152,3,152,5],[153,3,153,5],[97,4,100,5],[95,1,95,3],[96,2,96,3],[76,2,76,3],[77,2,77,3],[78,2,78,3],[88,2,88,3],[89,2,89,3],[90,2,90,3],[91,2,91,3],[79,2,79,3],[80,2,80,3],[81,2,81,3],[82,2,82,3],[83,2,83,3],[84,2,84,3],[85,2,85,3],[86,2,86,3],[87,2,87,3],[95,4,96,5],[172,3,172,5],[173,3,173,5],[174,3,174,5],[175,3,175,5],[154,3,154,5],[155,3,155,5],[166,3,166,5],[167,3,167,5],[168,3,168,5],[169,3,169,5],[170,3,170,5],[161,3,161,5],[162,3,162,5],[163,3,163,5],[164,3,164,5],[165,3,165,5],[171,3,171,5],[191,3,191,5],[192,3,192,5],[193,3,193,5],[194,3,194,5],[195,3,195,5],[186,3,186,5],[187,3,187,5],[188,3,188,5],[189,3,189,5],[190,3,190,5],[181,3,181,5],[182,3,182,5],[183,3,183,5],[184,3,184,5],[185,3,185,5],[176,3,176,5],[177,3,177,5],[178,3,178,5],[179,3,179,5],[180,3,180,5],[215,3,215,5],[256,5,256,6],[255,5,255,6],[196,3,196,5],[197,3,197,5],[198,3,198,5],[199,3,199,5],[200,3,200,5],[201,3,201,5],[202,3,202,5],[203,3,203,5],[204,3,204,5],[205,3,205,5],[206,3,206,5],[207,3,207,5],[208,3,208,5],[209,3,209,5],[210,3,210,5],[280,3,280,5],[281,3,281,5],[282,3,282,5],[221,3,221,5],[222,3,222,5],[223,3,223,5],[224,3,224,5],[225,3,225,5],[270,3,270,5],[271,3,271,5],[263,5,263,6],[264,5,264,6],[265,5,265,6],[242,2,242,4],[242,5,244,6],[241,1,241,6],[262,5,262,6],[253,5,253,6],[254,5,254,6],[258,5,258,6],[259,5,259,6],[260,5,260,6],[261,5,261,6],[252,5,252,6],[2,1,2,6],[303,3,303,4],[304,3,304,4],[312,3,312,4],[313,3,313,4],[314,3,314,4],[303,1,304,1],[53,3,56,3],[54,4,54,5],[35,4,35,5],[40,4,40,5],[45,4,45,5],[49,4,49,5],[226,3,226,5],[279,3,279,5],[216,3,216,5],[217,3,217,5],[218,3,218,5],[219,3,219,5],[220,3,220,5],[211,3,211,5],[212,3,212,5],[213,3,213,5],[214,3,214,5]]}
[]
[null,"GENERAL INPUTS"]
[null,"WARNING: Do not copy and paste data into this workbook. Doing so may insert conflicting code and remove validation. Please enter data manually & choose from dropdown menu where available to ensure proper functionality "]
[null,"MODULE OVERVIEW"]
[null,"* Enter general information on the costing exercise"]
[null,"* Select facility typologies for costing"]
[null,"* Enter basic information on system parameters "]
[null,"* Enter data on unit costs for infrastructure, equipment, HR & referrals"]
[null,"Light blue cells are user inputs."]
[]
[null,"STEP 1 - PROVIDE GENERAL INFORMATION ON THE COSTING EXERCISE"]
[]
[null,"1.1 - Name of the Costing Scenario"]
[null,"Name:","Training Dummy Data"]
[]
[null,"1.2 - Select currency used for cost inputs & document exchange rate used for any conversions."]
[null,"Remember that all costs should be measured using the same currency."]
[null,null,null,"User Notes"]
[null,"Currency to be used for all cost inputs: ","USD"]
[]
[null,"Exchange Rate of local currency for conversions of final estimates: 1 USD = ",120]
[]
[null,"1.3- Select base year for costings and financing "]
[null,"Remember all costs should be measured for the same base year"]
[null,"If different types of costs are collected for different years, the costing results will be incorrect"]
[null,null,null,"User Notes"]
[null,"All the tool costings and financing inputs are for base year:",2024]
[]
[]
[null,"STEP 2 - SELECT FACILITY TYPOLOGIES FOR COSTING"]
[]
[null,"Select facility typologies for costing. Need to select at least one option for each typology"]
[null,"Please make sure you select from the drop down menu (\"Yes\", \"No\"). Do not copy/paste, cut/paste into these cells"]
[null,null,null,"User Notes"]
[null,"SIZE","To be included ?"]
[null,"Small","Yes",null,{"$f":"IF(AND(C36= \"No\",C37=\"No\",C38=\"No\"),\"ERROR, NEED TO SELECT A CATEGORY\", \"\")","v":""}]
[null,"Medium","Yes"]
[null,"Large","No"]
[]
[null,"COST/LOCATION"]
[null,"Mid Cost ","Yes",null,{"$f":"IF(AND(C41= \"No\",C42=\"No\",C43=\"No\"),\"ERROR, NEED TO SELECT A CATEGORY\", \"\")","v":""}]
[null,"High Cost","Yes"]
[null,"Very High Cost","Yes"]
[]
[null,"CONSTRUCTION TYPE"]
[null,"New Construction","Yes",null,{"$f":"IF(AND(C46= \"No\",C47=\"No\"),\"ERROR, NEED TO SELECT A CATEGORY\", \"\")","v":""}]
[null,"Rehabilitation","Yes"]
[]
[null,"EQUIPMENT NEEDS"]
[null,"Major","Yes",null,{"$f":"IF(AND(C50= \"No\",C51=\"No\",C52=\"No\"),\"ERROR, NEED TO SELECT A CATEGORY\", \"\")","v":""}]
[null,"Partial","Yes"]
[null,"Limited","Yes"]
[]
[null,"RECRUITMENT CHALLENGES"]
[null,"Standard","Yes",null,{"$f":"IF(AND(C55= \"No\",C56=\"No\", C57=\"No\"),\"ERROR, NEED TO SELECT A CATEGORY\", \"\")","v":""}]
[null,"Hard-to-Recruit","Yes"]
[null,"Most Challenging","No"]
[]
[]
[null,"STEP 3 -ENTER BASIC INFRASTRUCTURE STANDARDS & UNIT COSTS FOR CONSTRUCTION"]
[]
[null,"3.1 Infrastructure Standards - Enter type of inpatient beds for a Level 2 Newborn Care Unit"]
[null,"Enter only inpatient beds. Beds for family members not staying with the newborn should not be included here."]
[null,null,"User Notes"]
[null,"Type of Inpatient Beds"]
[null,"High Dependency"]
[null,"Low Dependency"]
[null,"Transitioning"]
[]
[]
[null,"3.2. Infrastructure Standards - Enter the other facility areas, such as outpatient care, ancillary and support services "]
[null,"Remember to account for space requirements of all components of the model of care, including post-discharge follow-up and family and community involvement and support"]
[null,"This also includes office space requirements for management, data systems & liaison with other facilities regarding linkages and referrals"]
[null,"Any areas for accommodation of family members not staying with the newborn should be included here."]
[]
[null,null,"User Notes"]
[null,"Type of Facility Service Areas"]
[null,"Family facilities","Sample areas only"]
[null,"Nursing station"]
[null,"Nursing office"]
[null,"Counselling area"]
[null,"Other areas to be defined","Catch-all category"]
[null,null,"As per instructions, individual areas need to be specified"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"3.3. Enter average construction costs per Sq mt for a Level 2 Newborn Care Unit as per standards"]
[null," If no data on rehabilitation costs, note that based on the GFF case study rehabilitation costs are approximately 50% to 60% of new construction costs"]
[null,"Average Cost per Square Meter of Construction (by Typology)",null,null,"User Notes"]
[null,null,"Type of Construction"]
[null,"Costing Typology",{"$f":"IF(C46=\"Yes\",B46,\"\")","v":"New Construction"},{"$f":"IF(C47=\"Yes\",B47,\"\")","v":"Rehabilitation"}]
[null,{"$f":"IF(C41=\"Yes\", B41, \"\")","v":"Mid Cost "},670,400]
[null,{"$f":"IF(C42=\"Yes\", B42, \"\")","v":"High Cost"},940,560]
[null,{"$f":"IF(C43=\"Yes\", B43, \"\")","v":"Very High Cost"},1200,720]
[]
[null,"3.4. Enter estimated annual cost of building maintenance (as % of the cost of building a new unit)"]
[null,"If country data are not available, a standard rule of thumb such as 1% can be used."]
[null,"Building Maintenance","As % of new building value","User Notes"]
[null,"Annual building maintenance costs ",1.4999999999999999E-2]
[]
[]
[null,"STEP 4.  ENTER LIST OF ESSENTIAL EQUIPMENT (as per standards)  & UNIT COSTS"]
[]
[null,"4.1. Enter list of essential equipment and unit price (inclusive of  warranty) for each device"]
[null,"Equipment list to be sourced from country standards & guidelines. "]
[null,"The list should include all essential devices to deliver quality of care inc. those required for mothers and referral transport "]
[null,"If standards are not available, as a starting point for discussions, the list can be sourced from international guidelines or relevant GFF reports"]
[null,"Do not enter office furniture or equipment here"]
[]
[null,"LIST OF ESSENTIAL EQUIPMENT","Unit price inc. warranty ","User Notes"]
[null,"Multipara monitor",700]
[null,"Phototherapy Unit",400]
[null,"Radiant Warmer",2000]
[null,"CPAP",1300]
[null,"Pulse Oximeter",100]
[null,"Portable X-Ray",20000]
[null,"Other devices to be defined and costed",57950,"Catch-all category. Individual devices need to be specified and costed"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"4.2. Provide a brief description of warranty, including number of years"]
[]
[null,"Brief Warranty Description:"]
[null,"One year only"]
[]
[]
[null,"STEP 5. ENTER HUMAN RESOURCES -CLINICAL & SUPPORT- (As per standards) AND UNIT COSTS"]
[null,"5.1 Enter categories of facility staff and annual cost per FTE for facility typologies included"]
[null,"Categories should include clinical & support staff needed. To be sourced from country standards & guidelines. "]
[null,"Make sure the list includes human resources required for all components, such as drivers for ambulance referrals, data officers for information systems or support staff for post-discharge follow-up"]
[null,"If not available, the list can be sourced from international guidelines or relevant GFF reports, as a starting point for discussions in country."]
[null,"Column headings will be blank if a typology was not included"]
[]
[null,"List of Human Resources Required & Annual Costs per FTE"]
[null,null,"STAFF RECRUITMENT FACILITY TYPOLOGIES",null,null,"User Notes"]
[null,null,{"$f":"IF(C55=\"Yes\", _xlfn.CONCAT(B55, \" area\"), \"\")","v":"Standard area"},{"$f":"IF(C56=\"Yes\", B56, \"\")","v":"Hard-to-Recruit"},{"$f":"IF(C57=\"Yes\",B57,\"\")","v":""}]
[null,"Staff Category (Clinical & Support)",{"$f":"IF(C55= \"Yes\", \"Annual costs inc. salaries, allowances, etc.\", \"\")","v":"Annual costs inc. salaries, allowances, etc."},{"$f":"IF(C56= \"Yes\", \"Annual costs inc. salaries, allowances, recruitment area incentives\", \"\")","v":"Annual costs inc. salaries, allowances, recruitment area incentives"},{"$f":"IF(C57= \"Yes\", \"Annual costs inc. salaries, allowances, & recruitment area incentives\", \"\")","v":""}]
[null,"Neonatologist ",11000,13750]
[null,"Medical Doctor",8000,10000]
[null,"Registered Neonatal Nurse",6000,7500]
[null,"Registered Nurse",4000,5000]
[null,"Ward assistant/Public Health Nurse",2000,2500]
[null,"Biomedical engineer",6000,7500]
[null,"Ambulance driver",3000,3750]
[null,"Cleaner",1500,1875]
[null,"Other staff to be individually defined & costed",50000,75000]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"5.2 Enter average costs of supervision/mentoring visits from regions to Level 2 Newborn Care Units, including allowances, per diems, transport"]
[]
[null,"Supervision/Mentoring/Coaching Visits - Unit Costs","$","User Notes"]
[null,"Average cost per supervision, mentoring and coaching visits:",95]
[]
[]
[null,"STEP 6. ENTER & VALIDATE COST LOADINGS OR MARK-UPS TO CAPTURE VARIATIONS ACROSS LOCATION/COST TYPOLOGIES"]
[]
[null,"6.1. Enter % of cost loadings/mark-ups to be applied to supervision/mentoring visits and other strategies at facility level. Enter 0 or leave blank if none"]
[null,"If for example, costs entered in step 5.2. reflect a mid-cost location and are likely to be 10% higher in high cost locations and 20% higher in very high cost locations: Enter 0 for mid cost, 10% for high cost and 20% for very high cost"]
[null,"Only cost/location typologies included in the exercise are shown here."]
[null,"Cost loadings/mark-ups by typology"," %","User Notes"]
[null,{"$f":"List_Costing_Groups","v":"Mid Cost "},0]
[null,"High Cost",0.1]
[null,"Very High Cost",0.2]
[]
[]
[null,"6.2. Review costs of supervision/mentoring visits after applying cost loadings"]
[null,"This table shows unit costs in step 5.2. by facility/cost location typology, after applying cost loadings/mark-ups in Step 6.1."]
[null,"Here you have the opportunity to review how cost loadings are applied to ensure that percentages entered in Step 6.1. are accurate"]
[null,"If you think there is a mistake in these calculations, go back to Step 6.1. and change the cost loadings entered."]
[null,"Remember that these loadings are used to estimate costs under each planning & budgeting module."]
[]
[null,"Unit costs of Supervision visits after applying cost loadings ","$"]
[null,{"$f":"List_Costing_Groups","v":"Mid Cost "},{"$f":"IF(Name_Cost_Mid=\"\",0,Price_SupervisionVisit*(1+Percent_Loading_Mid))","v":95}]
[null,"High Cost",{"$f":"IF(Name_Cost_High=\"\",0,Price_SupervisionVisit*(1+Percent_Loading_High))","v":104.50000000000001}]
[null,"Very High Cost",{"$f":"IF(Name_Cost_VHigh=\"\",0,Price_SupervisionVisit*(1+Percent_Loading_VHigh))","v":114}]
[]
[]
[]
[null,"STEP 7. ENTER COSTS OF REFERAL VEHICLE/AMBULANCE"]
[]
[null,"7.1. Enter ambulance vehicle acquisition costs, including any GPS requirements"]
[null,"Do not include newborn transport equipment costs, only the costs of the vehicle & the GPS"]
[]
[null,"Ambulance vehicle cost inclusive of GPS:","Unit COST","User Notes"]
[null,null,100000]
[]
[]
[null,"7.2. Enter fuel and maintenance costs per kilometer for ambulance vehicles"]
[null,"Remember that ambulance annual costs by facility typologies are estimated using these inputs. "]
[null,"Under the Referrals Plan & Budget tab, adjustments by cost loadings and other factors are made and you can review/modify facility estimates as required"]
[]
[null,"Note: For a traditional ambulance vehicle, a litre of fuel might last between 12-15 kmts. In the absence of data, maintenance costs can be set as a percentage of fuel cost (i.e. 40 or 50%)"]
[null,"Average cost of  vehicle fuel & maintenance","Cost per kilometer","User Notes"]
[null,"Fuel",0.12]
[null,"Maintenance",0.06]

{"sheet":"2.Infrastructure_Plan&Budget","index":2,"n_rows":134,"n_cols":6,"rows_kept":134,"cut":false,"hidden":false,"merged":[[91,5,91,6],[92,5,92,6],[93,5,93,6],[94,5,94,6],[98,3,98,4],[90,5,90,6],[79,5,79,6],[80,5,80,6],[81,5,81,6],[82,5,82,6],[88,5,88,6],[89,5,89,6],[83,5,83,6],[84,5,84,6],[85,5,85,6],[86,5,86,6],[43,2,43,4],[43,1,44,1],[55,1,55,2],[72,2,72,4],[87,5,87,6],[43,5,43,6],[44,5,49,6],[55,3,55,4],[56,3,60,4],[76,5,78,6],[2,1,2,6],[129,1,129,5],[104,1,104,4],[113,2,113,4],[121,2,121,4],[113,5,113,7],[121,5,121,7],[29,3,29,4],[30,3,31,4],[20,5,20,6],[21,5,22,6],[97,3,97,4],[76,1,76,4],[20,2,20,4],[64,1,64,4],[97,1,97,2]]}
[]
[null,"INFRASTRUCTURE - PLANNING & BUDGETING"]
[null,"WARNING: Do not copy and paste data into this workbook. Doing so may insert conflicting code and remove validation. Please enter data manually to ensure proper functionality"]
[null,"MODULE OVERVIEW"]
[null,"Enter country infrastructure standards, including:"]
[null,"*The required parameters to estimate the number of beds needed to adequately meet the demand for services at each facility size"]
[null,"* Minimum floor space per bed  "]
[null,"* Minimum floor space per facility area & facility circulation areas"]
[null,"If detailed country standards are not available, to initiate discussions in country, they can be sourced from international guidelines or relevant GFF reports"]
[null,"Review required floor space & associated costings for each type of facility, including building maintenance."]
[null,"Remember:"]
[null,"Light blue cells are user inputs."]
[null,"Yellow cells are tool calculations not to be manually changed"]
[]
[null,"STEP 1 - ESTIMATE & VALIDATE THE NUMBER OF BEDS REQUIRED TO MEET THE DEMAND FOR SERVICES"]
[null,"The tool calculates the expected number of facility admissions by typology based on: number of live births in catchment area and % of live births requiring special care. "]
[null,"The number of beds is estimated based on expected admissions, ALoS and target occupancy bed rate"]
[]
[null,"1.1. Enter the expected average number of live births in the catchment area for what would be a typical small, medium and large facility "]
[null,"Leave cells blank if facility typology is not being costed"]
[null,null,"Facility Size Typology",null,null,"User Notes"]
[null,null,{"$f":"IF('1.General_Inputs_Plan&Budget'!C36=\"Yes\",'1.General_Inputs_Plan&Budget'!B36,\"\")","v":"Small"},{"$f":"IF('1.General_Inputs_Plan&Budget'!C37=\"Yes\",'1.General_Inputs_Plan&Budget'!B37,\"\")","v":"Medium"},{"$f":"IF('1.General_Inputs_Plan&Budget'!C38=\"Yes\",'1.General_Inputs_Plan&Budget'!B38,\"\")","v":""}]
[null,"Average number of live births in catchment area",5000,10000]
[]
[null,"1.2. Enter formula parameters to estimate number of required beds based on population need:"]
[null,"Based on WHO and UNICEF guidelines & the GFF case study, approx. 13.46% of live births require special care & 6.4 days of ALoS "]
[null,"QoC strategies, inc. protocols and criteria for admission & discharge should be in place to ensure bed strength is adequate"]
[null,"~ 80% to 85% occupancy bed rates might be advisable"]
[null,"Leave target occupancy bed rate blank if 100%"]
[null,"% of live births requiring special care",0.13450000000000001,"User Notes"]
[null,"Target average length of stay (days)",6.4]
[null,"Target occupancy bed rate",0.85]
[]
[null,"1.3. Review expected number of admissions and newborn beds required by typology, "]
[null,"These figures are estimated based on expected live births entered in Step 1.1. and other parameters entered in Step 1.2"]
[null,"Service Delivery Parameters",{"$f":"C22","v":"Small"},{"$f":"D22","v":"Medium"},{"$f":"E22","v":""}]
[null,"Expected annual number of admissions (#)",{"$f":"IF(C22= \"\",0,ROUND(C23*$C$30,0))","v":673},{"$f":"IF(D22=\"\",0,ROUND(D23*$C$30,0))","v":1345},{"$f":"IF(E22=\"\",0,ROUND(E23*$C$30,0))","v":0}]
[null,"Number of beds required (#)",{"$f":"IF(C22=\"\",0,IF($C$32=0,(ROUNDUP(((C37*$C$31)/365),0)),(ROUNDUP(((C37*$C$31)/365)/$C$32,0))))","v":14},{"$f":"IF(D22=\"\",0,IF($C$32=0,(ROUNDUP(((D37*$C$31)/365),0)),(ROUNDUP(((D37*$C$31)/365)/$C$32,0))))","v":28},{"$f":"IF(E22=\"\",0,IF($C$32=0,(ROUNDUP(((E37*$C$31)/365),0)),(ROUNDUP(((E37*$C$31)/365)/$C$32,0))))","v":0}]
[]
[null,"STEP 2 - IDENTIFY NUMBERS FOR EACH TYPE OF INPATIENT BED "]
[null,"Enter here the number of beds for each type of inpatient bed listed under general inputs."]
[null,"Total Number of Beds should equal number of beds required in Step 1.3 above. Otherwise a warning sign would appear. "]
[null,"If there are errors, infrastructure totals will be 0 & equipment costs might also be affected."]
[null,"Inpatient Areas (Type of Beds)","Number of beds",null,null,"User Notes"]
[null,null,{"$f":"IF(C22=\"\",\"\",C36)","v":"Small"},{"$f":" IF(D22=\"\", \"\",D36)","v":"Medium"},{"$f":"IF(E22=\"\", \"\",E36)","v":""}]
[null,{"$f":"List_Inpatient_Beds","v":"High Dependency"},5,10]
[null,"Low Dependency",5,10]
[null,"Transitioning",4,8]
[null,0]
[null,"Total Number of Beds to Check",{"$f":"IF(SUM(C46:C49)=Number_Beds_Small,Number_Beds_Small,\"Check bed numbers\")","v":14},{"$f":"IF(SUM(D46:D49)=Number_Beds_Medium,Number_Beds_Medium,\"Check bed numbers\")","v":28},{"$f":"IF(SUM(E46:E49)=Number_Beds_Large,Number_Beds_Large,\"Check bed numbers\")","v":0}]
[]
[null,"STEP 3 - SET FLOOR SPACE STANDARDS "]
[]
[null,"3.1 - Set minimum floor space (square meters) per each type of inpatient bed"]
[null,"Floor space standards for inpatient beds should take into consideration zero-separation policies"]
[null,"Sq. Mt. per Type of Bed",null,"User Notes"]
[null,{"$f":"B44","v":"Inpatient Areas (Type of Beds)"},"Sq. Mt per Bed"]
[null,{"$f":"List_Inpatient_Beds","v":"High Dependency"},16]
[null,"Low Dependency",12]
[null,"Transitioning",12]
[null,0]
[]
[null,"3.2. Review minimum floor space for inpatient care areas by facility size typology"]
[null,"If Total inpatient care area = 0 the typology has not been costed or there is a mistake in the number of beds entered in Step 2."]
[null,"Total inpatient care area (Sq. Mt.) by Facility Size"]
[null,null,{"$f":"List_Facility_Sizes","v":"Small"},"Medium",""]
[null,"Type of inpatient care area","Sq. Mts per facility","Sq. Mts per facility","Sq. Mts per facility"]
[null,{"$f":"List_Inpatient_Beds","v":"High Dependency"},{"$f":"IF(Number_Beds_Small=0,0,C46*$C58)","v":80},{"$f":"IF(Number_Beds_Medium=0,0,D46*$C58)","v":160},{"$f":"IF(Number_Beds_Large=0,0,E46*$C58)","v":0}]
[null,"Low Dependency",{"$f":"IF(Number_Beds_Small=0,0,C47*$C59)","v":60},{"$f":"IF(Number_Beds_Medium=0,0,D47*$C59)","v":120},{"$f":"IF(Number_Beds_Large=0,0,E47*$C59)","v":0}]
[null,"Transitioning",{"$f":"IF(Number_Beds_Small=0,0,C48*$C60)","v":48},{"$f":"IF(Number_Beds_Medium=0,0,D48*$C60)","v":96},{"$f":"IF(Number_Beds_Large=0,0,E48*$C60)","v":0}]
[null,0,{"$f":"IF(Number_Beds_Small=0,0,C49*$C61)","v":0},{"$f":"IF(Number_Beds_Medium=0,0,D49*$C61)","v":0},{"$f":"IF(Number_Beds_Large=0,0,E49*$C61)","v":0}]
[null,"Total inpatient care area (Sq. Mt.) ",{"$f":"IF(ISNUMBER(C50),SUM(C68:C71),0)","v":188},{"$f":"IF(ISNUMBER(D50),SUM(D68:D71),0)","v":376},{"$f":"IF(ISNUMBER(E50),SUM(E68:E71),0)","v":0}]
["Cell with warning",null,{"$f":"IF(OR(C50=\"Check bed numbers\",D50=\"Check bed numbers\",E72=\"Check bed numbers\"), \"Check number of beds entered in Step 2 before proceeding\", \"\")","v":""}]
[null,"3.3. Set minimum floor space (square meters) for outpatient care, ancillary and support services as applicable"]
[null,"Remember that minimum space standards for the relevant facility areas should take into account any requirements of the 10 components of the small and sick newborn care model"]
[]
[null,"Floor standards for other areas by facility size",null,null,null,"User Notes"]
[null,"Facility Service Area",{"$f":"List_Facility_Sizes","v":"Small"},"Medium",""]
[null,null,{"$f":"C67","v":"Sq. Mts per facility"},{"$f":"D67","v":"Sq. Mts per facility"},{"$f":"E67","v":"Sq. Mts per facility"}]
[null,{"$f":"List_Other_Facility_Areas","v":"Family facilities"},20,35]
[null,"Nursing station",20,20]
[null,"Nursing office",15,16]
[null,"Counselling area",12,16]
[null,"Other areas to be defined",70,90,null,"Catch-all category built for the training dataset"]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,"Total ",{"$f":"IF(Number_Beds_Small=0,0,SUM(C80:C94))","v":137},{"$f":"IF(Number_Beds_Medium=0,0,SUM(D80:D94))","v":177},{"$f":"IF(Number_Beds_Large=0,0,SUM(E80:E94))","v":0}]
[]
[null,"3.4. Set floor space standards for circulation areas (i.e. corridors, entrance)"]
[null,null,null,"User Notes"]
[null,"Minimum floor space for circulation as % of the total area"]
[]
[null,"STEP 4 - REVIEW & VALIDATE TOTAL FACILITY FLOOR SPACE REQUIREMENTS & INFRASTRUCTURE COSTINGS"]
[]
[null,"4.1. Review total floor space required to deliver good quality of care by facility size typology"]
[null,"Total floor space = 0 if typology not costed or errors in number of beds"]
[null,"Square Meters of Floor Space by Facility Size "]
[null,"Service Areas - Floor Space",{"$f":"List_Facility_Sizes","v":"Small"},"Medium",""]
[null,"Inpatient care areas (Sq. Mts.)",{"$f":"IF(Number_Beds_Small=0,0,C72)","v":188},{"$f":"IF(Number_Beds_Medium=0,0,D72)","v":376},{"$f":"IF(Number_Beds_Large=0,0,E72)","v":0}]
[null,"Other facility areas (Sq. Mts.)",{"$f":"C95","v":137},{"$f":"D95","v":177},{"$f":"IF(Number_Beds_Large=0,0,E95)","v":0}]
[null,"Circulation space (Sq. Mts.)",{"$f":"(C107+C108)*$C$99","v":0},{"$f":"(D107+D108)*$C$99","v":0},{"$f":"(E107+E108)*$C$99","v":0}]
[null,"Total floor space (Sq. Mts.)",{"$f":"IF(OR(Number_Beds_Small=0,C50=\"Check bed numbers\"),0,SUM(C107:C109))","v":325},{"$f":"IF(OR(Number_Beds_Medium=0,D50=\"Check bed numbers\"),0,SUM(D107:D109))","v":553},{"$f":"IF(OR(Number_Beds_Large=0,E50=\"Check bed numbers\"),0,SUM(E107:E109))","v":0}]
[]
[null,"4.2. Review infrastructure costs for facilities requiring new construction by size and location/cost typologies"]
[null,"Estimates are based on facility floor space and construction costs per square meter.  "]
[null,null,"NEW CONSTRUCTION - Total Costs"]
[null,"Facility Costs by Typology",{"$f":"List_Facility_Sizes","v":"Small"},"Medium",""]
[null,{"$f":"List_Costing_Groups","v":"Mid Cost "},{"$f":"IF(Name_Construction_New=\"\",0,IF(Name_Cost_Mid=\"\",0,'1.General_Inputs_Plan&Budget'!$C99*Floor_Space_Small))","v":217750},{"$f":"IF(Name_Construction_New=\"\",0,IF(Name_Cost_Mid=\"\",0,'1.General_Inputs_Plan&Budget'!$C99*Floor_Space_Medium))","v":370510},{"$f":"IF(Name_Construction_New=\"\",0,IF(Name_Cost_Mid=\"\",0,'1.General_Inputs_Plan&Budget'!$C99*Floor_Space_Large))","v":0}]
[null,"High Cost",{"$f":"IF(Name_Construction_New= \"\",0,IF(Name_Cost_High=\"\",0,'1.General_Inputs_Plan&Budget'!$C100*Floor_Space_Small))","v":305500},{"$f":"IF(Name_Construction_New=\"\",0,IF(Name_Cost_High=\"\",0,'1.General_Inputs_Plan&Budget'!$C100*Floor_Space_Medium))","v":519820},{"$f":"IF(Name_Construction_New=\"\",0,IF(Name_Cost_High=\"\",0,'1.General_Inputs_Plan&Budget'!$C100*Floor_Space_Large))","v":0}]
[null,"Very High Cost",{"$f":"IF(Name_Construction_New=\"\",0,IF(Name_Cost_VHigh=\"\",0,'1.General_Inputs_Plan&Budget'!$C101*Floor_Space_Small))","v":390000},{"$f":"IF(Name_Construction_New=\"\",0,IF(Name_Cost_VHigh=\"\",0,'1.General_Inputs_Plan&Budget'!$C101*Floor_Space_Medium))","v":663600},{"$f":"IF(Name_Construction_New=\"\",0,IF(Name_Cost_VHigh=\"\",0,'1.General_Inputs_Plan&Budget'!$C101*Floor_Space_Large))","v":0}]
[]
[null,"4.3. Review infrastructure costs for facilities requiring rehabilitation by size and location/cost typologies"]
[null,{"$f":"B113","v":"Estimates are based on facility floor space and construction costs per square meter.  "}]
[null,null,"REHABILITATION - Total Costs"]
[null,{"$f":"B115","v":"Facility Costs by Typology"},{"$f":"List_Facility_Sizes","v":"Small"},"Medium",""]
[null,{"$f":"List_Costing_Groups","v":"Mid Cost "},{"$f":"IF(Name_Construction_Rehab= \"\",0,IF(Name_Cost_Mid=\"\",0,'1.General_Inputs_Plan&Budget'!$D99*Floor_Space_Small))","v":130000},{"$f":"IF(Name_Construction_Rehab= \"\",0,IF(Name_Cost_Mid=\"\",0,'1.General_Inputs_Plan&Budget'!$D99*Floor_Space_Medium))","v":221200},{"$f":"IF(Name_Construction_Rehab= \"\",0,IF(Name_Cost_Mid=\"\",0,'1.General_Inputs_Plan&Budget'!$D99*Floor_Space_Large))","v":0}]
[null,"High Cost",{"$f":"IF(Name_Construction_Rehab= \"\",0,IF(Name_Cost_High=\"\",0,'1.General_Inputs_Plan&Budget'!$D100*Floor_Space_Small))","v":182000},{"$f":"IF(Name_Construction_Rehab= \"\",0,IF(Name_Cost_High=\"\",0,'1.General_Inputs_Plan&Budget'!$D100*Floor_Space_Medium))","v":309680},{"$f":"IF(Name_Construction_Rehab= \"\",0,IF(Name_Cost_High=\"\",0,'1.General_Inputs_Plan&Budget'!$D100*Floor_Space_Large))","v":0}]
[null,"Very High Cost",{"$f":"IF(Name_Construction_Rehab= \"\",0,IF(Name_Cost_VHigh=\"\",0,'1.General_Inputs_Plan&Budget'!$D101*Floor_Space_Small))","v":234000},{"$f":"IF(Name_Construction_Rehab= \"\",0,IF(Name_Cost_VHigh=\"\",0,'1.General_Inputs_Plan&Budget'!$D101*Floor_Space_Medium))","v":398160},{"$f":"IF(Name_Construction_Rehab= \"\",0,IF(Name_Cost_VHigh=\"\",0,'1.General_Inputs_Plan&Budget'!$D101*Floor_Space_Large))","v":0}]
[]
[null,"STEP 5 - REVIEW ANNUAL COST OF BUILDING MAINTENANCE BASED ON INPUTS AND NEW BUILDING VALUES "]
[null,"These costs are estimated as a percentage of new building values"]
[null,"Costs will be 0 if the new construction typology has not been included in costings or if no % of building maintenance was entered in inputs"]
[null,"Annual building maintenance costs by typology",{"$f":"List_Facility_Sizes","v":"Small"},"Medium",""]
[null,{"$f":"List_Costing_Groups","v":"Mid Cost "},{"$f":"Infrastr_maintenance_percentage*C116","v":3266.25},5557.65,0]
[null,"High Cost",4582.5,7797.2999999999993,0]
[null,"Very High Cost",5850,9954,0]

{"sheet":"3.Equip_Standards_Plan&Budget","index":3,"n_rows":131,"n_cols":23,"rows_kept":131,"cut":false,"hidden":false,"merged":[[128,16,128,19],[129,16,129,19],[130,16,130,19],[19,16,20,19],[122,16,122,19],[123,16,123,19],[124,16,124,19],[125,16,125,19],[126,16,126,19],[127,16,127,19],[116,16,116,19],[117,16,117,19],[118,16,118,19],[119,16,119,19],[120,16,120,19],[121,16,121,19],[110,16,110,19],[111,16,111,19],[112,16,112,19],[113,16,113,19],[114,16,114,19],[115,16,115,19],[104,16,104,19],[105,16,105,19],[106,16,106,19],[107,16,107,19],[108,16,108,19],[109,16,109,19],[98,16,98,19],[99,16,99,19],[100,16,100,19],[101,16,101,19],[102,16,102,19],[103,16,103,19],[92,16,92,19],[93,16,93,19],[94,16,94,19],[95,16,95,19],[96,16,96,19],[97,16,97,19],[86,16,86,19],[87,16,87,19],[88,16,88,19],[89,16,89,19],[90,16,90,19],[91,16,91,19],[80,16,80,19],[81,16,81,19],[82,16,82,19],[83,16,83,19],[84,16,84,19],[85,16,85,19],[74,16,74,19],[75,16,75,19],[76,16,76,19],[77,16,77,19],[78,16,78,19],[79,16,79,19],[68,16,68,19],[69,16,69,19],[70,16,70,19],[71,16,71,19],[72,16,72,19],[73,16,73,19],[62,16,62,19],[63,16,63,19],[64,16,64,19],[65,16,65,19],[66,16,66,19],[67,16,67,19],[56,16,56,19],[57,16,57,19],[58,16,58,19],[59,16,59,19],[60,16,60,19],[61,16,61,19],[50,16,50,19],[51,16,51,19],[52,16,52,19],[53,16,53,19],[54,16,54,19],[55,16,55,19],[44,16,44,19],[45,16,45,19],[46,16,46,19],[47,16,47,19],[48,16,48,19],[49,16,49,19],[38,16,38,19],[39,16,39,19],[40,16,40,19],[41,16,41,19],[42,16,42,19],[43,16,43,19],[32,16,32,19],[33,16,33,19],[34,16,34,19],[35,16,35,19],[36,16,36,19],[37,16,37,19],[26,16,26,19],[27,16,27,19],[28,16,28,19],[29,16,29,19],[30,16,30,19],[31,16,31,19],[2,1,2,15],[18,1,18,5],[19,20,19,22],[21,16,21,19],[22,16,22,19],[23,16,23,19],[24,16,24,19],[25,16,25,19],[19,1,20,1],[19,7,19,9],[19,10,19,12],[19,13,19,15],[19,2,19,5]]}
[]
[null,"EQUIPMENT & COMMODITIES (1) -PLANNING & BUDGETING"]
[null,"WARNING: Do not copy and paste data into this workbook. Doing so may insert conflicting code and remove validation. Please enter data manually to ensure proper functionality. If pasting is absolutely necessary use \"Paste Values\" only."]
[null,"MODULE OVERVIEW"]
[null,"Enter the number of essential facility equipment required at each facility size typology, following the instructions below"]
[null,"Some column headings will be blank if not all facility typologies have been included or if the user has specified fewer than five types of inpatient beds. Do not enter data in those columns."]
[null,"Note that panes have been frozen to facilitate data-entry"]
[null,"Light blue cells are user inputs."]
[null,"Yellow cells are tool calculations not to be manually changed"]
[null,"If required, cells in dark blue can be used for overriding modelled estimates "]
[]
[null,"STEP 1 - SET THE NUMBER OF ESSENTIAL DEVICES & VALIDATE ESTIMATES TO BE USED IN COST CALCULATIONS"]
[null,"First enter the number of essential devices required per type of inpatient bed. Decimals are allowed. So if one piece of equipment is required per three beds, enter 0.33"]
[null,"Second, enter total number of devices required for providing safe transport to newborns as part of the referral system"]
[null,"Third, enter any additional essential devices required at a facility. This is done by each facility size included and should take into consideration equipment requirements for facility areas such as triage. "]
[null,"Fourth, review total facility requirements calculated for each typology (number of devices required per type of bed x numbers of each type of bed, plus additional devices required at each facility). Note that the tool rounds up estimates."]
[null,"Fifth, if required override modelled estimates in dark-blue cells."]
[null,"Sixth, review final estimates to be used in cost calculations. These numbers will be the same as those calculated by the tool, unless you have used the dark blue cells to override them."]
["Cell with warning",{"$f":"IF(OR('2.Infrastructure_Plan&Budget'!C50=\"Check bed numbers\",('2.Infrastructure_Plan&Budget'!D50 = \"Check bed numbers\"), ('2.Infrastructure_Plan&Budget'!E50= \"Check bed numbers\")), \" Warning: Go back to Step 2 in the Infrastructure module & check number of beds, before proceeding\", \"\")","v":""}]
[null,"Equipment Name","First, enter required items per type of inpatient bed",null,null,null,"Second, enter requirements for referrals","Third, enter additional required items @ facility",null,null,"Fourth, review estimated facility requirements",null,null,"Fifth, enter user-defined numbers here. Note they override modelled estimates",null,null,"User Notes",null,null,null,"Sixth, review essential equipment numbers to be used in final calculations"]
[null,null,{"$f":"'1.General_Inputs_Plan&Budget'!B66","v":"High Dependency"},{"$f":"'1.General_Inputs_Plan&Budget'!B67","v":"Low Dependency"},{"$f":"'1.General_Inputs_Plan&Budget'!B68","v":"Transitioning"},{"$f":"'1.General_Inputs_Plan&Budget'!B69","v":0},"Newborn Transport Equipment",{"$f":"_xlfn.CONCAT(\"Additional items @\", Name_Small)","v":"Additional items @Small"},{"$f":"_xlfn.CONCAT(\"Additional items @\", Name_Medium)","v":"Additional items @Medium"},{"$f":"_xlfn.CONCAT(\"Additional items @\", Name_Large)","v":"Additional items @"},{"$f":"List_Facility_Sizes","v":"Small"},"Medium","",{"$f":"List_Facility_Sizes","v":"Small"},"Medium","",null,null,null,null,{"$f":"List_Facility_Sizes","v":"Small"},"Medium",""]
[null,{"$f":"Equipment_Type","v":"Multipara monitor"},1,0,0,null,0,0,0,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C22,$D22,$E22,$F22,$G22,H22)","v":5},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C22,$D22,$E22,$F22,$G22,I22)","v":10},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C22,$D22,$E22,$F22,$G22,J22)","v":0},null,null,null,null,null,null,null,{"$f":"IF(N22=\"\",K22,N22)","v":5},{"$f":"IF(O22=\"\",L22,O22)","v":10},{"$f":"IF(P22=\"\",M22,P22)","v":0}]
[null,"Phototherapy Unit",0.6,0.5,0,null,0,0,0,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C23,$D23,$E23,$F23,$G23,H23)","v":6},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C23,$D23,$E23,$F23,$G23,I23)","v":11},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C23,$D23,$E23,$F23,$G23,J23)","v":0},null,null,null,null,null,null,null,6,11,0]
[null,"Radiant Warmer",0.5,0,0,null,0,1,1,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C24,$D24,$E24,$F24,$G24,H24)","v":4},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C24,$D24,$E24,$F24,$G24,I24)","v":6},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C24,$D24,$E24,$F24,$G24,J24)","v":0},null,null,null,null,null,null,null,4,6,0]
[null,"CPAP",0.5,0,0,null,0,0,0,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C25,$D25,$E25,$F25,$G25,H25)","v":3},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C25,$D25,$E25,$F25,$G25,I25)","v":5},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C25,$D25,$E25,$F25,$G25,J25)","v":0},null,null,null,null,null,null,null,3,5,0]
[null,"Pulse Oximeter",0.6,0.5,0.25,null,1,2,4,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C26,$D26,$E26,$F26,$G26,H26)","v":10},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C26,$D26,$E26,$F26,$G26,I26)","v":18},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C26,$D26,$E26,$F26,$G26,J26)","v":0},null,null,null,null,null,null,null,10,18,0]
[null,"Portable X-Ray",0,0,0,null,0,0.2,0.2,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C27,$D27,$E27,$F27,$G27,H27)","v":1},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C27,$D27,$E27,$F27,$G27,I27)","v":1},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C27,$D27,$E27,$F27,$G27,J27)","v":0},0.2,0.2,null,null,null,null,null,0.2,0.2,0]
[null,"Other devices to be defined and costed",0,0,0,null,0,0,0,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C28,$D28,$E28,$F28,$G28,H28)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C28,$D28,$E28,$F28,$G28,I28)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C28,$D28,$E28,$F28,$G28,J28)","v":0},1,1.6,null,null,null,null,null,1,1.6,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C29,$D29,$E29,$F29,$G29,H29)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C29,$D29,$E29,$F29,$G29,I29)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C29,$D29,$E29,$F29,$G29,J29)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C30,$D30,$E30,$F30,$G30,H30)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C30,$D30,$E30,$F30,$G30,I30)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C30,$D30,$E30,$F30,$G30,J30)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C31,$D31,$E31,$F31,$G31,H31)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C31,$D31,$E31,$F31,$G31,I31)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C31,$D31,$E31,$F31,$G31,J31)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C32,$D32,$E32,$F32,$G32,H32)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C32,$D32,$E32,$F32,$G32,I32)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C32,$D32,$E32,$F32,$G32,J32)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C33,$D33,$E33,$F33,$G33,H33)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C33,$D33,$E33,$F33,$G33,I33)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C33,$D33,$E33,$F33,$G33,J33)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C34,$D34,$E34,$F34,$G34,H34)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C34,$D34,$E34,$F34,$G34,I34)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C34,$D34,$E34,$F34,$G34,J34)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C35,$D35,$E35,$F35,$G35,H35)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C35,$D35,$E35,$F35,$G35,I35)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C35,$D35,$E35,$F35,$G35,J35)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C36,$D36,$E36,$F36,$G36,H36)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C36,$D36,$E36,$F36,$G36,I36)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C36,$D36,$E36,$F36,$G36,J36)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C37,$D37,$E37,$F37,$G37,H37)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C37,$D37,$E37,$F37,$G37,I37)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C37,$D37,$E37,$F37,$G37,J37)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C38,$D38,$E38,$F38,$G38,H38)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C38,$D38,$E38,$F38,$G38,I38)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C38,$D38,$E38,$F38,$G38,J38)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C39,$D39,$E39,$F39,$G39,H39)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C39,$D39,$E39,$F39,$G39,I39)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C39,$D39,$E39,$F39,$G39,J39)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C40,$D40,$E40,$F40,$G40,H40)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C40,$D40,$E40,$F40,$G40,I40)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C40,$D40,$E40,$F40,$G40,J40)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C41,$D41,$E41,$F41,$G41,H41)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C41,$D41,$E41,$F41,$G41,I41)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C41,$D41,$E41,$F41,$G41,J41)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C42,$D42,$E42,$F42,$G42,H42)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C42,$D42,$E42,$F42,$G42,I42)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C42,$D42,$E42,$F42,$G42,J42)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C43,$D43,$E43,$F43,$G43,H43)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C43,$D43,$E43,$F43,$G43,I43)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C43,$D43,$E43,$F43,$G43,J43)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C44,$D44,$E44,$F44,$G44,H44)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C44,$D44,$E44,$F44,$G44,I44)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C44,$D44,$E44,$F44,$G44,J44)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C45,$D45,$E45,$F45,$G45,H45)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C45,$D45,$E45,$F45,$G45,I45)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C45,$D45,$E45,$F45,$G45,J45)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C46,$D46,$E46,$F46,$G46,H46)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C46,$D46,$E46,$F46,$G46,I46)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C46,$D46,$E46,$F46,$G46,J46)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C47,$D47,$E47,$F47,$G47,H47)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C47,$D47,$E47,$F47,$G47,I47)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C47,$D47,$E47,$F47,$G47,J47)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C48,$D48,$E48,$F48,$G48,H48)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C48,$D48,$E48,$F48,$G48,I48)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C48,$D48,$E48,$F48,$G48,J48)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C49,$D49,$E49,$F49,$G49,H49)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C49,$D49,$E49,$F49,$G49,I49)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C49,$D49,$E49,$F49,$G49,J49)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C50,$D50,$E50,$F50,$G50,H50)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C50,$D50,$E50,$F50,$G50,I50)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C50,$D50,$E50,$F50,$G50,J50)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C51,$D51,$E51,$F51,$G51,H51)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C51,$D51,$E51,$F51,$G51,I51)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C51,$D51,$E51,$F51,$G51,J51)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C52,$D52,$E52,$F52,$G52,H52)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C52,$D52,$E52,$F52,$G52,I52)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C52,$D52,$E52,$F52,$G52,J52)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C53,$D53,$E53,$F53,$G53,H53)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C53,$D53,$E53,$F53,$G53,I53)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C53,$D53,$E53,$F53,$G53,J53)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C54,$D54,$E54,$F54,$G54,H54)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C54,$D54,$E54,$F54,$G54,I54)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C54,$D54,$E54,$F54,$G54,J54)","v":0},null,null,null,null,null,null,null,{"$f":"IF(N54=\"\",K54,N54)","v":0},{"$f":"IF(O54=\"\",L54,O54)","v":0},{"$f":"IF(P54=\"\",M54,P54)","v":0}]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C55,$D55,$E55,$F55,$G55,H55)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C55,$D55,$E55,$F55,$G55,I55)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C55,$D55,$E55,$F55,$G55,J55)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C56,$D56,$E56,$F56,$G56,H56)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C56,$D56,$E56,$F56,$G56,I56)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C56,$D56,$E56,$F56,$G56,J56)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C57,$D57,$E57,$F57,$G57,H57)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C57,$D57,$E57,$F57,$G57,I57)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C57,$D57,$E57,$F57,$G57,J57)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C58,$D58,$E58,$F58,$G58,H58)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C58,$D58,$E58,$F58,$G58,I58)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C58,$D58,$E58,$F58,$G58,J58)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C59,$D59,$E59,$F59,$G59,H59)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C59,$D59,$E59,$F59,$G59,I59)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C59,$D59,$E59,$F59,$G59,J59)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C60,$D60,$E60,$F60,$G60,H60)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C60,$D60,$E60,$F60,$G60,I60)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C60,$D60,$E60,$F60,$G60,J60)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C61,$D61,$E61,$F61,$G61,H61)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C61,$D61,$E61,$F61,$G61,I61)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C61,$D61,$E61,$F61,$G61,J61)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C62,$D62,$E62,$F62,$G62,H62)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C62,$D62,$E62,$F62,$G62,I62)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C62,$D62,$E62,$F62,$G62,J62)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C63,$D63,$E63,$F63,$G63,H63)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C63,$D63,$E63,$F63,$G63,I63)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C63,$D63,$E63,$F63,$G63,J63)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C64,$D64,$E64,$F64,$G64,H64)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C64,$D64,$E64,$F64,$G64,I64)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C64,$D64,$E64,$F64,$G64,J64)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C65,$D65,$E65,$F65,$G65,H65)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C65,$D65,$E65,$F65,$G65,I65)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C65,$D65,$E65,$F65,$G65,J65)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C66,$D66,$E66,$F66,$G66,H66)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C66,$D66,$E66,$F66,$G66,I66)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C66,$D66,$E66,$F66,$G66,J66)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C67,$D67,$E67,$F67,$G67,H67)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C67,$D67,$E67,$F67,$G67,I67)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C67,$D67,$E67,$F67,$G67,J67)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C68,$D68,$E68,$F68,$G68,H68)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C68,$D68,$E68,$F68,$G68,I68)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C68,$D68,$E68,$F68,$G68,J68)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C69,$D69,$E69,$F69,$G69,H69)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C69,$D69,$E69,$F69,$G69,I69)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C69,$D69,$E69,$F69,$G69,J69)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C70,$D70,$E70,$F70,$G70,H70)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C70,$D70,$E70,$F70,$G70,I70)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C70,$D70,$E70,$F70,$G70,J70)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C71,$D71,$E71,$F71,$G71,H71)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C71,$D71,$E71,$F71,$G71,I71)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C71,$D71,$E71,$F71,$G71,J71)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C72,$D72,$E72,$F72,$G72,H72)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C72,$D72,$E72,$F72,$G72,I72)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C72,$D72,$E72,$F72,$G72,J72)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C73,$D73,$E73,$F73,$G73,H73)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C73,$D73,$E73,$F73,$G73,I73)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C73,$D73,$E73,$F73,$G73,J73)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C74,$D74,$E74,$F74,$G74,H74)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C74,$D74,$E74,$F74,$G74,I74)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C74,$D74,$E74,$F74,$G74,J74)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C75,$D75,$E75,$F75,$G75,H75)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C75,$D75,$E75,$F75,$G75,I75)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C75,$D75,$E75,$F75,$G75,J75)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C76,$D76,$E76,$F76,$G76,H76)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C76,$D76,$E76,$F76,$G76,I76)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C76,$D76,$E76,$F76,$G76,J76)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C77,$D77,$E77,$F77,$G77,H77)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C77,$D77,$E77,$F77,$G77,I77)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C77,$D77,$E77,$F77,$G77,J77)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C78,$D78,$E78,$F78,$G78,H78)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C78,$D78,$E78,$F78,$G78,I78)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C78,$D78,$E78,$F78,$G78,J78)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C79,$D79,$E79,$F79,$G79,H79)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C79,$D79,$E79,$F79,$G79,I79)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C79,$D79,$E79,$F79,$G79,J79)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C80,$D80,$E80,$F80,$G80,H80)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C80,$D80,$E80,$F80,$G80,I80)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C80,$D80,$E80,$F80,$G80,J80)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C81,$D81,$E81,$F81,$G81,H81)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C81,$D81,$E81,$F81,$G81,I81)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C81,$D81,$E81,$F81,$G81,J81)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C82,$D82,$E82,$F82,$G82,H82)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C82,$D82,$E82,$F82,$G82,I82)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C82,$D82,$E82,$F82,$G82,J82)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C83,$D83,$E83,$F83,$G83,H83)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C83,$D83,$E83,$F83,$G83,I83)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C83,$D83,$E83,$F83,$G83,J83)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C84,$D84,$E84,$F84,$G84,H84)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C84,$D84,$E84,$F84,$G84,I84)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C84,$D84,$E84,$F84,$G84,J84)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C85,$D85,$E85,$F85,$G85,H85)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C85,$D85,$E85,$F85,$G85,I85)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C85,$D85,$E85,$F85,$G85,J85)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C86,$D86,$E86,$F86,$G86,H86)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C86,$D86,$E86,$F86,$G86,I86)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C86,$D86,$E86,$F86,$G86,J86)","v":0},null,null,null,null,null,null,null,{"$f":"IF(N86=\"\",K86,N86)","v":0},{"$f":"IF(O86=\"\",L86,O86)","v":0},{"$f":"IF(P86=\"\",M86,P86)","v":0}]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C87,$D87,$E87,$F87,$G87,H87)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C87,$D87,$E87,$F87,$G87,I87)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C87,$D87,$E87,$F87,$G87,J87)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C88,$D88,$E88,$F88,$G88,H88)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C88,$D88,$E88,$F88,$G88,I88)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C88,$D88,$E88,$F88,$G88,J88)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C89,$D89,$E89,$F89,$G89,H89)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C89,$D89,$E89,$F89,$G89,I89)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C89,$D89,$E89,$F89,$G89,J89)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C90,$D90,$E90,$F90,$G90,H90)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C90,$D90,$E90,$F90,$G90,I90)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C90,$D90,$E90,$F90,$G90,J90)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C91,$D91,$E91,$F91,$G91,H91)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C91,$D91,$E91,$F91,$G91,I91)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C91,$D91,$E91,$F91,$G91,J91)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C92,$D92,$E92,$F92,$G92,H92)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C92,$D92,$E92,$F92,$G92,I92)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C92,$D92,$E92,$F92,$G92,J92)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C93,$D93,$E93,$F93,$G93,H93)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C93,$D93,$E93,$F93,$G93,I93)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C93,$D93,$E93,$F93,$G93,J93)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C94,$D94,$E94,$F94,$G94,H94)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C94,$D94,$E94,$F94,$G94,I94)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C94,$D94,$E94,$F94,$G94,J94)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C95,$D95,$E95,$F95,$G95,H95)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C95,$D95,$E95,$F95,$G95,I95)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C95,$D95,$E95,$F95,$G95,J95)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C96,$D96,$E96,$F96,$G96,H96)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C96,$D96,$E96,$F96,$G96,I96)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C96,$D96,$E96,$F96,$G96,J96)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C97,$D97,$E97,$F97,$G97,H97)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C97,$D97,$E97,$F97,$G97,I97)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C97,$D97,$E97,$F97,$G97,J97)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C98,$D98,$E98,$F98,$G98,H98)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C98,$D98,$E98,$F98,$G98,I98)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C98,$D98,$E98,$F98,$G98,J98)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C99,$D99,$E99,$F99,$G99,H99)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C99,$D99,$E99,$F99,$G99,I99)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C99,$D99,$E99,$F99,$G99,J99)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C100,$D100,$E100,$F100,$G100,H100)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C100,$D100,$E100,$F100,$G100,I100)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C100,$D100,$E100,$F100,$G100,J100)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C101,$D101,$E101,$F101,$G101,H101)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C101,$D101,$E101,$F101,$G101,I101)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C101,$D101,$E101,$F101,$G101,J101)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C102,$D102,$E102,$F102,$G102,H102)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C102,$D102,$E102,$F102,$G102,I102)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C102,$D102,$E102,$F102,$G102,J102)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C103,$D103,$E103,$F103,$G103,H103)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C103,$D103,$E103,$F103,$G103,I103)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C103,$D103,$E103,$F103,$G103,J103)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C104,$D104,$E104,$F104,$G104,H104)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C104,$D104,$E104,$F104,$G104,I104)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C104,$D104,$E104,$F104,$G104,J104)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C105,$D105,$E105,$F105,$G105,H105)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C105,$D105,$E105,$F105,$G105,I105)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C105,$D105,$E105,$F105,$G105,J105)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C106,$D106,$E106,$F106,$G106,H106)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C106,$D106,$E106,$F106,$G106,I106)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C106,$D106,$E106,$F106,$G106,J106)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C107,$D107,$E107,$F107,$G107,H107)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C107,$D107,$E107,$F107,$G107,I107)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C107,$D107,$E107,$F107,$G107,J107)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C108,$D108,$E108,$F108,$G108,H108)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C108,$D108,$E108,$F108,$G108,I108)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C108,$D108,$E108,$F108,$G108,J108)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C109,$D109,$E109,$F109,$G109,H109)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C109,$D109,$E109,$F109,$G109,I109)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C109,$D109,$E109,$F109,$G109,J109)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C110,$D110,$E110,$F110,$G110,H110)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C110,$D110,$E110,$F110,$G110,I110)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C110,$D110,$E110,$F110,$G110,J110)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C111,$D111,$E111,$F111,$G111,H111)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C111,$D111,$E111,$F111,$G111,I111)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C111,$D111,$E111,$F111,$G111,J111)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C112,$D112,$E112,$F112,$G112,H112)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C112,$D112,$E112,$F112,$G112,I112)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C112,$D112,$E112,$F112,$G112,J112)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C113,$D113,$E113,$F113,$G113,H113)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C113,$D113,$E113,$F113,$G113,I113)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C113,$D113,$E113,$F113,$G113,J113)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C114,$D114,$E114,$F114,$G114,H114)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C114,$D114,$E114,$F114,$G114,I114)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C114,$D114,$E114,$F114,$G114,J114)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C115,$D115,$E115,$F115,$G115,H115)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C115,$D115,$E115,$F115,$G115,I115)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C115,$D115,$E115,$F115,$G115,J115)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C116,$D116,$E116,$F116,$G116,H116)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C116,$D116,$E116,$F116,$G116,I116)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C116,$D116,$E116,$F116,$G116,J116)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C117,$D117,$E117,$F117,$G117,H117)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C117,$D117,$E117,$F117,$G117,I117)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C117,$D117,$E117,$F117,$G117,J117)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C118,$D118,$E118,$F118,$G118,H118)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C118,$D118,$E118,$F118,$G118,I118)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C118,$D118,$E118,$F118,$G118,J118)","v":0},null,null,null,null,null,null,null,{"$f":"IF(N118=\"\",K118,N118)","v":0},{"$f":"IF(O118=\"\",L118,O118)","v":0},{"$f":"IF(P118=\"\",M118,P118)","v":0}]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C119,$D119,$E119,$F119,$G119,H119)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C119,$D119,$E119,$F119,$G119,I119)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C119,$D119,$E119,$F119,$G119,J119)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C120,$D120,$E120,$F120,$G120,H120)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C120,$D120,$E120,$F120,$G120,I120)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C120,$D120,$E120,$F120,$G120,J120)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C121,$D121,$E121,$F121,$G121,H121)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C121,$D121,$E121,$F121,$G121,I121)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C121,$D121,$E121,$F121,$G121,J121)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C122,$D122,$E122,$F122,$G122,H122)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C122,$D122,$E122,$F122,$G122,I122)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C122,$D122,$E122,$F122,$G122,J122)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C123,$D123,$E123,$F123,$G123,H123)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C123,$D123,$E123,$F123,$G123,I123)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C123,$D123,$E123,$F123,$G123,J123)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C124,$D124,$E124,$F124,$G124,H124)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C124,$D124,$E124,$F124,$G124,I124)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C124,$D124,$E124,$F124,$G124,J124)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C125,$D125,$E125,$F125,$G125,H125)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C125,$D125,$E125,$F125,$G125,I125)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C125,$D125,$E125,$F125,$G125,J125)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C126,$D126,$E126,$F126,$G126,H126)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C126,$D126,$E126,$F126,$G126,I126)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C126,$D126,$E126,$F126,$G126,J126)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C127,$D127,$E127,$F127,$G127,H127)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C127,$D127,$E127,$F127,$G127,I127)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C127,$D127,$E127,$F127,$G127,J127)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C128,$D128,$E128,$F128,$G128,H128)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C128,$D128,$E128,$F128,$G128,I128)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C128,$D128,$E128,$F128,$G128,J128)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C129,$D129,$E129,$F129,$G129,H129)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C129,$D129,$E129,$F129,$G129,I129)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C129,$D129,$E129,$F129,$G129,J129)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C130,$D130,$E130,$F130,$G130,H130)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C130,$D130,$E130,$F130,$G130,I130)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C130,$D130,$E130,$F130,$G130,J130)","v":0},null,null,null,null,null,null,null,0,0,0]
[null,0,null,null,null,null,null,null,null,null,{"$f":"EquipNumber(K$21,NumberBedTypes_All_Range,$C131,$D131,$E131,$F131,$G131,H131)","v":0},{"$f":"EquipNumber(L$21,NumberBedTypes_All_Range,$C131,$D131,$E131,$F131,$G131,I131)","v":0},{"$f":"EquipNumber(M$21,NumberBedTypes_All_Range,$C131,$D131,$E131,$F131,$G131,J131)","v":0},null,null,null,null,null,null,null,0,0,0]

{"sheet":"4.Equip_Other_Plan&Budget","index":4,"n_rows":339,"n_cols":12,"rows_kept":339,"cut":false,"hidden":false,"merged":[[277,1,278,1],[312,4,314,10],[279,5,279,7],[284,3,284,6],[285,3,287,6],[311,4,311,10],[314,2,314,3],[311,2,311,3],[312,2,312,3],[313,2,313,3],[291,8,294,10],[290,5,290,7],[290,8,290,10],[328,8,331,11],[321,4,321,7],[322,4,322,7],[327,2,327,4],[327,5,327,7],[322,2,322,3],[327,8,327,11],[168,9,168,11],[169,9,172,11],[168,3,168,5],[208,9,211,11],[187,3,187,5],[168,6,168,8],[187,6,187,8],[187,9,187,11],[188,9,191,11],[207,9,207,11],[268,5,268,7],[269,5,269,7],[207,3,207,5],[207,6,207,8],[26,8,26,10],[26,5,26,7],[149,9,149,11],[150,9,153,11],[26,2,26,4],[149,6,149,8],[26,11,27,11],[149,3,149,5],[224,1,224,2],[260,5,260,7],[262,5,262,7],[263,5,263,7],[238,3,238,5],[239,3,241,5],[266,5,266,7],[267,5,267,7],[2,1,2,6],[264,5,264,7],[265,5,265,7],[257,1,258,1],[261,5,261,7],[259,5,259,7]]}
[]
[null,"EQUIPMENT & COMMODITIES (2)- PLANNING & BUDGETING"]
[null,"WARNING: Do not copy and paste data into this workbook. Doing so may insert conflicting code and remove validation. Please enter data manually to ensure proper functionality"]
[null,"MODULE OVERVIEW"]
[null,"Review facility equipment cost calculations for each facility size typology, including:"]
[null,"* Total facility equipment cost & devices accounting for the largest cost share"]
[null,"This review step will help users understand what drives facility equipment costs"]
[null,"Consider, estimate and review other equipment related costs"]
[null,"*Equipment acquisition DOES NOT account for the vast majority of all equipment related costs. "]
[null,"* Equipment related costs to be considered and included in these calculations are:"]
[null,"** Transport and distribution to facilities as well as installation"]
[null,"** Annual costs of consumables, medical supplies and renewables"]
[null,"** One-Off buffer stocks required as part of maintenance strategies"]
[null,"** Annual cost of spare parts required as part of maintenance strategies"]
[null,"** Other preventive and corrective maintenance strategies"]
[null,"Consider, estimate and review costs of fully furnishing a facility and providing adequate office & communications equipment, including equipment required to support other components such as referrals & data systems"]
[null,"Estimate needs of new equipment and furniture by equipment typology"]
[null,"Estimate annual costs of medicines and supplies not included elsewhere"]
[null,"Light blue cells are user inputs."]
[null,"Yellow cells are tool calculations not to be manually changed"]
[null,"If required, cells in dark blue can be used for overriding modelled estimates "]
[]
[null,"STEP 1. REVIEW TOTAL FACILITY EQUIPMENT COSTS AND IDENTIFY THE TYPE OF EQUIPMENT ACCOUNTING FOR THE LARGEST SHARE OF COSTS"]
[null,"To examine key costing drivers information on the required number of items and unit prices is also included in this table. Devices accounting for the largest share of costs are highlighted. "]
[null,"Note that calculations will be 0 if that facility typology was not costed or the equipment was not included. "]
[]
[null,null,"Facility Equipment Costs ($)",null,null,"Facility Equipment Costs as % of total",null,null,"Facility Equipment Numbers (as calculated in worksheet \"3.Equipment_Numbers\")",null,null,"Unit price ($) from 1.General Inputs"]
[null,{"$f":"'3.Equip_Standards_Plan&Budget'!B20","v":"Equipment Name"},{"$f":"List_Facility_Sizes","v":"Small"},"Medium","",{"$f":"List_Facility_Sizes","v":"Small"},"Medium","",{"$f":"List_Facility_Sizes","v":"Small"},"Medium",""]
[null,{"$f":"Equipment_Type","v":"Multipara monitor"},{"$f":"IF(Number_Beds_Small=0,0,I29*$L29)","v":3500},{"$f":"IF(Number_Beds_Medium=0,0,J29*$L29)","v":7000},{"$f":"IF(Number_Beds_Large=0,0,K29*$L29)","v":0},{"$f":"IF(C29=0,0,C29/C$139)","v":4.3343653250773995E-2},{"$f":"IF(D29=0,0,D29/D$139)","v":5.4508643513471421E-2},{"$f":"IF(E29=0,0,E29/E$139)","v":0},{"$f":"IF(B29=0,0,INDEX(Equipment_Units_Small,MATCH(B29,Equipment_Type,0)))","v":5},{"$f":"IF(B29=0,0,INDEX(Equipment_Units_Med,MATCH(B29,Equipment_Type,0)))","v":10},{"$f":"IF(B29=0,0,INDEX(Equipment_Units_Large,MATCH(B29,Equipment_Type,0)))","v":0},{"$f":"IF(B29=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B29,Equipment_Type,0)))","v":700}]
[null,"Phototherapy Unit",2400,4400,0,2.9721362229102165E-2,3.4262575922753467E-2,0,6,11,0,{"$f":"IF(B30=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B30,Equipment_Type,0)))","v":400}]
[null,"Radiant Warmer",8000,12000,0,9.9071207430340563E-2,9.3443388880236719E-2,0,4,6,0,{"$f":"IF(B31=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B31,Equipment_Type,0)))","v":2000}]
[null,"CPAP",3900,6500,0,4.8297213622291023E-2,5.061516897679489E-2,0,3,5,0,{"$f":"IF(B32=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B32,Equipment_Type,0)))","v":1300}]
[null,"Pulse Oximeter",1000,1800,0,1.238390092879257E-2,1.4016508332035509E-2,0,10,18,0,{"$f":"IF(B33=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B33,Equipment_Type,0)))","v":100}]
[null,"Portable X-Ray",4000,4000,0,4.9535603715170282E-2,3.1147796293412241E-2,0,0.2,0.2,0,{"$f":"IF(B34=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B34,Equipment_Type,0)))","v":20000}]
[null,"Other devices to be defined and costed",57950,92720,0,0.71764705882352942,0.72200591808129577,0,1,1.6,0,{"$f":"IF(B35=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B35,Equipment_Type,0)))","v":57950}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B36=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B36,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B37=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B37,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B38=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B38,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B39=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B39,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B40=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B40,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B41=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B41,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B42=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B42,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B43=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B43,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B44=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B44,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B45=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B45,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B46=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B46,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B47=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B47,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B48=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B48,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B49=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B49,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B50=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B50,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B51=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B51,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B52=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B52,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B53=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B53,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B54=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B54,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B55=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B55,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B56=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B56,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B57=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B57,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B58=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B58,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B59=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B59,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B60=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B60,Equipment_Type,0)))","v":0}]
[null,0,{"$f":"IF(Number_Beds_Small=0,0,I61*$L61)","v":0},{"$f":"IF(Number_Beds_Medium=0,0,J61*$L61)","v":0},{"$f":"IF(Number_Beds_Large=0,0,K61*$L61)","v":0},{"$f":"IF(C61=0,0,C61/C$139)","v":0},{"$f":"IF(D61=0,0,D61/D$139)","v":0},{"$f":"IF(E61=0,0,E61/E$139)","v":0},{"$f":"IF(B61=0,0,INDEX(Equipment_Units_Small,MATCH(B61,Equipment_Type,0)))","v":0},{"$f":"IF(B61=0,0,INDEX(Equipment_Units_Med,MATCH(B61,Equipment_Type,0)))","v":0},{"$f":"IF(B61=0,0,INDEX(Equipment_Units_Large,MATCH(B61,Equipment_Type,0)))","v":0},{"$f":"IF(B61=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B61,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B62=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B62,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B63=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B63,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B64=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B64,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B65=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B65,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B66=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B66,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B67=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B67,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B68=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B68,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B69=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B69,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B70=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B70,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B71=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B71,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B72=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B72,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B73=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B73,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B74=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B74,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B75=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B75,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B76=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B76,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B77=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B77,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B78=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B78,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B79=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B79,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B80=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B80,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B81=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B81,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B82=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B82,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B83=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B83,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B84=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B84,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B85=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B85,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B86=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B86,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B87=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B87,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B88=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B88,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B89=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B89,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B90=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B90,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B91=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B91,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B92=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B92,Equipment_Type,0)))","v":0}]
[null,0,{"$f":"IF(Number_Beds_Small=0,0,I93*$L93)","v":0},{"$f":"IF(Number_Beds_Medium=0,0,J93*$L93)","v":0},{"$f":"IF(Number_Beds_Large=0,0,K93*$L93)","v":0},{"$f":"IF(C93=0,0,C93/C$139)","v":0},{"$f":"IF(D93=0,0,D93/D$139)","v":0},{"$f":"IF(E93=0,0,E93/E$139)","v":0},{"$f":"IF(B93=0,0,INDEX(Equipment_Units_Small,MATCH(B93,Equipment_Type,0)))","v":0},{"$f":"IF(B93=0,0,INDEX(Equipment_Units_Med,MATCH(B93,Equipment_Type,0)))","v":0},{"$f":"IF(B93=0,0,INDEX(Equipment_Units_Large,MATCH(B93,Equipment_Type,0)))","v":0},{"$f":"IF(B93=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B93,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B94=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B94,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B95=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B95,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B96=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B96,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B97=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B97,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B98=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B98,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B99=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B99,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B100=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B100,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B101=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B101,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B102=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B102,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B103=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B103,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B104=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B104,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B105=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B105,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B106=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B106,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B107=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B107,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B108=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B108,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B109=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B109,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B110=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B110,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B111=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B111,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B112=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B112,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B113=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B113,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B114=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B114,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B115=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B115,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B116=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B116,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B117=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B117,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B118=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B118,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B119=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B119,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B120=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B120,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B121=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B121,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B122=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B122,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B123=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B123,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B124=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B124,Equipment_Type,0)))","v":0}]
[null,0,{"$f":"IF(Number_Beds_Small=0,0,I125*$L125)","v":0},{"$f":"IF(Number_Beds_Medium=0,0,J125*$L125)","v":0},{"$f":"IF(Number_Beds_Large=0,0,K125*$L125)","v":0},{"$f":"IF(C125=0,0,C125/C$139)","v":0},{"$f":"IF(D125=0,0,D125/D$139)","v":0},{"$f":"IF(E125=0,0,E125/E$139)","v":0},{"$f":"IF(B125=0,0,INDEX(Equipment_Units_Small,MATCH(B125,Equipment_Type,0)))","v":0},{"$f":"IF(B125=0,0,INDEX(Equipment_Units_Med,MATCH(B125,Equipment_Type,0)))","v":0},{"$f":"IF(B125=0,0,INDEX(Equipment_Units_Large,MATCH(B125,Equipment_Type,0)))","v":0},{"$f":"IF(B125=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B125,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B126=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B126,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B127=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B127,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B128=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B128,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B129=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B129,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B130=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B130,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B131=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B131,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B132=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B132,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B133=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B133,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B134=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B134,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B135=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B135,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B136=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B136,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B137=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B137,Equipment_Type,0)))","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(B138=0,0,INDEX('1.General_Inputs_Plan&Budget'!$C$118:$C$227,MATCH('4.Equip_Other_Plan&Budget'!B138,Equipment_Type,0)))","v":0}]
[null,"Total Facility Equipment Costs",{"$f":"IF(Number_Beds_Small=0,0,SUM(C29:C138))","v":80750},{"$f":"IF(Number_Beds_Medium=0,0,SUM(D29:D138))","v":128420},{"$f":"IF(Number_Beds_Large=0,0,SUM(E29:E138))","v":0},{"$f":"SUM(F29:F138)","v":1},{"$f":"SUM(G29:G138)","v":1},{"$f":"SUM(H29:H138)","v":0}]
[]
[]
[null,"STEP 2 - ESTIMATE & VALIDATE COSTS OF EQUIPMENT TRANSPORT, DISTRIBUTION AND INSTALLATION "]
[null,"If equipment prices DO NOT include transport, distribution and installation costs, estimate those costs for each facility typology."]
[null,"Transport, distribution and installation costs can be significant, so if they are not included in equipment acquisition value, they can be calculated here"]
[null,"Note: Leave cells blank if transport, distribution and installation cost sare included in equipment acquisition value"]
[]
[null,"2.1. Estimate costs as a percentage of equipment acquisition value for each typology and revise/modify estimates if required"]
[null,"Enter  % of equipment value or user-defined costs. Note that user-defined costs will override any modelled estimates"]
[null,"In Zambia, 20%, 30% & 40% estimates were used based on Unicef experience in country"]
[null,null,null,"Estimated model costs",null,null,"Enter user-defined costs here. Note they override modelled estimates",null,null,"User Notes"]
[null,"Equipment Transport, Distribution and Installation Costs as a % of Equipment Acquisition Value, by Location Typology","% of equipment value",{"$f":"List_Facility_Sizes","v":"Small"},"Medium","",{"$f":"List_Facility_Sizes","v":"Small"},"Medium",""]
[null,{"$f":"List_Costing_Groups","v":"Mid Cost "},0.25,{"$f":"IF(Name_Cost_Mid=\"\", 0, IF(Name_Small=\"\",0,Percent_Equipm_Transport_Mid*Cost_Equipment_Small))","v":20187.5},{"$f":"IF(Name_Cost_Mid=\"\", 0, IF(Name_Medium=\"\",0,Percent_Equipm_Transport_Mid*Cost_Equipment_Medium))","v":32105},{"$f":"IF(Name_Cost_Mid=\"\", 0, IF(Name_Large=\"\",0,Percent_Equipm_Transport_Mid*Cost_Equipment_Large))","v":0},null,30000]
[null,"High Cost",0.3,{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Small=\"\",0,Percent_Equipm_Transport_High*Cost_Equipment_Small))","v":24225},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Medium=\"\",0,Percent_Equipm_Transport_High*Cost_Equipment_Medium))","v":38526},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Large=\"\",0,Percent_Equipm_Transport_High*Cost_Equipment_Large))","v":0},null,35000]
[null,"Very High Cost",0.35,{"$f":"IF(Name_Cost_VHigh=\"\", 0, IF(Name_Small=\"\",0,Percent_Equipm_Transport_VHigh*Cost_Equipment_Small))","v":28262.5},{"$f":"IF(Name_Cost_VHigh=\"\", 0, IF(Name_Medium=\"\",0,Percent_Equipm_Transport_VHigh*Cost_Equipment_Medium))","v":44947},{"$f":"IF(Name_Cost_VHigh=\"\", 0, IF(Name_Large=\"\",0,Percent_Equipm_Transport_VHigh*Cost_Equipment_Large))","v":0},null,41000]
[]
[null,"2.2. Review costs that will be used for final results"]
[]
[null,"Final transport, distribution & installation costs by typology",null,{"$f":"List_Facility_Sizes","v":"Small"},"Medium",""]
[null,{"$f":"List_Costing_Groups","v":"Mid Cost "},null,{"$f":"IF(Name_Cost_Mid=\"\", 0, IF(Name_Small=\"\",0,IF(G152>0,G152,D152)))","v":20187.5},{"$f":"IF(Name_Cost_Mid=\"\", 0, IF(Name_Medium=\"\",0,IF(H152>0,H152,E152)))","v":30000},{"$f":"IF(Name_Cost_Mid=\"\", 0, IF(Name_Large=\"\",0,IF(I152>0,I152,F152)))","v":0}]
[null,"High Cost",null,{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Small=\"\",0,IF(G153>0,G153,D153)))","v":24225},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Medium=\"\",0,IF(H153>0,H153,E153)))","v":35000},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Large=\"\",0,IF(I153>0,I153,F153)))","v":0}]
[null,"Very High Cost",null,{"$f":"IF(Name_Cost_VHigh=\"\", 0, IF(Name_Small=\"\",0,IF(G154>0,G154, D154)))","v":28262.5},{"$f":"IF(Name_Cost_VHigh=\"\", 0, IF(Name_Medium=\"\",0,IF(H154>0,H154, E154)))","v":41000},{"$f":"IF(Name_Cost_VHigh=\"\", 0, IF(Name_Large=\"\",0,IF(I154>0,I154,F154)))","v":0}]
[]
[]
[null,"STEP 3. ESTIMATE & VALIDATE ANNUAL COSTS OF EQUIPMENT CONSUMABLES AND RENEWABLES"]
[]
[null,"3.1. Estimate costs as a percentage of equipment acquisition value for each typology and revise/modify estimates if required"]
[null,"Enter  % of equipment value or user-defined costs. Note that user-defined costs will override any modelled estimates"]
[null,"Note UNICEF experience in India & Zambia suggests 30% to 40% might be reasonable estimates. A similar range was provided by government officials in Ghana."]
[null,null,null,"Estimated model costs",null,null,{"$f":"G150","v":"Enter user-defined costs here. Note they override modelled estimates"},null,null,"User Notes"]
[null,"Annual Costs Consumables and Renewables as % of Equipment  Value ","% of Equipment Value",{"$f":"List_Facility_Sizes","v":"Small"},"Medium","",{"$f":"List_Facility_Sizes","v":"Small"},"Medium",""]
[null,{"$f":"List_Costing_Groups","v":"Mid Cost "},0.3,{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Small=\"\",0,Percent_Consumables_Mid*Cost_Equipment_Small))","v":24225},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Medium=\"\",0,Percent_Consumables_Mid*Cost_Equipment_Medium))","v":38526},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Large=\"\",0,Percent_Consumables_Mid*Cost_Equipment_Large))","v":0},null,36000]
[null,"High Cost",0.35,{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Small=\"\",0,Percent_Consumables_High*Cost_Equipment_Small))","v":28262.5},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Medium=\"\",0,Percent_Consumables_High*Cost_Equipment_Medium))","v":44947},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Large=\"\",0,Percent_Consumables_High*Cost_Equipment_Large))","v":0},null,41000]
[null,"Very High Cost",0.4,{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Small=\"\",0,Percent_Consumables_VHigh*Cost_Equipment_Small))","v":32300},{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Medium=\"\",0,Percent_Consumables_VHigh*Cost_Equipment_Medium))","v":51368},{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Large=\"\",0,Percent_Consumables_VHigh*Cost_Equipment_Large))","v":0},null,48000]
[]
[null,"3.2. Review costs that will be used for final results."]
[]
[null,"Final annual costs of consumables and renewables  by typology",null,{"$f":"List_Facility_Sizes","v":"Small"},"Medium",""]
[null,{"$f":"List_Costing_Groups","v":"Mid Cost "},null,{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Small=\"\",0,IF(G171>0,G171,D171)))","v":24225},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Medium=\"\",0,IF(H171>0,H171,E171)))","v":36000},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Large=\"\",0,IF(I171>0,I171,F171)))","v":0}]
[null,"High Cost",null,{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Small=\"\",0,IF(G172>0,G172,D172)))","v":28262.5},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Medium=\"\",0,IF(H172>0,H172,E172)))","v":41000},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Large=\"\",0,IF(I172>0,I172,F172)))","v":0}]
[null,"Very High Cost",null,{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Small=\"\",0,IF(G173>0,G173,D173)))","v":32300},{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Medium=\"\",0,IF(H173>0,H173,E173)))","v":48000},{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Large=\"\",0,IF(I173>0,I173,F173)))","v":0}]
[]
[]
[null,"STEP 4. ESTIMATE & VALIDATE ANNUAL COSTS OF SPARE PARTS"]
[]
[null,"4.1. Estimate costs as a percentage of equipment acquisition value for each typology and revise/modify estimates if required"]
[null,"Enter  % of equipment value or user-defined costs. Note that user-defined costs will override any modelled estimates"]
[null,"Leave cells blank if spare parts costed in Step 5 below (maintenance strategies) "]
[null,null,null,"Estimated model costs",null,null,{"$f":"$G$150","v":"Enter user-defined costs here. Note they override modelled estimates"},null,null,"User Notes"]
[null,"Annual Cost of Spare Parts as % of Equipment Value","%",{"$f":"List_Facility_Sizes","v":"Small"},"Medium","",{"$f":"List_Facility_Sizes","v":"Small"},"Medium",""]
[null,{"$f":"List_Costing_Groups","v":"Mid Cost "},null,{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Small=\"\",0,Percent_Spare_Parts_Mid*Cost_Equipment_Small))","v":0},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Medium=\"\",0,Percent_Spare_Parts_Mid*Cost_Equipment_Medium))","v":0},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Large=\"\",0,Percent_Spare_Parts_Mid*Cost_Equipment_Large))","v":0}]
[null,"High Cost",null,{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Small=\"\",0,Percent_Spare_Parts_High*Cost_Equipment_Small))","v":0},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Medium=\"\",0,Percent_Spare_Parts_High*Cost_Equipment_Medium))","v":0},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Large=\"\",0,Percent_Spare_Parts_High*Cost_Equipment_Large))","v":0}]
[null,"Very High Cost",null,{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Small=\"\",0,Percent_Spare_Parts_VHigh*Cost_Equipment_Small))","v":0},{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Medium=\"\",0,Percent_Spare_Parts_VHigh*Cost_Equipment_Medium))","v":0},{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Large=\"\",0,Percent_Spare_Parts_VHigh*Cost_Equipment_Large))","v":0}]
[]
[null,"4.2. Verify costs that will be used for final results."]
[]
[null,"Final Annual Cost of Spare Parts by Typology",null,{"$f":"List_Facility_Sizes","v":"Small"},"Medium",""]
[null,{"$f":"List_Costing_Groups","v":"Mid Cost "},null,{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Small=\"\",0,IF(G190>0,G190,D190)))","v":0},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Medium=\"\",0,IF(H190>0,H190,E190)))","v":0},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Large=\"\",0,IF(I190>0,I190,F190)))","v":0}]
[null,"High Cost",null,{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Small=\"\",0,IF(G191>0,G191,D191)))","v":0},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Medium=\"\",0,IF(H191>0,H191,E191)))","v":0},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Large=\"\",0,IF(I191>0,I191,F191)))","v":0}]
[null,"Very High Cost",null,{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Small=\"\",0,IF(G192>0,G192,D192)))","v":0},{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Medium=\"\",0,IF(H192>0,H192,E192)))","v":0},{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Large=\"\",0,IF(I192>0,I192,F192)))","v":0}]
[]
[null,"STEP 5. ESTIMATE & VALIDATE ANNUAL COSTS OF MAINTENANCE STRATEGIES (PREVENTIVE & CORRECTIVE)"]
[null,"Note that costs related to human resources, such as specialised staff (i.e. engineers) or mandatory training for health staff should be costed under human resources"]
[null,"Remember to include spare parts if not costed separately"]
[]
[null,"5.1. Estimate costs as a percentage of equipment acquisition value for each typology and revise/modify estimates if required"]
[null,"Enter  % of equipment value or user-defined costs. Note that user-defined costs will override any modelled estimates"]
[null,"Note that these costs are likely to vary across countries. For example, in Zambia, UNICEF experts suggested 10 to 15% might be reasonable for annual expenditure on maintenance. In Ghana government officials estimated annual maintenance costs to range from 8% to 12% "]
[null,null,null,"Estimated model costs",null,null,{"$f":"G150","v":"Enter user-defined costs here. Note they override modelled estimates"},null,null,"User Notes"]
[null,"Maintenance strategies as  % of equipment acquisition value","%",{"$f":"List_Facility_Sizes","v":"Small"},"Medium","",{"$f":"List_Facility_Sizes","v":"Small"},"Medium",""]
[null,{"$f":"List_Costing_Groups","v":"Mid Cost "},0.08,{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Small=\"\",0,Percent_Maintenance_Mid*Cost_Equipment_Small))","v":6460},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Medium=\"\",0,Percent_Maintenance_Mid*Cost_Equipment_Medium))","v":10273.6},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Large=\"\",0,Percent_Maintenance_Mid*Cost_Equipment_Large))","v":0}]
[null,"High Cost",0.1,{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Small=\"\",0,Percent_Maintenance_High*Cost_Equipment_Small))","v":8075},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Medium=\"\",0,Percent_Maintenance_High*Cost_Equipment_Medium))","v":12842},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Large=\"\",0,Percent_Maintenance_High*Cost_Equipment_Large))","v":0}]
[null,"Very High Cost",0.12,{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Small=\"\",0,Percent_Maintenance_VHigh*Cost_Equipment_Small))","v":9690},{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Medium=\"\",0,Percent_Maintenance_VHigh*Cost_Equipment_Medium))","v":15410.4},{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Large=\"\",0,Percent_Maintenance_VHigh*Cost_Equipment_Large))","v":0}]
[]
[null,"5.2. Review costs that will be used for final results."]
[]
[null,"Final Annual Costs of Preventive and Corrective Maintenance Strategies",null,{"$f":"List_Facility_Sizes","v":"Small"},"Medium",""]
[null,{"$f":"List_Costing_Groups","v":"Mid Cost "},null,{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Small=\"\",0,IF(G$210>0,G210,D210)))","v":6460},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Medium=\"\",0,IF(H$210>0,H210,E210)))","v":10273.6},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Large=\"\",0,IF(I$210>0,I210,F210)))","v":0}]
[null,"High Cost",null,{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Small=\"\",0,IF(G$211>0,G211,D211)))","v":8075},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Medium=\"\",0,IF(H$211>0,H211,E211)))","v":12842},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Large=\"\",0,IF(I$211>0,I211,F211)))","v":0}]
[null,"Very High Cost",null,{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Small=\"\",0,IF(G$212>0,G212,D212)))","v":9690},{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Medium=\"\",0,IF(H$212>0,H212,E212)))","v":15410.4},{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Large=\"\",0,IF(I$212>0,I212,F212)))","v":0}]
[]
[]
[null,"STEP 6. REVIEW TOTAL ANNUAL COSTS OF SPARE PARTS + MAINTENANCE STRATEGIES"]
[null,"Review that estimated annual maintenance costs, including spare parts, are adequate"]
[]
[null,"Review of Total Annual Maintenance Costs (Spare Parts + Preventive & Corrective) by Typology",null,{"$f":"List_Facility_Sizes","v":"Small"},"Medium",""]
[null,{"$f":"List_Costing_Groups","v":"Mid Cost "},null,{"$f":"D217+D197","v":6460},10273.6,0]
[null,"High Cost",null,8075,12842,0]
[null,"Very High Cost",null,9690,15410.4,0]
[]
[]
[null,"STEP 7.  ESTIMATE & VALIDATE EQUIPMENT BUFFER STOCKS REQUIRED"]
[null,"Note that although buffer stocks are most likely to be managed at regional levey, they are costed as a % of facility equipment acquisition value"]
[]
[null,"7.1. Estimate the expected one-off costs of buffer stocks (inclusive of transport/distribution)  as a % of equipment replacement value. Leave blank if none."]
[null,"Enter the expected cost (as a percentage of equipment value) of any buffer stocks required. "]
[null,"The tool calculations assume this is a percentage of new equipment value (excluding distribution costs) "]
[null,"In some instances, UNICEF recommends 10% of buffer stocks to be managed at regional level."]
[]
[null,"Once-Off Equipment Buffer Stock Costs as % of equipment value","%","User Notes"]
[null,{"$f":"List_Costing_Groups","v":"Mid Cost "}]
[null,"High Cost"]
[null,"Very High Cost"]
[]
[null,"7.2. Review Once-Off Equipment Buffer Stock Costs by Facility Typology "]
[]
[null,"Once-Off Equipment Buffer Stock Costs",{"$f":"List_Facility_Sizes","v":"Small"},"Medium",""]
[null,{"$f":"List_Costing_Groups","v":"Mid Cost "},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Small=\"\",0,Percent_Buffer_Stock_Mid*Cost_Equipment_Small))","v":0},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Medium=\"\",0,Percent_Buffer_Stock_Mid*Cost_Equipment_Medium))","v":0},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Large=\"\",0,Percent_Buffer_Stock_Mid*Cost_Equipment_Large))","v":0}]
[null,"High Cost",{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Small=\"\",0,Percent_Buffer_Stock_High*Cost_Equipment_Small))","v":0},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Medium=\"\",0,Percent_Buffer_Stock_High*Cost_Equipment_Medium))","v":0},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Large=\"\",0,Percent_Buffer_Stock_High*Cost_Equipment_Large))","v":0}]
[null,"Very High Cost",{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Small=\"\",0,Percent_Buffer_Stock_VHigh*Cost_Equipment_Small))","v":0},{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Medium=\"\",0,Percent_Buffer_Stock_VHigh*Cost_Equipment_Medium))","v":0},{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Large=\"\",0,Percent_Buffer_Stock_VHigh*Cost_Equipment_Large))","v":0}]
[]
[]
[null,"STEP 8. ESTIMATE & VALIDATE COSTS OF ADDITIONAL FACILITY FURNITURE & EQUIPMENT, INCLUDING OFFICE EQUIPMENT"]
[]
[null,"8.1. Enter acquisition costs of office & communications equipment required for other model of care components such as data systems & referrals and general management of the unit"]
[null,"Include items such as laptops, printers, mobile/landline phones required to support referrals, data systems and general administration of the level 2 newborn care unit. Also include here other devices you want individually itemized (e.g. fuel generator)."]
[null,"Enter total amount, not percentages. In User Notes enter what is included (i.e. number of items) and their main purpose (i.e. to support referrals)"]
[]
[null,"Major equipment, inc. Office & Communications equipment for other components of care (inc.  referral & data systems) and unit management",{"$f":"List_Facility_Sizes","v":"Small"},"Medium","","User Notes"]
[null,null,"($)","($)","($)"]
[null,"Computer & printer",2000,2000]
[null,"Phones",1000,1000]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Acquisition Costs of Office & Communications Equipment",{"$f":"IF(Name_Small=\"\",0,SUM(C260:C269))","v":3000},{"$f":"IF(Name_Medium=\"\",0,SUM(D260:D269))","v":3000},{"$f":"IF(Name_Large=\"\",0,SUM(E260:E269))","v":0}]
[]
[]
[null,"8.2. Enter acquisition costs of other facility and office furniture & equipment not included elsewhere. "]
[null,"Facility level costs should be entered here to ensure these expenses are properly accounted for."]
[null,"Can include costs for furniture items, such as staff office chairs and desks, wardrobes and mothers' beds, as well as TVs or other equipment such as medicine trolleys not costed elsewhere."]
[null,"Remember to include here any personal protective equipment for infection prevention and control if it has not been accounted for earlier."]
[null,"Enter total amount, not percentages. "]
[null,"Additional facility furniture and equipment",{"$f":"List_Facility_Sizes","v":"Small"},"Medium","","User Notes"]
[null,null,"($)","($)","($)"]
[null,"Acquisition Costs of Furniture & Other Equipment",20000,20000]
[]
[null,"8.3. Enter distribution costs for location typologies as a percentage of furniture & other equipment acquisition value. Leave blank if distribution costs included in acquisition costs"]
[null,"Note: These costs are expected to be lower than for medical equipment due to issues such as installation."]
[]
[null,"Distribution costs by location typology","% of furniture & equipment value","User Notes"]
[null,{"$f":"List_Costing_Groups","v":"Mid Cost "},0]
[null,"High Cost",0.05]
[null,"Very High Cost",0.08]
[]
[null,"8.4. Review Costs of Furniture, Office Equipment & Other (Acquisition value + distribution) by typology and revise/modify estimates if required"]
[null,null,null,null,null,"Enter user-defined costs here. Note they override modelled estimates",null,null,"User Notes"]
[null,"Costs of Furniture, Office Equipment & Other (including distribution)  by Typology",{"$f":"List_Facility_Sizes","v":"Small"},"Medium","",{"$f":"List_Facility_Sizes","v":"Small"},"Medium",""]
[null,{"$f":"List_Costing_Groups","v":"Mid Cost "},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Small=\"\",0,(C$280+C$270)*(1+$C286)))","v":23000},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Medium=\"\",0,(D$280+D$270)*(1+$C286)))","v":23000},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Large=\"\",0,(E$280+E$270)*(1+$C286)))","v":0}]
[null,"High Cost",{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Small=\"\",0,(C$280+C$270)*(1+$C287)))","v":24150},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Medium=\"\",0,(D$280+D$270)*(1+$C287)))","v":24150},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Large=\"\",0,(E$280+E$270)*(1+$C287)))","v":0}]
[null,"Very High Cost",{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Small=\"\",0,(C$280+C$270)*(1+$C288)))","v":24840},{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Medium=\"\",0,(D$280+D$270)*(1+$C288)))","v":24840},{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Large=\"\",0,(E$280+E$270)*(1+$C288)))","v":0}]
[]
[]
[null,"8.5. Review costs that will be used for final results."]
[]
[null,"Final Costs of Furniture, Office Equipment & Other",{"$f":"List_Facility_Sizes","v":"Small"},"Medium",""]
[null,{"$f":"List_Costing_Groups","v":"Mid Cost "},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Small=\"\",0,IF(F293>0,F293,C293)))","v":23000},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Medium=\"\",0,IF(G293>0,G293,D293)))","v":23000},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Large=\"\",0,IF(H293>0,H293,E293)))","v":0}]
[null,"High Cost",{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Small=\"\",0,IF(F294>0,F294,C294)))","v":24150},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Medium=\"\",0,IF(G294>0,G294,D294)))","v":24150},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Large=\"\",0,IF(H294>0,H294,E294)))","v":0}]
[null,"Very High Cost",{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Small=\"\",0,IF(F295>0,F295,C295)))","v":24840},{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Medium=\"\",0,IF(G295>0,G295,D295)))","v":24840},{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Large=\"\",0,IF(H295>0,H295,E295)))","v":0}]
[]
[null,"STEP 9. ESTIMATE DIFFERENTIAL NEEDS OF EQUIPMENT AND FURNITURE BY TYPOLOGY"]
[]
[null,"Enter % of equipment and furniture investments needed by typology"]
[null,"Adjusts capital investments needed at each typology, based on current availability"]
[null,"The higher the percentage, the higher the capital investment required"]
[null,"To estimate the cost of fully equipping and furnishing a facility enter 100% under major need"]
[]
["Key table/cells for VBA","Facilities in need of essential equipment:","As % of acquisition value",null,"User Notes"]
[{"$f":"IF(Name_Equipment_Need_Major=\"\",0,C313)","v":1},{"$f":"IF('1.General_Inputs_Plan&Budget'!C50=\"Yes\",_xlfn.CONCAT('1.General_Inputs_Plan&Budget'!B50, \" need\"), \"\")","v":"Major need"},1]
[{"$f":"IF(Name_Equipment_Need_Partial=\"\",0,C314)","v":0.45},{"$f":"IF('1.General_Inputs_Plan&Budget'!C51=\"Yes\",_xlfn.CONCAT('1.General_Inputs_Plan&Budget'!B51, \" need\"), \"\")","v":"Partial need"},0.45]
[{"$f":"IF(Name_Equipment_Need_Limited=\"\",0,C315)","v":0.15},{"$f":"IF('1.General_Inputs_Plan&Budget'!C52=\"Yes\",_xlfn.CONCAT('1.General_Inputs_Plan&Budget'!B52, \" need\"), \"\")","v":"Limited need"},0.15]
[]
[]
[null,"STEP 10. ESTIMATE COSTS OF MEDICINES & SUPPLIES NOT COSTED AS PART OF EQUIPMENT CONSUMABLES"]
[]
[null,"10.1. Enter estimated costs of medicines & supplies per newborn admission"]
[null,"Note that equipment consumables including reagents that have been costed above should not be included here"]
[null,null,null,null,"User Notes"]
[null,"Annual costs of medicines & supplies per newborn admission ($):",8]
[]
[null,"10.2. Review costs of medicines & supplies by typology after applying cost loadings from inputs and enter revised estimates if required"]
[null,"Costs are estimated based on the number of admissions at each facility and adjusted by cost loadings/mark-ups for facility location/cost typologies"]
[null,"If required, use the dark-blue cells to override modelled estimates."]
[null,null,"Estimated model costs",null,null,{"$f":"'4.Equip_Other_Plan&Budget'!$G$150","v":"Enter user-defined costs here. Note they override modelled estimates"},null,null,"User Notes"]
[null,"Annual costs of medicines & supplies by Facility Typology",{"$f":"List_Facility_Sizes","v":"Small"},"Medium","",{"$f":"List_Facility_Sizes","v":"Small"},"Medium",""]
[null,{"$f":"List_Costing_Groups","v":"Mid Cost "},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Small=\"\",0,CostPerAdmission_Drugs*Admissions_Small*(1+Percent_Loading_Mid)))","v":5384},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Medium=\"\",0,CostPerAdmission_Drugs*Admissions_Medium*(1+Percent_Loading_Mid)))","v":10760},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Large=\"\",0,CostPerAdmission_Drugs*Admissions_Large*(1+Percent_Loading_Mid)))","v":0}]
[null,"High Cost",{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Small=\"\",0,CostPerAdmission_Drugs*Admissions_Small*(1+Percent_Loading_High)))","v":5922.4000000000005},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Medium=\"\",0,CostPerAdmission_Drugs*Admissions_Medium*(1+Percent_Loading_High)))","v":11836.000000000002},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Large=\"\",0,CostPerAdmission_Drugs*Admissions_Large*(1+Percent_Loading_High)))","v":0}]
[null,"Very High Cost",{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Small=\"\",0,CostPerAdmission_Drugs*Admissions_Small*(1+Percent_Loading_VHigh)))","v":6460.8},{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Medium=\"\",0,CostPerAdmission_Drugs*Admissions_Medium*(1+Percent_Loading_VHigh)))","v":12912},{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Large=\"\",0,CostPerAdmission_Drugs*Admissions_Large*(1+Percent_Loading_VHigh)))","v":0}]
[]
[null,"10.3. Review costs that will be used for final results."]
[]
[null,"Check annual facility costs of medicines & supplies to be used",{"$f":"List_Facility_Sizes","v":"Small"},"Medium",""]
[null,{"$f":"List_Costing_Groups","v":"Mid Cost "},{"$f":"IF(Name_Cost_Mid=\"\",0, IF(Name_Small=\"\",0,IF(F330>0,F330,C330)))","v":5384},{"$f":"IF(Name_Cost_Mid=\"\",0, IF(Name_Medium=\"\",0,IF(G330>0,G330,D330)))","v":10760},{"$f":"IF(Name_Cost_Mid=\"\",0, IF(Name_Large=\"\",0,IF(H330>0,H330,E330)))","v":0}]
[null,"High Cost",{"$f":"IF(Name_Cost_High=\"\",0, IF(Name_Small=\"\",0,IF(F331>0,F331,C331)))","v":5922.4000000000005},{"$f":"IF(Name_Cost_High=\"\",0, IF(Name_Medium=\"\",0,IF(G331>0,G331,D331)))","v":11836.000000000002},{"$f":"IF(Name_Cost_High=\"\",0, IF(Name_Large=\"\",0,IF(H331>0,H331,E331)))","v":0}]
[null,"Very High Cost",{"$f":"IF(Name_Cost_VHigh=\"\",0, IF(Name_Small=\"\",0,IF(F332>0,F332,C332)))","v":6460.8},{"$f":"IF(Name_Cost_VHigh=\"\",0, IF(Name_Medium=\"\",0,IF(G332>0,G332,D332)))","v":12912},{"$f":"IF(Name_Cost_VHigh=\"\",0, IF(Name_Large=\"\",0,IF(H332>0,H332,E332)))","v":0}]

{"sheet":"5.Human_Resources_Plan&Budget","index":5,"n_rows":266,"n_cols":12,"rows_kept":266,"cut":false,"hidden":false,"merged":[[262,8,262,11],[263,8,263,11],[264,8,264,11],[265,8,265,11],[243,2,243,4],[258,2,258,4],[243,5,243,7],[248,8,248,11],[249,8,249,11],[250,8,250,11],[257,2,257,7],[257,8,259,11],[261,8,261,11],[246,8,246,11],[247,8,247,11],[204,5,204,7],[210,5,210,7],[210,8,210,11],[211,8,214,11],[199,5,199,7],[200,5,200,7],[201,5,201,7],[202,5,202,7],[203,5,203,7],[205,5,205,7],[243,1,244,1],[242,2,242,7],[242,8,244,11],[245,8,245,11],[206,5,206,7],[41,5,41,8],[42,5,42,8],[258,1,259,1],[258,5,258,7],[260,8,260,11],[165,6,166,6],[165,1,166,1],[165,2,165,4],[55,2,55,4],[55,5,55,7],[82,5,82,7],[109,2,109,4],[109,5,109,7],[82,2,82,4],[165,8,166,8],[181,5,181,7],[36,5,36,8],[37,5,37,8],[38,5,38,8],[39,5,39,8],[40,5,40,8],[3,1,3,3],[4,1,4,3],[9,1,9,3],[7,1,7,3],[5,1,5,3],[6,1,6,3],[33,5,33,8],[34,5,34,8],[35,5,35,8],[29,2,29,4],[29,5,30,8],[31,5,31,8],[32,5,32,8],[51,5,51,8],[147,5,147,7],[45,5,45,8],[46,5,46,8],[47,5,47,8],[48,5,48,8],[49,5,49,8],[2,1,2,11],[28,1,28,8],[164,1,164,8],[198,2,198,4],[181,8,181,11],[165,5,166,5],[165,7,166,7],[148,5,148,7],[165,9,165,11],[182,8,182,11],[183,8,183,11],[184,8,184,11],[185,8,185,11],[43,5,43,8],[44,5,44,8],[50,5,50,8]]}
[]
[null," HUMAN RESOURCES - PLANNING & BUDGETING"]
[null,"WARNING: Do not copy and paste data into this workbook. Doing so may insert conflicting code and remove validation. Please enter data manually to ensure proper functionality"]
[null,"MODULE OVERVIEW"]
[null,"Set country standards for Human Resources at each facility size typology & estimate associated costs"]
[null,"* Enter numbers of FTE facility staff required, as per country standards"]
[null,"* Review annual cost of staff salaries by typology"]
[null,"Set country standards for Human Resource Development Strategies & estimate facility costs"]
[null,"* Supervision/Mentoring/Coaching Visits"]
[null,"* Mandatory in-service training for all staff (clinical and ancillary)"]
[null,"Note that higher education courses to upskill workforce are costed at national level in the QoC National and Regional Strategies Module"]
[null,"* Other Human Resource Development Strategies"]
[null,"Identify and cost recruitment and retention strategies for hard-to-recruit and most challenging recruitment areas"]
[null,"* Identify strategies and estimate capital costs, such as those related to housing infrastructure or purchasing of motorbikes or other transport vehicles"]
[null,"* Identify strategies and estimate recurrent annual costs, such as those related to additional opportunities for professional collaboration and development"]
[null,"Note that strategies applicable to all areas, including standard, should be identified and costed in the previous steps or as part of Quality of Care Facility strategies"]
[null,"Remember:"]
[null,"Light blue cells are user inputs."]
[null,"Yellow cells are tool calculations not to be manually changed"]
[null,"If required, cells in dark blue can be used for overriding modelled estimates "]
[]
[null,"STEP 1 - ENTER & VALIDATE REQUIRED NUMBERS OF CLINICAL AND SUPPORT STAFF & REVIEW COSTS BY FACILITY TYPOLOGY"]
[]
[null,"1.1. Enter required FTE staff numbers for each facility size typology"]
[null,"Required FTE numbers should be sourced from country standards and guidelines."]
[null,"* Staff requirements should account for expected workload, including clinical & administrative tasks related to all components of care"]
[null,"If country guidelines are not available, as a starting point for discussions in country, staff ratios can be sourced from international guidelines or relevant GFF reports"]
[null,"If typology is not costed or staff not required, enter 0 or leave blank"]
[]
[null,null,"Required FTE per facility",null,null,"User Notes"]
[null,{"$f":"Staff_Category","v":"Staff Category (Clinical & Support)"},{"$f":"List_Facility_Sizes","v":"Small"},"Medium",""]
[null,"Neonatologist ",1,1]
[null,"Medical Doctor",1,2]
[null,"Registered Neonatal Nurse",5,11]
[null,"Registered Nurse",8,15]
[null,"Ward assistant/Public Health Nurse",1,1]
[null,"Biomedical engineer",0.2,0.2]
[null,"Ambulance driver",1,1]
[null,"Cleaner",2,3]
[null,"Other staff to be individually defined & costed",1,1.3,null,"Remember this is a catch-all category built for the training dataset"]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[]
[null,"1.2  Review facility staff costs by staff category for standard recruiting areas "]
[]
[null,"STANDARD RECRUITING AREAS - ESSENTIAL STAFF","Annual Cost ($)",null,null,"Percentage (%)",null,null,"Unit costs from inputs"]
[null,{"$f":"Staff_Category","v":"Staff Category (Clinical & Support)"},{"$f":"List_Facility_Sizes","v":"Small"},"Medium","",{"$f":"List_Facility_Sizes","v":"Small"},"Medium","",{"$f":"IF(Name_HR_Standard=\"\",\"\",Staff_Salaries_Standard)","v":"Annual costs inc. salaries, allowances, etc."}," "]
[null,"Neonatologist ",{"$f":"IF(OR(Number_Beds_Small=0,Name_HR_Standard=\"\"),0,$C32*$I58)","v":11000},{"$f":"IF(OR(Number_Beds_Medium=0,,Name_HR_Standard=\"\"),0,$D32*$I58)","v":11000},{"$f":"IF(OR(Number_Beds_Large=0,,Name_HR_Standard=\"\"),0,$E32*$I58)","v":0},{"$f":"IF(OR(Number_Beds_Small=0,Name_HR_Standard=\"\"),0,IF(C58=0,0,C58/C$79))","v":7.8459343794579167E-2},{"$f":"IF(OR(Number_Beds_Medium=0,Name_HR_Standard=\"\"),0,IF(D58=0,0,D58/D$79))","v":4.8097944905990384E-2},{"$f":"IF(OR(Number_Beds_Large=0,Name_HR_Standard=\"\"),0,IF(E58=0,0,E58/E$79))","v":0},11000]
[null,"Medical Doctor",8000,16000,0,5.7061340941512127E-2,6.9960647135986001E-2,0,8000]
[null,"Registered Neonatal Nurse",30000,66000,0,0.21398002853067047,0.28858766943594227,0,6000]
[null,"Registered Nurse",32000,60000,0,0.22824536376604851,0.26235242675994752,0,4000]
[null,"Ward assistant/Public Health Nurse",2000,2000,0,1.4265335235378032E-2,8.7450808919982501E-3,0,2000]
[null,"Biomedical engineer",1200,1200,0,8.5592011412268191E-3,5.2470485351989509E-3,0,6000]
[null,"Ambulance driver",3000,3000,0,2.1398002853067047E-2,1.3117621337997376E-2,0,3000]
[null,"Cleaner",3000,4500,0,2.1398002853067047E-2,1.9676432006996064E-2,0,1500]
[null,"Other staff to be individually defined & costed",50000,65000,0,0.35663338088445079,0.28421512898994317,0,50000]
[null,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0]
[null,"Annual Staff Costs ",{"$f":"IF(Number_Beds_Small=0,0,IF(Name_HR_Standard=\"\",0,(SUM(C58:C78))))","v":140200},{"$f":"IF(Number_Beds_Medium=0,0,IF(Name_HR_Standard=\"\",0,(SUM(D58:D78))))","v":228700},{"$f":"IF(Number_Beds_Large=0,0,IF(Name_HR_Standard=\"\",0,(SUM(E58:E78))))","v":0},{"$f":"SUM(F58:F78)","v":1},{"$f":"SUM(G58:G78)","v":1},{"$f":"SUM(H58:H73)","v":0}]
[]
[null,"1.3  Review facility staff costs by staff category for Hard-to-Recruit areas."]
[]
[null,"HARD-TO-RECRUIT AREAS  - ESSENTIAL STAFF",{"$f":"C56","v":"Annual Cost ($)"},null,null,{"$f":"F56","v":"Percentage (%)"},null,null,{"$f":"I56","v":"Unit costs from inputs"}]
[null,{"$f":"Staff_Category","v":"Staff Category (Clinical & Support)"},{"$f":"List_Facility_Sizes","v":"Small"},"Medium","",{"$f":"List_Facility_Sizes","v":"Small"},"Medium","",{"$f":"IF(Name_HR_HardRecruit=\"\", \"\",Staff_Salaries_Hard_to_recruit)","v":"Annual costs inc. salaries, allowances, recruitment area incentives"}]
[null,"Neonatologist ",{"$f":"IF(OR(Number_Beds_Small=0,Name_HR_HardRecruit=\"\"),0,$C32*$I85)","v":13750},{"$f":"IF(OR(Number_Beds_Medium=0,Name_HR_HardRecruit=\"\"),0,$D32*I85)","v":13750},{"$f":"IF(OR(Number_Beds_Large=0,Name_HR_HardRecruit=\"\"),0,$E32*$I85)","v":0},{"$f":"IF(OR(Number_Beds_Small=0,Name_HR_HardRecruit=\"\"),0,IF(C85=0,0,C85/C$106))","v":7.3235685752330221E-2},{"$f":"IF(OR(Number_Beds_Medium=0,Name_HR_HardRecruit=\"\"),0,IF(D85=0,0,D85/D$106))","v":4.5510964004964835E-2},{"$f":"IF(OR(Number_Beds_Large=0,Name_HR_HardRecruit=\"\"),0,IF(E85=0,0,E85/E$106))","v":0},13750]
[null,"Medical Doctor",{"$f":"IF(OR(Number_Beds_Small=0,Name_HR_HardRecruit=\"\"),0,$C33*$I86)","v":10000},20000,0,5.3262316910785618E-2,6.619776582540339E-2,0,10000]
[null,"Registered Neonatal Nurse",37500,82500,0,0.19973368841544606,0.27306578402978898,0,7500]
[null,"Registered Nurse",40000,75000,0,0.21304926764314247,0.24824162184526272,0,5000]
[null,"Ward assistant/Public Health Nurse",2500,2500,0,1.3315579227696404E-2,8.2747207281754238E-3,0,2500]
[null,"Biomedical engineer",1500,1500,0,7.989347536617843E-3,4.9648324369052548E-3,0,7500]
[null,"Ambulance driver",3750,3750,0,1.9973368841544607E-2,1.2412081092263137E-2,0,3750]
[null,"Cleaner",3750,5625,0,1.9973368841544607E-2,1.8618121638394703E-2,0,1875]
[null,"Other staff to be individually defined & costed",75000,97500,0,0.39946737683089212,0.32271410839884151,0,75000]
[null,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0]
[null,"Annual Staff Costs ",{"$f":"IF(OR(Number_Beds_Small=0,Name_HR_HardRecruit=\"\"),0,(SUM(C85:C105)))","v":187750},{"$f":"IF(OR(Number_Beds_Medium=0,Name_HR_HardRecruit=\"\"),0,(SUM(D85:D105)))","v":302125},{"$f":"IF(OR(Number_Beds_Large=0,Name_HR_HardRecruit=\"\"),0,(SUM(E85:E105)))","v":0},{"$f":"SUM(F85:F105)","v":1},{"$f":"SUM(G85:G105)","v":1},{"$f":"SUM(H85:H105)","v":0}]
[]
[null,"1.4  Review facility staff costs by staff category for Most Challenging to Recruit areas."]
[]
[null,"MOST CHALLENGING TO RECRUIT AREAS  - ESSENTIAL STAFF",{"$f":"C56","v":"Annual Cost ($)"},null,null,{"$f":"F56","v":"Percentage (%)"},null,null,{"$f":"I83","v":"Unit costs from inputs"}]
[null,{"$f":"Staff_Category","v":"Staff Category (Clinical & Support)"},{"$f":"List_Facility_Sizes","v":"Small"},"Medium","",{"$f":"List_Facility_Sizes","v":"Small"},"Medium","",{"$f":"IF(Name_HR_HardRecruit=\"\", \"\",Staff_Salaries_VHard_to_recruit)","v":""}]
[null,"Neonatologist ",{"$f":"IF(OR(Number_Beds_Small=0,Name_HR_HardRecruit=\"\"),0,$C32*$I112)","v":0},{"$f":"IF(OR(Number_Beds_Medium=0,Name_HR_HardRecruit=\"\"),0,$D32*I112)","v":0},{"$f":"IF(OR(Number_Beds_Large=0,Name_HR_HardRecruit=\"\"),0,$E32*$I112)","v":0},{"$f":"IF(OR(Number_Beds_Small=0,Name_HR_HardRecruit=\"\"),0,IF(C112=0,0,C112/C$133))","v":0},{"$f":"IF(OR(Number_Beds_Medium=0,Name_HR_HardRecruit=\"\"),0,IF(D112=0,0,D112/D$133))","v":0},{"$f":"IF(OR(Number_Beds_Large=0,Name_HR_HardRecruit=\"\"),0,IF(E112=0,0,E112/E$133))","v":0},0]
[null,"Medical Doctor",0,0,0,0,0,0,0]
[null,"Registered Neonatal Nurse",0,0,0,0,0,0,0]
[null,"Registered Nurse",0,0,0,0,0,0,0]
[null,"Ward assistant/Public Health Nurse",0,0,0,0,0,0,0]
[null,"Biomedical engineer",0,0,0,0,0,0,0]
[null,"Ambulance driver",0,0,0,0,0,0,0]
[null,"Cleaner",0,0,0,0,0,0,0]
[null,"Other staff to be individually defined & costed",0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0]
[null,0,0,0,0,{"$f":"IF(OR(Number_Beds_Small=0,Name_HR_HardRecruit=\"\"),0,IF(C132=0,0,C132/C$106))","v":0},0,0,0]
[null,"Annual Staff Costs ",{"$f":"IF(OR(Number_Beds_Small=0,Name_HR_VHardRecruit=\"\"),0,(SUM(C112:C132)))","v":0},{"$f":"IF(OR(Number_Beds_Medium=0,Name_HR_VHardRecruit=\"\"),0,(SUM(D112:D132)))","v":0},{"$f":"IF(OR(Number_Beds_Large=0,Name_HR_VHardRecruit=\"\"),0,(SUM(E112:E132)))","v":0},{"$f":"SUM(F112:F132)","v":0},{"$f":"SUM(G112:G132)","v":0},{"$f":"SUM(H112:H132)","v":0}]
[]
[null,"1.5. Review total facility staff salaries by typology."]
[null,"Results will be 0 if typology not included"]
[]
[null,"Annual Cost of Facility Staff Salaries",{"$f":"List_Facility_Sizes","v":"Small"},"Medium",""]
[null,{"$f":"Name_HR_Standard","v":"Standard area"},{"$f":"C79","v":140200},{"$f":"D79","v":228700},{"$f":"E79","v":0}]
[null,{"$f":"Name_HR_HardRecruit","v":"Hard-to-Recruit"},{"$f":"C106","v":187750},{"$f":"D106","v":302125},{"$f":"E106","v":0}]
[null,{"$f":"Name_HR_VHardRecruit","v":""},{"$f":"C133","v":0},{"$f":"D133","v":0},0]
[]
[]
[null,"STEP 2 - COST MENTORING/SUPERVISION/COACHING VISITS"]
[null,"Estimate the costs of mentoring/supervision/coaching visits based on unit costs entered under General Inputs"]
[null,"2.1. Enter number of mentoring/supervision/coaching visits to each facility required in a year:"]
[]
[null,null,{"$f":"List_Facility_Sizes","v":"Small"},"Medium","","User Notes"]
[null,"Number of annual mentoring/supervision visits by regional staff to each facility =",4,4]
[]
[null,"2.2. Review estimated annual costs of mentoring and supervision by facility size and cost/location typology after applying cost loadings from inputs"]
[]
[null,"Mentoring/Supervision/Coaching ",{"$f":" List_Facility_Sizes","v":"Small"},"Medium","","Unit costs - See General Inputs Step 6.2"]
[null,{"$f":"List_Costing_Groups","v":"Mid Cost "},{"$f":"IF(Name_Small=\"\",0,IF(Name_Cost_Mid=\"\",0,C$149*(Price_SupervisionVisit*(1+Percent_Loading_Mid))))","v":380},{"$f":"IF(Name_Medium=\"\",0,IF(Name_Cost_Mid=\"\",0,D$149*(Price_SupervisionVisit*(1+Percent_Loading_Mid))))","v":380},{"$f":"IF(Name_Large=\"\",0,IF(Name_Cost_Mid=\"\",0,E$149*(Price_SupervisionVisit*(1+Percent_Loading_Mid))))","v":0},{"$f":"'1.General_Inputs_Plan&Budget'!C293","v":95}]
[null,"High Cost",{"$f":"IF(Name_Small=\"\",0,IF(Name_Cost_High=\"\",0,C$149*(Price_SupervisionVisit*(1+Percent_Loading_High))))","v":418.00000000000006},{"$f":"IF(Name_Medium=\"\",0,IF(Name_Cost_High=\"\",0,D$149*(Price_SupervisionVisit*(1+Percent_Loading_High))))","v":418.00000000000006},{"$f":"IF(Name_Large=\"\",0,IF(Name_Cost_High=\"\",0,E$149*(Price_SupervisionVisit*(1+Percent_Loading_High))))","v":0},{"$f":"'1.General_Inputs_Plan&Budget'!C294","v":104.50000000000001}]
[null,"Very High Cost",{"$f":"IF(Name_Small=\"\",0,IF(Name_Cost_VHigh=\"\",0,C$149*(Price_SupervisionVisit*(1+Percent_Loading_VHigh))))","v":456},{"$f":"IF(Name_Medium=\"\",0,IF(Name_Cost_VHigh=\"\",0,D$149*(Price_SupervisionVisit*(1+Percent_Loading_VHigh))))","v":456},{"$f":"IF(Name_Large=\"\",0,IF(Name_Cost_VHigh=\"\",0,E$149*(Price_SupervisionVisit*(1+Percent_Loading_VHigh))))","v":0},{"$f":"'1.General_Inputs_Plan&Budget'!C295","v":114}]
[]
[]
[null,"STEP 3 - IDENTIFY & COST MANDATORY IN-SERVICE TRAININGS FOR ALL FACILITY STAFF "]
[]
[null,"3.1. Enter service parameters for mandatory in-service training. Include trainings for all components of small and sick newborn care and any associated quality standards"]
[null,"As appropriate in the local context, you can include here any trainings related to task-shifting i.e. to improve the capacity of nurses and midwives to deliver small and sick newborn care"]
[null,"If trainings will take place at a facility only once a year enter 1, if every 2 years, enter 0.5"]
[null,"The final columns (yellow cells) show total in-service training by facilty size"]
[]
[null,"First: Enter Name of Mandatory in-service training package","Second: enter number of staff trained @ each facility",null,null,"Third, enter # of days","Fourth, enter Costs per Person per Day ($)","Fifth, enter number of training sessions in a year","Sixth, Enter User Notes","Seventh, Review In-Service Training Costs by Facility Size"]
[null,null,{"$f":"List_Facility_Sizes","v":"Small"},"Medium","",null,null,null,null,{"$f":"List_Facility_Sizes","v":"Small"},"Medium",""]
[null,"Essential newborn care for small and normal babies",15,29,null,3,100,1,"Nurses, assistant, paramedic",{"$f":"IF(Name_Small= \"\",0, C168*$F168*$G168*$H168)","v":4500},{"$f":"IF(Name_Medium= \"\",0, D168*$F168*$G168*$H168)","v":8700},{"$f":"IF(Name_Large= \"\",0, E168*$F168*$G168*$H168)","v":0}]
[null,"KMC and quality improvement traning",15,29,null,2,100,1,"As above",3000,5800,0]
[null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,"Total In-Service Training Costs",{"$f":"IF(Name_Small=\"\",0,SUM(J168:J177))","v":7500},{"$f":"IF(Name_Medium=\"\",0,SUM(K168:K177))","v":14500},{"$f":"IF(Name_Large=\"\",0,SUM(L168:L177))","v":0}]
[]
[null,"3.2. Review Total Annual In-Service Training Costs by Facility Size and Location Typology after applying cost loadings/mark-ups from inputs.  If required revise estimates in dark-blue cells"]
[]
[null,null,null,null,null,{"$f":"'4.Equip_Other_Plan&Budget'!G150","v":"Enter user-defined costs here. Note they override modelled estimates"},null,null,"User Notes"]
[null,"Annual In-Service Training Costs",{"$f":"List_Facility_Sizes","v":"Small"},"Medium","",{"$f":"List_Facility_Sizes","v":"Small"},"Medium",""]
[null,{"$f":"List_Costing_Groups","v":"Mid Cost "},{"$f":"IF(Name_Cost_Mid=\"\",0,J178*(1+Percent_Loading_Mid))","v":7500},{"$f":"IF(Name_Cost_Mid=\"\",0,K178*(1+Percent_Loading_Mid))","v":14500},{"$f":"IF(Name_Cost_Mid=\"\",0,L178*(1+Percent_Loading_Mid))","v":0}]
[null,"High Cost",{"$f":"IF(Name_Cost_High=\"\",0,J178*(1+Percent_Loading_High))","v":8250},{"$f":"IF(Name_Cost_High=\"\",0,K178*(1+Percent_Loading_High))","v":15950.000000000002},{"$f":"IF(Name_Cost_High=\"\",0,L178*(1+Percent_Loading_High))","v":0}]
[null,"Very High Cost",{"$f":"IF(Name_Cost_VHigh=\"\",0,J178*(1+Percent_Loading_VHigh))","v":9000},{"$f":"IF(Name_Cost_VHigh=\"\",0,K178*(1+Percent_Loading_VHigh))","v":17400},{"$f":"IF(Name_Cost_VHigh=\"\",0,L178*(1+Percent_Loading_VHigh))","v":0}]
[]
[null,"3.3. Review In-Service Training Costs to be used in the final calculations"]
[null,null,{"$f":"List_Facility_Sizes","v":"Small"},"Medium",""]
[null,{"$f":"List_Costing_Groups","v":"Mid Cost "},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Small=\"\",0,IF(F184<>\"\",F184,C184)))","v":7500},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Medium=\"\",0,IF(G184<>\"\",G184,D184)))","v":14500},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Large=\"\",0,IF(H184<>\"\",H184,E184)))","v":0}]
[null,"High Cost",{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Small=\"\",0,IF(F185<>\"\",F185,C185)))","v":8250},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Medium=\"\",0,IF(G185<>\"\",G185,D185)))","v":15950.000000000002},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Large=\"\",0,IF(H185<>\"\",H185,E185)))","v":0}]
[null,"Very High Cost",{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Small=\"\",0,IF(F186<>\"\",F186,C186)))","v":9000},{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Medium=\"\",0,IF(G186<>\"\",G186,D186)))","v":17400},{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Large=\"\",0,IF(H186<>\"\",H186,E186)))","v":0}]
[]
[]
[null,"STEP 4 - IDENTIFY AND COST OTHER HUMAN RESOURCE DEVELOPMENT STRATEGIES"]
[null,"4.1. Enter the name of other human resource development strategies and expected costs at facility level"]
[null,"For example, you can include here costs related to performance-based rewards or peer mentoring programs"]
[null,"Enter expected costs by facility size typology. Leave blank if not applicable or if that facility typology is not costed"]
[null,null,"Costs by Facility size typology"]
[null,"Name of Other Human Resource Strategy",{"$f":"List_Facility_Sizes","v":"Small"},"Medium","","User Notes"]
[]
[]
[]
[]
[]
[]
[null,"Total Annual - Other Human Resource Strategies",{"$f":"IF(Name_Small=\"\",0,SUM(C201:C206))","v":0},{"$f":"IF(Name_Medium=\"\",0,SUM(D201:D206))","v":0},{"$f":"IF(Name_Large=\"\",0,SUM(E201:E206))","v":0}]
[]
[null,"4.2. Review estimated total for other strategies by Facility Size and Location Typology after applying cost loadings/mark-ups from inputs.  If required revise estimates in dark-blue cells"]
[]
[null,null,null,null,null,"Enter user-defined costs here. Note they override modelled estimates",null,null,"User Notes"]
[null,"Other Human Resource Strategies (Annual Costs)",{"$f":"List_Facility_Sizes","v":"Small"},"Medium","",{"$f":"List_Facility_Sizes","v":"Small"},"Medium",""]
[null,{"$f":"List_Costing_Groups","v":"Mid Cost "},{"$f":"IF(Name_Cost_Mid=\"\",0,C207*(1+Percent_Loading_Mid))","v":0},{"$f":"IF(Name_Cost_Mid=\"\",0,D207*(1+Percent_Loading_Mid))","v":0},{"$f":"IF(Name_Cost_Mid=\"\",0,E207*(1+Percent_Loading_Mid))","v":0}]
[null,"High Cost",{"$f":"IF(Name_Cost_High=\"\",0,C207*(1+Percent_Loading_High))","v":0},{"$f":"IF(Name_Cost_High=\"\",0,D207*(1+Percent_Loading_High))","v":0},{"$f":"IF(Name_Cost_High=\"\",0,E207*(1+Percent_Loading_High))","v":0}]
[null,"Very High Cost",{"$f":"IF(Name_Cost_VHigh=\"\",0,C207*(1+Percent_Loading_VHigh))","v":0},{"$f":"IF(Name_Cost_VHigh=\"\",0,D207*(1+Percent_Loading_VHigh))","v":0},{"$f":"IF(Name_Cost_VHigh=\"\",0,E207*(1+Percent_Loading_VHigh))","v":0}]
[]
[null,"4.3. Review Costs of Other Huma Resource Strategies to be used in the final calculations"]
[null,null,{"$f":"List_Facility_Sizes","v":"Small"},"Medium",""]
[null,{"$f":"List_Costing_Groups","v":"Mid Cost "},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Small=\"\",0,IF(F213<>\"\",F213,C213)))","v":0},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Medium=\"\",0,IF(G213<>\"\",G213,D213)))","v":0},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Large=\"\",0,IF(H213<>\"\",H213,E213)))","v":0}]
[null,"High Cost",{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Small=\"\",0,IF(F214<>\"\",F214,C214)))","v":0},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Medium=\"\",0,IF(G214<>\"\",G214,D214)))","v":0},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Large=\"\",0,IF(H214<>\"\",H214,E214)))","v":0}]
[null,"Very High Cost",{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Small=\"\",0,IF(F215<>\"\",F215,C215)))","v":0},{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Medium=\"\",0,IF(G215<>\"\",G215,D215)))","v":0},{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Large=\"\",0,IF(H215<>\"\",H215,E215)))","v":0}]
[]
[null,"STEP 5 - REVIEW TOTAL HUMAN RESOURCE DEVELOPMENT COSTS"]
[null,"Review Total Human Resource Development Costs as estimated above. "]
[null,"These are the sum of Supervision/Mentoring PLUS in-service training PLUS Other Human Resource Development Strategies"]
[null,"Annual  Human Resource Development Costs  (Supervision + In-service Training + Other)",{"$f":"List_Facility_Sizes","v":"Small"},"Medium",""]
[null,{"$f":"List_Costing_Groups","v":"Mid Cost "},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Small=\"\",0,C154+C190+C219))","v":7880},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Medium=\"\",0,D154+D190+D219))","v":14880},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Large=\"\",0,E154+E190+E219))","v":0}]
[null,"High Cost",{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Small=\"\",0,C155+C191+C220))","v":8668},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Medium=\"\",0,D155+D191+D220))","v":16368.000000000002},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Large=\"\",0,E155+E191+E220))","v":0}]
[null,"Very High Cost",{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Small=\"\",0,C156+C192+C221))","v":9456},{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Medium=\"\",0,D156+D192+D221))","v":17856},{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Large=\"\",0,E156+E192+E221))","v":0}]
[]
[null,"STEP 6 - IDENTIFY AND COST ADDITIONAL STRATEGIES TO RECRUIT AND RETAIN STAFF IN HARD-TO-RECRUIT AND MOST CHALLENGING RECRUITMENT AREAS. LEAVE BLANK IF  TYPOLOGY NOT INCLUDED."]
[]
[null,"In this step you can include the cost of additional strategies specifically targeting the recruitment and retention of human resources in hard-to-recruit & most challenging recruit areas."]
[null,"Make sure you do not include strategies already costed above, such as financial incentives included in salaries and allowances for staff working in these areas"]
[null,"Some of these new strategies might involve capital investments, such as providing housing or vehicles (i.e. motobikes) for transport in remote areas. These costs are entered in Step 3.1."]
[null,"Other strategies might involve recurrent costs, such as strategies for increased opportunities for training, mentoring or collaboration. These costs are entered in Step 3.2."]
[]
[]
[null,"Step 6.1. Identify recruitment and retainment strategies applicable and enter the amount of CAPITAL investments required. "]
[null,"For example, if new houses needs to be built for nurses and doctors, enter total costs per facility size typology"]
[null,"Leave blank if typology not included or if there are no additional strategies applicable"]
[]
[null,null,"Amount of CAPITAL costs required by facility",null,null,null,null,null,"User Notes"]
[null,"Name of Recruitment/Retetion strategy",{"$f":"Name_HR_HardRecruit","v":"Hard-to-Recruit"},null,null,{"$f":"Name_HR_VHardRecruit","v":""}]
[null,null,{"$f":"List_Facility_Sizes","v":"Small"},"Medium","",{"$f":"List_Facility_Sizes","v":"Small"},"Medium",""]
[null,"Motorbikes",5000,10000]
[null,"Strategy 2"]
[null,"Strategy 3"]
[null,"Strategy 4"]
[null,"Strategy 5"]
[null,"Total CAPITAL costs per facility ",{"$f":"IF(Name_HR_HardRecruit=\"\",0,IF(Name_Small=\"\",0,SUM(C246:C250)))","v":5000},{"$f":"IF(Name_HR_HardRecruit=\"\",0,IF(Name_Medium=\"\",0,SUM(D246:D250)))","v":10000},{"$f":"IF(Name_HR_HardRecruit=\"\",0,IF(Name_Large=\"\",0,SUM(E246:E250)))","v":0},{"$f":"IF(Name_HR_VHardRecruit=\"\",0,IF(Name_Small=\"\",0,SUM(F246:F250)))","v":0},{"$f":"IF(Name_HR_VHardRecruit=\"\",0,IF(Name_Medium=\"\",0,SUM(G246:G250)))","v":0},{"$f":"IF(Name_HR_VHardRecruit=\"\",0,IF(Name_Large=\"\",0,SUM(H246:H250)))","v":0}]
[]
[]
[]
[null,"Step 6.2. Identify recruitment and retainment strategies and enter the amount of RECURRENT costs required.  Leave blank if  typology not included or if there are no additional strategies applicable"]
[null,"For example, if additional staff mentoring or collaboration opportunities are required, enter total costs per facility size typology"]
[null,"Note: Total will be 0 if facility typology not included"]
[null,null,"Amount of RECURRENT costs per facility",null,null,null,null,null,"User Notes"]
[null,{"$f":"B244","v":"Name of Recruitment/Retetion strategy"},{"$f":"Name_HR_HardRecruit","v":"Hard-to-Recruit"},null,null,{"$f":"Name_HR_VHardRecruit","v":""}]
[null,null,{"$f":"List_Facility_Sizes","v":"Small"},"Medium","",{"$f":"List_Facility_Sizes","v":"Small"},"Medium",""]
[null,"Professional Development ",1000,2000]
[null,"Strategy 2"]
[null,"Strategy 3"]
[null,"Strategy 4"]
[null,"Strategy 5"]
[null,"Total RECURRENT costs per facility ",{"$f":"IF(Name_HR_HardRecruit=\"\",0,IF(Name_Small=\"\",0,SUM(C261:C265)))","v":1000},{"$f":"IF(Name_HR_HardRecruit=\"\",0,IF(Name_Medium=\"\",0,SUM(D261:D265)))","v":2000},{"$f":"IF(Name_HR_HardRecruit=\"\",0,IF(Name_Large=\"\",0,SUM(E261:E265)))","v":0},{"$f":"IF(Name_HR_VHardRecruit=\"\",0,IF(Name_Small=\"\",0,SUM(F261:F265)))","v":0},{"$f":"IF(Name_HR_VHardRecruit=\"\",0,IF(Name_Medium=\"\",0,SUM(G261:G265)))","v":0},{"$f":"IF(Name_HR_VHardRecruit=\"\",0,IF(Name_Large=\"\",0,SUM(H261:H265)))","v":0}]

{"sheet":"6.Referrals_Plan&Budget","index":6,"n_rows":222,"n_cols":10,"rows_kept":222,"cut":false,"hidden":false,"merged":[[170,5,170,8],[162,5,162,8],[163,5,163,8],[164,5,164,8],[165,5,165,8],[166,5,166,8],[129,3,129,6],[162,2,162,4],[167,5,167,8],[168,5,168,8],[169,5,169,8],[40,5,40,10],[39,5,39,10],[136,8,136,11],[137,8,137,11],[98,8,98,11],[83,3,83,6],[84,3,84,6],[85,3,85,6],[86,3,86,6],[87,3,87,6],[123,3,123,6],[124,3,124,6],[125,3,125,6],[126,3,126,6],[127,3,127,6],[128,3,128,6],[174,2,174,4],[174,5,174,7],[174,8,174,11],[175,8,175,11],[33,5,33,10],[34,5,34,10],[52,1,52,5],[138,8,138,11],[95,8,95,11],[96,8,96,11],[99,8,99,11],[134,5,134,7],[95,5,95,7],[119,1,119,5],[38,1,38,2],[97,8,97,11],[32,5,32,10],[215,13,215,18],[216,13,217,18],[220,3,220,8],[70,3,70,8],[71,3,71,8],[219,3,219,8],[187,1,187,11],[208,3,208,8],[209,3,209,8],[213,3,213,8],[214,3,214,8],[153,3,153,7],[154,3,154,7],[178,8,178,11],[179,8,179,11],[10,1,10,11],[24,1,24,5],[210,13,210,18],[211,13,212,18],[28,1,28,2],[121,1,121,2],[29,1,29,2],[147,1,147,5],[134,8,134,11],[135,8,135,11],[25,13,25,19],[134,2,134,4],[200,3,200,8],[201,3,201,8],[91,1,91,7],[31,5,31,10]]}
[]
[null,"List of Options. HR & Equipment Requirements for this and next sheet. "]
[null,"Yes"]
[null,"No & Should be included"]
[null,"Not Applicable"]
[]
[]
[]
[]
[null,"FUNCTIONAL REFERRAL SYSTEM - PLANNING & BUDGETING "]
[null,"WARNING: Do not copy and paste data into this workbook. Doing so may insert conflicting code and remove validation. Please enter data manually to ensure proper functionality"]
[null,"MODULE OVERVIEW"]
[null,"Identify key service parameters to estimate the expected number of referrals which will be used to estimate the associated transport costs"]
[null,"Estimate and review costs for: "]
[null,"Transport (Ambulance & Alternative Means of Transport)"]
[null,"*Care coordination & communication systems  "]
[null,"Consider and review whether equipment and human resource costs in the previous modules have accounted for the referral system requirements, such as ambulance equipment & trained drivers"]
[null,"Remember:"]
[null,"Light blue cells are user inputs."]
[null,"Yellow cells are tool calculations not to be manually changed"]
[null,"If required, cells in dark blue can be used for overriding modelled estimates. They can also be used to enter costs directly"]
[]
[]
[]
[null,"STEP 1. IDENTIFY KEY SERVICE PARAMETERS FOR FACILITY REFERRALS TO ESTIMATE TRANSPORT COSTS"]
[null,"In this step the user will enter service parameters to estimate the transport costs of referrals"]
[null,"Note that costs will be estimated separately for ambulance referrals and for referrals using other means of transport"]
[]
[null,"1.1. Enter service parameters for referrals using the Facility Ambulance Transport"]
[null,"Note: Leave blank or enter 0 if no referrals require funding for that type of transport"]
[]
[null,"Service Parameters - Facility Ambulance Referrals",{"$f":"List_Facility_Sizes","v":"Small"},"Medium","","User Notes"]
[null,"% of admissions expected to require referral by Facility Ambulance",0.4,0.4]
[null,"Number of Vehicles Required per Facility",1,1]
[null,"Average number of kilometers per ambulance referral round trip",70,70]
[]
[]
[null,"1.2. Enter Service Paramaters for referrals using Alternative Modes of Transport"]
[null,"Note: Leave blank or enter 0 if no referrals require funding for that type of transport"]
[null,null,{"$f":"List_Facility_Sizes","v":"Small"},"Medium","","User Notes"]
[null,"% of admissions expected to require alternative means of referral transport",0.1,0.1]
[]
[null,"1.3. Review number of admissions requiring referral transport (Facility Ambulance + Alternative Means of Transport)"]
[null,"This is estimated based on the number of expected admissions for each facility size (displayed here) and the % requiring referrals entered above. Included as reminders in light gray"]
[]
[null,null,{"$f":"List_Facility_Sizes","v":"Small"},"Medium",""]
[null,"# of admissions requiring referrals using Facility Ambulance ",{"$f":"ROUNDUP(IF(Name_Small=\"\",0,C33*Admissions_Small),0)","v":270},{"$f":"ROUNDUP(IF(Name_Medium=\"\",0,D33*Admissions_Medium),0)","v":538},{"$f":"ROUNDUP(IF(Name_Large=\"\",0,E33*Admissions_Large),0)","v":0}]
[null,"# of admissions requiring referrals using Alternative Means of Transport",{"$f":"ROUNDUP(IF(Name_Small=\"\",0,C41*Admissions_Small),0)","v":68},{"$f":"ROUNDUP(IF(Name_Medium=\"\",0,D41*Admissions_Medium),0)","v":135},{"$f":"ROUNDUP(IF(Name_Large=\"\",0,E41*Admissions_Large),0)","v":0}]
[null,"Total facility admissions",{"$f":"Admissions_Small","v":673},{"$f":"Admissions_Medium","v":1345},{"$f":"Admissions_Large","v":0}]
[null,"All admissions requiring referral (Facility Ambulance + Other) as % of total",{"$f":"IF(Name_Small=\"\",0,IF(ISNUMBER((Referrals_Ambulance_Small+Referrals_Other_Small)/Admissions_Small),(Referrals_Ambulance_Small+Referrals_Other_Small)/Admissions_Small,0))","v":0.50222882615156017},{"$f":"IF(Name_Medium=\"\",0,IF(ISNUMBER((Referrals_Ambulance_Medium+Referrals_Other_Medium)/Admissions_Medium),(Referrals_Ambulance_Medium+Referrals_Other_Medium)/Admissions_Medium,0))","v":0.50037174721189592},{"$f":"IF(Name_Large=\"\",0,IF(ISNUMBER((Referrals_Ambulance_Large+Referrals_Other_Large)/Admissions_Large),(Referrals_Ambulance_Large+Referrals_Other_Large)/Admissions_Large,0))","v":0}]
[]
[]
[null,"STEP 2 - ESTIMATE AND REVIEW COSTS OF REFERRALS USING FACILITY AMBULANCE TRANSPORT"]
[null,"In this step the user will estimate and review costs of ambulance referrals, including acquiring ambulance vehicles, fuel and maintenance and other recurrent costs"]
[null,"Remember that: "]
[null,"* Annual salaries of facility staff such as trained drivers should be costed under human resources. "]
[null,"* Neonatal transport equipment should be included under the facility equipment standards"]
[null,"Leave blank if facility referrals are not transported by facility ambulance or if those costs are covered by other programs, such as national/regional/provincial emergency transportation services"]
[]
[null,"2.1. Review Cost of Ambulance Vehicles, based on unit prices from inputs and required numbers. Make sure ambulance prices include GPS"]
[null,"Note: costs will be 0 if facility typology not costed or there are no referrals by facility ambulance"]
[null,"These costs are estimated based on the ambulance vehicle costs (from inputs) and the facility requirements set above. Included as reminders in light gray"]
[]
[null,"Ambulance Vehicle Acquisition Costs",{"$f":"List_Facility_Sizes","v":"Small"},"Medium",""]
[null,"Acquisition costs of ambulance vehicle",{"$f":"IF(Name_Small=\"\",0,C34*Price_AmbulanceVehicle)","v":100000},{"$f":"IF(Name_Medium=\"\", 0,D34*Price_AmbulanceVehicle)","v":100000},{"$f":"IF(Name_Large=\"\",0,E34*Price_AmbulanceVehicle)","v":0}]
[null,"Ambulance vehicle (unit prices)",{"$f":"Price_AmbulanceVehicle","v":100000},{"$f":"Price_AmbulanceVehicle","v":100000},{"$f":"Price_AmbulanceVehicle","v":100000}]
[null,"# of ambulance vehicles  required by facility",{"$f":"C34","v":1},{"$f":"D34","v":1},{"$f":"E34","v":0}]
[]
[null,"2.2. Review if the ambulance neonatal equipment was included under the facility equipment requirements? Click Go to The Equipment Tab if required"]
[]
[null,null,null,"User Notes"]
[null,"Did you include the equipment required for safe transport of newborns under the facility equipment standards?","No & Should be included"]
[null,null,{"$f":"IF(C72=\"No & Should be included\", \"ERROR. GO BACK TO EQUIPMENT\", \" \" )","v":"ERROR. GO BACK TO EQUIPMENT"}]
[]
[null,"2.3. Review cost inputs of fuel and maintenance for ambulance referrals transport"]
[null,"Note: These were entered under Step 7.2 under the General Inputs Tab and are shown here as a reminder"]
[]
[null,"Ambulance fuel cost per kilometer",{"$f":"'1.General_Inputs_Plan&Budget'!C314","v":0.12}]
[null,"Ambulance maintenance cost per kilometer",{"$f":"'1.General_Inputs_Plan&Budget'!C315","v":0.06},null,null,null,null,null,null," "]
[]
[]
[null,"2.4. Identify strategies to support ambulance transport referrals and enter other costs per referral trip"]
[null,"Include costs such as fees for community workers to accompany the baby and the mother & remember these are unit costs per referral trip"]
[null,null,"Unit Cost per Referral Trip","User Notes"]
[null,"Vouchers",5]
[]
[]
[null,"Total Other Ambulance Referral Costs",{"$f":"SUM(C85:C87)","v":5}]
[]
[]
[null,"2.5. Review recurrent Facility Ambulance costs (fuel & maintenance + Other) by facility typology and enter user-defined estimates if required"]
[null,"Review total recurrent costs of ambulance referrals (after applying cost loadings from inputs) and override modelled estimates if required"]
[null,"To facilitate this review, intermediate calculations for fuel & maintenance and other annual costs by typology are included in light gray cells."]
[null,"* Fuel & maintenance costs are estimated based on number of referrals, kilometers per referral and fuel and maintenance costs reviewed above . "]
[null,"* Other annual ambulance referral costs are estimated based on the expected number of referrals & costs per referral trip entered above."]
[null,null,null,null,null," Enter user-defined numbers here. Note they override modelled estimates",null,null,"User Notes"]
[null,"Recurrent Annual Facility Ambulance Transport Costs",{"$f":"List_Facility_Sizes","v":"Small"},"Medium","",{"$f":"List_Facility_Sizes","v":"Small"},"Medium",""]
[null,{"$f":"List_Costing_Groups","v":"Mid Cost "},{"$f":"C103+C107","v":4752},{"$f":"D103+D107","v":9468.7999999999993},0]
[null,"High Cost",{"$f":"C104+C108","v":5227.2000000000007},10415.68,0]
[null,"Very High Cost",{"$f":"C105+C109","v":5702.4},11362.56,0]
[]
[null,"Annual Ambulance Fuel & Maintenance Costs",{"$f":"List_Facility_Sizes","v":"Small"},"Medium",""]
[null,{"$f":"List_Costing_Groups","v":"Mid Cost "},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Small=\"\",0,(Referrals_Ambulance_Small*Referrals_Kilometers_Small)*(($C$78+$C$79)*(1+Percent_Loading_Mid))))","v":3402},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Medium=\"\",0,(Referrals_Ambulance_Medium*Referrals_Kilometers_Medium)*(($C$78+$C$79)*(1+Percent_Loading_Mid))))","v":6778.8},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Large=\"\",0,(Referrals_Ambulance_Large*Referrals_Kilometers_Large)*(($C$78+$C$79)*(1+Percent_Loading_Mid))))","v":0}]
[null,"High Cost",{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Small=\"\",0,(Referrals_Ambulance_Small*Referrals_Kilometers_Small)*(($C$78+$C$79)*(1+Percent_Loading_High))))","v":3742.2000000000003},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Medium=\"\",0,(Referrals_Ambulance_Medium*Referrals_Kilometers_Medium)*(($C$78+$C$79)*(1+Percent_Loading_High))))","v":7456.68},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Large=\"\",0,(Referrals_Ambulance_Large*Referrals_Kilometers_Large)*(($C$78+$C$79)*(1+Percent_Loading_High))))","v":0}]
[null,"Very High Cost",{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Small=\"\",0,(Referrals_Ambulance_Small*Referrals_Kilometers_Small)*(($C$78+$C$79)*(1+Percent_Loading_VHigh))))","v":4082.4},{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Medium=\"\",0,(Referrals_Ambulance_Medium*Referrals_Kilometers_Medium)*(($C$78+$C$79)*(1+Percent_Loading_VHigh))))","v":8134.5599999999995},{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Large=\"\",0,(Referrals_Ambulance_Large*Referrals_Kilometers_Large)*(($C$78+$C$79)*(1+Percent_Loading_VHigh))))","v":0}]
[null,"Other Annual Ambulance Referral Costs",{"$f":"List_Facility_Sizes","v":"Small"},"Medium",""]
[null,{"$f":"List_Costing_Groups","v":"Mid Cost "},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Small=\"\",0,(Referrals_Ambulance_Small*(($C$88)*(1+Percent_Loading_Mid)))))","v":1350},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Medium=\"\",0,(Referrals_Ambulance_Medium*(($C$88)*(1+Percent_Loading_Mid)))))","v":2690},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Large=\"\",0,(Referrals_Ambulance_Large*(($C$88)*(1+Percent_Loading_Mid)))))","v":0}]
[null,"High Cost",{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Small=\"\",0,(Referrals_Ambulance_Small*(($C$88)*(1+Percent_Loading_High)))))","v":1485},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Medium=\"\",0,(Referrals_Ambulance_Medium*(($C$88)*(1+Percent_Loading_High)))))","v":2959},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Large=\"\",0,(Referrals_Ambulance_Large*(($C$88)*(1+Percent_Loading_High)))))","v":0}]
[null,"Very High Cost",{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Small=\"\",0,(Referrals_Ambulance_Small*(($C$88)*(1+Percent_Loading_VHigh)))))","v":1620},{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Medium=\"\",0,(Referrals_Ambulance_Medium*(($C$88)*(1+Percent_Loading_VHigh)))))","v":3228},{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Large=\"\",0,(Referrals_Ambulance_Large*(($C$88)*(1+Percent_Loading_VHigh)))))","v":0}]
[]
[]
[null,"2.6 Review Recurrent Annual Facility Ambulance Costs to be used in final estimates"]
[]
[null,{"$f":"B97","v":"Recurrent Annual Facility Ambulance Transport Costs"},{"$f":"List_Facility_Sizes","v":"Small"},"Medium",""]
[null,{"$f":"List_Costing_Groups","v":"Mid Cost "},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Small=\"\",0,IF(F98<>\"\",F98,C98)))","v":4752},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Medium=\"\",0,IF(G98<>\"\",G98,D98)))","v":9468.7999999999993},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Large=\"\",0,IF(H98<>\"\",H98,E98)))","v":0}]
[null,"High Cost",{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Small=\"\",0,IF(F99<>\"\",F99,C99)))","v":5227.2000000000007},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Medium=\"\",0,IF(G99<>\"\",G99,D99)))","v":10415.68},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Large=\"\",0,IF(H99<>\"\",H99,E99)))","v":0}]
[null,"Very High Cost",{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Small=\"\",0,IF(F100<>\"\",F100,C100)))","v":5702.4},{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Medium=\"\",0,IF(G100<>\"\",G100,D100)))","v":11362.56},{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Large=\"\",0,IF(H100<>\"\",H100,E100)))","v":0}]
[]
[]
[null,"STEP 3 - ESTIMATE AND REVIEW COSTS OF REFERRALS USING ALTERNATIVE MEANS OF TRANSPORT "]
[]
[null,"3.1. Enter cost parameters for referrals requiring alternative means of transport"]
[null,"Remember to enter costs per referral"]
[null,"First enter unit costs per referral requiring Alternative Means of Transport","Unit Costs per Referral ","User Notes"]
[null,"Transport fee (vehicle with equipment and driver)",15]
[null,"Community health worker fees",5]
[]
[]
[]
[null,"Total",{"$f":"SUM(C125:C129)","v":20}]
[]
[null,"3.2.Review annual costs of referrals using alternative means of transport by facility size and locatioon typology. Use dark blue cellss to override modelled estimates as required"]
[null,"Note that these costs are estimated based on the unit costs per referral adjusted by loadings/mark-ups and the expected number of referrals using other means of transport "]
[]
[null,null,"Annual Cost of Alternative Means of Referral Transport by Facility Typology",null,null," Enter user-defined numbers here. Note they override modelled estimates",null,null,"User Notes"]
[null,null,{"$f":"List_Facility_Sizes","v":"Small"},"Medium","",{"$f":"List_Facility_Sizes","v":"Small"},"Medium",""]
[null,{"$f":"List_Costing_Groups","v":"Mid Cost "},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Small=\"\",0,(Referrals_Other_Small*$C$130*(1+Percent_Loading_Mid))))","v":1360},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Medium=\"\",0,(Referrals_Other_Medium*$C$130*(1+Percent_Loading_Mid))))","v":2700},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Large=\"\",0,(Referrals_Other_Large*$C$130*(1+Percent_Loading_Mid))))","v":0}]
[null,"High Cost",{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Small=\"\",0,(Referrals_Other_Small*$C$130*(1+Percent_Loading_High))))","v":1496.0000000000002},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Medium=\"\",0,(Referrals_Other_Medium*$C$130*(1+Percent_Loading_High))))","v":2970.0000000000005},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Large=\"\",0,(Referrals_Other_Large*$C$130*(1+Percent_Loading_High))))","v":0}]
[null,"Very High Cost",{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Small=\"\",0,(Referrals_Other_Small*$C$130*(1+Percent_Loading_VHigh))))","v":1632},{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Medium=\"\",0,(Referrals_Other_Medium*$C$130*(1+Percent_Loading_VHigh))))","v":3240},{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Large=\"\",0,(Referrals_Other_Large*$C$130*(1+Percent_Loading_VHigh))))","v":0}]
[]
[null,"3.3. Review Recurrent Costs for alternative means of transport to be used in the final calculations"]
[null,null,{"$f":"List_Facility_Sizes","v":"Small"},"Medium",""]
[null,{"$f":"List_Costing_Groups","v":"Mid Cost "},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Small=\"\",0,IF(F137<>\"\",F137,C137)))","v":1360},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Medium=\"\",0,IF(G137<>\"\",G137,D137)))","v":2700},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Large=\"\",0,IF(H137<>\"\",H137,E137)))","v":0}]
[null,"High Cost",{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Small=\"\",0,IF(F138<>\"\",F138,C138)))","v":1496.0000000000002},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Medium=\"\",0,IF(G138<>\"\",G138,D138)))","v":2970.0000000000005},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Large=\"\",0,IF(H138<>\"\",H138,E138)))","v":0}]
[null,"Very High Cost",{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Small=\"\",0,IF(F139<>\"\",F139,C139)))","v":1632},{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Medium=\"\",0,IF(G139<>\"\",G139,D139)))","v":3240},{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Large=\"\",0,IF(H139<>\"\",H139,E139)))","v":0}]
[]
[]
[null,"STEP 4. IDENTIFY,  COST & REVIEW COMMUNICATIONS & COORDINATION SYSTEM REQUIREMENTS FOR REFERRALS (Excluding human resources costed elsewhere)"]
[]
[null,"4.1. Identify Equipment Requirements "]
[null,"Review if the equipment requirements such as phones & computers were included under the equipment & commodities module. Click Go to The Equipment Tab if required"]
[null,"If equipment is funded separately as part of the Emergency Services budget, select Not Applicable"]
[]
[null,null,null,"User Notes"]
[null,"Did you include equipment requirements, such as computers and phones, under 'office and communication equipment' standards in the previous module?","No & Should be included"]
[null,null,{"$f":"IF(C155=\"No & Should be included\", \"ERROR. GO BACK TO EQUIPMENT\", \" \" )","v":"ERROR. GO BACK TO EQUIPMENT"}]
[]
[]
[null,"4.2. Identify and include additional recurrent costs associated with communications and coordination requirements for referrals, not costed elsewhere "]
[null,"For example, you can include here expenses related to internet, mobile or landphone for communication exchanges with other facilities"]
[null,"You can also include here other costs such as those associated with supporting in-referrals from lower-level facilities & the community, such as mentoring to facility staff and community health workers"]
[]
[null,"Recurrent costs -  Coordination & Communications Systems for Referrals ","Other Referral Annual Recurrent Costs",null,null,"User Notes"]
[null,null,{"$f":"List_Facility_Sizes","v":"Small"},"Medium",""]
[null,"Facility internet and phone bills",1000,1000]
[]
[]
[]
[]
[]
[null,"Total Communication & Coordination Recurrent Costs",{"$f":"IF(Name_Small=\"\",0,SUM(C165:C170))","v":1000},{"$f":"IF(Name_Medium=\"\",0,SUM(D165:D170))","v":1000},{"$f":"IF(Name_Large=\"\",0,SUM(E165:E170))","v":0}]
[]
[null,"4.3. Review additional recurrent costs for referrals by size and location typologies and override modelled estimates as required"]
[]
[null,null,"Other Referral Annual Recurrent Costs",null,null," Enter user-defined numbers here. Note they override modelled estimates",null,null,"User Notes"]
[null,null,{"$f":"List_Facility_Sizes","v":"Small"},"Medium","",{"$f":"List_Facility_Sizes","v":"Small"},"Medium",""]
[null,{"$f":"List_Costing_Groups","v":"Mid Cost "},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Small=\"\",0,C171*(1+Percent_Loading_Mid)))","v":1000},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Medium=\"\",0,D171*(1+Percent_Loading_Mid)))","v":1000},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Large=\"\",0,E171*(1+Percent_Loading_Mid)))","v":0}]
[null,"High Cost",{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Small=\"\",0,C171*(1+Percent_Loading_High)))","v":1100},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Medium=\"\",0,D171*(1+Percent_Loading_High)))","v":1100},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Large=\"\",0,E171*(1+Percent_Loading_High)))","v":0}]
[null,"Very High Cost",{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Small=\"\",0,C171*(1+Percent_Loading_VHigh)))","v":1200},{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Medium=\"\",0,D171*(1+Percent_Loading_VHigh)))","v":1200},{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Large=\"\",0,E171*(1+Percent_Loading_VHigh)))","v":0}]
[]
[null,"4.4. Review additional recurrent referral costs to be used in Step 4 to estimate recurrent referrals costs"]
[null,null,{"$f":"List_Facility_Sizes","v":"Small"},"Medium",""]
[null,{"$f":"List_Costing_Groups","v":"Mid Cost "},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Small=\"\",0,IF(F177<>\"\",F177,C177)))","v":1000},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Medium=\"\",0,IF(G177<>\"\",G177,D177)))","v":1000},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Large=\"\",0,IF(H177<>\"\",H177,E177)))","v":0}]
[null,"High Cost",{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Small=\"\",0,IF(F178<>\"\",F178,C178)))","v":1100},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Medium=\"\",0,IF(G178<>\"\",G178,D178)))","v":1100},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Large=\"\",0,IF(H178<>\"\",H178,E178)))","v":0}]
[null,"Very High Cost",{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Small=\"\",0,IF(F179<>\"\",F179,C179)))","v":1200},{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Medium=\"\",0,IF(G179<>\"\",G179,D179)))","v":1200},{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Large=\"\",0,IF(H179<>\"\",H179,E179)))","v":0}]
[]
[]
[null,"STEP 5 - REVIEW FACILITY RECURRENT COSTS FOR TRANSPORT, COORDINATION AND COMMUNICATIONS (All Referrrals)"]
[null,"Review recurrent costs for facility referrals, excluding human resources. They include transport costs (ambulance & other) as well as communications and coordination costs estimated in the previous steps"]
[]
[null,"Referral Recurrent Costs (Transport, Communication & Coordination)*",{"$f":"List_Facility_Sizes","v":"Small"},"Medium",""]
[null,{"$f":"List_Costing_Groups","v":"Mid Cost "},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Small=\"\",0,C183+C143+Cost_Ambulance_Annual_Small_Mid))","v":7112},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Medium=\"\",0,D183+D143+Cost_Ambulance_Annual_Medium_Mid))","v":13168.8},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Large=\"\",0,E183+E143+Cost_Ambulance_Annual_Large_Mid))","v":0}]
[null,"High Cost",{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Small=\"\",0,C184+C144+Cost_Ambulance_Annual_Small_High))","v":7823.2000000000007},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Medium=\"\",0,D184+D144+Cost_Ambulance_Annual_Medium_High))","v":14485.68},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Large=\"\",0,E184+E144+Cost_Ambulance_Annual_Large_High))","v":0}]
[null,"Very High Cost",{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Small=\"\",0,C185+C145+Cost_Ambulance_Annual_Small_VHigh))","v":8534.4},{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Medium=\"\",0,D185+D145+Cost_Ambulance_Annual_Medium_VHigh))","v":15802.56},{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Large=\"\",0,E185+E145+Cost_Ambulance_Annual_Large_VHigh))","v":0}]
[null,"* Excludes facility staff salaries"]
[]
[null,"STEP 6. REVIEW THAT HUMAN RESOURCES REQUIREMENTS FOR REFERRAL SYSTEMS, INCLUDING FOR TRANSPORT, COMMUNICATIONS AND COORDINATION HAVE BEEN INCLUDED IN FACILITY STANDARDS"]
[]
[null,"6.1. Identify if staff ratios have taken into consideration workloads related to referrals, such as liaising with other facilities, filling out referral forms and accompanying newborns and mothers during transport as required. Click Go to The HR Tab if required"]
[]
[null,null,null,"User Notes"]
[null,"Did you account for the time needed by facility health staff to support referrals when setting facility staff standards under Human Resources? Select Yes/No","No"]
[null,null,{"$f":"IF(C202=\"No\", \"ERROR. GO BACK TO HUMAN RESOURCES\", \" \" )","v":"ERROR. GO BACK TO HUMAN RESOURCES"}]
[]
[null,"6.2. Identify if additional human resources for referrals such as drivers or call center staff have been included as part of facility human resource standards. Click Go to The HR Tab if required"]
[null,"In instances where those human resources are not required, the answer should be \"No, but other arrangements in place\"."]
[]
[null,"First, review human resource standards for transport"]
[null,null,null,"User Notes"]
[null,"Did you include transport staff, such as trained ambulance drivers when setting facility staff standards under Human Resources? ?","No & Should be included"]
[null,null,{"$f":"IF(C210=\"No & Should be included\", \"ERROR. GO BACK TO HUMAN RESOURCES\", \" \" )","v":"ERROR. GO BACK TO HUMAN RESOURCES"}]
[]
[null,"Second, review human resource standards for communications and care coordination.  Click Go to The HR Tab if required"]
[null,null,null,"User Notes"]
[null,"Did you include coordination/communications staff, such as call centre officers, when setting facility staff standards under Human Resources?","No & Should be included"]
[null,null,{"$f":"IF(C215=\"No & Should be included\", \"ERROR. GO BACK TO HUMAN RESOURCES\", \" \" )","v":"ERROR. GO BACK TO HUMAN RESOURCES"}]
[]
[null,"6.3. Identify if referral training for facility, transport and communications staff has been included as part of human development strategies. Click Go to The HR Tab (training) if required"]
[]
[null,null,null,"User Notes"]
[null,"Did you include under mandatory in-service trainings any requirements related to referrals, communications and care coordination?","No & Should be included"]
[null,null,{"$f":"IF(C221=\"No & Should be included\", \"ERROR. GO BACK TO HUMAN RESOURCES\", \" \" )","v":"ERROR. GO BACK TO HUMAN RESOURCES"}]

{"sheet":"7.Other_Facility_Plan&Budget","index":7,"n_rows":205,"n_cols":9,"rows_kept":205,"cut":false,"hidden":false,"merged":[[57,1,57,5],[162,2,162,4],[67,2,67,4],[122,2,122,4],[142,2,142,4],[102,2,102,4],[87,2,87,4],[46,2,46,4],[31,1,31,5],[24,2,24,4],[25,2,25,4],[29,2,29,4],[45,2,45,4],[26,2,26,4],[27,2,27,4],[28,2,28,4],[40,2,40,4],[41,2,41,4],[42,2,42,4],[43,2,43,4],[44,2,44,4],[196,8,196,11],[197,8,197,11],[50,2,50,4],[51,2,51,4],[52,2,52,4],[53,2,53,4],[54,2,54,4],[87,6,87,9],[55,2,55,4],[124,6,139,9],[144,6,159,9],[194,8,194,11],[193,5,193,7],[193,8,193,11],[143,6,143,9],[103,6,103,9],[55,6,55,9],[45,6,45,9],[51,6,51,9],[52,6,52,9],[53,6,53,9],[54,6,54,9],[69,6,84,9],[104,6,119,9],[88,6,99,9],[195,8,195,11],[68,6,68,9],[123,6,123,9],[43,6,43,9],[29,6,29,9],[41,6,41,9],[42,6,42,9],[44,6,44,9],[2,1,2,9],[25,6,25,9],[26,6,26,9],[27,6,27,9],[28,6,28,9],[17,1,17,5]]}
[]
[null,"OTHER COMPONENTS OF SCALING-UP THE MODEL OF CARE (FACILITY LEVEL) - PLANNING & BUDGETING "]
[null,"WARNING: Do not copy and paste data into this workbook. Doing so may insert conflicting code and remove validation. Please enter data manually & choose from dropdown menu where available to ensure proper functionality "]
[null,"MODULE OVERVIEW"]
[null,"In this module you will review and identify costs for other components of scaling-up the model of care @ facility level:"]
[null,{"$f":"B69","v":"Robust Data Systems"}]
[null,{"$f":"B89","v":"Linkage of Maternal & Newborn Care"}]
[null,{"$f":"B104","v":"Family & Community Involvement and Support"}]
[null,{"$f":"B124","v":"Post-Discharge Follow-Up"}]
[null,"You will also have the opportunity to include additional facility-level costs for strategies related to infection prevention and control & other recurrent costs (e.g. utilities) not costed elsewhere"]
[null,"Note this module should only be used to estimate annual recurrent costs, excluding human resources which as noted below are costed elsewhere"]
[null,"Any capital investments needed should be also be costed as part of equipment or infrastructure."]
[null,"Reminder menus are included to provide some initial pointers for consideration."]
[null,"Light blue cells are user inputs."]
[null,"Yellow cells are tool calculations or contain reminder menus for strategies. They cannot be manually changed by the user"]
[null,"If required, cells in dark blue (at the end) can be used for overriding modelled estimates. "]
[]
[null,"STEP 1 - REVIEW IF FACILITY STANDARDS FOR EQUIPMENT INCLUDE ASSOCIATED REQUIEMENTS FOR OTHER MODEL OF CARE COMPONENTS"]
[]
[null,"Review if you included any additional equipment requirements for other facility components of small and sick newborn care. Click Go to The Equipment Tab if required"]
[null,"This will help you ensure that additional equipment requirements, such as computers for robust data systems are included and costed under facility equipment. "]
[null,"Note that we have also included infection prevention & control here to ensure any equipment requirements such as personal protective equipment have been duly considered."]
[null,"Select answer for each component listed below and add any relevant notes"]
[]
[null,"Other Facility-Level Components of Small and Sick Newborn Care","Did you include additional equipment requirements related to this component?",null,null,"User Notes"]
["Cols G& H have formula","Robust data systems",null,null,null,null,{"$f":"IF(C26=\"No & Should be included\", \"ERROR. GO BACK TO EQUIPMENT\", \" \" )","v":" "}]
["Cols G& H have formula","Linkage of maternal and newborn care",null,null,null,null,{"$f":"IF(C27=\"No & Should be included\", \"ERROR. GO BACK TO EQUIPMENT\", \" \" )","v":" "}]
["Cols G& H have formula","Family & community involvement and support",null,null,null,null," "]
["Cols G& H have formula","Post-discharge follow-up at facility and at home",null,null,null,null,{"$f":"IF(C29=\"No & Should be included\", \"ERROR. GO BACK TO EQUIPMENT\", \" \" )","v":" "}]
["Cols G& H have formula","Infection Prevention & Control",null,null,null,null,{"$f":"IF(C30=\"No & Should be included\", \"ERROR. GO BACK TO EQUIPMENT\", \" \" )","v":" "}]
[]
[null,"STEP 2 - REVIEW IF FACILITY STANDARDS FOR HUMAN RESOURCES INCLUDE ASSOCIATED REQUIEMENTS FOR OTHER MODEL OF CARE COMPONENTS"]
[]
[null,"2.1. Review if you included any staff requirements associated with other facility components of small and sick newborn care. Click Go to The HR Tab if required"]
[null,"This will help you ensure that:  "]
[null,"a)  additional staff, such as data clerks for robust data systems are included & costed"]
[null,"b) facility staff ratios are adequate for the expected workload, which should include additional tasks related to all of these components "]
[null,"Note that we have also included infection prevention & control here to ensure users consider any staff requirements, such as housekeepers/cleaners & training needs"]
[null,"Select answer for each component listed below and add any relevant notes. "]
[]
[null,{"$f":"B$25","v":"Other Facility-Level Components of Small and Sick Newborn Care"},"Did you include staff requirements related to this component?",null,null,"User Notes"]
["Cols G& H have formula",{"$f":"B$26","v":"Robust data systems"},null,null,null,null,{"$f":"IF(C42=\"No & Should be included\", \"ERROR. GO BACK TO HUMAN RESOURCES\", \" \" )","v":" "}]
["Cols G& H have formula",{"$f":"B$27","v":"Linkage of maternal and newborn care"},null,null,null,null,{"$f":"IF(C43=\"No & Should be included\", \"ERROR. GO BACK TO HUMAN RESOURCES\", \" \" )","v":" "}]
["Cols G& H have formula",{"$f":"B$28","v":"Family & community involvement and support"},null,null,null,null," "]
["Cols G& H have formula",{"$f":"B$29","v":"Post-discharge follow-up at facility and at home"},null,null,null,null," "]
["Cols G& H have formula","Infection Prevention & Control",null,null,null,null,{"$f":"IF(C46=\"No & Should be included\", \"ERROR. GO BACK TO HUMAN RESOURCES\", \" \" )","v":" "}]
[]
[null,"2.2. Review if you included any additional training requirements for other facility components of small and sick newborn care. Click Go to The HR Tab if required"]
[null,"Select answer for each component listed below and add any relevant notes"]
[]
[null,{"$f":"B$25","v":"Other Facility-Level Components of Small and Sick Newborn Care"},"Did you include training requirements related to this component?",null,null,"User Notes"]
["Cols G& H have formula",{"$f":"B$26","v":"Robust data systems"},null,null,null,null,{"$f":"IF(C52=\"No & Should be included\", \"ERROR. GO BACK TO HUMAN RESOURCES\", \" \" )","v":" "}]
["Cols G& H have formula",{"$f":"B$27","v":"Linkage of maternal and newborn care"},null,null,null,null,{"$f":"IF(C53=\"No & Should be included\", \"ERROR. GO BACK TO HUMAN RESOURCES\", \" \" )","v":" "}]
["Cols G& H have formula",{"$f":"B$28","v":"Family & community involvement and support"},null,null,null,null," "]
["Cols G& H have formula",{"$f":"B$29","v":"Post-discharge follow-up at facility and at home"},null,null,null,null," "]
["Cols G& H have formula","Infection Prevention & Control",null,null,null,null,{"$f":"IF(C56=\"No & Should be included\", \"ERROR. GO BACK TO HUMAN RESOURCES\", \" \" )","v":" "}]
[]
[null,"STEP 3 - IDENTIFY ADDITIONAL STRATEGIES & COSTS ASSOCIATED WITH OTHER COMPONENTS OF THE MODEL OF CARE NOT INCLUDED ELSEWHERE"]
[null,"This is to account for any additional recurrent expenditure that was not costed under the previous modules."]
[null,"Remember that "]
[null,"a) as in the previous two steps, additional facility equipment and staff requirements should be costed under the equipment and human resources modules."]
[null,"b) additional infrastructure such as adequate space for mothers and families should be costed under infrastructure"]
[null,"Enter any additional costs in the blue cells. Grey cells are locked."]
[null,"You can enter sub-categories in dark blue cells. Yellow cells include a reminding menu of potential strategies to consider."]
[]
[null,{"$f":"CONCATENATE(\"3.1. Identify \", B69, \" strategies & estimate any additional costs at facility level\")","v":"3.1. Identify Robust Data Systems strategies & estimate any additional costs at facility level"}]
[]
[null,null,"Additional annual facility costs required"]
[null,"Robust Data Systems",{"$f":"List_Facility_Sizes","v":"Small"},"Medium","","User Notes","Reminder Notes"]
[null,"Consumables & other office-related costs",null,null,null,null,"Consider strategies and costs related to:   *Ensuring sufficient numbers of printed case record sheets & registries  * Providing an adequate supply of office consumables such as paper & print toner  *Regular audits & quality assurance   *Perinatal death reviews    * Regional meetings to improve data collection, analysis and use of data  * Developing and implementing facility protocols and standard operating procedures  *Community engagement and feedback.                              "]
[null,"Printing of case record sheets & registers",1000,1500]
[null,"Office equipment consumables such as paper & print toner"]
[null,"Perinatal death reviews"]
[null,"Team Reviews of the unit's data"]
[null,"Regional meetings with other facilities "]
[null,"Supporting a QoC champion in each facility "]
[null,"Developing and implementation of facility protocols"]
[null,"Family's feedback on services"]
[]
[]
[]
[]
[]
[]
[null,"Annual Additional Costs",{"$f":"IF(Name_Small=\"\",0,SUM(C70:C84))","v":1000},{"$f":"IF(Name_Medium=\"\",0,SUM(D70:D84))","v":1500},{"$f":"IF(Name_Large=\"\",0,SUM(E70:E84))","v":0}]
[]
[null,{"$f":"CONCATENATE(\"3.2. Identify \", B89, \" strategies & estimate any additional costs at facility level\")","v":"3.2. Identify Linkage of Maternal & Newborn Care strategies & estimate any additional costs at facility level"}]
[null,null,"Additional annual facility costs required",null,null,null,{"$f":"G69","v":"Reminder Notes"}]
[null,"Linkage of Maternal & Newborn Care",{"$f":"List_Facility_Sizes","v":"Small"},"Medium","","User Notes","Consider any additional costs for Level II facilities related to:  * Zero separation policy and *Mechanisms to foster collaboration among health care profesionals, including obstetricians, midwives, neonatologists and neonatal nurses. "]
[null,"Facility space inc. requirements for zero separation of mother and baby",null,null,null,"Included under infrastructure requirements"]
[null,"Mother's education to ensure zero separation policy"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Annual Additional Costs",{"$f":"IF(Name_Small=\"\",0,SUM(C90:C99))","v":0},{"$f":"IF(Name_Medium=\"\",0,SUM(D90:D99))","v":0},{"$f":"IF(Name_Large=\"\",0,SUM(E90:E99))","v":0}]
[]
[null,{"$f":"CONCATENATE(\"3.3. Identify \", B104, \" strategies & estimate any additional costs at facility level\")","v":"3.3. Identify Family & Community Involvement and Support strategies & estimate any additional costs at facility level"}]
[null,null,"Additional annual facility costs required"]
[null,"Family & Community Involvement and Support",{"$f":"List_Facility_Sizes","v":"Small"},"Medium","","User Notes",{"$f":"G69","v":"Reminder Notes"}]
[null,"Producing information, education and communications material in the local language",null,null,null,null,"Consider strategies related to:  *Compassionate and respectful care  *Mother/family participation in decision making and care provision                                                                                                                                                                                              Additional costs might include those associated with:  *Information, education & communication campaigns provided in the local language and tailored to each community  *Behavioural change interventions  *Developing and implementing facility protocols & standard operating procedures."]
[null,"Developing and implementing facility protocols and SoP"]
[null,"Linking families with community health workers"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Annual Additional Costs",{"$f":"IF(Name_Small=\"\",0,SUM(C105:C119))","v":0},{"$f":"IF(Name_Medium=\"\",0,SUM(D105:D119))","v":0},{"$f":"IF(Name_Large=\"\",0,SUM(E105:E119))","v":0}]
[]
[null,{"$f":"CONCATENATE(\"3.4. Identify \", B124, \" strategies & estimate any additional costs at facility level\")","v":"3.4. Identify Post-Discharge Follow-Up strategies & estimate any additional costs at facility level"}]
[null,null,"Additional annual facility costs required"]
[null,"Post-Discharge Follow-Up",{"$f":"List_Facility_Sizes","v":"Small"},"Medium","","User Notes",{"$f":"G69","v":"Reminder Notes"}]
[null,"Social and behavioral change interventions, inc. patient education",null,null,null,null,"Consider strategies and costs related to:  *Deploying community health workers to conduct post-discharge follow-up visits   *Appointment scheduling and reminders systems  *Patient education about the importance of post-discharge follow-up  *Addressing transport barriers, including financial support for transport to attend post-discharge follow-up appointments"]
[null,"Transport vouchers for families to visit health facility for follow-up"]
[null,"Developing and disseminating protocols for  discharge & post-discharge plans"]
[null,"Home visits by trained community health workers",2200,4400,null,"Assume annual average of $3 per newborn"]
[null,"SMS/Phone reminder system"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Annual Additional Costs",{"$f":"IF(Name_Small=\"\",0,SUM(C125:C139))","v":2200},{"$f":"IF(Name_Medium=\"\",0,SUM(D125:D139))","v":4400},{"$f":"IF(Name_Large=\"\",0,SUM(E125:E139))","v":0}]
[]
[null,{"$f":"CONCATENATE(\"3.5. Identify \", B144, \" strategies & estimate any additional costs at facility level\")","v":"3.5. Identify Infection prevention & control inc. WASH strategies & estimate any additional costs at facility level"}]
[null,null,"Additional annual facility costs required"]
[null,"Infection prevention & control inc. WASH",{"$f":"List_Facility_Sizes","v":"Small"},"Medium","","User Notes",{"$f":"G69","v":"Reminder Notes"}]
[null,"Cleaning & linen management protocols inc. daily, weekly and monthly routines",null,null,null,null,"Consider strategies & costs related to: *Use of personal protective equipment *Cleaning & linen management protocols (e.g. availability of consumables) * Waste management  *Microbiological surveillance  *Fire safety  *WASH."]
[null,"Availability of cleaning & linen management consumables"]
[null,"Waste management protocols"]
[null,"Microbiological surveillance"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Annual Additional Costs",{"$f":"IF(Name_Small=\"\",0,SUM(C145:C159))","v":0},{"$f":"IF(Name_Medium=\"\",0,SUM(D145:D159))","v":0},{"$f":"IF(Name_Large=\"\",0,SUM(E145:E159))","v":0}]
[]
[null,{"$f":"CONCATENATE(\"3.6. Identify \", B164, \" strategies applicable in country with costs not already included in other modules & estimate any additional costs at facility level\")","v":"3.6. Identify Other strategies applicable in country with costs not already included in other modules & estimate any additional costs at facility level"}]
[null,null,"Additional annual facility costs required"]
[null,"Other",{"$f":"List_Facility_Sizes","v":"Small"},"Medium","","User Notes"]
[null,"Utilities?"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Annual Additional Costs",{"$f":"IF(Name_Small=\"\",0,SUM(C165:C174))","v":0},{"$f":"IF(Name_Medium=\"\",0,SUM(D165:D174))","v":0},{"$f":"IF(Name_Large=\"\",0,SUM(E165:E174))","v":0}]
[]
[]
[null,"STEP 4 - REVIEW & VALIDATE ANNUAL ADDITIONAL COSTS FOR OTHER COMPONENTS OF THE MODEL OF CARE (BY TYPOLOGY)"]
[]
[null,"4.1. Review Additional Facility Annual Costs to deliver Small and Sick Newborn Care not included elsewhere"]
[]
[null,"Other Components - Annual Costs",{"$f":"List_Facility_Sizes","v":"Small"},"Medium",""]
[null,{"$f":"B69","v":"Robust Data Systems"},{"$f":"IF(Number_Beds_Small=0,0,C85)","v":1000},{"$f":"IF(Number_Beds_Medium=0,0,D85)","v":1500},{"$f":"IF(Number_Beds_Large=0,0,E85)","v":0}]
[null,{"$f":"B89","v":"Linkage of Maternal & Newborn Care"},{"$f":"IF(Number_Beds_Small=0,0,C100)","v":0},{"$f":"IF(Number_Beds_Medium=0,0,D100)","v":0},{"$f":"IF(Number_Beds_Large=0,0,E100)","v":0}]
[null,{"$f":"B104","v":"Family & Community Involvement and Support"},{"$f":"IF(Number_Beds_Small=0,0,C120)","v":0},{"$f":"IF(Number_Beds_Medium=0,0,D120)","v":0},{"$f":"IF(Number_Beds_Large=0,0,E120)","v":0}]
[null,{"$f":"B124","v":"Post-Discharge Follow-Up"},{"$f":"IF(Number_Beds_Small=0,0,C140)","v":2200},{"$f":"IF(Number_Beds_Medium=0,0,D140)","v":4400},{"$f":"IF(Number_Beds_Large=0,0,E140)","v":0}]
[null,{"$f":"B144","v":"Infection prevention & control inc. WASH"},{"$f":"IF(Number_Beds_Small=0,0,C160)","v":0},{"$f":"IF(Number_Beds_Medium=0,0,D160)","v":0},{"$f":"IF(Number_Beds_Large=0,0,E160)","v":0}]
[null,{"$f":"B164","v":"Other"},{"$f":"IF(Number_Beds_Small=0,0,C175)","v":0},{"$f":"IF(Number_Beds_Medium=0,0,D175)","v":0},{"$f":"IF(Number_Beds_Large=0,0,E175)","v":0}]
[null,"Total Other Model of Care Components",{"$f":"IF(Number_Beds_Small=0,0,SUM(C183:C188))","v":3200},{"$f":"IF(Number_Beds_Medium=0,0,SUM(D183:D188))","v":5900},{"$f":"IF(Number_Beds_Large=0,0,SUM(E183:E188))","v":0}]
[]
[]
[null,"4.2. Review Other Components - Annual Costs by Facility Size and Location Typology (after applying cost loadings from inputs)"]
[null,"This table uses cost loadings to estimate costs by facility location/cost typology"]
[null,"As required, estimates can be modified in the dark blue cells.",null,null,null,{"$f":"'4.Equip_Other_Plan&Budget'!G150","v":"Enter user-defined costs here. Note they override modelled estimates"},null,null,"User Notes"]
[null,{"$f":"B182","v":"Other Components - Annual Costs"},{"$f":"List_Facility_Sizes","v":"Small"},"Medium","",{"$f":"List_Facility_Sizes","v":"Small"},"Medium",""]
[null,{"$f":"List_Costing_Groups","v":"Mid Cost "},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Small=\"\",0,C$189*(1+Percent_Loading_Mid)))","v":3200},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Medium=\"\",0,D$189*(1+Percent_Loading_Mid)))","v":5900},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Large=\"\",0,E$189*(1+Percent_Loading_Mid)))","v":0}]
[null,"High Cost",{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Small=\"\",0,C$189*(1+Percent_Loading_High)))","v":3520.0000000000005},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Medium=\"\",0,D$189*(1+Percent_Loading_High)))","v":6490.0000000000009},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Large=\"\",0,E$189*(1+Percent_Loading_High)))","v":0}]
[null,"Very High Cost",{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Small=\"\",0,C$189*(1+Percent_Loading_VHigh)))","v":3840},{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Medium=\"\",0,D$189*(1+Percent_Loading_VHigh)))","v":7080},{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Large=\"\",0,E$189*(1+Percent_Loading_VHigh)))","v":0}]
[]
[null,"4.3. Review costs that will be used for final results."]
[null,"This table shows the costs to be used in the final estimates. "]
[null,{"$f":"B182","v":"Other Components - Annual Costs"},{"$f":"List_Facility_Sizes","v":"Small"},"Medium",""]
[null,{"$f":"List_Costing_Groups","v":"Mid Cost "},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Small=\"\",0,IF(F196>1,F196,C196)))","v":3200},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Medium=\"\",0,IF(G196>1,G196,D196)))","v":5900},{"$f":"IF(Name_Cost_Mid=\"\",0,IF(Name_Large=\"\",0,IF(H196>1,H196,E196)))","v":0}]
[null,"High Cost",{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Small=\"\",0,IF(F197>1,F197,C197)))","v":3520.0000000000005},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Medium=\"\",0,IF(G197>1,G197,D197)))","v":6490.0000000000009},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Large=\"\",0,IF(H197>1,H197,E197)))","v":0}]
[null,"Very High Cost",{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Small=\"\",0,IF(F198>1,F198,C198)))","v":3840},{"$f":"IF(Name_Cost_High=\"\",0,IF(Name_Medium=\"\",0,IF(G198>1,G198,D198)))","v":7080},{"$f":"IF(Name_Cost_VHigh=\"\",0,IF(Name_Large=\"\",0,IF(H198>1,H198,E198)))","v":0}]

{"sheet":"8.National_Regional_Plan&Budget","index":8,"n_rows":148,"n_cols":7,"rows_kept":148,"cut":false,"hidden":false,"merged":[[3,1,3,3],[4,1,4,3],[5,1,5,3],[6,1,6,3],[19,3,19,4],[74,5,83,7],[94,5,94,7],[85,5,85,7],[86,5,92,7],[36,5,36,7],[37,5,43,7],[64,5,64,7],[65,5,71,7],[73,5,73,7],[45,5,45,7],[2,1,2,9],[27,1,27,4],[113,5,113,7],[114,5,128,7],[46,5,62,7],[104,5,104,7],[105,5,111,7],[95,5,101,7],[20,6,20,10],[21,6,21,10],[22,6,22,10],[23,6,23,10],[24,6,24,10],[25,6,25,10],[26,6,26,10],[27,6,27,10]]}
[]
[null,"LEADERSHIP AND NATIONAL & REGIONAL LEVEL STRATEGIES  - PLANNING & BUDGETING "]
[null,"WARNING: Do not copy and paste data into this workbook. Doing so may insert conflicting code and remove validation. Please enter data manually to ensure proper functionality"]
[null,"MODULE OVERVIEW"]
[null,"Identify and cost higher level education courses to upskill human resources"]
[null,"* Estimate number of people that would receive a scholarship to attend identified courses"]
[null,"* Estimate tuition and living allowances expenses"]
[null,"Identify national and regional level strategies and associated annual costs to support the scale-up"]
[null,"Note that cross-cutting issues corresponding to the Vision & Leadership component, such as high-level oversight and management & development of templates for guidelines are listed first"]
[null,"Review summary table and chart with total costs"]
[null,"Remember:"]
[null,"Light blue cells are user inputs."]
[null,"Yellow cells are tool calculations or contain reminder notes about potential strategies. They cannot be manually changed by the user"]
[]
[null,"Step 1. Identify and cost the delivery of higher education courses to upskill human resources"]
[null,"Include here any higher education courses to be funded against the scale-up budget"]
[null,"First, enter the number of trainees funded per year"]
[null,"Second, enter the tuition fees per person per year"]
[null,"Third, enter other costs such as scholarship living allowances."]
[null,null,null,"Costs per trainee per year funded against the scale-up"]
[null,"Higher Education Courses","Number of funded trainees per year","Tuition Fees per person per year","Scholarship Living Allowances & Additional Costs per person per year","Estimated Annual Cost - All Trainees","User Notes"]
[null,"Advanced Diploma for Nurses - 1 year",10,824,5642,{"$f":"(D22+E22)*C22","v":64660}]
[null,"Masters of Science in neonatologoy - 2 years",10,1529,5642,{"$f":"(D23+E23)*C23","v":71710}]
[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,"Annual Costs of Higher Education Courses",null,null,null,{"$f":"SUM(F22:F27)","v":136370}]
[]
[]
[null,"Step 2 Identify & cost national and regional level strategies for leading and supporting the scale-up"]
[null,"First, enter national and regional level strategies required to support the scale-up and facilities delivering good quality of care, including any costs for finalising and disseminating the national plan."]
[null,"Second, enter start up costs including any capital investments that need to be incurred in year one of the scale-up"]
[null,"Third, enter annual costs for subsequent years"]
[null,"Remember that for regional/provincial strategies, country-wide costs should be entered, taking into consideration the number of regions/provinces included in scale-up plans & budgets"]
[]
[null,"National Plan & high level oversight and management","Start up Costs (Year One)","Annual Costs in Subsequent Years","User Notes","Reminder notes "]
[null,"National Plan development and dissemination",null,null,null,"In addition to the costs of developing and disseminating the national plan, consider for example, the need of additional staff for management & oversight of the scale-up, as well as costs associated with financing mechanisms to ensure timely funding to facilities."]
[null,"Design & implementation of financing mechanisms to ensure timely funding to facilities"]
[null,"Additional auditing, financial oversight?"]
[]
[]
[]
[null,{"$f":"CONCATENATE(,B37, \" costs\")","v":"National Plan & high level oversight and management costs"},{"$f":"SUM(C38:C43)","v":0},{"$f":"SUM(D38:D43)","v":0}]
[]
[null,"Templates for guidelines, protocols and SoP",{"$f":"C$37","v":"Start up Costs (Year One)"},{"$f":"D$37","v":"Annual Costs in Subsequent Years"},{"$f":"E$37","v":"User Notes"},{"$f":"F$37","v":"Reminder notes "}]
[null,"Infrastructure",90000,null,null,"Consider the development of templates as required for each component as well as those included in the standards for improving the quality of care for small and sick newborns, such as guidelines, protocols and SoP for evidence-based practices for routine care and management of complications."]
[null,"Equipment, including for maintenance",70000]
[null,"Human Resources"]
[null,"Referral systems, including admission & discharge criteria and protocols"]
[null,"Robust data systems, including setting up national minimum dataset"]
[null,"Linkages of maternal & Neonatal care"]
[null,"Family and Community Involvement and Support"]
[null,"Post-discharge Follow-Up"]
[null,"Evidence-base practice (clinical)"]
[null,"Infection and prevention control"]
[]
[]
[]
[]
[]
[null,"Other"]
[null,{"$f":"CONCATENATE(,B46, \" costs\")","v":"Templates for guidelines, protocols and SoP costs"},{"$f":"SUM(C47:C62)","v":160000},{"$f":"SUM(D47:D62)","v":0}]
[]
[null,"Infrastructure",{"$f":"C37","v":"Start up Costs (Year One)"},{"$f":"D37","v":"Annual Costs in Subsequent Years"},{"$f":"E37","v":"User Notes"},{"$f":"F$37","v":"Reminder notes "}]
[null,"Commissioning Processes",null,null,null,"Consider for example, commissioning strategies for building and rehabilitating facilities, including the development of additional specifications required for tenders."]
[]
[]
[]
[]
[]
[null,{"$f":"CONCATENATE(,B65, \" costs\")","v":"Infrastructure costs"},{"$f":"SUM(C66:C71)","v":0},{"$f":"SUM(D66:D71)","v":0}]
[]
[null,"Equipment & Commodities",{"$f":"C$37","v":"Start up Costs (Year One)"},{"$f":"D$37","v":"Annual Costs in Subsequent Years"},{"$f":"E$37","v":"User Notes"},{"$f":"F$37","v":"Reminder notes "}]
[null,"Commissioning processes for equipment",null,null,null,"Consider for example, commissioning strategies for purchasing equipment and ensuring adequate supply of spare parts and consumables. Also consider any additional costs at regional or national level related to maintenance, decommissioning, and asset management not already covered by existing programs. Costs related to management systems for facility assets and drugs and medical supplies  that are not already covered by existing programs should also be included. "]
[null,"Asset management system"]
[null,"Drugs and medical supplies management systems"]
[]
[]
[]
[]
[]
[]
[null,{"$f":"CONCATENATE(,B74, \" costs\")","v":"Equipment & Commodities costs"},{"$f":"SUM(C75:C83)","v":0},{"$f":"SUM(D75:D83)","v":0}]
[]
[null,"Human Resources",{"$f":"C$37","v":"Start up Costs (Year One)"},{"$f":"D$37","v":"Annual Costs in Subsequent Years"},{"$f":"E$37","v":"User Notes"},{"$f":"F$37","v":"Reminder notes "}]
[null,"Review training curriculum",null,null,null,"Consider for example, strategies related to review of pre-service training curricula or to build the capacity of regional staff to supervise, mentor and coach facility teams"]
[]
[]
[]
[]
[]
[null,{"$f":"CONCATENATE(,B86, \" costs\")","v":"Human Resources costs"},{"$f":"SUM(C87:C92)","v":0},{"$f":"SUM(D87:D92)","v":0}]
[]
[null,"Referral Systems",{"$f":"C37","v":"Start up Costs (Year One)"},{"$f":"D37","v":"Annual Costs in Subsequent Years"},{"$f":"E37","v":"User Notes"},{"$f":"F$37","v":"Reminder notes "}]
[null,null,null,null,null,"Consider strategies to improve coordination and communication systems between various levels of facilities, including regional investments in technology"]
[]
[]
[]
[]
[]
[null,{"$f":"CONCATENATE(,B95, \" costs\")","v":"Referral Systems costs"},{"$f":"SUM(C96:C101)","v":0},{"$f":"SUM(D96:D101)","v":0}]
[]
[]
[null,{"$f":"'7.Other_Facility_Plan&Budget'!B69","v":"Robust Data Systems"},{"$f":"C37","v":"Start up Costs (Year One)"},{"$f":"D37","v":"Annual Costs in Subsequent Years"},{"$f":"E37","v":"User Notes"},{"$f":"F$37","v":"Reminder notes "}]
[null,"Annual Implementation Reviews, inc. dissemination meetings for regions & facilities",null,null,null,"Consider for example strategies needed to support data management such as developing the national minimum dataset, as well as annual implementation reviews and a 3 or 5 year evaluation of the scale-up. Also consider any strategies required to support implementation of perinatal death reviews as required."]
[null,"Three year evaluation, inc. annual implementation reviews."]
[]
[]
[]
[]
[null,{"$f":"CONCATENATE(,B105, \" costs\")","v":"Robust Data Systems costs"},{"$f":"SUM(C106:C111)","v":0},{"$f":"SUM(D106:D111)","v":0}]
[]
["To decide","Other Components & Strategies",{"$f":"C37","v":"Start up Costs (Year One)"},{"$f":"D37","v":"Annual Costs in Subsequent Years"},{"$f":"E37","v":"User Notes"},{"$f":"F$37","v":"Reminder notes "}]
[null,null,null,null,null,"Consider strategies for the remaining components, not included elsewhere."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"CONCATENATE(,B114, \" costs\")","v":"Other Components & Strategies costs"},{"$f":"SUM(C115:C128)","v":0},{"$f":"SUM(D115:D128)","v":0}]
[]
[null,"Step 3. Review cost of national and regional level strategies, including higher education courses"]
[null,"This table shows total national and regional level costs to support the scale-up and so are not included in facility typology cost analytics"]
[]
[null,{"$f":"'9.Financing_Typology_Analytics'!E40","v":"All financial figures are in USD - Base Year (2024)"}]
[null,"National & Regional Level Costs",{"$f":"C37","v":"Start up Costs (Year One)"},{"$f":"$D$37","v":"Annual Costs in Subsequent Years"}]
[]
[null,{"$f":"LEFT(B44,(LEN(B44)-6))","v":"National Plan & high level oversight and management"},{"$f":"C44","v":0},{"$f":"D44","v":0}]
[null,{"$f":"LEFT(B63,(LEN(B63)-6))","v":"Templates for guidelines, protocols and SoP"},{"$f":"C63","v":160000},{"$f":"D63","v":0}]
[null,{"$f":"LEFT(B72,(LEN(B72)-6))","v":"Infrastructure"},{"$f":"C72","v":0},{"$f":"D72","v":0}]
[null,{"$f":"LEFT(B84,(LEN(B84)-6))","v":"Equipment & Commodities"},{"$f":"C84","v":0},{"$f":"D84","v":0}]
[null,{"$f":"LEFT(B93,(LEN(B93)-6))","v":"Human Resources"},{"$f":"C93","v":0},{"$f":"D93","v":0}]
[null,{"$f":"LEFT(B102,(LEN(B102)-6))","v":"Referral Systems"},{"$f":"C102","v":0},{"$f":"D102","v":0}]
[null,{"$f":"LEFT(B112,(LEN(B112)-6))","v":"Robust Data Systems"},{"$f":"C112","v":0},{"$f":"D112","v":0}]
[null,{"$f":"LEFT(B129,(LEN(B129)-6))","v":"Other Components & Strategies"},{"$f":"C129","v":0},{"$f":"D129","v":0}]
[null,"National and Regional Strategies",{"$f":"SUM(C137:C144)","v":160000},{"$f":"SUM(D137:D144)","v":0}]
[null,{"$f":"B21","v":"Higher Education Courses"},{"$f":"Cost_HigherEducation_Annual","v":136370},{"$f":"Cost_HigherEducation_Annual","v":136370}]
[null,"Total Annual National and Regional Costs",{"$f":"Cost_National_Year1+C146","v":296370},{"$f":"Cost_National_After_Year1+D146","v":136370}]
[null,"IMPORTANT:  Do not cut charts. Always use copy & paste"]

{"sheet":"9.Financing_Typology_Analytics","index":9,"n_rows":143,"n_cols":9,"rows_kept":143,"cut":false,"hidden":false,"merged":[[80,4,80,7],[81,4,81,7],[82,4,82,7],[83,4,83,7],[38,4,38,7],[12,4,12,12],[28,8,28,12],[23,8,23,12],[24,8,24,12],[25,8,25,12],[26,8,26,12],[27,8,27,12]]}
[null,"Dynamic List_ Size Typologies",null,null,"Dynamic List Cost Typologies"]
[{"$f":"IF(B2=\"\",\"\",MAX(A$1:A1)+1)","v":1},{"$f":"Name_Small","v":"Small"},{"$f":"IFERROR(INDEX($B$2:$B$4,MATCH(ROW()-ROW($C$1),$A$2:$A$4,0)),\"\")","v":"Small"},{"$f":"IF(E2=\"\",\"\",MAX(D1:D$1)+1)","v":1},{"$f":"Name_Cost_Mid","v":"Mid Cost "},{"$f":"IFERROR(INDEX($E$2:$E$4,MATCH(ROW()-ROW($F$1),$D$2:$D$4,0)),\"\")","v":"Mid Cost "}]
[{"$f":"IF(B3=\"\",\"\",MAX(A$1:A2)+1)","v":2},{"$f":"Name_Medium","v":"Medium"},{"$f":"IFERROR(INDEX($B$2:$B$4,MATCH(ROW()-ROW($C$1),$A$2:$A$4,0)),\"\")","v":"Medium"},{"$f":"IF(E3=\"\",\"\",MAX(D$1:D2)+1)","v":2},{"$f":"Name_Cost_High","v":"High Cost"},{"$f":"IFERROR(INDEX($E$2:$E$4,MATCH(ROW()-ROW($F$1),$D$2:$D$4,0)),\"\")","v":"High Cost"}]
[{"$f":"IF(B4=\"\",\"\",MAX(A$1:A3)+1)","v":""},{"$f":"Name_Large","v":""},{"$f":"IFERROR(INDEX($B$2:$B$4,MATCH(ROW()-ROW($C$1),$A$2:$A$4,0)),\"\")","v":""},{"$f":"IF(E4=\"\",\"\",MAX(D$1:D3)+1)","v":3},{"$f":"Name_Cost_VHigh","v":"Very High Cost"},{"$f":"IFERROR(INDEX($E$2:$E$4,MATCH(ROW()-ROW($F$1),$D$2:$D$4,0)),\"\")","v":"Very High Cost"}]
[]
[null,"Dynamic List Equipment Needs",null,null,"Dynamic List Standard/Hard-to-recruit",null,null,"Dynamic List New Construction"]
[{"$f":"IF(B7=\"\",\"\",MAX(A6:A$6)+1)","v":1},{"$f":"Name_Equipment_Need_Major","v":"Major need"},{"$f":"IFERROR(INDEX($B$7:$B$9,MATCH(ROW()-ROW($C$6),$A$7:$A$9,0)),\"\")","v":"Major need"},{"$f":"IF(E7=\"\",\"\",MAX(D$6:D6)+1)","v":1},{"$f":"Name_HR_Standard","v":"Standard area"},{"$f":"IFERROR(INDEX($E$7:$E$9,MATCH(ROW()-ROW($F$6),$D$7:$D$9,0)),\"\")","v":"Standard area"},{"$f":"IF(H7=\"\",\"\",MAX(G$6:G6)+1)","v":1},{"$f":"Name_Construction_New","v":"New Construction"},{"$f":"IFERROR(INDEX($H$7:$H$9,MATCH(ROW()-ROW($I$6),$G$7:$G$8,0)),\"\")","v":"New Construction"}]
[{"$f":"IF(B8=\"\",\"\",MAX(A$6:A7)+1)","v":2},{"$f":"Name_Equipment_Need_Partial","v":"Partial need"},{"$f":"IFERROR(INDEX($B$7:$B$9,MATCH(ROW()-ROW($C$6),$A$7:$A$9,0)),\"\")","v":"Partial need"},{"$f":"IF(E8=\"\",\"\",MAX(D$6:D7)+1)","v":2},{"$f":"Name_HR_HardRecruit","v":"Hard-to-Recruit"},{"$f":"IFERROR(INDEX($E$7:$E$9,MATCH(ROW()-ROW($F$6),$D$7:$D$9,0)),\"\")","v":"Hard-to-Recruit"},{"$f":"IF(H8=\"\",\"\",MAX(G$6:G7)+1)","v":2},{"$f":"Name_Construction_Rehab","v":"Rehabilitation"},{"$f":"IFERROR(INDEX($H$7:$H$9,MATCH(ROW()-ROW($I$6),$G$7:$G$8,0)),\"\")","v":"Rehabilitation"}]
[{"$f":"IF(B9=\"\",\"\",MAX(A$6:A8)+1)","v":3},{"$f":"Name_Equipment_Need_Limited","v":"Limited need"},{"$f":"IFERROR(INDEX($B$7:$B$9,MATCH(ROW()-ROW($C$6),$A$7:$A$9,0)),\"\")","v":"Limited need"},{"$f":"IF(E9=\"\",\"\",MAX(D$6:D8)+1)","v":""},{"$f":"Name_HR_VHardRecruit","v":""},{"$f":"IFERROR(INDEX($E$7:$E$9,MATCH(ROW()-ROW($F$6),$D$7:$D$9,0)),\"\")","v":""}]
[]
[]
[null,null,null,null,"FINANCING (1) - FACILITY TYPOLOGY ANALYTICS"]
[null,null,null,null,"WARNING: Do not copy and paste data into this workbook. Doing so may insert conflicting code and remove validation. Please enter data manually & choose from dropdown menu where available to ensure proper functionality "]
[null,null,null,null,"MODULE OVERVIEW"]
[null,null,null,null,"This is the first financing module, which provides cost analytics by facility typology to support strategic decision-making"]
[null,null,null,null,"Select facility typologies for calculating key system parameters and costs "]
[null,null,null,null,"Select facility typologies from the dropdown menu"]
[null,null,null,null,"Review system parameters and costs by typology"]
[]
[null,null,null,null,"STEP 1. SELECT FACILITY TYPOLOGIES FOR DISPLAYING TOTAL COSTS "]
[]
[null,null,null,null,"1.1. Select a costed typology by clicking on each cell & choose from the dropdown menu.  "]
[null,null,null,null,"Remember do not copy/paste cut/paste into these cells. Only choose from the dropdown menu"]
[null,null,null,null,"Facility Typology","Facility Type 1","Facility Type 2","Facility Type 3","User Notes"]
[null,null,null,null,{"$f":"'1.General_Inputs_Plan&Budget'!B35","v":"SIZE"},"Small","Medium","Medium"]
[null,null,null,null,{"$f":"'1.General_Inputs_Plan&Budget'!B40","v":"COST/LOCATION"},"Mid Cost ","Mid Cost ","Mid Cost "]
[null,null,null,null,{"$f":"'1.General_Inputs_Plan&Budget'!B45","v":"CONSTRUCTION TYPE"},"New Construction","New Construction","Rehabilitation"]
[null,null,null,null,{"$f":"'1.General_Inputs_Plan&Budget'!B49","v":"EQUIPMENT NEEDS"},"Major need","Major need","Partial need"]
[null,null,null,null,{"$f":"'1.General_Inputs_Plan&Budget'!B54","v":"RECRUITMENT CHALLENGES"},"Standard area","Standard area","Standard area"]
[]
[null,null,null,null,"1.2. Enter a short name for the 'typical' facility. "]
[null,null,null,null,"This name will be used for displaying charts, so try to keep it short"]
[null,null,null,null,null,{"$f":"F24","v":"Facility Type 1"},{"$f":"G24","v":"Facility Type 2"},"Facility Type 3"]
[null,null,null,null,"Typical Facility Name/Description:","Small","MediumNew","MediumRehab"]
[]
[null,null,null,null,"STEP 2. REVIEW FACILITY COST ANALYTICS "]
[null,null,null,null,"Note: If column values are 0, the items or the typology has not been costed. "]
[null,null,null,null,"Go back to the previous step and make sure you choose a typology from the dropdown menu"]
[null,null,null,null,"FACILITY COSTS (1)"]
[null,null,null,null,{"$f":"_xlfn.CONCAT(\"All financial figures are in \", '1.General_Inputs_Plan&Budget'!C19, \" - Base Year (\", '1.General_Inputs_Plan&Budget'!C27, \")\")","v":"All financial figures are in USD - Base Year (2024)"}]
[null,null,null,null,"Service Parameter/Cost",{"$f":"IF(F34=\"\",F33, F34)","v":"Small"},{"$f":"IF(G34=\"\",G33, G34)","v":"MediumNew"},{"$f":"IF(H34=\"\",H33, H34)","v":"MediumRehab"}]
[null,null,null,null,"Expected annual number of admissions (#)",{"$f":"Admissions(Typology1_Size,Admissions_All_Range)","v":673},{"$f":"Admissions(Typology2_Size,Admissions_All_Range)","v":1345},{"$f":"Admissions(Typology3_Size,Admissions_All_Range)","v":1345}]
[null,null,null,null,"Number of beds required (#)",{"$f":"Beds(Typology1_Size,Number_Beds_All_Range)","v":14},{"$f":"Beds(Typology2_Size,Number_Beds_All_Range)","v":28},{"$f":"Beds(Typology3_Size,Number_Beds_All_Range)","v":28}]
[null,null,null,null,"Total floor space (Sq. Mts.)",{"$f":"FloorSpace(Typology1_Size, Floor_Space_All)","v":325},{"$f":"FloorSpace(Typology2_Size, Floor_Space_All)","v":553},{"$f":"FloorSpace(Typology3_Size, Floor_Space_All)","v":553}]
[null,null,null,null,"FACILITY CAPITAL COSTS",{"$f":"F46+F47+F52","v":{"$error":"#NAME?"}},{"$f":"G46+G47+G52","v":{"$error":"#NAME?"}},{"$f":"H46+H47+H52","v":{"$error":"#NAME?"}}]
[null,null,null,null,"Infrastructure ",{"$f":"CostBuilding(Typology1_Building,Typology1_Costs,Typology1_Size,Cost_Infr_All_New_Range,Cost_Infr_All_Rehab_Range)","v":217750},{"$f":"CostBuilding(Typology2_Building,Typology2_Costs,Typology2_Size, Cost_Infr_All_New_Range,Cost_Infr_All_Rehab_Range)","v":370510},{"$f":"CostBuilding(Typology3_Building,Typology3_Costs,Typology3_Size, Cost_Infr_All_New_Range,Cost_Infr_All_Rehab_Range)","v":221200}]
[null,null,null,null,"Equipment",{"$f":"SUM(F48:F51)","v":{"$error":"#NAME?"}},{"$f":"SUM(G48:G51)","v":{"$error":"#NAME?"}},{"$error":"#NAME?"}]
[null,null,null,null,"Main Equipment - Acquisition",{"$f":"CostEquipment(Typology1_Equipment_Need,Typology1_Size,Equipment_Need_All_Range,Cost_Equipment_All_Range)","v":{"$error":"#NAME?"}},{"$f":"CostEquipment(Typology2_Equipment_Need,Typology2_Size,Equipment_Need_All_Range,Cost_Equipment_All_Range)","v":{"$error":"#NAME?"}},{"$f":"CostEquipment(Typology3_Equipment_Need,Typology3_Size,Equipment_Need_All_Range,Cost_Equipment_All_Range)","v":{"$error":"#NAME?"}}]
[null,null,null,null,"Main Equipment - Distribution",{"$f":"CostTransportEquip(Typology1_Equipment_Need,Typology1_Size,Typology1_Costs,Equipment_Need_All_Range,Cost_Equipm_Transport_All_Range)","v":{"$error":"#NAME?"}},{"$f":"CostTransportEquip(Typology2_Equipment_Need,Typology2_Size,Typology2_Costs,Equipment_Need_All_Range,Cost_Equipm_Transport_All_Range)","v":{"$error":"#NAME?"}},{"$f":"(CostTransportEquip(Typology3_Equipment_Need,Typology3_Size,Typology3_Costs,Equipment_Need_All_Range,Cost_Equipm_Transport_All_Range))","v":{"$error":"#NAME?"}}]
[null,null,null,null,"Main Equipment - Buffer Stocks",{"$f":"CostBufferStocks(Typology1_Equipment_Need,Typology1_Size,Typology1_Costs,Equipment_Need_All_Range,Cost_Equipm_Buffer_All_Range)","v":{"$error":"#NAME?"}},{"$f":"CostBufferStocks(Typology2_Equipment_Need,Typology2_Size,Typology2_Costs,Equipment_Need_All_Range,Cost_Equipm_Buffer_All_Range)","v":{"$error":"#NAME?"}},{"$f":"CostBufferStocks(Typology3_Equipment_Need,Typology3_Size,Typology3_Costs,Equipment_Need_All_Range,Cost_Equipm_Buffer_All_Range)","v":{"$error":"#NAME?"}}]
[null,null,null,null,"Furniture & other equipment",{"$f":"CostFurniture(Typology1_Equipment_Need,Typology1_Size,Typology1_Costs,Equipment_Need_All_Range,Cost_Furniture_All_Range)","v":23000},{"$f":"CostFurniture(Typology2_Equipment_Need,Typology2_Size,Typology2_Costs,Equipment_Need_All_Range,Cost_Furniture_All_Range)","v":23000},{"$f":"CostFurniture(Typology3_Equipment_Need,Typology3_Size,Typology3_Costs,Equipment_Need_All_Range,Cost_Furniture_All_Range)","v":10350}]
[null,null,null,null,"Other Capital",{"$f":"F53+F54","v":100000},{"$f":"G53+G54","v":100000},{"$f":"H53+H54","v":100000}]
[null,null,null,null,"Ambulance ",{"$f":"CostAmbulanceVehicle(Typology1_Size,Cost_AmbulanceVehicle_All_Range)","v":100000},{"$f":"CostAmbulanceVehicle(Typology2_Size,Cost_AmbulanceVehicle_All_Range)","v":100000},{"$f":"CostAmbulanceVehicle(Typology3_Size,Cost_AmbulanceVehicle_All_Range)","v":100000}]
[null,null,null,null,"Other (2)",{"$f":"CostRecruitCapital(Typology1_HR,Typology1_Size,Cost_Recruit_Capital_All_Range)","v":0},{"$f":"CostRecruitCapital(Typology2_HR,Typology2_Size,Cost_Recruit_Capital_All_Range)","v":0},{"$f":"CostRecruitCapital(Typology3_HR,Typology3_Size,Cost_Recruit_Capital_All_Range)","v":0}]
[null,null,null,null,"FACILITY RECURRENT COSTS",{"$f":"F56+F59+F62","v":{"$error":"#NAME?"}},{"$f":"G56+G59+G62","v":{"$error":"#NAME?"}},{"$f":"H56+H59+H62","v":{"$error":"#NAME?"}}]
[null,null,null,null,"Human Resources",{"$f":"F57+F58","v":148080},{"$f":"G57+G58","v":243580},243580]
[null,null,null,null,"Salaries",{"$f":"CostSalaries(Typology1_HR,Typology1_Size,Cost_HR_All_Range)","v":140200},{"$f":"CostSalaries(Typology2_HR,Typology2_Size,Cost_HR_All_Range)","v":228700},{"$f":"CostSalaries(Typology3_HR,Typology3_Size,Cost_HR_All_Range)","v":228700}]
[null,null,null,null,"Development & Incentives (3)",{"$f":"CostDevelopmentHR(Typology1_Size,Typology1_Costs,Cost_DevelopHR_All_Range)+CostRecruitAnnual(Typology1_HR,Typology1_Size,Cost_Recruit_Annual_All_Range)","v":7880},{"$f":"CostDevelopmentHR(Typology2_Size,Typology2_Costs,Cost_DevelopHR_All_Range)+CostRecruitAnnual(Typology2_HR,Typology2_Size,Cost_Recruit_Annual_All_Range)","v":14880},{"$f":"CostDevelopmentHR(Typology3_Size,Typology3_Costs,Cost_DevelopHR_All_Range)+CostRecruitAnnual(Typology3_HR,Typology3_Size,Cost_Recruit_Annual_All_Range)","v":14880}]
[null,null,null,null,"Equipment",{"$f":"F60+F61","v":{"$error":"#NAME?"}},{"$f":"G60+G61","v":{"$error":"#NAME?"}},{"$error":"#NAME?"}]
[null,null,null,null,"Regular Maintenance (4)",{"$f":"CostMaintenance(Typology1_Size,Typology1_Costs,Cost_Maintenance_All_Range)","v":{"$error":"#NAME?"}},{"$f":"CostMaintenance(Typology2_Size,Typology2_Costs,Cost_Maintenance_All_Range)","v":{"$error":"#NAME?"}},{"$f":"CostMaintenance(Typology3_Size,Typology3_Costs,Cost_Maintenance_All_Range)","v":{"$error":"#NAME?"}}]
[null,null,null,null,"Consumables & Renewables",{"$f":"CostConsumables(Typology1_Size,Typology1_Costs,Cost_Consumables_All_Range)","v":{"$error":"#NAME?"}},{"$f":"CostConsumables(Typology2_Size,Typology2_Costs,Cost_Consumables_All_Range)","v":{"$error":"#NAME?"}},{"$f":"CostConsumables(Typology3_Size,Typology3_Costs,Cost_Consumables_All_Range)","v":{"$error":"#NAME?"}}]
[null,null,null,null,"Other Recurrent",{"$f":"(SUM(F63:F65))","v":18962.25},{"$f":"(SUM(G63:G65))","v":35386.449999999997},{"$f":"(SUM(H63:H65))","v":35386.449999999997}]
[null,null,null,null,"Drugs & Medical Supplies",{"$f":"CostDrugs(Typology1_Size,Typology1_Costs,Cost_Drugs_All_Range)","v":5384},{"$f":"CostDrugs(Typology2_Size,Typology2_Costs,Cost_Drugs_All_Range)","v":10760},{"$f":"CostDrugs(Typology3_Size,Typology3_Costs,Cost_Drugs_All_Range)","v":10760}]
[null,null,null,null,"Referral Systems",{"$f":"CostAnnualReferral(Typology1_Size,Typology1_Costs,Cost_Referral_Annual_All_Range)","v":7112},{"$f":"CostAnnualReferral(Typology2_Size,Typology2_Costs,Cost_Referral_Annual_All_Range)","v":13168.8},{"$f":"CostAnnualReferral(Typology3_Size,Typology3_Costs,Cost_Referral_Annual_All_Range)","v":13168.8}]
[null,null,null,null,"Other Model of Care Components (5)",{"$f":"CostQoC(Typology1_Size,Typology1_Costs,Cost_QoC_All_Range)+ CostInfrMaintenance(Typology1_Size,Typology1_Costs,Cost_InfrMaintenance_All_Range)","v":6466.25},{"$f":"CostQoC(Typology2_Size,Typology2_Costs,Cost_QoC_All_Range)+ CostInfrMaintenance(Typology2_Size,Typology2_Costs,Cost_InfrMaintenance_All_Range)","v":11457.65},{"$f":"CostQoC(Typology3_Size,Typology3_Costs,Cost_QoC_All_Range)+CostInfrMaintenance(Typology3_Size,Typology3_Costs,Cost_InfrMaintenance_All_Range)","v":11457.65}]
[null,null,null,null,{"$f":"_xlfn.CONCAT(E45, \" ANALYSIS\")","v":"FACILITY CAPITAL COSTS ANALYSIS"}]
[null,null,null,null,"Capital Cost per Bed",{"$f":"IF(F45=0,0,F45/F43)","v":{"$error":"#NAME?"}},{"$f":"IF(G45=0,0,G45/G43)","v":{"$error":"#NAME?"}},{"$f":"IF(H45=0,0,H45/H43)","v":{"$error":"#NAME?"}}]
[null,null,null,null,"% Share",{"$f":"SUM(F69:F71)","v":{"$error":"#NAME?"}},{"$f":"SUM(G69:G71)","v":{"$error":"#NAME?"}},{"$error":"#NAME?"}]
[null,null,null,null,{"$f":"E46","v":"Infrastructure "},{"$f":"IF(F46=0,0,F46/F45)","v":{"$error":"#NAME?"}},{"$f":"IF(G46=0,0,G46/G45)","v":{"$error":"#NAME?"}},{"$f":"IF(H46=0,0,H46/H45)","v":{"$error":"#NAME?"}}]
[null,null,null,null,{"$f":"E47","v":"Equipment"},{"$f":"IF(F47=0,0,F47/F45)","v":{"$error":"#NAME?"}},{"$f":"IF(G47=0,0,G47/G45)","v":{"$error":"#NAME?"}},{"$f":"IF(H47=0,0,H47/H45)","v":{"$error":"#NAME?"}}]
[null,null,null,null,{"$f":"E52","v":"Other Capital"},{"$f":"IF(F52=0,0,F52/F45)","v":{"$error":"#NAME?"}},{"$f":"IF(G52=0,0,G52/G45)","v":{"$error":"#NAME?"}},{"$f":"IF(H52=0,0,H52/H45)","v":{"$error":"#NAME?"}}]
[null,null,null,null,{"$f":"_xlfn.CONCAT(E55, \" ANALYSIS\")","v":"FACILITY RECURRENT COSTS ANALYSIS"}]
[null,null,null,null,"Annual Cost per Bed",{"$f":"IF(F55=0,0,F55/F43)","v":{"$error":"#NAME?"}},{"$f":"IF(G55=0,0,G55/G43)","v":{"$error":"#NAME?"}},{"$f":"IF(H55=0,0,H55/H43)","v":{"$error":"#NAME?"}}]
[null,null,null,null,"Annual Cost per Newborn Admission",{"$f":"IF(F55=0,0,F55/F42)","v":{"$error":"#NAME?"}},{"$f":"IF(G55=0,0,G55/G42)","v":{"$error":"#NAME?"}},{"$f":"IF(H55=0,0,H55/H42)","v":{"$error":"#NAME?"}}]
[null,null,null,null,{"$f":"E68","v":"% Share"},{"$f":"SUM(F76:F78)","v":{"$error":"#NAME?"}},{"$f":"SUM(G76:G78)","v":{"$error":"#NAME?"}},{"$f":"SUM(H76:H78)","v":{"$error":"#NAME?"}}]
[null,null,null,null,{"$f":"E56","v":"Human Resources"},{"$f":"IF(F56=0,0,F56/F55)","v":{"$error":"#NAME?"}},{"$f":"IF(G56=0,0,G56/G55)","v":{"$error":"#NAME?"}},{"$f":"IF(H56=0,0,H56/H55)","v":{"$error":"#NAME?"}}]
[null,null,null,null,{"$f":"E59","v":"Equipment"},{"$f":"IF(F59=0,0,F59/F55)","v":{"$error":"#NAME?"}},{"$f":"IF(G59=0,0,G59/G55)","v":{"$error":"#NAME?"}},{"$error":"#NAME?"}]
[null,null,null,null,{"$f":"E62","v":"Other Recurrent"},{"$f":"IF(F62=0,0,F62/F55)","v":{"$error":"#NAME?"}},{"$f":"IF(G62=0,0,G62/G55)","v":{"$error":"#NAME?"}},{"$error":"#NAME?"}]
[null,null,null,null,"Notes:"]
[null,null,null,null,"(1) Table does not include costs of national & regional strategies"]
[null,null,null,null,"(2) Other include capital costs (i.e. housing) to recruit and retain staff in hard-to-recruit and most-challenging recruitment typologies"]
[null,null,null,null,"(3)  Development & Incentives includes human development strategies such as supervision/coaching & mandatory in-service training and additional recruitment incentives not costed as part of staff salaries and allowances"]
[null,null,null,null,"(4) Equipment regular maintenance includes spare parts and maintenance strategies, except buffer stocks"]
[null,null,null,null,"(5) Recurrent costs for infrastructure maintenance and model of care components other than human resources, equipment & commodities and referrals)"]
[]
[null,null,null,null,"IMPORTANT:  Do not cut charts. Always use copy & paste"]
[null,null,null,null,null,{"$f":"E40","v":"All financial figures are in USD - Base Year (2024)"}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"What are the capital and annual recurrent costs involved?"]
[null,null,null,null,"How do costs vary by typology"]
[null,null,null,null,"What about costs per bed?"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"What accounts for the largest share of capital costs?"]
[null,null,null,null,"How does the distribution vary by typology?"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"What accounts for the largest share of annual costs?"]
[null,null,null,null,"How does the distribution vary by typology?"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"How do annual recurrent costs per newborn  vary by typology?"]

{"sheet":"10.Financing_ScaleUp_Scenario","index":10,"n_rows":156,"n_cols":8,"rows_kept":156,"cut":false,"hidden":false,"merged":[[2,1,2,7],[145,1,146,2],[57,2,57,6],[51,1,51,2],[38,1,38,5],[91,1,91,2],[92,1,92,2],[133,1,133,7],[112,1,112,2],[113,1,113,2]]}
[]
[null,"FINANCING (2) - SCALE-UP SCENARIO"]
[null,"WARNING: Do not copy and paste data into this workbook. Doing so may insert conflicting code and remove validation. Please enter data manually to ensure proper functionality"]
[null,"MODULE OVERVIEW"]
[null,"Complements the facility typology analytics module by allowing the user to model the costs of a basic scale-up scenario "]
[null,"It can be used in planning & budgeting discussions to examine the impact of recurrent expenditure vs. capital investments"]
[null,"The analysis can also help users gauge how many facilities can be funded within a limited resource envelope"]
[null,"Note that five-year estimates are shown here and do not include the cost of replacing capital assets after a certain period of time"]
[null,"The module steps include:"]
[null,"Review the characteristics of the 'typical' facilities that will be used for the scale-up scenario calculations"]
[null,"They represent the typologies used in the previous module (9.Financing_Typology_Analytics)"]
[null,"Select the start year of the scale-up scenario "]
[null,"Scale-up scenario projections shown for five years. If the start year is 2025, the end year of the scenario will be 2029"]
[null,"Enter the percentage of recurrent costs to be funded in each scenario year"]
[null,"It is unlikely that facilities will be fully operational the year they are funded, so this percentage adjusts the recurrent expenditure in that year."]
[null,"Enter the number of facilities that will be set up each year"]
[null,"To estimate scale-up costs, enter here the number of each 'typical' facility included in the scale-up"]
[null,"Review & validate the number of facilities and associated scale-up costs"]
[null,"Here the user can examine the impact of recurrent vs. capital costs"]
[null,"Review total scale-up costs (facility & national and regional levels)"]
[null,"Here the user can review all scale-up costs, including those incurred at national & regional levels"]
[null,"Review summary charts"]
[null,"Light blue cells are user inputs."]
[null,"Yellow cells cannot be manually changed by the user"]
[]
[null,"STEP 1. REVIEW THE CHARACTERISTICS OF THE 'TYPICAL FACILITIES' THAT WILL BE USED FOR THE SCALE-UP SCENARIO CALCULATIONS"]
[null,"This table shows the current typologies modelled in Facility Typology Analytics (Module 9)"]
[null,"Costs for these typologies will be used for the scale-up scenario calculations"]
[null,"Make sure they represent the 'typical' facilities to be included in the scale-up"]
[null,"If you want to change any of the typologies, go back to the previous sheet (9.Facility_Typology_Analytics) and make the corresponding changes"]
[]
[null,{"$f":"'9.Financing_Typology_Analytics'!E34","v":"Typical Facility Name/Description:"},{"$f":"'9.Financing_Typology_Analytics'!F41","v":"Small"},{"$f":"'9.Financing_Typology_Analytics'!G41","v":"MediumNew"},{"$f":"'9.Financing_Typology_Analytics'!H41","v":"MediumRehab"}]
[null,{"$f":"'9.Financing_Typology_Analytics'!E25","v":"SIZE"},{"$f":"'9.Financing_Typology_Analytics'!F25","v":"Small"},{"$f":"'9.Financing_Typology_Analytics'!G25","v":"Medium"},{"$f":"'9.Financing_Typology_Analytics'!H25","v":"Medium"}]
[null,{"$f":"'9.Financing_Typology_Analytics'!E26","v":"COST/LOCATION"},{"$f":"'9.Financing_Typology_Analytics'!F26","v":"Mid Cost "},{"$f":"'9.Financing_Typology_Analytics'!G26","v":"Mid Cost "},{"$f":"'9.Financing_Typology_Analytics'!H26","v":"Mid Cost "}]
[null,{"$f":"'9.Financing_Typology_Analytics'!E27","v":"CONSTRUCTION TYPE"},{"$f":"'9.Financing_Typology_Analytics'!F27","v":"New Construction"},{"$f":"'9.Financing_Typology_Analytics'!G27","v":"New Construction"},{"$f":"'9.Financing_Typology_Analytics'!H27","v":"Rehabilitation"}]
[null,{"$f":"'9.Financing_Typology_Analytics'!E28","v":"EQUIPMENT NEEDS"},{"$f":"'9.Financing_Typology_Analytics'!F28","v":"Major need"},{"$f":"'9.Financing_Typology_Analytics'!G28","v":"Major need"},{"$f":"'9.Financing_Typology_Analytics'!H28","v":"Partial need"}]
[null,{"$f":"'9.Financing_Typology_Analytics'!E29","v":"RECRUITMENT CHALLENGES"},{"$f":"'9.Financing_Typology_Analytics'!F29","v":"Standard area"},{"$f":"'9.Financing_Typology_Analytics'!G29","v":"Standard area"},{"$f":"'9.Financing_Typology_Analytics'!H29","v":"Standard area"}]
[]
[null,"STEP 2. SELECT THE START YEAR FOR THE SCALE-UP SCENARIO"]
[null,"The start year of the scale-up scenario is the year when the first group of facilities will be financed to commence construction."]
[null,"Select a start year for the scale-up after 2023"]
[null,"Note that scale-up projections are shown for five years, that is if the scale-up scenario starts in 2024, it will show expenditure projections up to 2030"]
[]
["Final year of the scale-up scenario: ","Start year of the scale-up scenario: ",2025]
[{"$f":"User_ScenarioYear_Start+4","v":2029}]
[]
[null,"STEP 3. ENTER THE PERCENTAGE OF RECURRENT COSTS TO BE FUNDED THE YEAR THE FACILITY IS SET UP/FUNDED"]
[null,"The model assumes that all capital costs for a facility are disbursed/funded in the year that facility is set up."]
[null,"However, it is reasonable to assume that in the setup year, while the facility is under construction, recurrent costs such as equipment maintenance expenditure will not be incurred. "]
[null,"The % entered here will account for this reduced expenditure in that first year. Leave blank or enter 0% if you think no recurrent expenditure will be incurred in the set-up year"]
[]
[null,"% facility recurrent costs funded in the set up year:",null,0.1]
[]
[null,"STEP 4. FOR EACH YEAR OF THE SCALE-UP ENTER THE NUMBER OF 'TYPICAL' FACILITIES SET UP "]
[null,"These 'typical' facilities represent the typologies selected by the user in Facility Typology_Cost_Charts"]
[null,"If there are no facilities set up in a particular year, leave blank o enter 0"]
[]
[null,null,"Enter number of new facilities included in the scale-up each year"]
[null,"'Typical' Facilities in Country",{"$f":"IF(User_ScenarioYear_Start=\"\",\"NA\",User_ScenarioYear_Start)","v":2025},{"$f":"IF(C59=\"NA\",\"NA\",IF((User_ScenarioYear_Start+1)<=User_ScenarioYear_End,User_ScenarioYear_Start+1,\"NA\"))","v":2026},{"$f":"IF(C59=\"NA\",\"NA\",IF((User_ScenarioYear_Start+2)<=User_ScenarioYear_End,User_ScenarioYear_Start+2,\"NA\"))","v":2027},{"$f":"IF(C59=\"NA\",\"NA\",IF((User_ScenarioYear_Start+3)<=User_ScenarioYear_End,User_ScenarioYear_Start+3,\"NA\"))","v":2028},{"$f":"IF(C59=\"NA\",\"NA\",IF((User_ScenarioYear_Start+4)<=User_ScenarioYear_End,User_ScenarioYear_Start+4,\"NA\"))","v":2029}," Total"]
[null,{"$f":"'9.Financing_Typology_Analytics'!F41","v":"Small"},5,6,2,null,null,{"$f":"SUM(C60:G60)","v":13}]
[null,{"$f":"'9.Financing_Typology_Analytics'!G41","v":"MediumNew"},5,7,3,null,null,{"$f":"SUM(C61:G61)","v":15}]
[null,{"$f":"'9.Financing_Typology_Analytics'!H41","v":"MediumRehab"},5,7,3,null,null,{"$f":"SUM(C62:G62)","v":15}]
[]
[]
[null,"STEP 5. REVIEW & VALIDATE SCALE-UP SCENARIO COSTS (CAPITAL & RECURRENT) "]
[null,"In this table you can review the total number of new facilities funded each year as well as the associated scale-up costs"]
[null,"This table shows capital expenditure for facilities funded in a year. "]
[null,"Annual recurrent costs are estimated separately for new facilities and for those set up in previous years"]
[null,"Remember that all costs in this table are presented in constant prices. The same base year and currency indicated in inputs. "]
[null,"Scale-up Year",{"$f":"C59","v":2025},{"$f":"D59","v":2026},2027,2028,2029,"Total"]
[null,"New facilities",{"$f":"IF(C59=\"NA\",\"\",C60+C61+C62)","v":15},{"$f":"IF(D59=\"NA\",\"\",D60+D61+D62)","v":20},8,0,0,{"$f":"SUM(C71:G71)","v":43}]
[null,"Annual facility costs",{"$f":"C77+C78","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$f":"SUM(C72:G72)","v":{"$error":"#NAME?"}}]
[]
[null,"Capital (%)",{"$f":"IF(C72=0,0,C77/C72)","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$f":"IF(H72=0,0,H77/H72)","v":{"$error":"#NAME?"}}]
[null,"Recurrent (%)",{"$f":"IF(C72=0,0,C78/C72)","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$f":"IF(H72=0,0,H78/H72)","v":{"$error":"#NAME?"}}]
[]
[null,"Capital Costs ($)",{"$f":"IF(C59=\"NA\",0,(C60*UserTypologyName1_Capital)+(C61*UserTypologyName2_Capital)+(C62*UserTypologyName3_Capital))","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$f":"SUM(C77:G77)","v":{"$error":"#NAME?"}}]
[null,"Recurrent Costs ($)",{"$f":"C79+C80","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$f":"SUM(C78:G78)","v":{"$error":"#NAME?"}}]
[null,"Recurrent new facilities ($)",{"$f":"IF(C59=\"NA\",0,((C60*UserTypologyName1_Recurrent)+(C61*UserTypologyName2_Recurrent)+(C62*UserTypologyName3_Recurrent))*User_PercentRecurrent_SetupYear)","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,"Recurrent facilities set up in previous years",0,{"$f":"IF(D59=\"NA\",0,C80+((C60*UserTypologyName1_Recurrent)+(C61*UserTypologyName2_Recurrent)+(C62*UserTypologyName3_Recurrent)))","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,{"$f":"_xlfn.CONCAT(\"Note: \",'9.Financing_Typology_Analytics'!$E$40)","v":"Note: All financial figures are in USD - Base Year (2024)"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"How many new facilities are funded every year?"]
[null,"What are the expected levels of facility expenditure?"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"_xlfn.CONCAT(\"Note: \",'9.Financing_Typology_Analytics'!$E$40)","v":"Note: All financial figures are in USD - Base Year (2024)"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"What about facility capital vs. recurrent costs?"]
[null,"How does the split change by year?"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"_xlfn.CONCAT(\"Note: \",'9.Financing_Typology_Analytics'!$E$40)","v":"Note: All financial figures are in USD - Base Year (2024)"}]
[]
[]
[null,"STEP 6. REVIEW TOTAL SCALE-UP COSTS BY YEAR (FACILITY, NATIONAL AND REGIONAL LEVELS) "]
[null,"Review total scale-up costs, including national & regional level strategies, by year"]
[]
[null,null,{"$f":"C59","v":2025},2026,2027,2028,2029," Total"]
[null,"Facility Scale-up Costs",{"$f":"C72","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,"National & Regional Costs",{"$f":"IF(C70=\"NA\",0,'8.National_Regional_Plan&Budget'!C147)","v":296370},{"$f":"IF(D70=\"NA\",0,'8.National_Regional_Plan&Budget'!$D$147)","v":136370},{"$f":"IF(E70=\"NA\",0,'8.National_Regional_Plan&Budget'!$D$147)","v":136370},{"$f":"IF(F70=\"NA\",0,'8.National_Regional_Plan&Budget'!$D$147)","v":136370},{"$f":"IF(G70=\"NA\",0,'8.National_Regional_Plan&Budget'!$D$147)","v":136370},{"$f":"SUM(C132:G132)","v":841850}]
[null,"TOTAL SCALE-UP COSTS",{"$f":"C131+C132","v":{"$error":"#NAME?"}},{"$f":"D131+D132","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,{"$f":"_xlfn.CONCAT(\"Note: \",'9.Financing_Typology_Analytics'!$E$40)","v":"Note: All financial figures are in USD - Base Year (2024)"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"How does the expected expenditure at national and regional levels compare with expenditure at facility level?"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"_xlfn.CONCAT(\"Note: \",'9.Financing_Typology_Analytics'!$E$40)","v":"Note: All financial figures are in USD - Base Year (2024)"}]