*Author

miniwally

  • Guest
Data Collection https://elementscommunity.org/forum/index.php?topic=5188.msg51820#msg51820
« on: April 11, 2010, 08:08:36 pm »
Ok as some of you in chat may know I've been working on an excel spreadsheet that gives information on your cards.

Here is what it does
  • Says how many rares you have
  • Says how many overall cards you have
  • Says how many upgrades/unupgraded cards you have
  • Says how many cards you have "completely collected" (in my eyes that means 6 copies of it or 15 if it's pillars
  • The cost of buying all your cards 9this could be great if you're going to post a deck idea on forums so you can also post the cost of buying it
  • The cost of selling all the cards
  • Can input it via the import codes (this was made by Markilleruk so thanks for this goes to him)
An important note: rare buying value is based on selling value

Version with it is in the attachments.
Version without automatic uploader http://www.filefront.com/16100509/Totals%20Blank%20V1_1.xls

Offline markilleruk

  • Jr. Member
  • **
  • Posts: 162
  • Reputation Power: 2
  • markilleruk is a Spark waiting for a buff.
  • New to Elements
Re: Elements Collection Analyser https://elementscommunity.org/forum/index.php?topic=5188.msg51824#msg51824
« Reply #1 on: April 11, 2010, 08:12:40 pm »
Great job wally, I know this took a lot of time and effort - especially all the data input and finding the card codes. - does anyone know the code for relics as it is missing? (temporary xxx yyy is wrong)

The code extraction is pretty simple - use import/export to get all of your cards for a particular elements cods and paste them into the mini card code chart at the bottom - this means you don't have to manually input card totals so is much faster.

killfer8

  • Guest
Re: Data Collection https://elementscommunity.org/forum/index.php?topic=5188.msg52039#msg52039
« Reply #2 on: April 12, 2010, 01:51:00 am »
what chart Mark?

miniwally

  • Guest
Re: Data Collection https://elementscommunity.org/forum/index.php?topic=5188.msg52041#msg52041
« Reply #3 on: April 12, 2010, 01:55:40 am »
If you've downloaded the excel file via the first link then there's a card importer chart at the bottom.

Offline Jangoo

  • Sr. Member
  • ****
  • Posts: 877
  • Reputation Power: 0
  • Jangoo hides under a Cloak.
  • New to You
Re: Elements Collection Analyser https://elementscommunity.org/forum/index.php?topic=5188.msg52154#msg52154
« Reply #4 on: April 12, 2010, 10:45:07 am »
does anyone know the code for relics as it is missing? (temporary xxx yyy is wrong)

The code extraction is pretty simple - use import/export to get all of your cards for a particular elements cods and paste them into the mini card code chart at the bottom - this means you don't have to manually input card totals so is much faster.
"4t9" is the relic-code (unupped ;-))
65 elecs is the sell-value. [wasn't it some 100 elecs a while ago?]

Thanks a bunch for this awesome tool ... let's see what the collection is worth. ;-)

I assume if you have more than 60 cards for one Element you have to switch out the cards you filled in already for the next 60 cards ... ?






miniwally

  • Guest
Re: Data Collection https://elementscommunity.org/forum/index.php?topic=5188.msg52157#msg52157
« Reply #5 on: April 12, 2010, 10:56:37 am »
does anyone know the code for relics as it is missing? (temporary xxx yyy is wrong)

The code extraction is pretty simple - use import/export to get all of your cards for a particular elements cods and paste them into the mini card code chart at the bottom - this means you don't have to manually input card totals so is much faster.

"4t9" is the relic-code (unupped ;-))
65 elecs is the sell-value. [wasn't it some 100 elecs a while ago?]

Thanks a bunch for this awesome tool ... let's see what the collection is worth. ;-)

I assume if you have more than 60 cards for one Element you have to switch out the cards you filled in already for the next 60 cards ... ?
Yes you'd have to reupload them in a new deck hope it helps I wasn't planning on releasing it but a couple of people expressed interest. Thank you for the relic code I'll update the download and if you could find out upgraded stuff then that' be great.

Offline Jangoo

  • Sr. Member
  • ****
  • Posts: 877
  • Reputation Power: 0
  • Jangoo hides under a Cloak.
  • New to You
Re: Data Collection https://elementscommunity.org/forum/index.php?topic=5188.msg52176#msg52176
« Reply #6 on: April 12, 2010, 12:40:23 pm »
Ok, back from food and collection-upload.

It seems to work really well. The only thing is that there are a few bugs in the card-codes that will lead to screwed up data when uploading via the import-function.

Here are the ones I discovered in a quick bug-report:

un-upped:

- switch codes for SoGs and SoDs (SoD: 4t6, SoG: 4t7)
- Lobotomizer: 61u (not 6lu)
- water-mark is quite scrambled:
Squid: 5ib
Toadfish: 5ie
Ice Drag: 5id
mindflayer: 5if
nymphtears: 5ig
flood: 5ih

upped:

- Life:
feralbond: 7am
epinephrine: 7an
(both 7am so far)

- Water:
change codes from 7qX to 7gX
for: Poseidon, Pufferfish, Ulitharid, Arctic Octo, Arc.Drag.

Probably not comprehensive since I dont have all the cards, but if everyone charting his collection checks up on the mistakes he finds, this will probably be easier than having to go over all the codes one by one again.

Thank you for the relic code I'll update the download and if you could find out upgraded stuff then that' be great.
Are you talking about the upped relic-code?
If so, I dont think you need it in there: Nobody would upgrade a useless relic and if so, he might as well sell it again right away. Also relics cant be bought in the trainer so finding out the cheap way isn't possible. ;-)


Offline pepokish

  • Full Member
  • ***
  • Posts: 377
  • Country: us
  • Reputation Power: 6
  • pepokish is a Spark waiting for a buff.
  • Honorary Team Life Member! <3
  • Awards: Real Life Elementalist
Re: Data Collection https://elementscommunity.org/forum/index.php?topic=5188.msg52178#msg52178
« Reply #7 on: April 12, 2010, 12:48:33 pm »
Awesome job, mini!  I know you poured a lot of blood, sweat, and tears into this, and I think it's safe to say that the finished product is well worth the effort.

Offline Jangoo

  • Sr. Member
  • ****
  • Posts: 877
  • Reputation Power: 0
  • Jangoo hides under a Cloak.
  • New to You
Re: Data Collection https://elementscommunity.org/forum/index.php?topic=5188.msg52179#msg52179
« Reply #8 on: April 12, 2010, 12:54:05 pm »


Hehe, I actually found the code for upped relic here (http://ftbhrygvn.x10hosting.com/elements/code/): 6rp

I don't know how ftbhrygvn linked the whole thing up but since all the decks requested actually show the correct cards I suppose that the codes correspond correctly with the ingame-codes.


miniwally

  • Guest
Re: Data Collection https://elementscommunity.org/forum/index.php?topic=5188.msg52185#msg52185
« Reply #9 on: April 12, 2010, 01:04:18 pm »
Ok, back from food and collection-upload.

It seems to work really well. The only thing is that there are a few bugs in the card-codes that will lead to screwed up data when uploading via the import-function.

Here are the ones I discovered in a quick bug-report:

un-upped:

- switch codes for SoGs and SoDs (SoD: 4t6, SoG: 4t7)
- Lobotomizer: 61u (not 6lu)
- water-mark is quite scrambled:
Squid: 5ib
Toadfish: 5ie
Ice Drag: 5id
mindflayer: 5if
nymphtears: 5ig
flood: 5ih

upped:

- Life:
feralbond: 7am
epinephrine: 7an
(both 7am so far)

- Water:
change codes from 7qX to 7gX
for: Poseidon, Pufferfish, Ulitharid, Arctic Octo, Arc.Drag.

Probably not comprehensive since I dont have all the cards, but if everyone charting his collection checks up on the mistakes he finds, this will probably be easier than having to go over all the codes one by one again.

Thank you for the relic code I'll update the download and if you could find out upgraded stuff then that' be great.
Are you talking about the upped relic-code?
If so, I dont think you need it in there: Nobody would upgrade a useless relic and if so, he might as well sell it again right away. Also relics cant be bought in the trainer so finding out the cheap way isn't possible. ;-)
Thank you I edited some stuff in the new version but didn't notice all these I'll fix them ASAP not surprised there's some mistakes and I was unsure whether they were l or 1 so that's the reason for a view mistakes.

Reason for the upped relic code is if they're collecting them all.

Scaredgirl

  • Guest
Re: Data Collection https://elementscommunity.org/forum/index.php?topic=5188.msg52186#msg52186
« Reply #10 on: April 12, 2010, 01:12:58 pm »
Good job.

I recommend you post the files as forum post attachments so it's easier to download.

miniwally

  • Guest
Re: Data Collection https://elementscommunity.org/forum/index.php?topic=5188.msg52188#msg52188
« Reply #11 on: April 12, 2010, 01:13:52 pm »
Good job.

I recommend you post the files as forum post attachments so it's easier to download.
Didn't know that was possible I'll do that with the corrected version.

 

anything
blarg: