Fully Automated Building Cost Estimator Excel
Budget: $750 – $1,500 AUD
I'm looking for a skilled Excel expert to create a fully automated spreadsheet for building cost estimation. The spreadsheet should be user-friendly and capable of generating a detailed, summary-level, and client report. The name of this automated spreadsheet to be finalised.
Key Features:
- Material and Labor Cost Calculation: The spreadsheet should calculate material and labor costs, with each category showing the percentage of the total building cost.
- the development of this automated sht to be built in the latest version of excel but must be usable in all excel versions from office 2019 to 2021
- Overall Project Summary: An overall project summary should be included.
- Detailed Cost Breakdown: The estimator should be able to see costs per square meter of floor, roof, or wall area, as well as plant hire costs, and costs for labor and materials.
- There needs to be a "search item description" feature so that the estimator can filter or see all items contained within the estimate with the search description criteria.
- The price file needs to be searchable also by description and category
- all price file descriptions & price file cost centres will have a unique identification number
- the price file will need the ability to have individual items, but also the ability to have grouped items called "recipes" that the estimator can select & then these items are exploded (added into the estimate sheet into their individual cost centres)
- colour coding in the estimate sheet so that the estimator can choose to colour single or multiple line items in the sheet that may represent an item qty that is incomplete or waiting on a quote, etc
- the estimate sheet must have the ability for the estimator to add a "custom" item that is not in the price file & when this item appears in the estimate sht the id for this item will show as a 0001 for m2, 0002 for lm, 0003 for sht, etc which identifies it as a custom item
- any line item in the estimate sht that has either a "0" or negative qty, or $0 or negative $ value to be shown in red text as a warning to the estimator
- happy for there to be data validation, filters & conditional formatting in the building of this estimate sht
Reporting:
- Internal Reports: A detailed report for internal use should be generated.
- Summary Reports: Summary reports should be produced.
- Client Reports: Client-facing reports should be created, with each report showing costs per square meter.
- a summary report that shows or warns the estimator of any items in the estimate sheet that either has a "0" or negative qty, & $0 or negative value against any item
- All reporting formats for the estimator & client need to have options of pdf, word & excel
- Client reports info must not have the ability to copy & paste text info
- Search by description report, this is a search text box that the estimator will search for text for example "bricks" & the report to group all descriptions in the estmate sheet with this text & then show a total cost for these items & a cost per m2
Essentially, there needs to be a "price file" sheet from which the estimator can choose items. The ideal freelancer for this project should have extensive experience with Excel, particularly in creating complex, automated spreadsheets. They should also have a good understanding of building costs and estimation, to ensure the spreadsheet is practical and useful.
Key Features:
- Material and Labor Cost Calculation: The spreadsheet should calculate material and labor costs, with each category showing the percentage of the total building cost.
- the development of this automated sht to be built in the latest version of excel but must be usable in all excel versions from office 2019 to 2021
- Overall Project Summary: An overall project summary should be included.
- Detailed Cost Breakdown: The estimator should be able to see costs per square meter of floor, roof, or wall area, as well as plant hire costs, and costs for labor and materials.
- There needs to be a "search item description" feature so that the estimator can filter or see all items contained within the estimate with the search description criteria.
- The price file needs to be searchable also by description and category
- all price file descriptions & price file cost centres will have a unique identification number
- the price file will need the ability to have individual items, but also the ability to have grouped items called "recipes" that the estimator can select & then these items are exploded (added into the estimate sheet into their individual cost centres)
- colour coding in the estimate sheet so that the estimator can choose to colour single or multiple line items in the sheet that may represent an item qty that is incomplete or waiting on a quote, etc
- the estimate sheet must have the ability for the estimator to add a "custom" item that is not in the price file & when this item appears in the estimate sht the id for this item will show as a 0001 for m2, 0002 for lm, 0003 for sht, etc which identifies it as a custom item
- any line item in the estimate sht that has either a "0" or negative qty, or $0 or negative $ value to be shown in red text as a warning to the estimator
- happy for there to be data validation, filters & conditional formatting in the building of this estimate sht
Reporting:
- Internal Reports: A detailed report for internal use should be generated.
- Summary Reports: Summary reports should be produced.
- Client Reports: Client-facing reports should be created, with each report showing costs per square meter.
- a summary report that shows or warns the estimator of any items in the estimate sheet that either has a "0" or negative qty, & $0 or negative value against any item
- All reporting formats for the estimator & client need to have options of pdf, word & excel
- Client reports info must not have the ability to copy & paste text info
- Search by description report, this is a search text box that the estimator will search for text for example "bricks" & the report to group all descriptions in the estmate sheet with this text & then show a total cost for these items & a cost per m2
Essentially, there needs to be a "price file" sheet from which the estimator can choose items. The ideal freelancer for this project should have extensive experience with Excel, particularly in creating complex, automated spreadsheets. They should also have a good understanding of building costs and estimation, to ensure the spreadsheet is practical and useful.