In a Google spreadsheet that performs a lot of intense calculation, does opening the sheet on multiple computers provide more CPU resources to spread out the computation load?
The sheet contains big lists (largely generated from data inputs) and mostly these functions: arrayformula, filter, if, sum, and consequential sum where 1 change at the beginning of the chain and propagate chain reactions and cause many other recalculations. But no RAND or NOW, and no importrange however there's multiple sheets in the same file referencing each other.
If data is uploaded from my PC and the status shows "All chances saved in Drive", can I close the tab and expect the other client PCs to perform the calculations, then return later to see the completed results? Or will my PC recalculate everything upon reopening (even without any new changes) the tab?
Does the account signed in on each computer matter? Same account or multiple different ones work better?
PS: One interesting observation I have is that while making "intense" changes on either PC, it can cause spikes in CPU load in the other PCs and sometimes cause them to become unresponsive or hang!?