Comment from Tony
Time: Wednesday, June 18, 2008, 10:59 am

Great idea Jon. Maybe the Projectile Trajectory project can somehow lower my golf score. I’ll have to play with it.

I’ll ping this post in an upcoming blog post on DSA Insights.

Good luck!

Comment from Stewart McNaught
Time: Wednesday, June 18, 2008, 2:55 pm

Golf is a game whose aim is to hit a very small ball into a even smaller hole, with weapons singularly ill-designed for the purpose.
– Winston Churchill

Comment from Timothy Bard
Time: Wednesday, June 18, 2008, 2:57 pm

Here is a link to a zipped spreadsheet that plots the Lorentz Attractor.

http://www.freefilehosting.net/download/3ifhl

From wikipedia… “The attractor itself, and the equations from which it is derived, were introduced by Edward Lorenz in 1963, who derived it from the simplified equations of convection rolls arising in the equations of the atmosphere.”

Comment from Doug Glancy
Time: Wednesday, June 18, 2008, 3:03 pm

According to http://www.cemc.org/cjgt/trivia.htm it was Winston Churchill who said that. He also supposedly said, while mocking an uptight grammarian, “This is the sort of stilted English up with which I will not put.”

Comment from derek
Time: Thursday, June 19, 2008, 2:48 am

Our only prime minister to get the Nobel Prize for Literature.

Comment from Timothy Bard
Time: Thursday, June 19, 2008, 3:18 pm

Here is my second entry:

http://www.freefilehosting.net/download/3iga0

This spreadsheet charts a diffusion-limited aggregation pattern.

From wikipedia… “DLA can be observed in many systems such as electrodeposition, Hele-Shaw flow, mineral deposits, and dielectric breakdown.”

Comment from John Doyle
Time: Thursday, June 19, 2008, 6:32 pm

I have created a website at http://www.excelcalcs.com for people to share and discuss engineering and science problems in Excel. It would be great to have some of you guys visit sometime.

Comment from John Doyle
Time: Friday, June 20, 2008, 4:40 am

Jon we have a monthly newsletter so I’ll let all our users know about your competition in the next edition. At http://www.excelcalcs.com our solved problems cover many subjects including Strength, Beams, Buckling, Civil Engineering, Cracks, Finite Element, Frames, Materials, Plates, Stress Concentration, Structural Details, Torsion, Pressure Vessels, Machine Design, Bolts and Threads, Gears, Pins and Joints, Ropes and Cables, Shafts, Welds, Math, Geometry, Heat Transfer (Conduction, Convection, Radiation & Combined), Dynamics, Fluids Mechanics, Piping, Electricity and Finance.

Many of the calculations require the XLC addin to be installed - this displays Excel Cell formulae as Mathematical notation. It is very useful if you need to present the calculation method like in a set of engineering calculations. It is also a very useful teaching tool. Our users say it gives MathCad functionality to Excel and its all free.

Pingback from DSA Insights » Blog Archive » Microsoft Excel Contest!
Time: Friday, June 20, 2008, 8:08 am

[...] you want to win this book or a $25 Amazon gift card?  Jon’s blog at Peltier Technical Services is running an Excel contest.  Check out Jon’s blog for [...]

Pingback from Weekend Minis For Your Lazy Weekend - 6/21/08 | FlowingData
Time: Saturday, June 21, 2008, 4:56 am

[...] Excel Contest for Science and Engineering - Jon Peltier, a frequent FlowingData commenter, is running a contest on modeling science and engineering. The key phrase is - A winner will be drawn at random. [...]

Comment from Doug Jenkins
Time: Saturday, June 21, 2008, 8:03 am

Jon - here are my three entries:

Section properties of defined shapes and section properties from coordinates (also includes “evaluate” function):
http://www.interactiveds.com.au/software/Section%20Properties03.zip

UDFs for trignometric functions:
http://www.interactiveds.com.au/software/TrigFuncsVBA.zip

UDFs for elastic analysis of reinforced concrete and prestressed concrete sections under combined bending and axial load. As far as I know these include the only published closed form solutions for finding the neutral axis of beams of complex (i.e. non-rectangular) cross section. Also included are UDFs for solving quartic, cubic and quadratic equations, and routines for plotting shapes from coordinates:
http://www.interactiveds.com.au/software/Beam%20Design%20Functions.zip

See: http://newtonexcelbach.wordpress.com/ for more

Comment from Keith Halford
Time: Monday, June 23, 2008, 11:48 pm

Jon,

My entry is http://pubs.usgs.gov/sir/2006/5024/

Simple models have been developed for estimating unpumped water levels during aquifer tests that are referred to as synthetic water levels. These models sum multiple time series such as barometric pressure, tidal potential, and background water levels to simulate non-pumping water levels. The amplitude and phase of each time series are adjusted so that synthetic water levels match measured water levels during periods unaffected by an aquifer test. Differences between synthetic and measured water levels are minimized with a sum-of-squares objective function.

Pingback from Code For Excel And Outlook Blog » Blog Archive » Calculate Working Hours in VBA
Time: Tuesday, June 24, 2008, 1:03 pm

[...] For you Excel charting and modeling fans, Jon Peltier (Excel MVP) is having acontest on his blog, if you have developed a scientific or engineering model in Excel, submit it and maybe it will pay [...]