In the new script, you calculate AVERAGEDU by using (DU1+DU2+DU3)/3 (3 days), but AVERAGEGAIN still by using (GAIN1+GAIN2+GAIN3+GAIN4+GAIN5)/5 (5 days). Why?
As we move into the summer months, seasonal volatility changes occur. As a result, I felt using the last three months volume numbers had a greater impact on Dry Up (DU) calculations vs volume which occurred six months ago. I neglected to note this change in the chartscript description. I appreciate you pointing it out. The GAIN variable applies more to rank than Dry Up. We still need a minimum five cycles in six months. As such, I did not alter the AVERAGEGAIN formula.
Related Questions
- In the new script, you calculate AVERAGEDU by using (DU1+DU2+DU3)/3 (3 days), but AVERAGEGAIN still by using (GAIN1+GAIN2+GAIN3+GAIN4+GAIN5)/5 (5 days). Why?
- If I know the days and hours a member worked, can I calculate service credit on the method which provides the highest credit?
- How can I get Word to automatically calculate dates (i.e. 7 days from today?
