This paper employs the newly conceived accounting-and-finance engineering system (AFES) described in a previous paper (Magni 2023, “The Split-Screen Approach for Project Appraisal (Part I: The Theory)”), addressed to the analysis of capit...
This paper presents a modeling practical works project of electrical engineering, proposed to the first-year students of the University Institute of Technology in France, during the COVID-19 pandemic. The objective of this paper is twofold. The first...
This paper presents and validates a unified spreadsheet-based framework for engineering mechanics education and preliminary design. Three modules are integrated within a single openly available workbook: multi-point resultant force and moment computa...
Remote teaching has been becoming increasingly important in higher education since the COVID-19 pandemic. Additionally, fast and precise modeling of the main operating values of industrial systems is a key point for production and efficiency calculat...
We present a systematic spreadsheet method for modeling and optimizing general partial differential algebraic equations (PDAE). The method exploits a pure spreadsheet PDAE solver function design that encapsulates the Method of Lines and permits seaml...
The use of composite materials in additive manufacturing has significant potential and prospects for development. However, the 3D printing of composite materials also has some challenges, such as tool path planning and optimization, material distribu...
Business process models help to visualize processes of an organization. In enterprises, these processes are often specified in internal regulations, resolutions or other law acts of a company. Such descriptions, like task lists, have mostly form of e...
This paper illustrates an innovative approach to financial modeling of engineering decision-making and industrial projects. The approach is a minimal one, grounded as it is on three notions, two laws, and one matrix that combines them, called Split-S...
Research data are often prepared in spreadsheets, but the meanings of their columns and values must still be translated into reusable metadata schemas. Even with a graphical editor, this translation requires repeated decisions about field names, type...
Quantifying the benefits of construction supply chain management through prescriptive models is a challenging and fast-growing research area that still lacks standardized optimization models with full integrative potential. In response to the needs a...
The sorption of basic dyes onto magnetic nanosorbent is commonly used as a novel material to combat powdered activated carbon, which is difficult to handle and separate during water and wastewater treatment. This adsorption method is commonly impleme...
Table olives are recognized as an essential component of the Mediterranean diet, having been explicitly included in the second level of its nutritional pyramid as an aperitif or culinary ingredient, with a recommended daily consumption of one to two...
The evaluation of student performance often relies on basic spreadsheet outputs that provide limited insight into item functioning. This study presents a methodological demonstration showing how widely available spreadsheet software can be transforme...
The field of nanoinformatics is rapidly developing and provides data driven solutions in the area of nanomaterials (NM) safety. Safe by Design approaches are encouraged and promoted through regulatory initiatives and multiple scientific projects. Exp...
This article presents an application for educational purposes in the field of engineering graphics, which corrects the dihedral projections of the sections of a plane for a part by comparing the solution provided by the student with that obtained thr...
The famous empirical model for the horizontal force estimation of farm implements was issued by the American Society of Agricultural Biological Engineers (ASABE). It relies on information on soil texture through its soil texture adjustment parameter,...
Agricultural cropping systems and experiments include complex interactions of processes and various management practices and/or treatments under a wide range of environmental and climatic conditions. The use of standardized formats to monitor and doc...
Pervaporation is a proven technology that overcomes distillation to produce high-quality ethanol. The process is modeled and simulated in the literature, but the model’s accuracy with industrial data is rarely discussed. In this work, a commerc...
The resilient modulus is one of the primary parameters used in mechanistic–empirical pavement design methods and plays a fundamental role in pavement structural analysis and performance prediction. In Brazil, the implementation of the MeDiNa pa...
Computer-assisted audit tools and techniques (CAATs) are central to audit digitalization, yet it remains unclear which system-quality attributes make their use successful, particularly in audit markets where spreadsheets still dominate. Drawing on th...
The study addresses the challenge of accurately simulating and visualising the kinematics of agricultural machinery during field operations. The research is motivated by the current lack of comprehensive guidelines for selecting optimal movement and...
The Brazilian craft beer market has experienced continuous growth, increasing operational challenges for small- and medium-sized breweries that frequently rely on empirical and spreadsheet-based production routines. These practices often lead to inef...
In this paper we provide the reader with a ready to use Group Contribution (GC) method for the heat of formation (gaseous state) of organics in the form of an Excel spreadsheet with all data, enabling further predictions, and an accompanying manual o...
Despite the widespread use of chain-ladder models, so far no theory was available to test for model specification. The popular over-dispersed Poisson model assumes that the over-dispersion is common across the data. A further assumption is that accid...
Over the last decades, several reliable mathematical models have been developed for simulating ore comminution processes and determining the Work Index. Since Fred Chester Bond developed the Work Index standard procedure in 1961, numerous attempts ha...
A variety of Salix L. (Willow) tree and shrub cultivars provide resources for significant commercial markets such as bioenergy, environmental applications, basket manufacturing, and ornamental selections. The International Poplar Commission of the Fo...
6 June 2022
This article quantifies the environmental, health, and economic co-benefits from the use of solar electricity and heat generation in the Ger area (a sub-district of traditional residences and private houses) in Ulaanbaatar (UB), Mongolia. The quantif...
In this paper, a novel algorithm for the determination of Walker damage in loaded disc springs is presented. The algorithm takes a 3D-scan of a disc spring, measured residual stresses, material parameters, and spring loads as inputs. It outputs a dis...
Bottom-up integrated assessment models, like MESSAGEix, depend on the description of the capabilities and limitations of technological, economical and ecological parameters, and their development over long-time horizons. Even small models of a few no...
In planning and managing water resources, the implementation of optimization techniques in the operation of reservoirs has become an important focus. An optimal reservoir operating policy should take into consideration the uncertainty associated with...
Harvesting is an integral component of the agricultural cycle, necessitating the use of high-performance grain harvester combines, which are utilized for a short period each year. Given the seasonality and significant cost involved, list prices rangi...
The ability to anticipate the effects of the interaction between waste rubber particles from end-of-life tires and bitumen can encourage the use of rubberized bitumen, a material with proven environmental benefits, in civil engineering applications....
Contemporary climate challenges are changing the architect’s awareness, which results in a broader spectrum of interest. The available software enables the design of vegetation, but it is often very limited and requires specialist knowledge. Th...
This work surveys the use of directed weighted graphs in conducting comparative static analyses. The paper discusses the implementation of a computer-aided process for building spreadsheet-based graph models for inter- and intra-regional financial fl...
Previous studies on tractor performance and efficiency were conducted prior to the implementation of emission reduction technologies and the increased density and complexity of tractor portfolios. This study presents a robust methodology for forecast...
Designing UHPC beams for shear is challenging because many factors—geometry, concrete strength, fibers, and stirrups—act together. In this study, we compile a large, curated database of laboratory tests and develop machine learning models to predict...
In the context of artificial intelligence in chemistry, the first applications that come to mind are widely discussed ones, such as building surrogate models to replace costly numerical simulations or designing new compounds. However, one area where...
In work, data from carbonization of the eight main municipal solid waste components (carton, fabric, kitchen waste, paper, plastic, rubber, paper/aluminum/polyethylene (PAP/AL/PE) composite packaging pack, wood) carbonized at 300–500 °C for 20–60 min...
Concurrent engineering (CE) aims to provide a collaborative environment in which all involved parties work simultaneously to optimize resources. However, some aspects can make it hard to implement in organizations. This study presents the development...
This paper describes an event-based water quality model for sparsely gauged catchments. The model was cultivated in a robust way to cope with practical issues, such as limited available data and error propagation. A simplified model structure and few...
The design of end-plate connections for steel structures is more loosely specified in Chilean regulations than in American regulations. Nevertheless, eight-bolt extended stiffened (8ES) end-plate connections have not derived benefit from extensive pa...
This paper presents a new approach for energetic analyses of traffic accidents against fixed road elements using close-range photogrammetry. The main contributions of the developed approach are related to the quality of the 3D photogrammetric models,...
A variety of mathematical models have been developed to simulate the biochemical and physico-chemical aspects of the anaerobic digestion (AD) process to treat organic wastes and generate biogas. However, all these models, including the most widely ac...
In the development of safety-critical systems, it is important to perform failure modes and effects analysis (FMEA) to identify potential failures. However, traditional FMEA activities tend to be considered difficult and time-consuming tasks. To comp...
Due to the shortage and high cost of shipping containers, manufacturers that distribute products for worldwide customers must optimize their delivery. Commonly, they complete their delivery schedule first before creating the production schedule. This...
Technoeconomic analyses using established tools such as SuperPro Designer® require a level of detail that is typically unavailable at the early stage of process evaluation. To facilitate this, members of our group previously created a spreadsheet...
Background: Traceability systems and carbon emissions are two important factors involved in production and distribution activities. The involvement of these two factors in production and distribution activities along the supply chain will ensure the...
This study investigated the sustainability of the rainwater harvesting system (RWHS) by analyzing six urban city sites with different rainfall statistics in the United States. We developed a new RWHS performance model by modifying a spreadsheet-based...
A field water balance model for efficient irrigation water management of corn was developed using Excel VBA. The model consists of five sub-components or modules, namely, (1) a plant subcomponent, (2) an effective rainfall subcomponent, (3) an evapot...
Heap leach operations typically employ some form of modelling and forecasting tools to predict cash flow margins and project viability. However, these vary from simple spreadsheets to phenomenological models, with more complex models not commonly emp...
of 4