Category Archives: Newton

The answer to Life the Universe and Everything …

is 42, as is well-known. The actual question, to which the answer is 42, is not known, but a lesser known long standing question involving this number has recently been solved: The original problem, set in 1954 at the University … Continue reading

Posted in Computing - general, Excel, Maths, Newton, PyXLL | Tagged , , , , | Leave a comment

Plotting Mandelbrot

There are many sites discussing the Mandelbrot Set, but not many examples using VBA to plot the set in Excel, so here is my effort: The spreadsheet (including open source VBA code) may be downloaded from: Mandelbrot chart.zip Note that … Continue reading

Posted in Charts, Charts, Coordinate Geometry, Drawing, Excel, Maths, Newton, VBA | Tagged , , , | 3 Comments

64 bit Excel and the Strand7 API

Back in May 2017 I posted a sample spreadsheet using the Strand7 API to allow Excel to read and write Strand7 node data and results.  A comment noted at the time that the spreadsheet was not working with 64 bit … Continue reading

Posted in Excel, Finite Element Analysis, Frame Analysis, Link to dll, Newton, Strand7 | Tagged , | Leave a comment

Concrete 2019

The Concrete Institute of Australia’s biennial conference is this year being held in Sydney from 8-11 September, and early-bird registration has now been extended to 15th July, so register now and save! For more details of the conference see: Concrete … Continue reading

Posted in Concrete, Newton | Tagged , , , | 2 Comments

Solving the Lagrangian Point equation for the Moon

This post was prompted by a recent question at Fitting high order polynomials, asking for Excel methods to solve the equations for the radius of the Moon’s Lagrangian Point 1. All the methods described in this post have been added to … Continue reading

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , | 3 Comments

ULS design of circular reinforced concrete columns

The RC Design Functions spreadsheet has been updated (to Version 8.04) with the addition of a CircU function for ULS design of circular reinforced concrete sections under combined bending and axial load.  The new version, including full open-source code, may … Continue reading

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , , , , , , , , | Leave a comment

ULS Design Functions – update for AS 3600

The ULS Design Functions spreadsheet (last posted here) has been updated to the new Australian Standard for concrete structures; AS 3600-2018.  The new version can be downloaded from: ULS Design Functions.zip Note that the biaxial version included in the download … Continue reading

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