AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Excel 16.5312/20/2023 ![]() ![]() ![]() According to the results of arterial blood gas analysis, the type of acid-base imbalance of patients was judged by both artificial judgment (artificial group) and Excel spreadsheet automatic judgment (Excel spreadsheet group). A total of 96 patients admitted to the department of intensive care unit (ICU) of Xuzhou Central Hospital were enrolled. The results of arterial blood gas analysis were judged by using the editing formula of IF function in Excel 2003 spreadsheet. The four-step analysis was used to carry out programmatically through establishing acid-base balance disorder analysis process: (1) the acid and base types were determined according to pH value and the primary or main type of acid-base balance disorder was determined according to the pH value combined with blood carbon dioxide pressure (PaCO 2), HCO 3 - and their change rate (2) the expected compensation formula was selected to determine whether there was mixed acid-base imbalance, according to the primary or main acid-base imbalance type (3) the potential HCO 3 - should be calculated to replace the measured HCO 3 - when the primary acid-base imbalance was divided into two parts according to the prior two steps: respiratory acidosis or respiratory alkalosis accompanied with anion gap (AG) increased-metabolic acidosis and compared with the compensatory interval calculated by the predicted compensatory formula for acid or alkali to determine whether there were triple acid-base imbalance (TABD) (4) while the following two parts were judged: metabolic acidosis accompanied with AG increased-metabolic acidosis according to the prior two steps, ΔAG↑/ΔHCO 3 -↓ should be calculated to determine whether there was metabolic alkalosis or metabolic acidosis with normal AG. To judge the type of acid-base balance disorder automatically according to the results of arterial blood gas analysis by using the IF function editing formula in an Excel spreadsheet. ![]()
0 Comments
Read More
Leave a Reply. |