{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Score","(1)","(2)"],"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"]
["Create Table for Future Value Calculations",3,{"$f":"B2","v":3},{"$f":"IF(B2<>C2,K2,\"\")","v":""}]
["Use Mixed and Absolute Cell References like: =FV(B$11,$A12,-$B$5)",3,3,{"$f":"IF(B3<>C3,K3,\"\")","v":""}]
["Have Deposit as Negative Cash Flow",3,3,""]
["In PQ:Filter out the extra Field Names by using the Products Field to filter out the word “Product”.",3,3,""]
["In PQ:Highlight Web Site, Product and Quantity Fields and then right-click and click “Remove Other Columns” (the only Fields to import are Web Site, Product and Quantity).",3,3,""]
["In PQ:  Be sure to check the Data Types in each Field.",3,3,""]
["In PQ: Use the Close and Load To option and then select “Only Create Connection” and “Add this data to the Data Model”.",3,3,""]
["Create Cross Tab PivotTAble",3,3,""]
["Add Format: Report Layout Tabular",3,3,""]
["Add Number Format",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":"(1)","index":1,"n_rows":3,"n_cols":10,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Use your picture to the right as your guide to build a Future Value schedule for an annual Bank CD deposit of $2500 made at the end of each year  for various Annual Rates and Number of Total Years."]
[]
[null,null,null,null,null,null,null,null,null,"Picture ==>>"]

{"sheet":"(2)","index":2,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["1) Download the zipped folder \"TextFiles\"."]
["2) Unzip \"TextFiles\" folder."]
["3) Use Power Query (Get & Transform group in Data Ribbon Tab) to import all the text files in the \"TextFiles\" folder into the Power Pivot Data Model as a single Table."]
["4) Create the PivotTable Report as seen in the picture to the right ==>>"]