Workflow Developme
Posted: Tue Jun 17, 2025 9:57 am
For each of our top 3 list types, we built the specific transformation routines:
Customer Feedback: We created a Google Sheet template with pre-built formulas using REGEXEXTRACT to pull Core_Issue_Category based on keywords in the Original_Comment. We used VLOOKUP against a "Sentiment Keyword" list to assign Sentiment.
Bug Reports: The Python script was refined. It now took the markdown bug report, parsed each section (Title, Impact, Steps), and outputted it into a structured Jira import CSV format.
Feature Requirements: We developed a structured markdown template that could be brother cell phone list easily parsed by a simple custom script into a project management tool (e.g., Asana/Trello) with predefined fields.
Internal Training Sessions (Days 14-15):
We conducted short, hands-on training sessions (1 hour each) for the teams responsible for generating and consuming these lists.
We focused on:
Why: Explaining the benefits of the new structured approach.
How to Input: Demonstrating the new input templates/forms.
How to Transform: Walking through the new spreadsheet formulas or how to run the Python script (for those comfortable).
How to Access Output: Showing where the clean data would reside.
Week 4: Implementation, Feedback, and Refinement
Goal: Roll out the new processes, gather feedback, and make necessary adjustments.
Pilot Rollout (Days 16-18):
Customer Feedback: We created a Google Sheet template with pre-built formulas using REGEXEXTRACT to pull Core_Issue_Category based on keywords in the Original_Comment. We used VLOOKUP against a "Sentiment Keyword" list to assign Sentiment.
Bug Reports: The Python script was refined. It now took the markdown bug report, parsed each section (Title, Impact, Steps), and outputted it into a structured Jira import CSV format.
Feature Requirements: We developed a structured markdown template that could be brother cell phone list easily parsed by a simple custom script into a project management tool (e.g., Asana/Trello) with predefined fields.
Internal Training Sessions (Days 14-15):
We conducted short, hands-on training sessions (1 hour each) for the teams responsible for generating and consuming these lists.
We focused on:
Why: Explaining the benefits of the new structured approach.
How to Input: Demonstrating the new input templates/forms.
How to Transform: Walking through the new spreadsheet formulas or how to run the Python script (for those comfortable).
How to Access Output: Showing where the clean data would reside.
Week 4: Implementation, Feedback, and Refinement
Goal: Roll out the new processes, gather feedback, and make necessary adjustments.
Pilot Rollout (Days 16-18):