Terminology - I use spreadsheet for a document and sheet for a sheet within the document.
TL; DR
If several users must work on data, stemming from the same source, which is fastest:
- one Google Account for all users, one spreadsheet and different sheets for the users.
- one GA, different spreadsheets for the different users.
- different GAs for the differents users
Long version
Let's say I have a document with sheet A, containing a table with several columns - ID, Name, Shares etc.. I want to copy this data several times so that this data can be accessed by different people. On their view (be that in a sheet withing the same document or in another document) the data will be combined with other things. So if I have columns A, B, and C in the original source, they will be copied to columns A, B, and C in the users' view and the users will enter data / modify columns D, E, F, etc.. I have several options:
Create Sheets B, C, D in the same spreadsheet. This way person 1, 2 and 3 will use the same Google Account, the same document and only use different sheets.
Create new spreadsheets in the same Google Account and use Importrange to import the data. Each user works in a separate documents, but from Google's point of view it is the same user/account, logged from different devices and working on different documents.
Create separate Google Accounts, within them create spreadsheets and then import using Importrange.
As this is an In-house thing authorisations/permissions are not an issue, so it's not a problem if the users use the same Google Account. My purpose is to use the most lightweight option because the users will be using relatively cheap Android tablets, which do not possess much processing power or fast wifi cards. I have two things to consider:
- as I have tried to make things as automatic as possible I have a lot of index/match formulas, importrange formulas and validations plus a source table of more then 4500 rows. This may not sound a lot, but it definitely makes a difference on a tablet. So I guess putting too much logic in a single spreadsheet is not a good idea.
- having the same spreadsheet opened by many people is also not very good as updating changes, made by one user on the screens of other users takes (relatively) long. At the beginning I went with option 1 (one account, one document, many users with many spreadsheets), but the Google Drive app would constantly crash on the tablets.
Currently I use option 2 - one Google Account, different spreadsheets for the different users, which is much better. The main logic happens in one spreadsheet and each user opens a separate spreadsheet, where the data is copied. However, I don't know if it's a problem that one Google Account is used from several devices at the same time. Does it make sense to create separate accounts for the different users from performance point of view? This will certainly introduce a lot of overhead for me (keeping records of usernames/passwords, logging users etc.), but if it will be faster I would go with it.