#### Using “Multiple Operations” feature in Lotus Symphony 3 Spreadsheet

##### YiXuan Liu, Software Engineer  |  Aug 5, 2010 5:27 AM
Multiple Operations is a powerful tool for data calculation in Lotus Symphony 3, which could give a formula result automatically when one or two variables change. Below is an example to see how Multiple Operations feature can be used.

The Problem:

There is a product A. We know the cost price and selling price of each product, the storage fee of one year, and the selling quantity, as Figure 1 shows.

The questions are:

Question 1: What is the profit with different quantity?

Question 2: What is the profit with different quantity and different cost price of each product?

Solution with Multiple Operations

Question 1.

Step-1 Give the profit formula.

Profit=Quantity * (Selling price – Cost price) – Storage Fee. Enter this formula in B5 := =B4*(B2-B1)-B3. (Figure 2)

Step-2 Put different quantities in Column D. (Figure 3)

Step-3 Choose D1:E6 and Choose “Data->Multiple Operations...” to open Multiple Operations. (Figure 4)

1. Our goal is to compute the profit as B5. So, set “Formulas” as “B5”

2. Since the quantity variables are put in a column, “Row input cell” should be blank.

3. Quantity is the variable in the profit formula, and “B4” in the original formula will be substituted by new values, so set “Column input cell” as “B4”.

Step-4. Click OK, and results will be shown in Column E. (Figure 5)

Question 2.

Now we have two variables(quantity and cost price per product) in the formula.

Step 1 is the same as question 1.

Step-2. New values of these two variables should be put in column and row respectively. (Figure 6)

Step-3. D1:G7 should be chosen. And “Row input cell” is useful in this situation, which should be set as “B1”. (Figure 7)

Step 4. The results are shown in E2:G7. (Figure 8)

Currently, only two variables are supported by “Multiple Operations” in symphony. Despite this limitation, Multiple Operations feature still makes calculation easy and efficient. Try it!

• Law said on Sep 13, 2010 6:58 PM:

Interesting.. going to try this
• David said on Nov 24, 2010 12:18 AM:

Usefully! Thanks