{ "auto_complete": { "selected_items": [ [ "ass", "assign.to" ], [ "color", "colors.sc" ], [ "countr", "country_code" ], [ "time", "times_info" ], [ "resu", "result_string" ], [ "vlin", "vline.color" ], [ "vline.", "vline.alpha" ], [ "vline", "vline.value" ], [ "face", "facet_scales" ], [ "alp", "alpha_dot" ], [ "label_a", "label_act" ], [ "SE_", "SE_USERS" ], [ "curr", "currency" ], [ "curre", "currency_rate" ], [ "curren", "currency_code" ], [ "smo", "smooth" ], [ "smoot", "smooth_se" ], [ "country", "country_using" ], [ "DT.month.per", "DT.monthly_cast.perc_incr" ], [ "cols.", "cols.monthly_cast_perc" ], [ "DT.s", "DT.monthly_cast" ], [ "total_", "total_streams" ], [ "lae", "labelcolor" ], [ "strea", "streams_scaled_MA3" ], [ "perce", "percent.y" ], [ "sre", "streams_as_perc_of_max" ], [ "top", "top50" ], [ "count", "countries_using" ], [ "totl", "total_streams" ], [ "warning", "warningCols" ], [ "y", "ylab" ], [ "total", "total_streams" ], [ "DT.RED_", "DT.RED_Split_Spotify.an" ], [ "scal", "scale.func" ], [ "uni", "units_perc" ], [ "accoun", "accounting_month" ], [ "cols", "colsToPull.red_split" ], [ "colsT", "colsToPull" ], [ "aggregate", "aggregateDT" ], [ "aggre", "aggregateDT" ], [ "acco", "accounting_month" ], [ "DT.mon", "DT.monthly" ], [ "i.n", "is.null" ], [ "DT.nms", "DT.nms.bak" ], [ "month", "monthly_as_perc_of_orchard" ], [ "orch", "Orchard_Total_Streams" ], [ "spo", "spotify_tracks" ], [ "avG", "avg_monthly_streams" ], [ "from", "fromdate" ], [ "tota", "total_streams" ], [ "countyr", "country_code" ], [ "DT.", "DT.top" ], [ "tot", "total_streams" ], [ "ret", "ret_json" ], [ "nrow", "nrowThresh" ], [ "Trac", "track_name" ], [ "album", "album_name" ], [ "error", "errors_fixing" ], [ "track", "tracks.flat" ], [ "coun", "country" ], [ "dates", "dates.avail" ], [ "notif", "notifyIfError" ], [ "select", "SelectAndUnload" ], [ "not", "notify" ], [ "exist", "existing_tables" ], [ "verbo", "verboseMsg" ], [ "metho", "method_used_for_forecasting" ], [ "Sys", "Sys.time" ], [ "DTs", "DTsToXLSX" ], [ "numeri", "numeric.format" ], [ "store_n", "store_name_short" ], [ "GP", "GPU_Est_MA" ], [ "GPU_Es", "GPU_Est_Fore" ], [ "ver", "verbose" ], [ "GPU_EST", "GPU_Est_Fore" ], [ "back", "BackUpOrRestore" ], [ "FAS", "FALSE" ], [ "DT.t", "DT.transacs" ], [ "ski", "skip.select.in_Denormalizing" ], [ "rc.", "rc.fact" ], [ "last", "lastProcessedDate" ], [ "pro", "processeddaytime" ], [ "fa.", "fa_rbound.manual" ], [ "tran", "transac_typeid" ], [ "DT.v", "DT.validate" ], [ "tra", "transac_typeid" ], [ "un", "units.aggd" ], [ "kc", "kc" ], [ "colsTo", "colsToAgg" ], [ "fact_a", "fact_analytics_error" ], [ "maxD", "maxDate" ], [ "maxDA", "maxDayIdToCheck" ], [ "view", "viewsDependedOn" ], [ "verbose", "verbose" ], [ "verbos", "verboseQry" ], [ "clus", "cluster" ], [ "cluster", "cluster.in" ], [ "cluster.", "cluster.out" ], [ "sql", "sqlFileToQry" ], [ "viw", "views" ], [ "is", "isDependedOn" ], [ "qry", "qrys.create" ], [ "header.", "header.left" ], [ "header", "header.right" ], [ "heade", "header.left" ], [ "nch", "nchar.left" ], [ "sch", "schema" ], [ "exi", "existing_tables" ], [ "tbl.f", "tbl.final" ], [ "skip", "skip.GPU" ], [ "roy", "royalty" ], [ "a", "ancillaryline" ], [ "DT.fore", "DT.forecasts.full" ], [ "add", "addStoreName.storeid_" ], [ "DT.acc.che", "DT.acc.check.failed" ], [ "store", "storeColsToBringIn" ], [ "DT.ac", "DT.acc.check.187" ], [ "atta", "attachments" ], [ "smt", "smtp.settings" ], [ "Rev", "Revenue" ], [ "the", "theorchard.com" ], [ "tbl", "tbls_to_update" ], [ "force", "force.views" ], [ "verb", "verbose" ], [ "trans", "transactiontypeid" ], [ "act", "activity_date" ], [ "DT.3", "DT.355.acc" ], [ "accounting", "accountingperiodid" ] ] }, "buffers": [ ], "build_system": "", "build_system_choices": [ ], "build_varint": "", "command_palette": { "height": 287.0, "last_filter": "", "selected_items": [ [ "path", "File: Copy Path" ], [ "rap", "R Application Switch" ], [ "enh", "Set Syntax: Enhanced-R" ], [ "ren", "File: Rename" ], [ "wor", "Word Wrap: Toggle" ], [ "push", "Git: Push" ], [ "qui", "Git: Quick Commit Current File" ], [ "ra", "R Application Switch" ], [ "word", "Word Wrap: Toggle" ], [ "r", "R Application Switch" ], [ "prett", "Pretty JSON: Format (Pretty Print) JSON" ], [ "js", "JSLint" ], [ "json", "Set Syntax: JSON" ], [ "qi", "Git: Quick Commit" ], [ "pus", "Git: Push Current Branch" ], [ "move", "File: Move" ], [ "jslin", "JSLint" ], [ "insta", "Package Control: Install Package" ], [ "pretty", "Pretty JSON: Format (Pretty Print) JSON" ], [ "reinde", "JSON Reindent: reindent file or selection" ], [ "inden", "Indentation: Reindent Lines" ], [ "get package", "Package Control: Install Package" ], [ "package", "Preferences: Browse Packages" ], [ "enab", "Package Control: Enable Package" ], [ "ite", "Indentation: Convert to Spaces" ], [ "enha", "Set Syntax: Enhanced-R" ], [ "pull", "Git: Pull" ], [ "pul", "Git: Pull" ], [ "quic", "Git: Quick Commit Current File" ], [ "d", "File: Delete" ], [ "comcur", "Git: Quick Commit Current File" ], [ "w", "Word Wrap: Toggle" ], [ "add cu", "Git: Add Current File" ], [ "git chec", "Git: Checkout" ], [ "git check", "Git: Checkout" ], [ "syn shel", "Set Syntax: Shell Script (Bash)" ], [ "synt she", "Set Syntax: Shell Script (Bash)" ], [ "quick", "Git: Quick Commit Current File" ], [ "git ch", "Git: Checkout" ], [ "git stas", "Git: Pop Stash" ], [ "git sta", "Git: Stash" ], [ "sql", "Set Syntax: SQL" ], [ "add", "Git: Add Current File" ], [ "rapp", "R Application Switch" ], [ "git cur", "Git: Quick Commit Current File" ], [ "pat", "File: Copy Path" ], [ "quci", "Git: Quick Commit Current File" ], [ "ush", "SublimeREPL: Shell" ], [ "dele", "File: Delete" ], [ "del", "File: Delete" ], [ "psuh", "Git: Push" ], [ "puh", "Git: Push" ], [ "disable pack", "Package Control: Disable Package" ], [ "disa", "Package Control: Disable Package" ], [ "reve", "File: Reveal" ], [ "check", "Git: Checkout New Branch" ], [ "git com cur", "Git: Quick Commit Current File" ], [ "curr", "Git: Add Current File" ], [ "git comcu", "Git: Quick Commit Current File" ], [ "name", "File: Copy Name" ], [ "qucur", "Git: Quick Commit Current File" ], [ "qu", "Git: Quick Commit Current File" ], [ "com cu", "Git: Quick Commit Current File" ], [ "addcu", "Git: Add Current File" ], [ "quicad", "Git: Quick Add" ], [ "PAT", "File: Copy Path" ], [ "git comm", "Git: Commit" ], [ "synshe", "Set Syntax: Shell Script (Bash)" ], [ "shel", "SublimeREPL: Shell" ], [ "fil", "File: Copy Name" ], [ "nh", "Set Syntax: HTML" ], [ "nam", "File: Copy Name" ], [ "fin", "File: Copy Name" ], [ "comm", "Git: Commit" ], [ "checkou", "Git: Checkout New Branch" ], [ "filena", "File: Copy Name" ], [ "com file", "Git: Quick Commit Current File" ], [ "quc", "Git: Quick Commit Current File" ], [ "qucomf", "Git: Quick Commit Current File" ], [ "comf", "Git: Quick Commit Current File" ], [ "wo", "Word Wrap: Toggle" ], [ "qucf", "Git: Quick Commit Current File" ], [ "commfil", "Git: Quick Commit Current File" ], [ "filen", "File: Copy Name" ], [ "branch", "Git: Checkout New Branch" ], [ "new br", "Git: Checkout New Branch" ], [ "branc", "Git: Checkout New Branch" ], [ "copy", "File: Copy Name" ], [ "rena", "File: Rename" ], [ "RENA", "File: Rename" ], [ "ADD", "Git: Add Current File" ], [ "copnam", "File: Copy Name" ], [ "q", "Git: Quick Add" ], [ "renam", "File: Rename" ], [ "rep", "SublimeREPL: PHP" ], [ "enhg", "BracketHighlighter: Select Next Attribute (right)" ], [ "en", "Set Syntax: Enhanced-R" ], [ "WOR", "Word Wrap: Toggle" ], [ "pu", "Git: Push" ], [ "cop", "File: Copy Name" ], [ "delet", "File: Delete" ], [ "RA", "R Application Switch" ], [ "REV", "File: Reveal" ], [ "COPNA", "File: Copy Name" ], [ "ENH", "Set Syntax: Enhanced-R" ], [ "QUIC", "Git: Quick Commit" ], [ "co", "File: Copy Name" ], [ "COP", "File: Copy Name" ], [ "oath", "File: Copy Path" ], [ "copy na", "File: Copy Name" ], [ "git pu", "Git: Pull" ], [ "diff", "Git: Diff Current File" ], [ "filenam", "File: Copy Name" ], [ "disab", "Package Control: Disable Package" ], [ "enable", "Package Control: Enable Package" ], [ "SQL", "Set Syntax: SQL" ], [ "sq", "Set Syntax: SQL" ], [ "ql", "Git: Quick Log" ], [ "r app", "R Application Switch" ], [ "enah", "Set Syntax: Enhanced-Rd" ], [ "late", "Set Syntax: LaTeX" ], [ "enabl", "Package Control: Enable Package" ], [ "git add", "Git: Add Current File" ], [ "yaml", "Set Syntax: YAML" ], [ "ya", "Set Syntax: YAML" ], [ "Q", "Git: Quick Commit" ], [ "git ad", "Git: Add Current File" ], [ "g quick", "Git: Quick Commit" ] ], "width": 504.0 }, "console": { "height": 126.0, "history": [ "subprocess.Popen([Rscript, '-e', 'args(' + 'as.data.table' + ')', '--default-packages=data.table,ggplot2'], stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen([Rscript, '-e', 'args(' + 'data.table' + ')', '--default-packages=data.table,ggplot2'], stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen([Rscript, '-e', 'args(' + func + ')', '--default-packages=data.table,ggplot2'], stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen([Rscript, '-e', 'args(' + func + ')'], stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen([Rscript, '-e', '\"args(' + func + ')\"'], stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen([Rscript, '-e', '\"args(' + func + ')\" --default-packages=data.table,ggplot2'], stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen([Rscript, '-e', 'args(' + func + ') --default-packages=\"data.table,ggplot2\"'], stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen([Rscript, '-e', 'args(' + func + ') --default-packages=data.table,ggplot2'], stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen([Rscript, '-e', 'args(' + func + ')'], stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen(args + '', stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen(args + \"\", stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen(args, stdout=subprocess.PIPE).communicate()[0]", "args = [Rscript, '-e', 'args(' + func + ')']", "args", "subprocess.Popen(args, stdout=subprocess.PIPE).communicate()[0]", "args =[Rscript, '-e', 'args(' + func + ') --default-packages=data.table,ggplot2']", "subprocess.Popen([Rscript, '-e', 'args(' + 'data.table' + ')'], stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen([Rscript, '-e', 'args(' + 'data.frame' + ')'], stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen([Rscript, '-e', 'args(' + func + ')'], stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen(args, stdout=subprocess.PIPE).communicate()[0]", "import subprocess", "subprocess.Popen(args, stdout=subprocess.PIPE).communicate()[0]", "args", "args = [Rscript, '-e', 'args(' + func + ')']", "args <- [Rscript, '-e', 'args(' + func + ')']", "[Rscript, '-e', 'args(' + func + ')']", "output", "output = mycheck_output([Rscript, '-e', 'args(' + func + ')'])", "plat = sublime.platform()", "Rscript = \"Rscript\"", "Rscript = get(plat, \"Rscript\", \"Rscript\")", "plat", "help", "?", "{", "def get_Rscript():", "Rscript = get_Rscript()", "print(func in container)", "func", "func = m.group(1)", "print(func in container)", "m.group(1)", "m.group", "view.set_status(\"Enhanced-R\", \"\")", "not m", "if not m: return", "m", "m = re.match(r\".*?([a-zA-Z0-9.]+)\\($\", contentb)", "import re", "m = re.match(r\".*?([a-zA-Z0-9.]+)\\($\", contentb)", "contentb = view.substr(sublime.Region(view.line(point).begin(), point))", "contentb", "contentb = view.substr(sublime.Region(view.line(point).begin(), point))", "point", "point = view.sel()[0].end() if view.sel() else 0", " point = view.sel()[0].end() if view.sel() else 0", "point", "contentb", "contentb = view.substr(sublime.Region(view.line(point).begin(), point))", "sel[0].begin() != sel[0].end()", "len(sel)", "if len(sel)!=1: return", "sel = view.sel()", "this_row = view.rowcol(point)[0]", "sel[0].end()", "sel[0].begin()", "sel[0]", "len(sel)", "sel", "sel'", "sel = view.sel()", "this_row", "this_row = view.rowcol(point)[0]", "not view.score_selector(point, \"source.r\")", "view.score_selector(point, \"source.r\")", "point", "point = view.sel()[0].end() if view.sel() else 0", "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 }, "expanded_folders": [ ], "file_history": [ "/Users/rsaporta/git/orch/sublws/Currency_Exchange_Rates/Currency_Exchange_Rates.sublime-workspace", "/Users/rsaporta/git/orch/sublws/Currency_Exchange_Rates/Currency_Exchange_Rates.sublime-project", "/Users/rsaporta/git/orch/src/Currency_Exchange_Rates/01 Ingest exchange rates from Mike Bs sheet.r", "/Users/rsaporta/git/orch/src/Spotify_Streams_Per_Top_Artist/20150113 TimeTest.r", "/Users/rsaporta/git/misc/rscripts/utils/ggWrappers/ggLinegraph.r", "/Users/rsaporta/git/misc/rscripts/utils/Orchard_Specific/storeid.fromname.r", "/Users/rsaporta/git/misc/rscripts/utilsRS.r", "/Users/rsaporta/git/orch/src/Spotify_Streams_Per_Top_Artist/02 Create DT.toptracks by Parsing JSON.r", "/Users/rsaporta/git/orch/src/Spotify_Streams_Per_Top_Artist/supportFns/Spotify_Country_Codes.r", "/Users/rsaporta/git/orch/src/Spotify_Streams_Per_Top_Artist/API Documentation.txt", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt2_ZZ Join Cols and Export.r", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt2_c Create DT.merged - new 20140910.r", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt2_a Create GL_summaries.r", "/Users/rsaporta/git/orch/src/MgmtReport/GL Auto Latest Forecast Update.r", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt2_e Create DT.ancillary_with_forecasts.r", "/Users/rsaporta/git/orch/src/MgmtReport/supportFns/mkForecast.r", "/Users/rsaporta/git/orch/src/chartio/Create GPU Table from analytics.r", "/Users/rsaporta/git/orch/src/MgmtReport/supportFns/findMaxDate.r", "/Users/rsaporta/git/orch/src/MgmtReport/zArchive - Old Splits/2c archiving on 20140909/GL_pt2_c Create DT.merged, Split & Expand.r", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt6_a Export DT.supplychain_percentages to DB.r", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt3_aaaa TODO.r", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt1_a Import OA from DB Querying Aggregated Tables.r", "/Users/rsaporta/git/orch/src/MgmtReport/DT.acc check.r", "/Users/rsaporta/git/orch/src/MgmtReport/Accounting-to-Activity Time matchup.r", "/Users/rsaporta/git/orch/src/MgmtReport/!! TODO", "/Users/rsaporta/git/misc/rscripts/utils/notify/EmailStatusUpdate.r", "/Users/rsaporta/git/misc/rscripts/utils/notify/notify.r", "/Users/rsaporta/git/orch/src/MgmtReport/supportFns/calculateSplitPercentages.r", "/Users/rsaporta/git/orch/src/MgmtReport/Updaets since last email.txt", "/Users/rsaporta/git/orch/src/MgmtReport/supportFns/create_and_ingest_DT.MgmtReport_months_reported.r", "/Users/rsaporta/git/orch/src/MgmtReport/supportFns/create_DT_expanded_with_NA_fillers.r", "/Users/rsaporta/git/misc/rscripts/utils/DB_Utils/DB_Utils_WhereClause.r", "/Users/rsaporta/git/orch/src/MgmtReport/DT Descriptions.r", "/Users/rsaporta/git/orch/src/MgmtReport/GL Automation - Mgmt Report Ingestion.r", "/Users/rsaporta/Library/Application Support/Adobe/Lightroom/Develop Presets/User Presets/Sharp + Noise + Vignette.lrtemplate", "/Users/rsaporta/git/orch/ingest/MgmtReport/greatplains_storeid.csv", "/Users/rsaporta/git/orch/src/DeNormalizing/Column Renames 20140921.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables_new/Create All Views.r", "/Users/rsaporta/git/orch/src/MgmtReport/Updaets since last email:", "/Users/rsaporta/git/orch/src/MgmtReport/GL Auto Emails.r", "/Users/rsaporta/git/orch/src/MgmtReport/supportFns/music_and_video_bucketcleanup_.r", "/Users/rsaporta/git/misc/rscripts/utils/DB_Utils/DB_Utils.r", "/Users/rsaporta/git/misc/rscripts/utils/Orchard_Specific/fact_analytics_to_fact_analytics_error.r", "/Users/rsaporta/git/misc/rscripts/utils/debugging.r", "/Users/rsaporta/git/orch/src/automate new.r", "/Users/rsaporta/git/misc/rscripts/utils/DB_Utils/AWS_unload_load.r", "/Users/rsaporta/development/deleteme/.git/config", "/Users/rsaporta/git/.git/config", "/Users/rsaporta/git/orch/src/GL Automation - forecasting.r", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables_new/Analytics/02_AN populate_aggregated_analytics.sql", "/Users/rsaporta/git/misc/rscripts/utils/notify/email_with_mailR.r", "/Users/rsaporta/git/notify/email_with_mailR.r", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables_new/Analytics/01_AN create_aggregated_analytics.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables_new/Analytics/03_AN update_aggregated_analytics.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables_new/Views/store_view.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables_old/03_AN update_aggregated_analytics.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables_new/Views/label_view.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables_old/02_AN populate_aggregated_analytics.sql", "/Users/rsaporta/orgs_updated.tsv", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt0_a Workspace Setup.r", "/Users/rsaporta/git/orch/src/MgmtReport/warnings to clean up", "/Users/rsaporta/git/orch/src/DeNormalizing/zCleanTheseUp/AggregatedTables 140902/iTunes RED USA check.r", "/Users/rsaporta/git/orch/log/MgmtReport/Automation_ETL+MGMT_LogFile_20140917_0050.logr", "/Users/rsaporta/git/orch/log/MgmtReport/Automation_ETL+MGMT_LogFile_20140916_1646.logr", "/Users/rsaporta/git/orch/log/MgmtReport/Automation_ETL+MGMT_LogFile_20140916_1619.logr", "/Users/rsaporta/git/orch/log/MgmtReport/Automation_ETL+MGMT_LogFile_20140916_1610.logr", "/Users/rsaporta/git/orch/log/MgmtReport/Automation_ETL+MGMT_LogFile_20140916_1608.logr", "/Users/rsaporta/git/orch/log/MgmtReport/Automation_ETL+MGMT_LogFile_20140916_1525.logr", "/Users/rsaporta/git/orch/src/chartio/ISSUE - storeid is 355.r", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables_new/Views/transactiontype_view.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables_new/Views/country_view.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables_new/Views/release_product_view.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/zCleanTheseUp/zArchived/AggregatedTables 140505/populate_aggregated_accounting.sql", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt0_b Keys Folders and Variables.r", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt0_c Col Name Clean (for restoring backups).r", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables_new/UPDATE ioda vendors.r", "/Users/rsaporta/git/orch/src/DeNormalizing/zCleanTheseUp/Top Label By Store Group.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/zCleanTheseUp/Char Lengths.txt", "/Users/rsaporta/git/orch/src/MgmtReport/supportFns/findDateInterval.r", "/Users/rsaporta/git/orch/src/MGMT_REPORT_only_cluster.out.r", "/Users/rsaporta/git/orch/src/MGMT_REPORT_only_cluster.in.r", "/Users/rsaporta/git/orch/src/MGMT_REPORT_FULL_AUTO.r", "/Users/rsaporta/git/orch/src/DeNormalizing/Create CASE Clause from CSV.r", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/!01 Create analytics_outter_subqry.r", "/Users/rsaporta/git/orch/src/DeNormalizing/Char Lengths.txt", "/Users/rsaporta/git/orch/src/chartio/SQL Executor.r", "/Users/rsaporta/Library/Application Support/Sublime Text 3/Packages/User/Preferences.sublime-settings", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/aggregated_accounting_period_view.txt", "/Users/rsaporta/Downloads/GENRE2_0000_part_00", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/aggregated_accounting_label_view.txt", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/aggregated_accounting_genre_view.txt", "/Users/rsaporta/git/orch/src/DeNormalizing/AggregatedTables 140902/iTunes RED USA check.r", "/Users/rsaporta/git/orch/src/DeNormalizing/zArchived/AggregatedTables 140520/update agg tables part 2.sql", "/Users/rsaporta/git/orch/src/chartio/Create DS_scratch.GPU from analytics.r", "/Users/rsaporta/git/orch/src/DeNormalizing/AggregatedTables 140902/03_AN-update_aggregated_analytics (140902).sql", "/Users/rsaporta/git/orch/src/DeNormalizing/AggregatedTables 140902/03_AN update_aggregated_analytics (140902).sql", "/Users/rsaporta/git/orch/src/DeNormalizing/AggregatedTables 140902/03_AC-update_aggregated_accounting (140902).sql", "/Users/rsaporta/git/orch/src/DeNormalizing/AggregatedTables 140902/03_AC update_aggregated_accounting (140902).sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables (21040902)/02 AN NEW.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/02_AC populate_aggregated_accounting.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/02_AN-populate_aggregated_analytics.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables (21040902)/02_AN-new populate_aggregated_analytics_unload.sql", "/Users/rsaporta/git/misc/rscripts/utils/unloadQry.r", "/Users/rsaporta/git/orch/src/DeNormalizing/zArchived/AggregatedTables 140715/02_AN-new populate_aggregated_analytics (140715).sql", "/Users/rsaporta/git/orch/src/DeNormalizing/AGG_COMPARE/02_AN-new populate_aggregated_analytics (CHANGES).sql", "/Users/rsaporta/git/orch/src/DeNormalizing/AGG_COMPARE/02_AC populate_aggregated_accounting (CHANGES).sql", "/Users/rsaporta/git/orch/src/DeNormalizing/zArchived/AggregatedTables 140715/02_AC populate_aggregated_accounting (140715).sql", "/Users/rsaporta/git/orch/src/DeNormalizing/zArchived/AggregatedTables 140715/01_AN create_aggregated_analytics (140715).sql", "/Users/rsaporta/git/orch/src/DeNormalizing/AGG_COMPARE/01_AN create_aggregated_analytics (CHANGES).sql", "/Users/rsaporta/git/orch/src/DeNormalizing/AGG_COMPARE/01_AC create_aggregated_accounting (CHANGES).sql", "/Users/rsaporta/git/orch/src/DeNormalizing/zArchived/AggregatedTables 140715/01_AC create_aggregated_accounting (140715).sql", "/Users/rsaporta/git/orch/src/DeNormalizing/AGG_COMPARE/02_AC populate_aggregated_accounting (140902).sql", "/Users/rsaporta/git/orch/src/DeNormalizing/AggregatedTables 140902/02_AC populate_aggregated_accounting (140902).sql", "/Users/rsaporta/git/orch/src/DeNormalizing/AGG_COMPARE/01_AC create_aggregated_accounting (140902).sql", "/Users/rsaporta/git/orch/src/DeNormalizing/AggregatedTables 140902/01_AC create_aggregated_accounting (140902).sql", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt1_b Ingest GL from Revenue Worksheet.r", "/Users/rsaporta/git/orch/src/MgmtReport/supportFns/RunIsAForecast.r", "/Users/rsaporta/git/orch/src/MgmtReport/supportFns/GL Automation - forecasting.r", "/Users/rsaporta/git/orch/ingest/MgmtReport/SC_splits/supplychain_split_percs.csv", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt2_g DT.cleaned.agg.r", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt2_f Create DT.cleaned.r", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt1_c Ingest Revenue Summaries.r", "/Users/rsaporta/git/orch/src/MgmtReport/supportFns/showStoreAcc.r", "/Users/rsaporta/git/orch/src/MgmtReport/March Revenue.r", "/Users/rsaporta/git/misc/SublimeTextStuff/symbolic links.txt", "/Users/rsaporta/Library/Application Support/Sublime Text 3/Packages/User/Enhanced-R/send.py", "/Users/rsaporta/Library/Application Support/Sublime Text 3/Packages/Enhanced-R/send.py", "/Users/rsaporta/Library/Application Support/Sublime Text 3/Packages/Enhanced-R/Enhanced-R.sublime-settings" ], "find": { "height": 22.0 }, "find_in_files": { "height": 93.0, "where_history": [ "" ] }, "find_state": { "case_sensitive": false, "find_history": [ "DT.currency_exchange", "USD", "DT.revshare", "global_weekly_absolute", "P.global_weekly_absolute", "DT.country", "errors <- ", "DTs.list", "use this", "\n ", "tracks.flat", "gg_scale_functions", "thickness", "label", "alpha_dot", "alpha_line", "alpha", "geom_line", "registered", "net_revenue", "DT.revshare", "DT.monthly_cast.perc_incr", "cols.monthly_cast_perc", "smooth_", "stat_smoo", "transac", "kCols_streams", "sprintf", "y_scale", "ylab", "runQry", "dt.revshare", "global", "transac_type", "DT.RED_Split_Spotify", "by", "errors", "Despicable", "'", "country", "ggplot", " DT.spotify_countries", "spotify_tracks", "total_tracks", "orchard_tracks", "DT.revsh", "daily", "DT.top", "DT.top50", "nms.dc", "\"", "DTs.list", "(", "warning", "D", "force.views", "notify", "download_", "download_activity_date", "download_accounting_month", "updateDeNormTable", "QRY.select", "SelectAndUnload", "qShowTables", "starting", "updateDeN", "union", "SelectAndUnload", "unloadQry", "bucket ::", "bucket :", "EmailStatusUpdate", "notifyAndEmail", "tbl.zArch", "removed", "updateDeNormTable", "Updating tables", "||", "gpu_using", "gpuest", "download_", "tbl.out", "\"gpu\"", "'gpu'", "accounting_days_present", "full", "method", "method_used_for_forecasting", "forecasts_manual_from_rev_summary.ll", "DT.ancillary_with_forecasts", "aspiro", "DT.GL.summaries ", "DT.GL.summaries ", "DT.GL.summaries <- ", "DT.mgmtr_summary_tall <- ", "DT.forecast", "forecastColsToBringIn", "DT.forecasts <- ", "forecast", "rbind", "nokia", "sinkOn(", "Automation_ETL", "all views", "creating", "02b fa_errors_view.sql", "attache", "setCellStyleForType", "DTsToXLSX", "unlink", "f.out.xlsx", "if (file.exists(f.out))\n stop(\"file '\", f.out, \"' exists already\")\n ", "sheets", "store_name", "music_video_ancillary", "dict2", "nms.dict", "dict", "DT.percentages_full", " DT.percentages_full", "DT.forecasts", "DT.forecasts <- ", "DT.predictions", "accounting_period_view", "periodidTodate", "verbose", "AllDates", "dimensionCols" ], "highlight": true, "in_selection": true, "preserve_case": true, "regex": false, "replace_history": [ "weekly_absolute_byCountry", "dot_alpha", "line_alpha", "active", "x_scale", "xlab", "DT.RED_Split_Spotify.an", "", "\\'", "spotify_streams", "total_streams", "orchard_streams", "DT.toptracks", "DT.top", "", "activity_date", "accounting_month", "exportXLS.usingXLConnect", "store_name_short", "dict", "period_view", "dimCols", "dimensionCols", "fa.manual <- runQry(\"\nSELECT download_activity_date AS date, storeid, transactiontypeid AS transac_typeid, false AS from_errors_table\n , SUM(units) as units \nFROM production.fact_analytics \nWHERE storeid = 1 and download_activity_date >= '2014-10-01'\nGROUP By 1, 2, 3, 4\n \")\n", "schema", "period_view", "accounting_period_view", "skip.select.in_Denormalizing", "skip.select.indenormalizing", "out.right", "out.left", "gest_net_of_SC", "ancilla", "anal", "analytics", ".prod", "\\n ", "", " THEN", " THEN", "schema", "schema.tmp", "-------", "03_AC", "'", "DT.merged2", "calculated", "MgmtReport_", "MgmtReport", "----------", "Revenue", "file.in", "kCols.smry_supbuk", "thisRunIsAForecast", "notForecasting", "!notForecasting", "DT.GL_forecasted", "notForecasting", "DT.cleaned.aggd2", "DT.MgmtReport", "DT.cleaned.aggd", "GL_net_forDSOM", "DT.manual", "DT.cleaned.aggd", "DT.cleaned.OSC", "OA_percof_DS_forDSOM", "label_sc_group %in% OSC_values", "label_sc_group %ni% c(\"RED\", \"Orchard\")", "calc.tol", "DT.cleaned", "tmp_DT.monthly_sums_by_grp", "tmp_DT.monthly_sums", "is.na(ancillaryline)", "!is.na(ancillaryline)", "lastDateClosed", "zUncatego", "zUncategorized", "zUncategorized Store", "unaggd_adjust_to_add", "tmp.perc_by_date_SC", "OA_percof_DSO_forDSOM", "OA_percof_DS_forDSOM", "kCols.date", "ASR_percof_DS_forDSO", "kCols.SC", "tmp_DT", "[, V1]", "OA_majority_group_forDS", "OA_majority_group_forS", "OA_ZeroEntirely_forS", "OA_ZeroMonth_forDS", "tmp.OA_gross_forDS", "tmp_", "OA_gross_forDSOM", ".imputed", "store_first_date_in_OA", "store_last_date_in_OA", "total_gross_by_DS", "DSOM_subtotalgross_oa", "DT.merged", "split_perc_asr", "DT.split_percs.unexpanded", "DT.split_percs", "DT.split_percs.unexpanded", "DSOM_subtotalgross_oa", "subtotalgross_oa", "DT.allMain", "cn", "kCols.SC_meta", "kCols.meta_SC", "kCols.SC_meta", "ret_DT", "newCol.nm", "nm.newCol", "DT", "month_is_zero_in_OA", "month_is_zero", "DT", "storeTotal_by_SC", "total_by_StoreSC", "AdSupported", "DT.split_percs", "kCols.main_nodate", "kCols.storeSC", "total_netsc_by_DSO", "perc_split_ofOA_byDSO", "perc_split_ofDSO_byDSO", "perc_split_ofDSO_bystatement" ], "reverse": false, "show_context": false, "use_buffer2": true, "whole_word": false, "wrap": true }, "groups": [ { "sheets": [ ] } ], "incremental_find": { "height": 20.0 }, "input": { "height": 31.0 }, "layout": { "cells": [ [ 0, 0, 1, 1 ] ], "cols": [ 0.0, 1.0 ], "rows": [ 0.0, 1.0 ] }, "menu_visible": true, "output.exec": { "height": 166.0 }, "output.find_results": { "height": 256.0 }, "output.git-checkout": { "height": 100.0 }, "output.git-commit": { "height": 100.0 }, "output.git-pull": { "height": 82.0 }, "output.git-push": { "height": 94.0 }, "output.sftp": { "height": 0.0 }, "pinned_build_system": "", "project": "Currency_Exchange_Rates.sublime-project", "replace": { "height": 40.0 }, "save_all_on_build": true, "select_file": { "height": 0.0, "last_filter": "", "selected_items": [ [ "mk", "supportFns/mkForecast.r" ], [ "push", "DeNormalizing/zCleanTheseUp/AggregatedTables 140902/iTunes RED USA check.r" ], [ "ush", "DeNormalizing/zCleanTheseUp/AggregatedTables 140902/iTunes RED USA check.r" ], [ "jesusfordata_forecasting", "supportFns/jesusForData_Forecasting.r" ], [ "permeat", "supportFns/permeate.r" ], [ "dict.", "supportFns/dict.rev_summary_colnames.r" ], [ "dict", "supportFns/dict.GL_colnames.r" ], [ "manl_cr", "GL_pt3_a Create DT.manl_crop.r" ], [ "mkforecast", "supportFns/mkForecast.r" ], [ "ull", "supportFns/calculateSplitPercentages.r" ], [ "us", "supportFns/calculateSplitPercentages.r" ], [ "r", "03b DB_raw.r" ] ], "width": 0.0 }, "select_project": { "height": 0.0, "last_filter": "", "selected_items": [ ], "width": 0.0 }, "select_symbol": { "height": 392.0, "last_filter": "", "selected_items": [ ], "width": 392.0 }, "selected_group": 0, "settings": { }, "show_minimap": false, "show_open_files": false, "show_tabs": true, "side_bar_visible": false, "side_bar_width": 211.0, "status_bar_visible": true, "template_settings": { } }