New forums are going live April 23, 2018. Check it out for yourself.

Excel Spreadsheets - Systems, Tools, Utilities and More

Forum: Systems & Strategies Page 11 of 11 «  7 8 9 10 11  
Author: [Systems & Strategies] Topic: Excel Spreadsheets - Systems, Tools, Utilities and More
BuckeyeKaptn PM BuckeyeKaptn
Joined: Jan 2013
Posts: 1274
 
BuckeyeKaptn
Participation Meter
Veteran
quote#251
Posted: 4/19/2017 9:46:38 PM
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 PM dalypen
Joined: Apr 2017
Posts: 4
 
dalypen
Participation Meter
Prospect
quote#252
Posted: 4/20/2017 6:22:21 PM
[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 PM booey
Joined: Jun 2015
Posts: 26
 
booey
Participation Meter
Prospect
quote#253
Posted: 4/20/2017 9:55:26 PM
Thanks for the info buckey. Im guessing there is no way to successfully view this on an iPhone and have it update daily?
BuckeyeKaptn PM BuckeyeKaptn
Joined: Jan 2013
Posts: 1274
 
BuckeyeKaptn
Participation Meter
Veteran
quote#254
Posted: 4/21/2017 10:39:19 AM
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 PM BuckeyeKaptn
Joined: Jan 2013
Posts: 1274
 
BuckeyeKaptn
Participation Meter
Veteran
quote#255
Posted: 4/22/2017 8:11:13 AM
Found a problem for the 5r Fd/u470 plays.  File updated, and fix is on the Google Sheet if you already downloaded.
booey PM booey
Joined: Jun 2015
Posts: 26
 
booey
Participation Meter
Prospect
quote#256
Posted: 4/22/2017 5:52:00 PM
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 PM BuckeyeKaptn
Joined: Jan 2013
Posts: 1274
 
BuckeyeKaptn
Participation Meter
Veteran
quote#257
Posted: 4/22/2017 6:01:19 PM
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.
Posted using a mobile device.
jenjay23 PM jenjay23
Joined: Mar 2006
Posts: 338
 
jenjay23
Participation Meter
Prospect
quote#258
Posted: 4/24/2017 12:44:24 PM
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
BuckeyeKaptn PM BuckeyeKaptn
Joined: Jan 2013
Posts: 1274
 
BuckeyeKaptn
Participation Meter
Veteran
quote#259
Posted: 5/4/2017 9:59:10 PM
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 PM sports_Network
Joined: Feb 2009
Posts: 6041
 
sports_Network
Participation Meter
Captain
quote#260
Posted: 5/5/2017 7:09:24 AM
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 PM BarackPajamas
Joined: Jun 2016
Posts: 20
 
BarackPajamas
Participation Meter
Prospect
quote#261
Posted: 6/3/2017 4:07:01 AM
@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 PM BarackPajamas
Joined: Jun 2016
Posts: 20
 
BarackPajamas
Participation Meter
Prospect
quote#262
Posted: 6/14/2017 11:08:30 AM
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 PM fin6969
Joined: May 2016
Posts: 16
 
fin6969
Participation Meter
Prospect
quote#263
Posted: 3/25/2018 4:02:37 PM
Buckeye
Could You please update your spreadsheet to 2018?
BuckeyeKaptn PM BuckeyeKaptn
Joined: Jan 2013
Posts: 1274
 
BuckeyeKaptn
Participation Meter
Veteran
quote#264
Posted: 3/26/2018 7:00:17 AM
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 PM jb246810
Joined: Mar 2018
Posts: 1
 
jb246810
Participation Meter
Prospect
quote#265
Posted: 4/3/2018 9:23:02 PM

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 PM jenjay23
Joined: Mar 2006
Posts: 338
 
jenjay23
Participation Meter
Prospect
quote#266
Posted: 4/14/2018 3:45:27 PM
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


Forum: Systems & Strategies Page 11 of 11 «  7 8 9 10 11  
You have entered the forum as a GUEST. 
You must login/register to post or reply.
Desktop View: Switch to Mobile View