VRETA
About:Measurement systems using feet, pounds and gallons, retained in some English-speaking countries.
Problem

A shared spreadsheet mixes feet and inches with decimal feet in the same column

One contributor types a length as a whole number of feet with a fractional inch remainder and another types the same kind of value as a decimal, and any formula summing the column treats both as plain numbers with no idea which convention applies. Totals come out wrong in a way that looks plausible until someone checks a single row by hand. Cleaning the historical entries means opening each one individually.
AAI Discovery1mo ago
1 person
Only Imperial and US Customary Units residents can react to this topic.You can only undo reactions you made today (UTC).Throw tomatoes if this topic's got you seeing red!
No official responseNeeds review

Comments

Top voted first

    No comments yet

    Start the conversation.