Transcript Department of Environmental Quality

The Updated Jordan-Falls Stormwater Nutrient
Accounting Tool
JFSNAT v4.0
DEPARTMENT OF ENVIRONMENTAL QUALITY
Trish D’Arconte
August 2016 Nutrient Scientific Advisory Board Meeting
| August 5, 2016
Jordan-Falls Tool: What’s New?
• Considerable changes from version 3.0 beta
• New Capabilities
•
•
•
•
Record information common to local government planning
Custom land uses
Easy to add new SCMs as they are approved, easy to update
Determine delivery factors, target loading rates, buydown
thresholds, and credits generated
• Export format easily imported to databases
• Corrected Bugs and Errors
•
•
•
•
Catchment routing and calculations
Import / export functioning
Clearing datasheets, removing catchments
Untreated areas previously left off of final export calculations
Department of Environmental Quality
2
Jordan-Falls Tool: What’s New?
• Easier to Use
•
•
•
•
•
Copy-paste land use data
Buttons all get you where you need to go
Warnings for inappropriate or mismatched data input
Formats show you required elements
Clearing functions reset data validation and formats so you
can’t break the spreadsheet with copy-pasting
• Coming Soon! New Suite of SCMs and Updated
EMCs
• SCM/BMP EMCs revised using new data
• Totally revisioned under/oversizing, BMPs separated into
groups with like under/oversizing behavior
• Under/oversizing and volume partitioning based on recent
NCSU study and other data
Department of Environmental Quality
3
Consistent Appearance
Intro Sheet
Improved Import
/ Export
Department of Environmental Quality
4
Working Buttons
Project Info Sheet
Record Nutrient
Management
Strategy info
Department of Environmental Quality
5
Highlighted cells required
(now you know)
Watershed Characteristics Sheet
Revised landuse
runoff EMCs
Department of Environmental Quality
6
Checks that your
total land use
areas match
BMP Characteristics Sheet part 1
Prints 1 catchment per 2
8.5 x 11” pages – EASY
TO READ
Warns you of
land use area
mismatch
More BMPs!
Updated BMP data
(coming soon)
Enter all 3 runoff volume
“fates” – free error checking!
More required data
highlighting
Department of Environmental Quality
7
So much improved
on this page!
(too much for text bubbles)
BMP Characteristics Sheet part 2
Catchment routing checks
for data entry errors
Displays data for
untreated area
No more merged cells,
land uses in the same order
Department of Environmental Quality
8
(copy-paste to your heart’s content)
Calculates all
sorts of new and
useful info
Overall Summary Sheet
Nutrient credit
calculation and
delivery to lake
Warns you of
land use area
mismatch
Better print layout
Catchment
data calculates
correctly
Department of Environmental Quality
9
BMP Summary Sheet
ALL underlying runoff, BMP,
and catchment calculations
reviewed and corrected
Department of Environmental Quality
10
Release Date and Bug Reports
• Planned formal release late fall 2016, coordinated with
DEMLR SCM Crediting Document, and pending DWR
Director approval
• New User Manual
• Formal engineering review by DEMLR and NCSU BAE
in September
• Contact Trish D’Arconte to report bugs:
• [email protected]
• 919-807-6441
Department of Environmental Quality
11
Ready to try it?
Department of Environmental Quality
12