How the WPS table implements the Solver calculation

WPS Table implements the method of Solver calculation:

Create a new WPS form file and enter relevant information about product A and b according to the conditions of the problem.

Set a variable cell (equivalent to a free variable), there are two free variables in the argument, so set two variable cells (in order to be obvious, marked with red, can not be marked in normal operation)

Set Target function

Set the first constraint function until all the constraint function settings are complete

Click on the data, click the machine to install automatically, find the condition planning and clicks

Set the target. Click on the red box in the picture, and then click the cell in which you just set the target function.

Sets the variable cells. Click on the red box in the picture, and then click on the location of the changing cells that you just set, if the number of changing cells is two or more, you must press and hold the CTRL key one at a time to click, you can not drag together to select.

Add constraints. Click the "Add" button in the previous step diagram, click on the right yellow box in the image below, and then drag to select the cell (left yellow box) that contains the constraint function you just set, and then click the Red box on the right side of the image below, and then drag to select the cell with the constraint function assignment you just set (the left red box). Finally click OK. (This step can also add the constraint conditions one by one, and the results of the two operations are the same)

Check "make the constraint variable non-negative" (This is a practical problem, ask the constraint variable to be positive), click "Solve"

The results of the calculation have been shown, click "Keep Solver solution", you can leave the solution on the table, and then click "OK" can be.