Galaxy Legion Forum
http://galaxylegion.com/forum/

Planetary Invasion Calculator
http://galaxylegion.com/forum/viewtopic.php?f=4&t=15501
Page 1 of 1

Author:  Ferros [ Tue Nov 01, 2011 8:44 am ]
Post subject:  Planetary Invasion Calculator

Any of you guys good with Excel think you could do one?

Author:  Lone.Lycan [ Tue Nov 01, 2011 2:48 pm ]
Post subject:  Re: Planetary Invasion Calculator

yep.. i've done one
i have a non-user-friendly one for personal use
last update included atmospheric decimators
i might eventually throw in the few other items it's missing

i'm not planning on sharing the spreadsheet, but... if you tell me how many missions you've fully completed and list your modules, and answer a few questions, i'll tell you your planetary invasion attack total

I might eventually make a javascript-enabled html page that i'd be willing to share

Author:  Toastar [ Tue Nov 01, 2011 6:13 pm ]
Post subject:  Re: Planetary Invasion Calculator

The main thing is to keep the order of operations right and remember that crimson amps etc. don't affect Invasion-Only bonuses (like when it says Invasion Attack +45)

My sheet has all my weapons listed separately, with attack and invasion attack in separate columns.

Add up all your weapon attack. Make sure to get every last thing that adds attack - it's easy to miss a couple mission items or Hull/Attack hybrids.
THEN add your Tactical officers to that. If you've done it right, you should match your 'Attack' stat in GL.

I made separate columns for each attack buff - so I could see my attack if I had just an obelisk and foci, or if I added an amp, and then a crux amp.

(((((Guns + Officers) * 1.05)*1.10)*1.15)*1.10) = Fully Buffed Attack (FBA)
1.05 = Foci 1.1 = Obelisk 1.15 = Amp 1.1 = Crux

Remember that buffs do not affect Invasion Attack, so do not factor it in at this stage!

To calculate your invasion attack bonus, separately add up the Invasion bonus from items like the Psi Emitter and Prototype Mech.
Then, add it on to your earlier figure:

(FBA + Invasion Attack)

If you have Atmospheric Decimators, I'm told the 7% affects everything, as does the 20% if you're a Konqul. So the full thing you want is:

((((FBA + Invasion Attack)*1.07)*1.07)*1.2)

1.07 = Decimator 1.2 = Konqul-only bonus

Author:  Ferros [ Thu Nov 03, 2011 7:22 pm ]
Post subject:  Re: Planetary Invasion Calculator

Don't you divide FBA by 3?

Author:  Lone.Lycan [ Thu Nov 03, 2011 7:56 pm ]
Post subject:  Re: Planetary Invasion Calculator

the 1/3 ratio gets applied when comparing to the final invasion attack total of the ship to the final invasion defense total of the planet to get the chance

Author:  Toastar [ Thu Nov 03, 2011 11:31 pm ]
Post subject:  Re: Planetary Invasion Calculator

Right, the the formula I gave doesn't tell you your chance of succeeding an attack, it just tells you what your total attack would be for the invasion, with everything factored in.

To see what defenses you'd have a 90% (max) chance against, do

((Total of Everything/3)/.9)

Author:  QCubed [ Tue Jul 24, 2012 11:43 am ]
Post subject:  Re: Planetary Invasion Calculator

Toastar wrote:
The main thing is to keep the order of operations right and remember that crimson amps etc. don't affect Invasion-Only bonuses (like when it says Invasion Attack +45)

My sheet has all my weapons listed separately, with attack and invasion attack in separate columns.

Add up all your weapon attack. Make sure to get every last thing that adds attack - it's easy to miss a couple mission items or Hull/Attack hybrids.
THEN add your Tactical officers to that. If you've done it right, you should match your 'Attack' stat in GL.

I made separate columns for each attack buff - so I could see my attack if I had just an obelisk and foci, or if I added an amp, and then a crux amp.

(((((Guns + Officers) * 1.05)*1.10)*1.15)*1.10) = Fully Buffed Attack (FBA)
1.05 = Foci 1.1 = Obelisk 1.15 = Amp 1.1 = Crux

Remember that buffs do not affect Invasion Attack, so do not factor it in at this stage!

To calculate your invasion attack bonus, separately add up the Invasion bonus from items like the Psi Emitter and Prototype Mech.
Then, add it on to your earlier figure:

(FBA + Invasion Attack)

If you have Atmospheric Decimators, I'm told the 7% affects everything, as does the 20% if you're a Konqul. So the full thing you want is:

((((FBA + Invasion Attack)*1.07)*1.07)*1.2)

1.07 = Decimator 1.2 = Konqul-only bonus


I remember reading someone, mento maybe, where they determined that buffs do affect invasion attack and invasion defense, maybe it was just invasion defense...?

Author:  QCubed [ Tue Jul 24, 2012 11:45 am ]
Post subject:  Re: Planetary Invasion Calculator

Toastar wrote:
Right, the the formula I gave doesn't tell you your chance of succeeding an attack, it just tells you what your total attack would be for the invasion, with everything factored in.

To see what defenses you'd have a 90% (max) chance against, do

((Total of Everything/3)/.9)


if a player is inactive, I hear tell you can have over an 90% chance of invade, but I've never been able to confirm this as you only see your chances on a failure...

Author:  Darth Flagitious [ Tue Jul 24, 2012 1:17 pm ]
Post subject:  Re: Planetary Invasion Calculator

QCubed wrote:
I remember reading someone, mento maybe, where they determined that buffs do affect invasion attack and invasion defense, maybe it was just invasion defense...?


My experience and spreadsheet do not support that. Legion bonus does apply to the invasion defense stat (Lazuli Pylon, Soldier Outpost, etc) however. Not sure about +xx% Defense buffs such as Barrier Nexus effect or even Xecti racial bonus though as I've not failed on any invasions with that category of bonus.

Author:  ODragon [ Tue Jul 24, 2012 4:48 pm ]
Post subject:  Re: Planetary Invasion Calculator

Darth Flagitious wrote:
QCubed wrote:
I remember reading someone, mento maybe, where they determined that buffs do affect invasion attack and invasion defense, maybe it was just invasion defense...?


My experience and spreadsheet do not support that. Legion bonus does apply to the invasion defense stat (Lazuli Pylon, Soldier Outpost, etc) however. Not sure about +xx% Defense buffs such as Barrier Nexus effect or even Xecti racial bonus though as I've not failed on any invasions with that category of bonus.

I can confirm that buffs do effect invasion defense items.

Author:  Darth Flagitious [ Tue Jul 24, 2012 4:56 pm ]
Post subject:  Re: Planetary Invasion Calculator

So you're saying a lazuli pylon with a barrier nexus would count as 600*1.3*legionbonus?

Author:  ODragon [ Tue Jul 24, 2012 5:18 pm ]
Post subject:  Re: Planetary Invasion Calculator

Darth Flagitious wrote:
So you're saying a lazuli pylon with a barrier nexus would count as 600*1.3*legionbonus?


Sorry, I misread, I meant debuffs do effect them.

I had been seeing some discrepancies on my spreadsheet so it might be do to that. I wouldn't be surprised if they do. I'll have to check on the next one I invade (after I update it for all of the invasion items + %invasion bonuses there are now).

Author:  Darth Flagitious [ Tue Jul 24, 2012 6:25 pm ]
Post subject:  Re: Planetary Invasion Calculator

ODragon wrote:
Darth Flagitious wrote:
So you're saying a lazuli pylon with a barrier nexus would count as 600*1.3*legionbonus?


Sorry, I misread, I meant debuffs do effect them.

I had been seeing some discrepancies on my spreadsheet so it might be do to that. I wouldn't be surprised if they do. I'll have to check on the next one I invade (after I update it for all of the invasion items + %invasion bonuses there are now).


Hmmm... Interesting.... Like I said, I've not failed an invasion with both an invasion structure AND % defense bonus/nerf, so I can't corroborate. However, I will be watching any failed invasions in the future so we can confirm or refute and thereby gain an even more accurate invasion formula.

Author:  neevale [ Wed Jul 25, 2012 3:35 am ]
Post subject:  Re: Planetary Invasion Calculator

QCubed wrote:
Toastar wrote:
Right, the the formula I gave doesn't tell you your chance of succeeding an attack, it just tells you what your total attack would be for the invasion, with everything factored in.

To see what defenses you'd have a 90% (max) chance against, do

((Total of Everything/3)/.9)


if a player is inactive, I hear tell you can have over an 90% chance of invade, but I've never been able to confirm this as you only see your chances on a failure...


i can confirm that u can get over 90% on a planet invasion if player is inactive. i once remember invading one planet i probed with governance probe that was inactive and got 91% i think.... i failed at 79% the day b4 because i didn't buff then probed to see if player was active or not to be safe leaving it 24 hours for another attempt... and then was not all to happy seeing a fail at 91% :x

Page 1 of 1 All times are UTC
Powered by phpBB® Forum Software © phpBB Group
https://www.phpbb.com/