{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","Formula","Paste Special","SUM Function","Text Subtraction","from One Single Cell","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":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Employee Cost List"]
[]
[null,"Id No","Name","Salary","House Rent","Grocery","Bills"]
[null,101,"Mark Smith",2000,500,300,400]
[null,102,"Ruth Will",3000,700,400,300]
[null,103,"Adam Louis",2500,600,450,500]
[null,104,"Rain Bekar",2200,560,250,450]
[null,105,"Lilly Davis",2800,650,320,350]
[null,106,"Jack Berry",3200,800,500,560]
[null,107,"Joe Grell",2700,550,440,380]
[null,108," Daniel Casto",2600,600,250,450]

{"sheet":"Formula","index":1,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Subtract Multiple Cells Using Formula"]
[]
[null,"Id No","Name","Salary","House Rent","Grocery","Bills",null,"Savings"]
[null,101,"Mark Smith",2000,500,300,400,null,{"$f":"D5-E5-F5-G5","v":800}]
[null,102,"Ruth Will",3000,700,400,300,null,{"$f":"D6-E6-F6-G6","v":1600}]
[null,103,"Adam Louis",2500,600,450,500,null,950]
[null,104,"Rain Bekar",2200,560,250,450,null,940]
[null,105,"Lilly Davis",2800,650,320,350,null,1480]
[null,106,"Jack Berry",3200,800,500,560,null,1340]
[null,107,"Joe Grell",2700,550,440,380,null,1330]
[null,108,"Daniel Casto",2600,600,250,450,null,{"$f":"D12-E12-F12-G12","v":1300}]

{"sheet":"Paste Special","index":2,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Subtract Multiple Cells Using Paste Special"]
[]
[null,"Id No","Name","Salary","House Rent","Grocery","Bills",null,"Health Insurance",null,"Post Insurance Salary"]
[null,101,"Mark Smith",1700,500,300,400,null,300,null,1700]
[null,102,"Ruth Will",2700,700,400,300,null,null,null,2700]
[null,103,"Adam Louis",2200,600,450,500,null,null,null,2200]
[null,104,"Rain Bekar",1900,560,250,450,null,null,null,1900]
[null,105,"Lilly Davis",2500,650,320,350,null,null,null,2500]
[null,106,"Jack Berry",2900,800,500,560,null,null,null,2900]
[null,107,"Joe Grell",2400,550,440,380,null,null,null,2400]
[null,108,"Daniel Casto",2300,600,250,450,null,null,null,2300]

{"sheet":"SUM Function","index":3,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Employee Cost List"]
[]
[null,"Id No","Name","Salary","House Rent","Grocery","Bills",null,"Savings"]
[null,101,"Mark Smith",2000,500,300,400,null,{"$f":"D5-SUM(E5:G5)","v":800}]
[null,102,"Ruth Will",3000,700,400,300,null,{"$f":"D6-SUM(E6:G6)","v":1600}]
[null,103,"Adam Louis",2500,600,450,500,null,950]
[null,104,"Rain Bekar",2200,560,250,450,null,940]
[null,105,"Lilly Davis",2800,650,320,350,null,1480]
[null,106,"Jack Berry",3200,800,500,560,null,1340]
[null,107,"Joe Grell",2700,550,440,380,null,1330]
[null,108,"Daniel Casto",2600,600,250,450,null,1300]

{"sheet":"Text Subtraction","index":4,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Employee Cost List"]
[]
[null,"Id No","Name","Last Name","Salary","House Rent","Grocery","Bills",null,"First Name"]
[null,101,"Mark Smith","Smith",2000,500,300,400,null,{"$f":"TRIM(SUBSTITUTE(C5,D5,\" \"))","v":"Mark"},null,{"$f":"TRIM(SUBSTITUTE(C5,D5,\" \"))","v":"Mark"}]
[null,102,"Ruth Will","Will",3000,700,400,300,null,{"$f":"TRIM(SUBSTITUTE(C6,D6,\" \"))","v":"Ruth"}]
[null,103,"Adam Louis","Louis",2500,600,450,500,null,"Adam"]
[null,104,"Rain Bekar","Bekar",2200,560,250,450,null,"Rain"]
[null,105,"Lilly Davis","Davis",2800,650,320,350,null,"Lilly"]
[null,106,"Jack Berry","Berry",3200,800,500,560,null,"Jack"]
[null,107,"Joe Grell","Grell",2700,550,440,380,null,"Joe"]
[null,108,"Daniel Casto","Casto",2600,600,250,450,null,"Daniel"]

{"sheet":"from One Single Cell","index":5,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Employee Cost List"]
[]
[null,"Id No","Name","Salary","House Rent","Grocery","Bills",null,"Expected Salary",null,"Underpay"]
[null,101,"Mark Smith",2000,500,300,400,null,4000,null,{"$f":"$I$5-D5","v":2000}]
[null,102,"Ruth Will",3000,700,400,300,null,null,null,{"$f":"$I$5-D6","v":1000}]
[null,103,"Adam Louis",2500,600,450,500,null,null,null,1500]
[null,104,"Rain Bekar",2200,560,250,450,null,null,null,1800]
[null,105,"Lilly Davis",2800,650,320,350,null,null,null,1200]
[null,106,"Jack Berry",3200,800,500,560,null,null,null,800]
[null,107,"Joe Grell",2700,550,440,380,null,null,null,1300]
[null,108,"Daniel Casto",2600,600,250,450,null,null,null,1400]

{"sheet":"VBA Code","index":6,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Employee Cost List"]
[]
[null,"Id No","Name","Salary","House Rent","Grocery","Bills",null,"Expected Salary"]
[null,101,"Mark Smith",2000,500,300,400,null,4000]
[null,102,"Ruth Will",3000,700,400,300]
[null,103,"Adam Louis",2500,600,450,500]
[null,104,"Rain Bekar",2200,560,250,450]
[null,105,"Lilly Davis",2800,650,320,350]
[null,106,"Jack Berry",3200,800,500,560]
[null,107,"Joe Grell",2700,550,440,380]
[null,108," Daniel Casto",2600,600,250,450]