Spreadsheet: 109999d1306804393-cut-and-pasting-from-one-worksheet-to-another-causes-formulas-to-give-errors-excel-alterations-web-forum-docment-2
Sheet: Detailed Summary

 | SURPLUS SALES
ALL SURPLUS SALES IN PROGRESS
PROPERTIES IN THE PROCESS OF DISPOSAL | 2
PROPERTIES ON THE MARKET | 2 | CURRENT MARKET VALUE * | 300000
PROPERTIES NOT ON THE MARKET | 0
ALL SURPLUS SALES UNDER CONTRACT
PROPERTIES DISPOSED AND AWAITING SETTLEMENT | 1 | TOTAL VALUE OF CONTRACTS | 160000
ALL SURPLUS SALES SETTLED
SALES SETTLED | 1
GROSS VALUE OF SETTLEMENTS | 160000 | AVERAGE GROSS SALE PRICE | 160000
NETT VALUE OF SETTLEMENTS | 154300 | AVERAGE NETT SALE PRICE | 154300
GROSS VALUE OF SETTLEMENTS TARGET | 7500000 | NETT VALUE OF SETTLEMENTS TARGET | 7425000
PROGRESS | 0.02133333333333333 | PROGRESS | 0.02078114478114478
* CURRENT MARKET VALUE IS DERIVED FROM THE VALUATIONS PROVIDED BY LICENSED VALUERS
 | HOME PURCHASE PLAN
ALL TENANT SALES IN PROGRESS
APPLICATIONS ACCEPTED BY BMAPS | 0 | APPLICATIONS LAPSED / WITHDRAWN / CANCELLED | 0
APPLICATIONS IN PROGRESS | 0 | OFFERS SENT | 0
CURRENT MARKET VALUE OF PROPERTIES FOR SALE | 0 | VALUE OF OFFERS SENT | 0
ALL TENANT SALES UNDER CONTRACT
PROPERTIES DISPOSED AND AWAITING SETTLEMENT | 0 | TOTAL VALUE OF CONTRACTS | 0
ALL TENANT SALES SETTLED
SALES SETTLED | 0
GROSS VALUE OF SETTLEMENTS | 0 | AVERAGE GROSS SALE PRICE | #N/A
NETT VALUE OF SETTLEMENTS | 0 | AVERAGE NETT SALE PRICE | #N/A
GROSS VALUE OF SETTLMENTS TARGET | 4000000 | NETT VALUE OF SETTLEMENTS TARGET | 3960000
PROGRESS | 0 | PROGRESS | 0
 | DEPOT PROPERTIES
ALL DEPOT SALES IN PROGRESS
PROPERTIES IN THE PROCESS OF DISPOSAL | 0
PROPERTIES ON THE MARKET | 0 | CURRENT MARKET VALUE ** | 0
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 | 0
GROSS VALUE OF SETTLEMENTS * | 0 | AVERAGE GROSS SALE PRICE | #N/A
NETT VALUE OF SETTLEMENTS | 0 | AVERAGE NETT SALE PRICE | #N/A
GROSS VALUE OF SETTLEMENTS TARGET | 8000000 | NETT VALUE OF SETTLEMENTS TARGET | 7920000
PROGRESS | 0 | PROGRESS | 0
* 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 | 1 | SALES SETTLED | 1
ALL SALES SETTLED
GROSS VALUE OF SETTLEMENTS | 160000 | AVERAGE GROSS SALE PRICE | 160000
NETT VALUE OF SETTLMENTS | 154300 | AVERAGE NETT SALE PRICE | 154300
PROGRESS TOWARDS TARGETS
TOTAL SALES TARGET | 50 | TOTAL SALES TO DATE | 1
 |  | PROGRESS | 0.02
GROSS TARGET | 11500000 | NETT TARGET | 11385000
PROGRESS | 0.01391304347826087 | PROGRESS | 0.01355292050944225
 | OVERALL SUMMARY
 | CURRENT FINANCIAL YEAR
OVERALL SALES PROGRESS
TOTAL PROPERTIES IN PROCESS OF DISPOSAL | 2
TOTAL PROPERTIES ON THE MARKET / HOME PURCHASE PLANS IN PROGRESS | 2 | TOTAL CURRENT MARKET VALUE * | 300000
TOTAL PROPERTIES NOT ON THE MARKET | 0
OVERALL SALES UNDER CONTRACT
TOTAL PROPERTIES DISPOSED AND AWAITING SETTLEMENT | 1 | TOTAL GROSS VALUE OF CONTRACTS | 160000
OVERALL SALES SETTLED
TOTAL PROPERTIES SETTLED | 1 | TOTAL GROSS VALUE OF SETTLEMENTS | 160000
 |  | TOTAL NETT VALUE OF SETTLEMENTS | 154300
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 | 0.8 | PROGRESS | 0.7792929292929293
 | OVERALL PROGRAM TARGETS
OVERALL PROGRESS TOWARD TARGETS
TOTAL SALES TARGET | 100 | TOTAL SALES TO DATE | 1
 |  | PROGRESS | 0.01
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