Skip to content

About

Fit enzymatic kinetics data set directly from excel with the Michaelis-Menten equation

Topics

Resources

Code of conduct

Stars

1 star

Watchers

1 watching

Forks

Latest commit

Β 

History

107 Commits

Folders and files

Repository files navigation

Michaelis-Menten Equation Fitting Tool

It was written for University Grenoble Alpes (UGA) students for biochemistry practicals in L2, L3, and M1.

This tool allows users to input data for substrate concentration (S0) and observed reaction rates (v0) to fit the Michaelis-Menten equation. The application provides a graphical user interface to input the data and visualize the curve-fitting results easily. No need of an expansive software to make non linear regression

If you found this project useful, used it, or needed to customize it (e.g., adding more lines or columns), please let me know! Your feedback is essential to help me improve and continue this project. You can reach out to me via email.

Stand-alone version for Windows, Mac, Linux are avalible to download at the end of the README

You can also use new the web version (on desktop or mobile) here

General Features:

1- Paste kinetic data directly from Excel.

2- Select substrate concentration and velocity columns.

3- Fit data to the Michaelis-Menten equation using nonlinear regression.

4- View fitted V_{\max}, K_m, and plot the fitted curve.

5- View Lineweaver-Burk plot and have the lienar regression

6- Exclude odd value from the fit for MM and LB

7- Clean, interactive GUI built with PyQt5.

8- Save plots as png,pdf.. or print them MM plot and LB plot

Version 6.x Major update

πŸ”„ Version 6.3 β€” Latest Release

Released: November 2026 Status: Stable

πŸš€ What's New in MM-Fit v6.3

✏️ Editable Data Table

  • Manual Cell Editing: Removed strict row-selection behavior. Users can now double-click any cell in the main table to manually edit values after pasting, allowing for quick corrections without needing to re-paste from Excel.

🎨 UI & Plotting Enhancements

  • "Change Colors" Button: Added a new utility button to instantly randomly shuffle the plot colors and re-draw the graph if the initial random palette lacks desired contrast.
  • High-Contrast Randomized Palette: Migrated from pastel colormaps to the vibrant, high-contrast tab10 colormap. The palette is shuffled upon loading data so each dataset gets a unique, easily distinguishable set of colors.
  • Distinct Markers per Series: Data series now cycle through distinct geometric shapes (o, D, ^, s, v, *) in addition to colors. This significantly improves accessibility and clarity when multiple curves overlap.
  • Clearer Data Exclusion: Excluded data points are strictly hardcoded to use a faded cross marker (x). This makes it instantly obvious which points are ignored by the fit across all plots (Michaelis-Menten, Residuals, and Lineweaver-Burk).
  • Exclusion Window Grid & Numbering: Overhauled the Exclusion GUI. It now includes a dedicated row numbering column (#) on the far left and features a thin grey CSS grid, making it much easier to align checkboxes with data points in large datasets.

πŸ›‘οΈ Data Validation & Safety

  • Smart Paste Pre-scanning: The clipboard paste method now pre-scans data before wiping the existing table to catch common pedagogical errors:
    • Missing Blank Check: Prompts the user with a Yes/No warning if the [S]0 column does not contain a 0.0 value.
    • Sorting Check: Prompts the user with a Yes/No warning if the [S]0 values are not strictly increasing.
    • Note: Both prompts allow the user to abort the paste safely without losing their current session.

πŸŽ“ Pedagogical "How-To-Fit" Simulation

  • Interactive Regression Guide: Added the How-To-Fit feature, an interactive educational window designed to help students and users visualize how optimization algorithms iteratively minimize global error ($\Sigma$ Squared Error) to find optimal $V_{max}$ and $K_m$ parameters.
  • Step-by-Step Controls & Export: Features full playback controls (Play, Pause, and manual stepping), customizable initial starting parameters, real-time convergence tracking.
MM_Fit_Animation

πŸ› Bug Fixes

  • LB Plot Auto-Scaling Fix: Restored missing data aggregation loops in the Lineweaver-Burk window, fixing an issue where axes failed to auto-scale correctly.

Dependencies:

The following Python libraries are required: β€’ PyQt5 β€’ numpy β€’ pandas β€’ matplotlib β€’ scipy

Installation from the script:

Ensure you have Python installed on your system.

Install the required packages using pip:

# Create and activate a virtual environment (optional but recommended)
python -m venv mmfit-env
source mmfit-env/bin/activate
# On Windows use: mmfit-env\Scripts\activate

Install required packages

pip install PyQt5 numpy pandas matplotlib scipy

or

conda create -n mmfit-env python=3.12
conda activate mmfit-env
conda install pyqt5 numpy pandas matplotlib scipy

Run the script:

python MM-fit-v5.x.py

Video tutorial:

MM-Fit-tutorial.mp4

Usage:

  1. If python is present on your system then run the script:
python MM-Fit-v6.x.py

or use the stand-alone for Window, Mac.app, or Linux (link below) double click on the file:

MM-fit.exe

  1. A window will popup (beware first start is ver very long 40-45 sec):
image
  1. Copy cells in Excel (make sure that values are in scientific format)
image
  1. Then on the GUI click on "1- Paste from Excel". Data will appear in the left panel
image
  1. Click on "2- MM-Fit" to fit the Michaelis-Menten equation and visualize the results.

Micahelis Menten representation with the fit (Km and error, Vmax and error, and R^2) :

image

At the bottom of the plot you can see residuals (Exp values - Fit values) with a color cone for values at +/- 5% from the fit value.

  1. Click LB plot to draw Lineweaver and Burk Plot to get the plot :
image

Check on Display linear fit to get values from the linear regression

image

Note with the v5.0 you can change the X and Y scale using X or Y max and min box.

You can click on print to print or save as PDF

Close the LB plot window to get back to the GUI

  1. Click on "4- Exclude data" to exclude some value to improve the fit for one or several series.
image

Check the values that seem a bit odd to exclude them for the MM fit and Lineweaver and Burk Plot:

Then click on "Apply and Refit", the new fit appears without the exclude values. Note that exclude values appears as crosses on the plot

MM-plot

image

Or LB plot

image
  1. Click on "Reset " to clear all the fields and reset checked checboxes, and start over.

  2. Click on "Quit" to quit

Notes:

  1. Ensure all values are valid and in the correct format like 12E03 (for 12000 e.g., scientific notation) before fitting.

  2. In principle, it should accept numbers with commas or dots i.e. 1,2E-03 or 1.2E-03.

  3. If copying from Excel, ensure the data is in two columns with the substrate concentration in the first column and the observed reaction rate in the second.

  4. It's possible to make an exe file for Windows using "pyinstaller" or "py2app", to distribute the script on computers that don't have Python install:

       pyinstaller -F MM-v6.x.py

    /!\ For the first run be patient, the embeded matplotlib needs to compile and it takes sometimes /!\ (this should be solve in the 5.5 version)

Stand-alone versions are here v6.x (last release):

/!\ For the first run be patient, the embeded matplotlib needs to compile and it takes sometimes /!\ (this should be solved since the 5.5 version)

=> For Mac (if it doesn't start go to Privacy & Security and click on open anyway, as I'm an unidentify develloper) :

Get it from Here

=> For Windows Just one file (it will be a bit slow start (solved since the 5.5 version), but can be place anywhere):

Get it from Here

=> For Linux (5.0):(rather use python directly)

Get it from Here

Don't hesitate to reach me if you need help setting it up reach out to me via email.

About

Fit enzymatic kinetics data set directly from excel with the Michaelis-Menten equation

Topics

Resources

Code of conduct

Stars

1 star

Watchers

1 watching

Forks

Releases

Packages

Contributors

Languages