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

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

#### Attachments

Last edited: