DTP checklist generator tool

प्रारुप निविदा प्रपत्र (DTP) तपासणी सुची

प्रकल्प निवडा

कामाचे नांव

संदर्भ

प्रादेशिक विभाग

जावक क्र.

दरसुची वर्ष

आर्थिक तपशील (Financial Details)

Civil Work (I)

Electrical (II)

रॉयल्टी शुल्क

प्रयोगशाळा शुल्क

P.O.L. Component (%)

Labour (%)

Material (%)

P.O.L (%)

P.O.L. एकूण: 0% | त्रुटी: एकूण १००% आवश्यक!

बांधकाम साहित्य दर (Basic Rates)

सिमेंट (MT)

TMT Steel (MT)

Structural Steel (MT)

डांबर 60/70 (MT)

डांबर 80/100 (MT)

बाबींच्या परिमाणाचा तपशिल (३०% तपासणी)

बाबींची यादी	एकूण परिमाण	युनिट	३०% परिमाण	बाबींची किंमत (रु.)	काढा

प्रारुप निविदा प्रपत्र तपासणी सुची

कामाचे नांव:

संदर्भ:

महोदय, सदर कामास मुख्य अभियंता, सा. बां. प्रादेशिक विभाग, यांनी त्यांचेकडील पत्र जा.क्र. नुसार तांत्रिक मान्यता दिलेली आहे. सदर कामाचे अंदाजपत्रक हे सन चे दरसुचीवर आधारीत आहे.

अ)	प्रारुप निविदा किंमत (Civil + Electrical)
ब)	रॉयल्टी + प्रयोगशाळा शुल्क
क)	मंजुर अंदाजपत्रकाप्रमाणे एकूण किंमत

ड) P.O.L. Component:

Labour
Material
P.O.L

ई) बांधकाम साहित्याचे दर:

अ.क्र.	साहित्याचा तपशील	दर (प्रति मे. टन)
1	सिमेंट (Cement)
2	TMT Steel
3	Structural Steel
4	डांबर 60/70
5	डांबर 80/100

बाबींच्या परिमाणाचा तपशिल (३०% तपासणी):

अ.क्र.	बाबींची यादी	एकूण परिमाण	युनिट	३०%	किंमत (रु.)

____________________ शाखा अभियंता

____________________ उप विभागीय अभियंता

User Guide: PWD Checklist & Draft Tender Paper (DTP) Tool

A manual for project estimating, structural validation, and database management

1. Introduction

This tool is designed to streamline the compilation, validation, and generation of PWD (Public Works Department) Checklists and Draft Tender Premium (DTP) documentation. Powered by a local background database, it allows you to handle project financial summaries, track fundamental construction material rates, and automate Bill of Quantities (BOQ) math efficiently.

2. Key Features

• Local Offline Storage: Uses your browser's built-in IndexedDB layout named PWD_Checklist_DB to save or update progress instantly without an active internet connection.
• Automated Math Constraints: Real-time confirmation that your labor, material, and fuel variables add up perfectly to 100%.
• Smart BOQ Processor: Automatic execution of specific subset parameters (e.g., automated calculation of 30% metric allowances based on item quantities).
• Dynamic Document Exporter: Compiles user field variables directly into formatted PDF formats using client-side canvas generation engines.
• Data Portability: Native backup routines allowing seamless migration or archival via standard JSON uploads/downloads.

3. Operating Instructions

Step 1: Selecting or Creating a Project

When the application boots, it queries your browser database storage layer.

• To start fresh: Simply enter details in the clear text fields provided. By default, the app structures a baseline table row to let you input details immediately.
• To load an existing file: Utilize the project dropdown selection engine at the top of the interface. Choosing an option will trigger loadSelected() and populate all saved metadata elements dynamically.

Step 2: Completing Metadata and Financial Data Blocks

Fill out the descriptive metrics sections (Work Name, Reference String, Regional Zone, Technical Sanction Number, Schedule of Rates Year). Below that, enter your monetary valuations:

• Civil Structural Valuations
• Electrical Infrastructure Allocations
• Royalty Rates & Labor Surcharges
• Basic Material Ledger Values (Cement, TMT Steel, Structural Steel, Bitumen VG-60 / VG-80 grades)

Step 3: POL Allocation Validation (Crucial Check)

The system evaluates the statutory distribution of Petroleum, Oil, and Lubricants (POL) parameters. You must input:

1. Labor Component Percentage (polLab)
2. Material Component Percentage (polMat)
3. Fuel Component Percentage (polFuel)

Validation Notice: The engine automatically tracks these inputs. If the cumulative sum is exactly 100%, you will see a green confirmation indicator: योग्य: एकूण १००% आहे.. If it deviates from 100%, a red error notice appears: त्रुटी: एकूण १००% आवश्यक!, and your PDF download button will be disabled.

Step 4: Managing the Bill of Quantities (BOQ) Table

The core itemizer performs calculations instantly on user entry:

• Type your Item Name, Target Quantity, Unit metrics, and individual base Rate.
• As you type a quantity value, the system automatically runs the update30() routine, calculating exactly 30% of that value and rendering it under the custom tracking column.
• Click the red cross icon (✖) at the end of any given row to drop that specific index entry instantly.

4. Control Actions Reference

Action Button / Mechanism	Underlying Operation	Outcome / Results
Save Project	saveProject()	Pushes all metadata and structural array objects into IndexedDB storage and triggers a success prompt (माहिती जतन केली!).
Download PDF	generatePDF()	Temporarily maps all active elements to a hidden snapshot canvas, structures a clean layout page format, and initiates a localized prompt file download named DTP_Checklist.pdf.
Delete Project	deleteProject()	Displays a confirmation message (काय आपण हे रेकॉर्ड डिलीट करू इच्छिता?). If confirmed, it purges the file from the database and resets the input screen.
Export Backup	exportToJSON()	Pulls the entire database and compiles a downloadable backup document appended with the current date string (e.g., .json).
Import Data	importFromJSON()	Opens a local file dialog window to read JSON files, generates new safe ID indicators for each record, updates your local store, and updates the view list.

5. Technical Notes & Best Practices

• Browser Storage Dependence: Clearing your web browser cache or cookies completely might flush your active data if storage properties are unpinned. It is highly recommended to perform an Export Backup routinely to safeguard records.
• External Libraries Required: The file export engine depends heavily on having access to external runtime helper libraries, specifically html2canvas and jsPDF, loaded on the hosting window envelope.