I have a construction company. Here’s my problem:
Let’s say I get a job to develope a basement. To develope a basement there are walls that need to be built, electrical wiring that needs to be done, drywall needs to be put up, exterior walls need insulatiion and vapor barrier, I have to mud the walls, prime & paint, then hang doors, and finish with baseboards & door trim. Now before I get the job, I need to provid an estimate, & list everything that needs to be done (kind of like what I just did but in a lot more detail and in point form on a spreadsheet), and list all the materials. This is a 3-4 hour job that doesn’t guarantee the job is mine.
So what I want is a spreadsheet/program on my website that will do the work for me and other contractors can use it as well… for example:
in box A1 for example, it asks me how long the wall is (in feet). I input 12. The spreadsheet now automatically calculates how long it’s going to take to frame it, how long to drywall it, how long to paint it, how long to put baseboard on it.
Then, it’s going to automatically calculate the material required… how many 2x4s, how many nails, how many sheets of drywall, how much primer, how much paint, how much baseboard, how much baseboard paint, how much baseboard caulking etc.
Everything will be optional. In other words my customer may want me to just frame the wall and drywall it, and they will do the rest. Some walls may need electrical outlets, some may not… some may need insulation, others not… so everything needs to be optional.
Everything needs to be adjustable as far as prices go… if I am framing for $15/ft and want to change it to $17, then I need to be able to easily do this without messing up the calculator…. in fact, it would be prefered that the calculator can’t be fiddled with… but the variables can be changed… but I also don’t want to have to input the $15/ft everytime I use it.
I also need to be able to design templates… for example, bathrooms are usually similar…I open the bathroom template and then adjust it accordingly.
Then the spreadsheet needs to be able to list everything in order and in a way so that the customer understands it. The materials need to be organized in sections… “Building materials,” “Electrical,” “plumbing,” “painting” etc…
Then I need to be able to convert to PDF and email/print for my customer. The output needs to look professional with my company logo and colors.
Multiple people will be using this, so each seperate user will have their own user name & password. In their back office will be all the estimates they have done as well as the templates they have used and any current estimate they are working on. They may be another contractor with their own company and own logo, which would be different from mine, therefore when they upload their logo, it will not change mine or any other user.
There needs to be an “upload” button for the logo as I have other companies that will be using this that will put their own logo on…
Finally, when all the testing is done, this will be a subscription based service, so the site needs to accept payments (this will be later and is not part of this project).
I hope this is sufficient.
Thanks,
Davyn