|
|||||||
| Capping All handicapping, betting systems, spreadsheets, mathematics & quantitative technicapping. |
 |
|
|
LinkBack | Thread Tools | Display Modes |
|
#1
10-27-2010, 09:52 AM
|
|||
|
|||
|
excel question
Hey there everybody. I am sure this has been discussed before but I couldn't find it by searching. I dabbled a little last basketball season by keeping a simple excel spreadsheet tally for service plays on all Bball games. I then compared the extreme discrepancies with the public percentages.
My question is...Is there a way to link the daily schedule of games into an excel spreadsheet so I don't have to manually input these games each day? Just throwing it out there to see if there is anyone more technologically literate than I am. Thanks in advance 
|
|
#2
10-27-2010, 10:04 AM
|
|||
|
|||
|
Pretty sure there is a way.. not sure how to do though.
__________________
2005-present ATS NFL - 158 - 121 - 15 - 57% CFB - 259 - 161 - 11 - 62% CBB - 354 - 189 - 20 - 65% 12/20/2010 ML's > -150 - 3-0 GOY's 13-1 -Go with your gut, not the chatter 
|
|
#3
10-27-2010, 12:06 PM
|
|||
|
|||
|
Search the import function in the help section. I can't remember the fx off hand
|
|
#4
10-27-2010, 12:43 PM
|
|||
|
|||
|
Go to data. Then import external data
|
|
#5
10-27-2010, 04:02 PM
|
|||
|
|||
|
^^ yes or u can use a method i'll post about in a second
__________________
"Nobody goes there anymore, its too crowded." --Yogi Berra "Always tell the truth, that way you won't have to remember what you said." --Mark Twain *=$50,000
|
|
#6
01-25-2011, 12:29 PM
|
|||
|
|||
|
would love to know this also!
|
|
#7
01-29-2011, 07:16 PM
|
|||
|
|||
|
There are several sites that display schedules. I'm not certain which will fit your needs, but here is how I do it.
Open Excel click on DATA tab click on FROM WEB (usually found on the left side) a new box will open....copy, paste or type the address in the address window similar to jimfeist.com/ncaa basketball schedules hit Go (or enter) the selected site will now appear in the box accompanied by small yellow arrows... select the section you need by clicking on the yellow arrows. hit IMPORT anothe box will appear asking where you want the data... usually A1 will suffice, but you may post it anywhere on your sheet you want... Hit OK in the small box that appears.... the information selected will be posted on your sheet.... More tedious to explain that perform... good luck on your action...
|
|
| Bookmarks |
«
Previous Thread
|
Next Thread
»
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT -5. The time now is 05:46 PM.
