Main Menu

France 1900H1

Started by Jefgte, November 06, 2012, 05:53:49 AM

Previous topic - Next topic

Jefgte

"You French are fighting for money, while we English are fighting for honor!"
"Everyone is fighting for what they miss. "
Surcouf

Jefgte

#1
Army


Corp #NameTypeMotorizedRatingArtilleryStrengthMoraleValue [$]StatusUpkeep [$]AmmoLocation
1East Corp1895INF82100%Reg8a0.4Verdun
2East Corp1895INF82100%Elite8a0.4Toul
3East Corp1895CAV82100%Reg8a0.4Montbéliard
4North Corp1895INF82100%Reg8a0.4Marchiennes(Douais)
5North Corp1895INF82100%Reg8a0.4Rethel
6Ouest Corp1895CAV41100%Reg8a0.4Alençon
7Ouest Corp1895INF41100%Reg8a0.4Angoulème
8South Corp1895INF42100%Reg8a0.4Toulouse
9South Corp1895MTN41100%Reg8a0.4Grenoble
10Tonkin Corp1895INF42100%Reg8a0.4Hanoî
11New Caledonia1895INF42100%Reg8a0.4Nouméa
12Algeria Corp1895INF42100%Reg8a0.4Alger
13East Corp1895INF62100%Reg8r0.08Saint Diziers
14East Corp1895GAR66100%Reg8r0.08Vesoul
15Zouaves1895INF41200%Reg16r0.16Tanger
16Spahis1885CAV31100%Reg6r0.04Tanger
17Légionnaires1885INF84100%Elite16r0.08Mont de Marsan
18Tirailleurs Malgaches1885INF31100%Reg6r0.04Tananarive
19Tirailleurs Cambodgiens1885JNG31100%Reg6r0.04Phnom Penh
20Tirailleurs Sénégalais1885INF31100%Reg6r0.04Dakar
21Tirailleurs Haoussas1885INF31100%Reg6r0.04N'Djamena
22Tirailleurs Laosiens1885JNG31100%Reg6r0.04Vientiane
23Tirailleurs Tonkinois1885JNG31100%Reg6r0.04Hanoi
24Tirailleurs Tonkinois1885INF31100%Reg6r0.04Saigon
25Zouaves1885INF31100%Reg6r0.04Gabès
26Spahis1885CAV30.5100%Reg6r0.04Sfax
27Tirailleurs du Pacifique1885JNG30.5100%Reg6r0.04Ouégoa
29Tirailleurs Malgaches1885INF30.5100%Reg6r0.04Soalala
30Tirailleurs de Guinée1895INF30.5100%Reg8r0.08Conakry
31Tirailleurs Sénégalais1895INF30.5100%Reg8r0.08St Louis
32Tirailleurs Haoussas1895INF30.5100%Reg8r0.08Douala
33Tirailleurs Laosiens1895JNG30.5100%Reg8r0.08Muang Khong
34East Corp1895GAR46200%Reg16Stockp0Chaumont
35North Corp1895GAR46200%Reg16Stockp0Reims
36Zouaves1895INF30.5100%Reg8Stockp0Tunis
37Spahis1895CAV30.5100%Quiet8Stockp0Casablanca
38Légionnaires1895INF46100%Quiet8Stockp0Constantine
39Tirailleurs Malgaches1895INF30.5100%Quiet8Stockp0San Diego
40Tirailleurs Cambodgiens1895INF30.5100%Quiet8Stockp0Phnom Penh
41Tirailleurs Sénégalais1895JNG30.5100%Quiet8Stockp0Dakar
42Tirailleurs Haoussas1895INF30.5100%Quiet8Stockp0Yaoundé
43Tirailleurs Laosiens1895JNG30.5100%Quiet8Stockp0Paksé
44Tirailleurs Tonkinois1895JNG30.5200%Quiet16Stockp0Haiphong
45Tirailleurs Tonkinois1895INF30.5200%Quiet16Stockp0Nam Dinh
46Zouaves1895INF30.5200%Quiet16Stockp0Oran
47Spahis1895CAV30.5200%Quiet16Stockp0Agadir
48Tirailleurs du Pacifique1895JNG30.5100%Quiet8Stockp0Tahiti
49Tirailleurs Malgaches1895JNG30.5100%Quiet8Stockp0Tolanaro & Djibouty
6
$
"You French are fighting for money, while we English are fighting for honor!"
"Everyone is fighting for what they miss. "
Surcouf

Jefgte

Marine Nationale


AffectationTypeNamesDivisionsdispLD/Com/R.Div.Cost $Div.Cost BPStatutUpkeep
TangerCP1Danjoult-Dufort1er CR295018955.95.9reserve0.295
BrestAC1Neerwinden-Wissembourg1er CC5150189510.310.3active4.12
BrestBB1Tolbiac-Bouvines1er CU11300189522.622.6active9.04
ToulonBB1Malplaquet-Denain2eme CU11300189522.622.6reserve1.13
DunkerqueTB1TT1-TT2-TT3-TT41er TT30018961.51.2reserve0.06
DunkerqueTB1TT5-TT6-TT7-TT82eme TT30018961.51.2active0.48
ToulonTB1TT9-TT10-TT11-TT123eme TT30018961.51.2active0.06
ToulonTB1TT13-TT14-TT15-TT164eme TT30018961.51.2reserve0.48
DakarCP2Duvalles-Dassonville3eme CR320018966.46.4reserve0.32
Diego SuarezCP2Dentraigue-Duvillars4eme CR320018966.46.4active2.56
Fort BayardCP2Darras-Denevers5eme CR320018966.46.4active2.56
NouméaCP2Dufort-Dersignac6eme CR320018966.46.4reserve2.56
Fort BayardSBB1Marignan-Calais3eme CU7600189615.215.2active6.08
Fort BayardSBB1Rocroi-La Marsailles4eme CU7600189615.215.2reserve0.76
TunisAT1AT1-AT21ere AT154018973.083.08active1.232
TangerAT1AT3-AT42eme AT154018973.083.08reserve0.154
AlgerAT1AT5-AT63eme AT154018973.083.08reserve0.154
Port GentilAT1AT7-AT84eme AT154018973.083.08active1.232
Pointe à PitreAT1AT9-AT105eme AT154018973.083.08active1.232
OranAT1AT11-AT126eme AT154018973.083.08reserve0.154
BrestCP3Cocherel-Orléans6eme CR500018971010reserve0.5
BrestCP3Castillon-Formigny7eme CR500018971010active4
ToulonBB2Austerlitz-Iena7eme CU11750189723.523.5active9.4
ToulonBB2Arcole-Rivoli8eme CU11750189823.523.5reserve1.175
ToulonTB2TT17-TT18-TT19-TT205eme TT45018982.251.8reserve0.09
ToulonTB2TT21-TT22-TT23-TT246eme TT45018982.251.8reserve0.72
CherbourgTB2TT25-TT26-TT27-TT287eme TT45018982.251.8active0.72
TangerTB2TT29-TT30-TT31-TT328eme TT45018982.251.8reserve0.09
TangerTB2TT33-TT34-TT35-TT369eme TT45018982.251.8active0.09
ToulonAC2Fontenoy-Valmy2eme CC750018981515active6.00
BrestAC2Jemappes-Wattignies3eme CC750018981515active6.00
BrestTB3TT37-TT38TT39-TT4010eme TT50018992.52reserve0.10
BrestTB3TT41-TT42-TT43-TT4411eme TT50018992.52reserve0.10
ToulonTB3TT45-TT46-TT47-TT4812eme TT50018992.52active0.80
ToulonTB3TT49-TT50-TT51-TT5213eme TT50018992.52active0.80
Diego SuarezTB3TT53-TT54-TT55-TT5614eme TT50018992.52reserve0.10
Fort BayardTB3TT57-TT58TT59-TT6015eme TT50018992.52reserve0.10
NouméaTB3TT61-TT62-TT63-TT6416eme TT50018992.52active0.80
Diego SuarezAT2AT13 to AT147eme AT154018993.083.08active1.23
TahitiAT2AT15 to AT168eme AT154018993.083.08reserve0.15
DakarAT2AT17 to AT189eme AT154018993.083.08reserve0.15
Fort BayardAT2AT19 to AT2010eme AT154018993.083.08active1.23
OranCP5Carmelia-Cerres9eme CR4500189999active3.6
AlgerCP5Cantales-Courseau10eme CR4500189999reserve0.45
ToulonCP5Caliste-Cassandra11eme CR4500189999reserve0.45
73.52
YearTypeNameDivisiondispLD/Com/R.Cost $Cost BPUpkeep
"You French are fighting for money, while we English are fighting for honor!"
"Everyone is fighting for what they miss. "
Surcouf

Jefgte


Coastal Guns
Harbors or PlacesT2$BPActive4 x casemates$BPActive
Dunkerque3050.01621640.002
Dunkerque3050.01621640.002
Dunkerque3050.01621640.002
Dunkerque3050.01621640.002
Cap Gris Nez3050.01621640.002
Cap Gris Nez3050.01621640.002
Cap Gris Nez3050.01621640.002
Cap Gris Nez3050.01621640.002
Cap Gris Nez3050.01621640.002
Cherbourg3050.01621640.002
Cherbourg3050.01621640.002
Cherbourg3050.01621640.002
Cherbourg3050.01621640.002
Brest3050.01621640.002
Brest3050.01621640.002
Brest3050.01621640.002
Brest3050.01621640.002
Brest3050.01621640.002
Brest3050.01621640.002
Lorient3050.01621640.002
Lorient3050.01621640.002
St Nazaires3050.01621640.002
St Nazaires3050.01621640.002
St Nazaires001640.002
Rochefort001640.002
Bordeaux001640.002
Port Vendres001640.002
Toulon3050.01621640.002
Toulon3050.01621640.002
Toulon3050.01621640.002
Toulon3050.01621640.002
Fort de France001640.002
Pointe à Pitre3050.01621640.002
Bizerte3050.01621640.002
Tunis3050.01621640.002
Alger3050.01621640.002
Point Cires-Edallya3050.01621640.002
Point Cires-Edallya3050.01621640.002
Point Cires-Edallya3050.01621640.002
Point Cires-Edallya3050.01621640.002
Point Cires-Edallya3050.01621640.002
Tanger3050.01621640.002
Oran3050.01621640.002
Dakar3050.01621640.002
Port Gentil001640.002
Diego Suarez3050.01621640.002
Diego Suarez3050.01621640.002
La Réunion-le Port001640.002
Saigon3050.01621640.002
Saigon3050.01621640.002
Fort Bayard3050.01621640.002
Fort Bayard3050.01621640.002
Papeete001640.002
Nouméa3050.01621640.002
Nouméa3050.01621640.002
000.7614000.11
$BPActive$BPActive
total : 94x305
47T2xx305total : 220x164
240x164Total build BP :0
Total cost build $: 0
Total active cost: 0.872
"You French are fighting for money, while we English are fighting for honor!"
"Everyone is fighting for what they miss. "
Surcouf

Jefgte

For the Shipyards, SS are not finish...
"You French are fighting for money, while we English are fighting for honor!"
"Everyone is fighting for what they miss. "
Surcouf

snip

You appear to be missing the fuel-based upkeep.
You smug-faced crowds with kindling eye
Who cheer when solider lads march by
Sneak home and pray that you'll never know
The hell where youth and laughter go.
-Siegfried Sassoon

Jefgte

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
"You French are fighting for money, while we English are fighting for honor!"
"Everyone is fighting for what they miss. "
Surcouf

snip

I advise getting the spreadsheet from the UK 1900/H1 thread and grabbing the Naval page from there and inputing your ships into that.
You smug-faced crowds with kindling eye
Who cheer when solider lads march by
Sneak home and pray that you'll never know
The hell where youth and laughter go.
-Siegfried Sassoon

Jefgte

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

Thanks KW

Jef ;)
"You French are fighting for money, while we English are fighting for honor!"
"Everyone is fighting for what they miss. "
Surcouf

Tanthalas

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 ;)
"He either fears his fate too much,
Or his desserts are small,
Who dares not put it to the touch,
To win or lose it all!"

James Graham, 5th Earl of Montrose
1612 to 1650
Royalist General during the English Civil War

Jefgte

#10
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?


AffectationTypeNamesDivisionsdispLD/Com/R.Div.Cost $Div.Cost BPStatutUpkeepDimensionArmamentv_MaxRangeCruiseBunker
TangerCP1Danjoult-Dufort1er CR295018955.95.9reserve0.295101x13.4x4.614x140+4x10019.1650010938


I'll probably change all ship "active"
"You French are fighting for money, while we English are fighting for honor!"
"Everyone is fighting for what they miss. "
Surcouf

Tanthalas

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.
"He either fears his fate too much,
Or his desserts are small,
Who dares not put it to the touch,
To win or lose it all!"

James Graham, 5th Earl of Montrose
1612 to 1650
Royalist General during the English Civil War

Nobody

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

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
"You French are fighting for money, while we English are fighting for honor!"
"Everyone is fighting for what they miss. "
Surcouf

Jefgte

#14
Here is the 1900H1 Building Plan

Classement by Harbors/Shipyards


ShippricetonnageBP spentTons usedBP usedTons LeftBuild Report LeftSS & DD 70mx16
AC4-1$2.708 6002.727002.759002Dunkerque - D120
TB4-1$0.604800.484800.4800Dunkerque - D70
TB4-2$0.604800.484800.4800Dunkerque - S70
AC4-2$2.708 6002.727002.759002Le Havre - S120
TB4-3$0.604800.484800.4800Le Havre - S70
TB4-4$0.604800.484800.4800Le Havre - S70
BB3-1$3.0013800330003108003Cherbourg - S170
CP6-1$1.8053001.818001.835002Cherbourg - S120
CP6-2$1.8053001.818001.835002Cherbourg - D120
TB4-5$0.604800.484800.4800Cherbourg - S70
TB4-6$0.604800.484800.4800Cherbourg - D70
BB3-2$3.0013800330003108003Brest - S170
AC3-1$3.001200033000390003Brest - S170
AC3-2$3.001200033000390003Brest - D170
CP6-3$1.8053001.818001.835002Brest - S120
CP6-4$1.8053001.818001.835002Brest - D120
AT3-1$1.5042001.515001.527002Brest - D120
TB4-7$0.604800.484800.4800Brest - S70
TB4-8$0.604800.484800.4800Brest - S70
SS1-1to4$1.50100011000000Lorient - S170
AC4-3$2.7086002.727002.759002Lorient - S120
TB4-9$0.604800.484800.4800Lorient - S70
AC3-3$3.001200033000390003St Nazaires - D170
AC4-4$2.7086002.727002.759002St Nazaires - D120
TB4-10$0.604800.484800.4800St Nazaires - D70
AT3-2$1.5042001.515001.502Rochefort - S120
TB4-11$0.604800.484800.4800Rochefort - S70
TB4-12$0.604800.484800.4800Bordeaux - D70
AT3-3$1.5042001.515001.527002Bordeaux- D120
AC3-4$3.001200033000390003Bordeaux - D170
TB4-13$0.604800.484800.4800Port Vendres - S70
TB4-14$0.604800.484800.4800Port Vendres - S70
BB3-3$3.0013800330003108003Toulon - S170
BB3-4$3.0013800330003108003Toulon - D170
AT3-4$1.5042001.515001.527002Toulon - S120
AT3-5$1.5042001.515001.527002Toulon - D120
AT3-6$1.5042001.515001.527002Toulon - D120
TB4-15$0.604800.484800.4800Toulon - S70
TB4-16$0.604800.484800.4800Toulon - D70
Total62.1192 68059.685968058.68130300
pricetonnageBP spentTons usedBP usedTons LeftBuild Turn Left
"You French are fighting for money, while we English are fighting for honor!"
"Everyone is fighting for what they miss. "
Surcouf