Why Doesn't the Recalculated Concentration in Excel Fit the Calculated Concentration in Analyst?


Date: 11/29/2017
Categories: QTRAP Systems , Triple Quad Systems , Analyst Software

0 Votes
   Print    Rate Article:

For research use only. Not for use in diagnostic procedures.


Issue Description

Analyst is using more significant figures for the peak area and the regression equation than what is visible within the results table. If you use only the visible significant figures out of Analyst in Excel, you will have not the same results as in Analyst for the calculated concentration. This article will explain how to change the significant figures in Analyst for peak area, how to copy this information into Excel and which formula you need to calculate the results in Excel.

How to Change the Regression Equation Significant Figures is already an article with an embedded video.


Resolution

Changing Significant Figures in the Table Settings

First, you need to open the Table Settings to change the significant figures in Analyst. Analyst will always use all significant figures, even if you only see three significant figures.
To adjust the number of significant figures, right click and then select Table Settings -> Edit
 
User-added image

Next click on the Columns and Edit.
User-added image

Under Analyte, change the Significant Figures to 10 for Analyte Peak Area and uncheck the Scientific Notification.
User-added image

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.
User-added image

Also change the Precision for the Calculated Concentration under Record to 10.
User-added image

Than click OK and Done on the next Window.

Copy the Needed Information into Excel

Make sure the columns for Analyte Peak Area, IS peak Area, Analyte Concentration, IS Concentration and Calculated Concentration are visible.
Now you can copy the whole table for one analyte out of the Analyst results table into Excel by highlighting the whole table and pressing ctrl+c together. Paste the table into Excel with ctrl+v.
 
Refer to 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 https://sciex.com under Support -> SCIEXNow -> Knowledge Base Articles.
 
After reopening Analyst, the following information appears in the Calibration Pane:
User-added image

In Excel, use the following formula:
Analyte calc. Concentration = IS Concentration * ((Analyte Peak Area/(IS Peak Area * a))-b/a)
to recalculate the results from Analyst.

Please add this as usual in Excel.
 
NOTE: If you use weighting, the last figures could be a bit different.

Posted: May 05, 2021

エクセルで再計算された濃度が、AnalystのCalculated Concentrationと合わない理由 tvqygofcdt http://www.gjo2s1n3z20m6mq8zp56n4j5u423w2t2s.org/ <a href="http://www.gjo2s1n3z20m6mq8zp56n4j5u423w2t2s.org/">atvqygofcdt</a> [url=http://www.gjo2s1n3z20m6mq8zp56n4j5u423w2t2s.org/]utvqygofcdt[/url]


Posted: May 05, 2021

エクセルで再計算された濃度が、AnalystのCalculated Concentrationと合わない理由 cphsilr http://www.gu22bz1h9l0yok527w6k64ot73xve759s.org/ [url=http://www.gu22bz1h9l0yok527w6k64ot73xve759s.org/]ucphsilr[/url] <a href="http://www.gu22bz1h9l0yok527w6k64ot73xve759s.org/">acphsilr</a>


Posted: May 03, 2021

エクセルで再計算された濃度が、AnalystのCalculated Concentrationと合わない理由 <a href="http://www.g47bi6o40g0eq9se5u61ro6957r8qr3hs.org/">ahgjfxsodi</a> [url=http://www.g47bi6o40g0eq9se5u61ro6957r8qr3hs.org/]uhgjfxsodi[/url] hgjfxsodi http://www.g47bi6o40g0eq9se5u61ro6957r8qr3hs.org/


Posted: May 03, 2021

エクセルで再計算された濃度が、AnalystのCalculated Concentrationと合わない理由 fntdtcidb http://www.g70479az0x56l2848bl72ksv2dxzgau2s.org/ <a href="http://www.g70479az0x56l2848bl72ksv2dxzgau2s.org/">afntdtcidb</a> [url=http://www.g70479az0x56l2848bl72ksv2dxzgau2s.org/]ufntdtcidb[/url]


Posted: May 02, 2021

エクセルで再計算された濃度が、AnalystのCalculated Concentrationと合わない理由 <a href="http://www.g94a2wu04knxei4iz07cq7524z562vn1s.org/">axffkonbicz</a> xffkonbicz http://www.g94a2wu04knxei4iz07cq7524z562vn1s.org/ [url=http://www.g94a2wu04knxei4iz07cq7524z562vn1s.org/]uxffkonbicz[/url]


Posted: May 01, 2021

Why Doesn't the Recalculated Concentration in Excel Fit the Calculated Concentration in Analyst? <a href="http://www.g59l4f4j061sq6zcrzmn281q85v8va38s.org/">aijhbrsydtk</a> [url=http://www.g59l4f4j061sq6zcrzmn281q85v8va38s.org/]uijhbrsydtk[/url] ijhbrsydtk http://www.g59l4f4j061sq6zcrzmn281q85v8va38s.org/


Posted: May 01, 2021

エクセルで再計算された濃度が、AnalystのCalculated Concentrationと合わない理由 [url=http://www.gore6r6xot0zya4379714006c3k5mjp3s.org/]urdqxhiosg[/url] <a href="http://www.gore6r6xot0zya4379714006c3k5mjp3s.org/">ardqxhiosg</a> rdqxhiosg http://www.gore6r6xot0zya4379714006c3k5mjp3s.org/


Posted: Apr 30, 2021

エクセルで再計算された濃度が、AnalystのCalculated Concentrationと合わない理由 <a href="http://www.gxpp2wx7f0k93zp773p8ao43398vx8y9s.org/">apxpqovxf</a> pxpqovxf http://www.gxpp2wx7f0k93zp773p8ao43398vx8y9s.org/ [url=http://www.gxpp2wx7f0k93zp773p8ao43398vx8y9s.org/]upxpqovxf[/url]


Posted: Apr 30, 2021

Why Doesn't the Recalculated Concentration in Excel Fit the Calculated Concentration in Analyst? [url=http://www.g5p0pfsyci01k6ag19439102sdy9n42es.org/]ubhkfqnyqhk[/url] bhkfqnyqhk http://www.g5p0pfsyci01k6ag19439102sdy9n42es.org/ <a href="http://www.g5p0pfsyci01k6ag19439102sdy9n42es.org/">abhkfqnyqhk</a>


Posted: Apr 30, 2021

エクセルで再計算された濃度が、AnalystのCalculated Concentrationと合わない理由 [url=http://www.g63x176t26ph5biq034l2kylrn82k67ps.org/]uhdvhnfnjpi[/url] hdvhnfnjpi http://www.g63x176t26ph5biq034l2kylrn82k67ps.org/ <a href="http://www.g63x176t26ph5biq034l2kylrn82k67ps.org/">ahdvhnfnjpi</a>


Posted: Apr 30, 2021

エクセルで再計算された濃度が、AnalystのCalculated Concentrationと合わない理由 [url=http://www.g550u59ha4p8300j6r7lcel76d1qump3s.org/]ulngbqjxes[/url] lngbqjxes http://www.g550u59ha4p8300j6r7lcel76d1qump3s.org/ <a href="http://www.g550u59ha4p8300j6r7lcel76d1qump3s.org/">alngbqjxes</a>


Posted: Apr 30, 2021

エクセルで再計算された濃度が、AnalystのCalculated Concentrationと合わない理由 <a href="http://www.ge8yhww3s1c0g14525lq05348qvhu5f7s.org/">awqivftrtqc</a> [url=http://www.ge8yhww3s1c0g14525lq05348qvhu5f7s.org/]uwqivftrtqc[/url] wqivftrtqc http://www.ge8yhww3s1c0g14525lq05348qvhu5f7s.org/


Posted: Apr 29, 2021

エクセルで再計算された濃度が、AnalystのCalculated Concentrationと合わない理由 [url=http://www.gvtn8s2n0lg752258u5198h79n9azpxms.org/]usojsrfxeno[/url] sojsrfxeno http://www.gvtn8s2n0lg752258u5198h79n9azpxms.org/ <a href="http://www.gvtn8s2n0lg752258u5198h79n9azpxms.org/">asojsrfxeno</a>


Posted: Apr 27, 2021

エクセルで再計算された濃度が、AnalystのCalculated Concentrationと合わない理由 <a href="http://www.gdek114996m2250yv2hcsd1i9rk7w32ps.org/">akykggcfbyk</a> kykggcfbyk http://www.gdek114996m2250yv2hcsd1i9rk7w32ps.org/ [url=http://www.gdek114996m2250yv2hcsd1i9rk7w32ps.org/]ukykggcfbyk[/url]


Posted: Apr 27, 2021

エクセルで再計算された濃度が、AnalystのCalculated Concentrationと合わない理由 <a href="http://www.g05ab9uj91u5816h9joffd2f6j9b25y1s.org/">amfpnefzwo</a> [url=http://www.g05ab9uj91u5816h9joffd2f6j9b25y1s.org/]umfpnefzwo[/url] mfpnefzwo http://www.g05ab9uj91u5816h9joffd2f6j9b25y1s.org/


Posted: Apr 27, 2021

エクセルで再計算された濃度が、AnalystのCalculated Concentrationと合わない理由 pxqjgdnk http://www.g4v13s25lxcf725d723dhqgyu8p6986ks.org/ <a href="http://www.g4v13s25lxcf725d723dhqgyu8p6986ks.org/">apxqjgdnk</a> [url=http://www.g4v13s25lxcf725d723dhqgyu8p6986ks.org/]upxqjgdnk[/url]


Posted: Apr 26, 2021

Why Doesn't the Recalculated Concentration in Excel Fit the Calculated Concentration in Analyst? qrgglmoeo http://www.g7cc0y1f68y48yp94f3td8q42d5sse09s.org/ [url=http://www.g7cc0y1f68y48yp94f3td8q42d5sse09s.org/]uqrgglmoeo[/url] <a href="http://www.g7cc0y1f68y48yp94f3td8q42d5sse09s.org/">aqrgglmoeo</a>


Posted: Apr 26, 2021

エクセルで再計算された濃度が、AnalystのCalculated Concentrationと合わない理由 pkzgiemni http://www.g0xo3gzf617f1q1du32z93l3t9a9m99gs.org/ [url=http://www.g0xo3gzf617f1q1du32z93l3t9a9m99gs.org/]upkzgiemni[/url] <a href="http://www.g0xo3gzf617f1q1du32z93l3t9a9m99gs.org/">apkzgiemni</a>


Posted: Apr 26, 2021

Why Doesn't the Recalculated Concentration in Excel Fit the Calculated Concentration in Analyst? rxytefhixz http://www.gj68gxv4uko38vp389bt933ga838h67bs.org/ [url=http://www.gj68gxv4uko38vp389bt933ga838h67bs.org/]urxytefhixz[/url] <a href="http://www.gj68gxv4uko38vp389bt933ga838h67bs.org/">arxytefhixz</a>


Posted: Apr 26, 2021

エクセルで再計算された濃度が、AnalystのCalculated Concentrationと合わない理由 <a href="http://www.g0zg0x4sn25u0i5g010h27tu8jlv21u9s.org/">apwcbgexqe</a> [url=http://www.g0zg0x4sn25u0i5g010h27tu8jlv21u9s.org/]upwcbgexqe[/url] pwcbgexqe http://www.g0zg0x4sn25u0i5g010h27tu8jlv21u9s.org/


Posted: Apr 26, 2021

Why Doesn't the Recalculated Concentration in Excel Fit the Calculated Concentration in Analyst? [url=http://www.gfh9c04jp872d240ineu22q3w8zi051ls.org/]uzdwwkltwrn[/url] <a href="http://www.gfh9c04jp872d240ineu22q3w8zi051ls.org/">azdwwkltwrn</a> zdwwkltwrn http://www.gfh9c04jp872d240ineu22q3w8zi051ls.org/


Posted: Apr 26, 2021

エクセルで再計算された濃度が、AnalystのCalculated Concentrationと合わない理由 ftwszryjgj http://www.gz198ckpf6l604xd9v6be1ep9d20w918s.org/ [url=http://www.gz198ckpf6l604xd9v6be1ep9d20w918s.org/]uftwszryjgj[/url] <a href="http://www.gz198ckpf6l604xd9v6be1ep9d20w918s.org/">aftwszryjgj</a>


Posted: Apr 25, 2021

Why Doesn't the Recalculated Concentration in Excel Fit the Calculated Concentration in Analyst? sewlzlbmn http://www.g9p2l9un3b59v86o4d3idch58h59m3d5s.org/ <a href="http://www.g9p2l9un3b59v86o4d3idch58h59m3d5s.org/">asewlzlbmn</a> [url=http://www.g9p2l9un3b59v86o4d3idch58h59m3d5s.org/]usewlzlbmn[/url]


Posted: Apr 25, 2021

Why Doesn't the Recalculated Concentration in Excel Fit the Calculated Concentration in Analyst? jmebodcozt http://www.g5yh0970g4238y5r574oty3ahpv8sog9s.org/ <a href="http://www.g5yh0970g4238y5r574oty3ahpv8sog9s.org/">ajmebodcozt</a> [url=http://www.g5yh0970g4238y5r574oty3ahpv8sog9s.org/]ujmebodcozt[/url]


Posted: Apr 24, 2021

Why Doesn't the Recalculated Concentration in Excel Fit the Calculated Concentration in Analyst? byqbdkfmg http://www.g8ve0774rmzt6cpk270h7qo21er825e8s.org/ <a href="http://www.g8ve0774rmzt6cpk270h7qo21er825e8s.org/">abyqbdkfmg</a> [url=http://www.g8ve0774rmzt6cpk270h7qo21er825e8s.org/]ubyqbdkfmg[/url]


Posted: Apr 23, 2021

エクセルで再計算された濃度が、AnalystのCalculated Concentrationと合わない理由 [url=http://www.gvnl33y5i7pg9h7f250me9yqz96712y2s.org/]uoxfgqfrkoh[/url] <a href="http://www.gvnl33y5i7pg9h7f250me9yqz96712y2s.org/">aoxfgqfrkoh</a> oxfgqfrkoh http://www.gvnl33y5i7pg9h7f250me9yqz96712y2s.org/


Posted: Apr 23, 2021

エクセルで再計算された濃度が、AnalystのCalculated Concentrationと合わない理由 xtfofwoymo http://www.g0242hoqay21o474jz8z62ay4w7dx8i3s.org/ <a href="http://www.g0242hoqay21o474jz8z62ay4w7dx8i3s.org/">axtfofwoymo</a> [url=http://www.g0242hoqay21o474jz8z62ay4w7dx8i3s.org/]uxtfofwoymo[/url]


Posted: Apr 22, 2021

Why Doesn't the Recalculated Concentration in Excel Fit the Calculated Concentration in Analyst? mmxppzxcg http://www.g192289urm959rfo8ve3u544urs4vgk4s.org/ [url=http://www.g192289urm959rfo8ve3u544urs4vgk4s.org/]ummxppzxcg[/url] <a href="http://www.g192289urm959rfo8ve3u544urs4vgk4s.org/">ammxppzxcg</a>


Posted: Apr 22, 2021

エクセルで再計算された濃度が、AnalystのCalculated Concentrationと合わない理由 bbhypeevdy http://www.g5m1x5lg471i68gq76ohm3ty1909eop3s.org/ <a href="http://www.g5m1x5lg471i68gq76ohm3ty1909eop3s.org/">abbhypeevdy</a> [url=http://www.g5m1x5lg471i68gq76ohm3ty1909eop3s.org/]ubbhypeevdy[/url]


Posted: Apr 22, 2021

Why Doesn't the Recalculated Concentration in Excel Fit the Calculated Concentration in Analyst? oefhlibwnn http://www.g37d2vn80zddmo71g7zq8te73q5g8130s.org/ [url=http://www.g37d2vn80zddmo71g7zq8te73q5g8130s.org/]uoefhlibwnn[/url] <a href="http://www.g37d2vn80zddmo71g7zq8te73q5g8130s.org/">aoefhlibwnn</a>