Hi I need a column to enter height weight of children with automatic bmi calculation.please include that option I already entered some data don't change those data.
cd /home/daytona/workspace/attachments/a4f1e331-1eb1-474c-90a3-e6ef6652d14d/ && …
python3 -c " import openpyxl wb = openpyxl.load_workbook('/home/daytona/workspac…
python3 << 'EOF' import openpyxl from openpyxl import load_workbook from openpyx…
python3 << 'EOF' import openpyxl from openpyxl import load_workbook from openpyx…
python3 << 'EOF' import openpyxl from openpyxl import load_workbook from openpyx…
mkdir -p /home/daytona/workspace/bmi-update && ls /home/daytona/workspace/bmi-up…
python3 << 'EOF' import shutil, openpyxl from openpyxl import load_workbook from…
cp '/home/daytona/workspace/attachments/a4f1e331-1eb1-474c-90a3-e6ef6652d14d/DOC…
python3 << 'EOF' from openpyxl import load_workbook from openpyxl.styles import …
python3 << 'EOF' import os, io from openpyxl import load_workbook from openpyxl.…
python3 << 'EOF' from openpyxl import load_workbook dst = '/home/daytona/worksp…
DOC 20260710 WA0000 updated
Spreadsheet · XLSX
| Column | Label | Colour | Purpose |
|---|---|---|---|
| AM | Height (cm) | Green header | You type the child's height in centimetres |
| AN | Weight (kg) | Green header | You type the child's weight in kilograms |
| AO | BMI (Auto) | Blue header | Calculates automatically - no typing needed |
=IF(OR(AM4="",AN4=""),"",ROUND(AN4/(AM4/100)^2,1))
- If either Height or Weight is blank, the BMI cell stays blank (no error).
- Once both are entered, BMI = Weight (kg) / Height (m)² - rounded to 1 decimal place.
- The formula runs for all 500 participant rows (rows 4-503).