nasaforums.com

Official Forums of the National Auto Sport Association
It is currently Mon Jun 26, 2017 12:37 am

All times are UTC - 8 hours




Post new topic Reply to topic  [ 4 posts ] 
Author Message
 Post subject: Reserved number question
PostPosted: Mon Jun 22, 2015 10:42 am 
Offline
Hard-core Forum Racer
Hard-core Forum Racer
User avatar

Joined: Tue Jan 04, 2005 2:09 pm
Posts: 757
Location: Northern, Va
I am curios why the reserved number limitation where leading zero's don't count as a "number" exists in NASA Northeast? It can't be an AMB issue, as they accommodate for it.

_________________
Enjoy,
Bill

05 PTE - Honda Accord LX
SFT(Spec Flat Tow) Ford SD


Top
 Profile  
 
PostPosted: Mon Jul 06, 2015 8:08 am 
Offline
Hard-core Forum Racer
Hard-core Forum Racer
User avatar

Joined: Fri Apr 25, 2003 6:26 am
Posts: 977
Location: Edgewater, NJ
Ev wrote:
I am curios why the reserved number limitation where leading zero's don't count as a "number" exists in NASA Northeast? It can't be an AMB issue, as they accommodate for it.


It is because of how AMB exports them to excel it causes a problem in that it drops the leading zeros, so you can have leading zeros in your number but that won't differentiate it in the system from a car without a leading zero in it. So it sees 07, 7, 007 all as "7" when exported to be dealt with for points and what not. As an additional reason and probably more importantly... The flaggers at NE tracks are required to be provided by the track itself, and well they aren't always up to par on calling in violations. We've seen on many occasions where a 07 were called into us as 7 in the tower. We had no way of knowing if the 07 or the 7 was in violation and there is no way to "force" the flaggers to read the right numbers.

Hope this helps.


-mike

_________________
NASA-NE Timing & Scoring Director
'14 VW Touareg TDi | '14 Subaru BRZ | '04 Nissan Armada


Top
 Profile  
 
PostPosted: Mon Jul 06, 2015 8:39 am 
Offline
Hard-core Forum Racer
Hard-core Forum Racer
User avatar

Joined: Tue Jan 04, 2005 2:09 pm
Posts: 757
Location: Northern, Va
Paisan wrote:
Ev wrote:
I am curios why the reserved number limitation where leading zero's don't count as a "number" exists in NASA Northeast? It can't be an AMB issue, as they accommodate for it.


It is because of how AMB exports them to excel it causes a problem in that it drops the leading zeros, so you can have leading zeros in your number but that won't differentiate it in the system from a car without a leading zero in it. So it sees 07, 7, 007 all as "7" when exported to be dealt with for points and what not. As an additional reason and probably more importantly... The flaggers at NE tracks are required to be provided by the track itself, and well they aren't always up to par on calling in violations. We've seen on many occasions where a 07 were called into us as 7 in the tower. We had no way of knowing if the 07 or the 7 was in violation and there is no way to "force" the flaggers to read the right numbers.

Hope this helps.


-mike
Thanks for your response.

I think the export format isn't the issue with AMB, it's how it's being decoded by the program you are using, Excel. AMB exports a .CSV file format. Excel looks at the data, and based on what it sees, it formats the column automatically. To Excel, the car number looks like a number, so it formats it as such, removing leading zeros. If you change the column to a "text", the zero's return. I hate microsoft for this, as I am a database analyst, and frequently get nailed by this challenge. As far as flaggers not giving you correct numbers, that's a training issue.

It's a shame really that I have to re-number my car to race with NE because of a gap in training. Just about everyone else has overcome this simple challenge <shrug> NJMP was on my list, but for this and other reasons, I will be passing this year.

_________________
Enjoy,
Bill

05 PTE - Honda Accord LX
SFT(Spec Flat Tow) Ford SD


Top
 Profile  
 
PostPosted: Mon Jul 06, 2015 9:05 am 
Offline
Hard-core Forum Racer
Hard-core Forum Racer
User avatar

Joined: Fri Apr 25, 2003 6:26 am
Posts: 977
Location: Edgewater, NJ
Ev wrote:
Paisan wrote:
Ev wrote:
I am curios why the reserved number limitation where leading zero's don't count as a "number" exists in NASA Northeast? It can't be an AMB issue, as they accommodate for it.


It is because of how AMB exports them to excel it causes a problem in that it drops the leading zeros, so you can have leading zeros in your number but that won't differentiate it in the system from a car without a leading zero in it. So it sees 07, 7, 007 all as "7" when exported to be dealt with for points and what not. As an additional reason and probably more importantly... The flaggers at NE tracks are required to be provided by the track itself, and well they aren't always up to par on calling in violations. We've seen on many occasions where a 07 were called into us as 7 in the tower. We had no way of knowing if the 07 or the 7 was in violation and there is no way to "force" the flaggers to read the right numbers.

Hope this helps.


-mike
Thanks for your response.

I think the export format isn't the issue with AMB, it's how it's being decoded by the program you are using, Excel. AMB exports a .CSV file format. Excel looks at the data, and based on what it sees, it formats the column automatically. To Excel, the car number looks like a number, so it formats it as such, removing leading zeros. If you change the column to a "text", the zero's return. I hate microsoft for this, as I am a database analyst, and frequently get nailed by this challenge. As far as flaggers not giving you correct numbers, that's a training issue.

It's a shame really that I have to re-number my car to race with NE because of a gap in training. Just about everyone else has overcome this simple challenge <shrug> NJMP was on my list, but for this and other reasons, I will be passing this year.


Yeah, unfortunately we have absolutely zero control over the flaggers.

Even if you want 07 it would already have been taken (we have several folks who have had 7, 07, etc) who would have been ahead of you on the list to get that number.

If you are only planning to run with us 1x a year or so, we can have you run as a guest with your "regular" number from your other region.

-mike

_________________
NASA-NE Timing & Scoring Director
'14 VW Touareg TDi | '14 Subaru BRZ | '04 Nissan Armada


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 

All times are UTC - 8 hours


Who is online

Users browsing this forum: Yahoo [Bot] and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group