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.

These are the cell addresses of the attributes.

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.

Evaluated

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 @ a e f 2 3 4 Input Area @ a e f 5 Household Income (N#) @ a e f 15000 @ a e f Income elasticity of demand @ a e f 0.9 @ a e f 6 Interest Rate (%) @ a e f 6 @ a e f sensitivity to interest rate (%) @ a e f 25 @ a e f 7 Population (millions) @ a e f 56 @ a e f CPED with rental @ a e f 1.1 @ a e f 8 Rental Prices (N#) @ a e f 650 @ a e f sensitivity to cost of land (%) @ a e f 30 @ a e f 9 Cost of Land (N# per hectare) @ a e f 4000 @ a e f price elasticity of demand @ a e f 0.4 @ a e f 10 Building Regulations (loose, neutral, tight) @ a e f neutral @ a e f price elasticity of supply @ a e f 0.8 @ a e f 11 Output of other sectors (increases, neutral, decreases) @ a e f neutral @ a e f Original Price @ a e f 49020.83 @ a e f 12 Original Quantity @ a e f 40016.67 @ a e f 13 14 Output Area @ a e f 15 16 Price (N#) = @ a e f 49020.83333333333 @ a e f Price (% change) @ a e f 6.79983045316953E-6 @ a e f 17 Quantity = @ a e f 40016.66666666667 @ a e f Quantity (% change) @ a e f -8.32986184691646E-6 @ a e f 18 19 20 21 22 Working Area - DO NOT CHANGE !!!!! @ a e f 23 24 Building Regulations (loose, neutral, tight) @ a e f 0.0 @ a e f 25 Output of other sectors (increases, neutral, decreases) @ a e f 0.0 @ a e f 26 27 a (demand curve constant) @ a e f 45000 @ a e f 28 population constant @ a e f 10 @ a e f 29 Output of other sectors constant @ a e f 400 @ a e f 30 Building regulations constant @ a e f 1000 @ a e f 31 c (supply curve) @ a e f 1000 @ a e f 32 e (scaler for land costs) @ a e f 0.05 @ a e f

Formulae

This is the spreadsheet in formula view.

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