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: Cancelled 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!
 |  |  |  |  |  |  |  |  |  | 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 |  |  |  | 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
6 | NARROGIN | 68 | 2 | 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 | Not Applicable | 50000 | 158000 | 0.7784810126582279 | Not Applicable | Not Applicable | Not Applicable | Not Applicable | 2004-03-25 00:00:00 | 2004-03-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 281000 |  |  |  |  | 2683 | 281000 |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | -750 | 281000 | 280250 | HPP where tenant no longer wishes to proceed |  | 0 | 281000
7 | KATANNING | 77 |  | 49 |  | ROMEO | ROAD | HOUSE | 2005-01-01 00:00:00 | MARIO COLELLA | Not Applicable | Not Applicable | Not Applicable | SURPLUS | 2004-01-01 00:00:00 | Not Applicable | Not Applicable | 2005-01-02 00:00:00 | 2004-01-01 00:00:00 | Not Applicable | Not Applicable | 2005-01-03 00:00:00 | 2005-01-04 00:00:00 | 2005-01-04 00:00:00 | 2005-01-05 00:00:00 | 2005-01-12 00:00:00 | 2005-01-13 00:00:00 | 2005-01-13 00:00:00 | 2005-01-13 00:00:00 | 2005-01-20 00:00:00 | 2005-01-21 00:00:00 | 2005-01-21 00:00:00 | 2005-01-28 00:00:00 | 2005-01-28 00:00:00 | -350 | 350000 | 150000 | 115000 | 285000 | 0.3157894736842105 | 2005-04-28 00:00:00 | -250 | 375000 | -1500 | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | 2005-05-01 00:00:00 | 2005-05-22 00:00:00 | 2005-06-01 00:00:00 | 2005-06-01 00:00:00 | PL Bolto & Co | 2005-06-08 00:00:00 | 2005-06-10 00:00:00 | 2005-06-10 00:00:00 | 380000 | 2005-06-24 00:00:00 | Not Applicable | Not Applicable | Not Applicable | 14 | 375000 | 2005-06-24 00:00:00 | 0 | 0 | 2005-07-01 00:00:00 | 2005-07-03 00:00:00 | 2005-07-03 00:00:00 | 2005-07-04 00:00:00 |  |  |  |  |  |  |  |  |  | -2100 | 375000 | 372900 | Surplus with revaluation and a Cool-off |  | 0 | 375000
10 | [NAME] | 480 |  | 36 |  | SELWYN | STREET | HOUSE | 2008-01-01 00:00:00 | [NAME] FOPPOLI | DAF | -55000 | DAF | DEPOT | Not Applicable | Not Applicable | Not Applicable | 2008-01-01 00:00:00 | 2008-01-01 00:00:00 | 2008-01-08 00:00:00 | 2008-01-15 00:00:00 | 2008-01-16 00:00:00 | 2008-01-17 00:00:00 | 2008-01-18 00:00:00 | 2008-01-18 00:00:00 | 2008-01-25 00:00:00 | 2008-01-27 00:00:00 | 2008-01-28 00:00:00 | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | 2008-02-21 00:00:00 | -1000 | 55000 | 10000 | Not Applicable | 12500 | 3.4 | Not Applicable | Not Applicable | Not Applicable | -250 | 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 | 55000 | Not Applicable | Not Applicable | Not Applicable | Not Applicable | 1252 |  |  | -55000 | -1 |  |  |  |  |  |  |  |  |  |  |  |  |  | -56250 | 0 | -56250 | Depot house no longer required, house to be demolished - transaction cancelled |  | 0 | 55000
11 | MEEKATHARRA | 265 |  | 10 |  | DARLOT | STREET | HOUSE | 2009-01-01 00:00:00 | [NAME] FOPPOLI | Not Applicable | Not Applicable | Not Applicable | HPP | Not Applicable | 2009-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-01-08 00:00:00 | Not Applicable | Not Applicable | Not Applicable | 2009-01-09 00:00:00 | 2009-01-09 00:00:00 | 2009-01-10 00:00:00 | 2009-01-11 00:00:00 | 2009-01-18 00:00:00 | 2009-01-19 00:00:00 | 2009-01-19 00:00:00 | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | 2009-02-02 00:00:00 | -750 | 650000 | 395000 | 15000 | 420000 | 0.5476190476190477 | Not Applicable | Not Applicable | Not Applicable | -500 | 2009-02-14 00:00:00 | 2009-02-21 00:00:00 | Not Applicable | 2009-02-23 00:00:00 | 2009-02-28 00:00:00 | 2009-03-01 00:00:00 | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | 650000 | Not Applicable | Not Applicable | Not Applicable | Not Applicable | #N/A | 650000 |  | 0 | 0 | 2009-03-16 00:00:00 | 2009-03-25 00:00:00 | 2009-03-25 00:00:00 |  |  |  |  |  |  |  |  |  |  | -1250 | 650000 | 648750 | HPP negotiated but purchaser excercised their right to Cool-off |  | 0 | 650000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL | -2850 | 1336000 | 555000 | 180000 | 875500 |  |  | -250 | 375000 | -2250 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1306000 |  | -55000 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | -60350 | 1306000 | 1245650 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AVERAGE | -712.5 | 334000 | 185000 | 60000 | 0 | 1.260472383490371 |  | -250 | 375000 | -750 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1316.333333333333 | 435333.3333333333 |  | -11000 | -0.25 |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | -12070 | 261200 | 249130 |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Original Formula | 2683 | Works but does not see entry in Column AV
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | New Formula | 2683 | Works but does not allow entry of "Not Applicable" in Column AV - throws up a #[NAME]! Error