Jump to content

Card and upgrade collector tool


MephistoRoss

Recommended Posts

Since everybody will start in Battlefore Reborn with just the starting cards and 0 upgrades, it will probably be the easiest way to gain the majority of the upgrades by playing PvE maps. Therefore, I made a tool in excel to help collecting cards and their upgrades. The idea is that you can insert all the cards you have and the upgrades you want (optional with a priority) in the tool and it will tell you which maps you will need to play. I added card information like edition, faction, type, tier, rarety, counter, size, power, swift/flying and the lootlist so you can easily sort and filter. Note that I inserted all data manual, so please let me know if you find a mistake.

 Cards_overview.thumb.PNG.61ec3803ae129f8
Screenshot 1: First tab 'Cards'

Here is how it works:
The columns that you need to insert yourself on the tab 'Cards' are:
-Own: the amount of that card that you own, all cards that are owned will automatically become bold text.
-Upgrades wanted: the upgrades (U1, U2 and U3) that you want for each card, dont include upgrades that you already got. Please note that you need to use "U1" "U2" and "U3" as the tool only will detect it that way.
-Priority: the priority of the upgrades that you want (this is optional), you can decide yourself what kind of scale you want to maintain, the tool will work as long as you only use numbers.
-(Price): the price of the card in the AH (this is an optional column that is not used in the rest of the tool), you can decide yourself if and how you want to use this. For example you can insert the last price you bought the card for or you can keep it updated with the current price of the card or insert the average lowest buyout price.

On the tab 'Upgrades wanted per map' it will show you the amount of card upgrades per map you filled in with U1 U2 U3 on the 'cards' tab. I made two views for this, on the top list I split up each difficulty and on the bottom list it has all maps/difficulties as a total (see screenshot 2). If you sort on priority, it will give you the total priority you assigned for all cards of which the upgrades are on that map. If you didnt use the priority column on the first tab, than you can sort it on the Upgrades so you get the maps with the most upgrades that you want. 

I already marked all the starting cards as 'Owned' and I set some priorities as example (see screenshot 1). On the second tab you can see that Bad Harvest on standard has 10 upgrades of cards I marked with U1 in the 'Upgrades wanted' column on the first tab and those 10 upgrades have a total priority of 28 making it the highest priority. This means I should play Bad Harvest on standard first for getting the upgrades that I want. After earning the upgrades, I should of course remove the ones I got from the first tab so that the total priority is recalculated automatically. You should keep in mind that for using upgrade 2 or 3 you will need upgrade 1 of course, so I suggest you start with the standard maps.

Map_overview_total.thumb.PNG.9ff06b373c0
Screenshot 2: Second tab 'Upgrades wanted per map'

I added some macros on the first tab (in the .xlsm file) to make searching for a card even easier and I added a couple buttons to clear the search, clear all filters and a default sorting method (by tier, faction, own) (see screenshot 1). But in case you dont want to use macros, I also added the normal .xlsx file (there is also a search option if you press the downward arrow for filtering). The file with macros has a minor bug though, when you filter on something the grey/white lines wont be alternately (different sortings works fine though). Normally I would assign the data as a table to fix this, but if I do that the macros will give errors because they reset the filters. Therefore I had to use conditional formatting based on even/odd row numbers. I will look into this later, but it is not a real problem though.

 

If people find a tool like this usefull, it would be great if the Devs could make something in the distant future so you can easily extract the data of cards you own and upgrades you have from the website so you can just copy/paste it in this excel file (or even better if they could integrate this excel functions in the website).

As a last note: the Amii edition upgrades are not possible to earn by playing PvE maps (you could only get them with tokens), it is uncertain if the Devs will change this. Also the following cards will need confirmation for U1: Twilight Creeper, Architect's Call, Northland Drake, Firesworn, Dying Breed, Cluster Explosion, Lost Converter, Revenant's Blessing, Lost Banestone, Lost Warlord, Sylvan Gate, Deathglider, Vileblood and Hatecaster. 

Please let me know what you think about this tool and if you have ideas to improve it or if you have got any questions.

Upgrades_collector_v1.5.xlsm

Upgrades_collector_v1.5.xlsx

Link to comment
Share on other sites

  • 2 weeks later...

Cool concept, but the thing that bothers me is that I could look up on Google where to get them instead of downloading this. But anyways good effort! +1

It probably does some sort of calculation to see which maps would net you the upgrades you want the most compared to the number of upgrades that you can use per map. Does save a lot of time.

 

Great Job Mephisto!

Link to comment
Share on other sites

It probably does some sort of calculation to see which maps would net you the upgrades you want the most compared to the number of upgrades that you can use per map. Does save a lot of time.

 

Great Job Mephisto!

Yep, you just need to mark which upgrades you want and it will calculate which map would net you the most upgrades that you want. You can even give upgrades a higher priority than others so that the map with the highest weighed upgrades will be calculated by taking the priorities into account.

And thanks :) 

Link to comment
Share on other sites

Yep, you just need to mark which upgrades you want and it will calculate which map would net you the most upgrades that you want. You can even give upgrades a higher priority than others so that the map with the highest weighed upgrades will be calculated by taking the priorities into account.

And thanks :) 

How are priorities taken into account? any specific numbers on that? Weightage and such?

Link to comment
Share on other sites

How are priorities taken into account? any specific numbers on that? Weightage and such?

It actually works really easy. You enter the priorities as a number, for example 1 to 10. For each map it will count all priorities of cards that have an upgrade in that map. So for example if you entered the priorities of two cards:
-Card X, which has U3 in Bad Harvest for which you entered a priority of 8.
-Card Y, which has U3 in Bad Harvest for which you entered a priority of 3.

It will give Bad Harvest on expert the priority of 11 (8+3). It does that for each map and it will sort the maps on highest sum of priority. Thus the map on top will be the map with the highest priority.

Link to comment
Share on other sites

  • 2 years later...

Hey thank you for that, but as a new player I would have a question regarding this:

On 4.9.2015 at 10:04 PM, MephistoRoss said:

....

I already marked all the starting cards as 'Owned' and I set some priorities as example (see screenshot 1).....

Are all the starting cards really marked? Because I cannot se a shadow t1 or nature t2.

Link to comment
Share on other sites

35 minutes ago, Tam Hawkins said:

Hey thank you for that, but as a new player I would have a question regarding this:

Are all the starting cards really marked? Because I cannot se a shadow t1 or nature t2.

Are you sure you dont have any filters enabled?

Cards_overview.thumb.PNG.61ec3803ae129f8

Link to comment
Share on other sites

1 hour ago, MephistoRoss said:

Are you sure you dont have any filters enabled?

Cards_overview.thumb.PNG.61ec3803ae129f8

Not 100% sure, but i clicked clear all filters (after allowing editing the sheet) and nothing changed, it also looks exactly like in your picture.

I also checked the remaining ~480 Cards and they are all not owned in the sheet.

Link to comment
Share on other sites

1 hour ago, Tam Hawkins said:

Hey thank you for that, but as a new player I would have a question regarding this:

Are all the starting cards really marked? Because I cannot se a shadow t1 or nature t2.

Wait a minute, there were no starting cards shadow t1 or nature t2. The ones in the screenshot are all the starting cards (F2P decks).

BTW, these are the starting cards of the old BF, Skylords Reborn may have other starting cards...

Tam Hawkins likes this
Link to comment
Share on other sites

1 hour ago, MephistoRoss said:

Wait a minute, there were no starting cards shadow t1 or nature t2. The ones in the screenshot are all the starting cards (F2P decks).

BTW, these are the starting cards of the old BF, Skylords Reborn may have other starting cards...

Ah, ok that explains it^^

Thanks for your answers.

Link to comment
Share on other sites

  • 4 weeks later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Terms of Use