GearCity Executive Secretary - A Report Utility for GearCity

[JC_Denton]

Forking third party code is definitely best avoided! We have a 20-year-old forked version of a database library at work, which is now thoroughly ingrained in some of our most important systems and will be exceedingly difficult to upgrade. I'm sure someone thought it made sense at the time, and maybe it did in the short term...

Version 2026-04 has been re-released, with a fix to the prevents-saves in 2.6.x issue

It survived a 59-year test while I was out in the Valley this afternoon, and would have gone longer had I not received a notice of upcoming emissions standards (I seem to have forgotten where to configure the game to ignore all messages, even red-important ones).

It may still be beneficial to restart the Secretary every decade or so, as it was trying to reload data when I switched reports an excessive number of times after 59 years. But there is no longer a critical issue.

Along the way, I also added another fix to prevent extremely unreliable cars - with dependability ratings in the single digits - from causing an underflow error and throwing off the World Fleet report, because more than 100% of them were failing to survive a year and the formula couldn't cope with that. Hopefully that is the last similar issue.

Note to users: Never buy the first year of a brand new model. Especially if it's a Stellantis product.

[JC_Denton]

6-7 Update

Another update to Gear City Executive Secretary has arrived!  In keeping with the times, this update arrives on 6-7 and also fixes a 6-7 issue.

Download the 6-7 Update here.

Changes:

Feature: You can now Shift+Click legend entries on graphs to have only that one specific series plotted; for example, on the Sales by Type report, Shift+Click on Sedan to see just Sedan sales by time.  This makes it much less tedious to view the trend of one specific series.
Feature: You can now double-click on rows in the Defunct Companies report to view the company-specific report for a defunct company, just like you can on the Company Profitability report for non-defunct companies.  Middle click any legend entry to reset the chart to its default legend selection, or Shift+Click one row and then single-click a different row to view just two, for example.
Optimization: Remove duplicate event listeners causing the reports to reload once per autosave since the Secretary started.  Especially on long-running sessions, this can result in much better responsiveness.
Fix: Fixed the Cylinder Market Trends report legend having a cylinder order of 6-8-7.  The legend sort order is now properly 6-7 rather than 6-8.

Leave a comment if you find the new features helpful - I'm still playing my current playthrough, so there is a chance that there may be another update this summer.