# Downloads

All the files listed below are available for free download, and include full open source code. Recently posted files are:

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.

### Like this:

Like Loading...

Pingback: Interactive File List | Newton Excel Bach, not (just) an Excel Blog

Hi,

I’ve just started with vba programming. By googling I found your blog very helpful and interesting.

Zoul

LikeLike

one of the best help or toturial you people made availabe to world

in so simple manner to new usser

LikeLike

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.

LikeLike

please can anyone help me ….. I want an Excel sheet make analysis for 2D truss using VBA

thanks

LikeLike

Did you look here?!

Download link at:

https://newtonexcelbach.wordpress.com/2013/02/21/using-frame4-for-truss-analysis/

LikeLike

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.

LikeLike

Thanks for letting me know.

I have uploaded the copy on my machine (that works).

Please let me know if you have any problems.

LikeLike

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.

LikeLike

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.

LikeLike

Will do Doug. I will strip it down and email.

LikeLike

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.

LikeLike

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.

Hmmmmm ?

LikeLike

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.

LikeLike

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.

LikeLike

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.

LikeLike

Michael – sorry to be unhelpful, but if you need results you can rely on you really need a qualified person to do the calculations.

LikeLike

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?

LikeLike

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 :

https://newtonexcelbach.wordpress.com/2017/04/09/rcinteract-and-rc-design-functions-7-03/

Coincidentally, I will be posting another example using Brent’s Method in my next post here (although not related directly to reinforced concrete design).

LikeLike

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

LikeLike

SDepth is set equal to reo(1,1), so it would give the same result.

LikeLike

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

LikeLike

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.

LikeLike