Practice Operations Guide
Dietitian Client Tracking Spreadsheet Architecture
Organize your private practice in Excel or Google Sheets. Below is the ideal 3-tab workbook structure, essential BMR/TDEE calculation formulas, and steps to import your roster into Nutrena.
Tab 1: Master Client Roster (Columns A to J)
Sheet: Master_RosterMaintain one row per client. Use these standardized column names to ensure instant CSV mapping if you migrate to CRM software:
| Col | Header Name | Data Type | Example Value |
|---|---|---|---|
| A | Client_ID | Text | NUT-2026-042 |
| B | Full_Name | Text | Priya Patel |
| C | Phone_WhatsApp | Number | +91 98765 43210 |
| D | Age_Gender | Text | 34 / Female |
| E | Primary_Goal | Dropdown | Fat Loss + PCOS Management |
| F | Plan_Tier | Dropdown | 3-Month Transformation |
| G | Start_Date | Date | 2026-06-01 |
| H | Renewal_Date | Date | 2026-09-01 |
| I | Fee_Status | Dropdown | Paid (₹7,500) |
| J | Status | Dropdown | Active / In Progress |
Tab 2: Essential Clinical Formulas (Excel & Google Sheets)
1. Body Mass Index (BMI)
Weight in kg divided by Height in meters squared:
=ROUND(Weight_kg / ((Height_cm / 100) ^ 2), 1)2. Basal Metabolic Rate (Mifflin-St Jeor)
Calculates baseline energy expenditure for men and women:
Female: =(10 * Weight_kg) + (6.25 * Height_cm) - (5 * Age_Years) - 161
Male: =(10 * Weight_kg) + (6.25 * Height_cm) - (5 * Age_Years) + 53. Total Daily Energy Expenditure (TDEE)
Multiplies BMR by clinical physical activity factor:
=BMR * Activity_Multiplier [Sedentary: 1.2 | Light: 1.375 | Moderate: 1.55 | Heavy: 1.725]Ready to upgrade past spreadsheet bottlenecks?
Import your existing client spreadsheet directly into Nutrena. Keep all your client notes, dates, and metrics intact without manual re-typing.