(Tool) Alliance War Team Planner

heroes
alliance-wars
ascension_materials
tool

#101

@flyingsolow I was playing around with the AW team planning sheet and noticed the Hero Power isn’t pulling any data. Currently coming up as N/A.


#102

Fixed!

I had added a column for the Atlantis families in the hero list which made the hero power lookup off by 1 column.

Thanks for letting me know.


#103

@flyingsolow … Hi! here I arrive maybe with the most stupid question of all… but… please be patient with me))
Where can I find the file??(!!)


#104

#105

Thank you very much!! I appreciate that you continue to work on this file.
I started to use the file a while ago to track my heroes and mats more than for AW, chests and Titans.
So I more look to that part… and might disturb you about it (!!)
Or do you know a spreadsheet focused on heroes and heroes development?


#106

EDIT: user error, disregard


#107

@Melchior, how long wait for new version with health of 11 and 12 star titans?


#108

@MCa I don’t know another public spreadsheet that’s solely focused on tracking your roster of heroes and ascension items. I know many people make their own from scratch. Let me know any improvements you’d like me to make to the roster section.


#109

@LEN1N78 I’m currently managing the spreadsheet. I just need 11/12* Titan HP data. I’ve filled in what I’ve found on random forum posts and my own experience with 11* Titans, but if you send me HP data, I’ll put it into the sheet.


#110

In case you are gathering rare data too, here’s our current dragon rooster:

Btw our last 4 titans had exactly the same HP 4.378k

image


#111

@flyingsolow - couple things I noticed:

  • missing Mok-Arr, between heroes

  • when assigning ascension material to 3rd tier to blue or green, it counts chainmails not needed

    Thanks!


#112

@flyingsolow Thanks again for your work. Would it be possible that you update http://7ddgaming.com/2018/02/27/7dr-hero-ascension-item-tool/ with the right version number and eventually the date of your last update ? It would be easy to follow your changes


#113

Updated with latest heroes. Thanks @MCa you were totally right about the ascension items.


#114

Added December HOTM & Christmas Heroes.


#115

You are doing an amazing job with this mate. I am super impressed!!!

Mel


#116

Is there a good layout for tracking War Results?


#117

Good question :slight_smile:


#118

Thank you for the update!!!


#119

I just started using this amazing tool.
Can Kage be added to the list of new heroes, I try but the sheet is locked.

Thanks!


#120

@parallelsys read the instructions included in the sheet or watch the videos: I wonder if you are not trying to overwrite the original file.

PC : Make a Copy and enter a new name for the sheet. This will save a copy of the sheet into your google storage.

Phone - Android Click the three dots on the right at the top of the screen. Select Share & Export. Select Make a copy.

Be sure to master google sheets before modifying anything because of the scripts and macros. The hero list in on an hidden sheet