| Galaxy Legion Forum http://galaxylegion.com/forum/ |
|
| I have mental problems http://galaxylegion.com/forum/viewtopic.php?f=3&t=44041 |
Page 1 of 1 |
| Author: | DarthNefarious [ Tue Aug 02, 2016 10:49 pm ] |
| Post subject: | I have mental problems |
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. |
|
| Author: | ActualFate [ Tue Aug 02, 2016 10:57 pm ] |
| Post subject: | Re: I have mental problems |
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. |
|
| Author: | TrinityThree [ Thu Aug 04, 2016 4:22 am ] |
| Post subject: | Re: I have mental problems |
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 |
|
| Page 1 of 1 | All times are UTC |
| Powered by phpBB® Forum Software © phpBB Group https://www.phpbb.com/ |
|