Spreadsheet: 110120d1306889865-cut-and-pasting-from-one-worksheet-to-another-causes-formulas-to-give-errors-excel-alterations-web-forum-docment-2-tms
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 | 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 | CHECK - SHOULD BE ZERO | COMMENTS | BMAPS RECORDS UPDATED & FILE CLOSED
1 | PERTH | 1 | 1 | 1 | A | FORRESTER | CIRCLE | DUPLEX | 2000-01-01 00:00:00 | UNASSIGNED | Not Applicable | Not Applicable | DECS | SURPLUS | 2000-01-01 00:00:00 | Not Applicable | Not Applicable | 2000-01-08 00:00:00 | 2000-01-08 00:00:00 | Not Applicable | Not Applicable | 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.1764705882352941 | Not Applicable | Not Applicable | Not Applicable | -500 | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | 2000-02-04 00:00:00 | 2000-02-25 00:00:00 | 2000-02-28 00:00:00 | 2000-02-28 00:00:00 | [NAME] Real Estate | 2000-03-03 00:00:00 | 2000-03-03 00:00:00 | 2000-03-03 00:00:00 | 2000-03-17 00:00:00 | 2000-06-03 00:00:00 | 2000-09-03 00:00:00 | 2000-12-03 00:00:00 | 281 | 160000 | 2000-12-09 00:00:00 | 10000 | 0.06666666666666667 | 2000-12-16 00:00:00 | 2000-12-17 00:00:00 | Not Applicable | Not Applicable | 2000-12-18 00:00:00 | 2000-12-18 00:00:00 | 2001-01-05 00:00:00 | 2001-01-09 00:00:00 | -3300 | -750 | -225 | 0 | -575 | -5700 | 160000 | 154300 | 0 |  | 2001-02-09 00:00:00
2 | PERTH | 1 | 1 | 1 | A | FORRESTER | CIRCLE | DUPLEX | 2000-01-01 00:00:00 | UNASSIGNED | Not Applicable | Not Applicable | DECS | SURPLUS | 2000-01-01 00:00:00 | Not Applicable | Not Applicable | 2000-01-08 00:00:00 | 2000-01-08 00:00:00 | Not Applicable | Not Applicable | 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.09803921568627451 | Not Applicable | -375 | 115000 | -500 | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | 2000-02-04 00:00:00 | 2000-02-25 00:00:00 | 2000-02-26 00:00:00 | 2000-02-26 00:00:00 | [NAME] Real Estate | 2000-03-03 00:00:00 | 2000-03-03 00:00:00 |  |  |  |  |  | 4107 |  |  | -115000 | -1 |  |  |  |  |  |  |  |  |  |  |  |  |  | -1225 | 0 | -1225 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL | -700 | 300000 | 145000 | 110000 | 255000 |  |  | -375 | 115000 | -1000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 160000 |  | -105000 |  |  |  |  |  |  |  |  |  | -3300 | -750 | -225 | 0 | -575 | -6925 | 160000 | 153075 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AVERAGE | -350 | 150000 | 72500 | 55000 | 127500 | 0.03921568627450981 |  | -375 | 115000 | -500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2194 | 160000 |  | -52500 | -0.4666666666666667 |  |  |  |  |  |  |  |  | -3300 | -750 | -225 | 0 | -575 | -3462.5 | 80000 | 76537.5 | 0