Number Of Combinations, comparison to data table plus outcome reporting
$100-500 USD
Dibatalkan
Dibuat sekitar 15 tahun yang lalu
$100-500 USD
Dibayar ketika dikirim
The program compares an excel spread sheet containing numerious rows of numbers with the possible (pre-definable )number combinations of a pool of numbers that have been defined by the user.
Once the combination calculations and comparison is run for each line of numbers the program reports how nany numbers in the combination match the numbers in the line of numbers from the excel spreadsheet.?
The program then goes to the next line of the spread sheet and runs the same process, etc untill the end of the? data in the spreadsheed.?
A summary of the comparison is then presented (details to follow)?
Operational eg
The user will browse and up load a file containing numerious rows of data
for comparison to.
the user will be prompted to enter the number of numbers in the pool
EG 72...
NEXT
72 Boxes will then appear.
NEXT
The user will then enter a number in each box.
NEXT
The program will then split the numbers into pairs in this case 36 pairs of 2 numbers? (half Number in pool, in? this case "72")
The program will add up? each number pair to produce 36 numbers.
These numbers will then be compared to the first row of data in the spreadsheet uploaded and the number of matching numbers reported? on.
All possible pair combinations of the 72 numbers will be then be generated?
and each time compared to the first row of data in the spreadsheet.?
The number of comparisons on each combination are recorded eg 26/72 . Lets asume that there were 1000 pair combinations of the 72 numbers, the reporting displayed beside the? first line of imported data may look like this.
Combinations with? "X"? matching those generated? ? 72 matchs =[ 45]
72 Matches? =1
71 Matches =3
70 Matches = 7
etc
23 Matches = 342
etc
1 Match = 1000
Once data line one has been reported on, the possible combinations are compared to the second line of the data table and so on untill the end of the data.
some sort of confirmation at the end of report eg number of possible combinations form 72 pairs =X?
200,000? lines of data compared.
results then outputted / displayed
See attached file for example. Any questions , flee free to ask
Thanks for Looking!
Henry