So, when we started, there were 4 Excelsiors, 1 Connie-A, 7 Consties, 12 Mirandas, serving in four home sectors, two border zones, supported by four starbases.
That comes to an Operations field establishment of 24 Starship captains, 6 Commodores, 4 Rear Admirals. Plus on the shore side, 1 Vice, a handful of other Rear Admirals, and a smattering of Commodores.
This has accelerated to 17 Excelsiors, 1 Connie-A, 9 Connie-Bs, a Rennie, 7 Consties, 8 Centaurs, 13 Mirandas, 4 Oberths for 60 Starship Captains. This is supporting 10 Home Sectors, 5 Border Zones, 12 Starbases, for 3 Vice Admirals, 15 Rear Admirals, 27 Commodores. Supporting that (will be) an Admiral, two other Vice Admirals, ~9 Rear Admirals, and a pack of other Commodores, all handling the near tripling of Starfleet, and the Federation.
Starting Starfleet = 22.9 million tons of shipping.
Currently it is = 69.85 million tons of shipping (not counting Oberths). So in terms of weight, it has more than tripled.
The Old Lady, Kahurangi, entered the Academy at 2256, graduated at 2260. Took 19 years after graduation to reach Captain. A total of 25 years to hit flag rank, plus 5 to Rear, plus 5 to Vice, plus 6 to Admiral. I daresay, as someone who ticked every box, and kept her nose clean, Kahurangi was a relatively meteoric rise in that old Starfleet. Only people like Kirk and ka'Sharren hit Captaincy faster than that. But I wonder how must shorter the wait to get flag rank is at the moment with the tripling of billets. Not sure how to model that. Maybe if I look at the first turn's personnel pool, the total ship crews, and take that as the spacegoing part of Starfleet, and then compare that. Because it's people who were already in service in 2301 who have a chance at these flag ranks atm.
Sounds like you need a Yeoman.
Help Wanted: Must be anal retentive with photographic memory, penchant for org charts.