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.

=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!

0