{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Cover Sheet","Rv and Adjusted CN","Sheet1"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":3,"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":"Cover Sheet","index":0,"n_rows":44,"n_cols":15,"rows_kept":44,"cut":false,"hidden":false,"merged":[[24,8,39,8],[4,2,4,5],[17,8,23,8],[20,9,23,9],[17,9,19,9],[33,9,34,9],[31,9,32,9],[27,9,30,9],[24,9,26,9],[35,9,36,9],[0,8,0,15],[30,0,41,0],[30,1,31,1],[32,1,39,1],[40,1,41,1],[17,0,29,0],[17,1,29,1],[0,0,0,1],[2,0,2,1],[2,2,2,5],[1,0,1,1],[4,0,4,1],[0,2,0,5],[1,2,1,5],[3,0,3,1],[3,2,3,5]]}
["Project Name",null,null,null,null,null,null,null,"MWS LID SITE DESIGN TOOL VERSION 9 - August 1, 2016"]
["Parcel Identification #"]
["Engineer"]
["Address"]
["E-mail"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Lookup Table",null,null,null,null,null,null,null,"Lookup Table"]
[null,"Basic Land Use Category","Land Use","Code","R Credit","Rv ","CN",null,null,"GI Practice","Level","Code","R Credit","Rv","Tv Multiplier"]
["Step 1   Basic Land Use","Basic Land Use","Impervious Surface","IA",{"$f":"1-F18","v":5.0000000000000044E-2},0.95,98,null,"Step 2     Intrinsic GIPs","Downspout Disconnection","A/B Soil","DAB",0.5,{"$f":"1-M18","v":0.5},0]
[null,null,"Forest A Soil","FA",0.98,0.02,36,null,null,null,"C/D Soil","DCD",0.25,0.75,0]
[null,null,"Forest B Soil","FB",0.97,0.03,60,null,null,null,"Amended","DAS",0.5,0.5,0]
[null,null,"Forest C Soil","FC",0.96,0.04,73,null,null,"Sheet Flow","Cons Area A/B","SAB",0.75,0.25,0]
[null,null,"Forest D Soil","FD",0.95,0.05,79,null,null,null,"Cons Area C/D","SCD",0.5,0.5,0]
[null,null,"Turf A Soil","TA",0.85,0.15,49,null,null,null,"Strip A","SA",0.5,0.5,0]
[null,null,"Turf B Soil","TB",0.82000000000000006,0.18,69,null,null,null,"Strip Amended","SAS",0.5,0.5,0]
[null,null,"Turf C Soil","TC",0.8,0.2,79,null,"Step 3 & 3a Structural GIPs","Permeable Pavement\n(see Notes below)",1,"P1",0.45,{"$f":"1-M25","v":0.55000000000000004},1]
[null,null,"Turf D Soil","TD",{"$f":"1-F26","v":0.77},0.23,84,null,null,null,"1 (P1 Land Use)","PP1",0,{"$f":"1-M26","v":1},1]
[null,null,"Gravel A Soil","GRA",0.4,0.6,76,null,null,null,"2 (No Run on)*","P2",0,{"$f":"1-M27","v":1},1.1000000000000001]
[null,null,"Gravel B Soil","GRB",0.4,0.6,85,null,null,"Grass Channel","A/B Soil","GAB",0.2,{"$f":"1-M28","v":0.8},0]
[null,null,"Gravel C Soil","GRC",0.4,0.6,89,null,null,null,"C/D Soil","GCD",0.1,0.9,0]
[null,null,"Gravel D Soil","GRD",0.4,0.6,91,null,null,null,"A/B Amended","GAA",0.3,0.7,0]
["Step 1a Modified Land Use","Permeable \nPavement","Level 1","P1",0.45,0.55000000000000004,98,null,null,null,"C/D amended","GCA",0.2,0.8,0]
[null,null,"Level 2","P2",0.75,0.25,98,null,null,"Bioretention",1,"B1",0.4,{"$f":"1-M32","v":0.6},1]
[null,"Reforestation","A","RA",0.96,{"$f":"1-E33","v":4.0000000000000036E-2},45,null,null,null,2,"B2",0.8,0.19999999999999996,1.25]
[null,null,"B","RB",0.94,6.0000000000000053E-2,66,null,null,"Water Quality Swales",1,"S1",0.4,0.6,1]
[null,null,"C","RC",0.92,7.999999999999996E-2,77,null,null,null,2,"S2",0.6,0.4,1.1000000000000001]
[null,null,"D","RD",0.9,9.9999999999999978E-2,83,null,null,"Infiltration Trench",1,"I1",0.5,0.5,1]
[null,null,"A Amended","RAA",0.98,2.0000000000000018E-2,30,null,null,null,2,"I2",0.9,9.9999999999999978E-2,1.1000000000000001]
[null,null,"B Amended","RBA",0.97,3.0000000000000027E-2,55,null,null,"Urban Bioretention",1,"UB",0.4,0.6,1]
[null,null,"C Amended","RCA",0.96,4.0000000000000036E-2,70,null,null,"Ext Detention Pond",null,"D1",0.15,0.85,1.25]
[null,null,"D Amended","RDA",0.95,5.0000000000000044E-2,77,null,null,"Cistern",null,"CIS",{"$f":"'Rv and Adjusted CN'!$D$11/100","v":0},1,0]
[null,"Green Roof",1,"G1",0.45,0.55000000000000004,86,null,"Notes for Permeable Pavement"]
[null,null,2,"G2",0.6,0.4,86,null,"1.  Choose PP1 in Structural GIP for actual area of the Level 1 Permeable Pavement, otherwise use P1 for run-on areas."]
[null,null,null,null,null,null,null,null,"2. Level 2 Permeable Pavement cannot have run-on, therefore P2 can only be chosen as Structural GIP for Modified Land Use of P2"]
[null,null,null,null,null,null,null,null,"Text in Column AC will turn red if these conditions are not met."]

{"sheet":"Rv and Adjusted CN","index":1,"n_rows":63,"n_cols":50,"rows_kept":63,"cut":false,"hidden":false,"merged":[[0,37,0,44],[91,0,91,3],[16,23,16,24],[16,27,16,30],[16,31,16,37],[16,39,16,42],[58,15,60,15],[58,16,60,16],[58,21,60,21],[58,22,60,22],[60,0,60,3],[16,43,16,49],[14,20,15,22],[15,27,15,37],[15,39,15,49],[16,0,16,4],[16,21,16,22],[6,26,6,27],[9,0,9,2],[9,4,9,5],[10,0,10,2],[14,0,15,4],[14,5,15,7],[14,8,15,10],[14,11,15,13],[14,14,15,16],[14,17,15,19],[16,5,16,7],[16,8,16,10],[16,11,16,13],[16,15,16,16],[16,17,16,19],[1,0,1,3],[1,4,1,8],[1,26,1,30],[1,31,1,35],[0,0,0,3],[0,4,0,8],[0,26,0,30],[0,31,0,35],[0,10,0,17]]}
["Project Name",null,null,null,{"$f":"'Cover Sheet'!C1","v":0},null,null,null,null,null,"MWS LID SITE DESIGN TOOL VERSION 9 - August 1, 2016",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project Name",null,null,null,null,{"$f":"'Cover Sheet'!C1","v":0},null,null,null,null,null,"MWS LID SITE DESIGN TOOL VERSION 9 - August 1, 2016"]
["Parcel Identification #",null,null,null,{"$f":"'Cover Sheet'!C2","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Parcel Identification #",null,null,null,null,{"$f":"'Cover Sheet'!C2","v":0}]
["Combined Sewer Overlay?"]
["Pre-Development Impervious Area (acres)"]
["Post-Development Impervious Area (acres)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PreDev \nCN"]
["Pre-Development Rv ="]
["Target Runoff Reduction Requirement =",null,null,null,0.8,"See Section 7.2.1 in Metro SWMM Volume 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"METRO RAINFALL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Return\n Period","Rainfall\n(in)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2-yr",3.39]
["Capture Depth=",null,null,1,"inch",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5-yr",4.5]
["Cistern Capture=",null,null,null,"% Total Vol captured",null,null,"From Cistern Design Tool",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10-yr",5.23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"25-yr",6.16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50-yr",6.85]
["Percent Volume Reduction-Based Calculations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"100-yr",7.53]
["Step 1: Lay out the site and divide it into sub-areas each of a specific land use type and Rv.",null,null,null,null,"Step 1a: Change any basic land use types through reforesting, permeable pavement or green roofs - or through use of open space for a GIP.",null,null,"Step 2: Treat impervious areas through the use of disconnection or sheet flow",null,null,"Step 3: Treat primarily impervious areas with structural GIPs either in series with Step 3 intrinsic GIPs or alone downstream from Steps 1 and 2 land use.",null,null," Size controls for Step 3 by assigning structure ID to each sub-area, combining sub-areas into one structure if appropriate.",null,null,"Step 3a Treatment in Series Calculation - Place Structural GIPs in same row as upstream GIP ",null,null,"Size controls for Step 3a in series by assigning a sequential structure ID to each area treated in series."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adjusted Curve Number Calculations (Step 3 only)",null,null,null,null,null,null,null,null,null,null,null,"Adjusted Curve Number Calculations (Step 3a added)"]
["Step1 Basic Land Use",null,null,null,null,"Step 1a Modified LU",null,null,"Step 2 Intrinsic GIPs",null,null,"Step 3 Structural GIPs",null,null,"Structure ID","IA Capture",null,"Step 3a Structural GIPs in Series",null,null,"Structure ID","IA Capture",null,"Nominal Curve Number",null,null,null,"No Controls",null,null,null,"With Structural Controls &Treatment Vol Removed",null,null,null,null,null,null,null,"No Controls",null,null,null,"With Structural Controls &Treatment Vol Removed"]
["Subarea","Description","Code","Acres","Base Rv","Code",{"$f":"D18","v":"Acres"},"Eff Rv1","Code","Trtmt VR1","Eff Rv2","Code","Trtmt VR2","Eff Rv3",null,"Tv Multiplier","Tv (cf)","Code","Trtmt VR2","Eff Rv4","Site GIP ID Number","Tv Multiplier","Structure in Series Tv (cf)","Step 1","Step 1A",null,null,"Original CN","Rainfall (in)","S (in)","Q (in)","Tv required\n(cu ft)","Tv provided \n(%)","RO Vol \nRed (cu ft)","Q reduction (in)","Q adj (in)","Adjusted CN","Difference",null,"Adjusted\nCN (St 3)","Rainfall (in)","S (in)","Q (in)","Tv required\n(cu ft)","Tv provided \n(%)","RO Vol \nRed (cu ft)","Q reduction (in)","Q adj (in)","Adjusted CN","Difference"]
[1,null,null,null,{"$f":"IF($G19=0,0,VLOOKUP(C19,'Cover Sheet'!$D$18:$F$30,3,0))","v":0},null,0,{"$f":"IF($G19=0,0,VLOOKUP(F19,'Cover Sheet'!$D$18:$F$42,3,0))","v":0},null,{"$f":"IF(I19=0,0,VLOOKUP(I19,'Cover Sheet'!$L$18:$M$24,2,0))","v":0},{"$f":"IF(J19>0,H19*(1-J19),H19)","v":0},null,{"$f":"IF(L19=0,0,VLOOKUP(L19,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},{"$f":"IF(M19>0,ROUNDUP(K19*(1-M19),2),K19)","v":0},null,{"$f":"IF(L19=\"\",0,VLOOKUP(L19,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},{"$f":"IF(L19=\"\",\"-\",IF(OR(L19=\"PP1\",L19=\"P2\"),P19*$D$10*E19*G19/12*43560,P19*$D$10*K19*G19/12*43560))","v":"-"},null,{"$f":"IF(R19=0,0,VLOOKUP(R19,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},{"$f":"IF(S19>0,N19*(1-S19),N19)","v":0},null,{"$f":"IF(R19=\"\",0,VLOOKUP(R19,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},{"$f":"IF(R19=\"\",\"-\",V19*$D$10*N19*G19/12*43560)","v":"-"},{"$f":"IF(C19=0,0,VLOOKUP(C19,'Cover Sheet'!$D$18:$G$30,4,0))","v":0},{"$f":"IF(F19=0,0,VLOOKUP(F19,'Cover Sheet'!$D$18:$G$42,4,0))","v":0},null,null,{"$f":"Y19","v":0},7.53,{"$f":"IF(AB19=0,\"-\",1000/AB19-10)","v":"-"},{"$f":"IF(AB19=0,\"-\",(AC19-0.2*AD19)^2/(AC19+0.8*AD19))","v":"-"},{"$f":"Q19","v":"-"},null,{"$f":"IF(AG19=\"\",\"\",AF19*AG19)","v":""},{"$f":"IF(OR(AB19=0,L19=\"\"),0,12*AH19/43560/D19)","v":0},{"$f":"IF(AB19=0,\"-\",AE19-AI19)","v":"-"},{"$f":"IF(AB19=0,0,1000/(10+5*AC19+10*AJ19-10*(AJ19^2+1.25*AJ19*AC19)^(1/2)))","v":0},{"$f":"AK19-AB19","v":0},null,{"$f":"AK19","v":0},7.53,{"$f":"IF(AN19=0,\"-\",1000/AN19-10)","v":"-"},{"$f":"IF(AN19=0,\"-\",(AO19-0.2*AP19)^2/(AO19+0.8*AP19))","v":"-"},{"$f":"W19","v":"-"},1,{"$f":"IF(AS19=\"\",\"\",AR19*AS19)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(AN19=0,R19=\"\"),0,12*AT19/43560/D19)","v":0},{"$f":"IF(AN19=0,\"-\",AQ19-AU19)","v":"-"},{"$f":"IF(AN19=0,0,1000/(10+5*AO19+10*AV19-10*(AV19^2+1.25*AV19*AO19)^(1/2)))","v":0},{"$f":"AW19-AN19","v":0}]
[{"$f":"A19+1","v":2},null,null,null,{"$f":"IF($G20=0,0,VLOOKUP(C20,'Cover Sheet'!$D$18:$F$30,3,0))","v":0},null,0,{"$f":"IF($G20=0,0,VLOOKUP(F20,'Cover Sheet'!$D$18:$F$42,3,0))","v":0},null,{"$f":"IF(I20=0,0,VLOOKUP(I20,'Cover Sheet'!$L$18:$M$24,2,0))","v":0},{"$f":"IF(J20>0,H20*(1-J20),H20)","v":0},null,{"$f":"IF(L20=0,0,VLOOKUP(L20,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},{"$f":"IF(M20>0,ROUNDUP(K20*(1-M20),2),K20)","v":0},null,{"$f":"IF(L20=\"\",0,VLOOKUP(L20,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},{"$f":"IF(L20=\"\",\"-\",IF(OR(L20=\"PP1\",L20=\"P2\"),P20*$D$10*E20*G20/12*43560,P20*$D$10*K20*G20/12*43560))","v":"-"},null,{"$f":"IF(R20=0,0,VLOOKUP(R20,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},{"$f":"IF(S20>0,N20*(1-S20),N20)","v":0},null,{"$f":"IF(R20=\"\",0,VLOOKUP(R20,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",{"$f":"IF(C20=0,0,VLOOKUP(C20,'Cover Sheet'!$D$18:$G$30,4,0))","v":0},{"$f":"IF(F20=0,0,VLOOKUP(F20,'Cover Sheet'!$D$18:$G$42,4,0))","v":0},null,null,{"$f":"Y20","v":0},{"$f":"$AC$19","v":7.53},"-",{"$f":"IF(AB20=0,\"-\",(AC20-0.2*AD20)^2/(AC20+0.8*AD20))","v":"-"},{"$f":"Q20","v":"-"},null,{"$f":"IF(AG20=\"\",\"\",AF20*AG20)","v":""},0,"-",{"$f":"IF(AB20=0,0,1000/(10+5*AC20+10*AJ20-10*(AJ20^2+1.25*AJ20*AC20)^(1/2)))","v":0},{"$f":"AK20-AB20","v":0},null,{"$f":"AK20","v":0},{"$f":"$AC$19","v":7.53},"-","-",{"$f":"W20","v":"-"},null,{"$f":"IF(AS20=\"\",\"\",AR20*AS20)","v":""},{"$f":"IF(OR(AN20=0,R20=\"\"),0,12*AT20/43560/D20)","v":0},"-",0,{"$f":"AW20-AN20","v":0}]
[{"$f":"A20+1","v":3},null,null,null,{"$f":"IF($G21=0,0,VLOOKUP(C21,'Cover Sheet'!$D$18:$F$30,3,0))","v":0},null,0,{"$f":"IF($G21=0,0,VLOOKUP(F21,'Cover Sheet'!$D$18:$F$42,3,0))","v":0},null,{"$f":"IF(I21=0,0,VLOOKUP(I21,'Cover Sheet'!$L$18:$M$24,2,0))","v":0},0,null,{"$f":"IF(L21=0,0,VLOOKUP(L21,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(L21=\"\",0,VLOOKUP(L21,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},{"$f":"IF(L21=\"\",\"-\",IF(OR(L21=\"PP1\",L21=\"P2\"),P21*$D$10*E21*G21/12*43560,P21*$D$10*K21*G21/12*43560))","v":"-"},null,{"$f":"IF(R21=0,0,VLOOKUP(R21,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},{"$f":"IF(S21>0,N21*(1-S21),N21)","v":0},null,{"$f":"IF(R21=\"\",0,VLOOKUP(R21,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",{"$f":"IF(C21=0,0,VLOOKUP(C21,'Cover Sheet'!$D$18:$G$30,4,0))","v":0},{"$f":"IF(F21=0,0,VLOOKUP(F21,'Cover Sheet'!$D$18:$G$42,4,0))","v":0},null,null,0,{"$f":"$AC$19","v":7.53},"-","-",{"$f":"Q21","v":"-"},null,"",0,"-",0,0,null,0,{"$f":"$AC$19","v":7.53},"-","-","-",null,"",0,"-",0,0]
[4,null,null,null,{"$f":"IF($G22=0,0,VLOOKUP(C22,'Cover Sheet'!$D$18:$F$30,3,0))","v":0},null,0,{"$f":"IF($G22=0,0,VLOOKUP(F22,'Cover Sheet'!$D$18:$F$42,3,0))","v":0},null,{"$f":"IF(I22=0,0,VLOOKUP(I22,'Cover Sheet'!$L$18:$M$24,2,0))","v":0},0,null,{"$f":"IF(L22=0,0,VLOOKUP(L22,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(L22=\"\",0,VLOOKUP(L22,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",null,{"$f":"IF(R22=0,0,VLOOKUP(R22,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(R22=\"\",0,VLOOKUP(R22,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",{"$f":"IF(C22=0,0,VLOOKUP(C22,'Cover Sheet'!$D$18:$G$30,4,0))","v":0},{"$f":"IF(F22=0,0,VLOOKUP(F22,'Cover Sheet'!$D$18:$G$42,4,0))","v":0},null,null,0,7.53,"-","-","-",null,"",0,"-",0,0,null,0,7.53,"-","-","-",null,"",0,"-",0,0]
[5,null,null,null,{"$f":"IF($G23=0,0,VLOOKUP(C23,'Cover Sheet'!$D$18:$F$30,3,0))","v":0},null,0,{"$f":"IF($G23=0,0,VLOOKUP(F23,'Cover Sheet'!$D$18:$F$42,3,0))","v":0},null,{"$f":"IF(I23=0,0,VLOOKUP(I23,'Cover Sheet'!$L$18:$M$24,2,0))","v":0},0,null,{"$f":"IF(L23=0,0,VLOOKUP(L23,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(L23=\"\",0,VLOOKUP(L23,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",null,{"$f":"IF(R23=0,0,VLOOKUP(R23,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(R23=\"\",0,VLOOKUP(R23,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",{"$f":"IF(C23=0,0,VLOOKUP(C23,'Cover Sheet'!$D$18:$G$30,4,0))","v":0},{"$f":"IF(F23=0,0,VLOOKUP(F23,'Cover Sheet'!$D$18:$G$42,4,0))","v":0},null,null,0,7.53,"-","-","-",null,"",0,"-",0,0,null,0,7.53,"-","-","-",null,"",0,"-",0,0]
[6,null,null,null,{"$f":"IF($G24=0,0,VLOOKUP(C24,'Cover Sheet'!$D$18:$F$30,3,0))","v":0},null,0,{"$f":"IF($G24=0,0,VLOOKUP(F24,'Cover Sheet'!$D$18:$F$42,3,0))","v":0},null,{"$f":"IF(I24=0,0,VLOOKUP(I24,'Cover Sheet'!$L$18:$M$24,2,0))","v":0},0,null,{"$f":"IF(L24=0,0,VLOOKUP(L24,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(L24=\"\",0,VLOOKUP(L24,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",null,{"$f":"IF(R24=0,0,VLOOKUP(R24,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(R24=\"\",0,VLOOKUP(R24,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",{"$f":"IF(C24=0,0,VLOOKUP(C24,'Cover Sheet'!$D$18:$G$30,4,0))","v":0},{"$f":"IF(F24=0,0,VLOOKUP(F24,'Cover Sheet'!$D$18:$G$42,4,0))","v":0},null,null,0,7.53,"-","-","-",null,"",0,"-",0,0,null,0,7.53,"-","-","-",null,"",0,"-",0,0]
[7,null,null,null,{"$f":"IF($G25=0,0,VLOOKUP(C25,'Cover Sheet'!$D$18:$F$30,3,0))","v":0},null,0,{"$f":"IF($G25=0,0,VLOOKUP(F25,'Cover Sheet'!$D$18:$F$42,3,0))","v":0},null,{"$f":"IF(I25=0,0,VLOOKUP(I25,'Cover Sheet'!$L$18:$M$24,2,0))","v":0},0,null,{"$f":"IF(L25=0,0,VLOOKUP(L25,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(L25=\"\",0,VLOOKUP(L25,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",null,{"$f":"IF(R25=0,0,VLOOKUP(R25,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(R25=\"\",0,VLOOKUP(R25,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",{"$f":"IF(C25=0,0,VLOOKUP(C25,'Cover Sheet'!$D$18:$G$30,4,0))","v":0},{"$f":"IF(F25=0,0,VLOOKUP(F25,'Cover Sheet'!$D$18:$G$42,4,0))","v":0},null,null,0,7.53,"-","-","-",null,"",0,"-",0,0,null,0,7.53,"-","-","-",null,"",0,"-",0,0]
[8,null,null,null,{"$f":"IF($G26=0,0,VLOOKUP(C26,'Cover Sheet'!$D$18:$F$30,3,0))","v":0},null,0,{"$f":"IF($G26=0,0,VLOOKUP(F26,'Cover Sheet'!$D$18:$F$42,3,0))","v":0},null,{"$f":"IF(I26=0,0,VLOOKUP(I26,'Cover Sheet'!$L$18:$M$24,2,0))","v":0},0,null,{"$f":"IF(L26=0,0,VLOOKUP(L26,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(L26=\"\",0,VLOOKUP(L26,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",null,{"$f":"IF(R26=0,0,VLOOKUP(R26,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(R26=\"\",0,VLOOKUP(R26,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",{"$f":"IF(C26=0,0,VLOOKUP(C26,'Cover Sheet'!$D$18:$G$30,4,0))","v":0},{"$f":"IF(F26=0,0,VLOOKUP(F26,'Cover Sheet'!$D$18:$G$42,4,0))","v":0},null,null,0,7.53,"-","-","-",null,"",0,"-",0,0,null,0,7.53,"-","-","-",null,"",0,"-",0,0]
[9,null,null,null,{"$f":"IF($G27=0,0,VLOOKUP(C27,'Cover Sheet'!$D$18:$F$30,3,0))","v":0},null,0,{"$f":"IF($G27=0,0,VLOOKUP(F27,'Cover Sheet'!$D$18:$F$42,3,0))","v":0},null,{"$f":"IF(I27=0,0,VLOOKUP(I27,'Cover Sheet'!$L$18:$M$24,2,0))","v":0},0,null,{"$f":"IF(L27=0,0,VLOOKUP(L27,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(L27=\"\",0,VLOOKUP(L27,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",null,{"$f":"IF(R27=0,0,VLOOKUP(R27,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(R27=\"\",0,VLOOKUP(R27,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",{"$f":"IF(C27=0,0,VLOOKUP(C27,'Cover Sheet'!$D$18:$G$30,4,0))","v":0},{"$f":"IF(F27=0,0,VLOOKUP(F27,'Cover Sheet'!$D$18:$G$42,4,0))","v":0},null,null,0,7.53,"-","-","-",null,"",0,"-",0,0,null,0,7.53,"-","-","-",null,"",0,"-",0,0]
[10,null,null,null,{"$f":"IF($G28=0,0,VLOOKUP(C28,'Cover Sheet'!$D$18:$F$30,3,0))","v":0},null,0,{"$f":"IF($G28=0,0,VLOOKUP(F28,'Cover Sheet'!$D$18:$F$42,3,0))","v":0},null,{"$f":"IF(I28=0,0,VLOOKUP(I28,'Cover Sheet'!$L$18:$M$24,2,0))","v":0},0,null,{"$f":"IF(L28=0,0,VLOOKUP(L28,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(L28=\"\",0,VLOOKUP(L28,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",null,{"$f":"IF(R28=0,0,VLOOKUP(R28,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(R28=\"\",0,VLOOKUP(R28,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",{"$f":"IF(C28=0,0,VLOOKUP(C28,'Cover Sheet'!$D$18:$G$30,4,0))","v":0},{"$f":"IF(F28=0,0,VLOOKUP(F28,'Cover Sheet'!$D$18:$G$42,4,0))","v":0},null,null,0,7.53,"-","-","-",null,"",0,"-",0,0,null,0,7.53,"-","-","-",null,"",0,"-",0,0]
[11,null,null,null,{"$f":"IF($G29=0,0,VLOOKUP(C29,'Cover Sheet'!$D$18:$F$30,3,0))","v":0},null,0,{"$f":"IF($G29=0,0,VLOOKUP(F29,'Cover Sheet'!$D$18:$F$42,3,0))","v":0},null,{"$f":"IF(I29=0,0,VLOOKUP(I29,'Cover Sheet'!$L$18:$M$24,2,0))","v":0},0,null,{"$f":"IF(L29=0,0,VLOOKUP(L29,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(L29=\"\",0,VLOOKUP(L29,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",null,{"$f":"IF(R29=0,0,VLOOKUP(R29,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(R29=\"\",0,VLOOKUP(R29,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",{"$f":"IF(C29=0,0,VLOOKUP(C29,'Cover Sheet'!$D$18:$G$30,4,0))","v":0},{"$f":"IF(F29=0,0,VLOOKUP(F29,'Cover Sheet'!$D$18:$G$42,4,0))","v":0},null,null,0,7.53,"-","-","-",null,"",0,"-",0,0,null,0,7.53,"-","-","-",null,"",0,"-",0,0]
[12,null,null,null,{"$f":"IF($G30=0,0,VLOOKUP(C30,'Cover Sheet'!$D$18:$F$30,3,0))","v":0},null,0,{"$f":"IF($G30=0,0,VLOOKUP(F30,'Cover Sheet'!$D$18:$F$42,3,0))","v":0},null,{"$f":"IF(I30=0,0,VLOOKUP(I30,'Cover Sheet'!$L$18:$M$24,2,0))","v":0},0,null,{"$f":"IF(L30=0,0,VLOOKUP(L30,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(L30=\"\",0,VLOOKUP(L30,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",null,{"$f":"IF(R30=0,0,VLOOKUP(R30,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(R30=\"\",0,VLOOKUP(R30,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",{"$f":"IF(C30=0,0,VLOOKUP(C30,'Cover Sheet'!$D$18:$G$30,4,0))","v":0},{"$f":"IF(F30=0,0,VLOOKUP(F30,'Cover Sheet'!$D$18:$G$42,4,0))","v":0},null,null,0,7.53,"-",{"$f":"IF(AB30=0,\"-\",(AC30-0.2*AD30)^2/(AC30+0.8*AD30))","v":"-"},"-",null,"",0,"-",0,0,null,0,7.53,"-",{"$f":"IF(AN30=0,\"-\",(AO30-0.2*AP30)^2/(AO30+0.8*AP30))","v":"-"},"-",null,"",0,"-",0,0]
[13,null,null,null,{"$f":"IF($G31=0,0,VLOOKUP(C31,'Cover Sheet'!$D$18:$F$30,3,0))","v":0},null,0,{"$f":"IF($G31=0,0,VLOOKUP(F31,'Cover Sheet'!$D$18:$F$42,3,0))","v":0},null,{"$f":"IF(I31=0,0,VLOOKUP(I31,'Cover Sheet'!$L$18:$M$24,2,0))","v":0},0,null,{"$f":"IF(L31=0,0,VLOOKUP(L31,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(L31=\"\",0,VLOOKUP(L31,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",null,{"$f":"IF(R31=0,0,VLOOKUP(R31,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(R31=\"\",0,VLOOKUP(R31,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",{"$f":"IF(C31=0,0,VLOOKUP(C31,'Cover Sheet'!$D$18:$G$30,4,0))","v":0},{"$f":"IF(F31=0,0,VLOOKUP(F31,'Cover Sheet'!$D$18:$G$42,4,0))","v":0},null,null,0,7.53,"-","-","-",null,"",0,"-",0,0,null,0,7.53,"-",{"$f":"IF(AN31=0,\"-\",(AO31-0.2*AP31)^2/(AO31+0.8*AP31))","v":"-"},"-",null,"",0,"-",0,0]
[14,null,null,null,{"$f":"IF($G32=0,0,VLOOKUP(C32,'Cover Sheet'!$D$18:$F$30,3,0))","v":0},null,0,{"$f":"IF($G32=0,0,VLOOKUP(F32,'Cover Sheet'!$D$18:$F$42,3,0))","v":0},null,{"$f":"IF(I32=0,0,VLOOKUP(I32,'Cover Sheet'!$L$18:$M$24,2,0))","v":0},0,null,{"$f":"IF(L32=0,0,VLOOKUP(L32,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(L32=\"\",0,VLOOKUP(L32,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",null,{"$f":"IF(R32=0,0,VLOOKUP(R32,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(R32=\"\",0,VLOOKUP(R32,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",{"$f":"IF(C32=0,0,VLOOKUP(C32,'Cover Sheet'!$D$18:$G$30,4,0))","v":0},{"$f":"IF(F32=0,0,VLOOKUP(F32,'Cover Sheet'!$D$18:$G$42,4,0))","v":0},null,null,0,7.53,"-","-","-",null,"",0,"-",0,0,null,0,7.53,"-","-","-",null,"",0,"-",0,0]
[15,null,null,null,{"$f":"IF($G33=0,0,VLOOKUP(C33,'Cover Sheet'!$D$18:$F$30,3,0))","v":0},null,0,{"$f":"IF($G33=0,0,VLOOKUP(F33,'Cover Sheet'!$D$18:$F$42,3,0))","v":0},null,{"$f":"IF(I33=0,0,VLOOKUP(I33,'Cover Sheet'!$L$18:$M$24,2,0))","v":0},0,null,{"$f":"IF(L33=0,0,VLOOKUP(L33,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(L33=\"\",0,VLOOKUP(L33,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",null,{"$f":"IF(R33=0,0,VLOOKUP(R33,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(R33=\"\",0,VLOOKUP(R33,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",{"$f":"IF(C33=0,0,VLOOKUP(C33,'Cover Sheet'!$D$18:$G$30,4,0))","v":0},{"$f":"IF(F33=0,0,VLOOKUP(F33,'Cover Sheet'!$D$18:$G$42,4,0))","v":0},null,null,0,7.53,"-","-","-",null,"",0,"-",0,0,null,0,7.53,"-","-","-",null,"",0,"-",0,0]
[16,null,null,null,{"$f":"IF($G34=0,0,VLOOKUP(C34,'Cover Sheet'!$D$18:$F$30,3,0))","v":0},null,0,{"$f":"IF($G34=0,0,VLOOKUP(F34,'Cover Sheet'!$D$18:$F$42,3,0))","v":0},null,{"$f":"IF(I34=0,0,VLOOKUP(I34,'Cover Sheet'!$L$18:$M$24,2,0))","v":0},0,null,{"$f":"IF(L34=0,0,VLOOKUP(L34,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(L34=\"\",0,VLOOKUP(L34,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",null,{"$f":"IF(R34=0,0,VLOOKUP(R34,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(R34=\"\",0,VLOOKUP(R34,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",{"$f":"IF(C34=0,0,VLOOKUP(C34,'Cover Sheet'!$D$18:$G$30,4,0))","v":0},{"$f":"IF(F34=0,0,VLOOKUP(F34,'Cover Sheet'!$D$18:$G$42,4,0))","v":0},null,null,0,7.53,"-","-","-",null,"",0,"-",0,0,null,0,7.53,"-","-","-",null,"",0,"-",0,0]
[17,null,null,null,{"$f":"IF($G35=0,0,VLOOKUP(C35,'Cover Sheet'!$D$18:$F$30,3,0))","v":0},null,0,{"$f":"IF($G35=0,0,VLOOKUP(F35,'Cover Sheet'!$D$18:$F$42,3,0))","v":0},null,{"$f":"IF(I35=0,0,VLOOKUP(I35,'Cover Sheet'!$L$18:$M$24,2,0))","v":0},0,null,{"$f":"IF(L35=0,0,VLOOKUP(L35,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(L35=\"\",0,VLOOKUP(L35,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",null,{"$f":"IF(R35=0,0,VLOOKUP(R35,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(R35=\"\",0,VLOOKUP(R35,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",{"$f":"IF(C35=0,0,VLOOKUP(C35,'Cover Sheet'!$D$18:$G$30,4,0))","v":0},{"$f":"IF(F35=0,0,VLOOKUP(F35,'Cover Sheet'!$D$18:$G$42,4,0))","v":0},null,null,0,7.53,"-","-","-",null,"",0,"-",0,0,null,0,7.53,"-","-","-",null,"",0,"-",0,0]
[18,null,null,null,{"$f":"IF($G36=0,0,VLOOKUP(C36,'Cover Sheet'!$D$18:$F$30,3,0))","v":0},null,0,{"$f":"IF($G36=0,0,VLOOKUP(F36,'Cover Sheet'!$D$18:$F$42,3,0))","v":0},null,{"$f":"IF(I36=0,0,VLOOKUP(I36,'Cover Sheet'!$L$18:$M$24,2,0))","v":0},0,null,{"$f":"IF(L36=0,0,VLOOKUP(L36,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(L36=\"\",0,VLOOKUP(L36,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",null,{"$f":"IF(R36=0,0,VLOOKUP(R36,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(R36=\"\",0,VLOOKUP(R36,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",{"$f":"IF(C36=0,0,VLOOKUP(C36,'Cover Sheet'!$D$18:$G$30,4,0))","v":0},{"$f":"IF(F36=0,0,VLOOKUP(F36,'Cover Sheet'!$D$18:$G$42,4,0))","v":0},null,null,0,7.53,"-","-","-",null,"",0,"-",0,0,null,0,7.53,"-","-","-",null,"",0,"-",0,0]
[19,null,null,null,{"$f":"IF($G37=0,0,VLOOKUP(C37,'Cover Sheet'!$D$18:$F$30,3,0))","v":0},null,0,{"$f":"IF($G37=0,0,VLOOKUP(F37,'Cover Sheet'!$D$18:$F$42,3,0))","v":0},null,{"$f":"IF(I37=0,0,VLOOKUP(I37,'Cover Sheet'!$L$18:$M$24,2,0))","v":0},0,null,{"$f":"IF(L37=0,0,VLOOKUP(L37,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(L37=\"\",0,VLOOKUP(L37,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",null,{"$f":"IF(R37=0,0,VLOOKUP(R37,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(R37=\"\",0,VLOOKUP(R37,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",{"$f":"IF(C37=0,0,VLOOKUP(C37,'Cover Sheet'!$D$18:$G$30,4,0))","v":0},{"$f":"IF(F37=0,0,VLOOKUP(F37,'Cover Sheet'!$D$18:$G$42,4,0))","v":0},null,null,0,7.53,"-","-","-",null,"",0,"-",0,0,null,0,7.53,"-","-","-",null,"",0,"-",0,0]
[{"$f":"A37+1","v":20},null,null,null,{"$f":"IF($G38=0,0,VLOOKUP(C38,'Cover Sheet'!$D$18:$F$30,3,0))","v":0},null,{"$f":"D38","v":0},{"$f":"IF($G38=0,0,VLOOKUP(F38,'Cover Sheet'!$D$18:$F$42,3,0))","v":0},null,{"$f":"IF(I38=0,0,VLOOKUP(I38,'Cover Sheet'!$L$18:$M$24,2,0))","v":0},{"$f":"IF(J38>0,H38*(1-J38),H38)","v":0},null,{"$f":"IF(L38=0,0,VLOOKUP(L38,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},{"$f":"IF(M38>0,ROUNDUP(K38*(1-M38),2),K38)","v":0},null,{"$f":"IF(L38=\"\",0,VLOOKUP(L38,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},{"$f":"IF(L38=\"\",\"-\",IF(OR(L38=\"PP1\",L38=\"P2\"),P38*$D$10*E38*G38/12*43560,P38*$D$10*K38*G38/12*43560))","v":"-"},null,{"$f":"IF(R38=0,0,VLOOKUP(R38,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},{"$f":"IF(S38>0,N38*(1-S38),N38)","v":0},null,{"$f":"IF(R38=\"\",0,VLOOKUP(R38,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},{"$f":"IF(R38=\"\",\"-\",V38*$D$10*N38*G38/12*43560)","v":"-"},{"$f":"IF(C38=0,0,VLOOKUP(C38,'Cover Sheet'!$D$18:$G$30,4,0))","v":0},{"$f":"IF(F38=0,0,VLOOKUP(F38,'Cover Sheet'!$D$18:$G$42,4,0))","v":0},null,null,{"$f":"Y38","v":0},7.53,{"$f":"IF(AB38=0,\"-\",1000/AB38-10)","v":"-"},{"$f":"IF(AB38=0,\"-\",(AC38-0.2*AD38)^2/(AC38+0.8*AD38))","v":"-"},{"$f":"Q38","v":"-"},null,{"$f":"IF(AG38=\"\",\"\",AF38*AG38)","v":""},{"$f":"IF(OR(AB38=0,L38=\"\"),0,12*AH38/43560/D38)","v":0},{"$f":"IF(AB38=0,\"-\",AE38-AI38)","v":"-"},{"$f":"IF(AB38=0,0,1000/(10+5*AC38+10*AJ38-10*(AJ38^2+1.25*AJ38*AC38)^(1/2)))","v":0},{"$f":"AK38-AB38","v":0},null,{"$f":"AK38","v":0},7.53,{"$f":"IF(AN38=0,\"-\",1000/AN38-10)","v":"-"},"-",{"$f":"W38","v":"-"},null,{"$f":"IF(AS38=\"\",\"\",AR38*AS38)","v":""},{"$f":"IF(OR(AN38=0,R38=\"\"),0,12*AT38/43560/D38)","v":0},{"$f":"IF(AN38=0,\"-\",AQ38-AU38)","v":"-"},{"$f":"IF(AN38=0,0,1000/(10+5*AO38+10*AV38-10*(AV38^2+1.25*AV38*AO38)^(1/2)))","v":0},{"$f":"AW38-AN38","v":0}]
[21,null,null,null,{"$f":"IF($G39=0,0,VLOOKUP(C39,'Cover Sheet'!$D$18:$F$30,3,0))","v":0},null,0,{"$f":"IF($G39=0,0,VLOOKUP(F39,'Cover Sheet'!$D$18:$F$42,3,0))","v":0},null,{"$f":"IF(I39=0,0,VLOOKUP(I39,'Cover Sheet'!$L$18:$M$24,2,0))","v":0},0,null,{"$f":"IF(L39=0,0,VLOOKUP(L39,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(L39=\"\",0,VLOOKUP(L39,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",null,{"$f":"IF(R39=0,0,VLOOKUP(R39,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(R39=\"\",0,VLOOKUP(R39,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",{"$f":"IF(C39=0,0,VLOOKUP(C39,'Cover Sheet'!$D$18:$G$30,4,0))","v":0},{"$f":"IF(F39=0,0,VLOOKUP(F39,'Cover Sheet'!$D$18:$G$42,4,0))","v":0},null,null,0,7.53,"-","-","-",null,"",0,"-",0,0,null,0,7.53,"-","-","-",null,"",0,"-",0,0]
[22,null,null,null,{"$f":"IF($G40=0,0,VLOOKUP(C40,'Cover Sheet'!$D$18:$F$30,3,0))","v":0},null,0,{"$f":"IF($G40=0,0,VLOOKUP(F40,'Cover Sheet'!$D$18:$F$42,3,0))","v":0},null,{"$f":"IF(I40=0,0,VLOOKUP(I40,'Cover Sheet'!$L$18:$M$24,2,0))","v":0},0,null,{"$f":"IF(L40=0,0,VLOOKUP(L40,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(L40=\"\",0,VLOOKUP(L40,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",null,{"$f":"IF(R40=0,0,VLOOKUP(R40,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(R40=\"\",0,VLOOKUP(R40,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",{"$f":"IF(C40=0,0,VLOOKUP(C40,'Cover Sheet'!$D$18:$G$30,4,0))","v":0},{"$f":"IF(F40=0,0,VLOOKUP(F40,'Cover Sheet'!$D$18:$G$42,4,0))","v":0},null,null,0,7.53,"-",{"$f":"IF(AB40=0,\"-\",(AC40-0.2*AD40)^2/(AC40+0.8*AD40))","v":"-"},"-",null,"",0,"-",0,0,null,0,7.53,"-",{"$f":"IF(AN40=0,\"-\",(AO40-0.2*AP40)^2/(AO40+0.8*AP40))","v":"-"},"-",null,"",0,"-",0,0]
[23,null,null,null,{"$f":"IF($G41=0,0,VLOOKUP(C41,'Cover Sheet'!$D$18:$F$30,3,0))","v":0},null,0,{"$f":"IF($G41=0,0,VLOOKUP(F41,'Cover Sheet'!$D$18:$F$42,3,0))","v":0},null,{"$f":"IF(I41=0,0,VLOOKUP(I41,'Cover Sheet'!$L$18:$M$24,2,0))","v":0},0,null,{"$f":"IF(L41=0,0,VLOOKUP(L41,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(L41=\"\",0,VLOOKUP(L41,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",null,{"$f":"IF(R41=0,0,VLOOKUP(R41,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(R41=\"\",0,VLOOKUP(R41,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",{"$f":"IF(C41=0,0,VLOOKUP(C41,'Cover Sheet'!$D$18:$G$30,4,0))","v":0},{"$f":"IF(F41=0,0,VLOOKUP(F41,'Cover Sheet'!$D$18:$G$42,4,0))","v":0},null,null,0,7.53,"-",{"$f":"IF(AB41=0,\"-\",(AC41-0.2*AD41)^2/(AC41+0.8*AD41))","v":"-"},"-",null,"",0,"-",0,0,null,0,7.53,"-",{"$f":"IF(AN41=0,\"-\",(AO41-0.2*AP41)^2/(AO41+0.8*AP41))","v":"-"},"-",null,"",0,"-",0,0]
[24,null,null,null,{"$f":"IF($G42=0,0,VLOOKUP(C42,'Cover Sheet'!$D$18:$F$30,3,0))","v":0},null,0,{"$f":"IF($G42=0,0,VLOOKUP(F42,'Cover Sheet'!$D$18:$F$42,3,0))","v":0},null,{"$f":"IF(I42=0,0,VLOOKUP(I42,'Cover Sheet'!$L$18:$M$24,2,0))","v":0},0,null,{"$f":"IF(L42=0,0,VLOOKUP(L42,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(L42=\"\",0,VLOOKUP(L42,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",null,{"$f":"IF(R42=0,0,VLOOKUP(R42,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(R42=\"\",0,VLOOKUP(R42,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",{"$f":"IF(C42=0,0,VLOOKUP(C42,'Cover Sheet'!$D$18:$G$30,4,0))","v":0},{"$f":"IF(F42=0,0,VLOOKUP(F42,'Cover Sheet'!$D$18:$G$42,4,0))","v":0},null,null,0,7.53,"-","-","-",null,"",0,"-",0,0,null,0,7.53,"-","-","-",null,"",0,"-",0,0]
[{"$f":"A42+1","v":25},null,null,null,{"$f":"IF($G43=0,0,VLOOKUP(C43,'Cover Sheet'!$D$18:$F$30,3,0))","v":0},null,0,{"$f":"IF($G43=0,0,VLOOKUP(F43,'Cover Sheet'!$D$18:$F$42,3,0))","v":0},null,{"$f":"IF(I43=0,0,VLOOKUP(I43,'Cover Sheet'!$L$18:$M$24,2,0))","v":0},0,null,{"$f":"IF(L43=0,0,VLOOKUP(L43,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(L43=\"\",0,VLOOKUP(L43,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",null,{"$f":"IF(R43=0,0,VLOOKUP(R43,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(R43=\"\",0,VLOOKUP(R43,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",{"$f":"IF(C43=0,0,VLOOKUP(C43,'Cover Sheet'!$D$18:$G$30,4,0))","v":0},{"$f":"IF(F43=0,0,VLOOKUP(F43,'Cover Sheet'!$D$18:$G$42,4,0))","v":0},null,null,0,7.53,"-","-","-",null,"",0,"-",0,0,null,0,7.53,"-","-","-",null,"",0,"-",0,0]
[26,null,null,null,{"$f":"IF($G44=0,0,VLOOKUP(C44,'Cover Sheet'!$D$18:$F$30,3,0))","v":0},null,0,{"$f":"IF($G44=0,0,VLOOKUP(F44,'Cover Sheet'!$D$18:$F$42,3,0))","v":0},null,{"$f":"IF(I44=0,0,VLOOKUP(I44,'Cover Sheet'!$L$18:$M$24,2,0))","v":0},0,null,{"$f":"IF(L44=0,0,VLOOKUP(L44,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(L44=\"\",0,VLOOKUP(L44,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",null,{"$f":"IF(R44=0,0,VLOOKUP(R44,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(R44=\"\",0,VLOOKUP(R44,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",{"$f":"IF(C44=0,0,VLOOKUP(C44,'Cover Sheet'!$D$18:$G$30,4,0))","v":0},{"$f":"IF(F44=0,0,VLOOKUP(F44,'Cover Sheet'!$D$18:$G$42,4,0))","v":0},null,null,0,7.53,"-","-","-",null,"",0,"-",0,0,null,0,7.53,"-","-","-",null,"",0,"-",0,0]
[27,null,null,null,{"$f":"IF($G45=0,0,VLOOKUP(C45,'Cover Sheet'!$D$18:$F$30,3,0))","v":0},null,0,{"$f":"IF($G45=0,0,VLOOKUP(F45,'Cover Sheet'!$D$18:$F$42,3,0))","v":0},null,{"$f":"IF(I45=0,0,VLOOKUP(I45,'Cover Sheet'!$L$18:$M$24,2,0))","v":0},0,null,{"$f":"IF(L45=0,0,VLOOKUP(L45,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(L45=\"\",0,VLOOKUP(L45,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",null,{"$f":"IF(R45=0,0,VLOOKUP(R45,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(R45=\"\",0,VLOOKUP(R45,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",{"$f":"IF(C45=0,0,VLOOKUP(C45,'Cover Sheet'!$D$18:$G$30,4,0))","v":0},{"$f":"IF(F45=0,0,VLOOKUP(F45,'Cover Sheet'!$D$18:$G$42,4,0))","v":0},null,null,0,7.53,"-","-","-",null,"",0,"-",0,0,null,0,7.53,"-","-","-",null,"",0,"-",0,0]
[28,null,null,null,{"$f":"IF($G46=0,0,VLOOKUP(C46,'Cover Sheet'!$D$18:$F$30,3,0))","v":0},null,0,{"$f":"IF($G46=0,0,VLOOKUP(F46,'Cover Sheet'!$D$18:$F$42,3,0))","v":0},null,{"$f":"IF(I46=0,0,VLOOKUP(I46,'Cover Sheet'!$L$18:$M$24,2,0))","v":0},0,null,{"$f":"IF(L46=0,0,VLOOKUP(L46,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(L46=\"\",0,VLOOKUP(L46,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",null,{"$f":"IF(R46=0,0,VLOOKUP(R46,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(R46=\"\",0,VLOOKUP(R46,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",{"$f":"IF(C46=0,0,VLOOKUP(C46,'Cover Sheet'!$D$18:$G$30,4,0))","v":0},{"$f":"IF(F46=0,0,VLOOKUP(F46,'Cover Sheet'!$D$18:$G$42,4,0))","v":0},null,null,0,7.53,"-","-","-",null,"",0,"-",0,0,null,0,7.53,"-","-","-",null,"",0,"-",0,0]
[29,null,null,null,{"$f":"IF($G47=0,0,VLOOKUP(C47,'Cover Sheet'!$D$18:$F$30,3,0))","v":0},null,0,{"$f":"IF($G47=0,0,VLOOKUP(F47,'Cover Sheet'!$D$18:$F$42,3,0))","v":0},null,{"$f":"IF(I47=0,0,VLOOKUP(I47,'Cover Sheet'!$L$18:$M$24,2,0))","v":0},0,null,{"$f":"IF(L47=0,0,VLOOKUP(L47,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(L47=\"\",0,VLOOKUP(L47,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",null,{"$f":"IF(R47=0,0,VLOOKUP(R47,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(R47=\"\",0,VLOOKUP(R47,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",{"$f":"IF(C47=0,0,VLOOKUP(C47,'Cover Sheet'!$D$18:$G$30,4,0))","v":0},{"$f":"IF(F47=0,0,VLOOKUP(F47,'Cover Sheet'!$D$18:$G$42,4,0))","v":0},null,null,0,7.53,"-","-","-",null,"",0,"-",0,0,null,0,7.53,"-","-","-",null,"",0,"-",0,0]
[{"$f":"A47+1","v":30},null,null,null,{"$f":"IF($G48=0,0,VLOOKUP(C48,'Cover Sheet'!$D$18:$F$30,3,0))","v":0},null,{"$f":"D48","v":0},{"$f":"IF($G48=0,0,VLOOKUP(F48,'Cover Sheet'!$D$18:$F$42,3,0))","v":0},null,{"$f":"IF(I48=0,0,VLOOKUP(I48,'Cover Sheet'!$L$18:$M$24,2,0))","v":0},{"$f":"IF(J48>0,H48*(1-J48),H48)","v":0},null,{"$f":"IF(L48=0,0,VLOOKUP(L48,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},{"$f":"IF(M48>0,ROUNDUP(K48*(1-M48),2),K48)","v":0},null,{"$f":"IF(L48=\"\",0,VLOOKUP(L48,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},{"$f":"IF(L48=\"\",\"-\",IF(OR(L48=\"PP1\",L48=\"P2\"),P48*$D$10*E48*G48/12*43560,P48*$D$10*K48*G48/12*43560))","v":"-"},null,{"$f":"IF(R48=0,0,VLOOKUP(R48,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},{"$f":"IF(S48>0,N48*(1-S48),N48)","v":0},null,{"$f":"IF(R48=\"\",0,VLOOKUP(R48,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},{"$f":"IF(R48=\"\",\"-\",V48*$D$10*N48*G48/12*43560)","v":"-"},{"$f":"IF(C48=0,0,VLOOKUP(C48,'Cover Sheet'!$D$18:$G$30,4,0))","v":0},{"$f":"IF(F48=0,0,VLOOKUP(F48,'Cover Sheet'!$D$18:$G$42,4,0))","v":0},null,null,{"$f":"Y48","v":0},7.53,{"$f":"IF(AB48=0,\"-\",1000/AB48-10)","v":"-"},"-",{"$f":"Q48","v":"-"},null,{"$f":"IF(AG48=\"\",\"\",AF48*AG48)","v":""},{"$f":"IF(OR(AB48=0,L48=\"\"),0,12*AH48/43560/D48)","v":0},{"$f":"IF(AB48=0,\"-\",AE48-AI48)","v":"-"},{"$f":"IF(AB48=0,0,1000/(10+5*AC48+10*AJ48-10*(AJ48^2+1.25*AJ48*AC48)^(1/2)))","v":0},{"$f":"AK48-AB48","v":0},null,{"$f":"AK48","v":0},7.53,{"$f":"IF(AN48=0,\"-\",1000/AN48-10)","v":"-"},"-",{"$f":"W48","v":"-"},null,{"$f":"IF(AS48=\"\",\"\",AR48*AS48)","v":""},{"$f":"IF(OR(AN48=0,R48=\"\"),0,12*AT48/43560/D48)","v":0},{"$f":"IF(AN48=0,\"-\",AQ48-AU48)","v":"-"},{"$f":"IF(AN48=0,0,1000/(10+5*AO48+10*AV48-10*(AV48^2+1.25*AV48*AO48)^(1/2)))","v":0},{"$f":"AW48-AN48","v":0}]
[31,null,null,null,{"$f":"IF($G49=0,0,VLOOKUP(C49,'Cover Sheet'!$D$18:$F$30,3,0))","v":0},null,0,{"$f":"IF($G49=0,0,VLOOKUP(F49,'Cover Sheet'!$D$18:$F$42,3,0))","v":0},null,{"$f":"IF(I49=0,0,VLOOKUP(I49,'Cover Sheet'!$L$18:$M$24,2,0))","v":0},0,null,{"$f":"IF(L49=0,0,VLOOKUP(L49,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(L49=\"\",0,VLOOKUP(L49,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",null,{"$f":"IF(R49=0,0,VLOOKUP(R49,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(R49=\"\",0,VLOOKUP(R49,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",{"$f":"IF(C49=0,0,VLOOKUP(C49,'Cover Sheet'!$D$18:$G$30,4,0))","v":0},{"$f":"IF(F49=0,0,VLOOKUP(F49,'Cover Sheet'!$D$18:$G$42,4,0))","v":0},null,null,0,7.53,"-","-","-",null,"",0,"-",0,0,null,0,7.53,"-","-","-",null,"",0,"-",0,0]
[32,null,null,null,{"$f":"IF($G50=0,0,VLOOKUP(C50,'Cover Sheet'!$D$18:$F$30,3,0))","v":0},null,0,{"$f":"IF($G50=0,0,VLOOKUP(F50,'Cover Sheet'!$D$18:$F$42,3,0))","v":0},null,{"$f":"IF(I50=0,0,VLOOKUP(I50,'Cover Sheet'!$L$18:$M$24,2,0))","v":0},0,null,{"$f":"IF(L50=0,0,VLOOKUP(L50,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(L50=\"\",0,VLOOKUP(L50,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",null,{"$f":"IF(R50=0,0,VLOOKUP(R50,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(R50=\"\",0,VLOOKUP(R50,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",{"$f":"IF(C50=0,0,VLOOKUP(C50,'Cover Sheet'!$D$18:$G$30,4,0))","v":0},{"$f":"IF(F50=0,0,VLOOKUP(F50,'Cover Sheet'!$D$18:$G$42,4,0))","v":0},null,null,0,7.53,"-",{"$f":"IF(AB50=0,\"-\",(AC50-0.2*AD50)^2/(AC50+0.8*AD50))","v":"-"},"-",null,"",0,"-",0,0,null,0,7.53,"-",{"$f":"IF(AN50=0,\"-\",(AO50-0.2*AP50)^2/(AO50+0.8*AP50))","v":"-"},"-",null,"",0,"-",0,0]
[33,null,null,null,{"$f":"IF($G51=0,0,VLOOKUP(C51,'Cover Sheet'!$D$18:$F$30,3,0))","v":0},null,0,{"$f":"IF($G51=0,0,VLOOKUP(F51,'Cover Sheet'!$D$18:$F$42,3,0))","v":0},null,{"$f":"IF(I51=0,0,VLOOKUP(I51,'Cover Sheet'!$L$18:$M$24,2,0))","v":0},0,null,{"$f":"IF(L51=0,0,VLOOKUP(L51,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(L51=\"\",0,VLOOKUP(L51,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",null,{"$f":"IF(R51=0,0,VLOOKUP(R51,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(R51=\"\",0,VLOOKUP(R51,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",{"$f":"IF(C51=0,0,VLOOKUP(C51,'Cover Sheet'!$D$18:$G$30,4,0))","v":0},{"$f":"IF(F51=0,0,VLOOKUP(F51,'Cover Sheet'!$D$18:$G$42,4,0))","v":0},null,null,0,7.53,"-",{"$f":"IF(AB51=0,\"-\",(AC51-0.2*AD51)^2/(AC51+0.8*AD51))","v":"-"},"-",null,"",0,"-",0,0,null,0,7.53,"-",{"$f":"IF(AN51=0,\"-\",(AO51-0.2*AP51)^2/(AO51+0.8*AP51))","v":"-"},"-",null,"",0,"-",0,0]
[34,null,null,null,{"$f":"IF($G52=0,0,VLOOKUP(C52,'Cover Sheet'!$D$18:$F$30,3,0))","v":0},null,0,{"$f":"IF($G52=0,0,VLOOKUP(F52,'Cover Sheet'!$D$18:$F$42,3,0))","v":0},null,{"$f":"IF(I52=0,0,VLOOKUP(I52,'Cover Sheet'!$L$18:$M$24,2,0))","v":0},0,null,{"$f":"IF(L52=0,0,VLOOKUP(L52,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(L52=\"\",0,VLOOKUP(L52,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",null,{"$f":"IF(R52=0,0,VLOOKUP(R52,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(R52=\"\",0,VLOOKUP(R52,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",{"$f":"IF(C52=0,0,VLOOKUP(C52,'Cover Sheet'!$D$18:$G$30,4,0))","v":0},{"$f":"IF(F52=0,0,VLOOKUP(F52,'Cover Sheet'!$D$18:$G$42,4,0))","v":0},null,null,0,7.53,"-","-","-",null,"",0,"-",0,0,null,0,7.53,"-","-","-",null,"",0,"-",0,0]
[35,null,null,null,{"$f":"IF($G53=0,0,VLOOKUP(C53,'Cover Sheet'!$D$18:$F$30,3,0))","v":0},null,0,{"$f":"IF($G53=0,0,VLOOKUP(F53,'Cover Sheet'!$D$18:$F$42,3,0))","v":0},null,{"$f":"IF(I53=0,0,VLOOKUP(I53,'Cover Sheet'!$L$18:$M$24,2,0))","v":0},0,null,{"$f":"IF(L53=0,0,VLOOKUP(L53,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(L53=\"\",0,VLOOKUP(L53,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",null,{"$f":"IF(R53=0,0,VLOOKUP(R53,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(R53=\"\",0,VLOOKUP(R53,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",{"$f":"IF(C53=0,0,VLOOKUP(C53,'Cover Sheet'!$D$18:$G$30,4,0))","v":0},{"$f":"IF(F53=0,0,VLOOKUP(F53,'Cover Sheet'!$D$18:$G$42,4,0))","v":0},null,null,0,7.53,"-","-","-",null,"",0,"-",0,0,null,0,7.53,"-","-","-",null,"",0,"-",0,0]
[36,null,null,null,{"$f":"IF($G54=0,0,VLOOKUP(C54,'Cover Sheet'!$D$18:$F$30,3,0))","v":0},null,0,{"$f":"IF($G54=0,0,VLOOKUP(F54,'Cover Sheet'!$D$18:$F$42,3,0))","v":0},null,{"$f":"IF(I54=0,0,VLOOKUP(I54,'Cover Sheet'!$L$18:$M$24,2,0))","v":0},0,null,{"$f":"IF(L54=0,0,VLOOKUP(L54,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(L54=\"\",0,VLOOKUP(L54,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",null,{"$f":"IF(R54=0,0,VLOOKUP(R54,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(R54=\"\",0,VLOOKUP(R54,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",{"$f":"IF(C54=0,0,VLOOKUP(C54,'Cover Sheet'!$D$18:$G$30,4,0))","v":0},{"$f":"IF(F54=0,0,VLOOKUP(F54,'Cover Sheet'!$D$18:$G$42,4,0))","v":0},null,null,0,7.53,"-","-","-",null,"",0,"-",0,0,null,0,7.53,"-","-","-",null,"",0,"-",0,0]
[37,null,null,null,{"$f":"IF($G55=0,0,VLOOKUP(C55,'Cover Sheet'!$D$18:$F$30,3,0))","v":0},null,0,{"$f":"IF($G55=0,0,VLOOKUP(F55,'Cover Sheet'!$D$18:$F$42,3,0))","v":0},null,{"$f":"IF(I55=0,0,VLOOKUP(I55,'Cover Sheet'!$L$18:$M$24,2,0))","v":0},0,null,{"$f":"IF(L55=0,0,VLOOKUP(L55,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(L55=\"\",0,VLOOKUP(L55,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",null,{"$f":"IF(R55=0,0,VLOOKUP(R55,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(R55=\"\",0,VLOOKUP(R55,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",{"$f":"IF(C55=0,0,VLOOKUP(C55,'Cover Sheet'!$D$18:$G$30,4,0))","v":0},{"$f":"IF(F55=0,0,VLOOKUP(F55,'Cover Sheet'!$D$18:$G$42,4,0))","v":0},null,null,0,7.53,"-","-","-",null,"",0,"-",0,0,null,0,7.53,"-","-","-",null,"",0,"-",0,0]
[38,null,null,null,{"$f":"IF($G56=0,0,VLOOKUP(C56,'Cover Sheet'!$D$18:$F$30,3,0))","v":0},null,0,{"$f":"IF($G56=0,0,VLOOKUP(F56,'Cover Sheet'!$D$18:$F$42,3,0))","v":0},null,{"$f":"IF(I56=0,0,VLOOKUP(I56,'Cover Sheet'!$L$18:$M$24,2,0))","v":0},0,null,{"$f":"IF(L56=0,0,VLOOKUP(L56,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(L56=\"\",0,VLOOKUP(L56,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",null,{"$f":"IF(R56=0,0,VLOOKUP(R56,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(R56=\"\",0,VLOOKUP(R56,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",{"$f":"IF(C56=0,0,VLOOKUP(C56,'Cover Sheet'!$D$18:$G$30,4,0))","v":0},{"$f":"IF(F56=0,0,VLOOKUP(F56,'Cover Sheet'!$D$18:$G$42,4,0))","v":0},null,null,0,7.53,"-","-","-",null,"",0,"-",0,0,null,0,7.53,"-","-","-",null,"",0,"-",0,0]
[39,null,null,null,{"$f":"IF($G57=0,0,VLOOKUP(C57,'Cover Sheet'!$D$18:$F$30,3,0))","v":0},null,0,{"$f":"IF($G57=0,0,VLOOKUP(F57,'Cover Sheet'!$D$18:$F$42,3,0))","v":0},null,{"$f":"IF(I57=0,0,VLOOKUP(I57,'Cover Sheet'!$L$18:$M$24,2,0))","v":0},0,null,{"$f":"IF(L57=0,0,VLOOKUP(L57,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(L57=\"\",0,VLOOKUP(L57,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",null,{"$f":"IF(R57=0,0,VLOOKUP(R57,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(R57=\"\",0,VLOOKUP(R57,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",{"$f":"IF(C57=0,0,VLOOKUP(C57,'Cover Sheet'!$D$18:$G$30,4,0))","v":0},{"$f":"IF(F57=0,0,VLOOKUP(F57,'Cover Sheet'!$D$18:$G$42,4,0))","v":0},null,null,0,7.53,"-","-","-",null,"",0,"-",0,0,null,0,7.53,"-","-","-",null,"",0,"-",0,0]
[{"$f":"A57+1","v":40},null,null,null,{"$f":"IF($G58=0,0,VLOOKUP(C58,'Cover Sheet'!$D$18:$F$30,3,0))","v":0},null,0,{"$f":"IF($G58=0,0,VLOOKUP(F58,'Cover Sheet'!$D$18:$F$42,3,0))","v":0},null,{"$f":"IF(I58=0,0,VLOOKUP(I58,'Cover Sheet'!$L$18:$M$24,2,0))","v":0},0,null,{"$f":"IF(L58=0,0,VLOOKUP(L58,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(L58=\"\",0,VLOOKUP(L58,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",null,{"$f":"IF(R58=0,0,VLOOKUP(R58,'Cover Sheet'!$L$25:$M$40,2,0))","v":0},0,null,{"$f":"IF(R58=\"\",0,VLOOKUP(R58,'Cover Sheet'!$L$18:$O$40,4,0))","v":0},"-",{"$f":"IF(C58=0,0,VLOOKUP(C58,'Cover Sheet'!$D$18:$G$30,4,0))","v":0},{"$f":"IF(F58=0,0,VLOOKUP(F58,'Cover Sheet'!$D$18:$G$42,4,0))","v":0},null,null,0,7.53,{"$f":"IF(AB58=0,\"-\",1000/AB58-10)","v":"-"},{"$f":"IF(AB58=0,\"-\",(AC58-0.2*AD58)^2/(AC58+0.8*AD58))","v":"-"},{"$f":"Q58","v":"-"},null,"",0,{"$f":"IF(AB58=0,\"-\",AE58-AI58)","v":"-"},{"$f":"IF(AB58=0,0,1000/(10+5*AC58+10*AJ58-10*(AJ58^2+1.25*AJ58*AC58)^(1/2)))","v":0},0,null,0,7.53,{"$f":"IF(AN58=0,\"-\",1000/AN58-10)","v":"-"},{"$f":"IF(AN58=0,\"-\",(AO58-0.2*AP58)^2/(AO58+0.8*AP58))","v":"-"},"-",null,"",0,{"$f":"IF(AN58=0,\"-\",AQ58-AU58)","v":"-"},{"$f":"IF(AN58=0,0,1000/(10+5*AO58+10*AV58-10*(AV58^2+1.25*AV58*AO58)^(1/2)))","v":0},0]
[null,null,"Weighted Rv",null,{"$f":"E60/D60","v":{"$error":"#DIV/0!"}},"Weighted Rv",null,{"$f":"H60/G60","v":{"$error":"#DIV/0!"}},"Weighted Rv",null,{"$f":"K60/G60","v":{"$error":"#DIV/0!"}},"Weighted Rv",null,{"$f":"N60/G60","v":{"$error":"#DIV/0!"}},null,"Step 3 Tv Total",{"$f":"SUM(Q19:Q58)","v":0},null,null,{"$f":"T60/G60","v":{"$error":"#DIV/0!"}},null,"Final Tv Total",{"$f":"SUM(W19:W58)+Q59","v":0},{"$f":"SUMPRODUCT($D$19:$D$58,$X$19:$X$58)/$D$60","v":{"$error":"#DIV/0!"}},{"$f":"SUMPRODUCT($D$19:$D$58,$Y$19:$Y$58)/$D$60","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUMPRODUCT($D$19:$D$58,$Y$19:$Y$58)/$D$60","v":{"$error":"#DIV/0!"}},null,{"$f":"1000/AB59-10","v":{"$error":"#DIV/0!"}},{"$f":"(AC59-0.2*AD59)^2/(AC59+0.8*AD59)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AF19:AF58)","v":0},null,null,{"$f":"12*AF59/43560/D60","v":{"$error":"#DIV/0!"}},{"$f":"AE59-AI59","v":{"$error":"#DIV/0!"}},{"$f":"SUMPRODUCT($D$19:$D$58,$AK$19:$AK$58)/$D$60","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$f":"SUMPRODUCT($D$19:$D$58,$Y$19:$Y$58)/$D$60","v":{"$error":"#DIV/0!"}},null,{"$f":"1000/AN59-10","v":{"$error":"#DIV/0!"}},{"$f":"(AO59-0.2*AP59)^2/(AO59+0.8*AP59)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AR19:AR58)","v":0},null,null,{"$f":"12*AR59/43560/P60","v":{"$error":"#DIV/0!"}},{"$f":"AQ59-AU59","v":{"$error":"#DIV/0!"}},{"$f":"SUMPRODUCT($D$19:$D$58,$AW$19:$AW$58)/$D$60","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,"Total Area=",{"$f":"SUM(D19:D58)","v":0},{"$f":"SUMPRODUCT($G19:$G58,E19:E58)","v":0},"Total Area=",{"$f":"SUM(G19:G58)","v":0},{"$f":"SUMPRODUCT($G19:$G58,H19:H58)","v":0},null,null,{"$f":"SUMPRODUCT($G19:$G58,K19:K58)","v":0},null,null,{"$f":"SUMPRODUCT($G19:$G58,N19:N58)","v":0},null,null,null,null,null,{"$f":"SUMPRODUCT($G19:$G58,T19:T58)","v":0},null,null,null,null,null,null,null,null,"Note that this assumes the same Pre- and Post-developpmentTc and Drainage Areas",null,null,null,null,null,null,null,{"$f":"IF(AK59>$AB$5, \"DETENTION REQ\",\"OK\")","v":{"$error":"#DIV/0!"}},null,null,null,"Note that this assumes the same Pre- and Post-developpmentTc and Drainage Areas",null,null,null,null,null,null,null,{"$f":"IF(AW59>$AB$5, \"DETENTION REQ\",\"OK\")","v":{"$error":"#DIV/0!"}}]
["% Removal",null,null,null,{"$f":"(1-E60/$G60)","v":{"$error":"#DIV/0!"}},"% Removal ",null,{"$f":"1-H60/$G60","v":{"$error":"#DIV/0!"}},"% Removal ",null,{"$f":"1-K60/$G60","v":{"$error":"#DIV/0!"}},"% Removal ",null,{"$f":"1-N60/$G60","v":{"$error":"#DIV/0!"}},null,null,null,"% Removal ",null,{"$f":"1-T60/$G60","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"if this is not the case additional routing calculations will be required",null,null,null,null,null,null,null,null,null,null,null,"if this is not the case additional routing calculations will be required"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"THIS CELL WILL TURN GREEN WHEN",null,null,null,null,null,"THIS CELL WILL TURN GREEN WHEN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"TARGET RUNOFF REDUCTION MET",null,null,null,null,null,"TARGET RUNOFF REDUCTION MET"]

{"sheet":"Sheet1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}