Duke WasteTrackingCUHWC 2013

Two programs

Laboratory Safety Management System WasteTracking

Technical babble

Language: C# (ASP.net), 2008 SQL server database Interface (software): Visual Studio 2010 Make it look pretty: Telerik (buttons, hovering, loading circle) Printing barcodes and reports: Neodynamic’s Barcode for

Reporting Service SSRS(SQL server reporting services) Sounds: JavaScript with SoundManager using mp3 Weight: ActiveXperts Serial Port Component with JavaScript

Equipment used

• Windows based

• Must have speaker

Computer

• Honeywell 4820i Scanner

Scanner

• Adam CPWplus

• 165 lb x 0.05 lb

Scale

• HP LaserJet P3005dn

• Avery labels 5161, 5167

Printer

Submit a pickup

Barcodes (data matrix, 2D) Log sheet

Picking up the waste

Processing the waste

Any questions?

none….great!

my office is now closed!

ID Description1 Requested by User2 Requested by EP3 Barcode Printed4 Barcode Reprinted5 Barcode Deactivated6 Added to Pickup (not submitted)7 Moved to a different Pickup (not submitted)8 Removed from Pickup (not submitted)9 Submitted for Pickup

10 Hazardous Waste Determination Made11 Moved to Normal Pending Pickups12 Moved to Offsite Pending Pickups (Marked Cleanout)13 Moved to Offsite Pending Pickups (Marked Offsite)14 Moved back to Normal Pending Pickups15 Added to Normal Pickup List16 Added to Offsite Pickup List17 Waste Label Printed18 Picked Up / Received19 Chemical Determination Made20 Checked In21 Chemical Determination Changed22 Waste Label Reprinted24 Packed in Box25 Transferred to Another Drum26 Transferred to Another Box27 Removed from Drum28 Removed from Box23 Packed in Drum29 Add to Pending Shipment30 Removed from Shipment31 Confirmed to be Shipped32 Shipped

# of Barcodes picked up

CHEM RAD 2010 1,529 122 2011 12,744 821 2012 13,322 796 2013(so far) 6,410 443

Recorded steps