Spreadsheet: 110120d1306889865-cut-and-pasting-from-one-worksheet-to-another-causes-formulas-to-give-errors-excel-alterations-web-forum-docment-2-tms
Sheet: Formulas

CURRENT TRANSACTIONS | PROPERTIES IN THE PROCESS OF DISPOSAL | HPP'S ACCEPTED BY BMAPS | HPP'S IN PROGRESS | HPP'S LAPSED / WITHDRAWN / CANCELLED | HPP'S AWAITING VALUATIONS | HPP OFFERS SENT | ON THE MARKET | NOT ON THE MARKET | CMV OF PROPERTIES ON THE MARKET | UNDER CONTRACT & AWAITING SETTLEMENT | VALUE OF CONTRACTS AWAITING SETTLEMENT | SALES SETTLED | GROSS VALUE OF CONTRACTS SETTLED | NETT VALUE OF CONTRACTS SETTLED
DEPOT | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
HPP | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
SURPLUS | 2 |  |  |  |  |  | 2 | 0 | 300000 | 1 | 160000 | 1 | 160000 | 154300
TOTAL | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 300000 | 1 | 160000 | 1 | 160000 | 154300
COMPLETED TRANSACTIONS | PROPERTIES IN THE PROCESS OF DISPOSAL | HPP'S ACCEPTED BY BMAPS | HPP'S IN PROGRESS | HPP'S LAPSED / WITHDRAWN / CANCELLED | HPP'S AWAITING VALUATIONS | HPP OFFERS SENT | ON THE MARKET | NOT ON THE MARKET | CMV OF PROPERTIES ON THE MARKET | UNDER CONTRACT & AWAITING SETTLEMENT | VALUE OF CONTRACTS AWAITING SETTLEMENT | SALES SETTLED | GROSS VALUE OF CONTRACTS SETTLED | NETT VALUE OF CONTRACTS SETTLED
DEPOT | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
HPP | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
SURPLUS | 1 |  |  |  |  |  | 1 | 0 | 150000 | 1 | 160000 | 1 | 160000 | 154300
TOTAL | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 150000 | 1 | 160000 | 1 | 160000 | 154300
CURRENT TRANSACTIONS | 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 MARKET VALUE (%) | MARKET RE-VALUATION FEE | REVISED MARKET VALUE | DEPARTMENT OF ENVIRONMENT AND NATURAL RESOURCES' FEES | DAYS ON THE MARKET | CONTRACT AMOUNT | DIFFERENCE BETWEEN CURRENT MARKET VALUE AND CONTRACT AMOUNT ($) | DIFFERENCE BETWEEN CURRENT MARKET VALUE AND CONTRACT AMOUNT (%) | PROFESSIONAL FEES | ADVERTISING FEES | MAINTENANCE COSTS | OTHER EXPENSES | CROWN SOLICITORS OFFICE FEES | TOTAL FEES | GROSS PROCEEDS OF SALE | NETT PROCEEDS OF SALE
COLUMN | AJ | AK | AL | AM | AN | AO | AQ | AR | AS | BL | BM | BO | BP | BY | BZ | CA | CB | CC | CD | CE | CF
TOTAL | -700 | 300000 | 145000 | 110000 | 255000 |  | -375 | 115000 | -1000 |  | 160000 | -105000 |  | -3300 | -750 | -225 | 0 | -575 | -6925 | 160000 | 153075
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
COMPLETED TRANSACTIONS | 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 MARKET VALUE (%) | MARKET RE-VALUATION FEE | REVISED MARKET VALUE | DEPARTMENT OF ENVIRONMENT AND NATURAL RESOURCES' FEES | DAYS ON THE MARKET | CONTRACT AMOUNT | DIFFERENCE BETWEEN CURRENT MARKET VALUE AND CONTRACT AMOUNT ($) | DIFFERENCE BETWEEN CURRENT MARKET VALUE AND CONTRACT AMOUNT (%) | PROFESSIONAL FEES | ADVERTISING FEES | MAINTENANCE COSTS | OTHER EXPENSES | CROWN SOLICITORS OFFICE FEES | TOTAL FEES | GROSS PROCEEDS OF SALE | NETT PROCEEDS OF SALE
COLUMN | AJ | AK | AL | AM | AN | AO | AQ | AR | AS | BL | BM | BO | BP | BY | BZ | CA | CB | CC | CD | CE | CF
TOTAL | -350 | 150000 | 72500 | 55000 | 127500 |  | 0 | 0 | -500 |  | 160000 | 10000 |  | -3300 | -750 | -225 | 0 | -575 | -5700 | 160000 | 154300
AVERAGE | -350 | 150000 | 72500 | 55000 | 127500 | 0.1764705882352941 | #N/A | #N/A | -500 | 281 | 160000 | 10000 | 0.06666666666666667 | -3300 | -750 | -225 | 0 | -575 | -5700 | 160000 | 154300