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!

I would imagine that this would best be accomplished in Access, rather than
Excel, but if you want to do it in Excel:

I would set this up with a column for each
1. Parameters
2. Variables
3. Results
and maybe the date you ran the experiment? Make sure to have separate
columns for each setting, with a True/False or Yes/No, unless it can only
have one setting among a group, in which case make a "Setting" column and
write the name down.

How are you copying your numbers down? Are you using a macro, or are you
typing in this data?

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 would use a PivotTable here so that you can compare several different
results possibly using a PivotChart.

Hope this helps (I'm unfortunately quite vague though)