{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Clean()","Trim()","Substitute","Value"],"read":"whole","date_system":"1900"}

{"sheet":"Clean()","index":0,"n_rows":13,"n_cols":10,"rows_kept":13}
[null,"Step 1",{"$nulls":7},"Step 2"]
[]
[null,"Product"]
[null,"\u0014PROGRAF"]
[null,"\u0014PARIET",{"$nulls":7},"Staffing Data"]
[null,"\u0014CONCERTA",{"$nulls":7},"Eric_Johnson_johnson.eric@company.com_Manager"]
[null,"\u0014LEUSTATIN",{"$nulls":7},"John_Smith_john.smith@company.com_Director"]
[null,"\u0014VELCADE",{"$nulls":7},"Beth_Summers_beth.summers@company.com_associate"]
[null,"\u0014LEUSTATIN",{"$nulls":7},"Miles_Peterson_Miles.peterson@company.com_Partner"]
[null,"\u0014VELCADE",{"$nulls":7},"Jenna_Stone_Jenne.Stone@company.com_Manager"]
[{"$nulls":9},"Quinn_Cook_Quinn.Cook@company.com_Manager"]
[]
[null,"Product"]

{"sheet":"Trim()","index":1,"n_rows":15,"n_cols":2,"rows_kept":15}
[]
[]
[]
[null,"Product Detail"]
[null,"PROGRAF 5MG 50CAPSULAS PROIBID"]
[null,"PARIET     20 MG 28 CP OR"]
[null,"CONCERTA 54MG FR         30CP OR"]
[null,"LEUSTATIN        INJ CT C/ 1 FR          AMP"]
[null,"VELCADE 3,5 MG OR"]
[null,"LEUSTATIN INJ CT C/ 1       FR AMP"]
[null,"    VELCADE 3,5 MG OR"]
[]
[]
[]
[null,"Trimed Prodcut Detail"]

{"sheet":"Substitute","index":2,"n_rows":14,"n_cols":7,"rows_kept":14}
[null,"Step 4",{"$nulls":4},"Step 5"]
[]
[null,"Product Detail"]
[null,"PROGRAF 5MG 50CAPSULAS PROIBID",{"$nulls":4},"Sales Data"]
[null,"PARIET     20 MG 28 CP OR",{"$nulls":4},"Quarter 1, 2013"]
[null,"CONCERTA 54MG FR         30CP OR",{"$nulls":4},"Quarter 2, 2013"]
[null,"LEUSTATIN        INJ CT C/ 1 FR          AMP",{"$nulls":4},"Quarter 3, 2013"]
[null,"VELCADE 3,5 MG OR",{"$nulls":4},"Quarter 4, 2013"]
[null,"LEUSTATIN INJ CT C/ 1       FR AMP",{"$nulls":4},"Quarter 1, 2014"]
[null,"    VELCADE 3,5 MG OR",{"$nulls":4},"Quarter 2, 2014"]
[{"$nulls":6},"Quarter 3, 2014"]
[{"$nulls":6},"Quarter 4, 2014"]
[]
[null,"Product Detail - substitute . for , "]

{"sheet":"Value","index":3,"n_rows":24,"n_cols":7,"rows_kept":24}
[]
[]
[null,"Reported Quantity"]
[null,2]
[null,3]
[null,5]
[null,3]
[null,10]
[null,5]
[null,10]
[null,{"$f":"SUM(B4:B10)","v":38}]
[]
[]
[]
[null,"Using =Value",{"$nulls":4},"Using Text To Columns"]
{"$rows_empty":8}
[null,{"$f":"SUM(B17:B23)","v":0},{"$nulls":4},{"$f":"SUM(G17:G23)","v":0}]