That's... concerning. As far I knew your spreadsheet with last-minute income fixes (41 Miele IV mining colony completion) should've matched with my audit spreadsheet, and it seems it was off by 80sr. I'm now paranoid I got something wrong...

I can tell you that I updated my spreadsheet with values on the "Actual" worksheet that match both the EOY post and your audit, so all numbers are correct as of 2317.Q1.
 
I can tell you that I updated my spreadsheet with values on the "Actual" worksheet that match both the EOY post and your audit, so all numbers are correct as of 2317.Q1.

I found the problem, and fortunately it's not in the audit spreadsheet or EOY:

Your shipbuild planning spreadsheet has a calculation bug with the Excelsior cost infusion option. It's treating it as giving us 230br 230sr, rather than 230br 150sr. Which leads to the discrepancy of 80sr.

Another bug although far less important: Your calculation of total # of "Super-Mirandas" is referencing the wrong row so it's ignoring non-prototype Super-Mirandas. It needs to reference Calcs2!<col>68, not Calcs2!<col>69.



Anyway, that does indeed mean that the "bring Rennie build a year earlier, delay E-A refit a quarter" build plan won't work :(
 
Last edited:
Yeah well, there are a lot of Scotsmen. Not all of them are Montgomery Scott, former chief engineer, USS Enterprise.

Which is a damned shame. Imagine a Starfleet Corps of Engineers full of nothing but Scotty as far as the eye can see.

Couldn't have said it better myself.

Oh wait, yes I can!




Don't. Break. The. Timeline!

... what on Earth? Who are these strange Nazis and where is Hitler's grave? We need to hook him up to a generator to make good use of all that spinning he's doing!
 
So we'd get something like...

USS Whomever, Captain's Log, Stardate, Pick a number
Mapped a star today. Nothing interesting happened at all.
Personal Log, Stardate, Pick a number.1
Well, at least I keep my hair. That's nice.
+5RP, Don't break the timeline. Yet at least.
That is basically exactly right. When you think about it, we've already seen at least one such log: the report from USS Docana's time adventure! There were censor bars in the captain's log, in the log sent to Starfleet Command itself. Who put those censor bars in there? Who are these secrets being kept from? The answer: put there by Temporal Affairs (as alluded to in yet another captain's log that comments on how Temporal Affairs censors the hell out of things)... And they're being kept from Admiral Sousa herself. Probably because giving such a prominent decision-maker knowledge of the actual events surrounding the time anomaly would be likely to cause some sort of temporal problem.

[In other words, @OneirosTheWriter is correct]

Couldn't have said it better myself.

Oh wait, yes I can!



Don't. Break. The. Timeline!
I'm not arguing for 'no time travel.' I'm arguing that it's a bad idea to use time travel to give the Commander of Starfleet access to special information about the future. Much safer to keep that information in the hands of a bunch of low-level functionaries with no direct power to affect anything but whatever is necessary to preserve the timeline.

Said low-level functionaries should, JUST HAPPEN to be in a cross-temporal IRC connection with the distant future Federation's "Temporal Integrity Commission" or whatever so they can ask stuff like "so, uh, should we let Captain Kirk go back to the 1980s and save the whales?" Or so said far future Federation can quietly drop messages to them like "get your dudes together to hush up the Docana incident" and then our Temporal Affairs people ask "what's the Docana incident," and the far future Federation replies "we'll tell you when you're older."
 
Last edited:
Inserted tally
Adhoc vote count started by UbeOne on Jul 12, 2017 at 7:46 AM, finished with 197 posts and 29 votes.
 
I found the problem, and fortunately it's not in the audit spreadsheet or EOY:

Your shipbuild planning spreadsheet has a calculation bug with the Excelsior cost infusion option. It's treating it as giving us 230br 230sr, rather than 230br 150sr. Which leads to the discrepancy of 80sr.

Another bug although far less important: Your calculation of total # of "Super-Mirandas" is referencing the wrong row so it's ignoring non-prototype Super-Mirandas. It needs to reference Calcs2!<col>68, not Calcs2!<col>69.

Thanks for catching those! Corrected.
 
I'm still trying to figure out how advantage is gained in the vanguard phase. One thing to note is that there are no gradual updates on the fleet positioning values calculated for next phase so far like there are during the skirmish phase, so it might be based on a single calculation at the end of the phase. Here are some stats on all battles after we started to get numbers for fleet positioning value (the first line is how advantage changed from the start of the vanguard phase to the start of the main battle), does anyone spot anything promising?

Clash near Gammon
Had no skirmish or vanguard phases, straight from scouting to main battle, and the main battle used the fleet positioning values derived from scouting that would normally be used during the skirmish phase.



Battle of Gammon (C)
Note: Gaeni used Federation doctrines.

advantage 1.2 : 0.8 -> 1.4 : 1
Fired (vanguard phase): 16 : 2
Hits (vanguard phase): 16 : 1
Damage (vanguard phase): 26.76 : 2.03
Fired (skirmish + vanguard phase): 35 : 10
Hits (skirmish + vanguard phase): 34 : 7
Damage (skirmish + vanguard phase): 49.75 : 15.07


Battle of Gammon (A/B)

advantage 0.8 : 1.2 -> 1 : 1.25
Fired (vanguard phase): 21 : 33
Hits (vanguard phase): 17 : 29
Damage (vanguard phase): 42.49 : 75.85
Fired (skirmish + vanguard phase): 71(47*) : 64(49*)
Hits (skirmish + vanguard phase): 41(28*) : 49 (41*)
Damage (skirmish + vanguard phase): 73.15(67.63*) : 95.04 (87.11*)

*Inspire and Od-Gach-3 withdrew at the start of the vanguard phase, so stats might not be included (or only partially included, or only included for one side) in the calculation at the end of the phase.


Battle of Ixaria Approach

advantage 1.035 : 0.965 -> 1 : 1.15
Fired (vanguard phase): 12 : 26
Hits (vanguard phase): 8 : 18
Damage (vanguard phase): 39.54 : 41.52
Fired (skirmish + vanguard phase): 37 : 58
Hits (skirmish + vanguard phase): 21 : 32
Damage (skirmish + vanguard phase): 53.64 : 57.24


Battle of Ixaria Orbit

advantage 1.2 : 0.3 -> 1.4 : 1
Fired (vanguard phase): 1 : 0
Hits (vanguard phase): 1 : 0
Damage (vanguard phase): 3.48 : 0
Fired (skirmish + vanguard phase): 17 : 3
Hits (skirmish + vanguard phase): 7 : 1
Damage (skirmish + vanguard phase): 11.37 : 0.47
 
2317.Q1 - MWCO Report
2317.Q1

[X][BEE] Intazzi Shipyards
[X][NAME1] Spirit
[X][NAME2] Opportunity
[X][CREW1] Crew with Standard Crew
[X][CREW2] Crew with Explorer Corps
[X][BUILD] 2317 2 Excelsior-As, 2 Excelsior refits, 2 Miranda-A refits, 2 Constellation-As, 2 Constellation Refits, 4 Renaissance, 2 cargo ships, 1 freighter, 1 super-freighter

  • SF Berth A (3mt) – In 2317.Q1 commence Constellation-A using 'parallel construction' industrial park bonus. (ETC 2319.Q2)
  • SF Berth 1 (1mt) – Available 2317.Q4. Build cargo ship here ETC 2319.Q4.
  • SF Berth 2 (1mt) – In 2317.Q1 commence Constellation-A using 'parallel construction' industrial park bonus. (ETC 2319.Q2)

  • 40 Eridani Berth A (3mt) – Commence Excelsior-A in 2317.Q1 with 1qt off build time from Admiral Sirvk bonus (ETC 2320.Q4)
  • 40 Eridani Berth B (3mt) – Commence Excelsior-A in 2317.Q1 with 1qt off build time from Admiral Sirvk bonus (ETC 2320.Q4)
  • 40 Eridani Berth 1 (1mt) – Begin refit of Dryad to Mirada-A in 2317.Q1 (ETC 2318.Q1)
  • 40 Eridani Berth 2 (1mt) - Begin refit of Calypso to Miranda-A in 2317.Q1 (ETC 2318.Q1)

  • Oreasa Starfleet Berth 1 (1mt) – In 2317.Q3, begin refit of Kearsage to Constellation-A (ETC 2318.Q3)
  • Oreasa Starfleet Berth 2 (1mt) – In 2316.Q3, begin refit of Vigour to Constellation-A (ETC 2318.Q3)

  • Ana Font Berth A (2.5mt) – In 2317.Q1 begin refit of Excelsior to Excelsior-A (ETC 2318.Q1)
  • Ana Font Berth 1 (1mt) – Available 2317.Q2. Build freighter here ETC 2320.Q2.

  • LOCF Berth A (2.5mt) – In 2317.Q4 begin refit of Kumari to Excelsior-A (ETC 2318.Q4)
  • LOCF Berth 1 (1mt) – Occupied with Renaissance build (ETC 2318.Q2)

  • Apinae Shipyard Berth A (3mt) – Available 2317.Q2. Build super-freighter here ETC 2321.Q2.
  • Apinae Shipyard Berth 1 (1mt) – Available 2317.Q2. Build cargo ship here ETC 2319.Q2.

  • UP Berth A (3mt) – Occupied with Excelsior-A double build using Chen's bonus (ETC 2318.Q2)
  • UP Berth B (3mt) – Occupied with Ambassador prototype as dual build using Chen's bonus. (ETC 2321.Q4)
  • UP Berth C (3mt) – Occupied with Excelsior-A double build using Chen's bonus (ETC 2318.Q2)
  • UP Berth D (3mt) – Occupied with Ambassador prototype as dual build using Chen's bonus. (ETC 2321.Q4)
  • UP Berth 1 (1mt) – In 2317.Q1 commence Renaissance build using 'parallel construction' industrial park bonus. (ETC 2319.Q2)
  • UP Berth 2 (1mt) - In 2317.Q1 commence Renaissance build using 'parallel construction' industrial park bonus. (ETC 2319.Q2)
  • UP Berth 3 (1mt) - In 2317.Q1 commence Renaissance build using 'parallel construction' industrial park bonus. (ETC 2319.Q2)
  • UP Berth 4 (1mt) – In 2317.Q1 commence Renaissance build using 'parallel construction' industrial park bonus. (ETC 2319.Q2)

Member World Coordination Office Report

Admiral,

A relatively quiet year for the Member World Coordination Office, as most of the fleets are continuing on existing agenda, or otherwise quiet after their crew stocks were invested in the completion of multiple Renaissance-class cruisers.

Most notable are the sweeping changes being instituted with the Amarkians, where a long-standing project to refit the two-decade old Riala-class battlecruisers has come to fruition. In addition, a pair of upgrade packages are also being deployed to Brieca and Calac class frigates, aimed to give them an extra decade of relevance to buy time for the next generation frigate program to bear fruit.


End Report

Current Priorities
Name Short-Term Mid-Term Long-Term
Andorians Refit Constie 1/3 Rethinking Priorities Develop new Mining
Vulcans Emergency Crew Call-up Rethinking Priorities Grow Civ Shipping
Humans Liberty/Miranda Liberty/Miranda Ambassador
Tellarites Enlisted Drive Rethinking Priorities Expansion
Amarki   Escort Prototypes Riala-A '17
Betazed Complete Rennie Finish Eng Team Improve Budget
Caitian   Economic Growth  
Rigel Expand Cutters Cargo Expansion Expand Core/Tail
Apiata   Rethinking Priorities  
Indorian   Refit Projects U/way Increase Budget
Gaeni   Complete Exp Proto  
.
Resources

Name - BR - SR - Off - Enl - Tech
Andor - 90 - 45 - 9.2 - 10.5 - 13.5
Vulcan - 30 - 30 - (2) - (3.55) - (0.25)
Tellar - 235 - 65 - 0.25 - 0.65 - 2
Earth - 195 - 60 - 2 - (1.8) - 4.5
Amarki - 115 - 205 - 16.75 - 24 - 15
Betazoids - 115 - 155 - 5.4 - 7.15 - 4.4
Caitian - 203 - 215 - 9.7 - 10.7 - 6.2
Rigel - 90 - 30 - 1.7 - 13.05 - 8.7
Apiata - 285 - 230 - 5.5 - 50 - 14
Indoria - 125 - 70 - 6.75 - 9.1 - 8.85
Gaeni - 250 - 70 - 7.35 - 6.45 - 6.85
* NB - Most new construction has already been slated at this stage, but not all


Free Berths
Andor - 1x2500kt, 2x1000kt
Vulcan - 1x500kt
Tellar - 1x100kt
Human - 1x3100kt, 3x1000kt, 1x500kt
Amarki -
Betazoids -
Caitian - 2x600kt
Rigel - 1x2500kt, 3x1500kt
Apiata -
Indoria - 2x500kt
Gaeni - 1x1500kt, 1x1000kt

Current Fleets


[ ][PRIORITY] Pick One Member World Priority to change
[ ][PRIORITY] Change nothing [Weighted 1.5x]

Suggested possible priorities can be things such as:
Focus on building a particular ship type/class
Focus on more cargo shipping
Focus on increasing resources/recruitment
Set a target for Combat or Defence
Start designing a new ship
Prepare a refit of a ship
Interest in the GBZ

The United Earth SPA is making a decision between building the fourth and final Miranda-A of their post-Arcadian rebuild, or to start refitting the UES Liberty now.
[ ][UES] Build new Miranda-A
[ ][UES] Refit the United Earth's Excelsior

The Amarkians have revealed their long-anticipated Riala-A refit. Starfleet's input has been influencing the design throughout the process, and have helped the Amarkians come out to a package of...
(Both options cost 60br/40sr)
[ ][RIALA] Gain C2 S1 H1 L2
[ ][RIALA] Gain S2 H1 L1 P1 D1

A number of the Tailwards powers are comparing notes to find where they are running into bottlenecks on exotic materials. One of the key elements, used as a key component in EPS conduits, may be artificially synthesizable component. If Starfleet can spare research time, they may be able to improve their position on special resources.
(Per Year Increases - UESPA +10sr, TSF +10sr, VHC +5sr, BDF +5sr, Gaeni +5sr)
[ ][SR] Invest (-40rp, 1 year project)
[ ][SR] Decline

Vice Admiral T'Fear can make use of an open bay at Lagan-Shir shiypard at Rigel for an auxiliary build.
[ ][RIGEL] Build Freighter (5pp)
[ ][RIGEL] Decline

[x][UES] Refit the United Earth's Excelsior
[x][RIALA] Gain C2 S1 H1 L2
[x][SR] Invest (-40rp, 1 year project)
[X][RIGEL] Build Freighter (5pp)
[X][PRIORITY] Apiata should improve Bulk Cargo shipping in long term
 
Last edited:
[x][UES] Refit the United Earth's Excelsior

It could use the upgrade.

[x][RIALA] Gain C2 S1 H1 L2

They're gonna need those in case of Cardassians and such.

[x][SR] Invest (-40rp, 1 year project)

More SR? Yes please!

[X][RIGEL] Build Freighter (5pp)

We could use the improvement in logistics.
 
Last edited:
A number of the Tailwards powers are comparing notes to find where they are running into bottlenecks on exotic materials. One of the key elements, used as a key component in EPS conduits, may be artificially synthesizable component. If Starfleet can spare research time, they may be able to improve their position on special resources.
(Per Year Increases - UESPA +10sr, TSF +10sr, VHC +5sr, BDF +5sr, Gaeni +5sr)
[ ][SR] Invest (-40rp, 1 year project)
[ ][SR] Decline
do we get anything out of this?
 
The Gaeni have a surprisingly low SR income and a huge BR income...

Let me guess, they use up all the SR for MAD!SCIENCE! and have none left for the fleet?
 
[X][UES] Refit the United Earth's Excelsior


[X][RIALA] Gain C2 S1 H1 L2

Member world ships don't respond to events very often and science is not very important for a capital ship in battle.

[X][SR] Invest (-40rp, 1 year project)

More SR for them means more ships and higher chance they will want to trade SR for BR with us. We can spare the rp this year. Not a no-brainer, but it's sort of like spending 20pp on two SR mines for members. Would we do that? Quite possibly.

[X][RIGEL] Decline

Let's see what's available in the snakepit first (pp cost of a permanent logistics budget increase), we will probably have opportunities like this in the next few years as well.
 
Last edited:
The Amarkians have revealed their long-anticipated Riala-A refit. Starfleet's input has been influencing the design throughout the process, and have helped the Amarkians come out to a package of...
(Both options cost 60br/40sr)
[ ][RIALA] Gain C2 S1 H1 L2
[ ][RIALA] Gain S2 H1 L1 P1 D1

For reference, current Riala stats are: C6 S4 H5 L7 P5 D6

So the choice is C8 S5 H6 L9 P5 D6
or
C6 S6 H6 L8 P6 D7

Combat-focused or a balanced Explorer?
 
I think that's T'Faer. Unless you get on her bad side.

[X][UES] Refit the United Earth's Excelsior
I sort of want to hold off on the member fleets building too many Mirandas? Could go either way on this choice.
[X][RIALA] Gain C2 S1 H1 L2
C8 S5 H5 L9. That's a combatant not far off from an Amby. It plays right to Amarki strengths.
[X][SR] Invest (-40rp, 1 year project)
I don't know that we can afford 40 rp? But if Nix says we can, I trust Nix.
[X][RIGEL] Build Freighter (5pp)
Sure, why not.
 
[x][UES] Refit the United Earth's Excelsior
Completes a bit faster and is a LOT more useful for a fleet that's operating in one sector outside of wartime.

[x][RIALA] Gain C2 S1 H1 L2

Because the result is a battleship slightly weaker than an Amby ... that costs about 2/3 as much. The alternative is a tougher Excelsior-A.

[X][SR] Invest (-40rp, 1 year project)


[X][RIGEL] Build Freighter (5pp)

Convinced.

@OneirosTheWriter
Do members get improvements to their resource income when we complete mining techs?
 
Last edited:
[X][PRIORITY] Apiata should improve Bulk Cargo shipping in long term

It's something that everybody notices when they look at their auxiliary shipping capabilities.

[X][UES] Refit the United Earth's Excelsior

Get it done while things are quiet.

[X][RIALA] Gain C2 S1 H1 L2

Punching harder is a good thing for a member world ship like the Rialas. If they need Presence, they can always build an Ambassador later specifically for that purpose.

[X][SR] Invest (-40rp, 1 year project)

If Nix says we can afford it....

[X][RIGEL] Build Freighter (5pp)

5pp isn't much, and I want to walk into the Snakepit showing we've done everything possible. Remember we're still in the hole here.
 
Currently I'd say 40rp is about as valuable as 20pp. Increasing our own SR income by 35/year for 20 pp and no logistic overhead would be an easy decision, the question is how much we discount the value of the SR because it's members getting it.
 
[X][UES] Build new Miranda-A

We might have just met a very dangerous new enemy along the core/tailward frontier. All our member fleets in that region should try to get warship hulls out quickly.


[X][RIALA] Gain C2 S1 H1 L2

Hmm, this is a tough one. Should we have the proud warrior race who we've already told to build a strike fleet for us improve their battleships in that role, or should we turn a baffling 180 and tell them to turn their fleet into science ships?

When I said this was a tough one, what I really meant was that this isn't even a fucking decision at all lmao.


[X][SR] Invest (-40rp, 1 year project)

40 rp for a member fleet buff? Sounds like a bargain.


[X][RIGEL] Build Freighter (5pp)

The cat must be appeased.
 
Back
Top