Artisan Trend Usage Guide
User Manual:
Open the PDF directly: View PDF 
.
Page Count: 8
| Download | |
| Open PDF In Browser | View PDF |
Artisan Engineering 4085 2nd Avenue Burnaby, BC V5C 3X1 (778) 251-4290 Artisan Trend Usage Guide Written by: Riley Stewart, 2018. Not to be copied, used, or revised without explicit written permission from the author and Artisan Engineering, Ltd. OVERVIEW This is a usage guide for the trending application developed by Artisan Engineering by Riley Stewart. Artisan Trend is intended to be used to view plots of data contained within chemical test reports produced by Artisan Engineering. PREPARING REPORTS As a general note, files sent to clients should be in the form of a password-locked excel worksheet; data contained within PDF reports cannot be accessed by Artisan Trend, and thus cannot be used. File Name When producing reports, file names should adhere to the following conventions (any of these works): Note: Here “_____” indicates anything may be put there. ● ‘YEAR-MONTH-DAY_______ .xlsx’ where each is numeric. ○ Ex: ‘2017-08-16 _ AC Report.xlsx’ ● ‘________MonthDAYYEAR.xlsx’ where day and year are numeric. ○ Month may be in short form or long form ■ Short form: first three letters of month (ex.: Jan, Feb, Mar, Apr, etc.) ■ Long form: full month name (ex. January, February, March, April, etc.) ○ Ex. ‘BentallReportJul172017.xlsx’ This serves to provide dates for each data point. Chemical Test Labels Chemical tests labels, located in the header of each data table in an excel file, for example: These vary from file to file; here is a table of all the chemical test labels that will work (case insensitive): Chemical Test Label Allowed Test Labels TDS TDS Cond Cond, Cond., Conductivity M. Alk M. Alk, Alkalinity, M.Alk, Alk., M Alk pH pH PO4 PO4 PhO4 PhO4 ORP ORP Cl Copper/Cu Iron/Fe Free Cl, Cl, FCl Cu Fe, Iron FATP FATP, F, Free ATP, F.ATP TATP TATP, T, Total ATP, T.ATP Zinc/Zn Zn Mg Hardness Mg, Mg Hardness Ca Hardness Ca, Ca Hardness Nitrite Molybdenum Nitrite, Nit, Nit. Mo, Molybdenum CONFIGURATION Excel File Location Upon launching the application, a pop-up menu will appear, requesting the user to select the folder that contains the excel reports produced by Artisan Engineering. This location must only contain these excel files; other files in the folder cause no issues. If issues are detected caused by an incorrect directory selected (no files present, difficulties loading files, etc.), the user will be informed and asked to select the directory again. The directory selected may be changed at any time by selecting ‘File’, and then ‘Change file directory’: Sample Labels When labelling samples in reports, consistency is key. For a particular sample, variations on sample names (ex. TASC 1 CT vs. TASC CT 1) is accounted for based upon matching labels according to similarity, and thus is fine. Larger variations in sample names (ex. Main HW vs. Hot Heating Water) must be accounted for using Artisan Trend’s alternate sample name system: By selecting ‘File’, and then ‘Change CT sample entries’ or ‘Change CL (Closed Loop) sample entries’, the label system can be viewed: As you can see above, each sample has alternate names associated with it, which allows Artisan Trend to compile data for each sample correctly, even with larger variations in sample labels used in the excel worksheets. Only the sample listed in ‘Sample Labels’ are plotted by the program. To add an item to one of the lists, first enter the sample/sample alternate name in the text box located near the bottom of the window. Then press the ‘+’ button for the particular list wanted. To remove an item from one of the lists, first select the item (will highlight blue) and then press the ‘-’ button for the respective list you are removing the item from: To save the current configuration of sample labels/alternate names, press the ‘Save’ button. USAGE To utilize Artisan Trend, simply click the .exe file contained with the folder. This folder may be placed anywhere, and a shortcut can be easily created and placed on the desktop for ease of use. To generate a plot for a particular chemical test, simply press the respective button; if trending CT samples, select the test under the ‘CT Tests’ header. If CL samples are wanted, select the test under the ‘Cl Tests’ header. This will produce an interactive .html file containing the plot. This plot automatically opens using the default web browser for the user. This plot is saved to the folder containing the .exe with the name ‘Trend (START DATE - END DATE)’, where START DATE is the earliest dated excel file, and END DATE is the latest. Being interactive, the plot has a number of features: Time Slider From the plot page, the time range of the plot may be adjusted by dragging either sides of the time slider, located below the plot. By dragging either the left or right bar on either side of the time slider, the start date and end date of the data plotted above is altered: As seen above, the start date of the data plotted is adjusted using the left slider bar. The end date may be adjusted similarly using the right slider bar. This allows for a specific date range to be displayed. For example, the summer months of 2017: Time Selector For ease of use, time selector buttons can be used to quickly view preset time ranges, based upon the end date of the data. These buttons are located on the top right corner off the plot: There are 5 buttons: 1. 1m - displays last month of data 2. 6m - displays last 6 months of data 3. YTD (Year to date) - displays the last year to the current date 4. 1y - displays last year of data 5. All - displays total date range of data Legend The legend, located at the top right corner of the plot page, can be interacted with to select and deselect samples to be displayed. Initially, all samples are displayed. To hide a particular sample, simply click on the sample name in the legend. This will grey out the sample name in the legend, and hide the sample in the plot: In this example, 737 CT is deselected: Additionally, to quickly isolate and display a single sample, simply double-click on the sample name in the legend. Point-by-point Information To see additional information about a data point, such as the exact date and value, simply hover over the point, upon which a small box will appear: To visualize and compare between samples for data taken on a particular day, first switch the hover mode to compare data on hover by pressing the corner. button located in the top right With this mode enabled, hovering over a data point shows information on all data points taken on the same date: Additional options are also contained at the top right corner. Information about the use of each can be found by hovering over a button: Deployment For ease of use, Artisan Trend exists within a single folder. When deploying to clients, this folder may be copied to a usb drive or directly downloaded to client computers via Google Drive. While each client has its own folder, they vary by only by an .ini file, which holds configuration settings such as file directory, client sample names, etc. The folder may be placed anywhere on client computer. For practical use, a shortcut may be created by navigating inside the folder, and then right-clicking the folder and selecting ‘Create Shortcut’. This shortcut may be dragged to the desktop, which then may be used to easily access the application. Troubleshooting For troubleshooting problems with the application, please email riley.stewart1775@gmail.com. I’d be happy to fix anything that comes up! The source files (python scripts, pyinstaller .spec files, etc.) are also on Google Drive.
Source Exif Data:
File Type : PDF File Type Extension : pdf MIME Type : application/pdf PDF Version : 1.5 Linearized : Yes Producer : Skia/PDF m70 Page Count : 8EXIF Metadata provided by EXIF.tools