How to guide for spreadsheet

Debates and discussions on the various race scheduling methods that can be used and their fairness and accuracy in determining the winners.
Post Reply
bobcatbrown520
Journeyman
Journeyman
Posts: 25
Joined: Mon Jan 15, 2018 11:54 am
Location: Collinsville, IL

How to guide for spreadsheet

Post by bobcatbrown520 »

Is there any guides for how to make a race schedule in a spreedsheet program so I can import it as a csv file?

Sent from my LG-H810 using Tapatalk

User avatar
Vitamin K
Pine Head Legend
Pine Head Legend
Posts: 1227
Joined: Sat Apr 20, 2013 7:26 pm
Location: Spotsylvania, VA

Re: How to guide for spreadsheet

Post by Vitamin K »

bobcatbrown520 wrote: Fri Feb 09, 2018 8:13 pm Is there any guides for how to make a race schedule in a spreedsheet program so I can import it as a csv file?

Sent from my LG-H810 using Tapatalk
Do you mean creating a roster in a spreadsheet and then importing it into GPRM?
User avatar
gpraceman
Site Admin
Site Admin
Posts: 4919
Joined: Fri Jun 20, 2003 12:46 am
Location: Highlands Ranch, CO
Contact:

Re: How to guide for spreadsheet

Post by gpraceman »

bobcatbrown520 wrote: Fri Feb 09, 2018 8:13 pm Is there any guides for how to make a race schedule in a spreedsheet program so I can import it as a csv file?
Import into what? GrandPrix Race Manager?
Randy Lisano
Romans 5:8

Awana Grand Prix and Pinewood Derby racing - Where a child, an adult and a small block of wood combine for a lot of fun and memories.
bobcatbrown520
Journeyman
Journeyman
Posts: 25
Joined: Mon Jan 15, 2018 11:54 am
Location: Collinsville, IL

Re: How to guide for spreadsheet

Post by bobcatbrown520 »

Vitamin K wrote:
bobcatbrown520 wrote: Fri Feb 09, 2018 8:13 pm Is there any guides for how to make a race schedule in a spreedsheet program so I can import it as a csv file?

Sent from my LG-H810 using Tapatalk
Do you mean creating a roster in a spreadsheet and then importing it into GPRM?
Yes create in spreadsheet and import into gprm

Sent from my LG-H810 using Tapatalk

User avatar
gpraceman
Site Admin
Site Admin
Posts: 4919
Joined: Fri Jun 20, 2003 12:46 am
Location: Highlands Ranch, CO
Contact:

Re: How to guide for spreadsheet

Post by gpraceman »

The specs are in the software's Help file. Simply put, the contents of your file can look like this 4 lane example, where each line is a heat:

1,2,3,4
2,3,4,1
3,4,1,2
4,1,2,3

For Versions 15 and below, those numbers must start at 1 and go up to the number of cars, with no number gaps.

for Versions 16 and above, you can do like V15 and below or use actual car numbers (can have number gaps).
Randy Lisano
Romans 5:8

Awana Grand Prix and Pinewood Derby racing - Where a child, an adult and a small block of wood combine for a lot of fun and memories.
bracketracer
Pine Head
Pine Head
Posts: 85
Joined: Sun Mar 24, 2013 11:08 pm
Location: St. Louis, Missouri

Re: How to guide for spreadsheet

Post by bracketracer »

bobcatbrown520 wrote: Sun Feb 11, 2018 12:45 am
Vitamin K wrote:
Do you mean creating a roster in a spreadsheet and then importing it into GPRM?
Yes create in spreadsheet and import into gprm

Sent from my LG-H810 using Tapatalk
I may have misunderstood your question, but if you're importing a roster, the format you need is:
(copied from the help menu in GPRM)
"Values are separated by commas or tabs, as applicable. The default column order is:
LastName, FirstName, Group, Subgroup, VehicleNumber, CustomField, PassedInspection, Image, Exclude
The data fields in bold are required. The rest are optional."

GPRM will assign the car numbers if you leave that field blank but I like to assign car numbers in numerical order to the registered racers and give the unregistered racers higher numbers so everyone in the pack is in the data file but the boys that aren't likely to show up don't leave empty holes on the staging table if that makes sense.

I just copy the roster from the pack's website, paste it into an Excel spreadsheet, configure it as above, save it in the .csv format, then import it into a new data file in GPRM. You don't need to create any groups or subgroups or anything like that, those will be created for you when you import your spreadsheet. I understand that GPRM now has a data mapping feature for importing that puts the data in the correct order but I just bought v17 and I haven't tried that yet. Our race isn't until next year so I'm not in a hurry, yet!
bobcatbrown520
Journeyman
Journeyman
Posts: 25
Joined: Mon Jan 15, 2018 11:54 am
Location: Collinsville, IL

Re: How to guide for spreadsheet

Post by bobcatbrown520 »

gpraceman wrote:The specs are in the software's Help file. Simply put, the contents of your file can look like this 4 lane example, where each line is a heat:

1,2,3,4
2,3,4,1
3,4,1,2
4,1,2,3

For Versions 15 and below, those numbers must start at 1 and go up to the number of cars, with no number gaps.

for Versions 16 and above, you can do like V15 and below or use actual car numbers (can have number gaps).
So if I need a BYE lane would it look like

0 1 2 3

Sent from my LG-H810 using Tapatalk

User avatar
gpraceman
Site Admin
Site Admin
Posts: 4919
Joined: Fri Jun 20, 2003 12:46 am
Location: Highlands Ranch, CO
Contact:

Re: How to guide for spreadsheet

Post by gpraceman »

bobcatbrown520 wrote: Sun Feb 11, 2018 1:41 pm So if I need a BYE lane would it look like

0 1 2 3
Yes, that is correct.
Randy Lisano
Romans 5:8

Awana Grand Prix and Pinewood Derby racing - Where a child, an adult and a small block of wood combine for a lot of fun and memories.
bobcatbrown520
Journeyman
Journeyman
Posts: 25
Joined: Mon Jan 15, 2018 11:54 am
Location: Collinsville, IL

Re: How to guide for spreadsheet

Post by bobcatbrown520 »

gpraceman wrote:
bobcatbrown520 wrote: Sun Feb 11, 2018 1:41 pm So if I need a BYE lane would it look like

0 1 2 3
Yes, that is correct.
Thanks that did the trick

Sent from my LG-H810 using Tapatalk

Post Reply