Spreadsheet: 110695d1307324478-creating-a-formula-to-allow-8-or-more-nested-if-statements-in-excel-2000-excel-alterations-web-forum-document-6-june-2011
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 | BMAPS 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 GERMS TO "P" TO CEASE AGENCY CHARGES | INITIAL TEST OF STRATEGIC SIGNIFICANCE (ITSS) - DEPOTS | SITE STRATEGIC LAND USE ASSESSMENT (SSLUA) - DEPOTS | BMAPS APPROVAL TO SELL -  MANAGER GOVERNMENT EMPLOYEES' HOUSING | SENT TO DIRECTOR BMAPS SEEKING MINISTERIAL APPROVAL | APPROVED BY DIRECTOR BMAPS | SENT BY PROPERTY SERVICES TO MINISTER FOR APPROVAL | MINISTERIAL APPROVAL GRANTED | SIGNED BY EXECUTIVE DIRECTOR BUILDING MANAGEMENT (POST MINISTERIAL APPROVAL) | VALUER APPOINTED | ELECTRICAL COMPLIANCE CERTIFICATE REQUESTED | ELECTRICAL COMPLIANCE CERTIFICATE RECEIVED | POWER CONNECTED | GOVERNMENT AND LAND MANAGEMENT CORPORATION CIRCULARISATION ACTIONED | GOVERNMENT AND LAND MANAGEMENT CORPORATION CIRCULARISATION CLOSING DATE | VALUATION REPORT RECEIVED FROM VALUER | VALUATION FEE | CURRENT MARKET VALUE OF PROPERTY | [NAME] ASSESSMENT OF BMAPS ASSET (CAPITAL VALUE) | [NAME] ASSESSMENT OF BMAPS ASSET (SITE VALUE) | CAPITAL VALUE (BMAPS) | DIFFERENCE BETWEEN CAPITAL VALUE AND CURRENT MARKET VALUE (%) | MARKET RE-VALUATION DATE | MARKET RE-VALUATION FEE | REVISED MARKET VALUE | DEPARTMENT OF ENVIRONMENT AND NATURAL RESOURCES' FEES | OFFER MADE TO TENANT AT CURRENT MARKET VALUE (HOME PURCHASE PLAN) | 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 CROWN SOLICITOR'S OFFICE (CSO) FOR FORMULATION OF DOCUMENTATION - HOME PURCHASE PLAN | TENDER SENT TO AGENTS | TENDER CLOSING DATE | ASSESSMENT OF TENDER COMPLETED | SALES AGENTS ADVISED | SUCCESSFUL SALES AGENT | SIGNED SALES AGENCY AGREEMENT RECEIVED FROM SUCCESSFUL AGENT | SALES AGENCY AGREEMENT FULLY EXECUTED | ADVISED MANAGER FINANCE POLICY AND REPORTING SALES AGENCY AGREEMENT EXECUTED | LISTING / OFFER PRICE | AGENT MARKETING FOLLOW UP | FIRST RENEWAL EXECUTED | SECOND RENEWAL EXECUTED | THIRD RENEWAL 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 BMAPS | FORM 1 EXECUTED BY ALL PARTIES | ADVISED MANAGER FINANCE POLICY AND REPORTING HOME PURCHASE PLAN CONTRACT EXECUTED | COOL-OFF DATE | DOCUMENTS SENT TO CROWN SOLICITORS OFFICE | DATE POWER DISCONNECTED | TRANSFER / ANNEXURE TO TRANSFER SIGNED BY DIRECTOR BMAPS | SETTLEMENT / TRANSFER DATE | PROFESSIONAL FEES | ADVERTISING FEES | MAINTENANCE COSTS | OTHER EXPENSES | CROWN SOLICITORS OFFICE FEES | TOTAL FEES | GROSS PROCEEDS OF SALE | NETT PROCEEDS OF SALE | COMMENTS | BMAPS RECORDS UPDATED & FILE CLOSED | CHECK - SHOULD BE ZERO | DO NOT DELETE THIS COLUMN UNDER ANY CIRCUMSTANCES!
 |  |  |  |  |  |  |  |  | 2011-01-01 00:00:00 | UNASSIGNED | Not Applicable | Not Applicable | Not Applicable | TESTING | 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 | Not Applicable | Not Applicable |  |  | Not Applicable |  | #N/A | 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 | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable |  |  |  | 0 | #N/A | 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 | 0 | 0 | 0 |  |  | 0 | 0
4 | PERTH | 724 |  | 36 |  | NORTH WEST COASTAL | HIGHWAY | HOUSE | 2002-01-01 00:00:00 | [NAME] FOPPOLI | SAPOL | -15000 | SAPOL | DEPOT | Not Applicable | Not Applicable | Not Applicable | 2002-01-01 00:00:00 | 2002-01-01 00:00:00 | 2002-01-08 00:00:00 | 2002-01-15 00:00:00 | 2002-01-16 00:00:00 | 2002-01-17 00:00:00 | 2002-01-24 00:00:00 | 2002-01-25 00:00:00 | 2002-02-01 00:00:00 | 2002-02-02 00:00:00 | 2002-02-02 00:00:00 | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | 2002-02-12 00:00:00 | -1500 | 400000 | 50000 | 300000 | 350000 | 0.2857142857142857 | 2002-05-31 00:00:00 | -350 | 450000 | -2000 | 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 | 450000 | Not Applicable | Not Applicable | Not Applicable | Not Applicable | 3443 |  |  | -450000 | -1 |  |  |  |  |  |  |  |  |  |  |  |  |  | -18850 | 0 | -18850 | Occupied Improvements to be transferred to SAPOL but sale price has not been agreed upon |  | 0 | 450000
8 | PERTH | 68 | 1 | 18 |  | FOX | STREET | UNIT | 2004-01-01 00:00:00 | ANDREW PARK | Not Applicable | Not Applicable | Not Applicable | HPP | Not Applicable | 2004-01-31 00:00:00 | Not Applicable | 2004-02-01 00:00:00 | Not Applicable | Not Applicable | Not Applicable | 2004-02-02 00:00:00 | 2004-02-03 00:00:00 | 2004-02-04 00:00:00 | 2004-02-05 00:00:00 | 2004-02-12 00:00:00 | 2004-02-13 00:00:00 | 2004-02-14 00:00:00 | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | 2004-02-28 00:00:00 | -750 | 281000 | 25000 | 50000 | 158000 | 0.879746835443038 | 2004-06-15 00:00:00 | -500 | 297000 | -500 | 2004-06-25 00:00:00 | 2004-06-30 00:00:00 | Not Applicable | 2004-07-01 00:00:00 | 2004-07-08 00:00:00 | 2004-07-08 00:00:00 | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | 297000 | Not Applicable | Not Applicable | Not Applicable | Not Applicable | 166 | 297000 | 2004-07-15 00:00:00 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | -1750 | 297000 | 295250 | HPP negotiated but not settled with a revaluation |  | 0 | 297000
9 | PERTH | 862 |  | 211 |  | OCEAN | DRIVE | HOUSE | 2007-01-01 00:00:00 | MARIO COLELLA | Not Applicable | Not Applicable | Not Applicable | SURPLUS | 2007-01-01 00:00:00 | Not Applicable | Not Applicable | 2007-01-01 00:00:00 | 2007-01-01 00:00:00 | Not Applicable | Not Applicable | 2007-01-02 00:00:00 | 2007-01-03 00:00:00 | 2007-01-07 00:00:00 | 2007-01-08 00:00:00 | 2007-01-15 00:00:00 | 2007-01-16 00:00:00 | 2007-01-17 00:00:00 | Not Applicable | Not Applicable | 2007-01-17 00:00:00 | Not Applicable | Not Applicable | 31/1//2007 | -500 | 325000 | 115000 | 110000 | 235000 | 0.4893617021276596 | 2007-05-14 00:00:00 | -250 | 350000 | -1500 | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | 2007-05-22 00:00:00 | 2007-06-13 00:00:00 | 2007-06-20 00:00:00 | 2007-06-20 00:00:00 | DAD Real Estate | 2007-06-22 00:00:00 | 2007-06-24 00:00:00 | 2007-06-24 00:00:00 | 360000 | 2007-07-22 00:00:00 | Not Applicable | Not Applicable | Not Applicable | 27 | 358500 | 2007-07-21 00:00:00 | 8500 | 0.02428571428571429 |  |  |  |  |  |  |  |  |  |  |  |  |  | -2250 | 358500 | 356250 | Surplus revalued and under contract but not settled |  | 0 | 350000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL | -2750 | 0 | 190000 | 460000 | 743000 |  |  | -1100 | 1097000 | -4000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 655500 |  | -441500 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | -22850 | 655500 | 632650 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AVERAGE | -916.6666666666666 | 335333.3333333333 | 63333.33333333334 | 153333.3333333333 | 247666.6666666667 | 0.5516076077616611 |  | -366.6666666666667 | 365666.6666666667 | -1333.333333333333 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1212 | 327750 |  | -110375 | -0.3252380952380953 |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | -5712.5 | 163875 | 158162.5 |  |  | 0