Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- AS 3600 public comment draft and py_RC Design
- Downloads
- Deflections and Moments in Rectangular Plates
- Using LINEST for non-linear curve fitting
- Taming Symbols in Excel
- Finding Prime Numbers with Excel, and using Array Formulas
- Retrieving unique values from a range or array ...
- Tension Stiffening
- The history of the theory of beam bending - Part 3
- 3D Frames, axes and stiffness matrices
Recent Comments
Category Archives: Newton
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 ACI 318, AS 3600, biaxial bending, Eurocode 2, Excel, Reinforced Concrete, UDFs, ULS Design Functions, VBA
35 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 42, Excel, Life the Universe and Everything, mpmath, PyXLL, sum of 3 cubes
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 42, Excel, Life the Universe and Everything, mpmath, PyXLL
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 Charts, Excel, Mandelbrot Set, VBA
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 64 bit Excel, Strand7 API
Leave a comment