ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Shop Titans Hero & Quest Simulator
2
3
This versionV5.4
4
Latest versionV5.4
5
What is this?This spreadsheet contains a simulator for quests and a builder for heroes in Shop Titans. The quest simulator accounts for random factors in the quests such as dodging and critical hits. The simulator runs a quest 50000 times, and outputs the likelihood of the quest being successful and survival chance of each Hero sent on the quest.
6
7
How to use this spreadsheet?1) Make a copy of this spreadsheet for your own use. It does NOT work as an excel file.
2) Put your hero and champion data in the "Hero Data" tab. The orange coloured slots are reserved for the Hero/Champion Builder, do not change those.
3) Use the "Hero 1" .. "Hero 5", and "Champion 1" tabs to build heroes and champions whose data is automatically inserted in the "Hero Data" tab. Solo win rates for the heroes are given in each tab.
4) Use the "Quest Sim" tab if you want to sim teams (2 or more heroes). Use the drop down menus in "Quest Sim" to select which heros you want in your team, the quest you intend to do and whether or not a power booster is used. Any time the "Quest Sim" tab is edited, the simulator will run again.
OLD video tutorial on how to fill your own hero data here: https://www.youtube.com/watch?v=ZEGMN31tAT0&feature=youtu.be
8
9
10
When to updateUnlike the old Hero Builder, this sheet gets the equipment and quest data from a different spreadsheet. This means that you do NOT have to make a new copy whenever new items come out. Do check back every once in a while to find out if a new version with bug fixes / general improvements / new features has been released.
11
12
Additional NotesThe fifth Hero slot is only used for LCoG Quests. If you don't want to run full teams, just delete the Hero's name on the slots you want empty. Effects of the "On guard" Hero skill regarding chance to surviving a fatal blow are not accounted for (but the cleric innate skill is). The defense system in place assumes that there's a 50% increase in base damage at 0 defense, 50% reduction of damage (first soft cap) occurs at 1/6 of the final cap, and that 70% reduction (2nd soft cap) occurs at 1/3 of the final cap. This is not entirely accurate, but is a conservative approach so the "true" win rate should not be lower than the calculated value.
13
14
AcknowledgmentsThis spreadsheet would not be possible without the efforts of players in order to get data for the defense caps of each quest. Quest data is taken from https://stcentral.net/quest-data/
Do be sure to join the Shop Titans Central discord: https://discord.com/invite/u4pPT732pM
15
16
DisclaimerIt is nearly certain that the simulator has bugs. Use it at your own discretion. I cannot guarantee it is 100% accurate, nor am I responsible for any loss of formatting or configuration that may occur when making a copy, or simple misuse of the spreadsheet.
17
18
Contact InfoQuestions, comments, suggestions, feature requests? Contact me on discord: Ress#8449, or find me at the Shop Titans Central discord server (https://discord.com/invite/u4pPT732pM)
19
20
Version Log
21
22
This sheetVersion numberDescription
23
V1.0Release
24
V1.1Fixed bug of quest sim not getting data from the last slots on the Hero Tab
25
V1.2Fixed bug on item selection to prevent future breaking of the builder
26
V1.3Fixed bug with Mundra items not having correct stats.
27
V1.4Added changes from Patch 6.3 to Donovan, Chieftain, Conquistador, Daimyo, Pathfinder, Sensei. Added Hemma.
28
V1.4.1Fixed a bug with Hemma. There may be more coming up.
29
V1.4.2Fixed several bugs with Hemma. Hopefully that's the last of them.
30
V1.4.3Fixed a bug with Hemma still draining HP after she had fainted.
31
V1.5.0Added new Grandmaster skill from Patch 6.4
32
V2.0Added Polonia Loot feature to the Quest Sim tab. New Hero tab (Hero 5) and import from other heroes feature. Additional optional stats, power, and eva cap warning. Fixed shark description and Lord stats.
33
V2.1Fixed a bug with success chance for solo heroes over the evasion cap.
34
V2.2Fixed a bug with Shark Spirits.
35
V2.3Fix a bug with trickster innate. Added luxurious and opulent element, new export feature to hero data tab and Average Damage to extra stats.
36
V3.0Added Champion builder with Familiar options. Added elemental and spirit affinity system from update 9.0. Added third tier of epic (gold) skills, and renamed accordingly. Item names have been renamed to display what stats they provide. Reworked Hemma's Innate (9.0 update). Hero Tabs can now be duplicated. Armadillo, Dino, Lizard and Shark cells no longer count the number of enchants, but the bonus each spirit provides.
37
V3.1Bug Fixes.
38
V3.2QoL Features: Element counter, Skill tier and element indicator, item affinity indicator. Fixed bugs preventing exporting/importing Heroes at the bottom of the Hero Data table.
39
V3.3Bug Fixes: Fixed Cyclops and Harpy familiars not providing correct stats. Fixed power calculation when there are shark or dinosaur affinities. Hero Tabs can now import from one another.
40
V3.4Bug Fix: Fixed spirit affinities (Armadillo, Dinosaur, Lizard, Shark) not working correctly.
41
V3.5Bug Fix: Mundra's spirit was not auto-set on Mundra items (and could not be manually set)
42
V3.6Added changes from Update 9.1.0 regarding Spellknight, Lord and Mercenary Innates. Changed enemy crit damage calculation.
43
V3.7Reverted enemy crit damage calculation per the new hotfix (9.1.2)
44
V3.8Fixed hero innates not being accounted for in the quest sim tab.
45
V3.9Added changes from Update 9.2.0: Ashley, and Extreme difficulty mechanics. Missing quests will be added as data is gathered without the need for a new version, much like new equipment is added.
46
V4.0Added changes from Update 9.4.0: barrier mechanics. Extreme quests are marked with an "OUTDATED" tag until they are updated (defense caps are figured out). Added element choice for champions. Fixed a bug causing Berserkers and Jarls to have their innate ignored when simmed in the Hero Tabs. Random hero attack order for teams.
47
V4.1Added changes from Update 9.5.0: T12 elements and spirits. Bug fixes.
48
V5.0Added changes from Update 9.6.0: Tier 4 skills, changes to elemental barriers and samurai innate. Expect bug fixes in the near future.
49
V5.4Small bug fixes. Fixed Power calculation for Lords.
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100