Back to Parent
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.
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.
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.