Playtopia Dev Labs
Where Innovation Meets Implementation

📊 MSR Generator - User Guide

Overview

MSR Generator automates the monthly service review process for Nexon-Ausgrid operations, transforming manual Excel manipulation and PowerPoint creation into a streamlined automated workflow. This guide covers the complete platform usage from file upload to report generation.

🚀 Getting Started

Accessing the Platform

  1. Navigate to MSR Portal: Visit https://msr.playtopia.com.au
  2. Authelia Authentication: Log in using your enterprise credentials
  3. Eva Dashboard: Experience the anime/kawaii themed interface with Unit-02 styling

User Roles & Access Levels

Interface Overview

The MSR Generator features an Eva/kawaii themed interface with:

📁 File Upload System

Supported File Categories

Service Data Files

Performance Metrics Files

Incident Data Files

Report Templates

File Upload Process

Step 1: Navigate to Upload Interface

Step 2: Select Report Month

Report Month: [Select YYYY-MM format]
Example: 2025-08 for August 2025 report

Step 3: Choose File Category

Select the appropriate category for your files:

Step 4: Upload Files

Drag-and-Drop Method:

  1. Drag files from your computer to the upload zone
  2. Watch for visual feedback as files are selected
  3. Review file list with names and sizes
  4. Verify all files are correct before submission

File Selection Method:

  1. Click “Choose Files” button
  2. Navigate to files in the browser dialog
  3. Select multiple files using Ctrl+Click (Windows) or Cmd+Click (Mac)
  4. Click “Open” to add files to upload queue

Step 5: Submit for Processing

  1. Review uploaded file list for accuracy
  2. Verify report month and category selections
  3. Click “Submit Files for Processing”
  4. Monitor upload progress with real-time progress bars

Upload Validation and Security

File Size Limits

Security Scanning

🔄 Data Processing Workflow

Automated Processing Pipeline

Phase 1: File Ingestion

1. File Validation → Security scanning and format verification
2. Metadata Extraction → File properties and content analysis
3. Category Classification → Automatic content type detection
4. Storage Allocation → Secure file storage with backup

Phase 2: Data Extraction

1. Excel/CSV Parsing → Cell-by-cell data extraction
2. Formula Evaluation → Calculated field processing
3. Data Normalization → Standardized format conversion
4. Quality Validation → Data integrity checks

Phase 3: Business Logic Application

1. Service Metrics → Availability calculations and trend analysis
2. Performance Analysis → KPI computation and benchmarking
3. Incident Processing → Outage impact and duration analysis
4. Template Processing → Placeholder identification and mapping

Phase 4: Report Generation

1. Data Aggregation → Multi-source data combination
2. Chart Creation → Visual representation generation
3. Template Population → Dynamic content injection
4. Format Export → PDF and PowerPoint output creation

Processing Status Monitoring

Real-Time Status Updates

Progress Indicators

📊 Report Generation and Management

Automated Report Creation

Service Performance Reports

Incident Management Reports

Executive Dashboards

Commentary and Customization

Editable Commentary Fields

Each report section includes commentary fields for human insight:

Executive Summary Commentary:
[Editable text field for high-level observations]

Performance Analysis Commentary:
[Detailed technical analysis and observations]

Incident Review Commentary:
[Root cause analysis and prevention strategies]

Recommendations Commentary:
[Action items and improvement suggestions]

Rich Text Editing

Report Export and Distribution

Export Formats

Distribution Options

🎨 Eva Theme Interface Guide

The horizontal navigation menu features Eva-themed styling:

Dashboard Elements

Accessibility and Usability

Color and Contrast

Keyboard Navigation

🔧 Business Logic Configuration

Data Processing Rules

Service Data Processing Rules

Availability Calculation:
- Uptime = (Total Time - Downtime) / Total Time * 100
- SLA Compliance = Availability >= Target SLA Percentage
- Trend Analysis = Month-over-Month Comparison

Performance Metrics:
- Response Time = Average of All Measured Response Times
- Throughput = Total Transactions / Time Period
- Error Rate = Error Count / Total Transactions * 100

Incident Data Processing Rules

Impact Classification:
- Critical: Service completely unavailable
- High: Significant functionality impaired
- Medium: Minor functionality affected
- Low: Cosmetic or minimal impact

Duration Calculation:
- MTTR = Mean Time To Resolution
- MTBF = Mean Time Between Failures
- Availability Impact = (Outage Duration / Total Time) * Customer Count

Custom Business Logic

Configurable Thresholds

Formula Customization

🛠️ Advanced Features

Batch Processing

Multi-Month Processing

Scheduled Processing

Integration Capabilities

External System Integration

API Access

🛠️ Troubleshooting

Common Issues and Solutions

File Upload Problems

Processing Errors

Report Generation Issues

Performance Optimization

Upload Optimization

Processing Optimization

📚 Best Practices

Efficient Workflow Management

Data Preparation

Report Management

Security and Compliance

Data Handling

Change Management

This comprehensive user guide covers all aspects of using MSR Generator effectively. The platform combines powerful automation capabilities with an engaging Eva/kawaii themed interface to deliver professional monthly service reviews with minimal manual effort.