Our new forums will be launched soon. Check it out for yourself.

Excel Spreadsheets - Systems, Tools, Utilities and More

Forum: Systems & Strategies Page 8 of 11 «  6 7 8 9 10   »
Author: [Systems & Strategies] Topic: Excel Spreadsheets - Systems, Tools, Utilities and More
GoodBadger PM GoodBadger
Joined: Apr 2015
Posts: 4
 
GoodBadger
Participation Meter
Prospect
quote#176
Posted: 4/13/2015 7:24:13 PM
After weeks of trying my own spreadsheet building, I also wonder if anyone is either A) Upkeeping or B) Selling a functional version of the Super System Spreadsheet for 2015?  After awhile frustration sets in and you're ready to throw down some cash to make it happen. :)  Thank for any insight!
jenjay23 PM jenjay23
Joined: Mar 2006
Posts: 335
 
jenjay23
Participation Meter
Prospect
quote#177
Posted: 4/14/2015 5:44:54 PM
Badger,
No promises as I haven't used or looked at this sheet before but i will look at Leprechaun's & Degen's sheet tonight and see if it's an easy update to the 2015 season
jenjay23 PM jenjay23
Joined: Mar 2006
Posts: 335
 
jenjay23
Participation Meter
Prospect
quote#178
Posted: 4/14/2015 7:06:55 PM
For those who like the original Degen "Super Systems" sheet, I believe i have the required information updated for 2015.  I DID NOT update the "Park Records" for the previous 3 years utilized for System#4 so you will have to do some googling and fill that information in the Park Record tab if you want to use it properly. I also did not check the original formula's to determine qualifying teams, only provided what i think is the proper information to determine those. To start out i would check the rules of the systems posted by Degen in post #4 and manually run through it to ensure you are playing the right games. Again, thx DEGEN for some great stuff to work with.
GL

https://drive.google.com/file/d/0B9UBaNk9s7UjemlmQXJPcmU0NEU/view?usp=sharing


GoodBadger PM GoodBadger
Joined: Apr 2015
Posts: 4
 
GoodBadger
Participation Meter
Prospect
quote#179
Posted: 4/14/2015 7:50:11 PM
Thanks so much guys!  I appreciate the generosity.  I'm really excited to give this a whirl and make this season a blast. I owe it to you folks!  I'm going to try systems 1 & 4, but I have a Baseball Reference page bookmarked where I can look back at the last 3 years in the same ballpark criteria. Awesome. Thanks again!
BuckeyeKaptn PM BuckeyeKaptn
Joined: Jan 2013
Posts: 1086
 
BuckeyeKaptn
Participation Meter
Veteran
quote#180
Posted: 4/14/2015 8:44:35 PM
QUOTE Originally Posted by BuckeyeKaptn:

Thanx for the sheets, JJ23.  
I made my macro, which is made up of all the "Call..." macros.  I did a test run a few minutes ago...changing the time to 14:25:00, saved, closed and reopened the spreadsheet.  I left the room, and came back...and it's running.  HUGE time saver!  I pull data from a lot of sites and mine usually takes an hour to update.
Dammit, nice long post wiped out.
The computer has to be on/awake for the macro to work, and the damn task scheduler didn't work.
Max67 PM Max67
Joined: Mar 2015
Posts: 33
 
Max67
Participation Meter
Prospect
quote#181
Posted: 4/15/2015 8:15:23 AM
QUOTE Originally Posted by jenjay23:

For those who like the original Degen "Super Systems" sheet, I believe i have the required information updated for 2015.  I DID NOT update the "Park Records" for the previous 3 years utilized for System#4 so you will have to do some googling and fill that information in the Park Record tab if you want to use it properly. I also did not check the original formula's to determine qualifying teams, only provided what i think is the proper information to determine those. To start out i would check the rules of the systems posted by Degen in post #4 and manually run through it to ensure you are playing the right games. Again, thx DEGEN for some great stuff to work with.
GL

https://drive.google.com/file/d/0B9UBaNk9s7UjemlmQXJPcmU0NEU/view?usp=sharing



Damn Updater doesnt work for me,nothing change,Sagarin ratings get scrambled,what to do ?

I have excel 2013 is that a problem or ?

Thank You for effort,I need just MLB underdog sheet !

jenjay23 PM jenjay23
Joined: Mar 2006
Posts: 335
 
jenjay23
Participation Meter
Prospect
quote#182
Posted: 4/15/2015 2:33:08 PM
Ya, sorry man. i thought usatoday's sagarin ratings might come in from their site consistently.....it doesn't. it will take a bit of vba playing to get it right.  i will attempt it when i get a bit of time and update the link, not sure when that will occur tho!
Max67 PM Max67
Joined: Mar 2015
Posts: 33
 
Max67
Participation Meter
Prospect
quote#183
Posted: 4/15/2015 8:14:42 PM
QUOTE Originally Posted by jenjay23:

Ya, sorry man. i thought usatoday's sagarin ratings might come in from their site consistently.....it doesn't. it will take a bit of vba playing to get it right.  i will attempt it when i get a bit of time and update the link, not sure when that will occur tho!

jenjay thx man for effort really...All the best 
grecycle99 PM grecycle99
Joined: Jan 2010
Posts: 169
 
grecycle99
Participation Meter
Prospect
quote#184
Posted: 4/19/2015 9:26:47 AM
Hey Jenjay

When I try to update the 2 last files, Here's the errors I have in the standings tab. I have explorer 11. Can someone tell how to make it connect to chrome instead??

''You've reached a degraded version of ESPN.com because you're using an unsupported version of Internet Explorer.

For a complete ESPN.com experience, please upgrade or use a supported browser. ''

Thanks in advance
Gaetan
jenjay23 PM jenjay23
Joined: Mar 2006
Posts: 335
 
jenjay23
Participation Meter
Prospect
quote#185
Posted: 4/23/2015 3:18:29 PM
I made a second attempt at DEGEN's original Super System sheet, the original link is updated.  NO guarantees as i dont know to much in excel VBA but for the people who liked to use it you can try this one and see if it is any better or at least accurate enough to give you some tools to make the system picks.  Again if you are playing these i would manually check before trusting the sheets accuracy
GL 
GoodBadger PM GoodBadger
Joined: Apr 2015
Posts: 4
 
GoodBadger
Participation Meter
Prospect
quote#186
Posted: 5/12/2015 9:51:38 AM
Thanks so much again, Jenjay!  Could you tell me what is the web site that contains the data displayed on the "Series" sheet that displays the game number of the series?  Thanks again!
jenjay23 PM jenjay23
Joined: Mar 2006
Posts: 335
 
jenjay23
Participation Meter
Prospect
quote#187
Posted: 5/12/2015 1:43:53 PM
GoodBadger,
That was all manual creation when the schedule came out for the season.  Obvious downfall of creating the series this way is it could have mistakes and does not pick up the cancelled and make up games.
GL
GoodBadger PM GoodBadger
Joined: Apr 2015
Posts: 4
 
GoodBadger
Participation Meter
Prospect
quote#188
Posted: 5/12/2015 1:48:50 PM
That's what I was thinking too.  Thanks for the quick reply!
Leprechaun PM Leprechaun
Joined: Mar 2009
Posts: 324
 
Leprechaun
Participation Meter
Prospect
quote#189
Posted: 5/30/2015 12:37:21 AM
Hello fellow degenerates.  It's been awhile for the old Leprechaun but I'm still out here and quietly visit the forums when there is time.  The last two seasons I've had family and work issues and haven't been able to dedicate time the extra time it takes to keep my systems or any others up and running publicly.  I thought I would be able to do it this season and then ended up traveling for half of April and May and having too many other commitments.

No promises, but I'll try to update this spreadsheet in the next couple weeks and get it working for everybody.  Even if you just get 2/3 of the season out of it, you can still make a few bucks.  If I don't happen to make it back to post the sheet, best of luck to everyone.  I'll always be lurking...

Leprechaun 
rivermonsterz PM rivermonsterz
Joined: Aug 2013
Posts: 1027
 
rivermonsterz
Participation Meter
Veteran
quote#190
Posted: 6/13/2015 7:58:45 AM
QUOTE Originally Posted by Bart_:

The date formatting screws up sometimes. 
Does anyone have a quick fix? Or do i have to manually correct it? 



I am also having the same issues.
Was wondering if anyone else apart from myself and bart had this problem and if anyone has a solution for the problem?

Kind Regards,
RM
Bart_ PM Bart_
Joined: Mar 2008
Posts: 3548
 
Bart_
Participation Meter
Veteran
quote#191
Posted: 6/15/2015 8:38:07 PM
QUOTE Originally Posted by rivermonsterz:



I am also having the same issues.
Was wondering if anyone else apart from myself and bart had this problem and if anyone has a solution for the problem?

Kind Regards,
RM

do you need MLB? 
I went though all of the years from 2008 and corrected the dates. 
I even added a win % column. 

Here is the link where you can download the Excel spreadsheet. 

http://tinyurl.com/owukcg8
rivermonsterz PM rivermonsterz
Joined: Aug 2013
Posts: 1027
 
rivermonsterz
Participation Meter
Veteran
quote#192
Posted: 6/16/2015 4:09:06 PM
Fantastic work bart. Thankyou very much, I really appreciate it.

Did you do this all manually?

Great stuff,
Regards, RM


Bart_ PM Bart_
Joined: Mar 2008
Posts: 3548
 
Bart_
Participation Meter
Veteran
quote#193
Posted: 6/16/2015 4:24:07 PM
QUOTE Originally Posted by rivermonsterz:

Fantastic work bart. Thankyou very much, I really appreciate it.

Did you do this all manually?

Great stuff,
Regards, RM



Yea, it wasn't too bad. Only the games which were played between the 1st and 12th day of the month got screwed up. I sorted by date, corrected the first one, then filled down on the other games from the same day. 
kcindc02 PM kcindc02
Joined: Jan 2012
Posts: 14
 
kcindc02
Participation Meter
Prospect
quote#194
Posted: 6/23/2015 8:10:57 AM
QUOTE Originally Posted by GoodBadger:

After weeks of trying my own spreadsheet building, I also wonder if anyone is either A) Upkeeping or B) Selling a functional version of the Super System Spreadsheet for 2015?  After awhile frustration sets in and you're ready to throw down some cash to make it happen. :)  Thank for any insight!

You should look at Statfox.com- they have a subscription service that might make sense for you.  
sports_Network PM sports_Network
Joined: Feb 2009
Posts: 5645
 
sports_Network
Participation Meter
Captain
quote#195
Posted: 7/20/2015 7:08:32 AM
DG, Any 'new' updates for the 2015 season?
donfernando PM donfernando
Joined: Feb 2014
Posts: 108
 
donfernando
Participation Meter
Prospect
quote#196
Posted: 8/27/2015 11:06:44 AM
can some1 please tell me about:
MLB LINES FROM VEGAS INSIDER
what sportbook those lines comes?
RojasBello PM RojasBello
Joined: May 2014
Posts: 1531
 
RojasBello
Participation Meter
Veteran
quote#197
Posted: 11/19/2015 9:22:39 AM
Hi! How can I export the data from the NBA Matchup page into an Excel spreadsheet? Thanks
sports_Network PM sports_Network
Joined: Feb 2009
Posts: 5645
 
sports_Network
Participation Meter
Captain
quote#198
Posted: 3/7/2016 10:46:37 AM

DG

Anything in progress for the upcoming MLB 2016 season?

let me know.....If not; the best to you

Nysut PM Nysut
Joined: Mar 2016
Posts: 5
 
Nysut
Participation Meter
Prospect
quote#199
Posted: 3/22/2016 10:53:38 AM
bump
Roxpile PM Roxpile
Joined: Mar 2016
Posts: 6
 
Roxpile
Participation Meter
Prospect
quote#200
Posted: 3/30/2016 11:43:41 PM
In the spreadsheets, there is a Schedule tab and lists which game of the series they're on. But what does the * mean? I see A* and even double stars. Help
Posted using a mobile device.
Forum: Systems & Strategies Page 8 of 11 «  6 7 8 9 10   »
You have entered the forum as a GUEST. 
You must login/register to post or reply.
Desktop View: Switch to Mobile View