| RotoGuru Baseball Forum View the Forum Registry |
| |
| 0 |
Subject: SW Spreadsheet? Posted by: Phyrre56 - [317391714] Sun, Apr 08, 14:56 I remember last year there was a downloadable spreadsheet (I think it was Richard's) that could tabulate all kinds of stats for a SW team. Is it still available somewhere? Thanks | ||||||
| 1 | Strike One ID: 39252299 Sun, Apr 08, 15:32 | filter all threads started by "richard" | |||||
| 2 | JW ID: 58410317 Sun, Apr 08, 15:38 |
Richard I was looking for the old thread and saw this first. Can you give us an update on the new version? The old one was working fine earlier in the week but no more, alas. | |||||
| 3 | Madman ID: 29246911 Sun, Apr 08, 23:15 | The change came because ESPN has changed their boxscores and layouts, FYI. | |||||
| 4 | RecycledSpinalFluid ID: 52523240 Mon, Apr 09, 00:47 |
If you have already modified the SWP producing column, here are the changes I maed on my version of Richard's spreadsheet. Now I have modified his original many, many times, so I hope these are all the same lines you guys have: In the ReadEspnScoreboard() macro: Change: Workbooks.Open Filename:="http://espn.go.com/mlb/scoreboard" To: Workbooks.Open Filename:="http://baseball.espn.go.com/mlb/scoreboard" Change: Range("G" & i + 1).Value = "http://espn.go.com" & links(i) To: Range("G" & i + 1).Value = "http://baseball.espn.go.com" & links(i) In the ReadBoxScore(url As String) macro: Change all instances of: team = c.Offset(0, -1) To: team = c.Offset(-1, -1) There should be 4 occurances of the last one IIRC. I think those are the only lines I changed. Good Luck. One last note, this is if you are using Excel 97. I have not tested if this corrects Excel 2000, as I don't use that clunky piece of junk. | |||||
| 5 | spudnik187 ID: 170501618 Mon, Apr 09, 17:30 | I don't see the second batch of lines in my code anywhere. Could someone please post a working version in either '97 or 2k format? Much thanks | |||||
| 6 | Huskiez ID: 25344216 Mon, Apr 09, 17:32 | I just dled the spreadsheet by filtering threads submitted by Richard, third one from top. This is for Microsoft Excel 2000. What changes need to be made so that it will work? As of now, the SWP and the Rosters don't work, but it gets the scores OK. | |||||
| 7 | APerfect10 ID: 422362923 Mon, Apr 09, 18:09 | For everyones information, these two lines of code do not work for Excel 2000. If anyone does happen to have a working spreadsheet for 2000 and could post a link, or send it to my email address, it would be greatly appreciated! | |||||
| 8 | APerfect10 ID: 422362923 Mon, Apr 09, 18:13 | Ooops, Richard already posted a new version under a different thread, sorry... | |||||
| 9 | APerfect10 ID: 422362923 Mon, Apr 09, 18:22 | oops...or did he? | |||||
| 10 | spudnik187 ID: 170501618 Mon, Apr 09, 18:29 | He posted a link, but it doesn't seem to work this year. Richard: please clear this up for us | |||||
| 11 | RecycledSpinalFluid ID: 39446311 Mon, Apr 09, 18:37 | Man, what the hell was I thinking when I posted that message. There were a bunch of other mods. Sheesh. I'll post up an Excel 97 version just as soon as I verify the numbers it puts out. It will be just the basics (gets you the SWPs). I'll leave it up until Richard releases something better. | |||||
| 12 | RecycledSpinalFluid ID: 39446311 Mon, Apr 09, 19:01 |
OK, here is the GetMLBScores_v2001a.zip file. I know it works for Excel 97, which I use. I'll check it out on Excel 2000 later tonight. If you get an Error message downloading it, go back and click on the link again. HOMEPAGES.GO.COM has been very erratic lately. Good luck. | |||||
| 13 | APerfect10 ID: 422362923 Mon, Apr 09, 23:10 |
RSF, I tried the link like 30 times so far tonite, and notta. Could you possibly send it to my email address. Thanks a lot! | |||||
| 14 | jedman ID: 291133620 Mon, Apr 09, 23:13 | I tried using Richard's just a few minutes ago and got a runtime error. It got the full game scores, but not the SWP. On the rosters, it said the roster numbers I put in were invalid. I double checked them against the numbers from smallworld and I feel comfortable that I had the right numbers in there. I'm using Excel 2000. | |||||
| 15 | Ender ID: 13443221 Mon, Apr 09, 23:16 |
Just grabbed it first try. Aperfect10, I'd email it to you myself, but am having email problems lately. If I get around them I'll shoot you a copy. I should be able to do it from school in the morning if you don't get it before then. | |||||
| 16 | APerfect10 ID: 422362923 Mon, Apr 09, 23:33 | Ender, Thanks a lot! | |||||
| 17 | Scrubbunch ID: 49253257 Mon, Apr 09, 23:43 | APerfect10 I have it working if you want me to email a copy. | |||||
| 18 | RecycledSpinalFluid ID: 52523240 Tue, Apr 10, 01:15 |
jedman, I promiss I'll get the patented jedman's crow feature working soon for baseball. Scrubbunch, are you working in 97 or 2000? | |||||
| 19 | JW ID: 58410317 Tue, Apr 10, 02:31 |
Excellent stuff, RSF, many thanks. Worked like a dream and I'm back in business | |||||
| 20 | APerfect10 ID: 422362923 Tue, Apr 10, 06:29 | Scrub, yeah if you get a chance, so far no one has...thanks! | |||||
| 21 | Scrubbunch ID: 49253257 Tue, Apr 10, 07:59 |
Working in 97, just like it better. It's on the way AP10 | |||||
| 22 | APerfect10 ID: 422362923 Tue, Apr 10, 14:06 | Scrubbunch, Thanks a lot, working in Excel 2000! | |||||
| 23 | Huskiez ID: 25344216 Tue, Apr 10, 17:04 | Can someone send me a working copy for Excel 2000 please? | |||||
| 24 | APerfect10 ID: 432432619 Tue, Apr 10, 17:41 | I can when i get home from work in 30 min. | |||||
| 25 | Huskiez ID: 25344216 Tue, Apr 10, 17:42 | Thank you, APerfect10. | |||||
| 26 | Huskiez ID: 25344216 Thu, Apr 12, 10:30 | Is there anyone who has a working Excel 2000 version of the spreadsheet and could send it to me? | |||||
| 27 | Powerlifter ID: 19841316 Thu, Apr 12, 10:47 | Can someone sed me the Excel 97 version? Thanks! | |||||
| 28 | ProudestMonkey ID: 4220113 Thu, Apr 12, 11:01 | I am also interested in getting my hands on a copy of this year's version of the spreadsheet. I tried clicking on the link, but it said "GO.com cannot answer your information request." I am using Excel 2000. Thanks to anyone who can provide me with this file! | |||||
| 29 | RecycledSpinalFluid ID: 39446311 Thu, Apr 12, 11:35 |
Stupid HOMEPAGES.GO.COM... Try this link: GetMLBScores_v2001a.zip Can anyone download them from either link? If so, what OS/Browser are you using? I really need a different place to store my stuff. | |||||
| 30 | J ID: 50726110 Thu, Apr 12, 11:58 |
Same thing RSF: A message to GO.com users: * We're sorry for the inconvenience, but at the moment, the GO.com cannot answer your information request. Suggestions: Wait a few moments and reload the page. You can do this in one of the following ways: Hit the Reload or Refresh button on your browser. If you are using a Lynx browser (a text-based browser), press Ctrl-R. This will request the information from our service again. You should get a response within several seconds. If you do not get a response within several seconds, we are probably experiencing a system problem. Try again later today. This is a temporary* situation. Thank you for your patience! * - Temporary my arse! | |||||
| 31 | ProudestMonkey ID: 4220113 Thu, Apr 12, 13:44 | RSF, I'm using Win 2000. I tried with IE5.0 and Netscape 6 and neither worked. If we can't get the file via your homepage, could someone email it to me? Thanks a ton! | |||||
| 32 | KrazyKoalaBears ID: 51521713 Thu, Apr 12, 20:11 | RSF, if you like, I can drop the zip file on Gleem and give you a link that will always work. Just let me know and I can set it up before tomorrow afternoon. | |||||
| 33 | AnalogKid ID: 122101617 Fri, Apr 13, 10:24 |
I hate to be dense, but is there an instruction set somewhere? Its not immediately clear where to input my rosters. Is it like the BaseBall rosters sheet, where I just put in a team number, and the macros do the rest, or do I need to key my teams? Thanks for the help. I appreciate all the hard work poured into these tools, as well as the willingness to share w/ the SW community. | |||||
| 34 | APerfect10 ID: 432432619 Fri, Apr 13, 10:27 |
Put the team id #'s in Row 1. Put the team name in Row 2. In cell A27 there is a button named "Grab Rosters". click it and the macro's do the rest. Hope that helps. | |||||
| 35 | AnalogKid ID: 122101617 Fri, Apr 13, 11:45 | AP10 - Thanks for the info. Those instructions are for the baseball rosters sheet. What about the Get scores sheet? | |||||
| 36 | RecycledSpinalFluid ID: 39446311 Fri, Apr 13, 12:00 |
Instructions: 1.) Click on . | |||||
| 37 | APerfect10 ID: 432432619 Fri, Apr 13, 12:27 | Analogkid, Sorry bout that, for the getscores sheets, the vs. working for this year doesnt work with your team. It just gets HITTERS/PITCHER SWP's, and lists them. No roster, atleast i dont think. Or if there is a newer vs. working, i'd appreciate if someone could get it to me :) | |||||
| 38 | jedi_council ID: 451571316 Fri, Apr 13, 13:58 | In my Get Rosters spreadsheet for some reason it is not getting the SWD change and the Total SWD for the players properly (i.e. the last two numbers after the players name). Is there a new version out there that I don't know about or is everyone else having this problem? | |||||
| 39 | 6-9 With The Afro ID: 1551486 Sat, Jun 09, 23:31 | Hmmm...can't seem to download the spreadsheet. Are there any other links? | |||||
| Rate this thread: | If you wish, you may rate this thread on scale of 1-5. Ratings should indicate how valuable or interesting you believe this thread would be to other users of this forum. A '5' means that this thread is a 'must read'. A '1' means that this is a complete waste of time. If you have previously rated this thread, rating it again will delete your previous rating. If you do not want to rate this thread, but want to see how others have rated it, then click the button without entering a rating, or else click here. | ||||||
| |||||||
Post a reply to this message: (But first, how about checking out this sponsor?) | |||||||