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: 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 | 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
1 | PERTH | 1 | 1 | 1 | A | FORRESTER | CIRCLE | MAISONETTE | 2000-01-01 00:00:00 | [NAME] FOPPOLI | DECS | -15000 | DECS | DEPOT | 2000-01-01 00:00:00 | Not Applicable | Not Applicable | 2000-01-08 00:00:00 | 2000-01-08 00:00:00 | 2000-01-15 00:00:00 | 2000-01-15 00:00:00 | 2000-01-15 00:00:00 | 2000-01-15 00:00:00 | 2000-01-16 00:00:00 | 2000-01-17 00:00:00 | 2000-01-24 00:00:00 | 2000-01-25 00:00:00 | 2000-01-27 00:00:00 | Not Applicable | Not Applicable | 2000-01-27 00:00:00 | Not Applicable | Not Applicable | 2000-02-02 00:00:00 | -350 | 150000 | 72500 | 55000 | 127500 | 0.4823529411764706 | 2000-05-02 00:00:00 | -275 | 189000 | -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 | 200000 | Not Applicable | Not Applicable | Not Applicable | Not Applicable | 60 | 200000 | 2000-03-01 00:00:00 | 11000 | 0.0582010582010582 | 2000-03-02 00:00:00 | 2000-02-03 00:00:00 | Not Applicable | Not Applicable | 2000-03-03 00:00:00 | 2000-03-05 00:00:00 | 2000-03-17 00:00:00 | 2000-03-21 00:00:00 | Not Applicable | Not Applicable | Not Applicable | Not Applicable | -750 | -16875 | 200000 | 183125 | Land and vacant Improvements transferred to DECS with revaluation | 2000-03-31 00:00:00 | 0 | 189000
2 | PERTH | 1 | 2 | 1 | A | FORRESTER | CIRCLE | MAISONETTE | 2000-01-01 00:00:00 | ANDREW PARK | DECS | -15000 | DECS | DEPOT | 2000-01-01 00:00:00 | Not Applicable | Not Applicable | 2000-01-01 00:00:00 | 2000-01-01 00:00:00 | 2000-01-08 00:00:00 | 2000-01-08 00:00:00 | 2000-01-08 00:00:00 | 2000-01-09 00:00:00 | 2000-01-10 00:00:00 | 2000-01-11 00:00:00 | 2000-01-18 00:00:00 | 2000-01-19 00:00:00 | 2000-01-20 00:00:00 | Not Applicable | Not Applicable | 2000-01-20 00:00:00 | Not Applicable | Not Applicable | 2000-01-27 00:00:00 | -375 | 150000 | 72500 | Not Applicable | 127500 | 0.1764705882352941 | Not Applicable | Not Applicable | Not Applicable | -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 | 180000 | Not Applicable | Not Applicable | Not Applicale | Not Applicablle | 31 | 180000 | 2000-02-01 00:00:00 | 30000 | 0.2 | 2000-02-02 00:00:00 | 2000-02-03 00:00:00 | Not Applicable | Not Applicable | 2000-02-04 00:00:00 | 2000-02-04 00:00:00 | 2000-02-10 00:00:00 | 2000-02-14 00:00:00 | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | -15875 | 180000 | 164125 | Land and vacant Improvements Transferred to DECS without revaluation | 2000-02-28 00:00:00 | 0 | 150000
3 | PERTH | 22 |  | 6 |  | BAAL | STREET | HOUSE | 2001-01-01 00:00:00 | MARIO COLELLA | SAPOL | -25000 | SAPOL | DEPOT | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | 2001-01-02 00:00:00 | 2001-01-09 00:00:00 | 2001-01-16 00:00:00 | 2001-01-17 00:00:00 | 2001-01-18 00:00:00 | 2001-01-19 00:00:00 | 2001-01-27 00:00:00 | 2001-01-28 00:00:00 | 2001-01-29 00:00:00 | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | 2000-02-06 00:00:00 | -250 | 75000 | 20000 | 15000 | 40000 | 0.75 | 2001-05-06 00:00:00 | -150 | 70000 | 0 | 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 | 70000 | Not Applicable | Not Applicable | Not Applicable | Not Applicable | 126 | 70000 | 2001-05-07 00:00:00 | 0 | 0 | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | 2001-05-07 00:00:00 | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | -25400 | 70000 | 44600 | Occupied Improvments only transferred to SAPOL with revaluation | 2001-05-31 00:00:00 | 0 | 70000
5 | PERTH | 22 |  | 12 |  | WEIR | ROAD | HOUSE | 2003-01-01 00:00:00 | MARIO COLELLA | Not Applicable | -15000 | Not Applicable | HPP | Not Applicable | 2002-12-27 00:00:00 | 2003-01-06 00:00:00 | 2003-01-06 00:00:00 | 2003-01-06 00:00:00 | Not Applicable | Not Applicable | 2003-01-08 00:00:00 | 2003-01-08 00:00:00 | 2003-01-09 00:00:00 | 2003-01-09 00:00:00 | 2003-01-16 00:00:00 | 2003-01-17 00:00:00 | 2003-01-18 00:00:00 | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | 2003-01-31 00:00:00 | -1500 | 180000 | 22000 | 15000 | 80000 | 0.4823529411764706 | Not Applicable | Not Applicable | Not Applicable | -250 | 2003-02-01 00:00:00 | 2003-02-08 00:00:00 | Not Applicable | 2003-02-08 00:00:00 | 2003-02-15 00:00:00 | 2003-02-16 00:00:00 | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | 180000 | Not Applicable | Not Applicable | Not Applicable | Not Applicable | 57 | 180000 | 2003-02-22 00:00:00 | 11000 | 0.0582010582010582 | 2003-02-24 00:00:00 | 2003-03-03 00:00:00 | 2003-03-03 00:00:00 | Not Applicable | 2003-03-03 00:00:00 | Not Applicable | 2003-03-10 00:00:00 | 2003-03-17 00:00:00 | -500 | -500 | -500 | -500 | -500 | -16875 | 200000 | 183125 | HPP settled with no revaluation | 2003-03-31 00:00:00 | 0 | 189000
8 | PERTH | 88 |  | 72 |  | PREMIER | CIRCLE | HOUSE | 2006-01-01 00:00:00 | [NAME] FOPPOLI | Not Applicable | Not Applicable | Not Applicable | SURPLUS | 2006-01-01 00:00:00 | Not Applicable | Not Applicable | 2006-01-08 00:00:00 | 2006-01-01 00:00:00 | Not Applicable | Not Applicable | 2006-01-01 00:00:00 | 2006-01-02 00:00:00 | 2006-01-09 00:00:00 | 2006-01-10 00:00:00 | 2006-01-17 00:00:00 | 2006-01-18 00:00:00 | 2006-01-19 00:00:00 | Not Applicable | Not Applicable | 2006-01-20 00:00:00 | Not Applicable | Not Applicable | 2006-01-27 00:00:00 | -285 | 487500 | 200000 | 185000 | 400000 | 0.25 | 2006-05-01 00:00:00 | -195 | 500000 | -2250 | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | 2006-02-01 00:00:00 | 2006-02-22 00:00:00 | 2006-03-01 00:00:00 | 2006-03-01 00:00:00 | [NAME] Albany | 2006-03-08 00:00:00 | 2006-03-10 00:00:00 | 2006-03-10 00:00:00 | 555000 | 2006-03-24 00:00:00 | Not Applicable | Not Applicable | Not Applicable | 52 | 552000 | 2006-05-01 00:00:00 | 52000 | 0.104 | 2006-05-08 00:00:00 | 2006-05-10 00:00:00 | Not Applicable | Not Applicable | 2006-05-10 00:00:00 | 2006-05-10 00:00:00 | 2006-05-17 00:00:00 | 2006-05-31 00:00:00 | -12144 | -500 | -250 | -50 | -750 | -16424 | 552000 | 535576 | Surplus with revaluation settled |  | 0 | 500000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL | -2760 | 1042500 | 387000 | 270000 | 775000 |  |  | -620 | 759000 | -3500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1182000 |  | 104000 |  |  |  |  |  |  |  |  |  | -12644 | -1000 | -750 | -550 | -2000 | -91449 | 1202000 | 1110551 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AVERAGE | -552 | 208500 | 77400 | 67500 | 155000 | 0.428235294117647 |  | -206.6666666666667 | 253000 | -700 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 65.2 | 236400 |  | 17333.33333333333 | 0.08408042328042328 |  |  |  |  |  |  |  |  | -6322 | -500 | -375 | -275 | -666.6666666666666 | -15241.5 | 200333.3333333333 | 185091.8333333333 |  |  | 0