This is a very simple question. Excel calls their individual documents Workbooks, and their "tabs" sheets. Google has a naming problem with their products, and makes this confusing.
I have a slow workBOOK. With 17 Columns by 5000 rows called jobs.
MY QUESTION My question is if complexity of a sheet is determined by the individual .gsheet regardless of tabs, or if each tab is treated as a brand new sheet.
CONTEXT: I have Split my data into 4+ workBooks in an attempt to simulate a database and import spreadsheets when the are relevant. I work in Construction, so each spread sheet manages:
- Main Sheet shows all jobs that exist or could exist
- repeating jobs
- List employee / Vendor information
- Addresses (there are 10k) ; probably a fraction of that actually active.
This is a simplified explanation of what each workbook does, BUT some work books do more than other, For exmaple, the Adresses one also tell us:
- Who are customers are, how to bill them
- What our agreed upon price is for a given task
- a contact list akin to what one might find on their phone with titles emails, addresses, and phone#'s
- A sub category of address that lists blue prints, their sqft, and what codes the builder uses to identify them.
Again my question is if combining all this information into a multitude of "sheets" is faster than having several work books that import eachothers data Faster, meaning less lag.