IMPORTANT NOTE:XP values may currently be slightly incorrect. Some of this is due to rounding error that I can’t do much about. There may also be inaccuracies with respect to the interaction of some XP multipliers, particularly Double XP Weekend and some of the limited access buffs like knowledge bombs, since I usually want to do things other than test multipliers with DXP/knowledge bombs. I have done my best to test out multipliers that aren’t limited time.
to reset the sheet to default.
I sometimes use the base copy of the sheet directly for my calculations, so this removes my changes from default.
Don’t worry about ruining my copy; changes in your sandbox don’t affect it.
Open the Parameters block, and configure the general parameters to taste.
(Optional) Open the Filters block to hide some kinds of recipes, or set a maximum level, to make selection easier.
For each type of potion you want to make, add a row to the Potions table and fill in the TargetQuantity with the number you want to make.
For recipes that produce multiple outputs (batch recipes and upgraded primal extract recipes), the TargetQuantity is the total number you want, not the number of times to craft the recipe.
Note that there are no +1 recipes for powerbursts or bombs because the only difference between +0 and +1 is crafting time; just use the +0 recipe.
For each type of potion you intend to craft as an intermediate, add a row to the Potions table with that recipe, but leave the Target Quantity as 0.
Note that you must do this manually even for untradeable potions. Warning: Do not put multiple recipes for the same intermediate into the table!
This will cause the intermediate to get double-counted! Ask me if you’d like me to add support for this.
Tick Botanist's Amulet for any potions you wish to use the botanist's amulet onーyou probably want to use it on expensive 3-dose potions! It is ignored on potions that can’t make use of it.
Expand the Supplies section and click Add Missing Supplies. This will populate the table with the ingredients needed for all listed potions.
(Optional) If you already have some supplies, fill in the Quantity Owned column. This will cause the Additional Required column to update to only show the number you need to procure. It will also update the Needed as Ingredients column in the Potions table so that you don't make extra intermediate potions.
Back in the Potions table, the total number of times to craft the recipe will appear in the Total to Craft column. This is the actual number of times to craft the recipe, not the number of outputs to produce with it.
page, you can override prices with your own values. This can be used to use actual observed buy or sell prices, which might be different than GE mid, to account for the cost of untradeable ingredients, or to
Don't touch anything on the hidden pages unless you know what you're doing!
You can save a copy of this doc for your own use, but there are a number of caveats:
Your copy will be disconnected from mine, which means it won’t get any updates, including synced GEMW prices.
You may need a subscription to make use of it for more than a little while, because this doc does not qualify for Coda.io’s free tier. Even without the GEMW data, this doc is close to the row limit. You can remove the
page and save a link to it someplace. A future Coda update could cause the experimental formulas to crash the doc. If you have a link directly to the Devtools page, you can uncheck “Enable experimental formulas” to stop crashes. If you do not save this link, your doc may break permanently.
Desert amulet 4:
(20% chance of super antifire (4) in desert)
Morytania legs 4:
(20% chance of prayer renewal (4) in Morytania)
(+10% base XP, 5% chance of doubling non-combination potion)
Brooch of the Gods:
(double portable proc chance)
Scroll of cleansing:
(10% chance of saving ingredient)
Meilyr Voice of Seren:
(+20% base XP for combination potions in Meilyr district)
Perject juju herblore potion:
(+5% base XP for combination potions)
(10% chance of 4-dose weapon poison/antipoison)
Botanist's outfit pieces:
(+1% XP per piece; +1% XP if all worn)
Modified botanist's mask:
(5% chance of doubling any potion)
Factory outfit pieces:
(3: 10% chance of 4-dose potion; 5: unfs +XP)
If you select the Desert amulet 4, it will not take priority over the botanist's amulet, so don't use the botanist's amulet on super antifires if you have it! If you select the Morytania legs 4 and/or factory outfits, they will override the botanist's outfit on eligible potions. It is assumed that you have the pieces necessary to optimally distribute them so that, for instance, you only lose a piece to wearing the Morytania legs 4 if you have them all.
The factory outfit calculations assume you wear either 3 or 5 pieces of the outfit, as appropriate, when crafting potions to which the effect applies. This will take precedence over the botanist’s outfit XP boost, although if you have the modified mask, the calculator assumes you will still be wearing it (that is, it assumes you have 3 non-headgear factory outfit pieces). The additional XP for making unfinished potions with the full factory outfit is not yet accounted for, however.
Most XP bonuses are additive, not multiplicative, but there are a few exceptions. Base XP bonuses go before all other modifiers. The clan avatar and Double XP Weekend stack multiplicatively with each other and other bonuses. It's assumed that any other bonuses are additive only; please let me know there are any multiplicative or base XP bonuses missing.
Use empirical scroll of cleansing proc chance (10.42%):
The official proc chance of the scroll is 10%, but empirical data points to a slightly higher chance—current best estimate is 10.42%. If you tick this box, you can choose to use this chance in the calculations instead of the official figure. The difference is small but not insignificant when doing long potions chains, about 2% for elder salves made from tradeable potions.
Safety margin %:
Many supply-saving effects are based on proc chances, like portable wells and the scroll of cleansing. As a result, with bad luck, you might come up short of your target. The safety margin slightly increases the number of ingredients considered needed, and the number of potions to craft, to be slightly increased in order to ensure you reach your objective. 1% is typically enough to give a 99.9% chance that you will not come up short; the more potions you are making, the less margin of error you need.
Show recipes available at level:
Recipe types to show:
Note that primal extract and adrenaline crystals are classified as items.
Total Base XP:
Total Value of Products:
Needed as Ingredients
Total to Craft
Ranarr potion (unf)
There are no rows in this table
Add Missing Supplies
Note: Potion quantities are normalized to 3-dose potions.
Show only supplies where additional is required:
Cost of Total
Cost of Additional
Ranarr potion (unf)
Vial of water
There are no rows in this table
Want to print your doc? This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (