{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Dataset","1. Target Value Check","2. Updating Cell Value","3. Bold","4.Font Color","5. Uppercase","7. Double Click","8. Populat1","8. Populate2","9. Color Based On Condition","9.1 Color Intergers","9.2 Color Strings","Target.Address"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Dataset","index":0,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Sales Data"]
[]
[null,"Salesperson ID","Salesperson","Product","Product ID","Total Sales"]
[null,"SP001","Alex","TV","PI101",100]
[null,"SP002","Emily","Fridge","PI102",200]
[null,"SP003","Madison","Phone","PI103",150]
[null,"SP004","William","TV","PI101",75]
[null,"SP005","Olivia","Fridge","PI102",300]
[null,"SP006","David","Phone","PI103",50]
[null,"SP007","Sophia","TV","PI101",150]
[null,"SP008","Jacob","Fridge","PI102",100]
[null,"SP009","Megan","Phone","PI103",175]

{"sheet":"1. Target Value Check","index":1,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Checking if Target is Met"]
[]
[null,"Salesperson ID","Salesperson","Product","Product ID","Total Sales",null,"Target Value"]
[null,"SP001","Alex","TV","PI101",100,null,30]
[null,"SP002","Emily","Fridge","PI102",200]
[null,"SP003","Madison","Phone","PI103",150]
[null,"SP004","William","TV","PI101",75]
[null,"SP005","Olivia","Fridge","PI102",300]
[null,"SP006","David","Phone","PI103",50]
[null,"SP007","Sophia","TV","PI101",150]
[null,"SP008","Jacob","Fridge","PI102",20]
[null,"SP009","Megan","Phone","PI103",30]

{"sheet":"2. Updating Cell Value","index":2,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Automatically Updating Cell Value"]
[]
[null,"Salesperson ID","Salesperson","Product","Product ID","Total Sales"]
[null,"SP001","Alex","TV","PI101",100]
[null,"SP002","Emily","Fridge","PI102",200]
[null,"SP003","Madison","Phone","PI103",150]
[null,"SP004","William","TV","PI101",75]
[null,"SP005","Olivia","Fridge","PI102",300]
[null,"SP006","David","Phone","PI103",50]
[null,"SP007","Sophia","TV","PI101",150]
[null,"SP008","Jacob","Fridge","PI102",100]
[null,"SP009","Megan","Phone","PI103",175]

{"sheet":"3. Bold","index":3,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Bolding Text"]
[]
[null,"Salesperson ID","Salesperson","Product","Product ID","Total Sales"]
[null,"SP001","Alex","TV","PI101",100]
[null,"SP002","Emily","Fridge","PI102",200]
[null,"SP003","Madison","Phone","PI103",150]
[null,"SP004","William","TV","PI101",75]
[null,"SP005","Olivia","Fridge","PI102",300]
[null,"SP006","David","Phone","PI103",50]
[null,"SP007","Sophia",null,"PI101",150]
[null,"SP008","Jacob","Fridge","PI102",100]
[null,"SP009","Megan","Phone","PI103",175]

{"sheet":"4.Font Color","index":4,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Setting Font Color Automatically"]
[]
[null,"Salesperson ID","Salesperson","Product","Product ID","Total Sales"]
[null,"SP001","Alex","TV","PI101",100]
[null,"SP002","Emily","Fridge","PI102",200]
[null,"SP003","Madison","Phone","PI103",150]
[null,"SP004","William","TV","PI101",75]
[null,"SP005","Olivia","Fridge","PI102",300]
[null,"SP006","David","Phone","PI103",50]
[null,"SP007","Sophia","TV","PI101",150]
[null,"SP008","Jacob","Fridge","PI102",100]
[null,"SP009","Megan","Phone","PI103",175]

{"sheet":"5. Uppercase","index":5,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Automatically Upper Casing"]
[]
[null,"Salesperson ID","Salesperson","Product","Product ID","Total Sales"]
[null,"SP001","Alex","TV","PI101",100]
[null,"SP002","Emily","Fridge","PI102",200]
[null,"SP003","Madison","Phone","PI103",150]
[null,"SP004","William","TV","PI101",75]
[null,"SP005","Olivia","Fridge","PI102",300]
[null,"SP006","David","Phone","PI103",50]
[null,"SP007","Sophia","TV","PI101",150]
[null,"SP008","Jacob","Fridge","PI102",100]
[null,"SP009","Megan","Phone","PI103",175]

{"sheet":"7. Double Click","index":6,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Double Click to Show Message"]
[]
[null,"Salesperson ID","Salesperson","Product","Product ID","Total Sales"]
[null,"SP001","Alex","TV","PI101",100]
[null,"SP002","Emily","Fridge","PI102",200]
[null,"SP003","Madison","Phone","PI103",150]
[null,"SP004","William","TV","PI101",75]
[null,"SP005","Olivia","Fridge","PI102",300]
[null,"SP006","David","Phone","PI103",50]
[null,"SP007","Sophia","TV","PI101",150]
[null,"SP008","Jacob","Fridge","PI102",100]
[null,"SP009","Megan","Phone","PI103",175]

{"sheet":"8. Populat1","index":7,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Populating New Entry to Different Worksheet"]
[]
[null,"Salesperson ID","Salesperson","Product","Product ID","Total Sales"]
[null,"SP001","Alex","TV","PI101",100]
[null,"SP002","Emily","Fridge","PI102",200]
[null,"SP003","Madison","Phone","PI103",150]
[null,"SP004","William","TV","PI101",75]
[null,"SP005","Olivia","Fridge","PI102",300]
[null,"SP006","David","Phone","PI103",50]
[null,"SP007","Sophia","TV","PI101",150]
[null,"SP008","Jacob","Fridge","PI102",100]
[null,"SP009","Megan","Phone","PI103",175]
[null,"SP010","Alison","Phone","P103",200]

{"sheet":"8. Populate2","index":8,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Stores The Populated Value Here"]
[]
[null,"Salesperson ID","Salesperson","Product","Product ID","Total Sales"]
[null,"SP001","Alex","TV","PI101",100]
[null,"SP002","Emily","Fridge","PI102",200]
[null,"SP003","Madison","Phone","PI103",150]
[null,"SP004","William","TV","PI101",75]
[null,"SP005","Olivia","Fridge","PI102",300]
[null,"SP006","David","Phone","PI103",50]
[null,"SP007","Sophia","TV","PI101",150]
[null,"SP008","Jacob","Fridge","PI102",100]
[null,"SP009","Megan","Phone","PI103",175]
[null,"SP009","Megan","Phone","PI103",175]
[null,"SP010","Alison","Phone","P103",200]

{"sheet":"9. Color Based On Condition","index":9,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Coloring Matched Value"]
[]
[null,"Salesperson ID","Salesperson","Product","Product ID","Total Sales",null,"Search Product"]
[null,"SP001","Alex","TV","PI101",100,null,"Phone"]
[null,"SP002","Emily","Fridge","PI102",200]
[null,"SP003","Madison","Phone","PI103",150]
[null,"SP004","William","TV","PI101",75]
[null,"SP005","Olivia","Fridge","PI102",300]
[null,"SP006","David","Phone","PI103",50]
[null,"SP007","Sophia","TV","PI101",150]
[null,"SP008","Jacob","Fridge","PI102",100]
[null,"SP009","Megan","Phone","PI103",175]

{"sheet":"9.1 Color Intergers","index":10,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Coloring Integer Values Based on Condition"]
[]
[null,"Salesperson ID","Salesperson","Product","Product ID","Total Sales"]
[null,"SP001","Alex","TV","PI101",90]
[null,"SP002","Emily","Fridge","PI102",131]
[null,"SP003","Madison","Phone","PI103",177]
[null,"SP004","William","TV","PI101",86]
[null,"SP005","Olivia","Fridge","PI102",101]
[null,"SP006","David","Phone","PI103",52]
[null,"SP007","Sophia","TV","PI101",76]
[null,"SP008","Jacob","Fridge","PI102"]
[null,"SP009","Megan","Phone","PI103"]

{"sheet":"9.2 Color Strings","index":11,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Coloring Strings Based on Conditon"]
[]
[null,"Salesperson ID","Salesperson","Product","Product ID","Total Sales"]
[null,"SP001","Alex","TV","PI101",100]
[null,"SP002","Emily","Fridge","PI102",200]
[null,"SP003","Madison","Computer","PI104",150]
[null,"SP004","William","Phone","PI101",75]
[null,"SP005","Olivia","Phone","PI101",300]
[null,"SP006","David",null,"PI101",50]
[null,"SP007","Sophia",null,"PI102",150]
[null,"SP008","Jacob",null,"PI103",100]
[null,"SP009","Megan",null,"PI103",175]

{"sheet":"Target.Address","index":12,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[4,6,5,6],[1,1,1,6]]}
[]
[null,"Using Target.Address to Write to Multiple Cells"]
[]
[null,"Salesperson ID","Salesperson","Product","Product ID","Total Sales","First Two Non Zero Sum: "]
[null,"SP001","Alex","TV","PI101",125,265]
[null,"SP002","Emily","Fridge","PI102",140]
[null,"SP003","Madison","Phone","PI103",150]
[null,"SP004","William","TV","PI101",75]
[null,"SP005","Olivia","Fridge","PI102",300]
[null,"SP006","David","Phone","PI103",50]
[null,"SP007","Sophia","TV","PI101",150]
[null,"SP008","Jacob","Fridge","PI102",100]
[null,"SP009","Megan","Phone","PI103",175]