Hello!

I am looking for recent advances in Windows/Web automation that can do things like:
1) automate both high and low level Windows and its apps
2) perform large data analysis
3) integrate with Excel and wider Office
4) automate Web/Chrome/Edge

However, I have the following requirements:
1) no installation needed, no admin rights needed, no executables that may be admin blocked
2) fully compatibility/stability with latest Windows
3) easy syntax (without having to write 100 lines of code just to detect and click a button)
4) no Powershell, no cmd, no WSCRIPT, no AHK (as it requires executables and may not have good Windows integration)
5) Power Automate is okay but ideally would like something else as it is not standard with every Windows
6) if it can run on virtual machine or cloud, it would be ideal

Do the above ring any bell? I suppose I can install Python and do all the above but again would prefer no installation.
Thanks!

Hello!

Do you know any formula navigator for Excel that is free? Similar to Arixcel where you click on each references of a formula to navigate to them?

It seems several people have built their on in VBA but can't find anything to leverage nor I can easily build it in an evening!

Thanks!

Hello!

Are you familiar with kubernetes/containers?

I have left behind regarding these technologies and wonder if you can briefly explain how you understand its purposes and use cases?

I remember decades ago there was the concept of 'sandbox' where basically you would be able to run executables locally in a way that is isolated from the OS for security purposes. E.g. if you didn't know if something is a virus, you would run it in a sandbox so that whatever it reads/writes will be emulated locally instead of messing the OS.

Then there was the concept of 'portable apps' which still exists and its purpose was that you can migrate the app to different machines without having to install it and this would ensure that whatever permanent changes you make to the app such as choosing particular Options (i.e. dark theme) would be transferred or maintained within the app.

Is it accurate to say kubernetes/containers are kind of these concepts? i.e. a sandbox or an sandboxed executable or a portable executable?

Regarding its purpose, is it instead of security or maybe in addition to security, some kind of repeatability and efficiency?

• I understand efficiency as 'in case the executable would mess the OS resources if run unrestricted e.g. a very CPU consuming executable'
• I understand repeatability as 'in case the executable would be incompatible with the OS e.g. a Linux executable running in a Windows environment'

I read/watched some kubernetes/containers explanations but they were not making much sense :/ and especially how different they are from sandboxes and portable apps.

Thanks!