Home

Users Manual

Contents

1. a A ee Bo ea As you can see the Audit Log records the date and time of the event the user w ho w as logged in to DataSight at the time the Computer the user w as using and the type of activity that user completed When you click the Details button you can get details of the activity EE Audit Loa Details Import Import Dated Time Source File 18 06 2009 1 43 12 PM Source Fiet WisersalankiDocumentsiSevenoV umana Trainings als Humber of ines m source fle 3721 Import starts from 2 Import finishes at 5720 B Levels B Level 1 Project L M Level Weather Stations L vel 3 Camp AWS Variables Date Fields gt Date Time Fields Time Ory Temp Hr Av C Fields Dry Temp Hr Avg MC Evap Hr Total mm Fiald6 gt Evap Hr Total mm Hume dity Hr Av 98 Field gt Humidity 054 Press Hr Av mbar Fieldg Pressore Mr Av mbar Rainfall Hr Toca me Fields gt Painfall Hr Total mm Solar Rad Hr Ay RV Sou FieldTO gt Solar Aled Hr Av KHW Vap Press Hr v kPa Fieldt1 gt Vap Fress Hr Av KP Wind Dir Hr Av 7 Field T2 gt Wind Dir Hr Av 7 Wind Vel Hr Ay m s Fieldt3 gt Wind Vel Hr Av m s Standards Check Information in the Audit Log Details screen is in RTF format
2. Eip vastes DateTime AuSeres O Single Series S Humoy v C Choose records where a ofthe folowing apply E CO vinos ia esa f Click hene to add new condition gt Ajustes Level m Ar temp Deg C Comments DO mom Evap imm Humidity 9 i r Pets L gw ee Se poA be Connected to C Demonstration Database i 5 DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Quick Tour Use DataSight s filter function to construct data queries See the results in tabular form or plot as a graph t DataSight Fie Edi 11012003 201 2003 101 2003 40152007 50142003 2101 2093 E la del la La Jo VC SavedViews 2 Seared Vies 4 fi Graphs e F9 Damsress E Reports mm am ce lip varaties O DateTime v Time E C ASS Level im v Ak temp Deg C O Comments O Do dem O Evy imm Hory dg i ah DataSight Users Manual Version 2 9 4 Humidity 96 d a Al Senes _ Choose recorda where Automabc Vieather Station 1 EA 2 Level aeni Region I E t Ej fis Tabular Reports E MDE amp yutcmatic Vieaiher Sater Date statan P Automabe Vieather Staten 1 am 2003 4 1 2003 491 2003 4it 2003 AD 4 2003 4701 2003 Automabe eather Station 1 amp a Automate Weather Station 1 amp utomabc Vieather Station 1 Automate Vieather Station 1 Autom
3. 110 mi rhieerir cwetivertiticiocceneretentinasccecea ee 111 A PH 113 Savingia Data Meet ini R E Aa a aa KO ABS MAKAK Aaa 113 Graphs 115 Create VIEW CI I 115 A O a aNs 115 Renaming and deleting Graph Series concococcccoccococoncoconcoroncarannarnrnararnncarnnnarannararnanannas 116 Saving a Gla Pi a ttt eto ETE 116 COPYING Gra PhS icis nwwnn 117 Setting and Changing Graph Properties oococcccocconocoococoncoroncaranonrarnnrarnnnarnnnarnnarannans 117 Using Advanced OPHONS mtr a a Aaa 119 Advanced Graph i am m 121 Graphing Multiple Variables iia nnmnnn nnmnnn KiRo nnmnnn nnne 121 WING ROSS RO EE LT iaaa aa ana a ARA AKA OKA at aaa a AAA AAAA K Ka Aa aea 132 GIS and DataSight 138 Reports 140 Tabular ReporiS sessir D T e kodu Itm 140 Example Report Wind ROS Sui aa aS EEEa A E ad k SAHARE EEA St dak 144 Repon mem E 147 Scheduler 153 Scheduling TASKS cet e a iaa 154 Conversion Tool 157 Conversion Tool Introduction coincidan 157 DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Contents 2 Converson Tool QVerViQW x neurons Rak aaa ua IS A n E KEEN RATEN A ERA EE UR IER ASR AN AN ae d MSN 162 3 Using the Conversion TOOL ec nio 169 Completing a Conversion Vises ara street ds 172 Completing a ConversiOn 2 oar aa iaaa caca ana iii 176 Comple inga Conversion 3 cae ec o redo a so secco Raiden ced A MESS Uic sd 178 Com
4. 245 4 EX DOPING ISSUES iia 246 5 Merge ISSUES SNS een 247 25 Glossary of Terms 248 Index 250 DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Copyright Notice 1 Copyright Notice Copyright Notice Copyright O 2013 Seveno Pty Ltd All rights reserved The softw are contains proprietary information of Seveno Pty Ltd it is provided under a license agreement containing restrictions on use and disclosure and is also protected by copyright law Reverse engineering of the softw are is prohibited Due to continued product development this information may change w ithout notice The information and intellectual property contained herein is confidential betw een Seveno Pty Ltd and the client and remains the exclusive property of Seveno Pty Ltd If you find any problems in the documentation please report them to us in writing Seveno Pty Ltd does not w arrant that this document is error free No part of this publication may be reproduced stored in a retrieval system or transmitted in any form or by any means electronic mechanical photocopying recording or otherw ise w ithout the prior w ritten permission of Seveno Pty Ltd Adobe and Acrobat are trademarks of Adobe Systems Incorporated Microsoft Access Window se Window 95 Window 98 Window s NT amp Window XP M and MS DOS M are trademarks of the Microsoft Corporation Seveno Pty Ltd PO Box 1165 Fyshw ick ACT 2609 Australia Phone 61
5. 4 If you select Use filters that were saved wth this graph option the graph w ill open with the filters that w ere saved with the original saved graph 5 If you have already pre selected a Level 2 and or Level 3 and or Level 4 and or added other conditions then you can select the Use filters that have just been selected option 6 Click Ok 12 5 Copying Graphs You can copy a graph and paste it as a Window s MetaFile to another application 1 With your cursor anyw here on the Graph right click and select Copy to Clipboard 2 Navigate to your open application right click and select Paste You can also save your graph as a jpg i With your cursor anyw here on the Graph right click and select Save As JPG 2 The Save As dialogue w indow opens In the Save In drop dow n menu select the folder that you w ish to save to Type in a File name and click Save 12 6 Setting and Changing Graph Properties DataSight comes w ith its ow n Graph Properties editor so that you can control the look of any graph display 1 Click on the Graph toolbar or right click anyw here on the Graph 2 The Properties dialogue box appears Chat Series Tools Export General Asc Tiles Legend Panel Paging wats 30 Zoom Sero Pint Preview FF Allow i la al Pam Pattern i Margins 2 Miniman peels 16 ET FA ma ij B 4 Mourpe Button Len E H z 9 Select the appropriate tab and m
6. sek Databi E Exit Help The Open Dialogue box appears In the Look In drop dow n menu select the folder containing the data file that you w ish to import In the Files of type drop dow n menu click to select A Files dat prn then click the file name and click Open Lookin C3 RAW Dae R Aws srm PsL ES Campbell ci dat 28 Demo Fuana xis 29 Demo Muito Sites x Demo Rental xis Deme River xls Demo Sewer Time Problem ods PB Demo we Dems Sever xe fil Demo vit A Demo WO 1 5xt s test tet E Demo WG 1 imolog log E Demo WQ txt The Import Wizard Step 1 Dialogue box appears 2013 Seveno Pty Lid C Demonstration DataBase RAW DataiDemo WO 2 prn Step 1 Sec the options for gula sport or lead v ipit Select the file type O Pamesa Characters Such as Commas or 1809 seperate each fais e Fed With Pies are aligned in colemns with spaces between each feld Howe i the data formatted Filo Delkmi r Date Formas My Time Deimber Text Qualifier limar e Dale Delimitar i Dacimal Symbol Vihere does the data start and atop First Tie Row First Data Row E Li E Hymbar of Tie Rows I Laat Dala Row S Date 02 07 2003 7 05 1959 27 05 1999 20 11 2000 19 11 20 nar fit a my tf Ch sh Ae Pm L k du GF ALE aD b BB 44 ib dy m am ALI au mam a 47 Oh La un sE EF 2 In Step 1 you will identify how the import data is forma
7. 2013 Seveno Pty Lid Luv 1 a 3 ba z T a tr ENE de K M p ji gh A EJE k um rn Tier C E 1 J a a Ren I L I k J 7 F li le LE i Fr i i Per E I j Maps are also accessible via the Level 3 Properties area as specified on the following pages You will require an internet connection to access the maps If you do not have an internet connection and wish to turn Google Maps off go to the Tools menu in DataSight and Select Options When the Options window opens select Tools on the left of the window interpelate wah master as a defaut e Show conversion summary before conversion starts Tabular Reports Use defaut display formal for variables in Tabular Reports Y Defaut display format eo E Y DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd 9 1 You can now check the Enable Google Maps checkbox and click Apply Entering Map Details To display information in the Map window of DataSight station details must be entered in the GIS Information area of a specific Level 3 Right click on the Level 3 and select Properties My Data E Biological E Dust Montoring E eBAM Statens s P North East eBAM Station 4 P Hort west eBAM Staton P South East eBAM Station a PP South West eBAM Station KJ ueteoroisgical Rain Gauges BH Weather Stations FEL 3 PF Cossi New B new Level 1 lm Rename R3 Noise Monto M Delete k Su
8. PC Ke E aka 9 060 0 4 ae as ma ee NOTE EEE KK F use conversion tatie 1 Eea Qmm am cm A APA ED j Conversion ESSE E reote wer master vara ir Stat offset lo a ap Output NL o IOC End Offset a sentem Same wan taster eran T eper ere A A A A tal Records 838 T ferent Record O78 DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Conversion Tool oe Conversions WeirkConversionTr sabre 1 2n New Bo open T se Xue Ll uo Delete variatie i wa cc DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Conversion Tool 167 Conversion Graph The Conversion Graph displays both the raw data and the converted data This can provide the user with an opportunity to complete an initial review By right clicking on the graph the user can access all of the standard DataSight graphing features found in the main program This includes exporting the graph via email or saving to a file Conversions New Conversion Set IT File New G3 Open Save j Delete Tig Add Variable lig Delete Variable d Cose Ir Conversion Variables dll Conversion Graph ET Conversion Data Conversion Graph 0 08 0085 a k Sr hnit ere 0 075 0 07 5 065 a EO r BANIA ut 0 08 AA ALA dy SA O O A el amp 0 05 be dem D05 oe hash el t ee 0 04 gt i l i 0 035 0 03 0 025 A 0 02 0 015 SO0AM 300AM 400AM SOGAN EOC AM TONAN SO
9. s Tire Fa v Adjusted Level im 4 Air temp Deg C Comments v DO ma e Evan mm v Humis y 56 i i ta i Corrected to Demonstraton DataBase E o Bag duas L DE i sese records wh 11 sv a m m Ek 2 a u J te P 1 ess BHAA y DateTime DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Quick Tour oc You can plot different series for comparison in this example overlay two different periods of Humidity data for a w eather station DataSight eles ers edt B Tabor Reports jee it Ja tw of l m January ieck 2 amp 01 2003 701 2003 801 2003 901 2003 1001 2003 11 01 2003 12 01 2003 13 01 2003 A Regent E Automatic west d V M 1701 2003 ao V a 2042003 somos Ld les tp fastos dieu Dina ma soma T 0120012 li E pan haki 1 u i 7012003 wj 40 mana ie irere eI iit vegIteccc ueceitfgAlt tfft UR m m a i u u a a a a a a a u u m a n a u E a 8 a n a u a L a s ae Graahs W Datasheets MA A nn aoe AE O UD Reports 13 01 2003 14 01 2003 15 00 2003 18 01 2003 17 01 2003 18 01 2003 18 01 2003 20 01 2003 January Week 3 ba 5 3 77050707 55707777 a A sos
10. Calculations Use previous Level 3 formulas Create new Input Fields automatically Sorted formula list a Come Cam DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Setting up the DataSight Database oe Datasheet Options Filters EF General Use filters that were saved with this datasheet Li Import s Use filters that have just been selected mm Prompt for filters to use when datasheet is lial Graph E Look And Feel im Tools Reports Orientation Portrait M Fit To Page Grid Display C Fit Columns To Width Second Row For Units show Summary Show Spatial Information Show Navigator Stop Lighting Flags Min Value MN Colour Text Max Value MEM Colour Text Goal Value MEE Colour Text Enable Usage Of Flags on DataSheet Views Create SQL Views for Saved Datasheet Views Create Numeric SQL Views for Saved Datasheet Views Change Filters Reports Grid Display Stop Lighting and SQL Views Filters When selecting a saved Datasheet you can elect to alw ays use the filters that w ere originally saved w ith that Datasheet or alw ays to use the new filters that have just been selected or alw ays to prompt w ith the above options Reports Change the page orientation and toggle the Fit to Page options for any Datasheet w hen output as a report Grid Check uncheck the Fit Columns to Width checkbox to toggle the auto fitting of the Datasheet columns to the available w idth of
11. E Merge Wizard Select Data Location Sect where fo marge the data from Menge Database Location Selec DSO Fis r 1 2 Click and navigate to the folder location containing the DataSight database files you w ish to merge 3 If you have a dsd file select it fromthe Select DSD File drop down box Otherwise leave the Select DSD File blank Click Next 4 Use the checkboxes to select the Level 1 Level 2 Level 3 and Level 4 you wish to merge and click Next DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Merge Wizard Select Rows Sect the dala t be merged e Station Statioaz C A Wells 1 2 moorted Vater 14 3 Recycled Water de 4 Holding Reservors C k 5 Heie Treatment Pant OO Distribution OIR 7 customers 5 The Merge Wizard Select Variables dialogue box appears C3 Merge Wizard Select Variables Sect the variabus lo be merged Vara bes E ip Conductieity usen 1p Flow mise Ip DO mg mg lp 56 8 lp Temperature e ipy Turbidity niu ly pH lp RH Avg lp Seccbepih m pr tomera ip TP mam lp TH img Wanabies Lp Vater Level im lp Sewer Level im lp RF mem lp Sewer mi lp Comments lp Lab ij pH pH lp 00 man lp Sampied lp Venter Tema Dep C ip uru amu lj Ar temp Deg C E lp Ham ty 44 ae i P 4 nm u Ya na Select Variables 1 On the left are listed the available variables for merg
12. For fractional exponents or exponents greater than Maxlnt Base must be greater than 0 LOGN he LogN function returns the log base N of X Example LOGN 10 100 22 MIN MIN 2 3 is 2 MAX MAX 2 3 is 3 Functions that take more than 2 parameters are IF IF BOOL X Y returns X if BOOL is lt gt 0 returns Y if BOOL 0 Values of X and Y are calculated regardless of BOOL Full Boolean Evaluation Formula Samples A MINA A B AVGB AVGB Parenthesis can be in the following formats 2 LN 1 X LOG 1 X 237 7 17 27 A 237 7 A In B 100 17 27 17 27 A 237 7 A In B 100 Functions variables and constant values can be SIN 3 14 5 2 POW 2 MAX X 2 Y nested IF a b c branching function are supported IF X gt 0 3 X F X Boolean operators are DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Conversion Tool is supported Any non zero value is TRUE 0 is FALSE Scientific notation is X COSH 3E 2 supported eg 3E 2 i l SIN 3 14 5 2 POW 2 7 MAX 10 20 SINA 2 COS 1 PV2 COSH 2 71 SINH COS 0 5 POW 0 2345 0 67 LOG 1 A 24A 5 25993 894 EXP 1 53389 A 32 POW A 0 13547 POW B 0 38603 EXP 0 36222 B A B IF A A B A IF A lt gt 0 3 A 3 IF A gt B A B 2 As mentioned the formula box is analysed for errors before the calculation is completed If you have any errors in the formula the conversion will not continu
13. Options Biological DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Setting up the DataSight Database co Access via Level 3 Control Documents is My Data Level 3 aw are so that B Biological if it is opened via a 8 Dust Montering R3 Mateorolgicn right click on Level 3 it only show s tation One documents for that amp Bj New specific Level 3 5 B setius Rename F2 teath Delete Del F Refresh F5 The Control Documents screen is show n below File J New JE Delete d Close elf A Ra z startdate Ene Date C ae n 3 T m y Ba TES Paid http aw ar thormsonenvironmeniabsy uo ST 57 ma PIU Surface Water Montering Water Quality Surface Water Montering Lachlan River Lachlan River Catchment testforAutoimport Fauna Studies aj imported by admin on HCHP Each record has a Field Description for entering a document title or the details of the document The Link column can be used to attach and open links by right clicking on the Link area for a particular record This is a hyperlink and can be a link to any local or netw ork file or can be used as an internet link Each record also has a Siart Date and End Date and these can be entered to specify the period of applicability for a document for example The Details column allow s further details regarding the documents to be entered These details are RTF documents which allow text
14. Weather Statens Camp AWS Venable Muvmelity 96 MuEpleriK 1 Coversion Table Cov ersion Type Interpolate Comments You can add you comments here Calculsting Dew Point for AWS data I I I I I I I E I 31 07 2008 30 08 2008 25 05 2008 25 10 2008 28 11 2008 28 12 2008 27 01 2009 26 02 2009 Date amp Time The image above displays the Conversion Graph Plotted on the graph are Variables A and B and the Result of the formula entered As with the graphs created in other areas of DataSight users can save and export the graph and data and zoom in DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Conversion Tool 175 and examine the graph more closely within the conversion w indow 12 Press the Close button w hen you wish to view the output data You can then elect to either save or discard the L conversion you have completed by selecting Yes or No Confirm No Cancel Note that this simply saves the Conversion Tool window variable s and formula You do not need to save to complete the conversion 13 Select Yes to refresh the datasheet and view the newly calculated data Data in the datasheet has been modified You have to refresh datasheet to see the current data Would you like to refresh it now The Dew Point C variable has been populated w ithin the datasheet Siain Date Time Cale Cale Ory Teme Hr Avg C Humidity 56 Dew Pont C k
15. 2 6228 1994 Fax 61 2 6228 1996 E Mail support seveno com Website http w w w seveno com DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Your feedback 2 2 DataSight Users Manual Version 2 9 4 Your feedback To help us improve w hat we offer we would like your feedback about this Help File and about any other aspect of DataSight email at support seveno com or by mail at Seveno Pty Ltd PO Box 1165 Fyshw ick ACT 2609 Australia or by phone fax on Phone 61 2 6228 1994 Fax 61 2 6228 1996 Visit our website at www seveno com 2013 Seveno Pty Ltd Get the the latest version 3 3 Get the the latest version Check on start up If your PC is connected to the Internet DataSight can check for updates as it opens to make sure that you have the latest version You will be prompted to update and taken through the update process if you choose this If you prefer you can turn this option off and then check for any updates on demand To do this Turn off Auto Update on start up 1 Click Tools Options on the main menu Options Ayto Update Enable Auto Update aa import E MA Update Location http www sevens comdownleadal gisa dil Graph Paths E Look And Feel Exon Path Merge Path Report Save Fath Temp Data Path C Program FlesDataSight DesidogiTemp A M WOE Temp Path C Pregram FlesiDataSight DeakloniTer 2 Select General in the left panel
16. 3 or Level 4 level 2 Click to select the Level 2 Level 3 or Level 4 then select the DataSheet tab if this is not already selected 3 The default Column headings in the DataSheet correspond to the data variables already set up in the DataSight Field List xc database If the Field list panel is not already displayed click the button on the DataSight toolbar Editing data in the Datasheet Data may be changed directly in the datasheet To edit data in the datasheet 1 Click in the DataSight toolbar 2 Click in the appropriate data field and make changes e Click off the row to save the changes athe datasheet remains in edit mode until the A E button is toggled off To delete data in the datasheet 1 Click anyw here in the data row 2 Right click and select Delete Record 3 You can delete multiple records by using CTRL in conjunction with clicking To select a range use SHIFT in conjunction w ith clicking With the development of DataSight Plug In Modules capable of complex data manipulation it is prudent to add additional temporary calculation variables e g Calc 1 Calc 2 Calc 3 The preliminary results of calculations can be placed into these columns When finished w ith these temporary results you are able to use the Clear Column option to remove the data To clear a column of data la Click anyw here in your chosen column 2 Right click and select Clear Column DataSight Users Manual Version 2 9 4 20
17. C Demonstration Database RAW DataiDemeo Sewer xls Select the options for data kapon of load kive p E E A RR GE in i 4 Khana ee ee es ee m sami n m zni MN M E Miu oe Demo Sewer E Dat rE Fermat ow WB ul i Station l P Ls hi if PD la I x 71 n d a eT l ds ide om y I gt os i i i J 1 07 1994 1 07 1994 ZTS 1 07 1994 1 07 1894 1 07 1994 1 07 1994 0000000000 T A gt n von A 46 i co od nh oh Uk B dud dan Ch Ch H OF OF C i aD oun ooo XC Ck eo foo C oC url B By RR Bs ER ha koj T PP 20000000500 dd fe F this canes w e are importing a spresdsk c buly you can a imo text files both delimited and fixed width along w ith may different raw data logger files wo Demonstration Database RAW Data Demo WO 1 txt l Step 1 Shkoi ihe options for cata import or ad dave Spec RAT o commas or tabs seperate each field gon Width Fields are aligned in columns with spaces between each fied How is the data formatted M measer OE KMM NS ORG 5 SSS m Pta Domos v DateFormat OMY Tree Detter A OZO ECC Text Qualifier rone il Date Dimter Reema gyneet Where does the data start and atop mae VALE Fist Tee Row ja c inris Time rus TAI mg i F 133 Gaara AM 0 01 61 a Q 22 03 2929 5 20 33 AM 40 01 8 4 e Q 24 03 22999
18. Click on the arrows to open and Close the panel Field List Panel Field List Displays the available variables l in your DataSight database Click the arrow s to open and close the panel Filter Panel NT Filters Displays the current Filters Click on the conditions applied to the DataSight Toolbar to toggle selected data At the top of the main DataSight w indow is a Toolbar panel Toolbars The Toolbar panel comprises Tt C5 DataSight AE Pe Ent Took Heb Mew save Print E Prevew import T Filters E Tabular Reports MDE 4 KE i a0 e The Menu Bar The DataSight Toolbar The Graph Toolbar Menu Bar and DataSight Toolbar Type Description Menu bar The Menu bar is a special toolbar at the very top of the screen that contains the menus File Edit Tools and Help Click any menu name in the bar to see a list of menu commands Moving the cursor over any other menus will display the options DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Getting Started s w ithout having to click again Click to select and execute any command Any greyed out menu command indicates that it is not available DataSight Toolbar The DataSight toolbar below the menu bar provides shortcuts to the DataSight functions that you will use most often DataSight Button Function Opens a new blank graph when the Graph tab is active or adds a new record w hen the Datasheet ta
19. Click the Save button and the Save Spec dialogue box appears Type in a description and click Ok DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd 10 1 4 Receiving a dsd file If another user has sent you a dsd file 1 Right click on the dsd file and select Save As 2 Navigate to the location w here you wish to save the file and click the Save button Then you can either Merge the data into your currently open DataSight database or Create a new database from the dsd file DataSight dsd files are only compatible w ith DataSight Desktop and NOT DataSight Enterprise DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd 10 2 Manual Data Entry MDE As well as importing data you can also manually enter data against an existing Level 3 Manual Data Entry MDE can replicate your field datasheets so data can be keyed in quickly To add data 1 Click on the DataSight toolbar and the Manual Data Entry form appears Datasight Manual Data Entry Form Man Fields Ste Mamor Stream Gauging Stations NABUKIO Mong oring Time Name Obzerver Exguipemernt Create Level 4 data if Eis not already created Update the Level 4 information H tit aready created Wansble 140 m lsec pH Click on the drop dow n Site menu and choose a Level 3 Enter the Monitoring Date and Monitoring Time Alternatively you can Create Level 4 data if not already created or Update the Level 4 informatio
20. DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Setting up the DataSight Database This can be useful when attempting to recover lost or accidentally deleted data as full details of the data are retained You can copy this information into to Clipboard and use somew here else 8 7 1 2 Level 4 Properties 1 With an existing Level 4 selected right click and select Properties e Data List Y My Dala E 1 Local Vater D Aquilers Se Lake zo P north Station ET oe 704 a Nen i 4 504 Rename F2 T IE Delete Del D q MK A eni a Ew zs d 10568 Properties Fz TSn Gentrel Documents d 5011993 41 902 993 2 The Event Properties dialogue box appears show ing the Body Type Body Station and Events Event Properties 3 Check your Equipment and Collector information for the Level 4 Date If the appropriate choice is not listed in gm the drop dow n menus click on to open and edit audit trail information 4 The Comments box can be used to store other information relating to the Level 4 5 Click on the icon The Find dialogue box appears DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Setting up the DataSight Database se mer Find what Find Next Match whole word only Direction Cancel Match case E Up Down 6 Type in the text you wish to find in the Comments
21. Delete Record wiz ji Py Conversions ymi S Data Quality 1100 Column Settings 110157 Summary Panel nu Navigator Panel IST Stop Lighting s Standards 19 0 god Paper 164 eu Print EH id Preview 11 0 T Filter Options 507 cokes Echt Record with MDE Li b PH pH units 8 3 Bi 78 T 7 3 789 TES 7 65 TT TE 3E ai Ad 2 05 0 18 0 03 0 03 i NS 0 01 r Australian Drinking USGS Water Quality Standard 0 07 01 HAQI 0 03 0 0 0 02 Chilarine Total a SEP A 0 05 0 06 0 2 0 2 0 2 0 1 0 1 0 1 n2 0 18 0 1 0 1 0 1 After you select one of Standard you created Datasheet w ill trace the data and will show the exceeding data different colors which are selected in Options You can see the one of the samples for Datasight variable pH DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Scientific Standards 225 pH pH Units 4 30 4 40 F 96 8 01 8 10 F 85 0 46 6 04 1 8 10 7 90 8 00 6 30 5 00 6 00 How to use Standards in the Tabular Reports There are two special reports w hich are available through Tabular Report Wizard e Standards Exceeding Data e Standards Summary DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Scientific Standards s e DataSight Tabular Report Wizard Report Type Select report type date amp time Report Type C Mon
22. Export Print Series General Axis Tiles Legend Panel Paging Wak 30 Scales Title Labels Ticks Minor Position fe Automatic fe Verde inverted F Masar 983 Minima Change Desied Increment 0 Loganthmic Log Base To add a Custom axis click the button below the axes list To display four variables on the y axis as isre quired here click this button three times Lett Axis Fight Axis Top Axis Bottom Axis Depth Axis Custom Custom 1 You now have a Left Axis and Custom 0 Custom 1 and Custom 2 to display these variables DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Graphs 127 To distribute these axes evenly up the left hand y axis Within the Editing window Select Left Axis within the Axis tab and click on the Position tab Editing Chat Series Data Tools Export Print Series General Axis Tiles Legend Panel Paging Walls 30 F Vibe Scales Tile Labels Ticks Minor Position v Behind Popis Position 0 Start E o lt End 100 E leave the Start on 0 change the End to 25 select the Custom 0 axis from the list to the left Change the Start Position to 25 and the End 50 Custom 1 Start 50 End 75 Custom 2 Start 75 End 100 Chad Series Data Toole Esport Print Series General Asis Tiles Legend Panel Paging walk 30 F Visible
23. Level 4 Properties Level Control Documents O RB G N 2013 Seveno Pty Lid Contents i 8 9 10 9 1 10 1 OO m 0 JO OU BON NY Noa AGN 13 14 15 16 Control DOCUImenlS oo reso uzdu ven adu dna it ME REGE 59 OPIONS X 61 Repairing and compacting the Database eeeeeeeeeeeeeee nennen nennen 68 Maps 69 Entering Map Detalls med p 71 Data 74 IMPOFUNO Gala NOREK NN Mao NE I 74 Imporling SspreadsheetTeS ia 74 importing other delimitada ee eaves ease eee nc em eto repa erac eco unice aan ko dea ads 81 importing Bib CX Ze RI e M 88 Recelvina a ASdAe mtt 94 Manual Data Env MDE Leo 95 Merdgind a Cala Da SO xc ccscesceecesenceestas on DAE o oc Osee oe cu DAD Dub pA NER RUNE SE MEN OR USA DAN secs POS UR OS UR NS ROUES 97 2 4athuegocir m kok 99 Exporting data from a dalasheel A bee cu eco core crt react 99 Exporing a Desktop das A Cu cu ovx oe ek tuus cutn Ep RUE kn aek 99 Move To COPY TO 25e a cs aka o P Ex ERR d ASA Es AKE ais 101 MA a pon 102 CODY Toca M 103 Viewing Editing Data 105 Editing data in the Datasheet una oca 105 Manual Data Enty MDE cos 106 Datasheet display OPTIONS iii ai 108 SUMMALY SlAUISUGS e
24. Logarithm Root Model Power Freundlich Modified Power Exponential Modified Exponential Rectangular Hyperbola Reciprocal Model First Order Logarithm Logarithm Model Reciprocal Logarithm Model Geometric Model Modified Geometric Model Group Name Inverse Polynomial Inverse Polynomial Inverse Polynomial Inverse Polynomial Inverse Polynomial Inverse Logarithm Inverse Logarithm Inverse Logarithm Inverse Logarithm Inverse Logarithm Single Parameter Convex Concave Single Parameter Convex Concave Single Parameter Convex Concave Single Parameter Convex Concave Single Parameter Convex Concave Single Parameter Convex Concave Single Parameter Convex Concave Two Parameter Convex Concave Two Parameter Convex Concave Two Parameter Convex Concave Two Parameter Convex Concave Two Parameter Convex Concave Two Parameter Convex Concave Two Parameter Convex Concave Two Parameter Convex Concave Two Parameter Convex Concave Two Parameter Convex Concave Two Parameter Convex Concave Two Parameter Convex Concave Two Parameter Convex Concave Two Parameter Convex Concave Two Parameter Convex Concave Two Parameter Convex Concave Two Parameter Convex Concave Saturation Growth Model Two Parameter Convex Concave First Order Inverse Hyperbolic Model Hoerl Model Modified Hoerl Model Two Parameter Convex Concave Two Parameter Convex Concave Three Parameter Convex Concave Three Parameter Convex Concave 201
25. Paging Wale 20 F Visible Scales Tide Labels Ticks Minor Position Tithe 10 RF Hily Tot enm RH Hii Avg 4 7 Sie o M bla Separation Lines Using Tools Select the Tools tab from the top of the Graph Properties editing window and click the Add button Select Color Line and click Add Editing Chat Sevier Data Tools Export Peint fe Chart Tools Gallery Add 3 colour lines You can now assign these lines to Axis and check the Allow Drag box to set their position on the axis Chad Series Data Tools Esport Prira Bx Let Asi Border Valuer o M Allow Drag Disg Hepsini Mo Lent Diag DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Graphs 132 Click Close 12 8 2 You have now created a high quality presentable chart using several variables from your dataset You can now print the graph or it can be copied to the clipboard or saved as a JPG file and placed into a report or other document To do this right click anywhere on the graph and select from the list of options ta 2 A EBU Rename Series Delete Save as JPG Copy Eo Clipboard Print Preview Switch Axis Filter Options Advanced Options Properties 114 2008 11 7 2008 ORF Harty Tot mm Darton Automatic Weather Station Camp 1 November 2003 1150 2008 1113 2009 RH Hirby Awg CR 11 16 2008 1113 2008 Tu 22008 1152
26. a b x 5 log x c log x a b x 5 log x c x 5 a b x 5 log x c log x x a b x 5 log x c x a b x 5 log x c x 1 5 at tb x4 5 log x c log x x2 a b xA 5 log x c x 2 a b x 5 log x c exp x a b log x 2 c x log x a b log x 24c x 5 a b log x 24c log x a b log x 2 c log x a b log x 2 c x 5 a b log x 2 c log x x a b log x 24c x a b log x 24c x 1 5 a b log x 2 c log x x 2 a b log x 24c x 2 a b log x 2 c exp x a b x log x c x2 5 a b x log x c log x a b x log x c log x a b x log x c x 5 a b x log x c log x x a b x log x c x a b x log x c x 1 5 a b x log x c log x x22 a b x log x c x 2 a b x log x c exp x a b x 54c log x a b xA 5 c log x a b x 54c x 5 a b x 5 c log x x a b x 5 c x a b x 54c x 1 5 a b x 54c log x x 2 a b xA 5 c x 2 a b x 5 c exp x a b log x c log x a b log x c x 5 a b log x c log x x a b log x c x DataSight Users Manual Version 2 9 4 Model Name Regression Tool Group Name Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two
27. bis aten 1 2007 2003 goza la Staton 27 08 1990 0008 T Station 1 27 054999 0055 74 Satoni 20 11 2000 amp 01 31 7 1 Staton 1 19 122001 9 00 04 Station 1 15 01 2003 18 03 08 Input Fieid DataSight Field Station Date base EO BA Day of Year ate Tithe Date Variables LL AAN RA uses Level m 13 The left column lists your Input field names Click in each adjacent line in the right column to access the drop dow n list and select an existing DataSight field to map each Input field to Note that if appropriate the DataSight field does not already exist You can click the Variables button and add the variable Then close the Define Variable dialogue box to return to Import Wizard Step 2 dialogue box No unmapped fields will be imported 14 When you have mapped all the fields click the Next button The Import Wizard Step 3 dialogue box appears 15 In Step 3 you will be preview ing the data you are importing This is also where you may Save the Import Specification to save repeating earlier steps w hen importing similar data Saving the Import Routine E select Import Spec Name import Routine Benthics DepthDa charge Gauging Station Hydrolab Step3 Preview the cate that wil be importes 27 05 1999 5 00 55 AM 20 11 2000 9 01 31 AM 71 19 11 2001 9 00 04 AM 6 97 15 01 2003 19 03 05 AM 68 25 98 1999 9 00 13 AM 6 62 epe ct ume qu 16 If you are happy with the data press N
28. images and hyperlinks The final column provides an area for attaching files Right clicking in the Attachment column allow s the user to attach any file type as shown below Load Attachment Is used to add an attachment to that record g Attach File dB Open Attachment Open Attachment opens the attachment using the associated Save Attachment As softw are in Window s a Clear Attachment Save Attachment As saves the file with a new name without changing the original format Users can change the name w hile saving Selecting Clear Attachment deletes the attachment without deleting the record DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Setting up the DataSight Database KO You can save ICS Outlook Calendar files into Control Documents w hich can be scheduled for email Open your Outlook Calendar click Save As and select Calendar format Once your calendar is saved in this format open the control document window w here you wish to attach the calendar and then click on the Brow se icon le Select the calendar for attachment and click open Using the Scheduler you can then disseminate this calendar file to intended recipients A possible example w here this might be of use is the emailing of sampling runs to staff members An important note for users of older versions of DataSight Old existing control documents are kept as a record That is DataSight w ill automatically create an initial record and copy all
29. p value 0 0000000000 Residual Standard Error 20232158675 Regression Sum of Squares 4960 0963041280 EN Residual Sum of Squares Selecting a model from the list will display the model graphically and present the statistical model details including the R2 value p Value Standard Error and Sum of Squares information as show n above Further details can be found by clicking the Details button DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Regression Tool Regression Graph Confidence Models Analyse Results Output Table V ater Quality Mode Model Definition R Value 7 y Res Standard Ern 10 a x 10 b x 9 c x Bed 0 99712 0 90881 9 a x 9 b x Bec x 7 d 120671 8 a x Beb x 7 c x 6 d 1 49540 7 a x T b x G c x 5 d 2415894 6 a x G b x 5 c x 4ed 0 97401 2 46870 5 a x 5 b x 4 c x 3 d 0 97397 2 41635 4 a x 4 b x 3 c x 2 d 0 96819 2 61494 3 a x 3 b x 2 c x d 0 96138 2 82322 2 a x 2 b x c 0 95643 2 94032 1 a x b 0 76349 6 72270 Model Number 3 Model Definition a x 3 b x 2 c x d Model Description Third Order Polynomial R Value 0 9613782144 p Value 0 0000000000 Residual Standard Error 2 8232158676 Regression Sum of Squares 4960 0963041280 Conversion Table ConvTable Un
30. used DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Quick Tour Standards are used to implement Min and Max settings for variables 3 C Demonstration DataBase RAW DataWDemo Sewer xls Use the drop dow n menu to select the desired Standard Click Next and you re done DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Quick Tour NOS You can check the Import Summary Information page before proceeding w ith the import i C ADemonstration DataBase RAW DatalDemo Sewer xls Step 6 Summary nformalion of igon Source Source Fig C Demonstration DaraBasevtAW Da Humber of ines m source fla 25504 import starts fram 3 impart mhes ai 3 Levels Level 1 City Level 2 Sener iMontoring Level 3 Semer Se 1 Variables Gate i Field gt Data Time Ejaidd om Tima Level F Fiald5 gt Sener Level m Gif Freig gt Sewer O msi Information DataSight Users Manual Version 2 9 4 auDemo Saver xis 2013 Seveno Pty Ltd Quick Tour NON 5 4 Quick Tour Exporting Data You can export all or selected data in a database format Select the data you w ould like to export e Export Wizard Select Rows Sec ihe cata lo be exported mA Catchers t O Rania Stator Stream a D amp Water Quality Note The creation of a DataSight dsd database file is NOT available in DataSight Enterprise Data Export fromthe Enterprise version is direct from the
31. 075535 2233258 A au uo E ALE ee 2 48925 2925 855 2655 2 0825 2373 2 064 1 952 1 3315 218l 202 8707675 25815 3 654 Das 003784 023185 1 46738 34701 5 72137 amp 67578 11 298216 13 37827 17 052855 2251344 20 42328 38 356478 Dscharge 42 4798155 70 1139475 100 9737375 93 7102925 8396202 34 743338 32 9155025 31 267234 31 0216225 41 102331 B5 09 3485 Fij graphically in the Regression Graph area DERART GU a ES Hawson River Feb2010 200 400 600 eng 1 000 1200 1 400 Conversi n Table ConvTable Unselected Gaugings o Gauginas Unseleleci d Regression Curve Ouiput The user can select and deselect row s from the Conversion Table and those from the Gaugings before or after carrying out analysis by selecting the checkboxes at the left New oj Save Table Gaugings g Analyze CS Result Setting Selecting the Result Settings button allows the user to define the upper and low er boundaries of the result set produced during analysis along with the required number of increments required for the result set DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Regression Tool 207 Autcmabcaly set start and and values Use these values X value siari from 0 00000 X value ends at 4 00000 increments increments al each step Number of increments P New lH save Table Gaugings R
32. 1 Sewer 1 Cte The final step is to select output type You can send your report directly to the printer or you can save your report into different file formats like PDF RTF etc DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Quick Tour 1 O DataSight Tabular Report Wizard Ouput Device select one of the output options To Print setting Collation Station Print report Show preview screen for each report Show print dialog C RIF save Options Save As C Sewer reports PDF C Create one file for whole report save Template E DataSight Tabular Report Wizard Reports List of created tabular teporta Reports 1 City Sewer Monitoring Sewer Ste 18UserVariZ UserVari1 Uservaro J Cimate Regi n 1 Sewer 1hUserVard Uservar amp User ara User ars DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Quick Tour 32 5 8 Quick Tour Notes Thanks for taking the Quick Tour To summarise DataSight is Seveno s flagship product a platform for the management graphing communication and reporting of any natural resource data DataSight handles information relating to any part of the sector surface and groundw ater atmosphere soil and others Use the advanced power of DataSight to connect with or import data from acquisition systems such as probes sensors data loggers and laboratory instrumentation into a logical centrally organized relational data
33. 152 154 155 156 157 158 159 160 161 162 163 164 165 166 168 169 170 171 172 173 175 176 177 178 179 Formula a b x 1 5 c x log x a b x 1 54c x 5 a b x 1 54c log x a b x41 5 c log x a b x 1 54c x 5 a b x41 5 c log x x atb x41 5 c x a b x 1 54c x 1 5 a b x 1 54c log x x 2 atb x41 5 c x42 a b x 1 5 c exp x atb x2 c x2 log x atb x42 c x2 5 a b xA2 c x 3 a b xA2 c exp x a b xA2 c xA 5 log x a b x 24c log x 2 at b x42 c x log x a b x 24c x 5 a b x 24c log x a b x22 c log x a b xA2 c xA 5 atb x42 c log x x atb x42 c x at b x 24c x 1 5 a tb x 24c log x x 2 a b x 24c x 2 a tb x 24c exp x a b x 2 log x c x 2 5 a b x 2 log x c x 3 a b x 2 log x c exp x a b x 2 log x c x 5 log x at b x42 log x c log x 42 a b x42 log x c x log x a b x 2 log x c x 5 a b x 2 log x c log x a b x 2 log x c log x a b x 2 log x 4c x 5 a b x 2 log x c log x x a b x 2 log x c x a b x 2 log x 4c x 1 5 a b x 2 log x c log x x 2 a b x 2 log x c x 2 a b x 2 log x c exp x DataSight Users Manual Version 2 9 4 Model Name Group Name Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term In
34. 4 2013 Seveno Pty Ltd Viewing Editing Data 113 11 6 11 7 Setting dates There are two ways to Set dates By Overtyping 1 Collection iz equal ta Bluewater 2 Station is equalta 21001 3 Date is equal ta 8 2000 Click here to add E E Click the day to highlight and overtype new day Click the month to highlight and overtype new month Click the year to highlight and overtype new year Or by using the Calendar Tool 1 2 4 6 Click on the dow n arrow to display the calendar w ith today s date highlighted Click on the year displayed in the blue panel header on the calendar then click to select a new year fromthe display January 1343 zo Sun Mon Tue Wed 1990 1531 20011 3 4 5 B 1997 007 10 11 12 13 1903 C 17 181 2 199 2004 gt d 2 1905 2005 1996 2006 Today 10 14 x 1993 00 wi 1933 009 Then click on the backw ard or forw ard arrow s in the blue panel header to navigate back or forw ard through the months or Click on the month displayed in the blue panel and click to select the new month January Sun Hon Tue Y February March A es Exe g 10 11 16 47 18 May Today 72 9 September Ockaber Hovember December Click on the new day w ithin the calendar page Click anyw here off the calendar page to set Saving a Datasheet To save the current Datasheet Click and the Save As dialogue box appears Name
35. 46 SIN recane Ier nc 0 4 06 2002 8 00 12 AM 8 04 55 over Standard 0 00 an0 2002 2 00 43 AM 8 10 2910 2002 9 00 44 AM 7 90 Drinking Water Crib 10 611 2002 9 00 45 AM 8 00 5 12 2000 9 00 00 AM 8 04 302003 2 00 48 AM 8 30 2 01 2001 39 00 00 AM M TIBTIZDOS 10 40 00 AM 3 00 7 10 2003 10 20 00 AM 7 30 DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Scientific Standards NS How to use Standards during Import Users can also use standard in the Import to check w hether imported data is in the standard limits or not You can select w hich standard you w ould like to use in the during the Import process at the 6th Step of the Import Wizard CDS Data RAW Data tet Step 6 Seed standard Scientific Standards e Use Standards Standard AS You can see the result at the last step of the Import Wizard If you finished the import all the Import Summary will be recorded into the related Station properties under the Import Audit Log section For example Import Import Date amp Time Source File 13 04 2009 11 14 01 AM Source File C Documents Seveno remote mine ground water csv Number of lines in source file 404 Import starts from 2 Import finishes at 25 Levels Level 1 Remote Mine Level 2 Ground Water Monitoring Variables Sample Location Field2 gt Level 3 Date Field3 gt Date Time Field4 gt Time Al27 MR Field5 gt Aluminium Total mg l Standards Check 1
36. 9 00 234 AM 0 01 35 3 te DQ 16 904 18999 9 00 35 AM 0 01 178 3 se 0 22 04 1999 9 00 36 AM 0 01 28 e Q 28 04 1999 9 00 37 AM lt 0 01 TE e O 12 08 1 399 9 00 38 AM lt 0 01 595 5 0 29 08 2995 9100 33 AH 40 01 687 4 e Q 2 06 1999 9 00 40 AH 0 01 0 2 DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Quick Tour 12 In the above image a txt file is being imported The user needs to select either delimited or fixed width format for the file type DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Quick Tour 1 Map the spreadsheet fields to your DataSight database fields je Demonstration Database RAW DatalDemeo Sewer xls Step 2 Wag maul falda bo Data Sight aida p Sewer Ste 107 1994 Sewer Ste 107 1994 JE 0 081 lere sur Times es 26 00 eer 078 F Sewer Sie OTA jo 25 00 0 07 ors ETET Pe imp j pH ipe RE rem i Sampad Y Sawer Level mj m Seer O mi 1 Sel Rad Kw e Z GIGS LLLE IGIAELTZZZ ru ELLEELCG G HC ZGOZI LLLZ EZS GO ZD3DIIG GLTI O Y ou may need to add Datasight Field Variables to match the Input Field Click the Variables button and follow the steps under Quick Tour Database Variables DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Quick Tour ta You can preview what your data will look like once it is imported Then select next to continue C Demo
37. 9 4 2013 Seveno Pty Ltd Regression Tool 199 Note that you can select regression models from the list on the right and the graph will reflect this change red line 3 In this example am satisfied w ith the regression model from a discharge point of about 4 5 before this point the model is not reliably accurate View the generated analysis results by selecting the Analysis Results tab 0 597979797979790 0 795959595959596 0 993939393939394 1 19191919191919 2 18181818181818 2 37979797979798 are rrr So ETETETT E T 29737373737 3737 A AF1riririririr 3 35969696069697 3 6767676167677 3 76265656565657 3 96353536353635 4 16161616161616 4 fo oTa aG 4 7 5000500050000 4 95353535353535 5 15151515151515 5 34849484848485 s5 54faTATATATATS 0 705142434676729 0 574475456760372 0 544845318206706 0 59052150254337 0 566235792111661 0 5445307659390565 0 525042660674306 2 0 5087 45264404134 0 495 72057096076 0 4062 73592511921 0 4607093134 76597 0 475332718193769 0 482445791002417 0 490362516241522 0 503378878250063 0 521802861357022 0 5459399449991379 0 576083628282114 0 6125 70360756206 0 6556 74691696041 0 705711545442383 0 76298592632546 0 6276026106057 r 0 900467 206603372 0 961264075230206 1 0 7055040607526 4 The user can then highlight row s and output to a new table In this example we will select row s right click and select Copy Selected Into Output 9 This mov
38. Camp AWS 19 07 2008 12 00 00 AM 12 22 65 52 5 9482 EI Camp AWS 19 07 2008 1 00 00 AM 11 83 724 7 0255 Camp AWS 18 07 2008 2 00 00 AM 10 42 787 68781 Camp AWS 19 07 2008 3 00 00 AM TA 80 66313 Camp AWS 19 07 2008 4 00 00 AM w 738 K Camp AWS 19 07 2008 15 00 00 AM 11 74 74 3 67161 Camp AWS 49 97 2008 6 00 00 AM 12 45 68 79 8 8744 Camp AWS 19 07 2008 7 00 00 AM 12 33 71 4 7 3020 Camp AWS 18 07 2008 8 00 00 AM 1268 6556 6 3842 Camp AWS 180712005 9 00 00 AM 14 11 58 51 6 0947 Camp AWS 19 07 2008 40 00 00 AM 158 47 42 4 6344 Camp AWS 15 07 2008 11 00 00 AM 1 amp 25 TT 35750 gt Cl A Camp AMS 19 07 2008 1 00 00 Pu EKOSE rr Camp Aws 19 07 2008 2 00 00 Pu 219 28 08 3 1600 Camp AWTS 19 07 2008 BE E E 26768 Camp AWS 19 07 2008 14 00 00 Pu 22 15 30 96 4 1971 oy Tine xu m abi La Pa remm mA AL aa AS rre 4 DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Conversion Tool 176 16 3 2 Completing a Conversion 2 Example 2 A simple calculation The follow ing example illustrates a simple multiplication completed w ithin the Conversion Tool Ji Mew Y Opes rd 56 WC De ebe dig Add Wendie TM Delete s hrs tir Help d chew lj Cenepo vacabit jj edv k m Grape C Comeersen Data Apr MALO rapia Deam ur Example Converting Depth metres to Depth feet K EE a U oe 4 zia P EE O1 tputvai ADT Eu Eka Cate were a F Opt MOC 4 ee E Wear Var P di
39. DataSight database by selecting Security gt Who s Logged On fromthe Tools menu This window displays the User Name and Logon Time of those currently using the database Who s Logged On 0 Admin 16092009 10005 42 am Y Alan 16 03 0009 11 09 53 am DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Setting up the DataSight Database a 8 8 1 8 2 Setting up the DataSight Database Before importing or entering data into the DataSight database you must first define the structure and nature of the data fields variables you wish to use for your variables and add these to the Database You must also decide on your Level 1 Level 2 Level 3 and Level 4 hierarchy You can also set a security function on your database and maintain audit trails Creating a new database DataSight Desktop Edition comes w ith a sample database but when you w ant to import data or if you have received a DataSight database from another user then you can create a blank database or create a database from the dsd file that you have been sent 1 Click File Database Create 2 The Create Database dialogue box appears 3 Choose the location w here you w ant to save your new database 4 If you are creating a database from a dsd file then check the Create from DSD file checkbox not available in DataSight Enterprise and select the location of the dsd file Click the Create button 6 You are now able to import or merge data into the
40. Dimensions uen Veca 0 F Apo 6 The user can also change the layout of the wind rose from within the Editing window shown above Turn points on off by selecting the Visible checkbox in the Series gt Point tab Chat Series Data Tools Expo Print wind Vel Hr Av rvs GR Wied Rose wind ve Format Point Cicled General Marks Data Source Fr A e Dad Style MS quese warji Height Turn the border on off using the Pen and Pattern options in the Series gt Format tab Chad Series Data Toole Export Print wind Vel Hr Av m s GB windFioce Windve m Format Point Creled General Marks Data Source Pen IV Close Cece F Valles T imie Patten Circle 7 Rotated Radusinciement o H t9 Transparency gt DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Add a title in the Chart gt Titles tab Edit the Legend in the the Chart gt Legend tab sssusssssamuuuzuuurrd Series General Axis Titles Legend Panel Paging walls 4 k 1 Camp AWS August Wind Rose a Vid Vel Hr Ay dm x Wind Vel Hr Ar m s Note When the user needs to mark wind direction points on a Wind Rose it is important to select Label from the Graph Properties w indow This is show n below DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Graphs 137 Chat Seres Data Too
41. H Cole Bar Dieto H for Dak Ba 30 Sides he Bor Side Maegan E Auto Mark Pontion Select the variable to be displayed as a Bar chart eg 10 HF Hrly Tot under the Format tab you can alter the Style Colour Bar Width etc Click the Border button and untick the Visible checkbox click OK DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Graphs 125 Border Editor jf Visible Style Solid Color M width fi Round Cancel From the drop down arrow under Series select the variable to be displayed as an Area graph Sol Had Hrly Avg Char Seres Data Tools Export Print Sol Rad Hrly Avg kwmz Area Format Point General Marks ata Source under the Format tab click the Border button and untick the Visible checkbox click OK Click the Area Lines button and untick the Visible checkbox click OK Following these steps has simply removed the borders from around these two variables Another option is to click the Color button and you can change the colour the variable will be displayed in DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd In order to distribute the variables along the y axis you must create several custom axes to display them on In the Graph Properties window select the Chart tab now select the Axis tab This diaplsy all the options available to you for editing the chart axes Chart Series Data Toole
42. Lite can still be used to import export and maintain data in a DataSight database and can be used after the 30 day evaluation period for DataSight has expired How ever not all the features described in the Help file w ill be available for DataSight Lite 6 3 Typographical Conventions Before you start using this Help File it is important to understand the terms and typographical conventions used For more information on specialized terms used in the documentation see the Glossary The follow ing kinds of formatting in the text identify special information Formatting Convention Type of Information Numbered List Step by step procedures You can follow these instructions to complete a specific task Special Bold tems you must select or interact with such as menu options command buttons or dialogue boxes Emphasis Used to emphasize the importance of a point or for variable expressions such as parameters CAPITALS Names of keys on the keyboard For example SHIFT CTRL or ALT KEY KEY Key combinations w here you must press and hold dow n one key and then press another for example CTRL P or ALT F4 DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Getting Started 7 Getting Started This chapter describes the w ork environment and the interface elements you will encounter w hile you are using DataSight 7 1 Main Window Layout The main DataSight window can be divided into 5 panels The three panels to the left
43. Ltd Quick Tour 22 O Merge Wizard Select Variables Seba th variables lo b merged Ayr Conductivity uS cm Up Flow mimsec dp DO mg img ip d p Temperature e lp Turbidity ntu lp pH ip RH Avg lp SeccDeoth im pr ether lp TP mar li TH manm A vw m DataSight Users Manual Version 2 9 4 Variables lp Water Level e ipe Sewer Level im dp AF imm lp Sewer m lp Comments lp Lab lp p i pH Ap 00 mo lj Sampied LL Vater Temo Deg C i ip MTU MTU lir Ar temo Deg C lj Hamaty mr For 2013 Seveno Pty Ltd Quick Tour 2 5 6 Quick Tour Graphs After your data is in DataSight you can retrieve it view it graph it and interrogate it DataSight Ale h Fe me dy eet Green Z emi T ries est bue Reports ee i Jt gt e BB EFRON jE Datasneet Gi Hew Graph Apipmabe Viesiher Stator Humidity B Regi n 1 F Automatic viet m wow 201 2003 M 3701 2003 T 4012003 d 5 01 2003 aT 601 2003 T reves l Te Saved Views m 3 Graphs e FS Datasheets x E Resorts a ae rp p ae UE a ETE ET rTU Tre TE ET TE ET E HET m TIT MERECE ee PD LIII A ee ee T dx n en ae A A A a ed E A a ET ape T aca T ace u lp Varables DateTime v Date Tere Adjssted Level m Air temp Deg C Comments v DO mam v Evan imm ven js DataSight U
44. Model Definition a x 6 b x 5 c x 4 d x 3 e 2 i Model Description Sixth Order Polynomial R Value 0 9740125453 0 10 15 20 25 30 35 40 45 50 p Value 0 0000000000 Conversion Table ConvTable Unselected Residual Standard Error 2 4687007474 X Gaugings Gaugings Unselelected a x 6 b x 5 c x 4 d x 3 e x 2 f x g Output Regression Sum of Squares 5025 2813656363 Residual Sum of Squares 134 0786343637 DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Regression Tool m 8 In this example as it fits the line w ell we select Model 65 Gunary Model as shown below Regression Graph Confidence Water Quality i R Value 7 Res Standard Er 10 0 99712 0 90881 9 0 99464 1 20671 8 0 99133 1 49540 7 0 98103 2 15894 6 0 97401 2 46870 5 a x S b x 4 c x 3 d 0 97397 2 41635 65 x a b x c sar x 0 97273 2 32604 69 a exp x b 2 2 c 0 96931 64 exp a b x c x 2 0 96931 4 a x 4 b x 3 c x 2 d 0 96819 67 x a exp b cx 0 96677 45 a b log x c log xy 2 0 96537 54 exp a b x c log x 37 atexp brx Model Number 65 Model Definition x a b x c sar x Model Description Gunary Model R Value 0 9727346868 0 1 2 3 4 5 p Value 0 0000000000 Residual Standard Error 2 3260362984 Conversion Table ConvTable Unselected Gaugings Gaugings Unselelected x a b x c sqr x Outpu
45. OK Then Adding or Removing a User to or from a Group 1 By default new users are added to the User group but you can also add themto any other Group s 2 With the Users tab active select the user name from the Name drop down box DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Getting Started NON Users and Groups 4 Users Gre uz aes Ora Usar Haee Joe Biggs Lear Password Group Membershr Avalabie Groups Lamar of A dene Montoring Staff Monitoring Staff V Select the relevant Group from the Available Groups list Click the Add or Remove button Alternatively the Clear button will clear the user from membership of all Groups 7 4 2 2 Clearing User passwords Any member of the Admin Group can clear any User passw ord including that of the Admin User 1 2 9 4 o Click Tools Security Accounts on the main menu The Users and Groups dialogue box opens Click the Users tab Click the Name drop dow n box to view a list of existing Users then Click to select the relevant user Click the Clear Password button A confirmation dialogue appears click Yes 7 4 2 3 Adding User passwords Any user can add or change their passw ord 1 2 a Click Tools Security Change Password The Change Password dialogue box opens then To add Leave the Old Password field blank and type in a password in the New Password and Verify fields or To change an existing pa
46. Reports Status Wind Dir Av k Below is an example report output in PDF format Wind Direction Report 1 10 2009 31 10 2009 Variable Wind Dir Av Staton Weather Station STP AWS Wind Directions Seveno Datasight DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Reports 147 14 2 Report Creator Report Creator is an end user reporting solution Using Report Creator you can create your own report templates and use them in DataSight As Report Creator is also a report management tool you are then able to share your reports with other users To create anew report template 1 Click Tools Report Creator Tools un Audit Trai lf variables Security Toolbars k y Check for Update 2 The Report Explorer dialogue window appears Report Explorer Fie Edt Wew Help P ESA 33 X EM oo Al Folders Contents of All Folders 3 Gl F chders 3 Select File New Report The DataSight ReportCreator New Report window appears with the Design window open DataSight Users Manual Version 2 9 4 2013 Seveno Pty Lid Datasight ReportCreator New Report File Edt View Report Heb Data Cak Design Preview Lh 8 PERLE L Si 5 Au m ms RS DON f o eera FE A 4 38 ise mo dns due o uo dee uo ree ec 4 Select the Data tab to bring up the blank Data w indow 9 Select File New to create a new data query The New Items template w indow opens 6 C
47. Scalex Tie Labels Ticks Minor Position jv Behind Postion 0 Stat x 50 H End 75 Y ther side Horzomtal DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Now we must distribute the variables across the axes we have created Select the top Series tab between the Chart and Data tabs and select the General tab below this Chari Senes Data Tool Export Print 10 RF Help T ot ram li Bar 10RF Hry Te A Format Stack General Marks Data Source General Honzontal Asir PV Jio in Lagena Bottom v Cursor Defaut hw DateTime Depth 0 H W Auto Vertical Air REIN Lei Vaker amans e n k Percents emo n Z Sat None Assign a vertical axis to each of the variables Select each variable from the drop down menu and alter the Vertical Axis it is displayed on Chad Series Data Tooke Expert Print RH H v e Cursor Defouk F DateTime Depth 0 W Auto Vertical Axis F Custom 0 emae i Values E BONEN DateTime Percents BORRA set ez Each variable should have a different Vertical Axis When you have finished assigning axis to the variables click Close DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd E 8 2 Ea j c 2 h 10 RF Hrly Tot mm RH Hrly Avg 36 Sel Rod Hrly Awg km2 418 2008 11MQUOB 11 7 2
48. Standard The navigation menu can be used to add delete and submit standard items Each standard item has tw o values Min and Max These can both be blank If this is the case the standard item is ignored in all the Standard processes such as Datasheet analysis and during Import standard Items Variable Sulfate mgl Flourine Ni mg l pH pH units Turbidity NTU Turbidity Filtered MTU Chiorine Total Xylene DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Scientific Standards NS 20 2 Using Scientific Standards Standards can be used in several places in DataSight e Data analysis e Tabular Reports e Import How to use Standards in the Datasheet for data analysis When you create a Standard using Standard interface it will be available on the Datasheet by right clicking on the data and selecting Standards Standards w ithin the Datasheet apply the use of Stop Lighting so the Datasheet allow s you to visualise exceeding standard values in different colors It uses the color schema associated w ith Stop Lighting Datasight w ill show you all the Standards you have created before on the right click menu of Datasheet Staton CH Admin Crcut Water CH Cooler Min Wiorchop CH Crib CN Hut 2 Dragine 2 Dragkne 1 Dragine Qld Crib Rooms Qld Crb Rooms OM Crb Raoms Old Crib Raoms Old Crib Rooms Qld Crib Rooms Od Cre Reems Ok Crib Rooms Dale Tires F aaa AF L A I gm gt lt
49. Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept 2013 Seveno Pty Ltd 217 Regression Tool ns Model Number 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 Formula a b log x c x 1 5 a b log x c log x x 2 a b log x c x 2 a b log x c exp x a b log x c x 5 a b log x c log x x a b log x c x a b log x c x 1 5 a b log x c log x x 2 atb log x c x2 a b log x c exp x a b x 5 c log x x atb x 5 c x atb x4 5 c x41 5 a b x 54c log x x 2 atb x 54c x 2 a b x 5 c exp x a b log x x c x a b log x x c x 1 5 a b log x x c log x x 2 a b log x x c x 2 a b log x x c exp x a b x c x 1 5 a b x c log x x 2 a b x c exp x a b x 1 5 c log x x 2 atb x 1 54c x 2 a b x 1 5 c exp x a b log x x 2 c x 2 a b log x xA2 c exp x a b x 2 4c exp x DataSight Users Manual Version 2 9 4 Model Name Group Name Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term In
50. The Wizard Step 4 dialogue box appears DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd 18 19 20 21 22 23 24 J C Demonstration DataBase RAW Data Demo WO 2 prn Step 4 Enter information required te complete Pa sport Required Information Lene 1 Aura Level 2 Water Quality Level 3 Water Quality 1 Auditing Equipment Colector Select the appropriate Level 1 Level 2 and Level 3 fromthe drop down boxes If you have not already set these up you may type a name directly into the blank field In this case you will be asked to confirmthat you w ish to add the new Level 1 Level 2 Level 3 Click Yes The fields marked Date Time and Increment are only used if you have data which does not already have Date and Time values recorded it is the Date and Time value that makes each data record unique In this case you can use this section of the dialogue box to set default level 4 Date and Start Time values together w ith the increment at w hich the time values will be added If you wish to add an Audit Trail click the drop dow n boxes for Equipment and Collector and make a selection Note that if security has required that you log on as the current user it is your name that w ill appear as the default Collector Click Next The Wizard Step 5 dialogue box In Step 5 you can undertake simple conversions on the data during the import This feature can be used to add set offsets to data or convert da
51. Three Parameter with Max Min Three Parameter with Max Min Three Parameter with Max Min Three Parameter with Max Min Single Parameter Sigmoidally Shaped Single Parameter Sigmoidally Shaped Two Parameter Sigmoidally Shaped Two Parameter Sigmoidally Shaped Two Parameter Sigmoidally Shaped Single Term Intercept Single Term Intercept Single Term Intercept Single Term Intercept Single Term Intercept Single Term Intercept Single Term Intercept Single Term Intercept Single Term Intercept Single Term Intercept Single Term Intercept Single Term Intercept Single Term Intercept Single Term Intercept Single Term Intercept Single Term Intercept Single Term Intercept 2013 Seveno Pty Ltd Regression Tool NS Model Number 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 Formula a b x c x log x a b x c x 1 5 a b x c x 2 log x atb x c x42 5 a b x c x 3 a b x c exp x a b x4c x 5 og x a b x4c log x 2 a b x c x log x a b x c x1 5 a b x c log x a b x c log x a b x c xA 5 a b x c log x x atb x c x atb x c x41 5 a b x c log x x 2 a b x c exp x a b x log x c x 1 5 a b x log x 4c x 2 a b x log x 4 c x 2 l og x a b x log x c x 2 5 a b x log x c x 3 a b x log x c exp x a b x log x c x 5 log x atb x log x c log x 42 a b
52. Unsele ted Gaugings Gaugngs Unseltected exp asb xe c x z Dutpul DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Regression Tool NS 195 a bex 3 c expix 64 expiasb xec x 2 68 a expi x b 2 2e 35x3b5 2ecxed 2 x 2 b x c 181 a b x 2 Sec expix 128 nebe Secr O Rt Wale m Res Standard Er 10 a x I0 b x Bec x Be 8 at Seboc Beck Ted Babe Too Ged T a x Teb x beet bud amp a x G bne Sete ded 5 a k gebt dec a Jed 4 g x 4sb x Sect 2d 0 99985 0 99985 0 99985 0 99985 0 99984 0 99983 0 99933 407407 401855 399097 395772 405733 4 08097 804533 E 0 29326 amp 28072 1262511 1262511 14 03418 15 15400 16 64505 17 25384 Model Number 1195 W Model Defn ion a b x 3sc expix Model Deazripten A Value 09981769187 p value 0 0000000000 Residual Standard Error amp 2087413496 Regression Sum of Squares 2088406 3242017422 Residual Sum of Squares 6458 0581981113 Model details are displayed at the bottom of the Models w indow at the right This includes the F value p Value Standard Error and Sum of Squares information Further details can be found by clicking the Details button Graphical Display DataSight Users Manual Version 2 9 4 Users can scroll through the Models to display them on the graph Check or Un check the boxes in the gauging list and conversion table to remove these from t
53. any of the database variables This also allows conversions to be completed on the output variable selected and not change any data within the database Update database variable the output is to the database This allows the user to update and store the output in the selected output variable in the database To demonstrate the areas of the Conversion Tool window several example calculations are carried out below DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Conversion Tool 172 16 3 1 Completing a Conversion 1 Example 1 Calculating Dew Point Temperature If the user wanted to calculate Dew Point Temperature using the variables Temperature and Relative Humidity 1 Ensure the variables required for the calculation are currently being view ed within the Datasheet R Datasheet lii New Graph Staten Dae Tme Calc Cale Dry Temp Hr Avg C Humidity 56 Dew Pont C a Camp aws 19 07 2008 12 00 00 AM 1222 65 52 s Camp AWS 19 07 2008 1 00 00 AM 11 83 724 Came AWS 18 07 2008 2 00 00 AM UN 10 42 78 7 Camp aws 19 07 2008 3 00 00 am 9 92 80 Camp AWS 19 07 2008 4 00 00 AM 10 96 7 8 Camp AWS 19 07 2008 5 00 00 AM 11 74 713 camp AWS 19 07 2008 6 00 00 AM 1245 6879 Camp aws 18 07 2008 7 00 00 Au 12 33 714 camp AWS 19 07 2008 8 00 00 AM 12 68 65 56 Camp AWS 1 07 2008 5 00 00 AM 14 11 58 51 Camp AWS 18 07 2
54. appears Name your graph and click Save A Saved Graph Properties file is created w ith any saved graph recording the creator and the creation date If the saved graph is subsequently modified the Saved Graph Properties w ill be updated to show the relevant user and date it w as last modified The Graph Properties w ill also show any tasks that are scheduled to run using that graph 4 To view the Saved Graph Properties right click on the name of the saved graph and select Properties Properties Precerties Name Daiy sensn krel Created By Admin Created Date 11 04 2008 10 10 AM Modified By Admin Modified Date 11 04 2000 10 15AM Em lin E UE l ext Run Tien Last Run Time Deleting a graph 1 Right click on the saved graph 2 Select Delete Be you attempt to delete a graph with a task assigned you will get a warning and a request for confirmation Deleting the graph will delete the task assigned to it To use a saved Graph 1 With the Data List tab selected click Hon My Data to expand your list of Level 2 You can create graphs at DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Graphs 117 the Level 2 Level 3 or Level 4 level 2 Double click to select a saved graph in Saved Views and the Select Filters dialogue box will appear Select Filters What filters do you want to apply to this graph v Use fibers that were saved with this graph O Use fibers that have put been selected o J cancer
55. apply any of these Descriptors last n year s last n month s last n w eek s last n day s last calendar year last calendar month last calendar day and or Time to which you can then apply any of these Descriptors last n hour s last n minute s last n second s Relative Time values are alw ays relative to the current time day month and year on which you create or open a saved graph Bracket Options Bracket options are relevant w here you w ant to impose more than 1 condition Option Meaning all returns data w here all the conditions are true any returns data w here any of the conditions are true none returns data w here none of the conditions are true not all returns data w hen not all of the conditions are true To impose a bracket 1 Click on the blue highlighted option on the bracket line and choose from the drop down list Al Serias e Choose records where gf of the folowing apply T Level ds esualso EE 2 Level i ii pouil lo E any nore 3 Levels m esualic j not all 4 Dae ecualig Vibe lt Chck have t add new condihion gt dH 2 The Datasheet Graph w ill update automatically n you have selected the Graph tab you can choose to Filter data or all plotted data series by clicking either the Single Series or All Series radio button If you click Single series then select your series name from the Series drop menu DataSight Users Manual Version 2 9
56. data solution Import datasets in common formats like spreadsheets comma delimited or text files or even directly from environmental sensors or probes 7 Create and send databases to other users Receive and merge data from other users Profile data visually w ith full control over formatting Interrogate data by filtering Spend the next 5 minutes on the DataSight Quick Tour and check out how DataSight w orks DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Quick Tour 5 1 Quick Tour Layout The main DataSight window can be divided into 5 panels The three panels to the left contain Data List Saved Views and Field List for the database The main panel contains two tabs allow ing you to view the Datasheet and Graph and also a saved report The bottom panel contains the filters DataSight P 7 ae He See A Pregew E import fees lea KE Tabular Reports EJ MDE di Fa EDI veisanos1 d Howe Graph P Bow D Sewer Mondonng F be Ste 1 n oTo T 207 1854 tz Saved Views e 3 Graghs EE E Datasheets 12 00 PM DateTime ep Varables DateTime E AA KPE E Date E E ETA mes v ase Adusted Level mj O GET records where of the folowing apply Evag mm ror v Humd amp y 34 All mk ma n Connected to C Demonsiraton Datadase DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Quick Tour os Data List DataSight come
57. directory of the Options dialogue box 3 Uncheck the Enable Auto Update checkbox and click OK To update on demand 1 Click Tools on the main menu 2 Select Check for Update and follow the onscreen instructions Datasight Fie Edit Toots Help New E AuditTrad lp Variables Security Toobars DataSight Users Manual Version 2 9 4 2013 Seveno Pty Lid What is new in DataSight version 2 4 What is new in DataSight version 2 9 DataSight 2 9 nas the same user interface as earlier versions but it has plenty of new features Itis even more reliable and robust than before Here is the list of the exciting new features Maps DataSight has an in built link to Google Maps allow ing users to view station locations or important sites w ithin the database Regression Analysis tool for statistical analysis of data and the creation of rating tables and applying rating tables to existing data Enterprise edition only Flagging feature assign user defined flags to specific data datasets including a freehand graphical interf ace Enterprise edition only This feature has replaced the Data Quality feature included in earlier versions of DataSight Interpolation Tool provides users w ith the ability to construct new data points w ithin the range of a discrete set of know n data points This graphical curve fitting feature expands on DataSight s existing calculations and analysis capability allow ing simple linear
58. een points If data is above or below the values specified in the table the slope of the line is continued and the data calculated Extreme care has been taken to ensure the accuracy of the data How ever w e do recommend that the user conducts a review of the data to ensure the conversion is valid for their specific circumstance Conv ableForm Fie Edt New pd Save Delete ux Transpose Axis Logarithenic Mg Close Conversion Table Conversion Table Graph v X Depth Y Discharge Depth Discharge sl 19 5 I25 25 1 27 3 20 9 M 37 3 41 45 xa Hote The Conversi n Table assumes a straight ine nterpolation from the last bwo ports for data that is above and below the points expressed in the table This means that negative values can be created if the data falis below the origin Therefore for most stream flow rabng tables 4 second point should be inserted before the origin such as 4 and 0 The table wil then assume thal al data below zero and past 2 will have a resul of zero Conversion Tool Overview The Conversion Tool The DataSight Conversions tool is designed to enable the user to manipulate the data that is within DataSight The Conversions are linked directly to the Datasheet w ithin DataSight Therefore only data that can be seen within the Datasheet is available for manipulation by the Conversion tool This can be across multiple stations and multiple variables By using data that is only in the Datashe
59. entering the Name Organisation and User Name details You can also edit and or delete current equipment or people within the Audit Trail The person and equipment information is now available to attach to data when it is being imported and when data is being entered into a datasheet using Manual Data Entry DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Setting up the DataSight Database 5 Audit Trail Setup L Calibration The Details button next to each of the Equipment can be used to add any calibration details required for the equipment such as servicing and maintenance along with any comments Click the Details button and an Equipment Details window will open allowing you to edit equipment model and serial number add and delete calibration dates and enter any comments related to the equipment For example add a link to the equipment manufacturers internet address once linked press Ctrl Left mouse click to follow the link Equipment Details Regular maintenance of this model required Take Phillips head screwdrreer and hammer Semice Manual http are panaphonic s com au Contact Ph 0455 333 333 When data is imported you can attach an audit trail w hich records the Equipment used to acquire the data and the Person responsible for collecting it The Audit Trail details are recorded and may be view ed as Level 4 Properties against the sample event Dat
60. etc Conversions New Conversion Set File New EY Open save Sx Delete Tig Add variable ly Delete Variable MJ Close AP Conversion Variables iii Conversion Graph El Conversion Data Conversion Graph 2641 1997 26 03 1998 24 07 1998 21 11 1998 21 03 1099 19 07 1999 161 1 1995 15 02 2000 Oates Tene C USED Quia DU interpolate with master variable Time shining Start Offset End Offset Formula gt Output value Output variable Type Total Records 75 CurrentRecord 0 1 DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Conversion Tool NO The Conversion Tool also includes a Conversion Data area w hich displays the data in grid format Conversions Mew Conversion Set LJ New E Open bises x oe Mi aaa vert dig Delete Variable rre TT 3 19 09 1957 9 00 00 AI 3 229 997 5 00 00 AI A 80 1987 9 00 00 AM A 36 10 1897 9 00 00 Al 3 8111597 9 00 00 AM 3 13 11 1997 9 00 00 Al 3 15 12 1997 9 00 00 AI 3 16 01 1998 9 00 00 AI alzan somwa 32 28 01 1898 00 00 Al 3 61021996 9 00 00 AM DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Conversion Tool 162 16 2 Conversion tables can also be used There is no limit to the number of points Betw een each point the conversion tool uses a linear interpolation to calculate data betw
61. extension are comma separated value files A csv file is one in which each value in the cells of a table row is delimited by and separated from the next value by a comma The beginning of a row is indicated by a new line character Delimited Delimited files use a special text character to separate each data value in a record Typically the delimiter is either a tab or acomma but any character may be used The field delimiter denotes the beginning and ending of a data field e g 5123450 with a semi colon as the field delimiter identifies 123450 as the data value in that field dependent variable A variable whose value is determined by the value of an independent variable For example in a graph of temperature at different depths for a water body temperature is the dependent variable Any depth from the surface to the bottom can be chosen to see what the corresponding temperature at that depth is By convention a dependent variable is plotted on the y axis but w ith DataSight you can choose the x axis if you wish dsd A single zipped DataSight file containing all the database tables This file format is suitable for sharing or emailing databases Field List panel The bottom left screen panel displaying the available data variables in your DataSight database Fixed width A fixed width file contains data in columns w here each column is a certain width and all values in that column are the same width Footer Footers are fie
62. functions are defined by default Full list of built in math functions Functions with single parameters SQR Square function which can be used as SQR X SIN Sinus function which can be used as SIN X X is a real type expression Sin returns the sine of the angle X in radians DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Conversion Tool 16s COS Cosinus function which can be used as COS X X is a real type expression COS returns the cosine of the angle X in radians ATAN Arc Tangent function w hich can be used as ATAN X SINH Sinus Hyperbolic function w hich can be used as SINH X COSH Cosinus Hyperbolic function w hich can be used as COSH X COTAN which can be used as COTAN X TAN which can be used as TAN X EXP which can be used as EXP X LN natural log w hich can be used as LN X LOG 10 based log w hich can be used as LOG X SQRT which can be used as SQRT X ABS absolute value w hich can be used as ABS X SIGN SIGN X returns 1 if X 0 1 if X20 O if X20 it can be used as SQR X TRUNC Discards the fractional part of a number e g TRUNC 3 2 is 3 TRUNC 3 2 is 3 CEIL CEIL 3 2 3 CEIL 3 2 4 FLOOR FLOOR 3 2 4 FLOOR 3 2 3 Functions that take two parameters are INTPOW The INTPOW function raises Base to an integral pow er INTPOW 2 3 8 Note that result of INTPOW 2 3 4 8 as well POW The Pow er function raises Base to any pow er
63. ignored in the Import process 10 Click the Next button The Import Wizard Step 2 Dialogue box appears LJ C Demonstration DataBase RAW Data Demo WO 2 xls 4 i2 x Step 2 Mas ngul fields to DataSigh feiss z Piwo 20772003 s0a49 Station 1 27 05 1988 9 00 08 Staten 1 27 08 1999 9 00 85 Station 1 20 11 2000 9 01 31 Station 1 19 11 2001 8 00 04 Station 1 15 01 2003 9 03 06 11 The Step 2 Dialogue box is divided into upper and low er panels In the upper panel you can view and filter your existing data fields In the low er panel you map those input fields to your DataSight database fields This combination of filtering and mapping functionality means that you can accurately define and import all or a DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd subset of input data values Filtering input values Filtering is a quick and easy way to define then import a subset of data You can use filtering to import only the row s that meet the criteria you specify for a particular column or columns Click at the head of any data column to display a list of filter options Standard options are All Custom Blanks and Non Blanks The other options are any of the unique data values within that column Note that the Blanks and Non Blanks options are available only if the column you w ant to filter contains a blank cell Use To return All allrows Custom all row s meeting the criteria you specify for
64. input field name s already present in the table and use standard mathematical nomenclature 28 Step 6 offers the chance to select a Scientific Standard to check w hether imported data is within the standard limits or not If you wish to use a Standard check the box and select a Standard from the list Otherw ise click Ne xt 43 CADS Data RAW Datalb txt Step 6 Sect standard Scientific Standards e Use Standards Abra lan Drnkng Water Guidelines 29 Click the Finish button If your import is successful a confirmation information box will display Alternatively an Import Error Log will be displayed with appropriate error messages and options to Save Print Preview Go Back Continue or Abort the Import P When importing data if the first line in the file is Data and not column header leave First Title Line as 0 This ensures that the Input Fields as in the example above are named as Field 1 2 3 4 etc f numerical values are in the Input Fields your calculation w ill be incorrect The user can also use multiple fields to calculate a new variable For example Flow Total Dissolved Solids to give an instantaneous discharge of TDS P In Step 4 the user selects the Level 3 that the data is to be imported too The mapping of Level 3 allow s DataSight to link and save the formulas used for that specific site The Formula area is populated w ith the last used formula for that specific site This increases the speed of impo
65. only the rows containing non blank data values in that column Unique data value all the row s containing the specified data value in that column Custom filtering using specified criteria Click at the head of any data column and select Custom The custom filter dialogue box appears Custom Filter Show roves biene Click the first arrow to display the drop dow n menu options for filtering either numeric and text values Select a filter condition then enter an appropriate value in the box on the right If you need to find values that share some characters w hether text or numeric use the ike or not like options in conjunction with either or 96 Use To stand in for underscore any single character e eg 8 will find 81 82 83 8B etc e eg 8 willfind 845 87A etc e eg T wil find TP TN T9 etc percent any number of character e eg 8 will find 81 82456 8B etc e eg fish e will find fish fished fishing fishA 1 etc To add another criteria click AND or OR and repeat the previous step 12 In the Step 2 Dialogue box low er panel DataSight w ill attempt to recognize the fixed w idth parameters of your input file but you w ill need to review and adjust these Click in a row of the Start column and type the start position of the first character relating to that Input Field of data Click in the corresponding W idth column and type the number of characters that comprise the w
66. ow Multiple variables can be used in the calculations Only stations variables and actual data that are displayed in the DataSight Datasheet are accessible 3 Conversions New Conversion Set Eie A index 1 838 ms i Km AUN T Conversion table Conrarsion tpo WIEN interpolate with master variable Time shifting Start Offset 0 End Offset e Total Records am Current Record 0 838 Nem Open p save M Delete 11g Add variable iig Delete variable B cese lj Conversion Variables Mu Conversion Graph E Conversion Data index Bs Kw Ku Use conversion table Conversion table teni Mul Output E Formula gt Output value Output variable Output station s Same with Master Variahle o Update conversion form variable Update database variable Once you have completed the conversion you can Save the Set located at the top of the screen if you wish to use this specific conversion again The conversion set can be stored on the netw ork allow ing any other users to use your same conversion set DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Conversion Tool 160 The Conversions also has a conversion data graph that w ill display the data you have converted against the original data You can also access all of the standard graphing options by right clicking your mouse within the graph area This includes exporting the graph as a JPG image
67. representative low flows and floods high flows for a river course a hydrologist w ill analyse the frequency of daily flows in the form of a flow duration curve A flow duration curve is a plot of discharge vs amount of time that a certain discharge w as exceeded For most studies the data needed for this analysis is the daily average flow the average discharge or flow for each day hence this is used in this example Within the Datasheet ensure you are view ing the a z r Sra variables required for the calculation a m Parier Fem nici n C Flow and two variables to output Daily Average M To CL TT Flow and Percent of time exceeded qmm ELE d E cud u D i 2450 1 q AM u o 2M wea fe a To calculate the Daily average flow Open the conversion tool Select Master Variable A 140 Flow Enter the formula dailyavgA PN EH I k AJ dut Kyje V Select the output variable Daily Avg Flow Check the Update database variable box and the Update conversion form variable box and click m ina Update data Once the conversion has run you will have the Daily Average Flowfor the river and you can calculate the Percent of time exceeded Within the conversion tool select the Daily Average Flow variable you have just populated w ith the previous calculation Enter the follow ing formula RankDSCA n 1 100 RankDSC is used in the formula to sort rank the average daily dis
68. restart Restart application after a period of Restart after 1 hour eMail Server SMTP Details Server Mame Server Port User Mame User Password 10 Choose the Saved Graph Datasheet Calculation or Report from the Item Name list This defines the filter conditions that you are going to use for the task Important For Task Type Reports Saved Reports must have an associated Saved Datasheet or Saved Graph which contains the filter settings to be applied to the report Once you have selected the Report select the associated datasheet or graph fromthe Use Filter From drop down list ltem Mame Rainfall M Use Filter From AMY S Monthly Data M Copy Filter Criteria Into This T ask In the example above the filter applied to the saved AWS Monthly Data graph or datasheet w ill be applied to the DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Scheduler ss report Rainfall For Task Type Calculations Saved Calculations must have associated filter settings to be applied to the report These can be taken from a Saved Datasheet Once you have selected the Calculation select the associated Datasheet fromthe Use Filter From drop dow n list 11 Set the date and time that you wish the report to run 12 Set the Freguency Recurrence and Regeneration options 13 Click OK Edit a task 1 Click Tools Scheduler 2 The Scheduled Tasks dialogue box appears 3 Right click on the task and sel
69. sites Double click on any level to include any or all stations w ithin that level in the selected sites list Use to clear sites from the selected sites list Order the site list using the and e keys 6 Click Next The Tabular Report Wizard Variables dialogue window appears DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd 37 DataSight Labular Report Wizard Variables Select Vanes Variable List Selected Variables Adusied Level dur tar Sewer Level Sewer O Sol Had Z Select your variables by either double clicking on individual variables or by highlighting variables and using the arrow keys 8 Click Next The Tabular Report Wizard Summary Types dialogue window appears Ep DataSight Tabular Report Wizard Summary Types Seed functions and report summary types ip Varabletame Report Type Ste Rural Catchment 1 Rainfal Station Means Duma _ Cancel 9 Customise the the Report Type by selecting either a Cumulative or Mean data report fromthe drop down menus Sites can also be ignored at this point by removing the tick button in the Include column 10 Click Next The Tabular Report Wizard Output Device dialogue window appears DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd t9 DataSight Tabular Report Wizard Ouput Device Sect ona of tha output caters Sens E SUE MUS xc Celaten Staton List d Show preview screen for each report v Show print dalog Sav
70. spline interpolation along w ith cubic spline and Akima spline to perform interpolation operations w ith ease Scheduler a tool for scheduling reports graphs calculations and datasheets New features include automated emailing and a scheduled task log to review completed scheduled tasks Active property enables users to one click operation to enable and disable tasks Audit Trail provides very efficient audit logging for Import Conversion Data Quality data editing and manual data entry Enterprise edition only The Audit Trail has an additional Calibration tool w hich allow s for instrument and equipment calibration entries Automated raw data storage on Import Enterprise only Control Documents allow s storage of raw data files reports PDF files site documentation images videos maps and much more Accessible by every DataSight user this provides an excellent document management system for your databases DataSight reporting tools Tabular Report Wizard provides an extensive range of tabular reports w ithin a few quick and easy steps Report Creator is available for both Desktop and Enterprise versions as a built in tool DataSight Conversion Tool has been re engineered and redesigned from scratch as a built in tool Look up Conversion Tables provide look up conversion in the conversion tool Scientific Standards to monitor and report on data quality Be notified w hen data is not complying w ith Scientific Standards Improved
71. that column Blanks only the rows containing blank data values in that column Non Blanks only the rows containing non blank data values in that column Unique data value all the row s containing the specified data value in that column Custom filtering using specified criteria Click at the head of any data column and select Custom The custom filter dialogue box appears Custom Filter Show roves where Click the first arrow to display the drop dow n menu options for filtering either numeric and text values Select a filter condition then enter an appropriate value in the box on the right If you need to find values that share some characters w hether text or numeric use the ike or not like options in conjunction with either or 96 Use To stand in for underscore any single character e e g 8 will find 81 82 83 8B etc e e g 8 willfind 845 87A etc e eg T willfind TP TN T3 etc percent any number of character e e g 8 will find 81 82456 8B etc e e g fish will find fish fished fishing fishA1 etc To add another criteria click AND or OR and repeat the previous step 12 In the Step 2 Dialogue box low er panel you will map your input fields to your DataSight database fields DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd J C Demonstration DataBaseiRAW Data Demo WO 2 xls step 2 Map naut fields to DataSight Grida Siabon oo Daie w Tre v pH
72. the Datasheet panel Check uncheck the Show Summary checkbox to default the display of a statistical summary on the Datasheet Check uncheck the Show Navigator checkbox to default the display of a statistical summary on the Datasheet Stop Lighting Flags Change the colour of the cell background in a Datasheet to highlight data that is less than the Minimum Value listed for that variable greater than the Maximum Value listed for that variable equal to the Goal Value listed for that variable These Stop Lighting colour changes may be applied only to the text in the cells if preferred Enabling the use of Flags in the Datasheet allow s the user to assign flags to specific data w hen view ed in the Datasheet w indow DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Setting up the DataSight Database Views Create SQL Views for Saved Datasheet Views DataSight creates SQL database tables for Saved DataSheets allow s integration and referencing from other softw are such as Maplnfo Create Numeric SQL Views for Saved Datasheet Views DataSight creates SQL database tables w ith numeric version of text variables again for integration w ith other softw are s These features are only available in the DataSight Enterprise Edition Graph ES Options Pale 2 Options Filters E General j Use filters that were saved with this graph Li Import Use filters that have just been selected FS Da
73. the option of overw riting the existing database You can change the name of the folder by highlighting and typing over a new name If the folder does not already exist then one w ill be automatically created If you w ant to email the database then name your data and check the Send Data by Email checkbox 5 If you also w ant to export the database in MS Access format version 2000 or later then check the Save as MS Access checkbox in then low er panel Then in the low er panel Save To Location field click LJ The Save As dialogue box appears Navigate to the folder in w hich you w ant to save the MS Access database Click in the File Name field and name the file Click Save Click Next The Export Wizard Select Row s dialogue box appears Select the data you w ant to transfer by checking the appropriate checkboxes and click Next F xport Wizard Select Rows Sec ihe ga lo be exported E A Catchment 1 O Ranta Staten x J Streams Id water Quality 8 Select any or all variables you must include Date and Time and click Finish DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd 10 5 J Export Wizard Select Variables SEC he variables lo be exported Vanacies lp Dave lp Tee v ip Sever Level m O ip Viajar Level em Cip RF mm v ip Sewer Q mi ip comments 1p vaso Dip pH pH m m 9 The Transfer Progress dialogue box appears 10 If you had earlier checked the Send Data by Email
74. 008 11 0 2008 11 12 2008 11 16 2008 11 19 2008 11 22 2008 11 25 0008 11 28 2008 DateTime DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Final presentation of the graph requires editing other attributes such as Legend Title Axis labels and inserting separation lines to clearly identify variables Legend Open the Graph Properties window Select the Chart tab select the Legend tab select the Position tab Change the position of the Legend to Bottom Chart Series Data Toole Export Print Seres General Asis Tiles Legend Panel Pagng Walk 20 Style Position Symbol Format Test Gradient Shadow Pozn Rese Chat C Lett C Righ Magre 0 O Custom Left Tox From here you can also edit other Legend properties such as the Text style and Framing and Shadow effects Title Select the Titles tab and enter a Title SubTitle Footer Chad Series Data Tool Export Print Seres General Asis Titles Legend Panel Pagng Walk 3 Style Postion Format Text Gradient Shadow e Visible F dust Frame C Let Cortes C Bight Text Darton Automates Weather Station Axis Select the Axis tab select the Title tab and untick the Visible checkbox DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Graphs 131 Chad Seres Data Tool Expert Print Seres General Avis Titles Legend Panel
75. 008 10 00 00 AM 15 8 47 42 camp aws 19 07 2008 11 00 00 AM 18 25 37 7 E k 2 Right click on the datasheet and open the Conversion w indow 3 Select Master Variable A Temperature by selecting the Level and Variable from the populated drop down lists Weather Stations Camp AWS Variable Ory Temp Hr Avg C alekTime 19 07 2008 1 00 00 Au Index 719 STIS A m 11 830 Kkali AK m 11 830 Use conversion table 4 Add asecond Variable by selecting Add Variable in the toolbar Mew 7 Open 51 Save X Delete lg Add Variable kg Delete Variable Help Bl Close 5 Select Variable B Relative Humidity DataSight Users Manual Version 2 9 4 2013 Seveno Pty Lid Conversion Tool 173 Weather Stations Camp AWS Variable Humidity 56 Dats Tima 15 07 2008 Index 5719 I 5719 E m 65 4520 Ke i B Km 55520 Use conversion table Conversion table Co nversion type 6 Below the Output area of the Conversion window enter the Formula required to complete the calculation Output Formula gt 237 7 17 27 A 237 7 A In BI100 9 F 17 27 17 274 237 7 A 1 8 100 Output value 0 x 5719 Output variable i Update conversion form variable Update database variable UE Update data 7 Select the Output variable Output variable Dew Point C M 8 The user can then select either Update conversion form variable or Update database v
76. 008 11 28 2008 1zn 2008 Date Time A Sob Red riy Avg Aim Temp Hrly Avg Degrees C Wind Rose Creating a wind rose from weather station data is a great way to get a succinct view of how wind speed and direction are typically distributed at a particular location When graphing a wind rose in DataSight the wind rose is presented in a circular format It shows the DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Graphs 133 velocity of winds blowing from particular directions The distribution of each point or line around the circle is related to the velocity that the wind blows from a particular direction It is also possible to create a Wind Direction Report in DataSight This report displays a wind rose showing the frequency of winds blowing from particular directions The length of each spoke around the circle is related to the frequency of time that the wind blows from a particular direction See Reports for further details 1 Within the DataSight graphing area drag and drop the Wind Direction variable on to the x axis horizontal axis 2 Drag Wind Velocity on to the y axis vertical axis DataSight will plot this data as a line graph as default Mini Sell dr dw mds a 40 e 9 160 120 140 160 160 00 zx 240 60 280 300 220 340 Wind Dir Hr Av 3 Right click on Wind Velocity in the the legend and select Advanced Options Rename Series A D
77. 13 Seveno Pty Ltd Viewing Editing Data 105 11 2 Manual Data Entry MDE To edit data using the Manual Data Entry form 1 Highlight the selected Level 4 data point on the Datasheet Right click on the Datasheet and select Edit Record with MDE Datasheet ji New Graph station Dale Time SewerLevel Sewerd gt Sewer Ste 1 07 1995 12 00 00 AM 0 077 6009 Sewer Ste 1 071189 12 05 00 AM 0 07 0 008 b Sewer Ste 1 407 1994 12 15 00 AM 0 074 0 008 m Sewer Ste 1 407 1534 12 20 00 AM 0 07 0 007 Sewer Ste 1 407 1895 12 55 00 AM 0 072 8 007 Sewer Ste 1 5 07 1834 1 00 00 AM 0 055 0 007 ji Sewer Ste 1 3 07 1594 1 05 00 AM 0 064 0006 Step Lighting Sewer Ste 1 407 1994 1 10 00 AM 0 059 0 007 Bert b ven AE A 0 09 0 01 print mE hy A E Preven Fiter oor 2 The Manual Data Entry Formis opened and is populated w ith the variables that are displayed within the Datasheet DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Viewing Editing Data 107 Create Level 4 data if Eis not already created v Update the Level 4 information if ls already created V anale 140 m lsec pH 3 The user can change the Site and move the data to another monitoring site or just modify the variable values as required Click Save 4 The user also can create Manual Data Entry Templates To select var
78. 2017N081974408 We now have part of a conversion table for determining TSS based on Discharge but still need the low er end of the table 6 Click the Analyse button and select All Groups from the Regression Groups list This w ill complete a regression analysis of the data using all available models in DataSight 7 ff you scroll through the Regression Models to the right of the window you can view the model graphically in the Regression Graph area It displays which models fit the existing data points along with the Output Table w e began creating in the previous steps Regression Graph Confidence Models Analyse Results Output Table Water Quality Mode Model Definition R Value Res Standard Er 204 10 atx 10 b x 9 c x 8 0 99712 0 90881 19 9 a x 9 b x B c x 7 d 0 99464 1 20671 184 8 a x B b x 7 c x 6 d 0 99133 1 49540 171 7 a x 7 b x 6 c x 5 d 0 98103 2 15894 16 6 a x 6 b x 5 c x 4 d 0 97401 2 46870 154 5 a x 5 b x 4 0 x 3 d 0 97397 2 41635 144 65 x a b x c sqr x 0 97273 2 32604 134 69 a exp x b 2 2 c 0 96931 2 46777 12 64 exp a b x c x 2 0 96931 2 46777 14 4 a x 4 b x 3 c x 2 d 0 96819 2 61494 10 T 67 x a exp b c x 0 96677 2 56781 ol 15 a b log x c log x 2 0 96537 2 78709 al 54 exp a b x c log x 2 63976 7 i 37 a exp b x ef FS PE sf Model Number 6 4 A
79. 3 Seveno Pty Ltd Regression Tool 213 Model Number 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 Formula 1 a b x4c x 2 exp a b x c log x atb x c x42 a 1 b x c x 2 cos x a sin x a 1 exp a x 2 exp a x 2 a cos x b sin x x atb x c x2 a b cos x c sin x exp atb x c x2 X a b x c sqr x a x b exp c x x a exp b c x a x b 1 x c a exp x b 2 2 c 2 1 exp x a exp x a 1 exp a x b 1 exp a b x exp exp a b x a b x log x ES a b x22 a b x 2 log x a b x 2 5 a b x 3 a b exp x a b x 5 log x a b log x 2 a b x log x a b x 5 a b x 5 a b log x x atb x 1 5 a b log x x 2 a b x 2 a b exp x DataSight Users Manual Version 2 9 4 Model Name Reciprocal Quadratic Holliday Vapor Pressure Model Heat Capacity Model Trigonometric Trigonometric ll Gunary Model Beta Distribution Model Gaussian Distribution Model Group Name Three Parameter Convex Concave Three Parameter Convex Concave Three Parameter Convex Concave Three Parameter Convex Concave Single Parameter with Max Min Single Parameter with Max Min Single Parameter with Max Min Single Parameter with Max Min Two Parameter with Max Min Three Para meter with Max Min Three Parameter with Max Min Three Parameter with Max Min Three Parameter with Max Min
80. 53 15 Scheduler DataSight has a facility for generating a report based on an existing saved graph datasheet calculation or report The output can be in a pdf Adobe Acrobat RTF HTML JPG or xls Microsoft Excel datasheet format The user also has the option to email the output file to a number of recipients To set up scheduled email reporting please revisit the Options section under Setting up the DataSight Database Reports can be regenerated periodically w ith the same file name or DataSight can automatically increment file names such as Temp 001 jpg Temp 002 jpg Once you have set the appropriate filters on your data and saved the results as a Graph or Datasheet 1 Click Tools Scheduler Tools Help Conversion Tables Regressions g Control Documents QS Report Creator Scheduler d Scheduler Scheduler Log 2 The Scheduled Tasks dialogue box will appear ES Scheduled Tasks File F New Bo Edit gt lt Delete Scheduler Log Close Schedule Next Run Time Last Run Time Add Scheduled Task Weather station daily graph Never 15122011 11 28 AM West Creek Q 12 01 2012 8 44 AM 12 01 2012 9 43 AM South Creek Q 12 01 2012 9 44 AM 12 01 2012 9 43 AM WL Report 12 01 2012 9 44 AM 12 01 2012 9 42 AM RF Report 30 09 2011 6 31 PM 30 09 2011 6 21 PM DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Scheduler ssa 15 1 Scheduling Tasks Add a Task 1 Click the New icon on the men
81. 6 Setting properties 117 Toolbar 36 Usingsaved 116 Viewing 115 Zooming 115 Graphing Variables 121 Group Adding or Maintaining 39 H Hourly 28 If you are using DataSight Lite 33 Importing Data 74 Default formats 61 Excel files 74 Fixed width files 88 Issues 245 Other delimited files 81 Spreadsheet files 74 Js JPG 117 2013 Seveno Pty Ltd Data List 34 y L y Datasheet 34 Level 1 Field List 34 Adding or deleting 44 Filters 34 Level 2 Graph 34 Adding or deleting 44 Saved Views 34 Level 3 Passw ord Adding or deleting 44 Adding 40 Properties 52 Clearing 40 Level 4 PDF 28 Adding or deleting 44 Permissions Properties 57 Setting 40 Look and feel 61 Plug In Modules 244 Look Up Tables 191 192 Add a Pugin 244 M Preferences 61 Print Main Window Layout 34 Setup 35 Manual Data Entry 95 106 Printing Map 69 71 Issues 245 Mapping 69 71 Properties Mapping Fields 74 Graph 117 MDE 95 i Q Means 28 Menu Bar and Datasight Toolbar 35 Quick Tour 6 Merge Quick Tour Database Variables 9 Issues 247 Quick Tour Exporting Data 19 Merging a database 97 Quick Tour Graphs 23 Merging variables 47 Quick Tour Importing Data 10 Models Quick Tour Layout 7 Regression Models 211 Quick Tour Merge 21 Montly 28 Quick Tour Notes 32 Moving data 101 Quick Tour Reports 28 O R Opening a database 43 Rank 180 Operators Rating Table 178 Analytic Operators 182 Conversion Table 194 203 Logical Operators 182 Receiving a
82. 77836658672391 95060595555605 862702129046358 855814855590722 Within the Analyse Results w indow that the user can begin to create new Conversion Tables based on the results of the Regression Analysis Simply select the lines you w ish to use in your new Conversion Table Then right click on the table and select Copy Selected into Output Then when you view the Output Table tab you can see the new ly created Conversion Table data This data w ill also be displayed on the graph DataSight Users Manual Version 2 9 4 x 0 1 83634394455554 9 55514855590722 35 9170825697382 101 978815815126 3 45454546454848 166 10265161604 431313131312131 339 771622643437 4 4959595555596 416 950795471061 544444444444444 696 082165180308 8 15151515151515 949 705750146085 amp T1717171 HT 1128 1500708485 1 7 1153 06273185578 Select Save from the toolbar to save the rating table 2013 Seveno Pty Ltd Regression Tool 2 18 4 Rating Table Name Weir A Jan Feb 1 03 2012 Labels Y Flow Period of Applicability Date from 1 01 2012 00 00 Date to 29 02 2012 23 59 EJE V Assign to the Level 3 that conversion table has been assigned to V Update existing data Rating Tabie ses This w ill open the Save Rating Table dialog window X Depth Enter the name of the new Rating Table Enter the X and Y axis Labels Enter the
83. 8 07 2007 9 00 00 AM The import value for Aluminium Total mg l 2 05 is greater than Standard value 0 25 DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Scientific Standards 2 18 07 2007 9 00 00 AM The import value for Aluminium Total mg l 9 88 is greater than Standard value 0 25 17 08 2007 9 00 00 AM The import value for Aluminium Total mg l 1 451 is greater than Standard value 0 25 17 08 2007 9 00 00 AM The import value for Aluminium Total mg l 0 3959 is greater than Standard value 0 25 DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd 21 Flags DataSight Flags can be used to assign and visually identify data for quality coding or quality assurance purposes Flags are user defined and database specific and can be used to clearly label data by colouring the row of data 21 1 Setting Up Flags The user can access Flags va the Settings menu File L New ffl Delete Application Flags Close i14 gt nx By default DataSight sets up several Flags for use within the database The user can elect to edit these or delete them to create their own user defined flagging system Create a new Fla 1 To create a new flag simply click the New button on the Flags toolbar New Ji Delete Application Flags Close Background Color 2 Enter the flag Description in the blank space th
84. Bank WERB Starting bank 7 Ascending Order Measurement Quality E Measurement Unds ut Collector Gauging Personnel Calculated Properties Manual Override Mean Stal Gauge Height Tetal Area Mean Velocity Total Discharge A new Gauging ID will be provided after saving the Gauging Gauging ID s are automatically created by Datasight and cannot be edited or changed by the user and ID s for deleted Gaugings cannot be used again Calculated properties will show the values for Mean Staff Gauge Height Total Area Mean Velocity and Total Discharge for the Gauging These values w ill be refreshed after adding or editing Chainage measurements and are display ed in the same measurement units as the data being entered There is also an option to enter these values manually by clicking the Manual Override checkbox EJ Chainages To add new chainages or edit chainages click Chainages button DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd O Chainages File Edit New fl Delete Ed Observations Bg Close Chainages Value X RiverDepth Bank Mean Velocity Area Discharge ko o WERB 0 0000 0 0000 0 0000 be px f e enm us pz pe p ma ow oa p 4 E o o DHT s lt o 0m 028 re pm o us e pz e oe 0 1140 0 1360 0 1250 0 1200 eic on mann s382822 8322582528 i JEJE Eg 8 88 HALT All the chainages can be seen in the Chainages form To add new Chai
85. D AM 50044 10 00 AM Date Tre DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Conversion Tool ee Conversion Data The Conversion Data displays the both the raw and the calculated data This is only available after the conversion has been undertaken LOT eS hos gt Hew LONyersi0mn sh 16 10 1997 9 00 00 AI 3 8 11 1997 9 00 00 AM 33 1 1997 9 00 00 Al 3 IUD E 3 5 18 12 1997 9 00 00 Al 3 16 01 1998 9 00 00 Al 3 23 01 1998 9 00 00 AI c M eee E 3 20001998 se Al DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Conversion Tool 169 16 3 Using the Conversion Tool Using the Conversion Tool DataSight Conversion tool is a free hand calculation tool for the manipulation and calculation of data Before progressing please read the Conversion Tool Overview If you have used DataSight you will be familiar w ith the required fields w ithin the calculation tool The first step in using the tool is to use DataSight to filter and display the data that you w ish to use in the calculations The data MUST be displayed in the DataSight Datasheet It is possible to have several stations displayed in the Datasheet so they are all available for calculations Once you have filtered your data to access the Conversions right click w ithin the DataSight Datasheet and select Conversions X Delete Record Edit Record with MDE 75 Data Quality Couma Settings k Summary Panel Navig
86. DataSight Users Manual Version 2 9 4 Id et gt OLIC p 0 MES 1 O TOTO TO FIO i 1494 0 000 FO FB i FOOT 0000011110040 JALOL OOO 04140410 E A 100 B Seveno Pty Lid Canberra ACT Seveno Pty Lid Printed May 2013 in Canberra ACT Contents Table of Contents Copyright Notice m N y O 0 NO U AGN gt G A W N Ono MO G A DataSight Users Manual Version 2 9 4 Your feedback Get the the latest version What is new in DataSight version 2 9 Guick Tour Quick Tour Layout Quick Tour Database Variables Quick Tour Importing Data Quick Tour Exporting Data Quick Tour Merge Quick Tour Graphs Quick Tour Reports Quick Tour Notes Using this Guide Who this Help file is for If you are using DataSight Lite Typographical Conventions Getting Started Main Window Layout TOOIDa Sisi Menu Bar and DataSight Toolbar Graph Toolbar iia ia Floating and Docking a Toolbar Right click menus A A aed Setting Security Admin Group permissions Adding and maintaining Groups and Users Clearing User passw ords Adding User passw ords Setting User permissions within DataSight Enterprise Who s Logged On Setting up the DataSight Database Creating a new database Opening a database Adding or deleting Levels 1 2 3 and 4 Audit LOG iia Adding and Updating variables Deleting variables Merging variables AUG Trall ca ia Setting Up the Audit Trail table Level 3 Properties
87. Delete Record Edt Record with MOE Colne Serengs Sumar y Pane Manrigator Panel From the export list select your format txt xls html xml and the Save as dialogue box appears 5 Navigate to a chosen folder name your file and click Save 10 4 2 Exporting a Desktop database You are able to export data in DataSight Desktop database format and as an MS Access database file restricted to version 2000 and later Before commencing the export process we recommend that you use the Repair and Compact functions to repair any errors and to compact the database 1 Click File Database Export to start the Export Wizard 2 The Export Wizard Select Data Location dialogue box appears Use the upper panel to export a DataSight database and the low er panel to export an MS Access database DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd 1 Export Wizard Select Data Location Sect where lo gave Ihe data te and if you wan te emal the date lo someone ehe Save To Location CiDercisiration DalaBase Export ata OSD Data Hame VyDala h SendByEma O Save as US Access v Save bo Location Cancel 3 In the upper panel Save To Location field click and navigate to the folder in w hich you w ant to save the DataSight database The name of the default folder w here the database w ill be saved is Export Data Y ou cannot save more than one database to a folder If you attempt to do this you will be given
88. Details Conversion Dale IDO Unter Align Converzion Mer Cosmeriasa Del interpolate vet master gt Yes Forma dan ma Output Variable Cox Oulu Level Rafa Veather Data Namo APS Dan iaia fem 3067077008 MEDO OD A Dinh eres nt 12 3008 11 00 00 PAE Aantal Weather Data Birmos AS 10 HF Mardy Tot mm f Coverzion Type isberpolate DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Setting up the DataSight Database so amp Audit Lop Details User Alan Dato 2 19 2008 12 32 03 PM Datasheet Delete Raefall Weber Data Named AWS 1272572008 71090 00 AM 10 RF Piy Tot men 0 Bar Press Hrly Arg hPa Zi Cade 24 87 79 ISE RH Hrly Ag 56 3 Sel Rad Hebr Avg Km Teme Hily Avg Deg C WO Hely Ava Deg WS Hely Ava m sec See Also Database Audit Log 8 7 1 Setting Up the Audit Trail table Before the Audit Trail can begin recording details for imported data and for data entered manually all the eguipment and personnel user details must first be loaded into Audit Trail Setup To access Audit Trail Setup in DataSight select the Tools menu and click on Audit Trail Took Up variables E Data Quality Codes E Standards 8 Security Toolbars check for Update E scheduler SE Report Creator Plug Ins i Sov Te From this window you can click New to create New Equipment records detailing the Brana Model and Serial No and New Person records
89. Gauging Calculator for gauging measurements and flow calculation New features include file saving measurement units measurement quality and collector information Flow calculations can also be entered manually Statistical functions such as Average Minimum and Maximum for Graphs Calculations during Import GIS data view s for Station Properties can contain several geographic information types such as easting and northings X and Y co ordinates etc Construction Details allow s station specific construction information to be stored w ithin DataSight SQL view s with Enterprise edition provides easy connection to Maplnfo ArcGIS and other GIS softw are for spatial analysis and mapping DataSight Enterprise s Database Engine provides a very strong and fast connection to the database server DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd What is new in DataSight version 2 s e Hundreds of minor improvements and bug fixes DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Quick Tour 2 Quick Tour Welcome to the DataSight Quick Tour DataSight DataSight is a window s based relational database custom designed for the easy management storage retrieval profiling and sharing of environmental data Custom designed by an environmental scientist DataSight combines the management and storage features of a database w ith graphing and filtering functionality to give you a complete post collection
90. Import Wizard Step 2 dialogue box No unmapped fields will be imported 14 When you have mapped all the fields click the Next button The Import Wizard Step 3 dialogue box appears 15 In Step 3 you will be preview ing the data you are importing Demonstration DataBase RAW Data Demo WO 2 txt Step 3 Priv the data thai vell be impertec Date 19 03 49 AM 27 05 1998 5 00 08 an 27 05 1999 00 55 au 20 11 2000 18001 31 AM 1811 2001 p 00 04 AU 15 01 2003 8 02 05 AM 2u08 1959 9 00 13 au 16 If you are happy with the data press Next otherw ise press Back and make the necessary changes 17 The Wizard Step 4 dialogue box appears DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd 18 19 20 21 22 23 24 3 C Demonstration DataBase RAW Data Demo WO 2 txt Step 4 Estar nformatien reguzed t complete th men Required Information Level 1 Aura Laval 2 Water Qualy Level 3 Water Quay 1 Auditing Equipement Cobector Select the appropriate Level 1 Level 2 and Level 3 fromthe drop down boxes If you have not already set these up you may type a name directly into the blank field In this case you will be asked to confirm that you w ish to add the new Level 1 Level 2 Level 3 Click Yes The fields marked Date Time and Increment are only used if you have data which does not already have Date and Time values recorded it is the Date and
91. Mathematical and Statistical Functions Formula Example Use MEDIAN Calculates the Median Value of the selected Variable Series VARIANCE Calculates the Variance Value of the selected Variable series STDEV Calculates the Standard Deviation of the selected Variable series Cof V Calculates the Co efficient of Variation of the selected Variable series Calculates the per second Rate of Change from one data point to the next For example the formula rofcA 3 will calculate the per second rate of change for variable A over the previous three points The formula rofcA 3 3600 calculates the hourly rate of change for variable A Calculating Differences The Conversion Tool can be used to determine previous next and time differences w ithin the variables of a database Formula Variable Commen PVALA Previous reading value of Variable A PVALB Previous reading value of Variable B MEE Previous reading value of Variable n Formula Variable NVALA Next reading value of Variable A NVALB Next reading value of Variable B Previous reading value of Variable n Example 1 by using the Previous Value and Next Value in a formula a user can calculate differences betw een values Example 2 the NVAL conversion formula could be used to ensure correct functioning of the meter such as looking at future next or NVAL values to see if a water meter is increasing in value as a flow increases Note W
92. Paging wats _4 gt Scales Tile Labels Ticks Mince Position Ste Fermat Text Exponential Date T ime Format ad MMMM F 12 7 Using Advanced Options Within the Graph panel you can use Advanced Options to apply commonly used series Display Type and Series Label formats Graph Type and Series labels 1 With the cursor anyw here on the graph right click and select Advanced Options Save as JPG Copy to Clipboard Print Preview Switch Axis Filter Options Advanced Options Properties 2 The Advanced Options panel will open to the right of the Graph DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd HE Datasheet di New Graph Labels ione EC Points Visible Humidity s ERIALAALHRRSS Ses 3 Checking All Series checkbox will apply the selected options to all plotted series To apply an option to an individual series uncheck the All Series checkbox and click to select any series on the graph legend 4 Make your selection by using the drop dow n menus on the Type and Labels fields Label amp percent total X vales X amp Y values 5 Manipulate data for any graph series by highlighting the series in the legend of the graph and then selecting a function from the drop dow n menu An entire new series is draw n onto the graph Functions available are Min Max Average Standard Deviation Trend Line Total and Cumulative DataSight Users Manual
93. Period of Applicability for the new Rating Table Users can also elect to Assign the rating table to the same Level 3 as the current Conversion Table Update existing data needs to be clicked to be able to apply the new rating table shift to existing data Click OK Regression Models The follow ing is a list of the in built models that are available w ithin the DataSight Regression Tool Model Formula Number a x b 1 2 a xA2 b x c 3 a x 3 b x22 c x d 4 a xA4 b x 3 c xA2 d x e 5 a x 5 b x 4 c x 3 d x 2 e x f 6 a x 6 4b x 54c x 44d x 34e x 2 H x g 7 a x 7 b x 64c x 54d x 44e x 3 f x 2 g x h g a x 8 b x 74c x 64d x 54e x 4 xA3 g x 2 hx i 9 a xA9 b x 8 c xA7 d x 6 e x 5 f x 4 g x 3 h x 2 i x j 10 a x 10 b x 9 c x 8 d x 7 e x 6 f x 5 g x 4 h x 3 i x 2 j x k 45 a b log x 45 a b log x 12 a b log x 4c log x 2 13 a b log x c log x 2 d log x 3 14 a b log x c log x 2 d log x 3 e log x 4 15 a b log x c log x 2 d log x 3 re l og x 44f log x 5 50 a b x DataSight Users Manual Version 2 9 4 Model Name First Order Polynomial Polynomial Second Order Polynomial Polynomial Third Order Polynomial Polynomial Fourth Order Polynomial Polynomial Fifth Order Polynomial Polynomial Sixth Order Polynomial Polynomial Seventh Order PolynomialPolynomial Eighth Order Polynomial Polynomial Ninth Order Polynomial Polynomial Tenth Order Polynomial Polynomial First Order Loga
94. The accuracy is the sole responsibility of the user We recommend that the user create two or three variables that are used for review ing calculated data In many cases we add three variables normally Calc 1 Calc 2 Calc 3 for all data modified or generated This allows the user to review the data before relocating to the final variable DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Conversion Tool oase Conversion Tool The Conversion Tool is accessed from within the Datasheet area of DataSight 1 Users must ensure the variables they wish to use in the calculation or conversion including the Calc variables are checked in the Field List and visible w ithin the datasheet 2 Right click your mouse in the Datasheet window and select Conversions 3 The Conversion Tool will open Conversions New Conversion Set Eje New Ed Open Save Bx Delete Lig Add variable lk Delete Variable a Close 7 Conversion Vanables i Conversion Graph 1 Conversion Data Master Variable A Index A S Hm AFKE 0 use conversion table Conversion table Converse interpolate with master variable Ci Time shitting Start Offset End Offset 0 DataSight Users Manual Version 2 9 4 Output Formula gt Output value Output variable Output state s Same with Master Variable o LI Update conversion form variable C Update database varistis 2013 Seveno Pty Ltd Conversion Tool
95. Time value that makes each data record unique In this case you can use this section of the dialogue box to set default level 4 Date and Start Time values together w ith the increment at w hich the time values will be added If you wish to add an Audit Trail click the drop dow n boxes for Equipment and Collector and make a selection Note that if security has required that you log on as the current user it is your name that w ill appear as the default Collector Click Next The Wizard Step 5 dialogue box In Step 5 you can undertake simple conversions on the data during the import This feature can be used to add set offsets to data or convert data from raw to scientific units for example Step 5 is activated by ticking the box above the Input Fields The Input Fields column is populated 2 C Demonstration DataBase RAW Data Demo WO 2 txt Step 5 SSS Qr enter Mw formala to modify Input Frida Calculated Input Fields Use Calculated input Fields bout Fields Das New input Field Type in the conversion for the given Input Field you wish to modify in the appropriate Formula cell This will place the modified data into the variable field that was mapped for that input field in Step 2 Leave blank if there are no calculations Alternatively add a New Input Field The Add New Input Field dialogue box appears DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd C3 Add New Input Field 0 nput Fee Inout Field Name Mappe
96. Tools La New cave cave AS Help Ey Print ig Preview sek Databi E Exit The Open Dialogue box appears 3 In the Look In drop down menu select the folder containing the data file that you wish to import In the Files of type drop down menu click to select Excel files x s then click the file name and click Open Look in RAW Data Bl Demo Fuana xis E pemo WO 2ds Bl Demo Muupe Sres wis 2 Demo Rainal rd Demo River xs a8 peo Sever Time Problem oe ed Demo Sever xis Excel Filas xia Open 34 read only 4 The Import Wizard Step 1 Dialogue box appears DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd iC Demonstration DataBase RAW DatalDemoa WO xls E El i step 1 Sec the ogtiong for data moot or load v ipit How is the data formatted Sheet Dama W 2 Date Format DMY Ime Delenter Date Dehmter 1 Decima Symbol Vihere does the data start and stop a First Tie Row j FirstData Roy 2 M ka Hymber of Tte Rows 1 Last Dala Row 3 E Lo at Kai EB E Eb j in i ux n 4n ac LL ns Hu L j 1 pa A Mm UE EE EH oo CO EB dO ul in La t Lo D t Lo 4 E D J Oy Un ib da RD j 71 in FE EE mn mn ano oo a dal dn Pa E F KE c1 El am i D xa no d CO i amp AD da d aC G j i hb j 5 In Step 1 you will identify how the import data is formatted and define w here the data value
97. Update data selecting the OBERTA tab or the EA Conversion Data tab allow s the user to view the graphical result and the data result of the conversion before it is completed DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Regression Tool NOS 18 Regression Tool 18 1 Regression Tool The Regression Tool allows the user to analyse the relationship betw een different variables and to fit statistical functions to a set of data in order to understand the relationship betw een the dependent and independent variable It is accessible via the Tools menu 18 2 Analysing Water Quality relationships using the Regression Tool To performregression analysis on two variables a conversion table must exist The procedure for creating a Conversion Table is outlined in the previous chapter In this example we will analyse a water quality table containing the variables discharge a 1 Having created our conversion table w ith the existing data open the Regression Tool nd total suspended solids TSS E E Regressions File Options New by Save Table Gaugings Result Settings lt Analyse i24 Scale Transformation KS Conversion Tabie Height X Discharge Y amp Close Regression Graph Confidence B sw Height Discharge 0 9 Conversion Table ConvTable Unselected Gaugings Gaugings Unselelected Regression Curve Output Mode
98. Version 2 9 4 2013 Seveno Pty Ltd Graphs 12 Advanced Options Al Senes Type Line Labe Hone Peints visite 128 Advanced Graphs The following pages contain some examples of creating more advanced graphs using the features detailed in the previous section 12 8 1 Graphing Multiple Variables Graphing multiple variables allows users to display large amounts of information within one image The following example using weather station variables details the procedure for creating this type of chart This worked example uses a database with the following Data List Levels QE My Data Darton i BE Weather amp Rainfall Stations pP Camp 1 4 1151 2008 i 11 2 2008 and these Field List Variables ip Variables DateTime Date Time 10 RF Hrly Tot mm RH Hrly Avg 56 Sol Rad Hrly Avg WAITZ Temp Arly Avg Degrees C 1 While viewing the New Graph window within DataSight you can drag and drop variables in the Graphing window DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Graphs 122 2 Click and hold the DateTime variable and drag it across to the graph dropping it on the x axis when the cursor looks like this J 3 Now you can add dependent variables on the y axis dragging them from the Variables list and dropping when the cursor looks like this E For this example four variables are added to the left hand axis Rainfall Relative Humidity Solar Radiation an
99. Wizard Step 2 Dialogue box appears C Demonstration DataBase RAW DataiDemo WO 7 prn E BIR Step 2 las mu nekis te Datasight feria Staten m Date JETEN DEDI EBEMI Staton 1 27 05 1889 0 suben 1 27 05 1889 5 055 Staion 1 20 11 2000 5 01 31 S bon Ia11 2001 2 00 05 Slaton 15 01 2003 5 030 11 The Step 2 Dialogue box is divided into upper and low er panels In the upper panel you can view and filter your existing data fields In the low er panel you map those input fields to your DataSight database fields This combination of filtering and mapping functionality means that you can accurately define and import all or a DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd subset of input data values Filtering input values Filtering is a quick and easy way to define and then import a subset of data You can use filtering to import only the rows that meet the criteria you specify for a particular column or columns Click at the head of any data column to display a list of filter options Standard options are All Custom Blanks and Non Blanks The other options are any of the unique data values w ithin that column Note that the Blanks and Non Blanks options are available only if the column you w ant to filter contains a blank cell Use To return All allrows Custom all row s meeting the criteria you specify for that column Blanks only the rows containing blank data values in that column Non Blanks
100. You can select multiple station as w ell as selection same station more than once m DataSight Tabular Report Wizard Levels Double cick to select Level 1 Level 2 or Level X to report Sites Selected Sites E City Sewer Monitoring Sewer Sie 1 E Sewer Montong Region 1 Sewer 1 Pr Sewer Site 1 3 mate 5 Region 1 Pr Avtomatc Weather Staton 1 F 3 Rural Next step is selection of Datasight variable s you w anted to add your tabular reports You can double click on the variable you want to add the report or you can use buttons located betw een two combo boxes t9 DataSight Tabular Report Wizard Variable Liat Selected Variables Ar temo Sewer Level E Ssewer O Water Level Water Temp DH Wind Dir Sigma Wind Speed Lat DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Quick Tour NOS Y our tabular report list is grouped by the Level 3 Information Tabular Report Wizard will show you the list of all the combinations of the selected Levels and the variables You may w ant to cancel or remove from the output by using the corresponding check box You can also change the report type from Mean Averages Cumulative O DataSight Tabular Report Wizard Summary Types Select functions and report summary types 1p variableName L Report Type E Site City Sewer Monitoring Sewer Site 1 severe ene sewed e A A Water Level Means Mens O Warm ems M P ms M Site Climate Region
101. a b exp x c log x a b exp x c x 5 a b exp x c log x x a b exp x c x a b exp x c x 1 5 a b exp x c log x x 2 a b exp x c x 2 a b exp x c exp x a b x 5 log x c log x 2 a b x 5 log x c x log x DataSight Users Manual Version 2 9 4 Model Name Group Name Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept 2013 Seveno Pty Ltd Model Number 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 Formula a b x 5 log x c x 5 a b x 5 log x c log x
102. aSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Setting up the DataSight Database 5 Before any Audit Trail can be recorded all the equipment and person details must first be loaded into the Audit Trail Table Maintain Audit Trail Table 1 On the main menu click Tools Audit Trail 2 The Audit Trail Setup dialogue box appears Audit Trail Setup Ele Ede We Ip deve Osee jl cos hii I Brand Model V Serial No Cam Sci 10m AW AWS Penaphonics 123445 B80 553 123 3 Any existing Equipment and Person will be listed To add new Equipment or Person 1 Click File New and make a selection 2 According to the selection a new line will be added 3 Type in the details 4 Note that for New Person you may also select a User Name if that person has also been added as a User 5 Click Save then continue to add details or click Close to save and close the dialogue box To delete Equipment or Person 1 Click anyw here in the row for that equipment or person 2 Click Delete 3 Note that deleting any Person or Equipment w ill remove them from any existing Audit Trail 8 7 1 1 Level 3 Properties 1 With an existing Level 3 selected right click and select Properties _ Data kist My Data B cy El i Bj Sewer Monitoring p AA 0L L5 l d RY dl Nes d sess q 10071594 Mi 2 The Properties dialogue box appears show ing the Level 3 Name 3 Under Station Comment
103. ake the changes DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd From within this window the user can access the options to change the graph style edit the each of the axis create graph titles alter the legend and perform many other functions It is simply a matter of selecting the appropriate tab For example to change the format of date labels on the x axis 1 Select the Axis tab Chart Series Data Toole Export Print Senes Genel Axis Titles Legend Panel Paging wals 4 F Visible Seales Tite Labels Ticks Mince Postion Automatic 4 Visible Inverted Apto Chenge Auto Change ul Change Desited Increment 1 000 Logarithmi Log Base no 2 Select the Labels tab Series General Ais Tiles Legend Panel Paging wats 1 7 Visle Seaes Title Labels Ticks Mince Position Style Format Test R Visible Sige o Molina Ange M Roynd Fast Min Separation f0 7 Label On Axis E Style C Auto Value C Ten Mone C Mark 3 Select the Format tab Seales Title Labels Ticks Mince Position Style Format Text Exponential Values Format et HQ eH p Drefauk Albgrenera 4 Select Bottom Axis from the Axes list on the left and select or type in the required format DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Series General Ao Tiles Legend Panel
104. al information to the end of each section A sample output of the Summary Report looks like this DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Scientific Standards Scientific Standard Summary Report 1 01 1999 1 01 2007 Variable pH standard Australian Drinking Water Guidelines Minimum 6 5 Maximum 8 Monitoring Date amp Time Value Monitoring Date amp Time Value Drinking Water Crib East Average TAZ 3 09 2002 9 00 42 AM 7 90 of Records 14 3 12 2002 amp 00 46 AM 8 00 Minimum E 1 09 2002 39 00 00 AM 5 40 Maximum 8 40999984741211 110 2003 10 50 00 AM 3 40 of records below Standard a 22 09 2003 10 10 00 AM 7 60 below Standard 24 43 7 06 2005 9 00 00 AM 7 90 O SEO is A 703 it of records over Standard a m LE over Standard 35 71 se ee Drinking Water Crib 9 lack ij 12 03 2001 9 00 00 AM I7 amp af records below Standard 2 4 08 2003 10 05 00 AMI 510 below Standard 33 33 4 02 2004 3 00 00 AM 8 00 of records over Standard AN 4 02 2004 10 50 00 AMI 8 00 t over Standard 0 00 8 06 2004 7 00 00 AM 7 90 1 08 2005 9 00 00 AM 7 90 Drinking Water Crib 3 Average 7 45 6 03 1999 9 00 00 AM 2 30 of Records 6 10 05 1999 39 00 00 AM 240 Minimum E 09999990463257 1 08 2000 9 00 00 AM 7 96 Maximum T 310 2000 3 00 00 AM 8 01 it of records below Standard 1 4104 2001 3 00 02 AMI 8 10 26 below Standard 16 67 96 14 05 2001 8 00 00 AM 7 85 into de 14 01 2002 9 00 06 AM 8
105. an set up a specific Import flag within the Application Flags interface All data imported in to the database will then be assigned the selected flag Flags in the Datasheet Assigning Flags within the Datasheet When viewing data in the Datsheet simply select a row s of data right click and select to Set Flag The Set Flag list is populated by the user defined flags in the Settings menu created by following the steps under Setting Up Flags DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd X Delete Edit Record with MDE F4 Conversions E Data Quality Interpolations Column Settings summary Panel Navigator Panel Stop Lighting Standards Copy To Move To amp Print WF Filter Options Clear Column Clear Flag Data assigned with a flag will be coloured with the selected Flag colour An example datasheet is shown below Station Date Time attery Volts M10 mg m M10 mg m RHI 96 erature C Dir Hr Av Hr Av mis we trang eon ns oas owe o h jee soon aw 0 00 3 157 539 025 M sz suo K O ons 9 E Wo 12 DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Flags 235 21 3 2 21 3 3 Flags in the Conversion Tool Assigning Flags during Calculations Where a flag is designated as a conversion flag in the Application Flags interface any output data in the conversion tool will be assigned this flag Example Flag 3 e Application Flags File G
106. anspose Axis Logarithmic Regression ld Update Data k Close Conversion Table Conversion Table Graph Weir A M X Depth Y Flow Period of Applicability From 1 05 2005 M 00 00 Note The Conversion Table assumes a straight line interpolation from the last two points for data that is above and below the points expressed in the table This means that negative values can be created if the data falls below the origin Therefore for most stream flow rating tables a second point should be inserted before the origin such as 2 and 0 The table will then assume that all data below zero and past 2 will have a result of zero To save the graph go to the File menu and select Save as As you can see in the images below graph axis can be transposed by selecting et Transpose Axis Note that this does not change or sw ap data stored in the X and Y columns it simply changes the w ay they are displayed on the graph Conversion Table Graph Conversion Table Graph 0 2 3 4 100 200 100 400 500 Depth Discharge DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Conversion Tables 190 Selecting _ Logarithmic allow s the user to set the graph scale to Logarithmic which can be helpful w hen the data entered covers a large range of values Selecting Regression opens the Regression Tool allow ing regression analysis and the development of rating tables tasks which are detailed in the follow ing chapter Assign the Con
107. arge Note The Conversion Table assumes a straight line interpolation from the last two points for data that is above and below the points expressed in the table This means that negative values can be created if the data falls below the origin Therefore for most stream flow rating tables a second point should be inserted before the origin such as 2 and 0 The table will then assume that all data below zero and past 2 will have a result of zero After entering the specific X and Y axis labels available data can be entered Data can be entered individually using the navigation buttons at the bottom of the data area selecting the button to add a line and enter data and the button to remove a line of data Column data can also be by copied from Excel or a similar program into the X and Y columns in the Conversion Table So if you have rating tables look up tables in two columns in Excel for example you will be able to highlight copy and paste them into this area TSS 02 3 0 5 0 2 gt aa A AAA l 0 9 0 4 1 0 4 1 3 0 6 1 3 0 5 1 5 0 7 1 5 0 5 1 8 07 q e lt Similarly if the user was to enter a rating table displaying depth stage vs discharge As data is entered it is graphed in the Conversion Table Graph area as shown below DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Conversion Tables m Ht Conversion Table File Edit La New Ld Save gt Delete A Tr
108. ariable checkbox to complete the calculation Options Update conversion form variable the output is within the conversion tool This allows the user to simply update and store the output within the conversion tool so as not to change any of the database variables This also allow s conversions to be completed on the output variable created in Step 7 and not change any data within the database Update database variable the output is to the database This allow s the user to update and store the output in the database variable selected in Step 7 ig Update data 9 Once the user has selected from these options simply press the button 10 A Conversion Log summary will be displayed and saved to the Audit Trail Log and the conversion completed w hen OK is pressed DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Conversion Tool 174 Conversion Date ZROD User Anean interpolate wEh master Yes Formula 237 7 17 274 237 74A BTO JI 17 27 t 17274 S237 TAAN Herio JJ Output Variable Dew Point FE Output Level Weather Stations Camo AWS M Conversion deuwpoirx Data stats from 1072008 Data enda at 14077009 90000 AM Variables Variable Hame A Level Weather Stations Camp AWS Varigbie Dry Temp Hr Avg C MuEglerik 7 Coversion Table Coversion Type interpa ate Waniable lame E Level
109. ata can be raw or already converted Conversion Table needs to be assigned to a station specific Level 1 Level 2 Level 3 location and Period of Applicability needs to be assigned to be able to update existing data E Update Data To open Update Form click button 3 Shift Update File P New H Save Bl Close Source Weir A 18 02 2012 Reviewed 1 05 2005 00 00 31 05 2005 23 59 Weir A Mone selected 12 00 AM New Data Read onh Archive After selecting source variable and output variable DataSight automatically shows old and new data on the Graph Data tab also shows the Source and before and after data in the datasheet to review DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Conversion Tables m ES Shift Update File La New k Save lg Close Source Table Test 2 5 7 2010 A 2 24 2012 Date from 2 1 2006 00 00 Date to 2 28 2006 23 59 Level 3 Mawson River Variable Depth m M Flag Ratings Shift M Calc1 Reviewed M ge Original Discharge Shifted Discharge Loading data completed Click Save button to update existing data 17 2 Using Conversion Tables Conversion Tables can be used for interpolation w ithin the DataSight Conversion Tool They can also be used for regression analysis within the Regression Tool Within the Conversion Tool the user first needs to select the appropriate Conversion table from the list The small box to the r
110. atasheet and display the data they wish to review and flag 2 Right click on the datasheet and select Data Quality The Data Quality window will open File New oj Save Help f amp Close Graphical Data B Series Update modified data Update flag Above Data Quality Code Poor Quality Between Data Quality Code Verified Data Below Data Quality Code Poor Quality a ES 23 11 2005 24 11 2005 25 11 2005 26 11 2005 27 11 2005 28 11 2005 29 11 2005 30 11 2005 1 12 2005 2 12 2005 3 12 2005 4 12 2005 5 12 2005 6 12 2005 Archive Read Only f For example in the image above depth measurements can be quickly identified and flagged as poor quality or bad data or flagged as data verified to be correct etc Use the Above and Below Start Edit buttons to create freehand lines to define the upper and lower limits for the selected dataset Individual points can be edited drag them up or down to a new value The date and time will remain the same Clicking Save will make the changes in the database to any modified data and or flags depending on the check boxes selected Update modified data Update flag DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd 22 Gaugings Gauging Calculator helps you store gauging measurements and get the Total Discharge Total Area and Mean Velocity 22 1 Gauging Calculator The Gauging Calculator module is for
111. ate Weather Staton 1 Aytamate Weather Station 1 Automate Vieather S aten 1 401 2003 AD PETE o a Ad 2012003 Awomabe Vieather Station 1 Automate Weather Station Automate Weather Station 1 O seg Aytomase Weather Staten 1 u m t V eather Station 1 aj 120 Un E Today 412 2006 Time 12 00 00 414 1 00 00 AM 2 00 00 AM 30000 AM 20000 AL 5 00 90 sald 6 00 00 AM 7 00 00 AM 8 00 00 AM 8 00 00 AM 10 00 00 A4 11 00 00 ALI 12 00 00 PM 1 00 00 PL Ax temp Deg C Humidty 054 16 850 41 600 17 430 16 350 15 870 xs La 3 i k Si ais Ch oc Gi 18 260 35 500 15 590 30 106 17 850 17 910 17 590 18 120 0 640 55 220 21 580 21 610 74 800 22 550 89 830 2013 Seveno Pty Lid Quick Tour 5 7 Quick Tour Reports Use Tabular Reports Wizard to create tabular report in a few clicks To start Tabular Report Wizard click button on the main menu did Mew Graph Datasheet Then select your report type and the report period depending on the report type you have selected e DataSight Tabular Report Wizard Report Type Select report type date amp time Report Tvpe C Monthly Daily Basis ras C Monthly Hourly Basis Starting Month Daily Special Reports Help Load Template DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Quick Tour a Select your data location Level 3 information to continue
112. ator Panel Stop Lighting Standards k Export k Ea Print A Preview Y Fiter Options Clear Column The follow ing Icons are found at the top of the Conversions screen 1M Delete Variable Ij Close F New Open L4 Save X Delete liz Add Variable If you select Open the screen Conversion Sets will open so you can select a saved Conversion Set DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Conversion Sets D Conversion Sets A WerAConversionTrueDepth Gy vierlConversienTrueDent AQ WerCConversionTrueDegth Y vierDConversionTrueDegth EY WerGConversonTrueDepth A Vier SNCI ConversionTrueDept E Ver SNC2 ConversonTrueDept EY WerGTrveDepthChris WeirKConversionTrueDepth A WerkTuedepthRetalc Conversi n Set Name WeikConversionTrueDepth interpolata with master variable Time shifting Start Offset 0 End Offset Type Output Formula A B 0 290 Variable Conversion Tool 170 i SNCI Depth to Flow Variables jj Golfer Broad l 6 Cover Ro ene Gy Goiter Rock Depth to O P EY Wer H Level Conversi n 220501 Lev l3 11 Y Werk ConversionTrueDepth Venable Depth Absolute m K 1 00 i GY Vier Golder Broad D to Q Use Conversion Table Yes Converspn rabie 1 Conversion Type Linear interpolabon Conversion Variable B Level 2 18 Level 12 Once you have your Datasheet displayed you can then populate the fields w ithin the Conve
113. b is active for a Level 3 Allow s the naming and saving of the current Graph or Datasheet Prints either the DataSheet or Graph depending on which tab is active Preview s the print of either the Datasheet or the Graph depending on w hich tab is active From the Preview dialogue box you can change the Page Setup Activates the Import Wizard which will step you through the import process Toggles the display of current Filters conditions applied to the selected data Allow s you to edit data w hen the Datasheet tab is active Tabular reports opens a report wizard window allow ing you to generate tabular reports over varying time frames MDE stands for Manual Data Entry By clicking on this icon you can access an electronic formfor data entry The parameters entered are chosen so that you can build and save electronic forms to match field data sheets 7 2 2 Graph Toolbar The Graph Toolbar to the right of the DataSight Toolbar provides shortcuts to the view and presentation formats of your Function Resets the normal graph view enabled ES Enables the graph to be rotated by dragging up and dow n and left and right Enables the graph to be moved up and dow n and left and right Button Restores the cursor to Normal functionality In Normal mode zoom is DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd 7 2 3 7 3 7 4 Getting Started a Enables the depth of the graph to be increased decreased by d
114. base Legacy databases spreadsheets and existing data files can all be consolidated DataSight has built in functionality to track audit trails perform data validation data interrogation and graphical profiling With DataSight as a common data communication standard you can send and receive share and merge data even if that data is structured differently You can also output report and publish data in a variety of formats including w eb based DataSight is GIS and ODBC compliant adding its ow n pow er to your GIS environment and preserving your investment in existing applications DataSight is also structured to accept plug in analysis modules such as Seveno s LakeWatch application Easy scalability makes DataSight the perfect choice of organizational application Whether supported by a desktop or an enterprise w ide database DataSight connects the w hole natural resources industry To dow nload a fully functional evaluation copy of DataSight go to http w w w seveno com DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Using this Guide 33 6 Using this Guide 6 1 Who this Help file is for This Help file is for anyone w ho is using DataSight Desktop DataSight Enterprise or DataSight Lite Some features change betw een products as noted throughout the help file 6 2 If you are using DataSight Lite DataSight Lite has few er features than DataSight Desktop and Enterprise but is free of charge DataSight
115. bove are named as Field 1 2 3 4 etc f numerical values are in the Input Fields your calculation w ill be incorrect The user can also use multiple fields to calculate a new variable For example Flow Total Dissolved Solids to give an instantaneous discharge of TDS P In Step 4 the user selects the Level 3 that the data is to be imported too The mapping of Level 3 allow s DataSight to link and save the formulas used for that specific site The Formula area is populated w ith the last used formula for that specific site This increases the speed of importing e You can save your Import Spec to use again w ith the same type of file Click the Save button and the Save Spec dialogue box appears Type in a description and click Ok DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd 10 1 3 DataSight Users Manual Version 2 9 4 Importing fixed width files 4 File First look at the file that you wish to import the data source and check that the data variables you wish to import already exist in the DataSight database If not you can choose to add them before you begin Alternatively you can add them in Step 2 of the Import process Before starting the import process close the import file F Click MBA Or on the DataSight Toolbar Open the File Menu and Click Import Edit Tools La Mew Ld Save Save AS Eg Print ig Preview
116. ccess rights to the paths nominated in Tools Options If users are not able to w rite to the default paths please change the paths in the Options w indow Auto Update General Enable Auto Update m Import 17 Datasheet il Graph E Look And Feel ta Tools Update Location httpv www seveno comdownloads Paths Export Path Merge Path Report Save Path C DataSight Enterprises Temp Data Path C Wsers Documents DataSightiTemp MDE Temp Path C Wsers Documents DataSighti Temp 24 4 Exporting Issues In certain circumstances if you are exporting a database and you uncheck a Level 4 or Level 4s under a station you may get this error message e DBISAM Engine Error 9462 Too many Filters defined For the table event In this case the export will fail If this happens re export the database leaving all Level 4s checked Then open the exported database and delete the Level 4s from within the database itself DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Troubleshooting 247 24 5 Merge Issues Deleting a variable after you have mapped it during the merge process will cause the other mappings to scramble You will need to remap these before proceeding w ith the Merge DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Glossary of Terms s 25 Glossary of Terms Find the definitions of commonly used terms in DataSight csv Comma separated values Files w ith a csv file
117. charges for the period of record from the largest value to the smallest value involving a total of n values where n equals the number of points or events for the period of flow records being analysed So in our example there are 6275 flow points in the period ed M and this is displayed in the conversion tool w indow So the formula to be entered is RankDSCA 6275 1 100 Cm C Select an output variable for example Percent o Check the Update database variable box Click Update data Close the conversion tool window ensuring you refresh the datasheet to see the current data DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Conversion Tool NON Creating the Flow Duration Curve Using your calculated data you can now create a Flow Duration Curve Click the New Graph tab Place the Percent exceeded variable on to the x axis Place the Daily Average Flowvariable on the y axis Fiona cum ecs a Fi 0 36 tme ovy Excesded Figure 1 1 Fiow duration curve for the East Creek 2006 08 data DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Conversion Tool m 16 4 Conversion Formulas DataSight Conversion Tool gives you the opportunity to do complex conversions The formula area is one of the most important pieces of the Conversion Tool You can write simple or complex formulas and calculations and any formula you enter in to the formula box is parsed against errors before yo
118. check boxes If the user clicks the variable Datasight w ill populate all the previous unique entries for that variable to provide data entry consistency 7 To save the entry form as a template Click the Template button Select Save 5 Load pe Save 8 Close the Manual Data Entry formto update the Datasheet 113 Datasheet display options Display width With the cursor anyw here in the datasheet right click and select Column Settings Check uncheck Fit Columns to Width to toggle the automatic fitting of the Datasheet columns to the available w idth of the Datasheet panel Check or uncheck the Best Fit to adjust the width of each column to accommodate the maximum w idth of the data in that column Heading order Left click a Column header then drag and drop it to its new position Remove columns Click on the Column header and drag and drop it from the datasheet panel That variable in the field list w ill be unchecked Add columns If any variable in the Field list is unchecked it indicates that the field does not currently appear in the displayed Datasheet You can then drag and drop any of these variables from the Field list to anyw here in the Datasheet or check the box to add that column to the Datasheet DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Viewing Editing Data 109 Restore columns To restore all variables in the Field list panel to the Datasheet right click and select Column Settings then Re
119. checkbox then an email w indow will open w ith a DataSight database as an attachment My ii ud Data Message Rich Lu H nd O This message has not been sent ee Ju CE in Subject My Datacight Dats 114 KB Enter the email address of the recipient in the To field and click Send Move To Copy To The Move To and Copy To functions accessible w ithin the Datasheet allow the user to move or copy data across levels w ithin a DataSight database Within the datasheet the user can select e individual records e multiple individual records using the Ctrl key and selecting individual records e agroup of records selecting the first record then press Shift and select the final record The Move To and Copy To functions are then available by right clicking on the selected data w ithin the datasheet DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Delete Record Edit Record with MDE F4 Conversions 76 Data Quality Column Settings d El Summary Panel v Navigator Panel Stop Lighting Standards k 4 amp Filter Qptions Clear Column 10 5 1 Move To Selecting the Move To function will cut and paste the selected data fromthe current level in the database to a selected destination elsew here in the database amp AI data including null values Select this option to copy move source data to a destination IT the destination has data with same date and time stamp al va
120. contain Data List Saved Views and Field List The main panel contains two tabs allow ing you to view the datasheet and graph and also a saved report The bottom panel contains the filters Datasiet e oky Bh Sewer Mondonng Sewer Ste 1 a 110711894 E ELA x Datasheets E Resorts O Field List L Vanaties Date zi eres e See Series o e Time ae records where of the toto ng DA m gustes Level im Expo me 7 Humidity 13 dl i T NN _ lt Ckk here to add new condiien gt ws Connected te C Demonstraton DataBase Tis zm Qu expand your view of the yall panels datasheet graph panel or filters hover the cursor over any screen panel border The cursor will change to then hold the left mouse button dow n to drag and drop the border of the screen panel To expand the data list saved view s or field list w indow s vertically click on the panel header and drag to the desired height on screen DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Getting Started 7 2 7 2 1 Panel Controlled by Function Data List Panel R3 sus E Displays a tree list view of your data in Levels 1 2 3 and 4 Click the arrow s to open and close the panel Datasheet Graph Panel T Datasheet Displays selected data in a Datasheet or Graph Click tabs to toggle betw een view s Saved View s x anal ices Displays a tree list view of the saved datasheets graphs and imported reports il
121. control documents created for database s in older DataSight versions into the Details area of the first record 8 9 Options Set Default preferences 1 Click Settings Options on the main menu 2 Select the functional area in which to set preferences from the list in the left panel General Toggle the Enable Auto Update on and off and display the location to check for Updates Set default paths for exporting merging data and or saving scheduled reports Set a new default temporary data pathw ay DataSight automatically recognizes w hen you are attempting to import a large file in excess of 10 000 lines and assigns a temporary data location in order to make the importation process faster and more efficient The default location is C TEMP but you can set a new temp data path at any time or if the C Drive is low on space e Options Options Auto Update Y General Enable Auto Update gt Import Datasheet lial Graph E Look And Feel Lal Tools Update Location httpv www seveno comdownloads Paths Export Path Merge Path Report Save Path CADataSight Enterprise Temp Data Path C Users Documents DataSight Temp MDE Temp Path C Wsers Documents DataSightiTemp DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Setting up the DataSight Database Im portant It is essential that a DataSight user has access rights to the drive and folders nominated above If users are not able
122. conversion tool the calculated results or converted data w ill be assigned this flag gt Archive Read Only Data that is assigned w ith the Archive Read Only flag w ill not be editable by any user Administrator users or those w ith appropriate DataSight permissions w ill be able to assign remove Archive Ready Only flags 1 To set these flags select the Application Flags button in the Flags toolbar P New TW Delete Application Flags lg Close 2 In the Flag Index column you can select an appropriate flag for each of the above application processes For example some selections are made below DataSight Users Manual Version 2 9 4 2013 Seveno Pty Lid 21 3 21 3 1 E Application Flags File k Close Description Flag 3 Archive Data 3 The Allow Override function is only applicable for the Conversion If this option is selected users are able to change the flag assigned to specific data using the conversion tool For example w hile completing a calculation the user may elect to flag current raw data with an edited data flag as it is modified in the Conversion Tool If the box is unchecked these changes will not be allow ed See Assigning Flags during Calcualtions for further details Using Flags Flags can be assigned to data e during import e within the Datasheet e during calculations in the Conversion Tool e with the graphical Data Quality interface Assigning Flags during Import Users c
123. d Temperature 8 g 10 RF Hity Tot mim RH Hrhy Avg e 1h Sol Red Hrly Avg 5 8 A 3 a 8 i amp n a 3 9 8 KR SE A k JN ORF Hrhy Tot mm RH Ary Avg 9 A Sol Rad Holy Ava kim z Temp Hriy Avg Degrees C i L 1102006 HASA 1106 2005 1119 2008 115200085 112500065 115302003 Date Time i j IL 11 2008 11 4 2008 117520065 By default these variables are all added as line graphs and the chart may look crowded So the aim now is to clearly display these variables clearly and distinctly within the one chart DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Graphs 123 Right click anywhere within the graphing window and select Advanced Options Rename Series x Delete ma Save as JPG Im Copy to Clipboard igi Preview gli Switch Axis f Filter Options Advanced Options Ey Properties This will display the Advanced Options to the right of the graphing window All Serios Type Line v Labels None Points visible Function w Advanced Options allows you to edit the Type of graph for each variable the type of Labels visible turn data Points on off and add Functions such as trend lines and cumulative data For this example we will display Rainfall as a Bar graph Solar Radiation as an Area graph and Relative Humidity and Temperature as Line graphs With the Advanced Options window open ensure the All Se
124. d Wands Defaut Vale 25 Type in your new Input Field Name Choose a variable to map the new data to from the drop down menu for Mapped Variable Note that a different variable from that of the raw data should be used if both the raw data and modified data are to be imported This variable must already exist w ithin the variable table prior to Step 5 If not please return to Step 2 and create the new variable Insert a default value if you wish Click Ok 26 Type in the conversion for the New Input Field in the corresponding Formula cell Include the input field name s already present in the table and use standard mathematical nomenclature 27 Step 6 offers the chance to select a Scientific Standard to check w hether imported data is within the standard limits or not If you wish to use a Standard check the box and select a Standard from the list Otherw ise click Next 43 CADS Data RAW Datalb txt Step 6 Sect standard Scientific Standards e Use Standards Abra lan Drnkng Water Guidelines 28 Click the Finish button If your import is successful a confirmation information box will display Alternatively an Import Error Log will be displayed with appropriate error messages and options to Save Print Preview Go Back Continue or Abort the Import P When importing data if the first line in the file is Data and not column header leave First Title Line as 0 This ensures that the Input Fields as in the example a
125. d under Level 3 Properties DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd GIS and DataSight NOS z X s intopo ha 41 2312 55 Station information w hen linked w ith a GIS package can then be georeferenced allow ing easy access to database data for querying analysis and reporting DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd 14 Reports There are several w ays to create reports in DataSight For data printouts one option is to filter a datasheet and print or export the resulting data show n in the datasheet Users can also simply generate a graph from data in the database and either print or save a copy as a jpg Alternatively you can elect to use one of DataSight s three different reporting tools Scheduler Tabular Reports and Report Creator 14 4 Tabular Reports Tabular Reports is a fixed type tabular reporting solution You cannot change the report layout but you can select the various Levels and Variables that you wish to report upon You can change the summary type totals averages and Output type You can also save report templates to use them again To generate a Tabular Report Tabular Reports 1 Select the icon on the DataSight Toolbar This opens the Tabular Report Wizard EB DataSight Tabular Report Wizard Report Type Select report type dale 4 tme Report Type Annual CMonthiy Hourty Basis O Daly O Special Reports ALAN Y 2 If you have alrea
126. data sheet Select some or all variable data Export Wizard Select Variables Sect he variables lo be exported Vara cies 1p bate lp Time v 1j Sewer Level im O lp Water Level ien C ij AF mm v 1j Sewer 0 mi I ip Comments O ip Las D ip ph gh r3 4 m m If you select to Send By Email DataSight creates a zipped database ready for emailing DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Quick Tour zo LI Datasight Data Message Rich Text Ge i Suet My Oatasight Baba 000 DataSight Users Manual Version 2 9 4 2013 Seveno Pty Lid Quick Tour 2 5 5 Quick Tour Merge You can also receive a DataSight database from another source and merge the data into your ow n database Datasipht GO Severo Ph TeduseDaralMesgepa 3 L akesContDatacghtiBet a lDatalSamplelData 4 S Customer City of WestminateriWestminster Datasight Data Select any or all of the data for merging in this case the data for River Merge Wizard Select Rows Selec the gua t be merged c Ne i cecal vere a C Aquiters OA Lake 5 d River v V Station E Sion 04 vets 19 2 mgarted Water DI 3 Recycled Water OA a Homing Reservors Qe s Heie Treatment Pant H O d 6 Datribabon k 7 Customers Select the variable fields data to be merged and set the merge links DataSight Users Manual Version 2 9 4 2013 Seveno Pty
127. deleted although you can change their Variable name Description and Format 2 To add a variable click the New button and a new line will be added highlighted in yellow DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Setting up the DataSight Database 8 5 Sr T S Variables Ele Edt I Mew pf Save Mi Delete X Merge l Close variabile Description Units Lead c ph ph meca Sulphate mot J Ja ikg Total Organic Carton malc Toba N rogen mat NTU rici ric o ee eo ojola ol o olo o D D O a om Do D Click on the new line in the Variable column and name the variable Click in the Description column and type in a meaningful description Click in the Units column and type in the appropriate unit of measurement Click in the Field Type column and use the drop dow n menu to select the type of value If you have selected Number then skip the Size column and type or select the Format The number being formatted is alw ays rounded to as many decimal places as there are digit placeholders 0 or to the right of the decimal point If the number contains no decimal point the value being formatted is rounded to the nearest w hole number Listed number formats are HH 0 0 0 00 0 0 You can choose from this list or type your own If you have selected T ext then type in the maximum number of characters that w ill make up the string of text in the Size column If you have selec
128. dsd file 94 Paranthesis 182 Regression Tool Options Conversion Table 194 Setting 61 Regression Analysis 194 203 P Relative Date Time filtering 111 Renaming and deleting Graph Series 116 Page Repairing and compacting the Database 68 Setup 35 Report Wizard 28 Page orientation 61 Reports 28 Panel Print to File 147 DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Index 253 Reports 28 Printing 140 147 Report Creator 140 147 Saved Views 147 Scheduler 140 153 Tabular 140 Templates 147 Right click menus 37 RIF 28 S Saved View s Datasheet 113 Graphs 116 Reports 147 Scheduled Datasheet 153 Scheduled Graph 153 Scheduler 153 Scheduling tasks 153 Scientific Standards 222 224 Importing 222 Tabular reports 222 Security Admin Group Permissions 38 Group permissions 37 Setting 37 Setting for the first time 38 User passwords 37 User permissions 37 Series Renaming and deleting 116 Setting and Changing Graph Properties 117 Setting dates 113 Setting Security 38 Setting up the Datasight Database 43 Setting User Permissions 40 Special reports 28 SQL Views 138 Statistics Summary 110 Style settings 61 Summary Statistics 110 Tabular 28 Tabular Reports 140 Task DataSight Users Manual Version 2 9 4 Scheduler 153 Temporary data pathw ays Toolbars DataSight 35 Graph 35 36 Menu 35 Troubleshooting 245 txt files Importing 81 Typographical conventions U Updates Gett
129. dy saved a Template for this type of report and w ant to use it click the Load Template button Click to select the appropriate template and click Open This will load the parameters that have been saved for that report Continue to press Next to preview and move through each subsequent step Otherw ise di Select your Report Type and Reporting Period Report Type Purpose Reporting Period Annual Average or cumulative reports over 12 months Enter Year and Starting Month Monthly Daily Daily averages or totals for multiple variables Enter Year and Month Basis Monthly Hourly Monthly tabular report for individual variables in Enter Year and Month DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Basis hours Daily Average and total figures hourly over the day Enter the Date Special Reports Specialised analytical reports for the data set Choose Report Type form drop dow n menu e Rainfall Intensity Enter dates for the reporting period e Operational Period Summary e Tabular Summary e Standards Exceeding Data e Standards Summary e Wind Direction 4 Click Next The Tabular Report Wizard Levels dialogue window appears t9 DataSight Tabular Report Wizard Levels Deubie cket to 400 Level l Level 2 r Level 16 reser Selected Sites Catchment 1 Rainfal Station mi Vister Quality 5 On the left are listed the levels available in your DataSight database for reporting On the right is the list of your selected
130. e DataSight Desktop has a database repair function that scans everything inside your data file and repairs any errors Also over time your DataSight database will increase in size If you ever remove data the database file w ill have unused areas that once contained the deleted data These unused areas can affect the efficiency w ith which DataSight w orks with the database and they consume space on your hard disk that can be used for other purposes We recommend that you use the Compact function to remove the unused areas in the database and keep DataSight performing efficiently 1 Click File Database Repair Repairing database Table Progress MEME AAA AAA AAA Totel Progress NRNNNNNRNNNUNRNU Compacting database Table Progress MENA AAA AAA Totel Progress BERGE Datasight Administrator is the database management tool for the Datasight Enterprise Edition to carry out Reindexing Defragmentation Shrinking etc DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd 9 Maps Map Information can be stored in DataSight allowing users to view the location of stations Maps are accessible by right clicking on a Level 2 or Level 3 within the Data List and selecting Map B My Data i Biological B Dust Mentoring i P Hon Mew P nord m Rename i mss LL M p Sout x Delete Meteorologia GZ Refresh G2 New Level R3 Nowe Mont e Surface Via W Control Documents EEE DataSight Users Manual Version 2 9 4
131. e Close Flag Index Allow Override Flag 3 Archive Data However if the Conversion flag has the Alow Override function checked users are then able to change the flag assigned to specific data within the conversion tool For example using the Flag Index number within the Conversion Tool the Output Flag can be calculated rather than user defined using an IF statement or other condition statements In the example below where the result of the calculation output is greater than 4 5 the data will be flagged 2 otherwise it will be flagged 4 using the statement IF output gt 4 5 2 4 Output Formula gt Al Output value m 0 Index Output variable Calc1 M Output Flag Default flag is 0Y W Calculate Flag Fioutput gt 4 5 2 4 Output station Same with Master Variable Update form data Update database variable Pi Update data In another example if the user wishes to simply flag the output data as an alternative flag to that assigned in the Application Flags area they can just enter the Flag Index number see below Output Flag Default flag is 0 4 Calculate Flag 25 Flags and Data Quality Assigning Flags with the Data Quality tool The Data Quality component within DataSight allows the user to quickly and visually assign flags to data points using the graphical interface DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd To edit data in the Data Quality interface 1 Open the D
132. e Decimal Symbol formats 8 Use the scroll arrow s to set the First Title Row and Number of Title Rows v ill appear next to the first and last Title Row lines in the data panel if there is no Title Row leave the Title Row at O 9 Scroll dow n the data panel and identify w here the data starts Position the cursor on the appropriate line number in the data panel and left click This w ill set the position of the First Data Row and P wil appear next to that line in the data panel Any values above this row apart from any set Title row s will be ignored in the Import process Continue to scroll dow n the data panel and identify w here the data stops Right click on the appropriate line number in the data panel to set the position of the Last Data Row and P will appear next to that line in the data panel Any values below this line w ill be ignored in the Import process 10 Click the Next button The Import Wizard Step 2 Dialogue box appears CJ C Demonstration DataBase RAW DatalDemo WO 2 txt Step 2 i Maga u feld to Parasaght Meda Sibbon Dae w Time kiwon E 27551999 awos leas 27 08 1999 9 00 55 20012009 9 01 31 19 11 2001 9 00 04 15 01 2003 9 03 05 vg 11 The Step 2 Dialogue box is divided into upper and low er panels In the upper panel you can view and filter your existing data fields In the low er panel you map those input fields to your DataSight database fields This combination of filtering and ma
133. e Options 11 Select one of the Output Options from the To Print list Print Report RTF PDF or HTML For the latter options ensure the appropriate save options are chosen You may collate reports by variables or sites 12 If you wish to save the report click on Save Template Name Sulace Water Monitor A5 Repond Monthly Anrrual Fari al Noite bor en Level Check Due Levels Al Sites a Type the Name of your Report template b Click Save The Tabular Report Template dialogue w indow will close 13 Click Next The list of created tabular reports w ill be show n DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd DataSight Tabular Report Wizard Reports La of created tabular lepers POKER E dE VEE ee 14 Rural Catchment 1 Raintal Stations RF 14 Click Finish to exit Tabular Reports 14 1 1 Example Report Wind Rose This example details how to create a Wind Direction Report This report displays a wind rose showing the frequency of winds blowing from particular directions The length of each spoke around the circle is related to the frequency of time that the wind blows from a particular direction 1 Select Tabular Reports from the Toolbar 2 Select Special Reports from the Report Type area Report Type y Annually Monthly Daily Basis 3 Select Wind Direction along with the reporting period from the drop down list to the right Repor
134. e and you will receive the follow ing w arning Warning DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd 17 Conversion Tables 187 Conversion Tables The follow ing provides information on how to create and save a conversion look up table These look up tables can contain data for e Strean River Stage Discharge Curves e Water Quality data For example plotting Turbidity against Discharge e Stream Rating Tables e Pump Rating Tables To create a Conversion Table access the Conversion Tables window via the Tools menu Tools Help Regressions Control Documents Report Creator Scheduler Conversion Tables are also accessible from the File menu w ithin the Conversion Tool Create a New Table by clicking the New button on the Toolbar This allow s the user to enter X and Y data in the area provided along w ith a Period of Applicability for each new conversion table For example in this exercise w e will create a Water Quality lookup table comparing observed Discharge and total suspended solids TSS for a stream DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Conversion Tables 188 HE Conversion Table File Edit d New Save K Delete LA Transpose Axis Logarithmic Regression l Update Data E Close Conversion Table Conversion Table Graph New Table 2 M X Water Level Yo Discharge Period of Applicability From To Water Level Discharge m m L E 0 Disch
135. e calculations This is the user s responsibility and all calculations should be checked By using the Conversion Tool the user warranties Seveno against any claims DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Conversion Tool 14 Conversion Table Layout File Edi New Save lt Delete wt Transpose Axis Logarithmic ki Close Conversion Table Conversion Table Graph New Table 7 X Discharge Period of Applicability Date from E I I I I I I I I I I I I I I I I I I I I I I I J I I I I I I I I I I I I I I Note The Conversion Table assumes a straight line interpolation from the last two points for data that is above and below the points expressed in the table This means that negative values can be created if the data falls below the origin Therefore for most stream flow rating tables a second point should be inserted before the origin such as 2 and 0 The table will then assume that all data below zero and past 2 will have a result of zero DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Conversion Tool es Conversions IVENBCORYEIES sion Bi rueDepth nes Bom Pes Kode i Adi vraie dij uic vete leas ip c Conversion Varables cx Conversion Gon 3 mm A A mm n Gauging Stations Weir K Date amp Tme 1 01 2007 5 45 40 AM Index 1 E E
136. eated within a nominated time interval second minute hour day month or year within the selected range of data For example Every 15 minutes 7 Once these options have been entered the points will be displayed within the graphing area of the Interpolation Tool This can be seen as the red data points in the graph above 8 The user can elect to output newly created points to the original variable or another variable in the database The default variable is the same as the source data In the example above this is Battery Volts 9 When you are satisfied with the interpolation and to create new points in the database press the Save button Please note where existing data with the same date and time as the new data points exist it will be overwritten with the interpolated figure DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Scientific Standards 222 20 Scientific Standards Scientific Standards in DataSight can be used to check and control the data entered for specific variables within a database against certain specified Scientific Standards 20 1 Scientific Standards Introduction Standards are accessed by selecting Standards from Settings main menu Audit Trail Variables Plug Ins Toolbars Ag Show Tip Standards ium m Standard List E E a EEE Standards af USGS Water Qualty Standard A Standard Name Australan Drinking Water Guidelines The 2004 Apstra
137. ect Edit 4 Make any required changes 5 Click OK Delete a task 1 Click Tools Scheduler 2 The Scheduled Tasks dialogue box appears 3 Right click on the task and select Delete 4 You will be asked to confirm the selected deletion 5 Click OK Checking tasks assigned to a Graph or a Datasheet 1 Right click on any saved Graph or saved Datasheet and select Properties 2 Scheduled tasks are listed DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Conversion Tool 157 16 Conversion Tool 16 1 Conversion Tool Introduction The Conversion tool is an extremely flexible tool allow ing the user to use either look up tables or interpolation tables along w ith free hand formula s or a combination of each to adjust and modify data In brief the user can e Convert data using look up interpolation tables e Convert data using free hand formulas e Convert or adjust data using time shift with either absolute or percentage values e Use the data from multiple stations or multiple variables to undertake conversions e Generate new data and place in a variable e Relocate data to appropriate variable e Undertake Scientific unit conversion e Review Modified data in the Conversion graph e Review tabular data in the Conversion data grid tt is important that the user understands from the onset that the Conversions does not undertake any review of the accuracy or validity of the data being adjusted generated or calculated
138. ei e ara un nag aie E TERI MEINEN A Select the Conversion Graph tab to view the result of the calculation DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Conversion Tool 177 A New 9 Open pj Save X Delete thy Add Variable lij Delete Variable amp Help i Clove ip Conversion Varabes i Converyon Graph Coeversane Data Converter Graph 10 20 AM PO AM 10 00AM 10650 AM TE AM 7110AM 1120 AM 1130 AM 1AM 110 AU Datel Te Comi enam Culpa J nierpolte wih Sater varabie Forma la e 4A l280840 Time shifting Suet Ofise 0 EndOdffse n vag Output variable Dep F Teel en Same wih Laster viniti Type PE Uondase COFFEE form ds y Loire Catalase varabe Current Record 0 18 DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Conversion Tool 178 16 3 3 Completing a Conversion 3 Conversion Tables To calculate stream flow from depth measurements ensure you have the correct rating table with depth and discharge data Rating tables can be entered into DataSight in the Conversion Tool Select File Conversion Tables 3 New pp Save X Delete 4 Transpose Axis _ Logarithmic il Close z Conversion Table Graph Hote The Converson Table assumes a straight ine nterpolation from the Inst two ponts for data That a above and below the points expressed in the table Tha means thal negative values can be created if tha date falis below the origin Theref
139. elete LE Save as JPG 4 Copy to Clipboard Ey Print JJ Preview ali Switch Axis Y Filter Options Advanced Options E Properties 4 Within the Advanced Options area that opens select Windrose from the Type drop down box DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Filters O Use fiters that were saved with this datasheet CO Use fiters that have just been selected Prompt for fiters to use when datasheet is loaded 4 Graph j Lock And Feel B Toots Orientation Portrait Reports v Fit To Page Grid Display C Fe Columns To Width C Second Row For Unis Show Summary Show Navigator Step Lighting 3 Min Valve MEN Colour Text C Max Vale Colour Text C Colour Text View s v Create SOL Views for Saved Datasheet Views Create Numeric SOL Views for Saved Datasheet Views The graph will change to a wind rose H NNW pa E NNE 3 uw P ES HEE ai wW SWWN SEE Vind Vel Hr Ay mis LU Lad 9 Opening Graph Properties right click on the graph allows the user to make the graph circled DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Graphs 135 Select the Series tab Select the Circled tab Tick the Circled checkbox Chast Series Data Tools Export Font wedvaHravm E Wind Rose Wind Ve Circled Gener l Marks Data Source Rotation 99 H Coe I Radur oua 0 H F duo E 3
140. er Mame Server Port User Name User Password OK Cane Apply Tools allow s the user to set the default settings for Conversions w ithin Datasight including e opening the program with the last saved conversion set e interpolate or estimate the values w ith the master dataset and e showing the conversion summary for confirmation before starting conversions Tabular Reports The user can elect to use a selected default format for displaying variables in tabular reports If this option is left unchecked the display format w ill be taken from the format selected in the Variable list Map The user can elect to enable disable Google Maps This option should be unchecked w here a computer does not have an internet connection available Scheduler e These options are related to the DataSight Scheduler e Enable disable the scheduler e Restart application after a period of Restart DataSight after a user defined period this clears the DataSight cache of past scheduled tasks allow ing all DataSight operations to run smoothly This is useful where there are several scheduled tasks running and or regular scheduled tasks e Email Server Details Enter the default email settings for sending scheduled output files from DataSight Email recipients are selected under individual tasks DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Setting up the DataSight Database 8 10 Repairing and compacting the Databas
141. er control the integrity of the system Despite this you may still add other members of the Admin Group if you wish The Security features in DataSight are implemented in this hierarchical order di The Admin User in the Admin Group Who can toggle the Security feature on the DataSight database by allocating an Admin User passw ord If that passw ord is subsequently deleted Security is toggled off and access to the database will remain unrestricted unless and until another passw ord is allocated by someone logged in as the Admin User If no Security is turned on the default login is the Admin User 2 Members of the Admin Group Who can Toggle off security by clearing the Admin User passw ord Add and Delete Groups Add and Delete Users Assign Users to Groups Clear any User passw ords including the Admin User s 3 Users Who can Add or Change their ow n passw ords DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Getting Started NOS 7 4 1 7 4 2 Setting Security Setting up Security for the first time The first time that DataSight Security features are set up the user doing the setup is recognized as having the default user name of Admin w hich is the only existing member of the Admin Group The Admin User toggles the DataSight Security feature on at the highest level by allocating an Admin User passw ord If that passw ord is subsequently deleted Security is toggled off and access to the database w ill remain
142. es Plug Ins are used to enable third parties to develop their ow n applications that access the data within DataSight DataSight Plug Ins operate w ith both DataSight Desktop and DataSight Enterprise 23 1 Adda Plug In To connect a Plug in to DataSight 1 Go to the Tools menu and under Plug Ins select Plug In Manager 2 The Plug In Manager dialogue w indow appears Plugin Manager EET Manning s Ecvatan Conver Tables Version 155 Author Murat TAHTALI Published Date 13 pri 2004 Desecrinton Data Quality Fiters 3 The Window shows the current suite of Plug Ins installed You can view the Version number Author Publication Date and a brief Description of the Plug In 4 Click Add or Remove to manage your Plug In suite Plug Ins are attached to DataSight through a dll file located in the appropriate Plug In directory on your computer or your local server 9 Close the Plug In Manager to return to the DataSight desktop 6 Select Tools Plug Ins to view the available Plug Ins from the drop dow n menu DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Troubleshooting 25 24 Troubleshooting Use this guide to troubleshoot any issues with DataSight If you do not find the answ er here or elsew here in the Help file then use the Forum or email support seveno com w ith the issue details 24 1 General running issues If you have any issues or errors when DataSight opens 1 Check that y
143. es They may contain text and numeric characters xls Files w ith a xls file extension have been created using Microsoft Excel xml Extensible Markup Language Files with a xml file extension can be used for sharing structured data such as database information betw een users particularly via the Internet DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Index Cumulative 28 j Daily 28 PICTURE bm56n bmp 52 Data 74 Editing 106 y A Entering 95 Add a Plug In 244 EXDor ng 99 Adding and maintaining Groups and Users 39 meno MI M En Adding and Updating variables 45 dd 9 rsin Adding User passwords 40 9 Admin Group Permissions Data pathw ays Adding 38 Temporary 61 Maintaining 38 Data Quality 237 Advanced Options 119 Database Annual 28 Compacting 68 Creating 43 Audit Trail 48 erasing 169 Audit Trail Table ELO B Control Documents 50 dl 9 P Level 3 Properties 50 de Repairing 68 Level 4 Properties 50 Datasheet 105 Auto Update Clear Column 105 Enable 61 Default formats 61 C Deleting 105 113 Display Options 108 calculation 15 7 Editing 105 Calculations 169 Exporting 99 Calendar 113 Saving 113 Clear Column 105 Viewing 105 108 Clearing User passwords 40 DataSight Desktop 33 DataSight Enterprise 40 DataSight Lite 33 Date Formats 61 Control Documents 58 Conversion 180 Conversion Formulas 182 conversion table 178 187 Dates Conversion Tool 157 Setting 113 Time Shifting 169 l l Dele
144. es any selected data into the Output Table tab Data in the Output Table is displayed in the Graph area in blue DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Regressi on Tool Regression Graph Confidence Water Quality 0 1 2 3 Conversion Table ConvTable Unselected Gaugings Gaugings Unselelected a x 3 b x 2 c x d Output Output Tabie x Y 4 55757575757576 0 705711545442393 4 75555555555556 0 762985926328446 4 95353535353535 0 827802818695778 5 15151515151515 0 900467206883372 5 34949494949495 0 981284075230206 5 54747474747475 1 07055840807526 5 74545454545455 1 16859518975752 5 94343434343434 1 27569940461596 6 14141414141414 1 39217603698957 6 33939393939394 1 51833007121731 6 53737373737374 1 65446649163818 6 73535353535354 1 80089028259116 6 93333333333333 1 95790642841522 7 13131313131313 2 12581991344934 7 32929292929293 2 30493572203252 7 52727272727273 2 49555883850371 7 72525252525253 2 69799424720191 7 92323232323232 2 9125469324661 8 12121212121212 3 13952187863526 8 31919191919192 3 37922407004836 8 51717171717172 3 6319584910444 8 71515151515151 3 89803012596234 8 91313131313131 4 17774395914117 9 11111111111111 4 47140497491986 9 30909090909091 4 77931815763741 9 50707070707071 5 10178849163279 a TNENENENENENE E 4
145. esult Setttings TB Analyze lA Scale Transformation Reports k Close Once you have selected the conversion table and gaugings you wish to use click Analyse in the toolbar to begin regression analysis Regression Group M A list of the available Regression Groups will be displayed DN Select the applicable Group or select A Groups and click OK Inverse Polynomial ERA Single Parameter w h MaxMin z iege Temes E By clicking New users also have the option of creating their ow n Group using the in built Three Parameter wih MaxMin regression models a Two Parameter Convex Concave F Two Parameter Sigmoidaly Shaped Two Parameter with Max Min Two Term intercept Details of the Regression Groups available for analysis are found in the follow ing pages When the user clicks OK DataSight w ill complete the regression analysis and display the results of each model graphically On the right details of the Regression Models will be displayed A graphical representation of the model will be display ed in the Regression Graph w indow in the middle of the Regression Tool DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Regression Tool s Regression Graph Confidence Mawson River Feb2010 84 T Pat 5 i A PORE EAE LA autern A AA 1 h DAT a gt LIIS POE TYS EV VET ES RO DEA RS A 0 200 200 5600 Bon 1 000 1 200 1 400 j Conversion Table ConvTabe
146. et the user can isolate only the data that requires modification The Conversion tool also allow s the user to save conversion sets and look up tables The speed of the conversion changes betw een DataSight Desktop and DataSight Enterprise We recommend that the user undertakes conversions in reasonable sizes For example w ith DataSight Desktop it takes under 2 minutes to complete the conversion of 9 000 data points This w ould equate to approximately 12 months of hourly data But performance of the conversions is really dependent of you computers performance The Conversion tool is extremely flexible and pow erful allow ing the user to use look up tables free hand formula off set adjustments in proportion to time for both absolute and percentage changes This is extremely important for adjustment of w ater quality data as sensors are affected by algal grow th Data form several different sites can also be modified We recommend that if the user is undertaking a significant amount of data manipulation that they generate three additional DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Conversion Tool 163 variables In most cases we use Calc 1 Calc 2 and Calc 3 These additional variables allow the user to manipulate modify the data set and save it into a generic variable w hich they can then verify before placing into the final variable The following is to be used as a guide only No warranty is given as to the accuracy of th
147. existing file If you tick the checkbox for Do not create output if no data the you avoid overw riting the last output file that DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Scheduler 158 contained data 8 DataSight can create and add a Report Title to the output file Check or uncheck this box to Enable disable the Report Title 9 The generated output file can be emailed to one or more recipients Simply check the box and enter an email address When entering more than one email address separate each address with a comma You can choose one of three options w hen emailing the results of your task You can choose to send an email every time the scheduler runs the task or only send an email w hen data is found or only send an email w hen there is no data Having the ability to receive an email notification fromthe scheduler if data has not arrived can be great for your data management Note please ensure the user has entered the correct email server SMTP details in the Tools area of the DataSight Options access via Settings on the toolbar Conversions ES SRM pen with last saved set M Import i interpolate with master as a default E Datasheet lial Graph Look And Feel Tabular Reports ui Use default display format for variables in Tabular Reports Show conversion summary before conversion starts 0 00 0 00 Map Enable Google Maps Scheduler Enable scheduled tasks Changes require
148. ext otherw ise press Back and make the necessary changes 17 The Import Wizard Step 4 dialogue box appears DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd 18 19 20 21 22 23 24 25 17 C Demonstration DataBase RAW Data Demo WO 7 xls Step 4 Enter nformaton regured to complete tha Required Information Level 1 Rural Level 2 Water Quality Level 3 Water Qualty 1 Auditing Equipment Colector Select the appropriate Level 1 Level 2 and Level 3 fromthe drop down boxes If you have not already set these up you may type a name directly into the blank field In this case you will be asked to confirmthat you w ish to add the new Level 1 Level 2 Level 3 Click Yes The fields marked Date Time and Increment are only used if you have data which does not already have Date and Time values recorded it is the Date and Time value that makes each data record unique In this case you can use this section of the dialogue box to set default level 4 Date and Start Time values together w ith the increment at w hich the time values will be added If you wish to add an Audit Trail click the drop dow n boxes for Equipment and Collector and make a selection Note if security has required that you log on as the current user it is your name that will appear as the default Collector Click Next The Wizard Step 5 dialogue box In Step 5 you can undertake simple conversions on the data during the import T
149. fer markedly in their scale you should use two different dependent variable axes to cater for this either the 2 x axes Top and Bottom or the 2 y axes Left and Right Br you are plotting Date as a series value you will need to format it by right clicking on the Graph and selecting 12 2 Properties Then select the Series tab and use the drop dow n menu to select the Date series Select the General tab Select the appropriate axis and check the Date Time checkbox Zooming To Zoom Click on the Graph toolbar Hold dow n left mouse button and drag mouse tow ards dow n right You will see a rectangle around the selected zoom area Release the left mouse button Repeat the action to continue zooming To restore view Hold dow n left mouse button and drag the rectangle in the opposite direction up left This w ill restore the original graph view DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Change the appearance of your graph using other graph toolbar buttons 12 3 Renaming and deleting Graph Series To rename a series 1 Right click on any series on the legend and select Rename 2 Overtype the new name and click Ok To delete a series 1 Right click on any series on the legend and select Delete 2 A Confirm dialogue box appears Click Yes 12 4 Saving a Graph Saving a graph Once you have created your graph you can save its structure and format to use again Click and the Save As dialogue box
150. ge 32 ge En pco Son Harina Osa Tacos Maite inna Ei hra 11 Beer Hita Ost Dr DAA 22344 12 NET 0 ZI mper pri qos Pe a TAE En SA mil WII ES T coger Poppa dmg fn JamE IE im whe cum ach shi Ta Bdaer Hada Oir e n n ALE az ZITA DIL mom v EPRE Mita PRUE d ion beet DEE im 1519 VEL ME ET H BRET biaa BOTH ma Bhu imi tis NYE ai Tam m Egger Frac Om rg Finbar DT 2291 2nmT Im Tit os BE filed El m Bure a li SE 233407 zzm PECI asi Haa Eijer Minh Geir SB ons Helier ET amp WE wes ED Hm 47331 y Egger brama o Ambar id IER Lite ll k l I ia hirie mi tE ena drid HH EIS ifa I5 IE Eh 208 B Figer Mila Bil IKE Rena doen ellie ZOE Same za 20m rm L pras fears BS OF Pura Rs THIF 175 gt TEES ume Tee I ad Limia Mare mi PE irren Suc ibe ZE izn 11m ras ret UT MI az Minds Hari i n hue Bors Thir 24g 2274 sin cH 17 x3 pines si Bn A ER mires unc hors THIF SEs Ala ra hia a1 m hinia Fire m H3 bena Porc lors ii EB 23i i l P PETE ad Soper Higos mi B irra durmak isi AE 2s is eit BB 3 mier Puhia HE er e por Te EBS ZM mm oun Dum Dur Omar s Figures and summary data are displayed in the same measurement units as the data that has been entered w hether that be metres cm feet inches etc If you select File Print or click the Print icon you can Print to File and export the gauging report as an xls pdf rtf or other file DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Plug In Modules 24 23 Plug In Modul
151. he Regression Graph area will display the Conversion Table graphically DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Regression Tool s ns file EA id ew bl seve Tobe e Gaugings Ko 49 Analyze d ZA Scale Transformation Reports gg Close Mawson River Febz010 3 Result Setttings og Analyze A Scale Transformation Reports I Close 2 Click the Gaugings button on the toolbar to select the Gaugings for analysis l 13 Mew a Delete Reports Close 1 9520 a D 2100 eum nem ls ws mnm CT wee ei jenom Mon MN 05 03 00 DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Regression Tool s J M Delete Export Columns Select all Unselect all FASS SS SiS E Invert selection Select individual gaugings by checking the boxes on the right of the v Gaugings window or right click on the window and Select All This will populate the Gauging Data area of the Regression Tool allow ing regressions to be carried out on those selected and plot the gaugings This is displayed below 0 894737 0 875574 1 178058 1 328726 1 441847 1 570534 1682515 1 718854 1 81824 1951177 2
152. he regression calculation While view ing the graph users can alter the Result Set Settings altering the start and end values Zoom by clicking the eft mouse button and dragging Pan around the graph by right clicking the graph and dragging Right clicking the mouse button also displays a menu allow ing the user to copy and save the graph and turn the various series in the graph on or off Show Conversion Table Show Conversion Table Unselected Show Gaugangs Show Gaugings Unselected Show Curve Fitting Show Output 2013 Seveno Pty Ltd Regression Tool NOS The Graph Legend Conversion Table ConvTable Unselected Gaugings Gaugings Unselelected aro Adra HPA Output The graph legend is standard displaying the six different series view able in the Regression Tool Selecting the Analyse Results tab will display the results of the analysis using the selected model that is currently displayed on the graph X Y a 1333431455554 7 0707D707070707E 02 2067157005131 77 0 141414141414141 232199117 7791473 0 212121212121212 250548263972096 0 242424282828283 292049326221141 0 353535353535354 327012744795264 D 424242424242424 1557T4540393401 i 0 494949454545495 4 08698410627491 0 56565655656566 456176332481272 0 636363635363636 5 08631196148382 0 707070707070707 5 55517958355273 l O TTTITIHIITITITE B 3032407018212 0 845484848484848 7 00577827 394835 0919191919191919 7
153. hen PVAL is used for the first value within the dataset it will return that first value Similarly when NVAL is used DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Conversion Tool m for the final value in a set it will return that final value The Conversion Tool can be used to calculate the time difference betw een records values Formula Variable TIMEDIFFA Time difference betw een records in seconds The TIMEDIFF variable w ill return the time difference betw een records values For example if Record 1 was taken at 12 12 2008 02 02 00 and Record 2 at 12 12 2008 02 03 00 the value given would be 60 seconds INDEX function INDEX Displays the Index value of the output The INDEX function can be used to index the selected variable giving the first data entry in the series a value of 1 the next a value of 2 then 3 and so on An example output is displayed below Station Dabe Time Degth m dex Bar mer OTT m ls 5 200420410 0AM 445 4 Test 20 04 7010 9 30 00 AM 16 2p Test 20 04 2010 8 45 00 AM 2 3E Test 20 04 2010 10 00 00 AM 21 4 Test 20 04 2010 10 18 00 AM 32 5g Test 201042010 10 30 00 AM 3 Ep Test 20 04 2010 10 45 00 AM 342 7 Test 20 04 2010 11 00 00 AM 4 51 ay Test 20 04 2010 11 15 00 AM 5 08 8 Test 20 04 2010 11 30 00 AM 74 10 Analytic Operators Logical Operators lt gt amp lt gt lt gt Paranthesis Common math
154. hing area and can be saved as a DataSight Conversion Table by clicking the Save button on the toolbar and entering the follow ing details e Rating Table Name e Xand Y axis Labels e Period of Applicability this is simply a set of reference dates for the user e select to Assign the conversion table to the Level 3 that the original conversion table data w as assigned to e select to update existing data in the database DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Regression Tool m 18 3 E Rating Table e lla Es Rating Table Name Weir A Jan Feb 1 03 2012 Labels X Depth Yo Flow Period of Applicability Date from 1 01 2012 Date to 29 02 2012 Assign to the Level 3 that conversion table has been assigned to Update existing data 12 Click OK to save the Conversion Table 13 Update existing data Applying Conversion Table to Updating Existing Data The Conversion Table w ill then be available from the Tools menu and within the Conversion Tool for interpolation and use w ith other datasets Analysing hydrographic relationships using the Regression Tool The regression tool also allow s the user to fit different functions to a set of gauging data points and develop rating tables based on existing gauging data There are three aspects to the Regression Analysis Tool These are e Gaugings e Conversion Tables e Regression Tool Regression Analysis can be performed on Gaug
155. his feature can be used to add set offsets to data or convert data from raw to scientific units for example Step 5 is activated by ticking the box above the Input Fields The Input Fields column is populated C Demonstration DataBase RAW Data Demo WO 7 prn Step 5 Sac or deter ruv formula lo modify fiau Fees Calculated Input Fields v Use Calculated input Fields naut Fields Care Lene Haig New out Fie uet Cancel Type in the conversion for the given Input Field you wish to modify in the appropriate Formula cell This will place the modified data into the variable field that was mapped for that input field in Step 2 Leave blank if there are no calculations Alternatively add a New Input Field The Add New Input Field dialogue box appears DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd C3 Add New Input Field 0 nput Fee Inout Field Name Mapped Wands Defaut Vale 26 Type in your new Input Field Name Choose a variable to map the new data to from the drop down menu for Mapped Variable Note that a different variable from that of the raw data should be used if both the raw data and modified data are to be imported This variable must already exist w ithin the variable table prior to Step 5 If not please return to Step 2 and create the new variable Insert a default value if you wish Click Ok 27 Type in the conversion for the New Input Field in the corresponding Formula cell Include the
156. ht Users Manual Version 2 9 4 2013 Seveno Pty Ltd CiDemonstration Database RAW Data Demo WO 7 txt a Im 5 Step 1 Sect the Gotland for data import or ead save p Select the file type Dema Characters such as commas or tabs seperate each field C Eid With Fieids are aligned in columns with spaces between each field How is the data formatted Field Delimiter tat Dale Formal DUY Time Deiter Text Qualifies nene Daie Diber Decimal Symbol Vihere does the data start and stop First Tie Row Figi Data Roy lt A a E ne A Fe Hymbar of Tile Rows Last Data Row J JE FE pr aci Bog HET ia E 21 pa pa o CR MB au gw HER ALI ge GF ae da da des T F v D A amp MR AD D ac see GC mb xD do TP A ki 5 Ki Bet D dar du E E cf ef gt 48 dM cH LES b ER 4b B C O Wk Gh 4L in 5 In Step 1 you will identify how the import data is formatted and define w here the data values start and stop 6 If you have already saved an Import Specification for this type of file and w ant to use it click the Load button Click to select the appropriate specification and click Open This will load the parameters including the mapping decisions that have been saved for that specification Continue to press Next to preview and move through each subsequent import step Otherw ise T Set the appropriate Date Format Time Delimiter Date Delimiter and th
157. iables you w ant to show on the Entry Form click Variables button 5 Left panel show all the variables available to show on the form Right panel show already selected variables Variable Selection Wariable Lai Anthracene Acenagthene Acenapthywne AI Ammonis as HH Ammonia Nitrogen pe Ash mm Bar Pres Wax 24h Bar Press Bar Press Av 24h Bar Press AvHr Bar Press Min 24h Benziajanthracen Add selected variables to the form Removes selected variable from the form DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Viewing Editing Data 108 Eo Add all the variables to the form Removes all the selected variables E Changes order of the variable on the form E close 6 After you selected variables and organized the order of the variables you can click button to finalize the selection Variable Selection Variable List Selected Variables Vol Available Storage A Data Quality valatles Trihalo methanes Iv cenaplhyiene Wa Bub Benzo bifouranibane Wei Days 7 Death Wind Dir s Wind Dir 24h Wind Dir AvHr res r Volume Chiarine Free f hr i Wind Vel 24h E Wind Vel AvHr mai Wind Ved Max 24h Oa Xylene Zn wind Dr ST 245 Wind Dir ST AvHr As you can see on the image above some of the variables are faded and some of them have check boxes w ith them Numeric variables are show n faded in the list Only text variables have
158. idth of that Input Field DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd C Demonstration DataBase RAW Data Demo WO 7 prn Step 2 lap pul falda to Dela Sight fea tabon Date ws Time ln E De mme L oH b S aton 02 07 2003 9 03 49 euten 1 27 05 1899 acos zao Staten 1 27 05 1999 9 00 55 zaoo ssaten 1 20 11 2000 9 01 31 7 100 Steson anwo amp 00 04 6570 Staton 1 14 01 2003 50308 m 13 The left column lists your Input field names Click in each adjacent line in the right column to access the drop dow n list and select an existing DataSight field to map each Input field to Note that if the appropriate DataSight field does not already exist you can click the Variables button and add the variable Then close the Define Variable dialogue box to return to Import Wizard Step 2 dialogue box No unmapped fields w ill be imported 14 When you have mapped all the fields click the Next button The Import Wizard Step 3 dialogue box appears 15 In Step 3 you will be preview ing the data you are importing C Demonstration DataBase RAW DatalDemo WO 7 prn Step 3 Prak th Gata thal wil be imported Date 2 07 2003 275 05 1898 27 05 1989 9 00 85 AM 20 11 2000 15 01 31 AM 1811 2001 8 00 04 AM 12 912003 8 03 05 am 25 08 1898 8 00 13 am 16 If you are happy with the data press Next otherw ise press Back and make the necessary changes 17
159. ight provides access to the conversion table allow ing the user to view and edit the table Master Variable A Level Area z ew Level 4 Variable WL m Dada Tima 81102005 index 1 A m 04082 Ke 1 A Ke 0 082 P Use conversion table Converse table Kabanga 1 Conversii hype interpolate A 0 082 Below this Conversion type allows the user to select the type of interpolation betw een the selected variable and the conversion table e Interpolate assumes a Straight line relationship and draw s a straight line betw een the points in the table e Step up method Goes UP to the nearest point on the conversion rating table to calculate the output DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Conversion Tables NOS e Step down method Goes DOWN to the nearest point on the conversion rating table to calculate the output The Step up Step dow n methods can be used for situations w here pump activation might initiate a pump that has only one speed Therefore it is either on or off To complete the conversion a formula must be entered in the Output area In this example A is the formula referring to variable A which will be interpolated against the conversion table and Calc2 is selected as the Output variable Output Formula ss A Output value ae Output variable Calc Dutput station a Same with Master Vanable Update conversion form vanabie T ea J Update database variable wu
160. ing and on the right are listed your existing DataSight variables 2 If there are variables in the left panel that do not match existing DataSight variables on the right you can add them by Clicking the Variables button w hich w ill open the Variables dialogue box 3 Link the variables to be merged by clicking on a variable on the left and dragging it across to the same variable on the right Drop it when Hlappears on the cursor Note that Date and Time which are required database variables w ill be automatically merged as part of the process and will not appear in either panel 4 Click Finish DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Information i Data has been merged A When you merge a database the merge data w ill be added to the existing data unless it has the same Level 1 Level 2 Level 3 and Level 4 and Time and Variable name Then it will overwrite the existing data amp This feature is not available w ithin DataSight Enterprise Edition See DataSight Administrator Enterprise 10 4 Exporting data 10 4 4 Exporting data from a datasheet You can export data from a DataSight Datasheet into Text Excel or HTML formats 1 In the Data List tab click on My Data expand your list of Level 1 You can view data at the Level 2 Level 3 or Level 4 level 2 Click to select the Level 2 Level 3 or Level 4 then click the DataSheet tab 3 Right click w ithin the datasheet and select Export
161. ing 3 User Adding and maintaining Password 40 Permissions 40 Using Saved Graphs 116 Using this Guide 33 V Variables 121 Adding or updating 45 Deleting 46 dependent 115 dragging 115 independent 115 Merge 47 Version Latest 3 View ing Editing Data 105 W Water Quality 194 Who this Help file is for 33 wind rose 1382 144 Window DataSight 34 Layout 34 Y Your feedback 2 61 33 39 2013 Seveno Pty Ltd Notes DataSight
162. ing data Conversion Table data or both To performregression analysis a conversion table must exist or be created The procedure for this is outlined in the previous chapter In order to carry out the regression analysis the Conversion Table must also be assigned to a station It is necessary to have some gauging information w ithin the database to complete regression analysis The procedure for entering Gauging data is covered in a later chapter DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Regression Tool NES pe eo ABN Resressen Graph contience Discharge Y When you open the Regression Tool the first thing you w ill need to do is load the Conversion Table and Gauging data P New Save C Table Gaugings E Result Setttings v Analyze A Scale Transformation Reports dx Close 1 Click the Table button on the toolbar to select the Conversion Table for analysis The user will be presented with a list of available Conversion Tables i e those that exist w ithin the current database a Faft AL Aare P M p k a lun i FTM s lee mo n L Table Name Mawson River Febz010 Mawson River Feb2010 26 02 2010 Molongio Reach Thompsons Beach Pumping Staten Select the Conversion Table you wish to use for analysis and click OK Within the Regression Tool the Conversion Table area w ill be populated w ith data from the selected Conversion Table and t
163. ing existing DataSight database variables 3 Click the Merge button ab Merge 4 Select your Source Variable you wish to merge from and click Next Source Variable Please select the scurce variable te merge Flew Rabe H PU10 mim Humidty Av 196 Humidity Hr Av 96 dex Cales Cenductivity ySJem Cumulative Distance Daly Average Flew cumecs 6 Select the Merge Options you wish to apply and click Start Merge DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Setting up the DataSight Database B Merge Variables O Merge Options Copy data from source variable only when source is not null Overwrte target variable data with source variable data oniy when target variable is null or not exist Create clone of the source variable Deletes all the data in target variable Delete source variable afer merge 7 A window stating Merge process completed will be displayed Click Done 8 7 Audit Trail It is inevitable that critical records w ithin your databases will get modified or deleted from time to time If the database system has more than one user the frequency of these events increases exponentially With Audit Trail DataSight has incorporated a solution for monitoring and recording changes to a database such as w hen data has been imported or modified or w hen data has been deleted by a user Essentially Audit Trail is a record w hich tracks and displays w ho has acces
164. is can be alphanumeric 3 Select the Index number to assign to this flag The Index is used to number flags and is useful when filtering data according to Flag index in the Datasheet DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Flags 231 4 Select an appropriate Image from the drop down menu The image is simply a visually associated icon for the selected flag 5 Assign a background colour to the flag This colour is used to highlight flagged data in the Datasheet 6 When you are satisfied with the selection click OK The new flag will be added to the list T awe T a ei ss New flf Delete Application Flags fla Close Edit a Flag 1 Double click the flag you wish to edit and make the appropriate changes For example from this Description Index Image Background Color to this DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd 21 2 ES Edit Flag Description Raw Data Import Index 3 Image Background Color Delete a Flag 1 Select the flag you wish to delete and click the Delete button on the Flags toolbar P New Application Flags I Close 2 You will be asked to confirm the delete request Click OK if you are sure Confirm OX Application Flags Flags can be assigned for automatic flagging to specific DataSight tasks gt Import Data that is imported w ill automatically be assigned this flag gt Conversion When using the
165. l metaphors com dow nload learning reportbuilder html To run the report in DataSight 1 Within the Report Explorer dialogue w indow highlight the Report template that you w ish to export to your DataSight database DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Report Explorer E Eet yew Eb ie el daa T1 Em Biome Aroa Conterts ot A Foes BAR Name a gt 2 of Recycle En 2 Select File Export to Saved Views The Report template w ill now be listed under Reports in the Saved Views panel in DataSight Design Ctrl D Print Ctrl alt P i i a Graphs Print Preview Ctri P FES Datas Er 3 Reports DataSight Variables 3 To run the report right click on the report template and select Open or double click on the report template You can then Print Preview your report ra 1 z 1 Print Preview o Bocas CES E iT pagum j tte Hat mu 4 Select File Print to choose your output Printer or Print to File DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Reports 15 Print HP PSC 2350 seres Page Range v AI Curent Page C Pages Enter page numbers nd o page page Inez separated by commas For example 1 3512 5 Select OK and then Close the Print Preview window DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Reports 152 DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Scheduler 1
166. lds that follow the main file content and describe characteristics of the file Header Headers precede the main file content and describe the length of the content or other characteristics of the file html HyperText Markup Language Files with a html file extension have been created for use within a web browsing interface such as Internet Explorer Import Spec A file that contains specified DataSight parameters for importing data including the mapping decisions independent variable A variable whose value determines the value of other variables lt is called independent because within a certain valid range any independent value can be chosen to see what the dependent value is For example in a graph of temperature at different depths for a waterbody depth is the independent variable Any depth from the surface to the bottom can be chosen to see w hat the corresponding temperature at that depth is By convention an independent variable is plotted on the x axis but with DataSight you can choose the the y axis if you wish This can be be helpful in producing depth profiles for example DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Glossary of Terms NS jpg Files with a jpg file extension are JPEG files which is a commonly used standard method of compression for graphic images The name JPEG stands for Joint Photographic Experts Group Level 1 An organizational level of data naming which will be determined by the
167. lian Drinking Water Guidelines AD have been developed by the National Health and Medical Research Council MHMAC m collaboration with the Natural Resource Management Ministenal Counci NAHH The ADVeG incorporates the Framework for the Management of Drinking Water Quality and provides the Australian community and the walter supply industry wih guidance on whal consttules good quality drinking aber The ADV include two different types of guideline value A health related guideline value which is the concentration or measure of a water quality characteristic that based on present knowledge does not resul in any signifi cant risk to the heath of the consumer over a kfetme of consumption An desthetic guideline Value which amp the concentration or measure of a water quality TESI ES n Loe IA CAT ee EA ete n J eaa E Use the menu items to create a New Standard and to Save and Delete existing Standards DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Scientific Standards 223 P New b Save X Delete You can also Rename and Delete standard w ith the right click menu items Hid Standards vi Australian Drinking Water Guidelines B MESSI a m Rename F2 Delete Del Standard Items Each Standard ltem consists of a Variable and it s Minimum and Maximum values to be applied in the specific standard Users can add any number of variables into the
168. lick on the Templates tab to show the DataSight Template This query accesses all the relevant Fields and Tables within your DataSight Database Hew Items Mew Templates Jd D atasight DataSight Enterprise version has another template DatasightNumeric has same fields w ith the first template plus numeric versions of the text variables Some of the report functions like SUM AVG etc are not able w ork w ith text variables We need to create and use text variables to be able to use below detection symbols like lt gt etc DatasightNumeric create numeric version of the text variable to make them available to use in the calculation f the content of the variable is not the convertible data it w ill be empty w ith the numeric version of the variable DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd 3 D aan Lh a Las 3 jl n lur T enc f Double click on the DataSight Template A query then runs to return the follow ing list of fields from your Database to the Data window Datasipht ReportCreator M g NE Data Cae Design Preview Pan T Sue 8 Click on the Design tab to return to the Design window 9 Click File Save to save the report template w hich now links via the data query to your DataSight database The named template w ill appear in the Report Explorer window 10 You are now ready to build your report ran access a Report Builder User s manual go to http w w w digita
169. ls Analyse Resutts Output Table I Regressionmodes Mode Model Definition R Value Res Standard Erni Model Number Model Definition Model Description R Value p Value Residual Standard Error Regression Sum of Squares Residual Sum of Squares 2 Click the Table button to load the Table List select the appropriate table and click OK DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Regression Tool Conversion Table List Tg o i E C D 4 c amp zog 3 E 3 The table w ill be displayed in the Conversion Table area as well as graphically in the Regression Graph area IE Conversion Table Regression Graph Confidence Water Quality DA DET arp E Mcr Eris Salt Maki oa wr EQ Saar p pan carceri LUST c ri Pau cua UIDES SUIS ze xum ze E iii iii iii iii kk A A A A SoS See Seal See A R a c M a Sl Sr a a a a da apa mmm iii tT o NOR S E E ih E m i iii S mee FT ree cac cc acueducto adve dx rr ad ries EE cA a OSE EVS CES A PRE EE SEE OLED CORE ez ZOE Wal t aee ze m a PS a ae ao wr adc rr Discharge Output ConvTable Unselected Gaugings o Gaugings Unselelected Regression Curve Conversion Table 4 Click the Result Settings button to apply start and end values and output increments for the regression analysis 2013 Seveno Pty Ltd DataSight Users Manual Version 2 9 4 Regressi
170. ls Export Prnt wind Wel Av km h ae WII ees USE Format Paint Circled General Marks Data Source Style Format Text Gradient Shadow v Visible je All Series Visible Dipped Style v Multi line Draw every 1 E Angle E d T E Length 9 E Wind Direction amp Average Wind Velocity 15 Minute Average m Wind Vel Av km h DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd GIS and DataSight NS 13 GIS and DataSight DataSight data is able to link directly in to GIS softw are for spatial analysis Users must ensure they have checked the SQL Views for Saved Datasheet Views boxes in the Datasheet options area of DataSight Use ers that were saved with this datasheet Use Mers that have just been selected x Prompt for fiers to use when datasheet is loaded Uy Graph Reports Look And Feel DERE E Tools Orientation Portrait i Fit To Page FR Columns To Width Second Row For Unis Show Summary V Shaw Spatial Information 4 Show Navigator Stop Lighting Me Value MEM coeur Text M Max Vee MEN coco Text F GosiVaue MEE Colour Text E Vews V Create SOL Views for Saved Datasheet Views Create Numere SOL Views for Saved Datasheet Views This will allow GIS softw are such as MapInfo and ArcGIS to view and display DataSight data The latitude and longitude or eastings northings X Y co ordinates etc for stations is store
171. lues ncipdng null valves wil replace the dala n the destination Hon null values only Select this option to copy move non nul values This option ignores al null values Move dala from variables visible in the Datasheet only The first window displayed w hen Move To is selected provides the option to either move all values for the selected record or only non null values ignoring those variables w hich contain null data The checkbox at the bottom of the option w indow also allow s the user to select to move only data that is currently being display ed in the datasheet When the user selects Next DataSight w ill request a destination location Level 3 for the data that has been selected DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd 10 5 2 DataSight Users Manual Version 2 9 4 Select destination Pease selec deshnaton Dats List e uv Dala 3 Darton Gow s 3 esc A Project A 2 13 Project ac 2 d Project L 7 Gauging Stations E Weather Stations P camp AWS El Region 1 9 Surface Water Stes Select the destination location and click Finish to move the data Copy To Selecting the Copy To function will copy the selected data from the current level in the database to a selected destination elsew here in the database All data including null values Select this option to copy move source data to a destination I1 the destination has data with same date and tme stamp al values incipding
172. n if it has already been created by ticking the appropriate check boxes 9 Choose the Name Observer and Equipment used for the Audit trail 6 If you wish you can save your MDE electronic form under Templates Click on the M to also select saved forms ip variables Wi r b aro r Click on to open the Variables Selection form DataSight Users Manual Version 2 9 4 2013 Seveno Pty Lid Variable Selection Variable List Selected Variables adjusted Leve Artem Sample Sewer Level bajir Leal Water Temo Wind Dir Select the Variables fromthe Variable List that will appear on the form using the arrow ed selection buttons Define the order of the variables on the form using the Up and Dow n arrow s to the Right of the Selected Variables List 10 Click Close and return to the Manual Data Entry Form 11 Enter data for each variable in the boxes shown Click Save 12 When you have finished entering data click Close DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd 10 3 Merging a database Merging is available in DataSight Desktop only You can also receive a DataSight Desktop database from another source and merge the data into your own database 1 Click File Database Merge Fl Edt Tocks _ Qee PM Tessera Mesgena 3 QM akesConlDatasightiBeta Dat a SampleData 45 Customer City of Wesbminasber Westminster Datasoht Data The Merge Wizard dialogue box appears
173. nage edit new button To edit the chainage double click on the chainage Chainages can be edited via Chainage details form DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd 22 2 Gauging Reports Gauging report provides summary information for each gauging chainage details and graph for Segmental Division of Cross Section and Segment Velocity Profile These are created by clicking the Reports button from the Gauging window and selecting Gauging Details or Gauging List Here is the report layout of a sample gauging summary report which is created by highlighting the gauging you wish to view and selecting Reports Gauging Details Gauging Details s E3 1 zoe 2 Canchmer 1 Seem M Sorting De mrd Time PEDO 12 000 Finish Dais mrd Tie PEDO 1325000 Easting Edge WERS CculmsonMedod Mid Section Chale Value Dep nmm nn nm LTI Mean vele Ey lz ka ngs E EIL TRAHAN AHES iiti bi kx PEPER EEE EL HT di i Sag eal die of r Sein Was T DL Figures and summary data are displayed in the same measurement units as the data that has been entered w hether that be metres cm feet inches etc DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Here is the report layout of a sample gauging list report which is created by selecting Gauging List fromthe Reports button Gauging List al ase Site A Dovwndtresn Brid
174. nd Feel Button Style Default iR Tools Colours Fanel rm Headers Header Text Splitters MEE Fitters Group Field List v Group Variables Alphabetically Fj Change the look and feel of DataSight by changing appearance attributes The default setting is Native Style w hich applies your native Window s settings To change uncheck the Native Style checkbox and use the drop dow n menus to choose Appearance Border and Button styles Filters Group Field List allow s fields to be selected from a choice of Level Date or Variable pop up menus w hen applying filter conditions When not activated a single menu will be displayed w ith all levels dates and variables listed together Alongside this checking the Group Variables Alphabetically box makes displaying a longs list of variables easy to sort through The default is a simple Popup Field List DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Setting up the DataSight Database Tools conversion General Open with last saved set a A Interpolate with master as a default E Datasheet liil Graph IE Look And Feel Tabular Reports a Use default display format for variables in Tabular Reports Show conversion summary before conversion starts amp 0 00 amp 0 00 Map Enable Google Maps Scheduler Enable scheduled tasks Changes require restart Restart application after a period of Restart after 1 hour eMail Server SMTP Details Serv
175. nd choose a statistical property 3 The values are displayed at the bottom of each relevant column of the Datasheet E Datasheet lin New Graph gt SiMen Date hu ui Sewer Ste 1 4 07 1594 wer Ste 1 4 07 1994 Qm unm o wer Sie 110711594 te 1 5 07 1894 Lr m Wer te 15 07 1954 te 11440711994 te 1 407 1924 te 1 207 1884 E zs ua GI m et in e Fw ET p oh dry DF Ur a Time Sewer Level Sewer O alf 12 00 00 AM 12 02 00 AM 12 15 00 AM 12 20 00 AM 12 55 00 AM 1 00 00 Al 1 05 00 AM 1 10 00 AM E 2 te m m Note that Null values are ignored by default in the statistical summary but you can change this by selecting Options then unselecting Ignore Nulls Null values will then be treated as zero Y ou also have the option of using only selected values for the statistical summary la Use SHIFT CLICK to select a range of values or CTRL CLICK to select individual values on the datasheet 2 Right click on the Summary Panel and select Options Only Selected 2013 Seveno Pty Ltd Viewing Editing Data m 11 5 Filtering data 1 Click TY Ex on the DataSight toolbar if it is not already active to display the current filter conditions If you had already selected a particular station using the Data tab for example you w ould see filters relevant to the Level 1 Level 2 and Level 3 that you had selected 2 You can impose more Filters to isolate a
176. nd derivatives at the supplied data points Akima spline The Akima method is also based on piecewise polynomials The Akima spline is less affected by outlying data points 19 1 Interpolation Tool The Interpolation Tool is accessed from within the Datasheet area of DataSight 1 Users should ensure the variables they wish to review are checked in the Field List and visible within the datasheet 2 The Interpolation tool will apply any filters selected in the filter panel and only display data that applies to the filter 3 Right click your mouse in the Datasheet window and select Interpolations 4 The Interpolation Tool will open DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Interpolation Tool zo 3 interpolations File Source Site M Variable M Spline Method inear M Range Stats 1 Starts Ends 0 Ends Interpolated data Add new data in between 1 and 0 5 points betwen each data points Every 1 Variable M Date Time Value 12 00 AM Source Data Spline m New Data Within the Interpolation Tool 1 Select the Site for the data you wish to review This list is limited to the sites currently viewed in the Datasheet 2 Select the Variable to be used in the interpolation Once selected the data will be displayed in the graphing area to the right 3 Select the Interpolation method Linear Cubic or Akima 4 Using either the Data Sta
177. new database Datasight Administrator is the database management tool for the Datasight Enterprise Edition Datasight Administrator can be used to create new databases for Datasight Enterprise Edition Opening a database DataSight Desktop Edition 1 To open an existing DataSight database click File Database Open 2 The Select data location dialogue box appears di Navigate to the required folder Click Ok DataSight Enterprise Edition 1 To open an existing DataSight database click File Database Open 2 Enter the logon information in the dialogue box appears Logon Authenticabion SOL Sere Authentication UserName Admin Passweced LS Remenber Password Serve SENTIMEL SQL Marnoci 3 To Connect to the Database server and Open the Datasight database click Ok me DataSight status bar show s the location of the database w hich is currently open DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Setting up the DataSight Database oa 8 3 Adding or deleting Levels 1 2 3 and 4 Add Level 1 1 With the cursor anyw here in the Data List Panel right click and select New Dada Lisi caa a Vy One Cae B iiec E ter Level 1 PR Rename Fi Level 2 x Druete Del Level 3 J Refresh F5 Select Level 1 and the Add Level 1 dialogue box appears Type in a Level 1 name Add Level 2 1 With an existing Level 1 selected right click and select New Level 2 and the Add Level 2 dialogue box a
178. nomenclature 27 Step 6 offers the chance to select a Scientific Standard to check w hether imported data is within the standard limits or not If you wish to use a Standard check the box and select a Standard from the list Otherw ise click Next 43 CADS Data RAW Datalb txt Step 6 Sect standard Scientific Standards e Use Standards Abra lan Drnkng Water Guidelines 28 Click the Finish button If your import is successful a confirmation information box will display Alternatively an Import Error Log will be displayed with appropriate error messages and options to Save Print Preview Go Back Continue or Abort the Import P When importing data if the first line in the file is Data and not column header leave First Title Line as 0 This ensures that the Input Fields as in the example above are named as Field 1 2 3 4 etc f numerical values are in the Input Fields your calculation w ill be incorrect The user can also use multiple fields to calculate a new variable For example Flow Total Dissolved Solids to give an instantaneous discharge of TDS P In Step 4 the user selects the Level 3 that the data is to be imported too The mapping of Level 3 allow s DataSight to link and save the formulas used for that specific site The Formula area is populated w ith the last used formula for that specific site This increases the speed of importing e You can save your Import Spec to use again w ith the same type of file
179. nstration DataBase RAW Data Demo Sewer xls E 16 Step 3 Preval the data thal wil be impor Time 12 00 00 AN lorng 12 05 00 AN MZE 42 10 00 4 11 07 1994 12 15 00 AN wozr89a 12 20 00 AN 11 07 1994 12 25 00 AN 11 07 1994 12 30 00 AN DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Quick Tour 1 Add your Level information You can also add audit trail information Click next 3 Demonstration DataBase HAW DataWermo Sewer xls Step 4 Eater formation r qur d lo comolat the moort Sewer Monitoring n 3 f 4i H J i T D i M E J n n DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Quick Tour NOS Perform simple calculations on your Input Fields x i C Demonstration DataRaseaiRAW Data Demo Sewer xis Step 5 Seed or enter few formula to modify Input Fields ni unda mmi i dion mm al dac ramas See omia immenso hn mdi me Hac EGLI L3 21 AE XXE UR Dada 2 eh A m e MUN ny a a T E US MN FI HAM A F Tare S Kek ememr e ee ee eee Las ad Ww T ML e Kew input Field Tick the box above the Input Fields to perform a conversion on your input data Y ou may also add New Input Fields to store the calculated data in a separate Variable Field from that of the raw data Once the conversion has been completed DataSight w ill remember the conversion and will deliver the last formulae
180. nul values wil replace he dala n the destination Hon null values only Select thia option to copy move non null values This option ignores all null values Copy dala rom variables visible in the Datasheet only The first window displayed w hen Copy To is selected provides the option to either move all values for the selected record or only non null values ignoring those variables w hich contain null data The checkbox at the bottom of the option w indow also allow s the user to select to copy only data that is currently being display ed in the datasheet This allow s the user to only copy data from selected variables to another location in the database When the user selects Next DataSight w ill request a destination location Level 3 for the data that has been selected 2013 Seveno Pty Ltd Select destination Feast select desinalon Data List E Wy Cate 2 e Carton God E esc gt A Project A 3 Project AC M Project L E Gaugng Stations Z Weather Statens p Camp AWS 2 Regin 1 A Surface Water Stes a 4 Select the destination location and click Finish to copy the data DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Viewing Editing Data 105 11 11 1 Viewing Editing Data You view data in tabular form in the Datasheet To view data in a Datasheet 1 Select the Data List tab Click next to My Data to expand your list of Level 2 You can view data at the Level
181. on Tool 196 X value start from X value ends at Increments Increments at each step Number of increments The user can elect to Automatically set start and end values the regression tool w ill use the low est and highest values in the data as the start and end values check the Use these values button and enter values manually Enter a number of Increments at each step of the regression or enter a total Number of increments for the regression analysis 9 Click the Analyse button to select the Regression groups and carry out the analysis In this example the Polynomial regression models are selected C Single Term Intercept Three Parameter Convex Concave Users can also click the New button to create and edit their ow n Regression group from the in built Regression Models 6 When you are satisfied w ith your selection click OK The regression analysis will be completed using your selected models and the results displayed to the right of the Regression Tool window DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Regression Tool 197 RE Value v Res Standard Erri 10 a x 10 b x 8 c x B d 0 899712 3 a x 3 b x 2 c x d 0 86138 252327 2 Model Definition a x 3 b x 2 ctx d Model Description Third Order Pohynomial fo R Value 0 965137832144
182. ore for most stream flow rating tables a second point should be inserted before the origin Such as 2 and 0 The fable wE then assume that al data below zero aad past 2 vill have regul of zero Exam ple 3 Converting Depth to Flow using a Conversion Table 1 Ensure you are view ing the data you wish to w ork w ith in the Datasheet w indow Right click and select Conversions 2 In the Conversions w indow select the appropriate Level and Variable for Master Variable A these should be the depth measurement location and depth DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Conversion Tool 179 Ensure you also check the Use conversion table box 3 Select the appropriate Conversion table from the drop dow n list Gauging Sations Lumwana East En Variable Depth M H atekTime 9 05 2008 5 14 58 AM index 1 a A s 0 423 Ke 1 A Km 0423 15 Use conversion table Conversion table Demo Rating Table Conversion type intenpolate A 0 42 4 When completing conversions using a Conversion table the Formula entered can simply be A or a Output Formula gt a Output value laa je SEEI Output variable Flow Rate msec E Output amon g Same with Master Varabe o Update conversos form variable V Update database variable B Update data DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Conversion Tool 10 16 3 4 Completing a Conversion 4 Flow Duration Curves To establish
183. ou are only have one copy of DataSight running Use the Windows Task Manager to confirm 2 Check that no one else is concurrently connected to the DataSight Database 3 Ensure you have enough free hard disk space on your machine 24 2 Printing Issues If you see the message Default Printer not set or Cannot Print to screen or other similar errors check that your Printer s are setup correctly 24 3 Importing Issues If you see the message box Error uj Cannot proceed to the next step Please check all import options and bry again Check that all import options e g File type Date Delimiter etc are appropriate to the file you are importing If you get the error message User var not found during the import If you are using an Import Spec check that all variables defined in the Import Spec are present in your DataSight Database If you see the message box Error h Error Not enough disk space on drive C Please free some more disk space or set the Temp Data Path to a different location in the Options Click Tools Options then select General 2 in the Temp Data Path box type or navigate to a new drive location 3 Click OK DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Troubleshooting 6 If you receive the error DBISAM Engine Error 11013 Access denied to table C Program Files DataSight Enterprise Temp TempEvent DAT It is essential that a DataSight user has a
184. pleting a Conversion 4 e 180 4 Converson Formulas dad 182 17 Conversion Tables 187 1 Applying Conversion Table to Updating Existing Data 191 2 Using Conversion Tables uni 192 18 Regression Tool 194 RO GIESSION ero tee ect ia 194 2 Analysing Water Quality relationships using the Regression Tool 194 3 Analysing hydrographic relationships using the Regression Tool 203 4 Ii rule 211 19 Interpolation Tool 219 Icio Meec m nm 219 20 Scientific Standards 222 1 Scientific Standards Introd ucllOh conor os peo eus asa e eco eo Toe ER Ee uIe Y EE a Fe PR esp an Us na Eo so anu ais 222 2 Using Scientific Standards ion 224 21 Flags 230 1 Setting Up Plagio da 230 2 APplicaton FOSA deena ooo oo 232 9 USING FlagS cius ioi osi eo EU RCRiN DI aRar Rana iarba 233 Hags in the Datasheet uidelicet eos petia a da e ade s aO SAIS noha Sea RI ao ode Stu nsec ane E ao Mud MUI 233 Flags ithe Conversion TOON eec 235 Flags and Data Oualil m 235 22 Gaugings 237 1 Gauging Calculator iii 237 2 Gaudging Reporis skautem E 242 23 Plug In Modules 244 o R o a 244 24 Troubleshooting 245 1 General r nning ISSUES iii du ob ou es ABB Gite ete ieee oo AS 245 2 PINUNO jE Ko 0 E ZR SSS enr 245 3 uUEL I I qee 5
185. ppears 2 Type ina Level 2 Name Add Level 3 1 With an existing Level 2 selected right click and select New Level 3 and the Add Level 3 dialogue box appears 2 Type in Level 3 name or code Add Level 4 1 With an existing Level 3 selected right click and select New Level 4 and the Add Level 4 dialogue box appears 2 Set the new date Delete Level 1 Level 2 Level 3 or Level 4 With the appropriate item selected right click and select Delete A confirm dialogue will display advising that any child data attached to that item w ill also be deleted Click Yes DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Setting up the DataSight Database as 8 3 1 Audit Log DataSight has an Audit Log of database configuration changes that occur when renaming and deleting Levels Saved View s and Import Templates This enables you to track changes you have made to these components E a Delete de Close Drag a column header here to group by that column Date Time ne User Name Computer Name Log Type 15 05 2013 7 45 17 PM SENTINEL carolyns CAROLYN TS Level Renamed 8 4 Adding and Updating variables 1 Click the Settings button on the menu bar and select Variables Datastpht The Variables dialogue box appears show ing existing DataSight database variables Tw o default variables must alw ays be present These are Date and Time and they will alw ays be greyed out so that they cannot be
186. pping functionality means that you can accurately define and import all or a subset of input data values DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Filtering is a quick and easy w ay to define then import a subset of data You can use filtering to import only the row s that meet the criteria you specify for a particular column or columns Filtering input values Click at the head of any data column to display a list of filter options Standard options are All Custom Blanks and Non Blanks The other options are any of the unique data values within that column Note that the Blanks and Non Blanks options are available only if the column you w ant to filter contains a blank cell Use To return All all row s Custom all row s meeting the criteria you specify for that column Blanks only the row s containing blank data values in that column Non Blanks only the row s containing non blank data values in that column Unique data value all the row s containing the specified data value in that column Custom filtering using specified criteria Click at the head of any data column and select Custom The custom filter dialogue box appears Custom Filter Show rows where Click the first arrow to display the drop dow n menu options for filtering either numeric and text values Select a filter condition then enter an appropriate value in the box on the right If you need to find values that share some characters
187. ragging left or right 3D must be enabled before this option is active Toggles a 3D perspective on and off Opens the Graph Properties dialogue box Floating and Docking a Toolbar 1 Click in any part of the grey area in the toolbar then 2 Keeping your finger on the mouse button drag and drop the toolbar to a new location w here it w ill float or 3 Drag and drop the toolbar to the extreme right or left of the screen to dock it on that side r4 If the toolbar is floating double clicking the Title Bar at the top of the toolbar panel w ill restore it to its previous docked location Right click menus DataSight provides right click menus for accomplishing your most common and frequently used tasks The options display ed on the right click menu vary depending on w here you are w hen you click Security The Security feature is imposed by w ay of a passw ord on the DataSight database This is first allocated by the user called Admin w ho is alw ays a member of the Admin Group Only the Admin User has this pow er in addition to the general Admin Group pow ers For this reason you are prohibited from deleting the Admin User DataSight comes w ith 2 default User Groups Admin and User While both Groups can have access to the database only members of the Admin group can set up and maintain Groups and Users For this reason w e recommend that you restrict membership of the Admin Group to just the default Admin User in order to bett
188. rface Wa Befresh Gauging l Control Documents ie Map In the Level 3 Properties area select the GIS Information tab Within this area you may enter the Longitude and Latitude of a Level 3 along with any associated information DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd When you have done this you can select the Map tab and view the location geographically DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd 10 Data This Chapter covers importing adding merging and exporting data 10 1 Importing data Before importing data ensure you check the default Import options under the Options via the Settings menu 10 1 1 Importing spreadsheet files 1 First look at the file that you wish to import the data source and check that the data variables you wish to import already exist in the DataSight database If not you can choose to add them before you begin Alternatively you can add them in Step 2 of the Import process Check that your spreadsheet contains a Title Row for all the data fields you wish to import If not add titles for your columns as it will make the subsequent mapping process much easier Before starting the import process close the import file 2 Click Eb Import Or Open the File Menu and Click Import on the DataSight Toolbar File Edit
189. ries box is unchecked left click on the variable you wish to edit in the graphing window This will select it and display a dotted line around the label RH Ely Avg 151 Sol Rad Hely Avg mz Temp Hrly Avg Degrees C Line Area Left click on the drop down menu next to Type and select Bar ose This will display the data for the variable selected 10 RF Hrly Tot in Bar chart format Left click another variable within the graphing window and alter it to be displayed as an Area graph For this example So Rad Hrly Avg DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Advanced Options Close the Advanced Options toolbar Click the Graph Properties button on the toolbar Alternatively right click anywhere within the graphing window and select Properties This will open the Graph Editing window Editing Char Series Data Tools Export Print Series General Axis Tiles Legend Panel Paging wais 3 lix F RH Hip val Mil J Sa Rad Hri Avg ewm lix F Temp Hip Avg Degrees C The first thing you can alter within this window is the graph colours so they are all easily visible when they are displayed within the one chart Select the Series tab Chat Series Dats Tools Export Print 10 RF Help Tot ram li Ba 10 RF Ha Tot ill Formal Stack General Marks Data Source She Rectangle Bode Pattar Color Each Bor Mid 70
190. rithm Logarithm Model Group Name Logarithm Polynomial Logarithm Polynomial Second Order Logarithm Logarithm Polynomial Third Order Logarithm Fourth Order Logarithm Fifth Order Logarithm First Order Inverse Logarithm Polynomial Logarithm Polynomial Logarithm Polynomial Inverse Polynomial 2013 Seveno Pty Ltd Regression Tool 212 Model Number 50 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 45 46 47 48 49 50 50 51 52 Formula a b x a b x c x 2 a b x c x 2 d x 3 a b x c x 2 d x 3 e x 4 a b x c x 2 d x 3 e x 4 f x 5 a b log x a b log x c log x 2 a b log x 4c log x 24d log x 3 at b log x c log x 42 d log x 3 e log x 4 at b log x c log x 42 d log x 43 e log x 44 f log x 45 log x a 1 1 a x ex p x a x a a 1 x 1 x a 1 1 x a log a b x a x b a b x a exp b x a exp b x exp a b x a b x 1 b x x a x b 1 a b x a 1 b x a x b a 1 x b a b log x a b log x 1 a b log x a xMb x a x b x a x b x a b x a b x ab a b 1 x x c DataSight Users Manual Version 2 9 4 Model Name Hyperbolic Model Second Order Inverse Third Order Inverse Fourth Order Inverse Fifth Order Inverse First Order Inverse Logarithm Second Order Inverse Logarithm Third Order Inverse Logarithm Fourth Order Inverse Logarithm Fifth Order Inverse
191. rsion Tool If you require more than one variable select Add Variable at the top of the Conversions screen Variables Master Variable A Users must select specific Level and Variable information for the Variables which have been added for use in the conversion calculation Time Shifting Time Shifting can be used when an error is found in the data For example on installation a sensor may have no error However after 6 months deployment there may be a 1096 error in the sensors measurements By using Time Shifting selecting the Start and End Offset amount percentage the DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Conversion Tool 171 user can adjust the data proportionally over time It is important to note that Time Shifting assumes that the error is linear and undertakes the calculations using this assumption Conversion _ interpolate with master variable Time shifting Start Offset End Offset Type is Formula amp Output Output Formula gt Output value Output variable Output station Same with Master Variable F Update conversion form variable F Update database variable Index ip Update data The Output area allows a formula to be entered and an output variable to be selected and updated Update conversion form variable the output is within the conversion tool This allows the user to simply update and store the output within the conversion tool so as not to change
192. rting e You can save your Import Spec to use again w ith the same type of file Click the Save button and the Save Spec dialogue box appears Type in a description and click Ok DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd 10 1 2 Importing other delimited files 4 File La New Ld cave ey Print ld Preview A Exit First look at the file that you wish to import the data source and check that the data variables you wish to import already exist in the DataSight database If not you can choose to add variables before you begin Alternatively you can add them in Step 2 of the Import process Check that your file contains a Title Row for all the data fields you w ish to import If not you may wish to add titles as it w ill make the subsequent mapping process much easier Before starting the import process close the file w hich is to be imported F Click 55 import Or Open the File Menu and Click Import on the DataSight Toolbar Edit Tools Help cave AS Datab ce P The Open Dialogue box appears In the Look In drop down menu select the folder containing the data file that you wish to import In the Files of type drop down menu click to select Text files csv txt then click the file name and click Open kin C RAW Data fz Demo WO Lii The Import Wizard Step 1 Dialogue box appears DataSig
193. rting When you add a variable you can define its unit of measurement type size and format see 7 4 Adding and Updating Variables J Variables M elete Ru cos Vanatie Descripten unes RA ee La ate LE 7 as Tima MenterngTeme Austed Laval Air temp Ar Temperature Comments Comments DO Dasha Oxygen Eva Evapalransoraton Hired ity Percentage Humidity 4 Lab D Lab Same D MU Turbidty Ck O CR 0 o CR amp op0 00000 0 Note Laboratory data that contains or may contain a prefix such as lt to denote that measured value is below detection limits should be mapped to an appropriate variable w ith the field type set as TEXT DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Quick Tour NON 9 3 Quick Tour Importing Data Now you are ready to import your data using DataSight s Import w izard File Edit Settings Tools Help Print Preview Database k Exit Look in E9 RAW Data oeno Fue ade Bd Demo WO los SH Demo Multiple Sites xis E jDeno Rants xis 20 Demo River sds Demo Sewer Time Problem xis B Demo Sewer xls Ries af type Excel Files ds i a Open a4 read only Just select your existing data file In this example it is a spreadsheet DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Quick Tour n Then set the data formats and w here the data to be imported starts and stops before selecting Ne xt E E
194. rts and Ends display or by selecting points within the graphing window you can select the data start and end points for the interpolation to occur Left click your mouse to select the start point right click to define the end point DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Interpolation Tool 22 3 interpolations File New b Save New Data Points Selection ts Close Source ste Variable Battery Volts M Spline Method Akima 7 Range Starts 18 1 09 2009 5 00 00 PM Ends 35 2 09 2009 6 00 00 PM Interpolated data Add new data in between 1 and 112 5 points betwen each data points gt Every 1 Variable Battery Volts M Date amp Time Value 4 18 1 09 2009 5 00 00 PM 11 5 19 1 09 2009 6 00 00 PM 11 4 z 20 1 09 2009 7 00 00 PM 11 4 21 1 09 2009 8 00 00 PM 11 4 22 1 09 2009 9 00 00 PM 11 3 23 1 09 2009 10 00 00 PM 11 6 24 1 09 2009 11 00 00 PM 114 1 09 2009 1 09 2009 2 09 2009 2 09 2009 3 09 2009 3 09 2009 4 09 2009 4 09 2009 5 09 2009 5 09 2009 25 2 09 2009 8 00 00 AM 12 7 26 2 09 2009 9 00 00 AM 127 arco Data Spine a Now Data 27 2 09 2009 10 00 00 AM 11 8 Interpolated data o Enter the existing data points between which you wish to create new data points 6 The user can define the points to be created by the interpolation tool a enter the number of points to create between each existing data point b enter the number of points to be cr
195. s Type any information or copy and past images relevant to the station DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Setting up the DataSight Database s Name Camp AWS Properties Staton Comments GS information Construction Detads audRlog pA x D f A k P B Barometric Pressure Sensor replaced May 2009 Appendix E i Whew Ar Rel G Clear G oa Tampere SET Bhp Raley Horas SET Rad Pine Purple Siya Relenerce AG Elach Poe Grou kly Crags Pour Control C1 Clear Shana O GRE e e Tesla Weed teed mj xz AS BOZP VY bey uum jan an can am ars cam gs arae La n am i it TLLA rt LI bi Y amm rn il A ra b i IIT A a s mm m 4 Click on the icon The Add Link dialogue box appears Once linked press Ctrl Left mouse click to follow the text link to a w ebpage file etc 5 Click on the window The Find dialogue box appears Type in the text you wish to find in the Station Comments DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Setting up the DataSight Database os Find what Find Next Match whole word only Direction Cancel Match case C Up Dom 6 Input your GIS information for the site Longitude Latitude and Altitude information boxes are also present for additional information relating to the site locality aa RR ERN a E q E E n a m Longitude Latitude Al
196. s is not already displayed A list of the data fields variables will then be displayed in the Field List panel Click to select an independent variable and drag and drop it close to the outside of either the x or y axis As it moves the cursor will change to J indicating a drop on the x axis or l indicating a drop on the yaxis Since you can only ever have one independent variable axis active at a time on the same graph repeating the process with a different variable or to a different axis will overwrite your original independent variable selection As soon as your independent variable has been dropped a grid displays dividing the graph into four area panels Click to select your first dependent variable series and drag it onto the graph If your independent axis is x the cursor will change to or P that you are about to plot the dependent data series on left or right y axis Alternatively if your independent axis is y the cursor will change to or y indicating that you are about to plot the dependent data series on the upper or lower x axis You can continue to plot any number of dependent variables by dragging and dropping The default Graph Type is Line but you can change this by right clicking on the open Graph and selecting Advanced Options to display the Advanced Options panel You can also control a whole range of Graph formatting options by right clicking on the Graph and selecting Properties Bt dependent variables dif
197. s start and stop When importing a spreadsheet you must import and parse each worksheet separately so use the Sheet drop dow n menu to select any w orksheet 6 If you have already saved an Import Specification for this type of file and w ant to use it click the Load button Click to select the appropriate specification and click Open This will load the parameters including the mapping decisions that have been saved for that specification Continue to press Next to preview and move through each subsequent import step Otherw ise 7 Set the appropriate Date Format Time Delimiter Date Delimiter and the Decimal Symbol formats 8 Use the scroll arrow s to set the First Title Row and Number of Title Rows will appear next to the first and last Title Row lines in the data panel if there is no Title Row leave the Title Row at 0 9 Scroll dow n the data panel and identify w here the data starts Position the cursor on the appropriate line number in the data panel and left click This will set the position of the First Data Row and P will appear next to that line in the data panel Any values above this row apart from any set Title row s will be ignored in the Import process Continue to scroll dow n the data panel and identify w here the data stops Right click on the appropriate line number in the data panel to set the position of the Last Data Row and P will appear next to that line in the data panel Any values below this line will be
198. s w ith a sample database so that you can try the range of DataSight features before you import your ow n data The DataSight database is configured in 4 tiers consisting of 1 Level 1 appropriate Level 1 may be Geographic Area s Project Area s Client s Catchment Area s etc 2 Level 2 in the case of Level 2 Water Quality Data Weather Station Data or a specific project within an area w ould be appropriate 3 Level 3 the name or identification code relating to a particular monitoring site or location e g monitoring station name 4 Level 4 the date of a Sample Event A Sample Event is an occurrence of sampling on a particular day Each Sample Event consists of data relating to the variables measured The sample database supplied w ith DataSight comes configured w ith some common variables My Data zm E City m gt BH Sewer Monitoring P Sewe Site 1 11 07 1994 E 2071997 BA 3407 1997 47 1987 momig P 8 07 1997 A 407 1997 10 07 1997 7h 41 07 1997 T izora A 13 07 1997 Eh 14 07 1997 Rural BE Catchment 1 F Ranfal Staten P Srema 5 Water Quality DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Quick Tour 5 2 Quick Tour Database Variables When you are ready to create your own database simply add your own variables to customize the DataSight database The DataSight variables correspond to the field names of the data that you will be adding or impo
199. sed and edited data from w hich computer system and w hat operations the user has performed at that time This information can be displayed under Level 3 Properties as an Audit Log Biy Das eB nemen umi E Hanfai E Veeather Date P FF BD Rename Fi M Delete Del di estres PS 13 Eropertes F12 PU Gonbral Documents The Audit Logs tab displays information related to changes to Level 3 data such as imports conversions using the Conversion tool and w hen data is deleted DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Setting up the DataSight Database o rubu B Raton Comets OE informac Avil Lope rmz m tue header here 1o group by Pal cohen Cola Tona w Liar Hama 2510000 3 1 04 P A 11 25 65 a0 A RODEO d TO D JUN A 170000 P As you can see the Audit Log records the date and time of the event the user who was logged in to DataSight at the time the Computer the user was using and the type of activity that user completed The Audit Log also records details for the event including any related variables conversions etc If you click the Details icon for a specific event a window detailing the activity is displayed in the Audit Log Details window This can be useful when attempting to recover lost or accidentally deleted data as full details of the data are retained such as those show n below and these can be copied to the clipboard P Audit Log
200. selected Gaugings Gaugings Unselelected a x 3 b x 2 c x d Output Residual Sum of Squares 199 2636958720 Deis Developing a Water Quality Conversion Table Continuing w ith this example w e can develop a conversion table modelled on the measured w ater quality results 1 Select Model number 3 Third Order Polynomial 2 Zooming in on the the low er end of the graph w e can identify the curve that lines up suitably w ith the existing measure points Regression Graph Confidence Models Analyse Results Output Table l Regression Models Mode Model Definition V 10 a x 10 b x 9 c x 8 d 9 a x 9 b x B c x 7 d 8 a x B b x 7 c x 6 d 7 a x T b x 6G c x 5 d 6 a x 6 b x 5 c x 4 d 0 97401 5 a x Seb x 4 c x 3 d 0 97397 4 3 2 1 Water Quality a x 4 b x 3 c x 2 d 0 96819 a x 3eb x 2 c xed 0 96138 l a x 2 b x c 0 95643 a x b 0 76349 Model Number 3 Model Definition a x 3 b x 2 c x d Model Description Third Order Polynomial R Value 0 9613782144 p Value 0 0000000000 0 1 2 3 4 Residual Standard Error 2 8232158676 Regression Sum of Squares 4960 0963041280 Conversion Table ConvTable Unselected Gaugings Gaugings Unselelected a x 3 b x 2 c x d Output Residual Sum of Squares 199 2636958720 Details DataSight Users Manual Version 2
201. sers Manual Version 2 9 4 2013 Seveno Pty Ltd Quick Tour Especially pow erful is the data profiling functionality Just drag and drop data fields to use as axes or series onto the graph panel You have full control over the formatting of the graph including being able to stack graphs 2 DataSight File Edt Tools d RANA Be Region 1 sutomatic weai FE 1012003 A 201 2002 T aonaid 1 4 01 2003 P 5012003 B emi2003 1 r I Saved Views 3 j Graphs Ex Datasheets Reports i Field List E y Varables DateTime Date Time Adjusted Level NE Air temp Deg C v Comments E DO ima Evan men E ke 351 DataSight Users Manual Version 2 9 4 it 9 TEN Forty 6 e Siogle Seria o c d hon 0038 records where E E n 7 m ll der LN i id a B Air tero Des C 2 Bag dux ay 2013 Seveno Pty Ltd Quick Tour 25 You can scroll up and dow n successive sample dates and the graph changes dynamically DataSight File Edt Tools Hel uer dime em id My Data eB cry B cimae F Lon EE Tt Region 1 z Y FF Automate West A wow2003 M B N 20102003 Go speer a e elect eei d 3012003 m i T 4012003 d 512003 T env2003 u 2 Bagi du any a E ac Humidity X kr L E L k E O E d EX E EGER Sa m Z ER ROR OR unm on Ejip variades v DateTime Date O ates
202. sign Users to Groups Clear any User passw ords including the Admin User s DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Getting Started a 7 4 2 1 Adding and maintaining Groups and Users You must be a member of the Admin Group to maintain Groups and Users Groups 1 Click Tools Security User Accounts on the main menu 2 The Users and Groups dialogue box opens 3 Click the Groups tab 4 Click the Name drop dow n box to view list of existing Groups 5 Selecting any Group w ill display a list of members in the panel below then To Add a Group 6 Click New and the Add Groups dialogue box appears 7 Type in a Group name and click OK or To Delete a Group Select a Group 8 Click Delete 9 If the Group has members a w arning message will appear asking for confirmation of the Delete 10 If the Delete is confirmed any members will be unallocated from the Group and the Group w ill be deleted Users and their membership of Groups Maintain Users 1 Click Tools Security Accounts on the main menu 2 The Users and Groups dialogue box opens 3 Click the Users tab 4 Click the Name drop dow n box to view a list of existing Users Then Add a New User 1 Click the New button and the Add User dialogue appears 2 Type in a User name 3 Allocate a passw ord to a User at this stage by typing in a passw ord in the passw ord field and again to verify You can also leave the passw ord field blank 4 Click
203. ssword Type the old password in the Old Password Type the new password in the New Password and Verify fields Click OK 7 4 2 4 Setting User permissions within DataSight Enterprise DataSight Enterprise has added security features The access permissions are the final stage in setting up security on your database The Administrator or Users within the Admin Group can allocate access to specific areas w ithin DataSight Enterprise DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Getting Started NN 1 Click Tools Security Permissions on the main menu 2 The Users and Group Permissions dialogue box opens User and Group Permissions F iren mmml amp e x e II cs amp 4 4 x X gm amp l i itt sttt amp t w v gt I e iw al Li Li 3 Click the User or Group in the User Group Name w indow 4 Set the permissions in the Object Name w indow by ticking the appropriate check boxes r4 The Administrator should NEV ER release the Admin User Name and Passw ord as the Admin User Name and Passw ord are identical for Microsoft SQL Server The users should be provided separate passw ords The users w ill retain the last group privileges that they have been allocated even if the group has been deleted All users should be allocated to groups DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Getting Started 2 7 4 3 Who s Logged On You can identify any current users of a
204. store Column Defaults Summary Panel With the cursor anyw here in the datasheet right click and toggle on or off Summary Panel to see the Summary Statistics Navigator Panel With the cursor anyw here in the datasheet right click and toggle on or off Navigator Panel pe gt m a a Scroll backw ards or forw ards through the data jump to the start or end of the datasheet or lock on to a row of data in the datasheet and navigate back to this point at any time Stop Lighting With the cursor anyw here in the datasheet right click and toggle on or off Stop Lighting e When you save a Datasheet the column configurations are also saved r4 The Datasheet Add Remove column display should be changed at the Level 2 level and this setting w ill be applied dow n to the Level 3 and Level 4 level Column heading order may be changed at any individual level DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Viewing Editing Data no 11 4 DataSight Users Manual Version 2 9 4 Summary statistics Use DataSight s QA QC feature to calculate and display the follow ing statistical characteristics of a datasheet Available statistics are 7 Average value Count Minimum value Maximum value Standard Deviation Sum Display statistical values on a datasheet 1 Right click anyw here in the Datasheet and check the Summary Panel option 2 Right click on the Summary Panel at the bottom of the Datasheet panel a
205. storing your Stream Gauging Measurements and for calculation of the Total Discharge The calculation of the discharge from velocity and depth measurements can be made in several w ays Mid section method uses averages of the mean velocities in the verticals and of the w idth of the sub divisions Mean section method uses the mean velocities and depths at the subdivision point DataSight Gaugings are related to the Level 3 in a DataSight database Each Level 3 item has it s ow n Gauging storage and can be accessible through right click menu item at Level 3 P Mew Il Rename F2 ml Renam Delete Del X Refresh F5 Properties Fl Control Documents DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Gaugings Stream A File Edit New fli Delete Report z Close Gaugings ID A Description Starting Date amp Time Time Discharge Velocity All the Gaugings related to the specific Level 3 User can be seen in the main gauging form Main form show s Gauging list and some of the details for each gauging To create new Gauging click New button All the properties of the Gauging including Description Starting and Finishing Date and Time Gauging Method and Starting Bank can be changed DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd 21 04 2010 Start Gauge Height 6 0000 Finish Gated Tine 2104 2010 Finish Gauge Heaght 0 0000 Method af Gauging Mid Section Method v Water Edge
206. subset of data that you are interested in Filters comprise tw o options Condition options and Bracket Options AE Series a Choose records where is GA ion gt Condition Options Conditions have 3 parts 1st part is the Field selected from a list of possible options 2nd part is the Descriptor a description of the relationship betw een the Field and the Value 3rd part is a Value For example in the statement x is less than 3 x is the Field is less thanis the Descriptor 3 is the Value To impose conditions 1 Click in the line marked Click here to add new condition 2 Click the 1st part and select a field 3 Click the 2nd part and select a Descriptor 4 Click the 3rd part and select or type a value Repeat this process to add more conditions List of possible conditions is nit equal to is less than is less than er equal to greater than greater than or equal to i rad is et ist is between Last yes s Last veais Last day s Last hais Last miz Last pects Last month s is not nul ik rot im 1 is not between Conditional Filtering using Relative Date Time values DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Viewing Editing Data 112 You have the option of filtering using Relative Date Time values e g you could look at Temperature values for the last 3 months Relative Time options are available by selecting Date to which you can then
207. t Regression Sum of Squares 5018 6884336005 Residual Sum of Squares 140 6715663995 9 Select the Analyse Results tab to display the results of the selected model 0 4 0 597979797979796 3 53164625268889F 02 4 55757575757576 0 60026697553137 4zrrrrrrrrrrrrz A FARMA 4d oe 10 Highlight the values you wish to move across to the Output Table right click and and select Copy Selected Into Output In this example generating the Conversion Table this is the points w ith a discharge value below 4 5 DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Regression Tool Regression Graph Analyse Results Water Quality 0 4 2 18976880813371E 02 0 597979797979798 3 53164625268889E 02 0 795959595959596 5 02316005051147E 02 0 993939393939394 6 66233215123558E 02 19191919191919 8 45027863001525E 02 0 103899593129958 0 124856179187315 0 147424976286055 0 171666869179179 0 197650347588645 0 225451063220665 0 255151642194708 0 286841670160431 0 320617802091593 ATATATATATAT1T 0 35658396795555 3 36969696969697 0 394851656672573 3 56767676767677 0 435540267643794 3 76565656565657 0 478777523514046 3 96363636363636 0 524699940759013 4 16161616161616 0 573453356716093 0 625193513149414 m r NEC m k n E ZAGAEGAGAGAEAEE nee AONE 20729 ee yo Se T m i r e mao oo oo o d AS eb RS ep 11 The Output Table w ill be displayed in the grap
208. t Type Wind Direction 96 M Begining of the 1 10 2009 M End of the period 31 10 2009 M 4 Click Next o Select the Sites required for the Wind Rose report and click Next DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Levels Double click to select Level 1 Level 2 or Level 3 to report EE Euro Weather Station STP AWS E 4 H E Reservoirs HE Sewer Manholes 4 84 STP Flumes H E Water Supply EE Weather Station PA p Brou Tip AWS e P STP AWS i P Tuross Head AWS Variables Select Variables Variable List Selected Variables Rainfall A Wind Dir Av summary Types Select functions and report summary types 1p VariableName Site EurobodallaShireCouncil Weather Station STP AWS 8 Select the Output Type PDF Excel direct to Printer etc Enter the file location and filename if required DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Ouput Device Select one of the output options Io Print Setting pira Colaton Station List RIF m Show pnt dialn 4 POF Save Options C HTML Save each report into a separate fie LT 0 Create a separate fie for each collalion group Excel Create one file for whole report Note at this last step the user can also elect to _Save Template to use the template at a future date 9 Upon clicking Next the report will be created Reports List of created tabular teports
209. ta from raw to scientific units for example Step 5 is activated by ticking the box above the Input Fields The Input Fields column is populated C Demonstration DataBase RAW Data Demo WO 7 prn Step 5 SECI OF deter nrw formula fo modify Input Figa Calculated Input Fields v Use Calculated input Fields baut Fields Formulas New out Fieid Next gt Type in the conversion for the given Input Field you wish to modify in the appropriate Formula cell This will place the modified data into the variable field that was mapped for that input field in Step 2 Leave blank if there are no calculations Alternatively add a New Input Field The Add New Input Field dialogue box appears DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd C3 Add New Input Field 0 nput Fee Inout Field Name Mapped Wands Defaut Vale 25 Type in your new Input Field Name Choose a variable to map the new data to from the drop down menu for Mapped Variable Note that a different variable from that of the raw data should be used if both the raw data and modified data are to be imported This variable must already exist w ithin the variable table prior to Step 5 If not please return to Step 2 and create the new variable Insert a default value if you wish Click Ok 26 Type in the conversion for the New Input Field in the corresponding Formula cell Include the input field name s already present in the table and use standard mathematical
210. tasheet a Prompt for filters to use when graph is loaded lisi Reports amp Look And Feel Orientation Portrait M V Fit To Page imi Tools Appearance F 3p oom 30 15 Rotation F Elevation Orthogonal Horizontal Offset Angle 45 m Vertical Offset E e E cun E b al E E ES m E m Perspective Walls Panel Colour Defauts Left wall B Visible Transparent E Right wall Visible E Transparent E Bottom wall Visible Transparent E Back wall Visible Transparent Change Filters Reports and Default appearance of graphs Filters When selecting a saved graph you can elect to alw ays use the filters that w ere originally saved w ith that graph or use the new filters that have just been selected in the filter panel or prompt w ith the above 2 options Reports Change the page orientation and toggle the Fit to Page options for any graph w hen output as a report Appearance Alter the graph s appearance including displaying 3D and Orthogonal effects and the related zoom rotation elevation and offset aspects of these settings Walls Alter the colour and visibility of the graph s panels and w alls Look and Feel DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Setting up the DataSight Database KO Options Look and Feel 4 General Use Native Style Y F BE en Appearance Ultra Flat M FS Datasheet lil Graph Border Style Ultra Flat v 2 Look A
211. ted Date as the Field Type then you can leave the Format box empty and the default date will be as per your Window s date setting Otherw ise you can type a different format w hich will override the default A Data that contains or may contain a prefix such as lt to denote that measured value is below detection limits should be mapped to an appropriate variable w ith the field type set as Text Note In DataSight Enterprise once the field type of a variable is saved as Text it is not possible to changing the variable field type from text to numeric Deleting variables prae w Ie gt Click the Tools button on the DataSight toolbar and select Variables The Define Variables dialogue box appears show ing existing DataSight database variables Click to check the Delete checkbox es against any variable s that you w ish to delete Click the Delete button Click the Save button at any point to save changes and continue otherw ise w hen you click the Close button you will be prompted to save your changes dw the variable that you intend to delete has been used as a series dependent variable or axis independent variable in any created graph you will get a message asking to confirm the delete DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Setting up the DataSight Database 8 6 Merging variables Click the Tools button on the DataSight toolbar and select Variables 2 The Define Variables dialogue box appears show
212. tercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept 2013 Seveno Pty Ltd Interpolation Tool NS 19 interpolation Tool The Interpolation Tool provides users with the ability to construct new data points within the range of a discrete set of known data points The interpolation tool accessed by right clicking within the Datasheet is a graphical curve fitting feature using spline interpolation to perform functional interpolation operations opline interpolation divdes the selected data range into small subintervals and each of these is interpolated using the third degree polynomial DataSight s Interpolation tool provides the following Spline types linear spline cubic spline and Akima spline Linear spline The linear spline simply involves forming consecutive data through straight lines using existing known data points Cubic spline A cubic spline curve is a piecewise continuous Curve passing through each of the known values The resulting curve includes a separate cubic polynomial for each interval with matching first and seco
213. tercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept 2013 Seveno Pty Ltd Regression Tool NS Model Number 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 Formula aD 2 546 x3 a b x 2 54c exp x a b x 2 54c x 5 og x a b x 2 54c log x 2 a b xA2 5 c x log x a b xA2 B c xA 5 a b x 2 54c log x a b x 2 5 c log x a b xA2 5 c x 5 a b x 2 5 c log x x atb x42 5 c x a b x 2 54c x 1 5 a b x 2 5 c log x xA2 a b x 2 54c x 2 a b x 2 5 c exp x a b x 3 c exp x a b x3 c x 5 log x a b x 3 4c log x 2 a b x3 c x log x a b x 3 c x 5 a b x3 c log x a b x 3 c log x a b x 34c x 5 a b x 3 c log x x atb x43 c x a b x 3 c x 1 5 a b x 3 c log x x 2 a b x 3 c x 2 a b x 3 c exp x a b exp x c x 5 log x a b exp x c log x 2 a b exp x c x log x atb exp x c x 5 a b exp x c log x
214. thly Daily Basis O Monthly Hourly Basis standards Exceeding data 1 04 2005 Ww Begining of the period End of the period Standard 1 08 2007 w Australian Drinking Watts Standards Exceeding Data report is show every exceeding data for selected variable s A sample output of the report looks like this Vanable pH Standard Australian Drinking Water Guidelines Minimum 6 5 Maximum Monitoring Date amp Time Value Drinking Water Crib East 1 02 2003 00 00 AM 102003 10050000 AM Drinking Water Crib 3 6031988 9 00 00 AM 10051809 8 00 00 AM 3 t0 2000 39 00 00 AM 2004 2001 900002 AM 141 2002 9 00 06 AM 416 2002 9 00 12 AM B10 2002 0043 AM 272003 900048 AM 02003 10 40 00 AM 5022006 39 00 00 AM Drinking Water Crib 7 32 1568 300000 AM SAM 1999 9 00 00 AM 308 1550 9 00 00 AM scientific Standard Report 1 01 1999 1 01 2007 11 09 2000 74112000 2104 2001 304 2001 14052001 9 00 00 AM 800000 AM 00 02 AM 8000009 AM 8 00 00 AM 9 00 00 AM 9 00 00 AM 5 00 01 AM 5 00 01 AM 00002 AM 20711 AM 8 00 12 AM BD 11 AM Sc 11 00 AM 7 00 00 AM 7 00 00 AM 10533 PM 7 00 00 AM 3 00 00 AM 8 00 00 AM 80000 AM Monitoring Date Time Value dro a a a S 0 Db go OR OR Ob OD DO O0 DO CO CU O DD OB OO P 0 CO DO CM J p Seog Standards Summary Report is very similar to Exceeding Data report It will create a report displaying exceeding data and add statistic
215. ting variables 46 Using 169 Delimited files Conversion Tool Introduction 157 Importing 81 Conversion Tool Overview 162 Copying data 101 Copying Graphs 117 E Copyright Noice d Editing data 106 Create and View Graphs 115 Discharge 180 Editing or deleting data in datasheet 105 Creating a new database 43 Example Graphs 121 csv files Importing 81 Exporting Issues 246 DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Index 25 Exporting a database 99 Exporting data 99 Exporting data from a datasheet 99 F Feedback 2 Fields Mapping 74 Filtering data 111 Filtering using Relative Date Time 111 Fixed width files Importing 88 Floating and Docking a Toolbar 37 Flow Duration Curves 180 Functions ABS 182 ATAN 182 CEL 182 CofV 182 COS 182 COSH 182 COTAN 182 DISCHARGE 182 EXP 182 FLOOR 182 INDEX 182 INTPOW 182 LN 182 LOG 182 LOGN 182 MAX 182 MEDIAN 182 MN 182 NVAL 182 POW 182 PVAL 182 RANKASC 182 RANKDSC 182 SIGN 182 SIN 182 SQR 182 SQRT 182 STDEV 182 TAN 182 TIMEDIFF 182 TRUNC 182 VARIANCE 182 DataSight Users Manual Version 2 9 4 Ga Gauging 194 203 Gauging Reports 237 General running issues 245 Get the the latest version 3 Getting Started 34 GS 138 GIS Information 69 71 138 Glossary of Terms 248 Google maps 69 71 Graph 115 3D 36 Advanced options 119 Copying 117 Creating 115 Default formats 61 Depth Properties 36 Move 36 Rotate 36 Series 11
216. titude 2432222 FT 252 Lattude info z X eo y kinem Ez eme e M24 134 22 41232 56 213 222 435 262 1435 This GIS information can be linked to MapInfo and other GIS softw are for use in mapping and spatial analysis 7 The Construction Details area allows construction details of individual stations to be recorded DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Setting up the DataSight Database s e stertDate we FinishOste e Station installation 7 03 2008 8 03 2008 Temperature Sensor Vaisala WXTS10 LE IR M Young Barometric Pressure Vaisala PTB 110 Rain Gauge Tipping Bucket 05mm ENNEN 8 The Audit Logs tab displays information related to changes to Level 3 data such as imports conversions using the Conversion tool and w hen data is deleted as w ell as other configuration changes for import templates and scheduled tasks They keep date and time username and computer name information about the activity as w ell as the all the details of the activity For data import records inclusion of the specific w orksheet w ithin an Excel file that w as the source data sheet DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Setting up the DataSight Database se jemertone 1 43 18 PM 28 07 2009 10 59 34 au a8m7 2009 120220 PM As pA
217. to write to the default paths as displayed in the above window please change the paths in the Options window DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Setting up the DataSight Database KO Import Set default formats for all import files e Date format MDY DMY etc e Date delimiter e Time delimiter e Decimal symbol e The default file type to search for when importing files please note this does not limit the type of files for import simply the type of files DataSight will see first e Copy an import summary to the Window s clipboard automatically Under the Calculations options the user is also able to define the saved defaults for calculations which will be carried out during the Import process e Use previous Level 3 formulas checking this option will allow DataSight to remember the calculations carried out on the Level 3 previously and present these to the user when similar files are imported to this Level 3 e Create new Input Fields automatically checking this option w ill allow DataSight to remember the Input Fields used previously for this Level 3 station e Sorted formulas list sorts the Input fields alphabetically Options Defaults J General Date Format OMY M Hi Import H Datasheet lial Graph IE Look And Feel Decimal Symbol Date Delimiter Time Delimiter Lal Tools File Type Excel Files xls Copy Import Summary to clipboard Copy source file into Control Documents
218. tted and define w here the data values start and stop If you have already saved an Import Specification for this type of file and w ant to use it click the Load button Click to select the appropriate specification and click Open This will load the parameters including the mapping decisions that have been saved for that specification Continue to press Next to preview and move through each subsequent import step Otherw ise 7 Click the Fixed Width radio button Set the appropriate Date Format Time Delimiter Date Delimiter and the Decimal Symbol formats 8 Use the scroll arrows to set the First Title Row and Number of Title Rows will appear next to the first and last Title Row lines in the data panel if there is no Title Row leave the Title Row at O 9 Scroll dow n the data panel and identify w here the data starts Position the cursor on the appropriate line number in the data panel and left click This will set the position of the First Data Row and P will appear next to that line in the data panel Any values above this row apart from any set Title row s will be ignored in the Import process Continue to scroll dow n the data panel and identify w here the data stops Right click on the appropriate line number in the data panel to set the position of the Last Data Row and P will appear next to that line in the data panel Any values below this line w ill be ignored in the Import process 10 Click the Next button The Import
219. type of data you are working with In the case of freshw ater quality data for example an appropriate Level 1 may be Lakes Rivers Reservoirs etc Level 2 The first Data grouping level with Level 1 being the organizational level For example in the case of freshw ater quality data an appropriate Level 2 may be the name of a particular w ater body Level 3 The defined physical point at which data is collected This forms the 2nd level in the hierarchy of data grouping underneath Level 2 and contains Level 4 data Level 4 An Level 4 is an occurrence of data sampling which occurs at a Level 3 Each Event Level 4 is differentiated by its date parse To define something in an orderly w ay In DataSight parsing the data enables DataSight to identify the different features of the data eg Title Row Number of Title Rows etc pdf Portable Document Format Files with a pdf file extension are created for easy document exchange between users Documents can be view ed in the free Adobe Reader program rtf Rich Text Format Files w ith the file extension rtf are created for easy document interchange as most word processors are able to read and write rtf documents Text Qualifier Denotes that a text value is enclosed within eg the data field Blue greens within a text qualifier of double quotes identifies the value Blue greens as a text value rather than say a numeric value txt Files w ith a txt file extension are text fil
220. u or double click the Add Scheduler Task icon and the Edit Task dialogue box appears Edit Task Active Description Email Task Type Graphs File Type Graphic M File Mame C Users test Desktop E mail Demo pg V Ovenwrite File at Recurrence Do not create output file if na data Create Report Title v Email File Email Subject Bad Hecipient s radsceisentinielpl com au carelynsceYsentinelpl com When Send email every time scheduler runs the task Send email every time scheduler runs the task Item Mame Rainfall Alva Send email ONLY when there 15 data Send email ONLY when there is N data b Due Date 15 05 2013 M Due Time 20 37 00 Frequency Hecurrence Eius JS Every Day Dal 0 Weekly Regenerate task 5 Minute s M alter completed O Monthly Include Weekends P 2 Check Active to make the task enabled and running Uncheck to disable the task Tasks scheduled to run once w ill be inactive after one run 3 Type in a Descriptive name for the task 4 Use the Task Type drop down menu to select either Graphs Datasheets Reports Calculations or Email Documents B Select File Type from drop down list 6 Enter the File Name with the destination folder T If you are scheduling the recurring creation of a the report you can select to overw rite file at recurrence A if you select this option note that each time a report is generated the new output w ill overwrite the
221. u do the calculation Consider the details below while you are working with the Conversion Tool Each DataSight variable added into the Conversion Tool is represented w ith corresponding variable letter in the formula The first variable is a Master variable and named by A additional variables are named B C etc Conversion Variable Formula Representation Master Variable A Aora Examples A A B A 2 3 B For example If the user enters A into the formula box the conversion tool will return the value of Variable A as the result Datasight implemented variables There are also some DataSight Implemented variables for use in the Formula area presentation Minimum Value of Master Variable A series Maximum Value of Master Variable A series AVGA Average Value of Master Variable A series Total Value of Master Variable A Series DISCHA RGEA Total Discharge Value of Master Variable A series Further functions include calander usage such as DAILYSUM DAILYAVG WEEKLY SWUM WEEKLY AVG MONTHLY SUM MONTHLYAVG YEARLYSUM YEARLYAVG DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Conversion Tool m You need the add the corresponding letter for the variable to the end of these formulas for the conversion to complete such as DAILYAVGA WEEKLYSUMB YEARLYAVGC etc DAILY SUMA Daily Sumary Total Value of Master Variable A series DA NO BEEN Average Value of Master Variable A series
222. unrestricted unless and until another passw ord is allocated by someone logged in as the Admin User Allocating a Security password 1 Click Tools Security Accounts on the main menu 2 The Users and Groups dialogue box opens 3 Click the Passw ord tab and note that the current user is Admin Users and Groups Users Groups Password 4 Type a password in the New Password field then type it again in the Verify field and click OK 5 That passw ord will then be required for the Admin User the next time that DataSight is opened m Passw ords are attached to Users and are not case sensitive e Group Privileges override individual privileges Individual users w ill continue to have a specific group s privileges even if the group has been deleted All users should be transferred to a new group is a group is deleted Admin Group permissions DataSight comes w ith two default User Groups Admin and User There is one existing default member of the Admin Group the user called Admin While both the Admin and User Groups can have access to the database only members of the Admin group can set up and maintain Groups and Users For this reason w e recommend that you restrict membership of the Admin Group to just the default Admin User in order to better control the integrity of the system Despite this you may still add other members of the Admin Group if you wish Admin Group Users can Add and Delete Groups Add and Delete Users As
223. version Table to a Station Once the Conversion Table has been created it can be assigned to a station specific Level 1 Level 2 Level 3 location so that it can be compared w ith stream gauging data individual discharge measurements and used for regression analysis 1 Select Assign to Station from the File menu 2 Within the Assign Levels window click the New button 3 Select the Station to assign the conversion table to then select OK m Benthics HHE Fauna Studies fe Zooplaniten a Dust V ontorng B eBAM Stations vetecrologica m Ran Gauges E E Weather Stations B Nome Von orng A Staton One Surface Water Montong m E Bathymetry JE Gauging Stations P Bridge A F Bridge B F Bridge C Mawson River Pr Molonglo River Junction P Mida River P Stiring Creek P Test F Tuggeranong Creek P upper Weston Creek E hind Hydrolab Users can assign multiple stations to one Conversion Table by selecting New from w ithin the Assign Levels w indow Updating existing data Once the Conversion Table has been created and assigned to a station specific Level 1 Level 2 Level 3 location it can be applied to the existing data Period of Applicability needs to be assigned to be able to update existing data DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Conversion Tables NON 17 1 Applying Conversion Table to Updating Existing Data Conversion Tables can be applied to existing data Existing d
224. w hether text or numeric use the like or not like options in conjunction with either or 95 Use To stand in for underscore any single character e e g 8 will find 81 82 83 8B etc e e g 8 willfind 845 87A etc e eg T_ will find TP TN T3 etc percent any number of character e e g 8 will find 81 82456 8B etc e e g fish will find fish fished fishing fishA1 etc To add another criteria click AND or OR and repeat the previous step 12 In the Step 2 Dialogue box low er panel you will map your input fields to your DataSight database fields DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd C Demonstration DataBase RAW DatalDemo WO tet Step 2 Mas naut falda to DataSignt Gaida Saton Dale Time b Staten 1 207 2003 3 03 49 Station 1 27 05 1999 5 00 08 Station 1 27 05 1999 9 00 55 Station 1 200112009 01 31 Station 1 19 11 2001 8 00 04 amp xten 1 15 01 2003 9 07 05 PUDE T T pee MR Sabon Data D ae gt TR pH Day of Year DateTime 13 The left column lists your Input field names Click in each adjacent line in the right column to access the drop dow n list and select an existing DataSight field to map each Input field to Note that if appropriate the DataSight field does not already exist You can click the Variables button and add the variable Then close the Define Variable dialogue box to return to
225. window f Click on the icon The Add Link dialogue box appears 8 7 1 3 Level Control Documents The Control Documents panel provides a comments text box that can be used to store information relevant to all or the majority of data in the database 1 Right click on each level in Data List A pull down menu will appear Catchment 2 F E Air Quality Bt El New Level 2 2 Click on Control Documents The Control Documents window appears DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Setting up the DataSight Database so Control Documents Raw Water File New ff Delete Close Level 2 Level 3 Field Description Link File Name Start Date End Date Details Attachment 3 Type in your rich text comments in the editor or create links to other documents on your computer or netw ork 8 8 Control Documents Control Documents provides an area w ithin DataSight for document management w ithin your database Itis accessible via the Tools menu or by right clicking on a specific Level 3 DA Audit Trail Access via the Tools menu A lp Variables If Control Documents are accessed via the Data Quality Codes Tools menu it will display the general control E Standards documents for the database you are currently Conversion Tables using Stovky Toolbars Check for Update la Schedule Report Creator Plug ins A Show Tip
226. x log x c x log x a b x log x c x 5 a b x log x c log x a b x log x c log x a b x log x c x 5 a b x log x c log x x a b x log x c x a b x log x c x 1 5 a b x log x c log x x 2 a b x log x c x 2 a b x log x c exp x a b x 1 5 c x 2 a b x 1 54c x 2 og x a b x 1 54c x 2 5 a tb xA1 5 c xA3 a b x 1 5 c exp x a b x 1 54c x 5 og x a b x 1 5 c log x 2 DataSight Users Manual Version 2 9 4 Model Name Group Name Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept Two Term Intercept 2013 Seveno Pty Ltd Regression Tool 215 Model Number 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151
227. your datasheet and click Save The Datasheet together w ith its filters and column configuration w ill be saved DataSight Users Manual Version 2 9 4 2013 Seveno Pty Ltd Viewing Editing Data a A Datasheet Properties file is created with any saved Datasheet and records the user who created the Datasheet and its creation date If the saved Datasheet is subsequently modified the Datasheet Properties w ill be updated to show the relevant user and date it was last modified The Datasheet Properties w ill also show any tasks that are scheduled to run using that datasheet To view the Datasheet Properties 1 Right click on the name of the saved datasheet and select Properties Properties Properties Name AMS 1 52003 Created By Admin Mrs Fi Created Date 24 01 2008 2 47 PU Modified By Admn Modified Date 14 03 2008 3 10 FA Next Run Tima Last Run Time DataSight Users Manual Version 2 9 4 2013 Seveno Pty Lid Graphs L 12 12 1 Graphs Create View Graphs To create and view graphs of your data 1 With the Data List tab selected click on My Data to expand your list of Level 1 You can create graphs at the Level 2 Level 3 or Level 4 level Click to select the Level 2 Level 3 or Level 4 then select the New Graph Tab if this is not already active If you do not already see a blank graph template click 1 New Field List ES Click on the DataSight Toolbar to toggle the Fields List view if thi

Download Pdf Manuals

Related Search

Related Contents

  利用規約をダウンロード  Gigaset N720 DECT IP Multicell System  TVman Auto_User Manual_Ver1.10  TP3 \(molécules\) - Sciences physiques et chimiques  WIRELESS ALARM MONITORING User Manual V1.2  SISTEMA DE TEATRO EN CASA CON REPRODUCTOR DE  Philips SCF690/47 Data Sheet  

Copyright © All rights reserved. Failed to retrieve file