Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Cubic Splines
- About Newton Excel Bach
- XLDennis, the MSDN Library, and VBA rant
- Downloads
- Filling Blanks with Go To-Special (and local help rant)
- Frame Analysis with Excel - 3, Continuous beam or frame
- Linking Excel to C - 2
- Writing Arrays to the worksheet - VBA function
Recent Comments
Category Archives: Maths
Dog Tessellations
An intruiging tessellation from a dog with a way with words Also a variety of tessellations from MC Escher. And while we are on tessellations, here is an animated tadpole tessellation posted by the dog’s father (who, strangely, does not seem … Continue reading
Solving simultaneous equations
Solving a series of simultaneous equations is a task frequently required in engineering and scientific analysis. Excel provides the tools to perform this task quickly and easily, but the procedure is not documented in the on-line help (so far as … Continue reading
Evaluate Function – update
Previous post The evaluate function described in the previous post has been used in writing a UDF that will evaluate the integral of any suitable function over a specified range. The revised worksheet can be downloaded from: Eval.zip
Elegant proofs 2 – The area of a circle
We are so familiar with the formula for the area enclosed by a circle that we tend not to think much about how it was derived, at least I don’t. The proofs of the formula are in fact many and … Continue reading
Pythagoras, Penrose and Pov-Ray
Images based on Pythagorean tiling, Penrose tiling, and projections onto the Riemann Sphere by PM2ring, a regular contributor to the ABC Self-Service Science Forum (words by the artist): Various renderings of a Pythagorean tiling. Mostly using the 3,4,5 triangle. This … Continue reading