Recent Comments
Category Archives: VBA
Automatic download of csv files
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
ULS Analysis of Concrete Beams; now with added units
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 Concrete section, Excel, UDF, ULS Analysis, unit aware, VBA
10 Comments
Units for Excel 4: Scripting dictionaries
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 Conversion, Excel, scripting dictionaries, UDF, Units, Units aware, VBA
6 Comments
Units for Excel 3 – Editing the units table
I have made several changes to the Units4Excel spreadsheet: Litres added as the base SI unit of fluid volume. Units added for specific heat Units added for fuel consumption in both km/litre and litres/100 km form As before, the revisions … Continue reading
Units for Excel 2 – Unit aware evaluation of functions
The Units4Excel spreadsheet described in the first post of this series provides functions to convert values from one set of units to another, but does not allow for automatic evaluation of functions, taking account of the specified units, as performed by programs … Continue reading
Posted in Excel, Newton, UDFs, VBA
Tagged Conversion, Excel, UDF, Units, Units aware, VBA
Leave a comment
Newton Excel Bach, not (just) an Excel Blog 