Software- Prepare DataSet Report

1. In Excel, open the large output file (ie F014587.csv.Proteins.csv.SummedProteinValues.out (2-5 Mb))- from the last perl script ProteinCalculate.pl
2. Select all Cells and copy into worksheet "DetailedResults" of the 'ProteinListReportGenerator.xls'.
3. Run the Macro 'ProteinListReportGenerator'.
4. The tasks performed by the macro include-
   1. Sorting the list alphabetically, and highlight key proteins:
      1. For Genetech- "Complement*", "Clusterin", "Metaloproteinase", "Vitronectin"
      2. For Visual Cyclel "CRALBP, LRAT, RPE65, RDH5, Ezrin, etc...
   2. Sort the list by Number of iTRAQ Peptides, and split off the One-hit wonders into a seperate list following the more reliable identifications
   3. Sort the proteins with 2 or more IDs by iTRAQ ratio with the largest number (ie most abundant in diseased vs Normal) at the top with the rest descending.
5. With the requirements met, Save Worksheet as ("F014587(Concise)") in the excel report file.
6. When preparing report address presentation settings including:
   1. Add Title- updated with relevant details- especially Sample number and date
   2. Add header rows with exact labels,
   3. specific Type-size,
   4. font,
   5. Boldness,
   6. Column Width,
   7. Merged,
   8. centered,
   9. number of Significant digits.
7. Once report is finished for experiment, it must be added to the summary table.