CN105808898A - 新生儿静脉营养速算器 - Google Patents

新生儿静脉营养速算器 Download PDF

Info

Publication number
CN105808898A
CN105808898A CN201410825265.5A CN201410825265A CN105808898A CN 105808898 A CN105808898 A CN 105808898A CN 201410825265 A CN201410825265 A CN 201410825265A CN 105808898 A CN105808898 A CN 105808898A
Authority
CN
China
Prior art keywords
cell
mid
value
round
vlookup
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN201410825265.5A
Other languages
English (en)
Inventor
马鸿雁
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Individual
Original Assignee
Individual
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Individual filed Critical Individual
Priority to CN201410825265.5A priority Critical patent/CN105808898A/zh
Publication of CN105808898A publication Critical patent/CN105808898A/zh
Pending legal-status Critical Current

Links

Landscapes

  • Cosmetics (AREA)

Abstract

为解决医院新生儿科医师在日常工作中手工计算新生儿静脉营养的繁琐，本发明为一种计算新生儿静脉营养的速算器，是以Excel表格为载体，可以计算出新生儿的静脉营养常用成份(葡萄糖、小儿复方氨基酸、脂肪乳、10%氯化钠、氯化钾、水溶性维生素、脂溶性维生素、甘油磷酸钠、肝素)的数值，并且既准确又快速，希望它能对新生儿科医师的工作有所帮助。

Description

新生儿静脉营养速算器
技术领域
本发明旨在解决医院新生儿科医师在日常工作中手工计算新生儿静脉营养的难题。
背景技术
作为新生儿科医师，几乎每天都要手工计算静脉营养，甚至每天计算很多次，算好以后还要反过来再计算各种成份是否符合标准，非常繁琐，占用医生的大量时间，还担心会出错。到目前为止，尚无更好的解决方案。
发明内容
为解决医院新生儿科医师在日常工作中手工计算新生儿静脉营养的繁琐，本发明为一种计算新生儿静脉营养的速算器，是以Excel表格为载体，可以计算出新生儿的静脉营养常用成份(葡萄糖、小儿复方氨基酸、脂肪乳、10%氯化钠、氯化钾、水溶性维生素、脂溶性维生素、甘油磷酸钠、肝素)的数值，并且既准确又快速，希望它能对新生儿科医师的工作有所帮助。
附图说明
附图1为新生儿静脉营养速算器的操作界面。
其中单元格D6、D10、D12、D16、D18、D24、D26、D28、D32为可输入单元格。
单元格D8、B12、B14、G12、I12、D20、D22、N8、N10、N12、N14为可选择单元格，可以在单元格D8内选择输注方式为外周静脉或中心静脉；在单元格B12和B14内选择奶的品种为足月儿奶、早产儿奶、母乳、母乳+母乳强化剂（HMF）、蔼尔舒、纽太特、纽康特、PDF奶；在单元格G12内选择喂奶间隔时间为q1h、q2h、q3h、q4h、q6h；在单元格I12内选择喂奶次数为×2、×4、×6、×8、×10；在单元格D20内选择氨基酸克数为0、1、1.5、2、2.5、3、3.5、4；在单元格D22内选择脂肪乳克数为0、0.5、1、1.5、2、2.5、3；在单元格N8内选择葡萄糖的百分比浓度为25、50；单元格N10内选择葡萄糖的百分比浓度为5、10；在单元格N12和N14内选择有、无。
单元格S8、S10、S12、S14、S16、S18、S20、S22、S24、S26、S28、S30为计算结果。其中单元格S8=ROUND((((D10*D16-D18-D12*24/(VALUE(MID(G12,2,1))))*(6*D10*D32)/((D10*D16-D18-D12*24/(VALUE(MID(G12,2,1))))/D28)-((D10*D16-D18-D12*24/(VALUE(MID(G12,2,1))))-(SUM(S12:S28)))*N10)/(N8-N10)),1)；单元格S10＝ROUND((D10*D16-D18-D12*24/(VALUE(MID(G12,2,1)))-(SUM(S12:S28))-S8),1)；
单元格S12=IF(N12="无","",ROUNDDOWN(D10,1))；单元格S14=IF(N14="无","",IF(D10>=1.5,D10*0.4,1))；单元格S16=IF(D20=0,"",ROUNDDOWN(IF(D8="中心静脉",D20*D10*100/N16,IF(D20*D10*100/N16>((D10*D16-D18-D12*24/(VALUE(MID(G12,2,1))))*3/N16),((D10*D16-D18-D12*24/(VALUE(MID(G12,2,1))))*3/N16),D20*D10*100/N16)),1))；单元格S18=IF(D22=0,"",ROUNDDOWN(D22*D10*100/N18,1))；单元格S20=IF(D24=0,"",ROUNDDOWN(IF(D8="中心静脉",D10*D24*0.585,IF((D10*D24*0.585)>((D10*D16-D18-D12*24/(VALUE(MID(G12,2,1))))/30),((D10*D16-D18-D12*24/(VALUE(MID(G12,2,1))))/30),(D10*D24*0.585))),1))；单元格S22=IF(D26=0,"",ROUNDDOWN(IF(((D10*D16-D18-D12*24/(VALUE(MID(G12,2,1))))*0.003*N22)>(D10*D26*0.75),(D10*D26*0.75),((D10*D16-D18-D12*24/(VALUE(MID(G12,2,1))))*0.003*N22)),1))；单元格S24=IF(D8="中心静脉",D10*2,"")；单元格S26=IF(D8="中心静脉",D10*0.4"")；单元格S28=IF(D8="中心静脉",D10*0.1,"")；单元格S30=IF(AND(D8="中心静脉",((D10*D16-D18-D12*24/(VALUE(MID(G12,2,1))))/D28)<=2),IF((D10*D16-D18-D12*24/(VALUE(MID(G12,2,1))))>D10*20,D10*20,(D10*D16-D18-D12*24/(VALUE(MID(G12,2,1))))),"")。
　　　单元格D14、G14、I14、D30、W8、W10、W12、W14、W16、W18、W20、W22、W24、W26、W28、W32为注意事项。
单元格D14=IF(OR(I12="",B14=""),"",IF(D12="","",D12))；单元格G14=IF(OR(I12="",B14=""),"",G12)；单元格I14=IF(OR(I12="",B14=""),"",(24/MID(G12,2,1)-MID(I12,2,2)))；单元格D30＝=ROUND((D10*D16-D18-D12*24/(VALUE(MID(G12,2,1))))/D28,1)；单元格W8=(S8*N8*0.04+S10*N10*0.04)/(S8*N8*0.04+S10*N10*0.04+IF(S16="",0,S16)*N16*0.04+IF(S18="",0,S18)*N18*0.09)；单元格W10=(IF(S16="",0,S16)*N16*0.04)/(S8*N8*0.04+S10*N10*0.04+IF(S16="",0,S16)*N16*0.04+IF(S18="",0,S18)*N18*0.09)；单元格W12=(IF(S18="",0,S18)*N18*0.09)/(S8*N8*0.04+S10*N10*0.04+IF(S16="",0,S16)*N16*0.04+IF(S18="",0,S18)*N18*0.09)；单元格W14=ROUND(IF(OR(I12="",B14=""),IF(D12="",0,IF(ISERROR(VLOOKUP(B12,Z41:AB54,2,FALSE)),"",VLOOKUP(B12,Z41:AB54,2,FALSE)))*D12*0.24/((VALUE(MID(G12,2,1)))),IF(D12="",0,(VLOOKUP(B12,Z41:AB54,2,FALSE)*D12*0.01*(IF(I12="",0,VALUE(MID(I12,2,2))))))+IF(B14="",0,VLOOKUP(B14,Z41:AB54,2,FALSE))*D12*0.01*IF(OR(I12="",B14=""),0,(24/MID(G12,2,1)-MID(I12,2,2)))),1)；单元格W16=ROUND((S8*N8*0.04+S10*N10*0.04+IF(S16="",0,S16)*N16*0.04+IF(S18="",0,S18)*N18*0.09),1)；单元格W18=ROUND((IF(OR(I12="",B14=""),IF(D12="",0,IF(ISERROR(VLOOKUP(B12,Z41:AB54,2,FALSE)),"",VLOOKUP(B12,Z41:AB54,2,FALSE)))*D12*0.24/((VALUE(MID(G12,2,1)))),IF(D12="",0,(VLOOKUP(B12,Z41:AB54,2,FALSE)*D12*0.01*(IF(I12="",0,VALUE(MID(I12,2,2))))))+IF(B14="",0,VLOOKUP(B14,Z41:AB54,2,FALSE))*D12*0.01*IF(OR(I12="",B14=""),0,(24/MID(G12,2,1)-MID(I12,2,2))))+(S8*N8*0.04+S10*N10*0.04+IF(S16="",0,S16)*N16*0.04+IF(S18="",0,S18)*N18*0.09))/D10,1)；单元格W20=ROUND((N8*S8*0.05+S10*N10*0.05+IF(S16="",0,S16)*0.6+IF(S18="",0,S18)*0.3+IF(S20="",0,S20)*3.4+IF(S22="",0,S22)*4+IF(S24="",0,S24)*0.308)*1000/(D16*D10-D18-D12*24/(VALUE(MID(G12,2,1)))),1)；单元格W22=ROUND((6*D10*D32)/((D10*D16-D18-D12*24/(VALUE(MID(G12,2,1))))/D28),1)；单元格W24=IF(S20="",0,S20*N20/(D10*D16-D18-D12*24/(VALUE(MID(G12,2,1)))))；单元格W26=ROUND((IF(S16="",0,S16)*N16)/(100*D10),1)；单元格W28=ROUND((IF(S18="",0,S18)*N18)/(100*D10),1)；单元格W32=D10*D16-D18-D12*24/(VALUE(MID(G12,2,1)))。
附图2为新生儿常用奶及能量。
具体实施方式
首先按照患者实际情况在单元格D6、D10、D12、D16、D18、D24、D26、D28、D32内输入相应的值，然后在单元格D8、B12、B14、G12、I12、D20、D22、N8、N10、N12、N14内选择相应的值，检查单元格W8、W10、W12、W14、W16、W18、W20、W22、W24、W26、W28、W32内的值有无不当，最后把单元格S8、S10、S12、S14、S16、S18、S20、S22、S24、S26、S28、S30内相应的值转抄至医嘱单。

Claims (4)

1.一种计算新生儿静脉营养的速算器，是以Excel表格为载体，可以计算新生儿静脉营养的常用成份(葡萄糖、6%小儿复方氨基酸、20%脂肪乳、10%氯化钠、10%氯化钾、水溶性维生素、脂溶性维生素、甘油磷酸钠、肝素)的数值。
2.根据权利要求1所述的速算器，其中单元格D8、B12、B14、G12、I12、D20、D22、N8、N10、N12、N14为可选择单元格，可以在单元格D8内选择输注方式为外周静脉或中心静脉；在单元格B12和B14内选择奶的品种为足月儿奶、早产儿奶、母乳、母乳+母乳强化剂（HMF）、蔼尔舒、纽太特、纽康特、PDF奶；在单元格G12内选择喂奶间隔时间为q1h、q2h、q3h、q4h、q6h；在单元格I12内选择喂奶次数为×2、×4、×6、×8、×10；在单元格D20内选择氨基酸克数为0、1、1.5、2、2.5、3、3.5、4；在单元格D22内选择脂肪乳克数为0、0.5、1、1.5、2、2.5、3；在单元格N8内选择葡萄糖的百分比浓度为25、50；单元格N10内选择葡萄糖的百分比浓度为5、10；在单元格N12和N14内选择有、无。
3.根据权利要求1所述的速算器，其中单元格S8、S10、S12、S14、S16、S18、S20、S22、S24、S26、S28、S30为计算结果，单元格S8=ROUND((((D10*D16-D18-D12*24/(VALUE(MID(G12,2,1))))*(6*D10*D32)/((D10*D16-D18-D12*24/(VALUE(MID(G12,2,1))))/D28)-((D10*D16-D18-D12*24/(VALUE(MID(G12,2,1))))-(SUM(S12:S28)))*N10)/(N8-N10)),1)；单元格S10＝ROUND((D10*D16-D18-D12*24/(VALUE(MID(G12,2,1)))-(SUM(S12:S28))-S8),1)；
单元格S12=IF(N12="无","",ROUNDDOWN(D10,1))；单元格S14=IF(N14="无","",IF(D10>=1.5,D10*0.4,1))；单元格S16=IF(D20=0,"",ROUNDDOWN(IF(D8="中心静脉",D20*D10*100/N16,IF(D20*D10*100/N16>((D10*D16-D18-D12*24/(VALUE(MID(G12,2,1))))*3/N16),((D10*D16-D18-D12*24/(VALUE(MID(G12,2,1))))*3/N16),D20*D10*100/N16)),1))；单元格S18=IF(D22=0,"",ROUNDDOWN(D22*D10*100/N18,1))；单元格S20=IF(D24=0,"",ROUNDDOWN(IF(D8="中心静脉",D10*D24*0.585,IF((D10*D24*0.585)>((D10*D16-D18-D12*24/(VALUE(MID(G12,2,1))))/30),((D10*D16-D18-D12*24/(VALUE(MID(G12,2,1))))/30),(D10*D24*0.585))),1))；单元格S22=IF(D26=0,"",ROUNDDOWN(IF(((D10*D16-D18-D12*24/(VALUE(MID(G12,2,1))))*0.003*N22)>(D10*D26*0.75),(D10*D26*0.75),((D10*D16-D18-D12*24/(VALUE(MID(G12,2,1))))*0.003*N22)),1))；单元格S24=IF(D8="中心静脉",D10*2,"")；单元格S26=IF(D8="中心静脉",D10*0.4"")；单元格S28=IF(D8="中心静脉",D10*0.1,"")；单元格S30=IF(AND(D8="中心静脉",((D10*D16-D18-D12*24/(VALUE(MID(G12,2,1))))/D28)<=2),IF((D10*D16-D18-D12*24/(VALUE(MID(G12,2,1))))>D10*20,D10*20,(D10*D16-D18-D12*24/(VALUE(MID(G12,2,1))))),"")。
4.根据权利要求1所述的速算器，其中单元格D14、G14、I14、D30、W8、W10、W12、W14、W16、W18、W20、W22、W24、W26、W28、W32为注意事项，单元格D14=IF(OR(I12="",B14=""),"",IF(D12="","",D12))；单元格G14=IF(OR(I12="",B14=""),"",G12)；单元格I14=IF(OR(I12="",B14=""),"",(24/MID(G12,2,1)-MID(I12,2,2)))；单元格D30＝=ROUND((D10*D16-D18-D12*24/(VALUE(MID(G12,2,1))))/D28,1)；单元格W8=(S8*N8*0.04+S10*N10*0.04)/(S8*N8*0.04+S10*N10*0.04+IF(S16="",0,S16)*N16*0.04+IF(S18="",0,S18)*N18*0.09)；单元格W10=(IF(S16="",0,S16)*N16*0.04)/(S8*N8*0.04+S10*N10*0.04+IF(S16="",0,S16)*N16*0.04+IF(S18="",0,S18)*N18*0.09)；单元格W12=(IF(S18="",0,S18)*N18*0.09)/(S8*N8*0.04+S10*N10*0.04+IF(S16="",0,S16)*N16*0.04+IF(S18="",0,S18)*N18*0.09)；单元格W14=ROUND(IF(OR(I12="",B14=""),IF(D12="",0,IF(ISERROR(VLOOKUP(B12,Z41:AB54,2,FALSE)),"",VLOOKUP(B12,Z41:AB54,2,FALSE)))*D12*0.24/((VALUE(MID(G12,2,1)))),IF(D12="",0,(VLOOKUP(B12,Z41:AB54,2,FALSE)*D12*0.01*(IF(I12="",0,VALUE(MID(I12,2,2))))))+IF(B14="",0,VLOOKUP(B14,Z41:AB54,2,FALSE))*D12*0.01*IF(OR(I12="",B14=""),0,(24/MID(G12,2,1)-MID(I12,2,2)))),1)；单元格W16=ROUND((S8*N8*0.04+S10*N10*0.04+IF(S16="",0,S16)*N16*0.04+IF(S18="",0,S18)*N18*0.09),1)；单元格W18=ROUND((IF(OR(I12="",B14=""),IF(D12="",0,IF(ISERROR(VLOOKUP(B12,Z41:AB54,2,FALSE)),"",VLOOKUP(B12,Z41:AB54,2,FALSE)))*D12*0.24/((VALUE(MID(G12,2,1)))),IF(D12="",0,(VLOOKUP(B12,Z41:AB54,2,FALSE)*D12*0.01*(IF(I12="",0,VALUE(MID(I12,2,2))))))+IF(B14="",0,VLOOKUP(B14,Z41:AB54,2,FALSE))*D12*0.01*IF(OR(I12="",B14=""),0,(24/MID(G12,2,1)-MID(I12,2,2))))+(S8*N8*0.04+S10*N10*0.04+IF(S16="",0,S16)*N16*0.04+IF(S18="",0,S18)*N18*0.09))/D10,1)；单元格W20=ROUND((N8*S8*0.05+S10*N10*0.05+IF(S16="",0,S16)*0.6+IF(S18="",0,S18)*0.3+IF(S20="",0,S20)*3.4+IF(S22="",0,S22)*4+IF(S24="",0,S24)*0.308)*1000/(D16*D10-D18-D12*24/(VALUE(MID(G12,2,1)))),1)；单元格W22=ROUND((6*D10*D32)/((D10*D16-D18-D12*24/(VALUE(MID(G12,2,1))))/D28),1)；单元格W24=IF(S20="",0,S20*N20/(D10*D16-D18-D12*24/(VALUE(MID(G12,2,1)))))；单元格W26=ROUND((IF(S16="",0,S16)*N16)/(100*D10),1)；单元格W28=ROUND((IF(S18="",0,S18)*N18)/(100*D10),1)；单元格W32=D10*D16-D18-D12*24/(VALUE(MID(G12,2,1)))。
CN201410825265.5A 2014-12-27 2014-12-27 新生儿静脉营养速算器 Pending CN105808898A (zh)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201410825265.5A CN105808898A (zh) 2014-12-27 2014-12-27 新生儿静脉营养速算器

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201410825265.5A CN105808898A (zh) 2014-12-27 2014-12-27 新生儿静脉营养速算器

Publications (1)

Publication Number Publication Date
CN105808898A true CN105808898A (zh) 2016-07-27

Family

ID=56981480

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201410825265.5A Pending CN105808898A (zh) 2014-12-27 2014-12-27 新生儿静脉营养速算器

Country Status (1)

Country Link
CN (1) CN105808898A (zh)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107705825A (zh) * 2017-09-25 2018-02-16 南京市儿童医院 一种基于MicrosoftExcel的儿童肠外营养计算表制作方法

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103751874A (zh) * 2014-01-21 2014-04-30 山东大学齐鲁儿童医院 一种提高新生儿静脉营养注射计量准确率的系统
CN104091043A (zh) * 2014-06-13 2014-10-08 郧西县人民医院 一种利用Excel制作的新生儿静脉营养液体及热卡计算器

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103751874A (zh) * 2014-01-21 2014-04-30 山东大学齐鲁儿童医院 一种提高新生儿静脉营养注射计量准确率的系统
CN104091043A (zh) * 2014-06-13 2014-10-08 郧西县人民医院 一种利用Excel制作的新生儿静脉营养液体及热卡计算器

Non-Patent Citations (4)

* Cited by examiner, † Cited by third party
Title
吴杰斌 等: "Excel电子计算表格在新生儿静脉营养中的应用", 《儿科药学杂志》 *
时艳平: "Excel在新生儿静脉营养输液配制中计算营养素和热量的应用", 《儿科药学杂志》 *
潘广赉 等: "新生儿静脉营养电子计算表格制作及临床应用", 《广州医药》 *
马鸿雁: "新生儿静脉营养计算器在新生儿工作中的应用", 《中华医学会第十七次全国儿科学术大会论文汇》 *

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107705825A (zh) * 2017-09-25 2018-02-16 南京市儿童医院 一种基于MicrosoftExcel的儿童肠外营养计算表制作方法

Similar Documents

Publication Publication Date Title
Başaran et al. Treatment and Results in Paediatric Traumatic Hip Dislocation: Case series and review of the literature
CN105808898A (zh) 新生儿静脉营养速算器
Yadav et al. Estimation of stature from the measurement of forearm, hand, leg, and foot dimensions in Uttar Pradesh region
Kostinov et al. Duration of preservation of antibodies to the flu virus in the mother-child pairs during the vaccination of women depending on the trimester of pregnancy
Protière et al. Will CURE trials introduce an uncomfortable revolution in the field of HIV research?
Mirea et al. Analysis of aortic size in subjects died due to cardiovascular and non-cardiovascular events: a necropsy study
Hines et al. Pediatric nurses acknowledging praxis: Recognizing caring in reflective narratives.
Chokotho Quality of life, functional status and cost-effectiveness of treatment after femoral shaft fractures in Malawi. A comparison of skeletal traction and intramedullary nailing in a low resource setting.
Coulthard Ultra-small neonatal dialysis circuits do not maintain safe fluid balance
Chiles et al. Accidental carotid artery cannulation detected by bedside ultrasound
Reber et al. SUN-PO254: SwissHPN-II Study: Long Term Challenges and Complications Home Parenteral Nutrition
Lorenzo-Márquez et al. Estimating risk of exposure to heavy metals by consumption of plecos (Pterygoplichthys spp.) in infants of riverine communites of Grijalva and Usumacinta rivers, Mexico
Duque et al. Conversion disorder in children and adolescents
Ludvigsson Maternal H1N1 vaccination: no adverse effects on mortality
López et al. Association between nutritional status and pulmonary function in children without respiratory disease
Kim et al. Brestfeeding rate and its related factors in rural area
CN105512449A (zh) 新生儿静脉营养计算器
Yiyit et al. A unique case of Poland's syndrome associated with Sprengel's deformity and contralateral gynecomastia
De Giorgi et al. Erratum to:(18) F-Fluorocholine PET/CT for early response assessment in patients with metastatic castration-resistant prostate cancer treated with enzalutamide
Silva et al. Renal function in renogram: comparison of two algorithms for image processing
Oikonen Model equations for the dispersion of the input function in bolus infusion PET studies
Aşilar et al. Hypertensive individuals’ use of complementary health approaches and its effect on adherence with antihypertensive medication treatment
Stefanescu et al. Uniqueness of the palatine folds a family based forensic ortho dental study
Niesporek et al. In-vivo chlorine quantification with partial volume corrected 35Cl-MRI
Sadoh et al. Cardiovascular responses to blood transfusion in children with anemic heart failure

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
WD01 Invention patent application deemed withdrawn after publication
WD01 Invention patent application deemed withdrawn after publication

Application publication date: 20160727