Spreadsheet: 32866d1229030134-help-with-formula-race-data
Sheet: Car Wear

Average wear per level
Chassis | Avg. Wear | Engine | Avg. Wear | Fwing | Avg. Wear | Rwing | Avg. Wear
1 | 0.09999999999999998 | 1 | #N/A | 1 | 0.27 | 1 | 0.27
2 | 0.2666666666666667 | 2 | 0.3125 | 2 | 0.49 | 2 | 0.5
3 | #N/A | 3 | #N/A | 3 | #N/A | 3 | #N/A
4 | #N/A | 4 | #N/A | 4 | #N/A | 4 | #N/A
5 | #N/A | 5 | #N/A | 5 | #N/A | 5 | #N/A
6 | #N/A | 6 | #N/A | 6 | #N/A | 6 | #N/A
Season 12 |  |  |  |  |  |  |  | Season 12 |  |  |  |  |  |  |  | Season 12 |  |  |  |  |  |  |  | Season 12
Race 3 | No. of laps: | 76 | KMs / Lap: | 3.861 |  |  |  | Race 4 | No. of laps: | 71 | KMs / Lap: | 4.251 |  |  |  | Race 5 | No. of laps: | 55 | KMs / Lap: | 3.369 |  |  |  | Race 6 | No. of laps: | 62 | KMs / Lap: | 4.929
[NAME] |  |  |  |  |  |  |  | Zandvoort |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | Imola
 | Overtake | Defend | Clear |  |  |  |  |  | Overtake | Defend | Clear |  |  |  |  |  | Overtake | Defend | Clear |  |  |  |  |  | Overtake | Defend | Clear
Risks | 32 | 30 | 45 |  |  |  |  | Risks | 15 | 25 | 25 |  |  |  |  | Risks | 0 | 0 | 2 |  |  |  |  | Risks | 0 | 0 | 2
Car part | Level | Start | End | Wear | Avg. Wear a lap | Avg. Wear per Km |  | Car part | Level | Start | End | Wear | Avg. Wear a lap | Avg. Wear per Km |  | Car part | Level | Start | End | Wear | Avg. Wear a lap | Avg. Wear per Km |  | Car part | Level | Start | End | Wear | Avg. Wear a lap | Avg. Wear per Km
Chassis | 2 | 0.16 | 0.45 | 0.29 | 0.003815789473684211 | 0.0009882904619746727 |  | Chassis | 2 | 0.45 | 0.79 | 0.34 | 0.004473684210526316 | 0.001052383959192265 |  | Chassis | 1 | 0.67 | 0.77 | 0.09999999999999998 | 0.00131578947368421 | 0.0003905578728656011 |  | Chassis | 2 | 0 | 0.17 | 0.17 | 0.002394366197183099 | 0.0004857711903394398
Engine | 2 | 0.65 | 0.99 | 0.34 | 0.004473684210526315 | 0.001158685369211685 |  | Engine | 2 | 0 | 0.52 | 0.52 | 0.006842105263157895 | 0.001609528408176404 |  | Engine | 2 | 0.52 | 0.63 | 0.11 | 0.001447368421052631 | 0.0004296136601521613 |  | Engine | 2 | 0.63 | 0.91 | 0.28 | 0.003943661971830987 | 0.0008000937252649597
Fwing | 2 | 0.14 | 0.44 | 0.3 | 0.003947368421052632 | 0.001022369443422075 |  | Fwing | 2 | 0.44 | 0.85 | 0.41 | 0.005394736842105263 | 0.001269051244908319 |  | Fwing | 1 | 0.72 | 0.99 | 0.27 | 0.003552631578947368 | 0.001054506256737123 |  | Fwing | 2 | 0 | 0.27 | 0.27 | 0.003802816901408451 | 0.0007715189493626396
Rwing | 2 | 0.14 | 0.51 | 0.37 | 0.004868421052631579 | 0.001260922313553893 |  | Rwing | 2 | 0.51 | 0.85 | 0.34 | 0.004473684210526315 | 0.001052383959192264 |  | Rwing | 1 | 0.72 | 0.99 | 0.27 | 0.003552631578947368 | 0.001054506256737123 |  | Rwing | 2 | 0 | 0.29 | 0.29 | 0.004084507042253521 | 0.0008286685011672796
Underbody | 2 | 0.14 | 0.47 | 0.33 | 0.004342105263157895 | 0.001124606387764282 |  | Underbody | 2 | 0.47 | 0.77 | 0.3 | 0.003947368421052633 | 0.0009285740816402335 |  | Underbody | 2 | 0.77 | 0.93 | 0.16 | 0.002105263157894737 | 0.000624892596584962 |  | Underbody | 2 | 0 | 0.23 | 0.23 | 0.00323943661971831 | 0.0006572198457533597
Sidepods | 2 | 0.14 | 0.34 | 0.2 | 0.002631578947368421 | 0.00068157962894805 |  | Sidepods | 2 | 0.34 | 0.6 | 0.26 | 0.003421052631578947 | 0.0008047642040882019 |  | Sidepods | 2 | 0.6 | 0.68 | 0.08000000000000007 | 0.001052631578947369 | 0.0003124462982924812 |  | Sidepods | 2 | 0.68 | 0.82 | 0.1399999999999999 | 0.001971830985915492 | 0.0004000468626324795
Cooling | 2 | 0.14 | 0.37 | 0.23 | 0.003026315789473684 | 0.0007838165732902574 |  | Cooling | 2 | 0.37 | 0.62 | 0.25 | 0.003289473684210526 | 0.0007738117347001942 |  | Cooling | 2 | 0.62 | 0.72 | 0.09999999999999998 | 0.00131578947368421 | 0.0003905578728656011 |  | Cooling | 2 | 0.72 | 0.88 | 0.16 | 0.002253521126760564 | 0.0004571964144371199
Gear | 2 | 0.16 | 0.48 | 0.32 | 0.004210526315789473 | 0.00109052740631688 |  | Gear | 2 | 0.48 | 0.81 | 0.3300000000000001 | 0.004342105263157895 | 0.001021431489804257 |  | Gear | 2 | 0.81 | 0.97 | 0.1599999999999999 | 0.002105263157894736 | 0.0006248925965849616 |  | Gear | 3 | 0 | 0.26 | 0.26 | 0.003661971830985915 | 0.0007429441734603196
Brakes | 2 | 0.51 | 0.99 | 0.48 | 0.00631578947368421 | 0.00163579110947532 |  | Brakes | 3 | 0 | 0.52 | 0.52 | 0.006842105263157895 | 0.001609528408176404 |  | Brakes | 3 | 0.52 | 0.76 | 0.24 | 0.003157894736842105 | 0.0009373388948774429 |  | Brakes | 2 | 0.64 | 0.96 | 0.32 | 0.004507042253521126 | 0.0009143928288742394
Suspension | 2 | 0.15 | 0.42 | 0.27 | 0.003552631578947368 | 0.0009201324990798674 |  | Suspension | 2 | 0.42 | 0.87 | 0.45 | 0.005921052631578948 | 0.00139286112246035 |  | Suspension | 1 | 0.73 | 0.93 | 0.2000000000000001 | 0.002631578947368422 | 0.0007811157457312027 |  | Suspension | 2 | 0 | 0.27 | 0.27 | 0.003802816901408451 | 0.0007715189493626396
Electrical | 2 | 0.14 | 0.3 | 0.16 | 0.002105263157894736 | 0.0005452637031584398 |  | Electrical | 2 | 0.3 | 0.52 | 0.22 | 0.002894736842105264 | 0.0006809543265361711 |  | Electrical | 2 | 0.52 | 0.61 | 0.08999999999999997 | 0.001184210526315789 | 0.000351502085579041 |  | Electrical | 2 | 0.61 | 0.76 | 0.15 | 0.002112676056338028 | 0.0004286216385347998