Trefor Roscoe <mailto:[log in to unmask]> wrote:
> This is the function off the spreadsheet that calculates how many
> points you have for a given percentage in a particular group.
>
>
> =IF(F14<>"",((MAX(MIN(F14,D14),C14)-C14)/(D14-C14)*B14),0)
>
> Where B = number of points avaialble
> C = minimum threshold
> D = maximum target
> F = actual percentage achieved.
>
> Any Excel whiz kids out there who can tell me if this is a linear
> function or if there are more points to be got for the last few
> patients in any one area. I think it is linear.
>
>
> Dr Trefor Roscoe
> GP IT Consultant
> 07771 982 670
>
> Please copy your reply to [log in to unmask] for a faster
> response
Linear, however doesn't matter since value of points = square root(practice
prev squared/national prev squared) which in effect makes it non linear.
My interpretation is to go for moderate numbers reasonably well managed.
--
Tim Walter
http://www.falklandsurgery.co.uk
|