Of course my parents walked in right when the spreadsheet was up. Now they’ve banned me from TH-cam and have taken away my access to Microsoft office on the family PC. Thanks a lot Generalist!
Ah yes the return of Generalist, Tired of the loud cars on the street, He who is a master of Victoria 3, And a beast in the (spread)sheets. Good stuff as always👍
I would watch that for sure. But it seems it's roughly the same as before. Simply put: -Early game (lot of peasant) focus on efficiency per construction (chop-chops and mines) -Mid-late game (few peasant) focus on efficiency per workers (manufactures, consumer goods)
Great spreadsheet, Generalist! This price flexibility should be called profit margin or something like this. Would love to see it adapted to the new dividend/income dynamics. Also, thanks a lot for sharing it!
I wonder why Art Academies and Railroads are so bad. During that time period, railroad companies were among the most profitable in the world (e.g., the Pennsylvania Railroad, which was the most profitable company in the world in the 1910s, but is not represented at all in Victoria 3).
Tbf there were also a lot of Railroads that lost money as they were overbuilt in some areas as they were seen as a good money sink for investment. But the problem is that manufactories should be playing the railroads/ports for freight.
@@generalistgaming though railroads would also be a good labor saving PM for ports, considering railroads are the best inland connections to be ports. I wonder why government buildings don't have any of those.
Can you do a tutorial on Urban Centers and prices for services and transportation? I’ve noticed that the price effect estimates of changing PMs there is totally whack… I think because substitution effects are so dominant and the tooltips can’t predict that. Love your content!
Can you look at the investment pool amount for different ownership methods? I am not convinced Laissez-Faire gives you more reinvestment than having nationally owned buildings.
I think the general idea with private ownership being better than government ownership is that private ownership stimulates the economy even if your balance doesn’t show it. Profits from government owned buildings go directly into the balance sheet (after being subject to a ‘government dividends reinvestment efficiency’ malice), whereas a portion of the profits from privately owned buildings are put into the investment pool and a portion are spent on consumer goods by the pops that own the building. For a brief summary on the government dividends reinvestment efficiency modifier, it varies based on economic system and it deletes money from the economy. If we assume a modifier of 0.5x or 50% then you will see half of the buildings profits in the balance sheet and the other half will just be deleted. The deleted portion of the dividends is such an issue because the ‘lost money’ doesn’t stimulate the economy at all. (i.e it isn’t spent by the owners on consumer goods) Therefore, it may look like government owned buildings are better because you can see the output on the balance sheet, but privately owned buildings stimulate the economy far more as well as helping to avoid the negative government dividends reinvestment modifier. Feel free to correct me on any of this and watch generalist’s ’meta changes’ video to get a more detailed and better explained answer.
@@KieranDix0n Almost everything you said is true, I am just wondering if, when all is said and done, that government ownership has an edge in reinvestment edge allowing you to grow your economy faster while burning some of (25%) of the factory profits. Also I think the 50% reinvestment part is actually put into the reinvestment pool in full without any losses, so overall it should be 75% of the profits surviving (and you can reinvest them all by spending them on manual construction) on interventionism, capitalists normally reinvest 25-30%. Late game I think with wages being high you will suffer a lot from the throughput and it would be make sense to privatize a lot of buildings. Later as you maybe run out of investment opportunities the balance shifts to efficency and you want more throughput.
should evaluate the different companies and state bonuses in this sheet seems like the discount you get to construction from conpanies and the throughput bonus which would increase the numerator in the value / construction
I feel like now you need to gun for groceries and make them as cheap as they can be while profitable so more pops get them instead to lower grain prices more in 1.7, since pops are the largest factor for grain price and groceries provide 1.5 times the supply need per grain to pops at only 20ish grain on the highest value and pops pick the good with the most quantity at the highest value to fill their specific need
40:43 Don't engineers favor joining PB or industrialists? They do get a little TU attraction from working in a factory, but not nearly as much as laborers and machinists do.
I think it’s more so industrialists. I had a communist run where I went with cooperative ownership, and engineers and the occasional remaining capitalists (the ones that owned foreign buildings) allowed my Industrialists to still have 7.5% clout. Granted, the PB were still at over 40% clout, while the TU was only at around 20% clout.
Will you do a Video about how to become a recognized power or do you have a thread about this topic? I struggle to do this with japan now in the new update.
So if for example the price flexibility for e.g. automobiles is 108%, - it means it starts losing money at -8% price point, - but it also means that it has double gross margin when the price is at +8% And quadruple when it's at +24%! (i.e. when the output price goes up) Or even better and realistically, if you suppress the input goods by -24%? Sorry if I'm wrong. I was just thinking this way when I was playing the game personally, in which I had different conclusions with steel and auto. I once ago computed that industries are way way better. Don't remember the numbers but like 5 times more profitable.
This also relates to small differences in input output good prices(mapi) making huge differences in profitability, as for some industries. (Especially steel)
Some industries can also be even more productive for exports when we consider that the AI markets often have super high prices for some goods (motor, steel again)
It does not double the net output at +8% price, unless I'm misunderstanding what you're saying somehow. Industries are generally efficient per worker but not very efficient per construction
The spreadsheets are nye! Will you evaluate working classes someday? The new ownership makes this more important, since buildings can be fully owned by workers and some classes have more bonuses (and earlier bonuses) than others. I reckon that you should build and nationalize the worst buildings in the country too, since less profit means less money deleted by public dividends, and more money freed up at private hands for buying profitable public buildings. What was the book you mentioned on your previous video on Algebraic notation and the press? Will you do a Generalist Ideas on it? I might be interested for citing in my PhD.
Nice video! Hey, I would like to know if you would take players saves and fix them. I have a good Soviet Union Run, but I think the economy is not healthy, and would like to know if you would check it out. I ask mainly to learn how a good economy must look like.
Of course my parents walked in right when the spreadsheet was up.
Now they’ve banned me from TH-cam and have taken away my access to Microsoft office on the family PC.
Thanks a lot Generalist!
Wait you mean to tell me you're underaged and watching this?! Shame on you!
Grats you have just passed the law "TH-cam Banned" on your first try with the support of most powerful clout in your family.
I see what you did there.
yeah rely im a minor and you showed this vid to me i deserve compencation for caused emotional damage8so slide over you walet) lol
SPREADSHEETS 😱
THIS IS THE MOMENT I HAVE BEEN WAITING FOR!!!!!!!!!!
Pervert
Look at spreadsheets all day at work only to come back home to watch a dude play a game with spreadsheets. This is my best life
Ah yes the return of Generalist,
Tired of the loud cars on the street,
He who is a master of Victoria 3,
And a beast in the (spread)sheets.
Good stuff as always👍
Godlike content, truly the core gameplay of Vicky is in the spreadsheets
Why look at art assets when I can look at cells?
@@generalistgaming working better pm than art academies
Oh almighty Algorithm! Please take this comment as a humble offering and bless Generalist with recommendations and 100% MAPI in every TH-cam category.
Based 🙏
idk why but "please remove children from the room" and "loud car" always get me
1.7 Industrialisation guide, generalist! 1.7 Industrialisation guide!
I would watch that for sure. But it seems it's roughly the same as before. Simply put:
-Early game (lot of peasant) focus on efficiency per construction (chop-chops and mines)
-Mid-late game (few peasant) focus on efficiency per workers (manufactures, consumer goods)
SPREADSHEET GAMING 🗣️🗣️🗣️🔥🔥🔥
Videogames and Excel spreadsheets, a classic combo.
You spread the sheets real well, friend. ❤
This is possibly the funniest thumbnail and title pairing I've seen to date. Bravo
Great spreadsheet, Generalist! This price flexibility should be called profit margin or something like this. Would love to see it adapted to the new dividend/income dynamics. Also, thanks a lot for sharing it!
The problem is that net is the profit and the flexibility is a ratio.
Yes! Finally putting the spreadhseet in spreadsheet gaming
I like chop2 even though not the most efficient, because it can spawn capitalist with the smallest construction cost.
I wonder why Art Academies and Railroads are so bad. During that time period, railroad companies were among the most profitable in the world (e.g., the Pennsylvania Railroad, which was the most profitable company in the world in the 1910s, but is not represented at all in Victoria 3).
Tbf there were also a lot of Railroads that lost money as they were overbuilt in some areas as they were seen as a good money sink for investment. But the problem is that manufactories should be playing the railroads/ports for freight.
@@generalistgaming though railroads would also be a good labor saving PM for ports, considering railroads are the best inland connections to be ports. I wonder why government buildings don't have any of those.
Can you do a tutorial on Urban Centers and prices for services and transportation? I’ve noticed that the price effect estimates of changing PMs there is totally whack… I think because substitution effects are so dominant and the tooltips can’t predict that.
Love your content!
Can you look at the investment pool amount for different ownership methods? I am not convinced Laissez-Faire gives you more reinvestment than having nationally owned buildings.
I second this, and it would be good to account for different taxation laws
I think the general idea with private ownership being better than government ownership is that private ownership stimulates the economy even if your balance doesn’t show it.
Profits from government owned buildings go directly into the balance sheet (after being subject to a ‘government dividends reinvestment efficiency’ malice), whereas a portion of the profits from privately owned buildings are put into the investment pool and a portion are spent on consumer goods by the pops that own the building.
For a brief summary on the government dividends reinvestment efficiency modifier, it varies based on economic system and it deletes money from the economy. If we assume a modifier of 0.5x or 50% then you will see half of the buildings profits in the balance sheet and the other half will just be deleted. The deleted portion of the dividends is such an issue because the ‘lost money’ doesn’t stimulate the economy at all. (i.e it isn’t spent by the owners on consumer goods)
Therefore, it may look like government owned buildings are better because you can see the output on the balance sheet, but privately owned buildings stimulate the economy far more as well as helping to avoid the negative government dividends reinvestment modifier.
Feel free to correct me on any of this and watch generalist’s ’meta changes’ video to get a more detailed and better explained answer.
@@KieranDix0n Almost everything you said is true, I am just wondering if, when all is said and done, that government ownership has an edge in reinvestment edge allowing you to grow your economy faster while burning some of (25%) of the factory profits.
Also I think the 50% reinvestment part is actually put into the reinvestment pool in full without any losses, so overall it should be 75% of the profits surviving (and you can reinvest them all by spending them on manual construction) on interventionism, capitalists normally reinvest 25-30%. Late game I think with wages being high you will suffer a lot from the throughput and it would be make sense to privatize a lot of buildings. Later as you maybe run out of investment opportunities the balance shifts to efficency and you want more throughput.
I'm going to once LF is fully unbugged
Dude, are you an economics major? How did you learn to model this stuff and how can I learn to do it too? Awesome job btw!
Can't like this enough. A masterclass on Victoria 3 econ
we will defend you from being canceled for this, Generalist.
What can men do against such reckless hate?
@@generalistgaming brotherhood and the power of friendship will triumph over the impending evil
Great my parents saw the spreadsheet. Now they think I'm some functioning member of "Society". Now I have to play another Byzantine run in eu4.
should evaluate the different companies and state bonuses in this sheet seems like the discount you get to construction from conpanies and the throughput bonus which would increase the numerator in the value / construction
Hell yeah spreadsheets
I feel like now you need to gun for groceries and make them as cheap as they can be while profitable so more pops get them instead to lower grain prices more in 1.7, since pops are the largest factor for grain price and groceries provide 1.5 times the supply need per grain to pops at only 20ish grain on the highest value and pops pick the good with the most quantity at the highest value to fill their specific need
40:43 Don't engineers favor joining PB or industrialists? They do get a little TU attraction from working in a factory, but not nearly as much as laborers and machinists do.
I think it’s more so industrialists. I had a communist run where I went with cooperative ownership, and engineers and the occasional remaining capitalists (the ones that owned foreign buildings) allowed my Industrialists to still have 7.5% clout. Granted, the PB were still at over 40% clout, while the TU was only at around 20% clout.
imagine being this smart
Will you do a Video about how to become a recognized power or do you have a thread about this topic?
I struggle to do this with japan now in the new update.
Maybe? They just changed the mechanic and I haven't played w/ it yet. Enforcing a ton of wargoals seems to be the most straightforward though atm
@@generalistgaming ok thanks for the explaining.
Now THIS is a happy Thursday
Bro posted the spreadsheet, i AYO'd outloud at work
AYOOOO
So if for example the price flexibility for e.g. automobiles is 108%,
- it means it starts losing money at -8% price point,
- but it also means that it has double gross margin when the price is at +8%
And quadruple when it's at +24%!
(i.e. when the output price goes up)
Or even better and realistically, if you suppress the input goods by -24%?
Sorry if I'm wrong. I was just thinking this way when I was playing the game personally, in which I had different conclusions with steel and auto. I once ago computed that industries are way way better. Don't remember the numbers but like 5 times more profitable.
This also relates to small differences in input output good prices(mapi) making huge differences in profitability, as for some industries. (Especially steel)
Some industries can also be even more productive for exports when we consider that the AI markets often have super high prices for some goods (motor, steel again)
It does not double the net output at +8% price, unless I'm misunderstanding what you're saying somehow. Industries are generally efficient per worker but not very efficient per construction
the infamous spreadsheets
No wonder I’m worse in patch 1.7 than in former game version, I haven’t seen the spreadsheet video
The spreadsheets are nye! Will you evaluate working classes someday? The new ownership makes this more important, since buildings can be fully owned by workers and some classes have more bonuses (and earlier bonuses) than others.
I reckon that you should build and nationalize the worst buildings in the country too, since less profit means less money deleted by public dividends, and more money freed up at private hands for buying profitable public buildings.
What was the book you mentioned on your previous video on Algebraic notation and the press? Will you do a Generalist Ideas on it? I might be interested for citing in my PhD.
I read it before I did reviews on YT I think, but here's the book: www.amazon.com/After-Thought-Computer-Challenge-Intelligence/dp/0465007821
I believe, somebody should make a video, which explains this video 😄
Could someone check the investment pool in the new update? It seems broken, at least on laissez-fair. The gays can't properly invest.
I've always found the gays to be pretty good at investing.
I meant guys. English is not my first language.
Now I can't stop laughing.
children unhided! Very nice video
Yeah spread those sheets.
Nice video!
Hey, I would like to know if you would take players saves and fix them. I have a good Soviet Union Run, but I think the economy is not healthy, and would like to know if you would check it out. I ask mainly to learn how a good economy must look like.
ah fuck you beat me to it, i just played a full game of krakow to test out a few theory to get you some more info but you already made poland lmao.
I watched the other 2 videos about the spreedsheet and understand nothing, lets see now if I understand lol
Main purpose of this video is to direct people to who don't understand other spreadsheet videos so I hope so
Yes, my favourite adult content
The spiciest
These aren't even bare spreadsheets, there's color coding and formatting. Such scandalous content for a video!
You gotta leave something to the imagination
Spreadsheets and coffee what could possibly go wrong
thanks now my brain hurts
Good
1.7.2 patch review?
Tomorrow/Thursday alongside the Dev Diary
It sux.
Spreadsheet stream when….
Imagine what the game's AI could do if it had access to this...
I feel like the ai can see this stuff but is bad at planning ahead
what if generalist gaming was freaky gaming but instead of spreading sheets he spread…
😮
Excelria 3
No happy thursday?? On spreadsheet day?? 😭😭
It was still Wednesday when I published this
bro spreaded his sheets for an hour and didn't even bothered with timestamps 💀💀
Timestamps are in there, but they seem to have gotten bricked for some reason? You can see them in the description
Accountants envy him, devs hate him, click here to know why.
We should all start thinking and talking about 'depeasanting' as 'freeing the cryptobros for the greater good of the country'.
No Kids Allowed, SFW
What did I just watch
The truth
ladies and gentlemen, the goat of vic3 strikes again. all hail the shiny!
This is the real game. The rest is just an interface
The GUI is how they get you
You are all getting too comfortable in youtube.(Luckly Im above 18)
Channel ban speedrun
Reported for showing nude spreadsheets.
Damn
I like your funny words magic man🪄📈