L
LunaMoon
Hi all,
Let's say I am collecting data for experiments.
For each experiments, there are a bunch of data I have to collect$B!'(B
1. Parameters;
2. Variables;
3. Results.
Every time I change a few settings and hit the run button, the
experiment will run and the results will be recorded.
How do I efficiently organize the collected data?
Currently, I just copy down a whole bunch of numbers to a 100 x 100
cells in a new sheet.
Every time I run the experiment, the results are copied to the 100x100
cells following the previously recorded many 100x100 cells.
Is this the best way to do such things? I need some productivity
advice...
Then the next step is to visualize the changes, for example, changing
one parameter will lead to what changes in results, this is the key
question I am asking myself.
I hope to be able to draw a line to highlight the changes I've made
from one 100x100 data block to the next 100x100 data block. This is
much like the "trace" feature in formula auditing...
How do I do that using EXCEL/VBA? Is this the best way to visualize
the results of experiments?
Thanks!
Let's say I am collecting data for experiments.
For each experiments, there are a bunch of data I have to collect$B!'(B
1. Parameters;
2. Variables;
3. Results.
Every time I change a few settings and hit the run button, the
experiment will run and the results will be recorded.
How do I efficiently organize the collected data?
Currently, I just copy down a whole bunch of numbers to a 100 x 100
cells in a new sheet.
Every time I run the experiment, the results are copied to the 100x100
cells following the previously recorded many 100x100 cells.
Is this the best way to do such things? I need some productivity
advice...
Then the next step is to visualize the changes, for example, changing
one parameter will lead to what changes in results, this is the key
question I am asking myself.
I hope to be able to draw a line to highlight the changes I've made
from one 100x100 data block to the next 100x100 data block. This is
much like the "trace" feature in formula auditing...
How do I do that using EXCEL/VBA? Is this the best way to visualize
the results of experiments?
Thanks!