Description: 利用ecxel中vba计算了时间序列谱分析，具有很好指导意义对于使用vba编程者来说-Ecxel in vba calculated using the time series spectrum analysis, an excellent guide for programmers who use vba Platform: |
Size: 538624 |
Author:guowenxian |
Hits:
Description: three udf function
This is a real single point crossover function for genetic algorithm based projects
under vb.net or excel vba
usage
a1=crosover(a1, b1, m, 1)
b1 = crosover(a1, b1, m, 2)
crossover with a1 and b1 are strings, m is a random number between len(a1) or len(b1)
b1 = crosover(a1, b1, m, 2) crossover b1 and a1 are strings, m is a random number between len(a1) or len(b1)
The second is a mutation function
The third function converts decimal to binary
with the given digit.
example
decimal(2)=binary(10) normal eveybody can write so function
my function will show the binary with n digit if n=20
DECTOBINDI(2, 20)=00000000000000000010
It can be used to write genetic algorithm based functions
Finally normal function decto bin to understand differencases. -three udf function
This is a real single point crossover function for genetic algorithm based projects
under vb.net or excel vba
usage
a1=crosover(a1, b1, m, 1)
b1 = crosover(a1, b1, m, 2)
crossover with a1 and b1 are strings, m is a random number between len(a1) or len(b1)
b1 = crosover(a1, b1, m, 2) crossover b1 and a1 are strings, m is a random number between len(a1) or len(b1)
The second is a mutation function
The third function converts decimal to binary
with the given digit.
example
decimal(2)=binary(10) normal eveybody can write so function
my function will show the binary with n digit if n=20
DECTOBINDI(2, 20)=00000000000000000010
It can be used to write genetic algorithm based functions
Finally normal function decto bin to understand differencases. Platform: |
Size: 3072 |
Author:falacal |
Hits:
Search - genetic algorithm excel vba