Difference between revisions of "Exporting plot data from Analyzer Plots"

From wiki.olisystems.com
Jump to: navigation, search
(Created page with " == Overview == The OLI Analyzers can provide a wealth of information about a chemical system. Sometimes you are interested in only a small portion of the data and do not wa...")
 
(→‎Exporting the plot to a graphics image file)
 
(3 intermediate revisions by 2 users not shown)
Line 3: Line 3:
  
  
−
The OLI Analyzers can provide a wealth of information about a chemical system. Sometimes you are interested in only a small portion of the data and do not want to sort through all the output. The plot options can easily reduce the massive amount of data to a smaller, manageable amount. In this guide we will show you a typical procedure to accomplish this task.
+
The OLI Studio can provide a wealth of information about a chemical system. Sometimes you are interested in only a small portion of the data and do not want to sort through all the output. The plot options can easily reduce the massive amount of data to a smaller, manageable amount. In this guide we will show you a typical procedure to accomplish this task.
  
 +
== Example ==
  
−
== Assumptions ==
+
In this example we are plotting the pH versus the amount of sodium hydroxide in the solution. This technique will work for any plotted variable. You will need to specify the units you want to use since they can not be automatically changed once the data is exported. Also, apply any formatting and title changes you wish at this time.
  
−
This procedure will only work in the OLI Analyzers version 2.0.16 and higher. We also assume that you can start and operate the OLI Analyzers and can plot your desired values.
+
[[File:2017-12-19 11-16-59.png]]
  
 +
To start the export, click the '''View Data''' button. 
  
−
== Example ==
+
This will display the data for the plot.
  
−
In this example we are plotting the molar electrical conductivity versus the amount of sodium hydroxide in the solution. This technique will work for any plotted variable. You will need to specify the units you want to use since they can not be automatically changed once the data is exported. Also, apply any formatting and title changes you wish at this time.
+
[[File:2017-12-19 11-20-46.png]]
  
−
[[File:Plot Image 1.jpg]]
+
Click the box in the upper left-hand corner
  
−
'''Figure 1 Standard OLI Analyzers Plot Dialog'''
+
This will select all the data in the grid. Then click the '''Edit''' button from the menu
  
−
To start the export, select Edit from the menu line.
+
[[File:2017-12-19 11-24-18.png]]
  
−
[[File:Plot Image 2.jpg]]
+
Select '''Copy''' from the drop-down menu
  
−
'''Figure 2 Select Copy'''
+
[[File:2017-12-19 11-26-01.png]]
  
−
Next select '''Copy''' from the drop-down menu. This will place both the plot (as a bitmap) and the plot data into the windows clip-board.
+
This places all the selected data into the Clip-Board paste buffer.
  
 +
== Start Excel ==
  
 +
Next start your spreadsheet program. The example here uses Microsoft Excel 2016.
  
−
== Start Excel ==
+
Since the data is in the paste buffer you can simply use the '''control-V''' paste function to paste the data.
  
−
Next start your spreadsheet program. The example here uses Microsoft Excel 2003.
+
Here is Excel before the operation
  
−
Select '''Edit''' from the menu line and then select '''Paste Special…''' from the drop-down menu.
+
[[File:2017-12-19 11-29-14.png]]
  
−
[[File:Plot Image 3.jpg]]
+
Select the cell where you want the data to be displayed and then press '''control-v'''
  
−
'''Figure 3 Select Edit and then Paste Special'''
+
[[File:2017-12-19 11-31-23.png]]
  
−
You will have several options. If you want the bitmap image to be in the excel document, select '''Bitmap'''.
+
At this point you all the standard Excel functions are available. It is important to note that the connection to OLI Studio is not maintained. If you need update Excel with new data you need to repeat these steps.
  
−
[[File:Plot Image 4.jpg]]
 
  
−
'''Figure 4 Selecting Bitmap'''
+
== Exporting the plot to a graphics image file ==
  
 +
'''Supported graphics images'''
  
−
[[File:Plot Image 5.jpg]]
+
The following file types are supported in the graphics export procedure:
  
−
'''Figure 5 The imported image'''
+
BMP - Bitmapped files
 +
JPG - JPEG files
 +
PNG - Portable graphic files
  
−
To import the actual data, repeat the Edit/Past Special… procedure above.
+
'''Export Procedure:'''
  
−
[[File:Plot Image 6.jpg]]
+
Display the plot you wish to export
  
−
'''Figure 6 the imported data'''
 
  
−
You may now manage the data within the spreadsheet. Please note, it is not necessary to import the bitmap image if you choose not to.
+
[[File:2017-12-19 11-35-28.png]]
  
  
−
== Exporting the plot to a graphics image file ==
+
Right-click anywhere on the plot:
 +
 
 +
[[File:2017-12-19 11-38-34.png]]
 +
 
 +
Select '''Save Image As...'''
 +
 
 +
[[File:2017-12-19 11-40-22.png]]
 +
 
 +
This dialog is similar to any windows file management window. 
 +
 
 +
Specify the '''Save as type:''' file type. Bitmaps tend to have the highest resolution but are the largest files, JPEG files are more compressible but the higher the compression the greater the degradation of the image. PNG files are easily compressed and have little loss but are not supported by all graphics programs.
  
−
'''Supported graphics images'''
+
Switch to your working folder then specify the name of your file.
  
−
The following file types are supported in the graphics export procedure:
+
Click the '''Save''' button.
  
−
BMP - Bitmapped files
+
[[Category:Tips]] [[Category:Former Tips]]
−
JPG - JPEG files
 
−
PNG - Portable graphic files
 

Latest revision as of 09:42, 19 December 2017

Overview

The OLI Studio can provide a wealth of information about a chemical system. Sometimes you are interested in only a small portion of the data and do not want to sort through all the output. The plot options can easily reduce the massive amount of data to a smaller, manageable amount. In this guide we will show you a typical procedure to accomplish this task.

Example

In this example we are plotting the pH versus the amount of sodium hydroxide in the solution. This technique will work for any plotted variable. You will need to specify the units you want to use since they can not be automatically changed once the data is exported. Also, apply any formatting and title changes you wish at this time.

2017-12-19 11-16-59.png

To start the export, click the View Data button.

This will display the data for the plot.

2017-12-19 11-20-46.png

Click the box in the upper left-hand corner

This will select all the data in the grid. Then click the Edit button from the menu

2017-12-19 11-24-18.png

Select Copy from the drop-down menu

2017-12-19 11-26-01.png

This places all the selected data into the Clip-Board paste buffer.

Start Excel

Next start your spreadsheet program. The example here uses Microsoft Excel 2016.

Since the data is in the paste buffer you can simply use the control-V paste function to paste the data.

Here is Excel before the operation

2017-12-19 11-29-14.png

Select the cell where you want the data to be displayed and then press control-v

2017-12-19 11-31-23.png

At this point you all the standard Excel functions are available. It is important to note that the connection to OLI Studio is not maintained. If you need update Excel with new data you need to repeat these steps.


Exporting the plot to a graphics image file

Supported graphics images

The following file types are supported in the graphics export procedure:

BMP - Bitmapped files JPG - JPEG files PNG - Portable graphic files

Export Procedure:

Display the plot you wish to export


2017-12-19 11-35-28.png


Right-click anywhere on the plot:

2017-12-19 11-38-34.png

Select Save Image As...

2017-12-19 11-40-22.png

This dialog is similar to any windows file management window.

Specify the Save as type: file type. Bitmaps tend to have the highest resolution but are the largest files, JPEG files are more compressible but the higher the compression the greater the degradation of the image. PNG files are easily compressed and have little loss but are not supported by all graphics programs.

Switch to your working folder then specify the name of your file.

Click the Save button.

Retrieved from "https://wiki.olisystems.com/wiki/index.php?title=Exporting_plot_data_from_Analyzer_Plots&oldid=4813"