Friday, December 11, 2020

Raid Shadow Legends MASSIVE spreadsheet database tier list

03/21/2021 new version is here https://wickedwallz.blogspot.com/2021/03/raid-shadow-legends-massive-spreadsheet.html

03/08/2021 UPDATE, I removed the download link for this because in a few days I will be releasing a new, improved and MUCH more detailed spreadsheet, updated with the latest champs and a lot of fixes, changes and add ins, stay tuned!!!!



 Here's something completely different from me that I have been working on for a little while.

This is a massive project I put together to be a huge checklist and database for all your Raid Shadow Legends needs. I play on Bluestacks on PC and have 3 solid game accounts, so I use it to keep track of well, everything! 

Let me break it down, your main sheet is your database. It has Chosen's and Hell Hades tier lists in it HOWEVER it is NOT to be another tier list, only use those as guidelines. I have put in areas for you to list all of your own champions' setups like exactly what type of gauntlets you're using, how much HP your champ has and so on. The main point is team building, especially helpful for Faction Wars and Doom Tower. I have quite a lot of the champions' skills listed as well, but not every one of them but that's an easy thing for you to add yourself for the champs you have.

In this zip file are 2 versions of the spreadsheet. The public version is the one you'll use, the other version is my version you can use to get an idea of what to do with this. The best champion to look at on my sheet is Valkyrie. Mine does not have any queries in it as my example is to really show you what to do with the spreadsheet itself.



After downloading in order for the queries to work you MUST change the file location in Excel to point to wherever you saved this spreadsheet to. Here's how. After opening it in Excel, go to the Data tab and click on the Queries and connections button. This opens a sidebar that has at the top Champs Master List Master Query. Highlight it and a bubble pops out, click edit. You'll see a new window called power query editor, in the ribbon click the "data source settings" button. Click browse, select the one you downloaded (the one you're actually working in works even if it's opened) then click close and load and that's it! You most likely will get "there's a problem with the clipboard....." errors, that's fine because this file is so large, just keep clicking ok lol. Unfortunately when you do that the row sizes get all screwed up so you'll want to shrink them down, been trying to figure out how to lock the sizes but I can't lol.

Its best after that to not edit the Champs Master Query as you might break something, instead make a copy of it and edit away. You see an example of the edits in the Arena Query.


Anyway, any questions ask away, its a complicated file and Im not the best with Excel so its FAR from perfect but it came out pretty cool. Hopefully it can help some of you! One thing to note is there will be NO updates to this because if you were to start filling this one out then I update it a month from now it would be a massive mess for you to add in any updates without losing you user data. You can easily add new champions and of course duplicate the champs you own like I did!




A couple of screenshots to show what it is might help LOL!!!!

This first one you can see where I added my team and sorted by owned.

This shot you see a couple things, first I put in the info on my gearing for Hellgazer, see where I put a note about needing to change to speed boots? Little things like that are what makes this so useful, put notes wherever you need to help better manage your builds. Also you see the Doom Tower notes, this is MAD helpful and you just add in any champs you find to help you with each boss!


9 comments:

  1. Why are there duplicate Champs? Or is that just me?

    ReplyDelete
    Replies
    1. on my main list I duplicate any champs I own so on the public release sheet I may have forgotten to delete the dupes.

      Delete
  2. Looks very cool, but is there a legend? How are you ranking them for the different dungeons? (1-8?) What are the different colors in the dungeons for? What is "HH"?

    ReplyDelete
    Replies
    1. So sorry I didnt see this sooner. I am going to release a new version of this in a few days with plenty of explanations on whats going on. The 2 ratings system is from the 2 biggest content creators tier lists, Chosen and Hell Hades, the HH labeled ratings are Hell Hades.

      Delete
  3. Here's a LibreOffice tip for making the top line of your spreadsheet easier to read!
    1. Select the first row with column header info.
    2. Right click - select format cells
    3. Select Alignment tab
    4. Select 30 degrees for text angle
    5. Select LOWER edge as reference.
    6. Apply. Then go back into cell format and increase size of your font to say size 12 calibre and see how it looks :)
    Thanks for sharing your hard work. The above is a thank you for sharing.

    ReplyDelete
    Replies
    1. Thank you for this! I use Excel and im still learning it Lol, I'll try this in there see if it works!

      Delete
  4. Additional note, column width can still limit how much text you can read even if it's slanted. If you are having trouble seeing the text in the column header, try making the column just a tiny bit wider to reveal the cut-off text.
    Kind Regards, UberNoob2 - See you on Raid: Shadow Realms

    ReplyDelete
  5. Mystery Shard: Common, Uncommon, Rare
    Ancient Shard: Rare, Epic, Legendary
    Void Shard: Rare, Epic, Legendary
    Sacred Shard: Epic, Legendary More...

    ReplyDelete
  6. Check Here https://www.youtube.com/watch?v=-AAGzejdqWM

    ReplyDelete