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.
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
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
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"
This is the result of running the spreadsheet.
A | B | C | D | E | F | |
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 demand | 0.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 rental | 1.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 demand | 0.4 @ a e f | ||
10 | Building Regulations (loose, neutral, tight) | neutral @ a e f | price elasticity of supply | 0.8 @ a e f | ||
11 | Output of other sectors (increases, neutral, decreases) | neutral @ a e f | Original Price | 49020.83 @ a e f | ||
12 | Original Quantity | 40016.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 constant | 10 @ a e f | ||||
29 | Output of other sectors constant | 400 @ a e f | ||||
30 | Building regulations constant | 1000 @ a e f | ||||
31 | c (supply curve) | 1000 @ a e f | ||||
32 | e (scaler for land costs) | 0.05 @ a e f |
This is the spreadsheet in formula view.
A | B | C | D | E | F | |
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 demand | 0.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 rental | 1.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 demand | 0.4 @ a e v | ||
10 | Building Regulations (loose, neutral, tight) | "neutral" @ a e v | price elasticity of supply | 0.8 @ a e v | ||
11 | Output of other sectors (increases, neutral, decreases) | "neutral" @ a e v | Original Price | 49020.83 @ a e v | ||
12 | Original Quantity | 40016.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 constant | 10 @ a e v | ||||
29 | Output of other sectors constant | 400 @ a e v | ||||
30 | Building regulations constant | 1000 @ 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 |