Forest Products Transport Monitoring Dashboard

Foreword Page 4

It is with great pride that I present the Forest Products Transport Monitoring Dashboard User Manual, a product of the Department of Environment and Natural Resources (DENR) Region XI's ongoing commitment to digital transformation and effective environmental law enforcement.

The Forest Products Transport Monitoring Dashboard serves as a crucial monitoring system for regulating the movement of forest products and wildlife resources. Through the use of this dashboard, our field personnel and enforcement officers are now equipped with a real-time digital platform that simplifies documentation, improves accuracy, and strengthens decision-making.

Message Page 5

It is with great satisfaction that I extend my message to the users of the Forest Products Transport Monitoring Dashboard User Manual. This system represents a remarkable achievement in the continuing efforts of the Department of Environment and Natural Resources- Provincial Environment and Natural Resources Office (DENR-PENRO) Davao del Norte to strengthen monitoring, enforcement, and data management related to forest products and wildlife transport within Davao del Norte.

The Forest Products Transport Monitoring Dashboard User Manual provides our personnel and management teams with a more efficient and transparent way to record, track, and analyze transport activities. By replacing manual processes with real-time digital tools, this system enhances accuracy, reduces delays, and promotes accountability in our environmental law enforcement operations.

1. Introduction Page 15

The Forest Products Transport Monitoring Dashboard is a digital monitoring system developed by the Department of Environment and Natural Resources- Provincial Environment and Natural Resources Office (DENR-PENRO) Region XI to enhance transparency, efficiency, and data accuracy in forest product and wildlife transport monitoring.

1.1 Purpose of the Manual Page 16

This User Manual serves as a comprehensive reference and instructional guide for all users and administrators of the Forest Products Transport Monitoring Dashboard. It provides detailed information on the system's objectives, functionalities, and operational processes to ensure its effective and consistent use.

1.2 Scope and Audience Page 16

The scope of this manual covers both technical and operational aspects of the Forest Products Transport Monitoring Dashboard, ensuring that all stakeholders involved in the management, monitoring, and regulation of forest product transportation can effectively perform their roles within the system.

This manual is specifically intended for:

• DENR Officers and Administrators
• CENRO Personnel
• Checkpoint Monitors and Enforcement Officers
• Technical Staff and IT Support

1.3 System Overview Page 17

The Forest Products Transport Monitoring Dashboard is an innovative, web-based platform designed to enhance the monitoring, regulation, and management of forest product transportation within the jurisdiction of PENRO Tagum, Davao del Norte.

Key features of the dashboard include:

• Real-Time Monitoring: Enables instant tracking of forest product movement and permit validation.
• Data Visualization: Provides dynamic charts, graphs, and summaries to support data analysis and decision-making.
• Centralized Recordkeeping: Ensures that all permit and transport records are stored securely and can be easily retrieved for audits or inspections.
• User Accessibility: Designed with a user-friendly interface that supports both administrative and operational functions.

2. Strategic Alignment Page 18

The Forest Products Transport Monitoring Dashboard is an innovative digital system developed to enhance the monitoring and regulatory capabilities of the DENR – PENRO Tagum, Davao del Norte. Its main goal is to ensure efficient, transparent, and data-driven oversight of forest product transportation across the province.

Designed as an interactive, real-time platform, the dashboard consolidates operational data such as transport permits, vehicle registrations, checkpoint records, and consignee details into a single interface.

3. Impact Page 19

a. Operational Transparency and Compliance

The system supports the real-time monitoring of forest product transport through:

1. Permit Tracking – All issued transport permits are recorded and visualized for easy verification.
2. Checkpoints Monitoring – Integration of checkpoint data ensures movement legitimacy.
3. Analytics Visualization – Visual charts summarize product types, species, and destinations.

b. Data-Driven Decision Making

The Analytics Dashboard converts raw data into meaningful visual information through:

• Real-time filtering options by date, species, CENRO, or consignee.
• Bar, line, radar, and pie charts for product types, volume, and destinations.
• Dynamic summaries for Total Permits, Volume (CU.M), BD. FT, and Pieces.

c. Environmental and Organizational Advantages

1. Improved Regulatory Oversight: The system centralizes permit verification, reducing manual errors and ensuring consistent monitoring.
2. Faster Validation: Automated record-keeping enables immediate verification of transport legality.
3. Enhanced Accountability: Every transaction and record can be traced back to a specific office or officer.
4. Transparency to Stakeholders: Promotes trust among partners, communities, and governing agencies.
5. Support for Sustainable Development Goals (SDGs): Contributes to climate action, responsible production, and life on land (SDG 13, 12, and 15).

4. Key Features Page 20

Dashboard Highlights:

Quick Stats:

System Requirements Page 20-21

Recommended Browsers:

• Google Chrome 90+ (Recommended)
• Mozilla Firefox 88+
• Safari 14+
• Microsoft Edge 90+

Technical Requirements:

• Internet connection for data loading
• JavaScript enabled
• Minimum screen resolution 1024×768
• Pop-up blocker disabled for PDF downloads

5. Getting Started Page 21

First Time Setup

Open your browser's address bar, type https://mes.rave-master.de, and press Enter, or scan the QR code to access the mobile interface.

QR Code for mobile access

When you first open the dashboard, it automatically loads data from the connected Google Sheets database. Loading usually takes 5–10 seconds, depending on connection speed and data size.

Initial Data Load Process:

1. Connects to Google Sheets API
2. Downloads and processes data
3. Generates charts and statistics
4. Displays current month data
5. Populates filter options

8. The Dashboard Page 27-28

8.1 Login & View Top Bar

After logging in, your profile, date, and time appear in the top bar. You may click Logout anytime.

8.2 Search Records

Type keywords in the Search box. The table updates instantly with matching records.

8.3 Toggle Months

Click Prev or Next to move between months. The label updates (e.g., August 2025). If no records exist, a "No Records" message appears.

8.4 Data Table

Table automatically loads entries for the selected month. Footer calculates totals/summary data.

8.5 Open Other Sections

Click Analytics → Charts and summaries
Click Forms → Submit new monitoring records

11. Dashboard Components Page 32-36

11.1 Statistics Cards

The statistics cards show KPIs for the selected time period. They update automatically when filters change.

11.2 Interactive Charts

The dashboard includes seven specialized charts providing different insights:

1. Permits by Species (Doughnut Chart) - Shows percentage distribution by species
2. Kind of Forest Products (Bar Chart) - Displays quantities by product type
3. Daily Trend (Line Chart) - Shows daily permit issuance patterns
4. CENRO Distribution (Polar Area Chart) - Geographic distribution by CENRO office
5. Destination Distribution (Horizontal Bar Chart) - Top destinations for forest products
6. Permit Types (Pie Chart) - Breaks down permit types by percentage
7. Consignee Volume Distribution (Bar Chart) - Shows top consignees by volume (CU.M)

11.3 Data Table

The Recent Permits Table displays detailed permit records filtered by month.

Columns include: Date, Permittee, Species, Pieces, Volume (CU.M), BD.FT, Transport Type, Plate No., CENRO

13. Data Management Page 39-40

13.1 Data Refresh

Connected live to Google Sheets for current information.

Refresh Steps:

1. Click "Refresh Data" button
2. "Loading data..." appears
3. Connects to API
4. Downloads and processes data
5. Charts regenerate
6. Filters update

When to Refresh:

• Start of a session
• After new permits are added
• If charts look outdated
• After maintenance or updates

13.2 Data Sources

Primary Source: Google Sheets database

Data Fields:

• Permit Info: Date, permittee, permit type
• Product Details: Species, volume, pieces, board feet
• Transport: Vehicle type, plate no., destination
• Administrative: CENRO, consignee

13.3 Data Validation

Ensures consistency and handles missing information.

Validation Features:

• Missing data → "Unknown"
• Numeric conversion and date parsing
• Text normalization groups similar entries

14. Reporting Features Page 41-42

14.1 PDF Report Generation

Generates detailed PDF reports from your current filters.

Steps:

1. Select month
2. Apply filters
3. Click "Generate PDF Report"
4. Wait for analysis
5. PDF downloads automatically

Report Contents:

• Executive Summary
• KPIs and statistics
• Species/CENRO/Consignee analyses
• Destination breakdown
• Daily activity patterns
• Recommendations

14.2 Report Customization

Adjust filters before generating to tailor content.

Customization Options:

• Time Period: Month or range
• Region: CENRO focus
• Destination: Market reports
• Date Range: Weekly or event focus

14.3 Scheduled Reports

No auto-scheduler, but you can adopt manual routines.

Recommended Schedule:

• Monthly (end of month)
• Weekly updates (via date range)
• Quarterly reviews
• Annual summaries

14. Analytics & Insights Page 43-44

14.1 Species Analysis

Understand species composition and movement trends.

Features:

• Percentage breakdown charts
• Hover for counts + percentages
• Color-coded species
• Auto-group similar names

Use Cases:

• Biodiversity monitoring
• Sustainability checks
• Market demand analysis
• Compliance tracking

14.2 Volume Tracking

Quantitative view of movements.

Metrics:

• Cubic Meters (CU.M)
• Board Feet (BD.FT)
• Piece Count
• Average Volume per Permit

Applications:

• Economic impact calculation
• Capacity planning
• Consignee analysis
• Trend monitoring

14.3 Trend Analysis

Identify patterns over time.

Tools:

• Daily Trend Chart
• Monthly comparisons
• Month-over-month changes
• Peak activity detection

Patterns to Monitor:

• Seasonal variation
• Weekly patterns
• Growth trends
• Regulatory impact

15. Troubleshooting Page 45-46

15.1 Common Issues

Data Loading

Problem: "Loading data..." stays forever

Solutions:

• Check internet connection
• Refresh (F5 / Ctrl + R)
• Click "Refresh Data" button
• Clear browser cache
• Try another browser

Charts Blank

Problem: Charts don't appear

Solutions:

• Enable JavaScript in browser settings
• Disable blocking extensions
• Refresh the page
• Confirm data exists for selected period
• Use supported browser

PDF Failing

Problem: PDF doesn't download

Solutions:

• Allow pop-ups for the site
• Check downloads folder
• Ensure data is loaded before generating
• Try other filters
• Clear cache and retry

15.2 Performance Tips

• Browser: Use Chrome / Firefox, keep updated, close unused tabs, disable heavy extensions
• Data Handling: Filter large datasets, refresh only as needed, use monthly navigation first
• System: Stable internet (≥ 1 Mbps), 4 GB RAM recommended, Resolution ≥ 1024×768

15.3 Error Messages

16. Mobile Usage Page 47

16.1 Mobile Features

Fully responsive for phones & tablets.

Optimizations:

• Auto-adjust layout
• Touch-friendly buttons
• Responsive charts
• Scrollable tables
• Stacked navigation
• Single column view
• Larger text
• Simplified controls
• Collapsible sections

16.2 Touch Interactions

• Tap: Activate buttons / filters
• Hold: Show chart tooltips
• Swipe: Scroll tables
• Pinch: Zoom browser view

17. Security & Privacy Page 48

17.1 Data Security

Measures:

• Read-only access
• HTTPS encryption
• No local storage
• Client-side PDF generation
• No third-party sharing

Protections:

• Secure API integration
• No persistent sessions
• Uses browser security
• Login required

17.2 Privacy Policy

Practices:

• No personal data collection
• No tracking or analytics
• No cookies
• Local processing only

Usage:

• Data shown for visualization only
• Cleared on browser close
• No retention or uploading
• Full user control

Appendices Pages 51-59

Appendix A – Glossary of Terms

Appendix B – System Requirements

Minimum Requirements:

• Hardware: Dual-core processor (2.0 GHz or higher), 8 GB RAM, 10 GB available disk space, 1280x720 screen resolution
• Software: Windows 10 or later / macOS 10.14+, Google Chrome (latest version) or Microsoft Edge
• Internet: Stable broadband connection (minimum 5 Mbps)
• User Access: Active DENR or CENRO account credentials

Recommended Setup:

• Quad-core processor (2.5 GHz or higher)
• 16 GB RAM
• Dual-monitor configuration for data analysis
• High-speed internet (10 Mbps or more)

Appendix C – User Roles and Access Levels

Appendix E – Troubleshooting Guide

Appendix E – Technical Support