[Application of VBA programming to achieve high quality critical illness score]

To establish a high-quality critical illness scoring program by VBA programming.

The acute physiology and chronic health evaluatin II (APACHE II), Logistic organ dysfunction score (LODS) and sequential organ failure assessment (SOFA) were combined into a program with visual basic for applications (VBA) of Microsoft Excel. Taking the case data published in the literature as an example, the program was applied to SOFA score. First, directly copied the patient's data, such as age, body weight, body temperature, pulse, blood pressure, blood routine, blood biochemistry, blood gas analysis, etc. Then, returned to the program, clicked the "paste data" button, and the data would be automatically filled in, and selected the worst option. Then, the usage of norepinephrine, mechanical ventilation, Glasgow coma scale (GCS) score and 24-hour urine volume were input according to the situation. Finally, clicked the "score" button to get SOFA score.

Pasted the data directly into the critical illness scoring program and checked it accordingly. The total time from data input to abtaining scoring result was less than 2 minutes; and the repeatability was strong.

The application of VBA self-programming can quickly and accurately perform critical illness scoring.