{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Score","P(1)","Dashboard"],"not_rendered":{"charts":0,"images":2,"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":"Score","index":0,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["Graded Element","Possible Points","Your Points","Comments"]
["Line Chart Pivot",3,{"$f":"B2","v":3},{"$f":"IF(B2<>C2,K2,\"\")","v":""}]
["Line Chart with no chart junk",3,3,{"$f":"IF(B3<>C3,K3,\"\")","v":""}]
["Cross Tab Pivot",3,3,""]
["Conditional Formatting Top 5",3,3,""]
["Sales Rep Pivot",3,3,""]
["Sales Rep Bar Chart",3,3,""]
["Dashboard Neat",3,3,""]
["Other",3,3,""]
["Other",3,3,""]
["Other",3,3,""]
[null,null,{"$f":"IF(C13=\"Late\",-0.25*SUM(C1:C11),\"\")","v":""},{"$f":"IF($C$13=\"Late\",\"Late\",\"\")","v":""}]
["Total Possible:",{"$f":"SUM(B2:B11)","v":30},null,{"$f":"IF($C$13=\"Late\",\"In accordance with the syllabus, late points are subtracted from score (25%).\",\"\")","v":""}]
[null,null,{"$f":"SUM(C2:C12)","v":30}]

{"sheet":"P(1)","index":1,"n_rows":54,"n_cols":40,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["You do not need to use Power Pivot or the Data Model for this project."]
["Below in the table named \"TransactionTable\"."]
["Your job is to make the dashboard that is pictured to right and below on the sheet that is named \"Dashboard\"."]
["Create the necessary PivotTables, Charts and Conditional Formatting on new sheets"]
["and then place the final visualizations on the sheet named \"Dashboard\"."]
["When you have completed the Dashboard, add the new records listed to the right to the bottom of"]
["the \"TransactionTable\". Then refresh your dashboard.",null,null,null,null,null,null,null,null,"New Records that you should add to the table names \"Transaction Table\":"]
[]
["Date","Sales Rep","Region","Product","Sales",null,null,null,null,"Date","Sales Rep","Region","Product","Sales",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sales Rep",null,"Region",null,"Product"]
["2016-05-12","Sioux","South","Majestic Beaut",1090,null,null,null,null,"2016-05-15","Dwan","South","Aspen",2241,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sioux",null,"West",null,"Quad"]
["2016-05-12","Timmy","West","Majestic Beaut",1600,null,null,null,null,"2016-05-15","Chin","East","Sunshine",3506,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Timmy",null,"East",null,"Carlota"]
["2016-05-12","Dwan","South","Yanaki",1825,null,null,null,null,"2016-05-15","Chin","West","Quad",1661,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dwan",null,"South",null,"Sunshine"]
["2016-05-12","Timmy","West","Aspen",2151,null,null,null,null,"2016-05-15","Sioux","East","Aspen",493,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chin",null,"Northwest",null,"Majestic Beaut"]
["2016-05-13","Dwan","West","Quad",903,null,null,null,null,"2016-05-15","Dwan","Northwest","Carlota",3865,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"West",null,"Yanaki"]
["2016-05-13","Sioux","Northwest","Quad",1158,null,null,null,null,"2016-05-16","Chin","South","Aspen",2756,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aspen"]
["2016-05-13","Chin","Northwest","Flattop",692,null,null,null,null,"2016-05-16","Dwan","West","Majestic Beaut",4089,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flattop"]
["2016-05-13","Dwan","South","Majestic Beaut",3323,null,null,null,null,"2016-05-16","Dwan","East","Aspen",2620,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MTA"]
["2016-05-13","Sioux","East","Sunshine",1659,null,null,null,null,"2016-05-16","Sioux","West","Aspen",2565]
["2016-05-14","Timmy","South","MTA",1870]
["2016-05-14","Timmy","South","Carlota",2357]
[]
[]
[null,null,null,null,null,null,null,null,null,"What Dashboard should look like Before New Data:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"What Dashboard should look like After New Data:"]

{"sheet":"Dashboard","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}