Hire the best Decking Expert

DeCalc F5 Timber - Deck Span and Cost Calculator

Results 1 to 6 of 6
  1. #1
    Member
    Join Date
    Sep 2010
    Location
    Victoria
    Posts
    70

    Default DeCalc F5 Timber - Deck Span and Cost Calculator v1.01

    Hello my fellow Renovators.

    Attached is a Deck Span and Cost Calculator that I have developed after I built my deck. I ifeel that this is the best way I can give back to the forum of what I have taken out (information wise). The intention is not to replace other people's hard work and instead compliment the deck planning experience.



    Some of the features include the calculation of:
    • span requirements
    • deck specs vs. AS 1684.2 - F5 Seasonal Timber
    • holes and supports required
    • footing depth
    • concrete volume
    • screw quantity
    • total cost
    There are many more features that I have on my mind but for now I am open for comments on bugs and enchancements.

    Enjoy!

    **Due to upload issues with MS Excel, I have had to save it as MS Excel 2007, I should fix this in the next couple of days**
    Attached Files Attached Files

  2. #2
    Senior Member
    Join Date
    Apr 2006
    Location
    Melbourne Victoria
    Posts
    351

    Default

    Quite easy to use.

    Few suggestions

    Cell E34 the calculation only works with 90 mm board, and doesn't alter if 140 or 70 selected. Needs an IF value

    Cell D39 doesn't vary with board width as it relies on the result of E34. In the formula =ROUNDUP((1000*E34)/(D11)*2,0) for this cell replace the last 2 with N14 (Number of screws)

    L5 spelling error.
    C31 changing ledger size doesn't vary the cost in F31. Problem with the IF argument? Cells below have VLOOKUP

    I would protect all the cells except the light green ones

    Perhaps at the very top add put in the area to input the price of the materials, rather than scattered Throughout the worksheet, and then have formulas to get the value from above. That way changing the price of 90x45 needs only to be done once, rather than for joist bearer ledger etc.

    Similarly move drop down cell C32 to C20, directly above the sizes available, may make it more user friendly (still have value in C32 though)

  3. #3
    Member
    Join Date
    Sep 2010
    Location
    Victoria
    Posts
    70

    Default

    Thanks very much Brian!

    Version 1.01 now has the calcs fixed on the items you prescribed. I will leave the asthetics alone for a week then tinker around with the format.

    By the way, the worksheet is protected but there is no password. So to unlock, go to Tools > Protection > Unprotect Sheet

    Thanks again!

  4. #4
    Member
    Join Date
    Sep 2010
    Location
    Victoria
    Posts
    70

    Default

    DeCalc Version 1.02 fixes anther calc error with the joists spacing.
    Attached Files Attached Files

  5. #5
    Building Designer ausdesign's Avatar
    Join Date
    Sep 2004
    Location
    Strzelecki Ranges Victoria
    Posts
    546

    Default

    I will have a look through the sheet but in the meantime the first thing that comes to mind is that the majority of deck members used are F7 or mgp10 - have you thought along those lines.
    Peter Clarkson

    www.ausdesign.com.au

    This information is intended to provide general information only.
    It does not purport to be a comprehensive advice.

  6. #6
    Member
    Join Date
    Sep 2010
    Location
    Victoria
    Posts
    70

    Default

    Yes I have thought along those lines.The tables behind the spreadsheet can be adjusted to any span table, regardless of timber type from MPG10 to MGP15 and F5 to F17. It's just a matter of inputting the tables. The have 2676 pages of AS 164.2 Supplements if need be. I thought F5 would be a good starting point considering majority of people who I know have built a deck and deck builders themselves use F5. Also, I built using F5 wood of which I needed a real example to test the tool

Similar Threads

  1. Deck Calculator
    By Blocklayer in forum Decking
    Replies: 13
    Last Post: 19th Oct 2012, 01:54 PM
  2. Low deck hardwood span
    By IanK in forum Decking
    Replies: 2
    Last Post: 28th Sep 2010, 02:53 PM
  3. Deck Calculator Help
    By Blocklayer in forum Decking
    Replies: 9
    Last Post: 9th Nov 2009, 04:16 PM
  4. Large Span Deck
    By brissyboy in forum Decking
    Replies: 0
    Last Post: 8th Nov 2009, 11:23 PM
  5. Deck Calculator
    By Blocklayer in forum Decking
    Replies: 4
    Last Post: 18th Dec 2008, 11:21 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •