Scrapper DPA Spreadsheet.

I looked around and couldn't find something like this posted anywhere, so I put together spreadsheets of the DPA for each scrapper primary and APP/PPP power.

I was trying to decide on what scrapper to make next, preferably something I could turn into a main/badger since I've got picky requirements. Ended up doing this as a result to help my decisions.

Here's the spreadsheet:

ODS format (open office): http://www.mediafire.com/?yq76gxva9xabq3f

XLS format (MS excel): http://www.mediafire.com/?84o2pddd7q2m6t4

GoogleDocs: https://spreadsheets.google.com/ccc?...thkey=CJDikZoL

GoogleDocs formatting is a bit weird, dunno how to truncate the calculations on DPA. The other spreadsheets round off.

Still haven't decided on what to do for my power sets, though. Was thinking fire/fire/fire built towards 32.5% def. Been playing a lot of characters with straight def and no res (bane spider, fire/earth dom) that go 'splat!' when up against nasty AOEs (reichs is a good example). Getting a bit tired of that. Or maybe Fire/Elec/Fire.

Edit: The DPA for the blasts is, apparently, incorrect. Disregard.

At a quick glance, I think you're getting your numbers from Mids. The fire DOTs are averaged poorly and the epic blasts are shown doing twice as much damage as they actually do.

I would be careful with looking at DPA on individual powers in a vacuum, while it can help there's also many other things to consider - amount of self damage buffage being the most obvious one. I say this because you're mentioning fiery melee as the choice you're considering, and individual DPA numbers bring fire in the top spot by far, but it's not that above the other primaries in actual gameplay (although fire/fire is still a very damaging character).

I agree that just looking at DPA doesn't come close to giving you the whole picture(but you probably know that). Optimal attack chains, procs, damage buffs, are all more important things that should be taken into consideration.

Appreciate the effort though, it was an interesting read.

If you haven't seen it yet, take a look at this thread: http://boards.cityofheroes.com/showp...79&postcount=1

I figure someone will benefit from the data in the primaries. Looking at city of data, I'm having a bit of difficulty getting the actual values for some of the epic blasts, however. I suppose I'd need to look in game.

The raw DPA does give good ideas on where to start with optimizing attack chains, though. Something else I had difficulty finding, aside from ones I already know off the top of my head. I'm really looking for something that can chew into AVs, and decently AOE groups, while not getting his butt kicked by AOEs.

Calculating attack chains is one thing I don't know how to do, though. I can organize data and make basic calculations, but that's about it.

Edit: Doh, just saw your link after I posted. I'm not sure how I missed that in my search, but it may have to do with the last post being almost a year old.

Edit 2: Ont he other hand, those determinations are over 1.5 years old. With changes to powers, improvements in recharges, et al., perhaps newer determinations should be made.

I have a DPA spreadsheet of all blue-side ATs as of I16 or so (no Khelds), and a few red-side ATs as well, but haven't updated for some of the newer sets (pretty much after City of Data stopped updating). I still refer back to it from time to time (like when I wrote my guide in my sig), and think it's a very valuable resource, though keeping track of ST vs. AoEs, 2ndary effects, stacking bonuses or debuffs, etc, is almost impossible to do on one table. Scrappers are also a bit tough, because you have to either calculate the crit % as part of the DPA or just leave it out.

In any case, kudos for your efforts. I know how much of a pita it is to pull all the data.