View Single Post
  #26  
Old November 22nd, 2016, 04:53 AM

Kiwikkiwik Kiwikkiwik is offline
BANNED USER
 
Join Date: Mar 2016
Posts: 183
Thanks: 8
Thanked 21 Times in 16 Posts
Kiwikkiwik is on a distinguished road
Default Re: Cross country speeds

Thank you for your reply DRG
I see from other posts you are very busy trying to keep us all happy, thank you for that also.
OK you are right A10 is wrong. In the spreadsheet in column H I have changed rounddown in the formula to round and left rounddown as rounddown in other columns.
I also checked my spreadsheet again and found an error and corrected it.
I also added a column (Q) that shows the vehicles that have a cross county speed higher than in the book and by how much.
I also sorted the spreadsheet to show the tanks wich deviate most from your values at the top.
I understand these book cross country values are not sacrosant but they are probably correct? I have no reason to beleive they are wrong or made up.
I can see the reasoning that because of terrain variability cross country speeds will be about right.
But if you compare two vehicles I think the problem becomes clear.
Compare the Tiger 1 and Sherman, both with nearly the same max speed (38 and 38.6 kph) this gives them both a crosscountry speed of 6 hexs.
But using the book crosscountry speeds of 3 and 8 there is a difference of 5 hexes in their speed per turn.
So if they move over the same terrain, for example clear the sherman will always move two hexs too few and the tiger will always move three hexes too far, every move.
If you change the terrain type the tiger will nearly always move too far the Sherman not far enough. It doesnt equal out over a game.
The early Marders are 4 hexes too fast crosscountry, Jentz says because the chassis was overloaded.
The french AMC's are 4 hexes to slow because their crosscountry speed is nearly the same as their road speed.

Looking at Mobhack I see each vehicle has a speed (Max) and a swim speed. Maybe crosscountry speed can be put into swim speed? then calculate swim speed or just have a generic swim speed?

I redid my sample list with just the most exceptional for these Sample OObs (and better justified).

Battle is fire and movement.
I am sorry to bother you with this but I think making slow vehicles slow and fast vehicles fast would be a great addition.


Nation_Vehicle__Book_Game_____Book_Game
________________Road_Road_____RoughRough
________________SpeedSpeedDiffSpeedSpeedDiff
________________Hex__Hex__Hex_Hex__Hex__Hex
Fra_AMC_34_YR___13___13___0___10____6___4
Fra_AMC_35______13___13___0___10____6___4
Fra_Char_B______11____9___2____5____4___1
Fra_FCM_2C/bis___4____6___2____2____3___1
Fra_FT-17________3____6___3____2____3___1
Fra_H-35_________9___11___2____4____5___1
Fra_R-35_________6____8___2____4____4___0
Fra_Somua_S-35__16___14___2____7____7___0
Ger_Jagdpanther_15___15___0____5____7___2
Ger_Jagdtiger___11___12___1____4____6___2
Ger_Kfz_70_Pr___23___20___3___11___10___1
Ger_Las_762_____18___13___5____6____6___0
Ger_Marder_I_37_12___12___0____2____6___4
Ger_Marder_I_39_12___12___0____2____6___4
Ger_MarderIII_H_16___13___3____6____6___0
Ger_MarderIII_M_16___14___2____6____7___1
Ger_Panther_____15___17___2___10____8___2
Ger_PanzerjagI__10___14___4____3____7___4
Ger_PzKpfw_38t__14___14___0____5____7___2
Ger_PzKpfw_I_A__12___13___1____4____6___2
Ger_PzKpfw_I_B__13___13___0____4____6___2
Ger_PzKpfw_I_C__22___26___4___11___13___2
Ger_PzKpfw_II_D-18___17___1____6____8___2
Ger_PzKpfw_II_E_18___14___4____6____7___1
Ger_PzKpfwLuchs_20___18___2___15____9___6
Ger_Pz_III_E/F__13___14___1____5____7___2
Ger_SdKfz_11____18___18___0____7____9___2
Ger_SdKfz231(8)_28___28___0___10___14___4
Ger_SdKfz_233___28___28___0___10___14___4
Ger_SdKfz_234___28___28___0___10___14___4
Ger_SdKfz_8_____17___14___3____7____7___0
Ger_Sturmpz_IV__13___12___1____8____6___2
Ger_Tiger_I_____13___13___0____3____6___3
GB__A_9_________13___13___0____8____6___2
GB__A13_Mk_I____16___16___0___12____8___4
GB__Archer_______8___11___3____4____5___1
GB__Bishop_______8___10___2____3____5___2
GB__Cavalier____13___17___4____7____8___1
GB__Centaur_____14___16___2____8____8___0
GB__Centurionk__11___11___0____8____5___3
GB__Comet_A_34__15___17___2____8____8___0
GB__Covenator___16___18___2___13____9___4
GB__Cromwell_I__21___22___1____9___11___2
GB__Cromwell_VI_17___20___3____9___10___1
GB__Grant_______14___12___2____8____6___2
GB__Honey_AOP___19___21___2___10___10___0
GB__Honey_Recce_19___24___5___10___12___2
GB__MK_II-MK_III16___16___0___10____8___2
GB__MK_VIB/C____19___19___0___13____9___4
GB__M10_17_pdr__16___17___1___10____8___2
GB__M22_Locust__21___20___1___16___10___6
GB__Matilda_Mk_I_4____6___2____3____3___0
GB__Sexton______13___13___0___10____6___4
GB__Sherman_____13___13___0____8____6___2
GB__Tetrarch____21___22___1___15___11___4
GB__Vickers_Med__9____7___2____5____3___2
GB__Vickers_Vali_6___11___5____3____5___2
SU__BT-2/5______37___17___2___16____8___8
SU__BT-7________25___17___8___16____8___8
SU__BT-7M_______29___17___1___16____8___8
SU__IS-1________12___12___0____8____6___2
SU__KV-1________12___10___2____6____5___1
SU__T-34________18___18___0___13____9___4
SU__T-34-85_17__18___17___1___11____9___2
SU__T-37________12___12___0____8____6___2
SU__T-40________15___15___0___10____7___3
SU__T-44________17___17___0___13____8___5
SU__T-50________18___17___1___13____8___5
SU__T-60________15___15___0___10____7___3
SU__T-70________17___15___2___10____7___3
USA_90_GMCM36___16___15___1____9____7___2
USA_Combtcar_M1_24___24___0____9___12___3
USA_M10_76mm____16___17___1___10____8___2
USA_M18_Hellcat_24___27___3___10___13___3
USA_M22_locust__21___20___1___16___10___6
USA_M24_Chaffee_19___17___2___13____8___5
USA_M26Pershing_11___15___4____2____7___5
USA_M2A2Mae-West15___21___6____9___10___1
USA_M2A4________15___20___5____9___10___1
USA_M3_Lee______14___12___2____8____6___2
USA_M39_________24___27___3___10___13___3
USA_M3A3________19___17___2___10____8___2
USA_M3A3/M3A5___14___13___1____8____6___2
USA_M4_Duplex___13___12___1____8____6___2
USA_M4_Sherman__13___13___0____8____6___2
USA_M4A3_105____15___13___2____9____6___3
USA_M5/M5A1_____19___20___1___12___10___2
USA_M8__________16___16___0___12____8___4

The.book.speeds.are.from.these.books.
Chamberlain.and.Ellis,.British.and.American.Tanks. of.World.War.II.
Chamberlain.and.Milsom,.Allied.Combat.Tanks.
Chamberlain.and.Ellis,.Axis.Combat.Tanks.
Cappellano.and.Battistelli,.Italian.medium.tanks.1 939-45.
Cappellano.and.Battistelli,.Italian.light.tanks.19 19-45.
Encycopedia.of.WW2.weapons
Attached Files
File Type: xls TrackedCrossCountrySpeeds.xls (304.5 KB, 217 views)