All the files listed below are available for free download, and include full open source code.
Click on the file name to download, or the associated blog post link to open the post in a new window. Click on the icon in the bottom right hand corner to open this window full size.
The table now has two “category” columns. Scroll across or open in full window mode to view. The second category column links to the associated “Download by category” page, with more details and links for each file. It is also possible to sort on any column when the worksheet is in “Edit” mode, or open in Excel to use all Excel functions.
Pingback: Interactive File List | Newton Excel Bach, not (just) an Excel Blog
I’ve just started with vba programming. By googling I found your blog very helpful and interesting.
one of the best help or toturial you people made availabe to world
in so simple manner to new usser
Pingback: JRodSIM 1, or, How to use Excel to figure out your wishbones. | Hyllest
Pingback: Embedding Skydrive worksheets in WordPress | Newton Excel Bach, not (just) an Excel Blog
Thanks for the Skydrive wordpress support link, Doug. I was struggling with this myself so it’s a great help.
please can anyone help me ….. I want an Excel sheet make analysis for 2D truss using VBA
Did you look here?!
Download link at:
Pingback: Download update 2 | Newton Excel Bach, not (just) an Excel Blog
Doug, The files in the Textin2 zip won’t open. Could you take a look and reload the file, Thanks.
Thanks for letting me know.
I have uploaded the copy on my machine (that works).
Please let me know if you have any problems.
Doug, Files open now……thanks mate.Text-in2 works with your text files, but bombs out with error message 1004 with my text file. My file is colon separated with no header line, from a mobile phone company. Any ideas on what the problem is? Thanks again.
I don’t know why a colon separated file wouldn’t work. If you send a copy of a file that gives that problem to my gmail account (DougAJ4), I will take a look at it.
Will do Doug. I will strip it down and email.
Doug, Just downloaded the latest Text-in2 files. Hopefully the formatting issues are resolved. I will test and get back to you with the results.
For some inexplicable reason amounts in the original text file are not maintaining their comma in the correct location and shifting one number right (19,7150 is reflected as 197,150 in the output). However this is not the case for all amounts. The amount of 000,1666 maintains its format.
Doug, OK, disregard my previous post, I realized I had skipped a step. The output is as I wanted. Would it be possible to save the file as a tab delimited text file? What modifications are required to the VBA code. Thanks for your invaluable support.
Sorry, Mis-spoke. When the text file is Read, it looks OK. However, when Read and Split is pressed; some amounts are General format and others are numerical format. The amounts with General format are OK, but the numerical formatted amounts have the decimal comma in the wrong location, as noted above. Sorry for the confusion.
Hi Doug, I wonder if you could help – I’m looking for a simple calculator to calculate load distribution on a truss grid layout. I am familiar with load distribution for simple spans and cantilevers using only two anchorages however things get more tricky with additional supports and attached additional spans.
Do you have something that could be used for a novice like myself? I am involved in the entertainment business and use trussing for events.
Michael – sorry to be unhelpful, but if you need results you can rely on you really need a qualified person to do the calculations.
The DepthNA spreadsheet refers to a “RC design functions-circ.xls” spreadsheet to calculate the layer in which the neutral axis of a RC circular section lies, but I couldn’t find this spreadsheet in the downloads list – could you point me in the right direction for it?
Hannah – The routine referred to is now included in the RC Design Functions7.xlsb spreadsheet. Input and output are on the CircE Input and CircE Output sheets, and the VBA code is in the mCirc code module.
You can download from the list above, and the most recent blog post on this spreadsheet is :
Coincidentally, I will be posting another example using Brent’s Method in my next post here (although not related directly to reinforced concrete design).
Pingback: Section Properties with MeshPY, including torsion and warping | Newton Excel Bach, not (just) an Excel Blog
Hi Doug, In Composite design function, the Centroids Subroutine has
‘ Find layer and adjusted total transformed area, first moment of area about top, and centroid depth of steel
‘ for NA down to current layer
Asttc = RLayers(1, 2) * MRc
AsttcTot = AstttSum – RLayers(1, 2)
MAsttcTot = MAstttSum – RLayers(1, 2) * SDepth
Shouldn’t the last line read:
MAsttcTot = MAstttSum – RLayers(1, 2) * reo(1,1)
Thanks a lot for your Invaluable support to us
SDepth is set equal to reo(1,1), so it would give the same result.
The SDepth is assigned as reo(i,1) from a previous For loop meant to ” Find layer and cumulative transformed area, first moment of area about top, and centroid depth of steel in tension”. This gives the depth of the bottom most instead of depth of first layer.
Kindly look into this
You are right, SDepth gives the wrong depth, but the resulting MAsttcTot value is not actually used, because it is overwritten in the next for loop, where SDepth is set equal to reo(I,1), so that line of code doesn’t actually do anything.
I will tidy up the code and post a new version.
Thanks for letting me know, and following it up.
I just discovered this page, it is incredible. How can I download the files? Links appear to be down
Clicking on the file name should download, it worked for me with no problem with 3 I tried.
I’ll check on a different computer tomorrow.
Also you could try http://interactiveds.com.au/software/ and download directly from there.
Hello, thank your sharing all these files.
I have been using the functions on the IP2 and they are great! They have been super help full at work.
Thanks Jose, yes, IP2 is one of the general purpose spreadsheets I use the most as well.
How to draw a 3D tetrahedron with known excel 3d coordinates
The IP2 spreadsheet has functions for plotting 3D shapes. See:
for the VBA version and:
for a Python version.