Wednesday, March 6, 2013

(Technical) Fun With Spreadsheet Design




Here I go again... spelunking into the depths of Microsoft's Excel Caverns, only to emerge for an occasional cup of tea, and to write a few notes about what it is I hope to accomplish with a bunch of numbers and a variety of software applications.

The image at the top of this article (click to enlarge) is a simple screen capture of my current project, which currently serves no definitive purpose other than to grind-up an integer, and look somewhat curious; my hope is for it to act as a foundation for greater imaginings.

It is in fact a working slide rule of sorts. I built the whole thing off the cuff in about a half an hour. The pink cell is the only input... the rest of the numbers are derivatives. It's at the middle of the leftmost column after [MAGIC NUMBER], the one that reads "222" and can be any integer.

Any good spreadsheet intended for the general reading public should include a concise and comprehensive graph or two. Or as many graphs as the designer sees fit, I guess. This designer sandwiched the cell that reads [MAGIC NUMBER] between two interpretive graphs: a ring chart, and a small bar graph. Behind the bar graph, I inserted a background of a scanned image of John Lennon 7" single, "Mother" still in its original Apple Records' sleeve. The charts are populated with data sourced from some of the derivations throughout the chart.

Well that's it for tonight. 

No comments:

Post a Comment