Spreadsheet 2: Healing Boogaloo
Posted: Mon Nov 26, 2012 6:30 pm
I recall reading a comment elsewhere on the forums that healing items needed to be looked at, so I thought I'd do that myself. This one's way easier than the Enemy Comparison.
Name: The name of the item.
Source: Where you get it.
Type: As supplied by the game. Entries are color-coded based on this field.
Price: The price you pay to purchase the item. For Izthiel Claws, which are available as drops only, I just sold one to the store, then bought it back.
Min/Max/Avg Heal: Because of Izthiel Claws, I needed three values. The Average Heal value is used for all calculations.
HP/Gold: How many HP you get per Gold spent.
Gold/HP: How many Gold you pay for each HP regained.
THE SPREADSHEET!
The list is pretty consistent. Any items with identical heal values have the same cost, and the more an item heals, the more it costs. This makes sense, since an item that heals 40 HP is far more valuable in combat than an item that heals 1, but takes the same number of AP.
There are three exceptions: Izthiel Claws heal FAR more on average than comparably priced items. This makes sense, since they're a drop-only item, and have a random factor. Bonemeal Potions cost far less, but they are only available after completing a quest (albeit a very easy one).
If you keep the Types separate, then those are the only anomalies. However, if you mix the Types, Cooked Meat costs less per HP healed than a Regular Potion, but gives a bit more than twice the HP.
If you look at the bottom of the spreadsheet, there are two tabs: Current and Adjusted. Switching to Adjusted will show my recommended changes: Food, and Drink share a formula: 2 Gold per HP for 1 HP, increasing by 0.5 Gold per HP with each doubling. Under Edible Animal Parts, Meat is left slightly better price than it would have as Food - it should be 42-43 Gold by that formula).
Izthiel Claws are left unadjusted at 1 Gold.
Potions, except the Bonemeal Potion, have been adjusted to heal a little more than comparable foods, and cost a bit more, but have the same Gold/HP ratio as the foods that heal the next step lower (making them slightly more efficient). The Major Potion of Health has been reduced slightly in effectiveness, making it weaker than the Bonemeal Potion, but has had its cost reduced greatly as well. I don't know about anyone else, but at the current cost, I just will NOT buy the Major Potion. Over 8 Gold per HP is too much.
If this change is made, the Major Potion will no longer heal four times the regular, so the quest where you have to find the book, then bring the guy healing potions should be changed to "2 Regular or 1 Major" or "4 Minor, or 2 Regular, or one Major".
The Bonemeal Potion was adjusted up to a cost of 80. However, this makes it on par with the 1 hp healing items - still the most efficient healing by far.
In most cases, this increased prices slightly, though it dropped them for some items, plus added mathematical consistency.
Name: The name of the item.
Source: Where you get it.
Type: As supplied by the game. Entries are color-coded based on this field.
Price: The price you pay to purchase the item. For Izthiel Claws, which are available as drops only, I just sold one to the store, then bought it back.
Min/Max/Avg Heal: Because of Izthiel Claws, I needed three values. The Average Heal value is used for all calculations.
HP/Gold: How many HP you get per Gold spent.
Gold/HP: How many Gold you pay for each HP regained.
THE SPREADSHEET!
The list is pretty consistent. Any items with identical heal values have the same cost, and the more an item heals, the more it costs. This makes sense, since an item that heals 40 HP is far more valuable in combat than an item that heals 1, but takes the same number of AP.
There are three exceptions: Izthiel Claws heal FAR more on average than comparably priced items. This makes sense, since they're a drop-only item, and have a random factor. Bonemeal Potions cost far less, but they are only available after completing a quest (albeit a very easy one).
If you keep the Types separate, then those are the only anomalies. However, if you mix the Types, Cooked Meat costs less per HP healed than a Regular Potion, but gives a bit more than twice the HP.
If you look at the bottom of the spreadsheet, there are two tabs: Current and Adjusted. Switching to Adjusted will show my recommended changes: Food, and Drink share a formula: 2 Gold per HP for 1 HP, increasing by 0.5 Gold per HP with each doubling. Under Edible Animal Parts, Meat is left slightly better price than it would have as Food - it should be 42-43 Gold by that formula).
Izthiel Claws are left unadjusted at 1 Gold.
Potions, except the Bonemeal Potion, have been adjusted to heal a little more than comparable foods, and cost a bit more, but have the same Gold/HP ratio as the foods that heal the next step lower (making them slightly more efficient). The Major Potion of Health has been reduced slightly in effectiveness, making it weaker than the Bonemeal Potion, but has had its cost reduced greatly as well. I don't know about anyone else, but at the current cost, I just will NOT buy the Major Potion. Over 8 Gold per HP is too much.
If this change is made, the Major Potion will no longer heal four times the regular, so the quest where you have to find the book, then bring the guy healing potions should be changed to "2 Regular or 1 Major" or "4 Minor, or 2 Regular, or one Major".
The Bonemeal Potion was adjusted up to a cost of 80. However, this makes it on par with the 1 hp healing items - still the most efficient healing by far.
In most cases, this increased prices slightly, though it dropped them for some items, plus added mathematical consistency.
