Military Medal Data Spreadsheet
Budget: $30 – $250 CAD
I need a clean, well-organised Excel workbook that catalogues every officially recognised military medal from five countries: USA, UK, India, New Zealand and Australia. For each decoration, please fill out these four fields:
• Medal name exactly as issued
• Direct link to its Wikipedia (or equally authoritative) page
• Direct link to a page that shows the ribbon alone
• The ribbon image itself, inserted as a thumbnail in the sheet
Set up one worksheet for all country’s so the file is easy to navigate. A column for priority, ie a VC has #1 in priority, and a MOH has #1 in priority, while a DCM has second place. A column for the country code. Ie Can VC or NZ VC. Keep the layout consistent, one row per medal, with clear column headers. All links must be live and images should display crisply without inflating the file size.
Acceptance criteria
1. Every current and historical military medal for the five countries is listed.
2. All four data fields are present and accurate; links open correctly.
3. Images render inside the workbook with no broken visuals.
4. File passes a quick spot-check for duplicates and spelling.
Deliver the finished .xlsx file plus any image folder you used, zipped together.
• Medal name exactly as issued
• Direct link to its Wikipedia (or equally authoritative) page
• Direct link to a page that shows the ribbon alone
• The ribbon image itself, inserted as a thumbnail in the sheet
Set up one worksheet for all country’s so the file is easy to navigate. A column for priority, ie a VC has #1 in priority, and a MOH has #1 in priority, while a DCM has second place. A column for the country code. Ie Can VC or NZ VC. Keep the layout consistent, one row per medal, with clear column headers. All links must be live and images should display crisply without inflating the file size.
Acceptance criteria
1. Every current and historical military medal for the five countries is listed.
2. All four data fields are present and accurate; links open correctly.
3. Images render inside the workbook with no broken visuals.
4. File passes a quick spot-check for duplicates and spelling.
Deliver the finished .xlsx file plus any image folder you used, zipped together.
Related categories:
Data Processing
Data Entry
Research
Excel
Web Scraping
Documentation
Data Analysis
Data Management