{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Cell Value Change","Range","Drop-Down menu","Formularesult change","Cell selection"],"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":"Cell Value Change","index":0,"n_rows":20,"n_cols":16,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,6],[17,4,17,6],[1,12,1,16]]}
[]
[null,"Run VBA Macro When a Specific Cell Value Changes",null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Students Name","Marks",null,"Top",10,null,null,null,null,null,null,"Students Name","Marks",null,"Top"]
[null,"James",56,null,null,null,null,null,null,null,null,null,"James",56]
[null,"Robert",76,null,"Rank","Students Name","Marks",null,null,null,null,null,"Robert",76]
[null,"John",45,null,{"$f":"IF(COUNT($C$6:$C$21)>F4,_xlfn.SEQUENCE(F4),\"\")","v":1},{"$f":"_xlfn._xlws.SORT(_xlfn._xlws.FILTER($B$5:$C$21,$C$5:$C$21>=LARGE($C$5:$C$21,F4)),2,-1)","v":"William"},95,null,null,null,null,null,"John",45]
[null,"Mary",85,null,2,"Susan",94,null,null,null,null,null,"Mary",85]
[null,"William",95,null,3,"Mary",85,null,null,null,null,null,"William",95]
[null,"Jennifer",47,null,4,"Charles",79,null,null,null,null,null,"Jennifer",47]
[null,"Linda",39,null,5,"Robert",76,null,null,null,null,null,"Linda",39]
[null,"Thomas",45,null,6,"Joseph",70,null,null,null,null,null,"Thomas",45]
[null,"Susan",94,null,7,"Betty",65,null,null,null,null,null,"Susan",94]
[null,"Joseph",70,null,8,"Jessica",57,null,null,null,null,null,"Joseph",70]
[null,"Barbara",48,null,9,"James",56,null,null,null,null,null,"Barbara",48]
[null,"Jessica",57,null,10,"Barbara",48,null,null,null,null,null,"Jessica",57]
[null,"Charles",79,null,null,null,null,null,null,null,null,null,"Charles",79]
[null,"Karen",47,null,"These 10 students will get a scholarship",null,null,null,null,null,null,null,"Karen",47]
[null,"Nancy",45,null,null,null,null,null,null,null,null,null,"Nancy",45]
[null,"Betty",65,null,null,null,null,null,null,null,null,null,"Betty",65]

{"sheet":"Range","index":1,"n_rows":20,"n_cols":13,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"Run VBA Macro When a Cell Value in Range is Changed",null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Students Name","Marks",null,null,null,null,null,null,null,null,"Students Name","Marks"]
[null,"James",56,null,null,null,null,null,null,null,null,"James",56]
[null,"Robert",76,null,null,null,null,null,null,null,null,"Robert",76]
[null,"John",93,null,null,null,null,null,null,null,null,"John",93]
[null,"Mary",85,null,null,null,null,null,null,null,null,"Mary",85]
[null,"William",93,null,null,null,null,null,null,null,null,"William",93]
[null,"Jennifer",50,null,null,null,null,null,null,null,null,"Jennifer",50]
[null,"Linda",65,null,null,null,null,null,null,null,null,"Linda",65]
[null,"Thomas",70,null,null,null,null,null,null,null,null,"Thomas",70]
[null,"Susan",52,null,null,null,null,null,null,null,null,"Susan",52]
[null,"Joseph",70,null,null,null,null,null,null,null,null,"Joseph",70]
[null,"Barbara",72,null,null,null,null,null,null,null,null,"Barbara",72]
[null,"Jessica",57,null,null,null,null,null,null,null,null,"Jessica",57]
[null,"Charles",89,null,null,null,null,null,null,null,null,"Charles",89]
[null,"Karen",93,null,null,null,null,null,null,null,null,"Karen",93]
[null,"Nancy",45,null,null,null,null,null,null,null,null,"Nancy",45]
[null,"Betty",65,null,null,null,null,null,null,null,null,"Betty",65]

{"sheet":"Drop-Down menu","index":2,"n_rows":20,"n_cols":17,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,6],[17,4,17,6],[1,13,1,17]]}
[]
[null,"Run VBA Macro When Value in Drop-Down List Changes",null,null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Students Name","Marks",null,"Top",4,null,null,null,null,null,null,null,"Students Name","Marks",null,"Top"]
[null,"James",56,null,null,null,null,null,null,null,null,null,null,"James",56]
[null,"Robert",76,null,"Rank","Students Name","Marks",null,null,null,null,null,null,"Robert",76]
[null,"John",45,null,{"$f":"IF(COUNT($C$6:$C$21)>F4,_xlfn.SEQUENCE(F4),\"\")","v":1},{"$f":"_xlfn._xlws.SORT(_xlfn._xlws.FILTER($B$5:$C$21,$C$5:$C$21>=LARGE($C$5:$C$21,F4)),2,-1)","v":"William"},95,null,null,null,null,null,null,"John",45]
[null,"Mary",85,null,2,"Susan",94,null,null,null,null,null,null,"Mary",85]
[null,"William",95,null,3,"Mary",85,null,null,null,null,null,null,"William",95]
[null,"Jennifer",47,null,4,"Charles",79,null,null,null,null,null,null,"Jennifer",47]
[null,"Linda",39,null,null,null,null,null,null,null,null,null,null,"Linda",39]
[null,"Thomas",45,null,null,null,null,null,null,null,null,null,null,"Thomas",45]
[null,"Susan",94,null,null,null,null,null,null,null,null,null,null,"Susan",94]
[null,"Joseph",70,null,null,null,null,null,null,null,null,null,null,"Joseph",70]
[null,"Barbara",48,null,null,null,null,null,null,null,null,null,null,"Barbara",48]
[null,"Jessica",57,null,null,null,null,null,null,null,null,null,null,"Jessica",57]
[null,"Charles",79,null,null,null,null,null,null,null,null,null,null,"Charles",79]
[null,"Karen",47,null,"These 4 students will get scholarship",null,null,null,null,null,null,null,null,"Karen",47]
[null,"Nancy",45,null,null,null,null,null,null,null,null,null,null,"Nancy",45]
[null,"Betty",65,null,null,null,null,null,null,null,null,null,null,"Betty",65]

{"sheet":"Formularesult change","index":3,"n_rows":10,"n_cols":19,"rows_kept":10,"cut":false,"hidden":false,"merged":[[3,1,4,1],[3,2,3,4],[3,5,4,5],[1,1,1,5],[1,14,1,18],[3,14,4,14],[3,15,3,17],[3,18,4,18]]}
[]
[null,"Run VBA Macro When Cell Value Changes By Formula",null,null,null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Students","Obtained Marks",null,null,"Total",null,null,null,null,null,null,null,null,"Students","Obtained Marks",null,null,"Total"]
[null,null,"Physics","Chemistry","Mathematics",null,null,null,null,null,null,null,null,null,null,"Physics","Chemistry","Mathematics"]
[null,"Wade",98,96,86,{"$f":"SUM(C6:E6)","v":280},null,null,null,null,null,null,null,null,"Wade",98,96,86,{"$f":"SUM(P6:R6)","v":280}]
[null,"Dave",45,85,85,{"$f":"SUM(C7:E7)","v":215},null,null,null,null,null,null,null,null,"Dave",45,85,85,{"$f":"SUM(P7:R7)","v":215}]
[null,"Seth",98,87,98,{"$f":"SUM(C8:E8)","v":283},null,null,null,null,null,null,null,null,"Seth",98,87,98,{"$f":"SUM(P8:R8)","v":283}]
[null,"Riley",69,85,85,{"$f":"SUM(C9:E9)","v":239},null,null,null,null,null,null,null,null,"Riley",69,85,85,{"$f":"SUM(P9:R9)","v":239}]
[null,"Gilbert",75,61,78,{"$f":"SUM(C10:E10)","v":214},null,null,null,null,null,null,null,null,"Gilbert",75,61,78,{"$f":"SUM(P10:R10)","v":214}]

{"sheet":"Cell selection","index":4,"n_rows":10,"n_cols":19,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5],[3,1,4,1],[3,2,3,5],[1,14,1,18],[3,14,4,14],[3,15,3,18]]}
[]
[null,"Run VBA Macro When Specific Cell is Selected",null,null,null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Students","Obtained Marks",null,null,null,null,null,null,null,null,null,null,null,"Students","Obtained Marks"]
[null,null,"Physics","Chemistry","Mathematics","Total",null,null,null,null,null,null,null,null,null,"Physics","Chemistry","Mathematics","Total"]
[null,"Wade",98,96,86,{"$f":"SUM(C6:E6)","v":280},null,null,null,null,null,null,null,null,"Wade",98,96,86,{"$f":"SUM(P6:R6)","v":280}]
[null,"Dave",45,85,85,{"$f":"SUM(C7:E7)","v":215},null,null,null,null,null,null,null,null,"Dave",45,85,85,{"$f":"SUM(P7:R7)","v":215}]
[null,"Seth",98,87,98,{"$f":"SUM(C8:E8)","v":283},null,null,null,null,null,null,null,null,"Seth",98,87,98,{"$f":"SUM(P8:R8)","v":283}]
[null,"Riley",69,85,85,{"$f":"SUM(C9:E9)","v":239},null,null,null,null,null,null,null,null,"Riley",69,85,85,{"$f":"SUM(P9:R9)","v":239}]
[null,"Gilbert",75,61,78,{"$f":"SUM(C10:E10)","v":214},null,null,null,null,null,null,null,null,"Gilbert",75,61,78,{"$f":"SUM(P10:R10)","v":214}]