Cookies help us deliver our services. By using our services, you agree to our use of cookies. More information

Difference between revisions of "DatLab-Analysis templates"

From Bioblast
Line 1: Line 1:
{{MitoPedia
{{MitoPedia
|description=Go in DatLab to [[Mark statistics - DatLab|Mark statistics]] (F2), select which type of marks you want to export ("All marks in plot" or "DL-protocol marks", with 3 possibilities each), then click on [Copy to clipboard] to copy selected values and paste them to a '''DatLab-Analysis template''' for numerical and graphical data analysis.
|description=Go in DatLab to [[Mark statistics - DatLab|Mark statistics]] (F2), select which type of marks you want to export ("All marks in plot" or "DL-Protocol marks", with 3 possibilities each), then click on [Copy to clipboard] to copy selected values and paste them to a '''DatLab-Analysis template''' for numerical and graphical data analysis.
|info=[[MitoPedia: DatLab]]
|info=[[MitoPedia: DatLab]]
}}
}}
Line 16: Line 16:




Β Β  Version: DatLab 7 - work in progress
Β Β  Version: DatLab 7 Β 


== Colour codes ==
== Colour codes ==
::::* Yellow: you have to copy/enter something here. Β 
::::* Yellow: you have to paste/edit something here. Β 
::::* Cyan: a hyperlink to another cell within the DatLab-Analysis template.
Β 
::::* Light blue: a hyperlink to a web page.


== Guidelines ==
== Guidelines ==


::::# Make sure that the DatLab-Analysis template corresponds with the protocol of your experiment. Open the chosen template and click at tab #1. Check if the reference mark names (row 33) correspond to the protocol of your experiment.
::::# Select the DatLab-Analysis template for your specific SUIT protocol. In DatLab, in the pull-down menu 'Protocols: SUIT: Browse DL-Protocos and templates', select your specific SUIT protocol and open the chosen DatLab-Analysis template.
::::# Select the tab "Navigation". Fill in the sample number (Sample.Subsample: i.e. 1.1) in column E of your experiment and create a hyperlink to each individual DatLab file in column F. It is recommended to save the DatLab-Analysis template and the DatLab files in the same subdirectory.
::::# Make sure that the DatLab-Analysis template corresponds with the protocol of your experiment.
::::# Set the [[mark]s on the flux (or flow, slope) plot of your subsample. Press [F2] to open [[Mark statistics - DatLab|Mark statistics]] (O2 slope neg.) and [Copy to clipboard].
::::# Create a copy for your data analysis.
::::# In the DatLab-Analysis template, select the tab # (#1; #2; ...) for your sample (tab #1 may be different from the Sample number in your experiment [F3]). Click on the hyperlink ['''↓ Subsample entry #a'''; #b; #c; ..] and ['''β†’ Mark statistics'''], taking you to the yellow cell in column AA. Press [Ctrl-V] to paste the data of your subsample from Mark statistics in DatLab into the yellow cell under column AA.
::::# In the copied Excel file, select the tab "Data". Β 
::::# Copy the graph in DatLab. Go to the DatLab-Analysis template, click on ['''←  Graph'''], and paste into the yellow cell for the subsample. Adjust the length of the graph to 20 cm (8 inch).
::::# In DatLab go to [[Mark statistics - DatLab|Mark statistics]] (F2), select in "DL-Protocol marks": Slope uncorrected + all info. Click on [Copy to clipboard] to copy selected values.
::::# Proceed with all subsamples (the template provides 8 subsamples: #a,#b,#c,#d,#e,#f,#g and #h for each sample).
::::# In the DatLab-Analysis file paste the selected values in the cell A7. Β 
::::# Repeat for all samples. Currently 6 tabs are provided for independent samples (#1,#2,#3,#4,#5 and #6).
::::# Select tab '''Cohort'''.Β  Enter a short acronym for your cohort in cell E1 (yellow). This tab provides automatically a summary of your experimental cohort.
Β 


== Concept ==
== Concept ==
Line 41: Line 37:
Β Β  Version: up to DatLab 6
Β Β  Version: up to DatLab 6


::::* DatLab-Analysis templates are provided for DatLab 7. For using previous DatLab-Analysis template/own Excel templates:
::::# Select a [[Layout for DatLab graphs]] with the plot of O2 [[Oxygen flux|flux]] or O2 [[Oxygen flow|flow]] normalized for the sample concentration.
::::# Select a [[Layout for DatLab graphs]] with the plot of O2 [[Oxygen flux|flux]] or O2 [[Oxygen flow|flow]] normalized for the sample concentration.
::::# Set marks on the plot for O2 [[Oxygen flux|flux]] or O2 [[Oxygen flow|flow]].
::::# Set marks on the plot for O2 [[Oxygen flux|flux]] or O2 [[Oxygen flow|flow]].
::::# Press [F2] (or click on Marks \ Statistics). Then click on [Copy to clipboard] to copy selected values and paste them to an DatLab-Analysis template for flux analysis.
::::# Press [F2] (or click on [[Mark statistics - DatLab|Mark statistics]]) and select "Flux/flow" marks. Click on [Copy to clipboard] to copy selected values.




== DatLab-Analysis templates for instrumental quality control ==
== DatLab-Analysis templates for instrumental quality control ==


::::Β» Template: [[Media:O2 calibration.xlsx|O2 calibration.xlsx]] - [[MiPNet06.03 POS-calibration-SOP]]
::::* Select the DatLab-Analysis template for instrumental quality control:
::::Β» [[MiPNet14.06 Instrumental O2 background]]
::::# In DatLab, in the pull-down menu 'Instrumental: Browse DL-Protocos and templates', select your specific DatLab-Analysis template for instrumental quality control.

Revision as of 11:52, 7 February 2019


high-resolution terminology - matching measurements at high-resolution


DatLab-Analysis templates

Description

Go in DatLab to Mark statistics (F2), select which type of marks you want to export ("All marks in plot" or "DL-Protocol marks", with 3 possibilities each), then click on [Copy to clipboard] to copy selected values and paste them to a DatLab-Analysis template for numerical and graphical data analysis.


Reference: MitoPedia: DatLab





MitoPedia O2k and high-resolution respirometry: DatLab 



DatLab-Analysis templates for O2k-analysis of respiratory flux - strategy

DatLab-Analysis templates are made available for specific SUIT protocols, to express respiration as oxygen flux or oxygen flow normalized for sample concentration, and as flux control ratios, FCR and flux control factors, FCF.


 Version: DatLab 7 

Colour codes

  • Yellow: you have to paste/edit something here.


Guidelines

  1. Select the DatLab-Analysis template for your specific SUIT protocol. In DatLab, in the pull-down menu 'Protocols: SUIT: Browse DL-Protocos and templates', select your specific SUIT protocol and open the chosen DatLab-Analysis template.
  2. Make sure that the DatLab-Analysis template corresponds with the protocol of your experiment.
  3. Create a copy for your data analysis.
  4. In the copied Excel file, select the tab "Data".
  5. In DatLab go to Mark statistics (F2), select in "DL-Protocol marks": Slope uncorrected + all info. Click on [Copy to clipboard] to copy selected values.
  6. In the DatLab-Analysis file paste the selected values in the cell A7.

Concept

  1. The normalization for sample concentration is transferred into a DatLab-Analysis template, since (1) in some cases the final sample concentration is not known until a later time point (e.g. protein or CS determination), and different markers may be used for different aspects of the analysis; (2) the sample (isolated mitochondria, homogenate, cell suspensions) is diluted during titrations, and the dilution effect is calculated in the DatLab-Analysis template.
  2. A logical next step: instrumental O2 background parameters may not be known at the time of the experiment, particularly when brackting instrumental quality control is performed (before and after the experiment). Finally optimized background parameters may be calculated at the end of a complete experimental series, combining several relevant instrumental O2 background tests. Up to now, the DatLab-Analysis files do not document the instrumental O2 background parameters. For quality control each individual DatLab file has to be checked. Therefore, the logical next step is to export from Mark statistic only slopes (O2 slope neg.) for complete data analysis in the DatLab-Analysis template. There, the instrumental O2 background correction is easily implemented, adjustments of parameters are quickly performed, actual parameters used can be much more quickly checked, and documentation for tracing is provided in the DatLab-Analysis files in a more complete and compact form.
 Version: up to DatLab 6
  • DatLab-Analysis templates are provided for DatLab 7. For using previous DatLab-Analysis template/own Excel templates:
  1. Select a Layout for DatLab graphs with the plot of O2 flux or O2 flow normalized for the sample concentration.
  2. Set marks on the plot for O2 flux or O2 flow.
  3. Press [F2] (or click on Mark statistics) and select "Flux/flow" marks. Click on [Copy to clipboard] to copy selected values.


DatLab-Analysis templates for instrumental quality control

  • Select the DatLab-Analysis template for instrumental quality control:
  1. In DatLab, in the pull-down menu 'Instrumental: Browse DL-Protocos and templates', select your specific DatLab-Analysis template for instrumental quality control.