*UPDATED* Super Ship Design Builder

[whitelightercarl]

Super Ship Design Builder
  Ship builder link here:

Mirror 1
Mirror 2


changes:

*added input for accuracy and absorb bonus
*optimized shields
*changed the default weapon accuracy from 55% to 60%
*changed the formula for shields and accuracy to make it more accurate (thanks to FTP) 

===================================================================

Please post you comments and suggestion so that I could make some improvements.

Also let me know if you encountered any computation error.

[Belana]

Here are some better shield stacks, I would like to add them to your program, but alas, I don't have the password to edit the calculations:

SHIELDS
ABS tot# 1st   2nd     3rd           Energy Total
50   16    27   25 x 0   24 x 15      3,265,589
51   16    27   26 x 1   25 x 14      5,586,651
52   16    28   26 x 1   25 x 14      6,678,918
53   18    28   26 x 16  25 x 1      11,336,721
54   18    29   26 x 16  25 x 1      13,521,254
55   18    29   28 x 0   27 x 17     23,078,582
56   18    30   28 x 0   27 x 17     27,447,649
57   18    30   29 x 1   28 x 16     48,200,721
58   18    31   29 x 1   28 x 16     56,938,854
59   20    31   29 x 18  28 x 1      98,460,647
60   20    32   29 x 18  28 x 1     115,936,914
61   20    32   31 x 0   30 x 19    201,133,720
62   20    33   31 x 0   30 x 19    236,086,253
63   20    33   32 x 1   31 x 18    419,587,047
64   20    34   32 x 1   31 x 18    489,492,114
65   20    35   32 x 1   31 x 18    629,302,247
66   22    35   32 x 20  31 x 1     996,319,518
67   22    36   32 x 20  31 x 1     1,275,939,785
68   22    36   34 x 0   33 x 21    2,027,419,245
69   22    37   34 x 0   33 x 21    2,586,659,778
70   22    37   35 x 1   34 x 20    4,194,476,318
71   22    38   35 x 1   34 x 20    5,312,957,385
72   24    38   35 x 2   34 x 1      8,528,606,110
73   24    39   35 x 22  34 x 1    10,765,568,243
74   24    39   37 x 0    36 x 23    17,336,644,517
75   24    40   37 x 0   36 x 23     21,810,568,784
76   24    40   38 x 1    37 x 22    35,791,582,110
77   24    41   38 x 1    37 x 22    44,739,430,643
78   26    41   38 x 24   37 x 1     72,701,472,982
79   26    42   38 x 24   37 x 1     90,597,170,049
80   26    42   40 x 0     39 x 25  147,639,704,441

[SorisDark]

the 60% acc doesn't help, u need computers but don't have any

[Mobius13]

if u need comps read the "computers" list on design & strategy room

[whitelightercarl]

Here are some better shield stacks, I would like to add them to your program, but alas, I don't have the password to edit the calculations:

SHIELDS
ABS tot# 1st   2nd     3rd           Energy Total
50   16    27   25 x 0   24 x 15      3,265,589
51   16    27   26 x 1   25 x 14      5,586,651
52   16    28   26 x 1   25 x 14      6,678,918
53   18    28   26 x 16  25 x 1      11,336,721
54   18    29   26 x 16  25 x 1      13,521,254
55   18    29   28 x 0   27 x 17     23,078,582
56   18    30   28 x 0   27 x 17     27,447,649
57   18    30   29 x 1   28 x 16     48,200,721
58   18    31   29 x 1   28 x 16     56,938,854
59   20    31   29 x 18  28 x 1      98,460,647
60   20    32   29 x 18  28 x 1     115,936,914
61   20    32   31 x 0   30 x 19    201,133,720
62   20    33   31 x 0   30 x 19    236,086,253
63   20    33   32 x 1   31 x 18    419,587,047
64   20    34   32 x 1   31 x 18    489,492,114
65   20    35   32 x 1   31 x 18    629,302,247
66   22    35   32 x 20  31 x 1     996,319,518
67   22    36   32 x 20  31 x 1     1,275,939,785
68   22    36   34 x 0   33 x 21    2,027,419,245
69   22    37   34 x 0   33 x 21    2,586,659,778
70   22    37   35 x 1   34 x 20    4,194,476,318
71   22    38   35 x 1   34 x 20    5,312,957,385
72   24    38   35 x 2   34 x 1      8,528,606,110
73   24    39   35 x 22  34 x 1    10,765,568,243
74   24    39   37 x 0    36 x 23    17,336,644,517
75   24    40   37 x 0   36 x 23     21,810,568,784
76   24    40   38 x 1    37 x 22    35,791,582,110
77   24    41   38 x 1    37 x 22    44,739,430,643
78   26    41   38 x 24   37 x 1     72,701,472,982
79   26    42   38 x 24   37 x 1     90,597,170,049
80   26    42   40 x 0     39 x 25  147,639,704,441

Thanks I'm gonna put them on this builder once I have enough time

[Jan`go Vhett]

Hey Carl I assume since you have a calc that you have the weapon calc without being ingame. I was wondering if you would mind sharing it with me at least.

[whitelightercarl]

Hey Carl I assume since you have a calc that you have the weapon calc without being ingame. I was wondering if you would mind sharing it with me at least.

hmmmm.. lemme think about it, I think its time for the people to know the weapon formula
 

[Mobius13]

give em to me too carl... i dont have patience to fix my weapon 

[whitelightercarl]

Perfect Weapon Formula:
Weight:8 (see below if you will use 1 weight weapon)



Where:

EN = Energy

ACCVALUE =

ACCURACY   
1%   9,771,310
2%   9,786,310
3%   9,801,310
4%   9,816,310
5%   9,831,310
6%   9,846,310
7%   9,861,310
8%   9,876,310
9%   9,891,310
10%   9,906,310
11%   9,921,310
12%   9,936,310
13%   9,951,310
14%   9,966,310
15%   9,981,310
16%   9,996,310
17%   10,011,310
18%   10,026,310
19%   10,041,310
20%   10,056,310
21%   10,071,310
22%   10,086,310
23%   10,101,310
24%   10,116,310
25%   10,131,310
26%   10,146,310
27%   10,161,310
28%   10,176,310
29%   10,191,310
30%   10,206,320
31%   10,206,330
32%   10,206,350
33%   10,206,390
34%   10,206,470
35%   10,206,630
36%   10,206,950
37%   10,207,590
38%   10,208,870
39%   10,211,430
40%   10,216,550
41%   10,226,790
42%   10,247,270
43%   10,288,230
44%   10,370,150
45%   10,533,990
46%   10,861,670
47%   11,517,030
48%   12,827,750
49%   15,449,190
50%   20,692,070
51%   31,177,830
52%   52,149,350
53%   94,092,390
54%   177,978,470
55%   345,750,630
56%   681,294,950
57%   1,352,383,590
58%   2,694,560,870
59%   5,378,915,430
60%   10,747,624,550
61%   21,485,042,790
62%   42,959,879,270
63%   85,909,552,230
64%   171,808,898,150
65%   343,607,589,990

Note:
***This formula applies only if energy input is more than 3102
***Applies only for 8 weight weapon, add 999003 instead of 1019323 if the weapon's weight is 1.

[Jan`go Vhett]

Thank you. This will be very helpful.

[Mobius13]

thanks carl! 

[Silentmob]

So all the purple cells means the final stats?
And all the other ones means the individual things stats?

[Belana]

Hey Carl Just a note in case you didn't get the one I sent to your personal box.
Can I get an unprotected copy of the spreadsheet to play around with?
I got it so I deleted my e-mail address   

Thanks

[whitelightercarl]

haha Even I myself forgot the password but I know that its going to happen so I made a duplicate unprotected file.  I sent the file to your mail

[Dr.Mengele]

hey it download the program but it doesn't let me use it say have have to unlock the password