Spreadsheet: 109173d1306117576-calculating-date-difference-with-multiple-criteria-excel-alterations-web-forum-docment
Sheet: Completed 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
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.3333333333333333 | 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 |  | #N/A | 0.1428571428571428 | 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 | -4000 | 299500 | 1746000 | -1450500 |  | 2009-07-30 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL | -3150
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AVERAGE | -525