18xx "Super Scripted" Sheets to Facilitate Online Play
Aaron Percival
Canada
Ottawa
ON
flag msg tools
badge
A strange game. The only winning move is not to play. How about a nice game of chess?
Avatar
Microbadge: MLB fanMicrobadge: PhysicistMicrobadge: I like to grillMicrobadge: Home BrewerMicrobadge: Canadian Wargamer
Recommend
26 
 Thumb up
8.00
 tip
 Hide
This is a list of the "Super Scripted" spreadsheets I have created to facilitate online play of various 18xx titles using Board18 (or other).

You can find a folder of all sheets here:
https://drive.google.com/drive/folders/1t74ef2crj7HJRquTRuZF...

In general, my Super Scripted sheets all have the following features:
- Automate setup: randomize the player order and set starting values
- Facilitate the privates auction
- Automatically create the next sheet, rename it according to the next phase and transfer over appropriate values
- Link cash and worth to the previous sheet so any changes will propagate forward if a mistake was made

These sheets are based on the layout and design of Richard Price's Board18 sheets. Richard's work is found here: https://drive.google.com/drive/folders/0B-wwptMMyHTAN0IzYlpM...

The scripts in these sheets requite authorization to run. See Richard's instructions here for more information about this:
http://wiki.board18.org/w/18xx_Dream_Spreadsheet_Authorizati...

In general, the Board18 wiki is a good source of information on how to play 18xx online using these sheets:
http://wiki.board18.org/w/Main_Page

All of my work is shared though CC BY-NC-SA 4.0
Creative Commons Attribution-ShareAlike 4.0 International
https://creativecommons.org/licenses/by-nc-sa/4.0/

Sheets marked as BETA may have significant bugs.
Beta sheets require more testing and a keen eye.

Please comments under each item to bugs


Your Tags: Add tags
Popular Tags: 18xx [+] [View All]
  • [+] Dice rolls
1. Board Game: 1849: The Game of Sicilian Railways [Average Rating:8.24 Overall Rank:1872]
Board Game: 1849: The Game of Sicilian Railways
Aaron Percival
Canada
Ottawa
ON
flag msg tools
badge
A strange game. The only winning move is not to play. How about a nice game of chess?
Avatar
Microbadge: MLB fanMicrobadge: PhysicistMicrobadge: I like to grillMicrobadge: Home BrewerMicrobadge: Canadian Wargamer
Version 2.1

Main Functionality:
- Randomize Player order and set scenario (cert limits, starting cash, etc).
- Randomize corporation order and remove a corporation if playing small scenario
- Facilitate private auction
- Automatically create next sheet
- Link cash and worth to the previous sheet so any changes will propagate forward if a mistake was made
- Create the correct number of ORs between SRs based on game phase
- Copy Privates owned to income when OR
- After SR ask for new PD

Release History

v2.2
- Fixed token fee setup bug

v2.1
- Minor formatting adjustments

v2.0
- Small formatting changes to add Lira symbol and protect formula cells
- Sequence companies by order on operation pages (at initialization)
- In Scenario 5, grey out company that is not used.

v1.6
Added conditional formatting to point out errors on the sheet

v1.5
Modified company dividend formula to account for stock issues/buybacks during ORs

v1.4
- Ask for and set PD after SR

v1.3
- Automatic validation of valid scenarios for player counts

v1.2
Bug fixes: company cashflow formula error, certificate calculation
Added Row for PD

v1.1
Changed layout
Added dependancy between sheets using INDIRECT function

v1.0
Initial sheet
Added automation for player order and company order
 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Loading... | Locked Hide Show Unlock Lock Comment     View Previous {{limitCount(numprevitems_calculated,commentParams.showcount)}} 1 « Pg. {{commentParams.pageid}} » {{data.config.endpage}}
{{error.message}}
{{comment.error.message}}
    View More Comments {{limitCount(numnextitems_calculated,commentParams.showcount)}} / {{numnextitems_calculated}} 1 « Pg. {{commentParams.pageid}} » {{data.config.endpage}}
2. Board Game: 1867: The Railways of Canada [Average Rating:7.65 Unranked] [Average Rating:7.65 Unranked]
Board Game: 1867: The Railways of Canada
Aaron Percival
Canada
Ottawa
ON
flag msg tools
badge
A strange game. The only winning move is not to play. How about a nice game of chess?
Avatar
Microbadge: MLB fanMicrobadge: PhysicistMicrobadge: I like to grillMicrobadge: Home BrewerMicrobadge: Canadian Wargamer
Version 0.5 - BETA

Main Functionality:
- Randomize Player order and set scenario (cert limits, starting cash, etc).
- Facilitate private auction
- Automatically create next sheet
- Link cash and worth to the previous sheet so any changes will propagate forward if a mistake was made
- Create correct number of ORs between SRs based on game phase.
- Create MRs in phases 3 to 7.
- Copy Privates owned to income when OR
- After SR ask for new PD

Release History

v0.7 BETA
- Bug fixes

v0,6 BETA
- Added Automatic loan calculation

v0.5 BETA
Initial sheet
 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Loading... | Locked Hide Show Unlock Lock Comment     View Previous {{limitCount(numprevitems_calculated,commentParams.showcount)}} 1 « Pg. {{commentParams.pageid}} » {{data.config.endpage}}
{{error.message}}
{{comment.error.message}}
    View More Comments {{limitCount(numnextitems_calculated,commentParams.showcount)}} / {{numnextitems_calculated}} 1 « Pg. {{commentParams.pageid}} » {{data.config.endpage}}
3. Board Game: 18Ireland [Average Rating:7.92 Overall Rank:4181]
Board Game: 18Ireland
Aaron Percival
Canada
Ottawa
ON
flag msg tools
badge
A strange game. The only winning move is not to play. How about a nice game of chess?
Avatar
Microbadge: MLB fanMicrobadge: PhysicistMicrobadge: I like to grillMicrobadge: Home BrewerMicrobadge: Canadian Wargamer
Version 1.0

Main Functionality:
- Randomize Player order and set scenario (cert limits, starting cash, etc).
- Create game setup including shuffling minors and selecting privates
- Facilitate private auction
- Automatically create next sheet
- Link cash and worth to the previous sheet so any changes will propagate forward if a mistake was made
- Create the correct number of ORs between SRs based on game phase.
- Create MR after second OR if a 4T is purchased.
- Copy Privates owned to income when OR
- After SR ask for new PD

Release History
v1.0
First stable release

v0.10
Bug fix in the formula for certs and shares

v0.9
- Bug fix (clearing cells in corps on the new sheet)

v0.8
- Bug fixes (formulas)

v0.7
- Minor formatting adjustments

v0.6
- Formatting changes and cell protection

v0.5 BETA
Initial sheet
1 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Loading... | Locked Hide Show Unlock Lock Comment     View Previous {{limitCount(numprevitems_calculated,commentParams.showcount)}} 1 « Pg. {{commentParams.pageid}} » {{data.config.endpage}}
{{error.message}}
{{comment.error.message}}
    View More Comments {{limitCount(numnextitems_calculated,commentParams.showcount)}} / {{numnextitems_calculated}} 1 « Pg. {{commentParams.pageid}} » {{data.config.endpage}}
4. Board Game: 18MEX [Average Rating:7.85 Overall Rank:2596]
Board Game: 18MEX
Aaron Percival
Canada
Ottawa
ON
flag msg tools
badge
A strange game. The only winning move is not to play. How about a nice game of chess?
Avatar
Microbadge: MLB fanMicrobadge: PhysicistMicrobadge: I like to grillMicrobadge: Home BrewerMicrobadge: Canadian Wargamer
Version 1.5

Main Functionality:
- Randomize Player order and set scenario (cert limits, starting cash, etc).
- Facilitate private auction
- Automatically create next sheet
- Link cash and worth to the previous sheet so any changes will propagate forward if a mistake was made
- Create the correct number of ORs between SRs based on game phase
- Copy Privates owned to income when OR
- After SR ask for new PD

Release History
v1.4
Bux fixes

v1.4
Formatting changes

v1.3
Formatting and formula changes to allow minor shares to be deleted but have dividends calculated correctly for the current OR

v1.2
Cell protection and formatting changes

v1.1
Changed layout
Minor fixes

v1.0
Initial sheet
 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Loading... | Locked Hide Show Unlock Lock Comment     View Previous {{limitCount(numprevitems_calculated,commentParams.showcount)}} 1 « Pg. {{commentParams.pageid}} » {{data.config.endpage}}
{{error.message}}
{{comment.error.message}}
    View More Comments {{limitCount(numnextitems_calculated,commentParams.showcount)}} / {{numnextitems_calculated}} 1 « Pg. {{commentParams.pageid}} » {{data.config.endpage}}
Loading... | Locked Hide Show Unlock Lock Comment     View Previous {{limitCount(numprevitems_calculated,commentParams.showcount)}} 1 « Pg. {{commentParams.pageid}} » {{data.config.endpage}}
{{error.message}}
{{comment.error.message}}
    View More Comments {{limitCount(numnextitems_calculated,commentParams.showcount)}} / {{numnextitems_calculated}} 1 « Pg. {{commentParams.pageid}} » {{data.config.endpage}}