Task: Extract specific data fields from Batch Pack...
創建於:2026年11月13日
使用 GPT-6 Thinking 回答 Chat01
創建於:2026年11月13日
使用 GPT-6 Thinking 回答 Chat01
Task: Extract specific data fields from Batch Packing Record (BPR) Word documents and populate them into a structured Excel sheet. If any data is not found in the document, leave that cell blank.
Input: A .rar archive containing multiple BPR Word files (.docx).
Output Format: Excel sheet with the following columns:
Column Name
Description
Product Name
Name of the finished product
FG Code
Finished Good Code (numeric)
Market
Country/Market name
Pack Style
Packaging configuration (e.g., 3x8, 10x10)
Lidding foil
Material code for lidding foil
Description
Description of lidding foil
Base foil
Material code for base foil
Description
Description of base foil
Machine parameters BPR (Blister packing machine)
Speed, Sealing Temperature, Forming Temperature, and any other blister machine parameters
Cartonater Machine
Cartonator speed/parameters
BPR Number
Batch Packing Record number
Extraction Rules & Field Mapping:
Search for: "Generic Name", product name near FG code, or title on first page.
Example: "Artemether and Lumefantrine Tablets 20/120 MG" or branded name like "LONART 20/120 AQCOAT TABLET"
Search for: "Finished Good Code", "FG Code", or numeric code near product name.
Usually an 8-digit number (e.g., 17005956).
Search for: "Market / Country", "Country", "Market".
Extract country name (e.g., UGANDA, Uganda).
Search for: "Pack style", "Pack Style", "Packaging Style".
Extract configuration (e.g., 3X8's Tablets, 3x8).
Search in "BILL OF MATERIAL" section.
Look for lidding foil / blister foil / backing foil material code.
Usually starts with description containing "BF" or "Lidding" or "Blister Foil".
Extract the numeric material code (e.g., 12004594).
Extract the full material description corresponding to the lidding foil code from Bill of Material.
Example: "BF 0.025X262MM LONART 20/120 TAB 8'S INT1"
Search in "BILL OF MATERIAL" section.
Look for PVC film / forming film / base foil material code.
Extract the numeric material code (e.g., 12004145).
Extract the full material description corresponding to the base foil code from Bill of Material.
Example: "PVC 0.25X268 MM CLEAR FILM IN/INT P3"
Search in "Primary Packing Operation" section, specifically Table 8.1 and 8.2.
Extract the following parameters (whichever are available):
Machine Speed / Speed (e.g., "300 - 450 BPM")
Sealing Temperature / Sealing Temp (e.g., "210 - 255°C")
Forming Temperature / Forming Temp (e.g., "90 - 130°C")
Any other temperature or speed parameters listed
Format as: "Speed- [value], Sealing Temp- [value], Forming Temp- [value]"
Search in "Secondary Packing Operation" section, specifically Table 10.1 and 10.2.
Extract Cartonator speed/parameters (e.g., "25-200 CPM").
Look for: "Speed (Minimum)", "Speed (Maximum)", "Cycle/Min", "Cartonator" parameters.
Search for: "BPR No.", "BPR Number", or document identifier.
Usually in format like "BPR/PT/290/03".
Important Instructions:
If a field is not found in the document, leave it blank (do not guess or use placeholder text).
Bill of Material Section Priority: For lidding foil and base foil, always refer to Section 5.0 "BILL OF MATERIAL" first. Lidding foil typically has description starting with "BF" (Blister Foil) or similar backing foil terms. Base foil typically contains "PVC" or "PVC/PVDC" or "Forming Film".
Machine Parameters Priority: For blister machine parameters, use Table 8.1 (Recipe details) and Table 8.2 (Setting parameters). For cartonator parameters, use Table 10.1 and Table 10.2.
Case Insensitive Search: Field labels in documents may vary slightly (e.g., "Pack style" vs "Pack Style"). Perform case-insensitive matching.
Multi-line Parameters: If machine parameters span multiple lines, combine them into a single cell with line breaks or commas as shown in the sample format.
One Row Per BPR: Each BPR document should result in exactly one row in the Excel sheet.
Output: Generate the final data as an Excel file (.xlsx) with all extracted rows.
Sample Output Row (for reference):
Product Name
FG Code
Market
Pack Style
Lidding foil
Description
Base foil
Description
Machine parameters BPR
Cartonater Machine
BPR Number
LONART 20/120 AQCOAT TABLET
17005956
Uganda
3x8
12004594
BF 0.025X262MM LONART 20/120 TAB 8'S INT1
12004145
PVC 0.25X268 MM CLEAR FILM IN/INT P3
Speed- 300 - 450 BPMSealing Temp- 210 - 255°C, Forming Temp- 90 - 130°C
Cartonator- 25-200 CPM
BPR/PT/290/03
Process all BPR documents in the provided .rar file and generate the complete Excel sheet.
I’ll inspect the archive, extract the requested fields from each BPR, and create one Excel row per document. I’ll pay particular attention to the Bill of Material and machine-setting tables, leave unverified fields blank, and check the workbook before sharing it.
I’ve confirmed that most BPRs use the expected sections, but a few have different table numbering or formatting. I’m accounting for those variations so the foil codes and machine settings come from the correct tables.
The extraction is complete for the 65 top-level BPRs. I also found a separate LOFNAC BPR revision inside a nested RAR, which brings the workbook to 66 rows. The remaining blanks are limited to values not stated in the relevant documents, including placeholder foil codes and records without cartonator settings.
The archive contains 65 identifiable Batch Packing Record Word documents, along with supporting BOM, recipe, and other files. I'll include one row for each BPR document, including separate revisions, and exclude supporting documents from the row count.
Missing or unverified values will remain blank, as requested.
The Excel extraction is complete and verified.
Download the Completed BPR Excel Sheet
66 BPR documents · 66 data rows · 11 requested columns
The workbook includes one additional distinct BPR found inside a nested RAR archive, bringing the total from 65 to 66 records.
All requested fields have been extracted where available. Missing or unverified values have been left blank rather than estimated. The sheet is formatted for filtering and reviewing in Excel.