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: Detailed Summary

 | SURPLUS SALES
ALL SURPLUS SALES IN PROGRESS
PROPERTIES IN THE PROCESS OF DISPOSAL | 1
PROPERTIES ON THE MARKET | 1 | CURRENT MARKET VALUE * | 350000
PROPERTIES NOT ON THE MARKET | 0
ALL SURPLUS SALES UNDER CONTRACT
PROPERTIES DISPOSED AND AWAITING SETTLEMENT | 1 | TOTAL VALUE OF CONTRACTS | 358500
ALL SURPLUS SALES SETTLED
SALES SETTLED | 1
GROSS VALUE OF SETTLEMENTS | 552000 | AVERAGE GROSS SALE PRICE | 552000
NETT VALUE OF SETTLEMENTS | 535576 | AVERAGE NETT SALE PRICE | 535576
GROSS VALUE OF SETTLEMENTS TARGET | 7500000 | NETT VALUE OF SETTLEMENTS TARGET | 7425000
PROGRESS | 0.0736 | PROGRESS | 0.07213144781144781
* CURRENT MARKET VALUE IS DERIVED FROM THE VALUATIONS PROVIDED BY LICENSED VALUERS
 | HOME PURCHASE PLAN
ALL TENANT SALES IN PROGRESS
APPLICATIONS ACCEPTED BY BMAPS | 1 | APPLICATIONS LAPSED / WITHDRAWN / CANCELLED | 0
APPLICATIONS IN PROGRESS | 1 | OFFERS SENT | 1
CURRENT MARKET VALUE OF PROPERTIES FOR SALE | 297000 | VALUE OF OFFERS SENT | 297000
ALL TENANT SALES UNDER CONTRACT
PROPERTIES DISPOSED AND AWAITING SETTLEMENT | 1 | TOTAL VALUE OF CONTRACTS | 297000
ALL TENANT SALES SETTLED
SALES SETTLED | 1
GROSS VALUE OF SETTLEMENTS | 180000 | AVERAGE GROSS SALE PRICE | 180000
NETT VALUE OF SETTLEMENTS | 183125 | AVERAGE NETT SALE PRICE | 183125
GROSS VALUE OF SETTLMENTS TARGET | 4000000 | NETT VALUE OF SETTLEMENTS TARGET | 3960000
PROGRESS | 0.045 | PROGRESS | 0.04624368686868687
 | DEPOT PROPERTIES
ALL DEPOT SALES IN PROGRESS
PROPERTIES IN THE PROCESS OF DISPOSAL | 1
PROPERTIES ON THE MARKET | 0 | CURRENT MARKET VALUE ** | 450000
PROPERTIES NOT ON THE MARKET | 0
ALL DEPOT SALES UNDER CONTRACT
PROPERTIES DISPOSED AND AWAITING SETTLEMENT | 0 | TOTAL VALUE OF CONTRACTS | 0
ALL DEPOT SALES SETTLED
SALES SETTLED | 3
GROSS VALUE OF SETTLEMENTS * | 450000 | AVERAGE GROSS SALE PRICE | 150000
NETT VALUE OF SETTLEMENTS | 391850 | AVERAGE NETT SALE PRICE | 130616.6666666667
GROSS VALUE OF SETTLEMENTS TARGET | 8000000 | NETT VALUE OF SETTLEMENTS TARGET | 7920000
PROGRESS | 0.05625 | PROGRESS | 0.0494760101010101
* SOME DEPOT PROPERTIES ARE TRANSFERRED AT NIL VALUE | ** CURRENT MARKET VALUE IS DERIVED FROM THE VALUATIONS PROVIDED BY LICENSED VALUERS
 | SURPLUS SALES AND HOME PURCHASE PLAN SUMMARY
ALL SALES IN PROGRESS
PROPERTIES IN THE PROCESS OF DISPOSAL | 2 | PROPERTIES ON THE MARKET / HOME PURCHASE PLANS IN PROGRESS | 2
ALL SALES UNDER CONTRACT
PROPERTIES DISPOSED AND AWAITING SETTLEMENT | 2 | SALES SETTLED | 2
ALL SALES SETTLED
GROSS VALUE OF SETTLEMENTS | 732000 | AVERAGE GROSS SALE PRICE | 366000
NETT VALUE OF SETTLMENTS | 718701 | AVERAGE NETT SALE PRICE | 359350.5
PROGRESS TOWARDS TARGETS
TOTAL SALES TARGET | 50 | TOTAL SALES TO DATE | 2
 |  | PROGRESS | 0.04
GROSS TARGET | 11500000 | NETT TARGET | 11385000
PROGRESS | 0.06365217391304348 | PROGRESS | 0.0631270092226614
 | OVERALL SUMMARY
 | CURRENT FINANCIAL YEAR
OVERALL SALES PROGRESS
TOTAL PROPERTIES IN PROCESS OF DISPOSAL | 3
TOTAL PROPERTIES ON THE MARKET / HOME PURCHASE PLANS IN PROGRESS | 2 | TOTAL CURRENT MARKET VALUE * | 1097000
TOTAL PROPERTIES NOT ON THE MARKET | 0
OVERALL SALES UNDER CONTRACT
TOTAL PROPERTIES DISPOSED AND AWAITING SETTLEMENT | 2 | TOTAL GROSS VALUE OF CONTRACTS | 655500
OVERALL SALES SETTLED
TOTAL PROPERTIES SETTLED | 5 | TOTAL GROSS VALUE OF SETTLEMENTS | 1182000
 |  | TOTAL NETT VALUE OF SETTLEMENTS | 1110551
OVERALL CASHFLOW
CARRYOVER FROM 2009/2010 | 0 | TOTAL VALUE OF CARRYOVER | 0
OVERALL PROGRESS TOWARD TARGETS
GROSS SALES VALUE TARGET | 200000 | NETT SALES VALUE TARGET | 198000
PROGRESS | 5.91 | PROGRESS | 5.608843434343434
 | OVERALL PROGRAM TARGETS
OVERALL PROGRESS TOWARD TARGETS
TOTAL SALES TARGET | 100 | TOTAL SALES TO DATE | 5
 |  | PROGRESS | 0.05
GROSS SALES VALUE TARGET | 20000000 | NETT SALES VALUE TARGET | 19800000
PROGRESS | 0.01 | PROGRESS | 0.01
* CURRENT MARKET VALUE IS DERIVED FROM THE VALUATIONS PROVIDED BY LICENSED VALUERS