Visualizing ranges of 3 parameters with 6 variables

01mercy

Involved In Discussions
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

Attachments

• 26 KB Views: 142
Last edited:

Miner

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

01mercy

Involved In Discussions
Hi miner,

(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

Involved In Discussions
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

Mikael

Quite Involved in Discussions
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

Involved In Discussions

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

Regards.

Visualizing Sigma Imported Legacy Blogs 1
Visualizing "Answer People" In Online Discussions After Work and Weekend Discussion Topics 17
Proficiency Testing for ISO 17025: AC Current Ranges ISO 17025 related Discussions 1
MSA Type 1 - Cg and Cgk ranges Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
Should calibration range of Oscilloscope cover the test ranges? General Measurement Device and Calibration Topics 8
Calibration and Tolerance Ranges of Pressure Gages General Measurement Device and Calibration Topics 8
M Setting Solid Dose Drug Fill Count Ranges Pharmaceuticals (21 CFR Part 210, 21 CFR Part 211 and related Regulations) 8
M Establishing Ranges for Weights for Calibration Verification of a Micro-Balance Calibration Frequency (Interval) 1
D ISO Team Size ranges, anyone? Misc. Quality Assurance and Business Systems Related Topics 9
D Internal Laboratory Scope - Ranges for Measurement Tools Specified? General Measurement Device and Calibration Topics 8
J Finding standard deviation of ranges in Minitab Using Minitab Software 5
M Gage R&R (Ranges Method) - Reproducibility standard deviation Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 4
Supplier wants to perform pre-qualifications prior to every run instead of locking in parameters. Supplier Quality Assurance and other Supplier Issues 7
IEC 60601-2-10 - Accuracy of Pulse Parameters - Required Measurement Uncertainty IEC 60601 - Medical Electrical Equipment Safety Standards Series 3
B WEDM Taguchi and Anova Analysis - L16 array with 5 parameters at 4 levels Manufacturing and Related Processes 5
Quality of Potable Water Testing Parameters during Purified Water Validation Qualification and Validation (including 21 CFR Part 11) 1
E IEC 60601-2-57 item 201.12.4.2 - Indication of parameters relevant to safety IEC 60601 - Medical Electrical Equipment Safety Standards Series 0
N Regression Model (Minitab 18) - Which values my input parameters should have Using Minitab Software 2
M AS9100 D 8.3.4.1 a - Parameters to be recorded" - What is this asking for? AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 3
Insights on Transactional Ticket Audits such Parameters, Weighting Points, etc ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 2
ISO 11135 Monitoring Routine ETO Sterilisation Parameters Other Medical Device Related Standards 3
Process Capability for parameters with non-normal distribution. Capability, Accuracy and Stability - Processes, Machines, etc. 16
D minitab macro to pull access query with parameters Using Minitab Software 1
MSA for gaging which specifies process parameters and 7.6.1 Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 4
L How do you specify your receiving inspection parameters? Misc. Quality Assurance and Business Systems Related Topics 2
T What to do if parameters are found to be Outside of Control Limits Document Control Systems, Procedures, Forms and Templates 5
Testing software-only device on hardware - What are the hardware parameters? Software Quality Assurance 6
M New Calibration Laboratory Set Up Measurement Parameters and Equipment General Measurement Device and Calibration Topics 4
P MSA requirements for Systems that Measure Process Parameters Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
Problem with the Classification of the Process Parameters IATF 16949 - Automotive Quality Systems Standard 6
K Data Analysis of Milk Composition (Seven Parameters like Protein, Fat, Lactose, etc.) Using Minitab Software 18
R Which parameters to be addressed in Control Plan from FMEA? FMEA and Control Plans 2
R How to assess capability for parameters which has got either Min values or Max values Statistical Analysis Tools, Techniques and SPC 2
M The General Parameters of IQ, OQ & PQ - Depyrogenation Tunnels and Autoclaves General Measurement Device and Calibration Topics 2
A Comparing Effect of Process Parameters on Equipment Performance during Start Ups Statistical Analysis Tools, Techniques and SPC 3
SPC for Metal Foundry Parameters like Metal Temperature, Sand Moisture Statistical Analysis Tools, Techniques and SPC 5
N Different Distribution Parameters when analyzing the same data in different ways Using Minitab Software 8
R Analysis of Welding Parameters - Can Taguchi methods provide equation? Using Minitab Software 11
The approach/criteria of setting Acceptance Limits Method Validation Parameters Statistical Analysis Tools, Techniques and SPC 1
P General Parameters to Approve Supplier ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 6
Hoffman Scratch Hardness Test - General Parameters for Pass/Fail (Paint Coatings) Inspection, Prints (Drawings), Testing, Sampling and Related Topics 1
TS 16949 Process Capability Requirements - Cpk ≥ 1.67 on All Key Parameters? IATF 16949 - Automotive Quality Systems Standard 8
J Critical Process Parameters vs. Critical Performance Parameters - Definitions Qualification and Validation (including 21 CFR Part 11) 2
O Correlation of 2 Test Devices - 2 samples (13 parameters) Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 6
D Problems with DOE - Different levels in parameters of a full factorial experiment Using Minitab Software 1
M True Position of a Hole Capabilty - Appropriate parameters to use Capability, Accuracy and Stability - Processes, Machines, etc. 5
Equipment Parameters in Control Plan? IATF 16949 - Automotive Quality Systems Standard 4
Process Parameters in Textile Lamination Manufacturing and Related Processes 2
D Subjective parameters and Quality costs - VDA 16 IATF 16949 - Automotive Quality Systems Standard 6
Process Specifications and Control Parameters Document Control Systems, Procedures, Forms and Templates 4