Establishment of Checking TPN Prescription Algorithm Based on Excel vba Technology
- VernacularTitle:基于Excelvba技术构建审核全肠外营养液处方的算法
- Author:
Yaqi WANG
1
;
Chengsen PANG
1
;
Ni MA
1
;
Yinli HE
1
;
Weihua DONG
1
Author Information
1. Dept. of Pharmacy，the First Affiliated Hospital of Xi’an Jiaotong Universit y，Xi’an 710061，China
- Publication Type:Journal Article
- Keywords:
Excel vba;
Algorithm;
Total parenteral mutrition;
Prescription checking;
Rational drug use
- From:
China Pharmacy
2019;30(1):130-135
- CountryChina
- Language:Chinese
-
Abstract:
OBJECTIVE： To improve the efficiency and accuracy of checking total parenteral mutrition （TPN） prescription. METHODS： Excel vba technology was used to edit vba code and construct TPN prescription algorithm. The key indicators and standard of TPN prescription checking were determined. Established algorithm was used to check the prescriptions from PIVAS of our hospital in May 2018， results of which was compared with the results of manual checking （using potassium concentration， monovalent cation concentration and alanyl-glutamine combined with amino acid as indexes）. RESULTS： TPN prescription algorithm was established through confirming 17 key indicators as glycolipid ratio， heat-nitrogen ratio， monovalent cation concentration， the checking standard was set as. It took 15 seconds to check 2 638 TPN prescriptions received within one month in PIVAS of our hospital； 449 irrational prescriptions （excessive dose， incompatibility， inappropriate proportion and volume of nutrition） of them and reasons had been marked out. By comparing 3 evaluation indexes， 1， 1， 0 irrational prescriptions were checked by manually and 4， 12， 4 checked by established algorithm， respectively. CONCLUSIONS： TPN prescription algorithm can check prescription in batches based on Excel vba technology， and mark out the substandard prescription automatically. Hereby， it improves the efficiency and accuracy of TPN prescriptions by PIVAS.
