Raid Comp Planning with Spreadsheets

Spreadsheets are the unsung heroes of raid organization. A well-designed raid planning spreadsheet tracks roster composition, mechanic assignments, cooldown rotations, and loot priorities in a format everyone can reference before and during raids.

Building Your Roster Spreadsheet

Create a master roster sheet listing every raider with their main character, class, specialization, off-specs, available alt characters, and attendance history. This single document provides the information raid leaders need to plan compositions for any given night.

Include columns for each raider’s best role and willingness to flex. A Paladin who mains Retribution but can play Holy in emergencies provides different flexibility than one who refuses to swap. Tracking this prevents awkward conversations when you need a last-minute role swap.

Color-code rows by role: tanks in blue, healers in green, DPS in red or yellow. This visual organization lets you scan the roster and instantly see whether you have enough of each role for tonight’s raid, even before counting individual players.

Google Sheets works well for raid spreadsheets because it allows real-time collaboration, is accessible from any device, and supports conditional formatting that automates visual indicators. A cell that turns red when a raider has missed three consecutive weeks flags attendance issues without manual tracking.

Encounter Assignment Sheets

For each progression boss, create an assignment tab mapping every mechanic to specific players. Column A lists the mechanic name and timing. Subsequent columns list the player assigned to each aspect of that mechanic. For a soak mechanic requiring three groups, list the members of each group explicitly.

Include diagrams alongside text assignments. A simple cell grid colored to represent arena positions, with player names placed in their assigned locations, communicates positioning more clearly than written descriptions. Most raiders can look at a colored grid and immediately understand where they stand for each phase.

Link your encounter assignment sheets to your roster sheet. If a raider is absent and replaced, updating their name in the roster can auto-populate changes across all encounter sheets, preventing the error of running an assignment with an absent player’s name still listed.

Cooldown Rotation Planning

A cooldown tracking tab lists every defensive and offensive raid cooldown available in your composition alongside their cooldown durations. Map these against the encounter timeline to create a visual rotation showing which cooldown covers each damage event.

Format the timeline as rows representing time intervals and columns representing each cooldown. Mark cells where a cooldown is assigned. A gap in coverage becomes immediately visible as an unmarked row where major damage occurs, flagging a planning error before you waste pulls discovering it in practice.

WoW’s Method Raid Tools addon can import note data from spreadsheets, allowing you to transfer your cooldown rotation from a planning document directly into in-game notes visible during the encounter.

Loot Priority and Tracking

A loot tab tracks which items each raider needs from each boss, their current gear in that slot, and the DPS or HPS gain the upgrade provides. Sorting by upgrade value identifies which drops provide the most group-wide benefit, guiding loot council decisions or informing personal bonus roll targets.

Track loot distribution history to ensure fairness over time. A raider who has received three items in two weeks might reasonably defer to a teammate who has received none, even if the current drop provides a larger individual upgrade.

Maintaining the Spreadsheet Long-Term

Assign a specific person to maintain the spreadsheet, typically an officer who enjoys organizational work. Update it after every raid night with attendance records, loot distributions, and any composition changes.

Archive each tier’s spreadsheet rather than overwriting it. Historical records of past compositions, strategies, and progression timelines provide valuable reference when planning future tiers and training new officers.

For more on planning tools, see our raid leading guide and strategy documentation guide.