Lab calculations spreadsheet example (solutions, dilutions, master mixes, protein concentrations) скачать в хорошем качестве

Lab calculations spreadsheet example (solutions, dilutions, master mixes, protein concentrations)

Here’s a walkthrough I made of an example lab math spreadsheet PS - apologies if it's blurry (I don't monetize my stuff or anything) – I recommend following along with the spreadsheet on your own device. link to spreadsheet: https://bit.ly/bb_labcalcspreadsheet Note: this does not replace needing to know how to do things by hand! (In some ways it makes it more important because it let’s you set up things and check you set things up right!) Often, I’m using spreadsheets for dilution calculations, automating C1V1=C2V2 I make a column with Stock/Initial concentrations (C1s), Desired concentrations (C2s), and Desired volumes (V2s). Sometimes I include some molecular weights too. This lets you easily reference them in any equation, and allows all those equations to automatically update if you change them. Include units-but in a neighboring column to allow you to use the quantities as numbers The units can be anything, even % or X, as long as you use the same units in your calculations with those numbers. When you want a reference to be absolute (i.e. if you drag (bottom right corner) or copy/paste a formula it will stay referencing that cell), put $ before the column letter & row number. A shortcut for this is F4. Great for when you are referencing a V2 multiple times for different components or samples, etc. Spreadsheets are also optimal for making master mixes. If it’s something you do a lot and/or there are lots of components with decimals and stuff, you can even make a spreadsheet where you have a “per reaction” column and then a “total column” with the amounts you get if you multiply it by a “conversion factor” you can change (if you’re using excel or Google sheets, use F4 after you click on the well you want it to multiply by (the conversion factor so if you try to copy the formula it still knows where to look).  more on experimental spreadsheets: https://bit.ly/experiment_spreadsheets ; Walkthrough video:    • Planning experiments in spreadsheets:...   example spreadsheet: https://bit.ly/experiment_spreadsheet... more on metric conversions: blog: https://bit.ly/metric_calcs ; YouTube:    • Metric conversions & scientific notat...        more on dimensional analysis: http://bit.ly/dimensionalanalysising &    • Dimensional analysis (aka factor-labe...         more about concentrations & making solutions: http://bit.ly/sciencestocksolutions ; YouTube:    • Concentration - ways to report it (mo...   &    • Working with relative concentrations ...          and a couple cheat sheets for molecular weights: https://drive.google.com/file/d/1TqCR...        and concentrations: https://drive.google.com/file/d/1v7pf...        more lab-mathy things: https://thebumblingbiochemist.com/let... &    • lab math-y stuff   more on coding: https://bit.ly/why_program ,    • Random tip - Use a Clipboard Manager  ,  https://bit.ly/bb_python_tips   more about all sorts of things: #365DaysOfScience All (with topics listed) 👉 http://bit.ly/2OllAB0 or search blog: http://thebumblingbiochemist.com