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

 | Unit |  | I-66-0 |  |  |  |  |  |  |  | I-66-1 |  |  |  |  |  |  |  | I-66-2
 | Total Price |  | 1341500
 |  |  | 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 |  | 737825 | 0 | 627000 | 110825 |  |  |  |  | 469525 | 0 | 399000 | 70524.99999999999 |  |  |  |  | 134150 | 0 | 114000 | 20150
 | *All Currency in MYR
 | CN for Discount | 0 | 113511.5384615384 |  |  |  | 0 | -224336.5384615384 | 737825 |  | 72234.61538461533 |  |  |  | 0 | -142759.6153846153 | 469525 |  | 20638.46153846153 |  |  |  | 0 | -40788.46153846153 | 134150 |  | 206384.6153846153
 | Booking Fee | 0.1 | 5500 |  |  | 5500 | -5500 | -110825 | 732325 |  | 3500 |  |  | 3500 | -3500 | -70525 | 466025 |  | 1000 |  |  | 1000 | -1000 | -20150 | 133150 |  | 10000
1 | Down Payment |  | 68282.5 |  |  | 68282.5 | -73782.5 | -105325 | 664042.5 |  | 43452.5 |  |  | 43452.5 | -46952.5 | -67025 | 422572.5 |  | 12415 |  |  | 12415 | -13415 | -19150 | 120735 |  | 124150
2a | Earthworks | 0.1 | 73782.5 |  | 36740 | 37042.5 | -147565 | -37042.5 | 590260 |  | 46952.5 |  | 23380 | 23572.49999999999 | -93905 | -23572.5 | 375620 |  | 13415 |  | 6680 | 6735.000000000004 | -26830 | -6735 | 107320 |  | 134150
2b | Piling | 0.1 | 73782.5 |  | 73782.5 |  | -221347.5 | 36740 | 516477.5 |  | 46952.5 |  | 46952.5 |  | -140857.5 | 23380 | 328667.5 |  | 13415 |  | 13415 |  | -40245 | 6680 | 93905 |  | 134150
2c | Sub Struc | 0.15 | 110673.75 |  | 110673.75 |  | -332021.25 | 110522.5 | 405803.75 |  | 70428.75 |  | 70428.75 |  | -211286.25 | 70332.5 | 258238.75 |  | 20122.5 |  | 20122.5 |  | -60367.5 | 20095 | 73782.5 |  | 201225
2d | Concrete | 0.15 | 110673.75 |  | 110673.75 |  | -442695 | 221196.25 | 295130 |  | 70428.75 |  | 70428.75 |  | -281715 | 140761.25 | 187810 |  | 20122.5 |  | 20122.5 |  | -80490 | 40217.5 | 53660 |  | 201225
2e | Walls | 0.1 | 73782.5 |  | 73782.5 |  | -516477.5 | 331870 | 221347.5 |  | 46952.5 |  | 46952.5 |  | -328667.5 | 211190 | 140857.5 |  | 13415 |  | 13415 |  | -93905 | 60340 | 40245 |  | 134150
2f | Ceiling | 0.05 | 36891.25 |  | 36891.25 |  | -553368.75 | 405652.5 | 184456.25 |  | 23476.25 |  | 23476.25 |  | -352143.75 | 258142.5 | 117381.25 |  | 6707.5 |  | 6707.5 |  | -100612.5 | 73755 | 33537.5 |  | 67075
2g | Wiring | 0.05 | 36891.25 |  | 36891.25 |  | -590260 | 442543.75 | 147565 |  | 23476.25 |  | 23476.25 |  | -375620 | 281618.75 | 93905 |  | 6707.5 |  | 6707.5 |  | -107320 | 80462.5 | 26830 |  | 67075
2h | Plaster | 0.05 | 36891.25 |  | 36891.25 |  | -627151.25 | 479435 | 110673.75 |  | 23476.25 |  | 23476.25 |  | -399096.25 | 305095 | 70428.75 |  | 6707.5 |  | 6707.5 |  | -114027.5 | 87170 | 20122.5 |  | 67075
2i | Roof | 0.05 | 36891.25 |  | 36891.25 |  | -664042.5 | 516326.25 | 73782.5 |  | 23476.25 |  | 23476.25 |  | -422572.5 | 328571.25 | 46952.5 |  | 6707.5 |  | 6707.5 |  | -120735 | 93877.5 | 13415 |  | 67075
2j | Road | 0.05 | 36891.25 |  | 36891.25 |  | -700933.75 | 553217.5 | 36891.25 |  | 23476.25 |  | 23476.25 |  | -446048.75 | 352047.5 | 23476.25 |  | 6707.5 |  | 6707.5 |  | -127442.5 | 100585 | 6707.5 |  | 67075
3 | CPC | 0.05 | 36891.25 |  | 36891.25 |  | -737825 | 590108.75 | 0 |  | 23476.25 |  | 23476.25 |  | -469525 | 375523.75 | 0 |  | 6707.5 |  | 6707.5 |  | -134150 | 107292.5 | 0 |  | 67075
 | Total | 1 | 851336.5384615384 | 0 | 627000 | 110825 | #N/A | 36740 | - |  | 541759.6153846153 | 0 | 399000 | 70524.99999999999 | #N/A | 23380 | - |  | 154788.4615384615 | 0 | 114000 | 20150 | #N/A | 6680 | - |  | 1547884.615384615
 |  | Expected | Actual | % | Outstanding (Act-Exp) |  |  |  |  |  | [NAME]
 | Total Cash Paid | 0 | 0 | 0 | 0 |  |  |  |  |  | Total Loan | 1140000
 | Total Loan | 1140000 | 1140000 | 0.85 | 0 |  |  |  |  |  | GF | 627000
 | Total CN | 201500 | 201500 | 0.15 | 0 |  |  |  |  |  | FF | 399000
 | Differential Sum (Cash + CN) | 201500 | 201500 | 0.15 | 0 |  |  |  |  |  | SF | 114000
 | Apportionment of Differential Sum |  |  |  |  |  |  |  |  |  |  | Total CN + Cash | Deduct Return
 | Floor | To Bank | Differential Sum | Stage | % | Variance (Act-Exp) |  |  |  |  | 1140000
 | GF | 737825 | 36740 | 2a | 0.04979500559075661 | 0 |  |  |  |  | 206384.6153846153 | 216384.6153846153 | 201500
 | FF | 469525 | 23380 | 2a | 0.04979500559075661 | 0 |  |  |  |  | 10000
 | SF | 134150 | 6680 | 2a | 0.04979500559075661 | 0 |  |  |  |  | 1356384.615384615
 | Total | 1341500 | 66800 |  |  | 0 |  |  |  |  | 14884.61538461526
 |  |  |  |  |  |  |  |  |  |  |  | 119011.5384615384 | 8186.538461538394 | 110825
 |  |  |  |  |  |  |  |  |  |  |  | 75734.61538461533 | 5209.61538461534 | 70524.99999999999
 |  |  |  |  |  |  |  |  |  |  |  | 21638.46153846153 | 1488.461538461526 | 20150
 |  |  |  |  |  |  |  |  |  |  |  |  | Refund