|Welcome to reward calculator 3.3!|
1. Make a copy of the sheet
2. Choose the strategies your clan uses at the bottom of this tab, default is manual so tick the
boxes in the "Manual strategy" tab. Or you can choose one of the premade ones,
Terro (head, torso, 1 leg), Mohaca (skip torso) and Jukk (both legs or both arms) are included
in the premade strats.
3. Fill in your raid results in the "Results" tab as shown by the example. The avg will be
calculated automatically and last raids + last 3 raids avg will be available in the drop-down list.
(if you are coming from the old sheet just copy the results over)
Additionally you can use the sheet without results just by manually choosing AVG DMG.
The sheet uses the old format of raid data export. To convert the new export format to new one,
i recommend using the tool here: https://www.tt2-compendium.com/en/toolscorner/raidanalyser
4. Fill in the AVG DMG and number of expected players in the "Reward Stats" tab
and you will see the expected rewards / day for each of the raids. You can ignore raids based on
the cycle amount from the drop down list.
5. You can input your clans average daily ticket gain, current ticket amount, ticket collection time,
raid start time and the highest cleared raid. The sheet will calculate how much you will gain tickets
during the raid and will show the expected ticket amount and the raid ending time. It will also show
you how many ticket collections you will have during the raid and the possible waiting time to start
another raid. You can choose to take this waiting time in to consideration when calculating the
rewards, because sometime its more benefitial to wait for tickets for few hours than to do a longer
All times should be inputted in hours in 24h format, so for example 7:45PM / 19:45 should be
inputted as 19.75.
Results are given with the worst possible spawn since its random (one of each titan is guaranteed)
You can choose your own spawns under "Titan spawns" sheet and it will
reflect on the total damage needed.
You can contact me at discord axxu#3305 for any questions and feedback :)
|Titan attack strategy:||Manual strategy (check manual strategy tab)|
|(it's hard to be 100% efficient)|
|Last cycle time calculation:||Default||120||minutes|
|(Default = First 30 attackers are expected to arrive in 4minute intervals and after that in 12minute intervals. 30 attackers = 2 hours, full 50 = 6 hours)|