Open-FDD ECM Engineering

open-fdd (PyPI 4.x) packages two complementary engineering surfaces:

  1. Enhanced Excel ECM workbook — the human-auditable source of truth.
  2. Independent Python benchmark functions — machine-friendly checks for AI agents, APIs and EnergyPlus comparisons.

The Python API fills the same workbook input cells a human engineer would fill. It does not replace the visible spreadsheet calculations.

Production FDD (DataFusion SQL fault detection) lives in the GHCR container stack, not this wheel.

Install

pip install open-fdd

For the FastAPI example:

pip install "open-fdd[ecm-web]"

Generate a workbook in a few lines

from open_fdd.ecm_engineering import ECMJob

job = (
    ECMJob("Lincoln Middle School")
    .set_global(
        area_ft2=85000,
        electric_rate=0.145,
        gas_rate=0.92,
    )
    .add_ecm(
        "static_pressure_reset",
        fan_kw=55.9,
        hours=4100,
        baseline_speed=0.82,
        proposed_speed=0.67,
    )
    .add_ecm(
        "boiler_reset",
        base_therms=48000,
        base_eff=0.86,
        prop_eff=0.92,
    )
)

job.save("Lincoln_Middle_School_ECMs.xlsx")

The resulting XLSX contains the engineering inputs and formulas for human review.

Independent benchmark

from open_fdd.ecm_engineering import ECMJob

job = ECMJob("demo")
result = job.calc(
    "fan_affinity",
    design_kw=55.9,
    hours=4100,
    baseline_speed_fraction=0.82,
    proposed_speed_fraction=0.67,
)

CLI

open-fdd-ecm calculators
open-fdd-ecm demo --out Demo_ECMs.xlsx

Engineering posture

Prefer measured BAS, utility, TAB, nameplate and manufacturer data over defaults. Generic chiller %/°F methods are screening proxies; manufacturer performance maps or calibrated EnergyPlus should replace them when stronger estimates are needed.

Project links

Data verified by PyPI on Jul 27, 2026
Data provided by the project maintainers, verified at the time the release was uploaded to PyPI.

Key dates

PyPI data
Data sourced directly from PyPI's database.
  • Released:
Newer release available (4.4.1)

1 maintainer

PyPI data
Data sourced directly from PyPI's database.
Avatar for bartlino from gravatar.com bartlino

Credits

Author: Ben Bartling

GitHub Statistics

Data verified by PyPI on Jul 27, 2026
The GitHub source repository was provided by the project maintainers and verified by PyPI at the time of upload. Stars, forks, and open issues/PRs are derived from that repository and have not been independently verified.

License

MIT License (MIT)

Requires

Python >=3.10

Provides Extra

ecm-web test dev release

Tags

hvac ecm energy-conservation building-automation spreadsheet open-fdd

Classifiers

Report project as malware

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

open_fdd-4.0.0.tar.gz (95.0 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

open_fdd-4.0.0-py3-none-any.whl (92.3 kB view details)

Uploaded Python 3

File details

Details for the file open_fdd-4.0.0.tar.gz.

File metadata

  • Download URL: open_fdd-4.0.0.tar.gz
  • Upload date:
  • Size: 95.0 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/6.1.0 CPython/3.13.14

File hashes

Hashes for open_fdd-4.0.0.tar.gz
Algorithm Hash digest
SHA256 d8077e7c664d6bbb155e299db9ecf8f924aa6096419f2ccae09298a5713e5480
MD5 0d5ec391a371ed4758756eebc2eaaf3e
BLAKE2b-256 6f8d7f869e02f080351c5bd52cc1025b62680e9454d3f1104147fc7222000f45

See more details on using hashes here.

Provenance

The following attestation bundles were made for open_fdd-4.0.0.tar.gz:

Publisher: publish-open-fdd.yml on bbartling/open-fdd

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file open_fdd-4.0.0-py3-none-any.whl.

File metadata

  • Download URL: open_fdd-4.0.0-py3-none-any.whl
  • Upload date:
  • Size: 92.3 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/6.1.0 CPython/3.13.14

File hashes

Hashes for open_fdd-4.0.0-py3-none-any.whl
Algorithm Hash digest
SHA256 af747fc5ba1b6eb4e0eb810a492a1183c3ad0cda422b506e0e493d8d21335bdd
MD5 93ecc9b73346e32e0b182c5f56b42fbb
BLAKE2b-256 a018286bacff924745597da665b5b365151edd9137cec910025d23eecd99da8d

See more details on using hashes here.

Provenance

The following attestation bundles were made for open_fdd-4.0.0-py3-none-any.whl:

Publisher: publish-open-fdd.yml on bbartling/open-fdd

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

Release history Release notifications | RSS feed

4.4.1

2 files

4.4.0

2 files

4.3.0

2 files

4.2.0

2 files

4.1.2

2 files

4.1.1

2 files

4.1.0

2 files

This release

4.0.0 This release

2 files

3.1.6

2 files

3.1.5

2 files

3.1.3

2 files

3.1.2

2 files

3.1.1

2 files

3.1.0

2 files

3.0.34

2 files

3.0.32

2 files

3.0.31

2 files

3.0.30

2 files

3.0.21

2 files

3.0.20

2 files

3.0.18

2 files

3.0.16

2 files

3.0.12

2 files

3.0.11

2 files

3.0.10

2 files

3.0.9

2 files

3.0.8

2 files

3.0.6

2 files

3.0.5

2 files

3.0.4

2 files

3.0.1

2 files

2.4.1

2 files

2.4.0

2 files

2.3.1

2 files

2.3.0

2 files

2.2.0

2 files

2.1.0

2 files

2.0.13

2 files

2.0.11

2 files

2.0.9

2 files

0.1.9

2 files

0.1.8

2 files

0.1.7

2 files

0.1.6

2 files

0.1.5

2 files

0.1.4

2 files

0.1.3

2 files

0.1.1

2 files

0.1.0

2 files

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page