Page 1 of 1

How to guide for spreadsheet

Posted: Fri Feb 09, 2018 9:13 pm
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


Re: How to guide for spreadsheet

Posted: Sat Feb 10, 2018 6:44 am
by Vitamin K
bobcatbrown520 wrote:
Fri Feb 09, 2018 9: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?

Re: How to guide for spreadsheet

Posted: Sat Feb 10, 2018 12:26 pm
by gpraceman
bobcatbrown520 wrote:
Fri Feb 09, 2018 9: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?

Re: How to guide for spreadsheet

Posted: Sun Feb 11, 2018 1:45 am
by bobcatbrown520
Vitamin K wrote:
bobcatbrown520 wrote:
Fri Feb 09, 2018 9: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


Re: How to guide for spreadsheet

Posted: Sun Feb 11, 2018 9:32 am
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).

Re: How to guide for spreadsheet

Posted: Sun Feb 11, 2018 2:34 pm
by bracketracer
bobcatbrown520 wrote:
Sun Feb 11, 2018 1: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!

Re: How to guide for spreadsheet

Posted: Sun Feb 11, 2018 2:41 pm
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


Re: How to guide for spreadsheet

Posted: Sun Feb 11, 2018 7:21 pm
by gpraceman
bobcatbrown520 wrote:
Sun Feb 11, 2018 2:41 pm
So if I need a BYE lane would it look like

0 1 2 3
Yes, that is correct.

Re: How to guide for spreadsheet

Posted: Mon Feb 12, 2018 5:42 am
by bobcatbrown520
gpraceman wrote:
bobcatbrown520 wrote:
Sun Feb 11, 2018 2: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