contact
September 19, 2020, 10:00:16 PM

Author Topic: Fleet Cost Calculator/Moon Chance Calculator  (Read 1477 times)

0 Members and 1 Guest are viewing this topic.

Offline Master

  • Member
  • Posts: 1110
    • View Profile
Fleet Cost Calculator/Moon Chance Calculator
« on: February 20, 2010, 05:10:51 PM »
I was bored in class today so I made this. It is pretty simple but I locked out invalid inputs and made it so its hard to unintentionally change things.

Here it is if anyone wants it.
v2.2 added new ships from 2012 on for normal sfc unis, added a rsp field and probably some other things as I didn't do patch notes for the last few versions.

v2.2 Download

v1.5 changes:
Added resource percentage of total fleet by ship type.

v1.5 Download

v1.4 changes:
Long overdue heph added.

unprotected v1.3: v1.3 Download

v1.3 changes:
Added moon chance and Title text.

regular v1.3: v1.3 Protected Download

unprotected v1.3: v1.3 Download

v1.2 changes:
Added cargo capacity for ships to see how much can be carried away. Rearranged and added some colors and formatting to make it look a little easier to read. Fixed Gaia spelling.

Regular v1.2:  v1.2 Protected Download

Unprotected v1.2: v1.2 Download

v1.1 changes:
Added debris fields, fixed hercules spelling, added gia, added total resources and total debris, fixed mistype for athena crystal cost.

Now there are two versions normal version has protection enabled but not password protected, to prevent unintentional altering of formulas and data.
v1.1 Protected Download
And a unprotected version which is the same with no protection enabled.
v1.1 Download
« Last Edit: February 01, 2020, 03:36:15 AM by Master »
poeticmotion: You know what will happen if I oracle-lock you?

Absolutely nothing. I\'ll cuss a few times, mutter "holy crap, I\'m not even going to battlecalc that" and have nightmares about 10000 capitol ships descending upon my homeworld.

Offline Catfish

  • Member
  • Posts: 1070
    • View Profile
Re: Fleet cost calculator
« Reply #1 on: February 21, 2010, 01:15:35 AM »
Are your other sheets hidden in some way? I'd like to put this in an all-in-one sort of spreadsheet I'm working on atm, but I can't find your formulas or values
« Last Edit: January 01, 1970, 12:00:00 AM by Guest »
The [size=100]WIKI[/size][/b][/url][/u] is your friend.

Offline Ness

  • Member
  • Posts: 212
    • View Profile
Re: Fleet cost calculator
« Reply #2 on: February 21, 2010, 01:22:49 AM »
Feature request:  could you also calculate the expected debris field if your fleet was crashed?
« Last Edit: January 01, 1970, 12:00:00 AM by Guest »

Offline Master

  • Member
  • Posts: 1110
    • View Profile
Re: Fleet cost calculator
« Reply #3 on: February 21, 2010, 02:00:43 AM »
Ok I will add debris fields, fix hercules, add gia, and make a second one that has nothing hidden. there is no password so all you have to do to un-protect it is click the review tab in excel and select un-protect sheet. I thought it was easy to un-hide the sheet as well but it seems I can't get that option through the normal buttons on the released version.
« Last Edit: January 01, 1970, 12:00:00 AM by Guest »
poeticmotion: You know what will happen if I oracle-lock you?

Absolutely nothing. I\'ll cuss a few times, mutter "holy crap, I\'m not even going to battlecalc that" and have nightmares about 10000 capitol ships descending upon my homeworld.

Offline Master

  • Member
  • Posts: 1110
    • View Profile
Re: Fleet cost calculator
« Reply #4 on: February 23, 2010, 06:20:15 AM »
Made some changes and corrections for the second time. I think it might be a little more useful now with cargo capacities now, and a little easier to read with colors and formatting added. Sad part is that I did all of the cargo capacities from memory, and they were all correct when I checked them...
« Last Edit: January 01, 1970, 12:00:00 AM by Guest »
poeticmotion: You know what will happen if I oracle-lock you?

Absolutely nothing. I\'ll cuss a few times, mutter "holy crap, I\'m not even going to battlecalc that" and have nightmares about 10000 capitol ships descending upon my homeworld.

Offline Master

  • Member
  • Posts: 1110
    • View Profile
Re: Fleet Cost Calculator/Moon Chance Calculator
« Reply #5 on: February 25, 2010, 08:36:41 AM »
Updated for v1.3 see first post for details.
« Last Edit: January 01, 1970, 12:00:00 AM by Guest »
poeticmotion: You know what will happen if I oracle-lock you?

Absolutely nothing. I\'ll cuss a few times, mutter "holy crap, I\'m not even going to battlecalc that" and have nightmares about 10000 capitol ships descending upon my homeworld.

Offline Master

  • Member
  • Posts: 1110
    • View Profile
Re: Fleet Cost Calculator/Moon Chance Calculator
« Reply #6 on: November 19, 2010, 06:34:58 AM »
Added the Hephaestus in version 1.4 which was only slightly overdue...
« Last Edit: January 01, 1970, 12:00:00 AM by Guest »
poeticmotion: You know what will happen if I oracle-lock you?

Absolutely nothing. I\'ll cuss a few times, mutter "holy crap, I\'m not even going to battlecalc that" and have nightmares about 10000 capitol ships descending upon my homeworld.

Offline Master

  • Member
  • Posts: 1110
    • View Profile
Re: Fleet Cost Calculator/Moon Chance Calculator
« Reply #7 on: April 23, 2011, 02:26:16 PM »
Added percentage of ship type vs fleet cost by straight rsp values per request from someone.
« Last Edit: January 01, 1970, 12:00:00 AM by Guest »
poeticmotion: You know what will happen if I oracle-lock you?

Absolutely nothing. I\'ll cuss a few times, mutter "holy crap, I\'m not even going to battlecalc that" and have nightmares about 10000 capitol ships descending upon my homeworld.

Offline Master

  • Member
  • Posts: 1110
    • View Profile
Re: Fleet Cost Calculator/Moon Chance Calculator
« Reply #8 on: January 28, 2020, 12:39:04 AM »
Updated to add "new ships" and rsp field
poeticmotion: You know what will happen if I oracle-lock you?

Absolutely nothing. I\'ll cuss a few times, mutter "holy crap, I\'m not even going to battlecalc that" and have nightmares about 10000 capitol ships descending upon my homeworld.