Features & Benefits
Free project assessmentÂ form
It can be used over and over again 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
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
Rafter chart included
Input electrical for each room
Calculate circuits needed
Calculate counter tops
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 recd
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
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.
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.
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 I 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. I have used it for two 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, I welcome any new ideas.
Each order will be emailed to you. There is no documentation I will personally train you via phone with each order.