Home : Ohio EPA Credible Data Report
Q14553 - INFO: Ohio EPA Credible Data Report

Ohio EPA Credible Data Report XML file can be produced by using the OH-EPA-Credible-Data-Report.hwr (preview) template, setting the report type to "OH EPA Credible Data Report".

This report typically is used to report Chemical Monitoring Data and a sheet should be created for each Lab Cal Sample to be reported. 

HINTS for filling out report. 

1. On the General Information tab, place one "X" in B40:B43.  For Chemical Monitoring B43 should be equal to X for the report to generate the XML for Chemical Monitoring.

2. Use Sheet, Copy Sheet to create as many Chemical Monitoring Sheets as you need for the samples you are reporting.  THE SHEET NAME MUST START WITH "Chemical Monitoring" in order to be output.  Example sheet names: Chemical Monitoring 1,Chemical Monitoring 2,Chemical Monitoring 3,...

3. Set the Report type to "OH EPA Credible Data Report"

4. For tests that will be reported, the Storet Code and OH:CharacteristicValue must be set in Test Setup.  The Ohio Characteristic Values can be found in the table below (source is from the CWLBP 04-06-2017.xls file provided by the state, on sheet InternalData).  By default the report template uses Test.UD5 to hold the OH:CharacteristicValue but any UD field can be used. 

Acidity (CaCO3), Total (mg/l) 00435 1448
Acidity As HNO3 In Water (ug/l) 82206 1449
Acidity, Mineral (Methyl Orange) (mg/l) 00436 1450
Adsorbable Organic Halides (aox), Effluent (ug/l) 79855 1451
Alachlor (ug/l) 39161 1753
Aldrin (ug/l) 39330 1452
Algae, Total (No./ml) 60050 1453
Alkalinity, CaCO3 Stability (mg/l) 74023 1454
Alkalinity, Phenolphthein (mg/l) 00415 1455
Alkalinity, Total (CaCO3) (mg/l) 00410 1456
Aluminium, Dissolved (Al) (ug/l) 01106 1457
Aluminium, Total (Al) (ug/l) 01105 1458
Aluminum, Total Recoverable (ug/l) 01104 1459
Ammonium Perfluoroctanoate (ug/l) 51065 1460
Antimony, Total (ug/l) 01097 1461
Antimony, Total Recoverable (ug/l) 01268 1462
Arsenic, Total (As) (ug/l) 01002 1463
Arsenic, Total Recoverable (ug/l) 00978 1464
Asbestos (Fibers/L) 81855 1465
Asbestos (ug/l) 34225 1466
Atrazine (ug/l) 39033 1467
BOD, Carbonaceous, 20 Day, 20 Deg C (mg/l) 80087 1475
Barium Total (Ba) (ug/l) 01007 1468
Barium, Total Recoverable (ug/l) 01009 1469
Benthic chlorophyll a 32223 1744
Beryllium, Total (ug/l) 01012 1470
Beryllium, Total Recoverable (ug/l) 00998 1471
Bioassay, Mean Tolerance Level (%) 61402 1472
Biochemical Oxygen Demand, 5 Day (mg/l) 00310 1473
Bismuth, Total (Bi) (ug/l) 01017 1474
Boron, Total (ug/l) 01022 1476
Boron, Total Recoverable (ug/l) 00999 1477
CBOD  5 day (mg/l) 80082 1486
CBOD 20 day (mg/l) 80088 1487
CBOD 5 Day, 20 Deg C, Filtered (mg/l) 80280 1488
COD, Soluble (mg/l) 80116 1509
Cadmium, Dissolved (Cd) (ug/l) 01025 1478
Cadmium, Total (Cd) (ug/l) 01027 1479
Cadmium, Total Recoverable (ug/l) 01113 1480
Calcium, Total (Ca) (mg/l) 00916 1481
Captan In Whole Water Sample (ug/l) 39640 1482
Carbon Dioxide (mg/l) 00405 1483
Carbon, Dissolved Organic (as C) 00681 1739
Carbon, Total (as C) (mg/l) 00690 1484
Carbon, Total Organic (TOC) (mg/l) 00680 1485
Chemical Oxygen Demand (High Level) (mg/l) 00340 1489
Chemical Oxygen Demand (Low Level) (mg/l) 00335 1490
Chloride, Organic (mg/l) 70352 1491
Chloride, Total (mg/l) 00940 1492
Chlorine, Free Available (mg/l) 50064 1493
Chlorine, Total Residual (mg/l) 50060 1494
Chlorophyll, A (ug/l) 32209 1495
Chromium Trivalent Dissolved (ug/l) 80357 1496
Chromium, Dissolved (Cr) (ug/l) 01030 1497
Chromium, Dissolved Hexavalent (ug/l) 01220 1498
Chromium, Hexavalent (Cr +6) (ug/l) 01032 1499
Chromium, Total (Cr) (ug/l) 01034 1500
Chromium, Total Recoverable (ug/l) 01118 1501
Chromium, Trivalent (Cr +3) (ug/l) 01033 1502
Chronic Toxicity Daphnia magna (% Affected) 61439 1503
Chronic Toxicity, Ceriodaphnia dubia (TUc) 61426 1504
Chronic Toxicity, Daphnia Magna, 21 Day (% Affected) 04270 1505
Chronic Toxicity, Pimephales promelas (TUc) 61428 1506
Cobalt, Total (Co) (ug/l) 01037 1507
Cobalt, Total Recoverable (ug/l) 00979 1508
Coliform, Total (#/100 ml) 31505 1510
Coliform, Total Membrane Filter (#/100 ml) 31501 1511
Color (Platinum - Cobalt Units) (Units) 00080 1512
Color, Severity (Units) 00083 1513
Color, Spectrophoto (Admin Units) 00082 1514
Conductivity (Umho/Cm) 00094 1515
Copper, Dissolved (Cu) (ug/l) 01040 1516
Copper, Total (Cu) (ug/l) 01042 1517
Copper, Total Recoverable (ug/l) 01119 1518
Cyanide, Amenable to Chlorination (mg/l) 00722 1519
Cyanide, Dissolved (ug/l) 00723 1520
Cyanide, Free (mg/l) 00719 1521
Cyanide, Total (mg/l) 00720 1522
Cyanide, Weakacid Dissociable (mg/l) 00718 1523
Dissolved Oxygen (mg/l) 00300 1524
Dissolved Oxygen, Maximum 51646 1736
Dissolved Oxygen, Minimum 51645 1735
E. coli (#/100 ml) 31648 1525
Enteric Viruses Plaque-Forming Unit (PFU/4G) 81401 1526
Fecal Coliform (#/100 ml) 31616 1527
Fecal Streptococci (Membrane Filt) (#/100 ml) 31679 1528
Fecal Streptococci, (General Permit) (#/100 ml) 74054 1529
Fecal Streptococci, Plate Count KF Agar, 35C, 48hr (#/100 ml) 31671 1530
Flow Rate (CFS) 00060 1531
Flow Rate (Cubic meters/day) (M3/Day) 74060 1532
Flow Rate (GPD) 00056 1533
Flow Rate (MGD) 50050 1534
Flow Rate, Dilute (GPD) 00057 1535
Flow Rate, Instantaneous (GPM) 00059 1536
Flow Rate, Unregulated (GPD) 00058 1537
Flow, Peak Rate (MGD) 50047 1538
Flow, Severity (Units) 01351 1539
Fluoride, Dissolved (F) (mg/l) 00950 1540
Fluoride, Total (F) (mg/l) 00951 1541
Freeboard (feet) 82564 1542
Glyphosate (ug/l) 79743 1807
Gold, Total (ug/l) 71910 1543
Halogen,Total Organic, Whole Water Sample (ug/l) 78115 1544
Halomethane, Sum of (ug/l) 78456 1545
Hardness, Total (CaCO3) (mg/l) 00900 1546
High Water Temperature (F) 00013 1547
Hydrogen Sulfide H2S (mg/l) 71875 1548
Iron, Dissolved (Fe) (mg/l) 74011 1549
Iron, Dissolved (Fe) (ug/l) 01046 1550
Iron, Ferrous (Fe++) (ug/l) 01047 1551
Iron, Suspended (Fe) (ug/l) 01044 1552
Iron, Total (Fe) (mg/l) 74010 1553
Iron, Total (Fe) (ug/l) 01045 1554
Iron, Total Recoverable (ug/l) 00980 1555
Isophorone, Total (ug/l) 34408 1556
Lead, Dissolved (Pb) (ug/l) 01049 1557
Lead, Total (Pb) (ug/l) 01051 1558
Lead, Total Recoverable (ug/l) 01114 1559
Lithium, Total (Li) (ug/l) 01132 1560
Low Water Temperature (F) 00012 1561
Magnesium, Total (Mg) (mg/l) 00927 1562
Manganese, Dissolved (Mn) (ug/l) 01056 1563
Manganese, Suspended (Mn) (ug/l) 01054 1564
Manganese, Total (Mn) (ug/l) 01055 1566
Manganese, Total (mg/l) 74013 1565
Manganese, Total Recoverable (ug/l) 11123 1567
Manure Solids, Percent Total (%) 51091 1568
Mercury, Total (Hg) (ug/l) 71900 1569
Mercury, Total (Low Level) (ng/l) 50092 1570
Mercury, Total (Low Level, PQL=1000) (ng/l) 50286 1571
Mercury, Total Recoverable (ug/l) 71901 1572
Methyl Blue Active Substances (MBAS) (mg/l) 38260 1573
Methyl Tertiary Butyl Ether (MTBE) (ug/l) 46491 1574
Molybdenum (Mo) (ug/l) 01062 1575
Molybdenum, Total Recoverable (ug/l) 01129 1576
Nickel, Dissolved (Ni) (ug/l) 01065 1577
Nickel, Total (Ni) (ug/l) 01067 1578
Nickel, Total Recoverable (ug/l) 01074 1579
Nitrite Plus Nitrate, Total (mg/l) 00630 1580
Nitrogen Kjeldahl, Total (mg/l) 00625 1581
Nitrogen Nitrate, Total N03 (mg/l) 71850 1582
Nitrogen Nitrite, Total N02 (mg/l) 71855 1583
Nitrogen, Ammonia (NH3) (mg/l) 00610 1584
Nitrogen, Ammonia, Total (As NH4) (mg/l) 71845 1585
Nitrogen, Inorganic, Total (mg/l) 00640 1586
Nitrogen, Nitrate (NO3) (mg/l) 00620 1587
Nitrogen, Nitrite (NO2) (mg/l) 00615 1588
Nitrogen, Total (mg/l) 00600 1589
Odor, Severity (Units) 01330 1590
Oil and Grease Severity (Units) 01300 1591
Oil and Grease, Freon Extr-Grav Meth (mg/l) 00556 1592
Oil and Grease, Hexane Extr Method (mg/l) 00552 1593
Oil and Grease, Total (Infrared) (mg/l) 00560 1594
Oil and Grease, Total (mg/l) 00550 1595
Organic Nitrogen, Total (mg/l) 00605 1596
Organics, Total Toxic (mg/l) 78141 1597
Organics, Volatile, Detected, Numeric Code, Code (code) 84085 1598
Ortho Phospate, Total (mg/l) 00660 1599
Overflow Occurrence (No./Month) 74062 1600
Overflow Volume (Million Gallons) 74063 1601
Oxidants, Total Residual (mg/l) 34044 1602
PAHs (ug/l) 22456 1603
Pathogen Class Alternative Used (Number) 84369 1604
Petrol Hydrocarbons, Tot. Rec. (mg/l) 45501 1605
Phosphate, Total (PO4) (mg/l) 00650 1611
Phosphorous, Dissolved (P) (mg/l) 00666 1612
Phosphorus, Total (P) (mg/l) 00665 1613
Phosphorus, Total Orthophosphate (mg/l) 70507 1614
Plate Count, Total (No./ml) 31751 1615
Platinum, Total (ug/l) 01171 1616
Potassium, Total (K) (mg/l) 00937 1617
Process to Further Reduce Pathogens Path (Number) 46397 1618
Process to Significantly Reduce Pathogen (Number) 46396 1619
Rainfall in Inches (Inches) 46529 1620
Reaeration Rate (/day) 00330 1621
Residue, Settleable (Volume) (mL/L) 00545 1623
Residue, Settleable (mg/l) 00546 1622
Residue, Total (mg/l) 00500 1624
Residue, Total Dissolved (mg/l) 00515 1625
Residue, Total Filterable (mg/l) 70300 1626
Residue, Total Fixed (mg/l) 00510 1627
Residue, Total Nonsettleable (mg/l) 00547 1628
Residue, Total Volatile (Organic) (mg/l) 00505 1629
Residue, Volatile Filterable (mg/l) 00520 1630
Residue, Volatile Nonfilterable (mg/l) 00535 1631
Residue,Total Filtrable (Dried At Any Temp) (mg/l) 70295 1632
Salmonella Sp. (MPN/4G) 71202 1633
Selenium, Total (Se) (ug/l) 01147 1634
Selenium, Total Recoverable (ug/l) 00981 1635
Silver, Total (Ag) (ug/l) 01077 1636
Silver, Total Recoverable (ug/l) 01079 1637
Simazine (ug/l) 39055 1752
Sodium, Total (Na) (mg/l) 00929 1638
Solids, Dissolved-Sum of (mg/l) 70301 1639
Specific Conductance at 25 Degrees C (Umho/cm) 00095 1640
Specific Gravity (g/l) 82205 1642
Specific Gravity (g/l) 72013 1641
Static Water Level (Feet) 72019 1643
Stormwater Overflow Volume (MGD) 50054 1644
Stream Stage (feet) 00065 1751
Sulfate, (SO4) (g/l) 00947 1645
Sulfate, (SO4) (mg/l) 00945 1646
Sulfide, Total (mg/l) 00745 1647
Sulfite (SO3)(S) (mg/l) 00740 1648
Tannin and Lignin (mg/l) 32240 1649
Test Parameter (#/day) 77777 1650
Thallium, Total (TL) (ug/l) 01059 1651
Thallium, Total Recoverable (ug/l) 00982 1652
Threshold Odor (T.N.) 00085 1653
Tin, Total (Sn) (ug/l) 01102 1654
Titanium, Total (Ti) (ug/l) 01152 1655
Titanium, Total Recoverable (ug/l) 00984 1656
Total Metals (ug/l) 82095 1657
Total Oxygen Demand (mg/l) 00343 1658
Total Precipitation (Inches) 00045 1659
Total Suspended Solids (mg/l) 00530 1660
Toxicity Equivalent (pg/l) 76025 1661
Toxicity-Unit C-Selenc (TUc) 61431 1662
Transparency, Secchi Disc (Inches) 00077 1663
Tungsten, Total (W) (ug/l) 01154 1664
Turbidity (J.U.) 00070 1665
Turbidity, Severity (Units) 01350 1666
Turbidity, Transmissometer (NTU) 00074 1667
Ultimate Oxygen Demand (mg/l) 00181 1668
Urea (mg/l) 71800 1669
Vanadium, Total (V) (ug/l) 01087 1670
Vanadium, Total Recoverable (ug/l) 01128 1671
Vanadium, Total Recoverable In Water (as V) (ug/l) 00985 1672
Water Temperature (C) 00010 1673
Water Temperature (F) 00011 1674
Zinc, Dissolved (Zn) (ug/l) 01090 1675
Zinc, Total (Zn) (ug/l) 01092 1676
Zinc, Total Recoverable (ug/l) 01094 1677
Zirconium, Total (Zr) (ug/l) 01162 1678
pH (S.U.) 00400 1606
pH, CaCO3 Stability (S.U.) 70311 1607
pH, Lab (S.U.) 00403 1608
pH, Maximum (S.U.) 00401 1609
pH, Minimum (S.U.) 00402 1610

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 10/3/2019 1:01 PM.
Last Modified on 10/8/2019 3:53 PM.
Last Modified by Scott Dorner.
Article has been viewed 571 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article