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.

33 Responses to Downloads

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

  2. Zoul says:

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


  3. vivek says:

    one of the best help or toturial you people made availabe to world
    in so simple manner to new usser


  4. Pingback: JRodSIM 1, or, How to use Excel to figure out your wishbones. | Hyllest

  5. Pingback: Embedding Skydrive worksheets in WordPress | Newton Excel Bach, not (just) an Excel Blog

  6. Colin Legg says:

    Thanks for the Skydrive wordpress support link, Doug. I was struggling with this myself so it’s a great help.


  7. mustaffa says:

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


  8. Pingback: Download update 2 | Newton Excel Bach, not (just) an Excel Blog

  9. Costas says:

    Doug, The files in the Textin2 zip won’t open. Could you take a look and reload the file, Thanks.


  10. Costas says:

    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.


    • dougaj4 says:

      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.


  11. Costas says:

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


  12. Costas says:

    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.


  13. Costas says:

    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 ?


  14. Costas says:

    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.


  15. Costas says:

    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.


  16. Michael says:

    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.


    • dougaj4 says:

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


  17. Hannah says:

    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?


  18. Pingback: Section Properties with MeshPY, including torsion and warping | Newton Excel Bach, not (just) an Excel Blog

  19. Rajesh M says:

    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


    • dougaj4 says:

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


      • Rajesh M says:

        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


        • dougaj4 says:

          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.


  20. rhochoa81gmailcom says:

    I just discovered this page, it is incredible. How can I download the files? Links appear to be down


  21. Jose says:

    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.


  22. Sunny says:

    How to draw a 3D tetrahedron with known excel 3d coordinates


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.