madd quick start guide
TRANSCRIPT
-
Quick Start Guide for Materials Drum Database (M.A.D.D.)
Introduction: The purpose of M.A.D.D. (Materials Drum Database) is to allow anyone to enter data, sort
through, track and collate the mass of sometimes apparently non-related data generated from a drum site or
a site having either a few or many containers. Below are some guidelines to most effectively use M.A.D.D.
Prior to Numbering Containers: A simple numeric system is essential for material tracking. It is
suggested that the number 1 not be used to start the numbering system. A numbering system such as the
following will provide instant identification of container types (refer to these as 1000, 5000, etc. series
types of materials).
1000-4999: 55-gallon drums
5000-6999: 1-gallon to 35-gallon containers
7000-7999: Bulk Materials pallets of one type of chemical or material
8000-8999: Tanks or bulk storage
9000-9999: Miscellaneous
If a container is later determined not to have either an identification number or was mislabeled, simply use
the last unused number in the respective sequence to identify it. Do not use an alpha-numeric system. For
example, identifying it such as 1015-A could lead to confusion and misidentification. If the -A is inadvertently dropped and there is already a container identified as 1015, then there would exist the
possibility of two containers having the same number.
Further Identification: Once the materials in the containers have been identified from onsite
categorization, laboratory analysis, visual inspection or properly labeled containers, color coding is an
effective means for compatibility group identification/recognition. A system using various colors spray
painted on individual containers provides unambiguous material identification:
Red Flammable
White Base (pH >12.5)
Yellow Acid (ph< 2.5)
Blue Aqueous
Green Non-Hazardous (Trash / Debris / Construction debris)
Orange Non-regulated
Black Air or Water Reactive / Special Segregation / Oxidizers / Shock Sensitive / Multiple Hazardous Properties / Special Handling
Database Forms: There are four basic forms used in MADD. They are:
1. Drum Field Information Form: Starting point for entering basic field info. 2. ChemCat Form: A subform & companion to the Drum Field Info Form
3. Bulking (Blending) Forms: Drum/Container 55-gal. Drum or smaller bulking activities
Large Container Bulking 55-gal drums into Tanks / Tanker Truck activities
4. Lab analytical results: Analytical data from a fixed lab
Using the Database: The database comes in two versions; one populated with data for practice (MADD Practice) and one without data, as a template for project utilization (MADD template). Data can be entered into the template using either the FORM or DATASHEET (very similar to a spreadsheet) views.
When entering blocks of identical data, use the copy command and then the paste command
while in the datasheet view to enter information quickly. In the datasheet view, it is easy to
overwrite previously entered data. Use the pull down menus for repetitive data entry.
MADD utilizes pre-written Queries. Commonly used Queries and Forms are included in the MADD
Switchboard. Clicking on cancel while exiting a range query in the Switchboard form will generate an error. Do not hit , simple hit to exit the query.
Database Tips: Enter all data from the field log sheets into MADD. Use Word Merge function for
generating pre-numbered log sheets. Part of the MADD system includes the following form templates:
Field Log sheets; Lab ChemCat spreadsheet; Color code sheet and electronic COC. Please contact James
Hawkins [email protected] for questions or comments.