Forgot I made this ages ago
from the pastebin/source below.
CurrentEnchant 100.00%
LuckyTicket Yes
Material Dark Steel
Character Luck 0
Protection Charm No
Material Enchant Cost =vlookup($B$23,$E$21:$G$25,2,False)
Material Enchant Amount =vlookup($B$23,$E$21:$G$25,3,False)
Success Chance =MAX(MIN( (103-(B27*100)-(B21*100)+B24 + IF(B22="YES",5,0) )/100 , 1),0)
Break Chance =IF(B28<=0.45,0.46-B28,0)
Fail =1-B28
New Enchant =B21+B27
Enchant Test =IF(C6 <= B28, "Success", IF(C6 <= B28 + B29, IF(B25="Yes", "Broke - PC Used", "Broke"), "Fail"))
Materials Enchant Cost Enchant Amount
Tin 20000 3%
Dark Steel 40000 6%
Black Steel 70000 9%
Soe (Steel of Eternity) 100000 12%
Goe (Gold of Eternity) 100000 15%
File Save Copy of sheet if you have google drive/gmail account and want to use dice image buttons to randomize and input your own values.
Should mention its for TS1 but maybe its same in TS2. Game is basically copy paste.
Heh