Compile Decompile Upload

Program

Source

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.

attributes <
  C6 // @ e f v
  C7 // @ e f v
  C8 // @ e f v
  C9 // @ e f v
  C10 // @ e f v
  C14 // @ e f v
  C15 // @ e f v
  C16 // @ e f v
  C17 // @ e f v
  C18 // @ e f v
  C19 // @ e f v
  C23 // @ e f v
  C24 // @ e f v
  C25 // @ e f v
  C26 // @ e f v
>
where
  C26=IF((C17<0.0),"deficit","surplus") // @ a f v
  C25=IF((C9+-C8<0.0),"deficit","surplus") // @ a f v
  C24=IF((C10<1),"depreciating","appreciating") // @ a f v
  C23=IF((C6+C7>1),"holds","does not hold") // @ a f v
  C9=8 // @ a f v
  C8=14 // @ a f v
  C7=1.6 // @ a f v
  C19=((C9+-C16/C9)*100) // @ a f v
  C6=0.4 // @ a f v
  C18=((C8+-C15/C8)*100) // @ a f v
  C17=C16+-C15 // @ a f v
  C16=C9+-(C7*C10) // @ a f v
  C15=C8+(C6*C10) // @ a f v
  C14=C9+-C8 // @ a f v
  C10=0.0 // @ a f v

Addresses

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

Annotations

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"

Evaluated

This is the result of running the spreadsheet.

 ABC
1   
2 Marshall - Lerner Condition 
3   
4 Input 
5   
6 Price Elasticity of Demand for Imports0.4
@ a e f
7 Price Elasticity of Demand for Exports1.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

Formulae

This is the spreadsheet in formula view.

 ABC
1   
2 Marshall - Lerner Condition 
3   
4 Input 
5   
6 Price Elasticity of Demand for Imports0.4
@ a e v
7 Price Elasticity of Demand for Exports1.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
#!void