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)
https://support.microsoft.com/en-us/office/display-the-relat...
Here is the doc for Google sheets: https://support.google.com/docs/answer/63175?hl=en&co=GENIE....
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
Spreadsheets are underused as an UI. Every time you embed a table component in your app you probably wouldn’t complain about it being one.
As a programming interface, that makes spreadsheets deceptively powerful. But as a UI were you need to have control over how the user interacts, that makes spreadsheets incredibly painful to integrate.
Source: myself. I worked on a project around 20 years ago which integrated a spreadsheet into its UI and the number of ways people would break the application each month was mind boggling.
If you have a shared spreadsheet in one of these systems, surely there must be some way to lock down some rows and columns, right? Then, the spreadsheet simply becomes a program where intermediary values are displayed and can be read. It seems really convenient.
At some point, something invariably gets missed and someone else finds a way to tamper with it.
Bear in mind that the “tamperers” are never doing so maliciously. They’re just trying to do their job too. But when you have a UI that allows for unlimited abstractions, those “tamperers” will dream up a new way to represent their needs without realising that they’re breaking someone else’s workflow.
I've used it as the best UI for Accountants, Lawyers and other people that are famous for being afraid of technology. It's a great "bridge between "the system" and the people who want to get something from it.
Excel was also written by some random programmer. But the code that does anything complicated was at least used by everybody in my field, so if there’s a hidden bug in there, at least the responsibility is diffuse. And the code written by me or by someone at my office… well, you can at least see what every cell does.
I’m a big fan of spreadsheets for “getting shit done”.
But if you’re building a UI for other people to consume, you’ll quickly find that they’d break it in all manner of exotic ways.
This is why CRUD solutions exist. Sometimes you want the relational bookkeeping but with a more restricted UI. In those type of scenarios even MS Access is a better option than Excel (for example).
Excel pros (I am none) can do quite some nice tools on top of Excel.
Excel runs the world ...
I’ve already addressed this and the problems with that approach.
> Excel pros (I am none) can do quite some nice tools on top of Excel.
As I explained in my OP, I was one of them.
> Excel runs the world ...
I agree. I never claimed otherwise. So I don’t really understand your point here if it’s not to make a strawman argument.
"Replacing YAML with spreadsheets has always been our mission as a company, and we will continue to do so."
The python scripts were deployed PaaS style into a Kubernetes cluster.
If only we'd had the insight to manage our control plane via Excel also, we'd probably be squillionaires by now. :P
(joking in case people didn't look - 2 commits 5 years ago)
For a different sort of person, but there's some rather old efforts to expose Kubernetes & Etcd under FUSE , which would also be neat direct access. https://github.com/opencredo/KubeFuse https://github.com/cstavr/etcdfs
And since I was curious, there's also a spreadsheet to FUSE too, https://github.com/mk270/xls-fuse
As far as I know, the only 3d representation of Kubernetes is KubeDoom, https://github.com/storax/kubedoom
I reckon majority of operations do not strictly need distributed nature of Kubernetes and for many SMBs, which comfortably fit into one or two rack units plus maybe a storage shelf, that's even counterproductive.
However, Kubernetes, being resource virtualization platform, offers some very nice isolation and admin access control capabilities. I guess that's the power of kubernetes for most orgs.
Obligatory Doom mention
(Or more like putting the manager back in the management plane.)
What do you mean our auto scaling strategy stopped working when we switched to Office 360?