油脂加工製品のサンプル依頼・発送待ち表 / Processed Fats and Oils Product Sample Request and Pending Shipment Tracker

「油脂加工製品のサンプル依頼・発送待ち表」は、少人数で対応する脂肪酸・グリセリンメーカーの営業窓口向けに企画中のExcelテンプレートです。依頼内容、社内手配、発送実績を明細ごとに記録し、発送待ち製品を一覧で確認する構成を想定しています。 製品A・Bを各100g依頼され、Aだけ発送した場合、Aは「発送済み」、Bは「発送待ち」とし、依頼全体を完了にしません。社内手配と実際の発送を区別し、発送記録が不足する明細は「発送情報要確認」として残します。原資料や出荷担当に確認し、お問い合わせ時に製品別の状況と次の確認事項を整理するための表です。 基本は1窓口・1か月、Excel画面上での確認を想定。発送状況は手入力で、メール・配送状況との自動連携はありません。品質・輸送条件は従来の手順で判断してください。製作・動作検証前の企画段階です。 お仕事の依頼：ramaya08010801@gmail.com Sample Request & Pending Shipment Tracker for Oil and Fat Products A planned Excel workbook for small fatty acid and glycerin sales desks answering sample shipment inquiries. Track requests, internal arrangements and shipments by item, and review pending products. Customer names and addresses remain in the original request, avoiding re-entry. If A and B are requested at 100 g each and only A ships, A is shipped and B stays pending; the whole request is not complete. Internal arrangements do not count as shipment. Shipment date, responsible person and shipping document reference are required; incomplete details remain flagged for checking against source records or with the shipping team. This helps clarify each product's status and what to confirm when replying. Planned format: macro-free .xlsx, one sales desk and one month's requests, one editor at a time, on-screen review. Each entry is a quantity intended to ship in full at once. Intended environment: local file in Japanese-language Microsoft 365 desktop Excel (64-bit), Windows 11. Scope: sample requests and shipment tracking. Excludes stock allocation, email/carrier integration, printing and decisions on suitability, quality, safety documentation or transport conditions. Still at planning stage; production, usability and compatibility testing are not complete. Work inquiries/collaborations: ramaya08010801@gmail.com