Need an excel formula

Reply #12

winsumloosesum — Thu, 05 Feb 2015 13:09:41 GMT

Updated the Draws.xlsm Excel file to include color formatting of longest out skips by 1st digit and 2nd digit positions for the 1st draw pair, 2nd draw pair, and 3rd draw pair.

For tonight's 9pm drawing you might want to consider these selections:

1st Pair Drawing - 81,82,87,61,62,67,21,22,27

2nd Pair Drawing - 91,92,97,71,72,77,51,52,57

3rd Pair Drawing - 61,62,67,21,22,27,41,42,47

Reply #11

chivirico — Tue, 03 Feb 2015 00:07:28 GMT

so far is looking good i have played some bucks and get at least same amount back, easy to win one single ( xx ) number, hard to get 2 ( xx-xx ) impossible (xx-xx-xx ) but i ll keep trying, so i can share some cash with you, the bad part is to invest $$ lot extra to get the big hit, right now I'm trying to learn how long is been since xx number has not come out on Skips D1-D2-D3, but if i understand the Skips on the side numbers says, that those numbers was the longest ( days ) time xx number to... [ More ]

Reply #10

winsumloosesum — Sat, 31 Jan 2015 10:29:54 GMT

Added Jan 30 2015 drawing and corrected the Odd/Even formula columns in the Draws.xlsm file

https://app.box.com/s/qxp4ygohb3uym5lrx1qor0223recspi2

Reply #9

winsumloosesum — Fri, 30 Jan 2015 23:56:35 GMT

One thing I see that you have 6 consecutive Even numbers (00 through 99) for the 1st pick.

Reply #8

winsumloosesum — Fri, 30 Jan 2015 23:45:09 GMT

If you take for example last nights drawing:

1/29/15

15 84 57

Take the 1st number 15 and Position 1 or P1 would be 1 and Position 2 or P2 would be 5

In cell range X5:X14 are the current skips for each or the P1 and P2 digits #0 through #9

Cell X14 the digit 9 is currently out 30 draws Cell Y13 the digit 8 is out 28 draws.

In cell range AG5 through AH14 are the Minimum skips for each of the Positional digits.

For example in cell AG7 you should see a 12 indicating that it's be... [ More ]

Reply #7

LifesAGamble — Fri, 30 Jan 2015 14:36:16 GMT

This is to Bob in Michigan who sent me a pm......

for some reason, it appears that I can't send you an answer..... it looks like LP wants me to sign up for a paid subscription, which I'm not ready to do right now.

Would you please email your question to me again at KvWllms61 at gmail (can't put the link, I could get banned).

However, I won't be able to answer you today as I won't be home until tomorrow

Reply #6

chivirico — Thu, 29 Jan 2015 00:23:57 GMT

you are a master that High/Low columns are awesome, now it can tell me exactly what the best options to play and how they may come out, after one of those number come out to follow, as they don't use computer to draws the games, this is maybe a simple way to get it one day, about the new drawlrx what are the P1 P2 MINIMUM stand for ? about the yellow numbers.

thanks.

Reply #5

winsumloosesum — Wed, 28 Jan 2015 08:59:16 GMT

I updated the Draws.xlsm Excel file with last nights drawing.

Also added columns that include High/Low, Odd/Even, and Positional Skips for Front Back digits.

Use the same download link:

https://app.box.com/s/qxp4ygohb3uym5lrx1qor0223recspi2

Reply #4

chivirico — Wed, 28 Jan 2015 01:43:09 GMT

Yes got it thanks a lot you did a great job i will PM you shortly

Reply #3

winsumloosesum — Wed, 28 Jan 2015 00:10:11 GMT

Create a new folder and name it whatever you want. e.g. LoteriaNacional

Download the following 2 Excel files and place them in the new folder created above

https://app.box.com/s/qxp4ygohb3uym5lrx1qor0223recspi2

https://app.box.com/s/594hk6ti005ur704k7bn0hvu0vh8jw55

1. Open the Excel file Draws.xlsm

At the bottom you should see 3 Tabs. Draws, Totals, and DrawHistory9PM

Click the tab labeled Draws

In this worksheet you will update your draws. This is only if you need to... [ More ]

Reply #2

LifesAGamble — Tue, 27 Jan 2015 21:43:46 GMT

if you can arrange your data into a single column,

for example 17 52 76 would be listed

17

52

76

and so on........

then you could use the following formulas:

column C2 list each number that has appeared

column E2 list every number from 1 to 99

cell F2 enter =COUNTIF($C$2:$C$34,E2)

cell G2 enter =VALUE((COUNTIF($F$2:F2,F2)-1)*0.0001+F2)

cell I2 enter =LARGE($G$2:$G$101,ROW(A1))

cell J2 enter =INDEX($E$2:$E$101,MATCH(I2,$G$2:$G$101,0))

cell K2 enter =IF(I2... [ More ]

Reply #1

dominicanbeauty — Tue, 27 Jan 2015 20:25:08 GMT

Hi, this sounds interesting, hope somebody can help you with your request. Good Luck

Interesante tema

Need an excel formula

chivirico — Tue, 27 Jan 2015 20:01:46 GMT

hello friends, I need an excel formula that can tell me the hot numbers most drawn numbers less numbers cold numbers how many times they have come out etc, these numbers are not your regular pick 3 game here in the usa, this is for a quiniela numbers in Latin America, this are double digits pick 3 numbers example 14-65-32 this are called quiniella game a kind of Spanish game pick 3, these numbers are from 1 to 100 ( NOT 0 TO 9 )and if you cant do this from 1 to 100 it can be from 0 to 99 instead... [ More ]