Victoria 3

Victoria 3

47 ratings
More Spreadsheets Fork+
2
   
Award
Favorite
Favorited
Unfavorite
File Size
Posted
Updated
39.226 MB
3 Jul, 2024 @ 9:20pm
26 Sep @ 10:35pm
66 Change Notes ( view )

Subscribe to download
More Spreadsheets Fork+

Description
An updated fork of the More Spreadsheet mod that supports version 1.1X.

The More Spreadsheet mod is an excellent tool for viewing data on States, markets, and pops. It also allows you to monitor and manage three categories of goods trade routes all on a single screen. This version introduces new indicators and tooltips for identifying potentially optimal trade routes.

Unsure when the original mod would be updated, I have merged the following GUI files to ensure compatibility with newer game versions:

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

The following files were added:

spreadsheets_panel.gui
spreadsheets_panel_market.gui
spreadsheets_panel_states.gui
spreadsheets_panel_pops.gui

Load Order: It is recommended to load this mod later or place it at the end of your mod list.

All credit goes to the original authors.
--------------------------------------------------------------------------------
Note: The following known issues may also be present in the original mod. Unfortunately, I lack the expertise to resolve them:

Version 1.73 only supports four filters: Name, AveragePopWage, GovernmentExpenses, and TaxRevenue.

Market Tab:

(1) The listed goods items are influenced by the filters in the Market Overview tab of the Market Panel, and the displayed trade routes are controlled by the filters (Owned or All) in the Market Panel’s Trade Routes tab.
(2) The filters in the Market Overview tab will not function while this Market Tab is open. Normal operation resumes after closing either the Market Tab or the Spreadsheets window.

For further details, please refer to the original mod:
https://gtm.steamproxy.vip/sharedfiles/filedetails/?id=2884035975

Supported Languages: English, Chinese, Spanish, Korean, Russian, Portuguese, Japanese, French, and Turkish.
Please report any GUI-related issues.

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

25-9-9 On the state page's state name list, a right-click allows for quick navigation to the Building Registry. Additionally, a green reminder indicator will be highlighted on the corresponding state filter button within the Building Registry,
and right-click it to only show buildings of this state.
(PS: Right-clicking on the state name header button will clear all green reminder indicators.)

25-8-31 Add buildings level count.
ps. Since the total number of buildings in the state counts all buildings in the state, for states that only control part of the area, the statistical results may be overstated
2025-8-12: Added tags (I) to the Building Registry indicating profit rates at 20%, 50%, 75%, 100%, and 300%.
2025-7-29: Displayed each level’s balance, tax, and total subsidies in the Building Registry. Added a Save Game button (Ctrl+S).
2025-6-27: Added three new buttons: Building Browser, Pop Browser, and World Market.
2025-6-19: Added support for version 1.9+.
2024-11-24: Added support for version 1.8+. Shortcut key changed to N.
2024-7-20: Added two buttons at the top-right of the Market Tab: (1) Show/Hide Market Goods, and (2) Expand/Collapse All.
2024-7-18: By default, only owned trade routes are shown; click the top-right button to display all.
2024-7-9: Added a button to retrieve all goods if none are present; added a button at the bottom-right to open the trade routes window.
2024-7-8: Added weekly GDP display.
2024-7-7: Added up/down arrows to indicate changes in trade route levels.
Added a column showing the rate of pops below the Minimum Expected for each state.
Added green icons to sorted columns in the States Tab.
2024-7-5: Added support for the Market/Trades Tab.

--------------------------------- Merging Guide -----------------------------
If you wish to integrate this mod into another mod, note that the following 5 files are commonly modified by other mods as well. You can locate relevant code changes by searching for the keyword “# MOD” or “# mod”.
You will need to merge all these changes into your mod’s corresponding files (if they exist). It is highly recommended to review and understand the code changes before merging:

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

Load Order: Later is better, or place this mod at the end of your mod list.
-----------------------------------------------------------------------------------
--- 更多的州(地区)、市场/贸易、人口、建筑盈利、结余、补贴、利润率的详细信息和数据表 ---
且可以在一页上查看和控制三种类别的商品贸易路线。
- Mod载入位置:越后越好, 放最后也行。

- 250927
62 Comments
平独镇露的波兰球 27 Aug @ 8:34am 
@gamedreamcd
It worked! Now I can use the mod alongside T&R and Morgenröte—thank you so much!

The com_panel_bar.gui file in Community Mod Framework is where all the problems start.
If anyone else is having the same issue as me, you can try fixing this file.
gamedreamcd  [author] 26 Aug @ 5:26am 
@平独镇露的波兰球
The following cases are useful for merging references.

-------------------------------------------------------------
Regarding spreadsheet button disappearance issues, they may be caused by buttons code in information_panel_bar.gui being overwritten by other mod's modifications, even when the changes are implemented in other GUI files whose filenames do not match information_panel_bar.gui.

Similar issues like below:
7/31/2025:
@Bandaro
Below two files are conflict, they would need to be merged:

com_gui_sidebar.gui (Realism AI historical line More events & decisions)
information_panel_bar.gui

6/30/2025
@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 { ...
平独镇露的波兰球 26 Aug @ 2:59am 
@gamedreamcd
I’ve tried getting it to work, but it still won’t— I have no idea what else I can do to fix it.
gamedreamcd  [author] 25 Aug @ 7:47pm 
@平独镇露的波兰球
See below merging guide:
--------------------------------- Merging Guide -----------------------------
If you wish to integrate this mod into another mod, note that the following four files are commonly modified by other mods as well. You can locate relevant code changes by searching for the keyword “# MOD” or “# mod”.
You will need to merge all these changes into your mod’s corresponding files (if they exist). It is highly recommended to review and understand the code changes before merging:

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

Load Order: Later is better, or place this mod at the end of your mod list.
平独镇露的波兰球 25 Aug @ 7:48am 
I can’t get this mod to work with the Community Mod Framework, which is really frustrating. That means I can’t use this mod alongside T&R or Morgenröte either.
mwyeoh 24 Aug @ 11:18pm 
@gamedreamcd Thats a pity. Thanks for getting back to me.
gamedreamcd  [author] 24 Aug @ 9:05pm 
@mwyeoh
​​This has been a persistent issue for three years: the game still only offers sorting APIs for four columns instead of all.​
mwyeoh 24 Aug @ 6:54pm 
Just subscribed to this awesome mod! Could you add the ability to sort the lists by all of the column headers rather than just the few select ones?
gamedreamcd  [author] 20 Aug @ 7:54am 
@icon41gimp
I haven't figured out how to do this through a journal entry yet. But now merging conflict files is actually the way to prevent UI overwriting issues.
icon41gimp 19 Aug @ 6:23pm 
Any way to add a journal entry button to get into the spreadsheets to avoid the UI overwriting issues?