Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Escalation formula
4% QTY Excluding the Wastage Escalation cost is not for the
wastagae 3% DESCRIPTION Received Invoice No Dia Qty (MT) Basic Price Total Cost Excluding VAT/MT Vat Total Amount Including VAT/MT Rate Difference 8mm 10mm 12mm 16mm 20mm 25mm 32mm Total Paid Balance As Built Qty used as of RAB-02 As BuiltQty Escalation Qty Difference Rate Amount RA BILL NO.01 8mm 5.115 28-Mar-08 104174 16 19.73 44350 44350 1774 46124 14,124.00 - - - 19.155 - - - 19.155 19.155 0.000 SIL used 10mm instead of 8mm 5.115 13500 69052.5 28-Mar-08 104167 16 19.92 44350 44350 1774 46124 14,124.00 - - - 19.340 - - - 19.340 18.426 0.914 29-Mar-08 104215 20 19.97 44300 44300 1772 46072 14,072.00 - - - - 19.388 - - 19.388 19.388 0.000 29-Mar-03 104218 20 19.89 44300 44300 1772 46072 14,072.00 - - - - 19.311 - - 19.311 19.311 (0.000) 10mm 0 31-Mar-08 104405 10 6.51 43750 43750 1750 45500 13,500.00 - 6.320 - - - - - 6.320 5.115 1.205 14-Apr-08 195 8 1.99 50000 50000 2000 52000 20,000.00 1.932 - - - - - - 1.932 1.932 0.000 16-Apr-08 226 20 20.01 50000 50250 2010 52260 20,260.00 - - - - 19.427 - - 19.427 19.427 0.000 18-Apr-08 104701 20 12.98 42500 42500 1700 44200 12,200.00 - - - - 12.602 - - 12.602 12.602 (0.000) 12mm 0 18-Apr-08 237 8 2.99 50000 50535 2021.4 52556 20,556.00 2.903 - - - - - - 2.903 2.552 0.351 24-Apr-08 2008/BS1251 16 13.57 38498 46880 1875.2 48755 16,755.00 - - - 13.175 - - - 13.175 25-Apr-08 2008/35403 8 9.34 37542 45787 1831.48 47618 15,618.00 9.068 - - - - - - 9.068 1.581 7.487 27-Apr-08 325 16 15.23 36975.78 42308.78 1692.3512 44001 12,001.00 - - - 14.786 - - - 14.786 16mm 20.893 27-Apr-08 325 20 8.23 36975.78 42308.78 1692.3512 44001 12,001.00 - - - - 7.990 - - 7.990 3.406 4.584 19.155 14124 270545.22 28-Apr-08 333 20 25.00 36975.78 42308.78 1692.3512 44001 12,001.00 - - - - 24.272 - - 24.272 1.738 14124 24547.512 3-May-08 389 16 9.77 36975.78 42308.78 1692.3512 44001 12,001.00 - - - 9.485 - - - 9.485 3-May-08 389 20 10.00 36975.58 42308.58 1692.3432 44001 12,001.00 - - - - 9.709 - - 9.709 20mm 38.457 29-Feb-08 84003610 10 3.58 39711.53 39711.53 1588.4612 41300 9,300.00 - 3.476 - - - - - 3.476 19.388 14072 272827.936 8-May-08 427 8 5.00 37227.89 42597.89 1703.9156 44302 12,302.00 4.854 - - - - - - 4.854 19.069 14072 268338.968 8-May-08 427 20 20.00 36975.78 42308.78 1692.3512 44001 12,001.00 - - - - 19.417 - - 19.417 8-May-08 001402 32 24.94 37308 45519 1820.76 47340 15,340.00 - - - - - - 24.214 24.214 25mm 0 8-May-08 001401 32 24.05 37308 45519 1820.76 47340 15,340.00 - - - - - - 23.350 23.350 14-May-08 481 8 10.00 37227.89 42597.89 1703.9156 44302 12,302.00 9.709 - - - - - - 14-May-08 481 20 5.00 36975.78 42308.78 1692.3512 44001 12,001.00 - - - - 4.854 - - 32mm. 0 Total Escalation Amount for RAB-01 905,312.14 QTY USED AS OF RAB-01 5.115 0 0 20.893 38.457 0 0 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Escalation formula
Unfortunately, the below is very hard to read. Could you reply with the
specific question you have? "Mohan" wrote: 4% QTY Excluding the Wastage Escalation cost is not for the wastagae 3% DESCRIPTION Received Invoice No Dia Qty (MT) Basic Price Total Cost Excluding VAT/MT Vat Total Amount Including VAT/MT Rate Difference 8mm 10mm 12mm 16mm 20mm 25mm 32mm Total Paid Balance As Built Qty used as of RAB-02 As BuiltQty Escalation Qty Difference Rate Amount RA BILL NO.01 8mm 5.115 28-Mar-08 104174 16 19.73 44350 44350 1774 46124 14,124.00 - - - 19.155 - - - 19.155 19.155 0.000 SIL used 10mm instead of 8mm 5.115 13500 69052.5 28-Mar-08 104167 16 19.92 44350 44350 1774 46124 14,124.00 - - - 19.340 - - - 19.340 18.426 0.914 29-Mar-08 104215 20 19.97 44300 44300 1772 46072 14,072.00 - - - - 19.388 - - 19.388 19.388 0.000 29-Mar-03 104218 20 19.89 44300 44300 1772 46072 14,072.00 - - - - 19.311 - - 19.311 19.311 (0.000) 10mm 0 31-Mar-08 104405 10 6.51 43750 43750 1750 45500 13,500.00 - 6.320 - - - - - 6.320 5.115 1.205 14-Apr-08 195 8 1.99 50000 50000 2000 52000 20,000.00 1.932 - - - - - - 1.932 1.932 0.000 16-Apr-08 226 20 20.01 50000 50250 2010 52260 20,260.00 - - - - 19.427 - - 19.427 19.427 0.000 18-Apr-08 104701 20 12.98 42500 42500 1700 44200 12,200.00 - - - - 12.602 - - 12.602 12.602 (0.000) 12mm 0 18-Apr-08 237 8 2.99 50000 50535 2021.4 52556 20,556.00 2.903 - - - - - - 2.903 2.552 0.351 24-Apr-08 2008/BS1251 16 13.57 38498 46880 1875.2 48755 16,755.00 - - - 13.175 - - - 13.175 25-Apr-08 2008/35403 8 9.34 37542 45787 1831.48 47618 15,618.00 9.068 - - - - - - 9.068 1.581 7.487 27-Apr-08 325 16 15.23 36975.78 42308.78 1692.3512 44001 12,001.00 - - - 14.786 - - - 14.786 16mm 20.893 27-Apr-08 325 20 8.23 36975.78 42308.78 1692.3512 44001 12,001.00 - - - - 7.990 - - 7.990 3.406 4.584 19.155 14124 270545.22 28-Apr-08 333 20 25.00 36975.78 42308.78 1692.3512 44001 12,001.00 - - - - 24.272 - - 24.272 1.738 14124 24547.512 3-May-08 389 16 9.77 36975.78 42308.78 1692.3512 44001 12,001.00 - - - 9.485 - - - 9.485 3-May-08 389 20 10.00 36975.58 42308.58 1692.3432 44001 12,001.00 - - - - 9.709 - - 9.709 20mm 38.457 29-Feb-08 84003610 10 3.58 39711.53 39711.53 1588.4612 41300 9,300.00 - 3.476 - - - - - 3.476 19.388 14072 272827.936 8-May-08 427 8 5.00 37227.89 42597.89 1703.9156 44302 12,302.00 4.854 - - - - - - 4.854 19.069 14072 268338.968 8-May-08 427 20 20.00 36975.78 42308.78 1692.3512 44001 12,001.00 - - - - 19.417 - - 19.417 8-May-08 001402 32 24.94 37308 45519 1820.76 47340 15,340.00 - - - - - - 24.214 24.214 25mm 0 8-May-08 001401 32 24.05 37308 45519 1820.76 47340 15,340.00 - - - - - - 23.350 23.350 14-May-08 481 8 10.00 37227.89 42597.89 1703.9156 44302 12,302.00 9.709 - - - - - - 14-May-08 481 20 5.00 36975.78 42308.78 1692.3512 44001 12,001.00 - - - - 4.854 - - 32mm. 0 Total Escalation Amount for RAB-01 905,312.14 QTY USED AS OF RAB-01 5.115 0 0 20.893 38.457 0 0 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Escalation Formula | Excel Worksheet Functions | |||
To calculate escalation cost for the construction industry | Excel Worksheet Functions |