Spreadsheet: 355963d1414873749-seek-for-suggestions-on-how-to-display-the-data-for-easy-reference-customer-database-excel-forum-edited-
Sheet: B09

 | Unit | [NAME] | B-9-0 |  |  |  |  |  |  |  | B-9-1 |  |  |  |  |  |  |  | B-9-2
 | Total Price |  | 1451409
 |  |  | Ground Floor | Cash | Loan | CN/DN | [NAME] | [NAME] | Balance |  | Ground Floor | Cash | Loan | CN/DN | [NAME] | [NAME] | Balance |  | Ground Floor | Cash | Loan | CN/DN | [NAME] | [NAME] | Balance |  | Total
 | Original Price / Loan Amount |  | 798275 | 750378.5 |  | 47896.5 |  |  |  |  | 507993 | 477513.42 |  | 30479.58 |  |  |  |  | 145141 | 136432.44 |  | 8708.56
 | *All Currency in MYR
 | CN for Discount | 0.06 | 47896.5 |  |  | 47896.5 | 750378.5 | -798275 | 750378.5 |  | 30479.58 |  |  | 30479.58 | 477513.42 | -507993.0000000001 | 477513.42 |  | 8708.46 |  |  | 8708.46 | 136432.44 | -145141 | 136432.54 |  | 87084.54000000001
 | Booking Fee | 0.04000000000000001 | 5500 | 5500 |  |  | 744878.5 | -750378.5 | 744878.5 |  | 3500 | 3500 |  |  | 474013.42 | -477513.42 | 474013.42 |  | 1000 | 1000 |  |  | 135432.44 | -136432.54 | 135432.54 |  | 10000
1 | Down Payment |  | 26431 | 26431 |  |  | 718447.5 | -744878.5 | 718447.5 |  | 16819.72 | 16819.72 |  |  | 457193.7 | -474013.42 | 457193.7 |  | 4805.640000000001 | 4805.64 |  |  | 130626.8 | -135432.54 | 130626.9 |  | 48056.36
2a | Earthworks | 0.1 | 79827.5 | 79827.5 |  |  | 638620 | -718447.5 | 638620 |  | 50799.3 | 50799.3 |  |  | 406394.4 | -457193.7 | 406394.4 |  | 14514.1 | 14514.1 |  | 0.1 | 116112.7 | -130626.9 | 116112.7 |  | 145140.9
2b | Piling | 0.1 | 79827.5 | 79827.5 |  |  | 558792.5 | -638620 | 558792.5 |  | 50799.3 | 50799.3 |  |  | 355595.1 | -406394.4 | 355595.1 |  | 14514.1 | 14514.1 |  |  | 101598.6 | -116112.8 | 101598.6 |  | 145140.9
2c | Sub Struc | 0.15 | 119741.25 | 119741.25 |  |  | 439051.25 | -558792.5 | 439051.25 |  | 76198.95 | 76198.95 |  |  | 279396.15 | -355595.1 | 279396.15 |  | 21771.15 | 21771.15 |  |  | 79827.45 | -101598.7 | 79827.45000000001 |  | 217711.35
2d | Concrete | 0.15 | 119741.25 | 119714.25 |  |  | 319310 | -439051.25 | 319337 |  | 76198.95 | 76198.95 |  |  | 203197.2 | -279396.15 | 203197.2 |  | 21771.15 | 21771.15 |  |  | 58056.3 | -79827.55 | 58056.30000000001 |  | 217711.35
2e | Walls | 0.1 | 79827.5 | 79827.5 |  |  | 239482.5 | -319310 | 239509.5 |  | 50799.3 | 50799.3 |  |  | 152397.9 | -203197.2 | 152397.9 |  | 14514.1 | 14514.1 |  |  | 43542.2 | -58056.4 | 43542.20000000001 |  | 145140.9
2f | Ceiling | 0.05 | 39913.75 | 39913.75 |  |  | 199568.75 | -239482.5 | 199595.75 |  | 25399.65 | 25399.65 |  |  | 126998.25 | -152397.9 | 126998.25 |  | 7257.05 | 7257.05 |  |  | 36285.15 | -43542.3 | 36285.15000000001 |  | 72570.45
2g | Wiring | 0.05 | 39913.75 | 39913.75 |  |  | 159655 | -199568.75 | 159682 |  | 25399.65 | 25399.65 |  |  | 101598.6 | -126998.25 | 101598.6 |  | 7257.05 | 7257.05 |  |  | 29028.1 | -36285.25 | 29028.10000000001 |  | 72570.45
2h | Plaster | 0.05 | 39913.75 | 39913.75 |  |  | 119741.25 | -159655 | 119768.25 |  | 25399.65 | 25399.65 |  |  | 76198.94999999998 | -101598.6 | 76198.94999999998 |  | 7257.05 | 7257.05 |  |  | 21771.05 | -29028.2 | 21771.05000000001 |  | 72570.45
2i | Roof | 0.05 | 39913.75 | 39913.75 |  |  | 79827.5 | -119741.25 | 79854.5 |  | 25399.65 | 25399.65 |  |  | 50799.29999999998 | -76198.95000000001 | 50799.29999999998 |  | 7257.05 | 7257.05 |  |  | 14514 | -21771.15 | 14514.00000000001 |  | 72570.45
2j | Road | 0.05 | 39913.75 |  |  |  | 39913.75 | -79827.5 | 79854.5 |  | 25399.65 |  |  |  | 25399.64999999998 | -50799.3 | 50799.29999999998 |  | 7257.05 |  |  |  | 7256.950000000003 | -14514.1 | 14514.00000000001 |  | 72570.45
3 | CPC | 0.05 | 39913.75 |  |  |  | 0 | -39913.75 | 79854.5 |  | 25399.65 |  |  |  | 0 | -25399.65 | 50799.3 |  | 7257.05 |  |  |  | -0.09999999999672582 | -7257.05 | 14514 |  | 72570.45
 | Total | 1 | 798275 | 670524 | 0 | 47896.5 | 39913.75 | #N/A | - |  | 507993.0000000002 | 426714.1200000001 | 0 | 30479.58 | 25399.64999999998 | #N/A | - |  | 145141 | 121918.44 | 0 | 8708.56 | 7256.950000000003 | #N/A | - |  | 1451409
 |  | Expected | Actual | % | Outstanding (Act-Exp) |  |  |  |  |  | [NAME]
 | Total Cash Paid | 1364324.36 | 1219156.56 | 0.94 | -145167.8 |  |  |  |  |  | Total Loan | 0
 | Total Loan | 0 | 0 | 0 | 0 |  |  |  |  |  | GF | 0
 | Total CN | 87084.64 | 87084.64 | 0.06 | 0 |  |  |  |  |  | FF | 0
 | Differential Sum (Cash + CN) | 1451409 | 1306241.2 | 1 | -145167.8 |  |  |  |  |  | SF | 0
 | Apportionment of Differential Sum
 | Floor | To Bank | Differential Sum | Stage | % | Variance (Act-Exp)
 | GF | 798275 | 0 |  | 0 | 0
 | FF | 507993 | 0 |  | 0 | 0
 | SF | 145141 | 0 |  | 0 | 0
 | Total | 1451409 | 0 |  |  | 0
 | Floor | To Customer | Final Amount (Exp) | Stage | % | Variance (Act-Exp)
 | GF | 798275 | 0 |  | 0 | 0
 | FF | 507993 | 0 |  | 0 | 0
 | SF | 145141 | 0 |  | 0 | 0
 | Total | 1451409 | 0 |  |  | 0