• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

calculation

stanley thomas

New Member
Can you please help me how to write the following equation in excel, apprecite your help

135 × min(SCr/κ, 1)α ×
max(SCr/κ, 1)-0.601 ×
min(Scys/0.8, 1)-0.375 ×
max(Scys/0.8, 1)-0.711 ×
0.995Age ×
0.969 [if female]


SCr (serum creatinine) = mg/dL
Scys (standardized serum cystatin C) = mg/l
κ = 0.7 (females) or 0.9 (males)
α = -0.248 (females) or -0.207 (males)
min(SCr/κ or 1) = indicates the minimum of SCr/κ or 1
max(SCr/κ or 1) = indicates the maximum of SCr/κ or 1
min(Scys/0.8, 1) = indicates the minimum of Scys/0.8, 1
max(Scys/0.8, 1) = indicates the maximum of Scys/0.8, 1
age = year
 
stanley thomas
Here two possible samples
... depends - what do You really would like to get?
=135*MIN(SCr/IF(female,0.7,0.9),1)*IF(female,-0.248,-0.207) * MAX(SCr/IF(female,0.7,0.9),1)-0.601 * MIN(Scys/0.8,1)-0.375 * MAX(Scys/0.8,1)-0.711 * 0.995*Age * IF(female,0.969,1)

=( 135*MIN(SCr/IF(female,0.7,0.9),1)*IF(female,-0.248,-0.207) ) * ( MAX(SCr/IF(female,0.7,0.9),1)-0.601 ) * ( MIN(Scys/0.8,1)-0.375 * MAX(Scys/0.8,1)-0.711 ) * 0.995*Age * IF(female,0.969,1)
 
Thank you all for your suggestion, attached excel, we calculate the kidney function separately for males and females (coefficients are not identical). The excel calculations are verified using the online calculator : https:/ /www.kidney.org/professionals/kdoqi/gfr_calculator

For some reason my excel calculations are matching with kidney.org

Attached an excel that we use , your help is greatly appreciated.

Have a good day.
Thanking you,
Stan
 

Attachments

  • cyst cal.xlsx
    10.9 KB · Views: 7
Last edited by a moderator:
stanley thomas
One reason of Your calculations ... is because Your (given/used) formula is different than in that page.
Do You have correct excepted values somewhere?
Check/compare this test ..
 

Attachments

  • cyst cal.xlsx
    11.2 KB · Views: 8
stanley thomas
Did You compare my sample with Your used?
I changed term black ... instead of female as well as Your original formula has 'minor' other differences (which could make huge difference with result).
You should verify that .. very carefully.
 
Back
Top