PDA

View Full Version : Excel Sheet For Estimating


jg244888
09-30-2011, 05:49 PM
Does anyone have a excel sheet you could post that you just fill in to figure out your exact costs
Thanks

DVS Hardscaper
09-30-2011, 06:31 PM
You may buy my super duper estimating system for $500.00. Pretty good stuff.


.
Posted via Mobile Device

SDLandscapes VT
09-30-2011, 07:48 PM
well said DVS--why should we give away something we ve worked a long time on.....well I should say continue to work on each and every estimate improving the sheet and learning more about each and every job.

JimLewis
10-27-2011, 10:52 PM
I'm not sure anyone has exactly what you are asking for. You're asking for something where you could just plug in length and width and then this magic formula would tell you exactly how many pavers you need, what variety of pavers, how much gravel to go underneath, how much sand, how much joint sand, how much snap edge, how much labor, etc.???

If that's what you're asking for, that doesn't exist. And if it does, it's not accurate. Every job is unique. There are too many variable from one job to the next to do it this way. Some large patios have a lot of area that is bordered with snap edge, some have very little (because maybe it's bordered by the house foundation on one end and retaining wall on another....) Some varieties of pavers (e.g. tumbled) use up twice as much joint sand as other varieties that have tight joints. Some jobs will require you to factor in just 8% extra pavers for cutting, etc. while others will require up to maybe 15% extra to get the job done.

Every proposal is fairly unique to itself. I will "cut and paste" a lot in my previous proposals, if it's the exact same variety of paver and exact same pattern. Then I'll go through and change my quantities for all of the items. But there's no magic spreadsheet that just does all this for you. Each project needs to be given a lot more thought than what a program like that would do.

Now, if you want to see some of my excel spreadsheets how I work up a hardscape proposal, no problem. Just PM me your email address. But don't use this as a template for every job you estimate. It is just to give you an idea of what yours could look like after you're done creating your own custom proposal.

DVS Hardscaper
10-27-2011, 11:09 PM
If that's what you're asking for, that doesn't exist. And if it does, it's not accurate. Every job is unique. There are too many variable from one job to the next to do it this way. Some large patios have a lot of area that is bordered with snap edge, some have very little (because maybe it's bordered by the house foundation on one end and retaining wall on another....) Some varieties of pavers (e.g. tumbled) use up twice as much joint sand as other varieties that have tight joints. Some jobs will require you to factor in just 8% extra pavers for cutting, etc. while others will require up to maybe 15% extra to get the job done.



I CAN ASSURE you that 90% of what you just explained DOES exist.

And you're right, there are variables, that no software will ever calculate. But my system makes it easy to hand calculate.

It also writes the proposal AS you build the job :) And it orders the materials! And it calculates for borders!

I've spent about 8 years perfecting this. I wasn't kidding about $500.00

I have also been thinking about a winter service where I custom build spreadsheets for forum members. You name it, I can create it.


,

jg244888
10-27-2011, 11:26 PM
I'm not sure anyone has exactly what you are asking for. You're asking for something where you could just plug in length and width and then this magic formula would tell you exactly how many pavers you need, what variety of pavers, how much gravel to go underneath, how much sand, how much joint sand, how much snap edge, how much labor, etc.???

If that's what you're asking for, that doesn't exist. And if it does, it's not accurate. Every job is unique. There are too many variable from one job to the next to do it this way. Some large patios have a lot of area that is bordered with snap edge, some have very little (because maybe it's bordered by the house foundation on one end and retaining wall on another....) Some varieties of pavers (e.g. tumbled) use up twice as much joint sand as other varieties that have tight joints. Some jobs will require you to factor in just 8% extra pavers for cutting, etc. while others will require up to maybe 15% extra to get the job done.

Every proposal is fairly unique to itself. I will "cut and paste" a lot in my previous proposals, if it's the exact same variety of paver and exact same pattern. Then I'll go through and change my quantities for all of the items. But there's no magic spreadsheet that just does all this for you. Each project needs to be given a lot more thought than what a program like that would do.

Now, if you want to see some of my excel spreadsheets how I work up a hardscape proposal, no problem. Just PM me your email address. But don't use this as a template for every job you estimate. It is just to give you an idea of what yours could look like after you're done creating your own custom proposal.

pm sent Thanks a lot

4Russl5
10-28-2011, 10:45 AM
DVS you would give this away for $500? Seems cheap to me....

DVS Hardscaper
10-28-2011, 03:58 PM
DVS you would give this away for $500? Seems cheap to me....

At this time I would. Because for it to work, you have to cost out jobs and recover overhead the same way I do. So the user would be having to change their way of doing things.


I would consider selling the materi calculation portion for $250.00. It's pretty slick. I may post a PDF of it. Or maybe I won't. The codes are hidden, so it would be nearly impossible for one to reproduce it.

To create something like this you need to know the business inside and out. I've spent countless nights fro
10pm to 2 am creating this.



Posted tvia Mobile Device

4Russl5
10-28-2011, 06:13 PM
They are great tools for the people that develop their own for their company. A close friend and mentor here gave me his that he developed for his company, and he chuckled. I have a crew of 3 full time guys doing hardscaping, he has a full time crew of between 15-18 providing the spectrum of services. It was more of a labyrinth than a help even though he explains it to me from time to time. I do things my way based on how I think, work, etc...
You have learn to crawl before you walk, walk before you run...
Still seems cheap.

DVS Hardscaper
10-30-2011, 12:49 PM
They are great tools for the people that develop their own for their company. A close friend and mentor here gave me his that he developed for his company, and he chuckled. I have a crew of 3 full time guys doing hardscaping, he has a full time crew of between 15-18 providing the spectrum of services. It was more of a labyrinth than a help even though he explains it to me from time to time. I do things my way based on how I think, work, etc...
You have learn to crawl before you walk, walk before you run...
Still seems cheap.


Thats my exact saying! We have a former Sheriff that used that statement frequently, whom I learned it from. I think I've written that a time or two on here!


If you had an ice cream stand and I had an ice cream stand - most likely we could both very easily learn and quickly adapt to software for the ice cream stand business, as we're buying product and selling product.

But in construction, no two companies price work the same way. Yeah, in the scheme of things we may end up at the same digits, but we had different methods of getting us there.

My job costing is derived from a method that an industry consultant whom I had hired, had showed me.


Here is a question:

How much time do you guys spend calculating how many square feet of pavers are needed for a soldier course border and then calculating how many square feet of pavers are needed for the field? 5 minutes? 10 minutes? 7 minutes?

JimLewis
10-30-2011, 08:12 PM
About 10 minutes, I guess. But only if I get the job. Otherwise, I am just calculating the total sq. ft. of pavers we're going to need to purchase to get the job done. If I get the job, THEN I'll worry about how much border and field units I'll need. But only then.

Anyway, I think 4Russl5 is sort of right. I think that program probably works wonders for YOU. But I don't think it would save ME any time. First of all, it doesn't take me all that long to type up a proposal anyway. 50% of it is just cut and paste. Then I just change the quantities and paver variety and price per unit, etc. And all that is just in my head. I can type it out about as fast I could could select it from a drop down list in a pre-made custom program. I type pretty fast. Without seeing the program, it's hard to say for sure. But I just can envision it saving me any time, really. I am already pretty quick at writing up proposals.

JoeyDipetro
10-31-2011, 12:20 AM
Does anyone have a excel sheet you could post that you just fill in to figure out your exact costs
Thanks

Do you know your costs?