lbmaian
a thirsty squirrel
- Location
- USA
@OneirosTheWriter, preliminary 2322 EOY audit:
Note: Incomplete since still awaiting:
Corrections (that are compatible with 2322 player votes):
None
Assumptions:
Starting Resources
2090 Bulk Resources
1347 Special Resources
310 Political Will
624 Research Points
Starting Personnel Pool
Standard Starfleet: 34.65 Officer, 62.03 Enlisted, 73.3 Technician
Explorer Corps: 14.6 Officer, 14.84 Enlisted, 10.9 Technician
Expenditure
1700 Bulk Resources
1430 Special Resources
510 Political Will
543 Research Points
Casualties
Standard Starfleet: 1 Officer, 0 Enlisted, 1 Technician
Explorer Corps: 8 Officer, 9 Enlisted, 9 Technician
Career Casualties
Standard Starfleet: 60 Officer, 70 Enlisted, 62 Technician
Explorer Corps: 15 Officer, 20 Enlisted, 19 Technician
Total Starfleet Ship Losses:
5 Excelsior, 1 Renaissance, 2 Constitution, 2 Constellation, 2 Centaur, 5 Miranda, 1 Oberth, 1 Hospital Ship, 3 Cargo Ship, 1 Runabout
Total Other Allied Non-Auxiliary Ship Losses in Starfleet-led Operations and Incidents:
1 Miranda, 3 Orah, 3 Stinger, 1 Patroller
Ships Lost
USS S'Harien, Excelsior-A, NCC-2008
Ships Damaged
USS Tarrak, Excelsior-A, NCC-2023
USS Svai, Miranda-A, NCC-1658
USS Exeter, Constitution-B, NCC-1748
USS Courageous, Excelsior-A, NCC-2003
Ships Scrapped
None
Ships Laid Down
Ambassador, NCC-3909
Renaissance, NCC-2636
Kepler, NCC-4102
Kepler, NCC-4103
Kepler, NCC-4104
Kepler, NCC-4105
Kepler, NCC-4106
Kepler, NCC-4107
Kepler, NCC-4108
Kepler, NCC-4109
Kepler, NCC-4110
Refit - USS Rru'adorr, Excelsior-A, NCC-2016
Refit - USS Pleezirra, Excelsior-A, NCC-2024
Refit - USS Yukikaze, Centaur-B, NCC-2101
Refit - USS Zephyr, Centaur-B, NCC-2103
Refit - USS Gale, Centaur-B, NCC-2106
Comfort, NCC-3507
Comfort, NCC-3508
Freighter, NCC-3625 (Andorian)
Freighter, NCC-3626
Freighter, NCC-3627
Super-Freighter, NCC-3628
Cargo Ship, NCC-3732 (Human)
Cargo Ship, NCC-3733 (Rigellian)
Cargo Ship, NCC-3734
Cargo Ship, NCC-3735
Cargo Ship, NCC-3736
Cargo Ship, NCC-3737
Cargo Ship, NCC-3738 (Orion)
Cargo Ship, NCC-3739 (Orion)
Passenger Ship, NCC-5201
Colony Ship, NCC-908
Ships Crewed
Renaissance, NCC-2632
Renaissance, NCC-2633
Centaur-B, NCC-2147
Comfort, NCC-3505 (Medical Crew)
Ships Commissioned
USS Enkindle, Renaissance, NCC-2629
USS Zh'Mai, Renaissance, NCC-2630
USS Renewal, Renaissance, NCC-2631
USS Whale, Centaur-B, NCC-2135
USS Fluffy-Puffy, Centaur-B, NCC-2136
USS Sommerfield, Centaur-B, NCC-2137
USS Kepler, Kepler, NCC-4101 (formerly NX-4101)
Refit - USS Avandar, Excelsior-A, NCC-2010
Refit - USS Pathfinder, Excelsior-A, NCC-2021
Refit - USS Winterwind, Centaur-B, NCC-2104
Refit - USS Bull, Centaur-B, NCC-2107
Refit - USS Chinook, Centaur-B, NCC-2130
Refit - USS Sirocco, Centaur-B, NCC-2131
USS Shepherd, Comfort, NCC-3504
Freighter, NCC-3610 (Vulcan)
Freighter, NCC-3611 (Tellarite)
Freighter, NCC-3612 (Human)
Freighter, NCC-3614
Freighter, NCC-3615
Freighter, NCC-3616
Freighter, NCC-3617 (Human)
Cargo Ship, NCC-3725 (Vulcan)
Cargo Ship, NCC-3726 (Betazoid)
Cargo Ship, NCC-3727 (Orion)
Cargo Ship, NCC-3728 (Orion)
Cargo Ship, NCC-3729
SS Rocinante, SFI Civilian Ship, NC-2944
Final Stockpile with Annual Income
BR/yr: 1470 - 25 + 100 = 1545
SR/yr: 1130 - 15 + 130 = 1245
PP/yr: 173 - 5 + 2 = 170
RP/yr: 308 - 0 + 45 = 353
BR: 2090 - 1700 + 187 + 1545 = 2122
SR: 1347 - 1430 + 155 + 1245 = 1317
PP: 310 - 510 + 305 + 170 = 275
RP: 624 - 543 + 394 + 353 = 828
2122 Bulk Resources
1317 Special Resources
275 Political Will
828 Research Points
New Personnel Pool
Standard Starfleet:
O/yr: 23.3 - 0.0 + 0.75 = 24.05
E/yr: 35.12 + (-1.5 + 0.75) * 1.05 = 34.34
T/yr: 27.65 - 0.0 + 2.25 = 29.9
O: 34.65 - 14.0 + 0.0 + 24.05 = 44.7
E: 62.03 - 17.0 + 0.0 + 34.34 = 79.37
T: 73.3 - 14.0 + 0.0 + 29.9 = 89.2
Explorer Corps:
O(EC)/yr: 6.1 - 0.3 + 0.1 = 5.9
E(EC)/yr: 6.27 + (-0.0 + 0.0) * 1.1 = 6.27
T(EC)/yr: 4.7 - 0.0 + 0.3 = 5.0
O(EC): 14.6 - 2.0 + 6.0 + 5.9 = 24.5
E(EC): 14.84 - 4.0 + 5.0 + 6.27 = 22.11
T(EC): 10.9 - 4.0 + 5.0 + 5.0 = 16.9
Standard Starfleet: 44.7 Officer, 79.37 Enlisted, 89.2 Technician
Explorer Corps: 24.5 Officer, 22.11 Enlisted, 16.9 Technician
Relations
Current Federation Full Members:
Humans
Vulcans
Andorians
Tellarites
Amarki
Betazoids
Caitians
Rigellians
Apiata
Indorians
Gaeni
Orions
Caldonians
Seyek
Qloathi
Fiiral
Risans
Pending Ratification:
Honiani (includes Obar and Yan-Ros)
-[Multispecies Polity: 300/300]
-[Too Faithful for your Federation: 300/300]
Ked Paddah
Current Federation Affiliates:
Tauni: 500/500
-[Obsolete Technology: 100/100]
-[Unreliable Ally: 130/100]
-[Fool me once...: 26/500]
Kadeshi: 499/500
-[Missing In Action: N/A]
-[On A Journey Across The Galaxy: N/A]
Laio: 474/500
-[Obsolete Technology: 100/100]
Ashidi: 300/300
-[Cardassian Threat: 221/300]
-[Too Good To Be True: 60/500]
Yrillians: 300/300
-[Cardassian Influence: 100/100]
-[Bigfoot is a Communist Pirate: 256/300]
-[Anarchy at all levels: 0/500]
Sydraxians: 267/300
-[Ashalla Pact: N/A]
-[Recently in a Shooting War: 100/100]
-[Society and Government In Flux: 0/500]
Bajoran Diaspora: 196/300
-[Cardassian Agitators: 100/100]
-[Suspicious of Outsiders: 0/300]
-[Caste System: 0/500]
-[Rule by Vedek: 0/500]
Vermillions: 205/300
-[Obsolete Technology: 0/300]
Muuyozoi (Outer Space Alliance): 165/300
-[Corps are lying to us: 0/100]
-[Horizon Influence: 222/300]
-[Disunified Homeworld 200/500]
Currently Known Other Possible Members:
Gretarians: 100/100
-[Sydraxian Client: N/A]
-[Need some space right now: 63/100]
-[You are all Crazed Militarists!: 0/500]
Chrystovians: 100/100
-[Distant Stars: 5/100]
-[Cardassian Neighbours: 15/300]
Licori (Arcadian Empire): 100/100
-[Recently in a Shooting War: 100/100]
-[Romulan Influence: 80/100]
-[Horizon Influence: 102/300]
-[Uncontrolled Mentats: 0/300]
-[Slavery: 20/500]
-[Unequal Feudal Society: 15/500]
Shanpurr: 90/100
-[Interfering with Pre-Warp Societies: 0/500]
Hishmeri: 69/100
-[Eternal Empire Influence: 0/100]
-[Raiding the Federation: 155/100]
-[Slavery I: 0/100]
-[Slavery II: 0/100]
-[Slavery III: 0/100]
-[Slavery IV: 0/100]
-[Nomadic Raiders I: 0/300]
-[Nomadic Raiders II: 0/300]
Ittick-Ka: 99/100
-[Distant Stars: 0/100]
-[Slavery I: 0/100]
-[Slavery II: 0/100]
-[Slavery III: 0/100]
-[Slavery IV: 0/100]
-[Slavery V: 0/100]
-[Great Power Ambitions: 0/300]
-[Authoritarian Hivestate: 0/500]
Daw: 75/100
-[Ittick-Ka Vassals: N/A]
Sotaw: 60/100
-[Romulan Influence: 0/100]
-[Located in the Neutral Zone: 0/300]
Lamarckians: 100/100
-[Limited Stellar Presence: 36/100]
-[Obsolete Technology: 0/100]
-[Limited Stellar Ability: 0/300]
-[Unequal Distribution of Wealth: 0/300]
-[No Unified Government: 10/500]
Bolians: 100/100
-[Isolationist Government: 12/100]
Breen: 28/100
-[Isolationist: 0/100]
-[Militarily aggressive: 0/300]
-[Intensely Suspicious: 0/300]
-[Intensely Xenophobic: 0/500]
Gorn: 66/100
-[Distant Stars: 0/100]
-[The Ancient Enemy (Orions): 0/100]
-[Great Power Ambitions: 75/300]
-[Autocratic Monarchy: 0/500]
Talarians: 108/100
-[Under Padani Supervision: N/A]
Felis: 88/100
-[Horizon Influence: 94/300]
-[Inclined towards Independence: 0/300]
-[Weak Central Government: 0/300]
-[Systematic Wealth Inequality: 0/500]
Yizgisi (Azsi Popular Democratic Mandate): 100/100
-[Continent of Goo: 100/100]
-[Stellar Shock: 44/100]
-[Close Call: 0/100]
-[No warp tech: 0/300]
-[Obsolete Technology: 0/300]
Trills: 100/100
-[Aloof: 75/100]
-[They don't trust us: 0/300]
-[Discourage Attacks on the Trill: 201/300]
Unbound Gaeni: 40/100
-[Distant Stars: 0/100]
-[Slavery I: 0/100]
-[Slavery II: 0/100]
-[Slavery III: 0/100]
-[Slavery IV: 0/100]
-[Slavery V: 0/100]
-[Fractured Government: 0/300]
-[Clone Space Pirates: 0/300]
-[Survival of the Fittest: 0/500]
Dreamers: 100/100
-[Cosmozoan Lifeform: 20/100]
-[Alien Modes of Communication and Thought: 0/300]
Ur'razzi: 22/100
-[Off to a Bad Start: 0/100]
-[Aggressive: 0/100]
-[Obsolete Technology: 0/300]
Dawiar (Great Kingdom of Kharhazad): 100/100
-[Ashalla Pact: 130/300]
-[Gorn Alliance: N/A]
-[Sour about Caitian Conflict: 1/100]
-[End of Ambition: 0/300]
-[Feudal Monarchy: 0/500]
Dylaarians: 60/100
-[Ashalla Pact: N/A]
Goshawnar: 0/100
-[Ashalla Pact: N/A]
Imelak: 0/100
-[Ashalla Pact: N/A]
Konen: 0/100
-[Ashalla Pact: N/A]
Lecarrens: -30/100
-[Ashalla Pact: N/A]
-[We can't trust you: 0/100]
-[You don't trust anyone: 0/500]
Non-Diplomacy Tags:
-[Explore the Adrazzi Gulf: 185/430]
Details in audit ledger spreadsheet: ToBoldlyGo Audit Ledger
(Note: The diplo relations part of the main sheet ledger still hasn't been updated to account for the new tag system, so ignore its EOY values. I'm currently manually updating the relation values in the 'report template' sheet.)
Note: Incomplete since still awaiting:
Q4 Rat Race, if any surprises there(edit: done)any other surprises(edit: nope)
Corrections (that are compatible with 2322 player votes):
None
Assumptions:
- Starting off with previous year's EOY (where there are inconsistencies there, using the more detailed info as official source).
- Per historical precedent, member ratifications replace the tech-based affiliation crew income (was 0.15 O/E/T until after 2320.Q3, when it increased to 0.2 O/E/T) rather than the alliance bonus crew income, even if the ratification crew income change text is ambiguous on the matter.
- Per historical precedent, new affiliation/alliance/membership income bonuses apply immediately (i.e. applies to the current year's annual income at EOY).
- Ships under repair and/or refit are (re-)crewed upon start of repair/refit. (If refits took longer than a year, changes in crew would presumably manifest exactly one year before relaunch, just like the one year crewing before commissioning of new ships that take at least a year to build.)
- Michel Thuir's 5% enlisted & 10% EC enlisted bonuses can result in enlisted numbers beyond 2 decimal places. For the sake of not having to retain this precision, EOY enlisted are always rounded to 2 decimal places, and all future changes start from that rounded value.
- However, annual income is always recalculated from its base components, and thus, in contrast, all future changes start from the full precision EOY values. Note that although the annual income results do appear rounded, it is added unrounded to the EOY totals, after which those EOY totals are rounded.
- Task force attachment annual upkeep cost is applied right after every Q1 deployment vote at least 4 quarters after assignment of the attachment. This also means that the annual upkeep cost of the 2319.Q3-assigned attachments will apply right after the 2321.Q1 deployment vote (and not in 2320.Q1 or 2320.Q3) that are still voted to be assigned then.
I originally planned to just add attachment annual upkeep cost to next year's (2320) EOY, but the advent of the new annual Q1 deployment vote in 2320 throws a wrench in that plan, because the annual upkeep cost of attachments & requisitioned member fleet ships in 2320.Q1 is applied at either:
- 2320 EOY, which is problematic because the just-following 2321.Q1 deployment vote could change such attachments & requisitioning; or
- 2321 EOY, which is problematic because that's effectively two years after 2320.Q1.
So it would be better to apply the annual upkeep cost of continuing attachments and requisitioned member fleet ships every Q1 deployment vote.
However, the first attachments were assigned in 2319.Q3, thus I can either apply the annual upkeep cost in:
- 2320.Q1, which is simple, but this would be somewhat unfair, and in any case, be too late to change for the 2320.Q2 snakepit;
- 2320.Q3, exactly 4 quarters later, which is the most technically correct, but this requires more bookkeeping to track annually (and thus more error-prone) if these particular attachments continue to see consecutive use year-after-year; or
- 2321.Q1, which is the simplest and compatible option, but this gives 2 "free" quarters for these particular attachments.
I eventually decided on option 3 for the 2319.Q3 attachments, since it's simple, and it's not like we already have such timing simplifications in the form of EOY income (where most annual income is applied at EOY, rather than exactly every 4 quarters after initiation), which was my original plan anyway.- Moving attachments between task forces does not incur any additional costs.
- The stuff above about attachments also applies to member fleet ship requisitioning (annual upkeep cost is half the initial cost).
- Ex Astris, Scientia RP expenses are rounded to nearest integer.
- Diplomacy with the new tag system:
- General diplo points are directed toward the lowest diplomacy "blockers", an unfilled main diplo level (e.g. affiliate at 100) or diplomacy tag (e.g. Unreliably Ally at 100), then spilling over to the next highest blocker(s). The order of the blockers is determined by: main diplo level (e.g. affiliate at 100) or diplomacy tag max (primarily), main diplo level over diplomacy tag (e.g. fill main diplo to 100 first before working on any unfilled 100-level diplo tags), then tag text order (tertiary).
- Examples:
- A general +50 to {Tauni: 440/500, [Unreliable Ally: 60/100]}, where the "/500" indicates currently alliance and heading toward member candidate, results in {Tauni: 450/500, [Unreliable Ally: 100/100]}. The order of "blockers" is: Unreliable Ally (100 tag), Candidate (500), Fool me once... (500 tag), Member
- A general +50 to {Chrystovians: 100/100, [Distant Stars: 5/100]}, where the "/100" indicates non-affiliate and heading towards affiliate, results in {Chrystovians: 100/100, [Distant Stars: 60/100]}. The order of blockers is: Distant Stars (100 tag), Alliance (300), Cardassian Neighbors (300 tag), Candidate (500), Member
- Negative general diplo points do not have a "reverse spillover" behavior - they only affect the main diplo points, potentially reducing the main diplo level (e.g. from affiliate to non-affiliate). For example, a general -25 to {Sydraxians: 124/300,
[Recently in a Shooting War: 100/100]} results in {Sydraxians: 99/100,[Recently in a Shooting War: 100/100]}, whereby the Sydraxians would no longer be affiliates. - The presence of any N/A diplo tags that aren't strike-throughed has two effects:
- Diplo pushes can't be voted for the polity in the snakepit. That doesn't exclude diplo events from happening though (as has happened at times for Gretarians back when they were Sydraxian clients).
- Spillover logic remains the same, but the current diplo level can't increase. This does allow for main diplo points to increase above the current diplo maximum, e.g. 105/100 would be possible. For example, {Dawiar: 100/100, [Ashalla Pact: N/A]} and {Dylaarians: 60/100, [Ashalla Pact: N/A]} are stuck with the "/100" non-affiliate diplo level, but their main diplo points can go above 100 (resulting in relations like 105/100) and progress towards tags can still be made.
- Exceptions can be made for the above. For example, Kadeshi have reached Alliance (>=300) status, yet technically should have had the N/A tags since their expedition while in Affiliate (>=100) status.
- "Targeted" diplo points directed toward diplo tags go only to that diplo tag with no spillover. A diplo tag's points can go negative. It can also technically go above its blocker level, but as there is no spillover and a diplo tag is "done" once its points does reach its blocker level, it has no practical effect.
- Ship name prefixes:
- Names of Federation (not just Starfleet) cargo ships and freighters and other auxiliary ships have sometimes had the "SS" prefix (more prominent in Captain's Logs), while at other times, they've had the prefix of the owner fleet, e.g. "USS" (more prominent in the GBZ updates, used for hospital ships in Captain's Logs). Memory-alpha also shows the prefix isn't completely insistent, but it does suggest that "freighters and transports were given SS prefixes" and includes some survey ships and Oberths. So I've decided to prefix all auxiliary ships, excluding hospital ships, with "SS" instead of "USS" (or the owner fleet prefix).
- Names of Federation (or at least Starfleet) runabouts are prefixed with "USS" and have NCC registries, as suggested by memory-alpha for the future Danube-class runabouts. Since they're probably like small-yet-still-warp-capable civilian ships, I'm listing them if they do show up (as lost, built, etc.).
Starting Resources
2090 Bulk Resources
1347 Special Resources
310 Political Will
624 Research Points
Starting Personnel Pool
Standard Starfleet: 34.65 Officer, 62.03 Enlisted, 73.3 Technician
Explorer Corps: 14.6 Officer, 14.84 Enlisted, 10.9 Technician
Expenditure
1700 Bulk Resources
1430 Special Resources
510 Political Will
543 Research Points
Casualties
Standard Starfleet: 1 Officer, 0 Enlisted, 1 Technician
Explorer Corps: 8 Officer, 9 Enlisted, 9 Technician
Total: 0 Officer, 0 Enlisted, 0 Technician
Career Casualties
Standard Starfleet: 60 Officer, 70 Enlisted, 62 Technician
Explorer Corps: 15 Officer, 20 Enlisted, 19 Technician
Human: 4 Officer, 3 Enlisted, 1 Technician
Andorian: 0 Officer, 2 Enlisted, 1 Technician
Tellarite: 1 Officer, 0 Enlisted, 0 Technician
Amarki: 0 Officer, 1 Enlisted, 2 Technician
Apiata: 0 Officer, 3 Enlisted, 3 Technician
Rigellian: 0 Officer, 1 Enlisted, 1 Technician
Orion: 1 Officer, 1 Enlisted, 1 Technician
Ked Paddah: 3 Officer, 10 Enlisted, 10 Technician
Tauni: 1 Officer, 2 Enlisted, 1 Technician
Total: 10 Officer, 23 Enlisted, 20 Technician
Andorian: 0 Officer, 2 Enlisted, 1 Technician
Tellarite: 1 Officer, 0 Enlisted, 0 Technician
Amarki: 0 Officer, 1 Enlisted, 2 Technician
Apiata: 0 Officer, 3 Enlisted, 3 Technician
Rigellian: 0 Officer, 1 Enlisted, 1 Technician
Orion: 1 Officer, 1 Enlisted, 1 Technician
Ked Paddah: 3 Officer, 10 Enlisted, 10 Technician
Tauni: 1 Officer, 2 Enlisted, 1 Technician
Total: 10 Officer, 23 Enlisted, 20 Technician
Total Starfleet Ship Losses:
5 Excelsior, 1 Renaissance, 2 Constitution, 2 Constellation, 2 Centaur, 5 Miranda, 1 Oberth, 1 Hospital Ship, 3 Cargo Ship, 1 Runabout
USS Miracht, Miranda, NCC-1629 @ 2303.Q4
USS Faithful, Miranda, NCC-1630 @ 2304.Q1
USS Centaur, Centaur, NCC-2102 @ 2304.Q1
USS Polaris, Constellation, NCC-1813 @ 2308.Q1
USS Comfort, Hospital Ship, NCC-748 @ 2309.Q3
USS Lion, Miranda, NCC-1654 @ 2311.Q3 - presumed lost until recovered in 2315.Q1
USS Miracht, Excelsior, NCC-2006 @ 2311.Q4
USS Thunderhead, Miranda, NCC-1656 @ 2315.Q1
USS Blizzard, Centaur-A, NCC-2108 @ 2315.Q1
USS Suvek, Oberth, NCC-1508 @ 2315.Q1
USS Enterprise, Excelsior, NCC-1701-B @ 2315.Q2
USS Republic, Constitution-B, NCC-1743 @ 2318.Q1
SS Sturdy, Cargo Ship, NCC-37?? @ 2318.Q2
SS Scallop, Cargo Ship, NCC-37?? @ 2318.Q2
USS Excelsior, Excelsior-A, NCC-2000 @ 2318.Q3
USS Bantam, Miranda-A, NCC-1663 @ 2318.Q3
USS Huascar, Constitution-B, NCC-1752 @ 2318.Q3
USS Renaissance, Renaissance, NCC-2601 @ 2318.Q3
USS Fidelity, Miranda-A, NCC-1634 @ 2318.Q3
USS Sappho, Constellation-A, NCC-1812 @ 2319.Q2
USS Kumari, Excelsior-A, NCC-2005 @ 2320.Q2
USS Quicksilver, Runabout, NCC-???? @ 2320.Q3
SS Robert Wesley, Cargo Ship, NCC-3707 @ 2320.Q3
USS S'Harien, Excelsior-A, NCC-2008 @ 2322.Q4
USS Faithful, Miranda, NCC-1630 @ 2304.Q1
USS Centaur, Centaur, NCC-2102 @ 2304.Q1
USS Polaris, Constellation, NCC-1813 @ 2308.Q1
USS Comfort, Hospital Ship, NCC-748 @ 2309.Q3
USS Lion, Miranda, NCC-1654 @ 2311.Q3 - presumed lost until recovered in 2315.Q1
USS Miracht, Excelsior, NCC-2006 @ 2311.Q4
USS Thunderhead, Miranda, NCC-1656 @ 2315.Q1
USS Blizzard, Centaur-A, NCC-2108 @ 2315.Q1
USS Suvek, Oberth, NCC-1508 @ 2315.Q1
USS Enterprise, Excelsior, NCC-1701-B @ 2315.Q2
USS Republic, Constitution-B, NCC-1743 @ 2318.Q1
SS Sturdy, Cargo Ship, NCC-37?? @ 2318.Q2
SS Scallop, Cargo Ship, NCC-37?? @ 2318.Q2
USS Excelsior, Excelsior-A, NCC-2000 @ 2318.Q3
USS Bantam, Miranda-A, NCC-1663 @ 2318.Q3
USS Huascar, Constitution-B, NCC-1752 @ 2318.Q3
USS Renaissance, Renaissance, NCC-2601 @ 2318.Q3
USS Fidelity, Miranda-A, NCC-1634 @ 2318.Q3
USS Sappho, Constellation-A, NCC-1812 @ 2319.Q2
USS Kumari, Excelsior-A, NCC-2005 @ 2320.Q2
USS Quicksilver, Runabout, NCC-???? @ 2320.Q3
SS Robert Wesley, Cargo Ship, NCC-3707 @ 2320.Q3
USS S'Harien, Excelsior-A, NCC-2008 @ 2322.Q4
Total Other Allied Non-Auxiliary Ship Losses in Starfleet-led Operations and Incidents:
1 Miranda, 3 Orah, 3 Stinger, 1 Patroller
UES Shanghai, Miranda-A, NCC-1904 @ 2315.Q1
KPS Guarded, Orah @ 2315.Q1
KPS Wary, Orah @ 2315.Q1
KPS Thoughtful, Orah @ 2315.Q1
Unknown Stinger, NCC-32?? @ 2318.Q3
Gerzzi, Stinger, NCC-3202 @ 2318.Q3
Triada, Stinger, NCC-3201 @ 2318.Q3
SGC Oethyeus, Patroller-A, NCC-251? @ 2320.Q2
KPS Guarded, Orah @ 2315.Q1
KPS Wary, Orah @ 2315.Q1
KPS Thoughtful, Orah @ 2315.Q1
Unknown Stinger, NCC-32?? @ 2318.Q3
Gerzzi, Stinger, NCC-3202 @ 2318.Q3
Triada, Stinger, NCC-3201 @ 2318.Q3
SGC Oethyeus, Patroller-A, NCC-251? @ 2320.Q2
Ships Lost
USS S'Harien, Excelsior-A, NCC-2008
Ships Damaged
USS Tarrak, Excelsior-A, NCC-2023
USS Svai, Miranda-A, NCC-1658
USS Exeter, Constitution-B, NCC-1748
USS Courageous, Excelsior-A, NCC-2003
Ships Scrapped
None
Ships Laid Down
Ambassador, NCC-3909
Renaissance, NCC-2636
Kepler, NCC-4102
Kepler, NCC-4103
Kepler, NCC-4104
Kepler, NCC-4105
Kepler, NCC-4106
Kepler, NCC-4107
Kepler, NCC-4108
Kepler, NCC-4109
Kepler, NCC-4110
Refit - USS Rru'adorr, Excelsior-A, NCC-2016
Refit - USS Pleezirra, Excelsior-A, NCC-2024
Refit - USS Yukikaze, Centaur-B, NCC-2101
Refit - USS Zephyr, Centaur-B, NCC-2103
Refit - USS Gale, Centaur-B, NCC-2106
Comfort, NCC-3507
Comfort, NCC-3508
Freighter, NCC-3625 (Andorian)
Freighter, NCC-3626
Freighter, NCC-3627
Super-Freighter, NCC-3628
Cargo Ship, NCC-3732 (Human)
Cargo Ship, NCC-3733 (Rigellian)
Cargo Ship, NCC-3734
Cargo Ship, NCC-3735
Cargo Ship, NCC-3736
Cargo Ship, NCC-3737
Cargo Ship, NCC-3738 (Orion)
Cargo Ship, NCC-3739 (Orion)
Passenger Ship, NCC-5201
Colony Ship, NCC-908
Ships Crewed
Renaissance, NCC-2632
Renaissance, NCC-2633
Centaur-B, NCC-2147
Comfort, NCC-3505 (Medical Crew)
Ships Commissioned
USS Enkindle, Renaissance, NCC-2629
USS Zh'Mai, Renaissance, NCC-2630
USS Renewal, Renaissance, NCC-2631
USS Whale, Centaur-B, NCC-2135
USS Fluffy-Puffy, Centaur-B, NCC-2136
USS Sommerfield, Centaur-B, NCC-2137
USS Kepler, Kepler, NCC-4101 (formerly NX-4101)
Refit - USS Avandar, Excelsior-A, NCC-2010
Refit - USS Pathfinder, Excelsior-A, NCC-2021
Refit - USS Winterwind, Centaur-B, NCC-2104
Refit - USS Bull, Centaur-B, NCC-2107
Refit - USS Chinook, Centaur-B, NCC-2130
Refit - USS Sirocco, Centaur-B, NCC-2131
USS Shepherd, Comfort, NCC-3504
Freighter, NCC-3610 (Vulcan)
Freighter, NCC-3611 (Tellarite)
Freighter, NCC-3612 (Human)
Freighter, NCC-3614
Freighter, NCC-3615
Freighter, NCC-3616
Freighter, NCC-3617 (Human)
Cargo Ship, NCC-3725 (Vulcan)
Cargo Ship, NCC-3726 (Betazoid)
Cargo Ship, NCC-3727 (Orion)
Cargo Ship, NCC-3728 (Orion)
Cargo Ship, NCC-3729
SS Rocinante, SFI Civilian Ship, NC-2944
Final Stockpile with Annual Income
BR/yr: 1470 - 25 + 100 = 1545
SR/yr: 1130 - 15 + 130 = 1245
PP/yr: 173 - 5 + 2 = 170
RP/yr: 308 - 0 + 45 = 353
BR: 2090 - 1700 + 187 + 1545 = 2122
SR: 1347 - 1430 + 155 + 1245 = 1317
PP: 310 - 510 + 305 + 170 = 275
RP: 624 - 543 + 394 + 353 = 828
2122 Bulk Resources
1317 Special Resources
275 Political Will
828 Research Points
New Personnel Pool
Standard Starfleet:
O/yr: 23.3 - 0.0 + 0.75 = 24.05
E/yr: 35.12 + (-1.5 + 0.75) * 1.05 = 34.34
T/yr: 27.65 - 0.0 + 2.25 = 29.9
O: 34.65 - 14.0 + 0.0 + 24.05 = 44.7
E: 62.03 - 17.0 + 0.0 + 34.34 = 79.37
T: 73.3 - 14.0 + 0.0 + 29.9 = 89.2
Explorer Corps:
O(EC)/yr: 6.1 - 0.3 + 0.1 = 5.9
E(EC)/yr: 6.27 + (-0.0 + 0.0) * 1.1 = 6.27
T(EC)/yr: 4.7 - 0.0 + 0.3 = 5.0
O(EC): 14.6 - 2.0 + 6.0 + 5.9 = 24.5
E(EC): 14.84 - 4.0 + 5.0 + 6.27 = 22.11
T(EC): 10.9 - 4.0 + 5.0 + 5.0 = 16.9
Standard Starfleet: 44.7 Officer, 79.37 Enlisted, 89.2 Technician
Explorer Corps: 24.5 Officer, 22.11 Enlisted, 16.9 Technician
Relations
Current Federation Full Members:
Humans
Vulcans
Andorians
Tellarites
Amarki
Betazoids
Caitians
Rigellians
Apiata
Indorians
Gaeni
Orions
Caldonians
Seyek
Qloathi
Fiiral
Risans
Pending Ratification:
Honiani (includes Obar and Yan-Ros)
-[Too Faithful for your Federation: 300/300]
Ked Paddah
Current Federation Affiliates:
Tauni: 500/500
-[Unreliable Ally: 130/100]
-[Fool me once...: 26/500]
Kadeshi: 499/500
-[Missing In Action: N/A]
-[On A Journey Across The Galaxy: N/A]
Laio: 474/500
Ashidi: 300/300
-[Cardassian Threat: 221/300]
-[Too Good To Be True: 60/500]
Yrillians: 300/300
-[Bigfoot is a Communist Pirate: 256/300]
-[Anarchy at all levels: 0/500]
Sydraxians: 267/300
-[Recently in a Shooting War: 100/100]
-[Society and Government In Flux: 0/500]
Bajoran Diaspora: 196/300
-[Suspicious of Outsiders: 0/300]
-[Caste System: 0/500]
-[Rule by Vedek: 0/500]
Vermillions: 205/300
-[Obsolete Technology: 0/300]
Muuyozoi (Outer Space Alliance): 165/300
-[Corps are lying to us: 0/100]
-[Horizon Influence: 222/300]
-[Disunified Homeworld 200/500]
Currently Known Other Possible Members:
Gretarians: 100/100
-[Need some space right now: 63/100]
-[You are all Crazed Militarists!: 0/500]
Chrystovians: 100/100
-[Distant Stars: 5/100]
-[Cardassian Neighbours: 15/300]
Licori (Arcadian Empire): 100/100
-[Romulan Influence: 80/100]
-[Horizon Influence: 102/300]
-[Slavery: 20/500]
-[Unequal Feudal Society: 15/500]
Shanpurr: 90/100
-[Interfering with Pre-Warp Societies: 0/500]
Hishmeri: 69/100
-[Raiding the Federation: 155/100]
-[Slavery I: 0/100]
-[Slavery II: 0/100]
-[Slavery III: 0/100]
-[Slavery IV: 0/100]
-[Nomadic Raiders I: 0/300]
-[Nomadic Raiders II: 0/300]
Ittick-Ka: 99/100
-[Distant Stars: 0/100]
-[Slavery I: 0/100]
-[Slavery II: 0/100]
-[Slavery III: 0/100]
-[Slavery IV: 0/100]
-[Slavery V: 0/100]
-[Great Power Ambitions: 0/300]
-[Authoritarian Hivestate: 0/500]
Daw: 75/100
-[Ittick-Ka Vassals: N/A]
Sotaw: 60/100
-[Romulan Influence: 0/100]
-[Located in the Neutral Zone: 0/300]
Lamarckians: 100/100
-[Limited Stellar Presence: 36/100]
-[Obsolete Technology: 0/100]
-[Limited Stellar Ability: 0/300]
-[Unequal Distribution of Wealth: 0/300]
-[No Unified Government: 10/500]
Bolians: 100/100
-[Isolationist Government: 12/100]
Breen: 28/100
-[Isolationist: 0/100]
-[Militarily aggressive: 0/300]
-[Intensely Suspicious: 0/300]
-[Intensely Xenophobic: 0/500]
Gorn: 66/100
-[Distant Stars: 0/100]
-[The Ancient Enemy (Orions): 0/100]
-[Great Power Ambitions: 75/300]
-[Autocratic Monarchy: 0/500]
Talarians: 108/100
-[Under Padani Supervision: N/A]
Felis: 88/100
-[Horizon Influence: 94/300]
-[Inclined towards Independence: 0/300]
-[Weak Central Government: 0/300]
-[Systematic Wealth Inequality: 0/500]
Yizgisi (Azsi Popular Democratic Mandate): 100/100
-[Stellar Shock: 44/100]
-[Close Call: 0/100]
-[No warp tech: 0/300]
-[Obsolete Technology: 0/300]
Trills: 100/100
-[Aloof: 75/100]
-[They don't trust us: 0/300]
-[Discourage Attacks on the Trill: 201/300]
Unbound Gaeni: 40/100
-[Distant Stars: 0/100]
-[Slavery I: 0/100]
-[Slavery II: 0/100]
-[Slavery III: 0/100]
-[Slavery IV: 0/100]
-[Slavery V: 0/100]
-[Fractured Government: 0/300]
-[Clone Space Pirates: 0/300]
-[Survival of the Fittest: 0/500]
Dreamers: 100/100
-[Cosmozoan Lifeform: 20/100]
-[Alien Modes of Communication and Thought: 0/300]
Ur'razzi: 22/100
-[Off to a Bad Start: 0/100]
-[Aggressive: 0/100]
-[Obsolete Technology: 0/300]
Dawiar (Great Kingdom of Kharhazad): 100/100
-[Gorn Alliance: N/A]
-[Sour about Caitian Conflict: 1/100]
-[End of Ambition: 0/300]
-[Feudal Monarchy: 0/500]
Dylaarians: 60/100
-[Ashalla Pact: N/A]
Goshawnar: 0/100
-[Ashalla Pact: N/A]
Imelak: 0/100
-[Ashalla Pact: N/A]
Konen: 0/100
-[Ashalla Pact: N/A]
Lecarrens: -30/100
-[Ashalla Pact: N/A]
-[We can't trust you: 0/100]
-[You don't trust anyone: 0/500]
Non-Diplomacy Tags:
-[Explore the Adrazzi Gulf: 185/430]
Details in audit ledger spreadsheet: ToBoldlyGo Audit Ledger
(Note: The diplo relations part of the main sheet ledger still hasn't been updated to account for the new tag system, so ignore its EOY values. I'm currently manually updating the relation values in the 'report template' sheet.)
Last edited: