This forums is for questions, answers, and discussion about First Edition rules, formats, and expansions.
  • 129 posts
  • 1
  • 3
  • 4
  • 5
  • 6
  • 7
  • 9
User avatar
 
By JDobbs
 - Alpha Quadrant
 -  
#380702
I have a question about the spread sheet. Under the 1E tab there are entries for TWT, but the under the 1E WB & Misc there is also entries for TWTS. Maybe I'm still learning the abbreviations but what would the difference be?

Thanks!
J
User avatar
 
By Boffo97 (Dave Hines)
 - Gamma Quadrant
 -  
Retired Moderator
#380718
JDobbs wrote:I have a question about the spread sheet. Under the 1E tab there are entries for TWT, but the under the 1E WB & Misc there is also entries for TWTS. Maybe I'm still learning the abbreviations but what would the difference be?

Thanks!
J
Good question. TWTS means the Trouble with Tribbles Starter Packs, and are the contents of the Federation and Klingon starters from that set. The reason they are listed separately is that several cards from both starters have had Tribbles digitally inserted into the image, and all the cards had the new copyright date (2000, IIRC) rather than their original set's date.

So since the 1E WB & Misc tab is for the people who want to track absolutely everything, I included that as well. If you only care whether you have a card or not and don't care if it's from a starter, WB Alpha, WB Beta, the Collector's Tin or what have you, that sheet can be ignored.

Glad you're enjoying the spreadsheet, and I'll update soon for Broken Bow.
User avatar
 
By Boffo97 (Dave Hines)
 - Gamma Quadrant
 -  
Retired Moderator
#386058
So it seems that my version of "Soon" corresponds with the classic Blizzard version of "Soon". Sigh. Sorry, guys. Real life and resultant procrastination strikes again.

Update v.Whateverwe'reonnow: Broken Bow

Download at: https://www.dropbox.com/s/i0rylfq4m08dd ... G.xls?dl=0

I'm not sure if this download link works over the long term, so if you have problems downloading, please let me know.

Simple upgrade instructions:

1. Save above link to different location/filename from your existing inventory.
2. Open both spreadsheets and select tab "1E Virtual" in both.
3. Copy lines 1366-1455 from the new spreadsheet to the old spreadsheet.
4. Go to "1E VPs" tab in both spreadsheets.
5. Select cells B168-P210 of the new spreadsheet.
6. Copy those cells to the same range of the old spreadsheet.

Spreadsheet is now workable.

Additional full upgrade instructions:

1. Select the "2EBC" tab of your inventory and delete the lines containing the following numbers in the "Card #" column (note there are gaps left by previously deleted cards in this column):
* Card #165: Sickbay
* Card #219: "Rock People"
* Card #375: Retrieve Materiel
* Card #377: Survey New World
* Card #386: Callaghan
* Card #391: Kelby
* Card #393: Maxwell Forrest, Starfleet Executive
* Card #394: Phlox, Alien Physiologist
* Card #403: Contaminating a Culture
* Card #408: Stand-off
* Card #409: Symbalene Blood Burn
* Card #495: Amanda Cole
* Card #496: Hideaki Chang
* Card #497: Jeremiah Hayes
* Card #498: Nelson Kemper
* Card #499: Sascha Money
* Card #500: Sean Hawkins
* Card #545: Military Assault Command Operations

2. Select the "2EBC Virtual" tab of your inventory and delete these lines:
* The Undiscovered Country, Card #27: Harvest Drone
* The Undiscovered Country, Card #28: Synergy Drone
* The Undiscovered Country, Card #43: Jonathan Archer, Heroic Diplomat
* This Side of Paradise, Card #43: Fiona McKenzie

3. Select the "1E" tab of your inventory and make the following change:
* Card #2428, change name to "Jonathan Archer (EC)"
* Card #2430, change name to "Maxwell Forrest (EC)"
* Card #2431, change name to "Phlox (EC)"

4. Close new spreadsheet file. It may be safely deleted.
User avatar
 
By Iron Prime (Dan Van Kampen)
 - Delta Quadrant
 -  
Moderator
#386098
"better late than never"

Thanks again!
:thumbsup:
User avatar
 
By Boffo97 (Dave Hines)
 - Gamma Quadrant
 -  
Retired Moderator
#387909
Very minor Pre-Warp Pack update. There'll probably be a new update soon for new VPs. (Alas, 158 VP... will you ever be officially revealed?)

Download at: https://www.dropbox.com/s/i0rylfq4m08dd ... G.xls?dl=0

If link does not work, let me know.

Simple upgrade instructions:

1. Save above link to different location/filename from your existing inventory.
2. Open both spreadsheets and select tab "1E Virtual" in both.
3. Copy lines 1456-1473 from the new spreadsheet to the old spreadsheet.
4. Go to "1E VPs" tab in both spreadsheets.
5. Select row 195 (which is 188 VP, Wormhole)
6. Copy that row over the same row on the old spreadsheet.

Spreadsheet is now workable.

Additional full upgrade instructions:

1. Select the "1E" tab of your inventory and make the following change:
* Card #2432, change name to "T'Pol (EC)"

2. Close new spreadsheet file. It may be safely deleted.
User avatar
 
By Boffo97 (Dave Hines)
 - Gamma Quadrant
 -  
Retired Moderator
#395314
For a change, let's try to actually get this done while people are still thinking of this as a new expansion!

Update for Live Long and Prosper

Download at: https://www.dropbox.com/s/i0rylfq4m08dd ... G.xls?dl=0

Download link does seem to still work. Let me know if you have issues... unless of course if they are not at all relevant to this spreadsheet.

Fun fact: There are no conversions of Decipher produced 2E cards in this set. There is 1 conversion of a CC produced 2E card though.

Simple upgrade instructions:

1. Save above link to different location/filename from your existing inventory.
2. Open both spreadsheets and select tab "1E Virtual" in both.
3. Copy lines 1474-1539 from the new spreadsheet to the old spreadsheet.
4. Go to "1E VPs" tab in both spreadsheets.
5. Select cells B183-P210 of the new spreadsheet.
6. Copy those cells to the same range of the old spreadsheet.

Spreadsheet is now workable.

Additional full upgrade instructions:

1. Go to the "2E Virtual" tab of your inventory and delete the following line:
* Set "Raise the Stakes", Card 74, "Syrran, Desert Wind"

2. Go back to the "1E Virtual Tab" of your inventory and change the name of Set 31, Card 13 to "Soval (PWP)"

3. Select the "1E" tab of your inventory and make the following change:
* Card #2422, change name to "Charles Tucker III (EC)"

4. Close new spreadsheet file. It may be safely deleted.
User avatar
 
By Boffo97 (Dave Hines)
 - Gamma Quadrant
 -  
Retired Moderator
#396818
I did an extremely minor update to correct a typo in Jim Shimoda's name and add Up Yer Shaft!.

Update instructions:

1. Download new spreadsheet at https://www.dropbox.com/s/i0rylfq4m08dd ... G.xls?dl=0

2. Open your old and the new spreadsheet, go to 1E VPs tab in both.

3. Copy the range of B210 to P212 from the new sheet to your old sheet.

4. Save old sheet. New sheet may be safely deleted.
User avatar
 
By Boffo97 (Dave Hines)
 - Gamma Quadrant
 -  
Retired Moderator
#407320
With my traditional lateness, here's the update for Warp Pack: Holiday 2017.

Question: Given that preview cards, like Warp Packs, have their own numbering system, should I create a new tab for them? Or just use the numbers on the cards themselves? Or leave the thing as is?

And hey, we finally got VP 158 filled in!

Download at: https://www.dropbox.com/s/i0rylfq4m08dd ... G.xls?dl=0

Let me know if link does not work.

Simple upgrade instructions:

1. Save above link to different location/filename from your existing inventory.
2. Open both spreadsheets and select tab "1E Virtual" in both.
3. Copy lines 1540-1549 from the new spreadsheet to the old spreadsheet.
4. Go to "1E VPs" tab in both spreadsheets.
5. Select cells B164-P213 of the new spreadsheet.
6. Copy those cells to the same range of the old spreadsheet.
7. If you have any content in the range A210-A212, select it and move it down 1 row.

Spreadsheet is now workable.

Additional full upgrade instructions:

1. Go to the "2EBC" tab of your inventory and delete the following line:
* Card 419, "Kira Nerys, Blockade Commander"

2. Select the "1E" tab of your inventory and make the following change:
* Card #2391, change name to "Colonel Kira (AGT)"

3. Close new spreadsheet file. It may be safely deleted.
User avatar
 
By Boffo97 (Dave Hines)
 - Gamma Quadrant
 -  
Retired Moderator
#418243
Apparently, it was TOO cold, and I am WAY late with my update for Cold Front. Even by MY standards. Be sure to dock my pay.

Download at: https://www.dropbox.com/s/i0rylfq4m08dd ... G.xls?dl=0

Let me know if link does not work or if you spot any mistakes.

Simple upgrade instructions:

1. Save above link to different location/filename from your existing inventory.
2. Open both spreadsheets and select tab "1E Virtual" in both.
3. Copy lines 1550-1605 from the new spreadsheet to the old spreadsheet.
4. Go to "1E VPs" tab in both spreadsheets.
5. Select cells B198-P215 of the new spreadsheet.
6. Copy those cells to the same range of the old spreadsheet.

Spreadsheet is now workable.

Additional full upgrade instructions:

1. Go to the "2EBC" tab of your inventory and delete the following lines:
* Card 348, "Hoshi Sato, Empress"
* Card 381, "Arik Soong, Father of Many"
* Card 541, "Distant Control"

2. Select the "1E" tab of your inventory and make the following change:
* Card #2183, change name to "Ezri Dax (HA)"

3. Close new spreadsheet file. It may be safely deleted.
User avatar
 
By Boffo97 (Dave Hines)
 - Gamma Quadrant
 -  
Retired Moderator
#427498
It’s time for a State of the Spreadsheet Address!

Where’s Metamorphosis?

Even by my standards, I know I’m pretty late with adding Metamorphosis to the spreadsheet. Between work and illness (which are very fun at the same time), I haven’t had time to add it and any new Virtual Promo cards. I hope to take care of that before next week.

What’s Happening to the BC Tabs?

I asked for advice on the BC tabs when Metamorphosis wasn’t even Metamorphosis yet and didn’t get much feedback, so that kicked the decision back to me. So I thought about it and here’s what I decided:

I have taken cards off the list when they’ve been errata’ed into being a different card (which has only been the case with BC conversions AFAIK), but not when they’ve been banned. After all, good ol’ Raise the Stakes has been banned in every official format just as much as BC cards soon will be and it’s on the spreadsheet 4 times (on the 1E tab once and three on the 1E WB & Misc tab for WB94, WB95 and CTSB).

So what I will be doing is removing any converted cards in Metamorphosis from the appropriate 2E tab(s), and then leaving the tabs as is. Of course, end users are free to remove the tabs from their spreadsheets just as they are free to re-add any converted cards back to their spreadsheets if they wish.

On a side note, while me as a user has been (perhaps too) vocal about not liking certain decisions relating to Metamorphosis, this does make things a lot easier for me as the spreadsheet maintainer. One of the biggest holdups to adding a new set was stopping every time I hit a converted card, finding it in the 2E tabs, deleting it, then making a note to anyone manually updating the spreadsheet to delete that line as well. BC cards being banned going forward should permanently eliminate my need to do that, as (by my understanding), while 2E cards (BC or not) might be revisited to become the basis of 1E cards, these will not be true conversions in the sense that they have been, as this frees Art from needing to find exact frames that original card images were taken from to make the new image. This leads into a topic that every State of something Address needs…

The Future

This has been suggested before and I had to decline due to having no knowledge of how to do it, but unless something goes wrong, the next update for the spreadsheet will include a move over to Google Drive. This will not only increase the stability of the spreadsheet’s home (as I really don’t trust Dropbox not to mess around further with the way shared documents work then), but should enable me to appoint long time trusted users as co-editors if any should apply. With spreadsheet maintenance becoming much less complicated due to no longer having to edit out converted 2E cards, this seems like an ideal time to make such a move. I may also revisit and rewrite the instruction guide for the spreadsheet as well.

In the meantime, thank you for reading this far and thank you for all the support for what started as a dinky little thing for personal use, but seems to be widely appreciated now. I’ve always felt that one of the reasons this community was so great is that it seems so many of us have at least one little unofficial/semi-official project going to help make this game we love better.
User avatar
 
By Iron Prime (Dan Van Kampen)
 - Delta Quadrant
 -  
Moderator
#427516
Good choices. Thanks again for all your work and for sharing your efforts!
User avatar
Director of Operations
By JeBuS (Brian S)
 - Director of Operations
 -  
1E Deep Space 9 Regional Champion 2023
#427544
I'm curious about the numbering scheme in the spreadsheet. The "Card #" field is your own internal numbering system? No relation to the CC card ID numbers?
User avatar
 
By Boffo97 (Dave Hines)
 - Gamma Quadrant
 -  
Retired Moderator
#427548
JeBuS wrote:I'm curious about the numbering scheme in the spreadsheet. The "Card #" field is your own internal numbering system? No relation to the CC card ID numbers?
Correct. Card # is mine just to keep all the cards in release order, and in the case of 2E cards, being able to identify just which card got converted and needs to be deleted off the 2E tab.
User avatar
 
By Boffo97 (Dave Hines)
 - Gamma Quadrant
 -  
Retired Moderator
#428383
Working Update: Metamorphosis and partial Coming of Age

Download at: https://www.dropbox.com/s/i0rylfq4m08dd ... G.xls?dl=0

Since we’re so close to the full release of Coming of Age, I will wait until after then to make the move onto Google Drive. Already revealed Coming of Age cards have been included, so if you wish to remain spoiler free, you may wish to avoid downloading the new spreadsheet at this time.

Simple upgrade instructions:

1. Save above link to different location/filename from your existing inventory.
2. Open both spreadsheets and select tab "1E Virtual" in both.
3. Copy lines 1606-1670 from the new spreadsheet to the old spreadsheet. (Note: You can also add the Coming of Age portion to your sheet if you wish, but lines will be added if more multi affiliation cards are revealed.)
4. Go to "1E VPs" tab in both spreadsheets.
5. Select cells B208-P216 of the new spreadsheet.
6. Copy those cells to the same range of the old spreadsheet.

Spreadsheet is now workable.

Additional full upgrade instructions:

1. Select the "2EBC" tab of your inventory and delete the lines containing the following numbers in the "Card #" column (note there are gaps left by previously deleted cards in this column):
* Card #4: Command Decisions
* Card #19: Awaiting Trial
* Card #44: Souls of the Dead
* Card #47: Bareil Antos, Esteemed Vedek
* Card #78: B’amara
* Card #84: Meraht
* Card #100: Jo’Bril, Patient Schemer
* Card #112: Togaran
* Card #114: Chagrith
* Card #116: Dralvak
* Card #118: Jorvas
* Card #123: Thexor
* Card #199: Kitara
* Card #227: Psychological Pressure (mistakenly titled Psychological Assault on spreadsheet)
* Card #228: Quite a Coincidence
* Card #238: Calibration Drone
* Card #247: Thorel
* Card #251: Imat’Korex
* Card #262: Jack, Maladjusted Misfit
* Card #264: Patrick, Idiot Savant
* Card #265: Sarina Douglas, Cataleptic Conundrum
* Card #268: Alexander Rozhenko, Good Luck Charm
* Card #301: Dorian Collins, Acting Chief Petty Officer
* Card #303: Karen Farris, Rigorous Leader
* Card #305: Riley Shepard, Confident Captain
* Card #306: Seth Matthews, Red Squad Cadet
* Card #308: Tim Watters, Valiant Captain
* Card #315: U.S.S. Valiant, Red Squad Training Ship
* Card #374: Practice Orbital Maneuvers
* Card #379: Jean Hejar, Nova Squadron Navigator
* Card #384: Miss Sarda, Not a Legal Expert
* Card #432: Marie Kaplan, Observant Officer
* Card #476: Condition Red
* Card #481: Secure Strategic Base
* Cards #516-523: The Revised Voyager Holograms
* Card #525: Data, From The City of Rateg (another mistake of mine that it’s still here)
* Card #554: Katherine Pulaski, Chief Medical Officer
* Card #556: Leosa, Grifter

2. Select the "2EBC Virtual" tab of your inventory and delete this line:
* Set: Favor the Bold, Card #15: The Clown: On His Throne

3. Select the "1E" tab of your inventory and make the following changes:
* Card #196, change name to “Alexander Rozhenko (Prem)”
* Card #535, change name to “Katherine Pulaski (QC)”
* Card #1421, change name to “Nog (RoA)”

4. Close new spreadsheet file. It may be safely deleted.

Notes:

* SirDan once said AU Holograms should be made to mess up my spreadsheet and that day has come with the Revised Voyager crew. The abbreviation for such folks on the AU/H column is HA. Not to be confused with Holodeck Adventures of course.

* Since the reprints of cards from Premiere & RoA in Coming of Age are reprints and not new versions of the persona, they do not have parenthetical notation as to the set they are in, just as Virtual Promos that are reprints with new pictures don’t.
  • 1
  • 3
  • 4
  • 5
  • 6
  • 7
  • 9
1EFQ: Game of two halves

Honestly, I don’t think I’ve re[…]

HAPPY BIRTHDAY!!!!

Happy birthday to @Takket ! :D :thumbsup: […]

Opponents turn

Remodulation