All Forums | Systems & Strategies

Excel Spreadsheets - Systems, Tools, Utilities and More

...
Participants:
Search model icon
Views: 119508
Posts: 276
 
Veteran
Participation Meter
Joined: Jan, 2013
Posts: 1447
Posted: #251
Quote Originally Posted by booey:

Hi Guys,

I use Google Sheets and and it seems I'm unable to update both jenjay or Buckeys sheets. jenjays is stuck on the 11th of this month and Buckeys shows the correct date however the games and plays are stuck on back when the NYY played TB etc..... Does Google Shets not work properly with these formats? Although im probably doing something wrong......
I opened it in Google Sheets, your answer is no.  There doesn't look like there's any way to update.  Clicking on "All" does nothing. Sheets looks like something to use if you're not pulling info from the internet.
 
Prospect
Participation Meter
Joined: Apr, 2017
Posts: 4
Posted: #252
[Quote: Originally Posted by BuckeyeKaptn] @dalypen rows 1-45 are hidden and have the formulas.  Check up there.  I think that was where the problem was. If not, check in Module 1 - AddBets

@Scrivero One more thing.  Do you have Calculation Options set as Automatic?  I'm trying to get everything set to be automatically updated.  Some formulas will kick this option to manual and then nothing will automate. 
Formulas > Calculation Options>Automatic.
@BuckeyeKaptn That was where the problem was rows 1-45 in the game column. Haven't had time to fix it yet. So thanks for the info.
 
Prospect
Participation Meter
Joined: Jun, 2015
Posts: 27
Posted: #253
Thanks for the info buckey. Im guessing there is no way to successfully view this on an iPhone and have it update daily?
 
Veteran
Participation Meter
Joined: Jan, 2013
Posts: 1447
Posted: #254
Here it is finally:

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

Change the name of the other one first, this one will copy over it.  Plus, you can use the older one to mess around with...test things etc.  You can only use Microsoft Office to do anything with this other than view.
I made a Google Sheet online, with a link in the Excel file so if there's questions or problems, it can be talked about and resolved there, instead of clogging this thread.

Enjoy. 

 
It was a lot of work, going back a couple of years.  Glad it's done.
 
Veteran
Participation Meter
Joined: Jan, 2013
Posts: 1447
Posted: #255
Found a problem for the 5r Fd/u470 plays.  File updated, and fix is on the Google Sheet if you already downloaded.
 
Prospect
Participation Meter
Joined: Jun, 2015
Posts: 27
Posted: #256
buckeye,

I tried to post on the question sheet but I get told "view only". Any this can successfully be viewed on an iPhone? Been trying everything. I can view the sheet but doesn't seem to update.




 
Veteran
Participation Meter
Joined: Jan, 2013
Posts: 1447
Posted: #257
Quote Originally Posted by booey:

buckeye,I tried to post on the question sheet but I get told "view only". Any this can successfully be viewed on an iPhone? Been trying everything. I can view the sheet but doesn't seem to update.

Should now. Had the setting wrong. I tested from my phone..a droid. Worked fine.
 
Prospect
Participation Meter
Joined: Mar, 2006
Posts: 342
Posted: #258
Quote Originally Posted by jenjay23:

Here is a link to my sheet for the 5 Super Systems.  It looks like the data is importing properly and formula's defined to give the qualifying games for each system are correct. 
GL & enjoy if you use or play

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

There was a few changes to some website formats which resulted in importing not working correctly.  I updated the link to hopefully have the sheet perform properly.
GL
 
Veteran
Participation Meter
Joined: Jan, 2013
Posts: 1447
Posted: #259
https://drive.google.com/file/d/0Bynr1eDtdk5ZUEdYQnUyeDR6bWc/view?usp=sharing

Updated, plus changes. V1.2
As season goes along, I'm finding better ways to present info, more info too.
 
Banned
Participation Meter
Joined: Feb, 2009
Posts: 8426
Posted: #260
Quote Originally Posted by BuckeyeKaptn:

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

Updated, plus changes. V1.2

appreciate the update....thanks

 
Prospect
Participation Meter
Joined: Jun, 2016
Posts: 20
Posted: #261
@Degen-
Where can I find importable MLB odds for Team totals & First 5 lines to import into google sheets? Any idea? I have been looking everywhere.
 
Prospect
Participation Meter
Joined: Jun, 2016
Posts: 20
Posted: #262
Hi Degen. I sent you a friend request. I am building a spreadsheet and was hoping you could help me with some questions.

I am pretty far along.
 
Prospect
Participation Meter
Joined: May, 2016
Posts: 41
Posted: #263
Buckeye
Could You please update your spreadsheet to 2018?
 
Veteran
Participation Meter
Joined: Jan, 2013
Posts: 1447
Posted: #264
Quote Originally Posted by fin6969:

Buckeye
Could You please update your spreadsheet to 2018?

Did this work all year? I stopped using it towards end of May, then made a new one in August that had different stuff in it.

I've been working on a totally new one, from scratch, but it has none of the chase plays in it.  It's more of a rankings based spreadsheet, similar to what I did for NHL this past season, plus the MLB version of GSGA.

I can update this one, but as with a lot of web sites, I need to wait until after the season starts.

Also, if a web site changes it's format, I won't know about it since I'm not using this sheet personally. I have System and Strategies bookmarked as I like to check out others ideas. I would see an update to this thread if there's a problem.

I'd like to thank DeGen.  I still use the Macro to pull the lines from Covers...the venerable "CoversData".
 
Prospect
Participation Meter
Joined: Mar, 2018
Posts: 2
Posted: #265

Degen, I sent you a friend request.  Would love the chance to pick your brain on automating a system/systems. The work you have done is incredible and I would love to find a way to replicate turing an idea into an automated system.  Thanks!

 
Prospect
Participation Meter
Joined: Mar, 2006
Posts: 342
Posted: #266
Sheet updated for 2018 if you like to use or look at daily.  Same link as below and I will track and update records throughout season.  Started tracking yesterday.
As Kapt'n pointed out, all the props to Degen who provided awesome sheets & info to build off of.

[Quote: Originally Posted by jenjay23] Here is a link to my sheet for the 5 Super Systems.  It looks like the data is importing properly and formula's defined to give the qualifying games for each system are correct. Qualifying plays should start coming hot n heavy over the next few weeks.  I personally "pick and play" games from systems 1, 2 & 5 and play them on various labby's that I track.  Historically they do pretty well.  I cant guarantee the accuracy in the sheet and if you play and identify something while you manually cap, let me know and I will see if its an easy fix.  I do run this sheet daily and track it's successes/failures and will update this link as the season goes on with somewhat accurate results.  Also any bugs that will occur with the sheet throughout the year will usually be fixed and updated as well.
GL & enjoy if you use or play

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


 
Prospect
Participation Meter
Joined: May, 2019
Posts: 3
Posted: #267

Hello All,

Would anyone have a 2019 Version of this spreadsheet? Also can anyone possibly help with instructions on updating the schedule for this season. Any help would be much appreciated!!

 

Thanx

 

 
Prospect
Participation Meter
Joined: Mar, 2006
Posts: 342
Posted: #268

Quote Originally Posted by RunninRebel1990:

Hello All, Would anyone have a 2019 Version of this spreadsheet? Also can anyone possibly help with instructions on updating the schedule for this season. Any help would be much appreciated!!   Thanx

 

RunninRebel,

I updated the link with this years.  I hid system #4 as i did not update the L3 years in ballpark info as i don't use it for any of the capping I do.  Hope it helps you with yours.  Qualifying picks for Systems #1 & 3 have been doing pretty well.  Personally I pick and choose the qualifying picks from those systems after some minor personal capping of the teams/trends/spots.

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

 
Prospect
Participation Meter
Joined: May, 2019
Posts: 3
Posted: #269

JenJay23,

 

Thank you very much for the update!! Much appreciated!!

 
Covers Linesmen
Participation Meter
Joined: Feb, 2001
Posts: 87445
Posted: #270
I will take a look


 
Banned
Participation Meter
Joined: Oct, 2017
Posts: 296
Posted: #271

Take a look at the spreadsheet in the money management article at bettingresource.com   It is one of the best that out there and I have been using it for years, not just for baseball but for all sports. 

 
Prospect
Participation Meter
Joined: May, 2019
Posts: 3
Posted: #272

Hello everyone!!

Are there any updated versions of the spreadsheets besides the Super System spreadsheets?

If so can someone provide here as I'm a stat geek and would like to checkout... Any info provided would be appreciated and Thank you!!

 
Prospect
Participation Meter
Joined: Apr, 2015
Posts: 2
Posted: #273

Quote Originally Posted by jenjay23:

Quote Originally Posted by RunninRebel1990:

Hello All, Would anyone have a 2019 Version of this spreadsheet? Also can anyone possibly help with instructions on updating the schedule for this season. Any help would be much appreciated!!   Thanx
  RunninRebel, I updated the link with this years.  I hid system #4 as i did not update the L3 years in ballpark info as i don't use it for any of the capping I do.  Hope it helps you with yours.  Qualifying picks for Systems #1 & 3 have been doing pretty well.  Personally I pick and choose the qualifying picks from those systems after some minor personal capping of the teams/trends/spots. https://drive.google.com/file/d/0B9UBaNk9s7UjMnFuNXlDWUM4cVE/view?usp=sharing

 

Great thanks for your job :D

 
Prospect
Participation Meter
Joined: Jun, 2015
Posts: 27
Posted: #274

Hi Guys,

 

The sheet has been working great until a couple of days ago and now when I hit daily update, after it completes the system plays come up blank and going back in time there's no plays on any of the other dates.

 

Any ideas?

 
 
Prospect
Participation Meter
Joined: Mar, 2006
Posts: 342
Posted: #275

Thought i would pop my head in here and see what's up.....not a whole lot of activity like the old days :(

Info over the years has certainly changed and how we get it, but I am an excel junkie at heart and love the sheets Degen starting me off with.  Still use them daily for my daily capping. I updated the "Super System" sheet for 2024,  I find it useful to quickly look at matchups and trends, and use the qualifying plays to further cap in deciding what plays i want to make.  I find it useful in identifying teams avoiding the sweep and revenging a sweep.  Systems 1 and 3 are always productive and qualify for the most plays but are always a bit juicy, if I like the pitching matchup, I play them with odds of <-150 by going with the -1 or -1.5.  This year it takes quite a bit longer to run the daily update (~8-10 minutes) due to a few website restrictions but gets the job done while you enjoy your coffee.  If you can use it as a tool or it helps create your own ideas, enjoy! I hope it works correctly and hopefully I got all the formulas correct but cant promise anything :)

here is the link:

https://drive.google.com/file/d/128KXYyZlaSgglJN3A1DmX0jWmRhBuFQ7/view?usp=sharing

All Forums | Systems & Strategies
About Us
Contact Us
Careers
Our Team
Brand
Testimonials
Betting Guides
Sportsbook Reviews
Sports Betting News
Podcasts
Responsible Gaming
Sports Betting
US Betting Sites
Canada Betting Sites
Canada Casinos
Best Betting Apps
Contests
Streak Survivor
King of Covers
Ultimate Race
Office Pools
The Covers community has
618,670
lifetime members worldwide
Covers 25 Years Logo Established in 1995,
Covers is the world
leader in sports
betting information.
Site Map Help Privacy Terms of Service youtube logo facebook logo twitter logo instagram logo linkedin logo google news logo
Covers is verified safe by: Evalon Logo GPWA Logo GDPR Logo GeoTrust Logo Evalon Logo
Copyright © 1995 - 2024 CS Media Limited All Rights Reserved.

If you choose to make use of any information on this website including online sports betting services from any websites that may be featured on this website, we strongly recommend that you carefully check your local laws before doing so.It is your sole responsibility to understand your local laws and observe them strictly.Covers does not provide any advice or guidance as to the legality of online sports betting or other online gambling activities within your jurisdiction and you are responsible for complying with laws that are applicable to you in your relevant locality.Covers disclaims all liability associated with your use of this website and use of any information contained on it.As a condition of using this website, you agree to hold the owner of this website harmless from any claims arising from your use of any services on any third party website that may be featured by Covers.