1

(4 replies, posted in Grand Fleets)

You don't calculate the Firepower for light guns like you do for heavy guns.
Just multiply the number of each size by the Firepower rating given in the Light Guns Chart page 37 in the GF rule book.
Gun             Firepower
37mm/1lb     1.0
40mm/2lb     1.3
47mm/3lb     1.6
57mm/6lb     2.0
76mm/12lb   2.7
88mm/15lb   3.0
88mm/20lb   3.3

2

(1 replies, posted in Grand Fleets)

Since yesterday was the anniversary of the Battle of River Plate, here's a different take on the battle.
The 1956 movie version staring:
The USS Salem (Des Moines) CA as the Admiral Graf Spee, HMS Sheffield (Southhampton) CL as the HMS Ajax, HMS Jamaica (Fiji) CL as the HMS Exeter and HMNZS Achilles (Leander) CL as herself (INS Delhi).
Note: These are my own conversions of the ships based on Conway's All the Worlds Warships.

3

(46 replies, posted in News)

mj12games wrote:

I can't replicate this.

My mistake. When I changed cell X20 I did a find and replace to change K31 to K20 and that changed cell W31 as well as X20.  :oops:

4

(46 replies, posted in News)

Found another issue.
If you fill all 12 of the weapon slots on the SHIP1 tab, the last weapon doubles up on the DISPLAY tab.

5

(46 replies, posted in News)

That fixed it. However, the formula in X20 should look at cell K20 not K31.

=IF(K20=U$20,V$20,"")&IF(K20=U$21,V$21,"")&IF(K20=U$22,V$22,"")&IF(K20=U$23,V$23,"")&IF(K20=U$24,V$24,"")&IF(K20=U$25,V$25,"")&IF(K20=U$26,V$26,"")&IF(K20=U$27,V$27,"")&IF(K20=U$28,V$28,"")&IF(K20=U$29,V$29,"")&IF(K20=U$30,V$30,"")&IF(K20=U$31,V$31,"")

6

(46 replies, posted in News)

X20:X31 are all #NAME?
I don't recognize the TEXTJOIN command so I suspect that is the problem.

7

(46 replies, posted in News)

The BSUR is working now.
Next problem, the Display tab is not showing the weapon arcs and equipment.
It works in Office 365 but not Office 10.

8

(46 replies, posted in News)

Here is what I get with Office 10. BSUR changes to #NAME? as soon as I enter anything other than the Weapon Name.

9

(46 replies, posted in News)

Ran into a problem right away.
Trying to input a weapon and no matter what I input the BSUR gives me #NAME?
I get the same result with Office 10 and FreeOffice 2018

10

(2 replies, posted in Grand Fleets)

GF3 is very similar to Starmada: Nova.
It plays Solo in that you can play both sides since there is no hidden info. There are no special solo rules.

11

(8 replies, posted in Grand Fleets)

I got into GF3 a few months ago and updated Ruckdog's spreadsheet some.
I added the King & Kaiser revisions, edited some formulas that were returning errors on null inputs and increased the PS torpedo count to 12.

I added it to the files forum for everyone.
http://forum.mj12games.com/viewtopic.ph … mp;t=12771

12

(3 replies, posted in Starmada)

I would say the ship should move through the hex with the drone without impact since drones activate and attack during the fighter phase.

cnuzzi wrote:

Have you tried the Unity drydock on it? Does it work correctly?

Yup, it's what I use at home. Haven't had any problems.

Another option is Planmaker, part of FreeOffice 2018 from Softmaker. It has versions for Windows and Linux.
The PlanMaker spreadsheet part of it works great. I use it at home and MS Office at work with no compatibility issues beyond making sure to save as a .xlsx file rather than the native PlanMaker format.

15

(3 replies, posted in Starmada)

It would be easy to add them. A weaker, shorter range version of the Plasma-F with the Expendable (Exp) trait like Drones.
CR points wise it is almost a straight replacement for the left/right Phaser-3's.

Plasma-D Torpedo MA 8 2×2+/1/1 Evp; Exp               
▪ Bolt 3-6-9 1×4+/1/1 Dfn,Dfs; Exp               
◊◊ ☐| ◊◊ ☐

16

(4 replies, posted in Starmada)

The index for Alien Armada was posted on Facebook Oct 23 so it is coming, hopefully soon.
Tholian Webs and the Seltorian Web-Breakers look to be the main rules additions.

17

(60 replies, posted in Starmada)

I've gotten mine from ADB by emailing them at marketing@starfleetgames.com.
They replied and asked for the email associated with your DriveThru RPG, or Wargame Vault account and a selfie of you with the product.
Had the PDF within a day.

18

(60 replies, posted in Starmada)

mj12games wrote:

All conversions are based off of Federation Commander:

And there's the missing factor why my numbers don't always work out. I was using the regular SFB ships and they are a little different than FC. lol

19

(60 replies, posted in Starmada)

This is what I've come up with so far for converting SFB to unity.

Unity Hull: From the SFB SSD take the total number of boxes in the ship outline, add the excess damage boxes and divide by 10. There are only 2 ships that this doesn't work for and they are only off by 1 hull. (D7 comes out at 10 instead of 9. Large Freighter is 8 instead of 9.)

Unity Engines: Take the total power for the SSD, subtract the arming cost of all weapons, divide by the move cost, and then divide by 3.33. For ships with move cost of .33 add 2 to the final total. This works for about 70% of the ships.

Unity EPR: Looks like it maps straight to the SFB Move Cost.
MC        EPR
1.5        6
1        4
0.75        3
0.66        3
0.5        2
0.33        1
0        1

Unity Screens: Fore and Aft match to shields 1 & 4, total shield boxes divided by 3.33. Starboard and Port add shields 2 & 3 or 5 & 6 and divide by 6.66. This works for about 70% of the shields.

Clearly there are some factors that I am missing in the Engines and Screen calculations. But most of the numbers are only off by 1. The exceptions are the Front screens on the Burke FF, low by 2 (5 instead of 7), & Texas CL low by 3 (5 instead of 8. I think this is because the armor was added to the front shield.). Also the Engines of the FD7 Swiftsword calculate high by 2 (8 instead of 6. I think the 6 should have been a 7 like the other Fast cruisers.).

20

(60 replies, posted in Starmada)

I just got my copy yesterday so I haven't done more than skim through them. The new rules look great for SFU but I'm disappointed that the construction info is missing for the new Ship and Weapon traits.  sad

21

(3 replies, posted in Starmada)

Dan had mentioned that the CRAT on the ship page (M5) rounds up but the display page (Q2) rounds the the nearest 5.
It looks like LibreOffice might be rounding differently than MSExcel.

If the CRAT in M5 on the ship page rounds down rather than up you may end with a CRAT of 167 rounding to 165 for the nearest 5 vs. rounding up to 168 and 170.

Just the first thing that came to mind.

22

(63 replies, posted in Starmada)

murtalianconfederacy wrote:

The screens and the DRat rounding--I don't have any clue as to how to fix those, I'm afraid

The DRat rounding (Cell L) is actually just the displayed number. If you right click the cell, go to Format Cells and increase the decimal places displayed it shows the 2.4 for a Hull 1 Shield 1. So all you need to do is add ROUNDUP to the formula in L5.
Change from,

=((C8+Q8)*12/(6-R10)*PRODUCT(N34:N43))+SUM(M34:M43)

to,

=ROUNDUP(((C8+Q8)*12/(6-R10)*PRODUCT(N34:N43))+SUM(M34:M43),0)

The screens can be fixed by changing the formula in O11.
The current formula does all of the multiplication first then the addition (Order of Operations) so the tech multiplier is getting zeroed out.
You just need to change this,

=50*C11+30*SUM(E11:H11)*W10

to this.

=(50*C11+30*SUM(E11:H11))*W10

23

(63 replies, posted in Starmada)

There is more to it than that. Some of the cells on the Tables tab have calculations that refer back to the Ship# tabs.

24

(63 replies, posted in Starmada)

murtalianconfederacy wrote:

I had sent mj12games a PM about this, but as he hasn't been on for a week (thanks KDLadage for pointing it out), I'll post this up.

I found another couple mistakes. Two are easy fixes, one not so much (for my limited Excel-fu)

Slow weapon modifier is 0.7, should be 0.6

Guided+Telescopic shows as red--due to the range-based weapon trait column having a figure of 82, when it should be 80.

Selecting Piercing 1/2 and Proximity reads as an invalid combination.

For the Piercing 1/2 (Pr1/Pr2) and Proximity (Prx) invalid combo, the problem is that Pr* in the formula in Weapons! AK2:AK101 just looks at the first 2 characters so Pr1 & Prx end up the same.
To fix it, in Weapons!AK2 change this:

IF((COUNTIF(G2:K2,"NPr")+COUNTIF(G2:K2,"Pr*"))>1,1,0)

to this:

IF((COUNTIF(G2:K2,"NPr")+COUNTIF(G2:K2,"Pr1")+COUNTIF(G2:K2,"Pr2"))>1,1,0)

and copy down through AK101.

25

(33 replies, posted in Starmada Unity)

Those numbers seem pretty reasonable to me. The Sharlin really is a beast compared to the ships of the younger races and the EA Omega, even though called a "Destroyer" is really the EA's dreadnought class ship and should be comparable to the Octurion and the Bin'Tak.