- #1
volican
- 41
- 0
To illustrate my problem say I have the following table:
Option, x , y
A , 25 , 30
B , 5 , 12
C , 3 , 9
D, 12, 13
I want to create a graph of every possible combination in the set where the x values are added and the y values are added. For example say it was the combination AB then it would be (x = 25 + 5 , y = 30 + 12). This would become one point on a graph with x and y coordinates (30,42). I am working on the assumption that this is a power set problem. I have created a code to generate the binary table and this works fine when I have less than 15 entries.
In reality I will have 50 options and this I will give 2^50 combinations. My MS Access database that I am writing this to has a maximum capacity of 2GB and it is slow to run. There is definitely scope to improve the efficiency of my code but I am thinking that a fundamental change of tact might be in order but I am not sure how. Any pointers or advice would be much appreciated.
I am really only interested in the outline shape of the scatter from all the plotted points and where one particular point might sit within the context of this outline shape. I am wondering if there is a way that I can work out the shape without running through every possible calculation? Does anyone know if there is a way that I can know what the outline will be without having to do the calculations for all the points in the middle? Also, if not, any ideas for alternative strategies that might work better?
Thank you for your time and help :)
Option, x , y
A , 25 , 30
B , 5 , 12
C , 3 , 9
D, 12, 13
I want to create a graph of every possible combination in the set where the x values are added and the y values are added. For example say it was the combination AB then it would be (x = 25 + 5 , y = 30 + 12). This would become one point on a graph with x and y coordinates (30,42). I am working on the assumption that this is a power set problem. I have created a code to generate the binary table and this works fine when I have less than 15 entries.
In reality I will have 50 options and this I will give 2^50 combinations. My MS Access database that I am writing this to has a maximum capacity of 2GB and it is slow to run. There is definitely scope to improve the efficiency of my code but I am thinking that a fundamental change of tact might be in order but I am not sure how. Any pointers or advice would be much appreciated.
I am really only interested in the outline shape of the scatter from all the plotted points and where one particular point might sit within the context of this outline shape. I am wondering if there is a way that I can work out the shape without running through every possible calculation? Does anyone know if there is a way that I can know what the outline will be without having to do the calculations for all the points in the middle? Also, if not, any ideas for alternative strategies that might work better?
Thank you for your time and help :)