Bingo.
no less than 6 pages of excel!!! (more work than I bargained for)
usual disclaimer - GIGO (+fair chance of rounding errors, etc)
Not to mention the involuntary inclusion of pipe losses and rad losses, however I think this is a pretty good illustration of Cathars idea