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.