{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Calculator","Update","Lab","Tests","Cost Details"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":12,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Calculator","index":0,"n_rows":41,"n_cols":5,"rows_kept":41,"cut":false,"hidden":false,"merged":[[31,1,31,3],[1,1,1,3],[10,1,10,2],[14,1,14,2],[11,1,11,2],[13,1,13,2],[12,1,12,2]]}
[" "]
[null,"Test Cost Calculator "]
[null,"Instructions:  "]
[null,"Enter values in the white boxes below. Values in the the yellow boxes will be calculated automatically."]
[]
[null,"Test Lab and Name:"]
[null,null,null,8]
[null,null,null,6]
[]
[null,"Required consumables:",null,"Cost per specimen"]
[null,"Double mailing container Enzyme   ",null,5.5]
[null,"HIV reagent cost/test Enzyme",null,3.37]
[null,"Consumables Enzyme",null,1.5]
[null,"Western Blot reagent cost/test  ",null,34]
[null,"Consumables Blot",null,1.5]
[null,")-(",null,"Test Supplies Cost",{"$f":"SUM(D11:D15)","v":45.870000000000005}]
[]
[null,"Labor categories:","Time per specimen (hours):","Direct labor rate ($/hour):"]
[null,"Lab scientist",0.1,38.5]
[null,"Technician",0.1,22]
[null,"Clerical",0.2,24]
[null,null,null,"Direct Labor Cost",{"$f":"SUMPRODUCT(C19:C21,D19:D21)","v":10.850000000000001}]
[]
[null,null,null,"Total Direct Cost",{"$f":"SUM(E16:E22)","v":56.720000000000006}]
[]
[null,null,"Indirect cost rate (%):",0.4]
[null,null,null,"Indirect Cost",{"$f":"+E24*D26","v":22.688000000000002}]
[]
[null,null,null,"Total Test Cost",{"$f":"SUM(E24:E27)","v":79.408000000000015}]
[]
[null,"Notes about this test:"]
[null,"HIV testing includes a Enzyme-immunoassay (EIA) screening test and a western blot for confirmation of positive EIA tests. "]
[]
[]
[null,"Notes about this form:"]
[null,"Consumables includes supplies, reagents, disposables, and controls, all on a per-specimen basis."]
[null,"The Test Supplies Cost is the sum of all items listed under Required Consumables."]
[null,"The Direct Labor Cost is the sum (over the labor categories listed) of the product of the time per specimen and the labor rate."]
[null,"The Total Direct Cost equals the sum of the Test Supplies Cost and the Direct Labor Cost."]
[null,"The Indirect Cost equals the Total Direct Cost multiplied by the Indirect cost rate."]
[null,"The Total Test Cost equls the Total Direct Cost plus the Indirect Cost."]

{"sheet":"Update","index":1,"n_rows":2,"n_cols":20,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Lab","Lab Name","Test","Test Code","Test Category","Department","Started","Completed","Entered into archive","Test Volume (tests/year)","Total Test Cost","Test Supplies Cost","Labor Cost","Total Direct Cost","Indirect Cost","Indirect cost rate (%)","Batch Size Typical","Lab % Revenue","Estimated repeats","Price of Test (patient)"]
[{"$f":"VLOOKUP(B2,Lab!A2:B9,2,FALSE)","v":8},{"$f":"INDEX(Lab!A2:A9,Calculator!D7,0)","v":"WY Public Health Laboratory Department of Health"},{"$f":"INDEX(Tests!C69:C83,Calculator!D8,0)","v":"HIV"},{"$f":"VLOOKUP(C2,Tests!C2:D16,2,FALSE)","v":1},{"$f":"VLOOKUP(D2,Tests!D2:E16,2,FALSE)","v":"Virology"},{"$f":"VLOOKUP(E2,Tests!E2:F16,2,FALSE)","v":"Microbology"},"2008-10-10","2009-10-10","2009-10-11",500,{"$f":"TotalTestCost","v":79.408000000000015},{"$f":"TestSuppliesCost","v":45.870000000000005},{"$f":"DirectLaborCost","v":10.850000000000001},{"$f":"TotalDirectCost","v":56.720000000000006},{"$f":"IndirectCost","v":22.688000000000002},{"$f":"IndirectCostRate","v":0.4},100,0.02,30,25]

{"sheet":"Lab","index":2,"n_rows":88,"n_cols":12,"rows_kept":88,"cut":false,"hidden":true,"merged":[]}
["Center Name","Lab","Region","City","State","Zip Code","Street","Box/Suite","Phone","Network Exchange","Fax","24 Hour Phone"]
["AL Bureau of Clinical Laboratories State Department of Public Health",1,"IV","Montgomery","Alabama","36124-4018","8140 AUM Drive","P.O. Box 244018","334.260.3400",null,"334.274.9800","334.260.3400"]
["AK Department of Health & Social Services Division of Public Health Laboratory",2,"I","Anchorage","Alaska",99507,"4500 Boniface Parkway"," ","907.334.2100",null,"907.334.2161","800.418.8077"]
["AZ Bureau of State Laboratory Services AZ Department of Health",3,"II","Arizona","Arizona",85007,"250 N. 17th Avenue",null,"602.542.1188",null,"602.542.0760","602.283.6277"]
["Public Health Laboratory Arkansas Department of Health",4,"II","Little Rock","Arkansas","72205-5425","201 South Monroe Street"," ","501.280.4079",null,"501.661.2310","800.554.5738"]
["CA Department of Health Services",5,"I","Richmond","California",94804,"850 Marina Bay Parkway"," ","510.412.5846",null,"510.412.5848","800.971.9631"]
["CO Department of Public Health & Environment",6,"III","Denver","Colorado",80230,"8100 Lowry Boulevard"," ","303.692.3069",null,"303.344.9989","877.518.5608"]
["CT Division of Laboratories CT Department of Public Health",7,"II","Hartford","Connecticut",6144,"10 Clinton Street","P.O. Box 1689","860.614.4784",null,"860.509.8697","860.509.8697"]
["WY Public Health Laboratory Department of Health",8,"IV","Cheyenne","Wyoming",82002,"2300 Capitol Avenue 517 Hathaway Building"," ","307.777.7448",null,"307.777.6422","888.996.9104"]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[null,32]
[null,33]
[null,34]
[null,35]
[null,36]
[null,37]
[null,38]
[null,39]
[null,40]
[null,41]
[null,42]
[null,43]
[null,44]
[null,45]
[null,46]
[null,47]
[null,48]
[null,49]
[null,50]
[null,51]
[null,52]
[null,53]
[null,54]
[null,55]
[null,56]
[null,57]
[null,58]
[null,59]
[null,60]
[null,61]
[null,62]
[null,63]
[null,64]
[null,65]
[null,66]
[null,67]
[null,68]
[null,69]
[null,70]
[null,71]
[null,72]
[null,73]
[null,74]
[null,75]
[null,76]
[null,77]
[null,78]
[null,79]
[null,80]
[null,81]
[null,82]
[null,83]
[null,84]
[null,85]
[null,86]
[null,87]

{"sheet":"Tests","index":3,"n_rows":83,"n_cols":20,"rows_kept":83,"cut":false,"hidden":true,"merged":[]}
["Lab","Lab Name","Test","Test Code","Test Category","Department","Started","Completed","Entered into archive","Test Volume (tests/year)","Total Test Cost","Test Supplies Cost","Labor Cost","Total Direct Cost","Indirect Cost","Indirect cost rate (%)","Batch Size Typical","Lab % Revenue","Estimated repeats","Price of Test (patient)"]
[1,"AL Bureau of Clinical Laboratories State Department of Public Health","Syphilis RPR",21,"Virology","Microbology","2008-10-10","2009-10-10","2009-10-11",500,88.66,54.73,8.6,63.33,25.33,0.4,100,0.02,30,25]
[1,"AL Bureau of Clinical Laboratories State Department of Public Health","Rabies ",11,"Virology","Immunollogy",null,null,null,null,null,null,null,null,null,null,null,null,null,30]
[1,"AL Bureau of Clinical Laboratories State Department of Public Health","Hepatitis A ",31,"Virology","Immunollogy",null,null,null,null,null,null,null,null,null,null,null,null,null,124]
[1,"AL Bureau of Clinical Laboratories State Department of Public Health","Hepatitis B ",20,"Virology","Immunollogy",null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[1,"AL Bureau of Clinical Laboratories State Department of Public Health","Rubella  ",21,"Virology","Immunollogy",null,null,null,null,null,null,null,null,null,null,null,null,null,24]
[1,"AL Bureau of Clinical Laboratories State Department of Public Health","Measles ",22,"Virology","Immunollogy",null,null,null,null,null,null,null,null,null,null,null,null,null,27]
[1,"AL Bureau of Clinical Laboratories State Department of Public Health","Mumps ",35,"Virology","Immunollogy",null,null,null,null,null,null,null,null,null,null,null,null,null,33]
[1,"AL Bureau of Clinical Laboratories State Department of Public Health","Arbovirus ",24,"Virology","Immunollogy",null,null,null,null,null,null,null,null,null,null,null,null,null,25]
[1,"AL Bureau of Clinical Laboratories State Department of Public Health","Respiratory ",26,"Virology","Immunollogy",null,null,null,null,null,null,null,null,null,null,null,null,null,18]
[1,"AL Bureau of Clinical Laboratories State Department of Public Health","Rash Investigation ",17,"Virology","Immunollogy",null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[1,"AL Bureau of Clinical Laboratories State Department of Public Health","Gastrointestinal ",19,"Virology","Microbology",null,null,null,null,null,null,null,null,null,null,null,null,null,21]
[1,"AL Bureau of Clinical Laboratories State Department of Public Health","Encephalitis/Meningitis ",13,"Virology","Immunollogy",null,null,null,null,null,null,null,null,null,null,null,null,null,18]
[null,null,"HIV",1,"Virology","Immunollogy"]
[1,"AL Bureau of Clinical Laboratories State Department of Public Health","Non-variola Orthopox ",28,"Virology","Immunollogy",null,null,null,null,null,null,null,null,null,null,null,null,null,19]
[1,"AL Bureau of Clinical Laboratories State Department of Public Health","Rickettsial ",32,"Virology","Immunollogy",null,null,null,null,null,null,null,null,null,null,null,null,null,26]
[2,"AK Department of Health & Social Services Division of Public Health Laboratory","Syphilis RPR",21,"Virology","Microbology",null,null,null,null,null,null,null,null,null,null,null,null,null,25]
[2,"AK Department of Health & Social Services Division of Public Health Laboratory","Rabies ",11,"Virology","Immunollogy",null,null,null,null,null,null,null,null,null,null,null,null,null,30]
[2,"AK Department of Health & Social Services Division of Public Health Laboratory","Hepatitis A ",31,"Virology","Immunollogy",null,null,null,null,null,null,null,null,null,null,null,null,null,124]
[2,"AK Department of Health & Social Services Division of Public Health Laboratory","Hepatitis B ",20,"Virology","Immunollogy",null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[2,"AK Department of Health & Social Services Division of Public Health Laboratory","Rubella  ",21,"Virology","Immunollogy",null,null,null,null,null,null,null,null,null,null,null,null,null,24]
[2,"AK Department of Health & Social Services Division of Public Health Laboratory","Measles ",22,"Virology","Immunollogy",null,null,null,null,null,null,null,null,null,null,null,null,null,27]
[2,"AK Department of Health & Social Services Division of Public Health Laboratory","Mumps ",35,"Virology","Immunollogy",null,null,null,null,null,null,null,null,null,null,null,null,null,33]
[2,"AK Department of Health & Social Services Division of Public Health Laboratory","Arbovirus ",24,"Virology","Immunollogy",null,null,null,null,null,null,null,null,null,null,null,null,null,25]
[2,"AK Department of Health & Social Services Division of Public Health Laboratory","Respiratory ",26,"Virology","Immunollogy",null,null,null,null,null,null,null,null,null,null,null,null,null,18]
[2,"AK Department of Health & Social Services Division of Public Health Laboratory","Rash Investigation ",17,"Virology","Immunollogy",null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[2,"AK Department of Health & Social Services Division of Public Health Laboratory","Gastrointestinal ",19,"Virology","Microbology",null,null,null,null,null,null,null,null,null,null,null,null,null,21]
[2,"AK Department of Health & Social Services Division of Public Health Laboratory","Encephalitis/Meningitis ",13,"Virology","Immunollogy",null,null,null,null,null,null,null,null,null,null,null,null,null,18]
[2,"AK Department of Health & Social Services Division of Public Health Laboratory","Non-variola Orthopox ",28,"Virology","Immunollogy",null,null,null,null,null,null,null,null,null,null,null,null,null,19]
[2,"AK Department of Health & Social Services Division of Public Health Laboratory","Rickettsial ",32,"Virology","Immunollogy",null,null,null,null,null,null,null,null,null,null,null,null,null,26]
[3,"AZ Bureau of State Laboratory Services AZ Department of Health","Syphilis RPR",21,"Virology","Microbology"]
[3,"AZ Bureau of State Laboratory Services AZ Department of Health","Rabies ",11,"Virology","Immunollogy"]
[3,"AZ Bureau of State Laboratory Services AZ Department of Health","Hepatitis A ",31,"Virology","Immunollogy"]
[3,"AZ Bureau of State Laboratory Services AZ Department of Health","Hepatitis B ",20,"Virology","Immunollogy"]
[3,"AZ Bureau of State Laboratory Services AZ Department of Health","Rubella  ",21,"Virology","Immunollogy"]
[3,"AZ Bureau of State Laboratory Services AZ Department of Health","Measles ",22,"Virology","Immunollogy"]
[3,"AZ Bureau of State Laboratory Services AZ Department of Health","Mumps ",35,"Virology","Immunollogy"]
[3,"AZ Bureau of State Laboratory Services AZ Department of Health","Arbovirus ",24,"Virology","Immunollogy"]
[3,"AZ Bureau of State Laboratory Services AZ Department of Health","Respiratory ",26,"Virology","Immunollogy"]
[3,"AZ Bureau of State Laboratory Services AZ Department of Health","Rash Investigation ",17,"Virology","Immunollogy"]
[3,"AZ Bureau of State Laboratory Services AZ Department of Health","Gastrointestinal ",19,"Virology","Microbology"]
[3,"AZ Bureau of State Laboratory Services AZ Department of Health","Encephalitis/Meningitis ",13,"Virology","Immunollogy"]
[3,"AZ Bureau of State Laboratory Services AZ Department of Health","Non-variola Orthopox ",28,"Virology","Immunollogy"]
[3,"AZ Bureau of State Laboratory Services AZ Department of Health","Rickettsial ",32,"Virology","Immunollogy"]
[4,"Public Health Laboratory Arkansas Department of Health","Syphilis RPR",21,"Virology","Microbology"]
[4,"Public Health Laboratory Arkansas Department of Health","Rabies ",11,"Virology","Immunollogy"]
[4,"Public Health Laboratory Arkansas Department of Health","Hepatitis A ",31,"Virology","Immunollogy"]
[4,"Public Health Laboratory Arkansas Department of Health","Hepatitis B ",20,"Virology","Immunollogy"]
[4,"Public Health Laboratory Arkansas Department of Health","Rubella  ",21,"Virology","Immunollogy"]
[4,"Public Health Laboratory Arkansas Department of Health","Measles ",22,"Virology","Immunollogy"]
[4,"Public Health Laboratory Arkansas Department of Health","Mumps ",35,"Virology","Immunollogy"]
[4,"Public Health Laboratory Arkansas Department of Health","Arbovirus ",24,"Virology","Immunollogy"]
[4,"Public Health Laboratory Arkansas Department of Health","Respiratory ",26,"Virology","Immunollogy"]
[4,"Public Health Laboratory Arkansas Department of Health","Rash Investigation ",17,"Virology","Immunollogy"]
[4,"Public Health Laboratory Arkansas Department of Health","Gastrointestinal ",19,"Virology","Microbology"]
[4,"Public Health Laboratory Arkansas Department of Health","Encephalitis/Meningitis ",13,"Virology","Immunollogy"]
[4,"Public Health Laboratory Arkansas Department of Health","Non-variola Orthopox ",28,"Virology","Immunollogy"]
[4,"Public Health Laboratory Arkansas Department of Health","Rickettsial ",32,"Virology","Immunollogy"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Arbovirus "]
[null,null,"Encephalitis/Meningitis "]
[null,null,"Gastrointestinal "]
[null,null,"Hepatitis A "]
[null,null,"Hepatitis B "]
[null,null,"HIV"]
[null,null,"Measles "]
[null,null,"Mumps "]
[null,null,"Non-variola Orthopox "]
[null,null,"Rabies "]
[null,null,"Rash Investigation "]
[null,null,"Respiratory "]
[null,null,"Rickettsial "]
[null,null,"Rubella  "]
[null,null,"Syphilis RPR"]

{"sheet":"Cost Details","index":4,"n_rows":6,"n_cols":7,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["Lab","Test","Required consumables","Cost per specimen","Labor categories","Time per specimen (hours):","Direct labor rate ($/hour):"]
[{"$f":"Update!$A$2","v":8},{"$f":"Update!$C$2","v":"HIV"},{"$f":"Calculator!B11","v":"Double mailing container Enzyme   "},{"$f":"Calculator!D11","v":5.5},{"$f":"Calculator!B19","v":"Lab scientist"},{"$f":"Calculator!C19","v":0.1},{"$f":"Calculator!D19","v":38.5}]
[{"$f":"Update!$A$2","v":8},{"$f":"Update!$C$2","v":"HIV"},{"$f":"Calculator!B12","v":"HIV reagent cost/test Enzyme"},{"$f":"Calculator!D12","v":3.37},{"$f":"Calculator!B20","v":"Technician"},{"$f":"Calculator!C20","v":0.1},{"$f":"Calculator!D20","v":22}]
[{"$f":"Update!$A$2","v":8},{"$f":"Update!$C$2","v":"HIV"},{"$f":"Calculator!B13","v":"Consumables Enzyme"},{"$f":"Calculator!D13","v":1.5},{"$f":"Calculator!B21","v":"Clerical"},{"$f":"Calculator!C21","v":0.2},{"$f":"Calculator!D21","v":24}]
[{"$f":"Update!$A$2","v":8},{"$f":"Update!$C$2","v":"HIV"},{"$f":"Calculator!B14","v":"Western Blot reagent cost/test  "},{"$f":"Calculator!D14","v":34}]
[{"$f":"Update!$A$2","v":8},{"$f":"Update!$C$2","v":"HIV"},{"$f":"Calculator!B15","v":"Consumables Blot"},{"$f":"Calculator!D15","v":1.5}]