https://i.filehostingsite/7Spnhb9/Spreadsheet.png ! Welcome ! 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 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 (If anyone wants to help with that, PLEASE DO). Where was I.. oh right, two versions. Using the spreadsheetYou 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): https://i.filehostingsite/Npd1pTy/Googlesheets.png (File > Make a Copy) For people who prefer hunting by Continents (Click on the picture): https://i.filehostingsite/Npd1pTy/Googlesheets.png (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!
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).
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
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
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
Amazing!! You're one crazy person if you got every single card in the game! Props to you, it's an incredible achievement. Congrats!
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!
hey everyone! updated the sheet and made it more future proof, adding new mobs in the future shouldnt break the sheet feel free to make a copy, i plan on keeping my own sheet up to date. suggestions are always welcome too here is the link to my sheet
lazy 10 minute vba script to allow you to edit either sheet - someone out there surely has google enterprise access and can use the macro convert to turn this to appscript so that it will work on the sheets file. Code: Private Sub Worksheet_Change(ByVal Target As Range) Dim sht As Worksheet, oSht As Worksheet Dim lCol As Long, lRow As Long, hdrRow As Long, olRow As Long, olColumn As Long, ohdrRow As Long Dim monsterName As String, olColStr As String Dim vArr As Variant Dim oCell As Range, monsterCell As Range ' switch oSht and sht declarations when implementing for Continents sheet Set sht = ThisWorkbook.Sheets("Colors") Set oSht = ThisWorkbook.Sheets("Continents") If sht.Name = ActiveSheet.Name Then ' change 5 if the header row is changed per sheet hdrRow = 5 ohdrRow = 5 lCol = sht.Cells(hdrRow, sht.Columns.Count).End(xlToLeft).Column olRow = oSht.UsedRange.Rows.Count olColumn = oSht.Cells(hdrRow, oSht.Columns.Count).End(xlToLeft).Column vArr = Split(Cells(1, olColumn).Address(True, False), "$") olColStr = vArr(0) ' loop through each cell if multiple are changed simultaneously For Each oCell In Target ' check for intersect in desired range If oCell.Column <= lCol And sht.Cells(hdrRow, oCell.Column).Value2 = "Progress" And oCell.Offset(0, -1).Value2 <> "" Then monsterName = oCell.Offset(0, -1).Value ' access range in the other sheet and find the cell with a matching value Set monsterCell = oSht.Range("A1:" & olColStr & olRow).Find(monsterName).Offset(0, 1) monsterCell.Value = oCell.Value End If Next oCell End If End Sub
