[[Template:Lenaolufson]]

== "100000" issue ==

* Lena, I've looked at the file. While I was looking, I uncovered an issue with how you made your "MasterSheet" worksheet. You were only supposed to copy over the columns that had the correct Cy5/Cy3 orientation. There should only be two technical replicates per sample in your MasterSheet.

* First fix your MasterSheet by getting rid of the columns you don't need.

* What we will do next is not delete the genes, but do a search and replace. You will search for "100000" and "-1000000" and replace it with an empty cell. In the find/replace window, type 100000 or -100000 in the find field and nothing at all in the replace field and then click on the replace all button and record the number of replacements.

* Then you can copy and paste special > paste values into your scaling and centering sheet and try again. You will know things are OK if your Average for each column is a very small number near zero and your standard deviation is near 1.

''— [[User:Kdahlquist|Kdahlquist]] ([[User talk:Kdahlquist|talk]]) 16:38, 1 December 2015 (PST)''

== Week 12 Feedback ==

*#* Insert a column to the right of the columns that need to be swapped. Name the new column the same as you did before, but addd "_swapped" to the header to designate that you are going to swap the samples.

*#* Then, type a formula in the column where you multiply the value that needs to be swapped by (-1). Copy and paste the formula to the entire column.

Exception encountered, of type "Error"
[7226c3b4] /biodb/fall2015/index.php?diff=7095&oldid=6980&title=User_talk%3ALenaolufson Error from line 434 of /apps/xmlpipedb/biodb/fall2015/includes/diff/DairikiDiff.php: Call to undefined function each()
Backtrace:
#0 /apps/xmlpipedb/biodb/fall2015/includes/diff/DairikiDiff.php(544): DiffEngine->diag()
#1 /apps/xmlpipedb/biodb/fall2015/includes/diff/DairikiDiff.php(344): DiffEngine->compareSeq()
#2 /apps/xmlpipedb/biodb/fall2015/includes/diff/DairikiDiff.php(227): DiffEngine->diffLocal()
#3 /apps/xmlpipedb/biodb/fall2015/includes/diff/DairikiDiff.php(721): DiffEngine->diff()
#4 /apps/xmlpipedb/biodb/fall2015/includes/diff/DairikiDiff.php(859): Diff->__construct()
#5 /apps/xmlpipedb/biodb/fall2015/includes/diff/DairikiDiff.php(980): MappedDiff->__construct()
#6 /apps/xmlpipedb/biodb/fall2015/includes/diff/TableDiffFormatter.php(194): WordLevelDiff->__construct()
#7 /apps/xmlpipedb/biodb/fall2015/includes/diff/DiffFormatter.php(140): TableDiffFormatter->changed()
#8 /apps/xmlpipedb/biodb/fall2015/includes/diff/DiffFormatter.php(82): DiffFormatter->block()
#9 /apps/xmlpipedb/biodb/fall2015/includes/diff/DifferenceEngine.php(888): DiffFormatter->format()
#10 /apps/xmlpipedb/biodb/fall2015/includes/diff/DifferenceEngine.php(802): DifferenceEngine->generateTextDiffBody()
#11 /apps/xmlpipedb/biodb/fall2015/includes/diff/DifferenceEngine.php(733): DifferenceEngine->generateContentDiffBody()
#12 /apps/xmlpipedb/biodb/fall2015/includes/diff/DifferenceEngine.php(662): DifferenceEngine->getDiffBody()
#13 /apps/xmlpipedb/biodb/fall2015/includes/diff/DifferenceEngine.php(632): DifferenceEngine->getDiff()
#14 /apps/xmlpipedb/biodb/fall2015/includes/diff/DifferenceEngine.php(453): DifferenceEngine->showDiff()
#15 /apps/xmlpipedb/biodb/fall2015/includes/page/Article.php(795): DifferenceEngine->showDiffPage()
#16 /apps/xmlpipedb/biodb/fall2015/includes/page/Article.php(506): Article->showDiffPage()
#17 /apps/xmlpipedb/biodb/fall2015/includes/actions/ViewAction.php(44): Article->view()
#18 /apps/xmlpipedb/biodb/fall2015/includes/MediaWiki.php(395): ViewAction->show()
#19 /apps/xmlpipedb/biodb/fall2015/includes/MediaWiki.php(273): MediaWiki->performAction()
#20 /apps/xmlpipedb/biodb/fall2015/includes/MediaWiki.php(566): MediaWiki->performRequest()
#21 /apps/xmlpipedb/biodb/fall2015/includes/MediaWiki.php(414): MediaWiki->main()
#22 /apps/xmlpipedb/biodb/fall2015/index.php(44): MediaWiki->run()
#23 {main}