I was just wondering if the profits in the spreadsheet are up to date?
For instance i see these on the powerplay map:
Cockgaigne: 68 CC
Dvorsi: 79 CC
Rabh: 77 CC
Warning: fiddly-bit alert! In other words, I'm not as sure of my knowledge on this stuff as the simpler stuff. Bearing that in mind, here we go...
Short Answer: Trust the spreadsheet - it reflects the figures and results that the game itself will use and produce at the end of the current cycle, which is what matters.
Longer Answer: To do the above, our dedicated Research Dept (and most other powers have some tireless researchers too, just not as good as ours!) have to work out what bugs affect only the UI (so the game displays wrong figures but uses correct ones) and what bugs affect the game calculations (so they can incorporate them in the spreadsheet) and what affect both. It would be nice when these are reported to see some of them fixed, even just the major ones, but that seems to happen only rarely. Perhaps the 1.4 update will bring some fixes but who knows?
For example, consider the spreadsheet's figure for Projected Balance (on the right below the list of systems) and Galnet's "updated hourly" projection article. Sometimes the spreadsheet is more up-to-date, sometimes Galnet is, but often they match - for the last 5 hours or so both are projecting -640 CC for our power (based on no more fortifying or undermining, which won't be the case of course). But an example of a bug: during cycles when a power is in turmoil the Galnet article double-counts penalties for turmoil systems so shows too low a projection. So in Turmoil weeks the totals don't match. The bug is only in the UI, and doesn't affect the real result at end of cycle.
Your Examples: I think I know one UI 'bug' and one game bug that *may* affect these numbers, though there may even be other ones. Note that in each of these systems the last line on the tool-tip in the Powerplay map lists 1 (or 3) Contested systems. These are systems that are in more than one Control System's sphere of control, so there is a reduction in the Income they give to stop them being counted twice (I think the first one established keeps it all, later control systems get no income from overlaps). That may explain some of the discrepancy. The game bug, discovered and reported by Arkhanist
in this post, is that when a Power loses a Control System, obviously any Contested systems should have their income reset and sent to an alternative Control System to reflect that. But that has not been happening. From the loss of Tewi alone, we are losing 70 CC of income that we should be getting.
I see that a lot of Control Systems with 0 Contested systems have map figures that are the same as the "Exclusive Income" figures in the spreadsheet, which would support my theory above. But a few do not, so quite possibly that means things are even more complex than I have suggested.