The Google Sheets. The work of the Sweater Workshop

Form of introduction of works:

Automotive categories
Protection against unauthorized data entry
lists with the following exclusion of previously selected elements
Additional mechanisms with protection against incorrect input
Formation of the input database

Intermediate Monthly Analysis:

Use multiple sampling parameters by adapting Query requests
The “floating” final line
Automotive size column width

Importing data from DropBox:

Import of data from the CSV file
Conversion/Integration of data into a common database

The database:

Correction of the database by script request
Lights of the last line when switching to the database list
Lighting of the active line on the selected cell

The Final Analysis:

setting time criteria for the sample: Week / Month / Year / Date ( with - by )
Checkout / Checkout
Combined set of parameters (scripts)
Cleaning of sampling parameters (scripts)

Implementation of CRM:

the possibility of changing the parameters of the script by the user.Conditional mode Administrator/User

Auto ( hiding / displaying ) of the lists

User Menu

Full list of scripts on the 5th screenshot