v1.0.1 (2023-08-15 at 5:00pm ET)

• Fixed equation for Conservation Tillage (60% residue) so that correct cell was used for "Lbs/Yr Reduced" calculation
• Corrected "available load" calculations for Manure Treatment (Thermo Chemical) and Manure Treatment (Composting) BMPs

v1.0.0 (2020-01-09 at 1:00pm ET)

• Allows for input of farm animal information returned by Model My Watershed
• Allows for calculation of streambank loading rates based on information returned by Model My Watershed
• Incorporates data checks to avoid over-implementation of various agricultural BMP's.
• Added a completed example spreadsheet

v0.8.1 (2018-10-17 at 11:30am ET)

This minor release fixes a few oversights from the last release, including:

• Added Reid Christianson as a co-author. Reid was the original developer of the Clean Water Optimization Tool (CWOT) when he was at the Center for Watershed Protection (CWP), and much of his work is built into this MMW BMP spreadsheet tool.
• Added forward compatibility for handling the outputs for "Low-Density Open" that will come with MMW v1.24 as described in #9 & #10. Although this implementation doesn't explicitly show the new mapping of "NLCD 21 Developed, Open Space", it will still give the correct answer.

v0.8.0 (2018-10-03 at 3:19 pm CT)

This second release incorporates input from PA DEP to improve clarity, documentation and overall usability of the "MMW-BMP_Spreadsheet_Tool.xlsx" file, along with an updated User Manual.

Specifically, this release includes:

• Color coding of tabs and cells to better indicate where a user needs to fill in information.
• Reorganization and renaming of tabs for consistency, including:
  • Resolved issue #8 to "Combine "Stream Bank Loading Rate" tabs for Sediment, Nitrogen & Phosphorus"
  • Resolved issue #7 to "Create "Technical Documentation" tab, expanding from "Perf Std Approach""
  • Minor formatting changes to improve consistency amongst the tabs
• Fix to "Urban Area" section of "Total Load Reductions" tab, to return "--" if Urban Area (and their loads) are zero.
• Improved number formatting in "Total Load Reductions" tab, adding commas to the big numbers and percent symbols to the percentages.
• Improved documentation, by adding a NLCD>MapShed Landuse category conversion table to bottom of the TechDocs tab, partially completing issue #9.

v0.7.0-beta (2018-07-30 at 9:15 CT)

This is the first release of the Model My Watershed BMP Spreadsheet Tool that both:

• Accepts outputs from the Model My Watershed "multi-year" model (GWLF-E), https://app.wikiwatershed.org.
• Models the benefits of Urban Best Management Practices (BMPs) using the Chesapeake Bay Program's (CBP's) "Performance Standard" approach to calculating load removal efficiencies