Worksheet Formulas
Cell | Formula |
---|
V4 | =U4 |
---|
W4 | =TEXT(V4,"[$-409]GGGG") |
---|
V5 | =V4+1 |
---|
W5 | =TEXT(V5,"[$-409]GGGG") |
---|
V6 | =V5+1 |
---|
W6 | =TEXT(V6,"[$-409]GGGG") |
---|
V7 | =V6+1 |
---|
W7 | =TEXT(V7,"[$-409]GGGG") |
---|
V8 | =V7+1 |
---|
W8 | =TEXT(V8,"[$-409]GGGG") |
---|
V9 | =V8+1 |
---|
W9 | =TEXT(V9,"[$-409]GGGG") |
---|
V10 | =V9+1 |
---|
W10 | =TEXT(V10,"[$-409]GGGG") |
---|
V11 | =V10+1 |
---|
W11 | =TEXT(V11,"[$-409]GGGG") |
---|
V12 | =V11+1 |
---|
W12 | =TEXT(V12,"[$-409]GGGG") |
---|
V13 | =V12+1 |
---|
W13 | =TEXT(V13,"[$-409]GGGG") |
---|
V14 | =V13+1 |
---|
W14 | =TEXT(V14,"[$-409]GGGG") |
---|
V15 | =V14+1 |
---|
W15 | =TEXT(V15,"[$-409]GGGG") |
---|
V16 | =V15+1 |
---|
W16 | =TEXT(V16,"[$-409]GGGG") |
---|
V17 | =V16+1 |
---|
W17 | =TEXT(V17,"[$-409]GGGG") |
---|
V18 | =V17+1 |
---|
W18 | =TEXT(V18,"[$-409]GGGG") |
---|
V19 | =V18+1 |
---|
W19 | =TEXT(V19,"[$-409]GGGG") |
---|
V20 | =V19+1 |
---|
W20 | =TEXT(V20,"[$-409]GGGG") |
---|
V21 | =V20+1 |
---|
W21 | =TEXT(V21,"[$-409]GGGG") |
---|
V22 | =V21+1 |
---|
W22 | =TEXT(V22,"[$-409]GGGG") |
---|
V23 | =V22+1 |
---|
W23 | =TEXT(V23,"[$-409]GGGG") |
---|
V24 | =V23+1 |
---|
W24 | =TEXT(V24,"[$-409]GGGG") |
---|
V25 | =V24+1 |
---|
W25 | =TEXT(V25,"[$-409]GGGG") |
---|
V26 | =V25+1 |
---|
W26 | =TEXT(V26,"[$-409]GGGG") |
---|
V27 | =V26+1 |
---|
W27 | =TEXT(V27,"[$-409]GGGG") |
---|
V28 | =V27+1 |
---|
W28 | =TEXT(V28,"[$-409]GGGG") |
---|
V29 | =V28+1 |
---|
W29 | =TEXT(V29,"[$-409]GGGG") |
---|
V30 | =V29+1 |
---|
W30 | =TEXT(V30,"[$-409]GGGG") |
---|
V31 | =IF(EOMONTH($B$4,0)<(V30+1),"",(V30+1)) |
---|
W31 | =TEXT(V31,"[$-409]GGGG") |
---|
V32 | =IF(EOMONTH($B$4,0)<(V30+2),"",(V30+2)) |
---|
W32 | =TEXT(V32,"[$-409]GGGG") |
---|
V33 | =IF(EOMONTH($B$4,0)<(V30+3),"",(V30+3)) |
---|
W33 | =TEXT(V33,"[$-409]GGGG") |
---|
V34 | =IF(EOMONTH($B$4,0)<(V30+4),"",(V30+4)) |
---|
W34 | =TEXT(V34,"[$-409]GGGG") |
---|
AA11 | =AVERAGE(X4:X34) |
---|
Z14 | =INDEX($Z$4:$Z$10,MATCH(AA14,$AA$4:$AA$10,0)) |
---|
AA14 | =LARGE($AA$4:$AA$10,1) |
---|
Z15 | =INDEX($Z$4:$Z$10,MATCH(AA15,$AA$4:$AA$10,0)) |
---|
AA15 | =LARGE($AA$4:$AA$10,2) |
---|
Z16 | =INDEX($Z$4:$Z$10,MATCH(AA16,$AA$4:$AA$10,0)) |
---|
AA16 | =LARGE($AA$4:$AA$10,3) |
---|
Z17 | =INDEX($Z$4:$Z$10,MATCH(AA17,$AA$4:$AA$10,0)) |
---|
AA17 | =LARGE($AA$4:$AA$10,4) |
---|
Z18 | =INDEX($Z$4:$Z$10,MATCH(AA18,$AA$4:$AA$10,0)) |
---|
AA18 | =LARGE($AA$4:$AA$10,5) |
---|
Z19 | =INDEX($Z$4:$Z$10,MATCH(AA19,$AA$4:$AA$10,0)) |
---|
AA19 | =LARGE($AA$4:$AA$10,6) |
---|
Z20 | =INDEX($Z$4:$Z$10,MATCH(AA20,$AA$4:$AA$10,0)) |
---|
AA20 | =LARGE($AA$4:$AA$10,7) |
---|
AA21 | =AVERAGE(X4:X34) |
---|
<thead>
</thead><tbody>
</tbody> |