Zrusso week 8: Difference between revisions
From OpenWetWare
Jump to navigationJump to search
(added electronic lab notebook) |
(→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 19:38, 21 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