{
	"auto_complete":
	{
		"selected_items":
		[
			[
				"badData.d",
				"badData.dups"
			],
			[
				"drop",
				"dropping.cols.from.SpotifyAdds"
			],
			[
				"posix",
				"posixCols"
			],
			[
				"min",
				"minReleaseDate"
			],
			[
				"comm",
				"commentary"
			],
			[
				"singl",
				"singleDT"
			],
			[
				"header",
				"header.is.row.number"
			],
			[
				"head",
				"header.is.row.number"
			],
			[
				"simpli",
				"simplify"
			],
			[
				"works",
				"worksheet.name"
			],
			[
				"work",
				"worksheet.name"
			],
			[
				"wos",
				"worksheet.name"
			],
			[
				"trace",
				"traceback"
			],
			[
				"release",
				"releaseDate"
			],
			[
				"art",
				"artist_labelID"
			],
			[
				"ex",
				"exists"
			],
			[
				"remote",
				"remotefile"
			],
			[
				"DT.",
				"DT.genreAndRelease"
			],
			[
				"DT.re",
				"DT.releaseDatesDB"
			],
			[
				"date",
				"dateCol"
			],
			[
				"fac",
				"factorCols"
			],
			[
				"DB",
				"DB.mini"
			],
			[
				"upc",
				"upcUsing"
			],
			[
				"All",
				"Allele_A"
			],
			[
				"DT.m",
				"DT.mat2"
			],
			[
				"D",
				"DB2"
			],
			[
				".SD",
				".DTSD"
			],
			[
				"Gro",
				"groups"
			],
			[
				"for",
				"formnumb"
			],
			[
				"byC",
				"byCols.dict"
			],
			[
				"XLS",
				"XLS.byCols"
			],
			[
				"XSL",
				"XLS.dateCol"
			],
			[
				"NA",
				"NAsynonyms"
			],
			[
				"class",
				"classType"
			],
			[
				"to",
				"toInteger"
			],
			[
				"streams",
				"StreamsReport"
			],
			[
				"ST",
				"StreamsReport"
			],
			[
				"Strea",
				"StreamsReport"
			],
			[
				"totalSpend.by.UP",
				"totalSpend.by.UPCcidDate"
			],
			[
				"total",
				"totalSpend.by.UPCcid"
			],
			[
				"tota",
				"totalUPCspend.bycid"
			],
			[
				".",
				".hasr"
			],
			[
				"recon",
				"reconcileReturns"
			],
			[
				"order",
				"orderHasAnAlbum"
			],
			[
				"pric",
				"Price"
			],
			[
				"pri",
				"prices"
			],
			[
				"cance",
				"canceled"
			],
			[
				"Tot",
				"TotUnits.by.ocp"
			],
			[
				"lun",
				"luniq.S_R"
			],
			[
				"bad",
				"badDataRow"
			],
			[
				"NOt",
				"NOTES"
			],
			[
				"To",
				"TotalUnits.by.cid.pid"
			],
			[
				"Tota",
				"TotalUnits.by.oid.pid"
			],
			[
				"file",
				"file.bad.orders"
			],
			[
				"wh",
				"whereAreTheMultipleRowsPerGroup"
			],
			[
				"cid",
				"cid.moreNegThanPos"
			],
			[
				"cus",
				"customer_identifier"
			],
			[
				"should",
				"should.be.unique.by.vID"
			],
			[
				"cos",
				"colsToCheck"
			],
			[
				"paste",
				"pasteQ"
			],
			[
				"no",
				"noDups"
			],
			[
				"cols",
				"colsToCheck"
			],
			[
				"by",
				"byCols"
			],
			[
				"not",
				"notUsed"
			],
			[
				"name",
				"nameCol"
			],
			[
				"pro",
				"product"
			],
			[
				"vend",
				"vendor_offer_code"
			],
			[
				"prod",
				"product_type_identifier"
			],
			[
				"releas",
				"releaseDate"
			],
			[
				"Db",
				"DB.raw"
			],
			[
				"curr",
				"currencyCols"
			],
			[
				"fore",
				"foreignThresh"
			],
			[
				"ry",
				"royaltyCols"
			],
			[
				"sale",
				"sale_return"
			],
			[
				"id.",
				"id.col.AS"
			],
			[
				"len",
				"len	Length"
			],
			[
				"DT",
				"DT.TEST"
			],
			[
				"make",
				"If.CantDrop.MakeNameUnique"
			],
			[
				"tri",
				"tripEq"
			],
			[
				"TB",
				"TBLS.itunes"
			],
			[
				"q.nm",
				"q.nm.rel"
			],
			[
				"re",
				"releaseDates"
			],
			[
				"QRE",
				"QRES.Export"
			],
			[
				"cust",
				"customer_price"
			],
			[
				"all",
				"allPossibleNumerics"
			],
			[
				"isNum",
				"isNumberAll"
			],
			[
				"roya",
				"royaltyCols"
			],
			[
				"dropp",
				"droppedCols"
			],
			[
				"une",
				"unevenColumns"
			],
			[
				"roy",
				"royaltyCols"
			],
			[
				"miss",
				"missingCols"
			],
			[
				"un",
				"unevenColumns"
			],
			[
				"use",
				"useProduction"
			],
			[
				"SR",
				"SR_levs"
			],
			[
				".R",
				".RObjName"
			],
			[
				"read",
				"readFUNC"
			],
			[
				"local",
				"localfile"
			],
			[
				"camp",
				"campCountry"
			],
			[
				"verb",
				"verboseMsg"
			],
			[
				"MA.s",
				"MA.sizes"
			],
			[
				"ele",
				"element_text"
			],
			[
				"addl.",
				"addl.cols"
			],
			[
				"addl",
				"addl"
			],
			[
				"add.",
				"addl.cols"
			],
			[
				"start",
				"startDate"
			],
			[
				"add",
				"addl"
			],
			[
				"ret",
				"retNumeric"
			],
			[
				"round",
				"roundBy"
			],
			[
				"Roun",
				"roundBy"
			],
			[
				"fo",
				"format"
			],
			[
				"time",
				"Time"
			],
			[
				"tx",
				"txform"
			],
			[
				"scal",
				"scale.0.1"
			],
			[
				"pdf",
				"pdfFile"
			],
			[
				"group",
				"groupOrder"
			],
			[
				"MA.al",
				"MA.alphas"
			],
			[
				"MA.",
				"MA.col"
			],
			[
				"MA",
				"MA.col"
			],
			[
				"MA.C",
				"MA.colors"
			],
			[
				"MA.c",
				"MA.col"
			],
			[
				"MA.col",
				"MA.colors"
			],
			[
				"shif",
				"shift.MA"
			],
			[
				"dots.",
				"dots.on"
			],
			[
				"Create",
				"createPlot"
			],
			[
				"chec",
				"checkUnique"
			],
			[
				"igno",
				"ingoreCase"
			],
			[
				"DT.n",
				"DT.nl.purged"
			],
			[
				"fact",
				"factor"
			]
		]
	},
	"buffers":
	[
	],
	"build_system": "",
	"command_palette":
	{
		"height": 240.0,
		"selected_items":
		[
			[
				"rap",
				"R Application Switch"
			],
			[
				"enh",
				"Set Syntax: Enhanced-R"
			],
			[
				"git push",
				"Git: Push"
			],
			[
				"git pull",
				"Git: Pull"
			],
			[
				"commi",
				"Git: Commit"
			],
			[
				"add",
				"Git: Add Current File"
			],
			[
				"rapp",
				"R Application Switch"
			],
			[
				"SQL",
				"Set Syntax: SQL"
			],
			[
				"r",
				"Set Syntax: R"
			],
			[
				"comm",
				"Git: Commit"
			],
			[
				"en",
				"Set Syntax: Enhanced-R"
			],
			[
				"com",
				"Git: Commit"
			],
			[
				"add fil",
				"Git: Add Current File"
			],
			[
				"e",
				"Set Syntax: Enhanced-R"
			],
			[
				"she",
				"SublimeREPL: Shell"
			],
			[
				"print",
				"Print Selection"
			],
			[
				"install",
				"Package Control: Install Package"
			],
			[
				"json",
				"Set Syntax: JSON"
			],
			[
				"ins",
				"Package Control: Install Package"
			],
			[
				"instal",
				"Package Control: Install Package"
			]
		],
		"width": 521.0
	},
	"console":
	{
		"height": 126.0,
		"history":
		[
			"import urllib.request,os; pf = 'Package Control.sublime-package'; ipp = sublime.installed_packages_path(); urllib.request.install_opener( urllib.request.build_opener( urllib.request.ProxyHandler()) ); open(os.path.join(ipp, pf), 'wb').write(urllib.request.urlopen( 'http://sublime.wbond.net/' + pf.replace(' ','%20')).read())"
		]
	},
	"distraction_free":
	{
		"menu_visible": true,
		"show_minimap": false,
		"show_open_files": false,
		"show_tabs": false,
		"side_bar_visible": false,
		"status_bar_visible": false
	},
	"file_history":
	[
		"/Users/rsaporta/git/orch/src/SpotifyAdds/! DTable Overview.r",
		"/Users/rsaporta/git/orch/src/SpotifyAdds/03_DT_from_Reshapes/DT.SpotifyMeta.Long/03b.DT.SpotifyMeta.Long.r",
		"/Users/rsaporta/git/orch/src/SpotifyAdds/02_DT_from_Merges/DB.SpotifyMeta/02.B. DB.SpotifyMeta.r",
		"/Users/rsaporta/git/orch/src/SpotifyAdds/02_DT_from_Merges/DB.all.countmeta/02.A DB.all.countmeta.r",
		"/Users/rsaporta/git/orch/src/SpotifyAdds/01_DATA_INGESTION/DB.raw/01.Ca Raw_Spotify Pull Data - QRY PARAMS.r",
		"/Users/rsaporta/git/orch/src/SpotifyAdds/01_DATA_INGESTION/DB.raw/01.Cc DB_raw Column Cleanup.r",
		"/Users/rsaporta/git/orch/src/SpotifyAdds/01_DATA_INGESTION/DB.raw/01.Cb Raw_Spotify Pull Data - QRY Execution.r",
		"/Users/rsaporta/git/orch/src/SpotifyAdds/SpotifyAdds - Specials.r",
		"/Users/rsaporta/git/orch/src/SpotifyAdds/01_DATA_INGESTION/SpotifyAdds/01.Ab SpotifyAdds - Clean GDoc Report.r",
		"/Users/rsaporta/git/orch/src/SpotifyAdds/01_DATA_INGESTION/DB.all.count/01.Ec. DB.all.count - CLEAN.r",
		"/Users/rsaporta/git/orch/src/SpotifyAdds/04_Aggregations & Modifications/04.Da.r",
		"/Users/rsaporta/git/orch/src/SpotifyAdds/01_DATA_INGESTION/DB.all.count/01.Eb. DB.all.count - QRY EXECUTION.r",
		"/Users/rsaporta/git/orch/src/SpotifyAdds/01_DATA_INGESTION/DB.all.count/01.Ea. DB.all.count - QRY PARAMS.r",
		"/Users/rsaporta/git/orch/src/SpotifyAdds/00_Setup/00.01 SpotifyAdds Setup.r",
		"/Users/rsaporta/git/orch/src/SpotifyAdds/! GO.r",
		"/Users/rsaporta/git/orch/src/SpotifyAdds/0 Redshift Address.txt",
		"/Users/rsaporta/git/orch/src/SpotifyAdds/05_ANALYSIS/AvsB.r",
		"/Users/rsaporta/git/orch/src/SpotifyAdds/00_Setup/00.02 Tables Creating.r",
		"/Users/rsaporta/git/orch/src/SpotifyAdds/01_DATA_INGESTION/SpotifyAdds/01.Aa SpotifyAdds - Load  GDoc Report.r",
		"/Users/rsaporta/git/orch/src/SpotifyAdds/01_DATA_INGESTION/DB.all.meta/01.Da. Pull and Clean DB.all.meta in one step.r",
		"/Users/rsaporta/git/orch/src/SpotifyAdds/01_DATA_INGESTION/DB.Meta/01.Ba Meta Pull Data.r",
		"/tmp/subl stdin 2sWNuo.txt",
		"/Users/rsaporta/git/misc/rscripts/utils/googledocs.r",
		"/tmp/subl stdin sFFTn1.txt",
		"/tmp/subl stdin ZbDtur.txt",
		"/tmp/subl stdin hxBITt.txt",
		"/tmp/subl stdin U4x4dI.txt",
		"/tmp/subl stdin jOErwI.txt",
		"/Users/rsaporta/git/orch/src/SpotifyAdds/heat plot.r",
		"/Users/rsaporta/git/orch/src/SpotifyAdds/04 Aggregate.r",
		"/Users/rsaporta/git/orch/src/SpotifyAdds/03b DB_raw.r",
		"/Users/rsaporta/git/orch/src/SpotifyAdds/03a Clean Import",
		"/Users/rsaporta/git/orch/src/SpotifyAdds/02d QRY Local Import.r",
		"/Users/rsaporta/git/orch/src/SpotifyAdds/02b QRY Execution.r",
		"/Users/rsaporta/git/orch/src/SpotifyAdds/02a QRY PARAMS.r",
		"/Users/rsaporta/git/orch/src/SpotifyAdds/01e Merge Streaming with ReleaseGenre.r",
		"/Users/rsaporta/git/orch/src/SpotifyAdds/01b Pull Release Info.r",
		"/Users/rsaporta/git/orch/src/SpotifyAdds/01 Load GDoc Report.r",
		"/Users/rsaporta/git/orch/src/SpotifyAdds/# 000 ALL R BOX.r",
		"/Users/rsaporta/git/orch/src/SpotifyAdds/01d Clean ReleaseGenre DT.r",
		"/Users/rsaporta/git/orch/src/SpotifyAdds/01c Bring Release Data Local.r",
		"/Users/rsaporta/git/orch/src/SpotifyAdds/00 SpotifyAdds Setup.r",
		"/Users/rsaporta/git/orch/src/SpotifyAdds/col types.r",
		"/Users/rsaporta/git/orch/src/SpotifyAdds/02c QRY Export.r",
		"/Users/rsaporta/git/orch/src/SomLivre/QUESTIONS",
		"/Users/rsaporta/git/orch/src/SpotifyAdds/01b Pull Release Info",
		"/Users/rsaporta/git/orch/src/SpotifyAdds/release & genre query.sql",
		"/Users/rsaporta/git/orch/src/SomLivre/20 Create SomLivre Plots.r",
		"/Users/rsaporta/git/misc/rscripts/Benchmarks/untitled",
		"/tmp/subl stdin elw9BU.txt",
		"/Users/rsaporta/git/StackExchange/genetic recoding.r",
		"/Users/rsaporta/git/StackExchange/dropping list elements in place",
		"/Users/rsaporta/git/orch/src/SpotifyAdds/ERRORS in data.txt",
		"/Users/rsaporta/git/orch/src/SpotifyAdds/00b SpotifyAdds_Column_Info.r",
		"/Users/rsaporta/git/orch/src/SomLivre/02a2 Query Execution on RBox.r",
		"/Users/rsaporta/git/orch/src/SpotifyAdds/02 QRY PARAMS.r",
		"/Users/rsaporta/git/orch/src/SomLivre/02b Export To Local Machine.r",
		"/Users/rsaporta/Desktop/difference between empowering and delegation is wr",
		"/Users/rsaporta/git/orch/src/SpotifyAdds/02d QRY Local Import.r ",
		"/Users/rsaporta/git/orch/src/SpotifyAdds/02b QRY Execution",
		"/Users/rsaporta/git/orch/src/SomLivre/02a1 Query Params.r",
		"/Users/rsaporta/git/data.table/bug or FR? - negating NAs.r",
		"/Users/rsaporta/gitData/orch/data/SpotifyAdds/Weekly US Streaming Report.csv",
		"/Users/rsaporta/git/StackExchange/factor question (mine).R",
		"/Users/rsaporta/git/misc/rscripts/utils/dropDuplicateColumns_.R",
		"/Users/rsaporta/git/orch/src/SomLivre/03b Clean ReleaseDates",
		"/Users/rsaporta/git/orch/src/SomLivre/scrap (checking different itunes tables).R",
		"/Users/rsaporta/git/orch/src/SomLivre/02 Query.r",
		"/Users/rsaporta/git/StackExchange/merge on cut.R",
		"/Users/rsaporta/git/orch/src/SomLivre/02c Import to Local Machine.r",
		"/Users/rsaporta/git/misc/rscripts/Benchmarks/Saving Methods",
		"/Users/rsaporta/git/orch/unix home directory",
		"/Users/rsaporta/Desktop/forecast_ma bag",
		"/Users/rsaporta/git/misc/rscripts/utils/reproduce instructions.r",
		"/Users/rsaporta/git/orch/src/Pricing/01b Cleanup after Excel Import",
		"/Users/rsaporta/git/misc/rscripts/utils/transformations.R",
		"/Users/rsaporta/git/orch/src/Pricing/02 PricingES.r",
		"/Users/rsaporta/git/orch/src/Pricing/02 PricingES",
		"/Users/rsaporta/git/StackExchange/merge with suffix.r",
		"/Users/rsaporta/git/StackExchange/Excel Hidden Data.r",
		"/Users/rsaporta/git/orch/src/MktingReport/00 Setup.r",
		"/Users/rsaporta/git/orch/src/MktingReport/01 FB Report Load & Clean.r",
		"/Users/rsaporta/git/orch/src/Intro/00 OLD Intro.r",
		"/Users/rsaporta/git/orch/src/Intro/00 Intro.r",
		"/Users/rsaporta/Dropbox/rutgers mbs/Classes/137-502 Communication/MBS \"All aboute me\" Presentation.txt",
		"/Users/rsaporta/Desktop/Presenting.rtf",
		"/Users/rsaporta/Desktop/What are Six things that you would associate with",
		"/Users/rsaporta/Desktop/Thunderbolt Doc",
		"/Users/rsaporta/git/orch/src/MktingReport/02 FB Aggregate.r",
		"/Users/rsaporta/gitData/orch/data/dicts/fbAddsReportColNames.dict.csv",
		"/Users/rsaporta/gitData/orch/data/dicts/00 Setup New.r",
		"/Users/rsaporta/git/orch/src/MktingReport/getKeyVals.r",
		"/Users/rsaporta/git/orch/src/MktingReport/Funcs.r",
		"/Users/rsaporta/git/orch/streamdl/data/1ReadTables.r",
		"/Users/rsaporta/git/orch/src/Intro/00_new Intro.r",
		"/Users/rsaporta/Library/Application Support/Sublime Text 3/Packages/User/Preferences.sublime-settings",
		"/Users/rsaporta/git/orch/src/UnquoteJSON.r",
		"/Users/rsaporta/Library/Application Support/Sublime Text 3/Packages/Default/Preferences.sublime-settings",
		"/Users/rsaporta/git/orch/src/Intro/Sales Qry.r",
		"/Users/rsaporta/Desktop/trains.txt",
		"/Users/rsaporta/git/misc/rscripts/learning R/data.table/Value with Grep",
		"/Users/rsaporta/git/data.table bugs/as_data_table with NULL.r",
		"/Users/rsaporta/git/misc/rscripts/utils/SetupNewInstall.r"
	],
	"find":
	{
		"height": 35.0
	},
	"find_in_files":
	{
		"height": 93.0,
		"where_history":
		[
			""
		]
	},
	"find_state":
	{
		"case_sensitive": false,
		"find_history":
		[
			"fix",
			"list",
			"fix",
			"DB.raw.RAW",
			"download_datetime",
			"NAsynonymClean_",
			"DB.all.meta",
			"(SpotifyAdds|DB\\.Meta|DB\\.raw)",
			" - 400",
			"400",
			"(SpotifyAdds|DB\\.Meta|DB\\.raw)",
			"SpotifyAdds OR DB.Meta OR DB.raw",
			"getGenresForAllupcs",
			"sheets.con",
			"file.release",
			"hour",
			"date",
			"bring",
			"qry_t",
			"SomLivre",
			"StreamsReport",
			"genre",
			"shift",
			"Count",
			"888003155510",
			"hasr",
			"id.",
			".D(",
			".hasr",
			"quote",
			"cols",
			"maxLineWidth",
			"DB.agg",
			"colToCheck",
			"duplicate",
			"fullN",
			"cols[[i]]",
			"cols[[i]] ",
			"DT.releaseDates",
			"ln",
			"royaltyCols",
			",",
			"d2 <- QRES.Export[[2]]",
			"release",
			"project",
			"will be created in folder",
			".DATE.COLS",
			"date",
			"datee",
			"date",
			"collapse",
			"pasteR",
			"paste",
			"pasteR",
			"appl",
			"lappl",
			"scale_x",
			"date",
			"preRelDate",
			"MA.if",
			"dt2",
			"value.MA",
			"cr",
			"makeQry",
			"Excel",
			"DT.l[[nm]]",
			"grep",
			"DT.list",
			"excel",
			"createPlot",
			"Plots",
			"verboseQry",
			"make",
			"data.table",
			"fbRaw.",
			"MktingReport",
			"Gender",
			"fb.agg.demog.simple",
			"Gender",
			"l",
			"includeOriginalInReturn",
			"reach",
			"\"] ",
			"nbs",
			"FOLDERS",
			"sublime",
			"getProjectsFromFolders",
			"2",
			"3"
		],
		"highlight": true,
		"in_selection": false,
		"preserve_case": false,
		"regex": false,
		"replace_history":
		[
			"con",
			"StreamsReport",
			"Cnt",
			"",
			"DT.agg",
			"colsToCheck",
			"DT",
			"projName",
			"date.cols",
			"my.dt",
			"DT.",
			"DT.nestedlist",
			"",
			"Pricing",
			"Campaign",
			"fb.agg.age",
			"Campaign",
			"cols",
			"originalIncludedInReturn",
			"3",
			"2"
		],
		"reverse": false,
		"show_context": true,
		"use_buffer2": true,
		"whole_word": false,
		"wrap": true
	},
	"groups":
	[
		{
			"sheets":
			[
			]
		}
	],
	"incremental_find":
	{
		"height": 23.0
	},
	"input":
	{
		"height": 0.0
	},
	"layout":
	{
		"cells":
		[
			[
				0,
				0,
				1,
				1
			]
		],
		"cols":
		[
			0.0,
			1.0
		],
		"rows":
		[
			0.0,
			1.0
		]
	},
	"menu_visible": true,
	"output.find_results":
	{
		"height": 0.0
	},
	"output.git-commit":
	{
		"height": 100.0
	},
	"output.git-pull":
	{
		"height": 94.0
	},
	"output.git-push":
	{
		"height": 94.0
	},
	"project": "SpotifyAdds.sublime-project",
	"replace":
	{
		"height": 64.0
	},
	"save_all_on_build": true,
	"select_file":
	{
		"height": 0.0,
		"selected_items":
		[
			[
				"r",
				"03b DB_raw.r"
			]
		],
		"width": 0.0
	},
	"select_project":
	{
		"height": 0.0,
		"selected_items":
		[
		],
		"width": 0.0
	},
	"select_symbol":
	{
		"height": 47.0,
		"selected_items":
		[
		],
		"width": 392.0
	},
	"settings":
	{
	},
	"show_minimap": false,
	"show_open_files": false,
	"show_tabs": true,
	"side_bar_visible": true,
	"side_bar_width": 213.0,
	"status_bar_visible": true,
	"template_settings":
	{
	}
}