Artisan Archive

Hi everyone,

I suck at math, but I'm looking for a formula that will tell me what it actually costs me to harvest 1 unit of whatever.

Ithink that formula should include the following:

1. Total efficiency of harvester(s)

2. Percentage of resource

= how much resource I can harvest per hour

3. Cost of harvester maintenance per hour

4. Cost/amount of harvester energy per hour

= my cost per hour

R/60=CPU ?

5. Anything I've missed

Can anyone help a math dyslexic out and post a formula I can pop into Excel?

Thanks.

Here is how I calculate my resource and power cost.

Harvester Output perday = ((Base Extraction rate (BER) * Density) 60 minutes) * 24 hours

Actual Power(AP) = (((Potential Energy - 500) / 500) + 1) * Harvester Output
If the PE of the energy is 500 or less, then the Actual Power = Harvester Output

Power Cost (PC) = (Maintenance * 24) / AP

Resource Cost = (((PowerConsumption* 24) * PC) + (Maintenance * 24)) / Harvester Output

Here's some actual numbers as an example:

Radioactive power:
PE = 703
Density = 78.5%
BER = 16
Maintenance = 50/hr

Harvester Output = ((16 * .785) * 60) * 24) = 18086
Actual Power = (((703 - 500) / 500 +1) * 18086 = 25489
Power Cost = (50 * 24) / 25489 = 0.05 credits/unit

Resource: Aluminum
Harvester size: Medium
Density =77.8%
BER = 10
Maintenance = 50/hr
Power = 60/hr

Harvester Output = ((10 * .778) * 60) * 24) = 11203
Resource cost = (((60 * 24) * 0.05) + (50 * 24)) / 11203 = 0.13 credits/unit

There is an excellent spreadsheet-based tool available for calculating and tracking values such as these. The SWG forum link is:

http://forums.station.sony.com/swg/board/message?board.id=artisan&message.id=25375&highlight=spreadsheet#M25375

In case you want to jump right to it, the web site is http://swg.medievalweapons.net

Medman

Dalnin, Thanks that looks like it should work for me.

rscott, whew. Talk about a through spreadsheet. Yikes. Thanks though

Dalnin,

BER=Actual Rate or Spec Rate?

I hate to burst everyone's bubble, but these formulas only take into account the fact that the harvester never moves. If you move your harvesters to take advantage of high resource percentages every time a resourse shift occurs, you're not building that cost into account...

---

The1Paladin wrote:
I hate to burst everyone's bubble, but these formulas only take into account the fact that the harvester never moves. If you move your harvesters to take advantage of high resource percentages every time a resourse shift occurs, you're not building that cost into account...

---

That is one of the reasons that I use the http://swg.medievalweapons.netspreadsheet. Redeeding costs are factored in, as are energy costs, maintenance costs and even city tax costs. Anyone maintaining a fleet of harvestors should take the time to check it out.

Medman

---

The1Paladin wrote:
I hate to burst everyone's bubble, but these formulas only take into account the fact that the harvester never moves. If you move your harvesters to take advantage of high resource percentages every time a resourse shift occurs, you're not building that cost into account...

---

Ture, but I don't move the majority of my harvesters enough to bother factoring it in. If I factored the cost of redeeding my medium harvester (3000cr), spread it out over 8 days, then divided that by 24 (hours), I would just be adding 16cr/hour to theoverall cost, which adds only.04 to .08cr per resource. I just make up for those costs be taking survey missions when I check harvesters and by selling some of the resources on the Bazaar.

Blanktim: BER is the base rate of your harvester. The actual rate is the BER * Density%.

I would also reccomend taking a look at the harvester calculator on www.swgcraft.com It does a pretty good job of calculating resource costs. I actually just download the infamous Spreadsheet today so I haven't had a chance to use it yet.