{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Dataset","Formula Ribbon","Excel Options","FORMULATEXT","Leading Apostrophe","Leading Space","Format Cells","VBA Code"],"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,"List of Employee Salary "]
[]
[null,"Job ID","Name","Salary","Allowances","Total Salary"]
[null,44198,"James",2000,250,{"$f":"SUM(D5,E5)","v":2250}]
[null,44199,"Robert",1500,200,{"$f":"SUM(D6,E6)","v":1700}]
[null,44200,"John",2500,300,2800]
[null,44199,"Michael",3000,300,3300]
[null,44200,"William",2000,250,2250]
[null,44201,"David",2000,250,2250]
[null,44202,"Richard",2000,250,2250]
[null,44203,"Joseph",1500,200,1700]
[null,44204,"Thomas",2000,250,2250]

{"sheet":"Formula Ribbon","index":1,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using Formulas Ribbon"]
[]
[null,"Job ID","Name","Salary","Allowances","Total Salary"]
[null,44198,"James",2000,250,{"$f":"SUM(D5,E5)","v":2250}]
[null,44199,"Robert",1500,200,{"$f":"SUM(D6,E6)","v":1700}]
[null,44200,"John",2500,300,2800]
[null,44199,"Michael",3000,300,3300]
[null,44200,"William",2000,250,2250]
[null,44201,"David",2000,250,2250]
[null,44202,"Richard",2000,250,2250]
[null,44203,"Joseph",1500,200,1700]
[null,44204,"Thomas",2000,250,2250]

{"sheet":"Excel Options","index":2,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Utilizing Excel Options"]
[]
[null,"Job ID","Name","Salary","Allowances","Total Salary"]
[null,44198,"James",2000,250,{"$f":"SUM(D5,E5)","v":2250}]
[null,44199,"Robert",1500,200,{"$f":"SUM(D6,E6)","v":1700}]
[null,44200,"John",2500,300,2800]
[null,44199,"Michael",3000,300,3300]
[null,44200,"William",2000,250,2250]
[null,44201,"David",2000,250,2250]
[null,44202,"Richard",2000,250,2250]
[null,44203,"Joseph",1500,200,1700]
[null,44204,"Thomas",2000,250,2250]

{"sheet":"FORMULATEXT","index":3,"n_rows":13,"n_cols":16,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,11,1,15]]}
[]
[null,"Implementing FORMULATEXT Function",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Job ID","Name","Salary","Allowances","Basic Salary","Formula",null,null,null,null,"Job ID","Name","Salary","Allowances","Total Salary"]
[null,44198,"James",2000,250,{"$f":"SUM(D5,E5)","v":2250},{"$f":"_xlfn.FORMULATEXT(F5)","v":"=SUM(D5,E5)"},null,null,null,null,44198,"James",2000,250,{"$f":"SUM(N5,O5)","v":2250}]
[null,44199,"Robert",1500,200,{"$f":"SUM(D6,E6)","v":1700},{"$f":"_xlfn.FORMULATEXT(F6)","v":"=SUM(D6,E6)"},null,null,null,null,44199,"Robert",1500,200,{"$f":"SUM(N6,O6)","v":1700}]
[null,44200,"John",2500,300,2800,"=SUM(D7,E7)",null,null,null,null,44200,"John",2500,300,2800]
[null,44199,"Michael",3000,300,3300,"=SUM(D8,E8)",null,null,null,null,44199,"Michael",3000,300,3300]
[null,44200,"William",2000,250,2250,"=SUM(D9,E9)",null,null,null,null,44200,"William",2000,250,2250]
[null,44201,"David",2000,250,2250,"=SUM(D10,E10)",null,null,null,null,44201,"David",2000,250,2250]
[null,44202,"Richard",2000,250,2250,"=SUM(D11,E11)",null,null,null,null,44202,"Richard",2000,250,2250]
[null,44203,"Joseph",1500,200,1700,"=SUM(D12,E12)",null,null,null,null,44203,"Joseph",1500,200,1700]
[null,44204,"Thomas",2000,250,2250,"=SUM(D13,E13)",null,null,null,null,44204,"Thomas",2000,250,2250]

{"sheet":"Leading Apostrophe","index":4,"n_rows":13,"n_cols":16,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,11,1,15]]}
[]
[null,"Inserting Leading Apostrophe",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Job ID","Name","Salary","Allowances","Total Salary",null,null,null,null,null,"Job ID","Name","Salary","Allowances","Total Salary"]
[null,44198,"James",2000,250,"=SUM(D4,E4)",null,null,null,null,null,44198,"James",2000,250,{"$f":"SUM(N5,O5)","v":2250}]
[null,44199,"Robert",1500,200,"=SUM(D4,E4)",null,null,null,null,null,44199,"Robert",1500,200,{"$f":"SUM(N6,O6)","v":1700}]
[null,44200,"John",2500,300,"=SUM(D4,E4)",null,null,null,null,null,44200,"John",2500,300,2800]
[null,44199,"Michael",3000,300,"=SUM(D4,E4)",null,null,null,null,null,44199,"Michael",3000,300,3300]
[null,44200,"William",2000,250,"=SUM(D4,E4)",null,null,null,null,null,44200,"William",2000,250,2250]
[null,44201,"David",2000,250,"=SUM(D4,E4)",null,null,null,null,null,44201,"David",2000,250,2250]
[null,44202,"Richard",2000,250,"=SUM(D4,E4)",null,null,null,null,null,44202,"Richard",2000,250,2250]
[null,44203,"Joseph",1500,200,"=SUM(D4,E4)",null,null,null,null,null,44203,"Joseph",1500,200,1700]
[null,44204,"Thomas",2000,250,"=SUM(D4,E4)",null,null,null,null,null,44204,"Thomas",2000,250,2250]

{"sheet":"Leading Space","index":5,"n_rows":13,"n_cols":16,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,11,1,15]]}
[]
[null,"Using Leading Space",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Job ID","Name","Salary","Allowances","Total Salary",null,null,null,null,null,"Job ID","Name","Salary","Allowances","Total Salary"]
[null,44198,"James",2000,250,"  =SUM(D4,E4)",null,null,null,null,null,44198,"James",2000,250,{"$f":"SUM(N5,O5)","v":2250}]
[null,44199,"Robert",1500,200,"  =SUM(D5,E5)",null,null,null,null,null,44199,"Robert",1500,200,{"$f":"SUM(N6,O6)","v":1700}]
[null,44200,"John",2500,300,"  =SUM(D6,E6)",null,null,null,null,null,44200,"John",2500,300,2800]
[null,44199,"Michael",3000,300,"  =SUM(D7,E7)",null,null,null,null,null,44199,"Michael",3000,300,3300]
[null,44200,"William",2000,250,"  =SUM(D8,E8)",null,null,null,null,null,44200,"William",2000,250,2250]
[null,44201,"David",2000,250,"  =SUM(D9,E9)",null,null,null,null,null,44201,"David",2000,250,2250]
[null,44202,"Richard",2000,250,"  =SUM(D10,E10)",null,null,null,null,null,44202,"Richard",2000,250,2250]
[null,44203,"Joseph",1500,200,"  =SUM(D11,E11)",null,null,null,null,null,44203,"Joseph",1500,200,1700]
[null,44204,"Thomas",2000,250,"  =SUM(D12,E12)",null,null,null,null,null,44204,"Thomas",2000,250,2250]

{"sheet":"Format Cells","index":6,"n_rows":13,"n_cols":16,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,11,1,15]]}
[]
[null,"Employing Format Cells Option",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Job ID","Name","Salary","Allowances","Total Salary",null,null,null,null,null,"Job ID","Name","Salary","Allowances","Total Salary"]
[null,44198,"James",2000,250,"=SUM(D5,E5)",null,null,null,null,null,44198,"James",2000,250,{"$f":"SUM(N5,O5)","v":2250}]
[null,44199,"Robert",1500,200,"=SUM(D6,E6)",null,null,null,null,null,44199,"Robert",1500,200,{"$f":"SUM(N6,O6)","v":1700}]
[null,44200,"John",2500,300,"=SUM(D7,E7)",null,null,null,null,null,44200,"John",2500,300,2800]
[null,44199,"Michael",3000,300,"=SUM(D8,E8)",null,null,null,null,null,44199,"Michael",3000,300,3300]
[null,44200,"William",2000,250,"=SUM(D9,E9)",null,null,null,null,null,44200,"William",2000,250,2250]
[null,44201,"David",2000,250,"=SUM(D10,E10)",null,null,null,null,null,44201,"David",2000,250,2250]
[null,44202,"Richard",2000,250,"=SUM(D11,E11)",null,null,null,null,null,44202,"Richard",2000,250,2250]
[null,44203,"Joseph",1500,200,"=SUM(D12,E12)",null,null,null,null,null,44203,"Joseph",1500,200,1700]
[null,44204,"Thomas",2000,250,"=SUM(D13,E13)",null,null,null,null,null,44204,"Thomas",2000,250,2250]

{"sheet":"VBA Code","index":7,"n_rows":13,"n_cols":16,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,11,1,15]]}
[]
[null,"Incorporating VBA Code ",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Job ID","Name","Salary","Allowances","Total Salary","Formula",null,null,null,null,"Job ID","Name","Salary","Allowances","Total Salary"]
[null,44198,"James",2000,250,{"$f":"SUM(D5,E5)","v":2250},{"$f":"Disp_Form(F5)","v":"=SUM(D5,E5)"},null,null,null,null,44198,"James",2000,250,{"$f":"SUM(N5,O5)","v":2250}]
[null,44199,"Robert",1500,200,{"$f":"SUM(D6,E6)","v":1700},{"$f":"Disp_Form(F6)","v":"=SUM(D6,E6)"},null,null,null,null,44199,"Robert",1500,200,{"$f":"SUM(N6,O6)","v":1700}]
[null,44200,"John",2500,300,2800,{"$f":"Disp_Form(F7)","v":"=SUM(D7,E7)"},null,null,null,null,44200,"John",2500,300,2800]
[null,44199,"Michael",3000,300,3300,{"$f":"Disp_Form(F8)","v":"=SUM(D8,E8)"},null,null,null,null,44199,"Michael",3000,300,3300]
[null,44200,"William",2000,250,2250,{"$f":"Disp_Form(F9)","v":"=SUM(D9,E9)"},null,null,null,null,44200,"William",2000,250,2250]
[null,44201,"David",2000,250,2250,{"$f":"Disp_Form(F10)","v":"=SUM(D10,E10)"},null,null,null,null,44201,"David",2000,250,2250]
[null,44202,"Richard",2000,250,2250,{"$f":"Disp_Form(F11)","v":"=SUM(D11,E11)"},null,null,null,null,44202,"Richard",2000,250,2250]
[null,44203,"Joseph",1500,200,1700,{"$f":"Disp_Form(F12)","v":"=SUM(D12,E12)"},null,null,null,null,44203,"Joseph",1500,200,1700]
[null,44204,"Thomas",2000,250,2250,{"$f":"Disp_Form(F13)","v":"=SUM(D13,E13)"},null,null,null,null,44204,"Thomas",2000,250,2250]