{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["SCM 3.3.2","Versions","Ref"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":8,"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":"SCM 3.3.2","index":0,"n_rows":36,"n_cols":38,"rows_kept":36,"cut":false,"hidden":false,"merged":[[28,22,28,25],[29,22,29,25],[28,2,28,21],[30,22,30,25],[32,1,32,25],[35,4,35,11],[35,14,35,17],[35,18,35,25],[29,2,29,21],[30,2,30,21],[33,1,33,25],[2,1,2,25],[14,0,14,25],[15,2,15,4],[15,5,15,25],[0,0,0,25],[7,2,7,9],[7,23,7,24],[7,15,7,22],[7,13,7,14],[1,1,1,25],[7,10,7,11],[3,6,3,25],[26,6,26,7],[13,18,13,24],[18,32,18,34],[18,35,18,37],[5,2,5,4],[5,5,5,6],[19,2,19,15],[19,16,19,18],[19,19,19,21],[19,22,19,25],[20,19,20,21],[20,22,20,25],[20,16,20,18],[20,2,20,15],[17,2,17,25],[22,2,22,25]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,false,"Rows","T_F","Protect"]
[null,"SCM 3.3.2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,1,true,"Deed Restriction"]
[null,"Preserved Natural Open Spaces",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,2,false,"Conservation Easement"]
[null,null,"Project Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,3,null,"Other"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,4,false]
[null,null,"SCM ID:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P6<>\"\",IF(OR(P6=\"Riparian Forest Buffer Not Meeting § 102.14(b)\",P6=\"Other Forested Area\"),1,2),\"\")","v":""},false,5,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,"2-year/24-hour Precipitation Depth:",null,null,null,null,null,null,null,null,null,"in",null,null,"Project Site Area:",null,null,null,null,null,null,null,null,null,"ac",null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,"Are color photographs of the Preserved Natural Open Space attached?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes",null,null,"No"]
[]
[null,null,"Attach color photographs of the Preserved Natural Open Space."]
[]
[null,null,"How will the Preserved Natural Open Space be protected long-term?"]
[]
[null,null,"Description:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(I16<>\"\",I16<>\"Off-Site\"),\"Y\",\"\")","v":""}]
[]
[null,null,"Post-Construction Land Cover"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pollutant Conc. (mg/L)",null,null,"Pollutant Loads (lbs)"]
[null,null,"Predominant Preserved Natural Open Space Cover Type",null,null,null,null,null,null,null,null,null,null,null,null,null,"Area (ac)",null,null,"HSG",null,null,"Runoff, 2-Yr/24-Hr (CF)",null,null,null,null,"CN","Ia","Q","Volume","Soil Group","TSS","TP","TN","TSS","TP","TN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AE21<>\"\",AE21,\"\")","v":""},null,null,null,{"$f":"IF(AND(AA6<>\"\",Q21<>\"\"),IF(AA6=1,Q21*43560*(1.5/12)*(1-IF(#REF!<>\"\",#REF!,0)),IF(AA6=2,Q21*43560*(0.75/12)*(1-IF(#REF!<>\"\",#REF!,0)))),\"\")","v":""},{"$f":"IF(AND(C21<>\"\",Q21<>\"\",T21<>\"\"),IF(ISNA(VLOOKUP(C21,Ref!$A$1:$H$50,AF21,FALSE))=TRUE,\"\",VLOOKUP(C21,Ref!$A$1:$H$50,AF21,FALSE)),\"\")","v":""},{"$f":"IF(AB21<>\"\",0.2*((1000/AB21)-10),\"\")","v":""},{"$f":"IF(AND(AC21<>\"\",$K$8<>\"\"),IF($K$8-AC21>0,(($K$8-AC21)^2)/($K$8+0.8*((1000/AB21)-10)),0),\"\")","v":""},{"$f":"IF(AD21<>\"\",Q21*43560*(AD21/12),\"\")","v":""},{"$f":"IF(T21<>\"\",IF(T21=\"A\",2,IF(T21=\"B\",3,IF(T21=\"C\",4,IF(T21=\"D\",5,)))),\"\")","v":""},{"$f":"IF(C21<>\"\",IF(ISNA(VLOOKUP(C21,Ref!$A$1:$H$50,6,FALSE))=TRUE,\"\",VLOOKUP(C21,Ref!$A$1:$H$50,6,FALSE)),\"\")","v":""},{"$f":"IF(C21<>\"\",IF(ISNA(VLOOKUP(C21,Ref!$A$1:$H$50,7,FALSE))=TRUE,\"\",VLOOKUP(C21,Ref!$A$1:$H$50,7,FALSE)),\"\")","v":""},{"$f":"IF(C21<>\"\",IF(ISNA(VLOOKUP(C21,Ref!$A$1:$H$50,8,FALSE))=TRUE,\"\",VLOOKUP(C21,Ref!$A$1:$H$50,8,FALSE)),\"\")","v":""},{"$f":"IF(AND($AE21<>\"\",AG21<>\"\"),($AE21/43560)*AG21*0.25*2.72,\"\")","v":""},{"$f":"IF(AND($AE21<>\"\",AH21<>\"\"),($AE21/43560)*AH21*0.2*2.72,\"\")","v":""},{"$f":"IF(AND($AE21<>\"\",AI21<>\"\"),($AE21/43560)*AI21*0.15*2.72,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(C22<>\"\",Q22<>\"\",T22<>\"\"),IF(ISNA(VLOOKUP(C22,Ref!$A$1:$E$50,6,FALSE))=TRUE,\"\",IF(VLOOKUP(C22,#REF!,6,FALSE)=\"Y\",Q22,0)),0)","v":0},{"$f":"IF(AND(C22<>\"\",Q22<>\"\",T22<>\"\"),IF(ISNA(VLOOKUP(C22,Ref!$A$1:$E$50,AF22,FALSE))=TRUE,\"\",VLOOKUP(C22,Ref!$A$1:$E$50,AF22,FALSE)),\"\")","v":""},{"$f":"IF(AB22<>\"\",0.2*((1000/AB22)-10),\"\")","v":""},{"$f":"IF(AND(AC22<>\"\",$K$8<>\"\"),IF($K$8-AC22>0,(($K$8-AC22)^2)/($K$8+0.8*((1000/AB22)-10)),0),\"\")","v":""},{"$f":"IF(AD22<>\"\",Q22*43560*(AD22/12),\"\")","v":""},{"$f":"IF(T22<>\"\",IF(T22=\"A\",2,IF(T22=\"B\",3,IF(T22=\"C\",4,IF(OR(T22=\"D\",T22=\"N/A\"),5,)))),\"\")","v":""}]
[null,null,"Water Quality Management Credit"]
[]
[null,null,"Are there impervious surfaces within the Preserved Natural Open Space?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes",null,null,"No"]
[]
[null,null,"Impervious area:",null,null,null,null,null,"ac",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% Impervious:",{"$f":"IF(AND(G27<>\"\",Q21<>\"\"),G27/Q21,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<= 5%?",{"$f":"IF(AC27>0.05,\"N\",\"Y\")","v":"N"}]
[null,null,"WQM Credit, TSS (lbs):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AJ21<>\"\",AJ21*(IF(AC29<>\"\",(1-AC29),1)),\"\")","v":""},null,null,null,null,"Deduction:",{"$f":"IF(AC27<>\"\",IF(AC28=\"N\",AC27-0.05,\"\"),\"\")","v":""}]
[null,null,"WQM Credit, TP (lbs):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AK21<>\"\",AK21*(IF(AC29<>\"\",(1-AC29),1)),\"\")","v":""}]
[null,null,"WQM Credit, TN (lbs):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AL21<>\"\",AL21*(IF(AC29<>\"\",(1-AC29),1)),\"\")","v":""}]
[]
[null,"CERTIFICATION"]
[null,"I certify under penalty of law and subject to the penalties of 18 Pa.C.S. § 4904 (relating to unsworn falsification to authorities) that this document and all attachments were prepared under my direction or supervision in accordance with a system designed to assure that qualified personnel properly gathered and evaluated the information submitted.  Based on my inquiry of the person or persons who manage the system, or those persons directly responsible for gathering the information, the information submitted is, to the best of my knowledge and belief, true, accurate, and complete.  I further certify that the structure, function, and calculations contained in this spreadsheet have not been modified in comparison to the spreadsheet DEP has posted to its website."]
[]
[null,"User Name:",null,null,null,null,null,null,null,null,null,null,null,null,"User Company:"]

{"sheet":"Versions","index":1,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Version","Date","Change(s)"]
["1.0","2026-07-01","Revised Draft."]

{"sheet":"Ref","index":2,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":true,"merged":[]}
["PNOS_Cover","A","B","C","D","TSS_Conc (mg/L)","TP_Conc (mg/L)","TN_Conc (mg/L)","Soils"]
["Open Space (Lawns, Parks, Golf Courses, Cemeteries, Etc.) - Poor Condition (Grass Cover < 50%)",68,79,86,89,78,0.25,1.25,"A"]
["Open Space (Lawns, Parks, Golf Courses, Cemeteries, Etc.) - Fair Condition (Grass Cover 50% to 75%)",49,69,79,84,78,0.25,1.25,"B"]
["Open Space (Lawns, Parks, Golf Courses, Cemeteries, Etc.) - Good Condition (Grass Cover > 75%)",39,61,74,80,78,0.25,1.25,"C"]
["Fallow - Bare Soil",77,86,91,94,216,1.07,7.7,"D"]
["Fallow - Crop Residue Cover (Poor Condition)",76,85,90,93,216,1.07,7.7,"N/A"]
["Fallow - Crop Residue Cover (Good Condition)",74,83,88,90,216,1.07,7.7]
["Row Crops - Straight Row (Poor Condition)",72,81,88,91,145,0.55000000000000004,5.71]
["Row Crops - Straight Row (Good Condition)",67,78,85,89,145,0.55000000000000004,5.71]
["Row Crops - Straight Row & Crop Residue (Poor Condition)",71,80,87,90,216,1.07,7.7]
["Row Crops - Straight Row & Crop Residue (Good Condition)",64,75,82,85,216,1.07,7.7]
["Row Crops - Contoured (Poor Condition)",70,79,84,88,145,0.55000000000000004,5.71]
["Row Crops - Contoured (Good Condition)",65,75,82,86,145,0.55000000000000004,5.71]
["Row Crops - Contoured & Crop Residue (Poor Condition)",69,78,83,87,216,1.07,7.7]
["Row Crops - Contoured & Crop Residue (Good Condition)",64,74,81,85,216,1.07,7.7]
["Row Crops - Contoured & Terraced (Poor Condition)",66,74,80,82,145,0.55000000000000004,5.71]
["Row Crops - Contoured & Terraced (Good Condition)",62,71,78,81,145,0.55000000000000004,5.71]
["Row Crops - Contoured, Terraced & Crop Residue (Poor Condition)",65,73,79,81,216,1.07,7.7]
["Row Crops - Contoured, Terraced & Crop Residue (Good Condition)",61,70,77,80,216,1.07,7.7]
["Small Grain - Straight Row (Poor Condition)",65,76,84,88,145,0.55000000000000004,5.71]
["Small Grain - Straight Row (Good Condition)",63,75,83,87,145,0.55000000000000004,5.71]
["Small Grain - Straight Row & Crop Residue (Poor Condition)",64,75,83,86,216,1.07,7.7]
["Small Grain - Straight Row & Crop Residue (Good Condition)",60,72,80,84,216,1.07,7.7]
["Small Grain - Contoured (Poor Condition)",63,74,82,85,145,0.55000000000000004,5.71]
["Small Grain - Contoured (Good Condition)",61,73,81,84,145,0.55000000000000004,5.71]
["Small Grain - Contoured & Crop Residue (Poor Condition)",62,73,81,84,216,1.07,7.7]
["Small Grain - Contoured & Crop Residue (Good Condition)",60,72,80,83,216,1.07,7.7]
["Small Grain - Contoured & Terraced (Poor Condition)",61,72,79,82,145,0.55000000000000004,5.71]
["Small Grain - Contoured & Terraced (Good Condition)",59,70,78,81,145,0.55000000000000004,5.71]
["Small Grain - Contoured, Terraced & Crop Residue (Poor Condition)",60,71,78,81,216,1.07,7.7]
["Small Grain - Contoured, Terraced & Crop Residue (Good Condition)",58,69,77,80,216,1.07,7.7]
["Close-Seeded or Broadcast Legumes or Rotation Meadow - Straight Row (Poor Condition)",66,77,85,89,145,0.55000000000000004,5.71]
["Close-Seeded or Broadcast Legumes or Rotation Meadow - Straight Row (Good Condition)",58,72,81,85,145,0.55000000000000004,5.71]
["Close-Seeded or Broadcast Legumes or Rotation Meadow - Contoured (Poor Condition)",64,75,83,85,145,0.55000000000000004,5.71]
["Close-Seeded or Broadcast Legumes or Rotation Meadow - Contoured (Good Condition)",55,69,78,83,145,0.55000000000000004,5.71]
["Close-Seeded or Broadcast Legumes or Rotation Meadow - Contoured & Terraced (Poor Condition)",63,73,80,83,145,0.55000000000000004,5.71]
["Close-Seeded or Broadcast Legumes or Rotation Meadow - Contoured & Terraced (Good Condition)",51,67,76,80,145,0.55000000000000004,5.71]
["Pasture, Grassland, or Range-Continuous Forage for Grazing (Poor Condition)",68,79,86,89,48.8,0.22,2.2999999999999998]
["Pasture, Grassland, or Range-Continuous Forage for Grazing (Fair Condition)",49,69,79,84,48.8,0.22,2.2999999999999998]
["Pasture, Grassland, or Range-Continuous Forage for Grazing (Good Condition)",39,61,74,80,48.8,0.22,2.2999999999999998]
["Meadow-Continuous Grass, Protected from Grazing and Generally Mowed for Hay",30,58,71,78,48.8,0.22,2.2999999999999998]
["Brush-Forbs-Grass Mixture with Brush the Major Element (Poor Condition)",48,67,77,83,39,0.15,0.19]
["Brush-Forbs-Grass Mixture with Brush the Major Element (Fair Condition)",35,56,70,77,39,0.15,0.19]
["Brush-Forbs-Grass Mixture with Brush the Major Element (Good Condition)",30,48,65,73,39,0.15,0.19]
["Woods-Grass Combination (Orchard or Tree Farm) (Poor Condition)",57,73,82,86,45,0.13,1.05]
["Woods-Grass Combination (Orchard or Tree Farm) (Fair Condition)",43,65,76,82,45,0.13,1.05]
["Woods-Grass Combination (Orchard or Tree Farm) (Good Condition)",32,58,72,79,45,0.13,1.05]
["Woods (Poor Condition)",45,66,77,83,45,0.13,1.05]
["Woods (Fair Condition)",36,60,73,79,45,0.13,1.05]
["Woods (Good Condition)",30,55,70,77,45,0.13,1.05]