Welcome Guest
Log In | Register )
You last visited December 11, 2016, 4:50 am
All times shown are
Eastern Time (GMT-5:00)

Can someone give me a formula?

Topic closed. 7 replies. Last post 7 years ago by LottoMining.

Page 1 of 1
PrintE-mailLink
Avatar
New Member
North Easton, Ma
United States
Member #76392
June 26, 2009
3 Posts
Offline
Posted: June 30, 2009, 9:13 am - IP Logged

Hi,

How can I figure out how many 4 digit combinations can be made from 5 digits.

Then, how do I actually GET these combinations? ( I want to put them through a filter, of course.)

Any help is appreciated.

    Avatar
    New Mexico
    United States
    Member #58526
    February 18, 2008
    683 Posts
    Offline
    Posted: June 30, 2009, 9:50 am - IP Logged

    ABCDE

    =

    ABCD

    ABCE

    ACDE

    BCDE

      CARBOB's avatar - FL LOTTERY_LOGO.png
      ORLANDO, FLORIDA
      United States
      Member #4924
      June 3, 2004
      5913 Posts
      Offline
      Posted: June 30, 2009, 9:51 am - IP Logged

      Hi,

      How can I figure out how many 4 digit combinations can be made from 5 digits.

      Then, how do I actually GET these combinations? ( I want to put them through a filter, of course.)

      Any help is appreciated.

      You need to go back to your original post, here. http://www.lotterypost.com/thread/196264

      Then download the software. Then you will be able to do this. Just an example using any 5 digits.

      0123, 0124, 0132, 0134, 0142, 0143, 0213, 0214, 0231, 0234, 0241, 0243, 0312, 0314, 0321, 0324, 0341, 0342, 0412, 0413, 0421, 0423, 0431, 0432, 1023, 1024, 1032, 1034, 1042, 1043, 1203, 1204, 1230, 1234, 1240, 1243, 1302, 1304, 1320, 1324, 1340, 1342, 1402, 1403, 1420, 1423, 1430, 1432, 2013, 2014, 2031, 2034, 2041, 2043, 2103, 2104, 2130, 2134, 2140, 2143, 2301, 2304, 2310, 2314, 2340, 2341, 2401, 2403, 2410, 2413, 2430, 2431, 3012, 3014, 3021, 3024, 3041, 3042, 3102, 3104, 3120, 3124, 3140, 3142, 3201, 3204, 3210, 3214, 3240, 3241, 3401, 3402, 3410, 3412, 3420, 3421, 4012, 4013, 4021, 4023, 4031, 4032, 4102, 4103, 4120, 4123, 4130, 4132, 4201, 4203, 4210, 4213, 4230, 4231, 4301, 4302, 4310, 4312, 4320, 4321
      0012, 0013, 0014, 0021, 0023, 0024, 0031, 0032, 0034, 0041, 0042, 0043, 0102, 0103, 0104, 0112, 0113, 0114, 0120, 0121, 0122, 0130, 0131, 0133, 0140, 0141, 0144, 0201, 0203, 0204, 0210, 0211, 0212, 0221, 0223, 0224, 0230, 0232, 0233, 0240, 0242, 0244, 0301, 0302, 0304, 0310, 0311, 0313, 0320, 0322, 0323, 0331, 0332, 0334, 0340, 0343, 0344, 0401, 0402, 0403, 0410, 0411, 0414, 0420, 0422, 0424, 0430, 0433, 0434, 0441, 0442, 0443, 1002, 1003, 1004, 1012, 1013, 1014, 1020, 1021, 1022, 1030, 1031, 1033, 1040, 1041, 1044, 1102, 1103, 1104, 1120, 1123, 1124, 1130, 1132, 1134, 1140, 1142, 1143, 1200, 1201, 1202, 1210, 1213, 1214, 1220, 1223, 1224, 1231, 1232, 1233, 1241, 1242, 1244, 1300, 1301, 1303, 1310, 1312, 1314, 1321, 1322, 1323, 1330, 1332, 1334, 1341, 1343, 1344, 1400, 1401, 1404, 1410, 1412, 1413, 1421, 1422, 1424, 1431, 1433, 1434, 1440, 1442, 1443, 2001, 2003, 2004, 2010, 2011, 2012, 2021, 2023, 2024, 2030, 2032, 2033, 2040, 2042, 2044, 2100, 2101, 2102, 2110, 2113, 2114, 2120, 2123, 2124, 2131, 2132, 2133, 2141, 2142, 2144, 2201, 2203, 2204, 2210, 2213, 2214, 2230, 2231, 2234, 2240, 2241, 2243, 2300, 2302, 2303, 2311, 2312, 2313, 2320, 2321, 2324, 2330, 2331, 2334, 2342, 2343, 2344, 2400, 2402, 2404, 2411, 2412, 2414, 2420, 2421, 2423, 2432, 2433, 2434, 2440, 2441, 2443, 3001, 3002, 3004, 3010, 3011, 3013, 3020, 3022, 3023, 3031, 3032, 3034, 3040, 3043, 3044, 3100, 3101, 3103, 3110, 3112, 3114, 3121, 3122, 3123, 3130, 3132, 3134, 3141, 3143, 3144, 3200, 3202, 3203, 3211, 3212, 3213, 3220, 3221, 3224, 3230, 3231, 3234, 3242, 3243, 3244, 3301, 3302, 3304, 3310, 3312, 3314, 3320, 3321, 3324, 3340, 3341, 3342, 3400, 3403, 3404, 3411, 3413, 3414, 3422, 3423, 3424, 3430, 3431, 3432, 3440, 3441, 3442, 4001, 4002, 4003, 4010, 4011, 4014, 4020, 4022, 4024, 4030, 4033, 4034, 4041, 4042, 4043, 4100, 4101, 4104, 4110, 4112, 4113, 4121, 4122, 4124, 4131, 4133, 4134, 4140, 4142, 4143, 4200, 4202, 4204, 4211, 4212, 4214, 4220, 4221, 4223, 4232, 4233, 4234, 4240, 4241, 4243, 4300, 4303, 4304, 4311, 4313, 4314, 4322, 4323, 4324, 4330, 4331, 4332, 4340, 4341, 4342, 4401, 4402, 4403, 4410, 4412, 4413, 4420, 4421, 4423, 4430, 4431, 4432
      0001, 0002, 0003, 0004, 0010, 0020, 0030, 0040, 0100, 0111, 0200, 0222, 0300, 0333, 0400, 0444, 1000, 1011, 1101, 1110, 1112, 1113, 1114, 1121, 1131, 1141, 1211, 1222, 1311, 1333, 1411, 1444, 2000, 2022, 2111, 2122, 2202, 2212, 2220, 2221, 2223, 2224, 2232, 2242, 2322, 2333, 2422, 2444, 3000, 3033, 3111, 3133, 3222, 3233, 3303, 3313, 3323, 3330, 3331, 3332, 3334, 3343, 3433, 3444, 4000, 4044, 4111, 4144, 4222, 4244, 4333, 4344, 4404, 4414, 4424, 4434, 4440, 4441, 4442, 4443
      0011, 0022, 0033, 0044, 0101, 0110, 0202, 0220, 0303, 0330, 0404, 0440, 1001, 1010, 1100, 1122, 1133, 1144, 1212, 1221, 1313, 1331, 1414, 1441, 2002, 2020, 2112, 2121, 2200, 2211, 2233, 2244, 2323, 2332, 2424, 2442, 3003, 3030, 3113, 3131, 3223, 3232, 3300, 3311, 3322, 3344, 3434, 3443, 4004, 4040, 4114, 4141, 4224, 4242, 4334, 4343, 4400, 4411, 4422, 4433
      0000, 1111, 2222, 3333, 4444

        johnph77's avatar - avatar
        CA
        United States
        Member #2987
        December 10, 2003
        832 Posts
        Offline
        Posted: June 30, 2009, 11:35 am - IP Logged

        I just did an Excel chart similar to this but for Pick 3. Pick 4 would be 10 times as large, of course. I presently have no plans to work on something like this, as 10,000 cells would have to be individually formatted. But:

        There are 625 4-digit combinations that can be formed using 4 digits from the first 5-digit group. This includes doubles, triples and quads.
        There are 2,500 4-digit combinations that can be formed using 3 digits from the first 5-digit group and 1 digit from the second 5-digit group. This includes doubles and triples.
        There are 3,750 4-digit combinations that can be formed using 2 digits from the first 5-digit group and 2 digits from the second 5-digit group. This includes doubles and combinations where there are two sets of doubles.
        There are 2,500 4-digit combinations that can be formed using 1 digit from the first 5-digit group and 3 digits from the second 5-digit group. This includes doubles and triples.
        There are 625 4-digit combinations that can be formed using 4 digits from the second 5-digit group. This includes doubles, triples and quads.

        The Excel output would have to be text to allow the first digit in an individual cell to be a zero. The finished chart would have 400 rows and 25 columns, 200 rows and 50 columns, or 100 rows and 100 columns, depending on preference.

        There are several ways to display the results; my personal preference is to use a formula that can be copied, then easily edited to cover all the possibilities.

        Assuming the initial 5-digit group is posted in Cell A1, the first cell in which output is desired would have the formula =MID(A1,1,1)&MID(A1,1,1)&MID(A1,1,1)&MID(A1,1,1). This formula yields a quad consisting of the first number in the first 5-digit group. Note that MID is used for all output, not LEFT or RIGHT - this allows for easier editing of the copied formula to other cells. If I were continuing, the cell immediately to the right of the first output cell would have the formula =MID(A1,1,1)&MID(A1,1,1)&MID(A1,1,1)&MID(A1,2,1). This would yield a triple, consisting of the first number in the first 5-digit group three times and the second number in the first 5-digit group once.

        Hope you get the idea.

        gl

        j

        Blessed Saint Leibowitz, keep 'em dreamin' down there..... 

        Next week's convention for Psychics and Prognosticators has been cancelled due to unforeseen circumstances.

         =^.^=

          Avatar
          Kentucky
          United States
          Member #32652
          February 14, 2006
          7325 Posts
          Offline
          Posted: July 1, 2009, 9:43 am - IP Logged

          Hi,

          How can I figure out how many 4 digit combinations can be made from 5 digits.

          Then, how do I actually GET these combinations? ( I want to put them through a filter, of course.)

          Any help is appreciated.

          I believe it's called factoring when any of 5 digits can appear in any of the four positions. To get the total number of combinations you multiple 5 (first position) times 5 (second) times 5 (third) times 5 ( fourth) equals 625. If you're using the digits 1-2-3-4-5 it would look like (1-2-3-4-5) with (1-2-3-4-5) with (1-2-3-4-5) with (1-2-3-4-5).

          You'll probably need a program that generates all 625 combinations and allows you to apply filters.

            Avatar
            NY
            United States
            Member #23835
            October 16, 2005
            3475 Posts
            Offline
            Posted: July 21, 2009, 3:42 pm - IP Logged

            Perhaps you're thinking of factorials (n!), which are a number multiplied by each whole number that is less than that number and greater than zero. For 5 it's 5*4*3*2*1, which is 120. There are 120 permutations for 5 numbers if you use all 5 of them. In a permutation the order of the numbers matters.  For combinations, OTOH, the order doesn't matter. 1,2,3,4,5 and 5,4,3,2,1 are different permutations, but represent irrelevant variations of the same combination. The formulas for permutations and combinations start with the factorial of the full set of numbers, which is then reduced based on how many of the numbers are being used, and whether you want the number of permutations or combinations.

            For 4 of 5 it's 5! / (4! * (5-4)! ), which simplifies to 5! /  ( 4! * 1 )  -->  5! / 4!  = 5.

            The list above omitted  the 5th combination of ABDE.

              RJOh's avatar - chipmunk
              mid-Ohio
              United States
              Member #9
              March 24, 2001
              19831 Posts
              Offline
              Posted: July 21, 2009, 7:49 pm - IP Logged

              Hi,

              How can I figure out how many 4 digit combinations can be made from 5 digits.

              Then, how do I actually GET these combinations? ( I want to put them through a filter, of course.)

              Any help is appreciated.

              You can down load a free program from LottoLogix called "Maybelle QuickWheel" that will calculate that it's 625 combinations and print them out for you.

               * you don't need to buy more tickets, just buy a winning ticket * 
                 
                           Evil Looking       

                LottoMining's avatar - lightbulb
                California
                United States
                Member #48843
                January 11, 2007
                27 Posts
                Offline
                Posted: July 23, 2009, 12:32 am - IP Logged

                If you had a database program such as MS Access, you could create a table named tblRnd1 with a single field named Num of data type number (though data type of text works too). Then populate your table with the five digits.

                This query right below outputs the 625 records / combos (assuming you named the table as listed above and populated it):

                SELECT tblRnd1.Num, tblRnd1_1.Num, tblRnd1_2.Num, tblRnd1_3.Num

                FROM tblRnd1,

                tblRnd1 AS tblRnd1_1,

                tblRnd1 AS tblRnd1_2,

                tblRnd1 AS tblRnd1_3;

                 

                 

                (note: copy/paste the above in a new query in "SQL View", which is found on the pull down menu)

                You could save the above as a stored query and then query it with all your filters.