Posted in Spectroscopy

Excel Roller Coaster – Yes, my hobby is Excel

If you have FUN programming Excel, on a SATURDAY…You MIGHT be a Redneck I mean, you might be a PCHEMIST.

DLWilliamsExcelRollerCoaster1

Years ago, I was at home on a Saturday fiddling with a wave function problem in Excel. The plot on the screen was of a couple of cosines, and my 8-year-old son said, “Hey that looks like a roller coaster”.

“It sure does.” I said. “Do you want to make a roller coaster in Excel?”

“Yes!”, he said.

So over the next four hours we had some quality father son time making a roller coaster in Excel. He learned something about cosine functions, and how to put custom backgrounds on a chart. Some of the finer details he did not care much for were anchoring cells, negative error bars, or the mod() function. But he really appreciated the custom look of a white wooden roller coaster and the looping macro that made the coaster run along the track.

You can download the macro-enabled (.xlsm) workbook file from my curiosities page to see how these functions and settings were used. Here is a time-lapse video of my creating the page from scratch. There are some fun tricks so I hope you enjoy it. the background loop is a bit annoying. Sorry.

The coaster uses an infinite loop. To kill it just click Ctrl+Break, and it will stop.

What Excel awesomeness to you have to share? What questions do you have about these functions and settings in this fun application?

Ask in the comments field, and subscribe for more fun in the future (like my Sudoku solving spreadsheet).

Advertisements

Author:

Dr. Darren L. Williams (pchem4u) is an Associate Professor of Physical Chemistry at Sam Houston State University. When he is not blending solvents, he is tinkering with contact angle measurements, FTIR microspectroscopy, etc. http://www.shsu.edu/~chm_dlw/ . He welcomes your comments and questions by phone (936-294-1529) and by email (williams “at” shsu.edu).

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s