{"text_format":"1","workbook":"xlsx","n_sheets":49,"sheets":["Introduction","Reference","Lookup Table","Lookup List","Land Loading Rates","PerviousRunoffDepth","Scratch","ScratchBefore","ScratchAfter","PCInfiltrationChamber_0.17","PCInfiltrationChamber_0.27","PCInfiltrationChamber_0.52","PCInfiltrationChamber_1.02","PCInfiltrationChamber_2.41","PCInfiltrationChamber_8.27","PCInfiltrationTrench_0.17","PCInfiltrationTrench_0.27","PCInfiltrationTrench_0.52","PCInfiltrationTrench_1.02","PCInfiltrationTrench_2.41","PCInfiltrationTrench_8.27","PCInfiltrationBasin_0.17","PCInfiltrationBasin_0.27","PCInfiltrationBasin_0.52","PCInfiltrationBasin_1.02","PCInfiltrationBasin_2.41","PCInfiltrationBasin_8.27","PCSandFilter","PCBiofiltration","PCPorousPavement","PCBiofiltrationISR","PCGravelWetland","PCWetPond","PCDryPond","PCGrassSwale","PCIADisconnectStorage_8.1","PCIADisconnectStorage_6.1","PCIADisconnectStorage_4.1","PCIADisconnectStorage_2.1","PCIADisconnectStorage_1.1","PCDisconnect","Database Structural BMPs","Database Non-Structural BMPs","CSV_Export","Database Land Use Conversions","ExportProject","Import Structural BMPs","Import Non-Structural BMPs","Import Land Use Conversions"],"not_rendered":{"charts":1,"images":4,"macros":1,"external_links":0,"defined_names":48,"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":"Introduction","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Reference","index":1,"n_rows":21,"n_cols":15,"rows_kept":21,"cut":false,"hidden":false,"merged":[[20,11,20,14],[0,11,0,14],[16,11,16,14],[17,11,17,14],[18,11,18,14],[19,11,19,14]]}
[null,null,null,null,null,null,null,null,null,null,null,"Table 1:  Method for determining stormwater control design volume (DSV) (i.e., capacity) using Long-term cumulative performance curves"]
[null,null,null,null,null,null,null,null,null,null,null,"Stormwater Control Type","Description","Applicable Structural Stormwater Control Performance Curve ","Method for calculating Design Storage Capacity to Estimate Long-term Cumulative Reduction Performances  and Estimate Costs "]
[null,null,null,null,null,null,null,null,null,null,null,"Infiltration Trench","Provides temporary storage of runoff using the void spaces within the soil/sand/gravel mixture that is used to backfill the trench for subsequent infiltration into the surrounding sub-soils. ","Infiltration Trench (6 infiltration  rates: 0.17, 0.27, 0.52, 1.02, 2.41 and 8.27 inches per hour)","DSV = void space volumes of stone and sand layers             DSV = (Atrench x Dstone x nstone )+ (Atrench x Dsand x nsand)"]
[null,null,null,null,null,null,null,null,null,null,null,"Subsurface Infiltration  ","Provides temporary storage of runoff using the combination of storage structures (e.g., galleys, chambers, pipes, etc) and void spaces within the washed stone that is used to backfill the system for subsequent infiltration into the surrounding sub-soils. ","Infiltration Trench (6 infiltration  rates: 0.17, 0.27, 0.52, 1.02, 2.41 and 8.27 inches per hour)","DSV = Water storage volume of storage units and void space volumes of backfill materials. Example for subsurface galleys backfilled with washed stone:                       DSV = (L x W x D)galley + (Abackfill x Dstone x nstone) "]
[null,null,null,null,null,null,null,null,null,null,null,"Surface Infiltration ","Provides temporary storage of runoff through surface ponding (e.g., basin or swale) for subsequent infiltration into the underlying soils. ","Infiltration Basin (6 infiltration  rates: 0.17, 0.27, 0.52, 1.02, 2.41 and 8.27 inches per hour)","DSV = Water volume of storage structure before bypass. Example for linear trapezoidal vegetated swale          DSV = (L x ((Wbottom+Wtop@Dmax )/2) x D)"]
[null,null,null,null,null,null,null,null,null,null,null,"Rain Garden/Bio-retention  (no underdrains)","Provides temporary storage of runoff through surface ponding and possibly void spaces within the soil/sand/washed stone mixture that is used to filter runoff prior to infiltration into underlying soils.","Infiltration Basin (6 infiltration  rates: 0.17, 0.27, 0.52, 1.02, 2.41 and 8.27 inches per hour)","DSV = Ponding water storage volume and void space volumes of soil filter media. Example for raingarden :                       DSV = (Apond x Dpond) + (Asoil x Dsoil x nsoil mix) "]
[null,null,null,null,null,null,null,null,null,null,null,"Tree Filter (no underdrain)","Provides temporary storage of runoff through surface ponding and void spaces within the soil/sand/washed stone mixture that is used to filter runoff prior to infiltration into underlying soils.","Infiltration Trench (6 infiltration  rates: 0.17, 0.27, 0.52, 1.02, 2.41 and 8.27 inches per hour)","DSV = Ponding water storage volume and void space volumes of soil filter media.                                                  DSV = (Abed x Dponding) + (Abed x Dsoil x nsoil mix) "]
[null,null,null,null,null,null,null,null,null,null,null,"Bio-Filtration (w/underdrain)","Provides temporary storage of runoff for filtering through an engineered soil media. The storage capacity includes void spaces in the filter media and temporary ponding at the surface.  After runoff has passed through the filter media it is collected by an under-drain pipe for discharge. Manufactured or packaged bio-filter systems such as tree box filters may be suitable for using the bio-filtration performance results. ","Bioretention","DSV = Ponding water storage volume and void space volume of soil filter media.                                                   DSV =  (Abed x Dponding)+ (Abed x Dsoil x nsoil)  "]
[null,null,null,null,null,null,null,null,null,null,null,"Gravel Wetland","Based on design by the UNH Stormwater Center (UNHSC).  Provides temporary surface ponding storage of runoff in a vegetated wetland cell that is eventually routed to an underlying saturated gravel internal storage reservoir (ISR) for nitrogen treatment.  Outflow is controlled by an elevated orifice that has its invert elevation equal at the top of the ISR layer and provides a retention time of at least 24 hours.","Gravel Wetland ","DSV = pretreatment volume + ponding volume + void space volume of gravel ISR.                                                   DSV = (A pretreatment x DpreTreatment)+ (A wetland x Dponding)+ (AISR x Dgravel  x ngravel)  Pretreatment "]
[null,null,null,null,null,null,null,null,null,null,null,"Enhanced Biorention","Based on design by the UNH Stormwater Center (UNHSC).  Provides temporary surface ponding storage of runoff above a vegetated soil filter media cell that is filters runoff as it is routed to an underlying saturated washed stone internal storage reservoir (ISR) for nitrogen treatment.  Outflow is controlled by an elevated orifice that has its invert elevation equal at the top of the ISR layer and provides a retention time of at least 24 hours.","Enhanced Bioretention","DSV = Ponding volume + void space volume of filter media + void space volume of gravel ISR.                                                   DSV = (A filter bed x Dponding)+ (A filter bed x Dfilter  x n soil) + (AISR x Dstone  x nstone)"]
[null,null,null,null,null,null,null,null,null,null,null,"Porous Pavement with subsurface infiltration","Provides filtering of runoff through a filter course and temporary storage of runoff within the void spaces of a subsurface gravel reservoir prior to infiltration into subsoils.  ","Infiltration Trench (6 infiltration  rates: 0.17, 0.27, 0.52, 1.02, 2.41 and 8.27 inches per hour)","DSV = void space volumes of gravel layer                        DSV = (Apavement x Dstone x nstone )"]
[null,null,null,null,null,null,null,null,null,null,null,"Porous pavement w/ impermeable underliner w/underdrain ","Provides filtering of runoff through a filter course and temporary storage of runoff within the void spaces prior to discharge by way of an underdrain.","Porous Pavement","Depth of Filter Course = D FC"]
[null,null,null,null,null,null,null,null,null,null,null,"Sand Filter w/underdrain","Provides filtering of runoff through a sand filter course and temporary storage of runoff through surface ponding and within void spaces of the sand and washed stone layers prior to discharge by way of an underdrain.","Sand Filter","DSV = pretreatment volume + ponding volume + void space volume of sand and washed stone layers.                                                   DSV = (A pretreatment x DpreTreatment)+ (A bed x Dponding)                    + (Abed x Dsand  x nsand) + (Abed x Dstone  x nstone)"]
[null,null,null,null,null,null,null,null,null,null,null,"Wet  Pond","Provides treatment of runoff through routing through permanent pool.","Wet Pond","DSV= Pemanent pool volume prior to high flow bypass   DSV=Apond x Dpond   (does not include pretreatment volume)"]
[null,null,null,null,null,null,null,null,null,null,null,"Extended Dry Detention Basin","Provides temporary detention storage for the design storage volume t drain in 24 hours through multiple out let controls.   ","Dry Pond","DSV= Ponding volume prior to high flow bypass   DSV=Apond x Dpond   (does not include pretreatment volume)"]
[null,null,null,null,null,null,null,null,null,null,null,"Grass Conveyance Swale","Conveys runoff through an open channel vegetated with grass.  Primary removal mechanism is infiltration as runoff flows are conveyed.","Grass Swale","DSV = Volume of swale at full design flow            DSV=Lswalex AX-sect. swale            "]
[null,null,null,null,null,null,null,null,null,null,null,"Footnotes:"]
[null,null,null,null,null,null,null,null,null,null,null,"DSV= Design Storage Volume = physical storage capacity to hold water"]
[null,null,null,null,null,null,null,null,null,null,null,"VSV=Void Space Volume"]
[null,null,null,null,null,null,null,null,null,null,null,"L= length, W= width, D= depth at design capacity before bypass, n=porosity fill material, A= average surface area for calculating volume"]
[null,null,null,null,null,null,null,null,null,null,null,"Infiltration rate = saturated soil hydraulic conductivity"]

{"sheet":"Lookup Table","index":2,"n_rows":326,"n_cols":12,"rows_kept":326,"cut":false,"hidden":true,"merged":[]}
["State List",null,"State","Town List",null,"State","Town","Subcatchment",null,"State","Town","Receiving Water"]
["CONNECTICUT",null,"MASSACHUSETTS","ARLINGTON",null,"MASSACHUSETTS","ARLINGTON","SWS101",null,"MASSACHUSETTS","ARLINGTON","RCH101"]
["MAINE",null,"MASSACHUSETTS","ASHLAND"]
["MASSACHUSETTS",null,"MASSACHUSETTS","BELLINGHAM"]
["NEW HAMSPHIRE",null,"MASSACHUSETTS","BELMONT"]
["RHODE ISLAND",null,"MASSACHUSETTS","BOSTON"]
["VERMONT",null,"MASSACHUSETTS","BROOKLINE"]
["",null,"MASSACHUSETTS","CAMBRIDGE"]
[null,null,"MASSACHUSETTS","DEDHAM"]
[null,null,"MASSACHUSETTS","DOVER"]
[null,null,"MASSACHUSETTS","FOXBOROUGH"]
[null,null,"MASSACHUSETTS","FRANKLIN"]
[null,null,"MASSACHUSETTS","HOLLISTON"]
[null,null,"MASSACHUSETTS","HOPEDALE"]
[null,null,"MASSACHUSETTS","HOPKINTON"]
[null,null,"MASSACHUSETTS","LEXINGTON"]
[null,null,"MASSACHUSETTS","LINCOLN"]
[null,null,"MASSACHUSETTS","MEDFIELD"]
[null,null,"MASSACHUSETTS","MEDWAY"]
[null,null,"MASSACHUSETTS","MENDON"]
[null,null,"MASSACHUSETTS","MILFORD"]
[null,null,"MASSACHUSETTS","MILLIS"]
[null,null,"MASSACHUSETTS","NATICK"]
[null,null,"MASSACHUSETTS","NEEDHAM"]
[null,null,"MASSACHUSETTS","NEWTON"]
[null,null,"MASSACHUSETTS","NORFOLK"]
[null,null,"MASSACHUSETTS","SHERBORN"]
[null,null,"MASSACHUSETTS","SOMERVILLE"]
[null,null,"MASSACHUSETTS","WALPOLE"]
[null,null,"MASSACHUSETTS","WALTHAM"]
[null,null,"MASSACHUSETTS","WATERTOWN"]
[null,null,"MASSACHUSETTS","WAYLAND"]
[null,null,"MASSACHUSETTS","WELLESLEY"]
[null,null,"MASSACHUSETTS","WESTON"]
[null,null,"MASSACHUSETTS","WESTWOOD"]
[null,null,"MASSACHUSETTS","WRENTHAM"]
[null,null,"NEW HAMSPHIRE","ACWORTH"]
[null,null,"NEW HAMSPHIRE","ALBANY"]
[null,null,"NEW HAMSPHIRE","ALEXANDRIA"]
[null,null,"NEW HAMSPHIRE","ALLENSTOWN"]
[null,null,"NEW HAMSPHIRE","ALSTEAD"]
[null,null,"NEW HAMSPHIRE","ALTON"]
[null,null,"NEW HAMSPHIRE","AMHERST"]
[null,null,"NEW HAMSPHIRE","ANDOVER"]
[null,null,"NEW HAMSPHIRE","ANTRIM"]
[null,null,"NEW HAMSPHIRE","ASHLAND"]
[null,null,"NEW HAMSPHIRE","ATKINSON"]
[null,null,"NEW HAMSPHIRE","AUBURN"]
[null,null,"NEW HAMSPHIRE","BARNSTEAD"]
[null,null,"NEW HAMSPHIRE","BARRINGTON"]
[null,null,"NEW HAMSPHIRE","BARTLETT"]
[null,null,"NEW HAMSPHIRE","BATH"]
[null,null,"NEW HAMSPHIRE","BEDFORD"]
[null,null,"NEW HAMSPHIRE","BELMONT"]
[null,null,"NEW HAMSPHIRE","BENNINGTON"]
[null,null,"NEW HAMSPHIRE","BENTON"]
[null,null,"NEW HAMSPHIRE","BERLIN"]
[null,null,"NEW HAMSPHIRE","BETHLEHEM"]
[null,null,"NEW HAMSPHIRE","BOSCAWEN"]
[null,null,"NEW HAMSPHIRE","BOW"]
[null,null,"NEW HAMSPHIRE","BRADFORD"]
[null,null,"NEW HAMSPHIRE","BRENTWOOD"]
[null,null,"NEW HAMSPHIRE","BRIDGEWATER"]
[null,null,"NEW HAMSPHIRE","BRISTOL"]
[null,null,"NEW HAMSPHIRE","BROOKFIELD"]
[null,null,"NEW HAMSPHIRE","BROOKLINE"]
[null,null,"NEW HAMSPHIRE","CAMPTON"]
[null,null,"NEW HAMSPHIRE","CANAAN"]
[null,null,"NEW HAMSPHIRE","CANDIA"]
[null,null,"NEW HAMSPHIRE","CANTERBURY"]
[null,null,"NEW HAMSPHIRE","CARROLL"]
[null,null,"NEW HAMSPHIRE","CENTER HARBOR"]
[null,null,"NEW HAMSPHIRE","CHARLESTOWN"]
[null,null,"NEW HAMSPHIRE","CHATHAM"]
[null,null,"NEW HAMSPHIRE","CHESTER"]
[null,null,"NEW HAMSPHIRE","CHESTERFIELD"]
[null,null,"NEW HAMSPHIRE","CHICHESTER"]
[null,null,"NEW HAMSPHIRE","CLAREMONT"]
[null,null,"NEW HAMSPHIRE","CLARKSVILLE"]
[null,null,"NEW HAMSPHIRE","COLEBROOK"]
[null,null,"NEW HAMSPHIRE","COLUMBIA"]
[null,null,"NEW HAMSPHIRE","CONCORD"]
[null,null,"NEW HAMSPHIRE","CONWAY"]
[null,null,"NEW HAMSPHIRE","CORNISH"]
[null,null,"NEW HAMSPHIRE","CROYDON"]
[null,null,"NEW HAMSPHIRE","DALTON"]
[null,null,"NEW HAMSPHIRE","DANBURY"]
[null,null,"NEW HAMSPHIRE","DANVILLE"]
[null,null,"NEW HAMSPHIRE","DEERFIELD"]
[null,null,"NEW HAMSPHIRE","DEERING"]
[null,null,"NEW HAMSPHIRE","DERRY"]
[null,null,"NEW HAMSPHIRE","DORCHESTER"]
[null,null,"NEW HAMSPHIRE","DOVER"]
[null,null,"NEW HAMSPHIRE","DUBLIN"]
[null,null,"NEW HAMSPHIRE","DUMMER"]
[null,null,"NEW HAMSPHIRE","DUNBARTON"]
[null,null,"NEW HAMSPHIRE","DURHAM"]
[null,null,"NEW HAMSPHIRE","EAST KINGSTON"]
[null,null,"NEW HAMSPHIRE","EASTON"]
[null,null,"NEW HAMSPHIRE","EATON"]
[null,null,"NEW HAMSPHIRE","EFFINGHAM"]
[null,null,"NEW HAMSPHIRE","ELLSWORTH"]
[null,null,"NEW HAMSPHIRE","ENFIELD"]
[null,null,"NEW HAMSPHIRE","EPPING"]
[null,null,"NEW HAMSPHIRE","EPSOM"]
[null,null,"NEW HAMSPHIRE","ERROL"]
[null,null,"NEW HAMSPHIRE","EXETER"]
[null,null,"NEW HAMSPHIRE","FARMINGTON"]
[null,null,"NEW HAMSPHIRE","FITZWILLIAM"]
[null,null,"NEW HAMSPHIRE","FRANCESTOWN"]
[null,null,"NEW HAMSPHIRE","FRANCONIA"]
[null,null,"NEW HAMSPHIRE","FRANKLIN"]
[null,null,"NEW HAMSPHIRE","FREEDOM"]
[null,null,"NEW HAMSPHIRE","FREMONT"]
[null,null,"NEW HAMSPHIRE","GILFORD"]
[null,null,"NEW HAMSPHIRE","GILMANTON"]
[null,null,"NEW HAMSPHIRE","GILSUM"]
[null,null,"NEW HAMSPHIRE","GOFFSTOWN"]
[null,null,"NEW HAMSPHIRE","GORHAM"]
[null,null,"NEW HAMSPHIRE","GOSHEN"]
[null,null,"NEW HAMSPHIRE","GRAFTON"]
[null,null,"NEW HAMSPHIRE","GRANTHAM"]
[null,null,"NEW HAMSPHIRE","GREENFIELD"]
[null,null,"NEW HAMSPHIRE","GREENLAND"]
[null,null,"NEW HAMSPHIRE","GREENVILLE"]
[null,null,"NEW HAMSPHIRE","GROTON"]
[null,null,"NEW HAMSPHIRE","HAMPSTEAD"]
[null,null,"NEW HAMSPHIRE","HAMPTON"]
[null,null,"NEW HAMSPHIRE","HAMPTON FALLS"]
[null,null,"NEW HAMSPHIRE","HANCOCK"]
[null,null,"NEW HAMSPHIRE","HANOVER"]
[null,null,"NEW HAMSPHIRE","HARRISVILLE"]
[null,null,"NEW HAMSPHIRE","HART'S LOCATION"]
[null,null,"NEW HAMSPHIRE","HAVERHILL"]
[null,null,"NEW HAMSPHIRE","HEBRON"]
[null,null,"NEW HAMSPHIRE","HENNIKER"]
[null,null,"NEW HAMSPHIRE","HILL"]
[null,null,"NEW HAMSPHIRE","HILLSBOROUGH"]
[null,null,"NEW HAMSPHIRE","HINSDALE"]
[null,null,"NEW HAMSPHIRE","HOLDERNESS"]
[null,null,"NEW HAMSPHIRE","HOLLIS"]
[null,null,"NEW HAMSPHIRE","HOOKSETT"]
[null,null,"NEW HAMSPHIRE","HOPKINTON"]
[null,null,"NEW HAMSPHIRE","HUDSON"]
[null,null,"NEW HAMSPHIRE","JACKSON"]
[null,null,"NEW HAMSPHIRE","JAFFREY"]
[null,null,"NEW HAMSPHIRE","JEFFERSON"]
[null,null,"NEW HAMSPHIRE","KEENE"]
[null,null,"NEW HAMSPHIRE","KENSINGTON"]
[null,null,"NEW HAMSPHIRE","KINGSTON"]
[null,null,"NEW HAMSPHIRE","LACONIA"]
[null,null,"NEW HAMSPHIRE","LANCASTER"]
[null,null,"NEW HAMSPHIRE","LANDAFF"]
[null,null,"NEW HAMSPHIRE","LANGDON"]
[null,null,"NEW HAMSPHIRE","LEBANON"]
[null,null,"NEW HAMSPHIRE","LEE"]
[null,null,"NEW HAMSPHIRE","LEMPSTER"]
[null,null,"NEW HAMSPHIRE","LINCOLN"]
[null,null,"NEW HAMSPHIRE","LISBON"]
[null,null,"NEW HAMSPHIRE","LITCHFIELD"]
[null,null,"NEW HAMSPHIRE","LITTLETON"]
[null,null,"NEW HAMSPHIRE","LONDONDERRY"]
[null,null,"NEW HAMSPHIRE","LOUDON"]
[null,null,"NEW HAMSPHIRE","LYMAN"]
[null,null,"NEW HAMSPHIRE","LYME"]
[null,null,"NEW HAMSPHIRE","LYNDEBOROUGH"]
[null,null,"NEW HAMSPHIRE","MADBURY"]
[null,null,"NEW HAMSPHIRE","MADISON"]
[null,null,"NEW HAMSPHIRE","MANCHESTER"]
[null,null,"NEW HAMSPHIRE","MARLBOROUGH"]
[null,null,"NEW HAMSPHIRE","MARLOW"]
[null,null,"NEW HAMSPHIRE","MASON"]
[null,null,"NEW HAMSPHIRE","MEREDITH"]
[null,null,"NEW HAMSPHIRE","MERRIMACK"]
[null,null,"NEW HAMSPHIRE","MIDDLETON"]
[null,null,"NEW HAMSPHIRE","MILAN"]
[null,null,"NEW HAMSPHIRE","MILFORD"]
[null,null,"NEW HAMSPHIRE","MILTON"]
[null,null,"NEW HAMSPHIRE","MONROE"]
[null,null,"NEW HAMSPHIRE","MONT VERNON"]
[null,null,"NEW HAMSPHIRE","MOULTONBOROUGH"]
[null,null,"NEW HAMSPHIRE","NASHUA"]
[null,null,"NEW HAMSPHIRE","NELSON"]
[null,null,"NEW HAMSPHIRE","NEW BOSTON"]
[null,null,"NEW HAMSPHIRE","NEW CASTLE"]
[null,null,"NEW HAMSPHIRE","NEW DURHAM"]
[null,null,"NEW HAMSPHIRE","NEW HAMPTON"]
[null,null,"NEW HAMSPHIRE","NEW IPSWICH"]
[null,null,"NEW HAMSPHIRE","NEW LONDON"]
[null,null,"NEW HAMSPHIRE","NEWBURY"]
[null,null,"NEW HAMSPHIRE","NEWFIELDS"]
[null,null,"NEW HAMSPHIRE","NEWINGTON"]
[null,null,"NEW HAMSPHIRE","NEWMARKET"]
[null,null,"NEW HAMSPHIRE","NEWPORT"]
[null,null,"NEW HAMSPHIRE","NEWTON"]
[null,null,"NEW HAMSPHIRE","NORTHFIELD"]
[null,null,"NEW HAMSPHIRE","NORTH HAMPTON"]
[null,null,"NEW HAMSPHIRE","NORTHUMBERLAND"]
[null,null,"NEW HAMSPHIRE","NORTHWOOD"]
[null,null,"NEW HAMSPHIRE","NOTTINGHAM"]
[null,null,"NEW HAMSPHIRE","ORANGE"]
[null,null,"NEW HAMSPHIRE","ORFORD"]
[null,null,"NEW HAMSPHIRE","OSSIPEE"]
[null,null,"NEW HAMSPHIRE","PELHAM"]
[null,null,"NEW HAMSPHIRE","PEMBROKE"]
[null,null,"NEW HAMSPHIRE","PETERBOROUGH"]
[null,null,"NEW HAMSPHIRE","PIERMONT"]
[null,null,"NEW HAMSPHIRE","PITTSBURG"]
[null,null,"NEW HAMSPHIRE","PITTSFIELD"]
[null,null,"NEW HAMSPHIRE","PLAINFIELD"]
[null,null,"NEW HAMSPHIRE","PLAISTOW"]
[null,null,"NEW HAMSPHIRE","PLYMOUTH"]
[null,null,"NEW HAMSPHIRE","PORTSMOUTH"]
[null,null,"NEW HAMSPHIRE","RANDOLPH"]
[null,null,"NEW HAMSPHIRE","RAYMOND"]
[null,null,"NEW HAMSPHIRE","RICHMOND"]
[null,null,"NEW HAMSPHIRE","RINDGE"]
[null,null,"NEW HAMSPHIRE","ROCHESTER"]
[null,null,"NEW HAMSPHIRE","ROLLINSFORD"]
[null,null,"NEW HAMSPHIRE","ROXBURY"]
[null,null,"NEW HAMSPHIRE","RUMNEY"]
[null,null,"NEW HAMSPHIRE","RYE"]
[null,null,"NEW HAMSPHIRE","SALEM"]
[null,null,"NEW HAMSPHIRE","SALISBURY"]
[null,null,"NEW HAMSPHIRE","SANBORNTON"]
[null,null,"NEW HAMSPHIRE","SANDOWN"]
[null,null,"NEW HAMSPHIRE","SANDWICH"]
[null,null,"NEW HAMSPHIRE","SEABROOK"]
[null,null,"NEW HAMSPHIRE","SHARON"]
[null,null,"NEW HAMSPHIRE","SHELBURNE"]
[null,null,"NEW HAMSPHIRE","SOMERSWORTH"]
[null,null,"NEW HAMSPHIRE","SOUTH HAMPTON"]
[null,null,"NEW HAMSPHIRE","SPRINGFIELD"]
[null,null,"NEW HAMSPHIRE","STARK"]
[null,null,"NEW HAMSPHIRE","STEWARTSTOWN"]
[null,null,"NEW HAMSPHIRE","STODDARD"]
[null,null,"NEW HAMSPHIRE","STRAFFORD"]
[null,null,"NEW HAMSPHIRE","STRATFORD"]
[null,null,"NEW HAMSPHIRE","STRATHAM"]
[null,null,"NEW HAMSPHIRE","SUGAR HILL"]
[null,null,"NEW HAMSPHIRE","SULLIVAN"]
[null,null,"NEW HAMSPHIRE","SUNAPEE"]
[null,null,"NEW HAMSPHIRE","SURRY"]
[null,null,"NEW HAMSPHIRE","SUTTON"]
[null,null,"NEW HAMSPHIRE","SWANZEY"]
[null,null,"NEW HAMSPHIRE","TAMWORTH"]
[null,null,"NEW HAMSPHIRE","TEMPLE"]
[null,null,"NEW HAMSPHIRE","THORNTON"]
[null,null,"NEW HAMSPHIRE","TILTON"]
[null,null,"NEW HAMSPHIRE","TROY"]
[null,null,"NEW HAMSPHIRE","TUFTONBORO"]
[null,null,"NEW HAMSPHIRE","UNITY"]
[null,null,"NEW HAMSPHIRE","WAKEFIELD"]
[null,null,"NEW HAMSPHIRE","WALPOLE"]
[null,null,"NEW HAMSPHIRE","WARNER"]
[null,null,"NEW HAMSPHIRE","WARREN"]
[null,null,"NEW HAMSPHIRE","WASHINGTON"]
[null,null,"NEW HAMSPHIRE","WATERVILLE VALLEY"]
[null,null,"NEW HAMSPHIRE","WEARE"]
[null,null,"NEW HAMSPHIRE","WEBSTER"]
[null,null,"NEW HAMSPHIRE","WENTWORTH"]
[null,null,"NEW HAMSPHIRE","WESTMORELAND"]
[null,null,"NEW HAMSPHIRE","WHITEFIELD"]
[null,null,"NEW HAMSPHIRE","WILMOT"]
[null,null,"NEW HAMSPHIRE","WILTON"]
[null,null,"NEW HAMSPHIRE","WINCHESTER"]
[null,null,"NEW HAMSPHIRE","WINDHAM"]
[null,null,"NEW HAMSPHIRE","WINDSOR"]
[null,null,"NEW HAMSPHIRE","WOLFEBORO"]
[null,null,"NEW HAMSPHIRE","WOODSTOCK"]
[]
[]
[]
[]
[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,"",""]
[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,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",null,null,{"$f":"UPPER(D308)","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,{"$f":"UPPER(C314)","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,""]

{"sheet":"Lookup List","index":3,"n_rows":100,"n_cols":41,"rows_kept":100,"cut":false,"hidden":true,"merged":[[0,32,0,34],[0,35,0,37],[0,38,0,40]]}
["Town List",null,"Land Use List",null,"HSG List",null,"Structural BMPs List",null,"Infiltration Rate (in/hr)",null,"Non-Structural BMPs List",null,"Release Rate (day)",null,"Sweeper Technology Choices",null,"Sweeper Frequency Choices",null,"Town","No Application of Fertilizers Containing Phosphorus: Weighted P Export Rate Removal (lb/ac/yr)","No Application of Fertilizers Containing Phosphorus: Lawn Area (ac)",null,"Pollutants","No Application of Fertilizers Containing Phosphorusr: Removal Efficiency (%)",null,"Pollutants","Organic Waste/Leaf Litter: Removal Efficiency (%)",null,"Pollutants","Catch Basin Cleaning: Removal Efficiency (%)",null,null,"Phosphorus: Removal Efficiency (%)",null,null,"Nitrogen: Removal Efficiency (%)",null,null,"Total Suspended Solids: Removal Efficiency (%)"]
["ARLINGTON",null,"AGRICULTURE (I)",null,"A",null,"BIORETENTION",null,0.17,null,"CATCH BASIN CLEANING",null,1,null,"HIGH-EFFICIENCY REGENERATIVE AIR-VACUUM",null,"MONTHLY",null,"ARLINGTON",0.26103504964943097,15.216794580399974,null,"TP",0.5,null,"TP",0.05,null,"TP",0.02,null,null,"2x/ year","Monthly","Weekly","2x/ year","Monthly","Weekly","2x/ year","Monthly","Weekly"]
["ASHLAND",null,"AGRICULTURE (P)",null,"B",null,"ENHANCED BIORETENTION",null,0.27,null,"ENHANCED SWEEPING PROGRAM",null,2,null,"MECHANICAL BROOM",null,"TWICE/YEAR (SPRING AND FALL)",null,"ASHLAND",0.20734350351605441,27.202781494349967,null,"TN",0,null,"TN",0,null,"TN",0,null,"MECHANICAL BROOM",0.01,0.03,0.05,0,0,0,0,0,0]
["BELLINGHAM",null,"COMMERCIAL (I)",null,"C",null,"EXTENDED DRY DETENTION POND",null,0.52,null,"IMPERVIOUS AREA DISCONNECTION",null,3,null,"VACUUM ASSISTED",null,"WEEKLY",null,"BELLINGHAM",0.15171006943979903,237.6206313896798,null,"TSS",0,null,"TSS",0,null,"TSS",0,null,"VACUUM ASSISTED",0.02,0.04,0.08,0,0,0,0,0,0]
["BELMONT",null,"COMMERCIAL (P)",null,"C/D",null,"GRASS SWALE (CONVEYANCE)",null,1.02,null,"IMPERVIOUS AREA DISCONNECTION THROUGH STORAGE",null,null,null,null,null,null,null,"BELMONT",0.2269045071905603,118.1876624648299,null,null,null,null,null,null,null,null,null,null,"HIGH-EFFICIENCY REGENERATIVE AIR-VACUUM",0.02,0.08,0.1,0,0,0,0,0,0]
["BOSTON",null,"FOREST (I)",null,"D",null,"GRAVEL WETLAND",null,2.41,null,"NO APPLICATION OF FERTILIZERS CONTAINING PHOSPHORUS",null,null,null,null,null,null,null,"BOSTON",0.27336723245252514,1589.7699717419782]
["BROOKLINE",null,"FOREST (P)",null,null,null,"INFILTRATION BASIN",null,8.27,null,"ORGANIC WASTE/LEAF LITTER COLLECTION PROGRAM",null,null,null,null,null,null,null,"BROOKLINE",0.26069598939715299,689.34929080541895]
["CAMBRIDGE",null,"HIGH DENSITY RESIDENTIAL (I)",null,null,null,"INFILTRATION TRENCH",null,null,null,"",null,null,null,null,null,null,null,"CAMBRIDGE",0.29024910157672823,103.81874152138985]
["DEDHAM",null,"HIGH DENSITY RESIDENTIAL (P)",null,null,null,"POROUS PAVEMENT",null,null,null,null,null,null,null,null,null,null,null,"DEDHAM",0.2160395733732294,366.2786971932897]
["DOVER",null,"HIGHWAY (I)",null,null,null,"WET POND/CREATED WETLAND",null,null,null,null,null,null,null,null,null,null,null,"DOVER",0.13930824147514359,398.35526371801927]
["FOXBOROUGH",null,"HIGHWAY (P)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FOXBOROUGH",0.23593828285398158,0.79940675107999881]
["FRANKLIN",null,"INDUSTRIAL (I)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FRANKLIN",0.16401187082475971,1194.4060102347798]
["HOLLISTON",null,"INDUSTRIAL (P)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HOLLISTON",0.16168430014082583,684.05636385792923]
["HOPEDALE",null,"LOW DENSITY RESIDENTIAL (I)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HOPEDALE",0.13565765192450374,50.104775850289954]
["HOPKINTON",null,"LOW DENSITY RESIDENTIAL (P)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HOPKINTON",0.20600223076048974,153.06596697748981]
["LEXINGTON",null,"MEDIUM DENSITY RESIDENTIAL (I)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LEXINGTON",0.23753032247854058,229.20130290091976]
["LINCOLN",null,"MEDIUM DENSITY RESIDENTIAL (P)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LINCOLN",0.14809666782683556,223.22685915445973]
["MEDFIELD",null,"OPEN LAND (I)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MEDFIELD",0.15899267653504548,452.36254749202948]
["MEDWAY",null,"OPEN LAND (P)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MEDWAY",0.15770363505128523,609.44982579991904]
["MENDON",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MENDON",0.11866950461684074,7.5839209479599914]
["MILFORD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MILFORD",0.20509725211394139,552.19913502697921]
["MILLIS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MILLIS",0.13010427505983913,411.00193183538977]
["NATICK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NATICK",0.24034470847999578,521.01292248396931]
["NEEDHAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NEEDHAM",0.22098228191481153,675.72259502908946]
["NEWTON",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NEWTON",0.25223539459719557,1494.6817990988081]
["NORFOLK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NORFOLK",9.6476997370773088E-2,547.16145684444962]
["SHERBORN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SHERBORN",0.16209925128363994,273.92021354011968]
["SOMERVILLE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SOMERVILLE",0.2905508640501106,94.120855758789972]
["WALPOLE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WALPOLE",0.15644225347106336,79.617371024729849]
["WALTHAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WALTHAM",0.25453066851914413,594.6271867799893]
["WATERTOWN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WATERTOWN",0.28298839310124274,248.78624123807961]
["WAYLAND",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WAYLAND",0.2087558834031161,21.871993489499985]
["WELLESLEY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WELLESLEY",0.21994160246518515,858.28510924680904]
["WESTON",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WESTON",0.15897079332779512,856.63279869348867]
["WESTWOOD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WESTWOOD",0.24813916068077158,252.96895337118966]
["WRENTHAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WRENTHAM",7.576011360955201E-2,265.43581655429955]
["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,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,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,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,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,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,""]
["",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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,""]
["",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,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,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,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,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,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,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,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,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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Land Loading Rates","index":4,"n_rows":27,"n_cols":9,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
["Land Use List","lb P/ac/yr","lb N/ac/yr","lb TSS/ac/yr",null," Pervious","lb P/ac/yr","lb N/ac/yr","lb TSS/ac/yr"]
["AGRICULTURE (I)",1.52,11.33,649.51,null,"A",0.03,0.27,7.14]
["AGRICULTURE (P)",0.45,2.59,29.44,null,"B",0.12,1.1599999999999999,29.44]
["COMMERCIAL (I)",1.78,15.08,377.39,null,"C",0.21,2.41,59.78]
["FOREST (I)",1.52,11.33,649.51,null,"C/D",0.28999999999999998,3.03,75.84]
["FOREST (P)",0.12,0.54,29.44,null,"D",0.37,3.66,91]
["HIGH DENSITY RESIDENTIAL (I)",2.3199999999999998,14.1,438.95]
["HIGHWAY (I)",1.34,10.17,1480.13]
["INDUSTRIAL (I)",1.78,15.08,377.39]
["LOW DENSITY RESIDENTIAL (I)",1.52,14.1,438.95]
["MEDIUM DENSITY RESIDENTIAL (I)",1.96,14.1,438.95]
["OPEN LAND (I)",1.52,11.33,649.51]
[""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"UPPER(A14)","v":""}]

{"sheet":"PerviousRunoffDepth","index":5,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":true,"merged":[[0,0,0,5],[1,1,1,5],[1,0,2,0]]}
["Developed Land Pervious Area Runoff Depths based on Precipitation depth and Hydrological Soil Groups"]
["RainFall Depth, inches","Runoff Depth, Inches"]
[null,"Pervious HSG A","Pervious HSG B","Pervious HSG C","Pervious HSG C/D","Pervious HSG D"]
[0.1,0,0,0,0,0]
[0.2,0,0,0.01,0.02,0.02]
[0.4,0,0,0.03,0.05,0.06]
[0.5,0,0.01,0.05,7.0000000000000007E-2,0.09]
[0.6,0.01,0.02,0.06,0.09,0.11]
[0.8,0.02,0.03,0.09,0.13,0.16]
[1,0.03,0.04,0.12,0.17,0.21]
[1.2,0.04,0.05,0.14000000000000001,0.27,0.39]
[1.5,0.08,0.11,0.39,0.55000000000000004,0.72]
[2,0.14000000000000001,0.22,0.69,0.89,1.08]

{"sheet":"Scratch","index":6,"n_rows":2,"n_cols":13,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,"ARLINGTON","MASSACHUSETTS"]
["Land Use","Area (ac)","HSG","TP: Land Area Loading  (lb/ac/yr)","TP: Adjustment Factor","TP: Final Area Land Loading  (lb/ac/yr)","TN: Land Area  Loading  (lb/ac/yr)","TN: Adjustment Factor","TN: Final Area Land Loading  (lb/ac/yr)","TSS: Land Area Loading  (lb/ac/yr)","TSS: Adjustment Factor","TSS: Final Area Land Loading  (lb/ac/yr)","Imp or Perv"]

{"sheet":"ScratchBefore","index":7,"n_rows":3,"n_cols":13,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
[]
["Land Use","Area (ac)","HSG","TP: Land Area Loading  (lb/ac/yr)","TP: Adjustment Factor","TP: Final Area Land Loading  (lb/ac/yr)","TN: Land Area  Loading  (lb/ac/yr)","TN: Adjustment Factor","TN: Final Area Land Loading  (lb/ac/yr)","TSS: Land Area Loading  (lb/ac/yr)","TSS: Adjustment Factor","TSS: Final Area Land Loading  (lb/ac/yr)","Imp or Perv"]
["FOREST (I)",1,"N/A",1.52,1,1.52,11.33,1,11.33,649.51,1,649.51,1]

{"sheet":"ScratchAfter","index":8,"n_rows":3,"n_cols":13,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
[]
["Land Use","Area (ac)","HSG","TP: Land Area Loading  (lb/ac/yr)","TP: Adjustment Factor","TP: Final Area Land Loading  (lb/ac/yr)","TN: Land Area  Loading  (lb/ac/yr)","TN: Adjustment Factor","TN: Final Area Land Loading  (lb/ac/yr)","TSS: Land Area Loading  (lb/ac/yr)","TSS: Adjustment Factor","TSS: Final Area Land Loading  (lb/ac/yr)","Imp or Perv"]
["FOREST (P)",1,"N/A",0.12,1,0.12,0.54,1,0.54,29.44,1,29.44,0]

{"sheet":"PCInfiltrationChamber_0.17","index":9,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":true,"merged":[[0,0,0,8]]}
["Infiltration Chamber (0.17 in/hr) BMP Performance Table: Long-Term Load Reduction"]
["BMP Capacity: Depth of Runoff Treated from Impervious Area (inches)",0.1,0.2,0.4,0.6,0.8,1,1.5,2]
["Runoff Volume Reduction",0,0,0,0,0,0,0,0]
["Cumulative Phosphorus Load Reduction",0,0,0,0,0,0,0,0]
["Cumulative Nitrogen Load Reduction",0,0,0,0,0,0,0,0]
["Cumulative TSS Load Reduction",0,0,0,0,0,0,0,0]

{"sheet":"PCInfiltrationChamber_0.27","index":10,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":true,"merged":[[0,0,0,8]]}
["Infiltration Chamber (0.27 in/hr) BMP Performance Table: Long-Term Load Reduction"]
["BMP Capacity: Depth of Runoff Treated from Impervious Area (inches)",0.1,0.2,0.4,0.6,0.8,1,1.5,2]
["Runoff Volume Reduction",0,0,0,0,0,0,0,0]
["Cumulative Phosphorus Load Reduction",0,0,0,0,0,0,0,0]
["Cumulative Nitrogen Load Reduction",0,0,0,0,0,0,0,0]
["Cumulative TSS Load Reduction",0,0,0,0,0,0,0,0]

{"sheet":"PCInfiltrationChamber_0.52","index":11,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":true,"merged":[[0,0,0,8]]}
["Infiltration Chamber (0.52 in/hr) BMP Performance Table: Long-Term Load Reduction"]
["BMP Capacity: Depth of Runoff Treated from Impervious Area (inches)",0.1,0.2,0.4,0.6,0.8,1,1.5,2]
["Runoff Volume Reduction",0,0,0,0,0,0,0,0]
["Cumulative Phosphorus Load Reduction",0,0,0,0,0,0,0,0]
["Cumulative Nitrogen Load Reduction",0,0,0,0,0,0,0,0]
["Cumulative TSS Load Reduction",0,0,0,0,0,0,0,0]

{"sheet":"PCInfiltrationChamber_1.02","index":12,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":true,"merged":[[0,0,0,8]]}
["Infiltration Chamber (1.02 in/hr) BMP Performance Table: Long-Term Load Reduction"]
["BMP Capacity: Depth of Runoff Treated from Impervious Area (inches)",0.1,0.2,0.4,0.6,0.8,1,1.5,2]
["Runoff Volume Reduction",0,0,0,0,0,0,0,0]
["Cumulative Phosphorus Load Reduction",0,0,0,0,0,0,0,0]
["Cumulative Nitrogen Load Reduction",0,0,0,0,0,0,0,0]
["Cumulative TSS Load Reduction",0,0,0,0,0,0,0,0]

{"sheet":"PCInfiltrationChamber_2.41","index":13,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":true,"merged":[[0,0,0,8]]}
["Infiltration Chamber (2.41 in/hr) BMP Performance Table: Long-Term Load Reduction"]
["BMP Capacity: Depth of Runoff Treated from Impervious Area (inches)",0.1,0.2,0.4,0.6,0.8,1,1.5,2]
["Runoff Volume Reduction",0,0,0,0,0,0,0,0]
["Cumulative Phosphorus Load Reduction",0,0,0,0,0,0,0,0]
["Cumulative Nitrogen Load Reduction",0,0,0,0,0,0,0,0]
["Cumulative TSS Load Reduction",0,0,0,0,0,0,0,0]

{"sheet":"PCInfiltrationChamber_8.27","index":14,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":true,"merged":[[0,0,0,8]]}
["Infiltration Chamber (8.27 in/hr) BMP Performance Table: Long-Term Load Reduction"]
["BMP Capacity: Depth of Runoff Treated from Impervious Area (inches)",0.1,0.2,0.4,0.6,0.8,1,1.5,2]
["Runoff Volume Reduction",0,0,0,0,0,0,0,0]
["Cumulative Phosphorus Load Reduction",0,0,0,0,0,0,0,0]
["Cumulative Nitrogen Load Reduction",0,0,0,0,0,0,0,0]
["Cumulative TSS Load Reduction",0,0,0,0,0,0,0,0]

{"sheet":"PCInfiltrationTrench_0.17","index":15,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":true,"merged":[[0,0,0,8]]}
["Infiltration Trench (0.17 in/hr) BMP Performance Table: Long-Term Load Reduction"]
["BMP Capacity: Depth of Runoff Treated from Impervious Area (inches)",0.1,0.2,0.4,0.6,0.8,1,1.5,2]
["Runoff Volume Reduction",0.14699999999999999,0.27600000000000002,0.48599999999999999,0.64100000000000001,0.749,0.82,0.91600000000000004,0.95399999999999996]
["Cumulative Phosphorus Load Reduction",0.18,0.33,0.56999999999999995,0.73,0.83,0.9,0.97,0.99]
["Cumulative Nitrogen Load Reduction",0.56000000000000005,0.72,0.87,0.93,0.96,0.98,0.99,1]
["Cumulative TSS Load Reduction",0.32,0.56000000000000005,0.84,0.95,0.98,0.99,1,1]

{"sheet":"PCInfiltrationTrench_0.27","index":16,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":true,"merged":[[0,0,0,8]]}
["Infiltration Trench (0.27 in/hr) BMP Performance Table: Long-Term Load Reduction"]
["BMP Capacity: Depth of Runoff Treated from Impervious Area (inches)",0.1,0.2,0.4,0.6,0.8,1,1.5,2]
["Runoff Volume Reduction",0.17799999999999999,0.32500000000000001,0.55000000000000004,0.7,0.79300000000000004,0.85199999999999998,0.93300000000000005,0.96299999999999997]
["Cumulative Phosphorus Load Reduction",0.2,0.37,0.63,0.78,0.86,0.92,0.97,0.99]
["Cumulative Nitrogen Load Reduction",0.56999999999999995,0.74,0.88,0.94,0.97,0.98,0.99,1]
["Cumulative TSS Load Reduction",0.36,0.51,0.88,0.97,0.99,1,1,1]

{"sheet":"PCInfiltrationTrench_0.52","index":17,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":true,"merged":[[0,0,0,8]]}
["Infiltration Trench (0.52 in/hr) BMP Performance Table: Long-Term Load Reduction"]
["BMP Capacity: Depth of Runoff Treated from Impervious Area (inches)",0.1,0.2,0.4,0.6,0.8,1,1.5,2]
["Runoff Volume Reduction",0.22,0.38500000000000001,0.61799999999999999,0.75700000000000001,0.83699999999999997,0.88800000000000001,0.95,0.97199999999999998]
["Cumulative Phosphorus Load Reduction",0.23,0.42,0.68,0.82,0.89,0.94,0.98,0.99]
["Cumulative Nitrogen Load Reduction",0.59,0.76,0.9,0.95,0.98,0.99,1,1]
["Cumulative TSS Load Reduction",0.4,0.66,0.91,0.98,0.99,1,1,1]

{"sheet":"PCInfiltrationTrench_1.02","index":18,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":true,"merged":[[0,0,0,8]]}
["Infiltration Trench (1.02 in/hr) BMP Performance Table: Long-Term Load Reduction"]
["BMP Capacity: Depth of Runoff Treated from Impervious Area (inches)",0.1,0.2,0.4,0.6,0.8,1,1.5,2]
["Runoff Volume Reduction",0.26300000000000001,0.44600000000000001,0.68200000000000005,0.81,0.88,0.92100000000000004,0.96499999999999997,0.98299999999999998]
["Cumulative Phosphorus Load Reduction",0.27,0.47,0.73,0.86,0.92,0.96,0.99,1]
["Cumulative Nitrogen Load Reduction",0.61,0.78,0.92,0.97,0.98,0.99,1,1]
["Cumulative TSS Load Reduction",0.44,0.7,0.93,0.99,1,1,1,1]

{"sheet":"PCInfiltrationTrench_2.41","index":19,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":true,"merged":[[0,0,0,8]]}
["Infiltration Trench (2.41 in/hr) BMP Performance Table: Long-Term Phosphorus Load Reduction"]
["BMP Capacity: Depth of Runoff Treated from Impervious Area (inches)",0.1,0.2,0.4,0.6,0.8,1,1.5,2]
["Runoff Volume Reduction",0.34,0.54700000000000004,0.78300000000000003,0.88400000000000001,0.93400000000000005,0.96,0.98799999999999999,0.998]
["Cumulative Phosphorus Load Reduction",0.33,0.55000000000000004,0.81,0.91,0.96,0.98,1,1]
["Cumulative Nitrogen Load Reduction",0.65,0.83,0.95,0.98,0.99,1,1,1]
["Cumulative TSS Load Reduction",0.5,0.77,0.97,1,1,1,1,1]

{"sheet":"PCInfiltrationTrench_8.27","index":20,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":true,"merged":[[0,0,0,8]]}
["Infiltration Trench (8.27 in/hr) BMP Performance Table: Long-Term Load Reduction"]
["BMP Capacity: Depth of Runoff Treated from Impervious Area (inches)",0.1,0.2,0.4,0.6,0.8,1,1.5,2]
["Runoff Volume Reduction",0.53600000000000003,0.76100000000000001,0.92600000000000005,0.97199999999999998,0.98899999999999999,0.995,1,1]
["Cumulative Phosphorus Load Reduction",0.5,0.75,0.94,0.98,0.99,1,1,1]
["Cumulative Nitrogen Load Reduction",0.76,0.92,0.98,1,1,1,1,1]
["Cumulative TSS Load Reduction",0.68,0.92,1,1,1,1,1,1]

{"sheet":"PCInfiltrationBasin_0.17","index":21,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":true,"merged":[[0,0,0,8]]}
["Infiltration Basin (0.17 in/hr) BMP Performance Table: Long-Term Load Reduction"]
["BMP Capacity: Depth of Runoff Treated from Impervious Area (inches)",0.1,0.2,0.4,0.6,0.8,1,1.5,2]
["Runoff Volume Reduction",0.13,0.246,0.442,0.59499999999999997,0.70599999999999996,0.78100000000000003,0.89200000000000002,0.93899999999999995]
["Cumulative Phosphorus Load Reduction",0.35,0.52,0.72,0.82,0.88,0.92,0.97,0.99]
["Cumulative Nitrogen Load Reduction",0.52,0.69,0.85,0.92,0.96,0.98,0.99,1]
["Cumulative TSS Load Reduction",0.64,0.8,0.93,0.98,0.99,1,1,1]

{"sheet":"PCInfiltrationBasin_0.27","index":22,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":true,"merged":[[0,0,0,8]]}
["Infiltration Basin (0.27 in/hr) BMP Performance Table: Long-Term Load Reduction"]
["BMP Capacity: Depth of Runoff Treated from Impervious Area (inches)",0.1,0.2,0.4,0.6,0.8,1,1.5,2]
["Runoff Volume Reduction",0.16300000000000001,0.29799999999999999,0.51,0.66,0.76,0.82399999999999995,0.91500000000000004,0.95199999999999996]
["Cumulative Phosphorus Load Reduction",0.37,0.54,0.74,0.85,0.9,0.93,0.98,0.99]
["Cumulative Nitrogen Load Reduction",0.54,0.71,0.87,0.93,0.97,0.98,0.99,1]
["Cumulative TSS Load Reduction",0.65,0.81,0.94,0.98,0.99,1,1,1]

{"sheet":"PCInfiltrationBasin_0.52","index":23,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":true,"merged":[[0,0,0,8]]}
["Infiltration Basin (0.52 in/hr) BMP Performance Table: Long-Term Load Reduction"]
["BMP Capacity: Depth of Runoff Treated from Impervious Area (inches)",0.1,0.2,0.4,0.6,0.8,1,1.5,2]
["Runoff Volume Reduction",0.20200000000000001,0.35599999999999998,0.57999999999999996,0.72599999999999998,0.81299999999999994,0.86899999999999999,0.94199999999999995,0.96699999999999997]
["Cumulative Phosphorus Load Reduction",0.38,0.56000000000000005,0.77,0.87,0.92,0.95,0.98,0.99]
["Cumulative Nitrogen Load Reduction",0.56000000000000005,0.74,0.89,0.94,0.98,0.99,1,1]
["Cumulative TSS Load Reduction",0.65,0.83,0.95,0.99,0.99,1,1,1]

{"sheet":"PCInfiltrationBasin_1.02","index":24,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":true,"merged":[[0,0,0,8]]}
["Infiltration Basin (1.02 in/hr) BMP Performance Table: Long-Term Load Reduction"]
["BMP Capacity: Depth of Runoff Treated from Impervious Area (inches)",0.1,0.2,0.4,0.6,0.8,1,1.5,2]
["Runoff Volume Reduction",0.245,0.42,0.65600000000000003,0.79400000000000004,0.86799999999999999,0.91300000000000003,0.96199999999999997,0.98099999999999998]
["Cumulative Phosphorus Load Reduction",0.41,0.6,0.81,0.9,0.94,0.97,0.99,1]
["Cumulative Nitrogen Load Reduction",0.59,0.77,0.92,0.96,0.98,1,1,1]
["Cumulative TSS Load Reduction",0.67,0.94,0.96,0.99,1,1,1,1]

{"sheet":"PCInfiltrationBasin_2.41","index":25,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":true,"merged":[[0,0,0,8]]}
["Infiltration Basin (2.41 in/hr) BMP Performance Table: Long-Term Load Reduction"]
["BMP Capacity: Depth of Runoff Treated from Impervious Area (inches)",0.1,0.2,0.4,0.6,0.8,1,1.5,2]
["Runoff Volume Reduction",0.32800000000000001,0.53800000000000003,0.77800000000000002,0.88400000000000001,0.93400000000000005,0.96,0.98799999999999999,0.998]
["Cumulative Phosphorus Load Reduction",0.46,0.67,0.87,0.94,0.97,0.98,1,1]
["Cumulative Nitrogen Load Reduction",0.64,0.82,0.95,0.98,0.99,1,1,1]
["Cumulative TSS Load Reduction",0.7,0.88,0.98,1,1,1,1,1]

{"sheet":"PCInfiltrationBasin_8.27","index":26,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":true,"merged":[[0,0,0,8]]}
["Infiltration Basin (8.27 in/hr) BMP Performance Table: Long-Term Load Reduction"]
["BMP Capacity: Depth of Runoff Treated from Impervious Area (inches)",0.1,0.2,0.4,0.6,0.8,1,1.5,2]
["Runoff Volume Reduction",0.54600000000000004,0.77200000000000002,0.93400000000000005,0.97499999999999998,0.99,0.996,1,1]
["Cumulative Phosphorus Load Reduction",0.59,0.81,0.96,0.99,1,1,1,1]
["Cumulative Nitrogen Load Reduction",0.75,0.92,0.99,1,1,1,1,1]
["Cumulative TSS Load Reduction",0.79,0.95,1,1,1,1,1,1]

{"sheet":"PCSandFilter","index":27,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":true,"merged":[[0,0,0,8]]}
["Sand Filter BMP Performance Table: Long-Term Load Reduction"]
["BMP Capacity: Depth of Runoff Treated from Impervious Area (inches)",0.1,0.2,0.4,0.6,0.8,1,1.5,2]
["Cumulative Phosphorus Load Reduction",0.19,0.34,0.53,0.64,0.71,0.76,0.84,0.89]
["Cumulative Nitrogen Load Reduction",0.09,0.16,0.23,0.28000000000000003,0.31,0.32,0.37,0.4]
["Cumulative TSS Load Reduction",0,0,0,0,0,0,0,0]

{"sheet":"PCBiofiltration","index":28,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":true,"merged":[[0,0,0,8]]}
["Biofiltration BMP Performance Table: Long-Term Load Reduction"]
["BMP Capacity: Depth of Runoff Treated from Impervious Area (inches)",0.1,0.2,0.4,0.6,0.8,1,1.5,2]
["Cumulative Phosphorus Load Reduction",0.14000000000000001,0.25,0.37,0.44,0.48,0.53,0.57999999999999996,0.63]
["Cumulative Nitrogen Load Reduction",0.09,0.16,0.23,0.28000000000000003,0.31,0.32,0.37,0.4]
["Cumulative TSS Load Reduction",0.44,0.69,0.91,0.97,0.98,0.99,1,1]

{"sheet":"PCPorousPavement","index":29,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":true,"merged":[[0,0,0,4]]}
["Porous Pavement BMP Performance Table: Long-Term Load Reduction"]
["BMP Capacity: Depth of Filter Course Area (inches)",12,18,24,32]
["Cumulative Phosphorus Load Reduction",0.62,0.7,0.75,0.78]
["Cumulative Nitrogen Load Reduction",0.76,0.77,0.77,0.79]
["Cumulative TSS Load Reduction",0.92,0.94,0.96,0.97]

{"sheet":"PCBiofiltrationISR","index":30,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":true,"merged":[[0,0,0,8]]}
["Biofiltration with Internal Storage Reservoir BMP Performance Table: Long-Term Load Reduction"]
["BMP Capacity: Depth of Runoff Treated from Impervious Area (inches)",0.1,0.2,0.4,0.6,0.8,1,1.5,2]
["Cumulative Phosphorus Load Reduction",0.19,0.34,0.53,0.64,0.71,0.76,0.84,0.89]
["Cumulative Nitrogen Load Reduction",0.32,0.44,0.57999999999999996,0.66,0.71,0.75,0.82,0.86]
["Cumulative TSS Load Reduction",0.44,0.69,0.91,0.97,0.98,0.99,1,1]

{"sheet":"PCGravelWetland","index":31,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":true,"merged":[[0,0,0,8]]}
["Gravel Wetland BMP Performance Table: Long-Term Load Reduction"]
["BMP Capacity: Depth of Runoff Treated from Impervious Area (inches)",0.1,0.2,0.4,0.6,0.8,1,1.5,2]
["Cumulative Phosphorus Load Reduction",0.19,0.26,0.41,0.51,0.56999999999999995,0.61,0.65,0.66]
["Cumulative Nitrogen Load Reduction",0.22,0.33,0.48,0.56999999999999995,0.64,0.68,0.74,0.79]
["Cumulative TSS Load Reduction",0.48,0.61,0.82,0.91,0.95,0.97,0.99,0.99]

{"sheet":"PCWetPond","index":32,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":true,"merged":[[0,0,0,8]]}
["Wet Pond BMP Performance Table: Long-Term Load Reduction"]
["BMP Capacity: Depth of Runoff Treated from Impervious Area (inches)",0.1,0.2,0.4,0.6,0.8,1,1.5,2]
["Cumulative Phosphorus Load Reduction",0.14000000000000001,0.25,0.37,0.44,0.48,0.53,0.57999999999999996,0.63]
["Cumulative Nitrogen Load Reduction",0.09,0.16,0.23,0.28000000000000003,0.31,0.32,0.37,0.4]
["Cumulative TSS Load Reduction",0.3,0.44,0.6,0.68,0.74,0.77,0.83,0.86]

{"sheet":"PCDryPond","index":33,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":true,"merged":[[0,0,0,8]]}
["Dry Pond BMP Performance Table: Long-Term Load Reduction"]
["BMP Capacity: Depth of Runoff Treated from Impervious Area (inches)",0.1,0.2,0.4,0.6,0.8,1,1.5,2]
["Cumulative Phosphorus Load Reduction",0.03,0.06,0.08,0.09,0.11,0.12,0.13,0.14000000000000001]
["Cumulative Nitrogen Load Reduction",1.4014285714285712E-2,2.9098666666666672E-2,5.6940540540540541E-2,8.5569696969696962E-2,0.11261180555555556,0.1276377358490566,0.18738160919540231,0.23130158730158731]
["Cumulative TSS Load Reduction",0.18,0.31,0.38,0.4,0.44,0.46,0.47,0.49]

{"sheet":"PCGrassSwale","index":34,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":true,"merged":[[0,0,0,8]]}
["Grass Swale BMP Performance Table: Long-Term Load Reduction"]
["BMP Capacity: Depth of Runoff Treated from Impervious Area (inches)",0.1,0.2,0.4,0.6,0.8,1,1.5,2]
["Cumulative Phosphorus Load Reduction",0.02,0.05,0.09,0.13,0.17,0.21,0.28999999999999998,0.36]
["Cumulative Nitrogen Load Reduction",1.4014285714285712E-2,2.9098666666666672E-2,5.6940540540540541E-2,8.5569696969696962E-2,0.11261180555555556,0.1276377358490566,0.18738160919540231,0.23130158730158731]
["Cumulative TSS Load Reduction",0.28999999999999998,0.44,0.61,0.7,0.76,0.8,0.87,0.9]

{"sheet":"PCIADisconnectStorage_8.1","index":35,"n_rows":14,"n_cols":37,"rows_kept":14,"cut":false,"hidden":true,"merged":[[2,31,2,33],[1,13,1,24],[2,22,2,24],[2,34,2,36],[1,25,1,36],[2,13,2,15],[2,16,2,18],[2,19,2,21],[2,25,2,27],[2,28,2,30],[0,0,0,12],[2,10,2,12],[1,0,3,0],[2,1,2,3],[2,4,2,6],[2,7,2,9],[1,1,1,12]]}
["Impervious Area Disconnection through Storage : Impervious Area to Pervious Area Ratio = 8:1"]
["Storage volume to impervious area ratio (in)","TP Reduction Percentages",null,null,null,null,null,null,null,null,null,null,null,"TN Reduction Percentages",null,null,null,null,null,null,null,null,null,null,null,"TSS Reduction Percentages"]
[null,"HSG A",null,null,"HSG B",null,null,"HSG C",null,null,"HSG D",null,null,"HSG A",null,null,"HSG B",null,null,"HSG C",null,null,"HSG D",null,null,"HSG A",null,null,"HSG B",null,null,"HSG C",null,null,"HSG D"]
[null,"1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day"]
[0.1,0.24,0.23,0.22,0.24,0.23,0.22,0.24,0.23,0.22,0.22,0.22,0.21,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0.2,0.4,0.38,0.37,0.4,0.38,0.37,0.37,0.38,0.37,0.24,0.26,0.27,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0.3,0.52,0.5,0.49,0.52,0.5,0.49,0.4,0.46,0.49,0.24,0.26,0.27,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0.4,0.61,0.59,0.57999999999999996,0.59,0.59,0.57999999999999996,0.4,0.48,0.54,0.24,0.26,0.27,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0.5,0.67,0.66,0.64,0.62,0.66,0.64,0.4,0.48,0.56000000000000005,0.24,0.26,0.27,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0.6,0.7,0.71,0.7,0.62,0.7,0.7,0.4,0.48,0.56000000000000005,0.24,0.26,0.27,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0.8,0.71,0.78,0.77,0.62,0.73,0.77,0.4,0.48,0.56000000000000005,0.24,0.26,0.27,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1,0.71,0.8,0.8,0.62,0.73,0.79,0.4,0.48,0.56000000000000005,0.24,0.26,0.27,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1.5,0.71,0.81,0.87,0.62,0.73,0.81,0.4,0.48,0.56000000000000005,0.24,0.26,0.27,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[2,0.71,0.81,0.88,0.62,0.73,0.81,0.4,0.48,0.56000000000000005,0.24,0.26,0.27,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"PCIADisconnectStorage_6.1","index":36,"n_rows":14,"n_cols":37,"rows_kept":14,"cut":false,"hidden":true,"merged":[[1,13,1,24],[2,13,2,15],[2,16,2,18],[2,19,2,21],[2,22,2,24],[1,25,1,36],[2,25,2,27],[2,28,2,30],[2,31,2,33],[2,34,2,36],[0,0,0,12],[1,0,3,0],[1,1,1,12],[2,1,2,3],[2,4,2,6],[2,7,2,9],[2,10,2,12]]}
["Impervious Area Disconnection through Storage: Impervious Area to Pervious Area Ratio = 6:1"]
["Storage volume to impervious area ratio (in)","TP Reduction Percentages",null,null,null,null,null,null,null,null,null,null,null,"TN Reduction Percentages",null,null,null,null,null,null,null,null,null,null,null,"TSS Reduction Percentages"]
[null,"HSG A",null,null,"HSG B",null,null,"HSG C",null,null,"HSG D",null,null,"HSG A",null,null,"HSG B",null,null,"HSG C",null,null,"HSG D",null,null,"HSG A",null,null,"HSG B",null,null,"HSG C",null,null,"HSG D"]
[null,"1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day"]
[0.1,0.24,0.23,0.22,0.24,0.23,0.22,0.24,0.23,0.22,0.23,0.23,0.22,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0.2,0.4,0.38,0.37,0.4,0.38,0.37,0.4,0.38,0.37,0.28000000000000003,0.3,0.33,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0.3,0.52,0.5,0.49,0.52,0.5,0.49,0.47,0.5,0.49,0.28999999999999998,0.31,0.34,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0.4,0.61,0.59,0.57999999999999996,0.61,0.59,0.57999999999999996,0.48,0.55000000000000004,0.57999999999999996,0.28999999999999998,0.31,0.34,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0.5,0.67,0.66,0.64,0.67,0.66,0.64,0.48,0.56999999999999995,0.63,0.28999999999999998,0.31,0.34,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0.6,0.73,0.71,0.7,0.7,0.71,0.7,0.48,0.56999999999999995,0.65,0.28999999999999998,0.31,0.34,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0.8,0.78,0.78,0.77,0.71,0.78,0.77,0.48,0.56999999999999995,0.66,0.28999999999999998,0.31,0.34,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1,0.79,0.81,0.8,0.71,0.79,0.8,0.48,0.56999999999999995,0.66,0.28999999999999998,0.31,0.34,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1.5,0.79,0.87,0.88,0.71,0.8,0.87,0.48,0.56999999999999995,0.66,0.28999999999999998,0.31,0.34,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[2,0.79,0.87,0.91,0.71,0.8,0.87,0.48,0.56999999999999995,0.66,0.28999999999999998,0.31,0.34,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"PCIADisconnectStorage_4.1","index":37,"n_rows":14,"n_cols":37,"rows_kept":14,"cut":false,"hidden":true,"merged":[[1,13,1,24],[2,13,2,15],[2,16,2,18],[2,19,2,21],[2,22,2,24],[1,25,1,36],[2,25,2,27],[2,28,2,30],[2,31,2,33],[2,34,2,36],[0,0,0,12],[1,0,3,0],[1,1,1,12],[2,1,2,3],[2,4,2,6],[2,7,2,9],[2,10,2,12]]}
["Impervious Area Disconnection through Storage: Impervious Area to Pervious Area Ratio = 4:1"]
["Storage volume to impervious area ratio (in)","TP Reduction Percentages",null,null,null,null,null,null,null,null,null,null,null,"TN Reduction Percentages",null,null,null,null,null,null,null,null,null,null,null,"TSS Reduction Percentages"]
[null,"HSG A",null,null,"HSG B",null,null,"HSG C",null,null,"HSG D",null,null,"HSG A",null,null,"HSG B",null,null,"HSG C",null,null,"HSG D",null,null,"HSG A",null,null,"HSG B",null,null,"HSG C",null,null,"HSG D"]
[null,"1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day"]
[0.1,0.24,0.23,0.22,0.24,0.23,0.22,0.24,0.23,0.22,0.24,0.23,0.22,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0.2,0.4,0.38,0.37,0.4,0.38,0.37,0.4,0.38,0.37,0.37,0.37,0.37,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0.3,0.52,0.5,0.49,0.52,0.5,0.49,0.52,0.5,0.49,0.39,0.42,0.45,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0.4,0.61,0.59,0.57999999999999996,0.61,0.59,0.57999999999999996,0.57999999999999996,0.59,0.57999999999999996,0.39,0.42,0.47,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0.5,0.67,0.66,0.64,0.67,0.66,0.64,0.6,0.65,0.64,0.4,0.42,0.47,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0.6,0.73,0.71,0.7,0.73,0.71,0.7,0.61,0.68,0.7,0.4,0.42,0.47,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0.8,0.79,0.78,0.77,0.79,0.78,0.77,0.61,0.69,0.75,0.4,0.42,0.47,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1,0.82,0.81,0.8,0.8,0.81,0.8,0.61,0.69,0.76,0.4,0.42,0.47,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1.5,0.87,0.89,0.88,0.8,0.87,0.88,0.61,0.69,0.76,0.4,0.42,0.47,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[2,0.87,0.91,0.91,0.8,0.88,0.91,0.61,0.69,0.76,0.4,0.42,0.47,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"PCIADisconnectStorage_2.1","index":38,"n_rows":14,"n_cols":37,"rows_kept":14,"cut":false,"hidden":true,"merged":[[1,13,1,24],[2,13,2,15],[2,16,2,18],[2,19,2,21],[2,22,2,24],[1,25,1,36],[2,25,2,27],[2,28,2,30],[2,31,2,33],[2,34,2,36],[0,0,0,12],[1,0,3,0],[1,1,1,12],[2,1,2,3],[2,4,2,6],[2,7,2,9],[2,10,2,12]]}
["Impervious Area Disconnection through Storage: Impervious Area to Pervious Area Ratio = 2:1"]
["Storage volume to impervious area ratio (in)","TP Reduction Percentages",null,null,null,null,null,null,null,null,null,null,null,"TN Reduction Percentages",null,null,null,null,null,null,null,null,null,null,null,"TSS Reduction Percentages"]
[null,"HSG A",null,null,"HSG B",null,null,"HSG C",null,null,"HSG D",null,null,"HSG A",null,null,"HSG B",null,null,"HSG C",null,null,"HSG D",null,null,"HSG A",null,null,"HSG B",null,null,"HSG C",null,null,"HSG D"]
[null,"1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day"]
[0.1,0.24,0.23,0.22,0.24,0.23,0.22,0.24,0.23,0.22,0.24,0.23,0.22,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0.2,0.4,0.38,0.37,0.4,0.38,0.37,0.4,0.38,0.37,0.4,0.38,0.37,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0.3,0.52,0.5,0.49,0.52,0.5,0.49,0.52,0.5,0.49,0.51,0.5,0.49,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0.4,0.61,0.59,0.57999999999999996,0.61,0.59,0.57999999999999996,0.61,0.59,0.57999999999999996,0.56999999999999995,0.57999999999999996,0.56999999999999995,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0.5,0.67,0.66,0.64,0.67,0.66,0.64,0.67,0.66,0.64,0.59,0.62,0.63,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0.6,0.73,0.71,0.7,0.73,0.71,0.7,0.72,0.71,0.7,0.59,0.62,0.67,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0.8,0.79,0.78,0.77,0.79,0.78,0.77,0.77,0.78,0.77,0.59,0.62,0.67,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1,0.82,0.81,0.8,0.82,0.81,0.8,0.78,0.81,0.8,0.59,0.62,0.67,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1.5,0.89,0.89,0.88,0.89,0.89,0.88,0.78,0.84,0.88,0.59,0.62,0.67,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[2,0.92,0.92,0.91,0.91,0.92,0.91,0.78,0.84,0.89,0.59,0.62,0.67,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"PCIADisconnectStorage_1.1","index":39,"n_rows":14,"n_cols":37,"rows_kept":14,"cut":false,"hidden":true,"merged":[[1,13,1,24],[2,13,2,15],[2,16,2,18],[2,19,2,21],[2,22,2,24],[1,25,1,36],[2,25,2,27],[2,28,2,30],[2,31,2,33],[2,34,2,36],[0,0,0,12],[1,0,3,0],[1,1,1,12],[2,1,2,3],[2,4,2,6],[2,7,2,9],[2,10,2,12]]}
["Impervious Area Disconnection through Storage: Impervious Area to Pervious Area Ratio = 1:1"]
["Storage volume to impervious area ratio (in)","TP Reduction Percentages",null,null,null,null,null,null,null,null,null,null,null,"TN Reduction Percentages",null,null,null,null,null,null,null,null,null,null,null,"TSS Reduction Percentages"]
[null,"HSG A",null,null,"HSG B",null,null,"HSG C",null,null,"HSG D",null,null,"HSG A",null,null,"HSG B",null,null,"HSG C",null,null,"HSG D",null,null,"HSG A",null,null,"HSG B",null,null,"HSG C",null,null,"HSG D"]
[null,"1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day","1-day","2-day","3-day"]
[0.1,0.24,0.23,0.22,0.24,0.23,0.22,0.24,0.23,0.22,0.24,0.23,0.22,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0.2,0.4,0.38,0.37,0.4,0.38,0.37,0.4,0.38,0.37,0.4,0.38,0.37,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0.3,0.52,0.5,0.49,0.52,0.5,0.49,0.52,0.5,0.49,0.52,0.5,0.49,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0.4,0.61,0.59,0.57999999999999996,0.61,0.59,0.57999999999999996,0.61,0.59,0.57999999999999996,0.61,0.59,0.57999999999999996,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0.5,0.67,0.66,0.64,0.67,0.66,0.64,0.67,0.66,0.64,0.67,0.66,0.64,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0.6,0.73,0.71,0.7,0.73,0.71,0.7,0.73,0.71,0.7,0.72,0.71,0.7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0.8,0.79,0.78,0.77,0.79,0.78,0.77,0.79,0.78,0.77,0.78,0.78,0.77,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1,0.82,0.81,0.8,0.82,0.81,0.8,0.82,0.81,0.8,0.79,0.8,0.8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1.5,0.89,0.89,0.88,0.89,0.89,0.88,0.89,0.89,0.88,0.8,0.82,0.86,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[2,0.92,0.92,0.91,0.92,0.92,0.91,0.91,0.92,0.91,0.8,0.82,0.86,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"PCDisconnect","index":40,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":true,"merged":[[0,9,0,12],[0,0,1,0],[0,1,0,4],[0,5,0,8]]}
["Impervious area to pervious area ratio","Soil type of Receiving Pervious Area - Phosphorus",null,null,null,"Soil type of Receiving Pervious Area - Nitrogen",null,null,null,"Soil type of Receiving Pervious Area - TSS"]
[null,"HSG A","HSG B","HSG C","HSG D","HSG A","HSG B","HSG C","HSG D","HSG A","HSG B","HSG C","HSG D"]
[8,0.3,0.14000000000000001,7.0000000000000007E-2,0.03,0,0,0,0,0,0,0,0]
[6,0.37,0.18,0.11,0.05,0,0,0,0,0,0,0,0]
[4,0.48,0.27,0.17,0.09,0,0,0,0,0,0,0,0]
[2,0.64,0.45,0.33,0.21,0,0,0,0,0,0,0,0]
[1,0.74,0.59,0.49,0.36,0,0,0,0,0,0,0,0]
[0.5,0.82,0.67,0.6,0.49,0,0,0,0,0,0,0,0]
[0.25,0.85,0.72,0.67,0.56999999999999995,0,0,0,0,0,0,0,0]

{"sheet":"Database Structural BMPs","index":41,"n_rows":1,"n_cols":58,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["State","Town","Unique Project ID","Selected BMP Type","Active BMP (Yes/No)","Project Type","Multi Sector General Permit","Phosphorus: Calculated BMP Efficiency (%)","Phosphorus: Edit Default Efficiency (EPA Approved)","Nitrogen: Calculated BMP Efficiency (%)","Nitrogen: Edit Default Efficiency (EPA Approved)","Total Suspended Solids: Calculated BMP Efficiency (%)","Total Suspended Solids: Edit Default Efficiency (EPA Approved)","Phosphorus Load Reduction (lb/yr)","Nitrogen Load Reduction (lb/yr)","Total Suspended Solids Load Reduction (lb/yr)","Date of BMP Completion","Date of Last Inspection","Subcatchment","Receiving Water ID","Infiltration Rate (in/hr)","Storage Volume (ft^3)/ Filter Depth (in.)","BMP latitude (degree)","BMP Longitude (degree)","Address","BMP Built to Design Specification (Yes/No)","O&M Plan Provided and Reviewed (Yes/No)","Property Parcel ID","Responsible Party","Contact Phone","Number of Land Uses","Land Use Type1","Land Use Area (ac)1","Hydrologic Soil Group1","TP Calculated Land Area Loading (lb/ac/yr)1","TP Adjustment Factor1","TN Calculated Land Area Loading (lb/ac/yr)1","TN Adjustment Factor1","TSS Phosporus Calculated Land Area Loading (lb/ac/yr)1","TSS Adjustment Factor1","Land Use Type2","Land Use Area (ac)2","Hydrologic Soil Group2","TP Calculated Land Area Loading (lb/ac/yr)2","TP Adjustment Factor2","TN Calculated Land Area Loading (lb/ac/yr)2","TN Adjustment Factor2","TSS Phosporus Calculated Land Area Loading (lb/ac/yr)2","TSS Adjustment Factor2","Land Use Type3","Land Use Area (ac)3","Hydrologic Soil Group3","TP Calculated Land Area Loading (lb/ac/yr)3","TP Adjustment Factor3","TN Calculated Land Area Loading (lb/ac/yr)3","TN Adjustment Factor3","TSS Phosporus Calculated Land Area Loading (lb/ac/yr)3","TSS Adjustment Factor3"]

{"sheet":"Database Non-Structural BMPs","index":42,"n_rows":1,"n_cols":53,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["State","Town","Unique Project ID","BMP Type","Active","Phosphorus: Calculated BMP Efficiency (%)","Phosphorus: Edit Default Efficiency (EPA Approved)","Nitrogen: Calculated BMP Efficiency (%)","Nitrogen: Edit Default Efficiency (EPA Approved)","Total Suspended Solids: Calculated BMP Efficiency (%)","Total Suspended Solids: Edit Default Efficiency (EPA Approved)","Phosphorus Reduction Load (lb/yr)","Nitrogen Reduction Load  (lb/yr)","Total Suspended Sediment Reduction Load  (lb/yr)","Date of BMP Completion","Subcatchment ID","Receiving Water ID","Storage Volume (ft^3)/ Filter Depth (in.)","Receiving Pervious Area (ac)","Release Rates (days)","Pervious Area HSG","Sweeper Technology","Sweeper Frequency","Responsible Party","Contact Phone Number","Number of Land Uses","Land Use Type 1","Land Use Area (ac) 1","Hydrologic Soil Group 1","TP Calculated Land Area Loading (lb/ac/yr) 1","TP Adjustment Factor 1","TN Calculated Land Area Loading (lb/ac/yr) 1","TN Adjustment Factor 1","TSS Phosporus Calculated Land Area Loading (lb/ac/yr) 1","TSS Adjustment Factor 1","Land Use Type 2","Land Use Area (ac) 2","Hydrologic Soil Group 2","TP Calculated Land Area Loading (lb/ac/yr) 2","TP Adjustment Factor 2","TN Calculated Land Area Loading (lb/ac/yr) 2","TN Adjustment Factor 2","TSS Phosporus Calculated Land Area Loading (lb/ac/yr) 2","TSS Adjustment Factor 2","Land Use Type 3","Land Use Area (ac) 3","Hydrologic Soil Group 3","TP Calculated Land Area Loading (lb/ac/yr) 3","TP Adjustment Factor 3","TN Calculated Land Area Loading (lb/ac/yr) 3","TN Adjustment Factor 3","TSS Phosporus Calculated Land Area Loading (lb/ac/yr) 3","TSS Adjustment Factor 3"]

{"sheet":"CSV_Export","index":43,"n_rows":2,"n_cols":68,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["State","Town","Unique Project ID","Phosphorus Load Reduction (lb/yr)","Nitrogen Load Reduction  (lb/yr)","Total Suspended Solids Load Reduction  (lb/yr)","Date of Conversion Completed","Subcatchment ID","Receiving Water","Property Parcel ID","Responsible Party","Contact Phone","Number of Land Uses After","Number of Land Uses Before","Lande Use Type","Land Use Area (ac)","Hydrologic Soil Group","TP Calculated Land Area Loading (lb/ac/yr)","TN Adjustment Factor","TN Calculated Land Area Loading (lb/ac/yr)","TN Adjustment Factor","TSS Phosporus Calculated Land Area Loading (lb/ac/yr)","TSS Adjustment Factor","Lande Use Type","Land Use Area (ac)","Hydrologic Soil Group","TP Calculated Land Area Loading (lb/ac/yr)","TN Adjustment Factor","TN Calculated Land Area Loading (lb/ac/yr)","TN Adjustment Factor","TSS Phosporus Calculated Land Area Loading (lb/ac/yr)","TSS Adjustment Factor","Lande Use Type","Land Use Area (ac)","Hydrologic Soil Group","TP Calculated Land Area Loading (lb/ac/yr)","TN Adjustment Factor","TN Calculated Land Area Loading (lb/ac/yr)","TN Adjustment Factor","TSS Phosporus Calculated Land Area Loading (lb/ac/yr)","TSS Adjustment Factor","Lande Use Type","Land Use Area (ac)","Hydrologic Soil Group","TP Calculated Land Area Loading (lb/ac/yr)","TN Adjustment Factor","TN Calculated Land Area Loading (lb/ac/yr)","TN Adjustment Factor","TSS Phosporus Calculated Land Area Loading (lb/ac/yr)","TSS Adjustment Factor","Lande Use Type","Land Use Area (ac)","Hydrologic Soil Group","TP Calculated Land Area Loading (lb/ac/yr)","TN Adjustment Factor","TN Calculated Land Area Loading (lb/ac/yr)","TN Adjustment Factor","TSS Phosporus Calculated Land Area Loading (lb/ac/yr)","TSS Adjustment Factor","Lande Use Type","Land Use Area (ac)","Hydrologic Soil Group","TP Calculated Land Area Loading (lb/ac/yr)","TN Adjustment Factor","TN Calculated Land Area Loading (lb/ac/yr)","TN Adjustment Factor","TSS Phosporus Calculated Land Area Loading (lb/ac/yr)","TSS Adjustment Factor"]
["MASSACHUSETTS","ARLINGTON","LUCONV101",-11,-64.7,-2047.55,"2016-05-01","SWS101","RCH101","PP101","JS","(999) 999-9999",1,1,"HIGH DENSITY RESIDENTIAL (P)",5,"B",0.12,1,1.1599999999999999,1,29.44,1,"HIGH DENSITY RESIDENTIAL (I)",5,"N/A",2.3199999999999998,1,14.1,1,438.95,1]

{"sheet":"Database Land Use Conversions","index":44,"n_rows":1,"n_cols":68,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["State","Town","Unique Project ID","Phosphorus Load Reduction (lb/yr)","Nitrogen Load Reduction  (lb/yr)","Total Suspended Solids Load Reduction  (lb/yr)","Date of Conversion Completed","Subcatchment ID","Receiving Water","Property Parcel ID","Responsible Party","Contact Phone","Number of Land Uses After","Number of Land Uses Before","Lande Use Type","Land Use Area (ac)","Hydrologic Soil Group","TP Calculated Land Area Loading (lb/ac/yr)","TN Adjustment Factor","TN Calculated Land Area Loading (lb/ac/yr)","TN Adjustment Factor","TSS Phosporus Calculated Land Area Loading (lb/ac/yr)","TSS Adjustment Factor","Lande Use Type","Land Use Area (ac)","Hydrologic Soil Group","TP Calculated Land Area Loading (lb/ac/yr)","TN Adjustment Factor","TN Calculated Land Area Loading (lb/ac/yr)","TN Adjustment Factor","TSS Phosporus Calculated Land Area Loading (lb/ac/yr)","TSS Adjustment Factor","Lande Use Type","Land Use Area (ac)","Hydrologic Soil Group","TP Calculated Land Area Loading (lb/ac/yr)","TN Adjustment Factor","TN Calculated Land Area Loading (lb/ac/yr)","TN Adjustment Factor","TSS Phosporus Calculated Land Area Loading (lb/ac/yr)","TSS Adjustment Factor","Lande Use Type","Land Use Area (ac)","Hydrologic Soil Group","TP Calculated Land Area Loading (lb/ac/yr)","TN Adjustment Factor","TN Calculated Land Area Loading (lb/ac/yr)","TN Adjustment Factor","TSS Phosporus Calculated Land Area Loading (lb/ac/yr)","TSS Adjustment Factor","Lande Use Type","Land Use Area (ac)","Hydrologic Soil Group","TP Calculated Land Area Loading (lb/ac/yr)","TN Adjustment Factor","TN Calculated Land Area Loading (lb/ac/yr)","TN Adjustment Factor","TSS Phosporus Calculated Land Area Loading (lb/ac/yr)","TSS Adjustment Factor","Lande Use Type","Land Use Area (ac)","Hydrologic Soil Group","TP Calculated Land Area Loading (lb/ac/yr)","TN Adjustment Factor","TN Calculated Land Area Loading (lb/ac/yr)","TN Adjustment Factor","TSS Phosporus Calculated Land Area Loading (lb/ac/yr)","TSS Adjustment Factor"]

{"sheet":"ExportProject","index":45,"n_rows":10,"n_cols":41,"rows_kept":10,"cut":false,"hidden":true,"merged":[[2,0,2,4],[2,6,2,17],[2,19,2,29],[2,31,2,35]]}
[1,2,3,4,5,6,7,8,9,10,11,12,13,15,17,19,20,21,22,23,24,25,26,27,28,30,32,34,35,36,37,38,40,42,44,45,46,47,48,49]
[null,"Table 1. Project Summary Credit for",null,null,null,null,"Table 2. Structural Project Summary for",null,null,null,null,null,null,null,null,null,null,null,null,"Table 3. Non-Structural Project Summary for",null,null,null,null,null,null,null,null,null,null,null,"Table 4. Land Use Conversion Project Summary for"]
[{"$f":"(B2&\" \"&Scratch!G1)","v":"Table 1. Project Summary Credit for ARLINGTON"},null,null,null,null,null,{"$f":"(G2&\" \"&Scratch!G1)","v":"Table 2. Structural Project Summary for ARLINGTON"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(T2&\" \"&Scratch!G1)","v":"Table 3. Non-Structural Project Summary for ARLINGTON"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AF2&\" \"&Scratch!G1)","v":"Table 4. Land Use Conversion Project Summary for ARLINGTON"},null,null,null,null,null,null,null,{"$f":"(G2&\" \"&Scratch!G1)","v":"Table 2. Structural Project Summary for ARLINGTON"}]
[null,null,"Removed Phosphorus Load (lb/yr)","Removed Nitrogen Load (lb/yr)","Removed Sediment Load (lb/yr)",null,null,"Project ID","BMP Type","BMP Storage Capacity (ft3)/ Filter Depth (in.)","Phosphorus BMP Efficiency (%)","Nitrogen BMP Efficiency (%)","Sediment BMP Efficiency (%)","Removed Phosphorus Load (lb/yr)","Removed Nitrogen Load (lb/yr)","Removed Sediment Load (lb/yr)","Impervious Area Treated (ac)","Runoff Depth (in.)",null,"Project ID","BMP Type","BMP Storage Capacity","Phosphorus BMP Efficiency (%)","Nitrogen BMP Efficiency (%)","Sediment BMP  Efficiency (%)","Removed Phosphorus Load (lb/yr)","Removed Nitrogen Load  (lb/yr)","Removed Sediment Load  (lb/yr)","Impervious Area Treated (ac)","Runoff Depth (in.)",null,"Project ID","Removed Phosphorus Load (lb/yr)","Removed Nitrogen Load (lb/yr)","Removed Sediment Load  (lb/yr)","Impervious Area Treated (ac)",null,null,null,null,"There are no structural BMPs."]
[null,"Structural",7.58,56.89,1939.18,null,null,"INFIL101","INFILTRATION BASIN",5250,65.37,80.69,88.36,7.58,56.89,1939.18,5,0.28999999999999998,null,"SWEEP101","ENHANCED SWEEPING PROGRAM","N/A",8,0,0,0.71,0,0,5,"N/A",null,"LUCONV101",-11,-64.7,-2047.55,5]
[null,"Non-Structural",0.71,0,0,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,null,null,{"$f":"(T2&\" \"&Scratch!G1)","v":"Table 3. Non-Structural Project Summary for ARLINGTON"}]
[null,"Land Use Conversion",-11,-64.7,-2047.55,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,null,null,null,"There are no non-structural BMPs."]
[null,"Total",-2.7,-7.81,-108.37]
[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,null,null,null,null,null,null,null,{"$f":"(AF2&\" \"&Scratch!G1)","v":"Table 4. Land Use Conversion Project Summary for ARLINGTON"}]
[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,null,null,null,null,null,null,null,null,"There are no land use conversion projects."]

{"sheet":"Import Structural BMPs","index":46,"n_rows":10,"n_cols":58,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["State","Town","Unique Project ID","Selected BMP Type","Active BMP (Yes/No)","Project Type","Multi Sector General Permit","Phosphorus: Calculated BMP Efficiency (%)","Phosphorus: Edit Default Efficiency (EPA Approved)","Nitrogen: Calculated BMP Efficiency (%)","Nitrogen: Edit Default Efficiency (EPA Approved)","Total Suspended Solids: Calculated BMP Efficiency (%)","Total Suspended Solids: Edit Default Efficiency (EPA Approved)","Phosphorus Load Reduction (lb/yr)","Nitrogen Load Reduction (lb/yr)","Total Suspended Solids Load Reduction (lb/yr)","Date of BMP Completion","Date of Last Inspection","Subcatchment","Receiving Water ID","Infiltration Rate (in/hr)","Storage Volume (ft^3)/ Filter Depth (in.)","BMP latitude (degree)","BMP Longitude (degree)","Address","BMP Built to Design Specification (Yes/No)","O&M Plan Provided and Reviewed (Yes/No)","Property Parcel ID","Responsible Party","Contact Phone","Number of Land Uses","Land Use Type1","Land Use Area (ac)1","Hydrologic Soil Group1","TP Calculated Land Area Loading (lb/ac/yr)1","TP Adjustment Factor1","TN Calculated Land Area Loading (lb/ac/yr)1","TN Adjustment Factor1","TSS Phosporus Calculated Land Area Loading (lb/ac/yr)1","TSS Adjustment Factor1","Land Use Type2","Land Use Area (ac)2","Hydrologic Soil Group2","TP Calculated Land Area Loading (lb/ac/yr)2","TP Adjustment Factor2","TN Calculated Land Area Loading (lb/ac/yr)2","TN Adjustment Factor2","TSS Phosporus Calculated Land Area Loading (lb/ac/yr)2","TSS Adjustment Factor2","Land Use Type3","Land Use Area (ac)3","Hydrologic Soil Group3","TP Calculated Land Area Loading (lb/ac/yr)3","TP Adjustment Factor3","TN Calculated Land Area Loading (lb/ac/yr)3","TN Adjustment Factor3","TSS Phosporus Calculated Land Area Loading (lb/ac/yr)3","TSS Adjustment Factor3"]
["MASSACHUSETTS","ARLINGTON","B101","BIORETENTION","NO","New Development","No",0,"NO",0,"NO",0,"NO",0,0,0,"2016-12-31",null,"SWS101","RCH101","N/A",5250,"N/A","N/A",1263,"No","No","N/A","N/A","N/A",1,"INDUSTRIAL (I)",5,"N/A",1.78,1,15.08,1,377.39,1]
["MASSACHUSETTS","ARLINGTON","EB101","ENHANCED BIORETENTION","Yes","New Development","No",45.853994490358119,"NO",50.853994490358126,"NO",0,"NO",4.3,36.200000000000003,0,"2016-01-01",null,"SWS101","RCH101","N/A",7570,"N/A","N/A",123,"No","No","N/A","N/A","N/A",2,"FOREST (P)",0,"N/A",0.12,1,0.54,1,29.44,1,"HIGHWAY (I)",7,"N/A",1.34,1,10.17,1,1480.13,1]
["MASSACHUSETTS","ARLINGTON","DRY101","EXTENDED DRY DETENTION POND","Yes","New Development","No",12.98438934802572,"NO",0,"NO",46.984389348025715,"NO",3.61,0,2474.86,"2016-01-01",null,"N/A","N/A","N/A",65000,"N/A","N/A",123,"No","No","N/A","N/A","N/A",1,"HIGH DENSITY RESIDENTIAL (I)",12,"N/A",2.3199999999999998,1,14.1,1,438.95,1]
["MASSACHUSETTS","ARLINGTON","GS101","GRASS SWALE (CONVEYANCE)","Yes","New Development","No",24.834710743801601,"NO",0,"NO",83.355371900826398,"NO",6.91,0,4390.66,"2016-01-01",null,"N/A","N/A","N/A",54000,"N/A","N/A",123,"No","No","N/A","N/A","N/A",1,"HIGH DENSITY RESIDENTIAL (I)",12,"N/A",2.3199999999999998,1,14.1,1,438.95,1]
["MASSACHUSETTS","ARLINGTON","GW101","GRAVEL WETLAND","Yes","New Development","No",36.826446280991746,"NO",43.826446280991746,"NO",76.157024793388445,"NO",10.25,74.150000000000006,4011.5,"2016-01-01",null,"N/A","N/A","N/A",15000,"N/A","N/A",123,"No","No","N/A","N/A","N/A",1,"HIGH DENSITY RESIDENTIAL (I)",12,"N/A",2.3199999999999998,1,14.1,1,438.95,1]
["MASSACHUSETTS","ARLINGTON","IT101","INFILTRATION TRENCH","Yes","New Development","No",98.8,"NO",100,"NO",100,"NO",27.51,169.2,5267.4,"2016-01-01",null,"N/A","N/A",2.41,98765,"N/A","N/A",123,"No","No","N/A","N/A","N/A",1,"HIGH DENSITY RESIDENTIAL (I)",12,"N/A",2.3199999999999998,1,14.1,1,438.95,1]
["MASSACHUSETTS","ARLINGTON","PP101","POROUS PAVEMENT","Yes","New Development","No",0,"N/A",0,"N/A",0,"N/A",0,0,0,"2016-01-01",null,"N/A","N/A","N/A",0,"N/A","N/A",123,"No","No","N/A","N/A","N/A",1,"HIGH DENSITY RESIDENTIAL (I)",12,"N/A",2.3199999999999998,1,14.1,1,438.95,1]
["MASSACHUSETTS","ARLINGTON","SI101","SURFACE INFILTRATION","Yes","New Development","No",89.2,"NO",97,"NO",99,"NO",24.83,164.12,5214.7299999999996,"2016-01-01",null,"N/A","N/A",0.17,567980,"N/A","N/A",123,"No","No","N/A","N/A","N/A",1,"HIGH DENSITY RESIDENTIAL (I)",12,"N/A",2.3199999999999998,1,14.1,1,438.95,1]
["MASSACHUSETTS","ARLINGTON","WP101","WET POND/CREATED WETLAND","Yes","New Development","No",45.774104683195596,"NO",51.548209366391205,"NO",70.661157024793397,"NO",12.74,87.22,3722.01,"2016-01-01",null,"N/A","N/A","N/A",30000,"N/A","N/A",123,"No","No","N/A","N/A","N/A",1,"HIGH DENSITY RESIDENTIAL (I)",12,"N/A",2.3199999999999998,1,14.1,1,438.95,1]

{"sheet":"Import Non-Structural BMPs","index":47,"n_rows":7,"n_cols":53,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["State","Town","Unique Project ID","BMP Type","Active","Phosphorus: Calculated BMP Efficiency (%)","Phosphorus: Edit Default Efficiency (EPA Approved)","Nitrogen: Calculated BMP Efficiency (%)","Nitrogen: Edit Default Efficiency (EPA Approved)","Total Suspended Solids: Calculated BMP Efficiency (%)","Total Suspended Solids: Edit Default Efficiency (EPA Approved)","Phosphorus Reduction Load (lb/yr)","Nitrogen Reduction Load  (lb/yr)","Total Suspended Sediment Reduction Load  (lb/yr)","Date of BMP Completion","Subcatchment ID","Receiving Water ID","Storage Volume (ft^3)/ Filter Depth (in.)","Receiving Pervious Area (ac)","Release Rates (days)","Pervious Area HSG","Sweeper Technology","Sweeper Frequency","Responsible Party","Contact Phone Number","Number of Land Uses","Land Use Type 1","Land Use Area (ac) 1","Hydrologic Soil Group 1","TP Calculated Land Area Loading (lb/ac/yr) 1","TP Adjustment Factor 1","TN Calculated Land Area Loading (lb/ac/yr) 1","TN Adjustment Factor 1","TSS Phosporus Calculated Land Area Loading (lb/ac/yr) 1","TSS Adjustment Factor 1","Land Use Type 2","Land Use Area (ac) 2","Hydrologic Soil Group 2","TP Calculated Land Area Loading (lb/ac/yr) 2","TP Adjustment Factor 2","TN Calculated Land Area Loading (lb/ac/yr) 2","TN Adjustment Factor 2","TSS Phosporus Calculated Land Area Loading (lb/ac/yr) 2","TSS Adjustment Factor 2","Land Use Type 3","Land Use Area (ac) 3","Hydrologic Soil Group 3","TP Calculated Land Area Loading (lb/ac/yr) 3","TP Adjustment Factor 3","TN Calculated Land Area Loading (lb/ac/yr) 3","TN Adjustment Factor 3","TSS Phosporus Calculated Land Area Loading (lb/ac/yr) 3","TSS Adjustment Factor 3"]
["MASSACHUSETTS","ARLINGTON","CBC101","CATCH BASIN CLEANING","NO",0,"NO",0,"NO",0,"NO",0,0,0,"12/31/2-15","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A",1,"OPEN LAND (I)",45,"N/A",1.52,1,11.33,1,649.51,1]
["MASSACHUSETTS","ARLINGTON","IADISCONN101","IMPERVIOUS AREA DISCONNECTION","Yes",67.882853788326202,"No",0,"No",0,"No",46.431871991215125,0,0,"12/31/2-15","N/A","N/A","N/A",4300000,"N/A","B","N/A","N/A","N/A","N/A",1,"OPEN LAND (I)",45,"N/A",1.52,1,11.33,1,649.51,1]
["MASSACHUSETTS","ARLINGTON","IADISCONNS101","IMPERVIOUS AREA DISCONNECTION THROUGH STORAGE","Yes",60.812672176308538,"No",0,"No",0,"No",41.595867768595042,0,0,"12/31/2-15","N/A","N/A",65000,4500000,1,"B","N/A","N/A","N/A","N/A",1,"OPEN LAND (I)",45,"N/A",1.52,1,11.33,1,649.51,1]
["MASSACHUSETTS","ARLINGTON","NoFert","NO APPLICATION OF FERTILIZERS CONTAINING PHOSPHORUS","Yes",50,"NO",0,"NO",0,"NO",1.9860583643999496,0,0,"12/31/2-15","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A",1,"OPEN LAND (I)",45,"N/A",1.52,1,11.33,1,649.51,1]
["MASSACHUSETTS","ARLINGTON","LL101","ORGANIC WASTE/LEAF LITTER COLLECTION PROGRAM","Yes",5,"NO",0,"NO",0,"NO",3.4200000000000004,0,0,"12/31/2-15","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A",1,"OPEN LAND (I)",45,"N/A",1.52,1,11.33,1,649.51,1]
["MASSACHUSETTS","ARLINGTON","ESP101","ENHANCED SWEEPING PROGRAM","Yes","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","12/31/2-15","N/A","N/A","N/A","N/A","N/A","N/A","N/A","TWICE/YEAR (SPRING AND FALL)","N/A","N/A",-999,"OPEN LAND (I)",45,"N/A","N/A","N/A","N/A","N/A","N/A","N/A"]

{"sheet":"Import Land Use Conversions","index":48,"n_rows":2,"n_cols":68,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["State","Town","Unique Project ID","Phosphorus Load Reduction (lb/yr)","Nitrogen Load Reduction  (lb/yr)","Total Suspended Solids Load Reduction  (lb/yr)","Date of Conversion Completed","Subcatchment ID","Receiving Water","Property Parcel ID","Responsible Party","Contact Phone","Number of Land Uses After","Number of Land Uses Before","Lande Use Type","Land Use Area (ac)","Hydrologic Soil Group","TP Calculated Land Area Loading (lb/ac/yr)","TN Adjustment Factor","TN Calculated Land Area Loading (lb/ac/yr)","TN Adjustment Factor","TSS Phosporus Calculated Land Area Loading (lb/ac/yr)","TSS Adjustment Factor","Lande Use Type","Land Use Area (ac)","Hydrologic Soil Group","TP Calculated Land Area Loading (lb/ac/yr)","TN Adjustment Factor","TN Calculated Land Area Loading (lb/ac/yr)","TN Adjustment Factor","TSS Phosporus Calculated Land Area Loading (lb/ac/yr)","TSS Adjustment Factor","Lande Use Type","Land Use Area (ac)","Hydrologic Soil Group","TP Calculated Land Area Loading (lb/ac/yr)","TN Adjustment Factor","TN Calculated Land Area Loading (lb/ac/yr)","TN Adjustment Factor","TSS Phosporus Calculated Land Area Loading (lb/ac/yr)","TSS Adjustment Factor","Lande Use Type","Land Use Area (ac)","Hydrologic Soil Group","TP Calculated Land Area Loading (lb/ac/yr)","TN Adjustment Factor","TN Calculated Land Area Loading (lb/ac/yr)","TN Adjustment Factor","TSS Phosporus Calculated Land Area Loading (lb/ac/yr)","TSS Adjustment Factor","Lande Use Type","Land Use Area (ac)","Hydrologic Soil Group","TP Calculated Land Area Loading (lb/ac/yr)","TN Adjustment Factor","TN Calculated Land Area Loading (lb/ac/yr)","TN Adjustment Factor","TSS Phosporus Calculated Land Area Loading (lb/ac/yr)","TSS Adjustment Factor","Lande Use Type","Land Use Area (ac)","Hydrologic Soil Group","TP Calculated Land Area Loading (lb/ac/yr)","TN Adjustment Factor","TN Calculated Land Area Loading (lb/ac/yr)","TN Adjustment Factor","TSS Phosporus Calculated Land Area Loading (lb/ac/yr)","TSS Adjustment Factor"]
["MASSACHUSETTS","ARLINGTON","LUC101",158.6,1366,34554,"2015-12-31","N/A","N/A","N/A","N/A","N/A",1,5,"COMMERCIAL (I)",100,"N/A",1.78,1,15.08,1,377.39,1,"AGRICULTURE (P)",20,"N/A",0.45,1,2.59,1,29.44,1,"FOREST (P)",20,"N/A",0.12,1,0.54,1,29.44,1,"OPEN LAND (P)",40,"B",0.12,1,1.1599999999999999,1,29.44,1,"HIGH DENSITY RESIDENTIAL (P)",10,"C/D",0.28999999999999998,1,3.03,1,75.84,1,"INDUSTRIAL (P)",10,"A",0.03,1,0.27,1,7.14,1]