Zrusso week 8: Difference between revisions

From OpenWetWare
Jump to navigationJump to search
Zeb Russo (talk | contribs)
added electronic lab notebook
 
Zeb Russo (talk | contribs)
Electronic Lab Notebook: added links and category
Line 8: Line 8:
*Learned how to Autofilter!
*Learned how to Autofilter!
*saved entire spreadsheet as well as created separate txt file of the final sheet
*saved entire spreadsheet as well as created separate txt file of the final sheet
===Links===
[[User:Zeb Russo]]
[[BIOL367/F10]]
[[Category: BIOL367/F10]]

Revision as of 02:38, 22 October 2010

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

User:Zeb Russo

BIOL367/F10