{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Title","RegularTrackChanges","Sheet1","MoreFormulaCells","Recap","ShowTrackChanges"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":1,"defined_names":23,"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,2059]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Image credit: Bill Jelen / We Report Space"]

{"sheet":"RegularTrackChanges","index":1,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Input Cells",null,"Formula Cells"]
[1,null,{"$f":"A2*2","v":2},{"$f":"C2+1","v":3},{"$f":"D2+1","v":4},5,6,7,8,9]
[2,null,{"$f":"A3*2","v":4},{"$f":"C3+1","v":5},6,7,8,9,10,{"$f":"J2+1","v":10}]
[3,null,6,{"$f":"C4+1","v":7},8,9,10,11,12,{"$f":"J3+1","v":11}]
[4,null,8,{"$f":"C5+1","v":9},10,11,12,13,14,12]
[null,null,{"$f":"C2+C4","v":8},{"$f":"D4+1","v":8},9,10,11,12,{"$f":"AVERAGE(I5,H4)","v":12.5},13]
[null,null,{"$f":"C3+C5","v":12},{"$f":"D6+1","v":9},10,11,12,13,{"$f":"AVERAGE(I6,H5)","v":12.75},14]
[null,null,14,{"$f":"D7+1","v":10},11,12,13,14,{"$f":"AVERAGE(I7,H6)","v":12.375},15]
[null,null,20,{"$f":"D2+1","v":4},{"$f":"E2+1","v":5},6,7,8,{"$f":"AVERAGE(I8,H7)","v":12.6875},16]
[null,null,22,{"$f":"D3+1","v":6},7,8,9,10,{"$f":"AVERAGE(I9,H8)","v":13.34375},17]
[null,null,32,8,9,10,11,12,10.671875,18]
[null,null,36,10,11,12,13,14,10.3359375,19]
[null,null,52,9,10,11,12,13,11.16796875,20]
[null,null,58,10,11,12,13,14,12.583984375,21]
[null,null,84,11,12,13,14,15,12.7919921875,22]
[null,null,94,{"$f":"1+E16","v":29},28,27,26,25,{"$f":"1+J16","v":24},23]

{"sheet":"Sheet1","index":2,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Input Cells",null,"Formula Cells"]
[1,null,{"$f":"A2*2","v":2},{"$f":"C2+1","v":3},{"$f":"D2+1","v":4},5,6,7,8,9]
[2,null,{"$f":"A3*2","v":4},{"$f":"C3+1","v":5},6,7,8,9,10,{"$f":"J2+1","v":10}]
[3,null,6,{"$f":"C4+1","v":7},8,9,10,11,12,{"$f":"J3+1","v":11}]
[4,null,8,{"$f":"C5+1","v":9},10,11,12,13,14,12]
[null,null,{"$f":"C2+C4","v":8},{"$f":"D4+1","v":8},9,10,11,12,{"$f":"AVERAGE(I5,H4)","v":12.5},13]
[null,null,{"$f":"C3+C5","v":12},{"$f":"D6+1","v":9},10,11,12,13,{"$f":"AVERAGE(I6,H5)","v":12.75},14]
[null,null,14,{"$f":"D7+1","v":10},11,12,13,14,{"$f":"AVERAGE(I7,H6)","v":12.375},15]
[null,null,20,{"$f":"D2+1","v":4},{"$f":"E2+1","v":5},6,7,8,{"$f":"AVERAGE(I8,H7)","v":12.6875},16]
[null,null,22,{"$f":"D3+1","v":6},7,8,9,10,{"$f":"AVERAGE(I9,H8)","v":13.34375},17]
[null,null,32,{"$f":"D4+1","v":8},9,10,11,12,10.671875,18]
[null,null,36,{"$f":"D5+1","v":10},11,12,13,14,10.3359375,19]
[null,null,52,{"$f":"D6+1","v":9},10,11,12,13,11.16796875,20]
[null,null,58,{"$f":"D7+1","v":10},11,12,13,14,12.583984375,21]
[null,null,84,{"$f":"D8+1","v":11},12,13,14,15,12.7919921875,22]
[null,null,94,{"$f":"1+E16","v":29},28,27,26,25,{"$f":"1+J16","v":24},23]

{"sheet":"MoreFormulaCells","index":3,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Formula Cells"]
[]
[null,null,null,{"$f":"Sheet1!D$3","v":5},{"$f":"Sheet1!E$3","v":6},{"$f":"Sheet1!F$3","v":7},{"$f":"Sheet1!G$3","v":8},{"$f":"Sheet1!H$3","v":9},{"$f":"Sheet1!I$3","v":10},{"$f":"Sheet1!J$3","v":10}]
[null,null,null,{"$f":"Sheet1!D$3","v":5},{"$f":"Sheet1!E$3","v":6},{"$f":"Sheet1!F$3","v":7},{"$f":"Sheet1!G$3","v":8},{"$f":"Sheet1!H$3","v":9},{"$f":"Sheet1!I$3","v":10},{"$f":"Sheet1!J$3","v":10}]
[null,null,null,{"$f":"Sheet1!D$3","v":5},{"$f":"Sheet1!E$3","v":6},{"$f":"Sheet1!F$3","v":7},{"$f":"Sheet1!G$3","v":8},{"$f":"Sheet1!H$3","v":9},{"$f":"Sheet1!I$3","v":10},{"$f":"Sheet1!J$3","v":10}]
[null,null,null,{"$f":"Sheet1!D$3","v":5},{"$f":"Sheet1!E$3","v":6},{"$f":"Sheet1!F$3","v":7},{"$f":"Sheet1!G$3","v":8},{"$f":"Sheet1!H$3","v":9},{"$f":"Sheet1!I$3","v":10},{"$f":"Sheet1!J$3","v":10}]
[null,null,null,{"$f":"Sheet1!D$3","v":5},{"$f":"Sheet1!E$3","v":6},{"$f":"Sheet1!F$3","v":7},{"$f":"Sheet1!G$3","v":8},{"$f":"Sheet1!H$3","v":9},{"$f":"Sheet1!I$3","v":10},{"$f":"Sheet1!J$3","v":10}]
[null,null,null,{"$f":"Sheet1!D$3","v":5},{"$f":"Sheet1!E$3","v":6},{"$f":"Sheet1!F$3","v":7},{"$f":"Sheet1!G$3","v":8},{"$f":"Sheet1!H$3","v":9},{"$f":"Sheet1!I$3","v":10},{"$f":"Sheet1!J$3","v":10}]
[null,null,null,{"$f":"Sheet1!C11","v":32},{"$f":"Sheet1!D11","v":8},{"$f":"Sheet1!E11","v":9},{"$f":"Sheet1!F11","v":10},{"$f":"Sheet1!G11","v":11},{"$f":"Sheet1!H11","v":12},{"$f":"Sheet1!I11","v":10.671875}]
[null,null,null,{"$f":"Sheet1!C12","v":36},{"$f":"Sheet1!D12","v":10},{"$f":"Sheet1!E12","v":11},{"$f":"Sheet1!F12","v":12},{"$f":"Sheet1!G12","v":13},{"$f":"Sheet1!H12","v":14},{"$f":"Sheet1!I12","v":10.3359375}]
[null,null,null,{"$f":"Sheet1!C13","v":52},{"$f":"Sheet1!D13","v":9},{"$f":"Sheet1!E13","v":10},{"$f":"Sheet1!F13","v":11},{"$f":"Sheet1!G13","v":12},{"$f":"Sheet1!H13","v":13},{"$f":"Sheet1!I13","v":11.16796875}]
[null,null,null,{"$f":"Sheet1!D$3","v":5},{"$f":"Sheet1!E$3","v":6},{"$f":"Sheet1!F$3","v":7},{"$f":"Sheet1!G$3","v":8},{"$f":"Sheet1!H$3","v":9},{"$f":"Sheet1!I$3","v":10},{"$f":"Sheet1!J$3","v":10}]
[null,null,null,{"$f":"Sheet1!D$3","v":5},{"$f":"Sheet1!E$3","v":6},{"$f":"Sheet1!F$3","v":7},{"$f":"Sheet1!G$3","v":8},{"$f":"Sheet1!H$3","v":9},{"$f":"Sheet1!I$3","v":10},{"$f":"Sheet1!J$3","v":10}]
[null,null,null,{"$f":"Sheet1!D$3","v":5},{"$f":"Sheet1!E$3","v":6},{"$f":"Sheet1!F$3","v":7},{"$f":"Sheet1!G$3","v":8},{"$f":"Sheet1!H$3","v":9},{"$f":"Sheet1!I$3","v":10},{"$f":"Sheet1!J$3","v":10}]
[null,null,null,{"$f":"Sheet1!D$3","v":5},{"$f":"Sheet1!E$3","v":6},{"$f":"Sheet1!F$3","v":7},{"$f":"Sheet1!G$3","v":8},{"$f":"Sheet1!H$3","v":9},{"$f":"Sheet1!I$3","v":10},{"$f":"Sheet1!J$3","v":10}]
[null,null,null,{"$f":"Sheet1!D$3","v":5},{"$f":"Sheet1!E$3","v":6},{"$f":"Sheet1!F$3","v":7},{"$f":"Sheet1!G$3","v":8},{"$f":"Sheet1!H$3","v":9},{"$f":"Sheet1!I$3","v":10},{"$f":"Sheet1!J$3","v":10}]

{"sheet":"Recap","index":4,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Track changes in Excel is a little bizarre."]
[null,"Goal is to track what formula cells in Excel change."]
[null,"Save As to save workbook as XLSM."]
[null,"Change Macro Security."]
[null,"Record a macro to figure out the code to set up conditional formatting for numbers not equal to 2."]
[null,"Choose the Formatting that you want."]
[null,"Record another macro to learn how to remove CF from worksheet."]
[null,"In the macro, add a loop for each worksheet."]
[null,"Add an IF statement to prevent it from running on Title."]
[null,"Add a loop to check each formula cell."]
[null,"Add Conditional Formatting to see if cell <> value at time macro runs."]
[null,"Go back to Excel."]
[null,"Add a shape. Assign the macro to the shape."]
[null,"Click the Shape to Run the Macro."]
[null,"Bonus Tip: Dragging a VBA module to a new workbook."]

{"sheet":"ShowTrackChanges","index":5,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Input Cells",null,"Formula Cells"]
[1,null,{"$f":"A2*2","v":2},{"$f":"C2+1","v":3},{"$f":"D2+1","v":4},5,6,7,8,9]
[22,null,{"$f":"A3*2","v":44},{"$f":"C3+1","v":45},46,47,48,49,50,{"$f":"J2+1","v":10}]
[3,null,6,{"$f":"C4+1","v":7},8,9,10,11,12,{"$f":"J3+1","v":11}]
[0.4,null,0.8,{"$f":"C5+1","v":1.8},2.8,3.8,4.8,5.8,6.8,12]
[null,null,{"$f":"C2+C4","v":8},{"$f":"D4+1","v":8},9,10,11,12,{"$f":"AVERAGE(I5,H4)","v":8.9},13]
[null,null,{"$f":"C3+C5","v":44.8},{"$f":"D6+1","v":9},10,11,12,13,{"$f":"AVERAGE(I6,H5)","v":7.35},14]
[]
[null,null,{"$f":"C4+C6","v":14},{"$f":"D7+1","v":10},11,12,13,14,{"$f":"AVERAGE(I7,H6)","v":9.6750000000000007},{"$f":"J7+1","v":15}]
[null,null,{"$f":"C5+C7","v":45.599999999999994},{"$f":"D2+1","v":4},{"$f":"E2+1","v":5},6,7,8,{"$f":"AVERAGE(I9,H7)","v":11.3375},16]
[null,null,{"$f":"C6+C9","v":22},46,{"$f":"E3+1","v":47},48,49,50,{"$f":"AVERAGE(I10,H9)","v":12.668749999999999},17]
[null,null,{"$f":"C7+C10","v":90.399999999999991},8,9,10,11,12,10.334375,18]
[null,null,36,2.8,3.8,4.8,5.8,6.8,30.167187500000001,19]
[null,null,136,9,10,11,12,13,21.083593749999999,20]
[null,null,58,10,11,12,13,14,13.941796875,21]
[null,null,226.39999999999998,{"$f":"D9+1","v":11},12,13,14,15,13.470898437500001,22]
[null,null,94,{"$f":"1+E17","v":29},28,27,26,25,{"$f":"1+J17","v":24},23]