We're experimenting with our forums. Check it out for yourself.

# Excel Spreadsheets - Systems, Tools, Utilities and More

Page 7 of 11   5 6 7 8 9
 Author: [Systems & Strategies] Topic: Excel Spreadsheets - Systems, Tools, Utilities and More tidbit PM tidbitJoined: Jun 2013Posts: 10 Prospect #151Posted: 5/3/2014 3:35:02 PMIs anyone maintaining the Buddah spreadsheet? I get an error on Module 2. Dell73 PM Dell73Joined: Apr 2009Posts: 17 Prospect #152Posted: 5/4/2014 1:50:47 AMIs it possible for someone to fix the MLB SUPER SYSTEM .. thanks in advanceDegenGamble ?Leprechaun ?please guys cappervin PM cappervinJoined: May 2008Posts: 24 Prospect #153Posted: 5/6/2014 10:58:40 PMQUOTE 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 irageJoined: Nov 2005Posts: 4125 Banned #154Posted: 5/8/2014 10:44:50 PMHey 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 dplewis34Joined: Aug 2013Posts: 76 Prospect #155Posted: 5/13/2014 12:33:50 PMThanks man, that's exactly what I needed. irage PM irageJoined: Nov 2005Posts: 4125 Banned #156Posted: 5/17/2014 10:52:12 PMDegen,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 donfernandoJoined: Feb 2014Posts: 107 Prospect #157Posted: 6/19/2014 2:16:55 AMQUOTE 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 2010can anybody tell me why??? BuckeyeKaptn PM BuckeyeKaptnJoined: Jan 2013Posts: 776 Rookie #158Posted: 6/20/2014 7:28:00 AMIs your excel more recent than 2007? donfernando PM donfernandoJoined: Feb 2014Posts: 107 Prospect #159Posted: 6/20/2014 10:05:12 AMQUOTE 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 perfectlyanother 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 correctlythank you for your help again BuckeyeKaptn PM BuckeyeKaptnJoined: Jan 2013Posts: 776 Rookie #160Posted: 6/20/2014 6:50:41 PMHighlight 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 jhantzopJoined: Jul 2014Posts: 5 Prospect #161Posted: 7/8/2014 4:03:25 PMIs anyone maintaining the MLB Super Systems excel? lillblues1978 PM lillblues1978Joined: Jan 2011Posts: 1 Prospect #162Posted: 1/28/2015 2:27:45 PMQUOTEI 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 MikeyFingersJoined: Mar 2008Posts: 350 Prospect #163Posted: 1/28/2015 5:42:09 PMawesome spreadsheet!! any chance it can be updated to get the 2013-2014 NBA season? thanks so much. jenjay23 PM jenjay23Joined: Mar 2006Posts: 335 Prospect #164Posted: 1/28/2015 6:18:02 PMMikey, 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 2008Posts: 3548 Veteran #165Posted: 1/28/2015 8:30:05 PMThe date formatting screws up sometimes. Does anyone have a quick fix? Or do i have to manually correct it? bookus PM bookusJoined: Aug 2014Posts: 37 Prospect #166Posted: 1/29/2015 12:54:22 AMNice 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_NetworkJoined: Feb 2009Posts: 5596 Covers Rehab #167Posted: 2/8/2015 8:50:13 AMQUOTE 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_NetworkJoined: Feb 2009Posts: 5596 Covers Rehab #168Posted: 2/8/2015 8:57:53 AMQUOTE 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 MikeyFingersJoined: Mar 2008Posts: 350 Prospect #169Posted: 2/8/2015 3:46:22 PMQUOTE 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_NetworkJoined: Feb 2009Posts: 5596 Covers Rehab #170Posted: 2/11/2015 6:06:30 AMreceived the PM, thanks Coupee36 PM Coupee36Joined: Aug 2008Posts: 348 Prospect #171Posted: 2/20/2015 1:15:23 PMits 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 BuckeyeKaptnJoined: Jan 2013Posts: 776 Rookie #172Posted: 4/13/2015 8:26:28 AMI 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 AMApplication.OnTime TimeValue("02:50:00"), "CoversData"End SubThis 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 jenjay23Joined: Mar 2006Posts: 335 Prospect #173Posted: 4/13/2015 11:50:04 AMBuckeye,, 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.GLhttps://drive.google.com/file/d/0B9UBaNk9s7UjWmRtWTdUeTh4SzQ/view?usp=sharing BuckeyeKaptn PM BuckeyeKaptnJoined: Jan 2013Posts: 776 Rookie #174Posted: 4/13/2015 2:35:51 PMThanx 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 literatoJoined: Jun 2013Posts: 39 Prospect #175Posted: 4/13/2015 3:18:13 PMHello jj23 as usual nice work on this new file
 Page 7 of 11   5 6 7 8 9
You have entered the forum as a GUEST.
You must login/register to post or reply.
Desktop View: Switch to Mobile View