Spreadsheet used to calculated hydrograph recession statistical parameters (Minimum, Most Probable Value, and Maximum) for the Stochastic Empirical Loading Dilution Model (SELDM) . The spreadsheet was used in conjunction with the SELDM simulations used in the publication: Stonewall, A.J., and Granato, G.E., 2018, Assessing potential effects of highway and urban runoff on receiving streams in total maximum daily load watersheds in Oregon using the Stochastic Empirical Loading and Dilution Model: U.S. Geological Survey Scientific Investigations Report 2019-5053, 116 p., https://doi.org/10.3133/sir20195053, and after using the Hydrograph.xlsx spreadsheet.

This spreadsheet model calculates the net income for irrigated agricultural production. The model is designed to evaluate the economics of deficit irrigation (irrigation at less than the amount required to produce maximum yield). The spreadsheet first models the water production function for a crop, then uses that relationship along with crop price and production costs to calculate net income and the irrigation amount that maximizes net income. This spreadsheet is similar to another posted at Ag Data Commons: "Economic Model of Deficit Irrigation" (http://dx.doi.org/10.15482/USDA.ADC/1504421). That model was designed primarily to evaluate deficit irrigation as a means to compare revenue with reduced water consumption to income gained by transferring the saved water. The model includes two common scenarios: 1) irrigation water supply is adequate but expensive, and 2) irrigation water supply is inadequate to fully irrigate the available land. In the first scenario, net income is maximized when the marginal costs of production, including water, is equal to the marginal revenue. In the second scenario, net income is maximized when the value of the water is maximized by selecting the portion of the land that should be irrigated. In the second scenario, the value and costs of the un-irrigated land are included. The first worksheet of the spreadsheet describes the relationships used in each worksheet and the input parameters required. Additional worksheets calculate the water production function, the irrigation water production function, and the net income for each of the two scenarios. The worksheets allow the user to input the various biophysical and economic parameters relevant to their conditions and allows evaluating various parameter combinations. Each worksheet contains graphs to visualize the results. Resources in this dataset:Resource Title: Economic Model of Deficit Irrigation II (spreadsheet). File Name: WPF Econ Model V2 Mod.xlsxResource Description: Spreadsheet contains 5 worksheets. The first worksheet describes the relationships in the remaining worksheets and the parameters required by the model.Resource Software Recommended: Microsoft Excel 365 (may work on earlier versions),url: https://www.microsoft.com/en-us/microsoft-365/get-started-with-office-2019 Resource Title: Description of the Model. File Name: DataDictionary.pdfResource Description: Description of the model and input parameters.Resource Software Recommended: Adobe Reader,url: https://get.adobe.com/reader/otherversions/

The South Florida Water Management District (SFWMD) and the U.S. Geological Survey (USGS) have evaluated projections of future droughts for south Florida based on climate model output from the Multivariate Adaptive Constructed Analogs (MACA) downscaled climate dataset from the Coupled Model Intercomparison Project Phase 5 (CMIP5). The MACA dataset includes both Representative Concentration Pathways 4.5 and 8.5 (RCP4.5 and RCP8.5). A Microsoft Excel workbook is provided which tabulates model drought-evaluation statistics for the period 2056-95 based on drought characteristics derived from climate models downscaled by the MACA method assuming historical-standard stomatal resistance. Model drought-evaluation statistics based on 6-mo. and 12-mo. averaged balance anomaly timeseries are provided for four regions: (1) the entire South Florida Water Management District (SFWMD), (2) the Lower West Coast (LWC) water supply region, (3) the Lower East Coast (LEC) water supply region, and (4) the Okeechobee plus (OKEE+) water supply meta-region consisting of Lake Okeechobee (OKEE), the Lower Kissimmee (LKISS), Upper Kissimmee (UKISS), and Upper East Coast (UEC) water supply regions in the SFWMD. The balance anomaly timeseries are computed as the departure from the long-term monthly means of monthly balances (precipitation - reference evapotranspiration) for the period 1950-2005. Then 6-mo. and 12-mo. moving averages of the balance anomalies are computed and drought-event characteristics (duration, intensity and severity) are derived from the moving-average timeseries. The model drought-evaluation statistics include percentile rank of total future (2056-95) drought severity, percentage change in total future drought severity with respect to the historical period (1950-2005) and its percentile rank, as well as p-values comparing the joint distributions of model historical drought characteristics against those derived from observations, and p-values comparing model future to model historical drought characteristics. The lower the p-value, the more different the compared joint distributions of drought characteristics. P-values smaller than a chosen significance level (typically 0.05–0.1) denote models for which the joint distributions of drought characteristics are statistically significantly different.

Microsoft Excel-based computer module for continuous item responses. (XLSM 2705 kb)

Final excel sheet_after revision 2.xlsx

Abstract

This dataset was derived by the Bioregional Assessment Programme. The parent datasets are identified in the Lineage statement in this metadata statement. The processes undertaken to produce this derived dataset are described in the History field in this metadata statement.

This dataset comprises of interpreted elevation surfaces and contours for the major Triassic and Upper Permian units of the Galilee Geological Basin.

Purpose

This dataset was created to provide formation extents for aquifers in the Galilee geological basin

Dataset History

A Quality Assurance (QA) and validation process was conducted on the original well and bore data to choose wells/bores that are within 25 kilometres of the BA Galilee Region extent.

The QA/Validation process is as follows:

1. Well data

   a. Obtained excel file "QPED_July_2013_galilee.xlsx" from GA

   b. Based on stratigraphic information in "BH_costrat" tab formation names were regularised and simplified based on current naming conventions.

   c. Simplified names added to QPED_July_2013_galileet.xlsx as "Steve_geo" and "Steve_group"

   d. Produced new file "GSQ_Geology.xlsx" contained decimal latitude and longitude, KB elevation, top of unit in metres from KB, top of unit in metres AHD, bottom of unit in metres from KB, bottom of unit in metres AHD, original geology, simplified geology, simplified Group geology.

    i.     KB obtained from "BH_wellhist"
   
    ii.    Where no KB information was available ie KB=0, sample the 1S DEM at the well's location to obtain height. KB=DEM+10. Marked well as having lower reliability.
   
    iii.    Calculated Top_m_AHD = KB - Top_m_KB
   
    iv.    Calculated Bottom_m_AHD = KB - Bottom_m_KB
   

   e. Brought GSQ_Geology.xlsx into ArcGIS

   f. Selected wells based on "Steve_geo" field for each model layer to produce a geodatabase for each layer.

    i.     GSQ_basement_wells
   
    ii.    GSQ_top_joe_joe_group
   
    iii.    GSQ_top_bandanna_merge
   
    iv.    GSQ_rewan_group
   
    v.     GSQ_clematis
   
    vi.    GSQ_moolyember
   

   g. Additional wells and reinterpreted tops added to appropriate geodatabase based on well completion reports

   h. Additional wells added to coverages to help model building process

    i.     Well_name listed as Fake
   
    ii.    Exception being GSQ_top_basement_fake which was created as a separate geodatabase
   

2. Bore data

   a. Obtained QLD_DNRM_GroundwaterDatabaseExtract_20131111 from GA

   b. Used files REGISTRATIONS.txt, ELEVATIONS.txt and AQUIFER.txt to build GW_stratigraphy.xlsx

    i.     Based on RN
   
    ii.    Latitude from GIS_LAT (REGISTRATIONS.txt)
   
    iii.    Longitude from GIS_LNG (REGISTRATIONS.txt)
   
    iv.    Elevation from (ELEVATIONS.txt)
   
    v.     FORM_DESC from (AQUIFER.txt)
   
    vi.    Top from (AQUIFER.txt)
   
    vii.    Bottom from (AQUIFER.txt)
   

   c. Brought GW_stratigraphy.xlsx into ArcGIS

   d. Created gw_bores_galilee_dem

    i.     Sampled 1S DEM to obtain ground level elevation column RASTERVALU
   
    ii.    Created column top_m_AHD by RASTERVALU - Top
   

   e. Selected bores based on "FORM_DESC" field for each model layer to produce a geodatabase for each layer.

    i.     Gw_basement
   
    ii.    GW_bores_joe_joe_group
   
    iii.    GW_bores_bandanna
   
    iv.    Gw_bores_rewan
   
    v.     Gw_bores_clematis
   
    vi.    Gw_bores_moolyember
   

3. Georectified seismic surfaces

   a. Extracted interpreted seismic surfaces for base Permian (interpreted as basement) and top Bandanna (in time) from the following seismic surveys

    i.     Y80A, W81A, Carmichael, Pendine, T81A, Quilpie, Ward and Powell Creek seismic survey downloaded https://qdexguest.deedi.qld.gov.au/portal/site/qdex/search?searchType=general 
   
    ii.    Brought TIF images into ArcGIS and georectified
   
    iii.    Digitised shape of contours and faults into geodatabase
   
        1.   Basement_contours and basement_faults
   
        2.   bandanna_contours_new_data and bandanna_faults
   
    iv.    Added field "contour" to geodatabase
   
    v.     Converted contours to depth in "contour" field based on well and bore data (top_m_AHD) and contour progression
   
    vi.    Use the shape and depth derived from OZ SEEBASE to help to add additional contours and faults to basement and bandanna datasets
   

4. Additional contour and fault surfaces were built derived from underlying surfaces and wells/bore data

   a. Joejoe_contours and joejoe)faults

   b. Rewan_contour_clip (used bandanna_faults as fault coverage)

   c. Clematis_contour and clematis_faults

   d. Moolyember_contour (used clematis_faults as fault coverage)

5. Surface geology

   a. Extracted surface geology from QUEENSLAND GEOLOGY_AUGUST_2012 using Galilee BA region boundary with 25 kilometre boundary to form geodatabase QLD_geology_galilee

   b. Selected relevant surface geology from QLD_geology_galilee based on field "Name" for each model layer and created new geodatabase layers

    i.     Basement_geology: Argentine Metamorphics,Running River Metamorphics,Charters Towers Metamorphics; Bimurra Volcanics, Foyle Volcanics, Mount Wyatt Formation, Saint Anns Formation, Silver Hills Volcanics, Stones Creek Volcanics; Bulliwallah Formation, Ducabrook Formation, Mount Rankin Formation, Natal Formation, Star of Hope Formation; Cape River Metamorphics; Einasleigh Metamorphics; Gem Park Granite; Macrossan Province Cambrian-Ordovician intrusives; Macrossan Province Ordovician-Silurian intrusives; Macrossan Province Ordovician intrusives; Mount Formartine, unnamed plutonic units; Pama Province Silurian-Devonian intrusives; Seventy Mile Range Group; and Kirk River beds, Les Jumelles beds.
   
    ii.    Joe_joe_geology: Joe Joe Group
   
    iii.    Galilee_permian_geology: Back Creek Group, Betts Creek Group, Blackwater Group
   
    iv.    Rewan_geology: Rewan Group
   
       1.    Later also made dunda_beds_geology to be included in Rewan model: Dunda beds
   
    v.     Clematis_geology: Clematis Group
   
       1.    Later also made warang_sandstone_geology to be included in Clematis model: Warang Sandstone
   
    vi.    Moolyember_surface_geology: Moolyember Formation
   

6. DEM for each model layer

   a. Using surface geology geodatabase extent extract grid from dem_s_1s to represent the top of the model layer at the surface

    i.     Basement_dem
   
    ii.    Joejoe_dem
   
    iii.    Bandanna_dem
   
    iv.    Rewan_dem and dunda_dem
   
    v.     Clematis_dem and warang_dem
   
    vi.    Moolyember_surface_dem
   

   b. Used Contour tool in ArcGIS to obtain a 25 metre contour geodatabase from the relevant model DEM

    i.     Basement_dem_contours
   
    ii.    Joejoe_dem_contours
   
    iii.    Bandanna_dem_contours
   
    iv.    Rewan_dem_contours and dunda_dem_contours
   
    v.     Clematis_dem_contours and warang_dem_contours
   
    vi.    Moolyember_dem_contours
   

   c. For the purpose of guiding the model building process additional fields were added to each DEM contour geodatabase was added based on average thickness derived from groundwater bores and petroleum wells.

    i.     Basement_dem_contours: Joejoe, bandanna, rewan, clematis, moolyember
   
    ii.    Joejoe_dem_contours: basement, bandanna
   
    iii.    Bandanna_dem_contours: joejoe, rewan
   
    iv.    Rewan_dem_contours and dunda_dem_contours: clematis, rewan
   
    v.     Clematis_dem_contours and warang_dem_contours: moolyember, rewan
   
    vi.  Moolyember_dem_contours: clematis
   

The model building process is as follows:

1. Used the tope to raster tool to create surface based on the following rules

   a. Environment

       i.  Extent
   
          1. Top: -19.7012030024424
   
          2. Right: 148.891511819054
   
          3. Bottom: -27.5812030024424
   
          4. Left: 139.141511819054
   
       ii. Output cell size: 0.01 degrees
   
       iii. Drainage enforcement: No_enforce
   

   b. Input

       i.  Basement
   
          1. Basement_dem_contour; field - contour; type - contour
   
          2. Joejoe_dem_contour; field - basement; type - contour
   
          3. Basement_contour; field - contour; type - contour
   
          4. GSQ_basement_wells; field - top_m_AHD; type - point elevation
   
          5. GW_basement; field - top_m_AHDl type - point elevation
   
          6. GSQ_top_basement_fake; field - top_m_AHDl type - point elevation
   
          7. Basement_faults; type - cliff
   
      ii.  Joe Joe Group
   
          1. Joejoe_dem_contour; field - basement; type - contour
   
          2. Basement_dem_contour; field - joejoe; type - contour
   
          3. permian_dem_contour; field - joejoe, type - contour
   
          4. joejoe_contour; field - joejoe; type - contour
   
          5. GSQ_top_joejoe_group; field - top_m_AHD; type - point elevation
   
          6. GW_bores_joe_joe_group; field - top_m_AHDl type - point elevation
   
          7. joejoe_faults; type - cliff
   
      iii.  Bandanna Group
   
          1. Permian_dem_contour; field - contour; type - contour
   
          2. Joejoe_dem_contour; field - bandanna; type - contour
   
          3. Rewan_dem_contour: field - bandanna; type - contour
   
          4. Dunda_dem_contour; field - bandanna; type - contour
   

Spreadsheet for identifying individual storms for the Stochastic Empirical Loading Dilution Model (SELDM) . The spreadsheet was used in conjunction with the SELDM simulations used in the publication: Stonewall, A.J., and Granato, G.E., 2019, Assessing potential effects of highway and urban runoff on receiving streams in total maximum daily load watersheds in Oregon using the Stochastic Empirical Loading and Dilution Model: U.S. Geological Survey Scientific Investigations Report 2019-5053, 116 p., https://doi.org/10.3133/sir20195053.

Excel Spreadsheet showing rock shape data for interior, margin, and exterior of Homestead hollow, Mars. Excel Triplot model used for some rock shape calculations. Original versions of all figures in paper

Spreadsheet Software Market Size And Forecast

Spreadsheet Software Market size was valued at USD 10.05 Billion in 2023 and is expected to reach USD 14.55 Billion by 2031, with a CAGR of 7.8% from 2024-2031.

Global Spreadsheet Software Market Drivers

The market drivers for the Spreadsheet Software Market can be influenced by various factors. These may include:

Increasing Data Volume: As organizations generate and collect more data, the need for efficient data analysis and management tools, such as spreadsheet software, grows. Rising Demand for Data Visualization: Users increasingly seek sophisticated tools to visualize data for better insights. Spreadsheet software can provide charts and graphs, making data interpretation easier.

Global Spreadsheet Software Market Restraints

Several factors can act as restraints or challenges for the Spreadsheet Software Market, These may include:

Market Saturation: Many organizations already use established spreadsheet software such as Microsoft Excel or Google Sheets. The reliance on these platforms can make it difficult for new entrants or alternative solutions to capture market share. High Competition: The market is highly competitive, with numerous players offering similar features and functionalities. This can lead to price wars and reduced profit margins for software providers.

The author has calculated and plotted all epidemic curves in Excel for the paper "A Simple, SIR-like but Individual-Based Epidemic Model: Application in Comparison of COVID-19 in New York City and Wuhan". All these calculated curves are shown in Figures 2-11, which are separately placed in different sheets in the Excel file. The values of parameters l and c are separately placed in two cells marked in yellow. The two cells are located in top one or two row on the left. After the two parameters are changed, the Excel file will calculate the 4 variables An, In, Rn and Tn from n=1 to N. The calculated values are listed in 4 different columns of cells below the column labels An, In, Rn and Tn, respectively.

Excel spreadsheet containing, in separate sheets, the underlying numerical data of the findings.

Data velocity ice in the glacier surface are critical for glacier dynamics models. Although not generally used as boundary conditions inhomogeneous (as, instead, is usually set boundary conditions of homogeneous Neumann type of zero traction on the surface) Dirichlet type, surface speeds are used to adjust free model parameters such as the coefficient B of the constitutive relation or the multiplicative factor that usually appears in the parameterization of Weertman type of basal sliding velocity, so to minimize the differences between the speeds observed and calculated by the model on the surface.

Spreadsheet used to calculate Highway Site characteristics (Drainage area, slope and impervious fraction) for the Stochastic Empirical Loading Dilution Model (SELDM) . The spreadsheet was used in conjunction with the SELDM simulations used in the publication: Stonewall, A.J., and Granato, G.E., 2018, Assessing potential effects of highway and urban runoff on receiving streams in total maximum daily load watersheds in Oregon using the Stochastic Empirical Loading and Dilution Model: U.S. Geological Survey Scientific Investigations Report 2019-5053, 116 p., https://doi.org/10.3133/sir20195053.

The stranded assets Excel model supplements the article titled, “Stranded assets and reduced profits: Analyzing the economic underpinnings of the fossil fuel industry's resistance to climate stabilization” (hereafter, “main paper”), in Renewable and Sustainable Energy Reviews. This model can be used to obtain the main stranded assets results in the paper. It also contains formulas for estimating stranded assets using alternative discount rates, methods of projecting oil and gas supply, and production decline curves (used in the sensitivity analysis in the main paper and the supplementary material).

Excel Pricing Workbook & Market Data

This is the excel-based life cycle model that contains all the parameters and Monte Carlo simulation capabilities to model the techno-regions contained in the report: Life Cycle Analysis of Natural Gas Extraction and Power Generation: U.S. 2020 Emissions Profile.

This database studies the performance inconsistency on the biomass HHV ultimate analysis. The research null hypothesis is the consistency in the rank of a biomass HHV model. Fifteen biomass models are trained and tested in four datasets. In each dataset, the rank invariability of these 15 models indicates the performance consistency.

The database includes the datasets and source codes to analyze the performance consistency of the biomass HHV. These datasets are stored in tabular on an excel workbook. The source codes are the biomass HHV machine learning model through the MATLAB Objected Orient Program (OOP). These machine learning models consist of eight regressions, four supervised learnings, and three neural networks.

An excel workbook, "BiomassDataSetUltimate.xlsx," collects the research datasets in six worksheets. The first worksheet, "Ultimate," contains 908 HHV data from 20 pieces of literature. The names of the worksheet column indicate the elements of the ultimate analysis on a % dry basis. The HHV column refers to the higher heating value in MJ/kg. The following worksheet, "Full Residuals," backups the model testing's residuals based on the 20-fold cross-validations. The article (Kijkarncharoensin & Innet, 2021) verifies the performance consistency through these residuals. The other worksheets present the literature datasets implemented to train and test the model performance in many pieces of literature.

A file named "SourceCodeUltimate.rar" collects the MATLAB machine learning models implemented in the article. The list of the folders in this file is the class structure of the machine learning models. These classes extend the features of the original MATLAB's Statistics and Machine Learning Toolbox to support, e.g., the k-fold cross-validation. The MATLAB script, name "runStudyUltimate.m," is the article's main program to analyze the performance consistency of the biomass HHV model through the ultimate analysis. The script instantly loads the datasets from the excel workbook and automatically fits the biomass model through the OOP classes.

The first section of the MATLAB script generates the most accurate model by optimizing the model's higher parameters. It takes a few hours for the first run to train the machine learning model via the trial and error process. The trained models can be saved in MATLAB .mat file and loaded back to the MATLAB workspace. The remaining script, separated by the script section break, performs the residual analysis to inspect the performance consistency. Furthermore, the figure of the biomass data in the 3D scatter plot, and the box plots of the prediction residuals are exhibited. Finally, the interpretations of these results are examined in the author's article.

Reference : Kijkarncharoensin, A., & Innet, S. (2022). Performance inconsistency of the Biomass Higher Heating Value (HHV) Models derived from Ultimate Analysis [Manuscript in preparation]. University of the Thai Chamber of Commerce.

Folosiți acest fișier împreună cu capitolul:......

This Excel Workbook provides a high-resolution simulation of domestic lighting demand. The model generates stochastic data sets representing the lighting demand for a single dwelling over a 24-hour period at a one minute time resolution. The model uses both an active occupancy model (http://hdl.handle.net/2134/3112), together with measured irradiance data, as dynamic inputs. The user may configure the month of the year, the total number of residents that live at the dwelling and whether a week day or a weekend day simulation is required. The Workbook contains all the necessary data to run the simulation and includes the Visual Basic for Applications source code. The model is discussed in the journal paper: Ian Richardson, Murray Thomson, David Infield, Alice Delahunty, Domestic lighting: A high-resolution energy demand model, Energy and Buildings, Volume 41, Issue 7, July 2009, Pages 781-789, ISSN 0378-7788, DOI: 10.1016/j.enbuild.2009.02.010.