{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Process1","Process2","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":10,"defined_names":2,"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":"Process1","index":0,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Data File","Location"]
[]
[null,null,"C:\\Users\\Mobty002\\Desktop\\Old\\assignment\\04-Sep-2016\\9.xlsx"]
[]
[null,null,"C:\\Users\\sayedmd\\Desktop\\Camp 2016\\New Toyota Key In Price List  11-02-2016.TXT"]
[]
[null,null,"C:\\Users\\sayedmd\\Desktop\\Camp 2016\\New Retail-Toyota.txt"]

{"sheet":"Process2","index":1,"n_rows":41,"n_cols":10,"rows_kept":41,"cut":false,"hidden":true,"merged":[]}
[{"$f":"INDIRECT(\"G\"&A16)","v":1231},"Current Campaign Last Row Used",null,null,"Campaign1",{"$f":"A$3&ROW()&\".xlsx\"","v":"C:\\Users\\Mobty002\\Desktop\\Old\\assignment\\04-Sep-2016\\1.xlsx"},1056,"Jan 2016",{"$f":"A$3&\"[\"&ROW()&\".xlsx]\"","v":"C:\\Users\\Mobty002\\Desktop\\Old\\assignment\\04-Sep-2016\\[1.xlsx]"},{"$f":"IFERROR(IFERROR(INDEX('[1]Jan 2016'!$E$1:$E$1056,MATCH(A8,'[1]Jan 2016'!$D$1:$D$1056,0),1),INDEX('[1]Jan 2016'!$J$1:$J$1056,MATCH(A8,'[1]Jan 2016'!$I$1:$I$1056,0),1)),0)","v":0}]
[{"$f":"INDIRECT(\"H\"&A16)","v":"Sep- 2016"},"Current Sheet Name Campaign",null,null,"Campaign2",{"$f":"A$3&ROW()&\".xlsx\"","v":"C:\\Users\\Mobty002\\Desktop\\Old\\assignment\\04-Sep-2016\\2.xlsx"},1056,"Feb 2016",{"$f":"A$3&\"[\"&ROW()&\".xlsx]\"","v":"C:\\Users\\Mobty002\\Desktop\\Old\\assignment\\04-Sep-2016\\[2.xlsx]"},{"$f":"IFERROR(IFERROR(INDEX('[2]Feb 2016'!$E$1:$E$1056,MATCH(A8,'[2]Feb 2016'!$D$1:$D$1056,0),1),INDEX('[2]Feb 2016'!$J$1:$J$1056,MATCH(A8,'[2]Feb 2016'!$I$1:$I$1056,0),1)),0)","v":0}]
[{"$f":"LEFT(Process1!C5,LEN(Process1!C5)-LEN(A4))","v":"C:\\Users\\Mobty002\\Desktop\\Old\\assignment\\04-Sep-2016\\"},"Current Location Campaign",null,null,"Campaign3","C:\\Users\\Mobty002\\Desktop\\Old\\assignment\\04-Sep-2016\\3.xlsx",1266,"Mar 2016","C:\\Users\\Mobty002\\Desktop\\Old\\assignment\\04-Sep-2016\\[3.xlsx]",{"$f":"IFERROR(IFERROR(INDEX('[3]Mar 2016'!$E$1:$E$1266,MATCH(A8,'[3]Mar 2016'!$D$1:$D$1266,0),1),INDEX('[3]Mar 2016'!$J$1:$J$1266,MATCH(A8,'[3]Mar 2016'!$I$1:$I$1266,0),1)),0)","v":0}]
[{"$f":"IF(ISERROR(FIND(\"\\\",Process1!C5)),Process1!C5,RIGHT(Process1!C5,LEN(Process1!C5)-FIND(\"~\",SUBSTITUTE(Process1!C5,\"\\\",\"~\",LEN(Process1!C5)-LEN(SUBSTITUTE(Process1!C5,\"\\\",\"\"))))))","v":"9.xlsx"},"Current Campaign File Name",null,null,"Campaign4","C:\\Users\\Mobty002\\Desktop\\Old\\assignment\\04-Sep-2016\\4.xlsx",1233,"Apr 2016","C:\\Users\\Mobty002\\Desktop\\Old\\assignment\\04-Sep-2016\\[4.xlsx]",{"$f":"IFERROR(IFERROR(INDEX('[4]Apr 2016'!$E$1:$E$1233,MATCH(A8,'[4]Apr 2016'!$D$1:$D$1233,0),1),INDEX('[4]Apr 2016'!$J$1:$J$1233,MATCH(A8,'[4]Apr 2016'!$I$1:$I$1233,0),1)),0)","v":0}]
[null,null,null,null,"Campaign5","C:\\Users\\Mobty002\\Desktop\\Old\\assignment\\04-Sep-2016\\5.xlsx",1254,"May 2016","C:\\Users\\Mobty002\\Desktop\\Old\\assignment\\04-Sep-2016\\[5.xlsx]",{"$f":"IFERROR(IFERROR(INDEX('[5]May 2016'!$E$1:$E$1254,MATCH(A8,'[5]May 2016'!$D$1:$D$1254,0),1),INDEX('[5]May 2016'!$J$1:$J$1254,MATCH(A8,'[5]May 2016'!$I$1:$I$1254,0),1)),0)","v":0}]
[{"$f":"A3&\"[\"&A4&\"]\"","v":"C:\\Users\\Mobty002\\Desktop\\Old\\assignment\\04-Sep-2016\\[9.xlsx]"},"Full Address Current Campaign",null,null,"Campaign6","C:\\Users\\Mobty002\\Desktop\\Old\\assignment\\04-Sep-2016\\6.xlsx",1301,"Jun 2016","C:\\Users\\Mobty002\\Desktop\\Old\\assignment\\04-Sep-2016\\[6.xlsx]",{"$f":"IFERROR(IFERROR(INDEX('[6]Jun 2016'!$E$1:$E$1301,MATCH(A8,'[6]Jun 2016'!$D$1:$D$1301,0),1),INDEX('[6]Jun 2016'!$J$1:$J$1301,MATCH(A8,'[6]Jun 2016'!$I$1:$I$1301,0),1)),0)","v":0}]
[null,null,null,null,"Campaign7","C:\\Users\\Mobty002\\Desktop\\Old\\assignment\\04-Sep-2016\\7.xlsx",1266," Jul-2016","C:\\Users\\Mobty002\\Desktop\\Old\\assignment\\04-Sep-2016\\[7.xlsx]",{"$f":"IFERROR(IFERROR(INDEX('[7] Jul-2016'!$E$1:$E$1266,MATCH(A8,'[7] Jul-2016'!$D$1:$D$1266,0),1),INDEX('[7] Jul-2016'!$J$1:$J$1266,MATCH(A8,'[7] Jul-2016'!$I$1:$I$1266,0),1)),0)","v":0}]
[null,"Find Current Campaign",null,null,"Campaign8","C:\\Users\\Mobty002\\Desktop\\Old\\assignment\\04-Sep-2016\\8.xlsx",1196," 2016","C:\\Users\\Mobty002\\Desktop\\Old\\assignment\\04-Sep-2016\\[8.xlsx]",{"$f":"IFERROR(IFERROR(INDEX('[8] 2016'!$E$1:$E$1196,MATCH(A8,'[8] 2016'!$D$1:$D$1196,0),1),INDEX('[8] 2016'!$J$1:$J$1196,MATCH(A8,'[8] 2016'!$I$1:$I$1196,0),1)),0)","v":0}]
[11,"Current Row Find Current Campaign",null,null,"Campaign9","C:\\Users\\Mobty002\\Desktop\\Old\\assignment\\04-Sep-2016\\9.xlsx",1231,"Sep- 2016","C:\\Users\\Mobty002\\Desktop\\Old\\assignment\\04-Sep-2016\\[9.xlsx]",{"$f":"IFERROR(IFERROR(INDEX('[9]Sep- 2016'!$E$1:$E$1231,MATCH(A8,'[9]Sep- 2016'!$D$1:$D$1231,0),1),INDEX('[9]Sep- 2016'!$J$1:$J$1231,MATCH(A8,'[9]Sep- 2016'!$I$1:$I$1231,0),1)),0)","v":0}]
[10,"Range Count",null,null,"Campaign10","C:\\Users\\Mobty002\\Desktop\\Old\\assignment\\04-Sep-2016\\10.xlsx",null,null,"C:\\Users\\Mobty002\\Desktop\\Old\\assignment\\04-Sep-2016\\[10.xlsx]"]
[{"$f":"CONCATENATE(\"$D$1:$D$\"&A1)","v":"$D$1:$D$1231"},"First Column Current Campaign",null,null,"Campaign11","C:\\Users\\Mobty002\\Desktop\\Old\\assignment\\04-Sep-2016\\11.xlsx",null,null,"C:\\Users\\Mobty002\\Desktop\\Old\\assignment\\04-Sep-2016\\[11.xlsx]"]
[{"$f":"CONCATENATE(\"$I$1:$I$\"&A1)","v":"$I$1:$I$1231"},"Second Column Current Campaign",null,null,"Campaign12","C:\\Users\\Mobty002\\Desktop\\Old\\assignment\\04-Sep-2016\\12.xlsx",null,null,"C:\\Users\\Mobty002\\Desktop\\Old\\assignment\\04-Sep-2016\\[12.xlsx]"]
[]
[{"$f":"INDEX(J1:J12,A16,1)","v":0},"Locate Find Current Campaign"]
[]
[{"$f":"IFERROR(LEFT(A4,FIND(\".\",A4)-1),0)","v":"9"},"Total Campaign/Current Campaign"]
[]
[]
[{"$f":"IFERROR(LEFT(Process1!C7,LEN(Process1!C7)-LEN(A20)),0)","v":"C:\\Users\\sayedmd\\Desktop\\Camp 2016\\"},"Key In Price txt Location"]
[{"$f":"IF(ISERROR(FIND(\"\\\",Process1!C7)),Process1!C7,RIGHT(Process1!C7,LEN(Process1!C7)-FIND(\"~\",SUBSTITUTE(Process1!C7,\"\\\",\"~\",LEN(Process1!C7)-LEN(SUBSTITUTE(Process1!C7,\"\\\",\"\"))))))","v":"New Toyota Key In Price List  11-02-2016.TXT"},"Key In Price txt File Name"]
[]
["C:\\","Key In Price Excel Location"]
[{"$f":"IFERROR(LEFT(A20,LEN(A20)-4)&\".xlsx\",0)","v":"New Toyota Key In Price List  11-02-2016.xlsx"},"Key In Price Excel File Name"]
["KeyInPrice","Key In Price Excel Sheet Name"]
[{"$f":"\"C:\\Docs\\[\"&A23&\"]\"","v":"C:\\Docs\\[New Toyota Key In Price List  11-02-2016.xlsx]"},"Key In Price Excel Full Address"]
[5261,"Key in Price Last Used Row"]
[{"$f":"IFERROR(INDEX([10]KeyInPrice!$D$1:$D$5261,MATCH(A8,[10]KeyInPrice!$B$1:$B$5261,0),1),0)","v":0},"Locate Current Campaign in Key in Price"]
[]
[{"$f":"IFERROR(LEFT(Process1!C9,LEN(Process1!C9)-LEN(A30)),0)","v":"C:\\Users\\sayedmd\\Desktop\\Camp 2016\\"},"Retail Price txt Location"]
[{"$f":"IF(ISERROR(FIND(\"\\\",Process1!C9)),Process1!C9,RIGHT(Process1!C9,LEN(Process1!C9)-FIND(\"~\",SUBSTITUTE(Process1!C9,\"\\\",\"~\",LEN(Process1!C9)-LEN(SUBSTITUTE(Process1!C9,\"\\\",\"\"))))))","v":"New Retail-Toyota.txt"},"Retail Price txt File Name"]
[]
["C:\\","Retail Price Excel Location"]
[{"$f":"IFERROR(LEFT(A30,LEN(A30)-4)&\".xlsx\",0)","v":"New Retail-Toyota.xlsx"},"Retail Price Excel File Name"]
["RetailPrice","Retail Price Excel Sheet Name"]
[{"$f":"\"C:\\Docs\\[\"&A33&\"]\"","v":"C:\\Docs\\[New Retail-Toyota.xlsx]"},"Retail Price Excel Full Address"]
[248862,"Retail Price Last Used Row"]
[0,"Locate Current Campaign in Retail Price",null,null,null,null,null,null,null,{"$f":"MATCH(H37,H:H,0)","v":{"$error":"#N/A"}}]
[]
[1,"Count Quantity"]
["04005-16107","Value of Quantity"]
[6,"Current Row Quantity"]

{"sheet":"Sheet1","index":2,"n_rows":261,"n_cols":18,"rows_kept":261,"cut":false,"hidden":false,"merged":[]}
["Customer Order","Qty","Current Campaign","Key-in Price","Retail Price","Total Oder","Campaign 1","Campaign 2","Campaign 3","Campaign 4","Campaign 5","Campaign 6","Campaign 7","Campaign 8","Campaign 9","Campaign 10","Campaign 11","Campaign 12"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]