Formula for "score" plus a range

[Kim1968]

Hello,
I am recreating a calculator/table in Excel. There are 6 categories 2, 3, or 4 elements in each category. You choose the element in each category and it is assigned a score (both negative and positive). There is a total score and then a range. If I do a standard SUM then it will be incorrect. The highest score is 14 and the lowest is 0. If done correctly the risk score for this patient should be 4. Below is my spreadsheet and the link is the actual calculator that you can use, from the internet. What formula are the using to calculate the score?

REVEAL Lite 2 Risk Score Calculator

Use the REVEAL Lite 2 Risk Score Calculator to quickly calculate your patient’s risk score and to help determine whether treatment escalation may be needed to reach low risk.

pahriskcalculatorlt.com

Thanks!
Kim

REVEAL LITE 2 RISK CALCULATOR	SCORE
BNP (pg/ml)	< 50	50 to < 200	200 to < 800	≥ 800
	-2	0	1	2	-2
NT-proBNP (pg/ml)	< 300	300 to < 1100	≥ 1100
	-2	0	2
6MWT (m)	≥ 440	320 to 440	<320 to 165	< 165
	-2	-1	0	1	0
NYHA/WHO Functional Class	I	II	III	IV
	-1	0	1	2	0
Systolic BP		SBP ≥ 110	SBP ≤ 110
		0	1		0
Heart Rate		HR ≤ 96	HR > 96
		0	1		0
eGFR < 60ml/min/1.73m2 or renal insufficiency		No	Yes
		0	1		0
				RISK SCORE
RISK SCORE	Low Risk	Intermediate Risk	High Risk
	≤ 5	6-7	≥ 8

 

[6StringJazzer]

The calculator is taking the sum of the score for each category then adding 6 to that sum to get the total risk score. It even shows you that it is doing that.

In your example the total is -2.

-2 + 6 = 4

 

[Kim1968]

Thank you. I wasn't sure why it was adding 6 to the score and if it was that easy! I will re-read the method/research.

Thank you!
Kim

 

[6StringJazzer]

I am guessing that they add 6 because the lowest possible total score is -5 and they want the result to be a positive number. So the in the lowest-risk case the result is 1.