A protein purification table is the scorecard of any enzyme isolation. It records, step by step, how much total protein and how much catalytic activity you carry forward, and from those two numbers it derives the metrics that tell you whether the purification is working: specific activity, yield, and fold purification.
How it works
For each fraction you provide three measured quantities, and the table computes the rest:
total protein (mg) = volume (mL) x protein conc (mg/mL)
total units = volume (mL) x activity (U/mL)
specific activity = total units / total protein (U/mg)
yield % = (step total units / crude total units) x 100
fold purification = step specific activity / crude specific activity
The first row you enter is treated as the crude starting material and becomes the 100 percent yield, 1.0-fold reference for everything below it.
Example and notes
Imagine a crude extract of 100 mL at 10 mg/mL carrying 5 U/mL. That is 1000 mg of protein and 500 units, for a specific activity of 0.5 U/mg. After an ammonium sulphate cut you might have 20 mL at 8 mg/mL and 20 U/mL: 160 mg, 400 units, specific activity 2.5 U/mg. The yield is 80 percent and the fold is 5. Activity is mostly retained while purity has climbed fivefold, exactly the trade-off you want. Rows with zero protein are skipped for specific activity to avoid dividing by zero.