sigmoid.social is one of the many independent Mastodon servers you can use to participate in the fediverse.
A social space for people researching, working with, or just interested in AI!

Server stats:

525
active users

#spreadsheet

1 post1 participant0 posts today

Can you help me with an information storage and retrieval problem?

I have more than 2000 YouTube videos saved in 65 playlists. I would like to search for particular videos, but YouTube does not make it easy.

So I thought about doing something like this:

1) Create a document that would list every saved video with its URL.

2) Create a preliminary list of descriptive tags for the videos.

3) Begin the task of tagging each entry on the video listing in the document , adding new tags when necessary.

4) Find an application that would allow me to search the document using Boolean operators and parentheses.

Although Step 3 will be time consuming, I understand what I would be doing there.

However, I'm very unsure of myself with regard to step 4. A librarian suggested that I use Evernote, while an online search came up with a spreadsheet as the appropriate application for my purposes.

I have never used Evernote ( I don't even know what it is!), and am not familiar with spreadsheet operation, being more of a pencil and paper gradebook bloke.

I am not a tech person, have only a limited knowledge of information storage and retrieval, and would prefer not to use Microsoft or Google applications on my Linux desktop. I would also prefer not to have to buy anything.

Does anybody have any suggestions for step 4?

In addition, please don't hesitate to tell me if I am thinking about my YouTube searching problem in the wrong way and that I need to adopt a wholly different approach to solving it.

Excel doesn’t have to be the default.

With robust performance, excellent compatibility, and an ever-growing list of powerful features, Collabora Online Calc is a true open-source alternative.

Find out more about your next favourite spreadsheet solution.
collaboraonline.com/blog/why-c

In the almost 40 years I've been using Excel and a shorter time using LibreOffice I never realised until today that you could enable R1C1 notation in the settings.

This enables you to reference the current cell in formulas as RC and adjacent ones as R[-1]C[1] or RC[+1] etc.

It is a complete game changer!

Sigh.

I just found out about 'Spreadsheet Champions' - a first of a kind documentary about people competing in an official Microsoft competition I so want to watch this!!!

Might be difficult to find a place to stream it, any ideas, send them my way

theguardian.com/film/2025/aug/

The Guardian · Excelling in … Excel? Inside the high-stakes, secretive world of competitive spreadsheetingBy Giselle Au-Nhien Nguyen

Excel doesn’t have to be the default.

With robust performance, excellent compatibility, and an ever-growing list of powerful features, Collabora Online Calc is a true open-source alternative.

Find out more about your next favourite spreadsheet solution: collaboraonline.com/blog/why-c

The and Interest Group (eusprig.org) are pleased to announce that streaming tickets are now available for the EuSpRIG 2025 Annual Conference.

This year’s conference will be held on Thursday 3rd and Friday 4th July 2025 at the University of Greenwich, London.
To view the full programme and book your in-person or streaming place, visit:
eventbrite.co.uk/e/eusprig-202

Please share this announcement with colleagues and professional networks. @EuSpRIG

EventbriteEuSpRIG 2025 Annual Conference: Spreadsheet Productivity and RisksJoin us at EuSpRIG 2025 for insights on boosting your spreadsheet skills while managing risks - it's gonna be epic!