Use Excel Solver to optimize values, balance constraints
https://wiki.robotrage.pro/index.php/Excel_Functions_You%E2%80%99ll_Use_Every_Day
Use Excel Solver to optimize values, balance constraints, and find the best solution for budgeting or production planning.