#245234
It's been quite a while, but I have still been working on this, and am very close (should be within a week) to having Version 2.0 of the 1E Inventory Spreadsheet finished.
I actually had to download the file of 1.0 to remind myself of all the changes. Here's the list of what's coming:
* Due to the new universal printability rules, Columns B and C have gone from tracking "Original" and "Reprint" to "Physical" and "Proxy". Because of this, Alternate Border cards from Voyager onwards get their own line in the spreadsheet. Their card number and set number will receive an increment of .5 to note that they are the alternate border that would be marked with * on the card itself. For example, B'Elanna Torres from the Voyager set is card #1898 of 1E and #115 of Voyager. Her alternate Non-Aligned Border card is listed as #1898.5 and #115.5. This should keep cards straight during any sorting you do.
As a side note, the new printability rule actually made it easier for me on this project because now I don't have to keep a separate page on legally printable proxies.
* All cards that have one now list what property logo is on the card.
* New column: Subtype. In this column, you'll get notifications of whether a dilemma or mission is Planet, Space or Dual; if a card is a Captain's Order, icons, icons, cards, icons and icons.
* New column: Faction. In this column, you'll get notifications of cards that are , , or (or both those last two.)
* New column: HA. Which cards have a icon?
* New column: Ref. Which cards have a icon?
* Affiliation: Affiliation information on Missions is entered.
* Universality: Cards that have a ❖ icon will have their lines italicized.
* Virtual Card Info Added: Virtual Promos will get their own tab, and the rest of the Virtual cards will be on a 3rd tab.Obviously for virtual cards, there will be only 1 inventory column.
What remains to be done before release:
* Universality italicization needs done from Trouble with Tribbles to All Good Things (not sure there were any universals in Enterprise Collection)
* Card info entered from The Motion Pictures to
* Property logo info entered from All Good Things to Enterprise Collection.
* Virtual Promo info added for VP 81-92 and VP 95.
* Virtual card info added for The Sky's The Limit through Homefront V.
What's in the future:
I intend to be regular with updates when VPs become printable and new virtual sets are released. I would like to add 2E BC cards as a 4th tab.
What's not in:
I'm still not tracking foils, border color or Premiere Alpha/Beta separately. If that's something that's important to you, it would be pretty easy to add. I also didn't see much demand for listing on the sheet how many points are in a point box.
But, yeah, this should be out soon, and you'll be able to sort and track your collection in a ton of ways.
I actually had to download the file of 1.0 to remind myself of all the changes. Here's the list of what's coming:
* Due to the new universal printability rules, Columns B and C have gone from tracking "Original" and "Reprint" to "Physical" and "Proxy". Because of this, Alternate Border cards from Voyager onwards get their own line in the spreadsheet. Their card number and set number will receive an increment of .5 to note that they are the alternate border that would be marked with * on the card itself. For example, B'Elanna Torres from the Voyager set is card #1898 of 1E and #115 of Voyager. Her alternate Non-Aligned Border card is listed as #1898.5 and #115.5. This should keep cards straight during any sorting you do.
As a side note, the new printability rule actually made it easier for me on this project because now I don't have to keep a separate page on legally printable proxies.
* All cards that have one now list what property logo is on the card.
* New column: Subtype. In this column, you'll get notifications of whether a dilemma or mission is Planet, Space or Dual; if a card is a Captain's Order, icons, icons, cards, icons and icons.
* New column: Faction. In this column, you'll get notifications of cards that are , , or (or both those last two.)
* New column: HA. Which cards have a icon?
* New column: Ref. Which cards have a icon?
* Affiliation: Affiliation information on Missions is entered.
* Universality: Cards that have a ❖ icon will have their lines italicized.
* Virtual Card Info Added: Virtual Promos will get their own tab, and the rest of the Virtual cards will be on a 3rd tab.Obviously for virtual cards, there will be only 1 inventory column.
What remains to be done before release:
* Universality italicization needs done from Trouble with Tribbles to All Good Things (not sure there were any universals in Enterprise Collection)
* Card info entered from The Motion Pictures to
* Property logo info entered from All Good Things to Enterprise Collection.
* Virtual Promo info added for VP 81-92 and VP 95.
* Virtual card info added for The Sky's The Limit through Homefront V.
What's in the future:
I intend to be regular with updates when VPs become printable and new virtual sets are released. I would like to add 2E BC cards as a 4th tab.
What's not in:
I'm still not tracking foils, border color or Premiere Alpha/Beta separately. If that's something that's important to you, it would be pretty easy to add. I also didn't see much demand for listing on the sheet how many points are in a point box.
But, yeah, this should be out soon, and you'll be able to sort and track your collection in a ton of ways.
Last edited by Boffo97 on Sat Feb 22, 2014 3:57 am, edited 1 time in total.
Boffo97 wrote:The questions and the answers are mutually exclusive. If both are known, it's speculated that 1E will instantly disappear and be replaced by something even more bizarre and inexplicable.1E Inventory Spreadsheet