2005 NDS Supplement Lumber Design Values Spreadsheet
2005 NDS Supplement Lumber Design Values Spreadsheet
(OP)
Hiya,
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!
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
http://www.eng-tips.com/viewthread.cfm?qid=363147
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?
Thanks!
EIT
www.HowToEngineer.com
RE: 2005 NDS Supplement Lumber Design Values Spreadsheet
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>
main()
{
int number;
printf("Enter an integer\n");
scanf("%d",&number);
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
RE: 2005 NDS Supplement Lumber Design Values Spreadsheet
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
RE: 2005 NDS Supplement Lumber Design Values Spreadsheet
EIT
www.HowToEngineer.com
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
My email found here:
http://howtoengineer.com/contact-us/
EIT
www.HowToEngineer.com
RE: 2005 NDS Supplement Lumber Design Values Spreadsheet
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
A confused student is a good student.
Nathaniel P. Wilkerson, PE
www.medeek.com
RE: 2005 NDS Supplement Lumber Design Values Spreadsheet