{"id":51823,"date":"2023-09-11T00:00:00","date_gmt":"2023-09-11T00:00:00","guid":{"rendered":"https:\/\/discover.restek.com\/uncategorized\/the-standards-dilution-calculator-that-you-have-always-wanted\/"},"modified":"2025-12-11T20:54:08","modified_gmt":"2025-12-11T20:54:08","slug":"the-standards-dilution-calculator-that-you-have-always-wanted","status":"publish","type":"post","link":"https:\/\/discover.restek.com\/zh-hans\/blogs\/gnbl4829\/the-standards-dilution-calculator-that-you-have-always-wanted","title":{"rendered":"The Standards Dilution Calculator That You Have Always Wanted"},"content":{"rendered":"\n

By now you\u2019re probably familiar with Jason Hoisington\u2019s world-renowned blog series on calibrations and if you\u2019re not, then shame on you! I\u2019ll be nice though and provide the link HERE<\/a> so that you can get caught up. Now that you\u2019re up to speed on calibrations, I thought that I would add a little something to this series because I didn\u2019t want to miss out on the action!<\/p>\n\n\n\n

This blog will focus on giving you something that will hopefully make your life in the lab a little easier. As if figuring out calibrations (number of points, concentrations, etc.) wasn\u2019t already time consuming enough, calculating everything out can be quite a pain. This is why we like to work off of spreadsheets that help us calculate the volumes and concentrations for our stock solutions, working solutions, and calibration samples. If you are not already doing this, then you are in luck today! What we have built is a spreadsheet that will allow you to input the necessary information and calculate everything you should need for making your calibration and internal standard solutions. <\/p>\n\n\n\n

Calibration Calculator Spreadsheet<\/a><\/strong><\/p>\n\n\n\n

By clicking on the link above, you can download the spreadsheet. There are three tabs in this excel sheet which includes the Calibration Calculator, Internal Standard Calculator, and Printable Sheet. There are directions on the first two sheets that explain how to use them. The color-coding legend at the top of the sheet will explain what each color means. The only areas that need values entered by the user are colored YELLOW<\/strong><\/span>. The Printable Sheet should not need any modification as it pulls all the relevant information into a nice sheet that can be printed and taken into the lab. <\/p>\n\n\n\n

Values have already been entered into some of the locations as an example. You will see that I have selected reference standards related to EPA Method 8270. It should be noted that the example as is should not be used for 8270 because arbitrary values were selected for the calibration concentrations. <\/p>\n\n\n\n

Hopefully, this spreadsheet is straight forward and makes your lives a little easier when making calibration calculations!<\/p>\n\n\n\n

<\/div>\n","protected":false},"excerpt":{"rendered":"

In this post of the calibrations series, we look at using spreadsheets to help calculate the volumes and concentrations for our stock solutions, working solutions, and calibration samples. <\/p>\n","protected":false},"author":32,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kadence_starter_templates_imported_post":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"categories":[9],"tags":[2660],"industries-application":[],"post-badge":[],"resource-type":[],"product-library":[],"resource-technique":[2316,2318],"hf_cat_post":[623],"ppma_author":[452],"class_list":["post-51823","post","type-post","status-publish","format-standard","hentry","category-blogs","tag-calculators","resource-technique-chromatographie-en-phase-gazeuse-gc","resource-technique-chromatographie-en-phase-liquide"],"acf":[],"taxonomy_info":{"category":[{"value":9,"label":"Blogs"}],"post_tag":[{"value":2660,"label":"Calculators"}],"resource-technique":[{"value":2316,"label":"Chromatographie en phase gazeuse (GC)"},{"value":2318,"label":"Chromatographie en phase liquide"}]},"featured_image_src_large":false,"author_info":{"display_name":"Colton Myers","author_link":"https:\/\/discover.restek.com\/zh-hans\/author\/colton-myers\/"},"comment_info":0,"category_info":[{"term_id":9,"name":"Blogs","slug":"blogs","term_group":0,"term_taxonomy_id":9,"taxonomy":"category","description":"","parent":0,"count":442,"filter":"raw","cat_ID":9,"category_count":442,"category_description":"","cat_name":"Blogs","category_nicename":"blogs","category_parent":0}],"tag_info":[{"term_id":2660,"name":"Calculators","slug":"calculators","term_group":0,"term_taxonomy_id":2660,"taxonomy":"post_tag","description":"","parent":0,"count":6,"filter":"raw"}],"authors":[{"term_id":452,"user_id":32,"is_guest":0,"slug":"colton-myers","display_name":"Colton Myers","avatar_url":{"url":"https:\/\/discover.restek.com\/wp-content\/uploads\/people-myers-colton.jpg","url2x":"https:\/\/discover.restek.com\/wp-content\/uploads\/people-myers-colton.jpg"},"0":null,"1":"","2":"","3":"","4":"","5":"","6":"","7":"","8":""}],"_links":{"self":[{"href":"https:\/\/discover.restek.com\/zh-hans\/wp-json\/wp\/v2\/posts\/51823","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/discover.restek.com\/zh-hans\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/discover.restek.com\/zh-hans\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/discover.restek.com\/zh-hans\/wp-json\/wp\/v2\/users\/32"}],"replies":[{"embeddable":true,"href":"https:\/\/discover.restek.com\/zh-hans\/wp-json\/wp\/v2\/comments?post=51823"}],"version-history":[{"count":5,"href":"https:\/\/discover.restek.com\/zh-hans\/wp-json\/wp\/v2\/posts\/51823\/revisions"}],"predecessor-version":[{"id":73720,"href":"https:\/\/discover.restek.com\/zh-hans\/wp-json\/wp\/v2\/posts\/51823\/revisions\/73720"}],"wp:attachment":[{"href":"https:\/\/discover.restek.com\/zh-hans\/wp-json\/wp\/v2\/media?parent=51823"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/discover.restek.com\/zh-hans\/wp-json\/wp\/v2\/categories?post=51823"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/discover.restek.com\/zh-hans\/wp-json\/wp\/v2\/tags?post=51823"},{"taxonomy":"industries-application","embeddable":true,"href":"https:\/\/discover.restek.com\/zh-hans\/wp-json\/wp\/v2\/industries-application?post=51823"},{"taxonomy":"post-badge","embeddable":true,"href":"https:\/\/discover.restek.com\/zh-hans\/wp-json\/wp\/v2\/post-badge?post=51823"},{"taxonomy":"resource-type","embeddable":true,"href":"https:\/\/discover.restek.com\/zh-hans\/wp-json\/wp\/v2\/resource-type?post=51823"},{"taxonomy":"product-library","embeddable":true,"href":"https:\/\/discover.restek.com\/zh-hans\/wp-json\/wp\/v2\/product-library?post=51823"},{"taxonomy":"resource-technique","embeddable":true,"href":"https:\/\/discover.restek.com\/zh-hans\/wp-json\/wp\/v2\/resource-technique?post=51823"},{"taxonomy":"hf_cat_post","embeddable":true,"href":"https:\/\/discover.restek.com\/zh-hans\/wp-json\/wp\/v2\/hf_cat_post?post=51823"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/discover.restek.com\/zh-hans\/wp-json\/wp\/v2\/ppma_author?post=51823"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}