Excel Spreadsheets - Systems, Tools, Utilities and More

First << 8 of 11 >> Last
Views: 111402
Posts: 266
 
Prospect
Participation Meter
Joined: Apr, 2015
Posts: 4
#176 Report User
Posted:

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!
 
Prospect
Participation Meter
Joined: Mar, 2006
Posts: 340
#177 Report User
Posted:

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
 
Prospect
Participation Meter
Joined: Mar, 2006
Posts: 340
#178 Report User
Posted:

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


 
Prospect
Participation Meter
Joined: Apr, 2015
Posts: 4
#179 Report User
Posted:

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!
 
Veteran
Participation Meter
Joined: Jan, 2013
Posts: 1440
#180 Report User
Posted:

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.
 
Prospect
Participation Meter
Joined: Mar, 2015
Posts: 33
#181 Report User
Posted:

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 !

 
Prospect
Participation Meter
Joined: Mar, 2006
Posts: 340
#182 Report User
Posted:

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!
 
Prospect
Participation Meter
Joined: Mar, 2015
Posts: 33
#183 Report User
Posted:

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 
 
Prospect
Participation Meter
Joined: Jan, 2010
Posts: 178
#184 Report User
Posted:

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
 
Prospect
Participation Meter
Joined: Mar, 2006
Posts: 340
#185 Report User
Posted:

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 
 
Prospect
Participation Meter
Joined: Apr, 2015
Posts: 4
#186 Report User
Posted:

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!
 
Prospect
Participation Meter
Joined: Mar, 2006
Posts: 340
#187 Report User
Posted:

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
 
Prospect
Participation Meter
Joined: Apr, 2015
Posts: 4
#188 Report User
Posted:

That's what I was thinking too.  Thanks for the quick reply!
 
Prospect
Participation Meter
Joined: Mar, 2009
Posts: 324
#189 Report User
Posted:

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 
 
Veteran
Participation Meter
Joined: Aug, 2013
Posts: 1033
#190 Report User
Posted:

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
 
Veteran
Participation Meter
Joined: Mar, 2008
Posts: 3549
#191 Report User
Posted:

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
 
Veteran
Participation Meter
Joined: Aug, 2013
Posts: 1033
#192 Report User
Posted:

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

Did you do this all manually?

Great stuff,
Regards, RM


 
Veteran
Participation Meter
Joined: Mar, 2008
Posts: 3549
#193 Report User
Posted:

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. 
 
Prospect
Participation Meter
Joined: Jan, 2012
Posts: 14
#194 Report User
Posted:

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.  
 
Captain
Participation Meter
Joined: Feb, 2009
Posts: 6392
#195 Report User
Posted:

DG, Any 'new' updates for the 2015 season?
 
Prospect
Participation Meter
Joined: Feb, 2014
Posts: 108
#196 Report User
Posted:

can some1 please tell me about:
MLB LINES FROM VEGAS INSIDER
what sportbook those lines comes?
 
Veteran
Participation Meter
Joined: May, 2014
Posts: 1545
#197 Report User
Posted:

Hi! How can I export the data from the NBA Matchup page into an Excel spreadsheet? Thanks
 
Captain
Participation Meter
Joined: Feb, 2009
Posts: 6392
#198 Report User
Posted:

DG

Anything in progress for the upcoming MLB 2016 season?

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

 
Prospect
Participation Meter
Joined: Mar, 2016
Posts: 5
#199 Report User
Posted:

bump
 
Prospect
Participation Meter
Joined: Mar, 2016
Posts: 6
#200 Report User
Posted:

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
First << 8 of 11 >> Last
Desktop View: Switch to Mobile View