I hope there’s a place worse than hell
Comment on I try to spice it up with some VB Macros but it's still ultimately just a spreadsheet.
ViatorOmnium@piefed.social 21 hours agoWhy not both. I once wrote an abomination that read and wrote data into a Google Spreadsheet, interacting with formulas in the spreadsheet in the process.
iii@mander.xyz 7 hours ago
EditsHisComments@lemmy.world 21 hours ago
Jesus Christ
virku@lemmy.world 21 hours ago
Oh Lord. Before I found power bi 15 or so years ago I made interactive speeadsheets that did a lot of querying directly towards sql based on a set of input cells. Did a lot of crunching on the data merging data fetched from different database etc before presenting them in their own sheets. The worst part is that it was a huge leap from what we did earlier. Then I would write sql queries and dump the result to Excel every time management needed data.
prex@aussie.zone 1 hour ago
Image