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.


Content Rating

Is this a good/useful/informative piece of content to include in the project? Have your say!