Excel Template Description: Habit Building Meal Planner (Summary View)

This comprehensive Excel template is specifically designed to support Habit Building through a structured Meal Planner system, presented in an intuitive Summary View. The template merges meal planning with behavioral science principles, helping users establish sustainable healthy eating habits by visualizing progress, tracking consistency, and reinforcing positive routines.

Schedule: Sheet Names and Functions

1. Meal Planner (Daily View): A daily calendar where users log meals for each day of the week. It includes columns for breakfast, lunch, dinner, snacks, hydration tracking, and habit completion checkboxes.
2. Daily Logs: A dynamic log that records daily entries with time-stamped meal logs and habit checks. This sheet automatically aggregates data into summary metrics.
3. Summary Dashboard: The centerpiece of the template. It provides a high-level overview of weekly habits, meal consistency, nutrient goals (optional), hydration levels, and streaks — all visualized through charts and status indicators.
4. Habit Tracker & Goals: A dedicated space for defining personal health habits (e.g., “Drink 2 liters of water daily,” “Eat 5 servings of vegetables”), setting targets, and tracking long-term progress with streak counters and milestone flags.

Table Structures and Column Definitions

• Meal Planner (Daily View): <

  Column Name	Data Type/Format
  Date (DD/MM/YYYY)	Date
  Breakfast (Meal Description)	Text
  Lunch (Meal Description)	Text
  Dinner (Meal Description)	Text
  Snacks (List of Snacks)	Text
  Water Intake (ml)	Numeric (0–4000)
  Habit Check: Eat Vegetables?	Boolean (Yes/No checkbox)
  Habit Check: Prep Meals in Advance?	Boolean
  Habit Check: No Processed Food Today?	Boolean

• Daily Logs (Hidden Aggregation Sheet): Percentage calculated from checked habits

  Column Name	Data Type/Format
  Date	Date
  Total Meals Logged	Numeric (count of non-blank meal cells)
  Water Consumed (ml)	Numeric
  Habit Completion Rate (%)
  Daily Consistency Score (1–5)	Number based on user-defined rules and auto-calculated rating

• Habit Tracker & Goals:

  Column Name	Data Type/Format
  Habit Description (e.g., “Drink 2L Water”)	Text
  Daily Target (e.g., 2000ml)	Numeric
  Streak Count (Days)	Numeric (auto-incremented with conditional logic)
  Status: Achieved Today?	Yes/No Checkbox
  Last Updated	Date Auto-filled when checked

• Summary Dashboard (Main Visual Sheet): Contains multiple summary tables and interactive charts that pull data dynamically from the other sheets.

Formulas Required for Functionality

• Streak Counter (Habit Tracker):
  =IF(AND(Status=TRUE, PreviousRowStatus=TRUE), PreviousStreak+1, IF(Status=TRUE, 1, 0))
  This formula automatically counts consecutive days a habit is completed.
• Daily Habit Completion Rate:
  =COUNTIF(HabitCheckRange,"Yes")/COUNTA(HabitCheckRange)
  Calculates the percentage of habits completed on a given day.
• Weekly Average Hydration:
  =AVERAGEIF(DateColumn,">=01/01/2024",WaterIntakeColumn)
  Computes average daily water intake for the current week.
• Consistency Score (1–5):
  =IF(AverageHabitRate >= 90%, 5, IF(AverageHabitRate >= 75%, 4, IF(AverageHabitRate >= 60%, 3, IF(AverageHabitRate >= 40%,2,1))))
  Translates habit completion into a user-friendly consistency rating.
• Auto-Update Date Range (Dynamic):
  Uses EDATE() and TODAY() to dynamically update the current week’s data range for charts and summaries.

Conditional Formatting Rules

• Habit Streaks: Green fill for 7+ day streaks; Yellow for 3–6 days; Red if broken.
• Habit Completion Rate: Traffic light style — Green (>85%), Yellow (60–84%), Red (<60%).
• Water Intake: Blue fill when ≥2000ml; Gray if below 1500ml.
• Daily Consistency Score: Color gradients from red (1) to green (5).

User Instructions

1. Open the workbook and save it with your name or project title.
2. Navigate to the Meal Planner (Daily View). Enter meal details for each day, and check off completed habits.
3. On the same sheet, input daily water intake in milliliters.
4. Go to the Habit Tracker & Goals tab. Define your top 3–5 health habits (e.g., “Eat 5 servings of vegetables”), set goals, and check off each day.
5. The Summary Dashboard updates automatically every time you make a change — no manual input needed.
6. Review weekly charts to analyze patterns and adjust your habits for improvement.
7. Use the "Reset Week" button (if available) at the start of each new week to clean up old data and begin fresh.

Example Rows

Recommended Charts and Dashboards (Summary View)

• Daily Habit Completion Rate Chart: Line graph showing trend across 7 days.
• Habit Streak Tracker: Gantt-style bar chart for each habit, showing consecutive day streaks.
• Weekly Water Intake Comparison: Bar chart comparing daily intake against the target (2000ml).
• Daily Consistency Score Radar Chart: Visualizes how well you met your goals each day across multiple habit categories.