{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Introduction","Instructions","Control","Model","Flags"],"not_rendered":{"charts":1,"images":30,"macros":1,"external_links":0,"defined_names":13,"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":"Introduction","index":0,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,"Test Laboratory Financial Evaluation Tool"]
[null,"Introduction"]
[null,"Product testing is fundamental to designing and implementing voluntary or mandatory minimum energy performance standards (MEPS) and labeling policies, which require a high level of confidence that products perform as claimed. A common belief is that a country must build their own national testing laboratory for support product verification testing for policy compliance. However, establishment of a testing laboratory requires a large upfront investment. The government should also secure sufficient continuous funding to support its operation and maintenance ensuring its competence and the public's confidence in the test results it provides.\n\nBefore building a testing laboratory, the government should build a business case to provide a justification for establishing the facility. The key element of the business case is economic analysis to evaluate the upfront investment in construction, equipment, accreditation, and human resources, as well as ongoing operating costs including equipment calibration and maintenance, staff training, and re-accreditation. These costs should be compared against expected revenue from commercial testing and other services that the laboratory may provide. Such analysis can provide a clear picture on the annual budget that the government will have to allocate to keep the facility operational and competent. \n\nThe Test Laboratory Financial Evaluation Tool was developed by CLASP to help ECOWAS policymakers evaluate if establishing a national testing laboratory is a financially viable option to support MEPS and labeling policies for appliances and products. The tool allows users to calculate the costs of building and operating a laboratory and forecast its revenue. The default costs are based on data collected through the Super-efficient Equipment and Appliance Deployment (SEAD) Initiative Testing Costs Study. Users can also choose to enter their own cost data. The Tool displays the costs and revenues in U.S. dollars or the local currencies of ECOWAS Member States. \n\nIf building a national testing facility is not a financially viable option, alternative approaches for verification testing should be considered such as accepting testing results from foreign or independent private laboratories. Additionally, utilizing available regional resources such as regional product registration system (PRS) can help meet policy compliance objectives, especially if the policy enforcement efforts are resource-constrained. Refer to Guide for Building Sustainable Testing Capacity in ECOWAS Region for more information on the alternative approaches for verification testing."]

{"sheet":"Instructions","index":1,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[12,1,12,2],[5,1,5,2],[8,1,8,2]]}
[null,null,"Test Laboratory Financial Evaluation Tool"]
[null,"General Information"]
[null,"\nThe Control sheet allows users to input data and see the results: \n          · Orange and green cells contain default values that the user can a) keep, b) modify using the slider to increase or decrease value, b) enter their own value (0 is a valid entry). The pre-populated values are estimated based on the \n            Super-efficient Equipment and Appliance Deployment (SEAD) Global Appliance Testing Costs Catalogue: https://clasp.ngo/publications/sead-global-appliance-testing-costs-catalogue.\n          · White and Blue cells contain results that are calculated based on the values in the orange and green cells.\n\nModel sheet contains the formula and calculations (locked), which can be referenced. "]
[null,"Step-by-step Guide on How to Use the Tool"]
[null,"In the Control sheet:\n1. Choose country and currency from a drop-down list. The list includes currencies for 15 ECOWAS Member States and U.S. Dollars.\n2. Choose the product from a drop-down list, for which the laboratory is being considered (available products: air conditioner, refrigerator, TV, motor and lighting products).\n        · Note: re-select currency/country or product to reset the tool.\n         · Note: The tool uses macros (additional instructions embedded in the spreadsheet). Click the Enable Macros button at the top of the screen or if prompted."]
[null,"3. In the INPUTS-COSTS box, enter cost data.\n         · Choose Exclude from Analysis if government funding is not used to finance laboratory establishment and repayment is not required (e.g., external grant). This can also be selected for equipment, when the existing equipment is being reused. \n         · Explanation of terms associated with different cost groups:"]
[null,null,"Capital and Set-up Costs:\n- Product-specific equipment includes specialty equipment that is required test a particular product that must be purchased.  \n- Generic equipment includes general equipment (e.g., voltage stabilizer, thermometer, hygrometer, sampler, etc.). If the existing testing facility already owns such equipment, its costs should be excluded or reduced.\n- Accreditation - estimated costs to obtain accreditation to ISO 17025 General requirements for the competence of testing and calibration laboratories, which is the main ISO standard used by testing laboratories. If the laboratory is expected to obtain accreditation to additional standards, these additional costs can be added here (manual cost modification) or under \"Other costs\" group.\n- Inter-laboratory trials - cost of conducting inter-laboratory trials such as participating in round robin testing exercises to build technical capacity for establishing repeatable and reproducible testing results.\n- Staff training refers to the initial training conducted for the laboratory technicians to competently operate the laboratory and perform product testing as per international and national standards.\n- Other costs can include the other potential costs that are not included in the above-listed categories such as import tariffs or local taxes, specialized equipment installation (which can vary significantly), building construction costs, and others."]
[null,null,"Annual Operating and Maintenance Costs:\n- Staffing refers to a minimum number of trained technicians. This category does not include the staff hired for laboratory administration and management. However, their salaries can be added under \"Additional annual costs\" category or manually added here. \n- Staff salary is the estimated annual salary per technician. If there are different levels of salaries then their average can be entered here.\n- Space refers to the minimum space required for the laboratory. It is assumed that there is an existing, suitable building for the laboratory with a reliable electricity supply. \n- Rent for laboratory space refers to annual rent rate to rent the laboratory space (per 10 m2). \n- Equipment calibration and maintenance refers to the costs for equipment calibration and maintenance to ensure that the equipment is functional. Default value is an annualized estimate. Shipping costs to calibrate equipment are not included and can be added manually here or to the 'Additional operating costs\" category, if known. \n- Additional operating costs include capacity building, staff training, re-accreditation, re-certification. Default value is an annualized estimate. If there are anticipated other types of costs these can be manually entered to this category.\n - Discount rate refers to the percentage by which costs and revenues are decreased with each passing year, reflecting the time value of money (used to calculate break-even financial viability of lab in Results Summary)."]
[null," 4. In the INPUTS - ANNUAL REVENUE box, enter anticipated revenue information: \n          · The tool is pre-populated with estimated number of tests expected under compliance program, which the user can keep, or a) use the slider to increase or decrease value, b) manually enter value in the green cell.\n          · Choose Exclude from Analysis if the laboratory will not receive payment for testing products to verify compliance (e.g. from the energy efficiency compliance programme budget).  "]
[null,null,"Verification Testing for Compliance: \n- Number of Verification tests per year- the cell is pre-populated with estimated 50 tests per year. The user can adjust the number if the anticipated number of tests for compliance verification is different and known. \n- Price per verification test - this cell is pre-populated with the default testing price value, which the user can adjust using slider or manually, if needed.\n- Annual verification testing revenue is calculated using the above entries (number of tests and price).\n- If the laboratory will not receive revenue for conducting compliance verification testing for energy efficiency programme, then the user should check No revenue will be received from Verification testing for compliance (e.g. from government/energy efficiency programme budget, nor other entity)? box to exclude it from analysis as verification testing will not be a source of revenue."]
[null,null," Commercial Testing includes the revenue collected from testing services provided to third-parties including manufacturers, importers, other governments, and other stakeholders. This category is optional.\n- Number of Commercial tests per year  - the cell is pre-populated automatically showing how many commercial tests the laboratory should conduct to break even (cover all associated capital/set-up and operation & maintenance costs with revenue). If the user knows the anticipated number of commercial tests that laboratory is expected to conduct, they can manually change the number. If no commercial testing is expected, then the entry should be 0.\n- Price Charged Per Commercial Test - this cell is pre-populated with the default value, which the user can adjust manually, if needed. The user can compare this number to the commercial testing fees in other laboratories in the country of interest or other countries.\n- Annual Commercial Test Revenue is calculated using the above entries (number of tests and price)."]
[null,null,"Other Annual Revenue is set to zero, but can be manually changed to add additional anticipated revenue such as ongoing government funding. "]
[null,"5. RESULTS SUMMARY:\n        · First, the results section provides the summary of capital/set-up and operational & maintenance costs, as well as revenue that the laboratory is expected to generate from providing its services.\n        · The model is built to assess the laboratory performance over 10 years of operation.  \n        · Next, the results evaluate the sustainability of the investment in the laboratory based on estimated costs and revenues. Interpreting the results:\n                    - Whether the Revenues cover Costs over 10 Years (with discounting) can be 'Break even' or \"Yes\" if the total revenue will match or exceed the total costs, or \"No\" which means that the laboratory will be operating at a loss.\n                    - Part of Costs Covered by Testing Services and Other Revenue (%) show how much of the total costs the anticipated revenue will cover, and Part of Costs that Require Additional Funding (%) show what part of costs will require additional funding.  \n        · 10-Year Net Present Value of Lab show the net present value of the laboratory calculated as a difference between the present value of revenue and the present value of costs over a 10-year period. \n        · Simple payback period (years) shows after how many years the capital and set-up costs would be repaid.  It is calculated by dividing the capital and set-up costs by the total cash flow. If the cash flow is negative then the resulting payback is \"infinity\", meaning that the costs will not be repaid for a very long time, if ever.\n        · Cash Flows graph show the cost and revenue flow over 10-year period and the cumulative costs and revenues (discounted). \n"]

{"sheet":"Control","index":2,"n_rows":174,"n_cols":29,"rows_kept":174,"cut":false,"hidden":false,"merged":[[42,4,42,5],[44,4,44,5]]}
[null,null,null,"Test Laboratory Financial Evaluation Tool",null,null,null,null,null,null,null,null,null,"Reference Data - Do not move/change cells as tool will not work",null,null,null,null,null,null,null,null,null,null,null,"https://www.xe.com/currencytables/?from=USD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Products",null,null,null,null,null,null,"Country","Currency Code","Currency Used",null,null,"XE Currency Table: USD - US Dollar"]
[null,"Country and Currency:",null,null,"(select)",null,null,null,null,null,null,null,null,"Air Conditioners",null,null,null,null,null,null,"-- (USD)","USD",null,null,null,"2021-01-08 19:54 UTC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"General Service Lighting",null,null,null,null,null,null," Benin (XOF)","XOF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Motors",null,null,null,null,null,null," Burkina Faso (XOF)","XOF",null,null,null,"All figures are live mid-market rates, which are not available to consumers and are for informational purposes only. To see the rates we quote for money transfer, please use our money transfer service."]
[null,"Product to Be Tested:",null,null," (select)",null,null,null,null,null,null,null,null,"Refrigerators",null,null,null,null,null,null," Cape Verde (CVE)","CVE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Televisions",null,null,null,null,null,null," Gambia (GMD)","GMD",null,null,null,"Currency code ??","Currency name ??","Units per USD","USD per Unit"]
[null,null,null,"(change country or product to reset the tool)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Ghana (GHS)","GHS",null,null,null,"USD","US Dollar",1,1]
[null,null,null,20,null,null,null,null,null,null,null,null,null,"Selected Product:",{"$f":"INDEX(ProductsList,P9)","v":"Air Conditioners"},1,1,null,null,null," Guinea (GNF)","GNF",null,null,null,"EUR","Euro",0.81858082570000001,1.2216264644999999]
[null,"INPUTS - COSTS",null,null,null,null,null,"RESULTS SUMMARY",null,null,null,null,null,"If a single range, multiply by these factors to create a range:",null,0.5,1.5,null,null,null," Guinea-Bissau (XOF)","XOF",null,null,null,"GBP","British Pound",0.73712086210000005,1.3566296267]
[null,"Capital and Set-up Costs",null,null,null,null,null,null,null,null,null,null,null,"Input","Unit","Low Estimate","High Estimate","Description",null,null," Ivory Coast (XOF)","XOF",null,null,null,"INR","Indian Rupee",73.376748573300006,1.3628295299999999E-2]
[null,null,null,null,null,"Exclude from Analysis?",null,"Costs",null,null,null,null,null,"Capital Costs",null,null,null,null,null,null," Liberia (LRD)","LRD",null,null,null,"AUD","Australian Dollar",1.2904542468,0.77492092609999996]
[null,null,null,null,null,"(external grant, existing equipment)",null,{"$f":"\"Total Capital Costs (000 \"&SelectedCurrency&\")\"","v":"Total Capital Costs (000 USD)"},null,{"$f":"SUM(Model!C5:C10)","v":515},null,null,null,"Product-specific equipment",{"$f":"\"000 \"& SelectedCurrency","v":"000 USD"},{"$f":"INDEX(P$41:P$123,MATCH($N13,$N$41:$N$51,0)+MATCH(SelectedProduct,$N$38:$N$110,0)-1)\n*IF(INDEX($P$41:$P$123,MATCH($N13,$N$41:$N$51,0)+MATCH(SelectedProduct,$N$38:$N$110,0)-1)=INDEX($Q$41:$Q$123,MATCH($N13,$N$41:$N$51,0)+MATCH(SelectedProduct,$N$38:$N$110,0)-1),P$10,1)\n*IF($O13=\"000 \"& SelectedCurrency,INDEX($AB$8:$AB$174,MATCH(SelectedCurrency,$Z$8:$Z$174,0)),1)","v":350},650,{"$f":"INDEX(R$41:R$123,MATCH($N13,$N$41:$N$51,0)+MATCH(SelectedProduct,$N$38:$N$110,0)-1)","v":"Room calorimeter, control air space chamber, compressor condensing units, air handling unit, humidifiers, pressure equivalence devices, water calibration system, air sampler and psychrometer box (complete setup required commissioning)"},null,null," Mali (XOF)","XOF",null,null,null,"CAD","Canadian Dollar",1.2712522868,0.7866259203]
[null,{"$f":"\"Product-specific equipment (000 \"&SelectedCurrency&\")\"","v":"Product-specific equipment (000 USD)"},null,null,500,null,null,{"$f":"\"Total Annual Operational and Maintenance Costs (000 \"&SelectedCurrency&\")\"","v":"Total Annual Operational and Maintenance Costs (000 USD)"},null,{"$f":"-SUM(Model!E11:E14)","v":86},null,null,null,"Generic equipment (usually pre-owned)","000 USD",3,5,"Voltage stabilizer, thermometer, hygrometer, sampler, etc.",null,null," Niger (XOF)","XOF",null,null,null,"SGD","Singapore Dollar",1.3263161438,0.75396805249999999]
[null,{"$f":"\"Generic equipment  (000 \"&SelectedCurrency&\")\"","v":"Generic equipment  (000 USD)"},null,null,4,null,null,null,null,null,null,null,null,"Accreditation","000 USD",2.5,7.5,"To ISO 17025",null,null," Nigeria (NGN)","NGN",null,null,null,"CHF","Swiss Franc",0.88640914439999996,1.1281472064]
[null,{"$f":"\"Accreditation  (000 \"&SelectedCurrency&\")\"","v":"Accreditation  (000 USD)"},null,null,5,null,null,null,null,null,null,null,null,"Inter-laboratory trials","000 USD",2.5,7.5,"For calibrating proficiency",null,null," Senegal (XOF)","XOF",null,null,null,"MYR","Malaysian Ringgit",4.0324732505999998,0.24798676589999999]
[null,{"$f":"\"Inter-laboratory testing  (000 \"&SelectedCurrency&\")\"","v":"Inter-laboratory testing  (000 USD)"},null,null,5,null,null,"Revenues",null,null,null,null,null,"Staff training","000 USD",0,20,"Assumption---to be verified",null,null," Sierra Leone (SLL)","SLL",null,null,null,"JPY","Japanese Yen",103.9411215114,9.6208313000000004E-3]
[null,{"$f":"\"Staff training  (000 \"&SelectedCurrency&\")\"","v":"Staff training  (000 USD)"},null,null,1,null,null,{"$f":"\"Annual Verification Testing Revenue (000 \"&SelectedCurrency&\")\"","v":"Annual Verification Testing Revenue (000 USD)"},null,{"$f":"Model!E22","v":60},null,null,null,"Other costs","000 USD",0,50,"Assumption---to be verified",null,null," Togo (XOF)","XOF",null,null,null,"CNY","Chinese Yuan Renminbi",6.4736964284000003,0.15447125319999999]
[null,{"$f":"\"Other costs  (000 \"&SelectedCurrency&\")\"","v":"Other costs  (000 USD)"},null,null,0,null,null,{"$f":"\"Annual Commercial Testing Revenue (000 \"&SelectedCurrency&\")\"","v":"Annual Commercial Testing Revenue (000 USD)"},null,{"$f":"Model!E32","v":102.75018667899381},null,null,null,"Operational Costs",null,null,null,null,null,null,null,null,null,null,null,"NZD","New Zealand Dollar",1.3838298121999999,0.72263221330000005]
[null,null,null,null,null,null,null,{"$f":"\"Other Annual Revenue (000 \"&SelectedCurrency&\")\"","v":"Other Annual Revenue (000 USD)"},null,{"$f":"Model!E23","v":0},null,null,null,"Staffing","people",{"$f":"INDEX(P$41:P$123,MATCH($N20,$N$41:$N$51,0)+MATCH(SelectedProduct,$N$38:$N$110,0)-1)\n*IF(INDEX($P$41:$P$123,MATCH($N20,$N$41:$N$51,0)+MATCH(SelectedProduct,$N$38:$N$110,0)-1)=INDEX($Q$41:$Q$123,MATCH($N20,$N$41:$N$51,0)+MATCH(SelectedProduct,$N$38:$N$110,0)-1),P$10,1)\n*IF($O20=\"000 \"& SelectedCurrency,INDEX($AB$8:$AB$174,MATCH(SelectedCurrency,$AC$8:$AC$174,0)),1)","v":1},{"$f":"INDEX(Q$41:Q$123,MATCH($N20,$N$41:$N$51,0)+MATCH(SelectedProduct,$N$38:$N$110,0)-1)\n*IF(INDEX($P$41:$P$123,MATCH($N20,$N$41:$N$51,0)+MATCH(SelectedProduct,$N$38:$N$110,0)-1)=INDEX($Q$41:$Q$123,MATCH($N20,$N$41:$N$51,0)+MATCH(SelectedProduct,$N$38:$N$110,0)-1),Q$10,1)\n*IF($O20=\"000 \"& SelectedCurrency,INDEX($AB$8:$AB$174,MATCH(SelectedCurrency,$Z$8:$Z$174,0)),1)","v":3},{"$f":"INDEX(R$41:R$123,MATCH($N20,$N$41:$N$51,0)+MATCH(SelectedProduct,$N$38:$N$110,0)-1)","v":"Minimum number of trained technicians"},null,null,"Selected Country:",{"$f":"INDEX($U$3:$U$18,W20)","v":"-- (USD)"},1,2,null,"THB","Thai Baht",30.1284153388,3.3191257799999999E-2]
[null,null,null,null,null,null,null,{"$f":"\"Total Annual Revenue (000 \"&SelectedCurrency&\")\"","v":"Total Annual Revenue (000 USD)"},null,{"$f":"SUM(J18:J20)","v":162.75018667899383},null,null,null,"Space","m2",{"$f":"INDEX(P$41:P$123,MATCH($N21,$N$41:$N$51,0)+MATCH(SelectedProduct,$N$38:$N$110,0)-1)\n*IF(INDEX($P$41:$P$123,MATCH($N21,$N$41:$N$51,0)+MATCH(SelectedProduct,$N$38:$N$110,0)-1)=INDEX($Q$41:$Q$123,MATCH($N21,$N$41:$N$51,0)+MATCH(SelectedProduct,$N$38:$N$110,0)-1),P$10,1)\n*IF($O21=\"000 \"& SelectedCurrency,INDEX($AB$8:$AB$174,MATCH(SelectedCurrency,$Z$8:$Z$174,0)),1)","v":30},{"$f":"INDEX(Q$41:Q$123,MATCH($N21,$N$41:$N$51,0)+MATCH(SelectedProduct,$N$38:$N$110,0)-1)\n*IF(INDEX($P$41:$P$123,MATCH($N21,$N$41:$N$51,0)+MATCH(SelectedProduct,$N$38:$N$110,0)-1)=INDEX($Q$41:$Q$123,MATCH($N21,$N$41:$N$51,0)+MATCH(SelectedProduct,$N$38:$N$110,0)-1),Q$10,1)\n*IF($O21=\"000 \"& SelectedCurrency,INDEX($AB$8:$AB$174,MATCH(SelectedCurrency,$Z$8:$Z$174,0)),1)","v":90},{"$f":"INDEX(R$41:R$123,MATCH($N21,$N$41:$N$51,0)+MATCH(SelectedProduct,$N$38:$N$110,0)-1)","v":"Minimum space requirements"},null,null,"Selected Currency:",{"$f":"INDEX($V$3:$V$18,W20)","v":"USD"},null,null,null,"HUF","Hungarian Forint",294.37913200029999,3.3969798999999999E-3]
[null,"Annual Operating and Maintenance Costs ",null,null,null,null,null,null,null,null,null,null,null,"Equipment calibration and maintenance",{"$f":"\"000 \"& SelectedCurrency","v":"000 USD"},{"$f":"INDEX(P$41:P$123,MATCH($N22,$N$41:$N$51,0)+MATCH(SelectedProduct,$N$38:$N$110,0)-1)\n*IF(INDEX($P$41:$P$123,MATCH($N22,$N$41:$N$51,0)+MATCH(SelectedProduct,$N$38:$N$110,0)-1)=INDEX($Q$41:$Q$123,MATCH($N22,$N$41:$N$51,0)+MATCH(SelectedProduct,$N$38:$N$110,0)-1),P$10,1)\n*IF($O22=\"000 \"& SelectedCurrency,INDEX($AB$8:$AB$174,MATCH(SelectedCurrency,$Z$8:$Z$174,0)),1)","v":5},{"$f":"INDEX(Q$41:Q$123,MATCH($N22,$N$41:$N$51,0)+MATCH(SelectedProduct,$N$38:$N$110,0)-1)\n*IF(INDEX($P$41:$P$123,MATCH($N22,$N$41:$N$51,0)+MATCH(SelectedProduct,$N$38:$N$110,0)-1)=INDEX($Q$41:$Q$123,MATCH($N22,$N$41:$N$51,0)+MATCH(SelectedProduct,$N$38:$N$110,0)-1),Q$10,1)\n*IF($O22=\"000 \"& SelectedCurrency,INDEX($AB$8:$AB$174,MATCH(SelectedCurrency,$Z$8:$Z$174,0)),1)","v":15},{"$f":"INDEX(R$41:R$123,MATCH($N22,$N$41:$N$51,0)+MATCH(SelectedProduct,$N$38:$N$110,0)-1)","v":"Estimated annual cost"},null,null,"For Graphing",{"$f":"\"000 \"&SelectedCurrency","v":"000 USD"},null,null,null,"AED","Emirati Dirham",3.6724999999999999,0.27229407760000002]
[null,null,null,null,null,"Exclude from Analysis?",null,null,null,null,null,null,null,"Additional operating costs (capacity building, staff training, laboratory re-accreditation, re-certification)",{"$f":"\"000 \"& SelectedCurrency","v":"000 USD"},{"$f":"INDEX(P$41:P$123,MATCH($N23,$N$41:$N$51,0)+MATCH(SelectedProduct,$N$38:$N$110,0)-1)\n*IF(INDEX($P$41:$P$123,MATCH($N23,$N$41:$N$51,0)+MATCH(SelectedProduct,$N$38:$N$110,0)-1)=INDEX($Q$41:$Q$123,MATCH($N23,$N$41:$N$51,0)+MATCH(SelectedProduct,$N$38:$N$110,0)-1),P$10,1)\n*IF($O23=\"000 \"& SelectedCurrency,INDEX($AB$8:$AB$174,MATCH(SelectedCurrency,$Z$8:$Z$174,0)),1)","v":1},{"$f":"INDEX(Q$41:Q$123,MATCH($N23,$N$41:$N$51,0)+MATCH(SelectedProduct,$N$38:$N$110,0)-1)\n*IF(INDEX($P$41:$P$123,MATCH($N23,$N$41:$N$51,0)+MATCH(SelectedProduct,$N$38:$N$110,0)-1)=INDEX($Q$41:$Q$123,MATCH($N23,$N$41:$N$51,0)+MATCH(SelectedProduct,$N$38:$N$110,0)-1),Q$10,1)\n*IF($O23=\"000 \"& SelectedCurrency,INDEX($AB$8:$AB$174,MATCH(SelectedCurrency,$Z$8:$Z$174,0)),1)","v":3},{"$f":"INDEX(R$41:R$123,MATCH($N23,$N$41:$N$51,0)+MATCH(SelectedProduct,$N$38:$N$110,0)-1)","v":"Estimated annual cost"},null,null,null,null,null,null,null,"HKD","Hong Kong Dollar",7.7557086056999998,0.12893728360000001]
[null,null,null,null,null,"(external grant)",null,null,null,null,null,null,null,"Yearly staff salary",{"$f":"\"000 \"& SelectedCurrency","v":"000 USD"},{"$f":"P34\n*IF($P34=$Q34,P$10,1)\n*IF($O24=\"000 \"& SelectedCurrency,INDEX($AB$8:$AB$174,MATCH(SelectedCurrency,$Z$8:$Z$174,0)),1)","v":0},50,{"$f":"R34","v":"Assumption---to be verified"},null,null,null,null,null,null,null,"MXN","Mexican Peso",20.050769764599998,4.9873397E-2]
[null,"Staffing (number of people)",null,null,2,null,null,"Will Revenues cover Costs over 10 Years (with discounting)?",null,{"$f":"IF(ISNUMBER(J30),IF(J30>0,\"Yes\",IF(J30<0,\"No\",\"Break Even\")),\"Not applicable\")","v":"Break Even"},null,null,null,"Yearly rent (/10m2)",{"$f":"\"000 \"& SelectedCurrency","v":"000 USD"},0,6.67,{"$f":"R35","v":"Assumption---to be verified (in units of /10m2 to avoid rounding issues)"},null,null,null,null,null,null,null,"ZAR","South African Rand",15.332717629399999,6.5220010199999998E-2]
[null,{"$f":"\"Staff salary (000 \"&SelectedCurrency&\"/person)\"","v":"Staff salary (000 USD/person)"},null,null,25,null,null,null,null,null,null,null,null,"Discount rate","%",3,16,{"$f":"R36","v":"Assumption---to be verified"},null,null,null,null,null,null,null,"PHP","Philippine Peso",48.091434860500001,2.07937235E-2]
[null,"Laboratory space (m2)",null,null,60,null,null,{"$f":"\"Part of Costs Covered by Testing Services and Other Revenue (%)\"","v":"Part of Costs Covered by Testing Services and Other Revenue (%)"},null,{"$f":"IF((ABS(Model!C36/Model!C18))<=1, (ABS(Model!C36/Model!C18)), \"100%\")","v":0.99999999999999978},null,null,null,"Test Revenue",null,null,null,null,null,null,null,null,null,null,null,"SEK","Swedish Krona",8.2331573283000008,0.12146008630000001]
[null,{"$f":"\"Rent for laboratory space (000 \"&SelectedCurrency&\"/10m2)\"","v":"Rent for laboratory space (000 USD/10m2)"},null,null,4,null,null,{"$f":"\"Part of Costs that Require Additional Funding (%)\"","v":"Part of Costs that Require Additional Funding (%)"},null,{"$f":"IF(1-J27>=0,1-J27,\"0%\")","v":2.2204460492503131E-16},null,null,null,"Default Test Price",{"$f":"\"000 \"& SelectedCurrency","v":"000 USD"},{"$f":"INDEX(P$41:P$127,MATCH($N28,$N$41:$N$53,0)+MATCH(SelectedProduct,$N$38:$N$110,0)-1)\n\n*IF($O28=\"000 \"& SelectedCurrency,INDEX($AB$8:$AB$174,MATCH(SelectedCurrency,$Z$8:$Z$174,0)),1)","v":1.2},{"$f":"INDEX(Q$41:Q$127,MATCH($N28,$N$41:$N$53,0)+MATCH(SelectedProduct,$N$38:$N$110,0)-1)\n\n*IF($O28=\"000 \"& SelectedCurrency,INDEX($AB$8:$AB$174,MATCH(SelectedCurrency,$Z$8:$Z$174,0)),1)","v":1.2},{"$f":"INDEX(R$41:R$127,MATCH($N28,$N$41:$N$53,0)+MATCH(SelectedProduct,$N$38:$N$110,0)-1)","v":"Assumption—based on costs above"},null,null,null,null,null,null,null,"IDR","Indonesian Rupiah",14054.5087201153,7.1151500000000005E-5]
[null,null,null," ",null,null,null,null,null,null,null,null,null,"Number of Verification Tests","units",{"$f":"INDEX(P$41:P$127,MATCH($N29,$N$41:$N$54,0)+MATCH(SelectedProduct,$N$38:$N$110,0)-1)\n\n*IF($O29=\"000 \"& SelectedCurrency,INDEX($AB$8:$AB$174,MATCH(SelectedCurrency,$Z$8:$Z$174,0)),1)","v":50},{"$f":"INDEX(Q$41:Q$127,MATCH($N29,$N$41:$N$54,0)+MATCH(SelectedProduct,$N$38:$N$110,0)-1)\n\n*IF($O29=\"000 \"& SelectedCurrency,INDEX($AB$8:$AB$174,MATCH(SelectedCurrency,$Z$8:$Z$174,0)),1)","v":50},{"$f":"INDEX(R$41:R$127,MATCH($N29,$N$41:$N$54,0)+MATCH(SelectedProduct,$N$38:$N$110,0)-1)","v":"Assumption---to be verified"},null,null,null,null,null,null,null,"SAR","Saudi Arabian Riyal",3.75,0.2666666667]
[null,null,null,null,null,null,null,{"$f":"\"10-year Net Present Value of Lab (000 \"&SelectedCurrency&\")\"","v":"10-year Net Present Value of Lab (000 USD)"},null,{"$f":"IFERROR(ROUND(Model!$C$40,4),\"Not applicable\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BRL","Brazilian Real",5.4097357587000001,0.1848519123]
[null,{"$f":"\"Equipment calibration and maintenance (000 \"&SelectedCurrency&\")\"","v":"Equipment calibration and maintenance (000 USD)"},null,null,10,null,null,"Simple payback period (years)",null,{"$f":"IF(SUM(Model!C5:C10)/Model!E37>0,SUM(Model!C5:C10)/Model!E37,\"Infinity\")","v":6.7100813989414458},null,null,null,"Other Inputs",null,null,null,null,null,null,null,null,null,null,null,"TRY","Turkish Lira",7.3861088510000004,0.13538928550000001]
[null,{"$f":"\"Additional annual costs (000 \"&SelectedCurrency&\")\"","v":"Additional annual costs (000 USD)"},null,null,2,null,null,null,null,null,null,null,null,"Input","Unit","Low Estimate","High Estimate","Description",null,null,null,null,null,null,null,"KES","Kenyan Shilling",109.5922342641,9.1247341000000003E-3]
[null,"(capacity building, staff training, re-accreditation, re-certification)",null,null,null,null,null,null,null,null,null,null,null,"Operational Costs",null,null,null,null,null,null,null,null,null,null,null,"KRW","South Korean Won",1093.5017421995001,9.1449330000000005E-4]
[null,"Discount Rate (%)",null,null,8,null,null,null,null,null,null,null,null,"Yearly staff salary","000 $",0,50,"Assumption---to be verified",null,null,null,null,null,null,null,"EGP","Egyptian Pound",15.7000122639,6.3694217799999994E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly rent (/10m2)","000 $",0,6.67,"Assumption---to be verified (in units of /10m2 to avoid rounding issues)",null,null,null,null,null,null,null,"IQD","Iraqi Dinar",1461.13770378,6.8439819999999998E-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Discount rate","%",3,16,"Assumption---to be verified",null,null,null,null,null,null,null,"NOK","Norwegian Krone",8.4436442988000007,0.1184322746]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KWD","Kuwaiti Dinar",0.30360936329999999,3.2937060606999999]
[null,"INPUTS - ANNUAL REVENUE ",null,null,null,null,null,null,null,null,null,null,null,"Air Conditioners",null,null,null,null,null,null,null,null,null,null,null,"RUB","Russian Ruble",74.251545640800003,1.34677331E-2]
[null,"Verification Testing for Compliance",null,null,null,null,null,null,null,null,null,null,null,"Input","Unit","Low Estimate","High Estimate","Description",null,null,null,null,null,null,null,"DKK","Danish Krone",6.0881836797000002,0.16425260019999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Capital Costs",null,null,null,null,null,null,null,null,null,null,null,"PKR","Pakistani Rupee",160.38068695780001,6.2351647000000003E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Product-specific equipment","000 $",350,650,"Room calorimeter, control air space chamber, compressor condensing units, air handling unit, humidifiers, pressure equivalence devices, water calibration system, air sampler and psychrometer box (complete setup required commissioning)",null,null,null,null,null,null,null,"ILS","Israeli Shekel",3.1856857714000002,0.31390415490000001]
[null,"Number of Verification Tests Per Year:",null,50,null,null,null,null,null,null,null,null,null,"Generic equipment (usually pre-owned)","000 $",3,5,"Voltage stabilizer, thermometer, hygrometer, sampler, etc.",null,null,null,null,null,null,null,"PLN","Polish Zloty",3.6927554818999999,0.27080049160000003]
[null,{"$f":"\"Price per Verification Test (000 \"&SelectedCurrency&\"):\"","v":"Price per Verification Test (000 USD):"},null,1.2,null,null,null,null,null,null,null,null,null,"Accreditation","000 $",5,{"$f":"P43","v":5},"To ISO 17025",null,null,null,null,null,null,null,"QAR","Qatari Riyal",3.64,0.27472527470000002]
[null,{"$f":"\"Annual Verification Testing revenue  (000 \"&SelectedCurrency&\"):\"","v":"Annual Verification Testing revenue  (000 USD):"},null,{"$f":"D42*D43","v":60},null,null,null,null,null,null,null,null,null,"Inter-laboratory trials","000 $",5,{"$f":"P44","v":5},"For calibrating proficiency",null,null,null,null,null,null,null,"XAU","Gold Ounce",5.418218E-4,1845.6252590796]
[null,"No revenue will be received from Verification testing for compliance (e.g. from government/energy efficiency programme budget, nor other entity)?",null,null,"(exclude from analysis if checked as not a source of revenue)",null,null,null,null,null,null,null,null,"Staff training","000 $",0,20,"Assumption---to be verified",null,null,null,null,null,null,null,"OMR","Omani Rial",0.38450000000000001,2.6007802341000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Other costs","000 $",0,50,"Assumption---to be verified",null,null,null,null,null,null,null,"COP","Colombian Peso",3468.9548087745002,2.8827129999999999E-4]
[null,"Commercial Testing",null,null,null,null,null,null,null,null,null,null,null,"Operational Costs",null,null,null,null,null,null,null,null,null,null,null,"CLP","Chilean Peso",710.87697444579999,1.4067132E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Staffing","people",2,{"$f":"P48","v":2},"Minimum number of trained technicians",null,null,null,null,null,null,null,"TWD","Taiwan New Dollar",28.0023032422,3.5711348099999998E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Space","m2",60,{"$f":"P49","v":60},"Minimum space requirements",null,null,null,null,null,null,null,"ARS","Argentine Peso",85.125693800099995,1.17473345E-2]
[null,"Number of Commercial Tests Per Year:",null,{"$f":"IFERROR(Model!C52,\"Not applicable\")","v":85.62515556582818},"(default value is the number needed for lab to break even)",null,null,null,null,null,null,null,null,"Equipment calibration and maintenance","000 $",10,{"$f":"P50","v":10},"Estimated annual cost",null,null,null,null,null,null,null,"CZK","Czech Koruna",21.4177375121,4.6690272499999998E-2]
[null,{"$f":"\"Price Charged per Commercial Test (000 \"&SelectedCurrency&\"):\"","v":"Price Charged per Commercial Test (000 USD):"},null,1.2,null,null,null,null,null,null,null,null,null,"Additional operating costs (capacity building, staff training, laboratory re-accreditation, re-certification)","000 $",2,{"$f":"P51","v":2},"Estimated annual cost",null,null,null,null,null,null,null,"VND","Vietnamese Dong",23091.100891558701,4.3306700000000003E-5]
[null,{"$f":"\"Annual Commercial Test Revenue (000 \"&SelectedCurrency&\"):\"","v":"Annual Commercial Test Revenue (000 USD):"},null,{"$f":"D50*D51","v":102.75018667899381},null,null,null,null,null,null,null,null,null,"Test Revenue",null,null,null,null,null,null,null,null,null,null,null,"MAD","Moroccan Dirham",8.8375851155999996,0.1131530828]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Default Test Price","000 $",1.2,1.2,"Assumption—based on costs above",null,null,null,null,null,null,null,"JOD","Jordanian Dinar",0.70899999999999996,1.4104372355000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of Verification Tests","units",50,50,"Assumption---to be verified",null,null,null,null,null,null,null,"BHD","Bahraini Dinar",0.376,2.6595744681000002]
[null,{"$f":"\"Other Annual Revenue (000 \"&SelectedCurrency&\"):\"","v":"Other Annual Revenue (000 USD):"},null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"XOF","CFA Franc",536.9538226976,1.8623575E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"General Service Lighting",null,null,null,null,null,null,null,null,null,null,null,"LKR","Sri Lankan Rupee",188.00690918160001,5.3189535000000001E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Input","Unit","Low Estimate","High Estimate","Description",null,null,null,null,null,null,null,"UAH","Ukrainian Hryvnia",28.273963010100001,3.5368229100000002E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Capital Costs",null,null,null,null,null,null,null,null,null,null,null,"NGN","Nigerian Naira",382.41648428159999,2.61495E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Product-specific equipment","000 $",60,600,"Integrating sphere, goniophotometer, spectroradiometer, colorimeter, light meter",null,null,null,null,null,null,null,"TND","Tunisian Dinar",2.6847098631000001,0.37247972820000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Generic equipment (usually pre-owned)","000 $",3.7,4.7,"Voltage stabilizer, meters, measurement software, temperature control, AC inverter",null,null,null,null,null,null,null,"UGX","Ugandan Shilling",3694.1151918330002,2.7070080000000002E-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Accreditation","000 $",5,{"$f":"P61","v":5},"To ISO 17025",null,null,null,null,null,null,null,"RON","Romanian Leu",3.9861436287999998,0.25086903360000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Inter-laboratory trials","000 $",5,{"$f":"P62","v":5},"For proficiency",null,null,null,null,null,null,null,"BDT","Bangladeshi Taka",84.8105700805,1.1790983099999999E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Staff training","000 $",0,20,"Assumption",null,null,null,null,null,null,null,"PEN","Peruvian Sol",3.6083775248999999,0.27713286459999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Other costs","000 $",0,50,"Assumption",null,null,null,null,null,null,null,"GEL","Georgian Lari",3.3098041695,0.3021326788]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Operational Costs",null,null,null,null,null,null,null,null,null,null,null,"XAF","Central African CFA Franc BEAC",536.9538226976,1.8623575E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Staffing","people",2,{"$f":"P66","v":2},"Minimum number of trained technicians",null,null,null,null,null,null,null,"FJD","Fijian Dollar",2.0397403334000002,0.49025848220000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Space","m2",25,{"$f":"P67","v":25},"Minimum space requirements",null,null,null,null,null,null,null,"VEF","Venezuelan Bolívar",9.9875000000000007,0.1001251564]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Equipment calibration and maintenance","000 $",5,{"$f":"P68","v":5},"Estimated annual cost",null,null,null,null,null,null,null,"VES","Venezuelan Bolívar",1314885.0800717501,7.6049999999999996E-7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Capacity building, staff training, laboratory re-certification, others","000 $",2,{"$f":"P69","v":2},"Estimated annual cost",null,null,null,null,null,null,null,"BYN","Belarusian Ruble",2.5649487305999998,0.3898713405]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Test Revenue",null,null,null,null,null,null,null,null,null,null,null,"HRK","Croatian Kuna",6.1968517150000002,0.1613722655]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Default Test Price","000 $",0.6,0.6,"Assumption—based on costs above",null,null,null,null,null,null,null,"UZS","Uzbekistani Som",10451.727685739699,9.5678000000000001E-5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of Verification Tests","units",50,50,"Assumption",null,null,null,null,null,null,null,"BGN","Bulgarian Lev",1.6010049364000001,0.62460769309999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DZD","Algerian Dinar",132.25463495810001,7.5611717E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Motors",null,null,null,null,null,null,null,null,null,null,null,"IRR","Iranian Rial",42106.404982493303,2.37494E-5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Input","Unit","Low Estimate","High Estimate","Description",null,null,null,null,null,null,null,"DOP","Dominican Peso",58.269157861700002,1.7161737600000001E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Capital Costs",null,null,null,null,null,null,null,null,null,null,null,"ISK","Icelandic Krona",128.30229654639999,7.7940928000000001E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Product-specific equipment","000 $",180,370,"Torque transducer, power analyzers, measurement and control equipment, software, rack, motor frame.",null,null,null,null,null,null,null,"XAG","Silver Ounce",3.9589312299999999E-2,25.259342532200002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Generic equipment (usually pre-owned)","000 $",6.2,10,"Voltage stabilizer, ambient temperature controls, meters and sensors.",null,null,null,null,null,null,null,"CRC","Costa Rican Colon",611.51569283540005,1.6352809999999999E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Accreditation","000 $",5,{"$f":"P79","v":5},"To ISO 17025",null,null,null,null,null,null,null,"SYP","Syrian Pound",512.81925474479999,1.9500048E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Inter-laboratory trials","000 $",3.5,{"$f":"P80","v":3.5},"For calibrating proficiency",null,null,null,null,null,null,null,"LYD","Libyan Dinar",1.3382477173,0.74724581040000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Staff training","000 $",0,20,"Assumption",null,null,null,null,null,null,null,"JMD","Jamaican Dollar",142.29737280769999,7.0275366000000002E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Other costs","000 $",0,50,"Assumption",null,null,null,null,null,null,null,"MUR","Mauritian Rupee",39.372065055599997,2.5398718599999998E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Operational Costs",null,null,null,null,null,null,null,null,null,null,null,"GHS","Ghanaian Cedi",5.8634942915000003,0.17054676790000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Staffing","people",2,{"$f":"P84","v":2},"Minimum number of trained technicians",null,null,null,null,null,null,null,"AOA","Angolan Kwanza",649.53349944620004,1.5395665E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Space","m2",25,{"$f":"P85","v":25},"Minimum space requirements",null,null,null,null,null,null,null,"UYU","Uruguayan Peso",42.494292651499997,2.3532572000000002E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Equipment calibration and maintenance","000 $",2,{"$f":"P86","v":2},"Estimated annual cost",null,null,null,null,null,null,null,"AFN","Afghan Afghani",77.207582657900005,1.2952095699999999E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Capacity building, staff training, laboratory re-certification, others","000 $",2,{"$f":"P87","v":2},"Estimated annual cost",null,null,null,null,null,null,null,"LBP","Lebanese Pound",1507.5,6.6334990000000002E-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Test Revenue",null,null,null,null,null,null,null,null,null,null,null,"XPF","CFP Franc",97.682676099999995,1.0237229800000001E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Default Test Price","000 $",0.3,0.3,"Assumption—based on costs above",null,null,null,null,null,null,null,"TTD","Trinidadian Dollar",6.7888439068000004,0.14730048500000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of Verification Tests","units",50,50,"Assumption",null,null,null,null,null,null,null,"TZS","Tanzanian Shilling",2318.9881799394002,4.3122259999999997E-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ALL","Albanian Lek",101.0476589455,9.8963203000000007E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Refrigerators",null,null,null,null,null,null,null,null,null,null,null,"XCD","East Caribbean Dollar",2.7024920907999999,0.370028835]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Input","Unit","Low Estimate","High Estimate","Description",null,null,null,null,null,null,null,"GTQ","Guatemalan Quetzal",7.7944876686000004,0.12829579599999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Capital Costs",null,null,null,null,null,null,null,null,null,null,null,"NPR","Nepalese Rupee",117.9531233316,8.4779442000000003E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Product-specific equipment*","000 $",252,602,"Test chamber, air handling system, chiller, control and measurement equipment, test loads and conditioning, software.",null,null,null,null,null,null,null,"BOB","Bolivian Bolíviano",6.8824927059999998,0.14529619469999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Generic equipment (usually pre-owned)","000 $",3,5,"Voltage stabilizer, ambient temperature controls, meters and sensors.",null,null,null,null,null,null,null,"ZWD","Zimbabwean Dollar",361.9,2.7631943000000002E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Accreditation","000 $",5,{"$f":"P97","v":5},"To ISO 17025",null,null,null,null,null,null,null,"BBD","Barbadian or Bajan Dollar",2,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Inter-laboratory trials","000 $",5,{"$f":"P98","v":5},"For calibrating proficiency",null,null,null,null,null,null,null,"CUC","Cuban Convertible Peso",1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Staff training","000 $",0,20,"Assumption",null,null,null,null,null,null,null,"LAK","Lao Kip",9295.5421801465,1.0757840000000001E-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Other costs","000 $",0,50,"Assumption",null,null,null,null,null,null,null,"BND","Bruneian Dollar",1.3263161438,0.75396805249999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Operational Costs",null,null,null,null,null,null,null,null,null,null,null,"BWP","Botswana Pula",10.7957262813,9.2629247299999995E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Staffing","people",2,{"$f":"P102","v":2},"Minimum number of trained technicians",null,null,null,null,null,null,null,"HNL","Honduran Lempira",24.1234214013,4.1453489699999999E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Space","m2",50,{"$f":"P103","v":50},"Minimum space requirements",null,null,null,null,null,null,null,"PYG","Paraguayan Guarani",6919.0957559832004,1.445276E-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Equipment calibration and maintenance","000 $",2,{"$f":"P104","v":2},"Estimated annual cost",null,null,null,null,null,null,null,"ETB","Ethiopian Birr",39.308569955499998,2.5439745100000001E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Capacity building, staff training, laboratory re-accreditation and re-certification","000 $",2,{"$f":"P105","v":2},"Estimated annual cost",null,null,null,null,null,null,null,"NAD","Namibian Dollar",15.332717629399999,6.5220010199999998E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Test Revenue",null,null,null,null,null,null,null,null,null,null,null,"PGK","Papua New Guinean Kina",3.5179194599999999,0.28425892390000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Default Test Price","000 $",0.8,0.8,"Assumption—based on costs above",null,null,null,null,null,null,null,"SDG","Sudanese Pound",55.298272493699997,1.8083747599999998E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of Verification Tests","units",50,50,"Assumption",null,null,null,null,null,null,null,"MOP","Macau Pataca",7.9883798637999996,0.1251818287]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NIO","Nicaraguan Cordoba",35.016140438199997,2.85582588E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Televisions",null,null,null,null,null,null,null,null,null,null,null,"BMD","Bermudian Dollar",1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Input","Unit","Low Estimate","High Estimate","Description",null,null,null,null,null,null,null,"KZT","Kazakhstani Tenge",419.23512419880001,2.3852963E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Capital Costs",null,null,null,null,null,null,null,null,null,null,null,"PAB","Panamanian Balboa",1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Product-specific equipment","000 $",16.850000000000001,39.299999999999997,"Power analyzer, control and measurement equipment, test disk and control software.",null,null,null,null,null,null,null,"BAM","Bosnian Convertible Mark",1.6010049364000001,0.62460769309999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Generic equipment (usually pre-owned)","000 $",3.2,6.7,"Voltage stabilizer, ambient temperature controls, meters and sensors.",null,null,null,null,null,null,null,"GYD","Guyanese Dollar",209.44583024209999,4.7745041999999998E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Accreditation","000 $",5,{"$f":"P115","v":5},"To ISO 17025",null,null,null,null,null,null,null,"YER","Yemeni Rial",250.37034955339999,3.9940831999999999E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Inter-laboratory trials","000 $",5,{"$f":"P116","v":5},"For calibrating proficiency",null,null,null,null,null,null,null,"MGA","Malagasy Ariary",3778.4394407228001,2.646595E-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Staff training","000 $",0,20,"Assumption",null,null,null,null,null,null,null,"KYD","Caymanian Dollar",0.81999985610000004,1.2195124091]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Other costs","000 $",0,50,"Assumption",null,null,null,null,null,null,null,"MZN","Mozambican Metical",74.599971866800004,1.34048308E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Operational Costs",null,null,null,null,null,null,null,null,null,null,null,"RSD","Serbian Dinar",96.280787030300004,1.03862882E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Staffing","people",2,{"$f":"P120","v":2},"Minimum number of trained technicians",null,null,null,null,null,null,null,"SCR","Seychellois Rupee",21.178460550299999,4.72177851E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Space","m2",25,{"$f":"P121","v":25},"Minimum space requirements",null,null,null,null,null,null,null,"AMD","Armenian Dram",522.59242155439995,1.9135370999999999E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Equipment calibration and maintenance","000 $",2.5,{"$f":"P122","v":2.5},"Estimated annual cost",null,null,null,null,null,null,null,"SBD","Solomon Islander Dollar",7.9710109364999999,0.1254546014]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Capacity building, staff training, laboratory re-certification, others","000 $",2,{"$f":"P123","v":2},"Estimated annual cost",null,null,null,null,null,null,null,"AZN","Azerbaijan Manat",1.6989872105999999,0.58858594919999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Test Revenue",null,null,null,null,null,null,null,null,null,null,null,"SLL","Sierra Leonean Leone",10226.9789084612,9.7780600000000004E-5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Default Test Price","000 $",0.5,0.5,"Assumption—based on costs above",null,null,null,null,null,null,null,"TOP","Tongan Pa'anga",2.2517426271000001,0.44410048819999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of Verification Tests","units",50,50,"Assumption",null,null,null,null,null,null,null,"BZD","Belizean Dollar",2.0157590097,0.4960910482]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MWK","Malawian Kwacha",771.70464528380001,1.2958326E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GMD","Gambian Dalasi",51.694217767700003,1.9344523299999999E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BIF","Burundian Franc",1944.9993419857999,5.1413900000000005E-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SOS","Somali Shilling",577.30013275520002,1.7322011999999999E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HTG","Haitian Gourde",72.702233234399998,1.37547357E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GNF","Guinean Franc",10261.445064662201,9.7452200000000002E-5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MVR","Maldivian Rufiyaa",15.342933970700001,6.5176582400000002E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MNT","Mongolian Tughrik",2849.2224257182002,3.5097299999999998E-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CDF","Congolese Franc",1974.7492532859001,5.0639339999999998E-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STN","Sao Tomean Dobra",19.972945771500001,5.0067727200000002E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TJS","Tajikistani Somoni",11.2999954026,8.8495611200000004E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KPW","North Korean Won",900.04529894899997,1.1110552E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MMK","Burmese Kyat",1327.8265043621,7.5311040000000001E-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LSL","Basotho Loti",15.332717629399999,6.5220010199999998E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LRD","Liberian Dollar",166.8665932291,5.9928113000000003E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KGS","Kyrgyzstani Som",83.180783654099997,1.20220074E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GIP","Gibraltar Pound",0.73712086210000005,1.3566296267]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"XPT","Platinum Ounce",9.3623230000000005E-4,1068.1109805761]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MDL","Moldovan Leu",17.191363494200001,5.8168742699999998E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CUP","Cuban Peso",26.5,3.7735849100000003E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KHR","Cambodian Riel",4054.8007539314999,2.466212E-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MKD","Macedonian Denar",50.133763613600003,1.99466373E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VUV","Ni-Vanuatu Vatu",107.9802772333,9.2609505000000002E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MRU","Mauritanian Ouguiya",36.317482640900003,2.7534948100000001E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANG","Dutch Guilder",1.789945181,0.55867632739999995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SZL","Swazi Lilangeni",15.332717629399999,6.5220010199999998E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CVE","Cape Verdean Escudo",90.264907652299996,1.1078502400000001E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SRD","Surinamese Dollar",14.1526874033,7.0657958600000001E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"XPD","Palladium Ounce",4.2349560000000001E-4,2361.2996215308999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SVC","Salvadoran Colon",8.75,0.11428571429999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BSD","Bahamian Dollar",1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"XDR","IMF Special Drawing Rights",0.69319178130000003,1.4426022163000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RWF","Rwandan Franc",973.75980174769995,1.0269472999999999E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AWG","Aruban or Dutch Guilder",1.79,0.55865921789999995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DJF","Djiboutian Franc",177.77344223470001,5.6251371999999997E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BTN","Bhutanese Ngultrum",73.376748573300006,1.3628295299999999E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KMF","Comorian Franc",402.71536702319997,2.4831433999999999E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WST","Samoan Tala",2.4938261514,0.40099026129999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SPL","Seborgan Luigino",0.16666666599999999,6.0000000240000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ERN","Eritrean Nakfa",15,6.6666666700000002E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FKP","Falkland Island Pound",0.73712086210000005,1.3566296267]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SHP","Saint Helenian Pound",0.73712086210000005,1.3566296267]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JEP","Jersey Pound",0.73712086210000005,1.3566296267]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TMT","Turkmenistani Manat",3.4999999718999999,0.28571428799999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TVD","Tuvaluan Dollar",1.2904542468,0.77492092609999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IMP","Isle of Man Pound",0.73712086210000005,1.3566296267]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GGP","Guernsey Pound",0.73712086210000005,1.3566296267]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ZMW","Zambian Kwacha",21.2301397612,4.7102845800000001E-2]

{"sheet":"Model","index":3,"n_rows":58,"n_cols":14,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Year",0,1,2,3,4,5,6,7,8,9,10]
["COSTS"]
[{"$f":"Control!B13","v":0},"External Funding?"]
[{"$f":"Control!B14","v":"Product-specific equipment (000 USD)"},false,{"$f":"IF(B5,0,INDEX(Costs,MATCH($A5,CostCategories,0)))","v":500},{"$f":"-C5","v":-500}]
[{"$f":"Control!B15","v":"Generic equipment  (000 USD)"},false,{"$f":"IF(B6,0,INDEX(Costs,MATCH($A6,CostCategories,0)))","v":4},-4]
[{"$f":"Control!B16","v":"Accreditation  (000 USD)"},false,5,-5]
[{"$f":"Control!B17","v":"Inter-laboratory testing  (000 USD)"},false,5,-5]
[{"$f":"Control!B18","v":"Staff training  (000 USD)"},false,1,-1]
[{"$f":"Control!B19","v":"Other costs  (000 USD)"},false,{"$f":"IF(B10,0,INDEX(Costs,MATCH($A10,CostCategories,0)))","v":0},0]
[{"$f":"Control!B26","v":"Staff salary (000 USD/person)"},false,25,null,{"$f":"-$C11*$C44","v":-50},-50,-50,-50,-50,-50,-50,-50,-50,-50]
[{"$f":"Control!B28","v":"Rent for laboratory space (000 USD/10m2)"},false,4,null,{"$f":"-$C12*$C45/10","v":-24},-24,-24,-24,-24,-24,-24,-24,-24,-24]
[{"$f":"Control!B31","v":"Equipment calibration and maintenance (000 USD)"},false,10,null,{"$f":"-$C13","v":-10},-10,-10,-10,-10,-10,-10,-10,-10,-10]
[{"$f":"Control!B32","v":"Additional annual costs (000 USD)"},false,2,null,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2]
["Total Costs",null,{"$f":"SUM(D15:AK15)","v":-1375},{"$f":"SUM(D5:D14)","v":-515},{"$f":"SUM(E5:E14)","v":-86},-86,-86,-86,-86,-86,-86,-86,-86,-86]
["Annual Cost of Lab (Nominal)",null,{"$f":"C15/MAX($2:$2)","v":-137.5}]
["Discounted Costs",null,{"$f":"SUM(D17:AK17)","v":-1092.067000308964},{"$f":"D15/(1+$C$46)^D$2","v":-515},{"$f":"E15/(1+$C$46)^E$2","v":-79.629629629629619},-73.731138545953357,{"$f":"G15/(1+$C$46)^G$2","v":-68.269572727734584},-63.212567340494978,-58.530154944902762,-54.194587911946989,-50.180173992543509,-46.463124067169915,-43.021411173305474,-39.834639975282848]
["Annual Cost of Lab (Discounted)",null,{"$f":"C17/MAX($2:$2)","v":-109.2067000308964}]
[]
["REVENUES"]
[]
["Revenue from verification testing",null,null,null,{"$f":"IF(COUNTIF($B$50,\"FALSE\"),$C$50,0)","v":60},{"$f":"IF(COUNTIF($B$50,\"FALSE\"),$C$50,0)","v":60},60,60,60,60,60,60,60,60]
[{"$f":"Control!B55","v":"Other Annual Revenue (000 USD):"},null,null,null,{"$f":"$C$58","v":0},{"$f":"$C$58","v":0},0,0,0,0,0,0,0,0]
["Total Revenues Less Commercial Testing (Nominal)",null,null,null,{"$f":"SUM(E22:E23)","v":60},{"$f":"SUM(F22:F23)","v":60},60,60,60,60,60,60,60,60]
["Cash Flows Less Commercial Testing (Nominal)",null,{"$f":"SUM(D25:AK25)","v":-775},{"$f":"D15+D24","v":-515},-26,-26,-26,-26,-26,-26,-26,-26,-26,-26]
["Annual Cash Flow Less Commercial Testing (Nominal)",null,{"$f":"C25/MAX($2:$2)","v":-77.5}]
["Cash Flows Less Commercial Testing (Discounted)",null,{"$f":"SUM(D27:AK27)","v":-689.46211637247745},{"$f":"D25/(1+$C$46)^D$2","v":-515},{"$f":"E25/(1+$C$46)^E$2","v":-24.074074074074073},-22.290809327846365,-20.639638266524408,-19.110776172707784,-17.695163122877577,-16.38441029896072,{"$f":"K25/(1+$C$46)^K$2","v":-15.170750276815479},-14.04699099705137,-13.006473145417933,-12.043030690201791]
["Annual Cash Flow Less Commercial Testing (Discounted)",null,{"$f":"C27/MAX($2:$2)","v":-68.946211637247742}]
[]
[]
[]
["Revenue from commercial testing",null,null,null,{"$f":"$C$53*$C$54","v":102.75018667899381},{"$f":"$C$53*$C$54","v":102.75018667899381},102.75018667899381,102.75018667899381,102.75018667899381,102.75018667899381,102.75018667899381,102.75018667899381,102.75018667899381,102.75018667899381]
["Total Revenues (Nominal)",null,null,null,{"$f":"SUM(E24,E32)","v":162.75018667899383},{"$f":"SUM(F24,F32)","v":162.75018667899383},162.75018667899383,162.75018667899383,162.75018667899383,162.75018667899383,162.75018667899383,162.75018667899383,162.75018667899383,162.75018667899383]
[]
["Discounted Revenues",null,{"$f":"SUM(D35:AK35)","v":1092.0670003089638},{"$f":"D33/(1+$C$46)^D$2","v":0},{"$f":"E33/(1+$C$46)^E$2","v":150.69461729536465},{"$f":"F33/(1+$C$46)^F$2","v":139.53205305126355},129.19634541783662,119.62624575725611,110.76504236782974,102.56022441465716,94.963170754312173,87.928861809548309,81.415612786618794,75.384826654276665]
["Annual revenues of lab (discounted)",null,{"$f":"C35/MAX($2:$2)","v":109.20670003089637}]
["Cash Flows",null,{"$f":"SUM(D37:AK37)","v":252.50186678993828},{"$f":"D15+D33","v":-515},{"$f":"E15+E33","v":76.750186678993828},{"$f":"F15+F33","v":76.750186678993828},{"$f":"G15+G33","v":76.750186678993828},76.750186678993828,76.750186678993828,76.750186678993828,76.750186678993828,76.750186678993828,76.750186678993828,76.750186678993828]
["Discounted Cash Flows",null,{"$f":"SUM(D38:AK38)","v":-2.2026824808563106E-13},{"$f":"D37/(1+$C$46)^D$2","v":-515},{"$f":"E37/(1+$C$46)^E$2","v":71.064987665735018},65.800914505310203,60.926772690102034,56.413678416761144,52.234887422926981,48.36563650271016,44.782996761768665,41.465737742378394,38.394201613313328,35.550186678993818]
["Cumulative Costs and Revenues (Discounted to Present Year)",null,null,{"$f":"SUM(D38:$D38)","v":-515},{"$f":"SUM($D38:E38)","v":-443.93501233426497},{"$f":"SUM($D38:F38)","v":-378.13409782895474},{"$f":"SUM($D38:G38)","v":-317.2073251388527},{"$f":"SUM($D38:H38)","v":-260.79364672209158},{"$f":"SUM($D38:I38)","v":-208.55875929916459},{"$f":"SUM($D38:J38)","v":-160.19312279645442},{"$f":"SUM($D38:K38)","v":-115.41012603468576},{"$f":"SUM($D38:L38)","v":-73.944388292307366},{"$f":"SUM($D38:M38)","v":-35.550186678994038},{"$f":"SUM($D38:N38)","v":-2.2026824808563106E-13}]
["NPV of Total Costs and Revenues",null,{"$f":"N39","v":-2.2026824808563106E-13}]
[]
[]
["Other Data"]
[{"$f":"Control!B25","v":"Staffing (number of people)"},null,{"$f":"INDEX(Costs,MATCH($A44,CostCategories,0))","v":2}]
[{"$f":"Control!B27","v":"Laboratory space (m2)"},null,{"$f":"INDEX(Costs,MATCH($A45,CostCategories,0))","v":60}]
["Discount Rate (%)",null,{"$f":"Control!E34/100","v":0.08}]
[]
[{"$f":"Control!B42","v":"Number of Verification Tests Per Year:"},null,{"$f":"Control!D42","v":50}]
[{"$f":"Control!B43","v":"Price per Verification Test (000 USD):"},null,{"$f":"Control!D43","v":1.2}]
[{"$f":"Control!B44","v":"Annual Verification Testing revenue  (000 USD):"},false,{"$f":"Control!D44","v":60}]
[null,"^ Exclude from analysis ^"]
["Break-Even Number of Commercial Tests",null,{"$f":"PMT($C$46,MAX($2:$2),$C$27)/$C$54","v":85.62515556582818},"(Adjust VBA code when shifting cells)"]
["Number of Commercial Tests",null,{"$f":"Control!$D$50","v":85.62515556582818}]
[{"$f":"Control!B51","v":"Price Charged per Commercial Test (000 USD):"},null,{"$f":"Control!D51","v":1.2}]
[{"$f":"Control!B52","v":"Annual Commercial Test Revenue (000 USD):"},null,{"$f":"Control!D52","v":102.75018667899381}]
[]
[]
[{"$f":"Control!B55","v":"Other Annual Revenue (000 USD):"},null,{"$f":"Control!D55","v":0}]

{"sheet":"Flags","index":4,"n_rows":16,"n_cols":1,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
["-- (USD)"]
[" Benin (XOF)"]
[" Burkina Faso (XOF)"]
[" Cape Verde (CVE)"]
[" Gambia (GMD)"]
[" Ghana (GHS)"]
[" Guinea (GNF)"]
[" Guinea-Bissau (XOF)"]
[" Ivory Coast (XOF)"]
[" Liberia (LRD)"]
[" Mali (XOF)"]
[" Niger (XOF)"]
[" Nigeria (NGN)"]
[" Senegal (XOF)"]
[" Sierra Leone (SLL)"]
[" Togo (XOF)"]