Welcome Guest
Log In | Register )
You last visited January 18, 2017, 9:04 am
All times shown are
Eastern Time (GMT-5:00)

excel chart

Topic closed. 18 replies. Last post 5 years ago by winsumloosesum.

Page 1 of 2
PrintE-mailLink
retxx's avatar - mrthumbs
BOSTON
United States
Member #48
September 9, 2001
3611 Posts
Offline
Posted: October 29, 2011, 11:26 am - IP Logged

need a chart to use to put in numbers from a previous week into pairs and have the chart use these numbers to come up with a pick 4 play. sample; last numbers were mid 6575 eve was 4523. pairs become 65-67-57-75. next 45-42-43-52-53-23. chart should come up with a pic 4 play for mid and eve. Help is appreciated. I used the previous week because in the past it seem to show many of the hits included in those numbers. hope someone can help.

    winsumloosesum's avatar - Lottery-060.jpg
    Pennsylvania
    United States
    Member #2218
    September 1, 2003
    5396 Posts
    Offline
    Posted: October 29, 2011, 6:01 pm - IP Logged

    need a chart to use to put in numbers from a previous week into pairs and have the chart use these numbers to come up with a pick 4 play. sample; last numbers were mid 6575 eve was 4523. pairs become 65-67-57-75. next 45-42-43-52-53-23. chart should come up with a pic 4 play for mid and eve. Help is appreciated. I used the previous week because in the past it seem to show many of the hits included in those numbers. hope someone can help.

    Here you go retxx

    http://www.box.net/shared/7f41vhsbn7fqm8lin1mo

    You will need a functional version of Excel for this to work.

    If you don't have MS Excel you can download OpenOffice.org FREE of course.

    http://download.openoffice.org/

    You would need to use the program called "Calc" which is similar to Excel but with limitations:

    http://www.openoffice.org/product/calc.html

     

    The Excel file might be usable in OpenOffice Calc if you don't have a fully functional version of Excel.

    I used Excel 2002 to create this file.

    You can't use any other program to open this but Excel or OpenOffice "Calc" program.

      SteveC's avatar - istockphoto 1955988-lottery-ball.jpg
      Cincinnati
      United States
      Member #105168
      January 26, 2011
      600 Posts
      Offline
      Posted: October 29, 2011, 6:03 pm - IP Logged

      need a chart to use to put in numbers from a previous week into pairs and have the chart use these numbers to come up with a pick 4 play. sample; last numbers were mid 6575 eve was 4523. pairs become 65-67-57-75. next 45-42-43-52-53-23. chart should come up with a pic 4 play for mid and eve. Help is appreciated. I used the previous week because in the past it seem to show many of the hits included in those numbers. hope someone can help.

      If you put the numbers in seperate columns

      =CONCATENATE(C463,D463) Colored numbers to be replaced

      6 in A1  5 in A2 7 in A3 and A4  then in an adjacent column or row use =concatenate(A1,A2) the next box =concatenate(A1,A3) and so on. You will get your pairs then copy, drag down and Paste the whole column.

        retxx's avatar - mrthumbs
        BOSTON
        United States
        Member #48
        September 9, 2001
        3611 Posts
        Offline
        Posted: October 29, 2011, 8:07 pm - IP Logged

        wow guys thanks so much. I will try using this.You might want to test it using your states numbers as i said. Go to the same day in the prior week using the mid and eve draws and see if it helps. let me know if it works for you? thanks again

          destined2bgr8's avatar - DiscoBallGlowing
          Germantown, MD
          United States
          Member #69235
          January 6, 2009
          141 Posts
          Offline
          Posted: October 29, 2011, 8:18 pm - IP Logged

          Can you please tell me how I can create a excel spreadsheet like this for MD. Thanks in advance for any help you may offer.

            retxx's avatar - mrthumbs
            BOSTON
            United States
            Member #48
            September 9, 2001
            3611 Posts
            Offline
            Posted: October 29, 2011, 8:35 pm - IP Logged

            I got that,great now can excel put these pairs into pic 4 playing pos with say the best combos of say 8 numbers to play. Hope i am not pushing winsum.

              winsumloosesum's avatar - Lottery-060.jpg
              Pennsylvania
              United States
              Member #2218
              September 1, 2003
              5396 Posts
              Offline
              Posted: October 29, 2011, 9:10 pm - IP Logged

              Can you please tell me how I can create a excel spreadsheet like this for MD. Thanks in advance for any help you may offer.

              Maryland Pick 4 Excel download link:

              http://www.box.net/shared/ki54jq8v48oektz0m66f

                winsumloosesum's avatar - Lottery-060.jpg
                Pennsylvania
                United States
                Member #2218
                September 1, 2003
                5396 Posts
                Offline
                Posted: October 29, 2011, 9:15 pm - IP Logged

                I got that,great now can excel put these pairs into pic 4 playing pos with say the best combos of say 8 numbers to play. Hope i am not pushing winsum.

                Not sure what your asking?

                Can you give an example?

                You said that we should take the previous week, same day results (pairs) and play them the following week.

                OK.  Saturday's Massachusettes Pick 4 Midday number for 10/29/2011 was: 4880

                The Pairs would be: 48, 48, 40, 88, 80, 80. 

                Would you play the pairs next Saturday Midday drawing 48, 40, 88, 80?

                How would play the combinations?

                  destined2bgr8's avatar - DiscoBallGlowing
                  Germantown, MD
                  United States
                  Member #69235
                  January 6, 2009
                  141 Posts
                  Offline
                  Posted: October 29, 2011, 9:41 pm - IP Logged

                  Maryland Pick 4 Excel download link:

                  http://www.box.net/shared/ki54jq8v48oektz0m66f

                  Wow Winsum, thanks so very much. I am new to excel and working at it to learn how to apply it.

                    retxx's avatar - mrthumbs
                    BOSTON
                    United States
                    Member #48
                    September 9, 2001
                    3611 Posts
                    Offline
                    Posted: October 30, 2011, 9:20 am - IP Logged

                    hi winsum. doubles are a poor example to use as they usually do not work so I would like it to mix the doubles as odd/even hi/lo and use it for both mid and eve.
                    Does this make sense? My theory shows in many cases 3 0f the 4  numbers show on the following week same day. maybe we are onto something.

                      retxx's avatar - mrthumbs
                      BOSTON
                      United States
                      Member #48
                      September 9, 2001
                      3611 Posts
                      Offline
                      Posted: October 30, 2011, 9:46 am - IP Logged

                      Just noticed another tip to try. Hope everyone is testing this theory.
                      Try this take the mirrors of the previous week mid and eve into the spreadsheet and come up with 8 pic 4 to play mix n match. Can this be done? I know you are very good at this. Maybe it will work in your state.

                        winsumloosesum's avatar - Lottery-060.jpg
                        Pennsylvania
                        United States
                        Member #2218
                        September 1, 2003
                        5396 Posts
                        Offline
                        Posted: October 30, 2011, 9:56 am - IP Logged

                        Let me know what mirrors numbers you want?

                        Are these the mirror numbers?

                        0 = 5

                        1 = 6

                        2 = 7

                        3 = 8

                        4 = 9

                          retxx's avatar - mrthumbs
                          BOSTON
                          United States
                          Member #48
                          September 9, 2001
                          3611 Posts
                          Offline
                          Posted: October 30, 2011, 10:07 am - IP Logged

                          right on the button.
                          Let me know how it works in your state? thanks for the help.

                            winsumloosesum's avatar - Lottery-060.jpg
                            Pennsylvania
                            United States
                            Member #2218
                            September 1, 2003
                            5396 Posts
                            Offline
                            Posted: October 30, 2011, 10:27 am - IP Logged

                            right on the button.
                            Let me know how it works in your state? thanks for the help.

                            Here is the download with the added mirror pairs:

                            http://www.box.net/shared/bi0u3f2ouyjc3t0zj4xa

                              retxx's avatar - mrthumbs
                              BOSTON
                              United States
                              Member #48
                              September 9, 2001
                              3611 Posts
                              Offline
                              Posted: October 30, 2011, 10:34 am - IP Logged

                              boy you are great master win.
                              Here are the mirrors from last sun mid and eve to try
                              9153 7937
                              think you can install a spreadsheet to pic 8 sets to play using the criteria i gave you/ thanks