Spreadsheet: 354064d1414133758-seek-for-suggestions-on-how-to-display-the-data-for-easy-reference-customer-database-excel-forum
Sheet: B15

 | Unit |  | B-15-0 |  |  |  |  |  |  |  | B-15-1 |  |  |  |  |  |  |  | B-15-2
 | Total Price |  | 1191573
 |  |  | 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 |  | 655365 | 635704.05 |  | 19660.95 |  |  |  |  | 417051 | 404539.47 |  | 12511.53 |  |  |  |  | 119157 | 115582.28 |  | 3574.72
 | *All Currency in MYR
 | CN for Discount | 0.03 | 19660.95 |  |  | 19660.95 | 635704.05 | -655365 | 635704.05 |  | 12511.53 |  |  | 12511.53 | 404539.47 | -417051 | 404539.47 |  | 3574.72 |  |  | 3574.72 | 115582.28 | -119157 | 115582.28 |  | 35747.2
 | Booking Fee | 0.07 | 5500 | 5500 |  |  | 630204.05 | -635704.05 | 630204.05 |  | 3500 | 3500 |  |  | 401039.47 | -404539.47 | 401039.47 |  | 1000 | 1000 |  |  | 114582.28 | -115582.28 | 114582.28 |  | 10000
1 | Down Payment |  | 40375.55 | 40375.55 |  |  | 589828.5 | -630204.05 | 589828.5 |  | 25693.57000000001 | 25693.57000000001 |  |  | 375345.9 | -401039.47 | 375345.9 |  | 7340.98 | 7340.98 |  |  | 107241.3 | -114582.28 | 107241.3 |  | 73410.1
2a | Earthworks | 0.1 | 65536.5 | 65536.5 |  |  | 524292 | -589828.5 | 524292 |  | 41705.10000000001 | 41705.1 |  |  | 333640.7999999999 | -375345.9 | 333640.8 |  | 11915.7 | 11915.7 |  |  | 95325.6 | -107241.3 | 95325.6 |  | 119157.3
2b | Piling | 0.1 | 65536.5 | 65536.5 |  |  | 458755.5 | -524292 | 458755.5 |  | 41705.10000000001 | 41705.1 |  |  | 291935.7 | -333640.8 | 291935.7 |  | 11915.7 | 11915.7 |  |  | 83409.90000000001 | -95325.6 | 83409.90000000001 |  | 119157.3
2c | Sub Struc | 0.15 | 98304.75 | 98304.75 |  |  | 360450.75 | -458755.5 | 360450.75 |  | 62557.64999999999 | 62557.65 |  |  | 229378.05 | -291935.7 | 229378.05 |  | 17873.55 | 17873.55 |  |  | 65536.35 | -83409.90000000001 | 65536.35 |  | 178735.95
2d | Concrete | 0.15 | 98304.75 |  |  |  | 262146 | -360450.75 | 360450.75 |  | 62557.64999999999 |  |  |  | 166820.4 | -229378.05 | 229378.05 |  | 17873.55 |  |  |  | 47662.8 | -65536.35 | 65536.35 |  | 178735.95
2e | Walls | 0.1 | 65536.5 |  |  |  | 196609.5 | -262146 | 360450.75 |  | 41705.10000000001 |  |  |  | 125115.3 | -166820.4 | 229378.05 |  | 11915.7 |  |  |  | 35747.10000000001 | -47662.8 | 65536.35 |  | 119157.3
2f | Ceiling | 0.05 | 32768.25 |  |  |  | 163841.25 | -196609.5 | 360450.75 |  | 20852.55 |  |  |  | 104262.75 | -125115.3 | 229378.05 |  | 5957.85 |  |  |  | 29789.25000000001 | -35747.1 | 65536.35 |  | 59578.65
2g | Wiring | 0.05 | 32768.25 |  |  |  | 131073 | -163841.25 | 360450.75 |  | 20852.55 |  |  |  | 83410.19999999995 | -104262.75 | 229378.05 |  | 5957.85 |  |  |  | 23831.40000000001 | -29789.25 | 65536.35 |  | 59578.65
2h | Plaster | 0.05 | 32768.25 |  |  |  | 98304.75 | -131073 | 360450.75 |  | 20852.55 |  |  |  | 62557.64999999995 | -83410.20000000001 | 229378.05 |  | 5957.85 |  |  |  | 17873.55000000001 | -23831.4 | 65536.35 |  | 59578.65
2i | Roof | 0.05 | 32768.25 |  |  |  | 65536.5 | -98304.75 | 360450.75 |  | 20852.55 |  |  |  | 41705.09999999995 | -62557.65000000001 | 229378.05 |  | 5957.85 |  |  |  | 11915.70000000001 | -17873.55 | 65536.35 |  | 59578.65
2j | Road | 0.05 | 32768.25 |  |  |  | 32768.25 | -65536.5 | 360450.75 |  | 20852.55 |  |  |  | 20852.54999999994 | -41705.10000000001 | 229378.05 |  | 5957.85 |  |  |  | 5957.850000000009 | -11915.7 | 65536.35 |  | 59578.65
3 | CPC | 0.05 | 32768.25 |  |  |  | 0 | -32768.25 | 360450.75 |  | 20852.55 |  |  |  | -5.820766091346741e-11 | -20852.55 | 229378.05 |  | 5957.85 |  |  |  | 9.094947017729282e-12 | -5957.85 | 65536.35 |  | 59578.65
 | Total | 1 | 655365 | 275253.3 | 0 | 19660.95 | 32768.25 | #N/A | - |  | 417050.9999999999 | 175161.42 | 0 | 12511.53 | 20852.54999999994 | #N/A | - |  | 119157 | 50045.93 | 0 | 3574.72 | 9.094947017729282e-12 | #N/A | - |  | 1191573
 |  | Expected | Actual | % | Outstanding (Act-Exp) |  |  |  |  |  | [NAME]
 | Total Cash Paid | 1155825.8 | 500460.65 | 0.97 | -655365.1500000001 |  |  |  |  |  | Total Loan | 0
 | Total Loan | 0 | 0 | 0 | 0 |  |  |  |  |  | GF | 0
 | Total CN | 35747.2 | 35747.2 | 0.03 | 0 |  |  |  |  |  | FF | 0
 | Differential Sum (Cash + CN) | 1191573 | 536207.85 | 1 | -655365.15 |  |  |  |  |  | SF | 0
 | Apportionment of Differential Sum |  |  |  |  |  |  |  |  |  | **Notes: Change Unit from K77 to B15
 | Floor | To Bank | Differential Sum | Stage | % | Variance (Act-Exp) |  |  |  |  |  |  | K77 | B15 |  |  | Amount Due |  | Remarks
 | GF | 655365 | 0 |  | 0 | 0 |  |  |  |  |  |  | RM | RM |  |  | RM
 | FF | 417051 | 0 |  | 0 | 0 |  |  |  |  | Unit Price |  | 1179658 | 1191573
 | SF | 119157 | 0 |  | 0 | 0
 | Total | 1191573 | 0 |  |  | 0 |  |  |  |  | 3% CN Discount |  | 35458 | 35747.2
 |  |  |  |  |  |  |  |  |  |  | Commitment Fee |  | 10000 | 10000 |  |  | 0
 | Floor | To Customer | Final Amount (Exp) | Stage | % | Variance (Act-Exp) |  |  |  |  | Down Payment |  | 72507.8 | 73410.1 |  |  | 902.3000000000029
 | GF | 655365 | 0 |  | 0 | 0 |  |  |  |  | Earthwork |  | 117965.8 | 119157.3 |  |  | 1191.5
 | FF | 417051 | 0 |  | 0 | 0 |  |  |  |  | Total Paid |  | 235931.6 | 202567.4 |  |  | 2093.800000000003 |  | Balance to be credited from 2(b) Piling
 | SF | 119157 | 0 |  | 0 | 0
 | Total | 1191573 | 0 |  |  | 0