Create a downloadable single-file HTML dashboard called "Sugar Export Market Intelligence" from the attached TDM export Excel workbook.
Requirements:
• Read the first worksheet and use:
FLOW, REPORTER, PARTNER, COMMODITY, YEAR, MONTH, VALUE, QTY1, UNIT1
• Add visible buttons:
- Import Excel
- Export Filtered CSV
- Reset Filters
• Importing a new Excel file must:
- Replace the dataset
- Rebuild filters
- Refresh all visuals
- Show filename and row count
• Calculate Volume MT dynamically:
- T = QTY1
- KG = QTY1 / 1000
• Calculate:
Weighted USD/MT = Total Value / Total Volume MT
• Use these exact product names:
1701.11 - Cane sugar, raw, in solid form, not containing added flavouring or colouring matter
1701.13 - Cane sugar specified in Subheading Note 2 to this Chapter
1701.14 - Other cane sugar
1701.99 - Other refined sugar
• Global filters:
- Reporter
- Destination Market
- Product
- Year
Pages:
1. Executive Overview
- Export Value
- Volume MT
- Weighted USD/MT
- Markets
- Filtered Rows
- Monthly Export Value Trend
- Top Destinations
- Top Reporters
- Product Mix by Value
2. Products
- Product Composition by Export Value
- Product Composition by Volume
- Top Destination Markets for Selected Product
- Top Reporters for Selected Product
3. Markets
- Top Destination Markets
- Reporter Origins for Selected Market
- Market Product Mix
- Annual Market Trend
4. Trade Routes
- Sankey Diagram
- Reporter → Destination Market flows
- Link width based on Export Value
- Interactive and filter-aware
5. Data Explorer
- Search
- Pagination
- Reporter
- Destination
- Product
- Value
- Quantity
- Unit
- Volume MT
- USD/MT
Styling:
• Professional executive dashboard
• Green / Navy corporate theme
• Responsive layout
• White cards
• Sticky navigation tabs
• Mobile friendly
Include validation for invalid rows and display row number with rejection reason.
Return the completed dashboard as a downloadable HTML file.