発注・入荷管理テンプレート v0.1.0 制作チーム・個人事業向け。発注明細ごとの数量・入荷状況・予定日・発注額を1枚で手動管理します。 収録：英語表記Excelブック1点、Purchase receiptsシート1枚、空欄100行、日英ガイド、架空例と空欄の実物画像、変更履歴、利用条件。 使い方：Team / project、Review date（確認日）、Currency（通貨ラベル）を設定。1行＝1発注明細。琥珀色A:JへLine ID、Purchase order ID、Supplier、Item、Ordered date、Expected date、Qty ordered、Qty received、Unit price、Last receivedを入力します。K:Nは数式です。 Line IDは明細ごとに一意の文字列。Purchase order IDは同じ発注の複数明細で共用できます。IDは文字列で入力し、大文字小文字を同一視、*・?・~も文字そのものとして比較します。空欄・空白のみ・数値型IDは不備です。 数量は個数の整数。Qty orderedは1〜1000000、Qty receivedは0〜発注数。未入荷は空欄でなく0を入力します。Qty receivedは累計の手入力です。分納の都度合計を更新し、数量>0では最後の入荷日も入力。全数入荷していても入荷日未入力なら完了扱いになりません。入荷0では入荷日を空欄にします。 発注日は確認日以前、入荷予定日は発注日以降、最終入荷日は発注日以降かつ確認日以前。日付0・負数・小数・文字や順序の不備を検出します。Unit priceは0〜1000000000の数値。無料品は0、未入力は不備。全行で同じ通貨を使います。Currencyはラベルで、通貨換算・税計算はしません。 計算：Qty outstanding＝発注数−累計入荷数、Ordered value＝発注数×単価。上部で記録明細数・未完了・全数入荷・分納・期限超過・当日期限・発注額・入力不備を集計。確認日を毎回更新します。予定日当日はDue today、前日以前の残数量ありはReceipt overdue。入力不備や確認日欠損がある集計はn.a.。フィルターは表示行を変え、上部集計は一覧全体を対象にします。 1000行への拡張：ExcelでテーブルをA14:N1014へ拡張し、入力前にA114:J114をA115:J1014へコピーして入力規則・文字列ID書式・色を引き継ぎます。次にK114:N1014を選択してCtrl+Dで下方向コピー。入力はA15:J1014、数式列は上書きしません。1000件超は参照式の変更が必要です。 公開前検証：Artifact Toolの独立期待値、入力変更、保存再読込。Microsoft Excel16.0/Windowsで欠損・ゼロ・不正値、日付境界、文字列/重複/特殊文字ID、分納・全数入荷の条件、並べ替え・フィルター、配布ブックから実際に1000行へ拡張、最終行の入力規則・条件付き書式の反応、保存再読込。全1シート目視、数式エラー0。最終配布XLSXはメタデータ除去後にExcelで読み取り専用再読込。 制限：手入力の発注残管理。入荷取引の履歴台帳、返品・過入荷・取消・単位換算・税・支払/請求書照合・在庫残・自動通知・外部連携・マクロは含みません。数量は整数、単価の小数は使用可能。英語セル表記、日本語ガイド付き。配布ブックは空欄、画像は架空データ。Excel Mac/Web、Google Sheets、LibreOfficeは未検証。 1事業内の利用・改変可。テンプレート自体の外部再配布・再販売は禁止。同梱LICENSE.txt参照。 ZIP: purchase-orders-goods-receipts-v0.1.0.zip Purchase Orders and Goods Receipt Tracker v0.1.0 One worksheet for creative teams and independent businesses to manually review purchase-order lines, quantities, expected dates and order value. Includes one English XLSX, one Purchase receipts sheet,100 blank prepared rows, JA/EN guides, fictional-example/blank previews, changelog and license. Set Team / project, Review date and Currency label. Enter one order line per amber A:J row: unique text Line ID, text Purchase order ID, Supplier, Item, Ordered date, Expected date, Qty ordered, Qty received, Unit price and Last received. K:N are formulas. Different lines may share an order ID. IDs ignore letter case and compare *, ? and ~ literally. Blank/whitespace/numeric-typed IDs are invalid. Use whole quantities: ordered1..1000000 and received0..ordered. Enter explicit0 before receipt; blank is missing. Update received quantity cumulatively for partial deliveries and enter the most recent actual receipt date when quantity>0. Full quantity without its receipt date is not complete. Clear receipt date when quantity is0. Order date must be on/before review. Expected date must be on/after order. Last receipt date must be between order and review. Invalid/zero/fractional/text dates are flagged. Unit price0..1000000000;0 means free while blank means missing. Use one currency throughout; Currency is a label, with no conversion or tax logic. Outputs: outstanding quantity=ordered minus cumulative received; ordered value=ordered quantity times unit price. Whole-list summaries count tracked/outstanding/fully received/partial/overdue/today lines, order value and input issues. Due date is inclusive; outstanding lines become overdue the next day. Update Review date manually. Missing review or invalid rows show n.a. in dependent summaries. Filters do not change whole-list totals. Extend to1000 lines in Excel: resize the table to A14:N1014. Before entering data, copy A114:J114 into A115:J1014 to carry validation, text-ID format and colors. Select K114:N1014 and Fill Down (Ctrl+D). Input rows A15:J1014; do not overwrite formula columns. More than1000 requires reference edits. Verified with independent Artifact Tool expectations, recalculation and save/reimport. Microsoft Excel16.0/Windows: input changes, missing/zero/invalid values, date boundaries, duplicate/literal IDs, partial/full receipt prerequisites, sort/filter, actual1000-row extension from deliverable, final-row validation and reactive conditional colors, save/reopen. All1sheet visually reviewed, zero formula errors. Metadata-sanitized final XLSX reopened read-only in Excel. Manual outstanding-order tracker. No individual receipt transaction ledger, returns/overreceipts/cancellation, unit conversion, taxes, payment/invoice matching, stock balance, automated notifications, integrations or macros. Quantities are whole units; unit prices may be decimal. English cells, Japanese guide. Delivered inputs are blank; previews fictional. Excel Mac/Web, Google Sheets and LibreOffice untested. One-business internal use/modification allowed. No external redistribution/resale of the template itself. See LICENSE.txt. ZIP: purchase-orders-goods-receipts-v0.1.0.zip