RE responsive tables

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, LMR Rate (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. Use 'Add Item Manually' to add new items directly on the page
5. Click 'Submit Data', 'Generate Comparative Statement', and 'Download Result'
6. Note: Original Quantity is taken as Agreed Quantity. Ensure numeric fields are valid. Data persists on page refresh; use 'Clear Data' to reset. The Overall Factor (ratio of total agreed amount to total TS amount, excluding extra items) is displayed with 4 decimal places. Item descriptions are truncated to 5 words and expandable on click. Tables are responsive and stack on smaller screens.

Upload Excel File

Edit Data

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

Overall Factor (Total Agreed Amount / Total TS Amount, excluding extra items):

Item No: Description: Original Qty: Agreed Qty: TS Rate: Agreed Rate: Executed Qty: To Execute Qty: LMR Rate:

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

Excess Threshold Details

Item No	Description	Original Qty	Threshold Qty	Excess Qty	TS Rate	Agreed Rate	LMR Rate	Rate Taken