{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Dataset","Calculation Option","Using VBA","For Practice"],"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":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"Stop Formula to Convert into Value Automatically in Excel"]
[]
[null,"Student Name","Physics","Chemistry","Math","Total Marks"]
[null,"Robert Hills",62,70,85,{"$f":"SUM(C6:E6)","v":217}]
[null,"John Kabir",70,75,99,{"$f":"SUM(C7:E7)","v":244}]
[null,"Tom Hanks",69,72,84,{"$f":"SUM(C8:E8)","v":225}]
[null,"Manuel jack",96,81,53,{"$f":"SUM(C9:E9)","v":230}]
[null,"Austin Cooper",77,84,98,{"$f":"SUM(C10:E10)","v":259}]
[null,"Max Green",69,72,84,{"$f":"SUM(C11:E11)","v":225}]
[null,"David Thompson",96,81,53,{"$f":"SUM(C12:E12)","v":230}]
[null,"Rose Moore",87,77,94,{"$f":"SUM(C13:E13)","v":258}]
[null,"Samual Jackson",98,61,85,{"$f":"SUM(C14:E14)","v":244}]
[null,"Jimmy Black",79,64,85,228]

{"sheet":"Calculation Option","index":1,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"Utilizing Calculation Options to Stop Formula to Value Conversion"]
[]
[null,"Student Name","Physics","Chemistry","Math","Total Marks"]
[null,"Robert Hills",62,70,85,{"$f":"SUM(C6:E6)","v":217}]
[null,"John Kabir",70,75,99,{"$f":"SUM(C7:E7)","v":244}]
[null,"Tom Hanks",69,72,84,{"$f":"SUM(C8:E8)","v":225}]
[null,"Manuel jack",96,81,53,{"$f":"SUM(C9:E9)","v":230}]
[null,"Austin Cooper",77,84,98,{"$f":"SUM(C10:E10)","v":259}]
[null,"Max Green",69,72,84,{"$f":"SUM(C11:E11)","v":225}]
[null,"David Thompson",96,81,53,{"$f":"SUM(C12:E12)","v":230}]
[null,"Rose Moore",87,77,94,{"$f":"SUM(C13:E13)","v":258}]
[null,"Samual Jackson",98,61,85,{"$f":"SUM(C14:E14)","v":244}]
[null,"Jimmy Black",79,64,85,228]

{"sheet":"Using VBA","index":2,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"Using VBA to stop automatically converting formul to value"]
[]
[null,"Student Name","Physics","Chemistry","Math","Total Marks"]
[null,"Robert Hills",62,70,85,{"$f":"SUM(C6:E6)","v":217}]
[null,"John Kabir",70,75,99,{"$f":"SUM(C7:E7)","v":244}]
[null,"Tom Hanks",69,72,84,{"$f":"SUM(C8:E8)","v":225}]
[null,"Manuel jack",96,81,53,{"$f":"SUM(C9:E9)","v":230}]
[null,"Austin Cooper",77,84,98,{"$f":"SUM(C10:E10)","v":259}]
[null,"Max Green",69,72,84,{"$f":"SUM(C11:E11)","v":225}]
[null,"David Thompson",96,81,53,{"$f":"SUM(C12:E12)","v":230}]
[null,"Rose Moore",87,77,94,{"$f":"SUM(C13:E13)","v":258}]
[null,"Samual Jackson",98,61,85,{"$f":"SUM(C14:E14)","v":244}]
[null,"Jimmy Black",79,64,85,228]

{"sheet":"For Practice","index":3,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"Stop Formula to Convert into Value Automatically in Excel"]
[]
[null,"Student Name","Physics","Chemistry","Math","Total Marks"]
[null,"Robert Hills",62,70,85]
[null,"John Kabir",70,75,99]
[null,"Tom Hanks",69,72,84]
[null,"Manuel jack",96,81,53]
[null,"Austin Cooper",77,84,98]
[null,"Max Green",69,72,84]
[null,"David Thompson",96,81,53]
[null,"Rose Moore",87,77,94]
[null,"Samual Jackson",98,61,85]
[null,"Jimmy Black",79,64,85]