Excel Spreadsheets - Systems, Tools, Utilities and More

Forum: Systems & Strategies Page 7 of 9 «  5 6 7 8 9   »
Author: [Systems & Strategies] Topic: Excel Spreadsheets - Systems, Tools, Utilities and More
tidbit PM tidbit
Joined: Jun 2013
Posts: 10
Nevada
 
tidbit
Participation Meter
quote#151
Posted: 5/3/2014 3:35:02 PM
Is anyone maintaining the Buddah spreadsheet? I get an error on Module 2.
Dell73 PM Dell73
Joined: Apr 2009
Posts: 5
Croatia
 
Dell73
Participation Meter
quote#152
Posted: 5/4/2014 1:50:47 AM
Is it possible for someone to fix the MLB SUPER SYSTEM .. thanks in advance
DegenGamble ?
Leprechaun ?

please guys
cappervin PM cappervin
Joined: May 2008
Posts: 24
 
cappervin
Participation Meter
quote#153
Posted: 5/6/2014 10:58:40 PM
QUOTE Originally Posted by dplewis34:

I am needing help in excel. I am tracking records of multiple systems and I want to add the records up. Currently my formula is =left(B1,1)+left(B2,3) etc. With the records changing from say 9-0 to 10-0 it messes up the formula and I have to change the number of characters from 1 to 2. Is there an easier formula I can use for this. For instance: left(B1,everything left of "-")
I think this formula will get you what you are looking for...
=LEFT(B1,FIND("-",B1)-1)
irage PM irage
Joined: Nov 2005
Posts: 4125
Utah
 
irage
Participation Meter
quote#154
Posted: 5/8/2014 10:44:50 PM
Hey Guys, glad to see you are still at it. Really sick of all these posers in here claiming they have a "System".

Good luck this year.
dplewis34 PM dplewis34
Joined: Aug 2013
Posts: 76
 
dplewis34
Participation Meter
quote#155
Posted: 5/13/2014 12:33:50 PM
Thanks man, that's exactly what I needed.
irage PM irage
Joined: Nov 2005
Posts: 4125
Utah
 
irage
Participation Meter
quote#156
Posted: 5/17/2014 10:52:12 PM
Degen,

Nice work! I finally got around to taking a good look at the spreadsheet. Fine bit of coding my friend, simple clean. What would be cool is you had some pre-configured searches, common stuff with some variables.
donfernando PM donfernando
Joined: Feb 2014
Posts: 107
Dominican
              Republic
 
donfernando
Participation Meter
quote#157
Posted: 6/19/2014 2:16:55 AM
QUOTE Originally Posted by DegenGamble:

All Sports Game / ATS past results from Covers

Here are 4 excel spreadsheet that will allow you to import NBA, NHL, MLB, NHL Game / ATS results from Covers. All you have to do is select the SEASON you want to import from the dropdown and click the "IMPORT" button. The game logs for all the teams will be downloaded to the Covers Data tab.

if you want you can clear the blue cells in the Covers Data tab and start over or add to it. Anytime you import a season it is pasted below the last row.

You can download from the link below:

https://docs.google.com/file/d/0B5dydT9Oe6JbU1BVMlJqVXA0VkU/edit?usp=sharing



i have trouble trying to load any other mlb season but 2010
can anybody tell me why???
BuckeyeKaptn PM BuckeyeKaptn
Joined: Jan 2013
Posts: 656
Ohio
 
BuckeyeKaptn
Participation Meter
quote#158
Posted: 6/20/2014 7:28:00 AM
Is your excel more recent than 2007?
donfernando PM donfernando
Joined: Feb 2014
Posts: 107
Dominican
              Republic
 
donfernando
Participation Meter
quote#159
Posted: 6/20/2014 10:05:12 AM
QUOTE Originally Posted by BuckeyeKaptn:

Is your excel more recent than 2007?

yes, thank you buckeyKaptn, my excel its 2007, but i try in another pc, and its work perfectly

another Question, im havin trouble organizing the games per date beacuse some configuration date issue some are 2010, other are just 10, and they dont organize correctly

thank you for your help again
BuckeyeKaptn PM BuckeyeKaptn
Joined: Jan 2013
Posts: 656
Ohio
 
BuckeyeKaptn
Participation Meter
quote#160
Posted: 6/20/2014 6:50:41 PM
Highlight the column that has the date and then right click and go down to format? I think. I'm not at a computer. Hit I think the first tab and click on the date option to make the date one format. I'm going by memory so I hope that's right.
Posted using a mobile device.
jhantzop PM jhantzop
Joined: Jul 2014
Posts: 5
 
jhantzop
Participation Meter
quote#161
Posted: 7/8/2014 4:03:25 PM
Is anyone maintaining the MLB Super Systems excel?
lillblues1978 PM lillblues1978
Joined: Jan 2011
Posts: 1
 
lillblues1978
Participation Meter
quote#162
Posted: 1/28/2015 2:27:45 PM
QUOTEI tried NBA spreadsheet but it seemed that the latest results I could get is 2012-2013 season. The spreadsheet is locked so that I couldn't manually input the number of season. Is there any way to get the new results?

Originally Posted by DegenGamble:

All Sports Game / ATS past results from Covers

Here are 4 excel spreadsheet that will allow you to import NBA, NHL, MLB, NHL Game / ATS results from Covers. All you have to do is select the SEASON you want to import from the dropdown and click the "IMPORT" button. The game logs for all the teams will be downloaded to the Covers Data tab.

if you want you can clear the blue cells in the Covers Data tab and start over or add to it. Anytime you import a season it is pasted below the last row.

You can download from the link below:

https://docs.google.com/file/d/0B5dydT9Oe6JbU1BVMlJqVXA0VkU/edit?usp=sharing

MikeyFingers PM MikeyFingers
Joined: Mar 2008
Posts: 349
New York
 
MikeyFingers
Participation Meter
quote#163
Posted: 1/28/2015 5:42:09 PM
awesome spreadsheet!! any chance it can be updated to get the 2013-2014 NBA season? thanks so much.
jenjay23 PM jenjay23
Joined: Mar 2006
Posts: 304
Alberta
 
jenjay23
Participation Meter
quote#164
Posted: 1/28/2015 6:18:02 PM

Mikey,

Yes Degen and others made some awesome stuff to use in this thread.  If you want the 2013-2014 season to download you can unhide column "O".  to do this highlight on the letters N & P, right click, choose unhide.  you should see column O open up and will have the years present.  Just overwrite the 2012-2013 year with 2013-2014.  in the drop down in cell C7 you will se the year.  if you want the other years prior to 2013-2014 just continue overwriting the years down that column.   Hope that works for you.

GL

Bart_ PM Bart_
Joined: Mar 2008
Posts: 3547
Ontario
 
Bart_
Participation Meter
quote#165
Posted: 1/28/2015 8:30:05 PM
The date formatting screws up sometimes. 
Does anyone have a quick fix? Or do i have to manually correct it? 

bookus PM bookus
Joined: Aug 2014
Posts: 37
 
bookus
Participation Meter
quote#166
Posted: 1/29/2015 12:54:22 AM
Nice work, thanks

..I've made this calculator and I find it to be a useful tool. So, if it can help you.. ..I'll be glad.

www.advancedbetcalc.com/Downloads.aspx

(It has adds that I cannot remove just for this occasion, so please don't go there if you think that would not be appropriate. Just wanted to join this "help a fellow" action :), really wouldn't want to be called a spammer..)

Cheers
Posted using a mobile device.
sports_Network PM sports_Network
Joined: Feb 2009
Posts: 4651
Nevada
 
sports_Network
Participation Meter
quote#167
Posted: 2/8/2015 8:50:13 AM
QUOTE Originally Posted by jenjay23:

Mikey,

Yes Degen and others made some awesome stuff to use in this thread.  If you want the 2013-2014 season to download you can unhide column "O".  to do this highlight on the letters N & P, right click, choose unhide.  you should see column O open up and will have the years present.  Just overwrite the 2012-2013 year with 2013-2014.  in the drop down in cell C7 you will se the year.  if you want the other years prior to 2013-2014 just continue overwriting the years down that column.   Hope that works for you.

GL

what about 2014-2015 (present)? appreciate your effort, thanks.....
sports_Network PM sports_Network
Joined: Feb 2009
Posts: 4651
Nevada
 
sports_Network
Participation Meter
quote#168
Posted: 2/8/2015 8:57:53 AM
QUOTE Originally Posted by DegenGamble:

All Sports Game / ATS past results from Covers

Here are 4 excel spreadsheet that will allow you to import NBA, NHL, MLB, NHL Game / ATS results from Covers. All you have to do is select the SEASON you want to import from the dropdown and click the "IMPORT" button. The game logs for all the teams will be downloaded to the Covers Data tab.

if you want you can clear the blue cells in the Covers Data tab and start over or add to it. Anytime you import a season it is pasted below the last row.

You can download from the link below:

https://docs.google.com/file/d/0B5dydT9Oe6JbU1BVMlJqVXA0VkU/edit?usp=sharing

MikeyFingers PM MikeyFingers
Joined: Mar 2008
Posts: 349
New York
 
MikeyFingers
Participation Meter
quote#169
Posted: 2/8/2015 3:46:22 PM
QUOTE Originally Posted by jenjay23:

Mikey,

Yes Degen and others made some awesome stuff to use in this thread.  If you want the 2013-2014 season to download you can unhide column "O".  to do this highlight on the letters N & P, right click, choose unhide.  you should see column O open up and will have the years present.  Just overwrite the 2012-2013 year with 2013-2014.  in the drop down in cell C7 you will se the year.  if you want the other years prior to 2013-2014 just continue overwriting the years down that column.   Hope that works for you.

GL


Awesome! Thanks so much man.
sports_Network PM sports_Network
Joined: Feb 2009
Posts: 4651
Nevada
 
sports_Network
Participation Meter
quote#170
Posted: 2/11/2015 6:06:30 AM

received the PM, thanks

Coupee36 PM Coupee36
Joined: Aug 2008
Posts: 348
California
 
Coupee36
Participation Meter
quote#171
Posted: 2/20/2015 1:15:23 PM
its been awhile since i've been on here.. but just wanted to sign back in, and say thank you to those who worked on this spreadsheet.  I'll be downloading it today and taking a peek.
BuckeyeKaptn PM BuckeyeKaptn
Joined: Jan 2013
Posts: 656
Ohio
 
BuckeyeKaptn
Participation Meter
quote#172
Posted: 4/13/2015 8:26:28 AM
I found a handy little macro that I wish I knew about years ago.

Put this in "This Workbook" to work. You will see it on the left column of "Project - VBA Project"

Private Sub Workbook_Open()
'Runs a macro at 2:50 AM

Application.OnTime TimeValue("02:50:00"), "CoversData"

End Sub

This lil macro will run another macro at the specified time.  In this case, it will run my macro "CoversData" at 2:50 am.
It's real handy as pulling from Covers takes an amount of time I don't have in the morning before work.
Plug it in, Save. Close the excel file and bring it back up.

I'm going to make a macro that will pull all the info I use for my sheet.  I will use Task Scheduler to open the sheet at 245a, and then the macro will start at 250a.

jenjay23 PM jenjay23
Joined: Mar 2006
Posts: 304
Alberta
 
jenjay23
Participation Meter
quote#173
Posted: 4/13/2015 11:50:04 AM
Buckeye,
, thanks. I use the covers data download for a O/U system and this will help the agony of waiting a half hour for the sheet to update each morning.
As you requested this is my sheet for B2W's RPI, bD's Magna Carta1 & Magna Carta 2.  I hope qualifying games are correct as i just went through the schedule and identified series for both, their could be errors in qualifying series for that reason.  I also use win % filters for the MC's much similar to what Beefman proposed. These can be altered to your liking.  Please utilize a thread if one starts or bD's "bDDungeon" page if you want to follow all the qualifying plays in case he made any changes to his system.
GL
https://drive.google.com/file/d/0B9UBaNk9s7UjWmRtWTdUeTh4SzQ/view?usp=sharing
BuckeyeKaptn PM BuckeyeKaptn
Joined: Jan 2013
Posts: 656
Ohio
 
BuckeyeKaptn
Participation Meter
quote#174
Posted: 4/13/2015 2:35:51 PM
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.
literato PM literato
Joined: Jun 2013
Posts: 38
France
 
literato
Participation Meter
quote#175
Posted: 4/13/2015 3:18:13 PM
Hello jj23 as usual nice work on this new file
Forum: Systems & Strategies Page 7 of 9 «  5 6 7 8 9   »
You have entered the forum as a GUEST. 
You must login/register to post or reply.