Codex Tracking Spreadsheet

That’s the action of hiring a worker, which costs 1 gold. If you look way below there, it should show how much gold you have left after hiring a worker (and any other actions you take).

That’s automatic. Don’t worry about it.

That’s also automatic. As long as you put whatever card you turn into a worker in the workers column, it’ll give you the correct amount of gold for your next turn when you click discard/draw.

2 Likes

Hobusu is correct, but don’t forget that if your scavenger dies then you’ll have to manually enter the extra gold from that on your next turn.

@zhavier: It might be a good idea to provide some additional instructions for users in the OP. I imagine an additional paragraph or so would preempt a lot of questions.

1 Like

Yeah, I forgot about that one. Still, that’s the only part that has to be done manually that has to do with gold.

This would be extremely helpful! Especially since people are sometimes asking the same questions as each other, a small FAQ box somewhere on the sheet would reduce the number of questions by quite a bit.

One suggestion I’d like to make is adding an indicator for how many workers you have at a given moment. It’s not hard to figure it out manually once you understand the sheet, but it would help new users a lot by making it clearer that “Worker -1” is an action. Actually, that would also be a lot clearer if it said “Hire a Worker” instead – then there would be no ambiguity (but people would still ask how to see the number of workers they have, so my first request stands).

2 Likes

I humbly request a list of frequently asked questions with answers, as I am not sure when I will get around to this. If someone kindly creates it, I’ll add it to the OP.

5 Likes

Worth noting that this is basically just a timesaving thing. It won’t adjust your number of workers, for one. (The spreadsheet calculates Worker # by looking at whether you’re P1 or P2, then adding the number of cards in your Workers column.)

2 Likes

I noticed a minor bug with how stash is implemented with regards to the generated post. When you stash a card, it won’t show up in the “Starting Hand” part of the generated post for the next turn. For example, take a look at this game. On turn 7, I stashed Injunction. My new hand spoiler for turn 7 correctly lists Injunction in my new hand. But, when you look at turn 8, the starting hand spoiler only lists the 3 other cards.

3 Likes

Thank you for finding this! I think I know how to fix it…

3 Likes

Do you have any ideas about how to handle Prynn’s midband?

Manual editing is technically easier than the more technical version. Alternately place a bunch of x “cards” in the deck and move the actual deck cards somewhere else. Then just move the cards from discard back into your hand and put the deck cards back and hit generate again.

I do know how I could implement it as an actual function of the sheet, along with shrine of forbidden knowledge. I just haven’t gotten around to it

There’s also a bug when you peek at the top card of your deck. When you generate the next turn, the “discard, draw, reshuffle” bit at the bottom displays as if you actually have one less card in your deck (so it says you reshuffled when actually you didn’t if you drew the rest of your deck).

2 Likes

Ok, i’ll look into that!

Peek bug saying reshuffle when no reshuffle happened is fixed.

Stash bug not showing the stashed card in “starting hand” spoiler is fixed.

Current Open Feature Requests:

  1. Quick Deck Selection menu for the 6 Monocolor decks.
  2. Prynn’s Midband function: Currently requires manual editing of generated post and moving the cards back to their appropriate positions
  3. Shrine of Forbidden Knowledge Function: Currently almost works, except tech choices have to be manually readded.
2 Likes

I recommend not worrying about Prynn’s Midband unless it starts actually happening more often than “basically never.”

Twice I have been asked how to deal with it, and I should note the implementation is actually pretty easy. I just need to actually do it and make sure it works.

But you are right, it is basically never.

It happened to me in my RACE game against Jadiel. That’s why I brought it up.

All 3 features have been added! Bug Reports are strongly encouraged.

There are now quick deck selection menus for your own deck and your opponents deck just to the right of where you enter your deck choices.

Below the peek, discard and draw functions, there are now 2 fields which govern Skipping Discard/Draw and drawing extra cards for Shrine of Forbidden Knowledge (either 1 or 2 extra, for 1 or 2 active shrines)

5 Likes

First time poster, long time lurker of this forum, and as a fellow programmer, I must say these spreadsheets are amazing !

I’m eager to start playing PbF soon, but I thought coming over here and say “Thank you for the amazing gaming tool!” was necessary :slight_smile: .

7 Likes

I’m really surprised this hasn’t been mentioned before (or perhaps it has, but then I’m surprised it hasn’t been fixed):

The script generating the forum post doesn’t quite do it right. The title of the “buildings” section doesn’t display correctly - instead of showing as bold, you see the code disaplyed instead. I don’t know why this happens, but it is easily fixed manually each time by inserting a line break just before it. It would be much less annoying if the script did this automatically. (This can’t be peculiar to me because I have seen this in others’ PBF posts as well.)

It’s hardly a priority because it doesn’t affect the game itself, so most players probably don’t even notice it. But it must be very quick to fix, and it does annoy those of us with OCD tendencies :slight_smile:

The spreadsheet as a whole is great though, and I am very grateful that it exists.

I do have OCD tendencies, so I am certain I would find that equally annoying! That said, I am not reproducing it at the moment… Link or post to an example?

It occured to me that perhaps the issue had to do with the blank line created between in play and buildings. There is an asterisk there even when no cards are in the back line because of how this forum interprets blank lines. Basically, the in play and buildings are read as headers and expect lines with text in between, or two blank lines. I chose to always have the line of text (using the lonely asterisk) so that the board info block could be continuous but seperated from the economy block by a blank line


[B]Board Info:[/B]
[B]In Patrol:[/B]

  • :psblueshield: [I]Squad Leader[/I]:
  • :psfist: [I]Elite[/I]:
  • :ps_: [I]Scavenger[/I]:
  • :pschip: [I]Technician[/I]:
  • :target: [I]Lookout[/I]:
    [B]In Play:[/B]

[B]Buildings:[/B]

  • :heart: Base HP: 20

[B]Economy Info:[/B]
[B]Cards:[/B]

  • Hand: 0
  • Deck: 0
  • Disc: 0
    [B]Gold:[/B]
  • Gold:
  • Workers: 5

It could also have been

[B]In Play:[/B]
[B]Buildings:[/B]

  • :heart: Base HP: 20

But I wanted to make sure it was easy to tell the back line was empty

1 Like