In case I'm not awake for the 2317 EOY if it happens in the next several hours, preliminary audit
before the Q4.M3 CL and Q4 GBZ:
Assumptions
- Starting off with EOY 2316 (where there are inconsistencies there, using the more detailed info as official source)
- As discussed in private conv, Sol's 105br contribution should be fixed to be 95br to correspond with the actual 2310 budget increase and the computed annual incomes since 2310
- Per historical precedence, member ratifications replace the tech-based affiliation income (currently 0.15 O/E/T) rather than the major affiliation bonus income, even if the ratification crew income change text is ambiguous on the matter.
Casualties (in Starfleet-led operations and incidents)
Standard Starfleet: O-0 E-0 T-0
Explorer Corps: O-0 E-0 T-0
Career Casualties (in Starfleet-led operations and incidents)
Standard Starfleet: O-28 E-36 T-30
Explorer Corps: O-6 E-9 T-9
Human: O-4 E-3 T-1
Andorian: O-0 E-2 T-1
Tellarite: O-1 E-0 T-0
Amarki: O-0 E-1 T-2
Apiata: O-0 E-1 T-1
Rigellian: O-0 E-1 T-1
Ked Paddah: O-3 E-10 T-10
Total non-Explorer Corps: O-36 E-54 T-46
Total Starfleet Ship Losses: 2 Excelsior, 1 Constellation, 1 Centaur-A, 1 Centaur, 3 Miranda, 1 Oberth, 1 Hospital Ship
Total Other Ship Losses (in Starfleet-led operations and incidents): 1 Miranda-A, 3 Orah
Ships Lost
None
Ships Damaged
USS
Firefly, Miranda-A, NCC-1667
Ships Laid Down
Excelsior-A, NCC-2027
Excelsior-A, NCC-2028
Constellation-A, NCC-1826
Constellation-A, NCC-1827 (note: NCC-1827 was listed twice erroneously, assuming first one is NCC-1826)
Renaissance, NCC-2620
Renaissance, NCC-2621
Renaissance, NCC-2622
Renaissance, NCC-2623
Refit - USS
Excelsior, Excelsior-A, NCC-2000
Refit - USS
Kumari, Excelsior-A, NCC-2005
Refit - USS
Kearsage, Constellation-A, NCC-1811
Refit - USS
Vigour , Constellation-A, NCC-1804
Refit - USS
Dryad, Miranda-A, NCC-1631
Refit - USS
Calypso, Miranda-A, NCC-1632
Starfleet Super-Freighter, NCC-3606
Starfleet Freighter, NCC-3607 (Rigel)
Starfleet Freighter, NCC-3608
Starfleet Cargo Ship, NCC-3709
Starfleet Cargo Ship, NCC-3710 (Indoria)
Starfleet Cargo Ship, NCC-3711 (Indoria)
Starfleet Cargo Ship, NCC-3712 (Andor)
Starfleet Cargo Ship, NCC-3713
Starfleet Cargo Ship, NCC-3714
Starfleet Cargo Ship, NCC-3715 (note: voted for but never mentioned in any update, so assuming it's NCC-3715)
Ships Crewed
USS
Opportunity, Excelsior-A, NCC-2026 (Explorer Corps)
USS
Spirit, Excelsior-A, NCC-2025
Renaissance, NCC-2617
Ships Commissioned
USS
Tarrak, Excelsior, NCC-2023
USS
Pleezirra, Excelsior, NCC-2024
USS
Reason, Renaissance, NCC-2602
USS
Dynamo, Miranda-A, NCC-1665
Refit - USS
Sarek, Excelsior-A, NCC-2004
Refit - USS
Sappho, Constellation-A, NCC-1812
Refit - USS
Challorn, Constellation-A, NCC-1809
Refit - USS
Svai, Miranda-A, NCC-1658
Refit - USS
Lion, Miranda-A, NCC-1654
Starfleet Colony Ship, NCC-921
Starfleet Freighter, NCC-3601
Starfleet Freighter, NCC-3602
Resource Stockpile
BR/yr: 965 - 20 + 145 = 1090
SR/yr: 700 - 10 + 105 = 795
PP/yr: 124 - 5 + 25 = 144
RP/yr: 213 - 5 + 25 = 233
BR: 1488 - 1210 + 90 + 1090 = 1458
SR: 873 - 880 + 205 + 795 = 993
PP: 372 - 423 + 365 + 144 = 458
RP: 365 - 362 + 145 + 233 = 381
Personnel Pool
Standard Starfleet:
O/yr: 16.4 - 0.15 + 1.85 = 18.1
E/yr: 20.1 - 0.15 + 2.45 = 22.4
T/yr: 21.2 - 0.15 + 2.2 = 23.25
O: 12.35 - 9 + 0 + 18.1 = 27.85
E: 20.7 - 10 + 0 + 22.4 = 41.2
T: 28 - 8 + 0 + 23.25 = 55.45
Explorer Corps:
O/yr: 3.75 + 0.25 = 4
E/yr: 3.2 + 0.25 = 3.45
T/yr: 2.95 + 0.25 = 3.2
O: 13.75 - 6 + 0 + 4 = 9.5
E: 13.5 - 5 + 0 + 3.45 = 10.15
T: 13.95 - 5 + 0 + 3.2 = 9.1
Details in audit ledger spreadsheet:
ToBoldlyGo Audit Ledger
edit: updated with Q4.M3 CL and Q4 GBZ, Firefly was damaged