Couldn't attach spreadsheet (or any file for that matter) but here is how I did it in one simple line.
View attachment 48157
I know condensing isn't top of your list at the moment but thought I'd post the following.
I first of all carried out a quick test on own 20kw oil fired system, I set the boiler to give a average flow temp of 65C. I then opened all the TRVs fully and rather than spending hours trying to get a deltaT of 20C across every rad I simply throttled in a (one) valve on the main return before the pump and fairly quickly got 20C deltaT, (65C/45C), I then reopened the valve fully again once I was happy that I could achieve this without any problem.
With this in mind, I then did a few calculations based on a total rad output of 20kw with two zones (not HW) opened and with one zone only with a output of 10kw.
20kw rated output gives a actual output of 12.6kw with flow/return of 65/45C and a flow of 0.54m3/hr.
10kw rated output (one zone) gives a actual output of 7.3kw with flow/return of 65/53.5C at the same flowrate.
This is the basic problem with the above fixed parameters, once you switch down to one zone then no more condensing, like in your case.
The choices then are, 1, live with it. 2. use TRVs which will give condensing most/all of the time. 3. reduce the flow temp when on one zone (or both).
For example, with two zones if you reduced the flow temp to 55C with both zones (but original flow of 0.54m3/hr) output 9.3kw, flow/return of 55/40C, reduce further to 45C, output 6.1kw, flow/return of 45/35.3C.
One (10kw) zone, reduce flow temp to 60C, output 6.3kw, flow/return 60/50C (just condensing)
reduce flow temp to 55C, output 5.3kw, flow/return 55/46.5C.
reduce flow temp to 45C, output 3.5kw, flow/return 45/39.5C.
All calcs carried out with room temp of 20C.