Hi,
I am not sure if this question is in the right area or can be answers in this forum, but I will put it out anyway.
I want to construct a formula to answer the following question. A race car does 10 laps, each lap the fuel load (weight) reduces therefore the lap time reduces however the driver can not complete each lap exactly the same therefore the times do not reduce consistently. What I want to do is work out at how much time does each litre of fuel cost per lap and how much time is reduced for each lap worth of fuel
example
5 litres of fuel needed per lap
lap number
10 1:22.853
9 1:22.822
8 1:22:825
7 1:22:801
6 1:22:799
5 1:22.765
4 1:22.788
3 1:22:770
2 1:22:762
1 1:22:765
I will have 10 cells on a excel worksheet where I can enter the times next to the corresponding lap number then in the 11th cell the answer =time per lap/fuel 12th cell time per litre/fuel
Thanks in advance
I am not sure if this question is in the right area or can be answers in this forum, but I will put it out anyway.
I want to construct a formula to answer the following question. A race car does 10 laps, each lap the fuel load (weight) reduces therefore the lap time reduces however the driver can not complete each lap exactly the same therefore the times do not reduce consistently. What I want to do is work out at how much time does each litre of fuel cost per lap and how much time is reduced for each lap worth of fuel
example
5 litres of fuel needed per lap
lap number
10 1:22.853
9 1:22.822
8 1:22:825
7 1:22:801
6 1:22:799
5 1:22.765
4 1:22.788
3 1:22:770
2 1:22:762
1 1:22:765
I will have 10 cells on a excel worksheet where I can enter the times next to the corresponding lap number then in the 11th cell the answer =time per lap/fuel 12th cell time per litre/fuel
Thanks in advance