Produce an excel spreadsheet based simulation to illustrate


Part 1 - Produce an Excel spreadsheet based simulation to illustrate the operation of a simple Chromatography system.

1. The initial spreadsheet should calculate the progress of a single compound through the column using a finite element approach and assuming that the column is divided into theoretical plates. The user should be able to change parameters such as the partition coefficient and column length (number of theoretical plates).

2. Produce output graphs (simulated chromatograms) showing the effect of changing the variable parameters.

3. The system should be developed to handle a number of different species with different partition coefficients passing through the column e.g. by summing up separate simulations to produce a composite chromatogram.

4. Further refinements may be added to the model to simulate the various contributions to pulse broadening suggested by the Van Deemter equation. If possible generate further graphs showing the effect of changing the flow rate of the mobile phase.

5. Compare the peak widths for a given retention time with published data from real world systems.

Part 2 - Describe an industrial application for either GC or HPLC with some detail about the system and detectors used.

Request for Solution File

Ask an Expert for Answer!!
Dissertation: Produce an excel spreadsheet based simulation to illustrate
Reference No:- TGS01287547

Expected delivery within 24 Hours