What's New Dashboard Articles Forums Chat Room Achievements Tournaments Player Map The Promenade Volunteers About Us Site Index
The Continuing Committee
It is currently Wed Jan 29, 2020 3:33 pm




Post new topic Reply to topic  [ 115 posts ]  Go to page 1, 2, 3, 4, 5 ... 8  Next
 1E Inventory Spreadsheet 
Author Message
Delta Quadrant

User avatar

Joined: Thu Oct 02, 2008 12:29 pm
Posts: 4381
Location: Lompoc, CA
Region: Risa
Post 1E Inventory Spreadsheet
I created a Microsoft Excel 2007 spreadsheet to inventory my 1E collection.

This spreadsheet includes all standard cards released, whether common, uncommon or rare as part of a set, or premium as part of a standalone product, or in one case as a giveaway with a game (U.S.S. Jupiter). It does not include separate entries for Reflections foils or preview cards (which are listed under the set the card came out in as part of the set.) It does not include 2E BC cards or virtual cards.

It does include room for the alternate printings of dual affiliation cards that they did from the Voyager set onwards.

You can download the spreadsheet for free at https://drive.google.com/open?id=1vq-6limtXdiHPTGwUe5GvtcyHhhSUV9a. Feel free to alter or redistribute it as you see fit.

Also, there is a documentation file you can find at https://drive.google.com/open?id=1TyMPljS58VIMwtC4dBJRe6qjaRgrVem6

Edit: Changed link to a new permanent home, and updated.

_________________
Formerly EHCCGPP
EHCCGPP wrote:
No matter how long you play 1E, you'll always have moments where you yell "Wait! (Card X) does (Y)?! How did I not realize this?!"

1E Inventory Spreadsheet


Last edited by Boffo97 on Sun Jun 11, 2017 7:42 pm, edited 6 times in total.

Sat Jan 05, 2013 12:07 am
Profile
Online
First Edition Rules Master
First Edition Rules Master



User avatar

Joined: Sun Jun 17, 2012 1:51 am
Posts: 10766
Location: Twin Cities
Region: Andoria
Post Re: 1E Inventory Spreadsheet
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.

_________________
Rules Manager, First Edition

If it's blue, it's an Official Ruling. The rest is mere opinion.

We pledge our loyalty to the Glossary from now until death.
Then receive this reward from the Glossary. May it keep you strong.
~Iron Prime


Fri Jan 11, 2013 5:46 pm
Profile
Delta Quadrant

User avatar

Joined: Thu Oct 02, 2008 12:29 pm
Posts: 4381
Location: Lompoc, CA
Region: Risa
Post Re: 1E Inventory Spreadsheet
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 - [AQ], G - [1E-GQ], D - [1E-DQ] or M - [MQ].

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!

_________________
Formerly EHCCGPP
EHCCGPP wrote:
No matter how long you play 1E, you'll always have moments where you yell "Wait! (Card X) does (Y)?! How did I not realize this?!"

1E Inventory Spreadsheet


Fri Jan 11, 2013 6:16 pm
Profile
Delta Quadrant

User avatar

Joined: Thu Oct 02, 2008 12:29 pm
Posts: 4381
Location: Lompoc, CA
Region: Risa
Post Re: 1E Inventory Spreadsheet
I know a few people are using this, so I'll just give some update on my current work.

I'm currently in the process of adding in all printable virtual cards on a 2nd sheet so you can track that inventory as well.

Any thoughts on whether or not I should go through and list the property logo for each card? (except Missions of course)

_________________
Formerly EHCCGPP
EHCCGPP wrote:
No matter how long you play 1E, you'll always have moments where you yell "Wait! (Card X) does (Y)?! How did I not realize this?!"

1E Inventory Spreadsheet


Sat Feb 02, 2013 8:27 am
Profile
Beta Quadrant

Joined: Mon May 04, 2009 2:24 pm
Posts: 933
Region: The Void
Post Re: 1E Inventory Spreadsheet
IDK if it was the cite or what but the link just redirected me to their front page. Thanks again for putting in the time and effort to making this and sharing it with the community.


Sat Feb 02, 2013 4:39 pm
Profile
Delta Quadrant

User avatar

Joined: Thu Oct 02, 2008 12:29 pm
Posts: 4381
Location: Lompoc, CA
Region: Risa
Post Re: 1E Inventory Spreadsheet
maverick2909 wrote:
IDK if it was the cite or what but the link just redirected me to their front page. Thanks again for putting in the time and effort to making this and sharing it with the community.


Sorry about that. I should have realized that the free hosting site I used wasn't going to be a permanent solution. I found a way to put it onto my homepage (which I would have done before, except I'm about a quarter of the world away from my regular computer and working on an old one, so I had to figure out how to access it.)

Anyway, try this link: http://boffo.flactem.com:8080/STCCG.xlsx

That's still version 1.0 of the spreadsheet.

Coming soon in 2.0:

- Virtual cards: All currently printable cards from Referee Reprints to Shades of Gray are already done, though not in the file linked above.

- Property logos: For everything with an actual property logo on it.

- Faction: [Maq], [KCA], [TE], [KCA] & [TE], [TE] & [OS], [OS], [CF], and [22] among others. Plus a couple that don't really fit the category but are convenient to put there, like [EE], [Bar] and [Orb].

- AU/Holo: Whether the card has [1E-AU] or [Holo]. Luckily none seem to have both, unless the Revised Voyager crew from 2E is converted.

- Hidden Agenda and Referee categories, indicating if the card has these.

- Subgroup category, for miscellaneous things like Captain's Order, Rule icon, Crime icon, Pursuit icon, etc.

- Dilemmas and Missions split into specifying whether they are Planet, Space or both.

- Affiliation added to Missions

_________________
Formerly EHCCGPP
EHCCGPP wrote:
No matter how long you play 1E, you'll always have moments where you yell "Wait! (Card X) does (Y)?! How did I not realize this?!"

1E Inventory Spreadsheet


Sat Feb 02, 2013 8:52 pm
Profile
Beta Quadrant
User avatar

Joined: Wed Jan 23, 2013 9:37 am
Posts: 225
Location: Harelbeke, Belgium
Region: New Bajor
Post Re: 1E Inventory Spreadsheet
You did a hell of a job on that spreadsheet.
But if you are doing updates for a version 2.0, I would like to make a suggestion:
Maybe you could, for Premiere, split the "Orig" column out in BB, WB94 and WB95
as there where 3 different prints (original black border, unlimited print run in 1994 and the beta print run in 1995 (and later).

Just an idea, hopefull it is usefull to you.

Sincerely,
Jurgen


Tue Feb 19, 2013 2:28 pm
Profile
Delta Quadrant

User avatar

Joined: Thu Oct 02, 2008 12:29 pm
Posts: 4381
Location: Lompoc, CA
Region: Risa
Post Re: 1E Inventory Spreadsheet
JurgenP wrote:
You did a hell of a job on that spreadsheet.
But if you are doing updates for a version 2.0, I would like to make a suggestion:
Maybe you could, for Premiere, split the "Orig" column out in BB, WB94 and WB95
as there where 3 different prints (original black border, unlimited print run in 1994 and the beta print run in 1995 (and later).

Just an idea, hopefull it is usefull to you.

Sincerely,
Jurgen


Thanks for the kind feedback.

I am indeed working on a 2.0, but I really don't want to include alternate printings outside of Voyager and onwards dual personnel, because it gets to be too much of a can of worms. In addition to the Prem BB, WB Alpha, WB Beta and Silver Border Collector's Tin, you have preview cards, Reflections foil cards, reprints (such as the Trouble with Tribbles starters), etc.

However, it should be fairly easy to alter the spreadsheet to fit your needs if you want to track those.

Hope you enjoy inventorying! :D

_________________
Formerly EHCCGPP
EHCCGPP wrote:
No matter how long you play 1E, you'll always have moments where you yell "Wait! (Card X) does (Y)?! How did I not realize this?!"

1E Inventory Spreadsheet


Tue Feb 19, 2013 2:35 pm
Profile
Beta Quadrant
User avatar

Joined: Wed Jan 23, 2013 9:37 am
Posts: 225
Location: Harelbeke, Belgium
Region: New Bajor
Post Re: 1E Inventory Spreadsheet
No problem, it might indeed be a can of worms :)

I just suggested it, because (when trading cards) I sometimes get very specific "wants" fi. WB94 Kivas Fajo - Collector.

But you are rights, it is easy enough to "adapt" ... being a Borg-player, I guess it is one of my specialities.
Besides you already did all the hard work: entering 2.2K of card names and related information for each one of them.

Keep up the good work :)

Jurgen


Tue Feb 19, 2013 2:46 pm
Profile
Alpha Quadrant
User avatar

Joined: Tue May 28, 2013 7:55 pm
Posts: 11
Location: 115 Brodie Rd Henderson,NC 27536
Region: Sector 001
Post Re: 1E Inventory Spreadsheet
I formatted the spreadsheet as a table and find that it makes things much easier to catalog.

_________________
Jack


Sat Jun 29, 2013 12:43 am
Profile
New Member

Joined: Mon Sep 09, 2013 12:30 am
Posts: 5
Region: The Void
Post Re: 1E Inventory Spreadsheet
Just wondering how 2.0 is coming.

Been out of it for a while and found my collectors tin in a box... Next thing I know I'm digging through storage to find boxes and binders.

Anyway, my old xls has long since gone away and in starting over plus learning about the virtual cards. Decipher had a deck builder/game program but it to has gone by the wayside on an old laptop. (sigh).

Looking forward to the updates.


Mon Sep 09, 2013 12:48 am
Profile
Delta Quadrant

User avatar

Joined: Thu Oct 02, 2008 12:29 pm
Posts: 4381
Location: Lompoc, CA
Region: Risa
Post Re: 1E Inventory Spreadsheet
I was actually reminding myself I needed to get back onto working on 2.0. The holdup has been that I have a somewhat unreliable connection and including things like property logos and icons requires looking at every card.

I'm glad you're enjoying the spreadsheet.

_________________
Formerly EHCCGPP
EHCCGPP wrote:
No matter how long you play 1E, you'll always have moments where you yell "Wait! (Card X) does (Y)?! How did I not realize this?!"

1E Inventory Spreadsheet


Mon Sep 09, 2013 1:17 am
Profile
New Member

Joined: Mon Sep 09, 2013 12:30 am
Posts: 5
Region: The Void
Post Re: 1E Inventory Spreadsheet
Why not make it them open documents. So everyone could help.


Sun Sep 15, 2013 3:23 am
Profile
Delta Quadrant

User avatar

Joined: Thu Oct 02, 2008 12:29 pm
Posts: 4381
Location: Lompoc, CA
Region: Risa
Post Re: 1E Inventory Spreadsheet
Kletus wrote:
Why not make it them open documents. So everyone could help.

I'm not familiar with open documents.

Is it some kind of "shared on the cloud" type deal?

_________________
Formerly EHCCGPP
EHCCGPP wrote:
No matter how long you play 1E, you'll always have moments where you yell "Wait! (Card X) does (Y)?! How did I not realize this?!"

1E Inventory Spreadsheet


Sun Sep 15, 2013 3:29 am
Profile
New Member

Joined: Mon Sep 09, 2013 12:30 am
Posts: 5
Region: The Void
Post Re: 1E Inventory Spreadsheet
Yes like a google doc open for editing. There may be limits. I have not looked into it. Others might have input.


Sun Sep 15, 2013 3:47 am
Profile
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 115 posts ]  Go to page 1, 2, 3, 4, 5 ... 8  Next


Who is online

Users browsing this forum: Majestic-12 [Bot], Pants o.t. Tal Shiar and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Terms of Use

Powered by phpBB © phpBB Group.
Designed by Vjacheslav Trushkin for Free Forums/DivisionCore.