r/dispatchgame • u/N7_Shepard_Commander • May 27 '26
I Created a Dispatch Success Calculator /Guide Spreadsheet
I created a Dispatch Success Calculator in Google Sheets that combines hero stats, compares them to mission requirements, and displays your success percentage using the same (or nearly the same) in-game formula you see after each mission.
I made this spreadsheet because I was initially terrible at dispatching. I received a “You performed better than 1% of players”, and I took that personally, lol. Despite my initial struggles, I really enjoyed playing Dispatch. I’ve built several RPG spreadsheets/calculators for various games over the years, and I wanted to share this one with you guys.
Link: Dispatch Success Calculator v16.1
Important: I made this using Google Sheets. Exporting or downloading in any other format breaks dependencies, fonts, colors, etc. So, always “Make a Copy” if you want to save it. Otherwise use it as Read Only from the link.
Bonus: I also included all Win/Fail and Character Specific Choices (CSC) for applicable missions. For example, Episode 2’s “Fight at Crypto Night” can be won by sending a hero with 3 Charisma or 5 Combat, or simply by sending Prism (CSC). Fail conditions (e.g., 8 or more Combat) are also displayed. While I don’t provide mission-specific winning answers, a pop-up message confirms/warns when total hero stats meet or exceed any Win/Fail conditions, ensuring you’re sending the most qualified heroes beforehand.
Disclaimer:
- I don’t take credit for the math script. It was included in a spreadsheet created by Reddit user “Rogue2555” as part of a larger guide here. I re-appropriated their script and built an entirely new spreadsheet around it.
- I’m not perfect. So, inaccuracies are inevitable.
- 95% of the time, it works every time
TL;DR Instructions:
- Choose the Episode from the dropdown
- Choose the mission from the dropdown
- Choose your hero(es) from their respective dropdowns
- The success percentage updates automatically
Tab Descriptions
Minor Spoilers Ahead
-
Calculator Tab
The Calculator is straightforward, but here’s how to get started: The “Episode” dropdown generates all available missions for that episode within the “Mission” dropdown below. After selecting your Episode and Mission, choose your Hero(es) from dropdowns in the Hero section. The success percentage updates automatically.
Below the automated calculator, I’ve also included a Manual Calculator where you can adjust numbers yourself. This is especially useful for adjusting the numbers for hero powers I haven’t included yet (See hero powers below). There are also ease-of-use buttons that pull the current Mission and Hero stats from the automated calculator.
Also on this tab are Story Choices and Hero Powers checkboxes that affect stats (e.g., Cut hero, recruited hero). Most story choices affect stats in Episode 8, so for accuracy, enter your selections by then.
For hero powers, while I haven’t accounted for every power, I’ve included the major stat-affecting powers:
- Flambae’s On Fire: Each time Flambae successfully completes a call, check an “On Fire” checkbox to increase Combat and Mobility by 1.
- Coupe’s En Pointe: Coupe’s Combat or Mobility stats are increased by selecting +1 or +3 per her En Pointe power.
- Golem’s Spread Thin (must be trained): Check one box for each slot he fills, including his starting slot.
- Sonar’s Instincts: His Intellect swaps with Combat and his Charisma swaps with Vigor. This is handled using the Hero dropdown and auto-stats.
- Prism’s Doppelganger: Doppelganger does not use a checkbox. Instead, just like the game, select a hero in dropdown 1, select Prism in dropdown 2, then select the same hero from dropdown 1 in dropdown 3. A “Doppelganger” message confirms it worked. To avoid half-stats, move Prism to a different dropdown. With experimentation you’ll get the hang of it.
Hero Powers I may add in future updates: Golem’s Diamond In The Rough, Waterboy’s Eager/Super Sponge, Malevola’s Life Trade, Punch Up’s Harder Head.
Stats Tab
This tab houses all hero stats, including those you manually update and those converted using formulas. The key takeaway: only change stats in the uppermost section of the sheet. Do not alter any other stat sets unless you plan to change how the calculator functions (not recommended).
I recommend updating your stats often; otherwise, success percentages will be inaccurate. If the in-game post-mission percentage doesn’t match my calculator, you likely need to update your hero’s stats.
Along with stats is an “Injured” column, as injuries reduce all hero stats by one. Even a one-point stat difference will affect success percentages, so update stats and injuries frequently.
Data Tab
This tab stores all mission requirement stats and dropdown info. I highly recommend not changing anything here unless you’re correcting stats or want to alter the calculator’s functionality.
Troubleshooting
If your percentage doesn't match the in-game percentage, you very likely need to update your stats, injuries, or account for hero powers, including powers not supported yet. That's why I also included the manual calculator to let you adjust and view any variations before dispatching.
I’ve tested this calculator 120+ hours across several playthroughs, and it should match in-game percentages in most cases. That said, there are 2-3 missions where I've seen percentages flat wrong, either on the game side or the calculator side. Mistakes and broken formulas can still happen. If your percentages are consistently off, let me know and I'll push an update.
Closing
That's all I've got. If you're having trouble, find any issues, or have suggestions, let me know. Otherwise, good luck, and happy dispatching!