So I have been working with excel a lot lately and to test some things out I made a spreadsheet for Magelo like info. Basically, you enter in the gear you are looking at and balance focuses versus stats.
There are 2 links here. The sample shows one that I did up. The other is a bare bones version for you to enter data into.
Anyone can feel free to use this if they please.
Instructions:
Download the SS
Enter the data for the gear set you would like to see
Enter a Base HP/AC/Mana, AA Mana, AA Stats
View Results
FYI: Base HP/AC don't have a large variance so finding someone on a close tier will give similar results
SoD_Kazelo_Sample
SoD_Kazelo_Bare
I would like to hear any suggestions or requests you may have.
Things I am working atm(although busy for a couple weeks before I can really look at this again):
1)I have base mana and AA mana algorithms, just need to mess with the data so they don't error out.
2)Calculate Attack
3)Calculate Base HP
4)Calculate Base AC
5)Make a tab per class if their are differences in the bases(which I assume their are)
6)Have each of the class tabs only contain stats relevant to that particular class (made this for ranger then decided to expand)
7)Figure out and add how to link data to drop downs. Ex:ranger air aug is 10hp... It would auto fill
There are 2 links here. The sample shows one that I did up. The other is a bare bones version for you to enter data into.
Anyone can feel free to use this if they please.
Instructions:
Download the SS
Enter the data for the gear set you would like to see
Enter a Base HP/AC/Mana, AA Mana, AA Stats
View Results
FYI: Base HP/AC don't have a large variance so finding someone on a close tier will give similar results
SoD_Kazelo_Sample
SoD_Kazelo_Bare
I would like to hear any suggestions or requests you may have.
Things I am working atm(although busy for a couple weeks before I can really look at this again):
1)I have base mana and AA mana algorithms, just need to mess with the data so they don't error out.
2)Calculate Attack
3)Calculate Base HP
4)Calculate Base AC
5)Make a tab per class if their are differences in the bases(which I assume their are)
6)Have each of the class tabs only contain stats relevant to that particular class (made this for ranger then decided to expand)
7)Figure out and add how to link data to drop downs. Ex:ranger air aug is 10hp... It would auto fill