Why standard boss guides fall apart for cosmetic runs
I spent three months trying to farm Malenia's scarlet aura particles for a specific build aesthetic. The official wiki gives you damage numbers and frame data. It does not tell you which rot bloom pattern lines up with the Godrick armor trim in your camera angle. That is the gap this workbook fills. It is a community-maintained spreadsheet and visual reference that maps boss encounters to their aesthetic properties — particle effects, color grading shifts, animation silhouettes, and environmental cues that matter for cosmetic runs, speedrun camera tricks, or content creation. The core sheet tracks over two hundred boss variations across the base game and Shadow of the Erdtree expansion. Each row contains the boss name, encounter variant, timestamp for key visual moments, and links to video references so you do not have to hunt through footage yourself. The format is not polished. The layout looks like something someone built in a weekend and never stopped adding to. That is also why it stays current. When Miyazaki's team patched Radahn's meteor trail colors in a hotfix, the workbook was updated within forty-eight hours. Official databases took weeks longer or ignored the change entirely.
How to use it without wasting two hours
Start by opening the tracker tab. Filter by encounter type, not just boss name. This matters because Margit and the Demi-God Margit are visually distinct in ways that affect camera positioning. The workbook flags these variants with a letter code. Margit is M1, the demigod version is M2. If you skip that step you will time your screenshot or clip for the wrong encounter and lose the sequence. Next, cross-reference the effect column. This is where most people get stuck. The workbook lists particle IDs alongside visual descriptions. Particle IDs are not intuitive. You need to match them to what you see in-game. I keep a second monitor open with InGameShader or a similar mod that displays active particle overlays while I verify the effect against the spreadsheet. This cuts my verification time from twenty minutes per boss down to roughly four. Once you confirm the effect, note the frame-accurate timestamp. The workbook gives timestamps in MM:SS format using the unmodded boss health bar as a reference point. Your replay might differ by a frame or two depending on your latency settings or loading sequence. Always buffer three frames ahead when recording. The difference between a clean capture and a clipped frame is usually one or two seconds at most.
Aesthetic Elden Ring Boss Workbook download and access
The primary workbook lives on Google Sheets. The link circulates on the relevant subreddit and the Discord server for cosmetic Elden Ring content creators. Search for the thread titled "Boss Aesthetic Reference v4.2" posted by the maintainer. Do not download copies from third-party sites. They are often weeks out of date and sometimes contain corrupted rows that throw off your timestamps. There is also a companion database that some people use alongside the main sheet. It tracks NPC aesthetic states, weapon sheen variations, and helmet visibility through different armor combinations. This is optional but useful if you are building a reference library for modding purposes. The NPC sheet is less frequently updated. Expect a lag of one to two weeks behind the main workbook for new discoveries.
Get the Full Details

What the workbook does not cover and when to look elsewhere
The single biggest limitation is that the workbook focuses on boss encounters only. It does not track environmental aesthetics, site of grace lighting changes, or item pickup VFX. If you need those, you are better off using a dedicated shader debug tool or the community's separate environmental reference sheet, which is harder to find and less organized. I recommend keeping both open. Switching between them takes about thirty seconds once you have the tabs arranged correctly. Another gap is co-op aesthetics. The workbook assumes single-player observation. Boss particle effects can render differently when multiple players are present. I ran into this specifically with the Red Wolf of Radagon. The wolf's magic orb trail appears noticeably brighter in co-op. The workbook lists the single-player values. I spent an afternoon re-recording the co-op variant timestamps myself and submitted them to the maintainer. They were merged into the next update. It took about a week before my submission appeared in the live sheet. If you notice inconsistencies, record and submit rather than assuming the data is wrong. Most issues are edge cases the maintainers have not hit yet. A third limitation is that the workbook does not include PC-specific visual mod interactions. If you are running Reshade or ENB presets, the color values in the spreadsheet will not match your screen output. The timestamps are still valid but the color references become unreliable. This is obvious if you think about it but worth stating plainly. Plan your captures with default graphics settings first, then apply your visual mods after you have the timing locked down.
Advanced tip that nobody mentions
Use the workbook's comment field for your own notes. Every row has a free-text column. I use this to log my personal camera angles, lens settings, and any RNG variables that affected the encounter. The RNG part sounds odd. Boss animations in Elden Ring are not fully deterministic. Some particle spawns have slight randomness. After about fifteen attempts at each boss, I mark which ones are consistent and which ones drift. This saves me from chasing a timestamp that moves three frames left or right depending on how the boss's AI cycle aligns with the encounter start. The workbook also has a hidden feature in the conditional formatting. Rows turn amber when a boss has multiple confirmed variants and green when the aesthetic data is considered stable. I learned this by accident while filtering for red-highlighted rows one evening. The color coding is not documented anywhere in the sheet itself. It took me a few minutes to reverse-engineer which conditions triggered each state. Now I rely on it to prioritize which bosses need fresh data versus which ones I can trust without re-verifying.
When to abandon the workbook approach entirely
If your goal is purely cosmetic speedrunning, this tool is overkill. The workbook assumes you want precision references for visual capture, not racing. For speedrunning aesthetics alone, a simpler frame-by-frame video breakdown from a runner's stream is faster and more accurate. The workbook's strength is in being a comprehensive archive, not a quick reference for one-off needs. If you only need three boss captures for a video, spending time learning the spreadsheet structure might cost you more than just watching the relevant clips directly. The same applies if you are doing casual playthroughs. The level of detail here is aimed at content creators and people building technical reference libraries. The average player does not need particle IDs. You will find the data overwhelming without a clear reason to use it. Start with the basic encounter list if that is your case. Skip the advanced columns until you have a specific project that requires that depth.
