Company Overview · 2025
Greenpeg Engineering
All departments · Performance Dashboard · Real-time data
Hit Rate Analysis — 2025
Weekly = Purchase Orders ÷ Opportunities · Annual = Won Revenue ÷ Company Target × 100
0%
Annual HR
Revenue ÷ Target × 100
—
Weekly Hit Rate
PO ÷ Opportunity
—
Total Orders
All records
—
Won / Completed
Order entry count
—
Cancelled / Lost
Not fulfilled
Total Order Value
—
All departments
Won Revenue
—
Completed orders
Open Pipeline
—
Active orders
Rejected POs
61
₦256.8M total
Department Performance vs Target — 2025
Click any card to open full department view →
Monthly Order Entry — 2025
Won order value by month
Top 10 Clients by Revenue
Won value — all departments
Revenue by Industry (External Sales)
Won order value by sector — 2025
Cumulative Revenue vs Target Pace
Monthly build-up against annual target
Overall YTD Analysis
Total Value
—
All depts
Won / Paid
—
Completed
Open Pipeline
—
In progress
Cancelled
—
Lost / rejected
Year-on-Year Analysis — All Departments
Comparing available years of data
| Department | 2024 | 2025 | Change (₦) | Change (%) | Trend |
|---|
All Orders — General View
Showing 2025 records
| Reference | Company | Item / Description | Department | Industry | Sales Person | Order Value | Stage | Month | Status |
|---|
Records · All Years
Rejected Purchase Orders
All rejected POs with company, PO number, value and reason for rejection
Total Rejected POs
61
All recorded rejections
Total Rejected Value
₦256.8M
Combined PO value
Top Reason
Price Issues
Most common category
Avg. Rejected Value
₦4.2M
Per rejected PO
Rejection Reasons Breakdown
Categorised reasons for PO rejection
Top Rejected Companies
By total rejected PO value
Rejected PO Register
All 61 rejected purchase orders
| Week | Month | Company | PO Number | PO Value | Reason for Rejection |
|---|
Configuration
Settings
Configure dashboard identity, targets and connect your Google Sheet
Dashboard Identity
Title, subtitle and header labels
Company Name / Dashboard Title
Shown in header and overview page
Header Subtitle
Overview Page Description
Annual Target Label
Company Annual Target (₦)
Enter full number e.g. 24000000 = ₦24M
Department Targets — 2025
Annual revenue target per department (₦)
Live Data Source
One Google Sheet drives everything — all departments are in the ORDERS tab, filtered by the Department column
ORDERS Tab — Master Data (Required)
All purchase orders for all 7 departments. Dashboard reads this and filters by Department column automatically.
How to get this URL:
1. Open your Google Sheet → File → Share → Publish to web
2. Select the ORDERS tab from the dropdown
3. Select Comma-separated values (.csv)
4. Click Publish → Copy the URL below
2. Select the ORDERS tab from the dropdown
3. Select Comma-separated values (.csv)
4. Click Publish → Copy the URL below
ORDERS Tab CSV URL
QUOTATIONS Tab — Hit Rate (Optional)
Used to calculate Hit Rate = Purchase Orders Won ÷ Quotations Sent. Without this, dashboard uses orders-only ratio.
QUOTATIONS Tab CSV URL
Department Display Names (Optional)
Rename how each department appears in the sidebar and dashboard. Leave blank to use default names.
✓ Settings saved successfully