PAPERWORK
MAGIC SHEET
LIGHT PLOT
Spot Sheet:
Master Sheet
Created in Google Sheets, this sheet is programmed to 4 separate spot sheets- 1 for each operator. It is done using the QUERY function!
NOTE: The master sheet format was created by LD Ryan Marsh. The function and organization was done by yours truly.
Spot Sheet:
Individual Sheet
This is where my Excel certification comes into play... even though this was created in Google Sheets. Fun fact: the query function is one of the most powerful functions in Google Sheets, and is one of very few that does not exist in Excel!
Curious about what the function is? I don't keep secrets!
=QUERY(Spot1Act1, "select * where C is not null")
NOTE: The individual spot sheet format was created by LD Ryan Marsh. The function and organization was done by yours truly.
LIGHTWRIGHT SAMPLES
