PriceCzech wrote: I've taken the original Roster sheet and made some modifications and cleaned it up a bit (down to the essentials). I've made it to where the stats pull from the Wiki, so no updates to the sheets will need to be done, just the Wiki pages. I also add new characters within a day or so of them being announced. Those of you who have used the roster in the past and want to try mine out, be aware that the order of colors on the roster is different, so copy the values accordingly. Let me know if there are issues or errors, and I'll do my best to fix them.https://docs.google.com/spreadsheets/d/1OZ1_baGKbeNxR04jEhUPLojo7XUp91K56RYoUGACA-8 Feel free to give me feedback or ideas for improvements.
caesar46 wrote: Hi, I was also working on a new roster sheet for myself and this is what I came up with. Maybe it can be of use to someone, giving ideas. It's currently filled with my roster but I believe it's easy to adjust for anyone. You just have to fill out the current level and the number of covers/color you have and everything else is calculated (including HP, ISO to level and tile strength).https://docs.google.com/spreadsheets/d/ ... sp=sharing (P.S.: many thanks to the guys who collected the data and created the previous roster sheets)
evanbernstein wrote: When a new character is added: - are people copying the master sheet and re-entering all their data again? - is there an easy way to edit your copy to add the new character without messing everything up?
chanz0r wrote: I have looked at all the linked templates and could not see an up to date one so thought I would ask if anyone has one they could link please before I attempt to do it myself! I noticed some data on wiki is not entered with some levels. Is there a formula to it or another way to work out the missing info. I'm mainly after an easy way to track my rosters stats to put together teams. Thanks
alaeth wrote: One thing I feel is missing from the spreadsheet 'Team' tab is a like a flag or check-box or something to determine who tanks which colors taking into account minor & major boosts. Take the current story event for example (in my case): Punisher: level 43 - boosted to 73 (+30 levels) Original Black Widow: level 94 - boosted to 134 (+30 levels) I know that OBW tanks black, blue, and purple - but only from playing a few of the nodes.
Trisul wrote: I think the next step in the spreadsheet is just to list out generic 1*, 2*, 3*, and 4* match values and be able to intelligently match them to characters based on primary, secondary, tertiary colors (and also for their weak colors).
Trisul wrote: I really love PriceCzech's spreadsheet and still use it. Big bummer though since the importhtml change. I'm not familiar with some of the more advanced formulas and settings, but I think the next step in the spreadsheet is just to list out generic 1*, 2*, 3*, and 4* match values and be able to intelligently match them to characters based on primary, secondary, tertiary colors (and also for their weak colors). They could even account for 1.5x, 90, 40, and 30 level boosts to plan ahead for featured characters.