

Maybe you can even track market dominance, instead of numerical sales. A Showroom-style report, that lets you focus on the trends across generations of your vehicles more easily.

I've tried to trend this over time for my companies, and it's a lot of work to correlate manually.
#Gearcity wikia manual
Some fun historical reports, such as showing trends in cylinder counts over time (I3 vs V4, for example), or automatic vs manual transmissions. Sometimes they go broke and you can bid on them, but how can you make a decision based on almost no information? Company summaries for companies that aren't public. Don't be like me, introducing a new Phaeton in 1949. Perhaps some charts for sales by type, letting you visualize things such as the plateauing and decline of the Phaeton. You can get this manually if you tally up the Competition chart in the District screen, but it takes long enough that I usually ballpark it in practice. see total vehicle sales by continent, country, or district. Maybe some sort of obituary summary for them based on their historical data. I've always kind of wanted there to be newspaper articles when companies go under. Letting you easily see which companies are bankrupt, and when they went bankrupt. Detect if your investment is about to file for Chapter 7 bankruptcy. Add a report that shows companies' equity, debt, and cashflow situations. Would you be investing in a company that makes high-end cars, or tries to focus on the volume segment of the market? Integrating P/B (Profit to Book value) into the current report, to make it a general-purpose research-your-stock-investments report. In the future, I have ideas to enhance it such as:
#Gearcity wikia code
You can view the source code here with the database querying code here. It only reads from database it doesn't write anything to it. When it runs, it will start with a file open dialog point it to your Gear City save and it will crunch the numbers for the report. If Java is installed properly, double-clicking it should run it. I recommend the "Full JRE" option if you are an end user either 64-bit or 32-bit will work.ĭownload the latest version (August 2021) of Executive Secretary here.
#Gearcity wikia software
Eventually I plan to offer a batteries-included option for Windows, but for now, if you don't have Java, you can download it from Bell Software here.

To run this utility, you'll need to have Java 8 or later installed. Sort of a "company graveyard" memorial that I felt was missing. Includes year of founding and year of going bankrupt/acquired Shows companies that went bankrupt, or were acquired (and remain subsidiaries, e.g. Useful to tell at a glance if the market is shrinking Shows the worldwide sales of all vehicle types by year Bond repayments are included in expenses in both this report and the in-game Company List report, although only the coupon payments really affect profitability (versus cashflow, where bond repayments do matter) Note that the "Runway" column works best when viewing the previous year's data (it assumes all years have 12 months). You can view results for the current year-in-progress - just save the game and reload to get an update, no need to wait for January. Want to see the 1905 results when it's 1955? No need to click "Previous" fifty times. You can jump directly to a specific year. Don't let a profitable-for-one-year-only company fool you into investing in them! see the totals across the past 3, 5, or even 20 years instead of one year at a time. You can view multiple years at once, e.g. Includes columns for Company Equity and Runway (how long until their equity goes negative) to help you decide whether you should sell, and also to know if any bankruptcy bids are likely to occur soon. Includes columns for Margin, Market Cap, and Price/Book to help you make informed decisions about where to invest. Shows income/expenses/profitability while excluding stock sales (including IPOs and issuing new shares) and stock purchases, giving a more realistic view of profitability than the in-game Company List report. There are three reports as of the August 2021 update: Dubbed the Executive Secretary, it provides a few reports that provide additional insight into the market, and thus help you make more informed decisions. I've been inspired to start a new utility, which essentially creates additional reports based on data in the SQLite database.
