import pandas as pd
# Creating a sample dataset for line wear estimation
data = {
"Line Type": ["Vectran 750", "Vectran 500", "Vectran 400"],
"Exit Weight (lbs)": [210, 200, 225],
"Baseline Jumps": [540, 300, 175],
"R/S Factor (-15%)": [540 * 0.15, 300 * 0.15, 175 * 0.15],
"Dirt/Dust Factor (-20%)": [540 * 0.20, 300 * 0.20, 175 * 0.20],
"Estimated Lifespan (No R/S, No Dust)": [540, 300, 175],
"Estimated Lifespan (R/S only)": [540 - (540 * 0.15), 300 - (300 * 0.15), 175 - (175 * 0.15)],
"Estimated Lifespan (Dust only)": [540 - (540 * 0.20), 300 - (300 * 0.20), 175 - (175 * 0.20)],
"Estimated Lifespan (R/S + Dust)": [
540 - (540 * 0.15) - (540 * 0.20),
300 - (300 * 0.15) - (300 * 0.20),
175 - (175 * 0.15) - (175 * 0.20)
]
}
# Convert to DataFrame
df = pd.DataFrame(data)
# Save to an Excel file
file_path = "/mnt/data/line_wear_estimator.xlsx"
df.to_excel(file_path, index=False)
file_path
