write python code that createse an excel spreadsheet with formulas for a hypertrophy program that only has 4 exercises per day, 3 days per week, and incrementally increase weight each session
Certainly! Below is a Python script that uses the `openpyxl` library to create an Excel spreadsheet for a hypertrophy program with the specified parameters. The program consists of 3 days of workouts per week, with 4 exercises per day. Each session will incrementally increase the weight for each exercise.

### Prerequisites
You need to have the `openpyxl` library installed. You can install it using pip if you haven't already:

```bash
pip install openpyxl
```

### Python Code
Here’s the code to generate the Excel spreadsheet:

```python
import openpyxl
from openpyxl.styles import Font

# Define the workout program
workout_program = {
    "Day 1": ["Squats", "Bench Press", "Deadlifts", "Pull-Ups"],
    "Day 2": ["Leg Press", "Overhead Press", "Bent Over Rows", "Dumbbell Curls"],
    "Day 3": ["Lunges", "Incline Bench Press", "Lat Pulldowns", "Tricep Extensions"]
}

# Create a new workbook and select the active worksheet
workbook = openpyxl.Workbook()
sheet = workbook.active
sheet.title = "Hypertrophy Program"

# Add headers
headers = ["Day", "Exercise", "Weight (kg)", "Reps", "Sets"]
sheet.append(headers)

# Set font for headers
for cell in sheet[1]:
   
import pandas as pd

# Create an empty dataframe
df = pd.DataFrame()

# Set the columns
df['Exercise'] = ['Bench Press', 'Squat', 'Deadlift', 'Overhead Press']
df['Day'] = ['Monday', 'Tuesday', 'Wednesday', 'Thursday']
df['Weight'] = [50, 55, 60, 65]

# Set the row count
row_count = 4

# Set the incremental weight increase
incr_weight = 5

# Create the formula
formula = '=SUMPRODUCT(FACT(A1:A{0})*B1:B{0})'

# Create the formulas
for i in range(row_count):
    for j in range(df['Exercise'].size):
        df.at[i, j] = formula.format(incr_weight)

# Write the dataframe to an excel file
df.to_excel('Hypertrophy Program.xlsx', engine='xlsxwriter')