Hi,
This may be a long winded question.....
In the attached picture, I am trying to work out the average frequency of a route I have driven this year in percentage. I have blacked out the routes themselves, so lets go by the row numbers in Excel. So rows 8 and 9 have an overall percentage driven of 8.64% and 5.76%. However lets just say that row 9 was last driven a couple of months ago, whereas row 8 was driven yesterday. How can I get a percentage in the right hand side to show how frequent or not so frequent each year the route is that has been driven? So something like the percentage will lower each day, and then when it gets driven again, the percentage will raise once again, continuing in that cycle.
Thank you and sorry if it is confusing or doesn't make much sense.
This may be a long winded question.....
In the attached picture, I am trying to work out the average frequency of a route I have driven this year in percentage. I have blacked out the routes themselves, so lets go by the row numbers in Excel. So rows 8 and 9 have an overall percentage driven of 8.64% and 5.76%. However lets just say that row 9 was last driven a couple of months ago, whereas row 8 was driven yesterday. How can I get a percentage in the right hand side to show how frequent or not so frequent each year the route is that has been driven? So something like the percentage will lower each day, and then when it gets driven again, the percentage will raise once again, continuing in that cycle.
Thank you and sorry if it is confusing or doesn't make much sense.