The Logic behind the water level.
We use google sheets to aggregate the daily spending data. A running average column, computes the average spending of the previous 7 days.
Every daily avg spending value is rated on a 10 point scale. IF statements are used to cap the max and min values of the rating.
=IF((DailySpending!A9-10)>10,10,IF((DailySpending!A9-10)<0,0,DailySpending!A9-10))
The resultant values on the 10 point scale, are inverted to correspond to the water level. A high spending rating of 9, will result in a water level of 1.
=10-AvgSpendingScaled!A8
Content Rating
Is this a good/useful/informative piece of content to include in the project? Have your say!
You must login before you can post a comment. .