Go Back   MajorWager Forums > MW - Online Sportsbooks > Handicapping "Think Tank"
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Handicapping "Think Tank" technical handicapping and statistics

LinkBack Thread Tools
  #1 (permalink)  
Old 07-29-2002, 01:14 PM
2006 2006 is offline
Join Date: May 2002
Posts: 263
Default Excel ?

If I copy and paste team win/loss records from another software program to an excel spreadsheet the whole record for each team ends up in one cell. Say for example the win/loss record for team x is 19-3, is there any easy way to get 19 in one cell and 3 in another cell after I have already pasted? Can you divide the column/cell in two and keep the wins in the first column and the losses in the second column?

Reply With Quote
  #2 (permalink)  
Old 07-29-2002, 01:22 PM
doddster98 doddster98 is offline
Join Date: Jul 2002
Posts: 1,539

I dont think there is an easy way to cut and paste into Excel from another program. I would suggest that you open up the file using the original software that was used and then export it to your desktop as a tab delimited file. Then open Excel and open up the exported file. That should get all of the columns to contain the information that was in the original file.

Hope that helps.

Reply With Quote
  #3 (permalink)  
Old 07-29-2002, 01:24 PM
Crony Crony is offline
Join Date: Nov 2000
Posts: 3,029

Highlight the column in question
Text to Columns
Delimited (Fixed can also work depends on the data)

In the example you showed, under delimiters:
Uncheck "Tab"
Check "Others"
Put a "-" in the box next to others
Reply With Quote
  #4 (permalink)  
Old 07-29-2002, 01:33 PM
Alan Alan is offline
Join Date: Jun 2001
Posts: 1,821

Some data will work with the text to column and some simply will not based on the source format.
Reply With Quote
  #5 (permalink)  
Old 07-29-2002, 04:24 PM
Machiavelli Machiavelli is offline
Join Date: Jul 2001
Posts: 1,188

Most times you can do whatever parsing you need using text to columns. Sometimes you need to do a combination of "Fixed width" and "delimited" parsing. If your data has the space amount of spaces, like most of the data from Don Best Archives, fixed width parsing can be useful.

An easy way to find out if the data that you have copied/pasted is in fixed width is to change the font to Courier. If everything lines up nicely, you can do fixed-width parsing.

In this case, delimited parsing probably is what is needed.
Reply With Quote
  #6 (permalink)  
Old 07-30-2002, 02:03 AM
2006 2006 is offline
Join Date: May 2002
Posts: 263

thanks everyone for the input
crony you right on the money
Reply With Quote

Thread Tools

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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

All times are GMT -4. The time now is 12:43 AM.

Please be advised that if you are wagering over the internet, this is illegal in many jurisdictions. A wagering site may be operating legally at their location but it may still be illegal for you to wager from your location. We suggest you check on the legal situation from any jurisdiction in which you may wager.

Search Engine Optimization by vBSEO 3.0.0 RC6