GRNmap Testing Report .xlsx vs. .xls 2015-05-27: Difference between revisions

From OpenWetWare
Jump to navigationJump to search
(Add section about how to Analyze the Results)
(Remove june 3 and move to new page)
 
(14 intermediate revisions by the same user not shown)
Line 1: Line 1:
==GRNmap Testing Report==
==Test Conditions==
*Date started: 2015-05-27
*Date started: 2015-05-27
*Code Version: "current" version from Dr. Fitzpatrick 2014-09-18
*Test Performed by: [[User:Tessa A. Morris| Tessa A. Morris]], [[Tessa A. Morris Electronic Lab Notebook| Electronic Notebook]]
*[https://github.com/kdahlquist/GRNmap/archive/v1.0.6.zip GRNmap] version 1.0.6
*Code Version: [https://github.com/kdahlquist/GRNmap/archive/v1.0.6.zip GRNmap] version 1.0.6
*MATLAB Version: 2014b
*MATLAB Version: 2014b
*Model was run on the following computer: Row#2 4
*Computer on which the model was run: Row 2 4th from door


==Input, Output, and Plots==
==Purpose==
*The purpose was to test if there was a difference between running an .xlsx and an .xls file.
*[https://github.com/kdahlquist/GRNmap/issues/97 Issue 97]
==Results==
*22-genes_47-edges_Dahlquist-data_MM_estimation_fixP-1_graph.xls
*22-genes_47-edges_Dahlquist-data_MM_estimation_fixP-1_graph.xls
**[[Media:22-genes 47-edges Dahlquist-data MM estimation fixP-1 graph.xls| 22-genes_47-edges_Dahlquist-data_MM_estimation_fixP-1_graph.xls]]
**[[Media:22-genes 47-edges Dahlquist-data MM estimation fixP-1 graph.xls| 22-genes_47-edges_Dahlquist-data_MM_estimation_fixP-1_graph.xls]]
Line 24: Line 27:
**[[Media: 22-genes 47-edges Dahlquist-data Sigmoid estimation fixb-1 fixP-1 graph xlsx.zip| 2-genes_47-edges_Dahlquist-data_Sigmoid_estimation_fixb-1_fixP-1_graph_xlsx.zip]]
**[[Media: 22-genes 47-edges Dahlquist-data Sigmoid estimation fixb-1 fixP-1 graph xlsx.zip| 2-genes_47-edges_Dahlquist-data_Sigmoid_estimation_fixb-1_fixP-1_graph_xlsx.zip]]


==Methods==
==Discussion==
=== Preparing the input sheets ===
# Download [[Media:22-genes_47-edges_Dahlquist-data_MM_estimation_fixP-1_graph.xlsx| 22-genes_47-edges_Dahlquist-data_MM_estimation_fixP-1_graph]] and [[Media:22-genes_47-edges_Dahlquist-data_Sigmoid_estimation_fixb-1_fixP-1_graph.xlsx| 22-genes_47-edges_Dahlquist-data_Sigmoid_estimation_fixb-1_fixP-1_graph]] from a previous experiment [[GRNmap Test Inputs| comparing the sixteen possible options for the input sheet]].
# Both of these files should be in .xlsx format. Open them in Microsoft Excel, enable editting and save as an .xls file.
# Upload the input sheets to openwetware.
===Running GRNmap===
# Download the current version of [https://github.com/kdahlquist/GRNmap/archive/v1.0.6.zip GRNmap] from GitHub, in this case we are using version 1.0.6. 
#* Save it into a new folder called "GRNmap" on the Desktop.
#* Unzip the file by right-clicking on it and choosing 7-zip > Extract here.
# Drag the four input sheets into the "matlab" subfolder of "GRNmap-1.0.6". To keep it organized I created two folders within the "matlab" subfloder called "Need to Run" and "Ran".
# Open the "GRNmap-1.0.6" folder and open the "matlab" subfolder.  Double-click on the file "GRNmodel.m" to open GRNmap in MATLAB 2014b.
# Click on the green triangle "Run" button to run the model.
#* You will be prompted by an Open dialog to find your input file that you created in the previous section.  Browse and select this input file and click OK.
#* Note that the Open dialog will default to show files of <code>*.xlsx</code> only.  If your file is saved as <code>*.xls</code>, you will need to select the drop-down menu to show all files.
#* A window called "Figure 1" will appear.  The counter is showing the number of iterations of the least squares optimization algorithm.  The top plot is showing the values of all the parameters being estimated.  You should see some movement of the diamonds each time the counter iterates.
# Once the model has completed its run, plots showing the expression over time for all of the genes in the network will appear if "makeGraphs" was set to 1. The plots will automatically be saved as <code>*.jpg</code> files in the same folder as your input file.  Compile the figures into a folder following the naming convention described earlier. Compress this folder by right clicking then selecting "7-zip" and "Add to archive...". Make sure the archive format is "zip."
#* Note that because in this case the file names are essentially the same with the file extension being different, there may be some issues. I added _xls or _xlsx to the names of the folders so they would not overwrite. I did not run into any issue with Matlab because I moved the .mat files into the folder "Ran" for the first run (.xls) but when I tried to move the second output (.xlsx) there was an issue because it had the exact same name. To rectify this, windows added a (2) to the end of the second .mat file). The .mat files will likely not be needed in this experiment, so it should not cause problems.
# Upload the output sheet and the zipped folder with the output plots onto openwetware.
# After the initial run, type the commands "clear all" and "close all" then "GRNmodel" and select the input sheet to run.
===Analyzing the Results===
#The production rate and threshold b values will not be used in the data analysis. The version of Matlab has the previously documented errors with P and b for the Sigmoidal. The Michealis Menten model does not make use of the term b and also has an error with the production rate.
#The simplest way to understand if there is a difference in the weights between .xlsx and .xls is to subtract the matrices. This is done in excel by selecting a blank area with the same dimensions as the two matrices. In the formula bar type =(All of Matrix "xls")-(All of Matrix "xlsx") then press "Control" "Shift" "Enter". These should all be pressed at the same time.
#Find the sum of the comparison matrix, as well as the median and mean. This should provide insight into whether there is a notable difference between using .xlsx and .xls
 
==Observations==
*If a file is in the .xls format, the output will also be .xls. GRNsight can only handle .xlsx files so the file will need to be converted into a .xlsx before being visualized using GRNsight.  
*If a file is in the .xls format, the output will also be .xls. GRNsight can only handle .xlsx files so the file will need to be converted into a .xlsx before being visualized using GRNsight.  
*[[Media:GRNmap Testing Report xlsx vs xls 2015-05-27 Summary Statistics.xlsx| Summary Statistics]]
*The [[Media:GRNmap Testing Report xlsx vs xls 2015-05-27 Summary Statistics.xlsx| Summary Statistics]] showed that there was not a notable difference between using .xlsx and .xls.
*The maximum of the MM difference matrix was 4.74681E-07 and the maximum of the Sigmoidal difference matrix was 4.51574E-06.
*The small differences were due to rounding errors, rather than an error in the program.


{{Template:Tessa A. Morris ELN}}
[[Category:Dahlquist Lab]]
[[Category: GRNmap]]

Latest revision as of 10:15, 3 June 2015

Test Conditions

Purpose

  • The purpose was to test if there was a difference between running an .xlsx and an .xls file.
  • Issue 97

Results

Discussion

  • If a file is in the .xls format, the output will also be .xls. GRNsight can only handle .xlsx files so the file will need to be converted into a .xlsx before being visualized using GRNsight.
  • The Summary Statistics showed that there was not a notable difference between using .xlsx and .xls.
  • The maximum of the MM difference matrix was 4.74681E-07 and the maximum of the Sigmoidal difference matrix was 4.51574E-06.
  • The small differences were due to rounding errors, rather than an error in the program.
Retrieved from "https://openwetware.org/mediawiki/index.php?title=GRNmap_Testing_Report_.xlsx_vs._.xls_2015-05-27&oldid=887560"