HomeMy WebLinkAbout8807.TSS Calcs(5.30.23)INSTRUCTIONS:Non-automated: Mar. 4, 20081. Sheet is nonautomated. Print sheet and complete using hand calculations. Column A and B: See MassDEP Structural BMP Table2. The calculations must be completed using the Column Headings specified in Chart and Not the Excel Column Headings3. To complete Chart Column D, multiple Column B value within Row x Column C value within Row4. To complete Chart Column E value, subtract Column D value within Row from Column C within Row5. Total TSS Removal = Sum All Values in Column DLocation: A B C D ETSS Removal Starting TSS Amount RemainingBMP1Rate1Load* Removed (B*C) Load (C-D)1.00Total TSS Removal =Separate Form Needs to be Completed for Each Outlet or BMP TrainProject:Prepared By:*Equals remaining load from previous BMP (E)Date:which enters the BMPTSS Removal Calculation WorksheetNon-automated TSS Calculation Sheet must be used if Proprietary BMP Proposed1. From MassDEP Stormwater Handbook Vol. 1Mass. Dept. of Environmental ProtectionM1 - Runoff to Catch Basin (6,286 SF of Imperv.)Deep Sump and Hooded Catch Basin0.250.250.75Proprietary Device - CDS 2015-4 0.9540.7150.0350.7596.5%RFRDavenport Subdiv.5/30/2023Pre-Treatment
INSTRUCTIONS:Non-automated: Mar. 4, 20081. Sheet is nonautomated. Print sheet and complete using hand calculations. Column A and B: See MassDEP Structural BMP Table2. The calculations must be completed using the Column Headings specified in Chart and Not the Excel Column Headings3. To complete Chart Column D, multiple Column B value within Row x Column C value within Row4. To complete Chart Column E value, subtract Column D value within Row from Column C within Row5. Total TSS Removal = Sum All Values in Column DLocation: A B C D ETSS Removal Starting TSS Amount RemainingBMP1Rate1Load* Removed (B*C) Load (C-D)1.00Total TSS Removal =Separate Form Needs to be Completed for Each Outlet or BMP TrainProject:Prepared By:*Equals remaining load from previous BMP (E)Date:which enters the BMPTSS Removal Calculation WorksheetNon-automated TSS Calculation Sheet must be used if Proprietary BMP Proposed1. From MassDEP Stormwater Handbook Vol. 1Mass. Dept. of Environmental ProtectionDeep Sump and Hooded Catch Basin0.250.250.75Proprietary Device - CDS 2015-4 0.9540.7150.0350.7599.7%RFRDavenport Subdiv.5/30/2023Water Quality Swale - Dry0.700.0350.0240.0110.80Subsurface Infiltration Structure0.0110.0080.003M1 - Runoff to Catch Basin (6,286 SF of Imperv.)Treatment
INSTRUCTIONS:Non-automated: Mar. 4, 20081. Sheet is nonautomated. Print sheet and complete using hand calculations. Column A and B: See MassDEP Structural BMP Table2. The calculations must be completed using the Column Headings specified in Chart and Not the Excel Column Headings3. To complete Chart Column D, multiple Column B value within Row x Column C value within Row4. To complete Chart Column E value, subtract Column D value within Row from Column C within Row5. Total TSS Removal = Sum All Values in Column DLocation: A B C D ETSS Removal Starting TSS Amount RemainingBMP1Rate1Load* Removed (B*C) Load (C-D)1.00Total TSS Removal =Separate Form Needs to be Completed for Each Outlet or BMP TrainProject:Prepared By:*Equals remaining load from previous BMP (E)Date:which enters the BMPTSS Removal Calculation WorksheetNon-automated TSS Calculation Sheet must be used if Proprietary BMP Proposed1. From MassDEP Stormwater Handbook Vol. 1Mass. Dept. of Environmental ProtectionM1 - Overland - No Imperv. AreaN/ARFRDavenport Subdiv.5/30/2023
INSTRUCTIONS:Non-automated: Mar. 4, 20081. Sheet is nonautomated. Print sheet and complete using hand calculations. Column A and B: See MassDEP Structural BMP Table2. The calculations must be completed using the Column Headings specified in Chart and Not the Excel Column Headings3. To complete Chart Column D, multiple Column B value within Row x Column C value within Row4. To complete Chart Column E value, subtract Column D value within Row from Column C within Row5. Total TSS Removal = Sum All Values in Column DLocation: A B C D ETSS Removal Starting TSS Amount RemainingBMP1Rate1Load* Removed (B*C) Load (C-D)1.00Total TSS Removal =Separate Form Needs to be Completed for Each Outlet or BMP TrainProject:Prepared By:*Equals remaining load from previous BMP (E)Date:which enters the BMPTSS Removal Calculation WorksheetNon-automated TSS Calculation Sheet must be used if Proprietary BMP Proposed1. From MassDEP Stormwater Handbook Vol. 1Mass. Dept. of Environmental ProtectionDeep Sump and Hooded Catch Basin0.250.250.75Proprietary Device - CDS 2015-4 0.8640.6480.1020.7589.8%RFRDavenport Subdiv.5/30/2023M2 - Runoff to Catch Basin (33,633 SF of Imperv.)Pre-Treatment
INSTRUCTIONS:Non-automated: Mar. 4, 20081. Sheet is nonautomated. Print sheet and complete using hand calculations. Column A and B: See MassDEP Structural BMP Table2. The calculations must be completed using the Column Headings specified in Chart and Not the Excel Column Headings3. To complete Chart Column D, multiple Column B value within Row x Column C value within Row4. To complete Chart Column E value, subtract Column D value within Row from Column C within Row5. Total TSS Removal = Sum All Values in Column DLocation: A B C D ETSS Removal Starting TSS Amount RemainingBMP1Rate1Load* Removed (B*C) Load (C-D)1.00Total TSS Removal =Separate Form Needs to be Completed for Each Outlet or BMP TrainProject:Prepared By:*Equals remaining load from previous BMP (E)Date:which enters the BMPTSS Removal Calculation WorksheetNon-automated TSS Calculation Sheet must be used if Proprietary BMP Proposed1. From MassDEP Stormwater Handbook Vol. 1Mass. Dept. of Environmental ProtectionDeep Sump and Hooded Catch Basin0.250.250.75Proprietary Device - CDS 2015-4 0.8640.6480.1020.7599.3%RFRDavenport Subdiv.5/30/2023Water Quality Swale - Dry0.700.1020.0710.0310.80Subsurface Infiltration Structure0.0310.0240.007M2 - Runoff to Catch Basin (33,633 SF of Imperv.)Treatment
INSTRUCTIONS:Non-automated: Mar. 4, 20081. Sheet is nonautomated. Print sheet and complete using hand calculations. Column A and B: See MassDEP Structural BMP Table2. The calculations must be completed using the Column Headings specified in Chart and Not the Excel Column Headings3. To complete Chart Column D, multiple Column B value within Row x Column C value within Row4. To complete Chart Column E value, subtract Column D value within Row from Column C within Row5. Total TSS Removal = Sum All Values in Column DLocation: A B C D ETSS Removal Starting TSS Amount RemainingBMP1Rate1Load* Removed (B*C) Load (C-D)1.00Total TSS Removal =Separate Form Needs to be Completed for Each Outlet or BMP TrainProject:Prepared By:*Equals remaining load from previous BMP (E)Date:which enters the BMPTSS Removal Calculation WorksheetNon-automated TSS Calculation Sheet must be used if Proprietary BMP Proposed1. From MassDEP Stormwater Handbook Vol. 1Mass. Dept. of Environmental ProtectionM2 - Overland >50' from Swale (4,089 SF of Imperv.)Vegetated Filter Strip >50 feet 0.450.450.5545%RFRDavenport Subdiv.5/30/2023Pre-Treatment
INSTRUCTIONS:Non-automated: Mar. 4, 20081. Sheet is nonautomated. Print sheet and complete using hand calculations. Column A and B: See MassDEP Structural BMP Table2. The calculations must be completed using the Column Headings specified in Chart and Not the Excel Column Headings3. To complete Chart Column D, multiple Column B value within Row x Column C value within Row4. To complete Chart Column E value, subtract Column D value within Row from Column C within Row5. Total TSS Removal = Sum All Values in Column DLocation: A B C D ETSS Removal Starting TSS Amount RemainingBMP1Rate1Load* Removed (B*C) Load (C-D)1.00Total TSS Removal =Separate Form Needs to be Completed for Each Outlet or BMP TrainProject:Prepared By:*Equals remaining load from previous BMP (E)Date:which enters the BMPTSS Removal Calculation WorksheetNon-automated TSS Calculation Sheet must be used if Proprietary BMP Proposed1. From MassDEP Stormwater Handbook Vol. 1Mass. Dept. of Environmental ProtectionM2 - Overland >50' from Swale (4,089 SF of Imperv.)Vegetated Filter Strip >50 feet 0.450.450.5596.7%RFRDavenport Subdiv.5/30/2023TreatmentWater Quality Swale - DrySubsurface Infiltration Structure0.700.800.1650.550.3850.1320.1650.033
INSTRUCTIONS:Non-automated: Mar. 4, 20081. Sheet is nonautomated. Print sheet and complete using hand calculations. Column A and B: See MassDEP Structural BMP Table2. The calculations must be completed using the Column Headings specified in Chart and Not the Excel Column Headings3. To complete Chart Column D, multiple Column B value within Row x Column C value within Row4. To complete Chart Column E value, subtract Column D value within Row from Column C within Row5. Total TSS Removal = Sum All Values in Column DLocation: A B C D ETSS Removal Starting TSS Amount RemainingBMP1Rate1Load* Removed (B*C) Load (C-D)1.00Total TSS Removal =Separate Form Needs to be Completed for Each Outlet or BMP TrainProject:Prepared By:*Equals remaining load from previous BMP (E)Date:which enters the BMPTSS Removal Calculation WorksheetNon-automated TSS Calculation Sheet must be used if Proprietary BMP Proposed1. From MassDEP Stormwater Handbook Vol. 1Mass. Dept. of Environmental ProtectionS1 - No Vegetated Filter Strip (<25' from Swale) (1,988 SF of Imperv.)No Pre-Treatment or Treatment Provided0.000.001.000%RFRDavenport Subdiv.5/30/2023
INSTRUCTIONS:Non-automated: Mar. 4, 20081. Sheet is nonautomated. Print sheet and complete using hand calculations. Column A and B: See MassDEP Structural BMP Table2. The calculations must be completed using the Column Headings specified in Chart and Not the Excel Column Headings3. To complete Chart Column D, multiple Column B value within Row x Column C value within Row4. To complete Chart Column E value, subtract Column D value within Row from Column C within Row5. Total TSS Removal = Sum All Values in Column DLocation: A B C D ETSS Removal Starting TSS Amount RemainingBMP1Rate1Load* Removed (B*C) Load (C-D)1.00Total TSS Removal =Separate Form Needs to be Completed for Each Outlet or BMP TrainProject:Prepared By:*Equals remaining load from previous BMP (E)Date:which enters the BMPTSS Removal Calculation WorksheetNon-automated TSS Calculation Sheet must be used if Proprietary BMP Proposed1. From MassDEP Stormwater Handbook Vol. 1Mass. Dept. of Environmental ProtectionS1 - 25' to 50' from Swale (584 SF of Imperv.)Vegetated Filter Strip >25 feet 0.100.100.9010%RFRDavenport Subdiv.5/30/2023Pre-Treatment
INSTRUCTIONS:Non-automated: Mar. 4, 20081. Sheet is nonautomated. Print sheet and complete using hand calculations. Column A and B: See MassDEP Structural BMP Table2. The calculations must be completed using the Column Headings specified in Chart and Not the Excel Column Headings3. To complete Chart Column D, multiple Column B value within Row x Column C value within Row4. To complete Chart Column E value, subtract Column D value within Row from Column C within Row5. Total TSS Removal = Sum All Values in Column DLocation: A B C D ETSS Removal Starting TSS Amount RemainingBMP1Rate1Load* Removed (B*C) Load (C-D)1.00Total TSS Removal =Separate Form Needs to be Completed for Each Outlet or BMP TrainProject:Prepared By:*Equals remaining load from previous BMP (E)Date:which enters the BMPTSS Removal Calculation WorksheetNon-automated TSS Calculation Sheet must be used if Proprietary BMP Proposed1. From MassDEP Stormwater Handbook Vol. 1Mass. Dept. of Environmental ProtectionS1 - 25' to 50' from Swale (584 SF of Imperv.)Vegetated Filter Strip >25 feet 0.100.100.9073%RFRDavenport Subdiv.5/30/2023TreatmentWater Quality Swale - Dry0.700.900.630.27
INSTRUCTIONS:Non-automated: Mar. 4, 20081. Sheet is nonautomated. Print sheet and complete using hand calculations. Column A and B: See MassDEP Structural BMP Table2. The calculations must be completed using the Column Headings specified in Chart and Not the Excel Column Headings3. To complete Chart Column D, multiple Column B value within Row x Column C value within Row4. To complete Chart Column E value, subtract Column D value within Row from Column C within Row5. Total TSS Removal = Sum All Values in Column DLocation: A B C D ETSS Removal Starting TSS Amount RemainingBMP1Rate1Load* Removed (B*C) Load (C-D)1.00Total TSS Removal =Separate Form Needs to be Completed for Each Outlet or BMP TrainProject:Prepared By:*Equals remaining load from previous BMP (E)Date:which enters the BMPTSS Removal Calculation WorksheetNon-automated TSS Calculation Sheet must be used if Proprietary BMP Proposed1. From MassDEP Stormwater Handbook Vol. 1Mass. Dept. of Environmental ProtectionS1 - >50' from Swale (3,425 SF of Imperv.)Vegetated Filter Strip >50 feet 0.450.450.5545%RFRDavenport Subdiv.5/30/2023Pre-Treatment
INSTRUCTIONS:Non-automated: Mar. 4, 20081. Sheet is nonautomated. Print sheet and complete using hand calculations. Column A and B: See MassDEP Structural BMP Table2. The calculations must be completed using the Column Headings specified in Chart and Not the Excel Column Headings3. To complete Chart Column D, multiple Column B value within Row x Column C value within Row4. To complete Chart Column E value, subtract Column D value within Row from Column C within Row5. Total TSS Removal = Sum All Values in Column DLocation: A B C D ETSS Removal Starting TSS Amount RemainingBMP1Rate1Load* Removed (B*C) Load (C-D)1.00Total TSS Removal =Separate Form Needs to be Completed for Each Outlet or BMP TrainProject:Prepared By:*Equals remaining load from previous BMP (E)Date:which enters the BMPTSS Removal Calculation WorksheetNon-automated TSS Calculation Sheet must be used if Proprietary BMP Proposed1. From MassDEP Stormwater Handbook Vol. 1Mass. Dept. of Environmental ProtectionS1 - >50' from Swale (3,425 SF of Imperv.)Vegetated Filter Strip >50 feet 0.450.450.5583.5%RFRDavenport Subdiv.5/30/2023TreatmentWater Quality Swale - Dry0.700.550.3850.165
INSTRUCTIONS:Non-automated: Mar. 4, 20081. Sheet is nonautomated. Print sheet and complete using hand calculations. Column A and B: See MassDEP Structural BMP Table2. The calculations must be completed using the Column Headings specified in Chart and Not the Excel Column Headings3. To complete Chart Column D, multiple Column B value within Row x Column C value within Row4. To complete Chart Column E value, subtract Column D value within Row from Column C within Row5. Total TSS Removal = Sum All Values in Column DLocation: A B C D ETSS Removal Starting TSS Amount RemainingBMP1Rate1Load* Removed (B*C) Load (C-D)1.00Total TSS Removal =Separate Form Needs to be Completed for Each Outlet or BMP TrainProject:Prepared By:*Equals remaining load from previous BMP (E)Date:which enters the BMPTSS Removal Calculation WorksheetNon-automated TSS Calculation Sheet must be used if Proprietary BMP Proposed1. From MassDEP Stormwater Handbook Vol. 1Mass. Dept. of Environmental ProtectionS2 - No Imperv. AreaN/ARFRDavenport Subdiv.5/30/2023
INSTRUCTIONS:Non-automated: Mar. 4, 20081. Sheet is nonautomated. Print sheet and complete using hand calculations. Column A and B: See MassDEP Structural BMP Table2. The calculations must be completed using the Column Headings specified in Chart and Not the Excel Column Headings3. To complete Chart Column D, multiple Column B value within Row x Column C value within Row4. To complete Chart Column E value, subtract Column D value within Row from Column C within Row5. Total TSS Removal = Sum All Values in Column DLocation: A B C D ETSS Removal Starting TSS Amount RemainingBMP1Rate1Load* Removed (B*C) Load (C-D)1.00Total TSS Removal =Separate Form Needs to be Completed for Each Outlet or BMP TrainProject:Prepared By:*Equals remaining load from previous BMP (E)Date:which enters the BMPTSS Removal Calculation WorksheetNon-automated TSS Calculation Sheet must be used if Proprietary BMP Proposed1. From MassDEP Stormwater Handbook Vol. 1Mass. Dept. of Environmental ProtectionS3 - >50' from Swale (2,900 SF of Imperv.)Vegetated Filter Strip >50 feet 0.450.450.5545%RFRDavenport Subdiv.5/30/2023Pre-Treatment
INSTRUCTIONS:Non-automated: Mar. 4, 20081. Sheet is nonautomated. Print sheet and complete using hand calculations. Column A and B: See MassDEP Structural BMP Table2. The calculations must be completed using the Column Headings specified in Chart and Not the Excel Column Headings3. To complete Chart Column D, multiple Column B value within Row x Column C value within Row4. To complete Chart Column E value, subtract Column D value within Row from Column C within Row5. Total TSS Removal = Sum All Values in Column DLocation: A B C D ETSS Removal Starting TSS Amount RemainingBMP1Rate1Load* Removed (B*C) Load (C-D)1.00Total TSS Removal =Separate Form Needs to be Completed for Each Outlet or BMP TrainProject:Prepared By:*Equals remaining load from previous BMP (E)Date:which enters the BMPTSS Removal Calculation WorksheetNon-automated TSS Calculation Sheet must be used if Proprietary BMP Proposed1. From MassDEP Stormwater Handbook Vol. 1Mass. Dept. of Environmental ProtectionVegetated Filter Strip >50 feet 0.450.450.5583.5%RFRDavenport Subdiv.5/30/2023TreatmentWater Quality Swale - Dry0.700.550.3850.165S3 - >50' from Swale (2,900 SF of Imperv.)
INSTRUCTIONS:Non-automated: Mar. 4, 20081. Sheet is nonautomated. Print sheet and complete using hand calculations. Column A and B: See MassDEP Structural BMP Table2. The calculations must be completed using the Column Headings specified in Chart and Not the Excel Column Headings3. To complete Chart Column D, multiple Column B value within Row x Column C value within Row4. To complete Chart Column E value, subtract Column D value within Row from Column C within Row5. Total TSS Removal = Sum All Values in Column DLocation: A B C D ETSS Removal Starting TSS Amount RemainingBMP1Rate1Load* Removed (B*C) Load (C-D)1.00Total TSS Removal =Separate Form Needs to be Completed for Each Outlet or BMP TrainProject:Prepared By:*Equals remaining load from previous BMP (E)Date:which enters the BMPTSS Removal Calculation WorksheetNon-automated TSS Calculation Sheet must be used if Proprietary BMP Proposed1. From MassDEP Stormwater Handbook Vol. 1Mass. Dept. of Environmental ProtectionS4 - No Vegetated Filter Strip (<25' from Swale) (791 SF of Imperv.)No Pre-Treatment or Treatment Provided0.000.001.000%RFRDavenport Subdiv.5/30/2023
INSTRUCTIONS:Non-automated: Mar. 4, 20081. Sheet is nonautomated. Print sheet and complete using hand calculations. Column A and B: See MassDEP Structural BMP Table2. The calculations must be completed using the Column Headings specified in Chart and Not the Excel Column Headings3. To complete Chart Column D, multiple Column B value within Row x Column C value within Row4. To complete Chart Column E value, subtract Column D value within Row from Column C within Row5. Total TSS Removal = Sum All Values in Column DLocation: A B C D ETSS Removal Starting TSS Amount RemainingBMP1Rate1Load* Removed (B*C) Load (C-D)1.00Total TSS Removal =Separate Form Needs to be Completed for Each Outlet or BMP TrainProject:Prepared By:*Equals remaining load from previous BMP (E)Date:which enters the BMPTSS Removal Calculation WorksheetNon-automated TSS Calculation Sheet must be used if Proprietary BMP Proposed1. From MassDEP Stormwater Handbook Vol. 1Mass. Dept. of Environmental ProtectionS5 - >50' from Swale (1,359 SF of Imperv.)Vegetated Filter Strip >50 feet 0.450.450.5545%RFRDavenport Subdiv.5/30/2023Pre-Treatment
INSTRUCTIONS:Non-automated: Mar. 4, 20081. Sheet is nonautomated. Print sheet and complete using hand calculations. Column A and B: See MassDEP Structural BMP Table2. The calculations must be completed using the Column Headings specified in Chart and Not the Excel Column Headings3. To complete Chart Column D, multiple Column B value within Row x Column C value within Row4. To complete Chart Column E value, subtract Column D value within Row from Column C within Row5. Total TSS Removal = Sum All Values in Column DLocation: A B C D ETSS Removal Starting TSS Amount RemainingBMP1Rate1Load* Removed (B*C) Load (C-D)1.00Total TSS Removal =Separate Form Needs to be Completed for Each Outlet or BMP TrainProject:Prepared By:*Equals remaining load from previous BMP (E)Date:which enters the BMPTSS Removal Calculation WorksheetNon-automated TSS Calculation Sheet must be used if Proprietary BMP Proposed1. From MassDEP Stormwater Handbook Vol. 1Mass. Dept. of Environmental ProtectionVegetated Filter Strip >50 feet 0.450.450.5583.5%RFRDavenport Subdiv.5/30/2023TreatmentWater Quality Swale - Dry0.700.550.3850.165S5 - >50' from Swale (1,359 SF of Imperv.)
INSTRUCTIONS:Non-automated: Mar. 4, 20081. Sheet is nonautomated. Print sheet and complete using hand calculations. Column A and B: See MassDEP Structural BMP Table2. The calculations must be completed using the Column Headings specified in Chart and Not the Excel Column Headings3. To complete Chart Column D, multiple Column B value within Row x Column C value within Row4. To complete Chart Column E value, subtract Column D value within Row from Column C within Row5. Total TSS Removal = Sum All Values in Column DLocation: A B C D ETSS Removal Starting TSS Amount RemainingBMP1Rate1Load* Removed (B*C) Load (C-D)1.00Total TSS Removal =Separate Form Needs to be Completed for Each Outlet or BMP TrainProject:Prepared By:*Equals remaining load from previous BMP (E)Date:which enters the BMPTSS Removal Calculation WorksheetNon-automated TSS Calculation Sheet must be used if Proprietary BMP Proposed1. From MassDEP Stormwater Handbook Vol. 1Mass. Dept. of Environmental ProtectionS6 - Non-Recharge Areas (611 SF of Imperv.)No Pre-Treatment or Treatment Provided0.000.001.000%RFRDavenport Subdiv.5/30/2023
INSTRUCTIONS:Non-automated: Mar. 4, 20081. Sheet is nonautomated. Print sheet and complete using hand calculations. Column A and B: See MassDEP Structural BMP Table2. The calculations must be completed using the Column Headings specified in Chart and Not the Excel Column Headings3. To complete Chart Column D, multiple Column B value within Row x Column C value within Row4. To complete Chart Column E value, subtract Column D value within Row from Column C within Row5. Total TSS Removal = Sum All Values in Column DLocation: A B C D ETSS Removal Starting TSS Amount RemainingBMP1Rate1Load* Removed (B*C) Load (C-D)1.00Total TSS Removal =Separate Form Needs to be Completed for Each Outlet or BMP TrainProject:Prepared By:*Equals remaining load from previous BMP (E)Date:which enters the BMPTSS Removal Calculation WorksheetNon-automated TSS Calculation Sheet must be used if Proprietary BMP Proposed1. From MassDEP Stormwater Handbook Vol. 1Mass. Dept. of Environmental ProtectionSubsurface Infiltration Structure0.800.800.2080%RFRDavenport Subdiv.5/30/2023Roof Runoff