Help testing new version of spreadsheet?

[Jonathon E.]

All,

I appreciate so much the work that has been done on these Pinewood Derby spreadsheets.  It makes the event go so much smoother!

I am attaching a modified version of the 4-lane spreadsheet, and I would appreciate anyone's help beta testing and providing feedback.  The improvements I have sought to make are:

1. A single spreadsheet that adapts and formats itself for anywhere from 4 to 20 cars.
2. A "Now Racing" and "Up Next" section at the top of the spreadsheet, that shows everyone (if projected on a wall) who is racing in what lane, and who is up next.

Again, any feedback would be appreciated.  If this spreadsheet proves helpful or workable, I would be happy to contribute it to the group and make it freely available to all.

Jonathon English

Pack 380

Utah National Parks Council

--

[Chris Sutton]

Jonathan,

 

Wow.   I just tried this and it auto-configured as advertised.   It uses Excel features better than I realized was possible. 

 

I would like to post it.  But we can wait a few days to see if you get any feedback or testing. 

 

I was stuck for a while at the very first step of entering names because I was not sure where to enter the names.    It would help if the note that says “Start by entering a minimum of four names right here, ....

 

 

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/d/optout.

[niel....@gmail.com]

IS there a two lane version of this sheet.?

[Jonathon E.]

No. We have a four-lane track, so that's what I developed for.

[Jonathon E.]

Chris,

I'm attaching a version of the spreadsheet that makes it a little more obvious where to start typing.

Jonathon

To unsubscribe from this group and stop receiving emails from it, send an email to pinewood-derby-spreadsheet+unsub...@googlegroups.com.

[Chris]

This is easy to use.   Thanks for sharing it.      I put a copy on https://sites.google.com/site/pinewoodscore/ so others can find it.  

Thanks

Chris

[Jonathon E.]

Thanks, Chris.  I hope others find it useful.  I had a request the other day for a modification that would allow more than 20 racers.  If I get around to doing it, I'll let you know!

Cheers.

--
You received this message because you are subscribed to a topic in the Google Groups "Pinewood Derby Spreadsheet" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/pinewood-derby-spreadsheet/DyqQSfSdKqs/unsubscribe.
To unsubscribe from this group and all its topics, send an email to pinewood-derby-spreadsheet+unsub...@googlegroups.com.

[hayden....@gmail.com]

Hi Jonathan,

Just wondering if you got round to developing this for more than 20 racers?

Thanks

Hayden Small
Kerikeri Cub Scouts
Northland
New Zealand

[Jonathon E.]

Hayden,

Actually, yes, I recently expanded it to 40 cars this Spring.  See attached version.

Cheers.

[hayden....@gmail.com]

That's awesome. Thanks so much for that.

[miranda...@gmail.com]

Hi Jonathon,

I found your spreadsheets online and they are awesome! We have a 4 lane but with a timer. It says in the tips we could enter time in seconds but in the newest 40 car version we can only enter a number 1-4. Is it possible to get a version that will allow for a time with several decimal places? Thanks so much for making this!

Thanks so much!!

Miranda

Pack 136

Beaverton, OR

[Jonathon E.]

Miranda,

Thanks for the feedback.  I understand that you have a four-lane track, and would like a spreadsheet where you can record each car's time for each race.  There are different formats of spreadsheets on the site where you found mine, but mine was never designed for times.  (The person who maintains https://sites.google.com/site/pinewoodscore/ wrote the notes/tips that you read, and I really don't know him personally.)  My spreadsheet calculates points based on 1st through 4th placing in each race, and was designed to give all scouts the same number of opportunities to race, regardless of how well their car performs.  It's not a bracketing system.  While, in theory, columns to record times could be added to the spreadsheet, it would not add anything to the basic philosophy of the system.

I'm sorry I could not be of more help.  I wish you the best in finding a system that works for your pack.

Jonathon English

--

--

You received this message because you are subscribed to a topic in the Google Groups "Pinewood Derby Spreadsheet" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/pinewood-derby-spreadsheet/DyqQSfSdKqs/unsubscribe.

To unsubscribe from this group and all its topics, send an email to pinewood-derby-spre...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/pinewood-derby-spreadsheet/5ea16fc8-d180-46d4-b691-c22dda5b1efd%40googlegroups.com.

[Joshua Atha]

Hello,

Is there a two lane version of this?

That would be great if there is!

[chris.k...@gmail.com]

The only 2-lane spreadsheet I am aware of is Pine2n-jtd.xlsm at https://sites.google.com/site/pinewoodscore/Spreadsheets?authuser=0.   It does not have Jonathon’s enhancements.

 

Chris

 

 

From: pinewood-derb...@googlegroups.com <pinewood-derb...@googlegroups.com> On Behalf Of Joshua Atha
Sent: Monday, April 19, 2021 8:26 PM
To: Pinewood Derby Spreadsheet <pinewood-derb...@googlegroups.com>

--

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.
To view this discussion on the web visit https://groups.google.com/d/msgid/pinewood-derby-spreadsheet/0c1d7e96-6cf6-431b-95f0-0d5b47d7d11bn%40googlegroups.com.