J. L. Brown
Cosmic Mongoose
That is a really nice approach. I believe that is a very good first-approximation, despite all the issues of 'what defines a Shipyard' in Traveller. Could you, perhaps, turn your spreadsheet towards the Trojan Reach? Knowing what each polity has as available capacity would be extremely useful.Since I had the spreadsheet already set up, I had it tell me the numbers after refining the population as per the World Builder's Handbook. I did not tally any builds for government types 6 & 7 as I don't believe they would be capable of such. I capped the population on A pop worlds at 10,000,000,000.
Class A (all jump-capable ships (including capital ships),spacecraft, and small craft): 99,249,078 dtons. As discussed earlier, 39,500,000 dtons of that are on Mora, Trin, Glisten, and Rhylanor. As those four systems are the only TL-15 shipbuilders, that means the remaining 59,749,078 dtons are TL-12 builds.
Class B (spacecraft and small craft, no jump-capable builds): 48,714,023 dtons.
Class C (small craft only, no jump-capable builds): 49,853,970 dtons.
That all adds up to: 197,817,071 dtons of shipbuilding capacity for the Spinward Marches in peacetime.
There is a thread discussing the consequences, costs, and impacts of the 'Pirates of Drinax' campaign scenario 'Treasure Ship': https://forum.mongoosepublishing.com/threads/drinax-campaign-treasure-ship-spoilers.118986
In that thread, someone estimates that the Imperial fleet for the entire Sector is 31 ships; and that seems very low. Of course, they are relying on what has been detailed in published material, which might reasonably be considered only a fraction of the strength of ships actually in service.