# Equipment Warranty Renewal Watch Table Prompt

> An original prompt that turns a raw serial-number and warranty-date list into a renewal-watch table, leaving unknown fields blank for human review.

## Install

Copy the content below into your project:

# Equipment Warranty Renewal Watch Table Prompt

An original prompt that turns a raw serial-number and warranty-date list into a renewal-watch table, leaving unknown fields blank for human review.

## Start here

This is a reusable prompt for ordinary AI chat tools that accept pasted text. No terminal or API setup is needed.

**What to paste:** the prompt text below, plus your raw warranty list in the `MY INPUT` slot. Include a reference date (for example `reference date 2025-01-10`) if you want urgency tiers filled in.

**Where to paste:** into the message box of a general AI chat. Paste the prompt first, then your raw list in the same message.

**How to check the output:**
- The first line must state the reference date used, or say NONE supplied.
- The table must have exactly these columns: Item, Serial number, Warranty end, Vendor/location, Urgency tier, Flags.
- Every serial number and date should come from your text or be blank — nothing invented.
- "Needs human verification" should list only flagged rows.
- The Counts block should match the table.

## Introduction

Maintaining a warranty watch list by hand is slow and error-prone. This prompt converts a messy list of serial numbers and expiry dates into a structured Markdown table, flags gaps and ambiguities, and assigns an urgency tier against a reference date you supply.

## Prerequisites and permissions

- A general AI chat that accepts pasted text.
- Your raw list, and a reference date if you want tiers.
- No login to any vendor system, no file uploads required. Do not paste confidential serials unless your tool and policy allow it. The prompt cannot contact vendors, file claims, schedule renewals, or update systems.

## Limitations

- Only works on the text you paste; it will not search the web or your files.
- Dates are normalised only when unambiguous; month-only or relative dates keep the original wording and get a Flag.
- Urgency tiers stay blank when no reference date is supplied.
- Output is a draft for human verification, not legal, insurance, or purchasing advice.
- Source reviewed; runtime not tested.

## FAQ

**Do I need a reference date?** No. Without one, urgency tiers stay blank and the tool says so at the top. With one, tiers follow the four bands (Expired, 90 days, 91–180 days, later than 180 days).

**What if my list is garbled?** Fields that cannot be assigned confidently stay blank and are explained in Flags. Duplicate serials and possible duplicates are kept as separate rows and flagged.

## Attribution

Original TokRepo prompt, CC BY 4.0. Reference: [ChatGPT release notes](<https://help.openai.com/en/articles/6825453-chatgpt-release-notes>).

## Complete reusable prompt

You are helping me maintain an equipment warranty renewal watch list. I will paste raw text containing equipment serial numbers and warranty end dates. Work only from the text I provide. Do not invent serial numbers, product names, vendors, purchase dates, owners, dates, or coverage terms.

MY INPUT (paste below):
[Paste the raw list. It may be inconsistent. Entries might look like: "SN 44-A19B, warranty ends 2025-03-14", "pump model XR2 serial 88120 - covered until March 2025", or "item 7B: expiry unknown".]

YOUR TASK
1. Extract every distinct piece of equipment into one row.
2. For each row, capture only what is stated: item label or description, serial number, warranty end date, and any stated vendor or location. If a field is not stated, leave it blank rather than guessing.
3. Normalise dates to YYYY-MM-DD only when the stated date is unambiguous. If a date is partial or unclear (for example "March 2025" or "next quarter"), keep the original wording in the date field and add a note in the Flags column.
4. Assign an urgency tier based only on the warranty end date relative to the reference date I give you. If I do not give a reference date, leave the urgency tier blank and say so at the top.
   - Expired: end date is before the reference date
   - Due within 90 days
   - Due within 91-180 days
   - Later than 180 days
5. Flag any row where a serial number or warranty end date is missing, duplicate, or ambiguous.

OUTPUT FORMAT
Start with one line: "Reference date used: [date], or NONE supplied."
Then a Markdown table with these columns:
| Item | Serial number | Warranty end | Vendor/location | Urgency tier | Flags |
After the table, add a short section titled "Needs human verification" listing only the rows whose Flags column is non-empty, with a one-line reason for each.
Finally, add a "Counts" block: total rows, rows missing a serial number, rows missing an end date, rows with an ambiguous date, and rows with duplicate serial numbers.

UNCERTAINTY AND MISSING INPUT HANDLING
- Never fabricate a value to fill an empty cell.
- If two entries appear to describe the same item but the serial numbers differ, keep them as separate rows and flag a possible duplicate.
- If the same serial number appears twice, keep both rows and flag the duplicate.
- If the raw text is too garbled to assign a field confidently, leave the field blank and explain in Flags.
- If there is no date information at all for an item, mark the Warranty end cell as blank and flag it.

REVIEW CHECKS (state pass or fail for each, tied to my pasted input)
- Check 1: Every row's Serial number and Warranty end cells are either taken verbatim from my input or blank. Pass only if no value was invented.
- Check 2: Every urgent-tier value matches the reference date rule, with blank if no reference date was supplied.
- Check 3: Every non-empty Flags cell corresponds to a real gap, duplicate, or ambiguity in my input, not a guess.
- Check 4: The Counts block matches the actual table rows.

BOUNDARIES
- You are preparing a draft tracking table only. You are not contacting vendors, filing warranty claims, scheduling renewals, or updating any system. A person must verify flagged rows before any of that happens.
- Do not give legal, insurance, or purchasing advice.
- Do not add rows for equipment I did not mention.

FICTIONAL EXAMPLE (for shape only)
Input: "SN 44-A19B, warranty ends 2025-03-14; pump model XR2 serial 88120 - covered until March 2025; item 7B: expiry unknown" with reference date 2025-01-10.
Illustrative output shape:
Reference date used: 2025-01-10.
| Item | Serial number | Warranty end | Vendor/location | Urgency tier | Flags |
| 44-A19B | 44-A19B | 2025-03-14 |  | Due within 90 days |  |
| pump model XR2 | 88120 | March 2025 |  | Due within 90 days | Ambiguous date: month only |
| item 7B |  |  |  |  | Missing serial number and end date |
Needs human verification: pump model XR2 (ambiguous month-only date), item 7B (missing serial and date).
Counts: total 3, missing serial 1, missing end date 1, ambiguous date 1, duplicate serials 0.
Example pass/fail checks: Check 1 pass if no date or serial was added that was not in the input; Check 2 pass if tiers follow the reference date; Check 3 pass if flags describe only real gaps; Check 4 pass if counts match the table.

## References and reuse

- [ChatGPT release notes](https://help.openai.com/en/articles/6825453-chatgpt-release-notes)

Original TokRepo prompt · [CC BY 4.0](https://creativecommons.org/licenses/by/4.0/). Reference documents retain their own rights.

---

<!-- ZH -->

# 设备保修续期监控表提示词

一条原创提示词，把零散的设备序列号与保修到期日期清单整理成续期监控表，未知字段留空交由人工核对。

## 开始使用

这是一条可复用的提示词，适用于接受粘贴文本的普通 AI 聊天工具。无需终端或 API 配置。

**粘贴什么：** 下方提示词正文，以及放在 `MY INPUT` 位置的原始清单。若希望填写紧急程度，请附上参考日期（例如 `reference date 2025-01-10`）。

**粘贴到哪里：** 贴进通用 AI 聊天的输入框。先粘贴提示词，再在同一条消息里附上原始清单。

**如何检查输出：**
- 第一行必须写明所用参考日期，或注明未提供。
- 表格列必须为：Item、Serial number、Warranty end、Vendor/location、Urgency tier、Flags。
- 每个序列号和日期都应来自你的原文或留空，不得凭空生成。
- “Needs human verification”只列出被标记的行。
- Counts 区块应与表格一致。

## 简介

手工维护保修监控表既慢又容易出错。这条提示词能把杂乱的序列号与到期日期清单整理成结构化 Markdown 表格，标出缺失与含糊之处，并依据你提供的参考日期划分紧急程度。

## 前提与权限

- 一个接受粘贴文本的通用 AI 聊天工具。
- 你的原始清单；如需紧急程度，请提供参考日期。
- 无需登录任何厂商系统，无需上传文件。除非工具与政策允许，否则不要粘贴机密序列号。该提示词无法联系厂商、提交索赔、安排续期或更新系统。

## 局限

- 只处理你粘贴的文本，不会检索网络或你的文件。
- 仅在日期明确时才标准化；只有月份或相对时间时保留原措辞并记入 Flags。
- 未提供参考日期时紧急程度留空。
- 输出只是供人工核对草稿，不构成法律、保险或采购建议。
- 已审阅来源；未做运行测试。

## 常见问题

**需要提供参考日期吗？** 不需要。没有它，紧急程度留空并在顶部说明；有它则按四个区间（已过期、90 天内、91–180 天、超过 180 天）判定。

**清单很乱怎么办？** 无法确定归属的字段留空并在 Flags 中说明。重复序列号与疑似重复会保留为不同行并标记。

## 出处说明

原创 TokRepo 提示词，遵循 CC BY 4.0。参考：[ChatGPT release notes](<https://help.openai.com/en/articles/6825453-chatgpt-release-notes>)。

## 完整可复制提示词

你正在帮我维护一份设备保修续期监控表。我会粘贴包含设备序列号和保修到期日期的原始文本。只依据我提供的文本工作。不要编造序列号、产品名称、厂商、购买日期、所有者、日期或保障条款。

MY INPUT（粘贴到下方）：
[粘贴原始清单。它可能不一致。条目可能类似：“SN 44-A19B, warranty ends 2025-03-14”、“pump model XR2 serial 88120 - covered until March 2025”或“item 7B: expiry unknown”。]

你的任务
1. 将每一件不同的设备提取为一行。
2. 对每一行，只记录已陈述的内容：项目标签或描述、序列号、保修到期日期，以及任何已陈述的厂商或地点。如果某字段未陈述，留空而不是猜测。
3. 仅当陈述的日期明确无歧义时，才将其标准化为 YYYY-MM-DD。如果日期不完整或不清晰（例如“March 2025”或“next quarter”），在日期字段中保留原始措辞，并在 Flags 列中加注。
4. 仅根据保修到期日期相对于我给出的参考日期来分配紧急程度。如果我没有给出参考日期，则紧急程度留空并在顶部说明。
   - Expired：到期日期早于参考日期
   - Due within 90 days
   - Due within 91-180 days
   - Later than 180 days
5. 标记任何序列号或保修到期日期缺失、重复或有歧义的行。

输出格式
以一行开头：“Reference date used: [date], or NONE supplied.”
然后是一个 Markdown 表格，包含以下列：
| Item | Serial number | Warranty end | Vendor/location | Urgency tier | Flags |
表格之后，添加一个标题为“Needs human verification”的简短部分，仅列出 Flags 列非空的行，每行给出一行原因。
最后，添加一个“Counts”区块：总行数、缺少序列号的行数、缺少到期日期的行数、日期有歧义的行数，以及序列号重复的行数。

不确定性与缺失输入处理
- 绝不编造值来填充空单元格。
- 如果两条条目似乎描述同一件物品但序列号不同，将它们保留为不同行并标记可能重复。
- 如果同一序列号出现两次，保留两行并标记重复。
- 如果原始文本过于混乱，无法有把握地分配某字段，则将该字段留空并在 Flags 中说明。
- 如果某物品完全没有日期信息，将 Warranty end 单元格标记为空白并加标记。

复核检查（对每一项说明通过或未通过，并结合我粘贴的输入）
- Check 1：每一行的 Serial number 和 Warranty end 单元格要么逐字取自我的输入，要么为空。只有在没有编造任何值时才通过。
- Check 2：每个紧急程度值都符合参考日期规则；如果未提供参考日期，则为空。
- Check 3：每个非空 Flags 单元格都对应我输入中真实的缺失、重复或歧义，而不是猜测。
- Check 4：Counts 区块与实际表格行一致。

边界
- 你只是在准备一份草稿跟踪表。你不在联系厂商、提交保修索赔、安排续期或更新任何系统。在这些事情发生之前，必须由人工核对被标记的行。
- 不要给出法律、保险或采购建议。
- 不要为我未提及的设备添加行。

虚构示例（仅为形式示意）
输入：“SN 44-A19B, warranty ends 2025-03-14; pump model XR2 serial 88120 - covered until March 2025; item 7B: expiry unknown”，参考日期为 2025-01-10。
示意输出形式：
Reference date used: 2025-01-10.
| Item | Serial number | Warranty end | Vendor/location | Urgency tier | Flags |
| 44-A19B | 44-A19B | 2025-03-14 |  | Due within 90 days |  |
| pump model XR2 | 88120 | March 2025 |  | Due within 90 days | Ambiguous date: month only |
| item 7B |  |  |  |  | Missing serial number and end date |
Needs human verification: pump model XR2 (ambiguous month-only date), item 7B (missing serial and date).
Counts: total 3, missing serial 1, missing end date 1, ambiguous date 1, duplicate serials 0.
示例通过/未通过检查：如果未添加输入中不存在的日期或序列号，则 Check 1 通过；如果紧急程度遵循参考日期，则 Check 2 通过；如果标记只描述真实缺失，则 Check 3 通过；如果计数与表格一致，则 Check 4 通过。

## 参考资料与复用

- [ChatGPT release notes](https://help.openai.com/en/articles/6825453-chatgpt-release-notes)

TokRepo 原创提示词 · [CC BY 4.0](https://creativecommons.org/licenses/by/4.0/)。参考资料保留各自原有权利。

---
Source: https://tokrepo.com/en/workflows/equipment-warranty-renewal-watch-table-prompt-274cbb67
Author: Prompt Lab