#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,696
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Escalation Formula Joe Gieder Excel Worksheet Functions 6 April 2nd 23 06:35 PM
To calculate escalation cost for the construction industry vmohan1978 Excel Worksheet Functions 2 June 13th 08 12:57 PM


All times are GMT +1. The time now is 05:08 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"