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 <
B1 // @ e f v
B4 // @ e f v
B5 // @ e f v
B6 // @ e f v
B7 // @ e f v
B8 // @ e f v
B9 // @ e f v
B10 // @ e f v
B11 // @ e f v
B14 // @ e f v
B16 // @ e f v
B17 // @ e f v
B22 // @ e f v
B24 // @ e f v
B25 // @ e f v
B27 // @ e f v
B28 // @ e f v
B29 // @ e f v
B30 // @ e f v
B31 // @ e f v
B32 // @ e f v
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
E5 // @ e f v
E6 // @ e f v
E7 // @ e f v
E8 // @ e f v
E9 // @ e f v
E10 // @ e f v
E11 // @ e f v
E12 // @ e f v
E16 // @ e f v
E17 // @ 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
B29="Output of other sectors constant" // @ a f v
B28="population constant" // @ a f v
B27="a (demand curve constant)" // @ a f v
B25="Output of other sectors (increases, neutral, decreases)" // @ a f v
B24="Building Regulations (loose, neutral, tight)" // @ a f v
B9="Cost of Land (N# per hectare)" // @ a f v
B22="Working Area - DO NOT CHANGE !!!!!" // @ a f v
B8="Rental Prices (N#)" // @ a f v
B7="Population (millions)" // @ a f v
B6="Interest Rate (%)" // @ a f v
B5="Household Income (N#)" // @ a f v
B4="Input Area" // @ a f v
B1="Determination of the Price and Quantity within the Housing Market" // @ a f v
E9="price elasticity of demand" // @ a f v
E8="sensitivity to cost of land (%)" // @ a f v
E7="CPED with rental" // @ a f v
E6="sensitivity to interest rate (%)" // @ a f v
E5="Income elasticity of demand" // @ a f v
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
B17="Quantity =" // @ a f v
F10=0.8 // @ a f v
B16="Price (N#) =" // @ a f v
B14="Output Area" // @ a f v
B11="Output of other sectors (increases, neutral, decreases)" // @ a f v
B10="Building Regulations (loose, neutral, tight)" // @ 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
B32="e (scaler for land costs)" // @ a f v
B31="c (supply curve)" // @ a f v
C8=650 // @ a f v
B30="Building regulations constant" // @ a f v
C7=56 // @ a f v
E17="Quantity (% change)" // @ a f v
C6=6 // @ a f v
E16="Price (% change)" // @ 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
E12="Original Quantity" // @ a f v
E11="Original Price" // @ a f v
F9=0.4 // @ a f v
E10="price elasticity of supply" // @ 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.
B1 -> B1 a e f v
B11 -> B11 a e f v
C11 -> C11 a e f v
B31 -> B31 a e f v
C31 -> C31 a e f v
E11 -> E11 a e f v
F11 -> F11 a e f v
B10 -> B10 a e f v
C10 -> C10 a e f v
B30 -> B30 a e f v
C30 -> C30 a e f v
E10 -> E10 a e f v
F10 -> F10 a e f v
B9 -> B9 a e f v
C9 -> C9 a e f v
B29 -> B29 a e f v
E9 -> E9 a e f v
C29 -> C29 a e f v
F9 -> F9 a e f v
B8 -> B8 a e f v
C8 -> C8 a e f v
B28 -> B28 a e f v
E8 -> E8 a e f v
C28 -> C28 a e f v
F8 -> F8 a e f v
B7 -> B7 a e f v
C7 -> C7 a e f v
B17 -> B17 a e f v
B27 -> B27 a e f v
C17 -> C17 a e f v
E7 -> E7 a e f v
C27 -> C27 a e f v
F7 -> F7 a e f v
E17 -> E17 a e f v
F17 -> F17 a e f v
B6 -> B6 a e f v
C6 -> C6 a e f v
B16 -> B16 a e f v
C16 -> C16 a e f v
E6 -> E6 a e f v
F6 -> F6 a e f v
E16 -> E16 a e f v
F16 -> F16 a e f v
B5 -> B5 a e f v
C5 -> C5 a e f v
B25 -> B25 a e f v
E5 -> E5 a e f v
C25 -> C25 a e f v
F5 -> F5 a e f v
B4 -> B4 a e f v
B14 -> B14 a e f v
B24 -> B24 a e f v
C24 -> C24 a e f v
B22 -> B22 a e f v
B32 -> B32 a e f v
C32 -> C32 a e f v
E12 -> E12 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.
This is the result of running the spreadsheet.
This is the spreadsheet in formula view.
Compile | Decompile | Upload |