Podesavanja setupa Yeongam SSS

Sheets by Brendon Avery and Robert Filipe – Version 1.3.000

Setup&WS

Fill the data in the yellow cells to get the perfect setup for the track.

For this calculation each track needs to have a Base value filled in columns S to W in the Tracks sheet.

If you know the perfect setup for the track under the conditions expressed by the data in the yellow boxes, but no the base value for the track, you can fill in G23:G28 to get the base values for that track.

Tyre&Fuel

Fill the data in the yellow cells to get the fuel consumption and tyre and parts wear for the track.

G18 can be used to find out specific details for different number of laps.

Tracks

All track info is saved on this sheet.

Columns from S onwards are Base values to be used in the calculations and can be filled once you find out the values.

Tables

Do not edit.

These are just auxiliary data tables for the calculations, placed here to clean up the other sheets.

ReverseCalc

On this sheet you'll be able to determine each tracks base value for the different calculations, by using data from previous races.

The more data you use the more accurate the base value will be.

For this calculation each track needs to have a Base value filled in columns S to W in the Tracks sheet.

If you know the perfect setup for the track under the conditions expressed by the data in the yellow boxes, but no the base value for the track, you can fill in G23:G28 to get the base values for that track.

Columns from S onwards are Base values to be used in the calculations and can be filled once you find out the values.

On this sheet you'll be able to determine each tracks base value for the different calculations, by using data from previous races.

94 0

205 0

122 0

0 0

85 0 Front Wings

59 Rear Wings

17 6 Engine

185 5 Brake

38 Gears

0 Suspension

68 Track

31 Temp Hum Weather Front Wings

Q1 44 40 Dry Rear Wings

Q2 41 35 Dry Engine

34 Race 44 41 Dry Brake

36 Gears

34 Suspension

Level Wear 42 45 37 47 Front Wings

Chassis 3 27 43 47 35 44 Rear Wings

Engine 3 0 41 45 36 45 Engine

Front wing 2 71 41 45 38 48 Brake

Rear wing 3 0 Gears

Underbody 3 81 Suspension

Sidepods 3 0

Cooling 2 74

Gearbox 2 67 Q1 Setup

Brakes 3 9 (FW+RW)/2 814

Suspension 3 0 Engine 335

Electronics 2 62 Brake 580

Gears 439

Suspension 348

684.97

373.55

436.81

512.15

351.32

Temp Hum

Determine track Base Values

Track Base

Weight(kg) New Delhi

Age

Car

Power

Handling

Acceleration Race Weather Details

Aggressiveness Experience

Experience Pit coordination

Technical insight Staff

Stamina Stress handling

Charisma Concentration

Motivation

Reputation Stint Details

Talent R&D aerodynamics

Concentration R&D electronics Perfect Setups

Driver Tech director

OA R&D mechanics

Q1 Q2 Race Q1

Low Setup High Wings 1301.66 528 492 526 -301.030797

731 531 841 Engine 554.84 -132 -123 -131.5 63.4990409

731 1040 841 Brake 555.46 264 246 263 -60.756

488 542 596 Gears 718.94 -176 -164 -175.33 102.5

645 699 753 Suspension 161.86 -264 -246 -263 199.75

592 646 700

105 159 213

Happy Range Generic TD

715 518 825 Wings 110 112 Q1 Q2

715 1023 825 Engine 108 112 -254.48 -252.74979

498 552 606 Brake 108 112

627 681 735 Gears 108 112

604 658 712 Suspension 108 112

123 177 231

730 530 840

730 1039 840

488 542 596

644 698 752

592 646 700

106 160 214

RA

CE

Wing Split

Q2

Q1

DriverPerfect SetupsTrack Base

Weather

Setup Factor Calculations

Q2 Race Q1 Q2 Race

-295.105642 -300.701622 42.44 785.534601 770.497179 784.699189

64.765669 63.5694091 55.46 541.799041 552.065669 542.369409

-60.756 -60.756 -60.05 698.654 680.654 697.654

102.5 102.5 0.35 645.79 657.79 646.456667

199.75 199.75 60.93 158.54 176.54 159.54

Race

-254.381432

Wing Split

DriverCar

Setups

Setup Factor Calculations

Race Dry

Tyre Wear 1800 %

Brand Pipirelli

Type Extra Soft

Extra Soft 7 31 25.0 307.739

Soft 5 41 25.3 221.591

L/km Total L Medium 4 49 25.6 178.41

Fuel 0.79 242.69 Hard 3 61 26.0 135.087

Rain 2 70 26.3 90.6975

Máx. Km Laps

Tyres 50.2 9.768904084

Normal

60 Pitstops 6

19

Stint1 Stint2 Stint3 Stint4

Laps 9 9 9 9

Tyre Final Wear 787.1 % 787.1 % 787.1 % 787.1 %

Fuel Needed 37 l 37 l 37 l 37 l

No stop

1 Stop

Custom Stint 18 2 Stops

Final Wear ####### 3 Stops

Fuel Needed 73 l 4 Stops

Est. Pit time 26.4554

Overtaking

Laps

Pit I/O

Avg. Pit time

Tyre & Fuel Calculations

Race Details Chosen pit strategy details

Req.

Stops

Fuel

Load

Estm. Pit

TimePits

Race Options

Weather Determines Lost time due to pitting, fuel load and Tyre choice

(at which point the tyres should be replaced)

Tyres Lost Time (s)

26.7131 0 334.45

37.3984 5.47399 264.46

46.748 10.948 236.11

62.3306 16.422 213.84

80.1977 - 170.90

CT Risk 25

Stint5 Start Est.Wear End

9 Chassis 27 19 46

787.1 % Total Engine 0 34 34

37 l 185 l Front wing 71 30 101

Rear wing 0 24 24

Fuel Pitstop Underbody 81 18 99

185 l 30.4358 Sidepods 0 11 11

93 l 27.1484 Cooling 74 15 89

62 l 26.0526 Gearbox 67 27 94

46 l 25.5047 Brakes 9 35 44

37 l 25.176 Suspension 0 31 31

26.8635 Electronics 62 9 71

Estimated Parts Wear

Avg. Pit time

TCD Total

Chosen pit strategy details

Fuel

Load

Determines Lost time due to pitting, fuel load and Tyre choice

(at which point the tyres should be replaced)

Lost Time (s)

Track List WS BaseName Wings (19) Engine Brakes Gear Suspension WS (25)

A1-Ring 252.93 693.74 720.73 789.26 509.84 141.46

Adelaide 631.9 496.9 358.33 549.99 652.05 122.99

Ahvenisto 993.04 466.54 699.74 766.1 240.15 210.95

Anderstorp 250.72 699.88 769.29 611.18 107.05 74.73

Austin 521.56 605.59 608.9 640.62 786.9 173.6

Barcelona 464.91 670.27 501.63 674.01 316.45 133.75

Brands Hatch 483.6 647.54495 386.69197 709.39821 641.46833 121.775344

Brasilia 577.88029 409.23081 697.755 849.605 784.06 30.13

Brno 488.34301 517.01117 377.59667 554.278 490.13273 54.1332365

Bucharest Ring 275.1 654.7 711.7 592.07 744.75 137.26

Buenos Aires 901.29277 516.57393 272.05175 654.41483 706.34042 190.079156

Estoril

Fiorano

Fuji

Hockenheim

Hungaroring 853.49 439.15 572.06 434.29 416.75 70.77

Imola

Indianapolis

Indianapolis Oval -60.29 734.05 22.31 900.47 305.27 50.05

Interlagos

Irungattukottai

Istanbul 384.15 542.44666 701.98 544.11 634.96 118.92

Jerez

Kaunas

Kyalami

Laguna Seca

Magny Cours

Melbourne

Mexico City 632.08 700.96 470.54 671.13 323.13 32.32

Monte Carlo 939.09 372.71 472.54 376.37 494.83 168.28

Montreal 335.19099 677.81879 566.84333 718.10333 237.85 -130.19

Monza 124.19 735.83 495.997 868.17 610.97 14.82

Mugello

New Delhi 650.83 554.84 555.46 718.94 161.86 -100.96

Nurburgring

Oesterreichring

Paul Ricard

Portimao 784.38 390.49 485.96 486.98 295.12 174.03

Poznan

Sakhir 129.64223 402.51533 716.705 604.365 245.5 -8.95

Sepang

Shanghai 414.26814 532.36766 641.86167 355.0025 116.695 111

Silverstone 283.41 699.48 590.85 823.25 415.1 28.57

Singapore 847.57 439.34 578.7 597.72 801.9 196.53

Slovakiaring

Spa 585.63902 716.49414 446.824 609.47063 372.54417 52.0456585

Suzuka

Valencia

Yas Marina

Yeongam 787.19 481.33 722.19 686.93 419.73 171.78

Zandvoort 542.27792 654.6843 416.28564 779.58121 707.29 -31.57

Zolder

Track Base Setup

Tyre BaseL/km (27) L/km (wet) Wear (30) Cha (32) Eng FW RW UndB SidP Coo GeaB

0.875 0.9630 28.486 54.402 18.114 19.507 18.823 22.878 16.152 37.125

0.803 0.680 0.9885 37.92 18.96 40.44 48.03 43.19 25.64 30.33 29.69

0.843 0.9336 17.53 23.92 25.81 24.76 20.63 28.70 14.41 23.10

0.889 0.785 0.9710 24.73 50.99 19.27 17.74 42.59 26.26 14.30 41.37

0.867 0.752 1.0512 17.33 37.11 29.46 29.46 19.44 17.91 19.06 30.04

0.874 1.0933 25.81 60.23 44.74 53.35 33.98 27.79 22.09 35.68

0.831 0.613 1.0405 10.62 31.69 20.09 24.85 27.81 15.60 12.10 21.25

0.900 0.622 1.0165 19.61 39.60 24.76 31.93 20.41 18.83 21.55 32.75

0.847 0.702 0.9921 26.05 44.46 28.62 23.26 27.82 26.22 24.80 30.57

0.913 0.781 1.0263 29.47 65.6 29.47 31.11 37.66 27.2 20.8 46.4

0.797 0.572 1.0016 30.17 54.03 23.38 29.79 21.38 17.76 25.13 57.31

0.776 0.649 1.0158 25.39 38.82 78.07 71.65 35.82 18.71 15.34 50.24

0.897 0.749 1.0706 27.34 74.45 15.47 17.45 34.25 20.50 24.46 14.57

0.864 0.694 1.0905 26.84 29.50 16.70 18.91 20.04 20.04 26.47 21.14

0.828 0.683 1.0308 12.82 24.76 16.35 14.27 20.69 14.07 19.24 32.46

0.813 1.0707 15.07 17.69 57.34 57.34 29.31 10.02 14.99 30.59

0.856 0.735 1.0759 26.22 47.44 27.02 16.32 25.37 18.46 12.60 37.34

0.901 1.0733 30.58 60.92 19.94 14.62 27.92 23.93 18.61 45.2

0.880 0.768 0.9573 26.87 47.03 38.63 33.59 25.19 15.12 20.15 35.27

0.838 0.712 1.0314 24.526 22.63 24.526 26.161 45.786 22.076 21.256 22.63

0.928 0.690 1.0912 27.76 61.56 33.59 26.54 25.80 31.19 36.08 31.05

0.914 0.645 1.0588 20.82 58.46 34.62 40.16 34.69 28.32 26.77 38.95

0.880 0.681 1.1568 24.63 52.79 22.87 26.39 28.15 15.84 15.84 36.95

0.854 0.571 1.0501 28.922 21.498 35.536 30.575 34.727 26.494 28.922 29.479

0.884 0.452 1.0480 28.13 52.79 28.14 32.66 32.50 19.96 16.25 40.40

0.842 0.767 1.0336 29.17 43.17 31.35 34.39 20.90 22.42 23.94 25.93

0.826 0.583 1.0581 41.06 67.55 50.33 39.74 34.44 29.49 26.49 38.41

Fuel 2 Base Parts Wear Base

Bra Sus Ele

43.926 25.879 19.478

24.01 14.85 21.60

29.80 21.59 9.36

53.62 20.96 11.90

35.81 14.33 14.33

54.37 43.02 18.93

38.54 37.95 19.75

46.71 20.32 16.88

34.74 27.71 19.87

59.2 32.75 26.2

72.59 50.25 19.90

32.61 54.54 12.46

8.64 30.39 17.45

44.49 18.12 14.99

14.27 37.60 17.04

50.10 39.53 13.39

50.60 44.68 12.47

55.25 30.58 19.94

48.71 43.67 11.76

34.336 51.711 17.986

36.16 36.33 17.49

43.85 49.74 18.71

26.39 22.87 12.32

45.458 27 24.295

44.66 50.08 15.77

32.87 27.65 19.39

74.17 56.95 22.52

Parts Wear Base

Temp Offset

Wings 1 263 6

Engine 0.7 -190 -3

Brakes 3.9884 105.533 6

Gear -8.02 -4.7427 -4

Suspsensions -1 -257 -6

Cha Eng F Wing R Wing Und Side Cool Gear Brake Susp

Wings -19.74 30.03 30.03 -15.07

Engine 16.04 4.9

Brakes 6.04 -29.14

Gearbox -41

Suspension -15.27 -10.72 6.03 31

Wings 0.47 -0.59 -0.59 0.32

Engine -0.51 -0.09

Brakes -0.14 0.71

Gearbox 1.09

Suspension 0.34 0.23 -0.12 -0.7

Conc Tal Aggr Exp Weight

Wings

Engine 0.2952 0

Brakes -0.498 -60.76

Gearbox 0.5 102.5

Suspension 0.75 2 199.75

Factor F*Att

Concentration 0.1665 34.1325 0.1670

Talent 0.2490 30.378 0.2490

Agressiveness 0.1455 0 0.1450

Experience 0.0847 7.1995 0.0870

Technical insight 0.1245 7.3455 0.1250

Stamina 0.1440 2.448 0.1450

Charisma 0.0829 15.3365 0.0829

Motivation 0.0835 3.173 OA 0.0840

Weight -0.0827 -5.6236 94.389 -0.0827

Conc Agg Exp TI Eng lvl Elec lvl

Factors -0.0001 0.0001 -0.0001 -0.0002 -0.0127 -0.0084 -0.0926

Type Factor max km

Extra Soft 0 0.998 0.4039 50.2

Wear

Setup Calculation – Driver Influence Table

Driver Overall Calculation

Fuel Calculation – Using method 2

Tyre Wear Calculation

Setup Calculation - Weather Influence Table

WetDry

Setup Calculation – Car Influence Table

Level

Soft 1 0.997 0.5326 66.2

Medium 2 0.996 0.7095 88.1

Hard 3 0.996 0.9492 117.9

Rain 5 0.996 1.7534 159.0

Pipirelli 1

Yokomama 2

Dunnolop 4

Badyear 7

Michelini 5

Bridgerock 6

Very high 4

High 3

Medium 2

Low 1

Very low 0

Base Wear

Trk Wear AvgT T Dur T Type Susp Agg Exp Weig CT

Values 4 43.8333 1 0 3 0 85 68 25

Factors 0.896 0.988 1.049 1.355 1.009 1.000 1.000 1.000 0.998

Factors^Val 0.6457 0.60133 1.0489 1 1.0283 1 1.0197 0.99 0.955 0.4039

8 8 8 8 8

1 1 1 1 1

Common Factor 0.6001

Lvl Factor

1 1.0193

2 1.0100

3 1.0073

4 1.0053

5 1.0043

6 1.0037

7 1.0043

8 1.0097

9 1.0052

TD No TD

0.0315 0.0355 0.0355

-0.0945 -0.0798 -0.0798

-0.0355 0 0.0000

-0.0094 0 0.0000

-0.0113 0 0.0000

24.26

TD Pit Coordination

Base Pitstop

Fuel Tanked No

Staff Concentration

Staff Stress Handling

TD Experience

Lap Calcs

Parts Wear Calculation

CT

Ris

k F

acto

rs / L

vl

Pit Stop Estimated Refuel Time

Using TD?

Selected Track

Track Wear Very high

129.776458172

Race Pit Stop Calculation

Pipirelli 0.000

Yokomama 0.050

Dunnolop 0.070

Badyear 0.090

Michelini 0.075

Bridgerock 0.080

Tyre Compound Difference

Elec

45.72

3.34 64.6

6.11 -57.08

9 -64

33.12

-3.28

-0.04 -9.14

-0.09 -2.97

-0.14 64.35

27.81

Wear

Setup Calculation – Driver Influence Table

Driver Overall Calculation

Fuel Calculation – Using method 2

Tyre Wear Calculation

Setup Calculation - Weather Influence Table

Setup Calculation – Car Influence Table

Level

Parts Wear Calculation

Pit Stop Estimated Refuel Time

Race Pit Stop Calculation

Tyre Compound Difference

FW+RW 1060

Denom -4320 FW

A 0.0000111 RW

FW – RW Time (Secs) B -0.0005667 FW – RW

0 28.441 C 28.441

6 28.438 XV 25.500

30 28.434 YV 28.434

WS Base Tal FW lvl RW lvl FW RW Temp

118.92 181 7 7 543 517 36

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

118.92 Average

Fuel Base Fuel Used Km Done Conc Agg Exp TI

0.901 217.6 306.711 212 22 179 131

0.000

0.000

0.000

0.000

0.000

0.000

0.000

0.000

0.000

0.901 Average

Tyre Base Máx Km Track Wear Avg Temp T Brand T Type Susp lvl

1.0734 82.671 Medium 26.38 Yokomama Extra Soft 7

1.0694 81.773 Medium 27 Yokomama Extra Soft 7



0.0000 Medium Pipirelli Medium






1.0733 Average

Race 1 Chassis Engine Front wing Rear wing Underbody Sidepods

Determine the Parts base value

FW and RW represent the best WS

Determine the Fuel base value ( dry / wet )

If race is full wet or dry then race totals can be used instead of stint totals

Determine the Tyre base value


Determine the best WS based on 3 laps with different WS

Formula Proposed Wings

Study Laps

Determine the Wing Split base value

Level 7 6 7 7 7 7

Wear 23 43 15 11 21 18

Conc Tal Exp CT

212 181 179 100


Level 3 3 2 3 2 3

Wear 19 36 19 21 20 13

Conc Tal Exp CT

199 65 78 0


Level 3 3 2 3 2 3

Wear 17 33 18 20 21 12

Conc Tal Exp CT

199 65 78 0

Base Values Chassis Engine Front wing Rear wing Underbody Sidepods

Race 1 30.58 60.92 19.94 14.62 27.92 23.93

Race 2 29.01 54.96 29.01 32.06 30.54 19.85

Race 3 25.96 50.38 27.48 30.54 32.06 18.32

Average 28.51 55.42 25.48 25.74 30.17 20.70

30.58 60.92 19.94 14.62 27.92 23.93

Driver

Driver

Driver

542.75

517.25

25

Weather

Dry

Dry

Dry

Dry

Dry

Dry

Dry

Dry

Dry

Dry

EngLvl EleLvl

6 7

Type

Agg Exp Weig CT Extra Soft 0

22 179 53 100 Soft 1

22 179 53 100 Medium 2

22 179 53 100 Hard 3

22 179 53 100 Rain 5

Cooling Gearbox Brakes Suspension Electronics

Determine the Parts base value

FW and RW represent the best WS

Determine the Fuel base value ( dry / wet )


Determine the Tyre base value


Determine the best WS based on 3 laps with different WS

Proposed Wings

Determine the Wing Split base value

7 7 6 7 7

14 34 39 23 15


3 3 2 3 3

11 25 30 33 9


3 3 2 3 3

12 26 30 31 10


18.61 45.20 55.25 30.58 19.94

16.79 38.17 45.80 50.38 13.74

18.32 39.70 45.80 47.33 15.27

17.91 41.02 48.95 42.76 16.32

18.61 45.2 55.25 30.58 19.94

Factor Pipirelli 1 Very high 4

0.998 Yokomama 2 High 3

0.997 Dunnolop 4 Medium 2

0.996 Badyear 7 Low 1

0.996 Michelini 5 Very low 0

0.996 Bridgerock 6

Lvl Factor

1 1.0193

2 1.0100

3 1.0073

4 1.0053

5 1.0043

6 1.0037

7 1.0043

8 1.0097

9 1.0052

Podesavanja setupa Yeongam SSS

Documents

Transcript of Podesavanja setupa Yeongam SSS