Plot2Excel

General purpose engineering X-Y plotting tool

Plot2Excel is an Excel spreadsheet enhanced with Visual Basic for Applications to facilitate creating X-Y plots from large formatted data sets. It efficiently generates many plots with a user-controlled standard style.

Plot2Excel reads data sets written by SensorPlot with a specified format in Tab-delimited text files. The program allows the user to select data tables using an advanced search filter. Afterwards, any data columns from the selected tables can be plotted on the same chart with user-controlled size, style and axis scale. 

Plot2Excel creates descriptions of each plot and allows saving them as a text file called Plot-Log. Later you can import a new data set plus the saved Plot-Log file. By pressing a button, all plots are created with the new data, using the same format which was previously defined. More that 100 plots can be instantly generated with the Plot-Log function.

Third Party plotting packages that read Sensor binary output directly can be easier to use and more efficient for large-scale use.  We are not in the business of providing simulator pre- or post-processing tools.  These tools are provided with Sensor at no extra charge.

SensorPlot with Plot2Excel

SensorPlot is a post-processor program, which converts Sensor result files for graphical analysis with X-Y plotting application Plot2Excel. You can select data for plotting, compare multiple simulation runs, add observed data, make unit conversions and display results in MS Excel.

A Sensor reservoir simulation run creates a binary plot file “fort.61” containing calculated data for wells, platforms, regions, superregions, total field and traced components. SensorPlot includes the following capabilities to handle this data:

1. Convert the entire result file in Tab-delimited text form importable in MS Excel or any other spreadsheet type of program.

2. Select data for X-Y plotting with Plot2Excel. These commands create two tab-delimited text files. One contains selected data tables (*.tab) and is referred to as the data table file. The other contains plot-log information (*.plt) and is referred to as the plot-log file. Both files are used with Plot2Excel to automatically build these plots in MS Excel.

3. You can specify any number of Sensor result files to display the selected variables on the same plot. On the combined plots, different colors indicate each data source.

4. Add observed data for automatic plotting. Observed data is plotted in slightly larger symbols than calculated results and without connecting lines.

5. Make unit conversions for Sensor results and observed data with user-specified unit names and conversion factors.

The user can also write a program to read and process plot file results as required for plotting by the plot package of his choice, if it does not support Sensor output.  The simple plot file format is described in the SensorPlot Manual.

Images from SensorPlot - Plot2Excel