Status
Not open for further replies.

Sir Arkatreides

Second Lieutenant
93 Badges
Dec 30, 2010
128
95
  • Crusader Kings II: Charlemagne
  • Stellaris - Path to Destruction bundle
  • Crusader Kings II: Monks and Mystics
  • Tyranny - Tales from the Tiers
  • Stellaris: Galaxy Edition
  • Europa Universalis IV: Mare Nostrum
  • Europa Universalis IV: Cossacks
  • Cities: Skylines - After Dark
  • Europa Universalis IV: Pre-order
  • Europa Universalis IV: Third Rome
  • Semper Fi
  • Europa Universalis IV: Res Publica
  • Europa Universalis III Complete
  • Heir to the Throne
  • Hearts of Iron III
  • For the Motherland
  • Europa Universalis IV: Wealth of Nations
  • Crusader Kings II
  • 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: Sword of Islam
  • Europa Universalis III
  • Europa Universalis IV: Call to arms event
  • Europa Universalis IV: Conquest of Paradise
  • Europa Universalis IV: Art of War
  • Divine Wind
  • Europa Universalis III Complete
  • Europa Universalis III Complete
  • Cities: Skylines - Mass Transit
  • Steel Division: Normandy 44
  • Stellaris: Digital Anniversary Edition
  • Tyranny: Archon Edition
  • Europa Universalis IV: Rights of Man
  • Crusader Kings II: Reapers Due
  • Hearts of Iron IV: Field Marshal
  • Hearts of Iron IV: Colonel
  • Hearts of Iron IV: Cadet
  • Stellaris: Galaxy Edition
  • Stellaris: Nemesis
  • Europa Universalis IV
  • Crusader Kings II: Conclave
  • Victoria 2
  • Crusader Kings II: Horse Lords
  • Europa Universalis IV: Common Sense
  • Pillars of Eternity
  • Crusader Kings II: Way of Life
  • 500k Club
This is my take on a Division Calculator that takes current upgrade research into account

https://docs.google.com/spreadsheets/d/1KnAlPumx7-cxg0InwzjImYslglFc-TKlcj5nVboOpIA/edit?usp=sharing

How it works
  1. Select your currently produced equipment from the selection on the right on the first tab
  2. Select any variants you have applied to the equipment
  3. Select your upgrade research from the second tab (put 1 for researched, 0 for not)
  4. Select your division composition on the first tab
  5. Enjoy!
Version 1.3 (Dec16)
  • Updated for 'Torch' patch 1.3
Version 1.2 (Sep16)
Version 1.0 (Aug16)
Version 0.91 (1Jul16)
  • Added code for easy conversion to game file template code (as requested by @Invader_Canuck)

Version 0.9 (30Jun16)

  • Added Variants for Equipment

Version 0.7 (29Jun16)

  • Added all support battalions & research
  • Added Equipment & IC requirement
  • General clean-up and more wow

Version 0.2 (28Jun16)
  • Added all armor battalions and equipment
  • Added ability to calculate total IC for Division
  • Fixed issue with DIV/0 in terrain tables in GoogleSheets

Version 0.1 (27Jun16)
  • Not 100% complete yet, some later/heavier tanks/equipment are currently missing and all Anti-Air armor variants are missing. I will be working on this in the next few days.

So far I have been able to recreate any number generated in game, but please let me know if you find any discrepancies.

I also plan to extend it so that you can add variants to the equipment so that the divisions exactly reflect the equipment you use.

Any feedback appreciated!
 
Last edited:
  • 11
  • 1
Reactions:

elfiwolfe

First Lieutenant
79 Badges
Aug 22, 2001
239
102
  • Stellaris: Synthetic Dawn
  • Hearts of Iron IV: Colonel
  • Hearts of Iron IV: Field Marshal
  • Major Wiki Contributor
  • Stellaris: Digital Anniversary Edition
  • Stellaris: Leviathans Story Pack
  • Cities: Skylines - Natural Disasters
  • Stellaris - Path to Destruction bundle
  • Steel Division: Normandy 44
  • Steel Division: Normandy 44 Deluxe Edition
  • BATTLETECH
  • Surviving Mars
  • Hearts of Iron IV: Death or Dishonor
  • Hearts of Iron IV: Cadet
  • Age of Wonders III
  • Age of Wonders
  • Steel Division: Normand 44 - Second Wave
  • Hearts of Iron IV: Expansion Pass
  • Stellaris: Humanoids Species Pack
  • Stellaris: Apocalypse
  • Surviving Mars: Digital Deluxe Edition
  • BATTLETECH - Digital Deluxe Edition
  • BATTLETECH - Beta Backer
  • BATTLETECH - Backer
  • Cities: Skylines - Parklife
  • Stellaris: Nemesis
  • Europa Universalis III Complete
  • Crusader Kings II
  • Crusader Kings II: Sons of Abraham
  • Europa Universalis III
  • Europa Universalis III: Chronicles
  • Europa Universalis III Complete
  • Divine Wind
  • Europa Universalis IV
  • For the Motherland
  • Hearts of Iron III
  • Heir to the Throne
  • Europa Universalis III Complete
  • Magicka
  • Cities in Motion
  • Semper Fi
  • Sword of the Stars
  • Sword of the Stars II
  • Supreme Ruler 2020
  • Warlock: Master of the Arcane
  • 500k Club
  • Cities: Skylines
  • Stellaris
  • Stellaris: Galaxy Edition
  • Stellaris: Galaxy Edition
Ouch. I spent all that time building one pulling data from equipment by version and adding to unit stats (with adjustments from code).
And you out did that.
https://docs.google.com/spreadsheets/d/18Q9Pn5mnX64WwuAp9SRacXQtWMVc_SmSYLm9MX3eRws/edit?usp=sharing

There is several units that have adjustments to the equipment. and for Mech it is adding Mech and INF stats together and then using a multiplier.
From the above spreadsheet on the Unit page, if there is a unit listed as "... base" then that is made from the unit + equipment and then there the unit that applies a multiplier to a stat and that makes the real unit.

examples.:
Inf
Mountain applies a +30% to breakthrough to the equipment breakthrough
Artillery battalions applies a +25% to soft attack to the equipment soft attack.
All tanks get a +50% to soft attack
Mech are Inf soft +10%, Inf hard +400%, Inf Def + mech def, inf breakthrough + mech Breakthrough, inf piercing + mech piercing
SPAA get +50% to soft
Support AA, ART, Rock, AT are -40%

PS. I really like your sheet over mine.
 
  • 2
Reactions:

SchwarzKatze

Field Marshal
46 Badges
Nov 8, 2008
5.250
3.476
  • Europa Universalis IV
  • Stellaris
  • Hearts of Iron IV: Expansion Pass
  • Crusader Kings III
Ouch. I spent all that time building one pulling data from equipment by version and adding to unit stats (with adjustments from code).
And you out did that.
https://docs.google.com/spreadsheets/d/18Q9Pn5mnX64WwuAp9SRacXQtWMVc_SmSYLm9MX3eRws/edit?usp=sharing

There is several units that have adjustments to the equipment. and for Mech it is adding Mech and INF stats together and then using a multiplier.
From the above spreadsheet on the Unit page, if there is a unit listed as "... base" then that is made from the unit + equipment and then there the unit that applies a multiplier to a stat and that makes the real unit.

examples.:
Inf
Mountain applies a +30% to breakthrough to the equipment breakthrough
Artillery battalions applies a +25% to soft attack to the equipment soft attack.
All tanks get a +50% to soft attack
Mech are Inf soft +10%, Inf hard +400%, Inf Def + mech def, inf breakthrough + mech Breakthrough, inf piercing + mech piercing
SPAA get +50% to soft
Support AA, ART, Rock, AT are -40%

PS. I really like your sheet over mine.
Hey you're the one who filled the equipment table on the wiki! Thank you for your effort:)
 
  • 3
Reactions:

Sir Arkatreides

Second Lieutenant
93 Badges
Dec 30, 2010
128
95
  • Crusader Kings II: Charlemagne
  • Stellaris - Path to Destruction bundle
  • Crusader Kings II: Monks and Mystics
  • Tyranny - Tales from the Tiers
  • Stellaris: Galaxy Edition
  • Europa Universalis IV: Mare Nostrum
  • Europa Universalis IV: Cossacks
  • Cities: Skylines - After Dark
  • Europa Universalis IV: Pre-order
  • Europa Universalis IV: Third Rome
  • Semper Fi
  • Europa Universalis IV: Res Publica
  • Europa Universalis III Complete
  • Heir to the Throne
  • Hearts of Iron III
  • For the Motherland
  • Europa Universalis IV: Wealth of Nations
  • Crusader Kings II
  • 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: Sword of Islam
  • Europa Universalis III
  • Europa Universalis IV: Call to arms event
  • Europa Universalis IV: Conquest of Paradise
  • Europa Universalis IV: Art of War
  • Divine Wind
  • Europa Universalis III Complete
  • Europa Universalis III Complete
  • Cities: Skylines - Mass Transit
  • Steel Division: Normandy 44
  • Stellaris: Digital Anniversary Edition
  • Tyranny: Archon Edition
  • Europa Universalis IV: Rights of Man
  • Crusader Kings II: Reapers Due
  • Hearts of Iron IV: Field Marshal
  • Hearts of Iron IV: Colonel
  • Hearts of Iron IV: Cadet
  • Stellaris: Galaxy Edition
  • Stellaris: Nemesis
  • Europa Universalis IV
  • Crusader Kings II: Conclave
  • Victoria 2
  • Crusader Kings II: Horse Lords
  • Europa Universalis IV: Common Sense
  • Pillars of Eternity
  • Crusader Kings II: Way of Life
  • 500k Club
Elfiwolfe - thanks for the encouraging words.
For Hardness and some other stats, support battalions are treated in a different manner (e.g. hardness is completely ignored for them, terrain bonuses are added to the line average, etc.). A lot of this was trial and error.

I will be uploading another version in a few hours. I am almost done adding all the divisions and equipment. I will work on variants next.
 
  • 1
  • 1
Reactions:

Sir Arkatreides

Second Lieutenant
93 Badges
Dec 30, 2010
128
95
  • Crusader Kings II: Charlemagne
  • Stellaris - Path to Destruction bundle
  • Crusader Kings II: Monks and Mystics
  • Tyranny - Tales from the Tiers
  • Stellaris: Galaxy Edition
  • Europa Universalis IV: Mare Nostrum
  • Europa Universalis IV: Cossacks
  • Cities: Skylines - After Dark
  • Europa Universalis IV: Pre-order
  • Europa Universalis IV: Third Rome
  • Semper Fi
  • Europa Universalis IV: Res Publica
  • Europa Universalis III Complete
  • Heir to the Throne
  • Hearts of Iron III
  • For the Motherland
  • Europa Universalis IV: Wealth of Nations
  • Crusader Kings II
  • 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: Sword of Islam
  • Europa Universalis III
  • Europa Universalis IV: Call to arms event
  • Europa Universalis IV: Conquest of Paradise
  • Europa Universalis IV: Art of War
  • Divine Wind
  • Europa Universalis III Complete
  • Europa Universalis III Complete
  • Cities: Skylines - Mass Transit
  • Steel Division: Normandy 44
  • Stellaris: Digital Anniversary Edition
  • Tyranny: Archon Edition
  • Europa Universalis IV: Rights of Man
  • Crusader Kings II: Reapers Due
  • Hearts of Iron IV: Field Marshal
  • Hearts of Iron IV: Colonel
  • Hearts of Iron IV: Cadet
  • Stellaris: Galaxy Edition
  • Stellaris: Nemesis
  • Europa Universalis IV
  • Crusader Kings II: Conclave
  • Victoria 2
  • Crusader Kings II: Horse Lords
  • Europa Universalis IV: Common Sense
  • Pillars of Eternity
  • Crusader Kings II: Way of Life
  • 500k Club
  • 1
  • 1
Reactions:

Sir Arkatreides

Second Lieutenant
93 Badges
Dec 30, 2010
128
95
  • Crusader Kings II: Charlemagne
  • Stellaris - Path to Destruction bundle
  • Crusader Kings II: Monks and Mystics
  • Tyranny - Tales from the Tiers
  • Stellaris: Galaxy Edition
  • Europa Universalis IV: Mare Nostrum
  • Europa Universalis IV: Cossacks
  • Cities: Skylines - After Dark
  • Europa Universalis IV: Pre-order
  • Europa Universalis IV: Third Rome
  • Semper Fi
  • Europa Universalis IV: Res Publica
  • Europa Universalis III Complete
  • Heir to the Throne
  • Hearts of Iron III
  • For the Motherland
  • Europa Universalis IV: Wealth of Nations
  • Crusader Kings II
  • 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: Sword of Islam
  • Europa Universalis III
  • Europa Universalis IV: Call to arms event
  • Europa Universalis IV: Conquest of Paradise
  • Europa Universalis IV: Art of War
  • Divine Wind
  • Europa Universalis III Complete
  • Europa Universalis III Complete
  • Cities: Skylines - Mass Transit
  • Steel Division: Normandy 44
  • Stellaris: Digital Anniversary Edition
  • Tyranny: Archon Edition
  • Europa Universalis IV: Rights of Man
  • Crusader Kings II: Reapers Due
  • Hearts of Iron IV: Field Marshal
  • Hearts of Iron IV: Colonel
  • Hearts of Iron IV: Cadet
  • Stellaris: Galaxy Edition
  • Stellaris: Nemesis
  • Europa Universalis IV
  • Crusader Kings II: Conclave
  • Victoria 2
  • Crusader Kings II: Horse Lords
  • Europa Universalis IV: Common Sense
  • Pillars of Eternity
  • Crusader Kings II: Way of Life
  • 500k Club
New version uploaded (same link)

Added
  • All Support battalions and their research
  • Rearranged the sheet to make it look better
  • Updated some of the logic to make it easier to read
 
  • 1
  • 1
Reactions:

Vale777

Sergeant
47 Badges
Feb 2, 2013
60
15
  • Crusader Kings II: Charlemagne
  • Stellaris - Path to Destruction bundle
  • Rome: Vae Victis
  • Victoria 2: Heart of Darkness
  • Victoria 2: A House Divided
  • Crusader Kings II
  • Sengoku
  • Rome Gold
  • Victoria: Revolutions
  • March of the Eagles
  • The Kings Crusade
  • Darkest Hour
  • Crusader Kings II: Sword of Islam
  • Crusader Kings II: Sunset Invasion
  • Crusader Kings II: Sons of Abraham
  • Crusader Kings II: The Republic
  • Crusader Kings II: Rajas of India
  • Crusader Kings II: The Old Gods
  • Crusader Kings II: Legacy of Rome
  • Europa Universalis III: Chronicles
  • Hearts of Iron IV: Together for Victory
  • Crusader Kings II: Monks and Mystics
  • Crusader Kings III: Royal Edition
  • Hearts of Iron IV: Death or Dishonor
  • Stellaris: Synthetic Dawn
  • Crusader Kings II: Jade Dragon
  • Hearts of Iron IV: Expansion Pass
  • Stellaris: Apocalypse
  • Hearts of Iron IV: Expansion Pass
  • Stellaris: Distant Stars
  • Crusader Kings II: Holy Fury
  • Crusader Kings III
  • Stellaris: Leviathans Story Pack
  • Crusader Kings II: Reapers Due
  • Hearts of Iron IV: Colonel
  • Hearts of Iron IV: Cadet
  • Hearts of Iron IV Sign-up
  • Stellaris
  • Crusader Kings II: Conclave
  • Crusader Kings II: Horse Lords
  • Crusader Kings II: Way of Life
  • Mount & Blade: With Fire and Sword
  • Mount & Blade: Warband
  • 500k Club
  • Victoria 2
  • Steel Division: Normandy 44
  • Hearts of Iron IV: Expansion Pass
Wow! Great work! I gotta ask, do you work in Excel/data base for living? I have seen a lot of spreadsheets, but this one is a beauty. Would you mind if I use the layout as a base for a mod I am helping with? It is such a good design, that it would be very handy to keep the layout and add new info. If not, that is cool too.
 
  • 1
Reactions:

Invader_Canuck

General
10 Badges
Apr 20, 2006
2.226
2.412
  • Crusader Kings II
  • Europa Universalis IV
  • Europa Universalis IV: Call to arms event
  • Hearts of Iron III
  • Europa Universalis: Rome
  • Semper Fi
  • 500k Club
  • Europa Universalis IV: Pre-order
  • Hearts of Iron IV Sign-up
  • Stellaris Sign-up
This might sound crazy, but, is it possible for you to add a feature (depending on how much work it is!)That would be export the template in the calculator to the text based format the game uses. If you did this, I would love you long time!

IE

Code:
division_template = {
    name = "Tankovaya-Diviziya '39"

    regiments = {
        medium_armor = { x = 0 y = 0 }
        medium_armor = { x = 0 y = 1 }
        medium_armor = { x = 0 y = 2 }
        medium_armor = { x = 0 y = 3 }
        motorized = { x = 1 y = 0 }
        motorized = { x = 1 y = 1 }
        motorized = { x = 1 y = 2 }
        motorized = { x = 1 y = 3 }
    }
   
    support = {
           engineer = { x = 0 y = 0 }
    }
}
 

Sir Arkatreides

Second Lieutenant
93 Badges
Dec 30, 2010
128
95
  • Crusader Kings II: Charlemagne
  • Stellaris - Path to Destruction bundle
  • Crusader Kings II: Monks and Mystics
  • Tyranny - Tales from the Tiers
  • Stellaris: Galaxy Edition
  • Europa Universalis IV: Mare Nostrum
  • Europa Universalis IV: Cossacks
  • Cities: Skylines - After Dark
  • Europa Universalis IV: Pre-order
  • Europa Universalis IV: Third Rome
  • Semper Fi
  • Europa Universalis IV: Res Publica
  • Europa Universalis III Complete
  • Heir to the Throne
  • Hearts of Iron III
  • For the Motherland
  • Europa Universalis IV: Wealth of Nations
  • Crusader Kings II
  • 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: Sword of Islam
  • Europa Universalis III
  • Europa Universalis IV: Call to arms event
  • Europa Universalis IV: Conquest of Paradise
  • Europa Universalis IV: Art of War
  • Divine Wind
  • Europa Universalis III Complete
  • Europa Universalis III Complete
  • Cities: Skylines - Mass Transit
  • Steel Division: Normandy 44
  • Stellaris: Digital Anniversary Edition
  • Tyranny: Archon Edition
  • Europa Universalis IV: Rights of Man
  • Crusader Kings II: Reapers Due
  • Hearts of Iron IV: Field Marshal
  • Hearts of Iron IV: Colonel
  • Hearts of Iron IV: Cadet
  • Stellaris: Galaxy Edition
  • Stellaris: Nemesis
  • Europa Universalis IV
  • Crusader Kings II: Conclave
  • Victoria 2
  • Crusader Kings II: Horse Lords
  • Europa Universalis IV: Common Sense
  • Pillars of Eternity
  • Crusader Kings II: Way of Life
  • 500k Club
Wow! Great work! I gotta ask, do you work in Excel/data base for living? I have seen a lot of spreadsheets, but this one is a beauty. Would you mind if I use the layout as a base for a mod I am helping with? It is such a good design, that it would be very handy to keep the layout and add new info. If not, that is cool too.

Thanks. I use Excel a lot for 'games support' but not really that much at work. None of this is very hard, just a bunch of lookup tables.

You are more than welcome to use it for whatever purpose you want. If you find it useful for your mod, that's great, please use it (a shout-out would be nice ;)).

I think the way it is designed it is fairly agnostic to the data. There are only a handful of places where I had to hardcode something (from the top of my head this is the 'fake' cavalry equipment to get the speed bonus and the Engineer Company upgrade bonus to terrain). Also remember that the columns need to be consistent across sheets as the vlookup() relies heavily on column(), so if you add any Equipment types please be aware that inserting columns in one sheet might mess up the order in another. I could have put it all on one helper sheet, but prefer the small overhead of adding new columns on multiple sheets in order to retain clarity.

Let me know if you have any questions

This might sound crazy, but, is it possible for you to add a feature (depending on how much work it is!)That would be export the template in the calculator to the text based format the game uses. If you did this, I would love you long time!

IE

Code:
division_template = {
    name = "Tankovaya-Diviziya '39"

    regiments = {
        medium_armor = { x = 0 y = 0 }
        medium_armor = { x = 0 y = 1 }
        medium_armor = { x = 0 y = 2 }
        medium_armor = { x = 0 y = 3 }
        motorized = { x = 1 y = 0 }
        motorized = { x = 1 y = 1 }
        motorized = { x = 1 y = 2 }
        motorized = { x = 1 y = 3 }
    }
  
    support = {
           engineer = { x = 0 y = 0 }
    }
}

I will take a look. This definitely can be done with some VBA, but I prefer to keep the sheet VBA/Macro free. Might still be doable with some clever lookup and string concatenation though.
 
  • 1
  • 1
Reactions:

Sir Arkatreides

Second Lieutenant
93 Badges
Dec 30, 2010
128
95
  • Crusader Kings II: Charlemagne
  • Stellaris - Path to Destruction bundle
  • Crusader Kings II: Monks and Mystics
  • Tyranny - Tales from the Tiers
  • Stellaris: Galaxy Edition
  • Europa Universalis IV: Mare Nostrum
  • Europa Universalis IV: Cossacks
  • Cities: Skylines - After Dark
  • Europa Universalis IV: Pre-order
  • Europa Universalis IV: Third Rome
  • Semper Fi
  • Europa Universalis IV: Res Publica
  • Europa Universalis III Complete
  • Heir to the Throne
  • Hearts of Iron III
  • For the Motherland
  • Europa Universalis IV: Wealth of Nations
  • Crusader Kings II
  • 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: Sword of Islam
  • Europa Universalis III
  • Europa Universalis IV: Call to arms event
  • Europa Universalis IV: Conquest of Paradise
  • Europa Universalis IV: Art of War
  • Divine Wind
  • Europa Universalis III Complete
  • Europa Universalis III Complete
  • Cities: Skylines - Mass Transit
  • Steel Division: Normandy 44
  • Stellaris: Digital Anniversary Edition
  • Tyranny: Archon Edition
  • Europa Universalis IV: Rights of Man
  • Crusader Kings II: Reapers Due
  • Hearts of Iron IV: Field Marshal
  • Hearts of Iron IV: Colonel
  • Hearts of Iron IV: Cadet
  • Stellaris: Galaxy Edition
  • Stellaris: Nemesis
  • Europa Universalis IV
  • Crusader Kings II: Conclave
  • Victoria 2
  • Crusader Kings II: Horse Lords
  • Europa Universalis IV: Common Sense
  • Pillars of Eternity
  • Crusader Kings II: Way of Life
  • 500k Club
I will take a look. This definitely can be done with some VBA, but I prefer to keep the sheet VBA/Macro free. Might still be doable with some clever lookup and string concatenation though.

Turns out this is a lot easier than I expected. Take a look at latest version and let me know if this is what you are after.
 
  • 1
  • 1
Reactions:

Invader_Canuck

General
10 Badges
Apr 20, 2006
2.226
2.412
  • Crusader Kings II
  • Europa Universalis IV
  • Europa Universalis IV: Call to arms event
  • Hearts of Iron III
  • Europa Universalis: Rome
  • Semper Fi
  • 500k Club
  • Europa Universalis IV: Pre-order
  • Hearts of Iron IV Sign-up
  • Stellaris Sign-up
Turns out this is a lot easier than I expected. Take a look at latest version and let me know if this is what you are after.

Yea, that's exactly what I was looking for!

I'm slogging through like 180 template builds right now, and I spend more time cutting and pasting templates from other divisions, then swapping stuff around than actually planning them out :)

Thank you kindly!

Edit - Do you also get the little vertical lines and extra " marks when you paste the template? They can be cleaned up, but I'm wondering if I am doing it wrong.
 
Last edited:
  • 1
Reactions:

Sir Arkatreides

Second Lieutenant
93 Badges
Dec 30, 2010
128
95
  • Crusader Kings II: Charlemagne
  • Stellaris - Path to Destruction bundle
  • Crusader Kings II: Monks and Mystics
  • Tyranny - Tales from the Tiers
  • Stellaris: Galaxy Edition
  • Europa Universalis IV: Mare Nostrum
  • Europa Universalis IV: Cossacks
  • Cities: Skylines - After Dark
  • Europa Universalis IV: Pre-order
  • Europa Universalis IV: Third Rome
  • Semper Fi
  • Europa Universalis IV: Res Publica
  • Europa Universalis III Complete
  • Heir to the Throne
  • Hearts of Iron III
  • For the Motherland
  • Europa Universalis IV: Wealth of Nations
  • Crusader Kings II
  • 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: Sword of Islam
  • Europa Universalis III
  • Europa Universalis IV: Call to arms event
  • Europa Universalis IV: Conquest of Paradise
  • Europa Universalis IV: Art of War
  • Divine Wind
  • Europa Universalis III Complete
  • Europa Universalis III Complete
  • Cities: Skylines - Mass Transit
  • Steel Division: Normandy 44
  • Stellaris: Digital Anniversary Edition
  • Tyranny: Archon Edition
  • Europa Universalis IV: Rights of Man
  • Crusader Kings II: Reapers Due
  • Hearts of Iron IV: Field Marshal
  • Hearts of Iron IV: Colonel
  • Hearts of Iron IV: Cadet
  • Stellaris: Galaxy Edition
  • Stellaris: Nemesis
  • Europa Universalis IV
  • Crusader Kings II: Conclave
  • Victoria 2
  • Crusader Kings II: Horse Lords
  • Europa Universalis IV: Common Sense
  • Pillars of Eternity
  • Crusader Kings II: Way of Life
  • 500k Club
Edit - Do you also get the little vertical lines and extra " marks when you paste the template? They can be cleaned up, but I'm wondering if I am doing it wrong.

Pasting it directly into Notepad confuses it I think because the Excel newline char is different from what Notepad expects. However if you paste it into Word/WordPad first and the copy from there to Notepad it is ok.
 
  • 1
  • 1
Reactions:

Sir Arkatreides

Second Lieutenant
93 Badges
Dec 30, 2010
128
95
  • Crusader Kings II: Charlemagne
  • Stellaris - Path to Destruction bundle
  • Crusader Kings II: Monks and Mystics
  • Tyranny - Tales from the Tiers
  • Stellaris: Galaxy Edition
  • Europa Universalis IV: Mare Nostrum
  • Europa Universalis IV: Cossacks
  • Cities: Skylines - After Dark
  • Europa Universalis IV: Pre-order
  • Europa Universalis IV: Third Rome
  • Semper Fi
  • Europa Universalis IV: Res Publica
  • Europa Universalis III Complete
  • Heir to the Throne
  • Hearts of Iron III
  • For the Motherland
  • Europa Universalis IV: Wealth of Nations
  • Crusader Kings II
  • 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: Sword of Islam
  • Europa Universalis III
  • Europa Universalis IV: Call to arms event
  • Europa Universalis IV: Conquest of Paradise
  • Europa Universalis IV: Art of War
  • Divine Wind
  • Europa Universalis III Complete
  • Europa Universalis III Complete
  • Cities: Skylines - Mass Transit
  • Steel Division: Normandy 44
  • Stellaris: Digital Anniversary Edition
  • Tyranny: Archon Edition
  • Europa Universalis IV: Rights of Man
  • Crusader Kings II: Reapers Due
  • Hearts of Iron IV: Field Marshal
  • Hearts of Iron IV: Colonel
  • Hearts of Iron IV: Cadet
  • Stellaris: Galaxy Edition
  • Stellaris: Nemesis
  • Europa Universalis IV
  • Crusader Kings II: Conclave
  • Victoria 2
  • Crusader Kings II: Horse Lords
  • Europa Universalis IV: Common Sense
  • Pillars of Eternity
  • Crusader Kings II: Way of Life
  • 500k Club
How do you protect the page? I had to lock anonymous users to view only due to swastika Vandalism.

They keep changing the color of editable spaces.

The sheet cannot be edited online - when you open it in googledocs, you actually create your own, local version. That way the original never gets 'destroyed'.
 
  • 1
  • 1
Reactions:

Sir Arkatreides

Second Lieutenant
93 Badges
Dec 30, 2010
128
95
  • Crusader Kings II: Charlemagne
  • Stellaris - Path to Destruction bundle
  • Crusader Kings II: Monks and Mystics
  • Tyranny - Tales from the Tiers
  • Stellaris: Galaxy Edition
  • Europa Universalis IV: Mare Nostrum
  • Europa Universalis IV: Cossacks
  • Cities: Skylines - After Dark
  • Europa Universalis IV: Pre-order
  • Europa Universalis IV: Third Rome
  • Semper Fi
  • Europa Universalis IV: Res Publica
  • Europa Universalis III Complete
  • Heir to the Throne
  • Hearts of Iron III
  • For the Motherland
  • Europa Universalis IV: Wealth of Nations
  • Crusader Kings II
  • 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: Sword of Islam
  • Europa Universalis III
  • Europa Universalis IV: Call to arms event
  • Europa Universalis IV: Conquest of Paradise
  • Europa Universalis IV: Art of War
  • Divine Wind
  • Europa Universalis III Complete
  • Europa Universalis III Complete
  • Cities: Skylines - Mass Transit
  • Steel Division: Normandy 44
  • Stellaris: Digital Anniversary Edition
  • Tyranny: Archon Edition
  • Europa Universalis IV: Rights of Man
  • Crusader Kings II: Reapers Due
  • Hearts of Iron IV: Field Marshal
  • Hearts of Iron IV: Colonel
  • Hearts of Iron IV: Cadet
  • Stellaris: Galaxy Edition
  • Stellaris: Nemesis
  • Europa Universalis IV
  • Crusader Kings II: Conclave
  • Victoria 2
  • Crusader Kings II: Horse Lords
  • Europa Universalis IV: Common Sense
  • Pillars of Eternity
  • Crusader Kings II: Way of Life
  • 500k Club
To the person who put 'Respectfully Disagree' on every single post just now

Not that it particularly matters but I do wonder:
1) Where you think there is anything in this thread that is worth disagreeing (or agreeing for that matter) with?
2) Why, if you have something to add or criticise, you don't just post it here so we can all discuss it?

With regards
 
  • 3
Reactions:

elfiwolfe

First Lieutenant
79 Badges
Aug 22, 2001
239
102
  • Stellaris: Synthetic Dawn
  • Hearts of Iron IV: Colonel
  • Hearts of Iron IV: Field Marshal
  • Major Wiki Contributor
  • Stellaris: Digital Anniversary Edition
  • Stellaris: Leviathans Story Pack
  • Cities: Skylines - Natural Disasters
  • Stellaris - Path to Destruction bundle
  • Steel Division: Normandy 44
  • Steel Division: Normandy 44 Deluxe Edition
  • BATTLETECH
  • Surviving Mars
  • Hearts of Iron IV: Death or Dishonor
  • Hearts of Iron IV: Cadet
  • Age of Wonders III
  • Age of Wonders
  • Steel Division: Normand 44 - Second Wave
  • Hearts of Iron IV: Expansion Pass
  • Stellaris: Humanoids Species Pack
  • Stellaris: Apocalypse
  • Surviving Mars: Digital Deluxe Edition
  • BATTLETECH - Digital Deluxe Edition
  • BATTLETECH - Beta Backer
  • BATTLETECH - Backer
  • Cities: Skylines - Parklife
  • Stellaris: Nemesis
  • Europa Universalis III Complete
  • Crusader Kings II
  • Crusader Kings II: Sons of Abraham
  • Europa Universalis III
  • Europa Universalis III: Chronicles
  • Europa Universalis III Complete
  • Divine Wind
  • Europa Universalis IV
  • For the Motherland
  • Hearts of Iron III
  • Heir to the Throne
  • Europa Universalis III Complete
  • Magicka
  • Cities in Motion
  • Semper Fi
  • Sword of the Stars
  • Sword of the Stars II
  • Supreme Ruler 2020
  • Warlock: Master of the Arcane
  • 500k Club
  • Cities: Skylines
  • Stellaris
  • Stellaris: Galaxy Edition
  • Stellaris: Galaxy Edition
The sheet cannot be edited online - when you open it in googledocs, you actually create your own, local version. That way the original never gets 'destroyed'.
Oh. how did you do that?

Ah I think I see how.
You uploaded as an exel file. So google sheets does not directly open that but makes a copy and translate that to google sheets in the users folder.
 
Last edited:
Status
Not open for further replies.