LMR with data and rate json

LMR Calculator

LMR Calculator

Labor, Material, and Resource Cost Estimation Tool

Import Resource Rates

DSOR Rates
KWA Approved Rates
Manual Entry
Sub-Work JSON

How to import DSOR rates:

  1. Download the latest DSOR rates from the Price 3.0 website
  2. Convert the Excel file to JSON using this online converter
  3. Copy the JSON data and paste it in the textarea below
  4. Click "Import DSOR Rates" to update the resource database

How to import KWA approved rates:

  1. Download the latest KWA approved rates from the Price 3.0 website
  2. Convert the Excel file to JSON using this online converter
  3. Copy the JSON data and paste it in the textarea below
  4. Click "Import KWA Rates" to update the resource database

How to import Sub-Work JSON data:

  1. Prepare a JSON array of sub-works with Item Number, Title, Work Quantity, Resources, and Sub-Works.
  2. Ensure resources (e.g., "0114") exist in the database before importing.
  3. Example format: 
    [
    {
        "Item Number": "2.25",
        "Title": "Refilling, ramming and watering",
        "Work Quantity": "Per 1 cum",
        "Resources": {
            "0114": "0.89 day",
            "0115": "1.07 day",
            "0101": "0.35 day"
        },
        "Sub-Works": {}
    },
    {
        "Item Number": "2.9.1",
        "Title": "Excavation in ordinary rock",
        "Work Quantity": "Per 10 cum",
        "Resources": {
            "0020": "0.0625 day",
            "9999": ["13.52"]
        },
        "Sub-Works": {}
    }
]
  4. Paste the JSON data in the textarea below.
  5. Click "Import Sub-Works" to add them to the database.

Add Sub-Work

Resource Search

No resources found. Import rates first.

Arrange Components

No components added yet

Calculate Cost

Comments

Post a Comment

Popular posts from this blog

EL calculator

Kerala Government Employee EL Calculator Kerala Government Employee EL Calculator Calculate your earned leave balance and plan your leaves effectively Basic Information Date of Joining Service Current Date Non-Qualifying Days Non-Qualifying Days in First Year of Service ? Suspension, dies-non, commuted or half pay leaves, casual leave, compensation leave, etc. taken in first year ...
Read more

ISM to UNICODE

ISM to Unicode Converter ISM to Unicode Converter Upload your Word document with ISM font text and convert to Unicode Drag & drop your Word document here or click to browse Browse Files No file selected Convert to Unicode Download Word File How it works: 1. Upload a Word document (.doc or .docx) containing ISM font text 2. Click "Convert to Unicode" to process the document 3...
Read more

Comparative statement

Comparative Statement Generator - Kerala Water Authority Comparative Statement Generator Kerala Water Authority Instructions: 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) Upload the file and click 'Load Excel File' Edit data if needed and enter LMR Rate for items exceeding 125% (normal quoted) or 100% (abnormally high quoted) of Original Quantity Click 'Submit Data', 'Generate Comparative Statement', and 'Download Result' 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...
Read more