Skip to content
SlashClone
DiscoverUse in ClaudeSubmit a link
Sign in
Made by@agentcosts

Llm usage normalizer

@agentcosts/llm-usage-normalizer

Convert Anthropic and OpenAI usage exports, or your own app's token logs, into one usage schema with customers, tasks, cached and uncached tokens, and cost from a price table you edit. Fixes the classic mistake of counting cached tokens twice, and lists unmapped keys and unpriced models.

SkillDatav1.0.0 (latest)Tested
Use in Claude Save Like Clone Comment
Activity
New: be the first to try it
  1. 1// Small helpers shared by this kit's scripts. Node built-ins only.
  2. 2import { existsSync, mkdirSync, readFileSync, writeFileSync } from "node:fs";
  3. 3import { dirname } from "node:path";
  4. 4
  5. 5export function fail(message) {
  6. 6 process.stderr.write(`Error: ${message}\n`);
  7. 7 process.exit(1);
  8. 8}
  9. 9
  10. 10/** Parses argv into { _: [positional], flag: value }. Flags without a value become true. */
  11. 11export function parseArgs(argv, booleans = []) {
  12. 12 const out = { _: [] };
  13. 13 for (let i = 0; i < argv.length; i++) {
  14. 14 const a = argv[i];
  15. 15 if (a.startsWith("--")) {
  16. 16 const eq = a.indexOf("=");
  17. 17 if (eq !== -1) out[a.slice(2, eq)] = a.slice(eq + 1);
  18. 18 else if (booleans.includes(a.slice(2))) out[a.slice(2)] = true;
  19. 19 else {
  20. 20 const next = argv[i + 1];
  21. 21 if (next === undefined || next.startsWith("--")) out[a.slice(2)] = true;
  22. 22 else {
  23. 23 out[a.slice(2)] = next;
  24. 24 i++;
  25. 25 }
  26. 26 }
  27. 27 } else out._.push(a);
  28. 28 }
  29. 29 return out;
  30. 30}
  31. 31
  32. 32export function readText(path, what = "file") {
  33. 33 if (!path) fail(`no ${what} given.`);
  34. 34 if (!existsSync(path)) fail(`${what} not found: ${path}`);
  35. 35 return readFileSync(path, "utf8").replace(/^\uFEFF/, "");
  36. 36}
  37. 37
  38. 38export function readJson(path, what = "JSON file") {
  39. 39 const text = readText(path, what);
  40. 40 try {
  41. 41 return JSON.parse(text);
  42. 42 } catch (e) {
  43. 43 return fail(`${path} is not valid JSON (${e.message}).`);
  44. 44 }
  45. 45}
  46. 46
  47. 47/** RFC 4180 CSV parser. Returns { header, rows } where rows are objects keyed by trimmed header. */
  48. 48export function parseCsv(text) {
  49. 49 const raw = [];
  50. 50 let row = [];
  51. 51 let field = "";
  52. 52 let quoted = false;
  53. 53 const pushRow = () => {
  54. 54 row.push(field);
  55. 55 field = "";
  56. 56 if (row.some((v) => v.trim() !== "")) raw.push(row);
  57. 57 row = [];
  58. 58 };
  59. 59 for (let i = 0; i < text.length; i++) {
  60. 60 const ch = text[i];
  61. 61 if (quoted) {
  62. 62 if (ch === '"' && text[i + 1] === '"') {
  63. 63 field += '"';
  64. 64 i++;
  65. 65 } else if (ch === '"') quoted = false;
  66. 66 else field += ch;
  67. 67 } else if (ch === '"') quoted = true;
  68. 68 else if (ch === ",") {
  69. 69 row.push(field);
  70. 70 field = "";
  71. 71 } else if (ch === "\n" || ch === "\r") {
  72. 72 if (ch === "\r" && text[i + 1] === "\n") i++;
  73. 73 pushRow();
  74. 74 } else field += ch;
  75. 75 }
  76. 76 if (field !== "" || row.length) pushRow();
  77. 77 const [head = [], ...body] = raw;
  78. 78 const header = head.map((h) => h.trim());
  79. 79 const rows = body.map((r) => {
  80. 80 const rec = {};
  81. 81 header.forEach((h, i) => {
  82. 82 rec[h] = (r[i] ?? "").trim();
  83. 83 });
  84. 84 return rec;
  85. 85 });
  86. 86 return { header, rows };
  87. 87}
  88. 88
  89. 89export function readCsv(path, what = "CSV file", required = []) {
  90. 90 const { header, rows } = parseCsv(readText(path, what));
  91. 91 const lower = header.map((h) => h.toLowerCase());
  92. 92 const missing = required.filter((c) => !lower.includes(c.toLowerCase()));
  93. 93 if (missing.length)
  94. 94 fail(
  95. 95 `${path} is missing column(s): ${missing.join(", ")}. Found: ${header.join(", ") || "(no header)"}.`,
  96. 96 );
  97. 97 // Normalize keys to lowercase so "Amount" and "amount" both work.
  98. 98 return rows.map((r) => {
  99. 99 const o = {};
  100. 100 for (const [k, v] of Object.entries(r)) o[k.toLowerCase()] = v;
  101. 101 return o;
  102. 102 });
  103. 103}
  104. 104
  105. 105export function csvCell(v) {
  106. 106 const s = v === null || v === undefined ? "" : String(v);
  107. 107 return /[",\n\r]/.test(s) ? `"${s.replace(/"/g, '""')}"` : s;
  108. 108}
  109. 109
  110. 110export function toCsv(rows, columns) {
  111. 111 const lines = [columns.map(csvCell).join(",")];
  112. 112 for (const r of rows) lines.push(columns.map((c) => csvCell(r[c])).join(","));
  113. 113 return lines.join("\n") + "\n";
  114. 114}
  115. 115
  116. 116/** "$1,234.50", "(12.00)", "-3", "" -> number. Empty or junk -> NaN. */
  117. 117export function num(v) {
  118. 118 if (v === null || v === undefined) return NaN;
  119. 119 let s = String(v).trim();
  120. 120 if (s === "") return NaN;
  121. 121 let neg = false;
  122. 122 if (/^\(.*\)$/.test(s)) {
  123. 123 neg = true;
  124. 124 s = s.slice(1, -1);
  125. 125 }
  126. 126 s = s.replace(/[$€£,\s%]/g, "");
  127. 127 if (s.endsWith("-")) {
  128. 128 neg = !neg;
  129. 129 s = s.slice(0, -1);
  130. 130 }
  131. 131 const n = Number(s);
  132. 132 if (!Number.isFinite(n)) return NaN;
  133. 133 return neg ? -n : n;
  134. 134}
  135. 135
  136. 136export function num0(v) {
  137. 137 const n = num(v);
  138. 138 return Number.isNaN(n) ? 0 : n;
  139. 139}
  140. 140
  141. 141export function round(n, digits = 2) {
  142. 142 const f = 10 ** digits;
  143. 143 return Math.round((n + Number.EPSILON) * f) / f;
  144. 144}
  145. 145
  146. 146export function money(n, digits = 0) {
  147. 147 if (!Number.isFinite(n)) return "n/a";
  148. 148 const s = Math.abs(n).toLocaleString("en-US", {
  149. 149 minimumFractionDigits: digits,
  150. 150 maximumFractionDigits: digits,
  151. 151 });
  152. 152 return `${n < 0 ? "-" : ""}$${s}`;
  153. 153}
  154. 154
  155. 155export function pct(n, digits = 1) {
  156. 156 if (!Number.isFinite(n)) return "n/a";
  157. 157 return `${(n * 100).toFixed(digits)}%`;
  158. 158}
  159. 159
  160. 160export function writeOut(path, content) {
  161. 161 mkdirSync(dirname(path), { recursive: true });
  162. 162 writeFileSync(path, content);
  163. 163}
  164. 164
  165. 165/** Accepts 2026-10-03, 2026-10-03T12:00:00Z, 10/03/2026, or unix seconds. Returns a Date (UTC) or null. */
  166. 166export function parseDate(v) {
  167. 167 if (v === null || v === undefined) return null;
  168. 168 const s = String(v).trim();
  169. 169 if (!s) return null;
  170. 170 if (/^\d{9,10}$/.test(s)) return new Date(Number(s) * 1000);
  171. 171 if (/^\d{12,13}$/.test(s)) return new Date(Number(s));
  172. 172 let m = s.match(/^(\d{4})-(\d{2})(?:-(\d{2}))?$/);
  173. 173 if (m) return new Date(Date.UTC(+m[1], +m[2] - 1, m[3] ? +m[3] : 1));
  174. 174 m = s.match(/^(\d{1,2})\/(\d{1,2})\/(\d{2,4})$/);
  175. 175 if (m) {
  176. 176 const y = m[3].length === 2 ? 2000 + +m[3] : +m[3];
  177. 177 return new Date(Date.UTC(y, +m[1] - 1, +m[2]));
  178. 178 }
  179. 179 const d = new Date(s);
  180. 180 return Number.isNaN(d.getTime()) ? null : d;
  181. 181}
  182. 182
  183. 183export const DAY_MS = 86400000;
  184. 184
  185. 185export function dayKey(d) {
  186. 186 return d.toISOString().slice(0, 10);
  187. 187}
  188. 188
  189. 189export function monthKey(d) {
  190. 190 return d.toISOString().slice(0, 7);
  191. 191}
  192. 192
  193. 193/** Monday of the ISO week containing d, as YYYY-MM-DD. */
  194. 194export function weekKey(d) {
  195. 195 const day = (d.getUTCDay() + 6) % 7;
  196. 196 return dayKey(new Date(Date.UTC(d.getUTCFullYear(), d.getUTCMonth(), d.getUTCDate() - day)));
  197. 197}
  198. 198
  199. 199export function addMonths(key, n) {
  200. 200 const [y, m] = key.split("-").map(Number);
  201. 201 const d = new Date(Date.UTC(y, m - 1 + n, 1));
  202. 202 return monthKey(d);
  203. 203}
  204. 204
  205. 205export function monthsBetween(a, b) {
  206. 206 const [ya, ma] = a.split("-").map(Number);
  207. 207 const [yb, mb] = b.split("-").map(Number);
  208. 208 return (yb - ya) * 12 + (mb - ma);
  209. 209}
  210. 210
  211. 211export function median(values) {
  212. 212 const v = values.filter(Number.isFinite).sort((a, b) => a - b);
  213. 213 if (!v.length) return NaN;
  214. 214 const mid = Math.floor(v.length / 2);
  215. 215 return v.length % 2 ? v[mid] : (v[mid - 1] + v[mid]) / 2;
  216. 216}
  217. 217
  218. 218export function sum(values) {
  219. 219 return values.reduce((a, b) => a + (Number.isFinite(b) ? b : 0), 0);
  220. 220}
  221. 221
  222. 222export function mdTable(columns, rows) {
  223. 223 const head = `| ${columns.join(" | ")} |`;
  224. 224 const sep = `| ${columns.map(() => "---").join(" | ")} |`;
  225. 225 const body = rows.map((r) => `| ${r.map((c) => String(c).replace(/\|/g, "/")).join(" | ")} |`);
  226. 226 return [head, sep, ...body].join("\n");
  227. 227}
  228. 228
  229. 229export function escapeHtml(s) {
  230. 230 return String(s)
  231. 231 .replace(/&/g, "&amp;")
  232. 232 .replace(/</g, "&lt;")
  233. 233 .replace(/>/g, "&gt;")
  234. 234 .replace(/"/g, "&quot;");
  235. 235}
Sign in to comment on a line