Related Experiment Video
Updated: Jan 30, 2026
A Novel Method for Involving Women of Color at High Risk for Preterm Birth in Research Priority Setting
Published on: January 12, 2018
A Simple Method of Calculation in Excel for the Protein Requirements in Preterm New Borns
E C Stoicănescu1, F Popescu2, A Zavate3
1MD-Pediatrician, PhD student, University of Medicine and Pharmacy of Craiova, Romania.
Introduction:
The nutritional balance between the nutritional requirements of the organism and the intake is a very delicate thing to adjust especially when it comes to the premature new-born in whom often the oral feeding is very challenging and the need for parenteral feeding is very pressing.
Purpose:
The goal of this article is to present a simple method of calculation for the amino acid parenteral intake in preterm infants using the Excel spreadsheet platform as a platform.
Material And Method:
Using Excel commands, we translate the algorithms for the protein requirements calculation into an electronic format. This will allow the creation of a template that quickly identifies the need for proteins according to the clinical and evolutional features of the premature new-born, significantly reducing the duration of the calculation.
Results:
This method is easy to perform, simple and efficient. The calculation template has significantly reduced the errors and the actual working time with the algorithms. These effects are very obvious in intensive care units that take care of a large number of premature babies.
Conclusions:
Computerized calculation allows a decrease in calculation errors and also reduces the time actually allocated for the calculation, especially for the very complicated algorithms. Following this template in Excel, we can create separate modules for the algorithms necessary to calculate the needs for the intake of liquids, calories, lipids, and minerals.
Related Concept Videos
02:44The Born-Haber Cycle
01:17Performing a Simple Data Analysis using MS-Excel Function
SUM: This function calculates the total sum of a range of values. It's the foundation for aggregating data, essential for determining overall trends and totals in datasets.
AVERAGE: It computes the mean value of a given set of numbers, providing a quick insight into the central...
01:28Proteins: Dietary Sources and Requirements
01:18Microsoft Excel: Plotting Mean, SD, and SE
First, calculate the mean, SD, and SE of your data. The mean is obtained using the formula `=AVERAGE(range)`, while SD can be calculated with `=STDEV.P(range)` for a population or `=STDEV.S(range)` for a sample. SE is calculated as `=SD/SQRT(n)`, where `n` is the sample size.
To plot these values, use a bar...
01:25Microsoft Excel: Student's t-Test
To conduct a t-test in Excel, use the T.TEST function or the "Data...
02:46Calculating the Equilibrium Constant
For example, gaseous nitrogen dioxide forms dinitrogen tetroxide according to this equation: