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
... 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!
... 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!
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.
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."
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.
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.
*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.
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.
[ ][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
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
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.
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
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?
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.
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.