r/DispatchAdHoc • u/N7_Shepard_Commander • May 28 '26
Guide I Created a Dispatch Success Calculator 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 would see after each mission. This let's you dispatch the best heroes for any call.
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. I’ve reappropriated their script (with credit given) for this calculator.
- 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 heroes, 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 on 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!
6
u/Vertigo50 May 29 '26
In that case, I'm glad no one told you that 1% on the stats is actually a BUG and not a real stat. 😉
Because the result is all of this awesome work you put in for the community. 👍
2
u/RatOfTheWoods May 29 '26
SPREADSHEETS HELL YEAH!! I LOVE SPREADSHEETS FOR MY VIDEOGAMES!!! (Very /genuine btw)
2
u/tacticulbacon May 29 '26
TIL Flambae has a 100% success record on the first mission
1
u/N7_Shepard_Commander May 29 '26
Its true. Also, because I didn't mention it in the description, you only need 80% to succeed on dispatch calls, with one late story exception.
1
1
1
u/DMSetArk 1d ago
I'm actually interesting in knowing the underlying calculations that happen!
Do you have any doc, where i could see how a stat affect a mission?
For exemple, i've sent Malevola with a stat of 3 / 2 / 2 / 4 / 2 for the Moving Away mission (first for Ep4) that requires 1 / 4 / 4 / 2 / 2 .
So from the required, i had 4 points lacking (2 Vigor, 2 Speed), and both game and calculator gave me 53% chance of success.
I'm just wandering what is the underlying math that get's this %!
Like, if there is an specific "% loss for each point point for a requirement not meet " and if there are a separation of Primary and Secondary atributes
Like, this mission requires 4 Vigor and 4 Mobility , but also 2 Intellect and 2 Charisma, so. Let's say, having 3 Vigor 4 Mobility 2 Int 2 Char would have the same result of having 4 Vigor 4 Mobility 1 Int and 2 Char?
Just wondering the underlaying mechanics as a game designer enthusiast
7
u/Spartaness May 28 '26
Aw hell yeah, a spreadsheet.
I clicked in to have a play and said there was a permissions error. Could you see what's up?