{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Input","Calc","Diagnose","Calc02","ProtoD"],"not_rendered":{"charts":7,"macros":1,"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"Input","index":0,"n_rows":197,"n_cols":6,"rows_kept":197,"merged":[[0,0,0,1],[0,2,1,3],[0,4,1,5],[9,0,10,0],[9,1,10,1]]}
["Level of Understanding ",null,"Percieved Importance",null,"Level of Contact (approx. per week)"]
["L4","Analyze, theorize, hypothesize & justify (new) knowledge"]
["L3","Compare & explain theories ",3,"High",3,{"$f":"IF(OR(C8=Calc!L17, C8=Calc!L16, C8=Calc!L15), \"High (e.g. > = 5 Hours allocated)\", \"Many Hours (e.g. > 9 contact hours)\")","v":"High (e.g. > = 5 Hours allocated)"}]
["L2","Demonstrate comprehension & application of knowledge",2,"Medium",2,{"$f":"IF(OR(C8=Calc!L17, C8=Calc!L16, C8=Calc!L15), \"Medium (e.g. = 4 Hours allocated)\", \"Some Hours (e.g. 6-9 contact hours)\")","v":"Medium (e.g. = 4 Hours allocated)"}]
["L1","Recall knowledge, do simple procedures & calculations",1,"Low",1,{"$f":"IF(OR(C8=Calc!L17, C8=Calc!L16, C8=Calc!L15), \"Low (e.g. < = 3 Hours allocated)\", \"Few Hours (e.g. < 6 contact hours)\")","v":"Low (e.g. < = 3 Hours allocated)"}]
["L0","Not Applicable",0,"Not Applicable",0,"No hours allocated"]
[]
["Course/Subject",null,"Please Select"]
[]
["Item","Description","Level","Percieved Importance","Allocated Hours"]
[]
["TSkill01","Technology and applications used in the industry and on the field",{"$f":"IF(ISERROR(ROUND(AVERAGE(VALUE(RIGHT(C13:C15))),0)), \" \", CONCATENATE(\"L\", ROUND(AVERAGE(VALUE(RIGHT(C13:C15))),0)))","v":" "},{"$f":"IF(ISERROR(AVERAGE(D13:D15)), \" \", ROUND(AVERAGE(D13:D15),0))","v":" "}," ",{"$f":"IF(OR(C12=\" \", D12=\" \", E12=\" \", $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C12))>=3, OR(D12<=1, E12<=1)), AND(D12=3, OR(VALUE(RIGHT(C12))<2, E12<=1)), AND(E12=3, OR(VALUE(RIGHT(C12))<2, D12<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
[null,"Use of technologies and applications within scope of work"]
[null,"Theories behind how and why certain equipment/technology is used to obtain results"]
[null,"Characteristics in different equipment used (tool & procedure)"]
["TSkill02","Programming and application manipulation (incl. scripting)",{"$f":"IF(ISERROR(ROUND(AVERAGE(VALUE(RIGHT(C17:C20))),0)), \" \", CONCATENATE(\"L\", ROUND(AVERAGE(VALUE(RIGHT(C17:C20))),0)))","v":" "},{"$f":"IF(ISERROR(AVERAGE(D17:D20)), \" \", ROUND(AVERAGE(D17:D20),0))","v":" "}," ",{"$f":"IF(OR(C16=\" \", D16=\" \", E16=\" \", $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C16))>=3, OR(D16<=1, E16<=1)), AND(D16=3, OR(VALUE(RIGHT(C16))<2, E16<=1)), AND(E16=3, OR(VALUE(RIGHT(C16))<2, D16<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
[null,"Theory of programming"]
[null,"Structure involved in the construction of the program"]
[null,"Programming languages to suit the needs of the program and scope of work"]
[null,"Automate tasks using various language and programming structure"]
["DGMSkill01","Types of data and its characteristics",{"$f":"IF(ISERROR(ROUND(AVERAGE(VALUE(RIGHT(C22:C24))),0)), \" \", CONCATENATE(\"L\", ROUND(AVERAGE(VALUE(RIGHT(C22:C24))),0)))","v":" "},{"$f":"IF(ISERROR(AVERAGE(D22:D24)), \" \", ROUND(AVERAGE(D22:D24),0))","v":" "}," ",{"$f":"IF(OR(C21=\" \", D21=\" \", E21=\" \", $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C21))>=3, OR(D21<=1, E21<=1)), AND(D21=3, OR(VALUE(RIGHT(C21))<2, E21<=1)), AND(E21=3, OR(VALUE(RIGHT(C21))<2, D21<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
[null,"Variety (types) of data and its uses"]
[null,"Data characteristics and its effect on scope of work"]
[null,"Data requirements for scope of data"]
["DGMSkill02","How data is gathered and technologies involved",{"$f":"IF(ISERROR(ROUND(AVERAGE(VALUE(RIGHT(C26:C27))),0)), \" \", CONCATENATE(\"L\", ROUND(AVERAGE(VALUE(RIGHT(C26:C27))),0)))","v":" "},{"$f":"IF(ISERROR(AVERAGE(D26:D27)), \" \", ROUND(AVERAGE(D26:D27),0))","v":" "}," ",{"$f":"IF(OR(C25=\" \", D25=\" \", E25=\" \", $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C25))>=3, OR(D25<=1, E25<=1)), AND(D25=3, OR(VALUE(RIGHT(C25))<2, E25<=1)), AND(E25=3, OR(VALUE(RIGHT(C25))<2, D25<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
[null,"Technologies and equipment required to gather the data"]
[null,"Components and logic that can have an effect on data gathered"]
["DGMSkill03","Plan for and the execution of processes to gather data",{"$f":"IF(ISERROR(ROUND(AVERAGE(VALUE(RIGHT(C29:C30))),0)), \" \", CONCATENATE(\"L\", ROUND(AVERAGE(VALUE(RIGHT(C29:C30))),0)))","v":" "},{"$f":"IF(ISERROR(AVERAGE(D29:D30)), \" \", ROUND(AVERAGE(D29:D30),0))","v":" "}," ",{"$f":"IF(OR(C28=\" \", D28=\" \", E28=\" \", $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C28))>=3, OR(D28<=1, E28<=1)), AND(D28=3, OR(VALUE(RIGHT(C28))<2, E28<=1)), AND(E28=3, OR(VALUE(RIGHT(C28))<2, D28<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
[null,"Techniques in the gathering of data"]
[null,"Characteristics of data gathering processes & techniques"]
["DGMSkill04","Manipulate and transform the data to fit the needs of the scope of work",{"$f":"IF(ISERROR(ROUND(AVERAGE(VALUE(RIGHT(C32:C34))),0)), \" \", CONCATENATE(\"L\", ROUND(AVERAGE(VALUE(RIGHT(C32:C34))),0)))","v":" "},{"$f":"IF(ISERROR(AVERAGE(D32:D34)), \" \", ROUND(AVERAGE(D32:D34),0))","v":" "}," ",{"$f":"IF(OR(C31=\" \", D31=\" \", E31=\" \", $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C31))>=3, OR(D31<=1, E31<=1)), AND(D31=3, OR(VALUE(RIGHT(C31))<2, E31<=1)), AND(E31=3, OR(VALUE(RIGHT(C31))<2, D31<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
[null,"Process and to be ability to physically transform data into a visual outcome"]
[null,"Presentation of data in an understandable (logical) manner"]
[null,"Techniques to structure data"]
["IMSkill01","Concepts related to image/map reading and production",{"$f":"IF(ISERROR(ROUND(AVERAGE(VALUE(RIGHT(C36:C38))),0)), \" \", CONCATENATE(\"L\", ROUND(AVERAGE(VALUE(RIGHT(C36:C38))),0)))","v":" "},{"$f":"IF(ISERROR(AVERAGE(D36:D38)), \" \", ROUND(AVERAGE(D36:D38),0))","v":" "}," ",{"$f":"IF(OR(C35=\" \", D35=\" \", E35=\" \", $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C35))>=3, OR(D35<=1, E35<=1)), AND(D35=3, OR(VALUE(RIGHT(C35))<2, E35<=1)), AND(E35=3, OR(VALUE(RIGHT(C35))<2, D35<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
[null,"How maps and images are made, its composition and factors involved (reasoning)"]
[null,"Different characteristics of maps and images"]
[null,"Differentiate between the various types of maps and images"]
["IMSkill02","Symbology, terms, colours and its effect on visualization and interpretation of maps and images",{"$f":"IF(ISERROR(ROUND(AVERAGE(VALUE(RIGHT(C40:C41))),0)), \" \", CONCATENATE(\"L\", ROUND(AVERAGE(VALUE(RIGHT(C40:C41))),0)))","v":" "},{"$f":"IF(ISERROR(AVERAGE(D40:D41)), \" \", ROUND(AVERAGE(D40:D41),0))","v":" "}," ",{"$f":"IF(OR(C39=\" \", D39=\" \", E39=\" \", $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C39))>=3, OR(D39<=1, E39<=1)), AND(D39=3, OR(VALUE(RIGHT(C39))<2, E39<=1)), AND(E39=3, OR(VALUE(RIGHT(C39))<2, D39<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
[null,"Reproduce maps and images suiting to the scope of work"]
[null,"Visualization techniques used to enable analysis of maps and images"]
["IMSkill03","Modelling characteristics and processes",{"$f":"IF(ISERROR(ROUND(AVERAGE(VALUE(RIGHT(C43:C45))),0)), \" \", CONCATENATE(\"L\", ROUND(AVERAGE(VALUE(RIGHT(C43:C45))),0)))","v":" "},{"$f":"IF(ISERROR(AVERAGE(D43:D45)), \" \", ROUND(AVERAGE(D43:D45),0))","v":" "}," ",{"$f":"IF(OR(C42=\" \", D42=\" \", E42=\" \", $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C42))>=3, OR(D42<=1, E42<=1)), AND(D42=3, OR(VALUE(RIGHT(C42))<2, E42<=1)), AND(E42=3, OR(VALUE(RIGHT(C42))<2, D42<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
[null,"Differentiate between various types of models"]
[null,"Different characteristics of models can affect interpretation of information/data"]
[null,"Processes required to produce a model"]
["SSkill01","Relationship between elements on a physical field",{"$f":"IF(ISERROR(ROUND(AVERAGE(VALUE(RIGHT(C47:C48))),0)), \" \", CONCATENATE(\"L\", ROUND(AVERAGE(VALUE(RIGHT(C47:C48))),0)))","v":" "},{"$f":"IF(ISERROR(AVERAGE(D47:D48)), \" \", ROUND(AVERAGE(D47:D48),0))","v":" "}," ",{"$f":"IF(OR(C46=\" \", D46=\" \", E46=\" \", $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C46))>=3, OR(D46<=1, E46<=1)), AND(D46=3, OR(VALUE(RIGHT(C46))<2, E46<=1)), AND(E46=3, OR(VALUE(RIGHT(C46))<2, D46<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
[null,"Different elements in the physical world can relate to one-another—the logic behind an outcome"]
[null,"Characteristics of different elements on the physical plane"]
["SSkill02","Use of GIS technology",{"$f":"IF(ISERROR(ROUND(AVERAGE(VALUE(RIGHT(C50:C51))),0)), \" \", CONCATENATE(\"L\", ROUND(AVERAGE(VALUE(RIGHT(C50:C51))),0)))","v":" "},{"$f":"IF(ISERROR(AVERAGE(D50:D51)), \" \", ROUND(AVERAGE(D50:D51),0))","v":" "}," ",{"$f":"IF(OR(C49=\" \", D49=\" \", E49=\" \", $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C49))>=3, OR(D49<=1, E49<=1)), AND(D49=3, OR(VALUE(RIGHT(C49))<2, E49<=1)), AND(E49=3, OR(VALUE(RIGHT(C49))<2, D49<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
[null,"Outcome (product of) GIS technology"]
[null,"Process and theory (concepts) involved in the analysis of GIS outcomes"]
["SSkill03","Concept of ‘spatial data’",{"$f":"IF(ISERROR(ROUND(AVERAGE(VALUE(RIGHT(C53:C54))),0)), \" \", CONCATENATE(\"L\", ROUND(AVERAGE(VALUE(RIGHT(C53:C54))),0)))","v":" "},{"$f":"IF(ISERROR(AVERAGE(D53:D54)), \" \", ROUND(AVERAGE(D53:D54),0))","v":" "}," ",{"$f":"IF(OR(C52=\" \", D52=\" \", E52=\" \", $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C52))>=3, OR(D52<=1, E52<=1)), AND(D52=3, OR(VALUE(RIGHT(C52))<2, E52<=1)), AND(E52=3, OR(VALUE(RIGHT(C52))<2, D52<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
[null,"Characteristics of 'spatial data'"]
[null,"Conversion/transformation and collection of 'spatial data'"]
["PSkill01","Scope of work",{"$f":"IF(ISERROR(ROUND(AVERAGE(VALUE(RIGHT(C56:C58))),0)), \" \", CONCATENATE(\"L\", ROUND(AVERAGE(VALUE(RIGHT(C56:C58))),0)))","v":" "},{"$f":"IF(ISERROR(AVERAGE(D56:D58)), \" \", ROUND(AVERAGE(D56:D58),0))","v":" "}," ",{"$f":"IF(OR(C55=\" \", D55=\" \", E55=\" \", $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C55))>=3, OR(D55<=1, E55<=1)), AND(D55=3, OR(VALUE(RIGHT(C55))<2, E55<=1)), AND(E55=3, OR(VALUE(RIGHT(C55))<2, D55<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
[null,"Determining what needs to be done"]
[null,"Organization of tasks to enable the production of outcomes related to work scope"]
[null,"Risks, and its impact, towards the work"]
["PSkill02","Communicate, defend and explain reasoning behind use of data/technology/application",{"$f":"IF(ISERROR(ROUND(AVERAGE(VALUE(RIGHT(C60:C62))),0)), \" \", CONCATENATE(\"L\", ROUND(AVERAGE(VALUE(RIGHT(C60:C62))),0)))","v":" "},{"$f":"IF(ISERROR(AVERAGE(D60:D62)), \" \", ROUND(AVERAGE(D60:D62),0))","v":" "}," ",{"$f":"IF(OR(C59=\" \", D59=\" \", E59=\" \", $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C59))>=3, OR(D59<=1, E59<=1)), AND(D59=3, OR(VALUE(RIGHT(C59))<2, E59<=1)), AND(E59=3, OR(VALUE(RIGHT(C59))<2, D59<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
[null,"Logic behind decisions/outcomes"]
[null,"How communiques could be affected by different styles of visualizations"]
[null,"Standards of communication as required by scope of work"]
["PSkill03","Relationships between different parties and fields within scope of work",{"$f":"IF(ISERROR(ROUND(AVERAGE(VALUE(RIGHT(C64:C65))),0)), \" \", CONCATENATE(\"L\", ROUND(AVERAGE(VALUE(RIGHT(C64:C65))),0)))","v":" "},{"$f":"IF(ISERROR(AVERAGE(D64:D65)), \" \", ROUND(AVERAGE(D64:D65),0))","v":" "}," ",{"$f":"IF(OR(C63=\" \", D63=\" \", E63=\" \", $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C63))>=3, OR(D63<=1, E63<=1)), AND(D63=3, OR(VALUE(RIGHT(C63))<2, E63<=1)), AND(E63=3, OR(VALUE(RIGHT(C63))<2, D63<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
[null,"Different industries/fields of expertise that have contact with Geospatial information"]
[null,"How different industries/fields of expertise use/perceive the information (gathered/outcome)"]
["PSkill04","Best practices as specified by industry",{"$f":"IF(ISERROR(ROUND(AVERAGE(VALUE(RIGHT(C67:C68))),0)), \" \", CONCATENATE(\"L\", ROUND(AVERAGE(VALUE(RIGHT(C67:C68))),0)))","v":" "},{"$f":"IF(ISERROR(AVERAGE(D67:D68)),\" \", ROUND(AVERAGE(D67:D68),0))","v":" "}," ",{"$f":"IF(OR(C66=\" \", D66=\" \", E66=\" \", $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C66))>=3, OR(D66<=1, E66<=1)), AND(D66=3, OR(VALUE(RIGHT(C66))<2, E66<=1)), AND(E66=3, OR(VALUE(RIGHT(C66))<2, D66<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
[null,"Social responsibilities"]
[null,"Ethics in the use of data and precautions towards the protection of ethnically-inclined (privacy) information"]
["ASkill01","Decision making within Geospatial Investigation",{"$f":"IF(ISERROR(ROUND(AVERAGE(VALUE(RIGHT(C70:C73))),0)), \" \", CONCATENATE(\"L\", ROUND(AVERAGE(VALUE(RIGHT(C70:C73))),0)))","v":" "},{"$f":"IF(ISERROR(AVERAGE(D70:D73)),\" \", ROUND(AVERAGE(D70:D73),0))","v":" "},{"$f":"IF(ISERROR(AVERAGE(E70:E73)),\" \", ROUND(AVERAGE(E70:E73),0))","v":" "},{"$f":"IF(OR(C69=\" \", D69=\" \", E69=\" \", $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C69))>=3, OR(D69<=1, E69<=1)), AND(D69=3, OR(VALUE(RIGHT(C69))<2, E69<=1)), AND(E69=3, OR(VALUE(RIGHT(C69))<2, D69<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
[null,"Planning, organizing, and execution of procedures and methods relating to Geospatial Investigation"]
[null,"Logistics of planning and execution of Geospatial Investigation"]
[null,"Reason and logic for Geospatial Investigation process and outcomes"]
[null,"Risks and problems involved with a Geospatial Investigation"]
["ASkill02","Information and data organization for Geospatial Investigation",{"$f":"IF(ISERROR(ROUND(AVERAGE(VALUE(RIGHT(C75:C77))),0)), \" \", CONCATENATE(\"L\", ROUND(AVERAGE(VALUE(RIGHT(C75:C77))),0)))","v":" "},{"$f":"IF(ISERROR(AVERAGE(D75:D77)),\" \", ROUND(AVERAGE(D75:D77),0))","v":" "}," ",{"$f":"IF(OR(C74=\" \", D74=\" \", E74=\" \", $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C74))>=3, OR(D74<=1, E74<=1)), AND(D74=3, OR(VALUE(RIGHT(C74))<2, E74<=1)), AND(E74=3, OR(VALUE(RIGHT(C74))<2, D74<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
[null,"Logistics involved in gathering, using and analyzing Geospatial Investigation data"]
[null,"Integration of collected data with other sources for the needs of Geospatial Investigation"]
[null,"Data integrity and protection"]
["BKnoMIV01","Map content, layout and production specifications (scale, size, projection, colour etc…)",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C78), ISBLANK(D78), ISBLANK(E78), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C78))>=3, OR(D78<=1, E78<=1)), AND(D78=3, OR(VALUE(RIGHT(C78))<2, E78<=1)), AND(E78=3, OR(VALUE(RIGHT(C78))<2, D78<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["BKnoMIV02","Coordinate system, data accuracy, data precision, and data quality",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C79), ISBLANK(D79), ISBLANK(E79), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C79))>=3, OR(D79<=1, E79<=1)), AND(D79=3, OR(VALUE(RIGHT(C79))<2, E79<=1)), AND(E79=3, OR(VALUE(RIGHT(C79))<2, D79<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["BKnoMIV03","Measurement systems and calculations involved in determining measurements",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C80), ISBLANK(D80), ISBLANK(E80), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C80))>=3, OR(D80<=1, E80<=1)), AND(D80=3, OR(VALUE(RIGHT(C80))<2, E80<=1)), AND(E80=3, OR(VALUE(RIGHT(C80))<2, D80<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["BKnoMIV04","Compilation of information from maps and images including, but not limited to: boundaries, topographic feature locations, and water bodies",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C81), ISBLANK(D81), ISBLANK(E81), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C81))>=3, OR(D81<=1, E81<=1)), AND(D81=3, OR(VALUE(RIGHT(C81))<2, E81<=1)), AND(E81=3, OR(VALUE(RIGHT(C81))<2, D81<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["BKnoMIV05","Calculation from map features including, but not limited to: distances, and contours",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C82), ISBLANK(D82), ISBLANK(E82), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C82))>=3, OR(D82<=1, E82<=1)), AND(D82=3, OR(VALUE(RIGHT(C82))<2, E82<=1)), AND(E82=3, OR(VALUE(RIGHT(C82))<2, D82<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["BKnoDDM01","How data are gathered, different data sources available and their quality",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C83), ISBLANK(D83), ISBLANK(E83), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C83))>=3, OR(D83<=1, E83<=1)), AND(D83=3, OR(VALUE(RIGHT(C83))<2, E83<=1)), AND(E83=3, OR(VALUE(RIGHT(C83))<2, D83<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["BKnoDDM02","The cause and effect of data accuracy and error",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C84), ISBLANK(D84), ISBLANK(E84), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C84))>=3, OR(D84<=1, E84<=1)), AND(D84=3, OR(VALUE(RIGHT(C84))<2, E84<=1)), AND(E84=3, OR(VALUE(RIGHT(C84))<2, D84<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["BKnoDDM03","Basic query language to allow for analysis/gathering of data",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C85), ISBLANK(D85), ISBLANK(E85), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C85))>=3, OR(D85<=1, E85<=1)), AND(D85=3, OR(VALUE(RIGHT(C85))<2, E85<=1)), AND(E85=3, OR(VALUE(RIGHT(C85))<2, D85<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["BKnoDDM04","Different aspects relating to data reliability",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C86), ISBLANK(D86), ISBLANK(E86), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C86))>=3, OR(D86<=1, E86<=1)), AND(D86=3, OR(VALUE(RIGHT(C86))<2, E86<=1)), AND(E86=3, OR(VALUE(RIGHT(C86))<2, D86<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["BKnoDDM05","Precautions to data integrity and data sensitivity",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C87), ISBLANK(D87), ISBLANK(E87), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C87))>=3, OR(D87<=1, E87<=1)), AND(D87=3, OR(VALUE(RIGHT(C87))<2, E87<=1)), AND(E87=3, OR(VALUE(RIGHT(C87))<2, D87<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["BKnoGP01","Report and produce results for projects as per industry standards",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C88), ISBLANK(D88), ISBLANK(E88), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C88))>=3, OR(D88<=1, E88<=1)), AND(D88=3, OR(VALUE(RIGHT(C88))<2, E88<=1)), AND(E88=3, OR(VALUE(RIGHT(C88))<2, D88<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["BKnoGP02","Communication and organization of communiques in a logical and easy-to-understand manner",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C89), ISBLANK(D89), ISBLANK(E89), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C89))>=3, OR(D89<=1, E89<=1)), AND(D89=3, OR(VALUE(RIGHT(C89))<2, E89<=1)), AND(E89=3, OR(VALUE(RIGHT(C89))<2, D89<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["BKnoGP03","Visualization and information dissemination techniques",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C90), ISBLANK(D90), ISBLANK(E90), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C90))>=3, OR(D90<=1, E90<=1)), AND(D90=3, OR(VALUE(RIGHT(C90))<2, E90<=1)), AND(E90=3, OR(VALUE(RIGHT(C90))<2, D90<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["BKnoND01","Scale and manipulation of data into respective units",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C91), ISBLANK(D91), ISBLANK(E91), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C91))>=3, OR(D91<=1, E91<=1)), AND(D91=3, OR(VALUE(RIGHT(C91))<2, E91<=1)), AND(E91=3, OR(VALUE(RIGHT(C91))<2, D91<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["BKnoND02","Mathematical adjustment and manipulation to ensure quality and reliability of data",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C92), ISBLANK(D92), ISBLANK(E92), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C92))>=3, OR(D92<=1, E92<=1)), AND(D92=3, OR(VALUE(RIGHT(C92))<2, E92<=1)), AND(E92=3, OR(VALUE(RIGHT(C92))<2, D92<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["BKnoND03","Statistics and statistical processes to generate outcomes for specific needs",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C93), ISBLANK(D93), ISBLANK(E93), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C93))>=3, OR(D93<=1, E93<=1)), AND(D93=3, OR(VALUE(RIGHT(C93))<2, E93<=1)), AND(E93=3, OR(VALUE(RIGHT(C93))<2, D93<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["BKnoND04","Geometrical relationships and application of geometrical processes ",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C94), ISBLANK(D94), ISBLANK(E94), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C94))>=3, OR(D94<=1, E94<=1)), AND(D94=3, OR(VALUE(RIGHT(C94))<2, E94<=1)), AND(E94=3, OR(VALUE(RIGHT(C94))<2, D94<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["BKnoND05","Spatial patterns and relationships ",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C95), ISBLANK(D95), ISBLANK(E95), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C95))>=3, OR(D95<=1, E95<=1)), AND(D95=3, OR(VALUE(RIGHT(C95))<2, E95<=1)), AND(E95=3, OR(VALUE(RIGHT(C95))<2, D95<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["BKnoND06","Mathematical knowledge including, but not limited to: Algebra, Geometry, Trigonometry, Statistics, and Simple Math",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C96), ISBLANK(D96), ISBLANK(E96), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C96))>=3, OR(D96<=1, E96<=1)), AND(D96=3, OR(VALUE(RIGHT(C96))<2, E96<=1)), AND(E96=3, OR(VALUE(RIGHT(C96))<2, D96<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["BKnoPPS01","Ways of automation via physical and computerized processes",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C97), ISBLANK(D97), ISBLANK(E97), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C97))>=3, OR(D97<=1, E97<=1)), AND(D97=3, OR(VALUE(RIGHT(C97))<2, E97<=1)), AND(E97=3, OR(VALUE(RIGHT(C97))<2, D97<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["BKnoPPS02","Basic scripting procedures and its effect",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C98), ISBLANK(D98), ISBLANK(E98), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C98))>=3, OR(D98<=1, E98<=1)), AND(D98=3, OR(VALUE(RIGHT(C98))<2, E98<=1)), AND(E98=3, OR(VALUE(RIGHT(C98))<2, D98<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["BKnoPPS03","Industry standards and ways of achieving (affecting) the standards",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C99), ISBLANK(D99), ISBLANK(E99), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C99))>=3, OR(D99<=1, E99<=1)), AND(D99=3, OR(VALUE(RIGHT(C99))<2, E99<=1)), AND(E99=3, OR(VALUE(RIGHT(C99))<2, D99<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["BKnoPPS04","Methodologies to achieving industry standards",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C100), ISBLANK(D100), ISBLANK(E100), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C100))>=3, OR(D100<=1, E100<=1)), AND(D100=3, OR(VALUE(RIGHT(C100))<2, E100<=1)), AND(E100=3, OR(VALUE(RIGHT(C100))<2, D100<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["BKnoG01","Concept of geographical referencing, locations and relations between geographical features",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C101), ISBLANK(D101), ISBLANK(E101), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C101))>=3, OR(D101<=1, E101<=1)), AND(D101=3, OR(VALUE(RIGHT(C101))<2, E101<=1)), AND(E101=3, OR(VALUE(RIGHT(C101))<2, D101<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["BKnoG02","Regions and boundaries",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C102), ISBLANK(D102), ISBLANK(E102), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C102))>=3, OR(D102<=1, E102<=1)), AND(D102=3, OR(VALUE(RIGHT(C102))<2, E102<=1)), AND(E102=3, OR(VALUE(RIGHT(C102))<2, D102<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["BKnoG03","Relationship and differences between local-national-regional-global scales",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C103), ISBLANK(D103), ISBLANK(E103), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C103))>=3, OR(D103<=1, E103<=1)), AND(D103=3, OR(VALUE(RIGHT(C103))<2, E103<=1)), AND(E103=3, OR(VALUE(RIGHT(C103))<2, D103<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["BKnoG04","Relationship between coverage and spread of Geographical phenomena",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C104), ISBLANK(D104), ISBLANK(E104), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C104))>=3, OR(D104<=1, E104<=1)), AND(D104=3, OR(VALUE(RIGHT(C104))<2, E104<=1)), AND(E104=3, OR(VALUE(RIGHT(C104))<2, D104<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["BKnoG05","Movement of geographical features & phenomena, links and relationship between movement",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C105), ISBLANK(D105), ISBLANK(E105), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C105))>=3, OR(D105<=1, E105<=1)), AND(D105=3, OR(VALUE(RIGHT(C105))<2, E105<=1)), AND(E105=3, OR(VALUE(RIGHT(C105))<2, D105<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["BKnoG06","Human-Environment interaction",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C106), ISBLANK(D106), ISBLANK(E106), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C106))>=3, OR(D106<=1, E106<=1)), AND(D106=3, OR(VALUE(RIGHT(C106))<2, E106<=1)), AND(E106=3, OR(VALUE(RIGHT(C106))<2, D106<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["BKnoG07","Impacts of specific/localized phenomenon",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C107), ISBLANK(D107), ISBLANK(E107), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C107))>=3, OR(D107<=1, E107<=1)), AND(D107=3, OR(VALUE(RIGHT(C107))<2, E107<=1)), AND(E107=3, OR(VALUE(RIGHT(C107))<2, D107<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["BKnoG08","Effect of culture on Geography and perception of geographic phenomena and its relationships",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C108), ISBLANK(D108), ISBLANK(E108), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C108))>=3, OR(D108<=1, E108<=1)), AND(D108=3, OR(VALUE(RIGHT(C108))<2, E108<=1)), AND(E108=3, OR(VALUE(RIGHT(C108))<2, D108<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SupKnoCB01","BIM",{"$f":"IF(ISERROR(ROUND(AVERAGE(VALUE(RIGHT(C110:C114))),0)), \" \", CONCATENATE(\"L\", ROUND(AVERAGE(VALUE(RIGHT(C110:C114))),0)))","v":" "},{"$f":"IF(ISERROR(AVERAGE(D110:D114)), \" \", ROUND(AVERAGE(D110:D114),0))","v":" "}," ",{"$f":"IF(OR(C109=\" \", D109=\" \", E109=\" \", $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C109))>=3, OR(D109<=1, E109<=1)), AND(D109=3, OR(VALUE(RIGHT(C109))<2, E109<=1)), AND(E109=3, OR(VALUE(RIGHT(C109))<2, D109<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
[null,"Concepts and purpose of BIM and the role that it plays in the field of construction"]
[null,"Applications of BIM in other fields and its integration into the building life-cycle"]
[null,"BIM techniques to assist in decision-making"]
[null,"Processs involved in production of BIM and the effects it could have on overall outcome"]
[null,"Information type as required by the various stakeholders and the integration of various needs into the model"]
["SupKnoCB02","Construction",{"$f":"IF(ISERROR(ROUND(AVERAGE(VALUE(RIGHT(C116:C117))),0)), \" \", CONCATENATE(\"L\", ROUND(AVERAGE(VALUE(RIGHT(C116:C117))),0)))","v":" "},{"$f":"IF(ISERROR(AVERAGE(D116:D117)), \" \", ROUND(AVERAGE(D116:D117),0))","v":" "}," ",{"$f":"IF(OR(C115=\" \", D115=\" \", E115=\" \", $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C115))>=3, OR(D115<=1, E115<=1)), AND(D115=3, OR(VALUE(RIGHT(C115))<2, E115<=1)), AND(E115=3, OR(VALUE(RIGHT(C115))<2, D115<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
[null,"Construction standards and processes used"]
[null,"Documentation (e.g., specifications) required per industry standards"]
["SupKnoE01","Urban/Built Environment",{"$f":"IF(ISERROR(ROUND(AVERAGE(VALUE(RIGHT(C119:C121))),0)), \" \", CONCATENATE(\"L\", ROUND(AVERAGE(VALUE(RIGHT(C119:C121))),0)))","v":" "},{"$f":"IF(ISERROR(AVERAGE(D119:D121)), \" \", ROUND(AVERAGE(D119:D121),0))","v":" "}," ",{"$f":"IF(OR(C118=\" \", D118=\" \", E118=\" \", $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C118))>=3, OR(D118<=1, E118<=1)), AND(D118=3, OR(VALUE(RIGHT(C118))<2, E118<=1)), AND(E118=3, OR(VALUE(RIGHT(C118))<2, D118<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
[null,"Elements of the urban environment"]
[null,"The way in which urban environment could be shaped and changed"]
[null,"Restraints and factors that affect the changes to the urban environment"]
["SupKnoE02","Natural Environment",{"$f":"IF(ISERROR(ROUND(AVERAGE(VALUE(RIGHT(C123:C124))),0)), \" \", CONCATENATE(\"L\", ROUND(AVERAGE(VALUE(RIGHT(C123:C124))),0)))","v":" "},{"$f":"IF(ISERROR(AVERAGE(D123:D124)), \" \", ROUND(AVERAGE(D123:D124),0))","v":" "}," ",{"$f":"IF(OR(C122=\" \", D122=\" \", E122=\" \", $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C122))>=3, OR(D122<=1, E122<=1)), AND(D122=3, OR(VALUE(RIGHT(C122))<2, E122<=1)), AND(E122=3, OR(VALUE(RIGHT(C122))<2, D122<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
[null,"Issues that affect natural environment"]
[null,"Elements within the natural environment"]
["SupKnoS01","Human Geography",{"$f":"IF(ISERROR(ROUND(AVERAGE(VALUE(RIGHT(C126:C127))),0)), \" \", CONCATENATE(\"L\", ROUND(AVERAGE(VALUE(RIGHT(C126:C127))),0)))","v":" "},{"$f":"IF(ISERROR(AVERAGE(D126:D127)), \" \", ROUND(AVERAGE(D126:D127),0))","v":" "}," ",{"$f":"IF(OR(C125=\" \", D125=\" \", E125=\" \", $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C125))>=3, OR(D125<=1, E125<=1)), AND(D125=3, OR(VALUE(RIGHT(C125))<2, E125<=1)), AND(E125=3, OR(VALUE(RIGHT(C125))<2, D125<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
[null,"Demographics and social data"]
[null,"Factors affecting changes to human geography"]
["SupKnoS02","Risk Management",{"$f":"IF(ISERROR(ROUND(AVERAGE(VALUE(RIGHT(C129:C133))),0)), \" \", CONCATENATE(\"L\", ROUND(AVERAGE(VALUE(RIGHT(C129:C133))),0)))","v":" "},{"$f":"IF(ISERROR(AVERAGE(D129:D133)), \" \", ROUND(AVERAGE(D129:D133),0))","v":" "}," ",{"$f":"IF(OR(C128=\" \", D128=\" \", E128=\" \", $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C128))>=3, OR(D128<=1, E128<=1)), AND(D128=3, OR(VALUE(RIGHT(C128))<2, E128<=1)), AND(E128=3, OR(VALUE(RIGHT(C128))<2, D128<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
[null,"Types of risks and mitigation procedures"]
[null,"Process involved with the indentification of risks and mitigation techniques"]
[null,"Difference between risks and disasters"]
[null,"How different tyeps of risks can affect the surrounding environment and its repercussion"]
[null,"Potential risks and hazards"]
["SpKnoRST01","Collection of geospatial data using remote sensing technologies including, but not limited to: aerial photography, light and radio wave detection systems, digital satellites, thermal energy systems",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C134), ISBLANK(D134), ISBLANK(E134), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C134))>=3, OR(D134<=1, E134<=1)), AND(D134=3, OR(VALUE(RIGHT(C134))<2, E134<=1)), AND(E134=3, OR(VALUE(RIGHT(C134))<2, D134<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoRST02","Monitor quality and integrity of remote sensing data, process and procedures",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C135), ISBLANK(D135), ISBLANK(E135), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C135))>=3, OR(D135<=1, E135<=1)), AND(D135=3, OR(VALUE(RIGHT(C135))<2, E135<=1)), AND(E135=3, OR(VALUE(RIGHT(C135))<2, D135<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoRST03","Integration of remotely sensed data with other geospatial data",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C136), ISBLANK(D136), ISBLANK(E136), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C136))>=3, OR(D136<=1, E136<=1)), AND(D136=3, OR(VALUE(RIGHT(C136))<2, E136<=1)), AND(E136=3, OR(VALUE(RIGHT(C136))<2, D136<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoRST04","Adjustments to remotely sensed data for presentation using software",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C137), ISBLANK(D137), ISBLANK(E137), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C137))>=3, OR(D137<=1, E137<=1)), AND(D137=3, OR(VALUE(RIGHT(C137))<2, E137<=1)), AND(E137=3, OR(VALUE(RIGHT(C137))<2, D137<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoRST05","Selection and definition of image display, image set categories and processing routines",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C138), ISBLANK(D138), ISBLANK(E138), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C138))>=3, OR(D138<=1, E138<=1)), AND(D138=3, OR(VALUE(RIGHT(C138))<2, E138<=1)), AND(E138=3, OR(VALUE(RIGHT(C138))<2, D138<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoRST06","Manipulation and enhancement of raw data for interpretation",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C139), ISBLANK(D139), ISBLANK(E139), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C139))>=3, OR(D139<=1, E139<=1)), AND(D139=3, OR(VALUE(RIGHT(C139))<2, E139<=1)), AND(E139=3, OR(VALUE(RIGHT(C139))<2, D139<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoRST07","Correction for error factors on remotely sensed data including, but not limited to: skew, and atmospheric variation",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C140), ISBLANK(D140), ISBLANK(E140), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C140))>=3, OR(D140<=1, E140<=1)), AND(D140=3, OR(VALUE(RIGHT(C140))<2, E140<=1)), AND(E140=3, OR(VALUE(RIGHT(C140))<2, D140<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoRST08","Manage and analysis of data from remote sensing systems using image analysis software or GIS",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C141), ISBLANK(D141), ISBLANK(E141), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C141))>=3, OR(D141<=1, E141<=1)), AND(D141=3, OR(VALUE(RIGHT(C141))<2, E141<=1)), AND(E141=3, OR(VALUE(RIGHT(C141))<2, D141<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoRST09","Processing of aerial and satellite imagery to create products for analysis",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C142), ISBLANK(D142), ISBLANK(E142), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C142))>=3, OR(D142<=1, E142<=1)), AND(D142=3, OR(VALUE(RIGHT(C142))<2, E142<=1)), AND(E142=3, OR(VALUE(RIGHT(C142))<2, D142<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoRST10","Integration of other data sources into product",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C143), ISBLANK(D143), ISBLANK(E143), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C143))>=3, OR(D143<=1, E143<=1)), AND(D143=3, OR(VALUE(RIGHT(C143))<2, E143<=1)), AND(E143=3, OR(VALUE(RIGHT(C143))<2, D143<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoSTLA01","Measurements of features using survey equipment including, but not limited to: theodolites, EDMs, transits, levels, GPS",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C144), ISBLANK(D144), ISBLANK(E144), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C144))>=3, OR(D144<=1, E144<=1)), AND(D144=3, OR(VALUE(RIGHT(C144))<2, E144<=1)), AND(E144=3, OR(VALUE(RIGHT(C144))<2, D144<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoSTLA02","Calibrations, adjustments and maintenance of survey equipment",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C145), ISBLANK(D145), ISBLANK(E145), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C145))>=3, OR(D145<=1, E145<=1)), AND(D145=3, OR(VALUE(RIGHT(C145))<2, E145<=1)), AND(E145=3, OR(VALUE(RIGHT(C145))<2, D145<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoSTLA03","Plan and set out surveys as per industry standards including, but not limited to: reducing errors, closing traverse and level runs, establishing control points, setting out stakes and markers",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C146), ISBLANK(D146), ISBLANK(E146), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C146))>=3, OR(D146<=1, E146<=1)), AND(D146=3, OR(VALUE(RIGHT(C146))<2, E146<=1)), AND(E146=3, OR(VALUE(RIGHT(C146))<2, D146<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoSTLA04","Performing calculations relating to, but not limited to: heights, depths, relative positions, property lines, terrain characteristics",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C147), ISBLANK(D147), ISBLANK(E147), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C147))>=3, OR(D147<=1, E147<=1)), AND(D147=3, OR(VALUE(RIGHT(C147))<2, E147<=1)), AND(E147=3, OR(VALUE(RIGHT(C147))<2, D147<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoSTLA05","Calculations, corrections and adjustments for result (and errors) including, but not limited to: earth curvature, atmospheric impacts, traverse closures, level runs",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C148), ISBLANK(D148), ISBLANK(E148), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C148))>=3, OR(D148<=1, E148<=1)), AND(D148=3, OR(VALUE(RIGHT(C148))<2, E148<=1)), AND(E148=3, OR(VALUE(RIGHT(C148))<2, D148<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoSTLA06","Verification of land survey data including, but not limited to: measurements, calculations, levels, marker placements",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C149), ISBLANK(D149), ISBLANK(E149), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C149))>=3, OR(D149<=1, E149<=1)), AND(D149=3, OR(VALUE(RIGHT(C149))<2, E149<=1)), AND(E149=3, OR(VALUE(RIGHT(C149))<2, D149<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoSTLA07","Preparation and maintenance of maps, sketches, reports and legal description as per industry standards",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C150), ISBLANK(D150), ISBLANK(E150), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C150))>=3, OR(D150<=1, E150<=1)), AND(D150=3, OR(VALUE(RIGHT(C150))<2, E150<=1)), AND(E150=3, OR(VALUE(RIGHT(C150))<2, D150<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoSTLA08","Determination and measurement of land/property boundary through surveys to use in deeds, leases or other legal documentations",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C151), ISBLANK(D151), ISBLANK(E151), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C151))>=3, OR(D151<=1, E151<=1)), AND(D151=3, OR(VALUE(RIGHT(C151))<2, E151<=1)), AND(E151=3, OR(VALUE(RIGHT(C151))<2, D151<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoSTLA09","Preparation, planning and conducting surveys as per industry standards to establish, maintain, and verification of legal boundaries",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C152), ISBLANK(D152), ISBLANK(E152), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C152))>=3, OR(D152<=1, E152<=1)), AND(D152=3, OR(VALUE(RIGHT(C152))<2, E152<=1)), AND(E152=3, OR(VALUE(RIGHT(C152))<2, D152<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoSTLA10","Determination and recording of survey results including, but not limited to: shape, contour, location, elevation, dimensions",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C153), ISBLANK(D153), ISBLANK(E153), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C153))>=3, OR(D153<=1, E153<=1)), AND(D153=3, OR(VALUE(RIGHT(C153))<2, E153<=1)), AND(E153=3, OR(VALUE(RIGHT(C153))<2, D153<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoSTLA11","Conducting surveys using various surveying equipment and methods to locate and identify features (natural and man-made) in spatial context including, but not limited to: Earth surface, underground, underwater",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C154), ISBLANK(D154), ISBLANK(E154), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C154))>=3, OR(D154<=1, E154<=1)), AND(D154=3, OR(VALUE(RIGHT(C154))<2, E154<=1)), AND(E154=3, OR(VALUE(RIGHT(C154))<2, D154<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoPCT01","Identification of errors on maps and images to enable correction and adjustments to ensure accuracy of product",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C155), ISBLANK(D155), ISBLANK(E155), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C155))>=3, OR(D155<=1, E155<=1)), AND(D155=3, OR(VALUE(RIGHT(C155))<2, E155<=1)), AND(E155=3, OR(VALUE(RIGHT(C155))<2, D155<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoPCT02","Understanding, identifying and adjustments of geodetic points, elevations, planimetric features, and topographic features through application of standard mathematical formulas",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C156), ISBLANK(D156), ISBLANK(E156), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C156))>=3, OR(D156<=1, E156<=1)), AND(D156=3, OR(VALUE(RIGHT(C156))<2, E156<=1)), AND(E156=3, OR(VALUE(RIGHT(C156))<2, D156<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoPCT03","Compilation and management of geospatial data including, but not limited to: aerial photographs, survey notes, records, reports and maps",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C157), ISBLANK(D157), ISBLANK(E157), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C157))>=3, OR(D157<=1, E157<=1)), AND(D157=3, OR(VALUE(RIGHT(C157))<2, E157<=1)), AND(E157=3, OR(VALUE(RIGHT(C157))<2, D157<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoPCT04","Use of stereoscopic plotting and computer graphics equipment for alteration or production of geospatial products including, but not limited to: trace maps, charts, tables, detailed drawings, terrain models, 3D optical models, topographic maps, and aerial-photo mosaics",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C158), ISBLANK(D158), ISBLANK(E158), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C158))>=3, OR(D158<=1, E158<=1)), AND(D158=3, OR(VALUE(RIGHT(C158))<2, E158<=1)), AND(E158=3, OR(VALUE(RIGHT(C158))<2, D158<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoPCT05","Use of stereoplotting apparatus, drafting equipment, and computer software to delineate photographic details",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C159), ISBLANK(D159), ISBLANK(E159), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C159))>=3, OR(D159<=1, E159<=1)), AND(D159=3, OR(VALUE(RIGHT(C159))<2, E159<=1)), AND(E159=3, OR(VALUE(RIGHT(C159))<2, D159<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoPCT06","Understanding of information from geospatial data gathering including, but not limited to: ground surveys, reports, aerial photos, and topographic maps",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C160), ISBLANK(D160), ISBLANK(E160), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C160))>=3, OR(D160<=1, E160<=1)), AND(D160=3, OR(VALUE(RIGHT(C160))<2, E160<=1)), AND(E160=3, OR(VALUE(RIGHT(C160))<2, D160<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoPCT07","Production of maps and images showing information relating to, but not limited to: boundaries, water location, topographic details, and contours",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C161), ISBLANK(D161), ISBLANK(E161), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C161))>=3, OR(D161<=1, E161<=1)), AND(D161=3, OR(VALUE(RIGHT(C161))<2, E161<=1)), AND(E161=3, OR(VALUE(RIGHT(C161))<2, D161<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoPCT08","Comparison of topographic features between data sources including, but not limited to: aerial photos, maps, and written documents",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C162), ISBLANK(D162), ISBLANK(E162), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C162))>=3, OR(D162<=1, E162<=1)), AND(D162=3, OR(VALUE(RIGHT(C162))<2, E162<=1)), AND(E162=3, OR(VALUE(RIGHT(C162))<2, D162<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoGIS01","Evaluation of data for accuracy, precision, usefulness, quality and completeness",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C163), ISBLANK(D163), ISBLANK(E163), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C163))>=3, OR(D163<=1, E163<=1)), AND(D163=3, OR(VALUE(RIGHT(C163))<2, E163<=1)), AND(E163=3, OR(VALUE(RIGHT(C163))<2, D163<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoGIS02","Interpretation and management of geospatial data from various sources including, but not limited to: mapping coordinates, remote sensing images, photogrammetric images, maps, and survey data",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C164), ISBLANK(D164), ISBLANK(E164), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C164))>=3, OR(D164<=1, E164<=1)), AND(D164=3, OR(VALUE(RIGHT(C164))<2, E164<=1)), AND(E164=3, OR(VALUE(RIGHT(C164))<2, D164<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoGIS03","Produce data layers, maps, tables or reports using GIS technology, equipment, systems and procedures",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C165), ISBLANK(D165), ISBLANK(E165), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C165))>=3, OR(D165<=1, E165<=1)), AND(D165=3, OR(VALUE(RIGHT(C165))<2, E165<=1)), AND(E165=3, OR(VALUE(RIGHT(C165))<2, D165<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoGIS04","Performing geospatial data building, modelling or analysis using spatial analysis, data manipulation, and cartographic software",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C166), ISBLANK(D166), ISBLANK(E166), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C166))>=3, OR(D166<=1, E166<=1)), AND(D166=3, OR(VALUE(RIGHT(C166))<2, E166<=1)), AND(E166=3, OR(VALUE(RIGHT(C166))<2, D166<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoGIS05","Geospatial modelling techniques including, but not limited to: neural networks, cellular automata, heuristics, agent-based models, and simulation models",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C167), ISBLANK(D167), ISBLANK(E167), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C167))>=3, OR(D167<=1, E167<=1)), AND(D167=3, OR(VALUE(RIGHT(C167))<2, E167<=1)), AND(E167=3, OR(VALUE(RIGHT(C167))<2, D167<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoGIS06","Understanding and solving Modifiable Areal Unit Problem/MAUP",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C168), ISBLANK(D168), ISBLANK(E168), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C168))>=3, OR(D168<=1, E168<=1)), AND(D168=3, OR(VALUE(RIGHT(C168))<2, E168<=1)), AND(E168=3, OR(VALUE(RIGHT(C168))<2, D168<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoGIS07","Create, analyze, report, convert or transfer data using applicable programs/software",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C169), ISBLANK(D169), ISBLANK(E169), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C169))>=3, OR(D169<=1, E169<=1)), AND(D169=3, OR(VALUE(RIGHT(C169))<2, E169<=1)), AND(E169=3, OR(VALUE(RIGHT(C169))<2, D169<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoGIS08","Collect, compile, and integrate various GIS data for visualization and analysis",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C170), ISBLANK(D170), ISBLANK(E170), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C170))>=3, OR(D170<=1, E170<=1)), AND(D170=3, OR(VALUE(RIGHT(C170))<2, E170<=1)), AND(E170=3, OR(VALUE(RIGHT(C170))<2, D170<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoGIS09","Having the technical expertise required to develop GIS and be able to support GIS systems users",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C171), ISBLANK(D171), ISBLANK(E171), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C171))>=3, OR(D171<=1, E171<=1)), AND(D171=3, OR(VALUE(RIGHT(C171))<2, E171<=1)), AND(E171=3, OR(VALUE(RIGHT(C171))<2, D171<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoGIS10","Design, program and model GIS applications or procedures",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C172), ISBLANK(D172), ISBLANK(E172), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C172))>=3, OR(D172<=1, E172<=1)), AND(D172=3, OR(VALUE(RIGHT(C172))<2, E172<=1)), AND(E172=3, OR(VALUE(RIGHT(C172))<2, D172<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoGIS11","Ability for computer programming, data analysis, and software development and maintenance of GIS application and database",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C173), ISBLANK(D173), ISBLANK(E173), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C173))>=3, OR(D173<=1, E173<=1)), AND(D173=3, OR(VALUE(RIGHT(C173))<2, E173<=1)), AND(E173=3, OR(VALUE(RIGHT(C173))<2, D173<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoDAMM01","Computation of scalar adjustments between data",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C174), ISBLANK(D174), ISBLANK(E174), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C174))>=3, OR(D174<=1, E174<=1)), AND(D174=3, OR(VALUE(RIGHT(C174))<2, E174<=1)), AND(E174=3, OR(VALUE(RIGHT(C174))<2, D174<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoDAMM02","Computation and adjustments of geometric measurements including, but not limited to: distance, direction, shape, area, proximity, and connectivity",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C175), ISBLANK(D175), ISBLANK(E175), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C175))>=3, OR(D175<=1, E175<=1)), AND(D175=3, OR(VALUE(RIGHT(C175))<2, E175<=1)), AND(E175=3, OR(VALUE(RIGHT(C175))<2, D175<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoDAMM03","Analysis and calculation of measurements including, but not limited to: buffers, overlays, and neighbourhoods",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C176), ISBLANK(D176), ISBLANK(E176), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C176))>=3, OR(D176<=1, E176<=1)), AND(D176=3, OR(VALUE(RIGHT(C176))<2, E176<=1)), AND(E176=3, OR(VALUE(RIGHT(C176))<2, D176<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoDAMM04","Application of algorithms to calculated neighbourhood statistics",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C177), ISBLANK(D177), ISBLANK(E177), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C177))>=3, OR(D177<=1, E177<=1)), AND(D177=3, OR(VALUE(RIGHT(C177))<2, E177<=1)), AND(E177=3, OR(VALUE(RIGHT(C177))<2, D177<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoDAMM05","Application of analytical techniques including, but not limited to: spatial cluster analysis, point pattern analysis, kernel and density estimation, and network analysis",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C178), ISBLANK(D178), ISBLANK(E178), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C178))>=3, OR(D178<=1, E178<=1)), AND(D178=3, OR(VALUE(RIGHT(C178))<2, E178<=1)), AND(E178=3, OR(VALUE(RIGHT(C178))<2, D178<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoDAMM06","Modelling of data into various forms including, but not limited to: spatial process model, and network modelling",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C179), ISBLANK(D179), ISBLANK(E179), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C179))>=3, OR(D179<=1, E179<=1)), AND(D179=3, OR(VALUE(RIGHT(C179))<2, E179<=1)), AND(E179=3, OR(VALUE(RIGHT(C179))<2, D179<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoDAMM07","Overcoming errors in correlation and spatial dependencies using mathematical adjustment methods and procedures including, but not limited to: least squares adjustments, and maximum likelihood",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C180), ISBLANK(D180), ISBLANK(E180), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C180))>=3, OR(D180<=1, E180<=1)), AND(D180=3, OR(VALUE(RIGHT(C180))<2, E180<=1)), AND(E180=3, OR(VALUE(RIGHT(C180))<2, D180<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoProg01","Understanding of software structuring and programming techniques to develop and manage software",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C181), ISBLANK(D181), ISBLANK(E181), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C181))>=3, OR(D181<=1, E181<=1)), AND(D181=3, OR(VALUE(RIGHT(C181))<2, E181<=1)), AND(E181=3, OR(VALUE(RIGHT(C181))<2, D181<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoProg02","Logically plan for the development of new (or maintenance of existing) software and program using industry standards",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C182), ISBLANK(D182), ISBLANK(E182), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C182))>=3, OR(D182<=1, E182<=1)), AND(D182=3, OR(VALUE(RIGHT(C182))<2, E182<=1)), AND(E182=3, OR(VALUE(RIGHT(C182))<2, D182<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoProg03","Execution of development plans/systems architecture and conversion of logic sequence to programming language",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C183), ISBLANK(D183), ISBLANK(E183), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C183))>=3, OR(D183<=1, E183<=1)), AND(D183=3, OR(VALUE(RIGHT(C183))<2, E183<=1)), AND(E183=3, OR(VALUE(RIGHT(C183))<2, D183<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoProg04","Familiarity with different programming language structure",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C184), ISBLANK(D184), ISBLANK(E184), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C184))>=3, OR(D184<=1, E184<=1)), AND(D184=3, OR(VALUE(RIGHT(C184))<2, E184<=1)), AND(E184=3, OR(VALUE(RIGHT(C184))<2, D184<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoProg05","Analyze programs for errors and bugs",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C185), ISBLANK(D185), ISBLANK(E185), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C185))>=3, OR(D185<=1, E185<=1)), AND(D185=3, OR(VALUE(RIGHT(C185))<2, E185<=1)), AND(E185=3, OR(VALUE(RIGHT(C185))<2, D185<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoProg06","Data and Metadata logging and evaluation",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C186), ISBLANK(D186), ISBLANK(E186), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C186))>=3, OR(D186<=1, E186<=1)), AND(D186=3, OR(VALUE(RIGHT(C186))<2, E186<=1)), AND(E186=3, OR(VALUE(RIGHT(C186))<2, D186<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoProg07","Correcting and modifying programs and software to suit the needs of the project",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C187), ISBLANK(D187), ISBLANK(E187), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C187))>=3, OR(D187<=1, E187<=1)), AND(D187=3, OR(VALUE(RIGHT(C187))<2, E187<=1)), AND(E187=3, OR(VALUE(RIGHT(C187))<2, D187<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoProg08","Compilation of documents as per industry standards and user needs for the maintenance and use of software and program",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C188), ISBLANK(D188), ISBLANK(E188), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C188))>=3, OR(D188<=1, E188<=1)), AND(D188=3, OR(VALUE(RIGHT(C188))<2, E188<=1)), AND(E188=3, OR(VALUE(RIGHT(C188))<2, D188<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoProg09","Identify interoperability of GIS application",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C189), ISBLANK(D189), ISBLANK(E189), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C189))>=3, OR(D189<=1, E189<=1)), AND(D189=3, OR(VALUE(RIGHT(C189))<2, E189<=1)), AND(E189=3, OR(VALUE(RIGHT(C189))<2, D189<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoProg10","GUI/web-interface connection with GIS server/application",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C190), ISBLANK(D190), ISBLANK(E190), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C190))>=3, OR(D190<=1, E190<=1)), AND(D190=3, OR(VALUE(RIGHT(C190))<2, E190<=1)), AND(E190=3, OR(VALUE(RIGHT(C190))<2, D190<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoProg11","Implementation and evaluation of impact of GIS software",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C191), ISBLANK(D191), ISBLANK(E191), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C191))>=3, OR(D191<=1, E191<=1)), AND(D191=3, OR(VALUE(RIGHT(C191))<2, E191<=1)), AND(E191=3, OR(VALUE(RIGHT(C191))<2, D191<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoGNSSG01","Analysis and calculation of survey data for positioning as per industry standards",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C192), ISBLANK(D192), ISBLANK(E192), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C192))>=3, OR(D192<=1, E192<=1)), AND(D192=3, OR(VALUE(RIGHT(C192))<2, E192<=1)), AND(E192=3, OR(VALUE(RIGHT(C192))<2, D192<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoGNSSG02","Computation of exact positioning information per industry standards",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C193), ISBLANK(D193), ISBLANK(E193), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C193))>=3, OR(D193<=1, E193<=1)), AND(D193=3, OR(VALUE(RIGHT(C193))<2, E193<=1)), AND(E193=3, OR(VALUE(RIGHT(C193))<2, D193<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoGNSSG03","Determination of location given minimal information ",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C194), ISBLANK(D194), ISBLANK(E194), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C194))>=3, OR(D194<=1, E194<=1)), AND(D194=3, OR(VALUE(RIGHT(C194))<2, E194<=1)), AND(E194=3, OR(VALUE(RIGHT(C194))<2, D194<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoGNSSG04","Verification and correction of survey data to assess for quality of data for use in projects",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C195), ISBLANK(D195), ISBLANK(E195), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C195))>=3, OR(D195<=1, E195<=1)), AND(D195=3, OR(VALUE(RIGHT(C195))<2, E195<=1)), AND(E195=3, OR(VALUE(RIGHT(C195))<2, D195<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoGNSSG05","Computation and interpretation of Geodetic measurements to determine features including, but not limited to: shapes, positions, elevations, geomorphic and topographic features",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C196), ISBLANK(D196), ISBLANK(E196), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C196))>=3, OR(D196<=1, E196<=1)), AND(D196=3, OR(VALUE(RIGHT(C196))<2, E196<=1)), AND(E196=3, OR(VALUE(RIGHT(C196))<2, D196<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]
["SpKnoGNSSG06","Maintenance of database for geodetic and related data including, but not limited to: coordinates, and description",{"$nulls":3},{"$f":"IF(OR(ISBLANK(C197), ISBLANK(D197), ISBLANK(E197), $C$8=Calc!$L$18,$C$8=Calc!$L$19), \"\", IFERROR(IF(OR(AND(VALUE(RIGHT(C197))>=3, OR(D197<=1, E197<=1)), AND(D197=3, OR(VALUE(RIGHT(C197))<2, E197<=1)), AND(E197=3, OR(VALUE(RIGHT(C197))<2, D197<=1))), \"ATTENTION REQUIRED\", \" \"), \" \"))","v":""}]

{"sheet":"Calc","index":1,"n_rows":30,"n_cols":16,"rows_kept":30,"hidden":true}
[null,null,"Perceived Importance","Contact Hours",null,"L1","L2","lowL","L3","L4","highL","avglvl"]
["SKILL"]
["TSkill","Technical Skill",{"$f":"(SUMIF(Input!A12:A1048576, \"=TSkill*\",Input!D12:D1048576)/(COUNTIF(Input!A:A, \"TSkill*\")*3))","v":{"v":0,"d":"0%"}},{"$f":"(SUMIF(Input!A12:A1048576, \"=TSkill*\",Input!E12:E1048576)/(COUNTIF(Input!A:A, \"TSkill*\")*3))","v":{"v":0,"d":"0%"}},null,{"$f":"COUNTIFS(Input!A12:A1048576, \"Tskill*\", Input!C12:C1048576, \"L1\")","v":0},{"$f":"COUNTIFS(Input!A12:A1048576, \"Tskill*\", Input!C12:C1048576, \"L2\")","v":0},{"$f":"SUM(COUNTIFS(Input!A12:A1048576, \"Tskill*\", Input!C12:C1048576, \"L1\"), COUNTIFS(Input!A12:A1048576, \"Tskill*\", Input!C12:C1048576, \"L2\"))","v":0},{"$f":"COUNTIFS(Input!A12:A1048576, \"Tskill*\", Input!C12:C1048576, \"L3\")","v":0},{"$f":"COUNTIFS(Input!A12:A1048576, \"Tskill*\", Input!C12:C1048576, \"L4\")","v":0},{"$f":"SUM(COUNTIFS(Input!A12:A1048576, \"Tskill*\", Input!C12:C1048576, \"L3\"), COUNTIFS(Input!A12:A1048576, \"Tskill*\", Input!C12:C1048576, \"L4\"))","v":0},{"$f":"ROUND(((F3*1)+(G3*2)+(I3*3)+(J3*4))/SUM(F3:G3,I3:J3),0)","v":{"$error":"#DIV/0!"}}]
["DGMSkill","Data Gathering & Manipulation Skill",{"$f":"(SUMIF(Input!A12:A1048576, \"=DGMSkill*\",Input!D12:D1048576)/(COUNTIF(Input!A:A, \"DGMSkill*\")*3))","v":{"v":0,"d":"0%"}},{"$f":"(SUMIF(Input!A12:A1048576, \"=DGMSkill*\",Input!E12:E1048576)/(COUNTIF(Input!A:A, \"DGMSkill*\")*3))","v":{"v":0,"d":"0%"}},null,{"$f":"COUNTIFS(Input!A12:A1048576, \"DGMSkill*\", Input!C12:C1048576, \"L1\")","v":0},{"$f":"COUNTIFS(Input!A12:A1048576, \"DGMSkill*\", Input!C12:C1048576, \"L2\")","v":0},{"$f":"SUM(COUNTIFS(Input!A12:A1048576, \"DGMSkill*\", Input!C12:C1048576, \"L1\"), COUNTIFS(Input!A12:A1048576, \"DGMSkill*\", Input!C12:C1048576, \"L2\"))","v":0},{"$f":"COUNTIFS(Input!A12:A1048576, \"DGMSkill*\", Input!C12:C1048576, \"L3\")","v":0},{"$f":"COUNTIFS(Input!A12:A1048576, \"DGMSkill*\", Input!C12:C1048576, \"L4\")","v":0},{"$f":"SUM(COUNTIFS(Input!A12:A1048576, \"DGMSkill*\", Input!C12:C1048576, \"L3\"), COUNTIFS(Input!A12:A1048576, \"DGMSkill*\", Input!C12:C1048576, \"L4\"))","v":0},{"$f":"ROUND(((F4*1)+(G4*2)+(I4*3)+(J4*4))/SUM(F4:G4,I4:J4),0)","v":{"$error":"#DIV/0!"}}]
["IMSkill","Imaging & Mapping Skill",{"$f":"(SUMIF(Input!A12:A1048576, \"=IMSkill*\",Input!D12:D1048576)/(COUNTIF(Input!A:A, \"IMSkill*\")*3))","v":{"v":0,"d":"0%"}},{"$f":"(SUMIF(Input!A12:A1048576, \"=IMSkill*\",Input!E12:E1048576)/(COUNTIF(Input!A:A, \"IMSkill*\")*3))","v":{"v":0,"d":"0%"}},null,{"$f":"COUNTIFS(Input!A12:A1048576, \"IMSkill*\", Input!C12:C1048576, \"L1\")","v":0},{"$f":"COUNTIFS(Input!A12:A1048576, \"IMSkill*\", Input!C12:C1048576, \"L2\")","v":0},{"$f":"SUM(COUNTIFS(Input!A12:A1048576, \"IMSkill*\", Input!C12:C1048576, \"L1\"), COUNTIFS(Input!A12:A1048576, \"IMSkill*\", Input!C12:C1048576, \"L2\"))","v":0},{"$f":"COUNTIFS(Input!A12:A1048576, \"IMSkill*\", Input!C12:C1048576, \"L3\")","v":0},{"$f":"COUNTIFS(Input!A12:A1048576, \"IMSkill*\", Input!C12:C1048576, \"L4\")","v":0},{"$f":"SUM(COUNTIFS(Input!A12:A1048576, \"IMSkill*\", Input!C12:C1048576, \"L3\"), COUNTIFS(Input!A12:A1048576, \"IMSkill*\", Input!C12:C1048576, \"L4\"))","v":0},{"$error":"#DIV/0!"}]
["SSkill","Spatial Skill",{"$f":"(SUMIF(Input!A12:A1048576, \"=SSkill*\",Input!D12:D1048576)/(COUNTIF(Input!A:A, \"SSkill*\")*3))","v":{"v":0,"d":"0%"}},{"$f":"(SUMIF(Input!A12:A1048576, \"=SSkill*\",Input!E12:E1048576)/(COUNTIF(Input!A:A, \"SSkill*\")*3))","v":{"v":0,"d":"0%"}},null,{"$f":"COUNTIFS(Input!A12:A1048576, \"SSkill*\", Input!C12:C1048576, \"L1\")","v":0},{"$f":"COUNTIFS(Input!A12:A1048576, \"SSkill*\", Input!C12:C1048576, \"L2\")","v":0},{"$f":"SUM(COUNTIFS(Input!A12:A1048576, \"SSkill*\", Input!C12:C1048576, \"L1\"), COUNTIFS(Input!A12:A1048576, \"SSkill*\", Input!C12:C1048576, \"L2\"))","v":0},{"$f":"COUNTIFS(Input!A12:A1048576, \"SSkill*\", Input!C12:C1048576, \"L3\")","v":0},{"$f":"COUNTIFS(Input!A12:A1048576, \"SSkill*\", Input!C12:C1048576, \"L4\")","v":0},{"$f":"SUM(COUNTIFS(Input!A12:A1048576, \"SSkill*\", Input!C12:C1048576, \"L3\"), COUNTIFS(Input!A12:A1048576, \"SSkill*\", Input!C12:C1048576, \"L4\"))","v":0},{"$error":"#DIV/0!"}]
["PSkill","Professional Skill",{"$f":"(SUMIF(Input!A12:A1048576, \"=PSkill*\",Input!D12:D1048576)/(COUNTIF(Input!A:A, \"PSkill*\")*3))","v":{"v":0,"d":"0%"}},{"$f":"(SUMIF(Input!A12:A1048576, \"=PSkill*\",Input!E12:E1048576)/(COUNTIF(Input!A:A, \"PSkill*\")*3))","v":{"v":0,"d":"0%"}},null,{"$f":"COUNTIFS(Input!A12:A1048576, \"PSkill*\", Input!C12:C1048576, \"L1\")","v":0},{"$f":"COUNTIFS(Input!A12:A1048576, \"PSkill*\", Input!C12:C1048576, \"L2\")","v":0},{"$f":"SUM(COUNTIFS(Input!A12:A1048576, \"PSkill*\", Input!C12:C1048576, \"L1\"), COUNTIFS(Input!A12:A1048576, \"PSkill*\", Input!C12:C1048576, \"L2\"))","v":0},{"$f":"COUNTIFS(Input!A12:A1048576, \"PSkill*\", Input!C12:C1048576, \"L3\")","v":0},{"$f":"COUNTIFS(Input!A12:A1048576, \"PSkill*\", Input!C12:C1048576, \"L4\")","v":0},{"$f":"SUM(COUNTIFS(Input!A12:A1048576, \"PSkill*\", Input!C12:C1048576, \"L3\"), COUNTIFS(Input!A12:A1048576, \"PSkill*\", Input!C12:C1048576, \"L4\"))","v":0},{"$error":"#DIV/0!"}]
[null,"Application Skill",{"$f":"(SUMIF(Input!A12:A1048576, \"=ASkill*\",Input!D12:D1048576)/(COUNTIF(Input!A:A, \"ASkill*\")*3))","v":{"v":0,"d":"0%"}},{"$f":"(SUMIF(Input!A12:A1048576, \"=ASkill*\",Input!E12:E1048576)/(COUNTIF(Input!A:A, \"ASkill*\")*3))","v":{"v":0,"d":"0%"}},null,{"$f":"COUNTIFS(Input!A12:A1048576, \"ASkill*\", Input!C12:C1048576, \"L1\")","v":0},{"$f":"COUNTIFS(Input!A12:A1048576, \"ASkill*\", Input!C12:C1048576, \"L2\")","v":0},{"$f":"SUM(COUNTIFS(Input!A12:A1048576, \"ASkill*\", Input!C12:C1048576, \"L1\"), COUNTIFS(Input!A12:A1048576, \"ASkill*\", Input!C12:C1048576, \"L2\"))","v":0},{"$f":"COUNTIFS(Input!A12:A1048576, \"ASkill*\", Input!C12:C1048576, \"L3\")","v":0},{"$f":"COUNTIFS(Input!A12:A1048576, \"ASkill*\", Input!C12:C1048576, \"L4\")","v":0},{"$f":"SUM(COUNTIFS(Input!A12:A1048576, \"ASkill*\", Input!C12:C1048576, \"L3\"), COUNTIFS(Input!A12:A1048576, \"ASkill*\", Input!C12:C1048576, \"L4\"))","v":0},{"$error":"#DIV/0!"}]
["KNOWLEDGE",{"$nulls":11},"L1","L2","L3","L4"]
["Bkno","Basic Knowledge",{"$f":"(SUMIF(Input!A12:A1048576, \"=BKno*\",Input!D12:D1048576)/(COUNTIF(Input!A:A, \"BKno*\")*3))","v":{"v":0,"d":"0%"}},{"$f":"(SUMIF(Input!A12:A1048576, \"=BKno*\",Input!E12:E1048576)/(COUNTIF(Input!A:A, \"BKno*\")*3))","v":{"v":0,"d":"0%"}},null,{"$f":"COUNTIFS(Input!A12:A1048576, \"BKno*\", Input!C12:C1048576, \"L1\")","v":0},{"$f":"COUNTIFS(Input!A12:A1048576, \"BKno*\", Input!C12:C1048576, \"L2\")","v":0},{"$f":"SUM(COUNTIFS(Input!A12:A1048576, \"BKno*\", Input!C12:C1048576, \"L1\"), COUNTIFS(Input!A12:A1048576, \"BKno*\", Input!C12:C1048576, \"L2\"))","v":0},{"$f":"COUNTIFS(Input!A12:A1048576, \"BKno*\", Input!C12:C1048576, \"L3\")","v":0},{"$f":"COUNTIFS(Input!A12:A1048576, \"BKno*\", Input!C12:C1048576, \"L4\")","v":0},{"$f":"SUM(COUNTIFS(Input!A12:A1048576, \"BKno*\", Input!C12:C1048576, \"L3\"), COUNTIFS(Input!A12:A1048576, \"BKno*\", Input!C12:C1048576, \"L4\"))","v":0},null,{"$f":"F10/SUM(F10:G10,I10:J10)","v":{"$error":"#DIV/0!"}},{"$f":"G10/SUM(F10:G10,I10:J10)","v":{"$error":"#DIV/0!"}},{"$f":"I10/SUM(F10:G10,I10:J10)","v":{"$error":"#DIV/0!"}},{"$f":"J10/SUM(F10:G10,I10:J10)","v":{"$error":"#DIV/0!"}}]
["SupKno","Supplementary Knowledge",{"$f":"(SUMIF(Input!A12:A1048576, \"=SupKno*\",Input!D12:D1048576)/(COUNTIF(Input!A:A, \"SupKno*\")*3))","v":{"v":0,"d":"0%"}},{"$f":"(SUMIF(Input!A12:A1048576, \"=SupKno*\",Input!E12:E1048576)/(COUNTIF(Input!A:A, \"SupKno*\")*3))","v":{"v":0,"d":"0%"}},null,{"$f":"COUNTIFS(Input!A12:A1048576, \"SupKno*\", Input!C12:C1048576, \"L1\")","v":0},{"$f":"COUNTIFS(Input!A12:A1048576, \"SupKno*\", Input!C12:C1048576, \"L2\")","v":0},{"$f":"SUM(COUNTIFS(Input!A12:A1048576, \"SupKno*\", Input!C12:C1048576, \"L1\"), COUNTIFS(Input!A12:A1048576, \"SupKno*\", Input!C12:C1048576, \"L2\"))","v":0},{"$f":"COUNTIFS(Input!A12:A1048576, \"SupKno*\", Input!C12:C1048576, \"L3\")","v":0},{"$f":"COUNTIFS(Input!A12:A1048576, \"SupKno*\", Input!C12:C1048576, \"L4\")","v":0},{"$f":"SUM(COUNTIFS(Input!A12:A1048576, \"SupKno*\", Input!C12:C1048576, \"L3\"), COUNTIFS(Input!A12:A1048576, \"SupKno*\", Input!C12:C1048576, \"L4\"))","v":0},null,{"$f":"F11/SUM(F11:G11,I11:J11)","v":{"$error":"#DIV/0!"}},{"$f":"G11/SUM(F11:G11,I11:J11)","v":{"$error":"#DIV/0!"}},{"$f":"I11/SUM(F11:G11,I11:J11)","v":{"$error":"#DIV/0!"}},{"$f":"J11/SUM(F11:G11,I11:J11)","v":{"$error":"#DIV/0!"}}]
["SpKno","Specialized Knowledge",{"$f":"(SUMIF(Input!A12:A1048576, \"=SPKno*\",Input!D12:D1048576)/(COUNTIF(Input!A:A, \"SPKno*\")*3))","v":{"v":0,"d":"0%"}},{"$f":"(SUMIF(Input!A12:A1048576, \"=SpKno*\",Input!E12:E1048576)/(COUNTIF(Input!A:A, \"SpKno*\")*3))","v":{"v":0,"d":"0%"}},null,{"$f":"COUNTIFS(Input!A12:A1048576, \"SpKno*\", Input!C12:C1048576, \"L1\")","v":0},{"$f":"COUNTIFS(Input!A12:A1048576, \"SpKno*\", Input!C12:C1048576, \"L2\")","v":0},{"$f":"SUM(COUNTIFS(Input!A12:A1048576, \"SpKno*\", Input!C12:C1048576, \"L1\"), COUNTIFS(Input!A12:A1048576, \"SpKno\", Input!C12:C1048576, \"L2\"))","v":0},{"$f":"COUNTIFS(Input!A12:A1048576, \"SpKno*\", Input!C12:C1048576, \"L3\")","v":0},{"$f":"COUNTIFS(Input!A12:A1048576, \"SpKno*\", Input!C12:C1048576, \"L4\")","v":0},{"$f":"SUM(COUNTIFS(Input!A12:A1048576, \"SpKno*\", Input!C12:C1048576, \"L3\"), COUNTIFS(Input!A12:A1048576, \"SpKno\", Input!C12:C1048576, \"L4\"))","v":0},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":7},{"$f":"SUM(H3:H12)","v":0},null,null,{"$f":"SUM(K3:K12)","v":0}]
["KNOWLEDGE",null,"Percieve","Contact","Count (Imp)"]
["BKnoMIV","Basic Knowledge (Mapping & Image Visualization)",{"$nulls":4},"Level","count","%",null,null,"Please Select"]
["BKnoDDM","Basic Knowledge (Data & Database Management)",{"$nulls":4},"L1",{"$f":"COUNTIFS(Input!C12:C1048576, \"L1\", Input!A12:A1048576, \"*\")","v":0},{"$f":"H16/SUM(H16:H19)","v":{"$error":"#DIV/0!"}},null,null,"Topic"]
["BKnoGP","Basic Knowledge (Graphics & Presentation)",{"$nulls":4},"L2",{"$f":"COUNTIFS(Input!C12:C1048576, \"L2\", Input!A12:A1048576, \"*\")","v":0},{"$f":"H17/SUM(H16:H19)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H16:H17)","v":0},null,"Subject"]
["BKnoND","Basic Knowledge (Numeric Data)",{"$nulls":4},"L3",{"$f":"COUNTIFS(Input!C12:C1048576, \"L3\", Input!A12:A1048576, \"*\")","v":0},{"$f":"H18/SUM(H16:H19)","v":{"$error":"#DIV/0!"}},null,null,"Course"]
["BKnoPPS","Basic Knowledge (Processes, Procedures & Standards)",{"$nulls":4},"L4",{"$f":"COUNTIFS(Input!C12:C1048576, \"L4\", Input!A12:A1048576, \"*\")","v":0},{"$f":"H19/SUM(H16:H19)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H18:H19)","v":0},null,"Programme"]
["BKnoG","Basic Knowledge (Geography)"]
["SupKnoCB","Construction & Building",null,{"$f":"(SUMIF(Input!A12:A1048576, \"=SupKnoCB*\",Input!E12:E1048576)/(COUNTIF(Input!A:A, \"SupKnoCB*\")*3))","v":{"v":0,"d":"0%"}},{"$f":"COUNTIFS(Input!A12:A1048576,\"SupKnoCB*\",Input!D12:D1048576,\"=3\")/COUNTIF(Input!A12:A1048576,\"SupKnoCB*\")","v":{"v":0,"d":"0%"}}]
["SupKnoE","Environment",null,{"$f":"(SUMIF(Input!A12:A1048576, \"=SupKnoE*\",Input!E12:E1048576)/(COUNTIF(Input!A:A, \"SupKnoE*\")*3))","v":{"v":0,"d":"0%"}},{"$f":"COUNTIFS(Input!A12:A1048576,\"SupKnoE*\",Input!D12:D1048576,\"=3\")/COUNTIF(Input!A12:A1048576,\"SupKnoE*\")","v":{"v":0,"d":"0%"}}]
["SupKnoS","Social",null,{"$f":"(SUMIF(Input!A12:A1048576, \"=SupKnoS*\",Input!E12:E1048576)/(COUNTIF(Input!A:A, \"SupKnoS*\")*3))","v":{"v":0,"d":"0%"}},{"$f":"COUNTIFS(Input!A12:A1048576,\"SupKnoS*\",Input!D12:D1048576,\"=3\")/COUNTIF(Input!A12:A1048576,\"SupKnoS*\")","v":{"v":0,"d":"0%"}}]
["SpKnoRS","Remote Sensing",null,{"$f":"(SUMIF(Input!A12:A1048576, \"=SpKnoRS*\",Input!E12:E1048576)/(COUNTIF(Input!A:A, \"SPKnoRS*\")*3))","v":{"v":0,"d":"0%"}},{"$f":"COUNTIFS(Input!A12:A1048576,\"SpKnoRST*\",Input!D12:D1048576,\"=3\")/COUNTIF(Input!A12:A1048576,\"SpKnoRST*\")","v":{"v":0,"d":"0%"}}]
["SpKnoSTLA","Surveying & Land Administration",null,{"$f":"(SUMIF(Input!A12:A1048576, \"=SpKnoSTLA*\",Input!E12:E1048576)/(COUNTIF(Input!A:A, \"SPKnoSTLA*\")*3))","v":{"v":0,"d":"0%"}},{"$f":"COUNTIFS(Input!A12:A1048576, \"SpKnoSTLA*\", Input!D12:D1048576, \"=3\")/COUNTIF(Input!A12:A1048576, \"SpKnoSTLA*\")","v":{"v":0,"d":"0%"}}]
["SpKnoPCT","Photogrammetry",null,{"$f":"(SUMIF(Input!A12:A1048576, \"=SpKnoPCT*\",Input!E12:E1048576)/(COUNTIF(Input!A:A, \"SPKnoPCT*\")*3))","v":{"v":0,"d":"0%"}},{"$f":"COUNTIFS(Input!A12:A1048576, \"SpKnoPCT*\", Input!D12:D1048576, \"=3\")/COUNTIF(Input!A12:A1048576, \"SpKnoPCT*\")","v":{"v":0,"d":"0%"}}]
["SpKnoGIS","GIS",null,{"$f":"(SUMIF(Input!A12:A1048576, \"=SpKnoGIS*\",Input!E12:E1048576)/(COUNTIF(Input!A:A, \"SPKnoGIS*\")*3))","v":{"v":0,"d":"0%"}},{"$f":"COUNTIFS(Input!A12:A1048576, \"SpKnoGIS*\", Input!D12:D1048576, \"=3\")/COUNTIF(Input!A12:A1048576, \"SpKnoGIS*\")","v":{"v":0,"d":"0%"}}]
["SpKnoDAMM","Data Adjustment",null,{"$f":"(SUMIF(Input!A12:A1048576, \"=SpKnoDAMM*\",Input!E12:E1048576)/(COUNTIF(Input!A:A, \"SPKnoDAMM*\")*3))","v":{"v":0,"d":"0%"}},{"$f":"COUNTIFS(Input!A12:A1048576, \"SpKnoDAMM*\", Input!D12:D1048576, \"=3\")/COUNTIF(Input!A12:A1048576, \"SpKnoDAMM*\")","v":{"v":0,"d":"0%"}}]
["SpKnoProg","Programming",null,{"$f":"(SUMIF(Input!A12:A1048576, \"=SpKnoProg*\",Input!E12:E1048576)/(COUNTIF(Input!A:A, \"SPKnoProg*\")*3))","v":{"v":0,"d":"0%"}},{"$f":"COUNTIFS(Input!A12:A1048576, \"SpKnoProg*\", Input!D12:D1048576, \"=3\")/COUNTIF(Input!A12:A1048576, \"SpKnoProg*\")","v":{"v":0,"d":"0%"}}]
["SpKnoGNSSG","GNSS & Geodesy",null,{"$f":"(SUMIF(Input!A12:A1048576, \"=SpKnoGNSSG*\",Input!E12:E1048576)/(COUNTIF(Input!A:A, \"SPKnoGNSSG*\")*3))","v":{"v":0,"d":"0%"}},{"$f":"COUNTIFS(Input!A12:A1048576, \"SpKnoGNSSG*\", Input!D12:D1048576, \"=3\")/COUNTIF(Input!A12:A1048576, \"SpKnoGNSSG*\")","v":{"v":0,"d":"0%"}}]

{"sheet":"Diagnose","index":2,"n_rows":27,"n_cols":15,"rows_kept":27,"merged":[[1,4,1,14],[16,1,16,14],[26,1,26,14]]}
[]
[null,{"$f":"IF(Input!C8=\"Please Select\", \"Subject/Course\", IF(Input!C8=\"Topic\", Calc!L16, IF(Input!C8=\"Subject\", Calc!L17, IF(Input!C8=\"Course\",Calc!L18, IF(Input!C8=\"Programme\", Calc!L19, \" \")))))","v":"Subject/Course"},null,null,"Taught Knowledge"]
[null,{"$f":"IF(ISBLANK(Input!B8), \"-\", Input!B8)","v":"-"}]
[]
[null,"Average Level of Understanding"]
[null,{"$f":"IF(SUM(Calc!H16:H19) = 0, \"N/A\", IF(AND(SUM(Calc!H18:H19)>SUM(Calc!H17:H18),SUM(Calc!H18:H19)>SUM(Calc!H16:H17)), \"Advance\", IF(AND(SUM(Calc!H17:H18)>SUM(Calc!H18:H19), SUM(Calc!H17:H18)>SUM(Calc!H16:H17)), \"Intermediate\", \"Introductory\")))","v":"N/A"}]
[]
[null,"Specialisation Focus"]
[null,{"$f":"IF(SUM(Calc!E24:E30)=0,\"N/A\",IF(AND(Calc!E24<0.2,Calc!E25<0.2,Calc!E26<0.2,Calc!E27<0.2,Calc!E28<0.2,Calc!E29<0.2,Calc!E30<0.2),\"Broad\",VLOOKUP(INDEX(Calc!A24:A30,MATCH(MAX(Calc!E24:E30),Calc!E24:E30,0)),Calc!A24:E30,2,0)))","v":"N/A"}]
[]
[null,"Supplementary Focus"]
[null,{"$f":"IF(SUM(Calc!E21:E23)=0,\"NIL\",IF(AND(Calc!E21=Calc!E22,Calc!E22=Calc!E23,Calc!E23=Calc!E21),\"None\",IF(AND(Calc!E21>Calc!E23,Calc!E21=Calc!E22),\"Construction, Building & Environment\",IF(AND(Calc!E22>Calc!E21,Calc!E22=Calc!E23),\"Environment & Social\",IF(AND(Calc!E23>Calc!E22,Calc!E23=Calc!E21),\"Construction, Building & Social\",VLOOKUP(INDEX(Calc!A21:A23,MATCH(MAX(Calc!E21:E23),Calc!E21:E23,0)),Calc!A21:E23,2,0))))))","v":"NIL"}]
[]
[null,"Comment"]
[null,{"$f":"IF(OR(Input!C8=Calc!L17, Input!C8=Calc!L16, Input!C8=Calc!L15), CONCATENATE(COUNTIF(Input!F12:F1048576, \"ATTENTION REQUIRED\"), \" items require attention (more contact hours).\",CHAR(10), CHAR(10),IF(AND(Diagnose!B6=\"Advance\", NOT(Diagnose!B6=\"Introductory\"), NOT(Diagnose!B6=\"Intermediate\")), \"Course focus on Analyzing, Theorizing and Justifying (new) Knowledge\", IF(AND(Diagnose!B6=\"Intermediate\", NOT(Diagnose!B6=\"Advance\"), NOT(Diagnose!B6=\"Introductory\")), \"Course focus on Knowledge, Application and Comprehension of theories\", IF(AND(B6=\"Introductory\",NOT(B6=\"Advance\"),NOT(B6=\"Intermediate\")),\"Course focus on Knowledge Recall and Simple Calculations\",\" \")))), IF(AND(Diagnose!B6=\"Advance\", NOT(Diagnose!B6=\"Introductory\"), NOT(Diagnose!B6=\"Intermediate\")), \"Course focus on Analyzing, Theorizing and Justifying (new) Knowledge\", IF(AND(Diagnose!B6=\"Intermediate\", NOT(Diagnose!B6=\"Advance\"), NOT(Diagnose!B6=\"Introductory\")), \"Course focus on Knowledge, Application and Comprehension of theories\", IF(AND(B6=\"Introductory\",NOT(B6=\"Advance\"),NOT(B6=\"Intermediate\")),\"Course focus on Knowledge Recall and Simple Calculations\",\" \"))))","v":"0 items require attention (more contact hours).\n\n "}]
[]
[null,"Taught Skills"]
[{"$nulls":14},"Level"]
[{"$nulls":14},{"$f":"IFERROR(CONCATENATE(\"L\",Calc!L3),\"-\")","v":"-"}]
[{"$nulls":14},{"$f":"IFERROR(CONCATENATE(\"L\",Calc!L4),\"-\")","v":"-"}]
[{"$nulls":14},{"$f":"IFERROR(CONCATENATE(\"L\",Calc!L5),\"-\")","v":"-"}]
[{"$nulls":14},{"$f":"IFERROR(CONCATENATE(\"L\",Calc!L6),\"-\")","v":"-"}]
[{"$nulls":14},{"$f":"IFERROR(CONCATENATE(\"L\",Calc!L7),\"-\")","v":"-"}]
[{"$nulls":14},{"$f":"IFERROR(CONCATENATE(\"L\",Calc!L8),\"-\")","v":"-"}]
[]
[]
[null,{"$f":"IF(Input!C8=Calc!L15,\"Subject/Course Focus\",CONCATENATE(Input!C8,\" Focus\"))","v":"Subject/Course Focus"}]

{"sheet":"Calc02","index":3,"n_rows":120,"n_cols":18,"rows_kept":120,"hidden":true}
["C/P",null,"Level","Perceived","Contact","Point",null,null,"Skills","Percieved","Contact",null,null,"Conceptual/Analytical"]
["P",{"$f":"Input!A12","v":"TSkill01"},{"$f":"Input!C12","v":" "},{"$f":"Input!D12","v":" "},{"$f":"Input!E12","v":" "},{"$f":"IFERROR(RIGHT(C2)+D2+E2,0)","v":0},null,null,"Technical",{"$f":"SUM(D2:D3)","v":0},{"$f":"SUM(E2:E3)","v":0},{"$f":"COUNTIF(B:B,\"Tskill*\")*3","v":6},null,"Count >6","max","%"]
["C",{"$f":"Input!A16","v":"TSkill02"},{"$f":"Input!C16","v":" "},{"$f":"Input!D16","v":" "},{"$f":"Input!E16","v":" "},{"$f":"IFERROR(RIGHT(C3)+D3+E3,0)","v":0},null,null,"Data Gathering",{"$f":"SUM(D4:D7)","v":0},{"$f":"SUM(E4:E7)","v":0},{"$f":"COUNTIF(B:B,\"DGMSkill*\")*3","v":12},null,{"$f":"COUNTIFS(A2:A120, \"=C\", Point, \">=6\")","v":0},{"$f":"COUNTIFS(A2:A120,\"=C\",Point,\"<>0\")","v":0},{"$f":"IFERROR(N3/O3,0)","v":0}]
["P",{"$f":"Input!A21","v":"DGMSkill01"},{"$f":"Input!C21","v":" "},{"$f":"Input!D21","v":" "},{"$f":"Input!E21","v":" "},0,null,null,"Imaging",{"$f":"SUM(D8:D10)","v":0},{"$f":"SUM(E8:E10)","v":0},{"$f":"COUNTIF(B:B,\"IMSkill*\")*3","v":9},{"$nulls":4},"Diff","Sum"]
["P",{"$f":"Input!A25","v":"DGMSkill02"},{"$f":"Input!C25","v":" "},{"$f":"Input!D25","v":" "},{"$f":"Input!E25","v":" "},0,null,null,"Spatial",{"$f":"SUM(D11:D13)","v":0},{"$f":"SUM(E11:E13)","v":0},{"$f":"COUNTIF(B:B,\"Sskill*\")*3","v":9},null,"Practical/Technical",null,null,{"$f":"(P7*R5)-(P3*R5)","v":0},{"$f":"O7+O3","v":0}]
["P",{"$f":"Input!A28","v":"DGMSkill03"},{"$f":"Input!C28","v":" "},{"$f":"Input!D28","v":" "},{"$f":"Input!E28","v":" "},0,null,null,"Professional",{"$f":"SUM(D14:D17)","v":0},{"$f":"SUM(E14:E17)","v":0},{"$f":"COUNTIF(B:B,\"Pskill*\")*3","v":12},null,"Count>6","max","%"]
["P",{"$f":"Input!A31","v":"DGMSkill04"},{"$f":"Input!C31","v":" "},{"$f":"Input!D31","v":" "},{"$f":"Input!E31","v":" "},0,null,null,"Application",{"$f":"SUM(D18:D19)","v":0},{"$f":"SUM(E18:E19)","v":0},{"$f":"COUNTIF(B:B,\"Askill*\")*3","v":6},null,{"$f":"COUNTIFS(A2:A120, \"=p\", Point, \">=6\")","v":0},{"$f":"COUNTIFS(A2:A120, \"=p\", Point, \">=6\")","v":0},{"$f":"IFERROR(N7/O7,0)","v":0}]
["C",{"$f":"Input!A35","v":"IMSkill01"},{"$f":"Input!C35","v":" "},{"$f":"Input!D35","v":" "},{"$f":"Input!E35","v":" "},0]
["C",{"$f":"Input!A39","v":"IMSkill02"},{"$f":"Input!C39","v":" "},{"$f":"Input!D39","v":" "},{"$f":"Input!E39","v":" "},0,{"$nulls":3},"%Spec+ve","%slider fill p","%sliderp size","Standard","Slider Position P","Spectrum","Slider Fill P","Slider Size"]
["C",{"$f":"Input!A42","v":"IMSkill03"},{"$f":"Input!C42","v":" "},{"$f":"Input!D42","v":" "},{"$f":"Input!E42","v":" "},0,null,"per",{"$f":"Calc!B3","v":"Technical Skill"},1,{"$f":"IF(AND(N10=0,N11=0),0.485,P10/O10)","v":0.485},0.015,0.015,{"$f":"J2","v":0},{"$f":"L2","v":6},{"$f":"N10-Q10","v":-0.09},{"$f":"O10*M10","v":0.09}]
[null,{"$f":"Input!A46","v":"SSkill01"},{"$f":"Input!C46","v":" "},{"$f":"Input!D46","v":" "},{"$f":"Input!E46","v":" "},0,null,"con",null,1,{"$f":"IF(AND(N11=0,N10=0),0.485,P11/O11)","v":0.485},0.015,0.015,{"$f":"K2","v":0},{"$f":"L2","v":6},{"$f":"N11-Q10","v":-0.09},{"$f":"O11*M11","v":0.09}]
[null,{"$f":"Input!A49","v":"SSkill02"},{"$f":"Input!C49","v":" "},{"$f":"Input!D49","v":" "},{"$f":"Input!E49","v":" "},0]
[null,{"$f":"Input!A52","v":"SSkill03"},{"$f":"Input!C52","v":" "},{"$f":"Input!D52","v":" "},{"$f":"Input!E52","v":" "},0,null,"per",{"$f":"Calc!B4","v":"Data Gathering & Manipulation Skill"},1,{"$f":"IF(AND(N13=0,N14=0),0.485,P13/O13)","v":0.485},0.015,0.015,{"$f":"J3","v":0},{"$f":"L3","v":12},{"$f":"N13-Q13","v":-0.18},{"$f":"O13*M13","v":0.18}]
[null,{"$f":"Input!A55","v":"PSkill01"},{"$f":"Input!C55","v":" "},{"$f":"Input!D55","v":" "},{"$f":"Input!E55","v":" "},0,null,"con",null,1,{"$f":"IF(AND(N13=0,N14=0),0.485,P14/O14)","v":0.485},0.015,0.015,{"$f":"K3","v":0},{"$f":"L3","v":12},{"$f":"N14-Q13","v":-0.18},{"$f":"O14*M14","v":0.18}]
[null,{"$f":"Input!A59","v":"PSkill02"},{"$f":"Input!C59","v":" "},{"$f":"Input!D59","v":" "},{"$f":"Input!E59","v":" "},0]
[null,{"$f":"Input!A63","v":"PSkill03"},{"$f":"Input!C63","v":" "},{"$f":"Input!D63","v":" "},{"$f":"Input!E63","v":" "},0,null,"per",{"$f":"Calc!B5","v":"Imaging & Mapping Skill"},1,{"$f":"IF(AND(N16=0,N17=0),0.485,P16/O16)","v":0.485},0.015,0.015,{"$f":"J4","v":0},{"$f":"L4","v":9},{"$f":"N16-Q16","v":-0.135},{"$f":"O16*M16","v":0.135}]
[null,{"$f":"Input!A66","v":"PSkill04"},{"$f":"Input!C66","v":" "},{"$f":"Input!D66","v":" "},{"$f":"Input!E66","v":" "},0,null,"con",null,1,{"$f":"IF(AND(N16=0,N17=0),0.485,P17/O17)","v":0.485},0.015,0.015,{"$f":"K4","v":0},{"$f":"L4","v":9},{"$f":"N17-Q16","v":-0.135},{"$f":"O17*M17","v":0.135}]
[null,{"$f":"Input!A69","v":"ASkill01"},{"$f":"Input!C69","v":" "},{"$f":"Input!D69","v":" "},{"$f":"Input!E69","v":" "},0]
[null,{"$f":"Input!A74","v":"ASkill02"},{"$f":"Input!C74","v":" "},{"$f":"Input!D74","v":" "},{"$f":"Input!E74","v":" "},0,null,"per",{"$f":"Calc!B6","v":"Spatial Skill"},1,{"$f":"IF(AND(N19=0,N20=0),0.485,P19/O19)","v":0.485},0.015,0.015,{"$f":"J5","v":0},{"$f":"L5","v":9},{"$f":"N19-Q19","v":-0.135},{"$f":"O19*M19","v":0.135}]
[null,{"$f":"Input!A78","v":"BKnoMIV01"},{"$f":"Input!C78","v":0},{"$f":"Input!D78","v":0},{"$f":"Input!E78","v":0},0,null,"con",null,1,{"$f":"IF(AND(N19=0,N20=0),0.485,P20/O20)","v":0.485},0.015,0.015,{"$f":"K5","v":0},{"$f":"L5","v":9},{"$f":"N20-Q19","v":-0.135},{"$f":"O20*M20","v":0.135}]
[null,{"$f":"Input!A79","v":"BKnoMIV02"},{"$f":"Input!C79","v":0},{"$f":"Input!D79","v":0},{"$f":"Input!E79","v":0},0]
[null,{"$f":"Input!A80","v":"BKnoMIV03"},{"$f":"Input!C80","v":0},{"$f":"Input!D80","v":0},{"$f":"Input!E80","v":0},0,null,"per",{"$f":"Calc!B7","v":"Professional Skill"},1,{"$f":"IF(AND(N22=0,N23=0),0.485,P22/O22)","v":0.485},0.015,0.015,{"$f":"J6","v":0},{"$f":"L6","v":12},{"$f":"N22-Q22","v":-0.18},{"$f":"O22*M22","v":0.18}]
[null,{"$f":"Input!A81","v":"BKnoMIV04"},{"$f":"Input!C81","v":0},{"$f":"Input!D81","v":0},{"$f":"Input!E81","v":0},0,null,"con",null,1,{"$f":"IF(AND(N22=0,N23=0),0.485,P23/O23)","v":0.485},0.015,0.015,{"$f":"K6","v":0},{"$f":"L6","v":12},{"$f":"N23-Q22","v":-0.18},{"$f":"O23*M23","v":0.18}]
[null,{"$f":"Input!A82","v":"BKnoMIV05"},{"$f":"Input!C82","v":0},{"$f":"Input!D82","v":0},{"$f":"Input!E82","v":0},0]
[null,{"$f":"Input!A83","v":"BKnoDDM01"},{"$f":"Input!C83","v":0},{"$f":"Input!D83","v":0},{"$f":"Input!E83","v":0},0,null,"per",{"$f":"Calc!B8","v":"Application Skill"},1,{"$f":"IF(AND(N25=0,N26=0),0.485,P25/O25)","v":0.485},0.015,0.015,{"$f":"J7","v":0},{"$f":"L7","v":6},{"$f":"N25-Q25","v":-0.09},{"$f":"O25*M25","v":0.09}]
[null,{"$f":"Input!A84","v":"BKnoDDM02"},{"$f":"Input!C84","v":0},{"$f":"Input!D84","v":0},{"$f":"Input!E84","v":0},0,null,"con",null,1,{"$f":"IF(AND(N25=0,N26=0),0.485,P26/O26)","v":0.485},0.015,0.015,{"$f":"K7","v":0},{"$f":"L7","v":6},{"$f":"N26-Q25","v":-0.09},{"$f":"O26*M26","v":0.09}]
[null,{"$f":"Input!A85","v":"BKnoDDM03"},{"$f":"Input!C85","v":0},{"$f":"Input!D85","v":0},{"$f":"Input!E85","v":0},0]
[null,{"$f":"Input!A86","v":"BKnoDDM04"},{"$f":"Input!C86","v":0},{"$f":"Input!D86","v":0},{"$f":"Input!E86","v":0},0,null,null,"%Pos","%Spec+ve","%Spec-ve","%slider fill","%slider size","Standard","Slider Position","Spectrum","Slider Fill","Slider Size"]
[null,{"$f":"Input!A87","v":"BKnoDDM05"},{"$f":"Input!C87","v":0},{"$f":"Input!D87","v":0},{"$f":"Input!E87","v":0},0,null,null,{"$f":"IFERROR(O29/P29,0)","v":0},1,-1,{"$f":"IF(I29=0,N29/2,IF(I29>0, I29-N29, N29+I29))","v":0.0075},{"$f":"IF(L29<0,-N29,N29)","v":0.015},0.015,{"$f":"IFERROR(Q5,0)","v":0},{"$f":"R5","v":0},{"$f":"O29-R29","v":0},{"$f":"P29*N29","v":0}]
["C",{"$f":"Input!A88","v":"BKnoGP01"},{"$f":"Input!C88","v":0},{"$f":"Input!D88","v":0},{"$f":"Input!E88","v":0},0]
["C",{"$f":"Input!A89","v":"BKnoGP02"},{"$f":"Input!C89","v":0},{"$f":"Input!D89","v":0},{"$f":"Input!E89","v":0},0]
["C",{"$f":"Input!A90","v":"BKnoGP03"},{"$f":"Input!C90","v":0},{"$f":"Input!D90","v":0},{"$f":"Input!E90","v":0},0]
["P",{"$f":"Input!A91","v":"BKnoND01"},{"$f":"Input!C91","v":0},{"$f":"Input!D91","v":0},{"$f":"Input!E91","v":0},0]
["P",{"$f":"Input!A92","v":"BKnoND02"},{"$f":"Input!C92","v":0},{"$f":"Input!D92","v":0},{"$f":"Input!E92","v":0},0]
["P",{"$f":"Input!A93","v":"BKnoND03"},{"$f":"Input!C93","v":0},{"$f":"Input!D93","v":0},{"$f":"Input!E93","v":0},0]
["P",{"$f":"Input!A94","v":"BKnoND04"},{"$f":"Input!C94","v":0},{"$f":"Input!D94","v":0},{"$f":"Input!E94","v":0},0]
["P",{"$f":"Input!A95","v":"BKnoND05"},{"$f":"Input!C95","v":0},{"$f":"Input!D95","v":0},{"$f":"Input!E95","v":0},0]
["P",{"$f":"Input!A96","v":"BKnoND06"},{"$f":"Input!C96","v":0},{"$f":"Input!D96","v":0},{"$f":"Input!E96","v":0},0]
["P",{"$f":"Input!A97","v":"BKnoPPS01"},{"$f":"Input!C97","v":0},{"$f":"Input!D97","v":0},{"$f":"Input!E97","v":0},0]
["P",{"$f":"Input!A98","v":"BKnoPPS02"},{"$f":"Input!C98","v":0},{"$f":"Input!D98","v":0},{"$f":"Input!E98","v":0},0]
["P",{"$f":"Input!A99","v":"BKnoPPS03"},{"$f":"Input!C99","v":0},{"$f":"Input!D99","v":0},{"$f":"Input!E99","v":0},0]
["P",{"$f":"Input!A100","v":"BKnoPPS04"},{"$f":"Input!C100","v":0},{"$f":"Input!D100","v":0},{"$f":"Input!E100","v":0},0]
[null,{"$f":"Input!A101","v":"BKnoG01"},{"$f":"Input!C101","v":0},{"$f":"Input!D101","v":0},{"$f":"Input!E101","v":0},0]
[null,{"$f":"Input!A102","v":"BKnoG02"},{"$f":"Input!C102","v":0},{"$f":"Input!D102","v":0},{"$f":"Input!E102","v":0},0]
[null,{"$f":"Input!A103","v":"BKnoG03"},{"$f":"Input!C103","v":0},{"$f":"Input!D103","v":0},{"$f":"Input!E103","v":0},0]
[null,{"$f":"Input!A104","v":"BKnoG04"},{"$f":"Input!C104","v":0},{"$f":"Input!D104","v":0},{"$f":"Input!E104","v":0},0]
[null,{"$f":"Input!A105","v":"BKnoG05"},{"$f":"Input!C105","v":0},{"$f":"Input!D105","v":0},{"$f":"Input!E105","v":0},0]
[null,{"$f":"Input!A106","v":"BKnoG06"},{"$f":"Input!C106","v":0},{"$f":"Input!D106","v":0},{"$f":"Input!E106","v":0},0]
[null,{"$f":"Input!A107","v":"BKnoG07"},{"$f":"Input!C107","v":0},{"$f":"Input!D107","v":0},{"$f":"Input!E107","v":0},0]
[null,{"$f":"Input!A108","v":"BKnoG08"},{"$f":"Input!C108","v":0},{"$f":"Input!D108","v":0},{"$f":"Input!E108","v":0},0]
["C",{"$f":"Input!A109","v":"SupKnoCB01"},{"$f":"Input!C109","v":" "},{"$f":"Input!D109","v":" "},{"$f":"Input!E109","v":" "},0]
["C",{"$f":"Input!A115","v":"SupKnoCB02"},{"$f":"Input!C115","v":" "},{"$f":"Input!D115","v":" "},{"$f":"Input!E115","v":" "},0]
["C",{"$f":"Input!A118","v":"SupKnoE01"},{"$f":"Input!C118","v":" "},{"$f":"Input!D118","v":" "},{"$f":"Input!E118","v":" "},0]
["C",{"$f":"Input!A122","v":"SupKnoE02"},{"$f":"Input!C122","v":" "},{"$f":"Input!D122","v":" "},{"$f":"Input!E122","v":" "},0]
["C",{"$f":"Input!A125","v":"SupKnoS01"},{"$f":"Input!C125","v":" "},{"$f":"Input!D125","v":" "},{"$f":"Input!E125","v":" "},0]
["C",{"$f":"Input!A128","v":"SupKnoS02"},{"$f":"Input!C128","v":" "},{"$f":"Input!D128","v":" "},{"$f":"Input!E128","v":" "},0]
["P",{"$f":"Input!A134","v":"SpKnoRST01"},{"$f":"Input!C134","v":0},{"$f":"Input!D134","v":0},{"$f":"Input!E134","v":0},0]
["P",{"$f":"Input!A135","v":"SpKnoRST02"},{"$f":"Input!C135","v":0},{"$f":"Input!D135","v":0},{"$f":"Input!E135","v":0},0]
["P",{"$f":"Input!A136","v":"SpKnoRST03"},{"$f":"Input!C136","v":0},{"$f":"Input!D136","v":0},{"$f":"Input!E136","v":0},0]
["P",{"$f":"Input!A137","v":"SpKnoRST04"},{"$f":"Input!C137","v":0},{"$f":"Input!D137","v":0},{"$f":"Input!E137","v":0},0]
["P",{"$f":"Input!A138","v":"SpKnoRST05"},{"$f":"Input!C138","v":0},{"$f":"Input!D138","v":0},{"$f":"Input!E138","v":0},0]
["P",{"$f":"Input!A139","v":"SpKnoRST06"},{"$f":"Input!C139","v":0},{"$f":"Input!D139","v":0},{"$f":"Input!E139","v":0},0]
["P",{"$f":"Input!A140","v":"SpKnoRST07"},{"$f":"Input!C140","v":0},{"$f":"Input!D140","v":0},{"$f":"Input!E140","v":0},0]
["P",{"$f":"Input!A141","v":"SpKnoRST08"},{"$f":"Input!C141","v":0},{"$f":"Input!D141","v":0},{"$f":"Input!E141","v":0},0]
["P",{"$f":"Input!A142","v":"SpKnoRST09"},{"$f":"Input!C142","v":0},{"$f":"Input!D142","v":0},{"$f":"Input!E142","v":0},0]
["P",{"$f":"Input!A143","v":"SpKnoRST10"},{"$f":"Input!C143","v":0},{"$f":"Input!D143","v":0},{"$f":"Input!E143","v":0},0]
["P",{"$f":"Input!A144","v":"SpKnoSTLA01"},{"$f":"Input!C144","v":0},{"$f":"Input!D144","v":0},{"$f":"Input!E144","v":0},{"$f":"IFERROR(RIGHT(C67)+D67+E67,0)","v":0}]
["P",{"$f":"Input!A145","v":"SpKnoSTLA02"},{"$f":"Input!C145","v":0},{"$f":"Input!D145","v":0},{"$f":"Input!E145","v":0},0]
["P",{"$f":"Input!A146","v":"SpKnoSTLA03"},{"$f":"Input!C146","v":0},{"$f":"Input!D146","v":0},{"$f":"Input!E146","v":0},0]
["P",{"$f":"Input!A147","v":"SpKnoSTLA04"},{"$f":"Input!C147","v":0},{"$f":"Input!D147","v":0},{"$f":"Input!E147","v":0},0]
["P",{"$f":"Input!A148","v":"SpKnoSTLA05"},{"$f":"Input!C148","v":0},{"$f":"Input!D148","v":0},{"$f":"Input!E148","v":0},0]
["P",{"$f":"Input!A149","v":"SpKnoSTLA06"},{"$f":"Input!C149","v":0},{"$f":"Input!D149","v":0},{"$f":"Input!E149","v":0},0]
["P",{"$f":"Input!A150","v":"SpKnoSTLA07"},{"$f":"Input!C150","v":0},{"$f":"Input!D150","v":0},{"$f":"Input!E150","v":0},0]
["P",{"$f":"Input!A151","v":"SpKnoSTLA08"},{"$f":"Input!C151","v":0},{"$f":"Input!D151","v":0},{"$f":"Input!E151","v":0},0]
["P",{"$f":"Input!A152","v":"SpKnoSTLA09"},{"$f":"Input!C152","v":0},{"$f":"Input!D152","v":0},{"$f":"Input!E152","v":0},0]
["P",{"$f":"Input!A153","v":"SpKnoSTLA10"},{"$f":"Input!C153","v":0},{"$f":"Input!D153","v":0},{"$f":"Input!E153","v":0},0]
["P",{"$f":"Input!A154","v":"SpKnoSTLA11"},{"$f":"Input!C154","v":0},{"$f":"Input!D154","v":0},{"$f":"Input!E154","v":0},0]
["P",{"$f":"Input!A155","v":"SpKnoPCT01"},{"$f":"Input!C155","v":0},{"$f":"Input!D155","v":0},{"$f":"Input!E155","v":0},0]
["P",{"$f":"Input!A156","v":"SpKnoPCT02"},{"$f":"Input!C156","v":0},{"$f":"Input!D156","v":0},{"$f":"Input!E156","v":0},0]
["P",{"$f":"Input!A157","v":"SpKnoPCT03"},{"$f":"Input!C157","v":0},{"$f":"Input!D157","v":0},{"$f":"Input!E157","v":0},0]
["P",{"$f":"Input!A158","v":"SpKnoPCT04"},{"$f":"Input!C158","v":0},{"$f":"Input!D158","v":0},{"$f":"Input!E158","v":0},0]
["P",{"$f":"Input!A159","v":"SpKnoPCT05"},{"$f":"Input!C159","v":0},{"$f":"Input!D159","v":0},{"$f":"Input!E159","v":0},0]
["P",{"$f":"Input!A160","v":"SpKnoPCT06"},{"$f":"Input!C160","v":0},{"$f":"Input!D160","v":0},{"$f":"Input!E160","v":0},0]
["P",{"$f":"Input!A161","v":"SpKnoPCT07"},{"$f":"Input!C161","v":0},{"$f":"Input!D161","v":0},{"$f":"Input!E161","v":0},0]
["P",{"$f":"Input!A162","v":"SpKnoPCT08"},{"$f":"Input!C162","v":0},{"$f":"Input!D162","v":0},{"$f":"Input!E162","v":0},0]
[null,{"$f":"Input!A163","v":"SpKnoGIS01"},{"$f":"Input!C163","v":0},{"$f":"Input!D163","v":0},{"$f":"Input!E163","v":0},0]
[null,{"$f":"Input!A164","v":"SpKnoGIS02"},{"$f":"Input!C164","v":0},{"$f":"Input!D164","v":0},{"$f":"Input!E164","v":0},0]
[null,{"$f":"Input!A165","v":"SpKnoGIS03"},{"$f":"Input!C165","v":0},{"$f":"Input!D165","v":0},{"$f":"Input!E165","v":0},0]
[null,{"$f":"Input!A166","v":"SpKnoGIS04"},{"$f":"Input!C166","v":0},{"$f":"Input!D166","v":0},{"$f":"Input!E166","v":0},0]
[null,{"$f":"Input!A167","v":"SpKnoGIS05"},{"$f":"Input!C167","v":0},{"$f":"Input!D167","v":0},{"$f":"Input!E167","v":0},0]
[null,{"$f":"Input!A168","v":"SpKnoGIS06"},{"$f":"Input!C168","v":0},{"$f":"Input!D168","v":0},{"$f":"Input!E168","v":0},0]
[null,{"$f":"Input!A169","v":"SpKnoGIS07"},{"$f":"Input!C169","v":0},{"$f":"Input!D169","v":0},{"$f":"Input!E169","v":0},0]
[null,{"$f":"Input!A170","v":"SpKnoGIS08"},{"$f":"Input!C170","v":0},{"$f":"Input!D170","v":0},{"$f":"Input!E170","v":0},0]
[null,{"$f":"Input!A171","v":"SpKnoGIS09"},{"$f":"Input!C171","v":0},{"$f":"Input!D171","v":0},{"$f":"Input!E171","v":0},0]
[null,{"$f":"Input!A172","v":"SpKnoGIS10"},{"$f":"Input!C172","v":0},{"$f":"Input!D172","v":0},{"$f":"Input!E172","v":0},0]
[null,{"$f":"Input!A173","v":"SpKnoGIS11"},{"$f":"Input!C173","v":0},{"$f":"Input!D173","v":0},{"$f":"Input!E173","v":0},0]
[null,{"$f":"Input!A174","v":"SpKnoDAMM01"},{"$f":"Input!C174","v":0},{"$f":"Input!D174","v":0},{"$f":"Input!E174","v":0},0]
[null,{"$f":"Input!A175","v":"SpKnoDAMM02"},{"$f":"Input!C175","v":0},{"$f":"Input!D175","v":0},{"$f":"Input!E175","v":0},0]
[null,{"$f":"Input!A176","v":"SpKnoDAMM03"},{"$f":"Input!C176","v":0},{"$f":"Input!D176","v":0},{"$f":"Input!E176","v":0},0]
[null,{"$f":"Input!A177","v":"SpKnoDAMM04"},{"$f":"Input!C177","v":0},{"$f":"Input!D177","v":0},{"$f":"Input!E177","v":0},0]
[null,{"$f":"Input!A178","v":"SpKnoDAMM05"},{"$f":"Input!C178","v":0},{"$f":"Input!D178","v":0},{"$f":"Input!E178","v":0},0]
[null,{"$f":"Input!A179","v":"SpKnoDAMM06"},{"$f":"Input!C179","v":0},{"$f":"Input!D179","v":0},{"$f":"Input!E179","v":0},0]
[null,{"$f":"Input!A180","v":"SpKnoDAMM07"},{"$f":"Input!C180","v":0},{"$f":"Input!D180","v":0},{"$f":"Input!E180","v":0},0]
["C",{"$f":"Input!A181","v":"SpKnoProg01"},{"$f":"Input!C181","v":0},{"$f":"Input!D181","v":0},{"$f":"Input!E181","v":0},0]
["C",{"$f":"Input!A182","v":"SpKnoProg02"},{"$f":"Input!C182","v":0},{"$f":"Input!D182","v":0},{"$f":"Input!E182","v":0},0]
["C",{"$f":"Input!A183","v":"SpKnoProg03"},{"$f":"Input!C183","v":0},{"$f":"Input!D183","v":0},{"$f":"Input!E183","v":0},0]
["C",{"$f":"Input!A184","v":"SpKnoProg04"},{"$f":"Input!C184","v":0},{"$f":"Input!D184","v":0},{"$f":"Input!E184","v":0},0]
["C",{"$f":"Input!A185","v":"SpKnoProg05"},{"$f":"Input!C185","v":0},{"$f":"Input!D185","v":0},{"$f":"Input!E185","v":0},0]
["C",{"$f":"Input!A186","v":"SpKnoProg06"},{"$f":"Input!C186","v":0},{"$f":"Input!D186","v":0},{"$f":"Input!E186","v":0},0]
["C",{"$f":"Input!A187","v":"SpKnoProg07"},{"$f":"Input!C187","v":0},{"$f":"Input!D187","v":0},{"$f":"Input!E187","v":0},0]
["C",{"$f":"Input!A188","v":"SpKnoProg08"},{"$f":"Input!C188","v":0},{"$f":"Input!D188","v":0},{"$f":"Input!E188","v":0},0]
["C",{"$f":"Input!A189","v":"SpKnoProg09"},{"$f":"Input!C189","v":0},{"$f":"Input!D189","v":0},{"$f":"Input!E189","v":0},0]
["C",{"$f":"Input!A190","v":"SpKnoProg10"},{"$f":"Input!C190","v":0},{"$f":"Input!D190","v":0},{"$f":"Input!E190","v":0},0]
["C",{"$f":"Input!A191","v":"SpKnoProg11"},{"$f":"Input!C191","v":0},{"$f":"Input!D191","v":0},{"$f":"Input!E191","v":0},0]
["P",{"$f":"Input!A192","v":"SpKnoGNSSG01"},{"$f":"Input!C192","v":0},{"$f":"Input!D192","v":0},{"$f":"Input!E192","v":0},0]
["P",{"$f":"Input!A193","v":"SpKnoGNSSG02"},{"$f":"Input!C193","v":0},{"$f":"Input!D193","v":0},{"$f":"Input!E193","v":0},0]
["P",{"$f":"Input!A194","v":"SpKnoGNSSG03"},{"$f":"Input!C194","v":0},{"$f":"Input!D194","v":0},{"$f":"Input!E194","v":0},0]
["P",{"$f":"Input!A195","v":"SpKnoGNSSG04"},{"$f":"Input!C195","v":0},{"$f":"Input!D195","v":0},{"$f":"Input!E195","v":0},0]
["P",{"$f":"Input!A196","v":"SpKnoGNSSG05"},{"$f":"Input!C196","v":0},{"$f":"Input!D196","v":0},{"$f":"Input!E196","v":0},0]
["P",{"$f":"Input!A197","v":"SpKnoGNSSG06"},{"$f":"Input!C197","v":0},{"$f":"Input!D197","v":0},{"$f":"Input!E197","v":0},0]

{"sheet":"ProtoD","index":4,"n_rows":46,"n_cols":14,"rows_kept":46,"hidden":true}
{"$rows_empty":17}
[{"$nulls":9},{"$f":"IF(Input!C8=\"Please Select\", \"Subject/Course\", IF(Input!C8=\"Topic\", Calc!L16, IF(Input!C8=\"Subject\", Calc!L17, IF(Input!C8=\"Course\",Calc!L18, IF(Input!C8=\"Programme\", Calc!L19, \" \")))))","v":"Subject/Course"}]
[{"$nulls":9},{"$f":"IF(ISBLANK(Input!B8), \"-\", Input!B8)","v":"-"}]
[]
[{"$nulls":9},"Diagnosed Level",null,null,{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\"Specialization Focus\",\" \")","v":"Specialization Focus"}]
[{"$nulls":9},{"$f":"IF(SUM(Calc!H16:H19) = 0, \"N/A\", IF(AND(SUM(Calc!H18:H19)>SUM(Calc!H17:H18),SUM(Calc!H18:H19)>SUM(Calc!H16:H17)), \"Advance\", IF(AND(SUM(Calc!H17:H18)>SUM(Calc!H18:H19), SUM(Calc!H17:H18)>SUM(Calc!H16:H17)), \"Intermediate\", \"Introductory\")))","v":"N/A"},null,null,{"$f":"IF(OR(J18=Calc!L17, J18=Calc!L16, J18=\"Subject/Course\"), IF(SUM(Calc!E24:E30)=0,\"N/A\",IF(AND(Calc!E24<0.2,Calc!E25<0.2,Calc!E26<0.2,Calc!E27<0.2,Calc!E28<0.2,Calc!E29<0.2,Calc!E30<0.2),\"Broad\",VLOOKUP(INDEX(Calc!A23:A29,MATCH(MAX(Calc!E24:E30),Calc!E24:E30,0)),Calc!A23:F29,2,0))),\" \")","v":"N/A"}]
[{"$nulls":9},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \", IF(AND(J22=\"Advance\", NOT(J22=\"Introductory\"), NOT(J22=\"Intermediate\")), \"Course focus on Analyzing, Theorizing and Justifying (new) Knowledge\", IF(AND(J22=\"Intermediate\", NOT(J22=\"Advance\"), NOT(J22=\"Introductory\")), \"Course focus on Knowledge, Application and Comprehension of theories\", \"Course focus on Knowledge Recall and Simple Calculations\")))","v":" "}]
[{"$nulls":12},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\"Supplementary Focus\",\" \")","v":"Supplementary Focus"}]
[{"$nulls":12},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),IF(SUM(Calc!E21:E23)=0,\"NIL\",IF(AND(Calc!E21=Calc!E22,Calc!E22=Calc!E23,Calc!E23=Calc!E21),\"None\",IF(AND(Calc!E21>Calc!E23,Calc!E21=Calc!E22),\"Construction, Building & Environment\",IF(AND(Calc!E22>Calc!E21,Calc!E22=Calc!E23),\"Environment & Social\",IF(AND(Calc!E23>Calc!E22,Calc!E23=Calc!E21),\"Construction, Building & Social\",VLOOKUP(INDEX(Calc!A20:A22,MATCH(MAX(Calc!E21:E23),Calc!E21:E23,0)),Calc!A20:F22,2,0)))))),\" \")","v":"NIL"}]
[{"$nulls":9},{"$f":"IF(OR(J18=Calc!L16, J18=Calc!L17,J18=\"Subject/Course\"), \"Comment\", \"Details\")","v":"Comment"}]
[{"$nulls":9},{"$f":"IF(OR(J18=Calc!L17, J18=Calc!L16, J18=\"Subject/Course\"), CONCATENATE(COUNTIF(Input!F12:F1048576, \"IMBALANCE\"), \" items of imbalanced nature.\"), \"Breakdown of Levels\")","v":"0 items of imbalanced nature."}]
[{"$nulls":9},{"$f":"IF(OR(J18=Calc!L17, J18=Calc!L16, J18=\"Subject/Course\"), CONCATENATE(COUNTIF(Input!F12:F1048576, \"ATTENTION REQUIRED\"), \" items require attention (more contact hours).\"), \" \")","v":"0 items require attention (more contact hours)."}]
[{"$nulls":10},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",\"Level 1\")","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",\"Level 2\")","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",\"Level 3\")","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",\"Level 4\")","v":" "}]
[{"$nulls":9},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",\"# of Items\")","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!H16)","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16,J18=\"Subject/Course\"),\" \",Calc!H17)","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!H18)","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!H19)","v":" "}]
[]
[{"$nulls":9},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",\"Technical Skills\")","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!F3)","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!G3)","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!I3)","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!J3)","v":" "}]
[{"$nulls":9},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",\"Data Skills\")","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!F4)","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!G4)","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!I4)","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!J4)","v":" "}]
[{"$nulls":9},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",\"Visualization Skills\")","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!F5)","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!G5)","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!I5)","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!J5)","v":" "}]
[{"$nulls":9},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",\"Spatial Skills\")","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!F6)","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!G6)","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!I6)","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!J6)","v":" "}]
[{"$nulls":9},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",\"Professional Skills\")","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!F7)","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!G7)","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!I7)","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!J7)","v":" "}]
[{"$nulls":9},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",\"Basic Knowledge\")","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!F10)","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!G10)","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!I10)","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!J10)","v":" "}]
[{"$nulls":9},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",\"Supplementary Knowledge\")","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!F11)","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!G11)","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!I11)","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!J11)","v":" "}]
[]
[]
[{"$nulls":9},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",\"Data Skills\")","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!F4)","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!G4)","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!I4)","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!J4)","v":" "}]
[{"$nulls":9},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",\"Visualization Skills\")","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!F5)","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!G5)","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!I5)","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!J5)","v":" "}]
[{"$nulls":9},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",\"Spatial Skills\")","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!F6)","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!G6)","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!I6)","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!J6)","v":" "}]
[{"$nulls":9},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",\"Professional Skills\")","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!F7)","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!G7)","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!I7)","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!J7)","v":" "}]
[{"$nulls":9},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",\"Basic Knowledge\")","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!F10)","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!G10)","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!I10)","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!J10)","v":" "}]
[{"$nulls":9},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",\"Supplementary Knowledge\")","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!F11)","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!G11)","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!I11)","v":" "},{"$f":"IF(OR(J18=Calc!L17,J18=Calc!L16, J18=\"Subject/Course\"),\" \",Calc!J11)","v":" "}]