How to Use WPS Simulation Calculation Sheet on macOS

Last updated:July 16, 2026

Use Simulation Calculation Sheet with 4 operation topics, all available in WPS Spreadsheet; choose a topic from the How-to Index, then follow the steps to set the variable range, formula, and reference cells.

How-to Index

No.TopicMembership Requirement
11. Open the Simulation Calculation Sheet entryFree
22. Prepare the test variables and result areaFree
33. Set up a one-variable simulationFree
44. Set up a two-variable simulationFree

How-to Guide

1. Open the Simulation Calculation Sheet entry

Entry path: Data → What-If Analysis → Simulation Calculation Sheet

  1. Open the WPS spreadsheet file that you want to analyze.
  2. Click the Data tab at the top of the window.
  3. Click the What-If Analysis drop-down menu.
  4. Select Simulation Calculation Sheet from the menu.

Success Criteria

  • Interface result: The Simulation Calculation Sheet settings window opens.
  • Next action available: You can continue to set the row input cell or column input cell.

Tips While Using

  • Common mistake: If you open the feature before selecting the calculation range, you may need to reselect the area later.

2. Prepare the test variables and result area

Entry path: Organize the worksheet first, then go to Data → What-If Analysis → Simulation Calculation Sheet

  1. Arrange the variable data that you want to test in the worksheet.
  2. Enter the corresponding formula in the result cell.
  3. Select the full calculation range that includes the test variables and result cell.
  4. Make sure the selected range includes the formula cell and all variable values needed for the calculation.

Success Criteria

  • Interface result: The full calculation range is selected.
  • Next action available: You can open the Simulation Calculation Sheet window and set parameters.

Tips While Using

  • Common mistake: Missing the formula cell or some variable values can affect the filled result range.

3. Set up a one-variable simulation

Entry path: After selecting the range, go to Data → What-If Analysis → Simulation Calculation Sheet

  1. Open the Simulation Calculation Sheet window.
  2. Check whether the test variable is arranged by column or by row.
  3. If the variable list is in a column, click Column input cell, then select the variable cell used in the formula.
  4. If the variable list is in a row, select Row input cell.
  5. Click OK to start the calculation.

Success Criteria

  • Interface result: The output area is filled with one-variable results.
  • Next action available: You can adjust variable values and analyze again.

Tips While Using

  • Common mistake: Reversing the row input cell and column input cell can produce unexpected results.

4. Set up a two-variable simulation

Entry path: After selecting the range, go to Data → What-If Analysis → Simulation Calculation Sheet

  1. Open the Simulation Calculation Sheet window.
  2. Prepare a combination test area for two variables.
  3. Set the Row input cell in the dialog box.
  4. Set the Column input cell.
  5. Confirm that the two references match the two variables used in the formula.
  6. Click OK and wait for WPS to calculate all combination results automatically.

Success Criteria

  • Interface result: The selected output area shows the two-variable combination results.
  • Next action available: You can review, compare, or continue analyzing the result area.

Tips While Using

  • Common mistake: If both input references point to the same variable cell, the combination analysis will not reflect two different variables.