Good Trading Routes for Spreadsheets Fork-1.8+

Updated version of More Spreadsheet mod with support of version 1.8+.

The More Spreadsheet Mod is a great tool for displaying state, market and population data. You can view and manage trade routes for three categories of products on one page. Added indicators and tips for potentially the best trading routes.

Since I'm not sure when the upgrade will take place, I merged the four GUI files below to make sure the mod works in version 1.8+,

block_windows.gui

information_panel_bar.gui

ingame_hud.gui

shortcuts.shortcuts

and edited some fashion files:

spreadsheets_panel_market.gui (modified)

spreadsheets_panel_states.gui (modified)

Download order: Late download is preferred.

All rights reserved to the original authors.

— —

PS. Below are some of the problems that may coincide with the problems of the original fashion, and I do not have the knowledge to fix them:

1. Version 1.73 supports only four filters (name, averagepopwage, governmentexpenses, taxrevenue)

2. Conflicts with other modes.

Only four files below conflict due to the addition of the "Enter" button and the control of some actions, that is about 10-20 lines of code.

– information_panel_bar.gui, block_windows.gui, ingame_hud.gui, shortcuts.shortcuts

If you can merge these new codes into your mod, and set your mod download after this mod, both mods will work correctly.

3. "Market" tab:

  (1) The products displayed are controlled by the filters in the Market Overview tab of the Market panel, and the displayed trade paths are controlled by the filter parameter: "owned" (custom) or "all" (all) in the Trading Paths tab of the Market panel.

  (2) The Market Overview tab of the Market panel filters will not work when this Market tab is open. This will fix when you close the Market tab or this table window.

Detailed information can be found in the original fashion:

https://steamcommunity.com/sharedfiles/filedetails/?id=2884035975

I also used some codes from the following mods (More Spreadsheets Fork and Automate Trade):

https://steamcommunity.com/sharedfiles/filedetails/?id=3095120755

https://steamcommunity.com/sharedfiles/filedetails/?id=3019171696

Languages supported: English, Chinese, Spanish, Korean, Russian, Portuguese, Japanese, French, Turkish.

— —

Report GUI issues.

If the original mod is updated for the new version, support for this mod will be discontinued.

24-11-24 Support 1.8+. Change the shortcut key to N.

24-8-9 Added tooltips for indicators of potentially profitable trading paths (possible increase to the 2nd level or higher):

  a. Calculated best country/market;

  Sorted by product of quantities (the price of the goods is cheaper * consumption) or (the price of the goods is more expensive * production) to compare the balance, only for cheaper / more expensive >5% (the objectives are > 10%). If you right-click on GDP(w) -> sort by price, left-click on GDP(w) to update.

  b. Number of countries/markets that will have profitable trade routes;

  c. A figure indicating the number of the balance of consumption/production relative to the price cheaper/more expensive, in the format: (a.b) Example: 20.5 means 20 and 50 per cent. Number level: 20/30/40/50/75/100/125/150/200/300, price level: 10%-70% (step 10%).

24-7-27 (1) Update of the field in accordance with the recent change in game functionality. (States tab)

(2) Added an indicator for potentially profitable trading routes.

24-7-20 - Added two buttons in the upper right corner of the "Market" tab: (1) Show/hide products in the market. (2) Expand all or not.

24-7-18 - By default, only your own trade routes are displayed, and everything is displayed after you click the button in the upper right corner.

- Added numbers to indicate your own trade routes.

24-7-9 Added a button to get all items if they are not, support clicking the right bottom button to open the trade path window and the T shortcut key.

24-7-8 Added weekly GDP.

24-7-7 - Added up/down arrows to indicate the level change of each trade route.

- Added a percentage of the population below the minimum expected level for each state.

- Added green icons for sorted columns on the States tab.

24-7-5 - Support for displaying the tabs "Market / Trade".

— Merge Guide —-

If you want to merge this mod with another mod, here are four files that can also be updated by other mods. You can find changes to the code by searching for keywords: # MOD

or # mod

Then you need to merge all these code changes into your fashion files of the same name, if you have them,

and you may need to read and understand these code changes before you merge them.

block_windows.gui

information_panel_bar.gui

ingame_hud.gui

shortcuts.shortcuts (This file only contains this string: spread_sheet = "n")

- Detailed information and data on states (territories), markets/trade, population, as well as proposals for effective trade routes —

and the ability to view and manage trade routes of three categories of goods on one page.