('hot dog', 'fat'): 32,
('hot dog', 'sodium'): 1800,
('fries', 'calories'): 380,
('fries', 'protein'): 4,
('fries', 'fat'): 19,
('fries', 'sodium'): 270,
('macaroni', 'calories'): 320,
('macaroni', 'protein'): 12,
('macaroni', 'fat'): 10,
('macaroni', 'sodium'): 930,
('pizza', 'calories'): 320,
('pizza', 'protein'): 15,
('pizza', 'fat'): 12,
('pizza', 'sodium'): 820,
('salad', 'calories'): 320,
('salad', 'protein'): 31,
('salad', 'fat'): 12,
('salad', 'sodium'): 1230,
('milk', 'calories'): 100,
('milk', 'protein'): 8,
('milk', 'fat'): 2.5,
('milk', 'sodium'): 125,
('ice cream', 'calories'): 330,
('ice cream', 'protein'): 8,
('ice cream', 'fat'): 10,
('ice cream', 'sodium'): 180 }
import dietmodel
dietmodel.solve(categories, minNutrition, maxNutrition,
foods, cost, nutritionValues)
('hot dog', 'sodium'): 1800,
('fries', 'calories'): 380,
('fries', 'protein'): 4,
('fries', 'fat'): 19,
('fries', 'sodium'): 270,
('macaroni', 'calories'): 320,
('macaroni', 'protein'): 12,
('macaroni', 'fat'): 10,
('macaroni', 'sodium'): 930,
('pizza', 'calories'): 320,
('pizza', 'protein'): 15,
('pizza', 'fat'): 12,
('pizza', 'sodium'): 820,
('salad', 'calories'): 320,
('salad', 'protein'): 31,
('salad', 'fat'): 12,
('salad', 'sodium'): 1230,
('milk', 'calories'): 100,
('milk', 'protein'): 8,
('milk', 'fat'): 2.5,
('milk', 'sodium'): 125,
('ice cream', 'calories'): 330,
('ice cream', 'protein'): 8,
('ice cream', 'fat'): 10,
('ice cream', 'sodium'): 180
}
import dietmodel
dietmodel.solve(categories, minNutrition, maxNutrition, foods, cost,
nutritionValues)
#!/usr/bin/python
# Copyright 2015, Opalytics, Inc.
# edited with permission from Gurobi Optimization, Inc.
# Separate the model (dietmodel.py) from the data file (dietxlsdata.py), so
# that the model can be solved with different data files.
#
# This file solves the model with the data provided by the Excel file "diet.xls".
# It prints the summary information to the screen, and writes the solution into a
# a "solution.xls" file, overwriting any pre-existing "solution.xls" file.
#
from dietmodel import solve, dataFactory, solutionFactory
import os
# read the data from diet.xls into TicDat object dat
dat = dataFactory.xls.create_tic_dat("diet.xls", freeze_it=True)
solution = solve(dat)
if solution :
print('\nCost: %g' % solution.parameters[0]["totalCost"])
# will write to a solution.xls file, overwriting any pre-existing file
solutionFactory.xls.write_file(solution, "solution.xls", allow_overwrite=True)
else :
print('\nNo solution')
