Horse Racing Forum - PaceAdvantage.Com - Horse Racing Message Board

Go Back   Horse Racing Forum - PaceAdvantage.Com - Horse Racing Message Board > Thoroughbred Horse Racing Discussion > Handicapper's Corner


Reply
 
Thread Tools Rate Thread
Old 03-27-2015, 06:31 AM   #1
Capper Al
Registered User
 
Capper Al's Avatar
 
Join Date: Dec 2005
Location: MI
Posts: 6,330
Excel help -- Import column limitations

Has anyone dealt with import column limitations in either Excel 2007 or 2013? I dump a CSV file from a C++ program and then import it into Excel. I started noting data corruption after about column TU.

Thanks
__________________


"The Law, in its majestic equality, forbids the rich, as well as the poor, to sleep under bridges, to beg in the streets, and to steal bread."

Anatole France


Capper Al is offline   Reply With Quote Reply
Old 03-27-2015, 09:30 AM   #2
HUSKER55
Registered User
 
HUSKER55's Avatar
 
Join Date: Jul 2007
Location: MILWAUKEE
Posts: 5,285
wish I could help. but, I had an instructor a few years back that said when you attempt to move large amounts of data the more the column size and format had to match.

When you put in data and use the excel import wizard you can adjust the columns so they are readable, but they don't necessarily have to match the width of the project. For example, you need 10 spaces and the wizard puts in 12.24. After a while there will be confusion.

yeah I know....I never got the drift of it either.

Send Ray and email.

Sorry I couldn't help.
__________________
Never tell your problems to anyone because 20% flat don't care and 80% are glad they are yours.

No Balls.......No baby!

Have you ever noticed that those who do not have a pot to piss in nor a window to throw it out of always seem to know how to handle the money of those who do.
HUSKER55 is offline   Reply With Quote Reply
Old 03-27-2015, 09:55 AM   #3
Capper Al
Registered User
 
Capper Al's Avatar
 
Join Date: Dec 2005
Location: MI
Posts: 6,330
Quote:
Originally Posted by HUSKER55
wish I could help. but, I had an instructor a few years back that said when you attempt to move large amounts of data the more the column size and format had to match.

When you put in data and use the excel import wizard you can adjust the columns so they are readable, but they don't necessarily have to match the width of the project. For example, you need 10 spaces and the wizard puts in 12.24. After a while there will be confusion.

yeah I know....I never got the drift of it either.

Send Ray and email.

Sorry I couldn't help.
Think I will.Thanks
__________________


"The Law, in its majestic equality, forbids the rich, as well as the poor, to sleep under bridges, to beg in the streets, and to steal bread."

Anatole France


Capper Al is offline   Reply With Quote Reply
Old 03-27-2015, 10:14 AM   #4
Dave Schwartz
 
Dave Schwartz's Avatar
 
Join Date: Mar 2001
Location: Reno, NV
Posts: 16,878
Just a guess... but are you exporting/importing a columns that contain commas? (i.e. comments)
Dave Schwartz is online now   Reply With Quote Reply
Old 03-27-2015, 03:06 PM   #5
headhawg
crusty old guy
 
headhawg's Avatar
 
Join Date: Aug 2003
Location: Snarkytown USA
Posts: 3,909
Corruption is vague, but I'm with Dave here -- something about the source data is probably bad.
headhawg is offline   Reply With Quote Reply
Old 03-27-2015, 03:28 PM   #6
Capper Al
Registered User
 
Capper Al's Avatar
 
Join Date: Dec 2005
Location: MI
Posts: 6,330
I checked it before and after I sent it. It was okay in the program until I looked at them in the spreadsheet. I even just passed an integer- 6. It came out 1. It bothers me but the fields aren't important. Still, I won't rest on it.
__________________


"The Law, in its majestic equality, forbids the rich, as well as the poor, to sleep under bridges, to beg in the streets, and to steal bread."

Anatole France


Capper Al is offline   Reply With Quote Reply
Old 03-27-2015, 03:33 PM   #7
Dave Schwartz
 
Dave Schwartz's Avatar
 
Join Date: Mar 2001
Location: Reno, NV
Posts: 16,878
Did you bring the SAME data into "the program" as "the spreadsheet?"

or

Did you import the data into "the program," and then export it to the spreadsheet?

Just trying to (logically) search for the most likely cause of the error.
Dave Schwartz is online now   Reply With Quote Reply
Old 03-27-2015, 04:00 PM   #8
whodoyoulike
Veteran
 
Join Date: Aug 2005
Posts: 3,428
Quote:
Originally Posted by Capper Al
Has anyone dealt with import column limitations in either Excel 2007 or 2013? I dump a CSV file from a C++ program and then import it into Excel. I started noting data corruption after about column TU.

Thanks
k if there is

Curious, how many columns is TU?

Check if there is a # of column limitation in Excel for your versions.
whodoyoulike is offline   Reply With Quote Reply
Old 03-29-2015, 09:45 AM   #9
Capper Al
Registered User
 
Capper Al's Avatar
 
Join Date: Dec 2005
Location: MI
Posts: 6,330
Looking at GP Feb 21 bug again. This one has me. I save the value into a before output field, I output it, and then save it into after field. The field is expected to be 6. I get 6,1,6 respectively. And if this isn't enough I pass a literal int 6 at the end of the output stream. All the rows except the two having the problem display the 6 in the last column.

BTW, this is happening on both Excel 2007 and 2013.

Best guess if the field isn't being outputted. It problem is occurring around the 566 column on rows 13 and 14.

Yesterday's card at GP worked fine.
__________________


"The Law, in its majestic equality, forbids the rich, as well as the poor, to sleep under bridges, to beg in the streets, and to steal bread."

Anatole France



Last edited by Capper Al; 03-29-2015 at 09:55 AM.
Capper Al is offline   Reply With Quote Reply
Old 03-29-2015, 09:54 AM   #10
vegasone
Registered User
 
Join Date: Aug 2007
Posts: 526
If it is past performance data, sometimes they will throw in an extra "something" in one of the fields, such as a comma or quote character (") which can throw you off. Doesn't happen often and will drive you crazy till you hunt it down and adjust for this.
vegasone is offline   Reply With Quote Reply
Old 03-29-2015, 11:33 AM   #11
PaceMasterT
Registered User
 
Join Date: Jun 2014
Posts: 217
Quote:
Originally Posted by Capper Al
Looking at GP Feb 21 bug again. This one has me. I save the value into a before output field, I output it, and then save it into after field. The field is expected to be 6. I get 6,1,6 respectively. And if this isn't enough I pass a literal int 6 at the end of the output stream. All the rows except the two having the problem display the 6 in the last column.

BTW, this is happening on both Excel 2007 and 2013.

Best guess if the field isn't being outputted. It problem is occurring around the 566 column on rows 13 and 14.

Yesterday's card at GP worked fine.
For the line(s) that you are having a problem with, check to see if the horse raced in a race with a comma in it. Such as the Kenny Noe, Jr. Handicap.
PaceMasterT is offline   Reply With Quote Reply
Old 03-29-2015, 11:56 AM   #12
PaceMasterT
Registered User
 
Join Date: Jun 2014
Posts: 217
I don't have the GP Feb. 21st data file, but a cursory glance at that day's results charts, I'm guessing that row 14 is the 1 Dixie One in the second race. Dixie One was previously trained by Robert Falcone, Jr., so if that column is included in your data, there may be that , there messing up the delimiting process.
PaceMasterT is offline   Reply With Quote Reply
Old 03-29-2015, 03:08 PM   #13
Dave Schwartz
 
Dave Schwartz's Avatar
 
Join Date: Mar 2001
Location: Reno, NV
Posts: 16,878
PaceMaster is saying what I was saying.

That will corrupt your data if you do not put quotes around those fields.
Dave Schwartz is online now   Reply With Quote Reply
Old 03-30-2015, 07:56 AM   #14
Capper Al
Registered User
 
Capper Al's Avatar
 
Join Date: Dec 2005
Location: MI
Posts: 6,330
Bug found

I live to code another day. The bug was found. It wasn't the field that displayed the error. This caused me to go crazy, or crazier for those who already think I'm crazy. I should of mentioned that my importing module wasn't were the problem was. This has been working fine for years. It was my program's data being outputted into a csv file for input into an Excel spreadsheet. About two dozen columns upstream from where the error was visible, and only under very limited circumstances, a comma was skipped between fields. I want to thank everyone who posted for their support. Sometimes a programmer just needs to talk. I worked on this bug for over 10 days. It was a tough one and very maddening.

Thanks
__________________


"The Law, in its majestic equality, forbids the rich, as well as the poor, to sleep under bridges, to beg in the streets, and to steal bread."

Anatole France


Capper Al is offline   Reply With Quote Reply
Reply




Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

» Advertisement
Powered by vBadvanced CMPS v3.2.3

All times are GMT -4. The time now is 06:52 AM.


Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Copyright 1999 - 2023 -- PaceAdvantage.Com -- All Rights Reserved
We are a participant in the Amazon Services LLC Associates Program, an affiliate advertising program
designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.