{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Data Set","ABS Function","IF Function","SQRT Function","SIGN Function","MAX Function","Excel VBA","PIVOT Table","Power Query","Conditional Sum","Array SUM","Maximum Minimum Absolute Value","Average Absolute Value","Tolerance of Variance"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":1},"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":"Data Set","index":0,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Sales Review"]
[]
[null,"Brand","Yesterday's Sales","Today's Sales","Variance"]
[null,"Nike",1200,1150,{"$f":"D5-C5","v":-50}]
[null,"Adidas",1550,1400,{"$f":"D6-C6","v":-150}]
[null,"Fila",2300,2330,30]
[null,"Bata",1100,910,-190]
[null,"Gucci",1820,1250,-570]

{"sheet":"ABS Function","index":1,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,7,1,11]]}
[]
[null,"Using ABS Function",null,null,null,null,null,"Practice Section"]
[]
[null,"Brand","Yesterday's Sales","Today's Sales","Variance","Absolute Variance",null,"Brand","Yesterday's Sales","Today's Sales","Variance","Absolute Variance"]
[null,"Nike",1200,1150,{"$f":"D5-C5","v":-50},{"$f":"ABS(E5)","v":50},null,null,null,null,{"$f":"J5-I5","v":0},{"$f":"ABS(K5)","v":0}]
[null,"Adidas",1550,1400,{"$f":"D6-C6","v":-150},{"$f":"ABS(E6)","v":150},null,null,null,null,{"$f":"J6-I6","v":0},{"$f":"ABS(K6)","v":0}]
[null,"Fila",2300,2330,30,30,null,null,null,null,0,0]
[null,"Bata",1100,910,-190,190,null,null,null,null,0,0]
[null,"Gucci",1820,1250,-570,570,null,null,null,null,0,0]

{"sheet":"IF Function","index":2,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,7,1,11]]}
[]
[null,"Using IF Function",null,null,null,null,null,"Practice Section"]
[]
[null,"Brand","Yesterday's Sales","Today's Sales","Variance","Absolute Variance",null,"Brand","Yesterday's Sales","Today's Sales","Variance","Absolute Variance"]
[null,"Nike",1200,1150,{"$f":"D5-C5","v":-50},{"$f":"IF(E5<0,-E5,E5)","v":50},null,null,null,null,{"$f":"J5-I5","v":0},{"$f":"IF(K5<0,-K5,K5)","v":0}]
[null,"Adidas",1550,1400,{"$f":"D6-C6","v":-150},{"$f":"IF(E6<0,-E6,E6)","v":150},null,null,null,null,{"$f":"J6-I6","v":0},{"$f":"IF(K6<0,-K6,K6)","v":0}]
[null,"Fila",2300,2330,30,30,null,null,null,null,0,0]
[null,"Bata",1100,910,-190,190,null,null,null,null,0,0]
[null,"Gucci",1820,1250,-570,570,null,null,null,null,0,0]

{"sheet":"SQRT Function","index":3,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,7,1,11]]}
[]
[null,"Combination of SQRT & POWER Functions",null,null,null,null,null,"Practice Section"]
[]
[null,"Brand","Yesterday's Sales","Today's Sales","Variance","Absolute Variance",null,"Brand","Yesterday's Sales","Today's Sales","Variance","Absolute Variance"]
[null,"Nike",1200,1150,{"$f":"D5-C5","v":-50},{"$f":"SQRT(POWER(E5,2))","v":50},null,null,null,null,{"$f":"J5-I5","v":0},{"$f":"SQRT(POWER(K5,2))","v":0}]
[null,"Adidas",1550,1400,{"$f":"D6-C6","v":-150},{"$f":"SQRT(POWER(E6,2))","v":150},null,null,null,null,{"$f":"J6-I6","v":0},{"$f":"SQRT(POWER(K6,2))","v":0}]
[null,"Fila",2300,2330,30,30,null,null,null,null,0,0]
[null,"Bata",1100,910,-190,190,null,null,null,null,0,0]
[null,"Gucci",1820,1250,-570,570,null,null,null,null,0,0]

{"sheet":"SIGN Function","index":4,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,7,1,11]]}
[]
[null,"Using SIGN Function",null,null,null,null,null,"Practice Section"]
[]
[null,"Brand","Yesterday's Sales","Today's Sales","Variance","Absolute Variance",null,"Brand","Yesterday's Sales","Today's Sales","Variance","Absolute Variance"]
[null,"Nike",1200,1150,{"$f":"D5-C5","v":-50},{"$f":"SIGN(E5)*E5","v":50},null,null,null,null,{"$f":"J5-I5","v":0},{"$f":"SIGN(K5)*K5","v":0}]
[null,"Adidas",1550,1400,{"$f":"D6-C6","v":-150},{"$f":"SIGN(E6)*E6","v":150},null,null,null,null,{"$f":"J6-I6","v":0},{"$f":"SIGN(K6)*K6","v":0}]
[null,"Fila",2300,2330,30,30,null,null,null,null,0,0]
[null,"Bata",1100,910,-190,190,null,null,null,null,0,0]
[null,"Gucci",1820,1250,-570,570,null,null,null,null,0,0]

{"sheet":"MAX Function","index":5,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,7,1,11]]}
[]
[null,"Using MAX Function",null,null,null,null,null,"Practice Section"]
[]
[null,"Brand","Yesterday's Sales","Today's Sales","Variance","Absolute Variance",null,"Brand","Yesterday's Sales","Today's Sales","Variance","Absolute Variance"]
[null,"Nike",1200,1150,{"$f":"D5-C5","v":-50},{"$f":"MAX(-1*E5,E5)","v":50},null,null,null,null,{"$f":"J5-I5","v":0},{"$f":"MAX(-1*K5,K5)","v":0}]
[null,"Adidas",1550,1400,{"$f":"D6-C6","v":-150},{"$f":"MAX(-1*E6,E6)","v":150},null,null,null,null,{"$f":"J6-I6","v":0},{"$f":"MAX(-1*K6,K6)","v":0}]
[null,"Fila",2300,2330,30,30,null,null,null,null,0,0]
[null,"Bata",1100,910,-190,190,null,null,null,null,0,0]
[null,"Gucci",1820,1250,-570,570,null,null,null,null,0,0]

{"sheet":"Excel VBA","index":6,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Applying VBA Macro"]
[]
[null,"Brand","Yesterday's Sales","Today's Sales","Variance","Absolute Variance"]
[null,"Nike",1200,1150,{"$f":"D5-C5","v":-50},50]
[null,"Adidas",1550,1400,{"$f":"D6-C6","v":-150},150]
[null,"Fila",2300,2330,30,30]
[null,"Bata",1100,910,-190,190]
[null,"Gucci",1820,1250,-570,570]

{"sheet":"PIVOT Table","index":7,"n_rows":10,"n_cols":25,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,20,1,24]]}
[]
[null,"Application of Excel Pivot Table",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Brand","Yesterday's Sales","Today's Sales","Variance",null,"Row Labels","Sum of Variance","Sum of Absolute Variance",null,null,null,null,null,null,null,null,null,null,null,"Brand","Yesterday's Sales","Today's Sales","Variance","Absolute Variance"]
[null,"Nike",1200,1150,{"$f":"D5-C5","v":-50},null,"Adidas",-150,150,null,null,null,null,null,null,null,null,null,null,null,"Nike",1200,1150,{"$f":"W5-V5","v":-50}]
[null,"Adidas",1550,1400,{"$f":"D6-C6","v":-150},null,"Bata",-190,190,null,null,null,null,null,null,null,null,null,null,null,"Adidas",1550,1400,{"$f":"W6-V6","v":-150}]
[null,"Fila",2300,2330,30,null,"Fila",30,30,null,null,null,null,null,null,null,null,null,null,null,"Fila",2300,2330,30]
[null,"Bata",1100,910,-190,null,"Gucci",-570,570,null,null,null,null,null,null,null,null,null,null,null,"Bata",1100,910,-190]
[null,"Gucci",1820,1250,-570,null,"Nike",-50,50,null,null,null,null,null,null,null,null,null,null,null,"Gucci",1820,1250,-570]
[null,null,null,null,null,null,"Grand Total",-930,930]

{"sheet":"Power Query","index":8,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,7,1,10]]}
[]
[null,"Application of Power Query",null,null,null,null,null,"Practice Section"]
[]
[null,"Brand","Yesterday's Sales","Today's Sales","Variance",null,null,"Brand","Yesterday's Sales","Today's Sales","Variance"]
[null,"Nike",1200,1150,{"$f":"D5-C5","v":-50},null,null,"Nike",1200,1150,{"$f":"J5-I5","v":-50}]
[null,"Adidas",1550,1400,{"$f":"D6-C6","v":-150},null,null,"Adidas",1550,1400,{"$f":"J6-I6","v":-150}]
[null,"Fila",2300,2330,30,null,null,"Fila",2300,2330,30]
[null,"Bata",1100,910,-190,null,null,"Bata",1100,910,-190]
[null,"Gucci",1820,1250,-570,null,null,"Gucci",1820,1250,-570]

{"sheet":"Conditional Sum","index":9,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[[3,4,4,4],[3,5,4,5],[1,1,1,5],[1,7,1,11],[3,10,4,10],[3,11,4,11]]}
[]
[null,"Absolute Value of Conditional Sum",null,null,null,null,null,"Practice Section"]
[]
[null,"Series 1","Series 2",null,"Absolute Value of SUM",{"$f":"ABS(SUMIF(B5:B9,\"<0\")\n+SUMIF(C5:C9,\">0\"))","v":5},null,"Series 1","Series 2",null,"Absolute Value of SUM",{"$f":"ABS(SUMIF(H5:H9,\"<0\")+SUMIF(I5:I9,\">0\"))","v":0}]
[null,-20,10]
[null,-10,15]
[null,30,-30]
[null,-25,-50]
[null,3,25]

{"sheet":"Array SUM","index":10,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[10,1,10,3],[11,1,11,3],[1,8,1,11],[10,8,10,10],[11,8,11,10]]}
[]
[null,"Calculate Absolute SUM for Array Formula",null,null,null,null,null,null,"Practice Section"]
[]
[null,"Brand","Yesterday's Sales","Today's Sales","Variance",null,null,null,"Brand","Yesterday's Sales","Today's Sales","Variance"]
[null,"Nike",1200,1150,{"$f":"D5-C5","v":-50},null,null,null,null,null,null,{"$f":"K5-J5","v":0}]
[null,"Adidas",1550,1400,{"$f":"D6-C6","v":-150},null,null,null,null,null,null,{"$f":"K6-J6","v":0}]
[null,"Fila",2300,2330,30,null,null,null,null,null,null,0]
[null,"Bata",1100,910,-190,null,null,null,null,null,null,0]
[null,"Gucci",1820,1250,-570,null,null,null,null,null,null,0]
[]
[null,"Array Sum (SUM)",null,null,{"$f":"SUM(ABS(E5:E9))","v":990},null,null,null,"Array Sum (SUM)",null,null,{"$f":"SUM(ABS(L5:L9))","v":0}]
[null,"Array Sum (SUMPRODUCT)",null,null,{"$f":"SUMPRODUCT(ABS(E5:E9))","v":990},null,null,null,"Array Sum (SUMPRODUCT)",null,null,{"$f":"SUMPRODUCT(ABS(L5:L9))","v":0}]

{"sheet":"Maximum Minimum Absolute Value","index":11,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[10,1,10,3],[11,1,11,3],[1,7,1,10],[10,7,10,9],[11,7,11,9]]}
[]
[null,"Calculating Maximum/Minimum Absolute Value",null,null,null,null,null,"Practice Section"]
[]
[null,"Brand","Yesterday's Sales","Today's Sales","Variance",null,null,"Brand","Yesterday's Sales","Today's Sales","Variance"]
[null,"Nike",1200,1150,{"$f":"D5-C5","v":-50},null,null,null,null,null,{"$f":"J5-I5","v":0}]
[null,"Adidas",1550,1400,{"$f":"D6-C6","v":-150},null,null,null,null,null,{"$f":"J6-I6","v":0}]
[null,"Fila",2300,2330,30,null,null,null,null,null,0]
[null,"Bata",1100,910,-190,null,null,null,null,null,0]
[null,"Gucci",1820,1250,-570,null,null,null,null,null,0]
[]
[null,"Maximum Absolute Value",null,null,{"$f":"MAX(ABS(E5:E9))","v":570},null,null,"Maximum Absolute Value",null,null,{"$f":"MAX(ABS(K5:K9))","v":0}]
[null,"Minimum Absolute Value",null,null,{"$f":"MIN(ABS(E5:E9))","v":30},null,null,"Minimum Absolute Value",null,null,{"$f":"MIN(ABS(K5:K9))","v":0}]

{"sheet":"Average Absolute Value","index":12,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[10,1,10,3],[1,6,1,9],[10,6,10,8]]}
[]
[null,"Calculating Average Absolute Value",null,null,null,null,"Practice Section"]
[]
[null,"Brand","Yesterday's Sales","Today's Sales","Variance",null,"Brand","Yesterday's Sales","Today's Sales","Variance"]
[null,"Nike",1200,1150,{"$f":"D5-C5","v":-50},null,null,null,null,{"$f":"I5-H5","v":0}]
[null,"Adidas",1550,1400,{"$f":"D6-C6","v":-150},null,null,null,null,{"$f":"I6-H6","v":0}]
[null,"Fila",2300,2330,30,null,null,null,null,0]
[null,"Bata",1100,910,-190,null,null,null,null,0]
[null,"Gucci",1820,1250,-570,null,null,null,null,0]
[]
[null,"Average of Absolute Values",null,null,{"$f":"AVERAGE(ABS(E5:E9))","v":198},null,"Average of Absolute Values",null,null,{"$f":"AVERAGE(ABS(J5:J9))","v":0}]

{"sheet":"Tolerance of Variance","index":13,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,7,1,11]]}
[]
[null,"Calculating Tolerance of Variance",null,null,null,null,null,"Practice Section"]
[]
[null,"Brand","Yesterday's Sales","Today's Sales","Variance","Tolerance",null,"Brand","Yesterday's Sales","Today's Sales","Variance","Tolerance"]
[null,"Nike",1200,1150,{"$f":"D5-C5","v":-50},{"$f":"(--(ABS(E5)<120))","v":1},null,null,null,null,{"$f":"J5-I5","v":0},{"$f":"IF(SUMPRODUCT(--(ABS(K5)>120)),1,0)","v":0}]
[null,"Adidas",1550,1400,{"$f":"D6-C6","v":-150},{"$f":"(--(ABS(E6)<120))","v":0},null,null,null,null,{"$f":"J6-I6","v":0},{"$f":"IF(SUMPRODUCT(--(ABS(K6)>120)),1,0)","v":0}]
[null,"Fila",2300,2330,30,1,null,null,null,null,0,0]
[null,"Bata",1100,910,-190,0,null,null,null,null,0,0]
[null,"Gucci",1820,1250,-570,0,null,null,null,null,0,0]