中文版：请帮我制作一份专业的Excel库存盘点表。

表格需要包含商品编码、商品名称、规格、仓库、系统库存、实际盘点数量、盘盈数量、盘亏数量、采购单价、库存差异金额、盘点人员、盘点日期和备注。

自动计算实际库存与系统库存之间的差异。

当实际数量大于系统数量时计入盘盈，当实际数量小于系统数量时计入盘亏。

自动计算盘盈金额、盘亏金额和总库存差异金额。

使用条件格式突出数量差异较大的商品，并按照差异金额进行排序。

增加库存盘点汇总页面，展示盘点商品数量、盘盈商品数量、盘亏商品数量、盘盈金额和盘亏金额。

英文版：Create a professional Excel inventory stocktaking sheet.

Include product code, product name, specification, warehouse, system quantity, physical count, surplus quantity, shortage quantity, purchase price, inventory variance value, stocktaking employee, stocktaking date, and notes.

Automatically calculate the difference between system inventory and physical inventory.

If the physical quantity is greater than the system quantity, classify the difference as surplus. If it is lower, classify it as shortage.

Automatically calculate surplus value, shortage value, and total inventory variance.

Use conditional formatting to highlight products with significant quantity differences and sort them by variance value.

Add an inventory stocktaking summary showing total products counted, surplus products, shortage products, surplus value, and shortage value.

该提示词已在以下工具中验证有效：ChatGPT、Claude、Gemini、Copilot、WPS AI