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.
This study introduces a simple Excel-based method for calculating parenteral amino acid intake in preterm infants. The approach streamlines calculations, reducing errors and saving time in neonatal intensive care units.
Area of Science:
- Neonatal Nutrition
- Computational Medicine
- Pediatric Intensive Care
Background:
- Parenteral nutrition is critical for preterm infants due to feeding challenges.
- Accurate calculation of nutritional requirements is complex and time-consuming.
Purpose of the Study:
- To present a simplified Excel-based method for calculating parenteral amino acid intake in preterm infants.
- To reduce the complexity and time associated with nutritional calculations for neonates.
Main Methods:
- Developed an Excel template using built-in commands to automate protein requirement calculations.
- Algorithms for protein needs were translated into an electronic format for quick assessment.
Main Results:
- The Excel method significantly reduces calculation errors and working time.
- The template efficiently identifies protein needs based on infant clinical and evolutionary data.
- This approach is particularly beneficial in high-volume neonatal intensive care units.
Conclusions:
- Computerized calculation decreases errors and time for complex nutritional algorithms.
- The Excel template can be expanded to include modules for calculating fluid, calorie, lipid, and mineral intake.
- This method enhances the precision and efficiency of parenteral nutrition management in preterm infants.
Related Concept Videos
The Born-Haber Cycle
Performing 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...
Proteins: Dietary Sources and Requirements
Microsoft 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...
Microsoft Excel: Student's t-Test
To conduct a t-test in Excel, use the T.TEST function or the "Data...
Calculating the Equilibrium Constant
For example, gaseous nitrogen dioxide forms dinitrogen tetroxide according to this equation:

