View unanswered posts | View active topics It is currently Thu Mar 28, 2024 2:19 pm



Reply to topic  [ 3 posts ] 
 I have mental problems 
Author Message
User avatar

Joined: Fri Jun 03, 2011 10:36 pm
Posts: 332
Reply with quote
But, here's what I'm attempting to do. I'm building an Excel library for myself that will show the output of a specific artifact on a specific planet based on its resource outputs and what not. For instance, I have a Rich artifact that has a Space Elevator. I would like to be able to determine how much per hour that artifact is producing on that planet at that setting. What I'm getting around the world to asking is, where can I find information on what Rich, UR, VR, ER etc produce per hour? Or is that top secret type information? I CAN determine such things, but I really don't want to spend hours plugging in stuff to figure it out if its unnecessary.


Tue Aug 02, 2016 10:49 pm
Profile
User avatar

Joined: Tue May 20, 2014 1:56 am
Posts: 476
Reply with quote
Seek, and ye shall find...

Also, for what it's worth, attempting this in Excel is probably making it harder than it should be. I'd recommend picking up some programming (Visual Basic/C#) or lightweight scripting languages (such as PHP or Python) to get your started. It'll make your life easier.

_________________
Elements | Fragments | Remnants


Tue Aug 02, 2016 10:57 pm
Profile

Joined: Thu Mar 27, 2014 1:31 am
Posts: 453
Reply with quote
I've always done this part in my head, but each structure unit produces production units equal to:

2*((MR/4)+3) OR 2*((0.25*MR)+3)

Where MR is Mega Richness. In words, this translates to: Quarter the richness, then add 3, then multiply the total by 2.
You would have to scale down for things under 0x Mega Rich. Also, the second equation is needed at 0x MR because you can't do 0/4.
Thus the value of production units per structure unit at 0x MR is:

2*((0.25*0)+3) = 6 units/hr per structure unit

For easy reference, I've always memorized that the best natural terra VL 3x (size actually is irrelevant here) makes 7.5 units/hr per structure unit, as proven below:

2*((0.25*3)+3) = 7.5 units/hr per structure unit

Each richness above or below a given point, such as 3x MR, will produce 0.5 units/hr more or less than before. After all of this, you would still need to multiply by production bonuses, such as chuhn, litheor locators, hoveroids, shrines, patronages, gateway links, etc.
Keep in mind the original calc assumes at 100% colony age bonus. If for some reason you want the values without 5x PTVs, just divide the value by 2.





Here's a simple chart below for production units per single structure unit at any richness, assuming 100% colony age bonus only:

Notice that the units/hr correspond to exactly double the values found in the "Effective Multiplier" column in the link posted by Actual Fate. This is because the values below are in fact the effective multipliers for a given richness, but assume 100% colony age, whereas the wiki chart doesn't.

N/A = 0 units/hr
ES = 0.5 units/hr
VS = 1 units/hr
S = 1.5 units/hr
Avg = 2 units/hr
A = 2.5 units/hr
VA = 3 units/hr
EA = 3.5 units/hr
R = 4 units/hr
VR = 4.5 units/hr
ER = 5 units/hr
UR = 5.5 units/hr
MR 0 = 6 units/hr
MR 1 = 6.5 units/hr
MR 2 = 7 units/hr
MR 3 = 7.5 units/hr
MR 4 = 8 units/hr
MR 5 = 8.5 units/hr
MR 6 = 9 units/hr
MR 7 = 9.5 units/hr
MR 8 = 10 units/hr
MR 9 = 10.5 units/hr
MR 10 = 11 units/hr
MR 11 = 11.5 units/hr
MR 12 = 12 units/hr
MR 13 = 12.5 units/hr
MR 14 = 13 units/hr
MR 15 = 13.5 units/hr
MR 16 = 14 units/hr
MR 17 = 14.5 units/hr
MR 18 = 15 units/hr
MR 19 = 15.5 units/hr
MR 20 = 16 units/hr
MR 21 = 16.5 units/hr
MR 22 = 17 units/hr

_________________
Slow Ranking Noob, following the footsteps of TheBlackPearl
Leader of The Fallen
Unbuffed Rank 781 | Attack: 192437 T.O.s: 146116 | Defense: 114171 |
Click below to join us and we will rise together!

Image


Thu Aug 04, 2016 4:22 am
Profile
Display posts from previous:  Sort by  
Reply to topic   [ 3 posts ] 

Who is online

Users browsing this forum: No registered users and 33 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group
Designed by ST Software.