France 1900H1

Jefgte · November 06, 2012, 05:53:49 AM

Budget here

Jefgte · November 06, 2012, 05:55:07 AM

Army

Corp #	Name	Type		Motorized	Rating	Artillery	Strength	Morale	Value [$]	Status	Upkeep [$]	Ammo	Location
1	East Corp	1895	INF		8	2	100%	Reg	8	a	0.4		Verdun
2	East Corp	1895	INF		8	2	100%	Elite	8	a	0.4		Toul
3	East Corp	1895	CAV		8	2	100%	Reg	8	a	0.4		Montbéliard
4	North Corp	1895	INF		8	2	100%	Reg	8	a	0.4		Marchiennes(Douais)
5	North Corp	1895	INF		8	2	100%	Reg	8	a	0.4		Rethel
6	Ouest Corp	1895	CAV		4	1	100%	Reg	8	a	0.4		Alençon
7	Ouest Corp	1895	INF		4	1	100%	Reg	8	a	0.4		Angoulème
8	South Corp	1895	INF		4	2	100%	Reg	8	a	0.4		Toulouse
9	South Corp	1895	MTN		4	1	100%	Reg	8	a	0.4		Grenoble
10	Tonkin Corp	1895	INF		4	2	100%	Reg	8	a	0.4		Hanoî
11	New Caledonia	1895	INF		4	2	100%	Reg	8	a	0.4		Nouméa
12	Algeria Corp	1895	INF		4	2	100%	Reg	8	a	0.4		Alger
13	East Corp	1895	INF		6	2	100%	Reg	8	r	0.08		Saint Diziers
14	East Corp	1895	GAR		6	6	100%	Reg	8	r	0.08		Vesoul
15	Zouaves	1895	INF		4	1	200%	Reg	16	r	0.16		Tanger
16	Spahis	1885	CAV		3	1	100%	Reg	6	r	0.04		Tanger
17	Légionnaires	1885	INF		8	4	100%	Elite	16	r	0.08		Mont de Marsan
18	Tirailleurs Malgaches	1885	INF		3	1	100%	Reg	6	r	0.04		Tananarive
19	Tirailleurs Cambodgiens	1885	JNG		3	1	100%	Reg	6	r	0.04		Phnom Penh
20	Tirailleurs Sénégalais	1885	INF		3	1	100%	Reg	6	r	0.04		Dakar
21	Tirailleurs Haoussas	1885	INF		3	1	100%	Reg	6	r	0.04		N'Djamena
22	Tirailleurs Laosiens	1885	JNG		3	1	100%	Reg	6	r	0.04		Vientiane
23	Tirailleurs Tonkinois	1885	JNG		3	1	100%	Reg	6	r	0.04		Hanoi
24	Tirailleurs Tonkinois	1885	INF		3	1	100%	Reg	6	r	0.04		Saigon
25	Zouaves	1885	INF		3	1	100%	Reg	6	r	0.04		Gabès
26	Spahis	1885	CAV		3	0.5	100%	Reg	6	r	0.04		Sfax
27	Tirailleurs du Pacifique	1885	JNG		3	0.5	100%	Reg	6	r	0.04		Ouégoa
29	Tirailleurs Malgaches	1885	INF		3	0.5	100%	Reg	6	r	0.04		Soalala
30	Tirailleurs de Guinée	1895	INF		3	0.5	100%	Reg	8	r	0.08		Conakry
31	Tirailleurs Sénégalais	1895	INF		3	0.5	100%	Reg	8	r	0.08		St Louis
32	Tirailleurs Haoussas	1895	INF		3	0.5	100%	Reg	8	r	0.08		Douala
33	Tirailleurs Laosiens	1895	JNG		3	0.5	100%	Reg	8	r	0.08		Muang Khong
34	East Corp	1895	GAR		4	6	200%	Reg	16	Stockp	0		Chaumont
35	North Corp	1895	GAR		4	6	200%	Reg	16	Stockp	0		Reims
36	Zouaves	1895	INF		3	0.5	100%	Reg	8	Stockp	0		Tunis
37	Spahis	1895	CAV		3	0.5	100%	Quiet	8	Stockp	0		Casablanca
38	Légionnaires	1895	INF		4	6	100%	Quiet	8	Stockp	0		Constantine
39	Tirailleurs Malgaches	1895	INF		3	0.5	100%	Quiet	8	Stockp	0		San Diego
40	Tirailleurs Cambodgiens	1895	INF		3	0.5	100%	Quiet	8	Stockp	0		Phnom Penh
41	Tirailleurs Sénégalais	1895	JNG		3	0.5	100%	Quiet	8	Stockp	0		Dakar
42	Tirailleurs Haoussas	1895	INF		3	0.5	100%	Quiet	8	Stockp	0		Yaoundé
43	Tirailleurs Laosiens	1895	JNG		3	0.5	100%	Quiet	8	Stockp	0		Paksé
44	Tirailleurs Tonkinois	1895	JNG		3	0.5	200%	Quiet	16	Stockp	0		Haiphong
45	Tirailleurs Tonkinois	1895	INF		3	0.5	200%	Quiet	16	Stockp	0		Nam Dinh
46	Zouaves	1895	INF		3	0.5	200%	Quiet	16	Stockp	0		Oran
47	Spahis	1895	CAV		3	0.5	200%	Quiet	16	Stockp	0		Agadir
48	Tirailleurs du Pacifique	1895	JNG		3	0.5	100%	Quiet	8	Stockp	0		Tahiti
49	Tirailleurs Malgaches	1895	JNG		3	0.5	100%	Quiet	8	Stockp	0		Tolanaro & Djibouty
											6
											$

Jefgte · November 06, 2012, 05:58:59 AM

Marine Nationale

Affectation	Type	Names	Divisions	disp	LD/Com/R.	Div.Cost $	Div.Cost BP	Statut	Upkeep
Tanger	CP1	Danjoult-Dufort	1er CR	2950	1895	5.9	5.9	reserve	0.295
Brest	AC1	Neerwinden-Wissembourg	1er CC	5150	1895	10.3	10.3	active	4.12
Brest	BB1	Tolbiac-Bouvines	1er CU	11300	1895	22.6	22.6	active	9.04
Toulon	BB1	Malplaquet-Denain	2eme CU	11300	1895	22.6	22.6	reserve	1.13
Dunkerque	TB1	TT1-TT2-TT3-TT4	1er TT	300	1896	1.5	1.2	reserve	0.06
Dunkerque	TB1	TT5-TT6-TT7-TT8	2eme TT	300	1896	1.5	1.2	active	0.48
Toulon	TB1	TT9-TT10-TT11-TT12	3eme TT	300	1896	1.5	1.2	active	0.06
Toulon	TB1	TT13-TT14-TT15-TT16	4eme TT	300	1896	1.5	1.2	reserve	0.48
Dakar	CP2	Duvalles-Dassonville	3eme CR	3200	1896	6.4	6.4	reserve	0.32
Diego Suarez	CP2	Dentraigue-Duvillars	4eme CR	3200	1896	6.4	6.4	active	2.56
Fort Bayard	CP2	Darras-Denevers	5eme CR	3200	1896	6.4	6.4	active	2.56
Nouméa	CP2	Dufort-Dersignac	6eme CR	3200	1896	6.4	6.4	reserve	2.56
Fort Bayard	SBB1	Marignan-Calais	3eme CU	7600	1896	15.2	15.2	active	6.08
Fort Bayard	SBB1	Rocroi-La Marsailles	4eme CU	7600	1896	15.2	15.2	reserve	0.76
Tunis	AT1	AT1-AT2	1ere AT	1540	1897	3.08	3.08	active	1.232
Tanger	AT1	AT3-AT4	2eme AT	1540	1897	3.08	3.08	reserve	0.154
Alger	AT1	AT5-AT6	3eme AT	1540	1897	3.08	3.08	reserve	0.154
Port Gentil	AT1	AT7-AT8	4eme AT	1540	1897	3.08	3.08	active	1.232
Pointe à Pitre	AT1	AT9-AT10	5eme AT	1540	1897	3.08	3.08	active	1.232
Oran	AT1	AT11-AT12	6eme AT	1540	1897	3.08	3.08	reserve	0.154
Brest	CP3	Cocherel-Orléans	6eme CR	5000	1897	10	10	reserve	0.5
Brest	CP3	Castillon-Formigny	7eme CR	5000	1897	10	10	active	4
Toulon	BB2	Austerlitz-Iena	7eme CU	11750	1897	23.5	23.5	active	9.4
Toulon	BB2	Arcole-Rivoli	8eme CU	11750	1898	23.5	23.5	reserve	1.175
Toulon	TB2	TT17-TT18-TT19-TT20	5eme TT	450	1898	2.25	1.8	reserve	0.09
Toulon	TB2	TT21-TT22-TT23-TT24	6eme TT	450	1898	2.25	1.8	reserve	0.72
Cherbourg	TB2	TT25-TT26-TT27-TT28	7eme TT	450	1898	2.25	1.8	active	0.72
Tanger	TB2	TT29-TT30-TT31-TT32	8eme TT	450	1898	2.25	1.8	reserve	0.09
Tanger	TB2	TT33-TT34-TT35-TT36	9eme TT	450	1898	2.25	1.8	active	0.09
Toulon	AC2	Fontenoy-Valmy	2eme CC	7500	1898	15	15	active	6.00
Brest	AC2	Jemappes-Wattignies	3eme CC	7500	1898	15	15	active	6.00
Brest	TB3	TT37-TT38TT39-TT40	10eme TT	500	1899	2.5	2	reserve	0.10
Brest	TB3	TT41-TT42-TT43-TT44	11eme TT	500	1899	2.5	2	reserve	0.10
Toulon	TB3	TT45-TT46-TT47-TT48	12eme TT	500	1899	2.5	2	active	0.80
Toulon	TB3	TT49-TT50-TT51-TT52	13eme TT	500	1899	2.5	2	active	0.80
Diego Suarez	TB3	TT53-TT54-TT55-TT56	14eme TT	500	1899	2.5	2	reserve	0.10
Fort Bayard	TB3	TT57-TT58TT59-TT60	15eme TT	500	1899	2.5	2	reserve	0.10
Nouméa	TB3	TT61-TT62-TT63-TT64	16eme TT	500	1899	2.5	2	active	0.80
Diego Suarez	AT2	AT13 to AT14	7eme AT	1540	1899	3.08	3.08	active	1.23
Tahiti	AT2	AT15 to AT16	8eme AT	1540	1899	3.08	3.08	reserve	0.15
Dakar	AT2	AT17 to AT18	9eme AT	1540	1899	3.08	3.08	reserve	0.15
Fort Bayard	AT2	AT19 to AT20	10eme AT	1540	1899	3.08	3.08	active	1.23
Oran	CP5	Carmelia-Cerres	9eme CR	4500	1899	9	9	active	3.6
Alger	CP5	Cantales-Courseau	10eme CR	4500	1899	9	9	reserve	0.45
Toulon	CP5	Caliste-Cassandra	11eme CR	4500	1899	9	9	reserve	0.45


									73.52
Year	Type	Name	Division	disp	LD/Com/R.	Cost $	Cost BP		Upkeep

Jefgte · November 06, 2012, 06:05:25 AM

Coastal Guns
Harbors or Places	T2	$	BP	Active	4 x casemates	$	BP	Active
Dunkerque	305			0.0162	164			0.002
Dunkerque	305			0.0162	164			0.002
Dunkerque	305			0.0162	164			0.002
Dunkerque	305			0.0162	164			0.002
Cap Gris Nez	305			0.0162	164			0.002
Cap Gris Nez	305			0.0162	164			0.002
Cap Gris Nez	305			0.0162	164			0.002
Cap Gris Nez	305			0.0162	164			0.002
Cap Gris Nez	305			0.0162	164			0.002
Cherbourg	305			0.0162	164			0.002
Cherbourg	305			0.0162	164			0.002
Cherbourg	305			0.0162	164			0.002
Cherbourg	305			0.0162	164			0.002
Brest	305			0.0162	164			0.002
Brest	305			0.0162	164			0.002
Brest	305			0.0162	164			0.002
Brest	305			0.0162	164			0.002
Brest	305			0.0162	164			0.002
Brest	305			0.0162	164			0.002
Lorient	305			0.0162	164			0.002
Lorient	305			0.0162	164			0.002
St Nazaires	305			0.0162	164			0.002
St Nazaires	305			0.0162	164			0.002
St Nazaires	0			0	164			0.002
Rochefort	0			0	164			0.002
Bordeaux	0			0	164			0.002
Port Vendres	0			0	164			0.002
Toulon	305			0.0162	164			0.002
Toulon	305			0.0162	164			0.002
Toulon	305			0.0162	164			0.002
Toulon	305			0.0162	164			0.002
Fort de France	0			0	164			0.002
Pointe à Pitre	305			0.0162	164			0.002
Bizerte	305			0.0162	164			0.002
Tunis	305			0.0162	164			0.002
Alger	305			0.0162	164			0.002
Point Cires-Edallya	305			0.0162	164			0.002
Point Cires-Edallya	305			0.0162	164			0.002
Point Cires-Edallya	305			0.0162	164			0.002
Point Cires-Edallya	305			0.0162	164			0.002
Point Cires-Edallya	305			0.0162	164			0.002
Tanger	305			0.0162	164			0.002
Oran	305			0.0162	164			0.002
Dakar	305			0.0162	164			0.002
Port Gentil	0			0	164			0.002
Diego Suarez	305			0.0162	164			0.002
Diego Suarez	305			0.0162	164			0.002
La Réunion-le Port	0			0	164			0.002
Saigon	305			0.0162	164			0.002
Saigon	305			0.0162	164			0.002
Fort Bayard	305			0.0162	164			0.002
Fort Bayard	305			0.0162	164			0.002
Papeete	0			0	164			0.002
Nouméa	305			0.0162	164			0.002
Nouméa	305			0.0162	164			0.002
		0	0	0.7614		0	0	0.11
		$	BP	Active		$	BP	Active
					total : 94x305
	47T2xx305				total : 220x164
	240x164				Total build BP :0
					Total cost build $: 0
					Total active cost: 0.872

Jefgte · November 06, 2012, 06:08:18 AM

For the Shipyards, SS are not finish...

snip · November 06, 2012, 09:08:33 AM

You appear to be missing the fuel-based upkeep.

Jefgte · November 06, 2012, 10:24:29 AM

QuoteYou appear to be missing the fuel-based upkeep

Oups :o

I have changed the page & rename the last coluns...Dimensions - Armament - Range - Cruise - Bunker

How calculate the fuel-based upkeep?

Jef

snip · November 06, 2012, 10:35:38 AM

I advise getting the spreadsheet from the UK 1900/H1 thread and grabbing the Naval page from there and inputing your ships into that.

Jefgte · November 07, 2012, 07:46:47 AM

Snip's Spreadsheet is not working but KW's spreadsheet is working.

Thanks KW

Jef ;)

Tanthalas · November 07, 2012, 08:24:52 AM

I think Jef you proly had the same issue with Snips that I did (its saved as a .ods instead of an .xls... I htink I got the file extensions right)

Quote from: Jefgte on November 07, 2012, 07:46:47 AM
Snip's Spreadsheet is not working but KW's spreadsheet is working.

Thanks KW

Jef ;)

Jefgte · November 07, 2012, 08:41:57 AM

Yes Tan.

So, rewrite my spreadsheet is too complicated & the error risk are real & take too much time.. so, I didnt.

Here is the first line with the 1st div of cruisers-Danjoult & Dufort

How I calculate the bunker upkeep?
15% of the coal bunker or 15% of the displacement?

Affectation

Type

Names

Divisions

disp

LD/Com/R.

Div.Cost $

Div.Cost BP

Statut

Upkeep

Dimension

Armament

v_Max

Range

Cruise

Bunker

Tanger

CP1

Danjoult-Dufort

1er CR

2950

1895

5.9

reserve

0.295

101x13.4x4.61

4x140+4x100

19.1

6500

10

938

I'll probably change all ship "active"

Tanthalas · November 07, 2012, 08:49:02 AM

Best advice I can offer is to use the spreadsheat im ataching here for naval maintnence (you only have to use the Naval page but im uploading my whole package) as far as I know its acurate (atleast my reports came out right) this is in .xls format so you should be good to go.

Nobody · November 07, 2012, 11:43:29 AM

If you have problems with the upkeep calculations:
I made sure there is a detailed description how it works in the Rules. I also made example sheets in both excel and open file formats which are attached there. If you have problems with those (or questions) ask me.

Jefgte · November 07, 2012, 03:48:34 PM

Thanks Nobody & Tan,

I have just made the error in the original Spreadsheet to add coluns with ships dimensions, armament & protection.
More interresting for me than coal cost...

Tan spreadsheet is walking well.
I have just "save as" .xlsx & I can wrote & change numbers. Upkeep coluns are updated too.

Jef

Jefgte · November 08, 2012, 10:18:54 AM

Here is the 1900H1 Building Plan

Classement by Harbors/Shipyards

Ship	price	tonnage	BP spent	Tons used	BP used	Tons Left	Build Report Left	SS & DD 70mx16
AC4-1	$2.70	8 600	2.7	2700	2.7	5900	2	Dunkerque - D120
TB4-1	$0.60	480	0.48	480	0.48	0	0	Dunkerque - D70
TB4-2	$0.60	480	0.48	480	0.48	0	0	Dunkerque - S70
AC4-2	$2.70	8 600	2.7	2700	2.7	5900	2	Le Havre - S120
TB4-3	$0.60	480	0.48	480	0.48	0	0	Le Havre - S70
TB4-4	$0.60	480	0.48	480	0.48	0	0	Le Havre - S70
BB3-1	$3.00	13800	3	3000	3	10800	3	Cherbourg - S170
CP6-1	$1.80	5300	1.8	1800	1.8	3500	2	Cherbourg - S120
CP6-2	$1.80	5300	1.8	1800	1.8	3500	2	Cherbourg - D120
TB4-5	$0.60	480	0.48	480	0.48	0	0	Cherbourg - S70
TB4-6	$0.60	480	0.48	480	0.48	0	0	Cherbourg - D70
BB3-2	$3.00	13800	3	3000	3	10800	3	Brest - S170
AC3-1	$3.00	12000	3	3000	3	9000	3	Brest - S170
AC3-2	$3.00	12000	3	3000	3	9000	3	Brest - D170
CP6-3	$1.80	5300	1.8	1800	1.8	3500	2	Brest - S120
CP6-4	$1.80	5300	1.8	1800	1.8	3500	2	Brest - D120
AT3-1	$1.50	4200	1.5	1500	1.5	2700	2	Brest - D120
TB4-7	$0.60	480	0.48	480	0.48	0	0	Brest - S70
TB4-8	$0.60	480	0.48	480	0.48	0	0	Brest - S70
SS1-1to4	$1.50	1000	1	1000	0	0	0	Lorient - S170
AC4-3	$2.70	8600	2.7	2700	2.7	5900	2	Lorient - S120
TB4-9	$0.60	480	0.48	480	0.48	0	0	Lorient - S70
AC3-3	$3.00	12000	3	3000	3	9000	3	St Nazaires - D170
AC4-4	$2.70	8600	2.7	2700	2.7	5900	2	St Nazaires - D120
TB4-10	$0.60	480	0.48	480	0.48	0	0	St Nazaires - D70
AT3-2	$1.50	4200	1.5	1500	1.5	0	2	Rochefort - S120
TB4-11	$0.60	480	0.48	480	0.48	0	0	Rochefort - S70
TB4-12	$0.60	480	0.48	480	0.48	0	0	Bordeaux - D70
AT3-3	$1.50	4200	1.5	1500	1.5	2700	2	Bordeaux- D120
AC3-4	$3.00	12000	3	3000	3	9000	3	Bordeaux - D170
TB4-13	$0.60	480	0.48	480	0.48	0	0	Port Vendres - S70
TB4-14	$0.60	480	0.48	480	0.48	0	0	Port Vendres - S70
BB3-3	$3.00	13800	3	3000	3	10800	3	Toulon - S170
BB3-4	$3.00	13800	3	3000	3	10800	3	Toulon - D170
AT3-4	$1.50	4200	1.5	1500	1.5	2700	2	Toulon - S120
AT3-5	$1.50	4200	1.5	1500	1.5	2700	2	Toulon - D120
AT3-6	$1.50	4200	1.5	1500	1.5	2700	2	Toulon - D120
TB4-15	$0.60	480	0.48	480	0.48	0	0	Toulon - S70
TB4-16	$0.60	480	0.48	480	0.48	0	0	Toulon - D70
Total	62.1	192 680	59.68	59680	58.68	130300
	price	tonnage	BP spent	Tons used	BP used	Tons Left	Build Turn Left