Extract timesheet data from spreadsheet and display graphically by employee in following formats.
Day/week/month by employee in calendar format
Day/week/month by employee in piechart format
Day/week/month by employee in tracking format
I have attached a copy of the raw spreadsheet "Timesheet all staff unsorted" in 1st tab of attached spreadsheet and a representation of how the finished spreadsheet should look for 1 staff member based on the data from the raw spreadsheet.
I need a talented Excel expert to turn this into a reality , there will be ongoing work as I need other information sorted for other purposes.
I am based in Adelaide Australia and am only interested in working with an individual who keeps roughly the same timezone (GMT +8.5) so that there can be realtime communication.