「効いた気がする」を卒業する。AI効果シミュレータを5ファイルでつくり、社内で使える形にするまで

<!doctype html>
<html lang="ja">
<head>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <meta name="description" content="AI導入による月間の時間効果と換算価値を試算します。">
  <title>5ファイル効果シミュレータ</title>
  <link rel="stylesheet" href="./style.css">
  <script src="./app.js" defer></script>
</head>
<body>
  <main class="shell">
    <header>
      <p class="eyebrow">AI導入の効果を数字で概算</p>
      <h1>5ファイル効果シミュレータ</h1>
      <p class="lead">入力値はブラウザ内だけで計算され、保存・送信されません。</p>
    </header>

    <form id="effect-form" novalidate>
      <section class="panel inputs" aria-labelledby="input-heading">
        <h2 id="input-heading">入力</h2>
        <div class="field-grid">
          <label>対象人数<input id="people" name="people" type="number" min="0" step="1" value="5" required inputmode="numeric"><span>人</span></label>
          <label>1人あたり週時間<input id="weeklyHours" name="weeklyHours" type="number" min="0" step="0.1" value="3" required inputmode="decimal"><span>時間</span></label>
          <label>短縮率<input id="reductionRate" name="reductionRate" type="number" step="0.1" value="40" required inputmode="decimal"><span>%</span></label>
          <label>時給<input id="hourlyRate" name="hourlyRate" type="number" min="0" step="1" value="3000" required inputmode="numeric"><span>円</span></label>
          <label>AI月額費<input id="monthlyAiCost" name="monthlyAiCost" type="number" min="0" step="1" value="20000" required inputmode="numeric"><span>円</span></label>
          <label>初期費用<input id="initialCost" name="initialCost" type="number" min="0" step="1" value="100000" required inputmode="numeric"><span>円</span></label>
        </div>
        <p id="form-error" class="error" role="alert" aria-live="assertive"></p>
        <button type="submit">計算する</button>
      </section>

      <section class="panel" aria-labelledby="result-heading" aria-live="polite">
        <h2 id="result-heading">月間の試算</h2>
        <dl class="results">
          <div><dt>削減時間</dt><dd id="savedHours">25.8時間</dd></div>
          <div><dt>換算価値</dt><dd id="timeValue">77,400円</dd></div>
          <div><dt>AI月額費を差し引いた換算価値</dt><dd id="netValue">57,400円</dd></div>
          <div><dt>参考回収期間</dt><dd id="paybackMonths">1.74か月</dd></div>
        </dl>
        <p class="note">換算価値は、短縮できた時間を時給で換算した参考値です。現金支出の削減額ではありません。</p>
      </section>
    </form>
  </main>
</body>
</html>

:root {
  color-scheme: light;
  --ink: #132238;
  --muted: #516071;
  --paper: #ffffff;
  --wash: #eef4f8;
  --accent: #075985;
  --accent-dark: #0c4a6e;
  --danger: #b42318;
  --line: #c9d7e2;
  font-family: system-ui, -apple-system, BlinkMacSystemFont, "Segoe UI", sans-serif;
}

* { box-sizing: border-box; }
body { margin: 0; color: var(--ink); background: linear-gradient(145deg, #e9f5fb, var(--wash)); }
.shell { width: min(100% - 2rem, 62rem); margin-inline: auto; padding: 3rem 0 4rem; }
header { max-width: 44rem; margin-bottom: 1.5rem; }
h1 { margin: .25rem 0 .75rem; font-size: clamp(2rem, 5vw, 3.6rem); line-height: 1.08; }
h2 { margin-top: 0; }
.eyebrow { margin: 0; color: var(--accent); font-weight: 800; letter-spacing: .08em; text-transform: uppercase; }
.lead, .note { color: var(--muted); line-height: 1.7; }
form { display: grid; grid-template-columns: 1.1fr .9fr; gap: 1rem; align-items: start; }
.panel { background: var(--paper); border: 1px solid var(--line); border-radius: 1.2rem; padding: clamp(1.2rem, 3vw, 2rem); box-shadow: 0 1rem 2.5rem rgb(19 34 56 / 8%); }
.field-grid { display: grid; grid-template-columns: repeat(2, minmax(0, 1fr)); gap: 1rem; }
label { display: grid; grid-template-columns: 1fr auto; gap: .35rem .5rem; font-weight: 700; }
label input { grid-column: 1; width: 100%; margin-top: .35rem; border: 1px solid #8094a5; border-radius: .65rem; padding: .8rem; font: inherit; }
label span { grid-column: 2; align-self: end; padding-bottom: .8rem; color: var(--muted); }
input:focus-visible, button:focus-visible { outline: 3px solid #38bdf8; outline-offset: 2px; }
input[aria-invalid="true"] { border-color: var(--danger); }
button { width: 100%; margin-top: 1rem; border: 0; border-radius: .75rem; padding: .9rem 1rem; background: var(--accent); color: white; font: inherit; font-weight: 800; cursor: pointer; }
button:hover { background: var(--accent-dark); }
.error { min-height: 1.5em; margin: .8rem 0 0; color: var(--danger); font-weight: 700; }
.results { margin: 0; }
.results div { display: flex; justify-content: space-between; gap: 1rem; padding: 1rem 0; border-bottom: 1px solid var(--line); }
.results dt { color: var(--muted); }
.results dd { margin: 0; font-size: 1.15rem; font-weight: 850; text-align: right; }

@media (max-width: 720px) {
  .shell { width: min(100% - 1rem, 40rem); padding-top: 1.5rem; }
  form, .field-grid { grid-template-columns: 1fr; }
  .panel { border-radius: .9rem; }
}

@media (prefers-reduced-motion: reduce) { * { scroll-behavior: auto !important; } }

(function (root) {
  "use strict";

  const FIELD_LABELS = {
    people: "対象人数", weeklyHours: "1人あたり週時間", reductionRate: "短縮率",
    hourlyRate: "時給", monthlyAiCost: "AI月額費", initialCost: "初期費用"
  };
  const NON_NEGATIVE = new Set(["people", "weeklyHours", "hourlyRate", "monthlyAiCost", "initialCost"]);

  function parseInputs(raw) {
    const values = {};
    for (const key of Object.keys(FIELD_LABELS)) {
      const text = String(raw[key] ?? "").trim();
      if (text === "") throw new Error(`${FIELD_LABELS[key]}を入力してください。`);
      const value = Number(text);
      if (!Number.isFinite(value)) throw new Error(`${FIELD_LABELS[key]}は有限の数値で入力してください。`);
      if (NON_NEGATIVE.has(key) && value < 0) throw new Error(`${FIELD_LABELS[key]}は0以上で入力してください。`);
      if (key === "reductionRate" && value > 100) throw new Error("短縮率は100以下で入力してください。");
      values[key] = value;
    }
    return values;
  }

  function calculateEffect(input) {
    const monthlyHours = input.people * input.weeklyHours * (input.reductionRate / 100) * 4.3;
    const timeValue = monthlyHours * input.hourlyRate;
    const netValue = timeValue - input.monthlyAiCost;
    const result = {
      monthlyHours,
      timeValue,
      netValue,
      paybackMonths: netValue > 0 ? input.initialCost / netValue : null
    };
    if (![result.monthlyHours, result.timeValue, result.netValue].every(Number.isFinite) ||
        (result.paybackMonths !== null && !Number.isFinite(result.paybackMonths))) {
      throw new Error("計算結果が扱える範囲を超えました。入力値を小さくしてください。");
    }
    return result;
  }

  function formatNumber(value, digits) {
    return new Intl.NumberFormat("ja-JP", { maximumFractionDigits: digits }).format(value);
  }

  function mount(doc) {
    const form = doc.getElementById("effect-form");
    if (!form) return false;
    const error = doc.getElementById("form-error");

    function render(event) {
      if (event) event.preventDefault();
      for (const input of form.querySelectorAll("input")) input.removeAttribute("aria-invalid");
      try {
        const raw = Object.fromEntries(Object.keys(FIELD_LABELS).map((key) => [key, doc.getElementById(key).value]));
        const result = calculateEffect(parseInputs(raw));
        doc.getElementById("savedHours").textContent = `${formatNumber(result.monthlyHours, 2)}時間`;
        doc.getElementById("timeValue").textContent = `${formatNumber(result.timeValue, 0)}円`;
        doc.getElementById("netValue").textContent = `${formatNumber(result.netValue, 0)}円`;
        doc.getElementById("paybackMonths").textContent = result.paybackMonths === null ? "回収見込みなし" : `${formatNumber(result.paybackMonths, 2)}か月`;
        error.textContent = "";
      } catch (problem) {
        for (const id of ["savedHours", "timeValue", "netValue", "paybackMonths"]) doc.getElementById(id).textContent = "—";
        error.textContent = problem.message;
        const key = Object.keys(FIELD_LABELS).find((name) => problem.message.startsWith(FIELD_LABELS[name]));
        if (key) doc.getElementById(key).setAttribute("aria-invalid", "true");
      }
    }

    form.addEventListener("submit", render);
    render();
    return true;
  }

  const api = { parseInputs, calculateEffect, formatNumber, mount };
  if (typeof module !== "undefined" && module.exports) module.exports = api;
  if (root) root.EffectSimulator = api;
  if (typeof document !== "undefined") {
    if (document.readyState === "loading") document.addEventListener("DOMContentLoaded", () => mount(document));
    else mount(document);
  }
})(typeof globalThis !== "undefined" ? globalThis : this);

export default {
  async fetch(request, env) {
    const url = new URL(request.url);
    if (url.pathname === "/api/health") {
      return Response.json({ ok: true, service: "effect-simulator" }, {
        headers: { "cache-control": "no-store" }
      });
    }
    if (env && env.ASSETS && typeof env.ASSETS.fetch === "function") {
      return env.ASSETS.fetch(request);
    }
    return Response.json({ ok: false, error: "assets_binding_unavailable" }, { status: 503 });
  }
};

name = "five-file-effect-simulator"
main = "worker.js"
compatibility_date = "2026-09-18"

[assets]
directory = "./public"
binding = "ASSETS"
run_worker_first = ["/api/*"]

#!/usr/bin/env python3
"""既知の入力値を式へ代入し、期待値との差を検算する。"""
import argparse
import math


def calculate(people, weekly_hours, reduction_rate, hourly_rate, monthly_ai_cost, initial_cost):
    values = (people, weekly_hours, reduction_rate, hourly_rate, monthly_ai_cost, initial_cost)
    if not all(math.isfinite(value) for value in values):
        raise ValueError("入力は有限の数値にしてください")
    monthly_hours = people * weekly_hours * reduction_rate / 100 * 4.3
    time_value = monthly_hours * hourly_rate
    net_value = time_value - monthly_ai_cost
    payback = initial_cost / net_value if net_value > 0 else None
    return monthly_hours, time_value, net_value, payback


def main():
    parser = argparse.ArgumentParser()
    parser.add_argument("--tolerance", type=float, default=1e-9)
    args = parser.parse_args()
    actual = calculate(5, 3, 40, 3000, 20000, 100000)
    expected = (25.8, 77400.0, 57400.0, 100000 / 57400)
    for label, got, want in zip(("時間", "換算価値", "差引換算", "回収月"), actual, expected):
        if not math.isclose(got, want, rel_tol=args.tolerance, abs_tol=args.tolerance):
            raise SystemExit(f"NG {label}: got={got}, expected={want}")
        print(f"OK {label}: {got}")


if __name__ == "__main__":
    main()

#!/usr/bin/env python3
"""条件を揃えた導入前 baseline_minutes と導入後 actual_minutes を月別集計する。"""
import argparse
import csv
import math
from collections import defaultdict
from datetime import date


def number(row, key, line):
    text = (row.get(key) or "").strip()
    try:
        value = float(text)
    except ValueError as exc:
        raise ValueError(f"{line}行目の{key}が数値ではありません") from exc
    if not math.isfinite(value) or value < 0:
        raise ValueError(f"{line}行目の{key}は0以上の有限値にしてください")
    return value


def aggregate(path):
    totals = defaultdict(lambda: [0, 0.0, 0.0])
    with open(path, newline="", encoding="utf-8-sig") as handle:
        reader = csv.DictReader(handle)
        required = {"date", "baseline_minutes", "actual_minutes"}
        if not required.issubset(reader.fieldnames or []):
            raise ValueError("CSV列は date,baseline_minutes,actual_minutes が必須です")
        for line, row in enumerate(reader, 2):
            day = date.fromisoformat((row.get("date") or "").strip())
            planned = number(row, "baseline_minutes", line)
            actual = number(row, "actual_minutes", line)
            bucket = totals[day.strftime("%Y-%m")]
            bucket[0] += 1
            bucket[1] += planned
            bucket[2] += actual
    return totals


def main():
    parser = argparse.ArgumentParser()
    parser.add_argument("csv_file")
    args = parser.parse_args()
    print("month,count,baseline_hours,actual_hours,saved_hours,saved_rate_percent")
    for month, (count, planned, actual) in sorted(aggregate(args.csv_file).items()):
        saved = planned - actual
        rate = f"{saved / planned * 100:.2f}" if planned else ""
        print(f"{month},{count},{planned/60:.2f},{actual/60:.2f},{saved/60:.2f},{rate}")


if __name__ == "__main__":
    main()

#!/usr/bin/env python3
"""人数・週時間・短縮率の組合せ別に月間効果をCSV出力する。"""
import argparse
import csv
import itertools
import math
import sys


def csv_numbers(text):
    values = [float(part.strip()) for part in text.split(",") if part.strip()]
    if not values or not all(math.isfinite(value) for value in values):
        raise argparse.ArgumentTypeError("カンマ区切りの有限数値を指定してください")
    return values


def main():
    parser = argparse.ArgumentParser()
    parser.add_argument("--people", type=csv_numbers, default=[3, 5, 10])
    parser.add_argument("--weekly-hours", type=csv_numbers, default=[1, 3, 5])
    parser.add_argument("--rates", type=csv_numbers, default=[20, 40, 60])
    parser.add_argument("--hourly-rate", type=float, default=3000)
    parser.add_argument("--monthly-ai-cost", type=float, default=20000)
    args = parser.parse_args()
    if not math.isfinite(args.hourly_rate) or not math.isfinite(args.monthly_ai_cost):
        parser.error("単価と月額費は有限数値にしてください")
    if any(value < 0 for value in args.people + args.weekly_hours):
        parser.error("人数と週時間は0以上にしてください")
    if any(value > 100 for value in args.rates):
        parser.error("短縮率は100以下にしてください（負値は許容）")
    if args.hourly_rate < 0 or args.monthly_ai_cost < 0:
        parser.error("単価と月額費は0以上にしてください")
    writer = csv.writer(sys.stdout, lineterminator="\n")
    writer.writerow(["people", "weekly_hours", "reduction_rate", "monthly_hours", "time_value", "net_value"])
    for people, hours, rate in itertools.product(args.people, args.weekly_hours, args.rates):
        monthly = people * hours * rate / 100 * 4.3
        value = monthly * args.hourly_rate
        writer.writerow([people, hours, rate, round(monthly, 2), round(value), round(value - args.monthly_ai_cost)])


if __name__ == "__main__":
    main()

#!/usr/bin/env python3
"""指定週の実測記録CSVテンプレートを生成する。"""
import argparse
import csv
from datetime import date, timedelta
from pathlib import Path


def main():
    parser = argparse.ArgumentParser()
    parser.add_argument("--start", default=date.today().isoformat(), help="週の開始日 YYYY-MM-DD")
    parser.add_argument("--output", default="weekly-log.csv")
    args = parser.parse_args()
    start = date.fromisoformat(args.start)
    output = Path(args.output)
    with output.open("w", newline="", encoding="utf-8-sig") as handle:
        writer = csv.writer(handle)
        writer.writerow(["date", "task", "baseline_minutes", "actual_minutes", "note"])
        for offset in range(7):
            writer.writerow([(start + timedelta(days=offset)).isoformat(), "", "", "", ""])
    print(output.resolve())


if __name__ == "__main__":
    main()

#!/usr/bin/env python3
"""実測CSVから人が読める月報Markdownを生成する。"""
import argparse
import csv
import math
from collections import defaultdict
from datetime import date
from pathlib import Path


def read_rows(path):
    months = defaultdict(lambda: {"count": 0, "planned": 0.0, "actual": 0.0})
    with open(path, newline="", encoding="utf-8-sig") as handle:
        reader = csv.DictReader(handle)
        required = {"date", "baseline_minutes", "actual_minutes"}
        if not required.issubset(reader.fieldnames or []):
            raise ValueError("必須列: date,baseline_minutes,actual_minutes")
        for line, row in enumerate(reader, 2):
            month = date.fromisoformat((row["date"] or "").strip()).strftime("%Y-%m")
            try:
                planned, actual = float(row["baseline_minutes"]), float(row["actual_minutes"])
            except ValueError as exc:
                raise ValueError(f"{line}行目の時間が数値ではありません") from exc
            if not all(math.isfinite(v) and v >= 0 for v in (planned, actual)):
                raise ValueError(f"{line}行目の時間は0以上の有限値にしてください")
            months[month]["count"] += 1
            months[month]["planned"] += planned
            months[month]["actual"] += actual
    return months


def main():
    parser = argparse.ArgumentParser()
    parser.add_argument("csv_file")
    parser.add_argument("--hourly-rate", type=float, default=3000)
    parser.add_argument("--output", default="monthly-report.md")
    args = parser.parse_args()
    if not math.isfinite(args.hourly_rate) or args.hourly_rate < 0:
        parser.error("時給は0以上の有限値にしてください")
    lines = ["# AI活用 実測月報", "", "換算価値は現金削減額ではなく、時間を時給換算した参考値です。", ""]
    for month, data in sorted(read_rows(args.csv_file).items()):
        saved_hours = (data["planned"] - data["actual"]) / 60
        lines += [f"## {month}", "", f"- 記録件数: {data['count']}件", f"- 削減時間: {saved_hours:.2f}時間", f"- 換算価値: {saved_hours * args.hourly_rate:,.0f}円", ""]
    output = Path(args.output)
    output.write_text("\n".join(lines), encoding="utf-8")
    print(output.resolve())


if __name__ == "__main__":
    main()