Mulch Calculation Spreadsheet

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

  1. heygrassman

    heygrassman LawnSite Senior Member
    Posts: 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.

    Using the spreadsheet is easy.

    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
     

    Attached Files:

  2. Big Mow

    Big Mow LawnSite Member
    Posts: 13

  3. hoagie

    hoagie LawnSite Member
    Posts: 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. heygrassman

    heygrassman LawnSite Senior Member
    Posts: 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. GarPA

    GarPA LawnSite Silver Member
    from PA
    Posts: 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
     
  6. bob

    bob LawnSite Platinum Member
    from DE
    Posts: 4,254

  7. thfireman

    thfireman LawnSite Senior Member
    Posts: 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!:D
     
  8. heygrassman

    heygrassman LawnSite Senior Member
    Posts: 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...

    Fireman.. glad I could help..

    jf
     

Share This Page