Go to App Workspace / เข้าสู่ระบบงาน
Interactive Dashboard & Presentation

Premium Quantity Takeoff & Sourcing Platform

A unified digital solution mapping estimators, sales, procurement officers, workshop factory engineers, quality assurance inspectors, and executive directors in a single database flow.

Dual Takeoff Costs (Bid vs. Production)

Allows estimators to project material/labour values while production engineers update actual execution numbers, generating direct profit margins comparisons.

Real-Time Project Revisions

Every commit logs an immutable snapshot of project systems. Perform side-by-side comparative audits of pricing revisions instantly.

Unified Procurement Lifecycle

Transforms approved takeoff items into Purchase Requests (PRs) for price-sourcing, routing reviews, and final PO releases to warehouse inventory.

Factory Acceptance Testing (FAT)

Includes complete testing script modules, photo attachments, and quality check pass/fail markers for QA and customer validations.

Contextual Project Chat

Facilitates discussions between estimators, project supervisors, and suppliers directly attached to specific projects.

ExcelJS / XLSX Exporter

Generates client-ready Quotations, detailed BOMs, Free Issue allocations, and profit sheets with customized company templates.

Technical Stack & Layout

Built with a monolithic Single-Page Application (SPA) architecture on the client side, backed by a Node.js Express server running sqlite3 database operations.

Database Schema Definitions

CREATE TABLE projects ( id INTEGER PRIMARY KEY AUTOINCREMENT, name VARCHAR(255) NOT NULL, client_name VARCHAR(255) NULL, description TEXT NULL, created_by INT NULL, status VARCHAR(50) DEFAULT 'รอดำเนินการ', project_type VARCHAR(100) NULL, drawing_path VARCHAR(255) NULL, spec_path VARCHAR(255) NULL, is_deleted TINYINT DEFAULT 0, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP );

Role Integration & Core Pipeline

How different company divisions log data, authorize purchases, and receive warehouse materials.

Pre-Sales & Design / ตรวจสอบราคาและออกแบบ

Price Estimator & Draftsman / ฝ่ายออกแบบประมาณราคา

Constructs the project sections layout and executes the baseline material/labour takeoff sheet.

Creates system takeoff templates
Specifies item brands & descriptions
Inputs standard cost & markup percentage
Stores base Revisions (REV 1, etc.)
Authorized Reports / รายงานที่เกี่ยวข้อง:
  • รายงานเสนอราคา (Proposal): ใบเสนอราคา
  • รายงานเสนอราคา (Proposal): รายงานขอบเขตงาน
  • รายงานเสนอราคา (Proposal): รายงาน Catalog
  • รายงานต้นทุนกำไร (Costing): สอบราคาผู้รับเหมา
  • รายงานต้นทุนกำไร (Costing): สอบราคาวัสดุ
  • รายงานวัตถุดิบ: BOM (Bill of Materials)
  • รายงานการแก้ไข: รายงานประวัติแก้ไขรายการ
Key Database Tables: projects project_sections project_items

Cost & Profit Variance Simulator

Input bid values alongside actual factory production values below. Watch the system perform calculations on margin drift, sourced procurement savings, and status indicators in real-time.

Initial Bid Target
$1,750.00
Est. Margin: 20%
Actual Production Cost
$1,680.00
Cost Drift: +$280.00 (Quantity increase)
Sourcing Saving Variance
$120.00
Procurement Negotiated Discount
Margin Drift Health Status
High Margin Retention