|How to Use This Sheet|
|This spreadsheet can be used for detailed tracking of your chronicles and inventory. It should serve as a viable alternative to physical inventory tracking sheets (ITSs). It does not provide enough information to serve as a replacement for carrying around your chronicle sheets, although there are steps you could take (for example, scanning your chronicle sheets into digital form) that could help you go all-digital.|
There are four important types of sheets in this spreadsheet, not including this page (which you should feel free to delete or hide).
|The Default Character Sheet|
|The first and most important is the default character sheet. This is named "Default" in the list of tabs below. Do not change this sheet. Instead, when you create a new character (or want to import an existing character), right click on the tab and select the "Duplicate" option. This creates a duplicate of the sheet in this spreadsheet. It will be named "Copy of Default."|
You can rename this new sheet to whatever you like, although I prefer the format (Character Number): (Character Name).
I've protected the default sheet from editing; it should warn you if you try to change it. The protection is not retained when you duplicate the page. If, for some reason, you want to remove the default sheet's protection, you can change protection settings in Data > Protected Sheets and Ranges .
|Individual Character Sheets|
|Once you have a new character sheet, you can start filling it out. You'll see there are a number of columns on each sheet. Transaction number should increment each time--each line should have a new transaction number, which should be one greater than the line before. This isn't used directly by the sheet, but it gives you a number you can refer to in case you need to.|
The next column is the chronicle sheet number. This should indicate either the number of the chronicle sheet you're applying, or the number of the chronicle sheet that the transaction happened on. (Remember that all of your PFS transactions should be associated with one and only one chronicle sheet. They don't happen in a vacuum.)
After chronicle sheet number is the notes column. This is a plain-text, human-readable description of what the heck you're doing. Usually, this is the name of the item you sold, the spell you bought, the chronicle sheet you applied.
Next up is the transaction type. This dropdown pulls from the data spreadsheet (I'll talk about this later) and lets you select a type of transaction that this line represents.
Quantity describes the quantity, whether bought or sold.
Gold change lists the gold earned or spent. Remember that gold earned is positive, but gold spent should be negative--add a minus-sign (" - ") before the GP amount when you are buying something. It should look like this when you type it in: "-500" .
The Gold Remaining column adds the gold change from its own row to the gold remaining column from the row above to get the new total gold the character has available.
Prestige, fame, and experience are each represented by two columns that work like Gold Remaining and Gold Change. There is an additional column, Level, that divides the character's experience points by 3 and adds 1 to get the character's current level.
|Filling Out Individual Character Sheets|
|I've included three different ITS sheets of mine in this spreadsheet, so you can see how I've done things. Maybe you can figure out better ways of doing them, too! Feel free to delete them when you're done.|
I have a few things I try to do to make things easier on myself:
1. I don't track gold spent (except on used expendables, like potions or arrows) on a character until after they have gotten their third experience point. That way I don't need to keep detailed track of every rebuild I perform. This is in line with how I have seen just about every other PFS player do this, although depending on how closely you hew to the rules in the PFS guide, you may have some philosophical problems with the approach. Different strokes for different folks, I suppose. Note that boons applied, prestige spent, and the like are generally not rebuildable and so you should track those purchases (etc) as soon as you make them.
2. I track day job as a separate entry with the designation "chronicle sheet". I don't include it in the chronicle sheet gold.
3. I try to write down the PFS number of the PC I am learning a spell from when I scribe a spell from a shared spellbook.
4. I write down the name of every spell I'm learning, including from classes, not just "learned 25 first-level spells." I didn't always do this, but with a digital sheet it is much easier and it makes an audit (self or otherwise) feasible.
5. Boons that take up their own chronicle sheet get their own chronicle sheet number.
6. Arrows, wands, and other items that are either bought in bulk or that come with charges (that aren't refillable--I don't have any characters with staves, but I wouldn't track staff charges here if I did) have the charges listed under quantity. Quinn Shannon, organized as he is, is responsible for this particular optimization.
7. When entering in existing characters, I found a number of problems--math related and otherwise. In fact, because of mistakes, some of my characters should have had negative gold for brief stretches of their PFS career. This seems like a relatively normal occurrence--if you only used paper ITS sheets, mistakes are bound to happen. What I did was I wrote the corrected value (gold, prestige, otherwise) on that character's most recent chronicle sheet, along with a note that the changes were the result of a self-audit. If you are still in the negatives on that character's last chronicle, sell something to get yourself in the positive and move on. Leave the angst to the Bank of Abadar and their department of accidental loans.
8: Running out of rows: before you run out of rows on an ITS sheet, make a copy of the last blank one and add a couple hundred more! This is especially useful for prepared casters who might easily need hundreds or thousands of rows.
9. Watch out with inserts--Google Docs isn't Excel, and it doesn't handle inserts well. You probably will have to manually update the row(s) immediately after the inserted row. Other rows may or may not break. Try to avoid inserts if you can!
|The Data sheet is a hidden sheet. You can view hidden sheets by clicking on the "View" menu and selecting the sheet in the "Hidden Sheets" option. It has two datasets that are selected as named ranges and used in the validation. If you want to modify this sheet to add more dropdowns, columns, etc. and those require more hidden information, named ranges, etc. this sheet is the place to put them.|
I also made a PFS character list sheet. I manually add a row for each character I create, select their faction, and then select the max of the level column of their tracking sheet to get their current level. It works for me, but maybe you don't care, or maybe you want more information. There's nothing special about this sheet, so by all means feel free to redo it as much as you want. It won't break anything.
|Getting a Copy of This Sheet|
|If I've done my job correctly, you only have permission to view this sheet, not to edit it. You should be able to make a copy of it by clicking on the File menu and choosing the "Make a Copy" option. This should make it your own, to do what you will with it.|
|Sharing This Sheet|
|There are a lot of ways you can share this sheet with others, in particular with GMs when you are playing PFS online. You can create a new spreadsheet and copy a particular sheet (for a particular character) into that spreadsheet by right-clicking on the tab and selecting the "Copy To" option. My recommended approach, though, is to click on "File" and select the "Publish to Web" option and export a single character sheet. You can then share this with whoever you need. There are probably other good ways to share the sheet around--feel free to experiment.|
I would always, always, always recommend that you only allow the people you are sharing with to view, not edit, the sheet.
|Who Made This?|
|I'm Alex Wreschnig, and at the time of this writing I'm a PFS player in Pittsburgh. My wife Shannon and my friend Quinn Shannon (yes, they are different people.) both contributed.|
You can reach me at firstname.lastname@example.org (you'll need to fill in the blanks, but it shouldn't be hard.)
This template was originally shared on http://www.pittpfs.com .
|Pittsburgh Pathfinder Website Link|