Recent Comments
Category Archives: Excel
Interactive File List
Microsoft recently introduced the facility to embed a link to a live spreadsheet stored on Windows Skydrive. This is my first attempt to use this facility. The spreadsheet below is a list of all the files published on this blog, together … Continue reading
Update to Beam1 and Beam2
It has just been pointed out that the single span beam spreadsheet presented at Frame Analysis with Excel 1 does not work for a propped cantilever. The same applies to the spreadsheet for single span sloping beams at Frame Analysis with … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton
Tagged beam analysis, Excel, Frame Analysis
3 Comments
Faster Integration with the Tanh-Sinh Method
In my previous post about numerical integration I mentioned that I would be writing about another lesser known method providing better speed and/or accuracy in many cases. The method is known as Tanh-Sinh quadrature, and has been implemented in Excel by a reader … Continue reading
Posted in Excel, Maths, Numerical integration, UDFs, VBA
Tagged Excel, Gauss-Kronrod, numerical integration, Quadrature, Romberg, Tanh-Sinh, UDF, VBA
3 Comments
Plotting Ferns
Over at Daily-Dose-of-Excel mrt has posted an interesting VBA version of a Matlab program that used an Iterated Transfer Function to plot a graph resembling a fern. The original Matlab code came from Dr Tom Wood, and Michael’s VBA version works just fine, … Continue reading
