Diy Genshin Impact Build Checklist

Why People Still Make This Thing Instead of Using Existing Trackers

I get asked about this every few months. Someone finds my old spreadsheet from 2021 and thinks it's some legendary secret. It's not. It's a Google Sheet with conditional formatting and a lot of cells I color-coded by hand because I was bored one evening during a particularly dry content patch. The core idea is straightforward. Genshin Impact gives you way too many stats to track at once. Character levels, talent priorities, artifact sets, main stat targets, substat weights, weapons, constellations. Any given build can involve checking forty or fifty individual data points across different systems. That's a lot to hold in your head while you're also trying to plan your resin spending for the week. A checklist format forces you to confront the gaps. You can't pretend a +12 CRIT DMG substat on your Sands is "fine" if the sheet highlights that you've been skipping HP% baselines for three weeks.

DIY genshin impact build checklist

The actual structure I ended up with had six sections. The first one covers character progression state. That's level, ascension phase, talent levels, and weapon refinement tier. I put all four in one row per character because they're usually decision points you hit simultaneously. You level an artifact set, you find a weapon that works, you spend primogems on another constellation. These all happen in the same play session window. The artifact section is where things get messy. I split it into two tables. One for current best-in-slot candidates and one for your farming queue. The B.I.S. table tracks what you currently have equipped and what stat spread it shows. The farming queue tracks target main stats, which set you want, and which substats you're actually hunting. Most people skip the farming queue part and just track artifacts they own. That works until you realize you've been rolling on ATK% Sands for a Hypercarry DPS when the build actually wants Electro Bonus DMG on the Goblet. The farming queue catches that mismatch before you spend thirty minutes running Domain of Guyun. I ran into a specific edge case with Ruan Mei builds that took me about two weeks to figure out. The issue is that her team composition flexibility means the same character can use completely different artifact priorities depending on who they're paired with. Hu Tao runs pure Pyro DMG with Ruan Mei but shifts toward CRIT focused when paired with Mona for Vaporize coverage. My original spreadsheet treated these as separate characters with separate rows, which doubled my tracking work. The fix was adding a column called "Team Role" to the B.I.S. table. That way one row for Hu Tao could show two different setup paths with different target stats and you could toggle between them depending on your daily team comp. I wrote a simple IF formula that pulled the right stat targets based on a dropdown selection. Saved me from maintaining duplicate character entries.

The weapon section tracks refinement status and alternative options. Refinement matters more than most players admit. A refined Staff of Homa at R5 provides roughly 32 percent more HP bonus than R1, which directly scales into 32 percent more Pyro DMG Bonus. That's not a rounding error. Most people leave weapons untracked after purchase and then wonder why their damage feels flat compared to community benchmarks. The last section is stat weighting. This is the part that actually makes the spreadsheet useful instead of just being a inventory list. You assign numerical weights to different substats based on what your character needs. For a standard CRIT-focused DPS the weights are roughly CRIT Rate at 2.5, CRIT DMG at 2.2, ATK% at 1.3, and everything else below 0.8. A support character like Xingqiu gets very different weights. Energy Recharge jumps to 1.8, HP scales to 1.4, and CRIT stats drop to near zero. The formula multiplies each substat by its weight and sums them up. A single number pops out at the end. Higher is better. It's rough but it prevents you from getting distracted by high-looking raw numbers on stats that don't matter for that specific character. Here's the thing nobody tells you about this approach. The weighting system only works if you actually understand what each substat contributes to your character's total damage profile. I learned that the hard way with Keqing. I initially weighted CRIT Rate and CRIT DMG equally for her because the spreadsheet said so. Then I went through the math myself and realized that because her Electro application frequency caps out around 4 seconds in most rotations, stacking CRIT Rate past 70 percent gives diminishing returns compared to pure CRIT DMG. I adjusted the weights, reran the numbers, and my artifact sorting accuracy improved noticeably. The spreadsheet doesn't learn on its own. You have to update it when your understanding changes.

There are real limitations to this. The biggest one is that the model assumes linear scaling for most stats. It doesn't account for diminishing returns on ER, talent scaling curves, or team synergy multipliers. When you're chasing high-level optimizations past R5 weapons and maxed constellations, the spreadsheet starts giving you wrong answers. At that point you need simulation tools or direct DPS test runs instead of formulas. Another limitation is maintenance burden. The initial setup takes about three to four hours if you're doing it properly for a full roster. Ongoing updates take maybe twenty minutes per patch cycle. Some people can't justify that time investment. If that's you, Genshin Devotion or the Co-Op artifact filter tools handle the heavy lifting automatically. My spreadsheet is still useful for specific edge cases like comparing two artifact sets with similar scores or deciding between refining a weapon versus upgrading talents with the same currency pool. The file itself isn't hosted anywhere official. I posted the link in a thread on the Genshin subreddit back in 2022 and someone archived a copy on GitHub. The current version at the top has a few more characters than the original and the artifact scoring formula has been slightly recalibrated based on feedback from people who tested it across more builds. If you want to use it you'll need a Google account. The spreadsheet uses Google Sheets formulas exclusively. Excel compatibility is partial at best.

If you're just starting out and have less than ten characters unlocked, skip the whole thing. Track your artifacts on paper or in a notes app. The complexity doesn't pay off until you have enough roster depth that decisions start overlapping and conflicting with each other. That usually happens around character twenty through twenty-five. Before that you're just tracking things you already know.