All Forums | Systems & Strategies

Excel Spreadsheets - Systems, Tools, Utilities and More

...
Participants:
Search model icon
Views: 119508
Posts: 276
 
Prospect
Participation Meter
Joined: Jun, 2013
Posts: 10
Posted: #151
Is anyone maintaining the Buddah spreadsheet? I get an error on Module 2.
 
Prospect
Participation Meter
Joined: Apr, 2009
Posts: 17
Posted: #152
Is it possible for someone to fix the MLB SUPER SYSTEM .. thanks in advance
DegenGamble ?
Leprechaun ?

please guys
 
Prospect
Participation Meter
Joined: May, 2008
Posts: 24
Posted: #153
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)
 
Banned
Participation Meter
Joined: Nov, 2005
Posts: 4125
Posted: #154
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.
 
Prospect
Participation Meter
Joined: Aug, 2013
Posts: 76
Posted: #155
Thanks man, that's exactly what I needed.
 
Banned
Participation Meter
Joined: Nov, 2005
Posts: 4125
Posted: #156
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.
 
Prospect
Participation Meter
Joined: Feb, 2014
Posts: 108
Posted: #157
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???
 
Veteran
Participation Meter
Joined: Jan, 2013
Posts: 1447
Posted: #158
Is your excel more recent than 2007?
 
Prospect
Participation Meter
Joined: Feb, 2014
Posts: 108
Posted: #159
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
 
Veteran
Participation Meter
Joined: Jan, 2013
Posts: 1447
Posted: #160
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.
 
Prospect
Participation Meter
Joined: Jul, 2014
Posts: 5
Posted: #161
Is anyone maintaining the MLB Super Systems excel?
 
Prospect
Participation Meter
Joined: Jan, 2011
Posts: 1
Posted: #162
I 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?

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

 
Prospect
Participation Meter
Joined: Mar, 2008
Posts: 350
Posted: #163
awesome spreadsheet!! any chance it can be updated to get the 2013-2014 NBA season? thanks so much.
 
Prospect
Participation Meter
Joined: Mar, 2006
Posts: 342
Posted: #164

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

 
Veteran
Participation Meter
Joined: Mar, 2008
Posts: 3549
Posted: #165
The date formatting screws up sometimes. 
Does anyone have a quick fix? Or do i have to manually correct it? 

 
Prospect
Participation Meter
Joined: Aug, 2014
Posts: 37
Posted: #166
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
 
Banned
Participation Meter
Joined: Feb, 2009
Posts: 8426
Posted: #167
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.....
 
Banned
Participation Meter
Joined: Feb, 2009
Posts: 8426
Posted: #168
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

 
Prospect
Participation Meter
Joined: Mar, 2008
Posts: 350
Posted: #169
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.
 
Banned
Participation Meter
Joined: Feb, 2009
Posts: 8426
Posted: #170

received the PM, thanks

 
Prospect
Participation Meter
Joined: Aug, 2008
Posts: 348
Posted: #171
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.
 
Veteran
Participation Meter
Joined: Jan, 2013
Posts: 1447
Posted: #172
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.

 
Prospect
Participation Meter
Joined: Mar, 2006
Posts: 342
Posted: #173
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
 
Veteran
Participation Meter
Joined: Jan, 2013
Posts: 1447
Posted: #174
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.
 
 
Prospect
Participation Meter
Joined: Jun, 2013
Posts: 41
Posted: #175
Hello jj23 as usual nice work on this new file
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.