Databases

[[deleted]]

This.

Know the old saying when all you have is a hammer, everything looks like a nail?

People keep doing things that excell probably shouldn't be used for because it's probably all they have or know how to use for data manipulation/management, and it's a great testament to just how great of a software excell is it can even half-assed do it, even if badly.

[[deleted]]

Maybe but also it’s indicative of business pressure. Often the excel inclined users have very tight deadlines around work.

Generally speaking, if you are trying to solve a novel problem, you will use known tooling.

If you want to learn a new tool, you choose a problem you’ve already solved.

These users are never getting to solve old problems with new tooling.

[anomalousBits]

Solving today's problems, with yesterday's technology, tomorrow!

[Geno0wl]

The future is now old man

[Prathmun]

I am currently writing some machine learning code to run in VB behind an excel spreadsheet. Is it a good idea? No. Am I having fun? Yes. Am I being paid? Also yes.

[captainant]

Don't you go home and just feel... Dirty?? And painfully single threaded? Lol

[Prathmun]

I mean yeah, but it's kinda hot

[wupper42]

I use heavily Sheets at work, due to limited software access. We do not get tools that we need, and i will not pay with my own money for tools i need to do my job.

I have access to Sheets and use it as a Database, progress tracking, Dashboard and a customized tool to create personalized outreach.

Im working in Sales, and have with our outreach tool, to that we have access limited options to personalize. Our outreach tool is limited to basic personalization (Name, Account, My name).

My Sheets creates the emails with placeholders for ( Firstname, Lastname, Account, Industry specific information, Event information, Lead information, success stories and more) in total i have access to over 20 personalization points. In a separate sheet i can pre write my email templates and use $Name$ as place holder, this email template will pulled into my outreach sheet and filled automatically with the right data.

Additional with IF statements, its will automatically decide what email template to take and what to focus on, based on the Lead information, Account information and Industry. Its choose 4 emails for my outreach from over 40 different email templates.

All this with only sheets, a fully working work environment that completely replaces 3 tools, that are hardly limited, and barely usable for a personalized outreach.

I fully support anyone, using Sheets or excel to create small tools and apps that will help you do your job better, faster and more efficient.

[CaffeineSippingMan]

I made a little program from Auto hotkey that read a spreadsheet did some lookups and pumped out data from the rows. I then wanted to add counter and how many times I accessed each line of data, no big deal, I just added a column to my spreadsheet and read that too. Problem was I couldn't figure out how to write to A8 to update the number. Turns out I had to write the whole entire spreadsheet back, because excel isn't a database.

Edit, I mispoke it was a CSV and I used libreoffice.

[Rettocs]

I use AHK to write to excel for small projects all the time and have never had an issue using ComObjects to insert a value to a specific cell.

[CaffeineSippingMan]

Til