Oolite Bulletins

Hi

I'm glad to have discovered this awsome game. After using data from this helpful wiki page for some time I decided to make a spreadsheet out of it. Here it is. The spreadsheet makes use of some macros. The fields on yellow background are intended to be changed by user. Type in economy levels for current and target systems and current system prices for furs and narcotics (these two prices are used to determine the random factor). The calculation should work as long as default MARKET_MASK_PRICE remains 63 for furs and 120 for narcotics and no other commodity has masks greater than these. This seems to function well at least for main stations and rock hermits. Should you get wrong results, try to add 64 or 128 to the A1 cell on the second sheet ('market'), i.e. make A1 '=rnd+64' or '=rnd+128'.

I copied min/max prices from this page at Elite Wiki.

Although I'm not using any dockables from OXPs yet, I've included price tables for some of them on the 'market' sheet. Don't know if I got them right though. Some data look pretty suspicious like all commodities apart from slaves being exactly the same quantities at constores, or gems and precious metals measured in tons at taxi stations.

Feel free to change or adapt this spreadsheet as you like.

Hi Cdr. Jettison, and welcome to the friendliest board this side of Riedquat.
That's a nice piece of work and I'm sure it will be really useful to many of us.
Excellent start to your 'forum career'.

Wow. Now I feel really lame about my first post!

Don't worry, I think mine was where I'd broken something and needed help

Welcome Cdr.Jettison... and SeaDog to.
It's nice to see someone working on that end of oolite. Perhaps in time you'll learn javascript and come out with a related ship's equipment oxp. Good starting post.And good name to. Makes me think you're a Contrabandista!

Something to keep in mind is the huge price swings in a particular system can significantly change how profitable some items are.
Furs for instance vary wildly. Computers change very little.

Some OXP stations have pretty messed-up market prices and amounts of items.
I supplied the commodities prices for Random Hits Space Bar OXP, so it's not as crazy as some...though slaves are pretty ridiculous on it, from all the captured bounties.