eDATA 2.0 User Manual
Contents
1. Custom export generator m Score graph m PT review a Custom export generator Reports Stabsiecs Rescues Cenon Asmi Gassias a Caena The custom export generator is a tool that allows you to filter and download your historical PT data to your own specification To create a custom export 1 Choose from the Report Columns list to add reporting fields to your Selected Columns list 2 Specify the order for reporting by highlighting the desired column field and using the buttons provided to move the field up or down 3 Begin by selecting the year s you would like to report Note Addition filter fields are populated based on the data available from your selections in the previous field Hold down the control or shift keys to make multiple selections eDATA 2 0 User Manual 22 4 Next apply data filters to select the study type laboratory available only for corporate networks specific study or studies evaluation standard and or analytes to be reported 5 Once you ve selected the data and the order to be reported you can name and save your selected columns and order as a template for future use 6 Click Generate Report to download your data as a CSV file and open in Microsoft Excel b Z Score graph CDATA sus The z score is a great measure for comparing your analytical performance from one round to another Generally speaking an acceptable z score ranges from2. can be entered by standard when one method can be used for the entire analyte list A or you may choose to enter by analyte to designate a different analytical method for each analyte B If a standard requires more than one analytical technique such as Demand Catalog No 578 Report By Analyte will be the only option available eDATA 2 0 User Manual To enter data by standard l Ensure that you have selected the radial button for Report Data by Standard Begin typing your analytical method in the Method field and select from the list in the drop down box or enter the complete method manually if not listed Select the method Rev Edition from the drop down box or manually enter if not provided ANELAC Code and Tech Key will automatically populate based on the method you reported if found in the drop down list Check NELAC Code is Not Required if a NELAC Code and Tech Key are not required Click on the Analysis Date field and select the date the sample was analyzed from the calendar Click the Optional drop down to record any desired optional information to report with your PT results This may include Analyst SOP and SOP Revision Enter the analytical result s in the Datapoint field Click the check box under the Sign column to specify a less than lt result Continue to the next analyte Click Add Method to add a blank data set for entry of results from an additional met
3. select View Study Summary to review your data You can also receive a copy of your summary by email by clicking Email Study Summary In addition to manually entering your data for an open study you also have the option to upload your results directly to eDATA as a CSV Comma Separated Value file generated from your LIMS CDATA see Stalrstics ay oem baa Boe pip Boy Enrika Slacvtands Wiss sbacr baie LTTE neem tL Marght Ceia te babes belonged Bicrabe tE piian L LEIR Sri hance ee in N Beta LO ebtionmd Lr AE Hesa LEJH Hcb obionms Preece Het brish HS Soe Meco EA Beweti Chitata Atd Helena Wate Pite Tawni Leir Uomaan LEKSE Hiatoecetes Achis HAAI DEEST vartum nts Oa CLR ra SL et oo opoOUCOUCOUCOOUCUCOUlUCOGlUCU Ingcman Durica EA erro liniami THL LBZ Access the menu to upload you CSV from the data entry standards list menu by clicking the CSV Data Upload button Uploading an eDATA compatible CSV file ERA default format or your existing custom format DATA s Statistics Resources m Come Dan WAN APOI tND Dor Mees nten Deag icrmat LAD Dat Aktes Eee Deg OW end WS 221 1 gt 002010 04 22 2015 CSV Upload tf you heve used the DAA Detmst fie type te upload your PT data in Se pert A n Step l STEP Capers Dete Fo Fomei EAA Detar hie Formut Infarmenon Manage Custam Layouts Pabaidd aSc hat the Me Meerut ia few drh STEP gt Cree Cheese fe t
4. 2 to 2 shown as white on the graph A z score of gt absolute 2 to lt absolute 3 indicates a warning of questionable results and is color coded orange on the graph A z score of greater than or equal to absolute 3 is unsatisfactory and highlighted in red on this graph A negative z score indicates a low bias and a positive z score indicates a high bias in the reported result relative to the assigned value used for the performance evaluation It must be noted that these interpretations of z scores are as described in international standards for Proficiency Testing such as ISO 13528 however there can be some differences in the interpretation of z scores and what constitutes an acceptable or unacceptable result depending on the specific requirements set out by your Accrediting Body and or applicable regulations For consistency we have color coded the trending chart based on the general scale To create a z score graph for an analyte 1 Select the Lab applicable for laboratory networks Specify the Date Range select a date range based on your PT participation that will provide sufficient data points for review Select the desired Scheme study type Select the desired Standard Select the Analyst optional Select the Data Group optional select from the available methods or report all methods N O oO BR W PD Click to create your z score chart based on your selections eDATA 2 0 User Manual 23 c PT revi
5. 9 UV VIS CIV 1 15 15 9 88 0 0 co00000 S221 698 1820 10053200 IC COND CV 1 15 15 9 28 0 0 co00000 S221 698 1820 10067604 UV VIS clv 1 15 15 9 88 0 0 COO0000 S221 698 1610 20048402 COND JOC 1 15 15 507 0 0 co00000 S221 698 2000 10053200 IC COND CV 1 15 15 67 2 0 0 co00000 S221 699 2055 20044400 TITR JOC 1 15 15 2 48 0 0 co00000 S221 779 1900 20105004 IS SHA 1 15 15 6 96 0 0 co00000 S221 983 1645 10061402 UV VIS clv 1 15 15 0 219 0 0 co00000 S221 983 1645 20092404 UV VIS clv 1 15 15 0 219 0 0 eDATA 2 0 User Manual 13 The Comma Separated Values for an example file would look like this Lacpe ls Lr Dot tele ete Dide OLS Arahal Rieti Pathe MLAS Take Bary LS Freg hibad Cada LS Cheney ie Cadh Reel pal Pie te fle Reged kaloa Reged Laii Thi aparjad degater Thee Dimple Marjai Ce Ae eee ee ee re N COPS Fa 11M MIMA TLE ean Litter DOTY TO ME LE Mapping your own CSV format to a custom eDATA layout Many laboratories are already able to create EDD s for their customers from their LIMS Since creating a new EDD requires additional time and or IT resources ERA has made it easy for you to use one of your existing CSV electronic data deliverables to submit your PT To do this you will need to create a custom layout in eDATA that is mapped to the layout of your existing file DATA s mns gt Cam Bagdat WIIN APOIAN TVON
6. Biaederds for Water Peetictereryp Tasjes thedies CE aria Dore ene eed ihe leet aa yp eg ee edie bel pou jeri had Eha aide rerai hors eet the hilea riar L Ado ren oF any cher gt of Gen pug hp been revealed fo of ctocumped weth any uneethoriped preon oc cae Leponetcory phir to ie rhe oF ee ghete Thi indirdi far whch yau at aber hauia wia not mated by any other labaratary 1 Your Gboretary hes net kngeengly renee FT choy starelandy Irom sry other labor minrier E fio pero wie a from BRA or another laboneiories concerieng Rie magih welues oF Recenter figs for ha FT story Padeda veh ther clean of thot ady fc mai the grea for the requisites apenicess fo whet Ha PT dudy results are beng ueil Ill eDATA HOME PAGE YOUR PT DASHBOARD Once you have logged into your account and accepted the Attestation Statement you will be automatically directed to the eDATA home screen and your PT dashboard Study closing in 3 hours Study closing in 7 days Study closing in 7 days Study closing in 10 days closing in 28 days a The PT dashboard is your main hub in eDATA that provides an Once a study has closed it moves to the Recently Closed overview of critical items such as current open enrolled studies Studies section of your dashboard which provides a quick and provides quick access to data entry confirmations closed link to your study reports studies performance reports and other critical information l l Your enrolled studies that have n
7. E gt Ror Mees bateis Agag ormat E Ani Dut Artes Due Ose gt OIW eed WS 221 L2H 2086 gt 0i 2P 2015 CSV Upload if you heve used the DAA Detatt fie type te upload your PT sta in Me pest in Step 1 Choose Data Format leave De file type pe DRA Defaut Then po to Step 2 and browse to your EDO fie fer weleeding ss normal GTAP t Copeee Sete Pee Peer Enade Y Pile Formut Indormence Manage Custam Laros Caeth Acebes that the fie forrest is read orty STEP 2 Cranee Sasty Dace F o Upced Chatte fiie tte te chorn Pred Setete kd J Carcel ertre uptoed process d erry erora cceur POverwrite study data wh EDO date Ey accrediting body requret me te report NELAC method code ity hie has benders Test Run erty Mo ifo saad EM arte nedad Gum Ta ten Tate To create a custom layout to report your data click the Manage Custom Layouts button Manage custom EDD layouts CDATA Studies Statistics DOG CAD ee Ee H E Manage EDD Layouts Sea ohn Dey Lapel en peinar Crwate Fly ormai beped con tha daberich ujpis ua Drils isienck n t eee Coane E typl DEBRI H m amro r e eDATA 2 0 User Manual 14 A eDAITA gives you 3 different ways to create your custom layout that will allow you to upload your CSV files Option Edit an existing layout to map to your file Option 2 Create a new layout by selecting and ordering the fields to map to your file Option 3 Upload an example of you
8. ENCE OF WHAT S POSSIBLE P 34 Maple Street Milford MA 01757 U S A Waters ERA and The Science of What s Possible are registered trademarks of Waters Corporation eDATA is a registered T 1 508 478 2000 F 1 508 872 1990 2015 Waters Corporation Produced in the U S A April 2015 720005300EN LM PDF www walers com trademark of ERA A Waters Company All other trademarks are the property of their respective owners
9. Exception report indicating only your results for analytes that receive a Not Acceptable or Unsatisfactory performance evaluation Final PT report available after the closed study has been evaluated and released to participants Study summary Data entry and reporting summary for the study Preliminary limits report available between the closing date of the study and when final PT report is issued which includes your reported result and the preliminary assigned value and acceptance limits Final limits report available when the PI has been completed showing your reported results assigned value acceptance limits and evaluation essentially an abbreviated version of your final PT report i Exception Report CDATA Bhie E D a a eee iia Entaphon Rpa WP JH Pelgent Helim Deo ger E mT irm yid pr w WP bdi ote BYT IRO Andis m Ceo i ma Hoi icmp ibis EMG E LFE7IT TAT LEW Andir m Ceo i I Met focemietes SH 1110 bisa arrest LEO ed ii Le t iw Hi 2 cemrtekig Ee So Lae CEAP i seat Faye On the closed studies page click the Exception Report button at the right of the applicable closed study to access your exception report for the study eDATA 2 0 User Manual 20 The exception report provides a list of only the analytes with a not acceptable or unsatisfactory performance evaluation and includes information about your PT result including reported value the assigned value acceptance limit
10. List to return to the standards menu to select another standard for manual data entry TIPS m Use the tab key to move between fields m Use a decimal point in place of a comma when reporting data i e 15 5 instead of 15 5 Report your PT result to three significant figures A NELAC Code is a unique numerical identifier for each method assigned by The NELAC Institute TNI Method Codes are used by accreditors in the United States for automated data validation If you choose a method from ERA s drop down list eDATA will match the method you enter with the Method Code from the database of current TNI Method Codes If a match is not found a message will be returned prompting you to take one of the following actions 1 Enter a correct NELAC code 2 Indicate that a NELAC code is not required A list of TNI Method Code Analyte Codes can be accessed while entering your data by clicking on the link under the Resources menu eDATA 2 0 User Manual 9 Ah You will not be able to move past the Enter Data page or Save Data until you have entered a correct NELAC Code or have indicated that a NELAC Code is Not Required by selecting the box in the upper left International laboratories are not required to report NELAC Codes unless they are accredited in the United States View summary CDATA Studies Statistics Resources Data Entry Summary WE 720 8O 6 F044 1 31 7013 gt Mardewss cst 33 mares Tithe
11. Mathes 1 Check MELAC code is not requred Report Dats by Ansiyte moe bee Smee ot _ After reporting your data by standard or analyte and saving your work click View Summary to generate a data entry summary report that can be printed for your records and or used to verify your transcription Click Return to Standards List to continue entering your data for another standard CDATA Studies Stalrstics Aieourdes onroted Siangads 1 F 1 pi z 7 b i z E H E i i MS barbante met HarakiT Calfarme Lr pIDES HiorabaT icaling LENI Peergtd m iCeitanmal Lepap Fensi Leto Hionabe deoii Lena Hewa brail OS Se ea Peer bt e aa Beket Chimen Ati Neterabrache Plire Cash LiTE oma Lt KSA fimbanceter Achis eile DEEST vekum iti GM cite st ta SOA aS lo o o o o o o o o oo cUo8FmUCOhUC OOWUcCOUlUCODlUClhlUG norman Denectan ed te 77 0 Hearse TAL be RAL After you have entered data for a standard the X icon will change to a check mark icon to indicate that you have reported data for that standard eDATA 2 0 User Manual 10 NOTE Data is not required to be reported for all analytes for a given standard in order for a check mark to be displayed This is because laboratories have the option to report PT results for all analytes or only the analytes they wish to be evaluated CSV upload TIPS m You can make changes to your PI results until the study closes Always
12. Uewe Osscrption Fone USEPA d ade typeially rms tate instigis phe Ore pt member eg AOOO GAA 6 bet Peete oe Mated an peat irrsere of ot coe borgie 0g FIATI SOO 450 11i Then te Do TRAC orolt iade pa ind the mori sorori reacties of the todion Hy pecelly Gon ie o hw Agt ber eg BESA adh Thos orahy tacal sreettnnd onde ii the ILAC method vate pimgred ts the aralvtiiel methed yeu seed ber the dete row one reporting Trpetelly Pos redar om agt Og mire 0g OOS LAGS Soa s heck Thee clue mute shot We tortreingy used th De eel tes meted cede Me ar henel sah ot POG KP 48E C To create a new file format 1 Required columns are listed in selected columns shown on the right 2 Additional available columns can be added from the selections on the left by clicking the Add button 3 For extra fields in your CSV that are not listed use Do Not Import 4 Move the selected columns up or down to match the order of your CSV file 5 Provide a name for your layout in the Layout Name field 6 Save your layout eDATA 2 0 User Manual 16 oa Option 3 Upload an example of your existing CSV file and map to eDATA fields to create your layout DATA ss WEE CED ea Ee e OE LS Manage EDD Layouts asas 1 ae he hep ens teinar Conate file Termal beped oon thig Piiteri brett Bruel the Phe kaiman a read only Dyble drench nicae thie haana a necta To create your new layout by uploading an example of
13. act section and clicking the edit icon The edit contact screen allows you to specify the primary contact using the selection boxes CDATA org Lene Serene Customer infarnation Comtocses Iptoreia tees hera a V COMPLETING AN OPEN STUDY Navigate to an open study by clicking the green box on the desired open study panel displayed on the PT dashboard Alternatively you can view open studies by highlighting the Studies menu and clicking the Open Studies tab eDATA 2 0 User Manual 3 CDATA s Silt fem Os Mtei Open Stidus Te srd ried Peeticisery Tanig Picken The open studies page displays all your enrolled open studies The drop down filter allows you to filter your open studies by either nearest closing date or study type The status bar displays your progress toward the completion of each of the steps for the open study You can access each step from this menu by clicking on the text below the status bar for the desired step There are 3 required steps to complete an open study m Step l Mailing address m Step 2 Agencies and third parties m Step 3 Enter data a Step 1 Mailing address DATA so urs Soe Duasi Eras Wrieg Anton Enter Mafing Address 4 TIPS m Breadcrumbs in the upper left of each page allow you to navigate to a previous level m You can also go back to the home screen by clicking the eDATA logo Lat the g Asper WEDAI Tatie Min
14. eDATA 2 0 User Manual e CONTENTS VI Vil LOG IN TO eDATA ATTESTATION STATEMENT eDATA HOME PAGE YOUR PT DASHBOARD MANAGING YOUR CUSTOMER INFORMATION COMPLETING AN OPEN STUDY a Step 1 Mailing address b Step 2 Agencies and third parties c Step 3 Enter data i Manual entry of data ii CSV upload REVIEWING YOUR PT RESULTS a Closed studies i Exception report ii Performance report TOOLS FOR QA MANAGERS a Custom export generator b Z Score graph c PT Review eDATA 2 0 The Next Evolution of PT Informatics I LOG IN TO eDATA Access eDATA from the ERA website www eragc com Click on the eDATA login link in the upper right corner Log in to eDAIA using your ERA customer number or NPDES permit number and password If you need to reset your eDATA password click on the link to create reset ERA password to reset by entering your ERA customer number and email address registered to your account For any additional assistance accessing your account please contact ERA s Customer Service at 800 372 0122 or 303 431 8454 Access eDATA from the ERA website www eraqc com Click on the eDATA login link in the upper right corner A II ATTESTATION STATEMENT Before entering the site you are required to acknowledge and accept ERA s Attestation Statement which is required as part of ERA s ISO 17043 accreditation CDATA ATTESTATION STATOME MT Bar ihe reqeieererte of thee WD e Adio
15. ed in the United States eDATA 2 0 User Manual 8 To enter data by analyte l g Ensure that you have selected the radial box for Report Data by Analyte If the standard contains a list of analytes that require different methods this will be the only option displayed Begin typing your analytical method in the Method field and select from the list in the drop down box or enter the complete method manually if not listed Select the method Rev Edition from the drop down box or manually enter if not provided ANELAC Code and Tech Key will automatically populate based on the method you reported if found in the drop down list Check NELAC Code is Not Required if a NELAC Code and Tech Key are not required Click on the Analysis Date field and select your analysis date from the calendar Click the Optional drop down to record any desired optional information to report with your PT results This may include Analyst SOP and SOP Revision Enter the analytical result s in the Datapoint field Click the check box under the Sign column to specify a less than lt result Continue to the next analyte 10 Click Add Method to add a blank data set for entry of results from an additional method if needed When you have entered all data for this standard click Save 12 Click View Summary to generate a data entry summary for the standard you have just entered 13 Click Return to Standards
16. ew CDATA suse The PT Review report allows you to quickly and easily identify any analytes that you may need to be concerned about for accreditation purposes depending on the proficiency testing requirements to maintain your accreditation To generate your PT review make your selections using the dropdown filters at the top of the report 1 Select the Date Range to be examined Note the date range selected should be based on how often you participate in PT and how many studies you would like to display 2 Select the Study Type 3 Select whether you want the table to be based on Study Close Date or Analysis Date 4 Select review either your last 3 or last 5 PT results within the specified date range 5 Select display evaluation based on either the 2003 or 2009 TNI standard The PT Review table is listed by analyte in alphabetical order and includes the matrix method revision and technology for each analyte Performance evaluation and either the analysis date or study close date depending on the reporting option you selected are displayed Analytes that were given a not acceptable evaluation are highlighted in red to make them easily identifiable ERA ERA www eraqc com edata2 16341 Table Mountain Pkwy Stamford Avenue Golden CO 80403 U S A Altrinchem Road T 800 372 0122 or Wilmslow SK9 4AX 303 431 8454 United Kingdom F 303 421 0159 T 44 0 161 946 2777 F 44 0 161 946 2776 Waters Waters Corporation THE SCI
17. hod if needed When you have entered all data for this standard click Save Click View Summary to generate a data entry summary for the standard you have just entered Click Return to Standards List to return to the standards menu to select another standard for manual data entry TIPS Use the tab key to move between fields Use a decimal point in place of a comma when reporting data i e 15 5 instead of 15 5 Report your PI results to three significant figures A NELAC Code is a unique numerical identifier for each method assigned by The NELAC Institute TNI Method Codes are used by accreditors in the United States for automated data validation If you choose a method from ERA s drop down list eDATA will match the method you enter with the Method Code listed in the database of current INI Method Codes If a match is not found a message will be returned prompting you to take one of the following actions 1 Enter a correct NELAC code 2 Indicate that a NELAC code is not required A list of TNI Method Code Analyte Codes can be accessed while entering your data by clicking on the link under the Resources menu You will not be able to move past the enter data page or save data until you have entered a correct NELAC Code or have indicated that a NELAC Code is not required by selecting the box in the upper left International laboratories are not required to report NELAC Codes unless they are accredit
18. ie Me chorn oe Saot Dees P Peit Getereter Carte aare upped roms d erry mron cow POverwrite study data wih EDO data Pity ectreding body reure me te report NELAC method code Pity fle has benders Test Run or y Me mfo send fe type se TRA Doin Then po to Step 2 d browse to your eDATA 2 0 User Manual 11 Once you have entered the CSV Upload menu by clicking CSV Data Upload button from the Step 3 Enter Data Standards menu complete the 3 steps to upload your eDATA compatible CSV File Upload results page Step 1 Select the appropriate file format from the dropdown box either ERA default required only or a custom layout you have previously created Step 2 Click Choose File to select your file to attach and select or deselect the checkboxes you would like to apply to your upload Step 3 Click Upload Study File to upload your file to eDATA Once the upload is complete you will be automatically directed to the Upload Result Page to view the status of your upload If errors were detected these will be listed in the error detail section with a description of the error encountered If you receive an error message and have questions or need assistance please contact ERA s Interlab Group at 800 372 0122 or 303 431 8454 or interlabgroup eragc com Creating a CSV format compatible with eDATA 1 Requirements to create your CSV template in ERA Default Format CDATA su Corale
19. le layout If you have additional fields in your CSV file that you do not wish to import or upload the fields can be excluded by designating the fields with Do Not Import You will need to have a field for both Reported gt and Reported lt that has a bit flag of O or 1 O indicates there is no symbol reported while a indicates that the symbol was reported A listing and description of the fields required can be found by clicking the File Format Information button from the CSV Upload menu The following information is required to upload your PT data m ERA Lot as the sample number ID or your lot number id m The data system will recognize either INI analyte codes CAS numbers or analyte names Method Description or TNI Method Code Analysis Date Reported Value Greater than gt bit flag value either O or 1 Less than lt bit flag value either O or 1 Sample number for the WS Microbiology 10 sample set If you have any questions concerning any part of the eDATA website please contact ERA at 800 372 0122 or 303 431 8454 or send an email to interlabgroup eraqc com Once you have created your CSV custom layout it will become available in the dropdown selection box in step of the CSV Upload menu You will then be able to complete the 3 steps to upload your file eDATA 2 0 User Manual 18 Step 1 Select the appropriate file format from the dropdown box Either ERA default or a custom layout you have previo
20. ot opened yet are listed The study panel displays your enrolled open studies in on the dashboard in the Upcoming Studies section which chronological order starting with the study with the nearest allows you to set a reminder for the study open date in closing date and displays the time remaining until the study most calendar applications closes You can see what you have completed to date in the PT process using the blue status bar and the large green icons allow you to easily navigate back to where you may have left off in the PT process eDATA 2 0 User Manual 2 Top menu selections The top menu provides easy access links to detailed pages dedicated to all of your open and closed studies via the Studies menu The Reports menu provides access to the Custom Export Generator Z Score Graph PT Review Final Reports and Health of Your Lab HOYL reports The Statistics menu provides a link to overall study statistics The Resources menu provides other useful links and information pertinent to your PT The search bar allows you to search your eDATA account for a specific open or closed study The drop down menu under your customer number provides links to manage your customer information e mail us access FAQs and change your password IV MANAGING YOUR CUSTOMER INFORMATION The Customer Information menu allows you to manage your address contacts third parties and delivery preferences You can edit the primary contact by expanding the cont
21. r CSV to map the eDATA fields to your fields Option 1 Edit a CSV layout that already exists in eDATA to create your custom layout CDATA Studies Statistics Resources rae er LH Comi Stecdends Method Gummer Shade Vecficeban Manage EDD Layouts Seem Ode feitt payizi Bii fete F Cresp Mie domal imped qi then DATA Manage Edd ffe Layout Laut Mend 4 Coor of Eni Setnst To edit an existing format to create your new CSV format 1 The selected columns box lists the fields that are included in the format you are basing your custom layout on and the order Add additional fields or columns from the list of columns available You can set column order by moving the field selections up or down 2 3 4 Place a Do Not Import for any fields that are in your CSV that are not on the list provided or that you do not want to import 8 Name your new layout in the Layout Name field Be sure to create a name that is recognizable for future uploads A defaulted name is prepopulated and will be used if you do not enter a name 6 When completed click Save eDATA 2 0 User Manual 15 ODATA Studies Statishcs WE POG CAD he OE de LS Manage EDD Layouts Ceeae ay feig piris tance cont tnt nt ene Cope E od hes 7 m eer eet e en Feli daere ie hak ra Click Create New File Format to manage EDD file Layout DATA sse We 224 100 200 01 32 7913 Manage Edd tie Layout Code
22. s evaluation method study mean and standard deviation the analyst name if it was reported and the total number of datapoints reported for this analyte from all participants ii Performance report On the closed studies page click the Performance Report button at the right of the applicable closed study to access your performance report for the study The performance report provides a complete overview of your performance for the selected study and includes information about your final PT result including your reported value the assigned value acceptance limits evaluation method study mean and standard deviation the analyst name if it was reported and the total number of datapoints reported for this analyte as well as SOP name and revision if it was reported in the optional section on the data entry page The performance report is searchable by analyte performance evaluation and analyst name For U S customers the performance report was designed to include all of the information required in the 2009 TNI standard for Demonstration of Capability including the optional analyst name SOP and SOP Revision fields that are optional for data entry These fields are required if you intend to use the performance report for DOC purposes eDATA 2 0 User Manual 21 Ta VII TOOLS FOR QA MANAGERS Additional tools to assist in reviewing and understanding your PT performance are available under the Reports menu These include m
23. s Racdands Method Summary Studs Verficatan eDATA 2 0 User Manual 12 Once at the CSV Upload menu click on the File Format Information link for details on the ERA Default File format Links at the bottom of the pages will allow you to find INI Method Codes and Tech Key Information for the ERA Default File Format ERA default format specifications Snioted Sianida Methed Dimmar Study Verhcebon The EDD file Layout Summary page displays a list of the ERA electronic data deliverable EDD default file requirements The data file will have one header row and will consist of a string of values separated by commas All fields listed must be included in your CSV file with the specified header you do not need to provide data in the fields listed as not required Limits to the character length are specified in the EDD File Layout Summary Table If a number is not specified there is no restriction on the character length An example of the ERA default CSV format looks like this when opened in MS Excel RAIL co00000 S221 5262 1540 10053200 IC COND CV 1 15 15 218 0 0 COO0000 S221 667 1870 10053200 IC COND CV 1 15 15 5 33 0 0 COO0000 S221 667 1870 10070005 UV VIS clv 1 15 15 5 29 0 0 co00000 S221 667 1870 20124601 UV VIS clv 1 15 15 5 29 0 0 co00000 S221 698 1575 10053200 IC COND CV 1 15 15 45 7 0 0 COO0000 S221 698 1730 10053200 IC COND CV 1 15 15 1 56 0 0 co00000 S221 698 1810 2011640
24. tas Partesy Goden Ute eDATA 2 0 User Manual 4 1 Designate the individual at your company that will receive your final report 2 Review and update your account information if required 3 Select your preferred final report delivery option 4 Select Save and Continue to proceed to Step 2 Agencies and third parties NOTE Electronic PDF is the recommended delivery method You can retain an electronic copy and or print a copy of the PDF b Step 2 Agencies and third parties CDATA sw Choose Agencies from the menu at left and Third Parties from the menu at right Agencies To select the Agencies you would like your final PT report sent to 1 Select the check box for the Agencies you require for your study 2 Enter your agency specific laboratory ID in the adjacent box 3 View the contact information for the specific agency by clicking the Agency Lookup link under the Resources menu 4 f you are using a study for internal purposes or do not need to report to any of the specified U S Agencies select the No Agencies Required check box at the top of the list of Agencies eDATA 2 0 User Manual Third parties On the Third Party tab there are three options to help you manage and select third parties for reporting m Select a Third Party from the list displayed m Adda Third Party Delete a Third Party 1 To add a Third Party click on the Add Third Party but
25. ton and complete the required fields 2 To edit a Third Party click on the Edit icon 3 To delete a Third Party click on the Delete icon A master record for your Third Parties can also be added edited or deleted from the Customer Information page Once added to the master record Third Parties can be selected to receive future study reports Imported Third Party information is automatically selected to receive a report for this specific study Click View Reporting Summary to display a report summarizing your Agency and Third Party selections Click Save amp Continue to proceed to Step 3 Enter data eDATA 2 0 User Manual 6 ah c Step 3 Enter data EDAT Studies Statestics Enrtied Siandands ae SS ie eS usa oom 5 BOTE abdlpiirio akh Pais et ry diad eel le ee ioa el fin ai a Si Shaipi ta Thi ews Be gad bied ar Sil h lade 7 ooo onoono ouoo aa ooo ooo onoonooopog Step 3 begins with a list of the standards you re enrolled in for this study The X icon denotes that no data has been entered for that standard eDATA gives you two options to enter study results m Manual entry of data m CSV data upload Data entry by standard DATA s Mee Come Ban OLES YEIHS POREN pny baing cpet Deia Seer Adr Tuni Setas Ee Omp PN Data Entry SOG BS 1 19 2015 2 6 POLS gt Metals Sod cat 620 Repart Cate by Anahite Report Oma by Sdad i Manual entry of data Data
26. usly created Step 2 Click Choose File to select your file to attach and select or deselect the check boxes you would like to apply to your upload Step 3 Click Upload Study File to upload your file to eDATA View summary When you have successfully uploaded your CSV without errors return to the data entry standards menu A check mark next to the standard will indicate that datahas been uploaded Now you can view a summary of your reported results for the entire study or view your reporting summary by standard VI REVIEWING YOUR PT RESULTS a Closed studies There are two methods to access closed studies 1 eDATA Home Screen and PT Dashboard Recently Closed Studies Once a study has closed it moves to the recently closed studies section of your dashboard which provides a quick link to your study reports 2 Studies Menu Closed Studies The Studies menu is accessible from each eDATA page and provides a link to a complete list of all your closed studies eDATA 2 0 User Manual 19 CDATA Studies Statistics org Chee fdas Cisti Studies Cossi Studien Peter bs ma ay gery 6 The closed studies search bar allows search for a specific study number or filter by year or study type The buttons provided at the right of each closed study allow you to access reports and information for the specified study including Performance report summarizing your PT performance for the study
27. your existing CSV file click Choose File then select your example CSV for upload Click the GO button To map eDATA fields to your CSV 1 Use the drop down box to select and map the appropriate eDATA field match to your CSV field 2 The header provided in your CSV is provided above the drop down for reference with the data reported in that field below 3 Enter the name of your layout in the Layout Name field When you have completed mapping and named your file 4 Click Submit eDATA 2 0 User Manual 17 M TIPS Upload the data for all analytes to be reported for the standard Multiple uploads of the same standard may cause your data to be overwritten Error logs will provide you with the type of error and the line number where the error occurred If your file contains a header row the row number in the error log will not include the header row of your file Always review your study summary to ensure your results were uploaded correctly Be sure to name the format before you save the file International laboratories are not required to report NELAC Method Codes unless they are accredited in the United States Always select View Study Summary to review your data You can also receive a copy summary by selecting Email Study Summary While you are basing a layout on your existing CSV you need to ensure that all required data are presented in your CSV that you plan to use Upload your custom fi
Download Pdf Manuals
Related Search