Author Archives: dougaj4

Using Goal Seek on a multi-column range

Posted on May 20, 2013

Following a comment requesting help using my Goal Seek spreadsheet I have modified the macro to allow it to operate on a multi-column range.  The spreadsheet can be downloaded from GSeek.zip, including the solution to the problem described below. The … Continue reading →

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

Using RC Design Functions – 2

Posted on May 18, 2013

In the previous post we looked at a summary of the functions in the RC Design Functions spreadsheet, and ways of using the EStress function (download file with examples).  In this post we will look in more detail at the … Continue reading →

Posted in Excel, UDFs, Newton, Concrete, VBA | Tagged , , , , , | Leave a comment

A Fish Called Newton

Posted on May 17, 2013

From Big Questions Online (via Letters to Nature): By Frank Wilczek     April 22, 2013 Imagine a planet encrusted with ice, beneath which a vast ocean lies. (Imagine Europa.) Within that ocean a species of brilliant fish evolved. Those fish were … Continue reading →

Posted in Newton | Tagged , , | Leave a comment

While sitting in a tin can …

Posted on May 13, 2013

… astronaut Chris Hadfield has created a video cover of David Bowie’s “Space Oddity” made on location in the International Space Station: and a damned good job he made of it too. Top comment: I can’t stop watching this. Seriously.. everything … Continue reading →

Posted in Bach, Newton | Tagged , , , | Leave a comment

Using RC Design Functions – 1

Posted on May 10, 2013

Download RC Design Functions (includes full open source code) and EStress Examples.xlsx This series of posts will cover ways of using the many functions contained in the RC Design Functions spreadsheet, starting with some general comments on using the User … Continue reading →

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , | 11 Comments