('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')