nxstructural

Running account bills and final bill

One row per bill, in order. Each bill has its own period (start and end date); periods must follow one another without overlapping, and the final account bill must be the last. Values are the work done during the bill period at agreement rates; items not eligible for escalation are deducted.

Contract

Escalation statement name

Name of work

Agreement no.

Contractor

Employer / department

Division / office

Contract value (₹)

Date of start of work

Stipulated date of completion

Base month of indices normally the month before the last date of bid submission

Labour index centre (CPI-IW, Labour Bureau) the labour component uses this centre's CPI-IW from the index database

Wholesale price index series (OEA) for a base month before April 2023 use 2011-12 - its months after April 2026 are linked to the 2022-23 series and marked in the statement

Base indices for the base month

Price variation formula RPWA 100 = Rajasthan PWF&AR agreement form, clause 45 (load the RPWA 100 preset in the Formula tab for its components and settings)

Adjustable portion of R (%) clause 45: 0.75 × P / 100 × (I1 − I0)/I0 × R

Escalation only on work beyond (₹) clause 45: ₹ 50,00,000 - for a contract not above it, the first ₹ 50 lakh of work is deducted from R (condition 8); 0 = no limit

Eligible if stipulated period is more than (months) RPWA 100 clause 45: 3 months; 0 = no condition

Base index with "quarter", the base month above is the month the tenders were opened / negotiated

Current index for a bill period

Work done in a quarter (R), quarterly method

After the stipulated date of completion

Recover when indices fall (de-escalation)

Price variation formula

Escalation for component k = V × w_k / 100 × (I_k − I_k,0) / I_k,0

V = value of work done in the bill period less items not eligible; w = weightage (%) from the contract; I₀ = index of the base month; I = index for the bill period. The fixed portion plus the weightages must add up to 100 %.

Start from Fixed (non-escalable) portion %

Index series: type to search the index database (CPI-IW centres, every WPI item, and your custom indices). Typing a new name adds an index for this work only, filled in the Indices tab; to reuse one in other works, create it as a custom index in the database.

Monthly indices

Rows appear for the base month and the months of the bills. Grey figures come from the index database - CPI-IW (Labour Bureau, base 2016 = 100) and WPI (Office of the Economic Adviser, base 2022-23 or 2011-12 = 100, as chosen in the Contract tab) - and are used as they are. Type a figure to override one, or to fill a month not yet in the database; you can paste a block copied from Excel into any cell. To use a different index item for a component, pick it in the Formula & components tab.