bdl004
08-02-2010, 03:47 AM
Hi guys,
I am having some trouble coming up with a code to do compare sets of data against a reference set to choose appropriate running conditions for a fan. I have a variable number of parameters (usually around 4 but it changes) called Temperature, Pressure, VG, and TG (and more sometimes).
What I need to do is to declare a set of "n" arrays depending on the number of parameters. These arrays are 2 dimensional. For example, if there are 4 parameters, I need the program to define 4 arrays, 5 parameters, 5 arrays, etc. I do not want to use a 3d array because I have massive amounts of data (exceeds excel's memory -- I am running excel 2000).
Is this possible?
Thanks in advance!
I am having some trouble coming up with a code to do compare sets of data against a reference set to choose appropriate running conditions for a fan. I have a variable number of parameters (usually around 4 but it changes) called Temperature, Pressure, VG, and TG (and more sometimes).
What I need to do is to declare a set of "n" arrays depending on the number of parameters. These arrays are 2 dimensional. For example, if there are 4 parameters, I need the program to define 4 arrays, 5 parameters, 5 arrays, etc. I do not want to use a 3d array because I have massive amounts of data (exceeds excel's memory -- I am running excel 2000).
Is this possible?
Thanks in advance!