Editing with the Spreadsheet Editor (G11)
Contents
1. Delete Field Delete Current Row Delete Current Group Conditional Delete Replace Navigate Find OK Cancel Update Immediately oe lose anir T INTREPID will find and display the first data point that matches this condition fa Intrepid Spreadsheet Editor oe tL es File Edit Format Macros Help First value lt 1959 Edit Cell 1973 71 lt lt Prev Group roup gt gt line linetype _ T mlevel_mag 253 628148 2793 1958 99 254 628150 1958 92 255 628152 1958 91 256 2 1958 89 257 2 1958 86 258 2 1958 88 259 2 1958 86 260 2 1958 89 j 261 Intrepid Spreadsheet Editor 262 l 263 File j 264 Position in the dataset 265 266 267 268 269 For ACTION and dyf ction of Find Backward Forward 270 271 628184 Cancel 272 628186 4 C Intre pid 4 5 s ample_data guided_tours intrepyf_datasets ebagoola_ST DIR HL Group 7 of 36 809 rows on this group Choose OK in the Find dialog box to dismiss it 2012 Intrepid Geophysics 4 Back gt INTREPID User Manual Editing with the Spreadsheet Editor G11 7 Library Help Top Library Help Top S drei siete m Intrepid Spreadsheet Editor o q Back gt Creating a new field column and assigning values using the Replace operation Navigate to the beginning of the dataset 4 Return to Row 1 of Group line 1 of the dataset Choose Navigate from the Edit menu IN2. 8139 74 8408139 73 8408138 72 8408137 72 8408136 71 8408134 70 8408133 69 8408132 79 8408131 78 8408130 76 8408128 75 8408127 73 8408126 71 8408125 69 8408125 77 8408124 75 8408124 73 m 1972 36 1972 30 1972 33 1972 40 1972 34 f 8 Use the scroll bars and Previous and Next Groups buttons to examine the results of your search and replace operation mlevel_mag 1968 97 1968 83 1968 82 1968 73 1968 66 1968 63 1968 54 1968 52 1968 57 1968 59 1968 48 1968 50 1968 51 1968 35 1968 50 1968 41 1968 32 1968 39 1968 20 1968 25 Not greater than 1969 mag_adjust1 1968 97 1968 83 1968 82 1968 73 1968 66 1968 63 1968 54 1968 52 1968 57 1968 59 1968 48 1968 50 1968 51 1968 35 1968 50 1968 41 1968 32 1968 39 1968 20 1968 25 Group 1 Rows 476 495 mlevel_mag 1973 71 1973 77 1973 80 1973 75 1973 72 1973 78 1973 69 1973 66 1973 70 1973 58 1973 52 1973 57 1973 53 1973 50 1973 51 1973 55 1973 48 1973 52 1973 58 1973 52 mag_adjust1 1972 53 1972 59 1972 62 1972 57 1972 54 1972 60 1972 51 1972 48 1972 52 1972 40 1972 33 1972 38 1972 34 1972 31 1972 32 1972 36 1972 30 1972 33 1972 40 1972 34 Greater than 1969 Group 1 Rows 1 20 9 If someone else will be using this guided tour restore the value changed in Step 2 and delete the field mag_adjl1 from the dataset Exit from the Spreadsheet tool Return to Row 1 of Group 1 as explained in Step 4 Reve
3. Edit Cen f1973 71 lt lt Prev Group Next Group gt gt New tri g adl a l E ma maga column 8408141 75 8408141 75 contains nulls at first 8408140 75 8408140 75 8408140 75 8408140 75 8408139 74 8408139 74 8408139 73 8408139 73 8408138 72 8408138 72 8408137 72 8408137 72 8408136 71 8408136 71 8408134 70 8408134 70 8408133 69 8408133 69 8408132 79 8408132 79 8408131 78 8408131 78 8408130 76 8408130 76 8408128 75 8408128 75 8408127 73 8408127 73 8408126 71 6408126 71 8408125 69 8408125 69 8408125 77 8408125 77 8408124 75 8408124 75 8408124 73 8408124 73 m aon Oink wN C Intre pid 4 5 s ample_data guided_tours intrepid_datasets ebagoola_ST DIR Group 1 of 36 525 rows on this group Library Help Top 2012 Intrepid Geophysics lt 4 Back gt INTREPID User Manual Library Help Top Editing with the Spreadsheet Editor G11 9 4 Back gt Set decimal places for 6 Set the number of decimal places for the field to 2 From the Format menu choose Format Column INTREPID displays the Format display Columns dialog box Select double click the field mag_adj1 INTREPID will display its default display values for width and decimal places Enter 2 into the Decimals text box ri Intrepid Spreadsheet Editor f File Edit eens Help Column Format B or O Detail Cell Report e aaa linetype mlevel_mag smooth
4. Help Top 2012 Intrepid Geophysics 4 Back gt
5. INTREPID User Manual Editing with the Spreadsheet Editor G11 1 Library Help Top lt 4 Back gt Editing with the Spreadsheet Editor G11 Top The Spreadsheet Editor provides a numerical view of an INTREPID dataset It enables you to directly edit data create and manipulate fields and perform search and replace operations using mathematical formulas You can edit line point polygon grid voxets and SEGY data using the Spreadsheet Editor In this guided tour we will edit a line dataset The following illustration shows the specifications for a search and replace operation and some resulting values IF mlevel_mag gt 1969 amp amp linetype THEN mag_adj1 mlevel_mag 9994 ELSE mag_adj1l mlevel_mag mlevel_mag mag_adjust1 mlevel_mag mag_adjust1 1973 71 1972 53 1973 77 1972 59 1973 80 1972 62 1973 75 1972 57 1973 72 1972 54 1973 78 1972 60 1973 69 1972 51 1973 66 1972 48 1973 70 1972 52 1973 58 1972 40 1973 52 1972 33 1973 57 1972 38 1973 53 1972 34 1973 50 1972 31 1973 51 1968 41 1968 41 1973 55 1972 36 1968 32 1968 32 1973 48 1972 30 1968 39 1968 39 1973 52 1972 33 1968 20 1968 20 1973 58 1972 40 1968 25 1968 25 1973 52 1972 34 Not greater than 1969 Greater than 1969 1972 32 You can view and edit all of the new extended datatypes using this tool including tensor components gradient vectors complex structural geology and dates Overview The INTREPID Spreadsheet Editor is one of the IN
6. TREPID displays the Navigate dialog box Enter the value 1 into each of the three text boxes ai Se ae File Format Macros Help Edit Create New Field Navigate Insert Row After Current Row Split Group At Current Row Group i Join Group To Previous Group P i Sort Groups Row ji B a Delete Field oo Colum ni 1 21 Delete Current Row 21 Delete Current Group 21 Conditional Delete Ap P ly Clos e 4 Replace 2l of Navigate Find 2l I Update Immediately 2RR TR2817 Choose Apply INTREPID displays the first row of the first group line in the Spreadsheet window File Edit Format Macros Help 1973 71 1973 77 1973 80 1973 75 1973 72 1973 78 1973 69 1973 66 O N min hk Ww N m 9 1973 70 10 1973 58 11 12 l 13 14 15 Navigate 16 394222 17 394224 caup a l 18 394226 Row eooo i 19 394228 Colum 20 394230 _Apply Close C Intre pid 4 5 s ample_data guided_tours intrepro oa atlas etsyevago0ld oT UIr Group 1 of 36 525 rows on this group Choose Close in the Navigate dialog box to close it Tip You can leave the Navigate dialog box open for further use if required You can change focus between the Spreadsheet window and the Navigate dialog box as required 2012 Intrepid Geophysics 4 Back gt INTREPID User Manual Editing with the Spreadsheet Editor G11 8 Library Help Top lt 4 Back gt Create a n
7. TREPID editors Spreadsheet Flight Path split cruise clip line and Profile The INTREPID Spreadsheet Editor enables you to e Directly edit data by erasing and retyping individual values e Search for data according to a mathematical formula e Create a new field in a vector dataset or a new grid band e Usean f Then Else search and replace operation to assign values ina dataset Apply arithmetic statistical and geophysical functions in a flexible formula format 1 8 Use the field name mag_adj1 not mag_adjust1 when you use this guided tour Library Help Top 2012 Intrepid Geophysics 4 Back gt INTREPID User Manual Editing with the Spreadsheet Editor G11 2 Library Help Top 4 Back gt The Spreadsheet Editor e Has a wide range of arithmetic statistical and geophysical functions in a flexible formula format Supports ALL INTREPID data formats vector line point polygon grid voxet and SEGY e Supports grid level arithmetic you can add and subtract entire grids and create new grids Supports user written code e Supports smart geophysical observed data objects such as Full magnetic tensor gradients combined with a scalar magnitude reading or at V5 0 MT data 2D complex tensor decays The V5 0 replacement tool is known as Gravitas Context of this guided tour In the context of your data processing cycle this tour represents direct editing and mathematical enhanc
8. _mag raw_mag x_trim os Specify Format Width characters Decimal Places 2 Apply Cancel Choose Apply Choose Cancel to dismiss the box Use Replace 7 Assign the value of the new column field mag_adj1 by using the Replace function with an to define a logical condition expression expression to assign values to the new field From the Edit menu choose Replace INTREPID displays the Replace dialog box Enter the following into the corresponding text boxes of the dialog box If mlevel_mag gt 1969 Then Else mag_adjl mlevel_mag 9994 mag_adjl mlevel_mag Use of logical AND operator optional You can use the following for the IF text box instead if you wish This restricts the replacement to acquisition lines NS line type 2 amp amp is the notation for logical AND and is the notation for is equal to in a condition expression following the C language convention If mlevel_mag gt 1969 amp amp linetype Choose OK INTREPID displays a Confirm Overwrite dialog box r Intrepid Spreadsheet Editor l _e Replace Intrepid Spreadsheet Editor File Format Macros Help Edit Create New Field Please Choc Overwrite Insert Row After Current Row Library Help Top ma Split Group At Current Row Join Group To Previous Group Sort Groups Delete Field Delete Current Row Delete Current Group Conditional Delete Replace Navigate Fi
9. ement of data that you could wish to do at any stage The use of the fully corrected mlevel_mag field puts the tour slightly out of sequence in our case study since this field will be officially created in a later tour See Levelling decorrugation and microlevelling G14 We chose mlevel_mag because the example in this tour would most likely be applied to fully corrected data Should you complete this guided tour W Library Help Top This guided tour is intended for intermediate level users Its process is more complex than that of an introductory level tour and its instructions are less detailed If you are a beginner or wish only to have a brief overview of INTREPID s capabilities you can omit this guided tour Omitting this guided tour will not affect your understanding of later tours The ability to directly edit values and mathematically enhance data using your own formula is a desirable feature of a geophysical data processing system You should note that INTREPID includes an extensible API for this kind of operation The example macros are distributed Location of sample data for Guided Tours We provide two complete sets of sample datasets one in INTREPID format and one in Geosoft format INTREPID works equally well with both formats When you want to open a dataset navigate to the directory containing the required data format Where install_pathis the path of your INTREPID installation the project directories
10. ew 5 Create a new column i e new field called mag_adjl1 field Choose Create Column from the Edit menu INTREPID displays the Create Column dialog box Type mag_adj1i into the Field name text box _ o T a Z Intrepid Spreadsheet Editor m i e File Format Macros Help Field Name mag_adjl Create New Field Supported Data Types for Both Grid amp Databases Insert Row After Current Row Data Type Signed16Bitinteger C Signed32Bitinteger Split Group At Current Row C IEEE8ByteReal Logical Character Byte Join Group To Previous Group Sort Groups Tensor Delete Field Following not Supported for OASIS style Delete Current Row Yector C Gradients C Components Delete Current Group fs C i j C i Ca e Complex Observation Object Quaternion Date Geological Structure Replace Field measurement coordinate convention East North Down C ENU C NED C END i Group By Navigate Find Update Immediately Initial Assigment Any combination of field name function or constant Load Formula Save Formula Initial Operators OK Cancel Choose OK INTREPID will create the new column at the right hand end of the spreadsheet By default all values in the field will be set to Null Use the horizontal scroll bar to view the new field move the scroll box to the right Bepa spe tae T eE File Edit Format Macros Help
11. for the Guided Tours sample data are install_path sample_data guided_tours intrepid_ datasets and install_path sample_data guided_tours geosoft_datasets For example if INTREPID is installed in C Program Files Intrepid Intrepid4 5 nnn then you can find the INTREPID format sample data at C Program Files Intrepid Intrepid4 5 nnn sample_data guided_tours intrepid_ datasets This is the default location for the sample data If you have installed INTREPID normally the data resides there If you have installed INTREPID elsewhere the exercises will work just as well Just use the appropriate pathnames 2012 Intrepid Geophysics 4 Back gt INTREPID User Manual Editing with the Spreadsheet Editor G11 3 Library Help Top 4 Back gt For more information about installing the sample data see Sample datasets installing locating naming in INTREPID Guided Tours Introduction G01 For a more detailed description of INTREPID datasets see Introduction to the INTREPID database G20 For even more detail see INTREPID database file and data structures R05 Location of sample data for CookBooks Right next to the Guided tours data is a rich set of more exotic geophysics datasets and grids already prepared for the cookbook training sessions A casual user might also gain some trial and error insights into the capbilities of the software just by testing the Project Manger s ability to preview and describe the attr
12. ibutes of each of the cookbook datasets What you will do Flowchart Summary Library Help Top Inputs Process Outputs Intrepid o Examine a dataset dataset y A Edit orcreate new fields ina dataset x y Save gt Edited dataset dataset New paseo ee gt Fields in datset 2012 Intrepid Geophysics 4 Back gt INTREPID User Manual Editing with the Spreadsheet Editor G11 4 Library Help Top Steps to follow Launch the 1 Spreadsheet Editor lt 4 Back gt Start the Project Manager Navigate to the directory install _path sample_ data guided_tours intrepid datasets Start the Spreadsheet Editor Choose File gt Open Dataset When the Load Dataset dialog box appears select the line dataset ebagoola_ST See Locating datasets viewing statistics launching tools G02 for instructions about navigating to different directories and selecting datasets Choose Spreadsheet Editor from the Editors menu After opening the dataset ebagoola_ST it displays the tabular data in the Spreadsheet Editor window Each column in the spreadsheet corresponds to a field in the dataset The first row of each column is preceded by the name of the field I Project Manager ebagoola_ST DIR o o a Hj File Dataset Editing Editing Display Levelling Gridding Filtering Mapping Gunny Radior current Folder Spreadsheet Editor guided _ tours intrepid_dataset
13. iting with the Spreadsheet Editor G11 5 Library Help Top 4 Back gt Edit Cell 197 4 Edit Cell E W371 Library Help Top 2012 Intrepid Geophysics 4 Back gt INTREPID User Manual Library Help Top Search for a data point matching a condition Library Help Top Editing with the Spreadsheet Editor G11 6 4 Back gt Press ENTER INTREPID displays the new value in the spreadsheet dit Cell 1973 71 lt lt Prev Group Next Group gt gt fid line mlevel_ma 1973 71 1079 77 linetype Tip Remember that INTREPID saves your changes directly to the dataset files when you use the Spreadsheet Editor This enables you to edit very large datasets without having to load them into your computer s memory Finding a certain value in a field 3 Find the first data point in the dataset where the field mlevel_mag has a value less than 1959 Choose Find from the Edit menu INTREPID displays the Find dialog box Type mlevel_mag lt 1959 into the Search for text box Choose Forward een ow a Intrepid Spreadsheet Editor File Format Macros Help Create New Field Intrepid Spreadsheet Editor File Insert Row After Current Row Split Group At Current Row Search Relationships 2S P aa l HE Search For mlevel_mag lt 1959 Between START and For ACTION and direction of Find Backward Forward Join Group To Previous Group Sort Groups
14. nd Update Immediately R4NKR1IN 7R Choose Yes 2012 Intrepid Geophysics Formula Options Load Formula Save Formula Formula Definition lf Relationships gt lt mlevel_mag gt 1969 Yes No Then Else Assigment Any combination of field name function or constant Then Else Operators 7 Then mag_adj1 mlevel_mag 0 9994 i Else __ mag_adj1 mlevel_mag Between gt TART and END OK Cancel 4 Back gt INTREPID User Manual Library Help Top Examine the new field values Exit Library Help Top Editing with the Spreadsheet Editor G11 10 lt 4 Back gt INTREPID will calculate values for the mag_adj1 column field Note Use the field name mag_adj1 when you use this guided tour not mag_adjusti1 as shown in the illustrations Intrepid Spreadsheet Editor in INETEPIC DP ee File Edit Format Macros Help Edit Cellf1 973 71 lt lt Prev Group Next Group gt gt O N On hk we N m 20 4 C Intre pid V 4 5 s ample_data guided_tours intrepid_datasets ebagoola_ST DIR trim 8408141 75 8408140 75 8408140 75 8408139 74 8408139 73 8408138 72 8408137 72 8408136 71 8408134 70 8408133 69 8408132 79 8408131 78 8408130 76 8408128 75 8408127 73 8408126 71 8408125 69 8408125 77 8408124 75 8408124 73 Group 1 of 36 525 rows on this group 8408141 75 8408140 75 8408140 75 840
15. of tools including Spreadsheet Subsection and Levelling See INTREPID expressions and functions R12 for a complete list The list includes e Arithmetic expressions Trigonometric functions e Logical expressions e Statistical functions Tensor conversions Q I wish to use my own secret high performance filter Can I use it with INTREPID without having to reveal it outside my organisation A Yes You can write code for your filter macros using our very simple published database Application Programmer Interface You can then call your code and pass parameters to it like any other Spreadsheet function If you require assistance with this process contact our technical support service Q Can I edit grids A Yes The INTREPID Spreadsheet Editor supports grids You can perform simple and effective grid operations using arithmetic operations Q Can I load multiple grids and compare them A Yes The Spreadsheet Editor supports activities such as grid arithmetic between grids Q Can you delete and split groups and rows A Yes You can automate the process using conditional operators INTREPID expressions and functions R12 Library Help Top 2012 Intrepid Geophysics 4 Back gt INTREPID User Manual Editing with the Spreadsheet Editor G11 12 Library Help Top 4 Back gt Q Can I edit tensor data A Yes a Mohr circle diagram is used to visualise the tensor relationships Library
16. rse the process in Step 2 to restore the value to 1973 67 Choose Delete a Field from the Edit menu INTREPID displays the Select Field to Delete dialog box Select click mag_adj1 and choose OK INTREPID displays a confirm dialog box Choose Yes INTREPID will delete the field Choose Quit from the File menu to exit from the Spreadsheet Editor 2012 Intrepid Geophysics 4 Back gt INTREPID User Manual Editing with the Spreadsheet Editor G11 11 Library Help Top 4 Back gt Key points for this guided tour In this guided tour of the Spreadsheet Editor you have e Directly edited data by erasing and retyping individual values e Searched for data according to a mathematical formula e Created a new field in a vector dataset e Used an If Then Else search and replace operation to assign values in a dataset using a mathematical formula Note that the Spreadsheet Editor e Has a wide range of arithmetic statistical and geophysical functions in a flexible formula format Supports ALL INTREPID data formats vector line point polygon grid voxet SEGY e Supports geophysical fields using appropriate algebra and graphical representations e Converts to from scalar components to tensor vector quaternion etc Supports user written macro code Frequently Asked Questions Q You say a wide range of operators is supported What are they A The INTREPID Acalc class is available to a number
17. s 4 Profile Editor Flight Path Editor FA chi4_5 job i Clip Line Tool F ch14_6 job M help iq decor_grid ers 4 d images FE des1 ers d kernel if dircos_grid ers M lib FE dw_grid ers db lut EF ebagoola_ A DIR 4 lynxdata EF ebagoola B DIR manuals EF ebagoola_F DIR H nut EF ebagoola_5 DIR a proj Bi ebagoola_ST DIR i L eamnle data EFF euler s DIR la Intrepid Spr Spreadsheet Editor pem Edit Cell lt lt Prev Group Next Group gt gt 1 2 3 4 5 6 z 8 9 10 11 12 13 14 15 16 394222 2 1973 55 y 17 394224 2 1973 48 18 394226 2 1973 52 19 394228 2 1973 58 z 20 394230 2 1973 52 Cfintrenid 4 Sisamnle data ouided tours intrenid datasets ehanonola ST DIR rt File Edit Format Macros Help Directly editing a value Directlyeditan 2 Change the value of mlevel_mag in the first row to 1978 71 individual value Library Help Top Click the value of mlevel_mag in the first row INTREPID displays the value in the Edit Cell text box Click immediately to the right of the number in the Edit Cell text box ood Intrepid Spreadsheet Editor E t S File Edit Format Macros Help Edit Cell 1973 67 lt lt Prev Group Next Group fid line linetype mlevel_ma 394192 2731 2 1973 67 2 394194 2 1973 77 Press BACKSPACE twice or more to erase the 67 Type 71 2012 Intrepid Geophysics 4 Back gt INTREPID User Manual Ed
Download Pdf Manuals
Related Search