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

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

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

Don't you divide FBA by 3?

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

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)

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

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...

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.

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.

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%