jagomart
digital resources
picture1_Excel Sheet Download 30954 | Rtri Surveillance Activities And Inventory 2022


 220x       Filetype XLSX       File size 0.16 MB       Source: trace-recency.org


File: Excel Sheet Download 30954 | Rtri Surveillance Activities And Inventory 2022
sheet 1 how to use this tool rapid test for recent infection rtri surveillance activities and inventory tool this comprehensive spreadsheet has been developed to aid rtri implementors to1 calculate ...

icon picture XLSX Filetype Excel XLSX | Posted on 08 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: How to Use This Tool

Rapid Test for Recent Infection (RTRI) Surveillance Activities and Inventory Tool















This comprehensive spreadsheet has been developed to aid RTRI implementors to:

1) Calculate the laboratory consumables needed for trainings and specimen panel production: Quality Control (QC) panels, Training Panels (TP), and Proficiency Testing (PT) panels.
2) Maintain a laboratory consumables inventory log to ensure sufficient supply for upcoming additional TOTs and step-down trainings
3) Monitor national stock supply of RTRI tests and determine when to place next order
4) Maintain QC, PT, TP panel inventory to ensure there are no stock-outs needed for testing quality monitoring, trainings, and a proficiency testing program
5) Maintain an inventory and testing results log of blood bank samples used to make specimen panels for the RTRI program
6) Determine the estimated costs associated with implementing a recency surveillance program

Instructions are provided on each tab on how to fill in the necessary information, how frequently the activities should be performed, and information for consideration.

The intended users for this tool include, but not limited to, National Reference Lab (NRL) staff, MoH staff, RTRI implementing partners, and study managers responsible for monitoring and maintaining supplies and tests needed for RTRI testing.











































Sheet 2: 1. Training Consumables Calc
CALCULATING LABORATORY CONSUMABLES FOR
RAPID TEST FOR HIV-1 RECENT INFECTION (RTRI) TRAININGS


INSTRUCTIONS:
This calculator is used to estimate the total number of RTRI kits and other lab-related consumables needed for recency training of trainers (ToTs), DTS QC, and plasma training panel preparation and trainings. The costs will vary depending on the country and pricing agreement with vendors. Please enter the relevant information in cells C12:C19 (higlighted in yellow) and the supplies and costs will be calculated automatically below.

Note: If the country is considering only plasma samples for their QC, TP and PT panel productions, then please contact CDC ILB ISMEs for the plasma version only of this calculator. Additionally, please contact ILB to determine if a prodcut can be substituted.















TRAINING INPUT VARIABLES




Number of TOTs participants





Total number of testers to be trained at step-down trainings





Number of testers at each step-down training (if split)





Name of test kit (select from drop-down list) Maxim Swift HIV-1 Rapid Recency test (20 test packing)













Number of plasma units collected





Number of QC panel set to prepare





Number of training panel set to prepare





*ALL pricing in this calculator is an estimate and should be used for preliminary budgeting purposes only. For actual pricing, please contact each manufacturer for a specific quote.

CONSUMABLES FOR PURCHASING
Item Description Application Unit Units
Needed
Items Received Estimated Price
per unit*
Total Estimated Price* AVAILABLE IN COUNTRY?
Maxim Swift HIV-1 Rapid Recency test (20 test packing) Reagent kit Test

$3.95 #VALUE!

Desk Model Biohazard Bag Holder for tabletop waste (example, Bel-Art Scienceware Poxygrid, Fisher #01-815-2) Waste Disposal each

$32.00


Polypropylene Biohazard Autoclave Bags; Size: 8 x 12in for tabletop waste (example, Fisher #03-410-591) Waste Disposal pack of 100

$28.55


Polypropylene Biohazard Autoclave Bags, large red or clear with biohazard symbol (example, Fisher #S42905) Waste Disposal pack of 200

$361.00


Powder-Free Nitrile Exam Gloves with Aloe, Small to X-Large size (example, Fisher #19-050-550A--D) PPE pack of 100 pairs

$49.50


Lab coat (Small to X-Large size), typically disposable (example, Fisher #19-043057--60) PPE case of 25

$242.50


Disposable face mask (example, VWR Catalog Number: 76451-956) PPE case of 500

$423.88
For mitigation of COVID-19, 1-2 /person/day. The calculation is based on a 3 day training. Note: Mask worn during practical session should be treated as biohazadous waste.
Sarstedt Microtubes 2.0ml with enclosed cap, 250/bag, Sartstedt #72.694.007 Panel Prep 250/bag

$90.25


Microtube racks to accommodate 96 2.0ml tubes (example, Fisher #05-541-38) Panel Prep pack of 5

$101.00


Specimen tube labels, Laser Cryo-Babies 0.94 x 0.50" 2,380/pk, Diversified Biotech #LCRY-2380 Panel Prep 2380/pack

$69.00


Specimen box labels, Laser Cryo-Tags 2.625 x 1.0" 600/pk, Diversified Biotech #LCRY-1258 Panel Prep 600/pack

$69.00


Repeat Volume Pipettor (example, Thermo Scientific™ Finnpipette Stepper Pipette, Fisher #21-377-147) Panel Prep each

$536.50


Repeat Volume Pipettor Tips, 5ml (example, Thermo Scientific Finntip, pack of 50, Fisher #21-377-154) Panel Prep 50/pack

$86.50


Repeat Volume Pipettor Tips, 0.5ml (example Thermo Scientific Finntip, pack of 100, Fisher #21-377-148) DTS panel prep 100/pack

$164.80


Repeat Volume Pipettor Tips, 50ml (example Thermo Scientific Finntip, pack of 10, Fisher #21-377-160) Panel Prep 10/pack

$24.70


50 mL Centrifuge tubes, polypropylene (example, Fisher #S99412) Panel Prep 50/pack

$15.00


250 mL plasma storage bottles (example, Fisher #02-893B) Panel Prep 12/pack

$200.50


PBS with 0.05% Tween 20, pH 7.4 powder (Sigma-Aldrich #P3563) DTS panel prep 10/box

$57.20


Green food coloring dye, local market purchase DTS panel prep each

$2.00


Disposable transfer pipettes (Samco #282 transfer pipet, Fisher #13-711-43) DTS panel prep 500/box

$71.00


10 mL Serological pipette (example, Fisher #12-567-615) Panel Prep 200/case

$128.00


Pipet Filler (example, Fisherbrand™ Pipet Controller #FB14955202) Panel Prep each

$367.00


Cryoboxes, 9x9in 81-place (example, Fisher #12-565-182) Panel Storage case of 6

$54.60


Cryoboxes, 5x5in 25-place (example, Fisher #12-565-183) Training Panel case of 24

$187.90


absorbant surface protectors or bench pad/linen saver (example, Fisher #14-206-62) Biosafety 50 per pack

$83.50


70% Alcohol or Bleach-Based Disinfectant (example, Fisher #04-355-150) Biosafety bottle

$35.27


Chemically Resistant Permanent Markers, ultra fine tip (example, Fisher #22-026-700) Labeling, training pack of 12

$97.00


Pens, black ballpoint (example, Staples #2072214) Record keeping pack of 12

$2.09


Lab Timer, multi-channel (example, Fisher #S41782) RTRI testing each

$37.00


Paper towels RTRI testing roll each

$2.00


Freezer, -20C, upright manual defrost, ~566L capacity, 230 V/50 Hz (example, Fisher #20LFEETSV) NRL QC/TP Storage each

$3,006.00


Surgical Masks (example, Fisher #19-088-879) PPE pack of 500

$95.00


Hand Sanitizer (example, Fisher #23-001-729) PPE each

$15.80


Disposable Face Shields (example, Fisher #19-181-600B) PPE pack of 25

$66.00


Optional (verify lab has deionized water source and vacuum filtration):







1L Disposable 0.2 uM filter flask (Fisher #09-761-104) PT buffer case of 12

$351.20


Reagent grade deionized water, (Fisher #23-751610) DTS 1 gal

$50.60



TOTAL: #VALUE!







































































































































































































































































































































































































































































































1









Sheet 3: 2.Lab Consumables Inventory Log
INVENTORY LOG OF LABORATORY CONSUMABLES FOR RTRI TRAININGS























INSTRUCTIONS:
The spreadsheet should be used to maintain an ongoing inventory of laboratory supplies needed for additional ToT, step-down training and panel preparation (QC, TP and PT panels). This inventory tool should be completed EVERY MONTH and AFTER EVERY TRAINING. It should be used together with the Consumables Calculator (previous tab) to help determine preparedness status when planning for training and panel preparation activities. Take note of expiry dates of the supplies and exercise the first in/first out (FIFO) and/or first expired/first out (FEFO) rules. Add INVENTORY DATE into the yellow box and add columns as needed.





































































LABORATORY CONSUMABLES INVENTORY LOG
Inventory Date: Inventory Date: Inventory Date: Inventory Date: Inventory Date: Inventory Date:
Item Desciption Application Unit Quantity
Available
Expiry Date
(If Applicable)
Comments Quantity
Available
Expiry Date
(If Applicable)
Comments Quantity
Available
Expiry Date
(If Applicable)
Comments Quantity
Available
Expiry Date
(If Applicable)
Comments Quantity
Available
Expiry Date
(If Applicable)
Comments Quantity
Available
Expiry Date
(If Applicable)
Comments
Asante HIV-1 Rapid Recency test (100 test packaging) Reagent Kit Test

















Asante HIV-1 Rapid Recency test (20 test packaging) Reagent Kit Test

















Maxim Swift HIV-1 Rapid Recency test (20 test packing) Reagent Kit Test

















Desk Model Biohazard Bag Holder for tabletop waste Waste disposal Each

















Polypropylene Biohazard Autoclave Bags; Size: 8 x 12in for tabletop waste Waste disposal pack of 100

















Polypropylene Biohazard Autoclave Bags, large red or clear with biohazard symbol Waste disposal pack of 200

















Powder-Free Nitrile Exam Gloves with Aloe, SMALL PPE Pack of 100 pairs

















Powder-Free Nitrile Exam Gloves with Aloe, MEDIUM PPE Pack of 100 pairs

















Powder-Free Nitrile Exam Gloves with Aloe, LARGE PPE Pack of 100 pairs

















Powder-Free Nitrile Exam Gloves with Aloe, X-LARGE PPE Pack of 100 pairs

















Disposable Lab Coat, SMALL PPE case of 25

















Disposable Lab Coat, MEDIUM PPE case of 25

















Disposable Lab Coat, LARGE PPE case of 25

















Disposable Lab Coat, X-LARGE PPE case of 25

















Disposable face mask (example, VWR Catalog Number: 76451-956) PPE case of 500

















Sarstedt Microtubes 2.0ml with enclosed cap, 250/bag Panel prep 250/bag

















Microtube racks to accommodate 96 2.0ml tubes Panel prep pack of 5 or single

















Specimen tube labels, Laser Cryo-Babies 0.94 x 0.50" 2,380/pk, Panel prep 2380/pack

















Specimen box labels, Laser Cryo-Tags 2.625 x 1.0" 600/pk, Panel prep 600/pck

















Repeat Volume Pipettor Tips, 5ml (example, Thermo Scientific Finntip, pack of 50, Fisher #21-377-154) Panel Prep 50/pack

















Repeat Volume Pipettor Tips, 5ml (example, Thermo Scientific Finntip, pack of 50, Fisher #21-377-154) Panel Prep 50/pack

















Repeat Volume Pipettor Tips, 0.5ml (example Thermo Scientific Finntip, pack of 100, Fisher #21-377-148) DTS panel prep 100/pack

















Repeat Volume Pipettor Tips, 50ml (example Thermo Scientific Finntip, pack of 10, Fisher #21-377-160) Panel Prep 10/pack

















50 mL Centrifuge tubes, polypropylene Panel prep 50/pack

















250 mL plasma storage bottles (example, Fisher #02-893B) Panel Prep 12/pack

















PBS with 0.05% Tween 20, pH 7.4 powder (Sigma-Aldrich #P3563) Panel prep 10/box

















Green food coloring dye, local market purchase Panel prep each

















Disposable transfer pipettes (Samco #282 transfer pipet Panel prep 500/box

















Disposable transfer pipettes (Samco #282 transfer pipet, Fisher #13-711-43) DTS panel prep 500/box

















10 mL Serological pipette Panel prep 200/case

















Cryoboxes, 9x9in 81-place Multi use each

















Cryoboxes, 5x5in 25-place (example, Fisher #12-565-183) Training Panel case of 24

















Absorbant surface protectors or bench pad/linen saver Biosafety 50/pack

















70% Alcohol or Bleach-Based Disinfectant Biosafety bottle

















Chemically Resistant Permanent Markers, ultra fine tip Labelling-training each

















Pens, black ballpoint Record Keeping each

















Lab Timer, multi-channel/Single channel RTRI training each

















Paper towels RTRI training Roll

















Printing paper RTRI training Pack

















RTRI Job Aids RTRI training Each

















Surgical Masks (example, Fisher #19-088-879) PPE pack of 500

















Hand Sanitizer (example, Fisher #23-001-729) PPE each

















Disposable Face Shields (example, Fisher #19-181-600B) PPE pack of 25

















Optional: 1L Disposable 0.2 uM filter flask (Fisher #09-761-104) PT buffer case of 12

















Optional: Reagent grade deionized water, (Fisher #23-751610) DTS 1 gal



















The words contained in this file might help you see if this file matches what you are looking for:

...Sheet how to use this tool rapid test for recent infection rtri surveillance activities and inventory comprehensive spreadsheet has been developed aid implementors calculate the laboratory consumables needed trainings specimen panel production quality control qc panels training tp proficiency testing pt maintain a log ensure sufficient supply upcoming additional tots stepdown monitor national stock of tests determine when place next order there are no stockouts monitoring program an results blood bank samples used make estimated costs associated with implementing recency programinstructions provided on each tab fill in necessary information frequently should be performed consideration intended users include but not limited reference lab nrl staff moh partners study managers responsible maintaining supplies calc calculating hiv instructionsthis calculator is estimate total number kits other labrelated trainers dts plasma preparation will vary depending country pricing agreement vendors ...

no reviews yet
Please Login to review.