Individual Performance Report
Individual Worker Productivity Reports & Performance Tracking
Saved Uploads (Disabled)
Server storage temporarily disabled due to Cloudflare Workers limitations.
Please use Excel upload feature instead.
Upload New File
Drag & Drop Excel File
Excel (.xlsx, .xls) file with worker time records
Upload Successful!
Processed Records: 0
Date Range: -
Worker Count: 0
AI Insights & Alerts
No warnings detected. All systems normal.
Shift Performance Comparison
Compare shift performance across process groups (BT, WT, IM)
| Shift | Workers | Shift Time | Work Time | Utilization | Standard Time | Efficiency |
|---|---|---|---|---|---|---|
| No data available | ||||||
| Shift | Workers | Shift Time | Work Time | Utilization | Standard Time | Efficiency |
|---|---|---|---|---|---|---|
| No data available | ||||||
| Shift | Workers | Shift Time | Work Time | Utilization | Standard Time | Efficiency |
|---|---|---|---|---|---|---|
| No data available | ||||||
Note: Total worker count represents unique workers. Each shift may count workers multiple times due to overtime (OT).
KPI Trend Intelligence
Click data point to open Period Detail Modal
What Changed & Why
Overall Change: -
Export & Reports
Includes: KPI Summary, Worker Performance (aggregated), Shift Comparison, Performance Bands (aggregated), Raw Data
π² Outlier Scanner
| Type | Name | KPI | Value | Expected | Sample (n) | Confidence | Action |
|---|---|---|---|---|---|---|---|
| No outliers detected | |||||||
Filters
β οΈ Day/Night Overlap Due to Overtime (OT)
Total β Shift A+B+C is expected because workers may work across Day and Night shifts (OT).
For example, if a Shift A worker works Day (7AM-7PM) and continues to Night (7PM-9PM) for OT:
β’ The Day record is counted in Shift A filter
β’ The Night record is counted in Total but excluded from Shift A filter
This ensures accurate shift-based performance analysis while Total captures all work hours.
Records with rate > threshold will be filtered
Excellent Workers (β₯80%)
No data available
Normal Workers (50~79%)
No data available
Poor Workers (30~49%)
No data available
At-Risk Workers (<30%)
No data available
Average Work Rate by Process
Worker Performance Distribution
Worker Performance Report by Date
λ°μ΄ν°λ₯Ό μ λ‘λνκ³ Filtersλ₯Ό μ μ©ν΄μ£ΌμΈμ
Detailed Data
| Worker | Process (FO Desc 3) | Work Date | Shift | Day/Night | Work Time (min) | Work Count | Work Rate | Performance Grade |
|---|---|---|---|---|---|---|---|---|
| Please upload data | ||||||||
Process Mapping Management
Map Raw data's FD Desc or FO Desc to higher-level Process (FO Desc 2, FO Desc 3).
Add New Mapping
| FD Desc / FO Desc | FO Desc 2 | FO Desc 3 | Sequence (Seq) | Action |
|---|---|---|---|---|
| No mapping data available | ||||
User Guide
1. Data Upload
- Upload Excel file (.xlsx, .xls) downloaded from MES R018
- Drag & drop file or click 'Select File' button
- System automatically detects data and processes it
- Review the processed data and reports
- Click "Save to Database" to store data in Cloudflare D1 (temporarily disabled)
2. Load Saved Data (Temporarily Disabled)
- View Saved Uploads list in Upload tab
- Click any card to load saved data
- Automatically switches to Report tab after loading
- Delete uploads using the Delete button on each card
3. View KPI Cards & Switch Metric Mode
- 4 KPI Cards: View key metrics at a glance
- Utilization Mode: Total Workers, Total Shift Time, Total Work Time, Avg Utilization Rate
- Efficiency Mode: Total Workers, Total Adjusted S/T, Total Shift Time, Avg Efficiency Rate
- Toggle Button: Click to switch between Utilization & Efficiency modes
-
Utilization Rate: (Work time Γ· Shift time) Γ 100
Measures: "How much of the shift time was spent working?"
Example: 260 min work Γ· 660 min shift Γ 100 = 39.4%
-
Efficiency Rate (Shift Productivity): (Adjusted S/T Γ· Shift time) Γ 100
Measures: "How much standard work was completed per shift?"
Also known as "Shift Productivity" - measures output per shift (660 min)
Example: 1000 min S/T Γ· 660 min shift Γ 100 = 151.5%
- Note: All reports, bands, charts, and tables update automatically
4. Apply Filters
- Shift Filter: A Shift / B Shift / C Shift
- Date Filter: Select by individual dates, weeks (WK#), or months
- Working Shift: Day / Night
- Category: BT Process, DS, BT Complete, WT, IM, etc.
- Process: Specific processes (FO Desc 3)
- Worker: Individual workers (searchable)
- Click "Apply Filter" to update reports (loading indicator appears during processing)
- Reset: Clear all filters to view full dataset
5. Outlier Threshold (Efficiency Mode Only)
What is an Outlier?
An outlier is a work record with an unusually high efficiency rate (e.g., 1500%, 2000%). This typically occurs when Worker Rate (%) is very high, indicating significant task completion.
β οΈ Important: Outliers represent real work and are included in all calculations. They are only highlighted in red for visual reference.
-
Default Threshold: 1000%
Records with efficiency > 1000% are marked as outliers for visual identification
-
Adjustable
Change the threshold (e.g., 500%, 800%, 1200%) to adjust which records are visually marked
-
Visual Indicators
Outliers are marked with π« icon and red background in tables
-
Included in Calculations
All outlier records are included in KPI, charts, and efficiency calculations
Example: If a worker shows 1500% efficiency, this is likely a data error. The outlier filter prevents this extreme value from skewing your average efficiency rate.
7. Performance Grades
Utilization Rate Bands:
- Excellent: β₯ 80%
- Normal: 50-79%
- Poor: 30-49%
- At-Risk: < 30%
Efficiency Rate Bands:
- Excellent: β₯ 100%
- Normal: 80-99%
- Poor: 60-79%
- At-Risk: < 60%
Note: Outliers (>1000% by default) are visually marked in red but included in all calculations. See "Outlier Threshold" section for details.
8. Worker Detail Modal
- Click any worker card in Performance Bands to view detailed information
- KPI Summary: Total Shifts, Shift/Work Time, Performance Rate
- Rework Records: Total Records card shows Rework count in gray text below
- Excl. Rework Rate: Utilization/Efficiency rate excluding Rework shown below main rate
- Daily Trends: Line chart showing work time by date
- Hourly Distribution: Bar chart showing work time by hour
- Detailed Records Table: Date, shift, process, time breakdown
- Utilization Mode: Shows individual records with start/end times, orange highlighting for overlap removal
- Efficiency Mode: Shows records with start/end times, S/T, Worker Rate, Adjusted S/T (orange when overlap removed), outlier indicators (π«)
- Rework Indicators: Blue background with π icon for Rework records
- Glossary: Context-specific term definitions at the bottom
8. Export to Excel
-
KPI Summary Sheet
Overall report summary (total workers, total shifts, avg utilization/efficiency, performance band distribution)
π‘ Use Case: One-page executive summary for management reports
-
Worker Performance Sheet
Worker-level performance ranking (shift count, utilization, efficiency, W/O count, performance grade)
π‘ Use Case: Identify top/bottom performers, prepare individual performance reviews
-
Shift Comparison Sheet
Compare shifts (A/B/C/D) across process groups (BT/WT/IM)
π‘ Use Case: Analyze shift productivity gaps, workforce balancing
-
Performance Bands Sheet
Worker list grouped by performance bands (Excellent/Normal/Poor/Critical)
π‘ Use Case: Select training targets (Critical), share best practices (Excellent)
-
Raw Data Sheet
Individual work records (max 10,000 rows, worker/date/time/results)
π‘ Use Case: Detailed data analysis, create pivot tables
Workflow Example: Performance Bands Critical list β Interview β Worker Performance detailed metrics β Raw Data specific work records
9. Dashboard Tab (NEW in v4.0+)
-
AI Insights & Alerts
Automatic warnings for low utilization/efficiency, gaps, process concentration, sample size
-
KPI Trend Intelligence
Click data points to open Period Detail Modal with 6 key metrics, process breakdown, and top/bottom performers
-
What Changed & Why
Compare 7/14/30 day periods to see which processes contributed to performance changes
-
Shift Comparison (OLD)
Compare Day vs Night shift performance visually
-
Shift Performance Comparison (NEW in v4.3.0)
Table view comparing Shift A/B/C/D performance across BT/WT/IM groups
β’ 3 Groups: BT (Process/Complete/QC), WT (WT/WT QC), IM (IM/IM QC)
β’ Collapsible/expandable tables with period selector (7d/14d/30d/all)
β’ Columns: Workers, Shift Time, Work Time, Utilization (%), Standard Time, Efficiency (%)
β’ Color-coded: Blue/Purple (β₯50%), Orange (<50%)
February 2026 - Shift Calendar
Note: Day shift (06:00-18:00), Night shift (18:00-06:00)
Update Log
Version 4.3.5
Latest 2026-03-12Rework Visual Enhancement
- Blue Background Highlighting: Rework records now displayed with blue background in Worker Detail Modal tables
- π Rework Icon: Visual indicator added to Date column for easy identification
- Rework Count Display: Total Records card shows Rework count in gray text below total count
- Excl. Rework Rate: Utilization/Efficiency rate excluding Rework shown below main rate
- CSS Priority Fix: Added
!importantflag to ensure blue background displays correctly
Worker Detail Modal Enhancement
- Start/End Time Added: Efficiency Mode now shows Start Time and End Time columns (matching Utilization Mode)
- Overlap Adjustment Applied: Efficiency's Adjusted S/T now applies overlap removal ratio (same as Utilization)
- Orange Highlighting: Adjusted S/T values highlighted in orange when overlap detected and removed
- Tooltip Enhancement: Hover tooltip shows overlap adjustment details (e.g., "50min β 25min (ratio: 50%)")
Glossary Update
- Rework Definition Added: Both Efficiency and Utilization glossaries now include π Rework explanation
- Header Matching: Glossary terms now exactly match table header names for clarity
- Overlap Notes: Clear indication that overlap removal is applied to both Assigned and Actual in Efficiency Mode
Visual Improvements: Rework records now clearly distinguished with blue background and icon. Overlap adjustments highlighted in orange across both metric modes.
Version 4.3.3
Previous 2026-03-02Excel Export Function Complete Fix
- Global Function Registration:
exportToExcel()now properly exposed to browser's global scope - Performance Bands Data Verified: Shift Count and Utilization Rate correctly populated in exported Excel file
- All 5 Sheets Working: KPI Summary, Worker Performance, Shift Comparison, Performance Bands, Raw Data (10k limit)
- Console Logging Added: Debug logs confirm data aggregation (8,305 worker-day-shift entries, 48,065 records)
Documentation Enhancement
- Excel Export Guide Added: New User Guide section "8. Export to Excel" with practical usage examples
- 5 Sheet Descriptions: Each sheet's purpose and use case clearly explained
- Real-world Example: Critical worker identification β interview β detailed analysis workflow
Excel Export Now Fully Functional: All shift counts, utilization rates, and efficiency metrics correctly exported across all sheets.
Version 4.3.2
Previous 2026-03-02Bug Fix
- Performance Bands W/O Count Fixed: Now correctly displays W/O count (Work Order count) in Performance Bands section
- Consistent Logic: Uses
validCount(record count) when Excel file lacks W/O column, matching Worker Performance Report by Date - Enhanced W/O Column Recognition: Added comprehensive synonyms (
wo,w/o,wo#,wonumber,workorder, etc.) - Debug Logging: Added detailed logging for W/O count tracking (
validCount,woNumbers.size,final woCount)
Note: When Excel file contains W/O column β shows unique W/O numbers. Otherwise β shows record count (same as Worker Performance Report).
Version 4.3.1
Previous 2026-03-02Enhancement
- Section ID Column Added: Worker Detail modal's "Detailed Work Records" table now includes Section ID (from Excel column D) for both Efficiency and Utilization modes
- Process Tracking: Users can now identify which Skirt/Section each worker's task belongs to
- Thousand Separators: Shift Performance Comparison table now displays numeric values with comma formatting for better readability
Note: Section ID column helps track work assignments to specific Skirts or Sections. Missing values are shown as "-".
Version 4.3.0
Previous 2026-03-02Shift Performance Comparison Table Added
- Replaced: Process Health Matrix (bubble chart) removed
- New Table: 3 collapsible groups (BT, WT, IM) comparing Shift A/B/C/D performance
- BT Group: BT Process, BT Complete, BT QC - Shift A/B/C/D
- WT Group: WT, WT QC - Shift A/B/C/D
- IM Group: IM, IM QC - Shift A/B/C
- Period Selector: Last 7/14/30 days (default), All data with real-time date range display
- Columns: Workers, Shift Time (hrs), Work Time (hrs), Utilization (%), Standard Time (hrs), Efficiency (%)
- Formatting: Thousand separators (commas), 1 decimal place, color-coded (Blue/Purple β₯50%, Orange <50%)
Version 4.2.0
Previous 2026-03-02Server Storage Features Temporarily Disabled
- Disabled: "Save to Database" button (grayed out with tooltip)
- Disabled: "Saved Uploads" section (grayed out, click-blocked)
- Reason: Cloudflare Workers execution time limits prevent reliable storage of large datasets (32k+ records)
- Issue: Background tasks timeout after ~10k records, resulting in incomplete data saves
- Workaround: Use Excel upload feature (works perfectly in browser without server storage)
- Status: Temporary measure until alternative solution is implemented
Recommended Workflow
- Step 1: Upload Excel file from MES R018
- Step 2: Review Dashboard and Report tabs
- Step 3: Apply filters as needed
- Note: All data processing happens in your browser (fast and reliable)
Version 4.1.0
Older 2026-03-02Period Detail Modal Layout Improvements
- Removed: Total Records card eliminated for cleaner layout
- 6-Card Row: Workers, Avg Utilization, Avg Efficiency, Total Shift Time, Total Work Time, Total Adjusted S/T
- Main KPI Emphasis: Avg Utilization & Efficiency with gradient backgrounds, larger fonts, and icons
- Time Format: All time values now display in hours (hr) with thousand separators (e.g., 3,643.2 hr)
Process Breakdown Design Overhaul
- Larger Cards: Increased card size and padding for better visibility
- Font Improvements: Values upgraded from text-xs to text-base with bold highlighting
- Visual Polish: Blue gradient backgrounds, enhanced hover effects (shadow-md, border-blue-400)
- Layout: Left-right aligned layout for improved readability
Top/Bottom Performers Enhancements
- Clear Labels: "(Top 3)" and "(Bottom 3)" badges added to section titles
- Criteria Explanation: "Ranked by combined Utilization + Efficiency score"
- Visual Separation: Gradient backgrounds (green for top, orange for bottom)
- Icon Colors: Yellow trophy and orange warning icons for emphasis
Bug Fixes
- Fixed: Modal TypeError caused by deleted Total Records element reference
- Fixed: Dashboard Period Modal Total Shift Time not displaying (duplicate ID conflict resolved)
- Fixed: ID conflicts between Dashboard and Report modals (periodModalTotalShiftTime vs modalTotalShiftTime)
Version 4.0.0
Previous 2026-03-01Dashboard Tab - Major Release
- AI Insights & Alerts: 6 types of automatic warnings
- KPI Trend Intelligence: Daily/Weekly toggle with drill-down modals
- What Changed & Why: 7/14/30 day comparison with contribution analysis
- Shift Comparison: Day vs Night performance visualization
- Process Health Matrix: 4-quadrant bubble chart with colored zones
Version 3.6.0
Previous 2026-02-27Shift Filter Logic Overhaul
- Changed: Shift filter now uses hardcoded ShiftCalendar instead of Excel data
- Logic: ShiftCalendar defines which dates each shift (A/B/C) works on
- Example: "2026-02-09 β Day Shift B, Night Shift C" means only B-team Day records and C-team Night records are shown
- Impact: Total β A+B+C due to OT causing Day/Night duplicate counting
Shift Filter Tooltip Added
- Added: Tooltip explaining Total vs. Shift totals discrepancy
- Reason: Overtime (OT) workers appear in both Day and Night shifts
- Example: A-team worker does Day shift (07:00-19:00) + OT Night (19:00-21:00) β counted in Total twice but only Day in Shift A
Database Performance Optimization
- Fixed: 502 errors when loading large datasets
- Pagination API: Raw data now loads in 1000-record batches
- D1 Batch API: Background saves use batch() for efficient transactions (50 records/batch)
- Progress UI: Estimated progress with smooth updates (500ms intervals)
Bug Fixes
- Fixed: "loadSavedUploads is not defined" error β renamed to loadUploadsList()
- Fixed: ShiftCalendar loading issue when loading saved uploads β fallback to default calendar
- Fixed: Progress bar not updating β added estimation + async polling
Version 3.5.1
Previous 2026-02-27Worker Detail Modal Data Sync Fix
- Fixed: Modal KPI calculations now match current filter state
- Issue: Modal Total Work Time included filtered-out records
- Solution: Modal now aggregates current filtered data directly
- Impact: Table Adjusted sum and Modal Total Work Time now match perfectly
Version 3.4.2
Previous 2026-02-24Critical Bug Fix: Outlier Calculation
- Fixed: Outlier records (efficiency > 1000%) were incorrectly excluded from all calculations
- Corrected: Outliers now properly included in KPI, charts, and worker detail calculations
- Visual: Outlier records remain highlighted in red for reference
- Impact: All efficiency metrics now accurately reflect total work completed
Why This Matters
- Outliers are real work: High Worker Rate (%) indicates task completion, not data errors
- Efficiency formula: Total Adjusted S/T Γ· Shift Time Γ 100
- All work counts: Excluding outliers artificially deflated efficiency metrics
Note: Outlier records are now included in all calculations but remain visually marked in red for easy identification.
Version 3.3.0
β οΈ Breaking Change 2026-02-21Efficiency Calculation Formula Changed
- Previous: Efficiency = (Adjusted S/T Γ· Actual Time) Γ 100
- New: Efficiency = (Adjusted S/T Γ· Shift Time) Γ 100
- Shift Time: Fixed at 660 minutes per shift
- Reasoning: Prevents distortion from extremely short Actual Time entries
Why This Change?
- Issue: Short Actual Time (e.g., 2 min) inflates efficiency to 3000%
- Solution: Using Shift Time (660 min) provides consistent productivity measurement
- Benefit: Measures how much standard work was completed per shift
- Distinction: Utilization tracks time usage; Efficiency tracks work output
Updated Interpretation
- 100% Efficiency: Completed exactly one shift's worth of standard work
- 150% Efficiency: Completed 1.5Γ standard workload (high productivity)
- 70% Efficiency: Completed 0.7Γ standard workload (needs improvement)
Breaking Change: Efficiency values calculated with this version are not directly comparable with previous versions. The new formula provides more accurate shift-based productivity measurements.
Version 3.2.1
Previous 2026-02-21Bug Fixes
- Fixed Utilization Rate Mismatch: Modal (worker detail) now shows same % as main page
- Data Source Consistency: Both views now use cachedWorkerAgg (aggregated, overlap-removed data)
- Total Shift Time Calculation: Now correctly calculates total shifts worked instead of total workers
Fix: Utilization rate calculations are now consistent across main page and worker detail modal
Version 3.2.0
Previous 2026-02-21KPI Cards Redesign
- 4-Card Layout Restored with meaningful metrics for both modes
- Utilization Mode: Total Workers, Total Shift Time, Total Work Time, Avg Utilization Rate
- Efficiency Mode: Total Workers, Total Adjusted S/T, Total Actual Time, Avg Efficiency Rate
- Accurate Calculations: Average Rate = (Card 2 / Card 3) Γ 100
- Dynamic Color Themes: Blue for Utilization, Purple for Efficiency
Loading Indicators
- Filter Loading: Appears when applying filters or resetting
- Outlier Threshold Loading: Shows during Outlier Threshold updates
- Smooth Animation: 300ms fade-out transition for professional UX
- Top-Right Position: Non-intrusive WAIV logo + spinner display
Glossary Improvements
- Terminology Unified: "Assigned(m)" β "Adjusted S/T(m)"
- Consistent Naming: Modal table headers and glossary now match
- Clear Formula: Adjusted S/T = S/T Γ Worker Rate Γ· 100
Bug Fixes
- Worker S/T Accumulation: Fixed missing aggregation in aggregateByWorkerOnly
- KPI Calculation Logic: Corrected card order and calculation formulas
- Card Value Consistency: Total S/T no longer shows 0 in Efficiency mode
Improvement: Average Rate is now accurately calculated from displayed card values, ensuring transparency and correctness
Version 3.0.0
Major Update 2026-02-20Two New Performance Metrics
- Time Utilization Rate: Actual work time / Available time (shifts Γ 660min) Γ 100%
- Work Efficiency Rate: Assigned standard time / Actual time Γ 100%
- Toggle button to switch between metrics with visual indicators
- Performance bands updated: Excellent, Good, Normal, Poor, Critical
Enhanced Data Filtering
- Automatic exclusion of Rework records (W column = true)
- Filter out records with Worker S/T β€ 0
- New columns parsed: Worker S/T (T), Worker Rate(%) (U), ework (W)
Worker Detail Modal Enhancements
- Time Utilization View: Daily/hourly charts in minutes (blue theme), overlap removal highlighted
- Work Efficiency View: Daily/hourly charts in % (purple theme), efficiency color-coded
- Dynamic table headers based on selected metric
- Separate calculation logic for each metric type
Breaking Changes
- Removed old "Valid-only" work rate calculation
- Replaced single metric with dual-metric system
- Performance band thresholds completely redesigned
Bug Fixes
- Fixed overlap removal logic to work per worker (not merged across workers)
- Corrected Worker Rate(%) handling (0% is valid, not missing)
- Fixed performance band gaps (no empty ranges)
Validation: Tested with R018Worker_2026-02-18 Excel file (27,026 rows, 831 rework records excluded)
Version 2.6.0
PreviousWeek Filter
- Week Selection: Added week-based date filtering with week number display
β’ Format: WK7: 02-10 ~ 02-16
β’ ISO Week calculation (Monday-based) - Quick Selection: Month and Week buttons for fast date selection
Filter UX Improvements
- Visual Feedback: Enhanced hover effects (dark color + white text)
- Active State: Click animation (scale-95, darker color)
- Auto-close Dropdowns: Automatically close after selection
- Filter State Persistence: Maintain selections when re-applying filters
Average Work Rate Fix
- Calculation Update: Changed from worker count to total shift count
β’ Before: totalMinutes / workerCount / 660 Γ 100 β
β’ After: totalMinutes / totalShifts / 660 Γ 100 β
β’ Fixed: 457% β ~65% (correct range)
Pivot Table Enhancement
- Cell Merge: Worker Name header with rowspan for cleaner layout
- Sticky Header: Fixed header during scroll
- Clean Design: Simplified 2-row header structure
Version 2.1.0
2026-02-18Major Fixes
- Work Rate Calculation Fix: Changed from record count to worker count
β’ Before: totalMinutes / recordCount / 660 Γ 100 β
β’ After: totalMinutes / workerCount / 660 Γ 100 β - Valid Records Only: Only sum workerActMins for Result Cnt = 'X'
β’ Both main report and detail modal now consistent - Shift Counting Logic: Use workingDay + workingShift for proper O/T handling
β’ Fixed: Overnight shifts and overtime now counted as single shift
β’ Formula: Work Rate = validMinutes / (660 Γ shiftCount) Γ 100 - Process Sequence Mapping: Pre-Blasting moved to front (Seq: 0)
β’ Fixed: DB mappings merged with default mappings
β’ Chart order: FO Desc 2 category β Seq within category
Improvements
- Analysis Page Removed: Simplified UI by removing redundant analysis page
- Export/Import JSON Removed: Now fully database-based with Cloudflare D1
- Chart Compatibility: Fixed Chart.js v3+ compatibility (horizontalBar β bar with indexAxis: 'y')
- Debug Logging: Added detailed console logs for shift calculation and work rate
Version 3.0.0
2026-02-21Two Metric System
- Dual Metric Mode: Toggle between Utilization Rate & Efficiency Rate
- Utilization Rate: Actual work time / Available time Γ 100
- Efficiency Rate: Assigned standard time / Actual time Γ 100
- Dynamic Headers: Table headers adapt to current metric type
- Performance Bands: Separate thresholds for each metric
Data Quality
- Outlier Filtering: Automatically filters workers with rates >1000% from aggregated reports
- Note: Individual work orders are preserved; only worker-level totals are filtered
- Threshold: Configurable (default: 1000%)
Version 2.0.0
2026-02-17Major Features
- Database Integration: Cloudflare D1 for persistent storage
- Time Overlap Detection: Automatic removal of overlapping work intervals
- Performance Bands: Excellent (β₯80%), Normal (50-80%), Poor (30-50%), Critical (<30%)
- Worker Detail Modal: Daily trends, hourly distribution, and detailed records
- Process Mapping: Flexible FD Desc β FO Desc 2/3 mapping with sequence ordering
Version 1.0.0
2026-02-01Initial Release
- Excel Upload: Support for .xlsx/.xls files
- Basic Reports: Worker performance and process analysis
- Charts & Visualizations: Performance bands, process distribution
- Shift Calendar: A/B/C shift management
Technical Notes
- Framework: Hono (Cloudflare Workers) + Vanilla JavaScript
- Database: Cloudflare D1 (SQLite)
- Charts: Chart.js v3+
- Deployment: Cloudflare Pages
- Version Control: Git + GitHub
6. Process 맀ν
- Process 맀ν νμμ FD Desc/FO Descλ₯Ό μμ ProcessμΌλ‘ 맀νν©λλ€.
- 맀ν λ°μ΄ν°λ JSON λ΄λ³΄λ΄κΈ° μ ν¨κ» μ μ₯λ©λλ€.
- μμ(Seq)λ₯Ό μ§μ νμ¬ λ¦¬ν¬νΈμμ Process μ λ ¬ μμλ₯Ό μ μ΄ν μ μμ΅λλ€.
7. λ¬Έμ ν΄κ²°
λ°μ΄ν°κ° μ λ‘λλμ§ μμ λ:
- μμ νμΌμ 'Raw' μνΈκ° μλμ§ νμΈ
- νμ ν€λκ° λͺ¨λ ν¬ν¨λμ΄ μλμ§ νμΈ
- λ μ§/μκ° λ°μ΄ν°κ° μ¬λ°λ₯Έ νμμΈμ§ νμΈ
- λΈλΌμ°μ μ½μ(F12)μμ μ€λ₯ λ©μμ§ νμΈ