Spreadsheet: 91056d1290733215-excel-formula-analysis-sample-data-sheet
Sheet: HO queried Properties

UPRN | 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]
2648875 | 3 | [NAME] | SINGLETON | NSW | 2330 | Hunter Valley HMC | H | SKE | ANN | 155000 | 220000 | 375000 | 410 | SKE | ANN | 165000 | 230000 | 395000 | 440 | 0.05792405063291139 | 20000 | 0.05333333333333334 | 30
2648886 | 5 | [NAME] | SINGLETON | NSW | 2330 | Hunter Valley HMC | H | SKE | ANN | 155000 | 220000 | 375000 | 410 | SKE | ANN | 165000 | 230000 | 395000 | 440 | 0.05792405063291139 | 20000 | 0.05333333333333334 | 30
2648897 | 7 | [NAME] | SINGLETON | NSW | 2330 | Hunter Valley HMC | H | SKE | ANN | 160000 | 225000 | 385000 | 410 | SKE | ANN | 170000 | 235000 | 405000 | 440 | 0.05649382716049383 | 20000 | 0.05194805194805195 | 30
2648900 | 11 | [NAME] | SINGLETON | NSW | 2330 | Hunter Valley HMC | H | SKE | ANN | 160000 | 220000 | 380000 | 410 | SKE | ANN | 170000 | 230000 | 400000 | 440 | 0.0572 | 20000 | 0.05263157894736842 | 30
2648911 | 10 | [NAME] | SINGLETON | NSW | 2330 | Hunter Valley HMC | H | SKE | ANN | 160000 | 225000 | 385000 | 410 | SKE | ANN | 170000 | 235000 | 405000 | 440 | 0.05649382716049383 | 20000 | 0.05194805194805195 | 30
2648068 | 3 | AMIENS PLACE | ADAMSTOWN | NSW | 2289 | Hunter Valley HMC | A | SKE | ANN | 250000 | 205000 | 455000 | 450 | SKE | ANN | 255000 | 220000 | 475000 | 480 | 0.05254736842105263 | 20000 | 0.04395604395604396 | 30
1409672 | 21 | ARDERSIER DRIVE | SINGLETON | NSW | 2330 | Hunter Valley HMC | H | SKE | ANN | 220000 | 215000 | 435000 | 410 | SKE | ANN | 220000 | 225000 | 445000 | 440 | 0.05141573033707865 | 10000 | 0.02298850574712644 | 30
3000075 | 9 | ARDERSIER DRIVE | SINGLETON | NSW | 2330 | Hunter Valley HMC | X | SKE | ANN | 230000 | 280000 | 510000 | 455 | SKE | ANN | 230000 | 290000 | 520000 | 490 | 0.049 | 10000 | 0.0196078431372549 | 35
3486780 | 1 | ARMIDALE AVENUE | NELSON BAY | NSW | 2315 | Hunter Valley HMC | H | CBREN | ANN | 180000 | 220000 | 400000 | 360 | CBREN | ANN | 210000 | 200000 | 410000 | 410 | 0.052 | 10000 | 0.025 | 50
1407461 | 4 | ARUNTA CLOSE | SALAMANDER BAY | NSW | 2317 | Hunter Valley HMC | H | CBREN | ANN | 240000 | 130000 | 370000 | 350 | HTWNC | ANN | 225000 | 180000 | 405000 | 380 | 0.04879012345679012 | 35000 | 0.0945945945945946 | 30
1410997 | 116 | BAGNALL BEACH ROAD | CORLETTE | NSW | 2315 | Hunter Valley HMC | H | HTWNC | CONV | 0 | 0 | 0 | 400 | SKE | ANN | 230000 | 190000 | 420000 | 395 | 0.0489047619047619 | 420000 | #N/A | -5
1411014 | 120 | BAGNALL BEACH ROAD | CORLETTE | NSW | 2315 | Hunter Valley HMC | H | SKE | CONV | 0 | 0 | 0 | 380 | SKE | ANN | 230000 | 180000 | 410000 | 370 | 0.04692682926829268 | 410000 | #N/A | -10
1411252 | 113 | BAGNALL BEACH ROAD | CORLETTE | NSW | 2315 | Hunter Valley HMC | H | SKE | CONV | 0 | 0 | 0 | 375 | SKE | ANN | 230000 | 180000 | 410000 | 365 | 0.04629268292682927 | 410000 | #N/A | -10
1411694 | 70 | BAGNALL BEACH ROAD | CORLETTE | NSW | 2315 | Hunter Valley HMC | H | SKE | CONV | 0 | 0 | 0 | 395 | SKE | ANN | 230000 | 190000 | 420000 | 395 | 0.0489047619047619 | 420000 | #N/A | 0
1411707 | 74 | BAGNALL BEACH ROAD | CORLETTE | NSW | 2315 | Hunter Valley HMC | H | SKE | CONV | 0 | 0 | 0 | 400 | SKE | ANN | 230000 | 190000 | 420000 | 400 | 0.04952380952380953 | 420000 | #N/A | 0
1411730 | 82 | BAGNALL BEACH ROAD | CORLETTE | NSW | 2315 | Hunter Valley HMC | H | SKE | CONV | 0 | 0 | 0 | 395 | SKE | ANN | 230000 | 190000 | 420000 | 395 | 0.0489047619047619 | 420000 | #N/A | 0
1411774 | 85 | BAGNALL BEACH ROAD | CORLETTE | NSW | 2315 | Hunter Valley HMC | H | SKE | CONV | 0 | 0 | 0 | 375 | SKE | ANN | 230000 | 180000 | 410000 | 370 | 0.04692682926829268 | 410000 | #N/A | -5
2007843 | 20 | BANKSIA STREET | EVANS HEAD | NSW | 2473 | Hunter Valley HMC | H | AVO | ANN | 250000 | 180000 | 430000 | 300 | AVO | ANN | 250000 | 185000 | 435000 | 340 | 0.04064367816091954 | 5000 | 0.01162790697674419 | 40
1405829 | 2/5 | BARR STREET | MEREWETHER | NSW | 2291 | Hunter Valley HMC | H | CBREN | ANN | 0 | 410000 | 410000 | 400 | CBREN | ANN | 0 | 440000 | 440000 | 440 | 0.052 | 30000 | 0.07317073170731707 | 40
2596409 | 11 | BASS CLOSE | SALAMANDER BAY | NSW | 2317 | Hunter Valley HMC | H | CBREN | ANN | 180000 | 170000 | 350000 | 330 | HTWNC | ANN | 190000 | 190000 | 380000 | 360 | 0.04926315789473684 | 30000 | 0.08571428571428572 | 30
2603852 | 11A | BASS CLOSE | SALAMANDER BAY | NSW | 2317 | Hunter Valley HMC | H | CBREN | ANN | 180000 | 170000 | 350000 | 330 | HTWNC | ANN | 190000 | 190000 | 380000 | 380 | 0.052 | 30000 | 0.08571428571428572 | 50
3472693 | 3 | BEAUFORT CIRCUIT | ASHTONFIELD | NSW | 2323 | Hunter Valley HMC | X | SKE | ACQ | 160000 | 255000 | 415000 | 410 | SKE | ANN | 165000 | 265000 | 430000 | 440 | 0.0532093023255814 | 15000 | 0.03614457831325301 | 30
2628333 | 4 | BEAUFORT CIRCUIT | EAST MAITLAND | NSW | 2323 | Hunter Valley HMC | H | SKE | ANN | 180000 | 205000 | 385000 | 380 | SKE | ANN | 185000 | 205000 | 390000 | 410 | 0.05466666666666667 | 5000 | 0.01298701298701299 | 30
2628479 | 1 | BEECH CLOSE | THORNTON | NSW | 2322 | Hunter Valley HMC | H | CBREN | ANN | 195000 | 180000 | 375000 | 380 | CBREN | ANN | 200000 | 180000 | 380000 | 410 | 0.05610526315789473 | 5000 | 0.01333333333333333 | 30
2628480 | 3 | BEECH CLOSE | THORNTON | NSW | 2322 | Hunter Valley HMC | H | CBREN | ANN | 195000 | 170000 | 365000 | 380 | CBREN | ANN | 200000 | 170000 | 370000 | 410 | 0.05762162162162162 | 5000 | 0.0136986301369863 | 30
2628491 | 5 | BEECH CLOSE | THORNTON | NSW | 2322 | Hunter Valley HMC | H | CBREN | ANN | 195000 | 170000 | 365000 | 380 | CBREN | ANN | 200000 | 170000 | 370000 | 410 | 0.05762162162162162 | 5000 | 0.0136986301369863 | 30
1413134 | 6 | BELLBIRD PLACE | GOONELLABAH | NSW | 2480 | Hunter Valley HMC | N | Aust Valuation Office | ANN | 150000 | 250000 | 400000 | 360 | Aust Valuation Office | ANN | 140000 | 250000 | 390000 | 360 | 0.048 | -10000 | -0.025 | 0