I needed info about what raid buffs are available, which stack with which, how much they buff their stat, and how much they buff my DPS.

I tried to find this data at one place, but without much success, so I created my own XLS where I combined:

WoW_Raid_Buffs.xls

It features:
1) list of all buff types with buff names (color coded by class). Buffs in same buff type (same row) do not stack. List is further separated in 4 parts:
-caster only buffs,
-common (caster & melee) buffs,
-melee only buffs
-non-DPS (defensive) buffs

2) each buff type is mapped to class and build that has that buff. Buffs are vertical (B3-B37), classes/builds are horizontal (F2-AI2), and buff values are in cells. This enables me to see what class can cast which type of buff, who has best buff, and what classes can substitute same or similar buff.

3) select what classes/build are present in raid, and find out what buffs are available. Selection is done in yellow row at F38-AI38 (just enter number of players of that build/class present, or empty if none). Best available buff values are shown in column D, next to each buff type (D3-D37). That way if you have enh shaman you will see 144 in D4 for "Increased Spell Power Buff", but if you have ele shaman you will see 280.

4) estimate of DPS value of each buff, shown in column E (E3-E37). This is optional feature that helps me see what i miss if some buff is missing. Since buffs have very different effect on different classes (for example spell crit buff do not help melee ), to get DPS values I needed to define how each basic stat (INT,SPI,STR,AGI, +dmg, +crit, +haste...) is valuable to DPS. That is defined in first sheet named "Player values". First half are your stats as player. Second half define how much DPS is each 1 stat for you.

5) estimate of DPS benefit from buffs for all and every class/build and raid as whole. You can see estimate of how much each class benefit DPS from buffs in row 40 "Player Buffs", or see estimated total DPS for that class in row 41 "Player DPS", or see those values multiplied by number of present classes to show total buff benefits and expected DPS for raid in rows 42/43. This is even more optional than #4, and is based on estimated values of stats for each class/build, similar to estimated values for you on "Player values" sheet from #4. But since this time I needed values for every class, I put them below yellow row, in F47-AI71.



One reason why i posted this here is to save time and effort for those who needed similar info. But other reason I posted here is to get data checked. While data for #1 should be fairly accurate since I found that list on two sources on web, I needed manually to collect data for #2 (buff values across builds/classes). While it should be correct, it is still possible that i listed some buff that som ebuild does or does not have as stated, and I would appreciate feedback/corrections.

"Optional" part of XLS, where DPS gains are estimated, is also something where I estimated values of each stat for each build/class. For locks they should be close to ok since they are from DPS calc XLS and simulatorcraft. For other casters those are from simulatorcrafts so less accurate but close. For Rogues its from their XLS sheet, so should be close. For some other melees its from maxDPS.com site, and not sure how accurate those are. Anyway, if you see some big error on those numbers too, post here and I'll fix even if that feature (DPS guessing) is not primary reason for this table.

I used that too, and it is good, but it lacks several things for me:

- how easily to see which class/build has certain type of buff? For example, who has Melee haste? Not only which class, but which build. You can not see that only Frost DK has it, not other DKs, since mmo-champion has only color codes for classes (unless you drag and drop on or off builds to check which buffs you get, but thats slow).

- how easily to see value of buff for different classes/builds, ie who has best buff. While you can read tooltips, its slow that way, and does not show influence of talents/builds on buffs.

- how easily to see DPS value of buff? You can not see that in any way on above link.

If you browse over a buff, the specs that have it get a lighter shade.

Link appears to be broken. Anyone have the xls tucked away somewhere, I'd love to take a look at it