{ "auto_complete": { "selected_items": [ [ "distribut", "distributor_id" ], [ "activ", "activity_date" ], [ "DT.", "DT.rates" ], [ "DT.ra", "DT.rates2" ], [ "num", "number" ], [ "dtrat", "DT.rates" ], [ "DT.rate", "DT.rates" ], [ "sche", "schema_out" ], [ "Dump", "Dumps_For_AppleMusic_and_Spotify" ], [ "dbn", "dbname" ], [ "datec", "dateCol.spot" ], [ "date", "dateCol.spot" ], [ "colsTo", "colsToPull" ], [ "colst", "colsToPull" ], [ "check_", "check_warehouse" ], [ "setSnow", "setSnowflake" ], [ "curren", "current_vals" ], [ "snowf", "snowflake" ], [ "WH", "wh" ], [ "setSno", "setSnowflake" ], [ "is.char", "is.char_of_length1" ], [ "is.ch", "is.char_of_length1" ], [ "identi", "identity" ], [ "from", "from_system" ], [ "where", "whereIn" ], [ "UT_", "UTC_offset_std" ], [ "time_", "time_offsets" ], [ "stand", "Standard_TZ" ], [ "sta_", "states_with_multi" ], [ "as.p", "as.POSIXct" ], [ "iden", "identity" ], [ "DT.us", "DT.usa_streams" ], [ "ratio", "ratio_of_streams" ], [ "tmst", "tmstmp" ], [ "countr", "country_count" ], [ "othe", "others_playlist" ], [ "count", "country" ], [ "user_", "user_id" ], [ "ColsT", "colsToAgg" ], [ "env", "envir" ], [ "tblsp", "tbl_out.spot" ], [ "schema", "schema.out" ], [ "staging_", "staging_raw_spotify_v2" ], [ "apple", "AppleMusic" ], [ "buck", "bucket_base" ], [ "cols", "colSums" ], [ "quan", "quantity" ], [ "tbl_", "tbl_new" ], [ "label", "labelid" ], [ "gen", "genreid" ], [ "unload", "unloadQry" ], [ "produ", "production" ], [ "dist", "distinct" ], [ "downlo", "download_date" ], [ "downl", "download_date" ], [ "store_", "store_musicsuperbucket" ], [ "STORE_M", "store_musicbucket" ], [ "accoun", "accounting_month" ], [ "store", "storepart" ], [ "DT.m", "DT.manual.ll" ], [ "DT.st", "DT.storeavg" ], [ "DT.so", "DT.storeavg" ], [ "don", "download_activity_date" ], [ "rbind", "rbindlist" ], [ "fail_", "fail_if_GPU_fails" ], [ "skip", "skip.select.in_Denormalizing" ], [ "for", "force.accounting" ], [ "force.", "force.accounting" ], [ "suff", "suffix" ], [ "suffi", "suffixes" ], [ "suf", "suffixes" ], [ "DT.vali", "DT.validate" ], [ "DT.val", "DT.validate" ], [ "colsT", "colsToCompare" ], [ "folder", "folder.valid_jesus" ], [ "sch", "schemaPaste" ], [ "DT.r", "DT.rowcounts.aggd" ], [ "DT.rowcoun", "DT.rowcounts.aggd" ], [ "tim", "time.end" ], [ "q.fa", "qry.rowcounts.fact" ], [ "pa", "paidunits" ], [ "cl", "col" ], [ "key", "keys2" ], [ "verbos", "verboseMsg" ], [ "cluster", "cluster.out" ], [ "min", "minDate" ], [ "clu", "cluster.out" ], [ "clust", "cluster" ], [ "cluster.", "cluster.out" ], [ "run", "run_start_time" ], [ "out.", "out.padded.full" ], [ "paste", "pasteR" ], [ "TestF", "TestFunc1" ], [ "Test", "TestFunc2" ], [ "uniqu", "unique.bucket" ], [ "accou", "accounting" ], [ "anal", "analytics" ], [ "date.", "dateCol.ll" ], [ "Account", "accountingperiodid" ], [ "dateC", "dateCol_aggd.ll" ], [ "allo", "allow_0_rows" ], [ "al", "allow_0_rows" ], [ "DT.va", "DT.validate.fact" ], [ "DT.row", "DT.rowcounts" ], [ ".SD", ".SDcols" ], [ "DT.ro", "DT.rowcounts" ], [ "verbose", "verboseMsg" ], [ "notif", "notifyIfError" ], [ "select", "SelectAndUnload" ], [ "not", "notify" ], [ "exist", "existing_tables" ], [ "verbo", "verboseMsg" ], [ "metho", "method_used_for_forecasting" ], [ "Sys", "Sys.time" ], [ "time", "timeCheck" ], [ "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" ] ] }, "buffers": [ { "file": "/Users/rsaporta/git/orch/src/misc/spotify usa source comparison.r", "settings": { "buffer_size": 4105, "line_ending": "Unix" } }, { "file": "/Users/rsaporta/git/orch/src/misc/Lee Spotify Numbers Request.r", "settings": { "buffer_size": 1473, "line_ending": "Unix" } }, { "file": "/Users/rsaporta/git/orch/notes/AppleMusic/headDB of Music.r", "settings": { "buffer_size": 3090, "line_ending": "Unix", "name": "datestamp apple_identifier action_type end_re" } }, { "file": "/Users/rsaporta/git/orch/src/AppleMusic/Apple Music Transac Types.sql", "settings": { "buffer_size": 1805, "line_ending": "Unix" } }, { "file": "/Users/rsaporta/git/orch/src/AppleMusic/Apple Music Sony Figures Export To Snowflake.r", "settings": { "buffer_size": 11763, "line_ending": "Unix" } }, { "file": "/Users/rsaporta/git/misc/rscripts/utils/xls/xls_utils.r", "settings": { "buffer_size": 6631, "line_ending": "Unix" } }, { "file": "/Users/rsaporta/git/orch/src/AppleMusic/Trial Estimates.r", "settings": { "buffer_size": 5244, "line_ending": "Unix" } }, { "file": "/Users/rsaporta/git/orch/src/AppleMusic/finance data ingest 20151021.r", "settings": { "buffer_size": 1498, "line_ending": "Unix" } }, { "file": "/Users/rsaporta/git/orch/src/Snowflake_Scratch/SF - stages & file format for Apple Music and Spotify [2015-07-07].r", "settings": { "buffer_size": 1400, "line_ending": "Unix" } } ], "build_system": "Packages/R-Box/support/R-Box.sublime-build", "build_system_choices": [ [ [ [ "Packages/R-Box/support/R-Box.sublime-build", "" ], [ "Packages/SublimeREPL/sublimerepl_build_system_hack.sublime-build", "" ] ], [ "Packages/R-Box/support/R-Box.sublime-build", "" ] ] ], "build_varint": "", "command_palette": { "height": 392.0, "last_filter": "txe", "selected_items": [ [ "txe", "Set Syntax: Plain Text" ], [ "yaml", "Set Syntax: YAML" ], [ "name", "File: Copy Name" ], [ "push", "Git: Push" ], [ "path", "File: Copy Path" ], [ "rex", "Set Syntax: R Extended" ], [ "dele", "File: Delete" ], [ "wor", "Word Wrap: Toggle" ], [ "qui", "Git: Quick Commit Current File" ], [ "pus", "Git: Push" ], [ "pul", "Git: Pull" ], [ "rext", "Set Syntax: R Extended" ], [ "ren", "File: Rename" ], [ "pull", "Git: Pull" ], [ "map", "View: Toggle Minimap" ], [ "sql", "Set Syntax: SQL" ], [ "wo", "Word Wrap: Toggle" ], [ "move", "File: Move" ], [ "reve", "File: Reveal" ], [ "renam", "File: Rename" ], [ "rename", "File: Rename" ], [ "rena", "File: Rename" ], [ "word", "Word Wrap: Toggle" ], [ "bro", "SFTP: Browse Server…" ], [ "brow", "SFTP: Browse Server…" ], [ "edit", "SFTP: Edit Server…" ], [ "open file", "View: Toggle Open Files in Side Bar" ], [ "server", "SFTP: Setup Server…" ], [ "br", "SFTP: Browse Server…" ], [ "disabl", "Package Control: Disable Package" ], [ "edit serv", "SFTP: Edit Server…" ], [ "brow ser", "SFTP: Browse Server…" ], [ "install", "Package Control: Install Package" ], [ "enh", "Set Syntax: Enhanced-R" ], [ "qu", "Git: Quick Commit Current File" ], [ "rap", "R Application Switch" ], [ "comm", "Git: Commit" ], [ "ra", "R Application Switch" ], [ "copy", "File: Copy Path" ], [ "q", "Git: Quick Commit" ], [ "en", "Set Syntax: Enhanced-R" ], [ "git pu", "Git: Pull" ], [ "update", "Package Control: Upgrade/Overwrite All Packages" ], [ "git pull", "Git: Pull" ], [ "del", "File: Delete" ], [ "quic", "Git: Quick Commit Current File" ], [ "wro", "Word Wrap: Toggle" ], [ "upda", "Package Control: Upgrade Package" ], [ "text", "Set Syntax: Plain Text" ], [ "r", "R Application Switch" ], [ "d", "File: Delete" ], [ "comcur", "Git: Quick Commit Current File" ], [ "w", "Word Wrap: Toggle" ], [ "add cu", "Git: Add Current File" ], [ "enha", "Set Syntax: Enhanced-R" ], [ "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" ], [ "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" ], [ "psuh", "Git: Push" ], [ "puh", "Git: Push" ], [ "disable pack", "Package Control: Disable Package" ], [ "disa", "Package Control: Disable Package" ], [ "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" ], [ "qucur", "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" ], [ "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" ], [ "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" ], [ "RENA", "File: Rename" ], [ "ADD", "Git: Add Current File" ], [ "copnam", "File: Copy Name" ], [ "rep", "SublimeREPL: PHP" ], [ "enhg", "BracketHighlighter: Select Next Attribute (right)" ], [ "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" ], [ "ite", "Indentation: Convert to Spaces" ], [ "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" ] ], "width": 521.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": [ "/Users/rsaporta/git/orch/src/AppleMusic", "/Users/rsaporta/git/orch/notes/AppleMusic" ], "file_history": [ "/Users/rsaporta/Desktop/Introducing Data Team.R", "/Users/rsaporta/git/orch/src/AppleMusic/Trial Estimates.r", "/Users/rsaporta/git/orch/ingest/AppleMusic/OANDA_rates_20150909.csv", "/Users/rsaporta/git/orch/ingest/AppleMusic/AppleMusic Trial Rates uncleaned.csv", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Views/country_view.sql", "/Users/rsaporta/git/orch/src/AppleMusic/OANDA_rates_20150909.csv", "/Users/rsaporta/git/orch/src/AppleMusic/applemusic.apple_music_rates.lookml", "/Users/rsaporta/git/orch/src/Looker/supportFns/cleanLookerHeaders_after_download.r", "/Users/rsaporta/git/orch/src/Snowflake_Scratch/SF - stages & file format for Apple Music and Spotify [2015-07-07].r", "/Users/rsaporta/git/orch/ingest/AppleMusic/AppleMusic Trial Rates II.csv", "/Users/rsaporta/Desktop/example of crashing fread", "/Users/rsaporta/git/orch/src/misc/fact_sales fields.sql", "/Users/rsaporta/git/orch/src/AppleMusic/2015-07-07 Apple Music Overview.r", "/Users/rsaporta/git/orch/src/Looker/Row Numbers for fact_analytics 20150721.r", "/Users/rsaporta/git/orch/src/Looker/Row Numbers for fact_analytics 20150721 -- straight serial.r", "/Users/rsaporta/Desktop/this is a test file.csv", "/Users/rsaporta/git/orch/src/misc/Holly_miranda.r", "/Users/rsaporta/git/misc/rscripts/utils/DB_Utils/SF_Utils - Table Creations.r", "/Users/rsaporta/git/misc/rscripts/utils/DB_Utils/SF_Utils.R", "/Users/rsaporta/git/misc/rscripts/utils/DB_Utils/SF_Utils_Setters_and_Getters.r", "/Users/rsaporta/git/misc/rscripts/utils/DB_Utils/DB_Utils_Setters_and_Getters.r", "/Users/rsaporta/git/misc/rscripts/utils/DB_Utils/DB_redshift_errors.r", "/Users/rsaporta/git/misc/rscripts/utils/DB_Utils/DB_Utils.r", "/Users/rsaporta/git/misc/rscripts/utils/DB_Utils/SF zArchived Utils.r", "/Users/rsaporta/git/misc/rscripts/utils/DB_Utils/sf_options.r", "/Users/rsaporta/git/misc/rscripts/utils/weekdaysPer.r", "/Users/rsaporta/git/misc/rscripts/utils/getDMACodes.r", "/Users/rsaporta/Library/Application Support/Sublime Text 3/Packages/User/Preferences.sublime-settings", "/Users/rsaporta/Desktop/Looker TODO.r", "/Users/rsaporta/Downloads/Detailed Sales Report.sql", "/Users/rsaporta/git/orch/src/AppleMusic/Apple Music Poking Around [2015-07-07].r", "/Users/rsaporta/git/orch/src/AppleMusic/create table for SF.sql", "/Users/rsaporta/Desktop/TODO", "/Users/rsaporta/git/misc/rscripts/utils/AWS_Utils/AWS_unload_load.r", "/Users/rsaporta/git/orch/src/AppleMusic/SF - stages & file format for Apple Music and Spotify [2015-07-07].r", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Create All Views.r", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Views/release_view.sql", "/Users/rsaporta/git/misc/rscripts/utils/DB_Utils/makeQry and runQry.r", "/Users/rsaporta/git/orch/src/MGMT_REPORT_FULL_AUTO.r", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/20150415 Spotify Biz Review - User Counts.r", "/Users/rsaporta/.bash_profile", "/Users/rsaporta/Library/Application Support/Sublime Text 3/Packages/Default/Default (OSX).sublime-keymap", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Accounting/01_AC create_aggregated_accounting.sql", "/var/folders/sx/yk5_jdd16r32vj2fx8p2w9wr0000gp/T/sublime-sftp-browse-1428343631/AWS Log Files.json/home/rsaporta/git/orch/log/MgmtReport/Automation_ETL+MGMT_LogFile_20150406_1143.logr", "/Users/rsaporta/git/misc/rscripts/utils/date modifiers.r", "/Users/rsaporta/Library/Application Support/Sublime Text 3/Packages/User/sftp_servers/AWS Log Files.json", "/var/folders/sx/yk5_jdd16r32vj2fx8p2w9wr0000gp/T/sublime-sftp-browse-1428338715/AWS Log Files.json/home/rsaporta/git/orch/log/MgmtReport/Automation_ETL+MGMT_LogFile_20150406_1143.logr", "/var/folders/sx/yk5_jdd16r32vj2fx8p2w9wr0000gp/T/sublime-sftp-browse-1428337642/AWS.json/home/rsaporta/git/orch/log/MgmtReport/Automation_ETL+MGMT_LogFile_20150406_1143.logr", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt6_a Export DT.supplychain_percentages to DB.r", "/Users/rsaporta/git/orch/src/MgmtReport/greatplains export.r", "/Users/rsaporta/Library/Application Support/Sublime Text 3/Packages/User/sftp_servers/AWS.json", "/Users/rsaporta/Library/Application Support/Sublime Text 3/Packages/User/sftp_servers/[Errno 2] No such file or directory: 'node'", "/Users/rsaporta/git/orch/src/MgmtReport/supportFns/automate new.r", "/Users/rsaporta/git/orch/src/automate new.r", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt2_ZZ Join Cols and Export.r", "/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 Automation - Mgmt Report Ingestion.r", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt1_b Ingest GL from Revenue Worksheet.r", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt1_d Ingest Manual Tempalte worksheets.r", "/Users/rsaporta/git/misc/Bug Reports/DT - entire table gets printed.r", "/Users/rsaporta/git/orch/src/chartio/Create GPU Table from analytics.r", "/Users/rsaporta/git/orch/src/MgmtReport/Automate_File_Watching/mgmt_file_process.r", "/Users/rsaporta/git/orch/src/MgmtReport/Automate_File_Watching/Ship Downloaded Files.r", "/Users/rsaporta/git/orch/src/MgmtReport/supportFns/calculateSplitPercentages.r", "/Users/rsaporta/git/orch/src/validation failed.r", "/Users/rsaporta/git/orch/src/MgmtReport/supportFns/colsByTable.r", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt1_a Import OA from DB Querying Aggregated Tables.r", "/Users/rsaporta/git/orch/src/MgmtReport/!! TODO Dec 2014", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt2_b Create mgmtr_summary_tall from GL_Summaries.r", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt0_b Keys Folders and Variables.r", "/Users/rsaporta/git/orch/src/MgmtReport/GL - CHECK 2.r", "/Users/rsaporta/git/orch/src/MgmtReport/DT.acc check.r", "/Users/rsaporta/git/orch/src/MgmtReport/Accounting_vs_Analytics_2015 (GL using) - old as of 20150114.r", "/Users/rsaporta/git/orch/log/MgmtReport/Automation_ETL+MGMT_LogFile_20150117_1211.logr", "/Users/rsaporta/git/orch/src/MgmtReport/GL Auto Latest Forecast Update.r", "/Users/rsaporta/git/orch/src/MgmtReport/supportFns/createSummaryOfAggTables.r", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt0_a Workspace Setup.r", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt0_c Col Name Clean (for restoring backups).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/notify/notify.r", "/Users/rsaporta/git/orch/src/Tables To Drop from Cluster 09.sql", "/Users/rsaporta/Desktop/new music", "/Users/rsaporta/git/orch/src/automate new - validate II.r", "/Users/rsaporta/git/misc/rscripts/utils/Orchard_Specific/id Conversions.r", "/Users/rsaporta/Desktop/untitled.r", "/Users/rsaporta/git/orch/src/MgmtReport/Run For Rick Please.txt", "/Users/rsaporta/git/misc/rscripts/utils/DB_Utils/DB_Utils_WhereClause.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_pt2_e Create DT.ancillary_with_forecasts.r", "/Users/rsaporta/git/orch/src/MgmtReport/supportFns/mkForecast.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_pt3_aaaa TODO.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/orch/src/MgmtReport/DT Descriptions.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/Orchard_Specific/fact_analytics_to_fact_analytics_error.r", "/Users/rsaporta/git/misc/rscripts/utilsRS.r", "/Users/rsaporta/git/misc/rscripts/utils/debugging.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/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" ], "find": { "height": 35.0 }, "find_in_files": { "height": 93.0, "where_history": [ "" ] }, "find_state": { "case_sensitive": false, "find_history": [ " ", "lookerapp", "countryid", "f.sony.xlsx", "ingestFile", "readwork", "cell ", "store_name", "CDN", "idr", "IDR", "INR", "Congo", " \\d", "Belarus", " ", " and", " ", "united king", "\" \"", "\" \"", "'", "SELECT * \nFROM prod.production.FACT_SALES \nWHERE (accountingperiodid >= 182)\n AND (NOT subaccountid IS NULL) \n AND (fx_spread_fee != 0)\n AND (retail_price != 0)\n AND (fx_adjusted_exchange_rate <> 1.0) AND (fx_adjusted_exchange_rate <> 0.0) \nLIMIT 1", "makeqry", "schema", "Dumps_For_AppleMusic_and_Spotify", "dbname.sf", "AppleMusicr", "AppleMusic.aw", "stageName", "dbname.sf", "sfCreateStage", "COPY INTO", "sfCreateStage", "sfPopulateTableFromBucket", "addMeta_", "setSnowflakeWH", "maxdate", "setSnowflake", " print", "sfqry", "connex", "current_wh", "sfqry", "warehouse", "wareouse", "sFGETCon", "setCurrentWh", "justname=FALSE", "sfSetCurrentWH", "check_if_valid", "sfSetCurrentWH(name, connex=connex, verbose=False)", "sfSetCurrentWH(name, connex=connex, check_if_valid=FALSE, verbose=FALSE)", "sfSetCurrentWH", "do.call", "verbose=verbose", ", verbose=FALSE)", "sfSetCurrentWH", "usesnow", "here", "database", "setSnowflakeDB\nsetSnowflakeWH\nsetSnowflakeSchema\n\ngetSnowflakeDB\ngetSnowflakeWH\ngetSnowflakeSchema\n\n", "sfUseDB", "%1$s", "sfshowdb", "grep", "gsub", "sf", "envir=g", "envir=", "sfSetCurrentWH", "dbname", "dbname\"", "sfSet", "sfCurrent", "current_", "getSnowflakeDB <- ", "getSnowflakeDB", "dbname", "snowflake_dbname", "snowflake_current_wh", "sfSetCurrentWH", "sfSetWarehouseDetails", "setware", "snowflake_currentwh", "writeDT", "WeekdaysStartingAt", "DT.usa_streams", "set warehouse", "warehouse", ".dblib <- ", ".dblin", "RODBC:::odbcValidChannel(connex)", "iscone", ".sf_clean_wh_input", "isConExpired", "set_snowflake_inuse", "sfgetcon <- ", "\"dev\"", "schema.out", "DT.spot_samp", "DT.apple_samp", "views", "SelectAndUnload", "HINT 1", "SelectAndUnload", "tbl", "stamp", "view", "sink", "chopping Query", "at chopping Query", "at chopping Query ...", "FUN", "FUN(", "source", "INNER", " table was created but there are", "+b", "force", "\\t", "delim", "SelectAndUnload", "delim", "delim = ", "unloadQry", "UNLOAD", "accounting" ], "highlight": true, "in_selection": false, "preserve_case": false, "regex": true, "replace_history": [ "CAD", " ", " and ", " ", "\",\"", "\" \"", "\" \"", "\"", "dbname", "dbname.sf", "stage_name", "stageName", "wh", "sfGetCon", "sfSetCurrentWH(name, connex=connex, verbose=FALSE)", "connex=connex, verbose=verbose", ", connex=connex, verbose=verbose", ", connex=sfGetCon(), verbose=FALSE)", ", verbose=FALSE)", "warehouse", "snowflake_currentwh", "getSnowflakeDB()", "schema_out", "DT_samp.spot", "DT_samp.apple", "\\v", "AcctBIandProd_are_synced", "validate", "qry.rowcounts.fact", "unique_bucket", "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" ], "reverse": false, "show_context": false, "use_buffer2": true, "whole_word": false, "wrap": true }, "groups": [ { "selected": 4, "sheets": [ { "buffer": 0, "file": "/Users/rsaporta/git/orch/src/misc/spotify usa source comparison.r", "semi_transient": false, "settings": { "buffer_size": 4105, "regions": { }, "selection": [ [ 0, 0 ] ], "settings": { "BracketHighlighterBusy": false, "auto_name": "", "bh_regions": [ "bh_default", "bh_default_center", "bh_default_open", "bh_default_close", "bh_default_content", "bh_single_quote", "bh_single_quote_center", "bh_single_quote_open", "bh_single_quote_close", "bh_single_quote_content", "bh_double_quote", "bh_double_quote_center", "bh_double_quote_open", "bh_double_quote_close", "bh_double_quote_content", "bh_square", "bh_square_center", "bh_square_open", "bh_square_close", "bh_square_content", "bh_curly", "bh_curly_center", "bh_curly_open", "bh_curly_close", "bh_curly_content", "bh_c_define", "bh_c_define_center", "bh_c_define_open", "bh_c_define_close", "bh_c_define_content", "bh_unmatched", "bh_unmatched_center", "bh_unmatched_open", "bh_unmatched_close", "bh_unmatched_content", "bh_angle", "bh_angle_center", "bh_angle_open", "bh_angle_close", "bh_angle_content", "bh_tag", "bh_tag_center", "bh_tag_open", "bh_tag_close", "bh_tag_content", "bh_round", "bh_round_center", "bh_round_open", "bh_round_close", "bh_round_content", "bh_regex", "bh_regex_center", "bh_regex_open", "bh_regex_close", "bh_regex_content" ], "incomplete_sync": null, "r_box_status": false, "remote_loading": false, "synced": false, "syntax": "Packages/R-Box/syntax/R Extended.tmLanguage", "syntax_mgr_loaded": true, "tab_size": 2, "translate_tabs_to_spaces": true, "word_wrap": true }, "translation.x": 0.0, "translation.y": 0.0, "zoom_level": 1.0 }, "stack_index": 7, "type": "text" }, { "buffer": 1, "file": "/Users/rsaporta/git/orch/src/misc/Lee Spotify Numbers Request.r", "semi_transient": false, "settings": { "buffer_size": 1473, "regions": { }, "selection": [ [ 1473, 1473 ] ], "settings": { "BracketHighlighterBusy": false, "bh_regions": [ "bh_default", "bh_default_center", "bh_default_open", "bh_default_close", "bh_default_content", "bh_single_quote", "bh_single_quote_center", "bh_single_quote_open", "bh_single_quote_close", "bh_single_quote_content", "bh_double_quote", "bh_double_quote_center", "bh_double_quote_open", "bh_double_quote_close", "bh_double_quote_content", "bh_square", "bh_square_center", "bh_square_open", "bh_square_close", "bh_square_content", "bh_curly", "bh_curly_center", "bh_curly_open", "bh_curly_close", "bh_curly_content", "bh_c_define", "bh_c_define_center", "bh_c_define_open", "bh_c_define_close", "bh_c_define_content", "bh_unmatched", "bh_unmatched_center", "bh_unmatched_open", "bh_unmatched_close", "bh_unmatched_content", "bh_angle", "bh_angle_center", "bh_angle_open", "bh_angle_close", "bh_angle_content", "bh_tag", "bh_tag_center", "bh_tag_open", "bh_tag_close", "bh_tag_content", "bh_round", "bh_round_center", "bh_round_open", "bh_round_close", "bh_round_content", "bh_regex", "bh_regex_center", "bh_regex_open", "bh_regex_close", "bh_regex_content" ], "incomplete_sync": null, "r_box_status": false, "remote_loading": false, "synced": false, "syntax": "Packages/R-Box/syntax/R Extended.tmLanguage", "syntax_mgr_loaded": true }, "translation.x": 0.0, "translation.y": 0.0, "zoom_level": 1.0 }, "stack_index": 8, "type": "text" }, { "buffer": 2, "file": "/Users/rsaporta/git/orch/notes/AppleMusic/headDB of Music.r", "semi_transient": false, "settings": { "buffer_size": 3090, "regions": { }, "selection": [ [ 257, 257 ], [ 537, 537 ], [ 817, 817 ], [ 1097, 1097 ], [ 1377, 1377 ], [ 1657, 1657 ], [ 1937, 1937 ], [ 2217, 2217 ], [ 2497, 2497 ], [ 2777, 2777 ], [ 3057, 3057 ] ], "settings": { "BracketHighlighterBusy": false, "auto_name": "datestamp apple_identifier action_type end_re", "bh_regions": [ "bh_regex", "bh_regex_center", "bh_regex_open", "bh_regex_close", "bh_regex_content", "bh_square", "bh_square_center", "bh_square_open", "bh_square_close", "bh_square_content", "bh_double_quote", "bh_double_quote_center", "bh_double_quote_open", "bh_double_quote_close", "bh_double_quote_content", "bh_angle", "bh_angle_center", "bh_angle_open", "bh_angle_close", "bh_angle_content", "bh_c_define", "bh_c_define_center", "bh_c_define_open", "bh_c_define_close", "bh_c_define_content", "bh_curly", "bh_curly_center", "bh_curly_open", "bh_curly_close", "bh_curly_content", "bh_default", "bh_default_center", "bh_default_open", "bh_default_close", "bh_default_content", "bh_single_quote", "bh_single_quote_center", "bh_single_quote_open", "bh_single_quote_close", "bh_single_quote_content", "bh_round", "bh_round_center", "bh_round_open", "bh_round_close", "bh_round_content", "bh_tag", "bh_tag_center", "bh_tag_open", "bh_tag_close", "bh_tag_content", "bh_unmatched", "bh_unmatched_center", "bh_unmatched_open", "bh_unmatched_close", "bh_unmatched_content" ], "incomplete_sync": null, "remote_loading": false, "synced": false, "syntax": "Packages/R-Box/syntax/R Extended.tmLanguage", "syntax_mgr_loaded": true, "word_wrap": false }, "translation.x": 190.0, "translation.y": 0.0, "zoom_level": 1.0 }, "stack_index": 3, "type": "text" }, { "buffer": 3, "file": "/Users/rsaporta/git/orch/src/AppleMusic/Apple Music Transac Types.sql", "semi_transient": false, "settings": { "buffer_size": 1805, "regions": { }, "selection": [ [ 1110, 1110 ] ], "settings": { "BracketHighlighterBusy": false, "auto_name": "", "bh_regions": [ "bh_regex", "bh_regex_center", "bh_regex_open", "bh_regex_close", "bh_regex_content", "bh_square", "bh_square_center", "bh_square_open", "bh_square_close", "bh_square_content", "bh_double_quote", "bh_double_quote_center", "bh_double_quote_open", "bh_double_quote_close", "bh_double_quote_content", "bh_angle", "bh_angle_center", "bh_angle_open", "bh_angle_close", "bh_angle_content", "bh_c_define", "bh_c_define_center", "bh_c_define_open", "bh_c_define_close", "bh_c_define_content", "bh_curly", "bh_curly_center", "bh_curly_open", "bh_curly_close", "bh_curly_content", "bh_default", "bh_default_center", "bh_default_open", "bh_default_close", "bh_default_content", "bh_single_quote", "bh_single_quote_center", "bh_single_quote_open", "bh_single_quote_close", "bh_single_quote_content", "bh_round", "bh_round_center", "bh_round_open", "bh_round_close", "bh_round_content", "bh_tag", "bh_tag_center", "bh_tag_open", "bh_tag_close", "bh_tag_content", "bh_unmatched", "bh_unmatched_center", "bh_unmatched_open", "bh_unmatched_close", "bh_unmatched_content" ], "incomplete_sync": null, "remote_loading": false, "synced": false, "syntax": "Packages/SQL/SQL.tmLanguage", "syntax_mgr_loaded": true, "tab_size": 2, "translate_tabs_to_spaces": true }, "translation.x": 0.0, "translation.y": 0.0, "zoom_level": 1.0 }, "stack_index": 2, "type": "text" }, { "buffer": 4, "file": "/Users/rsaporta/git/orch/src/AppleMusic/Apple Music Sony Figures Export To Snowflake.r", "semi_transient": false, "settings": { "buffer_size": 11763, "regions": { }, "selection": [ [ 1470, 1470 ] ], "settings": { "BracketHighlighterBusy": false, "bh_regions": [ "bh_square", "bh_square_center", "bh_square_open", "bh_square_close", "bh_square_content", "bh_default", "bh_default_center", "bh_default_open", "bh_default_close", "bh_default_content", "bh_double_quote", "bh_double_quote_center", "bh_double_quote_open", "bh_double_quote_close", "bh_double_quote_content", "bh_angle", "bh_angle_center", "bh_angle_open", "bh_angle_close", "bh_angle_content", "bh_round", "bh_round_center", "bh_round_open", "bh_round_close", "bh_round_content", "bh_tag", "bh_tag_center", "bh_tag_open", "bh_tag_close", "bh_tag_content", "bh_unmatched", "bh_unmatched_center", "bh_unmatched_open", "bh_unmatched_close", "bh_unmatched_content", "bh_c_define", "bh_c_define_center", "bh_c_define_open", "bh_c_define_close", "bh_c_define_content", "bh_regex", "bh_regex_center", "bh_regex_open", "bh_regex_close", "bh_regex_content", "bh_single_quote", "bh_single_quote_center", "bh_single_quote_open", "bh_single_quote_close", "bh_single_quote_content", "bh_curly", "bh_curly_center", "bh_curly_open", "bh_curly_close", "bh_curly_content" ], "incomplete_sync": null, "r_box_status": false, "remote_loading": false, "synced": false, "syntax": "Packages/R-Box/syntax/R Extended.sublime-syntax", "syntax_mgr_loaded": true, "tab_size": 2, "translate_tabs_to_spaces": true }, "translation.x": 0.0, "translation.y": 0.0, "zoom_level": 1.0 }, "stack_index": 0, "type": "text" }, { "buffer": 5, "file": "/Users/rsaporta/git/misc/rscripts/utils/xls/xls_utils.r", "semi_transient": false, "settings": { "buffer_size": 6631, "regions": { }, "selection": [ [ 6630, 6630 ] ], "settings": { "BracketHighlighterBusy": false, "bh_regions": [ "bh_regex", "bh_regex_center", "bh_regex_open", "bh_regex_close", "bh_regex_content", "bh_square", "bh_square_center", "bh_square_open", "bh_square_close", "bh_square_content", "bh_double_quote", "bh_double_quote_center", "bh_double_quote_open", "bh_double_quote_close", "bh_double_quote_content", "bh_angle", "bh_angle_center", "bh_angle_open", "bh_angle_close", "bh_angle_content", "bh_c_define", "bh_c_define_center", "bh_c_define_open", "bh_c_define_close", "bh_c_define_content", "bh_curly", "bh_curly_center", "bh_curly_open", "bh_curly_close", "bh_curly_content", "bh_default", "bh_default_center", "bh_default_open", "bh_default_close", "bh_default_content", "bh_single_quote", "bh_single_quote_center", "bh_single_quote_open", "bh_single_quote_close", "bh_single_quote_content", "bh_round", "bh_round_center", "bh_round_open", "bh_round_close", "bh_round_content", "bh_tag", "bh_tag_center", "bh_tag_open", "bh_tag_close", "bh_tag_content", "bh_unmatched", "bh_unmatched_center", "bh_unmatched_open", "bh_unmatched_close", "bh_unmatched_content" ], "incomplete_sync": null, "r_box_status": false, "remote_loading": false, "synced": false, "syntax": "Packages/R-Box/syntax/R Extended.sublime-syntax", "syntax_mgr_loaded": true, "tab_size": 2, "translate_tabs_to_spaces": true }, "translation.x": 0.0, "translation.y": 1390.0, "zoom_level": 1.0 }, "stack_index": 1, "type": "text" }, { "buffer": 6, "file": "/Users/rsaporta/git/orch/src/AppleMusic/Trial Estimates.r", "semi_transient": false, "settings": { "buffer_size": 5244, "regions": { }, "selection": [ [ 0, 0 ] ], "settings": { "BracketHighlighterBusy": false, "bh_regions": [ "bh_c_define", "bh_c_define_center", "bh_c_define_open", "bh_c_define_close", "bh_c_define_content", "bh_round", "bh_round_center", "bh_round_open", "bh_round_close", "bh_round_content", "bh_default", "bh_default_center", "bh_default_open", "bh_default_close", "bh_default_content", "bh_double_quote", "bh_double_quote_center", "bh_double_quote_open", "bh_double_quote_close", "bh_double_quote_content", "bh_single_quote", "bh_single_quote_center", "bh_single_quote_open", "bh_single_quote_close", "bh_single_quote_content", "bh_angle", "bh_angle_center", "bh_angle_open", "bh_angle_close", "bh_angle_content", "bh_tag", "bh_tag_center", "bh_tag_open", "bh_tag_close", "bh_tag_content", "bh_unmatched", "bh_unmatched_center", "bh_unmatched_open", "bh_unmatched_close", "bh_unmatched_content", "bh_square", "bh_square_center", "bh_square_open", "bh_square_close", "bh_square_content", "bh_curly", "bh_curly_center", "bh_curly_open", "bh_curly_close", "bh_curly_content", "bh_regex", "bh_regex_center", "bh_regex_open", "bh_regex_close", "bh_regex_content" ], "incomplete_sync": null, "r_box_status": false, "remote_loading": false, "synced": false, "syntax": "Packages/R-Box/syntax/R Extended.tmLanguage", "syntax_mgr_loaded": true, "tab_size": 2, "translate_tabs_to_spaces": true }, "translation.x": 0.0, "translation.y": 704.0, "zoom_level": 1.0 }, "stack_index": 6, "type": "text" }, { "buffer": 7, "file": "/Users/rsaporta/git/orch/src/AppleMusic/finance data ingest 20151021.r", "semi_transient": false, "settings": { "buffer_size": 1498, "regions": { }, "selection": [ [ 0, 0 ] ], "settings": { "BracketHighlighterBusy": false, "bh_regions": [ "bh_c_define", "bh_c_define_center", "bh_c_define_open", "bh_c_define_close", "bh_c_define_content", "bh_round", "bh_round_center", "bh_round_open", "bh_round_close", "bh_round_content", "bh_default", "bh_default_center", "bh_default_open", "bh_default_close", "bh_default_content", "bh_double_quote", "bh_double_quote_center", "bh_double_quote_open", "bh_double_quote_close", "bh_double_quote_content", "bh_single_quote", "bh_single_quote_center", "bh_single_quote_open", "bh_single_quote_close", "bh_single_quote_content", "bh_angle", "bh_angle_center", "bh_angle_open", "bh_angle_close", "bh_angle_content", "bh_tag", "bh_tag_center", "bh_tag_open", "bh_tag_close", "bh_tag_content", "bh_unmatched", "bh_unmatched_center", "bh_unmatched_open", "bh_unmatched_close", "bh_unmatched_content", "bh_square", "bh_square_center", "bh_square_open", "bh_square_close", "bh_square_content", "bh_curly", "bh_curly_center", "bh_curly_open", "bh_curly_close", "bh_curly_content", "bh_regex", "bh_regex_center", "bh_regex_open", "bh_regex_close", "bh_regex_content" ], "incomplete_sync": null, "r_box_status": false, "remote_loading": false, "synced": false, "syntax": "Packages/R-Box/syntax/R Extended.tmLanguage", "syntax_mgr_loaded": true }, "translation.x": 0.0, "translation.y": 0.0, "zoom_level": 1.0 }, "stack_index": 5, "type": "text" }, { "buffer": 8, "file": "/Users/rsaporta/git/orch/src/Snowflake_Scratch/SF - stages & file format for Apple Music and Spotify [2015-07-07].r", "semi_transient": false, "settings": { "buffer_size": 1400, "regions": { }, "selection": [ [ 0, 0 ] ], "settings": { "BracketHighlighterBusy": false, "bh_regions": [ "bh_regex", "bh_regex_center", "bh_regex_open", "bh_regex_close", "bh_regex_content", "bh_square", "bh_square_center", "bh_square_open", "bh_square_close", "bh_square_content", "bh_double_quote", "bh_double_quote_center", "bh_double_quote_open", "bh_double_quote_close", "bh_double_quote_content", "bh_angle", "bh_angle_center", "bh_angle_open", "bh_angle_close", "bh_angle_content", "bh_c_define", "bh_c_define_center", "bh_c_define_open", "bh_c_define_close", "bh_c_define_content", "bh_curly", "bh_curly_center", "bh_curly_open", "bh_curly_close", "bh_curly_content", "bh_default", "bh_default_center", "bh_default_open", "bh_default_close", "bh_default_content", "bh_single_quote", "bh_single_quote_center", "bh_single_quote_open", "bh_single_quote_close", "bh_single_quote_content", "bh_round", "bh_round_center", "bh_round_open", "bh_round_close", "bh_round_content", "bh_tag", "bh_tag_center", "bh_tag_open", "bh_tag_close", "bh_tag_content", "bh_unmatched", "bh_unmatched_center", "bh_unmatched_open", "bh_unmatched_close", "bh_unmatched_content" ], "incomplete_sync": null, "remote_loading": false, "synced": false, "syntax": "Packages/R-Box/syntax/R Extended.tmLanguage", "syntax_mgr_loaded": true }, "translation.x": 0.0, "translation.y": 0.0, "zoom_level": 1.0 }, "stack_index": 4, "type": "text" } ] } ], "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.find_results": { "height": 256.0 }, "output.git-commit": { "height": 88.0 }, "output.git-pull": { "height": 88.0 }, "output.git-push": { "height": 88.0 }, "output.sftp": { "height": 0.0 }, "pinned_build_system": "", "project": "AppleMusic.sublime-project", "replace": { "height": 64.0 }, "save_all_on_build": true, "select_file": { "height": 0.0, "last_filter": "", "selected_items": [ [ "r", "Run For Rick Please.txt" ], [ "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" ] ], "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": true, "show_tabs": true, "side_bar_visible": false, "side_bar_width": 263.0, "status_bar_visible": true, "template_settings": { } }