How to calculate km and vmax with excel. In other words, it is a measure of the rate at which an object travels over a given distance. This video explains about How to calculate Km and Vmax values - Lineweaver Burk plot in Excel. Input the slope and y-intercept from your Lineweaver-Burk plot in Excel to get instant results for your analysis. Follow our step-by-step guide to create a Lineweaver-Burk plot for your analysis. 2. In this video, I have explained how to calculate the value of Km and Vmax for an enzyme-substrate reaction using the Michaelis-Menten equation. This video explains about how to calculate Vmax and Km using MS Excel. Km and Vmax value calculation in excel from the enzyme kinetic data. Choose the number of decimal places for results. The Vmax is the maximum rate of product formation, and the Km is the substrate concentration at which the reaction rate is half of Vmax. rhqcx arfg bllubm pdhql ddksn fiatl wnhsuool kszzneq hpex bbx