View unanswered posts | View active topics It is currently Thu Mar 28, 2024 9:05 am



Reply to topic  [ 16 posts ] 
 Planetary Production Help Spreadsheet (upon request) 

Let me know what ya think about this... I CAN update
1) I would like to see More from you! 89%  89%  [ 16 ]
2) Awesome 11%  11%  [ 2 ]
3) I Like it 0%  0%  [ 0 ]
4) it's ok 0%  0%  [ 0 ]
5) Needs work 0%  0%  [ 0 ]
6) WTF were you doing? 0%  0%  [ 0 ]
7) Please don't post anymore... 0%  0%  [ 0 ]
Total votes : 18

 Planetary Production Help Spreadsheet (upon request) 
Author Message

Joined: Sun May 02, 2010 12:01 am
Posts: 203
Reply with quote
I will try to make a spreadsheet on what the production values would be for various sized of planets and abundance of materials.

This is easily figured out upon one's self but at least this might help. Thanks for some of the posts Dan as in some of your information was used!!! =D (please post questions or comments after so maybe i can update this for everyone later to a new Thread!

Below is some generic information that should me used for class and race specializations and bonus's
I DO WANT to say.. i have a spreadsheet made on my compute that i can just input numbers and go from there... so if any other questions please ask!!! thanks!!!
Below is a list of all planetary types in Galaxy Legion and their abilities:

Gas - research only
Barren - good minerals
Volcanic - good minerals
Toxic - variable
Icy - good artifacts
Oceanic - good artifacts and research
Terra - great artifacts, good research
Desert - variable
Exotic - great everything
Dyson - amazing everything, only a few in the galaxy

With that said, here is a quick cheat-sheet on the availabilities: (labeled beside are the % abundance of resources gained)

Extremely Sparse (-75%)
Very Sparse (-50%)
Sparse (-25%)
Average (+0%)
Abundant (+25%)
Very Abundant (+50%)
Extremely Abundant (+75%)
Rich (+100%)
Very Rich (+125%)
Extremely Rich (+150%)
Ultra Rich (+175%)
Mega Rich (+200%)
X Mega Rich (these come in 2X - 40X) (this varies based on the (#)X-Mega Richness) (2x Mega = 250%, 3x Mega = 275%... etc)

Size of planets from largest to smallest: (the # beside then is the BUILDING space available on each
1- Dyson (only a few in the entire galaxy) (81)
2 - Colossal (only a few in the entire galaxy) (75)
3 - Very Massive (69)
4 - Massive (63)
5 - Very Large (57)
6 - Large (51)
7 - Average (45)
8 - Small (39)
9 - Very Small (33)
10 - Tiny (27)
11 - Very Tiny (21)

------RACES------
- Inergon - 10% extra max energy
- Human - 10% extra to all experience gains
- Konqul - 20% extra ship attack
- Sillixx - 10% extra ship size
- Vygoid - 20% bonus to research

PROFESSIONS - Merchant - 20% extra cargo space (Inergon, Sillixx, Human)
- Spy - 20% extra cloaking (Inergon, Konqul, Human, Vygoid)
- Physicist - 10% extra shielding (Aerlen, Inergon, Vygoid)
- Explorer - 10% extra scanning (Aerlen, Inergon, Sillixx, Human)
- Builder - 50% reduced upkeep (Inergon, Konqul, Sillixx, Vygoid)
- Fixer - 20% extra hull strength (Aerlen, Konqul, Sillixx)
- Biologist - 10% extra planet population (Aerlen, Inergon, Sillixx)
- Excavator - 10% extra artifact production (Aerlen, Konqul, Vygoid)
- Miner - 10% extra mineral production (Konqul, Human, Vygoid)
- Hacker - 20% extra hacking (Aerlen, Human, Vygoid)
- Raidier - 20% extra raiding ( Konqul, Sillixx, Human)

Development Bonus breakdown: (these are to all resources on planet)
New - 0 days owned - +0% production bonus
Emerging - 1 days owned - +20% production bonus
Developing - 2 days owned - +40% production bonus
Maturing - 3 days owned - +60% production bonus
Peaking - 4 days owned - +80% production bonus
Peaked - 5 days owned - +100% production bonus


Before i get into the Spreadsheets i just want to explain ONCE how TOTAL production is Figured up.... that way i can make a fast simple spreadsheet that you can figure out on your own! ;)

Total production is figured by this equation:
Base Production = Amount from structures
availability bonus = Abundance of resources
Development Bonus = Time Owned (0-5 days)
Race Bonus = Depends on specific resource and race... (mining and artifacts give 10%, research gives 20%) (IF your that class/race ONLY)


(base production (from buildings))+(base production*% of abundance)= Y
(Y + (Y*% of Development Bonus)= Z
(Z + (Z*% of Race/class Bonues) = Grand total

(Kinda Confusing Right?) Here's the actual Example and Breakdown


My planet: Very Massive (how much space is alowed to build on (69 in this case))
Gas
Very Abundant research (this is the availability Bonus) (50% in this case)

Total hourly production: 72 Units an hour

----break down of production to get 72/hr----

Research Production: 24 (Output from buildings on planet BEFORE bonus's)
Availability Bonus: 50% (From the Abundance of resource on planet)
Development Bonus: 100% (This varies on how long you've owned planet)

ok back to my production of 72/hour

This is all based off the amount of building on the planet actually producing resources...
so for mine it starts out at 24 (from building Bonus's)

so the start is 24

Then we add the 50% availability Bonus so... 24+(24 * .50) = 36

The development Bonus (this one is FULLY developed) is derived from that Number of 36 so... 36 + (36 * 1.00) =72

If you were Vygoid you would add another 20% to research on this planet from that 72

so 72 + (72 *.20) = 86.4 per hour (if you were Vygoid)

This goes along with any race or class bonus's... it is always added last..

so another quick example... in case you need it

Large Barren Planet (51 space)
Very Abundant Mining (50% production Bonus)

16 base production from buildings, 50% bonus from abundance on planet, and 80% development bonus, and 10% class bonus.. so...

16+ (16*.5)= 24 /hr
24+ (24*.8)= 43.2 /hr
43.2 +(43.2*.1)= 47.52 /hr

so in one day it would chance to 100% development so...

16+ (16 *.5)= 24 /hr
24+ (24 * 1.00)= 48 /hr
43.2 +(43.2 * .1)= 52.8 /hr

52.8 per/hr mined on this one planet


SO NOW the SPREADSHEET (KINDA) lol I might not list EVERYTHING but this should be ENOUGH to get a general Idea of what is BEST!

(This all ALSO depends on TECH level of structures and is assuming your building MAX production ON the planets for that ONE resource ONLY)

Spreadsheet #1 (Assuming you have MAX of ALL Buildings size 4 (+1 production), 100% developed, (with "NO" Race/Class Bonus's Added) Per/Hour
Code:
                             (-75%)   (-50%)    (-25%)     (+0%)     (+25%)     (+50%)     (+75%)     (+100%)     (+125%)    (+150%)     (+175%)
1 - Colossal        (75)       9        18        27        36         45          54         63          72          81         90         99

2 - Very Massive    (69)      8.5      17        25.5       34       42.5          51         59.5        68        76.5        85         93.5

3 - Massive         (63)      7.5       15        22.5      30       37.5          45       52.5          60         67.5        75         82.5

4 - Very Large      (57)       7        14         21       28          35         42        49           56          63         70          77

5 - Large           (51)       6        12         18       24          30         36        42           48          54         60          66

6 - Average         (45)       5.5       11       16.5      22       27.5           33       38.5         44         49.5        55         60.5

7 - Small           (39)       4.5        9        13.5     18        22.5          27       31.5          36        40.5        45         49.5

8 - Very Small      (33)       4          8         12      16          20          24        28          32         36          40          44

9 - Tiny            (27)       3          6         9       12         15           18       21            24         27         30          33

10 - Very Tiny      (21)       2.5        5         7.5      10         12.5        15       17.5         20         22.5        25          27.5


*NOTE* These are building AS many size 4 +1 production buildings as you can.. so there may be space left over for other buildings

I do want to say.. if you want the total for ANY race/Class Bonus then take the total above and times it by 10% or 20% for research and add that back onto the total for your awnser

Example: Research bonus (20% or .2)

total (6) * (.20) = 1.2
6+1.2 = 7.2 per hour for Vygoid Reseach on a TINY -25% production planet for research

*UPDATE*

Spreadsheet #2 (Assuming you have MAX of ALL Buildings size 7 (+2 production), 100% developed, (with "NO" Race/Class Bonus's Added) Per/Hour
Code:
                             (-75%)   (-50%)    (-25%)    (+0%)     (+25%)     (+50%)     (+75%)     (+100%)     (+125%)    (+150%)     (+175%)
1 - Colossal        (75)       10       20        30       40         50         60         70          80         90         100         110

2 - Very Massive    (69)       9        18        27       36         45         54         63          72         81          90          99

3 - Massive         (63)       9        18        27       36         45         54         63          72         81          90          99

4 - Very Large      (57)       8        16        24       32         40         48         56          64         72          80          88

5 - Large           (51)       7        14        21       28         35         42         49          56         63          70          77

6 - Average         (45)       6        12        18       24         30         36         42          48         54          60          66

7 - Small           (39)       5        10        15       20         25         30         35          40         45          50          55

8 - Very Small      (33)       4         8        12       16         20         24         28          32         36          40          44

9 - Tiny            (27)       3         6         9       12         15         18         21          24         27          30          33

10 - Very Tiny      (21)       3         6         9       12         15         18         21          24         27          30          33


*NOTE* These are building AS many size 7 +2 production buildings as you can.. so there may be space left over for other buildings


Last edited by Cloesdaddy on Wed May 05, 2010 8:07 pm, edited 4 times in total.



Mon May 03, 2010 11:47 pm
Profile
User avatar

Joined: Sun Feb 14, 2010 4:49 am
Posts: 2606
Location: Cowland
Reply with quote
polls dont work for some reason (any) but i choose option 1

_________________
Your right to an opinion does not mean your opinion is right.


Mon May 03, 2010 11:54 pm
Profile
User avatar

Joined: Wed Feb 10, 2010 1:34 pm
Posts: 101
Reply with quote
ditto

this is f/ing amazing, you rock

_________________
life is a game, level up
Image 58,979,323,846,329,234,632,234,983
Image 1,358,979,323,846,247,981


Mon May 03, 2010 11:58 pm
Profile

Joined: Sun May 02, 2010 12:01 am
Posts: 203
Reply with quote
Thanks guys.. sorry the spreadsheet is kinda messed up with the 175% and the value to the left under the name.. the preveiw didn't show it like that... guess it did anyway lol


Tue May 04, 2010 12:13 am
Profile
User avatar

Joined: Thu Mar 18, 2010 8:35 pm
Posts: 214
Reply with quote
the spreadsheet is awesome. and easy to see without having to go to an outside source. keep it up


Tue May 04, 2010 12:16 am
Profile
User avatar

Joined: Wed Apr 21, 2010 9:38 pm
Posts: 499
Reply with quote
1) I would like to see More from you!

Seriously... Looks great, and very handy for deciding whether or not to abandon a planet to colonize another.

_________________
The poster formerly known as Headless


Tue May 04, 2010 12:20 am
Profile

Joined: Sun May 02, 2010 12:01 am
Posts: 203
Reply with quote
I'm working on something else at the momment that might help all of us here more then that spreadsheet.. but that's a start


Tue May 04, 2010 12:25 am
Profile

Joined: Mon May 03, 2010 6:25 am
Posts: 22
Reply with quote
An easy way to explain the way all of the bonuses work towards planetary resource production would be to say that they are multiplying factors rather than additive, since they compound upon each other.

In any case yes, makes it easy to know which planets are worth colonizing. If only I saw this before I colonized that very small volcanic planet!


Tue May 04, 2010 12:35 am
Profile
User avatar

Joined: Wed Feb 10, 2010 1:34 pm
Posts: 101
Reply with quote
i fixed the ability to vote, please try again

_________________
life is a game, level up
Image 58,979,323,846,329,234,632,234,983
Image 1,358,979,323,846,247,981


Tue May 04, 2010 1:16 am
Profile
User avatar

Joined: Sat Jan 09, 2010 12:49 pm
Posts: 2085
Reply with quote
Wow.... very cool.


Tue May 04, 2010 1:37 am
Profile

Joined: Sat Feb 06, 2010 10:50 am
Posts: 42
Reply with quote
Very Well done. O.O


Tue May 04, 2010 8:21 am
Profile
User avatar

Joined: Sun Feb 14, 2010 1:02 am
Posts: 391
Reply with quote
I believe your terra is incorrect. More often then not terra has great research and great artifacts. For example most of mine (I have a bunch) have extremely-mega rich research and usually the same in artifacts.

Crazy good info tho. Should be stickied O_O

Edit: Also on planet development you have them all as new

Its :
New
Emerging
Developing
Maturing
Peaking
Peaked

_________________
Image


Wed May 05, 2010 6:18 pm
Profile

Joined: Sun May 02, 2010 12:01 am
Posts: 203
Reply with quote
yeah i did notice that about the all news.. downfalls of copy and paste.. you forget to change everything lol.. it's fixed

And as for the Terra abundance and their types.. that is info i copied DIRECTLY from one of Dan's Posts.. so i can't really say if it's right or not.. in dan i trust lol

Also Updated My First Post so now the production without (race/class Bonus's) shows for (+1/ Size 4) and a separate one for (+2/ Size 7)


Wed May 05, 2010 6:39 pm
Profile

Joined: Tue May 04, 2010 10:55 pm
Posts: 37
Reply with quote
Can someone explain the effect of habitation modules? Are they about the amount of "damage" a planet can take? I'm trying to figure out if I should be investing in defense, attack, stealth, or production and how to balance having enough of each.

Thanks,
Sean


Sat May 08, 2010 5:18 pm
Profile

Joined: Mon Apr 12, 2010 4:13 pm
Posts: 622
Reply with quote
They just add pop which is planet HP. So, it will take more energy to attack it before invasion can be done. Best combined with defence

_________________
My current threads:
    Destroying the GAME: http://galaxylegion.com/forum/viewtopic.php?f=7&t=762&start=0
    Alliance!: http://galaxylegion.com/forum/viewtopic.php?f=6&t=157&start=0&hilit=alliance


Sat May 08, 2010 5:20 pm
Profile
User avatar

Joined: Wed Apr 21, 2010 9:38 pm
Posts: 499
Reply with quote
Sean Powell wrote:
Can someone explain the effect of habitation modules? Are they about the amount of "damage" a planet can take? I'm trying to figure out if I should be investing in defense, attack, stealth, or production and how to balance having enough of each.

Thanks,
Sean


Exactly. Habition increases population, which is the "health" of a planet the same way that hull is the health of your ship.

_________________
The poster formerly known as Headless


Sat May 08, 2010 5:21 pm
Profile
Display posts from previous:  Sort by  
Reply to topic   [ 16 posts ] 

Who is online

Users browsing this forum: Google [Bot] and 28 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:  
cron
Powered by phpBB® Forum Software © phpBB Group
Designed by ST Software.