paxpatent.blogg.se

From the video tutorial you will learn how to –

We also show you how to protect the Excel sheet so that the formulas cannot be altered by mistake and also you can further validate the Excel sheet for use in a regulated environment.įor best results see the video in HD, in full screen mode and use headphones for better sound clarity. The sheet also includes a dilutions factor calculator using which the concentration of analyte in the undiluted samples can also be automatically calculated. This is a video tutorial for making an Excel sheet to create a calibration curve using six standards and using it to automatically back calculating unknown sample concentrations. Learning to use these different methods of calculation is essential to working in the laboratory and is a essential part of any laboratory training program. You could use a single external standard, a calibration curve, internal standard or use standard addition.

Excel Calibration Curve Video TutorialWorking in the laboratory, there are a number of different ways that we can calculate the amount of an analyte present in a sample by comparing them to standards.