Unfortunately the columns got lost on pasting. I used row A for column headings.
A - day
B - date
C - daily rate
D - week no.
E - weekly rate
F - month
G - monthly rate