Welcome Guest
Log In | Register )
You last visited December 8, 2016, 3:03 pm
All times shown are
Eastern Time (GMT-5:00)

only in spreadsheet...

Topic closed. Posted 8 years ago. No replies.

Page 1 of 1
PrintE-mailLink
sysp34's avatar - Lottery-062.jpg
Heroic City
Indonesia
Member #31689
February 2, 2006
1153 Posts
Offline
Posted: January 10, 2009, 6:44 pm - IP Logged

only in spreadsheet we can write horizontal skip LOL

BIG THANK TO CARBOB FOR THE FORMULA TO SKIP IN HORIZONTAL

 

OverallHITMAXSKIP23456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100
02892628111011239633432432310713152454514971531010331816323711139121122111273411594943314113812141159433871121161322496521626416
1281330211238537343218226213454581912519123131121533382114762334211924225516132118789228211132615581039525168623133317107
23042834761214365128918291326417333421185571212172333126232132233251817254598212663347713101692132231163564161281529239
3307292131113648121323516612105314216171041512311322472146297621921137523225244312742134241412461376313132121819294493718739
4318241161117331923272616210437131753112312101226648123141141224129103221262158221123159212242391104425612554114343132152
530125043768547843517923771055283134411224115152315227264102481312311525510311055114141039142512463211445671654551317366
62861941338314911619151538512717551011113121171229213521052611624443822584323447333311221231912131645191152524236387514
7323481-51465124123111136332118827439313355518323173211111351011252221487221225115724111151411271216511111125511741338548311
82892804106261062123333132783823111825422332541631923234231613112146347111028433541861138611525513613352133114821668
930224541121431361213131612826746541014121514153131386352111342121213332847121522724164666332611133121123125373743421531014
P1 = 1HITMAXSKIP23456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100
011052211411101143993515394823247132181254132097153111833221632715112223391611222118731111598134614144138283211594752881121161322496521626416
110348021124810257398191862272264545111910261231931916241533383232512673743112422772115139138148711927284011627131551110179825168623133317107
21014215429612343857289510210136214617354421188511621528433312620721322115251828427469388132362520162642241016212513523716351653131281529239
39144162951713688127152886661452515819217617134417125203833217711166291262192113724218222334143144209131424145286149831513372419372154         
4101949231271237538929101026162104347139171631110343331212615781894195210102241291083212621516731012315112121310239710441768121046462041343132152
59437556207681319782039479232017105153236224419224141715251721186841013378624121535152116103110751161410322202982742932720171156717158167      
69965713387149216314152032126167113126171436261211713139171354115391162241943832158472324109333311639121419421316451512215312122910363865523 
7113481211466124373191256333343388379202531335551831151163212111135105125322448911215101321287323211524112181217521139528511744731912108711
891611412626101638231137733114128873119161105122153211213241315195377423362733261214178471410314735111161414813131120236516812142151161         
9975420421254115126131311113613171567462841026121322340213151719675177254426112122438281371221537826141466633263035314912211457932143421513   
P2 = 5HITMAXSKIP23456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100
084522082434023291062234525323101431152472851412819104101031118272312371113111212821319212204616144936335241281712141119327331677                
187549161763235313214321925651322128198431145159125731012181321475421147142353142518924218519762125185189248211132623681531553             
291543147271719126512924185914326419143317391149547712721725546225123522673321221717254512824261533477133732921722414379256416         
31085523311859482813635117161210531414155381033151331132154182147297910235167105239435294922742194172317194111237637311721218195917493718739
496446161201213312023279199112114327132125141321312101521364161231411413443223616328152015368221439299292824219321331318256112955181163245    
510736015318123654121641951231422577139528313101071206231151159324522726141024813173116755116123516284218196914251216629211448151714654551317366
6102864719793116101116191241515859297755101611131451388622112207210162691821042041828587336114475897222239325121616211719151225242252262371314
71056419199511611123119131662521110252344394201198162452347631202931711135524616472315225115924111016151114712328671311111053713349131185411314
81154416510161711176212231327317278312242216825452123254106315132442376519124112996357111028535944863213861858515136133322133114821668
910536121011714313612124531141282182691851522141815141519131383136211137212413139331341113611112272415641415238173221113191213831273797512652031014
P3 = 8HITMAXSKIP23456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100
095522262434023291062234525323101431152472851412819104101031118272312371113111212821319212204616144936335241281712141119327331677                
1915413121763235313214321925651322128198431145159125731012181321475421147142353142518924218519762125185189248211132623681531553             
2112543147271719126512924185914326419143317391149547712721725546225123522673321221717254512824261533477133732921722414379256416         
31085541311859482813635117161210531414155381033151331132154182147297910235167105239435294922742194172317194111237637311721218195917493718739
4121441661201213312023279199112114327132125141321312101521364161231411413443223616328152015368221439299292824219321331318256112955181163245    
510036114318123654121641951231422577139528313101071206231151159324522726141024813173116755116123516284218196914251216629211448151714654551317366
685866519793116101116191241515859297755101611131451388622112207210162691821042041828587336114475897222239325121616211719151225242252262371314
71056415-5199511611123119131662521110252344394201198162452347631202931711135524616472315225115924111016151114712328671311111053713349131185411314
8834402110161711176212231327317278312242216825452123254106315132442376519124112996357111028535944863213861858515136133322133114821668
91003651711714313612124531141282182691851522141815141519131383136211137212413139331341113611112272415641415238173221113191213831273797512652031014

 

sumHITMAXSKIP23456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100
010584                                                                                                   
1532265322130111224                                                                                               
2726327821510591064263                                                                                             
310254189116469946122164254                                                                                          
41418622612018612100532933781264012258                                                                                      
520137310459141653145431375224872264748545141                                                                                
6222495572926521129182630603535191285924944166                                                                              
740831918872110221361045122112282192321210223274213417359833236019214044235                                                            
844971037115513926730301610115116331118872615126211411347174699725652127202114549                                                        
94310250118409726991096492327151463088282362383224182710261412732445171215123                                                         
1062564131813479545531742162951311681219253056114118167199615219308627371330213413022101129811189374111                                      
117067612864877830231323313874520226824191513411755441742242643193631462466101531417361428128153111327146755                              
126866132811121252824121576063835442030145615451373226117216651341028217811461454181331323411118452321784825                                
136612658308155472620345385136241691361178612019215556625172538142151133298541010101268211115126516419815                                  
148154095154122134715121615371041411412561415292471111127162499373322542178131133110211421311818998453332253192121464332411                   
157945165122161012191322408121763631915511887220231385962433143192213164536291781562818102624172721231112547147564284404102114                     
1676847333131912614171619832563241429182129518142159555171201431422120849191113511126633471031152231241710162117612209                        
17725011234820271027922149127213512122016942211338661036261523767318281713726362191428817405924947631153527619150                            
185999851335244115117611417125792641489583211882188233416699193333423101056112619109231153787                                         
19511231606122587288996415201299112291768428219412516127212341414714573912223723123130                                                 
2044155573255110155173972211636121212127162015456473471515232011282856492585325                                                        
211924512624548162545181915511653514293989647                                                                                 
22152352218523564688347113541018457270                                                                                     
2312243311097543531471181212351243                                                                                        
247209113154710020983162                                                                                             
2583075730727331364114532                                                                                            
2642552112552033                                                                                                
2710922                                                                                                   
sum groupHITMAXSKIP23456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100
00..06795321252773261610521113162141171183081867111924111255145717747571037635101113216714913811102613254510335351928221231811535                     
07..1339394243411763112213212111555141612211124113343252522231131431321112315412164524311413292144191216671321
14..2046290142112121141312213142312352311321311311113253141212115221411915322133521311413321161114112151314211
21..2766622218265151321235364431736322172016125112326992191441916279121124751341164110178144641533696111536227                                  
sum groupHITMAXSKIP23456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100
00..03231356512411646819414472237246714913885413522106                                                                             
04..079646211699873711102615110521176448214112512192616152124111253214327862121022771835352119213441333292110261313318553351718118340823135117546    
08..112191942471863138121125111151341777252723111221519136452432551119316611513324181515231748371531692815584110755974439
12..1529413094111413122138111142461123561732463672439111824148111414251041121123216131145251317152728232122711584162
16..192582316132342331032518121581415183429182213353311563115261314222821511115312151321772725114311321252133517272
20..23907557101813551821614754371729107213816432121111111225161127872318469161843511671815151211203836411421774101531719921258711827251027          
24..27201445756154736648927334218233417341281732144                                                                                

thank and good luck

Et erunt signa in sole.......Et luna et stellis.......Et presura gentium
Prae confusione sonitus maris.