| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Shop Titans Hero & Quest Simulator | |||||||||||||||||||||||||
2 | ||||||||||||||||||||||||||
3 | This version | V7.3 | ||||||||||||||||||||||||
4 | Latest version | V7.3 | ||||||||||||||||||||||||
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 | Useful Information | Be sure to check out the Hero Tracker (https://shoptitans.dowob.dev) developed by drakeonfire for an easy way to organize your heroes. | ||||||||||||||||||||||||
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 Azuris' Quick Quide on how to use this spreadsheet: https://docs.google.com/document/d/1d30DbS-H3P9Au0RcmPQ43FovW3i1VmWNCEgIgu-lCHA/edit | ||||||||||||||||||||||||
8 | ||||||||||||||||||||||||||
9 | ||||||||||||||||||||||||||
10 | When to update | Unlike 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 Notes | The 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 | Acknowledgments | This 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 | Disclaimer | It 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 Info | Questions, 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 sheet | Version number | Description | |||||||||||||||||||||||
23 | V1.0 | Release | ||||||||||||||||||||||||
24 | V1.1 | Fixed bug of quest sim not getting data from the last slots on the Hero Tab | ||||||||||||||||||||||||
25 | V1.2 | Fixed bug on item selection to prevent future breaking of the builder | ||||||||||||||||||||||||
26 | V1.3 | Fixed bug with Mundra items not having correct stats. | ||||||||||||||||||||||||
27 | V1.4 | Added changes from Patch 6.3 to Donovan, Chieftain, Conquistador, Daimyo, Pathfinder, Sensei. Added Hemma. | ||||||||||||||||||||||||
28 | V1.4.1 | Fixed a bug with Hemma. There may be more coming up. | ||||||||||||||||||||||||
29 | V1.4.2 | Fixed several bugs with Hemma. Hopefully that's the last of them. | ||||||||||||||||||||||||
30 | V1.4.3 | Fixed a bug with Hemma still draining HP after she had fainted. | ||||||||||||||||||||||||
31 | V1.5.0 | Added new Grandmaster skill from Patch 6.4 | ||||||||||||||||||||||||
32 | V2.0 | Added 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.1 | Fixed a bug with success chance for solo heroes over the evasion cap. | ||||||||||||||||||||||||
34 | V2.2 | Fixed a bug with Shark Spirits. | ||||||||||||||||||||||||
35 | V2.3 | Fix 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.0 | Added 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.1 | Bug Fixes. | ||||||||||||||||||||||||
38 | V3.2 | QoL 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.3 | Bug 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.4 | Bug Fix: Fixed spirit affinities (Armadillo, Dinosaur, Lizard, Shark) not working correctly. | ||||||||||||||||||||||||
41 | V3.5 | Bug Fix: Mundra's spirit was not auto-set on Mundra items (and could not be manually set) | ||||||||||||||||||||||||
42 | V3.6 | Added changes from Update 9.1.0 regarding Spellknight, Lord and Mercenary Innates. Changed enemy crit damage calculation. | ||||||||||||||||||||||||
43 | V3.7 | Reverted enemy crit damage calculation per the new hotfix (9.1.2) | ||||||||||||||||||||||||
44 | V3.8 | Fixed hero innates not being accounted for in the quest sim tab. | ||||||||||||||||||||||||
45 | V3.9 | Added 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.0 | Added 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.1 | Added changes from Update 9.5.0: T12 elements and spirits. Bug fixes. | ||||||||||||||||||||||||
48 | V5.0 | Added 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.4 | Small bug fixes. Fixed Power calculation for Lords. | ||||||||||||||||||||||||
50 | V5.5 | Added changes from Update 10.4.0: Mage & Archmage innate changes, Rudo's champion skill buffing damage to barriers. Geomancer and Astramancer attack bonus from innate now uses all elements (not only water). | ||||||||||||||||||||||||
51 | V5.6 | Fixed Power calculation for Jarls. | ||||||||||||||||||||||||
52 | V5.7 | Added Meals and Desserts. | ||||||||||||||||||||||||
53 | V5.8 | Fixed cloaks being on the wrong slot for Monk/Grandmaster | ||||||||||||||||||||||||
54 | V5.9 | Fixed a bug causing gold weapon skills to act as if they are tier 4 on non-souled classes. | ||||||||||||||||||||||||
55 | V5.10 | Fixed a bug preventing the Whirlwind Attack skill from being available for spellblades and spellknights. | ||||||||||||||||||||||||
56 | V5.11 | Added Christmas Spirit. Fixed power calculation for Dancers/Acrobats | ||||||||||||||||||||||||
57 | V5.12 | Fixed bonus stats from spirits not being accounted for in V5.11. | ||||||||||||||||||||||||
58 | V5.13 | Fixed power calculation for Ninjas and Senseis according to Update 11.3.0. | ||||||||||||||||||||||||
59 | V5.14 | Fixed a bug causing Extreme monsters to always inflict critical hits on heroes with low or no evasion. | ||||||||||||||||||||||||
60 | V6.0 | Fixed power calculation for Sensei, Jarl, and Acrobat. Added HP Regen power contribution. Added Mundra's Aegis. Fixed a bug with affinities. Added more hero slots. Made it easier to select quests. Quest zones can now be hidden by unmarking tickboxes in the quest data tab. | ||||||||||||||||||||||||
61 | V6.1 | Fixed a bug with barrier HP | ||||||||||||||||||||||||
62 | V6.2 | Added the new Champion Bjorn | ||||||||||||||||||||||||
63 | V6.3 | Added Reinhold as a Champion. Changed Hemma's skill according to update 14.2. | ||||||||||||||||||||||||
64 | V7.0 | Added Dark Knight, Velite, Chronomancer and corresponding souled classes according to update 14.3. | ||||||||||||||||||||||||
65 | V7.1 | Added "All" affinity, Champion souls, aurasongs and instruments. | ||||||||||||||||||||||||
66 | V7.2 | Changed Barriers according to update 15.2. Fixed a bug with the adept skill not providing its full effect and not displaying total element count. Fixed a bug with Export/Import from Hero Data. | ||||||||||||||||||||||||
67 | V7.3 | Fixed a bug which caused barriers to not work properly. | ||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||