Turn hundreds of pages of RFQs and BOQs into one requirements table
r/ClaudeAI 讨论串留言者(原帖不可读,未取得用户名)Reddit · Date not disclosed
Read originalSaved text / editorial summary
采集站 agentusecases.ai 的编辑摘要(原帖 Reddit 线程在本次采集时不可读,以下为转述而非引文):一位解决方案架构师在工作中用它处理 RFQ 与 BOQ 及其附件,通读 PDF、Word、Excel 格式的数百页材料,把需求抽取到一张 Excel 表中,并把本方能力与人员资质纳入考虑,同时计算不同情景下的报价金额;他建议为每条工作流做一个可复用的插件。结果方面,他称这样能对询价函形成非常准确的认知,提交投标书时信息也更准确,但帖内没有给出硬指标或失败案例。已知条件:设备为 MacBook Pro M5、24GB 内存,可复用的工作流插件能避免重复配置。
Business model
A solutions architect handed the most tedious part of bidding to a personal agent: read the RFQ and BOQ plus every attachment, across hundreds of pages of PDF, Word and Excel, extract every requirement into a structured table, then factor in the company's capabilities and staff qualifications and price out several scenarios. The thread reports no hours saved, no win rate and no hard metrics. What transfers is the order of operations: fix the column headers first, extract second, cite file and page for every row, and list anything ambiguous for a human to clarify.
The asset is the order of operations, not the software. Fixed headers turn 'did I miss anything' into a visible empty cell, and per-row citations mean a reviewer never has to re-read the pack. Any assistant that can read local files can run it; the discipline is what makes the output safe to bid from.
Workflow
- Fix the column headers first: number, description, quantity, unit, specification, deadline, acceptance, source file, page.
- Have the agent list every input file with format, page count and language, and confirm no attachment is missing before extracting.
- Make it restate how it will handle multiple languages, unreadable scans, missing page numbers and conflicting clauses, and approve that before it extracts.
- Extract in batches per file, with source file and page number on every row, leaving blanks rather than guessing.
- Spot-check 10 to 20 rows against the originals, concentrating on quantity, unit and deadline, and collect ambiguous clauses for formal clarification.
- Only after the table is approved, ask for two or three pricing scenarios with assumptions and arithmetic shown.
Adaptation plan
The thread gives no hours saved, no bid volume, no error rate, no failure cases and no tool cost. The original text could not be read at collection time (Reddit returned HTTP 403 on every public endpoint and no Wayback snapshot exists), so all specifics come from the discovery site's editorial summary. The workflow steps, prompt and pitfalls here are AgentFlow's proposals, untested.
Starter prompt
Written by AgentFlow; not the original author’s prompt. Not independently deployed in Muse or Grok.
You are a bid-document assistant. Extract requirements from my tender pack into a deliverable table. You do not make bidding decisions.
[INPUT]
Directory: [paste path]
Contents: the RFQ main document, the BOQ, and every attachment (mixed PDF / Word / Excel).
Fixed headers (do not add, remove or rename):
No. | Requirement | Quantity | Unit | Specification | Delivery or schedule | Acceptance criteria | Source file | Page or section | Notes
[EXECUTION STEPS]
1) First return only a file inventory: filename, format, page count, language. Do not extract yet. Wait for my confirmation that no attachment is missing.
2) Then explain in your own words how you will handle: clauses in other languages, scanned or non-selectable pages, missing page numbers, contradictions between the main document and attachments, and the same requirement repeated. Start only after I approve.
3) Extract file by file in batches, reporting rows added and source distribution after each batch.
4) Leave any field blank that the source does not state. Never fill it in from industry practice, common patterns or your own inference.
5) Finish with a separate clarification list: clauses that are vague, missing or contradictory, each with a note on why it needs clarification.
[OUTPUT REQUIREMENTS]
- Requirements table: one requirement per row, with source file plus page or section always populated. If no page number exists, cite the section or filename and mark "page unavailable".
- Clarification list: separate, with one entry per issue, never merged.
- Close with an extraction note: what you skipped, why, and which pages were unreadable.
- Do not modify, move or rename any original file.
[HUMAN CONFIRMATION POINTS]
- The file inventory needs my approval before extraction begins.
- The handling rules need my approval before extraction begins.
- The requirements table needs my spot-check before any pricing step. Produce no pricing figures until I confirm.
- I decide whether to raise a formal clarification for anything on the clarification list.
[COMPLETE SMALL SYNTHETIC INPUT AND OUTPUT — not real business data; no model execution]
The JSON contains all demo inputs and a manually authored reference output. Do not invent facts from files not supplied. This reference covers only this minimal input and is not a business reproduction.
{
"input": {
"sources": [
{
"file": "RFQ.txt",
"location": "section 4.3",
"text": "Commissioning: at least 2 person-days."
},
{
"file": "Appendix.txt",
"location": "section 2",
"text": "Commissioning: at least 3 person-days."
}
],
"required_fields": [
"requirement",
"quantity",
"unit",
"source",
"notes"
]
},
"expected_output": {
"requirements": [
{
"requirement": "Commissioning",
"quantity": 2,
"unit": "person-days",
"source": "RFQ.txt section 4.3",
"notes": "conflicts with Appendix.txt section 2"
},
{
"requirement": "Commissioning",
"quantity": 3,
"unit": "person-days",
"source": "Appendix.txt section 2",
"notes": "conflicts with RFQ.txt section 4.3"
}
],
"clarifications": [
"Confirm which commissioning requirement governs."
],
"pricing": "not produced; human clarification required",
"original_files_modified": false
},
"mode": "synthetic_read_only_reference_not_model_execution"
}Running costs and pitfalls
The thread gives no hours saved, no bid volume, no error rate, no failure cases and no tool cost. The original text could not be read at collection time (Reddit returned HTTP 403 on every public endpoint and no Wayback snapshot exists), so all specifics come from the discovery site's editorial summary. The workflow steps, prompt and pitfalls here are AgentFlow's proposals, untested. No independent cost benchmark is available. Check subscriptions, permissions and external actions before running a workflow.