Some text should be changed so that translations can be added

textbox = {
autoresize = yes
using = fontsize_mega
text = "Missing Market Goods?"
}
textbox = {
autoresize = yes
using = fontsize_large
text = "For some reason Paradox only exposes goods filtered by the Market tab filters."
}
textbox = {
autoresize = yes
using = fontsize_large
text = "How to fix: Head to the Market tab and deselect the filter."
}
}

[concept_sell_orders]

Can it be changed to MS_sell_orders

This makes it easier to translate into shorter texts

This will make it easier to view at 100% scale

Can the religion column be changed to just icons to save space?

l_simp_chinese:
MS_BTN: "表格"
MS_TOOLTIP: "显示表格"
MS_PANEL_HEADER: "表格"
MS_STATES: "地区"
MS_POPS: "人群"
MS_MARKET: "市场"
MS_POP: "人口"
MS_PEASANT: "小农"
MS_UNEMP: "失业"
MS_RADICAL: "激进"
MS_LOYALIST: "忠诚"
MS_LITERACY: "识字"
MS_INFRA: "基建"
MS_TAXCAP: "征税"
MS_TURMOIL: "动乱"
MS_GDP: "GDP"
MS_SOL: "生计"
MS_GROWTH: "增长"
MS_MIGRATION: "移民"
MS_MIGRATION_ATTRACTION: "吸引"
MS_TRAITS: "修正"
MS_URBANIZATION: "城镇"
MS_ARABLE: "可耕"
MS_QUALIFICATIONS: ""
MS_STAPLE: "日用品"
MS_INDUSTRIAL: "工业品"
MS_LUXURY: "奢侈品"
MS_MILITARY: "军用商品"
MS_TRADEROUTES: "贸易路线"
MS_GOTO_PORT: "港口"
MS_BUILD_PORT: "建造港口"
MS_TRADE_ROUTE_TOOLTIP: "该商品有你参与的贸易路线" # There are trade routes for this good that are owned by you
MS_WARNING_1: "市场商品缺失？" # Missing Market Goods?
MS_WARNING_2: "原因：你在市场页面单独筛选了商品" # For some reason Paradox only exposes goods filtered by the Market tab filters.
MS_WARNING_3: "修复：在市场页面改为显示所有商品" # How to fix: Head to the Market tab and deselect the filter.

# New for Pops Tab
MS_WORK_BUILDING: "建筑"
MS_WORK_BUILDING_TOOLTIP: "人群所工作的建筑"
MS_CULTURE: "文化"
MS_RELIGION: "宗教"
MS_ACCEPTED: ""
MS_ACCEPTED_TOOLTIP: "被接纳"
MS_POP_TOOLTIP: "人口"
MS_WORKFORCE: "劳力"
MS_WORKFORCE_TOOLTIP: "劳动力"
MS_DEPENDENTS: "扶养"
MS_DEPENDENTS_TOOLTIP: "受扶养人口"
MS_WORKFORCE_RATIO: "劳比"
MS_WORKFORCE_RATIO_TOOLTIP: "劳动力比例"
MS_EXPEXCTED_SOL: "期望"
MS_EXPEXCTED_SOL_TOOLTIP: "期望生活水平"
MS_INCOME: "收入"
MS_INCOME_TOOLTIP: "收入"
MS_WORKFORCE_INCOME: "劳收"
MS_WORKFORCE_INCOME_TOOLTIP: "劳动力收入"
MS_DEPENDENTS_INCOME: "扶收"
MS_DEPENDENTS_INCOME_TOOLTIP: "受扶养收入"
MS_NET_INCOME: "净收"
MS_NET_INCOME_TOOLTIP: "净收入"
MS_AVG_ANNUAL_WAGE: "年收"
MS_AVG_ANNUAL_WAGE_TOOLTIP: "平均年收入"
MS_WEALTH_PROGRESSION: "进度"
MS_WEALTH_PROGRESSION_TOOLTIP: "前往下一财富等级的进度"
MS_EDUCATION_ACCESS: "识字"
MS_EDUCATION_ACCESS_TOOLTIP: "识字率"
MS_POL_STR: "势力"
MS_POL_STR_PCT: "势力"
MS_POL_STR_TOOLTIP: "政治力量"
MS_IGS: "利益"

I added the tooltips in cases where people can only see dots. This way they can always read the full name in the tooltip.

I added the sol icon. Overall I am split about the icons, even consider removing them all, because on 100% scale they just overlap too easily especially with different translations all using different sizes.

Translation keys added, thanks for spotting these!:
- Warnings
- Trade route tooltip
- Sell and Buy orders (default to the concept because in english it is nice and short anyways, but now easy to overwrite)

Religion Icon: I don't think that is easily possible. The tooltip for the religion is autogenerated from the GetName promote. If I remove that there is no easy way to get that tooltip on the icon (cursory glance I couldnt find which translation key the GetName produces)

Thanks for the translation! New version will be up shortly.

Thank you very much for your efforts, and I have a few small suggestions.

textbox = {
size = { 40 @traderoute_line_height }
layoutpolicy_horizontal = expanding
layoutpolicy_vertical = expanding
align = right|nobaseline
text = "@money! #v [TradeRoute.CalcProductivity|1=+]#!"
tooltip = "[TradeRoute.GetRevenueAfterTariffDesc]"
}

textbox = {
size = { 40 @traderoute_line_height }
layoutpolicy_horizontal = expanding
layoutpolicy_vertical = expanding
align = right|nobaseline
text = "@bur! [TradeRoute.CalcCost]"
tooltip = "TRADE_ROUTE_TOOLTIP"
}

This may improve at 100% scale.

text = "Im/Ex"

Can this also be changed into an alternative translation? Or change to ImEx

I think if you use icons to represent the numerical balance, you can indeed delete the previous icons.

Wages, expenses, taxes, can not use a smaller font size? They can be sorted like "states"

# Avg Wage
sort_button = {
layoutstretchfactor_horizontal = 1
layoutpolicy_horizontal = expanding
size = { 0 @item_height }
onclick = "[AccessPlayer.SortStates('averagepopwage')]"

text = "WAGES"
align = right|nobaseline

How about [concept_building_wage]? This will look more beautiful.

Now, only the states column is left, and this column is left and the others are right. Are you going to do this? Then, the icon in the top bar looks centered. Can you adjust the other words in the top bar to center?

Can you change the column of religion to only display icons and tooltip on the page of pops, and move it to the left to leave more space for the column of culture?

In order to improve compatibility, can you widen the column of traits? Maybe it will be more convenient to be compatible with some mods that add four or even five traits? Or is it compatible now?

The trade route under the market page shows this part. Is it too narrow for 100%? Is there an easy way to widen it?

text = "MS_WEALTH_PROGRESSION"
tooltip = ""
align = right|nobaseline
}

vertical_divider = {}

# Literacy
sort_button = {
layoutstretchfactor_horizontal = 1
layoutpolicy_horizontal = expanding
size = { 0 @item_height }
enabled = no

You seem to have forgotten to add vertical_divider = {}

I think you will later change the columns under the pops page except the states columns to smaller font sizes?

layoutstretchfactor_horizontal = 2

Will this be better? Can display a longer culture name.

Thank you very much for your hard work.

Wow so much input. Thanks for your effort in finding all these!

- I improved the traderoute overview. Now 100% scale has no more ugly collisions.
- Removed Im/Ex completely, it is obvious what the buttons do
- Expenses are already too big for its column on 100% scale... I made them all bold, this is the easiest change because it doesn't require retranslation for every language
- The intention is that states is left, because the column below it is left aligned. Every other column is right aligned. So every sort button is right aligned. Only icons are centered, because otherwise they look ♥♥♥♥.
- I increased the size for culture and removed the religion name after I found a workaround to get the religion tooltip back (somewhat).
- I increased the width of traits so that 3 traits can fit now. More traits is going to be a stretch for 100% gui scale. 80% is probably possible, but there is no way to detect ui scale.
- Yes that divider was missing, good find.
- I made the font sizes for the other columns smaller.

All the changes will be included in the next version, probably up in 15 min.

I think all the improvements are great now, but the warnings on the market page seem to pop up too often when I play games. Sometimes it will disappear when I switch countries, and sometimes it won't. My guess is that it has something to do with text modification. Can it be made less sensitive?

There is also the "no supply network" prompt. Can you lower it a bit?

MS_EDUCATION_ACCESS: "机会"
MS_EDUCATION_ACCESS_TOOLTIP: "受教育机会"
MS_POL_STR: "势力"
MS_POL_STR_PCT: "势力"
MS_POL_STR_TOOLTIP: "政治力量"
MS_IGS: "利益"

MS_QUALIFICATIONS_TOOLTIP: "资质"
MS_SELL_ORDERS: "售"
MS_BUY_ORDERS: "购"
MS_TRADE_ROUTE_TOOLTIP: "该商品有你参与的贸易路线"
MS_WARNING_1: "市场商品缺失？"
MS_WARNING_2: "原因：你在市场页面单独筛选了商品"
MS_WARNING_3: "修复：在市场页面改为显示所有商品"
MS_GOODS_NUMBER_WITH_TRADE_LEVEL: "[TradeRoute.GetTradeQuantity|Dv] ([TradeRoute.GetLevel|v]级)"
MS_WAGES: "#bold $WAGES$#!"
MS_EXPENSES: "#bold $EXPENSES$#!"
MS_TAXES: "#bold $TAXES$#!"

Make up the translation and make some changes.

Oh no... yeah you are totally right.
If you don't have enough goods in your market (e.g. playing a small nation without customs union) it will also show the warning. The limit was at 25, I reduced it to 18 now. The alternative would be to reduce it even further, maybe to 14 or 12. In these cases it will not detect if you filter for industrial or luxury goods in big markets and will not show a warning.
This kind of sucks and I can't do anything against it.

Okay, I will fix that no supply too.

I feel a little embarrassed that I only realized how useful basic data visualizations would be after seeing Vic3 data presented like a spreadsheet. I have no idea what tools are built-in, but the information for supply and demand can be parsed by a user faster with a bar chart showing supply and demand as bars, no need to read the numbers.

The built-in pie-chart visual used for pops could be used to show supply. It would be really helpful to see entire the economy's demand for goods as a pie chart of quantity ordered (like for pop percentage of jobs) and a pie chart off to the side weighted by price (like pops weighted by clout, but instead price*demand)

Maybe I cant find the right sub-menu, but seeing the time-series of how supply and demand change for a good over time (overlaid in the same graph) would be cool. idk if it could be re-purposed, but the clout-over-time and GDP graph preform that function function.

The pie chart for goods demand and price may be possible. I am not sure where to fit them right now, but I added them to my backlog of things.

The other chart is somewhat existing. If you go to a specific goods detail screen you get a price history graph for that good. The version you described is not possible without Paradox Support as there is currently no way to retrieve this historical information.

Hey @inch4tk. Any particular reason to have "using = fontsize_small" @L659 in information_panel_bar.gui ? Without that the font becomes the same as the vanilla buttons and looks better imho.

Yes, there is a reason.

The area that moves out when hovering over the buttons has a clickthrough blocker behind it. When the length of a button name is longer it will extend that clickthrough blocker size. When not hovering over the buttons the clickthrough blocker is moved to the left with everything else, so it can be animated in and out. Since you increased the total size, the blocker then starts to be above UI elements that are very close to the left side of the screen, e.g. consumption taxes in the budget panel. This was actually a bug in one of the early More Spreadsheets versions.

I could of course move everything farther left to compensate, but the code for that movement is in another .gui file. If I start to overwrite this file, the mod potentially ends up being incompatible with other mods. Since the issue was pressing to fix back then, I just made the font size smaller and never revisited the issue.

I will check if any other common mod uses the file. If not, I will change it to make it look nicer.

ah, gotcha. Thanks for explaining it!