Have an idea?

Visit Sawtooth Software Feedback to share your ideas on how we can improve our products.

How to import Utilities in lighthouse with CSV file

I want to export my utilities, alter them manually, then import them into the lighthouse simulator. It is said to be a new function in 9.8.0, but I cannot find were to import it or any information on how.
asked Dec 3, 2019 by Lise Kristiansen

1 Answer

0 votes
You cannot easily alter the utilities within Lighthouse Studio's Choice Simulator.   But, the same market simulator is available as a standalone software package and has the same functionality and UI.  If you're licensed for Lighthouse Studio, then you (and your clients) are also covered for using the standalone Choice Simulator.  Here's where you download it:


I have found myself manipulating utility files and reading the manipulated file into Sawtooth Software simulators for over 20 years now.  The key file you'll be manipulating is the .HBU file.  It's a space-delimited text file you can manipulate with a text editor and/or with Excel.

My favorite way to work with an .HBU file is to open in Notepad and take the global header rows out (move them into a text file for holding purposes).  Then, open the remainder of the file (the rows of respondent data; one row per respondent) in Excel; modify the utilities in Excel, and save them out to a space-delimited text file.  

Then, I take the global header and put it at the top of the modified respondent records and save it as a new and modified .HBU file.

Then, open that .HBU file using Sawtooth Software's standalone Choice Simulator software.
answered Dec 3, 2019 by Bryan Orme Platinum Sawtooth Software, Inc. (174,640 points)
But it says in the improvements of your latest lighthouse studio version that importing utilities via CSV should be possible?


I know about this other way of doing in, I just don't understand why it cannot be done in lighthouse as well
That is an error in the Lighthouse release notes, which sometimes copies notes from the standalone Choice Simulator.

The most recent version of the standalone Choice Simulator can import utilities from a CSV file.  It has all the same features as the simulator in Lighthouse.  It can be downloaded from https://www.sawtoothsoftware.com/support/downloads/94-support/software-downloads/1651-downloadchoicesimulator.