Hello, I work in a hospital and I have an Excel spreadsheet created for insulin drip calculations. I am a novice with Alpha 5 yet and I am having trouble converting the Excel calculations to work in Alpha. I will include what I have so far:
Spreadsheet example:
Accu- Glucose Basal Basal Proport. Tot Action
Check Rate Rate
Sequ. #
1 490 0 0 9.75 8.0
2 400 0.3 0.3 7.5 7.8
3 300 0.5 0.5 5 5.5
4 248 0.7 0.7 3.7 4.4
5 95 0.5 0.5 -0.125 0.4
6 110 0.5 0.5 0.25 0.8
7 80 0.2 0.2 -0.5 0.0
8 60 -0.8 0 -1 0.0 give 1amp D50
9 100 0 0 0 0.0
10 105 0 0 0.125 0.1
11 140 0.1 0.1 1 1.1
12 0.1 0.1 0 0.1
13 0.1 0.1 0 0.1
14 0.1 0.1 0 0.1
15 0.1 0.1 0 0.1
16 0.1 0.1 0 0.1
Etc.
All values are calculated off what the nurse types in the glucose column. Rows 12 and on have no data typed in therefore the values that you see.
Now for the formulas that make the spread sheet work:
Proportional Rate = IF(B2>0,0.025*(B2-100),0)
Total Rate = IF(D2+E2>8,8,IF(D2+E20,IF(B3>349,D2+0.3,
IF(B3>199,D2+0.2,
IF(B3>129,D2+0.1,
IF(B3>99,D2,
IF(B3>89,D2-0.2,
IF(B3>79,D2-0.3,
IF(B3>68,D2-0.5,C2-1))))))),D2)
Basal 2 = IF(C20,0.025*(GLUCOSE-100),0)
Total Rate = IF(BASAL2+RATE>8,8,IF
(BASAL2+RATE0,IF(GLUCOSE>349,BASAL2+0.3,IF(GLUCOSE>199,BASAL2+0.2,
IF(GLUCOSE>129,BASAL2+0.1,IF(GLUCOSE>99,BASAL2,IF(GLUCOSE>89,BASAL2-0.2,
IF(GLUCOSE>79,BASAL2-0.3,IF(GLUCOSE>68,BASAL2-0.5,BASAL-1))))))),BASAL2))
I know this looks very complicated but if someone can print it off and look at it I'd appreciate it.
I added the first part of this last formula recently to try and make it work: IF(GLUC_ID=0,0 but it still does not function.
Thank you.
Bill
Spreadsheet example:
Accu- Glucose Basal Basal Proport. Tot Action
Check Rate Rate
Sequ. #
1 490 0 0 9.75 8.0
2 400 0.3 0.3 7.5 7.8
3 300 0.5 0.5 5 5.5
4 248 0.7 0.7 3.7 4.4
5 95 0.5 0.5 -0.125 0.4
6 110 0.5 0.5 0.25 0.8
7 80 0.2 0.2 -0.5 0.0
8 60 -0.8 0 -1 0.0 give 1amp D50
9 100 0 0 0 0.0
10 105 0 0 0.125 0.1
11 140 0.1 0.1 1 1.1
12 0.1 0.1 0 0.1
13 0.1 0.1 0 0.1
14 0.1 0.1 0 0.1
15 0.1 0.1 0 0.1
16 0.1 0.1 0 0.1
Etc.
All values are calculated off what the nurse types in the glucose column. Rows 12 and on have no data typed in therefore the values that you see.
Now for the formulas that make the spread sheet work:
Proportional Rate = IF(B2>0,0.025*(B2-100),0)
Total Rate = IF(D2+E2>8,8,IF(D2+E20,IF(B3>349,D2+0.3,
IF(B3>199,D2+0.2,
IF(B3>129,D2+0.1,
IF(B3>99,D2,
IF(B3>89,D2-0.2,
IF(B3>79,D2-0.3,
IF(B3>68,D2-0.5,C2-1))))))),D2)
Basal 2 = IF(C20,0.025*(GLUCOSE-100),0)
Total Rate = IF(BASAL2+RATE>8,8,IF
(BASAL2+RATE0,IF(GLUCOSE>349,BASAL2+0.3,IF(GLUCOSE>199,BASAL2+0.2,
IF(GLUCOSE>129,BASAL2+0.1,IF(GLUCOSE>99,BASAL2,IF(GLUCOSE>89,BASAL2-0.2,
IF(GLUCOSE>79,BASAL2-0.3,IF(GLUCOSE>68,BASAL2-0.5,BASAL-1))))))),BASAL2))
I know this looks very complicated but if someone can print it off and look at it I'd appreciate it.
I added the first part of this last formula recently to try and make it work: IF(GLUC_ID=0,0 but it still does not function.
Thank you.
Bill
Comment