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
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>]
Hi everybody (all two or three of you)! Are I crazy or what? I feel totally nuts. So I found some time to spend in the Realm, which has proved very exciting. Of course, hanging out with friends sure kills the hunting and harvesting and exploring time I like so well, but that’s to be expected and besides, I think I find my friends to be a whole lot more interesting.
Oh, I suppose you want an update on all my exploration activities and things. After all, nothing useful has been posted here since like March..except for the comic and the inspiration from Alynia..
So a few new places opened up (mostly islands) such as Lothos, Meropis, and some island south of Meropis. I managed to go to Lothos a while back and also was able to complete my attestation of the Marque of Unquestioned Seaworthiness (or whatever it’s called when you complete it). So yeah..now I can sail and everything, although nobody’s let me yet.
Maybe someday I’ll buy my own boat and be happy sailing all by myself.
As for quests, I discovered how to find the Skolef in Green Lake. It’s some wierd tentacle creature that can wrap you up and pin you against the wall. Nasty. Anyway, it’s Green Lake and that’s all you get for finding him. But either way, he’s really cool.
Anything else of note? Not really. Actually, there IS some things such as Kongregate and how much I like it. But that’s OOC and irrelevant.
OH! Another OOC-ish thing. Did I mention PennMUSH? I think I did..however, I’ve discovered a TON more on how to develop stuff. In fact, I discovered a whole website with a bunch of examples and tools and I can break them down and find out how things work and…well…things like that. I’m loving it!
Loreen? She’s well. Have I mentioned Loreen? She’s the BEST Xorani gal a little fairy like me could ever dream of. All my friends like her too, I think. I hope…
Anyhow, I think that’s it for now. Maybe I’ll also include PennMUSH tools and tips here. Or not..but maybe I will. Still I want to keep some of my ideas to myself, y’know. But with the amount of support (or lack of, I should say) I see online, SOMEBODY’S got to have SOMETHING on that whole system. And it might just have to be me if I can’t find somebody else.
Okay. I’m done. Take care, ya’ll!