contact
February 29, 2020, 09:10:04 AM

Author Topic: GA spreadsheet  (Read 855 times)

0 Members and 1 Guest are viewing this topic.

Offline pops2909

  • Member
  • Posts: 40
    • View Profile
GA spreadsheet
« on: November 30, 2014, 08:53:47 PM »
is there a spreadsheet online to help figure out how to disperse resources evenly from a group attack?

Offline Dr.Deeds

  • Member
  • Posts: 205
    • View Profile
Re: GA spreadsheet
« Reply #1 on: November 30, 2014, 11:06:22 PM »
not that i know of, but i have a pretty easy formula.
note:it does not apply in any unis like original where DSP is distributed evenly, but DOES apply in all unis where DSP is assigned based on participation.

Total DSP = A
Total DF = B
Total Losses = C

% of A = % of (B -C)

In other words, first distribute the DF to repair all losses.
Then divide the remaining DF by giving each participant the same % of it as the % of the DSP that they gained.

As far as plunder goes, that usually sorts itself out pretty fairly based on ships sent. I never worry about that one, just distribute the DF and call it good. 


Offline Swanvesta

  • Member
  • Posts: 818
    • View Profile
Re: GA spreadsheet
« Reply #2 on: November 30, 2014, 11:47:14 PM »
I made a spreadsheet a long time ago, that used the total amount of resources (ship values) sent per attacker to distribute debris/plunder. That's not so hard to calculate including ship losses.

Just requires a separate sheet with ship values and fields for each attackers losses. Then a few fancy equations :)
Miss Kiki: Believe me I have been well warned about you
Miss Kiki: I think it was stated that Swan is the biggest nut job in the SFC game community

Biggest nut job on SFC - I claim it!

Offline Pantin

  • Member
  • Posts: 832
    • View Profile
Re: GA spreadsheet
« Reply #3 on: December 01, 2014, 03:23:08 AM »
I have one. If enough people are interested in it I might actualyl fix it and send it to eljer so he can host it on his site

Offline Admiral T-Wayne

  • Member
  • Posts: 1006
    • View Profile
Re: GA spreadsheet
« Reply #4 on: December 01, 2014, 03:31:39 AM »
With the large fleets that are being used these days, it can be useful to include hydro burned for fuel in the calcs.

Offline Pantin

  • Member
  • Posts: 832
    • View Profile
Re: GA spreadsheet
« Reply #5 on: December 01, 2014, 03:22:45 PM »
I ahve an option al spot for H launch cost in mine

Offline Phil M

  • Member
  • Posts: 1216
    • Facebook - phil.mcbride.3
    • Skype - thesevenlevels
    • Twitter - philipmcbride
    • View Profile
    • Phil Mc Bride
Re: GA spreadsheet
« Reply #6 on: December 07, 2014, 10:59:23 AM »
i have one that factors in everything.

i passed it on to AAA coz they're dumb as fun and can't do their own maths, similarly they have a proper speed calc that rounds properly (also mine)

I thank you !!!

(hiya pants - waves)

(rethink, im not waving pants! I'm waving at pants!)
The darkest places in hell are reserved for those who maintain their neutrality in times of moral crisis.

 

birthmark-ant