Spreadsheet: 109173d1306117576-calculating-date-difference-with-multiple-criteria-excel-alterations-web-forum-docment
Sheet: Current Transactions

HOUSE NUMBER | TOWN | LOT NUMBER | UNIT NUMBER | STREET NUMBER | STREET NUMBER SUFFIX | STREET NAME | STREET INDICATOR | DWELLING TYPE (AS NOTED ON GERMS) | PROGRESS START DATE | OFFICER | AGENCY FROM WHICH THE DWELLING WAS ORIGINALLY PURCHASED / TRANSFERRED | ORIGINAL PURCHASE PRICE / TRANSFER FEE | CLIENT AGENCY | AGREED DISPOSAL METHOD (DEPOT / HPP / SURPLUS) | VACANCY DATE | HPP APPLICATION RECEIVED | HPP APPLICATION SENT TO HOUSING MANAGER | DISPOSAL CHECKLIST RECEIVED | CHANGED CODE ON TO "P" TO CEASE AGENCY CHARGES | INITIAL TEST OF STRATEGIC SIGNIFICANCE (ITSS) - DEPOTS | SITE STRATEGIC LAND USE ASSESSMENT (SSLUA) - DEPOTS | APPROVAL TO SELL -  MANAGER | SEEKING MINISTERIAL APPROVAL | APPROVED BY DIRECTOR | SENT TO MINISTER FOR APPROVAL | MINISTERIAL APPROVAL GRANTED | SIGNED BY EDM (POST MINISTERIAL APPROVAL) | VALUER APPOINTED | ELECTRICAL COMPLIANCE CERTIFICATE REQUESTED | ELECTRICAL COMPLIANCE CERTIFICATE RECEIVED | POWER CONNECTED | [NAME] | CIRCULARISATION CLOSING DATE | VALUATION REPORT RECEIVED FROM VALUER | VALUATION FEE | CURRENT MARKET VALUE OF PROPERTY | [NAME] ASSESSMENT OF  ASSET (CAPITAL VALUE) | [NAME] ASSESSMENT OF  ASSET (SITE VALUE) | CAPITAL VALUE | DIFFERENCE BETWEEN CAPITAL VALUE AND MARKET VALUE (%) | MARKET RE-VALUATION DATE | MARKET RE-VALUATION FEE | REVISED MARKET VALUE | CALM FEES | OFFER MADE TO TENANT | TENANT ACCEPTED OFFER | TENANT ADVISED NO LONGER WISHES TO PROCEED | FINANCIAL DETAILS FORM SENT TO TENANT | FINANCIAL DETAILS FORM RECEIVED FROM TENANT | INSTRUCTIONS SENT TO (CSO) FOR FORMULATION OF DOCUMENTATION) | TENDER SENT | TENDER CLOSING DATE | ASSESSMENT OF TENDER COMPLETED | AGENTS ADVISED | SUCCESSFUL AGENT | SIGNED  AGENCY AGREEMENT RECEIVED FROM SUCCESSFUL AGENT | AGENCY AGREEMENT FULLY EXECUTED | ADVISED MANAGER AGENCY AGREEMENT EXECUTED | AGENT MARKETING FOLLOW UP | FIRST RENEWAL EXECUTED | SECOND RENEWAL EXECUTED | THIRD RENEAL EXECUTED | DAYS ON THE MARKET / IN PROCESS OF DISPOSAL | CONTRACT AMOUNT | DATE CONTRACT EXECUTED BY ALL PARTIES | DIFFERENCE BETWEEN CURRENT MARKET VALUE AND CONTRACT AMOUNT ($) | DIFFERENCE BETWEEN CURRENT MARKET VALUE AND CONTRACT AMOUNT (%) | FORM 1 AND SEARCHES RECEIVED AND EXECUTED BY DIRECTOR | FORM 1 EXECUTED BY ALL PARTIES | ADVISED MANAGER CONTRACT EXECUTED | COOL-OFF DATE | DOCUMENTS SENT TO CSO | DATE POWER DISCONNECTED | TRANSFER / ANNEXURE TO TRANSFER SIGNED BY DIRECTOR | SETTLEMENT / TRANSFER DATE | PROFESSIONAL FEES | ADVERTISING FEES | MAINTENANCE COSTS | OTHER EXPENSES | CSO OFFICE FEES | TOTAL FEES | GROSS PROCEEDS OF SALE | NETT PROCEEDS OF SALE | CHECK - SHOULD BE ZERO | COMMENTS | RECORDS UPDATED & FILE CLOSED
707253 | PERTH | 626 | 1 | 64 | A | COOLGARDIE-ESPERANCE | ROAD | SINGLE DETATCHED HOUSE | 2009-09-30 00:00:00 | [NAME] | ZEDD99801A | 0 | ZEDD99801A | SURPLUS | 2009-01-01 00:00:00 | Not Applicable | Not Applicable | Not Applicable | 2009-09-30 00:00:00 | Not Applicable | Not Applicable | 2009-09-30 00:00:00 | Not Applicable | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | -500 | 1000000 | Not Applicable | Not Applicable | 1500000 | 0.3333333333333333 | 2009-09-30 00:00:00 | -500 | 1500000 | -500 | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | [NAME] | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 595 | 1750000 | 2011-05-18 00:00:00 | 250000 | 0.1428571428571428 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | Not Applicable | Not Applicable | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | -500 | -500 | -500 | -500 | -500 | -4000 | 1750000 | 1746000 | 0 |  | 2009-09-30 00:00:00
707286 | ADELAIDE | 821 | 7 | 22 | D | GREAT NORTHERN | HIGHWAY | TOWNHOUSE | 2008-09-30 00:00:00 | [NAME] | ZPOL99801A | -500 | ZPOL99801A | DEPOT | Not Applicable | Not Applicable | Not Applicable | Not Applicable | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-01-08 00:00:00 | 2009-09-30 00:00:00 | Not Applicable | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | -500 | 1000000 | 1000000 | 1000000 | 2000000 | 0.5 | 2009-09-30 00:00:00 | -500 | 1000000 | -500 | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | 365 | 4000000 | 2009-09-30 00:00:00 | 3000000 | 0.75 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | Not Applicable | Not Applicable | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | -500 | -500 | -500 | -500 | -500 | -4500 | 4000000 | 3995500 | 0 |  | 2009-09-30 00:00:00
710224 | MELBOURNE | 364 | 8 | 44 | C | CUE | BOULEVARDE | APARTMENT | 2011-01-01 00:00:00 | [NAME] | ZCLM99801A | -500 | ZCLM99801A | HPP | Not Applicable | 2011-01-01 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | Not Applicable | Not Applicable | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | Not Applicable | Not Applicable | 2009-09-30 00:00:00 | -500 | 1000000 | Not Applicable | Not Applicable | 875000 | -0.1428571428571428 | 2009-09-30 00:00:00 | -500 | 1000000 | -500 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Thorp Realty | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | 365 | 2000000 | 2012-01-01 00:00:00 | 1000000 | 0.5 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | -500 | -500 | -500 | -500 | -500 | -4500 | 2000000 | 1995500 | 0 |  | 2009-09-30 00:00:00
1 | BRISBANE | 930 |  | 52 | B | FELTON | STREET | DUPLEX | 2000-01-24 00:00:00 | [NAME] | [NAME] | 0 | [NAME] | SURPLUS | 2000-01-24 00:00:00 | Not Applicable | Not Applicable | 2000-01-24 00:00:00 | 2000-01-24 00:00:00 | Not Applicable | Not Applicable | 2000-01-31 00:00:00 | 2000-02-01 00:00:00 | 2000-02-08 00:00:00 | 2000-02-08 00:00:00 | 2000-04-22 00:00:00 | 2000-04-23 00:00:00 | 2000-04-23 00:00:00 | Not Applicable | Not Applicable | 2000-04-23 00:00:00 | 2000-04-23 00:00:00 | 2000-04-30 00:00:00 | 2000-05-01 00:00:00 | -350 | 110000 | 25000 | 60000 | 90000 | -0.2222222222222222 | Not Applicable | Not Applicable | Not Applicable | -250 | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | 2000-05-02 00:00:00 | 2000-05-23 00:00:00 | 2000-05-30 00:00:00 | 2000-05-31 00:00:00 | Harber Real Estate | 2000-06-01 00:00:00 | 2000-06-01 00:00:00 | 2000-06-02 00:00:00 | 2000-06-16 00:00:00 | Not Applicable | Not Applicable | Not Applicable | 19 | 112500 | 2000-06-20 00:00:00 | 2500 | 0.02222222222222222 | 2000-06-20 00:00:00 | 2000-06-22 00:00:00 | 2000-06-22 00:00:00 | Not Applicable | 2000-06-30 00:00:00 | 2000-06-30 00:00:00 | 2000-07-07 00:00:00 | 2000-07-30 00:00:00 | -1000 | -250 | -500 | -225 | -430 | -3005 | 112500 | 109495 | 0 |  | 2000-08-31 00:00:00
2 | SYDNEY | 127 |  | 78 | A | ELDORADO | STREET | DUPLEX | 2004-04-01 00:00:00 | [NAME] | ZJUS99801A | 0 | ZJUS99801A | HPP | Not Applicable | 2004-04-01 00:00:00 | 2004-04-15 00:00:00 | 2004-04-15 00:00:00 | Not Applicable | Not Applicable | Not Applicable | 2004-04-22 00:00:00 | 2004-04-23 00:00:00 | 2004-04-30 00:00:00 | 2004-04-30 00:00:00 | 2004-05-14 00:00:00 | 2004-05-15 00:00:00 | 2004-05-15 00:00:00 | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | 2004-05-22 00:00:00 | -500 | 220000 | 35000 | 75000 | 175000 | -0.2571428571428571 | Not Applicable | Not Applicable | Not Applicable | -350 | 2004-06-01 00:00:00 | 2004-06-08 00:00:00 | Not Applicable | 2004-06-10 00:00:00 | 2004-06-17 00:00:00 | 2004-06-18 00:00:00 | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | #N/A | 235000 |  | 15000 | 0.06382978723404255 | 2004-07-01 00:00:00 | 2004-07-08 00:00:00 | 2004-07-08 00:00:00 | Not Applicable | 2004-07-09 00:00:00 | 2004-07-09 00:00:00 | 2004-07-16 00:00:00 | 2004-07-30 00:00:00 | 0 | 0 | 0 | 0 | -750 | -1600 | 235000 | 233400 | 0 |  | 2004-08-31 00:00:00
3 | DARWIN | 68 |  | 2 |  | [NAME] | STREET | SINGLE DETATCHED HOUSE | 2009-03-08 00:00:00 | [NAME] | ZFIS99801A | 0 | ZFIS99801A | DEPOT | Not Applicable | Not Applicable | Not Applicable | 2009-03-08 00:00:00 | Not Applicable | 2009-04-25 00:00:00 | 2009-04-25 00:00:00 | 2009-03-15 00:00:00 | 2009-03-16 00:00:00 | 2009-03-23 00:00:00 | 2009-03-23 00:00:00 | 2009-04-06 00:00:00 | 2009-04-06 00:00:00 | 2009-04-06 00:00:00 | Not Applicable | Not Applicable | Not Applicable | 2009-04-06 00:00:00 | 2009-04-13 00:00:00 | 2009-04-14 00:00:00 | -800 | 300000 | 15000 | 220000 | 285000 | -0.05263157894736842 | Not Applicable | Not Applicable | Not Applicable | -600 | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | #N/A | 299500 |  | -500 | -0.001669449081803005 | 2009-06-01 00:00:00 | 2009-06-03 00:00:00 | 2009-06-03 00:00:00 | Not Applicable | 2009-06-04 00:00:00 | Not Applicable | 2009-06-14 00:00:00 | 2009-06-30 00:00:00 | 0 | 0 | 0 | 0 | -695 | -2095 | 299500 | 297405 | 0 |  | 2009-07-30 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL | -3150 | 3630000 | 1075000 | 1355000 | 4925000 |  |  | -1500 | 3500000 | -2700 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8397000 |  | 4267000 |  |  |  |  |  |  |  |  |  | -2500 | -1750 | -2000 | -1725 | -3375 | -19700 | 8397000 | 8377300 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AVERAGE | -525 | 605000 | 268750 | 338750 | 820833.3333333334 | 0.02641325536062379 |  | -500 | 1166666.666666667 | -450 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 1399500 |  | 711166.6666666666 | 0.2462066172052674 |  |  |  |  |  |  |  |  | -416.6666666666667 | -291.6666666666667 | -333.3333333333333 | -287.5 | -562.5 | -3283.333333333333 | 1399500 | 1396216.666666667 | 0