Emilysimso Week 12 - Revision history

Emilysimso: /* Consolidating Files */ notes to self

2015-11-20T20:40:59Z

‎Consolidating Files: notes to self

Emilysimso: /* Consolidating Files */ starting point note

2015-11-20T06:17:05Z

‎Consolidating Files: starting point note

Emilysimso: /* Consolidating Files */ procedure for log2

2015-11-20T06:11:31Z

‎Consolidating Files: procedure for log2

Emilysimso: /* Consolidating Files */ added step details

2015-11-20T06:00:44Z

‎Consolidating Files: added step details

Emilysimso: added template

2015-11-20T05:50:33Z

added template

Emilysimso: /* Consolidating Files */ added detail

2015-11-20T05:49:11Z

‎Consolidating Files: added detail

Emilysimso: /* Consolidating Files */ added combined files

2015-11-20T05:47:43Z

‎Consolidating Files: added combined files

Emilysimso: /* Files */ added section

2015-11-20T04:59:28Z

‎Files: added section

Emilysimso: /* Files */ added first raw data edits

2015-11-20T04:59:05Z

‎Files: added first raw data edits

Emilysimso: Started uploading files

2015-11-19T23:46:20Z

Started uploading files

New page

==Goals==
*Normalize data, statistical analysis of raw data

==File Notes==
*Will work on all "F" files
*52 chips total - 104 files (one for Cy3, one for Cy5)
*sdrf file has 208 - duplicates
*Need columns G, K, L, H
*Log2 (Cy5 signal median-Cy5 signal background / Cy3 signal median - Cy3 signal background)

==Files==
*F1_1_Cy3: [[File:GSM496756 MR-1 F1 1 Cy3.xlsx]]
*F1_1_Cy5: [[File:GSM496756 MR-1 F1 1 Cy5.xlsx]]
*F1_2_Cy3: [[File:GSM496757 MR-1 F1 2 Cy3.xlsx]]
*F1_2_Cy5: [[File:GSM496757 MR-1 F1 2 Cy5.xlsx]]
*F1_3_Cy3: [[File:GSM496758 MR-1 F1 3 Cy3.xlsx]]
*F1_3_Cy5: [[File:GSM496758 MR-1 F1 3 Cy5.xlsx]]
*F1_4_Cy3: [[File:GSM496759 MR-1 F1 4 Cy3.xlsx]]
*F1_4_Cy5: [[File:GSM496759 MR-1 F1 4 Cy5.xlsx]]
*F5_1_Cy3: [[File:GSM496760 MR-1 F5 1 Cy3.xlsx]]
*F5_1_Cy5: [[File:GSM496760 MR-1 F5 1 Cy5.xlsx]]
*F5_2_Cy3: [[File:GSM496761 MR-1 F5 2 Cy3.xlsx]]
*F5_2_Cy5: [[File:GSM496761 MR-1 F5 2 Cy5.xlsx]]
*F5_3_Cy3: [[File:GSM496762 MR-1 F5 3 Cy3.xlsx]]
*F5_3_Cy5: [[File:GSM496762 MR-1 F5 3 Cy5.xlsx]]
*F5_4_Cy3: [[File:GSM496763 MR-1 F5 4 Cy3.xlsx]]
*F5_4_Cy5: [[File:GSM496763 MR-1 F5 4 Cy5.xlsx]]
*F10_1_Cy3: [[File:GSM496764 MR-1 F10 1 Cy3.xlsx]]
*F10_1_Cy5: [[File:GSM496764 MR-1 F10 1 Cy5.xlsx]]
*F10_2_Cy3: [[File:GSM496765 MR-1 F10 2 Cy3.xlsx]]
*F10_2_Cy5: [[File:GSM496765 MR-1 F10 2 Cy5.xlsx]]
*F10_3_Cy3: [[File:GSM496766 MR-1 F10 3 Cy3.xlsx]]
*F10_3_Cy5: [[File:GSM496766 MR-1 F10 3 Cy5.xlsx]]
*F10_4_Cy3: [[File:GSM496767 MR-1 F10 4 Cy3.xlsx]]
*F10_4_Cy5: [[File:GSM496767 MR-1 F10 4 Cy5.xlsx]]
*F20_1_Cy3: [[File:GSM496768 MR-1 F20 1 Cy3.xlsx]]

@@ Line 84: / Line 84: @@
 ***K2=I2/J2
 **Column L labeled Log2
@@ Line 94: / Line 95: @@
 *[[File:F5 3 Combined.xlsx]]
 *[[File:F5 4 Combined.xlsx]]
-*[[File:F10 1 Combined.xlsx]] START HERE
+*[[File:F10 1 Combined.xlsx]]
 *[[File:F10 2 Combined.xlsx]]
 *[[File:F10 3 Combined.xlsx]]

@@ Line 94: / Line 94: @@
 *[[File:F5 3 Combined.xlsx]]
 *[[File:F5 4 Combined.xlsx]]
-*[[File:F10 1 Combined.xlsx]]
+*[[File:F10 1 Combined.xlsx]] START HERE
 *[[File:F10 2 Combined.xlsx]]
 *[[File:F10 3 Combined.xlsx]]

@@ Line 76: / Line 76: @@
 ***Added _Cy3 to columns A-D and _Cy5 to columns E-H on row titles to differentiate the samples
 *Calculated the Log2 for each of the following files in Sheet 4
-**OUTLINE STEPS
+**Copied over all of the data from Combined sheet

← Older revision		Revision as of 06:00, 20 November 2015
Line 75:		Line 75:
	**Sheet 3 = Combined		**Sheet 3 = Combined
	***Added _Cy3 to columns A-D and _Cy5 to columns E-H on row titles to differentiate the samples		***Added _Cy3 to columns A-D and _Cy5 to columns E-H on row titles to differentiate the samples
		+	*Calculated the Log2 for each of the following files in Sheet 4
		+	**OUTLINE STEPS

← Older revision		Revision as of 05:50, 20 November 2015
Line 101:		Line 101:
	*[[File:F60 3 Combined.xlsx]]		*[[File:F60 3 Combined.xlsx]]
	*[[File:F60 4 Combined.xlsx]]		*[[File:F60 4 Combined.xlsx]]
		+
		+
		+
		+	{{Template: Esimso entries etc}}

@@ Line 74: / Line 74: @@
 **Sheet 2 = Cy5
 **Sheet 3 = Combined
-***Added _Cy3 to columns A-D and _Cy5 to columns E-H
+***Added _Cy3 to columns A-D and _Cy5 to columns E-H on row titles to differentiate the samples

← Older revision		Revision as of 05:47, 20 November 2015
Line 69:		Line 69:

	===Consolidating Files===		===Consolidating Files===
		+	*Combined the Cy3 and Cy5 files for each time point onto a single spreadsheet
		+	*In each new spreadsheet:
		+	**Sheet 1 = Cy3
		+	**Sheet 2 = Cy5
		+	**Sheet 3 = Combined
		+	***Added _Cy3 to columns A-D and _Cy5 to columns E-H
		+
		+
		+	*[[File:F1 1 Combined.xlsx]]
		+	*[[File:F1 2 Combined.xlsx]]
		+	*[[File:F1 3 Combined.xlsx]]
		+	*[[File:F1 4 Combined.xlsx]]
		+	*[[File:F5 1 Combined.xlsx]]
		+	*[[File:F5 2 Combined.xlsx]]
		+	*[[File:F5 3 Combined.xlsx]]
		+	*[[File:F5 4 Combined.xlsx]]
		+	*[[File:F10 1 Combined.xlsx]]
		+	*[[File:F10 2 Combined.xlsx]]
		+	*[[File:F10 3 Combined.xlsx]]
		+	*[[File:F10 4 Combined.xlsx]]
		+	*[[File:F20 1 Combined.xlsx]]
		+	*[[File:F20 2 Combined.xlsx]]
		+	*[[File:F20 3 Combined.xlsx]]
		+	*[[File:F20 4 Combined.xlsx]]
		+	*[[File:F40 1 Combined.xlsx]]
		+	*[[File:F40 2 Combined.xlsx]]
		+	*[[File:F40 3 Combined.xlsx]]
		+	*[[File:F40 4 Combined.xlsx]]
		+	*[[File:F60 1 Combined.xlsx]]
		+	*[[File:F60 2 Combined.xlsx]]
		+	*[[File:F60 3 Combined.xlsx]]
		+	*[[File:F60 4 Combined.xlsx]]

← Older revision		Revision as of 04:59, 20 November 2015
Line 67:		Line 67:
	*F60_4_Cy3: [[File:GSM496779 MR-1 F60 4 Cy3.xlsx]]		*F60_4_Cy3: [[File:GSM496779 MR-1 F60 4 Cy3.xlsx]]
	*F60_4:Cy5: [[File:GSM496779 MR-1 F60 4 Cy5.xlsx]]		*F60_4:Cy5: [[File:GSM496779 MR-1 F60 4 Cy5.xlsx]]
		+
		+	===Consolidating Files===

@@ Line 10: / Line 10: @@
 ==Files==
 *F1_1_Cy3: [[File:GSM496756 MR-1 F1 1 Cy3.xlsx]]
 *F1_1_Cy5: [[File:GSM496756 MR-1 F1 1 Cy5.xlsx]]
@@ Line 35: / Line 44: @@
 *F10_4_Cy5: [[File:GSM496767 MR-1 F10 4 Cy5.xlsx]]
 *F20_1_Cy3: [[File:GSM496768 MR-1 F20 1 Cy3.xlsx]]