Introduction to the Spreadsheet Editor (G04)
Contents
1. m oS File Edit Format Macros Help Edit cell 2 lt lt Prev Group Next Group gt gt line iE ype rawmag diurnal 1 14020 2 59291 13 59002 76 2 59291 15 59002 76 Group line navigation buttons 59291 18 59002 78 59291 21 59002 77 59291 23 59002 77 59291 25 59002 77 59291 28 59002 78 59291 30 59002 78 9 59291 31 59002 78 Vertical scroll bar for navigating 10 cael ae rows data points fu 59291 33 59002 79 12 59291 34 59002 79 13 59291 35 59002 79 14 59291 38 59002 79 15 59291 38 59002 80 16 59291 38 59002 80 17 59291 40 59002 80 Horizontal scroll bar for 18 59291 42 59002 80 19 59291 44 59002 81 navigating columns fields 20 59291 48 59002 81 on n a Grou Tot 77 sample_data quided_tours intrepid_datasets albury DIR Group 1 of 77 2543 rows on this grou 3 Use the Navigate function to navigate to a different group Use the scroll bars and group navigation buttons to return to the top left of group 1 as shown when you first launched the tool From the Edit menu choose Navigate INTREPID displays the Navigate dialog box Enter 29 into the Group text box and 20 into the Row text box PJ Intrepid Spreadsheet Editor pese i a File Format Macros Help Edit Create New Field Navigate Insert Row After Current Row Split Group At Current Row Join Group To Previous Group Sort Groups Delete Field Delete Current Row Column Delete Current2. The spreadsheet uses Fields this field to divide the Columns of Spreadseet data into groups lines Each column of numbers represents one field You can also display and edit grid datasets using the Spreadsheet Editor Each group of the spreadsheet represents a horizontal line of grid points The number of rows in each group is equal to the number of grid cells per line Library Help Top 2012 Intrepid Geophysics 4 Back gt INTREPID User Manual Library Help Top Steps to follow Examine a line dataset 1 Library Help Top Introduction to the Spreadsheet Editor G04 4 Load a dataset into the spreadsheet editor Start the Project Manager Navigate to the directory install _path sample_data guided_tours intrepid datasets From the Editing menu launch the Spreadsheet Editor Project Manager File Dataset ashi Display Levelling Gridding Filtering Mapping Gravity Radiometrics Interpretation Utilities Betas Help Current Folder Profile Editor a6 gt ci cra oa ES ED cag Ci Flight Path Editor Clip Line Tool cll4 c118 c129 c136 cl41 c154 c156 c158 49 algorithm 46 bin H classes config cookbook dongle examples 4 filters 4 0 font 4 form help images 5 kernel 44465 lib lut lynxdata 4 0 nlut 8 proj temp 3 tutorials 2 Refresh lt H O Geosoft_c OE c999 gt Intrepid_datasets File name
3. EF albury DIR a alburydata dat E alburydata ddf E alburydata des E alburydata dfn FE anomL_grid ers E cho6_1 job E cho7_1 job E cho9_1 job E7 cho9_z job E ch10_1 job E chi 1_2 job E7 ch13_1 job E ch13_z job File type Intrepid dataset File Data Description File File Intrepid grid File Intrepid job file Intrepid job file Intrepid job file Intrepid job file Intrepid job file Intrepid job file Intrepid job file Intrepid job file Intrepid job file Intrepid job file Eek v lt 4 Back gt See Locating datasets viewing statistics launching tools G02 for instructions about navigating to different directories and selecting datasets Choose File gt Open Dataset The INTREPID Load Dataset dialog box appears Select the line dataset albury DIR and choose Open INTREPID launches the Spreadsheet Editor and displays the albury dataset in the Spreadsheet window f Intrepid Spreadsheet Editor _ So Line number File Edit Format Macros Help group by fi el d Edit Cell 2 lt lt Prev Group Next Group gt gt Tine lt linpp awm diura Ss Se 2 r T 59002 76 3 59291 18 700226 4 59291 21 7002 I5 59291 23 59002 77 Data fields 6 59291 25 59002 77 7 59291 28 59002 78 8 59291 30 59002 78 9 59291 31 59002 78 10 59291 32 59002 78 11 59291 33 59002 79 12 59291 34 59002 79 13 59291 35 59002 79 14 59291 38
4. 300279 15 59291 38 Ar 16 59291 38 59002 80 A Data points 17 59291 40 59002 80 18 59291 42 59002 80 I 19 59291 44 59002 81 20 59291 48 3002 61 C Intre pid V 4 5 s ample_data quided_tours intrepid_datasets albury DIR Group 1 of 77 2543 rows on this group Tip Each row in the Spreadsheet window represents a data point Each column in the Spreadsheet window represents a field The Editor displays line data from 2012 Intrepid Geophysics 4 Back gt INTREPID User Manual Introduction to the Spreadsheet Editor G04 5 Library Help Top 4 Back gt one group at atime Each group represents one survey line of data The line number field is the group by field that identifies each line 2 Use the scroll bars to view different rows and columns in the current group Use the vertical scroll bar to view different data points You can choose the down or up arrow to advance one or two data points through the group You can also drag and release the scroll box to advance many data points or all the way to the end of the current group Use the horizontal scroll bar to view different data points You can choose the right or left arrow to advance one or two columns through the group You can also drag and release the scroll box to advance many columns Now use the lt lt Prev Group and Next Group gt gt buttons to view different groups lines in the dataset i 7 Intrepid Spreadsheet Editor peo u
5. Group Apply Conditional Delete Replace Navigate Find E b _ eet woe Update Immediately Library Help Top 2012 Intrepid Geophysics 4 Back gt INTREPID User Manual Introduction to the Spreadsheet Editor G04 6 Library Help Top 4 Back gt Choose Apply INTREPID displays the 29th group beginning at row 20 a Intrepid Spreadsheet Editor femme en le File Edit Format Macros Help Edit Cell 2 lt lt Prev Group Next Group gt gt line linetype rawmag diurnal 59338 03 59003 03 59337 99 59003 03 59337 94 59003 03 l 59337 92 59003 03 59337 89 59003 03 59337 85 59003 03 59337 81 59003 03 59337 79 59003 03 59337 74 59003 03 3 59337 70 59003 03 Navigate 59337 66 59003 03 Group 29_ 59337 62 59003 03 59337 58 59003 03 jdi po 59337 55 59003 03 Column 59337 52 59003 03 Apply Close 59337 48 59003 03 i 59337 44 59003 03 I 59337 39 59003 03 59337 35 59003 03 C Intre pid 4 5 s ample_data guided_tours intrepid_datasets albury DIR l Group 29 of 77 2307 rows on this group Note the line number You are viewing the data from line 140481 Close the Navigate dialog box Observe how the Spreadsheet Editor reports the dataset name the current group and the number of rows in the current group at the bottom of the tool Note You can leave the Navigate dialog box open on the screen and use it as required 4
6. Next Group gt gt line Xgda94mga55 Yqgda34mga55 rawmag linetype mi 1 485347 24 5999360 040074 59291 13 2 2 485342 95 5999359 927777 59291 15 3 485338 23 5999359 976059 59291 18 4 485334 21 5999360 111033 59291 21 I 5 485331 03 5999359 924847 59291 23 6 485328 11 5999359 985933 59291 25 7 485325 20 5999360 047018 59291 28 8 485322 02 5999359 860832 59291 30 485320 00 485317 09 485314 18 485311 00 485308 08 485305 23 485300 94 485298 03 485294 21 485291 30 485287 00 485283 19 C Intre pid V4 5 s ample_data guided_tours intrepid_datasets albury DIR 5999359 928319 5999359 989405 5999360 050490 5999359 864304 5999359925389 5999361 121186 5999361008888 5999361 069974 5999361 124658 5999361 185743 5999361 073446 5999361 128129 59291 31 59291 32 59291 33 59291 34 59291 35 59291 38 59291 38 59291 38 59291 40 59291 42 59291 44 59291 48 Library Help Top 2012 Intrepid Geophysics 4 Back gt INTREPID User Manual Introduction to the Spreadsheet Editor G04 2 Library Help Top Overview Library Help Top lt 4 Back gt The INTREPID Spreadsheet Editor is a tool for viewing and editing your data numerically It enables you to e View and edit ALL types of INTREPID datasets in a spreadsheet layout e Navigate examine and manipulate the dataset structure e Search and replace data using conditional logic e View gradient and tensor data using special icons that help
7. Use the Reorder Fields function to change the display order of the fields columns From the Format menu choose Reorder Fields INTREPID displays the Column Display Order dialog box From the Current Order list select line and move it gt gt to the New Order list Then select and move the fid then flight and time fields Pl Intrepid Spreadsheet Editor File Edit Format Macros Help _ FditCell Reorder Fields Format Field Detail Cell Report Column Display Order Column Display Order Column Display Order Column Display Order New Order Current Order Cancel Choose OK INTREPID displays the new column order in the Spreadsheet Editor 5 Exit from the tool Library Help Top 2012 Intrepid Geophysics q Back gt INTREPID User Manual Library Help Top Introduction to the Spreadsheet Editor G04 7 4 Back gt To exit from the Spreadsheet Editor choose Quit from the File menu Manipulate a line dataset Library Help Top You will now use the Spreadsheet Editor to create a new data field using a combination of the existing fields The new data field appears as a new column in the Editor In this exercise you use the Editor to perform a routine diurnal correction on magnetic survey data Using the albury dataset you subtract the base station data from the raw magnetic data to create a diurnally corrected magnetic channel You also add the mean diurnal value to the ne
8. disappears and INTREPID calculates the new data field Now you can view the new field as a column in the Editor From the Format menu choose Reorder Fields Select the rawmag diurnal and magd fields in turn and move them to the New Order list Choose OK The Editor re orders those data fields to the left of the display screen where you can see them Exit from the tool To exit from the Spreadsheet Editor choose Quit from the File menu Library Help Top 2012 Intrepid Geophysics 4 Back gt INTREPID User Manual Introduction to the Spreadsheet Editor G04 10 Library Help Top 4 Back gt Further things to consider Using the Project Manager examine the histogram and statistics for the magd field Compare the range of the data Max Min with that of the rawmag field Are they similar or different If there was noise or spikes in the diurnal data what effect would you expect the diurnal subtraction to have on the aircraft data If the base station was located in a magnetically noisy area it may be necessary to do some pre processing of the diurnal data before applying the correction This might involve editing spikes out of the data or filtering it before applying the spreadsheet operation For further editing operations see Editing with the Spreadsheet Editor G11 For full details about the Spreadsheet Editor see Spreadsheet Editor T15 Key points for this guided tour In this guided tour you used
9. julian line H linetype radalt H rawmag i time Xqda94mga55 Lu Yodad4mnass E lt 2 Auto load a dataset into the spreadsheet editor With the albury DIR dataset still highlighted in the Project Manager launch the Spreadsheet Editor INTREPID launches the Spreadsheet Editor and displays the albury dataset in the Spreadsheet window This feature of 2012 Intrepid Geophysics 4 Back gt INTREPID User Manual Introduction to the Spreadsheet Editor G04 8 Library Help Top 4 Back gt INTREPID is called auto loading a dataset Note Auto loading is not enabled for all INTREPID tools Library Help Top 2012 Intrepid Geophysics 4 Back gt INTREPID User Manual Library Help Top 3 4 Introduction to the Spreadsheet Editor G04 9 4 Back gt Use the Replace function to create a new field in the dataset In the Spreadsheet Editor from the Edit menu choose Replace The INTREPID Replace dialog box appears The arithmetical expression we use contains no conditional statement Therefore leave the If text box blank In the text box to the right of Then type magd This becomes the name of our new data field In the textbox to the right of the sign type the following expression rawmag diurnal 59003 z Intrepid Spreadsheet Editor e Replace Formula Options Load Formula Save Formula Formula Definition If Relations
10. you to visualise the complex values in each reading e Perform grid level arithmetic on gridded datasets For example add a pair of grids e Create new fields and grids usingg functions This Guided Tour demonstrates the Spreadsheet Editor firstly as a tool for viewing dataset structure and secondly as a tool for manipulating your data 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 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 For more information about installing the sample data see Sample datasets installing locating naming in INTREPID Guided Tours Int
11. INTREPID User Manual Library Help Top Introduction to the Spreadsheet Editor G04 1 4 Back gt Introduction to the Spreadsheet Editor G04 Top When you are processing geophysical data you may want to view edit and manipulate the numbers that make up your data The INTREPID Spreadsheet Editor is a powerful tool which allows you to do all of this This Guided Tour shows you how the INTREPID Spreadsheet Editor interprets and manipulates the data contained in INTREPID datasets e You will examine the structure of a line dataset and learn to navigate around it e You will manipulate the data in an airborne magnetic Line dataset and create a new data field In this exercise you subtract base station data from raw magnetic data to create a diurnally corrected magnetic channel Context of this guided tour In the context of your data processing cycle the Spreadsheet Editor may be used at any stage to view and manipulate your data It is a both a window into your data and a versatile tool to make changes to that data When you want access to the numbers the Spreadsheet is for you We have extended this tool to support vectors and tensors using simple mimic garphs in each cell to give you a quick visual that with practise gives you a simple way to see how the signal is varing from sample to sample f Intrepid Spreadsheet Editor _ p e m oD arm File Edit Format Macros Help Edit as o lt lt Prev Group
12. Size File type F iszoosioszezem 08 inkeniddataset 08 12 2012 4 28 37 PM Intrepid dataset 12 02 2008 4 01 32 PM Generic Data file 12 02 2008 4 16 12 PM Data Description File 13 02 2008 1 10 50 PM File 12 02 2008 4 01 18 PM File 19 02 2008 12 27 38 PM Zip Archive 27 03 2003 1 38 52 PM Intrepid Grid File 26 07 2012 4 27 24 PM Intrepid job file 14 08 2008 11 23 42 AM Intrepid job file 27 03 2003 1 38 52 PM Intrepid job file 14 08 2008 11 23 42 AM 26 07 2012 4 27 24 PM 26 07 2012 4 27 24 PM 14 08 2008 11 23 42 AM 27 03 2003 1 38 52 PM 27 03 2003 1 38 52 PM 27 03 2003 1 38 52 PM File name 5 vas albury DIR EF albury 1 DIR alburydata dat 7 alburydata ddf _ alburydata des E alburydata dfn 4 dits p ced J alburydata zip p dongledriver H Ji filters d font M form Wy help id job fil i r ane Intrepid job file Intrepid job file Intrepid job file Intrepid job file Intrepid job file Intrepid job file Intrepid job file proj D sample_data 4 cookbooks Fields Statistics Histogram MetaData Thumbnail E J albury DIR J examples e date p guided_tours o ae geosoft_datasets me fid sD no fit d sdk H J temp m v edist Perflogs D Program Files Program Files x86 H J SWTOOLS Ti Values 191271 Statistics Samples Minimum 3 129 Maximum 19 554 Mean 13 522 _ StdDev 3 176 Nulis 103 gpsht i
13. agnetic or gravity field This can be confusing as we might talk about a gravity gradient tensor field also being part of the Spreadsheet visuals If data is collected at a series of random locations we refer to it as random or point data This is generally true of gravity and geochemistry surveys If data is collected along a series of lines we refer to it as line data This is true of airborne surveys where each line is assigned a unique line number The Spreadsheet Editor displays vector data in rows and columns Each vertical column of the spreadsheet represents a field in the dataset Each horizontal row of the spreadsheet represents a single data measurement An INTREPID Point dataset consists of a single group of data An INTREPID Line dataset consists of several groups where each group represents one survey line of data For a Line dataset the Spreadsheet Editor uses the line number field to group the data into lines It displays only one line at a time The line number field is a group by field and is the primary identifier for the dataset How the Spreadsheet Editor displays a line dataset J PET TTT itt Lines LEED A Groups in Spreadsheet _L EET ETT ETT oe Each group contains ER RRR eee the data for one line _ LN lalla A LTT TT sf E E E E Data points Samples Rows of Spreadsheet Each row of numbers represents one data point Line number field Group by field
14. hips gt lt amp amp l gt lt Then Else Assigment Any combination of field name function or constant Then Else Operators Then magd 2 rawmag diurnal 59003 Else a Between START and END OK Cancel 59003 is the mean value for the diurnal data field Does it agree with your value When you are done press OK on the Replace dialog box A Please Choose dialog box appears Create New Column Choose Yes The INTREPID Create New Field dialog box appears i Field Name magd Supported Data Types for Both Grid amp Databases Data Type Signed16Bitinteger C Signed32Bitinteger C IEEE4ByteReal IEEE8ByteReal C Logical C Character C Byte C Tensor Following not Supported for OASIS style C Vector C Gradients C Components C Complex C Observation Object C Quaternion C Date C Geological Structure Field measurement coordinate convention East North Down C ENU C NED C END Width Group By Initial Assiqment Any combination of field name function or constant l Load Formula Save Formula Initial Operators Initial Browse OK Cancel The Field Name is magd The Datatype is IEEE8byte real default The data field is not Group By so Group By stays unchecked default Choose OK in the Create New Field dialog box The dialog box
15. roduction 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 attributes of each of the cookbook datasets 2012 Intrepid Geophysics 4 Back gt INTREPID User Manual Introduction to the Spreadsheet Editor G04 3 Library Help Top 4 Back gt How the Spreadsheet represents INTREPID vector datasets see INTREPID dataset types in Locating datasets viewing statistics launching tools G02 for a brief introduction to the INTREPID database A spatial vector dataset consists of a set of data points Each data point may have several measurements or quantities associated with it e g X Y elevation temperature magnetometer reading We can refer to these quantities as fields or channels in the dataset Note The word field has many different meanings in physical sciences and mathematics A data field as used here simply refers to an attribute or quantity associated with a data point It has no significance in the wider sense of a m
16. the Spreadsheet Editor to Navigate and view INTREPID datasets Understand the structure of an INTREPID dataset Create a new data field in an INTREPID dataset Frequently Asked Questions Q Does the INTREPID database store all INTREPID data A Yes the binary database that underpins INTREPID stores vector line point polygon and grid datasets Q Are there size limits in the database A INTREPID itself imposes no size limits Size limits are imposed by the Operating System and the computer hardware Q Can I save my arithmetic formula and reload it at a later session A Yes the Spreadsheet Editor Replace dialog box has Load Formula and Save Formula buttons which allow you to do this Q I created a field I don t want can I delete it A Yes the Spreadsheet Editor lets you delete fields under Edit Delete Field Q How can I find out more about what arithmetic expressions are supported A The Spreadsheet Editor has its own Help facility The INTREPID documentation contains a comprehensive summary of the Spreadsheet functions Library Help Top 2012 Intrepid Geophysics 4 Back gt
17. w field Quick Review The Earth s magnetic field varies with time One of these time variations which affects airborne magnetic surveys is called the Diurnal During the airborne magnetic survey the diurnal variation 1s monitored by a base station at some fixed ground location By subtracting the diurnal from the aircraft data we get a residual magnetic signal which has no time dependence It 1s also common practice to add the mean magnetic field value to the diurnally corrected survey data to compensate for the arbitrary level shift introduced by the diurnal subtraction 1 Calculate a Mean value for the diurnal field Start the Project Manager Navigate to the directory install_path sample_data guided_tours intrepid_ datasets In the File name panel of the Project Manager select the dataset albury DIR The dataset details appear in the lower panel After the thumbnail colour image has finished drawing select the Statistics tab The list of all data fields appear under the albury dataset Select the diurnal field If a histogram is displayed select the Statistics tab Make a note of the Mean value for the diurnal field 59008 nT YE Project Manager albury DIR mmm a a 2 ym File Dataset Editing Display Levelling Gridding Filtering Mapping Gravity Radiometrics Interpretation Utilities Betas Help urrent Folder C Intrepid V4 5 sample_data guided_tours jntrepid_datasets GeoModeller a Last Modified
Download Pdf Manuals
Related Search