Keep a two-week price diary for five fish at one Goan market
Fish prices at Panjim, Margao and village markets change every morning, but most buyers only remember that fish has become costly, not when or why.
A two-week sheet of daily prices for five fish at one market, a line chart, and a half-page note on which fish moved most and two possible reasons.
This is a spreadsheet analysis project. Put real data in a table, work it out, and say what the numbers show.
The approach: Decide what one row means → Clean the data before analysing it → Calculate in the sheet, not in the chat → Write the finding in a sentence a manager can act on.
Think first
You are recording what five fish actually cost at one market over two weeks, then explaining the sharpest change. The point is to see how prices really move, not to guess at a trend from one visit or a news story.
- Which market and which single vendor will you visit, and at what time of the morning?
- In what unit does the vendor quote each fish, and will that stay the same every day?
- What else will you write down each visit: weather, sea conditions, festivals, how full the stall looked?
- How will you tell a real price change from the vendor simply giving you a different size of fish?
A clean table with one row per visit, a column per fish, the unit in each header, a short notes column, a line chart, and a half-page note that names the fish that moved most and two reasons you checked with a person.
Visiting different stalls or at different times and treating every gap as a price swing. A late-morning price is often lower because the vendor wants to clear stock, so keep the time and the vendor fixed.
Gather
- Your own price notes from each visit, written on the spot
- The vendor's answer to one question each visit: is today's catch more or less than usual?
- Notes on weather and sea conditions, from what you saw or a public weather forecast
AI must not fill gaps in your diary or suggest typical prices. If you missed a day, leave the cell blank and say so in the notes.
Build with AI
- 3.1 Set up the diary tableGOOGLE SHEETS
Why this tool: A fixed table makes every visit comparable and makes gaps visible.
Columns: date, time, weather, one column per fish with the unit in the header, and notes. Freeze the header row and enter prices the same day you visit.
- 3.2 Find the widest swingGOOGLE SHEETS
Why this tool: Working out the change in the sheet keeps the numbers checkable.
For each fish, add rows for the lowest and highest price you saw and the gap between them. Draw a line chart with one line per fish.
- 3.3 List possible reasonsCLAUDE CHAT
Why this tool: Claude can suggest reasons you had not thought of, which become questions for the vendor.
Paste the table and your notes. Ask for possible reasons and questions, then take the questions back to the market.
- 3.4 Draft and tighten the noteCLAUDE CHAT
Why this tool: A second pass helps you cut your note to what the evidence supports.
Write the note yourself first, then ask Claude to mark any sentence that claims more than your diary shows.
Check the AI's work
- Every price in the sheet came from your own visit, with the unit stated
- The widest swing figure matches a recount of the lowest and highest values
- Each reason in the note was checked with the vendor or marked as a guess
- Blank days are shown as blank, not filled with an average
- Recompute two numbers by hand
- Check the row count before and after cleaning
AI tends to blame every price jump on the monsoon or fuel costs. Check whether your swing happened on a calm, ordinary day, in which case the reason is probably local, such as a small catch or a festival.
Finish and show
- A two-week diary table with units and notes
- A line chart with one line per fish
- A row showing the lowest, highest and gap for each fish
- A half-page note with two checked reasons
Put the chart at the top, the note beneath it, and the full table on a second page. Circle the day of the widest swing on the chart.
Say which fish surprised you, what the vendor told you about why, and how you would repeat the diary in the monsoon season.
Which tool fits
- Google Sheets (free alternative): A fixed table makes every visit comparable and makes gaps visible.Free with a Google account.
- Claude chat: Claude can suggest reasons you had not thought of, which become questions for the vendor.Free plan works; Pro gives longer conversations.
- Claude for Excel: building and explaining formulas inside your workbookPaid plans; needs Excel.
Run the same diary at a second market on the same days and compare whether prices move together, then write what that suggests about where the fish come from.
AI helps you think, check and polish. The work, and the judgement, stay yours.
This is a free sample. Full Access opens every project in full and lets you submit your finished work.
See Full Access →