Zrusso week 8

From OpenWetWare
Revision as of 19:38, 21 October 2010 by Zeb Russo (talk | contribs) (→‎Electronic Lab Notebook: added links and category)
Jump to navigationJump to search

Electronic Lab Notebook

  • normalizing the log ratios between all the samples went well, copying and pasting the entire dataset was easy, but dragging the selection box over each column was tedious
  • learned that putting dollar signs in front of the letter and number designator of cells will 'lock' them so that when dragged or copied, those values will remain constant
  • Got slightly confused when copying columns into 'statistics' worksheet due to the fact that I used slightly different columns than stated so it was slightly off. Would be better to just say what content was in each column instead of location.
  • Learned that if I say 'paste special' I can simply copy and paste numerical values to equations in cells instead of typing them all out again
  • Again getting confused due to location being used as the identifier instead of the name
  • Learned how to Autofilter!
  • saved entire spreadsheet as well as created separate txt file of the final sheet

Links

User:Zeb Russo

BIOL367/F10