Discussion in 'Landscape Architecture and Design' started by heygrassman, Aug 18, 2002.

1. ### heygrassmanLawnSite Senior Memberfrom Columbus, OhioMessages: 509

I had made an offer before to provide everyone with the mulch calculation spreadsheet that I use. There have been quite a few that have requested it. I have modified this by eliminating my costing and pricing model and included a calc to include bags.

1) Measure your beds and note if they are circular, rectangular, or triangles. Sorry not getiing into liver shaped, etc, you are going to have to assume they are rectangular, etc.

2) Plug in the footages based on the shape :
Rectangle - length and width
Circle - Radius (measurement from center to edge)
Triangle base and height

3) Enter the desired depth of mulch
1in for top dress
4 in for new beds
etc

4) Flip to the total calc page to see how many bags or cubic feet. The model calcs the cubic footage, rounds up for loose materials and calcs 2 cubic foot bags.

Hope this helps.. if anyone finds any errors in the calcs let me know and I can fix them.

jf

File size:
31 KB
Views:
586

3. ### hoagieLawnSite Memberfrom MA- South ShoreMessages: 222

Something to remember when you're out on site w/ no computer handy and need a rough estimate...

One yard of mulch will cover 100 sq/ft spread @ 3". 200sq/ft @ 1.5" ect...

And if your a little obsessive about exact numbers like me... total area divided by 27, multiplied by the number of inches divided by 12, equals the number of cubic yards + 15% additional material to compensate for compaction.

Which is A/27 x N/12 = cu yd + Comp.

Or just use Heygrassmans spread sheet.

4. ### heygrassmanLawnSite Senior Memberfrom Columbus, OhioMessages: 509

The ultimate goal of this was for it to be.. loaded into PDA that supports Excel and be used onsite..please pass along any errors that are found I can fix them pretty readily..

jf

5. ### GarPALawnSite Silver Memberfrom PAMessages: 2,585

heygrassman....do you find this works for estimating topsoil for raised beds?? I've used the 115sq ft rule for soil and it seems that the soil doesn't go as far as the mulch

7. ### thfiremanLawnSite Senior Memberfrom Charlotte, NCMessages: 541

Good Stuff!

I put the excel spreed sheet in my PDA and gave it a trial run today. Works like a champ. I used the computation and only had 2 shovel fulls extra. No Waste!! Great lil spreedsheet.

Thank you!

8. ### heygrassmanLawnSite Senior Memberfrom Columbus, OhioMessages: 509

Kitzy.. I have not tried it with top soil but the theory should hold the same, unless you are buying by the bag. I buy my soil by the cubic yard and from there it is a volume calc converted from yards to feet, which is exactly what the sheet does. I use the average bed height. 10'x10' New round bed with a 8" peak would have a radius of 5' and a depth of 4" (average of 0" and 8"). Let me know if that works.. I have a top soil job this week that i am going to give it a try...