Unknown error when using the OpenStudio Spreadsheet

edit

@BrianLBall Thanks that worked :)

I'm now getting an error with a measure. Do you by any chance know what this means:

"[10:13:27.2 INFO] Loading Measure from /mnt/openstudio/analysis_4dd0afc0-83b5-4ecf-98e0-fd5d37565009/measures/ChangeRoofThermalProperties/measure.rb [10:13:27.2 INFO] Iterating over arguments for workflow item 'change_roof_thermal_properties' [10:13:27.2 INFO] Setting argument value '__SKIP__' to 'false' [10:13:27.2 ERROR].......Failed with Could not find argument map in measure for '__SKIP__' with value 'false',....."

that usually means you are trying to set a measure argument that doesn't exist. I would double check your measure arguments for that measure in the spreadsheet and make sure they are all legit by comparing them to whats actually in the measure. Also, try using the measure in the OS app with the 'apply measures now' feature and see if you get the same error.

actually I think the problem is with your openstudio-analysis gem in the spreadsheet repo. In your Gemfile and Gemfile.lock, change the version to 0.4.5 and update your gems. (you might need to force nokogiri to 1.6.8.1 if you do bundle update).

I did that and updated my gems and now im getting an error in cmd when doing the rake run after selecting a project.

"Unable to parse spreadsheet ./projects/SingleZone.xlsx with version 0.4.2 due to error: Roo::HeaderRowNotFoundError

yeah, i had the error too while trying to get the gems correct. You might try recloning the repo into a new directory, make those changes and then do a 'bundle' and 'bundle update'. But once you get the right analysis gem in there that should clear that error up.