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

 | Unit |  | I-65-0 |  |  |  |  |  |  |  | I-65-1 |  |  |  |  |  |  |  | I-65-2
 | Total Price |  | 1175200
 |  |  | 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 |  | 646360 | 0 | 549450 | 96910.00000000007 |  |  |  |  | 411320 | 0 | 349650 | 61670.00000000004 |  |  |  |  | 117520 | -1.455191522836685e-11 | 99900 | 17620.00000000001
 | *All Currency in MYR
 | CN for Discount | 0 | 99440.00000000007 |  |  |  | 0 | -196350.0000000001 | 646360 |  | 63280.00000000004 |  |  |  | 0 | -124950 | 411320 |  | 18080.00000000001 |  |  |  | -1.455191522836685e-11 | -35700.00000000001 | 117520 |  | 180800.0000000001
 | Booking Fee | 0.1 | 5500 |  |  | 5500 | -5500 | -96910 | 640860 |  | 3500 |  |  | 3500 | -3500 | -61670 | 407820 |  | 1000 |  |  | 1000 | -1000.000000000015 | -17620 | 116520 |  | 10000
1 | Down Payment |  | 59136 |  |  | 59136 | -64636 | -91410 | 581724 |  | 37632 |  |  | 37632 | -41132 | -58170 | 370188 |  | 10752 |  |  | 10752 | -11752.00000000001 | -16620 | 105768 |  | 107520
2a | Earthworks | 0.1 | 64636 |  | 32362 | 32274.00000000007 | -129272 | -32274 | 517087.9999999999 |  | 41132 |  | 20594 | 20538.00000000004 | -82264 | -20538 | 329055.9999999999 |  | 11752 |  | 5884 | 5868.000000000011 | -23504.00000000001 | -5868 | 94015.99999999999 |  | 117520
2b | Piling | 0.1 | 64636 |  | 64636 |  | -193908 | 32362 | 452451.9999999999 |  | 41132 |  | 41132 |  | -123396 | 20594 | 287923.9999999999 |  | 11752 |  | 11752 |  | -35256.00000000001 | 5884 | 82263.99999999999 |  | 117520
2c | Sub Struc | 0.15 | 96954 |  | 96954 |  | -290862 | 96998 | 355497.9999999999 |  | 61698 |  | 61698 |  | -185094 | 61726 | 226225.9999999999 |  | 17628 |  | 17628 |  | -52884.00000000001 | 17636 | 64635.99999999999 |  | 176280
2d | Concrete | 0.15 | 96954 |  | 96954 |  | -387816 | 193952 | 258543.9999999999 |  | 61698 |  | 61698 |  | -246792 | 123424 | 164527.9999999999 |  | 17628 |  | 17628 |  | -70512.00000000001 | 35264 | 47007.99999999999 |  | 176280
2e | Walls | 0.1 | 64636 |  | 64636 |  | -452452 | 290906 | 193907.9999999999 |  | 41132 |  | 41132 |  | -287924 | 185122 | 123395.9999999999 |  | 11752 |  | 11752 |  | -82264.00000000001 | 52892 | 35255.99999999999 |  | 117520
2f | Ceiling | 0.05 | 32318 |  | 32318 |  | -484770 | 355542 | 161589.9999999999 |  | 20566 |  | 20566 |  | -308490 | 226254 | 102829.9999999999 |  | 5876 |  | 5876 |  | -88140.00000000001 | 64644 | 29379.99999999999 |  | 58760
2g | Wiring | 0.05 | 32318 |  | 32318 |  | -517088 | 387860 | 129271.9999999999 |  | 20566 |  | 20566 |  | -329056 | 246820 | 82263.99999999994 |  | 5876 |  | 5876 |  | -94016.00000000001 | 70520 | 23503.99999999999 |  | 58760
2h | Plaster | 0.05 | 32318 |  | 32318 |  | -549406 | 420178 | 96953.99999999994 |  | 20566 |  | 20566 |  | -349622 | 267386 | 61697.99999999994 |  | 5876 |  | 5876 |  | -99892.00000000001 | 76396 | 17627.99999999999 |  | 58760
2i | Roof | 0.05 | 32318 |  | 32318 |  | -581724 | 452496 | 64635.99999999994 |  | 20566 |  | 20566 |  | -370188 | 287952 | 41131.99999999994 |  | 5876 |  | 5876 |  | -105768 | 82272 | 11751.99999999999 |  | 58760
2j | Road | 0.05 | 32318 |  | 32318 |  | -614042 | 484814 | 32317.99999999994 |  | 20566 |  | 20566 |  | -390754 | 308518 | 20565.99999999994 |  | 5876 |  | 5876 |  | -111644 | 88148 | 5875.999999999985 |  | 58760
3 | CPC | 0.05 | 32318 |  | 32318 |  | -646360 | 517132 | 0 |  | 20566 |  | 20566 |  | -411320 | 329084 | 0 |  | 5876 |  | 5876 |  | -117520 | 94024 | 0 |  | 58760
 | Total | 1 | 745800 | 0 | 549450 | 96910.00000000007 | #N/A | 32362 | - |  | 474600 | 0 | 349650 | 61670.00000000004 | #N/A | 20594 | - |  | 135600 | 0 | 99900 | 17620.00000000001 | #N/A | 5884 | - |  | 1356000
 |  | Expected | Actual | % | Outstanding (Act-Exp) |  |  |  |  |  | [NAME]
 | Total Cash Paid | 0 | 0 | 0 | 0 |  |  |  |  |  | Total Loan | 999000
 | Total Loan | 999000 | 999000 | 0.85 | 0 |  |  |  |  |  | GF | 549450
 | Total CN | 176200.0000000001 | 176200.0000000001 | 0.15 | 0 |  |  |  |  |  | FF | 349650
 | Differential Sum (Cash + CN) | 176200 | 176200.0000000001 | 0.15 | 0 |  |  |  |  |  | SF | 99900
 | Apportionment of Differential Sum |  |  |  |  |  |  |  |  |  |  | Total CN + Cash | Deduct Return
 | Floor | To Bank | Differential Sum | Stage | % | Variance (Act-Exp) |  |  |  |  | 999000
 | GF | 646360 | 32362 | 2a | 0.05006807351940095 | 0 |  |  |  |  | 180800.0000000001 | 190800.0000000001 | 176200.0000000001
 | FF | 411320 | 20594 | 2a | 0.05006807351940095 | 0 |  |  |  |  | 10000
 | SF | 117520 | 5884 | 2a | 0.05006807351940095 | 0 |  |  |  |  | 1189800
 | Total | 1175200 | 58840 |  |  | 0 |  |  |  |  | 14600
 |  |  |  |  |  |  |  |  |  |  |  | 104940.0000000001 | 8030.000000000001 | 96910.00000000007
 |  |  |  |  |  |  |  |  |  |  |  | 66780.00000000004 | 5110 | 61670.00000000004
 |  |  |  |  |  |  |  |  |  |  |  | 19080.00000000001 | 1460 | 17620.00000000001
 |  |  |  |  |  |  |  |  |  |  |  |  | Refund