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**

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

# Need to construct a forumla

Loading...

Similar Threads - Need construct forumla | Date |
---|---|

I Teacher needs maths assistance please | Jan 18, 2018 |

I Need Aproximate expressions for : ln(x) and 1/ln(x) Thanks | Nov 1, 2017 |

I think this is my first proof but need help constructing it | Aug 29, 2011 |

Need to construct a finite series with certain properties | Aug 21, 2009 |

Need help learning to construct proofs | Jan 19, 2007 |

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