Posted by: RecycledSpinalFluid
- [21446223] Wed, Nov 07, 2001, 10:20
To me, a vital thing to being a Gurupie is the sharing of knowledge and tools. The most obvious tools are the great stuff supplied by Guru, himself, such as the Sortable Stats (sartibles), Sched-o-matic and Assimilator.
Other tools would be stuff like your favorite stat sight or website where you get great "inside" info (player updates), things like that.
Lets not forget any spreadsheets or Applications you have or have written. The more tools the better.
Show 'em if you got 'em.
1
RecycledSpinalFluid
ID: 21446223 Wed, Nov 07, 2001, 10:20
In keeping with the sharing knowledge idea, here are a couple of spreadsheets I have developed for Stallworld Hoops 2001-2002.
The ground rules for my stuff: 1.) I designed these in Excel 97, so that is all that I care they work in. If they work in other newer versions, great, let others know, but I won't be modifying it to do so. If you do modify it to work in other versions, supply it to others. Kind of an open source rule.
2.) If you use the thread maker parts, when posting, please select YES (for HTML table input) before clicking . This will save you many, many head aches.
3.) If something is broke, let us know here, and maybe it will be fixed, sometime. Possibly. Some days/weeks are better than others. Be sure to post the OS you are using, the Excel version (just to be sure) and the EXACT error message. That will make it a little easier to troubleshoot. NBA_0102_Pricemovers_0.04.zip: This is a spreadsheet to pull in the daily PriceMovers for posting on the boards. It makes a fairly nice (IMO) table with links to Guru's player pages, as well as RotoWorld's player pages.
NBA_0102_DivTracker_v0.03.zip: This is a spreadsheet designed to track team information that is available on the Frozen Rosters. Could be used for tracking just your teams or your division's teams, etc.
Good Luck...
2
blue hen, almighty Leader
ID: 34937217 Wed, Nov 07, 2001, 10:57
I won't plug the ESPN free (or pay) games or any sortable stats, since you've probably seen most of what is out there, but I did want to alert people to the "correspondents" sections at ESPN Fantasy Games. These people post twice a week with in-depth fantasy articles about every team in every sport. They aren't professionals, and their work is geared towards the ESPN pay games, but they often provide some local insight.
Additionally, there are some pretty cool new features for ESPN Insider, including Power Picks and Inside The Game. Power Picks was invaluable down the stretch in baseball, since it told me the best matchup each day based on a pretty accurate formula. If you have an insider account, here's a link to ESPN NFL Power Picks. ESPN's fantasy coverage is at http://games.espn.go.com.
Also, if you're looking for All Time baseball stats, I've found that www.baseball-reference.com has the best stuff and a nice layout (albeit a little basic).
3
RecycledSpinalFluid
ID: 21446223 Wed, Nov 07, 2001, 11:01
Thanks blue hen, almighty! Those kinds of links are what I was hoping would be posted! That kind of "insider info"!
4
DR Stars
ID: 162592010 Wed, Nov 07, 2001, 11:23
RSF, I'm running Excel 97 on Windows NT Service Pack 6, and when I run the division tracker I get no player on every position of every team. Any particular reason, is this part supposed to work?
5
KB8ers GM
ID: 0616111 Wed, Nov 07, 2001, 11:30
To help cut down on player status inquiry threads/posts:
Shelby-villian
ID: 261146232 Wed, Nov 07, 2001, 11:35
I use sportspages.com if I'm in desperate need of specifc information. Mostly hometown links.
7
RecycledSpinalFluid
ID: 21446223 Wed, Nov 07, 2001, 11:38
DR Stars, forgot to note about DivTracker...
If you run it before the freeze (and after midnight of the day before a freeze) there is a problem (easily corrected). Just enter the day before's date. For example, it is 11/7/01 at 8 AM. I would enter 11/6/01 as the date to run. If it is 11/7/01 1 PM, then you enter 11/7/01. The spreadsheet calculates the "table_id" based off of this date. So basicly enter the date you want to see frozen roster of.
Make sense?
I know I fixed that in one version or another. I'll have to fix it later and upload again.
Thanks.
8
DR Stars
ID: 162592010 Wed, Nov 07, 2001, 11:41
On the pricemovers, I get a problem and it points to this line of code: 'Done Reading Data, now close active workbook (the SW team page) Workbooks(URLtoOpen).Close
something about an index, error 9
9
RecycledSpinalFluid
ID: 21446223 Wed, Nov 07, 2001, 11:48
Now thats a new one to me. I just Downloaded and ran it without a hitch. I'll try later on a similar box.
RSF - could you give a quick step by step process of how to use the division tracker - I can see it is an amazing tool - but I know little or nothing about computers or spreadsheets -
11
philflyboy Donor
ID: 2844635 Wed, Nov 07, 2001, 12:24
One thing I have found with running RSF's spreadsheets: Do not look at your own SW teams while it is running. It seems to jump out of its download mode and gives an error. Other than that I have been using his spreadsheets for some time and they are great!!! Thanks RSF for all your help and your willingness to share your "gifts" with us.
12
RecycledSpinalFluid
ID: 35928913 Wed, Nov 07, 2001, 14:13
Along the same lines as philflyboy says, it is best to not surf at all while retrieving data with the spreadsheets. Excel 97 is a temperamental beast.
Great One, on the first sheet in the "GatherInfo" page, hover your mouse over Cell A1. The rest is fairly self-explanatory.
13
jshrauner
ID: 571059514 Wed, Nov 07, 2001, 15:35
RSF:
First I would like to thank you for the division tracker. In the past, I would just check each team and calculate their points(tedious process).
However, since it is a zip file, do I need to unzip it? If so, how do I? Once I have downloaded it, how do I open it? If you or someone could give a little help, I would be thankful.
Thanks, Justin
14
biliruben Sustainer
ID: 3502218 Wed, Nov 07, 2001, 17:42
Yes, you have to unzip it. Likely you have a program on your machine that does this such as winzip.exe pkunzip.exe
If not you can download them for free off the net - just search and you will find, I am sure.
After you unzip it, then just click on the file divtrack.xls (or whatever it is - I have never used this particular beast), and it should automatically open up in excel. If you don't have excel, disregard all of the above and start clicking and adding again. ;)
Hope this is helpful.
15
rage_22
ID: 101023710 Wed, Nov 07, 2001, 20:29
I'm using Excel 2000 on Win ME and I got the same error as DR Stars did while running the pricemovers, as noted in post 8. This was while running Step 1 of the spreadsheet.
16
philflyboy Donor
ID: 2844635 Wed, Nov 07, 2001, 21:39
RSF the divisional tracker is just for the Ultimate game correct?
17
Dan Donor
ID: 41838303 Wed, Nov 07, 2001, 22:14
pfb that is correct. Should be easy to modify though...
18
Roar Donor
ID: 27927417 Wed, Nov 07, 2001, 22:28
Thanks for the great links and tools, guys. I consult my Magic 8-Ball before making any major decisions.
19
Ender
ID: 13443221 Wed, Nov 07, 2001, 22:35
rage_22, that's because you're using Excel 2000. It reads and parses web pages differently than Excel 97.
20
Choller
ID: 13027162 Thu, Nov 08, 2001, 03:20
Well, i'm kinda into programming myself, but since RFS is the king at these things i don't know what else to create. I just made a really basic calculator (http://software.themainclick.com)
So if anyone has any idea of a tool that could be handy, just drop a line.
21
Edgar
ID: 357126 Thu, Nov 08, 2001, 09:03
Here's one of my old favourites. The roster optimizer. You can download it here (post 9).
Just us the first 200 players from the sortables and paste them in an excel file (paste special, text) then go to 'text to columns' to sort the date. Then paste these data (remove the unnecessary columns) in to the solver sheet.
Good luck
22
RecycledSpinalFluid
ID: 211013916 Thu, Nov 15, 2001, 23:42
RecycledSpinalFluid
ID: 211013916 Fri, Jan 25, 2002, 07:06
With the recent passing of some artificial barriers, arbitrary chosen in my head (200 total Gurupies and $10K in contributions), I figure now is as good as any to release the SWP calculator.
NBA_SWP_0102_0.14_lite.zip: This is a "Lite" version of the SWP calculator. The only thing that makes it "Lite" is that it does not contain the code to create the threads to post the daily "SWP" stuff. It does calculate all the SWPs that same as the "Full" version.
All the same rules apply to this spreadsheet that have applied to the rest of the spreadsheets in this thread from me.
25
Mike D Donor
ID: 19105287 Fri, Jan 25, 2002, 07:39
Thanks RSF for sharing the knowledge and the tools. Does it also create random action thread titles?
26
Farn
ID: 171128623 Fri, Jan 25, 2002, 10:25
Thanks RSF.
One question for others: does it work in Excel 2000. I just ran it and got nothing. It could be I got nothing because:
1) it ran it on boxscores of today which don't exist 2) it is not compatible with 2000 3) i am an idiot (a former Art Award Winner)
any help would be great. And thanks RSF.
27
Ender
ID: 52438315 Fri, Jan 25, 2002, 11:03
I'll refer you to post #1. RSF typically does this is Excel 97 and I am willing to bet the same is true of his latest release.
28
PAOK BC
ID: 421114176 Fri, Jan 25, 2002, 11:05
I just tried the pricemovers in excel 2000. I got the same error as DR Stars. All you have to do is hit debug. Once it points you to the code lines that have a problem (the one on closing the active url). Just delete it. Then rerun the macro. Also, make sure stallworld is not open in your IE. The div tracker also works in excel 2000, as well as the lite version of the calculator. Let me know if it worked guys.
PAOK B.C.
29
the dog
ID: 5011421823 Fri, Jan 25, 2002, 11:16
since i have excel 2000 and dont know crap about cp's .... is it posilbe to past that SWP thing here on the board and just run it every nite from the tread??? or on someone web page and visit the page to do SWP totals... this would help that way i dont have to stay up till Dan runs the swp total at nite when i should be in bed
30
rage_22 Donor
ID: 490311415 Fri, Jan 25, 2002, 19:22
RSF, I'm running the Free Game Division Tracker on my WIN ME/Excel 2000 system and No Player is coming up on all of the 5 player positions. I'm just curious if anybody else is using this and having this problem, or if you know a solution to this RSF. Thanks for the help and all the hard work put forth on these.
31
RecycledSpinalFluid
ID: 35928913 Fri, Jan 25, 2002, 20:45
Simple solution (sorta):
In the macro code for the getFrozenRostersURL function the "startDate="somedate needs to be changed to "startDate=01/17/2002". The startDate needs to be updated in the PayGame version too, to "startDate=12/30/2002".
Also, for the SWP thing, if you run it once, during games, the whole spreadsheet needs to be closed and reopened due to Excel caching the loaded URL into memory and just recalling the previous (nonupdated) web page if you don't. Silly Microsloth.
32
rage_22 Donor
ID: 490311415 Fri, Jan 25, 2002, 21:29
Thanks a lot RSF, that worked. What is the logic behind that, if you don't mind me asking?
33
RecycledSpinalFluid
ID: 381122421 Fri, Jan 25, 2002, 23:49
Logic is pretty simple. The Frozen Roster "table_id" is calculated off of the difference from today's date and the StartDate ( + 1 more for grins).
I actually need to add a "StartDate" field in the "Setup" worksheet. Would make the modification a whole lot more user friendly. Maybe next release. Or for the baseball stuff.
34
Dan Donor
ID: 41838303 Fri, Jan 25, 2002, 23:54
that would be nice RSF! ;-)
35
Farn
ID: 171128623 Sat, Jan 26, 2002, 01:06
am i the only idiot who can't get the SWP to work?
I guess its probably because i have excel2000. anyone with 2000 have it working?
or better yet, maybe you can tell me what i am doing wrong. i click to load boxscores, it says it did, but it never loads anything.
thanks.
36
rage_22 Donor
ID: 490311415 Mon, Jan 28, 2002, 00:43
Farn, I am having the same problem with the SWP calculator running on Excel 2000. It says the boxscores have been loaded, but nothing shows up. I tried to scan through the VB code, but I couldn't figure anything out. Anybody have any solutions?
37
Dan Donor
ID: 41838303 Mon, Jan 28, 2002, 03:20
Only solution unfortunatly is to get Excel 97...
38
Chris Eibling
ID: 40053013 Thu, Jan 31, 2002, 12:28
Here is a spreadsheet that I created to help me int he Non-Ultimate Fantasy Hoops League. I also have a philosphy for trying to judge who will be the big price mover in the Non Ultimate league. IF ANYONE knows of a good way to tell what the Tuesday price changes might be prior then pleaselet me know I am trying to sell and Buy Monday to gain the most on all players..But there is not a Chat or Forum for that league...Much harder to tell who is going to be the major price movers Plus they do not play the Games per week trend as much as this league.
Here is a spreadsheet that I created to help me int he Non-Ultimate Fantasy Hoops League. I also have a philosphy for trying to judge who will be the big price mover in the Non Ultimate league. IF ANYONE knows of a good way to tell what the Tuesday price changes might be prior then pleaselet me know I am trying to sell and Buy Monday to gain the most on all players..But there is not a Chat or Forum for that league...Much harder to tell who is going to be the major price movers Plus they do not play the Games per week trend as much as this league. My Smallworld Games Per Week and what Days of actual play Spreadsheet
40
Dave R Leader
ID: 147341310 Sun, Feb 10, 2002, 08:55
BUTT
41
AHSbball05
ID: 571039718 Sun, Feb 10, 2002, 14:54
how do you change the startdate in the macro for the ownership of players???? it doesnt say any players!
42
RecycledSpinalFluid
ID: 42121814 Tue, Feb 12, 2002, 13:18
AHSbball05, I don't follow the question. Is it producing "no players" again, despite doing the changes mentioned in post #31?
43
rockafellerskank Sustainer
ID: 30831210 Wed, Dec 11, 2002, 14:20
JCS Sustainer
ID: 20102934 Fri, Oct 08, 2004, 09:27
Digging up an old thread.. Probably most of the links above don't work anymore, so maybe we could put some new ones to help each other.
Here are the sites I visit often for hoops info, most of them daily :
* Rotoworld : The Ultimate Resource for Fantasy Hoops, at least for free sites, never tried the paying ones. And they're quite funny sometimes in their commentary.
* InsideHoops Media Links : A really useful resource when you're looking for the insider info that won't make it to the mainstream media. My main source when it comes to injury and playing time info.
* NBA Forum Madness : Lists a lot of forums for every NBA team. Quite useful when you're looking for fresh news, like when people hear on radio that Iverson won't play tonight, you'll find it on forums before it makes it to newspapers and general sites.
* RealGM Forums : The Bulls, Raptors, and Knicks forums are really quite good. If you're looking for up-to-the-minute insider info on these teams, this is the place to go to.
* HoopsHype Rumor Mill : They browse a lot of sites and newspapers to gather all the useful info into one place. Quite informative, updated several times a day.
* BasketballBoards Forums : Their General NBA forum is possibly the best one I've seen, lots of informed people there, and interesting topics being debated. Their Bulls and Blazers forums are good too.
* SportSpyder : Quite cool. I go there usually in last resort, when I can't find the info I'm looking for anywhere else. Too bad it's not always updated very fast.
45
WonderB Sustainer
ID: 241053812 Fri, Oct 08, 2004, 09:49
i don't have many more interesting links. but i do have RAPTORS TV and, same as last year, i will try to watch the pregame show to update on those gametime decisions whenever possible. any others out there?
46
Gmoney
ID: 42732517 Fri, Nov 05, 2004, 17:54
We have all used this site to assemble our teams and most have gotten a jump on the competition because of the info/tools here.
Well, I was just looking at the Gurupatrons again and Guru is on pace to LOSE money just in operations, not to mentions his time.
Costs to maintain the site with its current capabilities, features, and game prizes are currently running at around $7,000 annually. In addition, I devote significant personal time and effort to producing the site, for which I am paid zilch.
Send donations to: Uncommon Cents, LLC 1245 Farmington Ave., PMB 386 West Hartford, CT 06107
If you can, support away.
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.