MFG Calcs Workbook API

The Workbook API from MFG Calcs — 2 operation(s) for workbook.

GitHub OpenAPI

Operations 2

GET /api/workbook/{slug}.xlsx Download a calculator as an Excel workbook #
POST /api/workbook Export current V2 inputs and calculated scenarios to Excel #

Work with this as data

Every API here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for apis

7 MCP tools reach this
  • 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.
All 92 tools →

Call it yourself

curl for this page
This API
curl "https://apis.io/api/v1/apis/mfgcalcs-com:mfgcalcs-com-workbook-api"
All apis
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.

Get an API 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 Specification

mfgcalcs-com-workbook-api-openapi.yml Raw ↑
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