I also put together a spreadsheet at
https://www.questsofdiscovery.com/files (scroll down to the bottom of the list).
In my experience food
consumption goes down on long passages at sea. Also, a "planned meals menu" changes after 1.5 days. I don't provision based on planned daily menus...I provision based on things I like to eat.
Also, things like warm cookies from the
oven are a real treat once a week, and some dark chocolate is nice also.
Fresh bread is also great. I usually make Irish soda bread once a week. (I don't eat a lot of bread.) For lunch sandwiches, I use flour tortillas instead of bread...they last longer and roll up nicely for ease of
consumption.
Staples such as rice, pastas, dried noodles, beans, etc are easy to store and last a long time especially if stored in sealed containers. I partition pasta and rice and beans into 2 person serving size and seal in vacuum sealed bags for
storage.
I don't stock up on tuna...I have never failed to catch
fish at sea...I used to get to port with more tuna than SPAM! (Unless you really like SPAM...there are many other better alternatives.)
Root veggies last a long time, other veggies not so much. Plan meals accordingly. Again, unless you really like the taste of canned veggies...it is something I would skip. Fresh veggies are usually plentiful wherever you go.
Recently I found those Tasty-Bite things are easy and pretty good over rice. Dress them up with canned chicken, fresh veggies, etc and they make a quick and excellent hot meal.
Provisioning is tricky business when you first start out...we tend to over-provision and somethings go to waste. With experience and based on location your diet and provision amount will likely change.
Oh...one last thought....if you buy in bulk....get a vacuum sealer and divide into smaller packages.
Buying a greater quantity of smaller sized things like condiments helps reduce waste...you won't go through 1 gallon of mayonnaise in a
passage.
Also be aware that some countries may confiscate certain items in your pantry upon entry...so check on that and use those items prior to clearing in.