Author Topic: Enhanced Card List Spreadsheet  (Read 4567 times)

Lamborghini_diablo

  • Guest
  • Trade Count: (0)
Enhanced Card List Spreadsheet
« on: September 16, 2011, 04:40:33 PM »
0
Hey guys.

I made a comment on the shoutbox about modifying my card list spreadsheet that I often use, and it seems there is interest in this.

Basically, I started off using the Bany spreadsheet, but I decided to personalize it, clean it up, etc.

What I currently have for columns is this:

Name
Set
Color 1 (For dual brigades, I only list ONE color)
Color 2 (For dual brigades, the second color is listed here. ALL dual brigade cards are listed twice, with the brigade cells reversed)
Card Type
Strength
Toughness
Class
Rarity (Also used for Tin numbers)
Generic (Helps a LOT for 100+ or T2)
Ability
Identifiers (currently VERY incomplete, but I just list the important ones.)

Two more I'm considering adding, Testament for a quick sorting of OT/NT cards, and then another the reference. (as there's no easy way to sort through this)

How many of you would be interested in me uploading this once I finish my modifications? I'm trying to make this as informative and easy to search as possible without having ten thousand individual listings.

Offline soul seeker

  • Trade Count: (+15)
  • Hero Member
  • *****
  • Posts: 3011
  • I find your lack of faith disturbing.
    • -
    • Northeast Region
Re: Enhanced Card List Spreadsheet
« Reply #1 on: September 16, 2011, 04:46:53 PM »
0
I am....my spreadsheet is very old and out of date.  I, for one, will appreciate the work.   :)
noob with a medal

Lamborghini_diablo

  • Guest
  • Trade Count: (0)
Re: Enhanced Card List Spreadsheet
« Reply #2 on: September 16, 2011, 05:04:41 PM »
0
Okay, I have a question for you all:

When adding the Identifiers, I'm currently leaving out "Male" and "Human" due to how FREQUENTLY those are listed.

Would you rather see those two identifiers, or is it fine for me to leave them out? I'm keeping female, gender-less, demon, and angel... so right now you can just assume a character is a male human unless you see one of these other labels

browarod

  • Guest
  • Trade Count: (0)
Re: Enhanced Card List Spreadsheet
« Reply #3 on: September 16, 2011, 05:05:58 PM »
0
I would, personally, love this. ^_^

I think leaving out human and male is fine.

Offline STAMP

  • Tournament Host
  • Trade Count: (+19)
  • *****
  • Posts: 5014
  • Redemption brings Freedom
    • -
    • Northwest Region
Re: Enhanced Card List Spreadsheet
« Reply #4 on: September 16, 2011, 06:45:30 PM »
0
Doesn't Gil still keep his URCL up to date?
Final ANB errata: Return player to game.

Lamborghini_diablo

  • Guest
  • Trade Count: (0)
Re: Enhanced Card List Spreadsheet
« Reply #5 on: September 16, 2011, 07:08:28 PM »
0
I dislike how that one is set up. The Bany style list is much easier to read and sort through IMO. I'm just adding some details that were not in his to begin with.

Offline Professoralstad

  • Tournament Host, Redemption Elder
  • Trade Count: (+47)
  • Hero Member
  • *****
  • Posts: 10841
  • Everything is Awesome!
    • -
    • North Central Region
Re: Enhanced Card List Spreadsheet
« Reply #6 on: September 16, 2011, 08:54:37 PM »
0
I would love it!
Press 1 for more options.

Lamborghini_diablo

  • Guest
  • Trade Count: (0)
Re: Enhanced Card List Spreadsheet
« Reply #7 on: September 16, 2011, 09:36:06 PM »
0
Alright, here's a sample of what the FOOF2 cards, look like, completely updated. I sorted these by the reference to show how the books, while not in biblical order, do clump properly (and in the right order within books).

You can also see the way I duplicated each dual brigade card with the reversed brigades.

Is there anything you'd like to see added or changed?


Rawrlolsauce!

  • Guest
  • Trade Count: (0)
Re: Enhanced Card List Spreadsheet
« Reply #8 on: September 16, 2011, 10:13:22 PM »
+3
I'd like to be able to sort cards by the categories of "Cards worth using", "Cards probably not worth using", and "cards never worth using/defense"

Offline ORS1949

  • Tournament Host
  • Trade Count: (+9)
  • *****
  • Posts: 111
    • Northeast Region
Re: Enhanced Card List Spreadsheet
« Reply #9 on: September 17, 2011, 12:56:25 AM »
0
  I would love a copy of this also !!

Offline SomeKittens

  • Tournament Host
  • Trade Count: (+10)
  • *****
  • Posts: 8102
    • -
    • Northeast Region
Re: Enhanced Card List Spreadsheet
« Reply #10 on: September 17, 2011, 01:53:10 AM »
+1
I'd love to have something like this!

I'd like to be able to sort cards by the categories of "Cards worth using", "Cards probably not worth using", and "cards never worth using/defense/Alan Rice custom card"
FTFY.
Mind not the ignorant fool on the other side of the screen!-BubbleBoy
Code: [Select]
postcount.add(1);

Offline Professoralstad

  • Tournament Host, Redemption Elder
  • Trade Count: (+47)
  • Hero Member
  • *****
  • Posts: 10841
  • Everything is Awesome!
    • -
    • North Central Region
Re: Enhanced Card List Spreadsheet
« Reply #11 on: September 17, 2011, 05:00:51 PM »
0
Did you still have the column from Bany's spreadsheet for quanitities of cards? That's helpful for collectors/T2 Players.
Press 1 for more options.

Lamborghini_diablo

  • Guest
  • Trade Count: (0)
Re: Enhanced Card List Spreadsheet
« Reply #12 on: September 17, 2011, 05:35:00 PM »
0
No, I took that out as I never used it. I suppose it wouldn't be hard to add that column... as it's just a blank column that you just add a number into.

Offline stefferweffer

  • Trade Count: (+17)
  • Hero Member
  • *****
  • Posts: 1775
Re: Enhanced Card List Spreadsheet
« Reply #13 on: September 17, 2011, 06:17:32 PM »
0
I would SO love to have something like this for the playgroup.  Thanks so much.

Offline Professoralstad

  • Tournament Host, Redemption Elder
  • Trade Count: (+47)
  • Hero Member
  • *****
  • Posts: 10841
  • Everything is Awesome!
    • -
    • North Central Region
Re: Enhanced Card List Spreadsheet
« Reply #14 on: September 18, 2011, 01:57:20 AM »
0
No, I took that out as I never used it. I suppose it wouldn't be hard to add that column... as it's just a blank column that you just add a number into.

I and I'm sure many others would appreciate it. Those of us who need multiples of cards especially.

Let us know if there's anything we can do for you. I know you don't have many/any physical cards, and wouldn't really have much of a use for them, but I feel like such an effort shouldn't go unrewarded.
Press 1 for more options.

Offline STAMP

  • Tournament Host
  • Trade Count: (+19)
  • *****
  • Posts: 5014
  • Redemption brings Freedom
    • -
    • Northwest Region
Re: Enhanced Card List Spreadsheet
« Reply #15 on: September 18, 2011, 11:02:06 PM »
+2
It's getting to the point where they really need to be in a database.
Final ANB errata: Return player to game.

Lamborghini_diablo

  • Guest
  • Trade Count: (0)
Re: Enhanced Card List Spreadsheet
« Reply #16 on: September 19, 2011, 01:48:36 AM »
0
One note, my class schedule is fairly busy this semester, so I can't exactly say when this will be done. I'll try to do it as quickly as I can due to the interest in the project.

Let us know if there's anything we can do for you. I know you don't have many/any physical cards, and wouldn't really have much of a use for them, but I feel like such an effort shouldn't go unrewarded.

I was already planning on doing this just for myself, so in a sense, I'm rewarding myself by finally doing it.  :D There's also the fact that, like you said, while I do have a decent collection of cards... I have never even had a chance to use them. So, I've stopped collecting them until I get that chance.

Though... I can think of one possible reward.........
Being a playtester would be super cool...  ;) (Hey, I can dream right?)

Offline Professoralstad

  • Tournament Host, Redemption Elder
  • Trade Count: (+47)
  • Hero Member
  • *****
  • Posts: 10841
  • Everything is Awesome!
    • -
    • North Central Region
Re: Enhanced Card List Spreadsheet
« Reply #17 on: September 19, 2011, 03:32:59 AM »
0
Though... I can think of one possible reward.........
Being a playtester would be super cool...  ;) (Hey, I can dream right?)

Well, that's not up to me, but I guess if Rob really likes the spreadsheet, you might have a chance...
Press 1 for more options.

Offline SomeKittens

  • Tournament Host
  • Trade Count: (+10)
  • *****
  • Posts: 8102
    • -
    • Northeast Region
Re: Enhanced Card List Spreadsheet
« Reply #18 on: September 19, 2011, 09:15:49 AM »
0
It's getting to the point where they really need to be in a database.
I do know there's a way to export a spreadsheet to XML.
Mind not the ignorant fool on the other side of the screen!-BubbleBoy
Code: [Select]
postcount.add(1);

Offline STAMP

  • Tournament Host
  • Trade Count: (+19)
  • *****
  • Posts: 5014
  • Redemption brings Freedom
    • -
    • Northwest Region
Re: Enhanced Card List Spreadsheet
« Reply #19 on: September 22, 2011, 05:24:05 PM »
0
It's getting to the point where they really need to be in a database.
I do know there's a way to export a spreadsheet to XML.

Or imported to SQL Server.  ;)   But it really needs some normalization first.   ;D
Final ANB errata: Return player to game.

Offline TheKarazyvicePresidentRR

  • Trade Count: (+4)
  • Hero Member
  • *****
  • Posts: 15781
  • Currently undead
    • -
    • Southeast Region
Re: Enhanced Card List Spreadsheet
« Reply #20 on: September 22, 2011, 10:18:58 PM »
0
Oh man, having it in SQL would be awesome. I would query that so much, as for me I'd love a copy.
Not quite a ghost...but not quite not.

Offline LordZardeck

  • RC! Founder/Creator
  • Trade Count: (+1)
  • Sr. Member
  • ****
  • Posts: 975
  • Programmer of all Languages \m/(>.<)\m/
    • -
    • Midwest Region
    • Redemption Connect!
Re: Enhanced Card List Spreadsheet
« Reply #21 on: December 30, 2011, 04:28:10 PM »
0
Oh man, having it in SQL would be awesome. I would query that so much, as for me I'd love a copy.
It's getting to the point where they really need to be in a database.

The Spreadsheet is in a database. Redemption Connect!'s card browser pulls from it. There will be a collection manager and spreadsheet view to it in the coming months, so keep checking back. If it's desired enough, I may even make an offline program so you can manage and sync your lists between RC! and your computer.

Lamborghini_diablo

  • Guest
  • Trade Count: (0)
Re: Enhanced Card List Spreadsheet
« Reply #22 on: December 30, 2011, 09:21:26 PM »
0
If people are wondering about this spreadsheet, I still have it, but school kept me MORE than busy, lol.

Offline SomeKittens

  • Tournament Host
  • Trade Count: (+10)
  • *****
  • Posts: 8102
    • -
    • Northeast Region
Re: Enhanced Card List Spreadsheet
« Reply #23 on: December 30, 2011, 09:23:57 PM »
0
I didn't mention this before, but to those who have this in database form, does anyone have it in XML?
Mind not the ignorant fool on the other side of the screen!-BubbleBoy
Code: [Select]
postcount.add(1);

Offline LordZardeck

  • RC! Founder/Creator
  • Trade Count: (+1)
  • Sr. Member
  • ****
  • Posts: 975
  • Programmer of all Languages \m/(>.<)\m/
    • -
    • Midwest Region
    • Redemption Connect!
Re: Enhanced Card List Spreadsheet
« Reply #24 on: December 30, 2011, 10:00:31 PM »
0
I didn't mention this before, but to those who have this in database form, does anyone have it in XML?

The database has been optimized and normalized into multiple tables, but if you don't mind that i can export it for you. I can give either xml or sql, whatever you'd prefer

 


SimplePortal 2.3.3 © 2008-2010, SimplePortal