This macro-enabled Excel workbook shows the calculation of a heat transfer coefficient for forced convection in rough pipes using the analogy between momentum and heat transfer. The Colebrook equation is used for the frictional pressure drop in non-smooth pipes and the Gnielinski correlation is used for the convection coefficient. Inputs are the Reynolds number and relative roughness (ε/D) of the pipe. The Colebrook equation is implicit in friction factor and thus Excel’s solver routine is implemented. With the friction factor thus available, the Gnielinski correlation is used to find the corresponding Nusselt number (=hD/k).