@daxx
Just checked it, some code are overlapped, although the filenames are difference.

An example:
block_windows.gui and 00_com_fullscreen_hide.gui

Above two files contain same below type name, but their content are difference.


template fullscreen_hide { ...

Buttons on the side do not show up when running Community Mod Framework, but there are no overlapping .gui files. Very bizarre: https://steamhost.cn/steamcommunity_com/workshop/filedetails/?id=3385002128

@ZhaoFJx， thanks, fixed.

BTW in the metadata.json, the mod title is still "1.7+"

Hooray. Thanks for the fix.

@ephidel
Thanks, I checked it, it's a code bug in a line.
I fixed it and released a new version on 6/19/2025, it would be fine now.

Thanks for the update to this excellent mod. Unfortunately, I'm not seeing the production/political/diplomatic/military lens buttons at the bottom of the screen. I wonder if it's related to the fact that there used to be a trade lens down there as well that was removed in 1.9?

@Flounder already support newest version 1.8.x.

Would be conflict with mods which changed following files:

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

You may test it by only enabling this mod.

@Arnoldas already support newest version 1.8.x

I'm not seeing a button for this at the bottom. Does it require an update?

any updates?

@Tortellobello45
No automate trade. Only add a icon to show whether it would have a good trade route, then player decide to do it or not.

Wait, i am confused. Does this mod automate trade too? I'm only here for the spreadsheets

@Stumpyguy

You can see the numbers in tooltips when you move and stop the mouse on the icons of indicators (GDP cols) . Clicking on the top of the GDP columns will refresh the data.

I don't know which country you are playing and whether it have better routes. You can test it by starting a new game using France, you will see the good trade routes icons of indicators (GDP cols).

Thanks. Where should I see the numbers, in your example, 20.5? Also, left and right mouse clicking on the top of the gdpw column doesnt seem to change anything (apart from changing the description in the toolbar for what it is searching for).

I can work round these though, this mod is great, I couldn't play without it now!

@Stumpyguy

It's according to following methods, it's some suggestions and wouldn't be the best:)

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).

Awesome, thanks! I see them now! I'm loving this mod so thanks for creating it!

What is the criteria for showing as icon? Currently I have 2 potentially profitable routes shown, but there are several other goods that arn't highlighted which have more profitable routes available when I click on them?

@Stumpyguy
See the fourth picture of description section, there are some small icons (GDP cols) which indicate good trade routes.

where do I see the suggested "good trade routes"?

@Gloomy
It's possible to modify the code to export the data to a txt file, then we can manually import it to excel.

Anyway, it needs a lot of effort to develop the code.

I love this mod. Is there a way to export the data to excel?

The good old unsubscribe/resubscribe fixed it; looks like Steam just failed to download the update properly. Sorry to waste your time, and thanks again.

@ephidel
I tested it again, sorry I didn't find the issue, and I uploaded a picture of culture tab in the description section.

You would let this mod in the end of mod load order, and try it again. In case it is overwrited by other mods.

Thanks for maintaining this wonderful mod. That being said, when I use this on the most recent patch, the culture tab is using the old icon, is missing localization text, and is unclickable.

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

期盼更新

@MrZhu 文字大小是跟随系统的。如果单独设置可能需要原作者才能修改。

1080p分辨率下，市场界面的文字挤成一坨，可以单独调整这个mod的文字大小吗？

@Dex,
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 = "t"）

Many thanks for your reply.

I'll try to follow your instructions in the code and see if I understand the changes required.
I'm not familiar with Vic3 modding.

This situation will occur with any mod that uses the same sidebar button locations, not just Morgenrote.

For instance, the same occurs with https://steamhost.cn/steamcommunity_com/sharedfiles/filedetails/?id=2946470694&searchtext=universalis or with https://steamhost.cn/steamcommunity_com/sharedfiles/filedetails/?id=3315203793&searchtext=variety

Since this mod is useful independently of many other mods that may conflict with the opening method, it would be great if the way to activate the spreadsheet was the least conflicting as possible.

@Dex
At the same time, I'm not sure if the mod ' Morgenrote' will overwrite the file information_panel_bar.gui.

If so, previous method would not work, and have to merge below code to the file 'information_panel_bar.gui' of the mod ' Morgenrote'.

sidebar_label_button_small = {
position = { -100 640 }
blockoverride "onclick" {
onclick = "[InformationPanelBar.ClosePanel]"
onclick = "[MapListPanelManager.CloseCurrentPanel]"

onclick = "[GetScriptedGui('spreadsheet_OK_runtag').Execute( GuiScope.SetRoot( GetPlayer.MakeScope ).End )]"
onclick = "[GetScriptedGui('toggle_spreadsheet_OK').Execute( GuiScope.SetRoot( GetPlayer.MakeScope ).End )]"

onclick = "[GetVariableSystem.Set( 'more_spreadsheets_showselftrade', 'true' )]"
onclick = "[GetVariableSystem.Set( 'more_spreadsheets_showgoods', 'true' )]"

onclick = "[GetVariableSystem.Set('more_spreadsheets', GetVariableSystem.Get('ms_last_tab'))]"

shortcut = "spread_sheet"
}
}

@Dex
I think the reason which ‘T’ key doesn't work is because the file 'shortcuts.shortcuts' of my mod was overwritten by the mod ' Morgenrote'. Those two mods are using same shortcuts file 'shortcuts.shortcuts' and later lorded mod will overwrite earlier loaded mod's file.

The location of this file is at mod path: \gui\shortcuts.shortcuts
If you can manually merged below 1 line into the file 'shortcuts.shortcuts' of the mod ' Morgenrote',
the ‘T’ key will work fine.

spread_sheet = "t"

-------------------------------------------------------------------------------------
Notes:
Because it's a manual merging, we have to manually merging again every time after each updating of the mod ' Morgenrote', unless its author includes this 1 line into his/her mod.

Thank you for updating the original mod.

Unfortunately, as Gunteraz said, it's incompatible with any mod that uses the same button.

Was able to use it with Morgenrote by putting Morgenrote below in the load order and using the shortcut 'T' to open the spreadsheet.

With the recent update the shortcut 'T' stopped working.

Would it in anyway be possible for you to change the method to access the spreadsheet?

Since it seems to require minor changes to the code it should be easy for you to make the change.

I think this would make such a useful mod as this accessible to a much wider number of players who otherwise have to opt between using it or other great mods, such as Morgenrote, for instance.

In any case, many thanks for keeping this mod alive!

@chernwei5784
As 1.7* only support four filters (name, averagepopwage, governmentexpenses, taxrevenue)，
and I don't know the APIs about sorting by SQL and others etc.

Is it inteded u cant click on some of the tabs in the spreadsheets? I would love to sort by SOL etc

Amazing modder.

@Gunteraz yes,

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.

Sadly it is incompatible with Morgenröte. The buttons are in the same spot.

@血糖偏低
这个mod可能可以部分实现你的功能：
https://steamhost.cn/steamcommunity_com/sharedfiles/filedetails/?id=3278156786

请问能否在building register里添加一键全部auto-expand、privatize和nationalize的功能？

@Coozer As I don't have the API development documents, so I only have the knowledge to modify the GUI code, sorry I can't find a way to support those functions.

I would like a pie chart or some data on percentage of ownership by country. Either at a national or state level. I want an overview of how much im owned by others. Seeing how much of your national dividends are being lost overseas would be good too.

Thanks!

24-7-5 Market/Trades Tab can show both goods and trades now. (Warning text use small font)

Notes:
Market Tab:
(1) Listed goods items would be controlled by the filters of market overview tab of Market Panel.
(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.