I need an Excel spreadsheet to track labor costs for my landscape construction company. I have not been able to find a spreadsheet that will do what I want it to do.
I want a sheet that I can print out for my supervisors to fill out or input information into the spreadsheet for data tracking.
I have a simple sketch of the layout but can't figure out how to build the spreadsheet. I need one page for each of my foreman. They will fill in information at the end of every day. I want the page to track one week monday-friday. I need to display: job name, hrs worked in category (demo, hardscape, masonry, planting, other) I want the one page to track up to 5 employees with 4 lines for each employee each day. This way I can track what each laborer is doing and accurately figure my job cost, both for the job name total labor cost and for the labor cost for each individual category. I can't figure out if I can set up the spreadsheet to total by job name first then by category. I plan on inputting the data that my foreman puts on the sheet and hands in weekly. So I want to be able to print the sheet for my foreman to fill out and for the sheet to calculate total hours for each project and each category.
If possible I would like to copy the weekly sheet to make a workbook displaying each month with totals for jobs and catagories for each job.
Please email me to discuss the details.
18 freelancers are bidding on average $88 for this job
Expert in MS Excel, I also have 15+ years experience in cost-management within construction (UK). I would be delighted to support you in this project. Regards Dom
The requirements you provide can all be automated using basic Excel functionality, including partial sums and copying data elsewhere. Do provide your outline and let's get this done.
Hello, Please consider me for this project. I am attaching a spreadsheet that I believe captures your idea. If this is what you are looking for, I can automate it and make any adjustments that you require.