Hi,(adsbygoogle = window.adsbygoogle || []).push({});

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

**Physics Forums - The Fusion of Science and Community**

# Need to construct a forumla

Know someone interested in this topic? Share a link to this question via email,
Google+,
Twitter, or
Facebook

- Similar discussions for: Need to construct a forumla

Loading...

**Physics Forums - The Fusion of Science and Community**