Comments for John Wright's Weblog http://www.jfwiii.net/blog One person's views on sports (particularly statistics), music, politics, religion, and technology. Sun, 04 Jul 2010 00:30:20 +0000 hourly 1 http://wordpress.org/?v=abc Comment on New England Vacation 2010 by ME http://www.jfwiii.net/blog/2010/06/new-england-vacation-2010/comment-page-1/#comment-7645 ME Sun, 04 Jul 2010 00:30:20 +0000 http://www.jfwiii.net/blog/?p=1423#comment-7645 That's a cool trip. A few sites in Delaware would have made it perfect. That’s a cool trip.

A few sites in Delaware would have made it perfect.

]]> Comment on 2010 Pythagorean Wins with BaseRuns by Doug Sparks http://www.jfwiii.net/blog/2010/04/2010-pythagorean-wins-with-baseruns/comment-page-1/#comment-7637 Doug Sparks Sun, 02 May 2010 16:10:57 +0000 http://www.jfwiii.net/blog/?p=1413#comment-7637 No luck on the 2007 file. I wonder if maybe when the web query botches the data table, it's also overwriting the "A" column with blank cells. Oh well. Don't worry about it. Sad times for us Mac people, because I'm sure this stuff is going to be really insightful to keep up with as the season goes along. No luck on the 2007 file. I wonder if maybe when the web query botches the data table, it’s also overwriting the “A” column with blank cells.

Oh well. Don’t worry about it. Sad times for us Mac people, because I’m sure this stuff is going to be really insightful to keep up with as the season goes along.

]]> Comment on 2010 Pythagorean Wins with BaseRuns by NL Central Sanity Check « Play a Hard Nine http://www.jfwiii.net/blog/2010/04/2010-pythagorean-wins-with-baseruns/comment-page-1/#comment-7636 NL Central Sanity Check « Play a Hard Nine Sat, 01 May 2010 14:04:05 +0000 http://www.jfwiii.net/blog/?p=1413#comment-7636 [...] allowed. It’s good at telling off  on who has been the beneficiary of some good or bad luck. John Wright was nice enough and smart enough to put together an Excel spreadsheet that updates the s.... Sweet nerdy [...] [...] allowed. It’s good at telling off  on who has been the beneficiary of some good or bad luck. John Wright was nice enough and smart enough to put together an Excel spreadsheet that updates the s…. Sweet nerdy [...]

]]> Comment on 2010 Pythagorean Wins with BaseRuns by John Wright http://www.jfwiii.net/blog/2010/04/2010-pythagorean-wins-with-baseruns/comment-page-1/#comment-7635 John Wright Sat, 01 May 2010 03:32:00 +0000 http://www.jfwiii.net/blog/?p=1413#comment-7635 "Web queries cannot be edited," seriously? Column V on the batting sheet is supposed to be "A" from the BaseRuns formula, as you suspected. Perhaps it's an issue with hidden columns, since I hid the BsR components to make the sheet look a little cleaner. It works fine for me in Windows, as does the vertical alignment of the standings tab. I'm actually kind of shocked that Excel is incompatible across platforms when MS has gone to the effort to release it for OS X. Sounds like it's going to be tough to get a Mac workaround. Try this: http://dl.dropbox.com/u/6494767/2010%20BsR%20Standings.xlsx That's an Excel 2007 version of the file. Perhaps it will play nicer with a Mac? “Web queries cannot be edited,” seriously?

Column V on the batting sheet is supposed to be “A” from the BaseRuns formula, as you suspected. Perhaps it’s an issue with hidden columns, since I hid the BsR components to make the sheet look a little cleaner. It works fine for me in Windows, as does the vertical alignment of the standings tab.

I’m actually kind of shocked that Excel is incompatible across platforms when MS has gone to the effort to release it for OS X. Sounds like it’s going to be tough to get a Mac workaround.

Try this:

http://dl.dropbox.com/u/6494767/2010%20BsR%20Standings.xlsx

That’s an Excel 2007 version of the file. Perhaps it will play nicer with a Mac?

]]> Comment on 2010 Pythagorean Wins with BaseRuns by Doug Sparks http://www.jfwiii.net/blog/2010/04/2010-pythagorean-wins-with-baseruns/comment-page-1/#comment-7634 Doug Sparks Fri, 30 Apr 2010 22:30:34 +0000 http://www.jfwiii.net/blog/?p=1413#comment-7634 Okay, nevermind. I fixed the #N/A's, but something's still definitely not working right. Just out of curiosity, what's supposed to go in Column V of the batting BsR sheet and in Column W of the pitching BsR sheet? It seems like there ought to be something there (like maybe "A" from the BaseRuns formula), but I'm getting a blank column there when I download the file. I'm wondering if maybe the Mac glitches are more than just in the web queries. That doesn't make any sense, but who knows. Okay, nevermind. I fixed the #N/A’s, but something’s still definitely not working right.

Just out of curiosity, what’s supposed to go in Column V of the batting BsR sheet and in Column W of the pitching BsR sheet? It seems like there ought to be something there (like maybe “A” from the BaseRuns formula), but I’m getting a blank column there when I download the file. I’m wondering if maybe the Mac glitches are more than just in the web queries. That doesn’t make any sense, but who knows.

]]>