Planets stats & terraforming

Mibal

Addict

5 years ago

Jan 14, 2019, 4:07:17 PM

Hi everybody,

During a game, I wondered if I can improve my super industrial system composed of hot-type planets (lavas and deserts) by terraforming it.

So I took out my sheet of paper and started counting the points. Finally all this ended up on an Excel sheet.

This may appeal to some people to understand the different bonuses and how they are calculated for planets.

It's in English but also in French (my native language). You can choose the language you want!

Here is the Excel file : ES2 - Planet terraformation V2.4.xlsm

Updated 5 years ago.

Mibal

Addict

mibal

Mibal

Addict

5 years ago

Jan 26, 2019, 2:23:42 PM

Update excel file to 2.1

- Correct a bug with English language

- Add 2 minors factions (from vaulters quest)

- Some little text errors

No modifiction for Penumbra mod (not yet...)

Updated 5 years ago.

Mibal

Addict

mibal

Mibal

Addict

5 years ago

Feb 8, 2019, 4:50:32 PM

Update excel file to 2.2

- Include new difficulty tables (1.4.7 S5) - Include Umbral Choir bonus / malus

Player

Difficulty

Raw FIDSI on Planet

Raw Prestige on Planet

Approval

Over colonization threshold

Over colonization penalty

Over population penalty

System Upkeep

Garrison Upkeep

Hero Upkeep

Net Minor Stress

Hacking Speed Percent Multiplier

Maximum Empire Processing Power Stock

Sandbox

+20

-20%

-50%

+10%

+40

Easy

+10

-10%

-25%

+5%

+20

Normal

Hard

+10%

Serious

+20%

Impossible

+30%

Endless

+40%

#	AI difficulty	Raw FIDSI on Planet	Raw Prestige on Planet	Approval	Over colonization threshold	Over colonization penalty	Over population penalty	System Upkeep	Garrison Upkeep	Hero Upkeep	Simplified Battle Damage Multiplier	Hacking Speed Percent Multiplier	Maximum Empire Processing Power Stock
0	Sandbox	-1	+1	-10		+10%	+10%	+10%	+10%	+10%		-20%	-10
1	Easy	-0.5	+0.5	+5		+5%	+5%	+5%	+5%	+5%		-10%	-5
2	Normal										-25%		0
3	Hard	+1	-1	+10		-10%	-10%	-10%	-10%	-10%	-40%		+10
4	Serious	+2	-1.5	+20		-20%	-20%	-20%	-20%	-20%	-55%		+20
5	Impossible	+3	-1.5	+40		-40%	-40%	-40%	-40%	-40%	-70%	+5%	+30
6	Endless	+4	-1.5	+60		-60%	-60%	-60%	-60%	-60%	-75%	+10%

#	AI difficulty	Maximum Juggernauts	Essence bonus (Vodyani) A=Arch count S=Leeching fleets count	Keii Hissho NO=Not Overcolonized
0	Sandbox
1	Easy
2	Normal		(A x 10) / S	+1 and +1 if NO
3	Hard	+1	(A x 25) / S	+1 and +1 if NO
4	Serious	+2	(A x 30) / S	+2 and +2 if NO
5	Impossible	+3	(A x 40) / S	+2 and +2 if NO
6	Endless	+4	(A x 45) / S	+2 and +2 if NO

Minors

#	Minor faction difficulty	Relation Points Trend	Relation Points Base Value	Hacking Speed Percent Multiplier	Net Trace Operation Progress	Raw Prestige on Planet	Approval	Stress	Troop Health Bonuses
0	Easy	+1	20	-50%	-50%	+1	-10	x 0.5	-30%
1	Normal			-25%	-25%	+0.5	+5
2	Hard	-1							+30%

Pirates

#	Pirates AI difficulty	Difficulty multiplier	Maximum Pirate fleet count	Hacking Speed Percent Multiplier	Net Trace Operation Progress
0	Easy	+38%	2	-50%	-50%
1	Normal	+42%	2	-25%	-25%
2	Hard	+46%	2

Updated 5 years ago.

Jacusky

Lord Protector

If you want the world to be a better place, begin by showing the world what that means.

Jacusky

Lord Protector

22 100g2g pts

5 years ago

Feb 8, 2019, 6:03:30 PM

As a fellow Excel Warrior, I appreciate the amount of work you've put into this resource. Thank you!

Mibal

Addict

mibal

Mibal

Addict

5 years ago

Mar 12, 2019, 1:28:08 PM

Update excel file to 2.3 (see first post to download)

- Fixed many bugs (many with the English language)

- Include Crescents (Umbral Choir)

- Includes new system enhancements (Science and Exploration - Tier 5)

- Add some missing system enhancements

- Add UC system enhancements

- Add Unique Planets bonuses (in the "Other bonus" section)

...

Updated 5 years ago.

gap81

Old Timer