OilLabData User Manual
Contents
1. 4220 DT CO1 A AIR COMPRESSOR A 0 05 08 2008 04 06 2008 13 05 2008 06 04 2008 03 03 2008 05 02 2008 07 01 2008 20 DT CO1 B AIR COMPRESSOR B p 1297520 1292705 1291709 1289714 1287102 1286318 1285105 20 DT C01C AIR COMPRESSOR C 4 20 DT C101A FREON COMPRESSOR A f DT C 1018 FREON COMPRESSOR B P1 SCREW COMP A 08 09 2008 1300514 AB 05 08 2008 1297520 AB 04 06 2008 1292705 AB 13 05 2008 1291709 AB 06 04 2008 1289714 AD 03 03 2008 1287102 AB 05 02 2008 1286318 06 07 01 2008 1285105 2 DT C101C FREON COMPRESSOR C 2 DT C101E FREON COMPRESSOR E 28 DT C101F FREON COMPRESSOR F 20 DT C2014 LP RE INJECTION COMP A 4 28 DT C2018 LP RE INJECTION COMP B 20 DT C201C LP RE INJECTION COMP C 2 DT C202A HP RE INJECTION COMP A 20 DT C202B HP RE INJECTION COMP B 20 DT P08B FIRE WATER DIESEL ENGINE 28 DT P08B GB FIRE WATER DIESEL ENGINE 2 P206A GLYCOL STORAGE PUMP A 20 P206B GLYCOL STORAGE PUMP B 80 A7 NITRIC ACID PLANT H E Imports THE WEAR RATE IS STABLE OIL COLOUR DARK AMBER WATER HAS INCREASED AND IS VERY HIGH PLEASE NOTE THE OIL WAS TOO GASSY IMPLIES TOO MUCH FREON IN OIL CAN YOU REMOVE IT 2 CHECK MEANS OF WATER REMOVAL IF APPLICABLE IF THIS ISN T POSSIBLE CHANGE THE OIL TO REMOVE THE CONTAMINATION WE WILL OBSERVE THE NEXT SAMPLE BEFORE FURTHER COMMENT RESAMPLE AFTER A MONTH TO MONITOR The Trend tab is the primary source for Sample r2. Each level has an ID and Description field of various lengths The items are alphabetically sorted according to the ID field Each database level has a color coded alarm gauge The alarms are rolled up the tree so that the higher levels display the worse alarm level For the example above the level for the most recent sample is rolled up to the Point This level is equal to or worse than the other points under this Machine so the alarm is rolled to the Machine level There other Machines under the area with worse alarms so the Sample alarm is not propagated further OilLabData MJR Technologies LLC 5 By right clicking the mouse on any level of the Database Tree a menu can be displayed E E webdb saa dal TEST NE S DT CO pee E 88 DTe Edit ce DTCO Delete SY DTC1 Preview fees of DTC S DT C101C FREON COMPRESSOR C 47 20 DT C101E FREON COMPRESSOR E For example selecting Add at the Area level will display a menu to add a Machine ad Add Equipment Description OK Cancel Selecting Edit will display a screen similar to the Add that will permit modification of the selected level ID and Description Note If you are using an import technique that automatically creates the database structure the ID field should not be modified For example if the Area ID A1 is changed to A2 the next time data is imported for Al the level will not be found and Al and its Machines and Points will be recreate
3. will depend on the current selection on the database tree All Samples at and below the selection will be exported This applies to the Import tree also For example by selecting the Month level all sample data imported for that Month would be exported Save As The name of the file that will contain the exported data Export Format e CSI Generic zip using the Lab Unit ID as the key for data import e Area Equipment Point zip codes as keys for import This option automatically creates the Area Equipment or Point in the target database 1f they do not exist Note DB Name must be provided e Comma Delimited output data separated by comma s DataFilter Check the Enabled box to limit the export to the tree selection and Sample dates that fall on or within the selectable Start End dates ta will be imported into the Oil Reference database OilLabData MJR Technologies LLC 16 Setup Report Global Report DB Trend Data 1 0 Setup Customize Reports Company Name Company Name Address Address gt gt gt Address Address gt Telephone Telephone EMail E Mail Logo Bitmap eyaurtogo jpg al Report Footer O Data i i es S Large Logo Customize Global Report Settings Report Global Report DE Trend SQL Server Seventy Labels Reports can be customized with your desired contact information The Report Global settings are stored in a configuration file and apply to
4. C01 A AIR COMPRESSOR A 20 DT C01 B AIR COMPRESSOR B Iron 20 DT C01C AIR COMPRESSOR C Q DT C101A FREON COMPRESSOR A f DT C101B FREON COMPRESSOR B P1 SCREW COMP A 08 09 2008 1300514 AB 05 08 2008 1297520 AB 04 06 2008 1292705 08 13 05 2008 1291709 AB 06 04 2008 1289714 AD 03 03 2008 1287102 AB 05 02 2008 1286318 06 07 01 2008 1285105 f DT C101C FREON COMPRESSOR C 2f DT C101E FREON COMPRESSOR E DT C101F FREON COMPRESSOR F 74 20 DT C2014 LP RE INJECTION COMP A 28 DT C201B LP RE INJECTION COMP B p DT C201C LP RE INJECTION COMP C DT C202A HP RE INJECTION COMP A 20 DT C202B HP RE INJECTION COMP B 20 DT P08B FIRE WATER DIESEL ENGINE 2f DT P08B GB FIRE WATER DIESEL ENGINE 22 P206A GLYCOL STORAGE PUMP A Q P206B GLYCOL STORAGE PUMP B 188 A7 NITRIC ACID PLANT Imports E E FF EEE EE E IOUS ZUUG lt m 3 Contamination Chemistry Right click on a parameter name to display a detail trend plot The lt and gt buttons will display the previous and next parameters Holding down the shift and left mouse button will move the plot The Crtl mouse combination will change the axis scale Alt mouse will allow you to select a box Releasing the mouse button will plot the selected region When Finished is selected the display returns to the Trend spreadsheet OilLabData MJR Technologies LLC 10 Sample Trend Report s
5. LEJ En H ad hol J zH TET E ERIRE ZIT AaB rak iT me ii m E LE ziyi pr Man aii 10 E a Limam a ME Till itt Ei al IKJ liE AR TEET ee eer E an Database E A A a dE e E 3 pi LE TIT OEPS e bs i ps as Tree q aaa Ele pitido ma de de A A ee a Ap ai FETE LT F T AL Faft CUTE VJ n x all i 5 A m 5 i P ete A so ie re LE y LT var ath a i LA HTA LL Ee FT E LA r AM a AA La THU TIL I Irim LERN AA Ml ra reat fa es wE am rr be 117 TT art BB osa 14 Te Ali Zu LL E ide ia LA E erm ara edam E Pate L Du Ju 1d rr Bd teas abate Tk an nea If ge mi IT 7 Bd ewer ee due wal WL LL EE HET Hei HAL A T6542 Pd TE MENT Te 1E I E As KD E a ries arene a ig ae me i rea ge uy TT an A Ba Eo A E eed ER CS 4 Td wie aa Pieter ThE TM rm 1m a TT Li E peo Fina A ne Er Gen it 17 nie El RA 1135 mM I Haz E DA bu Thi EE Hie LL BJ eee labia ae pia np pr r TT a Y AECA epa ie VN E En En ml Til xT E kai a EAT LE L TEZ LL ae E i oP a a g E a both EFS TS cen A TT er e Plas oe r de ml Splitter too Sub tab Information Window Information Window The Information Window will display data depending on the Main Tab selection Sub tab selection and possibly the Database Tree OilLabData MJR Technologies LLC 4 Splitter When moving the mouse over the Splitter the mouse will change to a vertical bar with arrows pointing to the left and right At this time the left mouse button can be pressed an
6. OilLabData User Manual January 2010 OilLabData MJR Technologies LLC igor e AS 3 HOW FOUS TMS MANU Alai 3 Ol ab Data SOTMW ale iii ida 4 MAGNO GUC OU O EA 4 E O Ea A 4 Program La dl A ee eae een een ey 4 A O ei eee 9 B VA Berean terete te te Serene cee keer o tee were awe heer Ee Oe 15 N 17 OilLabData MJR Technologies LLC 2 Introduction How To Use This Manual This manual describes the operation of OilLabData software Manual Conventions These conventions are used throughout this manual to call attention to the adjacent text Note The Note paragraph indicates special comments or instructions OilLabData MJR Technologies LLC OilLabData Software Introduction The OilLabData software 1s used to store retrieve analyze and report oil lab sample test results Installation Copy the setup exe and OilSetup msi to a temporary directory Execute setup exe accepting defaults or entering preferences as desired After installation the setup files may be deleted or archived for future use Program Layout Dropdown Toolbar iain Tabs Menu E dida rl a EE La eei naj A AO Waa sae AAA AA AT DP 2a RD TE l E sae ee Ya ma Dak ERG aca Sc O O kalis O a L da Fl AER ue a WAN E PNTA TE Wot AH FNE Bl oor 1rd meee 1 ai TLR E ee D AEM litil Te ers gt abaa Bd arara Llame Td 1340 15 18 ltda IEA CA JE i atid E Tal Dds E Bi I Ti HE a a ekee MEE Leet ZA ZU
7. all databases Report DB settings are stored in the database and apply only to the current database When generating reports the existence of DB settings are checked first and used if present Large Logo will generate a large logo that covers the address information OilLabData MJR Technologies LLC 17 Trend Trend Data YO Setup 3 Alarm Colors M Trend Plot Display All Samples Last wz Since Date 01 01 2006 Display Plot Alarms Report Global Report DB Trend SQL Server Server Seventy Labels 3 Alarm Colors will change the alarm colors on the tree cell and reports to 3 levels from the original 5 For 3 color magenta becomes red and cyan becomes yellow Trend Plot Display can be used to reduce the number of data points plotted This may be desirable 1f the quantity begins to obscure the trend or 1f data becomes too old to be relevant e All All data points are displayed e Last Enter the number of data points to display e Since Date Data since the entered date will be plotted Display Plot Alarms will display the data point using its alarm color OilLabData MJR Technologies LLC 18 SQL Server Trend Data 1 0 Setup SOL Server if Use SQL Server Database Server Name ROSTOSKYHOME SGLEXPRESS SQL Server and Windows Authentication mode SQL Server account for SQL Server Authentication mode User Name rostosky Password et O epot DB Trend SQL Ser
8. d Selecting Delete will delete the selected level and all sub levels in the database A confirmation prompt will be displayed before this operation is carried out Import Tree There is an Imports level at the same level as the Database The Import tree is used to conveniently review sample results without having to locate samples in the database hierarchy Each time data is imported a Batch is created under the Year Month and Day of the import If more than 99 samples are present new Batches are created as necessary If the same Sample data is imported multiple times multiple Batches are created Note The Imports tree is solely for the convenience of the user Once import data has been reviewed the Import construct may no longer be useful As with the Database tree the levels of the Import tree can be OilLabData MJR Technologies LLC 6 deleted Deleting Import tree items will NOT delete the Sample data Only the Import link to the Sample is deleted ae webdb Hal TEST NEW CUSTOMER Year Month de Day F de 19 Batch E 16 o co BO 1 7 2008 1285101 PQ 4 6 2008 1289710 ow DO 6 4 2008 1292701 ow BO 17 2008 1258102 Sample DO 4 6 2008 1289711 n DU 6 4 2008 1292702 ow BO 1 7 2008 1285103 BB 4 6 2008 1289712 DO 6 6 2008 1292703 co DE 12 6 2007 1276301 DE 1 7 2008 1285104 Action Required Tree There is an Action Required level at the same level as the Database The Action Required tree is use
9. d SQL Server Severity Labels Sample labels may be customized by selecting the desired fields The barcode may be omitted if the lab cannot interpret the embedded Area Equipment Point information The Cust ID value is assigned by the oil lab Report Global Label dimensions may be set by typing in the fields or selecting the up down arrows Try printing on scrap paper as it may take several iterations to determine the proper dimensions Note The label dimensions are for sheet labels only Settings for single label printers should be set through Windows Preprogrammed labels can be selected from the Labels dropdown list Verify that the dimensions will work for your label printer combination before printing large quantities If the Windows default printer is not used for labels the label printer can be selected with the Label Printer button OilLabData MJR Technologies LLC 22 Misc Trend Data I O Setup Display New 150 parameters Report Global Report DB Trend SQL Server Seventy Labels Misc The Misc sub tab 1s used for miscellaneous program settings Display New ISO parameters will replace particle count descriptions such as Cnts gt 2 Cnts gt 5 Cnts gt 15 with new ISO equivalents Cnts gt 4 Cnts gt 6 Cnts gt 14 OilLabData MJR Technologies LLC 23
10. d the width of the database tree can be adjusted Release the mouse when the desired width has been achieved This width will be stored and used for future program activation Main Tabs The Main Tabs are used to switch between the major program features For example the Trend tab 1s used to view the sample data and generate reports The Import tab is used to import or export data to from the database Setup tab 1s used to set miscellaneous configuration parameters Sub Tabs The Sub Tabs further divide the functions and displays of the Main Tabs Database Tree The Database Tree 1s the primary mechanism for navigating the database structure The tree can be expanded by icon 66 66 selecting the plus icon and collapsed by selecting the minus Database E webdb Area gt figll TEST NEW CUSTOMER H S DT CO1 A AIR COMPRESSOR A 6 20 DT CO1 B AIR COMPRESSOR B H 0 DT C01 C AIR COMPRESSOR C Sp DT C1014 FREON COMPRESSOR A MEF YF SCREW COMP ow WD 6 4 2008 1292704 wo BQ 5 13 2008 1291708 BB 4 6 2008 1289713 BE 3 3 2008 1287101 18 2 5 2008 1286317 lt lt GG 1 7 2008 1285104 BB 1246 2007 1276301 DT C101B FREON COMPRESSOR B pH P1 SCREW COMP JB 6 4 2008 1292705 JB 5 13 2008 1291709 18 4 6 2008 1289714 BE 3 3 2008 1287102 A AA a rt ee Machine Observe that the top level of the tree 1s the Database followed by the Area Machine Point and Sample
11. d to conveniently create a to do list without having to locate samples in the database hierarchy Samples may be added to the Action Required tree by right clicking a sample and selecting Action Required Note The Action Required tree is solely for the convenience of the user Once action is taken right click the sample under Action Required and select Delete Deleting Action Required tree items will NOT delete the Sample data The Sample is only removed from the Action Required list E Es Action Required lt lt DE 1 7 2008 1285106 o B 4 12 2008 1290236 ow UG 6 4 2008 1292715 OilLabData MJR Technologies LLC 7 Main Menu ba OilLabData oilcheck i p Open Database Create Database Printer Setup Exit Various drop down menu items may be selected from the Main Menu by left clicking the menu and item Options to open and create a database are available along with items to change printer settings and exit the program Toolbar Toolbar items can be invoked with a single click of the mouse If the mouse hovers over a toolbar item a brief tool tip description is displayed From left to right the toolbar items are Open Database Print Report Preview Report Close Report Preview and Save Report to PDF File OilLabData MJR Technologies LLC 8 E ad 412 FREON COMPRESSORS A12 FREON COMPRESSORS DT C101B FREON COMPRESSOR B P1 SCREW COMP
12. e WEB DB 2a A12 FREON COMPRESSORS der SCREW COMP fA heslo Beaia da Selecting the Preview button from the Toolbar will display the Sample Trend Report in a preview window The Sample displayed depends upon the Sample selected on the tree The selected Sample is the leftmost Sample on the report followed by the up to 4 prior Samples If the Point is selected the most recent Sample is considered the selected Sample The comments and vector summary are for the leftmost Sample Also the Plot data starts at this Sample The number of data points plotted depends on setting on the Trend sub tab of the Setup tab The report can be printed or saved as a PDF file with the toolbar buttons Select Close from the toolbar to return to the trend display OilLabData MJR Technologies LLC 11 Wear Contamination Chemistry Sub Tabs Trend Data 1 0 Setup TEST NEw CUSTOMER DT PO8B FIRE WATER DIESEL ENGINE P1 ENGINE CRANK AIUI 01 Mm y Wear Contamination Chemistry Selecting the Wear Contamination Chemistry Sub Tabs displays an array of trend charts for the selected category As with the Sample Trend report the number of data points plotted depends on setting on the Trend sub tab of the Setup tab OilLabData MJR Technologies LLC 12 Wear Contamination Chemistry Trend Report Wear Trend DT P08B NEW CUSTOMER i 12162007 642008 Selecting the Preview button from the Too
13. e import batch by selecting the batch and the Preview button Navigation keys on the preview allow for quick review of the reports Note Up to 99 samples on 99 pages may be included in this report Selecting Print will queue all pages to the printer OilLabData MJR Technologies LLC 14 Data I O Import Tend Data 1 0 Setup Import Type Generic File Import File CACHO LabData OilLabData binDebug OilCheck zip Import Into Al Databases Start Epor The Import tab allows you import test results from your oil analysis lab Status messages along with any warnings or errors are listed as the import progresses Import Import Type Currently supported import formats Import File Select to browse to the file that 1s to be imported Import Into This can be used with the Lab Unit ID method of import to limit the search to the current database instead of all databases Start Click on the Start button to begin the import process OilLabData MJR Technologies LLC 15 Export Trend Data l0 Setup Save As Format f CSI Generic C Area Equipment Point DB Name C Comma Delimited Date Filter Enable Start a End al r e Start Cancel Import Export Export can be used to create a text file with the Sample test results Status messages along with any warnings or errors are listed as the import progresses Note The Samples exported
14. esults This screen will update depending on the item selected in the Database or Import tree Results are displayed at the Point Sample and Batch level For other levels the screen will be empty If comments are present and Sample is selected from the tree the comments will be displayed at the bottom of the screen Samples are arranged according to sample date from left to right Note You may modify editable fields such as Unit Usage Oil Usage Oil Added and Comments by selecting them with the mouse and typing the new values The Sample Date and Sample may also be modified by right clicking the Sample and selecting Edit If you wish you can also add your own comments to the reports This can be useful for recording oil and filter changes or 1f you want to add specific information for management and production personnel Your comments are automatically saved when you enter them The cells of individual parameters are color coded according to the alarm level assigned by the lab Additionally parameters have been assigned to the Wear Contamination or Chemistry category The highest alarm level 0 100 range and color for each category is rolled to the summary Status rows OilLabData MJR Technologies LLC 9 Detail Trend 4 OilLabData C Program Files OilLabData WEB DB mdb Jak Trend Data 1 0 Setup fig 412 FREON COMPRESSORS DT
15. lbar will display the Sample Trend Report in a preview window The number of data points plotted depends on setting on the Trend sub tab of the Setup tab The report can be printed or saved as a PDF file with the toolbar buttons Select Close from the toolbar to return to the trend display OilLabData MJR Technologies LLC 13 Sample Trend Report at Batch Level File Help 1285101 1289710 1292701 1258102 1289711 1292702 1285103 1289712 1292703 B8 12 6 2007 1276301 8 1 7 2008 1285104 BB 2 5 2008 1286317 AB 3 3 2008 1287101 BQ 4 6 2008 1289713 AQ 5 13 2008 1291708 10 6 4 2008 1292704 8 12 6 2007 1276302 8 1 7 2008 1285105 fi 2 5 2008 1286318 _ 10 3 3 2008 1287102 8 4 6 2008 1289714 BB 5 13 2008 1291709 AG 6 4 2008 1292705 BB 12 6 2007 1276303 AB 1 7 2008 1285106 RQ 2 5 2008 1286326 fi 3 3 2008 1287103 8 4 6 2008 1289715 OB 5 13 2008 1291710 DB 6 4 2008 1292706 0G 12 6 2007 1276304 Trend Data 1 0 Setup S 4039 9 080 0 00Pgel F7QOOO D 204R13 27 21905 27 000 0 MBA Al Sample Trend Database vebdb ________________ EmipmentiDT CO1A AIRCOMPRESSOR A Areal TEST NEW CUSTOMER Point Pi SCREWCOMP GBX SO a O Your Lago Unit Usage E lt A wane Company Name Address 1 Address 2 Telephone Fax Email A Sample Trend report can be generated for an entir
16. t user The Guest user should be enabled and password protected and added to the SQL Server users http kbalertz com 831133 Server clients authenticated guests Simple Sharing enabled aspx http kbalertz com 304040 Description Sharing Permissions Windows aspx Note For domain networks you can speed the initial setup and configuration by adding the user domain domain users to SQL Server users and granting access to your database Adding individual users would be more secure OilLabData MJR Technologies LLC 20 Severity Trend Data 1 0 Setup Display Severity Severity Level BO Etene BE Baa 08 Marginal BA Fair BO God o Report Global if The vector display on the Sample Trend report may be customized to display Severity level names E xtrearrni 2 Wear Contaminabon Chemistry OilLabData MJR Technologies LLC Labels Trend Data YO Setup M Label Fields Cust ID 1234 W Equipment T Sample ID Oil Usage iY Database iY Point Sample Date Oil Added IW Area W Lab Unit ID Unit Usage W Barcode mM Sheet Labels Use Windows to set label size for single label printers side Margin Horizontal Fitch dla Top Margin Number Vertical Down Pitch w Top Margin 0 15 Label Height Z Number Across 2 Side Margin 10 05 Label Width FR Number Down 5 E Vertical Pitch 2 2 Horizontal Pitch 4 6 E Labels Y Label Printer if not Windows default Report DB Tren
17. ver Labels The default Access database is adequate for individual users SQL Server is a better choice for LAN users and web based databases With SQL Server the server system processes a request and passes back the selected records rather than passing all records to the client for processing SQL Server or SQL Server Express must be installed on your network and the Server must be configured to permit access from the client PCs Information Systems support may be required for proper configuration Server Name is the system name where the SQL server is located Selecting the down arrow will initiate a search on your LAN for available servers Windows Authentication mode is the Microsoft preferred authentication mode for SQL server SQL Server and Windows Authentication mode may be required for compatibility with existing network and SQL server configurations SOL Server account for SOL Server Authentication mode is used to enter the User Name and Password for access to the server system The Name and Password are only used if SQL Server and Windows Authentication mode 1s used The password is encrypted before storage to assure safety Note Windows Workgroup networks may require mirrored accounts on the server and the client The username and password must be identical OilLabData MJR Technologies LLC 19 Note Windows XP defaults to simple file sharing when using Workgroup networking In this case all users come through as the Gues
Download Pdf Manuals
Related Search