And then OneDrive comes along, someone accidentally saved “to the cloud” (IE the default windows location of OneDrive). And of course someone (you) has to fix all the desync bullshit.
Fuck excel, fuck Microsoft, fuck OneDrive!
Thank god my company is transitioning to a decent no code solution (nocobase plus literally anything that can interact with postgres - currently n8n but not yet limited to that. It’s a transition from excel, literally anything is better! (Tho, nocobase is awesome, non has it’s perks)).
Many parentheses, soz.
Fuck excel, use a database!
I’ve seen at a very large company a workflow that involved manually updating an excel workbook and (I think) saving it on confluence, so a python script could download it and parse it later. It wasn’t even doing formulas. It was just like less than a hundred lines of text in a half dozen sheets.
Professionals do seem to use excel.
Holy fuck is it painful for anyone that knows what they are doing.
15000 rows. 120 columns. One sheet. Creation date: 2011. A dedicated computer. Working at a multinational company is bad for mental health.
And then OneDrive comes along, someone accidentally saved “to the cloud” (IE the default windows location of OneDrive). And of course someone (you) has to fix all the desync bullshit.
Fuck excel, fuck Microsoft, fuck OneDrive!
Thank god my company is transitioning to a decent no code solution (nocobase plus literally anything that can interact with postgres - currently n8n but not yet limited to that. It’s a transition from excel, literally anything is better! (Tho, nocobase is awesome, non has it’s perks)).
Many parentheses, soz.
Fuck excel, use a database!
deleted by creator
100k+ rows and columns that want over ‘BMW’, worked actually fine
I’ve seen at a very large company a workflow that involved manually updating an excel workbook and (I think) saving it on confluence, so a python script could download it and parse it later. It wasn’t even doing formulas. It was just like less than a hundred lines of text in a half dozen sheets.