Table Spreadsheet

< CS101

Math Paradigms

Spreadsheet software - many options: Google docs has a free spreadsheet in the browser, and now Microsoft has a free browser one too with skydive. There's also the free application you can install LibreOffice. And the famous Microsoft Excel spreadsheet products which work great and are kind of expensive. Any of these will work for all our examples and homeworks.

Aside: Design History

Monster Example

Monster example spreadsheet in google docs. Below we'll use this as a running first example.

To edit above: either (a) In google docs: File > Make Copy to edit. or (b) File > Download As > .xlsx file, and then edit using any program.

For references here is the monster spreadsheet in completed form

1. Spreadsheet Cells and Naming

Experiment: click on a cell, note its "address" B1 or whatever, type in a word or number

2. Columns of Numbers

3. Add Computation: sum()

From the headlines: Reinhart and Rogoff had a popular economics paper supporting austerity, but it had a significant spreadsheet bug. Essentially they wrote something like sum(a1:a8) when they intended (a1:a11), so they left out some numbers. This bug was significant in the paper's results. The subsequent history of the great recession has shown austerity to be a bad idea. Note when you double-click a cell, it shows you what it depends on to help avoid this sort of bug. It's amusing that such high level research can have ordinary bugs just like the rest of us, although of course this should be no surprise. Bugs are a common part of software.

4. Add Computation: + - * /

5. Extreme Magic: Fill Right

6. Chart Magic

Here's a picture of it in done form:
finished monster spreadsheet

Compute average with average(a1:a10)

2. Cell Phone Example - You Try It