{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Pre LOD","Post LOD"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":22,"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":"Pre LOD","index":0,"n_rows":100,"n_cols":23,"rows_kept":100,"cut":false,"hidden":false,"merged":[[0,2,0,14],[1,2,1,14],[2,2,2,14],[4,2,5,2],[88,1,88,3],[3,4,3,14],[3,0,3,1]]}
[null,"PROJECT:"]
[null,"STANDARD PLAN TYPE:","Non-residential <1.0ac disturbed"]
[null,"PARCEL AREA (ACRES):"]
["PRE-DEVELOPMENT LOD CN\nENTER AREAS ONLY WITHIN THE LOD",null,null,null,"Curve Numbers for Hydrologic Soil Type"]
["Cover Type","Treatment","Hydrologic Condition",null,"A",null,null,"B",null,null,"C",null,null,"D"]
[null,null,null,null,"Acres","RCN",{"$f":"IF(AND(E6>0,E6<10000),E6*F6,0)","v":0},"Acres","RCN",{"$f":"IF(AND(H6>0,H6<10000),H6*I6,0)","v":0},"Acres","RCN",{"$f":"IF(AND(K6>0,K6<10000),K6*L6,0)","v":0},"Acres","RCN",{"$f":"IF(AND(N6>0,N6<10000),N6*O6,0)","v":0}]
["CULTIVATED AGRICULTURAL LANDS   "]
["Fallow","              Bare soil","----",null,null,"77",{"$f":"ROUND(IF(AND(E8>0,E8<10000),E8*F8,0),2)","v":0},null,"86",{"$f":"ROUND(IF(AND(H8>0,H8<10000),H8*I8,0),2)","v":0},null,"91",{"$f":"ROUND(IF(AND(K8>0,K8<10000),K8*L8,0),2)","v":0},null,"94",{"$f":"ROUND(IF(AND(N8>0,N8<10000),N8*O8,0),2)","v":0},"-----------"]
[null,"              Crop residue (CR)","poor",null,null,"76",{"$f":"ROUND(IF(AND(E9>0,E9<10000),E9*F9,0),2)","v":0},null,"85",{"$f":"ROUND(IF(AND(H9>0,H9<10000),H9*I9,0),2)","v":0},null,"90",{"$f":"ROUND(IF(AND(K9>0,K9<10000),K9*L9,0),2)","v":0},null,"93",{"$f":"ROUND(IF(AND(N9>0,N9<10000),N9*O9,0),2)","v":0},"-----------"]
[null,"              Crop residue (CR)","good",null,null,"74",0,null,"83",0,null,"88",0,null,"90",0,"-----------"]
["Row Crops","              Straight row (SR)","poor",null,null,"72",0,null,"81",0,null,"88",0,null,"91",0,"-----------"]
[null,"              Straight row (SR)","good",null,null,"67",0,null,"78",0,null,"85",0,null,"89",0,"-----------"]
[null,"              SR + Crop residue","poor",null,null,"71",0,null,"80",0,null,"87",0,null,"90",0,"-----------"]
[null,"              SR + Crop residue","good",null,null,"64",0,null,"75",0,null,"82",0,null,"85",0,"-----------"]
[null,"              Contoured (C)","poor",null,null,"70",0,null,"79",0,null,"84",0,null,"88",0,"-----------"]
[null,"              Contoured (C)","good",null,null,"65",0,null,"75",0,null,"82",0,null,"86",0,"-----------"]
[null,"              C + Crop residue","poor",null,null,"69",0,null,"78",0,null,"83",0,null,"87",0,"-----------"]
[null,"              C + Crop residue","good",null,null,"64",0,null,"74",0,null,"81",0,null,"85",0,"-----------"]
[null,"              Cont & terraced(C&T)","poor",null,null,"66",0,null,"74",0,null,"80",0,null,"82",0,"-----------"]
[null,"              Cont & terraced(C&T)","good",null,null,"62",0,null,"71",0,null,"78",0,null,"81",0,"-----------"]
[null,"              C&T + Crop residue","poor",null,null,"65",0,null,"73",0,null,"79",0,null,"81",0,"-----------"]
[null,"              C&T + Crop residue","good",null,null,"61",0,null,"70",0,null,"77",0,null,"80",0,"-----------"]
["Small Grain","              Straight row (SR)","poor",null,null,"65",0,null,"76",0,null,"84",0,null,"88",0,"-----------"]
[null,"              Straight row (SR)","good",null,null,"63",0,null,"75",0,null,"83",0,null,"87",0,"-----------"]
[null,"              SR + Crop residue","poor",null,null,"64",0,null,"75",0,null,"83",0,null,"86",0,"-----------"]
[null,"              SR + Crop residue","good",null,null,"60",0,null,"72",0,null,"80",0,null,"84",0,"-----------"]
[null,"              Contoured (C)","poor",null,null,"63",0,null,"74",0,null,"82",0,null,"85",0,"-----------"]
[null,"              Contoured (C)","good",null,null,"61",0,null,"73",0,null,"81",0,null,"84",0,"-----------"]
[null,"              C + Crop residue","poor",null,null,"62",0,null,"73",0,null,"81",0,null,"84",0,"-----------"]
[null,"              C + Crop residue","good",null,null,"60",0,null,"72",0,null,"80",0,null,"83",0,"-----------"]
[null,"              Cont & terraced(C&T)","poor",null,null,"61",0,null,"72",0,null,"79",0,null,"82",0,"-----------"]
[null,"              Cont & terraces(C&T)","good",null,null,"59",0,null,"70",0,null,"78",0,null,"81",0,"-----------"]
[null,"              C&T + Crop residue","poor",null,null,"60",0,null,"71",0,null,"78",0,null,"81",0,"-----------"]
[null,"              C&T + Crop residue","good",null,null,"58",0,null,"69",0,null,"77",0,null,"80",0,"-----------"]
["Close-seeded","              Straight row","poor",null,null,"66",0,null,"77",0,null,"85",0,null,"89",0,"-----------"]
["or broadcast","              Straight row","good",null,null,"58",0,null,"72",0,null,"81",0,null,"85",0,"-----------"]
["legumes or","              Contoured","poor",null,null,"64",0,null,"75",0,null,"83",0,null,"85",0,"-----------"]
["rotation","              Contoured","good",null,null,"55",0,null,"69",0,null,"78",0,null,"83",0,"-----------"]
["meadow","              Cont & terraced","poor",null,null,"63",0,null,"73",0,null,"80",0,null,"83",0,"-----------"]
[null,"              Cont & terraced","good",null,null,"51",0,null,"67",0,null,"76",0,null,"80",0,"-----------"]
[]
["OTHER AGRICULTURAL LANDS       ",null,null,null,null,"  ",null,null,null,null,null,null,null,null,"  "]
[null,"Pasture, grassland or range ","poor",null,null,"68",{"$f":"ROUND(IF(AND(E43>0,E43<10000),E43*F43,0),2)","v":0},null,"79",{"$f":"ROUND(IF(AND(H43>0,H43<10000),H43*I43,0),2)","v":0},null,"86",{"$f":"ROUND(IF(AND(K43>0,K43<10000),K43*L43,0),2)","v":0},null,"89",{"$f":"ROUND(IF(AND(N43>0,N43<10000),N43*O43,0),2)","v":0},"-----------"]
[null,"                            ","fair",null,null,"49",0,null,"69",0,null,"79",0,null,"84",0,"-----------"]
[null,"                            ","good",null,null,"39",0,null,"61",0,null,"74",0,null,"80",0,"-----------"]
[null,"Meadow -cont. grass (non grazed) ","----",null,null,"30",0,null,"58",0,null,"71",0,null,"78",0,"-----------"]
[null,"Brush - brush, weed, grass mix ","poor",null,null,"48",0,null,"67",0,null,"77",0,null,"83",0,"-----------"]
[null,"                               ","fair",null,null,"35",0,null,"56",0,null,"70",0,null,"77",0,"-----------"]
[null,"                               ","good",null,null,"30",0,null,"48",0,null,"65",0,null,"73",0,"-----------"]
[null,"Woods - grass combination ","poor",null,null,"57",0,null,"73",0,null,"82",0,null,"86",0,"-----------"]
[null,"                          ","fair",null,null,"43",0,null,"65",0,null,"76",0,null,"82",0,"-----------"]
[null,"                          ","good",null,null,"32",0,null,"58",0,null,"72",0,null,"79",0,"-----------"]
[null,"Woods ","poor",null,null,"45",0,null,"66",0,null,"77",0,null,"83",0,"-----------",null,null,null,null,null,"Project Type"]
[null,"      ","fair",null,null,"36",0,null,"60",0,null,"73",0,null,"79",0,"-----------"]
[null,"      ","good",null,null,"30",0,null,"55",0,null,"70",0,null,"77",0,"-----------",null,null,null,null,null,"Detailed"]
[null,"Farmsteads ","----",null,null,"59",0,null,"74",0,null,"82",0,null,"86",0,"-----------",null,null,null,null,null,"Standard"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"County"]
["FULLY DEVELOPED URBAN AREAS (Veg Established)"]
["Open space (Lawns,parks etc.)   ",null,null,null,null,"  ",null,null,"  ",null,null,"  ",null,null,"  ",null,null,null,null,null,null,null,"New Castle"]
[null,"   Poor condition; grass cover < 50%",null,null,null,"68",{"$f":"ROUND(IF(AND(E60>0,E60<10000),E60*F60,0),2)","v":0},null,"79",{"$f":"ROUND(IF(AND(H60>0,H60<10000),H60*I60,0),2)","v":0},null,"86",{"$f":"ROUND(IF(AND(K60>0,K60<10000),K60*L60,0),2)","v":0},null,"89",{"$f":"ROUND(IF(AND(N60>0,N60<10000),N60*O60,0),2)","v":0},"-----------",null,null,null,null,null,"New Castle (Incorp.)"]
[null,"   Fair condition; grass cover 50% to 75 %",null,null,null,"49",{"$f":"ROUND(IF(AND(E61>0,E61<10000),E61*F61,0),2)","v":0},null,"69",{"$f":"ROUND(IF(AND(H61>0,H61<10000),H61*I61,0),2)","v":0},null,"79",{"$f":"ROUND(IF(AND(K61>0,K61<10000),K61*L61,0),2)","v":0},null,"84",{"$f":"ROUND(IF(AND(N61>0,N61<10000),N61*O61,0),2)","v":0},"-----------",null,null,null,null,null,"Kent"]
[null,"   Good condition; grass cover > 75%",null,null,null,"39",{"$f":"ROUND(IF(AND(E62>0,E62<10000),E62*F62,0),2)","v":0},null,"61",{"$f":"ROUND(IF(AND(H62>0,H62<10000),H62*I62,0),2)","v":0},null,"74",{"$f":"ROUND(IF(AND(K62>0,K62<10000),K62*L62,0),2)","v":0},null,"80",{"$f":"ROUND(IF(AND(N62>0,N62<10000),N62*O62,0),2)","v":0},"-----------",null,null,null,null,null,"Sussex"]
["Impervious Areas      ",null,null,null,null,"  ",null,null,null,null,null,null,null,null,"  "]
[null,"  Paved parking lots, roofs, driveways",null,null,null,"98",{"$f":"ROUND(IF(AND(E64>0,E64<10000),E64*F64,0),2)","v":0},null,"98",{"$f":"ROUND(IF(AND(H64>0,H64<10000),H64*I64,0),2)","v":0},null,"98",{"$f":"ROUND(IF(AND(K64>0,K64<10000),K64*L64,0),2)","v":0},null,"98",{"$f":"ROUND(IF(AND(N64>0,N64<10000),N64*O64,0),2)","v":0},"-----------",null,null,null,null,null,"Unit Hydrograph"]
[null,"  Streets and roads      ",null,null,null,"  ",null,null,null,null,null,null,null,null,"  "]
[null,"      Paved; curbs and storm sewers","",null,null,"98",{"$f":"ROUND(IF(AND(E66>0,E66<10000),E66*F66,0),2)","v":0},null,"98",{"$f":"ROUND(IF(AND(H66>0,H66<10000),H66*I66,0),2)","v":0},null,"98",{"$f":"ROUND(IF(AND(K66>0,K66<10000),K66*L66,0),2)","v":0},null,"98",{"$f":"ROUND(IF(AND(N66>0,N66<10000),N66*O66,0),2)","v":0},"-----------",null,null,null,null,null,"DMV"]
[null,"     Paved; open ditches (w/right-of-way)",null,null,null,"83",{"$f":"ROUND(IF(AND(E67>0,E67<10000),E67*F67,0),2)","v":0},null,"89",{"$f":"ROUND(IF(AND(H67>0,H67<10000),H67*I67,0),2)","v":0},null,"92",{"$f":"ROUND(IF(AND(K67>0,K67<10000),K67*L67,0),2)","v":0},null,"93",{"$f":"ROUND(IF(AND(N67>0,N67<10000),N67*O67,0),2)","v":0},"-----------",null,null,null,null,null,"STD"]
[null,"     Gravel (w/ right-of-way)",null,null,null,"76",{"$f":"ROUND(IF(AND(E68>0,E68<10000),E68*F68,0),2)","v":0},null,"85",{"$f":"ROUND(IF(AND(H68>0,H68<10000),H68*I68,0),2)","v":0},null,"89",{"$f":"ROUND(IF(AND(K68>0,K68<10000),K68*L68,0),2)","v":0},null,"91",{"$f":"ROUND(IF(AND(N68>0,N68<10000),N68*O68,0),2)","v":0},"-----------"]
[null,"     Dirt   (w/ right-of-way)",null,null,null,"72",{"$f":"ROUND(IF(AND(E69>0,E69<10000),E69*F69,0),2)","v":0},null,"82",{"$f":"ROUND(IF(AND(H69>0,H69<10000),H69*I69,0),2)","v":0},null,"87",{"$f":"ROUND(IF(AND(K69>0,K69<10000),K69*L69,0),2)","v":0},null,"89",{"$f":"ROUND(IF(AND(N69>0,N69<10000),N69*O69,0),2)","v":0},"-----------"]
["Urban Districts",null,"Avg % impervious"]
[null,"     Commercial & business","85",null,null,"89",{"$f":"ROUND(IF(AND(E71>0,E71<10000),E71*F71,0),2)","v":0},null,"92",{"$f":"ROUND(IF(AND(H71>0,H71<10000),H71*I71,0),2)","v":0},null,"94",{"$f":"ROUND(IF(AND(K71>0,K71<10000),K71*L71,0),2)","v":0},null,"95",{"$f":"ROUND(IF(AND(N71>0,N71<10000),N71*O71,0),2)","v":0},"-----------"]
[null,"     Industrial","72 ",null,null,"81",{"$f":"ROUND(IF(AND(E72>0,E72<10000),E72*F72,0),2)","v":0},null,"88",{"$f":"ROUND(IF(AND(H72>0,H72<10000),H72*I72,0),2)","v":0},null,"91",{"$f":"ROUND(IF(AND(K72>0,K72<10000),K72*L72,0),2)","v":0},null,"93",{"$f":"ROUND(IF(AND(N72>0,N72<10000),N72*O72,0),2)","v":0},"-----------"]
["Residential districts by average lot size",null,"Avg % impervious",null,null,null,null,null,null,null,null,null,null,null,"  "]
[null,"   1/8 acre (town houses)","65",null,null,"77",{"$f":"ROUND(IF(AND(E74>0,E74<10000),E74*F74,0),2)","v":0},null,"85",{"$f":"ROUND(IF(AND(H74>0,H74<10000),H74*I74,0),2)","v":0},null,"90",{"$f":"ROUND(IF(AND(K74>0,K74<10000),K74*L74,0),2)","v":0},null,"92",{"$f":"ROUND(IF(AND(N74>0,N74<10000),N74*O74,0),2)","v":0},"-----------"]
[null,"   1/4 acre","38",null,null,"61",0,null,"75",0,null,"83",0,null,"87",0,"-----------"]
[null,"   1/3 acre","30",null,null,"57",0,null,"72",0,null,"81",0,null,"86",0,"-----------"]
[null,"   1/2 acre","25",null,null,"54",0,null,"70",0,null,"80",0,null,"85",0,"-----------"]
[null,"     1 acre","20",null,null,"51",0,null,"68",0,null,"79",0,null,"84",0,"-----------"]
[null,"     2 acre","12",null,null,"46",0,null,"65",0,null,"77",0,null,"82",0,"-----------"]
[]
[null,null,null,null,null,"**",null,null,"**",null,null,"**",null,null,"**"]
["DEVELOPING URBAN AREA (No Vegetation)",null,null,null,null,"  ",null,null,null,null,null,null,null,null,"  "]
[null,"Newly graded area (pervious only) ","",null,null,"77",{"$f":"ROUND(IF(AND(E83>0,E83<10000),E83*F83,0),2)","v":0},null,"86",{"$f":"ROUND(IF(AND(H83>0,H83<10000),H83*I83,0),2)","v":0},null,"91",{"$f":"ROUND(IF(AND(K83>0,K83<10000),K83*L83,0),2)","v":0},null,"94",{"$f":"ROUND(IF(AND(N83>0,N83<10000),N83*O83,0),2)","v":0}]
[]
["USER DEFINED"]
[null,null,null,null,null,null,{"$f":"ROUND(IF(AND(E86>0,E86<10000),E86*F86,0),2)","v":0},null,null,{"$f":"ROUND(IF(AND(H86>0,H86<10000),H86*I86,0),2)","v":0},null,null,{"$f":"ROUND(IF(AND(K86>0,K86<10000),K86*L86,0),2)","v":0},null,null,{"$f":"ROUND(IF(AND(N86>0,N86<10000),N86*O86,0),2)","v":0},"-----------"]
[null,null,null,null,null,null,{"$f":"ROUND(IF(AND(E87>0,E87<10000),E87*F87,0),2)","v":0},null,null,{"$f":"ROUND(IF(AND(H87>0,H87<10000),H87*I87,0),2)","v":0},null,null,{"$f":"ROUND(IF(AND(K87>0,K87<10000),K87*L87,0),2)","v":0},null,null,{"$f":"ROUND(IF(AND(N87>0,N87<10000),N87*O87,0),2)","v":0},"-----------"]
[]
[null,"Contributing Area per Soil Type (ac)",null,null,{"$f":"ROUND(SUM(E8:E87),2)","v":0},null,null,{"$f":"ROUND(SUM(H8:H87),2)","v":0},null,null,{"$f":"ROUND(SUM(K8:K87),2)","v":0},null,null,{"$f":"ROUND(SUM(N8:N87),2)","v":0}]
[null,"Pre LOD Area (ac)",{"$f":"SUM(E89,H89,K89,N89)","v":0}]
[null,"Subarea Weighted CN",{"$f":"IF($C$90=0,0,(SUM(G93:P93)/C90))","v":0}]
[]
[null,null,null,null,null,null,{"$f":"SUM(G8:G87)","v":0},null,null,{"$f":"SUM(J8:J87)","v":0},null,null,{"$f":"SUM(M8:M87)","v":0},null,null,{"$f":"SUM(P8:P87)","v":0}]
[]
[]
[]
[]
[]
[]
[null," "]

{"sheet":"Post LOD","index":1,"n_rows":98,"n_cols":23,"rows_kept":98,"cut":false,"hidden":false,"merged":[[4,2,5,2],[88,1,88,3],[91,2,92,2],[91,1,92,1],[0,2,0,14],[1,2,1,14],[3,0,3,1],[3,4,3,14],[2,2,2,14]]}
[null,"PROJECT:",{"$f":"'Pre LOD'!C1","v":0}]
[null,"STANDARD PLAN TYPE:",{"$f":"'Pre LOD'!C2","v":"Non-residential <1.0ac disturbed"}]
[null,"PARCEL AREA (ACRES):"]
["POST-DEVELOPMENT LOD CN\nENTER AREAS ONLY WITHIN THE LOD\n",null,null,null,"Curve Numbers for Hydrologic Soil Type"]
["Cover Type","Treatment","Hydrologic Condition",null,"A",null,null,"B",null,null,"C",null,null,"D"]
[null,null,null,null,"Acres","RCN",{"$f":"IF(AND(E6>0,E6<10000),E6*F6,0)","v":0},"Acres","RCN",{"$f":"IF(AND(H6>0,H6<10000),H6*I6,0)","v":0},"Acres","RCN",{"$f":"IF(AND(K6>0,K6<10000),K6*L6,0)","v":0},"Acres","RCN",{"$f":"IF(AND(N6>0,N6<10000),N6*O6,0)","v":0}]
["CULTIVATED AGRICULTURAL LANDS   "]
["Fallow","              Bare soil","----",null,null,"77",{"$f":"ROUND(IF(AND(E8>0,E8<10000),E8*F8,0),2)","v":0},null,"86",{"$f":"ROUND(IF(AND(H8>0,H8<10000),H8*I8,0),2)","v":0},null,"91",{"$f":"ROUND(IF(AND(K8>0,K8<10000),K8*L8,0),2)","v":0},null,"94",{"$f":"ROUND(IF(AND(N8>0,N8<10000),N8*O8,0),2)","v":0},"-----------"]
[null,"              Crop residue (CR)","poor",null,null,"76",{"$f":"ROUND(IF(AND(E9>0,E9<10000),E9*F9,0),2)","v":0},null,"85",{"$f":"ROUND(IF(AND(H9>0,H9<10000),H9*I9,0),2)","v":0},null,"90",{"$f":"ROUND(IF(AND(K9>0,K9<10000),K9*L9,0),2)","v":0},null,"93",{"$f":"ROUND(IF(AND(N9>0,N9<10000),N9*O9,0),2)","v":0},"-----------"]
[null,"              Crop residue (CR)","good",null,null,"74",0,null,"83",0,null,"88",0,null,"90",0,"-----------"]
["Row Crops","              Straight row (SR)","poor",null,null,"72",0,null,"81",0,null,"88",0,null,"91",0,"-----------"]
[null,"              Straight row (SR)","good",null,null,"67",0,null,"78",0,null,"85",0,null,"89",0,"-----------"]
[null,"              SR + Crop residue","poor",null,null,"71",0,null,"80",0,null,"87",0,null,"90",0,"-----------"]
[null,"              SR + Crop residue","good",null,null,"64",0,null,"75",0,null,"82",0,null,"85",0,"-----------"]
[null,"              Contoured (C)","poor",null,null,"70",0,null,"79",0,null,"84",0,null,"88",0,"-----------"]
[null,"              Contoured (C)","good",null,null,"65",0,null,"75",0,null,"82",0,null,"86",0,"-----------"]
[null,"              C + Crop residue","poor",null,null,"69",0,null,"78",0,null,"83",0,null,"87",0,"-----------"]
[null,"              C + Crop residue","good",null,null,"64",0,null,"74",0,null,"81",0,null,"85",0,"-----------"]
[null,"              Cont & terraced(C&T)","poor",null,null,"66",0,null,"74",0,null,"80",0,null,"82",0,"-----------"]
[null,"              Cont & terraced(C&T)","good",null,null,"62",0,null,"71",0,null,"78",0,null,"81",0,"-----------"]
[null,"              C&T + Crop residue","poor",null,null,"65",0,null,"73",0,null,"79",0,null,"81",0,"-----------"]
[null,"              C&T + Crop residue","good",null,null,"61",0,null,"70",0,null,"77",0,null,"80",0,"-----------"]
["Small Grain","              Straight row (SR)","poor",null,null,"65",0,null,"76",0,null,"84",0,null,"88",0,"-----------"]
[null,"              Straight row (SR)","good",null,null,"63",0,null,"75",0,null,"83",0,null,"87",0,"-----------"]
[null,"              SR + Crop residue","poor",null,null,"64",0,null,"75",0,null,"83",0,null,"86",0,"-----------"]
[null,"              SR + Crop residue","good",null,null,"60",0,null,"72",0,null,"80",0,null,"84",0,"-----------"]
[null,"              Contoured (C)","poor",null,null,"63",0,null,"74",0,null,"82",0,null,"85",0,"-----------"]
[null,"              Contoured (C)","good",null,null,"61",0,null,"73",0,null,"81",0,null,"84",0,"-----------"]
[null,"              C + Crop residue","poor",null,null,"62",0,null,"73",0,null,"81",0,null,"84",0,"-----------"]
[null,"              C + Crop residue","good",null,null,"60",0,null,"72",0,null,"80",0,null,"83",0,"-----------"]
[null,"              Cont & terraced(C&T)","poor",null,null,"61",0,null,"72",0,null,"79",0,null,"82",0,"-----------"]
[null,"              Cont & terraces(C&T)","good",null,null,"59",0,null,"70",0,null,"78",0,null,"81",0,"-----------"]
[null,"              C&T + Crop residue","poor",null,null,"60",0,null,"71",0,null,"78",0,null,"81",0,"-----------"]
[null,"              C&T + Crop residue","good",null,null,"58",0,null,"69",0,null,"77",0,null,"80",0,"-----------"]
["Close-seeded","              Straight row","poor",null,null,"66",0,null,"77",0,null,"85",0,null,"89",0,"-----------"]
["or broadcast","              Straight row","good",null,null,"58",0,null,"72",0,null,"81",0,null,"85",0,"-----------"]
["legumes or","              Contoured","poor",null,null,"64",0,null,"75",0,null,"83",0,null,"85",0,"-----------"]
["rotation","              Contoured","good",null,null,"55",0,null,"69",0,null,"78",0,null,"83",0,"-----------"]
["meadow","              Cont & terraced","poor",null,null,"63",0,null,"73",0,null,"80",0,null,"83",0,"-----------"]
[null,"              Cont & terraced","good",null,null,"51",0,null,"67",0,null,"76",0,null,"80",0,"-----------"]
[]
["OTHER AGRICULTURAL LANDS       ",null,null,null,null,"  ",null,null,null,null,null,null,null,null,"  "]
[null,"Pasture, grassland or range ","poor",null,null,"68",{"$f":"ROUND(IF(AND(E43>0,E43<10000),E43*F43,0),2)","v":0},null,"79",{"$f":"ROUND(IF(AND(H43>0,H43<10000),H43*I43,0),2)","v":0},null,"86",{"$f":"ROUND(IF(AND(K43>0,K43<10000),K43*L43,0),2)","v":0},null,"89",{"$f":"ROUND(IF(AND(N43>0,N43<10000),N43*O43,0),2)","v":0},"-----------"]
[null,"                            ","fair",null,null,"49",0,null,"69",0,null,"79",0,null,"84",0,"-----------"]
[null,"                            ","good",null,null,"39",0,null,"61",0,null,"74",0,null,"80",0,"-----------"]
[null,"Meadow -cont. grass (non grazed) ","----",null,null,"30",0,null,"58",0,null,"71",0,null,"78",0,"-----------"]
[null,"Brush - brush, weed, grass mix ","poor",null,null,"48",0,null,"67",0,null,"77",0,null,"83",0,"-----------"]
[null,"                               ","fair",null,null,"35",0,null,"56",0,null,"70",0,null,"77",0,"-----------"]
[null,"                               ","good",null,null,"30",0,null,"48",0,null,"65",0,null,"73",0,"-----------"]
[null,"Woods - grass combination ","poor",null,null,"57",0,null,"73",0,null,"82",0,null,"86",0,"-----------"]
[null,"                          ","fair",null,null,"43",0,null,"65",0,null,"76",0,null,"82",0,"-----------"]
[null,"                          ","good",null,null,"32",0,null,"58",0,null,"72",0,null,"79",0,"-----------"]
[null,"Woods ","poor",null,null,"45",0,null,"66",0,null,"77",0,null,"83",0,"-----------",null,null,null,null,null,"Project Type"]
[null,"      ","fair",null,null,"36",0,null,"60",0,null,"73",0,null,"79",0,"-----------"]
[null,"      ","good",null,null,"30",0,null,"55",0,null,"70",0,null,"77",0,"-----------",null,null,null,null,null,"Detailed"]
[null,"Farmsteads ","----",null,null,"59",0,null,"74",0,null,"82",0,null,"86",0,"-----------",null,null,null,null,null,"Standard"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"County"]
["FULLY DEVELOPED URBAN AREAS (Veg Established)"]
["Open space (Lawns,parks etc.)   ",null,null,null,null,"  ",null,null,"  ",null,null,"  ",null,null,"  ",null,null,null,null,null,null,null,"New Castle"]
[null,"   Poor condition; grass cover < 50%",null,null,null,"68",{"$f":"ROUND(IF(AND(E60>0,E60<10000),E60*F60,0),2)","v":0},null,"79",{"$f":"ROUND(IF(AND(H60>0,H60<10000),H60*I60,0),2)","v":0},null,"86",{"$f":"ROUND(IF(AND(K60>0,K60<10000),K60*L60,0),2)","v":0},null,"89",{"$f":"ROUND(IF(AND(N60>0,N60<10000),N60*O60,0),2)","v":0},"-----------",null,null,null,null,null,"New Castle (Incorp.)"]
[null,"   Fair condition; grass cover 50% to 75 %",null,null,null,"49",{"$f":"ROUND(IF(AND(E61>0,E61<10000),E61*F61,0),2)","v":0},null,"69",{"$f":"ROUND(IF(AND(H61>0,H61<10000),H61*I61,0),2)","v":0},null,"79",{"$f":"ROUND(IF(AND(K61>0,K61<10000),K61*L61,0),2)","v":0},null,"84",{"$f":"ROUND(IF(AND(N61>0,N61<10000),N61*O61,0),2)","v":0},"-----------",null,null,null,null,null,"Kent"]
[null,"   Good condition; grass cover > 75%",null,null,null,"39",{"$f":"ROUND(IF(AND(E62>0,E62<10000),E62*F62,0),2)","v":0},null,"61",{"$f":"ROUND(IF(AND(H62>0,H62<10000),H62*I62,0),2)","v":0},null,"74",{"$f":"ROUND(IF(AND(K62>0,K62<10000),K62*L62,0),2)","v":0},null,"80",{"$f":"ROUND(IF(AND(N62>0,N62<10000),N62*O62,0),2)","v":0},"-----------",null,null,null,null,null,"Sussex"]
["Impervious Areas      ",null,null,null,null,"  ",null,null,null,null,null,null,null,null,"  "]
[null,"  Paved parking lots, roofs, driveways",null,null,null,"98",{"$f":"ROUND(IF(AND(E64>0,E64<10000),E64*F64,0),2)","v":0},null,"98",{"$f":"ROUND(IF(AND(H64>0,H64<10000),H64*I64,0),2)","v":0},null,"98",{"$f":"ROUND(IF(AND(K64>0,K64<10000),K64*L64,0),2)","v":0},null,"98",{"$f":"ROUND(IF(AND(N64>0,N64<10000),N64*O64,0),2)","v":0},"-----------",null,null,null,null,null,"Unit Hydrograph"]
[null,"  Streets and roads      ",null,null,null,"  ",null,null,null,null,null,null,null,null,"  "]
[null,"      Paved; curbs and storm sewers","",null,null,"98",{"$f":"ROUND(IF(AND(E66>0,E66<10000),E66*F66,0),2)","v":0},null,"98",{"$f":"ROUND(IF(AND(H66>0,H66<10000),H66*I66,0),2)","v":0},null,"98",{"$f":"ROUND(IF(AND(K66>0,K66<10000),K66*L66,0),2)","v":0},null,"98",{"$f":"ROUND(IF(AND(N66>0,N66<10000),N66*O66,0),2)","v":0},"-----------",null,null,null,null,null,"DMV"]
[null,"     Paved; open ditches (w/right-of-way)",null,null,null,"83",{"$f":"ROUND(IF(AND(E67>0,E67<10000),E67*F67,0),2)","v":0},null,"89",{"$f":"ROUND(IF(AND(H67>0,H67<10000),H67*I67,0),2)","v":0},null,"92",{"$f":"ROUND(IF(AND(K67>0,K67<10000),K67*L67,0),2)","v":0},null,"93",{"$f":"ROUND(IF(AND(N67>0,N67<10000),N67*O67,0),2)","v":0},"-----------",null,null,null,null,null,"STD"]
[null,"     Gravel (w/ right-of-way)",null,null,null,"76",{"$f":"ROUND(IF(AND(E68>0,E68<10000),E68*F68,0),2)","v":0},null,"85",{"$f":"ROUND(IF(AND(H68>0,H68<10000),H68*I68,0),2)","v":0},null,"89",{"$f":"ROUND(IF(AND(K68>0,K68<10000),K68*L68,0),2)","v":0},null,"91",{"$f":"ROUND(IF(AND(N68>0,N68<10000),N68*O68,0),2)","v":0},"-----------"]
[null,"     Dirt   (w/ right-of-way)",null,null,null,"72",{"$f":"ROUND(IF(AND(E69>0,E69<10000),E69*F69,0),2)","v":0},null,"82",{"$f":"ROUND(IF(AND(H69>0,H69<10000),H69*I69,0),2)","v":0},null,"87",{"$f":"ROUND(IF(AND(K69>0,K69<10000),K69*L69,0),2)","v":0},null,"89",{"$f":"ROUND(IF(AND(N69>0,N69<10000),N69*O69,0),2)","v":0},"-----------"]
["Urban Districts",null,"Avg % impervious"]
[null,"     Commercial & business","85",null,null,"89",{"$f":"ROUND(IF(AND(E71>0,E71<10000),E71*F71,0),2)","v":0},null,"92",{"$f":"ROUND(IF(AND(H71>0,H71<10000),H71*I71,0),2)","v":0},null,"94",{"$f":"ROUND(IF(AND(K71>0,K71<10000),K71*L71,0),2)","v":0},null,"95",{"$f":"ROUND(IF(AND(N71>0,N71<10000),N71*O71,0),2)","v":0},"-----------"]
[null,"     Industrial","72 ",null,null,"81",{"$f":"ROUND(IF(AND(E72>0,E72<10000),E72*F72,0),2)","v":0},null,"88",{"$f":"ROUND(IF(AND(H72>0,H72<10000),H72*I72,0),2)","v":0},null,"91",{"$f":"ROUND(IF(AND(K72>0,K72<10000),K72*L72,0),2)","v":0},null,"93",{"$f":"ROUND(IF(AND(N72>0,N72<10000),N72*O72,0),2)","v":0},"-----------"]
["Residential districts by average lot size",null,"Avg % impervious",null,null,null,null,null,null,null,null,null,null,null,"  "]
[null,"   1/8 acre (town houses)","65",null,null,"77",{"$f":"ROUND(IF(AND(E74>0,E74<10000),E74*F74,0),2)","v":0},null,"85",{"$f":"ROUND(IF(AND(H74>0,H74<10000),H74*I74,0),2)","v":0},null,"90",{"$f":"ROUND(IF(AND(K74>0,K74<10000),K74*L74,0),2)","v":0},null,"92",{"$f":"ROUND(IF(AND(N74>0,N74<10000),N74*O74,0),2)","v":0},"-----------"]
[null,"   1/4 acre","38",null,null,"61",0,null,"75",0,null,"83",0,null,"87",0,"-----------"]
[null,"   1/3 acre","30",null,null,"57",0,null,"72",0,null,"81",0,null,"86",0,"-----------"]
[null,"   1/2 acre","25",null,null,"54",0,null,"70",0,null,"80",0,null,"85",0,"-----------"]
[null,"     1 acre","20",null,null,"51",0,null,"68",0,null,"79",0,null,"84",0,"-----------"]
[null,"     2 acre","12",null,null,"46",0,null,"65",0,null,"77",0,null,"82",0,"-----------"]
[]
[null,null,null,null,null,"**",null,null,"**",null,null,"**",null,null,"**"]
["DEVELOPING URBAN AREA (No Vegetation)",null,null,null,null,"  ",null,null,null,null,null,null,null,null,"  "]
[null,"Newly graded area (pervious only) ","",null,null,"77",{"$f":"ROUND(IF(AND(E83>0,E83<10000),E83*F83,0),2)","v":0},null,"86",{"$f":"ROUND(IF(AND(H83>0,H83<10000),H83*I83,0),2)","v":0},null,"91",{"$f":"ROUND(IF(AND(K83>0,K83<10000),K83*L83,0),2)","v":0},null,"94",{"$f":"ROUND(IF(AND(N83>0,N83<10000),N83*O83,0),2)","v":0}]
[]
["USER DEFINED"]
[null,null,null,null,null,null,{"$f":"ROUND(IF(AND(E86>0,E86<10000),E86*F86,0),2)","v":0},null,null,{"$f":"ROUND(IF(AND(H86>0,H86<10000),H86*I86,0),2)","v":0},null,null,{"$f":"ROUND(IF(AND(K86>0,K86<10000),K86*L86,0),2)","v":0},null,null,{"$f":"ROUND(IF(AND(N86>0,N86<10000),N86*O86,0),2)","v":0},"-----------"]
[null,null,null,null,null,null,{"$f":"ROUND(IF(AND(E87>0,E87<10000),E87*F87,0),2)","v":0},null,null,{"$f":"ROUND(IF(AND(H87>0,H87<10000),H87*I87,0),2)","v":0},null,null,{"$f":"ROUND(IF(AND(K87>0,K87<10000),K87*L87,0),2)","v":0},null,null,{"$f":"ROUND(IF(AND(N87>0,N87<10000),N87*O87,0),2)","v":0},"-----------"]
[]
[null,null,null,null,{"$f":"ROUND(SUM(E8:E87),2)","v":0},null,null,{"$f":"ROUND(SUM(H8:H87),2)","v":0},null,null,{"$f":"ROUND(SUM(K8:K87),2)","v":0},null,null,{"$f":"ROUND(SUM(N8:N87),2)","v":0}]
[null,"Post LOD Area (ac)",{"$f":"SUM(E89,H89,K89,N89)","v":0}]
[null,"Post Weighted CN",{"$f":"IF($C$90=0,0,(SUM(G93:P93)/C90))","v":0}]
[null,"Delta CN for the Parcel",{"$f":"ROUND((((PostArea*PostCN)/ParcelArea)-((PreArea*PreCN)/ParcelArea)),2)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,{"$f":"SUM(G8:G87)","v":0},null,null,{"$f":"SUM(J8:J87)","v":0},null,null,{"$f":"SUM(M8:M87)","v":0},null,null,{"$f":"SUM(P8:P87)","v":0}]
[]
[]
[]
[]
[null," "]