User:Andrew W Long/Notebook/Protein Modification/2014/06/19: Difference between revisions

From OpenWetWare
Jump to navigationJump to search
Line 13: Line 13:
*To import text filed from uv vis, go do data > from test > import > next > comma (to separate into two columns) > finish
*To import text filed from uv vis, go do data > from test > import > next > comma (to separate into two columns) > finish
*To correct based on water reference, import all necessary data, make a new column for Abs., hit =, select the absorbance minus the water reference, drag down as far as you want to extend the calculation
*To correct based on water reference, import all necessary data, make a new column for Abs., hit =, select the absorbance minus the water reference, drag down as far as you want to extend the calculation
 
*To get chart to open wetware, copy and paste chart into paint, save it as a .png, and put it with the rest of the data in Dr. Hartings's drop box >look under toolbox in wetware, and slect upload file, hit upload file, and hyperlink it to the notebook using [[link]]
**When copying and pasting link, only use the portion of the link after the standard openwetware piece that is on every link to the site
**to edit the size of the graph, put a vertical bar like [[link|size]]


<!-- ##### DO NOT edit below this line unless you know what you are doing. ##### -->
<!-- ##### DO NOT edit below this line unless you know what you are doing. ##### -->

Revision as of 06:06, 19 June 2014

Project name <html><img src="/images/9/94/Report.png" border="0" /></html> Main project page
<html><img src="/images/c/c3/Resultset_previous.png" border="0" /></html>Previous entry<html>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</html>Next entry<html><img src="/images/5/5c/Resultset_next.png" border="0" /></html>

June 19, 2014

Excel data analysis:

  • Axes under layout
  • Double click to change values on axes
  • To save graphs as pictures, right click and do move to new sheet, copy it and paste it in paint, and save as a .png
  • To import text filed from uv vis, go do data > from test > import > next > comma (to separate into two columns) > finish
  • To correct based on water reference, import all necessary data, make a new column for Abs., hit =, select the absorbance minus the water reference, drag down as far as you want to extend the calculation
  • To get chart to open wetware, copy and paste chart into paint, save it as a .png, and put it with the rest of the data in Dr. Hartings's drop box >look under toolbox in wetware, and slect upload file, hit upload file, and hyperlink it to the notebook using link
    • When copying and pasting link, only use the portion of the link after the standard openwetware piece that is on every link to the site
    • to edit the size of the graph, put a vertical bar like size