| A | B | C | D | E | F | I | J | K | L | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Kit Name | I n i t i a l V a l u e s | R o u n d e d V a l u e s | F i n a l V a l u e s | |||||||||||||||||||||
2 | TARGET GOLD / KILL | GOLD | SILVER | COPPER | TIN | GOLD | SILVER | COPPER | TIN | GOLD | SILVER | COPPER | TIN | ||||||||||||
3 | | Share with your friends! | This calculator was made by Concomitant | | Discord: Concomitant#1973 | | ||||||||||||||||||||||||
4 |  | Pippi Kit Coin Drop Calculator — Take the guess work out of probability — | Calculator Key |  | |||||||||||||||||||||
5 | |||||||||||||||||||||||||
6 | |||||||||||||||||||||||||
7 | |||||||||||||||||||||||||
8 | This system is comprised of five separate drops for each type of coin in The Age of Calamitous (AoC), which combine probabalistically to yield the the original desired Gold/Kit value. This calculator is designed for minimal guess-work when trying to create fun and dynamic AoC coin drop kits in the Pippi - User & Server Management interface. Depending on the difficulty of obtaining the kit, they have an appropriate amount of AoC coins dropped per kit. Various kits are listed as NPC drop kits, but it should be straightforward to add your own. Save a copy of this calculator for your use, and use the template for new kits; pay attention to problem indicators. | CHANGE these values! | CHANGE these values to perfect the drop! | ||||||||||||||||||||||
9 | |||||||||||||||||||||||||
10 | |||||||||||||||||||||||||
11 | CHANGE these values to fix an error! | FINAL VALUES! | |||||||||||||||||||||||
12 | |||||||||||||||||||||||||
13 | Depending on the needs of your server, you should mainly just change the amount of Gold/Kit, the Gold/Silver/Copper/Tin coin makeup of the entire kit, and the associated percentages that you want for each drop. The calculator determines the values of the coins per drop needed to hit the target Gold/Kit, rounds those values and finds residuals, and then recalculates drop values to get as close as possible to the target Gold/Kit value. Due to final rounding, there likely will be a small error that needs to be corrected at the end to be exact. See the example for more info. | ||||||||||||||||||||||||
14 | DON'T CHANGE these values, but there's an error somewhere! Try changing drop %'s or target Gold/Kill. | General values; ignore this stuff, or manually tweak values (advanced). | |||||||||||||||||||||||
15 | The Age of Calamitous - Discord | ||||||||||||||||||||||||
16 | |||||||||||||||||||||||||
17 | Need help? Expand the column/row groups & see the annotated example. | Pippi - User & Server Management - Discord | |||||||||||||||||||||||
18 | Forum Topic | ||||||||||||||||||||||||
19 | |||||||||||||||||||||||||
20 | Example "Boss" Drop Kit (Expand Groups) | I n i t i a l V a l u e s | R o u n d e d V a l u e s | F i n a l V a l u e s | |||||||||||||||||||||
21 | TARGET GOLD / KIT | GOLD | SILVER | COPPER | TIN | GOLD | SILVER | COPPER | TIN | GOLD | SILVER | COPPER | TIN | ||||||||||||
22 | This example NPC drop kit is a good testing area to get familiar with this calculator. By default, all of the helpful hints are collapsed, since the hope is that the calculator will be intuitive enough. If hints are needed, simply expand the column and row groups. A fair effort went in to making this calculator as accurate as mathematically possible, while removing most/all of the hard work (i.e. the math). What's particularly nice is that the drops are quite modular. Drops can be built to have certain coins only, while complete control over the drop percentages and kit values is maintained! The active coins and their drop percentages alone are enough to determine the drop values, but it is also possible to select how the calculator corrects for the inevitable rounding errors which occur because only whole percentage values are allowed in the Pippi UI. This calculator has coin-specific corrections for all of the AoC coins, but by default only the Tin coins are being recalculated to produce the target Gold/Kit. If Tin coins are not being dropped in the kit, then it is not very easy to obtain a nice drop result, since the Tin calculator is in this case disabled. As Tin coins are 1/12500th of an AoC gold, the Tin calculator is the most accurate of all of the calculators in this gadget, and accuracy decreases as higher coin calculators are activated! There are, of course, situations when it is not desirable to drop Tin or even Copper, but instead only Gold and Silver coins. In those cases, their calculators will need to be activated. Thank you! for taking the time to use this tool for your Conan Exiles server! If you have found this calculator to be useful or have found an error, I'd love to know your thoughts, suggestions, and feedback! — Concomitant — | 1.000 | 25% | 25% | 25% | 25% | 25% | 25% | 25% | 25% | 25% | 25% | 25% | 25% | |||||||||||
23 | PER KILL | 0.250 | 2.500 | 62.500 | 3125.000 | 0.250 | 2.500 | 62.500 | 3125.000 | 0.250 | 2.500 | 62.500 | 3065.600 | ||||||||||||
24 | PER DROP | 0.050 | 0.500 | 12.500 | 625.000 | 0.050 | 0.500 | 12.500 | 625.000 | 0.050 | 0.500 | 12.500 | 613.120 | ||||||||||||
25 | DROP 1 % | 5% | 50% | 70% | 90% | 5% | 50% | 70% | 90% | 5% | 50% | 70% | 90% | ||||||||||||
26 | DROP 2 % | 4% | 35% | 65% | 80% | 4% | 35% | 65% | 80% | 4% | 35% | 65% | 80% | ||||||||||||
27 | DROP 3 % | 3% | 20% | 50% | 50% | 3% | 20% | 50% | 50% | 3% | 20% | 50% | 50% | ||||||||||||
28 | DROP 4 % | 2% | 10% | 40% | 20% | 2% | 10% | 40% | 20% | 2% | 10% | 40% | 20% | ||||||||||||
29 | DROP 5 % | 1% | 5% | 35% | 10% | 1% | 5% | 35% | 10% | 1% | 5% | 35% | 10% | ||||||||||||
30 | DROP 1 VAL | 1.000 | 1.000 | 17.857 | 694.444 | 1 | 1 | 18 | 694 | 1 | 1 | 18 | 681 | ||||||||||||
31 | DROP 2 VAL | 1.250 | 1.429 | 19.231 | 781.250 | 1 | 1 | 19 | 781 | 1 | 1 | 19 | 766 | ||||||||||||
32 | DROP 3 VAL | 1.667 | 2.500 | 25.000 | 1250.000 | 2 | 3 | 25 | 1250 | 2 | 3 | 25 | 1226 | ||||||||||||
33 | DROP 4 VAL | 2.500 | 5.000 | 31.250 | 3125.000 | 3 | 5 | 31 | 3125 | 3 | 5 | 31 | 3066 | ||||||||||||
34 | DROP 5 VAL | 5.000 | 10.000 | 35.714 | 6250.000 | 5 | 10 | 36 | 6250 | 5 | 10 | 36 | 6131 | ||||||||||||
35 | TOTAL AVERAGE | 0.250 | 2.500 | 62.500 | 3125.000 | 0.260 | 2.450 | 62.450 | 3124.400 | 0.260 | 2.450 | 62.450 | 3065.000 | ||||||||||||
49 | 0.005 | 0 | 1.000000 | A handy 'trick' to get it just right is to multiply a small, workable offset by 100%, and then change a 'nearby' percentage's drop value by whole numbers. (ex. Copper offset=+0.2, lower the drop-val for 20% by 1, if there is one, or 10% by 2, 5% by 4, or 4% by 5). | |||||||||||||||||||||
50 | 0.048 | 0 | |||||||||||||||||||||||
51 | 1.188 | 0 | If the above box is GREEN, you nailed it! Use the final BLUE region %'s and values for your coin drop kit! | ||||||||||||||||||||||
52 | 59.400 | 1 | |||||||||||||||||||||||
53 | |||||||||||||||||||||||||
54 | |||||||||||||||||||||||||
55 | |||||||||||||||||||||||||
56 | — Template Kit — DON'T DELETE / ALTER | I n i t i a l V a l u e s | R o u n d e d V a l u e s | F i n a l V a l u e s | |||||||||||||||||||||
57 | TARGET GOLD / KIT | GOLD | SILVER | COPPER | TIN | GOLD | SILVER | COPPER | TIN | GOLD | SILVER | COPPER | TIN | ||||||||||||
89 | |||||||||||||||||||||||||
90 | |||||||||||||||||||||||||
91 | Test Kit #1 | I n i t i a l V a l u e s | R o u n d e d V a l u e s | F i n a l V a l u e s | |||||||||||||||||||||
92 | TARGET GOLD / KIT | GOLD | SILVER | COPPER | TIN | GOLD | SILVER | COPPER | TIN | GOLD | SILVER | COPPER | TIN | ||||||||||||
93 | 1.0000 | 25% | 25% | 25% | 25% | 25% | 25% | 25% | 25% | 25% | 25% | 25% | 25% | ||||||||||||
94 | PER KILL | 0.250 | 2.500 | 62.500 | 3125.000 | 0.250 | 2.500 | 62.500 | 3125.000 | 0.250 | 2.500 | 62.500 | 3065.600 | ||||||||||||
95 | PER DROP | 0.050 | 0.500 | 12.500 | 625.000 | 0.050 | 0.500 | 12.500 | 625.000 | 0.050 | 0.500 | 12.500 | 613.120 | ||||||||||||
96 | DROP 1 % | 5% | 50% | 70% | 90% | 5% | 50% | 70% | 90% | 5% | 50% | 70% | 90% | ||||||||||||
97 | DROP 2 % | 4% | 35% | 65% | 80% | 4% | 35% | 65% | 80% | 4% | 35% | 65% | 80% | ||||||||||||
98 | DROP 3 % | 3% | 20% | 50% | 50% | 3% | 20% | 50% | 50% | 3% | 20% | 50% | 50% | ||||||||||||
99 | DROP 4 % | 2% | 10% | 40% | 20% | 2% | 10% | 40% | 20% | 2% | 10% | 40% | 20% | ||||||||||||
100 | DROP 5 % | 1% | 5% | 35% | 10% | 1% | 5% | 35% | 10% | 1% | 5% | 35% | 10% | ||||||||||||
101 | DROP 1 VAL | 1.000 | 1.000 | 17.857 | 694.444 | 1 | 1 | 18 | 694 | 1 | 1 | 18 | 681 | ||||||||||||
102 | DROP 2 VAL | 1.250 | 1.429 | 19.231 | 781.250 | 1 | 1 | 19 | 781 | 1 | 1 | 19 | 766 | ||||||||||||
103 | DROP 3 VAL | 1.667 | 2.500 | 25.000 | 1250.000 | 2 | 3 | 25 | 1250 | 2 | 3 | 25 | 1226 | ||||||||||||
104 | DROP 4 VAL | 2.500 | 5.000 | 31.250 | 3125.000 | 3 | 5 | 31 | 3125 | 3 | 5 | 31 | 3066 | ||||||||||||
105 | DROP 5 VAL | 5.000 | 10.000 | 35.714 | 6250.000 | 5 | 10 | 36 | 6250 | 5 | 10 | 36 | 6131 | ||||||||||||
106 | TOTAL AVERAGE | 0.250 | 2.500 | 62.500 | 3125.000 | 0.260 | 2.450 | 62.450 | 3124.400 | 0.260 | 2.450 | 62.450 | 3065.000 | ||||||||||||
120 | 0.005 | 0 | 1.000000 | ||||||||||||||||||||||
121 | 0.048 | 0 | |||||||||||||||||||||||
122 | 1.188 | 0 | |||||||||||||||||||||||
123 | 59.400 | 1 | |||||||||||||||||||||||
124 | - | ||||||||||||||||||||||||
125 | |||||||||||||||||||||||||
126 | Test Kit #2 | I n i t i a l V a l u e s | R o u n d e d V a l u e s | F i n a l V a l u e s | |||||||||||||||||||||
127 | TARGET GOLD / KIT | GOLD | SILVER | COPPER | TIN | GOLD | SILVER | COPPER | TIN | GOLD | SILVER | COPPER | TIN | ||||||||||||
128 | 10.00000 | 50% | 30% | 15% | 5% | 50% | 30% | 15% | 5% | 50% | 30% | 15% | 5% | ||||||||||||
129 | PER KILL | 5.000 | 30.000 | 375.000 | 6250.000 | 5.000 | 30.000 | 375.000 | 6250.000 | 5.000 | 30.000 | 375.000 | 8765.000 | ||||||||||||
130 | PER DROP | 1.000 | 6.000 | 75.000 | 1250.000 | 1.000 | 6.000 | 75.000 | 1250.000 | 1.000 | 6.000 | 75.000 | 1753.000 | ||||||||||||
131 | DROP 1 % | 100% | 100% | 100% | 100% | 100% | 100% | 100% | 100% | 100% | 100% | 100% | 100% | ||||||||||||
132 | DROP 2 % | 80% | 85% | 90% | 95% | 80% | 85% | 90% | 95% | 80% | 85% | 90% | 95% | ||||||||||||
133 | DROP 3 % | 50% | 55% | 60% | 65% | 50% | 55% | 60% | 65% | 50% | 55% | 60% | 65% | ||||||||||||
134 | DROP 4 % | 20% | 25% | 30% | 35% | 20% | 25% | 30% | 35% | 20% | 25% | 30% | 35% | ||||||||||||
135 | DROP 5 % | 10% | 15% | 20% | 25% | 10% | 15% | 20% | 25% | 10% | 15% | 20% | 25% | ||||||||||||
136 | DROP 1 VAL | 1.000 | 6.000 | 75.000 | 1250.000 | 1 | 6 | 75 | 1250 | 1 | 6 | 75 | 1753 | ||||||||||||
137 | DROP 2 VAL | 1.250 | 7.059 | 83.333 | 1315.789 | 1 | 7 | 83 | 1316 | 1 | 7 | 83 | 1845 | ||||||||||||
138 | DROP 3 VAL | 2.000 | 10.909 | 125.000 | 1923.077 | 2 | 11 | 125 | 1923 | 2 | 11 | 125 | 2697 | ||||||||||||
139 | DROP 4 VAL | 5.000 | 24.000 | 250.000 | 3571.429 | 5 | 24 | 250 | 3571 | 5 | 24 | 250 | 5009 | ||||||||||||
140 | DROP 5 VAL | 10.000 | 40.000 | 375.000 | 5000.000 | 10 | 40 | 375 | 5000 | 10 | 40 | 375 | 7012 | ||||||||||||
141 | TOTAL AVERAGE | 5.000 | 30.000 | 375.000 | 6250.000 | 4.800 | 30.000 | 374.700 | 6250.000 | 4.800 | 30.000 | 374.700 | 8764.950 | ||||||||||||
142 | -0.200 | 0.000 | -0.300 | 0.000 | -0.200 | 0.000 | -0.300 | 2514.950 | |||||||||||||||||
143 | -0.200 | 0.000 | -0.001 | 0.000 | -0.200 | 0.000 | -0.001 | 0.201 | |||||||||||||||||
144 | -2.000 | 0.000 | -0.012 | 0.000 | -2.000 | 0.000 | -0.012 | 2.012 | |||||||||||||||||
145 | -50.000 | 0.000 | -0.300 | 0.000 | -50.000 | 0.000 | -0.300 | 50.299 | |||||||||||||||||
146 | -2500.000 | 0.000 | -15.000 | 0.000 | -2500.000 | 0.000 | -15.000 | 2514.950 | |||||||||||||||||
147 | 4.800 | 3.000 | 1.499 | 0.500 | 4.800 | 3.000 | 1.499 | 0.701 | |||||||||||||||||
148 | 48.000 | 30.000 | 14.988 | 5.000 | 48.000 | 30.000 | 14.988 | 7.012 | |||||||||||||||||
149 | 1200.000 | 750.000 | 374.700 | 125.000 | 1200.000 | 750.000 | 374.700 | 175.299 | |||||||||||||||||
150 | 60000.000 | 37500.000 | 18735.000 | 6250.000 | 60000.000 | 37500.000 | 18735.000 | 8764.950 | |||||||||||||||||
151 | 9.799 | 10.000 | 0.000 | ||||||||||||||||||||||
152 | 97.988 | 100.000 | 0.000 | ||||||||||||||||||||||
153 | 2449.700 | 2500.000 | -0.001 | ||||||||||||||||||||||
154 | 122485.000 | 125000.000 | -0.050 | ||||||||||||||||||||||
155 | -0.201 | 0 | 9.999996 | ||||||||||||||||||||||
156 | -2.012 | 0 | |||||||||||||||||||||||
157 | -50.300 | 0 | |||||||||||||||||||||||