文献速递消化、代谢与肾脏急症重症综合管理与镇静镇痛

Excel表格结合血气分析自动判断酸碱平衡紊乱类型的临床应用

[Clinical application of Excel spreadsheet with blood gas analysis in automatic judging the type of acid-base balance disorder].
PubMed 文献 · Zhonghua Wei Zhong Bing Ji Jiu Yi Xue · 2020-01-01
一句话结论在ICU患者中,Excel表格自动判断酸碱失衡类型的准确性与人工判断无显著差异,但耗时显著更短。

该研究利用Excel 2003的IF函数编辑公式,按四步分析法建立酸碱失衡自动判断流程,纳入徐州中心医院ICU的96例患者,比较人工判断与Excel表格自动判断酸碱失衡类型的结果及耗时。结果显示,Excel表格组在正常及单纯型、混合型、三重酸碱失衡中的准确率分别为100%、100%、100%,人工组分别为100%、96.08%、89.47%,组间差异均无统计学意义(均P>0.05);但Excel表格组判断耗时显著短于人工组(均P<0.01)。结论认为Excel表格自动判断血气分析酸碱失衡类型快速且准确。

要点

  • 在96例ICU患者中,Excel表格自动判断正常及单纯型酸碱失衡的准确率为100%(26/26),与人工判断100%(26/26)无显著差异(P>0.05)。
  • Excel表格自动判断混合型酸碱失衡的准确率为100%(51/51),人工判断为96.08%(49/51),差异无统计学意义(P>0.05)。
  • Excel表格自动判断三重酸碱失衡的准确率为100%(19/19),人工判断为89.47%(17/19),差异无统计学意义(P>0.05)。
  • Excel表格组判断耗时显著短于人工组:正常及单纯型31.13±4.70秒 vs 74.20±16.53秒,混合型31.59±5.49秒 vs 138.10±22.26秒,三重酸碱失衡30.98±5.40秒 vs 308.40±78.12秒(均P<0.01)。
  • Excel表格采用四步分析法,输入pH、PaCO2、实际HCO3-、Na+、Cl-及限定代偿时间等参数,可自动判断42种酸碱失衡类型。

适用人群与场景

  • 纳入徐州中心医院ICU收治的96例患者,根据动脉血气分析结果判断酸碱失衡类型。

诊断标准与关键阈值

  • 四步分析法:第一步根据pH值确定酸或碱类型,并结合PaCO2、HCO3-及其变化率确定原发或主要酸碱失衡类型;第二步根据原发或主要酸碱失衡类型选择预计代偿公式判断是否存在混合性酸碱失衡;第三步当原发酸碱失衡为呼吸性酸中毒或呼吸性碱中毒伴阴离子间隙(AG)增高的代谢性酸中毒时,计算潜在HCO3-替代实测HCO3-,与预计代偿公式计算的代偿区间比较,判断是否存在三重酸碱失衡(TABD);第四步当前两步判断为代谢性酸中毒伴AG增高型代谢性酸中毒时,计算ΔAG↑/ΔHCO3-↓,判断是否合并代谢性碱中毒或AG正常型代谢性酸中毒。

研究设计与关键结果

  • 研究类型为在ICU患者中比较人工判断与Excel表格自动判断酸碱失衡类型的准确性和耗时。
  • 共纳入96例患者,Excel表格组由一名NICU主治医师输入数据、另一名核对;人工组由2名NICU副主任医师和1名呼吸科主治医师判断,结果不一致时讨论决定。
  • 正常及单纯型酸碱失衡准确率:Excel表格组100%(26/26) vs 人工组100%(26/26),P>0.05。
  • 混合型酸碱失衡准确率:Excel表格组100%(51/51) vs 人工组96.08%(49/51),P>0.05。
  • 三重酸碱失衡准确率:Excel表格组100%(19/19) vs 人工组89.47%(17/19),P>0.05。
  • 判断耗时(秒):正常及单纯型Excel表格组31.13±4.70 vs 人工组74.20±16.53;混合型31.59±5.49 vs 138.10±22.26;三重酸碱失衡30.98±5.40 vs 308.40±78.12,均P<0.01。

证据类型、等级与局限

  • 证据类型为在ICU患者中开展的比较性研究,原文未报告证据等级或推荐强度。
  • 局限:原文未报告局限性。

对床旁实践的改变

  • 作者认为,Excel表格自动判断血气分析酸碱失衡类型可快速且准确地确定动脉血气分析中的酸碱失衡类型。
  • 在纳入的96例ICU患者中,Excel表格自动判断与人工判断的准确率无显著差异,但判断耗时显著缩短。

提炼说明

  • 本条依据论文摘要整理;摘要未涉及「处置流程与药物剂量」「红旗征与不能漏的情况」「指南或共识出处」,故未列出这些栏目;全文请点「阅读原文」。
英文原文(摘要)· 点击展开

OBJECTIVE: 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.

METHODS: 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 (PaCO2), HCO3- 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 HCO3- should be calculated to replace the measured HCO3- 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↑/ΔHCO3-↓ should be calculated to determine whether there was metabolic alkalosis or metabolic acidosis with normal AG. The results of arterial blood gas analysis were judged by using the editing formula of IF function in Excel 2003 spreadsheet. A total of 96 patients admitted to the department of intensive care unit (ICU) of Xuzhou Central Hospital were enrolled. 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). The artificial group was composed by 2 associate chief physicians from neonatal intensive care unit (NICU) and 1 attending respiratory physician. If the results were inconsistent, the decision should be made after discussion. In the Excel spreadsheet group, data were input by one NICU attending physician and checked by another. The differences in the results and the time spent in judging the type of acid-base imbalance between the two groups were compared.

RESULTS: Forty-two types of acid-base imbalance were obtained by using the four-step analysis method and inputting relevant parameters such as pH, PaCO2, actual HCO3-, Na+, Cl- and compensation time limited into the Excel spreadsheet for blood gas analysis. Data analyses of 96 patients showed that the accuracy of using Excel spreadsheets to automatically determine the type of acid-base imbalance was higher than artificial group, but there was no statistically significant difference between the two groups [normal and simple acid-base imbalance: 100% (26/26) vs. 100% (26/26), mixed acid-base imbalance: 100% (51/51) vs. 96.08% (49/51), TABD: 100% (19/19) vs. 89.47% (17/19), all P > 0.05], and it took less time to judge the results of blood gas analysis by the Excel spreadsheet group compared with the artificial group (s: normal and simple acid-base imbalance: 31.13±4.70 vs. 74.20±16.53, mixed acid-base imbalance: 31.59±5.49 vs. 138.10±22.26, TABD: 30.98±5.40 vs. 308.40±78.12, all P < 0.01).

CONCLUSIONS: The automatic judging Excel spreadsheet with blood gas analysis can quickly and accurately determine the type of acid-base imbalance in arterial blood gas analysis.

来源:Zhonghua Wei Zhong Bing Ji Jiu Yi Xue,查看原文。版权归原作者所有。

参考来源

  1. Zhai J, Wu Z, Wu J, et al. [Clinical application of Excel spreadsheet with blood gas analysis in automatic judging the type of acid-base balance disorder]. Zhonghua Wei Zhong Bing Ji Jiu Yi Xue. 2020. PMID: 32912413. doi:10.3760/cma.j.cn121430-20200217-00186

供执业医师抢救与诊疗参考,不替代临床判断;剂量请结合体重、肝肾功能和本院药品规格复核,以指南原文为准。