SLNG-II Excel Files - Dump File AnalysisPrev TopicNext Topic

• winsumloosesum

  

  Philadelpia/Pennsylvania
  United States
  Member #2,218
  September 1, 2003
  6,805 Posts
  Offline
  Apr 3, 2018, 3:24 pm

  ▲▼

  I did not want to place these videos and instructions in the main SLNG-II thread.

  I created 3 Excel files to use side-by-side with RL's SLNG-II program.

  The Excel files use the "Dump.TXT" file which is located in the sub folder "Files".

  Using the Dump.txt file we can analyze the winning results and settings created by SLNG-II.

  Here is the 1st video uploaded to Youtube:

  https://youtu.be/UV09cnLkchk

  I'll post additional information and videos....
• winsumloosesum

  

  Philadelpia/Pennsylvania
  United States
  Member #2,218
  September 1, 2003
  6,805 Posts
  Offline
  Apr 3, 2018, 3:40 pm

  ▲▼

  Video 2: Master Slider Settings

  This video explains how I import the Dump.txt into the Excel file.

  https://youtu.be/svKP_OHFYyA

  Download link to Excel file (Version 2010) 1.2 mb

  https://my.pcloud.com/publink/show?code=XZTyi87Zr6ynACVisIBKvkY1OG2G38dqT0qV

  Note: This Excel file may not work on previous versions of Excel.

  You may need to adjust your security setting and also enable macros when prompted.
• winsumloosesum

  

  Philadelpia/Pennsylvania
  United States
  Member #2,218
  September 1, 2003
  6,805 Posts
  Offline
  Apr 3, 2018, 3:50 pm

  ▲▼

  Video 3: Master Slider Settings - Hits & Skips Calculations and Same (S)/Change (C) calculations.

  https://youtu.be/K0Jh5RoCqpU
• ram

  

  South Texas
  United States
  Member #11
  December 6, 2001
  307 Posts
  Offline
  Apr 3, 2018, 4:46 pm

  ▲▼

  Thanks for the videos winsum. Your hard work is much appreciated.
• Gwoof

  

  Horwood NL
  Canada
  Member #70,611
  February 6, 2009
  729 Posts
  Offline
  Apr 3, 2018, 5:45 pm

  ▲▼

  Steve

  Will you be making excel file for P4? We don't have P3 here in Atlantic Canada. I know the videos will be the same for P4.

  Thanks

   GW
• Gwoof

  

  Horwood NL
  Canada
  Member #70,611
  February 6, 2009
  729 Posts
  Offline
  Apr 3, 2018, 6:01 pm

  ▲▼
  In response to Gwoof

  Quote: Originally posted by Gwoof on Apr 3, 2018

  Steve

  Will you be making excel file for P4? We don't have P3 here in Atlantic Canada. I know the videos will be the same for P4.

  Thanks

   GW

  Steve

  From watching the videos it looks like the only thing that changes is the game history section.

  Thanks again

   GW
• Johnebench

  

  New Hampshire
  United States
  Member #181,609
  May 8, 2017
  1,069 Posts
  Offline
  Apr 3, 2018, 8:03 pm

  ▲▼
  In response to winsumloosesum

  Quote: Originally posted by winsumloosesum on Apr 3, 2018

  Video 2: Master Slider Settings

  This video explains how I import the Dump.txt into the Excel file.

  https://youtu.be/svKP_OHFYyA

  Download link to Excel file (Version 2010) 1.2 mb

  https://my.pcloud.com/publink/show?code=XZTyi87Zr6ynACVisIBKvkY1OG2G38dqT0qV

  Note: This Excel file may not work on previous versions of Excel.

  You may need to adjust your security setting and also enable macros when prompted.

  Thanks Steve, Another very helpful program for us. 
• Johnebench

  

  New Hampshire
  United States
  Member #181,609
  May 8, 2017
  1,069 Posts
  Offline
  Apr 3, 2018, 9:29 pm

  ▲▼

  Ya know Steve about a year ago I would have got 5 minutes into the Sling 2 video 1 and my head would be in overload, Now I'm patiently waiting for your next video #4 to see what other juicy tid bits you have in store for us. Sure does beat entering all that data one at a time by hand. I for one am very happy with this so far. 

  Thank You. 
• Gwoof

  

  Horwood NL
  Canada
  Member #70,611
  February 6, 2009
  729 Posts
  Offline
  Apr 4, 2018, 7:40 am

  ▲▼
  In response to winsumloosesum

  Quote: Originally posted by winsumloosesum on Apr 3, 2018

  Video 2: Master Slider Settings

  This video explains how I import the Dump.txt into the Excel file.

  https://youtu.be/svKP_OHFYyA

  Download link to Excel file (Version 2010) 1.2 mb

  https://my.pcloud.com/publink/show?code=XZTyi87Zr6ynACVisIBKvkY1OG2G38dqT0qV

  Note: This Excel file may not work on previous versions of Excel.

  You may need to adjust your security setting and also enable macros when prompted.

  Steve

  Will you be making the excel file for P4?
• winsumloosesum

  

  Philadelpia/Pennsylvania
  United States
  Member #2,218
  September 1, 2003
  6,805 Posts
  Offline
  Apr 4, 2018, 9:14 am

  ▲▼

  Yes.  May be a few days...
• Gwoof

  

  Horwood NL
  Canada
  Member #70,611
  February 6, 2009
  729 Posts
  Offline
  Apr 4, 2018, 9:44 am

  ▲▼
  In response to winsumloosesum

  Quote: Originally posted by winsumloosesum on Apr 4, 2018

  Yes.  May be a few days...

  Thanks
• winsumloosesum

  

  Philadelpia/Pennsylvania
  United States
  Member #2,218
  September 1, 2003
  6,805 Posts
  Offline
  Apr 5, 2018, 9:27 am

  ▲▼
  In response to Gwoof

  Quote: Originally posted by Gwoof on Apr 4, 2018

  Thanks

  Download link to Pick 3 and Pick 4 Excel files:

  https://my.pcloud.com/publink/show?code=XZdj0Q7ZWiqDJxtYkSp1FmQ5ETUcYSvpQ0r7

  I changed the file names and added Pick3 and Pick4 to the end of the file names.

  Important: Make sure you are importing the correct "DUMP" text file. 

  The Pick 3 game you Load into SLNG-II and create the Dump.txt file (Keyboard Shortcut D) open either the Excel file MSMasterDumpFileImportFilterPick3.xlsm or FSMasterDumpFileImportFilterPick3.xlsm

  The Pick 4 game you Load into SLNG-II and create the Dump.txt file (Keyboard Shortcut D) open either the Excel file MSMasterDumpFileImportFilterPick4.xlsm or FSMasterDumpFileImportFilterPick4.xlsm

  I will create some additional videos on how to use the Excel files.
• winsumloosesum

  

  Philadelpia/Pennsylvania
  United States
  Member #2,218
  September 1, 2003
  6,805 Posts
  Offline
  Apr 5, 2018, 10:32 am

  ▲▼

  Video 4 - This video explains the Rogue values and also using Positions 3 through 5 of the Rogue value to determine/filter the next draw Master Slider Setting(s).  Filters include Positions 3 through 5 only

  a>Rogue Positions 3 through 5

  b>Repeat/Higher/Lower

  c>Odd/Even

  d>High/Low

  e>Same/Change

  Link to the Youtube video #4

  https://youtu.be/PVgS4n1hdRw
• Gwoof

  

  Horwood NL
  Canada
  Member #70,611
  February 6, 2009
  729 Posts
  Offline
  Apr 5, 2018, 12:36 pm

  ▲▼
  In response to winsumloosesum

  Quote: Originally posted by winsumloosesum on Apr 5, 2018

  Download link to Pick 3 and Pick 4 Excel files:

  https://my.pcloud.com/publink/show?code=XZdj0Q7ZWiqDJxtYkSp1FmQ5ETUcYSvpQ0r7

  I changed the file names and added Pick3 and Pick4 to the end of the file names.

  Important: Make sure you are importing the correct "DUMP" text file. 

  The Pick 3 game you Load into SLNG-II and create the Dump.txt file (Keyboard Shortcut D) open either the Excel file MSMasterDumpFileImportFilterPick3.xlsm or FSMasterDumpFileImportFilterPick3.xlsm

  The Pick 4 game you Load into SLNG-II and create the Dump.txt file (Keyboard Shortcut D) open either the Excel file MSMasterDumpFileImportFilterPick4.xlsm or FSMasterDumpFileImportFilterPick4.xlsm

  I will create some additional videos on how to use the Excel files.

  Thanks Steve for the updates.

  Videos are great!

   GW
• Gwoof

  

  Horwood NL
  Canada
  Member #70,611
  February 6, 2009
  729 Posts
  Offline
  Apr 5, 2018, 1:13 pm

  ▲▼
  In response to Gwoof

  Quote: Originally posted by Gwoof on Apr 5, 2018

  Thanks Steve for the updates.

  Videos are great!

   GW

  Steve

  Followed the video for import of Atlantic Canada dump files and the draw dates are all mixed up on the AnalysisMS tab. I think it might be the date format that is causing the problem. The DGAME tab has 2 different formats for the dates.

   GW