Recent Comments
Category Archives: Excel
Using LatPilePY
LatPilePY is a User Defined Function (UDF) used to analyse the deflections and load actions in laterally loaded piles. It was presented in this post: LatPilePY. In response to an e-mail request, this post will give step by step instructions for … Continue reading
Posted in Arrays, Concrete, Excel, Geotechnical Engineering, Newton, UDFs, VBA
Tagged Array Function, COM624, Excel, Laterally loaded pile, Non-linear concrete, UDF, VBA
Leave a comment
Rotating Hypercubes
The discussion of dancing pendulums in javascript at SSSF led onto Rotating Hypercubes, which resulted in this javascript animation by forum regular mollwollfumble: 4D Rotations (click to view in a new window, right click to download javascript file) See the SSSF thread for discussion on … Continue reading
Yet more pendulums
Following Dynamically Defined Dancing Pendulums, another three versions of the dancing pendulum theme. First a POV-RAY version by PM 2Ring, complete with reflections and shadows: POV-Ray Pendulums (click to open in a new window) and an interactive Javascript version: Javascript pendulums by PM2Ring (click … Continue reading
Posted in Animation, Excel, Newton, Ray Tracing
Tagged Chandoo, Excel Hero, javascript, Pendulum animation, PovRay
1 Comment
Debugging VBA …
… especially User Defined Functions (UDF’s). This post (and most likely several to follow) was prompted by a recent discussion at Daily Dose of Excel about various alternative debugging techniques. It reminded me (if I had ever known) of the Debug.Assert … Continue reading
High Speed Blog …
… brought to you via Smurf on Spreadsheets If you want your spreadsheets to go faster, Charles Williams is the man to tell you how to do it. Charles has recently started a blog on the subject: FastExcel Well worth … Continue reading
