Hi all.
I was working on another idea of mine a few days ago when I realised something was up with the Shipyard and how it calculates ORat for flotillas using ammo-using weapons. For some flotillas it seems to be calculating the ORat wrong. Now, I'm not sure, but I think it's to do with the look-up tables for the divisors. For the flotilla ORat formulae, the (hopefully relevant part of the) formula reads:
VLOOKUP($T$6,$BB$114:$BC$143)
But for non-flotillas it reads:
VLOOKUP($C$9,$BB$114:$BC$143)
What that does, I think, is that instead of referring to the size of the flotilla's hull, it refers to the number of the hulls in the flotilla, so for flotillas of more than 3 hulls, the flotilla has a ORat divisor of a hull-4 or more vessel, which makes it a 0.6 or even 0.8 rather than a 0.4.
If this is right, can someone comfirm it for me? I've done some preliminary errata for some of my supplements that takes this into account, and found that some of my flotillas, as a result, have a lower CRat than they should have.