All Forums | Systems & Strategies

Excel Spreadsheets - Systems, Tools, Utilities and More

...

Participants:

Posts: 278

BuckeyeKaptn

Veteran

Joined: Jan, 2013

Posts: 1447

Posted: Apr. 19, 2017 - 9:46 PM ET #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.

dalypen

Prospect

Joined: Apr, 2017

Posts: 4

Posted: Apr. 20, 2017 - 6:22 PM ET #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.

booey

Prospect

Joined: Jun, 2015

Posts: 27

Posted: Apr. 20, 2017 - 9:55 PM ET #253

Thanks for the info buckey. Im guessing there is no way to successfully view this on an iPhone and have it update daily?

BuckeyeKaptn

Veteran

Joined: Jan, 2013

Posts: 1447

Posted: Apr. 21, 2017 - 10:39 AM ET #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.

BuckeyeKaptn

Veteran

Joined: Jan, 2013

Posts: 1447

Posted: Apr. 22, 2017 - 8:11 AM ET #255

Found a problem for the 5r Fd/u470 plays. File updated, and fix is on the Google Sheet if you already downloaded.

booey

Prospect

Joined: Jun, 2015

Posts: 27

Posted: Apr. 22, 2017 - 5:52 PM ET #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.

BuckeyeKaptn

Veteran

Joined: Jan, 2013

Posts: 1447

Posted: Apr. 22, 2017 - 6:01 PM ET #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.

jenjay23

Prospect

Joined: Mar, 2006

Posts: 343

Posted: Apr. 24, 2017 - 12:44 PM ET #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.

BuckeyeKaptn

Veteran

Joined: Jan, 2013

Posts: 1447

Posted: May. 4, 2017 - 9:59 PM ET #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.

sports_Network

Banned

Joined: Feb, 2009

Posts: 8426

Posted: May. 5, 2017 - 7:09 AM ET #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

BarackPajamas

Prospect

Joined: Jun, 2016

Posts: 20

Posted: Jun. 3, 2017 - 4:07 AM ET #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.

BarackPajamas

Prospect

Joined: Jun, 2016

Posts: 20

Posted: Jun. 14, 2017 - 11:08 AM ET #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.

fin6969

Prospect

Joined: May, 2016

Posts: 44

Posted: Mar. 25, 2018 - 4:02 PM ET #263

Buckeye
Could You please update your spreadsheet to 2018?

BuckeyeKaptn

Veteran

Joined: Jan, 2013

Posts: 1447

Posted: Mar. 26, 2018 - 7:00 AM ET #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".

jb246810

Prospect

Joined: Mar, 2018

Posts: 2

Posted: Apr. 3, 2018 - 9:23 PM ET #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!

jenjay23

Prospect

Joined: Mar, 2006

Posts: 343

Posted: Apr. 14, 2018 - 3:45 PM ET #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

RunninRebel1990

Prospect

Joined: May, 2019

Posts: 3

Posted: May. 31, 2019 - 8:32 PM ET #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

jenjay23

Prospect

Joined: Mar, 2006

Posts: 343

Posted: Jun. 3, 2019 - 11:55 AM ET #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

RunninRebel1990

Prospect

Joined: May, 2019

Posts: 3

Posted: Jun. 3, 2019 - 4:19 PM ET #269

JenJay23,

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

Lippsman

Covers Linesmen

Joined: Feb, 2001

Posts: 87445

Posted: Jun. 4, 2019 - 10:07 AM ET #270

I will take a look

ILoveCover88

Banned

Joined: Oct, 2017

Posts: 296

Posted: Jun. 5, 2019 - 11:13 AM ET #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.

RunninRebel1990

Prospect

Joined: May, 2019

Posts: 3

Posted: Jun. 17, 2019 - 7:15 PM ET #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!!

alexmcm

Prospect

Joined: Apr, 2015

Posts: 2

Posted: Jul. 6, 2019 - 5:15 PM ET #273

Quote Originally Posted by jenjay23:

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

booey

Prospect

Joined: Jun, 2015

Posts: 27

Posted: Aug. 8, 2019 - 6:27 PM ET #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?

jenjay23

Prospect

Joined: Mar, 2006

Posts: 343

Posted: May. 23, 2024 - 10:16 AM ET #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

Excel Spreadsheets - Systems, Tools, Utilities and More

Hot Forum Topics