This is a lovely spreadsheet thank you! It must have taken you ages to fine tune it so well!
It took me a minute to work out your servings; they’re 1-and-a-half inch by 2 inch servings right?
It might be neat to add a little conditional formatting on your portion/pan guide section that will highlight what pans people could use for the servings they are pricing for;
This is how I would to it:
You would need to add conditional formatting for each of your pan serving numbers (N33 to N42, P33:41 and R33:36)
To highlights the pan serving number if it is equal to, or up to 10 servings more than, the number of servings in C6:
Go to conditional formatting, ‘choose highlight if between’, for the first value choose C6 and for the second value write C6+10
Set your highlight however you like :)
Great job though!! :)
