Comprehensive Daily, Weekly and Monthly Timesheet and job Cost Calculator
Budget: $30 – $250 AUD
I am seeking a proficient Microsoft Excel specialist to design a sophisticated project tracking spreadsheet utilizing daily timesheets for each day of the week (Monday to Sunday). The candidate should have:
- Solid experience with Excel or similar software.
- Understanding of timesheet creation and cost calculation.
- Ability to incorporate graphical data representations.
The scope of the task includes:
- Creating one consolidated timesheet for monthly invoicing
- i will also need to include material (costs if any) towards each individual job
- in the timesheet example attached are job codes created for the each job the client has given me
- i will also need the ability to print the daily timesheets and onsite equipment to be signed by the client
- Developing a summary page to automatically calculate personnel hours cost at a standard rate towards each job.
- Implementing a graphical representation of the weekly and monthly costs.
Ideal candidates should come with excellent communication skills to ensure smooth and clear dialogues throughout the process. A keen eye for detail to cross-check and validate data is also paramount for the successful completion of this project.
- Solid experience with Excel or similar software.
- Understanding of timesheet creation and cost calculation.
- Ability to incorporate graphical data representations.
The scope of the task includes:
- Creating one consolidated timesheet for monthly invoicing
- i will also need to include material (costs if any) towards each individual job
- in the timesheet example attached are job codes created for the each job the client has given me
- i will also need the ability to print the daily timesheets and onsite equipment to be signed by the client
- Developing a summary page to automatically calculate personnel hours cost at a standard rate towards each job.
- Implementing a graphical representation of the weekly and monthly costs.
Ideal candidates should come with excellent communication skills to ensure smooth and clear dialogues throughout the process. A keen eye for detail to cross-check and validate data is also paramount for the successful completion of this project.