{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Employee Dataset","Using Hyperlink","Using VBA Macro ","Samantha Carson","Clinton Webster","Chester Paul","Rodney Gomez","Jaime Schultz","Ryan Russell","Rudy Palmer","Abel Alvarado","Franklin Sanders","Jackie Berry","Maggie Gilbert","Ramiro Harper"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":3,"defined_names":18,"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":"Employee Dataset","index":0,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[null,"Group Tabs Under a Master Tab in Excel"]
[]
[null,"Group Tabs"]
[]
[null,"Employee ID","Full Name","Department","Designation"]
[null,"ID-22001","Samantha Carson","Sales","Manager"]
[null,"ID-22002","Clinton Webster","Sales","Associate"]
[null,"ID-22003","Chester Paul","Sales","Representative"]
[null,"ID-22004","Rodney Gomez","Sales","Representative"]
[null,"ID-22005","Jaime Schultz","Sales","Representative"]
[null,"ID-22006","Abel Alvarado","Marketing","Manager"]
[null,"ID-22007","Rudy Palmer","Marketing","Coordinator"]
[null,"ID-22008","Ryan Russell","Marketing","Analyst"]
[null,"ID-22009","Ramiro Harper","IT","Manager"]
[null,"ID-22010","Maggie Gilbert","IT","Engineer"]
[null,"ID-22011","Jackie Berry","IT","Developer"]
[null,"ID-22012","Franklin Sanders","IT","Developer"]

{"sheet":"Using Hyperlink","index":1,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[null,"Group Tabs Under a Master Tab in Excel"]
[]
[null,"Using Hyperlink\t"]
[]
[null,"Employee ID","Full Name","Department","Designation"]
[null,"ID-22001","Samantha Carson","Sales","Manager"]
[null,"ID-22002","Clinton Webster","Sales","Associate"]
[null,"ID-22003","Chester Paul","Sales","Representative"]
[null,"ID-22004","Rodney Gomez","Sales","Representative"]
[null,"ID-22005","Jaime Schultz","Sales","Representative"]
[null,"ID-22006","Abel Alvarado","Marketing","Manager"]
[null,"ID-22007","Rudy Palmer","Marketing","Coordinator"]
[null,"ID-22008","Ryan Russell","Marketing","Analyst"]
[null,"ID-22009","Ramiro Harper","IT","Manager"]
[null,"ID-22010","Maggie Gilbert","IT","Engineer"]
[null,"ID-22011","Jackie Berry","IT","Developer"]
[null,"ID-22012","Franklin Sanders","IT","Developer"]

{"sheet":"Using VBA Macro ","index":2,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[null,"Group Tabs Under a Master Tab in Excel"]
[]
[null,"Using VBA Macro\t"]
[]
[null,"Employee ID","Full Name","Department","Designation"]
[null,"ID-22001","Samantha Carson","Sales","Manager"]
[null,"ID-22002","Clinton Webster","Sales","Associate"]
[null,"ID-22003","Chester Paul","Sales","Representative"]
[null,"ID-22004","Rodney Gomez","Sales","Representative"]
[null,"ID-22005","Jaime Schultz","Sales","Representative"]
[null,"ID-22006","Abel Alvarado","Marketing","Manager"]
[null,"ID-22007","Rudy Palmer","Marketing","Coordinator"]
[null,"ID-22008","Ryan Russell","Marketing","Analyst"]
[null,"ID-22009","Ramiro Harper","IT","Manager"]
[null,"ID-22010","Maggie Gilbert","IT","Engineer"]
[null,"ID-22011","Jackie Berry","IT","Developer"]
[null,"ID-22012","Franklin Sanders","IT","Developer"]

{"sheet":"Samantha Carson","index":3,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Sales Report-Samantha Carson"]
[]
[null,"Order No","Order Date","Ship Date","Retail Price","Quantity","Sub Total"]
[null,"5071-1","2013-05-05","2013-05-07",2.23,41,{"$f":"E5*F5","v":91.429999999999993}]
[null,"5071-2","2013-05-05","2013-05-07",6.68,2,{"$f":"E6*F6","v":13.36}]
[null,"5145-1","2013-05-05","2013-05-07",5.18,1,5.18]
[null,"5145-2","2013-05-29","2013-06-10",5.84,4,23.36]
[null,"5160-1","2013-06-08","2013-06-10",20.99,41,860.58999999999992]
[null,"5160-2","2013-06-10","2013-06-10",5.4,26,140.4]
[null,"5168-1","2013-06-11","2013-06-10",6.47,20,129.4]
[null,"5168-2","2013-07-15","2013-07-22",2.84,39,110.75999999999999]
[null,"5195-1","2013-07-20","2013-07-22",2.88,11,31.68]
[null,"5195-2","2013-07-21","2013-07-22",19.98,43,859.14]
[]
[]
[]
[null,"Go back to Master Tab"]

{"sheet":"Clinton Webster","index":4,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Sales Report-Clinton Webster"]
[]
[null,"Order No","Order Date","Ship Date","Retail Price","Quantity","Sub Total"]
[null,"5071-1","2013-05-05","2013-05-07",2.23,41,{"$f":"E5*F5","v":91.429999999999993}]
[null,"5071-2","2013-05-05","2013-05-07",6.68,2,{"$f":"E6*F6","v":13.36}]
[null,"5145-1","2013-05-05","2013-05-07",5.18,1,5.18]
[null,"5145-2","2013-05-29","2013-06-10",5.84,4,23.36]
[null,"5160-1","2013-06-08","2013-06-10",20.99,41,860.58999999999992]
[null,"5160-2","2013-06-10","2013-06-10",5.4,26,140.4]
[null,"5168-1","2013-06-11","2013-06-10",6.47,20,129.4]
[null,"5168-2","2013-07-15","2013-07-22",2.84,39,110.75999999999999]
[null,"5195-1","2013-07-20","2013-07-22",2.88,11,31.68]
[null,"5195-2","2013-07-21","2013-07-22",19.98,43,859.14]

{"sheet":"Chester Paul","index":5,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Sales Report-Chester Paul"]
[]
[null,"Order No","Order Date","Ship Date","Retail Price","Order Quantity","Sub Total"]
[null,"5071-1","2013-05-05","2013-05-07",2.23,41,{"$f":"E5*F5","v":91.429999999999993}]
[null,"5071-2","2013-05-05","2013-05-07",6.68,2,{"$f":"E6*F6","v":13.36}]
[null,"5145-1","2013-05-05","2013-05-07",5.18,1,5.18]
[null,"5145-2","2013-05-29","2013-06-10",5.84,4,23.36]
[null,"5160-1","2013-06-08","2013-06-10",20.99,41,860.58999999999992]
[null,"5160-2","2013-06-10","2013-06-10",5.4,26,140.4]
[null,"5168-1","2013-06-11","2013-06-10",6.47,20,129.4]
[null,"5168-2","2013-07-15","2013-07-22",2.84,39,110.75999999999999]
[null,"5195-1","2013-07-20","2013-07-22",2.88,11,31.68]
[null,"5195-2","2013-07-21","2013-07-22",19.98,43,859.14]

{"sheet":"Rodney Gomez","index":6,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Sales Report-Clinton Webster"]
[]
[null,"Order No","Order Date","Customer Name","Ship Date","Retail Price","Order Quantity","Sub Total"]
[null,"5160-2","2013-06-10","Berenike Kampe","2013-06-10",5.4,26,{"$f":"F5*G5","v":140.4}]
[null,"5168-1","2013-06-11","Christy Brittain","2013-06-10",6.47,20,129.4]
[null,"5168-2","2013-07-15","Christy Brittain","2013-07-22",2.84,39,110.75999999999999]
[null,"5195-1","2013-07-20","Alex Grayson","2013-07-22",2.88,11,31.68]
[null,"5195-2","2013-07-21","Alex Grayson","2013-07-22",19.98,43,859.14]
[null,"5071-1","2013-05-05","Christopher Schild","2013-05-07",2.23,41,{"$f":"F10*G10","v":91.429999999999993}]
[null,"5071-2","2013-05-05","Christopher Schild","2013-05-07",6.68,2,{"$f":"F11*G11","v":13.36}]
[null,"5145-1","2013-05-05","Cyma Kinney","2013-05-07",5.18,1,5.18]
[null,"5145-2","2013-05-29","Cyma Kinney","2013-06-10",5.84,4,23.36]
[null,"5160-1","2013-06-08","Berenike Kampe","2013-06-10",20.99,41,860.58999999999992]

{"sheet":"Jaime Schultz","index":7,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Sales Report"]
[]
[null,"Order No","Order Date","Customer Name","Ship Date","Retail Price","Order Quantity","Sub Total"]
[null,"5071-1","2013-05-05","Christopher Schild","2013-05-07",2.23,41,{"$f":"F5*G5","v":91.429999999999993}]
[null,"5071-2","2013-05-05","Christopher Schild","2013-05-07",6.68,2,{"$f":"F6*G6","v":13.36}]
[null,"5145-1","2013-05-05","Cyma Kinney","2013-05-07",5.18,1,5.18]
[null,"5145-2","2013-05-29","Cyma Kinney","2013-06-10",5.84,4,23.36]
[null,"5160-1","2013-06-08","Berenike Kampe","2013-06-10",20.99,41,860.58999999999992]
[null,"5160-2","2013-06-10","Berenike Kampe","2013-06-10",5.4,26,140.4]
[null,"5168-1","2013-06-11","Christy Brittain","2013-06-10",6.47,20,129.4]
[null,"5168-2","2013-07-15","Christy Brittain","2013-07-22",2.84,39,110.75999999999999]
[null,"5195-1","2013-07-20","Alex Grayson","2013-07-22",2.88,11,31.68]
[null,"5195-2","2013-07-21","Alex Grayson","2013-07-22",19.98,43,859.14]

{"sheet":"Ryan Russell","index":8,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Sales Report"]
[]
[null,"Order No","Order Date","Customer Name","Ship Date","Retail Price","Order Quantity","Sub Total"]
[null,"5071-1","2013-05-05","Christopher Schild","2013-05-07",2.23,41,{"$f":"F5*G5","v":91.429999999999993}]
[null,"5071-2","2013-05-05","Christopher Schild","2013-05-07",6.68,2,{"$f":"F6*G6","v":13.36}]
[null,"5145-1","2013-05-05","Cyma Kinney","2013-05-07",5.18,1,5.18]
[null,"5145-2","2013-05-29","Cyma Kinney","2013-06-10",5.84,4,23.36]
[null,"5160-1","2013-06-08","Berenike Kampe","2013-06-10",20.99,41,860.58999999999992]
[null,"5160-2","2013-06-10","Berenike Kampe","2013-06-10",5.4,26,140.4]
[null,"5168-1","2013-06-11","Christy Brittain","2013-06-10",6.47,20,129.4]
[null,"5168-2","2013-07-15","Christy Brittain","2013-07-22",2.84,39,110.75999999999999]
[null,"5195-1","2013-07-20","Alex Grayson","2013-07-22",2.88,11,31.68]
[null,"5195-2","2013-07-21","Alex Grayson","2013-07-22",19.98,43,859.14]

{"sheet":"Rudy Palmer","index":9,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Sales Report"]
[]
[null,"Order No","Order Date","Customer Name","Ship Date","Retail Price","Order Quantity","Sub Total"]
[null,"5071-1","2013-05-05","Christopher Schild","2013-05-07",2.23,41,{"$f":"F5*G5","v":91.429999999999993}]
[null,"5071-2","2013-05-05","Christopher Schild","2013-05-07",6.68,2,{"$f":"F6*G6","v":13.36}]
[null,"5145-1","2013-05-05","Cyma Kinney","2013-05-07",5.18,1,5.18]
[null,"5145-2","2013-05-29","Cyma Kinney","2013-06-10",5.84,4,23.36]
[null,"5160-1","2013-06-08","Berenike Kampe","2013-06-10",20.99,41,860.58999999999992]
[null,"5160-2","2013-06-10","Berenike Kampe","2013-06-10",5.4,26,140.4]
[null,"5168-1","2013-06-11","Christy Brittain","2013-06-10",6.47,20,129.4]
[null,"5168-2","2013-07-15","Christy Brittain","2013-07-22",2.84,39,110.75999999999999]
[null,"5195-1","2013-07-20","Alex Grayson","2013-07-22",2.88,11,31.68]
[null,"5195-2","2013-07-21","Alex Grayson","2013-07-22",19.98,43,859.14]

{"sheet":"Abel Alvarado","index":10,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Sales Report"]
[]
[null,"Order No","Order Date","Customer Name","Ship Date","Retail Price","Order Quantity","Sub Total"]
[null,"5071-1","2013-05-05","Christopher Schild","2013-05-07",2.23,41,{"$f":"F5*G5","v":91.429999999999993}]
[null,"5071-2","2013-05-05","Christopher Schild","2013-05-07",6.68,2,{"$f":"F6*G6","v":13.36}]
[null,"5145-1","2013-05-05","Cyma Kinney","2013-05-07",5.18,1,5.18]
[null,"5145-2","2013-05-29","Cyma Kinney","2013-06-10",5.84,4,23.36]
[null,"5160-1","2013-06-08","Berenike Kampe","2013-06-10",20.99,41,860.58999999999992]
[null,"5160-2","2013-06-10","Berenike Kampe","2013-06-10",5.4,26,140.4]
[null,"5168-1","2013-06-11","Christy Brittain","2013-06-10",6.47,20,129.4]
[null,"5168-2","2013-07-15","Christy Brittain","2013-07-22",2.84,39,110.75999999999999]
[null,"5195-1","2013-07-20","Alex Grayson","2013-07-22",2.88,11,31.68]
[null,"5195-2","2013-07-21","Alex Grayson","2013-07-22",19.98,43,859.14]

{"sheet":"Franklin Sanders","index":11,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Sales Report"]
[]
[null,"Order No","Order Date","Customer Name","Ship Date","Retail Price","Order Quantity","Sub Total"]
[null,"5160-2","2013-06-10","Berenike Kampe","2013-06-10",5.4,26,{"$f":"F5*G5","v":140.4}]
[null,"5168-1","2013-06-11","Christy Brittain","2013-06-10",6.47,20,129.4]
[null,"5168-2","2013-07-15","Christy Brittain","2013-07-22",2.84,39,110.75999999999999]
[null,"5195-1","2013-07-20","Alex Grayson","2013-07-22",2.88,11,31.68]
[null,"5195-2","2013-07-21","Alex Grayson","2013-07-22",19.98,43,859.14]
[null,"5071-1","2013-05-05","Christopher Schild","2013-05-07",2.23,41,{"$f":"F10*G10","v":91.429999999999993}]
[null,"5071-2","2013-05-05","Christopher Schild","2013-05-07",6.68,2,{"$f":"F11*G11","v":13.36}]
[null,"5145-1","2013-05-05","Cyma Kinney","2013-05-07",5.18,1,5.18]
[null,"5145-2","2013-05-29","Cyma Kinney","2013-06-10",5.84,4,23.36]
[null,"5160-1","2013-06-08","Berenike Kampe","2013-06-10",20.99,41,860.58999999999992]

{"sheet":"Jackie Berry","index":12,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Sales Report"]
[]
[null,"Order No","Order Date","Customer Name","Ship Date","Retail Price","Order Quantity","Sub Total"]
[null,"5071-1","2013-05-05","Christopher Schild","2013-05-07",2.23,41,{"$f":"F5*G5","v":91.429999999999993}]
[null,"5071-2","2013-05-05","Christopher Schild","2013-05-07",6.68,2,{"$f":"F6*G6","v":13.36}]
[null,"5145-1","2013-05-05","Cyma Kinney","2013-05-07",5.18,1,5.18]
[null,"5145-2","2013-05-29","Cyma Kinney","2013-06-10",5.84,4,23.36]
[null,"5160-1","2013-06-08","Berenike Kampe","2013-06-10",20.99,41,860.58999999999992]
[null,"5160-2","2013-06-10","Berenike Kampe","2013-06-10",5.4,26,140.4]
[null,"5168-1","2013-06-11","Christy Brittain","2013-06-10",6.47,20,129.4]
[null,"5168-2","2013-07-15","Christy Brittain","2013-07-22",2.84,39,110.75999999999999]
[null,"5195-1","2013-07-20","Alex Grayson","2013-07-22",2.88,11,31.68]
[null,"5195-2","2013-07-21","Alex Grayson","2013-07-22",19.98,43,859.14]

{"sheet":"Maggie Gilbert","index":13,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Sales Report"]
[]
[null,"Order No","Order Date","Customer Name","Ship Date","Retail Price","Order Quantity","Sub Total"]
[null,"5160-2","2013-06-10","Berenike Kampe","2013-06-10",5.4,26,{"$f":"F5*G5","v":140.4}]
[null,"5168-1","2013-06-11","Christy Brittain","2013-06-10",6.47,20,129.4]
[null,"5168-2","2013-07-15","Christy Brittain","2013-07-22",2.84,39,110.75999999999999]
[null,"5195-1","2013-07-20","Alex Grayson","2013-07-22",2.88,11,31.68]
[null,"5195-2","2013-07-21","Alex Grayson","2013-07-22",19.98,43,859.14]
[null,"5071-1","2013-05-05","Christopher Schild","2013-05-07",2.23,41,{"$f":"F10*G10","v":91.429999999999993}]
[null,"5071-2","2013-05-05","Christopher Schild","2013-05-07",6.68,2,{"$f":"F11*G11","v":13.36}]
[null,"5145-1","2013-05-05","Cyma Kinney","2013-05-07",5.18,1,5.18]
[null,"5145-2","2013-05-29","Cyma Kinney","2013-06-10",5.84,4,23.36]
[null,"5160-1","2013-06-08","Berenike Kampe","2013-06-10",20.99,41,860.58999999999992]

{"sheet":"Ramiro Harper","index":14,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Sales Report"]
[]
[null,"Order No","Order Date","Customer Name","Ship Date","Retail Price","Order Quantity","Sub Total"]
[null,"5071-1","2013-05-05","Christopher Schild","2013-05-07",2.23,41,{"$f":"F5*G5","v":91.429999999999993}]
[null,"5071-2","2013-05-05","Christopher Schild","2013-05-07",6.68,2,{"$f":"F6*G6","v":13.36}]
[null,"5145-1","2013-05-05","Cyma Kinney","2013-05-07",5.18,1,5.18]
[null,"5145-2","2013-05-29","Cyma Kinney","2013-06-10",5.84,4,23.36]
[null,"5160-1","2013-06-08","Berenike Kampe","2013-06-10",20.99,41,860.58999999999992]
[null,"5160-2","2013-06-10","Berenike Kampe","2013-06-10",5.4,26,140.4]
[null,"5168-1","2013-06-11","Christy Brittain","2013-06-10",6.47,20,129.4]
[null,"5168-2","2013-07-15","Christy Brittain","2013-07-22",2.84,39,110.75999999999999]
[null,"5195-1","2013-07-20","Alex Grayson","2013-07-22",2.88,11,31.68]
[null,"5195-2","2013-07-21","Alex Grayson","2013-07-22",19.98,43,859.14]