
Construction cost estimating spreadsheet
5155
$$
- Posted:
- Proposals: 6
- Remote
- #140570
- Archived
Full Stack Developer : WordPress | Shopify | Next.js | Nuxt.js | RN ( Mobile App Development)

22708779625271611292575288151304564
Description
Experience Level: Intermediate
I would like to have a cost estimating spreadsheet for construction work in excel. The spreadsheet should have a project info sheet, a data entry sheet and there should be a function for reporting the data.
Data entry:
The structure for the estimate is given and it is in Estonian (hope it is not a problem). The user finds a place in the structure and adds an activity to a subgroup. Then enters the volume and unit for the activity. Each activity has different costs (work, materials, rented equipment, etc.). Now the user adds costs the the activity and enters the type of cost, cost per unit, unit of measurement of the cost and the price of a unit. And excel calculates the total prices.
I have 2 buttons - one for entering activities and the second for entering costs. But I think it would be userfriendlier if next to every activity and next to every subgroup there would be a button for adding rows under them.
Also every row has to have a code.
The reports:
It should enable to report the data in any possible way. Maingroup, group, subgroup, activity, cost; type of cost; with or without blank rows; With or without prices. A graph or a pie diagram for percentages of the total project for the types of costs. Price per m2.
The project info sheet:
Name of the project, start and finish dates, VAT %, Profit %, currency, m2, m3,
Please do ask if you have questions!
Data entry:
The structure for the estimate is given and it is in Estonian (hope it is not a problem). The user finds a place in the structure and adds an activity to a subgroup. Then enters the volume and unit for the activity. Each activity has different costs (work, materials, rented equipment, etc.). Now the user adds costs the the activity and enters the type of cost, cost per unit, unit of measurement of the cost and the price of a unit. And excel calculates the total prices.
I have 2 buttons - one for entering activities and the second for entering costs. But I think it would be userfriendlier if next to every activity and next to every subgroup there would be a button for adding rows under them.
Also every row has to have a code.
The reports:
It should enable to report the data in any possible way. Maingroup, group, subgroup, activity, cost; type of cost; with or without blank rows; With or without prices. A graph or a pie diagram for percentages of the total project for the types of costs. Price per m2.
The project info sheet:
Name of the project, start and finish dates, VAT %, Profit %, currency, m2, m3,
Please do ask if you have questions!
Ivo L.
100% (1)Projects Completed
2
Freelancers worked with
2
Projects awarded
100%
Last project
10 Jun 2017
Estonia
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies