We're experimenting with our forums. 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: 771
 
BuckeyeKaptn
Participation Meter
Rookie
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: 25
 
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: 771
 
BuckeyeKaptn
Participation Meter
Rookie
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: 771
 
BuckeyeKaptn
Participation Meter
Rookie
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: 25
 
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: 771
 
BuckeyeKaptn
Participation Meter
Rookie
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: 335
 
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: 771
 
BuckeyeKaptn
Participation Meter
Rookie
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: 5596
 
sports_Network
Participation Meter
Covers Rehab
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.
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