Well, for starters 40ft + 5(6.4ft) + 2.5ft is actually 74.5 ft, not 65.5 -- but that's not all.
There also seems to be something going on with the "conversion" from K to L_eq. For example, according to your data, the elbows have an equivalent length L_eq = 6.4 feet, and a loss coefficient K...