Annual Recharge¶
Sheet visibility: visible.
Stored values and formulas are shown below. Cached formula results are source snapshots and have not been recalculated.
| Cell | Stored value or cached result | Formula |
|---|---|---|
| A1 | ||
| B1 | ||
| C1 | Annual Groundwater Recharge Analysis (based on GSR-32) | |
| D1 | ||
| E1 | ||
| F1 | ||
| G1 | ||
| H1 | ||
| I1 | ||
| J1 | Project Name: | |
| K1 | Sample Project | |
| L1 | ||
| M1 | ||
| N1 | ||
| O1 | ||
| P1 | ||
| Q1 | ||
| R1 | ||
| S1 | ||
| T1 | ||
| U1 | ||
| V1 | ||
| W1 | ||
| X1 | ||
| Y1 | ||
| Z1 | ||
| AA1 | ||
| AB1 | ||
| AC1 | ||
| AD1 | ||
| AE1 | ||
| AF1 | ||
| AG1 | ||
| AH1 | ||
| AI1 | ||
| AJ1 | ||
| AK1 | ||
| AL1 | ||
| AM1 | ||
| AN1 | ||
| AO1 | ||
| AP1 | ||
| AQ1 | ||
| A2 | ||
| B2 | ||
| C2 | Select Township ↓ | |
| D2 | Average Annual P (in) |
|
| E2 | Climatic Factor |
|
| F2 | ||
| G2 | ||
| H2 | ||
| I2 | ||
| J2 | Description: | |
| K2 | This is a test application | |
| L2 | ||
| M2 | ||
| N2 | ||
| O2 | ||
| P2 | ||
| Q2 | ||
| R2 | ||
| S2 | ||
| T2 | ||
| U2 | ||
| V2 | ||
| W2 | ||
| X2 | ||
| Y2 | ||
| Z2 | ||
| AA2 | ||
| AB2 | ||
| AC2 | ||
| AD2 | ||
| AE2 | ||
| AF2 | ||
| AG2 | ||
| AH2 | ||
| AI2 | ||
| AJ2 | ||
| AK2 | ||
| AL2 | ||
| AM2 | ||
| AN2 | ||
| AO2 | ||
| AP2 | ||
| AQ2 | ||
| A3 | ||
| B3 | ||
| C3 | MIDDLESEX CO., PERTH AMBOY CITY | |
| D3 | 47.8 | =VLOOKUP($C$3,MunicipalityTable,3) |
| E3 | 1.53 | =VLOOKUP($C$3,MunicipalityTable,4) |
| F3 | ||
| G3 | ||
| H3 | ||
| I3 | ||
| J3 | Analysis Date: | |
| K3 | 37865 | |
| L3 | ||
| M3 | ||
| N3 | ||
| O3 | ||
| P3 | ||
| Q3 | ||
| R3 | ||
| S3 | ||
| T3 | ||
| U3 | ||
| V3 | ||
| W3 | ||
| X3 | ||
| Y3 | ||
| Z3 | ||
| AA3 | 1 | |
| AB3 | 2 | |
| AC3 | 3 | |
| AD3 | 4 | |
| AE3 | 5 | |
| AF3 | 6 | |
| AG3 | 7 | |
| AH3 | 8 | |
| AI3 | 9 | |
| AJ3 | 10 | |
| AK3 | 11 | |
| AL3 | 12 | |
| AM3 | 13 | |
| AN3 | 14 | |
| AO3 | 15 | |
| AP3 | ||
| AQ3 | ||
| A4 | Pre-Developed Conditions | |
| B4 | ||
| C4 | ||
| D4 | ||
| E4 | ||
| F4 | ||
| G4 | ||
| H4 | Post-Developed Conditions | |
| I4 | ||
| J4 | ||
| K4 | ||
| L4 | ||
| M4 | ||
| N4 | ||
| O4 | ||
| P4 | ||
| Q4 | ||
| R4 | ||
| S4 | ||
| T4 | ||
| U4 | ||
| V4 | ||
| W4 | ||
| X4 | ||
| Y4 | ||
| Z4 | ||
| AA4 | ||
| AB4 | Pre-Developed Conditions | |
| AC4 | ||
| AD4 | ||
| AE4 | ||
| AF4 | Post-Developed Conditions | |
| AG4 | ||
| AH4 | ||
| AI4 | ||
| AJ4 | ||
| AK4 | ||
| AL4 | ||
| AM4 | ||
| AN4 | ||
| AO4 | ||
| AP4 | ||
| AQ4 | ||
| A5 | Land Segment |
|
| B5 | Area (acres) |
|
| C5 | TR-55 Land Cover | |
| D5 | Soil | |
| E5 | Annual Recharge (in) |
|
| F5 | Annual Recharge (cu.ft) |
|
| G5 | ||
| H5 | Land Segment |
|
| I5 | Area (acres) |
|
| J5 | TR-55 Land Cover | |
| K5 | Soil | |
| L5 | Annual Recharge (in) |
|
| M5 | Annual Recharge (cu.ft) |
|
| N5 | ||
| O5 | ||
| P5 | ||
| Q5 | ||
| R5 | ||
| S5 | ||
| T5 | ||
| U5 | ||
| V5 | ||
| W5 | ||
| X5 | ||
| Y5 | ||
| Z5 | ||
| AA5 | Land Segment |
|
| AB5 | LULC | |
| AC5 | R-factor | |
| AD5 | R-const | |
| AE5 | ||
| AF5 | LULC | |
| AG5 | R-factor | |
| AH5 | R-const | |
| AI5 | Root Depth Category |
|
| AJ5 | Soil No. | |
| AK5 | AWC | |
| AL5 | RWC | |
| AM5 | RootDepth | |
| AN5 | Max( 0 & Rootdepth-0.5*Dexc |
|
| AO5 | multiply by AWC |
|
| AP5 | BMP buried depth-> |
|
| AQ5 | 0 | =+dEXC-MAX(0,dBMPu) |
| A6 | 1 | |
| B6 | 1.4 | |
| C6 | Open space | |
| D6 | Woodstown | |
| E6 | 12.888200000000001 | =IF(B6=0,"-",+AC6*C_factor-'Annual Recharge'!AD6) |
| F6 | 65497.83239999999 | =IF(B6=0,"-",43560B6E6/12) |
| G6 | ||
| H6 | 1 | |
| I6 | 1.5 | |
| J6 | Impervious areas | |
| K6 | Keyport | |
| L6 | 0 | =IF(I6=0,"-",+AG6*C_factor-'Annual Recharge'!AH6) |
| M6 | 0 | =IF(I6=0,"-",43560I6L6/12) |
| N6 | ||
| O6 | ||
| P6 | ||
| Q6 | ||
| R6 | ||
| S6 | ||
| T6 | ||
| U6 | ||
| V6 | ||
| W6 | ||
| X6 | ||
| Y6 | ||
| Z6 | ||
| AA6 | 1 | |
| AB6 | 0 | =VLOOKUP(+C6,LULC!$A$3:$C$16,3) |
| AC6 | 15.94 | =+VLOOKUP(D6,SoilTable,3+'Annual Recharge'!AB6) |
| AD6 | 11.5 | =+VLOOKUP(D6,SoilTable,18+'Annual Recharge'!AB6) |
| AE6 | ||
| AF6 | 6 | =VLOOKUP(+J6,LULC!$A$3:$C$16,3) |
| AG6 | 0 | =+VLOOKUP(K6,SoilTable,3+'Annual Recharge'!AF6) |
| AH6 | 0 | =+VLOOKUP(K6,SoilTable,18+'Annual Recharge'!AF6) |
| AI6 | SHALLOW | =VLOOKUP(+J6,LULC!$A$3:$D$16,4) |
| AJ6 | 87 | =VLOOKUP(K6,SoilTable,2) |
| AK6 | 0.15832 | =HLOOKUP($AI6,'Soil '!$AJ$2:$AN$210,$AJ6+1) |
| AL6 | 2.3748 | =HLOOKUP($AI6,'Soil '!$AO$2:$AS$210,$AJ6+1) |
| AM6 | 15 | =HLOOKUP($AI6,'Soil '!$AT$2:$AX$210,$AJ6+1) |
| AN6 | 15 | =MAX(0,AM6-dEXC+0.5*$AQ$5) |
| AO6 | 2.3748 | =+AN6*AK6 |
| AP6 | ||
| AQ6 | ||
| A7 | 2 | |
| B7 | 0.3 | |
| C7 | Gravel, dirt | |
| D7 | Woodstown | |
| E7 | 6.919900000000001 | =IF(B7=0,"-",+AC7*C_factor-'Annual Recharge'!AD7) |
| F7 | 7535.771100000001 | =IF(B7=0,"-",43560B7E7/12) |
| G7 | ||
| H7 | 2 | |
| I7 | 1.6 | |
| J7 | Gravel, dirt | |
| K7 | Woodstown | |
| L7 | 6.919900000000001 | =IF(I7=0,"-",+AG7*C_factor-'Annual Recharge'!AH7) |
| M7 | 40190.779200000004 | =IF(I7=0,"-",43560I7L7/12) |
| N7 | ||
| O7 | ||
| P7 | ||
| Q7 | ||
| R7 | ||
| S7 | ||
| T7 | ||
| U7 | ||
| V7 | ||
| W7 | ||
| X7 | ||
| Y7 | ||
| Z7 | ||
| AA7 | 2 | |
| AB7 | 7 | =VLOOKUP(+C7,LULC!$A$3:$C$16,3) |
| AC7 | 7.83 | =+VLOOKUP(D7,SoilTable,3+'Annual Recharge'!AB7) |
| AD7 | 5.06 | =+VLOOKUP(D7,SoilTable,18+'Annual Recharge'!AB7) |
| AE7 | ||
| AF7 | 7 | =VLOOKUP(+J7,LULC!$A$3:$C$16,3) |
| AG7 | 7.83 | =+VLOOKUP(K7,SoilTable,3+'Annual Recharge'!AF7) |
| AH7 | 5.06 | =+VLOOKUP(K7,SoilTable,18+'Annual Recharge'!AF7) |
| AI7 | SHALLOW | =VLOOKUP(+J7,LULC!$A$3:$D$16,4) |
| AJ7 | 206 | =VLOOKUP(K7,SoilTable,2) |
| AK7 | 0.11623333333333333 | =HLOOKUP($AI7,'Soil '!$AJ$2:$AN$210,$AJ7+1) |
| AL7 | 2.3246666666666664 | =HLOOKUP($AI7,'Soil '!$AO$2:$AS$210,$AJ7+1) |
| AM7 | 20 | =HLOOKUP($AI7,'Soil '!$AT$2:$AX$210,$AJ7+1) |
| AN7 | 20 | =MAX(0,AM7-dEXC+0.5*$AQ$5) |
| AO7 | 2.3246666666666664 | =+AN7*AK7 |
| AP7 | ||
| AQ7 | ||
| A8 | 3 | |
| B8 | 3.5 | |
| C8 | Woods-grass combination | |
| D8 | Woodstown | |
| E8 | 13.479299999999999 | =IF(B8=0,"-",+AC8*C_factor-'Annual Recharge'!AD8) |
| F8 | 171254.5065 | =IF(B8=0,"-",43560B8E8/12) |
| G8 | ||
| H8 | 3 | |
| I8 | 3.65 | |
| J8 | Open space | |
| K8 | Keyport | |
| L8 | 13.409300000000002 | =IF(I8=0,"-",+AG8*C_factor-'Annual Recharge'!AH8) |
| M8 | 177666.52035 | =IF(I8=0,"-",43560I8L8/12) |
| N8 | ||
| O8 | ||
| P8 | ||
| Q8 | ||
| R8 | ||
| S8 | ||
| T8 | ||
| U8 | ||
| V8 | ||
| W8 | ||
| X8 | ||
| Y8 | ||
| Z8 | ||
| AA8 | 3 | |
| AB8 | 9 | =VLOOKUP(+C8,LULC!$A$3:$C$16,3) |
| AC8 | 18.81 | =+VLOOKUP(D8,SoilTable,3+'Annual Recharge'!AB8) |
| AD8 | 15.3 | =+VLOOKUP(D8,SoilTable,18+'Annual Recharge'!AB8) |
| AE8 | ||
| AF8 | 0 | =VLOOKUP(+J8,LULC!$A$3:$C$16,3) |
| AG8 | 13.81 | =+VLOOKUP(K8,SoilTable,3+'Annual Recharge'!AF8) |
| AH8 | 7.72 | =+VLOOKUP(K8,SoilTable,18+'Annual Recharge'!AF8) |
| AI8 | MODERATE | =VLOOKUP(+J8,LULC!$A$3:$D$16,4) |
| AJ8 | 87 | =VLOOKUP(K8,SoilTable,2) |
| AK8 | 0.1541066666666667 | =HLOOKUP($AI8,'Soil '!$AJ$2:$AN$210,$AJ8+1) |
| AL8 | 4.623200000000001 | =HLOOKUP($AI8,'Soil '!$AO$2:$AS$210,$AJ8+1) |
| AM8 | 30 | =HLOOKUP($AI8,'Soil '!$AT$2:$AX$210,$AJ8+1) |
| AN8 | 30 | =MAX(0,AM8-dEXC+0.5*$AQ$5) |
| AO8 | 4.623200000000001 | =+AN8*AK8 |
| AP8 | ||
| AQ8 | ||
| A9 | 4 | |
| B9 | 1.4 | |
| C9 | Open space | |
| D9 | Keyport | |
| E9 | 13.409300000000002 | =IF(B9=0,"-",+AC9*C_factor-'Annual Recharge'!AD9) |
| F9 | 68146.0626 | =IF(B9=0,"-",43560B9E9/12) |
| G9 | ||
| H9 | 4 | |
| I9 | 3.65 | |
| J9 | Open space | |
| K9 | Woodstown | |
| L9 | 12.888200000000001 | =IF(I9=0,"-",+AG9*C_factor-'Annual Recharge'!AH9) |
| M9 | 170762.20590000003 | =IF(I9=0,"-",43560I9L9/12) |
| N9 | ||
| O9 | ||
| P9 | ||
| Q9 | ||
| R9 | ||
| S9 | ||
| T9 | ||
| U9 | ||
| V9 | ||
| W9 | ||
| X9 | ||
| Y9 | ||
| Z9 | ||
| AA9 | 4 | |
| AB9 | 0 | =VLOOKUP(+C9,LULC!$A$3:$C$16,3) |
| AC9 | 13.81 | =+VLOOKUP(D9,SoilTable,3+'Annual Recharge'!AB9) |
| AD9 | 7.72 | =+VLOOKUP(D9,SoilTable,18+'Annual Recharge'!AB9) |
| AE9 | ||
| AF9 | 0 | =VLOOKUP(+J9,LULC!$A$3:$C$16,3) |
| AG9 | 15.94 | =+VLOOKUP(K9,SoilTable,3+'Annual Recharge'!AF9) |
| AH9 | 11.5 | =+VLOOKUP(K9,SoilTable,18+'Annual Recharge'!AF9) |
| AI9 | MODERATE | =VLOOKUP(+J9,LULC!$A$3:$D$16,4) |
| AJ9 | 206 | =VLOOKUP(K9,SoilTable,2) |
| AK9 | 0.11536666666666666 | =HLOOKUP($AI9,'Soil '!$AJ$2:$AN$210,$AJ9+1) |
| AL9 | 4.6146666666666665 | =HLOOKUP($AI9,'Soil '!$AO$2:$AS$210,$AJ9+1) |
| AM9 | 40 | =HLOOKUP($AI9,'Soil '!$AT$2:$AX$210,$AJ9+1) |
| AN9 | 40 | =MAX(0,AM9-dEXC+0.5*$AQ$5) |
| AO9 | 4.6146666666666665 | =+AN9*AK9 |
| AP9 | ||
| AQ9 | ||
| A10 | 5 | |
| B10 | 0.5 | |
| C10 | Gravel, dirt | |
| D10 | Keyport | |
| E10 | 7.5244 | =IF(B10=0,"-",+AC10*C_factor-'Annual Recharge'!AD10) |
| F10 | 13656.786 | =IF(B10=0,"-",43560B10E10/12) |
| G10 | ||
| H10 | 5 | |
| I10 | 0 | |
| J10 | brush | |
| K10 | Adelphia | |
| L10 | - | =IF(I10=0,"-",+AG10*C_factor-'Annual Recharge'!AH10) |
| M10 | - | =IF(I10=0,"-",43560I10L10/12) |
| N10 | ||
| O10 | ||
| P10 | ||
| Q10 | ||
| R10 | ||
| S10 | ||
| T10 | ||
| U10 | ||
| V10 | ||
| W10 | ||
| X10 | ||
| Y10 | ||
| Z10 | ||
| AA10 | 5 | |
| AB10 | 7 | =VLOOKUP(+C10,LULC!$A$3:$C$16,3) |
| AC10 | 6.48 | =+VLOOKUP(D10,SoilTable,3+'Annual Recharge'!AB10) |
| AD10 | 2.39 | =+VLOOKUP(D10,SoilTable,18+'Annual Recharge'!AB10) |
| AE10 | ||
| AF10 | 12 | =VLOOKUP(+J10,LULC!$A$3:$C$16,3) |
| AG10 | 22.56 | =+VLOOKUP(K10,SoilTable,3+'Annual Recharge'!AF10) |
| AH10 | 18.24 | =+VLOOKUP(K10,SoilTable,18+'Annual Recharge'!AF10) |
| AI10 | DEEP | =VLOOKUP(+J10,LULC!$A$3:$D$16,4) |
| AJ10 | 2 | =VLOOKUP(K10,SoilTable,2) |
| AK10 | 0.15206117021276594 | =HLOOKUP($AI10,'Soil '!$AJ$2:$AN$210,$AJ10+1) |
| AL10 | 6.082446808510638 | =HLOOKUP($AI10,'Soil '!$AO$2:$AS$210,$AJ10+1) |
| AM10 | 40 | =HLOOKUP($AI10,'Soil '!$AT$2:$AX$210,$AJ10+1) |
| AN10 | 40 | =MAX(0,AM10-dEXC+0.5*$AQ$5) |
| AO10 | 6.082446808510637 | =+AN10*AK10 |
| AP10 | ||
| AQ10 | ||
| A11 | 6 | |
| B11 | 3.3 | |
| C11 | Woods-grass combination | |
| D11 | Keyport | |
| E11 | 13.8545 | =IF(B11=0,"-",+AC11*C_factor-'Annual Recharge'!AD11) |
| F11 | 165963.0555 | =IF(B11=0,"-",43560B11E11/12) |
| G11 | ||
| H11 | 6 | |
| I11 | 0 | |
| J11 | Brush | |
| K11 | Adelphia | |
| L11 | - | =IF(I11=0,"-",+AG11*C_factor-'Annual Recharge'!AH11) |
| M11 | - | =IF(I11=0,"-",43560I11L11/12) |
| N11 | ||
| O11 | ||
| P11 | ||
| Q11 | ||
| R11 | ||
| S11 | ||
| T11 | ||
| U11 | ||
| V11 | ||
| W11 | ||
| X11 | ||
| Y11 | ||
| Z11 | ||
| AA11 | 6 | |
| AB11 | 9 | =VLOOKUP(+C11,LULC!$A$3:$C$16,3) |
| AC11 | 16.65 | =+VLOOKUP(D11,SoilTable,3+'Annual Recharge'!AB11) |
| AD11 | 11.62 | =+VLOOKUP(D11,SoilTable,18+'Annual Recharge'!AB11) |
| AE11 | ||
| AF11 | 12 | =VLOOKUP(+J11,LULC!$A$3:$C$16,3) |
| AG11 | 22.56 | =+VLOOKUP(K11,SoilTable,3+'Annual Recharge'!AF11) |
| AH11 | 18.24 | =+VLOOKUP(K11,SoilTable,18+'Annual Recharge'!AF11) |
| AI11 | DEEP | =VLOOKUP(+J11,LULC!$A$3:$D$16,4) |
| AJ11 | 2 | =VLOOKUP(K11,SoilTable,2) |
| AK11 | 0.15206117021276594 | =HLOOKUP($AI11,'Soil '!$AJ$2:$AN$210,$AJ11+1) |
| AL11 | 6.082446808510638 | =HLOOKUP($AI11,'Soil '!$AO$2:$AS$210,$AJ11+1) |
| AM11 | 40 | =HLOOKUP($AI11,'Soil '!$AT$2:$AX$210,$AJ11+1) |
| AN11 | 40 | =MAX(0,AM11-dEXC+0.5*$AQ$5) |
| AO11 | 6.082446808510637 | =+AN11*AK11 |
| AP11 | ||
| AQ11 | ||
| A12 | 7 | |
| B12 | 0 | |
| C12 | brush | |
| D12 | Adrian | |
| E12 | - | =IF(B12=0,"-",+AC12*C_factor-'Annual Recharge'!AD12) |
| F12 | - | =IF(B12=0,"-",43560B12E12/12) |
| G12 | ||
| H12 | 7 | |
| I12 | 0 | |
| J12 | Brush | |
| K12 | Adelphia | |
| L12 | - | =IF(I12=0,"-",+AG12*C_factor-'Annual Recharge'!AH12) |
| M12 | - | =IF(I12=0,"-",43560I12L12/12) |
| N12 | ||
| O12 | ||
| P12 | ||
| Q12 | ||
| R12 | ||
| S12 | ||
| T12 | ||
| U12 | ||
| V12 | ||
| W12 | ||
| X12 | ||
| Y12 | ||
| Z12 | ||
| AA12 | 7 | |
| AB12 | 12 | =VLOOKUP(+C12,LULC!$A$3:$C$16,3) |
| AC12 | 0 | =+VLOOKUP(D12,SoilTable,3+'Annual Recharge'!AB12) |
| AD12 | 0 | =+VLOOKUP(D12,SoilTable,18+'Annual Recharge'!AB12) |
| AE12 | ||
| AF12 | 12 | =VLOOKUP(+J12,LULC!$A$3:$C$16,3) |
| AG12 | 22.56 | =+VLOOKUP(K12,SoilTable,3+'Annual Recharge'!AF12) |
| AH12 | 18.24 | =+VLOOKUP(K12,SoilTable,18+'Annual Recharge'!AF12) |
| AI12 | DEEP | =VLOOKUP(+J12,LULC!$A$3:$D$16,4) |
| AJ12 | 2 | =VLOOKUP(K12,SoilTable,2) |
| AK12 | 0.15206117021276594 | =HLOOKUP($AI12,'Soil '!$AJ$2:$AN$210,$AJ12+1) |
| AL12 | 6.082446808510638 | =HLOOKUP($AI12,'Soil '!$AO$2:$AS$210,$AJ12+1) |
| AM12 | 40 | =HLOOKUP($AI12,'Soil '!$AT$2:$AX$210,$AJ12+1) |
| AN12 | 40 | =MAX(0,AM12-dEXC+0.5*$AQ$5) |
| AO12 | 6.082446808510637 | =+AN12*AK12 |
| AP12 | ||
| AQ12 | ||
| A13 | 8 | |
| B13 | 0 | |
| C13 | brush | |
| D13 | Adelphia | |
| E13 | - | =IF(B13=0,"-",+AC13*C_factor-'Annual Recharge'!AD13) |
| F13 | - | =IF(B13=0,"-",43560B13E13/12) |
| G13 | ||
| H13 | 8 | |
| I13 | 0 | |
| J13 | Brush | |
| K13 | Adelphia Variant | |
| L13 | - | =IF(I13=0,"-",+AG13*C_factor-'Annual Recharge'!AH13) |
| M13 | - | =IF(I13=0,"-",43560I13L13/12) |
| N13 | ||
| O13 | ||
| P13 | ||
| Q13 | ||
| R13 | ||
| S13 | ||
| T13 | ||
| U13 | ||
| V13 | ||
| W13 | ||
| X13 | ||
| Y13 | ||
| Z13 | ||
| AA13 | 8 | |
| AB13 | 12 | =VLOOKUP(+C13,LULC!$A$3:$C$16,3) |
| AC13 | 22.56 | =+VLOOKUP(D13,SoilTable,3+'Annual Recharge'!AB13) |
| AD13 | 18.24 | =+VLOOKUP(D13,SoilTable,18+'Annual Recharge'!AB13) |
| AE13 | ||
| AF13 | 12 | =VLOOKUP(+J13,LULC!$A$3:$C$16,3) |
| AG13 | 23.03 | =+VLOOKUP(K13,SoilTable,3+'Annual Recharge'!AF13) |
| AH13 | 18.97 | =+VLOOKUP(K13,SoilTable,18+'Annual Recharge'!AF13) |
| AI13 | DEEP | =VLOOKUP(+J13,LULC!$A$3:$D$16,4) |
| AJ13 | 3 | =VLOOKUP(K13,SoilTable,2) |
| AK13 | 0.15075 | =HLOOKUP($AI13,'Soil '!$AJ$2:$AN$210,$AJ13+1) |
| AL13 | 6.03 | =HLOOKUP($AI13,'Soil '!$AO$2:$AS$210,$AJ13+1) |
| AM13 | 40 | =HLOOKUP($AI13,'Soil '!$AT$2:$AX$210,$AJ13+1) |
| AN13 | 40 | =MAX(0,AM13-dEXC+0.5*$AQ$5) |
| AO13 | 6.029999999999999 | =+AN13*AK13 |
| AP13 | ||
| AQ13 | ||
| A14 | 9 | |
| B14 | 0 | |
| C14 | brush | |
| D14 | Adelphia | |
| E14 | - | =IF(B14=0,"-",+AC14*C_factor-'Annual Recharge'!AD14) |
| F14 | - | =IF(B14=0,"-",43560B14E14/12) |
| G14 | ||
| H14 | 9 | |
| I14 | 0 | |
| J14 | Brush | |
| K14 | Adelphia | |
| L14 | - | =IF(I14=0,"-",+AG14*C_factor-'Annual Recharge'!AH14) |
| M14 | - | =IF(I14=0,"-",43560I14L14/12) |
| N14 | ||
| O14 | ||
| P14 | ||
| Q14 | ||
| R14 | ||
| S14 | ||
| T14 | ||
| U14 | ||
| V14 | ||
| W14 | ||
| X14 | ||
| Y14 | ||
| Z14 | ||
| AA14 | 9 | |
| AB14 | 12 | =VLOOKUP(+C14,LULC!$A$3:$C$16,3) |
| AC14 | 22.56 | =+VLOOKUP(D14,SoilTable,3+'Annual Recharge'!AB14) |
| AD14 | 18.24 | =+VLOOKUP(D14,SoilTable,18+'Annual Recharge'!AB14) |
| AE14 | ||
| AF14 | 12 | =VLOOKUP(+J14,LULC!$A$3:$C$16,3) |
| AG14 | 22.56 | =+VLOOKUP(K14,SoilTable,3+'Annual Recharge'!AF14) |
| AH14 | 18.24 | =+VLOOKUP(K14,SoilTable,18+'Annual Recharge'!AF14) |
| AI14 | DEEP | =VLOOKUP(+J14,LULC!$A$3:$D$16,4) |
| AJ14 | 2 | =VLOOKUP(K14,SoilTable,2) |
| AK14 | 0.15206117021276594 | =HLOOKUP($AI14,'Soil '!$AJ$2:$AN$210,$AJ14+1) |
| AL14 | 6.082446808510638 | =HLOOKUP($AI14,'Soil '!$AO$2:$AS$210,$AJ14+1) |
| AM14 | 40 | =HLOOKUP($AI14,'Soil '!$AT$2:$AX$210,$AJ14+1) |
| AN14 | 40 | =MAX(0,AM14-dEXC+0.5*$AQ$5) |
| AO14 | 6.082446808510637 | =+AN14*AK14 |
| AP14 | ||
| AQ14 | ||
| A15 | 10 | |
| B15 | 0 | |
| C15 | brush | |
| D15 | Adelphia | |
| E15 | - | =IF(B15=0,"-",+AC15*C_factor-'Annual Recharge'!AD15) |
| F15 | - | =IF(B15=0,"-",43560B15E15/12) |
| G15 | ||
| H15 | 10 | |
| I15 | 0 | |
| J15 | Brush | |
| K15 | Abbottstown | |
| L15 | - | =IF(I15=0,"-",+AG15*C_factor-'Annual Recharge'!AH15) |
| M15 | - | =IF(I15=0,"-",43560I15L15/12) |
| N15 | ||
| O15 | ||
| P15 | ||
| Q15 | ||
| R15 | ||
| S15 | ||
| T15 | ||
| U15 | ||
| V15 | ||
| W15 | ||
| X15 | ||
| Y15 | ||
| Z15 | ||
| AA15 | 10 | |
| AB15 | 12 | =VLOOKUP(+C15,LULC!$A$3:$C$16,3) |
| AC15 | 22.56 | =+VLOOKUP(D15,SoilTable,3+'Annual Recharge'!AB15) |
| AD15 | 18.24 | =+VLOOKUP(D15,SoilTable,18+'Annual Recharge'!AB15) |
| AE15 | ||
| AF15 | 12 | =VLOOKUP(+J15,LULC!$A$3:$C$16,3) |
| AG15 | 17.75 | =+VLOOKUP(K15,SoilTable,3+'Annual Recharge'!AF15) |
| AH15 | 12.37 | =+VLOOKUP(K15,SoilTable,18+'Annual Recharge'!AF15) |
| AI15 | DEEP | =VLOOKUP(+J15,LULC!$A$3:$D$16,4) |
| AJ15 | 1 | =VLOOKUP(K15,SoilTable,2) |
| AK15 | 0.17886363636363636 | =HLOOKUP($AI15,'Soil '!$AJ$2:$AN$210,$AJ15+1) |
| AL15 | 3.935 | =HLOOKUP($AI15,'Soil '!$AO$2:$AS$210,$AJ15+1) |
| AM15 | 22 | =HLOOKUP($AI15,'Soil '!$AT$2:$AX$210,$AJ15+1) |
| AN15 | 22 | =MAX(0,AM15-dEXC+0.5*$AQ$5) |
| AO15 | 3.935 | =+AN15*AK15 |
| AP15 | ||
| AQ15 | ||
| A16 | 11 | |
| B16 | 0 | |
| C16 | Brush | |
| D16 | Abbottstown | |
| E16 | - | =IF(B16=0,"-",+AC16*C_factor-'Annual Recharge'!AD16) |
| F16 | - | =IF(B16=0,"-",43560B16E16/12) |
| G16 | ||
| H16 | 11 | |
| I16 | 0 | |
| J16 | Brush | |
| K16 | Abbottstown | |
| L16 | - | =IF(I16=0,"-",+AG16*C_factor-'Annual Recharge'!AH16) |
| M16 | - | =IF(I16=0,"-",43560I16L16/12) |
| N16 | ||
| O16 | ||
| P16 | ||
| Q16 | ||
| R16 | ||
| S16 | ||
| T16 | ||
| U16 | ||
| V16 | ||
| W16 | ||
| X16 | ||
| Y16 | ||
| Z16 | ||
| AA16 | 11 | |
| AB16 | 12 | =VLOOKUP(+C16,LULC!$A$3:$C$16,3) |
| AC16 | 17.75 | =+VLOOKUP(D16,SoilTable,3+'Annual Recharge'!AB16) |
| AD16 | 12.37 | =+VLOOKUP(D16,SoilTable,18+'Annual Recharge'!AB16) |
| AE16 | ||
| AF16 | 12 | =VLOOKUP(+J16,LULC!$A$3:$C$16,3) |
| AG16 | 17.75 | =+VLOOKUP(K16,SoilTable,3+'Annual Recharge'!AF16) |
| AH16 | 12.37 | =+VLOOKUP(K16,SoilTable,18+'Annual Recharge'!AF16) |
| AI16 | DEEP | =VLOOKUP(+J16,LULC!$A$3:$D$16,4) |
| AJ16 | 1 | =VLOOKUP(K16,SoilTable,2) |
| AK16 | 0.17886363636363636 | =HLOOKUP($AI16,'Soil '!$AJ$2:$AN$210,$AJ16+1) |
| AL16 | 3.935 | =HLOOKUP($AI16,'Soil '!$AO$2:$AS$210,$AJ16+1) |
| AM16 | 22 | =HLOOKUP($AI16,'Soil '!$AT$2:$AX$210,$AJ16+1) |
| AN16 | 22 | =MAX(0,AM16-dEXC+0.5*$AQ$5) |
| AO16 | 3.935 | =+AN16*AK16 |
| AP16 | ||
| AQ16 | ||
| A17 | 12 | |
| B17 | 0 | |
| C17 | Brush | |
| D17 | Abbottstown | |
| E17 | - | =IF(B17=0,"-",+AC17*C_factor-'Annual Recharge'!AD17) |
| F17 | - | =IF(B17=0,"-",43560B17E17/12) |
| G17 | ||
| H17 | 12 | |
| I17 | 0 | |
| J17 | Brush | |
| K17 | Abbottstown | |
| L17 | - | =IF(I17=0,"-",+AG17*C_factor-'Annual Recharge'!AH17) |
| M17 | - | =IF(I17=0,"-",43560I17L17/12) |
| N17 | ||
| O17 | ||
| P17 | ||
| Q17 | ||
| R17 | ||
| S17 | ||
| T17 | ||
| U17 | ||
| V17 | ||
| W17 | ||
| X17 | ||
| Y17 | ||
| Z17 | ||
| AA17 | 12 | |
| AB17 | 12 | =VLOOKUP(+C17,LULC!$A$3:$C$16,3) |
| AC17 | 17.75 | =+VLOOKUP(D17,SoilTable,3+'Annual Recharge'!AB17) |
| AD17 | 12.37 | =+VLOOKUP(D17,SoilTable,18+'Annual Recharge'!AB17) |
| AE17 | ||
| AF17 | 12 | =VLOOKUP(+J17,LULC!$A$3:$C$16,3) |
| AG17 | 17.75 | =+VLOOKUP(K17,SoilTable,3+'Annual Recharge'!AF17) |
| AH17 | 12.37 | =+VLOOKUP(K17,SoilTable,18+'Annual Recharge'!AF17) |
| AI17 | DEEP | =VLOOKUP(+J17,LULC!$A$3:$D$16,4) |
| AJ17 | 1 | =VLOOKUP(K17,SoilTable,2) |
| AK17 | 0.17886363636363636 | =HLOOKUP($AI17,'Soil '!$AJ$2:$AN$210,$AJ17+1) |
| AL17 | 3.935 | =HLOOKUP($AI17,'Soil '!$AO$2:$AS$210,$AJ17+1) |
| AM17 | 22 | =HLOOKUP($AI17,'Soil '!$AT$2:$AX$210,$AJ17+1) |
| AN17 | 22 | =MAX(0,AM17-dEXC+0.5*$AQ$5) |
| AO17 | 3.935 | =+AN17*AK17 |
| AP17 | ||
| AQ17 | ||
| A18 | 13 | |
| B18 | 0 | |
| C18 | Brush | |
| D18 | Abbottstown | |
| E18 | - | =IF(B18=0,"-",+AC18*C_factor-'Annual Recharge'!AD18) |
| F18 | - | =IF(B18=0,"-",43560B18E18/12) |
| G18 | ||
| H18 | 13 | |
| I18 | 0 | |
| J18 | Brush | |
| K18 | Abbottstown | |
| L18 | - | =IF(I18=0,"-",+AG18*C_factor-'Annual Recharge'!AH18) |
| M18 | - | =IF(I18=0,"-",43560I18L18/12) |
| N18 | ||
| O18 | ||
| P18 | ||
| Q18 | ||
| R18 | ||
| S18 | ||
| T18 | ||
| U18 | ||
| V18 | ||
| W18 | ||
| X18 | ||
| Y18 | ||
| Z18 | ||
| AA18 | 13 | |
| AB18 | 12 | =VLOOKUP(+C18,LULC!$A$3:$C$16,3) |
| AC18 | 17.75 | =+VLOOKUP(D18,SoilTable,3+'Annual Recharge'!AB18) |
| AD18 | 12.37 | =+VLOOKUP(D18,SoilTable,18+'Annual Recharge'!AB18) |
| AE18 | ||
| AF18 | 12 | =VLOOKUP(+J18,LULC!$A$3:$C$16,3) |
| AG18 | 17.75 | =+VLOOKUP(K18,SoilTable,3+'Annual Recharge'!AF18) |
| AH18 | 12.37 | =+VLOOKUP(K18,SoilTable,18+'Annual Recharge'!AF18) |
| AI18 | DEEP | =VLOOKUP(+J18,LULC!$A$3:$D$16,4) |
| AJ18 | 1 | =VLOOKUP(K18,SoilTable,2) |
| AK18 | 0.17886363636363636 | =HLOOKUP($AI18,'Soil '!$AJ$2:$AN$210,$AJ18+1) |
| AL18 | 3.935 | =HLOOKUP($AI18,'Soil '!$AO$2:$AS$210,$AJ18+1) |
| AM18 | 22 | =HLOOKUP($AI18,'Soil '!$AT$2:$AX$210,$AJ18+1) |
| AN18 | 22 | =MAX(0,AM18-dEXC+0.5*$AQ$5) |
| AO18 | 3.935 | =+AN18*AK18 |
| AP18 | ||
| AQ18 | ||
| A19 | 14 | |
| B19 | 0 | |
| C19 | Brush | |
| D19 | Abbottstown | |
| E19 | - | =IF(B19=0,"-",+AC19*C_factor-'Annual Recharge'!AD19) |
| F19 | - | =IF(B19=0,"-",43560B19E19/12) |
| G19 | ||
| H19 | 14 | |
| I19 | 0 | |
| J19 | Brush | |
| K19 | Abbottstown | |
| L19 | - | =IF(I19=0,"-",+AG19*C_factor-'Annual Recharge'!AH19) |
| M19 | - | =IF(I19=0,"-",43560I19L19/12) |
| N19 | ||
| O19 | ||
| P19 | ||
| Q19 | ||
| R19 | ||
| S19 | ||
| T19 | ||
| U19 | ||
| V19 | ||
| W19 | ||
| X19 | ||
| Y19 | ||
| Z19 | ||
| AA19 | 14 | |
| AB19 | 12 | =VLOOKUP(+C19,LULC!$A$3:$C$16,3) |
| AC19 | 17.75 | =+VLOOKUP(D19,SoilTable,3+'Annual Recharge'!AB19) |
| AD19 | 12.37 | =+VLOOKUP(D19,SoilTable,18+'Annual Recharge'!AB19) |
| AE19 | ||
| AF19 | 12 | =VLOOKUP(+J19,LULC!$A$3:$C$16,3) |
| AG19 | 17.75 | =+VLOOKUP(K19,SoilTable,3+'Annual Recharge'!AF19) |
| AH19 | 12.37 | =+VLOOKUP(K19,SoilTable,18+'Annual Recharge'!AF19) |
| AI19 | DEEP | =VLOOKUP(+J19,LULC!$A$3:$D$16,4) |
| AJ19 | 1 | =VLOOKUP(K19,SoilTable,2) |
| AK19 | 0.17886363636363636 | =HLOOKUP($AI19,'Soil '!$AJ$2:$AN$210,$AJ19+1) |
| AL19 | 3.935 | =HLOOKUP($AI19,'Soil '!$AO$2:$AS$210,$AJ19+1) |
| AM19 | 22 | =HLOOKUP($AI19,'Soil '!$AT$2:$AX$210,$AJ19+1) |
| AN19 | 22 | =MAX(0,AM19-dEXC+0.5*$AQ$5) |
| AO19 | 3.935 | =+AN19*AK19 |
| AP19 | ||
| AQ19 | ||
| A20 | 15 | |
| B20 | 0 | |
| C20 | Brush | |
| D20 | Abbottstown | |
| E20 | - | =IF(B20=0,"-",+AC20*C_factor-'Annual Recharge'!AD20) |
| F20 | - | =IF(B20=0,"-",43560B20E20/12) |
| G20 | ||
| H20 | 15 | |
| I20 | 0 | |
| J20 | Brush | |
| K20 | Abbottstown | |
| L20 | - | =IF(I20=0,"-",+AG20*C_factor-'Annual Recharge'!AH20) |
| M20 | - | =IF(I20=0,"-",43560I20L20/12) |
| N20 | ||
| O20 | ||
| P20 | ||
| Q20 | ||
| R20 | ||
| S20 | ||
| T20 | ||
| U20 | ||
| V20 | ||
| W20 | ||
| X20 | ||
| Y20 | ||
| Z20 | ||
| AA20 | 15 | |
| AB20 | 12 | =VLOOKUP(+C20,LULC!$A$3:$C$16,3) |
| AC20 | 17.75 | =+VLOOKUP(D20,SoilTable,3+'Annual Recharge'!AB20) |
| AD20 | 12.37 | =+VLOOKUP(D20,SoilTable,18+'Annual Recharge'!AB20) |
| AE20 | ||
| AF20 | 12 | =VLOOKUP(+J20,LULC!$A$3:$C$16,3) |
| AG20 | 17.75 | =+VLOOKUP(K20,SoilTable,3+'Annual Recharge'!AF20) |
| AH20 | 12.37 | =+VLOOKUP(K20,SoilTable,18+'Annual Recharge'!AF20) |
| AI20 | DEEP | =VLOOKUP(+J20,LULC!$A$3:$D$16,4) |
| AJ20 | 1 | =VLOOKUP(K20,SoilTable,2) |
| AK20 | 0.17886363636363636 | =HLOOKUP($AI20,'Soil '!$AJ$2:$AN$210,$AJ20+1) |
| AL20 | 3.935 | =HLOOKUP($AI20,'Soil '!$AO$2:$AS$210,$AJ20+1) |
| AM20 | 22 | =HLOOKUP($AI20,'Soil '!$AT$2:$AX$210,$AJ20+1) |
| AN20 | 22 | =MAX(0,AM20-dEXC+0.5*$AQ$5) |
| AO20 | 3.935 | =+AN20*AK20 |
| AP20 | ||
| AQ20 | ||
| A21 | Total = | |
| B21 | 10.399999999999999 | =SUM(B6:B20) |
| C21 | ||
| D21 | ||
| E21 | Total Annual Recharge (in) |
|
| F21 | Total Annual Recharge (cu-ft) |
|
| G21 | ||
| H21 | Total = | |
| I21 | 10.4 | =SUM(I6:I20) |
| J21 | =IF(I21=B21,"","Warning: make total area equal to Pre-Developed Conditions") |
|
| K21 | ||
| L21 | Total Annual Recharge (in) |
|
| M21 | Total Annual Recharge (cu.ft) |
|
| N21 | ||
| O21 | ||
| P21 | ||
| Q21 | ||
| R21 | ||
| S21 | ||
| T21 | ||
| U21 | ||
| V21 | ||
| W21 | ||
| X21 | ||
| Y21 | ||
| Z21 | ||
| AA21 | ||
| AB21 | ||
| AC21 | ||
| AD21 | ||
| AE21 | ||
| AF21 | ||
| AG21 | ||
| AH21 | ||
| AI21 | ||
| AJ21 | ||
| AK21 | ||
| AL21 | ||
| AM21 | ||
| AN21 | ||
| AO21 | ||
| AP21 | ||
| AQ21 | ||
| A22 | ||
| B22 | ||
| C22 | ||
| D22 | ||
| E22 | 13.033852884615388 | =SUMPRODUCT(B6:B20,E6:E20)/$B$21 |
| F22 | 492054.01410000003 | =SUM(F6:F20) |
| G22 | Annual Recharge Requirements Calculation ↓ | |
| H22 | ||
| I22 | ||
| J22 | ||
| K22 | ||
| L22 | 10.294011057692309 | =SUMPRODUCT(I6:I20,L6:L20)/$B$21 |
| M22 | 388619.50545000006 | =SUM(M6:M20) |
| N22 | ||
| O22 | ||
| P22 | ||
| Q22 | ||
| R22 | ||
| S22 | ||
| T22 | ||
| U22 | ||
| V22 | ||
| W22 | ||
| X22 | ||
| Y22 | ||
| Z22 | ||
| AA22 | ||
| AB22 | ||
| AC22 | ||
| AD22 | ||
| AE22 | ||
| AF22 | ||
| AG22 | ||
| AH22 | ||
| AI22 | ||
| AJ22 | ||
| AK22 | ||
| AL22 | ||
| AM22 | ||
| AN22 | ||
| AO22 | ||
| AP22 | ||
| AQ22 | ||
| A23 | Procedure to fill the Pre-Development and Post-Development Conditions Tables | |
| B23 | ||
| C23 | ||
| D23 | ||
| E23 | ||
| F23 | ||
| G23 | % of Pre-Developed Annual Recharge to Preserve = | |
| H23 | ||
| I23 | ||
| J23 | ||
| K23 | 1 | |
| L23 | Total Impervious Area (sq.ft) |
|
| M23 | 65340 | =SUMIF($J$6:$J$20,"Impervious areas",$I$6:$I$20)*43560 |
| N23 | ||
| O23 | ||
| P23 | ||
| Q23 | ||
| R23 | ||
| S23 | ||
| T23 | ||
| U23 | ||
| V23 | ||
| W23 | ||
| X23 | ||
| Y23 | ||
| Z23 | ||
| AA23 | ||
| AB23 | ||
| AC23 | ||
| AD23 | ||
| AE23 | ||
| AF23 | ||
| AG23 | ||
| AH23 | ||
| AI23 | ||
| AJ23 | ||
| AK23 | ||
| AL23 | ||
| AM23 | ||
| AN23 | ||
| AO23 | ||
| AP23 | ||
| AQ23 | ||
| A24 | For each land segment, first enter the area, then select TR-55 Land Cover, then select Soil. Start from the top of the table | |
| B24 | ||
| C24 | ||
| D24 | ||
| E24 | ||
| F24 | ||
| G24 | Post-Development Annual Recharge Deficit= | |
| H24 | ||
| I24 | ||
| J24 | ||
| K24 | 103434.50864999997 | =rechargepercent*F22-M22 |
| L24 | (cubic feet) | |
| M24 | ||
| N24 | ||
| O24 | ||
| P24 | ||
| Q24 | ||
| R24 | ||
| S24 | ||
| T24 | ||
| U24 | ||
| V24 | ||
| W24 | ||
| X24 | ||
| Y24 | ||
| Z24 | ||
| AA24 | ||
| AB24 | ||
| AC24 | ||
| AD24 | ||
| AE24 | ||
| AF24 | ||
| AG24 | ||
| AH24 | ||
| AI24 | ||
| AJ24 | ||
| AK24 | ||
| AL24 | ||
| AM24 | ||
| AN24 | ||
| AO24 | ||
| AP24 | ||
| AQ24 | ||
| A25 | and proceed downward. Don't leave blank rows (with A=0) in between your segment entries. Rows with A=0 will not be | |
| B25 | ||
| C25 | ||
| D25 | ||
| E25 | ||
| F25 | ||
| G25 | Recharge Efficiency Parameters Calculations (area averages) | |
| H25 | ||
| I25 | ||
| J25 | ||
| K25 | ||
| L25 | ||
| M25 | ||
| N25 | ||
| O25 | ||
| P25 | ||
| Q25 | ||
| R25 | ||
| S25 | ||
| T25 | ||
| U25 | ||
| V25 | ||
| W25 | ||
| X25 | ||
| Y25 | ||
| Z25 | ||
| AA25 | ||
| AB25 | ||
| AC25 | ||
| AD25 | ||
| AE25 | ||
| AF25 | ||
| AG25 | ||
| AH25 | ||
| AI25 | ||
| AJ25 | ||
| AK25 | ||
| AL25 | ||
| AM25 | ||
| AN25 | ||
| AO25 | ||
| AP25 | ||
| AQ25 | ||
| A26 | displayed or used in calculations. For impervious areas outside of standard lots select "Impervious Areas" as the Land Cover. | |
| B26 | ||
| C26 | ||
| D26 | ||
| E26 | ||
| F26 | ||
| G26 | RWC= | |
| H26 | 3.9422961538461543 | =+SUMPRODUCT(I6:I20,AL6:AL20)/SUM(I6:I20) |
| I26 | (in) | |
| J26 | DRWC= | |
| K26 | 3.9422961538461543 | =SUMPRODUCT(I6:I20,AO6:AO20)/SUM(I6:I20) |
| L26 | (in) | |
| M26 | ||
| N26 | ||
| O26 | ||
| P26 | ||
| Q26 | ||
| R26 | ||
| S26 | ||
| T26 | ||
| U26 | ||
| V26 | ||
| W26 | ||
| X26 | ||
| Y26 | ||
| Z26 | ||
| AA26 | ||
| AB26 | ||
| AC26 | ||
| AD26 | ||
| AE26 | ||
| AF26 | ||
| AG26 | ||
| AH26 | ||
| AI26 | ||
| AJ26 | ||
| AK26 | ||
| AL26 | ||
| AM26 | ||
| AN26 | ||
| AO26 | ||
| AP26 | ||
| AQ26 | ||
| A27 | Soil type for impervious areas are only required if an infiltration facility will be built within these areas. | |
| B27 | ||
| C27 | ||
| D27 | ||
| E27 | ||
| F27 | ||
| G27 | ERWC = | |
| H27 | 0.9264395961538462 | =(1-0.5C_factor)RWC |
| I27 | (in) | |
| J27 | EDRWC= | |
| K27 | 0.9264395961538462 | =(1-0.5C_factor)DRWC |
| L27 | (in) | |
| M27 | ||
| N27 | ||
| O27 | ||
| P27 | ||
| Q27 | ||
| R27 | ||
| S27 | ||
| T27 | ||
| U27 | ||
| V27 | ||
| W27 | ||
| X27 | ||
| Y27 | ||
| Z27 | ||
| AA27 | ||
| AB27 | ||
| AC27 | ||
| AD27 | ||
| AE27 | ||
| AF27 | ||
| AG27 | ||
| AH27 | ||
| AI27 | ||
| AJ27 | ||
| AK27 | ||
| AL27 | ||
| AM27 | ||
| AN27 | ||
| AO27 | ||
| AP27 | ||
| AQ27 | ||
| A28 | ||
| B28 | ||
| C28 | ||
| D28 | ||
| E28 | ||
| F28 | ||
| G28 | ||
| H28 | ||
| I28 | ||
| J28 | ||
| K28 | ||
| L28 | ||
| M28 | ||
| N28 | ||
| O28 | ||
| P28 | ||
| Q28 | ||
| R28 | ||
| S28 | ||
| T28 | ||
| U28 | ||
| V28 | ||
| W28 | ||
| X28 | ||
| Y28 | ||
| Z28 | ||
| AA28 | ||
| AB28 | ||
| AC28 | ||
| AD28 | ||
| AE28 | ||
| AF28 | ||
| AG28 | ||
| AH28 | ||
| AI28 | ||
| AJ28 | ||
| AK28 | ||
| AL28 | ||
| AM28 | ||
| AN28 | ||
| AO28 | ||
| AP28 | ||
| AQ28 | ||
| A29 | ||
| B29 | ||
| C29 | ||
| D29 | ||
| E29 | ||
| F29 | ||
| G29 | ||
| H29 | ||
| I29 | ||
| J29 | ||
| K29 | ||
| L29 | ||
| M29 | ||
| N29 | ||
| O29 | ||
| P29 | ||
| Q29 | ||
| R29 | ||
| S29 | ||
| T29 | ||
| U29 | ||
| V29 | ||
| W29 | ||
| X29 | ||
| Y29 | ||
| Z29 | ||
| AA29 | ||
| AB29 | ||
| AC29 | ||
| AD29 | ||
| AE29 | ||
| AF29 | ||
| AG29 | ||
| AH29 | ||
| AI29 | ||
| AJ29 | ||
| AK29 | ||
| AL29 | ||
| AM29 | ||
| AN29 | ||
| AO29 | ||
| AP29 | ||
| AQ29 | ||
| A30 | ||
| B30 | ||
| C30 | ||
| D30 | ||
| E30 | ||
| F30 | 326091 | =492054-165963 |
| G30 | ||
| H30 | ||
| I30 | ||
| J30 | ||
| K30 | ||
| L30 | ||
| M30 | ||
| N30 | ||
| O30 | ||
| P30 | ||
| Q30 | ||
| R30 | ||
| S30 | ||
| T30 | ||
| U30 | ||
| V30 | ||
| W30 | ||
| X30 | ||
| Y30 | ||
| Z30 | ||
| AA30 | ||
| AB30 | ||
| AC30 | ||
| AD30 | ||
| AE30 | ||
| AF30 | ||
| AG30 | ||
| AH30 | ||
| AI30 | ||
| AJ30 | ||
| AK30 | ||
| AL30 | ||
| AM30 | ||
| AN30 | ||
| AO30 | ||
| AP30 | ||
| AQ30 | ||
| A31 | ||
| B31 | ||
| C31 | ||
| D31 | ||
| E31 | ||
| F31 | ||
| G31 | ||
| H31 | ||
| I31 | ||
| J31 | ||
| K31 | ||
| L31 | ||
| M31 | ||
| N31 | ||
| O31 | ||
| P31 | ||
| Q31 | ||
| R31 | ||
| S31 | ||
| T31 | ||
| U31 | ||
| V31 | ||
| W31 | ||
| X31 | ||
| Y31 | ||
| Z31 | ||
| AA31 | ||
| AB31 | ||
| AC31 | ||
| AD31 | ||
| AE31 | ||
| AF31 | ||
| AG31 | ||
| AH31 | ||
| AI31 | ||
| AJ31 | ||
| AK31 | ||
| AL31 | ||
| AM31 | ||
| AN31 | ||
| AO31 | ||
| AP31 | ||
| AQ31 | ||
| A32 | ||
| B32 | ||
| C32 | ||
| D32 | ||
| E32 | ||
| F32 | ||
| G32 | ||
| H32 | ||
| I32 | ||
| J32 | ||
| K32 | ||
| L32 | ||
| M32 | ||
| N32 | ||
| O32 | ||
| P32 | ||
| Q32 | ||
| R32 | ||
| S32 | ||
| T32 | ||
| U32 | ||
| V32 | ||
| W32 | ||
| X32 | ||
| Y32 | ||
| Z32 | ||
| AA32 | ||
| AB32 | ||
| AC32 | ||
| AD32 | ||
| AE32 | ||
| AF32 | ||
| AG32 | ||
| AH32 | ||
| AI32 | ||
| AJ32 | ||
| AK32 | ||
| AL32 | ||
| AM32 | ||
| AN32 | ||
| AO32 | ||
| AP32 | ||
| AQ32 | ||
| A33 | ||
| B33 | ||
| C33 | ||
| D33 | ||
| E33 | ||
| F33 | ||
| G33 | ||
| H33 | ||
| I33 | ||
| J33 | ||
| K33 | ||
| L33 | ||
| M33 | ||
| N33 | ||
| O33 | ||
| P33 | ||
| Q33 | ||
| R33 | ||
| S33 | ||
| T33 | ||
| U33 | ||
| V33 | ||
| W33 | ||
| X33 | ||
| Y33 | ||
| Z33 | ||
| AA33 | ||
| AB33 | ||
| AC33 | ||
| AD33 | ||
| AE33 | ||
| AF33 | ||
| AG33 | ||
| AH33 | ||
| AI33 | ||
| AJ33 | ||
| AK33 | ||
| AL33 | ||
| AM33 | ||
| AN33 | ||
| AO33 | ||
| AP33 | ||
| AQ33 | ||
| A34 | ||
| B34 | ||
| C34 | ||
| D34 | ||
| E34 | ||
| F34 | ||
| G34 | ||
| H34 | ||
| I34 | ||
| J34 | ||
| K34 | ||
| L34 | ||
| M34 | ||
| N34 | ||
| O34 | ||
| P34 | ||
| Q34 | ||
| R34 | ||
| S34 | ||
| T34 | ||
| U34 | ||
| V34 | ||
| W34 | ||
| X34 | ||
| Y34 | ||
| Z34 | ||
| AA34 | ||
| AB34 | ||
| AC34 | ||
| AD34 | ||
| AE34 | ||
| AF34 | ||
| AG34 | ||
| AH34 | ||
| AI34 | ||
| AJ34 | ||
| AK34 | ||
| AL34 | ||
| AM34 | ||
| AN34 | ||
| AO34 | ||
| AP34 | ||
| AQ34 | ||
| A35 | ||
| B35 | ||
| C35 | ||
| D35 | ||
| E35 | ||
| F35 | ||
| G35 | ||
| H35 | ||
| I35 | ||
| J35 | ||
| K35 | ||
| L35 | ||
| M35 | ||
| N35 | ||
| O35 | ||
| P35 | ||
| Q35 | ||
| R35 | ||
| S35 | ||
| T35 | ||
| U35 | ||
| V35 | ||
| W35 | ||
| X35 | ||
| Y35 | ||
| Z35 | ||
| AA35 | ||
| AB35 | ||
| AC35 | ||
| AD35 | ||
| AE35 | ||
| AF35 | ||
| AG35 | ||
| AH35 | ||
| AI35 | ||
| AJ35 | ||
| AK35 | ||
| AL35 | ||
| AM35 | ||
| AN35 | ||
| AO35 | ||
| AP35 | ||
| AQ35 | ||
| A36 | ||
| B36 | ||
| C36 | ||
| D36 | ||
| E36 | ||
| F36 | ||
| G36 | ||
| H36 | ||
| I36 | ||
| J36 | ||
| K36 | ||
| L36 | ||
| M36 | ||
| N36 | ||
| O36 | ||
| P36 | ||
| Q36 | ||
| R36 | ||
| S36 | ||
| T36 | ||
| U36 | ||
| V36 | ||
| W36 | ||
| X36 | ||
| Y36 | ||
| Z36 | ||
| AA36 | ||
| AB36 | ||
| AC36 | ||
| AD36 | ||
| AE36 | ||
| AF36 | ||
| AG36 | ||
| AH36 | ||
| AI36 | ||
| AJ36 | ||
| AK36 | ||
| AL36 | ||
| AM36 | ||
| AN36 | ||
| AO36 | ||
| AP36 | ||
| AQ36 | ||
| A37 | ||
| B37 | ||
| C37 | ||
| D37 | ||
| E37 | ||
| F37 | ||
| G37 | ||
| H37 | ||
| I37 | ||
| J37 | ||
| K37 | ||
| L37 | ||
| M37 | ||
| N37 | ||
| O37 | ||
| P37 | ||
| Q37 | ||
| R37 | ||
| S37 | ||
| T37 | ||
| U37 | ||
| V37 | ||
| W37 | ||
| X37 | ||
| Y37 | ||
| Z37 | ||
| AA37 | ||
| AB37 | ||
| AC37 | ||
| AD37 | ||
| AE37 | ||
| AF37 | ||
| AG37 | ||
| AH37 | ||
| AI37 | ||
| AJ37 | ||
| AK37 | ||
| AL37 | ||
| AM37 | ||
| AN37 | ||
| AO37 | ||
| AP37 | ||
| AQ37 |