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