OK, so I geeked out a little bit while I was on travel for work. I took the Smith BOD reward chart that I made (and posted) a few months back, and turned it into a pretty cool, automatic price generator using lookup tables and crap like that.
All you have to do is set the price that you think each reward is worth. So, it you think a Gold Runic Hammer is worth 1M (25 charges at 40K a charge), then it will break that down. It will calculate the price for Ringmail, Chainmail, and Platemail BODs using the standard of a LBOD is worth 2 SBODs from the set (so for a ringmail suit, the reward price is divided by 6). It will then search out all sets by the reward type, and produces a table that looks just like my reward chart, but this one will have the prices you want to charge.
It will also compare the price of turning in the single BOD vs. turning the set, and puts the higher of the 2 values into the block.
The beauty of this you don't have to manually update a bunch of stuff. If Gold Runics suddenly start selling for 60K each, then you just update the value of the reward, the POOF, the spreadsheet updates all the affected prices.
I am not going to post this for the masses, but if you want a copy of the program, PM me and include an email address, I will send you a copy (minus my beta version prices).
All you have to do is set the price that you think each reward is worth. So, it you think a Gold Runic Hammer is worth 1M (25 charges at 40K a charge), then it will break that down. It will calculate the price for Ringmail, Chainmail, and Platemail BODs using the standard of a LBOD is worth 2 SBODs from the set (so for a ringmail suit, the reward price is divided by 6). It will then search out all sets by the reward type, and produces a table that looks just like my reward chart, but this one will have the prices you want to charge.
It will also compare the price of turning in the single BOD vs. turning the set, and puts the higher of the 2 values into the block.
The beauty of this you don't have to manually update a bunch of stuff. If Gold Runics suddenly start selling for 60K each, then you just update the value of the reward, the POOF, the spreadsheet updates all the affected prices.
I am not going to post this for the masses, but if you want a copy of the program, PM me and include an email address, I will send you a copy (minus my beta version prices).
Last edited by a moderator:
![Vince[Tharakus]](/data/avatars/m/9/9563.jpg?1414129197){kind=avatar}