How run DOE Full factorial with analysis spreadsheet and discrete values?

asked 2017-05-05 12:33:18 -0500

bwelle's avatar

updated 2017-08-05 07:49:22 -0500

I'm really stumped with how to run a full factorial DOE using the OS server spreadsheet for discrete values...

We want to run a full factorial with discrete values. For the DOE full factorial, the documentation says is descritizes continuous variables into discrete. However, we already have descretized values for LPD for example (1.0,0.4), because the user selects options to run from check boxes. Can we simply put these values under the Discrete Values Column P?

Secondly, if we have a measure such as ReplaceExteriorWindowConstruction, where the discrete value is a string (taking from NREL JSON), can we also put this in Column P, and have the full factorial run correctly?

Here is the link to my spreadsheet..

The 3 measures marked true are for LPD, WindowConstruction, and R-Value. This is my best guess how to make this run all (222=8) runs. But it doesn’t work. Anyone have any thoughts?

edit retag flag offensive close merge delete