{"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":33,"n_cols":13,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,0,1,1],[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]]}
[]
[]
[]
[]
["Step 1: Choose Chapters                                           Chapters Use CTRL to select or deslect more than one chapter/section at a time",null,null,null,null,"Step 3: Optional Projects                                                                            Input or change minutes for Projects.  BY DEFAULT MINUTES FOR WORD PRO PROJECTS IS SHOWN AS 30 MINUTES TO COMPLETE EACH PROJECT.  \n              ",null,null,"Week to Cover ","Pacing Guide:                                              TestOut Pro Certified: Microsoft Word   ","Minutes per Section","Running Total"]
[null,null,null,null,null,null,null,null,1,"01.01: Word and the Microsoft Suite",5,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J6)),\"\",\nIF(ISBLANK($K6), \"\", SUM($K$6:K6)\n))\n)","v":5},135]
[null,null,null,null,null,"Word Pro Projects:  Requires Office to be Installed","Minutes",null,{"$f":"IFERROR(IF(K6=0,\"\",ROUNDDOWN(L6/Sheet2!$B$7,0)+1),\"\")","v":1},"01.02: Course Features",3,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J7)),\"\",\nIF(ISBLANK($K7), \"\", SUM($K$6:K7)\n))\n)","v":8}]
[null,null,null,null,null,null,30,null,{"$f":"IFERROR(IF(K7=0,\"\",ROUNDDOWN(L7/Sheet2!$B$7,0)+1),\"\")","v":1},"02.01: Getting Started with Office",18,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J8)),\"\",\nIF(ISBLANK($K8), \"\", SUM($K$6:K8)\n))\n)","v":26}]
[null,null,null,null,null,null,30,null,{"$f":"IFERROR(IF(K8=0,\"\",ROUNDDOWN(L8/Sheet2!$B$7,0)+1),\"\")","v":2},"02.02: Customizing Views and Options",7,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J9)),\"\",\nIF(ISBLANK($K9), \"\", SUM($K$6:K9)\n))\n)","v":33},0]
[null,null,null,null,null,null,30,null,{"$f":"IFERROR(IF(K9=0,\"\",ROUNDDOWN(L9/Sheet2!$B$7,0)+1),\"\")","v":2},"02.03: Printing Files",5,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J10)),\"\",\nIF(ISBLANK($K10), \"\", SUM($K$6:K10)\n))\n)","v":38},135]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K10=0,\"\",ROUNDDOWN(L10/Sheet2!$B$7,0)+1),\"\")","v":2},"02.04: Navigating Files",9,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J11)),\"\",\nIF(ISBLANK($K11), \"\", SUM($K$6:K11)\n))\n)","v":47},0]
[null,null,null,null,null,"My Projects and Assignments (Not part of Word Pro)","Minutes",null,{"$f":"IFERROR(IF(K11=0,\"\",ROUNDDOWN(L11/Sheet2!$B$7,0)+1),\"\")","v":2},"02.05: Working with Objects",12,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J12)),\"\",\nIF(ISBLANK($K12), \"\", SUM($K$6:K12)\n))\n)","v":59},60]
[null,null,null,null,null,null,0,null,{"$f":"IFERROR(IF(K12=0,\"\",ROUNDDOWN(L12/Sheet2!$B$7,0)+1),\"\")","v":3},"03.01: Creating Documents and Using the Clipboard",18,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J13)),\"\",\nIF(ISBLANK($K13), \"\", SUM($K$6:K13)\n))\n)","v":77}]
[null,null,null,null,null,null,0,null,{"$f":"IFERROR(IF(K13=0,\"\",ROUNDDOWN(L13/Sheet2!$B$7,0)+1),\"\")","v":4},"03.02: Modifying Fonts",8,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J14)),\"\",\nIF(ISBLANK($K14), \"\", SUM($K$6:K14)\n))\n)","v":85}]
[null,null,null,null,null,null,0,null,{"$f":"IFERROR(IF(K14=0,\"\",ROUNDDOWN(L14/Sheet2!$B$7,0)+1),\"\")","v":4},"03.03: Formatting Paragraphs",16,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J15)),\"\",\nIF(ISBLANK($K15), \"\", SUM($K$6:K15)\n))\n)","v":101}]
[null,null,null,null,null,null,0,null,{"$f":"IFERROR(IF(K15=0,\"\",ROUNDDOWN(L15/Sheet2!$B$7,0)+1),\"\")","v":5},"03.04: Editing Documents",10,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J16)),\"\",\nIF(ISBLANK($K16), \"\", SUM($K$6:K16)\n))\n)","v":111}]
[null,null,null,null,null,null,0,null,{"$f":"IFERROR(IF(K16=0,\"\",ROUNDDOWN(L16/Sheet2!$B$7,0)+1),\"\")","v":5},"04.01: Formatting Pages",8,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J17)),\"\",\nIF(ISBLANK($K17), \"\", SUM($K$6:K17)\n))\n)","v":119}]
[null,null,null,null,null,null,0,null,{"$f":"IFERROR(IF(K17=0,\"\",ROUNDDOWN(L17/Sheet2!$B$7,0)+1),\"\")","v":5},"04.02: Inserting Illustrations and Other Elements",13,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J18)),\"\",\nIF(ISBLANK($K18), \"\", SUM($K$6:K18)\n))\n)","v":132}]
[null,null,null,null,null,null,0,null,{"$f":"IFERROR(IF(K18=0,\"\",ROUNDDOWN(L18/Sheet2!$B$7,0)+1),\"\")","v":6},"04.03: Creating and Formatting Tables",11,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J19)),\"\",\nIF(ISBLANK($K19), \"\", SUM($K$6:K19)\n))\n)","v":143}]
["Step 2: Weeks\nInput number of weeks using Word Pro.                                                                           ",null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K19=0,\"\",ROUNDDOWN(L19/Sheet2!$B$7,0)+1),\"\")","v":6},"04.04: Using Themes, Styles, and Templates",11,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J20)),\"\",\nIF(ISBLANK($K20), \"\", SUM($K$6:K20)\n))\n)","v":154}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K20=0,\"\",ROUNDDOWN(L20/Sheet2!$B$7,0)+1),\"\")","v":7},"05.01: Managing References",12,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J21)),\"\",\nIF(ISBLANK($K21), \"\", SUM($K$6:K21)\n))\n)","v":166}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K21=0,\"\",ROUNDDOWN(L21/Sheet2!$B$7,0)+1),\"\")","v":7},"05.02: Managing Headers, Footers, and Sections",16,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J22)),\"\",\nIF(ISBLANK($K22), \"\", SUM($K$6:K22)\n))\n)","v":182}]
[12,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K22=0,\"\",ROUNDDOWN(L22/Sheet2!$B$7,0)+1),\"\")","v":8},"05.03: Using Office Collaboration Features",9,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J23)),\"\",\nIF(ISBLANK($K23), \"\", SUM($K$6:K23)\n))\n)","v":191}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K23=0,\"\",ROUNDDOWN(L23/Sheet2!$B$7,0)+1),\"\")","v":8},"06.01: Word Live Projects",4,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J24)),\"\",\nIF(ISBLANK($K24), \"\", SUM($K$6:K24)\n))\n)","v":195}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K24=0,\"\",ROUNDDOWN(L24/Sheet2!$B$7,0)+1),\"\")","v":8},"08.01: Using Custom Styles and Themes",17,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J25)),\"\",\nIF(ISBLANK($K25), \"\", SUM($K$6:K25)\n))\n)","v":212}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K25=0,\"\",ROUNDDOWN(L25/Sheet2!$B$7,0)+1),\"\")","v":9},"08.02: Using Charts",12,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J26)),\"\",\nIF(ISBLANK($K26), \"\", SUM($K$6:K26)\n))\n)","v":224}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K26=0,\"\",ROUNDDOWN(L26/Sheet2!$B$7,0)+1),\"\")","v":9},"09.01: Advanced Find and Replace",12,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J27)),\"\",\nIF(ISBLANK($K27), \"\", SUM($K$6:K27)\n))\n)","v":236}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K27=0,\"\",ROUNDDOWN(L27/Sheet2!$B$7,0)+1),\"\")","v":10},"09.02: Indexes and Captions",11,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J28)),\"\",\nIF(ISBLANK($K28), \"\", SUM($K$6:K28)\n))\n)","v":247}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K28=0,\"\",ROUNDDOWN(L28/Sheet2!$B$7,0)+1),\"\")","v":10},"09.03: Review and Protect Documents",19,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J29)),\"\",\nIF(ISBLANK($K29), \"\", SUM($K$6:K29)\n))\n)","v":266}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K29=0,\"\",ROUNDDOWN(L29/Sheet2!$B$7,0)+1),\"\")","v":11},"10.01: Forms and Fields",10,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J30)),\"\",\nIF(ISBLANK($K30), \"\", SUM($K$6:K30)\n))\n)","v":276}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K30=0,\"\",ROUNDDOWN(L30/Sheet2!$B$7,0)+1),\"\")","v":12},"10.02: Mail Merge",12,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J31)),\"\",\nIF(ISBLANK($K31), \"\", SUM($K$6:K31)\n))\n)","v":288}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K31=0,\"\",ROUNDDOWN(L31/Sheet2!$B$7,0)+1),\"\")","v":12},"10.03: Using Macros",11,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J32)),\"\",\nIF(ISBLANK($K32), \"\", SUM($K$6:K32)\n))\n)","v":299}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(K32=0,\"\",ROUNDDOWN(L32/Sheet2!$B$7,0)+1),\"\")","v":13},"Grand Total",299,{"$f":"(\nIF(ISNUMBER(SEARCH(\"Grand Total\",$J33)),\"\",\nIF(ISBLANK($K33), \"\", SUM($K$6:K33)\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$33,1)),\"\")","v":3},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$33,B16,'Pacing Guide'!K$6:K$33)=0,\"\",SUMIF('Pacing Guide'!I$6:I$33,B16,'Pacing Guide'!K$6:K$33))","v":26},{"$f":"IFERROR(D16+M16+I16+J16+K16+L16,\"\")","v":26},{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N16-E16),\"\")","v":-26},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":"00:26:00"},null,{"$f":"E16/1440","v":"00:26:00"},{"$f":"F16/1440","v":-1.8055555555555554E-2}]
[null,2,{"$f":"IFERROR(IF(V17=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$33,1)),\"\")","v":3},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$33,B17,'Pacing Guide'!K$6:K$33)=0,\"\",SUMIF('Pacing Guide'!I$6:I$33,B17,'Pacing Guide'!K$6:K$33))","v":33},33,{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N17-E17),\"\")","v":-33},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":"00:33:00"}]
[null,3,{"$f":"IFERROR(IF(V18=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$33,1)),\"\")","v":3},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$33,B18,'Pacing Guide'!K$6:K$33)=0,\"\",SUMIF('Pacing Guide'!I$6:I$33,B18,'Pacing Guide'!K$6:K$33))","v":18},18,{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N18-E18),\"\")","v":-18},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":"00:18:00"}]
[null,4,{"$f":"IFERROR(IF(V19=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$33,1)),\"\")","v":3},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$33,B19,'Pacing Guide'!K$6:K$33)=0,\"\",SUMIF('Pacing Guide'!I$6:I$33,B19,'Pacing Guide'!K$6:K$33))","v":24},24,{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N19-E19),\"\")","v":-24},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":"00:24:00"}]
[null,5,{"$f":"IFERROR(IF(V20=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$33,1)),\"\")","v":3},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$33,B20,'Pacing Guide'!K$6:K$33)=0,\"\",SUMIF('Pacing Guide'!I$6:I$33,B20,'Pacing Guide'!K$6:K$33))","v":31},31,{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N20-E20),\"\")","v":-31},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":"00:31:00"}]
[null,6,{"$f":"IFERROR(IF(V21=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$33,1)),\"\")","v":3},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$33,B21,'Pacing Guide'!K$6:K$33)=0,\"\",SUMIF('Pacing Guide'!I$6:I$33,B21,'Pacing Guide'!K$6:K$33))","v":22},22,{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N21-E21),\"\")","v":-22},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":"00:22:00"}]
[null,7,{"$f":"IFERROR(IF(V22=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$33,1)),\"\")","v":3},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$33,B22,'Pacing Guide'!K$6:K$33)=0,\"\",SUMIF('Pacing Guide'!I$6:I$33,B22,'Pacing Guide'!K$6:K$33))","v":28},28,{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N22-E22),\"\")","v":-28},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":"00:28:00"}]
[null,8,{"$f":"IFERROR(IF(V23=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$33,1)),\"\")","v":3},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$33,B23,'Pacing Guide'!K$6:K$33)=0,\"\",SUMIF('Pacing Guide'!I$6:I$33,B23,'Pacing Guide'!K$6:K$33))","v":30},30,{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N23-E23),\"\")","v":-30},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":"00:30:00"}]
[null,9,{"$f":"IFERROR(IF(V24=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$33,1)),\"\")","v":3},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$33,B24,'Pacing Guide'!K$6:K$33)=0,\"\",SUMIF('Pacing Guide'!I$6:I$33,B24,'Pacing Guide'!K$6:K$33))","v":24},24,{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N24-E24),\"\")","v":-24},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":"00:24:00"}]
[null,10,{"$f":"IFERROR(IF(V25=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$33,1)),\"\")","v":3},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$33,B25,'Pacing Guide'!K$6:K$33)=0,\"\",SUMIF('Pacing Guide'!I$6:I$33,B25,'Pacing Guide'!K$6:K$33))","v":30},30,{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N25-E25),\"\")","v":-30},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":"00:30:00"}]
[null,11,{"$f":"IFERROR(IF(V26=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$33,1)),\"\")","v":3},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$33,B26,'Pacing Guide'!K$6:K$33)=0,\"\",SUMIF('Pacing Guide'!I$6:I$33,B26,'Pacing Guide'!K$6:K$33))","v":10},10,{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N26-E26),\"\")","v":-10},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":"00:10:00"}]
[null,12,{"$f":"IFERROR(IF(V27=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$33,1)),\"\")","v":3},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$33,B27,'Pacing Guide'!K$6:K$33)=0,\"\",SUMIF('Pacing Guide'!I$6:I$33,B27,'Pacing Guide'!K$6:K$33))","v":23},23,{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N27-E27),\"\")","v":-23},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":"00:23:00"}]
[null,13,{"$f":"IFERROR(IF(V28=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$33,1)),\"\")","v":3},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$33,B28,'Pacing Guide'!K$6:K$33)=0,\"\",SUMIF('Pacing Guide'!I$6:I$33,B28,'Pacing Guide'!K$6:K$33))","v":299},299,{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N28-E28),\"\")","v":-299},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":"04:59:00"}]
[null,14,{"$f":"IFERROR(IF(V29=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$33,1)),\"\")","v":""},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$33,B29,'Pacing Guide'!K$6:K$33)=0,\"\",SUMIF('Pacing Guide'!I$6:I$33,B29,'Pacing Guide'!K$6:K$33))","v":""},"",{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N29-E29),\"\")","v":""},null,{"$f":"C29*'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,15,{"$f":"IFERROR(IF(V30=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$33,1)),\"\")","v":""},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$33,B30,'Pacing Guide'!K$6:K$33)=0,\"\",SUMIF('Pacing Guide'!I$6:I$33,B30,'Pacing Guide'!K$6:K$33))","v":""},"",{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N30-E30),\"\")","v":""},null,{"$f":"C30*'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,16,{"$f":"IFERROR(IF(V31=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$33,1)),\"\")","v":""},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$33,B31,'Pacing Guide'!K$6:K$33)=0,\"\",SUMIF('Pacing Guide'!I$6:I$33,B31,'Pacing Guide'!K$6:K$33))","v":""},"",{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N31-E31),\"\")","v":""},null,{"$f":"C31*'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,17,{"$f":"IFERROR(IF(V32=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$33,1)),\"\")","v":""},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$33,B32,'Pacing Guide'!K$6:K$33)=0,\"\",SUMIF('Pacing Guide'!I$6:I$33,B32,'Pacing Guide'!K$6:K$33))","v":""},"",{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N32-E32),\"\")","v":""},null,{"$f":"C32*'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,18,{"$f":"IFERROR(IF(V33=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$33,1)),\"\")","v":""},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$33,B33,'Pacing Guide'!K$6:K$33)=0,\"\",SUMIF('Pacing Guide'!I$6:I$33,B33,'Pacing Guide'!K$6:K$33))","v":""},"",{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N33-E33),\"\")","v":""},null,{"$f":"C33*'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,19,{"$f":"IFERROR(IF(V34=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$33,1)),\"\")","v":""},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$33,B34,'Pacing Guide'!K$6:K$33)=0,\"\",SUMIF('Pacing Guide'!I$6:I$33,B34,'Pacing Guide'!K$6:K$33))","v":""},{"$f":"IFERROR(D34+M34+I34+J34+K34+L34,\"\")","v":""},{"$f":"IFERROR(IF(Table3[[#This Row],[Class Activity Time]]=0,\"\",N34-E34),\"\")","v":""},null,{"$f":"C34*'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,20,{"$f":"IFERROR(IF(V35=0,\"\",COUNTIF('Pacing Guide'!$I$6:$I$33,1)),\"\")","v":""},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$33,B35,'Pacing Guide'!K$6:K$33)=0,\"\",SUMIF('Pacing Guide'!I$6:I$33,B35,'Pacing Guide'!K$6:K$33))","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$33,1)),\"\")","v":""},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$33,B36,'Pacing Guide'!K$6:K$33)=0,\"\",SUMIF('Pacing Guide'!I$6:I$33,B36,'Pacing Guide'!K$6:K$33))","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$33,1)),\"\")","v":""},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$33,B37,'Pacing Guide'!K$6:K$33)=0,\"\",SUMIF('Pacing Guide'!I$6:I$33,B37,'Pacing Guide'!K$6:K$33))","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$33,1)),\"\")","v":""},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$33,B38,'Pacing Guide'!K$6:K$33)=0,\"\",SUMIF('Pacing Guide'!I$6:I$33,B38,'Pacing Guide'!K$6:K$33))","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$33,1)),\"\")","v":""},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$33,B39,'Pacing Guide'!K$6:K$33)=0,\"\",SUMIF('Pacing Guide'!I$6:I$33,B39,'Pacing Guide'!K$6:K$33))","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$33,1)),\"\")","v":""},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$33,B40,'Pacing Guide'!K$6:K$33)=0,\"\",SUMIF('Pacing Guide'!I$6:I$33,B40,'Pacing Guide'!K$6:K$33))","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$33,1)),\"\")","v":""},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$33,B41,'Pacing Guide'!K$6:K$33)=0,\"\",SUMIF('Pacing Guide'!I$6:I$33,B41,'Pacing Guide'!K$6:K$33))","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$33,1)),\"\")","v":""},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$33,B42,'Pacing Guide'!K$6:K$33)=0,\"\",SUMIF('Pacing Guide'!I$6:I$33,B42,'Pacing Guide'!K$6:K$33))","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$33,1)),\"\")","v":""},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$33,B43,'Pacing Guide'!K$6:K$33)=0,\"\",SUMIF('Pacing Guide'!I$6:I$33,B43,'Pacing Guide'!K$6:K$33))","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$33,1)),\"\")","v":""},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$33,B44,'Pacing Guide'!K$6:K$33)=0,\"\",SUMIF('Pacing Guide'!I$6:I$33,B44,'Pacing Guide'!K$6:K$33))","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$33,1)),\"\")","v":""},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$33,B45,'Pacing Guide'!K$6:K$33)=0,\"\",SUMIF('Pacing Guide'!I$6:I$33,B45,'Pacing Guide'!K$6:K$33))","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$33,1)),\"\")","v":""},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$33,B46,'Pacing Guide'!K$6:K$33)=0,\"\",SUMIF('Pacing Guide'!I$6:I$33,B46,'Pacing Guide'!K$6:K$33))","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$33,1)),\"\")","v":""},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$33,B47,'Pacing Guide'!K$6:K$33)=0,\"\",SUMIF('Pacing Guide'!I$6:I$33,B47,'Pacing Guide'!K$6:K$33))","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$33,1)),\"\")","v":""},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$33,B48,'Pacing Guide'!K$6:K$33)=0,\"\",SUMIF('Pacing Guide'!I$6:I$33,B48,'Pacing Guide'!K$6:K$33))","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$33,1)),\"\")","v":""},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$33,B49,'Pacing Guide'!K$6:K$33)=0,\"\",SUMIF('Pacing Guide'!I$6:I$33,B49,'Pacing Guide'!K$6:K$33))","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$33,1)),\"\")","v":""},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$33,B50,'Pacing Guide'!K$6:K$33)=0,\"\",SUMIF('Pacing Guide'!I$6:I$33,B50,'Pacing Guide'!K$6:K$33))","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$33,1)),\"\")","v":""},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$33,B51,'Pacing Guide'!K$6:K$33)=0,\"\",SUMIF('Pacing Guide'!I$6:I$33,B51,'Pacing Guide'!K$6:K$33))","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$33,1)),\"\")","v":""},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$33,B52,'Pacing Guide'!K$6:K$33)=0,\"\",SUMIF('Pacing Guide'!I$6:I$33,B52,'Pacing Guide'!K$6:K$33))","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$33,1)),\"\")","v":""},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$33,B53,'Pacing Guide'!K$6:K$33)=0,\"\",SUMIF('Pacing Guide'!I$6:I$33,B53,'Pacing Guide'!K$6:K$33))","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$33,1)),\"\")","v":""},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$33,B54,'Pacing Guide'!K$6:K$33)=0,\"\",SUMIF('Pacing Guide'!I$6:I$33,B54,'Pacing Guide'!K$6:K$33))","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$33,1)),\"\")","v":""},{"$f":"IF(SUMIF('Pacing Guide'!I$6:I$33,B55,'Pacing Guide'!K$6:K$33)=0,\"\",SUMIF('Pacing Guide'!I$6:I$33,B55,'Pacing Guide'!K$6:K$33))","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":299}]
["Weekly Minutes to cover content:",{"$f":"(GETPIVOTDATA(\"Time\",'Pacing Guide'!$K$5))/'Pacing Guide'!A23","v":24.916666666666668}]

{"sheet":"Changing times. ","index":4,"n_rows":36,"n_cols":17,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Chapter","Section","Time","Lectures","Live Projects","Practice Tests & MOS Cert","Your Own Projects","Videos","Skills","Challenge","Applied","Labs","Text","Exams"]
["01.0: Course Overview","01.01: Word and the Microsoft Suite",5,{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,5,null,null,null,0,5,null,null,null,"Yes"]
["01.0: Course Overview","01.02: Course Features",3,{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,4,null,null,null,null,30,null,null,null,"No"]
["02.0: Common Office Features","02.01: Getting Started with Office",18,{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,21,null,null,null,24,10]
["02.0: Common Office Features","02.02: Customizing Views and Options",7,{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,7,null,null,null,24,5]
["02.0: Common Office Features","02.03: Printing Files",5,{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,5,null,null,null,24,5]
["02.0: Common Office Features","02.04: Navigating Files",9,null,null,null,null,9,null,null,null,24,5]
["02.0: Common Office Features","02.05: Working with Objects",12,null,0,null,null,9,null,null,null,24,5]
["03.0: Document and Text Basics","03.01: Creating Documents and Using the Clipboard",18,{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,13,null,null,null,24,10]
["03.0: Document and Text Basics","03.02: Modifying Fonts",8,{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,3,null,null,null,0,5,0]
["03.0: Document and Text Basics","03.03: Formatting Paragraphs",16,{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,10,25,15,20,null,10,0]
["03.0: Document and Text Basics","03.04: Editing Documents",10,{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,10,25,15,20,null,10,0]
["04.0: Document Formatting and Graphics","04.01: Formatting Pages",8,{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,10,25,15,20,null,10,0]
["04.0: Document Formatting and Graphics","04.02: Inserting Illustrations and Other Elements",13]
["04.0: Document Formatting and Graphics","04.03: Creating and Formatting Tables",11,{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,19,25,15,20,null,10,0]
["04.0: Document Formatting and Graphics","04.04: Using Themes, Styles, and Templates",11,{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,21,25,15,20,null,10,0]
["05.0: Academic and Workplace Features","05.01: Managing References",12,null,null,null,{"$f":"'Pacing Guide'!G14","v":0}]
["05.0: Academic and Workplace Features","05.02: Managing Headers, Footers, and Sections",16,{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,6,25,15,20,null,10,0]
["05.0: Academic and Workplace Features","05.03: Using Office Collaboration Features",9,{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,12,25,15,20,null,10,0]
["06.0: Word Associate Live Projects","06.01: Word Live Projects",4,null,null,null,{"$f":"'Pacing Guide'!G15","v":0}]
["08.0: Custom Styles","08.01: Using Custom Styles and Themes",17,{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,4,null,null,null,null,10,0]
["08.0: Custom Styles","08.02: Using Charts",12,null,{"$f":"'Pacing Guide'!G8","v":30}]
["09.0: Advanced Editing and References","09.01: Advanced Find and Replace",12,null,{"$f":"'Pacing Guide'!G9","v":30}]
["09.0: Advanced Editing and References","09.02: Indexes and Captions",11,null,{"$f":"'Pacing Guide'!G10","v":30}]
["09.0: Advanced Editing and References","09.03: Review and Protect Documents",19,{"$f":"'Advanced Guide'!$C$13","v":0},null,null,null,18,null,null,null,null,10,0]
["10.0: Automatic Document Contents","10.01: Forms and Fields",10,null,null,90]
["10.0: Automatic Document Contents","10.02: Mail Merge",12,null,null,240]
["10.0: Automatic Document Contents","10.03: Using Macros",11,null,null,null,null,8,30,20,25,null,10]
[]
["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]