# Reaction Conversion, Yield and Selectivity Batch Log (Excel) > Source: https://netray.co/tools/reaction-conversion-yield-selectivity-batch-log > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Log reactant fed, unreacted and product formed per batch and see conversion, yield and selectivity automatically. ## Category quality ## Industry Chemical Manufacturing ## Audience - Process chemist - Quality manager - Production manager ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Batch number **Key:** batch **Type:** text #### Date **Key:** date **Type:** date #### Limiting reactant charged **Key:** fed **Type:** number **Unit:** kmol #### Reactant left at end **Key:** unreacted **Type:** number **Unit:** kmol #### Desired product formed **Key:** product **Type:** number **Unit:** kmol #### Mol product per mol reactant **Key:** stoich **Type:** number **Help:** From the balanced equation, usually 1. #### Conversion **Key:** conv **Type:** number **Expr:** (fed - unreacted) / fed * 100 **Format:** percent #### Yield **Key:** yield **Type:** number **Expr:** product / (fed * stoich) * 100 **Format:** percent #### Selectivity **Key:** sel **Type:** number **Expr:** product / ((fed - unreacted) * stoich) * 100 **Format:** percent **Rows:** **Batch:** B-24101 **Date:** 2026-10-01 **Fed:** 12 **Unreacted:** 0.6 **Product:** 10.2 **Stoich:** 1 **Batch:** B-24102 **Date:** 2026-10-03 **Fed:** 12 **Unreacted:** 0.9 **Product:** 9.8 **Stoich:** 1 **Batch:** B-24103 **Date:** 2026-10-06 **Fed:** 12 **Unreacted:** 0.5 **Product:** 10.6 **Stoich:** 1 **Batch:** B-24104 **Date:** 2026-10-08 **Fed:** 11.5 **Unreacted:** 1.4 **Product:** 8.9 **Stoich:** 1 **Batch:** B-24105 **Date:** 2026-10-10 **Fed:** 12 **Unreacted:** 0.6 **Product:** 10.4 **Stoich:** 1 **Totals:** #### Average conversion **Key:** conv **Agg:** avg **Format:** percent #### Average yield **Key:** yield **Agg:** avg **Format:** percent #### Average selectivity **Key:** sel **Agg:** avg **Format:** percent **Notes:** Yield equals conversion multiplied by selectivity. Use consistent units (kmol or kg-moles) for all three amounts. Measure unreacted reactant by sampling or in-process assay, and product by assay of the final mass. ## Content **Intro:** Yield alone does not tell you whether a poor batch lost material to unreacted feed or to side products. This worksheet logs each batch and computes conversion, yield and selectivity side by side, with totals and Excel export. **Sections:** #### How to use it **Body:** Add one row per batch. Enter the limiting reactant charged, the amount still unreacted at the end, the desired product formed and the stoichiometric ratio from the balanced equation. The three percentage columns calculate themselves, and the totals show averages across the log. Replace the sample rows with your own and export to Excel or PDF for the batch review. #### The definitions **Body:** Conversion is the fraction of limiting reactant consumed: (fed minus unreacted) divided by fed. Yield is product formed divided by the theoretical maximum. Selectivity is product formed divided by the product that would be obtained if all consumed reactant went to the desired product. So yield = conversion x selectivity. **Bullets:** - Low conversion points to kinetics, time, temperature or catalyst - Low selectivity points to side reactions or poor mixing - Low yield with high conversion and selectivity suggests losses in work-up - Use moles, not mass, unless molar masses match #### Common mistakes **Body:** Mixing mass and mole bases is the most common error and produces yields over 100 percent. Another is using the wrong limiting reactant. If a row shows selectivity above 100 percent, check the stoichiometric coefficient and measurement units before assuming the chemistry is better than the equation allows. **Bullets:** - Account for recycled streams and heels separately - Record analytical method and date for traceability - Compare batches with the same raw material lot where possible - Trend the averages monthly rather than judging one batch **Cta:** If batch results are stored in your ERP production order history, Netray can help bring yield data into one trend view. Ask us for a review. **Faq:** #### What is the difference between yield and selectivity? **Answer:** Yield compares product to the theoretical maximum from the full charge. Selectivity compares product to what the reactant that actually reacted could give. A batch can have good selectivity and poor yield if conversion is low. #### Why does the worksheet show zero? **Answer:** If a divisor is zero, for example the charge is blank or all reactant remains unreacted, the formula returns zero rather than an error. Fill in the charge and unreacted values. #### Can I use kilograms? **Answer:** Only if all columns use the same basis and the stoichiometric ratio is expressed in mass. For most chemistry, moles are cleaner. Convert with molar mass before entering the values. #### What is a good yield? **Answer:** It depends on the chemistry and process stage. Simple reactions may exceed 95 percent, multi-step fine chemical routes much less. Compare against your validated process targets and historical control limits. ## Search terms reaction yield calculator excel, conversion yield selectivity formula, batch yield log template, chemical batch record yield, percent yield worksheet, selectivity calculation, chemical process yield tracking --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json