What does the rolling average section of the analysis show?
‘Rolling average’ is defined as the 3 month rolling average of daily total activity (credits+debits), this generates 3 (‘X') values for each month (where that month is in order number 1, number 2, number 3 of each rolling average calculation) ‘Distance to rolling average’ is defined as the difference between one day's total activity (credits+debits) and the ‘rolling average’, which uses the largest difference (when the daily total is compared to each ‘X’ value from above).
Recent Posts
See AllRevisited starter script from January 2021: Split Excel file into separate files Excel is essential, and Python is the future - forcing...