Agreed, well done. Thanks again, David.
About the rounding: I think you were able to 'lose weight,' because grams are expressed in whole numbers; whereas, your oz and lbs were probably decimals, and were rounded off.
I believe rounding off numbers is an MS Excel default setting. To avoid it you can just use the Format->Cells command [or keyboard command: press the "control" key, then the number "1"]. Use the "General" setting, and all the precision will be preserved. This is the easiest way to 'lose weight' if you're not using grams.
Also, I thought I'd share a modification. I added some specific-item formulas to my spreadsheet that let me calculate the weight of those items that will vary in number or volume from trip to trip [e.g. tent stakes, TP allotment, alcohol fuel, food, etc.]. In practice, instead of marking a field with an 'x,' meaning 'yes, I will bring this item,' I mark it with a specific number, meaning 'I will bring *8* stakes' or 'I will bring *4* days of TP' or 'I will bring *3*oz of alcohol.'
So the formula for the particular item's cell ends up being a basic [8 * .226oz] or [4 * .2oz] or [3 * .82oz], and so on, rather than the "IF" formula. By indicating the quantity of an item that you might bring, instead of an x ["yes/no"], you can be a bit more precise, and fine tune for each trip without having to generate a new sheet or do too much re-weighing or re-calculating. Just another idea.
I hope this post is at least tending towards clarity; let me know if I've generated any confusion.