GearCity Executive Secretary - A Report Utility for GearCity

[JC_Denton]

GearCity Executive Secretary is a utility that provides additional reports based on your GearCity game, allowing you to make more informed decisions, or just see how far you've progressed in make Superleggera frames the dominant chassis type in the industry.  I'm pleased to announce a substantial update.  Update, you say?  Indeed; you may have seen it before in its Steam thread.  I'm making this the new main thread since it should be possible to include screenshots here.

You can download the latest version here (7.67 MB, 4/26/2026).  To run it, you'll also need Java 17 or later, which you can download from BellSoft here (make sure to select "Full JRE").  The Secretary requires JavaFX, and thus either the BellSoft or Azul versions of Java that include it.

Versions of the Executive Secretary prior to 2026 required Java 8; this was changed in the first release of 2026.  You may need to updates your Java to run the latest version.

GearCity Executive Secretary now features 8 reports.

Company Profitability



This report shows each company's profitability, revenue, expenses, and profit margin for any year you select or a combination of multiple years (enter a number for "Years Included" and press Enter to update).  It also shows Market Cap, Price to Book, Equity, and Runway (predicted time until the company goes bankrupt at its current rate of losing money), to help you identify appealing takeover targets.  

All columns are sortable.

Profitability numbers do not include stock sales, stock issues such as IPOs, or stock purchases, so they more accurately reflect true profitability than the in-game reports (although over the long term, they also don't reflect gains or losses made via stock market investments).

New in this update is that you can double-click on a row to get Company Detail report on the company in that row.

Yearly Market Summary



The Yearly Market Summary gives overall market conditions for each game year, namely vehicle sales, industry revenue, expenses, and profitability.  This lets you get a sense of the impact of economic conditions.

There are no new features for this report in this update.

Defunct Companies



The Defunct Companies report shows you the fate of all defunct companies - if they were acquired, went bankrupt, and when.


There are no new features for this report in this update.

Market Trends



The Market Trends, formerly "Engine Layouts", report contains 19 sub-reports (up from 4 in last September's update) that show the trends in popularity of various components and metrics.  The reports available are:

 - Layout
 - Cylinders
 - Layout and Cylinders (e.g. V4, I5)
 - Fuel Type
 - Valvetrain
 - Induction System
 - Chassis Type
 - Chassis Drivetrain
 - Front Suspension
 - Rear Suspension
 - Combined Suspension
 - Gearbox Type
 - Gear Count
 - Average Gear Count
 - Average Fuel Economy
 - Average Horsepower
 - Average Torque
 - Average Top Speed by Type
 - Sales by Type

Other than the "Average" reports, all of these can be viewed in either absolute numbers of sales, or as a percentage of the overall market.  Fuel Type, Valvetrain, and Induction system also offer the ability to view the results for only one of your marques, rather than the entire market.

In all cases, you can click on items in the legend to hide them, and the graph will automatically adjust the y-axis as appropriate.  This lets you easily view the trend even for items that currently have very low market share, useful in those early years of your attempt to take over the world with superleggera.

Geographic Comparison



The Geographic Comparison report lets you view sales by marque and by country.  One potential use of this is seeing how your marketing campaigns are influencing sales over time.

This report can be a bit slow to load, especially in the late-game, due to the amount of data involved, and by default it shows sales by marque, across all countries combined.  But you can instead view one marque by-country (as above), or even all marques by country, if you have a relatively small number of marques * countries.  If you have too many marques * countries on too small of a screen, the legend will unfortunately be hidden.

This report is new in this update.

Acquisition Advisor



The Acquisition Advisor Report helps you identify the value of acquiring other companies for their physical assets, factories and branches.  It shows you all the new factories/branches you would acquire by acquiring that company, and only includes factories/branches where you do not already have a factory/branch in that city.

This saves you the time of filtering that yourself from the in-game stock market report, although currently the Secretary does not tell you where those factories are located as the in-game stock report does.

You can double-click on a row to view a Company Detail Report for a company.

This report is new in this update.

Company Detail



The Company Detail report shows a trendline of a company's profitability over time, again excluding stock transactions.  This provides a graphical view of long-term profitability, and complements the "Company Profitability" report.

This report only appears after you double-click on a company in the "Company Profitability" or "Acquisition Advisor" reports, and you can open as many of them as you wish.

This report is new in the September 2022 update.

[JC_Denton]

This post covers what changed in each update.

September, 2022

 - Added the Geographic Comparison, Acquisition Advisor, and Company Detail reports
 - Added 15 new sub-reports to the Market Trends report, bringing it to 19 in total.
 - Three of those 19, including the pre-existing Fuel Type sub-report, can now be viewed by marque
 - Added the ability to double-click on a company in Company Profitability to view Company Detail
 - The program now remembers which folder the current file is in, so if you want to jump between multiple GearCity saves, that is now much more convenient (File -> Open).
 - Major optimizations to the Market Trends reports.  Data is now loaded asynchronously so the UI doesn't freeze if it's slow, and the chart itself draws up to 96% faster once the data arrives.

June, 2023

- FBS1 (2nd Gear) Compatibility)
- Emissions Reports
- Autosave-Based Refreshing
- Company-Only Views on Almost All Market Trends Reports
- Stock Info on Acquisition Advisor
- Bonds Report
- Market Summary/Company Profitability Consider Bond Repayments
- Company Profitability's Runway accounts for negative-equity companies with cash
- Defunct Companies now note if their parent has since gone bankrupt

[JC_Denton]

June 2023 Update

GearCity Executive Secretary is back!  This update brings compatibility with FBS1, along with several new features.

You can download it from this link (8 MB).  Like previous versions, it requires the Azul or Bellsoft versions of Java 8 (Full JRE) in order to run.

FBS1 Compatibility [2nd Gear]

All reports are now compatible with FBS1.  This meant a significant update to the Market Trends report to add compatibility with the new integer-based IDs, but that is now complete.

The Executive Secretary will automatically detect whether your save is from the base game, or from 2nd Gear, and adjust its queries automatically.

Emissions Reports

There are two new reports under Market Trends, both dealing with emissions.  These are the Average Emissions report and the Average Emissions by Type report.





It is envisioned that in the future, more emission-based metrics will be available, such as comparing emissions by district.  One option that is already available is to view these reports for your individual marques.

Autosave-Based Refreshing

The Executive Secretary no longer has to be told by you to load new information - it will do so automatically.  Every 5 seconds, it checks for a new autosave file, and if it finds one, refreshes its information.  All you need to do is switch over from Gear City to the Executive Secretary, and you have information at your fingertips!

The Executive Secretary will also use the autosaves to monitor information that may not remain in the main database forever - so far, this means bond information (see that section later in this post), but in the future it may expand to annual snapshots of the stock market or company finances.

For this reason, it is recommended to set autosaves to the minimal 3-month frequency, and to leave the Executive Secretary running in the background while the game runs.  But no worries if you don't!  It can run on-demand just like previous versions as well.

Market Trends - Almost All Reports Support Viewing Your-Company-Only Results

In the previous update, three reports supported viewing the trends only for your company.  Now, all other than the Gear Count report support viewing both the entire industry's trends, or just your company's trends.  



Acquisition Advisor Improvements

The Acquisition Advisor now makes it easy to see which companies have shares available.  No more checking one-by-one, just ask the acquisition advisor if you're in the mood to buy some stocks!  The percentage of shares available and the amount that the company has not yet sold on the market are also visible, so you have a better idea of the likelihood of being able to acquire a majority stake.



Bonds Report

Considering buying a company but not sure about the quality of the debt you'd be acquiring?  Look at the Bonds report, which shows the bonds, when they're due, and their coupon rate for each company.  There's nothing worse than buying a company and finding out their billion-dollar bond is due next year.  Now your CFO can perform proper due diligence and help you avoid that surprise!



Market Summary Improvements

The Yearly Market Summary now displays the bonds issued and retired per year, and no longer counts bond repayments as an expense and against profits (coupon payments still count as an expense).  This gives a more accurate picture of the industry's profitability.



Company Profitability Improvements

Like the Yearly Market Summary, the Company Profitability Report now excludes bond repayments from profitability, both for single and multi-year views.  It didn't count as profit when you issued the bond, it shouldn't count as an expense when you repay it!

The "Runway" calculation also now better handles cases where companies have negative equity, but still have cash on hand.  Previously, this gave a result of 0 months of runway if the company was losing money.  Now, the runway is however long it will take until the cash reserves are depleted.



Defunct Companies Improvement

A small improvement has been made to the Defunct Companies Report as well - it is now properly noted if an acquired company was acquired by a parent that is now bankrupt.



Occasionally when an AI that owns multiple marques goes bankrupt, one of its acquired marques will be spun out and live on independently.  Like before, in these cases those spun-out companies will no longer be listed on the Defunct Companies Report.

Technical Note

This new version of the Executive Secretary will create a database file whose name begins with "GCES_" in its folder.  This is normal, and is where it keeps track of things that are not stored forever in the main Gear City database - for now that means historical bond information, which allows it to accurately show historical expenses and profitability.  You can browse this database with SQLite Studio or another SQLite-compatible database.

Download Now!

You can download the June 2023 version of GearCity Executive Secretary from this link (8 MB).  Like previous versions, it requires the Azul or Bellsoft versions of Java 8 (Full JRE) in order to run.

Comments are encouraged - this forum hasn't been the liveliest venue, but it doesn't have to remain that way.

[JC_Denton]

March 2024 Update

I've been playing GearCity again, and that means an update for the Executive Secretary.  It is available to download here.

It should work fine with the Liberica Full JDK, Azul Full JDK, or the old Oracle Java 8 releases.  However, results have been a bit iffy on my new laptop, so if you're having difficulty getting it to run, leaving a note, including which Java version you are running.  The Executive Secretary could benefit from an "upgrade libraries to current versions" bounty.

That said, the Executive Secretary has learned some new tricks.  These are the updates.

Licensed Components Reports

Do you fancy running a chassis, gearbox, or engine company, and letting everyone else take care of the coachwork, manufacturing, and marketing?  Then this update is for you!  The new "Licensed Components" reports show you who has sold the most of each type of component, and who has derived the most revenue from licensing each type.



Curious to play with those competitors?  If you're a Feature Bounty System supporter, head over to that forum and download my newly-released "Great Lakes" map.  If not, ready more about it here.

If you'd like to gain more insight about why Chevrolet is licensing so many more chassis than Dodge, you can also click on the pie chart to drill down.



The Secretary can't tell you all the nitty-gritty details of why that 1912 Chevy chassis is so popular, but sometimes competitors spill useful details in the names of their engines, and the price point info itself can be valuable.  Maybe it was worth sending your secretary to corporate espionage school?

Unique Colors on Market Trends

One of the shortcomings of previous releases was the limited color palette.  This has now been addressed.  Each company/component/configuration receives its own nearly-guaranteed-to-be-unique color, within a range that should exclude colors that would blend into the background too much, and will have that color stick across consultation sessions with the Secretary.  In addition, for the Layout/Cylinder report, all cylinder counts for a layout will now be within the same color family - all I's are blue, V's are red, Flats are green, and so forth.



This also extends to the Fuel Type report, which now has colors that match the pump colors at U.S. gas stations where possible - with the exception of BP, which uses non-standard colors.  Gasoline is black, diesel green, E85 yellow, water blue, and everything else gets its own uniquely-assigned color.

These changes should make it easier to garner information at a glance without having to check the legend as frequently.

Smaller Updates

A few smaller updates have been made as well.

- The Company Details report (for a specific company) now takes into account bond repayments, which means that years with a bond repayment won't show as having a huge loss.  It shows profit/loss, rather than cashflow gain/loss.
- For both the Company Profitability and Company Details reports, bonds that were issued and repaid in the same year no longer count as a negative expense, and thus positive profits.
- The Company Details report will no longer start at 1900 for companies founded considerable later - for example, companies founded between 1920 and 1929 will have their x axis start at 1920
- The Average Horsepower report now allows you to filter by fuel type, rather than by marque
- The Yearly Market Summary report has relegated bond info to the rightmost columns, to make profits/losses more prominent

Future Ideas

Ideas always outpace reality, but if there's demand (most likely meaning, if my company starts licensing out vehicle designs), vehicle licensing info may be added as well.  Various other metrics such as the companies that have licensed the most, and the companies with the most revenue from licensing (or contracts?) are also on the cusp of reaching the front burner.

I've even recently discovered a way to potentially build a report on construction expenses, which has given me ideas about expanding the Company Details report, and perhaps generally expanding the Company Detail report to shine more light on how all these bankrupt companies coming up for auction wound up being so bankrupt.  Of course, we know that your tough competition was likely a factor, but wouldn't it be nice to know more than that before you decide whether to bail out their shareholders?  Did they spend all their money trying to make an E85 renaissance happen, or did they just build too many factories anticipating a sales surge in the 1930s that never materialized?

[Eric.B]

Super awesome as always. It really makes me wish that QT or GTK had a rendering backend way back when I started. Then I could do stuff like these graphs in the game!

[JC_Denton]

Super awesome as always. It really makes me wish that QT or GTK had a rendering backend way back when I started. Then I could do stuff like these graphs in the game!

Sounds like an opportunity for AeroMogul!  Yeah, I have always liked graphs and charts, and GearCity happens to have both enough data to be interesting, and data that I can access without huge amounts of effort thanks to the save being in SQLite.  And it didn't hurt that there are enough graphs in GearCity to have me thinking, "yes, but more!"

Now I'm at a bit more of a sweet spot than when I started, as I've figured out some of the gaps in the JavaFX documentation, have learned how to navigate the SQLite DB effectively (and become better at SQL in the process), and still have ideas.  A couple of which have been enabled by the switch to numeric values bounty.

[Eric.B]

Unity has a couple of specific graphing libraries I will look into using. But being AM is client agnostic. We might get a QT version or something of the sort one day.

[JC_Denton]

Something that I've been working on, enabled by the recent "Remove Rating Limits" bounty:



A hypothetical picture of what the worldwide auto fleet might look like in a GearCity game.  The game, of course, focuses on selling new cars.  But as anyone who's been behind a late-'80s Mercedes 420 SEL at a traffic light recently knows, in the real world used cars form a considerable part of the market.  

GearCity models this to some extent, with used cars playing a factor in sales.  The modeling only goes back a few years, which makes sense when I think of which cars dealers that also sell new cars are likely to sell, especially the "certified pre-owned" or off-lease markets.

Still, I'd long thought, "what would the entire market look like?"  Could we model the number of Model T's on the road?  How rare might my former colleague, who drove his Model A to work on good-weather days in the early 2010s, be?  How long are all those phaetons relevant, anyway?

Thus, this early-version report.  It looks at the dependability score, now that it's not constantly-decreasing thanks to the new bounty, to see how likely a car is to survive; the more dependable it is, the more likely, but there's always a chance it will be destroyed in a wreck.  Then it's just a bit of math to approximate how many might still be on the road, and from there, to figure out how much fuel is being burned.

In this image, we see that while sales peaked in 1928 before the Depression, and 1928 model-year cars are more numerous than '29 through '33 model years. But due to their aging and the gradual revival of the market, 1934 model years are more common than '28, with 1941 being the most common before the war tanks the market.  Meanwhile, '38s use less fuel than '37s despite being more numerous, thanks to their improved efficiency.  Not yet in the table is that the overall-average miles-per-gallon is also 24.

So far this is all a high-level approximation based on yearly average dependability/fuel economy, but I have the groundwork to make it per-model - so if the most reliable cars are highly-inefficient trucks, they'll drive the fuel economy down for a long time, for instance.

From there, there are lots of directions it can go.  Making fuel consumption more accurate, via historical data on mileage driven per year, which I've found dating back to 1936.  CO2 emissions, based on the miles driven, fuel economy, and type of fuel.  More general greenhouse gas emissions via approximation of N2O and CH4 (nitrous oxide and methane) emissions, thanks to the new emissions system in GearCity.  Preliminary testing shows CO2 will almost always be responsible for 95 - 98% of greenhouse gas emissions, but exceptionally dirty cars may push other contributors above 10%, such as a vehicle one of the AIs built with an emissions score of 68,000.  Another possibility is showing an evolution of the figures over time, rather than the current snapshot of the current year picture. We see 724 million gallons of fuel were burned in 1944, but don't yet have a good view of how that compared to 1940 (although, for context, 724 million gallons represents about 2 days' worth of consumption in the U.S. in 2022, and actual fuel consumption in the U.S. in 1944 was 11.1 billion gallons).

I doubt I'll get as detailed as making award-winning cars survive longer as collectors' items, or modeling how many cases of lung disease were caused by highly-polluting vehicles.  Or how many lives were saved by the future safety regulations.  As usual, these reports are driven by what questions I find interesting, and which I find answerable with the data available.  More likely, a "contracts history" page to show your prowess with raking in the contract dough, or perhaps a variant of the "superlatives" screen with more filters ("highest emissions" superlative, anyone?) will come first.  I'm also tempted to add a "displacement" trend chart, showing the rise and eventual fall of the 6.2L V8 Hemi engine.

   

[Francescoq]

I absolutely love this tool.

It would be fantastic if it could also add the overall sales per year, per model/trim. I tend to track them on excel directly from the game but then sometimes (rarely) the filesave breaks and from that point on I might have to either go to a previous save or import them from the db directly, which requires saving the data every now and then...

[Syriax]

Hi, thank you for creating what looks to be a fantastic tool! Unfortunately I am struggling to get it to work. I have downloaded both the Liberica 8 Full JDK and JRE, among various other Java packs, and those two at least get the program to open. But when I open a save file, it is completely empty.

The March 2024 update file sits in my downloads folder and I open the most recent GearCity save in my Steam folder. As I'm not a backer currently, I have whatever the most recent Steam version is.

Have I made an error in installation and/or does the game need to run with the Secretary open for an extended period for it to function? Or has the tool fallen out of date?

Thank you for any answers anyone can provide!

[Pop Alexandra]

Such a useful tool. Thanks for all the work that went into it!
_______________
Alexandra

[JC_Denton]

I absolutely love this tool.

It would be fantastic if it could also add the overall sales per year, per model/trim. I tend to track them on excel directly from the game but then sometimes (rarely) the filesave breaks and from that point on I might have to either go to a previous save or import them from the db directly, which requires saving the data every now and then...

Glad you are making good use of it!

Isn't that functionality available in-game in the Hall of Fame? That's where I tend to go to see how my models sold. Maybe I'm misunderstanding the additional functionality that you are describing beyond that.

Hi, thank you for creating what looks to be a fantastic tool! Unfortunately I am struggling to get it to work. I have downloaded both the Liberica 8 Full JDK and JRE, among various other Java packs, and those two at least get the program to open. But when I open a save file, it is completely empty.

The March 2024 update file sits in my downloads folder and I open the most recent GearCity save in my Steam folder. As I'm not a backer currently, I have whatever the most recent Steam version is.

Have I made an error in installation and/or does the game need to run with the Secretary open for an extended period for it to function? Or has the tool fallen out of date?

Thank you for any answers anyone can provide!

I will have to take it for a test with the latest non-FBS version; I tested tonight that it remains compatible with FBS version 2.6.0.1.

It is, however, picky about only running on Java 8. That is something I might get around to improving this year, after having made some updates to my utility for a different game to get it running smoothly on Java 8 through 21 last year.

Most functionality should work without the program running as the game runs, with the Bonds tab being the most notable exception, as it tracks historical data that disappears from the Gear City save after the bond is paid off.

Such a useful tool. Thanks for all the work that went into it!
_______________
Alexandra

I'm glad you're enjoying it! And thanks for commenting - I wasn't sure if anyone else had made use of it in its first two years.

-------

General note, it's been a while since I played Gear City, and thanks to additional hobbies, I'm probably never going to play it again as much as I did in 2020 through 2023. But the itch to play it has returned, and with it there may be some minor update to the Executive Secretary - along with compatibility with more recent version of Java, the tab that I showed a preview of on the Ides of March, 2024 is likely to be released.

That could be this month, could be in December, but the larger point is that I haven't altogether forgotten this project.

[JC_Denton]

Good news: Work is mostly complete to port the Secretary to Java 11 through 26 (although I might make it 17 through 26, to use newer features). It was a bit harder than I'd hoped, but should make it easier to run, especially for those who need newer versions of Java for other programs.

Bad news: I found a bug where due to a miscalculation, in certain cases it appears that an infinite amount of vehicles are on the road at once, resulting in burning all of the world's historical oil reserves in a single year. This is, of course, bad for the planet. Although carbon levels become off the charts, the larger problem is the amount of soot from burned fuel, as being early in the automotive era, emissions controls are non-existent.

This has lead to global cooling due to sunlight being unable to reach the surface, and widespread crop failures.

The good news is I have an idea of where the bug is, and how to fix it. It looks like certain early models are so undependable that their annual failure rate is high enough that it becomes negative, resulting in a proliferation of those vehicles and, at the lowest levels of dependability, an infinite amount. By the time I added this feature during my prior playthrough, vehicles were already dependable enough not to have that problem.

(Note that this bug is only in the Secretary, not the game itself)

[Eric.B]

I wonder with 2nd Gear's emissions systems, you could figure out the pollution data.

I might have the formula I made to come up with GCEV values that I used to plug in real world pollutant values into...

[JC_Denton]

I wonder with 2nd Gear's emissions systems, you could figure out the pollution data.

I might have the formula I made to come up with GCEV values that I used to plug in real world pollutant values into...

That's exactly what the new tab attempts to do.

It uses the emissions value as a proxy for how much CH4 (methane) and N2O (nitrous oxide) are emitted, and combines that with the amount of CO2 emitted (based on the fuel economy and the type of fuel), and uses that to calculate the total greenhouse gas emissions (in tons of CO2-equivalent).

I'd have to look at my notes to determine exactly how I determined the conversion factors between the emissions rating and the amount of CH4 and N2O emitted.  I remember puzzling over it as well as the GCEV values for some time, but don't remember what I settled on.

The warming factors and CO2 per gallon of fuel burned are the real-world values, with an assumption of kerosene for steam cars.  That was somewhat illuminating; it made me rethink whether diesel really made any sense from a CO2 standpoint, since while it generally gives more miles per gallon, which at the surface level looks good, it also gives more CO2 per amount of fuel burned (as well as, more problematically from a city-air-quality standpoint, N2O).

There are other assumptions, notably that I didn't figure out the structure to the game's used car market, so I approximate the number of surviving cars from each model's yearly sales based on its dependability rating and age.  And it looks like miles driven per year is currently a fixed figure (9500 miles), whereas I had plans to make it gradually increase over time from the early years.

It's a feature I could take farther in several ways.  Currently it only shows prior-year emissions, not all of history.  There could be more detail of the cleanest or dirtiest cars.  I'd love to have an analysis of which fuel types are actually the best for the planet, across fleets (and that would be interesting to run on real-word data, too).  A pie-in-the-sky goal would be modeling the cumulative amount of planetary warming the historical automobile fleet had caused.  More realistic would be calculating emissions for electric vehicles and hydrogen vehicles taking into account the carbon used to generate the electricity or hydrogen (based on historical regional data), whereas currently those are factored in as zero, based on only the tailpipe emissions.

Then there are other "fun" things that could be modeled, like tetaethyllead.  I don't know if there's a distinction between types of pollutants being modeled in game to that level, but that one would at least gradually decline in the late game.

Basically though, it's a fun statistical playground, not one of the areas that offers actionable game insight.

[JC_Denton]

April 2026 Update

Another update is available!  You can download it here.

Please note that while prior releases ran on Java 8, this one runs on Java 17 through 26.  This brings the Secretary in line with the times, but means that you may need to upgrade to a more recent Liberica Java release, being sure to select a "Full" version of either the JDK or JRE.  The "Standard" and "Lite" versions do not include the nice graphics necessary to show all the charts.

Here are the changes:

World Fleet Report

As teased on Pi Day 2024, there is a new World Fleet Report.



This report shows the cumulative emissions across the world fleet over the prior calendar year; this save is from 1971, so it's showing 1970 emissions.

New Sales is what it sounds like - the number of new cars sold in a given year.

Annual Survival is based on the average dependability of models in that year, and is expected to gradually increase over time (although in this 2.3.x save, it eventually plateaued).

Amount on Road is how many cars from that year are still out there driving around.  This is calculated per-model based on the model's dependability and age; more dependable vehicles spend longer on the road.

% Fleet is the percentage of the surviving fleet which comes from that model year.  For the "Total" column, it shows the percentage of all cars ever sold which remain on the road.

Fuel Economy shows the year's annual fuel economy.

Fuel Burned shows how much fuel models from that year burned (as well as the total).  This is based on the amount still on the road, the fuel economy of those models, and a fixed average mileage per year (currently 9500); eventually this mileage-per-year will vary by year (and perhaps type of vehicle).

You can configure the units for Fuel Burned with the Preferences menu, to either U.S. Gallons, Imperial Gallons, or Barrels, to match your local unit preferences.  Reload the save or wait for the next auto-save to see the updated units.  Note that the dynamic units so far only applied to the Fuel Burned column; it is not yet possible to see fuel economy in miles-per-barrel, for example.

"Barrels" is defined in terms of the oil barrel, which is exactly 42 U.S. Gallons.

CO2 (g/mi) shows the grams of CO2 (carbon dioxide) emitted per mile traveled for a given year's remaining vehicles on the road.  These are calculated based on the vehicle's fuel efficiency as well as the amount of CO2 released by burning a gallon of the vehicle's type of fuel.

In order of most CO2 per gallon to least, the fuels are diesel (10.21 kilograms CO2 per gallon), "water" (kerosene, for steam cars, 10.15 KG CO2/gallon), gasoline (8.78 KG CO2/gallon), natural gas (6.727 KG CO2 per gallon), E85 (6.20 KG CO2 per gallon), autogas/LPG (5.68 KG CO2/gallon), and hydogen/electricity (0 KG CO2/gallon); these values are calculated from this EPA document.

How can burning a U.S. gallon of fuel that weighs about 2.7 kilograms release far more than that in CO2 content?  The answer is that while the carbon comes from the fuel, it binds with oxygen in the air, which provides the majority of the weight in the resultant CO2.

CH4/N2O (g CO2e/mi) shows the grams of CO2-equivalent (global warming potential) released per mile traveled, of CH4 (methane) and N2O (nitrous oxide).  These are calculated based on the vehicles' emission values as well as fuel burned.  Methane is 25 times as powerful at warming up the environment as CO2, and nitrous oxide is 298 times as powerful, but the amounts released are generally significantly smaller.

A vehicle with a Gear City emissions rating of 10,000 CVES will release 1.8758 grams of methane, and 0.6388 grams of nitrous oxide per U.S. gallon burned.  These are based on comparisons between historical figures of CH4 and NO2 emissions from the EPA, and Gear City CVES values for the United States, with 1979 figures used as a representative comparison point.

As can be seen, CH4/N2O emissions tend to be reduced more quickly than carbon emissions.

Total CO2 Emissions shows the amount of CO2 released by vehicles from a certain model year burning fuel on the road.  This is only the tailpipe emissions, and does not include any manufacturing-related emissions.  This is measured in metric tons, including kilotons and megatons for larger figures.

The total column shows the total amount of emissions from all cars in the prior in-game year; in this case, 193 megatons of emissions were made in 1970 alone.

Total GHG Emissions (CO2e) shows the total amount of greenhouse gas emissions, inclusive of CO2, CH4, and N2O.

You can see a list of countries by greenhouse gas emissions here, if you would like to have some comparison points for how much fuel your fleet is burning.  The figure in the screenshot is close to the real-world 2023 emissions of Pakistan and the United Arab Emirates (although those are whole-country emissions, not solely auto fleet emissions).

Java 17 to 26 Compatibility

This is a big one - the Executive Secretary now runs on Java 17 through 26 (and likely 27, etc. as they will be released).

You can download the Java 25, the latest long-term-support release, here.  Make sure to download the Full JDK or Full JRE versions from the drop-down.  The default Standard JDK release is not compatible because it does not include the fancy graphics that the Secretary makes heavy use of.

Geographic Comparison Fix

In the prior release, country names were missing from the Geographic Comparison report in 2nd Gear, being replaced by numbers (e.g. "1" instead of "Canada").  This has been fixed.

   

[JC_Denton]

THIS HAS NOW BEEN FIXED

I've noticed an issue when playing with version 2.6 of GearCity.  In version 2.3 and earlier, the Secretary could open the file, keep a database connection around, and make new queries when you requested different reports.  It could also monitor autosaves continuously, loading reports from them as the game went on.

In 2.6, I noticed that autosaves weren't happening, and then that regular saves weren't either, although when I manually saved in-game, the game said the game had been saved.  It wasn't.

Looking in Gear City's logs, I saw the following:

14:51:04:
Attempting to save database
14:51:04: Pending:

14:51:04:
Exception Occured saving db.
file: C:\Users\gc\programming\Kompex-SQLite-Wrapper\src\KompexSQLiteDatabase.cpp
line number: 423
error: database is locked

Although the path is not correct, the "database is locked" provided a clue.  This bounty removed SQLite thread safety.  One of the concerns was "If we implement advanced multi-threaded setups or multiplayer, this bounty becomes obsolete, as we'll need some thread safety".  My guess is that the existing design of the Executive Secretary requires thread safety.

What can be done?  A few things:

 - Play on 1st Gear.  Not great; it's hard to go back.  But this is the only surefire option as of today.
 - Play on an older 2nd Gear.  Not great; a lot of the appeal of continuing to play is the new features, and I didn't back up 2.5.x.
 - Change how the Secretary works so it gets a connection on demand.  A quick fix for automatic autosave loading has already mostly fixed that, but more extensive changes will be required for non-autosaves to function again, and loading data on demand.  This will take time.
 - Is it possible for a thread safety option to be added back in?

It also indicates a bug in the game: The game's UI reports that a save succeeds even if it does not, at least if the cause is the database being locked.  While an edge case, IMO it would be better for the UI to report that the save did not succeed, and preferably why, so the user can attempt to remedy the situation.  I remember back in the day trying to save documents and receiving messages that I was out of disk space - annoying, but at least I could delete something less important to free up space.

So, in the mean time, do not leave the Secretary running while playing Second Gear.  It should be safe to do so in First Gear.

[Eric.B]

If you could throw up your log file in the bugs forum, I'll take a look at it and see if there is anything I can do for 2.7 to fix this issue.

[JC_Denton]

Just put a thread up there. I think from the game standpoint, the main thing is having the UI inform the user of issues when and if issues occur saving. Which is hopefully never.

The good news from the Executive Secretary standpoint is that a fairly easy change to database connection tracking seems to have resolved the lock issue with regards to secretary-game interaction. Every time the Secretary talks with the database it requests a connection, every time it finishes a query it tells the database connection manager it's done, and once the count of connections reaches zero, the connection is closed.

I'll leave a simulation game up and running while I'm out and about this afternoon, but so far it seems to be working well; if it continues to, I'll release an update.

[Eric.B]

Sounds good!

I will likely add a lock check on save and throw an error. I think I can catch the error outside of the library. I'm trying to avoid forking third party code too much.