Project dashboard is a custom designed Excel estimating spreadsheet for the construction industry. It will keep all your data at your fingertips throughout every project. The sheet makes it easy to estimate the cost, track hours, material allowances, product selections, changes and the vendor payout's for each project. It comes with a fully customizable Word document that is a 6 page project assessment form that helps you identify all pre-existing conditions. This tool will help you estimate faster and more accurately!
Tracks the following data;
Division number, description, quantity, unit, material cost, material total, labor cost, labor total, unit cost for material & labor combined, allowance total, hrs. /unit, hrs. total, labor /unit, hourly labor total.

Features & Benefits
Free project assessment form
It can be used repeatedly just by copying the template
You can add or change the data to customize it to your specific needs
Input the dimensions for a room to get costing
Input the complete project by entering data on the division input tab
You may set the hourly rate of pay for all the divisions
Adjust the employer burden % for each division
Adjust hours need to perform each task therefore adjusting labor rate automatically
You may increase or decrease all divisions by % for labor, materials and/or allowances
Shut on and off cost as desired
It has a built in calculator to use
Use unit cost assemblies to get a unit price
Enter current material pricing to update assemblies
Calculate Btu’s needed for hvac
Calculate ea, lf, sf, cy, cf automatically
Calculate roofs
Rafter chart included
Input electrical for each room
Calculate circuits needed
Calculate counter tops
Calculate stairs
Auto calculate walls, ceilings and floors and everything that might go on them or in them
The ability to add to the sheet itself to do new things
It calculates a manage fee based on total project costs
Calculates % of each vendor compared to the total project
Calculates % of materials, labor and/or allowances for the complete project
Does the math for all change orders
Division totals summarizes all costs by material, labor, grand total discount total, allowance total and hrs. total
Allowance tab tracks item, quantity, unit, unit allowance, total allowance, actual unit cost, actual unit cost with tax, difference, manufacturer, model name, model #, finish, size, notes, vendor, phone, contact, date ordered, date expected, date rec
Selection tab tracks item, quantity, unit, allowance, total, details
Plans, permit, clean & protect tab enable you to input a % of project cost to calculate plans, permit, clean up, maid, protection, selections and duct cleaning.
Monitor hours that are expected to be required for a specific tasks
It provides boilerplate data for your proposals and contracts
Auto sworn statement

Example; if you know that on average it takes your electrician 1 hr. to run the box, pipe and wiring for a typical switch you can put that entry into the sheet so that when you get all finished with the estimate you will have a good idea of time needed to perform all the tasks in total & labor.
Divisions
There are 29 cost divisions in a simple format with over 2000 unit cost prices already included.

Prep/demo - Concrete - Carpentry Rough - Windows - Exterior Doors - Plumbing Rough - Hvac - Electrical - Masonry - Tops - Roofing - Gutter - Siding - Skylights - Cabinets - Cabinet/Appl install - Plumbing trim - Exterior Decks - Glass - Insulation - Drywall - Interior Doors - Interior Millwork - Tile floor/wall - Wood flooring - Vinyl/Laminate/Carpet floors - Fireplace prefab - Ceiling Wall Finish - Plans-Permit-Clean-Protect

Custom; if you do not need all the divisions I will custom make a dashboard for just your specific needs.

Example; if you are an electrician and want just electrical we will make it just for you!
This sheet is for anyone that wants to save time and be more accurate. The better you are at excel the easier it will be to use. The sheet is still in progress of being developed. We have used it for several years now and still find ways to improve on the design. The bottom line is it makes it very easy for you to get quick costing and track your projects. So if you cannot estimate as quickly as you would like maybe this is for you! After you buy it and use it you will see how fast you can estimate. As you see room for improvement, we welcome any new ideas.
Each order will be emailed to you. There is some documentation included. We will personally train you via phone with each order.
Solution Graphics
Buy this
PROJECT DASHBOARD $995.00
email me
Architectural Design & Build Services
OVERVIEW