Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.


2005 NDS Supplement Lumber Design Values Spreadsheet

2005 NDS Supplement Lumber Design Values Spreadsheet


I'm writing some python code to automatize design of individual member based on loading conditions. Anyways, I haven't had the chance to do re-write the whole NDS set of tables to a spreadsheet and I would like to know if anybody has or has run into an spreadsheet that contains all the wood properties already. Any help I'd appreciate :) Thanks!

RE: 2005 NDS Supplement Lumber Design Values Spreadsheet

I tried to ask this question as well...

If you don't mind (sorry I am of no help), I had a few questions for you...
I have just started to learn python. I'd like to start creating calculations as you describe. I'm curious though:
What resources have you found helpful in this process?
What made you want to start writing calcs in python?



RE: 2005 NDS Supplement Lumber Design Values Spreadsheet

First of all,

Python is free, it has great support and it's easy to program (they've kept it pretty straightforward) and its syntax is supposed to resemble common tongue rather than having something like:

#include <stdio.h>

int number;

printf("Enter an integer\n");

printf("Integer entered by you is %d\n", number);

return 0;
which is a lot of lines for something so simple. As for the resources, I normally just google whatever I want to do to find if there's an existent library or command that performs the function directly or if I have to program it myself. PLUS they have scipy package which is basically all MATLAB functions (with a few tweaks) so if you feel like doing matrix algebra or FEA or anything, you don't have to start from scratch.

RE: 2005 NDS Supplement Lumber Design Values Spreadsheet

and to answer the original question, there is a spreadsheet and it's $50 in the NDS website, but then again, who has that kind of cash to spare, I don't. That's why I'm asking for the spreadsheet made by someone who actually bothered to do it by hands to help a few lazy bastards like myself.

RE: 2005 NDS Supplement Lumber Design Values Spreadsheet

I asked a similar question as well but pertaining to ASCE 7 c&c wind tables and the response I received was "Can I get you some coffee too?".
Anyway, I'm a big python fan also and moved to it after lots of Matlab programming during grad school. I have mostly been doing things in excel the last few years since the interface, calcs, and report are all done at once but there are some pretty great modules out there now that should let you use excel as your interface and report and use python as the backend. I'm pretty excited to give it a shot.

RE: 2005 NDS Supplement Lumber Design Values Spreadsheet

ah yeah, i've seen it. It's sort of like VB integration, I mean at least it helps the visual part but i am planning to do a complete engineering package with python and commercialize it for a minimum amount $$ or release it on GPL for people to use, I've just started but it's going to take a while...

RE: 2005 NDS Supplement Lumber Design Values Spreadsheet

sponton -> I have the same dream. I'm learning python now. Seriously if you would like to have a some assistance/partner whatever let me know I would be more than interested. Also checkout SMath, very good program. I would love something like a combination of SMath with calc modules using python or some other more powerful language. Where you could create a calculation "report". All loads could be kept in one place with the ability to update everything by keeping things interlinked.


RE: 2005 NDS Supplement Lumber Design Values Spreadsheet


That's basically why I chose python, it works in modules so it can decompose very complex projects into smaller simple modules and everything can share information. If you want to, we can sort of exchange e-mails and tackle the project together. I think there's no better practice in analysis than coding and seeing how things get done rather than using the black boxes that people are so fond about, I've seen some people using design information that makes no sense but that has been obtained from a software package..

I have some matlab stuff as well, like plate bending, 3d FEA, some of them are quite elegant but I need to take the time to translate them into python, also I was looking for a way to see if it would be possible to read dxf files of simple line models and get centers of rigidity and mass and such, for masonry short building design.

RE: 2005 NDS Supplement Lumber Design Values Spreadsheet

Sponton, I would say there is definitely room for something like that in the market. Especially if you aimed at being a enercalc replacement.

RE: 2005 NDS Supplement Lumber Design Values Spreadsheet


I actually use enercalc at work and it's all right for certain things, but it's rather limited in use and it's not really clear what methods it uses.

anyways, here's the first wood table for anybody who's interested. I found a python code that is able to unlock the documents, so i'll feed you the formatted table via excel files.


RE: 2005 NDS Supplement Lumber Design Values Spreadsheet

I'm looking for Table 4A if it exists. 2012 or 2015 NDS Supplement

A confused student is a good student.
Nathaniel P. Wilkerson, PE

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close