Recent Comments
Author Archives: dougaj4
Iterative solvers and arrays
A recent thread at Eng-Tips was looking for a solution to the problem described below: The solutions to this problem described below can be downloaded from: ItSolve.zip and xlScipy3.zip The ItSolve.xlsb spreadsheet contains a user defined function (UDF) to solve iterative … Continue reading
Posted in Arrays, Charts, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA, xlwings
Tagged Brents method, Excel, Python, SciPy, UDFs, VBA, xlwings, xlwSciPy3
2 Comments
Australian Greenhouse Gas Emissions
What the Australian Government says: PM claims Australia will meet Paris target ‘in a canter’ despite emissions climbing. Morrison says rate of increase not as high as previous years and renewables investment will ensure Australia meets commitment pm-claims-australia-will-meet-paris-target-in-a-canter-despite-emissions-climbing What the … Continue reading
Time in hours and minutes between two dates
Dates and times in Excel are stored as a date number, which is the number of days since 1 January 1900, with the value after the decimal point representing the time of day. To calculate the number of hours between … Continue reading
Posted in Excel
Tagged Excel, format times, greater than 24 hours, Text function, time difference
7 Comments
New AS 3600 and RC Design Functions 8
A revised version of the Australian Concrete Structures code, AS 3600, was recently published, with many significant changes, including: Changes to ULS reduction Factors Creep and shrinkage Curvature and deflection calculations Crack width calculation and stress limits Major changes to … Continue reading
2 more Moves Through the Fair
I have just mended a broken link in the previous installment of “She moves Through the Fair”. Here are two more, from Tir Eolas: and Tara McNeill:
Newton Excel Bach, not (just) an Excel Blog 