I recently decided to add a Mining Calculation Tool to a spreadsheet that I put together.

When I was finished, I got numbers that seemed out of wack and I was wondering if someone (preferably mining experience or a rules team person) could run the numbers so I can see if what I got is accurate.

I used the following data:
NPCs: 10
Rarity Rate: 500
Raw Material Price: 488

Planet Morale: 85%
Planet Crime 5%
Tax Level: 5%

Leadership: 2

I then calculate the absolute minimum (random1: 35, random2: -50) and maximum (random1: 50, random2: 150) yields and resulting minimum and maximum costs.

The cost number I got were extremely high.

that?s because, if I rememebr it right, the more NPC you use the more expensive

That makes sense, but...I didn't want to actually give my numbers...

Yield (min and max): 18660-21033
Cost: 9.7 million - 10.9 million

Given those parameters, I got those exact same numbers Roy.

Fortunately, there aren't any materials that have a rarity rate of 500 and a RMP of 488. Also, while additional NPCs do result in more overall costs, cost per unit stays nearly the same because of the higher yield.

But the Meel...

*Roy attempts to crack his skull on the nearest brick wall, which only results in a flesh wound and a bad headache.

I misread that table. I was trying to use Meelenium as my base and I apparently put the price for Quantum into the speadsheet.

Thanks for catching that Arc and for confirming those numbers for me.

Since I've already got this started, its slightly off-topic...

How much is actually involved in mining? I see all these nice mines now on the market, seems a shame to let them just sit there doing nothing.

If I decided to buy one, can it essentially run on its own (with all the NPCs and such of course) or is there some internal programming preventing a non-mining company from operating one?

I believe the mine must be in posession of a mining faction, and the operator must be a member of a mining faction. You'd need to work out some sort of deal with a mining company I guess.

Manager must be a mining faction, and the operator a member of it.

I believe the mine itself also needs to be owned by a faction - not a private individual.

Should all be covered in the Rules, Roy.

Its not covered in the rules.

Operator does not have to be a member of a mining faction.

Mine must be owned or managed by a mining CMG

I just looked over the rules Hal.
I don't see anything about ownership or conditions for it to actually work (beyond having a single NPC assigned to the facility). I'm not doubting its there, I could have missed it the way I read.

Mines owned by a private individual will not work. It must be a faction (any kind) and the manager must be a mining faction.

Well, Roy could have them owned by Renegade so that isn't really a problem.

More trouble than it's worth, I've tried and it's so weird... might as well just have the MF own the mine.

..and that is something I would change.If an individual is able to somehow acquire a mine,either thru sales or getting a mining CMG to build a mine on thier deposit,then negotiate an agreement for a mining CMG to manage/operate it..not too mention pay for all this(city founding,RMs,hauler of some type,construction of power,mine and prolly storage,NPCs and maybe prospecting equipment) and then also pay for extractions....well..they should be able to.

Although there are alot of deposits out there just sitting, that will never do anything in a seemingly RM starved galaxy,something tells me there wouldn't be alot of folks able to do this ;)

I haven't checked the rules lately, but I do recall a question about a mine not working where people were quoting the rules about it... Might be somewhere obscure, or it could all have been revised since then and something lost.
But anyway, that's why I thought they were there.

I can confirm that operators of mines do not need to be members of mining factions, I regularly use affliated faction members as mine managers/operators if mines are within their general area of operations. So as it stands, mines can only be owned by mining factions but also are operatable by non-mining faction members.

And I agree that the rules page is not terribly up to date with regards to specific rules of managing and operating rights. Perhaps the intent was that it should all be done in house by factions and not individuals and hence written like that?