{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Score","Project(1)","Project(1an)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":3,"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":"Score","index":0,"n_rows":11,"n_cols":19,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["Graded Element","Possible Points","Your Points","Comments"]
["Fix Text Time Data in cells C14, C33 and D51.",5,{"$f":"B2","v":5},{"$f":"IF(B2<>C2,S2,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fix Text Time Data in cells C14, C33 and D51. You needed to add a space between the time value and the AM/PM."]
["Use a lookup formula to get wage for each employee. Something like: =VLOOKUP(B7,$K$7:$L$13,2,0). You can NOT use copy and paste or use other manual methods like sorting.",7,7,{"$f":"IF(B3<>C3,S3,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"You did not use  a lookup formula to get wage for each employee. Something like: =VLOOKUP(B7,$K$7:$L$13,2,0) would work."]
["Calculate Hours Worked with a formula like: =(D7-C7)*24",5,5,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"You needed to use a formula like: =(D7-C7)*24 to get the time value (Proportion of 24 hour day) to become Number of Hours Worked."]
["Number Formatting, like Currency.",1,1,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"You did not have Number Formatting, like Currency."]
["Include your name in the file name, something like \"Your Name Busn218Project01.xlsm\". This is good file management, as we learned in Busn 216.",2,2,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"You did not include your name in the file name, something like \"Your Name Busn218Project01.xlsm\" For future submissions, you must include your name in the file name. This is good file management, as we learned in Busn 216."]
["Because it says \"calculate the Total Gross Pay for all employees\", you must use ROUND. The Number of Hours Worked have extraneous decimals that need to be rounded so that when we add all of the individual gross pay amounts the SUM function does not add the extraneous decimals and can therefore get the correct answer. Something like: =ROUND(F7*E7,2). The correct answer with rounding is: $9,587.42. If you don't round you get:  $9,587.38.",5,5,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Because it says \"calculate the Total Gross Pay for all employees\", you must use ROUND. The Number of Hours Worked have extraneous decimals that need to be rounded so that when we add all of the individual gross pay amounts the SUM function does not add the extraneous decimals and can therefore get the correct answer. Something like: =ROUND(F7*E7,2). The correct answer with rounding is: $9,587.42. If you don't round you get:  9587.38."]
["Create Summary Employee Table. PivotTable or SUMIFS.",5,{"$f":"B8","v":5},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other"]
[null,null,{"$f":"IF(C10=\"Late\",-0.25*SUM(C1:C8),\"\")","v":""},{"$f":"IF($C$10=\"Late\",\"Late\",\"\")","v":""}]
["Total Possible:",{"$f":"SUM(B2:B8)","v":30},null,{"$f":"IF($C$10=\"Late\",\"In accordance with the syllabus, late points are subtracted from score (25%).\",\"\")","v":""}]
[null,null,{"$f":"SUM(C2:C9)","v":30}]

{"sheet":"Project(1)","index":1,"n_rows":57,"n_cols":12,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
["Below are the two data sets: 1) Data set with times that employees have worked per day (Left Table) and 2) Table with Employee Wages (Right Table, Lookup Table)."]
["Your goals are:"]
["1) Add a new column/s to the Data set with times that employees have worked per day and calculate the Gross Pay for each row in the data set, and then at the bottom calculate the Total Gross Pay for all employees."]
["2) Then, off to the side, create a report that shows the Total Gross Pay for each employee (either with SUMIFS function or a PivotTbale)."]
["You must create an effective and efficient solution."]
["Your check figure for Total Gross Pay at the bottom of the column is: $9,587.42"]
[]
["Date Worked","Employee","Time In","Time Out",null,null,null,null,null,null,"Employee","Hourly Wage"]
["2016-04-11","Taneka Guess","08:00:00","14:30:00",null,null,null,null,null,null,"Taneka Guess",26.95]
["2016-04-11","Heriberto Cheek","08:00:00","14:48:00",null,null,null,null,null,null,"Heriberto Cheek",32.5]
["2016-04-11","Irina Valles","08:00:00","16:00:00",null,null,null,null,null,null,"Irina Valles",36.5]
["2016-04-11","Dick Condon","08:00:00","14:36:00",null,null,null,null,null,null,"Dick Condon",19.5]
["2016-04-11","Georgetta Mayes","09:00:00","17:00:00",null,null,null,null,null,null,"Georgetta Mayes",30]
["2016-04-11","Precious Pettis","09:00:00","15:24:00",null,null,null,null,null,null,"Precious Pettis",27.75]
["2016-04-11","Louetta Peoples","09:00:00","15:12:00",null,null,null,null,null,null,"Louetta Peoples",24]
["2016-04-12","Taneka Guess","7:30AM","14:54:00"]
["2016-04-12","Heriberto Cheek","08:00:00","16:00:00"]
["2016-04-12","Irina Valles","09:00:00","15:42:00"]
["2016-04-12","Dick Condon","08:00:00","14:42:00"]
["2016-04-12","Georgetta Mayes","08:00:00","15:24:00"]
["2016-04-12","Precious Pettis","09:00:00","17:00:00"]
["2016-04-12","Louetta Peoples","07:30:00","15:18:00"]
["2016-04-13","Taneka Guess","08:00:00","15:48:00"]
["2016-04-13","Heriberto Cheek","09:00:00","15:42:00"]
["2016-04-13","Irina Valles","09:00:00","16:00:00"]
["2016-04-13","Dick Condon","09:00:00","16:06:00"]
["2016-04-13","Georgetta Mayes","09:00:00","15:18:00"]
["2016-04-13","Precious Pettis","09:00:00","15:30:00"]
["2016-04-13","Louetta Peoples","08:00:00","15:12:00"]
["2016-04-14","Taneka Guess","07:30:00","13:36:00"]
["2016-04-14","Heriberto Cheek","09:00:00","15:54:00"]
["2016-04-14","Irina Valles","08:00:00","14:42:00"]
["2016-04-14","Dick Condon","09:00:00","16:54:00"]
["2016-04-14","Georgetta Mayes","09:00:00","16:18:00"]
["2016-04-14","Precious Pettis","9:00AM","15:06:00"]
["2016-04-14","Louetta Peoples","07:30:00","14:06:00"]
["2016-04-15","Taneka Guess","07:30:00","13:48:00"]
["2016-04-15","Heriberto Cheek","07:30:00","13:36:00"]
["2016-04-15","Irina Valles","09:00:00","16:36:00"]
["2016-04-15","Dick Condon","09:00:00","15:12:00"]
["2016-04-15","Georgetta Mayes","09:00:00","15:06:00"]
["2016-04-15","Precious Pettis","09:00:00","16:54:00"]
["2016-04-15","Louetta Peoples","08:00:00","15:42:00"]
["2016-04-18","Taneka Guess","09:00:00","16:48:00"]
["2016-04-18","Heriberto Cheek","09:00:00","15:48:00"]
["2016-04-18","Irina Valles","09:00:00","15:54:00"]
["2016-04-18","Dick Condon","07:30:00","14:00:00"]
["2016-04-18","Georgetta Mayes","07:30:00","14:12:00"]
["2016-04-18","Precious Pettis","08:00:00","14:00:00"]
["2016-04-18","Louetta Peoples","09:00:00","15:00:00"]
["2016-04-19","Taneka Guess","09:00:00","16:30:00"]
["2016-04-19","Heriberto Cheek","08:00:00","15:36:00"]
["2016-04-19","Irina Valles","08:00:00","3:18PM"]
["2016-04-19","Dick Condon","09:00:00","15:24:00"]
["2016-04-19","Georgetta Mayes","08:00:00","14:24:00"]
["2016-04-19","Precious Pettis","08:00:00","14:18:00"]
["2016-04-19","Louetta Peoples","09:00:00","15:36:00"]

{"sheet":"Project(1an)","index":2,"n_rows":59,"n_cols":12,"rows_kept":59,"cut":false,"hidden":true,"merged":[]}
["Below are the two data sets: 1) Data set with times that employees have worked per day (Left Table) and 2) Table with Employee Wages (Right Table, Lookup Table)."]
["Your goals are:"]
["1) Add a new column/s to the Data set with times that employees have worked per day and calculate the Gross Pay for each row in the data set, and then at the bottom calculate the Total Gross Pay for all employees."]
["2) Then, off to the side, create a report that shows the Total Gross Pay for each employee (either with SUMIFS function or a PivotTbale)."]
["You must create an effective and efficient solution."]
["Your check figure for Total Gross Pay at the bottom of the column is: $9,587.42"]
[]
["Date Worked","Employee","Time In","Time Out","Wage","Hours Worked","Gross Pay",null,"Not Rounded:",null,"Employee","Hourly Wage"]
["2016-04-11","Taneka Guess","08:00:00","14:30:00",{"$f":"VLOOKUP(B9,$K$9:$L$15,2,0)","v":26.95},{"$f":"(D9-C9)*24","v":6.5},{"$f":"ROUND(F9*E9,2)","v":175.18},null,{"$f":"F9*E9","v":175.17499999999998},null,"Taneka Guess",26.95]
["2016-04-11","Heriberto Cheek","08:00:00","14:48:00",{"$f":"VLOOKUP(B10,$K$9:$L$15,2,0)","v":32.5},{"$f":"(D10-C10)*24","v":6.8000000000000007},{"$f":"ROUND(F10*E10,2)","v":221},null,221.00000000000003,null,"Heriberto Cheek",32.5]
["2016-04-11","Irina Valles","08:00:00","16:00:00",36.5,8,292,null,292,null,"Irina Valles",36.5]
["2016-04-11","Dick Condon","08:00:00","14:36:00",19.5,6.6000000000000014,128.69999999999999,null,128.70000000000002,null,"Dick Condon",19.5]
["2016-04-11","Georgetta Mayes","09:00:00","17:00:00",30,7.9999999999999982,240,null,239.99999999999994,null,"Georgetta Mayes",30]
["2016-04-11","Precious Pettis","09:00:00","15:24:00",27.75,6.3999999999999986,177.6,null,177.59999999999997,null,"Precious Pettis",27.75]
["2016-04-11","Louetta Peoples","09:00:00","15:12:00",24,6.1999999999999993,148.80000000000001,null,148.79999999999998,null,"Louetta Peoples",24]
["2016-04-12","Taneka Guess","07:30:00","14:54:00",26.95,7.4,199.43,null,199.43]
["2016-04-12","Heriberto Cheek","08:00:00","16:00:00",32.5,8,260,null,260,null,"Employee","Gross"]
["2016-04-12","Irina Valles","09:00:00","15:42:00",36.5,6.7,244.55,null,244.55,null,"Taneka Guess",{"$f":"SUMIFS($G$9:$G$57,$B$9:$B$57,K18)","v":1331.35}]
["2016-04-12","Dick Condon","08:00:00","14:42:00",19.5,6.7000000000000011,130.65,null,130.65000000000003,null,"Heriberto Cheek",{"$f":"SUMIFS($G$9:$G$57,$B$9:$B$57,K19)","v":1589.25}]
["2016-04-12","Georgetta Mayes","08:00:00","15:24:00",30,7.3999999999999986,222,null,221.99999999999994,null,"Irina Valles",1832.3]
["2016-04-12","Precious Pettis","09:00:00","17:00:00",27.75,7.9999999999999982,222,null,221.99999999999994,null,"Dick Condon",924.3]
["2016-04-12","Louetta Peoples","07:30:00","15:18:00",24,7.7999999999999989,187.2,null,187.2,null,"Georgetta Mayes",1446]
["2016-04-13","Taneka Guess","08:00:00","15:48:00",26.95,7.8000000000000007,210.21,null,210.21,null,"Precious Pettis",1309.82]
["2016-04-13","Heriberto Cheek","09:00:00","15:42:00",32.5,6.7,217.75,null,217.75,null,"Louetta Peoples",1154.4000000000001]
["2016-04-13","Irina Valles","09:00:00","16:00:00",36.5,7.0000000000000018,255.5,null,255.50000000000006,null,"Total",{"$f":"SUM(L18:L24)","v":9587.42}]
["2016-04-13","Dick Condon","09:00:00","16:06:00",19.5,7.1000000000000014,138.44999999999999,null,138.45000000000002]
["2016-04-13","Georgetta Mayes","09:00:00","15:18:00",30,6.2999999999999989,189,null,188.99999999999997]
["2016-04-13","Precious Pettis","09:00:00","15:30:00",27.75,6.4999999999999982,180.38,null,180.37499999999994,null,"Employee","Sum of Gross Pay"]
["2016-04-13","Louetta Peoples","08:00:00","15:12:00",24,7.1999999999999993,172.8,null,172.79999999999998,null,"Dick Condon",924.3]
["2016-04-14","Taneka Guess","07:30:00","13:36:00",26.95,6.1,164.4,null,164.39499999999998,null,"Georgetta Mayes",1446]
["2016-04-14","Heriberto Cheek","09:00:00","15:54:00",32.5,6.8999999999999995,224.25,null,224.24999999999997,null,"Heriberto Cheek",1589.25]
["2016-04-14","Irina Valles","08:00:00","14:42:00",36.5,6.7000000000000011,244.55,null,244.55000000000004,null,"Irina Valles",1832.3]
["2016-04-14","Dick Condon","09:00:00","16:54:00",19.5,7.8999999999999986,154.05000000000001,null,154.04999999999998,null,"Louetta Peoples",1154.4000000000001]
["2016-04-14","Georgetta Mayes","09:00:00","16:18:00",30,7.3000000000000007,219,null,219.00000000000003,null,"Precious Pettis",1309.82]
["2016-04-14","Precious Pettis","09:00:00","15:06:00",27.75,6.1,169.28,null,169.27499999999998,null,"Taneka Guess",1331.35]
["2016-04-14","Louetta Peoples","07:30:00","14:06:00",24,6.6000000000000005,158.4,null,158.4,null,"Grand Total",9587.42]
["2016-04-15","Taneka Guess","07:30:00","13:48:00",26.95,6.2999999999999989,169.79,null,169.78499999999997]
["2016-04-15","Heriberto Cheek","07:30:00","13:36:00",32.5,6.1,198.25,null,198.25]
["2016-04-15","Irina Valles","09:00:00","16:36:00",36.5,7.6,277.39999999999998,null,277.39999999999998]
["2016-04-15","Dick Condon","09:00:00","15:12:00",19.5,6.1999999999999993,120.9,null,120.89999999999999]
["2016-04-15","Georgetta Mayes","09:00:00","15:06:00",30,6.1,183,null,{"$f":"F41*E41","v":183}]
["2016-04-15","Precious Pettis","09:00:00","16:54:00",27.75,7.8999999999999986,219.23,null,219.22499999999997]
["2016-04-15","Louetta Peoples","08:00:00","15:42:00",24,7.7000000000000011,184.8,null,184.8]
["2016-04-18","Taneka Guess","09:00:00","16:48:00",26.95,7.7999999999999989,210.21,null,210.20999999999998]
["2016-04-18","Heriberto Cheek","09:00:00","15:48:00",32.5,6.8,221,null,221]
["2016-04-18","Irina Valles","09:00:00","15:54:00",36.5,6.8999999999999995,251.85,null,251.85]
["2016-04-18","Dick Condon","07:30:00","14:00:00",19.5,6.4999999999999982,126.75,null,126.74999999999997]
["2016-04-18","Georgetta Mayes","07:30:00","14:12:00",30,6.7,201,null,201]
["2016-04-18","Precious Pettis","08:00:00","14:00:00",27.75,5.9999999999999982,166.5,null,166.49999999999994]
["2016-04-18","Louetta Peoples","09:00:00","15:00:00",24,6,144,null,144]
["2016-04-19","Taneka Guess","09:00:00","16:30:00",26.95,7.5,202.13,null,202.125]
["2016-04-19","Heriberto Cheek","08:00:00","15:36:00",32.5,7.5999999999999979,247,null,246.99999999999994]
["2016-04-19","Irina Valles","08:00:00","15:18:00",36.5,7.3000000000000025,266.45,null,266.4500000000001]
["2016-04-19","Dick Condon","09:00:00","15:24:00",19.5,6.3999999999999986,124.8,null,124.79999999999997]
["2016-04-19","Georgetta Mayes","08:00:00","14:24:00",30,6.4,192,null,192]
["2016-04-19","Precious Pettis","08:00:00","14:18:00",27.75,6.3000000000000007,174.83,null,174.82500000000002]
["2016-04-19","Louetta Peoples","09:00:00","15:36:00",24,6.6000000000000005,158.4,null,158.4]
[]
[null,null,null,null,null,"Total:",{"$f":"SUM(G9:G57)","v":9587.4199999999964},null,{"$f":"SUM(I9:I57)","v":9587.3799999999992},"<<== Incorrect Total"]