Calculating Pounds and Ounces

[Outdoorsman80]

I have a spreadsheet to measure meat totals for chickens.
I record the weight of Breast, Legs and Tenders

File.xlsx
	R	S	T	U	V
3	Part	Pounds	Ounces	Bird Total	Year
Data

File.xlsx
	R	S	T	U	V
287	Hen Legs	1	10.8	1.675	2023
288	Hen Breast	1	0.5	1.03125	2023
289	Hen Tender	0	3.2	0.2	2023
290	Rooster Legs	1	5.8	1.3625	2023
291	Rooster Breast	0	15	0.9375	2023
292	Rooster Tender	0	3.4	0.2125	2023
Data

Cell Formulas
Range	Formula
U287:U292	U287	=S287 + T287/16

To explain the forumula, there's 16 ounces in a pound, so I add the pound cell plus the ounces cell then divide it by 16 to get the weight in pounds. The reason I do this is, some parts may not be a 1 pound 1.2 ounces, it could just be 14 ounces. In order to get a consistent number for the other formula, I convert it. So, above, Rooster Breast is only 15oz and that = .9375 pounds.

At the end of the season, I have a dashboard that calculates the totals of breast/tender, legs and all three.

File.xlsx
	A	B
45	Broiler Breast/Tender Total	2.38125
46	Broiler Legs Total	3.0375
47	Broiler Meat Total	5.41875
Dash

Cell Formulas
Range	Formula
B45	B45	=SUMIFS(tblBroilerTotalPerBird[Bird Total],tblBroilerTotalPerBird[Part], "*Breast", tblBroilerTotalPerBird[Year], "2023") + SUMIFS(tblBroilerTotalPerBird[Bird Total],tblBroilerTotalPerBird[Part], "*Tender", tblBroilerTotalPerBird[Year], "2023")
B46	B46	=+SUM(SUMIFS(tblBroilerTotalPerBird[Bird Total],tblBroilerTotalPerBird[Part], {"*Legs"}, tblBroilerTotalPerBird[Year],{"2023"}))
B47	B47	=+SUM(SUMIFS(tblBroilerTotalPerBird[Bird Total],tblBroilerTotalPerBird[Year],{"2023"}))

The Dash tab above, those totals are just in pounds, not pounds and ounces.

What I'm unsure of is my math... our scale measures the peice in pounds + ounce, so leg could be 1lb and 5.8 ounces. The U cell tries to combine that for a total, to make it easer on the dashboard formula for the totals. I thought that my formulas and math was right until I looked at this calculator. Am I going about this wrong?

 

[Georgiboy]

Excel has its own convert method, not sure if that will help:

Book1
	A	B	C
1	Lb	Oz	Lb Decimal
2	1	10.8	1.675
Sheet1

Cell Formulas
Range	Formula
C2	C2	=CONVERT(B2,"ozm","lbm")+A2

 

[Outdoorsman80]

I didn't know that, I implemented the formula for one entry and it's the same math. It doesn't really help me with the question though for the totals if the numbers are accurate on the dash.

 

[Fluff]

What exactly do you think is wrong?

 

[Outdoorsman80]

I'm not sure if anything is wrong, I just came across that online calculator and am second guessing my self now.

 

[Fluff]

I can see nothing wrong with what you've done & have no idea what you keyed into that calculator to thing something is wrong.

 

[Outdoorsman80]

I think what is messing me up is that the calculator took 1lb 5.8oz and convert it to 1lb 5oz instead of converting it to just a pound figure such as 1.3625 pounds.

 

[Georgiboy]

Same here, was just looking and i can't see anything wrong.

Your dash has the same total as the table and the logic for producing the decimal pound in the table seems to be sound.

The calculator below might help more:
Pounds And Ounces Calculator

Although every part of me wanted to convert it to grams