|
The spreadsheet tool allows you to edit data from the database in spreadsheet format. Spreadsheet columns are made up of selected well header or zone data values. Options include copying, sorting, computing statistics, find/replace, among others.
Petra does not automatically save changes made in the Spreadsheet module to the project database unless instructed. The values displayed on the Spreadsheet are the values at the time the spread sheet was created. Any changes made in the Spreadsheet module must be saved to the project. Users must Save the changes to the project by selecting File > Save on the menu bar at the top of the screen or by selecting the "Yes" option when requested to Save.
To open the Spreadsheet:
·Click the Spreadsheet button  on the Main module toolbar
·Main module:Tools > Spreadsheet
The first time that the Spreadsheet Module is opened the Spreadsheet options dialog will open so that the default columns can be selected. Thereafter, the spreadsheet will open populated with the selected well values.
Click to enlarge image
|
|
Options
|
Opens the Spreadsheet Options Tool.
|
|
|
Reload Data
|
Manually refreshes the displayed data. Alternatively, select Columns>Reload from the menu bar at the top of the screen
|
|
|
Save Data
|
Saves changes to the project database. Alternatively, select File>Save on the menu bar at the top of the screen.
|
|
|
Find and Replace
|
Opens the Replace tool that performs a find/replace on the currently selected column.
|
|
|
Sort Ascending
|
Sorts the spreadsheet by the currently selected column in ascending alphabetical order.
|
|
|
Sort Descending
|
Sorts the spreadsheet by the currently selected column in descending alphabetical order
|
|
|
Show column statistics
|
Displays a list for well header info, and a histogram for numerical data items.
|
|
|
Save to CSV
|
Exports and opens Petra spreadsheet in external spread sheet application.
When saving well remarks, line breaks are replaced with spaces so that entire remarks field is one line in the .CSV file. This is compatible with S&P GlobalKingdom software
|
|
|
Read Only Checkbox
|
Disables Spreadsheet Module from writing back to the project database. This is intended as a safeguard to prevent data from accidentally being modified.
|
Related Topics:
Selecting columns
Working with columns
|
