United Kingdom 1900/H1

[snip]

United Kingdom of Great Britain and Ireland
1900/H1
Region	Population	IC	BP	Income
United Kingdom	38	118	52	$156.00
India	200	20	4	$76.00
Burma	9.606	5	1	$10.92
Canada (including Newfoundland)	5.73	19.5	12	$25.23
Australia (including Papua)	4.4	15	10	$19.40
Ceylon	3.7	3	0	$6.14
New Zealand	0.967	4	1	$4.97
Malay (incd Straits)	0.955	2	0	$2.96
Jamaca	0.82	1	0	$1.82
Hong Kong	0.325	5	1	$5.33
Trinidad and Tobago	0.32	1	0	$1.32
North Borneo	0.3	1	0	$1.30
British Guiana	0.3	1	0	$1.30
Cyprus	0.126	1	0	$1.13
Barbados	0.182	1	0	$1.18
Total	265.731	197.5	81	$314.99
Total Revenue	$314.99
	$	BP
Other Income	28.5	0	Country	Payment	Reason
Industry profits			Italy	20	20 1900 Pattern TBDs
Other civilian income			Ottoman	8.5	Two Vickers Armored cruisers
Other military Income
Total Budget	$343.49	81
Army Construction:
Army Maintenance:	$26.66
Army Ammo Consumption	$0.00	0
Airship Hangars
Airship Construction/Repair
Airship Maintenance	$0.00
Airship Ammo	$0.00	0
Aircraft Infrastructure
Aircraft Construction/Repair
Aircraft Maintenance	$0.00
Ammo
Navy Construction&Repair	$101.85	75.08
Navy Maintenance:	$21.12
Research:	$0.00		Maximum	$27.00
Military Infrastructure					previous		total		remaining
Roslyth Port (Class 0)	$5.00	0.5	5	0.5	0	0	5	0.5	0	0
Scapa Flow (Class 0)	$5.00	0.5	5	0.5	0	0	5	0.5	0	0
Plymouth (Clash 5)	$6.00	1	20	1	0	0	6	1	12	0
Chatham (Class 4)	$6.00	1	15	1	0	0	6	1	13	0
Railways
Emergency Reserve Fund
Other Expenses
Military Budget	$171.63	78.08	Maximum	$171.74	Peacetime
			Remaining	$0.12
Other expenditure
Economic Development	$171.86	0
	Investment		Current	Total Needed	Previous	Needed to Complete
India IC #21	$32.07		20	$32.07	0	Completes
Ceylon IC #4	$35.40		4	$35.40	0	Completes
Burma IC #5	$33.07		5	$33.07	0	Completes
United Kingdom IC #119	$21.32		118	$120.71	0	$99.39
BP #82	$50.00		81	$505.00	0	$455.00
Remaining	0.00	0.00

[snip]

Total		$		101.845
		BP		75.08
					expenditures			previous status				new status					relative status
Name	Construction Facility	Class	Ship Size	Build Time	$	BP		$	BP	Time		$	BP	Time		Type	$	BP	Time
Ottoman Armored Cruiser	Portsmouth Slipway #1	3	11313	4	3.54	3.54		0	0	0		10.6	10.6	3		W	25%	25%	25%
Formidable	Portsmouth Slipway #2	2	15000	4	3.75	3.75		0	0	0		11.25	11.25	3		W	25%	25%	25%
Redoubtable	Portsmouth Slipway #3	2	15000	4	3.75	3.75		0	0	0		11.25	11.25	3		W	25%	25%	25%
Black Prince	Portsmouth Slipway #4	2	12500	4	3.125	3.125		0	0	0		9.375	9.375	3		W	25%	25%	25%
Sapphire	Portsmouth Slipway #5	1	3000	2	1.5	1.5		0	0	0		1.5	1.5	1		W	50	50	50
Emerald	Portsmouth Slipway #6	1	3000	2	1.5	1.5		0	0	0		1.5	1.5	1		W	50	50	50
Ruby	Portsmouth Slipway #7	1	3000	2	1.5	1.5		0	0	0		1.5	1.5	1		W	50	50	50
Impregnable	Plymouth Slipway #1	2	15000	4	3.75	3.75		0	0	0		11.25	11.25	3		W	25%	25%	25%
Iron Duke	Plymouth Slipway #2	2	12500	4	3.125	3.125		0	0	0		9.375	9.375	3		W	25%	25%	25%
Diamond Princess	Plymouth Slipway #3	2	12500	4	3.125	3.125		0	0	0		9.375	9.375	3		W	25%	25%	25%
Apatite	Plymouth Slipway #4	1	3000	2	1.5	1.5		0	0	0		1.5	1.5	1		W	50	50	50
Obsidian	Plymouth Slipway #5	1	3000	2	1.5	1.5		0	0	0		1.5	1.5	1		W	50	50	50
Mail Garnet	Plymouth Slipway #6	1	3000	2	1.5	1.5		0	0	0		1.5	1.5	1		W	50	50	50
Arduous	Chatham Slipway #1	2	15000	4	3.75	3.75		0	0	0		11.25	11.25	3		W	25%	25%	25%
Pearl	Chatham Slipway #2	1	3000	2	1.5	1.5		0	0	0		1.5	1.5	1		W	50	50	50
Rhodonite	Chatham Slipway #3	1	3000	2	1.5	1.5		0	0	0		1.5	1.5	1		W	50	50	50
Fantastic	Chatham Slipway #4	0	500	1	0.625	0.5		0	0	0		0	0	0		D	100%	100%	100%
Florescent	Glasgow Slipway #1	0	500	1	0.625	0.5		0	0	0		0	0	0		D	100%	100%	100%
Fancy	Woolwich Slipway #1	0	500	1	0.625	0.5		0	0	0		0	0	0		D	100%	100%	100%
Flanker	Deptford Slipway #1	0	500	1	0.625	0.5		0	0	0		0	0	0		D	100%	100%	100%
Fortune	Belfast Slipway #1	1	500	1	0.625	0.5		0	0	0		0	0	0		D	100%	100%	100%
Flagrant	Belfast Slipway #2	1	500	1	0.625	0.5		0	0	0		0	0	0		D	100%	100%	100%
A-1 Class Sub	Belfast Slipway #3	0	250	1	0.5	0.25		0	0	0		0	0	0		S	100%	100%	100%
Empress of India	Liverpool Slipway #1	2	12500	4	3.125	3.125		0	0	0		9.375	9.375	3		W	25%	25%	25%
Diamond	Liverpool Slipway #2	1	3000	2	1.5	1.5		0	0	0		1.5	1.5	1		W	50	50	50
Quartz	Liverpool Slipway #3	1	3000	2	1.5	1.5		0	0	0		1.5	1.5	1		W	50	50	50
Flanagan	Liverpool Slipway #4	0	500	1	0.625	0.5		0	0	0		0	0	0		D	100%	100%	100%
Future	Liverpool Slipway #5	0	500	1	0.625	0.5		0	0	0		0	0	0		D	100%	100%	100%
Fabulous	Liverpool Slipway #6	0	500	1	0.625	0.5		0	0	0		0	0	0		D	100%	100%	100%
Fortitude	Cardiff Slipway #1	0	500	1	0.625	0.5		0	0	0		0	0	0		D	100%	100%	100%
Sunstone	Newcastle Slipway #1	1	3000	2	1.5	1.5		0	0	0		1.5	1.5	1		W	50	50	50
A-1 Class Sub	Newcastle Slipway #2	0	250	1	0.5	0.25		0	0	0		0	0	0		S	100%	100%	100%
Italian DD-1900	Madras Slipway #1	0	500	1	0.782	0.5		0	0	0		0	0	0		D	100%	100%	100%
Italian DD-1900	Madras Slipway #2	0	500	1	0.782	0.5		0	0	0		0	0	0		D	100%	100%	100%
Italian DD-1900	Madras Slipway #3	0	500	1	0.782	0.5		0	0	0		0	0	0		D	100%	100%	100%
	Halifax Slipway #1	1	Upgrade	1	3	1		0	0	0		0	0	0		INF	100%	100%	100%
	Halifax Slipway #2	1	Upgrade	1	3	1		0	0	0		0	0	0		INF	100%	100%	100%
Fusileer	Halifax Slipway #3	0	500	1	0.625	0.5		0	0	0		0	0	0		D	100%	100%	100%
Fouler	Halifax Slipway #4	0	500	1	0.625	0.5		0	0	0		0	0	0		D	100%	100%	100%
Fissure	Halifax Slipway #5	0	500	1	0.625	0.5		0	0	0		0	0	0		D	100%	100%	100%
Italian DD-1900	Aberdeen Slipway #1	0	500	1	0.782	0.5		0	0	0		0	0	0		D	100%	100%	100%
	Edinburgh Slipway #1	1	Upgrade	1	3	1		0	0	0		0	0	0		INF	100%	100%	100%
	Edinburgh Slipway #2	1	Upgrade	1	3	1		0	0	0		0	0	0		INF	100%	100%	100%
A-1 Class Sub	Edinburgh Slipway #3	0	250	1	0.5	0.25		0	0	0		0	0	0		S	100%	100%	100%
A-1 Class Sub	Edinburgh Slipway #4	0	250	1	0.5	0.25		0	0	0		0	0	0		S	100%	100%	100%
A-1 Class Sub	Edinburgh Slipway #5	0	250	1	0.5	0.25		0	0	0		0	0	0		S	100%	100%	100%
A-1 Class Sub	Edinburgh Slipway #6	0	250	1	0.5	0.25		0	0	0		0	0	0		S	100%	100%	100%
	Sydney Slipway #1	0	Upgrade	1	6	1		0	0	0		0	0	0		INF	100%	100%	100%
	Sydney Slipway #2	0	Upgrade	1	6	1		0	0	0		0	0	0		INF	100%	100%	100%
	Hong Kong Slipway #1	0
	Hong Kong Slipway #2	0
	Hong Kong Slipway #3	0
	Hong Kong Slipway #4	0
	Singapore Slipway #1	1
	Singapore Slipway #2	1
	Singapore Slipway #3	0
	Singapore Slipway #4	0
Italian DD-1900	Larnaca Slipway #1	0	500	1	0.782	0.5		0	0	0		0	0	0		D	100%	100%	100%
Italian DD-1900	Larnaca Slipway #2	0	500	1	0.782	0.5		0	0	0		0	0	0		D	100%	100%	100%
Italian DD-1900	Valletta Slipway #1	0	500	1	0.782	0.5		0	0	0		0	0	0		D	100%	100%	100%
Italian DD-1900	Valletta Slipway #2	0	500	1	0.782	0.5		0	0	0		0	0	0		D	100%	100%	100%
Italian DD-1900	Valletta Slipway #3	0	500	1	0.782	0.5		0	0	0		0	0	0		D	100%	100%	100%
Italian DD-1900	Valletta Slipway #4	0	500	1	0.782	0.5		0	0	0		0	0	0		D	100%	100%	100%
Italian DD-1900	Gibraltar Slipway #1	0	500	1	0.782	0.5		0	0	0		0	0	0		D	100%	100%	100%
Italian DD-1900	Gibraltar Slipway #2	0	500	1	0.782	0.5		0	0	0		0	0	0		D	100%	100%	100%
	Port Stanley Slipway #1	0
	Port Stanley Slipway #2	0
Ottoman Armored Cruiser	Portsmouth Drydock #1	3	11313	4	3.54	3.54		0	0	0		10.6	10.6	3		W	25%	25%	25%
	Portsmouth Drydock #2	2
	Portsmouth Drydock #3	2
	Portsmouth Drydock #4	1
	Plymouth Drydock #1	2
	Plymouth Drydock #2	2
	Plymouth Drydock #3	1
	Chatham Drydock #1	1
	Chatham Drydock #2	1
	Chatham Drydock #3	0
	Glasgow Drydock #1	1
	Glasgow Drydock #2	0
	Woolwich Drydock #1	1
	Woolwich Drydock #2	0
	Deptford Drydock #1	1
	Deptford Drydock #2	0
	Larnaca Drydock #1	2
Italian DD-1900	Larnaca Drydock #2	0	500	1	0.782	0.5		0	0	0		0	0	0		D	100%	100%	100%
Italian DD-1900	Larnaca Drydock #3	0	500	1	0.782	0.5		0	0	0		0	0	0		D	100%	100%	100%
	Valletta Drydock #1	2
	Valletta Drydock #2	2
Italian DD-1900	Valletta Drydock #3	1	500	1	0.782	0.5		0	0	0		0	0	0		D	100%	100%	100%
Italian DD-1900	Valletta Drydock #4	1	500	1	0.782	0.5		0	0	0		0	0	0		D	100%	100%	100%
Italian DD-1900	Valletta Drydock #5	0	500	1	0.782	0.5		0	0	0		0	0	0		D	100%	100%	100%
Italian DD-1900	Gibraltar Drydock #1	2	500	1	0.782	0.5		0	0	0		0	0	0		D	100%	100%	100%
Italian DD-1900	Gibraltar Drydock #2	0	500	1	0.782	0.5		0	0	0		0	0	0		D	100%	100%	100%
Italian DD-1900	Gibraltar Drydock #3	0	500	1	0.782	0.5		0	0	0		0	0	0		D	100%	100%	100%

[snip]

#	Count	Name/Class	Disp	LD/Com/R.	v_Max	Range	Cruise	Bunker	Status	fighting	Upkeep [$]
	8	Illustrious	13,100	PreStart	16.39	7009	8	1471	a		3.14
	4	Albion	14,100	PreStart	17.98	7000	8	1506	a		1.72
	6	Remembrance	9,780	PreStart	17.96	7000	10	1995	a		2.00
	8	Ariadne	9,485	PreStart	20.45	7000	10	1990	a		2.77
	6	Cressy	10,980	PreStart	21.02	7000	10	2049	a		2.35
	12	Aphrodite	3,000	PreStart	19.91	4000	10	566	a		1.52
	12	Encounter	4,684	PreStart	20.3	7500	10	1334	a		2.21
	24	Pegasus	1,640	PreStart	18.69	7000	10	743	a		1.82
	40	Chamois	470	PreStart	24.04	3000	10	144	a		1.47
	40	Destructive	470	PreStart	24.04	3000	10	139	a		1.44
Total	160
		Tonnage:	530,808
Coastal Defenses	Count	Type	Defenses						Status		Upkeep [$]
	4	12" Turret	MD						a		0.13
	5	12" Turret	ED						a		0.08
	16	12" Dissap. Carrage.	ND						a		0.03
	6	9.2" Turret	ED						a		0.18
	29	9.2" Casemate	ND						a		0.07
	51	6" Turret	ND						a		0.05
	65	6" Casemate	ND						a		0.03
	975	6"Dissap. Carrage	ND						r		0.10
Total	1151

[snip]

Corp #	Name	Type		Motorized	Rating	Artillery	Strength	Morale	Value [$]	Status	Upkeep [$]	Ammo	Location
1	1st Infantry, Royal Guards	1895	INF		4	2	100%		8	a	0.4		England
2	2nd Infantry, Royal Welsh	1895	INF		4	2	100%		8	a	0.4		Wales
3	3rd Infantry, Royal Scots	1895	INF		4	2	100%		8	a	0.4		Scotland
4	4th Infantry, Royal Irish	1895	INF		4	2	100%		8	a	0.4		Ireland
5	5th Infantry, Raj Guards	1895	INF		4	2	100%		8	a	0.4		India
6	6th Infantry, Black Watch	1895	INF		4	2	100%		8	a	0.4		Canada
7	7th Infantry, Gaelic Guards	1895	INF		4	2	100%		8	a	0.4		Canal Zone
8	8th Infantry, Royal Fusiliers	1895	INF		4	2	100%		8	a	0.4		Hong Kong
9	9th Infantry, Queen's Rifles	1895	INF		4	2	100%		8	a	0.4		Gibraltar
10	10th Infantry, Royal ANZAC	1895	INF		4	2	100%		8	a	0.4		Australia
11	1st Royal Hussars	1895	CAV		4	1	100%		8	a	0.4		Home Islands
12	2nd Royal Hussars	1895	CAV		4	1	100%		8	a	0.4		Canal Zone
13	Royal Tigers	1895	JNG		4	1	100%		8	a	0.4		Mayala
14	Desert Rats	1895	DES		4	1	100%		8	a	0.4		Canal Zone
15	Royal Marines	1895	Mar		4	1	100%		8	a	0.4		Home Islands
16	1st Indian Regulars	1885	INF		3	1	100%		6	r	0.06		India
17	2nd Indian Regulars	1885	INF		3	1	100%		6	r	0.06		India
18	3rd Indian Regulars	1885	INF		3	1	100%		6	r	0.06		Canal Zone
19	11th Infantry	1885	INF		3	1	100%		6	r	0.06		Valletta
20	12th Infantry	1885	INF		3	1	100%		6	r	0.06		Singapore
21	13th Infantry	1885	INF		3	1	100%		6	r	0.06		Larnaca, Cyprus
22	Indian Reservists	1885	INF		3	1	100%		6	r	0.06		India
23	Indian Reservists	1885	INF		3	1	100%		6	r	0.06		India
24	Australian Reservists	1885	INF		3	1	100%		6	r	0.06		Australia
25	Canadian Reservists	1885	INF		3	1	100%		6	r	0.06		Canada
26	Royal Mounted Reserves	1885	CAV		3	0.5	100%		6	r	0.06		Canada
27	Australian Reservists	1885	CAV		3	0.5	100%		6	r	0.06		Australia
28	Indian Reservists	1885	CAV		3	0.5	100%		6	r	0.06		India
29	Far Eastern Reserves	1885	CAV		3	0.5	100%		6	r	0.06		Singapore
30	Home Reserves	1885	CAV		3	0.5	100%		6	r	0.06		Home Islands
1		1895	GAR		12	18	300%		48	a	2.4		Port Said
2		1895	GAR		12	18	300%		48	a	2.4		Suez
3		1895	GAR		8	12	200%		32	a	1.6		Madris
4		1895	GAR		8	12	200%		32	a	1.6		Hong Kong
5		1895	GAR		8	12	200%		32	a	1.6		Singapore
6		1895	GAR		8	12	200%		32	a	1.6		Gibraltar
7		1895	GAR		4	6	100%		16	a	0.8		Portsmouth
8		1895	GAR		4	6	100%		16	a	0.8		Valletta
9		1895	GAR		4	6	100%		16	a	0.8		Larnaca, Cyprus
10		1895	GAR		4	6	100%		16	a	0.8		Port Stanley
11		1895	GAR		4	6	100%		16	a	0.8		Plymouth
12		1895	GAR		4	6	100%		16	a	0.8		Sydney
13		1895	GAR		2	3	50%		8	a	0.4		Portsmouth
14		1895	GAR		2	3	50%		8	a	0.4		Gibraltar
15		1895	GAR		2	3	50%		8	a	0.4		Liverpool
16		1895	GAR		2	3	50%		8	a	0.4		Halifax
17		1880	GAR		6	6	200%		24	r	0.24		India
18		1880	GAR		6	6	200%		24	r	0.24		India
19		1880	GAR		6	6	200%		24	r	0.24		Canada
20		1880	GAR		6	6	200%		24	r	0.24		Canada
21		1880	GAR		6	6	200%		24	r	0.24		Australia
22		1880	GAR		6	6	200%		24	r	0.24		Australia
23		1880	GAR		3	3	100%		12	r	0.12		Ireland
24		1880	GAR		3	3	100%		12	r	0.12		Ireland
25		1880	GAR		3	3	100%		12	r	0.12		India
26		1880	GAR		3	3	100%		12	r	0.12		India
27		1880	GAR		1.5	1.5	50%		6	r	0.06		Gibraltar
28		1880	GAR		1.5	1.5	50%		6	r	0.06		Hong Kong
29		1880	GAR		1.5	1.5	50%		6	r	0.06		Singapore
30	Tower of London	1880	GAR		1.5	1.5	50%		6	r	0.06		London

[Logi]

If you copied your post from your spreadsheet there's a problem with it that I've found. For the value given for a reserve unit in the army tab, the conditional you have is K11="_R",0.01,0 where K11 is just the cell of the Status. However since the input status is 'r' not '_R', you have the upkeep resulting in 0 instead of 0.08.

This adds up to $3.06 not counted in the UK budget.

[Tanthalas]

Having just checked it in my spreadsheat you have aparently made changes in yours logi, because I get exactly the same numbers as Snip (infact it dosnt matter if I capitilise the R or not and if I use _R I get 0 for maintnence on my reserve units)

If you copied your post from your spreadsheet there's a problem with it that I've found. For the value given for a reserve unit in the army tab, the conditional you have is K11="_R",0.01,0 where K11 is just the cell of the Status. However since the input status is 'r' not '_R', you have the upkeep resulting in 0 instead of 0.08.

This adds up to $3.06 not counted in the UK budget.

[snip]

on my copy (which is the same as uploaded) it is a lower-case r for that value [=IF(OR(K11="m";K11="f");0.1;IF(K11="a";0.05;IF(K11="r";0.01;0)))*J11], which is listed in the posted page. Out of curiosity, what program are you using to open the file? Seeing as I made it in Open Office, it might be an artifact of trying to open it elsewhere.

[Tanthalas]

I have MS Office, it makes absolutly no diferance, as my results are the same as yours.  I would post my report but im still trying to name all my corps and figure out whats Active/Mobalised/Reserve.

on my copy (which is the same as uploaded) it is a lower-case r for that value [=IF(OR(K11="m";K11="f");0.1;IF(K11="a";0.05;IF(K11="r";0.01;0)))*J11], which is listed in the posted page. Out of curiosity, what program are you using to open the file? Seeing as I made it in Open Office, it might be an artifact of trying to open it elsewhere.

[Logi]

Ah then it is probably an artifact from the conversion from open office spreadsheet to excel spreadsheet. I use an automatic converter. Looking now at your post, it would seem to be the case since you do indeed have the correct maintenance values.