The Herb Guide is now updated to version 3! This includes a nice script that will price up groups of herbs for your shop’s stockroom. It also gives you a line to paste in for a ‘drop all groups of this type and number and price them all at the price calculated.’ Note that the cells that concatenate the paste-string together are multiple-line cells, and will be injected with quotation marks at the beginning and end, so those will need to be stripped off in a text editor before pasted into your stockroom script. Also, note that the gdrop alias I wrote is a client-side script that drops a number of groups all in a row without balance loss. This is the best thing for stockrooms, as someone can break in relatively easily if someone is inside. https://spreadsheets.google.com/ccc?key=0AkNBf7ic_0CMdDN3RXRPZjAzSHl2bEdLQmhDN3FiR3c&authkey=CNSwvbAI&hl=en
Tag: excel
New Herb Guide
Now that Firien’s found my herb guide, I got to thinking about it a bit and came up with a great new idea! How about if I make it calculate prices by using a discount percentage!
So I did. I added another page to the price guide that will allow you to enter friend discount, house (org) discount, and everyone discount from the Oakstone minimum. And this will ripple all the way through everything in your list.
Also, I added another column that lets you set an absolute minimum you will be willing to part with the herb for. For the economist, this is a price floor. If the discount pushes the final price below the minimum, the minimum will kick in and force the price back up. Of course, this is a requirement in the case of Mending and Restoration which require Rurin-set diamond dust and a set gold value respectively.
In addition to all this, I did a few minor edits that prevent you from selecting and editing the grey areas. However, I haven’t done this for copyright reasons and so the sheet protection is without a password. In Excel, you can just Tools/Protection/Unprotect Sheet and everything will be normal.
Anyhow, these new features have been added to the whole file. The old one is still included if you don’t like the new features.
I suppose you still want it, eh?
Here it is: [<Herb Price Guide v2.xls>]