ornl-amo / enpi Goto Github PK

There are spill errors with chaining calculations due to the new dynamic array features added to Excel and the implicit intersection operator. More information about this issue can be found here: https://support.microsoft.com/en-us/office/implicit-intersection-operator-ce3be07b-0101-4450-a24e-c1c999be2b34

See branch 'fix-chaining'

When a variable fails all models, the red text that appears on the SEP tab uses the phrase "energy use" when it should be "energy consumption".

In the Model Data Tab
SEP Validation Table
Row "SEP Validation Check"

Could the entries be right aligned?

Can the tool be made to work if the computer's setting is something other than U.S.?

From Daryl

It would be cool if we could customize the names of the data sheets.

Instead of "1 EnPI Results" , if it could be also partially based on the name of the sheet where the data came from.

Please see below screen shot. On the side “Model Switch” windows, the value of Adj R^2 was actually that of R^2.

Make so user can change units? Make so can download U.S. or International versions?

Right now, the tool is checks that all energy variables have (MMBtu) somewhere in their column name and then writes energy columns w/ the units MMBtu (/ year, / unit, etc)

Would also have to change unit converter (can only convert to MMBtu)
Would also have to get emissions data of other places

If doing a roll up and mixing regression and actual data, the roll up cannot add some fields

Regression:
Auto names energy data as "Actual XX" and "Actual YY"
(XX and YY come from the column names)

Actual data:
Auto names energy data as "XX" and "YY"
(XX and YY come from the column names)

So when you do the roll up, Excel doesn't know to add "XX" + "Actual XX"

Solution: where change name of results fields in "Actual Data" to also be "Actual XX" instead of "XX"

EnPI cannot install on a Mac VM