BCSWowbagger wrote:This is quite snazzy, and I will be using it in my latest inventory. (I used to do these by hand as a child! Was I insane?)
Questions about nomenclature: What is the RP column? What is the Orig column? What is the Q column, and what are its possible values?
Thanks for posting this.
My fault for being lazy and not explaining those. So I'll do it now. I'll just explain every column.
Have - The total number of copies of this card you own. Automatically set to be the total of the Orig and RP columns, so don't actually edit this column if you want to keep that functionality.
Orig - The original version of the card. For the vast majority of cards, this is the only version of the card, as this spreadsheet is not set up to track foils, version (for Premiere), preview cards, border colors or anything like that. You edit this column to add cards.
RP - Bad name, but couldn't think of a better one. It stands for reprint, but what it actually is for is tracking the "alternate printing" dual affiliation cards they started doing in Voyager. Basically, if the number on the bottom of the card has an *, then it goes here.
Card # - The spreadsheet makes an attempt to list every card in release order, and then by order of the official list, and thus goes all the way from card #1: Betazoid Gift Box to card #2,435: T'Pol/Soong Manuever.
Set # - The number of the card within a set. When the list moves on to a new set (or standalone product), this number resets, where Card # does not.
Set - The name of the set the card belongs to.
Rarity - The given rarity of the card. Rarities include Common, Uncommon, Rare, Rare+, Rare* (only used in Trouble With Tribbles), Ultra-Rare and Premium.
Name - Name of the card. Duh.
Card Type - The type of the card. I did think about dividing Dilemmas and Missions into Planet, Space or Planet/Space categories, but have not done that yet.
Q - Native quadrant of the card. This only applies to Missions, Facilities, Personnel and Ships. Valid values are A -
, G -
, D -
or M -
1st - 5th Affiliation: Affiliations of the card, printed in order of their appearance on the main version of the card. While personnel only go up to 3 affiliations, some missions have 5, and I thought about adding them.
Glad you enjoy the spreadsheet. Have fun inventorying!