Tag Archives: Excel

Excel Dynamic Arrays

Previews of dynamic arrays in Excel have been available for some time through the “Insider” programme.  They are now being published to general subscribers through Office 365 monthly updates: Further information is given at: Easier array formulas and Dynamic array … Continue reading

Posted in Arrays, Excel, UDFs | Tagged , , , , , | Leave a comment

Biaxial bending update

The reinforced concrete biaxial bending spreadsheet has now been updated: Stress block and capacity reduction factors updated for AS 3600-2018 ACI factors for US customary units used when stress is entered in ksi or psi units Example data updated The … Continue reading

Posted in Beam Bending, Concrete, Newton | Tagged , , , , , , , , | 10 Comments

More powers of 3

Following the discovery of a question to which the answer is 42, the same team has now reported a sum of three cubes equal to 3.  As before, the result can be checked from Excel, linking to mpmath, via pyxll. … Continue reading

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

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 , , , , | 5 Comments

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

Using conditional formatting with array formulas

A recent Quora question asked “How do I highlight the number closest to an initial number in a row in Excel?“.  The answer by Bill Jelen provides a good example of using conditional formatting with an array formula: In my … Continue reading

Posted in Arrays, Excel | Tagged , , , | Leave a comment

64 bit Excel and PtrSafe

Installing my Office 365 subscription on a new computer I discovered it had decided (without asking) to upgrade itself to the 64 bit version, which resulted in some of my spreadsheets not working on the new system.  The main problem … Continue reading

Posted in Excel, VBA | Tagged , , , , | Leave a comment