AH_Organic_Acids_HPLC

The attached spreadsheet comprises raw data related to developing an HPLC analytical method, which is used for the analysis of food composition and compounds involved in biomass reactions . The dataset in addition to the incorporated mathematical formulas guide researchers and quality control employees working at food and biomass industries on how to design an experimental design to yield a robust analytical chromatography protocol. Importantly, mathematical formulas furnished with the datasheet feature a user-friendly template for all calculations needed for preparing analytical standards, mix standards, real samples, and the corresponding calibrations. This spreadsheet is composed of two sheets where the first one entitled 'HPLC Standards' deals with the calculations of the concentrations of analytical standards and their relevant calibrations plots. Whereas the second sheet entitled 'Samples Run' is designated for calculating the final concentrations of the samples under analysis. Moreover, the latter provides a concise approach on how to run an HPLC sequence for the quantification of the samples' ingredients. In addition, statistics as well as relative response factor of the used internal standard calculations are demonstrated.

本附件中的电子表格包含与开发高效液相色谱法（HPLC）分析方法相关的原始数据，该方法用于食品成分以及生物质反应中涉及的化合物的分析。本数据集连同内置的数学公式，可为食品及生物质行业的研发人员与质量管控人员提供指导，帮助其设计实验方案以构建稳健的分析色谱流程。尤为重要的是，本电子表格附带的数学公式提供了便捷易用的模板，可用于制备分析标准品、混合标准品、实际样品以及相应校准工作所需的全部计算。本电子表格包含两个工作表：第一个工作表名为"HPLC Standards"，用于计算分析标准品的浓度及其对应的校准曲线；第二个工作表名为"Samples Run"，用于计算待测样品的最终浓度。此外，第二个工作表还提供了简洁的操作指南，介绍如何运行HPLC序列以实现样品成分的定量分析。同时，本数据集还展示了所用内标的相关统计计算以及相对响应因子的计算过程。