Closed

excel spreadsheet for landscape construction job costing

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.

Skills: Data Processing, Excel

See more: job costing spreadsheet excel, job costing spreadsheet, job costing excel, construction job costing spreadsheet, job costing excel spreadsheet, excel job costing, construction job costing excel, excel spreadsheet job costing, construction job spreadsheet, spreadsheet track construction jobs, simple job costing spreadsheet, job cost excel spreadsheet, landscape costing sheet, excel job cost spreadsheet, job costing sheet excel, construction job cost spreadsheet, excel landscape job costs, spreadsheet track job cost, landscape job costing excel, construction job tracking spreadsheet, landscape employee job costing, construction jobs spreadsheet, construction sheet excel, landscape costing excel, spreadsheet track laborer

About the Employer:
( 0 reviews ) San Diego, United States

Project ID: #2581735

18 freelancers are bidding on average $88 for this job

jeweljitu

****Letz start..... Low price .....Immediate start........ Check PMB.****

$60 USD in 3 days
(53 Reviews)
5.3
sonarkaushik

Sir, I can do the project. Refer PMB. with regards

$55 USD in 3 days
(21 Reviews)
5.2
LUretsky

I am a career accountant with 20 years of payroll and 15 years of excel experience.

$250 USD in 7 days
(12 Reviews)
4.6
redsentra

Hi, Excel VBA and data processing expert here ready to support. Refer PM for details.

$60 USD in 5 days
(16 Reviews)
4.2
domwakeling

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

$50 USD in 2 days
(11 Reviews)
3.7
vikashgadia

we r excel macro expert .....

$150 USD in 1 day
(13 Reviews)
3.5
ExtraNet

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.

$50 USD in 2 days
(5 Reviews)
3.3
sumshank

Thanks for your time in reading my bid. Here is what I can offer: - Excellent MS Excel skills, having used it extensively during my work with the Information Technology industry. - My Excel work includes usage of More

$100 USD in 10 days
(3 Reviews)
2.4
wha666

It seem like a simple process. More then happy to help. I work in the construction industry as an analyst.

$30 USD in 1 day
(0 Reviews)
0.0
Tetyana1235

Building spreadsheets, workbooks, templates, manipulating data in Excel is my every day work. I am a Database Coordinator.

$100 USD in 3 days
(0 Reviews)
0.0
bhigdon

I can get this to you in one day.

$60 USD in 1 day
(0 Reviews)
0.0
rahulharkisanka

I have done enough prior work in excel and with macros to know this does not take more than 5-6 hours, so charging accordingly.

$50 USD in 1 day
(0 Reviews)
0.0
kcarsle

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.

$50 USD in 5 days
(0 Reviews)
0.0
Flux8

I'm interested in completing this project for you. I'm very skilled in Microsoft Excel and VBA. I've developed spreadsheets and forms for several companies, including the U.S. Air Force. I will make your form effect More

$60 USD in 5 days
(0 Reviews)
0.0
rakeshmaurya1980

Hi - I am a VBA programmer and make a project as per your requirement. Please see private message for detail. Rakesh

$100 USD in 7 days
(0 Reviews)
0.0
skendertopilla

Fast, Reliable, Accurate, Trustworthy Hi, we can create this Excel file for you in a very sophisticated way, but we would propose that you have one in MS Access,, because in that way we can create all the spreadshee More

$150 USD in 4 days
(0 Reviews)
0.0
expertssphp

Lets get started........

$50 USD in 2 days
(0 Reviews)
0.0
bukolaadeosun

Hi there, what you want looks like a time sheet that can be used to automatically calculate how many hours worked and the cost on daily basis. I can design a time sheet with summary page showing total hours work by emp More

$150 USD in 5 days
(0 Reviews)
0.0