News Shop
Events Forums

Codex Tracking Spreadsheet

The cell formatting is not moved around to follow the text in each cell. A specific cell could have turned red text due to a stray keyboard press or perhaps that cell is formatted red in the current sheet.

1 Like

I’ve updated my output formatter with some new features and some minor bug-fixes and improvements. The forums won’t let me update my previous post, so here’s the new link.

Features:
The following special terms can be used in the “Board” or “Actions” columns to create new post sections similar to “In Play:”: Upkeep, Main, Future, In Graveyard, Jailed, On Loan, and Trashed.

Building HP set to 99 will be converted to ∞

2 Likes

It would appear this thread needs to be PINNED again.

@Leontes can you help?

the spreadsheet does not work for me. I have to use the buttons for mobile, otherwise it says there is an error and the script does not work.

The buttons trigger a security message, and certain google account settings can cause it to be automatically rejected, causing it to not work. When I use a new copy of the spreadsheet for the first time, I have to authorize the scripts to run after pressing a button for the first time.

2 Likes

i get the prompt, i do authorize the scripts, and get the error message.

1 Like

In that case, I do not have a good answer, I am not able to replicate the problem you describe using a fresh copy of the sheet.

1 Like

I got the problem. Ffox now disables pop ups, so it blocks the prompt for codex pbp helper. One has either to allow google docs to open pop ups or use chrome

4 Likes

Suggestion: it would look a little better if the patrol zone was formatted as a table. Sometimes unit names are different lengths and it makes the patrol zone hard to read at a glance, for example someone can miss a patroller in elite because they don’t ‘stick out’ far enough. a table would make them aligned more evenly.

output:

Patrol Zone
:psblueshield: Squad Leader: Fox Primus
:psfist: Elite: Rook
:ps_: Scavenger: savior monk
:pschip: Technician: sparring partner
:target: Lookout:

source (reference):

| Patrol Zone | |
|:---|---:|
| :psblueshield: Squad Leader: | Fox Primus |
| :psfist: Elite: | Rook |
| :ps_: Scavenger: | savior monk |
| :pschip: Technician: | sparring partner |
| :target: Lookout: | |
1 Like

Easy enought o implement.

I will say that adding the stats (eg 2/4, 3/3+A, 2/1, etc) helps to clue in there’s a patroller.

i’m soo lazy though. speaking of which another idea would be adding in an auto-generated ‘command zone’ with hero names and level 1 stats for easier copy/pasting

1 Like

That wouldnt be too hard, just have to decide where in the sheet to put it. Maybe at the bottom of the patrol zone.