Monster Card Spreadsheet

Discussion in 'Guides' started by SteveTrabajo, Dec 17, 2020.

  1. SteveTrabajo
    Offline

    SteveTrabajo Donator

    Joined:
    May 7, 2018
    Messages:
    114
    Likes Received:
    288
    Gender:
    Male
    Location:
    Israel
    Country Flag:
    IGN:
    SteveTrabajo
    Level:
    420
    Guild:
    Degeneracy
    [​IMG]
    ~meso ! Welcome ! ~meso
    So after card hunting for a while, I came to realize that the method my hunter friends and I were using to keep track of our progress was just ineffective and unorganized.
    Gave it some thought, and after a few days of hard work, I have finally come up with a better, cleaner, more organized spreadsheet, which includes (almost) everything a card hunter would need.

    How does it work?
    Well you're going to have to open it to see ~f17
    Just kidding, the spreadsheet is separated into two sheets:
    A "Colors" sheet, sorted by colors (just like in the book!), and a "Continents" sheet, sorted by... uhh... oh yeah, CONTINENTS! (IKR?).
    Depending on the version of the spreadsheet you choose (more on that below), you can fill either sheet, and the other sheet will update automatically.
    In addition, there are some nice features which include showing how many cards you're missing to complete a certain color set, a continent, or even a medal.

    Sounds good?
    Well, I'm not sharing!

    Oh, you really want to use it? fine..
    Here's how you can do it!

    Depending on your hunting preferences, I made two versions:
    1. Hunting by colors - following the book
    2. Hunting by continents - following a guide (shoutout to Becca's guide, the spreadsheet will work perfectly when using it)

    The reason behind this is I couldn't find a tool in Excel / Google Sheets to make a cell work both ways without breaking its formula (or creating a recursive loop which would end up in your PC EXPLODING, or the world collapsing on itself, both are pretty fun), and because coding in VBA sucks and I'm too lazy to learn a new language ~f8 (If anyone wants to help with that, PLEASE DO).

    Where was I.. oh right, two versions.

    Using the spreadsheet
    You have the option to either use the spreadsheet online, using Google Sheets, or the option to download it to your computer, using Microsoft Excel.
    Keep in mind, that if you do decide to download the online sheet, it will mess up the pictures.
    I RECOMMEND USING IT AT 70-75% Zoom (but do change it to your liking)

    Remember the two hunting preferences from before? Here's where you can use them:

    For people who prefer hunting by Colors (Click on the picture):
    [​IMG]
    (File > Make a Copy)

    For people who prefer hunting by Continents (Click on the picture):
    [​IMG]
    (File > Make a Copy)

    IF anything is broken (I hope it isn't f3) or you have feedback / tips or want to ask questions, please either comment below, or add me on Discord @ SteveTrabajo#6969

    Hope you enjoy!
     

    Attached Files:

    Last edited: Feb 5, 2021
    azura, Puddle, David2016 and 31 others like this.
  2. Dasha
    Offline

    Dasha Donator

    Joined:
    Sep 10, 2018
    Messages:
    3,839
    Likes Received:
    1,656
    Gender:
    Female
    Guild:
    Degeneracy
    First!

    -Chef kiss-

    [​IMG]
     
    SteveTrabajo likes this.
  3. Myoni
    Offline

    Myoni Donator

    Joined:
    Jan 28, 2018
    Messages:
    451
    Likes Received:
    689
    Location:
    USA
    Country Flag:
    IGN:
    Myoni
    Level:
    2OO
    Guild:
    Shark
    Second!
     
    Dasha and SteveTrabajo like this.
  4. McPew
    Online

    McPew Donator

    Joined:
    Jul 31, 2017
    Messages:
    196
    Likes Received:
    251
    Gender:
    Male
    Location:
    Dreaming in MS
    Country Flag:
    IGN:
    McPewPew
    Guild:
    Savior
    Bumperino for the man! Third!!
     
    Dasha and SteveTrabajo like this.
  5. Mooring
    Offline

    Mooring Donator

    Joined:
    Jun 14, 2019
    Messages:
    296
    Likes Received:
    216
    Gender:
    Male
    IGN:
    Shadock
    Level:
    200
    Guild:
    OHMS
    woah thank you so much sir!
     
    Dasha and SteveTrabajo like this.
  6. Kenny
    Offline

    Kenny Donator

    Joined:
    Dec 31, 2018
    Messages:
    4,729
    Likes Received:
    5,000
    Country Flag:
    IGN:
    Shadower
    Level:
    200
    [​IMG]
     
    SteveTrabajo likes this.
  7. dualeyjane
    Offline

    dualeyjane Active Member

    Joined:
    Oct 7, 2017
    Messages:
    39
    Likes Received:
    20
    Gender:
    Female
    Location:
    Malaysia
    Country Flag:
    IGN:
    Synxphia
    [​IMG]

    jokes aside it's a really good excel or card hunters! keep up my shweet steve >:D
     
    Dasha and SteveTrabajo like this.
  8. Dvir
    Offline

    Dvir Well-Known Member

    Joined:
    Jul 28, 2017
    Messages:
    172
    Likes Received:
    141
    Gender:
    Male
    thank you :)
     
    Dasha and SteveTrabajo like this.
  9. SteveTrabajo
    Offline

    SteveTrabajo Donator

    Joined:
    May 7, 2018
    Messages:
    114
    Likes Received:
    288
    Gender:
    Male
    Location:
    Israel
    Country Flag:
    IGN:
    SteveTrabajo
    Level:
    420
    Guild:
    Degeneracy
    Updated the spreadsheets with the new Ellin Forest mobs!
    In order to use it, you will need to "Make a Copy" again and transfer all the "Progress" bars into the new file.
    To do that, either select all the Progress bar cells, and copy-paste them into the new sheet, or type them again manually (preferably, to make sure you didn't forget to add a card)

    Also removed the Excel download option after I ran into some problems (Hopefully nobody used them) (If you did, PM me).
     
    Dasha, ikiru, LEMON MAN and 1 other person like this.
  10. mochikoala
    Offline

    mochikoala Member

    Joined:
    Aug 1, 2021
    Messages:
    7
    Likes Received:
    3
    Gender:
    Female
    Country Flag:
    IGN:
    mzkoala
    Level:
    75
    Guild:
    fastkill
    this is absolutely awesome, thank you so much for your hard work!

    sad i will never get to complete it now, it was fun while it lasted. thanks royals F4
     
    Last edited: Oct 10, 2021
    SteveTrabajo and Dasha like this.
  11. SteveTrabajo
    Offline

    SteveTrabajo Donator

    Joined:
    May 7, 2018
    Messages:
    114
    Likes Received:
    288
    Gender:
    Male
    Location:
    Israel
    Country Flag:
    IGN:
    SteveTrabajo
    Level:
    420
    Guild:
    Degeneracy
    Added the Lionheart Castle mobs to the spreadsheets.
    If anything's broken or anyone has any suggestions for something they would like to have in the spreadsheet, please let me know.
    Enjoy
     
    Kenny likes this.
  12. Comediante
    Offline

    Comediante Donator

    Joined:
    Mar 6, 2016
    Messages:
    548
    Likes Received:
    844
    Gender:
    Male
    Country Flag:
    IGN:
    Ucker
    Guild:
    Rice
    [​IMG]

    Put little Bacal in this beautiful Spreadsheet
     
  13. SteveTrabajo
    Offline

    SteveTrabajo Donator

    Joined:
    May 7, 2018
    Messages:
    114
    Likes Received:
    288
    Gender:
    Male
    Location:
    Israel
    Country Flag:
    IGN:
    SteveTrabajo
    Level:
    420
    Guild:
    Degeneracy
    Could you please send me a picture of its location in the monster book? I'm currently self-banned and can't check it. I will add it accordingly
     
  14. Comediante
    Offline

    Comediante Donator

    Joined:
    Mar 6, 2016
    Messages:
    548
    Likes Received:
    844
    Gender:
    Male
    Country Flag:
    IGN:
    Ucker
    Guild:
    Rice
  15. SteveTrabajo
    Offline

    SteveTrabajo Donator

    Joined:
    May 7, 2018
    Messages:
    114
    Likes Received:
    288
    Gender:
    Male
    Location:
    Israel
    Country Flag:
    IGN:
    SteveTrabajo
    Level:
    420
    Guild:
    Degeneracy
    Done, should be fine now :)
    Thanks for letting me know
     
  16. Comediante
    Offline

    Comediante Donator

    Joined:
    Mar 6, 2016
    Messages:
    548
    Likes Received:
    844
    Gender:
    Male
    Country Flag:
    IGN:
    Ucker
    Guild:
    Rice
    Thanks for this well-designed worksheet!

    [​IMG]
     
    JuliusOmega, Zancks, nut and 2 others like this.
  17. SteveTrabajo
    Offline

    SteveTrabajo Donator

    Joined:
    May 7, 2018
    Messages:
    114
    Likes Received:
    288
    Gender:
    Male
    Location:
    Israel
    Country Flag:
    IGN:
    SteveTrabajo
    Level:
    420
    Guild:
    Degeneracy
    Amazing!! You're one crazy person if you got every single card in the game! Props to you, it's an incredible achievement.
    Congrats! :D
     
    Zancks likes this.
  18. SteveTrabajo
    Offline

    SteveTrabajo Donator

    Joined:
    May 7, 2018
    Messages:
    114
    Likes Received:
    288
    Gender:
    Male
    Location:
    Israel
    Country Flag:
    IGN:
    SteveTrabajo
    Level:
    420
    Guild:
    Degeneracy
    Note: This spreadsheet is currently outdated as I haven't touched the game in over a year and a half.
    If this reply gets enough likes I'll know people want to use this and I shall update it accordingly.
    Thanks!
     
    bloodsicle, Joshy, Dvir and 1 other person like this.

Share This Page