{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Shoreline Credit Calculator","Min Qualifying Conditions","Lookup","Protocol 1","Protocol 2","Protocol 3","Protocol 4"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":30,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Shoreline Credit Calculator","index":0,"n_rows":48,"n_cols":5,"rows_kept":48,"cut":false,"hidden":false,"merged":[[19,0,20,0],[19,1,20,9],[21,1,22,9],[21,0,22,0],[0,1,0,4],[40,0,40,9],[39,0,39,9],[26,0,26,9],[25,0,25,9],[14,0,15,9],[12,0,12,9],[10,0,11,9],[9,0,9,9],[8,0,8,9],[33,0,33,9],[34,0,35,9],[13,0,13,9],[17,0,17,9],[27,1,27,3],[18,1,18,9],[41,0,42,0],[37,0,37,1],[36,0,36,1],[37,2,37,3],[36,2,36,3],[41,1,41,3],[41,4,42,4],[31,1,31,3],[30,1,30,3],[29,1,29,3],[28,1,28,3]]}
[null,"Shoreline Management MS4 Credit Calculator for TN, TP, TSS, and EIA"]
[null,"Version: 05/23/2022"]
[null,"Maryland Department of the Environment - Water and Sciences Administration"]
[]
[]
[]
[]
[]
["About the Calculator"]
["1. This calculator estimates the pollutant load reductions and Equivalent Impervious Acre (EIA) credit for shoreline management projects."]
["2. The Minimum Qualifying Conditions tab outlines conditions that projects must meet to be eligible for credit. This criteria is found in the expert panel approved by CBP: https://chesapeakestormwater.net/bmp-resources/shoreline-management/"]
[]
["3. EOT load in this spreadsheet is calculated following the protocols recommended by the expert panel approved by CBP."]
["4. EIA credit is calculated using Forest-Impervious load deltas with Stream Bed and Bank (STB) Load. These deltas account for inconsistencies in load distribution between the Phase 5 and 6 model. "]
["5. Please populate the blue cells in this worksheet with applicable project data.  The calculator will subsequently generate the TN, TP, and TSS load reduction and EIA credit for the project. Once finished, email this spreadsheet along with <<other supporting documentation>> to <<insert contact info>>."]
[]
[]
["Revision Record:"]
["Date","Revision"]
["2020-04-10","1st Version"]
[]
["2022-05-23","Corrected Protocol 1 TN and TP load reduction formulas"]
[]
[]
[]
["BASIC PROJECT INFORMATION"]
["Populate blue cells with basic project information."]
["Project Name"]
["County"]
["Address"]
["Lat (XX.XXXXXX)"]
["Long (-XX.XXXXXX)"]
[]
["WATERSHED INFORMATION"]
["Populate blue cells below with information regarding Chesapeake Bay model geography.  To determine the applicable geography, locate your project on MDE's  interactive webmap at <<mde.state.md.us>>.  Locate your project site and identify the segment-shed and land-river segment it is located in."]
[]
["Segment-shed"]
["MD Land River Segment"]
[]
["SHORELINE MANAGEMENT CREDIT CALCULATOR "]
["Populate blue cells below with proposed BMP information."]
["Protocol","EOT Load (lbs/yr)",null,null,"EIA Credit (lbs/ac/yr)"]
[null,"TN","TP","TSS"]
[1,{"$f":"'Protocol 1'!M15","v":0},{"$f":"'Protocol 1'!M16","v":0},{"$f":"'Protocol 1'!M17","v":0},{"$f":"((B44/18.08)+(C44/2.23)+(D44/8046))/3","v":0}]
[2,{"$f":"'Protocol 2'!D10","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"((B45/18.08)+(0/2.23)+(0/8046))/3","v":0}]
[3,{"$f":"0","v":0},{"$f":"'Protocol 3'!D15","v":0},{"$f":"'Protocol 3'!D10","v":0},{"$f":"((0/18.08)+(C46/2.23)+(D46/8046))/3","v":0}]
[4,{"$f":"'Protocol 4'!B14","v":0},{"$f":"'Protocol 4'!B15","v":0},{"$f":"0","v":0},{"$f":"((B47/18.08)+(C47/2.23)+(0/8046))/3","v":0}]
["Total",{"$f":"SUM(B44:B47)","v":0},{"$f":"SUM(C44:C47)","v":0},0,{"$f":"SUM(E44:E47)","v":0}]

{"sheet":"Min Qualifying Conditions","index":1,"n_rows":18,"n_cols":2,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,0,18,1],[13,0,16,0],[9,0,12,0],[14,1,15,1]]}
["Minimum Qualifying Conditions"]
["In order for a project to qualify for EIA credits, it must meet the key criteria identified below, as well as all other criteria outlined within the expert panel report. "]
["Shoreline Management Practice","Load reduction criteria1"]
["General","1. No existing SAV is present."]
[]
["Living Shoreline –","1. The site is currently experiencing shoreline erosion or is replacing existing armor. The site was graded, vegetated, and excess sediment was removed or used."]
["a)     Nonstructural;","2. When a marsh fringe habitat (a or b) or beach/dune habitat (c) is created, enhanced, or maintained."]
["b)     Hybrid system including a sill; and"]
["c)     Hybrid system including a breakwater"]
["Revetment AND/OR Breakwater system without a living shoreline","1. The site is currently experiencing shoreline erosion."]
[null,"2. A living shoreline is not technically feasible or practicable as determined by substrate, depth or other site constraints."]
[null,"3. When the breakwater footprint would not cover SAV, shellfish beds, and/or wetlands."]
[]
["Bulkhead/Seawalls","1. The site is currently experiencing shoreline erosion."]
[null,"2. The site consists of port facilities, marine industrial facilities, or other marine commercial areas where immediate offshore depth (e.g., depths deeper than 10 feet 35 feet from shore) precludes living shoreline stabilization or the use of a breakwater or revetment."]
[]
[]
["1Projects that impact the Chesapeake Bay Preservation Act protected vegetation without mitigation receive no pollutant load reduction toward the Chesapeake Bay TMDL or EIA credit. MDE may, on a case-by-case basis, determine a practice ineligible for credit when the unintended consequences of negative impacts to wetlands and SAVs caused by these shoreline management techniques outweigh the benefits."]

{"sheet":"Lookup","index":2,"n_rows":507,"n_cols":4,"rows_kept":507,"cut":false,"hidden":false,"merged":[]}
["Land River Segment",null,"Segment-shed","Segmented-shed Name"]
["H24021PM1_3510_4000",null,"ANATF_DC","Anacostia River Tidal Fresh DC"]
["H24021PM3_3040_3340",null,"ANATF_MD","Anacostia River Tidal Fresh Maryland"]
["H24021PM4_3340_3341",null,"BACOH","Back River Oligohaline"]
["H24023PU2_4720_4750",null,"BIGMH","Big Annemessex River Mesohaline"]
["H24023PU3_4451_4450",null,"BOHOH","Bohemia River Oligohaline"]
["N24001PU0_3871_3690",null,"BSHOH","Bush River Oligohaline"]
["N24001PU1_3100_3690",null,"C&DOH_DE","C&D Canal Oligohaline Delaware"]
["N24001PU1_3580_3780",null,"C&DOH_MD","C&D Canal Oligohaline Maryland"]
["N24001PU1_3850_4190",null,"CB1TF","Northern Chesapeake Bay Tidal Fresh"]
["N24001PU1_3940_3970",null,"CB2OH","Northern Chesapeake Bay Oligohaline"]
["N24001PU2_3140_3680",null,"CB3MH","Upper Chesapeake Bay Mesohaline"]
["N24001PU2_3180_3370",null,"CB4MH","Middle Chesapeake Bay Mesohaline"]
["N24001PU2_3370_4020",null,"CB5MH_MD","Lower Chesapeake Bay Mesohaline Maryland"]
["N24001PU3_3680_3890",null,"CHOMH1","Choptank River Mesohaline mouth 1"]
["N24001PU4_3780_3930",null,"CHOMH2","Choptank River Mesohaline 2"]
["N24001PU4_3890_3990",null,"CHOOH","Choptank River Oligohaline"]
["N24001PU4_3970_3890",null,"CHOTF","Upper Choptank River Tidal Fresh"]
["N24001PU4_3990_3780",null,"CHSMH","Lower Chester River Mesohaline"]
["N24001PU4_4440_3970",null,"CHSOH","Middle Chester River Oligohaline"]
["N24001PU5_3930_4170",null,"CHSTF","Upper Chester River Tidal Fresh"]
["N24001PU5_4170_4020",null,"EASMH","Eastern Bay Mesohaline"]
["N24001PU6_3870_3690",null,"ELKOH","Elk River Oligohaline"]
["N24001PU6_4020_3870",null,"FSBMH","Fishing Bay Mesohaline"]
["N24003WL0_4390_0000",null,"GUNOH","Gunpowder River Oligohaline"]
["N24003WL0_4391_0000",null,"HNGMH","Honga River Mesohaline"]
["N24003WL0_4392_0000",null,"LCHMH","Little Choptank River Mesohaline"]
["N24003WL0_4393_0000",null,"MAGMH","Magothy River Mesohaline"]
["N24003WL0_4394_0000",null,"MANMH","Manokin River Mesohaline"]
["N24003WL0_4420_0000",null,"MATTF","Mattawoman Creek Tidal Fresh"]
["N24003WL0_4421_0000",null,"MIDOH","Middle River Oligohaline"]
["N24003WL0_4422_0000",null,"NANMH","Lower Nanticoke River Mesohaline"]
["N24003WL0_4423_0000",null,"NANOH","Upper Nanticoke River Oligohaline"]
["N24003WL0_4424_0000",null,"NANTF_DE","Upper Nanticoke River Tidal Fresh Delaware"]
["N24003WL0_4425_0000",null,"NANTF_MD","Upper Nanticoke River Tidal Fresh Maryland"]
["N24003WL0_4600_0000",null,"NORTF","North East River Tidal Fresh"]
["N24003WL0_4601_0000",null,"PATMH","Patapsco River Mesohaline"]
["N24003WL0_4602_0000",null,"PAXMH","Lower Patuxent River Mesohaline"]
["N24003WL0_4603_0000",null,"PAXOH","Middle Patuxent River Oligohaline"]
["N24003WL0_4770_0000",null,"PAXTF","Upper Patuxent River Tidal Fresh"]
["N24003WL0_4771_0000",null,"PISTF","Piscataway Creek tidal Fresh"]
["N24003WL0_4772_0000",null,"POCMH_MD","Lower Pocomoke River Mesohaline Maryland"]
["N24003WM0_3961_0000",null,"POCOH_MD","Middle Pocomoke River Oligohaline Maryland"]
["N24003WM0_3962_0000",null,"POCOH_VA","Middle Pocomoke River Oligohaline Virginia"]
["N24003WM0_3963_0000",null,"POCTF","Upper Pocomoke River Tidal Fresh"]
["N24003WM0_3966_0000",null,"POTMH_MD","Lower Potomac River Mesohaline Maryland"]
["N24003WM3_4060_0001",null,"POTOH1_MD","Lower Potomac River Oligohaline Maryland"]
["N24003XL3_4710_0000",null,"POTOH2_MD","Port Tobacco River Oligohaline Maryland"]
["N24003XL3_4711_0000",null,"POTOH3_MD","Nanjemoy Creek Oligohaline Maryland"]
["N24003XL3_4712_0000",null,"POTTF_DC","Upper Potomac River Tidal Fresh DC"]
["N24003XL3_4713_0000",null,"POTTF_MD","Upper Potomac River Tidal Fresh Maryland"]
["N24003XL3_4950_0000",null,"RHDMH","Rhode River Mesohaline"]
["N24003XU2_4270_4650",null,"SASOH","Sassafras River Oligohaline"]
["N24003XU2_4480_4650",null,"SEVMH","Severn River Mesohaline"]
["N24003XU3_4650_0001",null,"SOUMH","South River Mesohaline"]
["N24005SL2_2910_3060",null,"TANMH_MD","Tangier Sound Mesohaline Maryland"]
["N24005WM0_3650_0001",null,"WBRTF","Western Branch Patuxent River Tidal Fresh"]
["N24005WM0_3740_0001",null,"WICMH","Wicomico River Mesohaline"]
["N24005WM0_3741_0000",null,"WSTMH","West River Mesohaline"]
["N24005WM0_3742_0000"]
["N24005WM0_3743_0000"]
["N24005WM0_3744_0000"]
["N24005WM0_3745_0000"]
["N24005WM0_3881_3880"]
["N24005WM0_3964_0000"]
["N24005WM0_3965_0000"]
["N24005WM1_3660_3910"]
["N24005WM1_3910_0001"]
["N24005WM3_3880_4060"]
["N24005WM3_4060_0001"]
["N24005WU0_3021_3020"]
["N24005WU0_3540_0000"]
["N24005WU0_3541_0000"]
["N24005WU0_3542_0000"]
["N24005WU0_3670_0001"]
["N24005WU0_3671_0000"]
["N24005WU0_3820_0000"]
["N24005WU0_3821_0000"]
["N24005WU1_3350_3490"]
["N24005WU1_3482_0001"]
["N24005WU1_3490_3480"]
["N24005WU2_3020_3320"]
["N24005WU2_3320_3480"]
["N24005WU3_3480_3481"]
["N24005WU3_3481_0001"]
["N24009WL0_4772_0000"]
["N24009WL0_4920_0000"]
["N24009WL0_4921_0000"]
["N24009WL0_4922_0000"]
["N24009WL0_4923_0000"]
["N24009WL0_4925_0000"]
["N24009XL0_4954_0000"]
["N24009XL0_5320_0001"]
["N24009XL0_5341_0000"]
["N24009XL0_5342_0000"]
["N24009XL0_5343_0000"]
["N24009XL0_5345_0000"]
["N24009XL0_5346_0000"]
["N24009XL0_5348_0000"]
["N24009XL0_5350_0000"]
["N24009XL3_4713_0000"]
["N24009XL3_4950_0000"]
["N24009XL3_4951_0000"]
["N24009XL3_4952_0000"]
["N24011EL0_4591_0000"]
["N24011EL2_4590_0001"]
["N24011EL2_4630_0000"]
["N24011EM0_4322_0000"]
["N24011EM0_4323_0000"]
["N24011EM0_4324_0000"]
["N24011EM0_4327_0000"]
["N24011EM2_3980_0001"]
["N24011EM2_4100_0001"]
["N24011EM2_4101_0000"]
["N24011EM3_4320_0000"]
["N24011EM3_4321_0000"]
["N24011EM3_4325_0000"]
["N24011EM4_4740_0000"]
["N24013PM1_3120_3400"]
["N24013PM1_3450_3400"]
["N24013PM1_3711_3710"]
["N24013PM2_2860_3040"]
["N24013PM2_3400_3340"]
["N24013PM3_3040_3340"]
["N24013SL0_2831_2830"]
["N24013SL3_2460_2430"]
["N24013WM0_3881_3880"]
["N24013WM1_3882_3880"]
["N24013WM3_3880_4060"]
["N24013WU0_3021_3020"]
["N24013WU1_3350_3490"]
["N24015EU0_2940_0000"]
["N24015EU0_2941_0000"]
["N24015EU0_2985_0000"]
["N24015EU0_3010_0000"]
["N24015EU0_3050_0000"]
["N24015EU0_3130_0000"]
["N24015EU0_3131_0000"]
["N24015EU0_3200_0000"]
["N24015EU0_3201_0000"]
["N24015EU0_3202_0000"]
["N24015EU0_3203_0000"]
["N24015EU0_3300_0000"]
["N24015EU0_3301_0000"]
["N24015EU0_3302_0000"]
["N24015EU0_3360_0000"]
["N24015EU0_3361_0000"]
["N24015EU0_3362_0000"]
["N24015EU0_3363_0000"]
["N24015EU0_3364_0000"]
["N24015EU1_2650_0001"]
["N24015EU1_2810_0001"]
["N24015EU1_2980_0000"]
["N24015EU1_2981_0000"]
["N24015EU1_2982_0000"]
["N24015EU1_2983_0000"]
["N24015EU1_2984_0000"]
["N24015SL2_2480_0001"]
["N24015SL9_2720_0001"]
["N24015SL9_2970_0000"]
["N24015SL9_2971_0000"]
["N24017PL0_5290_0000"]
["N24017PL0_5390_0000"]
["N24017PL0_5391_0000"]
["N24017PL0_5392_0000"]
["N24017PL0_5440_0000"]
["N24017PL0_5450_0000"]
["N24017PL0_5510_0001"]
["N24017PL0_5530_5710"]
["N24017PL0_5580_0000"]
["N24017PL0_5581_0000"]
["N24017PL0_5582_0000"]
["N24017PL0_5583_0000"]
["N24017PL0_5584_0000"]
["N24017PL0_5585_0000"]
["N24017PL0_5670_0000"]
["N24017PL0_5671_0000"]
["N24017PL0_5710_0001"]
["N24017PL0_5720_0001"]
["N24017PL0_5790_0000"]
["N24017PL0_5791_0000"]
["N24017PL0_5860_0000"]
["N24017PL0_5930_0000"]
["N24017PL1_5230_0001"]
["N24017PL2_5300_5630"]
["N24017PL2_5630_0001"]
["N24017PL2_5800_0000"]
["N24017XL0_5340_0000"]
["N24019EL0_4591_0000"]
["N24019EL0_4592_0000"]
["N24019EL0_4593_0000"]
["N24019EL0_4598_0000"]
["N24019EL0_4892_0000"]
["N24019EL0_5151_0000"]
["N24019EL0_5262_0000"]
["N24019EL0_5280_0000"]
["N24019EL0_5281_0000"]
["N24019EL0_5282_0000"]
["N24019EL0_5283_0000"]
["N24019EL0_5284_0000"]
["N24019EL0_5285_0000"]
["N24019EL0_5590_0000"]
["N24019EL0_5766_0000"]
["N24019EL0_5890_0000"]
["N24019EL1_5150_0001"]
["N24019EL2_4630_0000"]
["N24019EL2_4634_0000"]
["N24019EM0_4322_0000"]
["N24019EM0_4880_0000"]
["N24019EM0_4881_0000"]
["N24019EM0_4883_0000"]
["N24019EM0_4884_0000"]
["N24019EM0_4885_0000"]
["N24019EM0_4886_0000"]
["N24019EM0_4887_0000"]
["N24019EM0_4888_0000"]
["N24019EM0_4889_0000"]
["N24019EM0_4890_0000"]
["N24019EM0_4891_0000"]
["N24019EM0_5260_0000"]
["N24019EM0_5261_0000"]
["N24019EM0_5263_0000"]
["N24021PM1_3450_3400"]
["N24021PM1_3510_4000"]
["N24021PM1_3710_4040"]
["N24021PM1_3711_3710"]
["N24021PM1_4000_4290"]
["N24021PM2_2860_3040"]
["N24021PM2_3400_3340"]
["N24021PM3_3040_3340"]
["N24021PM4_3340_3341"]
["N24021PM4_3341_4040"]
["N24021PM4_4040_4410"]
["N24021PM7_4150_4290"]
["N24021PM7_4200_4410"]
["N24021PM7_4290_4200"]
["N24021PM7_4410_4620"]
["N24023PU1_3850_4190"]
["N24023PU1_3940_3970"]
["N24023PU1_4190_4300"]
["N24023PU1_4300_4440"]
["N24023PU2_4720_4750"]
["N24023PU2_4750_4451"]
["N24023PU3_4450_4440"]
["N24023PU3_4451_4450"]
["N24025SL0_2721_2720"]
["N24025SL2_2750_2720"]
["N24025SL2_2910_3060"]
["N24025SL2_3060_0001"]
["N24025SL9_2720_0001"]
["N24025SL9_2970_0000"]
["N24025SL9_2971_0000"]
["N24025WU0_3160_0000"]
["N24025WU0_3161_0000"]
["N24025WU0_3162_0000"]
["N24025WU0_3163_0000"]
["N24025WU0_3164_0000"]
["N24025WU0_3250_0001"]
["N24025WU0_3251_0000"]
["N24025WU0_3252_0000"]
["N24025WU0_3253_0000"]
["N24025WU0_3254_0000"]
["N24025WU0_3255_0000"]
["N24025WU0_3540_0000"]
["N24025WU1_3240_3331"]
["N24025WU1_3330_0001"]
["N24025WU1_3331_3330"]
["N24025WU1_3482_0001"]
["N24025WU2_3020_3320"]
["N24027WM1_3882_3880"]
["N24027WM3_3880_4060"]
["N24027WM3_4060_0001"]
["N24027XU0_4090_4270"]
["N24027XU0_4091_4270"]
["N24027XU0_4092_4090"]
["N24027XU0_4130_4070"]
["N24027XU2_4070_4330"]
["N24027XU2_4270_4650"]
["N24027XU2_4330_4480"]
["N24027XU2_4480_4650"]
["N24029EU0_3360_0000"]
["N24029EU0_3361_0000"]
["N24029EU0_3362_0000"]
["N24029EU0_3363_0000"]
["N24029EU0_3570_0000"]
["N24029EU0_3571_0000"]
["N24029EU0_3572_0000"]
["N24029EU0_3573_0000"]
["N24029EU0_3700_0000"]
["N24029EU0_3720_0000"]
["N24029EU0_3724_0000"]
["N24029EU0_3725_0000"]
["N24029EU0_3726_0001"]
["N24029EU0_4010_0000"]
["N24029EU0_4011_0000"]
["N24029EU0_4012_0000"]
["N24029EU0_4013_0000"]
["N24029EU0_4014_0000"]
["N24029EU0_4015_0000"]
["N24029EU0_4016_0000"]
["N24029EU0_4120_0000"]
["N24029EU0_4122_0000"]
["N24029EU0_4123_0000"]
["N24029EU0_4125_0000"]
["N24029EU2_3520_0001"]
["N24031PL0_4510_0001"]
["N24031PL1_4460_4780"]
["N24031PL1_4540_0001"]
["N24031PL1_4780_0001"]
["N24031PM0_4640_4820"]
["N24031PM1_4250_4500"]
["N24031PM1_4251_4250"]
["N24031PM1_4252_4250"]
["N24031PM1_4500_4580"]
["N24031PM4_4040_4410"]
["N24031PM7_4410_4620"]
["N24031PM7_4580_4820"]
["N24031PM7_4620_4580"]
["N24031PM7_4820_0001"]
["N24031XU0_4130_4070"]
["N24031XU2_4070_4330"]
["N24031XU2_4330_4480"]
["N24033PL0_4510_0001"]
["N24033PL0_4961_0000"]
["N24033PL0_5070_0001"]
["N24033PL0_5290_0000"]
["N24033PL0_5390_0000"]
["N24033PL1_4540_0001"]
["N24033PL1_5060_0000"]
["N24033PL1_5061_0000"]
["N24033PL1_5230_0001"]
["N24033PL2_4810_0000"]
["N24033PL2_4811_0000"]
["N24033PL2_5300_5630"]
["N24033PL7_4960_0000"]
["N24033PL7_4980_0000"]
["N24033XL0_5340_0000"]
["N24033XL1_4690_0001"]
["N24033XL1_4691_0000"]
["N24033XL3_4710_0000"]
["N24033XL3_4711_0000"]
["N24033XL3_4712_0000"]
["N24033XL3_4713_0000"]
["N24033XL3_4950_0000"]
["N24033XL3_4951_0000"]
["N24033XL3_4952_0000"]
["N24033XU2_4330_4480"]
["N24033XU2_4480_4650"]
["N24033XU3_4650_0001"]
["N24035EM2_3980_0001"]
["N24035EM2_4100_0001"]
["N24035EM2_4101_0000"]
["N24035EU0_3700_0000"]
["N24035EU0_3720_0000"]
["N24035EU0_3721_0000"]
["N24035EU0_3722_0000"]
["N24035EU0_3830_0001"]
["N24035EU0_4030_0000"]
["N24035EU0_4120_0000"]
["N24035EU0_4121_0000"]
["N24035EU0_4122_0000"]
["N24035EU0_4124_0000"]
["N24035EU0_4260_0000"]
["N24035EU0_4470_0000"]
["N24035EU0_4471_0000"]
["N24035EU0_4472_0000"]
["N24035EU0_4473_0000"]
["N24035EU0_4474_0000"]
["N24035EU0_4475_0000"]
["N24035EU0_4490_0000"]
["N24035EU0_4491_0000"]
["N24035EU0_4610_0000"]
["N24035EU0_4872_0000"]
["N24035EU2_3520_0001"]
["N24037PL0_5510_0001"]
["N24037PL0_5670_0000"]
["N24037PL0_5671_0000"]
["N24037PL0_5672_0000"]
["N24037PL0_5750_0001"]
["N24037PL0_5830_0001"]
["N24037PL0_5950_0000"]
["N24037PL0_5951_0000"]
["N24037PL0_5952_0000"]
["N24037PL0_5960_0000"]
["N24037PL0_5961_0000"]
["N24037PL0_5962_0000"]
["N24037PL0_5980_0000"]
["N24037PL0_5981_0000"]
["N24037PL0_5982_0000"]
["N24037PL0_5983_0000"]
["N24037PL0_6020_0000"]
["N24037PL0_6060_0000"]
["N24037PL0_6110_0000"]
["N24037PL1_5910_0001"]
["N24037WL0_4924_0000"]
["N24037WL0_5880_0000"]
["N24037WL0_5881_0000"]
["N24037XL0_4953_0000"]
["N24037XL0_4955_0000"]
["N24037XL0_4956_0000"]
["N24037XL0_5340_0000"]
["N24037XL0_5344_0000"]
["N24037XL0_5347_0000"]
["N24037XL0_5349_0000"]
["N24039EL0_5761_0000"]
["N24039EL0_5762_0000"]
["N24039EL0_5763_0000"]
["N24039EL0_5765_0000"]
["N24039EL0_5890_0000"]
["N24039EL0_5891_0000"]
["N24039EL0_5892_0000"]
["N24039EL0_5893_0000"]
["N24039EL0_5894_0000"]
["N24039EL0_6001_0000"]
["N24039EL0_6002_0000"]
["N24039EL0_6003_0000"]
["N24039EL0_6004_0000"]
["N24039EL0_6010_0000"]
["N24039EL0_6011_0000"]
["N24039EL1_5570_0001"]
["N24039EL1_6000_0001"]
["N24039EL3_5970_0000"]
["N24039EL3_5971_0000"]
["N24039EL3_5974_0000"]
["N24041EM0_4324_0000"]
["N24041EM0_4551_0000"]
["N24041EM0_4870_0000"]
["N24041EM0_4871_0000"]
["N24041EM0_4874_0000"]
["N24041EM0_4875_0000"]
["N24041EM0_4876_0000"]
["N24041EM0_4882_0000"]
["N24041EM2_4101_0000"]
["N24041EM4_4740_0000"]
["N24041EU0_4470_0000"]
["N24041EU0_4474_0000"]
["N24041EU0_4475_0000"]
["N24041EU0_4550_0000"]
["N24041EU0_4700_0000"]
["N24041EU0_4873_0000"]
["N24043PM7_4150_4290"]
["N24043PU0_3000_3090"]
["N24043PU0_3601_3602"]
["N24043PU0_3611_3530"]
["N24043PU0_3751_3752"]
["N24043PU1_3030_3440"]
["N24043PU1_3100_3690"]
["N24043PU2_2840_3080"]
["N24043PU2_3080_3640"]
["N24043PU2_3090_4050"]
["N24043PU2_4050_4180"]
["N24043PU3_2510_3290"]
["N24043PU3_3290_3390"]
["N24043PU3_3390_3730"]
["N24043PU6_3440_3590"]
["N24043PU6_3530_3440"]
["N24043PU6_3590_3640"]
["N24043PU6_3600_3602"]
["N24043PU6_3602_3730"]
["N24043PU6_3610_3530"]
["N24043PU6_3640_3600"]
["N24043PU6_3690_3610"]
["N24043PU6_3730_3750"]
["N24043PU6_3750_3752"]
["N24043PU6_3752_4080"]
["N24043PU6_4080_4180"]
["N24043PU6_4180_4150"]
["N24045EL0_4593_0000"]
["N24045EL0_4594_0000"]
["N24045EL0_4595_0000"]
["N24045EL0_4596_0000"]
["N24045EL0_4597_0000"]
["N24045EL0_4598_0000"]
["N24045EL0_4633_0000"]
["N24045EL0_5040_0000"]
["N24045EL0_5400_0001"]
["N24045EL0_5760_0000"]
["N24045EL0_5761_0000"]
["N24045EL0_5762_0000"]
["N24045EL0_5764_0000"]
["N24045EL0_5767_0001"]
["N24045EL1_5430_0001"]
["N24045EL1_5570_0001"]
["N24045EL2_4630_0000"]
["N24045EL2_4634_0000"]
["N24045EL2_5110_5270"]
["N24045EL2_5270_0001"]
["N24045EL2_5272_5270"]
["N24047EL0_5271_0000"]
["N24047EL1_5430_0001"]
["N24047EL1_5570_0001"]
["N24047EL1_5660_0000"]
["N24047EL2_5110_5270"]
["N24047EL2_5270_0001"]
["N24047EL3_5870_0000"]
["N24047EL3_5970_0000"]
["N24047EL3_5971_0000"]
["N24047EL3_5972_0000"]
["N24510WM0_3650_0001"]
["N24510WM0_3740_0001"]
["N24510WM0_3741_0000"]
["N24510WM0_3960_0000"]
["N24510WM0_3961_0000"]
["N24510WM0_3962_0000"]
["N24510WM0_3964_0000"]
["N24510WM1_3910_0001"]
["N24510WM3_4060_0001"]

{"sheet":"Protocol 1","index":3,"n_rows":24,"n_cols":18,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,9],[18,3,18,4],[18,5,18,6],[18,7,18,8],[19,3,19,4],[19,5,19,6],[19,7,19,8],[17,7,17,8],[14,3,14,4],[14,5,14,6],[14,7,14,8],[15,3,15,4],[15,5,15,6],[15,7,15,8],[16,3,16,4],[16,5,16,6],[23,3,23,4],[23,5,23,6],[23,7,23,8],[20,3,20,4],[20,5,20,6],[20,7,20,8],[21,3,21,4],[21,5,21,6],[21,7,21,8],[22,3,22,4],[22,5,22,6],[22,7,22,8],[16,7,16,8],[17,3,17,4],[17,5,17,6],[13,3,13,4],[13,5,13,6],[13,7,13,8],[11,3,11,4],[12,1,12,2],[11,5,11,6],[10,3,10,4],[10,5,10,6],[11,7,11,8],[12,3,12,4],[12,5,12,6],[12,7,12,8],[23,1,23,2],[22,1,22,2],[21,1,21,2],[20,1,20,2],[19,1,19,2],[18,1,18,2],[17,1,17,2],[16,1,16,2],[15,1,15,2],[14,1,14,2],[13,1,13,2],[11,1,11,2],[4,0,4,1],[4,2,4,3],[7,3,7,4],[7,5,7,6],[7,7,7,8],[7,0,8,0],[8,1,8,2],[8,7,8,8],[8,5,8,6],[8,3,8,4],[16,12,16,14],[4,11,4,14],[4,15,4,16],[9,11,9,13],[9,14,9,15],[10,14,10,15],[11,11,11,13],[11,14,11,15],[13,12,13,14],[14,12,14,14],[15,12,15,14],[10,11,10,13],[10,7,10,8],[5,0,5,1],[5,2,5,3],[7,1,7,2],[9,5,9,6],[9,7,9,8],[9,1,9,2],[9,3,9,4],[10,1,10,2]]}
["Protocol 1: Prevented Sediment"]
["Please populate the blue cells in this sheet with applicable project data. "]
["Step 1",null,null,null,null,null,null,null,null,null,null,"Step 2"]
["Estimate shoreline sediment erosion rate using either MD DNR's Coastal Atlas website or monitoring data.",null,null,null,null,null,null,null,null,null,null,"Estimate shoreline restoration efficiency - Justify efficiency or assume 100%"]
["Soil Bulk Density",null,93.6,null,"lb/ft3","Note: 93.6 lb/ft3 is the recommended default value",null,null,null,null,null,"Shoreline Restoration Efficiency",null,null,null,100,null,"%"]
["Total Sediment",null,{"$f":"SUM(H:H)","v":0},null,"lb/yr"]
[null,null,null,null,null,null,null,null,null,null,null,"Step 3"]
["Reach","Length",null,"Erosion Rate",null,"Bank Height",null,"Sediment Volume",null,null,null,"Adjust prevented sediment load to eliminate coarse grained sand and consider bank instability."]
[null,"ft",null,"ft/yr",null,"ft",null,"lb/yr",null,null,null,"Note: Projects at risk for failure require at least 50% bank instability reduction. Provide applicable monitoring data as needed."]
[1,null,null,null,null,null,null,{"$f":"B10*D10*F10*$C$5","v":0},null,null,null,"MD Sand Reduction Factor",null,null,0.55100000000000005]
[{"$f":"A10+1","v":2},null,null,null,null,null,null,{"$f":"B11*D11*F11*$C$5","v":0},null,null,null,"Bank Instability  ",null,null,"Yes"]
[{"$f":"A11+1","v":3},null,null,null,null,null,null,{"$f":"B12*D12*F12*$C$5","v":0},null,null,null,"Bank Instability Reduction ",null,null,50,null,"%"]
[4,null,null,null,null,null,null,0]
[5,null,null,null,null,null,null,0,null,null,null,"Pollutant","Load Reduction, lbs/yr"]
[6,null,null,null,null,null,null,0,null,null,null,"TN",{"$f":"C6*(P5/100)*(IF(O11=\"Yes\",(O12/100),IF(O11=\"No\",1)))*0.00029","v":0}]
[7,null,null,null,null,null,null,0,null,null,null,"TP",{"$f":"C6*(P5/100)*(IF(O11=\"Yes\",(O12/100),IF(O11=\"No\",1)))*0.000205","v":0}]
[8,null,null,null,null,null,null,0,null,null,null,"TSS",{"$f":"C6*(P5/100)*O10*(IF(O11=\"Yes\",(O12/100),IF(O11=\"No\",1)))","v":0}]
[9,null,null,null,null,null,null,0]
[10,null,null,null,null,null,null,0]
[11,null,null,null,null,null,null,0]
[12,null,null,null,null,null,null,0]
[13,null,null,null,null,null,null,0]
[14,null,null,null,null,null,null,0]
[15,null,null,null,null,null,null,0]

{"sheet":"Protocol 2","index":4,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,9],[9,0,9,2],[9,3,9,4],[4,0,4,2],[4,3,4,4],[8,3,8,4],[8,0,8,2]]}
["Protocol 2: Denitrification"]
["Please populate the blue cells in this sheet with applicable project data. "]
["Step 1"]
["Determine the total post-construction area of the net increase in marsh plantings and convert to acres. "]
["Post-Construction Area",null,null,null,null,"acres"]
[]
["Step 2"]
["Multiply the acres of marsh planting by the unit denittrification rate."]
["Unit Denitrification Rate",null,null,85,null,"lbs TN/acre/yr"]
["TN Load Reduction",null,null,{"$f":"D9*D5","v":0},null,"lbs/yr"]

{"sheet":"Protocol 3","index":5,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,10],[12,0,12,10],[14,0,14,2],[14,3,14,4],[9,0,9,2],[9,3,9,4],[13,0,13,2],[13,3,13,4],[8,0,8,2],[8,3,8,4],[3,0,3,9],[4,0,4,2],[4,3,4,4]]}
["Protocol 3: Sedimentation"]
["Please populate the blue cells in this sheet with applicable project data. "]
["Step 1"]
["Determine the total post-construction area of the net increase in marsh plantings and convert to acres."]
["Post-Construction Area",null,null,null,null,"acres"]
[]
["Step 2"]
["Multiply the acres of marsh planting by the unit sedimentation value."]
["Unit Sedimentation Value",null,null,6959,null,"lbs TSS/acre/yr"]
["TSS Load Reduction",null,null,{"$f":"D9*D5","v":0},null,"lbs/yr"]
[]
["Step 3"]
["For total phosphorus load removed multiply the acres of marsh planting by the sedimentation phosphorus load reduction."]
["Sedimentation P Load Reduction",null,null,5.2889999999999997,null,"lbs TP/acre/yr"]
["TP Load Reduction",null,null,{"$f":"D14*D5","v":0},null,"lbs/yr"]

{"sheet":"Protocol 4","index":6,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,9],[3,0,3,9],[4,0,4,2],[4,3,4,4],[12,0,12,2],[14,1,14,2],[13,1,13,2],[7,0,7,9],[10,1,10,2],[9,1,9,2],[8,0,8,2]]}
["Protocol 4: Marsh Redfield Ratio"]
["Please populate the blue cells in this sheet with applicable project data. "]
["Step 1"]
["Determine the total post-construction area of the net increase in marsh plantings and convert to acres."]
["Post-Construction Area",null,null,null,null,"acres"]
[]
["Step 2"]
["Multiply the acres of tidal marsh planting by the unit Marsh Redfield ratio value."]
["Marsh Redfield Ratio"]
["TN",6.83,null,"lbs/acre/yr"]
["TP",0.3,null,"lbs/acre/yr"]
[]
["Load Reduction"]
["TN",{"$f":"D5*B10","v":0},null,"lbs/yr"]
["TP",{"$f":"B11*D5","v":0},null,"lbs/yr"]