JSteam Online Help Manual

JSteam Excel Add In Installation Guide


This guide will help you quickly install and license the JSteam Excel Add In. The guide should be completed in order, or you can jump to a step directly below.

Jump to step:

  1. Downloading the Add In
  2. Installing the Add In
  3. Starting the Add In
  4. Installing a License
  5. Trusting the VBA Object Model
  6. Locating your MAC address


Downloading the Add In

The latest version of JSteam Excel Add-In is available from Dropbox here.

When choosing a version (Office 32bit or Office 64bit) please be aware the Office 64bit version only supports Office 2010/2013/365/2016 64bit. Many users mistake having a 64bit operating system automatically infers Office is also 64bit – this is not normally the case! Most companies and universities will be using Office 32bit. To check which version of Excel you currently have please see the following steps:

Office 2007: Excel 2007 was only released as 32bit software, so simply download the 32bit version of JSteam.

Office 2010: Click File -> Help

Office 2013/365: Click File -> Account

Office 2016: Click File -> Account -> About Excel

For Office 2010 or greater, simply download the version of JSteam associated with that shown in your version of Excel.


Installing the Add In

JSteam Excel Add-In is supplied as a standalone executable that will automatically install all pre-requisites as the installation progresses. The exception is .NET v4.0 (a set of Microsoft libraries) which the user will be directed to download before installation can commence.

There are a couple of steps that you will be manually required to complete when installing JSteam, as detailed below:

a) During installation you will be prompted to install the Visual C++ 2010 Runtime Libraries (x86 or x64), please ensure you click Install, as below. If the installer asks you to repair or remove the libraries, please ensure you select repair, and click Next.

b) When installing the Add-In you will prompted to choose the installation folder, and the availability of the Add-In, as below:

It is highly recommended you keep the default settings. Please note installing for “Everyone” will not function correctly in Excel 2007 without a patch. If this functionality is required in Excel 2007, please contact your system administrator to apply the patch described here http://support.microsoft.com/kb/976811.

c) Depending on the setting of “Window’s Updates” on a user’s computer, one of the pre-requisites may request for the computer to be restarted before installation is complete. If this occurs, please run the JSteam Excel Add-in installer again after the computer has restarted. This will ensure all components are installed correctly.


Starting the Add In

Once the Add-In has been successfully installed simply start Excel and you should see a new Ribbon Tab called JSteam. By default JSteam is not loaded when Excel starts, therefore to load it click Load -> JSteam, as shown below:

The first time JSteam is loaded you will be presented with the following window:

The options you have at this point are as follows:

a) Purchase the full version, including optional add-on modules. Clicking the link will take you our website where you can complete the purchase. While you are waiting for your license to arrive you may begin to use JSteam by clicking “Use Demo”.

b) Request a 30 day evaluation license, which enables all functionality and optional modules. Clicking the link will take you to our website where you can complete the request. While you are waiting for license to arrive you may begin to use JSteam by clicking “Use Demo”.

c) Install a license sent to you via email. Once we have received your payment confirmation or license request we will send you a .lic file to your email address. See the next section for instructions on installing your license.

d) Use JSteam Excel Add In in demo mode which is limited to water and steam thermodynamic functions only.


Installing a License

Once you have received a license file (.lic) from us please save it to your computer somewhere you can find it again, for example on the desktop. To install the license complete the following steps:

a) Start Excel, then click Load JSteam from the JSteam Ribbon.

b) Click About:

c) Click Install License:

d) Find the .lic file we emailed you (for example on the desktop as above, and click Open).

e) If you have Windows User Access Control (UAC – the window that asks are you sure you want to let a program modify your computer) enabled you will need to give JSteam permission to copy to the license file to your Program Files directory. Click OK, then Yes in the following window (don’t worry if you don’t see this window):

f) Your new license file is now installed, and you will see a window indicating the operation was successful. Restart Excel to enable the new license functionality. This process can be repeated to install a new license if required. Licensed functionality will be listed in the About Window.

g) If your license did not install successfully you will need to manually copy it to the directory indicated in the error window. Please ensure you rename your license file to JSteam.lic to ensure JSteam can find it.


Trusting the VBA Object Model

JSteam uses the VBA Object model to track the compositions sheet, as well as the current unit set between workbooks. By default it is not enabled, thus the first time you install JSteam into Excel you will need to perform the following steps. Note the description below is for Excel 2010, but it is very similar for the other versions:

a) Start Excel, Click File -> Options

b) On the Trust Center tab, click Trust Center Settings:

c) On the Macro Settings tab, ensure “Trust access to the VBA Object Model” is ticked:

d) Click OK to save the changes, then Restart Excel to update the object model settings.


Locating your MAC address

To license your copy of JSteam we require the MAC address of the computer you wish to use install and use JSteam on. To make this process easy, JSteam automatically displays your computer’s MAC address in the About window.

A MAC address is a 12 digit hexadecimal (0-9 and A-F) number, such as:

	0123456789AB

In order to obtain your MAC address, please complete the following steps:

a) Ensure Ethernet and Wireless adaptors are turned on. For example if using a laptop, ensure WiFi is turned on, and the laptop is plugged into a power outlet. Some brands of laptops disable the Ethernet (network) adaptor when not plugged in, which can cause license authentication to fail. Desktops should not normally have this problem (unless using a Wireless USB Adaptor, therefore ensure it is plugged in).

b) Complete the Download, Install and Start JSteam steps above, and when prompted to select a licensing option, click Use Demo.

c) Click About on the JSteam Ribbon:

d) Within the box “System MAC Address:” copy and paste the 12 digit hexadecimal number in an email to us at support@inverseproblem.co.nz:

e) Once you have received your license from us, complete the license install step above to install the license.