News for hackers. Stuff that matters.
Re:Human genes renamed to stop Microsoft Excel from misreadi... by cupofpython on Monday April 11, 2022 @04:05PM (#30994106)
I do this all the time. Excel is a fantastic data GUI for ad-hoc reporting.

My typical quick turn-around process is: type SQL in text editor, test sql in database, create a view, connect to the view from excel, use native excel features to display whats needed.

Usually I create a summary page as well which uses sum-ifs and such on the query result for the high level detail rather than go through the SQL process for it separately

There are no comments on this comment yet.