MFG Calcs Workbook API
The Workbook API from MFG Calcs — 2 operation(s) for workbook.
The Workbook API from MFG Calcs — 2 operation(s) for workbook.
Every API here is available over the APIs.io API and to AI agents over MCP.
One button, every client — Claude, Cursor, VS Code and the rest.
https://apis.io/mcp
find_apisBrowse and filter every API in the catalog.get_api_artifactsOne API's artifacts, grouped by type.get_openapiThe primary OpenAPI for this API.find_similar_apisAPIs that look like this one.apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.resolveTurn a domain, URL or GitHub org into the provider it belongs to.find_cohortsEvery scored population of providers in the catalog.curl "https://apis.io/api/v1/apis/mfgcalcs-com:mfgcalcs-com-workbook-api"
curl "https://apis.io/api/v1/apis?limit=25"
Calls without X-API-Key need no key. Calls with it need a paid plan — get a key.
Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. By signing up you are subscribing to the APIs.io and API Evangelist newsletters — you can unsubscribe from any issue. See our Privacy Policy and Terms.
A second provider on the same verified email joins the account you already have.
openapi: 3.2.0
info:
title: MFG Calcs Manufacturing Data and Calculation Workbook API
version: 1.0.0
description: 'The whole mfgcalcs.com platform over HTTP, keyless. 34 data endpoints serve live U.S. manufacturing intelligence: the effective calculated-duty index and estimate, per-family effective-rate gap and statutory duty-free line coverage, sourcing shifts and concentration, customs unit-value movers, the cost-pressure index and its diffusion, manufacturing PMI, state cost indices, the wage board, six-month forecasts with their own accuracy ledger, reshoring readiness and indexed break-even comparisons, and an exact linear-programming sourcing optimizer. Alongside them: 5,384 deterministic manufacturing calculators, one search across everything the site knows, and an answer endpoint that returns a scoped, source-dated answer or a structured clarification request for a natural-language question.
Everything is computed from committed public data (USITC, BLS, EIA, Census, BEA) rather than a model, so identical inputs always return identical output. The trust surfaces are part of the API, not a footnote: /api/vintages recovers what any series said on a past date, /api/revisions records every restatement, /api/provenance publishes artifact hashes, and /api/receipts carries Ed25519 signatures. Free with attribution (CC BY 4.0) and no key, ever. An MCP server exposing the same engines as tools for AI agents is at https://www.mfgcalcs.com/api/mcp.
VERSIONING: every path below is also served under /api/v1/ — e.g. https://www.mfgcalcs.com/api/v1/manufacturing-pmi. Prefer the /api/v1 form in code you intend to keep: v1''s response shapes are frozen (fields keep their name, type and meaning; new fields may be added, so ignore unknown ones), and any breaking change ships as /api/v2 instead of altering v1. The unversioned paths are permanent aliases and will not be removed. Responses carry an X-API-Version header. See https://www.mfgcalcs.com/developers and docs/methodology/API_VERSIONING.md.'
contact:
url: https://www.mfgcalcs.com/contact-us
servers:
- url: https://www.mfgcalcs.com
tags:
- name: Workbook
paths:
/api/workbook/{slug}.xlsx:
get:
operationId: workbook
summary: Download a calculator as an Excel workbook
description: Branded .xlsx with editable inputs; most calculators carry live, build-verified Excel formulas that recalculate as inputs change.
parameters:
- name: slug
in: path
required: true
schema:
type: string
responses:
'200':
description: Excel workbook
content:
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet:
schema:
type: string
format: binary
'404':
description: Unknown calculator slug.
tags:
- Workbook
/api/workbook:
post:
operationId: exportCalculatorScenarioWorkbook
summary: Export current V2 inputs and calculated scenarios to Excel
description: Private, no-store XLSX. Active V2 calculators only. The server recomputes supplied numeric inputs; client formulas/results are not accepted. Formula/workbook versions must match the active release. Request limit 128 KiB; combined batch and sensitivity comparisons at most 250 rows. Target and optimization sheets record supplied candidate solutions and do not rerun a solver in Excel. Native field units apply.
requestBody:
required: true
content:
application/json:
schema:
type: object
additionalProperties: false
properties:
slug:
type: string
minLength: 1
maxLength: 120
formulaVersion:
type: string
minLength: 1
maxLength: 120
workbookVersion:
type: string
minLength: 1
maxLength: 120
label:
type: string
minLength: 1
maxLength: 120
inputs:
type: object
maxProperties: 32
additionalProperties:
type: number
batch:
type: array
minItems: 1
maxItems: 250
items:
type: object
additionalProperties: false
properties:
label:
type: string
minLength: 1
maxLength: 120
inputs:
type: object
maxProperties: 32
additionalProperties:
type: number
required:
- inputs
sensitivity:
type: object
additionalProperties: false
properties:
inputKey:
type: string
minLength: 1
maxLength: 120
values:
type: array
minItems: 1
maxItems: 41
items:
type: number
secondInputKey:
type: string
minLength: 1
maxLength: 120
secondValues:
type: array
minItems: 1
maxItems: 41
items:
type: number
required:
- inputKey
- values
goal:
type: object
additionalProperties: false
properties:
inputKey:
type: string
minLength: 1
maxLength: 120
outputKey:
type: string
minLength: 1
maxLength: 120
target:
type: number
direction:
enum:
- atLeast
- atMost
- equal
tolerance:
type: number
minimum: 0
candidateInputs:
type: object
maxProperties: 32
additionalProperties:
type: number
required:
- inputKey
- outputKey
- target
- direction
- tolerance
- candidateInputs
optimization:
type: object
additionalProperties: false
properties:
objectiveKey:
type: string
minLength: 1
maxLength: 120
direction:
enum:
- minimize
- maximize
candidateInputs:
type: object
maxProperties: 32
additionalProperties:
type: number
required:
- objectiveKey
- direction
- candidateInputs
required:
- slug
- formulaVersion
- inputs
responses:
'200':
description: 'Personalized formula-driven workbook. Cache-Control: private, no-store.'
content:
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet:
schema:
type: string
format: binary
'400':
description: Malformed or unsupported request/input.
'409':
description: The requested calculation/workbook version has changed.
'413':
description: Request exceeds the body limit.
'422':
description: Unavailable V2 model or blocked baseline.
'429':
description: Rate limit or execution capacity exceeded.
tags:
- Workbook
externalDocs:
url: https://www.mfgcalcs.com/developers
description: Human documentation and MCP setup
x-mfgcalcs-preview:
status: preview-not-published
notice: MCP 2.0 preview documentation. These tools require an explicitly enabled preview deployment; this inventory does not activate them or prove that a hosted endpoint supports them. Read that endpoint's discovery response before calling.
metadata: /mcp-preview.json
schemaReference: /openapi-mcp-preview.json
examples: /mcp-preview-examples.json