Model the economics of one fishing trip with made-up inputs

You are modelling whether one fishing trip pays, from the boat owner's side and the crew's side, using made-up but sensible inputs and the sharing method that people at a harbour describe. The aim is to see which assumption decides the answer.

• What are the trip costs: diesel, ice, food, bait, gear wear, harbour charges?
• How is the catch shared between owner and crew, according to the people you asked?
• What decides the catch value: quantity, mix of species, and the price on the day?
• What happens to the price when every boat comes back with a big catch?
• Which single input would you most want to know accurately before going out?

A sheet with an assumptions block, a trip calculation, a crew share block, the owner's net result, a break-even catch value and three scenarios, with every input labelled made up and a line naming the input the result depends on most.

Treating catch value as quantity times a fixed price. On a glut day the price can drop sharply, so a big catch is not always a good day. Link price to how much the whole harbour landed in at least one scenario.

• Notes from a conversation with a boat owner or crew member on how costs and shares are split, with consent
• Your own made-up figures for each input, informed by what you saw at the harbour
• Public material from the fisheries department on boat categories, so your boat type is described correctly

AI must not give real diesel use, catch quantities or share percentages as facts. Every input is yours and labelled made up, and the sharing method comes from someone you spoke to.

1. 3.1 Turn interview notes into an assumptions tableCLAUDE WORKING ON YOUR FILES (FORMERLY COWORK)

   Why this tool: Claude working on your notes file can pull out every cost and sharing rule into one table for you to fill.

   Put your typed interview notes in one folder and ask Claude to produce an assumptions table with empty value cells. Fill the values yourself.

   Prompt to copy · fill in the [brackets]Copy

   Read my interview notes in [notes file name]. Build a table of every trip cost and every sharing rule they mention, one row each, with columns for item, unit, how it is decided and source line. Leave the value column empty for me to fill. Do not add costs that are not in the notes.

   Before you let it act: Check the folder holds only your notes with no names, and that you asked for a new table file rather than changes to the notes.

2. 3.2 Build the trip modelCLAUDE FOR EXCEL

   Why this tool: Formulas linked to labelled inputs let you change one assumption and see the result move.

   Assumptions at the top, then costs, catch value, the crew share, the owner's net result and break-even catch value. Ask Claude to explain each formula as you go.

   Prompt to copy · fill in the [brackets]Copy

   In this workbook the assumptions are in [cell range]. Build formulas for total trip cost, catch value, the crew share using this method: [sharing method from notes], and the owner's net result. Add a break-even catch value. Do not type any number into a formula; refer to the input cells.

3. 3.3 Add three scenariosGOOGLE SHEETS

   Why this tool: Scenarios side by side show how fragile the result is.

   Copy the inputs into three columns for a poor, normal and good day. In the good day column, lower the price to reflect a harbour-wide glut and see what happens.

4. 3.4 Challenge the modelCLAUDE CHAT

   Why this tool: Having someone attack your assumptions finds the weak spots before a reader does.

   Paste your assumptions and results and ask what a boat owner would question first.

   Prompt to copy · fill in the [brackets]Copy

   Here are my made-up assumptions and results for one fishing trip from [harbour or village]: [paste]. As an experienced boat owner, which three assumptions would you question first, and why? Which costs might I have left out?

• No number is typed inside a formula; every input is a labelled cell marked made up
• Recompute the owner's net result for the normal day by hand
• The sharing method matches what your interview described
• The good-day scenario reflects a lower price when the whole harbour lands a big catch
• No number typed inside a formula: every input is a labelled cell
• Recompute the headline result by hand

AI often deducts costs after splitting the catch, or before, without asking. The order matters for the crew's share, so build it the way the people you spoke to described.

• An assumptions table from your notes
• A trip model with labelled made-up inputs
• A break-even catch value
• Three scenarios
• A note on the input the result depends on most

A one-page summary: a small table of the three scenarios, the break-even figure and two sentences on what decides whether a trip pays.

Show the glut-day scenario and explain why a big catch can still be a poor day for the owner and crew.