{"text_format":"1","workbook":"xlsx","n_sheets":32,"sheets":["TITLE","Intro and instructions","Epidemiology","LAM","Truenat","TB-LAMP","Xpert MTB RIF Ultra","ZN microscopy","LED microscopy","Xpert MTB XDR","LPA 1st line","LPA 2nd line","MAX MDR-TB assay","FluoroType MTBDR VER 2.0","Cobas MTB and MTB-RIF-INH","Abbott RT MTB and MTB RIF-INH","Processing&solid-liquid culture","ID","LJ 1st line DST","LJ 2nd line DST","MGIT 1st line DST","MGIT 2nd line DST","Biosafety and cleaning","Maintenance & repair","Human resources","QA","OPERATION","BUDGET SUMMARY","LAB ITEM SUMMARY ","Sheet1","LPA and Tips","Lab items list"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":90,"comments":3,"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":"TITLE","index":0,"n_rows":51,"n_cols":15,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["WHO/UCN/TB/2021.8"]
["© WHO 2021. Some rights reserved. This work is available under the",null,null,null,null,null,null,null,null,null,"CC BY-NC-SA 3.0 IGO",null,null,null,"licence"]

{"sheet":"Intro and instructions","index":1,"n_rows":40,"n_cols":15,"rows_kept":40,"cut":false,"hidden":false,"merged":[[38,0,38,3],[39,0,41,0],[0,0,0,11],[2,0,2,10],[4,0,4,1],[31,0,33,0],[31,1,33,1],[35,0,37,0],[27,0,29,0],[27,1,29,1]]}
["Tool for calculating budget for consumables for TB diagnostics, version 2.0"]
[]
["This tool has been designed to facilitate systematic calculation of the quantities and costs of products for countries planning to order diagnostic products and laboratory supplies from the GDF catalogue. \nTo use the tool, please follow the steps below"]
[]
["Step 1: Select the tests or consumables for which you want a forecast. \n(Please use drop-down list to choose)"]
["LAM","Yes","<=Choose here"]
["Truenat","Yes","<=Choose here"]
["TB-LAMP","Yes","<=Choose here"]
["Xpert MTB/RIF Ultra","Yes","<=Choose here"]
["Ziehl-Neelsen microscopy","Yes","<=Choose here",null,null,null,null,null,null,null,null,null,null,"Yes","No"]
["Light-emitting diode microscopy","Yes","<=Choose here"]
["Xpert MTB/XDR","Yes","<=Choose here"]
["LPA 1st line","Yes","<=Choose here"]
["LPA 2nd line","Yes","<=Choose here"]
["MAX MDR-TB assay","Yes","<=Choose here"]
["FluoroType MTBDR VER 2.0","Yes","<=Choose here"]
["Cobas® MTB and MTB-RIF-INH","Yes","<=Choose here"]
["Abbott RT MTB and MTB RIF-INH","Yes","<=Choose here"]
["Processing and solid and liquid cultures","Yes","<=Choose here"]
["Mycobacteria Identification","Yes","<=Choose here"]
["Lowenstein-Jensen 1st-line DST","Yes","<=Choose here"]
["Lowenstein-Jensen 2nd-line DST","Yes","<=Choose here"]
["MGIT 1st-line DST","Yes","<=Choose here"]
["MGIT 2nd-line DST","Yes","<=Choose here"]
["Biosafety and cleaning","Yes","<=Choose here"]
["Maintenance and repair","Yes","<=Choose here"]
[]
["Step 2 : Enter the year of interest"]
[]
[]
[]
["Step 3 : Define the forecasting period (months)"]
[]
[]
[]
["Step 4 : Compile the epidemiological information"]
[]
[]
[]
["Step 5 : Use the consumption or the morbidity-based forecasting method for each selected diagnostic test. "]

{"sheet":"Epidemiology","index":2,"n_rows":32,"n_cols":5,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,4],[2,0,2,4],[1,0,1,4],[31,0,33,1],[18,0,18,4],[24,0,24,5],[14,0,14,4]]}
["Epidemiology:\nfor calculation of morbidity-based forecasts"]
["Values in red should be entered or adjusted according to actual country data and practices, when possible."]
["TB epidemiology"]
["Pulmonary, bacteriologically confirmed","New cases:",0,"Relapse cases:",0]
["Pulmonary, clinicially diagnosed","New cases:",0,"Relapse cases:",0]
["Extrapulmonary","New cases:",0,"Relapse cases:",0]
["Total no. of new cases notified",null,{"$f":"SUM(C4:C6)","v":0},"Total relapse cases notified:",{"$f":"SUM(E4:E6)","v":0}]
["Previously treated cases, excluding relapses",0]
["Total no. of cases notified",{"$f":"SUM(C4:C6,E4:E6,B8)","v":0}]
["TB cases in children (%)",0,null,"Adult TB cases (%):",0]
["TB cases in HIV-positive people (%)",0,null,"HIV-negative or HIV-unknown cases (%):",0]
["Number of HIV-positive people in care",0]
["Number of new HIV-positive notifications (annual)",0]
["Anticipated number of RR/MDR-TB cases to be detected during the year",0]
["General assumptions"]
["Percentage of relapse or previously treated with mono INH- R",0]
["Ratio of people with signs and symptoms of TB who have a history of previous succesful treatment: notified relapse cases",0,null,"Ratio of contacts per notified RR-TB case",0]
["Ratio of people with signs and symptoms of TB: 1 bacteriologically confirmed (or smear-positive) notified case",0]
["HIV assumptions"]
["Average number of times that clinical screening for TB is performed per person living with HIV (PLHIV) per year",0,null,"% of PLHIV found to have signs and symptoms of TB when screened ",0]
[null,null,null,"% of seriously ill PLHIV population or with CD4 < 200 found to have signs and symptoms of TB when screened ",0]
[null,null,null,"% of PLHIV population that is seriously ill or with CD4 < 200",0.15]
[null,null,null,"% of seriously ill PLHIV population or with CD4 < 100 found to have signs and symptoms of TB when screened ",0.3]
[null,null,null,"% of PLHIV population that is seriously ill or with CD4 < 100",0.1]
["Child assumptions"]
["Ratio of children with signs and symptoms of TB: children notified with TB",0]
[]
[]
[]
[]
[]
["Step 4: Navigate to the sheets below, and use  consumption-based or  morbidity-based forecasting  for each selected diagnostic test. "]

{"sheet":"LAM","index":3,"n_rows":27,"n_cols":17,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,1,1,7],[13,1,13,2],[3,1,3,2],[3,4,3,6],[8,4,8,5]]}
["LAM\nTwo methods are proposed for calculating the expected number of tests to be performed during the period."]
[null,"Values in red should be entered or adjusted according to actual country data and practices,when possible."]
[]
[null,"Method 1: Consumption-based forecasting\nThe expected number of tests is based on the number of tests used on average per month.",null,null,"Method 2: Morbidity-based forecasting\nThe estimated number of tests calculated is based on epidemiological data (notifications) and planned algorithms. The calculated sum is the target to be reached when algorithms are used according to the indicated coverage and assumptions."]
[null,"Average number of LAM tests performed per month",0,null,"Patient population","Coverage of testing","Number of LAM tests for the period"]
[null,"Number of LAM tests performed during the period",{"$f":"C5*Months","v":0},null,"People living with HIV (PLHIV) with signs and symptoms of TB",0,{"$f":"ROUND((Epidemiology!B12*F6*Epidemiology!B20*Epidemiology!E20),-2)","v":0}]
[null,null,null,null,"PLHIV seriously ill or with CD4 < 200",0,{"$f":"ROUND((Epidemiology!B12+Epidemiology!B13)*F7*Epidemiology!B20*Epidemiology!E21,-2)","v":0}]
[null,null,null,null,"PLHIV seriously ill or with CD4 < 100",1,{"$f":"ROUND((Epidemiology!B12+Epidemiology!B13)*F8*Epidemiology!B20*Epidemiology!E23*Epidemiology!E24,-2)","v":0}]
[null,null,null,null,"Total number of LAM for the period",null,{"$f":"SUM(G6:G8)","v":0},null,null,null,null,null,null,null,null,{"$f":"Epidemiology!E11*Epidemiology!E10*Epidemiology!C4","v":0},"Adult/HIV+/Bac+"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Epidemiology!C7*Epidemiology!B10","v":0},"Children"]
[null,"Quantities of LAM products to order"]
[null,"Total number of LAM performed during the period\n(with forecasting method 1 or 2 or a value in between)",0]
[null,"Current stock",0]
[null,"Total number of LAM required during the period",{"$f":"C15","v":0}]
[null,"Total number of LAM to be ordered",{"$f":"C15-C16","v":0}]
[]
["GDF code","ITEMS","Unit / pack","Need per test","No. of packs to be ordered","Unit cost (US$)","Calculation details"]
[106749,"Determine TB LAM Ag tests",25,1,{"$f":"ROUNDUP((D21/C21*C18),0)","v":0},92.5]
[106525,"Sputum containers",1000,1,{"$f":"ROUNDUP((D22/C22*C18),0)","v":0},83.3,"For collecting urine "]
[106388,"Sterile pipette filter tips, 5–100 µL",960,1,{"$f":"ROUNDUP((D23/C23*C18),0)","v":0},61,"For delivering 60 μL and suitable for 1-channel pipette, varies from 20 to 200 µL "]
[]
[null,"Summary","Cost (US$)"]
[null,"Total cost of LAM products",{"$f":"SUMPRODUCT(E21:E23,F21:F23)","v":0}]
[null,"Cost per sample tested",{"$f":"IF(C18=0,\"\",(C26/C18))","v":""}]

{"sheet":"Truenat","index":4,"n_rows":31,"n_cols":37,"rows_kept":31,"cut":false,"hidden":false,"merged":[[11,4,11,5],[16,1,16,2],[0,1,0,6],[1,1,1,6],[4,1,4,2],[4,4,4,6]]}
[null,"Truenat\nTwo methods are proposed for calculating the expected number of tests to be performed during the period."]
[null,"Values in red should be entered or adjusted according to actual country data and practices,when possible."]
[null,"No. of tests performed last year",0]
[]
[null,"Method 1: Consumption-based forecasting\nThe expected number of tests is based on the average daily use per instrument module.",null,null,"Method 2: Morbidity-based forecasting\nThe estimated number of tests calculated is based on epidemiological data (notifications) and planned algorithms. The calculated sum is the target to be reached when algorithms are implemented according to the indicated coverage and assumptions. The default coverage below is for an Truenat-for-all algorithm (100% coverage for all patient groups)"]
[null,"Number of Truelab analysers (uno)",0,null,"Patient population","Coverage of testing","Number of Truenat tests required for the period"]
[null,"Number of Truelab analysers (duo)",0,null,"People living with HIV (PLHIV) with signs and symptoms of TB",0,{"$f":"ROUND((F7*Epidemiology!B12*Epidemiology!B20*Epidemiology!E20),-2)","v":0}]
[null,"Number of Truelab analysers (quattro)",0,null,"Children with signs and symptoms of TB",0,{"$f":"ROUND(F8*Epidemiology!B9*Epidemiology!B10*Epidemiology!B26, -2)","v":0}]
[null,"Total number of chip ports",{"$f":"(C6*1)+(C7*2)+(C8*4)","v":0},null,"People at risk of drug-resistant TB",0,{"$f":"ROUND(F9*(Epidemiology!E7*Epidemiology!B17)+Epidemiology!B8+(Epidemiology!B14*Epidemiology!E17), -2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of Truepep devices",1,null,null,null,"Number of Truepep devices",1,null,null,"Number of Truepep devices",2]
[null,"Number of working days per year",0,null,"Previously untreated HIV-negative adults with signs and symptoms of TB",0,{"$f":"ROUND(F10*Epidemiology!E11*Epidemiology!E10*Epidemiology!C4*Epidemiology!B18,-2)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Epidemiology!B9*Epidemiology!B10","v":0},"Children",null,null,null,null,null,null,"Number of Truelab analysers (uno)",1,null,null,null,"Number of Truelab analysers (duo)",1,null,null,"Number of Truelab analysers (quattro)",1]
[null,"Average number of chip ports used per day",0,null,"New smear-positive TB cases receiving Truenat for rifampicin testing  (excluding those who received it as the initial diagnostic test)",0,{"$f":"ROUND(Epidemiology!C7-((Epidemiology!B9*Epidemiology!B10)+(Epidemiology!E7+Epidemiology!B8+Epidemiology!B14)+(Epidemiology!E11*Epidemiology!E10*Epidemiology!C4)+(Epidemiology!C7*Epidemiology!B10)),-2)*F11","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Epidemiology!E7+Epidemiology!B8+Epidemiology!B14","v":0},"Relapse/PR/MDR",null,null,null,null,null,null,null,{"$f":"IF(AB9=1,IF(AB10=1,(8),0),0)","v":8},null,null,null,null,{"$f":"IF(AG9=1,IF(AG10=1,(17),0),0)","v":17},null,null,null,{"$f":"IF(AK9=2,IF(AK10=1,(33),0),0)","v":33}]
[null,"Number of Treunat tests required for the period",{"$f":"C9*C10*C11","v":0},null,"Total number of Truenat cartridges required for the period",null,{"$f":"SUM(G7:G11)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Epidemiology!E11*Epidemiology!E10*Epidemiology!C4","v":0},"Adult/HIV+/Bac+"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Epidemiology!C7*Epidemiology!B10","v":0},"Children"]
[null,"Quantities of Truenat products to be ordered"]
[null,"Number of Truenat tests required for the period\n(with forecasting method 1 or 2 or a value in between)",0]
[null,"Percentage of invalid, error or no result",0]
[null,"Current stock",0]
[null,"Total number of Truenat tests required for the period",0]
[null,"Total number of Truenat tests to be ordered",{"$f":"((C18*C19)+C18)-C20","v":0}]
[null,"Free Truenat MTB Rif",{"$f":"(C22/100)*20","v":0}]
[]
[]
["GDF code","Item","Unit / pack","No. of packs to be ordered","Unit cost (US$)","Comment"]
[106697,"Truenat MTB  Plus",50,{"$f":"ROUNDUP((C22/C27),0)","v":0},450,"Other unit packs available, 5 and 20"]
[106700,"Truenat MTB Rif",50,0,400,"Additional Truenat MTB Rif testing  - Other unit packs available, 5 and 20"]
[]
[null,"Summary","Cost (US$)"]
[null,"Total cost of Truenat products",{"$f":"SUMPRODUCT(D27:D28,E27:E28)","v":0}]

{"sheet":"TB-LAMP","index":5,"n_rows":29,"n_cols":19,"rows_kept":29,"cut":false,"hidden":false,"merged":[[28,3,28,6],[0,0,0,8],[1,1,1,6],[3,1,3,2],[3,4,3,6],[11,3,13,4]]}
["TB-LAMP\nTwo methods are proposed for calculating the expected number of tests to be performed during the period."]
[null,"Values in red should be entered or adjusted according to actual country data and practices, when possible."]
[]
[null,"Method 1: Consumption-based forecasting\nThe expected number of tests is based on number of tests performed last year.",null,null,"Method 2: Morbidity-based forecasting\nThe estimated number of tests calculated is based on epidemiological data (notifications) and planned algorithms. The calculated sum is the target to be reached when algorithms are implemented according to the indicated coverage and assumptions."]
[null,"Average number of TB LAMP tests performed per month",0,null,"Patient population","Coverage of testing","Number of TB-LAMP tests required for the period"]
[null,"Number of TB LAMP tests required for the period",{"$f":"C5*Months","v":0},null,"People with signs and symptoms of TB",0,{"$f":"ROUND((Epidemiology!B12*Epidemiology!B20*Epidemiology!E20)+(Epidemiology!B9*Epidemiology!B10*Epidemiology!B26)+(Epidemiology!E7*Epidemiology!B17)+Epidemiology!B8+(Epidemiology!B14*Epidemiology!E17)+(Epidemiology!E11*Epidemiology!E10*Epidemiology!C4*Epidemiology!B18)+(Epidemiology!C7-((Epidemiology!B9*Epidemiology!B10)+(Epidemiology!E7+Epidemiology!B8+Epidemiology!B14)+(Epidemiology!E11*Epidemiology!E10*Epidemiology!C4)+(Epidemiology!C7*Epidemiology!B10))),-2)*F6","v":0}]
[]
[]
[]
[]
[]
[null,"Number of batches used per day",0,"Enter the appropriate number based on past consumption. The default number is based on maximum efficiency testing (14 specimens per batch and 5 testing cycles per day)"]
[null,"Number of specimens per batch",0]
[null,"Number of controls per batch",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S7:S9)","v":0}]
[null,"Number of TB LAMP tests required for the period\n(using forecasting method 1 or 2 or a value in between)",0]
[null,"Average size of a batch",{"$f":"C13+C14","v":0}]
[null,"Number of batches required for the period",{"$f":"IF(C13=0,0,(C15/C13))","v":0}]
[null,"Current stock",0]
[null,"Total number of TB-LAMP  required for the period (specimens plus controls)",{"$f":"(C17*C16)","v":0}]
[null,"Total number of TB-LAMP  required to be ordered (specimens plus controls)",{"$f":"(IF(C18=0,(C17*C16),(C17*C16)-C18))","v":0}]
[]
["GDF code","Item","Unit / pack","Need per test","No. of packs to be ordered","Unit cost (US$)","Calculation details"]
[106634,"Loopamp MTBC Detection Kit (2 x 48 tests)",96,1.1399999999999999,{"$f":"ROUNDUP((D23/C23*C20),0)","v":0},219,"A detection kit of 96 tests will provide the appropriate number of reagents for 6 cycles of 84 patient samples plus 6 negative controls and 6 positive controls."]
[106635,"Loopamp PURE DNA Extraction Kit (90 tests)",90,1.07,{"$f":"ROUNDUP((D24/C24*C20),0)","v":0},275,"An extraction kit of 90 tests will provide the appropriate number of reagents for 6 cycles of 84 patient samples plus 6 negative controls and 6 positive controls."]
[106643,"Pipette-60 set for TB LAMP (4 x 96 tests)",384,1,{"$f":"ROUNDUP((D25/C25*C20),0)","v":0},42]
[]
[null,"Summary","Cost (US$)"]
[null,"Total cost of TB-LAMP products",{"$f":"SUMPRODUCT(E23:E25,F23:F25)","v":0}]
[null,"Cost per sample tested",{"$f":"IF(C20=0,\"\",(C28/C20))","v":""},"The cost per patient sample for reagents and consumables depends on the batch size of the cycle.\nFor only maximum efficiency (14 specimens per batch and 5 testing cycles per day), the cost is US$ 6 per patient sample "]

{"sheet":"Xpert MTB RIF Ultra","index":6,"n_rows":30,"n_cols":20,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,1,1,7],[16,1,16,2],[4,4,4,6],[4,1,4,2],[11,4,11,5]]}
["Xpert MTB/RIF\nTwo methods are proposed for calculating the expected number of tests to be performed during the period."]
[null,"Values in red should be entered or adjusted according to actual country data and practices, when possible."]
[null,"No. of tests performed last year",0]
[]
[null,"Method 1: Consumption-based forecasting\nThe expected number of tests is based on the average daily use per instrument module.",null,null,"Method 2: Morbidity-based forecasting\nThe estimated number of tests calculated is based on epidemiological data (notifications) and planned algorithms. The calculated sum is the target to be reached when algorithms are implemented according to the indicated coverage and assumptions. The default coverage below is for an Xpert-for-all algorithm (100% coverage for all patient groups)."]
[null,"Number of instrument modules in the country",0,null,"Patient population","Coverage of testing","Number of Xpert MTB/RIF tests required for the period"]
[null,"Number of working days per year",0,null,"People living with HIV (PLHIV) with signs and symptoms of TB",0,{"$f":"ROUND((F7*Epidemiology!B12*Epidemiology!B20*Epidemiology!E20),-2)","v":0}]
[null,"Average number of Xpert MTB/RIF tests performed per module per day",0,null,"Children with signs and symptoms of TB",0,{"$f":"ROUND(F8*Epidemiology!B9*Epidemiology!B10*Epidemiology!B26, -2)","v":0}]
[null,"Number of Xpert MTB/RIF Ultra tests required for the period",{"$f":"C6*C7*C8","v":0},null,"People at risk of drug-resistant TB",0,{"$f":"ROUND(F9*(Epidemiology!E7*Epidemiology!B17)+Epidemiology!B8+(Epidemiology!B14*Epidemiology!E17), -2)","v":0}]
[null,null,null,null,"Previously untreated HIV-negative adults with signs and symptoms of TB",0,{"$f":"ROUND(F10*Epidemiology!E11*Epidemiology!E10*Epidemiology!C4*Epidemiology!B18,-2)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Epidemiology!B9*Epidemiology!B10","v":0},"Children"]
[null,null,null,null,"New smear-positive TB cases receiving Xpert for rifampicin testing purposes (excluding those receiving it as the initial diagnostic test)",0,{"$f":"ROUND(Epidemiology!C7-((Epidemiology!B9*Epidemiology!B10)+(Epidemiology!E7+Epidemiology!B8+Epidemiology!B14)+(Epidemiology!E11*Epidemiology!E10*Epidemiology!C4)+(Epidemiology!C7*Epidemiology!B10)),-2)*F11","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Epidemiology!E7+Epidemiology!B8+Epidemiology!B14","v":0},"Relapse/PR/MDR"]
[null,null,null,null,"Total number of Xpert MTB/RIF Ultra cartridges required for the period",null,{"$f":"SUM(G7:G11)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Epidemiology!E11*Epidemiology!E10*Epidemiology!C4","v":0},"Adult/HIV+/Bac+"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Epidemiology!C7*Epidemiology!B10","v":0},"Children"]
[null,"Quantities of Xpert MTB/RIF Ultra products to be ordered"]
[null,"Number of Xpert MTB/RIF cartridges required for the period\n(with forecasting method 1 or 2 or a value in between)",0]
[null,"Percentage of invalid, error, no result",0]
[null,"Current stock",0]
[null,"Total number of Xpert MTB/RIF cartridges required for the period",{"$f":"((C18*C19)+C18)","v":0}]
[null,"Total number of Xpert MTB/RIF cartridges to be ordered",{"$f":"((C18*C19)+C18)-C20","v":0}]
[]
["GDF code","Item","Units / pack","No. of packs to be ordered","Unit cost (US$)","Calculation details"]
["CGXMTB-RIF-50","Xpert MTB/RIF cartridges",50,{"$f":"ROUNDUP((C22/C25),0)","v":0},499]
[106340,"Sterile plastic centrifuge tubes 50 mL",500,0,45,"If you use normal sputum containers, set \"0\" for No. of packs to be ordered"]
[106525,"Sputum containers, pack of 1000",1000,{"$f":"ROUNDUP(((C22*1.1)/C27),0)","v":0},83.3]
[]
[null,"Summary","Cost (US$)"]
[null,"Total cost of Xpert MTB Rif Ultra products",{"$f":"SUMPRODUCT(D25:D27,E25:E27)","v":0}]

{"sheet":"ZN microscopy","index":7,"n_rows":57,"n_cols":24,"rows_kept":57,"cut":false,"hidden":false,"merged":[[3,1,3,2],[3,4,3,6],[1,1,1,8],[0,0,0,10],[4,3,4,6]]}
["Smear microscopy with Ziehl-Neelsen stain (ZN)\nTwo methods are proposed for calculating the expected number of tests to be performed during the period."]
[null,"Values in red should be entered or adjusted according to actual country data and practices, when possible."]
[]
[null,"Method 1: Consumption-based forecasting\nThe expected number of tests is based on number of tests performed last year"]
[null,"Number of smears performed for diagnosis or treatment monitoring",0,"Countries that are replacing microscopy with a rapid molecular test may anticipate fewer smears for diagnosis."]
[null,"Number of smears from culture",{"$f":"'Processing&solid-liquid culture'!F21*'Processing&solid-liquid culture'!F19","v":0}]
[null,"Current stock",0]
[null,"Number of ZN tests required for the period",{"$f":"SUM(C5:C6)","v":0}]
[null,"Number of ZN tests to be ordered",{"$f":"SUM(C5:C6)-C7","v":0}]
[]
[]
[null,"Test procurement","Kit","<=Choose here"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kit","Separated consumables"]
[]
[]
[]
[]
[]
["GDF code","Items","Unit ","Pack","Need per test","No. of packs ","Unit cost (US$)","Calculation details"]
[106522,"ZN stain solution, 1 L (strong carbol fuchsin 1% solution for ZN staining): 6, ZN decolourization solution, 1 L (ready-made decolourization solution of ZN-stained slides – 3.0% HCl/alcohol): 6, ZN counterstaining solution, 1 L (methylene blue 0.1%, counterstaining solution for ZN stain): 6 , 50 x 20 microscope slides: 1, 100x filter papers: 1, 10x pencils: 1, 2x waterproof marker pens: 1, 500x plastic bags W 200 mm x L 300 mm: 1, 1000x wooden applicator sticks: 2, 400x pairs of nitrile gloves (100 small, 200 medium, 100 large): 1, 30 x 150 carton of paper towels: 1, lens-cleaning tissue - 100 tissues: 1, immersion oil 100 mL: 1, denatured alcohol 96% 0.5 L: 5 and stable chlorine disinfectant 50 tabs: 5.","kit",1000,{"$f":"D22*1/1000","v":1},{"$f":"IF(W15=C12,ROUNDUP((E22/D22)*C9,0),0)","v":0},268,"1 kit for 1000 tests"]
[]
[]
[null,"Summary","Cost (US$)"]
[null,"Total cost of microscopy",{"$f":"F22*G22","v":0}]
[null,"Cost per smear",{"$f":"IF(C8=0,\"-\",C26/C8)","v":"-"}]
[]
[]
[]
["GDF code","Item","Units / pack","No. of packs","Unit cost (US$)","Budget","Calculation details"]
[106601,"Basic fuchsine, 100 g (bottle)",100,{"$f":"IF(X15=C12,ROUNDUP((C9*0.003)/C32,0),0)","v":0},154.25,{"$f":"D32*E32","v":0},"Carbol fuchsin: 5 mL per slide, includes +10%"]
[106602,"Methylene blue, 10 x 10 g (bottles)",100,{"$f":"IF(X15=C12,ROUNDUP((C9*0.02)/C33,0),0)","v":0},161.5,0,"Methylene blue: 5 mL per slide, includes +10%"]
[106599,"Phenol crystals, colourless, 500 g",500,{"$f":"IF(X15=C12,ROUNDUP((C9*0.03)/C34,0),0)","v":0},96.05,0,"includes +10%"]
[106597,"Ethanol, 99%, 1 L (bottle), for stain solutions",1000,{"$f":"IF(X15=C12,ROUNDUP((C9*0.55)/C35,0),0)","v":0},8.35,0,"includes +10%"]
[106597,"Ethanol, 99%, 1 L (bottle), for decolourization",1000,{"$f":"IF(X15=C12,ROUNDUP((C9*7.2)/C36,0),0)","v":0},8.35,0,"Decolourization: 7 mL per slide, includes +10%"]
[106603,"Hydrochloric acid, 1 L (bottle)",1000,{"$f":"IF(X15=C12,ROUNDUP((C9*0.8)/C37,0),0)","v":0},18.100000000000001,0,"Includes +10%"]
[null,"Total no. of reagents",null,{"$f":"SUM(F32:F37)","v":0}]
[null,"Reagent cost per smear",null,{"$f":"IF(C9=0,\"-\",D38/C9)","v":"-"}]
[]
[]
["GDF code","Item","Units / pack","No. of packs","Unit cost (US$)","Budget","Calculation details"]
[106655,"Wooden applicator sticks, 150 mm",1000,{"$f":"IF(X15=C12,ROUNDUP((C9*1.1)/C43,0),0)","v":0},2.5099999999999998,{"$f":"D43*E43","v":0},"includes +10%"]
[106609,"Microscope slides, lime-soda-glass, pack of 1000",1000,{"$f":"IF(X15=C12,ROUNDUP((C9*1.1)/C44,0),0)","v":0},10.4,0,"includes +10%"]
[106627,"Immersion oil, 100 mL",100,{"$f":"IF(X15=C12,ROUNDUP((C9*0.11)/C45,0),0)","v":0},9.24,0,"includes +10%"]
[106656,"Lens-cleaning tissue",150,{"$f":"IF(X15=C12,ROUNDUP((C9*0.33)/C46,0),0)","v":0},0.56999999999999995,0,"includes +10%"]
[106354,"Round filter paper, 150 mm",100,{"$f":"IF(X15=C12,ROUNDUP((C9*0.011)/C47,0),0)","v":0},24,0,"includes +10%"]
[106597,"Ethanol, 99%, 1 L (bottle), for spirit lamps",1000,{"$f":"IF(X15=C12,ROUNDUP((C9*0.001)/C48,0),0)","v":0},8.35,0]
[106355,"Marker pen (water-resistant)",1,{"$f":"IF(X15=C12,ROUNDUP((C9*0.001)/C49,0),0)","v":0},2.0499999999999998,0]
[106525,"Sputum containers, pack of 1000",1000,{"$f":"IF(X15=C12,ROUNDUP((C9*1.1)/C50,0),0)","v":0},83.3,0,"includes +10%"]
[null,"Total for reagents",null,{"$f":"SUMPRODUCT(D43:D50,E43:E50)","v":0}]
[null,"Reagent cost per smear",null,{"$f":"IF(C9=0,\"-\",D51/C9)","v":"-"}]
[]
[]
[null,"Summary","Cost (US$)"]
[null,"Total cost of microscopy",{"$f":"D51+D38","v":0}]
[null,"Cost per smear",{"$f":"IF(C9=0,\"-\",C56/C9)","v":"-"}]

{"sheet":"LED microscopy","index":8,"n_rows":56,"n_cols":24,"rows_kept":56,"cut":false,"hidden":false,"merged":[[3,1,3,2],[3,4,3,6],[0,0,0,10],[1,1,1,8],[4,3,4,6]]}
["Smear microscopy LED\n"]
[null,"Values in red should be entered or adjusted according to actual country data and practices, when possible."]
[]
[null,"Method 1: Consumption-based forecasting\nThe expected number of tests is based on the number of tests perfromed last year"]
[null,"Number of smears for diagnosis or treatment monitoring",0,"Countries that are replacing microscopy with a rapid molecular test may anticipate fewer smears for diagnosis."]
[null,"Number of smears from culture",0]
[null,"Current stock",0]
[null,"Number of LED tests required for the period",{"$f":"SUM(C5:C6)","v":0}]
[null,"Number of LED tests required for the period",{"$f":"SUM(C5:C6)-C7","v":0}]
[]
[]
[null,"Test procurement","Kit","<=Choose here"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kit","Separated consumables"]
[]
[]
[]
[]
[]
["GDF code","Item","Unit ","Pack","Need per test","No. of packs ","Unit cost (US$)","Calculation details"]
[106523,"Auramine stain solution, reagents (set of 3 components: 200 g - colourless phenol crystals C6H6O, 1 L - ethanol for stain solutions C2H6O and 5 g - auramine O C17H22ClN3 to produce auramine stain solution): 1 set, auramine decolourization solution, 1 L (ready-made decolourization solution 0.5% HCl/alcohol): 6, auramine counterstaining solution, 1 L (methylene blue 0.3%, counterstaining solution for auramine O stain) : 6, 50 x 20 microscope slides: 1, 100 x filter papers: 1, 10 x pencils: 1, 2 x waterproof marker pens: 1, 500 x plastic bags W 200 mm x L 300 mm: 1, 1000 x wooden applicator sticks: 1, 400 x pairs of nitrilegloves (100 small, 200 medium, 100 large): 1, 30 x 150 carton of paper towels: 1, lens-cleaning tissue - 100 tissues: 1, immersion oil 100 mL: 1, denatured alcohol 96% 0.5 L: 1, stable chlorine disinfectant 50 tablets: 5.","kit",1000,{"$f":"D22*1/1000","v":1},{"$f":"IF(W15=C12,ROUNDUP((E22/D22)*C9,0),0)","v":0},200.5,"1 kit for 1000 tests"]
[]
[]
[null,"Summary","Cost (US$)"]
[null,"Total cost of microscopy",{"$f":"F22*G22","v":0}]
[null,"Cost per smear",{"$f":"IF(C9=0,\"-\",(C26/C9))","v":"-"}]
[]
[]
[]
["GDF code","Item","Units / pack","No. of packs","Unit cost (US$)","Budget","Calculation details"]
[106602,"Methylene blue, 10 x 10 g (bottles)",100,{"$f":"IF(X15=C12,ROUNDUP((C9*0.02)/C32,0),0)","v":0},161.5,{"$f":"D32*E32","v":0},"Methylene blue: 5 mL per slide, includes +10%"]
[106599,"Phenol crystals colourless, 500 g",500,{"$f":"IF(X15=C12,ROUNDUP((C9*0.03)/C33,0),0)","v":0},96.05,{"$f":"D33*E33","v":0},"includes +10%"]
[106276,"Auramine O, powder, 25 g",25,{"$f":"IF(X15=C12,ROUNDUP((C9*0.003)/C34,0),0)","v":0},38.4,0,"includes +10%"]
[106597,"Ethanol, 99%, 1 L (bottle), for decolourization",1000,{"$f":"IF(X15=C12,ROUNDUP((C9*0.55)/C35,0),0)","v":0},8.35,0,"Decolourization: 7 mL per slide, includes +10%"]
[106603,"Hydrochloric acid, 1 L (bottle)",1000,{"$f":"IF(X15=C12,ROUNDUP((C9*0.8)/C36,0),0)","v":0},18.100000000000001,{"$f":"D36*E36","v":0},"includes +10%"]
[null,"Total for reagents",null,{"$f":"SUM(F32:F36)","v":0}]
[null,"Reagent cost per smear",null,{"$f":"IF(C9=0,\"-\",D37/C9)","v":"-"}]
[]
[]
["GDF code","Item","Unit / pack","No. of packs","Unit cost (US$)","Budget","Calculation details"]
[106655,"Wooden applicator sticks, 150 mm",1000,{"$f":"IF(X15=C12,ROUNDUP((C9*1.1)/C42,0),0)","v":0},2.5099999999999998,{"$f":"D42*E42","v":0},"includes +10%"]
[106609,"Microscope slides, lime-soda-glass, pack of 1000",1000,{"$f":"IF(X15=C12,ROUNDUP((C9*1.1)/C43,0),0)","v":0},10.4,0,"includes +10%"]
[106627,"Immersion oil, 100 mL",100,{"$f":"IF(X15=C12,ROUNDUP((C9*0.11)/C44,0),0)","v":0},9.24,0,"includes +10%"]
[106656,"Lens-cleaning tissue",150,{"$f":"IF(X15=C12,ROUNDUP((C9*0.33)/C45,0),0)","v":0},0.56999999999999995,0,"includes +10%"]
[106354,"Round filter paper, 150 mm",100,{"$f":"IF(X15=C12,ROUNDUP((C9*0.011)/C46,0),0)","v":0},24,0,"includes +10%"]
[106597,"Ethanol, 99%, 1 L (bottle), for spirit lamps",1000,{"$f":"IF(X15=C12,ROUNDUP((C9*0.001)/C47,0),0)","v":0},8.35,0]
[106355,"Marker pen (water-resistant)",1,{"$f":"IF(X15=C12,ROUNDUP((C9*0.001)/C48,0),0)","v":0},2.0499999999999998,0]
[106525,"Sputum containers, pack of 1000",1000,{"$f":"IF(X15=C12,ROUNDUP((C9*1.1)/C49,0),0)","v":0},83.3,0,"includes +10%"]
[null,"Total for reagents",null,{"$f":"SUMPRODUCT(D42:D49,E42:E49)","v":0}]
[null,"Reagent cost per smear",null,{"$f":"IF(C9=0,\"-\",D50/C9)","v":"-"}]
[]
[]
[null,"Summary","Costs (US$)"]
[null,"Total cost of microscopy",{"$f":"D50+D37","v":0}]
[null,"Cost per smear",{"$f":"IF(C9=0,\"-\",(C55/C9))","v":"-"}]

{"sheet":"Xpert MTB XDR","index":9,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[[23,2,23,3],[0,0,0,9],[1,1,1,9],[2,1,2,2],[2,4,2,6],[6,4,6,5]]}
["Xpert MTB/XDR\nTwo methods are proposed for calculating the expected number of tests to be performed during the period."]
[null,"Values in red should be entered or adjusted according to actual country data and practices, when possible."]
[null,"Method 1: Consumption-based forecasting\nThe expected number of tests is based on the number of tests performed last year",null,null,"Method 2: Morbidity-based forecasting\nThe estimated number of tests calculated is based on epidemiological data (notifications) and planned algorithms. The calculated sum is the target to be reached when algorithms are implemented according to the indicated coverage and assumptions."]
[null,"Average number of Xpert MTB/XDR tests performed per month ",0,null,"Patient population","Coverage of testing","Number of Xpert MTB/XDR required for the period"]
[null,"Number of Xpert MTB/XDR tests required for the period ",{"$f":"C4*Months","v":0},null,"Anticipated number of RR/MDR-TB cases to be detected in the year",0,{"$f":"Epidemiology!$B$14*F5","v":0}]
[null,null,null,null,"People with detected INH mono-resistance (to test for fluoroquinolone resistance)",0,{"$f":"(Epidemiology!$E$7+Epidemiology!$B$8)*F6*Epidemiology!B16","v":0}]
[null,null,null,null,"Total number of Xpert MTB/XDR required for the period",null,{"$f":"SUM(G5:G6)","v":0}]
[]
[]
[]
[]
[null,"Number of Xpert MTB/XDR cartridges required for the period (with forecasting method 1 or 2 or a value in between)",0]
[null,"Percentage of invalid, error, no result",0]
[null,"Current stock",0]
[null,"Total number of Xpert MTB/XDR cartridges required for the period",{"$f":"((C12*C13)+C12)","v":0}]
[null,"Total number of Xpert MTB/XDR cartridges to be ordered",{"$f":"((C12*C13)+C12)-C14","v":0}]
[]
["GDF code","Item","Units / pack","No. of packs to be ordered","Unit cost (US$)","Calculation details"]
[null,"Xpert MTB/XDR cartridges",10,{"$f":"ROUNDUP((C16/C19),0)","v":0},198]
[106340,"Sterile plastic centrifuge tubes, 50 mL",500,0,45,"If you use normal sputum containers, set \"0\" on No. of packs to be ordered"]
[106525,"Sputum containers, pack of 1000",1000,{"$f":"ROUNDUP(((C16*1.1)/C21),0)","v":0},83.3]
[]
[]
[null,null,"Summary",null,"Cost (US$)"]
[null,null,"Total for Xpert MTB/XDR",null,{"$f":"SUMPRODUCT(D19:D21*E19:E21)","v":0}]
[null,null,"Total per Xpert MTB/XDR",null,{"$f":"IF(C16=0,\"-\",(E25/C16))","v":"-"}]

{"sheet":"LPA 1st line","index":10,"n_rows":57,"n_cols":25,"rows_kept":57,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,1,1,9],[26,2,26,3],[17,2,17,3],[18,2,18,3],[12,4,12,5],[14,4,14,5],[17,4,17,5],[18,4,18,5],[15,2,15,3],[15,4,15,5],[13,2,13,3],[19,2,19,3],[19,5,23,5],[20,2,20,3],[25,2,25,3],[54,2,54,3],[20,21,20,27],[21,2,21,3],[23,2,23,3],[16,4,16,5],[22,2,22,3],[24,2,24,3],[14,2,14,3],[16,2,16,3],[30,7,31,7],[2,1,2,2],[2,4,2,6],[5,4,5,5],[13,4,13,5],[12,2,12,3]]}
["LPA 1st line\nTwo methods are proposed for calculating the expected number of tests to be performed during the period."]
[null,"Values in red should be entered or adjusted according to actual country data and practices, when possible."]
[null,"Method 1: Consumption-based forecasting\nThe expected number of tests is based on number of tests perfromed last year",null,null,"Method 2: Morbidity-based forecasting\nThe estimated number of tests calculated is based on epidemiological data (notifications) and planned algorithms. The calculated sum is the target to be reached when algorithms are implemented according to the indicated coverage and assumptions."]
[null,"Average number of LPA 1st-line tests performed per month ",0,null,"Patient population","Coverage of testing","Number of LPA 1st-line tests required for the period"]
[null,"Number of LPA 1st-line tests required for the period ",{"$f":"C4*Months","v":0},null,"New smear-positive TB cases receiving the test for rifampicin and isoniazid testing purposes (excluding those receiving it as the initial diagnostic test",0,{"$f":"ROUND(Epidemiology!C7-((Epidemiology!B9*Epidemiology!B10)+(Epidemiology!E7+Epidemiology!B8+Epidemiology!B14)+(Epidemiology!E11*Epidemiology!E10*Epidemiology!C4)+(Epidemiology!C7*Epidemiology!B10)),-2)*F5","v":0}]
[null,null,null,null,"Total number of LPA 1st-line tests required for the period",null,{"$f":"SUM(G5:G5)","v":0}]
[]
[]
[]
[]
[null,"LPA 1st-line test used","Geno Type MTBDRplus","<=Choose here"]
[]
[null,"Number of batches used per week",0,null,"Enter the appropriate number based on past consumption. The default number is based on optimal use of the test"]
[null,"Number of specimens per batch",0,null,"Enter the appropriate number based on past consumption. The default number is based on optimal use of the test"]
[null,"Number of controls per batch",0,null,"Enter the appropriate number based on past consumption. The default number is based on optimal use of the test"]
[null,"Number of LPA 1st-line tests for the period\n(with forecasting method 1 or 2 or a value in between)",0]
[null,"Average size of a batch",{"$f":"C14+C15","v":0}]
[null,"Number of batches required for the period",{"$f":"IF(C14=0,0,C16/C14)","v":0}]
[null,"Number of tests to be performed (specimens plus controls)",{"$f":"IF(C17=0,0,C18*C17)","v":0}]
[null,"Estimated repetitions (%)",0]
[null,"Number of extra tests per batch for pipetting error",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Do not delete"]
[null,"LPA equipment used in the laboratory","GT-BLOT 48",null,"<=Choose here",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GT-BLOT 48","TWINCUBATOR"]
[null,"DNA extraction with or without Genolyse","With Genolyse",null,"<=Choose here"]
[null,"For DNA extraction  ","Standard reaction tubes,  2 ml",null,"<=Choose here",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standard reaction tubes,  2 ml","Standard reaction tubes,  1,5ml"]
[null,"Current stock",0]
[null,"Total number of tests to be performed during the period",{"$f":"ROUNDUP(C19+(C19*repet)+C21*C18,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MULTIBLOT NS-4800"]
[null,"Total number of test to be ordered",{"$f":"IF(C25=0,(ROUNDUP(C19+(C19*repet)+C21*C18,0)),(ROUNDUP(C19+(C19*repet)+C21*C18,0))-C25)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Geno Type MTBDRplus"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Genoscholar NTM+MDRTB II"]
[null,"GDF code","Item","Units / pack","No. of packs","Unit cost (US$)","Calculation details","Option"]
[null,106682,"Genoscholar NTM+MDRTB II",20,{"$f":"IF(C11=W28,ROUNDUP(C27/unit_pack,0),0)","v":0},320,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"With Genolyse","Without Genolyse"]
[null,106512,"Geno Type MTBDRplus (96 tests/kit), Version 2.0 (30496A)   ",96,{"$f":"IF(C11=W27,ROUNDUP(C27/unit_pack,0),0)","v":0},720,null,"Two methods : 1 vial per batch or molecular-grade water is aliquoted \nChoose from drop-down list"]
[null,106477,"GenoLyse (96 tests), Version 1.0 (51610)",96,{"$f":"IF($C$23=$W$30,ROUNDUP(C27/D32,0),0)","v":0},50]
[null,106254,"Molecular grade water - 10 x 1.7 mL",17,{"$f":"IF(H33=X33,ROUNDUP(C18*0.505/unit_pack,0),IF(C14*0.505<=1.8,ROUNDUP(C18/10,0),ROUNDUP(C14*0.505,0)))","v":0},201.85,"Volume required is 505 µL per batch - 1 vial per batch or aliquot                                                                Choose here =>","1 vial per Batch","<=Choose here",null,null,null,null,null,null,null,null,null,null,null,null,null,"1 vial per Batch","Aliquot"]
[null,106385,"PCR tubes, 0.2 mL with attached caps, sterile, DNAse- and RNAse-free, 1000 per pack",1000,{"$f":"ROUNDUP((kit_ordered*D31*1.05)/unit_pack,0)","v":0},45.8,"1 tube per test + 5% extra"]
[null,106422,"Microcentrifuge tubes, 2 mL",500,{"$f":"IF(C24=W24,ROUNDUP(kit_ordered*D31*2/unit_pack,0),0)","v":0},49.55,"2 tubes per test + 5% extra"]
[null,106421,"Microcentrifuge tubes, 1.5 mL",{"$f":"IF(B36=106350,1000,500)","v":500},{"$f":"IF(C24=X24,ROUNDUP(kit_ordered*D31*2/unit_pack,0),0)","v":0},91.95,"2 tubes per test + 5% extra",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standard reaction tubes,  1.5 ml,","Standard reaction tubes,  2 ml, "]
[null,106383,"Sterile cryovials, 2 mL, single handed",1000,{"$f":"ROUNDUP(kit_ordered*D31/unit_pack,0)","v":0},261.39999999999998," Cryo-vials are necessary for storage , 1 tube per test + 5% extra",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C27+(C27*5)/100","v":0}]
[null,106554,"Sterile filter tips,  0.1–10 µL",960,{"$f":"ROUNDUP((kit_ordered*D31*2.05)/unit_pack,0)","v":0},115.7,"2 tips per tests + 5% extra to add supernatant to PCR tubes and n x 5 μL DNA"]
[null,106389,"Sterile filter tips, 20–200 µL",960,{"$f":"ROUNDUP((kit_ordered*D31*(2+1)+C18*(3+IF($C$22=$W$22,0,2)))*1.05/unit_pack,0)","v":0},61,"2 tips per test for DNA extraction, 2 tips per batch for amplification, 1 tip per batch to add DEN -  1 tip per test to add DNA/amplicon - if twincubator used, 2 tips for SUB/CONJ  + 5% extra"]
[null,106390,"Sterile filter tips, 100–1000 µL",960,{"$f":"ROUNDUP(kit_ordered*D31*1.05/unit_pack,0)","v":0},88.5,"1 tip per batch for mastermix + 5% extra"]
[null,106412,"Long 1-mL tips with filter ",800,{"$f":"ROUNDUP((kit_ordered*D31*2+IF($C$22=$W$22,0,kit_ordered*D31*2+IF(H42=X42,0,C18*8)))*1.05/unit_pack,0)","v":0},90,"2 tips to add/discard decontaminated specimen  - only for twincubator: 2 tips per batch  to add hybridization and STR + 8 tips per batch to add  rinse (3), water (3), SUB(1) CONJ (1)","Select below: whether you use Combitips or not"]
[null,106398,"Dispenser tips, 12.5 mL ",100,{"$f":"IF(AND(H42=X42,$C$22=$X$22),ROUNDUP(C18*8*1.05/unit_pack,0),0)","v":0},50,"Alternative to long 1-mL tips - 8 tips per batch to add RINS (3), WATER (3), SUB (1) CONJ (1) + 5% extra         ","Combitips is used","<=Choose here",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Combitips is used","No Combitips"]
[null,106434,"Non-sterile Pasteur pipettes, 3 mL ",500,{"$f":"ROUNDUP((kit_ordered*$D$31*(2)+C18*5)*1.05/unit_pack,0)","v":0},9.9,"2 pipettes per sample to remove hybridization and STR and 5 pipettes par batch to remove RINS, WATER, SUB and CONJ + 5% extra"]
[null,106556,"Sterile plastic laboratory forceps ",50,{"$f":"ROUNDUP(C18*2/unit_pack,0)","v":0},7.45,"2 per batch"]
[null,106355,"Permanent marker",1,{"$f":"ROUNDUP(kit_ordered/3/unit_pack,0)","v":0},2.0499999999999998,"1 pen for 3 kits"]
[null,106384,"Sterile plastic centrifuge tubes, 15 mL",500,{"$f":"ROUNDUP(C18*4/unit_pack,0)","v":0},48.95,"4 tubes per batch (diluting CON and SUB + HYB + STR)"]
[null,106340,"Sterile plastic centrifuge tubes, 50 mL",500,{"$f":"ROUNDUP(C18*IF($C$22=$W$22,5,3)/unit_pack,0)","v":0},45,"3 tubes per batch - 5 tubes if GT Blot 48 (decontamination)"]
[null,106444,"Plastic bags, 30 L",200,{"$f":"ROUNDUP(Months*22*4/unit_pack,0)","v":0},98.6,"4 per working day"]
[null,106415,"Square filter paper, 580 mm",100,{"$f":"ROUNDUP(Months*22*8/unit_pack,0)","v":0},111.4,"8 per working day"]
[null,106439,"GT-Blot 48 reagent set",1,{"$f":"IF($C$22=$W$22,ROUNDUP(kit_ordered/3/unit_pack,0),0)","v":0},0,"1 kit for 3 LPA kit if GT BLOT-48"]
[null,106438,"GT-Blot 48 tray for 96 strips (black)",1,{"$f":"IF($C$22=$W$22,ROUNDUP(C18/10*1.2/unit_pack,0),0)","v":0},2.9,"1 tray for 10 batches + 20%"]
[null,106755,"Paper towels",200,{"$f":"ROUNDUP(12*22*40/unit_pack,0)","v":53},1.45,"40 per day"]
[null,106333,"Ethanol / Isopropanol - 5 L",5,{"$f":"ROUNDUP(Months*4.33*1/unit_pack,0)","v":0},32.15,"1 L per week"]
[]
[null,null,"Summary",null,"Cost (US$)"]
[null,null,"Total for LPA 1st-line test, MTBDR plus V2",null,{"$f":"SUMPRODUCT(E31:E53*F31:F53)","v":76.849999999999994}]
[null,null,"Total per LPA 1st-line test, MTBDR plus V2",null,{"$f":"IF(C27=0,\"-\",E56/C27)","v":"-"}]

{"sheet":"LPA 2nd line","index":11,"n_rows":56,"n_cols":26,"rows_kept":56,"cut":false,"hidden":false,"merged":[[25,2,25,3],[26,2,26,3],[29,7,30,7],[22,2,22,3],[19,2,19,3],[19,5,23,5],[20,2,20,3],[24,2,24,3],[20,22,20,28],[21,2,21,3],[23,2,23,3],[16,2,16,3],[16,4,16,5],[17,2,17,3],[17,4,17,5],[18,2,18,3],[18,4,18,5],[13,2,13,3],[13,4,13,5],[14,2,14,3],[14,4,14,5],[15,2,15,3],[15,4,15,5],[12,2,12,3],[12,4,12,5],[0,1,0,6],[1,1,1,6],[2,1,2,2],[2,4,2,6],[6,4,6,5]]}
[null,"LPA 2nd line\nTwo methods are proposed for calculating the expected number of tests to be performed during the period."]
[null,"Values in red should be entered or adjusted according to actual country data and practices, when possible."]
[null,"Method 1: Consumption-based forecasting\nThe expected number of tests is based on the average daily use per instrument module.",null,null,"Method 2: Morbidity-based forecasting\nThe estimated number of tests calculated is based on epidemiological data (notifications) and planned algorithms. The calculated sum is the target to be reached when algorithms are implemented according to the indicated coverage and assumptions."]
[null,"Average number of LPA 2nd-line tests performed per month ",0,null,"Patient population","Coverage of testing","Number of LPA 1st-line tests for the period"]
[null,"Number of LPA 2nd-line tests required for the period ",{"$f":"C4*Months","v":0},null,"Anticipated number of RR/MDR-TB cases to be detected in the year",0,{"$f":"Epidemiology!$B$14*F5","v":0}]
[null,null,null,null,"People with detected INH mono-resistance (to test for fluoroquinolone resistance)",0,{"$f":"(Epidemiology!$E$7+Epidemiology!$B$8)*F6*Epidemiology!B16","v":0}]
[null,null,null,null,"Total number of LPA 2nd-line tests required for the period",null,{"$f":"SUM(G5:G6)","v":0}]
[]
[]
[]
[]
[]
[null,"Number of batches per week",0,null,"Enter the appropriate number based on past consumption. The default number is based on optimal use of the test."]
[null,"Number of specimens in one batch",0,null,"Enter the appropriate number based on past consumption. The default number is based on optimal use of the test."]
[null,"Number of controls per batch",0,null,"Enter the appropriate number based on past consumption. The default number is based on optimal use of the test."]
[null,"Number of LPA 2nd-line tests required for the period (with forecasting method 1 or 2 or a value in between)",0]
[null,"Average number of specimens per batch",{"$f":"C14+C15","v":0}]
[null,"Number of batches for the period",{"$f":"IF(C14=0,0,C16/C14)","v":0}]
[null,"Number of tests (specimens plus controls)",{"$f":"C18*C17","v":0}]
[null,"Estimated repetitions (%)",0]
[null,"Number of extra tests per batch for pipetting error",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Do not delete"]
[null,"LPA equipment used in the laboratory","GT-BLOT 48",null,"<=Choose here",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GT-BLOT 48","TWINCUBATOR"]
[null,"DNA extraction with or without Genolyse","With Genolyse",null,"<=Choose here"]
[null,"For DNA extraction  ","Standard reaction tubes,  2 ml",null,"<=Choose here",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standard reaction tubes,  2 ml","Standard reaction tubes,  1,5ml"]
[null,"Current stock"]
[null,"Total number of tests to be performed during the period",{"$f":"ROUNDUP(C19+(C19*repet)+C21*C18,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"With Genolyse","Without Genolyse"]
[null,"Total number of test to be ordered",{"$f":"IF(C25=0,(ROUNDUP(C19+(C19*repet)+C21*C18,0)),((ROUNDUP(C19+(C19*repet)+C21*C18,0))-C25))","v":0}]
[]
[null,"GDF code","Item","Units / pack","No. of packs","Unit cost (US$)","Calculation details","Options"]
[null,106513,"Geno Type MTBDRsl (96 tests/kit), Version 2.0 (30496A)   ",96,{"$f":"ROUNDUP(C27/unit_pack,0)","v":0},720,null,"Two methods : 1 vial per batch or molecular-grade water is aliquoted \nChoose from the drop-down list"]
[null,106477,"GenoLyse (96 tests), Version 1.0 (51610)",96,{"$f":"IF($C$23=$X$26,ROUNDUP(C27/D31,0),0)","v":0},50]
[null,106254,"Molecular-grade water - 10 x 1.7 mL",17,{"$f":"IF(H32=Y32,ROUNDUP(C18*0.505/unit_pack,0),IF(C14*0.505<=1.8,ROUNDUP(C18/10,0),ROUNDUP(C14*0.505,0)))","v":0},201.85,"Volume required is 505 µL per batch - 1 vial per batch or aliquot                                                                Choose here =>","Aliquot","<=Choose here",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1 vial per Batch","Aliquot"]
[null,106385,"PCR tubes, 0.2 mL with attached caps, sterile, DNAse- RNAse-free, 1000 per pack",1000,{"$f":"ROUNDUP((kit_ordered*D30*1.05)/unit_pack,0)","v":0},45.8,"1 tube per test + 5%"]
[null,106422,"Microcentrifuge tubes, 2 mL",500,{"$f":"IF(C24=X24,ROUNDUP(kit_ordered*D30*2/unit_pack,0),0)","v":0},49.55,"2 tubes per test + 5% extra"]
[null,106421,"Microcentrifuge tubes, 1.5 mL",{"$f":"IF(B35=106350,1000,500)","v":500},{"$f":"IF(C24=Y24,ROUNDUP(kit_ordered*D30*2/unit_pack,0),0)","v":0},91.95,"2 tubes per test + 5% extra",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standard reaction tubes,  1.5 ml,","Standard reaction tubes,  2 ml, "]
[null,106383,"Sterile cryovials, 2 mL, single handed",1000,{"$f":"IF(H36=Z36,0,ROUNDUP(kit_ordered*D30/unit_pack,0))","v":0},261.39999999999998," Cryo-vials are required for storage, 1 tube per test + 5% extra",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"total_test+(total_test*5)/100","v":0}]
[null,106554,"Sterile filter tips, 0.1–10 µL",960,{"$f":"ROUNDUP(E35*D35/D37,0)","v":0},115.7,"1 tip par vial"]
[null,106389,"Sterile filter tips, 20–200 µL",960,{"$f":"ROUNDUP((kit_ordered*D30*2.05)/unit_pack,0)","v":0},61,"2 tips per test + 5% extra to add supernatent to PCR tubes and n x 5 μL DNA"]
[null,106390,"Sterile filter tips, 100–1000 µL",960,{"$f":"ROUNDUP((kit_ordered*D30*(2+1)+C18*(3+IF($C$22=$X$22,0,2)))*1.05/unit_pack,0)","v":0},88.5,"2 tips per test for DNA extraction, 2 tips per batch for amplification, 1 tip per batch to add DEN, 1 tip per test to add DNA/amplicon; if using twincubator, 2 tips for SUB/CONJ  + 5% extra"]
[null,106412,"Long 1-mL tips with filter ",800,{"$f":"ROUNDUP(kit_ordered*D30*1.05/unit_pack,0)","v":0},90,"1 tip per batch for mastermix + 5% extra"]
[null,106398,"Dispenser tips, 12.5 mL ",100,{"$f":"ROUNDUP((kit_ordered*D30*2+IF($C$22=$X$22,0,kit_ordered*D30*2+IF(H42=Y42,0,C18*8)))*1.05/unit_pack,0)","v":0},50,"2 tips to add or discard decontaminated specimen; only for twincubator: 2 tips per batch  to add hybridization and STR + 8 tips per batch to add RINS (3), WATER (3), SUB (1) CONJ (1)","Select below whether you use Combitips or not"]
[null,106434,"Non-sterile Pasteur pipettes, 3 mL",500,{"$f":"IF(AND(H42=Y42,$C$22=$Y$22),ROUNDUP(C18*8*1.05/unit_pack,0),0)","v":0},9.9,"Alternative to long 1-mL tips - 8 tips per batch to add  RINS (3), WATER (3), SUB (1) CONJ (1) + 5% extra         ","No Combitips",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Combitips is used","No Combitips"]
[null,106556,"Sterile plastic laboratory forceps ",50,{"$f":"ROUNDUP((kit_ordered*$D$30*(2)+C18*5)*1.05/unit_pack,0)","v":0},7.45,"2 pipettes per sample to remove hybridization and STR, and 5 pipettes par batch to remove RINS, WATER, SUB, CONJ + 5% extra"]
[null,106355,"Permanent marker",1,{"$f":"ROUNDUP(C18*2/unit_pack,0)","v":0},2.0499999999999998,"2 per batch"]
[null,106384,"Sterile plastic centrifuge tubes, 15 mL",500,{"$f":"ROUNDUP(kit_ordered/3/unit_pack,0)","v":0},48.95,"1 pen for 3 kits"]
[null,106340,"Sterile plastic centrifuge tubes, 50 mL",500,{"$f":"ROUNDUP(C18*4/unit_pack,0)","v":0},45,"4 tubes per batch (for diluting CON and SUB + HYB + STR)"]
[null,106444,"Plastic bags, 30 L",200,{"$f":"ROUNDUP(C18*IF($C$22=$X$22,5,3)/unit_pack,0)","v":0},98.6,"3 tubes per batch - 5 tubes if GT Blot 48 (decontamination)"]
[null,106415,"Square filter paper, 580 mm",100,{"$f":"ROUNDUP(Months*22*4/unit_pack,0)","v":0},111.4,"4 per working day"]
[null,106439,"GT-Blot 48 reagent set",1,{"$f":"ROUNDUP(Months*22*8/unit_pack,0)","v":0},0,"8 per working day"]
[null,106438,"GT-Blot 48 tray for 96 strips (black)",1,{"$f":"IF($C$22=$X$22,ROUNDUP(kit_ordered/3/unit_pack,0),0)","v":0},2.9,"1 kit for 3 LPA kits if GT BLOT-48"]
[null,106755,"Paper towels",200,{"$f":"IF($C$22=$X$22,ROUNDUP(C18/10*1.2/unit_pack,0),0)","v":0},1.45,"1 tray for 10 batches + 20%"]
[null,106333,"Ethanol / isopropanol, 5 L",5,{"$f":"ROUNDUP(Months*4.33*1/unit_pack,0)","v":0},32.15,"40 per day"]
[]
[null,null,"Summary",null,"Cost (US$)"]
[null,null,"Total  for LPA 1st line, MTBDRplus V2",null,{"$f":"SUMPRODUCT(E30:E52*F30:F52)","v":0}]
[null,null,"Total per LPA 1st Line, MTBDRplus V2",null,{"$f":"IF(C27=0,\"-\",E55/C27)","v":"-"}]

{"sheet":"MAX MDR-TB assay","index":12,"n_rows":43,"n_cols":21,"rows_kept":43,"cut":false,"hidden":false,"merged":[[14,2,14,3],[14,4,14,5],[0,0,0,8],[1,1,1,8],[2,1,2,2],[2,4,2,6],[9,4,9,5],[15,2,15,3],[15,4,15,5],[16,2,16,3],[16,4,16,5],[17,2,17,3],[17,4,17,5],[21,20,21,26],[23,2,23,3],[40,2,40,3],[18,2,18,3],[18,4,18,5],[19,2,19,3],[19,4,19,5],[20,2,20,3],[20,5,21,5],[21,2,21,3],[27,6,28,6],[22,2,22,3],[24,2,24,3]]}
["MAX MDR-TB assay \nTwo methods are proposed for calculating the expected number of tests to be performed during the period."]
[null,"Values in red should be entered or adjusted according to actual country data and practices, when possible."]
[null,"Method 1: Consumption-based forecasting\nThe expected number of tests is based on the number of tests performed last year",null,null,"Method 2: Morbidity-based forecasting\nThe estimated number of tests calculated is based on epidemiological data (notifications) and planned algorithms. The calculated sum is the target to be reached when algorithms are implemented according to the indicated coverage and assumptions."]
[null,"Average number of MAX MDR-TB tests performed per month ",0,null,"Patient population","Coverage of testing","Number of MAX MDR-TB tests required for the period"]
[null,"Number of MAX MDR-TB tests required for the period ",{"$f":"C4*Months","v":0},null,"People living with HIV (PLHIV) with signs and symptoms of TB",0,{"$f":"ROUND((F5*Epidemiology!B12*Epidemiology!B20*Epidemiology!E20),-2)","v":0}]
[null,null,null,null,"Children with signs and symptoms of TB",0,{"$f":"ROUND(F6*Epidemiology!B9*Epidemiology!B10*Epidemiology!B26, -2)","v":0}]
[null,null,null,null,"People at risk of drug-resistant TB",0,{"$f":"ROUND(F7*(Epidemiology!E7*Epidemiology!B17)+Epidemiology!B8+(Epidemiology!B14*Epidemiology!E17), -2)","v":0}]
[null,null,null,null,"Previously untreated HIV-negative adults with signs and symptoms of TB",0,{"$f":"ROUND(F8*Epidemiology!E11*Epidemiology!E10*Epidemiology!C4*Epidemiology!B18,-2)","v":0}]
[null,null,null,null,"New smear-positive TB cases receiving Xpert for rifampicin testing purposes (excluding those receiving it as the initial diagnostic test)",0,{"$f":"ROUND(Epidemiology!C7-((Epidemiology!B9*Epidemiology!B10)+(Epidemiology!E7+Epidemiology!B8+Epidemiology!B14)+(Epidemiology!E11*Epidemiology!E10*Epidemiology!C4)+(Epidemiology!C7*Epidemiology!B10)),-2)*F9","v":0}]
[null,null,null,null,"Total number of MAX MDR-TB kits required for the period",null,{"$f":"SUM(G5:G9)","v":0}]
[]
[]
[]
[]
[null,"Number of specimens per batch",0]
[null,"Number of controls per batch",0]
[null,"Number of MAX MDR-TB tests required for the period (with forecasting method 1 or 2 or a value in between)",0]
[null,"Average size of a batch",{"$f":"C15+C16","v":0}]
[null,"Number of batches required for the period",{"$f":"IF(C15=0,\"0\",C17/C15)","v":"0"}]
[null,"Number of tests (specimens plus controls)",{"$f":"IF(C18=0,\"0\",C19*C18)","v":"0"}]
[null,"Estimated repetitions (%)",0]
[null,"Number of extra tests per batch for pipetting error",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Do not delete"]
[null,"Current stock",0]
[null,"Total number of tests to be performed during the period",{"$f":"ROUNDUP(C20+(C20*repet)+C22*C19,0)","v":0}]
[null,"Total number of tests to be ordered",{"$f":"IF(C23=0,(ROUNDUP(C20+(C20*repet)+C22*C19,0)),(ROUNDUP(C20+(C20*repet)+C22*C19,0)-C23))","v":0}]
[]
[null,"GDF code","Item","Units / pack","No. of packs","Unit cost (US$)","Calculation details"]
[null,null,"BD MAX MDR-TB kit",24,{"$f":"ROUNDUP(C25/unit_pack,0)","v":0},0,"Enter unit cost based on current procurement mechanism"]
[null,null,"BD MAX STR kit",24,{"$f":"ROUNDUP(C25/unit_pack,0)","v":0},0]
[null,106384,"Sterile plastic centrifuge tubes, 15 mL",500,{"$f":"ROUNDUP(kit_ordered*D28*1.05/unit_pack,0)","v":0},48.95,"1 tube per test + 5%"]
[null,106422,"Microcentrifuge tubes, 2 mL",500,{"$f":"ROUNDUP(C19*2*1.05/unit_pack,0)","v":0},49.55,"2 tubes per batch + 5% extra"]
[null,106554,"Sterile filter tips,  0.1–10 µL",960,{"$f":"ROUNDUP((kit_ordered*D28*4*1.05)/unit_pack,0)","v":0},115.7,"4 tips per tests + 5% extra "]
[null,106389,"Sterile filter tips, 20–200 µL",960,{"$f":"ROUNDUP((kit_ordered*D28*4*1.05)/unit_pack,0)","v":0},61,"4 tips per test + 5% extra"]
[null,106390,"Sterile filter tips, 100–1000 µL",960,{"$f":"ROUNDUP((kit_ordered*D28*4*1.05)/unit_pack,0)","v":0},88.5,"4 tips per test + 5% extra"]
[null,106444,"Plastic bags, 30 L",200,{"$f":"ROUNDUP(Months*22*4/unit_pack,0)","v":0},98.6,"4 per working day"]
[null,106415,"Square filter paper, 580 mm",100,{"$f":"ROUNDUP(Months*22*8/unit_pack,0)","v":0},111.4,"8 per working day"]
[null,106755,"Paper towels",200,{"$f":"ROUNDUP(12*22*40/unit_pack,0)","v":53},1.45,"40 per day"]
[null,106333,"Ethanol / isopropanol, 5 L",5,{"$f":"ROUNDUP(Months*4.33*1/unit_pack,0)","v":0},32.15,"1 L per week"]
[]
[]
[null,null,"Summary",null,"Cost (US$)"]
[null,null,"Total for MAX MDR-TB tests",null,{"$f":"SUMPRODUCT(E28:E38*F28:F38)","v":76.849999999999994}]
[null,null,"Total per MAX MDR-TB test",null,{"$f":"IF(total_test=0,\"-\",(E42/total_test))","v":"-"}]

{"sheet":"FluoroType MTBDR VER 2.0","index":13,"n_rows":45,"n_cols":22,"rows_kept":45,"cut":false,"hidden":false,"merged":[[14,2,14,3],[14,4,14,5],[0,0,0,9],[1,1,1,9],[2,1,2,2],[2,4,2,6],[15,2,15,3],[15,4,15,5],[16,2,16,3],[16,4,16,5],[17,2,17,3],[17,4,17,5],[21,21,21,27],[23,2,23,3],[42,2,42,3],[18,2,18,3],[18,4,18,5],[19,2,19,3],[19,4,19,5],[20,2,20,3],[20,5,21,5],[21,2,21,3],[25,2,25,3],[29,6,31,6],[22,2,22,3],[24,2,24,3]]}
["FluoroType® MTBDR VER 2.0 assays\nTwo methods are proposed for calculating the expected number of tests to be performed during the period."]
[null,"Values in red should be entered or adjusted according to actual country data and practices, when possible."]
[null,"Method 1: Consumption-based forecasting\nThe expected number of tests is based on the number of tests perfromed last year.",null,null,"Method 2: Morbidity-based forecasting\nThe estimated number of tests calculated is based on epidemiological data (notifications) and planned algorithms. The calculated sum is the target to be reached when algorithms are implemented according to the indicated coverage and assumptions."]
[null,"Average number of FluoroType® MTBDR VER 2.0 tests performed per month ",0,null,"Patient population","Coverage of testing","Number of FluoroType® MTBDR VER 2.0 required for the period"]
[null,"Number of FluoroType® MTBDR VER 2.0 tests required for the period ",{"$f":"C4*Months","v":0},null,"People living with HIV (PLHIV) with signs and symptoms of TB",0,{"$f":"ROUND((F5*Epidemiology!B12*Epidemiology!B20*Epidemiology!E20),-2)","v":0}]
[null,null,null,null,"Children with signs and symptoms of TB",0,{"$f":"ROUND(F6*Epidemiology!B9*Epidemiology!B10*Epidemiology!B26, -2)","v":0}]
[null,null,null,null,"People at risk of drug-resistant TB",0,{"$f":"ROUND(F7*(Epidemiology!E7*Epidemiology!B17)+Epidemiology!B8+(Epidemiology!B14*Epidemiology!E17), -2)","v":0}]
[null,null,null,null,"Previously untreated HIV-negative adults with signs and symptoms of TB",0,{"$f":"ROUND(F8*Epidemiology!E11*Epidemiology!E10*Epidemiology!C4*Epidemiology!B18,-2)","v":0}]
[null,null,null,null,"New smear-positive TB cases receiving Xpert for rifampicin testing (excluding those receiving it as the initial diagnostic test)",0,{"$f":"ROUND(Epidemiology!C7-((Epidemiology!B9*Epidemiology!B10)+(Epidemiology!E7+Epidemiology!B8+Epidemiology!B14)+(Epidemiology!E11*Epidemiology!E10*Epidemiology!C4)+(Epidemiology!C7*Epidemiology!B10)),-2)*F9","v":0}]
[null,null,null,null,"Total number of FluoroType® MTBDR VER 2.0 tests required for the period",null,{"$f":"SUM(G5:G9)","v":0}]
[]
[]
[]
[]
[null,"Number of specimens per batch",0]
[null,"Number of controls per batch",0]
[null,"Number of FluoroType® MTBDR VER 2.0 tests required for the period (with forecasting method 1 or 2 or a value in between)",0]
[null,"Average number of specimens in a batch",{"$f":"C15+C16","v":0}]
[null,"Number of batches required for the period",{"$f":"IF(C15=0,\"0\",C17/C15)","v":"0"}]
[null,"Number of tests (specimens plus controls)",{"$f":"C19*C18","v":0}]
[null,"Estimated repetitions (%)",0]
[null,"Number of extra tests per batch for pipetting error",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Do not delete"]
[null,"Current stock",0]
[null,"Total number of tests to be performed during the period",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FluoroLyse Extraciton Kit "]
[null,"Total number of tests to be ordered",{"$f":"IF(C23=0,(ROUNDUP(C20+(C20*repet)+C22*C19,0)),(ROUNDUP(C20+(C20*repet)+C22*C19,0))-C23)","v":0}]
[null,"For DNA extraction  ","FluoroLyse Extraciton Kit ",null,"<=Choose here",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GXT DNA/ RNA Extraction Kit "]
[]
[]
[null,"GDF code","Item","Units / pack","No. of packs","Unit cost (US$)","Calculation details","Options"]
[null,null," FluoroType MTBDR assay",96,{"$f":"ROUNDUP(C25/unit_pack,0)","v":0},0,"Enter unit cost based on current procurement mechanism"]
[null,null,"GXT DNA/ RNA Extraction Kit ",96,{"$f":"IF($C$26=$V$26,ROUNDUP(C25/unit_pack,0),0)","v":0},0]
[null,null,"FluoroLyse Extraciton Kit ",96,{"$f":"IF($C$26=$V$24,ROUNDUP(C25/unit_pack,0),0)","v":0},0]
[null,106384,"Sterile plastic centrifuge tubes, 15 mL",500,{"$f":"ROUNDUP(kit_ordered*D30*1.05/unit_pack,0)","v":0},48.95,"1 tube per test + 5%"]
[null,106422,"Microcentrifuge tubes, 2 mL",500,{"$f":"ROUNDUP(C19*2*1.05/unit_pack,0)","v":0},49.55,"2 tubes per batch + 5% extra"]
[null,106554,"Sterile filter tips,  0.1–10 µL",960,{"$f":"ROUNDUP((kit_ordered*D30*4*1.05)/unit_pack,0)","v":0},115.7,"4 tips per test + 5% extra "]
[null,106389,"Sterile filter tips, 20–200 µL",960,{"$f":"ROUNDUP((kit_ordered*D30*4*1.05)/unit_pack,0)","v":0},61,"4 tips per test + 5% extra"]
[null,106390,"Sterile filter tips, 100–1000 µL",960,{"$f":"ROUNDUP((kit_ordered*D30*4*1.05)/unit_pack,0)","v":0},88.5,"4 tips per test + 5% extra"]
[null,106444,"Plastic bags, 30 L",200,{"$f":"ROUNDUP(Months*22*4/unit_pack,0)","v":0},98.6,"4 per working day"]
[null,106415,"Square filter paper, 580 mm",100,{"$f":"ROUNDUP(Months*22*8/unit_pack,0)","v":0},111.4,"8 per working day"]
[null,106755,"Paper towels",200,{"$f":"ROUNDUP(12*22*40/unit_pack,0)","v":53},1.45,"40 per day"]
[null,106333,"Ethanol / isopropanol, 5 L",5,{"$f":"ROUNDUP(Months*4.33*1/unit_pack,0)","v":0},32.15,"1 L per week"]
[]
[null,null,"Summary",null,"Cost (US$)"]
[null,null,"Total for FluoroType® MTBDR VER 2.0",null,{"$f":"SUMPRODUCT(E30:E41*F30:F41)","v":76.849999999999994}]
[null,null,"Total per FluoroType® MTBDR VER 2.0",null,{"$f":"IF(C25=0,\"-\",E44/C25)","v":"-"}]

{"sheet":"Cobas MTB and MTB-RIF-INH","index":14,"n_rows":48,"n_cols":21,"rows_kept":48,"cut":false,"hidden":false,"merged":[[14,2,14,3],[14,4,14,5],[0,0,0,8],[1,1,1,8],[2,1,2,2],[2,4,2,6],[9,4,9,5],[15,2,15,3],[15,4,15,5],[16,2,16,3],[16,4,16,5],[17,2,17,3],[17,4,17,5],[21,20,21,26],[23,2,23,3],[45,2,45,3],[18,2,18,3],[18,4,18,5],[19,2,19,3],[19,4,19,5],[20,2,20,3],[20,5,21,5],[21,2,21,3],[27,6,29,6],[31,6,34,6],[22,2,22,3],[24,2,24,3]]}
["Cobas® MTB and MTB-RIF/INH assays\nTwo methods are proposed for calculating the expected number of tests to be performed during the period."]
[null,"Values in red should be entered or adjusted according to actual country data and practices, when possible."]
[null,"Method 1: Consumption-based forecasting\nThe expected number of tests is based on number of tests perfromed last year",null,null,"Method 2: Morbidity-based forecasting\nThe estimated number of tests calculated is based on epidemiological data (notifications) and planned algorithms. The calculated sum is the target to be reached when algorithms are implemented according to the indicated coverage and assumptions."]
[null,"Average number of Cobas® MTB tests performed per month ",0,null,"Patient population","Coverage of testing","Number of Cobas® MTB and MTB-RIF/INH tests performed during the period"]
[null,"Average number of Cobas® MTB RIF/IINH tests performed per month ",0,null,"People living with HIV (PLHIV) with signs and symptoms of TB",0,{"$f":"ROUND((F5*Epidemiology!B12*Epidemiology!B20*Epidemiology!E20),-2)","v":0}]
[null,"Number of Cobas® MTB and MTB-RIF/INH tests performed during the period ",{"$f":"(C4+C5)*Months","v":0},null,"Children with signs and symptoms of TB",0,{"$f":"ROUND(F6*Epidemiology!B9*Epidemiology!B10*Epidemiology!B26, -2)","v":0}]
[null,null,null,null,"People at risk of drug-resistant TB",0,{"$f":"ROUND(F7*(Epidemiology!E7*Epidemiology!B17)+Epidemiology!B8+(Epidemiology!B14*Epidemiology!E17), -2)","v":0}]
[null,null,null,null,"Previously untreated HIV-negative adults with signs and symptoms of TB",0,{"$f":"ROUND(F8*Epidemiology!E11*Epidemiology!E10*Epidemiology!C4*Epidemiology!B18,-2)","v":0}]
[null,null,null,null,"New smear-positive TB cases receiving Xpert for rifampicin testing purposes (excluding those receiving it as the initial diagnostic test)",0,{"$f":"ROUND(Epidemiology!C7-((Epidemiology!B9*Epidemiology!B10)+(Epidemiology!E7+Epidemiology!B8+Epidemiology!B14)+(Epidemiology!E11*Epidemiology!E10*Epidemiology!C4)+(Epidemiology!C7*Epidemiology!B10)),-2)*F9","v":0}]
[null,null,null,null,"Total number of Cobas® MTB and MTB-RIF/INH tests required for the period",null,{"$f":"SUM(G5:G9)","v":0}]
[]
[]
[]
[]
[null,"Number of specimens per batch",0]
[null,"Number of controls per batch",0]
[null,"Number of Cobas® MTB and MTB-RIF/INH tests performed during the period (with forecasting method 1 or 2 or a value in between)",0]
[null,"Average number of specimens in a batch",{"$f":"C15+C16","v":0}]
[null,"Number of batches used during the period",{"$f":"IF(C15=0,\"0\",C17/C15)","v":"0"}]
[null,"Number of tests performed (specimens plus controls)",{"$f":"C19*C18","v":0}]
[null,"Estimated repetitions (%)",0]
[null,"Number of extra tests per batch for pipetting error",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Do not delete"]
[null,"Current stock",0]
[null,"Total number of tests performed during the period",{"$f":"(ROUNDUP(C20+(C20*repet)+C22*C19,0))","v":0}]
[null,"Total number of tests to be ordered",{"$f":"(ROUNDUP(C20+(C20*repet)+C22*C19,0))-C23","v":0}]
[]
[null,"GDF code","Item","Units / pack","No. of packs","Unit cost (US$)","Calculation details"]
[null,null,"Cobas® MTB",384,{"$f":"ROUNDUP(C25/unit_pack,0)","v":0},0,"Enter unit cost in current procurement mechanism"]
[null,null,"Cobas® MTB Positive Control Kit",16,{"$f":"C19/D29","v":0},0]
[null,null,"Cobas® 6800/8800 Buffer Negative Control Kit",16,{"$f":"C19/D30","v":0},0]
[null,null,"Cobas® Microbial Inactivation Solution",16,{"$f":"(C25*3.2)/480","v":0},0,"1:4 per sample. Volume sample estimated 0.8 = 3.2 inactivation buffer. Enter unit cost in current procurement mechanism."]
[null,null,"Cobas® MTB-RIF/INH",72,3,0,"Enter unit cost in current procurement mechanism"]
[null,null,"Cobas® MTB-RIF/INH Positive Control Kit",16,{"$f":"C19/D29","v":0},0]
[null,null,"Cobas® 6800/8800 Buffer Negative Control Kit",16,{"$f":"C19/D30","v":0},0]
[null,null,"Cobas Microbial Inactivation Solution",16,{"$f":"(C25*3.2)/480","v":0},0]
[null,106384,"Sterile plastic centrifuge tubes, 15 mL",500,{"$f":"ROUNDUP(kit_ordered*D28*1.05/unit_pack,0)","v":0},48.95,"1 tube per test + 5%"]
[null,106422,"Microcentrifuge tubes, 2 mL",500,{"$f":"ROUNDUP(C19*2*1.05/unit_pack,0)","v":0},49.55,"2 tubes per batch + 5% extra"]
[null,106554,"Sterile filter tips, 0.1–10 µL",960,{"$f":"ROUNDUP((kit_ordered*D28*4*1.05)/unit_pack,0)","v":0},115.7,"4 tips per tests + 5% extra "]
[null,106389,"Sterile filter tips, 20–200 µL",960,{"$f":"ROUNDUP((kit_ordered*D28*4*1.05)/unit_pack,0)","v":0},61,"4 tips per test + 5% extra"]
[null,106390,"Sterile filter tips, 100–1000 µL",960,{"$f":"ROUNDUP((kit_ordered*D28*4*1.05)/unit_pack,0)","v":0},88.5,"4 tips per test + 5% extra"]
[null,106444,"Plastic bags, 30 L",200,{"$f":"ROUNDUP(Months*22*4/unit_pack,0)","v":0},98.6,"4 per working day"]
[null,106415,"Square filter paper, 580 mm",100,{"$f":"ROUNDUP(Months*22*8/unit_pack,0)","v":0},111.4,"8 per working day"]
[null,106755,"Paper towels",200,{"$f":"ROUNDUP(12*22*40/unit_pack,0)","v":53},1.45,"40 per day"]
[null,106333,"Ethanol / isopropanol, 5 L",5,{"$f":"ROUNDUP(Months*4.33*1/unit_pack,0)","v":0},32.15,"1 L per week"]
[]
[null,null,"Summary",null,"Cost (US$)"]
[null,null,"Total for Cobas® MTB and MTB-RIF/INH",null,{"$f":"SUMPRODUCT(E28:E44*F28:F44)","v":76.849999999999994}]
[null,null,"Total  per Cobas® MTB and MTB-RIF/INH",null,{"$f":"IF(C25=0,\"-\",E47/C25)","v":"-"}]

{"sheet":"Abbott RT MTB and MTB RIF-INH","index":15,"n_rows":48,"n_cols":21,"rows_kept":48,"cut":false,"hidden":false,"merged":[[14,2,14,3],[14,4,14,5],[15,2,15,3],[15,4,15,5],[16,2,16,3],[16,4,16,5],[0,0,0,8],[1,1,1,8],[2,1,2,2],[2,4,2,6],[9,4,9,5],[17,2,17,3],[17,4,17,5],[18,2,18,3],[18,4,18,5],[19,2,19,3],[19,4,19,5],[45,2,45,3],[20,2,20,3],[20,5,21,5],[21,2,21,3],[21,20,21,26],[27,6,34,6],[23,2,23,3],[22,2,22,3],[24,2,24,3]]}
["Abbott Real Time MTB and MTB RIF/INH assays\nTwo methods are proposed for calculating the expected number of tests to be performed during the period."]
[null,"Values in red should be entered or adjusted according to actual country data and practices, when possible."]
[null,"Method 1: Consumption-based forecasting\nThe expected number of tests is based on the number of tests perfomed last year.",null,null,"Method 2: Morbidity-based forecasting\nThe estimated number of tests calculated is based on epidemiological data (notifications) and planned algorithms. The calculated sum is the target to be reached when algorithms are implemented according to the indicated coverage and assumptions."]
[null,"Average number of Abott RT MTB tests performed per month ",0,null,"Patient population","Coverage of testing","Number of Abbott MTB and MTB RIF/INH required for the period"]
[null,"Average number of Abott RT MTB RIF/IINH tests performed per month ",0,null,"People living with HIV (PLHIV) with signs and symptoms of TB",0,{"$f":"ROUND((F5*Epidemiology!B12*Epidemiology!B20*Epidemiology!E20),-2)","v":0}]
[null,"Number of Abbott MTB and MTB RIF/INH tests performed during the period ",{"$f":"(C4+C5)*Months","v":0},null,"Children with signs and symptoms of TB",0,{"$f":"ROUND(F6*Epidemiology!B9*Epidemiology!B10*Epidemiology!B26, -2)","v":0}]
[null,null,null,null,"People at risk of drug-resistant TB",0,{"$f":"ROUND(F7*(Epidemiology!E7*Epidemiology!B17)+Epidemiology!B8+(Epidemiology!B14*Epidemiology!E17), -2)","v":0}]
[null,null,null,null,"Previously untreated HIV-negative adults with signs and symptoms of TB",0,{"$f":"ROUND(F8*Epidemiology!E11*Epidemiology!E10*Epidemiology!C4*Epidemiology!B18,-2)","v":0}]
[null,null,null,null,"New smear-positive TB cases receiving Xpert for rifampicin testing purposes (excluding those receiving it as the initial diagnostic test)",0,{"$f":"ROUND(Epidemiology!C7-((Epidemiology!B9*Epidemiology!B10)+(Epidemiology!E7+Epidemiology!B8+Epidemiology!B14)+(Epidemiology!E11*Epidemiology!E10*Epidemiology!C4)+(Epidemiology!C7*Epidemiology!B10)),-2)*F9","v":0}]
[null,null,null,null,"Total number of Abbott MTB and MTB RIF/INH tests required during the period",null,{"$f":"SUM(G5:G9)","v":0}]
[]
[]
[]
[]
[null,"Number of specimens per batch",0]
[null,"Number of controls per batch",0]
[null,"Number of Abbott MTB and MTB RIF/INH tests performed during the period (with forecasting method 1 or 2 or a value in between)",0]
[null,"Average number of specimens in a batch",{"$f":"C15+C16","v":0}]
[null,"Number of batches during the period",{"$f":"IF(C15=0,0,C17/C15)","v":0}]
[null,"Number of tests (specimens plus controls)",{"$f":"C19*C18","v":0}]
[null,"Estimated repetitions (%)",0]
[null,"Number of extra tests per batch for pipetting error",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Do not delete"]
[null,"Current stock",0]
[null,"Total number of tests to be performed during the period",{"$f":"ROUNDUP(C20+(C20*repet)+C22*C19,0)","v":0}]
[null,"Total number of tests to be ordered",{"$f":"IF(C23=0,0,(ROUNDUP(C20+(C20*repet)+C22*C19,0))-C23)","v":0}]
[]
[null,"GDF code","Item","Unit / pack","Qty of pack","Unit cost (US$)","Calculation details"]
[null,null,"Inactivation reagent",null,null,null,"Enter init cost in current procurement mechanism"]
[null,null,"Abbott Sample Preparation System DNA kit",192,{"$f":"ROUNDUP(C25/unit_pack,0)","v":0}]
[null,null,"Abbott Real Time MTB Amplification Reagent Kit",96,{"$f":"ROUNDUP(C25/unit_pack,0)","v":0}]
[null,null,"Abbott Real Time MTB Control Kit",8,{"$f":"C19/D31","v":0}]
[null,null,"Abbott Real Time MTB RIF/INH Resistance Amplification Reagent Kit",24,{"$f":"ROUNDUP(C25/unit_pack,0)","v":0}]
[null,null,"Abbott Real Time MTB RIF/INH Resistance Control Kit",4,{"$f":"ROUNDUP(C19/unit_pack,0)","v":0}]
[null,null,"Abbott 96-Well Optical Reaction Plates",20,{"$f":"ROUNDUP(C25/unit_pack,0)","v":0}]
[null,null,"Abbott 96-Deep-Well Plates and plate holder",32,{"$f":"ROUNDUP(C25/unit_pack,0)","v":0}]
[null,106384,"Sterile plastic centrifuge tubes, 15 mL",500,{"$f":"ROUNDUP(kit_ordered*D30*1.05/unit_pack,0)","v":0},48.95,"1 tube per test + 5%"]
[null,106422,"Microcentrifuge tubes, 2 mL",500,{"$f":"ROUNDUP(C19*2*1.05/unit_pack,0)","v":0},49.55,"2 tubes per batch + 5% extra"]
[null,106554,"Sterile filter tips,  0.1–10 µL",960,{"$f":"ROUNDUP((kit_ordered*D30*4*1.05)/unit_pack,0)","v":0},115.7,"4 tips per test + 5% extra "]
[null,106389,"Sterile filter tips, 20–200 µL",960,{"$f":"ROUNDUP((kit_ordered*D30*4*1.05)/unit_pack,0)","v":0},61,"4 tips per test + 5% extra"]
[null,106390,"Sterile filter tips, 100–1000 µL",960,{"$f":"ROUNDUP((kit_ordered*D30*4*1.05)/unit_pack,0)","v":0},88.5,"4 tips per test + 5% extra"]
[null,106444,"Plastic bags, 30 L",200,{"$f":"ROUNDUP(Months*22*4/unit_pack,0)","v":0},98.6,"4 per working day"]
[null,106415,"Square filter paper, 580 mm",100,{"$f":"ROUNDUP(Months*22*8/unit_pack,0)","v":0},111.4,"8 per working day"]
[null,106755,"Paper towels",200,{"$f":"ROUNDUP(12*22*40/unit_pack,0)","v":53},1.45,"40 per day"]
[null,106333,"Ethanol / isopropanol, 5 L",5,{"$f":"ROUNDUP(Months*4.33*1/unit_pack,0)","v":0},32.15,"1 L per week"]
[]
[null,null,"Summary",null,"Cost (US$)"]
[null,null,"Total for Abbott MTB and MTB RIF/INH",null,{"$f":"SUMPRODUCT(E30:E44*F30:F44)","v":76.849999999999994}]
[null,null,"Total per Abbott MTB and MTB RIF/INH test",null,{"$f":"IF(C25=0,\"-\",E47/C25)","v":"-"}]

{"sheet":"Processing&solid-liquid culture","index":16,"n_rows":86,"n_cols":33,"rows_kept":86,"cut":false,"hidden":false,"merged":[[15,30,15,36],[32,1,33,7],[62,1,62,7],[46,1,47,7],[48,1,59,1],[19,1,20,1],[19,2,20,2],[2,1,2,2],[2,4,2,6],[6,4,6,5],[1,1,1,8],[0,0,0,8],[79,3,79,4],[69,1,71,1],[64,1,65,1],[35,1,36,1],[38,1,43,1],[60,3,60,5]]}
["Processing and solid/liquid culture\nTwo methods are proposed for calculating the expected number of tests to be performed during the period."]
[null,"Values in red should be entered or adjusted according to actual country data and practices, when possible."]
[null,"Method 1: Consumption-based forecasting\nThe expected number of tests is based on the average daily use per instrument module.",null,null,"Method 2: Morbidity-based forecasting\nThe estimated number of tests calculated is based on epidemiological data (notifications) and planned algorithms. The calculated sum is the target to be reached when algorithms are implemented according to the indicated coverage and assumptions."]
[null,"Average number of samples processed for culture per month ",0,null,"Patient population","Coverage of testing","Number of samples processed for culture during the period"]
[null,"Number of samples processed for culture during the period ",{"$f":"C4*Months","v":0},null,"Anticipated cases of RR/MDR-TB detected in the year",0,{"$f":"Epidemiology!$B$14*F5","v":0}]
[null,null,null,null,"People at risk of INH mono-resistance",0,{"$f":"(Epidemiology!$E$7+Epidemiology!$B$8)*F6*Epidemiology!B16","v":0}]
[null,null,null,null,"Total number of samples processed for culture during the period",null,{"$f":"SUM(G5:G6)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[null,"LJ, home-made or ready-made","Ready","<=Choose here","MGIT culture","YES","<=Choose here"]
[null,"Number of samples processed for culture during the period (with forecasting method 1 or 2 or a value in between)",0,null,"Number of samples processed for culture during the period (with forecasting method 1 or 2 or a value in between)",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Do not delete"]
[null,"Number of slants used per sample",0,null,"Repetition rate",0,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,"Petroff","NALC/NaOH"]
[null,"Repetition rate",0,null,"Contamination rate",0]
[null,"Contamination rate",0,null,"MTB-positive cultures (%)",0]
[null,"Average volume (mL) per specimen to be decontaminated",0,null,"Current stock",0]
[null,null,null,null,"Total number of samples required for the period",{"$f":"F16*(1+F17+F18)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No","Ready","Home made"]
[null,"Current stock",0,null,"Total number of reagents to be ordered",{"$f":"(IF(AE25=F15,(F16*(1+F17+F18)),0))-F20","v":0}]
[null,"Total number of samples processed during the period",{"$f":"C16*(1+C18+C19)","v":0},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,null,null,null,"Sterile universal dispenser tips, 10 mL","Sterile, DNA-/RNAse-free tips, 100 - 1000 µl"]
[null,"Total number of reagents to ber ordered",{"$f":"IF(C22=0,C16*(1+C18+C19),((C16*(1+C18+C19)))-C22)","v":0}]
[null,"Number of slants produced with standard batch",{"$f":"IF(C20=0,0,ROUNDUP(1620/C20,0))","v":0},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,null,null,"YES","NO"]
[null,"Number of batches used during the period",{"$f":"IF(C25=0,0,ROUNDUP(C24/C25,0))","v":0}]
[]
[]
[]
[null,"Decontamination method","Petroff","<=Choose here"]
[]
[]
[null,"Solid culture"]
[]
[null,null,"GDF code","Item","Units / pack","No. of packs","Unit cost (US$)","Calculation details"]
[null,"Loewenstein-Jensen medium, ready-made",106259,"TB medium LJ, 500 g",1,{"$f":"IF($C$15=$AF$21,ROUNDUP(0.0375*C26/E36,0),0)","v":0},69.55,"Ready mix LJ: 37.5 g per batch"]
[null,null,106268,"Glycerol 99.5, 1 L",1,{"$f":"IF($C$15=$AF$21,ROUNDUP(0.0375*C26/E37,0),0)","v":0},10.55,"12 mL per batch"]
[]
[null,"Lowenstein-Jensen medium made from components",106263,"Potassium dihydrogen phosphate, MW: 136.09, 1 kg ",1,{"$f":"IF($C$15=$AG$21,ROUNDUP(0.0024*C26/E39,0),0)","v":0},36.700000000000003,"2.4 g per batch"]
[null,null,106264,"Magnesium sulfate-heptahydrate • 7H2O, MW: 246.48. 500 g ",0.5,{"$f":"IF($C$15=$AG$21,ROUNDUP(0.00024*C26/E40,0),0)","v":0},8.25,"0.24 g per batch"]
[null,null,106265,"L-Asparagine-monohydrate • H2O, MW: 150.13, 250 g",0.1,{"$f":"IF($C$15=$AG$21,ROUNDUP(0.0036*C26/E41,0),0)","v":0},21.6,"3.6 g per batch"]
[null,null,106266,"Tri-magnesium di-citrate nonahydrate • 9 H2O, 500 g ",0.1,{"$f":"IF($C$15=$AG$21,ROUNDUP(0.0006*C26/E42,0),0)","v":0},52.5,"0.6 g per batch"]
[null,null,106267,"Malachite green oxalate, 100 g ",0.1,{"$f":"IF($C$15=$AG$21,ROUNDUP(0.0004*C26/E43,0),0)","v":0},112.95,"0.4 g per batch"]
[null,null,106268,"Glycerol 99.5, 1 L",1,{"$f":"IF($C$15=$AG$21,ROUNDUP(0.012*C26/E44,0),0)","v":0},10.55,"12 mL per batch"]
[null,null,null,"Total cost for solid culture",null,null,{"$f":"SUMPRODUCT(F36:F44*G36:G44)","v":0}]
[]
[null,"Liquid culture"]
[]
[null,"MGIT liquid culture",106026,"BBL MGIT tubes  for use in Bactec MGIT 960 (7mL) - 100 tubes/pack",100,{"$f":"IF(AE25=F15,ROUNDUP(F16*(1+F17+F18)/E49,0),0)","v":0},195," 1 tube per test"]
[null,null,106027,"BACTEC MGIT 960 Supplement Kit (100 tests, PANTA and OADC combined)",100,{"$f":"IF(AE25=F15,ROUNDUP(F16*(1+F17+F18)/E50,0),0)","v":0},70.8,"1 tube per test"]
[null,null,106098,"Lime-glass culture tubes, 12 mL, screw caps",100,{"$f":"IF(AE25=F15,ROUNDUP(F16*(1+F17+F18)*0.1/E51,0),0)","v":0},43.6,"10% exchange per year"]
[null,null,106340,"Sterile plastic centrifuge tubes, 50 mL",500,{"$f":"IF(AE25=F15,ROUNDUP(F16*(1+F17+F18)/E52,0),0)","v":0},45,"Same when processing 0 or 1 tube per test"]
[null,null,106394,"Single-use plastic Pasteur-pipettes, sterile, individually packed",500,{"$f":"IF(AE25=F15,ROUNDUP(F22*(1+F19+0.1)/E53,0),0)","v":0},36.85,"For inoculation + contaminated tube + postive tube + repeat rate + 10% extra"]
[null,null,106714,"Disposable loops, 10 µL",500,{"$f":"IF(AE25=F15,ROUNDUP(F16*F19*0.3/E54,0),0)","v":0},16.8,"1 per positive"]
[null,null,106344,"Sterile cryovials, 2 mL ",1000,{"$f":"IF(AE25=F15,ROUNDUP(F16*F19*0.3/E55,0),0)","v":0},295.89999999999998,"30% of positive"]
[null,null,106052,"Cardboard storage box for sterile cryovials, 2 mL",1,{"$f":"IF(AE25=F15,ROUNDUP(F16*F19*0.3/81/E56,0),0)","v":0},2.15,"81 positioned in a box"]
[null,null,106823,"Plastic Petri dishes ",480,null,1.95,"1 Petri dish for 4 positive + 20% contatminated tubes"]
[null,null,"106390/106398","Sterile, DNA-/RNAse-free tips, 100 - 1000 µl","960 or 100",null,88.5,"Dispenser tips: 1 or 2 tips per working day depending on workload\nP1000 : 1 tip for 5 tubes"]
[null,null,106407,"Brain-heart infusion agar",0.5,{"$f":"IF(AE25=F15,ROUNDUP(Months/12*1,0),0)","v":0},84.65,"1 pack per year"]
[null,null,106362,"Plastic foil",1,{"$f":"IF(AE25=F15,ROUNDUP(Months/12*2,0),0)","v":0},70.400000000000006,"2 rolls per year"]
[null,null,null,"Total cost for liquiid culture",null,null,{"$f":"SUMPRODUCT(F49:F60*G49:G60)","v":0}]
[]
[null,"Processing"]
[null,null,"GDF code","Item","Units / pack","No. of packs","Unit cost (US$)","Calculation details"]
[null,"Phosphate buffer according to Soerensen, 1/15 M, pH 6.8 or adjustable between pH 5 and 8.2",106278,"Di-sodium hydrogen phosphate anhydrous, MW: 141.96, 1 kg",1,{"$f":"ROUNDUP((IF(C23=0,F22,C23)*0.04*1.5*0.00474),0)","v":0},27,"4.74 g for 1 L of final  buffer + 50% extra. Calculation for an average of 40 mL of final mix per specimen"]
[null,null,106263,"Potassium dihydrogen phosphate MW: 136.09, 1 kg",1,{"$f":"ROUNDUP((IF(C23=0,F22,C23)*0.04*1.5*0.00454),0)","v":0},36.700000000000003,"4.54 g/L for 1 L of final  buffer + 50% extra. Calculation for an average of 40 mL of final mix per specimen"]
[]
[null,"Petroff decontamination method",106281,"Sodium hydroxide, MW 40.00, purity ≥ 98%, pellets, 1 kg",1,{"$f":"IF($C$30=$AF$17,ROUNDUP(IF(C23=0,F22,C23)*(C20/1000)*0.04/E68,0),0)","v":0},13.55,"40 g/L of specimen"]
[]
[null,"NALC/NaOH decontamination method",106283,"N-Acetyl-L-cysteine, MW: 163.19, purity ≥ 99%, 100 g",0.1,{"$f":"IF($C$30=$AG$17,ROUNDUP(IF(C23=0,F22,C23)*(C20/1000)*0.005/E70,0),0)","v":0},180.5,"5 g/L of specimen"]
[null,null,106284,"Tri-sodium citrate dihydrate · 2H2O, MW: 294.10, 1 kg",1,{"$f":"IF($C$30=$AG$17,ROUNDUP(IF(C23=0,F22,C23)*(C20/1000)*0.029/2/E71,0),0)","v":0},55.35,"14.5 g/L of final buffer "]
[null,null,106281,"Sodium hydroxide, MW 40.00, purity ≥ 98%, pellets, 1 kg",1,{"$f":"IF($C$30=$AG$17,ROUNDUP(IF(C23=0,F22,C23)*(C20/1000)*0.02/E72,0),0)","v":0},13.55,"20 g/L of final  buffer "]
[]
[null,"Consumables",106340,"Sterile plastic centrifuge tubes, 50 mL",500,{"$f":"ROUNDUP(IF(C23=0,F22,C23)*1.1/E74,0)","v":0},45,"1 tube per sample + 10% extra"]
[null,"Consumables",106434,"Disposable Pasteur pipettes, graduated, non-sterile, 155 mm",500,{"$f":"ROUNDUP(Months/12,0)","v":0},9.9,"1 pack per year"]
[null,null,null,"Total cost for culture processing",null,null,{"$f":"SUMPRODUCT(F65:F75*G65:G75)","v":0}]
[]
[]
[]
[null,null,null,"Summary",null,"Cost (US$)"]
[null,null,null,"Total cost for solid culture",null,{"$f":"G45","v":0}]
[null,null,null,"Total cost for liquid culture",null,{"$f":"G61","v":0}]
[null,null,null,"Total cost for sample processing",null,{"$f":"G76","v":0}]
[null,null,null,"Cost for one LJ culture",null,{"$f":"IF(C24=0,\"-\",F81/C24)","v":"-"}]
[null,null,null,"Cost for one MGIT",null,{"$f":"IF(F22=0,\"-\",F82/F22)","v":"-"}]
[null,null,null,"Cost for sample processing per sample",null,{"$f":"IF(C24=0,\"-\",F83/C24)","v":"-"}]

{"sheet":"ID","index":17,"n_rows":38,"n_cols":21,"rows_kept":38,"cut":false,"hidden":false,"merged":[[2,1,2,2],[12,1,12,2],[13,1,13,2],[1,0,1,7],[0,0,0,7]]}
["Rapid MTB identification\nThe method below is used to calculate the expected number of tests to be performed during the period."]
["Values in red should be entered or adjusted according to actual country data and practices, when possible."]
[null,"Method 1: Consumption-based forecasting\nThe expected number of tests is based on the average daily use per instrument module."]
[null,"Average number of samples tested for rapid MTB identification per month ",0]
[null,"Current stock",0]
[null,"Number of samples to be processed for rapid MTB identification during the period ",{"$f":"(C4*Months)","v":0}]
[null,"Number of reagents to be ordered to process samples ",{"$f":"IF(C5=0,0,(C4*Months)-C5)","v":0}]
[]
[]
[]
[]
[]
[null,"Number of positive culture tested for rapid MTB identification",null,{"$f":"C7","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MPT64"]
[null,"Rapid MTB identification test",null,"Capilia TB Neo","<=Choose here",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Capilia TB Neo"]
[]
[]
[null,"GDF code","Item","No. / pack","No. of packs ","Unit cost (US$)"]
[null,106414,"Rapid test for detection of MPT 64 Antigen - SD Bioline TB Ag MPT64",25,{"$f":"IF($D$14=$U$13,ROUNDUP((D13/D18),0),0)","v":0},35]
[null,106394,"Single-use, sterile plastic Pasteur pipettes, individually packed",500,{"$f":"IF($D$14=$U$13,ROUNDUP((D19/D19),0),0)","v":0},36.85]
[null,106714,"Disposable loops, 10 µL",500,{"$f":"IF($D$14=$U$13,ROUNDUP((D13/D20),0),0)","v":0},16.8]
[null,106344,"Sterile cryovials, 2 mL ",1000,{"$f":"IF($D$14=$U$13,ROUNDUP((D13/D21),0),0)","v":0},295.89999999999998]
[]
[null,null,"Summary",null,"Cost"]
[null,null,"Total for SD Bioline TB Ag MPT64",null,{"$f":"SUMPRODUCT(E18:E21*F18:F21)","v":0}]
[null,null,"Total per SD Bioline TB Ag MPT64 test",null,{"$f":"IF(D13=0,0,E24/D13)","v":0}]
[]
[]
[]
[null,"GDF code","Item","No. / pack","No. of packs ","Unit cost (US$)"]
[null,106611,"Capilia TB-Neo - Rapid test for detection of MPT 64 antigen ",100,{"$f":"IF($D$14=$U$14,ROUNDUP((D13/D30),0),0)","v":0},100]
[null,106612,"Capilia TB-Neo Extraction buffer (1 x 20 mL)",20,{"$f":"IF($D$14=$U$14,ROUNDUP((D13/D30),0),0)","v":0},8]
[null,106394,"Sterile Pasteur pipettes, 3 mL",500,{"$f":"IF($D$14=$U$14,ROUNDUP((D13/D30),0),0)","v":0},36.85]
[null,106714,"Disposable loops, 10 µL",500,{"$f":"IF($D$14=$U$14,ROUNDUP((D13/D30),0),0)","v":0},16.8]
[null,106344,"Sterile cryovials, 2 mL ",1000,{"$f":"IF($D$14=$U$14,ROUNDUP((D13/D30),0),0)","v":0},295.89999999999998]
[]
[null,null,"Summary",null,"Cost (US$)"]
[null,null,"Total for Capilia TB-Neo ",null,{"$f":"SUMPRODUCT(E30:E34*F30:F34)","v":0}]
[null,null,"Total per Capilia TB-Neo test",null,{"$f":"IF(D13=0,\"-\",E37/D13)","v":"-"}]

{"sheet":"LJ 1st line DST","index":18,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,0,1,7],[2,0,2,7],[14,3,15,3],[3,1,3,2],[3,4,3,6],[7,4,7,5]]}
[]
["LJ 1st line\nTwo methods are proposed for calculating the expected number of tests to be performed during the period."]
["Values in red should be entered or adjusted according to actual country data and practices,when possible."]
[null,"Method 1: Consumption-based forecasting\nThe expected number of tests is based on the average daily use per instrument module.",null,null,"Method 2: Morbidity-based forecasting\nThe estimated number of tests calculated is based on epidemiological data (notifications) and planned algorithms. The calculated sum is the target to be reached when algorithms are implemented according to the indicated coverage and assumptions."]
[null,"Average number of LJ 1st-line tests performed per month ",0,null,"Patient population","Coverage of testing","Number of LJ 1st-line tests required during the period"]
[null,"Number of LJ 1st-line to be performed during the period ",{"$f":"C5*Months","v":0},null,"Anticipated number of RR/MDR-TB cases to be detected during the year (to test for INH resistance)",0,{"$f":"Epidemiology!$B$14*F6","v":0}]
[null,null,null,null,"People at risk of INH mono-resistance",0,{"$f":"(Epidemiology!$E$7+Epidemiology!$B$8)*F7*Epidemiology!B16","v":0}]
[null,null,null,null,"Total number of samples to be processed for culture during the period",null,{"$f":"SUM(G6:G7)","v":0}]
[]
[]
[]
[]
[]
[]
[null,"Number of LJ 1st-line tests performed during the period (with forecasting method 1 or 2 or a value in between)",0]
[null,"Expected repeat rate for 1st DST on LJ (%)",0]
[null,"Current stock",0]
[null,"Total number of tests to be performed during the period",{"$f":"(C15+(C15*C16)/100)","v":0}]
[null,"Total number of tests to be ordered",{"$f":"IF(C17=0,0,((C15+(C15*C16)/100))-C17)","v":0}]
[null,null,null,null,"Please enter needs per test here according to laboratory SOP (default values should be modified)"]
[]
["GDF code","Item","Unit ","Units / pack","Needs per test","No. of packs ","Unit cost (US$)"]
[106268,"Glycerol 99.5","ml",1000,0,{"$f":"ROUNDUP((E23/D23)*C19,0)","v":0},10.55]
[106259,"TB medium LJ, 500 g","g",500,0,{"$f":"ROUNDUP((E24/D24)*C19,0)","v":0},69.55]
[106308,"Isoniazid (INH) - for laboratory use","g",5,0,{"$f":"ROUNDUP((E25/D25)*C19,0)","v":0},40.5]
[106309,"Rifampicin (RMP) - for laboratory use","g",1,0,{"$f":"ROUNDUP((E26/D26)*C19,0)","v":0},131.6]
[106311,"Dihydro-streptomycin (DHSM) - for laboratory use","g",5,0,{"$f":"ROUNDUP((E27/D27)*C19,0)","v":0},65.61]
[106310,"Ethambutol - for laboratory use","g",25,0,{"$f":"ROUNDUP((E28/D28)*C19,0)","v":0},140.1]
[106394,"Single-use, sterile, plastic Pasteur-pipettes, individually packed","pcs",500,0,{"$f":"ROUNDUP((E29/D29)*C19,0)","v":0},36.85]
[106344,"Sterile cryovials, 2 mL","pcs",1000,0,{"$f":"ROUNDUP((E30/D30)*C19,0)","v":0},295.89999999999998]
[]
[]
[null,"Summary","Cost (US$)"]
[null,"Total  for 1st DST on LJ",{"$f":"SUMPRODUCT(F23:F30*G23:G30)","v":0}]
[null,"Cost per 1st DST LJ test",{"$f":"IF(C19=0,\"-\",C34/C19)","v":"-"}]

{"sheet":"LJ 2nd line DST","index":19,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,4,2,6],[6,4,6,5],[0,0,0,8],[1,0,1,8]]}
["LJ 2nd line\nTwo methods are proposed for calculating the expected number of tests to be performed during the period."]
["Values in red should be entered or adjusted according to actual country data and practices,when possible. "]
[null,"Method 1: Consumption-based forecasting\nThe expected number of tests is based on the average daily use per instrument module.",null,null,"Method 2: Morbidity-based forecasting\nThe estimated number of tests calculated is based on epidemiological data (notifications) and planned algorithms. The calculated sum is the target to be reached when algorithms are implemented according to the indicated coverage and assumptions."]
[null,"Average number of LJ 2nd-line tests performed per month ",0,null,"Patient population","Coverage of testing (%)","Number of LJ 2nd-line tests performed during the period"]
[null,"Total number of LJ 2nd-line to be performed during the period ",{"$f":"C4*Months","v":0},null,"Anticipated number of RR/MDR-TB cases to be detected during the year",0,{"$f":"Epidemiology!$B$14*F5","v":0}]
[null,null,null,null,"People with detected INH mono-resistance (to test for fluoroquinolone resistance)",0,{"$f":"(Epidemiology!$E$7+Epidemiology!$B$8)*F6*Epidemiology!B16","v":0}]
[null,null,null,null,"Total number of samples to be processed for culture during the period",null,{"$f":"SUM(G5:G6)","v":0}]
[]
[]
[]
[]
[null,"Number of LJ 1st-line tests performed during the period (with forecasting method 1 or 2 or a value in between)",0]
[null,"Expected repeat rate for 1st DST on LJ (%)",0]
[null,"Current stock",0]
[null,"Total number of tests to be performed during the period",{"$f":"(C12+((C12*C13)/100))","v":0}]
[null,"Total number of tests to be ordered",{"$f":"IF(C14=0,0,((C12+((C12*C13)/100)))-C14)","v":0}]
[]
[null,null,null,null,"Please enter needs per test here according to laboratory SOP (default values should be modified)"]
[]
["GDF code","Item","Unit ","Units/pack","Needs per test","No. of packs ","Unit cost (US$)","Calculation details"]
[106268,"Glycerol 99.5","ml",1000,0,{"$f":"ROUNDUP((E21/D21)*C16,0)","v":0},10.55]
[106259,"TB medium LJ, 500 g","g",500,0,{"$f":"ROUNDUP((E22/D22)*C16,0)","v":0},69.55]
[106560,"Levofloxacin (LFX)- for laboratory use","g",1,0,{"$f":"ROUNDUP((E23/D23)*C16,0)","v":0},43.75]
[106316,"Ethionamide (ETH) - for laboratory use","g",5,0,{"$f":"ROUNDUP((E24/D24)*C16,0)","v":0},135.19999999999999]
[106317,"Kanamycin (KAN) - for laboratory use","g",5,0,{"$f":"ROUNDUP((E25/D25)*C16,0)","v":0},171.4]
[106318,"Amikacin (AMI)  - for laboratory use","g",5,0,{"$f":"ROUNDUP((E26/D26)*C16,0)","v":0},90]
[106319,"Capreomycin (CM) - for laboratory use","g",1,0,{"$f":"ROUNDUP((E27/D27)*C16,0)","v":0},274.60000000000002]
[106396,"Dispenser tips, 5 mL","pieces",100,0,{"$f":"ROUNDUP((E28/D28)*C15,0)","v":0},50]
[106394,"Single-use, sterile plastic Pasteur pipettes, individually packed","pieces",500,0,{"$f":"ROUNDUP((E29/D29)*C16,0)","v":0},36.85]
[106344,"Sterile cryovials, 2 mL ","pieces",1000,0,{"$f":"ROUNDUP((E30/D30)*C16,0)","v":0},295.89999999999998]
[]
[]
[null,"Summary","Cost (US$)"]
[null,"Total for 2nd DST on LJ",{"$f":"SUMPRODUCT(F21:F30,G21:G30)","v":0}]
[null,"Cost per test 2nd DST on LJ ",{"$f":"IF(C15=0,\"-\",C34/C16)","v":"-"}]

{"sheet":"MGIT 1st line DST","index":20,"n_rows":46,"n_cols":7,"rows_kept":46,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,4,2,6],[6,4,6,5],[0,0,0,7],[1,1,1,7],[30,2,30,4],[37,2,37,4],[11,3,12,3],[17,3,18,3],[10,1,10,3],[16,1,16,3]]}
["MGIT 1st line\nTwo methods are proposed for calculating the expected number of tests to be performed during the period."]
[null,"Values in red should be entered or adjusted according to actual country data and practices, when possible."]
[null,"Method 1: Consumption-based forecasting\nThe expected number of tests is based on the average daily use per instrument module.",null,null,"Method 2: Morbidity-based forecasting\nThe estimated number of tests calculated is based on epidemiological data (notifications) and planned algorithms. The calculated sum is the target to be reached when algorithms are implemented according to the indicated coverage and assumptions."]
[null,"Average number of MGIT DST performed per month ",0,null,"Patient population","Coverage of testing (%)","Number of MGIT DST used during the period"]
[null,"Number of MGIT DST to be performed during the period ",{"$f":"C4*Months","v":0},null,"Anticipated number of RR/MDR-TB cases to be detected during the year (to test for INH resistance)",0,{"$f":"Epidemiology!$B$14*F5","v":0}]
[null,null,null,null,"People at risk of INH mono-resistance",0,{"$f":"(Epidemiology!$E$7+Epidemiology!$B$8)*F6*Epidemiology!B16","v":0}]
[null,null,null,null,"Total number of samples processed for MGIT DST during the period",null,{"$f":"SUM(G5:G6)","v":0}]
[]
[]
[]
[null,"SIRE"]
[null,"Number of strains to be tested for SIRE during the period (with forecasting method 1 or 2 or a value in between)",0]
[null,"Expected repeat rate for SIRE (%)",0]
[null,"Current stock",0]
[null,"Total number of tests to be performed during the period, including repeats",{"$f":"C12*(1+C13)","v":0}]
[null,"Total number of tests to be ordered",{"$f":"(C12*(1+C13)-C14)","v":0}]
[null,"PZA"]
[null,"Number of strains tested for PZA during the period (with forecasting method 1 or 2 or a value in between)",0]
[null,"Expected repeat rate for PZA (%)",0]
[null,"Current stock",0]
[null,"Total number of tests to be performed during the period, including repeats",{"$f":"(C18*(1+C19))","v":0}]
[null,"Total number of tests to be ordered",{"$f":"(C21)-C20","v":0}]
[]
[null,null,"FL and PZA DST on MGIT"]
[null,"GDF code","Item","Units / pack","No. of packs","Unit cost (US$)","Calculation details"]
[null,106028,"BACTEC™ MGIT™ 960 SIRE kit, One kit is sufficient for 40 test",40,{"$f":"ROUNDUP(C16/D26,0)","v":0},72.7]
[null,106026,"BBL MGIT tubes  for use in Bactec MGIT 960 (7 mL) - 100 tubes/pack",100,{"$f":"ROUNDUP(C16*5/D27,0)","v":0},195,"5 tubes per test"]
[null,106389,"Sterile filter tips, 20–200 µL",960,{"$f":"IF(C16=0,0,ROUNDUP((C16+2)/D28,0))","v":0},61,"1 tip per test for adding drug + 1 tip per test for diluting GC"]
[null,106390,"Sterile filter tips, 100–1000 µL",960,{"$f":"IF(C16=0,0,ROUNDUP((C16+2)/D29,0))","v":0},88.5,"1 tip per test for supplementation + 1 tip per test for bacteria"]
[null,106181,"Sterile dispenser tips, 10 mL",100,{"$f":"ROUNDUP(IF(C16>1000,2,1.2)*Months*22/D30,0)","v":0},196.65,"1 or 2 tips per working day, depending on workload"]
[null,null,"Total for DST SIRE",null,null,{"$f":"SUMPRODUCT(E26:E30*F26:F30)","v":0}]
[]
[]
[null,106033,"BACTEC™ MGIT™ PZA Kit",50,{"$f":"ROUNDUP(C22/D34,0)","v":0},90.6]
[null,106036,"BACTEC™ MGIT™ PZA Tubes - 25",25,{"$f":"ROUNDUP((C18*(1+C19)*2)/D35,0)","v":0},53.55,"2 tubes per PZA"]
[null,106389,"Sterile pipette filter  tips, 1–200 µL",960,{"$f":"ROUNDUP(C18*(1+C19)/D36,0)","v":0},61,"1 tip per test"]
[null,106390,"Sterile filter tips, 100–1000 µL",960,{"$f":"ROUNDUP(C18*(1+C19)/D37,0)","v":0},88.5,"1 tip per test"]
[null,null,"Total for DST SIRE",null,null,{"$f":"SUMPRODUCT(E34:E37*F34:F37)","v":0}]
[]
[]
[]
[]
[null,null,"Summary","Cost (US$)"]
[null,null,"Total amount for DST SIRE",{"$f":"F31","v":0}]
[null,null,"Total amount for DST PZA",{"$f":"F38","v":0}]
[null,null,"Total cost of liquid 1st-line DST",{"$f":"SUM(D44:D45)","v":0}]

{"sheet":"MGIT 2nd line DST","index":21,"n_rows":72,"n_cols":21,"rows_kept":72,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,4,2,6],[6,4,6,5],[0,0,0,8],[1,1,1,8],[71,1,71,2],[61,1,61,2],[65,1,65,2],[66,1,66,2],[67,1,67,2],[68,1,68,2],[62,1,62,2],[13,3,14,3],[29,3,29,5],[48,3,48,5],[69,1,69,2],[58,1,58,2],[59,1,59,2],[60,1,60,2]]}
["MGIT 2nd line\nTwo methods are proposed for calculating the expected number of tests to be performed during the period."]
[null,"Values in red should be entered or adjusted according to actual country data and practices, when possible."]
[null,"Method 1: Consumption-based forecasting\nThe expected number of tests is based on the average daily use per instrument module.",null,null,"Method 2: Morbidity-based forecasting\nThe estimated number of tests calculated is based on epidemiological data (notifications) and planned algorithms. The calculated sum is the target to be reached when algorithms are implemented according to the indicated coverage and assumptions."]
[null,"Average number of MGIT DST performed per month ",0,null,"Patient population","Coverage of testing (%)","Number of MGIT DST to be performed during the period"]
[null,"Number of MGIT DST to be performed during the period ",{"$f":"C4*Months","v":0},null,"Anticipated number of RR/MDR-TB cases to be detected during the year",1,{"$f":"Epidemiology!$B$14*F5","v":0}]
[null,null,null,null,"People with detected INH mono-resistance (to test for fluoroquinolone resistance)",1,{"$f":"(Epidemiology!$E$7+Epidemiology!$B$8)*F6*Epidemiology!B16","v":0}]
[null,null,null,null,"Total number of samples to be processed for MGIT DST during the period",null,{"$f":"SUM(G5:G6)","v":0}]
[]
[]
[]
[]
[]
[null,"Drug formulas","Lyophilized vials "]
[null,"Number of strains tested for SLD during the period (with forecasting method 1 or 2 or a value in between)",0]
[null,"Expected repeat rate for SLD MGIT (%)",0]
[null,"Current stock",0]
[null,"Total number of tests to be performed during the period",{"$f":"(ROUNDUP(C14*(1+C15),0))","v":0}]
[null,"Total number of tests to be oredered",{"$f":"(ROUNDUP(C14*(1+C15),0))-C16","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lyophilized vials ","Pure drugs substances"]
[null,null,null,null,"Please enter needs per test here according to laboratory SOP (default values should be modified)"]
["GDF code","Item","Unit ","No. / pack","Needs per test","No. of packs ","Unit cost (US$)","Calculation details"]
[106585,"Moxifloxacin - lyophilized drug for laboratory use, 6-vial pack","pack",1,0,{"$f":"IF(C13=T20,ROUNDUP((E23/D23)*$C$18,0),0)","v":0},90]
[106586,"Amikacin - lyophilized drug for laboratory use, 6-vial pack","pack",1,0,{"$f":"IF(C13=T20,ROUNDUP((E24/D24)*$C$18,0),0)","v":0},90]
[106584,"Kanamycin – lyophilized drug for laboratory use, 6-vial pack","pack",1,0,{"$f":"IF(C13=T20,ROUNDUP((E25/D25)*$C$18,0),0)","v":0},90]
[106587,"Capreomycin - lyophilized drug for laboratory use, 6-vial pack","pack",1,0,{"$f":"IF(C13=T20,ROUNDUP((E26/D26)*$C$18,0),0)","v":0},90]
[106582,"BD BBL Middlebrook OADC Enrichment, 20 mL per tube, ''A'' size tube,  BD BBL™ Middlebrook OADC Enrichment, 20 mL per tube, ''A'' size tube (10/sp)","pack/mL",200,0,{"$f":"IF(C13=T20,ROUNDUP((E27/D27)*$C$18,0),0)","v":0},65.8]
[106026,"BBL MGIT Tubes  for use in Bactec MGIT 960 (7 mL) - 100 tubes/pack","box/tubes",100,0,{"$f":"IF(C13=T20,ROUNDUP((E28/D28)*$C$18,0),0)","v":0},195]
[106412,"Long 1-mL tips with filter","box/pieces",800,0,{"$f":"IF(C13=T20,ROUNDUP((E29/D29)*$C$18,0),0)","v":0},90]
[null,null,null,"Total number of DST 2nd-line tests required",null,null,{"$f":"SUMPRODUCT(F23:F29,G23:G29)","v":0}]
[]
[]
[null,null,null,null,"Please enter needs per test here according to laboratory SOP (default values should be modified)"]
["GDF code","Item","Unit ","No. / pack","Needs per test","No. of packs ","Unit cost (US$)","Calculation details"]
[106315,"Prothionamide (PTH) - for laboratory use","g",2,0,{"$f":"IF($C$13=$U$20,ROUNDUP((E35/D35)*$C$18,0),0)","v":0},165.9]
[106319,"Capreomycin (CM) - for laboratory use","g",1,0,0,274.60000000000002]
[106560,"Levofloxacin - for laboratory use","g",1,0,0,43.75]
[106653,"Linezolid - for laboratory use","mg",0,0,0,516.95000000000005]
[106654,"Clofazimine - for laboratory use","g",0,0,0,111.3]
[null,"Bedaquiline - for laboratory use","g",0,0,0,0]
[null,"Delamanid - for laboratory use","g ",0,0,0,0]
[106623,"BBL MGIT OADC Enrichment, 6 15-mL vials (90 mL) ","pack/mL",90,0,0,55]
[106026,"BBL MGIT tubes  for use in Bactec MGIT 960 (7 mL) - 100 tubes/pack","box/tubes",100,0,0,195]
[106209,"Serological pipette, 5 mL","pack/pieces",200,0,0,60.95]
[106550,"Serological pipette 10 mL","pack/pieces",200,0,0,62.1]
[106344,"Sterile cryovials, 2 mL ","pack/pieces",1000,0,0,295.89999999999998]
[106388,"Sterile pipette filter tips, 5–100 µL","pack/pieces",960,0,0,61]
[106352,"Single-use syringes, sterile","pack/pieces",80,0,0,86.05]
[null,null,null,"Total number of DST 2nd-line tests required",null,null,{"$f":"SUMPRODUCT(F35:F48,G35:G48)","v":0}]
[]
[]
[]
[]
[]
[]
[null,"BACTEC MGIT 960 Instrument capacity required to run tests for culture, 1st line DST and 2nd line DST"]
[]
[null,"Number of tests performed",null,"Total tests","Maximum number of days for detection according to protocol ","Number of tubes per test according to protocol","Period  (days)","Comments"]
[null,"Total test culture (+%repeat+%cont)",null,{"$f":"'Processing&solid-liquid culture'!F21","v":0},42,1,{"$f":"365*(period/12)","v":{"$error":"#REF!"}}]
[null,"Total test SIRE (+%repeat)",null,{"$f":"'MGIT 1st line DST'!C15","v":0},13,5,{"$f":"365*(period/12)","v":{"$error":"#REF!"}},"AST Carrier Set for 5 tubes"]
[null,"Total test PZA (+%repeat)",null,{"$f":"'MGIT 1st line DST'!C21","v":0},21,2,{"$f":"365*(period/12)","v":{"$error":"#REF!"}},"AST Carrier Set for 2 tubes"]
[null,"Total test 2nd-line drugs (+%repeat) with ready reagents",null,{"$f":"IF(C13=T20,C17,0)","v":0},13,8,{"$f":"365*(period/12)","v":{"$error":"#REF!"}},"AST Carrier Set for 8 tubes"]
[null,"Total test 2nd-line drugs (+%repeat) with powder reagents",null,{"$f":"IF($C$13=$U$20,C17,0)","v":0},13,8,{"$f":"365*(period/12)","v":{"$error":"#REF!"}},"AST Carrier Set for 8 tubes"]
[]
[null,"Capacity used (number of tubes)",null,"Number of tubes"]
[null,"Capacity used by tubes for culture",null,{"$f":"((D59*F59)/G59)*E59","v":{"$error":"#REF!"}}]
[null,"Capacity used by SIRE tubes",null,{"$f":"((D60*F60)/G60)*E60","v":{"$error":"#REF!"}}]
[null,"Capacity used by PZA tubes",null,{"$f":"((D61*F61)/G61)*E61","v":{"$error":"#REF!"}}]
[null,"Capacity used by 2nd-line drugs tubes",null,{"$f":"(((D62*F62)/G62)*E62) + (((D63*F63)/G63)*E63)","v":{"$error":"#REF!"}}]
[null,"Total capacity used by tests in period",null,{"$f":"SUM(D66:D69)","v":{"$error":"#REF!"}}]
[]
[null,"Number of Bactec 960 systems needed to match the required capacity:",null,{"$f":"D70*1/960","v":{"$error":"#REF!"}}]

{"sheet":"Biosafety and cleaning","index":22,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["Cleaning and biosafety\n"]
[]
[null,"Number of staff in the laboratory",1]
[null,"Number of staff in the BSL3",1]
[null,"Number of biosafety cabinets",1]
[]
[null,"Cleaning"]
[]
[null,"GDF code","Family","Item","No. per pack","Quantity","Price (US$)","Comment"]
[null,106376,"Consumables","Cotton wool",1,{"$f":"ROUNDUP(Months/2/E10,0)","v":0},8.5500000000000007,"1 roll per 2 months"]
[null,106444,"Consumables","Plastic bags, biohazard waste, 30 L",200,{"$f":"ROUNDUP(Months*110/E11,0)","v":0},98.6,"3 per day for changing room + 1 per BSC"]
[null,106348,"Consumables","Transparent polypropylene waste bag, 420 x 600 mm",1000,{"$f":"ROUNDUP(Months*22*3/E12,0)","v":0},107.05,"3 per day"]
[null,106755,"Consumables","Paper towels, 200",1,{"$f":"ROUNDUP(Months/2/E13,0)","v":0},1.45,"1 per 2 months"]
[null,106359,"Consumables","Sterile indicator tape, autoclave",1,{"$f":"ROUNDUP(Months/3*2/E14,0)","v":0},2.15,"2 per quarter"]
[null,106358,"Consumables","Sterile indicator tape, hot-air oven",1,{"$f":"ROUNDUP(Months/3*2/E15,0)","v":0},14.25,"2 per quarter"]
[null,106377,"Consumables","Absorbent laboratory paper",50,{"$f":"ROUNDUP(Months*22*BSC/E16,0)","v":0},30.8,"2 per BSC per day",null,null,null,{"$f":"Months","v":0}]
[null,106363,"Consumables","Tube brush",5,{"$f":"ROUNDUP('Processing&solid-liquid culture'!F21/500/E17,0)","v":0},8.9499999999999993,"For culture, 1 per 500 cultures"]
[null,106371,"Consumables","Disinfectant for BSC surface",1,{"$f":"ROUNDUP(Months/3*BSC/E18,0)","v":0},35.200000000000003,"1 bottle per quarter per BSC"]
[null,106294,"Consumables","Disinfectant for cleaning instrument",1,{"$f":"ROUNDUP(Months/3*BSC/E19,0)","v":0},46.55,"1 bottle per quarter per BSC"]
[null,106370,"Consumables","Disinfectant for floors",1,{"$f":"ROUNDUP(Months/3/E20,0)","v":0},17,"1 per 2 months"]
[null,106374,"Consumables","Disinfectant for hands, 1 L",1,{"$f":"ROUNDUP(Months/0.5/E21,0)","v":0},8.1999999999999993,"2 per month"]
[null,106333,"Chemicals","Ethanol / isopropanol, 5 L",1,{"$f":"ROUNDUP(Months/1.5/E22,0)","v":0},32.15,"2 bottles per quarter per BSC"]
[null,106331,"Chemicals","Phenol, 1 kg",1,{"$f":"ROUNDUP(Months*22*0.025/E23,0)","v":0},63.2,"25 g per day"]
[null,106373,"Consumables","Liquid soap",1,{"$f":"ROUNDUP(Months/0.33/E24,0)","v":0},3.9,"3 per month"]
[]
[null,"Biosafety",null,"For staff working in BSL3 laboratory only"]
[null,106727,"Consumables","Hair cover",1000,{"$f":"ROUNDUP(staff3*Months*22/E27,0)","v":0},61.45,"1 per day per staff"]
[null,106726,"Consumables","Shoe cover",2000,{"$f":"ROUNDUP(staff3*Months*22*4/E28,0)","v":0},213.25,"4 per day per staff"]
[null,106725,"Consumables","Laboratory coat size L - disposable - sterile",60,{"$f":"ROUNDUP(staff3*Months*4.33*0.66/E29,0)","v":0},501.25,"0.66 per week per staff"]
[null,106724,"Consumables","Laboratory coat size M - disposable - sterile",60,{"$f":"ROUNDUP(staff3*Months*4.33*1.32/E30,0)","v":0},501.25,"1.32 per week per staff"]
[null,106723,"Consumables","Laboratory coat size S - disposable - sterile",60,{"$f":"ROUNDUP(staff3*Months*4.33*0.33/E31,0)","v":0},501.25,"0.66 per week per staff"]
[null,106820,"Consumables","Latex gloves size L",100,{"$f":"ROUNDUP(staff3*Months*22*10*0.33/E32,0)","v":0},19.649999999999999,"10 per staff per day "]
[null,106819,"Consumables","Latex gloves size M",100,{"$f":"ROUNDUP(staff3*Months*22*10*0.66/E33,0)","v":0},19.649999999999999,"10 per staff per day"]
[null,106818,"Consumables","Latex gloves size S",100,{"$f":"ROUNDUP(staff3*Months*22*10*0.33/E34,0)","v":0},19.649999999999999,"10 per staff per day"]
[null,106829,"Consumables","Disposable respirators FFP2",20,{"$f":"ROUNDUP(staff3*Months*4.33/E35,0)","v":0},40.1,"2 per staff per week"]
[null,106502,"Consumables","Surgical gown - cotton - L",1,{"$f":"ROUNDUP(Months*4.33*BSC/E36,0)","v":0},18.899999999999999,"1 per BSC per week"]
[null,106501,"Consumables","Surgical gown - cotton - M",1,{"$f":"ROUNDUP(Months*4.33*BSC/E37,0)","v":0},18.899999999999999,"1 per BSC per week"]
[null,106500,"Consumables","Surgical gown - cotton - S",1,{"$f":"ROUNDUP(Months*4.33*BSC/E38,0)","v":0},18.899999999999999,"1 per BSC per week"]
[null,106094,"Consumables","First-aid kit for scientific laboratories",1,0,248.85,"1 per 3 years"]
[]
[]
[null,null,null,"Summary",null,null,"Cost (US$)"]
[null,null,null,"Cost for cleaning",null,null,{"$f":"SUMPRODUCT(F10:F24,G10:G24)","v":0}]
[null,null,null,"Cost for biosafety",null,null,{"$f":"SUMPRODUCT(F27:F39,G27:G39)","v":0}]
[null,null,null,"Total cost",null,null,{"$f":"G43+G44","v":0}]

{"sheet":"Maintenance & repair","index":23,"n_rows":195,"n_cols":6,"rows_kept":195,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["Maintenance and repair\n"]
[null,null,"Exchange rate",1,0]
[]
[null,"Costs of equipment service and maintenance contracts"]
[null,"Equipment","No. of units","Unit cost (US$)","Service costs for 1 year (US$)","Comments/Details"]
[null,"Biosafety cabinets",0]
[null,"Service contract for 1 year",0,0,{"$f":"D7*C7","v":0}]
[null,"Spare parts",0,0,{"$f":"D8*C8","v":0}]
[null,"Travel and accommodation for technician",0,0,{"$f":"D9*C9","v":0}]
[null,"Sub-total",null,null,{"$f":"SUM(E7:E9)","v":0}]
[null,"Twincubator (LPA)",0]
[null,"Service contract for 1 year",0,0,0]
[null,"Spare parts",0,0,{"$f":"D13*C13","v":0}]
[null,"Travel and accommodation for technician",0,0,{"$f":"D14*C14","v":0}]
[null,"Sub-total",null,null,{"$f":"SUM(E12:E14)","v":0}]
[]
[null,"Thermocycler",0]
[null,"Service contract for 1 year",0,0,{"$f":"D18*C18","v":0}]
[null,"Spare parts",0,0,{"$f":"D19*C19","v":0}]
[null,"Travel and accommodation for technician",0,0,{"$f":"D20*C20","v":0}]
[null,"Sub-total",null,null,{"$f":"SUM(E18:E20)","v":0}]
[]
[null,"Laminar flow (PCR workstation)",0]
[null,"Service contract for 1 year",0,0,{"$f":"D24*C24","v":0}]
[null,"Spare parts",0,0,{"$f":"D25*C25","v":0}]
[null,"Travel and accommodation for technician",0,0,{"$f":"D26*C26","v":0}]
[null,"Sub-total",null,null,{"$f":"SUM(E24:E26)","v":0}]
[]
[null,"Autoclave",0]
[null,"Service contract for 1 year",0,0,{"$f":"D30*C30","v":0}]
[null,"Spare parts",0,0,{"$f":"D31*C31","v":0}]
[null,"Travel and accommodation for technician",0,0,{"$f":"D32*C32","v":0}]
[null,"Sub-total",null,null,{"$f":"SUM(E30:E32)","v":0}]
[]
[null,"BD BACTEC™ MGIT™ 960 System",0]
[null,"Service contract for 1 year",0,0,{"$f":"D36*C36","v":0},"1 visit per calendar year, 2 emergency calls"]
[null,"Travel and accommodation for technician",0,0,{"$f":"D37*C37","v":0},"For emergency visits only (1/year)"]
[null,"BD BBL™ air filters, rectangular, 2 packs (1 each year)",0,0,{"$f":"D38*C38","v":0}]
[null,"BD BBL™ Calibrator Kit (for 1 drawer)",0,0,{"$f":"D39*C39","v":0}]
[null,"Sub-total",null,null,{"$f":"SUM(E36:E39)","v":0}]
[]
[]
[null,"BD MAX MDR-TB",0]
[null,null,0,0,{"$f":"D44*C44","v":0}]
[null,null,0,0,{"$f":"D45*C45","v":0}]
[null,"Sub-total",null,null,{"$f":"SUM(E44:E45)","v":0}]
[]
[null,"FluoroType MTBDR VER 2.0",0]
[null,null,0,0,{"$f":"D49*C49","v":0}]
[null,null,0,0,{"$f":"D50*C50","v":0}]
[null,"Sub-total",null,null,{"$f":"SUM(E49:E50)","v":0}]
[]
[null,"Cobas®️ MTB and MTB-RIF-INH",0]
[null,null,0,0,{"$f":"D54*C54","v":0}]
[null,null,0,0,{"$f":"D55*C55","v":0}]
[null,"Sub-total",null,null,{"$f":"SUM(E54:E55)","v":0}]
[]
[null,"Abbott RT MTB and MTB RIF-INH",0]
[null,null,0,0,{"$f":"D59*C59","v":0}]
[null,null,0,0,{"$f":"D60*C60","v":0}]
[null,"Sub-total",null,null,{"$f":"SUM(E59:E60)","v":0}]
[]
["GDF code","GeneXpert 4-module",0,"Unit cost (US$)*    GDF catalogue prices"]
["WX04RG12","1-year warranty extension",0,2898,{"$f":"D64*C64","v":0},"Warranty includes 1 Xpert Check kit for year 1; therefore, another kit must be ordered separately for year 2."]
["WX04RG36","3-year warranty extension",0,7902,{"$f":"D65*C65","v":0},"This warranty includes Xpert Check kits for years 1, 2, 3 and 4; therefore, another kit must be ordered separately for year 5."]
["WX04UP36","3-year warranty extension, ordered with system",0,6840,{"$f":"D66*C66","v":0},"This warranty includes Xpert Check kits for years 1, 2, 3 and 4; therefore, another kit must be ordered separately for year 5."]
["XPERTCHECKCE-5","XpertCheck Calibration Pack for GeneXpert GX-IV 4-Module system",0,450,0,"An XpertCheck pack should be ordered when ordering a new GeneXpert system without a 3-year warranty extension (WX04UP36). The packs will be used after year 1, during the initial free 2-year warranty."]
["700-4510","Dust filter for GeneXpert system",0,350,0,"Additional filter required for dusty environments\nProduct linked to all Xpert systems"]
["GXIV-Module","Additional or replacement GeneXpert module",0,3360,0]
["GX-SWAP-1","1 module replacement ",0,900,0]
[null,"Upgrade to 10-colour instrument",0,0,{"$f":"D71*C71","v":0}]
[null,"Travel and accommodation of technician",0,0,{"$f":"D72*C72","v":0}]
[null,"Sub-total",null,null,{"$f":"SUM(E64:E72)","v":0}]
[]
["GDF code","GeneXpert 2-module",0,"Unit cost (US$)*    GDF catalogue prices"]
["WX02RG12","1-year warranty extension",0,1896,{"$f":"D76*C76","v":0},"This warranty includes 1 Xpert Check kit for year 1; therefore, another kit must be ordered separately for year 2."]
["WX02RG36","3-year warranty extension",0,5184,{"$f":"D77*C77","v":0},"This warranty includes the Xpert Check kits for year 1, 2, 3 and 4; therefore, another kit must be ordered separately for year 5."]
["WX02UP36","3-year warranty extension- ordered with System",0,4500,{"$f":"D78*C78","v":0},"This warranty includes the Xpert Check kits for year 1, 2, 3 and 4; therefore, another kit must be ordered separately for year 5."]
["XPERTCHECKCE-5","XpertCheck Calibration Pack for GeneXpert GX-IV 4-Module system",0,450,0,"An XpertCheck pack should be ordered when ordering a new GeneXpert system without a 3-year warranty extension (WX04UP36). The packs will be used after year 1, during the initial free 2-year warranty."]
["700-4510","Dust filter for GeneXpert system",0,350,0,"Additional filter required for dusty environments\nProduct linked to all Xpert systems"]
["GXIV-Module","Additional or replacement GeneXpert Module",0,3360,0]
["GX-SWAP-1","1 Module replacement ",0,900,0]
[null,"Upgrade to 10-colour instrument",0,0,{"$f":"D83*C83","v":0}]
[null,"Travel and accommodation of technician",0,0,{"$f":"D84*C84","v":0}]
[null,"Sub-total",null,null,{"$f":"SUM(E76:E84)","v":0}]
[]
["GDF code","GeneXpert 16-module",0,"Unit cost (US$)*    GDF catalogue prices",null,"This warranty includes 1 Xpert Check kit for year 1; therefore, another kit must be ordered separately for year 2."]
["WV16RG12","1-year warranty extension",0,7800,{"$f":"D88*C88","v":0},"This warranty includes the Xpert Check kits for year 1, 2, 3 and 4; therefore, another kit must be ordered separately for year 5."]
["WX16RG36","3-year warranty extension",0,20898,{"$f":"D89*C89","v":0},"This warranty includes the Xpert Check kits for year 1, 2, 3 and 4; therefore, another kit must be ordered separately for year 5."]
["WX16UP36","3-year warranty extensionmordered with system",0,18504,{"$f":"D90*C90","v":0},"An XpertCheck pack should be ordered when ordering a new GeneXpert system without a 3-year warranty extension (WX04UP36). The packs will be used after year 1, during the initial free 2-year warranty."]
["XPERTCHECKCE-5","XpertCheck Calibration Pack for GeneXpert GX-IV 4-Module system",0,450,0,"Additional filter required for dusty environments\nProduct linked to all Xpert systems"]
["700-4510","Dust filter for GeneXpert system",0,350,0]
["GXIV-Module","Additional or replacement GeneXpert module",0,3360,0]
["GX-SWAP-1","1 module replacement ",0,900,0]
[null,"Upgrade to 10-colour instrument",0,0,0]
[null,"Travel and accommodation of technician",0,0,{"$f":"D96*C96","v":0}]
[null,"Sub-total",null,null,{"$f":"SUM(E88:E96)","v":0}]
[]
["GDF code","Truenat",0,"Unit cost (US$)*    GDF catalogue prices",null,"Comprehensive maintenance contract includes:                                                                                                                                                           - Remote assistance and visit from service engineer if necessary\n- Repair and replacement of  parts. If a machine is not reparable on site, a stand-by machine will be provided. If the machine must be replaced, a free replacement will be provided at Molbio's cost\n- In-country travel and labour of company's local agent"]
[106702,"Truelab and Trueprep extended warranty for 1 year",0,1220,{"$f":"D100*C100","v":0},"Comprehensive maintenance contract includes:                                                                                                                                                           - Remote assistance and visit from service engineer if necessary\n- Repair and replacement of  parts. If a machine is not reparable on site, a stand-by machine will be provided. If the machine must be replaced, a free replacement will be provided at Molbio's cost\n- In-country travel and labour of company's local agent\n- Calibration chips and material used as service items"]
[106703,"Truelab and Trueprep extended warranty for 2 years",0,2240,{"$f":"D101*C101","v":0},"Comprehensive maintenance contract includes:                                                                                                                                                           - Remote assistance and visit from service engineer if necessary\n- Repair and replacement of  parts. If a machine is not reparable on site, a stand-by machine will be provided. If the machine must be replaced, a free replacement will be provided at Molbio's cost\n- In-country travel and labour of company's local agent"]
[106704,"Truelab and Trueprep extended warranty for 3 years",0,3360,0,"Comprehensive maintenance contract includes:                                                                                                                                                           - Remote assistance and visit from service engineer if necessary\n- Repair and replacement of  parts. If a machine is not reparable on site, a stand-by machine will be provided. If the machine must be replaced, a free replacement will be provided at Molbio's cost\n- In-country travel and labour of company's local agent"]
[106705,"Truelab and Trueprep extended warranty for 4 years",0,4480,0,"Comprehensive maintenance contract includes:                                                                                                                                                           - Remote assistance and visit from service engineer if necessary\n- Repair and replacement of  parts. If a machine is not reparable on site, a stand-by machine will be provided. If the machine must be replaced, a free replacement will be provided at Molbio's cost\n- In-country travel and labour of company's local agent"]
[106706,"Truelab and Trueprep extended warranty for 5 years",0,5600,0]
[null,"Sub-total",null,null,{"$f":"SUM(E100:E104)","v":0}]
[]
["GDF code","TB-LAMP",0,"Unit cost (US$)*    GDF catalogue prices",null,"• 1 year checking of on-site conditions\n• Extensive cleaning of working area, instrument surface, heating blocks and fluorescence reading unit according to maintenance checklist\n• Inspection and validation of UPS and power connections\n• Temperature check and verification that the incubation and reaction block  reach the target temperature according to the maintenance checklist\n• Performance of maintenance test kit to assure the instrument is working properly according to operation qualification (OQ)\n• Necessary equipment and test kit to perform the OQ\n• Issue of OQ certificate"]
[106639,"TB-LAMP maintenance for 1 year",0,1358.5,{"$f":"D108*C108","v":0},"• Warranty extension for 1 year (on-site) if the maintenance is done before the first warranty period ends and a copy of the filled maintenance checklist is returned to HUMAN.\n• Extensive cleaning of working area, instrument surface, heating blocks and fluorescence reading unit according to maintenance checklist\n• Inspection and validation of UPS and power connections\n• Temperature check and verification that the incubation and reaction block are reaching the target temperature according to the maintenance checklist\n• Performance of maintenance test kit to ensure that the instrument is working properly according to operation qualification (OQ)\n• Necessary quipment and test kit to perform OQ\n• Issue of OQ certificate"]
[106640,"Maintenance with warranty extension for TB-LAMP",0,1842.5,{"$f":"D109*C109","v":0}]
[null,"Sub-total",null,null,{"$f":"SUM(E108:E109)","v":0}]
[]
[]
[null,"LIS",0]
[null,"Service contract for 1 year",0,0,{"$f":"D114*C114","v":0}]
[null,"Travel and accommodation of technician",0,0,{"$f":"D115*C115","v":0}]
[null,"Sub-total",null,null,{"$f":"SUM(E93:E115)","v":0}]
[]
[]
[null,"Ventilation system C/DST laboratory",0]
[null,"Service contract for 1 year",0,0,{"$f":"D120*C120","v":0}]
[null,"Spare parts",0,0,{"$f":"D121*C121","v":0}]
[null,"Travel and accommodation of technician",0,0,{"$f":"D122*C122","v":0}]
[null,"Sub-total",null,null,{"$f":"SUM(E120:E122)","v":0}]
[]
[null,"Total cost of maintenance (US$)",null,null,{"$f":"E10+E27+E33+E40+E46+E51+E56+E61+E73+E85+E97+E105+E110+E116+E123+E15+E21","v":0}]
[]
[]
[]
[null,"Costs of equipment repair (with and without service contracts)",null,null,null,"Costs of repair (10% of value)"]
["GDF code","Equipment","No. of units","Unit cost (US$)*    GDF catalogue prices","Value of equipment (US$)",{"$f":"E131*10%","v":0}]
[106535,"Binocular bright field microscope - ZN ",0,921.09,{"$f":"C131*D131","v":0},0]
[106629,"Reflecting mirror for bright field microscope - ZN",0,12.82,0,0]
[106533,"Microscope - battery supply unit",0,94.11,0,0]
[106531,"LED microscope (basic configuration)",0,1503.8,0,0]
[106532,"LED microscope - light mirror",0,24,0,0]
[106475,"Slide warmer",0,1056.75,0,0]
[106709,"UPS - 3000 VA - 2100 W with battery pack",0,1933.5,0,0]
[106710,"Battery pack set for UPS 3000 VA",0,2364.8000000000002,0,0]
[106016,"Printer for BACTEC",0,532,null,0]
[106248,"Perforated stainless-steel shelf",0,183,null,0]
[106451,"Densitometer",0,699.05,0,0]
[106729,"Compact orbital shaker (for BSC)",0,853.6,0,0]
[106220,"Overhead stirrer with universal adapter",0,1891.55,0,0]
[106048,"Microlitre centrifuge",0,2034.75,0,0]
[106729,"Digital orbital shaker",0,853.6,0,0]
[106257,"Universal oven, 32 L",0,1306.55,0,0]
[106224,"Refrigerated bench-top centrifuge",0,6060.3,0,0]
[106225,"4-place swing-out rotor",0,948.7,0,0]
[106226,"Rotor buckets ",0,589.25,0,0]
[106227,"Aerosol tight lids for rotor buckets ",0,174.2,0,0]
[106228,"Reducing adapter for 50-mL tubes",0,327.14999999999998,0,0]
[106229,"Reducing adapter for 15- or 12-mL tubes",0,327.14999999999998,0,0]
[106732,"Thermoblock / thermo heater",0,1489.45,0,{"$f":"E154*10%","v":0}]
[106064,"GT-Blot 48 ",0,{"$f":"14352*E2","v":0},{"$f":"C154*D154","v":0},0]
[106438,"GT-Blot 48 tray for 96 strips (black) ",0,{"$f":"2.9*E2","v":0},0,0]
[106613,"GTQ-Cycler 96 ",0,{"$f":"4595*E2","v":0},0,0]
[106707,"UPS - 700 VA - 500 W with battery pack",0,761.15,0,0]
[106708,"Battery pack for UPS 700VA",0,1749.3,0,0]
[106595,"Voltage stabilizer 2000 W",0,255.95,0,0]
[106099,"Laboratory oven, 256 L",0,3530.65,0,0]
[106100,"Shelves for laboratory oven, 256 L",0,111,0,0]
[106101,"Laboratory washer-disinfecter ",0,7984.9,0,0]
[106102,"Washer-disinfecter 1/2 insert",0,2014.25,0,0]
[106103,"1/2 insert for baskets",0,432,0,0]
[106104,"Upper basket / injector for nozzles  ",0,1537,0,0]
[106105,"1/4 insert, for test tubes 160 x 16",0,393,0,0]
[106138,"Inspissator for coagulation of egg-based culture media",0,4663.1499999999996,0,0]
[106127,"Fully automatic water distiller",0,1914.45,0,0]
[106137,"Glassware stand",0,48.35,0,0]
[106140,"Laboratory floor-standing refrigerator, 141 L",0,1539.4,0,0]
[106424,"Laboratory freezer, 143 L",0,1483.1,0,0]
[106142,"Deep-freezer 70 L, –50 °C to –85 °C",0,9940.1,0,0]
[106130,"Benchtop pH meter",0,458.25,0,0]
[106132,"Magnetic stirrer with heating plate",0,1224.55,0,0]
[106720,"Magnetic bars, set of 18",0,86.35,0,0]
[106733,"Laboratory blender",0,1270.95,0,0]
[106734,"Jar for laboratory blender",0,189.95,0,0]
[106128,"Electronic analytical balance for DST",0,2007.8,0,0]
[106129,"Electronic precision balance",0,285.60000000000002,0,0]
[106142,"Deep-freezer 70 L, –40 °C to –86 °C",0,15422.4,0,0]
[106719,"Stainless-steel rack for deep-freezer",0,3764.25,0,0]
[106594,"Cryo gloves",0,143.4,0,0]
[106053,"1-channel pipette, variable from 1 to 10 µL",0,204.25,0,0]
[106054,"1-channel pipette, variable from 20 to 20 µL",0,204.25,0,0]
[106055,"1-channel pipette, variable from 10 to 100 µL ",0,204.25,0,0]
[106056,"1-channel pipette, variable from 20 to 200 µL",0,204.25,0]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"SUM(F130:F193)","v":0}]
[null,"Total cost of maintenance (US$)",null,null,{"$f":"SUM(E131:E194)","v":0}]

{"sheet":"Human resources","index":24,"n_rows":214,"n_cols":8,"rows_kept":214,"cut":false,"hidden":true,"merged":[]}
[null,null,"Human Resources"]
[]
[]
[null,null,"Salary and Incentives"]
[null,null,null,"No. of staff","Annual contract amount per staff /year (USD)","% contract","Annual incentives per staff (USD)","Total annual costs (USD)"]
[null,null,"Head of laboratory",0,0,0,0,{"$f":"(D6*E6*F6)+(G6*D6)","v":0}]
[null,null,"Laboratory doctors NRL",0,0,0,0,{"$f":"(D7*E7*F7)+(G7*D7)","v":0}]
[null,null,"Laboratory technicians  NRL",0,0,0,0,0]
[null,null,"Laboratory Clerk",0,0,0,0,0]
[null,null,"Nurse assistant/Cleaner",0,0,0,0,0]
[null,null,"Microscopy supervisor",0,0,0,0,0]
[null,null,"**Program officer (liason btw program & lab)",0,0,0,0,0]
[null,null,"Total Salary & Incentives",null,null,null,null,{"$f":"SUM(H6:H12)","v":0}]
[]
[]
[null,null,"Training 1: Refresher traning microscopy for ZN and LED"]
[null,null,"Number of sessions (per year)",0]
[null,null,"Length of session (average number of days per session) ",0]
[null,null,"Number of participants (per session)",0]
[null,null,"Number of participants requiring per diems (per session)",0]
[null,null,"Number of national facilitators (average per course)",0]
[null,null,"Number of international facilitators (average per course)",0]
[]
[null,null,"Costs for participants",null,"If no budget required for any of the mentioned activities, e.g. per diem for national facilitators, manualley enter \"0\""]
[null,null,"Total per diem",{"$f":"D17*D18*D20*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total cost of transportation",{"$f":"D19*D17*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total cost of hotel ",{"$f":"D20*D18*D17*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Costs for national experts/facilitators"]
[null,null,"Total per diem ",{"$f":"D21*D17*D18*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total cost of transportation",{"$f":"D17*D21*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total cost of hotel ",{"$f":"D21*D18*D17*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Costs for international experts/facilitators"]
[null,null,"Total per diems",{"$f":"D22*D17*D18*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total daily fee ",{"$f":"D22*D18*D17*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total travel costs ",{"$f":"D22*D17*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total transportation costs",{"$f":"D22*D17*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Additional costs"]
[null,null,"Total cost of refresher and lunch ",{"$f":"(D19+D21+D22)*D18*D17*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total cost of room rental",0]
[null,null,"Total cost of stationary & training material (per sesssion)",{"$f":"D17*D19*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Other costs <specify> (typical per session)",0]
[null,null,"Total Training 1",{"$f":"SUM(D25:D41)","v":{"$error":"#REF!"}}]
[]
[null,null,"Training 2: Training for GX user (refresher and for new people)"]
[null,null,"Number of sessions (per year)",0]
[null,null,"Length of session (average number of days per session) ",0]
[null,null,"Number of participants (per session)",0]
[null,null,"Number of participants requiring per diems (per session)",0]
[null,null,"Number of national facilitators (average per course)",0]
[null,null,"Number of international facilitators (average per course)",0]
[]
[null,null,"Costs for participants",null,"If no budget required for any of the mentioned activities, e.g. per diem for national facilitators, manualley enter \"0\""]
[null,null,"Total per diem",{"$f":"D48*D46*D45*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total cost of transportation",{"$f":"D47*D45*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total cost of hotel ",{"$f":"D48*D46*D45*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Costs for national experts/facilitators"]
[null,null,"Total per diem ",{"$f":"D49*D45*D46*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total cost of transportation",{"$f":"D49*D45*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total cost of hotel ",{"$f":"D49*D46*D45*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Costs for international experts/facilitators"]
[null,null,"Total per diems",{"$f":"D50*D45*D46*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total daily fee ",{"$f":"D50*D46*D45*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total travel costs ",{"$f":"D50*D45*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total transportation costs",{"$f":"D50*D45*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Additional costs"]
[null,null,"Total cost of refresher and lunch ",{"$f":"(D47+D49+D50)*D46*D45*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total cost of room rental",0]
[null,null,"Total cost of stationary & training material (per sesssion)",{"$f":"D45*D47*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Other costs <specify> (typical per session)",0]
[null,null,"Total Training 2",{"$f":"SUM(D53:D69)","v":{"$error":"#REF!"}}]
[]
[]
[null,null,"Training 3: TB-LAMP Training  (refresher and for new people)"]
[null,null,"Number of sessions (per year)",0]
[null,null,"Length of session (average number of days per session) ",0]
[null,null,"Number of participants (per session)",0]
[null,null,"Number of participants requiring per diems (per session)",0]
[null,null,"Number of national facilitators (average per course)",0]
[null,null,"Number of international facilitators (average per course)",0]
[]
[null,null,"Costs for participants",null,"If no budget required for any of the mentioned activities, e.g. per diem for national facilitators, manualley enter \"0\""]
[null,null,"Total per diem",{"$f":"D77*D75*D74*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total cost of transportation",{"$f":"D76*D74*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total cost of hotel ",{"$f":"D77*D75*D74*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Costs for national experts/facilitators"]
[null,null,"Total per diem ",{"$f":"D78*D74*D75*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total cost of transportation",{"$f":"D78*D74*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total cost of hotel ",{"$f":"D78*D75*D74*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Costs for international experts/facilitators"]
[null,null,"Total per diems",{"$f":"D79*D74*D75*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total daily fee ",{"$f":"D79*D75*D74*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total travel costs ",{"$f":"D79*D74*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total transportation costs",{"$f":"D79*D74*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Additional costs"]
[null,null,"Total cost of refresher and lunch ",{"$f":"(D76+D78+D79)*D75*D74*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total cost of room rental",0]
[null,null,"Total cost of stationary & training material (per sesssion)",{"$f":"D74*D76*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Other costs <specify> (typical per session)",0]
[null,null,"Total Training 3",{"$f":"SUM(D82:D98)","v":{"$error":"#REF!"}}]
[]
[]
[null,null,"Training 4: LAM Training  (refresher and for new people)"]
[null,null,"Number of sessions (per year)",0]
[null,null,"Length of session (average number of days per session) ",0]
[null,null,"Number of participants (per session)",0]
[null,null,"Number of participants requiring per diems (per session)",0]
[null,null,"Number of national facilitators (average per course)",0]
[null,null,"Number of international facilitators (average per course)",0]
[]
[null,null,"Costs for participants",null,"If no budget required for any of the mentioned activities, e.g. per diem for national facilitators, manualley enter \"0\""]
[null,null,"Total per diem",{"$f":"D106*D104*D103*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total cost of transportation",{"$f":"D105*D103*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total cost of hotel ",{"$f":"D106*D104*D103*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Costs for national experts/facilitators"]
[null,null,"Total per diem ",{"$f":"D107*D103*D104*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total cost of transportation",{"$f":"D107*D103*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total cost of hotel ",{"$f":"D107*D104*D103*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Costs for international experts/facilitators"]
[null,null,"Total per diems",{"$f":"D108*D103*D104*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total daily fee ",{"$f":"D108*D104*D103*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total travel costs ",{"$f":"D108*D103*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total transportation costs",{"$f":"D108*D103*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Additional costs"]
[null,null,"Total cost of refresher and lunch ",{"$f":"(D105+D107+D108)*D104*D103*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total cost of room rental",0]
[null,null,"Total cost of stationary & training material (per sesssion)",{"$f":"D103*D105*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Other costs <specify> (typical per session)",0]
[null,null,"Total Training 4",{"$f":"SUM(D111:D127)","v":{"$error":"#REF!"}}]
[]
[]
[null,null,"Training 5: LPA (1st and 2nd line drugs) Training  (refresher and for new people)"]
[null,null,"Number of sessions (per year)",0]
[null,null,"Length of session (average number of days per session) ",0]
[null,null,"Number of participants (per session)",0]
[null,null,"Number of participants requiring per diems (per session)",0]
[null,null,"Number of national facilitators (average per course)",0]
[null,null,"Number of international facilitators (average per course)",0]
[]
[null,null,"Costs for participants",null,"If no budget required for any of the mentioned activities, e.g. per diem for national facilitators, manualley enter \"0\""]
[null,null,"Total per diem",{"$f":"D135*D133*D132*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total cost of transportation",{"$f":"D134*D132*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total cost of hotel ",{"$f":"D135*D133*D132*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Costs for national experts/facilitators"]
[null,null,"Total per diem ",{"$f":"D136*D132*D133*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total cost of transportation",{"$f":"D136*D132*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total cost of hotel ",{"$f":"D136*D133*D132*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Costs for international experts/facilitators"]
[null,null,"Total per diems",{"$f":"D137*D132*D133*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total daily fee ",{"$f":"D137*D133*D132*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total travel costs ",{"$f":"D137*D132*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total transportation costs",{"$f":"D137*D132*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Additional costs"]
[null,null,"Total cost of refresher and lunch ",{"$f":"(D134+D136+D137)*D133*D132*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total cost of room rental",0]
[null,null,"Total cost of stationary & training material (per sesssion)",{"$f":"D132*D134*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Other costs <specify> (typical per session)",0]
[null,null,"Total Training 5",{"$f":"SUM(D140:D156)","v":{"$error":"#REF!"}}]
[]
[]
[null,null,"Training 6: Culture/DST Training  (refresher and for new people)"]
[null,null,"Number of sessions (per year)",0]
[null,null,"Length of session (average number of days per session) ",0]
[null,null,"Number of participants (per session)",0]
[null,null,"Number of participants requiring per diems (per session)",0]
[null,null,"Number of national facilitators (average per course)",0]
[null,null,"Number of international facilitators (average per course)",0]
[]
[null,null,"Costs for participants",null,"If no budget required for any of the mentioned activities, e.g. per diem for national facilitators, manualley enter \"0\""]
[null,null,"Total per diem",{"$f":"D164*D162*D161*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total cost of transportation",{"$f":"D163*D161*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total cost of hotel ",{"$f":"D164*D162*D161*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Costs for national experts/facilitators"]
[null,null,"Total per diem ",{"$f":"D165*D161*D162*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total cost of transportation",{"$f":"D165*D161*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total cost of hotel ",{"$f":"D165*D162*D161*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Costs for international experts/facilitators"]
[null,null,"Total per diems",{"$f":"D166*D161*D162*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total daily fee ",{"$f":"D166*D162*D161*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total travel costs ",{"$f":"D166*D161*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total transportation costs",{"$f":"D166*D161*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Additional costs"]
[null,null,"Total cost of refresher and lunch ",{"$f":"(D163+D165+D166)*D162*D161*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total cost of room rental",0]
[null,null,"Total cost of stationary & training material (per sesssion)",{"$f":"D161*D163*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Other costs <specify> (typical per session)",0]
[null,null,"Total Training 6",{"$f":"SUM(D169:D185)","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[null,null,"International Training <specify>"]
[null,null,"Number of sessions (per year)",0]
[null,null,"Length of session (average number of days per session) ",0]
[null,null,"Number of staff travelling for this training",0]
[]
[null,null,"Costs for participants"]
[null,null,"Total per diem",{"$f":"D194*D193*D192","v":0}]
[null,null,"Total cost of travel",{"$f":"D194*D192","v":0}]
[null,null,"Other costs <specify> registration costs",0]
[null,null,"Total costs international trainings",{"$f":"SUM(D197:D199)","v":0}]
[]
[]
[]
[]
[null,null,"Summary","Costs (USD)"]
[null,null,{"$f":"C13","v":"Total Salary & Incentives"},{"$f":"H13","v":0}]
[null,null,{"$f":"C16","v":"Training 1: Refresher traning microscopy for ZN and LED"},{"$f":"D42","v":{"$error":"#REF!"}}]
[null,null,{"$f":"C44","v":"Training 2: Training for GX user (refresher and for new people)"},{"$f":"D186","v":{"$error":"#REF!"}}]
[null,null,"Training 3: TB-LAMP Training  (refresher and for new people)",{"$f":"D99","v":{"$error":"#REF!"}}]
[null,null,"Training 4: LAM Training  (refresher and for new people)",{"$f":"D128","v":{"$error":"#REF!"}}]
[null,null,"Training 5: LPA (1st and 2nd line drugs) Training  (refresher and for new people)",{"$f":"D157","v":{"$error":"#REF!"}}]
[null,null,{"$f":"C160","v":"Training 6: Culture/DST Training  (refresher and for new people)"},{"$f":"D186","v":{"$error":"#REF!"}}]
[null,null,{"$f":"C191","v":"International Training <specify>"},{"$f":"D200","v":0}]
[null,null,"Total HR Costs",{"$f":"SUM(D206:D213)","v":{"$error":"#REF!"}}]

{"sheet":"QA","index":25,"n_rows":126,"n_cols":4,"rows_kept":126,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"Quality Assurance: Supervision, rechecking & panel testing"]
[]
[]
[]
[null,null,"Supervision visits for AFB laboratories periphery"]
[null,null,"Number of supervision visits in one year per facility",0]
[null,null,"Number of facilities to be supervised",0]
[null,null,"Length of supervision visit (average number of days)",0]
[null,null,"Number of national expert/facilitators (per supervision visit)",0]
[null,null,"Number of support staff (e.g., driver) (per supervision visit)",0]
[null,null,"Cost for fuel and lubricants (typical per visit)",0]
[null,null,"Costs for Supervision"]
[null,null,"Total Cost for fuel and lubricants",{"$f":"D8*D7*D12","v":0}]
[null,null,"Total per diem national expert/facilitators",{"$f":"D7*D8*D9*D10*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total per diem for support staff ",{"$f":"D7*D8*D9*D11*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total cost of hotel charges for staff",{"$f":"(D11+D10)*D8*D7*D9*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Other costs <specify> ",0]
[null,null,"Total costs for Supervision",{"$f":"SUM(D14:D18)","v":{"$error":"#REF!"}}]
[]
[null,null,"Supervision visits for AFB laboratories regional"]
[null,null,"Number of supervision visits in one year per facility",0]
[null,null,"Number of facilities to be supervised",0]
[null,null,"Length of supervision visit (average number of days)",0]
[null,null,"Number of national expert/facilitators (per supervision visit)",0]
[null,null,"Number of support staff (e.g., driver) (per supervision visit)",0]
[null,null,"Cost for fuel and lubricants (typical per visit)",0]
[null,null,"Costs for Supervision"]
[null,null,"Total Cost for fuel and lubricants",{"$f":"D23*D22*D27","v":0}]
[null,null,"Total per diem national expert/facilitators",{"$f":"D23*D22*D24*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total per diem for support staff ",{"$f":"D22*D23*D26*D24*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total cost of hotel charges for staff",{"$f":"(D26+D25)*D23*D22*D24*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Other costs <specify> ",0]
[null,null,"Total costs for Supervision",{"$f":"SUM(D29:D33)","v":{"$error":"#REF!"}}]
[]
[]
[null,null,"Supervision visits for culture/DST laboratories by NRL"]
[null,null,"Number of supervision visits in one year per facility",0]
[null,null,"Number of facilities to be supervised",0]
[null,null,"Length of supervision visit (average number of days)",0]
[null,null,"Number of national expert/facilitators (per supervision visit)",0]
[null,null,"Number of support staff (e.g., driver) (per supervision visit)",0]
[null,null,"Cost for fuel and lubricants (typical per visit)",0]
[]
[null,null,"Costs for Supervision"]
[null,null,"Total Cost for fuel and lubricants",{"$f":"D39*D38*D43","v":0}]
[null,null,"Total per diem national expert/facilitators",{"$f":"D42*D40*D39*D41*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total per diem for support staff ",{"$f":"D43*D40*D39*D41*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total cost of hotel charges for staff",{"$f":"(D43+D42)*D40*D39*D41*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Other costs <specify> ",0]
[null,null,"Total costs for supervision by NRL",{"$f":"SUM(D46:D50)","v":{"$error":"#REF!"}}]
[]
[]
[null,null,"Supervision visits for NRL(s) by SRL"]
[null,null,"Number of supervision visits in one year per facility",0]
[null,null,"Number of facilities to be supervised",0]
[null,null,"Length of supervision visit (average number of days of travel)",0]
[null,null,"Number of days for visit and preparation",0]
[null,null,"Number of national expert/facilitators (per supervision visit)",0]
[null,null,"Number of international experts/facilitators (per supervision visit)",0]
[]
[null,null,"Costs for national experts/facilitators"]
[null,null,"Total per diem ",0]
[null,null,"Total cost of transportation",0]
[null,null,"Total cost of hotel ",0]
[null,null,"Costs for international experts/facilitators"]
[null,null,"Total per diems",{"$f":"D60*D57*D56*D55*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total daily fee ",{"$f":"D60*D58*D56*D55*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total travel costs ",{"$f":"D60*D55*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Total transportation costs",{"$f":"D60*D55*D56*#REF!","v":{"$error":"#REF!"}}]
[null,null,"Additional costs"]
[null,null,"Other costs: Visa",0]
[null,null,"Total costs for supervision by SRL",{"$f":"SUM(D63:D70)","v":{"$error":"#REF!"}}]
[]
[]
[null,null,"Re-checking samples (NRL --> SRL)"]
[null,null,"Costs of sending slides",0]
[null,null,"Cost of sending samples of sputum",0]
[null,null,"Cost of sending samples of culture",0]
[null,null,"Cost of sending isolates from NRL to SRL (shipment costs)",0]
[null,null,"Transport containers/triple packaging",0]
[null,null,"Other costs <specify> ",0]
[null,null,"Total costs for rechecking",{"$f":"SUM(D77:D82)","v":0}]
[]
[]
[null,null,"Panel testing for GX test (NRL --> GX laboratories)"]
[null,null,"Costs of sending PT panel",0]
[null,null,"Cost of sending samples of sputum",0]
[null,null,"Cost of sending samples of culture",0]
[null,null,"Cost of sending isolates from NRL to SRL (shipment costs)",0]
[null,null,"Transport containers/triple packaging",0]
[null,null,"Other costs <specify> ",0]
[null,null,"Total costs for rechecking",{"$f":"SUM(D87:D92)","v":0}]
[]
[]
[null,null,"Panel testing culture/DST laboratories (NRL --> Regional culture/DST laboratory)"]
[null,null,"Costs of sending PT panel",0]
[null,null,"Cost of sending samples of sputum",0]
[null,null,"Cost of sending samples of culture",0]
[null,null,"Cost of sending isolates from NRL to SRL (shipment costs)",0]
[null,null,"Transport containers/triple packaging",0]
[null,null,"Other costs <specify> ",0]
[null,null,"Total costs for rechecking",0]
[]
[null,null,"Panel testing (SRL --> NRL)"]
[null,null,"Costs of sending PT panel",0]
[null,null,"Cost of sending samples of sputum",0]
[null,null,"Cost of sending samples of culture",0]
[null,null,"Cost of sending isolates from SRL to NRL (shipment costs)",0]
[null,null,"Transport containers/triple packaging",0]
[null,null,"Other costs <specify> ",0]
[null,null,"Total costs for panel testing",{"$f":"SUM(D106:D111)","v":0}]
[]
[]
[]
[]
[null,null,"Summary","Costs (USD)"]
[null,null,{"$f":"C6","v":"Supervision visits for AFB laboratories periphery"},{"$f":"D19","v":{"$error":"#REF!"}}]
[null,null,{"$f":"C21","v":"Supervision visits for AFB laboratories regional"},{"$f":"D34","v":{"$error":"#REF!"}}]
[null,null,{"$f":"C37","v":"Supervision visits for culture/DST laboratories by NRL"},{"$f":"D51","v":{"$error":"#REF!"}}]
[null,null,{"$f":"C54","v":"Supervision visits for NRL(s) by SRL"},{"$f":"D73","v":{"$error":"#REF!"}}]
[null,null,{"$f":"C76","v":"Re-checking samples (NRL --> SRL)"},{"$f":"D83","v":0}]
[null,null,{"$f":"C86","v":"Panel testing for GX test (NRL --> GX laboratories)"},{"$f":"D93","v":0}]
[null,null,{"$f":"C96","v":"Panel testing culture/DST laboratories (NRL --> Regional culture/DST laboratory)"},{"$f":"D103","v":0}]
[null,null,{"$f":"C105","v":"Panel testing (SRL --> NRL)"},{"$f":"D112","v":0}]
[null,null,"Total Quality Assurance Costs",{"$f":"SUM(D118:D125)","v":{"$error":"#REF!"}}]

{"sheet":"OPERATION","index":26,"n_rows":63,"n_cols":4,"rows_kept":63,"cut":false,"hidden":true,"merged":[]}
[]
[null,"OPERATIONAL COSTS"]
[]
[null,"Sample transportation for diagnosis"]
[]
[null,"Sample transportation for diagnosis (lower level lab --> superior lab)"]
[null,"Cost of sending samples of sputum to lower level lab --> superior lab",0]
[null,"Cost of sending isolates from NRL to SRL for testing (shipment)",0]
[null,"Transport containers/triple packaging",0]
[null,"Other costs <specify> ",0]
[null,"Total costs for sample transportation",{"$f":"SUM(C7:C10)","v":0}]
[]
[]
[null,"Shipment costs & import tax for international orders"]
[]
[null,"Import tax",0]
[null,"Custom clearance per order",0]
[null,"Number of orders / year",0]
[]
[null,"Import tax for international orders","Value of order (USD)","Import tax amount (USD)"]
[null,"Microscopy (LED, ZN)",0,{"$f":"C21*C16","v":0}]
[null,"TB-LAMP",0,{"$f":"C22*C16","v":0}]
[null,"LAM",0,{"$f":"C23*C16","v":0}]
[null,"Processing",0,{"$f":"C24*C16","v":0}]
[null,"Solid culture and DST",0,{"$f":"C25*C16","v":0}]
[null,"LPA FL&SL",0,{"$f":"C26*C16","v":0}]
[null,"Xpert MTB/RIF",0,{"$f":"C27*C16","v":0}]
[null,"ID ",0,{"$f":"C28*C16","v":0}]
[null,"Liquid culture and DST",0,{"$f":"C29*C16","v":0}]
[null,"Biosaftey and cleaning",0,{"$f":"C30*C16","v":0}]
[null,"Maintenance (calibrators and spare parts)",0,{"$f":"C31*C16","v":0}]
[null,"Total (import tax)",null,{"$f":"SUM(D24:D31)","v":0}]
[null,"Total (custom clearance)",{"$f":"C17*C18","v":0}]
[]
[null,"Shipment costs for international orders","Costs USD"]
[null,"Microscopy (LED, ZN)",0]
[null,"TB-LAMP",0]
[null,"LAM",0]
[null,"Processing",0]
[null,"Solid culture and DST",0]
[null,"LPA FL&SL",0]
[null,"Xpert MTB/RIF",0]
[null,"ID ",0]
[null,"Liquid culture and DST",0]
[null,"Biosaftey and cleaning",0]
[null,"Maintenance (calibrators and spare parts)",0]
[null,"Total ",{"$f":"SUM(C36:C46)","v":0}]
[]
[]
[null,"Other costs per 12 months"]
[]
[null,"Other operational costs","Costs USD"]
[null,"Fuel generator",0]
[null,"Electricity",0]
[null,"Request forms",0]
[null,"Registers",0]
[null,"Telephone & Internet",0]
[null,"Water",0]
[null,"Other",0]
[null,"Total ",{"$f":"SUM(C53:C59)","v":0}]
[]
[]
[null,"Sub total",{"$f":"C11+D32+C33+C47+C60","v":0}]

{"sheet":"BUDGET SUMMARY","index":27,"n_rows":59,"n_cols":8,"rows_kept":59,"cut":false,"hidden":false,"merged":[[0,0,1,6],[28,10,28,14]]}
["Annual budget overview"]
[]
[]
[null,null,"Area",null,null,null,null,"Budget Source "]
[null,null,"Reagents and consumables","Cost (US$)",null,"Total no. of tests","Cost per test","previous"]
[null,null,"ZN microscopy if consumables are procured in kit",{"$f":"IF('Intro and instructions'!B10=\"Yes\",'ZN microscopy'!C26,0)","v":0},null,{"$f":"'ZN microscopy'!C8","v":0},{"$f":"IF(F6=0,0,D6/F6)","v":0},"TB CARE I"]
[null,null,"ZN microscopy if consumables are procured separately",{"$f":"IF('Intro and instructions'!B10=\"Yes\",'ZN microscopy'!C56,0)","v":0},null,{"$f":"'ZN microscopy'!C8","v":0},{"$f":"IF(F7=0,0,D7/F7)","v":0}]
[null,null,"LED microscopy if consumables are procured in kit",{"$f":"IF('Intro and instructions'!B11=\"Yes\",'LED microscopy'!C26,0)","v":0},null,{"$f":"'LED microscopy'!C8","v":0},0]
[null,null,"LED microscopy if consumables are procured separately",{"$f":"IF('Intro and instructions'!B11=\"Yes\",'LED microscopy'!C55,0)","v":0},null,{"$f":"'LED microscopy'!C8","v":0},0]
[null,null,"TB-LAMP",{"$f":"IF('Intro and instructions'!B8=\"Yes\",'TB-LAMP'!C28,0)","v":0},null,{"$f":"'TB-LAMP'!C19","v":0},0]
[null,null,"Truenat",{"$f":"IF('Intro and instructions'!B7=\"Yes\",Truenat!C31,0)","v":0},null,{"$f":"Truenat!C21","v":0},0]
[null,null,"Xpert MTB/RIF Ultra",{"$f":"IF('Intro and instructions'!B9=\"Yes\",'Xpert MTB RIF Ultra'!C30,0)","v":0},null,{"$f":"'Xpert MTB RIF Ultra'!C21","v":0},0]
[null,null,"LAM",{"$f":"IF('Intro and instructions'!B6=\"Yes\",LAM!C26,0)","v":0},null,{"$f":"LAM!C15","v":0},0]
[null,null,"LPA 1st line",{"$f":"IF('Intro and instructions'!B13=\"Yes\",'LPA 1st line'!E56,0)","v":76.849999999999994},null,{"$f":"'LPA 1st line'!C27","v":0},0]
[null,null,"LPA 2nd line",{"$f":"IF('Intro and instructions'!B14=\"Yes\",'LPA 2nd line'!E55,0)","v":0},null,{"$f":"'LPA 2nd line'!C27","v":0},0]
[null,null,"MAX MDR-TB assay",{"$f":"IF('Intro and instructions'!B15=\"Yes\",'MAX MDR-TB assay'!E42,0)","v":76.849999999999994},null,{"$f":"'FluoroType MTBDR VER 2.0'!total_test","v":0},0]
[null,null,"FluoroType MTBDR Ver 2.0",{"$f":"IF('Intro and instructions'!B16=\"Yes\",'FluoroType MTBDR VER 2.0'!E44,0)","v":76.849999999999994},null,{"$f":"'FluoroType MTBDR VER 2.0'!total_test","v":0},0]
[null,null,"Cobas® MTB and MTB-RIF-INH",{"$f":"IF('Intro and instructions'!B17=\"Yes\",'Cobas MTB and MTB-RIF-INH'!E47,0)","v":76.849999999999994},null,{"$f":"'Cobas MTB and MTB-RIF-INH'!total_test","v":0},0]
[null,null,"Abbott RT MTB and MTB RIF-INH",{"$f":"IF('Intro and instructions'!B18=\"Yes\",'Abbott RT MTB and MTB RIF-INH'!E47,0)","v":76.849999999999994},null,{"$f":"'Abbott RT MTB and MTB RIF-INH'!total_test","v":0},0]
[null,null,"Sample processing",{"$f":"IF('Intro and instructions'!B19=\"Yes\",'Processing&solid-liquid culture'!F83,0)","v":0},null,{"$f":"IF('Processing&solid-liquid culture'!C23=0,'Processing&solid-liquid culture'!F21,'Processing&solid-liquid culture'!C23)","v":0},0]
[null,null,"Solid culture",{"$f":"IF('Intro and instructions'!B19=\"Yes\",'Processing&solid-liquid culture'!F81,0)","v":0},null,{"$f":"'Processing&solid-liquid culture'!C23","v":0},0]
[null,null,"Liquid culture",{"$f":"IF('Intro and instructions'!B19=\"Yes\",'Processing&solid-liquid culture'!F21,0)","v":0},null,{"$f":"'Processing&solid-liquid culture'!F82","v":0},0,"FIND"]
[null,null,"Culture identification",{"$f":"IF('Intro and instructions'!B20=\"Yes\",SUM(ID!E37,ID!E24),0)","v":0},null,{"$f":"ID!D13","v":0},0]
[null,null,"FL DST on LJ",{"$f":"IF('Intro and instructions'!B21=\"Yes\",'LJ 1st line DST'!C34,0)","v":0},null,{"$f":"'LJ 1st line DST'!C18","v":0},0,"FIND"]
[null,null,"SL DST on LJ",{"$f":"IF('Intro and instructions'!B22=\"Yes\",'LJ 2nd line DST'!C34,0)","v":0},null,{"$f":"'LJ 2nd line DST'!C15","v":0},0,"FIND"]
[null,null,"FL DST on MGIT",{"$f":"IF('Intro and instructions'!B23=\"Yes\",'MGIT 1st line DST'!D44,0)","v":0},null,{"$f":"'MGIT 1st line DST'!C15","v":0},0,"TB CARE I"]
[null,null,"PZA DST on MGIT",{"$f":"IF('Intro and instructions'!B23=\"Yes\",'MGIT 1st line DST'!D45,0)","v":0},null,{"$f":"'MGIT 1st line DST'!C21","v":0},0]
[null,null,"Liquid 2nd-line DST on MGIT when using ready-made lyophilized reagents",{"$f":"IF('Intro and instructions'!B24=\"Yes\",'MGIT 2nd line DST'!G30,0)","v":0},null,{"$f":"'MGIT 2nd line DST'!C17","v":0},0]
[null,null,"Liquid 2nd-line DST on MGIT when using pure drug powder reagents",{"$f":"IF('Intro and instructions'!B24=\"Yes\",'MGIT 2nd line DST'!G49,0)","v":0},null,{"$f":"'MGIT 2nd line DST'!C17","v":0},0]
[null,null,"Sub-total ",{"$f":"SUM(D6:D28)","v":384.25}]
[]
[null,null,"Cleaning and biosafety","Cost (US$)",null,null,null,"previous"]
[null,null,"Biosafety",{"$f":"IF('Intro and instructions'!B25=\"Yes\",'Biosafety and cleaning'!G44,0)","v":0},null,null,null,"FIND"]
[null,null,"Cleaning",{"$f":"IF('Intro and instructions'!B25=\"Yes\",'Biosafety and cleaning'!G43,0)","v":0},null,null,null,"FIND"]
[null,null,"Sub-total ",{"$f":"D33+D34","v":0}]
[]
[null,null,"Maintenance and repair","Cost (US$)",null,null,null,"previous"]
[null,null,{"$f":"'Maintenance & repair'!B6","v":"Biosafety cabinets"},{"$f":"IF('Intro and instructions'!B26=\"Yes\",'Maintenance & repair'!E10,0)","v":0}]
[null,null,{"$f":"'Maintenance & repair'!B11","v":"Twincubator (LPA)"},{"$f":"IF('Intro and instructions'!B26=\"Yes\",'Maintenance & repair'!E15,0)","v":0}]
[null,null,{"$f":"'Maintenance & repair'!B17","v":"Thermocycler"},{"$f":"IF('Intro and instructions'!B26=\"Yes\",'Maintenance & repair'!E21,0)","v":0}]
[null,null,{"$f":"'Maintenance & repair'!B23","v":"Laminar flow (PCR workstation)"},{"$f":"IF('Intro and instructions'!B26=\"Yes\",'Maintenance & repair'!E27,0)","v":0}]
[null,null,{"$f":"'Maintenance & repair'!B29","v":"Autoclave"},{"$f":"IF('Intro and instructions'!B26=\"Yes\",'Maintenance & repair'!E33,0)","v":0}]
[null,null,{"$f":"'Maintenance & repair'!B35","v":"BD BACTEC™ MGIT™ 960 System"},{"$f":"IF('Intro and instructions'!B26=\"Yes\",'Maintenance & repair'!E40,0)","v":0}]
[null,null,"MAX MDR-TB assay",{"$f":"IF('Intro and instructions'!B26=\"Yes\",'Maintenance & repair'!E46,0)","v":0}]
[null,null,"FluoroType MTBDR VER 2.0",{"$f":"IF('Intro and instructions'!B26=\"Yes\",'Maintenance & repair'!E51,0)","v":0}]
[null,null,"Cobas® MTB and MTB-RIF-INH",{"$f":"IF('Intro and instructions'!B26=\"Yes\",'Maintenance & repair'!E56,0)","v":0}]
[null,null,"Abott RT MTB and MTB RIF-INH",{"$f":"IF('Intro and instructions'!B26=\"Yes\",'Maintenance & repair'!E61,0)","v":0}]
[null,null,{"$f":"'Maintenance & repair'!B63","v":"GeneXpert 4-module"},{"$f":"IF('Intro and instructions'!B26=\"Yes\",'Maintenance & repair'!E73,0)","v":0}]
[null,null,{"$f":"'Maintenance & repair'!B75","v":"GeneXpert 2-module"},{"$f":"IF('Intro and instructions'!B26=\"Yes\",'Maintenance & repair'!E85,0)","v":0}]
[null,null,{"$f":"'Maintenance & repair'!B87","v":"GeneXpert 16-module"},{"$f":"IF('Intro and instructions'!B26=\"Yes\",'Maintenance & repair'!E97,0)","v":0}]
[null,null,"Truenat",{"$f":"IF('Intro and instructions'!B26=\"Yes\",'Maintenance & repair'!E105,0)","v":0}]
[null,null,{"$f":"'Maintenance & repair'!B107","v":"TB-LAMP"},{"$f":"IF('Intro and instructions'!B26=\"Yes\",'Maintenance & repair'!E110,0)","v":0}]
[null,null,{"$f":"'Maintenance & repair'!B113","v":"LIS"},{"$f":"IF('Intro and instructions'!B26=\"Yes\",'Maintenance & repair'!E116,0)","v":0}]
[null,null,{"$f":"'Maintenance & repair'!B119","v":"Ventilation system C/DST laboratory"},{"$f":"IF('Intro and instructions'!B26=\"Yes\",'Maintenance & repair'!E123,0)","v":0}]
[null,null,"Repair and other equipment",{"$f":"IF('Intro and instructions'!B26=\"Yes\",'Maintenance & repair'!F194,0)","v":0},null,null,null,"PFH"]
[null,null,"Sub-total ",{"$f":"SUM(D38:D55)","v":0}]
[]
[]
[null,null,"Total annual budget",{"$f":"SUM(D30,D35,D56)","v":384.25}]

{"sheet":"LAB ITEM SUMMARY ","index":28,"n_rows":284,"n_cols":6,"rows_kept":284,"cut":false,"hidden":false,"merged":[[268,1,268,3],[192,1,192,3],[211,1,211,3],[242,1,242,3],[170,1,170,3],[183,1,183,3],[254,1,254,3],[161,1,161,3],[0,0,1,4],[5,1,5,3],[21,1,21,3],[36,1,36,3],[40,1,40,3],[43,1,43,3],[47,1,47,3],[51,1,51,3],[76,1,76,3],[100,1,100,3],[112,1,112,3],[125,1,125,3],[143,1,143,3]]}
["Overview of laboratory items"]
[]
[]
[null,null,"Area",null,null,"Budget Source "]
[null,"GDF code","Reagents & consumables","Qty",null,"previous"]
[null,"ZN microscopy ",null,null,null,"TB CARE I"]
[null,{"$f":"'ZN microscopy'!A22","v":106522},"ZN Kit",{"$f":"'ZN microscopy'!F22","v":0}]
[null,{"$f":"'ZN microscopy'!A32","v":106601},{"$f":"'ZN microscopy'!B32","v":"Basic fuchsine, 100 g (bottle)"},{"$f":"'ZN microscopy'!D32","v":0}]
[null,{"$f":"'ZN microscopy'!A33","v":106602},{"$f":"'ZN microscopy'!B33","v":"Methylene blue, 10 x 10 g (bottles)"},{"$f":"'ZN microscopy'!D33","v":0}]
[null,{"$f":"'ZN microscopy'!A34","v":106599},{"$f":"'ZN microscopy'!B34","v":"Phenol crystals, colourless, 500 g"},{"$f":"'ZN microscopy'!D34","v":0}]
[null,{"$f":"'ZN microscopy'!A35","v":106597},{"$f":"'ZN microscopy'!B35","v":"Ethanol, 99%, 1 L (bottle), for stain solutions"},{"$f":"'ZN microscopy'!D35","v":0}]
[null,{"$f":"'ZN microscopy'!A36","v":106597},{"$f":"'ZN microscopy'!B36","v":"Ethanol, 99%, 1 L (bottle), for decolourization"},{"$f":"'ZN microscopy'!D36","v":0}]
[null,{"$f":"'ZN microscopy'!A37","v":106603},{"$f":"'ZN microscopy'!B37","v":"Hydrochloric acid, 1 L (bottle)"},{"$f":"'ZN microscopy'!D37","v":0}]
[null,{"$f":"'ZN microscopy'!A43","v":106655},{"$f":"'ZN microscopy'!B43","v":"Wooden applicator sticks, 150 mm"},{"$f":"'ZN microscopy'!D43","v":0}]
[null,{"$f":"'ZN microscopy'!A44","v":106609},{"$f":"'ZN microscopy'!B44","v":"Microscope slides, lime-soda-glass, pack of 1000"},{"$f":"'ZN microscopy'!D44","v":0}]
[null,{"$f":"'ZN microscopy'!A45","v":106627},{"$f":"'ZN microscopy'!B45","v":"Immersion oil, 100 mL"},{"$f":"'ZN microscopy'!D45","v":0}]
[null,{"$f":"'ZN microscopy'!A46","v":106656},{"$f":"'ZN microscopy'!B46","v":"Lens-cleaning tissue"},{"$f":"'ZN microscopy'!D46","v":0}]
[null,{"$f":"'ZN microscopy'!A47","v":106354},{"$f":"'ZN microscopy'!B47","v":"Round filter paper, 150 mm"},{"$f":"'ZN microscopy'!D47","v":0}]
[null,{"$f":"'ZN microscopy'!A48","v":106597},{"$f":"'ZN microscopy'!B48","v":"Ethanol, 99%, 1 L (bottle), for spirit lamps"},{"$f":"'ZN microscopy'!D48","v":0}]
[null,{"$f":"'ZN microscopy'!A49","v":106355},{"$f":"'ZN microscopy'!B49","v":"Marker pen (water-resistant)"},{"$f":"'ZN microscopy'!D49","v":0}]
[null,{"$f":"'ZN microscopy'!A50","v":106525},{"$f":"'ZN microscopy'!B50","v":"Sputum containers, pack of 1000"},{"$f":"'ZN microscopy'!D50","v":0}]
[null,"LED microscopy if consumables are procured in kit"]
[null,{"$f":"'LED microscopy'!A22","v":106523},"LED kit",{"$f":"'LED microscopy'!F22","v":0}]
[null,{"$f":"'LED microscopy'!A32","v":106602},{"$f":"'LED microscopy'!B32","v":"Methylene blue, 10 x 10 g (bottles)"},{"$f":"'LED microscopy'!D32","v":0}]
[null,{"$f":"'LED microscopy'!A33","v":106599},{"$f":"'LED microscopy'!B33","v":"Phenol crystals colourless, 500 g"},{"$f":"'LED microscopy'!D33","v":0}]
[null,{"$f":"'LED microscopy'!A34","v":106276},{"$f":"'LED microscopy'!B34","v":"Auramine O, powder, 25 g"},{"$f":"'LED microscopy'!D34","v":0}]
[null,{"$f":"'LED microscopy'!A35","v":106597},{"$f":"'LED microscopy'!B35","v":"Ethanol, 99%, 1 L (bottle), for decolourization"},{"$f":"'LED microscopy'!D35","v":0}]
[null,{"$f":"'LED microscopy'!A36","v":106603},{"$f":"'LED microscopy'!B36","v":"Hydrochloric acid, 1 L (bottle)"},{"$f":"'LED microscopy'!D36","v":0}]
[null,{"$f":"'LED microscopy'!A42","v":106655},{"$f":"'LED microscopy'!B42","v":"Wooden applicator sticks, 150 mm"},{"$f":"'LED microscopy'!D42","v":0}]
[null,{"$f":"'LED microscopy'!A43","v":106609},{"$f":"'LED microscopy'!B43","v":"Microscope slides, lime-soda-glass, pack of 1000"},{"$f":"'LED microscopy'!D43","v":0}]
[null,{"$f":"'LED microscopy'!A44","v":106627},{"$f":"'LED microscopy'!B44","v":"Immersion oil, 100 mL"},{"$f":"'LED microscopy'!D44","v":0}]
[null,{"$f":"'LED microscopy'!A45","v":106656},{"$f":"'LED microscopy'!B45","v":"Lens-cleaning tissue"},{"$f":"'LED microscopy'!D45","v":0}]
[null,{"$f":"'LED microscopy'!A46","v":106354},{"$f":"'LED microscopy'!B46","v":"Round filter paper, 150 mm"},{"$f":"'LED microscopy'!D46","v":0}]
[null,{"$f":"'LED microscopy'!A47","v":106597},{"$f":"'LED microscopy'!B47","v":"Ethanol, 99%, 1 L (bottle), for spirit lamps"},{"$f":"'LED microscopy'!D47","v":0}]
[null,{"$f":"'LED microscopy'!A48","v":106355},{"$f":"'LED microscopy'!B48","v":"Marker pen (water-resistant)"},{"$f":"'LED microscopy'!D48","v":0}]
[null,{"$f":"'LED microscopy'!A49","v":106525},{"$f":"'LED microscopy'!B49","v":"Sputum containers, pack of 1000"},{"$f":"'LED microscopy'!D49","v":0}]
[null,"TB-LAMP"]
[null,{"$f":"'TB-LAMP'!A23","v":106634},{"$f":"'TB-LAMP'!B23","v":"Loopamp MTBC Detection Kit (2 x 48 tests)"},{"$f":"'TB-LAMP'!E23","v":0}]
[null,{"$f":"'TB-LAMP'!A24","v":106635},{"$f":"'TB-LAMP'!B24","v":"Loopamp PURE DNA Extraction Kit (90 tests)"},{"$f":"'TB-LAMP'!E24","v":0}]
[null,{"$f":"'TB-LAMP'!A25","v":106643},{"$f":"'TB-LAMP'!B25","v":"Pipette-60 set for TB LAMP (4 x 96 tests)"},{"$f":"'TB-LAMP'!E25","v":0}]
[null,"Truenat"]
[null,{"$f":"Truenat!A27","v":106697},{"$f":"Truenat!B27","v":"Truenat MTB  Plus"},{"$f":"Truenat!D27","v":0}]
[null,{"$f":"Truenat!A28","v":106700},{"$f":"Truenat!B28","v":"Truenat MTB Rif"},{"$f":"Truenat!D28","v":0}]
[null,"Xpert MTB/RIF Ultra"]
[null,{"$f":"'Xpert MTB RIF Ultra'!A25","v":"CGXMTB-RIF-50"},{"$f":"'Xpert MTB RIF Ultra'!B25","v":"Xpert MTB/RIF cartridges"},{"$f":"'Xpert MTB RIF Ultra'!D25","v":0}]
[null,{"$f":"'Xpert MTB RIF Ultra'!A26","v":106340},{"$f":"'Xpert MTB RIF Ultra'!B26","v":"Sterile plastic centrifuge tubes 50 mL"},{"$f":"'Xpert MTB RIF Ultra'!D26","v":0}]
[null,{"$f":"'Xpert MTB RIF Ultra'!A27","v":106525},{"$f":"'Xpert MTB RIF Ultra'!B27","v":"Sputum containers, pack of 1000"},{"$f":"'Xpert MTB RIF Ultra'!D27","v":0}]
[null,"LAM"]
[null,{"$f":"LAM!A21","v":106749},{"$f":"LAM!B21","v":"Determine TB LAM Ag tests"},{"$f":"LAM!E21","v":0}]
[null,{"$f":"LAM!A22","v":106525},{"$f":"LAM!B22","v":"Sputum containers"},{"$f":"LAM!E22","v":0}]
[null,{"$f":"LAM!A23","v":106388},{"$f":"LAM!B23","v":"Sterile pipette filter tips, 5–100 µL"},{"$f":"LAM!E23","v":0}]
[null,"LPA 1st line"]
[null,{"$f":"'LPA 1st line'!B30","v":106682},{"$f":"'LPA 1st line'!C30","v":"Genoscholar NTM+MDRTB II"},{"$f":"'LPA 1st line'!E30","v":0}]
[null,{"$f":"'LPA 1st line'!B31","v":106512},{"$f":"'LPA 1st line'!C31","v":"Geno Type MTBDRplus (96 tests/kit), Version 2.0 (30496A)   "},{"$f":"'LPA 1st line'!E31","v":0}]
[null,{"$f":"'LPA 1st line'!B32","v":106477},{"$f":"'LPA 1st line'!C32","v":"GenoLyse (96 tests), Version 1.0 (51610)"},{"$f":"'LPA 1st line'!E32","v":0}]
[null,{"$f":"'LPA 1st line'!B33","v":106254},{"$f":"'LPA 1st line'!C33","v":"Molecular grade water - 10 x 1.7 mL"},{"$f":"'LPA 1st line'!E33","v":0}]
[null,{"$f":"'LPA 1st line'!B34","v":106385},{"$f":"'LPA 1st line'!C34","v":"PCR tubes, 0.2 mL with attached caps, sterile, DNAse- and RNAse-free, 1000 per pack"},{"$f":"'LPA 1st line'!E34","v":0}]
[null,{"$f":"'LPA 1st line'!B35","v":106422},{"$f":"'LPA 1st line'!C35","v":"Microcentrifuge tubes, 2 mL"},{"$f":"'LPA 1st line'!E35","v":0}]
[null,{"$f":"'LPA 1st line'!B36","v":106421},{"$f":"'LPA 1st line'!C36","v":"Microcentrifuge tubes, 1.5 mL"},{"$f":"'LPA 1st line'!E36","v":0}]
[null,{"$f":"'LPA 1st line'!B37","v":106383},{"$f":"'LPA 1st line'!C37","v":"Sterile cryovials, 2 mL, single handed"},{"$f":"'LPA 1st line'!E37","v":0}]
[null,{"$f":"'LPA 1st line'!B38","v":106554},{"$f":"'LPA 1st line'!C38","v":"Sterile filter tips,  0.1–10 µL"},{"$f":"'LPA 1st line'!E38","v":0}]
[null,{"$f":"'LPA 1st line'!B39","v":106389},{"$f":"'LPA 1st line'!C39","v":"Sterile filter tips, 20–200 µL"},{"$f":"'LPA 1st line'!E39","v":0}]
[null,{"$f":"'LPA 1st line'!B40","v":106390},{"$f":"'LPA 1st line'!C40","v":"Sterile filter tips, 100–1000 µL"},{"$f":"'LPA 1st line'!E40","v":0}]
[null,{"$f":"'LPA 1st line'!B41","v":106412},{"$f":"'LPA 1st line'!C41","v":"Long 1-mL tips with filter "},{"$f":"'LPA 1st line'!E41","v":0}]
[null,{"$f":"'LPA 1st line'!B42","v":106398},{"$f":"'LPA 1st line'!C42","v":"Dispenser tips, 12.5 mL "},{"$f":"'LPA 1st line'!E42","v":0}]
[null,{"$f":"'LPA 1st line'!B43","v":106434},{"$f":"'LPA 1st line'!C43","v":"Non-sterile Pasteur pipettes, 3 mL "},{"$f":"'LPA 1st line'!E43","v":0}]
[null,{"$f":"'LPA 1st line'!B44","v":106556},{"$f":"'LPA 1st line'!C44","v":"Sterile plastic laboratory forceps "},{"$f":"'LPA 1st line'!E44","v":0}]
[null,{"$f":"'LPA 1st line'!B45","v":106355},{"$f":"'LPA 1st line'!C45","v":"Permanent marker"},{"$f":"'LPA 1st line'!E45","v":0}]
[null,{"$f":"'LPA 1st line'!B46","v":106384},{"$f":"'LPA 1st line'!C46","v":"Sterile plastic centrifuge tubes, 15 mL"},{"$f":"'LPA 1st line'!E46","v":0}]
[null,{"$f":"'LPA 1st line'!B47","v":106340},{"$f":"'LPA 1st line'!C47","v":"Sterile plastic centrifuge tubes, 50 mL"},{"$f":"'LPA 1st line'!E47","v":0}]
[null,{"$f":"'LPA 1st line'!B48","v":106444},{"$f":"'LPA 1st line'!C48","v":"Plastic bags, 30 L"},{"$f":"'LPA 1st line'!E48","v":0}]
[null,{"$f":"'LPA 1st line'!B49","v":106415},{"$f":"'LPA 1st line'!C49","v":"Square filter paper, 580 mm"},{"$f":"'LPA 1st line'!E49","v":0}]
[null,{"$f":"'LPA 1st line'!B50","v":106439},{"$f":"'LPA 1st line'!C50","v":"GT-Blot 48 reagent set"},{"$f":"'LPA 1st line'!E50","v":0}]
[null,{"$f":"'LPA 1st line'!B51","v":106438},{"$f":"'LPA 1st line'!C51","v":"GT-Blot 48 tray for 96 strips (black)"},{"$f":"'LPA 1st line'!E51","v":0}]
[null,{"$f":"'LPA 1st line'!B52","v":106755},{"$f":"'LPA 1st line'!C52","v":"Paper towels"},{"$f":"'LPA 1st line'!E52","v":53}]
[null,{"$f":"'LPA 1st line'!B53","v":106333},{"$f":"'LPA 1st line'!C53","v":"Ethanol / Isopropanol - 5 L"},{"$f":"'LPA 1st line'!E53","v":0}]
[null,"LPA 2nd line"]
[null,{"$f":"'LPA 2nd line'!B30","v":106513},{"$f":"'LPA 2nd line'!C30","v":"Geno Type MTBDRsl (96 tests/kit), Version 2.0 (30496A)   "},{"$f":"'LPA 2nd line'!kit_ordered","v":0}]
[null,{"$f":"'LPA 2nd line'!B31","v":106477},{"$f":"'LPA 2nd line'!C31","v":"GenoLyse (96 tests), Version 1.0 (51610)"},{"$f":"'LPA 2nd line'!kit_ordered","v":0}]
[null,{"$f":"'LPA 2nd line'!B32","v":106254},{"$f":"'LPA 2nd line'!C32","v":"Molecular-grade water - 10 x 1.7 mL"},{"$f":"'LPA 2nd line'!kit_ordered","v":0}]
[null,{"$f":"'LPA 2nd line'!B33","v":106385},{"$f":"'LPA 2nd line'!C33","v":"PCR tubes, 0.2 mL with attached caps, sterile, DNAse- RNAse-free, 1000 per pack"},{"$f":"'LPA 2nd line'!kit_ordered","v":0}]
[null,{"$f":"'LPA 2nd line'!B34","v":106422},{"$f":"'LPA 2nd line'!C34","v":"Microcentrifuge tubes, 2 mL"},{"$f":"'LPA 2nd line'!kit_ordered","v":0}]
[null,{"$f":"'LPA 2nd line'!B35","v":106421},{"$f":"'LPA 2nd line'!C35","v":"Microcentrifuge tubes, 1.5 mL"},{"$f":"'LPA 2nd line'!kit_ordered","v":0}]
[null,{"$f":"'LPA 2nd line'!B36","v":106383},{"$f":"'LPA 2nd line'!C36","v":"Sterile cryovials, 2 mL, single handed"},{"$f":"'LPA 2nd line'!kit_ordered","v":0}]
[null,{"$f":"'LPA 2nd line'!B37","v":106554},{"$f":"'LPA 2nd line'!C37","v":"Sterile filter tips, 0.1–10 µL"},{"$f":"'LPA 2nd line'!kit_ordered","v":0}]
[null,{"$f":"'LPA 2nd line'!B38","v":106389},{"$f":"'LPA 2nd line'!C38","v":"Sterile filter tips, 20–200 µL"},{"$f":"'LPA 2nd line'!kit_ordered","v":0}]
[null,{"$f":"'LPA 2nd line'!B39","v":106390},{"$f":"'LPA 2nd line'!C39","v":"Sterile filter tips, 100–1000 µL"},{"$f":"'LPA 2nd line'!kit_ordered","v":0}]
[null,{"$f":"'LPA 2nd line'!B40","v":106412},{"$f":"'LPA 2nd line'!C40","v":"Long 1-mL tips with filter "},{"$f":"'LPA 2nd line'!kit_ordered","v":0}]
[null,{"$f":"'LPA 2nd line'!B41","v":106398},{"$f":"'LPA 2nd line'!C41","v":"Dispenser tips, 12.5 mL "},{"$f":"'LPA 2nd line'!kit_ordered","v":0}]
[null,{"$f":"'LPA 2nd line'!B42","v":106434},{"$f":"'LPA 2nd line'!C42","v":"Non-sterile Pasteur pipettes, 3 mL"},{"$f":"'LPA 2nd line'!kit_ordered","v":0}]
[null,{"$f":"'LPA 2nd line'!B43","v":106556},{"$f":"'LPA 2nd line'!C43","v":"Sterile plastic laboratory forceps "},{"$f":"'LPA 2nd line'!kit_ordered","v":0}]
[null,{"$f":"'LPA 2nd line'!B44","v":106355},{"$f":"'LPA 2nd line'!C44","v":"Permanent marker"},{"$f":"'LPA 2nd line'!kit_ordered","v":0}]
[null,{"$f":"'LPA 2nd line'!B45","v":106384},{"$f":"'LPA 2nd line'!C45","v":"Sterile plastic centrifuge tubes, 15 mL"},{"$f":"'LPA 2nd line'!kit_ordered","v":0}]
[null,{"$f":"'LPA 2nd line'!B46","v":106340},{"$f":"'LPA 2nd line'!C46","v":"Sterile plastic centrifuge tubes, 50 mL"},{"$f":"'LPA 2nd line'!kit_ordered","v":0}]
[null,{"$f":"'LPA 2nd line'!B47","v":106444},{"$f":"'LPA 2nd line'!C47","v":"Plastic bags, 30 L"},{"$f":"'LPA 2nd line'!kit_ordered","v":0}]
[null,{"$f":"'LPA 2nd line'!B48","v":106415},{"$f":"'LPA 2nd line'!C48","v":"Square filter paper, 580 mm"},{"$f":"'LPA 2nd line'!kit_ordered","v":0}]
[null,{"$f":"'LPA 2nd line'!B49","v":106439},{"$f":"'LPA 2nd line'!C49","v":"GT-Blot 48 reagent set"},{"$f":"'LPA 2nd line'!kit_ordered","v":0}]
[null,{"$f":"'LPA 2nd line'!B50","v":106438},{"$f":"'LPA 2nd line'!C50","v":"GT-Blot 48 tray for 96 strips (black)"},{"$f":"'LPA 2nd line'!kit_ordered","v":0}]
[null,{"$f":"'LPA 2nd line'!B51","v":106755},{"$f":"'LPA 2nd line'!C51","v":"Paper towels"},{"$f":"'LPA 2nd line'!kit_ordered","v":0}]
[null,{"$f":"'LPA 2nd line'!B52","v":106333},{"$f":"'LPA 2nd line'!C52","v":"Ethanol / isopropanol, 5 L"},{"$f":"'LPA 2nd line'!kit_ordered","v":0}]
[null,"MAX MDR-TB assay"]
[null,{"$f":"'MAX MDR-TB assay'!B28","v":0},{"$f":"'MAX MDR-TB assay'!C28","v":"BD MAX MDR-TB kit"},{"$f":"'MAX MDR-TB assay'!kit_ordered","v":0}]
[null,{"$f":"'MAX MDR-TB assay'!B29","v":0},{"$f":"'MAX MDR-TB assay'!C29","v":"BD MAX STR kit"},{"$f":"'MAX MDR-TB assay'!kit_ordered","v":0}]
[null,{"$f":"'MAX MDR-TB assay'!B30","v":106384},{"$f":"'MAX MDR-TB assay'!C30","v":"Sterile plastic centrifuge tubes, 15 mL"},{"$f":"'MAX MDR-TB assay'!kit_ordered","v":0}]
[null,{"$f":"'MAX MDR-TB assay'!B31","v":106422},{"$f":"'MAX MDR-TB assay'!C31","v":"Microcentrifuge tubes, 2 mL"},{"$f":"'MAX MDR-TB assay'!kit_ordered","v":0}]
[null,{"$f":"'MAX MDR-TB assay'!B32","v":106554},{"$f":"'MAX MDR-TB assay'!C32","v":"Sterile filter tips,  0.1–10 µL"},{"$f":"'MAX MDR-TB assay'!kit_ordered","v":0}]
[null,{"$f":"'MAX MDR-TB assay'!B33","v":106389},{"$f":"'MAX MDR-TB assay'!C33","v":"Sterile filter tips, 20–200 µL"},{"$f":"'MAX MDR-TB assay'!kit_ordered","v":0}]
[null,{"$f":"'MAX MDR-TB assay'!B34","v":106390},{"$f":"'MAX MDR-TB assay'!C34","v":"Sterile filter tips, 100–1000 µL"},{"$f":"'MAX MDR-TB assay'!kit_ordered","v":0}]
[null,{"$f":"'MAX MDR-TB assay'!B35","v":106444},{"$f":"'MAX MDR-TB assay'!C35","v":"Plastic bags, 30 L"},{"$f":"'MAX MDR-TB assay'!kit_ordered","v":0}]
[null,{"$f":"'MAX MDR-TB assay'!B36","v":106415},{"$f":"'MAX MDR-TB assay'!C36","v":"Square filter paper, 580 mm"},{"$f":"'MAX MDR-TB assay'!kit_ordered","v":0}]
[null,{"$f":"'MAX MDR-TB assay'!B37","v":106755},{"$f":"'MAX MDR-TB assay'!C37","v":"Paper towels"},{"$f":"'MAX MDR-TB assay'!kit_ordered","v":0}]
[null,{"$f":"'MAX MDR-TB assay'!B38","v":106333},{"$f":"'MAX MDR-TB assay'!C38","v":"Ethanol / isopropanol, 5 L"},{"$f":"'MAX MDR-TB assay'!kit_ordered","v":0}]
[null,"FluoroType MTBDR Ver 2.0"]
[null,{"$f":"'FluoroType MTBDR VER 2.0'!B30","v":0},{"$f":"'FluoroType MTBDR VER 2.0'!C30","v":" FluoroType MTBDR assay"},{"$f":"'FluoroType MTBDR VER 2.0'!kit_ordered","v":0}]
[null,{"$f":"'FluoroType MTBDR VER 2.0'!B31","v":0},{"$f":"'FluoroType MTBDR VER 2.0'!C31","v":"GXT DNA/ RNA Extraction Kit "},{"$f":"'FluoroType MTBDR VER 2.0'!kit_ordered","v":0}]
[null,{"$f":"'FluoroType MTBDR VER 2.0'!B32","v":0},{"$f":"'FluoroType MTBDR VER 2.0'!C32","v":"FluoroLyse Extraciton Kit "},{"$f":"'FluoroType MTBDR VER 2.0'!kit_ordered","v":0}]
[null,{"$f":"'FluoroType MTBDR VER 2.0'!B33","v":106384},{"$f":"'FluoroType MTBDR VER 2.0'!C33","v":"Sterile plastic centrifuge tubes, 15 mL"},{"$f":"'FluoroType MTBDR VER 2.0'!kit_ordered","v":0}]
[null,{"$f":"'FluoroType MTBDR VER 2.0'!B34","v":106422},{"$f":"'FluoroType MTBDR VER 2.0'!C34","v":"Microcentrifuge tubes, 2 mL"},{"$f":"'FluoroType MTBDR VER 2.0'!kit_ordered","v":0}]
[null,{"$f":"'FluoroType MTBDR VER 2.0'!B35","v":106554},{"$f":"'FluoroType MTBDR VER 2.0'!C35","v":"Sterile filter tips,  0.1–10 µL"},{"$f":"'FluoroType MTBDR VER 2.0'!kit_ordered","v":0}]
[null,{"$f":"'FluoroType MTBDR VER 2.0'!B36","v":106389},{"$f":"'FluoroType MTBDR VER 2.0'!C36","v":"Sterile filter tips, 20–200 µL"},{"$f":"'FluoroType MTBDR VER 2.0'!kit_ordered","v":0}]
[null,{"$f":"'FluoroType MTBDR VER 2.0'!B37","v":106390},{"$f":"'FluoroType MTBDR VER 2.0'!C37","v":"Sterile filter tips, 100–1000 µL"},{"$f":"'FluoroType MTBDR VER 2.0'!kit_ordered","v":0}]
[null,{"$f":"'FluoroType MTBDR VER 2.0'!B38","v":106444},{"$f":"'FluoroType MTBDR VER 2.0'!C38","v":"Plastic bags, 30 L"},{"$f":"'FluoroType MTBDR VER 2.0'!kit_ordered","v":0}]
[null,{"$f":"'FluoroType MTBDR VER 2.0'!B39","v":106415},{"$f":"'FluoroType MTBDR VER 2.0'!C39","v":"Square filter paper, 580 mm"},{"$f":"'FluoroType MTBDR VER 2.0'!kit_ordered","v":0}]
[null,{"$f":"'FluoroType MTBDR VER 2.0'!B40","v":106755},{"$f":"'FluoroType MTBDR VER 2.0'!C40","v":"Paper towels"},{"$f":"'FluoroType MTBDR VER 2.0'!kit_ordered","v":0}]
[null,{"$f":"'FluoroType MTBDR VER 2.0'!B41","v":106333},{"$f":"'FluoroType MTBDR VER 2.0'!C41","v":"Ethanol / isopropanol, 5 L"},{"$f":"'FluoroType MTBDR VER 2.0'!kit_ordered","v":0}]
[null,"Cobas MTB and MTB-RIF-INH"]
[null,{"$f":"'Cobas MTB and MTB-RIF-INH'!B28","v":0},{"$f":"'Cobas MTB and MTB-RIF-INH'!C28","v":"Cobas® MTB"},{"$f":"'Cobas MTB and MTB-RIF-INH'!kit_ordered","v":0}]
[null,{"$f":"'Cobas MTB and MTB-RIF-INH'!B29","v":0},{"$f":"'Cobas MTB and MTB-RIF-INH'!C29","v":"Cobas® MTB Positive Control Kit"},{"$f":"'Cobas MTB and MTB-RIF-INH'!kit_ordered","v":0}]
[null,{"$f":"'Cobas MTB and MTB-RIF-INH'!B30","v":0},{"$f":"'Cobas MTB and MTB-RIF-INH'!C30","v":"Cobas® 6800/8800 Buffer Negative Control Kit"},{"$f":"'Cobas MTB and MTB-RIF-INH'!kit_ordered","v":0}]
[null,{"$f":"'Cobas MTB and MTB-RIF-INH'!B31","v":0},{"$f":"'Cobas MTB and MTB-RIF-INH'!C31","v":"Cobas® Microbial Inactivation Solution"},{"$f":"'Cobas MTB and MTB-RIF-INH'!kit_ordered","v":0}]
[null,{"$f":"'Cobas MTB and MTB-RIF-INH'!B32","v":0},{"$f":"'Cobas MTB and MTB-RIF-INH'!C32","v":"Cobas® MTB-RIF/INH"},{"$f":"'Cobas MTB and MTB-RIF-INH'!kit_ordered","v":0}]
[null,{"$f":"'Cobas MTB and MTB-RIF-INH'!B33","v":0},{"$f":"'Cobas MTB and MTB-RIF-INH'!C33","v":"Cobas® MTB-RIF/INH Positive Control Kit"},{"$f":"'Cobas MTB and MTB-RIF-INH'!kit_ordered","v":0}]
[null,{"$f":"'Cobas MTB and MTB-RIF-INH'!B34","v":0},{"$f":"'Cobas MTB and MTB-RIF-INH'!C34","v":"Cobas® 6800/8800 Buffer Negative Control Kit"},{"$f":"'Cobas MTB and MTB-RIF-INH'!kit_ordered","v":0}]
[null,{"$f":"'Cobas MTB and MTB-RIF-INH'!B35","v":0},{"$f":"'Cobas MTB and MTB-RIF-INH'!C35","v":"Cobas Microbial Inactivation Solution"},{"$f":"'Cobas MTB and MTB-RIF-INH'!kit_ordered","v":0}]
[null,{"$f":"'Cobas MTB and MTB-RIF-INH'!B36","v":106384},{"$f":"'Cobas MTB and MTB-RIF-INH'!C36","v":"Sterile plastic centrifuge tubes, 15 mL"},{"$f":"'Cobas MTB and MTB-RIF-INH'!kit_ordered","v":0}]
[null,{"$f":"'Cobas MTB and MTB-RIF-INH'!B37","v":106422},{"$f":"'Cobas MTB and MTB-RIF-INH'!C37","v":"Microcentrifuge tubes, 2 mL"},{"$f":"'Cobas MTB and MTB-RIF-INH'!kit_ordered","v":0}]
[null,{"$f":"'Cobas MTB and MTB-RIF-INH'!B38","v":106554},{"$f":"'Cobas MTB and MTB-RIF-INH'!C38","v":"Sterile filter tips, 0.1–10 µL"},{"$f":"'Cobas MTB and MTB-RIF-INH'!kit_ordered","v":0}]
[null,{"$f":"'Cobas MTB and MTB-RIF-INH'!B39","v":106389},{"$f":"'Cobas MTB and MTB-RIF-INH'!C39","v":"Sterile filter tips, 20–200 µL"},{"$f":"'Cobas MTB and MTB-RIF-INH'!kit_ordered","v":0}]
[null,{"$f":"'Cobas MTB and MTB-RIF-INH'!B40","v":106390},{"$f":"'Cobas MTB and MTB-RIF-INH'!C40","v":"Sterile filter tips, 100–1000 µL"},{"$f":"'Cobas MTB and MTB-RIF-INH'!kit_ordered","v":0}]
[null,{"$f":"'Cobas MTB and MTB-RIF-INH'!B41","v":106444},{"$f":"'Cobas MTB and MTB-RIF-INH'!C41","v":"Plastic bags, 30 L"},{"$f":"'Cobas MTB and MTB-RIF-INH'!kit_ordered","v":0}]
[null,{"$f":"'Cobas MTB and MTB-RIF-INH'!B42","v":106415},{"$f":"'Cobas MTB and MTB-RIF-INH'!C42","v":"Square filter paper, 580 mm"},{"$f":"'Cobas MTB and MTB-RIF-INH'!kit_ordered","v":0}]
[null,{"$f":"'Cobas MTB and MTB-RIF-INH'!B43","v":106755},{"$f":"'Cobas MTB and MTB-RIF-INH'!C43","v":"Paper towels"},{"$f":"'Cobas MTB and MTB-RIF-INH'!kit_ordered","v":0}]
[null,{"$f":"'Cobas MTB and MTB-RIF-INH'!B44","v":106333},{"$f":"'Cobas MTB and MTB-RIF-INH'!C44","v":"Ethanol / isopropanol, 5 L"},{"$f":"'Cobas MTB and MTB-RIF-INH'!kit_ordered","v":0}]
[null,"Abbott RT MTB and MTB RIF-INH"]
[null,{"$f":"'Abbott RT MTB and MTB RIF-INH'!B28","v":0},{"$f":"'Abbott RT MTB and MTB RIF-INH'!C28","v":"Inactivation reagent"},{"$f":"'Abbott RT MTB and MTB RIF-INH'!E28","v":0}]
[null,{"$f":"'Abbott RT MTB and MTB RIF-INH'!B29","v":0},{"$f":"'Abbott RT MTB and MTB RIF-INH'!C29","v":"Abbott Sample Preparation System DNA kit"},{"$f":"'Abbott RT MTB and MTB RIF-INH'!E29","v":0}]
[null,{"$f":"'Abbott RT MTB and MTB RIF-INH'!B30","v":0},{"$f":"'Abbott RT MTB and MTB RIF-INH'!C30","v":"Abbott Real Time MTB Amplification Reagent Kit"},{"$f":"'Abbott RT MTB and MTB RIF-INH'!E30","v":0}]
[null,{"$f":"'Abbott RT MTB and MTB RIF-INH'!B31","v":0},{"$f":"'Abbott RT MTB and MTB RIF-INH'!C31","v":"Abbott Real Time MTB Control Kit"},{"$f":"'Abbott RT MTB and MTB RIF-INH'!E31","v":0}]
[null,{"$f":"'Abbott RT MTB and MTB RIF-INH'!B32","v":0},{"$f":"'Abbott RT MTB and MTB RIF-INH'!C32","v":"Abbott Real Time MTB RIF/INH Resistance Amplification Reagent Kit"},{"$f":"'Abbott RT MTB and MTB RIF-INH'!E32","v":0}]
[null,{"$f":"'Abbott RT MTB and MTB RIF-INH'!B33","v":0},{"$f":"'Abbott RT MTB and MTB RIF-INH'!C33","v":"Abbott Real Time MTB RIF/INH Resistance Control Kit"},{"$f":"'Abbott RT MTB and MTB RIF-INH'!E33","v":0}]
[null,{"$f":"'Abbott RT MTB and MTB RIF-INH'!B34","v":0},{"$f":"'Abbott RT MTB and MTB RIF-INH'!C34","v":"Abbott 96-Well Optical Reaction Plates"},{"$f":"'Abbott RT MTB and MTB RIF-INH'!E34","v":0}]
[null,{"$f":"'Abbott RT MTB and MTB RIF-INH'!B35","v":0},{"$f":"'Abbott RT MTB and MTB RIF-INH'!C35","v":"Abbott 96-Deep-Well Plates and plate holder"},{"$f":"'Abbott RT MTB and MTB RIF-INH'!E35","v":0}]
[null,{"$f":"'Abbott RT MTB and MTB RIF-INH'!B36","v":106384},{"$f":"'Abbott RT MTB and MTB RIF-INH'!C36","v":"Sterile plastic centrifuge tubes, 15 mL"},{"$f":"'Abbott RT MTB and MTB RIF-INH'!E36","v":0}]
[null,{"$f":"'Abbott RT MTB and MTB RIF-INH'!B37","v":106422},{"$f":"'Abbott RT MTB and MTB RIF-INH'!C37","v":"Microcentrifuge tubes, 2 mL"},{"$f":"'Abbott RT MTB and MTB RIF-INH'!E37","v":0}]
[null,{"$f":"'Abbott RT MTB and MTB RIF-INH'!B38","v":106554},{"$f":"'Abbott RT MTB and MTB RIF-INH'!C38","v":"Sterile filter tips,  0.1–10 µL"},{"$f":"'Abbott RT MTB and MTB RIF-INH'!E38","v":0}]
[null,{"$f":"'Abbott RT MTB and MTB RIF-INH'!B39","v":106389},{"$f":"'Abbott RT MTB and MTB RIF-INH'!C39","v":"Sterile filter tips, 20–200 µL"},{"$f":"'Abbott RT MTB and MTB RIF-INH'!E39","v":0}]
[null,{"$f":"'Abbott RT MTB and MTB RIF-INH'!B40","v":106390},{"$f":"'Abbott RT MTB and MTB RIF-INH'!C40","v":"Sterile filter tips, 100–1000 µL"},{"$f":"'Abbott RT MTB and MTB RIF-INH'!E40","v":0}]
[null,{"$f":"'Abbott RT MTB and MTB RIF-INH'!B41","v":106444},{"$f":"'Abbott RT MTB and MTB RIF-INH'!C41","v":"Plastic bags, 30 L"},{"$f":"'Abbott RT MTB and MTB RIF-INH'!E41","v":0}]
[null,{"$f":"'Abbott RT MTB and MTB RIF-INH'!B42","v":106415},{"$f":"'Abbott RT MTB and MTB RIF-INH'!C42","v":"Square filter paper, 580 mm"},{"$f":"'Abbott RT MTB and MTB RIF-INH'!E42","v":0}]
[null,{"$f":"'Abbott RT MTB and MTB RIF-INH'!B43","v":106755},{"$f":"'Abbott RT MTB and MTB RIF-INH'!C43","v":"Paper towels"},{"$f":"'Abbott RT MTB and MTB RIF-INH'!E43","v":53}]
[null,{"$f":"'Abbott RT MTB and MTB RIF-INH'!B44","v":106333},{"$f":"'Abbott RT MTB and MTB RIF-INH'!C44","v":"Ethanol / isopropanol, 5 L"},{"$f":"'Abbott RT MTB and MTB RIF-INH'!E44","v":0}]
[null,"Solid culture"]
[null,{"$f":"'Processing&solid-liquid culture'!C36","v":106259},{"$f":"'Processing&solid-liquid culture'!D36","v":"TB medium LJ, 500 g"},{"$f":"'Processing&solid-liquid culture'!E36","v":1}]
[null,{"$f":"'Processing&solid-liquid culture'!C37","v":106268},{"$f":"'Processing&solid-liquid culture'!D37","v":"Glycerol 99.5, 1 L"},{"$f":"'Processing&solid-liquid culture'!E37","v":1}]
[null,{"$f":"'Processing&solid-liquid culture'!C39","v":106263},{"$f":"'Processing&solid-liquid culture'!D39","v":"Potassium dihydrogen phosphate, MW: 136.09, 1 kg "},{"$f":"'Processing&solid-liquid culture'!E39","v":1}]
[null,{"$f":"'Processing&solid-liquid culture'!C40","v":106264},{"$f":"'Processing&solid-liquid culture'!D40","v":"Magnesium sulfate-heptahydrate • 7H2O, MW: 246.48. 500 g "},{"$f":"'Processing&solid-liquid culture'!E40","v":0.5}]
[null,{"$f":"'Processing&solid-liquid culture'!C41","v":106265},{"$f":"'Processing&solid-liquid culture'!D41","v":"L-Asparagine-monohydrate • H2O, MW: 150.13, 250 g"},{"$f":"'Processing&solid-liquid culture'!E41","v":0.1}]
[null,{"$f":"'Processing&solid-liquid culture'!C42","v":106266},{"$f":"'Processing&solid-liquid culture'!D42","v":"Tri-magnesium di-citrate nonahydrate • 9 H2O, 500 g "},{"$f":"'Processing&solid-liquid culture'!E42","v":0.1}]
[null,{"$f":"'Processing&solid-liquid culture'!C43","v":106267},{"$f":"'Processing&solid-liquid culture'!D43","v":"Malachite green oxalate, 100 g "},{"$f":"'Processing&solid-liquid culture'!E43","v":0.1}]
[null,{"$f":"'Processing&solid-liquid culture'!C44","v":106268},{"$f":"'Processing&solid-liquid culture'!D44","v":"Glycerol 99.5, 1 L"},{"$f":"'Processing&solid-liquid culture'!E44","v":1}]
[null,"Liquid culture"]
[null,{"$f":"'Processing&solid-liquid culture'!C49","v":106026},{"$f":"'Processing&solid-liquid culture'!D49","v":"BBL MGIT tubes  for use in Bactec MGIT 960 (7mL) - 100 tubes/pack"},{"$f":"'Processing&solid-liquid culture'!F49","v":0}]
[null,{"$f":"'Processing&solid-liquid culture'!C50","v":106027},{"$f":"'Processing&solid-liquid culture'!D50","v":"BACTEC MGIT 960 Supplement Kit (100 tests, PANTA and OADC combined)"},{"$f":"'Processing&solid-liquid culture'!F50","v":0}]
[null,{"$f":"'Processing&solid-liquid culture'!C51","v":106098},{"$f":"'Processing&solid-liquid culture'!D51","v":"Lime-glass culture tubes, 12 mL, screw caps"},{"$f":"'Processing&solid-liquid culture'!F51","v":0}]
[null,{"$f":"'Processing&solid-liquid culture'!C52","v":106340},{"$f":"'Processing&solid-liquid culture'!D52","v":"Sterile plastic centrifuge tubes, 50 mL"},{"$f":"'Processing&solid-liquid culture'!F52","v":0}]
[null,{"$f":"'Processing&solid-liquid culture'!C53","v":106394},{"$f":"'Processing&solid-liquid culture'!D53","v":"Single-use plastic Pasteur-pipettes, sterile, individually packed"},{"$f":"'Processing&solid-liquid culture'!F53","v":0}]
[null,{"$f":"'Processing&solid-liquid culture'!C54","v":106714},{"$f":"'Processing&solid-liquid culture'!D54","v":"Disposable loops, 10 µL"},{"$f":"'Processing&solid-liquid culture'!F54","v":0}]
[null,{"$f":"'Processing&solid-liquid culture'!C55","v":106344},{"$f":"'Processing&solid-liquid culture'!D55","v":"Sterile cryovials, 2 mL "},{"$f":"'Processing&solid-liquid culture'!F55","v":0}]
[null,{"$f":"'Processing&solid-liquid culture'!C56","v":106052},{"$f":"'Processing&solid-liquid culture'!D56","v":"Cardboard storage box for sterile cryovials, 2 mL"},{"$f":"'Processing&solid-liquid culture'!F56","v":0}]
[null,{"$f":"'Processing&solid-liquid culture'!C57","v":106823},{"$f":"'Processing&solid-liquid culture'!D57","v":"Plastic Petri dishes "},{"$f":"'Processing&solid-liquid culture'!F57","v":0}]
[null,{"$f":"'Processing&solid-liquid culture'!C58","v":"106390/106398"},{"$f":"'Processing&solid-liquid culture'!D58","v":"Sterile, DNA-/RNAse-free tips, 100 - 1000 µl"},{"$f":"'Processing&solid-liquid culture'!F58","v":0}]
[null,{"$f":"'Processing&solid-liquid culture'!C59","v":106407},{"$f":"'Processing&solid-liquid culture'!D59","v":"Brain-heart infusion agar"},{"$f":"'Processing&solid-liquid culture'!F59","v":0}]
[null,{"$f":"'Processing&solid-liquid culture'!C60","v":106362},{"$f":"'Processing&solid-liquid culture'!D60","v":"Plastic foil"},{"$f":"'Processing&solid-liquid culture'!F60","v":0}]
[null,"Sample processing"]
[null,{"$f":"'Processing&solid-liquid culture'!C65","v":106278},{"$f":"'Processing&solid-liquid culture'!D65","v":"Di-sodium hydrogen phosphate anhydrous, MW: 141.96, 1 kg"},{"$f":"'Processing&solid-liquid culture'!F65","v":0}]
[null,{"$f":"'Processing&solid-liquid culture'!C66","v":106263},{"$f":"'Processing&solid-liquid culture'!D66","v":"Potassium dihydrogen phosphate MW: 136.09, 1 kg"},{"$f":"'Processing&solid-liquid culture'!F66","v":0}]
[null,{"$f":"'Processing&solid-liquid culture'!C68","v":106281},{"$f":"'Processing&solid-liquid culture'!D68","v":"Sodium hydroxide, MW 40.00, purity ≥ 98%, pellets, 1 kg"},{"$f":"'Processing&solid-liquid culture'!F68","v":0}]
[null,{"$f":"'Processing&solid-liquid culture'!C70","v":106283},{"$f":"'Processing&solid-liquid culture'!D70","v":"N-Acetyl-L-cysteine, MW: 163.19, purity ≥ 99%, 100 g"},{"$f":"'Processing&solid-liquid culture'!F70","v":0}]
[null,{"$f":"'Processing&solid-liquid culture'!C71","v":106284},{"$f":"'Processing&solid-liquid culture'!D71","v":"Tri-sodium citrate dihydrate · 2H2O, MW: 294.10, 1 kg"},{"$f":"'Processing&solid-liquid culture'!F71","v":0}]
[null,{"$f":"'Processing&solid-liquid culture'!C72","v":106281},{"$f":"'Processing&solid-liquid culture'!D72","v":"Sodium hydroxide, MW 40.00, purity ≥ 98%, pellets, 1 kg"},{"$f":"'Processing&solid-liquid culture'!F72","v":0}]
[null,{"$f":"'Processing&solid-liquid culture'!C74","v":106340},{"$f":"'Processing&solid-liquid culture'!D74","v":"Sterile plastic centrifuge tubes, 50 mL"},{"$f":"'Processing&solid-liquid culture'!F74","v":0}]
[null,{"$f":"'Processing&solid-liquid culture'!C75","v":106434},{"$f":"'Processing&solid-liquid culture'!D75","v":"Disposable Pasteur pipettes, graduated, non-sterile, 155 mm"},{"$f":"'Processing&solid-liquid culture'!F75","v":0}]
[null,"LJ DST"]
[null,{"$f":"'LJ 1st line DST'!A23","v":106268},{"$f":"'LJ 1st line DST'!B23","v":"Glycerol 99.5"},{"$f":"'LJ 1st line DST'!F23","v":0}]
[null,{"$f":"'LJ 1st line DST'!A24","v":106259},{"$f":"'LJ 1st line DST'!B24","v":"TB medium LJ, 500 g"},{"$f":"'LJ 1st line DST'!F24","v":0}]
[null,{"$f":"'LJ 1st line DST'!A25","v":106308},{"$f":"'LJ 1st line DST'!B25","v":"Isoniazid (INH) - for laboratory use"},{"$f":"'LJ 1st line DST'!F25","v":0}]
[null,{"$f":"'LJ 1st line DST'!A26","v":106309},{"$f":"'LJ 1st line DST'!B26","v":"Rifampicin (RMP) - for laboratory use"},{"$f":"'LJ 1st line DST'!F26","v":0}]
[null,{"$f":"'LJ 1st line DST'!A27","v":106311},{"$f":"'LJ 1st line DST'!B27","v":"Dihydro-streptomycin (DHSM) - for laboratory use"},{"$f":"'LJ 1st line DST'!F27","v":0}]
[null,{"$f":"'LJ 1st line DST'!A28","v":106310},{"$f":"'LJ 1st line DST'!B28","v":"Ethambutol - for laboratory use"},{"$f":"'LJ 1st line DST'!F28","v":0}]
[null,{"$f":"'LJ 1st line DST'!A29","v":106394},{"$f":"'LJ 1st line DST'!B29","v":"Single-use, sterile, plastic Pasteur-pipettes, individually packed"},{"$f":"'LJ 1st line DST'!F29","v":0}]
[null,{"$f":"'LJ 1st line DST'!A30","v":106344},{"$f":"'LJ 1st line DST'!B30","v":"Sterile cryovials, 2 mL"},{"$f":"'LJ 1st line DST'!F30","v":0}]
[null,{"$f":"'LJ 2nd line DST'!A21","v":106268},{"$f":"'LJ 2nd line DST'!B21","v":"Glycerol 99.5"},{"$f":"'LJ 2nd line DST'!F21","v":0}]
[null,{"$f":"'LJ 2nd line DST'!A22","v":106259},{"$f":"'LJ 2nd line DST'!B22","v":"TB medium LJ, 500 g"},{"$f":"'LJ 2nd line DST'!F22","v":0},null,"FIND"]
[null,{"$f":"'LJ 2nd line DST'!A23","v":106560},{"$f":"'LJ 2nd line DST'!B23","v":"Levofloxacin (LFX)- for laboratory use"},{"$f":"'LJ 2nd line DST'!F23","v":0}]
[null,{"$f":"'LJ 2nd line DST'!A24","v":106316},{"$f":"'LJ 2nd line DST'!B24","v":"Ethionamide (ETH) - for laboratory use"},{"$f":"'LJ 2nd line DST'!F24","v":0}]
[null,{"$f":"'LJ 2nd line DST'!A25","v":106317},{"$f":"'LJ 2nd line DST'!B25","v":"Kanamycin (KAN) - for laboratory use"},{"$f":"'LJ 2nd line DST'!F25","v":0}]
[null,{"$f":"'LJ 2nd line DST'!A26","v":106318},{"$f":"'LJ 2nd line DST'!B26","v":"Amikacin (AMI)  - for laboratory use"},{"$f":"'LJ 2nd line DST'!F26","v":0}]
[null,{"$f":"'LJ 2nd line DST'!A27","v":106319},{"$f":"'LJ 2nd line DST'!B27","v":"Capreomycin (CM) - for laboratory use"},{"$f":"'LJ 2nd line DST'!F27","v":0}]
[null,{"$f":"'LJ 2nd line DST'!A28","v":106396},{"$f":"'LJ 2nd line DST'!B28","v":"Dispenser tips, 5 mL"},{"$f":"'LJ 2nd line DST'!F28","v":0}]
[null,{"$f":"'LJ 2nd line DST'!A29","v":106394},{"$f":"'LJ 2nd line DST'!B29","v":"Single-use, sterile plastic Pasteur pipettes, individually packed"},{"$f":"'LJ 2nd line DST'!F29","v":0}]
[null,{"$f":"'LJ 2nd line DST'!A30","v":106344},{"$f":"'LJ 2nd line DST'!B30","v":"Sterile cryovials, 2 mL "},{"$f":"'LJ 2nd line DST'!F30","v":0}]
[null,"Liquid DST"]
[null,{"$f":"'MGIT 1st line DST'!B26","v":106028},{"$f":"'MGIT 1st line DST'!C26","v":"BACTEC™ MGIT™ 960 SIRE kit, One kit is sufficient for 40 test"},{"$f":"'MGIT 1st line DST'!E26","v":0}]
[null,{"$f":"'MGIT 1st line DST'!B27","v":106026},{"$f":"'MGIT 1st line DST'!C27","v":"BBL MGIT tubes  for use in Bactec MGIT 960 (7 mL) - 100 tubes/pack"},{"$f":"'MGIT 1st line DST'!E27","v":0}]
[null,{"$f":"'MGIT 1st line DST'!B28","v":106389},{"$f":"'MGIT 1st line DST'!C28","v":"Sterile filter tips, 20–200 µL"},{"$f":"'MGIT 1st line DST'!E28","v":0}]
[null,{"$f":"'MGIT 1st line DST'!B29","v":106390},{"$f":"'MGIT 1st line DST'!C29","v":"Sterile filter tips, 100–1000 µL"},{"$f":"'MGIT 1st line DST'!E29","v":0}]
[null,{"$f":"'MGIT 1st line DST'!B30","v":106181},{"$f":"'MGIT 1st line DST'!C30","v":"Sterile dispenser tips, 10 mL"},{"$f":"'MGIT 1st line DST'!E30","v":0}]
[null,{"$f":"'MGIT 1st line DST'!B34","v":106033},{"$f":"'MGIT 1st line DST'!C34","v":"BACTEC™ MGIT™ PZA Kit"},{"$f":"'MGIT 1st line DST'!E34","v":0}]
[null,{"$f":"'MGIT 1st line DST'!B35","v":106036},{"$f":"'MGIT 1st line DST'!C35","v":"BACTEC™ MGIT™ PZA Tubes - 25"},{"$f":"'MGIT 1st line DST'!E35","v":0}]
[null,{"$f":"'MGIT 1st line DST'!B36","v":106389},{"$f":"'MGIT 1st line DST'!C36","v":"Sterile pipette filter  tips, 1–200 µL"},{"$f":"'MGIT 1st line DST'!E36","v":0}]
[null,{"$f":"'MGIT 1st line DST'!B37","v":106390},{"$f":"'MGIT 1st line DST'!C37","v":"Sterile filter tips, 100–1000 µL"},{"$f":"'MGIT 1st line DST'!E37","v":0}]
[null,{"$f":"'MGIT 2nd line DST'!A23","v":106585},{"$f":"'MGIT 2nd line DST'!B23","v":"Moxifloxacin - lyophilized drug for laboratory use, 6-vial pack"},{"$f":"'MGIT 2nd line DST'!F23","v":0}]
[null,{"$f":"'MGIT 2nd line DST'!A24","v":106586},{"$f":"'MGIT 2nd line DST'!B24","v":"Amikacin - lyophilized drug for laboratory use, 6-vial pack"},{"$f":"'MGIT 2nd line DST'!F24","v":0}]
[null,{"$f":"'MGIT 2nd line DST'!A25","v":106584},{"$f":"'MGIT 2nd line DST'!B25","v":"Kanamycin – lyophilized drug for laboratory use, 6-vial pack"},{"$f":"'MGIT 2nd line DST'!F25","v":0}]
[null,{"$f":"'MGIT 2nd line DST'!A26","v":106587},{"$f":"'MGIT 2nd line DST'!B26","v":"Capreomycin - lyophilized drug for laboratory use, 6-vial pack"},{"$f":"'MGIT 2nd line DST'!F26","v":0}]
[null,{"$f":"'MGIT 2nd line DST'!A27","v":106582},{"$f":"'MGIT 2nd line DST'!B27","v":"BD BBL Middlebrook OADC Enrichment, 20 mL per tube, ''A'' size tube,  BD BBL™ Middlebrook OADC Enrichment, 20 mL per tube, ''A'' size tube (10/sp)"},{"$f":"'MGIT 2nd line DST'!F27","v":0}]
[null,{"$f":"'MGIT 2nd line DST'!A28","v":106026},{"$f":"'MGIT 2nd line DST'!B28","v":"BBL MGIT Tubes  for use in Bactec MGIT 960 (7 mL) - 100 tubes/pack"},{"$f":"'MGIT 2nd line DST'!F28","v":0}]
[null,{"$f":"'MGIT 2nd line DST'!A29","v":106412},{"$f":"'MGIT 2nd line DST'!B29","v":"Long 1-mL tips with filter"},{"$f":"'MGIT 2nd line DST'!F29","v":0}]
[null,{"$f":"'MGIT 2nd line DST'!A35","v":106315},{"$f":"'MGIT 2nd line DST'!B35","v":"Prothionamide (PTH) - for laboratory use"},{"$f":"'MGIT 2nd line DST'!F35","v":0}]
[null,{"$f":"'MGIT 2nd line DST'!A36","v":106319},{"$f":"'MGIT 2nd line DST'!B36","v":"Capreomycin (CM) - for laboratory use"},{"$f":"'MGIT 2nd line DST'!F36","v":0}]
[null,{"$f":"'MGIT 2nd line DST'!A37","v":106560},{"$f":"'MGIT 2nd line DST'!B37","v":"Levofloxacin - for laboratory use"},{"$f":"'MGIT 2nd line DST'!F37","v":0}]
[null,{"$f":"'MGIT 2nd line DST'!A38","v":106653},{"$f":"'MGIT 2nd line DST'!B38","v":"Linezolid - for laboratory use"},{"$f":"'MGIT 2nd line DST'!F38","v":0}]
[null,{"$f":"'MGIT 2nd line DST'!A39","v":106654},{"$f":"'MGIT 2nd line DST'!B39","v":"Clofazimine - for laboratory use"},{"$f":"'MGIT 2nd line DST'!F39","v":0}]
[null,{"$f":"'MGIT 2nd line DST'!A40","v":0},{"$f":"'MGIT 2nd line DST'!B40","v":"Bedaquiline - for laboratory use"},{"$f":"'MGIT 2nd line DST'!F40","v":0}]
[null,{"$f":"'MGIT 2nd line DST'!A41","v":0},{"$f":"'MGIT 2nd line DST'!B41","v":"Delamanid - for laboratory use"},{"$f":"'MGIT 2nd line DST'!F41","v":0}]
[null,{"$f":"'MGIT 2nd line DST'!A42","v":106623},{"$f":"'MGIT 2nd line DST'!B42","v":"BBL MGIT OADC Enrichment, 6 15-mL vials (90 mL) "},{"$f":"'MGIT 2nd line DST'!F42","v":0}]
[null,{"$f":"'MGIT 2nd line DST'!A43","v":106026},{"$f":"'MGIT 2nd line DST'!B43","v":"BBL MGIT tubes  for use in Bactec MGIT 960 (7 mL) - 100 tubes/pack"},{"$f":"'MGIT 2nd line DST'!F43","v":0}]
[null,{"$f":"'MGIT 2nd line DST'!A44","v":106209},{"$f":"'MGIT 2nd line DST'!B44","v":"Serological pipette, 5 mL"},{"$f":"'MGIT 2nd line DST'!F44","v":0}]
[null,{"$f":"'MGIT 2nd line DST'!A45","v":106550},{"$f":"'MGIT 2nd line DST'!B45","v":"Serological pipette 10 mL"},{"$f":"'MGIT 2nd line DST'!F45","v":0}]
[null,{"$f":"'MGIT 2nd line DST'!A46","v":106344},{"$f":"'MGIT 2nd line DST'!B46","v":"Sterile cryovials, 2 mL "},{"$f":"'MGIT 2nd line DST'!F46","v":0}]
[null,{"$f":"'MGIT 2nd line DST'!A47","v":106388},{"$f":"'MGIT 2nd line DST'!B47","v":"Sterile pipette filter tips, 5–100 µL"},{"$f":"'MGIT 2nd line DST'!F47","v":0}]
[null,{"$f":"'MGIT 2nd line DST'!A48","v":106352},{"$f":"'MGIT 2nd line DST'!B48","v":"Single-use syringes, sterile"},{"$f":"'MGIT 2nd line DST'!F48","v":0}]
[null,"Culture identification"]
[null,{"$f":"ID!B18","v":106414},{"$f":"ID!C18","v":"Rapid test for detection of MPT 64 Antigen - SD Bioline TB Ag MPT64"},{"$f":"ID!E18","v":0}]
[null,{"$f":"ID!B19","v":106394},{"$f":"ID!C19","v":"Single-use, sterile plastic Pasteur pipettes, individually packed"},{"$f":"ID!E19","v":0}]
[null,{"$f":"ID!B20","v":106714},{"$f":"ID!C20","v":"Disposable loops, 10 µL"},{"$f":"ID!E20","v":0}]
[null,{"$f":"ID!B21","v":106344},{"$f":"ID!C21","v":"Sterile cryovials, 2 mL "},{"$f":"ID!E21","v":0}]
[null,{"$f":"ID!B30","v":106611},{"$f":"ID!C30","v":"Capilia TB-Neo - Rapid test for detection of MPT 64 antigen "},{"$f":"ID!E22","v":0}]
[null,{"$f":"ID!B31","v":106612},{"$f":"ID!C31","v":"Capilia TB-Neo Extraction buffer (1 x 20 mL)"},{"$f":"ID!E30","v":0}]
[null,{"$f":"ID!B32","v":106394},{"$f":"ID!C32","v":"Sterile Pasteur pipettes, 3 mL"},{"$f":"ID!E31","v":0}]
[null,{"$f":"ID!B33","v":106714},{"$f":"ID!C33","v":"Disposable loops, 10 µL"},{"$f":"ID!E32","v":0}]
[null,{"$f":"ID!B34","v":106344},{"$f":"ID!C34","v":"Sterile cryovials, 2 mL "},{"$f":"ID!E33","v":0}]
[]
[null,"GDF code","Biosafety and cleaning","Qty",null,"previous"]
[null,"Biosafety",null,null,null,"FIND"]
[null,{"$f":"'Biosafety and cleaning'!B27","v":106727},{"$f":"'Biosafety and cleaning'!D27","v":"Hair cover"},{"$f":"'Biosafety and cleaning'!F27","v":0}]
[null,{"$f":"'Biosafety and cleaning'!B28","v":106726},{"$f":"'Biosafety and cleaning'!D28","v":"Shoe cover"},{"$f":"'Biosafety and cleaning'!F28","v":0}]
[null,{"$f":"'Biosafety and cleaning'!B29","v":106725},{"$f":"'Biosafety and cleaning'!D29","v":"Laboratory coat size L - disposable - sterile"},{"$f":"'Biosafety and cleaning'!F29","v":0}]
[null,{"$f":"'Biosafety and cleaning'!B30","v":106724},{"$f":"'Biosafety and cleaning'!D30","v":"Laboratory coat size M - disposable - sterile"},{"$f":"'Biosafety and cleaning'!F30","v":0}]
[null,{"$f":"'Biosafety and cleaning'!B31","v":106723},{"$f":"'Biosafety and cleaning'!D31","v":"Laboratory coat size S - disposable - sterile"},{"$f":"'Biosafety and cleaning'!F31","v":0}]
[null,{"$f":"'Biosafety and cleaning'!B32","v":106820},{"$f":"'Biosafety and cleaning'!D32","v":"Latex gloves size L"},{"$f":"'Biosafety and cleaning'!F32","v":0}]
[null,{"$f":"'Biosafety and cleaning'!B33","v":106819},{"$f":"'Biosafety and cleaning'!D33","v":"Latex gloves size M"},{"$f":"'Biosafety and cleaning'!F33","v":0}]
[null,{"$f":"'Biosafety and cleaning'!B34","v":106818},{"$f":"'Biosafety and cleaning'!D34","v":"Latex gloves size S"},{"$f":"'Biosafety and cleaning'!F34","v":0}]
[null,{"$f":"'Biosafety and cleaning'!B35","v":106829},{"$f":"'Biosafety and cleaning'!D35","v":"Disposable respirators FFP2"},{"$f":"'Biosafety and cleaning'!F35","v":0}]
[null,{"$f":"'Biosafety and cleaning'!B36","v":106502},{"$f":"'Biosafety and cleaning'!D36","v":"Surgical gown - cotton - L"},{"$f":"'Biosafety and cleaning'!F36","v":0}]
[null,{"$f":"'Biosafety and cleaning'!B37","v":106501},{"$f":"'Biosafety and cleaning'!D37","v":"Surgical gown - cotton - M"},{"$f":"'Biosafety and cleaning'!F37","v":0}]
[null,{"$f":"'Biosafety and cleaning'!B38","v":106500},{"$f":"'Biosafety and cleaning'!D38","v":"Surgical gown - cotton - S"},{"$f":"'Biosafety and cleaning'!F38","v":0}]
[null,{"$f":"'Biosafety and cleaning'!B39","v":106094},{"$f":"'Biosafety and cleaning'!D39","v":"First-aid kit for scientific laboratories"},{"$f":"'Biosafety and cleaning'!F39","v":0}]
[null,"Cleaning",null,null,null,"FIND"]
[null,{"$f":"'Biosafety and cleaning'!B10","v":106376},{"$f":"'Biosafety and cleaning'!D10","v":"Cotton wool"},{"$f":"'Biosafety and cleaning'!F10","v":0}]
[null,{"$f":"'Biosafety and cleaning'!B11","v":106444},{"$f":"'Biosafety and cleaning'!D11","v":"Plastic bags, biohazard waste, 30 L"},{"$f":"'Biosafety and cleaning'!F11","v":0}]
[null,{"$f":"'Biosafety and cleaning'!B12","v":106348},{"$f":"'Biosafety and cleaning'!D12","v":"Transparent polypropylene waste bag, 420 x 600 mm"},{"$f":"'Biosafety and cleaning'!F12","v":0}]
[null,{"$f":"'Biosafety and cleaning'!B13","v":106755},{"$f":"'Biosafety and cleaning'!D13","v":"Paper towels, 200"},{"$f":"'Biosafety and cleaning'!F13","v":0}]
[null,{"$f":"'Biosafety and cleaning'!B14","v":106359},{"$f":"'Biosafety and cleaning'!D14","v":"Sterile indicator tape, autoclave"},{"$f":"'Biosafety and cleaning'!F14","v":0}]
[null,{"$f":"'Biosafety and cleaning'!B15","v":106358},{"$f":"'Biosafety and cleaning'!D15","v":"Sterile indicator tape, hot-air oven"},{"$f":"'Biosafety and cleaning'!F15","v":0}]
[null,{"$f":"'Biosafety and cleaning'!B16","v":106377},{"$f":"'Biosafety and cleaning'!D16","v":"Absorbent laboratory paper"},{"$f":"'Biosafety and cleaning'!F16","v":0}]
[null,{"$f":"'Biosafety and cleaning'!B17","v":106363},{"$f":"'Biosafety and cleaning'!D17","v":"Tube brush"},{"$f":"'Biosafety and cleaning'!F17","v":0}]
[null,{"$f":"'Biosafety and cleaning'!B18","v":106371},{"$f":"'Biosafety and cleaning'!D18","v":"Disinfectant for BSC surface"},{"$f":"'Biosafety and cleaning'!F18","v":0}]
[null,{"$f":"'Biosafety and cleaning'!B19","v":106294},{"$f":"'Biosafety and cleaning'!D19","v":"Disinfectant for cleaning instrument"},{"$f":"'Biosafety and cleaning'!F19","v":0}]
[null,{"$f":"'Biosafety and cleaning'!B20","v":106370},{"$f":"'Biosafety and cleaning'!D20","v":"Disinfectant for floors"},{"$f":"'Biosafety and cleaning'!F20","v":0}]
[null,{"$f":"'Biosafety and cleaning'!B21","v":106374},{"$f":"'Biosafety and cleaning'!D21","v":"Disinfectant for hands, 1 L"},{"$f":"'Biosafety and cleaning'!F21","v":0}]
[null,{"$f":"'Biosafety and cleaning'!B22","v":106333},{"$f":"'Biosafety and cleaning'!D22","v":"Ethanol / isopropanol, 5 L"},{"$f":"'Biosafety and cleaning'!F22","v":0}]
[null,{"$f":"'Biosafety and cleaning'!B23","v":106331},{"$f":"'Biosafety and cleaning'!D23","v":"Phenol, 1 kg"},{"$f":"'Biosafety and cleaning'!F23","v":0}]
[null,{"$f":"'Biosafety and cleaning'!B24","v":106373},{"$f":"'Biosafety and cleaning'!D24","v":"Liquid soap"},{"$f":"'Biosafety and cleaning'!F24","v":0}]

{"sheet":"Sheet1","index":29,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"LPA and Tips","index":30,"n_rows":39,"n_cols":11,"rows_kept":39,"cut":false,"hidden":true,"merged":[[16,10,27,10],[14,2,21,2],[22,2,27,2]]}
[]
[]
[null,null,null,null,"P10","P20","P200","P1000","P1000 Long","Pasteur pipette"]
[null,null,null,"DNA Extraction"]
[null,null,"A1","500μl decontaminated specimen",null,null,null,null,"1 per sample for adding and one per sample for discard supernatent"]
[null,null,"A2","A-LYS - 100μl lysis buffer",null,null,"1 per sample"]
[null,null,"A4","Add A-NB - 100μl neutralisation buffer",null,null,"1 per sample"]
[null,null,"A5","5μl Supernatent for PCR tube","1 per sample"]
[null,null,null,"AMPLIFICATION"]
[null,null,null,"Master mix - Reagent A (AM-A)",null,null,"1 per batch"]
[null,null,null,"Mastemix - Reagent AM-B",null,null,null,"1 per batch"]
[null,null,null,"To aliquote into PCR tubes",null,null,"1 per batch"]
[null,null,"PCR ROOM"," n x 5 μl DNA","1 per sample"]
[null,null,null,"HYBRIDISATION"]
[null,null,"To add","DEN",null,null,"1 per batch"]
[null,null,null,"DNA/amplicon",null,null,"1 per sample"]
[null,null,null,"HYBRIDISATION",null,null,null,null,"1 per sample",null,"Not needed for GT Blot 48 ?"]
[null,null,null,"STR",null,null,null,null,"1 per sample"]
[null,null,null,"RINS",null,null,null,null,"3 per batch"]
[null,null,null,"WATER",null,null,null,null,"3 per batch"]
[null,null,null,"SUB (dilution / Fill)",null,null,"1 per batch",null,"1 per batch"]
[null,null,null,"CONJ (Dilution / Fill)",null,null,"1 per batch",null,"1 per batch"]
[null,null,"to remove","HYBRIDISATION",null,null,null,null,null,"1 per sample"]
[null,null,null,"STR",null,null,null,null,null,"1 per batch"]
[null,null,null,"RINS",null,null,null,null,null,"2 per batch"]
[null,null,null,"WATER",null,null,null,null,null,"1 per batch"]
[null,null,null,"SUB",null,null,null,null,null,"1 per batch"]
[null,null,null,"CONJ",null,null,null,null,null,"1 per batch"]
[]
[null,null,null,"Sample",2,null,3,null,4,1]
[null,null,null,"Batch",null,null,5,1,8,6]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Injectible water for LPA DST from specimen coming from liquid culture 0.1 ml / solid culture 0.3 ml"]

{"sheet":"Lab items list","index":31,"n_rows":421,"n_cols":8,"rows_kept":421,"cut":false,"hidden":true,"merged":[[16,6,16,11],[132,6,132,11],[152,6,152,11],[315,1,316,4]]}
["List of laboratories items",null,"Back to Lab"]
[]
["Equipment",null,"Chemicals",null,"Consumables"]
[null,"Microscopy laboratory","Microscopy laboratory",null,"MIcroscopy laboratory"]
[null,"Culture laboratory","Culture laboratory",null,"Culture laboratory"]
[null,"DST laboratory","DST laboratory",null,"DST laboratory"]
[null,"Molecular tests","Molecular tests",null,"Molecular tests"]
[]
[null,null,"Number ","Unit cost (US$)","Possible alternatives"]
[null,"All prices indicated below are \"free on board\" (FOB) i.e. do not include shipping, insurance, import duties, local distributor margin for service and support, installation and maintenance.",null,null,"This column provides alternatives of equipment. If you wish to include them in your cost please copy the cells into the previous columns (B to D), so that the inputs (quantities and prices) are taken into account in the cost of the lab package."]
["EQUIPMENT"]
[]
["Ù Home"]
[]
[]
["Culture laboratory"]
[null,"Indicated quantities are based on experience and estimated for a laboratory performing approximately 12,000 cultures. Quantities should be adjusted according to the actual workload and methods used. "]
[]
[null,"ITEMS (solid media)","Number ","Unit cost (US$)","Possible alternatives","Number","Unit cost (US$)"]
[null,"Base Support for Laminar Air Flow Cabinet",2,1024.7249999999999]
[null,"BSC, class I or II",2,17761.900000000001]
[null,"UPS for BSC ",2,1639.56]
[null,"Minishaker or Vortex",3,478.20499999999998]
[null,"Optional : overhead stirrer, for at least 10 tubes (50 ml)",2,1639.56]
[null,"Test tube rack 18/8 stainless steel, diameter 16 mm ",5,38.256399999999999]
[null,"Test tube rack 18/8 stainless steel, diameter 35 mm",5,31.424900000000001]
[null,"Safety gas burner with glass chimney, footswitch for temporary ignition ",2,573.846," Electric micro incinerator for loops",1,245.93400000000003]
[null,"Safety gas tubing with safety clamps on both ends, inner diameter 9mm",2,40.989000000000004]
[null,"Inoculation loops, Platinum/Iridium wire, closed, 10 µl",6,122.96700000000001,"Disposable loops,100 x 10 pieces per pack",15,81.978000000000009]
[null,"Loop holder",12,9.5640999999999998]
[null,"Racks for loop holder",4,16.395600000000002]
[null,"Stainless steel bucket with lid, capacity 10L",5,150.29300000000001]
[null,"Discard bottle, stainless steel or thick walled glass with screw cap",5,4.0989000000000004]
[null,"Funnel, stainless steel 18/8,  top diameter 120 mm",3,18.445050000000002]
[null,"Safety box, PP, approx 3 L, for all sharps ",25,4.2355300000000007]
[null,"Laboratory chair, disinfectable, 5 wheels, no arm rests",2,245.93400000000003]
[null,"Incubator",2,9290.84]
[null,"Centrifuge",1,8880.9500000000007]
[null,"Centrifuge rotor",1,1229.67]
[null,"Centrifuge rotor buckets ",4,409.89]
[null,"Aerosol tight lids for rotor buckets ",4,136.63]
[null,"Reducing adapter for 50 ml centrifuge tubes ",4,109.304]
[null,"Reducing adapter for 15 ml/12 ml centrifuge tubes ",4,109.304]
[null,"Autoclave",2,15029.3]
[null,"Autoclave control unit for fully automated process control",2,3005.86]
[null,"Exhaust air filtration system for autoclave",1,3552.38]
[null,"Autoclave control unit for sterilization of liquids, including temperature probe",1,3361.098]
[null,"Autoclave recooling system to shorten the time of liquid sterilization",1,3415.75]
[null,"Wire baskets or stainless steel buckets for autoclave ",2,245.93400000000003]
[null,"Wire baskets with drip tray for autoclave ",2,478.20499999999998]
[null,"Hot-air oven",1,3825.64]
[null,"Optional Ion exchanger cartridge, flow rate approx. 950 L/h",2,1093.04]
[null,"Conductivity measuring device for laboratory grade water, digital",2,437.21600000000001]
[null,"Ion exchanger resin for laboratory grade water, pack of 5x10 L resin",5,81.978000000000009]
[null,"Water distiller",1,1776.19]
[null,"Balloon high-density poyethylene (HDPE) with discharge cock, 30 liters",1,81.978000000000009]
[null,"Balloon high-density poyethylene (HDPE) with discharge cock, 10 liters",4,54.652000000000001]
[null,"Stop cock, winding for HDPE balloon",10,4.4404750000000002]
[null,"Racks for test tubes, PP, autoclavable,  60 positions",12,10.930400000000001,"Racks for 28 ml universal vials, PP, autoclavable, 48 positions",150,10.930400000000001]
[null,"Alarm clock / digital timer, 4 digits",1,27.326000000000001]
[null,"Safety-Pipetting Ball, standard",10,3.4157500000000001]
[null,"Automated pipetting aid, battery capacity for 8 h work, 200 g weight",2,478.20499999999998,"Set of mechanical pipetting aids: up to 0.2 ml; up to 2 ml and up to 10 ml",2,68.314999999999998]
[null,"Pipette washer  ",1,170.78749999999999]
[null,"Transport boxes for specimens meeting WHO requirements of P650 package",10,20.494500000000002]
[null,"Electronic maxima-minima-thermometers, two channels, thin cable with sensor, battery, measuring range -50°C/+60°C",10,27.326000000000001]
[null,"Electronic maxima-minima-thermometers, two channels, battery, measuring range -10°C/+50°C ",10,27.326000000000001]
[null,"Dispenser for 1000 ml bottle for liquid soap, for wall mounting, 1 per sink",2,68.314999999999998]
[null,"Dispenser for hand towels, for wall mounting, 1 per sink",2,47.820500000000003]
[null,"Goggles, according to EN 166 and EN 170, frame adjustable, integrated side and top protection, total weight <40 g ",5,8.1978000000000009]
[null,"Emergency spill-kit",1,34.157499999999999]
[null,"First aid kit",1,327.91200000000003]
[null,"Anemometer",1,2049.4499999999998]
[null,"Analytical balance",1,4782.05]
[null,"pH meter",1,819.78]
[null,"Bunsen burner with fine tuning",1,143.4615]
[null,"Tripod stand",1,16.395600000000002]
[null,"Water bath, capacity approximately 20 L ",1,1502.93]
[null,"Magnetic stirrer",1,580.67750000000001]
[null,"Magnetic stirring bars, round-shaped, polytetrafluorethylen (PTFE) coated. Set of 10: 1x 15 mm, 2X 20 mm, 2x 25 mm, 1x 30 mm, 2x 40 mm, 2x 50 mm length. ",1,68.314999999999998]
[null,"Sterile filling station of culture media, consisting of 1000 ml Squibb sedimentation funnels or cylindric dropping funnels, with tube for pressure exchange, stopcocks made of glass and Teflon stopper, outlet diameter 4 mm ",3,68.314999999999998]
[null,"Stative for Squibb sedimentation funnels consisting of plate, rod and clamp",3,136.63]
[null,"Inspissator for coagulation of egg-based culture media",1,8197.7999999999993]
[null,"Refrigerator with freezing department ",1,819.78]
[null,"Refrigerator ",2,409.89]
[null,"Stainless steel funnel, short wide stem with air drain, diameter 150 mm on top",5,13.663]
[null,"Swan neck bottles (PE flask, narrow neck with screw cap and water dispenser) set of one each 250, 500, 1000ml",5,16.395600000000002]
[null,"Bowl, plastic, 500 x 350 mm",5,2.7326000000000001]
[null,"Erlenmeyer flasks, borosilicate 3.3, wide neck, graduated, autoclavable, 2000 ml",2,34.157499999999999]
[null,"Erlenmeyer flasks, borosilicate 3.3, wide neck, graduated, autoclavable, 1000 ml",10,163.95600000000002]
[null,"Erlenmeyer flasks, borosilicate 3.3, wide neck, autoclavable, 500 ml",10,81.978000000000009]
[null,"Erlenmeyer flasks, borosilicate 3.3, wide neck, graduated, autoclavable, 250 ml",10,61.483500000000006]
[null,"Erlenmeyer flasks, borosilicate 3.3, wide neck, graduated, 100 ml, pack. unit 10",20,54.652000000000001]
[null,"Erlenmeyer flasks, borosilicate 3.3, wide neck, graduated, autoclavable, 50 ml",20,54.652000000000001]
[null,"Measuring cylinder, class A; TPX, autoclavable, 1000 ml, graduated 10.0 ml",5,22.270690000000002]
[null,"Measuring cylinder, class A; TPX, autoclavable, 500 ml, graduated 5.0 ml",5,14.346150000000002]
[null,"Measuring cylinder, class A; TPX, autoclavable,  250 ml, graduated 2.0 ml",5,9.4957850000000015]
[null,"Measuring cylinder, class A; TPX, autoclavable, 100 ml, graduated 1.0 ml",5,6.1483500000000006]
[null,"Measuring cylinder, class A; TPX, autoclavable, 50 ml, graduated 1.0 ml",5,4.6454200000000005]
[null,"Thick-walled glass flask for preparation of culture medium; with flanged rim; 2500 ml ",6,58.750900000000001]
[null,"Thick walled bottles, borosilicate 3.3, graduated, transparent, PP ring and cap, 2000 ml",3,24.593400000000003]
[null,"Thick walled bottles, borosilicate 3.3, graduated, transparent, PP ring and cap, 1000 ml ",10,14.346150000000002]
[null,"Thick walled bottles, borosilicate 3.3, graduated, transparent, PP ring and cap, 500 ml;    ",5,9.2908400000000011]
[null,"Thick walled bottles, borosilicate 3.3, graduated, amber, PP ring and cap, 11000 ml",3,16.395600000000002]
[null,"Thick walled bottles, borosilicate 3.3, graduated, amber, PP ring and cap, 1, 2000 ml",2,27.326000000000001]
[null,"Screw caps with weld in PFTE membrane, 0.2 µm pore size, autoclavable to 140 °C",10,3.0058600000000002]
[null,"Laboratory beaker, EFTE, low form with graduation and spout, 2000 ml",3,136.63]
[null,"Laboratory beaker, EFTE, low form with graduation and spout, 1000 ml     ",3,68.314999999999998]
[null,"Laboratory beaker, EFTE, low form with graduation and spout, 600 ml",10,54.652000000000001]
[null,"Laboratory beaker, EFTE, low form with graduation and spout, 250 ml",10,24.593400000000003]
[null,"Laboratory beaker, EFTE, low form with graduation and spout, 100 ml",10,15.029300000000001]
[null,"Laboratory glassware drying rack, wall mounted; polystyrene; minimum 24 pegs ",1,184.45050000000001]
[null,"Funnel, soda lime glass, plain, short stem, d =   75 mm",5,6.8315000000000001]
[null,"Funnel, soda lime glass, plain, short stem, d = 125 mm",5,10.930400000000001]
[null,"Powder funnel , diameter 100mm",5,10.930400000000001]
[null,"Glass beads, massive glass, 5 mm diameter",2,34.157499999999999]
[null,"Glass beads, massive glass, 3 mm diameter",1,34.157499999999999]
[null,"Thick walled Pyrex tubes with ISO winding and autoclavable screw cap with tight gasket, 16x100 mm; package of 100",10,109.304]
[null,"Strainer, stainless steel, 1 grip, 2 eyes, diameter 20 cm",1,21.860800000000001]
[null,"Forceps; pointed; straight; 18/8 stainless steel, polished",5,9.3864809999999999]
[null,"Optional: Laboratory washer-disinfector for laboratory glass, 2 baskets",1,5055.3100000000004]
[null,"Separate water supply for deionised water with conductivity measure R 3/4\" with digital display and hose-set for in-and outflow ",1,929.08400000000006]
[null,"Aqua purificator cabinet for two de-mineralising cartridges",1,409.89]
[null,"Cost of equipment for culture laboratories (solid media)",null,{"$f":"SUMPRODUCT(C20:C122,D20:D122)","v":177698.3820300001}]
[]
[null,"Additional equipment for liquid culture and/or DST"]
[null,"ITEMS","Number ","Unit cost (US$)","Possible alternatives","Number","Unit cost (US$)","Notes"]
[null,"Automated analyser for liquid culture media with growth detection based on a fluorescent signal, 960 vials",2,79655.289999999994,"Automated analyser for liquid culture media with growth detection based on a fluorescent signal, 120 vials",12,36535]
[null,"Automated analyser for liquid culture media with growth detection based on a fluorescent signal, 960 vials",2,38950,null,null,null,"This is a FIND negotiated price for, please find the countries that can access to this special price in:  http://www.finddiagnostics.org/about/what_we_do/successes/find-negotiated-prices/bactec-mgit.html"]
[null,"Cost of additional equipment for culture and DST laboratories (liquid media)",null,{"$f":"SUMPRODUCT(D127:D128)","v":118605.29}]
[]
[]
["Drug-susceptibility testing (DST)"]
[null,"Indicated quantities are based on experience and estimated for a laboratory performing 1000 first-line DST (and possibly 100 second-line DST) in addition to cultures. Quantities should be adjusted according to the actual workload and strategy used."]
[]
[null,"ITEMS (solid media)","Number ","Unit cost (US$)"]
[null,"Desiccator, borosilicate glass, inner diameter 150-200 mm, lid with thread GL 32",2,273.26]
[null,"Membrane vacuum pump for desiccator, pressure endpoint < 20 mbar",1,1093.04]
[null,"Woulff flask consisting of borosilicate glass, 1000 ml with thread GL 45 screw cap",1,47.820500000000003]
[null,"Vacuum tube, 3m",1,27.326000000000001]
[null,"Precision balance",1,1366.3]
[null,"Sterile filling station of culture media, consisting of 250 ml Squibb sedimentation funnels or cylindric dropping funnels, with tube for pressure exchange, stopcocks made of glass and Teflon stopper, outlet diameter 4 mm ",7,40.989000000000004]
[null,"Refrigerator with freezing department ",1,819.78]
[null,"Refrigerator ",1,409.89]
[null,"Optional: Chest freezer, 70 litres, temperature range: -18 °C to - 28 °C, complete with cassettes and racks",1,1366.3]
[null,"Pipettes 1 ml, glass, graduated 0,01 ml, conformity certified, pack of 10 pieces",3,27.326000000000001]
[null,"Pipettes 2 ml, glass, graduated 0,02 ml, conformity certified, pack of 10 pieces",3,28.692300000000003]
[null,"Pipettes 10 ml, glass, graduated 0,05 ml, conformity certified, pack of 10 pieces",3,30.058600000000002]
[null,"Pipettes 5 ml, glass, graduated 0,1 ml, conformity certified, pack of 10 pieces",3,31.424900000000001]
[null,"Pipette box aluminium with lid, autoclavable, suitable for 35 cm long pipettes  ",10,136.63]
[null,"Cost of equipment for DST (solid media)",null,{"$f":"SUMPRODUCT(C136:C149,D136:D149)","v":7682.7049000000006}]
[]
[]
["Molecular laboratory "]
["Line-Probe Assays"]
[null,"Indicated quantities are based on experience and estimated for a laboratory performing approximately 1000 line-probe assays. Quantities should be adjusted according to the actual workload and strategy used."]
[]
[null,"ITEMS","Number ","Unit cost (US$)","Possible alternatives","Number","Unit cost (US$)"]
[null,"PCR-Workstation UV",1,3142.49]
[null,"Thermocycler",1,4782.05]
[null,"Ultrasonic bath",1,1639.56]
[null,"Thermoshaker for hybridization",1,3005.86,"Automate for hybridization, for 48 strips",1,19674.72]
[null,"Optional 8-channel pipette, 5 - 50 µl",1,587.50900000000001]
[null,"Optional 8-channel pipette, 50 - 300 µl",1,587.50900000000001]
[null,"Optional Electrophoresis, horizontal mini gel system ",1,409.89]
[null,"Optional Power supply for electrophoresis",1,478.20499999999998]
[null,"Optional UV-light illuminator at least 200 x 200 mm window",1,1639.56]
[null,"Optional Microwave oven, approx. 900 W, inner volume minimum 20 litres",1,819.78]
[null,"Racks, for tubes 1.5 - 2 ml, 10 mm diameter, at least 20 positions",10,6.8315000000000001]
[null,"Centrifuge for standard reaction tubes",1,2459.34]
[null,"Floating rack for 20 seats, diameter 10 mm, 2ml, for ultrasonic bath",2,9.5640999999999998]
[null,"Deep freeze storage box with lid for 2 ml cryovials , autoclavable PP",10,10.930400000000001]
[null,"Deep freeze storage box with lid for 0.2ml PCR tubes, autoclavable PP. ",10,11.067030000000001]
[null,"1-channel pipette, variable from 0.5 - 10 µl, ",3,273.26]
[null,"1-channel pipette, variable from 10 - 100 µl",4,273.26]
[null,"1-channel pipette, variable from 100 - 1000 µl,",4,273.26]
[null,"Racks suitable for pipettes offered, at least 4 positions",4,109.304]
[null,"Refrigerator with freezing department",1,409.89]
[null,"Freezer",1,546.52]
[null,"Stand for multichannel pipettes",1,122.96700000000001]
[null,"Hand-dispenser pipette, 5 dosage steps, suited for combitips",2,218.608]
[null,"Tripod stand for waste bags of 2 litres",5,10.247250000000001]
[null,"Cost of equipment for Molecular tests",null,{"$f":"SUMPRODUCT(C158:C181,D158:D181)","v":24870.075750000004}]
[]
["Xpert"]
[null,"ITEMS","Number ","Unit cost (US$)"]
[null,"Cost of one GeneXpert 4-module unit with laptop",1,17500]
[null,"Shipment, per machine",null,1000]
[null,"Uninterruptible power source",null,500]
[]
[null,"Printer",1,200]
[null,null,null,{"$f":"+SUM(D186:D190)","v":19200}]
[]
[null,"Cartridge and maintenance for XPERT","Number ","Unit cost (US$)"]
[null,"The average number of tests per machine per day is 15. So, the maximum number of cartridges per year is 3750 (=15*250 working days). Add 10% more due to losses because of damage or incorrect use."]
[null,"Cartridge, cost per one cartridge",null,16.86]
[null,"Cost of equipment maintenance per GeneXpert machine per year (range US$ 500-1800)",null,1800]
[]
[null,"For further information on Xpert please look at:"]
[null,"http://whqlibdoc.who.int/hq/2011/WHO_HTM_TB_2011.12_eng.pdf"]
[]
[]
["CHEMICALS"]
[]
[]
["Culture laboratory, chemicals"]
[null,"According to the SoP, prepare a batch of 1600 ml and adjust according to the workload"]
[]
[null,"ITEMS","Number ","Unit cost (US$)","Possible alternatives","Number","Unit cost (US$)"]
[null,"Loewenstein-Jensen medium**",null,null,"Lowenstein-Jensen medium from components"]
[null,"Ready-to-use mix, 500g",7,134,"Potassium dihydrogen phosphate, KH2PO4, MW: 136,09, 1 kg ",1,44]
[null,"Fresh eggs fed without growth factors (antibiotics), 25 per 1600 ml medium final volume ",2000,"local cost","Magnesium sulfate-heptahydrate,  MgSO4 • 7H2O, MW: 246,48. 500g ",1,21]
[null,"Glycerol >99% purity, 1 litre",2,38,"L-Asparagine-momohydrate, C4H8N2O3 • H2O, MW: 150.13, 250g",2,86]
[null,null,null,null,"tri-Magnesium di-citrate nonahydrate, Mg3(C6H5O7)2 • 9 H2O,  500g ",1,36]
[null,"** Prepare a batch of 1600 ml according to the SoP, to be dispensed in 6–8 ml volumes into sterile McCartney bottles or 16 x 125 mm screw-capped tubes. Estimate the number of tubes per batch (+/-260 tubes). ",null,null,"Malachite green oxalate, 100 g ",1,21]
[null,null,null,null,"glycerol >99% purity, 1 litre",2,38]
[null,null,null,null,"fresh eggs fed without growth factors (antibiotics), 25 per 1600 ml medium final volume",2000,"local cost"]
[]
[null,"ITEMS","Number ","Unit cost (US$)"]
[null,"Modified Ogawa medium"]
[null,"Sodium-L-Glutamate-monohydrate, C5H8NNaO4 · H2O,  1 kg ",1,45]
[null,"Potassium dihydrogen phosphate, KH2PO4, MW: 136,09, 1 kg ",1,44]
[null,"Malachite green oxalate, 100 g ",1,21]
[null,"Magnesium sulfate-heptahydrate,  MgSO4 • 7H2O, MW: 246,48. 500g ",1,21]
[null,"Glycerol >99% purity, 1 litre",2,38]
[null,"Fresh eggs fed without growth factors (antibiotics), 25 per 1600 ml medium final volume",2000,"local cost"]
[]
[null,"Phosphate buffer according to Soerensen, 1/15 M, pH 6.8 or adjustable between pH 5 to 8.2"]
[null,"ITEMS","Number ","Unit cost (US$)","Possible alternatives","Number","Unit cost (US$)"]
[null,"di-Sodium hydrogen phosphate anhydrous, Na2HPO4, MW: 141.96, 1 kg ",2,49,"di-Sodium hydrogen phosphate dodecahydrate Na2HPO4 12 H2O , MW: 358,14, 1 kg  ",2,48]
[null,"Potassium dihydrogen phosphate, KH2PO4, MW: 136,09, 1 kg ",2,44]
[]
[null,"Petroff decontamination method"]
[null,"ITEMS","Number ","Unit cost (US$)"]
[null,"Sodium hydroxide, NaOH, MW 40.00, purum ≥ 98%, pellets, 1kg",2,16]
[]
[null,"Tri-sodium phosphate decontamination method"]
[null,"ITEMS","Number ","Unit cost (US$)"]
[null,"tri-sodium phosphate dodecahydrate, Na3PO4 · 12H2O, MW: 380.12, 2.5 kg",4,48]
[]
[null,"NALC decontamionation method"]
[null,"ITEMS","Number ","Unit cost (US$)"]
[null,"N-acetyl-L-cysteine (NALC), C5H9NO3S, MW: 163.19,puriss. ≥ 99%, 250g",1,205]
[null,"tri-Sodium citrate dihydrate, C6H5Na3O7 · 2H2O, MW: 294.10, 1 kg",1,56]
[null,"Sodium hydroxide, NaOH, MW 40.00, purum ≥ 98%, pellets, 1kg",1,16]
[]
[null,"Cetylpyridinum chloride for specimen transportation"]
[null,"ITEMS","Number ","Unit cost (US$)"]
[null,"Cetylpyridinium chloride monohydrate, C21H38ClN · H2O, MW: 358.01, purity ≥ 98% for biochemistry, 500g",1,61]
[null,"Sodium chloride, NaCl, MW: 58.44, ≥ 99%, 1kg",1,14]
[]
[null,"Pre-treatment for urine"]
[null,"ITEMS","Number ","Unit cost (US$)"]
[null,"5-Sulfosalicylic acid dihydrate, C6H7NO3S· 2H2O, MW: 254,22, ≥ 99%, 100g "]
[]
[null,"Neutralization of gastric washings"]
[null,"ITEMS","Number ","Unit cost (US$)"]
[null,"sodium bicarbonate, NaHCO3, MW 84,  ≥ 99%, 500g ",1]
[]
[null,"Reagents for biochemical identification"]
[null,"ITEMS","Number ","Unit cost (US$)"]
[null,"Para-nitrobenzoic acid, (PNB), C7H5O4, MW: 167,12, purum ≥ 98%, 250g",1,15]
[null,"Thiophene-2-carboxylic acid hydrazide, (TCH), C5H6ON2S, MW: 142.21, ≥ 97%; 5g",2,107]
[null,"Niacin strips, 50 per pack",1000,102]
[null,"Tween® 80, (Polyoxyethlene-80-sorbitan monooleate), 1kg",1,52]
[null,"Hydrogen peroxide, H2O2, MW: 34.01, 30%, 250 ml",1,19]
[null,"Potassium dihydrogen phosphate, KH2PO4, MW: 136,09, 1 kg",1,44]
[null,"di-Sodium hydrogen phosphate anhydrous, Na2HPO4, MW: 141.96, 1 kg ",1,49]
[null,"Sodium nitrate, NaNO3, MW:84.99, p.a. ≥ 99.5%, 500g ",1,23]
[null,"Sulphanilamide, C6H8N2O2S, MW: 172.21, p.a. ≥ 98%,100g",1,55]
[null,"N-(1-Naphthyl)-ethylendiamine dihydrochloride, C12H14N2 · 2HCl, MW: 259.18, p.a.≥ 98%, 25g",1,82]
[null,"Zinc dust, 250g bottle",1,53]
[null,"Hydrochloric acid, HCl, purum, ≥ 35%, 1 L",1,27]
[]
[]
[null,"reagent for long-term storage of mycobacterial culture: "]
[null,"ITEMS","Number ","Unit cost (US$)"]
[null,"Skim milk powder, 500g",1,29]
[]
[null,"McFarland standard"]
[null,"ITEMS","Number ","Unit cost (US$)"]
[null,"Bariumchlorid dihydrate, BaCl2 · 2H2O, MW: 244.26, p.a.≥ 99%, 250 g",1,15]
[null,"Sulphuric acid, 100 ml",1,27]
[]
[]
["DST laboratory, chemicals"]
[null,"Indicated quantities are based on experience and estimated for a laboratory performing approximately 1,000 FL-DST (and possibly 100 SL-DST). Quantities should be adjusted according to the workload and methods used.  "]
[]
[null,"First line drugs"]
[null,"ITEMS","Number ","Unit cost (US$)","Possible alternatives","Number","Unit cost (US$)"]
[null,"5g Isoniazid ",1,23]
[null,"1g Rifampicin",1,82]
[null,"25 g Ethambutol",1,96]
[null,"5g Dihydro-streptomycin",1,25]
[]
[null,"Second Line Drugs"]
[null,"Ofloxacin/Ciprofloxacin, 2 g",1,30,"Moxifloxacin, 2 g",1]
[null,"Protionamid, 2 g",1,null,"Ethionamid, 2 g",1]
[null,"Kanamycin, 2 g",1,42,"Amikacin, 2 g",1,61]
[null,"capreomycin, 2 g",1,158]
[]
[null,"Dimethyl sulfoxide, 99,8%, p. a., 500 ml",1,27]
[]
[]
["Molecular tests, chemicals"]
[null,"Indicated quantities are based on experience and estimated for a laboratory performing approximately 1,000 line-probe assays. Quantities should be adjusted according to the workload and methods used."]
[]
[null,"ITEMS","Number ","Unit cost (US$)"]
[null,"Taq Polymerase, 250 units/vial; one vial per 200 amplifications",5,178]
[]
[]
[]
["CONSUMABLES"]
[]
[]
["Culture laboratory, consumables"]
[null,"Indicated quantities are based on experience and estimated for a laboratory performing approximately 12,000 cultures. Quantities should be adjusted to the actual workload and methods used.  "]
[]
[null,"ITEMS (solid media)","Number ","Unit cost (US$)","Possible alternatives","Number","Unit cost (US$)"]
[null,"Culture tubes, diameter 16 mm, pack of 100",260,40.989000000000004,"Universal glass bottle 28 ml, pack of 100",260,102.4725]
[null,"PP-tubes for centrifuge, 50 ml; 500 pieces/pack",60,163.95600000000002]
[null,"PP-tubes for centrifuge, 15 ml; 500 pieces/pack",4,163.95600000000002]
[null,"Loop, disposable 10 m, 10pieces/pack",1500,81.978000000000009]
[null,"Plastic Pasteur pipettes, 1.5 ml, 500 pieces/pack",30,54.652000000000001]
[null,"Cryo-vial, sterile with cap, 2 ml",1,199.47980000000001]
[null,"Deep freeze storage box with lid for 2 ml cryovials , autoclavable PP",10,10.930400000000001]
[null,"Gloves, vinyl or nitrile, powder free, disposable, size S, 100/pack",60,16.395600000000002]
[null,"Gloves, vinyl or nitrile, powder free, disposable, size M, 100/pack",90,16.395600000000002]
[null,"Gloves, vinyl or nitrile, powder free, disposable, size L, 100/pack",30,16.395600000000002]
[null,"Plastic bags for waste bins, 1000 pieces per pack",1,30.058600000000002]
[null,"Stands for small plastic bags (2 litres)",5,10.930400000000001]
[null,"Autoclavable bags at 134°C, 410 x 620 mm, 100 pieces per pack",10,54.652000000000001]
[null,"Filter paper round, diameter 185, packs of 100",3,10.930400000000001]
[null,"Filter paper round, diameter 150, packs of 100",6,9.5640999999999998]
[null,"Marker pen, water resistant",3,6.8315000000000001]
[null,"Adhesive labels, pack of 4800 labels",2,62.849800000000002]
[null,"Cryo-tags sized to fit for use on cryo-tubes, rolls of 1000",5,57.384600000000006]
[null,"Sterilindicator tape (rolls), 55 m long, for hot air sterilizer (green/brown)",5,30.058600000000002]
[null,"Sterilindicator tape (rolls), 55 m long,  for autoclave (beige/dark brown)",5,17.761900000000001]
[null,"Aluminium foil, 100 m long",3,157.12450000000001]
[null,"Parafilm, 100 mm width with dispenser",3,31.424900000000001]
[null,"Plastic-foil rolls, 30 cm",5,10.930400000000001]
[null,"Tube brush 280 mm long",20,2.7326000000000001]
[null,"Brush for glassware 120 mm long",10,6.8315000000000001]
[null,"Laboratory coat, size L",10,47.820500000000003]
[null,"Laboratory coat, size M",20,47.820500000000003]
[null,"Laboratory coat, size S",10,47.820500000000003]
[null,"FFP2 or FFP3 respirators, individually packed, packs of 10",1,102.4725]
[null,"Disinfectant for floors, container 10 litres ",6,72.413899999999998]
[null,"Disinfectant, ethanol-based, container 5 litres",8,64.216099999999997]
[null,"Spray hand for bottle with disinfectant of 1 litre",6,6.8315000000000001]
[null,"Liquid soap, pH neutral, bottle of 1 litre",12,9.5640999999999998]
[null,"Disinfectant for hands, alcohol-based,  1 litre bottle",15,10.930400000000001]
[null,"Paper towels, single-use, box. 150 towels/pack, 30 packs/ carton",5,58.750900000000001]
[null,"Cotton wool, 1 kg",10,2.7326000000000001]
[null,"Tissue pulp, absorbent sheets, approx. 550 x 350 mm",30,6.8315000000000001]
[null,"Detergent/washing powder for laboratory dish washer, 10 kg/pack",36,81.978000000000009]
[null,"Salt for dish washer, 10 kg/pack",10,20.494500000000002]
[null,"Rinse aid for dish washer, 1 litre",10,16.395600000000002]
[null,"Cost of consumables for culture laboratory (estimate of 12,000 cultures) (solid media)",null,{"$f":"SUMPRODUCT(C319:C358,D319:D358)","v":158283.12240000005}]
[]
[null,"Additional consumables for liquid culture methodology"]
[null,"ITEMS (liquid media)","Number ","Unit cost (US$)","Possible alternatives","Number","Unit cost (US$)","Notes"]
[null,"Tube and growth supplement for liquid cultures, growth detection based on fluorescence signal, per test",12000,13.663,"Tube and growth supplement for liquid cultures, growth detection based on pH colour change, per test",12000,12.296700000000001]
[null,"Tube and growth supplement for liquid cultures, growth detection based on fluorescence signal, per test",12000,2.76,null,null,null,"This is a FIND negotiated price for the HBCs (except Brazil and Russian Federation) plus Azerbaidjan, Bostwana, Cote d'Ivoire, Djibouti, Georgia, Kyrgyzstan, Lesotho, Malawi, Namibia, Nepal, Moldova, Rwanda, Sierra Leone, Somalia, Swaziland, Taijikistan, "]
[null,"Petri-dishes, disposables, sterile; 20 per bag, 15 bags per package",10,109.304]
[null,"Droppers, disposable, 1.5 ml, 20 per bag and 25 bags per package",30,81.978000000000009]
[null,"Cost of consumables for culture laboratory (estimate of 12,000 cultures) (liquid media)",null,{"$f":"SUMPRODUCT(C363:C366,D363:D366)","v":200628.38}]
[]
[]
["DST laboratory, consumables"]
[null,"Indicated quantities are based on experience and estimated for a laboratory performing 1,000 FL-DST (and possibly 100 SL-DST) in addition to cultures. Quantities should be adjusted to the actual workload and methods used.  "]
[]
[null,"ITEMS (solid media)","Number ","Unit cost (US$)","Possible alternatives","Number","Unit cost (US$)","Notes"]
[null,"Syringes, single use, 20 ml, 100 pieces per pack",1,88.8095]
[null,"Syringe filters, 100 pieces per pack",1,409.89]
[null,"Silica gel for desiccator, 0.5 kg",1,40.989000000000004]
[null,"Immunochromatographic tests for the rapid identification of Mycobacterium tuberculosis, per test",1000,29]
[null,"Immunochromatographic tests for the rapid identification of Mycobacterium tuberculosis, per test",1000,1.6,null,null,null,"FIND negotiated price for the 22 HBC"]
[null,"Cost of consumables for FL-DST laboratory (1000 FL, plus possibly 100 SL), solid media",null,{"$f":"SUMPRODUCT(C374:C378,D374:D378)","v":31139.6885}]
[]
[null,"Additional consumables for liquid  DST methodology"]
[null,"ITEMS","Number ","Unit cost (US$)","Possible alternatives","Number","Unit cost (US$)","Notes"]
[null,"Tube and growth supplement for liquid cultures, growth detection based on fluorescence signal, per test",6000,13.663,"Tube and growth supplement for liquid cultures, growth detection based on pH colour change, per test",6000,12.296700000000001]
[null,"Tube and growth supplement for liquid cultures, growth detection based on fluorescence signal, per test",6000,2.76,null,null,null,"This is a FIND negotiated price for, please find the countries that can access to this special price in:  http://www.finddiagnostics.org/about/what_we_do/successes/find-negotiated-prices/bactec-mgit.html"]
[null,"Cost of consumables for FL-DST laboratory (1000 FL, plus possibly 100 SL), liquid media",null,{"$f":"SUMPRODUCT(C383:C384,D383:D384)","v":98538}]
[]
[]
[]
[]
["Molecular Biology, consumables"]
[null,"Indicated quantities are based on experience and estimated for a laboratory performing approximately 1,000 line-probe assays. Quantities should be adjusted according to the workload and strategy used."]
[]
[null,"ITEMS","Number ","Unit cost (US$)","Possible alternatives","Number","Unit cost (US$)","Notes"]
[null,"Standard reaction tubes with O-ring,  1.5 ml, 1000 per pack",10,177.619]
[null,"Standard reaction tubes with O-ring,  2 ml, 1000 per pack",10,177.619]
[null,"Cryo-vial, sterile with cap, 2 ml, with outer winding; pack of 1000",3,245.93400000000003]
[null,"Cryo-tags, sized to fit for use on cryo-tubes, rolls of 1000",3,57.384600000000006]
[null,"PCR tubes, 0.2 ml with attached caps, sterile, DNAse- RNAse-free, 1000 per pack",10,116.13550000000001]
[null,"DNAse-/RNAse-free TIPS, for pipettes  0.1 - 10 µl, 10 boxes at 96 per pack",10,88.8095]
[null,"DNAse-/RNAse-free TIPS, for pipettes 1 - 20 µl, 10 boxes at 96 per pack",40,88.8095]
[null,"DNAse-/RNAse-free TIPS, for pipettes 10 - 100 µl, 10 boxes at 96 per pack",20,88.8095]
[null,"DNAse-/RNAse-free TIPS, for pipettes 20 - 200 µl, 10 boxes at 96 per pack",10,81.978000000000009]
[null,"TIPS, PE, for pipettes 0.5 -  10 µl, 1000 per pack",10,19.1282]
[null,"TIPS, PE, for pipettes 1 -  200 µl, 1000 per pack ",5,21.860800000000001]
[null,"TIPS, PE, for pipettes 100 -  1000 µl , 1000 per pack",5,19.1282]
[null,"Pasteur-pipettes, plastic, sterile, 1.5ml, 500 per pack",30,54.652000000000001]
[null,"Combitips for Multipette 5 ml,  100 pieces/pack ",3,109.304]
[null,"Combitips for Multipette 10 ml,  100 pieces/pack ",3,109.304]
[null,"Plastic bags, disposable PP, 100 pieces per pack",5,13.663]
[null,"Gloves, vinyl, powder free, disposable, size S, 100 per pack",60,16.395600000000002]
[null,"Gloves, vinyl, powder free, disposable, size M, 100 per pack",90,16.395600000000002]
[null,"Gloves,  vinyl, powder free, disposable, size L, 100 per pack",30,16.395600000000002]
[null,"Forceps plastic",3,15.029300000000001]
[null,"Bottles, plastic",3,30.058600000000002]
[null,"Marker pen, water resistant ",3,6.8315000000000001]
[null,"Gloves, nitril,  powder free, disposable, size 6-7, 100 per pack",10,19.1282]
[null,"Gloves, nitril,  powder free, disposable, size 7-8, 100 per pack",5,20.494500000000002]
[null,"Gloves, nitril,  powder free, disposable, size 8-9, 100 per pack",2,21.860800000000001]
[null,"Strips for the rapid detection of resistance to isoniazid and rifampicin, per strip ",1000,24.593400000000003,"Strips for the rapid detection of resistance to rifampicin, per strip ",1000,62.849800000000002]
[null,"Strips for the rapid detection of resistance to isoniazid and rifampicin, per strip ",1000,3.5,null,null,null,"This is a FIND negotiated price for, please find the countries that can access to this special price in:  http://www.finddiagnostics.org/about/what_we_do/successes/find-negotiated-prices/bactec-mgit.html"]
[null,"Cost of consumables for molecular tests (1000 LPAs)",null,{"$f":"SUMPRODUCT(C394:C420,D394:D420)","v":46957.9041}]