Google Apps Scripts for 18xx

From BOARD18 Project WIKI
Revision as of 16:44, 25 September 2017 by Rich (talk | contribs) (→‎Introduction)
Jump to navigation Jump to search

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 such a spreadsheet for 18EU using Google Apps Script combined with the formulas documented in my WIKI article at Spreadsheet Formulas for 18xx.

The resultant spreadsheet is here. This article documents the three scripts (functions) used in this spreadsheet.

The newTab function

The showPrompt function

The shareAdjust function

The Button