event calc table¶
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 | ||
| D1 | ||
| E1 | ||
| F1 | ||
| G1 | ||
| H1 | ||
| I1 | ||
| J1 | ||
| K1 | ||
| L1 | ||
| M1 | ||
| N1 | ||
| O1 | ||
| P1 | ||
| Q1 | P_Q calcs for Buffers | |
| R1 | ||
| S1 | ||
| A2 | No | |
| B2 | Pi as a % of Avg. Annual P |
|
| C2 | Pi Precip. Causing Runoff |
|
| D2 | Qi Runoff |
|
| E2 | infiltration in BMP | |
| F2 | Empty RWC under BMP |
|
| G2 | recharge in BMP | |
| H2 | Event Recharge Averaged over imp Area |
|
| I2 | cumulative recharge over imper Area |
|
| J2 | ||
| K2 | ||
| L2 | ||
| M2 | required rech depth over imp Area |
|
| N2 | Pdesign | |
| O2 | Yaxis | |
| P2 | ||
| Q2 | P | |
| R2 | Q | |
| S2 | ||
| A3 | 1 | |
| B3 | 0.19504512017606182 | |
| C3 | 0.09323156744415755 | =+Pavg*B3/100 |
| D3 | 0.044828990164754695 | =+IF(C3<0.0408,0,IF(C3<1.25,0.855(C3-0.0408),(C3-0.20.204)^2/(C3+0.8*0.204))) |
| E3 | 0.44007304948393505 | =+MIN(D3/Aratio,dBMP) |
| F3 | 0.48636654666991114 | =+MAX('BMP Calculations'!$G$6-E3,0) |
| G3 | 0 | =+MAX(E3-RERWC,0) |
| H3 | 0 | =+G3*Aratio |
| I3 | 0 | =SUM($H$3:H3) |
| J3 | ||
| K3 | ||
| L3 | ||
| M3 | 18.99623666666666 | =+dr |
| N3 | 0.672028306791204 | =+Pdesign |
| O3 | 0 | |
| P3 | ||
| Q3 | 0.09323156744415755 | ='event calc table'!C3 |
| R3 | #REF! | =+IF(Q3<=0.2#REF!$C$29,0,(Q3-0.2#REF!$C$29)^2/(Q3+0.8*#REF!$C$29)) |
| S3 | ||
| A4 | 2 | |
| B4 | 0.20352907070777088 | |
| C4 | 0.09728689579831448 | =+Pavg*B4/100 |
| D4 | 0.04829629590755888 | =+IF(C4<0.0408,0,IF(C4<1.25,0.855(C4-0.0408),(C4-0.20.204)^2/(C4+0.8*0.204))) |
| E4 | 0.4741105731069557 | =+MIN(D4/Aratio,dBMP) |
| F4 | 0.4523290230468905 | =+MAX('BMP Calculations'!$G$6-E4,0) |
| G4 | 0 | =+MAX(E4-RERWC,0) |
| H4 | 0 | =+G4*Aratio |
| I4 | 0 | =SUM($H$3:H4) |
| J4 | ||
| K4 | ||
| L4 | ||
| M4 | ||
| N4 | 0.672028306791204 | =+Pdesign |
| O4 | 8.584189116135457 | =+VLOOKUP(Pdesign,C3:I80,7) |
| P4 | ||
| Q4 | 0.09728689579831448 | ='event calc table'!C4 |
| R4 | #REF! | =+IF(Q4<=0.2#REF!$C$29,0,(Q4-0.2#REF!$C$29)^2/(Q4+0.8*#REF!$C$29)) |
| S4 | ||
| A5 | 3 | |
| B5 | 0.2125635754761121 | |
| C5 | 0.10160538907758157 | =+Pavg*B5/100 |
| D5 | 0.05198860766133224 | =+IF(C5<0.0408,0,IF(C5<1.25,0.855(C5-0.0408),(C5-0.20.204)^2/(C5+0.8*0.204))) |
| E5 | 0.5103569147523209 | =+MIN(D5/Aratio,dBMP) |
| F5 | 0.41608268140152527 | =+MAX('BMP Calculations'!$G$6-E5,0) |
| G5 | 0 | =+MAX(E5-RERWC,0) |
| H5 | 0 | =+G5*Aratio |
| I5 | 0 | =SUM($H$3:H5) |
| J5 | ||
| K5 | ||
| L5 | ||
| M5 | ||
| N5 | ||
| O5 | ||
| P5 | ||
| Q5 | 0.10160538907758157 | ='event calc table'!C5 |
| R5 | #REF! | =+IF(Q5<=0.2#REF!$C$29,0,(Q5-0.2#REF!$C$29)^2/(Q5+0.8*#REF!$C$29)) |
| S5 | ||
| A6 | 4 | |
| B6 | 0.22169284777698828 | |
| C6 | 0.10596918123740039 | =+Pavg*B6/100 |
| D6 | 0.055719649957977326 | =+IF(C6<0.0408,0,IF(C6<1.25,0.855(C6-0.0408),(C6-0.20.204)^2/(C6+0.8*0.204))) |
| E6 | 0.5469834627785815 | =+MIN(D6/Aratio,dBMP) |
| F6 | 0.37945613337526474 | =+MAX('BMP Calculations'!$G$6-E6,0) |
| G6 | 0 | =+MAX(E6-RERWC,0) |
| H6 | 0 | =+G6*Aratio |
| I6 | 0 | =SUM($H$3:H6) |
| J6 | ||
| K6 | ||
| L6 | ||
| M6 | ||
| N6 | ||
| O6 | ||
| P6 | ||
| Q6 | 0.10596918123740039 | ='event calc table'!C6 |
| R6 | #REF! | =+IF(Q6<=0.2#REF!$C$29,0,(Q6-0.2#REF!$C$29)^2/(Q6+0.8*#REF!$C$29)) |
| S6 | ||
| A7 | 5 | |
| B7 | 0.230722839805685 | |
| C7 | 0.11028551742711742 | =+Pavg*B7/100 |
| D7 | 0.0594101174001854 | =+IF(C7<0.0408,0,IF(C7<1.25,0.855(C7-0.0408),(C7-0.20.204)^2/(C7+0.8*0.204))) |
| E7 | 0.5832116993581902 | =+MIN(D7/Aratio,dBMP) |
| F7 | 0.343227896795656 | =+MAX('BMP Calculations'!$G$6-E7,0) |
| G7 | 0 | =+MAX(E7-RERWC,0) |
| H7 | 0 | =+G7*Aratio |
| I7 | 0 | =SUM($H$3:H7) |
| J7 | ||
| K7 | ||
| L7 | ||
| M7 | ||
| N7 | ||
| O7 | ||
| P7 | ||
| Q7 | 0.11028551742711742 | ='event calc table'!C7 |
| R7 | #REF! | =+IF(Q7<=0.2#REF!$C$29,0,(Q7-0.2#REF!$C$29)^2/(Q7+0.8*#REF!$C$29)) |
| S7 | ||
| A8 | 6 | |
| B8 | 0.24016349114203353 | |
| C8 | 0.11479814876589202 | =+Pavg*B8/100 |
| D8 | 0.06326841719483767 | =+IF(C8<0.0408,0,IF(C8<1.25,0.855(C8-0.0408),(C8-0.20.204)^2/(C8+0.8*0.204))) |
| E8 | 0.6210874969216786 | =+MIN(D8/Aratio,dBMP) |
| F8 | 0.30535209923216755 | =+MAX('BMP Calculations'!$G$6-E8,0) |
| G8 | 0 | =+MAX(E8-RERWC,0) |
| H8 | 0 | =+G8*Aratio |
| I8 | 0 | =SUM($H$3:H8) |
| J8 | ||
| K8 | ||
| L8 | ||
| M8 | ||
| N8 | ||
| O8 | ||
| P8 | ||
| Q8 | 0.11479814876589202 | ='event calc table'!C8 |
| R8 | #REF! | =+IF(Q8<=0.2#REF!$C$29,0,(Q8-0.2#REF!$C$29)^2/(Q8+0.8*#REF!$C$29)) |
| S8 | ||
| A9 | 7 | |
| B9 | 0.2501095693185691 | |
| C9 | 0.11955237413427602 | =+Pavg*B9/100 |
| D9 | 0.067333279884806 | =+IF(C9<0.0408,0,IF(C9<1.25,0.855(C9-0.0408),(C9-0.20.204)^2/(C9+0.8*0.204))) |
| E9 | 0.6609910618499435 | =+MIN(D9/Aratio,dBMP) |
| F9 | 0.2654485343039027 | =+MAX('BMP Calculations'!$G$6-E9,0) |
| G9 | 0 | =+MAX(E9-RERWC,0) |
| H9 | 0 | =+G9*Aratio |
| I9 | 0 | =SUM($H$3:H9) |
| J9 | ||
| K9 | ||
| L9 | ||
| M9 | ||
| N9 | ||
| O9 | ||
| P9 | ||
| Q9 | 0.11955237413427602 | ='event calc table'!C9 |
| R9 | #REF! | =+IF(Q9<=0.2#REF!$C$29,0,(Q9-0.2#REF!$C$29)^2/(Q9+0.8*#REF!$C$29)) |
| S9 | ||
| A10 | 8 | |
| B10 | 0.2607099947435608 | |
| C10 | 0.12461937748742206 | =+Pavg*B10/100 |
| D10 | 0.07166556775174586 | =+IF(C10<0.0408,0,IF(C10<1.25,0.855(C10-0.0408),(C10-0.20.204)^2/(C10+0.8*0.204))) |
| E10 | 0.7035198613129618 | =+MIN(D10/Aratio,dBMP) |
| F10 | 0.22291973484088434 | =+MAX('BMP Calculations'!$G$6-E10,0) |
| G10 | 0 | =+MAX(E10-RERWC,0) |
| H10 | 0 | =+G10*Aratio |
| I10 | 0 | =SUM($H$3:H10) |
| J10 | ||
| K10 | Precip | |
| L10 | 100 | |
| M10 | 47.8 | =+Pavg |
| N10 | 100 | =100*M10/$M$10 |
| O10 | ||
| P10 | ||
| Q10 | 0.12461937748742206 | ='event calc table'!C10 |
| R10 | #REF! | =+IF(Q10<=0.2#REF!$C$29,0,(Q10-0.2#REF!$C$29)^2/(Q10+0.8*#REF!$C$29)) |
| S10 | ||
| A11 | 9 | |
| B11 | 0.2713735985235761 | |
| C11 | 0.12971658009426937 | =+Pavg*B11/100 |
| D11 | 0.07602367598060031 | =+IF(C11<0.0408,0,IF(C11<1.25,0.855(C11-0.0408),(C11-0.20.204)^2/(C11+0.8*0.204))) |
| E11 | 0.7463021316965781 | =+MIN(D11/Aratio,dBMP) |
| F11 | 0.18013746445726808 | =+MAX('BMP Calculations'!$G$6-E11,0) |
| G11 | 0.011299698150342818 | =+MAX(E11-RERWC,0) |
| H11 | 0.0011510681188962627 | =+G11*Aratio |
| I11 | 0.0011510681188962627 | =SUM($H$3:H11) |
| J11 | ||
| K11 | Runoff | |
| L11 | 78.28979082660678 | =+'BMP Calculations'!G16*100 |
| M11 | 37.42252001511804 | =+'event calc table'!D84 |
| N11 | 78.28979082660678 | =100*M11/$M$10 |
| O11 | ||
| P11 | ||
| Q11 | 0.12971658009426937 | ='event calc table'!C11 |
| R11 | #REF! | =+IF(Q11<=0.2#REF!$C$29,0,(Q11-0.2#REF!$C$29)^2/(Q11+0.8*#REF!$C$29)) |
| S11 | ||
| A12 | 10 | |
| B12 | 0.2825381164041335 | |
| C12 | 0.1350532196411758 | =+Pavg*B12/100 |
| D12 | 0.08058650279320531 | =+IF(C12<0.0408,0,IF(C12<1.25,0.855(C12-0.0408),(C12-0.20.204)^2/(C12+0.8*0.204))) |
| E12 | 0.791094064379212 | =+MIN(D12/Aratio,dBMP) |
| F12 | 0.13534553177463415 | =+MAX('BMP Calculations'!$G$6-E12,0) |
| G12 | 0.05609163083297675 | =+MAX(E12-RERWC,0) |
| H12 | 0.005713894931501273 | =+G12*Aratio |
| I12 | 0.006864963050397536 | =SUM($H$3:H12) |
| J12 | ||
| K12 | Infiltration | |
| L12 | 51.8299220727423 | =+L11*'BMP Calculations'!G17 |
| M12 | 24.77470275077082 | =+'event calc table'!E84*Aratio |
| N12 | 51.829922072742306 | =100*M12/$M$10 |
| O12 | ||
| P12 | ||
| Q12 | 0.1350532196411758 | ='event calc table'!C12 |
| R12 | #REF! | =+IF(Q12<=0.2#REF!$C$29,0,(Q12-0.2#REF!$C$29)^2/(Q12+0.8*#REF!$C$29)) |
| S12 | ||
| A13 | 11 | |
| B13 | 0.2944788255035495 | |
| C13 | 0.14076087859069664 | =+Pavg*B13/100 |
| D13 | 0.08546655119504562 | =+IF(C13<0.0408,0,IF(C13<1.25,0.855(C13-0.0408),(C13-0.20.204)^2/(C13+0.8*0.204))) |
| E13 | 0.8390000683720373 | =+MIN(D13/Aratio,dBMP) |
| F13 | 0.08743952778180886 | =+MAX('BMP Calculations'!$G$6-E13,0) |
| G13 | 0.10399763482580204 | =+MAX(E13-RERWC,0) |
| H13 | 0.010593943333341573 | =+G13*Aratio |
| I13 | 0.01745890638373911 | =SUM($H$3:H13) |
| J13 | ||
| K13 | Recharge | |
| L13 | 39.741080892608096 | =+L12*'BMP Calculations'!G15 |
| M13 | 18.996236666666668 | =+'event calc table'!H84 |
| N13 | 39.741080892608096 | =100*M13/$M$10 |
| O13 | ||
| P13 | ||
| Q13 | 0.14076087859069664 | ='event calc table'!C13 |
| R13 | #REF! | =+IF(Q13<=0.2#REF!$C$29,0,(Q13-0.2#REF!$C$29)^2/(Q13+0.8*#REF!$C$29)) |
| S13 | ||
| A14 | 12 | |
| B14 | 0.3062886651532744 | |
| C14 | 0.14640598194326515 | =+Pavg*B14/100 |
| D14 | 0.0902931145614917 | =+IF(C14<0.0408,0,IF(C14<1.25,0.855(C14-0.0408),(C14-0.20.204)^2/(C14+0.8*0.204))) |
| E14 | 0.8863810254579128 | =+MIN(D14/Aratio,dBMP) |
| F14 | 0.04005857069593344 | =+MAX('BMP Calculations'!$G$6-E14,0) |
| G14 | 0.15137859191167746 | =+MAX(E14-RERWC,0) |
| H14 | 0.015420506699787652 | =+G14*Aratio |
| I14 | 0.032879413083526765 | =SUM($H$3:H14) |
| J14 | ||
| K14 | ||
| L14 | ||
| M14 | ||
| N14 | ||
| O14 | ||
| P14 | ||
| Q14 | 0.14640598194326515 | ='event calc table'!C14 |
| R14 | #REF! | =+IF(Q14<=0.2#REF!$C$29,0,(Q14-0.2#REF!$C$29)^2/(Q14+0.8*#REF!$C$29)) |
| S14 | ||
| A15 | 13 | |
| B15 | 0.3182203487734014 | |
| C15 | 0.15210932671368585 | =+Pavg*B15/100 |
| D15 | 0.0951694743402014 | =+IF(C15<0.0408,0,IF(C15<1.25,0.855(C15-0.0408),(C15-0.20.204)^2/(C15+0.8*0.204))) |
| E15 | 0.9342508193192246 | =+MIN(D15/Aratio,dBMP) |
| F15 | 0 | =+MAX('BMP Calculations'!$G$6-E15,0) |
| G15 | 0.1992483857729893 | =+MAX(E15-RERWC,0) |
| H15 | 0.02029686647849735 | =+G15*Aratio |
| I15 | 0.053176279562024115 | =SUM($H$3:H15) |
| J15 | ||
| K15 | ||
| L15 | ||
| M15 | ||
| N15 | ||
| O15 | ||
| P15 | ||
| Q15 | 0.15210932671368585 | ='event calc table'!C15 |
| R15 | #REF! | =+IF(Q15<=0.2#REF!$C$29,0,(Q15-0.2#REF!$C$29)^2/(Q15+0.8*#REF!$C$29)) |
| S15 | ||
| A16 | 14 | |
| B16 | 0.3306980738905158 | |
| C16 | 0.15807367931966654 | =+Pavg*B16/100 |
| D16 | 0.10026899581831489 | =+IF(C16<0.0408,0,IF(C16<1.25,0.855(C16-0.0408),(C16-0.20.204)^2/(C16+0.8*0.204))) |
| E16 | 0.9843113261371236 | =+MIN(D16/Aratio,dBMP) |
| F16 | 0 | =+MAX('BMP Calculations'!$G$6-E16,0) |
| G16 | 0.2493088925908883 | =+MAX(E16-RERWC,0) |
| H16 | 0.025396387956610842 | =+G16*Aratio |
| I16 | 0.07857266751863495 | =SUM($H$3:H16) |
| J16 | ||
| K16 | ||
| L16 | ||
| M16 | ||
| N16 | ||
| O16 | ||
| P16 | ||
| Q16 | 0.15807367931966654 | ='event calc table'!C16 |
| R16 | #REF! | =+IF(Q16<=0.2#REF!$C$29,0,(Q16-0.2#REF!$C$29)^2/(Q16+0.8*#REF!$C$29)) |
| S16 | ||
| A17 | 15 | |
| B17 | 0.34337435955198975 | |
| C17 | 0.1641329438658511 | =+Pavg*B17/100 |
| D17 | 0.10544966700530267 | =+IF(C17<0.0408,0,IF(C17<1.25,0.855(C17-0.0408),(C17-0.20.204)^2/(C17+0.8*0.204))) |
| E17 | 1.0351684558483287 | =+MIN(D17/Aratio,dBMP) |
| F17 | 0 | =+MAX('BMP Calculations'!$G$6-E17,0) |
| G17 | 0.30016602230209344 | =+MAX(E17-RERWC,0) |
| H17 | 0.030577059143598623 | =+G17*Aratio |
| I17 | 0.10914972666223358 | =SUM($H$3:H17) |
| J17 | ||
| K17 | ||
| L17 | ||
| M17 | ||
| N17 | ||
| O17 | ||
| P17 | ||
| Q17 | 0.1641329438658511 | ='event calc table'!C17 |
| R17 | #REF! | =+IF(Q17<=0.2#REF!$C$29,0,(Q17-0.2#REF!$C$29)^2/(Q17+0.8*#REF!$C$29)) |
| S17 | ||
| A18 | 16 | |
| B18 | 0.35628530767497907 | |
| C18 | 0.17030437706864 | =+Pavg*B18/100 |
| D18 | 0.11072624239368718 | =+IF(C18<0.0408,0,IF(C18<1.25,0.855(C18-0.0408),(C18-0.20.204)^2/(C18+0.8*0.204))) |
| E18 | 1.0869670489788943 | =+MIN(D18/Aratio,dBMP) |
| F18 | 0 | =+MAX('BMP Calculations'!$G$6-E18,0) |
| G18 | 0.351964615432659 | =+MAX(E18-RERWC,0) |
| H18 | 0.03585363453198314 | =+G18*Aratio |
| I18 | 0.14500336119421672 | =SUM($H$3:H18) |
| J18 | ||
| K18 | ||
| L18 | ||
| M18 | ||
| N18 | ||
| O18 | ||
| P18 | ||
| Q18 | 0.17030437706864 | ='event calc table'!C18 |
| R18 | #REF! | =+IF(Q18<=0.2#REF!$C$29,0,(Q18-0.2#REF!$C$29)^2/(Q18+0.8*#REF!$C$29)) |
| S18 | ||
| A19 | 17 | |
| B19 | 0.36989573044286944 | |
| C19 | 0.1768101591516916 | =+Pavg*B19/100 |
| D19 | 0.1162886860746963 | =+IF(C19<0.0408,0,IF(C19<1.25,0.855(C19-0.0408),(C19-0.20.204)^2/(C19+0.8*0.204))) |
| E19 | 1.1415719273017813 | =+MIN(D19/Aratio,dBMP) |
| F19 | 0 | =+MAX('BMP Calculations'!$G$6-E19,0) |
| G19 | 0.40656949375554596 | =+MAX(E19-RERWC,0) |
| H19 | 0.04141607821299226 | =+G19*Aratio |
| I19 | 0.18641943940720898 | =SUM($H$3:H19) |
| J19 | ||
| K19 | ||
| L19 | ||
| M19 | ||
| N19 | ||
| O19 | ||
| P19 | ||
| Q19 | 0.1768101591516916 | ='event calc table'!C19 |
| R19 | #REF! | =+IF(Q19<=0.2#REF!$C$29,0,(Q19-0.2#REF!$C$29)^2/(Q19+0.8*#REF!$C$29)) |
| S19 | ||
| A20 | 18 | |
| B20 | 0.38455310880829013 | |
| C20 | 0.18381638601036268 | =+Pavg*B20/100 |
| D20 | 0.12227901003886009 | =+IF(C20<0.0408,0,IF(C20<1.25,0.855(C20-0.0408),(C20-0.20.204)^2/(C20+0.8*0.204))) |
| E20 | 1.2003771808802761 | =+MIN(D20/Aratio,dBMP) |
| F20 | 0 | =+MAX('BMP Calculations'!$G$6-E20,0) |
| G20 | 0.46537474733404083 | =+MAX(E20-RERWC,0) |
| H20 | 0.04740640217715604 | =+G20*Aratio |
| I20 | 0.23382584158436504 | =SUM($H$3:H20) |
| J20 | ||
| K20 | ||
| L20 | ||
| M20 | ||
| N20 | ||
| O20 | ||
| P20 | ||
| Q20 | 0.18381638601036268 | ='event calc table'!C20 |
| R20 | #REF! | =+IF(Q20<=0.2#REF!$C$29,0,(Q20-0.2#REF!$C$29)^2/(Q20+0.8*#REF!$C$29)) |
| S20 | ||
| A21 | 19 | |
| B21 | 0.39852003800809854 | |
| C21 | 0.19049257816787107 | =+Pavg*B21/100 |
| D21 | 0.12798715433352975 | =+IF(C21<0.0408,0,IF(C21<1.25,0.855(C21-0.0408),(C21-0.20.204)^2/(C21+0.8*0.204))) |
| E21 | 1.256412359397962 | =+MIN(D21/Aratio,dBMP) |
| F21 | 0 | =+MAX('BMP Calculations'!$G$6-E21,0) |
| G21 | 0.5214099258517266 | =+MAX(E21-RERWC,0) |
| H21 | 0.053114546471825716 | =+G21*Aratio |
| I21 | 0.28694038805619076 | =SUM($H$3:H21) |
| J21 | ||
| K21 | ||
| L21 | ||
| M21 | ||
| N21 | ||
| O21 | ||
| P21 | ||
| Q21 | 0.19049257816787107 | ='event calc table'!C21 |
| R21 | #REF! | =+IF(Q21<=0.2#REF!$C$29,0,(Q21-0.2#REF!$C$29)^2/(Q21+0.8*#REF!$C$29)) |
| S21 | ||
| A22 | 20 | |
| B22 | 0.4136061266397493 | |
| C22 | 0.19770372853380017 | =+Pavg*B22/100 |
| D22 | 0.13415268789639914 | =+IF(C22<0.0408,0,IF(C22<1.25,0.855(C22-0.0408),(C22-0.20.204)^2/(C22+0.8*0.204))) |
| E22 | 1.3169375942233654 | =+MIN(D22/Aratio,dBMP) |
| F22 | 0 | =+MAX('BMP Calculations'!$G$6-E22,0) |
| G22 | 0.5819351606771301 | =+MAX(E22-RERWC,0) |
| H22 | 0.05928008003469511 | =+G22*Aratio |
| I22 | 0.34622046809088586 | =SUM($H$3:H22) |
| J22 | ||
| K22 | ||
| L22 | ||
| M22 | ||
| N22 | ||
| O22 | ||
| P22 | ||
| Q22 | 0.19770372853380017 | ='event calc table'!C22 |
| R22 | #REF! | =+IF(Q22<=0.2#REF!$C$29,0,(Q22-0.2#REF!$C$29)^2/(Q22+0.8*#REF!$C$29)) |
| S22 | ||
| A23 | 21 | |
| B23 | 0.42848011650810724 | |
| C23 | 0.20481349569087523 | =+Pavg*B23/100 |
| D23 | 0.1402315388156983 | =+IF(C23<0.0408,0,IF(C23<1.25,0.855(C23-0.0408),(C23-0.20.204)^2/(C23+0.8*0.204))) |
| E23 | 1.3766118909581921 | =+MIN(D23/Aratio,dBMP) |
| F23 | 0 | =+MAX('BMP Calculations'!$G$6-E23,0) |
| G23 | 0.6416094574119569 | =+MAX(E23-RERWC,0) |
| H23 | 0.06535893095399425 | =+G23*Aratio |
| I23 | 0.4115793990448801 | =SUM($H$3:H23) |
| J23 | ||
| K23 | ||
| L23 | ||
| M23 | ||
| N23 | ||
| O23 | ||
| P23 | ||
| Q23 | 0.20481349569087523 | ='event calc table'!C23 |
| R23 | #REF! | =+IF(Q23<=0.2#REF!$C$29,0,(Q23-0.2#REF!$C$29)^2/(Q23+0.8*#REF!$C$29)) |
| S23 | ||
| A24 | 22 | |
| B24 | 0.44444167663079576 | |
| C24 | 0.21244312142952038 | =+Pavg*B24/100 |
| D24 | 0.14675486882223993 | =+IF(C24<0.0408,0,IF(C24<1.25,0.855(C24-0.0408),(C24-0.20.204)^2/(C24+0.8*0.204))) |
| E24 | 1.4406495085404383 | =+MIN(D24/Aratio,dBMP) |
| F24 | 0 | =+MAX('BMP Calculations'!$G$6-E24,0) |
| G24 | 0.705647074994203 | =+MAX(E24-RERWC,0) |
| H24 | 0.07188226096053589 | =+G24*Aratio |
| I24 | 0.483461660005416 | =SUM($H$3:H24) |
| J24 | ||
| K24 | ||
| L24 | ||
| M24 | ||
| N24 | ||
| O24 | ||
| P24 | ||
| Q24 | 0.21244312142952038 | ='event calc table'!C24 |
| R24 | #REF! | =+IF(Q24<=0.2#REF!$C$29,0,(Q24-0.2#REF!$C$29)^2/(Q24+0.8*#REF!$C$29)) |
| S24 | ||
| A25 | 23 | |
| B25 | 0.46071912852860175 | |
| C25 | 0.22022374343667164 | =+Pavg*B25/100 |
| D25 | 0.15340730063835425 | =+IF(C25<0.0408,0,IF(C25<1.25,0.855(C25-0.0408),(C25-0.20.204)^2/(C25+0.8*0.204))) |
| E25 | 1.505954480725671 | =+MIN(D25/Aratio,dBMP) |
| F25 | 0 | =+MAX('BMP Calculations'!$G$6-E25,0) |
| G25 | 0.7709520471794358 | =+MAX(E25-RERWC,0) |
| H25 | 0.0785346927766502 | =+G25*Aratio |
| I25 | 0.5619963527820662 | =SUM($H$3:H25) |
| J25 | ||
| K25 | ||
| L25 | ||
| M25 | ||
| N25 | ||
| O25 | ||
| P25 | ||
| Q25 | 0.22022374343667164 | ='event calc table'!C25 |
| R25 | #REF! | =+IF(Q25<=0.2#REF!$C$29,0,(Q25-0.2#REF!$C$29)^2/(Q25+0.8*#REF!$C$29)) |
| S25 | ||
| A26 | 24 | |
| B26 | 0.4776780041127303 | |
| C26 | 0.22833008596588505 | =+Pavg*B26/100 |
| D26 | 0.1603382235008317 | =+IF(C26<0.0408,0,IF(C26<1.25,0.855(C26-0.0408),(C26-0.20.204)^2/(C26+0.8*0.204))) |
| E26 | 1.573993317840196 | =+MIN(D26/Aratio,dBMP) |
| F26 | 0 | =+MAX('BMP Calculations'!$G$6-E26,0) |
| G26 | 0.8389908842939606 | =+MAX(E26-RERWC,0) |
| H26 | 0.08546561563912768 | =+G26*Aratio |
| I26 | 0.6474619684211939 | =SUM($H$3:H26) |
| J26 | ||
| K26 | ||
| L26 | ||
| M26 | ||
| N26 | ||
| O26 | ||
| P26 | ||
| Q26 | 0.22833008596588505 | ='event calc table'!C26 |
| R26 | #REF! | =+IF(Q26<=0.2#REF!$C$29,0,(Q26-0.2#REF!$C$29)^2/(Q26+0.8*#REF!$C$29)) |
| S26 | ||
| A27 | 25 | |
| B27 | 0.49469103257259384 | |
| C27 | 0.23646231356969985 | =+Pavg*B27/100 |
| D27 | 0.16729127810209338 | =+IF(C27<0.0408,0,IF(C27<1.25,0.855(C27-0.0408),(C27-0.20.204)^2/(C27+0.8*0.204))) |
| E27 | 1.6422494157438072 | =+MIN(D27/Aratio,dBMP) |
| F27 | 0 | =+MAX('BMP Calculations'!$G$6-E27,0) |
| G27 | 0.9072469821975719 | =+MAX(E27-RERWC,0) |
| H27 | 0.09241867024038933 | =+G27*Aratio |
| I27 | 0.7398806386615832 | =SUM($H$3:H27) |
| J27 | ||
| K27 | ||
| L27 | ||
| M27 | ||
| N27 | ||
| O27 | ||
| P27 | ||
| Q27 | 0.23646231356969985 | ='event calc table'!C27 |
| R27 | #REF! | =+IF(Q27<=0.2#REF!$C$29,0,(Q27-0.2#REF!$C$29)^2/(Q27+0.8*#REF!$C$29)) |
| S27 | ||
| A28 | 26 | |
| B28 | 0.51291347525719 | |
| C28 | 0.2451726411729368 | =+Pavg*B28/100 |
| D28 | 0.17473860820286097 | =+IF(C28<0.0408,0,IF(C28<1.25,0.855(C28-0.0408),(C28-0.20.204)^2/(C28+0.8*0.204))) |
| E28 | 1.7153576712702727 | =+MIN(D28/Aratio,dBMP) |
| F28 | 0 | =+MAX('BMP Calculations'!$G$6-E28,0) |
| G28 | 0.9803552377240374 | =+MAX(E28-RERWC,0) |
| H28 | 0.09986600034115692 | =+G28*Aratio |
| I28 | 0.83974663900274 | =SUM($H$3:H28) |
| J28 | ||
| K28 | ||
| L28 | ||
| M28 | ||
| N28 | ||
| O28 | ||
| P28 | ||
| Q28 | 0.2451726411729368 | ='event calc table'!C28 |
| R28 | #REF! | =+IF(Q28<=0.2#REF!$C$29,0,(Q28-0.2#REF!$C$29)^2/(Q28+0.8*#REF!$C$29)) |
| S28 | ||
| A29 | 27 | |
| B29 | 0.5309960230128059 | |
| C29 | 0.2538160990001212 | =+Pavg*B29/100 |
| D29 | 0.1821287646451036 | =+IF(C29<0.0408,0,IF(C29<1.25,0.855(C29-0.0408),(C29-0.20.204)^2/(C29+0.8*0.204))) |
| E29 | 1.7879046697582737 | =+MIN(D29/Aratio,dBMP) |
| F29 | 0 | =+MAX('BMP Calculations'!$G$6-E29,0) |
| G29 | 1.0529022362120384 | =+MAX(E29-RERWC,0) |
| H29 | 0.10725615678339956 | =+G29*Aratio |
| I29 | 0.9470027957861396 | =SUM($H$3:H29) |
| J29 | ||
| K29 | ||
| L29 | ||
| M29 | ||
| N29 | ||
| O29 | ||
| P29 | ||
| Q29 | 0.2538160990001212 | ='event calc table'!C29 |
| R29 | #REF! | =+IF(Q29<=0.2#REF!$C$29,0,(Q29-0.2#REF!$C$29)^2/(Q29+0.8*#REF!$C$29)) |
| S29 | ||
| A30 | 28 | |
| B30 | 0.549994656916261 | |
| C30 | 0.26289744600597276 | =+Pavg*B30/100 |
| D30 | 0.1898933163351067 | =+IF(C30<0.0408,0,IF(C30<1.25,0.855(C30-0.0408),(C30-0.20.204)^2/(C30+0.8*0.204))) |
| E30 | 1.8641269965949325 | =+MIN(D30/Aratio,dBMP) |
| F30 | 0 | =+MAX('BMP Calculations'!$G$6-E30,0) |
| G30 | 1.1291245630486972 | =+MAX(E30-RERWC,0) |
| H30 | 0.11502070847340265 | =+G30*Aratio |
| I30 | 1.0620235042595423 | =SUM($H$3:H30) |
| J30 | ||
| K30 | ||
| L30 | ||
| M30 | ||
| N30 | ||
| O30 | ||
| P30 | ||
| Q30 | 0.26289744600597276 | ='event calc table'!C30 |
| R30 | #REF! | =+IF(Q30<=0.2#REF!$C$29,0,(Q30-0.2#REF!$C$29)^2/(Q30+0.8*#REF!$C$29)) |
| S30 | ||
| A31 | 29 | |
| B31 | 0.5686097079499309 | |
| C31 | 0.271795440400067 | =+Pavg*B31/100 |
| D31 | 0.19750110154205727 | =+IF(C31<0.0408,0,IF(C31<1.25,0.855(C31-0.0408),(C31-0.20.204)^2/(C31+0.8*0.204))) |
| E31 | 1.9388103928422509 | =+MIN(D31/Aratio,dBMP) |
| F31 | 0 | =+MAX('BMP Calculations'!$G$6-E31,0) |
| G31 | 1.2038079592960156 | =+MAX(E31-RERWC,0) |
| H31 | 0.12262849368035322 | =+G31*Aratio |
| I31 | 1.1846519979398955 | =SUM($H$3:H31) |
| J31 | ||
| K31 | ||
| L31 | ||
| M31 | ||
| N31 | ||
| O31 | ||
| P31 | ||
| Q31 | 0.271795440400067 | ='event calc table'!C31 |
| R31 | #REF! | =+IF(Q31<=0.2#REF!$C$29,0,(Q31-0.2#REF!$C$29)^2/(Q31+0.8*#REF!$C$29)) |
| S31 | ||
| A32 | 30 | |
| B32 | 0.5882130489657522 | |
| C32 | 0.28116583740562956 | =+Pavg*B32/100 |
| D32 | 0.20551279098181327 | =+IF(C32<0.0408,0,IF(C32<1.25,0.855(C32-0.0408),(C32-0.20.204)^2/(C32+0.8*0.204))) |
| E32 | 2.0174587984903365 | =+MIN(D32/Aratio,dBMP) |
| F32 | 0 | =+MAX('BMP Calculations'!$G$6-E32,0) |
| G32 | 1.2824563649441012 | =+MAX(E32-RERWC,0) |
| H32 | 0.13064018312010925 | =+G32*Aratio |
| I32 | 1.3152921810600047 | =SUM($H$3:H32) |
| J32 | ||
| K32 | ||
| L32 | ||
| M32 | ||
| N32 | ||
| O32 | ||
| P32 | ||
| Q32 | 0.28116583740562956 | ='event calc table'!C32 |
| R32 | #REF! | =+IF(Q32<=0.2#REF!$C$29,0,(Q32-0.2#REF!$C$29)^2/(Q32+0.8*#REF!$C$29)) |
| S32 | ||
| A33 | 31 | |
| B33 | 0.6085700175022093 | |
| C33 | 0.29089646836605604 | =+Pavg*B33/100 |
| D33 | 0.2138324804529779 | =+IF(C33<0.0408,0,IF(C33<1.25,0.855(C33-0.0408),(C33-0.20.204)^2/(C33+0.8*0.204))) |
| E33 | 2.099130750119828 | =+MIN(D33/Aratio,dBMP) |
| F33 | 0 | =+MAX('BMP Calculations'!$G$6-E33,0) |
| G33 | 1.364128316573593 | =+MAX(E33-RERWC,0) |
| H33 | 0.13895987259127388 | =+G33*Aratio |
| I33 | 1.4542520536512786 | =SUM($H$3:H33) |
| J33 | ||
| K33 | ||
| L33 | ||
| M33 | ||
| N33 | ||
| O33 | ||
| P33 | ||
| Q33 | 0.29089646836605604 | ='event calc table'!C33 |
| R33 | #REF! | =+IF(Q33<=0.2#REF!$C$29,0,(Q33-0.2#REF!$C$29)^2/(Q33+0.8*#REF!$C$29)) |
| S33 | ||
| A34 | 32 | |
| B34 | 0.6300596836894427 | |
| C34 | 0.30116852880355355 | =+Pavg*B34/100 |
| D34 | 0.22261509212703828 | =+IF(C34<0.0408,0,IF(C34<1.25,0.855(C34-0.0408),(C34-0.20.204)^2/(C34+0.8*0.204))) |
| E34 | 2.185347073254309 | =+MIN(D34/Aratio,dBMP) |
| F34 | 0 | =+MAX('BMP Calculations'!$G$6-E34,0) |
| G34 | 1.4503446397080737 | =+MAX(E34-RERWC,0) |
| H34 | 0.14774248426533423 | =+G34*Aratio |
| I34 | 1.601994537916613 | =SUM($H$3:H34) |
| J34 | ||
| K34 | ||
| L34 | ||
| M34 | ||
| N34 | ||
| O34 | ||
| P34 | ||
| Q34 | 0.30116852880355355 | ='event calc table'!C34 |
| R34 | #REF! | =+IF(Q34<=0.2#REF!$C$29,0,(Q34-0.2#REF!$C$29)^2/(Q34+0.8*#REF!$C$29)) |
| S34 | ||
| A35 | 33 | |
| B35 | 0.6515809390541878 | |
| C35 | 0.31145568886790176 | =+Pavg*B35/100 |
| D35 | 0.231410613982056 | =+IF(C35<0.0408,0,IF(C35<1.25,0.855(C35-0.0408),(C35-0.20.204)^2/(C35+0.8*0.204))) |
| E35 | 2.2716901318490894 | =+MIN(D35/Aratio,dBMP) |
| F35 | 0 | =+MAX('BMP Calculations'!$G$6-E35,0) |
| G35 | 1.5366876983028541 | =+MAX(E35-RERWC,0) |
| H35 | 0.15653800612035196 | =+G35*Aratio |
| I35 | 1.758532544036965 | =SUM($H$3:H35) |
| J35 | ||
| K35 | ||
| L35 | ||
| M35 | ||
| N35 | ||
| O35 | ||
| P35 | ||
| Q35 | 0.31145568886790176 | ='event calc table'!C35 |
| R35 | #REF! | =+IF(Q35<=0.2#REF!$C$29,0,(Q35-0.2#REF!$C$29)^2/(Q35+0.8*#REF!$C$29)) |
| S35 | ||
| A36 | 34 | |
| B36 | 0.6739596149513923 | |
| C36 | 0.3221526959467655 | =+Pavg*B36/100 |
| D36 | 0.24055655503448448 | =+IF(C36<0.0408,0,IF(C36<1.25,0.855(C36-0.0408),(C36-0.20.204)^2/(C36+0.8*0.204))) |
| E36 | 2.3614731529376827 | =+MIN(D36/Aratio,dBMP) |
| F36 | 0 | =+MAX('BMP Calculations'!$G$6-E36,0) |
| G36 | 1.6264707193914474 | =+MAX(E36-RERWC,0) |
| H36 | 0.16568394717278043 | =+G36*Aratio |
| I36 | 1.9242164912097455 | =SUM($H$3:H36) |
| J36 | ||
| K36 | ||
| L36 | ||
| M36 | ||
| N36 | ||
| O36 | ||
| P36 | ||
| Q36 | 0.3221526959467655 | ='event calc table'!C36 |
| R36 | #REF! | =+IF(Q36<=0.2#REF!$C$29,0,(Q36-0.2#REF!$C$29)^2/(Q36+0.8*#REF!$C$29)) |
| S36 | ||
| A37 | 35 | |
| B37 | 0.6968031030319836 | |
| C37 | 0.3330718832492881 | =+Pavg*B37/100 |
| D37 | 0.24989246017814132 | =+IF(C37<0.0408,0,IF(C37<1.25,0.855(C37-0.0408),(C37-0.20.204)^2/(C37+0.8*0.204))) |
| E37 | 2.453120995799242 | =+MIN(D37/Aratio,dBMP) |
| F37 | 0 | =+MAX('BMP Calculations'!$G$6-E37,0) |
| G37 | 1.7181185622530066 | =+MAX(E37-RERWC,0) |
| H37 | 0.1750198523164373 | =+G37*Aratio |
| I37 | 2.099236343526183 | =SUM($H$3:H37) |
| J37 | ||
| K37 | ||
| L37 | ||
| M37 | ||
| N37 | ||
| O37 | ||
| P37 | ||
| Q37 | 0.3330718832492881 | ='event calc table'!C37 |
| R37 | #REF! | =+IF(Q37<=0.2#REF!$C$29,0,(Q37-0.2#REF!$C$29)^2/(Q37+0.8*#REF!$C$29)) |
| S37 | ||
| A38 | 36 | |
| B38 | 0.7200843268580936 | |
| C38 | 0.3442003082381687 | =+Pavg*B38/100 |
| D38 | 0.25940726354363425 | =+IF(C38<0.0408,0,IF(C38<1.25,0.855(C38-0.0408),(C38-0.20.204)^2/(C38+0.8*0.204))) |
| E38 | 2.546525030039222 | =+MIN(D38/Aratio,dBMP) |
| F38 | 0 | =+MAX('BMP Calculations'!$G$6-E38,0) |
| G38 | 1.8115225964929869 | =+MAX(E38-RERWC,0) |
| H38 | 0.18453465568193023 | =+G38*Aratio |
| I38 | 2.283770999208113 | =SUM($H$3:H38) |
| J38 | ||
| K38 | ||
| L38 | ||
| M38 | ||
| N38 | ||
| O38 | ||
| P38 | ||
| Q38 | 0.3442003082381687 | ='event calc table'!C38 |
| R38 | #REF! | =+IF(Q38<=0.2#REF!$C$29,0,(Q38-0.2#REF!$C$29)^2/(Q38+0.8*#REF!$C$29)) |
| S38 | ||
| A39 | 37 | |
| B39 | 0.7451255191455685 | |
| C39 | 0.35616999815158173 | =+Pavg*B39/100 |
| D39 | 0.26964134841960236 | =+IF(C39<0.0408,0,IF(C39<1.25,0.855(C39-0.0408),(C39-0.20.204)^2/(C39+0.8*0.204))) |
| E39 | 2.6469900399244017 | =+MIN(D39/Aratio,dBMP) |
| F39 | 0 | =+MAX('BMP Calculations'!$G$6-E39,0) |
| G39 | 1.9119876063781664 | =+MAX(E39-RERWC,0) |
| H39 | 0.1947687405578983 | =+G39*Aratio |
| I39 | 2.4785397397660116 | =SUM($H$3:H39) |
| J39 | ||
| K39 | ||
| L39 | ||
| M39 | ||
| N39 | ||
| O39 | ||
| P39 | ||
| Q39 | 0.35616999815158173 | ='event calc table'!C39 |
| R39 | #REF! | =+IF(Q39<=0.2#REF!$C$29,0,(Q39-0.2#REF!$C$29)^2/(Q39+0.8*#REF!$C$29)) |
| S39 | ||
| A40 | 38 | |
| B40 | 0.770423937592782 | |
| C40 | 0.3682626421693498 | =+Pavg*B40/100 |
| D40 | 0.2799805590547941 | =+IF(C40<0.0408,0,IF(C40<1.25,0.855(C40-0.0408),(C40-0.20.204)^2/(C40+0.8*0.204))) |
| E40 | 2.748487038557729 | =+MIN(D40/Aratio,dBMP) |
| F40 | 0 | =+MAX('BMP Calculations'!$G$6-E40,0) |
| G40 | 2.0134846050114934 | =+MAX(E40-RERWC,0) |
| H40 | 0.20510795119309 | =+G40*Aratio |
| I40 | 2.6836476909591016 | =SUM($H$3:H40) |
| J40 | ||
| K40 | ||
| L40 | ||
| M40 | ||
| N40 | ||
| O40 | ||
| P40 | ||
| Q40 | 0.3682626421693498 | ='event calc table'!C40 |
| R40 | #REF! | =+IF(Q40<=0.2#REF!$C$29,0,(Q40-0.2#REF!$C$29)^2/(Q40+0.8*#REF!$C$29)) |
| S40 | ||
| A41 | 39 | |
| B41 | 0.7967196715014353 | |
| C41 | 0.38083200297768605 | =+Pavg*B41/100 |
| D41 | 0.2907273625459216 | =+IF(C41<0.0408,0,IF(C41<1.25,0.855(C41-0.0408),(C41-0.20.204)^2/(C41+0.8*0.204))) |
| E41 | 2.853985256723335 | =+MIN(D41/Aratio,dBMP) |
| F41 | 0 | =+MAX('BMP Calculations'!$G$6-E41,0) |
| G41 | 2.1189828231770997 | =+MAX(E41-RERWC,0) |
| H41 | 0.21585475468421758 | =+G41*Aratio |
| I41 | 2.899502445643319 | =SUM($H$3:H41) |
| J41 | ||
| K41 | ||
| L41 | ||
| M41 | ||
| N41 | ||
| O41 | ||
| P41 | ||
| Q41 | 0.38083200297768605 | ='event calc table'!C41 |
| R41 | #REF! | =+IF(Q41<=0.2#REF!$C$29,0,(Q41-0.2#REF!$C$29)^2/(Q41+0.8*#REF!$C$29)) |
| S41 | ||
| A42 | 40 | |
| B42 | 0.823331297185206 | |
| C42 | 0.3935523600545284 | =+Pavg*B42/100 |
| D42 | 0.3016032678466218 | =+IF(C42<0.0408,0,IF(C42<1.25,0.855(C42-0.0408),(C42-0.20.204)^2/(C42+0.8*0.204))) |
| E42 | 2.960750829491927 | =+MIN(D42/Aratio,dBMP) |
| F42 | 0 | =+MAX('BMP Calculations'!$G$6-E42,0) |
| G42 | 2.2257483959456916 | =+MAX(E42-RERWC,0) |
| H42 | 0.22673065998491773 | =+G42*Aratio |
| I42 | 3.126233105628237 | =SUM($H$3:H42) |
| J42 | ||
| K42 | ||
| L42 | ||
| M42 | ||
| N42 | ||
| O42 | ||
| P42 | ||
| Q42 | 0.3935523600545284 | ='event calc table'!C42 |
| R42 | #REF! | =+IF(Q42<=0.2#REF!$C$29,0,(Q42-0.2#REF!$C$29)^2/(Q42+0.8*#REF!$C$29)) |
| S42 | ||
| A43 | 41 | |
| B43 | 0.8512110027090883 | |
| C43 | 0.4068788592949442 | =+Pavg*B43/100 |
| D43 | 0.3129974246971773 | =+IF(C43<0.0408,0,IF(C43<1.25,0.855(C43-0.0408),(C43-0.20.204)^2/(C43+0.8*0.204))) |
| E43 | 3.072603925738216 | =+MIN(D43/Aratio,dBMP) |
| F43 | 0 | =+MAX('BMP Calculations'!$G$6-E43,0) |
| G43 | 2.3376014921919808 | =+MAX(E43-RERWC,0) |
| H43 | 0.2381248168354733 | =+G43*Aratio |
| I43 | 3.3643579224637103 | =SUM($H$3:H43) |
| J43 | ||
| K43 | ||
| L43 | ||
| M43 | ||
| N43 | ||
| O43 | ||
| P43 | ||
| Q43 | 0.4068788592949442 | ='event calc table'!C43 |
| R43 | #REF! | =+IF(Q43<=0.2#REF!$C$29,0,(Q43-0.2#REF!$C$29)^2/(Q43+0.8*#REF!$C$29)) |
| S43 | ||
| A44 | 42 | |
| B44 | 0.8796593134281808 | |
| C44 | 0.4204771518186704 | =+Pavg*B44/100 |
| D44 | 0.3246239648049632 | =+IF(C44<0.0408,0,IF(C44<1.25,0.855(C44-0.0408),(C44-0.20.204)^2/(C44+0.8*0.204))) |
| E44 | 3.186738260269876 | =+MIN(D44/Aratio,dBMP) |
| F44 | 0 | =+MAX('BMP Calculations'!$G$6-E44,0) |
| G44 | 2.451735826723641 | =+MAX(E44-RERWC,0) |
| H44 | 0.24975135694325917 | =+G44*Aratio |
| I44 | 3.6141092794069696 | =SUM($H$3:H44) |
| J44 | ||
| K44 | ||
| L44 | ||
| M44 | ||
| N44 | ||
| O44 | ||
| P44 | ||
| Q44 | 0.4204771518186704 | ='event calc table'!C44 |
| R44 | #REF! | =+IF(Q44<=0.2#REF!$C$29,0,(Q44-0.2#REF!$C$29)^2/(Q44+0.8*#REF!$C$29)) |
| S44 | ||
| A45 | 43 | |
| B45 | 0.909407293164896 | |
| C45 | 0.43469668613282025 | =+Pavg*B45/100 |
| D45 | 0.3367816666435613 | =+IF(C45<0.0408,0,IF(C45<1.25,0.855(C45-0.0408),(C45-0.20.204)^2/(C45+0.8*0.204))) |
| E45 | 3.3060868537395276 | =+MIN(D45/Aratio,dBMP) |
| F45 | 0 | =+MAX('BMP Calculations'!$G$6-E45,0) |
| G45 | 2.5710844201932925 | =+MAX(E45-RERWC,0) |
| H45 | 0.2619090587818573 | =+G45*Aratio |
| I45 | 3.876018338188827 | =SUM($H$3:H45) |
| J45 | ||
| K45 | ||
| L45 | ||
| M45 | ||
| N45 | ||
| O45 | ||
| P45 | ||
| Q45 | 0.43469668613282025 | ='event calc table'!C45 |
| R45 | #REF! | =+IF(Q45<=0.2#REF!$C$29,0,(Q45-0.2#REF!$C$29)^2/(Q45+0.8*#REF!$C$29)) |
| S45 | ||
| A46 | 44 | |
| B46 | 0.9406805789014624 | |
| C46 | 0.449645316714899 | =+Pavg*B46/100 |
| D46 | 0.34956274579123864 | =+IF(C46<0.0408,0,IF(C46<1.25,0.855(C46-0.0408),(C46-0.20.204)^2/(C46+0.8*0.204))) |
| E46 | 3.431554959435026 | =+MIN(D46/Aratio,dBMP) |
| F46 | 0 | =+MAX('BMP Calculations'!$G$6-E46,0) |
| G46 | 2.696552525888791 | =+MAX(E46-RERWC,0) |
| H46 | 0.2746901379295346 | =+G46*Aratio |
| I46 | 4.1507084761183615 | =SUM($H$3:H46) |
| J46 | ||
| K46 | ||
| L46 | ||
| M46 | ||
| N46 | ||
| O46 | ||
| P46 | ||
| Q46 | 0.449645316714899 | ='event calc table'!C46 |
| R46 | #REF! | =+IF(Q46<=0.2#REF!$C$29,0,(Q46-0.2#REF!$C$29)^2/(Q46+0.8*#REF!$C$29)) |
| S46 | ||
| A47 | 45 | |
| B47 | 0.9714123358806845 | |
| C47 | 0.4643350965509672 | =+Pavg*B47/100 |
| D47 | 0.36212250755107694 | =+IF(C47<0.0408,0,IF(C47<1.25,0.855(C47-0.0408),(C47-0.20.204)^2/(C47+0.8*0.204))) |
| E47 | 3.5548504572396884 | =+MIN(D47/Aratio,dBMP) |
| F47 | 0 | =+MAX('BMP Calculations'!$G$6-E47,0) |
| G47 | 2.819848023693453 | =+MAX(E47-RERWC,0) |
| H47 | 0.28724989968937287 | =+G47*Aratio |
| I47 | 4.437958375807734 | =SUM($H$3:H47) |
| J47 | ||
| K47 | ||
| L47 | ||
| M47 | ||
| N47 | ||
| O47 | ||
| P47 | ||
| Q47 | 0.4643350965509672 | ='event calc table'!C47 |
| R47 | #REF! | =+IF(Q47<=0.2#REF!$C$29,0,(Q47-0.2#REF!$C$29)^2/(Q47+0.8*#REF!$C$29)) |
| S47 | ||
| A48 | 46 | |
| B48 | 1.0041296983034989 | |
| C48 | 0.4799739957890724 | =+Pavg*B48/100 |
| D48 | 0.37549376639965687 | =+IF(C48<0.0408,0,IF(C48<1.25,0.855(C48-0.0408),(C48-0.20.204)^2/(C48+0.8*0.204))) |
| E48 | 3.686112183977401 | =+MIN(D48/Aratio,dBMP) |
| F48 | 0 | =+MAX('BMP Calculations'!$G$6-E48,0) |
| G48 | 2.951109750431166 | =+MAX(E48-RERWC,0) |
| H48 | 0.30062115853795285 | =+G48*Aratio |
| I48 | 4.738579534345687 | =SUM($H$3:H48) |
| J48 | ||
| K48 | ||
| L48 | ||
| M48 | ||
| N48 | ||
| O48 | ||
| P48 | ||
| Q48 | 0.4799739957890724 | ='event calc table'!C48 |
| R48 | #REF! | =+IF(Q48<=0.2#REF!$C$29,0,(Q48-0.2#REF!$C$29)^2/(Q48+0.8*#REF!$C$29)) |
| S48 | ||
| A49 | 47 | |
| B49 | 1.0385709272705217 | |
| C49 | 0.4964369032353093 | =+Pavg*B49/100 |
| D49 | 0.38956955226618944 | =+IF(C49<0.0408,0,IF(C49<1.25,0.855(C49-0.0408),(C49-0.20.204)^2/(C49+0.8*0.204))) |
| E49 | 3.8242900458342577 | =+MIN(D49/Aratio,dBMP) |
| F49 | 0 | =+MAX('BMP Calculations'!$G$6-E49,0) |
| G49 | 3.0892876122880226 | =+MAX(E49-RERWC,0) |
| H49 | 0.3146969444044854 | =+G49*Aratio |
| I49 | 5.053276478750173 | =SUM($H$3:H49) |
| J49 | ||
| K49 | ||
| L49 | ||
| M49 | ||
| N49 | ||
| O49 | ||
| P49 | ||
| Q49 | 0.4964369032353093 | ='event calc table'!C49 |
| R49 | #REF! | =+IF(Q49<=0.2#REF!$C$29,0,(Q49-0.2#REF!$C$29)^2/(Q49+0.8*#REF!$C$29)) |
| S49 | ||
| A50 | 48 | |
| B50 | 1.0722088885808196 | |
| C50 | 0.5125158487416318 | =+Pavg*B50/100 |
| D50 | 0.4033170506740952 | =+IF(C50<0.0408,0,IF(C50<1.25,0.855(C50-0.0408),(C50-0.20.204)^2/(C50+0.8*0.204))) |
| E50 | 3.959245205986385 | =+MIN(D50/Aratio,dBMP) |
| F50 | 0 | =+MAX('BMP Calculations'!$G$6-E50,0) |
| G50 | 3.2242427724401495 | =+MAX(E50-RERWC,0) |
| H50 | 0.3284444428123911 | =+G50*Aratio |
| I50 | 5.3817209215625645 | =SUM($H$3:H50) |
| J50 | ||
| K50 | ||
| L50 | ||
| M50 | ||
| N50 | ||
| O50 | ||
| P50 | ||
| Q50 | 0.5125158487416318 | ='event calc table'!C50 |
| R50 | #REF! | =+IF(Q50<=0.2#REF!$C$29,0,(Q50-0.2#REF!$C$29)^2/(Q50+0.8*#REF!$C$29)) |
| S50 | ||
| A51 | 49 | |
| B51 | 1.108477777103875 | |
| C51 | 0.5298523774556522 | =+Pavg*B51/100 |
| D51 | 0.4181397827245826 | =+IF(C51<0.0408,0,IF(C51<1.25,0.855(C51-0.0408),(C51-0.20.204)^2/(C51+0.8*0.204))) |
| E51 | 4.104755619474793 | =+MIN(D51/Aratio,dBMP) |
| F51 | 0 | =+MAX('BMP Calculations'!$G$6-E51,0) |
| G51 | 3.369753185928558 | =+MAX(E51-RERWC,0) |
| H51 | 0.34326717486287855 | =+G51*Aratio |
| I51 | 5.724988096425443 | =SUM($H$3:H51) |
| J51 | ||
| K51 | ||
| L51 | ||
| M51 | ||
| N51 | ||
| O51 | ||
| P51 | ||
| Q51 | 0.5298523774556522 | ='event calc table'!C51 |
| R51 | #REF! | =+IF(Q51<=0.2#REF!$C$29,0,(Q51-0.2#REF!$C$29)^2/(Q51+0.8*#REF!$C$29)) |
| S51 | ||
| A52 | 50 | |
| B52 | 1.1474317457154242 | |
| C52 | 0.5484723744519727 | =+Pavg*B52/100 |
| D52 | 0.4340598801564366 | =+IF(C52<0.0408,0,IF(C52<1.25,0.855(C52-0.0408),(C52-0.20.204)^2/(C52+0.8*0.204))) |
| E52 | 4.261038547088576 | =+MIN(D52/Aratio,dBMP) |
| F52 | 0 | =+MAX('BMP Calculations'!$G$6-E52,0) |
| G52 | 3.5260361135423413 | =+MAX(E52-RERWC,0) |
| H52 | 0.3591872722947325 | =+G52*Aratio |
| I52 | 6.084175368720176 | =SUM($H$3:H52) |
| J52 | ||
| K52 | ||
| L52 | ||
| M52 | ||
| N52 | ||
| O52 | ||
| P52 | ||
| Q52 | 0.5484723744519727 | ='event calc table'!C52 |
| R52 | #REF! | =+IF(Q52<=0.2#REF!$C$29,0,(Q52-0.2#REF!$C$29)^2/(Q52+0.8*#REF!$C$29)) |
| S52 | ||
| A53 | 51 | |
| B53 | 1.186218742960127 | |
| C53 | 0.5670125591349406 | =+Pavg*B53/100 |
| D53 | 0.44991173806037427 | =+IF(C53<0.0408,0,IF(C53<1.25,0.855(C53-0.0408),(C53-0.20.204)^2/(C53+0.8*0.204))) |
| E53 | 4.416651587269359 | =+MIN(D53/Aratio,dBMP) |
| F53 | 0 | =+MAX('BMP Calculations'!$G$6-E53,0) |
| G53 | 3.681649153723124 | =+MAX(E53-RERWC,0) |
| H53 | 0.37503913019867025 | =+G53*Aratio |
| I53 | 6.459214498918847 | =SUM($H$3:H53) |
| J53 | ||
| K53 | ||
| L53 | ||
| M53 | ||
| N53 | ||
| O53 | ||
| P53 | ||
| Q53 | 0.5670125591349406 | ='event calc table'!C53 |
| R53 | #REF! | =+IF(Q53<=0.2#REF!$C$29,0,(Q53-0.2#REF!$C$29)^2/(Q53+0.8*#REF!$C$29)) |
| S53 | ||
| A54 | 52 | |
| B54 | 1.2262557690863614 | |
| C54 | 0.5861502576232807 | =+Pavg*B54/100 |
| D54 | 0.466274470267905 | =+IF(C54<0.0408,0,IF(C54<1.25,0.855(C54-0.0408),(C54-0.20.204)^2/(C54+0.8*0.204))) |
| E54 | 4.5772797306648005 | =+MIN(D54/Aratio,dBMP) |
| F54 | 0 | =+MAX('BMP Calculations'!$G$6-E54,0) |
| G54 | 3.8422772971185655 | =+MAX(E54-RERWC,0) |
| H54 | 0.391401862406201 | =+G54*Aratio |
| I54 | 6.850616361325048 | =SUM($H$3:H54) |
| J54 | ||
| K54 | ||
| L54 | ||
| M54 | ||
| N54 | ||
| O54 | ||
| P54 | ||
| Q54 | 0.5861502576232807 | ='event calc table'!C54 |
| R54 | #REF! | =+IF(Q54<=0.2#REF!$C$29,0,(Q54-0.2#REF!$C$29)^2/(Q54+0.8*#REF!$C$29)) |
| S54 | ||
| A55 | 53 | |
| B55 | 1.2688515185910434 | |
| C55 | 0.6065110258865187 | =+Pavg*B55/100 |
| D55 | 0.48368292713297356 | =+IF(C55<0.0408,0,IF(C55<1.25,0.855(C55-0.0408),(C55-0.20.204)^2/(C55+0.8*0.204))) |
| E55 | 4.748173446344425 | =+MIN(D55/Aratio,dBMP) |
| F55 | 0 | =+MAX('BMP Calculations'!$G$6-E55,0) |
| G55 | 4.01317101279819 | =+MAX(E55-RERWC,0) |
| H55 | 0.40881031927126954 | =+G55*Aratio |
| I55 | 7.2594266805963175 | =SUM($H$3:H55) |
| J55 | ||
| K55 | ||
| L55 | ||
| M55 | ||
| N55 | ||
| O55 | ||
| P55 | ||
| Q55 | 0.6065110258865187 | ='event calc table'!C55 |
| R55 | #REF! | =+IF(Q55<=0.2#REF!$C$29,0,(Q55-0.2#REF!$C$29)^2/(Q55+0.8*#REF!$C$29)) |
| S55 | ||
| A56 | 54 | |
| B56 | 1.3131305199831331 | |
| C56 | 0.6276763885519376 | =+Pavg*B56/100 |
| D56 | 0.5017793122119067 | =+IF(C56<0.0408,0,IF(C56<1.25,0.855(C56-0.0408),(C56-0.20.204)^2/(C56+0.8*0.204))) |
| E56 | 4.92582035155138 | =+MIN(D56/Aratio,dBMP) |
| F56 | 0 | =+MAX('BMP Calculations'!$G$6-E56,0) |
| G56 | 4.190817918005145 | =+MAX(E56-RERWC,0) |
| H56 | 0.42690670435020267 | =+G56*Aratio |
| I56 | 7.68633338494652 | =SUM($H$3:H56) |
| J56 | ||
| K56 | ||
| L56 | ||
| M56 | ||
| N56 | ||
| O56 | ||
| P56 | ||
| Q56 | 0.6276763885519376 | ='event calc table'!C56 |
| R56 | #REF! | =+IF(Q56<=0.2#REF!$C$29,0,(Q56-0.2#REF!$C$29)^2/(Q56+0.8*#REF!$C$29)) |
| S56 | ||
| A57 | 55 | |
| B57 | 1.3577885915053636 | |
| C57 | 0.6490229467395637 | =+Pavg*B57/100 |
| D57 | 0.520030619462327 | =+IF(C57<0.0408,0,IF(C57<1.25,0.855(C57-0.0408),(C57-0.20.204)^2/(C57+0.8*0.204))) |
| E57 | 5.104988082281918 | =+MIN(D57/Aratio,dBMP) |
| F57 | 0 | =+MAX('BMP Calculations'!$G$6-E57,0) |
| G57 | 4.369985648735683 | =+MAX(E57-RERWC,0) |
| H57 | 0.44515801160062296 | =+G57*Aratio |
| I57 | 8.131491396547144 | =SUM($H$3:H57) |
| J57 | ||
| K57 | ||
| L57 | ||
| M57 | ||
| N57 | ||
| O57 | ||
| P57 | ||
| Q57 | 0.6490229467395637 | ='event calc table'!C57 |
| R57 | #REF! | =+IF(Q57<=0.2#REF!$C$29,0,(Q57-0.2#REF!$C$29)^2/(Q57+0.8*#REF!$C$29)) |
| S57 | ||
| A58 | 56 | |
| B58 | 1.4059169598142343 | |
| C58 | 0.672028306791204 | =+Pavg*B58/100 |
| D58 | 0.5397002023064793 | =+IF(C58<0.0408,0,IF(C58<1.25,0.855(C58-0.0408),(C58-0.20.204)^2/(C58+0.8*0.204))) |
| E58 | 5.179003184432713 | =+MIN(D58/Aratio,dBMP) |
| F58 | 0 | =+MAX('BMP Calculations'!$G$6-E58,0) |
| G58 | 4.444000750886478 | =+MAX(E58-RERWC,0) |
| H58 | 0.45269771958831345 | =+G58*Aratio |
| I58 | 8.584189116135457 | =SUM($H$3:H58) |
| J58 | ||
| K58 | ||
| L58 | ||
| M58 | ||
| N58 | ||
| O58 | ||
| P58 | ||
| Q58 | 0.672028306791204 | ='event calc table'!C58 |
| R58 | #REF! | =+IF(Q58<=0.2#REF!$C$29,0,(Q58-0.2#REF!$C$29)^2/(Q58+0.8*#REF!$C$29)) |
| S58 | ||
| A59 | 57 | |
| B59 | 1.4555525831643759 | |
| C59 | 0.6957541347525716 | =+Pavg*B59/100 |
| D59 | 0.5599857852134487 | =+IF(C59<0.0408,0,IF(C59<1.25,0.855(C59-0.0408),(C59-0.20.204)^2/(C59+0.8*0.204))) |
| E59 | 5.179003184432713 | =+MIN(D59/Aratio,dBMP) |
| F59 | 0 | =+MAX('BMP Calculations'!$G$6-E59,0) |
| G59 | 4.444000750886478 | =+MAX(E59-RERWC,0) |
| H59 | 0.45269771958831345 | =+G59*Aratio |
| I59 | 9.03688683572377 | =SUM($H$3:H59) |
| J59 | ||
| K59 | ||
| L59 | ||
| M59 | ||
| N59 | ||
| O59 | ||
| P59 | ||
| Q59 | 0.6957541347525716 | ='event calc table'!C59 |
| R59 | #REF! | =+IF(Q59<=0.2#REF!$C$29,0,(Q59-0.2#REF!$C$29)^2/(Q59+0.8*#REF!$C$29)) |
| S59 | ||
| A60 | 58 | |
| B60 | 1.5072324775734887 | |
| C60 | 0.7204571242801275 | =+Pavg*B60/100 |
| D60 | 0.581106841259509 | =+IF(C60<0.0408,0,IF(C60<1.25,0.855(C60-0.0408),(C60-0.20.204)^2/(C60+0.8*0.204))) |
| E60 | 5.179003184432713 | =+MIN(D60/Aratio,dBMP) |
| F60 | 0 | =+MAX('BMP Calculations'!$G$6-E60,0) |
| G60 | 4.444000750886478 | =+MAX(E60-RERWC,0) |
| H60 | 0.45269771958831345 | =+G60*Aratio |
| I60 | 9.489584555312083 | =SUM($H$3:H60) |
| J60 | ||
| K60 | ||
| L60 | ||
| M60 | ||
| N60 | ||
| O60 | ||
| P60 | ||
| Q60 | 0.7204571242801275 | ='event calc table'!C60 |
| R60 | #REF! | =+IF(Q60<=0.2#REF!$C$29,0,(Q60-0.2#REF!$C$29)^2/(Q60+0.8*#REF!$C$29)) |
| S60 | ||
| A61 | 59 | |
| B61 | 1.5626624586272027 | |
| C61 | 0.7469526552238028 | =+Pavg*B61/100 |
| D61 | 0.6037605202163514 | =+IF(C61<0.0408,0,IF(C61<1.25,0.855(C61-0.0408),(C61-0.20.204)^2/(C61+0.8*0.204))) |
| E61 | 5.179003184432713 | =+MIN(D61/Aratio,dBMP) |
| F61 | 0 | =+MAX('BMP Calculations'!$G$6-E61,0) |
| G61 | 4.444000750886478 | =+MAX(E61-RERWC,0) |
| H61 | 0.45269771958831345 | =+G61*Aratio |
| I61 | 9.942282274900396 | =SUM($H$3:H61) |
| J61 | ||
| K61 | ||
| L61 | ||
| M61 | ||
| N61 | ||
| O61 | ||
| P61 | ||
| Q61 | 0.7469526552238028 | ='event calc table'!C61 |
| R61 | #REF! | =+IF(Q61<=0.2#REF!$C$29,0,(Q61-0.2#REF!$C$29)^2/(Q61+0.8*#REF!$C$29)) |
| S61 | ||
| A62 | 60 | |
| B62 | 1.619130369799157 | |
| C62 | 0.773944316763997 | =+Pavg*B62/100 |
| D62 | 0.6268383908332175 | =+IF(C62<0.0408,0,IF(C62<1.25,0.855(C62-0.0408),(C62-0.20.204)^2/(C62+0.8*0.204))) |
| E62 | 5.179003184432713 | =+MIN(D62/Aratio,dBMP) |
| F62 | 0 | =+MAX('BMP Calculations'!$G$6-E62,0) |
| G62 | 4.444000750886478 | =+MAX(E62-RERWC,0) |
| H62 | 0.45269771958831345 | =+G62*Aratio |
| I62 | 10.39497999448871 | =SUM($H$3:H62) |
| J62 | ||
| K62 | ||
| L62 | ||
| M62 | ||
| N62 | ||
| O62 | ||
| P62 | ||
| Q62 | 0.773944316763997 | ='event calc table'!C62 |
| R62 | #REF! | =+IF(Q62<=0.2#REF!$C$29,0,(Q62-0.2#REF!$C$29)^2/(Q62+0.8*#REF!$C$29)) |
| S62 | ||
| A63 | 61 | |
| B63 | 1.6802057881481736 | |
| C63 | 0.803138366734827 | =+Pavg*B63/100 |
| D63 | 0.651799303558277 | =+IF(C63<0.0408,0,IF(C63<1.25,0.855(C63-0.0408),(C63-0.20.204)^2/(C63+0.8*0.204))) |
| E63 | 5.179003184432713 | =+MIN(D63/Aratio,dBMP) |
| F63 | 0 | =+MAX('BMP Calculations'!$G$6-E63,0) |
| G63 | 4.444000750886478 | =+MAX(E63-RERWC,0) |
| H63 | 0.45269771958831345 | =+G63*Aratio |
| I63 | 10.847677714077022 | =SUM($H$3:H63) |
| J63 | ||
| K63 | ||
| L63 | ||
| M63 | ||
| N63 | ||
| O63 | ||
| P63 | ||
| Q63 | 0.803138366734827 | ='event calc table'!C63 |
| R63 | #REF! | =+IF(Q63<=0.2#REF!$C$29,0,(Q63-0.2#REF!$C$29)^2/(Q63+0.8*#REF!$C$29)) |
| S63 | ||
| A64 | 62 | |
| B64 | 1.743997875763194 | |
| C64 | 0.8336309846148066 | =+Pavg*B64/100 |
| D64 | 0.6778704918456595 | =+IF(C64<0.0408,0,IF(C64<1.25,0.855(C64-0.0408),(C64-0.20.204)^2/(C64+0.8*0.204))) |
| E64 | 5.179003184432713 | =+MIN(D64/Aratio,dBMP) |
| F64 | 0 | =+MAX('BMP Calculations'!$G$6-E64,0) |
| G64 | 4.444000750886478 | =+MAX(E64-RERWC,0) |
| H64 | 0.45269771958831345 | =+G64*Aratio |
| I64 | 11.300375433665335 | =SUM($H$3:H64) |
| J64 | ||
| K64 | ||
| L64 | ||
| M64 | ||
| N64 | ||
| O64 | ||
| P64 | ||
| Q64 | 0.8336309846148066 | ='event calc table'!C64 |
| R64 | #REF! | =+IF(Q64<=0.2#REF!$C$29,0,(Q64-0.2#REF!$C$29)^2/(Q64+0.8*#REF!$C$29)) |
| S64 | ||
| A65 | 63 | |
| B65 | 1.8119913239872691 | |
| C65 | 0.8661318528659145 | =+Pavg*B65/100 |
| D65 | 0.705658734200357 | =+IF(C65<0.0408,0,IF(C65<1.25,0.855(C65-0.0408),(C65-0.20.204)^2/(C65+0.8*0.204))) |
| E65 | 5.179003184432713 | =+MIN(D65/Aratio,dBMP) |
| F65 | 0 | =+MAX('BMP Calculations'!$G$6-E65,0) |
| G65 | 4.444000750886478 | =+MAX(E65-RERWC,0) |
| H65 | 0.45269771958831345 | =+G65*Aratio |
| I65 | 11.753073153253649 | =SUM($H$3:H65) |
| J65 | ||
| K65 | ||
| L65 | ||
| M65 | ||
| N65 | ||
| O65 | ||
| P65 | ||
| Q65 | 0.8661318528659145 | ='event calc table'!C65 |
| R65 | #REF! | =+IF(Q65<=0.2#REF!$C$29,0,(Q65-0.2#REF!$C$29)^2/(Q65+0.8*#REF!$C$29)) |
| S65 | ||
| A66 | 64 | |
| B66 | 1.8823539605247195 | |
| C66 | 0.8997651931308158 | =+Pavg*B66/100 |
| D66 | 0.7344152401268474 | =+IF(C66<0.0408,0,IF(C66<1.25,0.855(C66-0.0408),(C66-0.20.204)^2/(C66+0.8*0.204))) |
| E66 | 5.179003184432713 | =+MIN(D66/Aratio,dBMP) |
| F66 | 0 | =+MAX('BMP Calculations'!$G$6-E66,0) |
| G66 | 4.444000750886478 | =+MAX(E66-RERWC,0) |
| H66 | 0.45269771958831345 | =+G66*Aratio |
| I66 | 12.205770872841962 | =SUM($H$3:H66) |
| J66 | ||
| K66 | ||
| L66 | ||
| M66 | ||
| N66 | ||
| O66 | ||
| P66 | ||
| Q66 | 0.8997651931308158 | ='event calc table'!C66 |
| R66 | #REF! | =+IF(Q66<=0.2#REF!$C$29,0,(Q66-0.2#REF!$C$29)^2/(Q66+0.8*#REF!$C$29)) |
| S66 | ||
| A67 | 65 | |
| B67 | 1.960171642954928 | |
| C67 | 0.9369620453324556 | =+Pavg*B67/100 |
| D67 | 0.7662185487592496 | =+IF(C67<0.0408,0,IF(C67<1.25,0.855(C67-0.0408),(C67-0.20.204)^2/(C67+0.8*0.204))) |
| E67 | 5.179003184432713 | =+MIN(D67/Aratio,dBMP) |
| F67 | 0 | =+MAX('BMP Calculations'!$G$6-E67,0) |
| G67 | 4.444000750886478 | =+MAX(E67-RERWC,0) |
| H67 | 0.45269771958831345 | =+G67*Aratio |
| I67 | 12.658468592430275 | =SUM($H$3:H67) |
| J67 | ||
| K67 | ||
| L67 | ||
| M67 | ||
| N67 | ||
| O67 | ||
| P67 | ||
| Q67 | 0.9369620453324556 | ='event calc table'!C67 |
| R67 | #REF! | =+IF(Q67<=0.2#REF!$C$29,0,(Q67-0.2#REF!$C$29)^2/(Q67+0.8*#REF!$C$29)) |
| S67 | ||
| A68 | 66 | |
| B68 | 2.0444019284200086 | |
| C68 | 0.977224121784764 | =+Pavg*B68/100 |
| D68 | 0.8006426241259732 | =+IF(C68<0.0408,0,IF(C68<1.25,0.855(C68-0.0408),(C68-0.20.204)^2/(C68+0.8*0.204))) |
| E68 | 5.179003184432713 | =+MIN(D68/Aratio,dBMP) |
| F68 | 0 | =+MAX('BMP Calculations'!$G$6-E68,0) |
| G68 | 4.444000750886478 | =+MAX(E68-RERWC,0) |
| H68 | 0.45269771958831345 | =+G68*Aratio |
| I68 | 13.111166312018588 | =SUM($H$3:H68) |
| J68 | ||
| K68 | ||
| L68 | ||
| M68 | ||
| N68 | ||
| O68 | ||
| P68 | ||
| Q68 | 0.977224121784764 | ='event calc table'!C68 |
| R68 | #REF! | =+IF(Q68<=0.2#REF!$C$29,0,(Q68-0.2#REF!$C$29)^2/(Q68+0.8*#REF!$C$29)) |
| S68 | ||
| A69 | 67 | |
| B69 | 2.134715386925907 | |
| C69 | 1.0203939549505834 | =+Pavg*B69/100 |
| D69 | 0.8375528314827488 | =+IF(C69<0.0408,0,IF(C69<1.25,0.855(C69-0.0408),(C69-0.20.204)^2/(C69+0.8*0.204))) |
| E69 | 5.179003184432713 | =+MIN(D69/Aratio,dBMP) |
| F69 | 0 | =+MAX('BMP Calculations'!$G$6-E69,0) |
| G69 | 4.444000750886478 | =+MAX(E69-RERWC,0) |
| H69 | 0.45269771958831345 | =+G69*Aratio |
| I69 | 13.5638640316069 | =SUM($H$3:H69) |
| J69 | ||
| K69 | ||
| L69 | ||
| M69 | ||
| N69 | ||
| O69 | ||
| P69 | ||
| Q69 | 1.0203939549505834 | ='event calc table'!C69 |
| R69 | #REF! | =+IF(Q69<=0.2#REF!$C$29,0,(Q69-0.2#REF!$C$29)^2/(Q69+0.8*#REF!$C$29)) |
| S69 | ||
| A70 | 68 | |
| B70 | 2.234009197324414 | |
| C70 | 1.0678563963210699 | =+Pavg*B70/100 |
| D70 | 0.8781332188545148 | =+IF(C70<0.0408,0,IF(C70<1.25,0.855(C70-0.0408),(C70-0.20.204)^2/(C70+0.8*0.204))) |
| E70 | 5.179003184432713 | =+MIN(D70/Aratio,dBMP) |
| F70 | 0 | =+MAX('BMP Calculations'!$G$6-E70,0) |
| G70 | 4.444000750886478 | =+MAX(E70-RERWC,0) |
| H70 | 0.45269771958831345 | =+G70*Aratio |
| I70 | 14.016561751195214 | =SUM($H$3:H70) |
| J70 | ||
| K70 | ||
| L70 | ||
| M70 | ||
| N70 | ||
| O70 | ||
| P70 | ||
| Q70 | 1.0678563963210699 | ='event calc table'!C70 |
| R70 | #REF! | =+IF(Q70<=0.2#REF!$C$29,0,(Q70-0.2#REF!$C$29)^2/(Q70+0.8*#REF!$C$29)) |
| S70 | ||
| A71 | 69 | |
| B71 | 2.3444946020413466 | |
| C71 | 1.1206684197757637 | =+Pavg*B71/100 |
| D71 | 0.923287498908278 | =+IF(C71<0.0408,0,IF(C71<1.25,0.855(C71-0.0408),(C71-0.20.204)^2/(C71+0.8*0.204))) |
| E71 | 5.179003184432713 | =+MIN(D71/Aratio,dBMP) |
| F71 | 0 | =+MAX('BMP Calculations'!$G$6-E71,0) |
| G71 | 4.444000750886478 | =+MAX(E71-RERWC,0) |
| H71 | 0.45269771958831345 | =+G71*Aratio |
| I71 | 14.469259470783527 | =SUM($H$3:H71) |
| J71 | ||
| K71 | ||
| L71 | ||
| M71 | ||
| N71 | ||
| O71 | ||
| P71 | ||
| Q71 | 1.1206684197757637 | ='event calc table'!C71 |
| R71 | #REF! | =+IF(Q71<=0.2#REF!$C$29,0,(Q71-0.2#REF!$C$29)^2/(Q71+0.8*#REF!$C$29)) |
| S71 | ||
| A72 | 70 | |
| B72 | 2.465359307940689 | |
| C72 | 1.1784417491956491 | =+Pavg*B72/100 |
| D72 | 0.9726836955622801 | =+IF(C72<0.0408,0,IF(C72<1.25,0.855(C72-0.0408),(C72-0.20.204)^2/(C72+0.8*0.204))) |
| E72 | 5.179003184432713 | =+MIN(D72/Aratio,dBMP) |
| F72 | 0 | =+MAX('BMP Calculations'!$G$6-E72,0) |
| G72 | 4.444000750886478 | =+MAX(E72-RERWC,0) |
| H72 | 0.45269771958831345 | =+G72*Aratio |
| I72 | 14.92195719037184 | =SUM($H$3:H72) |
| J72 | ||
| K72 | ||
| L72 | ||
| M72 | ||
| N72 | ||
| O72 | ||
| P72 | ||
| Q72 | 1.1784417491956491 | ='event calc table'!C72 |
| R72 | #REF! | =+IF(Q72<=0.2#REF!$C$29,0,(Q72-0.2#REF!$C$29)^2/(Q72+0.8*#REF!$C$29)) |
| S72 | ||
| A73 | 71 | |
| B73 | 2.599771258252898 | |
| C73 | 1.2426906614448852 | =+Pavg*B73/100 |
| D73 | 1.027616515535377 | =+IF(C73<0.0408,0,IF(C73<1.25,0.855(C73-0.0408),(C73-0.20.204)^2/(C73+0.8*0.204))) |
| E73 | 5.179003184432713 | =+MIN(D73/Aratio,dBMP) |
| F73 | 0 | =+MAX('BMP Calculations'!$G$6-E73,0) |
| G73 | 4.444000750886478 | =+MAX(E73-RERWC,0) |
| H73 | 0.45269771958831345 | =+G73*Aratio |
| I73 | 15.374654909960153 | =SUM($H$3:H73) |
| J73 | ||
| K73 | ||
| L73 | ||
| M73 | ||
| N73 | ||
| O73 | ||
| P73 | ||
| Q73 | 1.2426906614448852 | ='event calc table'!C73 |
| R73 | #REF! | =+IF(Q73<=0.2#REF!$C$29,0,(Q73-0.2#REF!$C$29)^2/(Q73+0.8*#REF!$C$29)) |
| S73 | ||
| A74 | 72 | |
| B74 | 2.753366864793988 | |
| C74 | 1.3161093613715265 | =+Pavg*B74/100 |
| D74 | 1.0994414080459396 | =+IF(C74<0.0408,0,IF(C74<1.25,0.855(C74-0.0408),(C74-0.20.204)^2/(C74+0.8*0.204))) |
| E74 | 5.179003184432713 | =+MIN(D74/Aratio,dBMP) |
| F74 | 0 | =+MAX('BMP Calculations'!$G$6-E74,0) |
| G74 | 4.444000750886478 | =+MAX(E74-RERWC,0) |
| H74 | 0.45269771958831345 | =+G74*Aratio |
| I74 | 15.827352629548466 | =SUM($H$3:H74) |
| J74 | ||
| K74 | ||
| L74 | ||
| M74 | ||
| N74 | ||
| O74 | ||
| P74 | ||
| Q74 | 1.3161093613715265 | ='event calc table'!C74 |
| R74 | #REF! | =+IF(Q74<=0.2#REF!$C$29,0,(Q74-0.2#REF!$C$29)^2/(Q74+0.8*#REF!$C$29)) |
| S74 | ||
| A75 | 73 | |
| B75 | 2.927829379451365 | |
| C75 | 1.3995024433777525 | =+Pavg*B75/100 |
| D75 | 1.1813332329924715 | =+IF(C75<0.0408,0,IF(C75<1.25,0.855(C75-0.0408),(C75-0.20.204)^2/(C75+0.8*0.204))) |
| E75 | 5.179003184432713 | =+MIN(D75/Aratio,dBMP) |
| F75 | 0 | =+MAX('BMP Calculations'!$G$6-E75,0) |
| G75 | 4.444000750886478 | =+MAX(E75-RERWC,0) |
| H75 | 0.45269771958831345 | =+G75*Aratio |
| I75 | 16.28005034913678 | =SUM($H$3:H75) |
| J75 | ||
| K75 | ||
| L75 | ||
| M75 | ||
| N75 | ||
| O75 | ||
| P75 | ||
| Q75 | 1.3995024433777525 | ='event calc table'!C75 |
| R75 | #REF! | =+IF(Q75<=0.2#REF!$C$29,0,(Q75-0.2#REF!$C$29)^2/(Q75+0.8*#REF!$C$29)) |
| S75 | Q for P>1.25 is also calculated based on modified CN but it doesn't matter because pond is assumed full and Q is not used anyway | |
| A76 | 74 | |
| B76 | 3.140605053690771 | |
| C76 | 1.5012092156641885 | =+Pavg*B76/100 |
| D76 | 1.2814126821244443 | =+IF(C76<0.0408,0,IF(C76<1.25,0.855(C76-0.0408),(C76-0.20.204)^2/(C76+0.8*0.204))) |
| E76 | 5.179003184432713 | =+MIN(D76/Aratio,dBMP) |
| F76 | 0 | =+MAX('BMP Calculations'!$G$6-E76,0) |
| G76 | 4.444000750886478 | =+MAX(E76-RERWC,0) |
| H76 | 0.45269771958831345 | =+G76*Aratio |
| I76 | 16.732748068725094 | =SUM($H$3:H76) |
| J76 | ||
| K76 | ||
| L76 | ||
| M76 | ||
| N76 | ||
| O76 | ||
| P76 | ||
| Q76 | 1.5012092156641885 | ='event calc table'!C76 |
| R76 | #REF! | =+IF(Q76<=0.2#REF!$C$29,0,(Q76-0.2#REF!$C$29)^2/(Q76+0.8*#REF!$C$29)) |
| S76 | ||
| A77 | 75 | |
| B77 | 3.4009630547420597 | |
| C77 | 1.6256603401667045 | =+Pavg*B77/100 |
| D77 | 1.4041243139189101 | =+IF(C77<0.0408,0,IF(C77<1.25,0.855(C77-0.0408),(C77-0.20.204)^2/(C77+0.8*0.204))) |
| E77 | 5.179003184432713 | =+MIN(D77/Aratio,dBMP) |
| F77 | 0 | =+MAX('BMP Calculations'!$G$6-E77,0) |
| G77 | 4.444000750886478 | =+MAX(E77-RERWC,0) |
| H77 | 0.45269771958831345 | =+G77*Aratio |
| I77 | 17.18544578831341 | =SUM($H$3:H77) |
| J77 | ||
| K77 | ||
| L77 | ||
| M77 | ||
| N77 | ||
| O77 | ||
| P77 | ||
| Q77 | 1.6256603401667045 | ='event calc table'!C77 |
| R77 | #REF! | =+IF(Q77<=0.2#REF!$C$29,0,(Q77-0.2#REF!$C$29)^2/(Q77+0.8*#REF!$C$29)) |
| S77 | ||
| A78 | 76 | |
| B78 | 3.740984448738166 | |
| C78 | 1.7881905664968432 | =+Pavg*B78/100 |
| D78 | 1.564716896917057 | =+IF(C78<0.0408,0,IF(C78<1.25,0.855(C78-0.0408),(C78-0.20.204)^2/(C78+0.8*0.204))) |
| E78 | 5.179003184432713 | =+MIN(D78/Aratio,dBMP) |
| F78 | 0 | =+MAX('BMP Calculations'!$G$6-E78,0) |
| G78 | 4.444000750886478 | =+MAX(E78-RERWC,0) |
| H78 | 0.45269771958831345 | =+G78*Aratio |
| I78 | 17.638143507901724 | =SUM($H$3:H78) |
| J78 | ||
| K78 | ||
| L78 | ||
| M78 | ||
| N78 | ||
| O78 | ||
| P78 | ||
| Q78 | 1.7881905664968432 | ='event calc table'!C78 |
| R78 | #REF! | =+IF(Q78<=0.2#REF!$C$29,0,(Q78-0.2#REF!$C$29)^2/(Q78+0.8*#REF!$C$29)) |
| S78 | ||
| A79 | 77 | |
| B79 | 4.222484743329812 | |
| C79 | 2.0183477073116496 | =+Pavg*B79/100 |
| D79 | 1.792624072160569 | =+IF(C79<0.0408,0,IF(C79<1.25,0.855(C79-0.0408),(C79-0.20.204)^2/(C79+0.8*0.204))) |
| E79 | 5.179003184432713 | =+MIN(D79/Aratio,dBMP) |
| F79 | 0 | =+MAX('BMP Calculations'!$G$6-E79,0) |
| G79 | 4.444000750886478 | =+MAX(E79-RERWC,0) |
| H79 | 0.45269771958831345 | =+G79*Aratio |
| I79 | 18.09084122749004 | =SUM($H$3:H79) |
| J79 | ||
| K79 | ||
| L79 | ||
| M79 | ||
| N79 | ||
| O79 | ||
| P79 | ||
| Q79 | 2.0183477073116496 | ='event calc table'!C79 |
| R79 | #REF! | =+IF(Q79<=0.2#REF!$C$29,0,(Q79-0.2#REF!$C$29)^2/(Q79+0.8*#REF!$C$29)) |
| S79 | ||
| A80 | 78 | |
| B80 | 4.9383135567031164 | |
| C80 | 2.3605138801040892 | =+Pavg*B80/100 |
| D80 | 2.1322038635083427 | =+IF(C80<0.0408,0,IF(C80<1.25,0.855(C80-0.0408),(C80-0.20.204)^2/(C80+0.8*0.204))) |
| E80 | 5.179003184432713 | =+MIN(D80/Aratio,dBMP) |
| F80 | 0 | =+MAX('BMP Calculations'!$G$6-E80,0) |
| G80 | 4.444000750886478 | =+MAX(E80-RERWC,0) |
| H80 | 0.45269771958831345 | =+G80*Aratio |
| I80 | 18.543538947078353 | =SUM($H$3:H80) |
| J80 | ||
| K80 | ||
| L80 | ||
| M80 | ||
| N80 | ||
| O80 | ||
| P80 | ||
| Q80 | 2.3605138801040892 | ='event calc table'!C80 |
| R80 | #REF! | =+IF(Q80<=0.2#REF!$C$29,0,(Q80-0.2#REF!$C$29)^2/(Q80+0.8*#REF!$C$29)) |
| S80 | ||
| A81 | 79 | |
| B81 | 6.692049924619196 | |
| C81 | 3.1987998639679756 | =+Pavg*B81/100 |
| D81 | 2.966378210691311 | =+IF(C81<0.0408,0,IF(C81<1.25,0.855(C81-0.0408),(C81-0.20.204)^2/(C81+0.8*0.204))) |
| E81 | 5.179003184432713 | =+MIN(D81/Aratio,dBMP) |
| F81 | 0 | =+MAX('BMP Calculations'!$G$6-E81,0) |
| G81 | 4.444000750886478 | =+MAX(E81-RERWC,0) |
| H81 | 0.45269771958831345 | =+G81*Aratio |
| I81 | 18.996236666666668 | =SUM($H$3:H81) |
| J81 | ||
| K81 | ||
| L81 | ||
| M81 | 18.99623666666666 | =+dr |
| N81 | 0.5397002023064793 | =+Qdesign |
| O81 | ||
| P81 | ||
| Q81 | 3.1987998639679756 | ='event calc table'!C81 |
| R81 | #REF! | =+IF(Q81<=0.2#REF!$C$29,0,(Q81-0.2#REF!$C$29)^2/(Q81+0.8*#REF!$C$29)) |
| S81 | ||
| A82 | ||
| B82 | ||
| C82 | ||
| D82 | ||
| E82 | ||
| F82 | ||
| G82 | ||
| H82 | ||
| I82 | ||
| J82 | ||
| K82 | ||
| L82 | ||
| M82 | ||
| N82 | ||
| O82 | ||
| P82 | ||
| Q82 | ||
| R82 | ||
| S82 | ||
| A83 | Avg= | |
| B83 | ||
| C83 | 0.5845018043281209 | =AVERAGE(C3:C81) |
| D83 | 0.47370278500149415 | =AVERAGE(D3:D81) |
| E83 | 3.078556851218973 | =AVERAGE(E3:E81) |
| F83 | 0.0419514398022259 | =AVERAGE(F3:F81) |
| G83 | 2.3605124600626834 | =AVERAGE(G3:G81) |
| H83 | 0.2404586919831224 | =AVERAGE(H3:H81) |
| I83 | ||
| J83 | ||
| K83 | ||
| L83 | ||
| M83 | ||
| N83 | ||
| O83 | ||
| P83 | ||
| Q83 | ||
| R83 | ||
| S83 | ||
| A84 | Sum= | |
| B84 | ||
| C84 | 46.175642541921555 | =SUM(C3:C81) |
| D84 | 37.42252001511804 | =SUM(D3:D81) |
| E84 | 243.20599124629888 | =SUM(E3:E81) |
| F84 | 3.314163744375846 | =SUM(F3:F81) |
| G84 | 186.48048434495198 | =SUM(G3:G81) |
| H84 | 18.996236666666668 | =SUM(H3:H81) |
| I84 | ||
| J84 | ||
| K84 | ||
| L84 | ||
| M84 | ||
| N84 | ||
| O84 | ||
| P84 | ||
| Q84 | ||
| R84 | ||
| S84 | ||
| A85 | ||
| B85 | ||
| C85 | ||
| D85 | ||
| E85 | ||
| F85 | ||
| G85 | ||
| H85 | ||
| I85 | ||
| J85 | ||
| K85 | ||
| L85 | ||
| M85 | ||
| N85 | ||
| O85 | ||
| P85 | ||
| Q85 | ||
| R85 | ||
| S85 | ||
| A86 | ||
| B86 | ||
| C86 | ||
| D86 | ||
| E86 | ||
| F86 | ||
| G86 | ||
| H86 | ||
| I86 | ||
| J86 | ||
| K86 | ||
| L86 | ||
| M86 | ||
| N86 | ||
| O86 | ||
| P86 | ||
| Q86 | ||
| R86 | ||
| S86 | ||
| A87 | ||
| B87 | ||
| C87 | ||
| D87 | ||
| E87 | ||
| F87 | ||
| G87 | ||
| H87 | ||
| I87 | ||
| J87 | ||
| K87 | ||
| L87 | ||
| M87 | ||
| N87 | ||
| O87 | ||
| P87 | ||
| Q87 | ||
| R87 | ||
| S87 | ||
| A88 | ||
| B88 | ||
| C88 | ||
| D88 | ||
| E88 | ||
| F88 | ||
| G88 | ||
| H88 | ||
| I88 | ||
| J88 | ||
| K88 | ||
| L88 | ||
| M88 | ||
| N88 | ||
| O88 | ||
| P88 | ||
| Q88 | ||
| R88 | ||
| S88 | ||
| A89 | ||
| B89 | ||
| C89 | ||
| D89 | ||
| E89 | ||
| F89 | ||
| G89 | ||
| H89 | ||
| I89 | ||
| J89 | ||
| K89 | ||
| L89 | ||
| M89 | ||
| N89 | ||
| O89 | ||
| P89 | ||
| Q89 | ||
| R89 | ||
| S89 | ||
| A90 | ||
| B90 | ||
| C90 | ||
| D90 | ||
| E90 | ||
| F90 | ||
| G90 | ||
| H90 | ||
| I90 | ||
| J90 | ||
| K90 | ||
| L90 | ||
| M90 | ||
| N90 | ||
| O90 | ||
| P90 | ||
| Q90 | ||
| R90 | ||
| S90 | ||
| A91 | ||
| B91 | ||
| C91 | ||
| D91 | ||
| E91 | ||
| F91 | ||
| G91 | ||
| H91 | ||
| I91 | ||
| J91 | ||
| K91 | ||
| L91 | ||
| M91 | ||
| N91 | ||
| O91 | ||
| P91 | ||
| Q91 | ||
| R91 | ||
| S91 | ||
| A92 | ||
| B92 | ||
| C92 | ||
| D92 | ||
| E92 | ||
| F92 | ||
| G92 | ||
| H92 | ||
| I92 | ||
| J92 | ||
| K92 | ||
| L92 | ||
| M92 | ||
| N92 | ||
| O92 | ||
| P92 | ||
| Q92 | ||
| R92 | ||
| S92 | ||
| A93 | ||
| B93 | ||
| C93 | ||
| D93 | ||
| E93 | ||
| F93 | ||
| G93 | ||
| H93 | ||
| I93 | ||
| J93 | ||
| K93 | ||
| L93 | ||
| M93 | ||
| N93 | ||
| O93 | ||
| P93 | ||
| Q93 | ||
| R93 | ||
| S93 | ||
| A94 | ||
| B94 | ||
| C94 | ||
| D94 | ||
| E94 | ||
| F94 | ||
| G94 | ||
| H94 | ||
| I94 | ||
| J94 | ||
| K94 | ||
| L94 | ||
| M94 | ||
| N94 | ||
| O94 | ||
| P94 | ||
| Q94 | ||
| R94 | ||
| S94 | ||
| A95 | ||
| B95 | ||
| C95 | ||
| D95 | ||
| E95 | ||
| F95 | ||
| G95 | ||
| H95 | ||
| I95 | ||
| J95 | ||
| K95 | ||
| L95 | ||
| M95 | ||
| N95 | ||
| O95 | ||
| P95 | ||
| Q95 | ||
| R95 | ||
| S95 | ||
| A96 | ||
| B96 | ||
| C96 | ||
| D96 | ||
| E96 | ||
| F96 | ||
| G96 | ||
| H96 | ||
| I96 | ||
| J96 | ||
| K96 | ||
| L96 | ||
| M96 | ||
| N96 | ||
| O96 | ||
| P96 | ||
| Q96 | ||
| R96 | ||
| S96 | ||
| A97 | ||
| B97 | ||
| C97 | ||
| D97 | ||
| E97 | ||
| F97 | ||
| G97 | ||
| H97 | ||
| I97 | ||
| J97 | ||
| K97 | ||
| L97 | ||
| M97 | ||
| N97 | ||
| O97 | ||
| P97 | ||
| Q97 | ||
| R97 | ||
| S97 | ||
| A98 | ||
| B98 | ||
| C98 | ||
| D98 | ||
| E98 | ||
| F98 | ||
| G98 | ||
| H98 | ||
| I98 | ||
| J98 | ||
| K98 | ||
| L98 | ||
| M98 | ||
| N98 | ||
| O98 | ||
| P98 | ||
| Q98 | ||
| R98 | ||
| S98 | ||
| A99 | ||
| B99 | ||
| C99 | ||
| D99 | ||
| E99 | ||
| F99 | ||
| G99 | ||
| H99 | ||
| I99 | ||
| J99 | ||
| K99 | ||
| L99 | ||
| M99 | ||
| N99 | ||
| O99 | ||
| P99 | ||
| Q99 | ||
| R99 | ||
| S99 | ||
| A100 | ||
| B100 | ||
| C100 | ||
| D100 | ||
| E100 | ||
| F100 | ||
| G100 | ||
| H100 | ||
| I100 | ||
| J100 | ||
| K100 | ||
| L100 | ||
| M100 | ||
| N100 | ||
| O100 | ||
| P100 | ||
| Q100 | ||
| R100 | ||
| S100 | ||
| A101 | ||
| B101 | ||
| C101 | ||
| D101 | ||
| E101 | ||
| F101 | ||
| G101 | ||
| H101 | ||
| I101 | ||
| J101 | ||
| K101 | ||
| L101 | ||
| M101 | ||
| N101 | ||
| O101 | ||
| P101 | ||
| Q101 | ||
| R101 | ||
| S101 | ||
| A102 | ||
| B102 | ||
| C102 | ||
| D102 | ||
| E102 | ||
| F102 | ||
| G102 | ||
| H102 | ||
| I102 | ||
| J102 | ||
| K102 | ||
| L102 | ||
| M102 | ||
| N102 | ||
| O102 | ||
| P102 | ||
| Q102 | ||
| R102 | ||
| S102 | ||
| A103 | ||
| B103 | ||
| C103 | ||
| D103 | ||
| E103 | ||
| F103 | ||
| G103 | ||
| H103 | ||
| I103 | ||
| J103 | ||
| K103 | ||
| L103 | ||
| M103 | ||
| N103 | ||
| O103 | ||
| P103 | ||
| Q103 | ||
| R103 | ||
| S103 | ||
| A104 | ||
| B104 | ||
| C104 | ||
| D104 | ||
| E104 | ||
| F104 | ||
| G104 | ||
| H104 | ||
| I104 | ||
| J104 | ||
| K104 | ||
| L104 | ||
| M104 | ||
| N104 | ||
| O104 | ||
| P104 | ||
| Q104 | ||
| R104 | ||
| S104 | ||
| A105 | ||
| B105 | ||
| C105 | ||
| D105 | ||
| E105 | ||
| F105 | ||
| G105 | ||
| H105 | ||
| I105 | ||
| J105 | ||
| K105 | ||
| L105 | ||
| M105 | ||
| N105 | ||
| O105 | ||
| P105 | ||
| Q105 | ||
| R105 | ||
| S105 | ||
| A106 | ||
| B106 | ||
| C106 | ||
| D106 | ||
| E106 | ||
| F106 | ||
| G106 | ||
| H106 | ||
| I106 | ||
| J106 | ||
| K106 | ||
| L106 | ||
| M106 | ||
| N106 | ||
| O106 | ||
| P106 | ||
| Q106 | ||
| R106 | ||
| S106 | ||
| A107 | ||
| B107 | ||
| C107 | ||
| D107 | ||
| E107 | ||
| F107 | ||
| G107 | ||
| H107 | ||
| I107 | ||
| J107 | ||
| K107 | ||
| L107 | ||
| M107 | ||
| N107 | ||
| O107 | ||
| P107 | ||
| Q107 | ||
| R107 | ||
| S107 | ||
| A108 | ||
| B108 | ||
| C108 | ||
| D108 | ||
| E108 | ||
| F108 | ||
| G108 | ||
| H108 | ||
| I108 | ||
| J108 | ||
| K108 | ||
| L108 | ||
| M108 | ||
| N108 | ||
| O108 | ||
| P108 | ||
| Q108 | ||
| R108 | ||
| S108 | ||
| A109 | ||
| B109 | ||
| C109 | ||
| D109 | ||
| E109 | ||
| F109 | ||
| G109 | ||
| H109 | ||
| I109 | ||
| J109 | ||
| K109 | ||
| L109 | ||
| M109 | ||
| N109 | ||
| O109 | ||
| P109 | ||
| Q109 | ||
| R109 | ||
| S109 | ||
| A110 | ||
| B110 | ||
| C110 | ||
| D110 | ||
| E110 | ||
| F110 | ||
| G110 | ||
| H110 | ||
| I110 | ||
| J110 | ||
| K110 | ||
| L110 | ||
| M110 | ||
| N110 | ||
| O110 | ||
| P110 | ||
| Q110 | ||
| R110 | ||
| S110 | ||
| A111 | ||
| B111 | ||
| C111 | ||
| D111 | ||
| E111 | ||
| F111 | ||
| G111 | ||
| H111 | ||
| I111 | ||
| J111 | ||
| K111 | ||
| L111 | ||
| M111 | ||
| N111 | ||
| O111 | ||
| P111 | ||
| Q111 | ||
| R111 | ||
| S111 | ||
| A112 | ||
| B112 | ||
| C112 | ||
| D112 | ||
| E112 | ||
| F112 | ||
| G112 | ||
| H112 | ||
| I112 | ||
| J112 | ||
| K112 | ||
| L112 | ||
| M112 | ||
| N112 | ||
| O112 | ||
| P112 | ||
| Q112 | ||
| R112 | ||
| S112 | ||
| A113 | ||
| B113 | ||
| C113 | ||
| D113 | ||
| E113 | ||
| F113 | ||
| G113 | ||
| H113 | ||
| I113 | ||
| J113 | ||
| K113 | ||
| L113 | ||
| M113 | ||
| N113 | ||
| O113 | ||
| P113 | ||
| Q113 | ||
| R113 | ||
| S113 | ||
| A114 | ||
| B114 | ||
| C114 | ||
| D114 | ||
| E114 | ||
| F114 | ||
| G114 | ||
| H114 | ||
| I114 | ||
| J114 | ||
| K114 | ||
| L114 | ||
| M114 | ||
| N114 | ||
| O114 | ||
| P114 | ||
| Q114 | ||
| R114 | ||
| S114 | ||
| A115 | ||
| B115 | ||
| C115 | ||
| D115 | ||
| E115 | ||
| F115 | ||
| G115 | ||
| H115 | ||
| I115 | ||
| J115 | ||
| K115 | ||
| L115 | ||
| M115 | ||
| N115 | ||
| O115 | ||
| P115 | ||
| Q115 | ||
| R115 | ||
| S115 |