Jarldom of Eastmarch Spreadsheet

	A	D	E	F	G	H	J	K	L	M	O	P	Q	R	T	U
1	Overview		Economy							Manpower						Guide
2	Overview		Economy							Manpower						Guide
3	Nation	Tax Income			Infrastructure Cost		Base Infantry Manpower				Infantry	Archers	Cavalry	Battlemages
4	Eastmarch	2,001,378.17			1,406,790.00		31,531			Desired Capacity:	21,000	9,525	7,500	6,000	General
5	Ruler Name	Trade Income			Other Income		Base Archer Manpower			Current:	21,000	9,525	7,500	6,000
6	Jarl Alfric Stormcloak	2,590,105.62					20,531			Losses:	0	0	0	0	Welcome to the spreadsheet! This section will serve as a guide on how to use and
7	Ruling Culture	Colonial Income			Other Expenditure		Base Cavalry Manpower			Base Manpower:	31,531	20,531	20,398	12,849	update it. Here are some general rules.
8	Old Nordic	0.00			2,050,000.00		20,398			Remaining:	10,531	11,006	12,898	6,849
9	Ruling Religion	Colonial Cost			Money (Current)		Base Battlemage Manpower			Current Manpower:	2,365	1,540	1,530	964	You can edit blue values whenever you want, unless specified otherwise.
10	Nordic Divines	0.00			2,720,137.78		12,849			New Recruits:	0	0	0	0	Green values can only be updated on Sunday. Never edit yellow values, as those
11	Population	Military Expenditure			Profit					Reserve:	2,365	1,540	1,530	964	are either imported directly from the main spreadsheet or are calculated by a formula.
12	1,470,000	2,386,997.91			-1,252,304.12		Total Manpower			End Manpower:	4,730	3,080	3,060	1,927
13	Infrastructure Level	Naval Expenditure			Money (Next Update)		85,309			Army Next Time:	21,000	9,525	7,500	6,000	Overview
14	15.95	0.00			1,467,833.66					Mercenaries:	0	0	0	0
15			Navy							Divisions					Choose your nation or organization on the "Nation" dropdown. Put your ruler's name
16			Navy							Divisions					in the "Ruler Name" cell. The "Ruling Culture" and "Ruling Religion" cells shows which
17			Weeks to build:	Current:	Being made:	Progress:				Military Expenditure					culture and religion is ruling in your nation. The "Population" cell shows the total
18		Heavy Ship	3	0	0	0				2,386,997.91					population of your nation. The "Infrastructure Level" cell shows the total amount of
19		Light Ship	2	0	0	0				2,386,997.91					infrastructure in your nation.
20		Galley	2	0	0	0
21		Transport	1	0	0	0	Name:	Unused Soldiers Division			Name:	The Great Bear's Own			Manpower
22		Airship	6	0	0	0	Infantry	Archers	Cavalry	Battlemages	Infantry	Archers	Cavalry	Battlemages
23							0	0	0	0	250	250	100	60	The manpower table is separated into four sections, each of them functioning
24		Airships possible?	No	Naval Expenditure:	0.00		Quality	Status	Location	Mage Spec.	Quality	Status	Location	Mage Spec.	independently. There is only a finite number of each type of soldiers, and that number
25			Naval Divisions				50	Active			100	Garrisoned	Windhelm	Destruction	is represented by "Base manpower".
26			Naval Divisions					Total Cost				Total Cost			"Desired Capacity" is the maximum number of soldiers you want to have in the army.
27								0.00				29,875.00			If your actual army ("Current") is smaller than that, it will replenish itself over time, up
28		Name:	Unused Ships Division												to the Desired Capacity. However, it cannot exceed Base manpower either.
29		Infantry	Archers	Cavalry	Battlemages		Name:	Shor's Wrath - Windhelm Garrison			Name:	The Levies of Eastmarch			At each update, Current will be replaced by "Army next time", which is a result of a
30							Infantry	Archers	Cavalry	Battlemages	Infantry	Archers	Cavalry	Battlemages	formula. The "Current Manpower" cell says how many men does your nation
31		Heavy Ship	Light Ship	Galley	Transport	Airship	1,000	1,000	400	940	10,000	8,000	3,500	2,500	have available for recruitment. If you run out of men (through losses in battle), you
32		0	0	0	0	0	Quality	Status	Location	Mage Spec.	Quality	Status	Location	Mage Spec.	won't be able to recruit. They do replenish over time, though. The cell is replaced
33		Quality	Status	Location	Mage Spec.		60	Garrisoned	Windhelm	Destruction	25	Active	Kynesgrove	Restoration	by "End Manpower" each update. "Reserve" says how many men become available.
34		50						Total Cost				Total Cost			"New Recruits" says how many soldiers joins your army next update.
35			Total Cost					132,166.67				1,150,967.74			If you lose any soldiers in battle, write the number in "Losses". Make sure you clear
36			0.00												the cell after you update.
37							Name:	Clan Shatter-Shield's Own			Name:	Clan Cruel-Sea's Own
38		Name:	Naval Division 1				Infantry	Archers	Cavalry	Battlemages	Infantry	Archers	Cavalry	Battlemages	When you set up your sheet, you have to fill in three cells in all four sections.
39		Infantry	Archers	Cavalry	Battlemages		4,750	75	2,500	1,250	5,000	200	1,000	1,250	Fill Desired Capacity and Current with the same number (you can start with an
40							Quality	Status	Location	Mage Spec.	Quality	Status	Location	Mage Spec.	army of any size, essentially (not exceeding Base Manpower, though). Then, set
41		Heavy Ship	Light Ship	Galley	Transport	Airship	60	Active	Kynesgrove	Destruction	35	Active	Kynesgrove	Alteration	Current Manpower to "Remaining".
42								Total Cost				Total Cost
43		Quality	Status	Location	Mage Spec.			636,333.33				437,655.17			Economy
44		50
45			Total Cost				Name:	Division 6			Name:	Division 7			"Trade Income" and "Tax Income" are values imported from your territories. Together
46			0.00				Infantry	Archers	Cavalry	Battlemages	Infantry	Archers	Cavalry	Battlemages	they make up all money that your country provides for you. "Colonial Income" is the
47															tribute that your vassals send to you (if you have any). "Colonial Cost" is the tribute that
48		Name:	Naval Division 2				Quality	Status	Location	Mage Spec.	Quality	Status	Location	Mage Spec.	you send to your liege. "Infrastructure Cost" represents how much the maintenance
49		Infantry	Archers	Cavalry	Battlemages		50				50				of your country's infrastructure cost you. "Military" and "Naval Expenditure" shows
50								Total Cost				Total Cost			the cost of maintenance of your standing army and navy.
51		Heavy Ship	Light Ship	Galley	Transport	Airship		0.00				0.00			"Money (Current)" is how much money you have at the moment. Everyone starts
52															with 2,000,000. Each update, this value will be replaced by "Money (Next Update)".
53		Quality	Status	Location	Mage Spec.		Name:	Division 8			Name:	Division 9			"Profit" shows how much you made or lost with the current update.
54		50					Infantry	Archers	Cavalry	Battlemages	Infantry	Archers	Cavalry	Battlemages	"Other Expenditure" and "Other Income" represents any items or projects you paid
55			Total Cost												for in the game, and how much money you got from other sources, respectively. Edit
56			0.00				Quality	Status	Location	Mage Spec.	Quality	Status	Location	Mage Spec.	these cells when you make such transaction, but don't forget to clear them after update.
57							50				50				If you run out of money ("Money (Current)" reaches 0), you go bankrupt. Your armies
58		Name:	Naval Division 3					Total Cost				Total Cost			will abandon you and your people will rise up to depose you. Avoid this by being
59		Infantry	Archers	Cavalry	Battlemages			0.00				0.00			responsible with your economy. When you see that you're approaching 0, but can't
60															avoid it in time, you may try to borrow money from another player. Don't forget to pay
61		Heavy Ship	Light Ship	Galley	Transport	Airship	Name:	Division 10			Name:	Division 11			it back, though!
62							Infantry	Archers	Cavalry	Battlemages	Infantry	Archers	Cavalry	Battlemages
63		Quality	Status	Location	Mage Spec.										Navy
64		50					Quality	Status	Location	Mage Spec.	Quality	Status	Location	Mage Spec.
65			Total Cost				50				50				The navy tab contains an overview of your navy. You may start out with up to 50
66			0.00					Total Cost				Total Cost			ships already built. Put these ships under the "Current" section for whatever type you
67								0.00				0.00			wish, except airships if the "Airships possible?" cell says "No".
68		Name:	Naval Division 4												To construct ships, you must make a post stating how many ships you are
69		Infantry	Archers	Cavalry	Battlemages		Name:	Division 12			Name:	Division 13			constructing and of what type. Then, put them under the "Being made" section. Every
70							Infantry	Archers	Cavalry	Battlemages	Infantry	Archers	Cavalry	Battlemages	week, update the "Progress" section with how many weeks they have been in
71		Heavy Ship	Light Ship	Galley	Transport	Airship									construction until it reaches the number under "Weeks to build". Once it reaches this
72							Quality	Status	Location	Mage Spec.	Quality	Status	Location	Mage Spec.	number, add them to "Current". You may only construct airships if "Airships possible?"
73		Quality	Status	Location	Mage Spec.		50				50				returns yes.
74		50						Total Cost				Total Cost			The "Naval Expenditure" cell shows you how much your current navy is costng
75			Total Cost					0.00				0.00			you.
76			0.00
77							Name:	Division 14			Name:	Division 15			Divisions
78		Name:	Naval Division 5				Infantry	Archers	Cavalry	Battlemages	Infantry	Archers	Cavalry	Battlemages
79		Infantry	Archers	Cavalry	Battlemages										Divisions show how your army is divided. Each division has a name, amount of
80							Quality	Status	Location	Mage Spec.	Quality	Status	Location	Mage Spec.	soldiers, quality, status, location, and mage specialization. You must make a post
81		Heavy Ship	Light Ship	Galley	Transport	Airship	50				50				when you first setup your spreadsheet stating each of these for each of your divisions,
82								Total Cost				Total Cost			and make a post whenever you change something, unless there are special
83		Quality	Status	Location	Mage Spec.			0.00				0.00			circumstances as explained later.
84		50													You may name your divisions whatever you want. You may add as many soldiers
85			Total Cost				Name:	Division 16			Name:	Division 17			to each division as you please, but you may not edit the soldier amount of the
86			0.00				Infantry	Archers	Cavalry	Battlemages	Infantry	Archers	Cavalry	Battlemages	"Unused Soldiers" division. You may change anything else about this division, though.
87															Quality affects the quality of your division's equipment. Divisions with higher qualiy
88		Name:	Naval Division 6				Quality	Status	Location	Mage Spec.	Quality	Status	Location	Mage Spec.	do better in combat, but are more expensive. For the status of your divisions, you
89		Infantry	Archers	Cavalry	Battlemages		50				50				may choose between "Active" or "Garrisoned" (or "Docked" in the case of naval
90								Total Cost				Total Cost			divisions). Active divisions have standard costs while garrisoned divisions only cost
91		Heavy Ship	Light Ship	Galley	Transport	Airship		0.00				0.00			half as much. If a division is garrisoned, though, it cannot travel and can only stay
92															and defend the territory it is stationed in until it becomes active again. It takes 2
93		Quality	Status	Location	Mage Spec.		Name:	Division 18			Name:	Division 19			months for a garrisoned division to become active.
94		50					Infantry	Archers	Cavalry	Battlemages	Infantry	Archers	Cavalry	Battlemages	For the location of your divisions, you may write whatever territory you would like
95			Total Cost												for them to be stationed in (preferably inside your own nation, unless you have
96			0.00				Quality	Status	Location	Mage Spec.	Quality	Status	Location	Mage Spec.	permission from the other nation). You do not need to make a post to update this
97							50				50				if you are at war, as long as you state you are moving them in the conflict post.
98		Name:	Naval Division 7					Total Cost				Total Cost			You may choose whichever specialization for your mages you desire. If your mages
99		Infantry	Archers	Cavalry	Battlemages			0.00				0.00			are specialized, they will do better in their specialization but worse at other schools.
100															You may edit the costs of mercenary divisions to be whatever you are paying for