{ "auto_complete": { "selected_items": [ [ "file_", "file.last_emailed" ], [ "prco", "processdaytime" ], [ "colsTo", "colsToPull" ], [ "proce", "processed_max" ], [ "proc", "processed_max" ], [ "pro_", "processed_max" ], [ "DT_", "DT_redshift" ], [ "rouw", "rowCount1" ], [ "colsT", "colsToPull" ], [ "DT.a", "DT.anal.monthly" ], [ "DT.", "DT.acc.monthly" ], [ "acti", "activity_month" ], [ "setkey", "setkeyIfNot" ], [ "Act", "Activity_Month" ], [ "act", "activity_month_date" ], [ "file", "filetype" ], [ "acit", "activity_month_date" ], [ "assi", "assignToEnvir" ], [ "DT.sp", "DT.Spot_ASR_Revenue.molt" ], [ "kC", "kCols.DateGrp" ], [ "T", "TOTAL" ], [ "G", "Grand" ], [ "TR", "transac_type_abbr" ], [ "Group", "Grouping2" ], [ "DT.s", "DT.Spot_ASR_Revenue" ], [ "XL", "XLStoDT" ], [ "ms", "msg.email" ], [ "sche", "schema" ], [ "cluster", "cluster.out" ], [ "upda", "updateDeNormTable" ], [ "fold", "folder_rel_to_src" ], [ "tbl.f", "tbl.fact" ], [ "fact_", "fact_analytics" ], [ "prod", "production" ], [ "gsub", "gsubQry" ], [ "QRY", "QRY.create" ], [ "match", "extractMatch" ], [ "updat", "Update" ], [ "proj", "projName" ], [ "DT.val", "DT.validate.fact" ], [ "DT.va", "DT.validate.fact" ], [ "DT.r", "DT.rowcounts.fact" ], [ "aggregated", "aggregated_analytics" ], [ "cols", "colsToCompare.ratio" ], [ "DT.row", "DT.rowcounts.aggd" ], [ "do", "download_activity_date" ], [ "qry", "qry_03_AN" ], [ "tbl", "tbl.tmp" ], [ "schem", "schemaPaste" ], [ "failed", "failedValidation" ], [ "produc", "production.fact_analytics" ], [ "DT.vali", "DT.validate.fact" ], [ "sch", "schema" ], [ "dayi", "dayidTodate" ], [ "day", "dayidTodate" ], [ "mind", "minDayIdUsing" ], [ "st", "storeids.to.check" ], [ "production.", "production.fact_analytics" ], [ "aggreg", "aggregated_analytics" ], [ "schema.", "schema.new" ], [ "aggre", "aggregated_analytics" ], [ "tb", "tbl.tmp" ], [ "sc", "schema" ], [ "sce", "schemaPaste" ], [ "buck", "bucket.todelete" ], [ "has", "hasRows" ], [ "conf", "confirm_dates" ], [ "verbose", "verboseMsg" ], [ "verbo", "verboseMsg" ], [ "tr", "truncate.if.exist" ], [ "del", "delim" ], [ "is.c", "is.char_of_length1" ], [ "is", "is_l1" ], [ "trac", "track_type" ], [ "clu.", "cluster.out" ], [ "remove", "removeNA" ], [ "files", "files_to_source" ], [ "grol", "grossCol.reported" ], [ "DT.GL_fo", "DT.GL_forecasted.merged" ], [ "gro", "grossCol.reported" ], [ "DT.re", "DT.reported" ], [ "date", "dateCol" ], [ "igno", "ignoreCols" ], [ "ver", "verbose.qry.oa" ], [ "table", "tableExists" ], [ "orig", "orig.cluster" ], [ "blan", "blankCols" ], [ "new", "newCols" ], [ "cr", "current" ], [ "folder", "folder.zArchive" ], [ "exp", "expectedCols" ], [ "expe", "expectedRows" ], [ "not", "notifyRick.FileIngestionFailed" ], [ "expect", "expectedCols" ], [ "DT.m", "DT.monthlyforecasts" ], [ "days", "daysFromTarget" ], [ "round", "roundOutToX" ], [ "fake", "fakeToday" ], [ "fore", "forecasted_gross" ], [ "DT.cl", "DT.cleaned.aggd" ], [ "store", "store_musicbucket" ], [ "run", "thisRunIsAForecast" ], [ "store_", "store_musicsuperbucket" ], [ "add", "addSuperBucket_" ], [ "DT", "DT.cleaned" ], [ "kc", "kCols.smry" ], [ "DT.clea", "DT.cleaned" ], [ "ignore", "ignoreFails" ], [ "TRE", "TRUE" ], [ "skipp", "skip.patterns" ], [ "DT.rev", "DT.rev_summary" ], [ "acc", "accounting_month" ], [ "attr", "attributes" ], [ "max", "maxDate" ], [ "dt", "DT.acc" ], [ "l.by", "l.byName" ], [ "l.b", "l.byName" ], [ "dateCols.", "dateCols.byName" ], [ "dateC", "dateCols" ], [ "sbu", "subl" ], [ "post", "postfix" ], [ "Res", "BackUpOrRestore" ], [ "skip", "skip_ingest" ], [ "kcols", "kCols.datestore" ], [ "kcols.", "kCols.smry" ], [ "sto_b", "store_videobucket" ], [ "kCol.s", "kCols.smry" ], [ "DT.cle", "DT.cleaned.aggd" ] ] }, "buffers": [ { "contents": "TODO -- forecast iTunes using basic priors\n\n\n(1) Analytics Total --> (2) Activity Total\n (2) Activity Total --> (3) Accounting Total (ie When will it book)\n\n", "file": "/Users/rsaporta/git/orch/src/Acc_vs_Anal_2015/##TODO.r", "file_size": 183, "file_write_time": 130969953080000000, "settings": { "buffer_size": 181, "line_ending": "Unix" } }, { "file": "/Users/rsaporta/git/orch/src/Acc_vs_Anal_2015/Accounting - missing transaction types 2015.r", "settings": { "buffer_size": 3502, "line_ending": "Unix" } }, { "file": "/Users/rsaporta/git/orch/src/Acc_vs_Anal_2015/staging_table_row_count.r", "settings": { "buffer_size": 1748, "line_ending": "Unix" } } ], "build_system": "", "build_system_choices": [ ], "build_varint": "", "command_palette": { "height": 307.0, "last_filter": "", "selected_items": [ [ "path", "File: Copy Path" ], [ "minim", "View: Toggle Minimap" ], [ "mini", "Pretty JSON: Minify (compress) JSON" ], [ "reve", "File: Reveal" ], [ "push", "Git: Push" ], [ "qui", "Git: Quick Commit Current File" ], [ "pull", "Git: Pull" ], [ "Rex", "Set Syntax: R Extended" ], [ "wo", "Word Wrap: Toggle" ], [ "filen", "File: Copy Name" ], [ "wor", "Word Wrap: Toggle" ], [ "rena", "File: Rename" ], [ "qu", "Git: Quick Commit Current File" ], [ "rex", "Set Syntax: R Extended" ], [ "rext", "Set Syntax: R Extended" ], [ "Rap", "R Application Switch" ], [ "word", "Word Wrap: Toggle" ], [ "file", "File: Copy Name" ], [ "ren", "File: Rename" ], [ "enh", "Set Syntax: Enhanced-R" ], [ "rap", "R Application Switch" ], [ "psu", "Git: Push" ], [ "quic", "Git: Quick Commit Current File" ], [ "pus", "Git: Push" ], [ "pat", "File: Copy Path" ], [ "pul", "Git: Pull" ], [ "quci", "Git: Quick Commit Current File" ], [ "ra", "R Application Switch" ], [ "ush", "SublimeREPL: Shell" ], [ "dele", "File: Delete" ], [ "del", "File: Delete" ], [ "psuh", "Git: Push" ], [ "puh", "Git: Push" ], [ "quick", "Git: Quick Commit Current File" ], [ "disable pack", "Package Control: Disable Package" ], [ "disa", "Package Control: Disable Package" ], [ "sql", "Set Syntax: SQL" ], [ "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" ], [ "com cu", "Git: Quick Commit Current File" ], [ "addcu", "Git: Add Current File" ], [ "quicad", "Git: Quick Add" ], [ "move", "File: Move" ], [ "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" ], [ "add cu", "Git: Add Current File" ], [ "enha", "Set Syntax: Enhanced-R" ], [ "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" ], [ "branch", "Git: Checkout New Branch" ], [ "new br", "Git: Checkout New Branch" ], [ "branc", "Git: Checkout New Branch" ], [ "copy", "File: Copy Name" ], [ "add", "Git: Add Current File" ], [ "RENA", "File: Rename" ], [ "ADD", "Git: Add Current File" ], [ "copnam", "File: Copy Name" ], [ "q", "Git: Quick Add" ], [ "renam", "File: Rename" ], [ "rapp", "R Application Switch" ], [ "rep", "SublimeREPL: PHP" ], [ "enhg", "BracketHighlighter: Select Next Attribute (right)" ], [ "en", "Set Syntax: Enhanced-R" ], [ "WOR", "Word Wrap: Toggle" ], [ "pu", "Git: Push" ], [ "r", "R Application Switch" ], [ "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" ], [ "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" ], [ "git qu", "Git: Quick Commit" ], [ "git pus", "Git: Push" ], [ "quic ", "Git: Quick Commit" ], [ "git qui", "Git: Quick Commit" ], [ "gi qui", "Git: Quick Commit" ], [ "git push", "Git: Push" ], [ "git q", "Git: Quick Commit" ], [ "wro", "Word Wrap: Toggle" ], [ "git diff", "Git: Diff Current File" ], [ "git com", "Git: Commit" ], [ "package", "Package Control: List Packages" ], [ "upgra", "Package Control: Upgrade/Overwrite All Packages" ], [ "upgr", "Package Control: Upgrade Package" ], [ "install", "Package Control: Install Package" ], [ "update", "Package Control: Upgrade/Overwrite All Packages" ] ], "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/Acc_vs_Anal_2015", "/Users/rsaporta/git/orch/notes/Acc_vs_Anal_2015", "/Users/rsaporta/git/orch/plots/Acc_vs_Anal_2015", "/Users/rsaporta/git/orch/out/Acc_vs_Anal_2015" ], "file_history": [ "/Users/rsaporta/git/misc/rscripts/utils/DB_Utils/DB_Utils.r", "/Users/rsaporta/git/orch/src/dbconcile/jira ticket 2015-03-03.txt", "/Users/rsaporta/git/!Projects/dbconcile.sublime-project", "/Users/rsaporta/git/orch/src/dbconcile/snowflake_check_20150707.r", "/Users/rsaporta/git/orch/src/dbconcile/supportFns/compare_snowflake_to_redshift.r", "/Users/rsaporta/Desktop/setting time zone on remote machine.txt", "/Users/rsaporta/git/misc/rscripts/utilsRS.r", "/Users/rsaporta/git/orch/src/dbconcile/TEST.r", "/Users/rsaporta/git/misc/rscripts/utils/setPrompt.r", "/Users/rsaporta/git/orch/src/dbconcile/Spot 01 Ingest.r", "/Users/rsaporta/development/deleteme/.git/config", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/Spotify_Raw_Analytics_Files.r", "/Users/rsaporta/git/misc/rscripts/utils/xls/xls_utils.r", "/Users/rsaporta/git/orch/src/spot.cleanGrouping_.r", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables_new/Create All Views.r", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables_new/Views/country_view.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/zCleanTheseUp/AggregatedTables 140902/iTunes RED USA check.r", "/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/chartio/Create GPU Table from analytics.r", "/Users/rsaporta/git/orch/src/MgmtReport/GL Automation - Mgmt Report Ingestion.r", "/Users/rsaporta/git/orch/src/automate new.r", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt0_a Workspace Setup.r", "/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/GL_pt1_a Import OA from DB Querying Aggregated Tables.r", "/Users/rsaporta/git/orch/src/MgmtReport/supportFns/findMaxDate.r", "/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_pt2_ZZ Join Cols and Export.r", "/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/create_and_ingest_DT.MgmtReport_months_reported.r", "/Users/rsaporta/git/orch/src/GL Automation - forecasting.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/!! TODO", "/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/supportFns/calculateSplitPercentages.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", "/Users/rsaporta/git/orch/src/MgmtReport/supportFns/addSuperBucket.r", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt2_b Create mgmtr_summary_tall from GL_Summaries.r", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt2_d Create DT.adjustments for rbinding.r", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt2_c Create DT.merged, Split & Expand.r", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt1_d Ingest Manual Tempalte worksheets.r", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt2_e Create DT.ancillary_with_forecasts.r", "/Users/rsaporta/git/git_branch_merge_HOWTO.txt", "/Users/rsaporta/git/orch/src/MgmtReport/supportFns/forecastByDateStore.r", "/Users/rsaporta/git/orch/src/MgmtReport/supportFns/split_indexCol_byPercentages.r", "/Users/rsaporta/git/orch/src/MgmtReport/supportFns/jesusForData_Forecasting.r", "/Users/rsaporta/git/orch/src/MgmtReport/supportFns/createSummaryOfAggTables.r", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt2_c Create DT.merged, Split ", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt2_ZZ Join Cols and Ingest.r", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt2_a Create GL_summaries.r", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt3_aaaa TODO.r", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt3_b Create Wide mgmtr_summary from mgmtr_summary_tall.r", "/Users/rsaporta/git/orch/src/MgmtReport/SCRATCH - sum vs sumn for DT.cleaned.OSC check.r", "/Users/rsaporta/git/orch/src/MgmtReport/SCRATCH - GL_pt3_a Create DT.manl_crop.r", "/Users/rsaporta/git/orch/src/MgmtReport/supportFns/dictionaries for MgmtReport.r", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt2_c Split & Expand {NEW}.r", "/Users/rsaporta/git/orch/src/MgmtReport/DT Descriptions.r", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt1_e Ingest RED and OSC percentages.r", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt2_c Split & Expand {z ADDITIONAL FROM new expand}.r", "/Users/rsaporta/git/orch/src/MgmtReport/SCRATCH - GL_pt2_02 (NEW II) Split_on_Several.r", "/Users/rsaporta/git/orch/src/MgmtReport/SCRATCH - GL_pt2_c Split revenue by Subgroups - new expand.r", "/Users/rsaporta/git/orch/src/MgmtReport/Scratch - GL_pt2_c Split revenue by Subgroups.r", "/Users/rsaporta/git/orch/src/MgmtReport/supportFns/TODO.txt", "/Users/rsaporta/git/orch/src/MgmtReport/zArchive - Old Splits/GL_pt2_02 (NEW) Split_on_Several.r", "/Users/rsaporta/git/orch/src/MgmtReport/zArchive - Old Splits/GL_pt2_c Split revenue by Subgroups (old - with NAs).r", "/Users/rsaporta/git/orch/src/MgmtReport/supportFns/permeate.r", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt2_c Split revenue by Subgroups.r", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt2", "/tmp/subl stdin fl131c.txt", "/Users/rsaporta/git/orch/new", "/Users/rsaporta/git/orch/method", "/Users/rsaporta/git/orch/src/MgmtReport/-", "/Users/rsaporta/git/orch/expanding", "/Users/rsaporta/git/orch/before", "/Users/rsaporta/git/orch/merge.r", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt2 - new method - expanding before merge.r", "/Users/rsaporta/git/orch/src/MgmtReport/SCRATCH - calculatePercentage_and_FillWithAvg_.r", "/Users/rsaporta/git/orch/src/MgmtReport/SCRATCH - expand_SC_using_defaultMetaValues.r", "/Users/rsaporta/git/orch/src/MgmtReport/supportFns/fill_NA_with_ma.r" ], "find": { "height": 35.0 }, "find_in_files": { "height": 93.0, "where_history": [ "" ] }, "find_state": { "case_sensitive": false, "find_history": [ ", cluster = 9", "file.email_marker_last_failed", "send_email_when_ok", "emailGroup_if_OK", "label_is_dthree", "file.email_marker", "file.last_emailed", "db", "maxDate", "maxDate ", "maxdate", "processed_max", "<=", "proce", "snowflake_dbname", "DT_snowflake", "DT_redshift", "suffix", "rowCount2", "rowcount1", "starToCount", "colNamesFromVector", "colsToAgg", "suffixes", "DT.cluster", "DT2", "DT1", "clusters", "setprompt", "qry.acc.daily", "dlFilesFromFTP", "DT.Spot_ASR_GPU", " DT.Spot_ASR_GPU", "Size.localFile", "tight.output", "drop.empty.sheets", "c(\"Grouping\", \"transac_type_abbr\")", "monthly", "DT.acc.daily", "cluster", "tbl.tmp", "stamp", "aggregated", "update", "tbl.tmp", "rename", "updateDeNormTable", "verbose.max.lines", "updateDeNormTable", "gsub", "last_file", "aggregated_", "findMaxDate", "browser", "Tbl.final", "tbl", "bucket", "tbl.old", "qRena", "reset", "fresh", "reset", "delete", "bucket", "tbl.tmp", "\n ", "whichColsCanBeInteger", "\\s+THEN", "schema.tmp", "storeid", "outter", "03_AN", "storeid as store", "confirm_dates", "schemaPaste(schema=schema, tbl)", "schemaPaste(schema, tbl=tbl)", "\\'", "gest", "TR.", "Music", "track", "max_date", "tmp.perc_to_add", "OA_ZeroMonth_forDS := ", "OA_ZeroMonth_forDS", "DT.merged", "CONFIRM: No NAs in GL_gro", "DT.merged[(!ignoreFails)]", "findMax", "reported", "DT.calculated", "accounting_months", "dropCurrentTable.manualnumbs", "FORECASTS", "jesusForData_forecasting", "cleaned.aggd", "mgmt_", "ingest", "total", "verbose.qry.oa", "DB", "cluster", "create", "year", "revenue", "as.path", "dir.create", "f.in", "\n ", "jesus", "set", "DB", "kCols.smry", "kcols.smry", "source", "bucket", "split_indexCol_byPercentages", "bucket", "DT.group_subtotals_from_rev_summary", "bucket", "addsuper", "bucket", "addsuper", "bucket", "addsuper", "bucket", "zUncategorized Store", "ignoreFAil" ], "highlight": true, "in_selection": false, "preserve_case": false, "regex": false, "replace_history": [ "file.email_marker", "file.last_emailed", "processed_lessthan", "processed_max", "DT.snowflake", "DT.redshift", "rowcount.sf", "rowcount.rs", "nms_of_colsToAgg", "DT.compare", "DT.cluster", "DT_snowflake", "DT_redshift", "DT1", "cluster", "clusters", "size.localFile", "Size.localFile", "kCols.Grp", "DT.acc.monthly", "DT.acc.daily", "", " 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", "perc_split_statement", "is.na(music_vs_video)", "is.na(label_sc_group)", "DT.mgmtr_summary_tall", "DT.mgmtr_summary_tall2", "indexCol", "Service", "split_OSC_to_Allegro_SelectO", "temp.DT_retailvid", "kCols.SC_date", "skip_exportOfBudget", "kCols.SC_date", "2013-01-01", "temp_DT.splitCols_expanded", "dict.rev_summary_meta", "skip_query" ], "reverse": false, "show_context": false, "use_buffer2": false, "whole_word": false, "wrap": true }, "groups": [ { "selected": 2, "sheets": [ { "buffer": 0, "file": "/Users/rsaporta/git/orch/src/Acc_vs_Anal_2015/##TODO.r", "semi_transient": false, "settings": { "buffer_size": 181, "regions": { }, "selection": [ [ 181, 181 ] ], "settings": { "BracketHighlighterBusy": false, "bh_regions": [ "bh_angle", "bh_angle_center", "bh_angle_open", "bh_angle_close", "bh_angle_content", "bh_curly", "bh_curly_center", "bh_curly_open", "bh_curly_close", "bh_curly_content", "bh_double_quote", "bh_double_quote_center", "bh_double_quote_open", "bh_double_quote_close", "bh_double_quote_content", "bh_default", "bh_default_center", "bh_default_open", "bh_default_close", "bh_default_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_unmatched", "bh_unmatched_center", "bh_unmatched_open", "bh_unmatched_close", "bh_unmatched_content", "bh_single_quote", "bh_single_quote_center", "bh_single_quote_open", "bh_single_quote_close", "bh_single_quote_content", "bh_c_define", "bh_c_define_center", "bh_c_define_open", "bh_c_define_close", "bh_c_define_content", "bh_square", "bh_square_center", "bh_square_open", "bh_square_close", "bh_square_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, "word_wrap": true }, "translation.x": 0.0, "translation.y": 0.0, "zoom_level": 1.0 }, "stack_index": 2, "type": "text" }, { "buffer": 1, "file": "/Users/rsaporta/git/orch/src/Acc_vs_Anal_2015/Accounting - missing transaction types 2015.r", "semi_transient": false, "settings": { "buffer_size": 3502, "regions": { }, "selection": [ [ 295, 295 ] ], "settings": { "BracketHighlighterBusy": false, "bh_regions": [ "bh_angle", "bh_angle_center", "bh_angle_open", "bh_angle_close", "bh_angle_content", "bh_curly", "bh_curly_center", "bh_curly_open", "bh_curly_close", "bh_curly_content", "bh_double_quote", "bh_double_quote_center", "bh_double_quote_open", "bh_double_quote_close", "bh_double_quote_content", "bh_default", "bh_default_center", "bh_default_open", "bh_default_close", "bh_default_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_unmatched", "bh_unmatched_center", "bh_unmatched_open", "bh_unmatched_close", "bh_unmatched_content", "bh_single_quote", "bh_single_quote_center", "bh_single_quote_open", "bh_single_quote_close", "bh_single_quote_content", "bh_c_define", "bh_c_define_center", "bh_c_define_open", "bh_c_define_close", "bh_c_define_content", "bh_square", "bh_square_center", "bh_square_open", "bh_square_close", "bh_square_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": 1, "type": "text" }, { "buffer": 2, "file": "/Users/rsaporta/git/orch/src/Acc_vs_Anal_2015/staging_table_row_count.r", "semi_transient": false, "settings": { "buffer_size": 1748, "regions": { }, "selection": [ [ 1748, 1748 ] ], "settings": { "BracketHighlighterBusy": false, "bh_regions": [ "bh_angle", "bh_angle_center", "bh_angle_open", "bh_angle_close", "bh_angle_content", "bh_curly", "bh_curly_center", "bh_curly_open", "bh_curly_close", "bh_curly_content", "bh_double_quote", "bh_double_quote_center", "bh_double_quote_open", "bh_double_quote_close", "bh_double_quote_content", "bh_default", "bh_default_center", "bh_default_open", "bh_default_close", "bh_default_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_unmatched", "bh_unmatched_center", "bh_unmatched_open", "bh_unmatched_close", "bh_unmatched_content", "bh_single_quote", "bh_single_quote_center", "bh_single_quote_open", "bh_single_quote_close", "bh_single_quote_content", "bh_c_define", "bh_c_define_center", "bh_c_define_open", "bh_c_define_close", "bh_c_define_content", "bh_square", "bh_square_center", "bh_square_open", "bh_square_close", "bh_square_content", "bh_regex", "bh_regex_center", "bh_regex_open", "bh_regex_close", "bh_regex_content" ], "incomplete_sync": null, "r_box_status": false, "syntax": "Packages/R-Box/syntax/R Extended.tmLanguage", "syntax_mgr_loaded": true, "word_wrap": true }, "translation.x": 0.0, "translation.y": 0.0, "zoom_level": 1.0 }, "stack_index": 0, "type": "text" } ] } ], "incremental_find": { "height": 22.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": 553.0 }, "output.sftp": { "height": 0.0 }, "pinned_build_system": "", "project": "Acc_vs_Anal_2015.sublime-project", "replace": { "height": 40.0 }, "save_all_on_build": true, "select_file": { "height": 0.0, "last_filter": "", "selected_items": [ [ "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": true, "show_tabs": true, "side_bar_visible": false, "side_bar_width": 445.0, "status_bar_visible": true, "template_settings": { } }