Open Office instead of Excel

[Andrew_Hannell]

I have not tried this, but I believe you can create an ODBC connection an ODS file
I don’t know if OpenOffice install necessary drivers by default

Similar to this:

https://sea2.discourse-cdn.com/business6/uploads/dynamobim/optimized/2X/c/c02d96cd333eecbd17223369f802321370056848_1_690x388.PNG

Pushing a formula to Excel from a Dynamo String

I agree with the database idea- although you probably don’t want to reinvent everything if it is now (almost) working MSAccess is problematic, particularly with 64bit operating systems I have successfully used Dynamo with the free version of SQL server (used to be called SQLExpress, think it is something different now) The joins/lookups of data would probably be much easier in an SQL query. You can easily link the SQL tables back into MSAccess or Excel for reporting.