Excel Sheets with Automated Calculations
Budget: $30 – $250 AUD
SHEET 1
I need an Excel sheet that I can enter 15 different groups of 3 numbers (45 numbers total) into a table. Their will be 10 sets (tables) in total. After I enter each group i.e enter numbers the script will show every permutation to fit the 15 sets into 2 sets (105 permutations total) i.e (1,2), (1,3)(1,4)....(14,15) it will show the numbers for each group in each table i.e if Table 1 has group as 1,5,8 in Group 2 as 2,11,19 then the permutation of group one and two will be 1,5, 8, 2,11,19 so it will group each table into all permutations of the 15 groups 105 sets of six numbers. The script will have 10 tables but will work with any amount of tables with input ie any amount between 1 and 10 and will show results for each.
SHEET2
I will enter any six numbers into an input box and the sheet will highlight any matching numbers in each set of six on sheet . On the right of each set it will show the number of numbers that match each set of 6 so we are basically testing the input set of 6 we generated in sheet 1. Example if we input the numbers 1,4,7,9,19,24 and set 1 is,1,4,6,7,9,11,12 it would highlight 1,4,7,9 and have 4 to the right of the set because there are 4 matching numbers and it will do this for all sets generated in sheet 1.
I need an Excel sheet that I can enter 15 different groups of 3 numbers (45 numbers total) into a table. Their will be 10 sets (tables) in total. After I enter each group i.e enter numbers the script will show every permutation to fit the 15 sets into 2 sets (105 permutations total) i.e (1,2), (1,3)(1,4)....(14,15) it will show the numbers for each group in each table i.e if Table 1 has group as 1,5,8 in Group 2 as 2,11,19 then the permutation of group one and two will be 1,5, 8, 2,11,19 so it will group each table into all permutations of the 15 groups 105 sets of six numbers. The script will have 10 tables but will work with any amount of tables with input ie any amount between 1 and 10 and will show results for each.
SHEET2
I will enter any six numbers into an input box and the sheet will highlight any matching numbers in each set of six on sheet . On the right of each set it will show the number of numbers that match each set of 6 so we are basically testing the input set of 6 we generated in sheet 1. Example if we input the numbers 1,4,7,9,19,24 and set 1 is,1,4,6,7,9,11,12 it would highlight 1,4,7,9 and have 4 to the right of the set because there are 4 matching numbers and it will do this for all sets generated in sheet 1.