Compile | Decompile | Upload |
This is the MM source of your spreadsheet, listing the variables ("attributes"), and the equations relating them. Just after you have decompiled the spreadsheet, the attributes will have the same names as the cells, but you can rename them. You can also ask MM to guess their names by looking at adjacent labels.
These are the cell addresses of the attributes.
C10 -> C10 a e f v
C9 -> C9 a e f v
C19 -> C19 a e f v
C8 -> C8 a e f v
C18 -> C18 a e f v
C7 -> C7 a e f v
C17 -> C17 a e f v
C6 -> C6 a e f v
C16 -> C16 a e f v
C26 -> C26 a e f v
C15 -> C15 a e f v
C25 -> C25 a e f v
C14 -> C14 a e f v
C24 -> C24 a e f v
C23 -> C23 a e f v
These are the addresses and contents of text cells that don't take part in the calculations. Just after you have decompiled the spreadsheet, there will be none of these, because MM starts by assuming all cells do take part. However, you can ask it to guess which cells are annotations.
B21 -> "Commentary"
B10 -> "Percentage Change in the Exchange Rate (%)"
B9 -> "Original Quantity of Exports (N#)"
B19 -> "Growth Rate of Exports (%)"
B8 -> "Original Quantity of Imports (N#)"
B18 -> "Growth Rate of Imports (%)"
B7 -> "Price Elasticity of Demand for Exports"
B17 -> "New Current Account (N#)"
B6 -> "Price Elasticity of Demand for Imports"
B16 -> "New Quantity of Exports (N#)"
B26 -> "The current account finishes in -->"
B15 -> "New Quantity of Imports (N#)"
B25 -> "The current account starts in -->"
B4 -> "Input"
B14 -> "Original Current Account (N#)"
B24 -> "The exchange rate is -->"
B23 -> "The Marshall Lerner condition -->"
B2 -> "Marshall - Lerner Condition"
B12 -> "Output"
This is the result of running the spreadsheet.
A | B | C | |
1 | |||
2 | Marshall - Lerner Condition | ||
3 | |||
4 | Input | ||
5 | |||
6 | Price Elasticity of Demand for Imports | 0.4 @ a e f | |
7 | Price Elasticity of Demand for Exports | 1.6 @ a e f | |
8 | Original Quantity of Imports (N#) | 14 @ a e f | |
9 | Original Quantity of Exports (N#) | 8 @ a e f | |
10 | Percentage Change in the Exchange Rate (%) | 0.0 @ a e f | |
11 | |||
12 | Output | ||
13 | |||
14 | Original Current Account (N#) | -6 @ a e f | |
15 | New Quantity of Imports (N#) | 14.0 @ a e f | |
16 | New Quantity of Exports (N#) | 8.0 @ a e f | |
17 | New Current Account (N#) | -6.0 @ a e f | |
18 | Growth Rate of Imports (%) | 0.0 @ a e f | |
19 | Growth Rate of Exports (%) | 0.0 @ a e f | |
20 | |||
21 | Commentary | ||
22 | |||
23 | The Marshall Lerner condition --> | holds @ a e f | |
24 | The exchange rate is --> | depreciating @ a e f | |
25 | The current account starts in --> | deficit @ a e f | |
26 | The current account finishes in --> | deficit @ a e f |
This is the spreadsheet in formula view.
A | B | C | |
1 | |||
2 | Marshall - Lerner Condition | ||
3 | |||
4 | Input | ||
5 | |||
6 | Price Elasticity of Demand for Imports | 0.4 @ a e v | |
7 | Price Elasticity of Demand for Exports | 1.6 @ a e v | |
8 | Original Quantity of Imports (N#) | 14 @ a e v | |
9 | Original Quantity of Exports (N#) | 8 @ a e v | |
10 | Percentage Change in the Exchange Rate (%) | 0.0 @ a e v | |
11 | |||
12 | Output | ||
13 | |||
14 | Original Current Account (N#) | C9+-C8 @ a e v | |
15 | New Quantity of Imports (N#) | C8+(C6*C10) @ a e v | |
16 | New Quantity of Exports (N#) | C9+-(C7*C10) @ a e v | |
17 | New Current Account (N#) | C16+-C15 @ a e v | |
18 | Growth Rate of Imports (%) | ((C8+-C15/C8)*100) @ a e v | |
19 | Growth Rate of Exports (%) | ((C9+-C16/C9)*100) @ a e v | |
20 | |||
21 | Commentary | ||
22 | |||
23 | The Marshall Lerner condition --> | IF((C6+C7>1),"holds","does not hold") @ a e v | |
24 | The exchange rate is --> | IF((C10<1),"depreciating","appreciating") @ a e v | |
25 | The current account starts in --> | IF((C9+-C8<0.0),"deficit","surplus") @ a e v | |
26 | The current account finishes in --> | IF((C17<0.0),"deficit","surplus") @ a e v |
Compile | Decompile | Upload |