Visualizing ranges of 3 parameters with 6 variables

[01mercy]

Hi all

I have quite a challenge here.

I have 6 materials which can be present in different % in a product.
From the product the colour space l.a.b. values are determined.

We've made a rough lineair model for each of the materials effect on the L, a and b value. This is not totally correct because the materials will influence eachother but it's a rough model to work with.

We want to make product within certain limits of the L, a and b value.
I can now use the solver in excel to find the optima of material compositions that will give the L, a and b values within these restriction.

The challenge now is to visualize in someway the ranges of the L, a and b values that we can work with, within the model.

I have attached an excel file showing the numerical model.

Thanks a lot for suggestions

 

[Miner]

Were these results from a designed experiment? I can probably assist, but am having difficultly understanding the experimental design.

 

[01mercy]

Hi miner,

Thank you for your reply.
(I have updated the file, there was a small flaw in the calculations)

The case is that we have 6 materials that are mixed into a product.
The target values that we need to obtain for the L, a and b value are on top.
Material 1 is the predominant base material where the others are mixed in.

For each material we tested the 100% L, a and b values.
For 0% of each material we set the L, a and b values to the base material.

From this we drawn a lineair model for each material for each value measured.
Eventually I used the lineair model for each material to add everything together and calculate the final L, a or b value in a mix.
The L value is an exception to this, because this is also corrected for the diminishing of the base material in the mix.

If you want I can write out the formulas used for the mix to calculate the L, a and b value.

Rgds.

 

[01mercy]

Hi all,

After some hard searching on I-net I came across the Mathematics add-in from MS. I was quite suprised that MS had an upgrade on their math add-in and I didn't know of it.

Anyway, eventhough I can't tweak around the naming of the axis from the inserted pictures this tool generates. It does let me animate the effect of other parameters in the formula beside what I designate for x, y and z. So if I have more variables in the the formula, lets say a, b, c and d than I can real time set the range of that parameter and play with the number and see what the graph does when I change the number.

This lets me set hard on the x and y axis 2 variables and the outcome on the z, the other variables I can tweak around from the list the comes with the graph.
I must say.... allthough the formatting options leaves some improvement, this is the only tool that I came across which lets me analyse a graph with multiple variables and being able to see the effect of changing them in the graph.

If anyone has more handsome tools that generate graphs that make it easy to see what more variable do other than 2 variables, I would love to hear of it.

Rgds

(broken link removed)

 

[Mikael]

Hi interesting, though I am not sure that I understand your visualization problem. Perhaps you could make a screen shoot of some dummy data? I work with BI tools like QlikView and Qlik Sense, which are very interactive, but not so optimized out of the box for advanced statistics, though there is a lot of other tools out there too.

 

[01mercy]

Hi thanks for your reply and suggestion on other software.

The MS formula tool help out at my work so it was good enough to visualize.

Regards.