{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Title","Method1","Method2","Wrap Up"],"not_rendered":{"charts":0,"images":7,"macros":0,"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":"Title","index":0,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,2099]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Image credit: Olaf Pictures / Pixabay"]

{"sheet":"Method1","index":1,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["XYZ Company"]
["Inventory Report"]
["June 9, 2017"]
[]
["Product","OH","Orders","Safety Stock","MOQ","Avail","Order"]
["Book 1",840,0,20,36,{"$f":"B6-SUM(C6:D6)","v":820},{"$f":"IF(F6>0,0,ROUNDUP(-F6/E6,0)*E6)","v":0}]
["Book 2",550,200,40,12,{"$f":"B7-SUM(C7:D7)","v":310},{"$f":"IF(F7>0,0,ROUNDUP(-F7/E7,0)*E7)","v":0}]
["Book 3",10,0,20,36,-10,36]
["Book 4",770,0,30,12,740,0]
["Book 5",480,300,20,12,160,0]
["Book 6",820,0,20,24,800,0]
["Book 7",30,100,40,12,-110,120]
["Book 8",190,0,10,24,180,0]
["Book 9",800,0,50,36,750,0]
["Book 10",520,0,50,36,470,0]
["Book 11",430,0,10,24,420,0]
["Book 12",40,200,50,24,-210,216]
["Book 13",990,0,20,36,970,0]
["Book 14",830,0,30,36,800,0]
["Book 15",480,0,10,36,470,0]
["Book 16",470,0,20,24,450,0]
["Book 17",600,0,20,12,580,0]

{"sheet":"Method2","index":2,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["XYZ Company"]
["Inventory Report"]
["June 9, 2017"]
[]
["Product","OH","Orders","Safety Stock","MOQ","Avail","Order"]
["Book 1",840,0,20,36,{"$f":"B6-SUM(C6:D6)","v":820},{"$f":"IF(F6>0,0,ROUNDUP(-F6/E6,0)*E6)","v":0}]
["Book 2",550,200,40,12,{"$f":"B7-SUM(C7:D7)","v":310},{"$f":"IF(F7>0,0,ROUNDUP(-F7/E7,0)*E7)","v":0}]
["Book 3",10,0,20,36,-10,36]
["Book 4",770,0,30,12,740,0]
["Book 5",480,300,20,12,160,0]
["Book 6",820,0,20,24,800,0]
["Book 7",30,100,40,12,-110,120]
["Book 8",190,0,10,24,180,0]
["Book 9",800,0,50,36,750,0]
["Book 10",520,0,50,36,470,0]
["Book 11",430,0,10,24,420,0]
["Book 12",40,200,50,24,-210,216]
["Book 13",990,0,20,36,970,0]
["Book 14",830,0,30,36,800,0]
["Book 15",480,0,10,36,470,0]
["Book 16",470,0,20,24,450,0]
["Book 17",600,0,20,12,580,0]

{"sheet":"Wrap Up","index":3,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Topics in this Episode"]
[]
[null,"How to subtract a value from a column in Excel"]
[null,"Method 1: Temporary column with =D6-3, Copy and Paste values"]
[null,"Method 2: Put the 3 in any cell. Copy it. Paste Special, Subtract"]