For research use only. Not for use in diagnostic procedures.
Analyst is using more significant Figures for Peak Area and Regression Equation if you normally see in the Analyst Software. If you use only the visible Figures out of Analyst in Excel, you will have not the same Results as in Analyst for the Calculated Concentration. These Article will explain, how to change the Significant Figures in Analyst for the Peak Area, how to copy this information into excel and which Formla you need to calculate the Results in Excel. How to change the Regression Equation Significant Figures, here is already an article with Video, which explain this:"How Do I Change the Significant Figures of Regression Equation in Analyst"
Change Significant Figures in the Table Settings
First, you need to open the Table Settings to change the significant figures in Analyst. Because Analyst always use all figures, even, if you only see 3 significant figures. Therefore, click right Mouse and then Table Settings -> Edit
Next click on the Columns and Edit.
Under Analyte, change the Significant Figures to 10 for Analyte Peak Area and uncheck the Scientific Notification.
Do the same for Internal Standard, if you use one. IS Peak Area to 10 for Significant Figures and uncheck the Scientific Notification. Please also check the Show for IS Concentration
Also change the Precision for the Calculated Concentration under Record to 10.
Than click OK and Done on the next Window.
Copy the needed Information into Excel
Make sure, that you will see the Analyte Peak Area, IS peak Area, Analyt Concentration, IS Concentration and calculated Concentration. Now you can copy the hole Table for one Analyte out of Analyst Result Table into Excel by mark the hole table and press ctrl+c together. Paste the table into Excel with ctrl+v.
Use the Article “How Do I Change the Significant Figures of Regression Equation in Analyst” to change the Significant Figures for the Equation to 12. You can find it on our Homepage under Support -> SCIEXNow -> Knowledge Base Articles.
You will see after reopen Analyst the following in the Calibration Pane:
In Excel, you need the Formula
Analyte calc. Concentration = IS Concentration * ((Analyte Peak Area/(IS Peak Area * a))-b/a)
to recalculate the Results in Analyst.
Please add this as usual in Excel.
NOTE: If you use weighting, the last figures could be a bit different.