What do you suggest for 4 cars?

[burns...@gmail.com]

Chris I love the spreadsheet. it will work great. I have a question that I need your thoughts on. 

Our Pack has a 3 lane track and i downloaded the 3 lanes spreadsheet. My Bear den this year has only 4 members, what do you suggest?

[Chris Sutton]

I see the problem.   The 3-lane spreadsheet is setup for 3, 5, 6, 7 .. 15 cars.   But not 4.   I don't remember why 4 is missing. 

 

As a workaround, you could add "pace car" so you have 5 cars.  Maybe use one of last year's cars, or a car that a dad built.  But the agreement is the pace car can't win.  It would be skipped/ignored in the results.

 

Another option would be to use the 8-car spreadsheet but put each racer in twice.   This would be more complicated to score. 

 

Chris

--
You received this message because you are subscribed to the Google Groups "Pinewood Derby Spreadsheet" group.
To unsubscribe from this group and stop receiving emails from it, send an email to pinewood-derby-spre...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[rcm...@aol.com]

Same problem here. But I think I've created a solution.

I took the 5-car spreadsheet, copied and doubled it, tossed out the races involving car #5,  rearranged the cells, and fixed the references and formulas. Each car runs 3 times in each lane, for a total of 12 races.

Take a look at: http://www.richardcmoeur.com/cub/pine3n-4cars.xls

--
Richard C. Moeur, P.E.
Pack 242 Pinewood Derby Chair
Four Peaks District Pinewood Derby Co-Chair
Phoenix, Arizona, USA
(602) 909-8451
http://www.richardcmoeur.com
http://twitter.com/rcmoeur
http://www.facebook.com/rcmoeur
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -