Deutsches Kaiserreich, H1/1900 *DRAFT FOR DISCUSSION*

[miketr]

I will follow the example of my Russian Neighbor and attach the draft Excel Doc for now.

Navy is placeholder as I have to go through the Spring Sharps sent over by Rocky.  I have no construction as of yet.  IC total updated after private talks with Mods.

Lots of forts, lots of coast defense and big standing army. 

EDIT:

All but 4,500 tons of navy entered in.

The TB's I owe other players are being built.
Per mods declaration on BP conversion 10 BP being turned into cash.
Tech entered in; Germany takes 1900 Reserves as its free Tech.

EDIT2:

Here is the excel with updated research and the new divisions.  I hope there are no errors in this.

Michael

[miketr]

BUMP, xls updated.

[Walter]

Guess you will need to tweak it a little since your military budget is $35.6625 and what you spent on the military is $36.16853333...

... and I would try to spend that leftover of $0.01 as well. :)

[miketr]

The max military budget is technically $42.225 and not $35.6625 so I will work on the reporting for that.  The actual left over $0.006467 so M'EH...

Michael

[Walter]

The max military budget is technically $42.225 and not $35.6625 so I will work on the reporting for that.

Well, looking at the spreadsheet I guess the German Government thinks otherwise. ;D

But I have it the same way in the spreadsheet (since I copied it from yours) so I need to correct that as well.

[miketr]

Copying of other peoples spreadsheets brings up an interesting point.

I took mine from  Guinness and made changes to it.  If people are going to use excel it might be a good idea to have an official version.  Otherwise we could have errors creeping in.

Michael

[Walter]

I took Logi's Japan's example report spreadsheet, put it on a memory stick, loaded it onto my laptop, saved it in a different format, copied the new version to the memory stick, copied it to my PC and worked with that, replacing all the Japanese stuff by the Chinese stuff. I later took the 'BP for Foreign Orders' bit from your report and put it into mine and then altered it so it adds to the cash and subtracts the BPs. As far as I can see, your spreadsheet (and thus Russia's spreadsheet) is the same as mine, although I did just make the additional change that the cash gained from selling the BPs is added to the military budget as well and not just the total budget.

BTW, something I just noticed in your spreadsheet when I loaded it to compare it to mine is that it indicates that the country is Russia.

[Kaiser Kirk]

Copying of other peoples spreadsheets brings up an interesting point.

I took mine from  Guinness and made changes to it.  If people are going to use excel it might be a good idea to have an official version.  Otherwise we could have errors creeping in.

Michael

I redid the Italian sheet from Snip's new one this weekend.
Noticed the problem with the research formula that I posted in Clarifications.

[miketr]

I redid the divisions of Germany.  Will post the map shortly.

Region	Pop	IC	BP	Revenue	Research		Growth Rate	Exp. Pop
Berlin	2	5	3.5	6.70	3		1.00	2.02
Alsace-Lorraine	1.8	1	1	2.18	0		2.50	1.85
Baden	2	1	1	2.20	0		2.50	2.05
Württemberg	2.4	1	1	2.24	0		2.50	2.46
Rhineland	5.9	2.5	2	5.59	0		2.50	6.05
Westphalia	4.7	2	1.5	4.47	0		2.50	4.82
Hannover	3.5	1	1	2.35	0		2.50	3.59
Hesse-Nassau	3.2	1	1	2.32	0		2.50	3.28
Bavaria	6	3	2.5	6.60	0		2.50	6.15
Saxony	3	1	1	2.30	0		2.50	3.08
K.Saxony	4.8	2	1.5	4.48	0		2.50	4.92
Schleswig-Holstein	1.5	1	1	2.15	0		2.50	1.54
Mecklenburg	0.6	0.5	0	1.06	0		2.50	0.62
Brandenburg	3	1	1	2.30	0		2.50	3.08
Pomerania	1.6	1	1	2.16	0		2.50	1.64
Silesia	5	1	1	2.50	0		2.50	5.13
Posen	2	1	1	2.20	0		2.50	2.05
WestPrussia	1.5	1	1	2.15	0		2.50	1.54
EastPrussia	2	1	1	2.20	0		2.50	2.05
				0.00	0		1.00	0.00
Deutsch-Neuguinea	0.50	0.00		0.05	0		2.50	0.51
Total	57.00	28.00	24.00	58.20	3.00			58.40

[Walter]

20 regions... :o glad that I only have 12 regions to work with...

[miketr]

20 regions... :o glad that I only have 12 regions to work with...

I tried to come up with something that reflects something like the historic divisions.

Michael

[miketr]

BUMP

Updated ECO.

I will post a 1900 /H2 budget in a day or so.

Michael