[dhab]

Love it. I generally avoided excel when my previous role was a dev. Now, leading a team - I find it more useful as it's a little universe to add various computations (counts, min, max) of various sorts of data that I want to keep track across projects & create charts etc, create rapid UIs (project timelines etc) and easily change them when required, invite collaborators, use that to replace slides to drive meeting discussions

It's quite versatile. I had never considered this angle of using it to manage and sync with something external like Kubernetes here and love it.

I wish someone also solved the issue with excel around refactoring though - esp when cells are being used in formulas, if there was a "Find All References" or Cmd+SHIFT+F (global find) of elements used in formula (not their values) - it would step it up even more towards maintainability.

(I understand it buckles under huge datasets, but I believe that's really over-use of the tool)

[anner_]

Is this feature what you're looking for?

https://support.microsoft.com/en-us/office/display-the-relat...

[philips]

Today I learned.

Here is the doc for Google sheets: https://support.google.com/docs/answer/63175?hl=en&co=GENIE....

[rickdeckard]

> I wish someone also solved the issue with excel around refactoring though - esp when cells are being used in formulas, if there was a "Find All References" or Cmd+SHIFT+F (global find) of elements used in formula (not their values) - it would step it up even more towards maintainability.

I usually handle this in MS Excel by searching "in workbook" and "in formulas". Works even better when the elements are in a named cell which is referenced in formulas (i.e. "stat.infra.APIrequests" instead of "$A$5"), this way you can also globally change the element by reassigning the cell-name to another cell