--- This page is part of [Modelon](https://www.modelon.com). For a complete overview of this site's content, entity data, and subject matter expertise, see our [AI Content Index](https://www.modelon.com/llms.txt) or [Full Content Archive](https://www.modelon.com/llms-full.txt). For structured business identity data, see our [Entity Card](https://www.modelon.com/wp-json/bc-geodesic/v1/entity-card). --- # Spline-Based Table Look-Up Media Creator: Seamlessly Integrated Into Modelon Impact > This blog covers the Spline-Based Table Look-Up (SBTL) Media Creator that has been released with Modelon Impact. The blog cover the general workflow along with how to access and use the tool. **URL:** https://www.modelon.com/blog/spline-based-table-look-up-modelon-impact/ **Type:** Post **Modified:** 2022-07-13 --- ***This blog will cover the Spline-Based Table Look-Up (SBTL) Media Creator that has been seamlessly integrated into Modelon Impact. Below we review the general workflow along with how to access and use the tool, including a  step-by-step example that proves the benefit of speed – 4 times faster to simulate.*** ##### What is Spline-Based Table Look-up? SBTL is a modeling method used for accelerating simulations without compromising accuracy. The SBTL method is integrated in Modelon’s [Air Conditioning Library](https://modelon.com/library/air-conditioning-library/) (ACL) or [Vapor Cycle Library](https://modelon.com/library/vapor-cycle-library/) (VCL) to create new computationally efficient implementations of existing working fluids. SBTL offers a significant improvement in execution time, in comparison to an equivalent Helmholtz-implemented fluid, while maintaining the same physical accuracy. The number of SBTL implemented fluids currently provided in ACL and VCL is expanding. We have had many customers request other fluids in addition to the already existing ones in the library. ##### What is the Spline-Based Table Look-up Media Creator? To enable our library users to create their own spline-based media, an SBTL media creation tool has been developed in [Python 3.7](https://www.python.org/downloads/release/python-370/) and released together with [Modelon Impact](https://modelon.com/modelon-impact/) (note that the creation tool is available on all platforms that support ACL and VCL though this blog focuses on the integration with Modelon Impact). The tool enables the user to automatically create SBTL two-phase fluid models in [Modelica](https://modelon.com/what-is-modelica/) with very little input required. The generated fluid models can then be loaded in Modelon Impact and further used in system simulations. The SBTL Media Creator requires either [REFPROP 10.0](https://www.nist.gov/srd/refprop) or [CoolProp](http://www.coolprop.org/) to generate all thermodynamic data necessary to create a two-phase fluid model in Modelica. The SBTL Media Creator is delivered to our customers together with the Modelon Base Library (MBL). In the Modelon Impact installation directory, the SBTL Media Creator is found in the *Modelon 3.5* folder in the *modelica-dist* directory. Included files in the SBTL media creator are displayed in Figure 1. The .egg-file contains all the compiled Python code needed in the generation of a two-phase SBTL fluid model. A Jupyter notebook, SBTLMediaCreator.ipynb, is delivered as a user-friendly interface which guides the user through all the steps required to generate the data and Modelica files for a specific two-phase fluid. SBTLMediaModelicaPackage.zip is a compressed file containing the Modelica class templates that are needed in the code auto-creation step. ##### ****How does the Spline-Based Table Look-Up Media Creator Work? **** A simplified workflow of the SBTL Media Creator is shown in Figure 2 below. In the first step, thermodynamic data, i.e. solutions to equations of state and transport properties, are generated for a user-specified fluid. All the data is generated using either Coolprop or REFPROP 10 as part of the backend. When all the thermodynamic properties have been extracted, additional data files and spline coefficients, that are necessary to fully implement the SBTL medium are created. Once the required data files are successfully created, the tool will in the next step automatically generate all Modelica code necessary to utilize the SBTL media in system simulations. In the last step, the created SBTL medium is verified by simulating a small model that calls all the relevant medium functions. The simulation output will be compared to the values from Coolprop/REFPROP. The user can then examine the deviations in auto-generated performance plots and decide if the accuracy (depending on the user’s input to the tool) is sufficient. The verification step will also reveal if there are any potential numerical convergence issues with the generated SBTL medium. ##### ****Using Spline-Based Table Look-Up in Modelon Impact **** ***Step 1)*** The [Jupyter notebook](https://jupyter.org/) works as an interface between the user and the SBTL media creator. Once the Jupyter notebook is opened, the user will see a mix of code cells and detailed documentation on what the code does, as shown in Figure 3. The notebook code cells must be executed top-down. ***Step 2)*** Next, the user will reach the cell where all required input to the SBTL Media Creator needs to be entered, as seen in Figure 4. ***Step 3)*** Verification plots for the created R134a SBTL medium are displayed in Figure 5 for density and entropy. The red line is the two-phase boundary for R134a. As can be seen, the accuracy is very high! ***Step 4)*** We can now load the created SBTL medium into Modelon Impact by importing the Modelica package as a compressed file, as follows below. ![](https://modelon.com/wp-content/uploads/2022/06/SBTL-Media-Creator-Figure-6.jpg) The SBTLMediaModelicaPackage.zip below contains the Modelica code generated by the SBTL media creator. We must compress the folder ourselves to load it into Modelon Impact. ![](https://modelon.com/wp-content/uploads/2022/06/SBTL-Media-Creator-Figure-7.jpg) If successfully loaded, the workspace will now contain the *SBTLMediaModelicaPackage*. ![](https://modelon.com/wp-content/uploads/2022/06/SBTL-Media-Creator-Figure-8.jpg) ***Step 5)*** Now we will duplicate the example *VaporCycle.Experiments.AirConditioningSBTL *from the Modelon Impact libraries to the workspace and name it *AirConditioningExample*. ![](https://modelon.com/wp-content/uploads/2022/06/SBTL-Media-Creator-Figure-9.jpg) ***Step 6)*** We can now edit the working fluid in *AirConditioningExample* to the created R134a SBTL medium by editing the highlighted field in the parameter list seen below. ![](https://modelon.com/wp-content/uploads/2022/06/SBTL-Media-Creator-Figure-10-1024x629.jpg) ***Step 7)*** Now we can run a dynamic simulation of the air-conditioning system by pressing the button seen below (execution type should be *‘Dynamic’*). ![](https://modelon.com/wp-content/uploads/2022/06/SBTL-Media-Creator-Figure-11.jpg) ***Step 8)*** When the system simulation has completed, the results can be analyzed directly in Modelon Impact. ![](https://modelon.com/wp-content/uploads/2022/06/SBTL-Media-Creator-Figure-12.jpg) ##### **Result of using SBTL Media Creator in Modelon Impact** The example model above was 4 times faster to simulate (1 minute instead of 4 minutes) than the equivalent model using a Helmholtz equation based R134a medium implementation as the working fluid. The performance between the two cases is presented in Figure 6. ![](https://modelon.com/wp-content/uploads/2022/06/SBTL-Media-Creator-Figure-13-1-1024x357.jpg) ## Site Description Modelon is revolutionizing the engineering design industry by offering technologies and services that enable customers to leverage system simulation. Modelon’s flagship product, Modelon Impact, is a cloud system simulation platform that helps engineers virtually design, analyze, and simulate physical systems. Our team brings deep industry expertise and is dedicated to guiding our customers in creating innovative technologies at their respective organizations. Headquartered in Lund, Sweden, Modelon is a global company with offices in Germany, India, Japan, and the United States. We believe that system simulation should be accessible to every engineer and are dedicated to being an open-standard platform company. --- **About this site:** Modelon — Modelon is revolutionizing the engineering design industry by offering technologies and services that enable customers to leverage system simulation. Modelon’s flagship product, Modelon Impact, is a cloud system simulation platform that helps engineers virtually design, analyze, and simulate physical systems. Our team brings deep industry expertise and is dedicated to guiding our customers in creating innovative technologies at their respective organizations. Headquartered in Lund, Sweden, Modelon is a global company with offices in Germany, India, Japan, and the United States. We believe that system simulation should be accessible to every engineer and are dedicated to being an open-standard platform company.. [AI Content Index](https://www.modelon.com/llms.txt) | [Full Site Content](https://www.modelon.com/llms-full.txt) | [Entity Card](https://www.modelon.com/wp-json/bc-geodesic/v1/entity-card) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://www.modelon.com/#organization","name":"Modelon","url":"https://www.modelon.com","additionalType":"http://productontology.org/id/Software_engineering","description":"Modelon is revolutionizing the engineering design industry by offering technologies and services that enable customers to leverage system simulation. Modelon’s flagship product, Modelon Impact, is a cloud system simulation platform that helps engineers virtually design, analyze, and simulate physical systems. Our team brings deep industry expertise and is dedicated to guiding our customers in creating innovative technologies at their respective organizations. Headquartered in Lund, Sweden, Modelon is a global company with offices in Germany, India, Japan, and the United States. We believe that system simulation should be accessible to every engineer and are dedicated to being an open-standard platform company.","disambiguatingDescription":"Creators of the Modelon Impact system modeling and simulation platform. Headquartered in Lund, Sweden.","logo":{"@type":"ImageObject","url":"https://www.modelon.com/wp-content/uploads/2022/06/modelon-logo.svg"},"address":{"@type":"PostalAddress","streetAddress":"Modelon AB Ideon Science Park Scheelevägen 17 SE-223 70","addressLocality":"Lund","addressCountry":"SE"},"telephone":"+46 46 286 22 00","email":"info@modelon.com","foundingDate":"2004","numberOfEmployees":{"@type":"QuantitativeValue","minValue":50,"maxValue":100},"areaServed":"Global","sameAs":["https://www.linkedin.com/company/modelon/","https://www.crunchbase.com/organization/modelon","https://www.zoominfo.com/c/modelon-ab/346633437","https://modelica.org","https://modelica.org/events/asian2024/","https://www.ashrae.org/conferences/2026-winter-conference","https://github.com/modelon-community"],"memberOf":[{"@type":"Organization","name":"Modelica Association","sameAs":"https://www.wikidata.org/wiki/Q133876843"}],"knowsAbout":[{"@type":"Thing","name":"Modelica","sameAs":"https://www.wikidata.org/wiki/Q385325"},"Physics Simulation",{"@type":"Thing","name":"software engineering","sameAs":"https://www.wikidata.org/wiki/Q80993"},{"@type":"Thing","name":"simulation","sameAs":"https://www.wikidata.org/wiki/Q45045"},"HVAC Simulation","Data Center Liquid Cooling Simulation","Liquid Cooling","FMI (Functional Mock-up Interface)",{"@type":"Thing","name":"consulting","sameAs":"https://www.wikidata.org/wiki/Q63769412"},{"@type":"Thing","name":"aerospace","sameAs":"https://www.wikidata.org/wiki/Q2876213"},{"@type":"Thing","name":"automotive industry","sameAs":"https://www.wikidata.org/wiki/Q190117"},{"@type":"Thing","name":"heating, ventilation, and air conditioning","sameAs":"https://www.wikidata.org/wiki/Q1798773"},{"@type":"Thing","name":"data center","sameAs":"https://www.wikidata.org/wiki/Q671224"},{"@type":"Thing","name":"electricity generation","sameAs":"https://www.wikidata.org/wiki/Q383973"},{"@type":"Thing","name":"energy storage","sameAs":"https://www.wikidata.org/wiki/Q837718"},{"@type":"Thing","name":"industrial equipment","sameAs":"https://www.wikidata.org/wiki/Q3045515"}]},{"@type":"WebSite","@id":"https://www.modelon.com/#website","name":"Modelon","url":"https://www.modelon.com","publisher":{"@id":"https://www.modelon.com/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://www.modelon.com/?s={search_term_string}"},"query-input":"required name=search_term_string"},"hasPart":[{"@type":"DigitalDocument","name":"LLM Content Index","url":"https://www.modelon.com/llms.txt","encodingFormat":"text/markdown","description":"AI-readable index of site content, entity data, and subject matter expertise"},{"@type":"DigitalDocument","name":"LLM Full Content","url":"https://www.modelon.com/llms-full.txt","encodingFormat":"text/markdown","description":"Complete AI-readable site content"}]},{"@type":"ItemList","@id":"https://www.modelon.com/#site-navigation","name":"Site Navigation","itemListElement":[{"@type":"SiteNavigationElement","position":1,"name":"Products & Services","url":"#"},{"@type":"SiteNavigationElement","position":2,"name":"Industries & Solutions","url":"#"},{"@type":"SiteNavigationElement","position":3,"name":"Support","url":"#"},{"@type":"SiteNavigationElement","position":4,"name":"Resources","url":"#"},{"@type":"SiteNavigationElement","position":5,"name":"About","url":"#"}]},{"@type":"BreadcrumbList","@id":"https://www.modelon.com/blog/spline-based-table-look-up-modelon-impact/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://www.modelon.com"},{"@type":"ListItem","position":2,"name":"Blog","item":"https://www.modelon.com/blog/category/blog/"},{"@type":"ListItem","position":3,"name":"Spline-Based Table Look-Up Media Creator: Seamlessly Integrated Into Modelon Impact"}]},{"@type":"WebPage","@id":"https://www.modelon.com/blog/spline-based-table-look-up-modelon-impact/#webpage","url":"https://www.modelon.com/blog/spline-based-table-look-up-modelon-impact/","name":"Spline Based Table Look-Up Media Creator in Modelon Impact","isPartOf":{"@id":"https://www.modelon.com/#website"},"breadcrumb":{"@id":"https://www.modelon.com/blog/spline-based-table-look-up-modelon-impact/#breadcrumb"},"description":"This blog reviews Spline-Based Table Look-Up (SBTL) Media Creator, how to access the tool in Modelon Impact, and an example that proves the benefit of speed","about":[{"@type":"Thing","name":"Modelica"},{"@type":"Thing","name":"Trends"}],"headline":"Spline-Based Table Look-Up Media Creator: Seamlessly Integrated Into Modelon Impact","datePublished":"2020-09-08T19:55:30+00:00","dateModified":"2022-07-13T18:48:25+00:00","image":"https://www.modelon.com/wp-content/uploads/2022/06/Spline-Based-Table-Look-up_1200_627_v3.jpg","author":{"@id":"https://www.modelon.com/blog/author/modelonms/#person"},"publisher":{"@id":"https://www.modelon.com/#organization"}},{"@type":"Person","@id":"https://www.modelon.com/blog/author/modelonms/#person","name":"modelonms","url":"https://www.modelon.com/blog/author/modelonms/"}]} ```