{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Definitions","Abbreviations","Instructions","CREED Workflow","Purpose Statement","Dataset Details","Gateway Criteria","Reliability Criteria","Relevance Criteria","Report","Version","Export_(hidden)","Conclusions_(hidden)"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":8,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Definitions","index":0,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[[19,2,19,5],[20,2,20,5],[15,3,15,5],[1,1,1,3],[14,1,15,1],[4,1,7,1],[10,1,12,1],[5,3,5,5],[6,3,6,5],[7,3,7,5],[11,3,11,5],[12,3,12,5],[13,2,13,5],[14,2,14,5],[16,2,16,5],[17,2,17,5],[18,2,18,5],[3,2,3,5],[4,2,4,5],[8,2,8,5],[9,2,9,5],[10,2,10,5]]}
[]
[null,"Definitions",null,null,"Back to CREED Workflow"]
[]
[null,"Assessment purpose","Statement defined by the user that specifies what the data evaluation is about and what the assessment aims to deliver. It should articulate the key factors in the assessment, such as the relevant chemicals, the sampling medium, the spatial and temporal scope, data analysis or statistical requirements, and any regulatory framework considerations. Ideally, the purpose statement also specifies the minimum information that is required for a relevance criterion to be “fully met” and may also include information required for a criterion to be “partly met” as appropriate. For further guidance on how to construct an effective purpose statement please refer to Peters et al. (forthcoming). The assessment purpose statement is analogous  to the problem formulation step in other scientific assessments."]
[null,"Category","The result of the evaluation of a dataset for reliability or for relevance.  Categories are assigned on the basis of the criteria ratings assigned by the user to the reliability and relevance criteria. The categories assigned to the data set for reliability and for relevance are then combined to determine the overall usability of the dataset for the given purpose. "]
[null,null,null,"reliability categories are: “reliable without restrictions, “reliable with restrictions,” “not reliable”, or “not assignable” "]
[null,null,null,"relevance categories are: “relevant without restrictions, “relevant with restrictions,” “not relevant”, or “not assignable” "]
[null,null,null,"usability categories are: “usable without restrictions”; “useable with restrictions”; or “not usable” "]
[null,"Class","One of six groups of CREED criteria that are related by topic: Media (e.g., water, soil, etc.), Spatial, Temporal, Analytical, Data handling and Statistics, and Supporting parameters.  "]
[null,"CREED","Criteria for Reporting and Evaluating Exposure Data."]
[null,"Criteria","Technical questions that define key elements of data quality (reliability criteria) or the extent to which the data are suitable for a given assessment purpose (relevance criteria). Individual criteria are designated as either required or recommended, based on relative importance for most assessment purposes; this distinction underpins the two levels (Gold and Silver) at which datasets are simultaneously scored under CREED."]
[null,null,null,"Circumstance-specific criteria: Criteria that apply only to datasets that contain certain types of data (such as summary statistics or censored data) or to which specific conditions apply (such as the dataset had outliers removed or calculations made).  These criteria are the only ones that can receive a “not applicable” criteria rating, if the specific circumstances do not apply to a given dataset. "]
[null,null,null,"Gateway criteria – A suite of questions about the dataset that define the minimum amount of information about a dataset to evaluate that dataset using the CREED procedure. If one or more gateway criteria are not met, then the dataset cannot be evaluated by CREED; if all gateway criteria are met, then the dataset undergoes detailed evaluation for reliability and relevance for a specified assessment purpose."]
[null,"Dataset Details","Summary of the basic characteristics (attributes) of the dataset that is subject to evaluation. We recommend that the user enter dataset characteristics in the Dataset Details tab of the Scoring Tool, so that a summary will be included in the report card.  "]
[null,"Level (Gold level, Silver level)","The CREED approach is a simultaneous, two-level scoring approach. The criteria ratings for the reliability and relevance criteria (assigned by the user) lead to the automatic assignment (using pre-defined rules) by the Scoring Tool of the dataset into reliability and relevance categories, each at both Silver level and Gold level. "]
[null,null,null,"At the Silver level, only the required criteria determine the category/score assignment, whereas all criteria (required plus recommended) determine the category/score at the Gold level. Thus, the Silver level (based only on required criteria) is less ambitious than the Gold level, which represents an ideal dataset where all the required and recommended criteria contribute to the category/score. "]
[null,"Limitations (Dataset Limitations)","Reasons for assigning a criteria rating other than “fully met” for any given criterion, that are identified during the dataset evaluation process. For transparency, we recommend that the user list all data limitations in the Scoring Tool, so they will be included in the Report Card. "]
[null,"Rating (Criteria Rating)","One of 5 possible results for a dataset being evaluated for a single CREED criterion. The 5 possible criteria ratings are: “fully met”, “partly met”, “not met/inappropriate”, “not reported”, and (only for certain circumstance-specific criteria only) “not applicable”.  "]
[null,"Relevance","The degree of suitability or appropriateness of the evaluated dataset to address the specific, user-defined purpose. "]
[null,"Reliability","The inherent quality of the chemical exposure dataset. "]
[null,"Report Card","A summary of the usability evaluation at the two scoring levels (Silver level and Gold level). This includes the assessment purpose statement, dataset details, the score card information, any dataset limitations, the Silver level and Gold level scores for relevance and reliability, and the overall data usability scores. The Scoring Tool workbook offers the option to extract the full evaluation outcomes as a downloadable report card. "]

{"sheet":"Abbreviations","index":1,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[9,1,9,2],[10,1,10,2],[11,1,11,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2]]}
[]
[null,"Abbreviations used in the CREED Scoring Tool",null,null,null,null,"Back to CREED Workflow"]
[]
[null,"CREED",null,"Criteria for Reporting and Evaluating Exposure Data"]
[null,"FM",null,"Fully Met"]
[null,"LOD",null,"Limit of detection"]
[null,"LOQ",null,"Limit of quantification (also called Limit of quantitation)"]
[null,"PM ",null,"Partly Met"]
[null,"QC",null,"Quality control"]
[null,"RB01 - RB19",null,"Reliability criteria number 01 through 19"]
[null,"RV01 - RV11",null,"Relevance criteria number 01 through 11"]
[null,"SRM",null,"Standard reference material"]

{"sheet":"Instructions","index":2,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[[3,1,3,4],[4,1,4,4],[17,1,17,4],[1,1,1,2],[15,1,15,4],[5,2,5,4],[6,2,6,4],[7,1,7,4],[8,1,8,4],[9,1,9,4],[10,2,10,4],[11,2,11,4],[12,1,12,4],[13,2,13,4],[14,2,14,4]]}
[]
[null,"Instructions for Using the CREED Scoring Tool*",null,"Back to CREED Workflow"]
[]
[null,"1. The user can click buttons in the workflow diagram to enter the appropriate tabs to enter information. Otherwise, the user can page through the tabs from left to right."]
[null,"2. On the Purpose Statement tab, the user should enter a well-defined purpose statement. To help construct a well-defined purpose statement, we recommend that the user fills out the Purpose Summary Table by entering thresholds \n    (i.e., specific qualitative or quantitative values) for each relevance criterion (RV01 through RV11)."]
[null,null,"a. To use the optional Purpose Summary Table to help construct a well-defined purpose statement, the user defines thresholds that must be satisfied to score the dataset as fully met (FM) or partly met (PM). These thresholds \n    should specify the optimal information desired (for FM) or the minimum information required (for PM) for a given relevance criterion."]
[null,null,"b. The goal of the Purpose Summary Table is to provide a set of quantitative or qualitative attributes that will help users evaluate data as fully or partly meeting the relevance criteria. Level of specificity will be dependent upon the \n    goals of the user. A higher degree of specificity will facilitate transparency in each evaluation and will promote greater consistency among evaluations for different datasets and by different users for a given assessment purpose."]
[null,"3. On the Dataset Details tab, the user will provide key information or characteristics of the dataset(s) to which the CREED scoring approach is being applied. Information provided on the Dataset Details tab will be included in the CREED \n    report generated by the scoring tool."]
[null,"4. On the Gateway Criteria tab, the user will enter Yes or No answers to basic criteria about the dataset. If one or more gateway criteria receive a No answer, then there is insufficient information available for that dataset to undergo a \n    CREED evaluation and the user should not populate any additional tabs."]
[null,"5. On the Reliability Criteria tab, the user will rate the reliability of the dataset that is being evaluated. To perform the evaluation, the user will score each criterion using the \"Conclusion (drop-down)\" score options. For any criterion that \n    is not scored as \"Fully met\" the user should enter the reasons as free text in the associated \"Reliability Limitations/Restrictions\" field. Any Reliability Limitations/Restrictions entered by the user represent an important part of the \n    evaluation result and will be included in the Report generated by the CREED scoring tool."]
[null,null,"a. Certain criteria are designated as \"required\" and contribute to the dataset score at both the \"Silver\" and \"Gold\" levels. These comprise the minimum se of criteria that should be fully, or at least partly met, for the dataset to be \n    used for the specified assessment purpose."]
[null,null,"b. Certain criteria are designated as \"recommended\" and contribute to the dataset score at the \"Gold\" level. These are value-added criteria that, when fully met or at least partly met, indicate that the dataset is optimal for the \n    specified assessment purpose."]
[null,"6. On the Relevance Criteria tab, the user will rate the relevance of the dataset for the purpose that has been defined. To perform the evaluation, the user will score each criterion using the \"Conclusion (drop-down)\" score options. For \n    any criterion that is not scored as \"Fully met\" the user should enter the reasons as free text in the associated \"Relevance Limitations/Restrictions\" field. Any Relevance Limitations/Restrictions entered by the user represent an \n    important part of the evaluation result and will be included in the Report that is automatically generated by the CREED scoring tool."]
[null,null,"a. Certain criteria are designated as \"required\" and contribute to the dataset score at both the \"Silver\" and \"Gold\" levels. These comprise the minimum set of criteria that should be fully or at least partly met for the dataset to be \n    used for the specified assessment purpose."]
[null,null,"b. Certain criteria are designated as \"recommended\" and contribute to the dataset score at the \"Gold\" level. These are value-added criteria that, when fully met or at least partly met, indicate that the dataset is optimal for the \n    specified assessment purpose."]
[null,"7. The Report tab shows the outcome of the CREED evaluation scores at both Gold and Silver levels; this Report is generated automatically from the information entered by the user on prior tabs. A textual description of the relevance, \n    reliability, and overall scores is provided along with a data usability interpretation. Any limitations/restrictions entered by the user during the evaluation will be summarized on the Report tab."]
[]
[null,"* For more information about the CREED scoring approach, see: Di Paolo C, Bramke I, Stauber J, Whalley C, Otter R, Verhaegen Y, Nowel LH, Ryan AC. In review. Implementation of the CREED approach for environmental assessments. Integrated Environmental Assessment and Management, in review."]

{"sheet":"CREED Workflow","index":3,"n_rows":22,"n_cols":17,"rows_kept":22,"cut":false,"hidden":false,"merged":[[4,1,4,15],[1,1,1,15],[21,1,21,22],[15,16,15,18],[18,7,18,11],[6,7,6,11],[9,7,9,11],[12,7,12,11],[15,10,15,13],[15,5,15,8],[6,16,6,18],[9,16,9,18],[12,16,12,18],[2,1,2,15]]}
[]
[null,"CREED Scoring Tool*"]
[null,"version 1.0"]
[]
[null,"Workflow (Click buttons to enter appropriate tabs)"]
[]
[null,null,null,null,null,null,null,"Purpose Statement",null,null,null,null,null,null,null,null,"Instructions"]
[]
[]
[null,null,null,null,null,null,null,"Dataset Details",null,null,null,null,null,null,null,null,"Abbreviations"]
[]
[]
[null,null,null,null,null,null,null,"Gateway Criteria",null,null,null,null,null,null,null,null,"Definitions"]
[]
[]
[null,null,null,null,null,"Reliability Criteria",null,null,null,null,"Relevance Criteria",null,null,null,null,null,"Version History"]
[]
[]
[null,null,null,null,null,null,null,"CREED Report"]
[]
[]
[null,"* For more information about the CREED scoring approach, see: Di Paolo C, Bramke I, Stauber J, Whalley C, Otter R, Verhaegen Y, Nowel LH, Ryan AC. In review. Implementation of the CREED approach for environmental assessments. Integrated Environmental Assessment and Management, in review."]

{"sheet":"Purpose Statement","index":4,"n_rows":20,"n_cols":22,"rows_kept":20,"cut":false,"hidden":false,"merged":[[13,2,13,14],[15,18,15,20],[16,18,16,20],[17,18,17,20],[18,18,18,20],[13,15,13,17],[14,15,14,17],[15,15,15,17],[16,15,16,17],[17,15,17,17],[19,18,19,20],[9,2,9,14],[10,2,10,14],[11,2,11,14],[12,2,12,14],[9,18,9,20],[10,18,10,20],[11,18,11,20],[12,18,12,20],[13,18,13,20],[14,18,14,20],[19,15,19,17],[18,15,18,17],[10,15,10,17],[11,15,11,17],[12,15,12,17],[19,2,19,14],[16,2,16,14],[17,2,17,14],[14,2,14,14],[15,2,15,14],[18,2,18,14],[8,1,8,20],[7,18,7,20],[7,15,7,17],[9,15,9,17],[1,6,1,11],[1,13,1,17],[4,1,4,20],[5,1,5,2],[5,3,5,20],[6,2,6,20],[7,1,7,14],[3,1,3,20]]}
[]
[null,"Purpose Statement",null,null,null,null,"Next Step: Dataset Details",null,null,null,null,null,null,"Back to CREED Workflow"]
[]
[null,"Purpose Statement"]
[null,"Please describe the objective for which the useability of the dataset is asssessed, including the required dataset thresholds"]
[null,"Purpose Statement:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(freetext)"]
[]
[null,"Purpose Summary Table (optional)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Fully Met (FM)",null,null,"Partly Met (PM)"]
[null,"Enter thresholds for \"Partly Met\" (minimum information required) and \"Fully Met\" (optimal information) to fit the assessment purpose. Thresholds can be specific or general, depending on how important a criterion is to the user for the assessment purpose. Also, users can choose not to enter any threshold(s) for \"Partly Met\", if they want a yes/no decision."]
[null,"RV1","The sampling medium/matrix was appropriate for the given purpose.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(freetext)"]
[null,"RV2","The sample collection method (e.g., grab, depth- and width-integrated, discrete, composite, or time-integrated samples, or continuous monitoring) was adequate for the given purpose. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(freetext)"]
[null,"RV3","The study area and number of locations sampled was suitable for the given purpose.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(freetext)"]
[null,"RV4","The rationale for selection of sampling locations was provided and it is suitable for the given purpose.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(freetext)"]
[null,"RV5","The samples were collected over a time scale that was appropriate for the given purpose.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(freetext)"]
[null,"RV6","Over the timespan, the sampling frequency was appropriate for the given purpose.  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(freetext)"]
[null,"RV7","Conditions during sampling events were documented and relevant for the given purpose (e.g., baseflow, storm events, planned/unplanned discharges, etc.).  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(freetext)"]
[null,"RV8","The analyte(s) reported was/were appropriate for the given purpose.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(freetext)"]
[null,"RV9","The method was sensitive enough for the given purpose (i.e., the LOD and/or LOQ were below the benchmarks or metrics to which concentrations in the dataset will be compared).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(freetext)"]
[null,"RV10","The summary statistics provided (e.g., median, geometric mean, arithmetic mean, percentiles) were appropriate for the given purpose. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(freetext)"]
[null,"RV11","All supporting parameters that were needed to achieve the given purpose were provided. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(freetext)"]

{"sheet":"Dataset Details","index":5,"n_rows":19,"n_cols":21,"rows_kept":19,"cut":false,"hidden":false,"merged":[[6,2,6,19],[7,2,7,19],[1,12,1,16],[1,5,1,10],[3,1,3,19],[4,2,4,19],[5,2,5,19],[16,2,16,19],[17,2,17,19],[18,2,18,19],[8,2,8,19],[9,2,9,19],[10,2,10,19],[11,2,11,19],[12,2,12,19],[13,2,13,19],[14,2,14,19],[15,2,15,19]]}
[]
[null,"Dataset Details",null,null,null,"Next Step: Gateway Criteria",null,null,null,null,null,null,"Back to CREED Workflow"]
[]
[null,"Key Attributes of Dataset Under Assessment"]
[null,"Source (reference):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(freetext)"]
[null,"Reported Analyte:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(freetext)"]
[null,"Sample Medium/Matrix:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(freetext)"]
[null,"Sampling Conditions:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(freetext)"]
[null,"Study Area:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(freetext)"]
[null,"Number of Sites:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(freetext)"]
[null,"Site Density:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(freetext)"]
[null,"Number of Samples:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(freetext)"]
[null,"Site Type(s):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(freetext)"]
[null,"Sampling Period:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(freetext)"]
[null,"Sampling Frequency:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(freetext)"]
[null,"Sampling Method(s):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(freetext)"]
[null,"Analytical Method(s):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(freetext)"]
[null," Limit of Quantification:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(freetext)"]
[null,"Other Details:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(freetext)"]

{"sheet":"Gateway Criteria","index":6,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[9,3,9,6],[3,3,3,6],[1,1,1,2],[4,3,4,6],[5,3,5,6],[6,3,6,6],[7,3,7,6],[8,3,8,6]]}
[]
[null,"Gateway Criteria",null,"Next Step: Reliability Criteria",null,"Back to CREED Workflow"]
[]
[null,"No.","Title ","Gateway Criterion",null,null,null,"Answer (Yes or No)"]
[null,1,"Sampling Medium/ Matrix","Does the study specify which medium/matrix is sampled? "]
[null,2,"Analyte ","Does the study specify which unique analyte is measured?  "]
[null,3,"Spatial Location ","Does the study specify where samples were collected? At a minimum, there is enough information for the given purpose (e.g., country). "]
[null,4,"Year","Does the study indicate when samples were collected? At a minimum, there is enough information for the given purpose (e.g., sampling year)."]
[null,5,"Units ","Does the study specify units of measurement? "]
[null,6,"Data source/ Citation ","Does the study cite the source of data and/or is a suitable bibliographic reference available for the study? "]

{"sheet":"Reliability Criteria","index":7,"n_rows":23,"n_cols":15,"rows_kept":23,"cut":false,"hidden":false,"merged":[[21,6,21,8],[22,6,22,8],[13,6,13,8],[14,6,14,8],[15,6,15,8],[16,6,16,8],[17,6,17,8],[18,6,18,8],[1,8,1,9],[3,6,3,8],[4,6,4,8],[5,6,5,8],[6,6,6,8],[10,6,10,8],[11,6,11,8],[12,6,12,8],[14,3,14,5],[4,3,4,5],[6,3,6,5],[7,3,7,5],[8,3,8,5],[8,6,8,8],[7,6,7,8],[22,3,22,5],[1,1,1,3],[3,3,3,5],[5,3,5,5],[15,3,15,5],[16,3,16,5],[17,3,17,5],[18,3,18,5],[19,3,19,5],[20,3,20,5],[9,3,9,5],[10,3,10,5],[11,3,11,5],[12,3,12,5],[13,3,13,5],[1,5,1,6],[4,1,6,1],[9,1,16,1],[17,1,21,1],[3,9,3,10],[14,9,14,10],[15,9,15,10],[16,9,16,10],[17,9,17,10],[18,9,18,10],[19,9,19,10],[20,9,20,10],[21,9,21,10],[21,3,21,5],[19,6,19,8],[20,6,20,8],[9,6,9,8],[22,9,22,10],[4,9,4,10],[5,9,5,10],[6,9,6,10],[7,9,7,10],[8,9,8,10],[9,9,9,10],[10,9,10,10],[11,9,11,10],[12,9,12,10],[13,9,13,10]]}
[]
[null,"Reliability Criteria",null,null,null,"Next Step: Relevance Criteria",null,null,"Back to CREED Workflow"]
[]
[null,"Class","No.","Title",null,null,"Criterion",null,null,"Conclusion (drop-down)",null,"Reliability Limitations/Restrictions (free-text)","Status",null,"Value"]
[null,"Media","RB01","Sample Medium/ Matrix",null,null,"Was the sampling medium/matrix reported in detail (for water: dissolved fraction or whole water; for sediment: sieved or whole; for soil, grain size; for biota, species, age, sex, tissue type), and was the matrix appropriate for the analyte of interest?",null,null,"Not Reported",null,null,"Required",null,{"$f":"INDEX('Conclusions_(hidden)'!$B:$B,MATCH('Reliability Criteria'!$J5,Conclusions_All,0)+1)","v":3}]
[null,null,"RB02","Collection Method/ Sample Type",null,null,"Was the sample collection method reported? Examples include grab, depth- and width-integrated, discrete, composite, or time-integrated samples, or continuous monitoring.",null,null,"Not Reported",null,null,"Recommended",null,{"$f":"INDEX('Conclusions_(hidden)'!$B:$B,MATCH('Reliability Criteria'!$J6,Conclusions_All,0)+1)","v":3}]
[null,null,"RB03","Sample Handling",null,null,"Was information reported on sample handling (transport conditions, preservation, filtration, storage)? Was the type of container suitable for use with the analyte of interest? (i.e., no loss or contamination)",null,null,"Not Reported",null,null,"Recommended",null,{"$f":"INDEX('Conclusions_(hidden)'!$B:$B,MATCH('Reliability Criteria'!$J7,Conclusions_All,0)+1)","v":3}]
[null,"Spatial","RB04","Site Location",null,null,"Were the site locations reported?",null,null,"Not Reported",null,null,"Required",null,{"$f":"INDEX('Conclusions_(hidden)'!$B:$B,MATCH('Reliability Criteria'!$J8,Conclusions_All,0)+1)","v":3}]
[null,"Temporal","RB05","Date and Time",null,null,"Were the date and time of sample collection reported?",null,null,"Not Reported",null,null,"Required",null,{"$f":"INDEX('Conclusions_(hidden)'!$B:$B,MATCH('Reliability Criteria'!$J9,Conclusions_All,0)+1)","v":3}]
[null,"Analytical","RB06","Analyte(s) Measured",null,null,"Was the analyte(s) of interest suitably and definitively identified? ",null,null,"Not Reported",null,null,"Required",null,{"$f":"INDEX('Conclusions_(hidden)'!$B:$B,MATCH('Reliability Criteria'!$J10,Conclusions_All,0)+1)","v":3}]
[null,null,"RB07","Limit of Detection and/or Limit of Quantification",null,null,"Were limits of detection and/or quantitation provided? ",null,null,"Not Reported",null,null,"Required",null,{"$f":"INDEX('Conclusions_(hidden)'!$B:$B,MATCH('Reliability Criteria'!$J11,Conclusions_All,0)+1)","v":3}]
[null,null,"RB08","Accreditation/ Quality Management System",null,null,"Were the laboratory and method accredited for all or almost all samples? Several national and international accreditation bodies are available (e.g. ISO, UKAS); Was that laboratory and/or method certified to these standards? Was a quality system (such as e.g. ISO 17025) adopted? If these criteria are 'Fully Met', please proceed to No. RB13. If not, please proceed to additional questions Nos. RB09-RB12.",null,null,"Not Reported"]
[null,null,"RB09","Method",null,null,"Was the method sufficiently described or referenced, such that it can be reproduced if necessary? Was method validation included?",null,null,"Not Reported",null,null,"Required",null,{"$f":"INDEX('Conclusions_(hidden)'!$B:$B,MATCH('Reliability Criteria'!$J13,Conclusions_All,0)+1)","v":3}]
[null,null,"RB10","Lab Blank Contamination",null,null,"Was method blank contamination assessed with laboratory blanks?",null,null,"Not Reported",null,null,"Recommended",null,{"$f":"INDEX('Conclusions_(hidden)'!$B:$B,MATCH('Reliability Criteria'!$J14,Conclusions_All,0)+1)","v":3}]
[null,null,"RB11","Recovery/ Accuracy",null,null,"Were method recovery/accuracy and/or uncertainty assessed by recovery of standard reference material (SRM) and/or were lab spike samples assessed?",null,null,"Not Reported",null,null,"Recommended",null,{"$f":"INDEX('Conclusions_(hidden)'!$B:$B,MATCH('Reliability Criteria'!$J15,Conclusions_All,0)+1)","v":3}]
[null,null,"RB12","Reproducibility/ Precision",null,null,"Were method reproducibility and/or uncertainty assessed with lab replicates and long-term control recoveries?",null,null,"Not Reported",null,null,"Recommended",null,{"$f":"INDEX('Conclusions_(hidden)'!$B:$B,MATCH('Reliability Criteria'!$J16,Conclusions_All,0)+1)","v":3}]
[null,null,"RB13","Field QC",null,null,"Were quality control (QC) samples collected during field sampling (such as field blanks, spikes, replicates) to demonstrate the method performance for a given field study?",null,null,"Not Reported",null,null,"Recommended",null,{"$f":"INDEX('Conclusions_(hidden)'!$B:$B,MATCH('Reliability Criteria'!$J17,Conclusions_All,0)+1)","v":3}]
[null,"Data Handling and Statistics","RB14","Calculations\n(if dataset contains calculated values)",null,null,"If chemical concentrations were normalised or adjusted (e.g., to represent bioavailability or toxicity), then were the calculations explained and were they appropriate?",null,null,"Not Reported",null,null,"Recommended",null,{"$f":"INDEX('Conclusions_(hidden)'!$B:$B,MATCH('Reliability Criteria'!$J18,Conclusions_All,0)+1)","v":3}]
[null,null,"RB15","Significant Figures\n(if dataset contains calculated values)",null,null,"During calculations, were data reported to the appropriate number of significant figures or decimal places?",null,null,"Not Reported",null,null,"Recommended",null,{"$f":"INDEX('Conclusions_(hidden)'!$B:$B,MATCH('Reliability Criteria'!$J19,Conclusions_All,0)+1)","v":3}]
[null,null,"RB16","Outliers\n(if dataset mentions outliers)",null,null,"For any outliers deleted from the data set, was evidence provided that these outliers were due to an error in measurement or contamination?",null,null,"Not Reported",null,null,"Recommended",null,{"$f":"INDEX('Conclusions_(hidden)'!$B:$B,MATCH('Reliability Criteria'!$J20,Conclusions_All,0)+1)","v":3}]
[null,null,"RB17","Censored Data\n(if dataset contains censored values)",null,null,"Were censored data reported correctly (e.g., as a numerical value plus a less-than sign or another indicator of a nondetect)? If a substitution method was used for nondetects (e.g., censored data were replaced by zero, or by 1/2 or another fraction of the LOD/LOQ), then can the original censored data be restored by back-calculation using the reported LOD/LOQ?",null,null,"Not Reported",null,null,"Required",null,{"$f":"INDEX('Conclusions_(hidden)'!$B:$B,MATCH('Reliability Criteria'!$J21,Conclusions_All,0)+1)","v":3}]
[null,null,"RB18","Summary Statistics Procedures\n(if dataset contains summary statistics)",null,null,"Were summary statistics calculated appropriately? If the dataset contained censored data, then were censored data included and were appropriate procedures used to determine summary statistics?",null,null,"Not Reported",null,null,"Recommended",null,{"$f":"INDEX('Conclusions_(hidden)'!$B:$B,MATCH('Reliability Criteria'!$J22,Conclusions_All,0)+1)","v":3}]
[null,"Supporting Parameters","RB19","Supporting Data Quality\n(if supporting parameters are required for the purpose)",null,null,"If any supporting parameters are required for the assessment purpose, then were the supporting parameter data provided, and were their methods and data quality addressed?   ",null,null,"Not Reported",null,null,"Recommended",null,{"$f":"INDEX('Conclusions_(hidden)'!$B:$B,MATCH('Reliability Criteria'!$J23,Conclusions_All,0)+1)","v":3}]

{"sheet":"Relevance Criteria","index":8,"n_rows":15,"n_cols":15,"rows_kept":15,"cut":false,"hidden":false,"merged":[[14,3,14,5],[12,6,12,8],[13,6,13,8],[13,3,13,5],[4,1,5,1],[6,1,7,1],[8,1,10,1],[11,1,12,1],[7,3,7,5],[8,3,8,5],[9,3,9,5],[10,3,10,5],[11,3,11,5],[12,3,12,5],[11,6,11,8],[4,6,4,8],[1,8,1,9],[3,6,3,8],[7,6,7,8],[8,6,8,8],[1,5,1,6],[3,3,3,5],[4,3,4,5],[5,3,5,5],[6,3,6,5],[5,6,5,8],[14,6,14,8],[3,9,3,10],[4,9,4,10],[5,9,5,10],[6,9,6,10],[7,9,7,10],[8,9,8,10],[9,9,9,10],[10,9,10,10],[11,9,11,10],[12,9,12,10],[13,9,13,10],[14,9,14,10],[9,6,9,8],[10,6,10,8],[6,6,6,8]]}
[]
[null,"Relevance Criteria",null,null,null,"Next Step: CREED Report",null,null,"Back to CREED Workflow"]
[]
[null,"Class","No.","Title",null,null,"Criterion",null,null,"Conclusion (drop-down)",null,"Relevance Limitations/Restrictions (free-text)","Status",null,"Value"]
[null,"Media","RV01","Sample Medium/ Matrix",null,null,"Was the sampling medium/matrix appropriate for the given purpose?",null,null,"Not Reported",null,null,"Required",null,{"$f":"INDEX('Conclusions_(hidden)'!$B:$B,MATCH('Relevance Criteria'!$J5,Conclusions_All,0)+1)","v":3}]
[null,null,"RV02","Collection Method/ Sample Type",null,null,"Was the sample collection method (e.g., grab, depth- and width-integrated, discrete, composite, or time-integrated samples, or continuous monitoring) adequate for the given purpose?",null,null,"Not Reported",null,null,"Recommended",null,{"$f":"INDEX('Conclusions_(hidden)'!$B:$B,MATCH('Relevance Criteria'!$J6,Conclusions_All,0)+1)","v":3}]
[null,"Spatial","RV03","Study Area",null,null,"Were the study area and number of locations sampled suitable for the given purpose?",null,null,"Not Reported",null,null,"Required",null,{"$f":"INDEX('Conclusions_(hidden)'!$B:$B,MATCH('Relevance Criteria'!$J7,Conclusions_All,0)+1)","v":3}]
[null,null,"RV04","Site Type",null,null,"Was the rationale for selection of sampling locations provided and was it suitable for the given purpose?",null,null,"Not Reported",null,null,"Recommended",null,{"$f":"INDEX('Conclusions_(hidden)'!$B:$B,MATCH('Relevance Criteria'!$J8,Conclusions_All,0)+1)","v":3}]
[null,"Temporal","RV05","Sampling Timespan",null,null,"Were the samples collected over a time scale that was appropriate for the given purpose?",null,null,"Not Reported",null,null,"Required",null,{"$f":"INDEX('Conclusions_(hidden)'!$B:$B,MATCH('Relevance Criteria'!$J9,Conclusions_All,0)+1)","v":3}]
[null,null,"RV06","Sampling Frequency",null,null,"Over the timespan, was the sampling frequency appropriate for the given purpose?",null,null,"Not Reported",null,null,"Required",null,{"$f":"INDEX('Conclusions_(hidden)'!$B:$B,MATCH('Relevance Criteria'!$J10,Conclusions_All,0)+1)","v":3}]
[null,null,"RV07","Temporal Conditions",null,null,"Were conditions during sampling events documented and relevant for the given purpose (e.g., baseflow, storm events, planned/unplanned discharges, etc.)?",null,null,"Not Reported",null,null,"Recommended",null,{"$f":"INDEX('Conclusions_(hidden)'!$B:$B,MATCH('Relevance Criteria'!$J11,Conclusions_All,0)+1)","v":3}]
[null,"Analytical","RV08","Analyte",null,null,"Was/were the reported analyte(s) appropriate for the given purpose?",null,null,"Not Reported",null,null,"Required",null,{"$f":"INDEX('Conclusions_(hidden)'!$B:$B,MATCH('Relevance Criteria'!$J12,Conclusions_All,0)+1)","v":3}]
[null,null,"RV09","Sensitivity/ LOD/ LOQ",null,null,"Was the method sensitive enough for the given purpose (i.e., were the LOD and/or LOQ below the benchmarks or metrics to which concentrations in the dataset will be compared)?",null,null,"Not Reported",null,null,"Required",null,{"$f":"INDEX('Conclusions_(hidden)'!$B:$B,MATCH('Relevance Criteria'!$J13,Conclusions_All,0)+1)","v":3}]
[null,"Data Handling and Statistics","RV10","Summary Statistics Type\nif dataset contains summary statistics",null,null,"Were the summary statistics provided (e.g., median, geometric mean, arithmetic mean, percentiles) appropriate for the given purpose?",null,null,"Not Reported",null,null,"Recommended",null,{"$f":"INDEX('Conclusions_(hidden)'!$B:$B,MATCH('Relevance Criteria'!$J14,Conclusions_All,0)+1)","v":3}]
[null,"Supporting Parameters","RV11","Supporting Parameters\nif supporting parameters are required for the purpose",null,null,"Were all supporting parameters provided that were needed to achieve the given purpose?",null,null,"Not Reported",null,null,"Required",null,{"$f":"INDEX('Conclusions_(hidden)'!$B:$B,MATCH('Relevance Criteria'!$J15,Conclusions_All,0)+1)","v":3}]

{"sheet":"Report","index":9,"n_rows":6,"n_cols":14,"rows_kept":6,"cut":false,"hidden":false,"merged":[[4,7,4,8],[5,7,5,8],[3,7,3,8],[3,5,3,6],[4,5,4,6],[5,5,5,6],[0,13,3,13],[0,10,3,10],[0,11,3,11],[0,12,3,12],[1,6,1,7]]}
[null,null,null,null,null,null,null,null,null,null,"Reliability Value","Relevance Value","Reliability Limitations/Restrictions","Relevance Limitations/Restrictions"]
[null,"Data Usability Summary",null,null,null,null,"Back to CREED Workflow"]
[]
[null,"Assessment Level","Data Reliability","Data Relevance","Data Usability","Interpretation",null,"Limitations/Restrictions"]
[null,"Silver\n(required level)",{"$f":"IF(COUNTIF('Gateway Criteria'!$H$5:$H$10,\"Yes\")<6,\"Did not pass Gateway Criteria\",IF(ISNA(K5),\"\",INDEX('Conclusions_(hidden)'!C:C,K5+1)))","v":"Did not pass Gateway Criteria"},{"$f":"IF(COUNTIF('Gateway Criteria'!$H$5:$H$10,\"Yes\")<6,\"Did not pass Gateway Criteria\",IF(ISNA(L5),\"\",INDEX('Conclusions_(hidden)'!D:D,L5+1)))","v":"Did not pass Gateway Criteria"},{"$f":"IF(COUNTIF('Gateway Criteria'!$H$5:$H$10,\"Yes\")<6,\"Not Usable\",IF(LEN(C5&D5)=0,\"\",INDEX('Conclusions_(hidden)'!E:E,MAX(K5:L5)+1)))","v":"Not Usable"},{"$f":"IF(COUNTIF('Gateway Criteria'!$H$5:$H$10,\"Yes\")<6,\"Does not meet minimum requirements\",IF(E5=\"\",\"\",INDEX('Conclusions_(hidden)'!F:F,MAX(K5:L5)+1)))","v":"Does not meet minimum requirements"},null,{"$f":"IF($M$5=\"0\",\"\",\"Reliabilty: \"&$M$5&\";\"&CHAR(10))&IF($N$5=\"0\",\"\",\"Relevance: \"&$N$5&\";\")","v":""},null,null,{"$f":"_xlfn.MAXIFS('Reliability Criteria'!$O:$O,'Reliability Criteria'!$M:$M,\"Required\")","v":3},{"$f":"_xlfn.MAXIFS('Relevance Criteria'!$O:$O,'Relevance Criteria'!$M:$M,\"Required\")","v":3},{"$f":"SUBSTITUTE(SUBSTITUTE(_xlfn.TEXTJOIN(\"; \",TRUE,IF('Reliability Criteria'!M:M=\"Required\",'Reliability Criteria'!L:L,\"\")),\"; 0\",\"\"),\"0; \",\"\")","v":"0"},{"$f":"SUBSTITUTE(SUBSTITUTE(_xlfn.TEXTJOIN(\"; \",TRUE,IF('Relevance Criteria'!M:M=\"Required\",'Relevance Criteria'!L:L,\"\")),\"; 0\",\"\"),\"0; \",\"\")","v":"0"}]
[null,"Gold\n(recommended level)",{"$f":"IF(COUNTIF('Gateway Criteria'!$H$5:$H$10,\"Yes\")<6,\"Did not pass Gateway Criteria\",IF(ISNA(K6),\"\",INDEX('Conclusions_(hidden)'!C:C,MAX(K5,K6)+1)))","v":"Did not pass Gateway Criteria"},{"$f":"IF(COUNTIF('Gateway Criteria'!$H$5:$H$10,\"Yes\")<6,\"Did not pass Gateway Criteria\",IF(ISNA(L6),\"\",INDEX('Conclusions_(hidden)'!D:D,MAX(L5,L6)+1)))","v":"Did not pass Gateway Criteria"},{"$f":"IF(COUNTIF('Gateway Criteria'!$H$5:$H$10,\"Yes\")<6,\"Not Usable\",IF(LEN(C6&D6)=0,\"\",INDEX('Conclusions_(hidden)'!E:E,MAX(K5:L6)+1)))","v":"Not Usable"},{"$f":"IF(COUNTIF('Gateway Criteria'!$H$5:$H$10,\"Yes\")<6,\"Does not meet minimum requirements\",IF(E6=\"\",\"\",INDEX('Conclusions_(hidden)'!F:F,MAX(K5:L6)+1)))","v":"Does not meet minimum requirements"},null,{"$f":"IF(AND($M$5=\"0\",$M$6=\"0\"),\"\",\"Reliability: \"&IF($M$5=\"0\",\"\",$M$5&\"; \")&IF($M$6=\"0\",\"\",$M$6&\"; \")&IF(AND($N$5=\"0\",$N$6=\"0\"),\"\",CHAR(10)))&IF(AND($N$5=\"0\",$N$6=\"0\"),\"\",\"Relevance: \"&IF($N$5=\"0\",\"\",$N$5&\"; \")&IF($N$6=\"0\",\"\",$N$6&\"; \"))","v":""},null,null,{"$f":"_xlfn.MAXIFS('Reliability Criteria'!$O:$O,'Reliability Criteria'!$M:$M,\"Recommended\")","v":3},{"$f":"_xlfn.MAXIFS('Relevance Criteria'!$O:$O,'Relevance Criteria'!$M:$M,\"Recommended\")","v":3},{"$f":"SUBSTITUTE(SUBSTITUTE(_xlfn.TEXTJOIN(\"; \",TRUE,IF('Reliability Criteria'!$M$5:$M$23=\"Recommended\",'Reliability Criteria'!$L$5:$L$23,\"\")),\"; 0\",\"\"),\"0; \",\"\")","v":"0"},{"$f":"SUBSTITUTE(SUBSTITUTE(_xlfn.TEXTJOIN(\"; \",TRUE,IF('Relevance Criteria'!$M$5:$M$15=\"Recommended\",'Relevance Criteria'!$L$5:$L$15,\"\")),\"; 0\",\"\"),\"0; \",\"\")","v":"0"}]

{"sheet":"Version","index":10,"n_rows":5,"n_cols":12,"rows_kept":5,"cut":false,"hidden":false,"merged":[[3,2,3,10],[4,2,4,10],[5,2,5,10],[6,2,6,10],[1,1,1,8]]}
[]
[null,"Version History",null,null,null,null,null,null,null,"Back to CREED Workflow"]
[]
[null,"Version","Comment(s)",null,null,null,null,null,null,null,null,"Date"]
[null,"1.0","First Release",null,null,null,null,null,null,null,null,"2024-01-30"]

{"sheet":"Export_(hidden)","index":11,"n_rows":76,"n_cols":13,"rows_kept":76,"cut":false,"hidden":true,"merged":[[25,11,25,12],[16,11,16,12],[17,11,17,12],[18,11,18,12],[19,11,19,12],[20,11,20,12],[21,11,21,12],[22,11,22,12],[23,11,23,12],[24,11,24,12],[23,1,23,9],[24,1,24,9],[25,1,25,9],[20,1,20,9],[21,1,21,9],[22,1,22,9],[17,1,17,9],[18,1,18,9],[19,1,19,9],[14,11,14,12],[15,1,15,9],[16,1,16,9],[14,1,14,9],[15,11,15,12],[1,6,1,12],[9,6,9,12],[10,6,10,12],[3,6,3,8],[2,6,2,8],[4,6,4,8],[5,6,5,8],[6,6,6,8],[2,10,2,12],[3,10,3,12],[4,10,4,12],[5,10,5,12],[6,10,6,12],[7,6,7,12],[8,6,8,12],[59,0,59,1],[54,0,58,1],[46,0,53,1],[45,0,45,1],[44,0,44,1],[41,0,43,1],[47,3,47,5],[48,3,48,5],[49,3,49,5],[44,3,44,5],[45,3,45,5],[46,3,46,5],[59,3,59,5],[53,3,53,5],[54,3,54,5],[55,3,55,5],[56,3,56,5],[57,3,57,5],[58,3,58,5],[51,3,51,5],[52,3,52,5],[50,3,50,5],[40,3,40,5],[41,3,41,5],[42,3,42,5],[43,3,43,5],[40,0,40,1],[36,1,36,3],[35,1,35,3],[38,4,38,11],[37,4,37,11],[36,4,36,11],[39,0,39,12],[41,6,41,10],[42,6,42,10],[43,6,43,10],[64,6,64,10],[65,6,65,10],[66,6,66,10],[67,6,67,10],[68,6,68,10],[74,3,74,5],[74,0,74,1],[71,6,71,10],[72,6,72,10],[73,6,73,10],[74,6,74,10],[68,3,68,5],[69,3,69,5],[75,6,75,10],[40,6,40,10],[32,1,32,3],[27,0,27,2],[28,0,28,2],[29,0,29,2],[33,4,33,11],[29,5,29,6],[28,9,28,12],[29,9,29,12],[75,0,75,1],[38,1,38,3],[37,1,37,3],[64,0,64,1],[75,3,75,5],[72,3,72,5],[35,4,35,11],[64,3,64,5],[65,3,65,5],[66,3,66,5],[67,3,67,5],[65,0,66,1],[67,0,68,1],[69,0,71,1],[0,3,0,12],[12,0,12,12],[13,0,13,12],[28,5,28,6],[28,3,28,4],[27,9,27,12],[73,3,73,5],[55,6,55,10],[56,6,56,10],[26,0,26,12],[31,0,31,12],[63,0,63,12],[27,3,27,4],[29,3,29,4],[27,5,27,6],[70,3,70,5],[71,3,71,5],[72,0,73,1],[34,4,34,11],[34,1,34,3],[69,6,69,10],[70,6,70,10],[33,1,33,3],[32,4,32,11],[44,6,44,10],[45,6,45,10],[57,6,57,10],[58,6,58,10],[59,6,59,10],[46,6,46,10],[47,6,47,10],[48,6,48,10],[49,6,49,10],[50,6,50,10],[51,6,51,10],[52,6,52,10],[53,6,53,10],[54,6,54,10]]}
[null,null,null,"DATASET DETAILS - Key Attributes of Dataset"]
[null,null,null,"Source (reference):",null,null,{"$f":"IF('Dataset Details'!$C$5=\"\",\"\",'Dataset Details'!$C$5)","v":""}]
[null,null,null,"Reported Analyte:",null,null,{"$f":"IF('Dataset Details'!$C$6=\"\",\"\",'Dataset Details'!$C$6)","v":""},null,null,"Sample Medium/Matrix:",{"$f":"IF('Dataset Details'!$C$7=\"\",\"\",'Dataset Details'!$C$7)","v":""}]
[null,null,null,"Sampling Conditions:",null,null,{"$f":"IF('Dataset Details'!$C$8=\"\",\"\",'Dataset Details'!$C$8)","v":""},null,null,"Study Area:",{"$f":"IF('Dataset Details'!$C$9=\"\",\"\",'Dataset Details'!$C$9)","v":""}]
[null,null,null,"Number of Sites:",null,null,{"$f":"IF('Dataset Details'!$C$10=\"\",\"\",'Dataset Details'!$C$10)","v":""},null,null,"Site Density:",{"$f":"IF('Dataset Details'!$C$11=\"\",\"\",'Dataset Details'!$C$11)","v":""}]
[null,null,null,"Number of Samples:",null,null,{"$f":"IF('Dataset Details'!$C$12=\"\",\"\",'Dataset Details'!$C$12)","v":""},null,null,"Site Type(s):",{"$f":"IF('Dataset Details'!$C$13=\"\",\"\",'Dataset Details'!$C$13)","v":""}]
[null,null,null,"Sampling Period:",null,null,{"$f":"IF('Dataset Details'!$C$14=\"\",\"\",'Dataset Details'!$C$14)","v":""},null,null,"Sampling Frequency:",{"$f":"IF('Dataset Details'!$C$15=\"\",\"\",'Dataset Details'!$C$15)","v":""}]
[null,null,null,"Sampling Method(s):",null,null,{"$f":"IF('Dataset Details'!$C$16=\"\",\"\",'Dataset Details'!$C16)","v":""}]
[null,null,null,"Analytical Method(s):",null,null,{"$f":"IF('Dataset Details'!$C$17=\"\",\"\",'Dataset Details'!$C17)","v":""}]
[null,null,null,"Limit of Quantification:",null,null,{"$f":"IF('Dataset Details'!$C$18=\"\",\"\",'Dataset Details'!$C18)","v":""}]
[null,null,null,"Other Details:",null,null,{"$f":"IF('Dataset Details'!$C$19=\"\",\"\",'Dataset Details'!$C$19)","v":""}]
[]
["PURPOSE STATEMENT - Required Attributes for Dataset"]
[{"$f":"IF('Purpose Statement'!D6=\"\",\"\",'Purpose Statement'!D6)","v":""}]
["No.","Purpose Summary Table (optional)",null,null,null,null,null,null,null,null,"Fully Met (FM)","Partly Met (PM)"]
["RV1","The sampling medium/matrix was appropriate for the given purpose.",null,null,null,null,null,null,null,null,{"$f":"IF('Purpose Statement'!$P10=\"\",\"\",'Purpose Statement'!$P10)","v":""},{"$f":"IF('Purpose Statement'!$S10=\"\",\"\",'Purpose Statement'!$S10)","v":""}]
["RV2","The sample collection method (e.g., grab, depth- and width-integrated, discrete, composite, or time-integrated samples, or continuous monitoring) was adequate for the given purpose. ",null,null,null,null,null,null,null,null,{"$f":"IF('Purpose Statement'!$P11=\"\",\"\",'Purpose Statement'!$P11)","v":""},{"$f":"IF('Purpose Statement'!$S11=\"\",\"\",'Purpose Statement'!$S11)","v":""}]
["RV3","The study area and number of locations sampled was suitable for the given purpose.",null,null,null,null,null,null,null,null,{"$f":"IF('Purpose Statement'!$P12=\"\",\"\",'Purpose Statement'!$P12)","v":""},{"$f":"IF('Purpose Statement'!$S12=\"\",\"\",'Purpose Statement'!$S12)","v":""}]
["RV4","The rationale for selection of sampling locations was provided and it is suitable for the given purpose.",null,null,null,null,null,null,null,null,{"$f":"IF('Purpose Statement'!$P13=\"\",\"\",'Purpose Statement'!$P13)","v":""},{"$f":"IF('Purpose Statement'!$S13=\"\",\"\",'Purpose Statement'!$S13)","v":""}]
["RV5","The samples were collected over a time scale that was appropriate for the given purpose.",null,null,null,null,null,null,null,null,{"$f":"IF('Purpose Statement'!$P14=\"\",\"\",'Purpose Statement'!$P14)","v":""},{"$f":"IF('Purpose Statement'!$S14=\"\",\"\",'Purpose Statement'!$S14)","v":""}]
["RV6","Over the timespan, the sampling frequency was appropriate for the given purpose.  ",null,null,null,null,null,null,null,null,{"$f":"IF('Purpose Statement'!$P15=\"\",\"\",'Purpose Statement'!$P15)","v":""},{"$f":"IF('Purpose Statement'!$S15=\"\",\"\",'Purpose Statement'!$S15)","v":""}]
["RV7","Conditions during sampling events were documented and relevant for the given purpose (e.g., baseflow, storm events, planned/unplanned discharges, etc.).  ",null,null,null,null,null,null,null,null,{"$f":"IF('Purpose Statement'!$P16=\"\",\"\",'Purpose Statement'!$P16)","v":""},{"$f":"IF('Purpose Statement'!$S16=\"\",\"\",'Purpose Statement'!$S16)","v":""}]
["RV8","The analyte(s) reported was/were appropriate for the given purpose.",null,null,null,null,null,null,null,null,{"$f":"IF('Purpose Statement'!$P17=\"\",\"\",'Purpose Statement'!$P17)","v":""},{"$f":"IF('Purpose Statement'!$S17=\"\",\"\",'Purpose Statement'!$S17)","v":""}]
["RV9","The method was sensitive enough for the given purpose (i.e., the LOD and/or LOQ were below the benchmarks or metrics to which concentrations in the dataset will be compared).",null,null,null,null,null,null,null,null,{"$f":"IF('Purpose Statement'!$P18=\"\",\"\",'Purpose Statement'!$P18)","v":""},{"$f":"IF('Purpose Statement'!$S18=\"\",\"\",'Purpose Statement'!$S18)","v":""}]
["RV10","The summary statistics provided (e.g., median, geometric mean, arithmetic mean, percentiles) were appropriate for the given purpose. ",null,null,null,null,null,null,null,null,{"$f":"IF('Purpose Statement'!$P19=\"\",\"\",'Purpose Statement'!$P19)","v":""},{"$f":"IF('Purpose Statement'!$S19=\"\",\"\",'Purpose Statement'!$S19)","v":""}]
["RV11","All supporting parameters that were needed to achieve the given purpose were provided. ",null,null,null,null,null,null,null,null,{"$f":"IF('Purpose Statement'!$P20=\"\",\"\",'Purpose Statement'!$P20)","v":""},{"$f":"IF('Purpose Statement'!$S20=\"\",\"\",'Purpose Statement'!$S20)","v":""}]
["FIT FOR PURPOSE"]
["Assessment Level",null,null,"Data Reliability",null,"Data Relevance",null,"Data Usability","Interpretation","Limitations/Restrictions"]
["Silver\n(required level)",null,null,{"$f":"IF(Report!C5=\"\",\"\",Report!C5)","v":"Did not pass Gateway Criteria"},null,{"$f":"IF(Report!D5=\"\",\"\",Report!D5)","v":"Did not pass Gateway Criteria"},null,{"$f":"IF(Report!E5=\"\",\"\",Report!E5)","v":"Not Usable"},{"$f":"IF(Report!F5=\"\",\"\",Report!F5)","v":"Does not meet minimum requirements"},{"$f":"IF(Report!H5=\"\",\"\",Report!H5)","v":""},null,{"$f":"IF(Report!J5=\"\",\"\",Report!J5)","v":""},{"$f":"IF(Report!K5=\"\",\"\",Report!K5)","v":3}]
["Gold\n(recommended level)",null,null,{"$f":"IF(Report!C6=\"\",\"\",Report!C6)","v":"Did not pass Gateway Criteria"},null,{"$f":"IF(Report!D6=\"\",\"\",Report!D6)","v":"Did not pass Gateway Criteria"},null,{"$f":"IF(Report!E6=\"\",\"\",Report!E6)","v":"Not Usable"},{"$f":"IF(Report!F6=\"\",\"\",Report!F6)","v":"Does not meet minimum requirements"},{"$f":"IF(Report!H6=\"\",\"\",Report!H6)","v":""},null,{"$f":"IF(Report!J6=\"\",\"\",Report!J6)","v":""},{"$f":"IF(Report!K6=\"\",\"\",Report!K6)","v":3}]
[]
["GATEWAY CRITERIA"]
["No.","Title ",null,null,"Criterion",null,null,null,null,null,null,null,"Answer"]
[1,"Sampling Medium/ Matrix",null,null,"Does the study specify which medium/matrix is sampled? ",null,null,null,null,null,null,null,{"$f":"IF('Gateway Criteria'!H5=0,\"\",'Gateway Criteria'!H5)","v":""}]
[2,"Analyte ",null,null,"Does the study specify which unique analyte is measured?  ",null,null,null,null,null,null,null,{"$f":"IF('Gateway Criteria'!H6=0,\"\",'Gateway Criteria'!H6)","v":""}]
[3,"Spatial Location ",null,null,"Does the study specify where samples were collected? At a minimum, there is enough information for the given purpose (e.g., country). ",null,null,null,null,null,null,null,{"$f":"IF('Gateway Criteria'!H7=0,\"\",'Gateway Criteria'!H7)","v":""}]
[4,"Year",null,null,"Does the study indicate when samples were collected? At a minimum, there is enough information for the given purpose (e.g., sampling year).",null,null,null,null,null,null,null,{"$f":"IF('Gateway Criteria'!H8=0,\"\",'Gateway Criteria'!H8)","v":""}]
[5,"Units ",null,null,"Does the study specify units of measurement? ",null,null,null,null,null,null,null,{"$f":"IF('Gateway Criteria'!H9=0,\"\",'Gateway Criteria'!H9)","v":""}]
[6,"Data source/ Citation ",null,null,"Does the study cite the source of data and/or is a suitable bibliographic reference available for the study? ",null,null,null,null,null,null,null,{"$f":"IF('Gateway Criteria'!H10=0,\"\",'Gateway Criteria'!H10)","v":""}]
["RELIABILITY CRITERIA"]
["Class",null,"No.","Title",null,null,"Criterion",null,null,null,null,"Conclusion","Status"]
["Media",null,"RB01","Sample Medium/ Matrix",null,null,"Was the sampling medium/matrix reported in detail (for water: dissolved fraction or whole water; for sediment: sieved or whole; for soil, grain size; for biota, species, age, sex, tissue type), and was the matrix appropriate for the analyte of interest?",null,null,null,null,{"$f":"IF('Reliability Criteria'!$J5=\"\",\"\",'Reliability Criteria'!$J5)","v":"Not Reported"},{"$f":"'Reliability Criteria'!M5","v":"Required"}]
[null,null,"RB02","Collection Method/ Sample Type",null,null,"Was the sample collection method reported? Examples include grab, depth- and width-integrated, discrete, composite, or time-integrated samples, or continuous monitoring.",null,null,null,null,{"$f":"IF('Reliability Criteria'!$J6=\"\",\"\",'Reliability Criteria'!$J6)","v":"Not Reported"},{"$f":"'Reliability Criteria'!M6","v":"Recommended"}]
[null,null,"RB03","Sample Handling",null,null,"Was information reported on sample handling (transport conditions, preservation, filtration, storage)? Was the type of container suitable for use with the analyte of interest? (i.e., no loss or contamination)",null,null,null,null,{"$f":"IF('Reliability Criteria'!$J7=\"\",\"\",'Reliability Criteria'!$J7)","v":"Not Reported"},{"$f":"'Reliability Criteria'!M7","v":"Recommended"}]
["Spatial",null,"RB04","Site Location",null,null,"Were the site locations reported?",null,null,null,null,{"$f":"IF('Reliability Criteria'!$J8=\"\",\"\",'Reliability Criteria'!$J8)","v":"Not Reported"},{"$f":"'Reliability Criteria'!M8","v":"Required"}]
["Temporal",null,"RB05","Date and Time",null,null,"Were the date and time of sample collection reported?",null,null,null,null,{"$f":"IF('Reliability Criteria'!$J9=\"\",\"\",'Reliability Criteria'!$J9)","v":"Not Reported"},{"$f":"'Reliability Criteria'!M9","v":"Required"}]
["Analytical",null,"RB06","Analyte(s) Measured",null,null,"Was the analyte(s) of interest suitably and definitively identified? ",null,null,null,null,{"$f":"IF('Reliability Criteria'!$J10=\"\",\"\",'Reliability Criteria'!$J10)","v":"Not Reported"},{"$f":"'Reliability Criteria'!M10","v":"Required"}]
[null,null,"RB07","LoD and/or LoQ",null,null,"Were limits of detection and/or quantitation provided? ",null,null,null,null,{"$f":"IF('Reliability Criteria'!$J11=\"\",\"\",'Reliability Criteria'!$J11)","v":"Not Reported"},{"$f":"'Reliability Criteria'!M11","v":"Required"}]
[null,null,"RB08","Accreditation/ Quality Management System",null,null,"Were the laboratory and method accredited for all or almost all samples? Several national and international accreditation bodies are available (e.g. ISO, UKAS); Was that laboratory and/or method certified to these standards? Was a quality system (such as e.g. ISO 17025) adopted?  If these criteria are 'Fully Met', please proceed to No. RB13. If not, please proceed to additional questions Nos. RB09-RB12.",null,null,null,null,{"$f":"IF('Reliability Criteria'!$J12=\"\",\"\",'Reliability Criteria'!$J12)","v":"Not Reported"}]
[null,null,"RB09","Method",null,null,"Was the method sufficiently described or referenced, such that it can be reproduced if necessary? Was method validation included?",null,null,null,null,{"$f":"IF('Reliability Criteria'!$J13=\"\",\"\",'Reliability Criteria'!$J13)","v":"Not Reported"},{"$f":"'Reliability Criteria'!M13","v":"Required"}]
[null,null,"RB10","Lab Blank Contamination",null,null,"Was method blank contamination assessed with laboratory blanks?",null,null,null,null,{"$f":"IF('Reliability Criteria'!$J14=\"\",\"\",'Reliability Criteria'!$J14)","v":"Not Reported"},{"$f":"'Reliability Criteria'!M14","v":"Recommended"}]
[null,null,"RB11","Recovery/ Accuracy",null,null,"Were method recovery/accuracy and/or uncertainty assessed by recovery of standard reference material (SRM) and/or were lab spike samples assessed?",null,null,null,null,{"$f":"IF('Reliability Criteria'!$J15=\"\",\"\",'Reliability Criteria'!$J15)","v":"Not Reported"},{"$f":"'Reliability Criteria'!M15","v":"Recommended"}]
[null,null,"RB12","Reproducibility/ Precision",null,null,"Were method reproducibility and/or uncertainty assessed with lab replicates and long-term control recoveries?",null,null,null,null,{"$f":"IF('Reliability Criteria'!$J16=\"\",\"\",'Reliability Criteria'!$J16)","v":"Not Reported"},{"$f":"'Reliability Criteria'!M16","v":"Recommended"}]
[null,null,"RB13","Field QC",null,null,"Were quality control (QC) samples collected during field sampling (such as field blanks, spikes, replicates) to demonstrate the method performance for a given field study?",null,null,null,null,{"$f":"IF('Reliability Criteria'!$J17=\"\",\"\",'Reliability Criteria'!$J17)","v":"Not Reported"},{"$f":"'Reliability Criteria'!M17","v":"Recommended"}]
["Data Handling & Statistics",null,"RB14","Calculations (if dataset contains calculated values)",null,null,"If chemical concentrations were normalised or adjusted (e.g., to represent bioavailability or toxicity), then were the calculations explained and were they appropriate?",null,null,null,null,{"$f":"IF('Reliability Criteria'!$J18=\"\",\"\",'Reliability Criteria'!$J18)","v":"Not Reported"},{"$f":"'Reliability Criteria'!M18","v":"Recommended"}]
[null,null,"RB15","Significant Figures (if dataset contains calculated values)",null,null,"During calculations, were data reported to the appropriate number of significant figures or decimal places?",null,null,null,null,{"$f":"IF('Reliability Criteria'!$J19=\"\",\"\",'Reliability Criteria'!$J19)","v":"Not Reported"},{"$f":"'Reliability Criteria'!M19","v":"Recommended"}]
[null,null,"RB16","Outliers (if dataset mentions outliers)",null,null,"For any outliers deleted from the data set, was evidence provided that these outliers were due to an error in measurement or contamination?",null,null,null,null,{"$f":"IF('Reliability Criteria'!$J20=\"\",\"\",'Reliability Criteria'!$J20)","v":"Not Reported"},{"$f":"'Reliability Criteria'!M20","v":"Recommended"}]
[null,null,"RB17","Censored Data (if dataset contains censored values)",null,null,"Were censored data reported correctly (e.g., as a numerical value plus a less-than sign or another indicator of a nondetect)? If a substitution method was used for nondetects (e.g., censored data were replaced by zero, or by 1/2 or another fraction of the LOD/LOQ), then can the original censored data be restored by back-calculation using the reported LOD/LOQ?",null,null,null,null,{"$f":"IF('Reliability Criteria'!$J21=\"\",\"\",'Reliability Criteria'!$J21)","v":"Not Reported"},{"$f":"'Reliability Criteria'!M21","v":"Required"}]
[null,null,"RB18","Summary Statistics Procedures (if dataset contains summary statistics)",null,null,"Were summary statistics calculated appropriately? If the dataset contained censored data, then were censored data included and were appropriate procedures used to determine summary statistics?",null,null,null,null,{"$f":"IF('Reliability Criteria'!$J22=\"\",\"\",'Reliability Criteria'!$J22)","v":"Not Reported"},{"$f":"'Reliability Criteria'!M22","v":"Recommended"}]
["Supporting Parameters",null,"RB19","Supporting Data Quality (if supporting parameters are required for the purpose)",null,null,"If any supporting parameters are required for the assessment purpose, then were the supporting parameter data provided, and were their methods and data quality addressed?   ",null,null,null,null,{"$f":"IF('Reliability Criteria'!$J23=\"\",\"\",'Reliability Criteria'!$J23)","v":"Not Reported"},{"$f":"'Reliability Criteria'!M23","v":"Recommended"}]
[]
[]
[]
["RELEVANCE CRITERIA"]
["Class",null,"No.","Title",null,null,"Criterion",null,null,null,null,"Conclusion","Status"]
["Media",null,"RV01","Sample Medium/ Matrix",null,null,"Was the sampling medium/matrix appropriate for the given purpose?",null,null,null,null,{"$f":"IF('Relevance Criteria'!J5=\"\",\"\",'Relevance Criteria'!J5)","v":"Not Reported"},{"$f":"'Relevance Criteria'!M5","v":"Required"}]
[null,null,"RV02","Collection Method/ Sample Type",null,null,"Was the sample collection method (e.g., grab, depth- and width-integrated, discrete, composite, or time-integrated samples, or continuous monitoring) adequate for the given purpose?",null,null,null,null,{"$f":"IF('Relevance Criteria'!J6=\"\",\"\",'Relevance Criteria'!J6)","v":"Not Reported"},{"$f":"'Relevance Criteria'!M6","v":"Recommended"}]
["Spatial",null,"RV03","Study Area",null,null,"Were the study area and number of locations sampled suitable for the given purpose?",null,null,null,null,{"$f":"IF('Relevance Criteria'!J7=\"\",\"\",'Relevance Criteria'!J7)","v":"Not Reported"},{"$f":"'Relevance Criteria'!M7","v":"Required"}]
[null,null,"RV04","Site Type",null,null,"Was the rationale for selection of sampling locations provided and was it suitable for the given purpose?",null,null,null,null,{"$f":"IF('Relevance Criteria'!J8=\"\",\"\",'Relevance Criteria'!J8)","v":"Not Reported"},{"$f":"'Relevance Criteria'!M8","v":"Recommended"}]
["Temporal",null,"RV05","Sampling Timespan",null,null,"Were the samples collected over a time scale that was appropriate for the given purpose?",null,null,null,null,{"$f":"IF('Relevance Criteria'!J9=\"\",\"\",'Relevance Criteria'!J9)","v":"Not Reported"},{"$f":"'Relevance Criteria'!M9","v":"Required"}]
[null,null,"RV06","Sampling Frequency",null,null,"Over the timespan, was the sampling frequency appropriate for the given purpose?",null,null,null,null,{"$f":"IF('Relevance Criteria'!J10=\"\",\"\",'Relevance Criteria'!J10)","v":"Not Reported"},{"$f":"'Relevance Criteria'!M10","v":"Required"}]
[null,null,"RV07","Temporal Conditions",null,null,"Were conditions during sampling events documented and relevant for the given purpose (e.g., baseflow, storm events, planned/unplanned discharges, etc.)?",null,null,null,null,{"$f":"IF('Relevance Criteria'!J11=\"\",\"\",'Relevance Criteria'!J11)","v":"Not Reported"},{"$f":"'Relevance Criteria'!M11","v":"Recommended"}]
["Analytical",null,"RV08","Analyte",null,null,"Was/were the reported analyte(s) appropriate for the given purpose?",null,null,null,null,{"$f":"IF('Relevance Criteria'!J12=\"\",\"\",'Relevance Criteria'!J12)","v":"Not Reported"},{"$f":"'Relevance Criteria'!M12","v":"Required"}]
[null,null,"RV09","Sensitivity/ LOD/ LOQ",null,null,"Was the method sensitive enough for the given purpose (i.e., were the LOD and/or LOQ below the benchmarks or metrics to which concentrations in the dataset will be compared)?",null,null,null,null,{"$f":"IF('Relevance Criteria'!J13=\"\",\"\",'Relevance Criteria'!J13)","v":"Not Reported"},{"$f":"'Relevance Criteria'!M13","v":"Required"}]
["Data Handling & Statistics",null,"RV10","Summary Statistics Type (if dataset contains summary statistics)",null,null,"Were the summary statistics provided (e.g., median, geometric mean, arithmetic mean, percentiles) appropriate for the given purpose?",null,null,null,null,{"$f":"IF('Relevance Criteria'!J14=\"\",\"\",'Relevance Criteria'!J14)","v":"Not Reported"},{"$f":"'Relevance Criteria'!M14","v":"Recommended"}]
["Supporting Parameters",null,"RV11","Supporting Parameters (if supporting parameters are required for the purpose)",null,null,"Were all supporting parameters provided that were needed to achieve the given purpose?",null,null,null,null,{"$f":"IF('Relevance Criteria'!J15=\"\",\"\",'Relevance Criteria'!J15)","v":"Not Reported"},{"$f":"'Relevance Criteria'!M15","v":"Required"}]

{"sheet":"Conclusions_(hidden)","index":12,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["Conclusion","Value","Reliability","Relevance","Usability","Interpretation"]
["Fully Met",1,"Reliable Without Restrictions","Relevant Without Restrictions","Usable Without Restrictions","Meets minimum requirements without restrictions/limitations"]
["Partly Met",2,"Reliable With Restrictions","Relevant With Restrictions","Usable With Restrictions","Meets minimum requirements with restrictions/limitations"]
["Not Reported",3,"Reliability Not Assignable","Relevance Not Assignable","Not Usable","Missing data, so does not currently meet minimum requirements"]
["Not Met",4,"Not Reliable","Not Relevant","Not Usable","Does not meet minimum requirements"]
["Not Applicable",0,"Reliability Not Assignable","Relevance Not Assignable","Not Usable","Missing data, so does not currently meet minimum requirements"]
["Skipped",1,"Reliable Without Restrictions","Relevant Without Restrictions","Usable Without Restrictions","Meets minimum requirements without restrictions/limitations"]