Spreadsheet: 91056d1290733215-excel-formula-analysis-sample-data-sheet
Sheet: Prelim analysis

Address Num | Street Name | Suburb | State | Postcode | HMC | Ownership | 2009 Valuer | [NAME] 2009 (current client rent ) | 2009 Land Val | 2009 House Val | 2009 Capital val | 2009 Rental Val | 2010 Valuer | [NAME] 2010 | 2010 Land Val | 2010 House Val | 2010 Capital val | 2010 Rental Val | Yield | $ [NAME] | % Capital Variance | $ [NAME] | % Rental Variance |  | Query
0 | 11 UPINGTON DRIVE | EAST MAITLAND | NSW | 2323 | Hunter Valley HMC | H | SKE | ANN | 160000 | 230000 | 390000 | 395 | SKE | ANN | 180000 | 230000 | 410000 | 420 | 0.05326829268292683 | 20000 | 0.05128205128205128 | 25 | 0.06329113924050633 |  | Y
341 | BRUNKER ROAD | ADAMSTOWN | NSW | 2289 | Hunter Valley HMC | H | SKE | ANN | 170000 | 235000 | 405000 | 420 | SKE | ANN | 175000 | 245000 | 420000 | 430 | 0.05323809523809524 | 15000 | 0.03703703703703703 | 10 | 0.02380952380952381 |  | N
339 | BRUNKER ROAD | ADAMSTOWN | NSW | 2289 | Hunter Valley HMC | H | SKE | ANN | 170000 | 235000 | 405000 | 420 | SKE | ANN | 175000 | 245000 | 420000 | 430 | 0.05323809523809524 | 15000 | 0.03703703703703703 | 10 | 0.02380952380952381 |  | N
337 | BRUNKER ROAD | ADAMSTOWN | NSW | 2289 | Hunter Valley HMC | H | SKE | ANN | 170000 | 235000 | 405000 | 420 | SKE | ANN | 175000 | 245000 | 420000 | 430 | 0.05323809523809524 | 15000 | 0.03703703703703703 | 10 | 0.02380952380952381 |  | N
335 | BRUNKER ROAD | ADAMSTOWN | NSW | 2289 | Hunter Valley HMC | H | SKE | ANN | 170000 | 235000 | 405000 | 420 | SKE | ANN | 175000 | 245000 | 420000 | 430 | 0.05323809523809524 | 15000 | 0.03703703703703703 | 10 | 0.02380952380952381 |  | N
333 | BRUNKER ROAD | ADAMSTOWN | NSW | 2289 | Hunter Valley HMC | H | SKE | ANN | 170000 | 235000 | 405000 | 420 | SKE | ANN | 175000 | 245000 | 420000 | 430 | 0.05323809523809524 | 15000 | 0.03703703703703703 | 10 | 0.02380952380952381 |  | N
331 | BRUNKER ROAD | ADAMSTOWN | NSW | 2289 | Hunter Valley HMC | H | SKE | ANN | 170000 | 235000 | 405000 | 420 | SKE | ANN | 175000 | 245000 | 420000 | 430 | 0.05323809523809524 | 15000 | 0.03703703703703703 | 10 | 0.02380952380952381 |  | N
329 | BRUNKER ROAD | ADAMSTOWN | NSW | 2289 | Hunter Valley HMC | H | SKE | ANN | 170000 | 235000 | 405000 | 420 | SKE | ANN | 175000 | 245000 | 420000 | 430 | 0.05323809523809524 | 15000 | 0.03703703703703703 | 10 | 0.02380952380952381 |  | N
327 | BRUNKER ROAD | ADAMSTOWN | NSW | 2289 | Hunter Valley HMC | H | SKE | ANN | 170000 | 235000 | 405000 | 420 | SKE | ANN | 175000 | 245000 | 420000 | 430 | 0.05323809523809524 | 15000 | 0.03703703703703703 | 10 | 0.02380952380952381 |  | N
325 | BRUNKER ROAD | ADAMSTOWN | NSW | 2289 | Hunter Valley HMC | H | SKE | ANN | 170000 | 235000 | 405000 | 420 | SKE | ANN | 175000 | 245000 | 420000 | 430 | 0.05323809523809524 | 15000 | 0.03703703703703703 | 10 | 0.02380952380952381 |  | N
323 | BRUNKER ROAD | ADAMSTOWN | NSW | 2289 | Hunter Valley HMC | H | SKE | ANN | 170000 | 235000 | 405000 | 420 | SKE | ANN | 175000 | 245000 | 420000 | 430 | 0.05323809523809524 | 15000 | 0.03703703703703703 | 10 | 0.02380952380952381 |  | N
321 | BRUNKER ROAD | ADAMSTOWN | NSW | 2289 | Hunter Valley HMC | H | SKE | ANN | 170000 | 235000 | 405000 | 420 | SKE | ANN | 175000 | 245000 | 420000 | 430 | 0.05323809523809524 | 15000 | 0.03703703703703703 | 10 | 0.02380952380952381 |  | N
319 | BRUNKER ROAD | ADAMSTOWN | NSW | 2289 | Hunter Valley HMC | H | SKE | ANN | 170000 | 235000 | 405000 | 420 | SKE | ANN | 175000 | 245000 | 420000 | 430 | 0.05323809523809524 | 15000 | 0.03703703703703703 | 10 | 0.02380952380952381 |  | N
317 | BRUNKER ROAD | ADAMSTOWN | NSW | 2289 | Hunter Valley HMC | H | SKE | ANN | 170000 | 235000 | 405000 | 420 | SKE | ANN | 175000 | 245000 | 420000 | 430 | 0.05323809523809524 | 15000 | 0.03703703703703703 | 10 | 0.02380952380952381 |  | N
0 | 13 UPINGTON DRIVE | EAST MAITLAND | NSW | 2323 | Hunter Valley HMC | H | SKE | ANN | 165000 | 230000 | 395000 | 395 | SKE | ANN | 180000 | 230000 | 410000 | 420 | 0.05326829268292683 | 15000 | 0.0379746835443038 | 25 | 0.06329113924050633 |  | Y
53 | BULLECOURT CIRCUIT | ADAMSTOWN | NSW | 2289 | Hunter Valley HMC | H | SKE | ANN | 265000 | 215000 | 480000 | 465 | SKE | ANN | 270000 | 225000 | 495000 | 485 | 0.05094949494949495 | 15000 | 0.03125 | 20 | 0.04301075268817205 |  | N
51 | BULLECOURT CIRCUIT | ADAMSTOWN | NSW | 2289 | Hunter Valley HMC | A | SKE | ANN | 275000 | 215000 | 490000 | 455 | SKE | ANN | 280000 | 230000 | 510000 | 485 | 0.04945098039215686 | 20000 | 0.04081632653061224 | 30 | 0.06593406593406594 |  | N
49 | BULLECOURT CIRCUIT | ADAMSTOWN | NSW | 2289 | Hunter Valley HMC | H | SKE | ANN | 260000 | 230000 | 490000 | 465 | SKE | ANN | 265000 | 240000 | 505000 | 485 | 0.04994059405940594 | 15000 | 0.03061224489795918 | 20 | 0.04301075268817205 |  | N
47 | BULLECOURT CIRCUIT | ADAMSTOWN | NSW | 2289 | Hunter Valley HMC | H | SKE | ANN | 265000 | 212000 | 477000 | 465 | SKE | ANN | 270000 | 222000 | 492000 | 485 | 0.05126016260162602 | 15000 | 0.03144654088050314 | 20 | 0.04301075268817205 |  | N
45 | BULLECOURT ADAMSTOWN | ADAMSTOWN | NSW | 2289 | Hunter Valley HMC | H | SKE | ANN | 265000 | 205000 | 470000 | 455 | SKE | ANN | 270000 | 215000 | 485000 | 475 | 0.05092783505154639 | 15000 | 0.03191489361702127 | 20 | 0.04395604395604396 |  | N
0 | 5 UPINGTON DRIVE | EAST MAITLAND | NSW | 2323 | Hunter Valley HMC | H | SKE | ANN | 165000 | 225000 | 390000 | 395 | SKE | ANN | 180000 | 225000 | 405000 | 420 | 0.05392592592592593 | 15000 | 0.03846153846153846 | 25 | 0.06329113924050633 |  | Y
41 | BULLECOURT CIRCUIT | ADAMSTOWN | NSW | 2289 | Hunter Valley HMC | H | SKE | ANN | 265000 | 210000 | 475000 | 475 | SKE | ANN | 270000 | 220000 | 490000 | 495 | 0.05253061224489796 | 15000 | 0.03157894736842105 | 20 | 0.04210526315789474 |  | N
39 | BULLECOURT CIRCUIT | ADAMSTOWN | NSW | 2289 | Hunter Valley HMC | H | SKE | ANN | 265000 | 210000 | 475000 | 475 | SKE | ANN | 270000 | 220000 | 490000 | 495 | 0.05253061224489796 | 15000 | 0.03157894736842105 | 20 | 0.04210526315789474 |  | N
16 | ACER TERRACE | THORNTON | NSW | 2322 | Hunter Valley HMC | H | CBREN | ANN | 190000 | 170000 | 360000 | 370 | CBREN | ANN | 190000 | 170000 | 360000 | 390 | 0.05633333333333333 | 0 | 0 | 20 | 0.05405405405405406 |  | Y
14 | ACER TERRACE | THORNTON | NSW | 2322 | Hunter Valley HMC | H | CBREN | ANN | 190000 | 170000 | 360000 | 370 | CBREN | ANN | 190000 | 170000 | 360000 | 390 | 0.05633333333333333 | 0 | 0 | 20 | 0.05405405405405406 |  | Y
10 | ACER TERRACE | THORNTON | NSW | 2322 | Hunter Valley HMC | H | CBREN | ANN | 190000 | 185000 | 375000 | 380 | CBREN | ANN | 190000 | 185000 | 375000 | 400 | 0.05546666666666666 | 0 | 0 | 20 | 0.05263157894736842 |  | Y
1 | AGONIS PLACE | MEDOWIE | NSW | 2318 | Hunter Valley HMC | H | SKE | ANN | 150000 | 150000 | 300000 | 320 | SKE | ANN | 150000 | 165000 | 315000 | 345 | 0.05695238095238096 | 15000 | 0.05 | 25 | 0.078125 |  | Y