![]() We check the box labelled ’ Make Unconstrained Variables Non-Negative’ to make sure colorants can only be added. In the ‘ Set Objective’ field, the cell that needs to be minimized is indicated, and in the field ‘ By Changing Variable Cells’ the concentration of the colorants to add are indicated by Correction. ![]() With the Data/Solver function of Excel, the following screen pops up. And, therefore, the differences before and after the optimization are the same. Because the correction additions of this second table are zero when we start, their influences are also zero. We need the 1% tinting table and the dL, da, and db differences under three light sources of the batch compared with the standard. Let’s start by using the Solver in Excel. ![]() Now how can we use Excel to calculate the best additions and taking this intricate play of color influences into account? ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |