Tag Archives: Maths

Xlls, Maths and Plots; some useful links

Two from regular commenter here, Keith Lewis: Excel xll add-in library: This is a library for creating xll add-ins for Excel from 97 through 2013. It makes every feature of the latest Excel SDK available to you including the big … Continue reading

Posted in Coordinate Geometry, Excel, Link to dll, Maths, Newton | Tagged , , , | 3 Comments

Recently discovered (and rediscovered) links

Math ∩ Programming – A place for elegant solutions (another Alfred Vachris link) About the Author My name is Jeremy Kun. I’m currently a mathematics PhD student at the University of Illinois in Chicago, and I did my undergraduate at Cal Poly … Continue reading

Posted in Arch structures, Dome Structures, Newton | Tagged , , , , , , | Leave a comment

Elegant Solutions – completing the square

When I was at school (many years ago), if I recall correctly, we were told of the “completing the square” method of solving quadratic equations, but I never really appreciated the elegance of this method because it was treated as … Continue reading

Posted in Excel, Maths, Newton | Tagged , , , , | 1 Comment

New Links

I have added some new links to Excel Blogs that are regularly updated with new and different content, plus one new maths blog. Bacon Bits: Delicious pieces of Excel and Access training brought to you by DataPigTechnologies.com Contextures Blog: The Contextures … Continue reading

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

The Inverse Quadratic Method 3 – Brent’s Method

The previous post in this series presented iterative methods to solve polynomial equations using direct or inverse quadratic interpolation.  These methods have two disadvantages: In some circumstances the function may converge very slowly, or not at all. The name of … Continue reading

Posted in Excel, Maths, UDFs, VBA | Tagged , , , , , | 12 Comments