{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Dataset","Dataset With Border","Border Weight Syntax","Border_ActiveCell","For Each Loop","Based on Selection","Numeric Cell Value","When Some Cells Empty","Cell_Text_Value","Cell_Date_Value","Borders Edge Property","Border Value","Colored Border","Line Style","Different Borders","Remove Borders","Practice Section"],"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":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,7],[3,3,3,4],[3,5,3,6],[3,1,4,1],[3,2,4,2],[12,1,12,2],[13,1,13,2],[3,7,4,7],[12,3,12,4],[12,5,12,6],[13,3,13,4],[13,5,13,6]]}
[]
[null,"Sample Dataset"]
[]
[null,"Student Name","Student ID","Midterm Exam",null,"Final Exam",null,"Final Mark"]
[null,null,null,"Raw Mark","Percent","Raw Mark","Percent"]
[null,"Lily Henderson",3923,35,{"$f":"D6/$D$13","v":0.35},55,{"$f":"F6/$F$13","v":0.27500000000000002},{"$f":"(E6*$D$14)+(G6*$F$14)","v":0.30499999999999999}]
[null,"Hannah Martinez",3956,95,0.95,197,0.98499999999999999,0.97099999999999997]
[null,"William Phillips",3985,80,0.8,160,0.8,0.8]
[null,"Xavier Perez",7048,40,0.4,43,0.215,0.28900000000000003]
[null,"Elijah Coleman",7650,100,1,195,0.97499999999999998,0.98499999999999999]
[null,"Clara Sanchez",7807,68,0.68,200,1,0.872]
[null,"Isaac Stewart",8187,85,0.85,122,0.61,0.70599999999999996]
[null,"Total Marks",null,100,null,200]
[null,"Weighted Average",null,0.4,null,0.6]

{"sheet":"Dataset With Border","index":1,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[12,1,12,2],[12,3,12,4],[12,5,12,6],[13,1,13,2],[13,3,13,4],[13,5,13,6],[1,1,1,7],[3,1,4,1],[3,2,4,2],[3,3,3,4],[3,5,3,6],[3,7,4,7]]}
[]
[null,"Adding Borders Using VBA Code"]
[]
[null,"Student Name","Student ID","Midterm Exam",null,"Final Exam",null,"Final Mark"]
[null,null,null,"Raw Mark","Percent","Raw Mark","Percent"]
[null,"Lily Henderson",3923,35,{"$f":"D6/$D$13","v":0.35},55,{"$f":"F6/$F$13","v":0.27500000000000002},{"$f":"(E6*$D$14)+(G6*$F$14)","v":0.30499999999999999}]
[null,"Hannah Martinez",3956,95,0.95,197,0.98499999999999999,0.97099999999999997]
[null,"William Phillips",3985,80,0.8,160,0.8,0.8]
[null,"Xavier Perez",7048,40,0.4,43,0.215,0.28900000000000003]
[null,"Elijah Coleman",7650,100,1,195,0.97499999999999998,0.98499999999999999]
[null,"Clara Sanchez",7807,68,0.68,200,1,0.872]
[null,"Isaac Stewart",8187,85,0.85,122,0.61,0.70599999999999996]
[null,"Total Marks",null,100,null,200]
[null,"Weighted Average",null,0.4,null,0.6]

{"sheet":"Border Weight Syntax","index":2,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[12,1,12,2],[12,3,12,4],[12,5,12,6],[13,1,13,2],[13,3,13,4],[13,5,13,6],[1,1,1,7],[3,1,4,1],[3,2,4,2],[3,3,3,4],[3,5,3,6],[3,7,4,7]]}
[]
[null,"Use of Borders Weight Property"]
[]
[null,"Student Name","Student ID","Midterm Exam",null,"Final Exam",null,"Final Mark"]
[null,null,null,"Raw Mark","Percent","Raw Mark","Percent"]
[null,"Lily Henderson",3923,35,{"$f":"D6/$D$13","v":0.35},55,{"$f":"F6/$F$13","v":0.27500000000000002},{"$f":"(E6*$D$14)+(G6*$F$14)","v":0.30499999999999999}]
[null,"Hannah Martinez",3956,95,0.95,197,0.98499999999999999,0.97099999999999997]
[null,"William Phillips",3985,80,0.8,160,0.8,0.8]
[null,"Xavier Perez",7048,40,0.4,43,0.215,0.28900000000000003]
[null,"Elijah Coleman",7650,100,1,195,0.97499999999999998,0.98499999999999999]
[null,"Clara Sanchez",7807,68,0.68,200,1,0.872]
[null,"Isaac Stewart",8187,85,0.85,122,0.61,0.70599999999999996]
[null,"Total Marks",null,100,null,200]
[null,"Weighted Average",null,0.4,null,0.6]

{"sheet":"Border_ActiveCell","index":3,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[15,1,16,2],[12,1,12,2],[12,3,12,4],[12,5,12,6],[13,1,13,2],[13,3,13,4],[13,5,13,6],[1,1,1,7],[3,1,4,1],[3,2,4,2],[3,3,3,4],[3,5,3,6],[3,7,4,7]]}
[]
[null,"Employing Borders Weight Property for Active Cell"]
[]
[null,"Student Name","Student ID","Midterm Exam",null,"Final Exam",null,"Final Mark"]
[null,null,null,"Raw Mark","Percent","Raw Mark","Percent"]
[null,"Lily Henderson",3923,35,0.35,55,0.27500000000000002,0.30499999999999999]
[null,"Hannah Martinez",3956,95,0.95,197,0.98499999999999999,0.97099999999999997]
[null,"William Phillips",3985,80,0.8,160,0.8,0.8]
[null,"Xavier Perez",7048,40,0.4,43,0.215,0.28900000000000003]
[null,"Elijah Coleman",7650,100,1,195,0.97499999999999998,0.98499999999999999]
[null,"Clara Sanchez",7807,68,0.68,200,1,0.872]
[null,"Isaac Stewart",8187,85,0.85,122,0.61,0.70599999999999996]
[null,"Total Marks",null,100,null,200]
[null,"Weighted Average",null,0.4,null,0.6]
[]
[null,"After Selecting a Cell >> Press Here"]

{"sheet":"For Each Loop","index":4,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[12,1,12,2],[12,3,12,4],[12,5,12,6],[13,1,13,2],[13,3,13,4],[13,5,13,6],[1,1,1,7],[3,1,4,1],[3,2,4,2],[3,3,3,4],[3,5,3,6],[3,7,4,7]]}
[]
[null,"Employing For Each Loop to Change Border Weight of a Certain Range"]
[]
[null,"Student Name","Student ID","Midterm Exam",null,"Final Exam",null,"Final Mark"]
[null,null,null,"Raw Mark","Percent","Raw Mark","Percent"]
[null,"Lily Henderson",3923,35,{"$f":"D6/$D$13","v":0.35},55,{"$f":"F6/$F$13","v":0.27500000000000002},{"$f":"(E6*$D$14)+(G6*$F$14)","v":0.30499999999999999}]
[null,"Hannah Martinez",3956,95,0.95,197,0.98499999999999999,0.97099999999999997]
[null,"William Phillips",3985,80,0.8,160,0.8,0.8]
[null,"Xavier Perez",7048,40,0.4,43,0.215,0.28900000000000003]
[null,"Elijah Coleman",7650,100,1,195,0.97499999999999998,0.98499999999999999]
[null,"Clara Sanchez",7807,68,0.68,200,1,0.872]
[null,"Isaac Stewart",8187,85,0.85,122,0.61,0.70599999999999996]
[null,"Total Marks",null,100,null,200]
[null,"Weighted Average",null,0.4,null,0.6]

{"sheet":"Based on Selection","index":5,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[12,1,12,2],[12,3,12,4],[12,5,12,6],[13,1,13,2],[13,3,13,4],[13,5,13,6],[1,1,1,7],[3,1,4,1],[3,2,4,2],[3,3,3,4],[3,5,3,6],[3,7,4,7]]}
[]
[null,"Changing Border Weight Within Selected Range"]
[]
[null,"Student Name","Student ID","Midterm Exam",null,"Final Exam",null,"Final Mark"]
[null,null,null,"Raw Mark","Percent","Raw Mark","Percent"]
[null,"Lily Henderson",3923,35,{"$f":"D6/$D$13","v":0.35},55,{"$f":"F6/$F$13","v":0.27500000000000002},{"$f":"(E6*$D$14)+(G6*$F$14)","v":0.30499999999999999}]
[null,"Hannah Martinez",3956,95,0.95,197,0.98499999999999999,0.97099999999999997]
[null,"William Phillips",3985,80,0.8,160,0.8,0.8]
[null,"Xavier Perez",7048,40,0.4,43,0.215,0.28900000000000003]
[null,"Elijah Coleman",7650,100,1,195,0.97499999999999998,0.98499999999999999]
[null,"Clara Sanchez",7807,68,0.68,200,1,0.872]
[null,"Isaac Stewart",8187,85,0.85,122,0.61,0.70599999999999996]
[null,"Total Marks",null,100,null,200]
[null,"Weighted Average",null,0.4,null,0.6]

{"sheet":"Numeric Cell Value","index":6,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[12,1,12,2],[12,3,12,4],[12,5,12,6],[13,1,13,2],[13,3,13,4],[13,5,13,6],[1,1,1,7],[3,1,4,1],[3,2,4,2],[3,3,3,4],[3,5,3,6],[3,7,4,7]]}
[]
[null,"Inserting Border with Borders.Weight Property for a Numeric Condition"]
[]
[null,"Student Name","Student ID","Midterm Exam",null,"Final Exam",null,"Final Mark"]
[null,null,null,"Raw Mark","Percent","Raw Mark","Percent"]
[null,"Lily Henderson",null,35,{"$f":"D6/$D$13","v":0.35},55,{"$f":"F6/$F$13","v":0.27500000000000002},{"$f":"(E6*$D$14)+(G6*$F$14)","v":0.30499999999999999}]
[null,"Hannah Martinez",3956,95,0.95,197,0.98499999999999999,0.97099999999999997]
[null,"William Phillips",3985,80,0.8,null,0,0.32000000000000006]
[null,"Xavier Perez",7048,40,0.4,43,0.215,0.28900000000000003]
[null,"Elijah Coleman",7650,null,0,195,0.97499999999999998,0.58499999999999996]
[null,null,7807,68,0.68,200,1,0.872]
[null,"Isaac Stewart",8187,85,0.85,122,0.61,0.70599999999999996]
[null,"Total Marks",null,100,null,200]
[null,"Weighted Average",null,0.4,null,0.6]

{"sheet":"When Some Cells Empty","index":7,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Applying Borders.Weight Property When Cell Value Is Not Empty"]
[]
[null,null,null,"Midterm Exam",null,"Final Exam"]
[null,"Student Name","Student ID","Raw Mark","Percent","Raw Mark","Percent"]
[null,"Lily Henderson",null,35,{"$f":"D6/$D$13","v":0.35},55,{"$f":"F6/$F$13","v":0.27500000000000002}]
[null,"Hannah Martinez",3956,95,0.95,197,0.98499999999999999]
[null,"William Phillips",3985,80,0.8,null,0]
[null,"Xavier Perez",7048,40,0.4,43,0.215]
[null,"Elijah Coleman",7650,null,0,195,0.97499999999999998]
[null,null,7807,68,0.68,200,1]
[null,"Isaac Stewart",8187,85,0.85,122,0.61]
[null,"Total Marks",null,100,null,200]
[null,"Weighted Average",null,0.4,null,0.6]

{"sheet":"Cell_Text_Value","index":8,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Increasing Border Weight Based on Text Value"]
[]
[null,"ID","Full Name","Department","Hiring Date"]
[null,"E03611","Alice Mehta","Sales","2019-04-02"]
[null,"E04464","Cooper Yoon","Engineering","2018-02-15"]
[null,"E02135","John Delgado","IT","2017-02-11"]
[null,"E03362","Lily Henderson","Human Resources","2011-05-20"]
[null,"E01108","Hannah Martinez","Marketing"]
[null,"E02217","William Phillips","IT","2004-01-27"]
[null,"E03519","Eliza Zheng","IT","2014-04-20"]
[null,"E01967","John Dang","Sales","1992-03-19"]
[null,"E01125","Joshua Yang","IT","2018-11-10"]
[null,"E02563","Clara Sanchez","Engineering","2018-10-02"]

{"sheet":"Cell_Date_Value","index":9,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Changing Border Weight Based on Date Value"]
[]
[null,"ID","Full Name","Department","Hiring Date"]
[null,"E03611","Alice Mehta","Sales","2019-04-02"]
[null,"E04464","Cooper Yoon","Engineering","2018-02-15"]
[null,"E02135","John Delgado","IT","2017-02-11"]
[null,"E03362","Lily Henderson","Human Resources","2011-05-20"]
[null,"E01108","Hannah Martinez","Marketing"]
[null,"E02217","William Phillips","IT","2004-01-27"]
[null,"E03519","Eliza Zheng","IT","2014-04-20"]
[null,"E01967","John Dang","Sales","1992-03-19"]
[null,"E01125","Joshua Yang","IT","2018-11-10"]
[null,"E02563","Clara Sanchez","Engineering","2018-10-02"]

{"sheet":"Borders Edge Property","index":10,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[12,1,12,2],[12,3,12,4],[12,5,12,6],[13,1,13,2],[13,3,13,4],[13,5,13,6],[1,1,1,7],[3,1,4,1],[3,2,4,2],[3,3,3,4],[3,5,3,6],[3,7,4,7]]}
[]
[null,"Changing Border Weight for One Side of Cell with Edge Property"]
[]
[null,"Student Name","Student ID","Midterm Exam",null,"Final Exam",null,"Final Mark"]
[null,null,null,"Raw Mark","Percent","Raw Mark","Percent"]
[null,"Lily Henderson",3923,35,{"$f":"D6/$D$13","v":0.35},55,{"$f":"F6/$F$13","v":0.27500000000000002},{"$f":"(E6*$D$14)+(G6*$F$14)","v":0.30499999999999999}]
[null,"Hannah Martinez",3956,95,0.95,197,0.98499999999999999,0.97099999999999997]
[null,"William Phillips",3985,80,0.8,160,0.8,0.8]
[null,"Xavier Perez",7048,40,0.4,43,0.215,0.28900000000000003]
[null,"Elijah Coleman",7650,100,1,195,0.97499999999999998,0.98499999999999999]
[null,"Clara Sanchez",7807,68,0.68,200,1,0.872]
[null,"Isaac Stewart",8187,85,0.85,122,0.61,0.70599999999999996]
[null,"Total Marks",null,100,null,200]
[null,"Weighted Average",null,0.4,null,0.6]

{"sheet":"Border Value","index":11,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[15,1,16,2],[12,1,12,2],[12,3,12,4],[12,5,12,6],[13,1,13,2],[13,3,13,4],[13,5,13,6],[1,1,1,7],[3,1,4,1],[3,2,4,2],[3,3,3,4],[3,5,3,6],[3,7,4,7]]}
[]
[null,"Use of Borders Value Property"]
[]
[null,"Student Name","Student ID","Midterm Exam",null,"Final Exam",null,"Final Mark"]
[null,null,null,"Raw Mark","Percent","Raw Mark","Percent"]
[null,"Lily Henderson",3923,35,{"$f":"D6/$D$13","v":0.35},55,{"$f":"F6/$F$13","v":0.27500000000000002},{"$f":"(E6*$D$14)+(G6*$F$14)","v":0.30499999999999999}]
[null,"Hannah Martinez",3956,95,0.95,197,0.98499999999999999,0.97099999999999997]
[null,"William Phillips",3985,80,0.8,160,0.8,0.8]
[null,"Xavier Perez",7048,40,0.4,43,0.215,0.28900000000000003]
[null,"Elijah Coleman",7650,100,1,195,0.97499999999999998,0.98499999999999999]
[null,"Clara Sanchez",7807,68,0.68,200,1,0.872]
[null,"Isaac Stewart",8187,85,0.85,122,0.61,0.70599999999999996]
[null,"Total Marks",null,100,null,200]
[null,"Weighted Average",null,0.4,null,0.6]

{"sheet":"Colored Border","index":12,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[12,1,12,2],[12,3,12,4],[12,5,12,6],[13,1,13,2],[13,3,13,4],[13,5,13,6],[1,1,1,7],[3,1,4,1],[3,2,4,2],[3,3,3,4],[3,5,3,6],[3,7,4,7]]}
[]
[null,"Using Colors on Borders"]
[]
[null,"Student Name","Student ID","Midterm Exam",null,"Final Exam",null,"Final Mark"]
[null,null,null,"Raw Mark","Percent","Raw Mark","Percent"]
[null,"Lily Henderson",3923,35,{"$f":"D6/$D$13","v":0.35},55,{"$f":"F6/$F$13","v":0.27500000000000002},{"$f":"(E6*$D$14)+(G6*$F$14)","v":0.30499999999999999}]
[null,"Hannah Martinez",3956,95,0.95,197,0.98499999999999999,0.97099999999999997]
[null,"William Phillips",3985,80,0.8,160,0.8,0.8]
[null,"Xavier Perez",7048,40,0.4,43,0.215,0.28900000000000003]
[null,"Elijah Coleman",7650,100,1,195,0.97499999999999998,0.98499999999999999]
[null,"Clara Sanchez",7807,68,0.68,200,1,0.872]
[null,"Isaac Stewart",8187,85,0.85,122,0.61,0.70599999999999996]
[null,"Total Marks",null,100,null,200]
[null,"Weighted Average",null,0.4,null,0.6]

{"sheet":"Line Style","index":13,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[12,1,12,2],[12,3,12,4],[12,5,12,6],[13,1,13,2],[13,3,13,4],[13,5,13,6],[1,1,1,7],[3,1,4,1],[3,2,4,2],[3,3,3,4],[3,5,3,6],[3,7,4,7]]}
[]
[null,"Showing Different Types of Line Style"]
[]
[null,"Student Name","Student ID","Midterm Exam",null,"Final Exam",null,"Final Mark"]
[null,null,null,"Raw Mark","Percent","Raw Mark","Percent"]
[null,"Lily Henderson",3923,35,{"$f":"D6/$D$13","v":0.35},55,{"$f":"F6/$F$13","v":0.27500000000000002},{"$f":"(E6*$D$14)+(G6*$F$14)","v":0.30499999999999999}]
[null,"Hannah Martinez",3956,95,0.95,197,0.98499999999999999,0.97099999999999997]
[null,"William Phillips",3985,80,0.8,160,0.8,0.8]
[null,"Xavier Perez",7048,40,0.4,43,0.215,0.28900000000000003]
[null,"Elijah Coleman",7650,100,1,195,0.97499999999999998,0.98499999999999999]
[null,"Clara Sanchez",7807,68,0.68,200,1,0.872]
[null,"Isaac Stewart",8187,85,0.85,122,0.61,0.70599999999999996]
[null,"Total Marks",null,100,null,200]
[null,"Weighted Average",null,0.4,null,0.6]

{"sheet":"Different Borders","index":14,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[12,1,12,2],[12,3,12,4],[12,5,12,6],[13,1,13,2],[13,3,13,4],[13,5,13,6],[1,1,1,7],[3,1,4,1],[3,2,4,2],[3,3,3,4],[3,5,3,6],[3,7,4,7]]}
[]
[null,"Applying Different Borders Properties within Same Range"]
[]
[null,"Student Name","Student ID","Midterm Exam",null,"Final Exam",null,"Final Mark"]
[null,null,null,"Raw Mark","Percent","Raw Mark","Percent"]
[null,"Lily Henderson",3923,35,{"$f":"D6/$D$13","v":0.35},55,{"$f":"F6/$F$13","v":0.27500000000000002},{"$f":"(E6*$D$14)+(G6*$F$14)","v":0.30499999999999999}]
[null,"Hannah Martinez",3956,95,0.95,197,0.98499999999999999,0.97099999999999997]
[null,"William Phillips",3985,80,0.8,160,0.8,0.8]
[null,"Xavier Perez",7048,40,0.4,43,0.215,0.28900000000000003]
[null,"Elijah Coleman",7650,100,1,195,0.97499999999999998,0.98499999999999999]
[null,"Clara Sanchez",7807,68,0.68,200,1,0.872]
[null,"Isaac Stewart",8187,85,0.85,122,0.61,0.70599999999999996]
[null,"Total Marks",null,100,null,200]
[null,"Weighted Average",null,0.4,null,0.6]

{"sheet":"Remove Borders","index":15,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[12,1,12,2],[12,3,12,4],[12,5,12,6],[13,1,13,2],[13,3,13,4],[13,5,13,6],[1,1,1,7],[3,1,4,1],[3,2,4,2],[3,3,3,4],[3,5,3,6],[3,7,4,7]]}
[]
[null,"Removing Borders with VBA Code"]
[]
[null,"Student Name","Student ID","Midterm Exam",null,"Final Exam",null,"Final Mark"]
[null,null,null,"Raw Mark","Percent","Raw Mark","Percent"]
[null,"Lily Henderson",3923,35,{"$f":"D6/$D$13","v":0.35},55,{"$f":"F6/$F$13","v":0.27500000000000002},{"$f":"(E6*$D$14)+(G6*$F$14)","v":0.30499999999999999}]
[null,"Hannah Martinez",3956,95,0.95,197,0.98499999999999999,0.97099999999999997]
[null,"William Phillips",3985,80,0.8,160,0.8,0.8]
[null,"Xavier Perez",7048,40,0.4,43,0.215,0.28900000000000003]
[null,"Elijah Coleman",7650,100,1,195,0.97499999999999998,0.98499999999999999]
[null,"Clara Sanchez",7807,68,0.68,200,1,0.872]
[null,"Isaac Stewart",8187,85,0.85,122,0.61,0.70599999999999996]
[null,"Total Marks",null,100,null,200]
[null,"Weighted Average",null,0.4,null,0.6]

{"sheet":"Practice Section","index":16,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[12,1,12,2],[12,3,12,4],[12,5,12,6],[13,1,13,2],[13,3,13,4],[13,5,13,6],[1,1,1,7],[3,1,4,1],[3,2,4,2],[3,3,3,4],[3,5,3,6],[3,7,4,7]]}
[]
[null,"Do It Yourself"]
[]
[null,"Student Name","Student ID","Midterm Exam",null,"Final Exam",null,"Final Mark"]
[null,null,null,"Raw Mark","Percent","Raw Mark","Percent"]
[null,"Lily Henderson",3923,35,{"$f":"D6/$D$13","v":0.35},55,{"$f":"F6/$F$13","v":0.27500000000000002},{"$f":"(E6*$D$14)+(G6*$F$14)","v":0.30499999999999999}]
[null,"Hannah Martinez",3956,95,0.95,197,0.98499999999999999,0.97099999999999997]
[null,"William Phillips",3985,80,0.8,160,0.8,0.8]
[null,"Xavier Perez",7048,40,0.4,43,0.215,0.28900000000000003]
[null,"Elijah Coleman",7650,100,1,195,0.97499999999999998,0.98499999999999999]
[null,"Clara Sanchez",7807,68,0.68,200,1,0.872]
[null,"Isaac Stewart",8187,85,0.85,122,0.61,0.70599999999999996]
[null,"Total Marks",null,100,null,200]
[null,"Weighted Average",null,0.4,null,0.6]