Thanks for the reply
@flyingsolow I updated from .95 to the current version .96.1 and found some of the formulas in the Titan Damage Data to be incorrect. Total hits, total damage and average didnāt include the info in column E.
Iāve corrected the formulas on my end, but afraid they will break again once an update comes out, if the master sheet isnāt update.
Also the is no formula in M2 (Highest hit # of hits). I put in =if(J2<>0, INDEX(J24:J,MATCH(J2,I24:I,0)),āā) in that cell, based upon the 2 cells below it.
Youāre welcome @flyingsolow. Thanks for the super fast fix!!
Is there a way to maybe implement a way to export your data and import it into a new version? Maybe a button to copy your hero list, so to the new revision and import itā¦then move on to the next set of data?
Is there an easy way to get data from the game and get it into the spreadsheets?
Is it set up to manually input all data?
As far as I know most things are manually inputted. Thought I saw reference once to a screenshot app that can covert data.
Grimmy, thatās a great idea, however, I just spent some time briefly researching it and it seems thereās no āCopy to clipboardā functionality inside Google sheets for security reasons. The Ctrl+C needs to be manually done by the user. Maybe thereās another way, but nothing comes to mind.
Bummerā¦Just thinking out loudā¦could it be done with a macro?
Too bad all data wasnāt on one tab, like a database per say, where you could just copy the one tab, and paste that way. Iāll keep thinking, and report back if I think of something.
Thanks for keeping this up to date! Very handy tool!!
Flyingsolow has done an amazing job with this. Super impressed!
@flyingsolow Just found another item for your list. In the chest tab, the items you get, missing is Titan Energy Flask. Iām sure you know about the emblems that were just added to the game. Also, is there a such thing as an Alliance Energy Flask any more? I think that was before my time.
Pretty sure youāre talking about the same item. Before wars thatās what it was called, but they renamed it. Iāll adjust it. Thanks.
Let me start out by saying that you are doing a FANTASTIC job. There is no way I could do what you do ^.^ I do have a few questions though.
Will you be adding the class emblems into the chest tab? I am currently just adding them in after the fact because I cannot just leave out a chest item lol. Also, any date on when Onatel will be added to the roster?
Onatel is in the roster. That being said, Iām considering changing some of this data like hero lists, item lists, titan lists to be update automatically by referencing a master copy of the data. This could prevent future need to update the version of the spreadsheet except for when thereās actually new features like adding a class column.
I will get to adding the emblems today (and probably a class column as well).
Oh no, I always got the updates, it would tell me to reload my sheet whenever you would update anything, but I didnāt get this update. I just copied a new sheet and saw Onatel is added., but she is still not showing up in my sheet. I did get the last update where Titan flasks were changed to Alliance flasks though, so I am not sure what happened. I REALLY hope I donāt have to start a new sheet because I have customized this sheet to be absolutely perfect for me Do you know if there is a way to try and manually update my sheet to get the latest update?
Add me on Line. Easier to work it out that way. id: flyingsolow
Not sure if anyone else is having this issue or not
Where some of the Tier data is offset along with the levels. Iāve noticed it more with the newer heros but I know Morgan and King Arthur have been around awhile as well. The offset data appears as a different font as wellā¦bigger at least
99% sure thatās your own doing. I tested and found that all of those cells have the same font, alignment, and bold setting. I donāt have a good idea how those changes wouldāve occurred without you knowing about them, but maybe you were copy/pasting values from elsewhere? Either way, you have control of fixing it by adjusting the font, alignment, etc yourself.
Iāve never worked with spreadsheets in the past and have no idea how to go about changing the dataā¦Guess Iāll play around with it and see what I can figure out.
Thatās surprising to hear. Itās actually very easy. Spreadsheets 101. Click on a cell and drag your mouse to select multiple cells. Then to adjust the font click on the dropdown below the Add-ons menu. The default is Calibri. To adjust the boldness, click the B to the right of the font size. The alignment is the 7th icon to the right of the B.
Alrightyā¦that was easyā¦Thank you!!! All fixed now