Spreadsheet - Resource History For Significant HOI4 Versions

Spreadsheet - Resource History For Significant HOI4 Versions

  • Crusader Kings III Available Now!

    The realm rejoices as Paradox Interactive announces the launch of Crusader Kings III, the latest entry in the publisher’s grand strategy role-playing game franchise. Advisors may now jockey for positions of influence and adversaries should save their schemes for another day, because on this day Crusader Kings III can be purchased on Steam, the Paradox Store, and other major online retailers.


    Real Strategy Requires Cunning

Mister Analyst

Major
35 Badges
Jul 27, 2018
739
395
  • Victoria 2
  • Hearts of Iron IV: Expansion Pass
  • Hearts of Iron IV: Expansion Pass
  • Age of Wonders III
  • Hearts of Iron IV: Death or Dishonor
  • Knights of Honor
  • Hearts of Iron IV: Together for Victory
  • Hearts of Iron IV: Colonel
  • Hearts of Iron IV: Cadet
  • Mount & Blade: Warband
  • Pride of Nations
  • Cities: Skylines
  • Warlock: Master of the Arcane
  • Hearts of Iron III Collection
  • Arsenal of Democracy
  • Crusader Kings II
  • Age of Wonders: Shadow Magic
  • Darkest Hour
  • Dungeonland
  • Europa Universalis III
  • For the Motherland
  • Hearts of Iron III
  • Hearts of Iron III: Their Finest Hour
  • Pillars of Eternity
  • Victoria: Revolutions
  • Impire
  • King Arthur II
  • Warlock 2: The Exiled
  • The Kings Crusade
  • Victoria 2: Heart of Darkness
  • Victoria 2: A House Divided
  • Majesty 2 Collection
  • Sword of the Stars
  • Semper Fi
Everyone,

The attached file is an Excel spreadsheet showing the resource history for significant versions of HOI4. The versions included are listed as follows:
  • 1.0.0
  • 1.1.0
  • 1.2.1
  • 1.3.3
  • 1.4.2
  • 1.5.4
  • 1.6.2
  • 1.7.1
  • 1.8.2
  • 1.9.3
There are a total of 21 tabs in the spreadsheet as follows:
  • Notes and Credits - 1 tab
  • Countries - 10 tabs
  • States - 10 tabs
This is a highly accurate spreadsheet as the majority of the information was generated by @bitmode modified Pyradox script and calculated using Excel formulas. This spreadsheet was inspired by forum member @billcorr .

If anyone finds an error or would like to provide feedback, then please contact me via a post on this forum or via a private message (PM).

Thank you for your attention.
 

Attachments

  • 3Like
  • 3Love
  • 3
Reactions:

Axe99

Ships for Victory
117 Badges
Feb 13, 2003
14.761
8.946
  • Crusader Kings II: The Republic
  • Crusader Kings III
  • Europa Universalis IV: Art of War
  • Europa Universalis IV: Conquest of Paradise
  • Europa Universalis IV: Call to arms event
  • For The Glory
  • For the Motherland
  • Hearts of Iron III
  • Hearts of Iron III: Their Finest Hour
  • Heir to the Throne
  • Europa Universalis III Complete
  • Lead and Gold
  • The Kings Crusade
  • Magicka
  • Majesty 2
  • Majesty 2 Collection
  • March of the Eagles
  • Europa Universalis III Complete
  • Europa Universalis IV: Res Publica
  • Victoria: Revolutions
  • Rome Gold
  • Semper Fi
  • Ship Simulator Extremes
  • Sword of the Stars
  • Supreme Ruler 2020
  • Victoria 2
  • Victoria 2: A House Divided
  • Victoria 2: Heart of Darkness
  • Rome: Vae Victis
  • 500k Club
  • Cities: Skylines
  • Europa Universalis IV: El Dorado
  • Europa Universalis IV: Pre-order
  • Pride of Nations
  • Rise of Prussia
  • Crusader Kings II: Way of Life
  • Europa Universalis IV: Common Sense
  • Crusader Kings II: Horse Lords
  • Cities: Skylines - After Dark
  • Europa Universalis IV: Cossacks
  • Crusader Kings II: Conclave
  • Cities: Skylines - Snowfall
  • Europa Universalis IV: Mare Nostrum
  • Stellaris
  • Stellaris: Galaxy Edition
  • Stellaris: Galaxy Edition
  • Hearts of Iron IV Sign-up
  • Stellaris Sign-up
  • Hearts of Iron IV: Cadet
Sensational work Mister Analyst - this is very helpful for balancing resources :)
 
  • 1
  • 1Like
Reactions:

Secret Master

Covert Mastermind
Demi Moderator
79 Badges
Jul 9, 2001
33.947
11.616
  • 200k Club
  • Europa Universalis III Complete
  • Victoria: Revolutions
  • Europa Universalis: Rome
  • Semper Fi
  • Sengoku
  • Ship Simulator Extremes
  • Sword of the Stars II
  • Victoria 2
  • Victoria 2: A House Divided
  • Victoria 2: Heart of Darkness
  • Rome: Vae Victis
  • Warlock: Master of the Arcane
  • March of the Eagles
  • 500k Club
  • Crusader Kings II: Holy Knight (pre-order)
  • Pride of Nations
  • Mount & Blade: Warband
  • Mount & Blade: With Fire and Sword
  • Crusader Kings II: Way of Life
  • Pillars of Eternity
  • Crusader Kings II: Horse Lords
  • Crusader Kings II: Limited Collectors Edition
  • Crusader Kings II: Conclave
  • Achtung Panzer
  • Crusader Kings III: Royal Edition
  • Europa Universalis III
  • A Game of Dwarves
  • Crusader Kings II
  • Crusader Kings II: Charlemagne
  • Crusader Kings II: Legacy of Rome
  • Crusader Kings II: The Old Gods
  • Crusader Kings II: Rajas of India
  • Crusader Kings II: The Republic
  • Crusader Kings II: Sons of Abraham
  • Crusader Kings II: Sunset Invasion
  • Crusader Kings II: Sword of Islam
  • Commander: Conquest of the Americas
  • Deus Vult
  • Europa Universalis III: Chronicles
  • Divine Wind
  • Europa Universalis IV: Conquest of Paradise
  • For the Motherland
  • Hearts of Iron III
  • Hearts of Iron III Collection
  • Heir to the Throne
  • Europa Universalis III Complete
  • King Arthur II
  • The Kings Crusade
Would you mind posting this on the wiki? :)
 

Voigt

Lt. General
63 Badges
Mar 15, 2012
1.486
842
  • Hearts of Iron IV: Expansion Pass
  • Crusader Kings III
Quite interesting that the ressources went quite down from 1.4.2. to 1.5.4 with the introduction of ressource gain of Infrastructure.
Base Oil before 2035 which went to base oil 1216 which gets adjusted by starting Infra to 1803. So still 200 Oil, roughly 10% less oil from before.

And this is similar to other ressources, 10% decrease overall with strating Infra, but of course you can now overcome the starting ressources quite easily by upgrading Infra, like USA can generate lots and lots of Oil by upgrading Infrastructure in Texas and California to level 10.
 

Secret Master

Covert Mastermind
Demi Moderator
79 Badges
Jul 9, 2001
33.947
11.616
  • 200k Club
  • Europa Universalis III Complete
  • Victoria: Revolutions
  • Europa Universalis: Rome
  • Semper Fi
  • Sengoku
  • Ship Simulator Extremes
  • Sword of the Stars II
  • Victoria 2
  • Victoria 2: A House Divided
  • Victoria 2: Heart of Darkness
  • Rome: Vae Victis
  • Warlock: Master of the Arcane
  • March of the Eagles
  • 500k Club
  • Crusader Kings II: Holy Knight (pre-order)
  • Pride of Nations
  • Mount & Blade: Warband
  • Mount & Blade: With Fire and Sword
  • Crusader Kings II: Way of Life
  • Pillars of Eternity
  • Crusader Kings II: Horse Lords
  • Crusader Kings II: Limited Collectors Edition
  • Crusader Kings II: Conclave
  • Achtung Panzer
  • Crusader Kings III: Royal Edition
  • Europa Universalis III
  • A Game of Dwarves
  • Crusader Kings II
  • Crusader Kings II: Charlemagne
  • Crusader Kings II: Legacy of Rome
  • Crusader Kings II: The Old Gods
  • Crusader Kings II: Rajas of India
  • Crusader Kings II: The Republic
  • Crusader Kings II: Sons of Abraham
  • Crusader Kings II: Sunset Invasion
  • Crusader Kings II: Sword of Islam
  • Commander: Conquest of the Americas
  • Deus Vult
  • Europa Universalis III: Chronicles
  • Divine Wind
  • Europa Universalis IV: Conquest of Paradise
  • For the Motherland
  • Hearts of Iron III
  • Hearts of Iron III Collection
  • Heir to the Throne
  • Europa Universalis III Complete
  • King Arthur II
  • The Kings Crusade
I'm not a wiki expert, but someone who knows about organizing that stuff might want to somehow link or merge those things. The spreadsheet has more information than the page, but they probably should be together.
 
  • 2
  • 1
Reactions:

Mousetick

Major
88 Badges
Oct 13, 2012
530
962
  • Crusader Kings II: Monks and Mystics
The List of states does not contain as much information as the spreadsheet, does not contain country summaries, and does not allow filtering and manipulation of data.
So presumably you'd want to keep the data in spreadsheet form, otherwise I don't see how one might be able to filter and manipulate the data once converted to HTML table(s)?

May I suggest a poor's man way of publishing the data:
- Ask the Wiki chief to create a Google account for the Wiki, so you don't use your personal Google account
- Upload the sheets to Google Sheets
- Make the sheets readonly and publish them on Google Sheets
- Link to the Google Sheets document on the Wiki

Wiki visitors may then review/filter the data online (no locally installed spreadsheet software necessary), and download a copy (many formats supported for export) locally if they wish to tinker with it.

1597355903001.png

It's likely Paradox has a policy that prohibits linking to non-Paradox sites from the Wiki, so this won't fly, but I'm throwing this idea out here just in case.
 
  • 1
Reactions:

Mister Analyst

Major
35 Badges
Jul 27, 2018
739
395
  • Victoria 2
  • Hearts of Iron IV: Expansion Pass
  • Hearts of Iron IV: Expansion Pass
  • Age of Wonders III
  • Hearts of Iron IV: Death or Dishonor
  • Knights of Honor
  • Hearts of Iron IV: Together for Victory
  • Hearts of Iron IV: Colonel
  • Hearts of Iron IV: Cadet
  • Mount & Blade: Warband
  • Pride of Nations
  • Cities: Skylines
  • Warlock: Master of the Arcane
  • Hearts of Iron III Collection
  • Arsenal of Democracy
  • Crusader Kings II
  • Age of Wonders: Shadow Magic
  • Darkest Hour
  • Dungeonland
  • Europa Universalis III
  • For the Motherland
  • Hearts of Iron III
  • Hearts of Iron III: Their Finest Hour
  • Pillars of Eternity
  • Victoria: Revolutions
  • Impire
  • King Arthur II
  • Warlock 2: The Exiled
  • The Kings Crusade
  • Victoria 2: Heart of Darkness
  • Victoria 2: A House Divided
  • Majesty 2 Collection
  • Sword of the Stars
  • Semper Fi
  • 2
  • 1
Reactions:

Mister Analyst

Major
35 Badges
Jul 27, 2018
739
395
  • Victoria 2
  • Hearts of Iron IV: Expansion Pass
  • Hearts of Iron IV: Expansion Pass
  • Age of Wonders III
  • Hearts of Iron IV: Death or Dishonor
  • Knights of Honor
  • Hearts of Iron IV: Together for Victory
  • Hearts of Iron IV: Colonel
  • Hearts of Iron IV: Cadet
  • Mount & Blade: Warband
  • Pride of Nations
  • Cities: Skylines
  • Warlock: Master of the Arcane
  • Hearts of Iron III Collection
  • Arsenal of Democracy
  • Crusader Kings II
  • Age of Wonders: Shadow Magic
  • Darkest Hour
  • Dungeonland
  • Europa Universalis III
  • For the Motherland
  • Hearts of Iron III
  • Hearts of Iron III: Their Finest Hour
  • Pillars of Eternity
  • Victoria: Revolutions
  • Impire
  • King Arthur II
  • Warlock 2: The Exiled
  • The Kings Crusade
  • Victoria 2: Heart of Darkness
  • Victoria 2: A House Divided
  • Majesty 2 Collection
  • Sword of the Stars
  • Semper Fi
So presumably you'd want to keep the data in spreadsheet form, otherwise I don't see how one might be able to filter and manipulate the data once converted to HTML table(s)?

May I suggest a poor's man way of publishing the data:
- Ask the Wiki chief to create a Google account for the Wiki, so you don't use your personal Google account
- Upload the sheets to Google Sheets
- Make the sheets readonly and publish them on Google Sheets
- Link to the Google Sheets document on the Wiki

Wiki visitors may then review/filter the data online (no locally installed spreadsheet software necessary), and download a copy (many formats supported for export) locally if they wish to tinker with it.


It's likely Paradox has a policy that prohibits linking to non-Paradox sites from the Wiki, so this won't fly, but I'm throwing this idea out here just in case.
Thanks for trying to help, but I have since linked the original thread to the wiki in 3 places. Forum users can download the Excel spreadsheet and can use free software, such as LibreOffice, to open and view the spreadsheet.
 
  • 1Like
Reactions:

bitmode

Armchair Reverse Engineer
Nov 10, 2016
2.474
1.235
Forum users can download the Excel spreadsheet and can use free software, such as LibreOffice, to open and view the spreadsheet.
The first row in "HOI4v 1.0.0 countries" extends to cell XEP1 for some reason, leading to this warning when opening with LibreOffice:
Screenshot from 2020-08-14 09-52-45.png

The file seems to work fine though after dismissing the warning.
 
  • 1
Reactions: