{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Question","Try","FlashFill","Bill","Mike","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Question","index":0,"n_rows":32,"n_cols":4,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Fund﻿ NameTickerNet FlowsDetails","Fund Name","Ticker","Price"]
["SPDR S&P 500 SPY 4,764.58","SPDR S&P 500","SPY",4764.58]
["iShares MSCI Emerging Markets EEM 2,673.52","iShares MSCI Emerging Markets","EEM",2673.52]
["iShares Russell 2000 IWM 910.17","iShares Russell 2000","IWM",910.17]
["PowerShares QQQ QQQ 600.83","PowerShares QQQ","QQQ",600.83000000000004]
["Market Vectors Gold Miners GDX 559.23","Market Vectors Gold Miners","GDX",559.23]
["Industrial Select SPDR XLI 521.68","Industrial Select SPDR","XLI",521.67999999999995]
["iShares MSCI Brazil Capped EWZ 484.01","iShares MSCI Brazil Capped","EWZ",484.01]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["SPDR S&P 500 SPY 4,764.58","SPDR S&P 500","SPY",4764.58]
["iShares MSCI Emerging Markets EEM 2,673.52","iShares MSCI Emerging Markets","EEM",2673.52]
["iShares Russell 2000 IWM 910.17","iShares Russell 2000","IWM",910.17]
["PowerShares QQQ QQQ 600.83","PowerShares QQQ","QQQ",600.83000000000004]
["Market Vectors Gold Miners GDX 559.23","Market Vectors Gold Miners","GDX",559.23]
["Industrial Select SPDR XLI 521.68","Industrial Select SPDR","XLI",521.67999999999995]
["iShares MSCI Brazil Capped EWZ 484.01","iShares MSCI Brazil Capped","EWZ",484.01]

{"sheet":"Try","index":1,"n_rows":19,"n_cols":1,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Fund﻿ NameTickerNet FlowsDetails"]
["SPDR S&P 500 SPY 4,764.58"]
["iShares MSCI Emerging Markets EEM 2,673.52"]
["iShares Russell 2000 IWM 910.17"]
["PowerShares QQQ QQQ 600.83"]
["Market Vectors Gold Miners GDX 559.23"]
["Industrial Select SPDR XLI 521.68"]
["iShares MSCI Brazil Capped EWZ 484.01"]
[]
[]
[]
["Fund﻿ NameTickerNet FlowsDetails"]
["SPDR S&P 500 SPY 4,764.58"]
["iShares MSCI Emerging Markets EEM 2,673.52"]
["iShares Russell 2000 IWM 910.17"]
["PowerShares QQQ QQQ 600.83"]
["Market Vectors Gold Miners GDX 559.23"]
["Industrial Select SPDR XLI 521.68"]
["iShares MSCI Brazil Capped EWZ 484.01"]

{"sheet":"FlashFill","index":2,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Fund﻿ NameTickerNet FlowsDetails"]
["SPDR S&P 500 SPY 4,764.58","SPDR S&P 500","SPY",4764.58]
["iShares MSCI Emerging Markets EEM 2,673.52","iShares MSCI Emerging Markets","EEM",2673.52]
["iShares Russell 2000 IWM 910.17","iShares Russell 2000","IWM",910.17]
["PowerShares QQQ QQQ 600.83","PowerShares QQQ","QQQ",600.83000000000004]
["Market Vectors Gold Miners GDX 559.23","Market Vectors Gold Miners","GDX",559.23]
["Industrial Select SPDR XLI 521.68","Industrial Select SPDR","XLI",521.67999999999995]
["iShares MSCI Brazil Capped EWZ 484.01","iShares MSCI Brazil Capped","EWZ",484.01]

{"sheet":"Bill","index":3,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Fund﻿ NameTickerNet FlowsDetails"]
["SPDR S&P 500 SPY 4,764.58","SPDR S&P 500","SPY",4764.58]
["iShares MSCI Emerging Markets EEM 2,673.52","iShares MSCI Emerging Markets","EEM",2673.52]
["iShares Russell 2000 IWM 910.17","iShares Russell 2000","IWM",910.17]
["PowerShares QQQ QQQ 600.83","PowerShares QQQ","QQQ",600.83000000000004]
["Market Vectors Gold Miners GDX 559.23","Market Vectors Gold Miners","GDX",559.23]
["Industrial Select SPDR XLI 521.68","Industrial Select SPDR","XLI",521.67999999999995]
["iShares MSCI Brazil Capped EWZ 484.01","iShares MSCI Brazil Capped","EWZ",484.01]

{"sheet":"Mike","index":4,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Fund﻿ NameTickerNet FlowsDetails","Fund","Ticker","Number",null,null,null,"Ticker","Number"]
["SPDR S&P 500 SPY 4,764.58",{"$f":"SUBSTITUTE(A2,\" \"&C2&\" \"&D2,\"\")","v":"SPDR S&P 500"},{"$f":"RIGHT(SUBSTITUTE(A2,\" \"&D2,\"\"),3)","v":"SPY"},{"$f":"REPLACE(A2,1,SEARCH(\"^\",SUBSTITUTE(A2,\" \",\"^\",LEN(A2)-LEN(SUBSTITUTE(A2,\" \",\"\")))),\"\")","v":"4,764.58"},null,"If number in D2, then >>",null,{"$f":"RIGHT(SUBSTITUTE(A2,\" \"&TEXT(I2,\"#,0.00\"),\"\"),3)","v":"SPY"},{"$f":"REPLACE(A2,1,SEARCH(\"^\",SUBSTITUTE(A2,\" \",\"^\",LEN(A2)-LEN(SUBSTITUTE(A2,\" \",\"\")))),\"\")+0","v":4764.58}]
["iShares MSCI Emerging Markets EEM 2,673.52",{"$f":"SUBSTITUTE(A3,\" \"&C3&\" \"&D3,\"\")","v":"iShares MSCI Emerging Markets"},{"$f":"RIGHT(SUBSTITUTE(A3,\" \"&D3,\"\"),3)","v":"EEM"},{"$f":"REPLACE(A3,1,SEARCH(\"^\",SUBSTITUTE(A3,\" \",\"^\",LEN(A3)-LEN(SUBSTITUTE(A3,\" \",\"\")))),\"\")","v":"2,673.52"},null,null,null,{"$f":"RIGHT(SUBSTITUTE(A3,\" \"&TEXT(I3,\"#,0.00\"),\"\"),3)","v":"EEM"},{"$f":"REPLACE(A3,1,SEARCH(\"^\",SUBSTITUTE(A3,\" \",\"^\",LEN(A3)-LEN(SUBSTITUTE(A3,\" \",\"\")))),\"\")+0","v":2673.52}]
["iShares Russell 2000 IWM 910.17","iShares Russell 2000","IWM","910.17",null,null,null,"IWM",910.17]
["PowerShares QQQ QQQ 600.83","PowerShares QQQ","QQQ","600.83",null,null,null,"QQQ",600.83000000000004]
["Market Vectors Gold Miners GDX 559.23","Market Vectors Gold Miners","GDX","559.23",null,null,null,"GDX",559.23]
["Industrial Select SPDR XLI 521.68","Industrial Select SPDR","XLI","521.68",null,null,null,"XLI",521.67999999999995]
["iShares MSCI Brazil Capped EWZ 484.01","iShares MSCI Brazil Capped","EWZ","484.01",null,null,null,"EWZ",484.01]
[null,null,null,null,null,null,"Max"]
[null,null,null,null,null,null,{"$f":"MAX(G12:G18)","v":5}]
["Fund﻿ NameTickerNet FlowsDetails","Fund","Ticker","Number"]
["SPDR S&P 500 SPY 4,764.58","SPDR S&P 500","SPY",4764.58,null,null,{"$f":"LEN(A12)-LEN(SUBSTITUTE(A12,\" \",\"\"))","v":4}]
["iShares MSCI Emerging Markets EEM 2,673.52","iShares MSCI Emerging Markets","EEM",2673.52,null,null,{"$f":"LEN(A13)-LEN(SUBSTITUTE(A13,\" \",\"\"))","v":5}]
["iShares Russell 2000 IWM 910.17","iShares Russell 2000","IWM",910.17,null,null,4]
["PowerShares QQQ QQQ 600.83","PowerShares QQQ","QQQ",600.83000000000004,null,null,3]
["Market Vectors Gold Miners GDX 559.23","Market Vectors Gold Miners","GDX",559.23,null,null,5]
["Industrial Select SPDR XLI 521.68","Industrial Select SPDR","XLI",521.67999999999995,null,null,4]
["iShares MSCI Brazil Capped EWZ 484.01","iShares MSCI Brazil Capped","EWZ",484.01,null,null,5]

{"sheet":"Sheet3","index":5,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Fund﻿ NameTickerNet FlowsDetails","Fund","Ticker","Number"]
["SPDR S&P 500 SPY 4,764.58",{"$f":"LEFT(A2,SEARCH(C2&\" \"&D2,A2)-2)","v":"SPDR S&P 500"},{"$f":"RIGHT(TRIM(SUBSTITUTE(A2,D2,\"\")),3)","v":"SPY"},{"$f":"REPLACE(A2,1,SEARCH(\"#\",SUBSTITUTE(A2,\" \",\"#\",LEN(A2)-LEN(SUBSTITUTE(A2,\" \",\"\")))),\"\")","v":"4,764.58"}]
["iShares MSCI Emerging Markets EEM 2,673.52",{"$f":"LEFT(A3,SEARCH(C3&\" \"&D3,A3)-2)","v":"iShares MSCI Emerging Markets"},{"$f":"RIGHT(TRIM(SUBSTITUTE(A3,D3,\"\")),3)","v":"EEM"},{"$f":"REPLACE(A3,1,SEARCH(\"#\",SUBSTITUTE(A3,\" \",\"#\",LEN(A3)-LEN(SUBSTITUTE(A3,\" \",\"\")))),\"\")","v":"2,673.52"}]
["iShares Russell 2000 IWM 910.17","iShares Russell 2000","IWM","910.17"]
["PowerShares QQQ QQQ 600.83","PowerShares QQQ","QQQ","600.83"]
["Market Vectors Gold Miners GDX 559.23","Market Vectors Gold Miners","GDX","559.23"]
["Industrial Select SPDR XLI 521.68","Industrial Select SPDR","XLI","521.68"]
["iShares MSCI Brazil Capped EWZ 484.01","iShares MSCI Brazil Capped","EWZ","484.01"]
[null,null,null,null,null,"Max"]
[null,null,null,null,null,{"$f":"MAX(F12:F18)","v":5}]
["Fund﻿ NameTickerNet FlowsDetails","Fund","Ticker","Number"]
["SPDR S&P 500 SPY 4,764.58","SPDR S&P 500","SPY",4764.58,null,{"$f":"LEN(A12)-LEN(SUBSTITUTE(A12,\" \",\"\"))","v":4}]
["iShares MSCI Emerging Markets EEM 2,673.52","iShares MSCI Emerging Markets","EEM",2673.52,null,{"$f":"LEN(A13)-LEN(SUBSTITUTE(A13,\" \",\"\"))","v":5}]
["iShares Russell 2000 IWM 910.17","iShares Russell 2000","IWM",910.17,null,4]
["PowerShares QQQ QQQ 600.83","PowerShares QQQ","QQQ",600.83000000000004,null,3]
["Market Vectors Gold Miners GDX 559.23","Market Vectors Gold Miners","GDX",559.23,null,5]
["Industrial Select SPDR XLI 521.68","Industrial Select SPDR","XLI",521.67999999999995,null,4]
["iShares MSCI Brazil Capped EWZ 484.01","iShares MSCI Brazil Capped","EWZ",484.01,null,5]