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 <
  C5 // @ e f v
  C6 // @ e f v
  C7 // @ e f v
  C8 // @ e f v
  C9 // @ e f v
  C10 // @ e f v
  C11 // @ e f v
  C16 // @ e f v
  C17 // @ e f v
  C24 // @ e f v
  C25 // @ e f v
  C27 // @ e f v
  C28 // @ e f v
  C29 // @ e f v
  C30 // @ e f v
  C31 // @ e f v
  C32 // @ e f v
  F5 // @ e f v
  F6 // @ e f v
  F7 // @ e f v
  F8 // @ e f v
  F9 // @ e f v
  F10 // @ e f v
  F11 // @ e f v
  F12 // @ e f v
  F16 // @ e f v
  F17 // @ e f v
>
where
  C32=0.05 // @ a f v
  C31=1000 // @ a f v
  C30=1000 // @ a f v
  F17=((C17+-F12/F12)*100) // @ a f v
  F16=((C16+-F11/F11)*100) // @ a f v
  F12=40016.67 // @ a f v
  F11=49020.83 // @ a f v
  F10=0.8 // @ a f v
  C29=400 // @ a f v
  C28=10 // @ a f v
  C27=45000 // @ a f v
  C25=IF((C11="neutral"),0.0,IF((C11="decreases"),-10,10)) // @ a f v
  C24=IF((C10="neutral"),0.0,IF((C10="loose"),-10,10)) // @ a f v
  C9=4000 // @ a f v
  C8=650 // @ a f v
  C7=56 // @ a f v
  C6=6 // @ a f v
  C5=15000 // @ a f v
  C17=C27+-(F9*C16)+(C5*F5)+-(F6*C6)+(C7*C28)+(C8*F7) // @ a f v
  C16=(C27+(F5*C5)+-(F6*C6)+(C7*C28)+(C8*F7)+-C31+(C25*C29)+(C9*C32)+(C24*C30)/F9+F10) // @ a f v
  F9=0.4 // @ a f v
  F8=30 // @ a f v
  F7=1.1 // @ a f v
  C11="neutral" // @ a f v
  F6=25 // @ a f v
  C10="neutral" // @ a f v
  F5=0.9 // @ a f v

Addresses

These are the cell addresses of the attributes.

C11 -> C11 a e f v
C31 -> C31 a e f v
F11 -> F11 a e f v
C10 -> C10 a e f v
C30 -> C30 a e f v
F10 -> F10 a e f v
C9 -> C9 a e f v
C29 -> C29 a e f v
F9 -> F9 a e f v
C8 -> C8 a e f v
C28 -> C28 a e f v
F8 -> F8 a e f v
C7 -> C7 a e f v
C17 -> C17 a e f v
C27 -> C27 a e f v
F7 -> F7 a e f v
F17 -> F17 a e f v
C6 -> C6 a e f v
C16 -> C16 a e f v
F6 -> F6 a e f v
F16 -> F16 a e f v
C5 -> C5 a e f v
C25 -> C25 a e f v
F5 -> F5 a e f v
C24 -> C24 a e f v
C32 -> C32 a e f v
F12 -> F12 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.

B1 -> "Determination of the Price and Quantity within the Housing Market"
B11 -> "Output of other sectors (increases, neutral, decreases)"
B31 -> "c (supply curve)"
E11 -> "Original Price"
B10 -> "Building Regulations (loose, neutral, tight)"
B30 -> "Building regulations constant"
E10 -> "price elasticity of supply"
B9 -> "Cost of Land (N# per hectare)"
B29 -> "Output of other sectors constant"
E9 -> "price elasticity of demand"
B8 -> "Rental Prices (N#)"
B28 -> "population constant"
E8 -> "sensitivity to cost of land (%)"
B7 -> "Population (millions)"
B17 -> "Quantity ="
B27 -> "a (demand curve constant)"
E7 -> "CPED with rental"
E17 -> "Quantity (% change)"
B6 -> "Interest Rate (%)"
B16 -> "Price (N#) ="
E6 -> "sensitivity to interest rate (%)"
E16 -> "Price (% change)"
B5 -> "Household Income (N#)"
B25 -> "Output of other sectors (increases, neutral, decreases)"
E5 -> "Income elasticity of demand"
B4 -> "Input Area"
B14 -> "Output Area"
B24 -> "Building Regulations (loose, neutral, tight)"
B22 -> "Working Area - DO NOT CHANGE !!!!!"
B32 -> "e (scaler for land costs)"
E12 -> "Original Quantity"

Evaluated

This is the result of running the spreadsheet.

 ABCDEF
1 Determination of the Price and Quantity within the Housing Market    
2      
3      
4 Input Area    
5 Household Income (N#)15000
@ a e f
 Income elasticity of demand0.9
@ a e f
6 Interest Rate (%)6
@ a e f
 sensitivity to interest rate (%)25
@ a e f
7 Population (millions)56
@ a e f
 CPED with rental1.1
@ a e f
8 Rental Prices (N#)650
@ a e f
 sensitivity to cost of land (%)30
@ a e f
9 Cost of Land (N# per hectare)4000
@ a e f
 price elasticity of demand0.4
@ a e f
10 Building Regulations (loose, neutral, tight)neutral
@ a e f
 price elasticity of supply0.8
@ a e f
11 Output of other sectors (increases, neutral, decreases)neutral
@ a e f
 Original Price49020.83
@ a e f
12    Original Quantity40016.67
@ a e f
13      
14 Output Area    
15      
16 Price (N#) =49020.83333333333
@ a e f
 Price (% change)6.79983045316953E-6
@ a e f
17 Quantity =40016.66666666667
@ a e f
 Quantity (% change)-8.32986184691646E-6
@ a e f
18      
19      
20      
21      
22 Working Area - DO NOT CHANGE !!!!!    
23      
24 Building Regulations (loose, neutral, tight)0.0
@ a e f
   
25 Output of other sectors (increases, neutral, decreases)0.0
@ a e f
   
26      
27 a (demand curve constant)45000
@ a e f
   
28 population constant10
@ a e f
   
29 Output of other sectors constant400
@ a e f
   
30 Building regulations constant1000
@ a e f
   
31 c (supply curve)1000
@ a e f
   
32 e (scaler for land costs)0.05
@ a e f
   

Formulae

This is the spreadsheet in formula view.

 ABCDEF
1 Determination of the Price and Quantity within the Housing Market    
2      
3      
4 Input Area    
5 Household Income (N#)15000
@ a e v
 Income elasticity of demand0.9
@ a e v
6 Interest Rate (%)6
@ a e v
 sensitivity to interest rate (%)25
@ a e v
7 Population (millions)56
@ a e v
 CPED with rental1.1
@ a e v
8 Rental Prices (N#)650
@ a e v
 sensitivity to cost of land (%)30
@ a e v
9 Cost of Land (N# per hectare)4000
@ a e v
 price elasticity of demand0.4
@ a e v
10 Building Regulations (loose, neutral, tight)"neutral"
@ a e v
 price elasticity of supply0.8
@ a e v
11 Output of other sectors (increases, neutral, decreases)"neutral"
@ a e v
 Original Price49020.83
@ a e v
12    Original Quantity40016.67
@ a e v
13      
14 Output Area    
15      
16 Price (N#) =(C27+(F5*C5)+-(F6*C6)+(C7*C28)+(C8*F7)+-C31+(C25*C29)+(C9*C32)+(C24*C30)/F9+F10)
@ a e v
 Price (% change)((C16+-F11/F11)*100)
@ a e v
17 Quantity =C27+-(F9*C16)+(C5*F5)+-(F6*C6)+(C7*C28)+(C8*F7)
@ a e v
 Quantity (% change)((C17+-F12/F12)*100)
@ a e v
18      
19      
20      
21      
22 Working Area - DO NOT CHANGE !!!!!    
23      
24 Building Regulations (loose, neutral, tight)IF((C10="neutral"),0.0,IF((C10="loose"),-10,10))
@ a e v
   
25 Output of other sectors (increases, neutral, decreases)IF((C11="neutral"),0.0,IF((C11="decreases"),-10,10))
@ a e v
   
26      
27 a (demand curve constant)45000
@ a e v
   
28 population constant10
@ a e v
   
29 Output of other sectors constant400
@ a e v
   
30 Building regulations constant1000
@ a e v
   
31 c (supply curve)1000
@ a e v
   
32 e (scaler for land costs)0.05
@ a e v
   
Compile Decompile Upload
#!void