Segments Graphic

[maroc]

Here an image of WNH segment column 0.
Position 1 at bottom Position 2 And Position 3 at top

[maroc]

Hi,

I have notice that some thing is wrong about my post.

I will correct it as soon as possible.

Sorry

Thank's

[maroc]

Hi Stan,

i have done an image from the Wn History for segment and another from package stats analyse after opnning the winning number as package.Ther is a
different value.Can you cheek please.
Thank you.

images attached

[stan]

[quote=maroc]
i have done an image from the Wn History for segment and another from package stats analyse after opnning the winning number as package.Ther is a
different value.Can you cheek please.
[/quote]

the package stats are always calculated against the very latest draw in your winning numbers database.
on the other hand stats in the wn history panel are calculated 'draw by draw' as if each draw was the latest one and then the next draw was added into the database.
therefore if the stats value is based on the winning numbers database (e.g. 'match prev x', wnh segments/sums) then the package stats for winning numbers loaded into the package will never match the statistics in the stats page and the wn history page.
ticket numbers statistics like odd/even, sum, high/low will be equal.

[sysp34]

hi stan

but how about a new stats page with a combo box where you would select the history column (0 to -10) and three tables showing occurrences, latest, skips etc for the count of numbers in each segment for the select wnh column?

is this features come with new version 886?

how about some plugins to retrieve appropriate WNH-Segments? for example last 365 draws

i mean some automatically steps

for example (FL 536)

* lastest WNH-Segments 10/06/95 10-11-15-17-18
* retrieve WNH-Segments for 10/09/95 05-10-18-22-23 and stored it
** repeat the step for next draw until lastest draw then exported into CSV.

unfortunately i can't write any programming language, well i hope any EL user able to create that plugins so we can optimize the WNH-Segments with appropriate hit and skip.

if any of EL user interested with new WNH-Segments see the attachment.

i hope one day on 2007 one of EL user able to CATCH the JACKPOT

good luck folk's

regards
sysp34

[Midas]

Maroc,

Having followed your system from conception to the present day. Systematically I've tried to replicate your results on the UK and French Lotto. The system jus does not work. So many enhancements... Very much like practising black magic?.

I think it's a matter of providing detailed help instructions; If you would be so kind to put all your ideas into one comprehensive document with better exemples, perhaps we all can finally hit the jackpot and retire like Alcymart!.

Regards

Midas

[maroc]

Hi Midas,

If you would be so kind to put all your ideas into one comprehensive document with better exemples

Can you please explains what can i do?

Thank you

[stan]

[quote=sysp34]
hi stan

but how about a new stats page with a combo box where you would select the history column (0 to -10) and three tables showing occurrences, latest, skips etc for the count of numbers in each segment for the select wnh column?

is this features come with new version 886?
[/quote]
i'll consider adding this to a new beta build (i don't know when that will happen though as the christmas are comming)

how about some plugins to retrieve appropriate WNH-Segments? for example last 365 draws

that's already available in the current beta version builds - go to wn history page, switch to the summary table and select segments in the show combo box

[Midas]

Yeah Maroc,

I looked again over my favorit histo and cheeked col by col against your system data, to make shure I understood, but still porobabilities don't work?.

Here attached submi comments towards your system. Would you look at the enteries and give better exemples with instructiones.

Thank you
Midas

[maroc]

Hi Midas,

Find attached answer to your question.Hope they right.

Thanks

[Da80th]

hi sysp34,

You seem to be an expert in Excel so I have a question for you.

I am looking for a formula that calculate ONLY the last # of cells in each column. For example, A1:A300 are data for WNH Seg for Col 0, and I only want to calculate the last 100 draws.

The basic way is to use =A200:A300 but when you add data on cell A301 then you have to update the formula to A201:A301.

Is there a way to calculate only the last 100 cells without updating the formula?


Thanks,


Da80th

[sysp34]

hi Da80th

i'm not an expert in excel just knew little bit formula

Is there a way to calculate only the last 100 cells without updating the formula?

actually i'm still looking that formula :vogel:

so far the best way is changing current draw into descending date?

then use this formula

to count hit =COUNTIF(H$1:H$102,T2)

to count skip =IF(ISERROR(MATCH($T2,H$1:H$102,0)-1)=TRUE,"",MATCH($T2,H$1:H$102,0)-1)

to add next draw just inserting cell range A2 to S2.

well i hope it helps, for further information see this site http://www.mrexcel.com/board2/viewforum.php?f=2 i hope one of the thread help you

regards
sysp34

[Joe]

[quote=sysp34:1166532317]
hi Joe, Stan and EL member

-------
for Joe
the spreadsheet applicable for any lotto when using WMH-Segments (3 Segments)

you need some step to do

1. Click on column G -> right click -> click insert (to add position 6)

2. transform 28 straight WNH-Segments pattern

0-1-5, 0-2-4, 0-4-2, 0-5-1, 1-0-5, 1-2-3, 1-3-2, 1-5-0, 2-0-4, 2-1-3, 2-3-1, 2-4-0, 3-1-2, 3-2-1, 4-0-2, 4-2-0, 5-0-1, 5-1-0
0-0-6, 0-3-3, 0-6-0, 1-1-4, 1-4-1, 3-0-3, 3-3-0, 4-1-1, 6-0-0
2-2-2

into one column then block Column S3 to S30 and change the format cell into text then copy transformed WHN-Segments into cell S3 then for each History (W3,Z3,AC3,AF3,AI3,AL3,AO3,AR3,AU3,AX3BA3).

about primitive wnh_rng you may change the WNH-Segments pattern using the most occurence.

[/quote]



Hi Ragwi

Thanks for your updated excel sheet for my lotto

Im woking with your excel sheet, I have updated my past results (6/49) as u explained above.

Plz explain the functions in wnh_rng. I couldn't understand it

Plz explain in detail.

I have Updated the WNH-Segments pattern using the most occurence, the changes are only in the first line (0 to -10) column, not in below line. Is there any updation needed for column?

Regards

Joe

[sysp34]

[quote=Joe:1168258951]
Hi Ragwi

Thanks for your updated excel sheet for my lotto

Im woking with your excel sheet, I have updated my past results (6/49) as u explained above.

Plz explain the functions in wnh_rng. I couldn't understand it

Plz explain in detail.

I have Updated the WNH-Segments pattern using the most occurence, the changes are only in the first line (0 to -10) column, not in below line. Is there any updation needed for column?

Regards

Joe
[/quote]

Joe about primitive wnh_rng you may change cell reference for the most hit 3 number group because pick 6 had 28 patterns while pick 5 had 21 patterns and in that xl i use only 11 patterns which is the most hit for FL 5-36.

i hope it help

regards
sysp34

[Joe]

ok thanks ragwi,

I jus work it again and get back to you