It appears I was wrong - this is a familiar feeling now
The actual Head in the index circuit is 4.55m @ 11 degrees drop. The reason why I got it wrong was forgetting that the full section mass flow only travels in the 22mm pipe and not the 15mm spur to each emitter.
Now it's correct, it calculates the mass for the rad against the short 15mm spurs and fittings. Then also calculates the sum of the mass flow for the whole section at each T off, againsts the 22mm pipe size fitted + fittings.
Even so 4.55m is still alot at 4l/s. (The UPS 25-80 looks like it would do it, if I need to get one large pump.)
I have wrestled all day to get excel to do a lookup against the mass flow index table and have finally sussed it.
In case anyone else decides they need to perform this hideous operation the formula is below.
=INDEX('Lookup Table'!$A$6:$C$28,MATCH(C27,'Lookup Table'!$A$6:$A$28,-1),2)
Explanation::
Input the table two from "Copper Tubes in Domestic Heating Systems" onto an excel tab called "Lookup Table". This is the important bit - upside down. Start with the large numbers at the top and work down the page to the smaller numbers in the table.
The formula does the following: Takes all the values found at 'Lookup Table'!$A$6:$C$28 The $ means the reference won't change when you copy the cell. So in effect; find from these range of cells A6:C28. MATCH means take this value and find it = C27 in my case. This contains the mass flow index that you are interested in. The bit after the next , says find the mass flow index in the range A6:A28 on the lookup table. This is where you have put the Flow Rate in Kg/s numbers. The next thing is important. -1 says where no exact match is found return the next highest number. So in other words give me a slightly higher resistance. The final figure is which column to return the relative value from. So 2 means in my case, return the value from the second column. This is where I placed the 15mm pipe resistances. 3 would mean from the 22mm pipe column and so on for other pipe sizes and resistances.
What this allows me to do is vary the temperature drop across all the emitters and see the effect on the total head of the system all by changing one number. This is possible because the mass flow index is calculated using the formula (rad watts/1000)/(B8*B5) Where B8 = 4.18 and B5 = the required temperature drop.
All this is leading up to saying because the house only needs 11kw and the emitters deliver 17kw I could run the rads with a 16 degree drop and they will still deliver enough heat. I can then from my calculations see that if I set the ABV to 1.24m it will provide the required pressure in the rad circuit, leaving the rest to head back to the boiler and keep it running at the correct flow rate and temperature drop.
This will reduce the system head to 4.01m which is only just outside the capacity of a 30/60 unit @ 4ls with no other changes required.
So transam - you were right!
Anyone got any advice on pumping options? Two pumps in series? Or one large one?