TELGEMS

	A	B	D	E	H	J	K	M	N	P	Q	S	T	V	W	Y	Z	AB	AC	AE	AF	AH	AI	AK	AL	AN	AO	AQ	AR	AT	AU	AW	AX	AY	AZ	BB	BC	BE	BF	BJ	BK	BL	BN	BO
1		0		1	2		3		4		5		6		7		8		9		10		10		11		12		13		14				15		16		17	10		16
2		CONSTANTS		XML WINE PRESS	LADY CRAWLEY		THE CRUSHENATOR		INVENTORI AMOS		JACKIE'S WARMUP		JACKIE JOINER		JACKIE JOINER'S CURSEYS		BRITTA'S FILTERS		STAR SEARCH		COLUMBO		MRS. COLUMBO		TAG NOTARO		THE COMMISSIONER		DJ TANNER		HERMES EXPORTS			Lin-Manuel Platform Population			MARK DUNLAP		LAUNCHPAD	ARTIST AND REPETOIRE		PATCH		COLOR CODES
3		This is where we store values referenced by multiple scripts so they don't get too hard to update		Populate XML sheet with fresh XML file	1. Makes a map of all the subfolders in the uploaded music folder		Cleans up the empty folders left by Lady Crawley, deals with duplicates, unplayable files and trash, leaves flat stanley ready for inventori amos		Populate Flat Stanley sheet with inventory of Flat Stanley folder		Looks at the file names provided by INVENTORI AMOS and breaks them up to reveal the metadata encoded by LADY CRAWLEY		JACKIE'S JOIN script looks at every line of FLAT STANLEY, and the metadata broken out during JACKIE'S WARMUP, and prints either the matching XML ID, or "no match"		JACKIE will try to do another JOIN after trying to fix the unmatching XML and file definitions		Filters JACKIE JOINER sheet according to minimum track rating provided by THE COUNT		Tries to get a wikipedia link for each given artist		Columbo script normalizes tags, artist names and artist links (to do)		User adds to library of tag rules. MRS. COLUMBO's CLEAN AND PRESS produces a cleaned set of tags for each track		TAG NOTARO script produces final pool of tags to be assigned by THE COMMISIONER		Looks at each track's set of tags and chooses the first one that matches from tag notaro's approved list		Maps pasted listed of folders to tags applied by commissioner		Sort files into folders to be uploaded to platform and download as zip files (to be added)			Upload each of the folders provided by HERMES to THE PLATFORM			When the tracks have made it to the platform, click to mark this batch as loaded, so as not to load it again		Process for assembling and launching metadata to final destination	Review artists and links for accuracy and consistency. Run Script to write to a column		Process for adding songs without redoing whole library		Use these codes to label columns
4					2. Stamps each file with its parent folder names
5					3. Moves it out to the parent root
6	Uploaded music folder ID	1AFywh3tlwRrldM6xzd9ZPDtNv3P2s9jv	Next run starts here:	0		DONE	RUN GEM	FILE MANIFEST	1984	CONFIDENCE MANIFEST	1154	TRACK MANIFEST	0	UNJOINED TRACKS	737	FILTERED TRACK MANIFEST	1	Artists		APPROVED TAG MANIFEST	242	CLEANED TAGS FOR PICKUP	126	PLAYLIST TAG MANIFEST	76	COMMISSIONED TRACK MANIFEST	1	MAPPED FOLDER MANIFEST	0	HERMES' EXPORTABLE TRACK MANIFEST	1	FOLDER MANIFEST		31		Total files	1985	METADATA LINE ITEM MANIFEST	962		PATCH MANIFEST		column type:	color name
7	Playlists folder ID	1QVVIDPGDA9pRg7rRXO1bCCMdMudfPyzp	Last status update				queue folders once	Last status update			0	Percentage of joined files compared to total files	0.00%	Percentage of unjoined files compared to total	37%	Percentage of filtered tracks compared to total reported in XML	0%	23rd_century_BC				MRS. COLUMBO'S TAG TYPES	126	TAG NOTARO'S TAG TYPES	Count of tags	Commissioner's applied tags	Tracks	TAG	FOLDER	Percent complete	60200%	Populated in this batch	Contents	Folder/tag number	Complete on platform	matched files	1250	1. Artists table					Constant value	constant crimson
8	BRITTA'S minimum rating for inclusion	40	batches done				Delete empty folders	Files added last time		high	952			FLAT STANLEY files that are not joined to metadata (get metadata)		BRITTA'S minimum rating for inclusion	40	Alicia_Keys				character studies	5	character studies	4	#N/A	0	alternative	1	Delivered	602		alternative	1		no match	737	2. Years table					formula	formula orange
9			batches needed				queue folders once			medium	202			XML items that are not joined to FLAT STANLEY files (get files)				Andrew_W.K.				description	2	description	2		0	christmas	2	Error: Unexpected error while getting the method or property getFolderById on object DriveApp.	4		christmas	2		total files	1987	3. Ratings table					manifest	manifestive gold
10			Remaining batches				Delete empty folders			fallback								Aqualung				featured instruments	5	featured instruments	4		0	country	3	Already Exists	0		country	3		% delivered of matched	87%	4. Albums table					filter output	clean green
11			Remaining minutes				queue folders once											Arcade_Fire				fold into	55	fold into	19		0	cover	4				cover	4		% delivered of total	55%	5. Playlists table					script output	blue script
12			file extract status				Delete empty folders											Beastie_Boys				genre	10	genre	6		0	energetic	5				energetic	5		FALSE	894	6. Lyrics table					column headings	mood indigo
13			xml lines found	1640			crush junk extensions from root											Beck				origin	4	origin	4		0	guitars	6				guitars	6		TRUE	1091	7. Tags table					columns picked up by the next sheet	purple pickup
14							Find & isolate duplicates											Belle_and_Sebastian				trash tag	24	trash tag	24		0	instrumental	7				instrumental	7
15							Sister Evangelina's m4p roundup											Ben_Marwood				vibe	21	vibe	13		0	karaoke	8				karaoke	8
16							Use local software to decode m4p collection											Beta_Band									0	live	9				live	9
17							Upload newly liberated mp3s											Beyoncé									0	lol	10				lol	10
18							Delete M4ps											Billy_Joel									0	narrative	11				narrative	11
19							Delete duplicates											Biz_Markie									0	partymode	12				partymode	12
20							clear existing playlist folders											Black_Eyed_Peas									0	pop	13				pop	13
21																		Blue_Ivy_Carter									0	pretty	14				pretty	14
22																		Brendan_Benson									0	quiet	15				quiet	15
23																		Bright_Eyes									0	rap	16				rap	16
24																		Brittain_Ashford									0	rock	17				rock	17
25																		BS_2000									0	rough	18				rough	18
26																		Built_to_Spill									0	tag me	19				tag me	19
27																		Calvin_Harris									0	wordy	20				wordy	20
28																		Chemical_Brothers									0	soundtrack	21				soundtrack	21
29																		Childish_Gambino									0	musical	22				musical	22
30																		China_Drum									0	friendship	23				friendship	23
31																		Clap_Your_Hands_Say_Yeah									0	funk	24				funk	24
32																		Clipping									0	audience	25				audience	25
33																		Cold_Mountain_(soundtrack)									0	exclude	26				exclude	26
34																		Cold_War_Kids									0	instrumental-ish	27				instrumental-ish	27
35																		Coldplay									0	dance	28				dance	28
36																		Courtney_Barnett									0	piano	29				piano	29
37																		dale_north									0	sad	30				sad	30
38																		Dan_Band									0	woc	31				woc	31
39																		Dan_the_Automator									0
40																		Death_Cab_for_Cutie									0
41																		Decemberists									0
42																		Delays									0
43																		Donald_Glover									0
44																		Dr._Dog
45																		Dunno
46																		ElEl
47																		Ella_Fitzgerald
48																		Ellie_Goulding
49																		Enya
50																		Feist_(singer)
51																		Flaming_Lips
52																		Fleetwood_Mac
53																		Flight_of_the_Conchords
54																		Florence_and_the_Machine
55																		Franz_Ferdinand
56																		Free_Design
57																		Futurama
58																		Gillian_Welch
59																		Gnarls_Barkley
60																		Go!_Team
61																		Grandaddy
62																		Guided_by_Voices
63																		Hadestown_cast_recordings
64																		Head_and_the_Heart
65																		Hot_Club_of_Cowtown
66																		https://en.wikipedia.org/wiki/Eileen_Essell
67																		https://en.wikipedia.org/wiki/HTTP_404
68																		https://en.wikipedia.org/wiki/Twentynine_Palms,_California
69																		Interpol
70																		Islands
71																		James_Lavelle
72																		Janelle_Monáe
73																		Jim_Croce
74																		John_Maus
75																		Kacey_Musgraves
76																		Kanye_West
77																		Katamari_Damacy
78																		Kendrick_Lamar
79																		Kidz_Bop
80																		Killers
81																		Lady_Gaga
82																		Lana_Del_Rey
83																		Lion_King:_The_Gift
84																		Living_Sisters
85																		Lorde
86																		Lucius
87																		M._Ward
88																		Macklemore_&_Ryan_Lewis
89																		Major_scaled
90																		Manowar
91																		MC_Hawking
92																		Mercury_Rev
93																		Metric
94																		Mike_D
95																		Moana_(soundtrack)
96																		Modest_Mouse
97																		Monkees
98																		Mood_Elevator
99																		Muse
100																		Nada_Surf