This spreadsheet template is designed to support regular market/price monitoring by collecting comparable commodity prices from multiple vendors across one or more locations and across repeated survey rounds (e.g., weekly). It guides users to enter an item/commodity name (example shown: rice) and define a standard unit (example: kilogram), then record prices from different sources (traders/shops/customers) for each survey date. For each location, the template captures the local selling unit (e.g., large tin, packet) and a conversion rate to the standard unit, then automatically calculates an average selling price and converts it into a standard-unit price to ensure prices are comparable across markets and over time. A separate graph sheet is included to visualize trends once data are populated.

Table of contents (worksheets and main sections)
1. Data Sheet
• Template instructions / shaded input cells
• Commodity setup: Item/Commodity and Standard Unit
• Survey rounds: Survey 1–Survey 14 (with “Insert Dates Here” row)
• Location blocks (e.g., Location 1, Location 2, Location 3), each containing:
- Selling unit + conversion rate
- Multiple price sources (vendors/shops/customers)
- Auto-calculated averages
- Conversion to standard unit price
2. Graph
• Pre-formatted chart area to plot price trends over the survey rounds (populates once linked data are in place)