About:

This tool finds the combination of items in column 1 which minimizes/maximizes the sum of values in column 2 and which characteristics listed from column 4 to N fall between the ranges specified in table 2.

Example: Find the diet with the minimum cost which provides the right amount of nutrients to be healthy.

Instructions:

  1. Download the template.
  2. Replace data, add or remove rows and columns of the main table.
  3. Keep one empty row between the two tables, do not add more rows to the second table and the number of columns after the 4th column should match in both tables.
Example CSV:
Download

The CSV file