{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Course Competency Tool","INPUT TAB","Competency Alignment","Competency Definitions"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":9,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Course Competency Tool","index":0,"n_rows":62,"n_cols":34,"rows_kept":62,"cut":false,"hidden":false,"merged":[[61,12,61,13],[52,12,52,13],[53,12,53,13],[54,12,54,13],[55,12,55,13],[56,12,56,13],[58,12,58,13],[59,12,59,13],[57,12,57,13],[30,12,30,13],[32,12,32,13],[33,12,33,13],[34,12,34,13],[35,12,35,13],[49,12,49,13],[50,12,50,13],[51,12,51,13],[60,12,60,13],[47,12,47,13],[48,12,48,13],[37,12,37,13],[38,12,38,13],[39,12,39,13],[40,12,40,13],[41,12,41,13],[42,12,42,13],[43,12,43,13],[44,12,44,13],[45,12,45,13],[46,12,46,13],[1,8,1,19],[3,8,4,8],[3,15,3,19],[6,14,6,19],[7,14,7,19],[9,14,9,19],[10,14,10,19],[6,8,6,12],[7,8,7,12],[9,8,9,12],[10,8,10,12],[3,9,4,12],[3,13,4,14],[14,8,14,19],[19,14,19,19],[18,12,18,19],[61,14,61,19],[60,14,60,19],[59,14,59,19],[58,14,58,19],[57,14,57,19],[56,14,56,19],[55,14,55,19],[54,14,54,19],[53,14,53,19],[52,14,52,19],[51,14,51,19],[50,14,50,19],[18,8,18,10],[21,8,21,10],[19,12,19,13],[20,9,20,10],[36,12,36,13],[22,12,22,13],[22,8,33,10],[31,12,31,13],[23,12,23,13],[44,14,44,19],[43,14,43,19],[42,14,42,19],[41,14,41,19],[40,14,40,19],[49,14,49,19],[48,14,48,19],[47,14,47,19],[46,14,46,19],[45,14,45,19],[34,14,34,19],[33,14,33,19],[32,14,32,19],[31,14,31,19],[30,14,30,19],[39,14,39,19],[38,14,38,19],[37,14,37,19],[36,14,36,19],[35,14,35,19],[24,14,24,19],[23,14,23,19],[22,14,22,19],[21,14,21,19],[20,14,20,19],[19,9,19,10],[20,12,20,13],[21,12,21,13],[29,14,29,19],[28,14,28,19],[27,14,27,19],[26,14,26,19],[25,14,25,19],[24,12,24,13],[25,12,25,13],[26,12,26,13],[27,12,27,13],[28,12,28,13],[29,12,29,13]]}
[]
[null,null,null,null,null,null,null,null,"VAAA CPS COURSE COMPETENCY TOOL\nVersion #5"]
[]
[null,null,null,null,null,null,null,null,"1. Order of Selection: \nFollow STEP #1 through STEP #4, by making your selection from the applicable drop down list. The darkest blue box directs you to the next choice you can make.","2. Effect of Choices: \nThe \"Competency Information\" and \"Courses\" sections will update based on the input provided.",null,null,null,"3. Updating the Tool (Optional):\nAs horizonatal scrolling has been disabled, use the \"Zoom In\" or \"Zoom Out\" buttons, as applicable, to see all aspects of the tool. The tool can be continuously updated with new inputs, as you work through it (resetting is not required). However, if you would like to start a completely new search, click the \"RESET TOOL\" button at the top right side of the tool.\n**PLEASE NOTE: Courses taught virtually are highlighted in green, with bold font.",null,"E-mail Comments/Questions:"]
[]
[]
[null,null,null,null,null,null,null,null,"STEP #1: Competency Type",null,null,null,null,null,"STEP #2: Competency"]
[null,null,null,null,null,null,null,null,{"$f":"'INPUT TAB'!A2","v":"(Select Competency Type)"},null,null,null,null,null,{"$f":"'INPUT TAB'!C2","v":"(Select Competency Type)"}]
[]
[null,null,null,null,null,null,null,null,"STEP #3: Program",null,null,null,null,null,"STEP #4: Level"]
[null,null,null,null,null,null,null,null,{"$f":"'INPUT TAB'!F2","v":"(Select Competency Type)"},null,null,null,null,null,{"$f":"'INPUT TAB'!I2","v":"(Select Competency Type)"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(I8='INPUT TAB'!A2,'Course Competency Tool'!O8='INPUT TAB'!C2,'Course Competency Tool'!O8='INPUT TAB'!D2,'Course Competency Tool'!O8='INPUT TAB'!A2,'Course Competency Tool'!I11='INPUT TAB'!A2,'Course Competency Tool'!I11='INPUT TAB'!C2,'Course Competency Tool'!I11='INPUT TAB'!D2,'Course Competency Tool'!I11='INPUT TAB'!F2,'Course Competency Tool'!I11='INPUT TAB'!G2,'Course Competency Tool'!O11='INPUT TAB'!A2,'Course Competency Tool'!O11='INPUT TAB'!C2,'Course Competency Tool'!O11='INPUT TAB'!D2,'Course Competency Tool'!O11='INPUT TAB'!F2,'Course Competency Tool'!O11='INPUT TAB'!G2,'Course Competency Tool'!O11='INPUT TAB'!I2,'Course Competency Tool'!O11='INPUT TAB'!J2),\"\",IF(I8='INPUT TAB'!A4,IF(AND(IFERROR(VLOOKUP('Course Competency Tool'!O11,'INPUT TAB'!J:L,2,FALSE),0)=2,IFERROR(VLOOKUP('Course Competency Tool'!I11,'INPUT TAB'!G:H,2,FALSE),0)=2,IFERROR(VLOOKUP('Course Competency Tool'!O8,'INPUT TAB'!D:E,2,FALSE),0)=2),CONCATENATE(O8,I11),\"\"),IF(AND(IFERROR(VLOOKUP('Course Competency Tool'!O11,'INPUT TAB'!I:L,3,FALSE),0)=2,IFERROR(VLOOKUP('Course Competency Tool'!I11,'INPUT TAB'!F:H,3,FALSE),0)=2,IFERROR(VLOOKUP('Course Competency Tool'!O8,'INPUT TAB'!C:E,3,FALSE),0)=2),CONCATENATE(O8,I11),\"\")))","v":""},{"$f":"'INPUT TAB'!F2","v":"(Select Competency Type)"}]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"'INPUT TAB'!F2","v":"(Select Competency Type)"}]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Competency Information",null,null,null,"Courses"]
[null,null,null,null,null,null,null,null,{"$f":"IF(I23=\"\",'INPUT TAB'!A26,\"FAR References:\")","v":"Please review Step #1 through Step #4.\u0001\u0001\u0001"},{"$f":"IF(OR($I$8=\"\",$O$8=\"\",O20='INPUT TAB'!A25),'INPUT TAB'!A27,IFERROR(VLOOKUP($O$8,Competency_Definitions,4,FALSE),\"\"))","v":"\u0001\u0001\u0001\u0001\u0001\u0001\u0001\u0001\u0001\u0001\u0001\u0001\u0001\u0001\u0001\u0001\u0001\u0001\u0001\u0001\u0001\u0001\u0001"},null,null,{"$f":"IF(OR(O20='INPUT TAB'!A25,O20=\"TBD\"),\"\",CONCATENATE(B21,C21))","v":""},null,{"$f":"IF(OR($I$8=\"\",$O$8=\"\"),'INPUT TAB'!$A$25,IFERROR(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O20)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0))&\" - \"&VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O20)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)&IF(VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O20)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)=1,\" CLP\",\" CLPs\"),'INPUT TAB'!$A$25))","v":"Check inputs for Step #1 through Step #4."}]
[{"$f":"IF(AH21=\"\",\"\",CONCATENATE($O$8,$I$11,$O$11,AH21))","v":"(Select Competency Type)(Select Competency Type)(Select Competency Type)Check Inputs"},{"$f":"IF(O20=\"\",\"\",1+B20)","v":1},{"$f":"IF(O20=\"\",\"\",\".\")","v":"."},null,null,null,null,null,{"$f":"IF(I23=\"\",\"\",\"Unit of Competence:\")","v":""},{"$f":"IF(OR($I$8=\"\",$O$8=\"\",O20='INPUT TAB'!A25),\"\",IFERROR(VLOOKUP($O$8,Competency_Definitions,3,FALSE),\"\"))","v":""},null,null,{"$f":"IF(OR(O21=\"Check Inputs\",O21=\"TBD\"),\"\",CONCATENATE(B22,C22))","v":""},null,{"$f":"IF(OR($I$8=\"\",$O$8=\"\"),\"\",IFERROR(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O21)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0))&\" - \"&VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O21)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)&IF(VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O21)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)=1,\" CLP\",\" CLPs\"),\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF($I$8='INPUT TAB'!$A$3,IF(COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11)<(ROW()-8),\"\",VLOOKUP(#REF!,OFFSET(#REF!,VLOOKUP('Course Competency Tool'!#REF!,#REF!,33,FALSE)+IF((ROW()-9)<=COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11),(ROW()-9),0),0,COUNTIF(#REF!,'Course Competency Tool'!$O$8),6),5,FALSE)),IF(COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11)<(ROW()-8),\"\",VLOOKUP(#REF!,OFFSET(#REF!,VLOOKUP('Course Competency Tool'!#REF!,#REF!,33,FALSE)+IF((ROW()-9)<=COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11),(ROW()-9),0),0,COUNTIF(#REF!,'Course Competency Tool'!$O$8),6),5,FALSE))),\"Check Inputs\")","v":"Check Inputs"}]
["(Select Competency Type)(Select Competency Type)(Select Competency Type)Check Inputs","","",null,null,null,null,null,{"$f":"IF(OR($I$8=\"\",$O$8=\"\",O20='INPUT TAB'!A25),\"\",IF(I23=\"\",'INPUT TAB'!A24,\"Competency Description:\"))","v":""},null,null,null,"",null,{"$f":"IF(OR($I$8=\"\",$O$8=\"\"),\"\",IFERROR(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O22)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0))&\" - \"&VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O22)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)&IF(VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O22)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)=1,\" CLP\",\" CLPs\"),\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF($I$8='INPUT TAB'!$A$3,IF(COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11)<(ROW()-8),\"\",VLOOKUP(#REF!,OFFSET(#REF!,VLOOKUP('Course Competency Tool'!#REF!,#REF!,33,FALSE)+IF((ROW()-9)<=COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11),(ROW()-9),0),0,COUNTIF(#REF!,'Course Competency Tool'!$O$8),6),5,FALSE)),IF(COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11)<(ROW()-8),\"\",VLOOKUP(#REF!,OFFSET(#REF!,VLOOKUP('Course Competency Tool'!#REF!,#REF!,33,FALSE)+IF((ROW()-9)<=COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11),(ROW()-9),0),0,COUNTIF(#REF!,'Course Competency Tool'!$O$8),6),5,FALSE))),\"Check Inputs\")","v":"Check Inputs"}]
["(Select Competency Type)(Select Competency Type)(Select Competency Type)Check Inputs","","",null,null,null,null,null,{"$f":"IF(OR($I$8=\"\",$O$8=\"\",O20='INPUT TAB'!A25),\"\",IFERROR(VLOOKUP($O$8,Competency_Definitions,2,FALSE),\"\"))","v":""},null,null,null,"",null,{"$f":"IF(OR($I$8=\"\",$O$8=\"\"),\"\",IFERROR(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O23)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0))&\" - \"&VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O23)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)&IF(VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O23)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)=1,\" CLP\",\" CLPs\"),\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF($I$8='INPUT TAB'!$A$3,IF(COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11)<(ROW()-8),\"\",VLOOKUP(#REF!,OFFSET(#REF!,VLOOKUP('Course Competency Tool'!#REF!,#REF!,33,FALSE)+IF((ROW()-9)<=COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11),(ROW()-9),0),0,COUNTIF(#REF!,'Course Competency Tool'!$O$8),6),5,FALSE)),IF(COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11)<(ROW()-8),\"\",VLOOKUP(#REF!,OFFSET(#REF!,VLOOKUP('Course Competency Tool'!#REF!,#REF!,33,FALSE)+IF((ROW()-9)<=COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11),(ROW()-9),0),0,COUNTIF(#REF!,'Course Competency Tool'!$O$8),6),5,FALSE))),\"Check Inputs\")","v":"Check Inputs"}]
["(Select Competency Type)(Select Competency Type)(Select Competency Type)Check Inputs","","",null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(OR($I$8=\"\",$O$8=\"\"),\"\",IFERROR(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O24)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0))&\" - \"&VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O24)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)&IF(VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O24)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)=1,\" CLP\",\" CLPs\"),\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF($I$8='INPUT TAB'!$A$3,IF(COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11)<(ROW()-8),\"\",VLOOKUP(#REF!,OFFSET(#REF!,VLOOKUP('Course Competency Tool'!#REF!,#REF!,33,FALSE)+IF((ROW()-9)<=COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11),(ROW()-9),0),0,COUNTIF(#REF!,'Course Competency Tool'!$O$8),6),5,FALSE)),IF(COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11)<(ROW()-8),\"\",VLOOKUP(#REF!,OFFSET(#REF!,VLOOKUP('Course Competency Tool'!#REF!,#REF!,33,FALSE)+IF((ROW()-9)<=COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11),(ROW()-9),0),0,COUNTIF(#REF!,'Course Competency Tool'!$O$8),6),5,FALSE))),\"Check Inputs\")","v":"Check Inputs"}]
["(Select Competency Type)(Select Competency Type)(Select Competency Type)Check Inputs","","",null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(OR($I$8=\"\",$O$8=\"\"),\"\",IFERROR(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O25)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0))&\" - \"&VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O25)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)&IF(VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O25)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)=1,\" CLP\",\" CLPs\"),\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF($I$8='INPUT TAB'!$A$3,IF(COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11)<(ROW()-8),\"\",VLOOKUP(#REF!,OFFSET(#REF!,VLOOKUP('Course Competency Tool'!#REF!,#REF!,33,FALSE)+IF((ROW()-9)<=COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11),(ROW()-9),0),0,COUNTIF(#REF!,'Course Competency Tool'!$O$8),6),5,FALSE)),IF(COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11)<(ROW()-8),\"\",VLOOKUP(#REF!,OFFSET(#REF!,VLOOKUP('Course Competency Tool'!#REF!,#REF!,33,FALSE)+IF((ROW()-9)<=COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11),(ROW()-9),0),0,COUNTIF(#REF!,'Course Competency Tool'!$O$8),6),5,FALSE))),\"Check Inputs\")","v":"Check Inputs"}]
["(Select Competency Type)(Select Competency Type)(Select Competency Type)Check Inputs","","",null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(OR($I$8=\"\",$O$8=\"\"),\"\",IFERROR(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O26)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0))&\" - \"&VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O26)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)&IF(VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O26)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)=1,\" CLP\",\" CLPs\"),\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF($I$8='INPUT TAB'!$A$3,IF(COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11)<(ROW()-8),\"\",VLOOKUP(#REF!,OFFSET(#REF!,VLOOKUP('Course Competency Tool'!#REF!,#REF!,33,FALSE)+IF((ROW()-9)<=COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11),(ROW()-9),0),0,COUNTIF(#REF!,'Course Competency Tool'!$O$8),6),5,FALSE)),IF(COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11)<(ROW()-8),\"\",VLOOKUP(#REF!,OFFSET(#REF!,VLOOKUP('Course Competency Tool'!#REF!,#REF!,33,FALSE)+IF((ROW()-9)<=COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11),(ROW()-9),0),0,COUNTIF(#REF!,'Course Competency Tool'!$O$8),6),5,FALSE))),\"Check Inputs\")","v":"Check Inputs"}]
["(Select Competency Type)(Select Competency Type)(Select Competency Type)Check Inputs","","",null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(OR($I$8=\"\",$O$8=\"\"),\"\",IFERROR(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O27)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0))&\" - \"&VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O27)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)&IF(VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O27)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)=1,\" CLP\",\" CLPs\"),\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF($I$8='INPUT TAB'!$A$3,IF(COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11)<(ROW()-8),\"\",VLOOKUP(#REF!,OFFSET(#REF!,VLOOKUP('Course Competency Tool'!#REF!,#REF!,33,FALSE)+IF((ROW()-9)<=COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11),(ROW()-9),0),0,COUNTIF(#REF!,'Course Competency Tool'!$O$8),6),5,FALSE)),IF(COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11)<(ROW()-8),\"\",VLOOKUP(#REF!,OFFSET(#REF!,VLOOKUP('Course Competency Tool'!#REF!,#REF!,33,FALSE)+IF((ROW()-9)<=COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11),(ROW()-9),0),0,COUNTIF(#REF!,'Course Competency Tool'!$O$8),6),5,FALSE))),\"Check Inputs\")","v":"Check Inputs"}]
["(Select Competency Type)(Select Competency Type)(Select Competency Type)Check Inputs","","",null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(OR($I$8=\"\",$O$8=\"\"),\"\",IFERROR(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O28)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0))&\" - \"&VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O28)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)&IF(VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O28)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)=1,\" CLP\",\" CLPs\"),\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF($I$8='INPUT TAB'!$A$3,IF(COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11)<(ROW()-8),\"\",VLOOKUP(#REF!,OFFSET(#REF!,VLOOKUP('Course Competency Tool'!#REF!,#REF!,33,FALSE)+IF((ROW()-9)<=COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11),(ROW()-9),0),0,COUNTIF(#REF!,'Course Competency Tool'!$O$8),6),5,FALSE)),IF(COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11)<(ROW()-8),\"\",VLOOKUP(#REF!,OFFSET(#REF!,VLOOKUP('Course Competency Tool'!#REF!,#REF!,33,FALSE)+IF((ROW()-9)<=COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11),(ROW()-9),0),0,COUNTIF(#REF!,'Course Competency Tool'!$O$8),6),5,FALSE))),\"Check Inputs\")","v":"Check Inputs"}]
["(Select Competency Type)(Select Competency Type)(Select Competency Type)Check Inputs","","",null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(OR($I$8=\"\",$O$8=\"\"),\"\",IFERROR(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O29)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0))&\" - \"&VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O29)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)&IF(VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O29)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)=1,\" CLP\",\" CLPs\"),\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF($I$8='INPUT TAB'!$A$3,IF(COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11)<(ROW()-8),\"\",VLOOKUP(#REF!,OFFSET(#REF!,VLOOKUP('Course Competency Tool'!#REF!,#REF!,33,FALSE)+IF((ROW()-9)<=COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11),(ROW()-9),0),0,COUNTIF(#REF!,'Course Competency Tool'!$O$8),6),5,FALSE)),IF(COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11)<(ROW()-8),\"\",VLOOKUP(#REF!,OFFSET(#REF!,VLOOKUP('Course Competency Tool'!#REF!,#REF!,33,FALSE)+IF((ROW()-9)<=COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11),(ROW()-9),0),0,COUNTIF(#REF!,'Course Competency Tool'!$O$8),6),5,FALSE))),\"Check Inputs\")","v":"Check Inputs"}]
["(Select Competency Type)(Select Competency Type)(Select Competency Type)Check Inputs","","",null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(OR($I$8=\"\",$O$8=\"\"),\"\",IFERROR(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O30)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0))&\" - \"&VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O30)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)&IF(VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O30)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)=1,\" CLP\",\" CLPs\"),\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF($I$8='INPUT TAB'!$A$3,IF(COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11)<(ROW()-8),\"\",VLOOKUP(#REF!,OFFSET(#REF!,VLOOKUP('Course Competency Tool'!#REF!,#REF!,33,FALSE)+IF((ROW()-9)<=COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11),(ROW()-9),0),0,COUNTIF(#REF!,'Course Competency Tool'!$O$8),6),5,FALSE)),IF(COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11)<(ROW()-8),\"\",VLOOKUP(#REF!,OFFSET(#REF!,VLOOKUP('Course Competency Tool'!#REF!,#REF!,33,FALSE)+IF((ROW()-9)<=COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11),(ROW()-9),0),0,COUNTIF(#REF!,'Course Competency Tool'!$O$8),6),5,FALSE))),\"Check Inputs\")","v":"Check Inputs"}]
["(Select Competency Type)(Select Competency Type)(Select Competency Type)Check Inputs","","",null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(OR($I$8=\"\",$O$8=\"\"),\"\",IFERROR(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O31)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0))&\" - \"&VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O31)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)&IF(VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O31)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)=1,\" CLP\",\" CLPs\"),\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF($I$8='INPUT TAB'!$A$3,IF(COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11)<(ROW()-8),\"\",VLOOKUP(#REF!,OFFSET(#REF!,VLOOKUP('Course Competency Tool'!#REF!,#REF!,33,FALSE)+IF((ROW()-9)<=COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11),(ROW()-9),0),0,COUNTIF(#REF!,'Course Competency Tool'!$O$8),6),5,FALSE)),IF(COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11)<(ROW()-8),\"\",VLOOKUP(#REF!,OFFSET(#REF!,VLOOKUP('Course Competency Tool'!#REF!,#REF!,33,FALSE)+IF((ROW()-9)<=COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11),(ROW()-9),0),0,COUNTIF(#REF!,'Course Competency Tool'!$O$8),6),5,FALSE))),\"Check Inputs\")","v":"Check Inputs"}]
["(Select Competency Type)(Select Competency Type)(Select Competency Type)Check Inputs","","",null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(OR($I$8=\"\",$O$8=\"\"),\"\",IFERROR(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O32)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0))&\" - \"&VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O32)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)&IF(VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O32)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)=1,\" CLP\",\" CLPs\"),\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF($I$8='INPUT TAB'!$A$3,IF(COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11)<(ROW()-8),\"\",VLOOKUP(#REF!,OFFSET(#REF!,VLOOKUP('Course Competency Tool'!#REF!,#REF!,33,FALSE)+IF((ROW()-9)<=COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11),(ROW()-9),0),0,COUNTIF(#REF!,'Course Competency Tool'!$O$8),6),5,FALSE)),IF(COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11)<(ROW()-8),\"\",VLOOKUP(#REF!,OFFSET(#REF!,VLOOKUP('Course Competency Tool'!#REF!,#REF!,33,FALSE)+IF((ROW()-9)<=COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11),(ROW()-9),0),0,COUNTIF(#REF!,'Course Competency Tool'!$O$8),6),5,FALSE))),\"Check Inputs\")","v":"Check Inputs"}]
["(Select Competency Type)(Select Competency Type)(Select Competency Type)Check Inputs","","",null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(OR($I$8=\"\",$O$8=\"\"),\"\",IFERROR(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O33)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0))&\" - \"&VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O33)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)&IF(VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O33)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)=1,\" CLP\",\" CLPs\"),\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF($I$8='INPUT TAB'!$A$3,IF(COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11)<(ROW()-8),\"\",VLOOKUP(#REF!,OFFSET(#REF!,VLOOKUP('Course Competency Tool'!#REF!,#REF!,33,FALSE)+IF((ROW()-9)<=COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11),(ROW()-9),0),0,COUNTIF(#REF!,'Course Competency Tool'!$O$8),6),5,FALSE)),IF(COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11)<(ROW()-8),\"\",VLOOKUP(#REF!,OFFSET(#REF!,VLOOKUP('Course Competency Tool'!#REF!,#REF!,33,FALSE)+IF((ROW()-9)<=COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11),(ROW()-9),0),0,COUNTIF(#REF!,'Course Competency Tool'!$O$8),6),5,FALSE))),\"Check Inputs\")","v":"Check Inputs"}]
["(Select Competency Type)(Select Competency Type)(Select Competency Type)Check Inputs","","",null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(OR($I$8=\"\",$O$8=\"\"),\"\",IFERROR(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O34)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0))&\" - \"&VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O34)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)&IF(VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O34)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)=1,\" CLP\",\" CLPs\"),\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF($I$8='INPUT TAB'!$A$3,IF(COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11)<(ROW()-8),\"\",VLOOKUP(#REF!,OFFSET(#REF!,VLOOKUP('Course Competency Tool'!#REF!,#REF!,33,FALSE)+IF((ROW()-9)<=COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11),(ROW()-9),0),0,COUNTIF(#REF!,'Course Competency Tool'!$O$8),6),5,FALSE)),IF(COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11)<(ROW()-8),\"\",VLOOKUP(#REF!,OFFSET(#REF!,VLOOKUP('Course Competency Tool'!#REF!,#REF!,33,FALSE)+IF((ROW()-9)<=COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11),(ROW()-9),0),0,COUNTIF(#REF!,'Course Competency Tool'!$O$8),6),5,FALSE))),\"Check Inputs\")","v":"Check Inputs"}]
["(Select Competency Type)(Select Competency Type)(Select Competency Type)Check Inputs","","",null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(OR($I$8=\"\",$O$8=\"\"),\"\",IFERROR(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O35)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0))&\" - \"&VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O35)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)&IF(VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O35)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)=1,\" CLP\",\" CLPs\"),\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF($I$8='INPUT TAB'!$A$3,IF(COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11)<(ROW()-8),\"\",VLOOKUP(#REF!,OFFSET(#REF!,VLOOKUP('Course Competency Tool'!#REF!,#REF!,33,FALSE)+IF((ROW()-9)<=COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11),(ROW()-9),0),0,COUNTIF(#REF!,'Course Competency Tool'!$O$8),6),5,FALSE)),IF(COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11)<(ROW()-8),\"\",VLOOKUP(#REF!,OFFSET(#REF!,VLOOKUP('Course Competency Tool'!#REF!,#REF!,33,FALSE)+IF((ROW()-9)<=COUNTIFS(#REF!,'Course Competency Tool'!$O$8,#REF!,'Course Competency Tool'!$I$11,#REF!,'Course Competency Tool'!$O$11),(ROW()-9),0),0,COUNTIF(#REF!,'Course Competency Tool'!$O$8),6),5,FALSE))),\"Check Inputs\")","v":"Check Inputs"}]
["","","",null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(OR($I$8=\"\",$O$8=\"\"),\"\",IFERROR(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O36)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0))&\" - \"&VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O36)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)&IF(VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O36)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)=1,\" CLP\",\" CLPs\"),\"\"))","v":""}]
["","","",null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(OR($I$8=\"\",$O$8=\"\"),\"\",IFERROR(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O37)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0))&\" - \"&VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O37)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)&IF(VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O37)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)=1,\" CLP\",\" CLPs\"),\"\"))","v":""}]
["","","",null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(OR($I$8=\"\",$O$8=\"\"),\"\",IFERROR(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O38)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0))&\" - \"&VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O38)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)&IF(VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O38)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)=1,\" CLP\",\" CLPs\"),\"\"))","v":""}]
["","","",null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(OR($I$8=\"\",$O$8=\"\"),\"\",IFERROR(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O39)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0))&\" - \"&VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O39)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)&IF(VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O39)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)=1,\" CLP\",\" CLPs\"),\"\"))","v":""}]
["","","",null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(OR($I$8=\"\",$O$8=\"\"),\"\",IFERROR(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O40)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0))&\" - \"&VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O40)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)&IF(VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O40)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)=1,\" CLP\",\" CLPs\"),\"\"))","v":""}]
["","","",null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(OR($I$8=\"\",$O$8=\"\"),\"\",IFERROR(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O41)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0))&\" - \"&VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O41)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)&IF(VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O41)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)=1,\" CLP\",\" CLPs\"),\"\"))","v":""}]
["","","",null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(OR($I$8=\"\",$O$8=\"\"),\"\",IFERROR(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O42)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0))&\" - \"&VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O42)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)&IF(VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O42)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)=1,\" CLP\",\" CLPs\"),\"\"))","v":""}]
["","","",null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(OR($I$8=\"\",$O$8=\"\"),\"\",IFERROR(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O43)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0))&\" - \"&VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O43)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)&IF(VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O43)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)=1,\" CLP\",\" CLPs\"),\"\"))","v":""}]
["","","",null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(OR($I$8=\"\",$O$8=\"\"),\"\",IFERROR(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O44)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0))&\" - \"&VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O44)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)&IF(VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O44)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)=1,\" CLP\",\" CLPs\"),\"\"))","v":""}]
["","","",null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(OR($I$8=\"\",$O$8=\"\"),\"\",IFERROR(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O45)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0))&\" - \"&VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O45)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)&IF(VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O45)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)=1,\" CLP\",\" CLPs\"),\"\"))","v":""}]
["","","",null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(OR($I$8=\"\",$O$8=\"\"),\"\",IFERROR(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O46)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0))&\" - \"&VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O46)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)&IF(VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O46)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)=1,\" CLP\",\" CLPs\"),\"\"))","v":""}]
["","","",null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(OR($I$8=\"\",$O$8=\"\"),\"\",IFERROR(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O47)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0))&\" - \"&VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O47)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)&IF(VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O47)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)=1,\" CLP\",\" CLPs\"),\"\"))","v":""}]
["","","",null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(OR($I$8=\"\",$O$8=\"\"),\"\",IFERROR(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O48)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0))&\" - \"&VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O48)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)&IF(VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O48)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)=1,\" CLP\",\" CLPs\"),\"\"))","v":""}]
["","","",null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(OR($I$8=\"\",$O$8=\"\"),\"\",IFERROR(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O49)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0))&\" - \"&VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O49)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)&IF(VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O49)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)=1,\" CLP\",\" CLPs\"),\"\"))","v":""}]
["","","",null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(OR($I$8=\"\",$O$8=\"\"),\"\",IFERROR(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O50)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0))&\" - \"&VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O50)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)&IF(VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O50)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)=1,\" CLP\",\" CLPs\"),\"\"))","v":""}]
["","","",null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(OR($I$8=\"\",$O$8=\"\"),\"\",IFERROR(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O51)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0))&\" - \"&VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O51)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)&IF(VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O51)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)=1,\" CLP\",\" CLPs\"),\"\"))","v":""}]
["","","",null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(OR($I$8=\"\",$O$8=\"\"),\"\",IFERROR(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O52)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0))&\" - \"&VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O52)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)&IF(VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O52)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)=1,\" CLP\",\" CLPs\"),\"\"))","v":""}]
["","","",null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(OR($I$8=\"\",$O$8=\"\"),\"\",IFERROR(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O53)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0))&\" - \"&VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O53)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)&IF(VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O53)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)=1,\" CLP\",\" CLPs\"),\"\"))","v":""}]
["","","",null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(OR($I$8=\"\",$O$8=\"\"),\"\",IFERROR(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O54)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0))&\" - \"&VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O54)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)&IF(VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O54)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)=1,\" CLP\",\" CLPs\"),\"\"))","v":""}]
["","","",null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(OR($I$8=\"\",$O$8=\"\"),\"\",IFERROR(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O55)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0))&\" - \"&VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O55)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)&IF(VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O55)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)=1,\" CLP\",\" CLPs\"),\"\"))","v":""}]
["","","",null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(OR($I$8=\"\",$O$8=\"\"),\"\",IFERROR(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O56)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0))&\" - \"&VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O56)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)&IF(VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O56)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)=1,\" CLP\",\" CLPs\"),\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(OR($I$8=\"\",$O$8=\"\"),\"\",IFERROR(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O57)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0))&\" - \"&VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O57)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)&IF(VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O57)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)=1,\" CLP\",\" CLPs\"),\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(OR($I$8=\"\",$O$8=\"\"),\"\",IFERROR(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O58)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0))&\" - \"&VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O58)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)&IF(VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O58)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)=1,\" CLP\",\" CLPs\"),\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(OR($I$8=\"\",$O$8=\"\"),\"\",IFERROR(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O59)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0))&\" - \"&VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O59)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)&IF(VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O59)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)=1,\" CLP\",\" CLPs\"),\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(OR($I$8=\"\",$O$8=\"\"),\"\",IFERROR(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O60)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0))&\" - \"&VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O60)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)&IF(VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O60)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)=1,\" CLP\",\" CLPs\"),\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(OR($I$8=\"\",$O$8=\"\"),\"\",IFERROR(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O61)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0))&\" - \"&VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O61)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)&IF(VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O61)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)=1,\" CLP\",\" CLPs\"),\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(OR($I$8=\"\",$O$8=\"\"),\"\",IFERROR(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O62)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0))&\" - \"&VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O62)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)&IF(VLOOKUP(INDEX('INPUT TAB'!$O$2:$O$30,MATCH(SMALL('INPUT TAB'!$R$2:$R$30,ROWS('Course Competency Tool'!$O$20:O62)+'INPUT TAB'!$Q$31),'INPUT TAB'!$R$2:$R$30,0)),'Competency Alignment'!E:F,2,FALSE)=1,\" CLP\",\" CLPs\"),\"\"))","v":""}]

{"sheet":"INPUT TAB","index":1,"n_rows":132,"n_cols":18,"rows_kept":132,"cut":false,"hidden":true,"merged":[]}
["Competency Type",null,"Competencies",null,null,null,"Programs",2,null,"Levels",{"$f":"J1","v":"Levels"},null,"Program Options","Level Options","Courses","Helper 1","Helper 2","Helper 3"]
["(Select Competency Type)",null,{"$f":"IF('Course Competency Tool'!$I$8=\"\",$A$2,IF('Course Competency Tool'!$I$8='INPUT TAB'!$A$2,'INPUT TAB'!$A$2,\"(Select Competency)\"))","v":"(Select Competency Type)"},null,null,{"$f":"G2","v":"(Select Competency Type)"},{"$f":"IF('Course Competency Tool'!$I$8=\"\",$A$2,IF('Course Competency Tool'!$O$8=\"\",$C$2,IF(IFERROR(VLOOKUP('Course Competency Tool'!$O$8,'INPUT TAB'!$C:$E,3,FALSE),0)<>2,C2,IF('Course Competency Tool'!$I$8='INPUT TAB'!$A$2,'INPUT TAB'!$A$2,IF('Course Competency Tool'!$O$8='INPUT TAB'!$D$2,'INPUT TAB'!$D$2,\"(Select Program)\")))))","v":"(Select Competency Type)"},null,{"$f":"J2","v":"(Select Competency Type)"},{"$f":"IF('Course Competency Tool'!$I$8=\"\",$A$2,IF('Course Competency Tool'!$O$8=\"\",$C$2,IF('Course Competency Tool'!$I$11=\"\",$G$2,IF('Course Competency Tool'!$I$8='INPUT TAB'!$A$2,'INPUT TAB'!$A$2,IF('Course Competency Tool'!$O$8='INPUT TAB'!$D$2,'INPUT TAB'!$D$2,IF('Course Competency Tool'!$I$11='INPUT TAB'!$G$2,'INPUT TAB'!G2,\"(Select Level)\"))))))","v":"(Select Competency Type)"},{"$f":"IF('Course Competency Tool'!$I$8=\"\",$A$2,IF('Course Competency Tool'!$O$8=\"\",$C$2,IF('Course Competency Tool'!$I$11=\"\",$G$2,IF(IFERROR(VLOOKUP('Course Competency Tool'!$O$8,'INPUT TAB'!$C:$E,3,FALSE),0)<>2,C2,IF(IFERROR(VLOOKUP('Course Competency Tool'!$I$11,'INPUT TAB'!$G:$H,2,FALSE),0)<>2,G2,IF('Course Competency Tool'!$I$8='INPUT TAB'!$A$2,'INPUT TAB'!$A$2,IF('Course Competency Tool'!$O$8='INPUT TAB'!$D$2,'INPUT TAB'!$D$2,IF('Course Competency Tool'!$I$11='INPUT TAB'!$G$2,'INPUT TAB'!G2,\"(Select Level)\"))))))))","v":"(Select Competency Type)"},null,"FAC-C","I",{"$f":"IFERROR(INDEX('Competency Alignment'!E:E,SMALL(IF((IF('Course Competency Tool'!$I$8<>\"\",Competency_Type='Course Competency Tool'!$I$8,TRUE))+(IF('Course Competency Tool'!$O$8<>\"\",Competency='Course Competency Tool'!$O$8,TRUE))+(IF('Course Competency Tool'!$I$11=\"Show All\",1,Program='Course Competency Tool'!$I$11))+(IF('Course Competency Tool'!$O$11=\"Show All\",1,Level='Course Competency Tool'!$O$11))=4,ROW(Level)),ROW(D1))),\"Check inputs for Step #1 through Step #4.\")","v":"Check inputs for Step #1 through Step #4."},{"$f":"COUNTIF($O$2:$O$30,\"<=\"&$O2)","v":29},{"$f":"IF(O2=\"\",1,0)","v":0},{"$f":"IF(O2=\"\",P2,P2+$Q$31)","v":57}]
[{"$f":"IFERROR(INDEX(Competency_Type,MATCH(0,COUNTIF($A$2:$A2,Competency_Type),0)),0)","v":"FAI/DAU Technical Competencies"},{"$f":"IF(A3<>0,2,\"\")","v":2},{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C2,Competency),\"\"),0)),0)","v":0},null,{"$f":"IF(AND(C3<>0,C3<>\"\"),2,\"\")","v":""},null,{"$f":"IF('Course Competency Tool'!$I$8=\"\",0,IF(IFERROR(VLOOKUP('Course Competency Tool'!$O$8,'INPUT TAB'!$C:$E,3,FALSE),0)<>2,0,IF(AND(G2<>\"(Select Program)\",'Course Competency Tool'!I11='INPUT TAB'!G2),0,\"Show All\")))","v":0},{"$f":"IF(AND(G3<>\"\",G3<>0),2,\"\")","v":""},null,{"$f":"IF(OR('Course Competency Tool'!$I$11<>'INPUT TAB'!G2,'Course Competency Tool'!$I$11<>'INPUT TAB'!G2),\"Show All\",0)","v":0},{"$f":"IF('Course Competency Tool'!$I$8=\"\",0,IF(IFERROR(VLOOKUP('Course Competency Tool'!$O$8,'INPUT TAB'!$C:$E,3,FALSE),0)<>2,0,IF(IFERROR(VLOOKUP('Course Competency Tool'!$I$11,'INPUT TAB'!$G:$H,2,FALSE),0)<>2,0,J3)))","v":0},{"$f":"IF(AND(K3<>\"\",K3<>0),2,\"\")","v":""},"Continuous Learning","II",{"$f":"IFERROR(INDEX('Competency Alignment'!E:E,SMALL(IF((IF('Course Competency Tool'!$I$8<>\"\",Competency_Type='Course Competency Tool'!$I$8,TRUE))+(IF('Course Competency Tool'!$O$8<>\"\",Competency='Course Competency Tool'!$O$8,TRUE))+(IF('Course Competency Tool'!$I$11=\"Show All\",1,Program='Course Competency Tool'!$I$11))+(IF('Course Competency Tool'!$O$11=\"Show All\",1,Level='Course Competency Tool'!$O$11))=4,ROW(Level)),ROW('Competency Alignment'!D2))),\"\")","v":""},{"$f":"COUNTIF($O$2:$O$30,\"<=\"&$O3)","v":0},{"$f":"IF(O3=\"\",1,0)","v":1},{"$f":"IF(O3=\"\",P3,P3+$Q$31)","v":0}]
[{"$f":"IFERROR(INDEX(Competency_Type,MATCH(0,COUNTIF($A$2:$A3,Competency_Type),0)),0)","v":"VA 1102 Professional Competencies"},2,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C3,Competency),\"\"),0)),0)","v":0},null,{"$f":"IF(AND(C4<>0,C4<>\"\"),2,\"\")","v":""},null,{"$f":"IFERROR(INDEX(OFFSET('Competency Alignment'!$C$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,1),MATCH(0,IF('Course Competency Tool'!$O$8=OFFSET('Competency Alignment'!$B$2,0,0,COUNTA('Competency Alignment'!$B:$B)-1,1),COUNTIF($G$3:$G3,OFFSET('Competency Alignment'!$C$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,1)),\"\"),0)),0)","v":0},"",null,{"$f":"IFERROR(IF('Course Competency Tool'!$I$11=\"Show All\",INDEX(OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,4),MATCH(1,((OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,1)='Course Competency Tool'!$I$8)*(OFFSET('Competency Alignment'!$B$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,1)='Course Competency Tool'!$O$8))+IF('Course Competency Tool'!$O$8=Competency,COUNTIF($J$3:$J3,Level)),0),4),INDEX(OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,4),MATCH(1,((OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,1)='Course Competency Tool'!$I$8)*(OFFSET('Competency Alignment'!$B$2,0,0,COUNTA('Competency Alignment'!$B:$B)-1,1)='Course Competency Tool'!$O$8)*(OFFSET('Competency Alignment'!$C$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,1)='Course Competency Tool'!$I$11))+IF('Course Competency Tool'!$O$8=Competency,COUNTIF($J$3:$J3,Level)),0),4)),0)","v":0},{"$f":"IF(IFERROR(VLOOKUP('Course Competency Tool'!$O$8,'INPUT TAB'!$C:$E,3,FALSE),0)<>2,0,IF(IFERROR(VLOOKUP('Course Competency Tool'!$I$11,'INPUT TAB'!$G:$H,2,FALSE),0)<>2,0,IF(AND(COUNTIF($J$2:$J$10,$N$2)>=1,COUNTIF($K$2:K3,$N$2)=0),$N$2,IF(AND(COUNTIF($J$2:$J$10,$N$3)>=1,COUNTIF($K$2:K3,$N$3)=0),$N$3,IF(AND(COUNTIF($J$2:$J$10,$N$4)>=1,COUNTIF($K$2:K3,$N$4)=0),$N$4,IF(AND(COUNTIF($J$2:$J$10,$N$5)>=1,COUNTIF($K$2:K3,$N$5)=0),$N$5,IF(AND(COUNTIF($J$2:$J$10,$N$6)>=1,COUNTIF($K$2:K3,$N$6)=0),$N$6,IF(AND(COUNTIF($J$2:$J$10,$N$7)>=1,COUNTIF($K$2:K3,$N$7)=0),$N$7,IF(AND(COUNTIF($J$2:$J$10,$N$8)>=1,COUNTIF($K$2:K3,$N$8)=0),$N$8,IF(AND(COUNTIF($J$2:$J$10,$N$9)>=1,COUNTIF($K$2:K3,$N$9)=0),$N$9,IF(AND(COUNTIF($J$2:$J$10,$N$10)>=1,COUNTIF($K$2:K3,$N$10)=0),$N$10,IF(AND(COUNTIF($J$2:$J$10,$N$11)>=1,COUNTIF($K$2:K3,$N$11)=0),$N$11,IF(AND(COUNTIF($J$2:$J$10,$N$12)>=1,COUNTIF($K$2:K3,$N$12)=0),$N$12,IF(AND(COUNTIF($J$2:$J$10,$N$13)>=1,COUNTIF($K$2:K3,$N$13)=0),$N$13,IF(AND(COUNTIF($J$2:$J$10,$N$14)>=1,COUNTIF($K$2:K3,$N$14)=0),$N$14,IF(AND(COUNTIF($J$2:$J$10,$N$15)>=1,COUNTIF($K$2:K3,$N$15)=0),$N$15,IF(AND(COUNTIF($J$2:$J$10,$N$16)>=1,COUNTIF($K$2:K3,$N$16)=0),$N$16,0)))))))))))))))))","v":0},"",null,"III",{"$f":"IFERROR(INDEX('Competency Alignment'!E:E,SMALL(IF((IF('Course Competency Tool'!$I$8<>\"\",Competency_Type='Course Competency Tool'!$I$8,TRUE))+(IF('Course Competency Tool'!$O$8<>\"\",Competency='Course Competency Tool'!$O$8,TRUE))+(IF('Course Competency Tool'!$I$11=\"Show All\",1,Program='Course Competency Tool'!$I$11))+(IF('Course Competency Tool'!$O$11=\"Show All\",1,Level='Course Competency Tool'!$O$11))=4,ROW(Level)),ROW('Competency Alignment'!D3))),\"\")","v":""},{"$f":"COUNTIF($O$2:$O$30,\"<=\"&$O4)","v":0},1,0]
[{"$f":"IFERROR(INDEX(Competency_Type,MATCH(0,COUNTIF($A$2:$A4,Competency_Type),0)),0)","v":0},"",{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C4,Competency),\"\"),0)),0)","v":0},null,"",null,{"$f":"IFERROR(INDEX(OFFSET('Competency Alignment'!$C$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,1),MATCH(0,IF('Course Competency Tool'!$O$8=OFFSET('Competency Alignment'!$B$2,0,0,COUNTA('Competency Alignment'!$B:$B)-1,1),COUNTIF($G$3:$G4,OFFSET('Competency Alignment'!$C$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,1)),\"\"),0)),0)","v":0},"",null,{"$f":"IFERROR(IF('Course Competency Tool'!$I$11=\"Show All\",INDEX(OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,4),MATCH(1,((OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,1)='Course Competency Tool'!$I$8)*(OFFSET('Competency Alignment'!$B$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,1)='Course Competency Tool'!$O$8))+IF('Course Competency Tool'!$O$8=Competency,COUNTIF($J$3:$J4,Level)),0),4),INDEX(OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,4),MATCH(1,((OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,1)='Course Competency Tool'!$I$8)*(OFFSET('Competency Alignment'!$B$2,0,0,COUNTA('Competency Alignment'!$B:$B)-1,1)='Course Competency Tool'!$O$8)*(OFFSET('Competency Alignment'!$C$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,1)='Course Competency Tool'!$I$11))+IF('Course Competency Tool'!$O$8=Competency,COUNTIF($J$3:$J4,Level)),0),4)),0)","v":0},{"$f":"IF(IFERROR(VLOOKUP('Course Competency Tool'!$O$8,'INPUT TAB'!$C:$E,3,FALSE),0)<>2,0,IF(IFERROR(VLOOKUP('Course Competency Tool'!$I$11,'INPUT TAB'!$G:$H,2,FALSE),0)<>2,0,IF(AND(COUNTIF($J$2:$J$10,$N$2)>=1,COUNTIF($K$2:K4,$N$2)=0),$N$2,IF(AND(COUNTIF($J$2:$J$10,$N$3)>=1,COUNTIF($K$2:K4,$N$3)=0),$N$3,IF(AND(COUNTIF($J$2:$J$10,$N$4)>=1,COUNTIF($K$2:K4,$N$4)=0),$N$4,IF(AND(COUNTIF($J$2:$J$10,$N$5)>=1,COUNTIF($K$2:K4,$N$5)=0),$N$5,IF(AND(COUNTIF($J$2:$J$10,$N$6)>=1,COUNTIF($K$2:K4,$N$6)=0),$N$6,IF(AND(COUNTIF($J$2:$J$10,$N$7)>=1,COUNTIF($K$2:K4,$N$7)=0),$N$7,IF(AND(COUNTIF($J$2:$J$10,$N$8)>=1,COUNTIF($K$2:K4,$N$8)=0),$N$8,IF(AND(COUNTIF($J$2:$J$10,$N$9)>=1,COUNTIF($K$2:K4,$N$9)=0),$N$9,IF(AND(COUNTIF($J$2:$J$10,$N$10)>=1,COUNTIF($K$2:K4,$N$10)=0),$N$10,IF(AND(COUNTIF($J$2:$J$10,$N$11)>=1,COUNTIF($K$2:K4,$N$11)=0),$N$11,IF(AND(COUNTIF($J$2:$J$10,$N$12)>=1,COUNTIF($K$2:K4,$N$12)=0),$N$12,IF(AND(COUNTIF($J$2:$J$10,$N$13)>=1,COUNTIF($K$2:K4,$N$13)=0),$N$13,IF(AND(COUNTIF($J$2:$J$10,$N$14)>=1,COUNTIF($K$2:K4,$N$14)=0),$N$14,IF(AND(COUNTIF($J$2:$J$10,$N$15)>=1,COUNTIF($K$2:K4,$N$15)=0),$N$15,IF(AND(COUNTIF($J$2:$J$10,$N$16)>=1,COUNTIF($K$2:K4,$N$16)=0),$N$16,0)))))))))))))))))","v":0},"",null,"III Elective",{"$f":"IFERROR(INDEX('Competency Alignment'!E:E,SMALL(IF((IF('Course Competency Tool'!$I$8<>\"\",Competency_Type='Course Competency Tool'!$I$8,TRUE))+(IF('Course Competency Tool'!$O$8<>\"\",Competency='Course Competency Tool'!$O$8,TRUE))+(IF('Course Competency Tool'!$I$11=\"Show All\",1,Program='Course Competency Tool'!$I$11))+(IF('Course Competency Tool'!$O$11=\"Show All\",1,Level='Course Competency Tool'!$O$11))=4,ROW(Level)),ROW('Competency Alignment'!D4))),\"\")","v":""},0,1,0]
[{"$f":"IFERROR(INDEX(Competency_Type,MATCH(0,COUNTIF($A$2:$A5,Competency_Type),0)),0)","v":0},"",{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C5,Competency),\"\"),0)),0)","v":0},null,"",null,{"$f":"IFERROR(INDEX(OFFSET('Competency Alignment'!$C$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,1),MATCH(0,IF('Course Competency Tool'!$O$8=OFFSET('Competency Alignment'!$B$2,0,0,COUNTA('Competency Alignment'!$B:$B)-1,1),COUNTIF($G$3:$G5,OFFSET('Competency Alignment'!$C$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,1)),\"\"),0)),0)","v":0},"",null,{"$f":"IFERROR(IF('Course Competency Tool'!$I$11=\"Show All\",INDEX(OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,4),MATCH(1,((OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,1)='Course Competency Tool'!$I$8)*(OFFSET('Competency Alignment'!$B$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,1)='Course Competency Tool'!$O$8))+IF('Course Competency Tool'!$O$8=Competency,COUNTIF($J$3:$J5,Level)),0),4),INDEX(OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,4),MATCH(1,((OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,1)='Course Competency Tool'!$I$8)*(OFFSET('Competency Alignment'!$B$2,0,0,COUNTA('Competency Alignment'!$B:$B)-1,1)='Course Competency Tool'!$O$8)*(OFFSET('Competency Alignment'!$C$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,1)='Course Competency Tool'!$I$11))+IF('Course Competency Tool'!$O$8=Competency,COUNTIF($J$3:$J5,Level)),0),4)),0)","v":0},{"$f":"IF(IFERROR(VLOOKUP('Course Competency Tool'!$O$8,'INPUT TAB'!$C:$E,3,FALSE),0)<>2,0,IF(IFERROR(VLOOKUP('Course Competency Tool'!$I$11,'INPUT TAB'!$G:$H,2,FALSE),0)<>2,0,IF(AND(COUNTIF($J$2:$J$10,$N$2)>=1,COUNTIF($K$2:K5,$N$2)=0),$N$2,IF(AND(COUNTIF($J$2:$J$10,$N$3)>=1,COUNTIF($K$2:K5,$N$3)=0),$N$3,IF(AND(COUNTIF($J$2:$J$10,$N$4)>=1,COUNTIF($K$2:K5,$N$4)=0),$N$4,IF(AND(COUNTIF($J$2:$J$10,$N$5)>=1,COUNTIF($K$2:K5,$N$5)=0),$N$5,IF(AND(COUNTIF($J$2:$J$10,$N$6)>=1,COUNTIF($K$2:K5,$N$6)=0),$N$6,IF(AND(COUNTIF($J$2:$J$10,$N$7)>=1,COUNTIF($K$2:K5,$N$7)=0),$N$7,IF(AND(COUNTIF($J$2:$J$10,$N$8)>=1,COUNTIF($K$2:K5,$N$8)=0),$N$8,IF(AND(COUNTIF($J$2:$J$10,$N$9)>=1,COUNTIF($K$2:K5,$N$9)=0),$N$9,IF(AND(COUNTIF($J$2:$J$10,$N$10)>=1,COUNTIF($K$2:K5,$N$10)=0),$N$10,IF(AND(COUNTIF($J$2:$J$10,$N$11)>=1,COUNTIF($K$2:K5,$N$11)=0),$N$11,IF(AND(COUNTIF($J$2:$J$10,$N$12)>=1,COUNTIF($K$2:K5,$N$12)=0),$N$12,IF(AND(COUNTIF($J$2:$J$10,$N$13)>=1,COUNTIF($K$2:K5,$N$13)=0),$N$13,IF(AND(COUNTIF($J$2:$J$10,$N$14)>=1,COUNTIF($K$2:K5,$N$14)=0),$N$14,IF(AND(COUNTIF($J$2:$J$10,$N$15)>=1,COUNTIF($K$2:K5,$N$15)=0),$N$15,IF(AND(COUNTIF($J$2:$J$10,$N$16)>=1,COUNTIF($K$2:K5,$N$16)=0),$N$16,0)))))))))))))))))","v":0},"",null,"Available For All Levels",{"$f":"IFERROR(INDEX('Competency Alignment'!E:E,SMALL(IF((IF('Course Competency Tool'!$I$8<>\"\",Competency_Type='Course Competency Tool'!$I$8,TRUE))+(IF('Course Competency Tool'!$O$8<>\"\",Competency='Course Competency Tool'!$O$8,TRUE))+(IF('Course Competency Tool'!$I$11=\"Show All\",1,Program='Course Competency Tool'!$I$11))+(IF('Course Competency Tool'!$O$11=\"Show All\",1,Level='Course Competency Tool'!$O$11))=4,ROW(Level)),ROW('Competency Alignment'!D5))),\"\")","v":""},0,1,0]
[{"$f":"IFERROR(INDEX(Competency_Type,MATCH(0,COUNTIF($A$2:$A6,Competency_Type),0)),0)","v":0},"",{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C6,Competency),\"\"),0)),0)","v":0},null,"",null,{"$f":"IFERROR(INDEX(OFFSET('Competency Alignment'!$C$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,1),MATCH(0,IF('Course Competency Tool'!$O$8=OFFSET('Competency Alignment'!$B$2,0,0,COUNTA('Competency Alignment'!$B:$B)-1,1),COUNTIF($G$3:$G6,OFFSET('Competency Alignment'!$C$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,1)),\"\"),0)),0)","v":0},"",null,{"$f":"IFERROR(IF('Course Competency Tool'!$I$11=\"Show All\",INDEX(OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,4),MATCH(1,((OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,1)='Course Competency Tool'!$I$8)*(OFFSET('Competency Alignment'!$B$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,1)='Course Competency Tool'!$O$8))+IF('Course Competency Tool'!$O$8=Competency,COUNTIF($J$3:$J6,Level)),0),4),INDEX(OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,4),MATCH(1,((OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,1)='Course Competency Tool'!$I$8)*(OFFSET('Competency Alignment'!$B$2,0,0,COUNTA('Competency Alignment'!$B:$B)-1,1)='Course Competency Tool'!$O$8)*(OFFSET('Competency Alignment'!$C$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,1)='Course Competency Tool'!$I$11))+IF('Course Competency Tool'!$O$8=Competency,COUNTIF($J$3:$J6,Level)),0),4)),0)","v":0},{"$f":"IF(IFERROR(VLOOKUP('Course Competency Tool'!$O$8,'INPUT TAB'!$C:$E,3,FALSE),0)<>2,0,IF(IFERROR(VLOOKUP('Course Competency Tool'!$I$11,'INPUT TAB'!$G:$H,2,FALSE),0)<>2,0,IF(AND(COUNTIF($J$2:$J$10,$N$2)>=1,COUNTIF($K$2:K6,$N$2)=0),$N$2,IF(AND(COUNTIF($J$2:$J$10,$N$3)>=1,COUNTIF($K$2:K6,$N$3)=0),$N$3,IF(AND(COUNTIF($J$2:$J$10,$N$4)>=1,COUNTIF($K$2:K6,$N$4)=0),$N$4,IF(AND(COUNTIF($J$2:$J$10,$N$5)>=1,COUNTIF($K$2:K6,$N$5)=0),$N$5,IF(AND(COUNTIF($J$2:$J$10,$N$6)>=1,COUNTIF($K$2:K6,$N$6)=0),$N$6,IF(AND(COUNTIF($J$2:$J$10,$N$7)>=1,COUNTIF($K$2:K6,$N$7)=0),$N$7,IF(AND(COUNTIF($J$2:$J$10,$N$8)>=1,COUNTIF($K$2:K6,$N$8)=0),$N$8,IF(AND(COUNTIF($J$2:$J$10,$N$9)>=1,COUNTIF($K$2:K6,$N$9)=0),$N$9,IF(AND(COUNTIF($J$2:$J$10,$N$10)>=1,COUNTIF($K$2:K6,$N$10)=0),$N$10,IF(AND(COUNTIF($J$2:$J$10,$N$11)>=1,COUNTIF($K$2:K6,$N$11)=0),$N$11,IF(AND(COUNTIF($J$2:$J$10,$N$12)>=1,COUNTIF($K$2:K6,$N$12)=0),$N$12,IF(AND(COUNTIF($J$2:$J$10,$N$13)>=1,COUNTIF($K$2:K6,$N$13)=0),$N$13,IF(AND(COUNTIF($J$2:$J$10,$N$14)>=1,COUNTIF($K$2:K6,$N$14)=0),$N$14,IF(AND(COUNTIF($J$2:$J$10,$N$15)>=1,COUNTIF($K$2:K6,$N$15)=0),$N$15,IF(AND(COUNTIF($J$2:$J$10,$N$16)>=1,COUNTIF($K$2:K6,$N$16)=0),$N$16,0)))))))))))))))))","v":0},"",null,null,{"$f":"IFERROR(INDEX('Competency Alignment'!E:E,SMALL(IF((IF('Course Competency Tool'!$I$8<>\"\",Competency_Type='Course Competency Tool'!$I$8,TRUE))+(IF('Course Competency Tool'!$O$8<>\"\",Competency='Course Competency Tool'!$O$8,TRUE))+(IF('Course Competency Tool'!$I$11=\"Show All\",1,Program='Course Competency Tool'!$I$11))+(IF('Course Competency Tool'!$O$11=\"Show All\",1,Level='Course Competency Tool'!$O$11))=4,ROW(Level)),ROW('Competency Alignment'!D6))),\"\")","v":""},0,1,0]
[{"$f":"IFERROR(INDEX(Competency_Type,MATCH(0,COUNTIF($A$2:$A7,Competency_Type),0)),0)","v":0},"",{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C7,Competency),\"\"),0)),0)","v":0},null,"",null,{"$f":"IFERROR(INDEX(OFFSET('Competency Alignment'!$C$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,1),MATCH(0,IF('Course Competency Tool'!$O$8=OFFSET('Competency Alignment'!$B$2,0,0,COUNTA('Competency Alignment'!$B:$B)-1,1),COUNTIF($G$3:$G7,OFFSET('Competency Alignment'!$C$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,1)),\"\"),0)),0)","v":0},"",null,{"$f":"IFERROR(IF('Course Competency Tool'!$I$11=\"Show All\",INDEX(OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,4),MATCH(1,((OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,1)='Course Competency Tool'!$I$8)*(OFFSET('Competency Alignment'!$B$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,1)='Course Competency Tool'!$O$8))+IF('Course Competency Tool'!$O$8=Competency,COUNTIF($J$3:$J7,Level)),0),4),INDEX(OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,4),MATCH(1,((OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,1)='Course Competency Tool'!$I$8)*(OFFSET('Competency Alignment'!$B$2,0,0,COUNTA('Competency Alignment'!$B:$B)-1,1)='Course Competency Tool'!$O$8)*(OFFSET('Competency Alignment'!$C$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,1)='Course Competency Tool'!$I$11))+IF('Course Competency Tool'!$O$8=Competency,COUNTIF($J$3:$J7,Level)),0),4)),0)","v":0},{"$f":"IF(IFERROR(VLOOKUP('Course Competency Tool'!$O$8,'INPUT TAB'!$C:$E,3,FALSE),0)<>2,0,IF(IFERROR(VLOOKUP('Course Competency Tool'!$I$11,'INPUT TAB'!$G:$H,2,FALSE),0)<>2,0,IF(AND(COUNTIF($J$2:$J$10,$N$2)>=1,COUNTIF($K$2:K7,$N$2)=0),$N$2,IF(AND(COUNTIF($J$2:$J$10,$N$3)>=1,COUNTIF($K$2:K7,$N$3)=0),$N$3,IF(AND(COUNTIF($J$2:$J$10,$N$4)>=1,COUNTIF($K$2:K7,$N$4)=0),$N$4,IF(AND(COUNTIF($J$2:$J$10,$N$5)>=1,COUNTIF($K$2:K7,$N$5)=0),$N$5,IF(AND(COUNTIF($J$2:$J$10,$N$6)>=1,COUNTIF($K$2:K7,$N$6)=0),$N$6,IF(AND(COUNTIF($J$2:$J$10,$N$7)>=1,COUNTIF($K$2:K7,$N$7)=0),$N$7,IF(AND(COUNTIF($J$2:$J$10,$N$8)>=1,COUNTIF($K$2:K7,$N$8)=0),$N$8,IF(AND(COUNTIF($J$2:$J$10,$N$9)>=1,COUNTIF($K$2:K7,$N$9)=0),$N$9,IF(AND(COUNTIF($J$2:$J$10,$N$10)>=1,COUNTIF($K$2:K7,$N$10)=0),$N$10,IF(AND(COUNTIF($J$2:$J$10,$N$11)>=1,COUNTIF($K$2:K7,$N$11)=0),$N$11,IF(AND(COUNTIF($J$2:$J$10,$N$12)>=1,COUNTIF($K$2:K7,$N$12)=0),$N$12,IF(AND(COUNTIF($J$2:$J$10,$N$13)>=1,COUNTIF($K$2:K7,$N$13)=0),$N$13,IF(AND(COUNTIF($J$2:$J$10,$N$14)>=1,COUNTIF($K$2:K7,$N$14)=0),$N$14,IF(AND(COUNTIF($J$2:$J$10,$N$15)>=1,COUNTIF($K$2:K7,$N$15)=0),$N$15,IF(AND(COUNTIF($J$2:$J$10,$N$16)>=1,COUNTIF($K$2:K7,$N$16)=0),$N$16,0)))))))))))))))))","v":0},"",null,null,{"$f":"IFERROR(INDEX('Competency Alignment'!E:E,SMALL(IF((IF('Course Competency Tool'!$I$8<>\"\",Competency_Type='Course Competency Tool'!$I$8,TRUE))+(IF('Course Competency Tool'!$O$8<>\"\",Competency='Course Competency Tool'!$O$8,TRUE))+(IF('Course Competency Tool'!$I$11=\"Show All\",1,Program='Course Competency Tool'!$I$11))+(IF('Course Competency Tool'!$O$11=\"Show All\",1,Level='Course Competency Tool'!$O$11))=4,ROW(Level)),ROW('Competency Alignment'!D7))),\"\")","v":""},0,1,0]
[{"$f":"IFERROR(INDEX(Competency_Type,MATCH(0,COUNTIF($A$2:$A8,Competency_Type),0)),0)","v":0},"",{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C8,Competency),\"\"),0)),0)","v":0},null,"",null,{"$f":"IFERROR(INDEX(OFFSET('Competency Alignment'!$C$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,1),MATCH(0,IF('Course Competency Tool'!$O$8=OFFSET('Competency Alignment'!$B$2,0,0,COUNTA('Competency Alignment'!$B:$B)-1,1),COUNTIF($G$3:$G8,OFFSET('Competency Alignment'!$C$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,1)),\"\"),0)),0)","v":0},"",null,{"$f":"IFERROR(IF('Course Competency Tool'!$I$11=\"Show All\",INDEX(OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,4),MATCH(1,((OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,1)='Course Competency Tool'!$I$8)*(OFFSET('Competency Alignment'!$B$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,1)='Course Competency Tool'!$O$8))+IF('Course Competency Tool'!$O$8=Competency,COUNTIF($J$3:$J8,Level)),0),4),INDEX(OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,4),MATCH(1,((OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,1)='Course Competency Tool'!$I$8)*(OFFSET('Competency Alignment'!$B$2,0,0,COUNTA('Competency Alignment'!$B:$B)-1,1)='Course Competency Tool'!$O$8)*(OFFSET('Competency Alignment'!$C$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,1)='Course Competency Tool'!$I$11))+IF('Course Competency Tool'!$O$8=Competency,COUNTIF($J$3:$J8,Level)),0),4)),0)","v":0},{"$f":"IF(IFERROR(VLOOKUP('Course Competency Tool'!$O$8,'INPUT TAB'!$C:$E,3,FALSE),0)<>2,0,IF(IFERROR(VLOOKUP('Course Competency Tool'!$I$11,'INPUT TAB'!$G:$H,2,FALSE),0)<>2,0,IF(AND(COUNTIF($J$2:$J$10,$N$2)>=1,COUNTIF($K$2:K8,$N$2)=0),$N$2,IF(AND(COUNTIF($J$2:$J$10,$N$3)>=1,COUNTIF($K$2:K8,$N$3)=0),$N$3,IF(AND(COUNTIF($J$2:$J$10,$N$4)>=1,COUNTIF($K$2:K8,$N$4)=0),$N$4,IF(AND(COUNTIF($J$2:$J$10,$N$5)>=1,COUNTIF($K$2:K8,$N$5)=0),$N$5,IF(AND(COUNTIF($J$2:$J$10,$N$6)>=1,COUNTIF($K$2:K8,$N$6)=0),$N$6,IF(AND(COUNTIF($J$2:$J$10,$N$7)>=1,COUNTIF($K$2:K8,$N$7)=0),$N$7,IF(AND(COUNTIF($J$2:$J$10,$N$8)>=1,COUNTIF($K$2:K8,$N$8)=0),$N$8,IF(AND(COUNTIF($J$2:$J$10,$N$9)>=1,COUNTIF($K$2:K8,$N$9)=0),$N$9,IF(AND(COUNTIF($J$2:$J$10,$N$10)>=1,COUNTIF($K$2:K8,$N$10)=0),$N$10,IF(AND(COUNTIF($J$2:$J$10,$N$11)>=1,COUNTIF($K$2:K8,$N$11)=0),$N$11,IF(AND(COUNTIF($J$2:$J$10,$N$12)>=1,COUNTIF($K$2:K8,$N$12)=0),$N$12,IF(AND(COUNTIF($J$2:$J$10,$N$13)>=1,COUNTIF($K$2:K8,$N$13)=0),$N$13,IF(AND(COUNTIF($J$2:$J$10,$N$14)>=1,COUNTIF($K$2:K8,$N$14)=0),$N$14,IF(AND(COUNTIF($J$2:$J$10,$N$15)>=1,COUNTIF($K$2:K8,$N$15)=0),$N$15,IF(AND(COUNTIF($J$2:$J$10,$N$16)>=1,COUNTIF($K$2:K8,$N$16)=0),$N$16,0)))))))))))))))))","v":0},"",null,null,{"$f":"IFERROR(INDEX('Competency Alignment'!E:E,SMALL(IF((IF('Course Competency Tool'!$I$8<>\"\",Competency_Type='Course Competency Tool'!$I$8,TRUE))+(IF('Course Competency Tool'!$O$8<>\"\",Competency='Course Competency Tool'!$O$8,TRUE))+(IF('Course Competency Tool'!$I$11=\"Show All\",1,Program='Course Competency Tool'!$I$11))+(IF('Course Competency Tool'!$O$11=\"Show All\",1,Level='Course Competency Tool'!$O$11))=4,ROW(Level)),ROW('Competency Alignment'!D8))),\"\")","v":""},0,1,0]
[{"$f":"IFERROR(INDEX(Competency_Type,MATCH(0,COUNTIF($A$2:$A9,Competency_Type),0)),0)","v":0},"",{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C9,Competency),\"\"),0)),0)","v":0},null,"",null,{"$f":"IFERROR(INDEX(OFFSET('Competency Alignment'!$C$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,1),MATCH(0,IF('Course Competency Tool'!$O$8=OFFSET('Competency Alignment'!$B$2,0,0,COUNTA('Competency Alignment'!$B:$B)-1,1),COUNTIF($G$3:$G9,OFFSET('Competency Alignment'!$C$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,1)),\"\"),0)),0)","v":0},"",null,{"$f":"IFERROR(IF('Course Competency Tool'!$I$11=\"Show All\",INDEX(OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,4),MATCH(1,((OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,1)='Course Competency Tool'!$I$8)*(OFFSET('Competency Alignment'!$B$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,1)='Course Competency Tool'!$O$8))+IF('Course Competency Tool'!$O$8=Competency,COUNTIF($J$3:$J9,Level)),0),4),INDEX(OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,4),MATCH(1,((OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,1)='Course Competency Tool'!$I$8)*(OFFSET('Competency Alignment'!$B$2,0,0,COUNTA('Competency Alignment'!$B:$B)-1,1)='Course Competency Tool'!$O$8)*(OFFSET('Competency Alignment'!$C$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,1)='Course Competency Tool'!$I$11))+IF('Course Competency Tool'!$O$8=Competency,COUNTIF($J$3:$J9,Level)),0),4)),0)","v":0},{"$f":"IF(IFERROR(VLOOKUP('Course Competency Tool'!$O$8,'INPUT TAB'!$C:$E,3,FALSE),0)<>2,0,IF(IFERROR(VLOOKUP('Course Competency Tool'!$I$11,'INPUT TAB'!$G:$H,2,FALSE),0)<>2,0,IF(AND(COUNTIF($J$2:$J$10,$N$2)>=1,COUNTIF($K$2:K9,$N$2)=0),$N$2,IF(AND(COUNTIF($J$2:$J$10,$N$3)>=1,COUNTIF($K$2:K9,$N$3)=0),$N$3,IF(AND(COUNTIF($J$2:$J$10,$N$4)>=1,COUNTIF($K$2:K9,$N$4)=0),$N$4,IF(AND(COUNTIF($J$2:$J$10,$N$5)>=1,COUNTIF($K$2:K9,$N$5)=0),$N$5,IF(AND(COUNTIF($J$2:$J$10,$N$6)>=1,COUNTIF($K$2:K9,$N$6)=0),$N$6,IF(AND(COUNTIF($J$2:$J$10,$N$7)>=1,COUNTIF($K$2:K9,$N$7)=0),$N$7,IF(AND(COUNTIF($J$2:$J$10,$N$8)>=1,COUNTIF($K$2:K9,$N$8)=0),$N$8,IF(AND(COUNTIF($J$2:$J$10,$N$9)>=1,COUNTIF($K$2:K9,$N$9)=0),$N$9,IF(AND(COUNTIF($J$2:$J$10,$N$10)>=1,COUNTIF($K$2:K9,$N$10)=0),$N$10,IF(AND(COUNTIF($J$2:$J$10,$N$11)>=1,COUNTIF($K$2:K9,$N$11)=0),$N$11,IF(AND(COUNTIF($J$2:$J$10,$N$12)>=1,COUNTIF($K$2:K9,$N$12)=0),$N$12,IF(AND(COUNTIF($J$2:$J$10,$N$13)>=1,COUNTIF($K$2:K9,$N$13)=0),$N$13,IF(AND(COUNTIF($J$2:$J$10,$N$14)>=1,COUNTIF($K$2:K9,$N$14)=0),$N$14,IF(AND(COUNTIF($J$2:$J$10,$N$15)>=1,COUNTIF($K$2:K9,$N$15)=0),$N$15,IF(AND(COUNTIF($J$2:$J$10,$N$16)>=1,COUNTIF($K$2:K9,$N$16)=0),$N$16,0)))))))))))))))))","v":0},"",null,null,{"$f":"IFERROR(INDEX('Competency Alignment'!E:E,SMALL(IF((IF('Course Competency Tool'!$I$8<>\"\",Competency_Type='Course Competency Tool'!$I$8,TRUE))+(IF('Course Competency Tool'!$O$8<>\"\",Competency='Course Competency Tool'!$O$8,TRUE))+(IF('Course Competency Tool'!$I$11=\"Show All\",1,Program='Course Competency Tool'!$I$11))+(IF('Course Competency Tool'!$O$11=\"Show All\",1,Level='Course Competency Tool'!$O$11))=4,ROW(Level)),ROW('Competency Alignment'!D9))),\"\")","v":""},0,1,0]
[{"$f":"IFERROR(INDEX(Competency_Type,MATCH(0,COUNTIF($A$2:$A10,Competency_Type),0)),0)","v":0},"",{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C10,Competency),\"\"),0)),0)","v":0},null,"",null,{"$f":"IFERROR(INDEX(OFFSET('Competency Alignment'!$C$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,1),MATCH(0,IF('Course Competency Tool'!$O$8=OFFSET('Competency Alignment'!$B$2,0,0,COUNTA('Competency Alignment'!$B:$B)-1,1),COUNTIF($G$3:$G10,OFFSET('Competency Alignment'!$C$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,1)),\"\"),0)),0)","v":0},"",null,{"$f":"IFERROR(IF('Course Competency Tool'!$I$11=\"Show All\",INDEX(OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,4),MATCH(1,((OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,1)='Course Competency Tool'!$I$8)*(OFFSET('Competency Alignment'!$B$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,1)='Course Competency Tool'!$O$8))+IF('Course Competency Tool'!$O$8=Competency,COUNTIF($J$3:$J10,Level)),0),4),INDEX(OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,4),MATCH(1,((OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,1)='Course Competency Tool'!$I$8)*(OFFSET('Competency Alignment'!$B$2,0,0,COUNTA('Competency Alignment'!$B:$B)-1,1)='Course Competency Tool'!$O$8)*(OFFSET('Competency Alignment'!$C$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,1)='Course Competency Tool'!$I$11))+IF('Course Competency Tool'!$O$8=Competency,COUNTIF($J$3:$J10,Level)),0),4)),0)","v":0},{"$f":"IF(IFERROR(VLOOKUP('Course Competency Tool'!$O$8,'INPUT TAB'!$C:$E,3,FALSE),0)<>2,0,IF(IFERROR(VLOOKUP('Course Competency Tool'!$I$11,'INPUT TAB'!$G:$H,2,FALSE),0)<>2,0,IF(AND(COUNTIF($J$2:$J$10,$N$2)>=1,COUNTIF($K$2:K10,$N$2)=0),$N$2,IF(AND(COUNTIF($J$2:$J$10,$N$3)>=1,COUNTIF($K$2:K10,$N$3)=0),$N$3,IF(AND(COUNTIF($J$2:$J$10,$N$4)>=1,COUNTIF($K$2:K10,$N$4)=0),$N$4,IF(AND(COUNTIF($J$2:$J$10,$N$5)>=1,COUNTIF($K$2:K10,$N$5)=0),$N$5,IF(AND(COUNTIF($J$2:$J$10,$N$6)>=1,COUNTIF($K$2:K10,$N$6)=0),$N$6,IF(AND(COUNTIF($J$2:$J$10,$N$7)>=1,COUNTIF($K$2:K10,$N$7)=0),$N$7,IF(AND(COUNTIF($J$2:$J$10,$N$8)>=1,COUNTIF($K$2:K10,$N$8)=0),$N$8,IF(AND(COUNTIF($J$2:$J$10,$N$9)>=1,COUNTIF($K$2:K10,$N$9)=0),$N$9,IF(AND(COUNTIF($J$2:$J$10,$N$10)>=1,COUNTIF($K$2:K10,$N$10)=0),$N$10,IF(AND(COUNTIF($J$2:$J$10,$N$11)>=1,COUNTIF($K$2:K10,$N$11)=0),$N$11,IF(AND(COUNTIF($J$2:$J$10,$N$12)>=1,COUNTIF($K$2:K10,$N$12)=0),$N$12,IF(AND(COUNTIF($J$2:$J$10,$N$13)>=1,COUNTIF($K$2:K10,$N$13)=0),$N$13,IF(AND(COUNTIF($J$2:$J$10,$N$14)>=1,COUNTIF($K$2:K10,$N$14)=0),$N$14,IF(AND(COUNTIF($J$2:$J$10,$N$15)>=1,COUNTIF($K$2:K10,$N$15)=0),$N$15,IF(AND(COUNTIF($J$2:$J$10,$N$16)>=1,COUNTIF($K$2:K10,$N$16)=0),$N$16,0)))))))))))))))))","v":0},"",null,null,{"$f":"IFERROR(INDEX('Competency Alignment'!E:E,SMALL(IF((IF('Course Competency Tool'!$I$8<>\"\",Competency_Type='Course Competency Tool'!$I$8,TRUE))+(IF('Course Competency Tool'!$O$8<>\"\",Competency='Course Competency Tool'!$O$8,TRUE))+(IF('Course Competency Tool'!$I$11=\"Show All\",1,Program='Course Competency Tool'!$I$11))+(IF('Course Competency Tool'!$O$11=\"Show All\",1,Level='Course Competency Tool'!$O$11))=4,ROW(Level)),ROW('Competency Alignment'!D10))),\"\")","v":""},0,1,0]
[{"$f":"IFERROR(INDEX(Competency_Type,MATCH(0,COUNTIF($A$2:$A11,Competency_Type),0)),0)","v":0},"",{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C11,Competency),\"\"),0)),0)","v":0},null,"",null,{"$f":"IFERROR(INDEX(OFFSET('Competency Alignment'!$C$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,1),MATCH(0,IF('Course Competency Tool'!$O$8=OFFSET('Competency Alignment'!$B$2,0,0,COUNTA('Competency Alignment'!$B:$B)-1,1),COUNTIF($G$3:$G11,OFFSET('Competency Alignment'!$C$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,1)),\"\"),0)),0)","v":0},"",null,{"$f":"IFERROR(IF('Course Competency Tool'!$I$11=\"Show All\",INDEX(OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,4),MATCH(1,((OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,1)='Course Competency Tool'!$I$8)*(OFFSET('Competency Alignment'!$B$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,1)='Course Competency Tool'!$O$8))+IF('Course Competency Tool'!$O$8=Competency,COUNTIF($J$3:$J11,Level)),0),4),INDEX(OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,4),MATCH(1,((OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,1)='Course Competency Tool'!$I$8)*(OFFSET('Competency Alignment'!$B$2,0,0,COUNTA('Competency Alignment'!$B:$B)-1,1)='Course Competency Tool'!$O$8)*(OFFSET('Competency Alignment'!$C$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,1)='Course Competency Tool'!$I$11))+IF('Course Competency Tool'!$O$8=Competency,COUNTIF($J$3:$J11,Level)),0),4)),0)","v":0},{"$f":"IF(IFERROR(VLOOKUP('Course Competency Tool'!$O$8,'INPUT TAB'!$C:$E,3,FALSE),0)<>2,0,IF(IFERROR(VLOOKUP('Course Competency Tool'!$I$11,'INPUT TAB'!$G:$H,2,FALSE),0)<>2,0,IF(AND(COUNTIF($J$2:$J$10,$N$2)>=1,COUNTIF($K$2:K11,$N$2)=0),$N$2,IF(AND(COUNTIF($J$2:$J$10,$N$3)>=1,COUNTIF($K$2:K11,$N$3)=0),$N$3,IF(AND(COUNTIF($J$2:$J$10,$N$4)>=1,COUNTIF($K$2:K11,$N$4)=0),$N$4,IF(AND(COUNTIF($J$2:$J$10,$N$5)>=1,COUNTIF($K$2:K11,$N$5)=0),$N$5,IF(AND(COUNTIF($J$2:$J$10,$N$6)>=1,COUNTIF($K$2:K11,$N$6)=0),$N$6,IF(AND(COUNTIF($J$2:$J$10,$N$7)>=1,COUNTIF($K$2:K11,$N$7)=0),$N$7,IF(AND(COUNTIF($J$2:$J$10,$N$8)>=1,COUNTIF($K$2:K11,$N$8)=0),$N$8,IF(AND(COUNTIF($J$2:$J$10,$N$9)>=1,COUNTIF($K$2:K11,$N$9)=0),$N$9,IF(AND(COUNTIF($J$2:$J$10,$N$10)>=1,COUNTIF($K$2:K11,$N$10)=0),$N$10,IF(AND(COUNTIF($J$2:$J$10,$N$11)>=1,COUNTIF($K$2:K11,$N$11)=0),$N$11,IF(AND(COUNTIF($J$2:$J$10,$N$12)>=1,COUNTIF($K$2:K11,$N$12)=0),$N$12,IF(AND(COUNTIF($J$2:$J$10,$N$13)>=1,COUNTIF($K$2:K11,$N$13)=0),$N$13,IF(AND(COUNTIF($J$2:$J$10,$N$14)>=1,COUNTIF($K$2:K11,$N$14)=0),$N$14,IF(AND(COUNTIF($J$2:$J$10,$N$15)>=1,COUNTIF($K$2:K11,$N$15)=0),$N$15,IF(AND(COUNTIF($J$2:$J$10,$N$16)>=1,COUNTIF($K$2:K11,$N$16)=0),$N$16,0)))))))))))))))))","v":0},"",null,null,{"$f":"IFERROR(INDEX('Competency Alignment'!E:E,SMALL(IF((IF('Course Competency Tool'!$I$8<>\"\",Competency_Type='Course Competency Tool'!$I$8,TRUE))+(IF('Course Competency Tool'!$O$8<>\"\",Competency='Course Competency Tool'!$O$8,TRUE))+(IF('Course Competency Tool'!$I$11=\"Show All\",1,Program='Course Competency Tool'!$I$11))+(IF('Course Competency Tool'!$O$11=\"Show All\",1,Level='Course Competency Tool'!$O$11))=4,ROW(Level)),ROW('Competency Alignment'!D13))),\"\")","v":""},0,1,0]
[{"$f":"IFERROR(INDEX(Competency_Type,MATCH(0,COUNTIF($A$2:$A12,Competency_Type),0)),0)","v":0},"",{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C12,Competency),\"\"),0)),0)","v":0},null,"",null,{"$f":"IFERROR(INDEX(OFFSET('Competency Alignment'!$C$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,1),MATCH(0,IF('Course Competency Tool'!$O$8=OFFSET('Competency Alignment'!$B$2,0,0,COUNTA('Competency Alignment'!$B:$B)-1,1),COUNTIF($G$3:$G12,OFFSET('Competency Alignment'!$C$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,1)),\"\"),0)),0)","v":0},"",null,{"$f":"IFERROR(IF('Course Competency Tool'!$I$11=\"Show All\",INDEX(OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,4),MATCH(1,((OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,1)='Course Competency Tool'!$I$8)*(OFFSET('Competency Alignment'!$B$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,1)='Course Competency Tool'!$O$8))+IF('Course Competency Tool'!$O$8=Competency,COUNTIF($J$3:$J12,Level)),0),4),INDEX(OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,4),MATCH(1,((OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,1)='Course Competency Tool'!$I$8)*(OFFSET('Competency Alignment'!$B$2,0,0,COUNTA('Competency Alignment'!$B:$B)-1,1)='Course Competency Tool'!$O$8)*(OFFSET('Competency Alignment'!$C$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,1)='Course Competency Tool'!$I$11))+IF('Course Competency Tool'!$O$8=Competency,COUNTIF($J$3:$J12,Level)),0),4)),0)","v":0},{"$f":"IF(IFERROR(VLOOKUP('Course Competency Tool'!$O$8,'INPUT TAB'!$C:$E,3,FALSE),0)<>2,0,IF(IFERROR(VLOOKUP('Course Competency Tool'!$I$11,'INPUT TAB'!$G:$H,2,FALSE),0)<>2,0,IF(AND(COUNTIF($J$2:$J$10,$N$2)>=1,COUNTIF($K$2:K12,$N$2)=0),$N$2,IF(AND(COUNTIF($J$2:$J$10,$N$3)>=1,COUNTIF($K$2:K12,$N$3)=0),$N$3,IF(AND(COUNTIF($J$2:$J$10,$N$4)>=1,COUNTIF($K$2:K12,$N$4)=0),$N$4,IF(AND(COUNTIF($J$2:$J$10,$N$5)>=1,COUNTIF($K$2:K12,$N$5)=0),$N$5,IF(AND(COUNTIF($J$2:$J$10,$N$6)>=1,COUNTIF($K$2:K12,$N$6)=0),$N$6,IF(AND(COUNTIF($J$2:$J$10,$N$7)>=1,COUNTIF($K$2:K12,$N$7)=0),$N$7,IF(AND(COUNTIF($J$2:$J$10,$N$8)>=1,COUNTIF($K$2:K12,$N$8)=0),$N$8,IF(AND(COUNTIF($J$2:$J$10,$N$9)>=1,COUNTIF($K$2:K12,$N$9)=0),$N$9,IF(AND(COUNTIF($J$2:$J$10,$N$10)>=1,COUNTIF($K$2:K12,$N$10)=0),$N$10,IF(AND(COUNTIF($J$2:$J$10,$N$11)>=1,COUNTIF($K$2:K12,$N$11)=0),$N$11,IF(AND(COUNTIF($J$2:$J$10,$N$12)>=1,COUNTIF($K$2:K12,$N$12)=0),$N$12,IF(AND(COUNTIF($J$2:$J$10,$N$13)>=1,COUNTIF($K$2:K12,$N$13)=0),$N$13,IF(AND(COUNTIF($J$2:$J$10,$N$14)>=1,COUNTIF($K$2:K12,$N$14)=0),$N$14,IF(AND(COUNTIF($J$2:$J$10,$N$15)>=1,COUNTIF($K$2:K12,$N$15)=0),$N$15,IF(AND(COUNTIF($J$2:$J$10,$N$16)>=1,COUNTIF($K$2:K12,$N$16)=0),$N$16,0)))))))))))))))))","v":0},"",null,null,{"$f":"IFERROR(INDEX('Competency Alignment'!E:E,SMALL(IF((IF('Course Competency Tool'!$I$8<>\"\",Competency_Type='Course Competency Tool'!$I$8,TRUE))+(IF('Course Competency Tool'!$O$8<>\"\",Competency='Course Competency Tool'!$O$8,TRUE))+(IF('Course Competency Tool'!$I$11=\"Show All\",1,Program='Course Competency Tool'!$I$11))+(IF('Course Competency Tool'!$O$11=\"Show All\",1,Level='Course Competency Tool'!$O$11))=4,ROW(Level)),ROW('Competency Alignment'!D14))),\"\")","v":""},0,1,0]
[{"$f":"IFERROR(INDEX(Competency_Type,MATCH(0,COUNTIF($A$2:$A13,Competency_Type),0)),0)","v":0},"",{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C13,Competency),\"\"),0)),0)","v":0},null,"",null,{"$f":"IFERROR(INDEX(OFFSET('Competency Alignment'!$C$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,1),MATCH(0,IF('Course Competency Tool'!$O$8=OFFSET('Competency Alignment'!$B$2,0,0,COUNTA('Competency Alignment'!$B:$B)-1,1),COUNTIF($G$3:$G13,OFFSET('Competency Alignment'!$C$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,1)),\"\"),0)),0)","v":0},"",null,{"$f":"IFERROR(IF('Course Competency Tool'!$I$11=\"Show All\",INDEX(OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,4),MATCH(1,((OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,1)='Course Competency Tool'!$I$8)*(OFFSET('Competency Alignment'!$B$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,1)='Course Competency Tool'!$O$8))+IF('Course Competency Tool'!$O$8=Competency,COUNTIF($J$3:$J13,Level)),0),4),INDEX(OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,4),MATCH(1,((OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,1)='Course Competency Tool'!$I$8)*(OFFSET('Competency Alignment'!$B$2,0,0,COUNTA('Competency Alignment'!$B:$B)-1,1)='Course Competency Tool'!$O$8)*(OFFSET('Competency Alignment'!$C$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,1)='Course Competency Tool'!$I$11))+IF('Course Competency Tool'!$O$8=Competency,COUNTIF($J$3:$J13,Level)),0),4)),0)","v":0},{"$f":"IF(IFERROR(VLOOKUP('Course Competency Tool'!$O$8,'INPUT TAB'!$C:$E,3,FALSE),0)<>2,0,IF(IFERROR(VLOOKUP('Course Competency Tool'!$I$11,'INPUT TAB'!$G:$H,2,FALSE),0)<>2,0,IF(AND(COUNTIF($J$2:$J$10,$N$2)>=1,COUNTIF($K$2:K13,$N$2)=0),$N$2,IF(AND(COUNTIF($J$2:$J$10,$N$3)>=1,COUNTIF($K$2:K13,$N$3)=0),$N$3,IF(AND(COUNTIF($J$2:$J$10,$N$4)>=1,COUNTIF($K$2:K13,$N$4)=0),$N$4,IF(AND(COUNTIF($J$2:$J$10,$N$5)>=1,COUNTIF($K$2:K13,$N$5)=0),$N$5,IF(AND(COUNTIF($J$2:$J$10,$N$6)>=1,COUNTIF($K$2:K13,$N$6)=0),$N$6,IF(AND(COUNTIF($J$2:$J$10,$N$7)>=1,COUNTIF($K$2:K13,$N$7)=0),$N$7,IF(AND(COUNTIF($J$2:$J$10,$N$8)>=1,COUNTIF($K$2:K13,$N$8)=0),$N$8,IF(AND(COUNTIF($J$2:$J$10,$N$9)>=1,COUNTIF($K$2:K13,$N$9)=0),$N$9,IF(AND(COUNTIF($J$2:$J$10,$N$10)>=1,COUNTIF($K$2:K13,$N$10)=0),$N$10,IF(AND(COUNTIF($J$2:$J$10,$N$11)>=1,COUNTIF($K$2:K13,$N$11)=0),$N$11,IF(AND(COUNTIF($J$2:$J$10,$N$12)>=1,COUNTIF($K$2:K13,$N$12)=0),$N$12,IF(AND(COUNTIF($J$2:$J$10,$N$13)>=1,COUNTIF($K$2:K13,$N$13)=0),$N$13,IF(AND(COUNTIF($J$2:$J$10,$N$14)>=1,COUNTIF($K$2:K13,$N$14)=0),$N$14,IF(AND(COUNTIF($J$2:$J$10,$N$15)>=1,COUNTIF($K$2:K13,$N$15)=0),$N$15,IF(AND(COUNTIF($J$2:$J$10,$N$16)>=1,COUNTIF($K$2:K13,$N$16)=0),$N$16,0)))))))))))))))))","v":0},"",null,null,{"$f":"IFERROR(INDEX('Competency Alignment'!E:E,SMALL(IF((IF('Course Competency Tool'!$I$8<>\"\",Competency_Type='Course Competency Tool'!$I$8,TRUE))+(IF('Course Competency Tool'!$O$8<>\"\",Competency='Course Competency Tool'!$O$8,TRUE))+(IF('Course Competency Tool'!$I$11=\"Show All\",1,Program='Course Competency Tool'!$I$11))+(IF('Course Competency Tool'!$O$11=\"Show All\",1,Level='Course Competency Tool'!$O$11))=4,ROW(Level)),ROW('Competency Alignment'!D15))),\"\")","v":""},0,1,0]
[{"$f":"IFERROR(INDEX(Competency_Type,MATCH(0,COUNTIF($A$2:$A14,Competency_Type),0)),0)","v":0},"",{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C14,Competency),\"\"),0)),0)","v":0},null,"",null,{"$f":"IFERROR(INDEX(OFFSET('Competency Alignment'!$C$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,1),MATCH(0,IF('Course Competency Tool'!$O$8=OFFSET('Competency Alignment'!$B$2,0,0,COUNTA('Competency Alignment'!$B:$B)-1,1),COUNTIF($G$3:$G14,OFFSET('Competency Alignment'!$C$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,1)),\"\"),0)),0)","v":0},"",null,{"$f":"IFERROR(IF('Course Competency Tool'!$I$11=\"Show All\",INDEX(OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,4),MATCH(1,((OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,1)='Course Competency Tool'!$I$8)*(OFFSET('Competency Alignment'!$B$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,1)='Course Competency Tool'!$O$8))+IF('Course Competency Tool'!$O$8=Competency,COUNTIF($J$3:$J14,Level)),0),4),INDEX(OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,4),MATCH(1,((OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,1)='Course Competency Tool'!$I$8)*(OFFSET('Competency Alignment'!$B$2,0,0,COUNTA('Competency Alignment'!$B:$B)-1,1)='Course Competency Tool'!$O$8)*(OFFSET('Competency Alignment'!$C$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,1)='Course Competency Tool'!$I$11))+IF('Course Competency Tool'!$O$8=Competency,COUNTIF($J$3:$J14,Level)),0),4)),0)","v":0},{"$f":"IF(IFERROR(VLOOKUP('Course Competency Tool'!$O$8,'INPUT TAB'!$C:$E,3,FALSE),0)<>2,0,IF(IFERROR(VLOOKUP('Course Competency Tool'!$I$11,'INPUT TAB'!$G:$H,2,FALSE),0)<>2,0,IF(AND(COUNTIF($J$2:$J$10,$N$2)>=1,COUNTIF($K$2:K14,$N$2)=0),$N$2,IF(AND(COUNTIF($J$2:$J$10,$N$3)>=1,COUNTIF($K$2:K14,$N$3)=0),$N$3,IF(AND(COUNTIF($J$2:$J$10,$N$4)>=1,COUNTIF($K$2:K14,$N$4)=0),$N$4,IF(AND(COUNTIF($J$2:$J$10,$N$5)>=1,COUNTIF($K$2:K14,$N$5)=0),$N$5,IF(AND(COUNTIF($J$2:$J$10,$N$6)>=1,COUNTIF($K$2:K14,$N$6)=0),$N$6,IF(AND(COUNTIF($J$2:$J$10,$N$7)>=1,COUNTIF($K$2:K14,$N$7)=0),$N$7,IF(AND(COUNTIF($J$2:$J$10,$N$8)>=1,COUNTIF($K$2:K14,$N$8)=0),$N$8,IF(AND(COUNTIF($J$2:$J$10,$N$9)>=1,COUNTIF($K$2:K14,$N$9)=0),$N$9,IF(AND(COUNTIF($J$2:$J$10,$N$10)>=1,COUNTIF($K$2:K14,$N$10)=0),$N$10,IF(AND(COUNTIF($J$2:$J$10,$N$11)>=1,COUNTIF($K$2:K14,$N$11)=0),$N$11,IF(AND(COUNTIF($J$2:$J$10,$N$12)>=1,COUNTIF($K$2:K14,$N$12)=0),$N$12,IF(AND(COUNTIF($J$2:$J$10,$N$13)>=1,COUNTIF($K$2:K14,$N$13)=0),$N$13,IF(AND(COUNTIF($J$2:$J$10,$N$14)>=1,COUNTIF($K$2:K14,$N$14)=0),$N$14,IF(AND(COUNTIF($J$2:$J$10,$N$15)>=1,COUNTIF($K$2:K14,$N$15)=0),$N$15,IF(AND(COUNTIF($J$2:$J$10,$N$16)>=1,COUNTIF($K$2:K14,$N$16)=0),$N$16,0)))))))))))))))))","v":0},"",null,null,{"$f":"IFERROR(INDEX('Competency Alignment'!E:E,SMALL(IF((IF('Course Competency Tool'!$I$8<>\"\",Competency_Type='Course Competency Tool'!$I$8,TRUE))+(IF('Course Competency Tool'!$O$8<>\"\",Competency='Course Competency Tool'!$O$8,TRUE))+(IF('Course Competency Tool'!$I$11=\"Show All\",1,Program='Course Competency Tool'!$I$11))+(IF('Course Competency Tool'!$O$11=\"Show All\",1,Level='Course Competency Tool'!$O$11))=4,ROW(Level)),ROW('Competency Alignment'!D17))),\"\")","v":""},0,1,0]
[{"$f":"IFERROR(INDEX(Competency_Type,MATCH(0,COUNTIF($A$2:$A15,Competency_Type),0)),0)","v":0},"",{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C15,Competency),\"\"),0)),0)","v":0},null,"",null,{"$f":"IFERROR(INDEX(OFFSET('Competency Alignment'!$C$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,1),MATCH(0,IF('Course Competency Tool'!$O$8=OFFSET('Competency Alignment'!$B$2,0,0,COUNTA('Competency Alignment'!$B:$B)-1,1),COUNTIF($G$3:$G15,OFFSET('Competency Alignment'!$C$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,1)),\"\"),0)),0)","v":0},"",null,{"$f":"IFERROR(IF('Course Competency Tool'!$I$11=\"Show All\",INDEX(OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,4),MATCH(1,((OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,1)='Course Competency Tool'!$I$8)*(OFFSET('Competency Alignment'!$B$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,1)='Course Competency Tool'!$O$8))+IF('Course Competency Tool'!$O$8=Competency,COUNTIF($J$3:$J15,Level)),0),4),INDEX(OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,4),MATCH(1,((OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,1)='Course Competency Tool'!$I$8)*(OFFSET('Competency Alignment'!$B$2,0,0,COUNTA('Competency Alignment'!$B:$B)-1,1)='Course Competency Tool'!$O$8)*(OFFSET('Competency Alignment'!$C$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,1)='Course Competency Tool'!$I$11))+IF('Course Competency Tool'!$O$8=Competency,COUNTIF($J$3:$J15,Level)),0),4)),0)","v":0},{"$f":"IF(IFERROR(VLOOKUP('Course Competency Tool'!$O$8,'INPUT TAB'!$C:$E,3,FALSE),0)<>2,0,IF(IFERROR(VLOOKUP('Course Competency Tool'!$I$11,'INPUT TAB'!$G:$H,2,FALSE),0)<>2,0,IF(AND(COUNTIF($J$2:$J$10,$N$2)>=1,COUNTIF($K$2:K15,$N$2)=0),$N$2,IF(AND(COUNTIF($J$2:$J$10,$N$3)>=1,COUNTIF($K$2:K15,$N$3)=0),$N$3,IF(AND(COUNTIF($J$2:$J$10,$N$4)>=1,COUNTIF($K$2:K15,$N$4)=0),$N$4,IF(AND(COUNTIF($J$2:$J$10,$N$5)>=1,COUNTIF($K$2:K15,$N$5)=0),$N$5,IF(AND(COUNTIF($J$2:$J$10,$N$6)>=1,COUNTIF($K$2:K15,$N$6)=0),$N$6,IF(AND(COUNTIF($J$2:$J$10,$N$7)>=1,COUNTIF($K$2:K15,$N$7)=0),$N$7,IF(AND(COUNTIF($J$2:$J$10,$N$8)>=1,COUNTIF($K$2:K15,$N$8)=0),$N$8,IF(AND(COUNTIF($J$2:$J$10,$N$9)>=1,COUNTIF($K$2:K15,$N$9)=0),$N$9,IF(AND(COUNTIF($J$2:$J$10,$N$10)>=1,COUNTIF($K$2:K15,$N$10)=0),$N$10,IF(AND(COUNTIF($J$2:$J$10,$N$11)>=1,COUNTIF($K$2:K15,$N$11)=0),$N$11,IF(AND(COUNTIF($J$2:$J$10,$N$12)>=1,COUNTIF($K$2:K15,$N$12)=0),$N$12,IF(AND(COUNTIF($J$2:$J$10,$N$13)>=1,COUNTIF($K$2:K15,$N$13)=0),$N$13,IF(AND(COUNTIF($J$2:$J$10,$N$14)>=1,COUNTIF($K$2:K15,$N$14)=0),$N$14,IF(AND(COUNTIF($J$2:$J$10,$N$15)>=1,COUNTIF($K$2:K15,$N$15)=0),$N$15,IF(AND(COUNTIF($J$2:$J$10,$N$16)>=1,COUNTIF($K$2:K15,$N$16)=0),$N$16,0)))))))))))))))))","v":0},"",null,null,{"$f":"IFERROR(INDEX('Competency Alignment'!E:E,SMALL(IF((IF('Course Competency Tool'!$I$8<>\"\",Competency_Type='Course Competency Tool'!$I$8,TRUE))+(IF('Course Competency Tool'!$O$8<>\"\",Competency='Course Competency Tool'!$O$8,TRUE))+(IF('Course Competency Tool'!$I$11=\"Show All\",1,Program='Course Competency Tool'!$I$11))+(IF('Course Competency Tool'!$O$11=\"Show All\",1,Level='Course Competency Tool'!$O$11))=4,ROW(Level)),ROW('Competency Alignment'!D18))),\"\")","v":""},0,1,0]
[{"$f":"IFERROR(INDEX(Competency_Type,MATCH(0,COUNTIF($A$2:$A16,Competency_Type),0)),0)","v":0},"",{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C16,Competency),\"\"),0)),0)","v":0},null,"",null,{"$f":"IFERROR(INDEX(OFFSET('Competency Alignment'!$C$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,1),MATCH(0,IF('Course Competency Tool'!$O$8=OFFSET('Competency Alignment'!$B$2,0,0,COUNTA('Competency Alignment'!$B:$B)-1,1),COUNTIF($G$3:$G16,OFFSET('Competency Alignment'!$C$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,1)),\"\"),0)),0)","v":0},"",null,{"$f":"IFERROR(IF('Course Competency Tool'!$I$11=\"Show All\",INDEX(OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,4),MATCH(1,((OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,1)='Course Competency Tool'!$I$8)*(OFFSET('Competency Alignment'!$B$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,1)='Course Competency Tool'!$O$8))+IF('Course Competency Tool'!$O$8=Competency,COUNTIF($J$3:$J16,Level)),0),4),INDEX(OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,4),MATCH(1,((OFFSET('Competency Alignment'!$A$2,0,0,COUNTA('Competency Alignment'!$A:$A)-1,1)='Course Competency Tool'!$I$8)*(OFFSET('Competency Alignment'!$B$2,0,0,COUNTA('Competency Alignment'!$B:$B)-1,1)='Course Competency Tool'!$O$8)*(OFFSET('Competency Alignment'!$C$2,0,0,COUNTA('Competency Alignment'!$C:$C)-1,1)='Course Competency Tool'!$I$11))+IF('Course Competency Tool'!$O$8=Competency,COUNTIF($J$3:$J16,Level)),0),4)),0)","v":0},{"$f":"IF(IFERROR(VLOOKUP('Course Competency Tool'!$O$8,'INPUT TAB'!$C:$E,3,FALSE),0)<>2,0,IF(IFERROR(VLOOKUP('Course Competency Tool'!$I$11,'INPUT TAB'!$G:$H,2,FALSE),0)<>2,0,IF(AND(COUNTIF($J$2:$J$10,$N$2)>=1,COUNTIF($K$2:K16,$N$2)=0),$N$2,IF(AND(COUNTIF($J$2:$J$10,$N$3)>=1,COUNTIF($K$2:K16,$N$3)=0),$N$3,IF(AND(COUNTIF($J$2:$J$10,$N$4)>=1,COUNTIF($K$2:K16,$N$4)=0),$N$4,IF(AND(COUNTIF($J$2:$J$10,$N$5)>=1,COUNTIF($K$2:K16,$N$5)=0),$N$5,IF(AND(COUNTIF($J$2:$J$10,$N$6)>=1,COUNTIF($K$2:K16,$N$6)=0),$N$6,IF(AND(COUNTIF($J$2:$J$10,$N$7)>=1,COUNTIF($K$2:K16,$N$7)=0),$N$7,IF(AND(COUNTIF($J$2:$J$10,$N$8)>=1,COUNTIF($K$2:K16,$N$8)=0),$N$8,IF(AND(COUNTIF($J$2:$J$10,$N$9)>=1,COUNTIF($K$2:K16,$N$9)=0),$N$9,IF(AND(COUNTIF($J$2:$J$10,$N$10)>=1,COUNTIF($K$2:K16,$N$10)=0),$N$10,IF(AND(COUNTIF($J$2:$J$10,$N$11)>=1,COUNTIF($K$2:K16,$N$11)=0),$N$11,IF(AND(COUNTIF($J$2:$J$10,$N$12)>=1,COUNTIF($K$2:K16,$N$12)=0),$N$12,IF(AND(COUNTIF($J$2:$J$10,$N$13)>=1,COUNTIF($K$2:K16,$N$13)=0),$N$13,IF(AND(COUNTIF($J$2:$J$10,$N$14)>=1,COUNTIF($K$2:K16,$N$14)=0),$N$14,IF(AND(COUNTIF($J$2:$J$10,$N$15)>=1,COUNTIF($K$2:K16,$N$15)=0),$N$15,IF(AND(COUNTIF($J$2:$J$10,$N$16)>=1,COUNTIF($K$2:K16,$N$16)=0),$N$16,0)))))))))))))))))","v":0},"",null,null,{"$f":"IFERROR(INDEX('Competency Alignment'!E:E,SMALL(IF((IF('Course Competency Tool'!$I$8<>\"\",Competency_Type='Course Competency Tool'!$I$8,TRUE))+(IF('Course Competency Tool'!$O$8<>\"\",Competency='Course Competency Tool'!$O$8,TRUE))+(IF('Course Competency Tool'!$I$11=\"Show All\",1,Program='Course Competency Tool'!$I$11))+(IF('Course Competency Tool'!$O$11=\"Show All\",1,Level='Course Competency Tool'!$O$11))=4,ROW(Level)),ROW('Competency Alignment'!D19))),\"\")","v":""},0,1,0]
[{"$f":"IFERROR(INDEX(Competency_Type,MATCH(0,COUNTIF($A$2:$A17,Competency_Type),0)),0)","v":0},"",{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C17,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,"",null,null,{"$f":"IFERROR(INDEX('Competency Alignment'!E:E,SMALL(IF((IF('Course Competency Tool'!$I$8<>\"\",Competency_Type='Course Competency Tool'!$I$8,TRUE))+(IF('Course Competency Tool'!$O$8<>\"\",Competency='Course Competency Tool'!$O$8,TRUE))+(IF('Course Competency Tool'!$I$11=\"Show All\",1,Program='Course Competency Tool'!$I$11))+(IF('Course Competency Tool'!$O$11=\"Show All\",1,Level='Course Competency Tool'!$O$11))=4,ROW(Level)),ROW('Competency Alignment'!D20))),\"\")","v":""},0,1,0]
[{"$f":"IFERROR(INDEX(Competency_Type,MATCH(0,COUNTIF($A$2:$A18,Competency_Type),0)),0)","v":0},"",{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C18,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,"",null,null,{"$f":"IFERROR(INDEX('Competency Alignment'!E:E,SMALL(IF((IF('Course Competency Tool'!$I$8<>\"\",Competency_Type='Course Competency Tool'!$I$8,TRUE))+(IF('Course Competency Tool'!$O$8<>\"\",Competency='Course Competency Tool'!$O$8,TRUE))+(IF('Course Competency Tool'!$I$11=\"Show All\",1,Program='Course Competency Tool'!$I$11))+(IF('Course Competency Tool'!$O$11=\"Show All\",1,Level='Course Competency Tool'!$O$11))=4,ROW(Level)),ROW('Competency Alignment'!D21))),\"\")","v":""},0,1,0]
[{"$f":"IFERROR(INDEX(Competency_Type,MATCH(0,COUNTIF($A$2:$A19,Competency_Type),0)),0)","v":0},"",{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C19,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,"",null,null,{"$f":"IFERROR(INDEX('Competency Alignment'!E:E,SMALL(IF((IF('Course Competency Tool'!$I$8<>\"\",Competency_Type='Course Competency Tool'!$I$8,TRUE))+(IF('Course Competency Tool'!$O$8<>\"\",Competency='Course Competency Tool'!$O$8,TRUE))+(IF('Course Competency Tool'!$I$11=\"Show All\",1,Program='Course Competency Tool'!$I$11))+(IF('Course Competency Tool'!$O$11=\"Show All\",1,Level='Course Competency Tool'!$O$11))=4,ROW(Level)),ROW('Competency Alignment'!D22))),\"\")","v":""},0,1,0]
[null,2,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C20,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,"",null,null,{"$f":"IFERROR(INDEX('Competency Alignment'!E:E,SMALL(IF((IF('Course Competency Tool'!$I$8<>\"\",Competency_Type='Course Competency Tool'!$I$8,TRUE))+(IF('Course Competency Tool'!$O$8<>\"\",Competency='Course Competency Tool'!$O$8,TRUE))+(IF('Course Competency Tool'!$I$11=\"Show All\",1,Program='Course Competency Tool'!$I$11))+(IF('Course Competency Tool'!$O$11=\"Show All\",1,Level='Course Competency Tool'!$O$11))=4,ROW(Level)),ROW('Competency Alignment'!D23))),\"\")","v":""},0,1,0]
[null,2,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C21,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,{"$f":"COUNTIF($J$3:$J6,Level)","v":0},null,"",null,null,{"$f":"IFERROR(INDEX('Competency Alignment'!E:E,SMALL(IF((IF('Course Competency Tool'!$I$8<>\"\",Competency_Type='Course Competency Tool'!$I$8,TRUE))+(IF('Course Competency Tool'!$O$8<>\"\",Competency='Course Competency Tool'!$O$8,TRUE))+(IF('Course Competency Tool'!$I$11=\"Show All\",1,Program='Course Competency Tool'!$I$11))+(IF('Course Competency Tool'!$O$11=\"Show All\",1,Level='Course Competency Tool'!$O$11))=4,ROW(Level)),ROW('Competency Alignment'!D24))),\"\")","v":""},0,1,0]
["Error Message:",null,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C22,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,"",null,null,{"$f":"IFERROR(INDEX('Competency Alignment'!E:E,SMALL(IF((IF('Course Competency Tool'!$I$8<>\"\",Competency_Type='Course Competency Tool'!$I$8,TRUE))+(IF('Course Competency Tool'!$O$8<>\"\",Competency='Course Competency Tool'!$O$8,TRUE))+(IF('Course Competency Tool'!$I$11=\"Show All\",1,Program='Course Competency Tool'!$I$11))+(IF('Course Competency Tool'!$O$11=\"Show All\",1,Level='Course Competency Tool'!$O$11))=4,ROW(Level)),ROW('Competency Alignment'!D25))),\"\")","v":""},0,1,0]
["Please review the data inputs, from Step #1 through Step #4.",null,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C23,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,"",null,null,{"$f":"IFERROR(INDEX('Competency Alignment'!E:E,SMALL(IF((IF('Course Competency Tool'!$I$8<>\"\",Competency_Type='Course Competency Tool'!$I$8,TRUE))+(IF('Course Competency Tool'!$O$8<>\"\",Competency='Course Competency Tool'!$O$8,TRUE))+(IF('Course Competency Tool'!$I$11=\"Show All\",1,Program='Course Competency Tool'!$I$11))+(IF('Course Competency Tool'!$O$11=\"Show All\",1,Level='Course Competency Tool'!$O$11))=4,ROW(Level)),ROW('Competency Alignment'!D26))),\"\")","v":""},0,1,0]
["Check inputs for Step #1 through Step #4.",null,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C24,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,"",null,null,{"$f":"IFERROR(INDEX('Competency Alignment'!E:E,SMALL(IF((IF('Course Competency Tool'!$I$8<>\"\",Competency_Type='Course Competency Tool'!$I$8,TRUE))+(IF('Course Competency Tool'!$O$8<>\"\",Competency='Course Competency Tool'!$O$8,TRUE))+(IF('Course Competency Tool'!$I$11=\"Show All\",1,Program='Course Competency Tool'!$I$11))+(IF('Course Competency Tool'!$O$11=\"Show All\",1,Level='Course Competency Tool'!$O$11))=4,ROW(Level)),ROW('Competency Alignment'!D27))),\"\")","v":""},0,1,0]
[{"$f":"\"Please review Step #1 through Step #4.\"&CHAR(1)&CHAR(1)&CHAR(1)","v":"Please review Step #1 through Step #4.\u0001\u0001\u0001"},null,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C25,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,"",null,null,{"$f":"IFERROR(INDEX('Competency Alignment'!E:E,SMALL(IF((IF('Course Competency Tool'!$I$8<>\"\",Competency_Type='Course Competency Tool'!$I$8,TRUE))+(IF('Course Competency Tool'!$O$8<>\"\",Competency='Course Competency Tool'!$O$8,TRUE))+(IF('Course Competency Tool'!$I$11=\"Show All\",1,Program='Course Competency Tool'!$I$11))+(IF('Course Competency Tool'!$O$11=\"Show All\",1,Level='Course Competency Tool'!$O$11))=4,ROW(Level)),ROW('Competency Alignment'!D28))),\"\")","v":""},0,1,0]
[{"$f":"\"\"&CHAR(1)&CHAR(1)&CHAR(1)&CHAR(1)&CHAR(1)&CHAR(1)&CHAR(1)&CHAR(1)&CHAR(1)&CHAR(1)&CHAR(1)&CHAR(1)&CHAR(1)&CHAR(1)&CHAR(1)&CHAR(1)&CHAR(1)&CHAR(1)&CHAR(1)&CHAR(1)&CHAR(1)&CHAR(1)&CHAR(1)","v":"\u0001\u0001\u0001\u0001\u0001\u0001\u0001\u0001\u0001\u0001\u0001\u0001\u0001\u0001\u0001\u0001\u0001\u0001\u0001\u0001\u0001\u0001\u0001"},null,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C26,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,"",null,null,{"$f":"IFERROR(INDEX('Competency Alignment'!E:E,SMALL(IF((IF('Course Competency Tool'!$I$8<>\"\",Competency_Type='Course Competency Tool'!$I$8,TRUE))+(IF('Course Competency Tool'!$O$8<>\"\",Competency='Course Competency Tool'!$O$8,TRUE))+(IF('Course Competency Tool'!$I$11=\"Show All\",1,Program='Course Competency Tool'!$I$11))+(IF('Course Competency Tool'!$O$11=\"Show All\",1,Level='Course Competency Tool'!$O$11))=4,ROW(Level)),ROW('Competency Alignment'!D30))),\"\")","v":""},0,1,0]
[null,null,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C27,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,"",null,null,{"$f":"IFERROR(INDEX('Competency Alignment'!E:E,SMALL(IF((IF('Course Competency Tool'!$I$8<>\"\",Competency_Type='Course Competency Tool'!$I$8,TRUE))+(IF('Course Competency Tool'!$O$8<>\"\",Competency='Course Competency Tool'!$O$8,TRUE))+(IF('Course Competency Tool'!$I$11=\"Show All\",1,Program='Course Competency Tool'!$I$11))+(IF('Course Competency Tool'!$O$11=\"Show All\",1,Level='Course Competency Tool'!$O$11))=4,ROW(Level)),ROW('Competency Alignment'!D31))),\"\")","v":""},0,1,0]
[null,null,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C28,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,"",null,null,{"$f":"IFERROR(INDEX('Competency Alignment'!E:E,SMALL(IF((IF('Course Competency Tool'!$I$8<>\"\",Competency_Type='Course Competency Tool'!$I$8,TRUE))+(IF('Course Competency Tool'!$O$8<>\"\",Competency='Course Competency Tool'!$O$8,TRUE))+(IF('Course Competency Tool'!$I$11=\"Show All\",1,Program='Course Competency Tool'!$I$11))+(IF('Course Competency Tool'!$O$11=\"Show All\",1,Level='Course Competency Tool'!$O$11))=4,ROW(Level)),ROW('Competency Alignment'!D32))),\"\")","v":""},0,1,0]
[null,null,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C29,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,"",null,null,{"$f":"IFERROR(INDEX('Competency Alignment'!E:E,SMALL(IF((IF('Course Competency Tool'!$I$8<>\"\",Competency_Type='Course Competency Tool'!$I$8,TRUE))+(IF('Course Competency Tool'!$O$8<>\"\",Competency='Course Competency Tool'!$O$8,TRUE))+(IF('Course Competency Tool'!$I$11=\"Show All\",1,Program='Course Competency Tool'!$I$11))+(IF('Course Competency Tool'!$O$11=\"Show All\",1,Level='Course Competency Tool'!$O$11))=4,ROW(Level)),ROW('Competency Alignment'!D33))),\"\")","v":""},0,1,0]
[null,null,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C30,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,"",null,null,null,null,{"$f":"SUM(Q2:Q30)","v":28}]
[null,null,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C31,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,""]
[null,null,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C32,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,""]
[null,null,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C33,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,""]
[null,null,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C34,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,""]
[null,null,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C35,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,""]
[null,null,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C36,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,""]
[null,null,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C37,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,""]
[null,null,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C38,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,""]
[null,null,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C39,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,""]
[null,null,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C40,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,""]
[null,null,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C41,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,""]
[null,null,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C42,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,""]
[null,null,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C43,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,""]
[null,null,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C44,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,""]
[null,null,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C45,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,""]
[null,null,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C46,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,""]
[null,null,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C47,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,""]
[null,null,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C48,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,""]
[null,null,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C49,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,""]
[null,null,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C50,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,""]
[null,null,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C51,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,""]
[null,null,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C52,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,""]
[null,null,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C53,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,""]
[null,null,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C54,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,""]
[null,null,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C55,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,""]
[null,null,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C56,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,""]
[null,null,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C57,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,""]
[null,null,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C58,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,""]
[null,null,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C59,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,""]
[null,null,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C60,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,""]
[null,null,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C61,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,""]
[null,null,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C62,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,""]
[null,null,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C63,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,""]
[null,null,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C64,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,""]
[null,null,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C65,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,""]
[null,null,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C66,Competency),\"\"),0)),0)","v":0},null,"",null,null,{"$f":"IF(AND(G67<>\"\",G67<>0),2,\"\")","v":""},null,null,null,{"$f":"IF(AND(K67<>\"\",K67<>0),2,\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C67,Competency),\"\"),0)),0)","v":0},null,{"$f":"IF(AND(C68<>0,C68<>\"\"),2,\"\")","v":""},null,null,"",null,null,null,""]
[null,null,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C68,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,""]
[null,null,{"$f":"IFERROR(INDEX(Competency,MATCH(0,IF('Course Competency Tool'!$I$8=Competency_Type,COUNTIF($C$2:$C69,Competency),\"\"),0)),0)","v":0},null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,"",null,null,null,""]
[null,null,null,null,"",null,null,{"$f":"IF(AND(G131<>\"\",G131<>0),2,\"\")","v":""},null,null,null,{"$f":"IF(AND(K131<>\"\",K131<>0),2,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(C132<>0,C132<>\"\"),2,\"\")","v":""},null,null,{"$f":"IF(AND(G132<>\"\",G132<>0),2,\"\")","v":""},null,null,null,{"$f":"IF(AND(K132<>\"\",K132<>0),2,\"\")","v":""}]

{"sheet":"Competency Alignment","index":2,"n_rows":453,"n_cols":9,"rows_kept":453,"cut":false,"hidden":true,"merged":[]}
["Competency Type","Competency","Program","Level","Courses","Course CLPs","FY16 Course Names & IDs","FY16 Course CLPs","Delivery Method"]
["FAI/DAU Technical Competencies","Activity Program Coordinator for Purchase Card","FAC-C","I","CON 100 (FED) - Shaping Smart Business Arrangements",16,"CON 100 - Shaping Smart Business Arrangements",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Activity Program Coordinator for Purchase Card","FAC-C","II","CON 216 (FED) - Legal Considerations in Contracting",40,"CON 216 - Legal Considerations in Contracting",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Activity Program Coordinator for Purchase Card","Continuous Learning","Available For All Levels","FQN 423 - Simplified Acquisitions",24,"FQN 113 - Simplified Acquisitions",24,"Instructor Led"]
["FAI/DAU Technical Competencies","Addressing Small Business Concerns","FAC-C","I","CON 121 (FED) - Contract Planning",16,"CON 121 - Contract Planning",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Addressing Small Business Concerns","FAC-C","I","CON 124 (FED) - Contract Execution",16,"CON 124 - Contract Execution",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Addressing Small Business Concerns","FAC-C","I","CON 127 (FED) - Contract Management",16,"CON 127 - Contract Management",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Addressing Small Business Concerns","FAC-C","II","CON 200 (FED) - Business Decisions for Contracting",24,"CON 200 - Business Decisions For Contracting",24,"Instructor Led"]
["FAI/DAU Technical Competencies","Addressing Small Business Concerns","Continuous Learning","III Elective","CON 243 (FED) - Architect-Engineer Services Contracting",40,"CON 243 - Architect-Engineer Services Contracting",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Addressing Small Business Concerns","FAC-C","II","CON 280 (FED) - Source Selection and the Administration of Service Contracts",80,"CON 280 - Source Selection and the Administration of Service Contracts",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Addressing Small Business Concerns","Continuous Learning","Available For All Levels","FCL-VA-0026 - Vets First Contracting: Tiered Evaluations",2,"N/A","N/A","Web-based (Blackboard)"]
["FAI/DAU Technical Competencies","Addressing Small Business Concerns","Continuous Learning","Available For All Levels","FCL-VA-0034 - Applying The Veterans First Contracting Program",2.5,"N/A","N/A","Web-based (Blackboard)"]
["FAI/DAU Technical Competencies","Addressing Small Business Concerns","Continuous Learning","III Elective","FCN 543 - Architect and Engineer Refresher",24,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Addressing Small Business Concerns","Continuous Learning","Available For All Levels","FQN 405 - Market Research and Commercial Items",24,"FQN 110 - Market Research and Commercial Items",24,"Instructor Led"]
["FAI/DAU Technical Competencies","Addressing Small Business Concerns","Continuous Learning","Available For All Levels","FQN 423 - Simplified Acquisitions",24,"FQN 113 - Simplified Acquisitions",24,"Instructor Led"]
["FAI/DAU Technical Competencies","Addressing Small Business Concerns","Continuous Learning","Available For All Levels","FQN 481 - Applied Simplified Acquisition Procedures (ASAP)",16,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Advanced Cost and/or Price Analysis","FAC-C","III Elective","ACQ 265 (FED) - Mission-Focused Services Acquisition",32,"ACQ 265 - Mission-Focused Services Acquisition",28,"Instructor Led"]
["FAI/DAU Technical Competencies","Advanced Cost and/or Price Analysis","FAC-C","I","CON 121 (FED) - Contract Planning",16,"CON 121 - Contract Planning",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Advanced Cost and/or Price Analysis","FAC-C","I","CON 124 (FED) - Contract Execution",16,"CON 124 - Contract Execution",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Advanced Cost and/or Price Analysis","FAC-C","I","CON 127 (FED) - Contract Management",16,"CON 127 - Contract Management",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Advanced Cost and/or Price Analysis","FAC-C","I","CON 170 (FED) - Fundamentals of Cost and Price Analysis",64,"CON 170 - Fundamentals of Cost and Price Analysis",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Advanced Cost and/or Price Analysis","FAC-C","II","CON 216 (FED) - Legal Considerations in Contracting",40,"CON 216 - Legal Considerations in Contracting",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Advanced Cost and/or Price Analysis","FAC-C","III","CON 244 (FED) - Construction Contracting",40,"CON 244 - Construction Contracting",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Advanced Cost and/or Price Analysis","FAC-C","II","CON 270 (FED) - Intermediate Cost and Price Analysis",80,"CON 270 - Intermediate Cost and Price Analysis",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Advanced Cost and/or Price Analysis","FAC-C","II","CON 280 (FED) - Source Selection and the Administration of Service Contracts",80,"CON 280 - Source Selection and the Administration of Service Contracts",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Advanced Cost and/or Price Analysis","FAC-C","II","CON 290 (FED) - Contract Administration and Negotiation Techniques in a Supply Environment",80,"CON 290 - Contract Administration and Negotiation Techniques in a Supply Environment",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Advanced Cost and/or Price Analysis","FAC-C","III","CON 370 (FED) - Advanced Contract Pricing ",74,"CON 370 - Advanced Contract Pricing ",74,"Instructor Led"]
["FAI/DAU Technical Competencies","Advanced Cost and/or Price Analysis","Continuous Learning","III Elective","FCN 408 - Cost and Price Analysis of Lease Proposals",40,"FCN 408 - Cost and Price Analysis of Lease Proposals",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Advanced Cost and/or Price Analysis","Continuous Learning","III Elective","FCN 244 - Construction Contracting Refresher",24,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Approve Payment Requests","FAC-C","I","CON 100 (FED) - Shaping Smart Business Arrangements",16,"CON 100 - Shaping Smart Business Arrangements",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Approve Payment Requests","FAC-C","I","CON 121 (FED) - Contract Planning",16,"CON 121 - Contract Planning",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Approve Payment Requests","FAC-C","I","CON 124 (FED) - Contract Execution",16,"CON 124 - Contract Execution",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Approve Payment Requests","FAC-C","I","CON 127 (FED) - Contract Management",16,"CON 127 - Contract Management",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Approve Payment Requests","FAC-C","II","CON 216 (FED) - Legal Considerations in Contracting",40,"CON 216 - Legal Considerations in Contracting",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Approve Payment Requests","FAC-C","II","CON 290 (FED) - Contract Administration and Negotiation Techniques in a Supply Environment",80,"CON 290 - Contract Administration and Negotiation Techniques in a Supply Environment",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Approve Payment Requests","Continuous Learning","III Elective","FCN 400 - Emergency Contracting Basics",16,"FCN 400 - Emergency Contracting Basics",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Bid Evaluation (Sealed Bidding)","FAC-C","I","CON 121 (FED) - Contract Planning",16,"CON 121 - Contract Planning",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Bid Evaluation (Sealed Bidding)","FAC-C","I","CON 124 (FED) - Contract Execution",16,"CON 124 - Contract Execution",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Bid Evaluation (Sealed Bidding)","FAC-C","I","CON 127 (FED) - Contract Management",16,"CON 127 - Contract Management",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Bid Evaluation (Sealed Bidding)","FAC-C","I","CON 170 (FED) - Fundamentals of Cost and Price Analysis",64,"CON 170 - Fundamentals of Cost and Price Analysis",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Bid Evaluation (Sealed Bidding)","FAC-C","II","CON 270 (FED) - Intermediate Cost and Price Analysis",80,"CON 270 - Intermediate Cost and Price Analysis",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Bid Evaluation (Sealed Bidding)","FAC-C","III","CON 360 (FED) - Contracting for Decision Makers",64,"CON 360 - Contracting for Decision Makers",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Bid Evaluation (Sealed Bidding)","Continuous Learning","Available For All Levels","FQN 405 - Market Research and Commercial Items",24,"FQN 110 - Market Research and Commercial Items",24,"Instructor Led"]
["FAI/DAU Technical Competencies","Bid Evaluation (Sealed Bidding)","Continuous Learning","Available For All Levels","FQN 423 - Simplified Acquisitions",24,"FQN 113 - Simplified Acquisitions",24,"Instructor Led"]
["FAI/DAU Technical Competencies","Close-out Contracts","FAC-C","I","CON 121 (FED) - Contract Planning",16,"CON 121 - Contract Planning",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Close-out Contracts","FAC-C","I","CON 124 (FED) - Contract Execution",16,"CON 124 - Contract Execution",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Close-out Contracts","FAC-C","I","CON 127 (FED) - Contract Management",16,"CON 127 - Contract Management",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Close-out Contracts","Continuous Learning","III Elective","CON 243 (FED) - Architect-Engineer Services Contracting",40,"CON 243 - Architect-Engineer Services Contracting",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Close-out Contracts","FAC-C","II","CON 290 (FED) - Contract Administration and Negotiation Techniques in a Supply Environment",80,"CON 290 - Contract Administration and Negotiation Techniques in a Supply Environment",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Close-out Contracts","Continuous Learning","III Elective","FCN 400 - Emergency Contracting Basics",16,"FCN 400 - Emergency Contracting Basics",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Close-out Contracts","Continuous Learning","III Elective","FCN 435 - Contract Administration",40,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Close-out Contracts","Continuous Learning","III Elective","FCN 543 - Architect and Engineer Refresher",24,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Close-out Contracts","Continuous Learning","III Elective","FCN 606 - Federal Real Property Leasing Refresher",40,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Consider Socio-economic Requirements ","FAC-C","I","CON 100 (FED) - Shaping Smart Business Arrangements",16,"CON 100 - Shaping Smart Business Arrangements",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Consider Socio-economic Requirements ","FAC-C","I","CON 121 (FED) - Contract Planning",16,"CON 121 - Contract Planning",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Consider Socio-economic Requirements ","FAC-C","I","CON 124 (FED) - Contract Execution",16,"CON 124 - Contract Execution",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Consider Socio-economic Requirements ","FAC-C","I","CON 127 (FED) - Contract Management",16,"CON 127 - Contract Management",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Consider Socio-economic Requirements ","FAC-C","II","CON 200 (FED) - Business Decisions for Contracting",24,"CON 200 - Business Decisions For Contracting",24,"Instructor Led"]
["FAI/DAU Technical Competencies","Consider Socio-economic Requirements ","Continuous Learning","III Elective","CON 243 (FED) - Architect-Engineer Services Contracting",40,"CON 243 - Architect-Engineer Services Contracting",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Consider Socio-economic Requirements ","FAC-C","II","CON 280 (FED) - Source Selection and the Administration of Service Contracts",80,"CON 280 - Source Selection and the Administration of Service Contracts",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Consider Socio-economic Requirements ","FAC-C","II","CON 290 (FED) - Contract Administration and Negotiation Techniques in a Supply Environment",80,"CON 290 - Contract Administration and Negotiation Techniques in a Supply Environment",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Consider Socio-economic Requirements ","Continuous Learning","Available For All Levels","FCL-VA-0026 - Vets First Contracting: Tiered Evaluations",2,"N/A","N/A","Web-based (Blackboard)"]
["FAI/DAU Technical Competencies","Consider Socio-economic Requirements ","Continuous Learning","Available For All Levels","FCL-VA-0034 - Applying The Veterans First Contracting Program",2.5,"N/A","N/A","Web-based (Blackboard)"]
["FAI/DAU Technical Competencies","Consider Socio-economic Requirements ","Continuous Learning","III Elective","FCN 400 - Emergency Contracting Basics",16,"FCN 400 - Emergency Contracting Basics",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Consider Socio-economic Requirements ","Continuous Learning","III Elective","FCN 543 - Architect and Engineer Refresher",16,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Consider Socio-economic Requirements ","Continuous Learning","Available For All Levels","FQN 423 - Simplified Acquisitions",24,"FQN 113 - Simplified Acquisitions",24,"Instructor Led"]
["FAI/DAU Technical Competencies","Consider Socio-economic Requirements ","Continuous Learning","Available For All Levels","FQN 481 - Applied Simplified Acquisition Procedures (ASAP)",16,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Construction/Architect & Engineering (A&E)","Continuous Learning","III Elective","CON 243 (FED) - Architect-Engineer Services Contracting",40,"CON 243 - Architect-Engineer Services Contracting",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Construction/Architect & Engineering (A&E)","FAC-C","III","CON 244 (FED) - Construction Contracting",40,"CON 244 - Construction Contracting",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Construction/Architect & Engineering (A&E)","FAC-C","II","CON 280 (FED) - Source Selection and the Administration of Service Contracts",80,"CON 280 - Source Selection and the Administration of Service Contracts",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Construction/Architect & Engineering (A&E)","Continuous Learning","III Elective","FCN 244 - Construction Contracting Refresher",24,"N.A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Construction/Architect & Engineering (A&E)","Continuous Learning","III Elective","FCN 543 - Architect and Engineer Refresher",24,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Construction/Architect & Engineering (A&E)","Continuous Learning","Available For All Levels","FQN 104 - Construction Claims",24,"FQN 104 - Construction Claims",24,"Instructor Led"]
["FAI/DAU Technical Competencies","Contract Award","FAC-C","I","CON 100 (FED) - Shaping Smart Business Arrangements",16,"CON 100 - Shaping Smart Business Arrangements",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Contract Award","FAC-C","I","CON 121 (FED) - Contract Planning",16,"CON 121 - Contract Planning",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Contract Award","FAC-C","I","CON 124 (FED) - Contract Execution",16,"CON 124 - Contract Execution",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Contract Award","FAC-C","I","CON 127 (FED) - Contract Management",16,"CON 127 - Contract Management",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Contract Award","FAC-C","II","CON 200 (FED) - Business Decisions for Contracting",24,"CON 200 - Business Decisions For Contracting",24,"Instructor Led"]
["FAI/DAU Technical Competencies","Contract Award","FAC-C","II","CON 216 (FED) - Legal Considerations in Contracting",40,"CON 216 - Legal Considerations in Contracting",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Contract Award","Continuous Learning","III Elective","CON 243 (FED) - Architect-Engineer Services Contracting",40,"CON 243 - Architect-Engineer Services Contracting",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Contract Award","FAC-C","III","CON 244 (FED) - Construction Contracting",40,"CON 244 - Construction Contracting",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Contract Award","FAC-C","II","CON 280 (FED) - Source Selection and the Administration of Service Contracts",80,"CON 280 - Source Selection and the Administration of Service Contracts",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Contract Award","FAC-C","II","CON 290 (FED) - Contract Administration and Negotiation Techniques in a Supply Environment",80,"CON 290 - Contract Administration and Negotiation Techniques in a Supply Environment",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Contract Award","FAC-C","I","FCL-VA-0170 - Contract Pricing Determinations Workshop",16,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Contract Award","FAC-C","I","FCL-VA-0170 - Contract Pricing Determinations Workshop",16,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Contract Award","Continuous Learning","III Elective","FCN 244 - Construction Contracting Refresher",24,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Contract Award","Continuous Learning","III Elective","FCN 400 - Emergency Contracting Basics",16,"FCN 400 - Emergency Contracting Basics",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Contract Award","Continuous Learning","III Elective","FCN 543 - Architect and Engineer Refresher",24,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Contract Award","Continuous Learning","III Elective","FCN 606 - Federal Real Property Leasing Refresher",40,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Contract Award","Continuous Learning","Available For All Levels","FFM 421 - Applied Fair and Reasonable Pricing Workshop",16,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Contract Award","Continuous Learning","Available For All Levels","FQN 423 - Simplified Acquisitions",24,"FQN 113 - Simplified Acquisitions",24,"Instructor Led"]
["FAI/DAU Technical Competencies","Contract Award","Continuous Learning","III Elective","FQN 440 - Basic Source Selection",40,"FQN 102 - Basic Source Selection",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Contract Award","Continuous Learning","Available For All Levels","FQN 442 - Best Value Source Selection",16,"FQN 103 - Best Value Source Selection ",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Contract Award","Continuous Learning","III Elective","FQN 446 - Advanced Source Selection",24,"FQN 101 - Advanced Source Selection",24,"Instructor Led"]
["FAI/DAU Technical Competencies","Contract Performance Management","FAC-C","III Elective","ACQ 265 (FED) - Mission-Focused Services Acquisition",32,"ACQ 265 - Mission-Focused Services Acquisition",28,"Instructor Led"]
["FAI/DAU Technical Competencies","Contract Performance Management","FAC-C","III Elective","ACQ 370 (FED) - Acquisition Law",51,"ACQ 370 - Acquisition Law",36,"Instructor Led"]
["FAI/DAU Technical Competencies","Contract Performance Management","FAC-C","I","CON 100 (FED) - Shaping Smart Business Arrangements",16,"CON 100 - Shaping Smart Business Arrangements",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Contract Performance Management","FAC-C","I","CON 121 (FED) - Contract Planning",16,"CON 121 - Contract Planning",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Contract Performance Management","FAC-C","I","CON 124 (FED) - Contract Execution",16,"CON 124 - Contract Execution",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Contract Performance Management","FAC-C","I","CON 127 (FED) - Contract Management",16,"CON 127 - Contract Management",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Contract Performance Management","FAC-C","II","CON 216 (FED) - Legal Considerations in Contracting",40,"CON 216 - Legal Considerations in Contracting",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Contract Performance Management","Continuous Learning","III Elective","CON 243 (FED) - Architect-Engineer Services Contracting",40,"CON 243 - Architect-Engineer Services Contracting",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Contract Performance Management","FAC-C","II","CON 280 (FED) - Source Selection and the Administration of Service Contracts",80,"CON 280 - Source Selection and the Administration of Service Contracts",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Contract Performance Management","FAC-C","II","CON 290 (FED) - Contract Administration and Negotiation Techniques in a Supply Environment",80,"CON 290 - Contract Administration and Negotiation Techniques in a Supply Environment",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Contract Performance Management","FAC-C","III","CON 360 (FED) - Contracting for Decision Makers",64,"CON 360 - Contracting for Decision Makers",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Contract Performance Management","Continuous Learning","III Elective","FCN 411 - Federal Real Property Lease Law",40,"FCN 411 - Federal Real Property Lease Law",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Contract Performance Management","Continuous Learning","III Elective","FCN 412 - Lease Administration",40,"FCN 412 - Lease Administration",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Contract Performance Management","Continuous Learning","III Elective","FCN 435 - Contract Administration",40,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Contract Performance Management","Continuous Learning","III Elective","FCN 543 - Architect and Engineer Refresher",24,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Contract Performance Management","Continuous Learning","III Elective","FCN 606 - Federal Real Property Leasing Refresher",40,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Contract Performance Management","Continuous Learning","Available For All Levels","FQN 104 - Construction Claims",24,"FQN 104 - Construction Claims",24,"Instructor Led"]
["FAI/DAU Technical Competencies","Contract Performance Management","Continuous Learning","Available For All Levels","FQN 401 - Administration of Cost Reimbursement Contracts",24,"FQN 105 - Administration of Cost Reimbursement Contracts",24,"Instructor Led"]
["FAI/DAU Technical Competencies","Contract Performance Management","Continuous Learning","III Elective","FQN 415 - Performance-Based Services Acquisitions with QASP",40,"FQN 112 - Performance-Based Services Acquisitions with QASP",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Contract Performance Management","Continuous Learning","Available For All Levels","FQN 423 - Simplified Acquisitions",24,"FQN 113 - Simplified Acquisitions",24,"Instructor Led"]
["FAI/DAU Technical Competencies","Contract Performance Management","Continuous Learning","III Elective","FQN 408 - Strategic Sourcing",24,"FQN 114 - Strategic Sourcing",24,"Instructor Led"]
["FAI/DAU Technical Competencies","Contract Termination","FAC-C","III Elective","ACQ 370 (FED) - Acquisition Law",51,"ACQ 370 - Acquisition Law",36,"Instructor Led"]
["FAI/DAU Technical Competencies","Contract Termination","FAC-C","I","CON 121 (FED) - Contract Planning",16,"CON 121 - Contract Planning",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Contract Termination","FAC-C","I","CON 124 (FED) - Contract Execution",16,"CON 124 - Contract Execution",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Contract Termination","FAC-C","I","CON 127 (FED) - Contract Management",16,"CON 127 - Contract Management",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Contract Termination","FAC-C","II","CON 216 (FED) - Legal Considerations in Contracting",40,"CON 216 - Legal Considerations in Contracting",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Contract Termination","FAC-C","III","CON 244 (FED) - Construction Contracting",40,"CON 244 - Construction Contracting",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Contract Termination","FAC-C","II","CON 290 (FED) - Contract Administration and Negotiation Techniques in a Supply Environment",80,"CON 290 - Contract Administration and Negotiation Techniques in a Supply Environment",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Contract Termination","Continuous Learning","III Elective","FCN 244 - Construction Contracting Refresher",24,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Contract Termination","Continuous Learning","III Elective","FCN 400 - Emergency Contracting Basics",16,"FCN 400 - Emergency Contracting Basics",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Contract Termination","Continuous Learning","III Elective","FCN 411 - Federal Real Property Lease Law",40,"FCN 411 - Federal Real Property Lease Law",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Contract Termination","Continuous Learning","III Elective","FCN 412 - Lease Administration",40,"FCN 412 - Lease Administration",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Contract Termination","Continuous Learning","III Elective","FCN 435 - Contract Administration",40,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Contract Termination","Continuous Learning","Available For All Levels","FCN 718 - Protests, Disputes and Terminations Workshop",8,"FQN WKSP 102 - Protests, Disputes and Terminations Workshop",8,"Web-based (Lync)"]
["FAI/DAU Technical Competencies","Contract Termination","Continuous Learning","Available For All Levels","FQN 104 - Construction Claims",24,"FQN 104 - Construction Claims",24,"Instructor Led"]
["FAI/DAU Technical Competencies","Contract Termination","Continuous Learning","Available For All Levels","FQN 423 - Simplified Acquisitions",24,"FQN 113 - Simplified Acquisitions",24,"Instructor Led"]
["FAI/DAU Technical Competencies","Contracting in a Contingent and/or Combat Environment","FAC-C","I","CON 100 (FED) - Shaping Smart Business Arrangements",16,"CON 100 - Shaping Smart Business Arrangements",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Contracting in a Contingent and/or Combat Environment","Continuous Learning","III Elective","FCN 400 - Emergency Contracting Basics",16,"FCN 400 - Emergency Contracting Basics",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Contracting in a Contingent and/or Combat Environment","Continuous Learning","Available For All Levels","FCN 718 - Protests, Disputes and Terminations Workshop",8,"FQN WKSP 102 - Protests, Disputes and Terminations Workshop",8,"Web-based (Lync)"]
["FAI/DAU Technical Competencies","Contracting in a Contingent and/or Combat Environment","Continuous Learning","III Elective","FQN 415 - Performance-Based Services Acquisitions with QASP",40,"FQN 112 - Performance-Based Services Acquisitions with QASP",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Contracting in a Contingent and/or Combat Environment","Continuous Learning","Available For All Levels","FQN 423 - Simplified Acquisitions",24,"FQN 113 - Simplified Acquisitions",24,"Instructor Led"]
["FAI/DAU Technical Competencies","Determination of How Best to Satisfy Requirements for the Mission Area","FAC-C","III Elective","ACQ 265 (FED) - Mission-Focused Services Acquisition",32,"ACQ 265 - Mission-Focused Services Acquisition",28,"Instructor Led"]
["FAI/DAU Technical Competencies","Determination of How Best to Satisfy Requirements for the Mission Area","FAC-C","III Elective","ACQ 370 (FED) - Acquisition Law",51,"ACQ 370 - Acquisition Law",36,"Instructor Led"]
["FAI/DAU Technical Competencies","Determination of How Best to Satisfy Requirements for the Mission Area","FAC-C","I","CON 091 (FED) - Contract Fundamentals",104,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Determination of How Best to Satisfy Requirements for the Mission Area","FAC-C","I","CON 100 (FED) - Shaping Smart Business Arrangements",16,"CON 100 - Shaping Smart Business Arrangements",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Determination of How Best to Satisfy Requirements for the Mission Area","FAC-C","I","CON 121 (FED) - Contract Planning",16,"CON 121 - Contract Planning",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Determination of How Best to Satisfy Requirements for the Mission Area","FAC-C","I","CON 124 (FED) - Contract Execution",16,"CON 124 - Contract Execution",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Determination of How Best to Satisfy Requirements for the Mission Area","FAC-C","I","CON 127 (FED) - Contract Management",16,"CON 127 - Contract Management",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Determination of How Best to Satisfy Requirements for the Mission Area","FAC-C","II","CON 200 (FED) - Business Decisions for Contracting",24,"CON 200 - Business Decisions For Contracting",24,"Instructor Led"]
["FAI/DAU Technical Competencies","Determination of How Best to Satisfy Requirements for the Mission Area","FAC-C","II","CON 216 (FED) - Legal Considerations in Contracting",40,"CON 216 - Legal Considerations in Contracting",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Determination of How Best to Satisfy Requirements for the Mission Area","FAC-C","III","CON 244 (FED) - Construction Contracting",40,"CON 244 - Construction Contracting",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Determination of How Best to Satisfy Requirements for the Mission Area","FAC-C","II","CON 280 (FED) - Source Selection and the Administration of Service Contracts",80,"CON 280 - Source Selection and the Administration of Service Contracts",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Determination of How Best to Satisfy Requirements for the Mission Area","FAC-C","II","CON 290 (FED) - Contract Administration and Negotiation Techniques in a Supply Environment",80,"CON 290 - Contract Administration and Negotiation Techniques in a Supply Environment",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Determination of How Best to Satisfy Requirements for the Mission Area","FAC-C","III","CON 360 (FED) - Contracting for Decision Makers",64,"CON 360 - Contracting for Decision Makers",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Determination of How Best to Satisfy Requirements for the Mission Area","Continuous Learning","Available For All Levels","FCL-VA-0026 - Vets First Contracting: Tiered Evaluations",2,"N/A","N/A","Web-based (Blackboard)"]
["FAI/DAU Technical Competencies","Determination of How Best to Satisfy Requirements for the Mission Area","Continuous Learning","Available For All Levels","FCL-VA-0026 - Vets First Contracting: Tiered Evaluations",2,"N/A","N/A","Web-based (Blackboard)"]
["FAI/DAU Technical Competencies","Determination of How Best to Satisfy Requirements for the Mission Area","Continuous Learning","Available For All Levels","FCL-VA-0034 - Applying The Veterans First Contracting Program",2.5,"N/A","N/A","Web-based (Blackboard)"]
["FAI/DAU Technical Competencies","Determination of How Best to Satisfy Requirements for the Mission Area","FAC-C","Available For All Levels","FCN 190 - FAR Fundamentals",80,"N/A","N/A","Web-based (Lync)"]
["FAI/DAU Technical Competencies","Determination of How Best to Satisfy Requirements for the Mission Area","FAC-C","Available For All Levels","FCN 195 - FAR Refresher",24,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Determination of How Best to Satisfy Requirements for the Mission Area","Continuous Learning","III Elective","FCN 400 - Emergency Contracting Basics",16,"FCN 400 - Emergency Contracting Basics",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Determination of How Best to Satisfy Requirements for the Mission Area","Continuous Learning","III Elective","FCN 406 - Lease Acquisition Training (LAT)",36,"FCN 406 - Lease Acquisition Training (LAT)",36,"Instructor Led"]
["FAI/DAU Technical Competencies","Determination of How Best to Satisfy Requirements for the Mission Area","Continuous Learning","Available For All Levels","FCN 605 - Intermediate Agile Techniques for Contracting",16,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Determination of How Best to Satisfy Requirements for the Mission Area","Continuous Learning","Available For All Levels","FFM 403 - Federal Appropriations Law",24,"FQN 107 - Federal Appropriations Law",24,"Instructor Led"]
["FAI/DAU Technical Competencies","Determination of How Best to Satisfy Requirements for the Mission Area","Continuous Learning","Available For All Levels","FQN 399 - Simplified Acquisition Procedures Demystified",8,"N/A","N/A","Web-based (Blackboard)"]
["FAI/DAU Technical Competencies","Determination of How Best to Satisfy Requirements for the Mission Area","Continuous Learning","Available For All Levels","FQN 405 - Market Research and Commercial Items",24,"FQN 110 - Market Research and Commercial Items",24,"Instructor Led"]
["FAI/DAU Technical Competencies","Determination of How Best to Satisfy Requirements for the Mission Area","Continuous Learning","III Elective","FQN 408 - Strategic Sourcing",24,"FQN 114 - Strategic Sourcing",24,"Instructor Led"]
["FAI/DAU Technical Competencies","Determination of How Best to Satisfy Requirements for the Mission Area","Continuous Learning","III Elective","FQN 415 - Performance-Based Services Acquisitions with QASP",40,"FQN 112 - Performance-Based Services Acquisitions with QASP",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Determination of How Best to Satisfy Requirements for the Mission Area","Continuous Learning","Available For All Levels","FQN 423 - Simplified Acquisitions",24,"FQN 113 - Simplified Acquisitions",24,"Instructor Led"]
["FAI/DAU Technical Competencies","Determination of How Best to Satisfy Requirements for the Mission Area","Continuous Learning","Available For All Levels","FQN 427 - Writing Performance-Based Work Statements",24,"FQN 116 - Writing Performance-Based Work Statements",24,"Instructor Led"]
["FAI/DAU Technical Competencies","Determination of How Best to Satisfy Requirements for the Mission Area","Continuous Learning","Available For All Levels","FQN 449 - Service Contract Labor Standards Statute",16,"FQN 449 - Service Contract Labor Standards Statute",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Determination of How Best to Satisfy Requirements for the Mission Area","Continuous Learning","Available For All Levels","FQN 481 - Applied Simplified Acquisition Procedures (ASAP)",16,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","E-Business and Automated Tools","FAC-C","I","CON 100 (FED) - Shaping Smart Business Arrangements",16,"CON 100 - Shaping Smart Business Arrangements",16,"Instructor Led"]
["FAI/DAU Technical Competencies","E-Business and Automated Tools","FAC-C","I","CON 121 (FED) - Contract Planning",16,"CON 121 - Contract Planning",16,"Instructor Led"]
["FAI/DAU Technical Competencies","E-Business and Automated Tools","FAC-C","I","CON 124 (FED) - Contract Execution",16,"CON 124 - Contract Execution",16,"Instructor Led"]
["FAI/DAU Technical Competencies","E-Business and Automated Tools","FAC-C","I","CON 127 (FED) - Contract Management",16,"CON 127 - Contract Management",16,"Instructor Led"]
["FAI/DAU Technical Competencies","E-Business and Automated Tools","FAC-C","II","CON 280 (FED) - Source Selection and the Administration of Service Contracts",80,"CON 280 - Source Selection and the Administration of Service Contracts",80,"Instructor Led"]
["FAI/DAU Technical Competencies","E-Business and Automated Tools","FAC-C","II","CON 290 (FED) - Contract Administration and Negotiation Techniques in a Supply Environment",80,"CON 290 - Contract Administration and Negotiation Techniques in a Supply Environment",80,"Instructor Led"]
["FAI/DAU Technical Competencies","E-Business and Automated Tools","Continuous Learning","Available For All Levels","FCE 401 - eCMS Coordinator Workshop",24,"FQN WKSP 105 - eCMS Coordinator Workshop",24,"Instructor Led"]
["FAI/DAU Technical Competencies","E-Business and Automated Tools","Continuous Learning","Available For All Levels","FCL-VA-0037 - Mini Mission: RFQ Dialog Session in eCMS",1,"N/A","N/A","Web-based (Blackboard)"]
["FAI/DAU Technical Competencies","E-Business and Automated Tools","Continuous Learning","Available For All Levels","FCL-VA-0038 - Mini Mission: SF 30 Contract Modification",1,"N/A","N/A","Web-based (Blackboard)"]
["FAI/DAU Technical Competencies","E-Business and Automated Tools","Continuous Learning","Available For All Levels","FCL-VA-0039 - Mini Mission: Pre-Solicitation Notice ",1,"N/A","N/A","Web-based (Blackboard)"]
["FAI/DAU Technical Competencies","E-Business and Automated Tools","Continuous Learning","Available For All Levels","FCL-VA-0039 - Mini Mission: Pre-Solicitation Notice ",1,"N/A","N/A","Web-based (Blackboard)"]
["FAI/DAU Technical Competencies","E-Business and Automated Tools","Continuous Learning","Available For All Levels","FCL-VA-0039 - Mini Mission: Pre-Solicitation Notice ",1,"N/A","N/A","Web-based (Blackboard)"]
["FAI/DAU Technical Competencies","E-Business and Automated Tools","Continuous Learning","Available For All Levels","FCL-VA-0040 - Mini-Mission: Intent to Sole Source",1,"N/A","N/A","Web-based (Blackboard)"]
["FAI/DAU Technical Competencies","E-Business and Automated Tools","Continuous Learning","Available For All Levels","FCL-VA-0041 - Mini Mission: Sources Sought Notice ",1,"N/A","N/A","Web-based (Blackboard)"]
["FAI/DAU Technical Competencies","E-Business and Automated Tools","Continuous Learning","Available For All Levels","FCL-VA-0042 - Mini Mission: VA 2268 ",1,"N/A","N/A","Web-based (Blackboard)"]
["FAI/DAU Technical Competencies","E-Business and Automated Tools","Continuous Learning","Available For All Levels","FCL-VA-0042 - Mini Mission: VA 2268 ",1,"N/A","N/A","Web-based (Blackboard)"]
["FAI/DAU Technical Competencies","E-Business and Automated Tools","Continuous Learning","Available For All Levels","FCL-VA-0043 - Mini Mission: RFQ Formatting in eCMS ",1,"N/A","N/A","Web-based (Blackboard)"]
["FAI/DAU Technical Competencies","E-Business and Automated Tools","Continuous Learning","Available For All Levels","FCL-VA-0044 - Mini Mission: Cover Page of the Award ",1,"N/A","N/A","Web-based (Blackboard)"]
["FAI/DAU Technical Competencies","E-Business and Automated Tools","Continuous Learning","Available For All Levels","FCL-VA-0045- Mini Mission: RFQ Content Manager in eCMS",1,"N/A","N/A","Web-based (Blackboard)"]
["FAI/DAU Technical Competencies","E-Business and Automated Tools","Continuous Learning","Available For All Levels","FCL-VA-0046 - Mini Mission: Organizing Your eCMS Desktop ",1,"N/A","N/A","Web-based (Blackboard)"]
["FAI/DAU Technical Competencies","E-Business and Automated Tools","Continuous Learning","Available For All Levels","FCL-VA-0047 - Mini Mission: Organizing Your Digital Desktop",1,"N/A","N/A","Web-based (Blackboard)"]
["FAI/DAU Technical Competencies","E-Business and Automated Tools","Continuous Learning","Available For All Levels","FCL-VA-0048 - Mini Mission: Cover Page of the Solicitation ",1,"N/A","N/A","Web-based (Blackboard)"]
["FAI/DAU Technical Competencies","E-Business and Automated Tools","Continuous Learning","Available For All Levels","FCL-VA-0048 - Mini Mission: Cover Page of the Solicitation ",1,"N/A","N/A","Web-based (Blackboard)"]
["FAI/DAU Technical Competencies","E-Business and Automated Tools","Continuous Learning","Available For All Levels","FCL-VA-0049 - Mini Mission: Line Item Structure ",1,"N/A","N/A","Web-based (Blackboard)"]
["FAI/DAU Technical Competencies","E-Business and Automated Tools","Continuous Learning","Available For All Levels","FCL-VA-0050 - Mini Mission: Award Creation in eCMS",1,"N/A","N/A","Web-based (Blackboard)"]
["FAI/DAU Technical Competencies","E-Business and Automated Tools","Continuous Learning","Available For All Levels","FCL-VA-0051 - Mini Mission: Award Formatting in eCMS",1,"N/A","N/A","Web-based (Blackboard)"]
["FAI/DAU Technical Competencies","E-Business and Automated Tools","Continuous Learning","Available For All Levels","FCL-VA-3860841 - eCMS In The Acquisition Lifecycle",1,"TMS ID: 3860841 - eCMS In The Acquisition Lifecycle",1,"Self Paced"]
["FAI/DAU Technical Competencies","E-Business and Automated Tools","Continuous Learning","Available For All Levels","FCL-VA-3860842 - eCMS and Integrated Systems",1,"TMS ID: 3860842 - eCMS and Integrated Systems",1,"Self Paced"]
["FAI/DAU Technical Competencies","E-Business and Automated Tools","Continuous Learning","Available For All Levels","FCL-VA-3860843 - eCMS FPDS Information Channel",1,"TMS ID: 3860843 - eCMS FPDS Information Channel",1,"Self Paced"]
["FAI/DAU Technical Competencies","E-Business and Automated Tools","Continuous Learning","Available For All Levels","FCL-VA-3864508 - eCMS Content Manager and Briefcase",1,"TMS ID: 3864508 - eCMS Content Manager and Briefcase",1,"Self Paced"]
["FAI/DAU Technical Competencies","E-Business and Automated Tools","Continuous Learning","Available For All Levels","FCL-VA-3864512 - eCMS Train the Trainer: Conveying Your Expertise To Others",1,"TMS ID: 3864512 - eCMS Train the Trainer: Conveying Your Expertise To Others",1,"Self Paced"]
["FAI/DAU Technical Competencies","E-Business and Automated Tools","Continuous Learning","Available For All Levels","FCL-VA-3864515 - eCMS Basic System Administration",1,"TMS ID: 3864515 - eCMS Basic System Administration",1,"Self Paced"]
["FAI/DAU Technical Competencies","E-Business and Automated Tools","Continuous Learning","Available For All Levels","FCL-VA-3864516 - eCMS MicroStrategy Reporting",1,"TMS ID: 3864516 - eCMS MicroStrategy Reporting",1,"Self Paced"]
["FAI/DAU Technical Competencies","E-Business and Automated Tools","Continuous Learning","Available For All Levels","FCL-VA-3864517 - eCMS Modification Actions and Change Orders",1,"TMS ID: 3864517 - eCMS Modification Actions and Change Orders",1,"Self Paced"]
["FAI/DAU Technical Competencies","E-Business and Automated Tools","Continuous Learning","Available For All Levels","FCL-VA-3864518 - eCMS User Refresher Guide",1,"TMS ID: 3864518 - eCMS User Refresher Guide",1,"Self Paced"]
["FAI/DAU Technical Competencies","E-Business and Automated Tools","Continuous Learning","Available For All Levels","FCL-VA-3870692 - eCMS Curriculum Updates",1,"TMS ID: 3870692 - eCMS Curriculum Updates",1,"Self Paced"]
["FAI/DAU Technical Competencies","E-Business and Automated Tools","Continuous Learning","Available For All Levels","FCN 462 - Practical Contracting Workshop",24,"FQN WKSP 103 - Practical Contracting",3,"Instructor Led"]
["FAI/DAU Technical Competencies","Initiation of Work","FAC-C","III Elective","ACQ 265 (FED) - Mission-Focused Services Acquisition",32,"ACQ 265 - Mission-Focused Services Acquisition",28,"Instructor Led"]
["FAI/DAU Technical Competencies","Initiation of Work","FAC-C","I","CON 100 (FED) - Shaping Smart Business Arrangements",16,"CON 100 - Shaping Smart Business Arrangements",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Initiation of Work","FAC-C","I","CON 121 (FED) - Contract Planning",16,"CON 121 - Contract Planning",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Initiation of Work","FAC-C","I","CON 124 (FED) - Contract Execution",16,"CON 124 - Contract Execution",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Initiation of Work","FAC-C","I","CON 127 (FED) - Contract Management",16,"CON 127 - Contract Management",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Initiation of Work","Continuous Learning","III Elective","CON 243 (FED) - Architect-Engineer Services Contracting",40,"CON 243 - Architect-Engineer Services Contracting",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Initiation of Work","FAC-C","III","CON 244 (FED) - Construction Contracting",40,"CON 244 - Construction Contracting",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Initiation of Work","FAC-C","II","CON 290 (FED) - Contract Administration and Negotiation Techniques in a Supply Environment",80,"CON 290 - Contract Administration and Negotiation Techniques in a Supply Environment",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Initiation of Work","Continuous Learning","III Elective","FCN 244 - Construction Contracting Refresher",24,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Initiation of Work","Continuous Learning","III Elective","FCN 400 - Emergency Contracting Basics",16,"FCN 400 - Emergency Contracting Basics",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Initiation of Work","Continuous Learning","III Elective","FCN 543 - Architect and Engineer Refresher",24,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Issue Changes and Modifications","FAC-C","III Elective","ACQ 370 (FED) - Acquisition Law",51,"ACQ 370 - Acquisition Law",36,"Instructor Led"]
["FAI/DAU Technical Competencies","Issue Changes and Modifications","FAC-C","I","CON 100 (FED) - Shaping Smart Business Arrangements",16,"CON 100 - Shaping Smart Business Arrangements",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Issue Changes and Modifications","FAC-C","I","CON 121 (FED) - Contract Planning",16,"CON 121 - Contract Planning",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Issue Changes and Modifications","FAC-C","I","CON 124 (FED) - Contract Execution",16,"CON 124 - Contract Execution",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Issue Changes and Modifications","FAC-C","I","CON 127 (FED) - Contract Management",16,"CON 127 - Contract Management",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Issue Changes and Modifications","FAC-C","II","CON 216 (FED) - Legal Considerations in Contracting",40,"CON 216 - Legal Considerations in Contracting",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Issue Changes and Modifications","FAC-C","II","CON 290 (FED) - Contract Administration and Negotiation Techniques in a Supply Environment",80,"CON 290 - Contract Administration and Negotiation Techniques in a Supply Environment",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Issue Changes and Modifications","Continuous Learning","III Elective","FCN 411 - Federal Real Property Lease Law",40,"FCN 411 - Federal Real Property Lease Law",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Issue Changes and Modifications","Continuous Learning","III Elective","FCN 412 - Lease Administration",40,"FCN 412 - Lease Administration",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Issue Changes and Modifications","Continuous Learning","Available For All Levels","FQN 401 - Administration of Cost Reimbursement Contracts",24,"FQN 105 - Administration of Cost Reimbursement Contracts",24,"Instructor Led"]
["FAI/DAU Technical Competencies","Justification of Other than Full and Open","FAC-C","I","CON 100 (FED) - Shaping Smart Business Arrangements",16,"CON 100 - Shaping Smart Business Arrangements",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Justification of Other than Full and Open","FAC-C","I","CON 121 (FED) - Contract Planning",16,"CON 121 - Contract Planning",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Justification of Other than Full and Open","FAC-C","I","CON 124 (FED) - Contract Execution",16,"CON 124 - Contract Execution",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Justification of Other than Full and Open","FAC-C","I","CON 127 (FED) - Contract Management",16,"CON 127 - Contract Management",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Justification of Other than Full and Open","FAC-C","II","CON 280 (FED) - Source Selection and the Administration of Service Contracts",80,"CON 280 - Source Selection and the Administration of Service Contracts",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Justification of Other than Full and Open","FAC-C","II","CON 290 (FED) - Contract Administration and Negotiation Techniques in a Supply Environment",80,"CON 290 - Contract Administration and Negotiation Techniques in a Supply Environment",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Justification of Other than Full and Open","Continuous Learning","Available For All Levels","FCL-VA-0026 - Vets First Contracting: Tiered Evaluations",2,"N/A","N/A","Web-based (Blackboard)"]
["FAI/DAU Technical Competencies","Justification of Other than Full and Open","Continuous Learning","Available For All Levels","FCL-VA-0034 - Applying The Veterans First Contracting Program",2.5,"N/A","N/A","Web-based (Blackboard)"]
["FAI/DAU Technical Competencies","Justification of Other than Full and Open","Continuous Learning","Available For All Levels","FQN 405 - Market Research and Commercial Items",24,"FQN 110 - Market Research and Commercial Items",24,"Instructor Led"]
["FAI/DAU Technical Competencies","Justification of Other than Full and Open","Continuous Learning","Available For All Levels","FQN 423 - Simplified Acquisitions",24,"FQN 113 - Simplified Acquisitions",24,"Instructor Led"]
["FAI/DAU Technical Competencies","Justification of Other than Full and Open","Continuous Learning","Available For All Levels","FQN 450 - Acquisition of Commercial Items",16,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Negotiate Forward Pricing Rates Agreements & Administer Cost Accounting Standards","FAC-C","I","CON 121 (FED) - Contract Planning",16,"CON 121 - Contract Planning",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Negotiate Forward Pricing Rates Agreements & Administer Cost Accounting Standards","FAC-C","I","CON 124 (FED) - Contract Execution",16,"CON 124 - Contract Execution",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Negotiate Forward Pricing Rates Agreements & Administer Cost Accounting Standards","FAC-C","I","CON 127 (FED) - Contract Management",16,"CON 127 - Contract Management",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Negotiate Forward Pricing Rates Agreements & Administer Cost Accounting Standards","FAC-C","I","CON 170 (FED) - Fundamentals of Cost and Price Analysis",64,"CON 170 - Fundamentals of Cost and Price Analysis",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Negotiate Forward Pricing Rates Agreements & Administer Cost Accounting Standards","Continuous Learning","III Elective","CON 243 (FED) - Architect-Engineer Services Contracting",40,"CON 243 - Architect-Engineer Services Contracting",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Negotiate Forward Pricing Rates Agreements & Administer Cost Accounting Standards","FAC-C","II","CON 270 (FED) - Intermediate Cost and Price Analysis",80,"CON 270 - Intermediate Cost and Price Analysis",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Negotiate Forward Pricing Rates Agreements & Administer Cost Accounting Standards","FAC-C","II","CON 290 (FED) - Contract Administration and Negotiation Techniques in a Supply Environment",80,"CON 290 - Contract Administration and Negotiation Techniques in a Supply Environment",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Negotiate Forward Pricing Rates Agreements & Administer Cost Accounting Standards","Continuous Learning","III Elective","FCN 543 - Architect and Engineer Refresher",24,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Negotiate Forward Pricing Rates Agreements & Administer Cost Accounting Standards","Continuous Learning","Available For All Levels","FQN 438 - Negotiation Skills for Acquisition Professionals Workshop",3,"FQN WKSP 101 - Negotiation Skills for Acquisition Professionals Workshop",3,"Web-based (Lync)"]
["FAI/DAU Technical Competencies","Preparation and Negotiation","FAC-C","I","CON 100 (FED) - Shaping Smart Business Arrangements",16,"CON 100 - Shaping Smart Business Arrangements",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Preparation and Negotiation","FAC-C","I","CON 121 (FED) - Contract Planning",16,"CON 121 - Contract Planning",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Preparation and Negotiation","FAC-C","I","CON 124 (FED) - Contract Execution",16,"CON 124 - Contract Execution",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Preparation and Negotiation","FAC-C","I","CON 127 (FED) - Contract Management",16,"CON 127 - Contract Management",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Preparation and Negotiation","FAC-C","I","CON 170 (FED) - Fundamentals of Cost and Price Analysis",64,"CON 170 - Fundamentals of Cost and Price Analysis",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Preparation and Negotiation","Continuous Learning","III Elective","CON 243 (FED) - Architect-Engineer Services Contracting",40,"CON 243 - Architect-Engineer Services Contracting",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Preparation and Negotiation","FAC-C","III","CON 244 (FED) - Construction Contracting",40,"CON 244 - Construction Contracting",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Preparation and Negotiation","FAC-C","II","CON 270 (FED) - Intermediate Cost and Price Analysis",80,"CON 270 - Intermediate Cost and Price Analysis",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Preparation and Negotiation","FAC-C","II","CON 280 (FED) - Source Selection and the Administration of Service Contracts",80,"CON 280 - Source Selection and the Administration of Service Contracts",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Preparation and Negotiation","FAC-C","II","CON 290 (FED) - Contract Administration and Negotiation Techniques in a Supply Environment",80,"CON 290 - Contract Administration and Negotiation Techniques in a Supply Environment",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Preparation and Negotiation","Continuous Learning","III Elective","FCN 244 - Construction Contracting Refresher",24,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Preparation and Negotiation","Continuous Learning","III Elective","FCN 409 - Techniques of Negotiating Federal Real Property Leases",40,"FCN 409 - Techniques of Negotiating Federal Real Property Leases",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Preparation and Negotiation","Continuous Learning","III Elective","FCN 543 - Architect and Engineer Refresher",24,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Preparation and Negotiation","Continuous Learning","III Elective","FCN 606 - Federal Real Property Leasing Refresher",40,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Preparation and Negotiation","Continuous Learning","Available For All Levels","FQN 406 - Negotiation Strategies and Techniques",40,"FQN 111 - Negotiation Strategies and Techniques",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Preparation and Negotiation","Continuous Learning","III Elective","FQN 415 - Performance-Based Services Acquisitions with QASP",40,"FQN 112 - Performance-Based Services Acquisitions with QASP",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Preparation and Negotiation","Continuous Learning","Available For All Levels","FQN 438 - Negotiation Skills for Acquisition Professionals Workshop",3,"FQN WKSP 101 - Negotiation Skills for Acquisition Professionals Workshop",3,"Web-based (Lync)"]
["FAI/DAU Technical Competencies","Process Protests","FAC-C","I","CON 100 (FED) - Shaping Smart Business Arrangements",16,"CON 100 - Shaping Smart Business Arrangements",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Process Protests","FAC-C","II","CON 216 (FED) - Legal Considerations in Contracting",40,"CON 216 - Legal Considerations in Contracting",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Process Protests","FAC-C","II","CON 290 (FED) - Contract Administration and Negotiation Techniques in a Supply Environment",80,"CON 290 - Contract Administration and Negotiation Techniques in a Supply Environment",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Process Protests","Continuous Learning","III Elective","FCN 400 - Emergency Contracting Basics",16,"FCN 400 - Emergency Contracting Basics",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Process Protests","Continuous Learning","Available For All Levels","FCN 718 - Protests, Disputes and Terminations Workshop",8,"FQN WKSP 102 - Protests, Disputes and Terminations Workshop",8,"Web-based (Lync)"]
["FAI/DAU Technical Competencies","Process Protests","Continuous Learning","Available For All Levels","FQN 104 - Construction Claims",24,"FQN 104 - Construction Claims",24,"Instructor Led"]
["FAI/DAU Technical Competencies","Procurement Analysis","FAC-C","III Elective","ACQ 370 (FED) - Acquisition Law",51,"ACQ 370 - Acquisition Law",36,"Instructor Led"]
["FAI/DAU Technical Competencies","Procurement Analysis","FAC-C","I","CON 100 (FED) - Shaping Smart Business Arrangements",16,"CON 100 - Shaping Smart Business Arrangements",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Procurement Analysis","FAC-C","I","CON 121 (FED) - Contract Planning",16,"CON 121 - Contract Planning",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Procurement Analysis","FAC-C","I","CON 124 (FED) - Contract Execution",16,"CON 124 - Contract Execution",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Procurement Analysis","FAC-C","I","CON 127 (FED) - Contract Management",16,"CON 127 - Contract Management",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Procurement Analysis","FAC-C","II","CON 216 (FED) - Legal Considerations in Contracting",40,"CON 216 - Legal Considerations in Contracting",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Procurement Analysis","Continuous Learning","III Elective","CON 243 (FED) - Architect-Engineer Services Contracting",40,"CON 243 - Architect-Engineer Services Contracting",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Procurement Analysis","FAC-C","II","CON 280 (FED) - Source Selection and the Administration of Service Contracts",80,"CON 280 - Source Selection and the Administration of Service Contracts",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Procurement Analysis","FAC-C","II","CON 290 (FED) - Contract Administration and Negotiation Techniques in a Supply Environment",80,"CON 290 - Contract Administration and Negotiation Techniques in a Supply Environment",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Procurement Analysis","FAC-C","III","CON 360 (FED) - Contracting for Decision Makers",64,"CON 360 - Contracting for Decision Makers",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Procurement Analysis","Continuous Learning","III Elective","FCN 400 - Emergency Contracting Basics",16,"FCN 400 - Emergency Contracting Basics",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Procurement Analysis","Continuous Learning","III Elective","FCN 543 - Architect and Engineer Refresher",24,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Procurement Analysis","Continuous Learning","Available For All Levels","FLD 400 - Congress and Federal Agencies",16,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Procurement Analysis","Continuous Learning","III Elective","FQN 408 - Strategic Sourcing",24,"FQN 114 - Strategic Sourcing",24,"Instructor Led"]
["FAI/DAU Technical Competencies","Promote Competition","FAC-C","I","CON 100 (FED) - Shaping Smart Business Arrangements",16,"CON 100 - Shaping Smart Business Arrangements",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Promote Competition","FAC-C","I","CON 121 (FED) - Contract Planning",16,"CON 121 - Contract Planning",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Promote Competition","FAC-C","I","CON 124 (FED) - Contract Execution",16,"CON 124 - Contract Execution",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Promote Competition","FAC-C","I","CON 127 (FED) - Contract Management",16,"CON 127 - Contract Management",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Promote Competition","Continuous Learning","III Elective","CON 243 (FED) - Architect-Engineer Services Contracting",40,"CON 243 - Architect-Engineer Services Contracting",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Promote Competition","FAC-C","II","CON 280 (FED) - Source Selection and the Administration of Service Contracts",80,"CON 280 - Source Selection and the Administration of Service Contracts",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Promote Competition","FAC-C","I","FCL-VA-0170 - Contract Pricing Determinations Workshop",16,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Promote Competition","Continuous Learning","III Elective","FCN 543 - Architect and Engineer Refresher",24,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Promote Competition","Continuous Learning","Available For All Levels","FFM 421 - Applied Fair and Reasonable Pricing Workshop",16,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Promote Competition","Continuous Learning","Available For All Levels","FQN 405 - Market Research and Commercial Items",24,"FQN 110 - Market Research and Commercial Items",24,"Instructor Led"]
["FAI/DAU Technical Competencies","Promote Competition","Continuous Learning","Available For All Levels","FQN 423 - Simplified Acquisitions",24,"FQN 113 - Simplified Acquisitions",24,"Instructor Led"]
["FAI/DAU Technical Competencies","Proposal Evaluation (Contracting by Negotiation)","FAC-C","I","CON 100 (FED) - Shaping Smart Business Arrangements",16,"CON 100 - Shaping Smart Business Arrangements",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Proposal Evaluation (Contracting by Negotiation)","FAC-C","I","CON 121 (FED) - Contract Planning",16,"CON 121 - Contract Planning",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Proposal Evaluation (Contracting by Negotiation)","FAC-C","I","CON 124 (FED) - Contract Execution",16,"CON 124 - Contract Execution",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Proposal Evaluation (Contracting by Negotiation)","FAC-C","I","CON 127 (FED) - Contract Management",16,"CON 127 - Contract Management",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Proposal Evaluation (Contracting by Negotiation)","FAC-C","I","CON 170 (FED) - Fundamentals of Cost and Price Analysis",64,"CON 170 - Fundamentals of Cost and Price Analysis",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Proposal Evaluation (Contracting by Negotiation)","FAC-C","II","CON 200 (FED) - Business Decisions for Contracting",24,"CON 200 - Business Decisions For Contracting",24,"Instructor Led"]
["FAI/DAU Technical Competencies","Proposal Evaluation (Contracting by Negotiation)","Continuous Learning","III Elective","CON 243 (FED) - Architect-Engineer Services Contracting",40,"CON 243 - Architect-Engineer Services Contracting",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Proposal Evaluation (Contracting by Negotiation)","FAC-C","II","CON 270 (FED) - Intermediate Cost and Price Analysis",80,"CON 270 - Intermediate Cost and Price Analysis",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Proposal Evaluation (Contracting by Negotiation)","FAC-C","II","CON 280 (FED) - Source Selection and the Administration of Service Contracts",80,"CON 280 - Source Selection and the Administration of Service Contracts",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Proposal Evaluation (Contracting by Negotiation)","FAC-C","II","CON 290 (FED) - Contract Administration and Negotiation Techniques in a Supply Environment",80,"CON 290 - Contract Administration and Negotiation Techniques in a Supply Environment",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Proposal Evaluation (Contracting by Negotiation)","Continuous Learning","III Elective","FCN 400 - Emergency Contracting Basics",16,"FCN 400 - Emergency Contracting Basics",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Proposal Evaluation (Contracting by Negotiation)","Continuous Learning","III Elective","FCN 409 - Techniques of Negotiating Federal Real Property Leases",40,"FCN 409 - Techniques of Negotiating Federal Real Property Leases",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Proposal Evaluation (Contracting by Negotiation)","Continuous Learning","III Elective","FCN 543 - Architect and Engineer Refresher",24,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Proposal Evaluation (Contracting by Negotiation)","Continuous Learning","III Elective","FCN 606 - Federal Real Property Leasing Refresher",40,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Responsibility Determination","FAC-C","III Elective","ACQ 370 (FED) - Acquisition Law",51,"ACQ 370 - Acquisition Law",36,"Instructor Led"]
["FAI/DAU Technical Competencies","Responsibility Determination","FAC-C","I","CON 100 (FED) - Shaping Smart Business Arrangements",16,"CON 100 - Shaping Smart Business Arrangements",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Responsibility Determination","FAC-C","I","CON 121 (FED) - Contract Planning",16,"CON 121 - Contract Planning",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Responsibility Determination","FAC-C","I","CON 124 (FED) - Contract Execution",16,"CON 124 - Contract Execution",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Responsibility Determination","FAC-C","I","CON 127 (FED) - Contract Management",16,"CON 127 - Contract Management",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Responsibility Determination","FAC-C","II","CON 200 (FED) - Business Decisions for Contracting",24,"CON 200 - Business Decisions For Contracting",24,"Instructor Led"]
["FAI/DAU Technical Competencies","Responsibility Determination","FAC-C","II","CON 216 (FED) - Legal Considerations in Contracting",40,"CON 216 - Legal Considerations in Contracting",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Responsibility Determination","Continuous Learning","III Elective","CON 243 (FED) - Architect-Engineer Services Contracting",40,"CON 243 - Architect-Engineer Services Contracting",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Responsibility Determination","FAC-C","II","CON 280 (FED) - Source Selection and the Administration of Service Contracts",80,"CON 280 - Source Selection and the Administration of Service Contracts",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Responsibility Determination","Continuous Learning","III Elective","FCN 543 - Architect and Engineer Refresher",24,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Solicitation of Offers","FAC-C","III Elective","ACQ 265 (FED) - Mission-Focused Services Acquisition",32,"ACQ 265 - Mission-Focused Services Acquisition",28,"Instructor Led"]
["FAI/DAU Technical Competencies","Solicitation of Offers","FAC-C","I","CON 100 (FED) - Shaping Smart Business Arrangements",16,"CON 100 - Shaping Smart Business Arrangements",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Solicitation of Offers","FAC-C","I","CON 121 (FED) - Contract Planning",16,"CON 121 - Contract Planning",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Solicitation of Offers","FAC-C","I","CON 124 (FED) - Contract Execution",16,"CON 124 - Contract Execution",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Solicitation of Offers","FAC-C","I","CON 127 (FED) - Contract Management",16,"CON 127 - Contract Management",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Solicitation of Offers","Continuous Learning","III Elective","CON 243 (FED) - Architect-Engineer Services Contracting",40,"CON 243 - Architect-Engineer Services Contracting",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Solicitation of Offers","FAC-C","II","CON 280 (FED) - Source Selection and the Administration of Service Contracts",80,"CON 280 - Source Selection and the Administration of Service Contracts",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Solicitation of Offers","FAC-C","II","CON 290 (FED) - Contract Administration and Negotiation Techniques in a Supply Environment",80,"CON 290 - Contract Administration and Negotiation Techniques in a Supply Environment",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Solicitation of Offers","Continuous Learning","III Elective","FCN 543 - Architect and Engineer Refresher",24,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Solicitation of Offers","Continuous Learning","III Elective","FCN 606 - Federal Real Property Leasing Refresher",40,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Solicitation of Offers","Continuous Learning","III Elective","FCN 606 - Federal Real Property Leasing Refresher",40,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Solicitation of Offers","Continuous Learning","III Elective","FCN 606 - Federal Real Property Leasing Refresher",40,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Solicitation of Offers","Continuous Learning","Available For All Levels","FQN 399 - Simplified Acquisition Procedures Demystified",8,"N/A","N/A","Web-based (Blackboard)"]
["FAI/DAU Technical Competencies","Solicitation of Offers","Continuous Learning","Available For All Levels","FQN 423 - Simplified Acquisitions",24,"FQN 113 - Simplified Acquisitions",24,"Instructor Led"]
["FAI/DAU Technical Competencies","Solicitation of Offers","Continuous Learning","Available For All Levels","FQN 450 - Acquisition of Commercial Items",16,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Solicitation of Offers","Continuous Learning","Available For All Levels","FQN 481 - Applied Simplified Acquisition Procedures (ASAP)",16,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Source Selection","FAC-C","I","CON 121 (FED) - Contract Planning",16,"CON 121 - Contract Planning",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Source Selection","FAC-C","I","CON 124 (FED) - Contract Execution",16,"CON 124 - Contract Execution",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Source Selection","FAC-C","I","CON 127 (FED) - Contract Management",16,"CON 127 - Contract Management",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Source Selection","FAC-C","II","CON 200 (FED) - Business Decisions for Contracting",24,"CON 200 - Business Decisions For Contracting",24,"Instructor Led"]
["FAI/DAU Technical Competencies","Source Selection","FAC-C","II","CON 280 (FED) - Source Selection and the Administration of Service Contracts",80,"CON 280 - Source Selection and the Administration of Service Contracts",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Source Selection","FAC-C","I","FCL-VA-0170 - Contract Pricing Determinations Workshop",16,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Source Selection","Continuous Learning","Available For All Levels","FFM 421 - Applied Fair and Reasonable Pricing Workshop",16,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Source Selection","Continuous Learning","Available For All Levels","FQN 399 - Simplified Acquisition Procedures Demystified",8,"N/A","N/A","Web-based (Blackboard)"]
["FAI/DAU Technical Competencies","Source Selection","Continuous Learning","Available For All Levels","FQN 423 - Simplified Acquisitions",24,"FQN 113 - Simplified Acquisitions",24,"Instructor Led"]
["FAI/DAU Technical Competencies","Source Selection","Continuous Learning","III Elective","FQN 440 - Basic Source Selection",40,"FQN 102 - Basic Source Selection",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Source Selection","Continuous Learning","Available For All Levels","FQN 442 - Best Value Source Selection",16,"FQN 103 - Best Value Source Selection",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Source Selection","Continuous Learning","III Elective","FQN 446 - Advanced Source Selection",24,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Source Selection","Continuous Learning","Available For All Levels","FQN 481 - Applied Simplified Acquisition Procedures (ASAP)",16,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Source Selection Planning","FAC-C","I","CON 100 (FED) - Shaping Smart Business Arrangements",16,"CON 100 - Shaping Smart Business Arrangements",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Source Selection Planning","FAC-C","I","CON 121 (FED) - Contract Planning",16,"CON 121 - Contract Planning",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Source Selection Planning","FAC-C","I","CON 124 (FED) - Contract Execution",16,"CON 124 - Contract Execution",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Source Selection Planning","FAC-C","I","CON 127 (FED) - Contract Management",16,"CON 127 - Contract Management",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Source Selection Planning","FAC-C","II","CON 200 (FED) - Business Decisions for Contracting",24,"CON 200 - Business Decisions For Contracting",24,"Instructor Led"]
["FAI/DAU Technical Competencies","Source Selection Planning","Continuous Learning","III Elective","CON 243 (FED) - Architect-Engineer Services Contracting",40,"CON 243 - Architect-Engineer Services Contracting",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Source Selection Planning","FAC-C","III","CON 244 (FED) - Construction Contracting",40,"CON 244 - Construction Contracting",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Source Selection Planning","FAC-C","II","CON 280 (FED) - Source Selection and the Administration of Service Contracts",80,"CON 280 - Source Selection and the Administration of Service Contracts",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Source Selection Planning","Continuous Learning","III Elective","FCN 244 - Construction Contracting Refresher",24,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Source Selection Planning","Continuous Learning","III Elective","FCN 400 - Emergency Contracting Basics",16,"FCN 400 - Emergency Contracting Basics",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Source Selection Planning","Continuous Learning","III Elective","FCN 543 - Architect and Engineer Refresher",24,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Source Selection Planning","Continuous Learning","Available For All Levels","FQN 399 - Simplified Acquisition Procedures Demystified",8,"N/A","N/A","Web-based (Blackboard)"]
["FAI/DAU Technical Competencies","Source Selection Planning","Continuous Learning","Available For All Levels","FQN 404 - Federal Supply Schedule (FSS)",24,"FQN 108 - Federal Supply Schedule (FSS)",24,"Instructor Led"]
["FAI/DAU Technical Competencies","Source Selection Planning","Continuous Learning","III Elective","FQN 408 - Strategic Sourcing",24,"FQN 114 - Strategic Sourcing",24,"Instructor Led"]
["FAI/DAU Technical Competencies","Source Selection Planning","Continuous Learning","Available For All Levels","FQN 423 - Simplified Acquisitions",24,"FQN 113 - Simplified Acquisitions",24,"Instructor Led"]
["FAI/DAU Technical Competencies","Source Selection Planning","Continuous Learning","III Elective","FQN 440 - Basic Source Selection",40,"FQN 102 - Basic Source Selection",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Source Selection Planning","Continuous Learning","Available For All Levels","FQN 442 - Best Value Source Selection",16,"FQN 103 - Best Value Source Selection",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Source Selection Planning","Continuous Learning","III Elective","FQN 446 - Advanced Source Selection",24,"FQN 101 - Advanced Source Selection",24,"Instructor Led"]
["FAI/DAU Technical Competencies","Source Selection Planning","Continuous Learning","Available For All Levels","FQN 481 - Applied Simplified Acquisition Procedures (ASAP)",16,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Terms and Conditions","FAC-C","III Elective","ACQ 265 (FED) - Mission-Focused Services Acquisition",32,"ACQ 265 - Mission-Focused Services Acquisition",28,"Instructor Led"]
["FAI/DAU Technical Competencies","Terms and Conditions","FAC-C","I","CON 100 (FED) - Shaping Smart Business Arrangements",16,"CON 100 - Shaping Smart Business Arrangements",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Terms and Conditions","FAC-C","I","CON 121 (FED) - Contract Planning",16,"CON 121 - Contract Planning",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Terms and Conditions","FAC-C","I","CON 124 (FED) - Contract Execution",16,"CON 124 - Contract Execution",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Terms and Conditions","FAC-C","I","CON 127 (FED) - Contract Management",16,"CON 127 - Contract Management",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Terms and Conditions","FAC-C","II","CON 216 (FED) - Legal Considerations in Contracting",40,"CON 216 - Legal Considerations in Contracting",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Terms and Conditions","Continuous Learning","III Elective","CON 243 (FED) - Architect-Engineer Services Contracting",40,"CON 243 - Architect-Engineer Services Contracting",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Terms and Conditions","FAC-C","III","CON 244 (FED) - Construction Contracting",40,"CON 244 - Construction Contracting",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Terms and Conditions","FAC-C","II","CON 280 (FED) - Source Selection and the Administration of Service Contracts",80,"CON 280 - Source Selection and the Administration of Service Contracts",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Terms and Conditions","FAC-C","II","CON 290 (FED) - Contract Administration and Negotiation Techniques in a Supply Environment",80,"CON 290 - Contract Administration and Negotiation Techniques in a Supply Environment",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Terms and Conditions","FAC-C","III","CON 360 (FED) - Contracting for Decision Makers",64,"CON 360 - Contracting for Decision Makers",80,"Instructor Led"]
["FAI/DAU Technical Competencies","Terms and Conditions","Continuous Learning","III Elective","FCN 244 - Construction Contracting Refresher",24,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Terms and Conditions","Continuous Learning","III Elective","FCN 400 - Emergency Contracting Basics",16,"FCN 400 - Emergency Contracting Basics",16,"Instructor Led"]
["FAI/DAU Technical Competencies","Terms and Conditions","Continuous Learning","III Elective","FCN 406 - Lease Acquisition Training (LAT)",36,"FCN 406 - Lease Acquisition Training (LAT)",36,"Instructor Led"]
["FAI/DAU Technical Competencies","Terms and Conditions","Continuous Learning","III Elective","FCN 409 - Techniques of Negotiating Federal Real Property Leases",40,"FCN 409 - Techniques of Negotiating Federal Real Property Leases",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Terms and Conditions","Continuous Learning","III Elective","FCN 410 - Real Estate Appraisal Principles",32,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Terms and Conditions","Continuous Learning","III Elective","FCN 411 - Federal Real Property Lease Law",40,"FCN 411 - Federal Real Property Lease Law",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Terms and Conditions","Continuous Learning","III Elective","FCN 412 - Lease Administration",40,"FCN 412 - Lease Administration",40,"Instructor Led"]
["FAI/DAU Technical Competencies","Terms and Conditions","Continuous Learning","III Elective","FCN 435 - Contract Administration",40,"N/A","N/A","Instructor Led"]
["FAI/DAU Technical Competencies","Terms and Conditions","Continuous Learning","III Elective","FCN 543 - Architect and Engineer Refresher",24,"N/A","N/A","Instructor Led"]
["VA 1102 Professional Competencies","Accountability","Continuous Learning","Available For All Levels","FCN 501 - Adapt to Change and Maintain Accountability",9,"FCN FLCP 501 - Adapt to Change and Maintain Accountability",9,"Web-based (Blackboard)"]
["VA 1102 Professional Competencies","Accountability","Continuous Learning","Available For All Levels","FLD 410 - Supervising 1102s: Getting Your Team to Great",45,"N/A","N/A","Instructor Led"]
["VA 1102 Professional Competencies","Building Effective Teams","Continuous Learning","II","FCN 802 - Develop and Manage High-Performing Teams",16,"N/A","N/A","Web-based (Blackboard)"]
["VA 1102 Professional Competencies","Building Effective Teams","Continuous Learning","Available For All Levels","FLD 410 - Supervising 1102s: Getting Your Team to Great",45,"N/A","N/A","Instructor Led"]
["VA 1102 Professional Competencies","Building Effective Teams","Continuous Learning","III Elective","FLD 420 - Senior Acquisition Leadership Training (SALT) Mission 1: Understanding Self and Others",63,"N/A","N/A","Instructor Led"]
["VA 1102 Professional Competencies","Business Acumen","Continuous Learning","Available For All Levels","FCN 604 - Business Acumen: Why Should They Listen To Me?",24,"N/A","N/A","Web-based (Blackboard)"]
["VA 1102 Professional Competencies","Command Skills","Continuous Learning","Available For All Levels","FCL-VA-0132 - Master Optimism to Improve Performance",2,"N/A","N/A","Web-based (Blackboard)"]
["VA 1102 Professional Competencies","Confronting Direct Reports","Continuous Learning","II","FCN 705 - Mastering Difficult Conversations with Direct Reports",16,"FCN RBCC 705 - Supervisory Contracting Officer, Confronting Direct Reports","TBD","Web-based (Blackboard)"]
["VA 1102 Professional Competencies","Confronting Direct Reports","Continuous Learning","Available For All Levels","FLD 410 - Supervising 1102s: Getting Your Team to Great",45,"N/A","N/A","Instructor Led"]
["VA 1102 Professional Competencies","Customer Service","Continuous Learning","Available For All Levels","FCL-VA-0002 - Welcome to VA: An Orientation for 1102s",8,"FQN 115 - Welcome to VA: An Orientation for 1102s",24,"Instructor Led"]
["VA 1102 Professional Competencies","Customer Service","Continuous Learning","Available For All Levels","FCN 504 - Effectively Interacting with Your Customer",8,"FCN FLCP 504 - Effectively Interacting with your Customer",8,"Web-based (Blackboard)"]
["VA 1102 Professional Competencies","Customer Service","Continuous Learning","III Elective","FLD 420 - Senior Acquisition Leadership Training (SALT) Mission 1: Understanding Self and Others",63,"N/A","N/A","Instructor Led"]
["VA 1102 Professional Competencies","Decisiveness","Continuous Learning","Available For All Levels","FCL-VA-0132 - Master Optimism to Improve Performance",2,"N/A","N/A","Web-based (Blackboard)"]
["VA 1102 Professional Competencies","Decisiveness","Continuous Learning","Available For All Levels","FCN 505 - Problem Solving for Acquisition Decision Making",8,"FCN FLCP 505 - Techniques for Acquisition Problem Solving",8,"Web-based (Blackboard)"]
["VA 1102 Professional Competencies","Decisiveness","Continuous Learning","Available For All Levels","FLD 410 - Supervising 1102s: Getting Your Team to Great",45,"N/A","N/A","Instructor Led"]
["VA 1102 Professional Competencies","Decisiveness","Continuous Learning","Available For All Levels","FLD 411 - Think About It: Systems Thinking in the VA",24,"NA","N/A","Instructor Led"]
["VA 1102 Professional Competencies","Decisiveness","Continuous Learning","Available For All Levels","FLD 413 - Think About It: Systems Thinking in the VA",12,"NA","N/A","Web-based (Blackboard)"]
["VA 1102 Professional Competencies","Delegation","Continuous Learning","II","FCN 800 - Delegating for Success",16,"FCN RBCC 800 - Managerial Contracting Officer, Delegating for Success",16,"Web-based (Blackboard)"]
["VA 1102 Professional Competencies","Delegation","Continuous Learning","Available For All Levels","FLD 410 - Supervising 1102s: Getting Your Team to Great",45,"N/A","N/A","Instructor Led"]
["VA 1102 Professional Competencies","Developing Direct Reports and Others","Continuous Learning","II","FCN 702 - Develop Others and Pay it Forward",16,"FCN RBCC 702 - Supervisory Contracting Officer, Develop Others and Pay It Forward",21,"Web-based (Blackboard)"]
["VA 1102 Professional Competencies","Developing Direct Reports and Others","Continuous Learning","Available For All Levels","FLD 410 - Supervising 1102s: Getting Your Team to Great",45,"N/A","N/A","Instructor Led"]
["VA 1102 Professional Competencies","Developing Direct Reports and Others","Continuous Learning","III Elective","FLD 420 - Senior Acquisition Leadership Training (SALT) Mission 1: Understanding Self and Others",63,"N/A","N/A","Instructor Led"]
["VA 1102 Professional Competencies","Emotional Intelligence","Continuous Learning","II","FCN 603 - Emotional Intelligence",18,"N/A","N/A","Web-based (Blackboard)"]
["VA 1102 Professional Competencies","Emotional Intelligence","Continuous Learning","Available For All Levels","FLD 411 - Think About It: Systems Thinking in the VA",24,"N/A","N/A","Instructor Led"]
["VA 1102 Professional Competencies","Flexibility","Continuous Learning","Available For All Levels","FCL-VA-0131 - Master Resilience to Thrive In Uncertainty",2,"N/A","N/A","Web-based (Blackboard)"]
["VA 1102 Professional Competencies","Flexibility","Continuous Learning","Available For All Levels","FCN 501 - Adapt to Change and Maintain Accountability",9,"FCN FLCP 501 - Adapt to Change and Maintain Accountability",9,"Web-based (Blackboard)"]
["VA 1102 Professional Competencies","Flexibility","Continuous Learning","Available For All Levels","FLD 411 - Think About It: Systems Thinking in the VA",24,"N/A","N/A","Instructor Led"]
["VA 1102 Professional Competencies","Informing","Continuous Learning","Available For All Levels","FCL-VA-0134 - Master Virtual Communication",2,"N/A","N/A","Web-based (Blackboard)"]
["VA 1102 Professional Competencies","Informing","Continuous Learning","II","FCN 703 - Manage the Message to Get Results",16,"FCN RBCC 703 - Supervisory Contracting Officer, Managing the Message to Get Results",17,"Web-based (Blackboard)"]
["VA 1102 Professional Competencies","Interpersonal Skills","Continuous Learning","Available For All Levels","FCN 503 - Build Networks: Maximizing Your Relationships",28,"FCN FLCP 503 - Build Networks: Maximizing Your Relationships",28,"Instructor Led"]
["VA 1102 Professional Competencies","Interpersonal Skills","Continuous Learning","Available For All Levels","FLD 124 - The Engaging Leader",16,"N/A","N/A","Instructor Led"]
["VA 1102 Professional Competencies","Interpersonal Skills","Continuous Learning","Available For All Levels","FLD 133 - Leadership and Management Skills for Non-Supervisory Contracting Professionals",24,"N/A","N/A","Instructor Led"]
["VA 1102 Professional Competencies","Interpersonal Skills","Continuous Learning","Available For All Levels","FLD 150 - Leadership Skills and Techniques",24,"N/A","N/A","Instructor Led"]
["VA 1102 Professional Competencies","Interpersonal Skills","Continuous Learning","Available For All Levels","FLD 410 - Supervising 1102s: Getting Your Team to Great",45,"N/A","N/A","Instructor Led"]
["VA 1102 Professional Competencies","Managing and Measuring Work","Continuous Learning","Available For All Levels","FCL-VA-0133 - Master Agility to Prevent Burnout",2,"N/A","N/A","Web-based (Blackboard)"]
["VA 1102 Professional Competencies","Managing and Measuring Work","Continuous Learning","II","FCN 700 - Managing and Measuring Work",15,"FCN RBCC 700 - Supervisory Contracting Officer, Managing and Measuring Work",16,"Web-based (Blackboard)"]
["VA 1102 Professional Competencies","Managing Diversity","Continuous Learning","II","FCN 704 - Champion Differences to Improve Acquisition Outcomes",16,"FCN RBCC 704 - Supervisory Contracting Officer, Champion Diversity to Improve Outcomes",16,"Web-based (Blackboard)"]
["VA 1102 Professional Competencies","Managing Vision and Purpose","Continuous Learning","III Elective","FLD 422 - Senior Acquisition Leadership Training (SALT) Mission 3: Words and Strategies in Action: Turning Challenges into Opportunities",49,"N/A","N/A","Instructor Led"]
["VA 1102 Professional Competencies","Motivating Others","Continuous Learning","Available For All Levels","FCL-VA-0132 - Master Optimism to Improve Performance",2,"N/A","N/A","Web-based (Blackboard)"]
["VA 1102 Professional Competencies","Oral Communication","Continuous Learning","Available For All Levels","FCL-VA-0134 - Master Virtual Communication",2,"N/A","N/A","Web-based (Blackboard)"]
["VA 1102 Professional Competencies","Oral Communication","Continuous Learning","Available For All Levels","FCN 506 - Communicate, Collaborate, and Connect",32,"FCN FLCP 506 - Wow the Crowd! Making Engaging Presentations",34,"Instructor Led"]
["VA 1102 Professional Competencies","Oral Communication","Continuous Learning","Available For All Levels","FLD 410 - Supervising 1102s: Getting Your Team to Great",45,"N/A","N/A","Instructor Led"]
["VA 1102 Professional Competencies","Oral Communication","Continuous Learning","III Elective","FLD 423 - Senior Acquisition Leadership Training (SALT) Mission 4: Your Leadership Legacy and Capstone",48,"N/A","N/A","Instructor Led"]
["VA 1102 Professional Competencies","Organizational Agility","Continuous Learning","III Elective","FLD 421 - Senior Acquisition Leadership Training (SALT) Mission 2: Thinking Strategically to Get Results",65,"N/A","N/A","Instructor Led"]
["VA 1102 Professional Competencies","Organizing","Continuous Learning","II","FCN 701 - Organizing a Winning Team",15,"FCN RBCC 701 - Supervisory Contracting Officer, Organizing A Winning Team",15,"Web-based (Blackboard)"]
["VA 1102 Professional Competencies","Peer Relationships","Continuous Learning","II","FCN 801 - Building Effective Peer Relationships",16,"FCN RBCC 801 - Managerial Contracting Officer, Building Effective Peer Relationships",16,"Web-based (Blackboard)"]
["VA 1102 Professional Competencies","Peer Relationships","Continuous Learning","Available For All Levels","FLD 410 - Supervising 1102s: Getting Your Team to Great",45,"N/A","N/A","Instructor Led"]
["VA 1102 Professional Competencies","Peer Relationships","Continuous Learning","III Elective","FLD 420 - Senior Acquisition Leadership Training (SALT) Mission 1: Understanding Self and Others",63,"N/A","N/A","Instructor Led"]
["VA 1102 Professional Competencies","Planning","Continuous Learning","II","FCN 600 - Planning: How To Make A Plan And Work It",12,"FCN RBCC 600 - Journeyman Contracting Officer, Planning: How to Make a Plan and Work It",12,"Web-based (Blackboard)"]
["VA 1102 Professional Competencies","Priority Setting","Continuous Learning","Available For All Levels","FCL-VA-0133 - Master Agility to Prevent Burnout",2,"N/A","N/A","Web-based (Blackboard)"]
["VA 1102 Professional Competencies","Priority Setting","Continuous Learning","II","FCN 601 - Priority Setting: Who's On First?",12,"FCN RBCC 601 - Journeyman Contracting Officer, Priority Setting: Who's On First?",12,"Web-based (Blackboard)"]
["VA 1102 Professional Competencies","Problem Solving","Continuous Learning","Available For All Levels","FCN 505 - Problem Solving for Acquisition Decision Making",8,"FCN FLCP 505 - Techniques for Acquisition Problem Solving",8,"Web-based (Blackboard)"]
["VA 1102 Professional Competencies","Problem Solving","Continuous Learning","Available For All Levels","FCN 521 - Advanced Problem Solving for 1102s",10,"FCN FLCP 521 - Identifying Problems and Creating Solutions",9,"Web-based (Blackboard)"]
["VA 1102 Professional Competencies","Problem Solving","Continuous Learning","Available For All Levels","FLD 151 - Critical Thinking for Problem Solving",24,"N/A","N/A","Instructor Led"]
["VA 1102 Professional Competencies","Problem Solving","Continuous Learning","Available For All Levels","FLD 410 - Supervising 1102s: Getting Your Team to Great",45,"N/A","N/A","Instructor Led"]
["VA 1102 Professional Competencies","Problem Solving","Continuous Learning","Available For All Levels","FLD 411 - Think About It: Systems Thinking in the VA",24,"N/A","N/A","Instructor Led"]
["VA 1102 Professional Competencies","Resilience","Continuous Learning","Available For All Levels","FCL-VA-0131 - Master Resilience to Thrive In Uncertainty",2,"N/A","N/A","Web-based (Blackboard)"]
["VA 1102 Professional Competencies","Resilience","Continuous Learning","Available For All Levels","FCN 507 - Strengthen Your Resilience: Thrive As An 1102",12,"FCN FLCP 507 - Strengthen Your Resilience: Thrive As An 1102",12,"Web-based (Blackboard)"]
["VA 1102 Professional Competencies","Resilience","Continuous Learning","Available For All Levels","FLD 410 - Supervising 1102s: Getting Your Team to Great",45,"N/A","N/A","Instructor Led"]
["VA 1102 Professional Competencies","Strategic Agility","Continuous Learning","Available For All Levels","FLD 151 - Critical Thinking for Problem Solving",24,"N/A","N/A","Instructor Led"]
["VA 1102 Professional Competencies","Strategic Agility","Continuous Learning","Available For All Levels","FLD 411 - Think About It: Systems Thinking in the VA",24,"N/A","N/A","Instructor Led"]
["VA 1102 Professional Competencies","Strategic Agility","Continuous Learning","III Elective","FLD 421 - Senior Acquisition Leadership Training (SALT) Mission 2: Thinking Strategically to Get Results",65,"N/A","N/A","Instructor Led"]
["VA 1102 Professional Competencies","Technical Credibility","Continuous Learning","Available For All Levels","FCN 508 - Building Credibility and Trust in Contracting",9,"FCN FLCP 508 - Building Credibility and Sustaining Influence",8,"Web-based (Blackboard)"]
["VA 1102 Professional Competencies","Technical Credibility","Continuous Learning","Available For All Levels","FFM 421 - Applied Fair and Reasonable Pricing Workshop",16,"N/A","N/A","Instructor Led"]
["VA 1102 Professional Competencies","Time Management","Continuous Learning","II","FCN 602 - Effective Time Management",14,"FCN RBCC 602 - Journeyman Contracting Officer, Effective Time Management",12,"Web-based (Blackboard)"]
["VA 1102 Professional Competencies","Written Communication","Continuous Learning","Available For All Levels","FCL-VA-0134 - Master Virtual Communication",2,"N/A","N/A","Web-based (Blackboard)"]
["VA 1102 Professional Competencies","Written Communication","Continuous Learning","Available For All Levels","FCN 502 - Effective Writing for 1102s",24,"FCN FLCP 502 - Business Writing for 1102s",24,"Instructor Led"]
["VA 1102 Professional Competencies","Written Communication","Continuous Learning","Available For All Levels","FCN 520 - Advanced Technical Writing for 1102s",20,"FCN FLCP 520 - Advanced Business Writing for 1102s",20,"Web-based (Blackboard)"]
["VA 1102 Professional Competencies","Written Communication","Continuous Learning","Available For All Levels","FFM 421 - Applied Fair and Reasonable Pricing Workshop",16,"N/A","N/A","Instructor Led"]
["VA 1102 Professional Competencies","Written Communication","Continuous Learning","III Elective","FLD 423 - Senior Acquisition Leadership Training (SALT) Mission 4: Your Leadership Legacy and Capstone",48,"N/A","N/A","Instructor Led"]

{"sheet":"Competency Definitions","index":3,"n_rows":58,"n_cols":4,"rows_kept":58,"cut":false,"hidden":true,"merged":[]}
["Competency","Definition","Unit of Competence","FAR Parts"]
["Accountability","Holds self and others accountable for measurable high-quality, timely, and cost-effective results. Determines objectives, sets priorities, and delegates work. Accepts responsibility for mistakes. Complies with established control systems and rules.","Professionalism","No Applicable FAR Parts"]
["Activity Program Coordinator for Purchase Card","Performs oversight and execution for the Purchase Card Program.","Other Competencies","FAR 13"]
["Addressing Small Business Concerns","1) Assist small business concerns in understanding how to do business with the government, identifying contracting opportunities, and responding to small business inquiries regarding payment delays or problems.\n\n2) Serve as a small business specialist and assist the Small Business Administration's assigned representative in conducting annual reviews of small business share, evaluation of contractors' subcontracting performance, and planning to maximize the use of small businesses.\n\n3) As a small business specialist provide recommendations on acquisition documents as to whether a particular acquisition should be set aside for one of the Small Business programs.","Small Business/Socio-Economic Programs","FAR 19"]
["Advanced Cost and/or Price Analysis","1) Evaluate the reasonableness of the contractor's proposed cost/price for use in preparing for complex negotiations.\n\n2) Develop positions on pricing-related contract terms and conditions to aid in developing the Government's position. \n\n3) Support special cost, price, and finance efforts by researching, analyzing and providing recommended positions that are in the best interests of the Government. \n\n4) Evaluate award fee/incentive fee plans and arrangements for adherence to policy and guidance.","Advanced Cost and/or Price Analysis","FAR 15"]
["Approve Payment Requests","Approve contractor request for payments to include final vouchers under cost reimbursement contracts, progress payments, performance-based payments, or commercial financing.","Contract Administration","FAR 32.1 - FAR 32.6, FAR 32.905"]
["Bid Evaluation (Sealed Bidding)","1) Evaluate the sealed bids in an transparent manner to preserve the integrity of the competitive process.  \n\n2) Perform price analysis to determine whether the lowest evaluated bid is reasonable and provides the best value to the Government.","Pre-Award and Award","FAR 14.1 - 14.4, FAR 14.408-2"]
["Building Effective Teams","Blends people into teams when needed; creates strong morale and spirit in his/her team; shares wins and successes; fosters open dialogue; lets people finish and be responsible for their work; defines success in terms of the whole team; creates a feeling of belonging in the team.","Professionalism","No Applicable FAR Parts"]
["Business Acumen","Knows how businesses work; knowledgeable in current and possible future policies, practices, trends, technology, and information affecting his/her business and organization; knows the competition; is aware of how strategies and tactics work in the marketplace. ","Professionalism","No Applicable FAR Parts"]
["Close-out Contracts","Close-out contracts following proper procedure to ensure property disposition, final payments, and documents/clearances have been received.","Contract Administration","FAR 4.804, FAR 4.804-5, FAR 4.805"]
["Command Skills","Relishes leading; takes unpopular stands if necessary; encourages direct and tough debate but isn’t afraid to end it and move on; is looked to for direction in a crisis; faces adversity head on; energized by tough challenges.","Professionalism","No Applicable FAR Parts"]
["Confronting Direct Reports","Deals with problem direct reports firmly and in a timely manner; doesn’t allow problems to fester; regularly reviews performance and holds timely discussions; can make negative decisions when all other efforts fail; deals effectively with troublemakers.","Professionalism","No Applicable FAR Parts"]
["Consider Socio-economic Requirements ","Consider socio-economic requirements including small business, labor, environmental, foreign, and other socio-economic requirements to provide maximum practicable contracting and subcontracting opportunities.","Pre-Award and Award","FAR 5, FAR 8.4, FAR 16, FAR 19.1 - FAR 19.3, FAR 19.4 - FAR 19.5, FAR 22 - FAR 26"]
["Construction/Architect & Engineering (A&E)","Develops acquisition strategies, issues notices/solicitations, conducts negotiations, selects sources, awards/administers contracts for construction & A&E in accordance w/reqts & procedures associated w/construction & A&E outlined in the FAR & supplemental policy & procedures (w/particular attention to FAR Part 36).","Other Competencies","FAR 11, FAR 14, FAR 19, FAR 22, FAR 28, \nFAR 36, FAR 48, FAR 52.242.14, FAR 52.236-13"]
["Contract Award","1) Select the awardee who, in the Government's estimation, provides the best value. \n\n2) Award contract/Issue task or delivery orders after ensuring fund availability and obtaining reviews and approvals\n\n3) Conducting pre/post award debriefings for all unsuccessful offerors when requested to ensure appropriate disclosure of information.","Pre-Award and Award","FAR 1, FAR 4, FAR 5, FAR 12, FAR 13, FAR 15, FAR 16, FAR 32"]
["Contract Performance Management","1) Administer contract by monitoring contracting officer representatives feedback, contractor performance, and enforcing contractor compliance with contract requirements.\n\n2) Ensure past performance evaluation is initiated to ensure documentation of performance including contracting officer input.\n\n3) Analyze, negotiate, and prepare claims file in order to issue final decisions.\n\n4) Resolve contract performance problems by gathering facts, determining remedies, and initiating remedial actions in order to find and provide a solution.","Contract Administration","FAR 9, FAR 32, FAR 33, FAR 42"]
["Contract Termination","Terminate contracts using applicable FAR (and supplemental) requirements if it is in the best interest in the government (either termination for convenience or cause/default).","Contract Termination","FAR 8, FAR 12, FAR 13, FAR 49"]
["Contracting in a Contingent and/or Combat Environment","Apply contracting expertise during deployments, contingency operations, or responses to natural disasters.","Contracting in a Contingent and/or Combat Environment","FAR 18"]
["Customer Service","Anticipates and meets the needs of both internal and external customers. Delivers high-quality products and services; is committed to continuous improvement.","Professionalism","No Applicable FAR Parts"]
["Decisiveness","Makes well-informed, effective, and timely decisions, even when data are limited or solutions produce unpleasant consequences; perceives the impact and implications of decisions.","Professionalism","No Applicable FAR Parts"]
["Delegation","Clearly and comfortably delegates both routine and important tasks and decisions; broadly shares both responsibility and accountability; tends to trust people to perform; lets direct reports and others finish their own work.","Professionalism","No Applicable FAR Parts"]
["Determination of How Best to Satisfy Requirements for the Mission Area","1) Provide proactive business advice on requirements documentation based on analysis of requirements and performance-based approaches to find the best solution to satisfy mission requirements. \n\n2) Conduct market research using relevant resources prior to solicitation to understand the industry environment and determine availability of sources of supply and/or services. \n\n3) Perform acquisition planning by considering all available sources and methods of procurement to satisfy mission needs while appropriately allocating risk.                                                                                                                                                                                                                    ","Pre-Award and Award","FAR 2, FAR 5, FAR 6, FAR 8, FAR 12-16, FAR 19, FAR 32, FAR 37"]
["Developing Direct Reports and Others","Provides challenging and stretching tasks and assignments; holds frequent development discussions; is aware of each person’s career goals; constructs compelling development plans and executes them; pushes people to accept developmental moves; will take on those who need help and further development; cooperates with the developmental system in the organization; is a people builder.\n\n• Supervisory Contracting Officer learns how to prepare Contract Specialists to become valued, trusted business advisors.\n• Supervisory Contracting Officer learns how to take the time to make developing direct reports a priority; actively identifies situations to develop reports in the process of completing work and day-to-day responsibilities.\n• Supervisory Contracting Officer learns how to make decisions on workload assignments and appropriately distribute work for meeting employee development goals.\n• Supervisory Contracting Officer learns how to work with direct reports to create developmental plans and conduct reviews on progress along their career path.\n• Supervisory Contracting Officer learns how to hold Contract Specialists accountable for performance; and communicates honest feedback in a professional manner on areas where further development is needed.","Professionalism","No Applicable FAR Parts"]
["E-Business and Automated Tools","Use e-business systems and automated tools to promote standardization, efficiency, and transparency.","Other Competencies","FAR 4, FAR 5, FAR 6, FAR 8, FAR 9, FAR 19"]
["Emotional Intelligence","Emotional Intelligence combines three (3) competencies: Conflict Management, Listening, and Negotiating. Please see the definitions below:\n\n1) Conflict Management - Steps up to conflicts, seeing them as opportunities; reads situations quickly; good at focused listening; can hammer out tough agreements and settle disputes equitably; can find common ground and get cooperation with minimum noise. \n\n2) Listening Practices - Attentive and active listening; has the patience to hear people out; can accurately restate the opinions of others even when he/she disagrees. \n\n3) Negotiating - Can negotiate skillfully in tough situations with both internal and external groups; can settle differences with minimum noise; can win concessions without damaging relationships; can be direct and forceful as well as diplomatic; gains trust quickly of other parties to the negotiations; has a good sense of timing.","Professionalism","No Applicable FAR Parts"]
["Flexibility","Is open to change and new information; rapidly adapts to new information, changing conditions, or unexpected obstacles.","Professionalism","No Applicable FAR Parts"]
["Informing","Provides the information people need to know to do their jobs and to feel good about being a member of the team, unit, and/or organization; provides individuals information so that they can make accurate decisions; is timely with information.\n\n• Supervisory Contracting Officer learns how to foster a transparent work environment; holds team meetings as a means to share information and seek input and involvement; empowers his/her team to make decisions.\n• Supervisory Contracting Officer shares information that helps employees to identify as part of a team and core to the purpose of the organization.\n• Supervisory Contracting Officer learns how to inform employees with relevant information required to complete their jobs, such as changes in approaches, regulations, and strategy.\n• Supervisory Contracting Officer learns how to keep customers informed; proactively provides customers with status updates.  \n• Supervisory Contracting Officer learns how to maintain open communication with leadership; learns to share all information both good and bad.","Professionalism","No Applicable FAR Parts"]
["Initiation of Work","1) Conduct post-award orientations to address customer concerns and contractor's responsibilities for performance of the contract.\n\n2) Plan for contract administration regarding delegating administrative functions; designating, training and managing CORs; and formally establishing all contract administration responsibilities.","Contract Administration","FAR 1, FAR 4, FAR 15, FAR 32, FAR 42, FAR 46, FAR 52.232-34 - FAR 52.232-38"]
["Interpersonal Skills","Treats others with courtesy, sensitivity, and respect. Considers and responds appropriately to the needs and feelings of different situations.","Professionalism","No Applicable FAR Parts"]
["Issue Changes and Modifications","Analyze the need for contract modifications and negotiate and issue contract modifications, as required.","Contract Administration","FAR 13, FAR 43"]
["Justification of Other than Full and Open","Justify the need to negotiate or award the contract without full and open competition or, in a multiple award scenario, without providing for fair opportunity based on business strategies and market research.","Develop and/or \nNegotiate Positions","FAR 5, FAR 6, FAR 8, FAR 13, FAR 16, FAR 19"]
["Managing and Measuring Work","Clearly assigns responsibility for tasks and decisions; sets clear objectives and measures; monitors process, progress, and results; designs feedback loops into work.\n\n• Supervisory Contracting Officer learns how to set performance expectations and team goals.\n• Supervisory Contracting Officer learns how to measure performance and identify what data is important. \n• Supervisory Contracting Officer learns how to set realistic expectations regarding work completion time, learns how to measure progress and quality, and conduct performance reviews with affected stakeholders.\n• Supervisory Contracting Officer learns how to develop a means and method to track progress to a plan.\n• Supervisory Contracting Officer learns how to evaluate current metric data to determine if measurement is meaningful and actionable.","Professionalism","No Applicable FAR Parts"]
["Managing Diversity","Manages all kinds and classes of people equitably; deals effectively with all races, nationalities, cultures, disabilities, ages and both sexes; hires variety and diversity without regard to class; supports equal and fair treatment and opportunity for all.","Professionalism","No Applicable FAR Parts"]
["Managing Vision and Purpose","Communicates a compelling and inspired vision or sense of core purpose; talks beyond today; talks about possibilities; is optimistic; creates mileposts and symbols to rally support behind the vision; makes the vision sharable by everyone; can inspire and motivate entire units or organizations.","Professionalism","No Applicable FAR Parts"]
["Motivating Others","Creates a climate in which people want to do their best; can motivate many kinds of direct reports and team or project members; can assess each person’s hot button and use it to get the best out of him/her; pushes tasks and decisions down; empowers others; invites input from each person and shares ownership and visibility; makes each individual feel his/her work is important; is someone people like working for and with.","Professionalism","No Applicable FAR Parts"]
["Negotiate Forward Pricing Rates Agreements & Administer Cost Accounting Standards","Negotiate forward pricing rate agreements (FPRAs) for billing purposes and administer cost accounting standards to ensure contractor's compliance.","Negotiate FPRAs & Administer Cost Accounting Standards","FAR 30, FAR 42.17"]
["Oral Communication","Makes clear and convincing oral presentations. Listens effectively; clarifies information as needed.","Professionalism","No Applicable FAR Parts"]
["Organizational Agility","Knowledgeable about how organizations work; knows how to get things done through formal channels and the informal network; understands the origin and reasoning behind key policies, practices, and procedures; understands the cultures of organizations.","Professionalism","No Applicable FAR Parts"]
["Organizing","Can marshal resources (people, funding, material, and support) to get things done; can orchestrate multiple activities at once to accomplish a goal; uses resources effectively and efficiently, arranges information and files in a useful manner.\n\n• Supervisory Contracting Officer learns how to manage and organize both individual and team workloads effectively.\n• Supervisory Contracting Officer learns how to organize and plan resources to meet the needs of customers.\n• Supervisory Contracting Officer learns how to balance priorities to achieve objectives.\n• Supervisory Contracting Officer learns how to extend time frames for organizing resources to consider both immediate and future workloads.","Professionalism","No Applicable FAR Parts"]
["Peer Relationships","Can quickly find common ground and solve problems for the good of all; can represent his/her own interests and yet be fair to other groups; can solve problems with peers with a minimum of noise; is seen as a team player and is cooperative; easily gains trust and support of peers; encourages collaboration; can be candid with peers.\n\n• Managerial Contracting Officer learns how to develop a network of professional colleagues and understands the importance of establishing and maintaining strong relationships.\n• Managerial Contracting Officer learns how to establish relationships and operate in a network of multi-functional managers. \n• Managerial Contracting Officer learns how to represent his/her own interests, while being candid and fair to peer groups.","Professionalism","No Applicable FAR Parts"]
["Planning","Accurately scopes out length and difficulty of tasks and projects; sets objectives and goals; breaks down work into the process steps; develops schedules and task/people assignments; anticipates and adjusts for problems and roadblocks; measures performance against goals; evaluates results.\n\n• Contracting Officer learns to improve processes and learn from past projects to more accurately plan existing procurements.\n• Contracting Officer learns to divide work amongst different types of Contract Specialists within an office. \n• Contracting Officer learns to forecast requirements and has the ability to manage multiple contracts in various stages of completion.\n• Contracting Officer learns to how to break projects down into tasks and steps and develop milestones for each.\n• Contracting Officer learns how to accurately estimate resources needed to accomplish contracting processes. ","Professionalism","No Applicable FAR Parts"]
["Preparation and Negotiation","1) Prepare for negotiations/discussions/awards by reviewing audit and technical reports, performing cost and/or price analysis (or reviewing price analysts reports), and developing pre-negotiation position to include identifying potential trade-offs.\n\n2) Negotiate terms and conditions (including price) based on the pre-negotiation objective and give-and-take with the offeror to establish a fair and reasonable price.  ","Develop and/or \nNegotiate Positions","FAR 15"]
["Priority Setting","Spends his/her time and the time of others on what’s important; quickly zeroes in on the critical few and puts the trivial aside; can quickly sense what will help or hinder accomplishing a goal; eliminates roadblocks; creates focus.\n\n• Contracting Officer learns to understand the distinction between what is important versus what is urgent.\n• Contracting Officer learns to rank priorities in contract actions.\n• Contracting Officer learns to prioritize requirements, workload, and urgent issues, and eliminate roadblocks to accomplish goals.\n• Contracting Officer learns to recognize potential risks and the impact on the overall schedule.","Professionalism","No Applicable FAR Parts"]
["Problem Solving","Identifies and analyzes problems; weighs relevance and accuracy of information; generates and evaluates alternative solutions; makes recommendations.","Professionalism","No Applicable FAR Parts"]
["Process Protests","Process protests to determine whether to withhold award or stop performance pending outcome of the protest.","Pre-Award and Award","FAR 15, FAR 33"]
["Procurement Analysis","1) Provide analysis to advise on procurement matters including contract documentation, legislation issues, and congressional inquiries impacting contracting matters. \n\n2) Develops procurement policy and changes in procedures through analysis of major procurements for statutory and regulatory compliance and a macro-analysis of contracting matters. \n\n3) Advise on high-level legislation & policy matters to recommend &/or lead change in the procurement process. \n\n4) Perform oversight & audits to review contract files, compile lessons learned, & ensure consistent policy application.","Procurement Policy","FAR 1, FAR 4, FAR 42"]
["Promote Competition","1) Conduct pre-solicitation industry conferences and analyze responses to draft solicitation terms and conditions to promote full and open competition.\n\n2) Identify and facilitate joint ventures and partnering on solicitations and subcontracting opportunities to increase competition and/or small business participation. ","Pre-Award and Award","FAR 5, FAR 6, FAR 8, FAR 14, FAR 16, FAR 19"]
["Proposal Evaluation (Contracting by Negotiation)","Evaluate proposals and quotes against evaluation criteria and request technical and pricing support, if needed, to identify offers that are acceptable or can be made acceptable.","Pre-Award and Award","FAR 15"]
["Resilience","Deals effectively with pressure; remains optimistic and persistent, even under adversity. Recovers quickly from setbacks.","Professionalism","No Applicable FAR Parts"]
["Responsibility Determination","Determine contractor responsibility by assessing past performance and financial stability to ensure that the contractor will be able to satisfy Government requirements.","Pre-Award and Award","FAR 9, FAR 19"]
["Solicitation of Offers","1) Conduct pre-bid or pre-proposal conference to inform offerors of the requirements of the acquisition.  \n\n2) Publicize proposed procurements to promote competition.  \n\n3) Issue a written solicitation consistent with the requirements documents, acquisition plan and source selection plan, that includes the appropriate provisions and clauses tailored to the requirement.\n\n4) Issue amendments or cancel solicitations when such actions are in the best interest of the Government and conform to law and regulations.\n\n5) Respond to preaward inquiries by taking the appropriate action according to FAR/DFARS (and applicable supplements) to resolve questions.","Pre-Award and Award","FAR 5, FAR 6, FAR 8, FAR 12, FAR 13, FAR 14, FAR 15, FAR 19, FAR 32, FAR 52.3"]
["Source Selection","1) Decide whether to hold discussions based on results of the evaluation.  \n\n2) Establish the competitive range to determine which of the offers will not be considered for the award.","Pre-Award and Award","FAR 15"]
["Source Selection Planning","Document a source selection plan that is consistent with public law, regulations, policy, and other guidelines.","Pre-Award and Award","FAR 7, FAR 15"]
["Strategic Agility","Sees ahead clearly; can anticipate future consequences and trends accurately; has broad knowledge and perspective; is future oriented; can articulately paint credible pictures and visions of possibilities and likelihoods; can create competitive and breakthrough strategies and plans.","Professionalism","No Applicable FAR Parts"]
["Technical Credibility","Understands and appropriately applies principles, procedures, requirements, regulations, and policies related to specialized expertise.","Professionalism","No Applicable FAR Parts"]
["Terms and Conditions","Determine terms and conditions, including special contract requirements applicable to the acquisition, that are appropriate for the acquisition to comply with laws and regulations (e.g. method of financing, Government property, intellectual property, OCI, specialty metals).","Develop and/or \nNegotiate Positions","FAR 52.3"]
["Time Management","Uses his/her time effectively and efficiently; values time; concentrates his/her efforts on the more important priorities; gets more done in less time than others; can attend to a broader range of activities.\n\n• Contracting Officer learns how to better manage multiple assignments at the same time.\n• Contracting Officer learns to balance speed to completion with quality.\n• Contracting Officer learns what he/she can control and what he/she can influence.\n• Contracting Officer learns how to better understand the customer’s needs and prioritize assignments accordingly.","Professionalism","No Applicable FAR Parts"]
["Written Communication","Writes in a clear, concise, organized, and convincing manner for the intended audience.","Professionalism","No Applicable FAR Parts"]