With a step-by-step approach, learn to prepare Excel files, data worksheets, and individual data columns for data analysis; practice conditional formatting and creating pivot tables/charts; go over basic principles of Research Data Management as they might apply to an Excel project. Avec une approche étape par étape, apprenez à préparer pour l’analyse des données des fichiers Excel, des feuilles de calcul de données et des colonnes de données individuelles; pratiquez la mise en forme conditionnelle et la création de tableaux croisés dynamiques ou de graphiques; passez en revue les principes de base de la gestion des données de recherche tels qu’ils pourraient s’appliquer à un projet Excel.

The USDA Agricultural Research Service (ARS) recently established SCINet , which consists of a shared high performance computing resource, Ceres, and the dedicated high-speed Internet2 network used to access Ceres. Current and potential SCINet users are using and generating very large datasets so SCINet needs to be provisioned with adequate data storage for their active computing. It is not designed to hold data beyond active research phases. At the same time, the National Agricultural Library has been developing the Ag Data Commons, a research data catalog and repository designed for public data release and professional data curation. Ag Data Commons needs to anticipate the size and nature of data it will be tasked with handling. The ARS Web-enabled Databases Working Group, organized under the SCINet initiative, conducted a study to establish baseline data storage needs and practices, and to make projections that could inform future infrastructure design, purchases, and policies. The SCINet Web-enabled Databases Working Group helped develop the survey which is the basis for an internal report. While the report was for internal use, the survey and resulting data may be generally useful and are being released publicly. From October 24 to November 8, 2016 we administered a 17-question survey (Appendix A) by emailing a Survey Monkey link to all ARS Research Leaders, intending to cover data storage needs of all 1,675 SY (Category 1 and Category 4) scientists. We designed the survey to accommodate either individual researcher responses or group responses. Research Leaders could decide, based on their unit's practices or their management preferences, whether to delegate response to a data management expert in their unit, to all members of their unit, or to themselves collate responses from their unit before reporting in the survey. Larger storage ranges cover vastly different amounts of data so the implications here could be significant depending on whether the true amount is at the lower or higher end of the range. Therefore, we requested more detail from "Big Data users," those 47 respondents who indicated they had more than 10 to 100 TB or over 100 TB total current data (Q5). All other respondents are called "Small Data users." Because not all of these follow-up requests were successful, we used actual follow-up responses to estimate likely responses for those who did not respond. We defined active data as data that would be used within the next six months. All other data would be considered inactive, or archival. To calculate per person storage needs we used the high end of the reported range divided by 1 for an individual response, or by G, the number of individuals in a group response. For Big Data users we used the actual reported values or estimated likely values. Resources in this dataset:Resource Title: Appendix A: ARS data storage survey questions. File Name: Appendix A.pdfResource Description: The full list of questions asked with the possible responses. The survey was not administered using this PDF but the PDF was generated directly from the administered survey using the Print option under Design Survey. Asterisked questions were required. A list of Research Units and their associated codes was provided in a drop down not shown here. Resource Software Recommended: Adobe Acrobat,url: https://get.adobe.com/reader/ Resource Title: CSV of Responses from ARS Researcher Data Storage Survey. File Name: Machine-readable survey response data.csvResource Description: CSV file includes raw responses from the administered survey, as downloaded unfiltered from Survey Monkey, including incomplete responses. Also includes additional classification and calculations to support analysis. Individual email addresses and IP addresses have been removed. This information is that same data as in the Excel spreadsheet (also provided).Resource Title: Responses from ARS Researcher Data Storage Survey. File Name: Data Storage Survey Data for public release.xlsxResource Description: MS Excel worksheet that Includes raw responses from the administered survey, as downloaded unfiltered from Survey Monkey, including incomplete responses. Also includes additional classification and calculations to support analysis. Individual email addresses and IP addresses have been removed.Resource Software Recommended: Microsoft Excel,url: https://products.office.com/en-us/excel

In order to test hypotheses about groundwater flow under and into estuaries and the Atlantic Ocean, geophysical surveys, geophysical probing, submarine groundwater sampling, and sediment coring were conducted by U.S. Geological Survey (USGS) scientists at Cape Cod National Seashore (CCNS) from 2004 through 2006. Coastal resource managers at CCNS and elsewhere are concerned about nutrients that are entering coastal waters via submarine groundwater discharge, which are contributing to eutrophication and harmful algal blooms. The research carried out as part of the study described here was designed, in part, to help refine assumptions required by earlier versions of models about the nature of submarine groundwater flow and discharge at CCNS. This study was conducted in four phases, with a variety of field techniques and equipment employed in each phase. Phase 1 consisted of continuous resistivity profiling (CRP) surveys of the entire study area conducted in 2004. Phase 2 consisted of CRP ground-truthing via resistivity probe measurements and submarine groundwater sampling from hydraulically-drive piezometers using a barge in the Salt Pond/Nauset Marsh area in 2005. Phase 3 consisted of supplemental detailed CRP surveys in the Salt Pond/Nauset Marsh area in 2006. Finally, Phase 4 consisted of sediment coring and porewater extraction in the Salt Pond/Nauset Marsh area later in 2006 to supplement the 2005 sampling.

This dataset is about book series and is filtered where the books is Microsoft Excel 2000 : introductory concepts and techniques, featuring 10 columns including authors, average publication date, book publishers, book series, and books. The preview is ordered by number of books (descending).

An Excel workbook containing tables of historical census data for a range of indicators dating back to 1961. Available in Excel 2003 (csv download) and Excel 2007-10 (excel download) formats.

The annual Retail store data CD-ROM is an easy-to-use tool for quickly discovering retail trade patterns and trends. The current product presents results from the 1999 and 2000 Annual Retail Store and Annual Retail Chain surveys. This product contains numerous cross-classified data tables using the North American Industry Classification System (NAICS). The data tables provide access to a wide range of financial variables, such as revenues, expenses, inventory, sales per square footage (chain stores only) and the number of stores. Most data tables contain detailed information on industry (as low as 5-digit NAICS codes), geography (Canada, provinces and territories) and store type (chains, independents, franchises). The electronic product also contains survey metadata, questionnaires, information on industry codes and definitions, and the list of retail chain store respondents.

This dataset is about book series and is filtered where the books is Excel at problem solving, featuring 10 columns including authors, average publication date, book publishers, book series, and books. The preview is ordered by number of books (descending).

Spatial analysis and statistical summaries of the Protected Areas Database of the United States (PAD-US) provide land managers and decision makers with a general assessment of management intent for biodiversity protection, natural resource management, and recreation access across the nation. The PAD-US 3.0 Combined Fee, Designation, Easement feature class (with Military Lands and Tribal Areas from the Proclamation and Other Planning Boundaries feature class) was modified to remove overlaps, avoiding overestimation in protected area statistics and to support user needs. A Python scripted process ("PADUS3_0_CreateVectorAnalysisFileScript.zip") associated with this data release prioritized overlapping designations (e.g. Wilderness within a National Forest) based upon their relative biodiversity conservation status (e.g. GAP Status Code 1 over 2), public access values (in the order of Closed, Restricted, Open, Unknown), and geodatabase load order (records are deliberately organized in the PAD-US full inventory with fee owned lands loaded before overlapping management designations, and easements). The Vector Analysis File ("PADUS3_0VectorAnalysisFile_ClipCensus.zip") associated item of PAD-US 3.0 Spatial Analysis and Statistics ( https://doi.org/10.5066/P9KLBB5D ) was clipped to the Census state boundary file to define the extent and serve as a common denominator for statistical summaries. Boundaries of interest to stakeholders (State, Department of the Interior Region, Congressional District, County, EcoRegions I-IV, Urban Areas, Landscape Conservation Cooperative) were incorporated into separate geodatabase feature classes to support various data summaries ("PADUS3_0VectorAnalysisFileOtherExtents_Clip_Census.zip") and Comma-separated Value (CSV) tables ("PADUS3_0SummaryStatistics_TabularData_CSV.zip") summarizing "PADUS3_0VectorAnalysisFileOtherExtents_Clip_Census.zip" are provided as an alternative format and enable users to explore and download summary statistics of interest (Comma-separated Table [CSV], Microsoft Excel Workbook [.XLSX], Portable Document Format [.PDF] Report) from the PAD-US Lands and Inland Water Statistics Dashboard ( https://www.usgs.gov/programs/gap-analysis-project/science/pad-us-statistics ). In addition, a "flattened" version of the PAD-US 3.0 combined file without other extent boundaries ("PADUS3_0VectorAnalysisFile_ClipCensus.zip") allow for other applications that require a representation of overall protection status without overlapping designation boundaries. The "PADUS3_0VectorAnalysis_State_Clip_CENSUS2020" feature class ("PADUS3_0VectorAnalysisFileOtherExtents_Clip_Census.gdb") is the source of the PAD-US 3.0 raster files (associated item of PAD-US 3.0 Spatial Analysis and Statistics, https://doi.org/10.5066/P9KLBB5D ). Note, the PAD-US inventory is now considered functionally complete with the vast majority of land protection types represented in some manner, while work continues to maintain updates and improve data quality (see inventory completeness estimates at: http://www.protectedlands.net/data-stewards/ ). In addition, changes in protected area status between versions of the PAD-US may be attributed to improving the completeness and accuracy of the spatial data more than actual management actions or new acquisitions. USGS provides no legal warranty for the use of this data. While PAD-US is the official aggregation of protected areas ( https://www.fgdc.gov/ngda-reports/NGDA_Datasets.html ), agencies are the best source of their lands data.

In order to test hypotheses about groundwater flow under and into estuaries and the Atlantic Ocean, geophysical surveys, geophysical probing, submarine groundwater sampling, and sediment coring were conducted by U.S. Geological Survey (USGS) scientists at Cape Cod National Seashore (CCNS) from 2004 through 2006. Coastal resource managers at CCNS and elsewhere are concerned about nutrients that are entering coastal waters via submarine groundwater discharge, which are contributing to eutrophication and harmful algal blooms. The research carried out as part of the study described here was designed, in part, to help refine assumptions required by earlier versions of models about the nature of submarine groundwater flow and discharge at CCNS. This study was conducted in four phases, with a variety of field techniques and equipment employed in each phase. Phase 1 consisted of continuous resistivity profiling (CRP) surveys of the entire study area conducted in 2004. Phase 2 consisted of CRP ground-truthing via resistivity probe measurements and submarine groundwater sampling from hydraulically-drive piezometers using a barge in the Salt Pond/Nauset Marsh area in 2005. Phase 3 consisted of supplemental detailed CRP surveys in the Salt Pond/Nauset Marsh area in 2006. Finally, Phase 4 consisted of sediment coring and porewater extraction in the Salt Pond/Nauset Marsh area later in 2006 to supplement the 2005 sampling.

Dataset

This dataset was created by Chandra Shekhar

Released under Other (specified in description)

Contents

The ITEX experiment at Audkuluheidi was started in 1996 when control and OTC plots 1-5 were set up. In 1997 Control and OTC plots 6-10 were set up in the protected area (No Graze). Also in 1997, 10 control plots were set up in the adjacent grazed area (Graze). In 2000, all plots were sampled again. This dataset is in excel format. For more information, please see the readme file.

Small Area and Administrative Data are derived from the annual tax file provided by Canada Revenue Agency. From the income tax forms submitted each year by Canadians, a wealth of economic and demographic information is available. Files include data on Families, Labour Income, Economic Dependency, Seniors, RRSP Contributions and Neighbourhood Income and Demographics. Geographic coverage is by Nation, Province/Territory, Postal Area and by Census Metropolitan Area (CMA).

This is a compilation of logs and data from Well 52-21 in the Roosevelt Hot Springs area in Utah. This well is also in the Utah FORGE study area. The file is in a compressed .zip format and there is a data inventory table (Excel spreadsheet) in the root folder that is a guide to the data that is accessible in subfolders.

Identification of study species

We identified 40 marine species with documented shifts in range limits along the coastline (<15 km from shore) of North America, including plants, invertebrates, fish, a protist, and a bird. Of these, 26 species were compiled by Sorte et al. (2010), and we added 14 species from an updated literature review. We searched Google Scholar (on 08/20/2019) using this search string: marine "range expansion" species "range shift". We reviewed titles and, when appropriate, abstracts and text of the first 600 results, identifying 12 additional species from eight papers. We added two species (Brachidontes adamsianus and Mexacanthina lugubris) from our literature files and personal observations. We excluded migratory or pelagic species with large biogeographic ranges, for which it was difficult to confirm historical native ranges.

Review of published impacts

Evidence of species’ impacts was compiled from online database searches an...

This is a compilation of logs and data from Well 82-33 in the Roosevelt Hot Springs area in Utah. This well is also in the Utah FORGE study area. The file is in a compressed .zip format and there is a data inventory table (Excel spreadsheet) in the root folder that is a guide to the data that is accessible in subfolders.

Data set for: Yamashita T, Vavladeli A, Pala A, Galan K, Crochet S, Petersen SSA, Petersen CCH (2018) Diverse long-range axonal projections of excitatory layer 2/3 neurons in mouse barrel cortex. Front Neuroanat 12: 33. https://doi.org/10.3389/fnana.2018.00033

There are 25 files in this data upload:

1. '2018_Yamashita_FrontNeuroanat.pdf' - this a pdf version of the online publication.

2. 'Yamashita_Figure2_Quantification.xlsx' - this is a Microsoft Excel file giving the locations of high density axonal projections from layer 2/3 pyramidal neurons in the mouse C2 barrel column in the coordinate frame of Paxinos & Franklin (2001) The mouse brain in stereotaxic coordinates. Academic Press. The data are plotted in Figure 2 of Yamashita et al., 2018.

3. 'Yamashita_Figure7_Quantification.xlsx' - this is a Microsoft Excel file giving the dendritic length, number of dendrites, number of dendritic nodes and total axonal length, as well as the axonal length in the different projection zones for each reconstructed neuron. The data are plotted in Figure 7 of Yamashita et al., 2018.

4. 'Yamashita_SupMov1_S2P_AP049.mov' - this is a QuickTime video file, showing the 3D structure of neuron AP049 featured in Figure 3 of Yamashita et al., 2018.

5. 'Yamashita_SupMov2_M1P_TY308.mov' - this is a QuickTime video file, showing the 3D structure of neuron TY308 featured in Figure 5 of Yamashita et al., 2018.

6. 'AV198.zip' - this zipped folder contains data relating to mouse AV198: a) 'AV198_stack.tif' the z-stack of whole-brain fluorescence images from expression of tdTomato in layer 2/3 neurons of the C2 barrel column of mouse AV198. b) 'AV198_ROI_Box.zip' can be loaded into FIJI (https://fiji.sc) and indicates projection regions by a box. c) 'AV198_ROI_Point.zip' can be loaded into FIJI (https://fiji.sc) and indicates projection regions by a point. d) 'AV198_Paxinos' is a folder showing the coronal fluorescent brain sections in pdf format overlaid on the equivalent drawing from Paxinos & Franklin (2001) The mouse brain in stereotaxic coordinates. Academic Press.

7. 'AV199.zip' - same as 'AV198.zip' but for mouse AV199.

8. 'AV201.zip' - same as 'AV198.zip' but for mouse AV201.

9. 'AV202.zip' - same as 'AV198.zip' but for mouse AV202.

10. 'AV203.zip' - same as 'AV198.zip' but for mouse AV203.

11. 'AP042.ASC' - Neurolucida (http://www.mbfbioscience.com/neurolucida) data file of the 3D reconstruction of axon and dendrite from the single neuron labelled in mouse AP042. Brain contours are also traced.

12. 'AP044.ASC' - Neurolucida data file of the 3D reconstruction of axon and dendrite from the single neuron labelled in mouse AP044. Brain contours are also traced.

13. 'AP046.ASC' - Neurolucida data file of the 3D reconstruction of axon and dendrite from the single neuron labelled in mouse AP046. Brain contours are also traced.

14. 'AP047.ASC' - Neurolucida data file of the 3D reconstruction of axon and dendrite from the single neuron labelled in mouse AP047. Brain contours are also traced.

15. 'AP049.ASC' - Neurolucida data file of the 3D reconstruction of axon and dendrite from the single neuron labelled in mouse AP049. Brain contours are also traced.

16. 'TY220.ASC' - Neurolucida data file of the 3D reconstruction of axon and dendrite from the single neuron labelled in mouse TY220. Brain contours are also traced.

17. 'TY288.ASC' - Neurolucida data file of the 3D reconstruction of axon and dendrite from the single neuron labelled in mouse TY288. Brain contours are also traced.

18. 'TY300.ASC' - Neurolucida data file of the 3D reconstruction of axon and dendrite from the single neuron labelled in mouse TY300. Brain contours are also traced.

19. 'TY302.ASC' - Neurolucida data file of the 3D reconstruction of axon and dendrite from the single neuron labelled in mouse TY302. Brain contours are also traced.

20. 'TY308.ASC' - Neurolucida data file of the 3D reconstruction of axon and dendrite from the single neuron labelled in mouse TY308. Brain contours are also traced.

21. 'TY310.ASC' - Neurolucida data file of the 3D reconstruction of axon and dendrite from the single neuron labelled in mouse TY310. Brain contours are also traced.

22. 'TY337.ASC' - Neurolucida data file of the 3D reconstruction of axon and dendrite from the single neuron labelled in mouse TY337. Brain contours are also traced.

23. 'TY345.ASC' - Neurolucida data file of the 3D reconstruction of axon and dendrite from the single neuron labelled in mouse TY345. Brain contours are also traced.

24. 'TY367.ASC' - Neurolucida data file of the 3D reconstruction of axon and dendrite from the single neuron labelled in mouse TY367. Brain contours are also traced.

25. 'TY369.ASC' - Neurolucida data file of the 3D reconstruction of axon and dendrite from the single neuron labelled in mouse TY369. Brain contours are also traced.

This is a compilation of logs and data from Well 9-1 in the Roosevelt Hot Springs area in Utah. This well is also in the Utah FORGE study area. The file is in a compressed .zip format and there is a data inventory table (Excel spreadsheet) in the root folder that is a guide to the data that is accessible in subfolders.

These are results of a series of laboratory experiments to determine if topical application of methoprene and 20-ecdysone can terminate reproductive diapause of the weevil, Ceratapion basicorne, which is a recently permitted biological control agent of yellow starthistle (Centaurea solstitialis). Adult weevils feed on leaves, creating pin holes, and lay eggs inside leaves. Diapausing weevils were treated with various doses of methoprene (0, 0.01, 0.1, 1.0 micrograms) dissolved in acetone in experiments 1 and 2. They were treated sequentially first with acetone or 20-ecdysone (1.0 microgram) and then with methoprene (1.0 microgram) in experiment 3 and were treated with 20-ecdysone followed by methoprene in experiment 4. Resources in this dataset:Resource Title: data dictionary. File Name: JH Data Dictionary.csvResource Description: description of data fieldsResource Software Recommended: Microsoft Excel,url: https://www.microsoft.com/microsoft-365/excel Resource Title: experiment 1. File Name: JH expt1 data.csvResource Description: Methoprene dissolved in acetone was applied topically at doses of 0.0, 0.01 and 0.1 and 1.0 μg per female weevil, and the number of feeding holes and eggs were recorded daily on cut leaves of yellow starthistle at room temperature (12 h photoperiod, temperature range 17 to 21°C).Resource Software Recommended: Microsoft Excel,url: https://www.microsoft.com/microsoft-365/excel Resource Title: experiment 2. File Name: JH expt2 data.csvResource Description: Methoprene dissolved in acetone was applied topically at doses of 0.0 and 1.0 μg to female weevils that did not produce eggs in experiment 1. The number of feeding holes and eggs were recorded daily on cut leaves of yellow starthistle at room temperature (12 h photoperiod, temperature range 17 to 21°C).Resource Software Recommended: Microsoft Excel,url: https://www.microsoft.com/microsoft-365/excel Resource Title: experiment 3. File Name: JH expt3 data.csvResource Description: Three types of treatments were applied with sequential applications 2 days apart: 1) acetone + acetone [AA: control], 2) acetone + methoprene [AM], and 20-ecdysone + methoprene 174 [2M]. All doses were 1.0 μg. The number of feeding holes and eggs were recorded every 2 days on cut leaves of yellow starthistle at room temperature (12 h photoperiod, temperature range 17 to 21°C).Resource Software Recommended: Microsoft Excel,url: https://www.microsoft.com/microsoft-365/excel Resource Title: experiment 4. File Name: JH expt4 data.csvResource Description: Females from experiment 3 that did not oviposit consistently were treated with 1.0 μg of 20-ecdysone followed 2 days later by 1.0 μg of methoprene. The treatments AA, AM, 2M refer to experiment 3. The number of feeding holes and eggs were recorded every 2 days on cut leaves of yellow starthistle at room temperature (12 h photoperiod, temperature range 17 to 21°C).Resource Software Recommended: Microsoft Excel,url: https://www.microsoft.com/microsoft-365/excel

We used STATA v12.1 to analyze the data, but the files can also be opened with Microsoft Excel or R.