Author Archives: dougaj4

Automatic download of csv files

Posted on 19/08/2012 by dougaj4

I was recently asked if I could assist with preparing a spreadsheet to automatically download .csv files from an internet location, with the filename incorporating the date of issue.  The process turned out to be quite straightforward, and works well … Continue reading →

Posted in Excel, VBA | Tagged , , , | 21 Comments

The Dome of Santa Maria del Fiore – Stress Analysis 2

Posted on 13/08/2012 by dougaj4

Following on from the previous post I have uploaded the Strand7 data and results files and an animation of the stresses as the construction proceeds.  Strand7 users can just download the files and load them into Strand7 (or those with a slow … Continue reading →

Posted in Dome Structures, Finite Element Analysis, Newton, Strand7 | Tagged , , , , , , | Leave a comment

The Dome of Santa Maria del Fiore – Stress Analysis 1

Posted on 11/08/2012 by dougaj4

It’s time to get back to the analysis of the stresses and strains in the dome of the Cathedral of Santa Maria del Fiore in Florence. Since the last installment I have purchased “Brunelleschi’s Cupola” by Giovanni and Michele Fanelli, which is … Continue reading →

Posted in Dome Structures, Finite Element Analysis, Newton | Tagged , , , , , , | 1 Comment

ULS Analysis of Concrete Beams; now with added units

Posted on 09/08/2012 by dougaj4

The spreadsheet for Ultimate Limit State Analysis of reinforced or prestressed concrete beams, previously presented here, has been combined with the Units4Excel spreadsheet to allow the program to work with any selected units, SI or non-SI.  Provision for the American … Continue reading →

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , | 10 Comments

Units for Excel 4: Scripting dictionaries

Posted on 08/08/2012 by dougaj4

As mentioned in the previous post I have now updated the Units4Excel spreadsheet with the use of scripting dictionaries to speed up the process of finding units in the lists, and also to simplify the process of adding or deleting units.  … Continue reading →

Posted in Excel, Newton, UDFs, VBA | Tagged , , , , , , | 6 Comments