Traitement de données

Bonjours a tous , j aimerais avoir une aide de votre part .

J aimerais savoir si il serait possible de gerer ce fichier txt pour calculer des valeurs comme le cumul des tours, meilleurs tours ainsi qu un classement

//[[gMa1.000f (c)2004    ]] [[            ]]
[Header]
Game=GTR2
Version=1.100
TimeString=2008/02/27 22:04:55
Aids=0,0,0,0,0,1,0,0,0

[Race]
RaceMode=5
Scene=GAMEDATA\LOCATIONS\Indianapolis\Indianapolis.TRK
AIDB=GAMEDATA\LOCATIONS\Indianapolis\Indianapolis.AIW
Race Length=0.100
Track Length=4189.2432

[Slot007]
Driver=CRO
Lobby Username=katoen
Vehicle=ACP08
VehicleNumber=0
Team=Team Belgium Spirit
QualTime=1:29.258
Laps=20
Lap=(0, -1.000, 1:40.335)
Lap=(1, 227.856, 1:30.309)
Lap=(2, 318.165, 1:30.574)
Lap=(3, 408.739, 1:37.600)
Lap=(4, 506.339, 1:31.096)
Lap=(5, 597.435, 1:30.164)
Lap=(6, 687.599, 1:31.091)
Lap=(7, 778.689, 1:30.699)
Lap=(8, 869.388, 1:30.698)
Lap=(9, 960.085, 1:31.726)
Lap=(10, 1051.811, 1:31.832)
Lap=(11, 1143.643, 1:31.326)
Lap=(12, 1234.969, 1:32.242)
Lap=(13, 1327.211, 1:32.178)
Lap=(14, 1419.389, 1:33.433)
Lap=(15, 1512.822, 2:29.229)
Lap=(16, 1662.051, 1:39.709)
Lap=(17, 1761.760, 1:31.544)
Lap=(18, 1853.305, 1:33.090)
Lap=(19, 1946.395, 1:34.245)
LapDistanceTravelled=3964.571045
BestLap=1:30.164
RaceTime=0:31:53.119

[Slot012]
Driver=Alpha
Lobby Username=[NTF] Alpha
Vehicle=ACP08
VehicleNumber=0
Team=Team Artefact
QualTime=1:31.869
Laps=0
LapDistanceTravelled=1116.059326
RaceTime=DNF
Reason=0

[Slot017]
Driver=[NTF] Ricco
Lobby Username=[NTF] Ricco
Vehicle=ACP08
VehicleNumber=0
Team=Team Djeuns Spirit
QualTime=1:28.368
Laps=0
LapDistanceTravelled=1605.995972
RaceTime=DNF
Reason=0

[Slot017]
Driver=[NTF] Ricco
Lobby Username=[NTF] Ricco
Vehicle=ACP08
VehicleNumber=0
Team=Team Djeuns Spirit
Laps=0
LapDistanceTravelled=3934.561523
RaceTime=DNF
Reason=0

[Slot017]
Driver=[NTF] Ricco
Lobby Username=[NTF] Ricco
Vehicle=ACP08
VehicleNumber=0
Team=Team Djeuns Spirit
Laps=0
LapDistanceTravelled=3934.561523
RaceTime=DNF
Reason=0

[Slot017]
Driver=[NTF] Ricco
Lobby Username=[NTF] Ricco
Vehicle=ACP08
VehicleNumber=0
Team=Team Djeuns Spirit
Laps=0
LapDistanceTravelled=3934.561523
RaceTime=DNF
Reason=0

[Slot017]
Driver=[NTF] Ricco
Lobby Username=[NTF] Ricco
Vehicle=ACP08
VehicleNumber=0
Team=Team Djeuns Spirit
Laps=0
LapDistanceTravelled=3934.561523
RaceTime=DNF
Reason=0

[Slot013]
Driver=angecris
Lobby Username=beraud
Vehicle=ACP08
VehicleNumber=0
Team=Team Artefact
QualTime=1:28.354
Laps=20
Lap=(0, -1.000, 1:40.767)
Lap=(1, 228.288, 1:30.020)
Lap=(2, 318.307, 1:30.675)
Lap=(3, 408.983, 1:35.806)
Lap=(4, 504.788, 1:29.005)
Lap=(5, 593.794, 2:06.562)
Lap=(6, 720.355, 1:36.521)
Lap=(7, 816.877, 1:29.088)
Lap=(8, 905.965, 1:28.848)
Lap=(9, 994.813, 1:29.625)
Lap=(10, 1084.438, 1:29.580)
Lap=(11, 1174.018, 1:29.496)
Lap=(12, 1263.514, 1:29.689)
Lap=(13, 1353.203, 1:29.508)
Lap=(14, 1442.712, 1:29.509)
Lap=(15, 1532.221, 1:29.347)
Lap=(16, 1621.568, 1:29.731)
Lap=(17, 1711.299, 1:29.332)
Lap=(18, 1800.632, 1:30.966)
Lap=(19, 1891.598, 1:31.142)
LapDistanceTravelled=3889.377686
BestLap=1:28.848
RaceTime=0:30:55.219

[Slot010]
Driver=[NTF] totoffe
Lobby Username=totoffe
Vehicle=ACP08
VehicleNumber=0
Team=Team Bordelais
QualTime=1:29.412
Laps=18
Lap=(0, -1.000, 1:51.602)
Lap=(1, 239.122, 1:38.468)
Lap=(2, 337.590, 1:41.706)
Lap=(3, 439.296, 1:31.144)
Lap=(4, 530.440, 1:31.576)
Lap=(5, 622.016, 2:15.599)
Lap=(6, 757.615, 2:22.363)
Lap=(7, 899.977, 1:41.718)
Lap=(8, 1001.696, 1:31.739)
Lap=(9, 1093.434, 1:31.239)
Lap=(10, 1184.673, 1:31.370)
Lap=(11, 1276.044, 1:31.109)
Lap=(12, 1367.153, 1:33.019)
Lap=(13, 1460.172, 1:31.901)
Lap=(14, 1552.073, 1:57.029)
Lap=(15, 1669.102, 1:39.315)
Lap=(17, 1870.075, 1:52.790)
LapDistanceTravelled=3999.426025
BestLap=1:31.109
RaceTime=0:30:55.345

[Slot002]
Driver=fred
Lobby Username=leouff
Vehicle=ACP08
VehicleNumber=0
Team=Team FoxRacing
Laps=17
Lap=(0, -1.000, 1:45.959)
Lap=(1, 233.480, 1:31.779)
Lap=(2, 325.259, 1:31.304)
Lap=(3, 416.562, 1:31.249)
Lap=(4, 507.811, 1:30.907)
Lap=(5, 598.718, 1:30.686)
Lap=(6, 689.405, 2:14.760)
Lap=(7, 824.165, 1:40.029)
Lap=(8, 924.193, 1:30.842)
Lap=(9, 1015.035, 1:31.749)
Lap=(10, 1106.785, 1:31.394)
Lap=(11, 1198.179, 1:32.458)
Lap=(12, 1290.637, 1:32.148)
Lap=(13, 1382.785, 2:56.754)
Lap=(14, 1559.539, 2:32.862)
Lap=(15, 1712.400, 2:35.484)
Lap=(16, 1867.884, 1:50.529)
LapDistanceTravelled=3908.849121
BestLap=1:30.686
RaceTime=0:30:50.893

[Slot016]
Driver=[NTF] Playmobil
Lobby Username=[NTF] Playmobil
Vehicle=ACP08
VehicleNumber=0
Team=Team Heineken
QualTime=1:30.408
Laps=19
Lap=(0, -1.000, 1:52.197)
Lap=(1, 239.717, 1:38.026)
Lap=(2, 337.744, 1:31.266)
Lap=(3, 429.010, 1:32.448)
Lap=(4, 521.458, 1:30.362)
Lap=(5, 611.820, 1:32.539)
Lap=(6, 704.359, 1:31.860)
Lap=(7, 796.219, 1:37.380)
Lap=(8, 893.599, 1:33.108)
Lap=(9, 986.708, 2:37.078)
Lap=(11, 1245.683, 1:34.068)
Lap=(13, 1430.612, 1:30.699)
Lap=(14, 1521.311, 1:31.297)
Lap=(15, 1612.608, 1:37.382)
Lap=(16, 1709.990, 1:31.648)
Lap=(17, 1801.638, 1:32.455)
Lap=(18, 1894.093, 1:31.578)
LapDistanceTravelled=3923.950928
BestLap=1:30.362
RaceTime=0:30:58.149

[Slot018]
Driver=nolimit
Lobby Username=nolimit
Vehicle=ACP08
VehicleNumber=0
Team=Team Artefact
QualTime=1:28.657
Laps=20
Lap=(0, -1.000, 1:43.425)
Lap=(1, 230.946, 1:31.534)
Lap=(2, 322.479, 1:30.209)
Lap=(3, 412.688, 1:32.136)
Lap=(4, 504.824, 2:12.410)
Lap=(5, 637.234, 1:37.651)
Lap=(6, 734.885, 1:29.929)
Lap=(7, 824.814, 1:30.557)
Lap=(8, 915.371, 1:30.348)
Lap=(9, 1005.719, 1:30.644)
Lap=(10, 1096.363, 1:30.557)
Lap=(11, 1186.920, 1:30.223)
Lap=(12, 1277.143, 1:30.401)
Lap=(13, 1367.543, 1:31.102)
Lap=(14, 1458.645, 1:30.699)
Lap=(15, 1549.344, 1:30.597)
Lap=(16, 1639.941, 1:31.203)
Lap=(17, 1731.144, 1:31.021)
Lap=(18, 1822.165, 1:30.779)
Lap=(19, 1912.943, 1:30.997)
LapDistanceTravelled=3946.249023
BestLap=1:29.929
RaceTime=0:31:16.420

[Slot011]
Driver=Burnout
Lobby Username=Burnout64
Vehicle=ACP08
VehicleNumber=0
Team=Team Andromede
QualTime=1:28.219
Laps=20
Lap=(0, -1.000, 1:38.456)
Lap=(1, 225.976, 1:29.636)
Lap=(2, 315.612, 1:29.143)
Lap=(3, 404.755, 1:29.134)
Lap=(4, 493.890, 1:29.206)
Lap=(5, 583.096, 2:03.955)
Lap=(6, 707.051, 1:36.449)
Lap=(7, 803.501, 1:30.031)
Lap=(8, 893.532, 1:29.807)
Lap=(9, 983.339, 1:29.502)
Lap=(10, 1072.841, 1:29.745)
Lap=(11, 1162.587, 1:28.935)
Lap=(12, 1251.522, 1:31.486)
Lap=(13, 1343.008, 1:31.026)
Lap=(14, 1434.034, 1:29.803)
Lap=(15, 1523.836, 1:29.728)
Lap=(16, 1613.565, 1:35.004)
Lap=(17, 1708.569, 1:29.753)
Lap=(18, 1798.322, 1:30.727)
Lap=(19, 1889.048, 1:30.535)
LapDistanceTravelled=4010.037842
BestLap=1:28.935
RaceTime=0:30:52.063

[Slot009]
Driver=cedric
Lobby Username=cedric duvivier
Vehicle=ACP08
VehicleNumber=0
Team=Team FoxRacing
QualTime=1:29.570
Laps=19
Lap=(0, -1.000, 1:42.985)
Lap=(1, 230.506, 1:31.125)
Lap=(2, 321.630, 1:29.788)
Lap=(3, 411.418, 1:30.440)
Lap=(4, 501.858, 1:29.490)
Lap=(5, 591.349, 2:22.079)
Lap=(6, 733.428, 1:37.840)
Lap=(7, 831.268, 1:31.952)
Lap=(8, 923.220, 1:29.930)
Lap=(9, 1013.149, 1:30.228)
Lap=(10, 1103.377, 1:30.383)
Lap=(11, 1193.760, 1:31.439)
Lap=(12, 1285.199, 1:31.117)
Lap=(13, 1376.317, 1:31.177)
Lap=(14, 1467.494, 1:32.158)
Lap=(15, 1559.652, 1:33.225)
Lap=(16, 1652.877, 1:31.649)
Lap=(17, 1744.526, 3:08.566)
Lap=(18, 1933.091, 1:38.866)
LapDistanceTravelled=3987.584473
BestLap=1:29.490
RaceTime=0:31:44.437

[Slot014]
Driver=Clemtomine
Lobby Username=Clemtomine
Vehicle=ACP08
VehicleNumber=0
Team=Team K Racing
QualTime=1:33.925
Laps=17
Lap=(0, -1.000, 1:48.370)
Lap=(1, 235.890, 1:34.131)
Lap=(2, 330.022, 3:56.424)
Lap=(3, 566.445, 1:42.907)
Lap=(4, 669.353, 1:33.467)
Lap=(5, 762.820, 1:33.611)
Lap=(6, 856.431, 1:32.092)
Lap=(7, 948.522, 1:32.882)
Lap=(8, 1041.405, 1:31.710)
Lap=(9, 1133.114, 1:32.100)
Lap=(10, 1225.214, 2:48.417)
Lap=(11, 1393.631, 1:47.828)
Lap=(12, 1501.459, 1:37.412)
Lap=(13, 1598.872, 1:35.213)
Lap=(14, 1694.084, 1:30.950)
Lap=(15, 1785.034, 1:41.457)
Lap=(16, 1886.491, 1:33.335)
LapDistanceTravelled=3901.148438
BestLap=1:30.950
RaceTime=0:30:52.306

[Slot005]
Driver=McGivre
Lobby Username=McGivre
Vehicle=ACP08
VehicleNumber=0
Team=Team Racing BELGA
QualTime=1:30.976
Laps=19
Lap=(0, -1.000, 1:51.898)
Lap=(1, 239.419, 1:36.090)
Lap=(2, 335.509, 1:33.348)
Lap=(3, 428.857, 1:35.718)
Lap=(4, 524.575, 1:32.840)
Lap=(5, 617.415, 1:33.266)
Lap=(6, 710.681, 1:32.771)
Lap=(7, 803.452, 1:36.740)
Lap=(8, 900.192, 1:33.701)
Lap=(9, 993.893, 2:44.154)
Lap=(10, 1158.048, 1:43.022)
Lap=(11, 1261.070, 1:38.271)
Lap=(12, 1359.340, 1:39.403)
Lap=(13, 1458.743, 1:35.109)
Lap=(14, 1553.852, 1:33.822)
Lap=(15, 1647.674, 1:32.528)
Lap=(16, 1740.202, 1:33.581)
Lap=(17, 1833.783, 1:32.479)
Lap=(18, 1926.263, 1:32.526)
LapDistanceTravelled=3942.373535
BestLap=1:32.479
RaceTime=0:31:31.268

[Slot001]
Driver=[NTF]  Nikko
Lobby Username=NIKKO95
Vehicle=ACP08
VehicleNumber=0
Team=Team Virtual Ruf Crew
QualTime=1:27.082
Laps=20
Lap=(0, -1.000, 1:36.742)
Lap=(1, 224.262, 1:28.722)
Lap=(2, 312.984, 1:27.794)
Lap=(3, 400.779, 1:28.278)
Lap=(4, 489.057, 2:03.677)
Lap=(5, 612.733, 1:37.285)
Lap=(6, 710.018, 1:28.566)
Lap=(7, 798.584, 1:28.777)
Lap=(8, 887.362, 1:28.253)
Lap=(9, 975.615, 1:28.815)
Lap=(10, 1064.430, 1:28.508)
Lap=(11, 1152.938, 1:29.907)
Lap=(12, 1242.845, 1:29.484)
Lap=(13, 1332.330, 1:29.169)
Lap=(14, 1421.499, 1:29.211)
Lap=(15, 1510.711, 1:28.226)
Lap=(16, 1598.937, 1:29.909)
Lap=(17, 1688.846, 1:28.998)
Lap=(18, 1777.844, 1:30.571)
Lap=(19, 1868.414, 1:29.641)
LapDistanceTravelled=3897.250977
BestLap=1:27.794
RaceTime=0:30:30.535

[Slot001]
Driver=[NTF]  Nikko
Lobby Username=NIKKO95
Vehicle=ACP08
VehicleNumber=0
Team=Team Virtual Ruf Crew
Laps=0
LapDistanceTravelled=3897.239502
RaceTime=DNF
Reason=0

[Slot004]
Driver=MadMax
Lobby Username=MadMax200cc
Vehicle=ACP08
VehicleNumber=0
Team=Team Virtual Ruf Crew
QualTime=1:28.264
Laps=20
Lap=(0, -1.000, 1:38.243)
Lap=(1, 225.764, 1:28.914)
Lap=(2, 314.677, 1:28.320)
Lap=(3, 402.997, 1:29.062)
Lap=(4, 492.059, 1:28.920)
Lap=(5, 580.979, 2:02.501)
Lap=(6, 703.480, 1:37.684)
Lap=(7, 801.163, 1:30.479)
Lap=(8, 891.643, 1:29.916)
Lap=(9, 981.559, 1:29.492)
Lap=(10, 1071.051, 1:29.703)
Lap=(11, 1160.753, 1:29.580)
Lap=(12, 1250.333, 1:29.580)
Lap=(13, 1339.913, 1:31.090)
Lap=(14, 1431.003, 1:29.851)
Lap=(15, 1520.854, 1:29.863)
Lap=(16, 1610.718, 1:29.977)
Lap=(17, 1700.695, 1:30.195)
Lap=(18, 1790.890, 1:30.074)
Lap=(19, 1880.964, 1:30.078)
LapDistanceTravelled=3931.148682
BestLap=1:28.320
RaceTime=0:30:43.521

[Slot008]
Driver=Julien Thirifays
Lobby Username=Julien Thirifays
Vehicle=ACP08
VehicleNumber=0
Team=Team Belgium Spirit
QualTime=1:28.659
Laps=20
Lap=(0, -1.000, 1:39.293)
Lap=(1, 226.814, 1:30.504)
Lap=(2, 317.318, 1:28.904)
Lap=(3, 406.222, 1:29.027)
Lap=(4, 495.248, 1:29.834)
Lap=(5, 585.082, 1:29.341)
Lap=(6, 674.423, 1:30.742)
Lap=(7, 765.165, 1:29.266)
Lap=(8, 854.432, 1:29.650)
Lap=(9, 944.081, 2:08.219)
Lap=(10, 1072.300, 2:10.874)
Lap=(11, 1203.174, 1:36.771)
Lap=(12, 1299.945, 1:30.771)
Lap=(13, 1390.716, 1:35.747)
Lap=(14, 1486.463, 1:37.972)
Lap=(15, 1584.435, 1:29.806)
Lap=(16, 1674.241, 1:29.694)
Lap=(17, 1763.935, 1:30.146)
Lap=(18, 1854.081, 1:30.142)
Lap=(19, 1944.223, 1:31.587)
LapDistanceTravelled=3976.357666
BestLap=1:28.904
RaceTime=0:31:48.290

[Slot015]
Driver=Wildman_fr
Lobby Username=wildman_fr
Vehicle=ACP08
VehicleNumber=0
Team=ERC NORTH AMERICA
QualTime=1:28.717
Laps=19
Lap=(0, -1.000, 1:45.531)
Lap=(1, 233.052, 1:40.103)
Lap=(2, 333.155, 1:41.262)
Lap=(3, 434.417, 1:33.053)
Lap=(4, 527.470, 1:30.753)
Lap=(5, 618.223, 1:31.532)
Lap=(6, 709.755, 1:30.586)
Lap=(7, 800.341, 1:30.395)
Lap=(8, 890.736, 1:30.637)
Lap=(9, 981.373, 1:29.400)
Lap=(10, 1070.773, 1:29.985)
Lap=(11, 1160.758, 1:30.245)
Lap=(12, 1251.003, 2:42.975)
Lap=(13, 1413.978, 1:39.774)
Lap=(14, 1513.751, 1:31.189)
Lap=(15, 1604.941, 1:31.035)
Lap=(16, 1695.975, 1:29.224)
Lap=(17, 1785.199, 1:38.636)
Lap=(18, 1883.835, 1:30.014)
LapDistanceTravelled=3919.562744
BestLap=1:29.224
RaceTime=0:30:46.329

[Slot006]
Driver=[NTF]crifouir
Lobby Username=crifouir
Vehicle=ACP08
VehicleNumber=0
Team=Team Bordelais
QualTime=1:30.565
Laps=19
Lap=(0, -1.000, 1:49.569)
Lap=(1, 237.089, 1:40.450)
Lap=(2, 337.539, 1:36.795)
Lap=(3, 434.334, 1:33.204)
Lap=(4, 527.538, 2:25.654)
Lap=(5, 673.192, 1:39.474)
Lap=(6, 772.667, 1:33.275)
Lap=(7, 865.941, 1:33.046)
Lap=(8, 958.987, 1:33.621)
Lap=(9, 1052.609, 1:33.474)
Lap=(10, 1146.083, 1:34.320)
Lap=(11, 1240.403, 1:39.250)
Lap=(12, 1339.652, 1:34.965)
Lap=(13, 1434.617, 1:33.991)
Lap=(14, 1528.609, 1:34.456)
Lap=(15, 1623.065, 1:32.935)
Lap=(16, 1716.000, 1:32.674)
Lap=(17, 1808.675, 1:32.136)
Lap=(18, 1900.810, 1:34.768)
LapDistanceTravelled=3953.947510
BestLap=1:32.136
RaceTime=0:31:08.058

[Slot000]
Driver=sizey
Lobby Username=SIZEY
Vehicle=ACP08
VehicleNumber=0
Team=Team Autobacs Racing
QualTime=1:29.682
Laps=19
Lap=(0, -1.000, 1:45.514)
Lap=(1, 233.034, 1:33.195)
Lap=(2, 326.229, 1:30.272)
Lap=(3, 416.501, 1:30.627)
Lap=(4, 507.128, 1:33.756)
Lap=(5, 600.884, 1:30.616)
Lap=(6, 691.500, 2:32.077)
Lap=(7, 843.577, 1:37.787)
Lap=(8, 941.364, 1:31.060)
Lap=(9, 1032.424, 1:36.815)
Lap=(10, 1129.239, 1:31.412)
Lap=(11, 1220.650, 1:33.204)
Lap=(12, 1313.854, 1:34.868)
Lap=(13, 1408.722, 1:31.631)
Lap=(14, 1500.353, 1:36.561)
Lap=(15, 1596.914, 1:32.952)
Lap=(16, 1689.866, 1:31.759)
Lap=(17, 1781.625, 1:31.379)
Lap=(18, 1873.004, 1:32.974)
LapDistanceTravelled=3885.969727
BestLap=1:30.272
RaceTime=0:30:38.457

[Slot007]
Driver=CRO
Lobby Username=katoen
Vehicle=ACP08
VehicleNumber=0
Team=Team Belgium Spirit
QualTime=1:29.258
Laps=20
Lap=(0, -1.000, 1:40.335)
Lap=(1, 227.856, 1:30.309)
Lap=(2, 318.165, 1:30.574)
Lap=(3, 408.739, 1:37.600)
Lap=(4, 506.339, 1:31.096)
Lap=(5, 597.435, 1:30.164)
Lap=(6, 687.599, 1:31.091)
Lap=(7, 778.689, 1:30.699)
Lap=(8, 869.388, 1:30.698)
Lap=(9, 960.085, 1:31.726)
Lap=(10, 1051.811, 1:31.832)
Lap=(11, 1143.643, 1:31.326)
Lap=(12, 1234.969, 1:32.242)
Lap=(13, 1327.211, 1:32.178)
Lap=(14, 1419.389, 1:33.433)
Lap=(15, 1512.822, 2:29.229)
Lap=(16, 1662.051, 1:39.709)
Lap=(17, 1761.760, 1:31.544)
Lap=(18, 1853.305, 1:33.090)
Lap=(19, 1946.395, 1:34.245)
LapDistanceTravelled=3964.570801
BestLap=1:30.164
RaceTime=0:31:53.119

[END]

Ce sont des données issue d une jeu GTR2 en fin de course

hello

tente un copier/coller du texte dans EXcel

puis tu enlèves tout ce qui est inintéressant et tu fais tes calculs.

bon travail

oui j avais pense a ce mais il faut pas que je supprime car pour les courses d endurance a la fin des 12h ou de 24h de course il a plusieur millier de tour par pilote ca devient vite ingerable

re

alors au lieu de supprimer, tu crées de nouvelles colonnes

= SI(GAUCHE(A1;3)="Lap";A1;"")

la formule est sans doute à adapter

le principe est de remplir ces colonnes avec les infos qui t'intéressent (d'où le test de comparaison si le mot Lap est trouvé) et de laisser vide ce qui ne t'intéresse pas, d'où le ""

ensuite tu traites les nouvelles colonnes.