I read over the rules and this should be OK. I tried google sheets and it BUTCHERS my named regions, which is needed for the workbook to have *no macros* which means you don't need to worry about stuff running that you don't want! https://www.dropbox.com/s/3qbl5t6yg9jirvu/Shop%20Heroes%20Parties%20v.95%205-20-2016.xlsx?dl=1Also, just a *huge* shoutout to Richard and his Item Spreadsheet. This would not have been possible if not for the work he has already put in.
Been working on this a few weeks now, and I'm ready for other people to touch my little baby
... so here it is! The link above is an excel spreadsheet (I *think* you will have to have Excel 2010+ to use) that you can use to determine what your parties power level / happy face will be when you run them on a quest. VERY useful when you're trying to figure out what items you need to get all greens WITHOUT having to buy the items, or if you want to see how much you can strip off someone while still getting a green face.
In its current state it calculates for all skills that increase power (survivability just increases power...). You may see power levels be off by a few points, but they are VERY accurate. The biggest caveat I have with this sheet is I cannot find tables of hero power based on level, so those pages are quite bare. You will probably have to fill them in for your heroes levels (and I'd like to know what they are so I can fill them in!!).
It is locked, and that's not because I don't want people to see my formula's... I just want to protect the integrity of them so you dont mess them up! I've deployed plenty of excel workbooks and I know that as soon as they are unlocked people mess up EVERYTHING!
Workbook has no macros, so there should be no worries about security.
Totally open to constructive feedback, if there's something you'd like to see added/changed I'm always willing to hear.
The biggest thing I've learned from this project, in addition to what I've seen on the forums, is Amazon/Brother is ABSOLUTELY the best item to have, followed by as many Protectors as you can get! Also, it is FAR better (well, cheaper) to have a lower level Mythical than a higher level epic/legend when you're gearing for energetic/healer.