Comparative statement

Comparative Statement Generator

Kerala Water Authority

Instructions:

1. Create an Excel file with columns: Item No (or Item No.), Description, Agreed Quantity, TS Rate, Agreed Rate, Already Executed Quantity, To be Executed Quantity (case-insensitive)
2. Upload the file and click 'Load Excel File'
3. Edit data if needed and enter LMR Rate for items exceeding 125% (normal quoted) or 100% (abnormally high quoted) of Original Quantity
4. Click 'Submit Data', 'Generate Comparative Statement', and 'Download Result'
5. Note: Original Quantity is taken as Agreed Quantity. Ensure numeric fields are valid. Data persists on page refresh; use 'Clear Data' to reset.

Upload Excel File

Edit Data

Item No.	Description	Original Qty	Agreed Qty	TS Rate	Agreed Rate	Executed	To Execute	Total Qty	LMR Rate	Status

Comparative Statement Preview

SI.No	Description of Item	Original Estimate			As per Agreement		RE Quantity			RE Amount (TS Rate)				RE Amount (Agreed Rate)			% Qty Var
		Qty	Rate	Amount	Rate	Amount	Exec	To Exec	Total	Rate	Amount	Savings	Excess	Amount	Savings	Excess