PDF manual - Ocean Drilling Program
Contents
1. visual Basic Editor Alt F11 10 You are now at the Macro window Press Run 11 Your data is now in a format comparable to the Sliders program Save this Importing If you make changes to data while in Excel or another program the changes should also be saved to the central database Do this by importing your altered data back into the Sliders program 1 2 3 4 5 Save your data in Excel as a csv file Comma Delimited File Close your file in Excel Sliders will not import while your Excel file is open Open Sliders It will open to the Smear Slides window From the Slides menu select import The Import from window will open see Figure 13 Select the file you want to import and click OK Ocean Drilling Program Sliders User s Manual 15 Import From x File name Folders MYDATA 1 csv c odp sliders MYDATA CSV MYDATA 1 CSV Network e gt SLIDERS Nei List files of type Drives Comma Delimited File zl c Figure 13 Import to Sliders from this window 6 If the program detects no problems with the imported data the Smear Slides spreadsheet opens with the changes underlined in red Save this to the central database 7 If the Sliders program does detect a discrepancy one of two screens or both will be displayed The Find Sample window This window appears only if a more than one match or b no m2. Beach use will most often be in the repositories Document Layout The Sliders document is broken into three main sections The first section Sliders Basics describes starting the program and each of the main windows The second section Sliders Examples goes through an example of smear slide analysis from beginning to end The third section Sliders In Depth gives a detailed description of several of the additional Sliders functions Ocean Drilling Program Sliders User s Manual Sliders Basics Getting Started 1 Click on the Sliders icon to start the program 2 A Login window appears asking for a User Name Password and Host String Enter these fields the very first time the program is started Note Sliders automatically remembers the User Name and Host String after the first time the program is opened 3 Check the Remember Password box if you want the program to default to your pass word each time then click OK The Smear Slides Window The Smear Slides window automatically opens when Sliders is started See Figure 1 Smear Slides Slides Lists Reports Options Help Comments Lithology Depth Text Comps Top mbsf Total Total Sct cm Leg Site H Core Figure 1 The Smear Slides window Smear slide sample information leg site H core sct top and depth is imported to 1 Ocean Drilling Program Sliders Us
3. SLIDERS USER S MANUAL Updated 9 99 Table of Contents Intr ducli n st eee Cox Y ERO HREX RR E XENEIEURE SES REX d REN 1 Document Layout 022 2229 Roa 1 wA RAO QS REdO ss A Us rd E OE 1 Sliders BASICS a meer ate e CERRAR UE S EON d ne CEN E bo NA 2 Getting Started 5 12 1 pec ik eeiu PUAN ne Ka E SE A RA FREUEN 2 The Smear Slides Window S sucera e Ree rr Rh5c eee E eee EN ES 2 The smear Slides Foolbart 2155 sue can e ka AE TA G 3 Toolbar BUttonS ei e r a a sse REE O gel ates 3 Men OPi Ons x 064 Rer a ls ees x Ei el aed EE es X INA BE gs 3 The Select Slides Window 2i hr RR p Re REDE TA eas 5 The Component Select Window 0c eee eee eee ee eens 6 Sliders Examples oe rto ON aoo cox ROR Ue BAe tea e ue NOE 8 Where tu Statt au coq oce ord e Poe Oa aye COE eie d arae uai ID gd 8 Data can be entered in several different ways 0 c eee eae 11 Notice the changes that have occurred lslsleleeleleeeeees 11 Several important features of this screen 0 0 e eee eee eee 11 Sliders In Deptli o i enmbetC ve E xx E whee eee E E ECKE RR eee 12 EXPOTINS carii peA ex Coe 2 de etc s e Unt us 12 THipOPUlig 22 cose et cee esae SI p nur EX ER Dra FOU ae ace nte cibi 14 Editing Components vox tee oie dace oo eb AE os ew hee O 16 Adding a New Component 2442 20 oo eau eO AE A Tu ns 16 Editing a Component 2l d E EREG e REGGiGqd bees E sRER 16 SelM Sp REPOS oed coe s FC OY So
4. appear in the Slides box Note Top distance and Depth are added automatically 3 To add a new slide that s not currently displayed enter the top distance of the smear slide and click on the Add New Slide button 4 Select a slide for analysis by highlighting it then clicking on Add Select all slides dis Ocean Drilling Program Sliders User s Manual 6 played by clicking on Add All 5 All slides chosen for analysis are displayed in the Selected Slides spreadsheet 6 Remove a selected slide at any time by highlighting it and clicking Remove for one slide or Remove All to de select all slides displayed 7 Clicking OK then exports all selected samples to the main spreadsheet 8 Click on Cancel to close the window without saving any of the selections The Component Select Window Select components for the Smear Slides spreadsheet from this window Open it by clicking on the Components button the F8 key or by selecting it from the Lists menu Mineral Alkali Amphibole Mineral Amphibole Biogenic Calcispheres Rock Basalt Fragments Accessory Minerals RE Aegerine Albite Alkali Amphibole Alkali Feldspar Amorphous Oxide Amphibole Rock Calcareous Fragments Analcime Anatase Andesine Anhydrite Ankerite Apatite Aragonite 1 Select the material type by clicking on the top left down arrow to display the drop down list of choices Mineral Rock Biogenic and Other Click on you
5. atch is found for the imported slide 1 The top line displays the Sample from Imported File 2 The bottom line displays the Matches Found in Database 3 If no match is found and you want to add this slide to the database click Add New then OK If you want to search for it again press Find Again 4 If more than one match is found highlight one of the Matches Found in Database and click OK If you decide the slide is not the correct match when the spreadsheet appears select import again and highlight the correct choice The Find Component Type window 1 The top line displays the Component or Type imported from Excel 2 If you added a component or type that is foreign or misspelled the program will find and display the closest match bottom of window 3 Click either Find Again or OK 4 Now the spreadsheet opens with the added changes underlined in red Press Save to save these changes to the database Ocean Drilling Program Sliders User s Manual 16 Editing Components It is possible that you ll want to add change or delete components in the database Just remember that any changes made here are also made in the Component Select win dow the master list used to select components for the Smear Slides spreadsheet 1 From the Slides menu select Edit Components to open the Component List win dow 2 From the top list select a component type mineral rock biogenic or other
6. ch takes you to the Select Slides window Highlight the slides in the Selected Slides box that you want to remove and click on the Remove button Click OK and the spreadsheet will reappear The removed slides are no longer on the screen but are still in the database A value must be entered for lithology or the program will not save Ocean Drilling Program Sliders User s Manual Sliders In Depth This section describes additional Sliders features Exporting 12 Once you enter smear slide data into the database you can also export it to another program such as Excel for your own spreadsheet This is done from the Smear Slides spreadsheet 1 From the Slides menu select Export This opens the Export to window See Fig ure 11 2 Enter a file name The file should be saved as a Comma Delimited File so after the name type csv In Figure 11 the filename is mydata csv Under Save file as type select Comma Delimite File csv 3 Select a Folder to save the data to Usually C ODP Sliders and click OK Export To File name Folders mydata csv c odp E c e gt ODP Sliders Save file as type Comma Delimited File Drives m c HE OK Cancel Network dii u Figure 11 Enter file name of data to be exported here 4 Open Excel 5 From the File menu select Open The Open window appears Under F
7. e Component Select Window p 6 3 Under Reports Slides opens a report form e g Smear Slides Form For more information see Predefined Queries in Janusweb Also More in Setting up Reports p 17 Ocean Drilling Program Sliders User s Manual 4 Components this selection not developed yet 4 Under Options Setup Report opens a Setup Reports screen More in Setting up Reports p 17 Change Header Font this selection reduces or increases the spreadsheet font size 5 Under Help Index this option not developed yet e About Sliders details the Sliders copyright information Ocean Drilling Program Sliders User s Manual 5 The Select Slides Window Select all smear slides for analysis at this window Open this window by clicking on the Slides button the F7 key or by selecting it from the Lists menu Select Slides Hole Core Sectior Selected Sldes Site H Cor CT Sct Top Dspth H 2 rire wea 3H 58 Cancel Figure 2 The Select Slides window 1 Select aleg hole core and section from top left columns Use the scroll bars to view all possible selections The Site selections displayed correspond to the Leg selected as the Hole selections displayed then corresond to the Site selected etc Note Hole Core and Section default to all when no selec tion is made 2 Slides corresponding to the selected information
8. e 5 Notice that Top distance and Depths have been added Figure 5 Selected slide information 4 Addaslide that is not displayed by entering its top distance and pressing the Add New Slide button See Figure 6 To I Add New Slide Figure 6 Add a new slide here 5 Highlight the slides you want to analyze and press the Add button Ocean Drilling Program Sliders User s Manual 6 Observe that the slides you selected are now under the Selected Slides box see Fig ure 7 Selected Slides Leg Sie H Cor CT Sct Top Dept we wem 3m v wo zn sp 7 9p re Se ee Figure 7 Slides selected for data analysis 7 Press OK and this information will export to the sample side of the Smear Slides spreadsheet In Figure 8 notice that the two lines of data from Figure 7 are now in the sample section Note The spreadsheet automatically opens The slides are now ready for analysis Sample Top Depth Leg Site H Core Sct em mbsf 172 1064 A EINE y 11 0 EIS 172 1064 A ELI 7 16 0 27 96 Text Total Comps Total Figure 8 Samples ready for analysis 8 Press the Components button to open the Components Select window Select the component you want by highlighting first and then pressing Add e Press OK once you ve selected all the components you want See Figure 9 Ocean Drilling Program Sliders User s Manual Accessor
9. er s Manual 3 this window from the Select Slides window More in The Select Slides Win dow p 5 2 Components are imported to this window from the Component Select window More in The Component Select Window p 6 3 All smear slide component data and comments are entered on this window The Smear Slides Toolbar Toolbar buttons Click New or F5 for a new Smear Slides spreadsheet Click Save or F6 to save information to the database Click Slides or F7 to open the Select Slides window Click Components or F8 to open the Component Select window Menu Options Under Slides New Spreadsheet opens a clear spreadsheet Save Data saves data to the central database Export opens a window for exporting data to Excel as a Comma Delimited File More in Exporting Section 3 Import opens a window for importing Comma Delimited files from Excel into the Sliders program more in Importing Section 3 Edit Components opens the Component List window Add delete or edit slide components from this window More in Editing Components p 16 Exit closes the Sliders program 2 Under Lists Select Slides opens the Select Slides window Same function as the Slides but ton or F7 key More in The Select Slides Window p 5 Select Components opens the Component Select window Same function as the Components button or F8 key More in Th
10. iles of type select Text Files Under Look in select the folder you saved the data to In Figure 12 it is under C ODP Sliders Highlight the file and click Open This opens an Excel spreadsheet with your data Ocean Drilling Program Sliders User s Manual 13 Open kak Look in E Sliders pen Cancel Advanced Find Files that match these search criteria File name Text or property Find Now Files of type rex Files Last modified any time New Search 1 File s Found Figure 12 Open your Excel spreadsheet from this window 6 To reformat your data to look similar to the Sliders spreadsheet From the File menu select Open again Under Files of type select Microsoft Excel Files The Sliders icon appears in the window Click Open 7 A window about Macros will appear Click Enable Macros 8 From the Window menu click on the bottom choice which is the name of your file Data Window Help amp od Mew Window Arrange Ponta Hide ile BS Split m Ereeze Panes 1 Sliders v 2Mydata Ocean Drilling Program Sliders User s Manual 14 9 From the Tools menu select Macro then Macros Tools Data Window Help Ve 7 Mw rs HE SEEN B 8 S8 dE Share Workbook Track Changes gt Protection Goal Seek Scenarios Auditing gt Solver Macro Add Ins Record New Macro Customize
11. ist button top right A list of choices appears for the highlighted cell Click on one of the choices Notice the changes that have occurred 1 The newly added data is underlined in red This indicates that the added data is not saved to the database Press Save to save new data to the database The values under Text Total and Comps Total have changed The program keeps track of the values entered for each component or texture When the total reaches 100 100 the number turns from red to black Several important features of this screen 1 Pressing the Exit button completely closes the program Any data underlined in red will not be saved when program exits Be sure to press Save before exiting Pressing the New button opens a new screen Any data underlined in red will be deleted by pressing New Always click Save before selecting a new screen Removing a component from the spreadsheet will remove it from all the sample slides shown For example your first two slides might contain component A The next four do not After entering the data for component A in the first two slides you decide to delete A since you don t need it anymore This will actually remove A and the data entered from the first two slides To remove slides from the Smear Slides window you must delete them from the Select Slides window First Save all data to the database e Next click the Slides button whi
12. r Slides Report and Components Report should also already be set 4 Click OK This should start Netscape and open to the selected report form Ocean Drilling Program
13. r selection Figure 3 The Component Select window 2 Next select the components Once a material type is selected corresponding compo nents are listed beneath the type Highlight your choice and click on the Add button Ocean Drilling Program Sliders User s Manual 7 Note Continue doing this until you have selected all the components you need for your spreadsheet View your component selections in the right side box 4 Remove a selected component at any time by highlighting it and clicking on the Remove button 5 Export the components to the spreadsheet by clicking on the OK button The selected components will become columns on the spreadsheet 6 Click Cancel to close the window without saving any of the selections Ocean Drilling Program Sliders User s Manual 8 Sliders Examples This section takes you through an entry and analysis example from beginning to end Where to Start The Smear Slides window automatically opens when Sliders is started 1 Press the Slides button or the F7 key to open the Select Slides screen 2 Select the leg site hole core and section information for the slides you want to ana lyze Figure 4 shows that leg 172 site 1064 hole A core 3H section 7 have been selected Hole Core Section Figure 4 Select sample information from this window 3 Slides corresponding to the selected information should now be listed in the Slides box See Figur
14. s Y WS KO d ERI ee ER RH ER 17 Table of Figures Figure 1 The Smear Slides window 2 2622 99 es PLE VEU EES 2 Figure 2 The Select Slides window 2 ERES 5 Figure 3 The Component Select window 0 0 0 eee eee eee 6 Figure 4 Select sample information from this window 8 Figure 5 Selected slide information 2 cdsrie Abe Eee eee eres y ah ees 8 Figure 6 Add a new slide here 252 Lea oe ee la hel a 8 Figure 7 Slides selected for data analysis 0 0 0 eee eee eee eee 9 Figure 8 Samples ready for analysis 0 0 0 0 eee eee 9 Figure 9 Selected components for the spreadsheet 04 10 Figure 10 Spreadsheet with selected slides components and data 10 Figure 11 Enter file name of data to be exported here 12 Figure 12 Open your Excel spreadsheet from this window 13 Figure 13 Import to Sliders from this window sleleesee sees 15 Figure 14 List of component types 2 veszeettviEem ry v XR CER t 16 Figure 15 Edit or add a component here 0 0 0 eee eee ee eee 16 Sliders User s Manual 1 Introduction Sliders is a program designed to aid in the recording of smear slide data The data entered for each slide is saved to the central database The main working window is a spreadsheet similar in look and function to Excel Shipboard use will generally be in the hard rock caf
15. see Figure 14 A list of corresponding components appears under it M Mineral us B Biogenic O Other Figure 14 List of component types Adding a New Component 1 Add a new component by clicking Add The Component Info window appears See Figure 15 Type in the Component name and press OK Be sure to capitalize the first letter of the name Component Info Component Name Figure 15 Edit or add a component here Editing a Component 1 Edit a component by highlighting it and clicking on Edit The Component Info window appears See Figure 15 Type the changes and click OK Be sure to capitalize the first letter of the name 2 Delete a component by highlighting it and pressing Delete Just remember that this deletes the component from the master list 3 From the Smear Slides window press the Components button Observe the changes you ve made in the Component Select window Ocean Drilling Program Sliders User s Manual 17 Setting up Reports ODP data query report forms can be accessed from the Smear Slides window 1 From the Options menu select Setup Reports to open the Setup Reports window 2 The Path for Web Browser URL should already be set to open directly to the ODP data request query forms If the URL does not work click on the List button for a list of options If you do not know the correct browser ask an MCS 3 The URL fo
16. y Minerals Mineral Mineral Biogenic Rock Rock Aegerine Albite Alkali Amphibole Alkali Feldspar Amorphous Oxide Amphibole Analcime Anatase Andesine Anhydrite Ankerite Apatite Aragonite 10 Component Select Alkali Amphibole Amphibole Calcispheres Basalt Fragments Calcareous Fragments Figure 9 Selected components for the spreadsheet 9 The spreadsheet reappears with the newly added components See Figure 10 Slides Lists Reports Options Help S ample Text Total Depth mbsf 27 81 27 96 Comps Top Total cm 11 0 16 0 Leg Site H Core Sct ez wn ss ess e dn M TEZ UGS A 35 E ST 80 80 100 100 Testre_ Mineraboofek Pa 2 D E ch 2 L e 2 D m 9 7 e Alkali Amphibole Amphibole Basalt Fragments Calcispheres Figure 10 Spreadsheet with selected slides components and data Ocean Drilling Program Sliders User s Manual 11 Data can be entered in several different ways l Click on a cell to highlight it or use the arrow keys to move around 2 Type in a value Notice it appears in the cell and the entry prompt Click Enter or the check mark to enter a value Click Delete or X to delete an entered value OR 3 Highlight the cell and click the right mouse button A list of selections is opened for the highlighted cell Click on one of the choices OR 4 Highlight a cell and click on the L
Download Pdf Manuals
Related Search