Small emittors calculator by Eurocontrol does not work in Calc

[JacDen]

Can anyone solve this problem?
After downloading the latest Eurocontrol Small Emittors calculator from Small emitters tool (SET) | EUROCONTROL and then then opening it with Calc it gives 504 error.
Older versions worked fine.

Wen asked for an OpenSource tool, the answer by Eurocontrol was:
“Unfortunately we are not validating (nor currently supporting) the tool under openOffice or under non Microsoft Excel tools*
One way out would be to ask the actual equation which are behind the SET, and build a version under LibreOffice or another tool.
The equation can be requested and obtained after signing a specific agreement.
I attach a draft agreement for information.
*Should you want to proceed in that way, please fill the below information and send-us an email back at ets.info@eurocontrol.int”

thanks for help.

[erAck]

Already the 2022 version gives Err:504. 2021 version seems to work. If they don’t want to provide an open version and as they state in their License Agreement for 7. Restrictions on Use and 8. Intellectual Property Rights that

The Licensee shall not modify the SET;

you are on your own.

However, in 2022 on sheet Calculator in the formulas of columns J,L,M they started to use a form of table structured reference t_models[#Data] (instead of t_models[[#Data]], note the bracketing) that Excel seemingly accepts but is not mentioned in Using structured references with Excel tables - Microsoft Support though may be covered by the ABNF grammar in [MS-XLSX]: Formulas | Microsoft Learn at structure-reference = ... and following, specifically
intra-table-reference = spaced-lbracket inner-reference spaced-rbracket / keyword / ("[" [simple-column-name] "]")
the plain keyword part (where keyword here is the special item specifier [#Data]) without extra brackets, but anyway that’s not implemented by Calc.

You may want to submit a request for enhancement bug for this and report back the bug number here in the form tdf#123456.

Theoretically you could replace all occurrences of t_models[#Data] with t_models[[#Data]] in the sheet’s XML stream xl/worksheets/sheet3.xml in the .xlsx zip container and it probably would work again. But as said, you’re bound by their license.

The working 2021 version used t_models[] which references the entire table including the column headers and not just data, that’s probably what they wanted to change.