6 ms·

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 comput

by dhab 2y ago

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_ 2y ago
Is this feature what you're looking for? https://support.microsoft.com/en-us/office/display-the-relationships-between-formulas-and-cells-a59bef2b-3701-46bf-8ff1-d3518771d507 https://support.microsoft.com/en-us/office/display-the-relat...
- philips 2y ago
  Today I learned. Here is the doc for Google sheets: https://support.google.com/docs/answer/63175?hl=en&co=GENIE.Platform%3DDesktop https://support.google.com/docs/answer/63175?hl=en&co=GENIE....
rickdeckard 2y ago
> 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

by dhab 2y ago

anner_ 2y ago

Is this feature what you're looking for? https://support.microsoft.com/en-us/office/display-the-relationships-between-formulas-and-cells-a59bef2b-3701-46bf-8ff1-d3518771d507 https://support.microsoft.com/en-us/office/display-the-relat...

philips 2y ago
Today I learned. Here is the doc for Google sheets: https://support.google.com/docs/answer/63175?hl=en&co=GENIE.Platform%3DDesktop https://support.google.com/docs/answer/63175?hl=en&co=GENIE....

rickdeckard 2y ago

> 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