{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["SUM","SUMPRODUCT","AutoSum","VBA","LSI 1","LSI 2"],"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":"SUM","index":0,"n_rows":10,"n_cols":15,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,10,1,14],[1,1,1,5]]}
[]
[null,"Using SUM Function",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Client","Task","Hours","Hourly Rate","Total",null,null,null,null,"Client","Task","Hours","Hourly Rate","Total"]
[null,"Daniel","Design",4.26,45,{"$f":"D5*E5","v":191.7},null,null,null,null,"Daniel","Design",4.26,45]
[null,"George","Development",2.4500000000000002,50,{"$f":"D6*E6","v":122.50000000000001},null,null,null,null,"George","Development",2.4500000000000002,50]
[null,"Paul","Meeting",5,72,360,null,null,null,null,"Paul","Meeting",5,72]
[null,"Williams","Administrative",1.75,38,66.5,null,null,null,null,"Williams","Administrative",1.75,38]
[null,"Davis","Research",2,28,56,null,null,null,null,"Davis","Research",2,28]
[null,null,"Total Hours=",{"$f":"SUM(D5:D9)","v":15.46},"Total Bill =",{"$f":"SUM(F5:F9)","v":796.7},null,null,null,null,null,"Total Hours=",null,"Total Bill ="]

{"sheet":"SUMPRODUCT","index":1,"n_rows":10,"n_cols":15,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,10,1,14]]}
[]
[null,"Using SUMPRODUCT Function",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Client","Task","Hours","Hourly Rate","Total",null,null,null,null,"Client","Task","Hours","Hourly Rate","Total"]
[null,"Daniel","Design",4.26,45,null,null,null,null,null,"Daniel","Design",4.26,45]
[null,"George","Development",2.4500000000000002,50,null,null,null,null,null,"George","Development",2.4500000000000002,50]
[null,"Paul","Meeting",5,72,null,null,null,null,null,"Paul","Meeting",5,72]
[null,"Williams","Administrative",1.75,38,null,null,null,null,null,"Williams","Administrative",1.75,38]
[null,"Davis","Research",2,28,null,null,null,null,null,"Davis","Research",2,28]
[null,null,"Total Hours=",{"$f":"SUM(D5:D9)","v":15.46},"Total Bill =",{"$f":"SUMPRODUCT(D5:D9,E5:E9)","v":796.7},null,null,null,null,null,"Total Hours=",null,"Total Bill ="]

{"sheet":"AutoSum","index":2,"n_rows":10,"n_cols":15,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,10,1,14]]}
[]
[null,"Using AutoSum Feature",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Client","Task","Hours","Hourly Rate","Total",null,null,null,null,"Client","Task","Hours","Hourly Rate","Total"]
[null,"Daniel","Design",4.26,45,{"$f":"PRODUCT(D5,E5)","v":191.7},null,null,null,null,"Daniel","Design",4.26,45]
[null,"George","Development",2.4500000000000002,50,{"$f":"PRODUCT(D6,E6)","v":122.50000000000001},null,null,null,null,"George","Development",2.4500000000000002,50]
[null,"Paul","Meeting",5,72,360,null,null,null,null,"Paul","Meeting",5,72]
[null,"Williams","Administrative",1.75,38,66.5,null,null,null,null,"Williams","Administrative",1.75,38]
[null,"Davis","Research",2,28,56,null,null,null,null,"Davis","Research",2,28]
[null,null,"Total Hours=",{"$f":"SUM(D5:D9)","v":15.46},"Total Bill =",{"$f":"SUM(F5:F9)","v":796.7},null,null,null,null,null,"Total Hours=",null,"Total Bill ="]

{"sheet":"VBA","index":3,"n_rows":10,"n_cols":15,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,10,1,14]]}
[]
[null,"Using VBA Code",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Client","Task","Hours","Hourly Rate","Total",null,null,null,null,"Client","Task","Hours","Hourly Rate","Total"]
[null,"Daniel","Design",4.26,45,null,null,null,null,null,"Daniel","Design",4.26,45]
[null,"George","Development",2.4500000000000002,50,null,null,null,null,null,"George","Development",2.4500000000000002,50]
[null,"Paul","Meeting",5,72,null,null,null,null,null,"Paul","Meeting",5,72]
[null,"Williams","Administrative",1.75,38,null,null,null,null,null,"Williams","Administrative",1.75,38]
[null,"Davis","Research",2,28,null,null,null,null,null,"Davis","Research",2,28]
[null,null,"Total Hours=",15.46,"Total Bill =",796.7,null,null,null,null,null,"Total Hours=",null,"Total Bill ="]

{"sheet":"LSI 1","index":4,"n_rows":10,"n_cols":15,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Calculating Man Hours in Excel",null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Employee","Time In","Time Out","Man Hours",null,null,null,null,null,null,"Employee","Time In","Time Out","Man Hours"]
[null,"Daniel","09:00:00","17:00:00",{"$f":"(D5-C5)*24","v":8},null,null,null,null,null,null,"Daniel","09:00:00","17:00:00"]
[null,"George","09:30:00","18:00:00",{"$f":"(D6-C6)*24","v":8.5},null,null,null,null,null,null,"George","09:30:00","18:00:00"]
[null,"Paul","09:45:00","17:00:00",7.2500000000000009,null,null,null,null,null,null,"Paul","09:45:00","17:00:00"]
[null,"Williams","10:00:00","19:30:00",9.5,null,null,null,null,null,null,"Williams","10:00:00","19:30:00"]
[null,"Davis","11:00:00","17:30:00",6.5,null,null,null,null,null,null,"Davis","11:00:00","17:30:00"]
[null,"Jones","10:30:00","17:15:00",6.75,null,null,null,null,null,null,"Jones","10:30:00","17:15:00"]

{"sheet":"LSI 2","index":5,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[9,1,9,3],[1,10,1,13],[9,10,9,12]]}
[]
[null,"Making Overtime Calculator in Excel",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Employee","Time In","Time Out","Overtime",null,null,null,null,null,"Employee","Time In","Time Out","Overtime"]
[null,"Daniel","09:00:00","17:00:00",{"$f":"IF((D5-C5)*24>$E$10,((D5-C5)*24)-$E$10,0)","v":0},null,null,null,null,null,"Daniel","09:00:00","17:00:00"]
[null,"George","09:30:00","18:00:00",{"$f":"IF((D6-C6)*24>$E$10,((D6-C6)*24)-$E$10,0)","v":0.5},null,null,null,null,null,"George","09:30:00","18:00:00"]
[null,"Paul","09:45:00","17:00:00",0,null,null,null,null,null,"Paul","09:45:00","17:00:00"]
[null,"Williams","10:00:00","19:30:00",1.5,null,null,null,null,null,"Williams","10:00:00","19:30:00"]
[null,"Davis","11:00:00","17:30:00",0,null,null,null,null,null,"Davis","11:00:00","17:30:00"]
[null,"Standard Time",null,null,8,null,null,null,null,null,"Standard Time",null,null,8]