News for hackers. Stuff that matters.

A comment on Mesh Spreadsheet. Parent comment

Re:Mesh Spreadsheet by microcolonel on Monday September 30, 2019 @11:56AM (#21116729)
I do whole program analysis, and the host is not interpreted. The costs are mostly about the data structures used to store the intermediate values. Automatically selecting whether to make some values contiguous or not is difficult, and the types are a bit complex (basically option types).

The sheets I'm working with have around a million expressions, and there are large sparse regions, so the data structures have to be a bit compact.

[ Parent | on HN ]
Re:Mesh Spreadsheet by vchak1 on Monday September 30, 2019 @01:19PM (#21117565)
I also think it would be valuable to autoconvert long lines (rows or columns) of similar formulas into a mapping on an array. That would require some level of shape analysis on the excel file.
[ Parent | on HN ]
Re:Mesh Spreadsheet by microcolonel on Monday September 30, 2019 @03:30PM (#21118861)
That is in fact the first step, we have around 800k instances, but only around 1500 unique combinations of dependency shape and expression, which makes a big difference.
[ Parent | on HN ]
Re:Mesh Spreadsheet by infinite8s on Monday September 30, 2019 @01:58PM (#21117981)
Sounds interesting, have you published any more details anywhere?
[ Parent | on HN ]
Re:Mesh Spreadsheet by microcolonel on Monday September 30, 2019 @03:33PM (#21118885)
Not yet, gotta do our jobs first, then we can have the candy. :- )

I would like to do a write-up about it at some point though, if for no other reason but to show the Open Document or LibreOffice people what could be improved about the formats.

[ Parent | on HN ]