Attachment A Spokane Estimated Test Volume.xlsx

XLSX spreadsheet 33 KB Posted

Attached to
6640--FY25 – Spokane – CPRR Clinical Chemistry Laboratory Equipment Base Plus 4 Procurement
Solicitation number
36C26025Q0178
Issued by

About this file

This is an Excel spreadsheet attachment containing detailed test volume data and estimates for clinical chemistry laboratory tests at a VA facility in Spokane. The file breaks down historical and projected test volumes across two analyzers (Pro 1 and Pro 2) for December 2023-2024, including routine, rerun, STAT, calibration, and quality control tests for over 70 different clinical chemistry analytes. The data shows estimated annual test volumes ranging from 100-46,400 tests per year for various analytes, with high-volume tests including basic metabolic panel components (sodium, potassium, chloride, CO2, glucose, BUN, creatinine) requiring 38,000-46,400 tests annually, while specialized tests like digoxin and vancomycin require only 300-400 tests annually.

The data appears to support procurement requirements for a clinical chemistry analyzer system outlined in solicitation 36C26025Q0178, which seeks a Federal Supply Schedule contractor to provide laboratory equipment, reagents, controls, supplies and disposables to the Spokane VA Medical Center. The file provides detailed testing workload data to help vendors understand the scope and volume of testing requirements that their proposed solutions must support.

View the file

Other files

File Type Posted
36C26025Q0178 0003.docx DOCX document
Spokane Laboaratroy Layout.jpg JPG image
Edited 2-5-2025-36C26025Q0178.docx DOCX document
36C26025Q0178 0002.docx DOCX document
Mann-Grandstaff Architectural Plans.pdf PDF
Detailed counter dec 23 to dec 24.xlsx XLSX spreadsheet
Edited 1-30-2025-36C26025Q0178.docx DOCX document
Laboratory.png PNG image
36C26025Q0178 0001.docx DOCX document
Attachment A Estimated Test Volume Spokane.xlsx XLSX spreadsheet
36C26025Q0178.docx DOCX document
Show all 11

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Pro 1

AnalyteDec-23 Pro 1 totalsRoutineRerunSTATCalibQCDec-24 Pro 1 totalsRoutine2Rerun2STAT4Calib2QC2Dec 2023 to Dec 2024 countCount/2 for 2 years of running totals
Aceta13002583881607912682468152223541623356178
Microalb956516149565161400
Dbili382320264043800914switched to new gen prior22181109need to do 2024 totals to when we switched gens
Alb1787213609189304798929385732890637472402021851196759837.5
alkp17521132011832994144999374132780236271382361875189249462
altp1749513251250300450940switched to new gen prior179128956need to do 2024 totals to when we switched gens
amy1147260173820812259367227136841674520260
astp176941329125629991201028switched to new gen prior180489024need to do 2024 totals to when we switched gens
tbil174611328918429914495337242278153687134881837188539426.5
ca19922151042343654448864394032417583887318218852288111440.5
chol10620938711110517883922209196722212663561694105565278
ck151631792251248323053684203507481611734367
co2202131516023036516611064431532298465886624824382258811294
creat20382154812673658868904431532957555889816217432300411502
creat-u79651479651400
crphs4294163860910191788509896343615782624482177643722186
dig1160235382584778246243273422881627249124.5
etoh149033354265747643176681996961381562824412
ggt118527722256828255668118471321678445222.5
gluc2002515177328365328839436393234469588886816442276911384.5
gluc3c6565656500
hdlc41043993371111043685121738193722232631341746103065153
iron4093291636571888969049656983113418186637561878
lact251623631310254889458024587852623132180422921146
ldh1402503135024812274496428112441596538269
ldlc3551245085016408981090688799749112176944512225.5
li14622332214330863300252992236221736375187.5
lip208136127605148940444280757148427218221355677.5
mg6344370536112831268691399180918302950270185065223261
nh312902321572047962780568151233701704416208
phos285316332520344948651740056563268174728411420.5
prea140518095168104328213921693722032223111.5
rf176560836202648373705138175534841712845422.5
Sali119122035664848247742571531481744306153
tp1736013217180299448921372082779835871311161805188969448
tpuc-c79651479651400
tpuc-u967012149670121400
trig1060393841501047688921766194062902651081697103235161.5
trsf370926433244124866803460308396172165334901745
uric269216792713136819561435345632968162720821041
uibc5436414543641400
bun200491509322436511209614363832107464887424019532247711238.5
valp16102895165267743313610102810421623338169
vanco3o1088115323332615264634214507641476265132.5
si237988314633776144486969713938341473664897924489.5
ckmbst125329573292827248447112731951733222111
hcg-beta78664878664800
myost100818433360728225335413591641663206103
b12 24772368221244607749062683137373152163333391669.5
tnt-g5st2637294247119412078258166296102666235167621701085
pct2241389998231048265092739261213820817461827913.5
tsh28204428204400
tpsa679357749063528141376611607179141152168760003000
pbnpstx161042104200
fol56243328127536116869103426006227858196180437031851.5
ferr44373304494714389495507116140101310188339571978.5
ft4 23535253633105847771948144933473238726041302need to do 2024 totals to when we switched gens
tsh993183091035876886420578170492231329184179396024801
fpsa11103164864718227756514121601526263131.5
vitdt 385467444173241247812365021186464462081746140557027.5
ft3 35036410503641000
pbnpstx219154136757767814818117363172321216471625812.5
na23610152832963650353784450816325796368875706516612286111430.5
na-u7272727200
k238041529746436523537854512673262810208877706516772311211556
k-u7272727200
cl23569152642803643353784550610324785618851706516552270311351.5
cl-u727272
387290
458273
Routine, rerun, STAT, Calib, and QC
bild2-d16691144, 16, 28, 38, 443
values include lot to lot studies, 6 month correlations, Roche QC and AMR studies, but no QC/Cal
altp2116078569, 131, 2351, 28, 528
astp2112568354, 124, 2269, 32, 477
routine and statnearest 100

Pro 2

AnalyteDec 2023 Pro 2RoutineRerunSTATCalibQCDec 2024 Pro 2Routine2Rerun3STAT4Calib5QC6Dec 2023 to Dec 2024Count/2 for 2 years of running totals
Aceta140524512612478402763398211125151717213106.5
Microalb913877813262048271946116292647636188688324416
Dbili2962128615277648780switched to new gen prior1748874
Alb17095142761821689728763841732822463330410417242044210221
alkp166651398218616493681237514320374673242961672199299964.5
altp1674614027228165020821switched to new gen prior199519975.5
amiq255664791292871811644100345638151652702635
amy121729713174484624405872460641705344172
astp1685914089240164932849switched to new gen prior188769438
ba2qp5517476425147141159199975026151852582629
bz2qp5521476324147201126597454820145250062503
tbil166511398618816481281737550320744703241681697199639981.5
ca19220159922262043868734378736928640405025219172335711678.5
chol12525112901544417985828362257823741113631732147797389.5
ck143133684159248282782656174271361645522261
co219155159692022041369074363536695500404926421272303211516
co3q25506475722107171153299854712148852532626.5
creat19513162802522042728674375437210617404116417222329411647
creat-u7421651533873170671516968183086894344.5
crphs2831996283558193801620822316161119457178521291064.5
etoh138832342183787622689552613551481573420210
ggt1207321185282525106306191401715325162.5
gluc1923616025307204132831431873664975740416816722307411537
gluc3c18911617233419311407738.5
bup1q56504788325277811824100187698163252742637
hdlc4122671118615645368442777325489380109941701145917295.5
lact199819522965040884393237748712946817061084542
ldh118830834328142394594450801666306153
ldlc35009405045650858107668912901766168149182459
lip173836115344969223425744266901641801740370
md3q05494476624146901153399934920147152522626
mg447325932067361108281024260825091391334192644472223.5
nh3126723814419678825614962653641634280140
op3q25538477031267111156699965528148752502625
pc2qp55484773222672711671100514940153153052652.5
phos2009102991261682943932441192892016241585792.5
prea1194151168875235531271288174716984.5
Sali112323610484478521783971386801602202101
th5q25565475936187521159399856022152652502625
tp166991395018416485686137399319444583241801676198619930.5
tpuc-c22713219437520911657738.5
tpuc-u16025282419485633601162523961750662331
trig1239911218185446488827888254954391081161730145957297.5
fent150112081212269763264229028109252922646
uric2028110410434083143712483251069616611457728.5
bun19099159162092039748614276136364513403412617242274711373.5
oxy3q55534784292072011702100716438152953222661
si22937125282345374046671058700814719063733718668.5
ckmbst11152512208775524465008401911707275137.5
hcg-beta1057217161482728231842923282221616233116.5
myost10992245208476622694538281721608240120
b12 2568844823282764787135691103570460140163069623481
tnt-g5st2030192182821927434112515386148618015451192596
pct1786360595119276436726631499781961686860430
tsh29214429214400
tpsa723762341823344744166351451538961108156285164258
fol6041367514742980783141588874339546172167171373568.5
ferr2039116427187675447262757813721116401666833
ft4 2382128478591527462501new generation in use42122106
tsh1039989931983696877124742215844857022101761132116605.5
fpsa11563101237875323405972051661552297148.5
vitdt 32649539130264953913000
ft3 313785221619807413235131125292001670808404
pbnpstx18424992547280766385811344283819616481018509
na23012161222842045363692550736367847004053738918102308611543
na-u1071279117812230491301709231115.5
k23156161354092045363693151067368269634043738918462324311621.5
k-u10272349784212840319170617989.5
cl23031161252592036363697550658367736144030738918522299711498.5
cl-u10472514792217143912172019698
Routine, rerun, STAT, Calib, and QC
bild2-d870, 11, 9, 22, 409
altp210183, 234, 924, 20, 498
astp29917, 226, 897, 60, 560
bz2q2423, 2, 0, 8, 49
ft4 41910, 60, 21, 66, 444

Estimated Annual Tests

AnalyteFake estimatesDec 23 to Dec 24 numbersDec 23 to Dec 24 estimatedPrice Per TestBase YearOption Year 1Option Year 2Optin Year 3Option Year 4Option Year 5Total for the Fiver Years
Acetaminophen1200569600
Microalbumin Urine1630088328900
Direct bilirubin210039664000
Albumin plasma723004011740200
Alkaline phosphatase703003885338900
ALT221003786337900
Amylase1500864900
AST215003692437000
Total Bilirubin703003881638900
Calcium823004623846300
Cholesterol459002533525400
Creatine kinase220012561300
Bicarbonate820004562045700
Creatinine832004629846300
Creatinine urine1520086898700
CRP high sensitivity950065016500
Digoxin500249300
Ethanol230012441300
GGT1400770800
Glucose820004584345900
Glucose CSF20077100
HDL453002489724900
Iron670037563800
Lactic Acid480033763400
LDH1800844900
LDL1790093699400
Lithium600375400
Lipase380020952100
Magnesium186001096911000
Ammonia1300696700
Phosphorus740044264500
Prealbumin800392400
Rheumatoid Factor1500845900
Salicylate1100508500
Total Protein702003875738800
Total Protein CSF30077100
Total Protein urine1200662700
Triglyceride453002491825000
Transferrin620034903500
Uric Acid650035393600
Blood Urea Nitrogen814004522445300
Valproic Acid700338400
Vancomycin400265300
CK-MB1100497500
Beta HCG500233300
Myoglobin900446500
Vitamin B12180001030110300
Troponin530033623400
Procalcitonin460026872700
TSH407002281322900
Total PSA264001451614600
Pro BNP490026432700
Folate150001084010900
Ferritin1010056235700
Free T4350068166900
Free PSA1200560600
Vitamin D213001405514100
Free T31400808900
Sodium830004594746000
Urine Sodium500231300
Potassium824004635546400
Urine Potassium500179200
Chloride822004570045800
Urine Chloride5000196200
Amphetamine1010052705300
Barbituates1000052585300
Benzodiazepine1020050065100
Cocaine1000052535300
Buprenorphine1010052745300
Methadone1000052525300
Opiates1000052505300
PCP1010053055300
THC1000052505300
Fentanyl650052925300
Oxycodone1010053225400
Total for the YearTotal for the Fiver Years

File details come from the government source that posted it. Updated .