Spreadsheet Day Rotating Header Image

Spreadsheet Planning: Excel Saves Halloween

Well, maybe Excel didn’t actually save Hallowe’en, but it helped the Double Fine video game company allocate staff for their Hallowe’en game — Costume Quest.

costumequest

In an interview at MTV, Tim Schafer, Double Fine’s president and CEO, described how the staff members, who had previously all worked on the same project, were split into four working groups.

"we let people fill out a form where they got to rank which game they worked on and then we also let the leaders on each team rank who they wanted on their team. We had this amazing Excel spreadsheet that, somehow, using algebra, or possibly calculus, decided the intersection of those two ranks to put everyone on the team they most wanted to be on and also where they were most needed."

Unfortunately, they didn’t share the Excel file or the magical formulas, but maybe you’ve done something similar at your own workplace. Or maybe that’s how you decide which of your children get to wear which Hallowe’en costume!

_________

Spreadsheet Cooking: Jarring Numbers

imageHave you ever made your own jam? I’ve made strawberry jam a few times, and it’s delicious, but lots of trouble to make. It’s much easier to grab a jar from the grocery store.

On the AnnArbor.com website today, Corinna Borden uses a spreadsheet to compare the costs of homemade blueberry and blackberry jams to organic store bought jams. She had enlisted her family’s help in picking the berries, and "I was hoping to show I am saving my family money by doing it myself."

There’s no sample spreadsheet to download, but you can view the cost comparison online. Corinna even adds cost a per ounce carbon footprint to the jams, to see how that affects the totals.

 jam01

Unfortunately, it’s not more cost effective to make your own jam at home, according to Corinna’s calculations. However, she’ll keep doing it, because you can’t beat the value of the "priceless intangible benefit".

__________

Spreadsheet Planning: Home Improvement

imageSpreadsheets aren’t just for project planning at the office — it’s great for planning home improvement projects too.

Fred Chidester Sr., who claims to be in his 70s (hard to believe!), is always looking for new ways to use Excel. He’s currently working on a bathroom renovation, and sent me the Excel file that he’s using to plan and manage the project.

A man of few words, Fred didn’t bore me with all the details, and simply described his workbook as:

It isn’t pretty, but it is getting the job done.

Planning the Renovation Budget

Despite Fred’s modest description, the workbook efficiently packs several tasks into a few sheets. On one worksheet, Fred keeps a list of supplies, with the order status, quantities and costs. 

BathReno01

On another sheet, Fred keeps track of the daily start and end times, and totals the material, labor, and other costs.

Designing the Renovation

Another sheet in the workbook as the bathroom layout, for the floors and wall tiles.

BathReno02

There’s even a picture of the tiles that will be used.

BathReno03

Download the Bathroom Reno Sample File

You can download Fred’s bathroom renovation Excel file, to see how it works. Thanks Fred!

If you have any interesting or unusual spreadsheets of your own that you’d like to share, please let me know at ddalgleish AT contextures.com.

________________

Spreadsheet Games: The Game of Life

When I asked people to send examples of interesting things they were doing with spreadsheets, Peter Burke sent this example of John Conway’s Game of Life simulator, programmed in Excel.

GameLife01 

Peter, who’s from Glasgow, Scotland, explained how his program came about:

We hold coding dojo’s (http://codingdojo.org/cgi-bin/wiki.pl?WhatIsCodingDojo ) and one of the subjects was coding a game of life simulator.. needless to say, my excel offering was the only working version at the end of the two hours…

The Game of Life Rules

The Game of Life is based on a starting pattern in a grid, where every cell has 8 neighbours. From that initial pattern, the game progresses in steps. The rules are simple — at each step in the game:

  1. A live cell stays alive if it has 2 or 3 live neighbours, otherwise it dies.
  2. A dead cell comes to life if it has exactly 3 live neighbours, otherwise it stays dead.

How the Game of Life Simulator Works

In Peter’s version of the Game of Life simulator, you can start fresh, by clicking the "All Dead" button. Then, create your own starting pattern, by selecting from the drop down lists in the grid, to make cells Live (L) or Dead (D).

There are also a couple of preset starting patterns, and you can add those by clicking "Create Glider" or "Create Spaceship".

You can adjust the maximum number of steps, and the wait time between steps.

Then, click the "Step Thru" button, to start the game, and click Stop, or let the game run its course. You’ll see the current step number at the top of the worksheet, in cell Q2.

GameLife02

Download the Game of Life Sample Excel File

You can download Peter’s Game of Life Excel file, and experiment with your own starting patterns. The file is zipped, and in Excel 2003 format. It has macros, so you’ll have to enable them to test the game.

I made one minor tweak to Peter’s code, by removing a "Select" statement, so the game would be a bit less jumpy.

How Do You Use Spreadsheets?

What unusual spreadsheet applications have you created? If you have something you can share, please let me know ddalgleish AT contextures.com.

________________

Spreadsheet Travel: Camping Checklist

imageDo you ever go camping? My family had camping vacations every summer, when I was growing up, and Dad always had everything meticulously organized. Those were the dark ages, before spreadsheets had been invented, so he probably had our supply lists written on graph paper, or something equally high tech.

My daughter went camping with friends this weekend, and I was impressed to learn that she planned the whole thing with an Excel checklist. Nice to know that it runs in the family!

Perhaps you have your own camping checklist, in Excel, or another program. If not, there’s a free checklist available for download on the Microsoft Office Templates site: Camping Checklist

camping01

___________

Spreadsheet Creativity: Christmas in July

christmas treeThe local malls like to promote Christmas in July sales, so maybe you need a greeting card for this fake festive season.

Thanks to Dermot Balson, from Modelling in Excel, your Christmas dreams have come true. As a break from his serious actuarial work, Dermot created an animated card in Excel.

christmascard

Dermot says he borrowed the text from an old greeting card, when he made this spreadsheet, many years ago.

You could adapt it for different occasions, by changing the picture and text, and modifying Dermot’s code slightly, to adapt to the new graphic objects.

Download the Sample File

To see Dermot’s animated greeting, and the code that makes it work, you can download the animated Excel greeting card. You’ll have to enable macros when you open the workbook, to see the animation.

____________

Stay Healthy with the Spreadsheet Diet

imageIf you spend most of your time sitting in front of a spreadsheet, you might suffer from a spreading waistline. You can monitor your weight with a spreadsheet, and keep track of what you’re eating, to help solve the problem.

The Spreadsheet Diet

As a preventive measure, you can follow a healthy meal plan by using The Spreadsheet Diet, which was created in 2006 by Ed Bruske. He described the diet in a Washington Post article, including a few recipes, and a list of the spreadsheet categories.

How It Works

To get started, you’ll enter all the food categories in spreadsheet columns, then create meals by selecting one  or more items from each column.

spreadsheetdiet

Bruske describes how to use the categories:

"Starting with whole grains in the vertical column of my version of a Kitchen Excel sheet, my eyes move across the horizontal axis and I pick up vegetables, nuts, vinegars and olive oil to complete my dish."

For more information on how the Spreadsheet Diet works, you can read the instructions from the Washington Post article (near the bottom of the linked page).

Would You Try It?

The Spreadsheet Diet is meat-free, and feta cheese is the only dairy product that I see listed. I’m sure it’s healthier than my normal diet, but it doesn’t look too appealing. It’s an interesting concept though, and maybe I can adapt it for my own use.

How about you? Would you plan your meals or recipes, using ingredients from spreadsheet category column?

____________ 

Spreadsheet Savings: Calculate Lunch Costs

image If you find yourself running out of money before the end of the month, maybe a spreadsheet can help. If you don’t have the strength to put together a detailed personal budget, you could start by keeping track of your lunch costs.

I saw this posted in Twitter last week:

"My friend in a local CBS special about brown bagging his lunch. I am fairly certain he does not keep a spreadsheet"

At the end of that post, there was a link to a CBS video, with a news report from 2008. In the video, you can see one frugal worker, who estimates his lunch costs  in an Excel file.

lunchcost

CBS estimates that he’ll accumulate over $100,000 by making his lunches for the next 20 years, and investing the savings.

So, are you making your lunches, and keeping track in a spreadsheet?

__________

Spreadsheet Creativity: Streaming Radio

radiostreaming01Just because you spend the day in a cubicle, staring at spreadsheets, doesn’t mean you shouldn’t have a bit of entertainment. Along with your analysis of banknotes, you can enjoy a few musical notes.

Excel Based Web Radio

In today’s example of spreadsheet ingenuity, Harald Staff, a Microsoft Excel MVP for several years, shares his Excel based web radio workbook. In addition to his musical skills, Harald answered thousands of Excel questions in the Microsoft Excel newsgroups, and created an Excel FAQ list, and an Introduction to Pivot Tables.

Operate the Radio

The web radio workbook is small, and easy to use.

  • Open the Web Radio file, and enable macros.
  • Double-click on one of the radio station names in column A, to play that station, in the embedded player.
  • You can add or remove stations in the list, to suit your musical taste, or lack of taste.

radiostreaming

Download the Web Radio Sample File

You can click this link to download Harald’s Sample Web Radio file. The file is zipped, and in Excel 2003 format.

__________

Spreadsheet Good: Taking Care of a Friend

image Maybe you use a spreadsheet to create your grocery list, or keep track of your daily tasks. Frat brothers from the University of Virginia have taken those ideas, and added a splash of good will, to help out an old friend — their former housefather.

As reported in the Charlottesville Daily Progress, Billy Hearns worked at their Chi Psi fraternity for 50 years. Frat brothers from those five decades are now working together, to ensure he’s well fed and cared for, during his retirement.

So, how does a spreadsheet play a part in this heartwarming story?

The frat brothers created a spreadsheet signup sheet for Hearns’ meals and each person chooses a week during which they plan his meals and pay a local catering company that delivers the meals.

What a great way to use a spreadsheet! Have you heard of any other philanthropic uses for Excel, or another spreadsheet program?

_____________