ipecac: Here is an excel utility to determine if you should use SMS or regular scrolls to improve your item. If you are scrolling a frenzy, several titles may be acceptable because even a pikeman title is useful for resale. Type the information into the indicated cells. One complete, you can manipulate the number of scrolls, number of usable titles, and from that the decision to scroll can be made. Excel formulas will follow on the next post.
14-09-22 21:35
ipecac: A1: Number of weapon titles
A2: Number of shield titles
A3: Number helm titles
A4: Number armor titles
A5: Number boot titles
A6: Number amulet titles
A7: Number ring titles
A9: number acceptable titles
A10: number of scrolls
A11: credits for scrolls
A12: cost per scroll
A13: number scrolls can buy
B1: 29
B2: 28
B3: 32
B4: 30
B5: 30
B6: 42
B7: 45
B9: 8
B10: 8
B11: 100
B12: 8
B13: =B11/B12
C1: =1-(1-$B$9/B1)^$B$10
C2: =1-(1-$B$9/B2)^$B$10
C3: =1-(1-$B$9/B3)^$B$10
C4: =1-(1-$B$9/B4)^$B$10
C5: =1-(1-$B$9/B5)^$B$10
C6: =1-(1-$B$9/B6)^$B$10
C7: =1-(1-$B$9/B7)^$B$10
A2: Number of shield titles
A3: Number helm titles
A4: Number armor titles
A5: Number boot titles
A6: Number amulet titles
A7: Number ring titles
A9: number acceptable titles
A10: number of scrolls
A11: credits for scrolls
A12: cost per scroll
A13: number scrolls can buy
B1: 29
B2: 28
B3: 32
B4: 30
B5: 30
B6: 42
B7: 45
B9: 8
B10: 8
B11: 100
B12: 8
B13: =B11/B12
C1: =1-(1-$B$9/B1)^$B$10
C2: =1-(1-$B$9/B2)^$B$10
C3: =1-(1-$B$9/B3)^$B$10
C4: =1-(1-$B$9/B4)^$B$10
C5: =1-(1-$B$9/B5)^$B$10
C6: =1-(1-$B$9/B6)^$B$10
C7: =1-(1-$B$9/B7)^$B$10
14-09-22 21:36
ipecac: You could enter 200 credits to equal the cost of a sms and say mp cost of scrolls is only 6c. That means you could buy 33 scrolls. If only an ultimate title is acceptable, you only have a 52% chance for that. In that case, a super magic scroll would probably be nice.
14-09-22 21:47
Page: 1/1