Before adding Chemical Usage data to your EHS-Dashboard™ it is important to first configure a master list of Materials and Constituents. This enables the EHS-Dashboard™ to calculate Air Emissions and total Constituent use based on your Chemical Usage inputs. This is a one time step that you should do to setup your ChemTrack program. After your initial import, you should use the Application Interface to add additional Materials and perform edits to existing Materials.


Each Material must have at least 1 Constituent - even if it is 100% of the material. You can easily import this data in two separate files: one for Materials, and one for Constituents. 


To Import a Materials List: 


    1.) Create a spreadsheet with the column headers listed below: 

  • Part Number
  • Material Name
  • Unit of Measure - Purchased
  • Volume / Weight per qty - Purchased (<--Conversion Factor)
  • Output Unit of Measure 
  • Density 
  • Specific Gravity


2.) Save the file to your computer. An example file is shown below:        


3.) In your EHS-Dashboard™  click on the white company icon in the top right corner of the Navigation Menu:


4.) Click "Import Data":

 

5.) Click "Upload Document":


6.) Follow the steps in the "Document Import Wizard" to select the appropriate file from your computer:


- 1.) Use the drop down for "Select a Facility" and choose the facility you are uploading data to, then click "Next":


 - 2.) Use the dropdown menu for "Select Document Type" to select "Material Safety Data Sheets", then click "Next": 


3.) Now click "Browse" to locate the file and upload it. Once attached, click "Finish":


4.) Click "Upload" if the confirmation table is correct. Or click "Restart" if anything needs to be changed:


5.) Once your file is uploaded to the EHS-Dashboard™ - follow the remaining steps to complete your import.

6.) Click "Next" to finish your upload.  


*Note: After your initial import, you should use the Application Interface to add additional Materials and perform edits to existing Materials.