Sum of lap times in order to give race time at any lap

**shockerty** · 04-13-2009, 01:51 PM

Hi,

Right I'm making a basic table in order to help determine how much fuel a car should carry and when to refuel mid-race, as well as how much fuel to refuel, in order to get the fastest time. Anyway, I have this function for laptime:

=C4+(0.3*(C5-((C2-1)*C3)))

Where C4 is 'Qualifying time', C5 is 'Starting fuel', C2 is 'Lap number' and C3 is 'Fuel consumption'. I also plan to make the 0.3 a changeable variable.

I'm not fussed as to whether or not this is a realistic function that would work in a real race, it's only hypothetical. However I would like to have a function that would give me the over all race time at any given lap, not just the lap time for it. Anyone got any ideas what equation I could use in order to give me that without doing a whole new table of every lap's details?

Cheers.

**zbor** · 04-13-2009, 01:55 PM

Isn't that =TOTAL TIME/LAP NUMBER * LAP?

=C4/C2*Cx

Edit: Sorry, I think you didn't ask for this... Hmmm, I didn't really get what you want :-S

**shockerty** · 04-13-2009, 02:14 PM

Not quite what I was looking for, but thanks!

C4 is qualifying time. i.e. lap time of the car in the qualifying round. The details though aren't important. Basically the equation I gave gives the laptime of any given lap. I want another cell to give me the total race time so far at the end of that lap.

So for example the for the 17th lap, the equation I gave will tell me how fast the car should do lap 17 in. I want another cell telling me how much time has elapsed at the end of lap 17 since the start of the race.

It's a bit complex I know. I might just make a table which works out the lap time for each lap and just =SUM the lap times to give me overall race time. Just hoped to do it in one cell instead of using a huge table.

**daddylonglegs** · 04-13-2009, 02:19 PM

Try

=SUMPRODUCT(C4+(0.3*(C5-((ROW(INDIRECT("1:"&C2))-1)*C3))))

**shockerty** · 04-13-2009, 02:37 PM

:D Perfect! Thanks daddylonglegs!

**shg** · 04-13-2009, 06:44 PM

Or =C2 * (C4 + 0.3 * (C5 - C3 * (C2 -1) / 2) )

**daddylonglegs** · 04-13-2009, 07:48 PM

Hey shg!

Nice!

**shockerty** · 04-15-2009, 08:18 AM

Cheers guys! You've been a great help. shg your soloution is alot easier for a novice like me to get my head around. Ha. Thanks for both your time though!

**McLeod40** · 08-08-2014, 10:03 PM

Fuel Calculator.xlsx Fuel Calculator.xlsxHey,

Just come across this post, I use for online sim racing to work out pit stops, when is the earliest I can fuel up, and the latest. Doesn't include any lap times but could possibly help you out?

Sum of lap times in order to give race time at any lap

LinkBack

Thread Tools

Rate This Thread

Display

Sum of lap times in order to give race time at any lap

Re: Sum of lap times in order to give race time at any lap

Re: Sum of lap times in order to give race time at any lap

Re: Sum of lap times in order to give race time at any lap

Re: Sum of lap times in order to give race time at any lap

Re: Sum of lap times in order to give race time at any lap

Re: Sum of lap times in order to give race time at any lap

Re: Sum of lap times in order to give race time at any lap

Re: Sum of lap times in order to give race time at any lap

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions