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: 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 | 1 |  |  |  |  |  | 0 | 0 | 450000 | 0 | 0 | 0 | 0 | 0
HPP | 1 | 1 | 1 | 0 | 0 | 1 |  |  | 297000 | 1 | 297000 | 0 | 0 | 0
SURPLUS | 1 |  |  |  |  |  | 1 | 0 | 350000 | 1 | 358500 | 0 | 0 | 0
TOTAL | 3 | 1 | 1 | 0 | 0 | 1 | 1 | 0 | 1097000 | 2 | 655500 | 0 | 0 | 0
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 | 3 |  |  |  |  |  | 3 | 0 | 409000 | 3 | 450000 | 3 | 450000 | 391850
HPP | 1 | 1 | 1 | 0 | 0 | 1 |  |  | 189000 | 1 | 180000 | 1 | 180000 | 183125
SURPLUS | 1 |  |  |  |  |  | 1 | 0 | 500000 | 1 | 552000 | 1 | 552000 | 535576
TOTAL | 5 | 1 | 1 | 0 | 0 | 1 | 4 | 0 | 1098000 | 5 | 1182000 | 5 | 1182000 | 1110551
CANCELLED 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 | 1 |  |  |  |  |  | 1 | 0 | 55000 | 0 | 0 | 0 | 0 | 0
HPP | 2 | 2 | 2 | 0 | 0 | 2 |  |  | 931000 | 0 | 0 | 0 | 0 | 0
SURPLUS | 1 |  |  |  |  |  | 1 | 0 | 375000 | 1 | 375000 | 0 | 0 | 0
TOTAL | 4 | 2 | 2 | 0 | 0 | 2 | 2 | 0 | 1361000 | 1 | 375000 | 0 | 0 | 0
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 | BM | BN | BP | BQ | BZ | CA | CB | CC | CD | CE | CF | CG
TOTAL | -2750 | 0 | 190000 | 460000 | 743000 |  | -1100 | 1097000 | -4000 |  | 655500 | -441500 |  | 0 | 0 | 0 | 0 | 0 | -22850 | 655500 | 632650
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
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 | BM | BN | BP | BQ | BZ | CA | CB | CC | CD | CE | CF | CG
TOTAL | -2760 | 1042500 | 387000 | 270000 | 775000 |  | -620 | 759000 | -3500 |  | 1182000 | 104000 |  | -12644 | -1000 | -750 | -550 | -2000 | -91449 | 1202000 | 1110551
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
CANCELLED 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 | BM | BN | BP | BQ | BZ | CA | CB | CC | CD | CE | CF | CG
TOTAL | -2850 | 1336000 | 555000 | 180000 | 875500 |  | -250 | 375000 | -2250 |  | 1306000 | -55000 |  | 0 | 0 | 0 | 0 | 0 | -60350 | 1306000 | 1245650
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