Here is the first stab at it. Now I've locked all but the fields for data entry to prevent accidental deletion of formulas. This also helps with entering the data where a tab from the last column in a row takes you to the left most column in the next row. There are two tables to enter data ... one with catch data and another with trip data. I left the HBG Exponent and Multipliers unlocked so you could adapt them. I actually couldn't find a length weight chart for HBG so I averaged GSF and BG numbers to get the exponent and multiplier. Don't rely on it. If you have some data to work with I could solve the standard weight equation for your bow. If you already have ... please do share it with us. The last two tabs have pivot tables/charts displaying some fake data. Feel free to play and if you have any questions about how to manipulate the pivot tables/charts let me know. BTW I added the pivots before all the columns were complete and so some the table isn't presently accessible. You can however expand the data or create new tabs containing pivots with fields of all the secondarily computed data.
Here are the measurement methods supported.
1. Measured Length & Weight ... An RW is computed and one should enter only one fish in the # fish column. Actual weight will be in the Total Weight column.
2. Measured Length only ... No RW is computed and one should enter only one fish in the #Fish column. A standard weight will be used in the Total Weight column.
3. Measured Weight only ... No RW is computed. For this measurement one may used a combined weight of many fish. One should enter the number of fish in the combined weight in the #fish column. A standard length is computed. Actual weight is used in the Total Weight column. I thought this might be convenient for panfish harvests where one may not care about prey fish relative weights.
Anyways ... its a start
It isn't what we don't know that gives us trouble, it's what we know that ain't so - Will Rogers
