roger1318 Posted September 3, 2015 Share Posted September 3, 2015 Ola, Segue as somas para Mega Sena. Neste ultimo sorteio tivemos 20 dezenas nas três somas 01, 03 e 08 Anexo esta como podemos separar e contar suas saídas. Uma copia do modelo do forum Tranquilo, http://jogos-previsoes.forumeiros.net/t3626-euromilhoes-semana-070-2015-terca-feira-estatisticas-e-prognosticos SorteRoger1318!! Quote Link to comment Share on other sites More sharing options...
DixieJoe Posted September 3, 2015 Share Posted September 3, 2015 roger1318, Entrei nesse site mas não consegui encontrar explicação de como entender ou usar essas somas. Você entendeu? O que significa e como chegar nessas somas? obrigado Quote Link to comment Share on other sites More sharing options...
sorel Posted September 3, 2015 Share Posted September 3, 2015 olá grande roger1318, tem comos estas soma criar um grafico da curva do sino( guass) para ver a faixa central das somas de maior incidencia? comoelas as somas podem dar indicios de alguma padrao preventivo? qual a referencia obase do inicio e fim da soma afim de nao andar em circulos dos parametros da soma. somas separadas por posiçao na vertical sibindo do ultimo até um intervalo de sorteios? soma e frequencia por posiçao separada parece se mais promissor que as 6 posiçoes juntasbom minha opiniao de soma com refencia se podeia somar que nao sai de 01 a dezena inicial do teste exempl 08 e da dezena final a 60 estes dois intervalos que nao saem ficam ausentes seria duas somas incial e final exemplo teste 12,15,25,36,45,56= soma inicial de 01 a 12 deu 11 e soma final deu 4 que é 56-60= 4 seria soma ous diferença melhor falando asim temos uma referencia de soma e até defenindo a dezena inicial e final as 4 restante ficam dentro delas Quote Link to comment Share on other sites More sharing options...
roger1318 Posted September 3, 2015 Author Share Posted September 3, 2015 Ola, DixieJoe,agora que vou começar a tentar entender estes números "gigantes", eles são irregulares nos anos de 1996 até hoje. Apenas coloquei o que vi la no forum e achei interessante as saídas de ano a ano, agora o que eu notei pelo menos nos dois últimos sorteios é que saíram em 3 somas, isto podemos usar para exclusão. Uma das linhas é ver qual soma esta em atraso (não importa a dezena e sim o grupo) e qual das somas tem mais saídas.O que significa: (também não sei)Como chegar nestas somas: Igual as somas da Lotomania (se é que entendi sua pergunta) Sorel,Voce é mestre em busca de novos caminhos para os números, mas acredito que da para fazer sim, a curva do sino eu não sei fazer. Estas somas que voce se refere é a distancia entre os números e a dezena 01 e 60 são juntas sem distancia fazendo um circulo (360º), estes seriam mais dados a fazer em um possível estudo mais detalhado. SorteRoger1318!! Quote Link to comment Share on other sites More sharing options...
sorel Posted September 3, 2015 Share Posted September 3, 2015 ok roger, o problema da soma é nao temos um norte( um ponto de partida ou central ou referencia ou base fixa. entende pois a muitas variantes para um unico evento, poderia ser somas so das pares ( dezenas) e so das impares já é referencia mas localiza por posiçao exemplo se adotar 4/2 par/impar entao em 2 por seis é 15 posiçoes1,2 1,3.... até 5,6= 15 duas dias assim voce localiza as somas, ou ao menos a dezana inicial da soma Quote Link to comment Share on other sites More sharing options...
sorel Posted September 4, 2015 Share Posted September 4, 2015 roger, voce domina o excel é trocal de 49/6 para a nossa mega sena 60,/6consegue por na planilia excel 2010?Interesting information but you might prefer the sum of each possibility (from 21 to 279).The following macro in VBA for Excel will generate a list of the number of combinations for all sums:Option ExplicitOption Base 1Dim A As Integer, B As Integer, C As Integer, D As Integer, E As Integer, F As IntegerDim I As Integer, nSum(279) As LongSub SumAll()Application.ScreenUpdating = FalseSheets("Sheet1").SelectRange("A2").SelectRange("A1").Value = "Sum"Range("B1").Value = "# comb."For I = 21 To 279nSum(I) = 0Next IFor A = 1 To 44For B = A + 1 To 45For C = B + 1 To 46For D = C + 1 To 47For E = D + 1 To 48For F = E + 1 To 49nSum(A + B + C + D + E + F) = nSum(A + B + C + D + E + F) + 1Next FNext ENext DNext CNext BNext AFor I = 21 To 279ActiveCell.Value = IActiveCell.Offset(0, 1).Value = nSum(I)ActiveCell.Offset(1, 0).SelectNext IApplication.ScreenUpdating = FalseRange("A1").SelectEnd SubThen if you graph all this data, you will have a nice bell-shape curve for the number of combinations for each sum of 6 numbers for a 6/49 lotteriy. Quote Link to comment Share on other sites More sharing options...
sorel Posted September 4, 2015 Share Posted September 4, 2015 roger te vira no INGLESny lotto sum frequency diagram tends to look like a bell shapedcurve.But it is not a perfect normal curve, often called "the bellcurve". The difference is especially evident at the mean peakvalue,which is truncated or flatened.. The 5/55 lotto part ofPowerball and the UK 6/49 game may serve as a test. The frequency data for a complete set of the sums of all possiblecombinations of any lotto, n/N, can be found on the internet, just askRP, or at university libraries. In the case of PB the sums range from 15 to 265 with a symmetricaldistribution around the mean 140. Thus there are 250 distinct sums,but it is sufficient to to plot the frequencies of every 5th sum. The very peak value 140 has a frequency of 39361 and at 135 and 145it is 39001 while at 130 and 150 it is 37917 and for 125 and 155 itis 36176.Thus the peak from 135 to 145 is rounded off. But how can itbe determine that the the total curve is not a perfect normal curve?This must be based on the fundamental characteristics of the Gaussiancurve function, which can be found in any good text book onstatistics. Certain criteria must be met, such as: First, a plot of the percent cumulative frequencies on a standardarithmetic probability graph paper must yield a perfect straight line. Second, there should be a distinct inflexion point at one std.dev..where the curveature changes from convex to concave as determined bythe tangent to the curve. Third, the peak value can be used to calculate the std.dev. Fourth, three s.d. deviations from the mean must cover exactly99.73%of all data and two s.d must cover must cover 95.44% and one s.d willcover only 68.26%. The sum frequency data for 5/55 meet none of these criteria exactlybut approach them , which is best illustrated with the std.dev. The formula for the normal,Gaussian, curve shows that the peak valuemust be equal to 40% of the Total divided by the std.dev. For 5/55 itwould be 0.4x3478761/39361=35.255. But the actual s.d. based on everyfive sum from 20 to 260 is only 34.157. This value could be predictedwith the formula s.d.=square root of (N+1)(N-n)n/12, which yields34.1565 for 5/55. Thus 3 s.d would be 102.5 and the cumulative frequencies for the sumsless than 38 is only 1603, but shouldbe0.5x(100-99.73)x3.48x10^6=4696. An identical analysis for the 6/49 game will be posted elsewhere. All or some of the above discussion might have appeared here or someother place but would be new to recent readers. It must be well knownand understood by those versed in the mathematics of lotto,with anotable exception for johnph77, who insists that the std.dev. must be14143, a clearly preposterous value, that any half smart highschoolstudent of Statistics 101 would be able to see as absurd ,because thes.d. must be about 1/6 to 1/8th of the range 250(265-15). Robert Perkis feel free to to use this poster with revisions as anarticle at Lotto-Logix. Quote Link to comment Share on other sites More sharing options...
sorel Posted September 4, 2015 Share Posted September 4, 2015 taduçao meia boca, mas, mas né Freqüências soma Lotto e a curva do sino por Stig HolmquistQualquer diagrama frequência soma lotto tende a olhar como uma forma de sinocurve.But não é uma curva normal perfeito, muitas vezes chamado de "o sinocurva". A diferença é particularmente evidente na média do pico devalor, que é truncado ou flatened .. A parte 5/55 lotto dePowerball eo jogo UK 6/49 pode servir como um teste.Os dados de frequência para um conjunto completo de as somas de todas as possíveiscombinações de qualquer loteria, n / N, pode ser encontrado na internet, basta perguntarRP, ou nas bibliotecas universitárias.No caso de OP as somas variam desde 15 a 265, com uma estrutura simétricade distribuição em torno da média 140. Assim, existem 250 somas distintas,mas é suficiente para traçar as frequências de cada soma 5a.O valor muito pico 140 tem uma frequência de 39.361 e em 135 e 145é 39001, enquanto a 130 e 150 é 37917 e para 125 e 155 queé 36176.Thus o pico 135-145 é arredondada. Mas como podeser determinar que a curva total não é uma curva normal perfeito?Isso deve ser com base nas características fundamentais da Gaussianfunção curva, que pode ser encontrado em qualquer livro texto bom emestatísticas. Alguns critérios devem ser atendidos, tais como:Primeiro, uma representação da percentagem frequências cumulativas em um padrãopapel de gráfico probabilidade aritmética deve produzir uma linha reta perfeita.Em segundo lugar, deve haver um ponto de inflexão distinta de uma só std.dev..onde As mudanças de curveature convexa para côncava, tal como determinado pora tangente à curva.Em terceiro lugar, o valor de pico pode ser utilizada para calcular o std.dev.Em quarto lugar, três desvios DP da média deve cobrir exactly99.73%de todos os dados e dois sd deve cobrir deve cobrir 95,44% e uma sd vaiabranger apenas 68,26%.Os dados de frequência soma para 5/55 encontram nenhum destes critériosexatamente, mas abordá-los, o que é melhor ilustrado com o std.dev.A fórmula para o, Gaussian, curva normal mostra que o valor de pico deve ser igual a 40% do total dividido pelo std.dev. Para 5/55 queseria 0.4x3478761 / 39.361 = 35,255. Mas o sd real com base em cadacinco soma 20-260 é de apenas 34,157. Este valor poderia ser previstocom a fórmula dp = raiz quadrada de (N + 1) (NN) n / 12, o que produz34,1565 para 5/55.Assim 3 sd seria 102,5 e as freqüências cumulativas para os montantesinferiores a 38 é de apenas 1,603, mas devebe0.5x (100-99,73) x3.48x10 ^ 6 = 4696.Uma análise idêntica para o jogo 6/49 será postado em outro lugar.Todos ou alguns a discussão acima poderia ter aparecido aqui ou algumoutro lugar, mas seria nova para os leitores recentes. Deve ser bem conhecidoe compreendido por aqueles versados na matemática da loteria, com umanotável exceção para johnph77, que insiste que o std.dev. deve ser14143, um valor claramente absurda, que qualquer colégio metade espertoestudante de Estatística 101 seria capaz de ver como um absurdo, porque osd deve ser de cerca de 1/6 a 1/8 da gama 250 (265-15).Robert Perkis sinta-se livre para usar este cartaz com as revisões como umartigo em Lotto-Logix.Stig Holmquist Quote Link to comment Share on other sites More sharing options...
sorel Posted September 4, 2015 Share Posted September 4, 2015 roger 1318 em matewria de conseguir uma referancia poderia ser isto=Você vai precisar de terceiro grau matemática para obter um ponto de referência.Adicionar a menor soma ..... 21Para a maior soma ..... 3451 + 5 = 62 + 4 = 6trazer a 3 para baixo.Isto equivale a 366Divida 366 por 2 (dois, porque você adicionou dois números) que equivale a 183. Método alternativo ....Adicionar a soma de todas as 50,063,860 conjuntos e dividir por 50.063.860. Se você fazê-lo desta forma, você pode traçar-los enquanto você trabalha.Sua escolha. Quote Link to comment Share on other sites More sharing options...
sorel Posted September 4, 2015 Share Posted September 4, 2015 opa opa apos muita luta achei o graficodas somasROGER COMO PODEMOS MANIPULAR ISTO-Jogo Facil ©VF.Maziero, 1999-2010Modulo de Analise de jogos para MEGASENAData: 03/09/2015 23:35:13Analise de jogos por SOMATORIA DAS DEZENAS Somatoria: 0066 => Qtde: 001 >##Somatoria: 0072 => Qtde: 001 >##Somatoria: 0073 => Qtde: 001 >##Somatoria: 0077 => Qtde: 001 >##Somatoria: 0079 => Qtde: 001 >##Somatoria: 0080 => Qtde: 001 >##Somatoria: 0081 => Qtde: 001 >##Somatoria: 0083 => Qtde: 001 >##Somatoria: 0085 => Qtde: 001 >##Somatoria: 0086 => Qtde: 002 >####Somatoria: 0087 => Qtde: 001 >##Somatoria: 0088 => Qtde: 002 >####Somatoria: 0089 => Qtde: 001 >##Somatoria: 0090 => Qtde: 002 >####Somatoria: 0091 => Qtde: 001 >##Somatoria: 0092 => Qtde: 001 >##Somatoria: 0093 => Qtde: 001 >##Somatoria: 0094 => Qtde: 002 >####Somatoria: 0096 => Qtde: 002 >####Somatoria: 0097 => Qtde: 001 >##Somatoria: 0098 => Qtde: 001 >##Somatoria: 0100 => Qtde: 004 >########Somatoria: 0102 => Qtde: 001 >##Somatoria: 0103 => Qtde: 001 >##Somatoria: 0104 => Qtde: 003 >######Somatoria: 0105 => Qtde: 002 >####Somatoria: 0106 => Qtde: 001 >##Somatoria: 0107 => Qtde: 006 >############Somatoria: 0108 => Qtde: 004 >########Somatoria: 0109 => Qtde: 003 >######Somatoria: 0110 => Qtde: 006 >############Somatoria: 0111 => Qtde: 004 >########Somatoria: 0112 => Qtde: 002 >####Somatoria: 0113 => Qtde: 002 >####Somatoria: 0114 => Qtde: 005 >##########Somatoria: 0115 => Qtde: 005 >##########Somatoria: 0116 => Qtde: 005 >##########Somatoria: 0117 => Qtde: 006 >############Somatoria: 0118 => Qtde: 006 >############Somatoria: 0119 => Qtde: 007 >##############Somatoria: 0120 => Qtde: 007 >##############Somatoria: 0121 => Qtde: 008 >################Somatoria: 0122 => Qtde: 005 >##########Somatoria: 0123 => Qtde: 006 >############Somatoria: 0124 => Qtde: 005 >##########Somatoria: 0125 => Qtde: 004 >########Somatoria: 0126 => Qtde: 007 >##############Somatoria: 0127 => Qtde: 005 >##########Somatoria: 0128 => Qtde: 004 >########Somatoria: 0129 => Qtde: 005 >##########Somatoria: 0130 => Qtde: 005 >##########Somatoria: 0131 => Qtde: 007 >##############Somatoria: 0132 => Qtde: 007 >##############Somatoria: 0133 => Qtde: 005 >##########Somatoria: 0134 => Qtde: 013 >###########################Somatoria: 0135 => Qtde: 007 >##############Somatoria: 0136 => Qtde: 007 >##############Somatoria: 0137 => Qtde: 008 >################Somatoria: 0138 => Qtde: 012 >#########################Somatoria: 0139 => Qtde: 015 >###############################Somatoria: 0140 => Qtde: 010 >####################Somatoria: 0141 => Qtde: 010 >####################Somatoria: 0142 => Qtde: 012 >#########################Somatoria: 0143 => Qtde: 012 >#########################Somatoria: 0144 => Qtde: 013 >###########################Somatoria: 0145 => Qtde: 012 >#########################Somatoria: 0146 => Qtde: 012 >#########################Somatoria: 0147 => Qtde: 012 >#########################Somatoria: 0148 => Qtde: 011 >######################Somatoria: 0149 => Qtde: 020 >#########################################Somatoria: 0150 => Qtde: 015 >###############################Somatoria: 0151 => Qtde: 013 >###########################Somatoria: 0152 => Qtde: 016 >#################################Somatoria: 0153 => Qtde: 012 >#########################Somatoria: 0154 => Qtde: 009 >##################Somatoria: 0155 => Qtde: 011 >######################Somatoria: 0156 => Qtde: 012 >#########################Somatoria: 0157 => Qtde: 010 >####################Somatoria: 0158 => Qtde: 018 >#####################################Somatoria: 0159 => Qtde: 018 >#####################################Somatoria: 0160 => Qtde: 010 >####################Somatoria: 0161 => Qtde: 018 >#####################################Somatoria: 0162 => Qtde: 014 >#############################Somatoria: 0163 => Qtde: 018 >#####################################Somatoria: 0164 => Qtde: 013 >###########################Somatoria: 0165 => Qtde: 020 >#########################################Somatoria: 0166 => Qtde: 014 >#############################Somatoria: 0167 => Qtde: 011 >######################Somatoria: 0168 => Qtde: 011 >######################Somatoria: 0169 => Qtde: 010 >####################Somatoria: 0170 => Qtde: 016 >#################################Somatoria: 0171 => Qtde: 017 >###################################Somatoria: 0172 => Qtde: 016 >#################################Somatoria: 0173 => Qtde: 013 >###########################Somatoria: 0174 => Qtde: 017 >###################################Somatoria: 0175 => Qtde: 015 >###############################Somatoria: 0176 => Qtde: 018 >#####################################Somatoria: 0177 => Qtde: 014 >#############################Somatoria: 0178 => Qtde: 013 >###########################Somatoria: 0179 => Qtde: 012 >#########################Somatoria: 0180 => Qtde: 024 >##################################################Somatoria: 0181 => Qtde: 018 >#####################################Somatoria: 0182 => Qtde: 022 >#############################################Somatoria: 0183 => Qtde: 011 >######################Somatoria: 0184 => Qtde: 018 >#####################################Somatoria: 0185 => Qtde: 015 >###############################Somatoria: 0186 => Qtde: 022 >#############################################Somatoria: 0187 => Qtde: 011 >######################Somatoria: 0188 => Qtde: 014 >#############################Somatoria: 0189 => Qtde: 013 >###########################Somatoria: 0190 => Qtde: 020 >#########################################Somatoria: 0191 => Qtde: 012 >#########################Somatoria: 0192 => Qtde: 019 >#######################################Somatoria: 0193 => Qtde: 012 >#########################Somatoria: 0194 => Qtde: 016 >#################################Somatoria: 0195 => Qtde: 008 >################Somatoria: 0196 => Qtde: 017 >###################################Somatoria: 0197 => Qtde: 016 >#################################Somatoria: 0198 => Qtde: 011 >######################Somatoria: 0199 => Qtde: 016 >#################################Somatoria: 0200 => Qtde: 020 >#########################################Somatoria: 0201 => Qtde: 018 >#####################################Somatoria: 0202 => Qtde: 018 >#####################################Somatoria: 0203 => Qtde: 009 >##################Somatoria: 0204 => Qtde: 019 >#######################################Somatoria: 0205 => Qtde: 019 >#######################################Somatoria: 0206 => Qtde: 014 >#############################Somatoria: 0207 => Qtde: 011 >######################Somatoria: 0208 => Qtde: 011 >######################Somatoria: 0209 => Qtde: 018 >#####################################Somatoria: 0210 => Qtde: 012 >#########################Somatoria: 0211 => Qtde: 018 >#####################################Somatoria: 0212 => Qtde: 010 >####################Somatoria: 0213 => Qtde: 014 >#############################Somatoria: 0214 => Qtde: 015 >###############################Somatoria: 0215 => Qtde: 016 >#################################Somatoria: 0216 => Qtde: 012 >#########################Somatoria: 0217 => Qtde: 014 >#############################Somatoria: 0218 => Qtde: 013 >###########################Somatoria: 0219 => Qtde: 015 >###############################Somatoria: 0220 => Qtde: 012 >#########################Somatoria: 0221 => Qtde: 010 >####################Somatoria: 0222 => Qtde: 012 >#########################Somatoria: 0223 => Qtde: 014 >#############################Somatoria: 0224 => Qtde: 020 >#########################################Somatoria: 0225 => Qtde: 002 >####Somatoria: 0226 => Qtde: 009 >##################Somatoria: 0227 => Qtde: 009 >##################Somatoria: 0228 => Qtde: 004 >########Somatoria: 0229 => Qtde: 014 >#############################Somatoria: 0230 => Qtde: 014 >#############################Somatoria: 0231 => Qtde: 010 >####################Somatoria: 0232 => Qtde: 007 >##############Somatoria: 0233 => Qtde: 010 >####################Somatoria: 0234 => Qtde: 005 >##########Somatoria: 0235 => Qtde: 009 >##################Somatoria: 0236 => Qtde: 004 >########Somatoria: 0237 => Qtde: 010 >####################Somatoria: 0238 => Qtde: 007 >##############Somatoria: 0239 => Qtde: 004 >########Somatoria: 0240 => Qtde: 001 >##Somatoria: 0241 => Qtde: 007 >##############Somatoria: 0242 => Qtde: 007 >##############Somatoria: 0243 => Qtde: 010 >####################Somatoria: 0244 => Qtde: 005 >##########Somatoria: 0245 => Qtde: 007 >##############Somatoria: 0246 => Qtde: 007 >##############Somatoria: 0247 => Qtde: 008 >################Somatoria: 0248 => Qtde: 007 >##############Somatoria: 0249 => Qtde: 003 >######Somatoria: 0250 => Qtde: 005 >##########Somatoria: 0251 => Qtde: 002 >####Somatoria: 0252 => Qtde: 002 >####Somatoria: 0253 => Qtde: 002 >####Somatoria: 0254 => Qtde: 007 >##############Somatoria: 0255 => Qtde: 004 >########Somatoria: 0256 => Qtde: 005 >##########Somatoria: 0257 => Qtde: 001 >##Somatoria: 0258 => Qtde: 003 >######Somatoria: 0259 => Qtde: 003 >######Somatoria: 0260 => Qtde: 003 >######Somatoria: 0261 => Qtde: 002 >####Somatoria: 0262 => Qtde: 002 >####Somatoria: 0263 => Qtde: 002 >####Somatoria: 0264 => Qtde: 002 >####Somatoria: 0265 => Qtde: 001 >##Somatoria: 0266 => Qtde: 003 >######Somatoria: 0267 => Qtde: 001 >##Somatoria: 0268 => Qtde: 001 >##Somatoria: 0270 => Qtde: 001 >##Somatoria: 0271 => Qtde: 001 >##Somatoria: 0274 => Qtde: 001 >##Somatoria: 0275 => Qtde: 003 >######Somatoria: 0276 => Qtde: 003 >######Somatoria: 0278 => Qtde: 001 >##Somatoria: 0279 => Qtde: 001 >##Somatoria: 0280 => Qtde: 004 >########Somatoria: 0281 => Qtde: 001 >##Somatoria: 0282 => Qtde: 001 >##Somatoria: 0287 => Qtde: 002 >####Somatoria: 0289 => Qtde: 001 >##Somatoria: 0290 => Qtde: 002 >####Somatoria: 0294 => Qtde: 001 >##Somatoria: 0296 => Qtde: 001 >##Somatoria: 0299 => Qtde: 001 >##Somatoria: 0314 => Qtde: 001 >## Filtro: 0066/0072/0073/0077/0079/0080/0081/0083/0085/0086/0087/0088/0089/0090/0091/0092/0093/0094/0096/0097/0098/0100/0102/0103/0104/0105/0106/0107/0108/0109/0110/0111/0112/0113/0114/0115/0116/0117/0118/0119/0120/0121/0122/0123/0124/0125/0126/0127/0128/0129/0130/0131/0132/0133/0134/0135/0136/0137/0138/0139/0140/0141/0142/0143/0144/0145/0146/0147/0148/0149/0150/0151/0152/0153/0154/0155/0156/0157/0158/0159/0160/0161/0162/0163/0164/0165/0166/0167/0168/0169/0170/0171/0172/0173/0174/0175/0176/0177/0178/0179/0180/0181/0182/0183/0184/0185/0186/0187/0188/0189/0190/0191/0192/0193/0194/0195/0196/0197/0198/0199/0200/0201/0202/0203/0204/0205/0206/0207/0208/0209/0210/0211/0212/0213/0214/0215/0216/0217/0218/0219/0220/0221/0222/0223/0224/0225/0226/0227/0228/0229/0230/0231/0232/0233/0234/0235/0236/0237/0238/0239/0240/0241/0242/0243/0244/0245/0246/0247/0248/0249/0250/0251/0252/0253/0254/0255/0256/0257/0258/0259/0260/0261/0262/0263/0264/0265/0266/0267/0268/0270/0271/0274/0275/0276/0278/0279/0280/0281/0282/0287/0289/0290/0294/0296/0299/0314/ Maior incidencia: 180 ocorreu: 24 vezes. SOMATORIA CONSIDERANDO DEZENAS PARES X IMPARES 001 002 003 004 005 006 007 008 009 010 011 012 013 014 015 016 017 018 019 020001 => (P)................................................................................ (I)006 ............................................................................002 => (P)006 ............................................................................ (I)................................................................................003 => (P)................................................................................ (I)006 ............................................................................004 => (P)006 ............................................................................ (I)....001 ........................................................................005 => (P)................................................................................ (I)006 ............................................................................006 => (P)004 003 ........................................................................ (I)....001 ........................................................................007 => (P)................................................................................ (I)003 ............................................................................008 => (P)004 ............................................................................ (I)....002 ........................................................................009 => (P)................................................................................ (I)005 ....002 ....................................................................010 => (P)005 004 ........................................................................ (I)....003 ........................................................................011 => (P)................................................................................ (I)004 ............................................................................012 => (P)003 002 ........................................................................ (I)....002 ........................................................................013 => (P)................................................................................ (I)007 ............................................................................014 => (P)003 004 ........................................................................ (I)....002 ........................................................................015 => (P)................................................................................ (I)005 ............................................................................016 => (P)008 004 ........................................................................ (I)....006 ........................................................................017 => (P)................................................................................ (I)009 ....001 ....................................................................018 => (P)006 004 ........................................................................ (I)....001 ........................................................................019 => (P)................................................................................ (I)007 ....003 ....................................................................020 => (P)004 005 001 .................................................................... (I)....003 ........................................................................021 => (P)................................................................................ (I)004 ............................................................................022 => (P)005 007 002 001 ................................................................ (I)....004 ........................................................................023 => (P)................................................................................ (I)008 ............................................................................024 => (P)005 006 001 .................................................................... (I)....004 ........................................................................025 => (P)................................................................................ (I)007 ....002 ....................................................................026 => (P)005 005 ........................................................................ (I)....006 ........................................................................027 => (P)................................................................................ (I)005 ............................................................................028 => (P)003 001 ........................................................................ (I)....005 ........................................................................029 => (P)................................................................................ (I)006 ....001 ....................................................................030 => (P)008 003 002 .................................................................... (I)....013 ........................................................................031 => (P)................................................................................ (I)005 ....002 ....................................................................032 => (P)006 006 001 .................................................................... (I)....009 ........................................................................033 => (P)................................................................................ (I)003 ....001 ....................................................................034 => (P)006 009 001 .................................................................... (I)....006 ........................................................................035 => (P)................................................................................ (I)006 ....005 ....................................................................036 => (P)006 007 002 .................................................................... (I)....003 ........................................................................037 => (P)................................................................................ (I)004 ....001 ....................................................................038 => (P)004 010 005 .................................................................... (I)....008 ........................................................................039 => (P)................................................................................ (I)004 ....001 ....................................................................040 => (P)007 010 003 .................................................................... (I)....008 ........................................................................041 => (P)................................................................................ (I)005 ....002 ....001 ............................................................042 => (P)005 008 005 .................................................................... (I)....016 ........................................................................043 => (P)................................................................................ (I)005 ....005 ....................................................................044 => (P)004 010 004 .................................................................... (I)....006 ....001 ................................................................045 => (P)................................................................................ (I)006 ....007 ....................................................................046 => (P)005 010 002 002 ................................................................ (I)....013 ....002 ................................................................047 => (P)................................................................................ (I)007 ....004 ....................................................................048 => (P)001 007 006 .................................................................... (I)....013 ........................................................................049 => (P)................................................................................ (I)006 ....005 ....................................................................050 => (P)005 016 007 002 ................................................................ (I)....011 ....003 ................................................................051 => (P)................................................................................ (I)007 ....006 ....................................................................052 => (P)007 007 002 001 ................................................................ (I)....014 ....003 ................................................................053 => (P)................................................................................ (I)007 ....009 ....................................................................054 => (P)006 015 006 .................................................................... (I)....009 ....004 ................................................................055 => (P)................................................................................ (I)003 ....008 ....................................................................056 => (P)004 014 004 002 ................................................................ (I)....011 ....001 ................................................................057 => (P)................................................................................ (I)005 ....010 ....................................................................058 => (P)005 013 001 003 ................................................................ (I)....009 ....002 ................................................................059 => (P)................................................................................ (I)008 ....006 ....................................................................060 => (P)004 018 007 002 ................................................................ (I)....009 ....002 ................................................................061 => (P)................................................................................ (I)........004 ....................................................................062 => (P)....019 015 .................................................................... (I)....017 ....002 ................................................................063 => (P)................................................................................ (I)........008 ....................................................................064 => (P)....013 010 001 ................................................................ (I)....015 ....001 ................................................................065 => (P)................................................................................ (I)........012 ....................................................................066 => (P)....018 013 001 ................................................................ (I)....016 ....004 ................................................................067 => (P)................................................................................ (I)........004 ....................................................................068 => (P)....016 005 002 ................................................................ (I)....012 ....004 ................................................................069 => (P)................................................................................ (I)........016 ....................................................................070 => (P)....010 010 001 ................................................................ (I)....011 ....007 ................................................................071 => (P)................................................................................ (I)........009 ....001 ............................................................072 => (P)....011 015 004 ................................................................ (I)....008 ....005 ................................................................073 => (P)................................................................................ (I)........007 ....002 ............................................................074 => (P)....007 013 .................................................................... (I)....010 ....006 ................................................................075 => (P)................................................................................ (I)........016 ....................................................................076 => (P)....013 011 005 ................................................................ (I)....020 ....004 ................................................................077 => (P)................................................................................ (I)........007 ....................................................................078 => (P)....012 019 001 ................................................................ (I)....016 ....007 ................................................................079 => (P)................................................................................ (I)........013 ....001 ............................................................080 => (P)....010 012 006 ................................................................ (I)....010 ....008 ................................................................081 => (P)................................................................................ (I)........013 ....................................................................082 => (P)....005 011 004 001 ............................................................ (I)....008 ....002 ................................................................083 => (P)................................................................................ (I)........021 ....001 ............................................................084 => (P)....005 011 006 001 ............................................................ (I)....012 ....005 ................................................................085 => (P)................................................................................ (I)........010 ....001 ............................................................086 => (P)....007 016 009 ................................................................ (I)....015 ....010 ................................................................087 => (P)................................................................................ (I)........016 ....001 ............................................................088 => (P)....002 010 006 ................................................................ (I)....006 ....002 ................................................................089 => (P)................................................................................ (I)........012 ....................................................................090 => (P)....012 011 004 001 ............................................................ (I)....006 ....001 ................................................................091 => (P)................................................................................ (I)........016 ....001 ............................................................092 => (P)....011 016 007 001 ............................................................ (I)....005 ....008 ................................................................093 => (P)................................................................................ (I)........009 ....................................................................094 => (P)....008 016 008 001 ............................................................ (I)....008 ....011 ................................................................095 => (P)................................................................................ (I)........014 ....001 ............................................................096 => (P)....010 017 005 002 ............................................................ (I)....005 ....006 ................................................................097 => (P)................................................................................ (I)........013 ....001 ............................................................098 => (P)....008 008 011 001 ............................................................ (I)....004 ....007 ................................................................099 => (P)................................................................................ (I)........014 ....002 ............................................................100 => (P)....005 012 009 002 ............................................................ (I)....003 ....008 ................................................................101 => (P)................................................................................ (I)........022 ....002 ............................................................102 => (P)....005 014 009 001 ............................................................ (I)....003 ....007 ................................................................103 => (P)................................................................................ (I)........013 ....................................................................104 => (P)....006 016 009 001 ............................................................ (I)....005 ....007 ................................................................105 => (P)................................................................................ (I)........016 ....001 ............................................................106 => (P)....002 015 015 001 ............................................................ (I)....004 ....010 ................................................................107 => (P)................................................................................ (I)........010 ....001 ............................................................108 => (P)....002 006 006 002 ............................................................ (I)............010 ................................................................109 => (P)................................................................................ (I)........011 ....001 ............................................................110 => (P)....002 016 009 ................................................................ (I)....002 ....013 ................................................................111 => (P)................................................................................ (I)........011 ....................................................................112 => (P)....002 012 011 002 ............................................................ (I)....002 ....007 ................................................................113 => (P)................................................................................ (I)........007 ....003 ............................................................114 => (P)....001 011 008 001 ............................................................ (I)............017 ................................................................115 => (P)................................................................................ (I)........015 ....004 ............................................................116 => (P)........010 005 002 ............................................................ (I)............012 ................................................................117 => (P)................................................................................ (I)........006 ....002 ............................................................118 => (P)....001 007 006 003 ............................................................ (I)............012 ................................................................119 => (P)................................................................................ (I)........007 ....001 ............................................................120 => (P)........008 008 003 ............................................................ (I)............011 ................................................................121 => (P)................................................................................ (I)........013 ....003 ............................................................122 => (P)........008 013 004 ............................................................ (I)............006 ................................................................123 => (P)................................................................................ (I)........012 ....004 ............................................................124 => (P)........009 013 003 ............................................................ (I)............009 ................................................................125 => (P)................................................................................ (I)........009 ....002 ............................................................126 => (P)........011 006 003 ............................................................ (I)............010 ................................................................127 => (P)................................................................................ (I)........005 ....003 ............................................................128 => (P)........006 008 003 ............................................................ (I)............012 ................................................................129 => (P)................................................................................ (I)........007 ....004 ............................................................130 => (P)........006 003 005 ............................................................ (I)............006 ................................................................131 => (P)................................................................................ (I)........005 ....002 ............................................................132 => (P)........005 014 001 ............................................................ (I)............008 ................................................................133 => (P)................................................................................ (I)........003 ....003 ............................................................134 => (P)........007 010 003 ............................................................ (I)............010 ................................................................135 => (P)................................................................................ (I)........005 ....001 ............................................................136 => (P)........005 010 002 ............................................................ (I)............008 ................................................................137 => (P)................................................................................ (I)........002 ....004 ............................................................138 => (P)........004 011 003 ............................................................ (I)............012 ................................................................139 => (P)................................................................................ (I)........003 ....004 ............................................................140 => (P)........004 011 004 ............................................................ (I)............005 ................................................................141 => (P)................................................................................ (I)........003 ....................................................................142 => (P)........005 010 002 ............................................................ (I)............006 ................................................................143 => (P)................................................................................ (I)........003 ....007 ............................................................144 => (P)........005 007 003 ............................................................ (I)............011 ................................................................145 => (P)................................................................................ (I)........003 ....001 ............................................................146 => (P)........003 007 005 ............................................................ (I)............006 ................................................................147 => (P)................................................................................ (I)........002 ....004 ............................................................148 => (P)........001 008 004 ............................................................ (I)............007 ................................................................149 => (P)................................................................................ (I)................003 ............................................................150 => (P)........002 004 004 ............................................................ (I)............003 ................................................................151 => (P)................................................................................ (I)........001 ....002 ............................................................152 => (P)........003 005 005 ............................................................ (I)............003 ................................................................153 => (P)................................................................................ (I)........001 ....001 ............................................................154 => (P)............006 004 ............................................................ (I)............011 ................................................................155 => (P)................................................................................ (I)........002 ....004 ............................................................156 => (P)........001 008 005 ............................................................ (I)............010 ................................................................157 => (P)................................................................................ (I)........002 ....002 ............................................................158 => (P)............005 004 ............................................................ (I)............005 ................................................................159 => (P)................................................................................ (I)................004 ............................................................160 => (P)............008 004 ............................................................ (I)............005 ................................................................161 => (P)................................................................................ (I)................005 ............................................................162 => (P)........001 008 005 ............................................................ (I)............003 ................................................................163 => (P)................................................................................ (I)........001 ....002 ............................................................164 => (P)............007 003 ............................................................ (I)............009 ................................................................165 => (P)................................................................................ (I)................002 ............................................................166 => (P)............004 002 ............................................................ (I)............003 ................................................................167 => (P)................................................................................ (I)................003 ............................................................168 => (P)........001 006 003 ............................................................ (I)............004 ................................................................169 => (P)................................................................................ (I)................002 ............................................................170 => (P)............006 002 ............................................................ (I)............003 ................................................................171 => (P)................................................................................ (I)................003 ............................................................172 => (P)............008 004 ............................................................ (I)............001 ................................................................173 => (P)................................................................................ (I)................004 ............................................................174 => (P)............004 003 ............................................................ (I)............005 ................................................................175 => (P)................................................................................ (I)................002 ............................................................176 => (P)............005 003 ............................................................ (I)............001 ................................................................177 => (P)................................................................................ (I)................001 ............................................................178 => (P)............003 002 ............................................................ (I)............002 ................................................................179 => (P)................................................................................ (I)................002 ............................................................180 => (P)............003 003 ............................................................ (I)................................................................................181 => (P)................................................................................ (I)................003 ............................................................182 => (P)............002 002 ............................................................ (I)............004 ................................................................183 => (P)................................................................................ (I)................005 ............................................................184 => (P)............002 004 ............................................................ (I)............001 ................................................................185 => (P)................................................................................ (I)................002 ............................................................186 => (P)............001 006 ............................................................ (I)................................................................................188 => (P)............001 002 ............................................................ (I)............002 ................................................................189 => (P)................................................................................ (I)................001 ............................................................190 => (P)................001 ............................................................ (I)............002 ................................................................191 => (P)................................................................................ (I)................002 ............................................................192 => (P)................002 ............................................................ (I)................................................................................193 => (P)................................................................................ (I)................001 ............................................................194 => (P)............001 001 ............................................................ (I)............001 ................................................................195 => (P)................................................................................ (I)................003 ............................................................196 => (P)................002 ............................................................ (I)............002 ................................................................197 => (P)................................................................................ (I)................002 ............................................................198 => (P)............001 002 ............................................................ (I)................................................................................199 => (P)................................................................................ (I)................002 ............................................................200 => (P)................002 ............................................................ (I)................................................................................201 => (P)................................................................................ (I)................004 ............................................................202 => (P)................004 ............................................................ (I)................................................................................203 => (P)................................................................................ (I)................001 ............................................................204 => (P)................004 ............................................................ (I)................................................................................205 => (P)................................................................................ (I)................002 ............................................................206 => (P)................001 ............................................................ (I)............001 ................................................................207 => (P)................................................................................ (I)................004 ............................................................208 => (P)............001 003 ............................................................ (I)................................................................................209 => (P)................................................................................ (I)................001 ............................................................210 => (P)................001 ............................................................ (I)............001 ................................................................211 => (P)................................................................................ (I)................001 ............................................................212 => (P)............002 001 ............................................................ (I)................................................................................214 => (P)................................................................................ (I)............001 ................................................................218 => (P)................002 ............................................................ (I)................................................................................219 => (P)................................................................................ (I)................001 ............................................................225 => (P)................................................................................ (I)................001 ............................................................228 => (P)................001 ............................................................ (I)................................................................................229 => (P)................................................................................ (I)................001 ............................................................240 => (P)................001 ............................................................ (I)................................................................................253 => (P)................................................................................ (I)................001 ............................................................ ANALISE DE DISTANCIA ENTRE DEZENASConfiguração para o FILTRO DISTANCIADistancia: 4 - 2xDistancia: 5 - 3xDistancia: 6 - 2xDistancia: 7 - 10xDistancia: 8 - 18xDistancia: 9 - 26xDistancia: 10 - 38xDistancia: 11 - 50xDistancia: 12 - 69xDistancia: 13 - 73xDistancia: 14 - 106xDistancia: 15 - 127xDistancia: 16 - 126xDistancia: 17 - 127xDistancia: 18 - 112xDistancia: 19 - 108xDistancia: 20 - 88xDistancia: 21 - 81xDistancia: 22 - 95xDistancia: 23 - 77xDistancia: 24 - 63xDistancia: 25 - 61xDistancia: 26 - 51xDistancia: 27 - 39xDistancia: 28 - 35xDistancia: 29 - 21xDistancia: 30 - 22xDistancia: 31 - 12xDistancia: 32 - 15xDistancia: 33 - 13xDistancia: 34 - 9xDistancia: 35 - 11xDistancia: 36 - 10xDistancia: 37 - 6xDistancia: 38 - 7xDistancia: 39 - 4xDistancia: 40 - 2xDistancia: 41 - 3xDistancia: 42 - 1xDistancia: 43 - 2x ANALISE DE GRUPOS POR CARTÃOConfiguração para o FILTRO POR GRUPOQtde dezenas no grupo acima de: 1Grupos: 3 - 4xGrupos: 4 - 118xGrupos: 5 - 594xGrupos: 6 - 1009x Quote Link to comment Share on other sites More sharing options...
sorel Posted September 4, 2015 Share Posted September 4, 2015 roger vamos ver estaOption ExplicitOption Base 1Dim A As Integer, B As Integer, C As Integer, D As Integer, E As Integer, F As IntegerDim I As Integer, nSum(345) As LongSub SumAll()Application.ScreenUpdating = FalseSheets("Sheet1").SelectRange("A2").SelectRange("A1").Value = "Sum"Range("B1").Value = "# comb."Range("C1").Value = "probability %."For I = 21 To 345nSum(I) = 0Next IFor A = 1 To 55For B = A + 1 To 56For C = B + 1 To 57For D = C + 1 To 58For E = D + 1 To 59For F = E + 1 To 60nSum(A + B + C + D + E + F) = nSum(A + B + C + D + E + F) + 1Next FNext ENext DNext CNext BNext AFor I = 21 To 345ActiveCell.Value = IActiveCell.Offset(0, 1).Value = nSum(I)ActiveCell.Offset(0, 2).Value = nSum(I) /500638.6ActiveCell.Offset(1, 0).SelectNext IApplication.ScreenUpdating = FalseRange("A1").SelectEnd Sub Quote Link to comment Share on other sites More sharing options...
roger1318 Posted September 4, 2015 Author Share Posted September 4, 2015 Ola, Segue a Planilha com todas as combinações das somas possíveis, conforme sua VBA (macro) informada logo acima.https://www.sendspace.com/file/kh2wfq SorteRoger1318!! Quote Link to comment Share on other sites More sharing options...
roger1318 Posted September 4, 2015 Author Share Posted September 4, 2015 Ola, Segue com as probabilidades e somas.https://www.sendspace.com/file/vlw10v SorteRoger1318!! Quote Link to comment Share on other sites More sharing options...
sorel Posted September 4, 2015 Share Posted September 4, 2015 olá rogar , boa, mas como pretende usar as melhores somas? como podemos usar isto para prever? abraço Quote Link to comment Share on other sites More sharing options...
roger1318 Posted September 4, 2015 Author Share Posted September 4, 2015 Ola, Sorel, eu não estou utilizando estas somas e sim as somas dos dígitos. Meus grupos são apenas nove, estou tentando reduzir a quantidades de dezenas para ficar perto e quem sabe alcançar algum premio. Aqui neste site voce pode ver muitas estatísticas, de todas as loterias.http://www.crv.com.br/Loteria SorteRoger1318!! Quote Link to comment Share on other sites More sharing options...
sorel Posted September 4, 2015 Share Posted September 4, 2015 isto das somas dos digitos pares e impares terminaçoes é muito promissor desde que se ache o começo( um ponto de referncia) os seja padroes reafirmar minhas suposições. (1) A matemática é a linguagem da natureza. (2) Tudo ao nosso redor pode ser representado e entendido através dos números. (3) Se você representar graficamente os números de qualquer sistema, padrões emergem. Portanto, há padrões, em toda a natureza. Quote Link to comment Share on other sites More sharing options...
sorel Posted September 4, 2015 Share Posted September 4, 2015 http://www.jadexcode.com/files/excel/Disimulate-Pick6-0.xlsm roger ter adaptar na 60/6 na nossa mega sena Quote Link to comment Share on other sites More sharing options...
sorel Posted September 4, 2015 Share Posted September 4, 2015 roger parece que só digitar 60 na planilia , beleza roger consegue colocar os nosso sorteios nao precisa data, desde o 1º sorteiobahh roger asim podemos ver as somas Quote Link to comment Share on other sites More sharing options...
sorel Posted September 4, 2015 Share Posted September 4, 2015 roger 1318, precisa ativar nesta macro tem as pares e impares separare consegue por na planilia e colocar o link por favorSub SumOddeven33() 'A,B,C are odd, D,E,F are evenApplication.ScreenUpdating = FalseSheets("Sheet2").SelectRange("A2").SelectRange("A1").Value = "Sum"Range("B1").Value = "# comb."Range("C1").Value = "probability %."For I = 21 To 345nSum(I) = 0Next IFor A = 1 To 55For B = A + 1 To 56For C = B + 1 To 57For D = C + 1 To 58For E = D + 1 To 59For F = E + 1 To 60If A Mod 2 = 1 And B Mod 2 = 1 And C Mod 2 = 1 And D Mod 2 = 0 And E Mod 2 = 0 And F Mod 2 = 0 ThennSum(A + B + C + D + E + F) = nSum(A + B + C + D + E + F) + 1End IfNext FNext ENext DNext CNext BNext AFor I = 21 To 345ActiveCell.Value = IActiveCell.Offset(0, 1).Value = nSum(I)ActiveCell.Offset(0, 2).Value = nSum(I) / 500638.6ActiveCell.Offset(1, 0).SelectNext IApplication.ScreenUpdating = FalseActiveCell.Offset(1, 0).SelectActiveCell.Value = "3 odd 3 even"Range("A1").SelectEnd SubSub SumEvenodd33() 'A,B,C are even, D,E,F are oddApplication.ScreenUpdating = FalseSheets("Sheet3").SelectRange("A2").SelectRange("A1").Value = "Sum"Range("B1").Value = "# comb."Range("C1").Value = "probability %."For I = 21 To 345nSum(I) = 0Next IFor A = 1 To 55For B = A + 1 To 56For C = B + 1 To 57For D = C + 1 To 58For E = D + 1 To 59For F = E + 1 To 60If A Mod 2 = 0 And B Mod 2 = 0 And C Mod 2 = 0 And D Mod 2 = 1 And E Mod 2 = 1 And F Mod 2 = 1 ThennSum(A + B + C + D + E + F) = nSum(A + B + C + D + E + F) + 1End IfNext FNext ENext DNext CNext BNext AFor I = 21 To 345ActiveCell.Value = IActiveCell.Offset(0, 1).Value = nSum(I)ActiveCell.Offset(0, 2).Value = nSum(I) / 500638.6ActiveCell.Offset(1, 0).SelectNext IApplication.ScreenUpdating = FalseActiveCell.Offset(1, 0).SelectActiveCell.Value = "3 even 3 odd"Range("A1").SelectEnd SubSub SumEvenodd42() 'A,B,C,D are even,E,F are oddApplication.ScreenUpdating = FalseSheets("Sheet4").SelectRange("A2").SelectRange("A1").Value = "Sum"Range("B1").Value = "# comb."Range("C1").Value = "probability %."For I = 21 To 345nSum(I) = 0Next IFor A = 1 To 55For B = A + 1 To 56For C = B + 1 To 57For D = C + 1 To 58For E = D + 1 To 59For F = E + 1 To 60If A Mod 2 = 0 And B Mod 2 = 0 And C Mod 2 = 0 And D Mod 2 = 0 And E Mod 2 = 1 And F Mod 2 = 1 ThennSum(A + B + C + D + E + F) = nSum(A + B + C + D + E + F) + 1End IfNext FNext ENext DNext CNext BNext AFor I = 21 To 345ActiveCell.Value = IActiveCell.Offset(0, 1).Value = nSum(I)ActiveCell.Offset(0, 2).Value = nSum(I) / 500638.6ActiveCell.Offset(1, 0).SelectNext IApplication.ScreenUpdating = FalseActiveCell.Offset(1, 0).SelectActiveCell.Value = "4 even 2 odd"Range("A1").SelectEnd SubSub SumOddeven42() 'A,B,C,D are odd E,F are evenApplication.ScreenUpdating = FalseSheets("Sheet5").SelectRange("A2").SelectRange("A1").Value = "Sum"Range("B1").Value = "# comb."Range("C1").Value = "probability %."For I = 21 To 345nSum(I) = 0Next IFor A = 1 To 55For B = A + 1 To 56For C = B + 1 To 57For D = C + 1 To 58For E = D + 1 To 59For F = E + 1 To 60If A Mod 2 = 1 And B Mod 2 = 1 And C Mod 2 = 1 And D Mod 2 = 1 And E Mod 2 = 0 And F Mod 2 = 0 ThennSum(A + B + C + D + E + F) = nSum(A + B + C + D + E + F) + 1End IfNext FNext ENext DNext CNext BNext AFor I = 21 To 345ActiveCell.Value = IActiveCell.Offset(0, 1).Value = nSum(I)ActiveCell.Offset(0, 2).Value = nSum(I) / 500638.6ActiveCell.Offset(1, 0).SelectNext IApplication.ScreenUpdating = FalseActiveCell.Offset(1, 0).SelectActiveCell.Value = "4 odd 2 even"Range("A1").SelectEnd SubSub SumOddeven24() 'A,B are odd C,D,E,F are evenApplication.ScreenUpdating = FalseSheets("Sheet6").SelectRange("A2").SelectRange("A1").Value = "Sum"Range("B1").Value = "# comb."Range("C1").Value = "probability %."For I = 21 To 345nSum(I) = 0Next IFor A = 1 To 55For B = A + 1 To 56For C = B + 1 To 57For D = C + 1 To 58For E = D + 1 To 59For F = E + 1 To 60If A Mod 2 = 1 And B Mod 2 = 1 And C Mod 2 = 0 And D Mod 2 = 0 And E Mod 2 = 0 And F Mod 2 = 0 ThennSum(A + B + C + D + E + F) = nSum(A + B + C + D + E + F) + 1End IfNext FNext ENext DNext CNext BNext AFor I = 21 To 345ActiveCell.Value = IActiveCell.Offset(0, 1).Value = nSum(I)ActiveCell.Offset(0, 2).Value = nSum(I) / 500638.6ActiveCell.Offset(1, 0).SelectNext IApplication.ScreenUpdating = FalseActiveCell.Offset(1, 0).SelectActiveCell.Value = "2 odd 4 even"Range("A1").SelectEnd SubSub SumEvenodd24() 'A,B are even,C,D, E,F are oddApplication.ScreenUpdating = FalseSheets("Sheet7").SelectRange("A2").SelectRange("A1").Value = "Sum"Range("B1").Value = "# comb."Range("C1").Value = "probability %."For I = 21 To 345nSum(I) = 0Next IFor A = 1 To 55For B = A + 1 To 56For C = B + 1 To 57For D = C + 1 To 58For E = D + 1 To 59For F = E + 1 To 60If A Mod 2 = 0 And B Mod 2 = 0 And C Mod 2 = 1 And D Mod 2 = 1 And E Mod 2 = 1 And F Mod 2 = 1 ThennSum(A + B + C + D + E + F) = nSum(A + B + C + D + E + F) + 1End IfNext FNext ENext DNext CNext BNext AFor I = 21 To 345ActiveCell.Value = IActiveCell.Offset(0, 1).Value = nSum(I)ActiveCell.Offset(0, 2).Value = nSum(I) / 500638.6ActiveCell.Offset(1, 0).SelectNext IApplication.ScreenUpdating = FalseActiveCell.Offset(1, 0).SelectActiveCell.Value = "2 even 4 odd"Range("A1").SelectEnd Sub Quote Link to comment Share on other sites More sharing options...
sorel Posted September 4, 2015 Share Posted September 4, 2015 Eu quase esqueci. Você vai precisar de pelo menos sete planilhas em sua pasta de trabalho para todas as macros para executar. Cada um usa a sua própria folha. Quote Link to comment Share on other sites More sharing options...
roger1318 Posted September 4, 2015 Author Share Posted September 4, 2015 Sorel, Não sei sobre VBA, estas formulas suas esta sem função nSum(I) = 0. SorteRoger1318!! Quote Link to comment Share on other sites More sharing options...
sorel Posted September 4, 2015 Share Posted September 4, 2015 voce tem criar 7 planilas Quote Link to comment Share on other sites More sharing options...
sorel Posted September 4, 2015 Share Posted September 4, 2015 roger soma dos digito inicail e final juntos ( algarismos)nalise de jogos por SOMATORIA DAS DEZENAS Somatoria: 0018 => Qtde: 001 >Somatoria: 0019 => Qtde: 001 >Somatoria: 0020 => Qtde: 001 >Somatoria: 0022 => Qtde: 002 >#Somatoria: 0023 => Qtde: 001 >Somatoria: 0024 => Qtde: 006 >###Somatoria: 0025 => Qtde: 002 >#Somatoria: 0026 => Qtde: 009 >####Somatoria: 0027 => Qtde: 014 >#######Somatoria: 0028 => Qtde: 020 >##########Somatoria: 0029 => Qtde: 020 >##########Somatoria: 0030 => Qtde: 019 >#########Somatoria: 0031 => Qtde: 026 >#############Somatoria: 0032 => Qtde: 039 >####################Somatoria: 0033 => Qtde: 042 >#####################Somatoria: 0034 => Qtde: 055 >############################Somatoria: 0035 => Qtde: 062 >################################Somatoria: 0036 => Qtde: 054 >############################Somatoria: 0037 => Qtde: 066 >##################################Somatoria: 0038 => Qtde: 077 >########################################Somatoria: 0039 => Qtde: 096 >##################################################Somatoria: 0040 => Qtde: 087 >#############################################Somatoria: 0041 => Qtde: 093 >################################################Somatoria: 0042 => Qtde: 091 >###############################################Somatoria: 0043 => Qtde: 071 >####################################Somatoria: 0044 => Qtde: 089 >##############################################Somatoria: 0045 => Qtde: 086 >############################################Somatoria: 0046 => Qtde: 079 >#########################################Somatoria: 0047 => Qtde: 077 >########################################Somatoria: 0048 => Qtde: 066 >##################################Somatoria: 0049 => Qtde: 067 >##################################Somatoria: 0050 => Qtde: 047 >########################Somatoria: 0051 => Qtde: 046 >#######################Somatoria: 0052 => Qtde: 046 >#######################Somatoria: 0053 => Qtde: 048 >#########################Somatoria: 0054 => Qtde: 022 >###########Somatoria: 0055 => Qtde: 028 >##############Somatoria: 0056 => Qtde: 019 >#########Somatoria: 0057 => Qtde: 013 >######Somatoria: 0058 => Qtde: 015 >#######Somatoria: 0059 => Qtde: 008 >####Somatoria: 0060 => Qtde: 003 >#Somatoria: 0061 => Qtde: 003 >#Somatoria: 0062 => Qtde: 004 >##Somatoria: 0063 => Qtde: 001 >Somatoria: 0066 => Qtde: 001 >Somatoria: 0067 => Qtde: 001 >Somatoria: 0068 => Qtde: 001 > Filtro: 0018/0019/0020/0022/0023/0024/0025/0026/0027/0028/0029/0030/0031/0032/0033/0034/0035/0036/0037/0038/0039/0040/0041/0042/0043/0044/0045/0046/0047/0048/0049/0050/0051/0052/0053/0054/0055/0056/0057/0058/0059/0060/0061/0062/0063/0066/0067/0068/ Maior incidencia: 39 ocorreu: 96 vezes. Quote Link to comment Share on other sites More sharing options...
sorel Posted September 4, 2015 Share Posted September 4, 2015 o problema é em que posiçao colocar a soma 39 e manter por varios sorteios.entao penso que antes seria o foco de ver uma referencia , um ponto fixo , no centro ou nas extremidades das apostas, senao nao vai adiantar Quote Link to comment Share on other sites More sharing options...
sorel Posted September 5, 2015 Share Posted September 5, 2015 roger1318 , uma forma de ter referencia é assimadap tar na nossa mega sena 60/61. Obter uma lista de todos os números que têm aparecido nos últimos cinco empates.(Eu usei cinco porque a mediana é 5,31 para uma lotaria 6/49, e números aqui repetir mais vezes.) 2.Para todas as permutações possíveis de seis números, manter somente aqueles com a) 3 pares e três números ímpares 3 baixos (1-24) e 3 (25-49) elevados números c) A soma de todos os seis dígitos, sendo entre 149 e 151. 150 (21 + 279) / 2 é o valor médio, e com os totais montagem de uma distribuição normal, 150 é também o modo (mais comum) e média. No entanto, a soma de três uniforme e três números ímpares é estranho, então eu usei 149 e 151. O número de arranjos desce drasticamente, mas ainda havia centenas de diminuir, de modo mais filtros tiveram de ser introduzidas.É algo que eu possa voltar para no futuro como eu fiz obter o sucesso impar, mas o Reino Unido 6/49 loteria é pobre valor se um bilhete de loteria é comprado. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.