Dream Spreadsheets

From BOARD18 Project WIKI
Revision as of 11:35, 5 June 2021 by Rich (talk | contribs) (→‎Other Instrumented Spreadsheets: initial contents)
Jump to navigation Jump to search

Introduction

Original Introduction

To paraphrase Jonathan Coveney: The dream spreadsheet for 18xx PBEM would:

  • Cause changes in the past spreadsheet tabs to flow forward to the future tabs.
  • Create a new tab with one click.

I have created a large number of spreadsheets that meet this criteria. I have decided to call these spreadsheets “Dream Spreadsheets”.

This page is intended to document how to create and how to use dream spreadsheets. It also contains links to three other pages that talk about specific issues in creating dream spreadsheets. These pages are:

Updated Introduction

An amazing amount has happened in the year since I proposed the concept of dream sheets. The number of dream sheets now exceeds the number of other sheets in my “spreadsheet templates” folder.
And other non dream sheet, but still highly instrumented, sheets have been written. Their existence and methodology should be documented.

So it is past time to upgrade the documentation for dream sheets and other highly instrumented sheets. This will involve changing or adding some pages here.
It will also involve changing some of the documentation text files in the “spreadsheet templates” folder.
These necessary changes are currently a work in progress. "Please pardon our dust."

Existing Dream Spreadsheets

There is a text file in my Spreadsheet Templates directory that contains a partial list of the existing Dream Spreadsheets and their status.
Note: This list is out of date and is no longer being maintained!
Note also that almost all dream spreadsheets can be recognized by having a suffix of ver2 or ver with a different numeric character.

The process of creating dream spreadsheets [and other instrumented sheets] has evolved as I and many others have continued to create them.
One of the most noticeable change in dream spreadsheets as the creation project process has evolved is in the use of colors for the spreadsheet cells.
My current thoughts in this matter are mentioned below. Also, Paul Zieske has created this 2 page document containing his thoughts on dream spreadsheets.

Cell Background Colors

The data entry portion of a dream spreadsheet uses the same light grey and dark grey color pattern [used on alternate rows] that many pre-existing spreadsheets seem to use. The exact definitions of these colors are RGB(230,230,230) and RGB(179,179,179).

The formula portion of a dream spreadsheet uses the same light orange and dark orange color pattern [used on alternate rows] that many pre-existing spreadsheets seem to use. The exact definitions of these colors are RGB(255,204,153) and RGB(255,153,102).

The remaining cells on a dream spreadsheet use standard Google Sheets colors found on the second row of the Fill Color drop-down box on any Google sheet. Cyan is used for Headings and Yellow is used for Constants. These two colors do not use a light/dark color pattern.

NOTE: Players should only type in data entry cells.

Other Thaughts on Dream Spreadsheet Design

I have started to always place the word "Players" in Cell A1 instead of the formula for the number of players. I moved this formula to Cell A2. This is because the default location for the cursor on opening a sheet is Cell A1 and the formula in the "fx" row can be confusing.

Other Instrumented Spreadsheets

The sheets that I have referred to as Dream Spreadsheets are not the only sheets that meet the
So how do you recognize a true Dream Spreadsheet? If the sheet contains a "New Tab" button then it is probably a Dream Spreadsheet.