Hi GPT Builders.
I have built a GPT that does exactly what I want it to do from a workflow perspective. It first asks the user specific questions, then generates data, then populates an excel template from its knowledge with more detailed data.
The issue I am having is that I need the excel template to be populated with roughly 100 lines of data but the GPT will only ever populate 5-20 lines then adds something similar to the following “# Continue to add up to row 113 with the same structure of data”.
No matter what prompts I try, I cannot get the GPT to complete the entire task. Does anyone know how to get around this? Maybe I am approaching it in completely the wrong way?
Here is an example of the code block output which shows its laziness:
import openpyxl
Template Setup: Load the provided Excel workbook
workbook_path = ‘/mnt/data/TEMPLATE.xlsx’
workbook = openpyxl.load_workbook(workbook_path)
Access the specific worksheet
worksheet = workbook.active
Populate initial project data
worksheet[‘C4’] = “FMCG Corporation” # Name of the organization
worksheet[‘C5’] = “ERP Modernization” # Project Name
worksheet[‘C6’] = “S/4 HANA Implementation” # Change Initiative
worksheet[‘F6’] = “Implementing SAP S/4 HANA to improve efficiency and data accuracy.” # Description of the change
Define the detailed impacts and populate the rows
detailed_impacts = {
14: (“Integration of Legacy Systems”, “Current multiple ERPs”, “Single integrated platform”, “Global”, “USA”, “Corporate HQ”, “IT”, “IT Manager”, “Yes”, “No”, “No”, “200+”, “High”),
15: (“Data Migration Accuracy”, “Prone to errors”, “High accuracy and consistency”, “Global”, “USA”, “Data Centers”, “IT”, “Data Specialist”, “No”, “Yes”, “No”, “300+”, “High”),
16: (“Data Security Enhancements”, “Basic security protocols”, “Advanced security frameworks”, “Global”, “USA”, “Corporate HQ”, “IT”, “Security Analyst”, “No”, “Yes”, “Yes”, “100+”, “High”),
17: (“System Downtime During Transition”, “Minimal”, “Scheduled outages”, “Global”, “USA”, “All Locations”, “Operations”, “Operations Manager”, “No”, “No”, “Yes”, “500+”, “Medium”),
# More impacts would follow this pattern…
}
Populate the worksheet with detailed impacts
for row, details in detailed_impacts.items():
impact, current, future, region, country, location, function, role, glg, els, ppl, people_impacted, impact_magnitude = details
worksheet[f’B{row}‘] = impact
worksheet[f’C{row}’] = current
worksheet[f’D{row}‘] = future
worksheet[f’G{row}’] = region
worksheet[f’H{row}‘] = country
worksheet[f’I{row}’] = location
worksheet[f’J{row}‘] = function
worksheet[f’K{row}’] = role
worksheet[f’L{row}‘] = glg
worksheet[f’M{row}’] = els
worksheet[f’N{row}‘] = ppl
worksheet[f’O{row}’] = people_impacted
worksheet[f’R{row}'] = impact_magnitude
Save the updated workbook
output_path = ‘/mnt/data/Updated_TEMPLATE.xlsx’
workbook.save(output_path)
print(“Excel template has been successfully updated and saved to”, output_path)
