{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Pacing Guide","Advanced Guide","Weekly Guide","Sheet2","Changing times. ","TypicalWeeks"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"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":"Pacing Guide","index":0,"n_rows":86,"n_cols":13,"rows_kept":86,"cut":false,"hidden":false,"merged":[[27,0,30,1],[31,0,32,1],[4,5,4,6],[6,0,16,0],[4,0,4,1],[19,0,21,1],[22,0,22,1],[0,0,2,1]]}
["K-12 Pacing Guide"]
[]
[]
[]
["Step 1: Choose Chapters                                           Use CTRL to select or deslect more than one chapter/section at a time.  ",null,null,null,null,"Step 3: Projects, Practice, & Certification                                                                                   Input or change the minutes for each activity.                     BY DEFAULT, THE MINUTES LISTED ARE A RECOMMENDATION. \n                  ",null,null,"Week to Cover ","Pacing Guide:                            Office Pro Sections and Activities   ","Minutes per Section","Running Total"]
[null,null,null,null,null,null,null,null,1,"3.1: Getting Started with Office",62,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J6)),\"\",\nIF(ISBLANK($K6), \"\", SUM($K$6:K6)\n))\n)","v":62},135]
[null,null,null,null,null,"Word","Minutes",null,{"$f":"IFERROR(IF(K6=0,\"\",ROUNDDOWN(L6/Sheet2!$B$7,0)+1),\"\")","v":1},"3.2: Customizing Views and Options",42,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J7)),\"\",\nIF(ISBLANK($K7), \"\", SUM($K$6:K7)\n))\n)","v":104}]
[null,null,null,null,null,"4.14:  Office Pro Projects (Uses Live Application)",120,null,{"$f":"IFERROR(IF(K7=0,\"\",ROUNDDOWN(L7/Sheet2!$B$7,0)+1),\"\")","v":1},"3.3: Printing Files",40,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J8)),\"\",\nIF(ISBLANK($K8), \"\", SUM($K$6:K8)\n))\n)","v":144}]
[null,null,null,null,null,"4.15:  My Projects/Assignments (Not Part of Office Pro)",0,null,{"$f":"IFERROR(IF(K8=0,\"\",ROUNDDOWN(L8/Sheet2!$B$7,0)+1),\"\")","v":1},"3.4: Navigating Files",44,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J9)),\"\",\nIF(ISBLANK($K9), \"\", SUM($K$6:K9)\n))\n)","v":188},0]
[null,null,null,null,null,"4.16:  MOS Practice: Domain Questions",120,null,{"$f":"IFERROR(IF(K9=0,\"\",ROUNDDOWN(L9/Sheet2!$B$7,0)+1),\"\")","v":1},"3.5: Working with Objects",44,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J10)),\"\",\nIF(ISBLANK($K10), \"\", SUM($K$6:K10)\n))\n)","v":232},135]
[null,null,null,null,null,"4.17:  MOS Practice: Certification (A and B)  ",300,null,{"$f":"IFERROR(IF(K10=0,\"\",ROUNDDOWN(L10/Sheet2!$B$7,0)+1),\"\")","v":1},"4.01: Introduction to Word",8,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J11)),\"\",\nIF(ISBLANK($K11), \"\", SUM($K$6:K11)\n))\n)","v":240},0]
[null,null,null,null,null,"4.18:  MOS Certification ",50,null,{"$f":"IFERROR(IF(K11=0,\"\",ROUNDDOWN(L11/Sheet2!$B$7,0)+1),\"\")","v":1},"4.02: Creating Documents and Using the Clipboard",104,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J12)),\"\",\nIF(ISBLANK($K12), \"\", SUM($K$6:K12)\n))\n)","v":344},60]
[null,null,null,null,null,"4.19:  Office Pro Exam for Word",60,null,{"$f":"IFERROR(IF(K12=0,\"\",ROUNDDOWN(L12/Sheet2!$B$7,0)+1),\"\")","v":2},"4.03: Modifying Fonts",93,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J13)),\"\",\nIF(ISBLANK($K13), \"\", SUM($K$6:K13)\n))\n)","v":437}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K13=0,\"\",ROUNDDOWN(L13/Sheet2!$B$7,0)+1),\"\")","v":2},"4.04: Formatting Paragraphs",101,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J14)),\"\",\nIF(ISBLANK($K14), \"\", SUM($K$6:K14)\n))\n)","v":538}]
[null,null,null,null,null,"Excel ","Minutes",null,{"$f":"IFERROR(IF(K14=0,\"\",ROUNDDOWN(L14/Sheet2!$B$7,0)+1),\"\")","v":2},"4.05: Formatting Pages",94,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J15)),\"\",\nIF(ISBLANK($K15), \"\", SUM($K$6:K15)\n))\n)","v":632}]
[null,null,null,null,null,"5.11:  Office Pro Projects (Uses Live Application)",120,null,{"$f":"IFERROR(IF(K15=0,\"\",ROUNDDOWN(L15/Sheet2!$B$7,0)+1),\"\")","v":2},"4.06: Editing Documents",95,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J16)),\"\",\nIF(ISBLANK($K16), \"\", SUM($K$6:K16)\n))\n)","v":727}]
[null,null,null,null,null,"5.12:  My Projects/Assignments (Not Part of Office Pro)",0,null,{"$f":"IFERROR(IF(K16=0,\"\",ROUNDDOWN(L16/Sheet2!$B$7,0)+1),\"\")","v":3},"4.07: Inserting Illustrations and Other Elements",96,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J17)),\"\",\nIF(ISBLANK($K17), \"\", SUM($K$6:K17)\n))\n)","v":823}]
[null,null,null,null,null,"5.13:  MOS Practice: Domain Questions",120,null,{"$f":"IFERROR(IF(K17=0,\"\",ROUNDDOWN(L17/Sheet2!$B$7,0)+1),\"\")","v":3},"4.08: Creating and Formatting Tables",97,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J18)),\"\",\nIF(ISBLANK($K18), \"\", SUM($K$6:K18)\n))\n)","v":920}]
[null,null,null,null,null,"5.14:  MOS Practice: Certification (A and B)  ",300,null,{"$f":"IFERROR(IF(K18=0,\"\",ROUNDDOWN(L18/Sheet2!$B$7,0)+1),\"\")","v":3},"4.09: Using Themes, Styles, and Templates",96,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J19)),\"\",\nIF(ISBLANK($K19), \"\", SUM($K$6:K19)\n))\n)","v":1016}]
["Step 2: Weeks\nInput number of weeks using Office Pro.                                                                           ",null,null,null,null,"5.15:  MOS Certification ",50,null,{"$f":"IFERROR(IF(K19=0,\"\",ROUNDDOWN(L19/Sheet2!$B$7,0)+1),\"\")","v":4},"4.10: Managing References",100,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J20)),\"\",\nIF(ISBLANK($K20), \"\", SUM($K$6:K20)\n))\n)","v":1116}]
[null,null,null,null,null,"5.16:  Office Pro Exam for Excel",60,null,{"$f":"IFERROR(IF(K20=0,\"\",ROUNDDOWN(L20/Sheet2!$B$7,0)+1),\"\")","v":4},"4.11: Managing Headers, Footers, and Sections",102,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J21)),\"\",\nIF(ISBLANK($K21), \"\", SUM($K$6:K21)\n))\n)","v":1218}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K21=0,\"\",ROUNDDOWN(L21/Sheet2!$B$7,0)+1),\"\")","v":4},"4.12: Using Office Collaboration Features",98,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J22)),\"\",\nIF(ISBLANK($K22), \"\", SUM($K$6:K22)\n))\n)","v":1316}]
[18,null,null,null,null,"PowerPoint","Minutes",null,{"$f":"IFERROR(IF(K22=0,\"\",ROUNDDOWN(L22/Sheet2!$B$7,0)+1),\"\")","v":5},"4.13: Using Macros",11,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J23)),\"\",\nIF(ISBLANK($K23), \"\", SUM($K$6:K23)\n))\n)","v":1327}]
[null,null,null,null,null,"6.11:  Office Pro Projects (Uses Live Application)",120,null,{"$f":"IFERROR(IF(K23=0,\"\",ROUNDDOWN(L23/Sheet2!$B$7,0)+1),\"\")","v":5},"4.14:  Office Pro Projects (Uses Live Application)",120,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J24)),\"\",\nIF(ISBLANK($K24), \"\", SUM($K$6:K24)\n))\n)","v":1447}]
[null,null,null,null,null,"6.12:  My Projects/Assignments (Not Part of Office Pro)",0,null,{"$f":"IFERROR(IF(K24=0,\"\",ROUNDDOWN(L24/Sheet2!$B$7,0)+1),\"\")","v":5},"4.15:  My Projects/Assignments",0,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J25)),\"\",\nIF(ISBLANK($K25), \"\", SUM($K$6:K25)\n))\n)","v":1447}]
[null,null,null,null,null,"6.13:  MOS Practice: Domain Questions",90,null,{"$f":"IFERROR(IF(K25=0,\"\",ROUNDDOWN(L25/Sheet2!$B$7,0)+1),\"\")","v":""},"4.16:  MOS Practice: Domain Questions",120,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J26)),\"\",\nIF(ISBLANK($K26), \"\", SUM($K$6:K26)\n))\n)","v":1567}]
[null,null,null,null,null,"6.14:  MOS Practice: Certification (A and B)  ",240,null,{"$f":"IFERROR(IF(K26=0,\"\",ROUNDDOWN(L26/Sheet2!$B$7,0)+1),\"\")","v":5},"4.17:  MOS Practice: Certification (A and B)  ",300,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J27)),\"\",\nIF(ISBLANK($K27), \"\", SUM($K$6:K27)\n))\n)","v":1867}]
[null,null,null,null,null,"6.15:  MOS Certification ",50,null,{"$f":"IFERROR(IF(K27=0,\"\",ROUNDDOWN(L27/Sheet2!$B$7,0)+1),\"\")","v":6},"4.18:  MOS Certification ",50,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J28)),\"\",\nIF(ISBLANK($K28), \"\", SUM($K$6:K28)\n))\n)","v":1917}]
[null,null,null,null,null,"6.16:  Office Pro Exam for PowerPoint",60,null,{"$f":"IFERROR(IF(K28=0,\"\",ROUNDDOWN(L28/Sheet2!$B$7,0)+1),\"\")","v":6},"4.19:  Office Pro Word Exam",60,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J29)),\"\",\nIF(ISBLANK($K29), \"\", SUM($K$6:K29)\n))\n)","v":1977}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K29=0,\"\",ROUNDDOWN(L29/Sheet2!$B$7,0)+1),\"\")","v":7},"5.01: Introduction to Excel",8,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J30)),\"\",\nIF(ISBLANK($K30), \"\", SUM($K$6:K30)\n))\n)","v":1985}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K30=0,\"\",ROUNDDOWN(L30/Sheet2!$B$7,0)+1),\"\")","v":7},"5.02: Creating and Managing Workbooks",95,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J31)),\"\",\nIF(ISBLANK($K31), \"\", SUM($K$6:K31)\n))\n)","v":2080}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K31=0,\"\",ROUNDDOWN(L31/Sheet2!$B$7,0)+1),\"\")","v":7},"5.03: Organizing and Entering Data",95,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J32)),\"\",\nIF(ISBLANK($K32), \"\", SUM($K$6:K32)\n))\n)","v":2175}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K32=0,\"\",ROUNDDOWN(L32/Sheet2!$B$7,0)+1),\"\")","v":7},"5.04: Changing Properties and Printing Worksheets",95,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J33)),\"\",\nIF(ISBLANK($K33), \"\", SUM($K$6:K33)\n))\n)","v":2270}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K33=0,\"\",ROUNDDOWN(L33/Sheet2!$B$7,0)+1),\"\")","v":8},"5.05: Formatting Cells",98,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J34)),\"\",\nIF(ISBLANK($K34), \"\", SUM($K$6:K34)\n))\n)","v":2368}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K34=0,\"\",ROUNDDOWN(L34/Sheet2!$B$7,0)+1),\"\")","v":8},"5.06: Entering Simple Formulas",115,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J35)),\"\",\nIF(ISBLANK($K35), \"\", SUM($K$6:K35)\n))\n)","v":2483}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K35=0,\"\",ROUNDDOWN(L35/Sheet2!$B$7,0)+1),\"\")","v":8},"5.07: Using Advanced Functions",133,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J36)),\"\",\nIF(ISBLANK($K36), \"\", SUM($K$6:K36)\n))\n)","v":2616}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K36=0,\"\",ROUNDDOWN(L36/Sheet2!$B$7,0)+1),\"\")","v":9},"5.08: Displaying Data in Charts",91,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J37)),\"\",\nIF(ISBLANK($K37), \"\", SUM($K$6:K37)\n))\n)","v":2707}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K37=0,\"\",ROUNDDOWN(L37/Sheet2!$B$7,0)+1),\"\")","v":9},"5.09: Organizing Data in Tables",93,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J38)),\"\",\nIF(ISBLANK($K38), \"\", SUM($K$6:K38)\n))\n)","v":2800}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K38=0,\"\",ROUNDDOWN(L38/Sheet2!$B$7,0)+1),\"\")","v":9},"5.10: Summarizing Complex Data",99,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J39)),\"\",\nIF(ISBLANK($K39), \"\", SUM($K$6:K39)\n))\n)","v":2899}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K39=0,\"\",ROUNDDOWN(L39/Sheet2!$B$7,0)+1),\"\")","v":10},"5.11:  Office Pro Projects (Uses Live Application)",120,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J40)),\"\",\nIF(ISBLANK($K40), \"\", SUM($K$6:K40)\n))\n)","v":3019}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K40=0,\"\",ROUNDDOWN(L40/Sheet2!$B$7,0)+1),\"\")","v":10},"5.12:  My Projects/Assignments",0,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J41)),\"\",\nIF(ISBLANK($K41), \"\", SUM($K$6:K41)\n))\n)","v":3019}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K41=0,\"\",ROUNDDOWN(L41/Sheet2!$B$7,0)+1),\"\")","v":""},"5.13:  MOS Practice: Domain Questions",120,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J42)),\"\",\nIF(ISBLANK($K42), \"\", SUM($K$6:K42)\n))\n)","v":3139}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K42=0,\"\",ROUNDDOWN(L42/Sheet2!$B$7,0)+1),\"\")","v":10},"5.14:  MOS Practice: Certification (A and B)  ",300,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J43)),\"\",\nIF(ISBLANK($K43), \"\", SUM($K$6:K43)\n))\n)","v":3439}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K43=0,\"\",ROUNDDOWN(L43/Sheet2!$B$7,0)+1),\"\")","v":11},"5.15:  MOS Certification ",50,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J44)),\"\",\nIF(ISBLANK($K44), \"\", SUM($K$6:K44)\n))\n)","v":3489}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K44=0,\"\",ROUNDDOWN(L44/Sheet2!$B$7,0)+1),\"\")","v":11},"5.16:  Office Pro Excel Exam",60,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J45)),\"\",\nIF(ISBLANK($K45), \"\", SUM($K$6:K45)\n))\n)","v":3549}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K45=0,\"\",ROUNDDOWN(L45/Sheet2!$B$7,0)+1),\"\")","v":12},"6.01: Introduction to PowerPoint",12,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J46)),\"\",\nIF(ISBLANK($K46), \"\", SUM($K$6:K46)\n))\n)","v":3561}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K46=0,\"\",ROUNDDOWN(L46/Sheet2!$B$7,0)+1),\"\")","v":12},"6.02: Creating and Managing Presentations",75,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J47)),\"\",\nIF(ISBLANK($K47), \"\", SUM($K$6:K47)\n))\n)","v":3636}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K47=0,\"\",ROUNDDOWN(L47/Sheet2!$B$7,0)+1),\"\")","v":12},"6.03: Formatting Textual Content",81,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J48)),\"\",\nIF(ISBLANK($K48), \"\", SUM($K$6:K48)\n))\n)","v":3717}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K48=0,\"\",ROUNDDOWN(L48/Sheet2!$B$7,0)+1),\"\")","v":12},"6.04: Designing Slides",76,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J49)),\"\",\nIF(ISBLANK($K49), \"\", SUM($K$6:K49)\n))\n)","v":3793}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K49=0,\"\",ROUNDDOWN(L49/Sheet2!$B$7,0)+1),\"\")","v":12},"6.05: Using the Slide Master",77,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J50)),\"\",\nIF(ISBLANK($K50), \"\", SUM($K$6:K50)\n))\n)","v":3870}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K50=0,\"\",ROUNDDOWN(L50/Sheet2!$B$7,0)+1),\"\")","v":13},"6.06: Formatting SmartArt and Shapes",77,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J51)),\"\",\nIF(ISBLANK($K51), \"\", SUM($K$6:K51)\n))\n)","v":3947}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K51=0,\"\",ROUNDDOWN(L51/Sheet2!$B$7,0)+1),\"\")","v":13},"6.07: Formatting Tables and Charts",77,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J52)),\"\",\nIF(ISBLANK($K52), \"\", SUM($K$6:K52)\n))\n)","v":4024}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K52=0,\"\",ROUNDDOWN(L52/Sheet2!$B$7,0)+1),\"\")","v":13},"6.08: Formatting Pictures and Other Media",79,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J53)),\"\",\nIF(ISBLANK($K53), \"\", SUM($K$6:K53)\n))\n)","v":4103}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K53=0,\"\",ROUNDDOWN(L53/Sheet2!$B$7,0)+1),\"\")","v":13},"6.09: Applying Animations and Transitions",77,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J54)),\"\",\nIF(ISBLANK($K54), \"\", SUM($K$6:K54)\n))\n)","v":4180}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K54=0,\"\",ROUNDDOWN(L54/Sheet2!$B$7,0)+1),\"\")","v":14},"6.10: Delivering Presentations",81,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J55)),\"\",\nIF(ISBLANK($K55), \"\", SUM($K$6:K55)\n))\n)","v":4261}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K55=0,\"\",ROUNDDOWN(L55/Sheet2!$B$7,0)+1),\"\")","v":14},"6.11:  Office Pro Projects (Uses Live Application)",120,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J56)),\"\",\nIF(ISBLANK($K56), \"\", SUM($K$6:K56)\n))\n)","v":4381}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K56=0,\"\",ROUNDDOWN(L56/Sheet2!$B$7,0)+1),\"\")","v":14},"6.12:  My Projects/Assignments",0,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J57)),\"\",\nIF(ISBLANK($K57), \"\", SUM($K$6:K57)\n))\n)","v":4381}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K57=0,\"\",ROUNDDOWN(L57/Sheet2!$B$7,0)+1),\"\")","v":""},"6.13:  MOS Practice: Domain Questions",90,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J58)),\"\",\nIF(ISBLANK($K58), \"\", SUM($K$6:K58)\n))\n)","v":4471}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K58=0,\"\",ROUNDDOWN(L58/Sheet2!$B$7,0)+1),\"\")","v":14},"6.14:  MOS Practice: Certification (A and B)  ",240,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J59)),\"\",\nIF(ISBLANK($K59), \"\", SUM($K$6:K59)\n))\n)","v":4711}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K59=0,\"\",ROUNDDOWN(L59/Sheet2!$B$7,0)+1),\"\")","v":15},"6.15:  MOS Certification ",50,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J60)),\"\",\nIF(ISBLANK($K60), \"\", SUM($K$6:K60)\n))\n)","v":4761}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K60=0,\"\",ROUNDDOWN(L60/Sheet2!$B$7,0)+1),\"\")","v":15},"6.16:  Office Pro PowerPoint Exam",60,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J61)),\"\",\nIF(ISBLANK($K61), \"\", SUM($K$6:K61)\n))\n)","v":4821}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K61=0,\"\",ROUNDDOWN(L61/Sheet2!$B$7,0)+1),\"\")","v":16},"7.1: Introduction to Access",9,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J62)),\"\",\nIF(ISBLANK($K62), \"\", SUM($K$6:K62)\n))\n)","v":4830}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K62=0,\"\",ROUNDDOWN(L62/Sheet2!$B$7,0)+1),\"\")","v":16},"7.2: Managing Databases",96,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J63)),\"\",\nIF(ISBLANK($K63), \"\", SUM($K$6:K63)\n))\n)","v":4926}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K63=0,\"\",ROUNDDOWN(L63/Sheet2!$B$7,0)+1),\"\")","v":16},"7.3: Designing and Creating Tables",85,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J64)),\"\",\nIF(ISBLANK($K64), \"\", SUM($K$6:K64)\n))\n)","v":5011}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K64=0,\"\",ROUNDDOWN(L64/Sheet2!$B$7,0)+1),\"\")","v":16},"7.4: Using Simple Queries",78,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J65)),\"\",\nIF(ISBLANK($K65), \"\", SUM($K$6:K65)\n))\n)","v":5089}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K65=0,\"\",ROUNDDOWN(L65/Sheet2!$B$7,0)+1),\"\")","v":16},"7.5: Creating Forms",76,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J66)),\"\",\nIF(ISBLANK($K66), \"\", SUM($K$6:K66)\n))\n)","v":5165}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K66=0,\"\",ROUNDDOWN(L66/Sheet2!$B$7,0)+1),\"\")","v":17},"7.6: Creating Reports",80,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J67)),\"\",\nIF(ISBLANK($K67), \"\", SUM($K$6:K67)\n))\n)","v":5245}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K67=0,\"\",ROUNDDOWN(L67/Sheet2!$B$7,0)+1),\"\")","v":17},"7.7: Surveying Advanced Access Features",43,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J68)),\"\",\nIF(ISBLANK($K68), \"\", SUM($K$6:K68)\n))\n)","v":5288}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K68=0,\"\",ROUNDDOWN(L68/Sheet2!$B$7,0)+1),\"\")","v":17},"7.8: Exam: Access",60,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J69)),\"\",\nIF(ISBLANK($K69), \"\", SUM($K$6:K69)\n))\n)","v":5348}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K69=0,\"\",ROUNDDOWN(L69/Sheet2!$B$7,0)+1),\"\")","v":17},"8.1: Introduction to Outlook",11,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J70)),\"\",\nIF(ISBLANK($K70), \"\", SUM($K$6:K70)\n))\n)","v":5359}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K70=0,\"\",ROUNDDOWN(L70/Sheet2!$B$7,0)+1),\"\")","v":17},"8.2: Sending and Receiving Messages",85,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J71)),\"\",\nIF(ISBLANK($K71), \"\", SUM($K$6:K71)\n))\n)","v":5444}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K71=0,\"\",ROUNDDOWN(L71/Sheet2!$B$7,0)+1),\"\")","v":18},"8.3: Managing Messages",90,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J72)),\"\",\nIF(ISBLANK($K72), \"\", SUM($K$6:K72)\n))\n)","v":5534}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K72=0,\"\",ROUNDDOWN(L72/Sheet2!$B$7,0)+1),\"\")","v":18},"8.4: Working with the Calendar",83,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J73)),\"\",\nIF(ISBLANK($K73), \"\", SUM($K$6:K73)\n))\n)","v":5617}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K73=0,\"\",ROUNDDOWN(L73/Sheet2!$B$7,0)+1),\"\")","v":18},"8.5: Managing Contacts and Groups",82,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J74)),\"\",\nIF(ISBLANK($K74), \"\", SUM($K$6:K74)\n))\n)","v":5699}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K74=0,\"\",ROUNDDOWN(L74/Sheet2!$B$7,0)+1),\"\")","v":18},"8.6: Exam: Outlook",60,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J75)),\"\",\nIF(ISBLANK($K75), \"\", SUM($K$6:K75)\n))\n)","v":5759}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K75=0,\"\",ROUNDDOWN(L75/Sheet2!$B$7,0)+1),\"\")","v":19},"Grand Total",5759,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J76)),\"\",\nIF(ISBLANK($K76), \"\", SUM($K$6:K76)\n))\n)","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K76=0,\"\",ROUNDDOWN(L76/Sheet2!$B$7,0)+1),\"\")","v":""},null,null,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J77)),\"\",\nIF(ISBLANK($K77), \"\", SUM($K$6:K77)\n))\n)","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K77=0,\"\",ROUNDDOWN(L77/Sheet2!$B$7,0)+1),\"\")","v":""},null,null,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J78)),\"\",\nIF(ISBLANK($K78), \"\", SUM($K$6:K78)\n))\n)","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K78=0,\"\",ROUNDDOWN(L78/Sheet2!$B$7,0)+1),\"\")","v":""},null,null,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J79)),\"\",\nIF(ISBLANK($K79), \"\", SUM($K$6:K79)\n))\n)","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K79=0,\"\",ROUNDDOWN(L79/Sheet2!$B$7,0)+1),\"\")","v":""},null,null,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J80)),\"\",\nIF(ISBLANK($K80), \"\", SUM($K$6:K80)\n))\n)","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K80=0,\"\",ROUNDDOWN(L80/Sheet2!$B$7,0)+1),\"\")","v":""},null,null,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J81)),\"\",\nIF(ISBLANK($K81), \"\", SUM($K$6:K81)\n))\n)","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K81=0,\"\",ROUNDDOWN(L81/Sheet2!$B$7,0)+1),\"\")","v":""},null,null,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J82)),\"\",\nIF(ISBLANK($K82), \"\", SUM($K$6:K82)\n))\n)","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(K82=0,\"\",ROUNDDOWN(L82/Sheet2!$B$7,0)+1)","v":""},null,null,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J83)),\"\",\nIF(ISBLANK($K83), \"\", SUM($K$6:K83)\n))\n)","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(K83=0,\"\",ROUNDDOWN(L83/Sheet2!$B$7,0)+1)","v":""},null,null,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J84)),\"\",\nIF(ISBLANK($K84), \"\", SUM($K$6:K84)\n))\n)","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(K84=0,\"\",ROUNDDOWN(L84/Sheet2!$B$7,0)+1)","v":""},null,null,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J85)),\"\",\nIF(ISBLANK($K85), \"\", SUM($K$6:K85)\n))\n)","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(K85=0,\"\",ROUNDDOWN(L85/Sheet2!$B$7,0)+1)","v":""},null,null,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J86)),\"\",\nIF(ISBLANK($K86), \"\", SUM($K$6:K86)\n))\n)","v":""}]

{"sheet":"Advanced Guide","index":1,"n_rows":55,"n_cols":25,"rows_kept":55,"cut":false,"hidden":true,"merged":[[6,3,7,3],[1,1,4,3]]}
[]
[null,"Step 6: Class Components\nFor each Component, select Yes or No from the drop-down\n• Yes = Retains/Adds Time\n• No = Removes Time\n"]
[]
[]
[]
[]
[null,"                                                                                                                                 ",null,"Avg. # of Min. ","Homework Recommendations"]
[null,null,null,null,"Traditional","Hybrid ",null,null,null,null,null,null,null,null,null,"Online","Flipped"]
[null,"Videos","Yes",15,"No","No",{"$f":"IF(C9=\"No\",-15,0)","v":0},null,null,null,null,null,null,null,null,"Yes","No"]
[null,"Skills Lab","Yes",25,"Yes","Yes",{"$f":"IF(C10=\"No\",-25,0)","v":0},null,null,null,null,null,null,null,null,"Yes","Yes"]
[null,"Challenge Lab","Yes",15,"Yes","No",{"$f":"IF(C11=\"No\",-15,0)","v":0},null,null,null,null,null,null,null,null,"Yes","Yes"]
[null,"Applied ","Yes",20,"Yes","No",{"$f":"IF(C12=\"No\",-20,0)","v":0},null,null,null,null,null,null,null,null,"Yes","No"]
[null,"Class Lectures",0]
[]
[null,"School Week","Sections Per Week","Content Per Week","Class Activity Time","Over Under Time ","Column2","Fact & Tip","Skills","Challenge","Applied","Videos","discussions","Min. Per Week",null,null,null,null,null,null,null,"Content Per Week"]
[null,1,{"$f":"IFERROR(IF(V16=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$84,1)),\"\")","v":7},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$85,B16,'Pacing Guide'!K$6:K$85)=0,\"\",SUMIF('Pacing Guide'!I$6:I$85,B16,'Pacing Guide'!K$6:K$85))","v":344},{"$f":"IFERROR(D16+M16+I16+J16+K16+L16,\"\")","v":344},{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N16-E16),\"\")","v":-344},null,{"$f":"C16*'Advanced Guide'!#REF!","v":{"$error":"#REF!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$10","v":0},{"$f":"$G$11*Table3[[#This Row],[Sections Per Week]]","v":0},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$12","v":0},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$9","v":0},{"$f":"'Advanced Guide'!$C$13*Table3[[#This Row],[Sections Per Week]]","v":0},{"$f":"IF(Table3[[#This Row],[Content Per Week]]=0,\"\",'Pacing Guide'!$A$32*'Advanced Guide'!$P$18)","v":0},null,null,null,null,null,null,null,{"$f":"Table3[[#This Row],[Content Per Week]]/$P$17","v":"05:44:00"},null,{"$f":"E16/1440","v":"05:44:00"},{"$f":"F16/1440","v":-0.2388888888888889}]
[null,2,{"$f":"IFERROR(IF(V17=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$84,1)),\"\")","v":7},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$85,B17,'Pacing Guide'!K$6:K$85)=0,\"\",SUMIF('Pacing Guide'!I$6:I$85,B17,'Pacing Guide'!K$6:K$85))","v":383},383,{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N17-E17),\"\")","v":-383},null,{"$f":"C17*'Advanced Guide'!#REF!","v":{"$error":"#REF!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$10","v":0},{"$f":"$G$11*Table3[[#This Row],[Sections Per Week]]","v":0},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$12","v":0},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$9","v":0},{"$f":"'Advanced Guide'!$C$13*Table3[[#This Row],[Sections Per Week]]","v":0},{"$f":"IF(Table3[[#This Row],[Content Per Week]]=0,\"\",'Pacing Guide'!$A$32*'Advanced Guide'!$P$18)","v":0},null,1440,null,null,null,null,null,{"$f":"Table3[[#This Row],[Content Per Week]]/$P$17","v":"06:23:00"}]
[null,3,{"$f":"IFERROR(IF(V18=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$84,1)),\"\")","v":7},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$85,B18,'Pacing Guide'!K$6:K$85)=0,\"\",SUMIF('Pacing Guide'!I$6:I$85,B18,'Pacing Guide'!K$6:K$85))","v":289},289,{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N18-E18),\"\")","v":-289},null,{"$f":"C18*'Advanced Guide'!#REF!","v":{"$error":"#REF!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$10","v":0},{"$f":"$G$11*Table3[[#This Row],[Sections Per Week]]","v":0},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$12","v":0},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$9","v":0},{"$f":"'Advanced Guide'!$C$13*Table3[[#This Row],[Sections Per Week]]","v":0},{"$f":"IF(Table3[[#This Row],[Content Per Week]]=0,\"\",'Pacing Guide'!$A$32*'Advanced Guide'!$P$18)","v":0},null,60,null,null,null,null,null,{"$f":"Table3[[#This Row],[Content Per Week]]/$P$17","v":"04:49:00"}]
[null,4,{"$f":"IFERROR(IF(V19=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$84,1)),\"\")","v":7},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$85,B19,'Pacing Guide'!K$6:K$85)=0,\"\",SUMIF('Pacing Guide'!I$6:I$85,B19,'Pacing Guide'!K$6:K$85))","v":300},300,{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N19-E19),\"\")","v":-300},null,{"$f":"C19*'Advanced Guide'!#REF!","v":{"$error":"#REF!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$10","v":0},{"$f":"$G$11*Table3[[#This Row],[Sections Per Week]]","v":0},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$12","v":0},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$9","v":0},{"$f":"'Advanced Guide'!$C$13*Table3[[#This Row],[Sections Per Week]]","v":0},{"$f":"IF(Table3[[#This Row],[Content Per Week]]=0,\"\",'Pacing Guide'!$A$32*'Advanced Guide'!$P$18)","v":0},null,null,null,null,null,null,null,{"$f":"Table3[[#This Row],[Content Per Week]]/$P$17","v":"05:00:00"}]
[null,5,{"$f":"IFERROR(IF(V20=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$84,1)),\"\")","v":7},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$85,B20,'Pacing Guide'!K$6:K$85)=0,\"\",SUMIF('Pacing Guide'!I$6:I$85,B20,'Pacing Guide'!K$6:K$85))","v":431},431,{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N20-E20),\"\")","v":-431},null,{"$f":"C20*'Advanced Guide'!#REF!","v":{"$error":"#REF!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$10","v":0},{"$f":"$G$11*Table3[[#This Row],[Sections Per Week]]","v":0},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$12","v":0},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$9","v":0},{"$f":"'Advanced Guide'!$C$13*Table3[[#This Row],[Sections Per Week]]","v":0},{"$f":"IF(Table3[[#This Row],[Content Per Week]]=0,\"\",'Pacing Guide'!$A$32*'Advanced Guide'!$P$18)","v":0},null,null,null,null,null,null,null,{"$f":"Table3[[#This Row],[Content Per Week]]/$P$17","v":"07:11:00"}]
[null,6,{"$f":"IFERROR(IF(V21=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$84,1)),\"\")","v":7},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$85,B21,'Pacing Guide'!K$6:K$85)=0,\"\",SUMIF('Pacing Guide'!I$6:I$85,B21,'Pacing Guide'!K$6:K$85))","v":110},110,{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N21-E21),\"\")","v":-110},null,{"$f":"C21*'Advanced Guide'!#REF!","v":{"$error":"#REF!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$10","v":0},{"$f":"$G$11*Table3[[#This Row],[Sections Per Week]]","v":0},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$12","v":0},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$9","v":0},{"$f":"'Advanced Guide'!$C$13*Table3[[#This Row],[Sections Per Week]]","v":0},{"$f":"IF(Table3[[#This Row],[Content Per Week]]=0,\"\",'Pacing Guide'!$A$32*'Advanced Guide'!$P$18)","v":0},null,null,null,null,null,null,null,{"$f":"Table3[[#This Row],[Content Per Week]]/$P$17","v":"01:50:00"}]
[null,7,{"$f":"IFERROR(IF(V22=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$84,1)),\"\")","v":7},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$85,B22,'Pacing Guide'!K$6:K$85)=0,\"\",SUMIF('Pacing Guide'!I$6:I$85,B22,'Pacing Guide'!K$6:K$85))","v":293},293,{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N22-E22),\"\")","v":-293},null,{"$f":"C22*'Advanced Guide'!#REF!","v":{"$error":"#REF!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$10","v":0},{"$f":"$G$11*Table3[[#This Row],[Sections Per Week]]","v":0},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$12","v":0},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$9","v":0},{"$f":"'Advanced Guide'!$C$13*Table3[[#This Row],[Sections Per Week]]","v":0},{"$f":"IF(Table3[[#This Row],[Content Per Week]]=0,\"\",'Pacing Guide'!$A$32*'Advanced Guide'!$P$18)","v":0},null,null,null,null,null,null,null,{"$f":"Table3[[#This Row],[Content Per Week]]/$P$17","v":"04:53:00"}]
[null,8,{"$f":"IFERROR(IF(V23=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$84,1)),\"\")","v":7},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$85,B23,'Pacing Guide'!K$6:K$85)=0,\"\",SUMIF('Pacing Guide'!I$6:I$85,B23,'Pacing Guide'!K$6:K$85))","v":346},346,{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N23-E23),\"\")","v":-346},null,{"$f":"C23*'Advanced Guide'!#REF!","v":{"$error":"#REF!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$10","v":0},{"$f":"$G$11*Table3[[#This Row],[Sections Per Week]]","v":0},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$12","v":0},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$9","v":0},{"$f":"'Advanced Guide'!$C$13*Table3[[#This Row],[Sections Per Week]]","v":0},{"$f":"IF(Table3[[#This Row],[Content Per Week]]=0,\"\",'Pacing Guide'!$A$32*'Advanced Guide'!$P$18)","v":0},null,null,null,null,null,null,null,{"$f":"Table3[[#This Row],[Content Per Week]]/$P$17","v":"05:46:00"}]
[null,9,{"$f":"IFERROR(IF(V24=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$84,1)),\"\")","v":7},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$85,B24,'Pacing Guide'!K$6:K$85)=0,\"\",SUMIF('Pacing Guide'!I$6:I$85,B24,'Pacing Guide'!K$6:K$85))","v":283},283,{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N24-E24),\"\")","v":-283},null,{"$f":"C24*'Advanced Guide'!#REF!","v":{"$error":"#REF!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$10","v":0},{"$f":"$G$11*Table3[[#This Row],[Sections Per Week]]","v":0},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$12","v":0},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$9","v":0},{"$f":"'Advanced Guide'!$C$13*Table3[[#This Row],[Sections Per Week]]","v":0},{"$f":"IF(Table3[[#This Row],[Content Per Week]]=0,\"\",'Pacing Guide'!$A$32*'Advanced Guide'!$P$18)","v":0},null,null,null,null,null,null,null,{"$f":"Table3[[#This Row],[Content Per Week]]/$P$17","v":"04:43:00"}]
[null,10,{"$f":"IFERROR(IF(V25=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$84,1)),\"\")","v":7},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$85,B25,'Pacing Guide'!K$6:K$85)=0,\"\",SUMIF('Pacing Guide'!I$6:I$85,B25,'Pacing Guide'!K$6:K$85))","v":420},420,{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N25-E25),\"\")","v":-420},null,{"$f":"C25*'Advanced Guide'!#REF!","v":{"$error":"#REF!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$10","v":0},{"$f":"$G$11*Table3[[#This Row],[Sections Per Week]]","v":0},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$12","v":0},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$9","v":0},{"$f":"'Advanced Guide'!$C$13*Table3[[#This Row],[Sections Per Week]]","v":0},{"$f":"IF(Table3[[#This Row],[Content Per Week]]=0,\"\",'Pacing Guide'!$A$32*'Advanced Guide'!$P$18)","v":0},null,null,null,null,null,null,null,{"$f":"Table3[[#This Row],[Content Per Week]]/$P$17","v":"07:00:00"}]
[null,11,{"$f":"IFERROR(IF(V26=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$84,1)),\"\")","v":7},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$85,B26,'Pacing Guide'!K$6:K$85)=0,\"\",SUMIF('Pacing Guide'!I$6:I$85,B26,'Pacing Guide'!K$6:K$85))","v":110},110,{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N26-E26),\"\")","v":-110},null,{"$f":"C26*'Advanced Guide'!#REF!","v":{"$error":"#REF!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$10","v":0},{"$f":"$G$11*Table3[[#This Row],[Sections Per Week]]","v":0},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$12","v":0},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$9","v":0},{"$f":"'Advanced Guide'!$C$13*Table3[[#This Row],[Sections Per Week]]","v":0},{"$f":"IF(Table3[[#This Row],[Content Per Week]]=0,\"\",'Pacing Guide'!$A$32*'Advanced Guide'!$P$18)","v":0},null,null,null,null,null,null,null,{"$f":"Table3[[#This Row],[Content Per Week]]/$P$17","v":"01:50:00"}]
[null,12,{"$f":"IFERROR(IF(V27=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$84,1)),\"\")","v":7},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$85,B27,'Pacing Guide'!K$6:K$85)=0,\"\",SUMIF('Pacing Guide'!I$6:I$85,B27,'Pacing Guide'!K$6:K$85))","v":321},321,{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N27-E27),\"\")","v":-321},null,{"$f":"C27*'Advanced Guide'!#REF!","v":{"$error":"#REF!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$10","v":0},{"$f":"$G$11*Table3[[#This Row],[Sections Per Week]]","v":0},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$12","v":0},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$9","v":0},{"$f":"'Advanced Guide'!$C$13*Table3[[#This Row],[Sections Per Week]]","v":0},{"$f":"IF(Table3[[#This Row],[Content Per Week]]=0,\"\",'Pacing Guide'!$A$32*'Advanced Guide'!$P$18)","v":0},null,null,null,null,null,null,null,{"$f":"Table3[[#This Row],[Content Per Week]]/$P$17","v":"05:21:00"}]
[null,13,{"$f":"IFERROR(IF(V28=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$84,1)),\"\")","v":7},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$85,B28,'Pacing Guide'!K$6:K$85)=0,\"\",SUMIF('Pacing Guide'!I$6:I$85,B28,'Pacing Guide'!K$6:K$85))","v":310},310,{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N28-E28),\"\")","v":-310},null,{"$f":"C28*'Advanced Guide'!#REF!","v":{"$error":"#REF!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$10","v":0},{"$f":"$G$11*Table3[[#This Row],[Sections Per Week]]","v":0},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$12","v":0},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$9","v":0},{"$f":"'Advanced Guide'!$C$13*Table3[[#This Row],[Sections Per Week]]","v":0},{"$f":"IF(Table3[[#This Row],[Content Per Week]]=0,\"\",'Pacing Guide'!$A$32*'Advanced Guide'!$P$18)","v":0},null,null,null,null,null,null,null,{"$f":"Table3[[#This Row],[Content Per Week]]/$P$17","v":"05:10:00"}]
[null,14,{"$f":"IFERROR(IF(V29=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$84,1)),\"\")","v":7},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$85,B29,'Pacing Guide'!K$6:K$85)=0,\"\",SUMIF('Pacing Guide'!I$6:I$85,B29,'Pacing Guide'!K$6:K$85))","v":441},441,{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N29-E29),\"\")","v":-441},null,{"$f":"C29*'Advanced Guide'!#REF!","v":{"$error":"#REF!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$10","v":0},{"$f":"$G$11*Table3[[#This Row],[Sections Per Week]]","v":0},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$12","v":0},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$9","v":0},{"$f":"'Advanced Guide'!$C$13*Table3[[#This Row],[Sections Per Week]]","v":0},{"$f":"IF(Table3[[#This Row],[Content Per Week]]=0,\"\",'Pacing Guide'!$A$32*'Advanced Guide'!$P$18)","v":0},null,null,null,null,null,null,null,{"$f":"Table3[[#This Row],[Content Per Week]]/$P$17","v":"07:21:00"}]
[null,15,{"$f":"IFERROR(IF(V30=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$84,1)),\"\")","v":7},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$85,B30,'Pacing Guide'!K$6:K$85)=0,\"\",SUMIF('Pacing Guide'!I$6:I$85,B30,'Pacing Guide'!K$6:K$85))","v":110},110,{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N30-E30),\"\")","v":-110},null,{"$f":"C30*'Advanced Guide'!#REF!","v":{"$error":"#REF!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$10","v":0},{"$f":"$G$11*Table3[[#This Row],[Sections Per Week]]","v":0},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$12","v":0},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$9","v":0},{"$f":"'Advanced Guide'!$C$13*Table3[[#This Row],[Sections Per Week]]","v":0},{"$f":"IF(Table3[[#This Row],[Content Per Week]]=0,\"\",'Pacing Guide'!$A$32*'Advanced Guide'!$P$18)","v":0},null,null,null,null,null,null,null,{"$f":"Table3[[#This Row],[Content Per Week]]/$P$17","v":"01:50:00"}]
[null,16,{"$f":"IFERROR(IF(V31=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$84,1)),\"\")","v":7},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$85,B31,'Pacing Guide'!K$6:K$85)=0,\"\",SUMIF('Pacing Guide'!I$6:I$85,B31,'Pacing Guide'!K$6:K$85))","v":344},344,{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N31-E31),\"\")","v":-344},null,{"$f":"C31*'Advanced Guide'!#REF!","v":{"$error":"#REF!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$10","v":0},{"$f":"$G$11*Table3[[#This Row],[Sections Per Week]]","v":0},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$12","v":0},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$9","v":0},{"$f":"'Advanced Guide'!$C$13*Table3[[#This Row],[Sections Per Week]]","v":0},{"$f":"IF(Table3[[#This Row],[Content Per Week]]=0,\"\",'Pacing Guide'!$A$32*'Advanced Guide'!$P$18)","v":0},null,null,null,null,null,null,null,{"$f":"Table3[[#This Row],[Content Per Week]]/$P$17","v":"05:44:00"}]
[null,17,{"$f":"IFERROR(IF(V32=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$84,1)),\"\")","v":7},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$85,B32,'Pacing Guide'!K$6:K$85)=0,\"\",SUMIF('Pacing Guide'!I$6:I$85,B32,'Pacing Guide'!K$6:K$85))","v":279},279,{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N32-E32),\"\")","v":-279},null,{"$f":"C32*'Advanced Guide'!#REF!","v":{"$error":"#REF!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$10","v":0},{"$f":"$G$11*Table3[[#This Row],[Sections Per Week]]","v":0},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$12","v":0},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$9","v":0},{"$f":"'Advanced Guide'!$C$13*Table3[[#This Row],[Sections Per Week]]","v":0},{"$f":"IF(Table3[[#This Row],[Content Per Week]]=0,\"\",'Pacing Guide'!$A$32*'Advanced Guide'!$P$18)","v":0},null,null,null,null,null,null,null,{"$f":"Table3[[#This Row],[Content Per Week]]/$P$17","v":"04:39:00"}]
[null,18,{"$f":"IFERROR(IF(V33=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$84,1)),\"\")","v":7},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$85,B33,'Pacing Guide'!K$6:K$85)=0,\"\",SUMIF('Pacing Guide'!I$6:I$85,B33,'Pacing Guide'!K$6:K$85))","v":315},315,{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N33-E33),\"\")","v":-315},null,{"$f":"C33*'Advanced Guide'!#REF!","v":{"$error":"#REF!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$10","v":0},{"$f":"$G$11*Table3[[#This Row],[Sections Per Week]]","v":0},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$12","v":0},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$9","v":0},{"$f":"'Advanced Guide'!$C$13*Table3[[#This Row],[Sections Per Week]]","v":0},{"$f":"IF(Table3[[#This Row],[Content Per Week]]=0,\"\",'Pacing Guide'!$A$32*'Advanced Guide'!$P$18)","v":0},null,null,null,null,null,null,null,{"$f":"Table3[[#This Row],[Content Per Week]]/$P$17","v":"05:15:00"}]
[null,19,{"$f":"IFERROR(IF(V34=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$84,1)),\"\")","v":7},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$85,B34,'Pacing Guide'!K$6:K$85)=0,\"\",SUMIF('Pacing Guide'!I$6:I$85,B34,'Pacing Guide'!K$6:K$85))","v":5759},{"$f":"IFERROR(D34+M34+I34+J34+K34+L34,\"\")","v":5759},{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N34-E34),\"\")","v":-5759},null,{"$f":"C34*'Advanced Guide'!#REF!","v":{"$error":"#REF!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$10","v":0},{"$f":"$G$11*Table3[[#This Row],[Sections Per Week]]","v":0},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$12","v":0},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$9","v":0},{"$f":"'Advanced Guide'!$C$13*Table3[[#This Row],[Sections Per Week]]","v":0},{"$f":"IF(Table3[[#This Row],[Content Per Week]]=0,\"\",'Pacing Guide'!$A$32*'Advanced Guide'!$P$18)","v":0},null,null,null,null,null,null,null,{"$f":"Table3[[#This Row],[Content Per Week]]/$P$17","v":3.9993055555555554}]
[null,20,{"$f":"IFERROR(IF(V35=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$84,1)),\"\")","v":""},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$85,B35,'Pacing Guide'!K$6:K$85)=0,\"\",SUMIF('Pacing Guide'!I$6:I$85,B35,'Pacing Guide'!K$6:K$85))","v":""},{"$f":"IFERROR(D35+M35+I35+J35+K35+L35,\"\")","v":""},{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N35-E35),\"\")","v":""},null,{"$f":"C35*'Advanced Guide'!#REF!","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$10","v":{"$error":"#VALUE!"}},{"$f":"$G$11*Table3[[#This Row],[Sections Per Week]]","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$12","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$9","v":{"$error":"#VALUE!"}},{"$f":"'Advanced Guide'!$C$13*Table3[[#This Row],[Sections Per Week]]","v":{"$error":"#VALUE!"}},{"$f":"IF(Table3[[#This Row],[Content Per Week]]=0,\"\",'Pacing Guide'!$A$32*'Advanced Guide'!$P$18)","v":0},null,null,null,null,null,null,null,{"$f":"Table3[[#This Row],[Content Per Week]]/$P$17","v":{"$error":"#VALUE!"}}]
[null,21,{"$f":"IFERROR(IF(V36=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$84,1)),\"\")","v":""},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$85,B36,'Pacing Guide'!K$6:K$85)=0,\"\",SUMIF('Pacing Guide'!I$6:I$85,B36,'Pacing Guide'!K$6:K$85))","v":""},"",{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N36-E36),\"\")","v":""},null,{"$f":"C36*'Advanced Guide'!#REF!","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$10","v":{"$error":"#VALUE!"}},{"$f":"$G$11*Table3[[#This Row],[Sections Per Week]]","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$12","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$9","v":{"$error":"#VALUE!"}},{"$f":"'Advanced Guide'!$C$13*Table3[[#This Row],[Sections Per Week]]","v":{"$error":"#VALUE!"}},{"$f":"IF(Table3[[#This Row],[Content Per Week]]=0,\"\",'Pacing Guide'!$A$32*'Advanced Guide'!$P$18)","v":0},null,null,null,null,null,null,null,{"$f":"Table3[[#This Row],[Content Per Week]]/$P$17","v":{"$error":"#VALUE!"}}]
[null,22,{"$f":"IFERROR(IF(V37=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$84,1)),\"\")","v":""},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$85,B37,'Pacing Guide'!K$6:K$85)=0,\"\",SUMIF('Pacing Guide'!I$6:I$85,B37,'Pacing Guide'!K$6:K$85))","v":""},"",{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N37-E37),\"\")","v":""},null,{"$f":"C37*'Advanced Guide'!#REF!","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$10","v":{"$error":"#VALUE!"}},{"$f":"$G$11*Table3[[#This Row],[Sections Per Week]]","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$12","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$9","v":{"$error":"#VALUE!"}},{"$f":"'Advanced Guide'!$C$13*Table3[[#This Row],[Sections Per Week]]","v":{"$error":"#VALUE!"}},{"$f":"IF(Table3[[#This Row],[Content Per Week]]=0,\"\",'Pacing Guide'!$A$32*'Advanced Guide'!$P$18)","v":0},null,null,null,null,null,null,null,{"$f":"Table3[[#This Row],[Content Per Week]]/$P$17","v":{"$error":"#VALUE!"}}]
[null,23,{"$f":"IFERROR(IF(V38=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$84,1)),\"\")","v":""},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$85,B38,'Pacing Guide'!K$6:K$85)=0,\"\",SUMIF('Pacing Guide'!I$6:I$85,B38,'Pacing Guide'!K$6:K$85))","v":""},"",{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N38-E38),\"\")","v":""},null,{"$f":"C38*'Advanced Guide'!#REF!","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$10","v":{"$error":"#VALUE!"}},{"$f":"$G$11*Table3[[#This Row],[Sections Per Week]]","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$12","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$9","v":{"$error":"#VALUE!"}},{"$f":"'Advanced Guide'!$C$13*Table3[[#This Row],[Sections Per Week]]","v":{"$error":"#VALUE!"}},{"$f":"IF(Table3[[#This Row],[Content Per Week]]=0,\"\",'Pacing Guide'!$A$32*'Advanced Guide'!$P$18)","v":0},null,null,null,null,null,null,null,{"$f":"Table3[[#This Row],[Content Per Week]]/$P$17","v":{"$error":"#VALUE!"}}]
[null,24,{"$f":"IFERROR(IF(V39=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$84,1)),\"\")","v":""},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$85,B39,'Pacing Guide'!K$6:K$85)=0,\"\",SUMIF('Pacing Guide'!I$6:I$85,B39,'Pacing Guide'!K$6:K$85))","v":""},"",{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N39-E39),\"\")","v":""},null,{"$f":"C39*'Advanced Guide'!#REF!","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$10","v":{"$error":"#VALUE!"}},{"$f":"$G$11*Table3[[#This Row],[Sections Per Week]]","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$12","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$9","v":{"$error":"#VALUE!"}},{"$f":"'Advanced Guide'!$C$13*Table3[[#This Row],[Sections Per Week]]","v":{"$error":"#VALUE!"}},{"$f":"IF(Table3[[#This Row],[Content Per Week]]=0,\"\",'Pacing Guide'!$A$32*'Advanced Guide'!$P$18)","v":0},null,null,null,null,null,null,null,{"$f":"Table3[[#This Row],[Content Per Week]]/$P$17","v":{"$error":"#VALUE!"}}]
[null,25,{"$f":"IFERROR(IF(V40=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$84,1)),\"\")","v":""},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$85,B40,'Pacing Guide'!K$6:K$85)=0,\"\",SUMIF('Pacing Guide'!I$6:I$85,B40,'Pacing Guide'!K$6:K$85))","v":""},"",{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N40-E40),\"\")","v":""},null,{"$f":"C40*'Advanced Guide'!#REF!","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$10","v":{"$error":"#VALUE!"}},{"$f":"$G$11*Table3[[#This Row],[Sections Per Week]]","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$12","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$9","v":{"$error":"#VALUE!"}},{"$f":"'Advanced Guide'!$C$13*Table3[[#This Row],[Sections Per Week]]","v":{"$error":"#VALUE!"}},{"$f":"IF(Table3[[#This Row],[Content Per Week]]=0,\"\",'Pacing Guide'!$A$32*'Advanced Guide'!$P$18)","v":0},null,null,null,null,null,null,null,{"$f":"Table3[[#This Row],[Content Per Week]]/$P$17","v":{"$error":"#VALUE!"}}]
[null,26,{"$f":"IFERROR(IF(V41=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$84,1)),\"\")","v":""},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$85,B41,'Pacing Guide'!K$6:K$85)=0,\"\",SUMIF('Pacing Guide'!I$6:I$85,B41,'Pacing Guide'!K$6:K$85))","v":""},"",{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N41-E41),\"\")","v":""},null,{"$f":"C41*'Advanced Guide'!#REF!","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$10","v":{"$error":"#VALUE!"}},{"$f":"$G$11*Table3[[#This Row],[Sections Per Week]]","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$12","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$9","v":{"$error":"#VALUE!"}},{"$f":"'Advanced Guide'!$C$13*Table3[[#This Row],[Sections Per Week]]","v":{"$error":"#VALUE!"}},{"$f":"IF(Table3[[#This Row],[Content Per Week]]=0,\"\",'Pacing Guide'!$A$32*'Advanced Guide'!$P$18)","v":0},null,null,null,null,null,null,null,{"$f":"Table3[[#This Row],[Content Per Week]]/$P$17","v":{"$error":"#VALUE!"}}]
[null,27,{"$f":"IFERROR(IF(V42=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$84,1)),\"\")","v":""},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$85,B42,'Pacing Guide'!K$6:K$85)=0,\"\",SUMIF('Pacing Guide'!I$6:I$85,B42,'Pacing Guide'!K$6:K$85))","v":""},"",{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N42-E42),\"\")","v":""},null,{"$f":"C42*'Advanced Guide'!#REF!","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$10","v":{"$error":"#VALUE!"}},{"$f":"$G$11*Table3[[#This Row],[Sections Per Week]]","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$12","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$9","v":{"$error":"#VALUE!"}},{"$f":"'Advanced Guide'!$C$13*Table3[[#This Row],[Sections Per Week]]","v":{"$error":"#VALUE!"}},{"$f":"IF(Table3[[#This Row],[Content Per Week]]=0,\"\",'Pacing Guide'!$A$32*'Advanced Guide'!$P$18)","v":0},null,null,null,null,null,null,null,{"$f":"Table3[[#This Row],[Content Per Week]]/$P$17","v":{"$error":"#VALUE!"}}]
[null,28,{"$f":"IFERROR(IF(V43=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$84,1)),\"\")","v":""},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$85,B43,'Pacing Guide'!K$6:K$85)=0,\"\",SUMIF('Pacing Guide'!I$6:I$85,B43,'Pacing Guide'!K$6:K$85))","v":""},"",{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N43-E43),\"\")","v":""},null,{"$f":"C43*'Advanced Guide'!#REF!","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$10","v":{"$error":"#VALUE!"}},{"$f":"$G$11*Table3[[#This Row],[Sections Per Week]]","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$12","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$9","v":{"$error":"#VALUE!"}},{"$f":"'Advanced Guide'!$C$13*Table3[[#This Row],[Sections Per Week]]","v":{"$error":"#VALUE!"}},{"$f":"IF(Table3[[#This Row],[Content Per Week]]=0,\"\",'Pacing Guide'!$A$32*'Advanced Guide'!$P$18)","v":0},null,null,null,null,null,null,null,{"$f":"Table3[[#This Row],[Content Per Week]]/$P$17","v":{"$error":"#VALUE!"}}]
[null,29,{"$f":"IFERROR(IF(V44=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$84,1)),\"\")","v":""},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$85,B44,'Pacing Guide'!K$6:K$85)=0,\"\",SUMIF('Pacing Guide'!I$6:I$85,B44,'Pacing Guide'!K$6:K$85))","v":""},"",{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N44-E44),\"\")","v":""},null,{"$f":"C44*'Advanced Guide'!#REF!","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$10","v":{"$error":"#VALUE!"}},{"$f":"$G$11*Table3[[#This Row],[Sections Per Week]]","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$12","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$9","v":{"$error":"#VALUE!"}},{"$f":"'Advanced Guide'!$C$13*Table3[[#This Row],[Sections Per Week]]","v":{"$error":"#VALUE!"}},{"$f":"IF(Table3[[#This Row],[Content Per Week]]=0,\"\",'Pacing Guide'!$A$32*'Advanced Guide'!$P$18)","v":0},null,null,null,null,null,null,null,{"$f":"Table3[[#This Row],[Content Per Week]]/$P$17","v":{"$error":"#VALUE!"}}]
[null,30,{"$f":"IFERROR(IF(V45=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$84,1)),\"\")","v":""},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$85,B45,'Pacing Guide'!K$6:K$85)=0,\"\",SUMIF('Pacing Guide'!I$6:I$85,B45,'Pacing Guide'!K$6:K$85))","v":""},"",{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N45-E45),\"\")","v":""},null,{"$f":"C45*'Advanced Guide'!#REF!","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$10","v":{"$error":"#VALUE!"}},{"$f":"$G$11*Table3[[#This Row],[Sections Per Week]]","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$12","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$9","v":{"$error":"#VALUE!"}},{"$f":"'Advanced Guide'!$C$13*Table3[[#This Row],[Sections Per Week]]","v":{"$error":"#VALUE!"}},{"$f":"IF(Table3[[#This Row],[Content Per Week]]=0,\"\",'Pacing Guide'!$A$32*'Advanced Guide'!$P$18)","v":0},null,null,null,null,null,null,null,{"$f":"Table3[[#This Row],[Content Per Week]]/$P$17","v":{"$error":"#VALUE!"}}]
[null,31,{"$f":"IFERROR(IF(V46=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$84,1)),\"\")","v":""},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$85,B46,'Pacing Guide'!K$6:K$85)=0,\"\",SUMIF('Pacing Guide'!I$6:I$85,B46,'Pacing Guide'!K$6:K$85))","v":""},"",{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N46-E46),\"\")","v":""},null,{"$f":"C46*'Advanced Guide'!#REF!","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$10","v":{"$error":"#VALUE!"}},{"$f":"$G$11*Table3[[#This Row],[Sections Per Week]]","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$12","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$9","v":{"$error":"#VALUE!"}},{"$f":"'Advanced Guide'!$C$13*Table3[[#This Row],[Sections Per Week]]","v":{"$error":"#VALUE!"}},{"$f":"IF(Table3[[#This Row],[Content Per Week]]=0,\"\",'Pacing Guide'!$A$32*'Advanced Guide'!$P$18)","v":0},null,null,null,null,null,null,null,{"$f":"Table3[[#This Row],[Content Per Week]]/$P$17","v":{"$error":"#VALUE!"}}]
[null,32,{"$f":"IFERROR(IF(V47=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$84,1)),\"\")","v":""},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$85,B47,'Pacing Guide'!K$6:K$85)=0,\"\",SUMIF('Pacing Guide'!I$6:I$85,B47,'Pacing Guide'!K$6:K$85))","v":""},"",{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N47-E47),\"\")","v":""},null,{"$f":"C47*'Advanced Guide'!#REF!","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$10","v":{"$error":"#VALUE!"}},{"$f":"$G$11*Table3[[#This Row],[Sections Per Week]]","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$12","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$9","v":{"$error":"#VALUE!"}},{"$f":"'Advanced Guide'!$C$13*Table3[[#This Row],[Sections Per Week]]","v":{"$error":"#VALUE!"}},{"$f":"IF(Table3[[#This Row],[Content Per Week]]=0,\"\",'Pacing Guide'!$A$32*'Advanced Guide'!$P$18)","v":0},null,null,null,null,null,null,null,{"$f":"Table3[[#This Row],[Content Per Week]]/$P$17","v":{"$error":"#VALUE!"}}]
[null,33,{"$f":"IFERROR(IF(V48=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$84,1)),\"\")","v":""},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$85,B48,'Pacing Guide'!K$6:K$85)=0,\"\",SUMIF('Pacing Guide'!I$6:I$85,B48,'Pacing Guide'!K$6:K$85))","v":""},"",{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N48-E48),\"\")","v":""},null,{"$f":"C48*'Advanced Guide'!#REF!","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$10","v":{"$error":"#VALUE!"}},{"$f":"$G$11*Table3[[#This Row],[Sections Per Week]]","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$12","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$9","v":{"$error":"#VALUE!"}},{"$f":"'Advanced Guide'!$C$13*Table3[[#This Row],[Sections Per Week]]","v":{"$error":"#VALUE!"}},{"$f":"IF(Table3[[#This Row],[Content Per Week]]=0,\"\",'Pacing Guide'!$A$32*'Advanced Guide'!$P$18)","v":0},null,null,null,null,null,null,null,{"$f":"Table3[[#This Row],[Content Per Week]]/$P$17","v":{"$error":"#VALUE!"}}]
[null,34,{"$f":"IFERROR(IF(V49=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$84,1)),\"\")","v":""},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$85,B49,'Pacing Guide'!K$6:K$85)=0,\"\",SUMIF('Pacing Guide'!I$6:I$85,B49,'Pacing Guide'!K$6:K$85))","v":""},"",{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N49-E49),\"\")","v":""},null,{"$f":"C49*'Advanced Guide'!#REF!","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$10","v":{"$error":"#VALUE!"}},{"$f":"$G$11*Table3[[#This Row],[Sections Per Week]]","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$12","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$9","v":{"$error":"#VALUE!"}},{"$f":"'Advanced Guide'!$C$13*Table3[[#This Row],[Sections Per Week]]","v":{"$error":"#VALUE!"}},{"$f":"IF(Table3[[#This Row],[Content Per Week]]=0,\"\",'Pacing Guide'!$A$32*'Advanced Guide'!$P$18)","v":0},null,null,null,null,null,null,null,{"$f":"Table3[[#This Row],[Content Per Week]]/$P$17","v":{"$error":"#VALUE!"}}]
[null,35,{"$f":"IFERROR(IF(V50=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$84,1)),\"\")","v":""},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$85,B50,'Pacing Guide'!K$6:K$85)=0,\"\",SUMIF('Pacing Guide'!I$6:I$85,B50,'Pacing Guide'!K$6:K$85))","v":""},"",{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N50-E50),\"\")","v":""},null,{"$f":"C50*'Advanced Guide'!#REF!","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$10","v":{"$error":"#VALUE!"}},{"$f":"$G$11*Table3[[#This Row],[Sections Per Week]]","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$12","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$9","v":{"$error":"#VALUE!"}},{"$f":"'Advanced Guide'!$C$13*Table3[[#This Row],[Sections Per Week]]","v":{"$error":"#VALUE!"}},{"$f":"IF(Table3[[#This Row],[Content Per Week]]=0,\"\",'Pacing Guide'!$A$32*'Advanced Guide'!$P$18)","v":0},null,null,null,null,null,null,null,{"$f":"Table3[[#This Row],[Content Per Week]]/$P$17","v":{"$error":"#VALUE!"}}]
[null,36,{"$f":"IFERROR(IF(V51=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$84,1)),\"\")","v":""},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$85,B51,'Pacing Guide'!K$6:K$85)=0,\"\",SUMIF('Pacing Guide'!I$6:I$85,B51,'Pacing Guide'!K$6:K$85))","v":""},"",{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N51-E51),\"\")","v":""},null,{"$f":"C51*'Advanced Guide'!#REF!","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$10","v":{"$error":"#VALUE!"}},{"$f":"$G$11*Table3[[#This Row],[Sections Per Week]]","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$12","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$9","v":{"$error":"#VALUE!"}},{"$f":"'Advanced Guide'!$C$13*Table3[[#This Row],[Sections Per Week]]","v":{"$error":"#VALUE!"}},{"$f":"IF(Table3[[#This Row],[Content Per Week]]=0,\"\",'Pacing Guide'!$A$32*'Advanced Guide'!$P$18)","v":0},null,null,null,null,null,null,null,{"$f":"Table3[[#This Row],[Content Per Week]]/$P$17","v":{"$error":"#VALUE!"}}]
[null,37,{"$f":"IFERROR(IF(V52=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$84,1)),\"\")","v":""},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$85,B52,'Pacing Guide'!K$6:K$85)=0,\"\",SUMIF('Pacing Guide'!I$6:I$85,B52,'Pacing Guide'!K$6:K$85))","v":""},"",{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N52-E52),\"\")","v":""},null,{"$f":"C52*'Advanced Guide'!#REF!","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$10","v":{"$error":"#VALUE!"}},{"$f":"$G$11*Table3[[#This Row],[Sections Per Week]]","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$12","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$9","v":{"$error":"#VALUE!"}},{"$f":"'Advanced Guide'!$C$13*Table3[[#This Row],[Sections Per Week]]","v":{"$error":"#VALUE!"}},{"$f":"IF(Table3[[#This Row],[Content Per Week]]=0,\"\",'Pacing Guide'!$A$32*'Advanced Guide'!$P$18)","v":0},null,null,null,null,null,null,null,{"$f":"Table3[[#This Row],[Content Per Week]]/$P$17","v":{"$error":"#VALUE!"}}]
[null,38,{"$f":"IFERROR(IF(V53=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$84,1)),\"\")","v":""},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$85,B53,'Pacing Guide'!K$6:K$85)=0,\"\",SUMIF('Pacing Guide'!I$6:I$85,B53,'Pacing Guide'!K$6:K$85))","v":""},"",{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N53-E53),\"\")","v":""},null,{"$f":"C53*'Advanced Guide'!#REF!","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$10","v":{"$error":"#VALUE!"}},{"$f":"$G$11*Table3[[#This Row],[Sections Per Week]]","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$12","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$9","v":{"$error":"#VALUE!"}},{"$f":"'Advanced Guide'!$C$13*Table3[[#This Row],[Sections Per Week]]","v":{"$error":"#VALUE!"}},{"$f":"IF(Table3[[#This Row],[Content Per Week]]=0,\"\",'Pacing Guide'!$A$32*'Advanced Guide'!$P$18)","v":0},null,null,null,null,null,null,null,{"$f":"Table3[[#This Row],[Content Per Week]]/$P$17","v":{"$error":"#VALUE!"}}]
[null,39,{"$f":"IFERROR(IF(V54=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$84,1)),\"\")","v":""},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$85,B54,'Pacing Guide'!K$6:K$85)=0,\"\",SUMIF('Pacing Guide'!I$6:I$85,B54,'Pacing Guide'!K$6:K$85))","v":""},"",{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N54-E54),\"\")","v":""},null,{"$f":"C54*'Advanced Guide'!#REF!","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$10","v":{"$error":"#VALUE!"}},{"$f":"$G$11*Table3[[#This Row],[Sections Per Week]]","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$12","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$9","v":{"$error":"#VALUE!"}},{"$f":"'Advanced Guide'!$C$13*Table3[[#This Row],[Sections Per Week]]","v":{"$error":"#VALUE!"}},{"$f":"IF(Table3[[#This Row],[Content Per Week]]=0,\"\",'Pacing Guide'!$A$32*'Advanced Guide'!$P$18)","v":0},null,null,null,null,null,null,null,{"$f":"Table3[[#This Row],[Content Per Week]]/$P$17","v":{"$error":"#VALUE!"}}]
[null,40,{"$f":"IFERROR(IF(V55=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$84,1)),\"\")","v":""},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$85,B55,'Pacing Guide'!K$6:K$85)=0,\"\",SUMIF('Pacing Guide'!I$6:I$85,B55,'Pacing Guide'!K$6:K$85))","v":""},"",{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N55-E55),\"\")","v":""},null,{"$f":"C55*'Advanced Guide'!#REF!","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$10","v":{"$error":"#VALUE!"}},{"$f":"$G$11*Table3[[#This Row],[Sections Per Week]]","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$12","v":{"$error":"#VALUE!"}},{"$f":"Table3[[#This Row],[Sections Per Week]]*$G$9","v":{"$error":"#VALUE!"}},{"$f":"'Advanced Guide'!$C$13*Table3[[#This Row],[Sections Per Week]]","v":{"$error":"#VALUE!"}},{"$f":"IF(Table3[[#This Row],[Content Per Week]]=0,\"\",'Pacing Guide'!$A$32*'Advanced Guide'!$P$18)","v":0},null,null,null,null,null,null,null,{"$f":"Table3[[#This Row],[Content Per Week]]/$P$17","v":{"$error":"#VALUE!"}}]

{"sheet":"Weekly Guide","index":2,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":true,"merged":[[1,1,1,2]]}
[]
[null,"Step 7:  Refresh your Weekly Guide\nAny items and minute changes made in Steps 3 & 4 will re-adjust your weekly guide.  \n1 ) Click cell C3 (Weekly Guide) below. \n2) At the top of the ribbon, click Pivotable Analyze (see image at right)\n3) Click Refresh."]

{"sheet":"Sheet2","index":3,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[null,"Totals"]
["Total Minutes of resources:",{"$f":"GETPIVOTDATA(\"Time\",'Pacing Guide'!$K$5)","v":5759}]
["Weekly Minutes to cover content:",{"$f":"(GETPIVOTDATA(\"Time\",'Pacing Guide'!$K$5))/'Pacing Guide'!A23","v":319.94444444444446}]

{"sheet":"Changing times. ","index":4,"n_rows":96,"n_cols":17,"rows_kept":96,"cut":false,"hidden":true,"merged":[]}
["Chapter","Section","Time","Lectures","Live Projects","Practice Tests & MOS Cert","Your Own Projects","Videos","Skills","Challenge","Applied","Labs","Text","Exams"]
["Online Essentials","1.1: The Information Age",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":78},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,33,null,null,null,0,45,null,null,null,"Yes"]
["Online Essentials","1.2: The Internet and Social Media",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":91},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,26,20,null,null,null,45,null,null,null,"No"]
["Online Essentials","1.3: Digital Communication",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":63},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,18,20,null,null,null,25]
["Online Essentials","1.4: Online Safety and Security",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":133},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,38,70,null,null,null,25]
["Online Essentials","1.5: Evaluating Online Information",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":35},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,15,null,null,null,0,20]
["Online Essentials","1.6: Exam: Online Essentials",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":60},null,null,null,null,null,null,null,null,null,null,60]
["Computer Essentials","2.1: Computer Hardware",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":119},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,29,60,null,null,null,30]
["Computer Essentials","2.2: System Software",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":110},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,20,60,null,null,null,30]
["Computer Essentials","2.3: File Management",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":99},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,19,60,null,null,null,20]
["Computer Essentials","2.4: Application Software",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":62},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,7,40,null,null,null,15]
["Computer Essentials","2.5: Networking and User Accounts",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":78},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,18,40,null,null,null,20]
["Computer Essentials","2.6: Databases",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":47},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,17,20,null,null,null,10]
["Computer Essentials","2.7: Computer Programming",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":44},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,19,null,null,null,0,25]
["Computer Essentials","2.8: Information Systems",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":40},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,15,null,null,null,0,25]
["Computer Essentials","2.9: Exam: Computer Essentials",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":60},null,null,null,null,null,null,null,null,null,null,60]
["Common Office Features","3.1: Getting Started with Office",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":62},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,22,20,10,null,null,10,0]
["Common Office Features","3.2: Customizing Views and Options",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":42},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,7,20,10,null,null,5,0]
["Common Office Features","3.3: Printing Files",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":40},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,5,20,10,null,null,5,0]
["Common Office Features","3.4: Navigating Files",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":44},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,9,20,10,null,null,5,0]
["Common Office Features","3.5: Working with Objects",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":44},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,9,20,10,null,null,5,0]
["Word","4.01: Introduction to Word",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":8},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,3,null,null,null,0,5,0]
["Word","4.02: Creating Documents and Using the Clipboard",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":104},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,19,30,20,25,null,10,0]
["Word","4.03: Modifying Fonts",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":93},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,8,30,20,25,null,10,0]
["Word","4.04: Formatting Paragraphs",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":101},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,16,30,20,25,null,10,0]
["Word","4.05: Formatting Pages",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":94},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,9,30,20,25,null,10,0]
["Word","4.06: Editing Documents",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":95},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,10,30,20,25,null,10,0]
["Word","4.07: Inserting Illustrations and Other Elements",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":96},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,11,30,20,25,null,10,0]
["Word","4.08: Creating and Formatting Tables",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":97},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,12,30,20,25,null,10,0]
["Word","4.09: Using Themes, Styles, and Templates",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":96},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,11,30,20,25,null,10,0]
["Word","4.10: Managing References",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":100},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,15,30,20,25,null,10,0]
["Word","4.11: Managing Headers, Footers, and Sections",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":102},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,17,30,20,25,null,10,0]
["Word","4.12: Using Office Collaboration Features",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":98},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,13,30,20,25,null,10,0]
["Word","4.13: Using Macros",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":11},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,6,null,null,null,0,5,0]
["Word","4.14:  Office Pro Projects (Uses Live Application)",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":120},null,{"$f":"'Pacing Guide'!G8","v":120}]
["Word","4.15:  My Projects/Assignments",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":0},null,{"$f":"'Pacing Guide'!G9","v":0}]
["Word","4.16:  MOS Practice: Domain Questions",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":120},null,{"$f":"'Pacing Guide'!G10","v":120}]
["Word","4.17:  MOS Practice: Certification (A and B)  ",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":300},null,{"$f":"'Pacing Guide'!G11","v":300}]
["Word","4.18:  MOS Certification ",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":50},null,{"$f":"'Pacing Guide'!G12","v":50}]
["Word","4.19:  Office Pro Word Exam",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":60},null,{"$f":"'Pacing Guide'!G13","v":60}]
["Excel","5.01: Introduction to Excel",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":8},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,3,null,null,null,0,5,0]
["Excel","5.02: Creating and Managing Workbooks",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":95},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,10,30,20,25,null,10,0]
["Excel","5.03: Organizing and Entering Data",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":95},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,10,30,20,25,null,10,0]
["Excel","5.04: Changing Properties and Printing Worksheets",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":95},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,10,30,20,25,null,10,0]
["Excel","5.05: Formatting Cells",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":98},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,13,30,20,25,null,10,0]
["Excel","5.06: Entering Simple Formulas",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":115},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,15,40,25,25,null,10,0]
["Excel","5.07: Using Advanced Functions",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":133},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,18,50,30,25,null,10,0]
["Excel","5.08: Displaying Data in Charts",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":91},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,6,30,20,25,null,10,0]
["Excel","5.09: Organizing Data in Tables",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":93},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,8,30,20,25,null,10,0]
["Excel","5.10: Summarizing Complex Data",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":99},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,14,30,20,25,null,10,0]
["Excel","5.11:  Office Pro Projects (Uses Live Application)",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":120},null,{"$f":"'Pacing Guide'!G16","v":120}]
["Excel","5.12:  My Projects/Assignments",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":0},null,{"$f":"'Pacing Guide'!G17","v":0}]
["Excel","5.13:  MOS Practice: Domain Questions",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":120},null,{"$f":"'Pacing Guide'!G18","v":120}]
["Excel","5.14:  MOS Practice: Certification (A and B)  ",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":300},null,{"$f":"'Pacing Guide'!G19","v":300}]
["Excel","5.15:  MOS Certification ",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":50},null,{"$f":"'Pacing Guide'!G20","v":50}]
["Excel","5.16:  Office Pro Excel Exam",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":60},null,{"$f":"'Pacing Guide'!G21","v":60}]
["PowerPoint","6.01: Introduction to PowerPoint",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":12},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,7,null,null,null,0,5,0]
["PowerPoint","6.02: Creating and Managing Presentations",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":75},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,5,25,15,20,null,10,0]
["PowerPoint","6.03: Formatting Textual Content",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":81},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,11,25,15,20,null,10,0]
["PowerPoint","6.04: Designing Slides",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":76},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,6,25,15,20,null,10,0]
["PowerPoint","6.05: Using the Slide Master",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":77},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,7,25,15,20,null,10,0]
["PowerPoint","6.06: Formatting SmartArt and Shapes",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":77},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,7,25,15,20,null,10,0]
["PowerPoint","6.07: Formatting Tables and Charts",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":77},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,7,25,15,20,null,10,0]
["PowerPoint","6.08: Formatting Pictures and Other Media",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":79},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,9,25,15,20,null,10,0]
["PowerPoint","6.09: Applying Animations and Transitions",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":77},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,7,25,15,20,null,10,0]
["PowerPoint","6.10: Delivering Presentations",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":81},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,11,25,15,20,null,10,0]
["PowerPoint","6.11:  Office Pro Projects (Uses Live Application)",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":120},null,{"$f":"'Pacing Guide'!G24","v":120}]
["PowerPoint","6.12:  My Projects/Assignments",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":0},null,{"$f":"'Pacing Guide'!G25","v":0}]
["PowerPoint","6.13:  MOS Practice: Domain Questions",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":90},null,{"$f":"'Pacing Guide'!G26","v":90}]
["PowerPoint","6.14:  MOS Practice: Certification (A and B)  ",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":240},null,{"$f":"'Pacing Guide'!G27","v":240}]
["PowerPoint","6.15:  MOS Certification ",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":50},null,{"$f":"'Pacing Guide'!G28","v":50}]
["PowerPoint","6.16:  Office Pro PowerPoint Exam",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":60},null,{"$f":"'Pacing Guide'!G29","v":60}]
["Access","7.1: Introduction to Access",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":9},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,4,null,null,null,0,5,0]
["Access","7.2: Managing Databases",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":96},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,6,20,20,null,40,10,0]
["Access","7.3: Designing and Creating Tables",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":85},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,15,25,15,20,null,10,0]
["Access","7.4: Using Simple Queries",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":78},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,8,25,15,20,null,10,0]
["Access","7.5: Creating Forms",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":76},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,6,25,15,20,null,10,0]
["Access","7.6: Creating Reports",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":80},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,10,25,15,20,null,10,0]
["Access","7.7: Surveying Advanced Access Features",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":43},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,33,null,null,null,0,10,0]
["Access","7.8: Exam: Access",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":60},null,null,null,null,null,null,null,null,null,null,60]
["Outlook","8.1: Introduction to Outlook",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":11},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,6,null,null,null,0,5,0]
["Outlook","8.2: Sending and Receiving Messages",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":85},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,15,25,15,20,null,10,0]
["Outlook","8.3: Managing Messages",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":90},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,20,25,15,20,null,10,0]
["Outlook","8.4: Working with the Calendar",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":83},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,13,25,15,20,null,10,0]
["Outlook","8.5: Managing Contacts and Groups",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":82},{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,12,25,15,20,null,10,0]
["Outlook","8.6: Exam: Outlook",{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":60},null,null,null,null,null,null,null,null,null,null,60]
[null,null,{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":0}]
[null,null,{"$f":"SUM(DesktopProPlusV5[[#This Row],[Live Projects]:[Exams]])","v":0}]
[]
["Highest Score"]
["Test Score"]
["Average Score"]
["100% or 0"]
["Pass/Fall"]
["Participation"]
["No Grade"]

{"sheet":"TypicalWeeks","index":5,"n_rows":39,"n_cols":1,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
["Weeks"]
[1]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[16]
[17]
[18]
[19]
[20.100000000000001]
[21.214705882352899]
[22.329411764705799]
[23.4441176470588]
[24.558823529411701]
[25.673529411764701]
[26.788235294117602]
[27.902941176470499]
[29.017647058823499]
[30.1323529411764]
[31.2470588235294]
[32.361764705882301]
[33.476470588235301]
[34.591176470588202]
[35.705882352941103]
[36.820588235294103]
[37.935294117646997]
[39.049999999999997]
[40.164705882352898]
[41.279411764705799]
[42.394117647058799]
[43.5088235294117]