ExcelBanter - To calculate escalation cost for the construction industry

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - To calculate escalation cost for the construction industry (https://www.excelbanter.com/excel-worksheet-functions/190808-calculate-escalation-cost-construction-industry.html)

vmohan1978

To calculate escalation cost for the construction industry

Dia Rate Difference 8mm 10mm 12mm 16mm 20mm 25mm 32mm
16 14,124.00 - - - 19.155 - - -
16 14,124.00 - - - 19.340 - - -
20 14,072.00 - - - - 19.388 - -
20 14,072.00 - - - - 19.311 - -
10 13,500.00 - 6.320 - - - - -
8 20,000.00 1.932 - - - - - -
20 20,260.00 - - - - 19.427 - -
20 12,200.00 - - - - 12.602 - -
8 20,556.00 2.903 - - - - - -
My question if i am using 16mm dia in 5 Running Bills.
In June out of 19.155 i am using 5Mt and in August iam 12Mt and in
September ia m using 2.155MT.
How to apply formula or any other format avialble.
Please help me in this matter.

Bernard Liengme

To calculate escalation cost for the construction industry

You will need to spell this out in more detail. It is unclear what you want
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"vmohan1978" wrote in message
...
Dia Rate Difference 8mm 10mm 12mm 16mm 20mm 25mm 32mm
16 14,124.00 - - - 19.155 - - -
16 14,124.00 - - - 19.340 - - -
20 14,072.00 - - - - 19.388 - -
20 14,072.00 - - - - 19.311 - -
10 13,500.00 - 6.320 - - - - -
8 20,000.00 1.932 - - - - - -
20 20,260.00 - - - - 19.427 - -
20 12,200.00 - - - - 12.602 - -
8 20,556.00 2.903 - - - - - -
My question if i am using 16mm dia in 5 Running Bills.
In June out of 19.155 i am using 5Mt and in August iam 12Mt and in
September ia m using 2.155MT.
How to apply formula or any other format avialble.
Please help me in this matter.

Mohan

To calculate escalation cost for the construction industry

please if possible can you give your email id i will send you the soft copy
of the file in that i will mention more details .

"vmohan1978" wrote:

Dia Rate Difference 8mm 10mm 12mm 16mm 20mm 25mm 32mm
16 14,124.00 - - - 19.155 - - -
16 14,124.00 - - - 19.340 - - -
20 14,072.00 - - - - 19.388 - -
20 14,072.00 - - - - 19.311 - -
10 13,500.00 - 6.320 - - - - -
8 20,000.00 1.932 - - - - - -
20 20,260.00 - - - - 19.427 - -
20 12,200.00 - - - - 12.602 - -
8 20,556.00 2.903 - - - - - -
My question if i am using 16mm dia in 5 Running Bills.
In June out of 19.155 i am using 5Mt and in August iam 12Mt and in
September ia m using 2.155MT.
How to apply formula or any other format avialble.
Please help me in this matter.

All times are GMT +1. The time now is 03:45 AM.