ReacGlos.txt
Description: This file provides the glossary terms and definitions listed on the Glossary card of the Worksheet ("Glossary" button on the Mixture card).
Structure: Simple 2-field data file. Field 1 contains the glossary term and field 2 contains the term definition.
Modifying: Current records can be modified and new records added as desired. Changes will appear in the Worksheet.
ReacInfo.txt
Description: This file provides the reactivity group definitions listed on the About Reactive Groups card of the Worksheet ("Reactive Groups" button on the Mixture card).
Structure: Simple 3-field data file. Field 1 contains the unique reactive group number, field 2 contains the group name, and field 3 contains the group description. Field 3 may contain back slash characters for line formatting.
Modifying: Reactive group descriptions can be modified as desired. Do not change reactive group names or numbers unless you make corresponding changes to the ReacTbl.txt and ReacChem.txt files. New records can be added, and will appear in the About Reactive Groups card, but will not become functional until they are added to ReacTbl.txt.
ReacHaz.txt
Description: This file provides hazard statements about mixture results. The statements appear in the results field of the Mixture card and both the statements and the hazard codes appear on the Compatibility Chart card of the Worksheet.
Structure: Simple 2-field data file. Field 1 contains the unique hazard code and field 2 contains the corresponding hazard statement.
Modifying: Hazard statements can be modified at will. Do not change hazard codes. New codes (as new records) can be added, but they will not appear in the Worksheet until they have been entered somewhere in the ReacTbl.txt data file.
ReacTbl.txt
Description: This file is the meat of the mixture code. When two chemicals are "mixed" (assume for now that each chemical belongs to a single reactive group), the reactive group for each chemical is used to look up mixing results in this file using a standard "mileage triangle" lookup chart format. The contents of a lookup cell (field), instead of mileage between cities, are zero or more hazard statements representing the "results" of mixing these two chemicals. The file is half-full of data (triangle) with data in the lower-left quadrant, so a lookup of groups 12 & 40 should be made at (row 40, column 12) instead of (row 12, column 40). Actually, the proper lookup method is: find row of group 12 (say m), find row of group 40 (say n), if m > n, then lookup at row m, column n+2, where +2 skips past the first 2 fields of each record. Also, if chemical 1 belongs to 2 reactive groups and chemical 2 belongs to 3 reactive groups, then 2*3 = 6 lookups must be performed. Finally, groups with numbers greater than 99 are treated specially in the code.
Structure: Each reactive group has its own record. Field 1 contains the group name, field 2 contains the unique group number and field 3 through x contains zero or more hazard codes. Multiple hazard codes within a field are delimited by commas. An empty field represents "no reaction" unless the field is in the upper-right quadrant, in which case you are looking at the wrong field.
Modifying: Do not modify fields 1 and 2 of each record. Make changes to the hazard codes at your own risk. If you feel changes are warranted due to erroneous data, please notify our Chemical Reactivity Worksheet Specialist (see link at page bottom) so that we can correct our database if needed. New records (i.e., new reactive groups) may be added, but this entails providing hazard codes for any new group vs. all the other groups in the file. To maintain row/column alignment, new records should be added to the end of the file (there is an inherent assumption that the group row number matches its column number+2). Note that you will probably want to assign the new reactive group to one or more chemicals in the file ReacChem.txt.
ReacChem.txt
Description: This file provides information about specific chemicals and is derived from NOAA's CAMEO (Computer-Aided Management of Emergency Operations) database. The information in this file is what appears in the Search Results card which displays chemicals for adding to the mixture.
Structure: Each chemical appears as a single record. This file has a single header record (perhaps not as originally intended, but it's good that it's there). The header record makes the fields pretty self-explanatory. Many of the synonym fields are huge, with back slashes delimiting synonyms within the field. CAS numbers include the dashes (unlike CAMEO). Multiple CAS or United Nations (UN) numbers for a given chemical are also delimited by back slashes.
Modifying: Current records can be modified and new records added as desired, or records may be deleted. The order of the chemicals in the file (alphabetical by name) is also the order they will appear in a search collection.
