Search NASA⌕ Search

SEARCH · Search NASA

Results for “spreadsheet”

Search indexed NASA NTRS and DOE OSTI research on propulsion, heat transfer, battery materials and energy systems. Follow report and document links to the original sources.

Quote a phrase for an exact phrase match. Source license links do not imply unrestricted reuse.

At least 253 records · Page 14

Using Model-Based Systems Engineering to Provide Artifacts for NASA Project Life-cycle and Technical Reviews

This paper is for the AIAA Space Conference. The ability of systems engineers to use model-based systems engineering (MBSE) to generate self-consistent, up-to-date systems engineering products for project life-cycle and technical reviews is an important aspect for the continued and accelerated acceptance of MBSE. Currently, many review products are generated using labor-intensive, error-prone approaches based on documents, spreadsheets, and chart sets; a promised benefit of MBSE is that users will experience reductions in inconsistencies and errors. This work examines features of SysML that can be used to generate systems engineering products. Model elements, relationships, tables, and diagrams are identified for a large number of the typical systems engineering artifacts. A SysML system model can contain and generate most systems engineering products to a significant extent and this paper provides a guide on how to use MBSE to generate products for project life-cycle and technical reviews. The use of MBSE can reduce the schedule impact usually experienced for review preparation, as in many cases the review products can be auto-generated directly from the system model. These approaches are useful to systems engineers, project managers, review board members, and other key project stakeholders.

MBSE↗

Using Model-Based Systems Engineering To Provide Artifacts for NASA Project Life-Cycle and Technical Reviews

The ability of systems engineers to use model-based systems engineering (MBSE) to generate self-consistent, up-to-date systems engineering products for project life-cycle and technical reviews is an important aspect for the continued and accelerated acceptance of MBSE. Currently, many review products are generated using labor-intensive, error-prone approaches based on documents, spreadsheets, and chart sets; a promised benefit of MBSE is that users will experience reductions in inconsistencies and errors. This work examines features of SysML that can be used to generate systems engineering products. Model elements, relationships, tables, and diagrams are identified for a large number of the typical systems engineering artifacts. A SysML system model can contain and generate most systems engineering products to a significant extent and this paper provides a guide on how to use MBSE to generate products for project life-cycle and technical reviews. The use of MBSE can reduce the schedule impact usually experienced for review preparation, as in many cases the review products can be auto-generated directly from the system model. These approaches are useful to systems engineers, project managers, review board members, and other key project stakeholders.

SE Product↗

Growing Beyond Earth; Students Exploring Plant Varieties for Future Space Exploration

Future space exploration and long duration space flight will pose an array of challenges to the health and wellbeing of astronauts. Since 2015, Fairchild Tropical Botanic Garden (FTBG), in partnership with NASA's Veggie team, has been testing edible crops for space flight potential through a series of citizen science experiments. FTBG's interest in classroom-based science projects, along with NASA's successful operation of the Veggie system aboard the International Space Station (ISS), led to a NASA-FTBG partnership that gave rise to the Growing Beyond Earth STEM Initiative (GBE). Established in 2015, GBE now involves 131 middle and high school classrooms in South Florida, all conducting simultaneous plant science experiments. The results of those experiments (both numeric and visual) are directly shared with the space food production researchers at KSC. Through this session, we will explore the successful classroom implementation and integration into the curriculum, how the data is being used and the impact of the project on participating researchers, teachers, and students. Participating schools were supplied with specialized LED-lit growth chambers, mimicking the Veggie system on ISS, for growing edible plants under similar physical and environmental constraints. Research protocols were provided by KSC scientists, while edible plant varieties were selected mainly by the botanists at FTBG. In a jointly-led professional development workshop, participating teachers were trained to conduct GBE experiments in their classrooms. Teachers were instructed to not only teach basic botany concepts, but to also demonstrate practical applications of math, physics and chemistry. As experiments were underway, students shared data on plant germination, growth, and health in an online spreadsheet. Results from the students research show a promising selection of new plant candidates for possible further testing. Over a two year period, more than 5000 South Florida students, ages 11 to 18, participated in GBE. Evaluation of the program shows an increased knowledge of and interest in science and science careers among students. The program has also boosted the demand for summer high school internships at FTBG, further developing expertise in plant research and science related to space exploration. Supported by a grant from NASA (NNX16AM32G) to Fairchild Tropical Botanic Garden.

Veggie↗

Designing and Developing Web-Based Administrative Tools for Program Management

The task assigned for this internship was to develop a new tool for tracking projects, their subsystems, the leads, backups, and other employees assigned to them, as well as all the relevant information related to the employee (WBS (time charge) codes, time distribution, certifications, and assignments). Currently, this data is tracked manually using a number of different spreadsheets and other tools simultaneously by a number of different people; some of these documents are then merged into one large document. This often leads to inconsistencies and loss in data due to human error. By simplifying the process of tracking this data and aggregating it into a single tool, it is possible to significantly decrease the potential for human error and time spent collecting and checking this information. II. Objective The main objective of this internship is to develop a web-based tool using Ruby on Rails to serve as a method of easily tracking projects, subsystems, and points of contact, along with employees, their assignments, time distribution, certifications, and contact information. Additionally, this tool must be capable of generating a number of different reports based on the data collected. It was important that this tool deliver all of this information using a readable and intuitive interface.

Material↗

Validation & Verification of Electrical Components B2 Test Facility

The research focus of this project is to assist in the closure of Measurement, Monitoring and Control System (MMCS) and other electrical requirements in support of the B2 Space Launch System (SLS) Core Stage Green Run Test Project. Alongside this goal I am to understand project management tools to analyze and control activities/tasks associated with those items. The project I am working on will assist electrical engineers in developing and or identifying closure rationale for the MMCS and electrical requirements. Also as serving the role of a training project manager, I am to develop and maintain a method for tracking progress with estimate completion dates specifically identifying those items during this performance window. The methods I used in order to perform the research consisted of worddocuments, excel sheets, and pdf documents needed for review. For example, documents consisted of: a SLS Core Stage Green Run Facility Requirement Document (FRD) identifying the SSC MMCS and electrical requirements, a Stage Controller to SSC Interface Control Document (ICD) identifying the SSC requirements, and the B2 SLS Core Stage Green Run Test project System Requirements Document (SRD) which identifies the MMCS and electrical requirements. The files were sent to me by both mentors, Mr. Barry Robinson and Ms. Dawn Davis. Overall, the review process for the word documents and excel spreadsheets proved to be successful. The data for the electrical components were accurate and were consistent with the original recorded data. However, the consistency with the pdf documents did not follow up all the way. Attention to this mistake was made and further revisions were done in order for the data to agree with each other. Furthermore, an itinerary was designed using Microsoft Outlook in order to track progress with estimated completion dates. This project contributes to NASA/Center Missions and Goals through the Waterfall Model. The Waterfall Model is a linear system used for engineering design. In the Waterfall Model, the fourth step is Verification and Validation. This involves installation, testing, and debugging of the B2 SLS Core Stage electrical components. For the SLS Core Stage Green Run Test Project, each requirement contained in this approved requirements set will have at least one Verification Item (VI) assigned to it. During the design phase, VIs will mostly consist of Analysis or Inspection types. Design phase VIs and closure information will be documented in Dynamics Data Management System (DDMS) in the form of analysis reports and design documentation.

Bastian, Tyler↗

The Advantages of Synergy-Quantitative Earth Science Data Visualization and Analysis with Giovanni, Panoply, and Excel

The NASA Giovanni data analysis system provides a multitude of basic analysis capabilities for numerous Earth science data products which are available in the NASA Goddard Earth Sciences Data and Information Services Center (GES DISC) archive, as well as for additional selected data products provided by other NASA Distributed Active Archive Center (DAAC) archives. In Giovanni, users can easily generate time-averaged data maps, area-averaged time-series, Latitude-Time and Longitude-Time Hovmoeller diagrams, correlation maps, accumulation maps, and map animations (22 analysis options are available in total). While ASCII text output is available for time-series plots, it is not included as an option for data maps. In order to provide a quantitative, easy-to-use numerical output in ASCII text form, the NetCDF file output from a Giovanni visualization is downloaded and then opened with the free NASA visualization software package Panoply. Panoply provides the capability of translating the Giovanni file into comma-separated-variable (CSV) output. Panoply also provides additional visualization options, including the facile calculation of difference maps and quasi-anomaly maps using Giovanni output files. The CSV files from Panoply can then be imported into an Excel spreadsheet, where an Excel macro converts the CSV files. The output consists of latitude-longitude-data value triads in text form for maps, and either longitude-time-data value or latitude-time-data value triads in text form for Hovmoeller diagrams. This presentation will explicate the basic procedure for the conversion, and then provide several examples where the procedure is applied to Giovanni output from different analysis options.

Earth science↗

Manual Asset Inventory: NASA Kennedy Space Center

The National Aeronautics and Aerospace Administration (NASA) relies in the security and protection of the information and information systems to know the devices that are connected to the Agency networks whether these are business, mission, research, or engineering devices. The Agency uses different Information Technology resources in order to do this process automatically, however, there are some devices that need to be reported manually. As a result of this, every month the Agency distributes among its Information System Owners (ISOs) the Manual Asset Inventory, a document that consists of a Microsoft Excel spreadsheet with twenty field descriptions cells that has to be filled out by the ISO of every Security Plan in the Center [fifty three in total] and uploaded into the IT Security Enterprise Data Warehouse (ITSEC-EDW).

Presentation↗

UH-60A Airloads Flight Test Program: Data Counter 9017

Aeromechanics Branch interns at Ames Research Center have been directly contributing to the data quality analysis and reporting of the UH-60A Airloads Flight Test Program for many years. In chronological order (together with the semester and year): Caroline Edwards (Summer 2011); Joni DeGuzman and Carson Turner (Fall 2011); Eric Fritz (Spring 2012); Connor Beierle (Fall 2012); Christopher Olinger (Spring and Summer 2013); Needa Lin, Anatole Levkoff, Maxwell Loebig, Jose Orejel, Megan Prout, and Albert Sue (Summer 2014); Jared Archey (Fall 2014); Alexander Crone (Summer 2015); Jeffrey Diament, Austin Djang, and Jessica Swan (Summer 2016); Makenzie Allen (Summer 2017); Colin Lauzon (Fall 2017); Eric Gilkey (Spring 2018); and Nicholas Masso (Summer 2019). These interns have spent their internships reviewing flight logs, extracting the data out of TRENDS, formatting the data into spreadsheets, writing code to automate the process, and plotting results. Without their efforts, much of the work would be unfinished. The authors appreciate the achievements of the UH-60A Airloads Working Group during its 20-year lifetime, as well the contributions of Randy Peterson, Tom Norman, and William Warmbrodt to the data processing and assistance with the report preparation. Lastly, this report is dedicated to William Bousman for his efforts preceding, during, and subsequent to the UH-60A Airloads Flight Test Program.

Kufeld, Robert M.↗

Systems Development, Datamining and Knowledge Discovery Abstract

This summer, 2020, during my NASA internship I worked with my mentor, Ali Shaykhian, as well as a group of four other interns: Javel Gramling, Janelisse Morales, Tristian Running Crane, and Zulmarie Jiménez. Our research and projects all differ but work together to solve datamining unstructured data into an easy to read format. Turning unstructured data into something easier to follow is important for helping quickly pull data out of larger documents, so that one doesn’t have to go through multiple pages to find certain data points. By being able to structure data pulled from a document, it can be usedto collect data from mass amounts of forms and arrange it in an easy to glance at table instead of multiple forms. I chose to focus mainly on creating form templates with both Microsoft Word and Excel and getting used to the types of data that can be collected; as well as learning where both programs differed. After I was familiar with what could be gathered, I worked towards taking data collected by a Word form and importing it into an Excel spreadsheet. By being able to transfer data from a Word document to an Excel document, there is an added layer of functionality to the datamining. Moving data around between Excel sheets isn’t that complex of a process, but when you try to import from a Word document a lot of formatting and readability can be lost. The purpose of my research is to reduce that loss by using Visual Basic scripts to clean and arrange imported data.

Makayla Amber Renfro↗

Conducted Susceptibility Data Adaptation Tool

The purpose of this research project is to help NASA scientists increase effectivity in testing by reducing the amount of time required for data conversion from initial measurements to the analysis stage. This project resulted in a data conversion tool developed in python using the openpyxl library. When lab personnel perform the Conducted Susceptibility 101 (CS101) and Conducted Susceptibility 02 (CS02) tests in the Semi-anechoic Electromagnetic Compatibility Test Facility at NASA Langley Research Center, the driving code produces a text file under the .DAT extension.The data must be manually converted the .DAT file into an Excel file line by line for data analysis.The Conducted Susceptibility Data Adaptation Tool (CSDAT) uses python code to convert the .DAT files to spreadsheets automatically which saves lab personnel time which they could use for faster analysis as well as prevents possible human error such as leaving out a line of data in the manual conversion process.

Gabriel Johnson↗

VESIcal Part I: An open-source thermodynamic model engine for mixed volatile (H2O-CO2) solubility in silicate melts

Thermodynamics has been fundamental to the interpretation of geologic data and modeling of geologic systems for decades. However, more recent advancements in computational capabilities and a marked increase in researchers’ accessibility to computing tools has outpaced the functionality and extensibility of currently available modeling tools. Here we present VESIcal (Volatile Equilibria and Saturation Identification calculator): the first comprehensive modeling tool for H 2 O, CO 2 , and mixed (H 2 O-CO 2 ) solubility in silicate melts that: a) allows users access to seven commonly used models, plus easy inter-comparison between models; b) provides universal functionality for all models (e.g., functions for calculating saturation pressures, degassing paths, etc.); c) can process large datasets (1,000’s of samples) automatically; d) can output computed data into an excel spreadsheet for simple post-modeling analysis; e) integrates advanced plotting capabilities directly within the tool; and f) provides all of these within the framework of a python library, making the tool extensible by the user and allowing any of the model functions to be incorporated into any other code capable of calling python. The tool is presented within this manuscript, which is a Jupyter notebook containing worked examples accessible to python users with a range of skill levels. The basic functions of VESIcal can also be access via a web app (https://vesical.anvil.app). The VESIcal python library is open-source and available for download at https://github.com/kaylai/VESIcal.

K. Iacovino↗

Battery Failure Databank

The Battery Failure Databank contains thermal runaway results gathered from nearly 300 small format fractional thermal runaway calorimetry (S-FTRC) experiments. A majority of these experiments were conducted at synchrotron facilities where high-speed x-ray videography was conducted of the cell while tested inside of the S-FTRC. The databank is a two-component system which consists of a Microsoft ExcelTM spreadsheet which provides S-FTRC results in tabular format and a radiographic video library containing the high-speed x-ray videos. Overall, the databank provides thermal results from S-FTRC experiments conducted on a mixture of commercially available lithium-ion (Li-ion) cells and specialized Li-ion test cells with varying cell format (18650, 21700, and D-cell) and trigger mechanism (heaters, heaters plus internal short circuiting device, and nail penetration). The radiography video component provides insight into the initiation and propagation of TR in the cells, in addition to consequences of TR measured by the FTRC. Fractions of mass ejected for the cell types are separated into regimes based on the different failure modes of the cells, such as purely venting, partial ejection, and total ejection. With knowledge of the rate and characterization of the internal degradation of the cells during TR, and the amounts of mass ejected and unrecovered, the extent of TR, and therefore the mitigation of TR, is revealed relative to cell types and failure modes.

Lithium-ion battery↗

One NASA PEM qualification standard : comparison of JPL and GSFC standards

Although use of Plastic Encapsulated Microelectronics (PEMs) in space applications is discouraged, their use is mandatory for selected applications involving the need for advanced technology and small packages. Various space systems designers and manufacturers have developed methods to qualify and screen PEMs. In general, each procedure is different. The purpose of this fiscal year’s investigation is to initiate a process to coordinate the efforts at various NASA centers to eventually develop a One NASA method. Part of this activity includes sharing of test data and PEM qualification methodologies. Various experts in the NASA community were identified and contacted to support this effort. We were successful in finding such experts at GSFC, APL and the Constellation office (Orion and Ares). All these experts provided typical qualification program plans. Since funding was severely restricted, it was decided to concentrate on coordination activity with GSFC. GSFC is planning a new version of IEEE-INST-002 section applying to PEMs. The GSFC expert (Dr. Alexander Teverovsky) provided a detailed assessment of the differences between the planned new version of IEEE-INST-002 and the JPL-D-19426 (JPL guideline) as well as a summary rationale for the decisions within the IEEE-INST-002. It should be noted that GSFC’s assessment of IEEE-INST-002 in the area of PEMs is not finalized. JPL is also considering changes in PEM qualification methodologies based on test data from recent qualification testing for their newer Projects (MSL, Grail, Juno). A spreadsheet delineating the differences between the JPL standard and the GSFC standard is presented.

Cooper, Mark↗

Calculator for Agricultural Water Use Fractions in California

Improved quantification of agricultural water use efficiency is a primary focus of California's Water Conservation Act. The California Department of Water Resources (CDWR), after extensive stakeholder consultation, has published methods and indicators to help identify opportunities for improved efficiency of irrigation management at various spatial scales. Additional 2017 legislation directs water suppliers to quantify water use efficiency using the CDWR metrics to support preparation of agricultural water management plans. The IrriQuest calculator derives the Crop Consumptive Use Fraction (CCUF), a foundational metric relating seasonal crop evapotranspiration (ET) to total applied water. Satellite normalized difference vegetation index (NDVI) data are used to develop fractional canopy cover timeseries. Additional key inputs include daily reference ET, irrigation volume, irrigation method, precipitation, soil texture and crop type. IrriQuest estimates of seasonal crop ET show less than 10% mean absolute error compared to ground-based measurements of several annual and perennial crops monitored by sensor deployment in commercial fields. Two additional indicators build on CCUF. The Agronomic Water Use Fraction adds consideration of water applied for beneficial purposes such as pre-plant soil preparation, soil salinity management, and climate control. Total Water Use Fraction additionally accounts for water applied for environmental purposes such as maintenance of wetland and riparian habitat. A convenient on-line portal is under development for CCUF estimation and a standalone spreadsheet is available for computation of all three use fractions.

Calculator↗

Down-Selection of Four Common Habitat Variants

The Common Habitat is a large habitat developed as an alternative architecture study, not part of the current NASA baseline, that uses the SLS core stage liquid oxygen tank as its primary structure. It has a gravity-independent internal architecture, such that identical units can be used on the lunar surface, Mars surface, and in microgravity. In developing the habitat, two key architectural questions emerged. Should the internal layout use a vertical or horizontal orientation of the tank? Should the crew size be four or eight? This led to the design of four variants: a four-crew horizontal, four-crew vertical, eight-crew horizontal, and eight-crew vertical. The four-crew variants use a shortened version of the tank while the eight-crew variants use the entire tank. The primary consideration applied for down-selection is the crew experience living and working in the habitat, inclusive of crew productivity, well-being, and survivability. Based on this consideration, a series of seven assessments were performed to compare the variants. This analysis was performed as an unfunded, volunteer activity leveraging civil servants across multiple field centers, most with expertise working in various Artemis teams. Additionally, the evaluation was limited to the use of CAD models, images, and spreadsheet data, with no resources available for mockups or Virtual Reality. A logistics analysis developed a standard logistics module and then estimated how much stowage could be carried onboard each Common Habitat and how many logistics modules are required by each variant for a given mission duration. It also considered the amounts of water to be stored in each variant. A functional analysis identified and compared the living and working functions across the habitats, ranking them relative to each other. A crew time assessment first estimated the total crew time, building a weekly crew timeline for both four and eight-person crews. It then allocated time to activities linked to living and working functions, comparing how much time was available for each function in each variant. A science productivity assessment developed a relative metric using crew time, science stowage, and assumed rates of experiment consumables use to analytically compare the four variants. It also comparatively ranked the habitats with respect to a number of subjective parameters and a workstation acceptability rating. A maintenance capacity assessment identified and compared eleven generic maintenance capabilities across the variants and also ranked them for their predicted ability to complete twelve fabrication, maintenance, and repair scenarios. A contingency responsiveness analysis examined twelve serious in-flight contingencies. For each scenario, the number of crew needed to respond were predicted and acceptability of various aspects of contingency response were evaluated, comparing the variants against each other. Finally, in a habitability assessment, 120 habitability characteristics reflecting 13 major categories were evaluated for each habitat. These results were compared to identify the most acceptable habitat in each category. Ultimately, the data favored the horizontal orientation over the vertical and an eight-person crew over four. Implications of selecting this variant are discussed, including specific architectural challenges that result from the use of the full tank.

Habitability↗

Crowd Sourcing Medical Data Collection Using Medical Students

OBJECTIVE We undertook an upgrade of the Evidence Library database of NASA HRP’s Integrated Medical Model, assessing 120 medical conditions which integrate with a novel probabilistic risk assessment (IMPACT) tool of medical risk and resource utilization for long duration exploration human spaceflight. This data collection process included a selection of these conditions crowd sourced over one year via three 4-week medical student electives at the University of Colorado School of Medicine (IDPT 8059 Space Medicine: Human Spaceflight Factors & Medical Risk Assessment). Students undertook a rapid systematic review of each medical condition, under close preceptors with backgrounds in clinical medicine, library science, epidemiology, biostatistics, and evidence-based medicine. As part of the elective, students also received instruction in core space medicine concepts, evidence based medicine and problem based learning sessions as a flight surgeon supporting a simulated Mars mission. METHODS The list of 120 medical conditions includes both common, terrestrial illness/injury (epistaxis, diverticulitis) as well as spaceflight-specific ones (space adaptation conditions, EVA-related injuries). A rapid systematic review process was developed that would allow students to find the data for determining disease incidence/prevalence, return to definitive care (often a surrogate such as hospitalization rates), loss of crew life, and treatment duration. Each data point required a tailored, specialized search process using different databases and corresponding specialized search filters. Databases were selected on their ability to provide high quality literature in an efficient manner and prioritized by their ability to provide graded evidence via a set rubrics specific to human spaceflight. Students were responsible for performing all literature searches and identifying the highest quality available evidence for each data point. Completed student data sheets underwent initial review by faculty preceptors followed by a secondary editing review by the ExMC Clinical Science Team. RESULTS Over the course of three electives, approximately 105 medical conditions were researched by students using spreadsheets with pre-crafted search strategies. Overall, this process was successful in allowing students to perform the preponderance of work to update incidence, treatment duration, return to definitive care, and loss of crew life data points. Students were successful in running searches, identifying the necessary data points within the literature, and determining the types of terrestrial data that most aligns with the astronaut population for successful completion of their tasks. Limitations included variable student experience with search methodologies [PubMed], differing values of evidence grading [best practice evidence based medicine vs. relevant to spaceflight], and students’ unfamiliarity with spaceflight specific conditions. CONCLUSION Finding the relevant literature for medical conditions in spaceflight within terrestrial databases in a systematic method is time consuming and not intuitive. However, the stepwise process that balanced sensitivity with specificity allowed for students to be highly successful in a short amount of time. Additionally, as the process was refined over the course of three electives, preceptors were better able to anticipate where students were likely to encounter barriers, which allowed the course to be adjusted to account for certain data points needing more time for completion. This replicable process may be an efficient way to accomplish rapid systematic reviews for a large volume of data in a short amount of time.

J Lemery↗

Design and Analysis of V-Groove Passive Cryogenic Radiators for Space-borne Telescopes & Instruments

V-groove passive radiators are extremely efficient passive designs to thermally isolate a cryogenic telescope or instrument from warm environments in space, like the Sun, Earth, Moon or Spacecrafts. Compared to traditional multi-layer insulation blankets employed for thermal isolation, the V-Groove radiators provide as much as an order of magnitude improvement. The V-Groove design typically constitutes three low emissivity, lightweight and thin aluminized Mylar/Kapton sheets angled from each other by just few degrees. These successively reflect heat from warmer shields to space via their angular openings, thus minimizing heat flow into the cryogenic system. Thermal analysis of these V-Groove radiators is typically performed by sophisticated thermal software that uses hundreds of thousands of rays to simulate radiative heat flow between successive shields via reflections, which can be very time & resource intensive. We have arrived at very simple closed form equations to predict the thermal behavior of these radiators, that includes their radiative heat transfer factors and temperatures as a function of their basic thermo-optical properties and inter-shield angles. These predictions can be done by hand calculators or in spreadsheet tools like MS-Excel. They compare very well to those from sophisticated computer programs. The ease in the use of these simple equations allow for instantaneous predictions of cryogenic temperatures and their trends for design options and trade studies. A case study of this was utilized for the telescope project that is currently being designed for an all sky spectral survey of the universe. This paper will describe the derivations of these equations, their comparison with computer software results and their applicability for current and future cryogenic space telescope and instrument missions

Bhandari, Pradeep↗

VESIcal: An Open-source Thermodynamic Model Engine for Mixed Volatile (H2O-CO2) Solubility in Silicate Melts

Modeling the solubility of volatiles in silicate melts is fundamental to the interpretation of volcanic systems and has implications for magma dynamics, eruption style, and material transport between the mantle, crust, and atmosphere. Recent advancements in computational capabilities and access to computing tools has outpaced the functionality and extensibility of previously available modeling platforms. Here we present VESIcal (Volatile Equilibria and Saturation Index calculator), the first comprehensive modeling tool for H2O, CO2, and mixed (H2O-CO2) solubility in silicate melts that: a) allows users access to seven popular models, with easy inter-comparison between models; b) provides universal functionality for all models (e.g., functions for calculating saturation pressures, degassing paths, etc.); c) can process large datasets (1,000’s of samples) automatically; d) can output computed data into an Excel spreadsheet or CSV file for post-modeling analysis; e) integrates plotting capabilities directly within the tool; and f) provides all of this within the framework of a python library, making the tool extensible by the user and allowing any of the model functions to be incorporated into any other code capable of calling python.Here we will provide a demonstration of VESIcal and its capabilities with applications to various volcanic processes affected by volatiles. VESIcal represents the first tool capable of directly comparing multiple solubility models and equations of state. We find that commonly used models predict surprisingly different volatile solubilities, particularly for pure CO2 or mixed CO2-H2O fluids. Even for melt compositions that are well represented in the calibration datasets of multiple models (e.g., MORBs), calculated solubilities for pure CO2 and pure H2O can deviate from one another by factors of >2 leading to 2x deviations in calculated saturation pressures (e.g., 5 to 10 kbar). The solubility of CO2 predicted by different rhyolitic models also differs substantially, overwhelming other sources of uncertainty such as analytical errors on measurements of volatile contents or uncertainties in crustal density profiles. This highlights the importance of model choice when drawing geological conclusions based on volatiles in magmas.

Kayla Iacovino↗