Subscribe to download
More Spreadsheets Fork-1.9+building/pop browser/world market buttons

A updated fork of More Spreadsheet mod to support 1.9+.
Notes: As big changes of 1.9.*, part of functions work, it would be temporary useful.
-------------------------------------------------------------------

More Spreadsheet mod is a great mod to show data of States, market and pops, and you can review and control three category goods trade routes in one page. Now added indicators and tooltips for possible best trade routes.

I'm not sure when it will be updated, so I merged four below gui files to let it can works in new version,

block_windows.gui
information_panel_bar.gui
ingame_hud.gui
shortcuts.shortcuts

and revised some mod files:

spreadsheets_panel_market.gui （revised）
spreadsheets_panel_states.gui（revised）

Load order：later is better.

All credits belong to the original authors.
-------------------------------------------------------------------------------

PS. There are some issues listed below, it may be as same as vanilla mod, and I don't have knowledge to fix them:

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

2. Conflict with other mods.

Only below four files are conflicting for adding left enter button and control some acts, it's about 10-20 lines code changes.
- information_panel_bar.gui, block_windows.gui, ingame_hud.gui, shortcuts.shortcuts
If you can merge those new codes to your mod, and let your mod's load order after this mod, both them will work fine.

3. Market Tab:

(1) Listed goods items would be controlled by the filters of market overview tab of Market Panel, and the listed trade routes would be controlled by Market Panel -> Trade Routes Tab -> filter: owned or all.

(2) The filters of market overview tab of Market Panel wouldn't work when this Market Tab is open. It will be fine after you close this Market Tab or this Spreadsheets window.

You can go to vanilla mod for detail reason:
https://steamhost.cn/steamcommunity_com/sharedfiles/filedetails/?id=2884035975

I also refer to some codes in below mods (More Spreadsheets Fork and Automate Trade):
https://steamhost.cn/steamcommunity_com/sharedfiles/filedetails/?id=3095120755
https://steamhost.cn/steamcommunity_com/sharedfiles/filedetails/?id=3019171696

It supports English, Chinese, Spanish, Korean, Russian, Portuguese, Japanese, French, Turkish
-------------------------------------------------------------------------------
Please let me know for GUI issues.

If vanilla mod is updated for new version, this mod would be abandoned.

25-6-27 add 3 buttons: Building Browser, Pop Browser， World Market.
25-6-19 support 1.9+. Change shortcut Key to N.

24-11-24 support 1.8+. Change shortcut Key to N.

24-8-9 add tooltips for indicators of possible good trade routes (may grow to level 2 or up):
a. estimated best country/market;
order by the multiply product of cheaper*consumption (or pricier*production) for comparison balance, only for cheaper/pricier >5% (targets > 10% ). If right click GDP(w)->order by price, left click GDP(w) to refresh.
b. the count of country/markets which would have good trade routes;
c. a digit indicate consumption/production balance number vs price cheaper/pricier as format: (a.b) Exp: 20.5 mean: 20 and 50%. Number level: 20/30/40/50/75/100/125/150/200/300, price level: 10%-70%(10% each step).

24-7-27 （1）Update a field according to recent a game function change.(States Tab)
(2) add an indicator for possible good trade routes.
24-7-20 - added two buttons at right-top of Market Tab: (1) show/hide Market Goods. (2) Expand all or not.
24-7-18 - Only show owned trade routes by default, and show all after clicking the button of right-top.
- Add numbers to indicate owned trade routes.
24-7-9 add a button to get all goods if not, support to click a right-bottom button to open the trade routes window, and shortcut Key T.
24-7-8 add weekly gdp.
24-7-7 - add a up/down arrow to indicate each trade route level changing.
- add rate of that pops are below Minimum Expected for each state.
- add green icons for sorted columns of States Tab.
24-7-5 - Support to show the Market/Trades Tab.

--------------------------------- merging guide -----------------------------
If you want merge this mod into other mod, here are four files which would be updated by other mods too. You can find the code changes by searching the key words: # MOD
or # mod

Then, you need to merge all those code changes into your mod's same files if have,
and you may need to read and understand those code changes before your merge them.

block_windows.gui
information_panel_bar.gui
ingame_hud.gui

shortcuts.shortcuts （In this file, only this line: spread_sheet = "n"）

--- 更多的州（地区）、市场/贸易、人口的详细信息和数据表，以及良好贸易路线建议 ---
且可以在一页上查看和控制三种类别的商品贸易路线。
- 250627