{"text_format":"2","workbook":"xlsx","n_sheets":6,"sheets":["Introduction","Data_Template_Summary","Sample_Metadata","Chemical_Analysis","drop-down menus","Elem. Conc. (1)"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Introduction","index":0,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,0,21,11]]}
["This spreadsheet is a template for the data and information collected as part of FOA 3077 \"CORE-CM Resource Assessment\".  The spreadsheet comprises the relevant data and metadata fields needed to ensure proper context for the sample data used in an assessment of REE's in coal and other unconventional resources.  \n\nIt is suggested to first review the \"Data_Template_Summary\" tab to familiarize with the types of data and information requested for each sample or aliquot.  Included for each field is the level of importance that the field is populated.  At a minimum, please populate all \"critical\" fields (where applicable).\n\nSample data and information can be entered in the \"Sample_Metadata\" and \"Chemical_Analysis\" tabs.  ID fields in these tabs are auto-formatted to highlight duplicate entries to flag potential errors.  Select fields have drop-down menus where anticipated values can be selected; to enter custom values, simply click \"OK\" in the pop-up window and proceed to enter the information.  If needing to copy/paste values, please paste as \"values only\" to preserve sheet formatting.\n\n\nContact information for questions/comments: \nScott Montross, Technology Manager, Critical Minerals & Materials, NETL (Scott.Montross@netl.doe.gov)\nJessica Mullen, Technology Manager, Critical Minerals & Materials, NETL (Jessica.Mullen@netl.doe.gov)\nKelly Rose, Principal Investigator, NETL (Kelly.Rose@netl.doe.gov)\nGabe Creason, Co-Principal Investigator, NETL (Christopher.Creason@netl.doe.gov)\nBurt Thomas, Technical Portfolio Lead, NETL (Burt Thomas@netl.doe.gov)"]

{"sheet":"Data_Template_Summary","index":1,"n_rows":114,"n_cols":4,"rows_kept":114,"cut":false,"hidden":false,"merged":[]}
["Category","Fields","Level of Importance","Suggested / Example  Responses"]
["Sample Identification","Unique ID / Sample ID","critical"]
[null,"Project ID","if known"]
[null,"Lab ID","if known"]
[null,"Field ID (if different from Lab ID)","if known"]
[null,"Stratigraphic ID in USGS COAL QUAL database","if known"]
[null,"API number","if known"]
[null,"Other alias (if applicable)","if known"]
[]
[]
["Sample Description","Sample material","critical","e.g., coal, fly ash, acid mine drainage"]
[null,"Sample detail (if hand sample)","critical","single rock hand sample; bulk rock hand sample (numerous pieces from same coalbed)"]
[null,"Sample detail (if from underground)","critical","drill core, underground mine"]
[null,"Sample Thickness [cm]","important"]
[null,"Sample location within stratigraphy or coal seam","important","seam, roof, floor, parting"]
[null,"Coal seam thickness [meters]","important"]
[null,"Coal seam name (if different from stratigraphic name)","important"]
[null,"Straigraphic unit association of coal seam","important","Formation, Group, Member,  bed"]
[null,"Geologic age of coal seam (Period or Epoch) ","if known","e.g., Pennsylvanian"]
[null,"Sample status","important","representative piece of sample exists, entire sample destroyed during analyses"]
[null,"Photos","if known","photo number; file location; point of contact"]
[null,"Sample description (any additional relevant information)","important"]
[]
[]
["Geolocation","Latitude","critical"]
[null,"Longitude","critical"]
[null,"Depth","critical","negative if collected from core "]
[null,"X","critical","e.g., UTM"]
[null,"Y","critical","e.g., UTM"]
[null,"Z ","critical","e.g., UTM"]
[null,"datum","critical"]
[null,"spheroid","if known"]
[null,"projection","if known"]
[null,"township","if known"]
[null,"range","if known"]
[null,"City (nearest)","if known"]
[null,"County","if known"]
[null,"State","if known"]
[null,"Country","if known"]
[null,"Sedimentary basin","if known"]
[null,"Coal field","if known","Enter name of coal field.  Refer to U.S. Geological Survey Open-File Report 2012–1205"]
[]
[]
["Site Characteristics","Unique site ID","critical","name"]
[null,"Company, Owner, Operator","critical","name"]
[null,"Physical setting or environment ","important","e.g., collected from roadcut along Hwy 99"]
[null,"Site ownership","important","public property, private property"]
[null,"Lithology of rock contacting upper coal seam","important","e.g., sandstone"]
[null,"Lithology of rock contacting lower coal seam","important","e.g., shale"]
[null,"Clay present (observed) in coal seam / core","important","yes, no"]
[null,"Depth of coal seam from surface, overburden [meters]","important"]
[null,"Proximity to igneous/metamorphic rock nearby (estimated) [kilometers]","if known"]
[null,"Outcrop / core condition","if known","fresh, weathered"]
[null,"Local geologic structure","if known","antiform, anticline, synform, syncline, monocline"]
[null,"Faults observed in outcrop/core","if known","yes, no"]
[null,"Proximity to nearby fault (if observed) [kilometers]","if known"]
[null,"Proximal fault type (if present)","if known","normal, reverse, strike slip, vertical, unknown"]
[null,"Coal cleat observed","important","yes, no"]
[null,"Most likely mechanism of REE concentration","if known","volcanic ash-fall, meteoric enrichment, hydrothermal enrichment, other, unknown"]
[null,"Tonnage and grades of commodity oxides (mine site)","if known"]
[null,"Key comments (any comments relevant to day of sample collection)","important"]
[null,"Picture/Photo","if known","e.g., file number or URL for download"]
[]
[]
["Collection Information","Project ID / Lab ID","critical"]
[null,"Name of sample collector","critical","name"]
[null,"Date Collected","critical","YYYYMMDD"]
[null,"Date Catalogued","important","YYYYMMDD"]
[null,"Date Analyzed","important","YYYYMMDD"]
[null,"Date Analyses Published","if known","YYYYMMDD"]
[null,"Date uploaded to EDX","if known","YYYYMMDD"]
[]
[]
["Other Metadata","contact info - principle investigator / project coordinator","critical","name, email, phone"]
[null,"contact info - lab ","critical","name, email, phone"]
[null,"Contact info - sample collector","important","name, email, phone"]
[null,"contact info - sample curator","important","name, email, phone"]
[null,"Link or source to other data or studies associated with samples","important"]
[null,"Data uploaded to Energy Data Exchange?","important","yes, no"]
[]
[]
["Chemical Analysis","Sample ID","critical"]
[null,"Lab ID (of the sample; if different from Sample ID)","critical"]
[null,"Laboratory where analyses completed","critical"]
[null,"Analysis technique","critical","XRF, ICP-MS, INAA, etc."]
[null,"Sample preperation method","critical"]
[null,"Digestion method","critical","Method to digest the solid (e.g., fusion w/ lithium metaborate)"]
[null,"Whole rock or ash yield?","critical","Whole rock, ash"]
[null,"Coal rank","if known","lignite, sub-bituminous, bituminous, anthracite"]
[null,"Alteration","important","indicate type"]
[null,"REE-bearing minerals identified in the coal","if known","indicate type"]
[null,"Other significant minerology","if known"]
[null,"Notes","critical","any additional relevant notes"]
[null,"Elements [ppm]","critical","Li, Be, B, F, Na, Mg, Al, Si, P, Cl, K, Ca, Sc, Ti, V, Cr, Fe, Co, Ni, Cu, Zn, Ga, Ge, As, Se, Rb, Sr, Y, Zr, Nb, Mo, Ag, Cd, In, Sn, Sb, Cs, Ba"]
[null,"Lanthanides [ppm]","critical","La, Ce, Pr, Nd, Pm, Sm, Eu, Gd, Tb, Dy, Y, Ho, Er, Tm, Yb, Lu"]
[null,"Other metals [ppm]","important","Hf, Ta, W, Hg, Tl, Pb, Bi"]
[null,"Actinides [ppm]","important","U, Th"]
[null,"Total REE concentration (whole rock) [ppm]","critical"]
[null,"Total REE + Y concentration (whole rock) [ppm]","critical"]
[null,"Total REE concentration (ashed) ","critical"]
[null,"Total REE + Y concentration (ashed) ","critical"]
[null,"Oxides [ppm]","important","Al2O3, SiO2, CaO, K2O, TiO2, Fe2O3, MgO, Na2O, MnO, P2O5"]
[null,"Radiometric age [Ma]","if known"]
[null,"Sulfur [wt %]","important"]
[null,"Moisture content [wt %]","important"]
[null,"Volatile matter content [wt %]","important"]
[null,"Fixed carbon content [wt %]","important"]
[null,"Ash yield [Dry, wt %]","important"]
[null,"Carbon [%]","important"]
[null,"Hydrogen [%]","important"]
[null,"Sulfur [%]","important"]
[null,"Oxygen [%]","important"]
[null,"Nitrogen [%]","important"]
[null,"Vitrinite Reflectance [%Ro]","if known"]

{"sheet":"Sample_Metadata","index":2,"n_rows":1004,"n_cols":104,"rows_kept":1004,"cut":false,"hidden":false,"merged":[[0,64,0,69],[0,0,0,6],[0,8,0,19],[0,21,0,36],[0,38,0,54],[0,56,0,62]]}
["Sample Identification",{"$nulls":7},"Sample Description",{"$nulls":12},"Geolocation",{"$nulls":16},"Site Characteristics",{"$nulls":17},"Collection Information",{"$nulls":7},"Other Metadata"]
["Unique ID / Sample ID","Project ID","Lab ID","Field ID \n(if different from Lab ID)","Stratigraphic ID in USGS COAL QUAL database","API number","Other alias \n(if applicable)",null,"Sample material","Sample detail (if hand sample)","Sample detail (if from underground)","Sample Thickness \n[cm]","Sample location within stratigraphy or coal seam","Coal seam thickness \n[meters]","Coal seam name \n(if different from stratigraphic name)","Straigraphic unit association of coal seam","Geologic age of coal seam \n(Period or Epoch) ","Sample status","Photos","Sample description",null,"Latitude","Longitude","Depth","X","Y","Z ","datum","spheroid","projection","township","range","City (nearest)","County","State","Country","Coal basin",null,"Unique site ID","Name of company, owner, or operator","Physical setting or environment ","Site ownership","Lithology of rock contacting upper coal seam","Lithology of rock contacting lower coal seam","Depth of coal seam from surface, overburden [meters]","Igneous/metamorphic rock nearby","Outcrop/core condition","Geologic folds","Faults observed in outcrop/core","Proximity to nearby fault (if observed) [kilometers]","Coal cleat observed","Most likely mechanism of REE concentration","Tonnage and grades of commodity oxides \n(mine site)","Key comments","Picture/Photo",null,"Project ID / Lab ID","Name of sample collector","Date Collected\n[YYYYMMDD]\n","Date Catalogued\n[YYYYMMDD]","Date Analyzed\n[YYYYMMDD]","Date Analyses Published\n[YYYYMMDD]","Date uploaded to EDX\n[YYYYMMDD]",null,"Contact info - Principle investigator / project coordinator","Contact info - \nLab name","Contact info - \nSample collector","Contact info - Sample curator","Link or source to other data or studies associated with samples","Data uploaded to Energy Data Exchange?",{"$nulls":33},"X"]
{"$rows_empty":1001}
[{"$nulls":69},"yes"]

{"sheet":"Chemical_Analysis","index":3,"n_rows":3,"n_cols":101,"rows_kept":3,"cut":false,"hidden":false,"merged":[[1,87,2,87],[1,88,2,88],[0,87,0,88],[0,77,0,86],[0,50,0,63],[0,64,0,70],[0,71,0,72],[0,12,0,49]]}
["Sample ID","Lab ID \n(of the sample, if different from Sample ID)","Laboratory where analyses completed","Analysis technique","Sample preparation method","Digestion method","Whole rock or ash yield?","Coal rank","Alteration","REE-bearing minerals identified in the coal","Other significant minerology","Notes","Elements\n[ppm]",{"$nulls":37},"Lanthanides \n[ppm]",{"$nulls":13},"Other metals \n[ppm]",{"$nulls":6},"Actinides \n[ppm]",null,"Total REE \n(whole rock) [ppm]","Total REE + Y \n(whole rock) \n[ppm]","Total REE \n(ashed) [ppm]","Total REE + Y \n(ashed) \n[ppm]","Oxides \n[ppm]",{"$nulls":9},"Mineral Phase Identification",null,"Radiometric age\n[Ma]","Sulfur \n[wt %]","Moisture content \n[wt %]","Volatile matter content \n[wt %]","Fixed carbon content \n[wt %]","Ash yield \n[Dry, wt %]","Carbon \n[%]","Hydrogen \n[%]","Sulfur \n[%]","Oxygen \n[%]","Nitrogen \n[%]","Vitrinite reflectance \n[%Ro]"]
[{"$nulls":12},"Li","Be","B","F","Na","Mg","Al","Si","P","Cl","K","Ca","Sc","Ti","V","Cr","Fe","Co","Ni","Cu","Zn","Ga","Ge","As","Se","Rb","Sr","Y","Zr","Nb","Mo","Ag","Cd","In","Sn","Sb","Cs","Ba","La","Ce","Pr","Nd","Sm","Eu","Gd","Tb","Dy","Ho","Er","Tm","Yb","Lu","Hf","Ta","W","Hg","Tl","Pb","Bi","Th","U",{"$nulls":4},"Al2O3"," SiO2"," CaO"," K2O"," TiO2"," Fe2O3"," MgO"," Na2O"," MnO"," P2O5","Primary Minerals","Secondary Minerals"]
[{"$nulls":12},3,4,5,9,11,12,13,14,15,17,19,20,21,22,23,24,26,27,28,29,30,31,32,33,34,37,38,39,40,41,42,47,48,49,50,51,55,56,57,58,59,60,62,63,64,65,66,67,68,69,70,71,72,73,74,80,81,82,83,90,92]

{"sheet":"drop-down menus","index":4,"n_rows":18,"n_cols":22,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["Sample material","Sample type (if hand sample)","Sample type - hand sample 2","Sample type (if from underground)","Sample type - coal ash","Sample type - aqueous by-products","Sample location within stratigraphy or coal seam","Straigraphic unit association of coal seam","Sample status","Company, Owner, or Operator","Site status","Development status 2","Outcrop / core condition","Local geologic structure","Faults observed in outcrop/core?","Proximal fault type (if present)","Coal cleat observed?","Most likely mechanism of REE concentration","Analysis technique","Whole rock or ash yield?","Coal rank","Data uploaded to Energy Data Exchange?"]
["Coal","single rock hand sample","in situ","drill core","fly","waste water residue","seam","Formation","representative piece of sample exists","company","public property","commercial","fresh","antiform","yes","normal","yes","volcanic ash-fall","XRF","Whole rock","lignite","yes"]
["Clean Coal","bulk rock hand sample (numerous pieces from same coalbed)","float","underground mine","bottom","coal mine drainage","roof","Group","entire sample destroyed during analyses","owner","private property, commercial","residential","weathered","anticline","no","reverse","no","meteoric enrichment","ICP-MS","Ash","sub-bituminous","no"]
["Parting",null,null,null,"ponded","runoff","floor","Member",null,"operator","private property, residential",null,null,"synform",null,"strike slip",null,"hydrothermal enrichment","ICP-OES",null,"bituminous"]
["Seam Roof Rock",null,null,null,"landfill",null,"parting","Bed",{"$nulls":5},"syncline",null,"vertical",null,"other","LIBS",null,"anthracite"]
["Seam Floor Rock",{"$nulls":12},"monocline",null,"unknown",null,"unknown","INAA"]
["Bottom Ash"]
["Fly Ash"]
["Ash"]
["Refuse"]
["Fine Coal By-Product"]
["Coarse Refuse"]
["Disposed Combustion By-Products"]
["Coal Mine Drainage"]
["Acid Mine Drainage"]
["Acid Mine Drainage - Sludge"]
["Aqueous"]
["N/A"]

{"sheet":"Elem. Conc. (1)","index":5,"n_rows":63,"n_cols":61,"rows_kept":63,"cut":false,"hidden":true,"merged":[]}
["Elements in coals from China - Dai et al., 2012 COAL_GEOLOGY"]
[]
["Li","Be","B","F","Cl","Sc","V","Cr","Co","Ni","Cu","Zn","Ga","Ge","As","Se","Rb","Sr","Y","Zr","Nb","Mo","Cd","In","Sn","Sb","Cs","Ba","La","Ce","Pr","Nd","Sm","Eu","Gd","Tb","Dy","Ho","Er","Tm","Yb","Lu","Hf","Ta","W","Hg","Tl","Pb","Bi","Th","U","Al2O3%","SiO2%","CaO%","K2O%","TiO2%","Fe2O3%","MgO%","Na2O%","MnO%","P2O5%"]
["Be"]
["B"]
["F"]
["Cl"]
["Sc"]
["V"]
["Cr"]
["Co"]
["Ni"]
["Cu"]
["Zn"]
["Ga"]
["Ge"]
["As"]
["Se"]
["Rb"]
["Sr"]
["Y"]
["Zr"]
["Nb"]
["Mo"]
["Cd"]
["In"]
["Sn"]
["Sb"]
["Cs"]
["Ba"]
["La"]
["Ce"]
["Pr"]
["Nd"]
["Sm"]
["Eu"]
["Gd"]
["Tb"]
["Dy"]
["Ho"]
["Er"]
["Tm"]
["Yb"]
["Lu"]
["Hf"]
["Ta"]
["W"]
["Hg"]
["Tl"]
["Pb"]
["Bi"]
["Th"]
["U"]
["Al2O3%"]
["SiO2%"]
["CaO%"]
["K2O%"]
["TiO2%"]
["Fe2O3%"]
["MgO%"]
["Na2O%"]
["MnO%"]
["P2O5%"]