Enter one foot of pipe as 0.1 of a stick
Materials that come in lengths have to be attached as the fraction you actually use, or every estimate bills the whole thing.
Pipe comes in ten-foot sticks. Wire comes on rolls. Fittings come in boxes. Your supplier prices them that way, so that is how they land in the book, and a quantity of 1 means the whole stick.
Three feet of that stick is 0.3. One foot is 0.1. Half a box of fittings is 0.5.
The quantity field is a fraction of a purchase unit, not a count of what you carried into the house.
Do it wrong and nothing warns you. The estimate builds, the margin looks generous, and the number carries seven feet of pipe that stayed on the truck.
Two things before you start. Round up where waste is real, because you do cut and throw away, and 0.3 on a three-foot run is honest while 0.25 is optimistic. And check what your markup brackets are doing, because a bracket applied to an eight-hundred-dollar stick behaves very differently from the same bracket applied to eighty dollars of it, and the two answers land a long way apart.
Sort your material list by unit of measure, find everything sold by the stick, roll, box or case, and check the quantity on each service that uses it.
The notebook is where this turned up. If you want it fixed rather than described, that is how material linking actually works, over at Titan Tech Tools.
One question a week.
Two minutes, one problem, something to do about it. No pitch.