{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Coversheet","Application by Block Classes 1","Application by Block Classes 2"],"not_rendered":{"images":1,"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"Coversheet","index":0,"n_rows":51,"n_cols":11,"rows_kept":51,"merged":[[0,0,0,2],[0,3,1,5],[0,6,1,7],[0,8,1,8],[1,0,1,2],[2,0,2,2],[2,6,2,7],[3,0,3,2],[4,2,4,3],[4,4,4,5],[4,6,4,7],[5,8,7,8],[8,8,16,8],[17,8,23,8],[24,8,31,8],[32,8,40,8],[41,8,48,8]]}
[{"$f":"K4&\" \"&L4","v":"SCHOOL NAME:   "},null,null,"Total Program Hours",null,null,{"$f":"SUM(H6:H49)","v":0},null,{"$f":"IFERROR(SUM(I6:I49),0)","v":{"v":0,"d":"0.0%"}},null,"ENTER THIS INFORMATION ONCE HERE"]
[{"$f":"K5&\" \"&L5","v":"ADDRESS:   "},{"$nulls":9},"THE INFORMATION WILL THEN SHOW ON ALL THREE TABS OF THIS SPREADSHEET"]
[{"$f":"K6&\" \"&L6","v":"PERSON APPLYING AND TITLE: "},{"$nulls":5},"Theory",null,{"$f":"'Application by Block Classes 1'!G371","v":0},null,"DATE:"]
[{"$f":"K7&\" \"&L7","v":"DEALER SPONSOR:  "},{"$nulls":5},"HandsOn",null,{"$f":"'Application by Block Classes 1'!G372","v":0},null,"SCHOOL NAME:  "]
[null,null,"Sheet 1",null,"Sheet 2",null,"Total",{"$nulls":3},"ADDRESS:  "]
["Section 1","Safety/Administration - Pgs. 14  - 24",null,{"$f":"SUM(C7:C8)","v":0},null,{"$f":"SUM(E7:E8)","v":0},null,{"$f":"SUM(F6,D6)","v":0},{"$f":"IFERROR(H6/$G$1,0)","v":{"v":0,"d":"0.0%"}},null,"PERSON APPLYING AND TITLE:"]
["1a","Theory and Operation",{"$f":"'Application by Block Classes 1'!AG26","v":0},null,{"$f":"'Application by Block Classes 2'!AG26","v":0},null,{"$f":"SUM(C7:E7)","v":0},{"$nulls":3},"DEALER SPONSOR: "]
["1b","Adminstrative",{"$f":"'Application by Block Classes 1'!AG35","v":0},null,{"$f":"'Application by Block Classes 2'!AG35","v":0},null,{"$f":"SUM(C8:E8)","v":0},{"$nulls":3},"PHONE/FAX:"]
["Section 2","Electronics/Electrical Systems - Pgs. 27- 32",null,{"$f":"SUM(C10:C17)","v":0},null,{"$f":"SUM(E10:E17)","v":0},null,{"$f":"SUM(F9,D9)","v":0},{"$f":"IFERROR(H9/$G$1,0)","v":{"v":0,"d":"0.0%"}},null,"EMAIL: "]
[2.1,"Fundamental Knowledge",{"$f":"'Application by Block Classes 1'!AG43","v":0},null,{"$f":"'Application by Block Classes 2'!AG43","v":0},null,{"$f":"SUM(C10:E10)","v":0},{"$nulls":3},"PROGRAM NAME: "]
[2.2,"Ohm's Law",{"$f":"'Application by Block Classes 1'!AG49","v":0},null,{"$f":"'Application by Block Classes 2'!AG49","v":0},null,0,{"$nulls":3},"PHONE/FAX:"]
[2.3,"12 and 24 Volt Cranking Systems",{"$f":"'Application by Block Classes 1'!AG57","v":0},null,{"$f":"'Application by Block Classes 2'!AG57","v":0},null,0,{"$nulls":3},"DEPT. CHAIR/HEAD: "]
[2.4,"12 and 24 Volt Charging Systems",{"$f":"'Application by Block Classes 1'!AG65","v":0},null,{"$f":"'Application by Block Classes 2'!AG65","v":0},null,0,{"$nulls":3},"CONTACT NAME:"]
[2.5,"Lighting, Accessory and Control Systems",{"$f":"'Application by Block Classes 1'!AG73","v":0},null,{"$f":"'Application by Block Classes 2'!AG73","v":0},null,0]
[2.6,"Electrical Schematics/Diagrams",{"$f":"'Application by Block Classes 1'!AG79","v":0},null,{"$f":"'Application by Block Classes 2'!AG79","v":0},null,0]
[2.7,"SAE Computer CAN-BUSS Standards",{"$f":"'Application by Block Classes 1'!AG85","v":0},null,{"$f":"'Application by Block Classes 2'!AG85","v":0},null,0]
[2.8,"Diagnostics",{"$f":"'Application by Block Classes 1'!AG95","v":0},null,{"$f":"'Application by Block Classes 2'!AG95","v":0},null,{"$f":"SUM(C17:E17)","v":0}]
["Section 3","Hydraulics/Hydrostatics  - Pgs. 34 - 45",null,{"$f":"SUM(C19:C24)","v":0},null,{"$f":"SUM(E19:E24)","v":0},null,{"$f":"SUM(F18,D18)","v":0},{"$f":"IFERROR(H18/$G$1,0)","v":{"v":0,"d":"0.0%"}}]
[3.1,"Theory and Operation of Hydraulics and Hydrostatics",{"$f":"'Application by Block Classes 1'!AG118","v":0},null,{"$f":"'Application by Block Classes 2'!AG118","v":0},null,{"$f":"SUM(C19:E19)","v":0}]
[3.2,"Fluids, Transfer Components and Filtering",{"$f":"'Application by Block Classes 1'!AG125","v":0},null,{"$f":"'Application by Block Classes 2'!AG125","v":0},null,0]
[3.3,"Maintenance Procedures",{"$f":"'Application by Block Classes 1'!AG136","v":0},null,{"$f":"'Application by Block Classes 2'!AG136","v":0},null,0]
[3.4,"Hydraulic Component Rebuild and Replacement",{"$f":"'Application by Block Classes 1'!AG146","v":0},null,{"$f":"'Application by Block Classes 2'!AG146","v":0},null,0]
[3.5,"Hydraulic Schematics",{"$f":"'Application by Block Classes 1'!AG153","v":0},null,{"$f":"'Application by Block Classes 2'!AG153","v":0},null,0]
[3.6,"Diagnostics:Systems and Component Troubleshooting",{"$f":"'Application by Block Classes 1'!AG163","v":0},null,{"$f":"'Application by Block Classes 2'!AG163","v":0},null,0]
["Section 4","Power Trains - Pgs. 47-59",null,{"$f":"SUM(C26:C32)","v":0},null,{"$f":"SUM(E26:E32)","v":0},null,{"$f":"SUM(F25,D25)","v":0},{"$f":"IFERROR(H25/$G$1,0)","v":{"v":0,"d":"0.0%"}}]
[4.1,"Theory and Operation",{"$f":"'Application by Block Classes 1'!AG186","v":0},null,{"$f":"'Application by Block Classes 2'!AG186","v":0},null,0]
[4.2,"Drive Shaft Function and Construction",{"$f":"'Application by Block Classes 1'!AG195","v":0},null,{"$f":"'Application by Block Classes 2'!AG195","v":0},null,0]
[4.3,"Theory of Hydraulic and Pneumatic Braking Systems",{"$f":"'Application by Block Classes 1'!AG204","v":0},null,{"$f":"'Application by Block Classes 2'!AG204","v":0},null,0]
[4.4,"Maintenane Practices",{"$f":"'Application by Block Classes 1'!AG211","v":0},null,{"$f":"'Application by Block Classes 2'!AG211","v":0},null,0]
[4.5,"Power Train Schematics and flow diagrams",{"$f":"'Application by Block Classes 1'!AG217","v":0},null,{"$f":"'Application by Block Classes 2'!AG217","v":0},null,0]
[4.6,"Troubleshooting and failure analysis",{"$f":"'Application by Block Classes 1'!AG225","v":0},null,{"$f":"'Application by Block Classes 2'!AG225","v":0},null,0]
[4.7,"Component Rebuild and Analysis",{"$f":"'Application by Block Classes 1'!AG233","v":0},null,{"$f":"'Application by Block Classes 2'!AG233","v":0},null,0]
["Section 5","Diesel Engines - Pgs. 61-71",null,{"$f":"SUM(C34:C41)","v":0},null,{"$f":"SUM(E34:E41)","v":0},null,{"$f":"SUM(F33,D33)","v":0},{"$f":"IFERROR(H33/$G$1,0)","v":{"v":0,"d":"0.0%"}}]
[5.1,"Safety",{"$f":"'Application by Block Classes 1'!AG239","v":0},null,{"$f":"'Application by Block Classes 2'!AG239","v":0},null,0]
[5.2,"Identifying and use of basic tools",{"$f":"'Application by Block Classes 1'!AG249","v":0},null,{"$f":"'Application by Block Classes 2'!AG249","v":0},null,0]
[5.3,"Theory and Operation",{"$f":"'Application by Block Classes 1'!AG261","v":0},null,{"$f":"'Application by Block Classes 2'!AG261","v":0},null,0]
[5.4,"Maintenance Practices",{"$f":"'Application by Block Classes 1'!AG269","v":0},null,{"$f":"'Application by Block Classes 2'!AG269","v":0},null,0]
[5.5,"Component Rebuild",{"$f":"'Application by Block Classes 1'!AG276","v":0},null,{"$f":"'Application by Block Classes 2'!AG276","v":0},null,0]
[5.6,"Engine Subsystem Components",{"$f":"'Application by Block Classes 1'!AG285","v":0},null,{"$f":"'Application by Block Classes 2'!AG285","v":0},null,0]
[5.7,"Fuel and Governing Systems",{"$f":"'Application by Block Classes 1'!AG293","v":0},null,{"$f":"'Application by Block Classes 2'!AG293","v":0},null,0]
[5.8,"Diagnostics",{"$f":"'Application by Block Classes 1'!AG301","v":0},null,{"$f":"'Application by Block Classes 2'!AG301","v":0},null,0]
["Section 6","Air Conditioning and Heating Systems - Pgs. 74 - 80",null,{"$f":"SUM(C43:C49)","v":0},null,{"$f":"SUM(E43:E49)","v":0},null,{"$f":"SUM(F42,D42)","v":0},{"$f":"IFERROR(H42/$G$1,0)","v":{"v":0,"d":"0.0%"}}]
[6.1,"Fundamental Knowledge",{"$f":"'Application by Block Classes 1'!AG311","v":0},null,{"$f":"'Application by Block Classes 2'!AG311","v":0},null,0]
[6.2,"AC System Operation",{"$f":"'Application by Block Classes 1'!AG318","v":0},null,{"$f":"'Application by Block Classes 2'!AG318","v":0},null,0]
[6.3,"Servicing AC systems",{"$f":"'Application by Block Classes 1'!AG327","v":0},null,{"$f":"'Application by Block Classes 2'!AG327","v":0},null,0]
[6.4,"Testing, Troubleshooting and Repairing AC systems",{"$f":"'Application by Block Classes 1'!AG340","v":0},null,{"$f":"'Application by Block Classes 2'!AG340","v":0},null,0]
[6.5,"Heating System Operation",{"$f":"'Application by Block Classes 1'!AG348","v":0},null,{"$f":"'Application by Block Classes 2'!AG348","v":0},null,0]
[6.6,"Servicing Heating Systems",{"$f":"'Application by Block Classes 1'!AG357","v":0},null,{"$f":"'Application by Block Classes 2'!AG357","v":0},null,0]
[6.7,"Pressurized Cabs",{"$f":"'Application by Block Classes 1'!AG363","v":0},null,{"$f":"'Application by Block Classes 2'!AG363","v":0},null,0]
[]
[null,"TOTALS",{"$f":"SUM(C6:C49)","v":0},0,0,0,0,0,{"v":0,"d":"0.0%"}]

{"sheet":"Application by Block Classes 1","index":1,"n_rows":373,"n_cols":38,"rows_kept":373,"merged":[[0,0,0,1],[0,2,0,9],[0,15,0,17],[0,18,0,25],[0,30,0,34],[1,0,1,1],[1,2,1,9],[1,15,1,17],[1,18,1,25],[2,0,2,1],[2,2,2,9],[2,15,2,17],[2,18,2,25],[3,0,3,1],[3,2,3,9],[3,15,3,17],[3,18,3,25],[4,0,4,1],[4,2,4,3],[4,5,4,9],[5,0,5,34],[6,2,6,29],[6,31,6,33],[7,2,7,3],[7,4,7,5],[7,6,7,7],[7,8,7,9],[7,10,7,11],[7,12,7,13],[7,14,7,15],[7,16,7,17],[7,18,7,19],[7,20,7,21],[7,22,7,23],[7,24,7,25],[7,26,7,27],[7,28,7,29],[7,31,7,33],[367,2,369,2],[367,4,369,4]]}
["SCHOOL NAME:  ",null,{"$f":"IF(Coversheet!L4=\"\",\"\",Coversheet!L4)","v":""},{"$nulls":12},"PROGRAM NAME: ",null,null,{"$f":"IF(Coversheet!L10=\"\",\"\",Coversheet!L10)","v":""},{"$nulls":10},"DATE:",{"$f":"IF(Coversheet!L3=\"\",\"\",Coversheet!L3)","v":""}]
["ADDRESS:  ",null,{"$f":"IF(Coversheet!L5=\"\",\"\",Coversheet!L5)","v":""},{"$nulls":12},"PHONE/FAX:",null,null,{"$f":"IF(Coversheet!L11=\"\",\"\",Coversheet!L11)","v":""}]
["PERSON APPLYING AND TITLE:",null,{"$f":"IF(Coversheet!L6=\"\",\"\",Coversheet!L6)","v":""},{"$nulls":12},"DEPT. CHAIR/HEAD: ",null,null,{"$f":"IF(Coversheet!L12=\"\",\"\",Coversheet!L12)","v":""}]
["DEALER SPONSOR: ",null,{"$f":"IF(Coversheet!L7=\"\",\"\",Coversheet!L7)","v":""},{"$nulls":12},"CONTACT NAME:",null,null,{"$f":"IF(Coversheet!L13=\"\",\"\",Coversheet!L13)","v":""}]
["PHONE/FAX:",null,{"$f":"IF(Coversheet!L8=\"\",\"\",Coversheet!L8)","v":""},null,"EMAIL: ",{"$f":"IF(Coversheet!L9=\"\",\"\",Coversheet!L9)","v":""}]
["AED Accreditation Program Analysis & Application"]
[null,null,"PLEASE NOTE: 1. At the top of each column in the yellow cell fill the the course name or course number for each to be considered.                                                                                                                                                                                                                                                                                                               2. For additional courses, use Tab2 titled Application by Block Classes 2.                                                                                                                                                                                                                                                                                                                                                                                                             3. To make a note next to a row, insert a number in the \"NO. FOR FOOT NOTE\" column AI. ",{"$nulls":31},"NO. FOR FOOT NOTE"]
[null,"Course Names --->",{"$nulls":33},"FROM  SPREAD SHEET 2","NEW TOTAL HRS","% TOTAL"]
[null,null,"Theory","Hands-on","Theory","Hands-on","Theory","Hands-on","Theory","Hands-on","Theory","Hands-on","Theory","Hands-on","Theory","Hands-on","Theory","Hands-on","Theory","Hands-on","Theory","Hands-on","Theory","Hands-on","Theory","Hands-on","Theory","Hands-on","Theory","Hands-on"]
["Section 1","Safety/Administration - Pgs. 14  - 24"]
["1a","Theory and Operation"]
[null,"Use of hand tools",{"$nulls":30},{"$f":"SUM(C12:AD12)","v":0}]
[null,"Use of electric tools",{"$nulls":30},0]
[null,"Use of air tools",{"$nulls":30},0]
[null,"Use of hydraulic tools",{"$nulls":30},0]
[null,"Use of lifting equipment",{"$nulls":30},0]
[null,"Use of various cleaning equipment",{"$nulls":30},0]
[null,"Use of metal cutting and welding equipment",{"$nulls":30},0]
[null,"Use of media type blasting equipment",{"$nulls":30},0]
[null,"Fluid pressure testing equipment",{"$nulls":30},0]
[null,"Environment of service facility",{"$nulls":30},0]
[null,"Machinery operation and identification",{"$nulls":30},0]
[null,"Federal and State OSHA and MSHA mandated regulations",{"$nulls":30},0]
[null,"Shop and in-field practices",{"$nulls":30},0]
[null,"Hazard identification and prevention",{"$nulls":30},0]
[null,"Total Hours Spent",{"$f":"SUM(C12:C25)","v":0},0,0,0,0,0,0,{"$f":"SUM(J10:J25)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[null,null,"Hands-On",{"$f":"D26+F26+H26+J26+L26+N26+P26+R26+T26+V26+X26+Z26+AB26+AD26","v":0},"Theory",{"$f":"C26+E26+G26+I26+K26+M26+O26+Q26+S26+U26+W26+Y26+AA26+AC26","v":0}]
[]
["1b","Adminstrative"]
[null,"comprehend basic academic functions",{"$nulls":30},{"$f":"SUM(C30:AD30)","v":0}]
[null,"utilize industry software and electronic communication systems and reference resources",{"$nulls":30},0]
[null,"demonstrate an awareness of expected company goals and objectives",{"$nulls":30},0]
[null,"define basic business practices",{"$nulls":30},0]
[null,"explain department goals and procedures",{"$nulls":30},0]
[null,"Total Hours Spent",{"$f":"SUM(C30:C34)","v":0},{"$f":"SUM(D30:D34)","v":0},0,0,0,0,{"$f":"SUM(I30:I34)","v":0},{"$f":"SUM(J30:J34)","v":0},{"$f":"SUM(K30:K34)","v":0},{"$f":"SUM(L30:L34)","v":0},0,0,0,0,{"$f":"SUM(Q30:Q34)","v":0},{"$f":"SUM(R30:R34)","v":0},{"$f":"SUM(S30:S34)","v":0},{"$f":"SUM(T30:T34)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(AD30:AD34)","v":0},null,null,0,null,{"$f":"AG26+AG35","v":0},{"$f":"'Application by Block Classes 2'!AI35","v":0},{"$f":"AI35+AJ35","v":0},{"$f":"AK35/AK366","v":{"$error":"#DIV/0!"}}]
[null,null,"Hands-On",{"$f":"D35+F35+H35+J35+L35+N35+P35+R35+T35+V35+X35+Z35+AB35+AD35","v":0},"Theory",{"$f":"C35+E35+G35+I35+K35+M35+O35+Q35+S35+U35+W35+Y35+AA35+AC35","v":0},{"$nulls":28},{"$f":"AI35/AI366","v":{"$error":"#DIV/0!"}}]
[]
["Section 2","Electronics/Electrical Systems - Pgs. 27- 32"]
[2.1,"Fundamental Knowledge"]
[null,"Atomic structure",{"$nulls":30},{"$f":"SUM(C40:AD40)","v":0}]
[null,"Electron theory of electricity",{"$nulls":30},{"$f":"SUM(C41:AD41)","v":0}]
[null,"Telematics-remote monitoring",{"$nulls":30},{"$f":"SUM(C42:AD42)","v":0}]
[null,"Total Hours Spent",{"$f":"SUM(C40:C42)","v":0},{"$f":"SUM(D40:D42)","v":0},0,0,0,0,{"$f":"SUM(I40:I42)","v":0},{"$f":"SUM(J40:J42)","v":0},{"$f":"SUM(K40:K42)","v":0},{"$f":"SUM(L40:L42)","v":0},0,0,0,0,{"$f":"SUM(Q40:Q42)","v":0},{"$f":"SUM(R40:R42)","v":0},{"$f":"SUM(S40:S42)","v":0},{"$f":"SUM(T40:T42)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(C43:AD43)","v":0}]
[null,null,"Hands-On",{"$f":"D43+F43+H43+J43+L43+N43+P43+R43+T43+V43+X43+Z43+AB43+AD43","v":0},"Theory",{"$f":"C43+E43+G43+I43+K43+M43+O43+Q43+S43+U43+W43+Y43+AA43+AC43","v":0}]
[]
[2.2,"Ohm's Law"]
[null,"Ohm’s Law theory",{"$nulls":30},{"$f":"SUM(C47:AD47)","v":0}]
[null,"applications to series, parallel and series/parallel DC Circuits",{"$nulls":30},{"$f":"SUM(C48:AD48)","v":0}]
[null,"Total Hours Spent",{"$f":"SUM(C47:C48)","v":0},{"$f":"SUM(D47:D48)","v":0},0,{"$f":"SUM(F47:F48)","v":0},0,0,{"$f":"SUM(I47:I48)","v":0},{"$f":"SUM(J47:J48)","v":0},{"$f":"SUM(K47:K48)","v":0},{"$f":"SUM(L47:L48)","v":0},0,0,0,0,{"$f":"SUM(Q47:Q48)","v":0},{"$f":"SUM(R47:R48)","v":0},{"$f":"SUM(S47:S48)","v":0},{"$f":"SUM(T47:T48)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(AD47:AD48)","v":0},null,null,{"$f":"SUM(C49:AD49)","v":0}]
[null,null,"Hands-On",{"$f":"D49+F49+H49+J49+L49+N49+P49+R49+T49+V49+X49+Z49+AB49+AD49","v":0},"Theory",{"$f":"C49+E49+G49+I49+K49+M49+O49+Q49+S49+U49+W49+Y49+AA49+AC49","v":0}]
[]
[2.3,"12 and 24 Volt Cranking Systems"]
[null,"Components",{"$nulls":30},{"$f":"SUM(C53:AD53)","v":0}]
[null,"Operation",{"$nulls":30},{"$f":"SUM(C54:AD54)","v":0}]
[null,"Troubleshooting",{"$nulls":30},{"$f":"SUM(C55:AD55)","v":0}]
[null,"Repair",{"$nulls":30},{"$f":"SUM(C56:AD56)","v":0}]
[null,"Total Hours Spent",{"$f":"SUM(C53:C56)","v":0},{"$f":"SUM(D53:D56)","v":0},0,0,0,0,{"$f":"SUM(I53:I56)","v":0},{"$f":"SUM(J53:J56)","v":0},{"$f":"SUM(K53:K56)","v":0},{"$f":"SUM(L53:L56)","v":0},0,0,0,0,{"$f":"SUM(Q53:Q56)","v":0},{"$f":"SUM(R53:R56)","v":0},{"$f":"SUM(S53:S56)","v":0},{"$f":"SUM(T53:T56)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(C57:AD57)","v":0}]
[null,null,"Hands-On",{"$f":"D57+F57+H57+J57+L57+N57+P57+R57+T57+V57+X57+Z57+AB57+AD57","v":0},"Theory",{"$f":"C57+E57+G57+I57+K57+M57+O57+Q57+S57+U57+W57+Y57+AA57+AC57","v":0}]
[]
[2.4,"12 and 24 Volt Charging Systems"]
[null,"Components",{"$nulls":30},{"$f":"SUM(C61:AD61)","v":0}]
[null,"Operation",{"$nulls":30},{"$f":"SUM(C62:AD62)","v":0}]
[null,"Troubleshooting",{"$nulls":30},{"$f":"SUM(C63:AD63)","v":0}]
[null,"Repair",{"$nulls":30},{"$f":"SUM(C64:AD64)","v":0}]
[null,"Total Hours Spent",{"$f":"SUM(C61:C64)","v":0},{"$f":"SUM(D61:D64)","v":0},0,0,0,0,{"$f":"SUM(I61:I64)","v":0},{"$f":"SUM(J61:J64)","v":0},{"$f":"SUM(K61:K64)","v":0},{"$f":"SUM(L61:L64)","v":0},0,0,0,0,{"$f":"SUM(Q61:Q64)","v":0},{"$f":"SUM(R61:R64)","v":0},{"$f":"SUM(S61:S64)","v":0},{"$f":"SUM(T61:T64)","v":0},0,0,0,0,0,0,{"$f":"SUM(AA61:AA64)","v":0},0,0,0,null,null,{"$f":"SUM(C65:AD65)","v":0}]
[null,null,"Hands-On",{"$f":"D65+F65+H65+J65+L65+N65+P65+R65+T65+V65+X65+Z65+AB65+AD65","v":0},"Theory",{"$f":"C65+E65+G65+I65+K65+M65+O65+Q65+S65+U65+W65+Y65+AA65+AC65","v":0}]
[]
[2.5,"Lighting, Accessory and Control Systems"]
[null,"Components",{"$nulls":30},{"$f":"SUM(C69:AD69)","v":0}]
[null,"Operation",{"$nulls":30},{"$f":"SUM(C70:AD70)","v":0}]
[null,"Troubleshooting",{"$nulls":30},{"$f":"SUM(C71:AD71)","v":0}]
[null,"Repair",{"$nulls":30},{"$f":"SUM(C72:AD72)","v":0}]
[null,"Total Hours Spent",{"$f":"SUM(C69:C72)","v":0},{"$f":"SUM(D69:D72)","v":0},0,0,0,0,{"$f":"SUM(I69:I72)","v":0},{"$f":"SUM(J69:J72)","v":0},{"$f":"SUM(K69:K72)","v":0},{"$f":"SUM(L69:L72)","v":0},0,0,0,0,{"$f":"SUM(Q69:Q72)","v":0},{"$f":"SUM(R69:R72)","v":0},{"$f":"SUM(S69:S72)","v":0},{"$f":"SUM(T69:T72)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(C73:AD73)","v":0}]
[null,null,"Hands-On",{"$f":"D73+F73+H73+J73+L73+N73+P73+R73+T73+V73+X73+Z73+AB73+AD73","v":0},"Theory",{"$f":"C73+E73+G73+I73+K73+M73+O73+Q73+S73+U73+W73+Y73+AA73+AC73","v":0}]
[]
[2.6,"Electrical Schematics/Diagrams"]
[null,"How to read schematics/diagrams",{"$nulls":30},{"$f":"SUM(C77:AD77)","v":0}]
[null,"How to use schematics/diagrams",{"$nulls":30},{"$f":"SUM(C78:AD78)","v":0}]
[null,"Total Hours Spent",{"$f":"SUM(C77:C78)","v":0},0,0,0,0,0,{"$f":"SUM(I77:I78)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(U77:U78)","v":0},0,0,0,0,0,{"$f":"SUM(AA77:AA78)","v":0},{"$f":"SUM(AB77:AB78)","v":0},{"$f":"SUM(AC77:AC78)","v":0},{"$f":"SUM(AD77:AD78)","v":0},null,null,{"$f":"SUM(C79:AD79)","v":0}]
[null,null,"Hands-On",{"$f":"D79+F79+H79+J79+L79+N79+P79+R79+T79+V79+X79+Z79+AB79+AD79","v":0},"Theory",{"$f":"C79+E79+G79+I79+K79+M79+O79+Q79+S79+U79+W79+Y79+AA79+AC79","v":0}]
[]
[2.7,"SAE Computer CAN-BUSS Standards"]
[null,"Understand communication standards",{"$nulls":30},{"$f":"SUM(C83:AD83)","v":0}]
[null,"Understand published error codes per SAE standards",{"$nulls":30},{"$f":"SUM(C84:AD84)","v":0}]
[null,"Total Hours Spent",{"$f":"SUM(C83:C84)","v":0},0,0,0,0,0,{"$f":"SUM(I83:I84)","v":0},{"$f":"SUM(J83:J84)","v":0},{"$f":"SUM(K83:K84)","v":0},{"$f":"SUM(L83:L84)","v":0},0,0,0,0,{"$f":"SUM(Q83:Q84)","v":0},{"$f":"SUM(R83:R84)","v":0},{"$f":"SUM(S83:S84)","v":0},{"$f":"SUM(T83:T84)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(C85:AD85)","v":0}]
[null,null,"Hands-On",{"$f":"D85+F85+H85+J85+L85+N85+P85+R85+T85+V85+X85+Z85+AB85+AD85","v":0},"Theory",{"$f":"C85+E85+G85+I85+K85+M85+O85+Q85+S85+U85+W85+Y85+AA85+AC85","v":0}]
[]
[2.8,"Diagnostics"]
[null,"Failure analysis on a required school owned engine driven simulator or machine",{"$nulls":30},{"$f":"SUM(C89:AD89)","v":0}]
[null,"Mastering use of all test equipment",{"$nulls":30},0]
[null,"Use of technical manuals",{"$nulls":30},0]
[null,"Use of schematic diagrams",{"$nulls":30},0]
[null,"Use of an interactive equipment diagnostic program",{"$nulls":30},0]
[null,"Demonstrate technical write-up competency",{"$nulls":30},0]
[null,"Total Hours Spent",{"$f":"SUM(C89:C94)","v":0},{"$f":"SUM(D89:D94)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,null,{"$f":"AG43+AG49+AG57+AG65+AG73+AG79+AG85+AG95","v":{"v":0,"d":"0.0"}},{"$f":"'Application by Block Classes 2'!AI95","v":0},{"$f":"AI95+AJ95","v":0},{"$f":"AK95/AK366","v":{"$error":"#DIV/0!"}}]
[null,null,"Hands-On",{"$f":"D95+F95+H95+J95+L95+N95+P95+R95+T95+V95+X95+Z95+AB95+AD95","v":0},"Theory",{"$f":"C95+E95+G95+I95+K95+M95+O95+Q95+S95+U95+W95+Y95+AA95+AC95","v":0},{"$nulls":28},{"$f":"AI95/AI366","v":{"$error":"#DIV/0!"}}]
[]
["Section 3","Hydraulics/Hydrostatics  - Pgs. 34 - 45"]
[3.1,"Theory and Operation of Hydraulics and Hydrostatics"]
[null,"Learn basic hydraulic principles",{"$nulls":30},{"$f":"SUM(C100:AD100)","v":0}]
[null,"Understand the difference between open and closed center systems",{"$nulls":30},0]
[null,"Applications of hydraulic systems",{"$nulls":30},0]
[null,"Basic hydrostatic principles and systems",{"$nulls":30},0]
[null,"The difference between hydrostatics & hydrodynamics ",{"$nulls":30},0]
[null,"The difference between the various displacement pumps",{"$nulls":30},0]
[null,"Identify various pumps, parts and operation",{"$nulls":30},0]
[null,"Identifying types of swash plate control",{"$nulls":30},{"$f":"SUM(C107:AD107)","v":0}]
[null,"The difference between fixed variable displacement and 2 speed motors",{"$nulls":30},0]
[null,"Identify various pump motors and operation of each; gear, vane, radial and axial piston motors and gerotors.",{"$nulls":30},0]
[null,"Function and uses electro-hydraulic valves, control systems",{"$nulls":30},0]
[null,"Function and use of types of hydraulic valves; pressure, control and volume",{"$nulls":30},0]
[null,"electro-hydraulics valves and control systems",{"$nulls":30},0]
[null,"Use of pressure control valves",{"$nulls":30},0]
[null,"Use of directional control valves",{"$nulls":30},0]
[null,"Use of volume control valves",{"$nulls":30},0]
[null,"Cylinder identification and operation",{"$nulls":30},0]
[null,"accumulator identification and operation",{"$nulls":30},0]
[null,"Total Hours Spent",{"$f":"SUM(C100:C117)","v":0},0,0,0,0,0,{"$f":"SUM(I100:I117)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(U100:U117)","v":0},0,0,0,0,0,{"$f":"SUM(AA100:AA117)","v":0},{"$f":"SUM(AB100:AB117)","v":0},{"$f":"SUM(AC100:AC117)","v":0},{"$f":"SUM(AD100:AD117)","v":0},null,null,0]
[null,null,"Hands-On",{"$f":"D118+F118+H118+J118+L118+N118+P118+R118+T118+V118+X118+Z118+AB118+AD118","v":0},"Theory",{"$f":"C118+E118+G118+I118+K118+M118+O118+Q118+S118+U118+W118+Y118+AA118+AC118","v":0}]
[]
[3.2,"Fluids, Transfer Components and Filtering"]
[null,"Know the function of hoses",{"$nulls":30},{"$f":"SUM(C122:AD122)","v":0}]
[null,"Knowledge and understanding of fittings",{"$nulls":30},{"$f":"SUM(C123:AD123)","v":0}]
[null,"Know the various use of filters",{"$nulls":30},{"$f":"SUM(C124:AD124)","v":0}]
[null,"Total Hours Spent",{"$f":"SUM(C122:C124)","v":0},0,0,0,0,0,{"$f":"SUM(I122:I124)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(U122:U124)","v":0},0,0,0,0,0,{"$f":"SUM(AA122:AA124)","v":0},{"$f":"SUM(AB122:AB124)","v":0},{"$f":"SUM(AC122:AC124)","v":0},{"$f":"SUM(AD122:AD124)","v":0},null,null,{"$f":"SUM(C125:AD125)","v":0}]
[null,null,"Hands-On",{"$f":"D125+F125+H125+J125+L125+N125+P125+R125+T125+V125+X125+Z125+AB125+AD125","v":0},"Theory",{"$f":"C125+E125+G125+I125+K125+M125+O125+Q125+S125+U125+W125+Y125+AA125+AC125","v":0}]
[]
[3.3,"Maintenance Procedures"]
[null,"Fluid - ISO cleanliness codes",{"$nulls":30},{"$f":"SUM(C129:AD129)","v":0}]
[null,"Proper flushing procedures",{"$nulls":30},0]
[null,"Prevening leaks and overheating",{"$nulls":30},0]
[null,"Identify worn or defective hoses",{"$nulls":30},0]
[null,"Various oil analysis",{"$nulls":30},0]
[null,"Various types of seals and gasket materials",{"$nulls":30},0]
[null,"Periodic maintenance & safety proceedures",{"$nulls":30},0]
[null,"Total Hours Spent",{"$f":"SUM(C129:C135)","v":0},{"$f":"SUM(D129:D135)","v":0},0,0,0,0,{"$f":"SUM(I129:I135)","v":0},{"$f":"SUM(J129:J135)","v":0},{"$f":"SUM(K129:K135)","v":0},{"$f":"SUM(L129:L135)","v":0},0,0,0,0,{"$f":"SUM(Q129:Q135)","v":0},{"$f":"SUM(R129:R135)","v":0},{"$f":"SUM(S129:S135)","v":0},{"$f":"SUM(T129:T135)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,0]
[null,null,"Hands-On",{"$f":"D136+F136+H136+J136+L136+N136+P136+R136+T136+V136+X136+Z136+AB136+AD136","v":0},"Theory",{"$f":"C136+E136+G136+I136+K136+M136+O136+Q136+S136+U136+W136+Y136+AA136+AC136","v":0}]
[]
[3.4,"Hydraulic Component Rebuild and Replacement"]
[null,"Pumps",{"$nulls":30},{"$f":"SUM(C140:AD140)","v":0}]
[null,"Motors",{"$nulls":30},0]
[null,"Valves",{"$nulls":30},0]
[null,"Cylinders",{"$nulls":30},0]
[null,"Accumulators",{"$nulls":30},0]
[null,"Safety Practices",{"$nulls":30},0]
[null,"Total Hours Spent",{"$f":"SUM(C140:C145)","v":0},{"$f":"SUM(D140:D145)","v":0},0,0,0,0,{"$f":"SUM(I140:I145)","v":0},{"$f":"SUM(J140:J145)","v":0},{"$f":"SUM(K140:K145)","v":0},{"$f":"SUM(L140:L145)","v":0},0,0,0,0,{"$f":"SUM(Q140:Q145)","v":0},{"$f":"SUM(R140:R145)","v":0},{"$f":"SUM(S140:S145)","v":0},{"$f":"SUM(T140:T145)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,0]
[null,null,"Hands-On",{"$f":"D146+F146+H146+J146+L146+N146+P146+R146+T146+V146+X146+Z146+AB146+AD146","v":0},"Theory",{"$f":"C146+E146+G146+I146+K146+M146+O146+Q146+S146+U146+W146+Y146+AA146+AC146","v":0}]
[]
[3.5,"Hydraulic Schematics"]
[null,"Identifying symbols",{"$nulls":30},{"$f":"SUM(C150:AD150)","v":0}]
[null,"Demonstrate use of schematics",{"$nulls":30},{"$f":"SUM(C151:AD151)","v":0}]
[null,"Follow fluid flow using schematics",{"$nulls":30},{"$f":"SUM(C152:AD152)","v":0}]
[null,"Total Hours Spent",{"$f":"SUM(C150:C152)","v":0},{"$f":"SUM(D150:D152)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(C153:AD153)","v":0}]
[null,null,"Hands-On",{"$f":"D153+F153+H153+J153+L153+N153+P153+R153+T153+V153+X153+Z153+AB153+AD153","v":0},"Theory",{"$f":"C153+E153+G153+I153+K153+M153+O153+Q153+S153+U153+W153+Y153+AA153+AC153","v":0}]
[]
[3.6,"Diagnostics:Systems and Component Troubleshooting"]
[null,"Use of technical manuals to troubleshoot on selected pieces",{"$nulls":30},{"$f":"SUM(C157:AD157)","v":0}]
[null,"       Engine driven training equipment",{"$nulls":30},0]
[null,"Master the use of all test equipment",{"$nulls":30},0]
[null,"Demonstrate the ability to use schematic diagrams",{"$nulls":30},0]
[null,"Demonstrate the ability to follow an operational check proceedure",{"$nulls":30},0]
[null,"Technical write-up competency",{"$nulls":30},0]
[null,"Total Hours Spent",{"$f":"SUM(C157:C162)","v":0},{"$f":"SUM(D157:D162)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,null,{"$f":"AG118+AG125+AG136+AG146+AG153+AG163","v":0},{"$f":"'Application by Block Classes 2'!AI163","v":0},{"$f":"AI163+AJ163","v":0},{"$f":"AK163/AK366","v":{"$error":"#DIV/0!"}}]
[null,null,"Hands-On",{"$f":"D163+F163+H163+J163+L163+N163+P163+R163+T163+V163+X163+Z163+AB163+AD163","v":0},"Theory",{"$f":"C163+E163+G163+I163+K163+M163+O163+Q163+S163+U163+W163+Y163+AA163+AC163","v":0},{"$nulls":28},{"$f":"AI163/AI366","v":{"$error":"#DIV/0!"}}]
[]
["Section 4","Power Trains - Pgs. 47-59"]
[4.1,"Theory and Operation"]
[null,"Clutches",{"$nulls":30},{"$f":"SUM(C168:AD168)","v":0}]
[null,"Manual transmissions",{"$nulls":30},0]
[null,"Power shift transmission",{"$nulls":30},0]
[null,"Hydrostatic drives",{"$nulls":30},0]
[null,"Torque converters",{"$nulls":30},0]
[null,"Differentials",{"$nulls":30},0]
[null,"Dry brakes",{"$nulls":30},0]
[null,"Wet brakes",{"$nulls":30},0]
[null,"Final drives",{"$nulls":30},0]
[null,"Understanding of gear ratios",{"$nulls":30},0]
[null,"Types of gears",{"$nulls":30},0]
[null,"Anti-friction bearings and plain bearings",{"$nulls":30},0]
[null,"Torque converter; components, operation, testing and troubleshooting",{"$nulls":30},0]
[null,"Manual transmission",{"$nulls":30},0]
[null,"Power shift transmissions",{"$nulls":30},0]
[null,"Clutches",{"$nulls":30},0]
[null,"Electronic-controlled transmissions",{"$nulls":30},0]
[null,"Hydrostatic transmissions",{"$nulls":30},0]
[null,"Total Hours Spent",{"$f":"SUM(C168:C185)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[null,null,"Hands-On",{"$f":"D186+F186+H186+J186+L186+N186+P186+R186+T186+V186+X186+Z186+AB186+AD186","v":0},"Theory",{"$f":"C186+E186+G186+I186+K186+M186+O186+Q186+S186+U186+W186+Y186+AA186+AC186","v":0}]
[]
[4.2,"Drive Shaft Function and Construction"]
[null,"Recognizing components",{"$nulls":30},{"$f":"SUM(C190:AD190)","v":0}]
[null,"Drive line angles and failures",{"$nulls":30},0]
[null,"Differentials",{"$nulls":30},0]
[null,"Final drives",{"$nulls":30},0]
[null,"Perform adjustments to OEM Standards",{"$nulls":30},0]
[null,"Total Hours Spent",{"$f":"SUM(C190:C194)","v":0},{"$f":"SUM(D190:D194)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[null,null,"Hands-On",{"$f":"D195+F195+H195+J195+L195+N195+P195+R195+T195+V195+X195+Z195+AB195+AD195","v":0},"Theory",{"$f":"C195+E195+G195+I195+K195+M195+O195+Q195+S195+U195+W195+Y195+AA195+AC195","v":0}]
[]
[4.3,"Theory of Hydraulic and Pneumatic Braking Systems"]
[null,"Components of hydraulic and pneumatic braking systems",{"$nulls":30},{"$f":"SUM(C199:AD199)","v":0}]
[null,"Hydraulic wheel cylinders",{"$nulls":30},0]
[null,"Master cylinders",{"$nulls":30},0]
[null,"Air system maintenance",{"$nulls":30},0]
[null,"Internal wet disc brakes and brake retarders",{"$nulls":30},0]
[null,"Total Hours Spent",{"$f":"SUM(C199:C203)","v":0},{"$f":"SUM(D199:D203)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[null,null,"Hands-On",{"$f":"D204+F204+H204+J204+L204+N204+P204+R204+T204+V204+X204+Z204+AB204+AD204","v":0},"Theory",{"$f":"C204+E204+G204+I204+K204+M204+O204+Q204+S204+U204+W204+Y204+AA204+AC204","v":0}]
[]
[4.4,"Maintenane Practices"]
[null,"Keeping the work area clean",{"$nulls":30},{"$f":"SUM(C208:AD208)","v":0}]
[null,"Proper flushing procedures",{"$nulls":30},{"$f":"SUM(C209:AD209)","v":0}]
[null,"Scheduled oil sampling",{"$nulls":30},{"$f":"SUM(C210:AD210)","v":0}]
[null,"Total Hours Spent",{"$f":"SUM(C208:C210)","v":0},{"$f":"SUM(D208:D210)","v":0},0,0,0,0,{"$f":"SUM(I208:I210)","v":0},{"$f":"SUM(J208:J210)","v":0},{"$f":"SUM(K208:K210)","v":0},{"$f":"SUM(L208:L210)","v":0},0,0,0,0,{"$f":"SUM(Q208:Q210)","v":0},{"$f":"SUM(R208:R210)","v":0},{"$f":"SUM(S208:S210)","v":0},{"$f":"SUM(T208:T210)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(C211:AD211)","v":0}]
[null,null,"Hands-On",{"$f":"D211+F211+H211+J211+L211+N211+P211+R211+T211+V211+X211+Z211+AB211+AD211","v":0},"Theory",{"$f":"C211+E211+G211+I211+K211+M211+O211+Q211+S211+U211+W211+Y211+AA211+AC211","v":0}]
[]
[4.5,"Power Train Schematics and flow diagrams"]
[null,"Identifying symbols",{"$nulls":30},{"$f":"SUM(C215:AD215)","v":0}]
[null,"Demonstrating use of schematics and flow diagrams",{"$nulls":30},{"$f":"SUM(C216:AD216)","v":0}]
[null,"Total Hours Spent",{"$f":"SUM(C215:C216)","v":0},0,0,0,0,0,{"$f":"SUM(I215:I216)","v":0},{"$f":"SUM(J215:J216)","v":0},{"$f":"SUM(K215:K216)","v":0},{"$f":"SUM(L215:L216)","v":0},0,0,0,0,{"$f":"SUM(Q215:Q216)","v":0},{"$f":"SUM(R215:R216)","v":0},{"$f":"SUM(S215:S216)","v":0},{"$f":"SUM(T215:T216)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(C217:AD217)","v":0}]
[null,null,"Hands-On",{"$f":"D217+F217+H217+J217+L217+N217+P217+R217+T217+V217+X217+Z217+AB217+AD217","v":0},"Theory",{"$f":"C217+E217+G217+I217+K217+M217+O217+Q217+S217+U217+W217+Y217+AA217+AC217","v":0}]
[]
[4.6,"Troubleshooting and failure analysis"]
[null,"Decision making",{"$nulls":30},{"$f":"SUM(C221:AD221)","v":0}]
[null,"Troubleshooting",{"$nulls":30},{"$f":"SUM(C222:AD222)","v":0}]
[null,"Failure analysis",{"$nulls":30},{"$f":"SUM(C223:AD223)","v":0}]
[null,"Technical write-up competency",{"$nulls":30},{"$f":"SUM(C224:AD224)","v":0}]
[null,"Total Hours Spent",{"$f":"SUM(C221:C224)","v":0},{"$f":"SUM(D221:D224)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(C225:AD225)","v":0}]
[null,null,"Hands-On",{"$f":"D225+F225+H225+J225+L225+N225+P225+R225+T225+V225+X225+Z225+AB225+AD225","v":0},"Theory",{"$f":"C225+E225+G225+I225+K225+M225+O225+Q225+S225+U225+W225+Y225+AA225+AC225","v":0}]
[]
[4.7,"Component Rebuild and Analysis"]
[null,"Apply procedures to properly rebuild components",{"$nulls":30},{"$f":"SUM(C229:AD229)","v":0}]
[null,"Remove and replace power train components",{"$nulls":30},{"$f":"SUM(C230:AD230)","v":0}]
[null,"Service publications",{"$nulls":30},{"$f":"SUM(C231:AD231)","v":0}]
[null,"Parts reusability guidelines",{"$nulls":30},{"$f":"SUM(C232:AD232)","v":0}]
[null,"Total Hours Spent",{"$f":"SUM(C229:C232)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(C233:AD233)","v":0},null,{"$f":"AG186+AG195+AG204+AG211+AG217+AG225+AG233","v":0},{"$f":"'Application by Block Classes 2'!AI233","v":0},{"$f":"AI233+AJ233","v":0},{"$f":"AK233/AK366","v":{"$error":"#DIV/0!"}}]
[null,null,"Hands-On",{"$f":"D233+F233+H233+J233+L233+N233+P233+R233+T233+V233+X233+Z233+AB233+AD233","v":0},"Theory",{"$f":"C233+E233+G233+I233+K233+M233+O233+Q233+S233+U233+W233+Y233+AA233+AC233","v":0},{"$nulls":28},{"$f":"AI233/AI366","v":{"$error":"#DIV/0!"}}]
[]
["Section 5","Diesel Engines - Pgs. 61-71"]
[5.1,"Safety"]
[null,"Safety specific to engines application including OSHA regulations",{"$nulls":30},{"$f":"SUM(C238:AD238)","v":0}]
[null,"Total Hours Spent",{"$f":"SUM(C238)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(C239:AD239)","v":0}]
[null,null,"Hands-On",{"$f":"D239+F239+H239+J239+L239+N239+P239+R239+T239+V239+X239+Z239+AB239+AD239","v":0},"Theory",{"$f":"C239+E239+G239+I239+K239+M239+O239+Q239+S239+U239+W239+Y239+AA239+AC239","v":0}]
[]
[5.2,"Identifying and use of basic tools"]
[null,"Care and safety on the proper use of hand tools",{"$nulls":30},{"$f":"SUM(C243:AD243)","v":0}]
[null,"Understanding regulations governing solvents",{"$nulls":30},0]
[null,"Demonstrate all torque and de-torque methods",{"$nulls":30},0]
[null,"Use of metrics",{"$nulls":30},0]
[null,"Use of measuring tools and gauges",{"$nulls":30},0]
[null,"Proper use of technical manuals/computers/laptops",{"$nulls":30},0]
[null,"Total Hours Spent",{"$f":"SUM(C243:C248)","v":0},0,0,0,0,0,{"$f":"SUM(I243:I248)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(U243:U248)","v":0},0,0,0,0,0,{"$f":"SUM(AA243:AA248)","v":0},{"$f":"SUM(AB243:AB248)","v":0},{"$f":"SUM(AC243:AC248)","v":0},{"$f":"SUM(AD243:AD248)","v":0},null,null,0]
[null,null,"Hands-On",{"$f":"D249+F249+H249+J249+L249+N249+P249+R249+T249+V249+X249+Z249+AB249+AD249","v":0},"Theory",{"$f":"C249+E249+G249+I249+K249+M249+O249+Q249+S249+U249+W249+Y249+AA249+AC249","v":0}]
[]
[5.3,"Theory and Operation"]
[null,"Four-stroke cycle; engine theory",{"$nulls":30},{"$f":"SUM(C253:AD253)","v":0}]
[null,"Cooling systems",{"$nulls":30},0]
[null,"Intake/exhaust systems",{"$nulls":30},0]
[null,"Lubrication systems",{"$nulls":30},0]
[null,"Fuel and governing systems",{"$nulls":30},0]
[null,"Emission controls",{"$nulls":30},0]
[null,"Gauges",{"$nulls":30},0]
[null,"Standard to metric conversion",{"$nulls":30},0]
[null,"Total Hours Spent",{"$f":"SUM(C253:C260)","v":0},{"$f":"SUM(D253:D260)","v":0},0,0,0,0,{"$f":"SUM(I253:I260)","v":0},{"$f":"SUM(J253:J260)","v":0},{"$f":"SUM(K253:K260)","v":0},{"$f":"SUM(L253:L260)","v":0},0,0,0,0,{"$f":"SUM(Q253:Q260)","v":0},{"$f":"SUM(R253:R260)","v":0},{"$f":"SUM(S253:S260)","v":0},{"$f":"SUM(T253:T260)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,0]
[null,null,"Hands-On",{"$f":"D261+F261+H261+J261+L261+N261+P261+R261+T261+V261+X261+Z261+AB261+AD261","v":0},"Theory",{"$f":"C261+E261+G261+I261+K261+M261+O261+Q261+S261+U261+W261+Y261+AA261+AC261","v":0}]
[]
[5.4,"Maintenance Practices"]
[null,"Service literature",{"$nulls":30},{"$f":"SUM(C265:AD265)","v":0}]
[null,"Fluid analysis",{"$nulls":30},{"$f":"SUM(C266:AD266)","v":0}]
[null,"Fuel types and grades",{"$nulls":30},{"$f":"SUM(C267:AD267)","v":0}]
[null,"Filter dissection/inspection",{"$nulls":30},{"$f":"SUM(C268:AD268)","v":0}]
[null,"Total Hours Spent",{"$f":"SUM(C265:C268)","v":0},{"$f":"SUM(D265:D268)","v":0},0,0,0,0,{"$f":"SUM(I265:I268)","v":0},{"$f":"SUM(J265:J268)","v":0},{"$f":"SUM(K265:K268)","v":0},{"$f":"SUM(L265:L268)","v":0},0,0,0,0,{"$f":"SUM(Q265:Q268)","v":0},{"$f":"SUM(R265:R268)","v":0},{"$f":"SUM(S265:S268)","v":0},{"$f":"SUM(T265:T268)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(C269:AD269)","v":0}]
[null,null,"Hands-On",{"$f":"D269+F269+H269+J269+L269+N269+P269+R269+T269+V269+X269+Z269+AB269+AD269","v":0},"Theory",{"$f":"C269+E269+G269+I269+K269+M269+O269+Q269+S269+U269+W269+Y269+AA269+AC269","v":0}]
[]
[5.5,"Component Rebuild"]
[null,"Use of service literature",{"$nulls":30},{"$f":"SUM(C273:AD273)","v":0}]
[null,"Cylinder block/head related components",{"$nulls":30},{"$f":"SUM(C274:AD274)","v":0}]
[null,"Parts reusability guidelines",{"$nulls":30},{"$f":"SUM(C275:AD275)","v":0}]
[null,"Total Hours Spent",{"$f":"SUM(C273:C275)","v":0},{"$f":"SUM(D273:D275)","v":0},0,0,0,0,{"$f":"SUM(I273:I275)","v":0},{"$f":"SUM(J273:J275)","v":0},{"$f":"SUM(K273:K275)","v":0},{"$f":"SUM(L273:L275)","v":0},0,0,0,0,{"$f":"SUM(Q273:Q275)","v":0},{"$f":"SUM(R273:R275)","v":0},{"$f":"SUM(S273:S275)","v":0},{"$f":"SUM(T273:T275)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(C276:AD276)","v":0}]
[null,null,"Hands-On",{"$f":"D276+F276+H276+J276+L276+N276+P276+R276+T276+V276+X276+Z276+AB276+AD276","v":0},"Theory",{"$f":"C276+E276+G276+I276+K276+M276+O276+Q276+S276+U276+W276+Y276+AA276+AC276","v":0}]
[]
[5.6,"Engine Subsystem Components"]
[null,"Cooling",{"$nulls":30},{"$f":"SUM(C280:AD280)","v":0}]
[null,"Intake/exhaust",{"$nulls":30},0]
[null,"Lubrication",{"$nulls":30},0]
[null,"Emissions",{"$nulls":30},0]
[null,"Heat exchanger",{"$nulls":30},0]
[null,"Total Hours Spent",{"$f":"SUM(C280:C284)","v":0},{"$f":"SUM(D280:D284)","v":0},0,0,0,0,{"$f":"SUM(I280:I284)","v":0},{"$f":"SUM(J280:J284)","v":0},{"$f":"SUM(K280:K284)","v":0},{"$f":"SUM(L280:L284)","v":0},0,0,0,0,{"$f":"SUM(Q280:Q284)","v":0},{"$f":"SUM(R280:R284)","v":0},{"$f":"SUM(S280:S284)","v":0},{"$f":"SUM(T280:T284)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,0]
[null,null,"Hands-On",{"$f":"D285+F285+H285+J285+L285+N285+P285+R285+T285+V285+X285+Z285+AB285+AD285","v":0},"Theory",{"$f":"C285+E285+G285+I285+K285+M285+O285+Q285+S285+U285+W285+Y285+AA285+AC285","v":0}]
[]
[5.7,"Fuel and Governing Systems"]
[null,"Mechanical",{"$nulls":30},{"$f":"SUM(C289:AD289)","v":0}]
[null,"Hydraulic/servo systems",{"$nulls":30},{"$f":"SUM(C290:AD290)","v":0}]
[null,"Electronic/electric",{"$nulls":30},{"$f":"SUM(C291:AD291)","v":0}]
[null,"Aneroid/smoke controls",{"$nulls":30},{"$f":"SUM(C292:AD292)","v":0}]
[null,"Total Hours Spent",{"$f":"SUM(C289:C292)","v":0},{"$f":"SUM(D289:D292)","v":0},0,0,0,0,{"$f":"SUM(I289:I292)","v":0},{"$f":"SUM(J289:J292)","v":0},{"$f":"SUM(K289:K292)","v":0},{"$f":"SUM(L289:L292)","v":0},0,0,0,0,{"$f":"SUM(Q289:Q292)","v":0},{"$f":"SUM(R289:R292)","v":0},{"$f":"SUM(S289:S292)","v":0},{"$f":"SUM(T289:T292)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(C293:AD293)","v":0}]
[null,null,"Hands-On",{"$f":"D293+F293+H293+J293+L293+N293+P293+R293+T293+V293+X293+Z293+AB293+AD293","v":0},"Theory",{"$f":"C293+E293+G293+I293+K293+M293+O293+Q293+S293+U293+W293+Y293+AA293+AC293","v":0}]
[]
[5.8,"Diagnostics"]
[null,"Troubleshooting",{"$nulls":30},{"$f":"SUM(C297:AD297)","v":0}]
[null,"Failure analysis",{"$nulls":30},{"$f":"SUM(C298:AD298)","v":0}]
[null,"Use of tools ",{"$nulls":30},{"$f":"SUM(C299:AD299)","v":0}]
[null,"Technical write-up competency",{"$nulls":30},{"$f":"SUM(C300:AD300)","v":0}]
[null,"Total Hours Spent",{"$f":"SUM(C297:C300)","v":0},{"$f":"SUM(D297:D300)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(C301:AD301)","v":0},null,{"$f":"AG239+AG249+AG261+AG269+AG276+AG285+AG293+AG301","v":0},{"$f":"+'Application by Block Classes 2'!AI301","v":0},{"$f":"AI301+AJ301","v":0},{"$f":"AK301/AK366","v":{"$error":"#DIV/0!"}}]
[null,null,"Hands-On",{"$f":"D301+F301+H301+J301+L301+N301+P301+R301+T301+V301+X301+Z301+AB301+AD301","v":0},"Theory",{"$f":"C301+E301+G301+I301+K301+M301+O301+Q301+S301+U301+W301+Y301+AA301+AC301","v":0},{"$nulls":28},{"$f":"AI301/AI366","v":{"$error":"#DIV/0!"}}]
[]
["Section 6","Air Conditioning and Heating Systems - Pgs. 74 - 80"]
[6.1,"Fundamental Knowledge"]
[null,"Heat and heat energy",{"$nulls":30},{"$f":"SUM(C306:AD306)","v":0}]
[null,"Pressure/temperature relationship of refrigerants",{"$nulls":30},0]
[null,"Refrigerants and refrigerant characteristics",{"$nulls":30},0]
[null,"Refrigerant oils",{"$nulls":30},0]
[null,"Refrigerant recovery, recycle, reclaim",{"$nulls":30},0]
[null,"Total Hours Spent",{"$f":"SUM(C306:C310)","v":0},{"$f":"SUM(D306:D310)","v":0},0,0,0,0,{"$f":"SUM(I306:I310)","v":0},{"$f":"SUM(J306:J310)","v":0},{"$f":"SUM(K306:K310)","v":0},{"$f":"SUM(L306:L310)","v":0},0,0,0,0,{"$f":"SUM(Q306:Q310)","v":0},{"$f":"SUM(R306:R310)","v":0},{"$f":"SUM(S306:S310)","v":0},{"$f":"SUM(T306:T310)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,0]
[null,null,"Hands-On",{"$f":"D311+F311+H311+J311+L311+N311+P311+R311+T311+V311+X311+Z311+AB311+AD311","v":0},"Theory",{"$f":"C311+E311+G311+I311+K311+M311+O311+Q311+S311+U311+W311+Y311+AA311+AC311","v":0}]
[]
[6.2,"AC System Operation"]
[null,"Basic system components",{"$nulls":30},{"$f":"SUM(C315:AD315)","v":0}]
[null,"Refrigerant cycle",{"$nulls":30},{"$f":"SUM(C316:AD316)","v":0}]
[null,"Refrigerant state",{"$nulls":30},{"$f":"SUM(C317:AD317)","v":0}]
[null,"Total Hours Spent",{"$f":"SUM(C315:C317)","v":0},{"$f":"SUM(D315:D317)","v":0},0,0,0,0,{"$f":"SUM(I315:I317)","v":0},{"$f":"SUM(J315:J317)","v":0},{"$f":"SUM(K315:K317)","v":0},{"$f":"SUM(L315:L317)","v":0},0,0,0,0,{"$f":"SUM(Q315:Q317)","v":0},{"$f":"SUM(R315:R317)","v":0},{"$f":"SUM(S315:S317)","v":0},{"$f":"SUM(T315:T317)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(C318:AD318)","v":0}]
[null,null,"Hands-On",{"$f":"D318+F318+H318+J318+L318+N318+P318+R318+T318+V318+X318+Z318+AB318+AD318","v":0},"Theory",{"$f":"C318+E318+G318+I318+K318+M318+O318+Q318+S318+U318+W318+Y318+AA318+AC318","v":0}]
[]
[6.3,"Servicing AC systems"]
[null,"System identification",{"$nulls":30},{"$f":"SUM(C322:AD322)","v":0}]
[null,"Connecting/disconnecting gauge manifold sets",{"$nulls":30},0]
[null,"System evacuation and dehydration",{"$nulls":30},0]
[null,"Refrigerant recovery and charging",{"$nulls":30},0]
[null,"Adding oil, dye and refrigerants to AC systems",{"$nulls":30},0]
[null,"Total Hours Spent",{"$f":"SUM(C322:C326)","v":0},{"$f":"SUM(D322:D326)","v":0},0,0,0,0,{"$f":"SUM(I322:I326)","v":0},{"$f":"SUM(J322:J326)","v":0},{"$f":"SUM(K322:K326)","v":0},{"$f":"SUM(L322:L326)","v":0},0,0,0,0,{"$f":"SUM(Q322:Q326)","v":0},{"$f":"SUM(R322:R326)","v":0},{"$f":"SUM(S322:S326)","v":0},{"$f":"SUM(T322:T326)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,0]
[null,null,"Hands-On",{"$f":"D327+F327+H327+J327+L327+N327+P327+R327+T327+V327+X327+Z327+AB327+AD327","v":0},"Theory",{"$f":"C327+E327+G327+I327+K327+M327+O327+Q327+S327+U327+W327+Y327+AA327+AC327","v":0}]
[]
[6.4,"Testing, Troubleshooting and Repairing AC systems"]
[null,"Visual inspection of system",{"$nulls":30},{"$f":"SUM(C331:AD331)","v":0}]
[null,"Ability to visually identify coolant capacity",{"$nulls":30},0]
[null,"Identiry switches, valves and fusion plug locations  ",{"$nulls":30},0]
[null,"Interpreting pressure/temperature readings ",{"$nulls":30},0]
[null,"Metering devices and limit switches",{"$nulls":30},0]
[null,"Leak detection",{"$nulls":30},0]
[null,"Component replacement/repair",{"$nulls":30},0]
[null,"Performance testing",{"$nulls":30},0]
[null,"Technical write-up competency",{"$nulls":30},0]
[null,"Total Hours Spent",{"$f":"SUM(C331:C339)","v":0},{"$f":"SUM(D331:D339)","v":0},{"$f":"SUM(E331:E339)","v":0},{"$f":"SUM(F331:F339)","v":0},{"$f":"SUM(G331:G339)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[null,null,"Hands-On",{"$f":"D340+F340+H340+J340+L340+N340+P340+R340+T340+V340+X340+Z340+AB340+AD340","v":0},"Theory",{"$f":"C340+E340+G340+I340+K340+M340+O340+Q340+S340+U340+W340+Y340+AA340+AC340","v":0}]
[]
[6.5,"Heating System Operation"]
[null,"Basic system components ",{"$nulls":30},{"$f":"SUM(C344:AD344)","v":0}]
[null,"Water pumps",{"$nulls":30},{"$f":"SUM(C345:AD345)","v":0}]
[null,"Coolant flow",{"$nulls":30},{"$f":"SUM(C346:AD346)","v":0}]
[null,"Thermostats",{"$nulls":30},{"$f":"SUM(C347:AD347)","v":0}]
[null,"Total Hours Spent",{"$f":"SUM(C344:C347)","v":0},{"$f":"SUM(D344:D347)","v":0},0,0,0,0,{"$f":"SUM(I344:I347)","v":0},{"$f":"SUM(J344:J347)","v":0},{"$f":"SUM(K344:K347)","v":0},{"$f":"SUM(L344:L347)","v":0},0,0,0,0,{"$f":"SUM(Q344:Q347)","v":0},{"$f":"SUM(R344:R347)","v":0},{"$f":"SUM(S344:S347)","v":0},{"$f":"SUM(T344:T347)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(C348:AD348)","v":0}]
[null,null,"Hands-On",{"$f":"D348+F348+H348+J348+L348+N348+P348+R348+T348+V348+X348+Z348+AB348+AD348","v":0},"Theory",{"$f":"C348+E348+G348+I348+K348+M348+O348+Q348+S348+U348+W348+Y348+AA348+AC348","v":0}]
[]
[6.6,"Servicing Heating Systems"]
[null,"Heater core replacement ",{"$nulls":30},{"$f":"SUM(C352:AD352)","v":0}]
[null,"Control valves",{"$nulls":30},0]
[null,"Thermostats",{"$nulls":30},0]
[null,"Component replacement/repair",{"$nulls":30},0]
[null,"Performance testing",{"$nulls":30},0]
[null,"Total Hours Spent",{"$f":"SUM(C352:C356)","v":0},{"$f":"SUM(D352:D356)","v":0},0,0,0,0,{"$f":"SUM(I352:I356)","v":0},{"$f":"SUM(J352:J356)","v":0},{"$f":"SUM(K352:K356)","v":0},{"$f":"SUM(L352:L356)","v":0},0,0,0,0,{"$f":"SUM(Q352:Q356)","v":0},{"$f":"SUM(R352:R356)","v":0},{"$f":"SUM(S352:S356)","v":0},{"$f":"SUM(T352:T356)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,0]
[null,null,"Hands-On",{"$f":"D357+F357+H357+J357+L357+N357+P357+R357+T357+V357+X357+Z357+AB357+AD357","v":0},"Theory",{"$f":"C357+E357+G357+I357+K357+M357+O357+Q357+S357+U357+W357+Y357+AA357+AC357","v":0}]
[]
[6.7,"Pressurized Cabs"]
[null,"Purpose and function of pressurized cab systems",{"$nulls":30},{"$f":"SUM(C361:AD361)","v":0}]
[null,"How to remove, clean, and install cab air filters",{"$nulls":30},{"$f":"SUM(C362:AD362)","v":0}]
[null,"Total Hours Spent",{"$f":"SUM(C361:C362)","v":0},0,0,0,0,0,{"$f":"SUM(I361:I362)","v":0},{"$f":"SUM(J361:J362)","v":0},{"$f":"SUM(K361:K362)","v":0},{"$f":"SUM(L361:L362)","v":0},0,0,0,0,{"$f":"SUM(Q361:Q362)","v":0},{"$f":"SUM(R361:R362)","v":0},{"$f":"SUM(S361:S362)","v":0},{"$f":"SUM(T361:T362)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(C363:AD363)","v":0}]
[null,null,"Hands-On",{"$f":"D363+F363+H363+J363+L363+N363+P363+R363+T363+V363+X363+Z363+AB363+AD363","v":0},"Theory",{"$f":"C363+E363+G363+I363+K363+M363+O363+Q363+S363+U363+W363+Y363+AA363+AC363","v":0},{"$nulls":28},{"$f":"AG311+AG318+AG327+AG340+AG348+AG357+AG363","v":0},{"$f":"+'Application by Block Classes 2'!AI363","v":0},{"$f":"AI364+AJ364","v":0},{"$f":"AK364/AK366","v":{"$error":"#DIV/0!"}}]
[{"$nulls":34},{"$f":"AI364/AI366","v":{"$error":"#DIV/0!"}}]
[null,"TOTALS FOR EACH COLUMN",{"$f":"SUM(C363,C357,C348,C340,C327,C318,C311,C301,C293,C285,C276,C269,C261,C249,C239,C233,C225,C217,C211,C204,C195,C186,C163,C153,C146,C136,C125,C118,C95,C85,C79,C73,C65,C57,C49,C43,C35,C26)","v":0},{"$f":"SUM(D363,D357,D348,D340,D327,D318,D311,D301,D293,D285,D276,D269,D261,D249,D239,D233,D225,D217,D211,D204,D195,D186,D163,D153,D146,D136,D125,D118,D95,D85,D79,D73,D65,D57,D49,D43,D35,D26)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$nulls":4},{"$f":"SUM(C366:AD366)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(AJ11:AJ365)","v":0},{"$f":"SUM(AK11:AK365)","v":0},{"$f":"SUM(AL12:AL364)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"From this Sheet",null,"From Spreadsheet 2"]
[]
[]
[null,"Total Program Hours Theory",{"$f":"C366+E366+G366+I366+K366+M366+O366+Q366+S366+U366+W366+Y366+AA366+AC366","v":0},null,{"$f":"'Application by Block Classes 2'!C370","v":0},null,{"$f":"E371+C371","v":0}]
[null,"Total Program Hours Hands On",{"$f":"D366+F366+H366+J366+L366+N366+P366+R366+T366+V366+X366+Z366+AB366+AD366","v":0},null,{"$f":"'Application by Block Classes 2'!C371","v":0},null,0]
[null,"Total All Hours",{"$f":"C371+C372","v":0},null,{"$f":"'Application by Block Classes 2'!C372","v":0},null,{"$f":"E373+C373","v":0}]

{"sheet":"Application by Block Classes 2","index":2,"n_rows":372,"n_cols":35,"rows_kept":372,"merged":[[0,0,0,1],[0,2,0,9],[0,15,0,17],[0,18,0,25],[0,30,0,34],[1,0,1,1],[1,2,1,9],[1,15,1,17],[1,18,1,25],[2,0,2,1],[2,2,2,9],[2,15,2,17],[2,18,2,25],[3,0,3,1],[3,2,3,9],[3,15,3,17],[3,18,3,25],[4,0,4,1],[4,2,4,3],[4,5,4,9],[5,0,5,34],[6,2,6,29],[6,31,6,33],[7,2,7,3],[7,4,7,5],[7,6,7,7],[7,8,7,9],[7,10,7,11],[7,12,7,13],[7,14,7,15],[7,16,7,17],[7,18,7,19],[7,20,7,21],[7,22,7,23],[7,24,7,25],[7,26,7,27],[7,28,7,29],[7,31,7,33]]}
["SCHOOL NAME:  ",null,{"$f":"IF(Coversheet!L4=\"\",\"\",Coversheet!L4)","v":""},{"$nulls":12},"PROGRAM NAME: ",null,null,{"$f":"IF(Coversheet!L10=\"\",\"\",Coversheet!L10)","v":""},{"$nulls":10},"DATE:",{"$f":"IF(Coversheet!L3=\"\",\"\",Coversheet!L3)","v":""}]
["ADDRESS:  ",null,{"$f":"IF(Coversheet!L5=\"\",\"\",Coversheet!L5)","v":""},{"$nulls":12},"PHONE/FAX:",null,null,{"$f":"IF(Coversheet!L11=\"\",\"\",Coversheet!L11)","v":""}]
["PERSON APPLYING AND TITLE:",null,{"$f":"IF(Coversheet!L6=\"\",\"\",Coversheet!L6)","v":""},{"$nulls":12},"DEPT. CHAIR/HEAD: ",null,null,{"$f":"IF(Coversheet!L12=\"\",\"\",Coversheet!L12)","v":""}]
["DEALER SPONSOR: ",null,{"$f":"IF(Coversheet!L7=\"\",\"\",Coversheet!L7)","v":""},{"$nulls":12},"CONTACT NAME:",null,null,{"$f":"IF(Coversheet!L13=\"\",\"\",Coversheet!L13)","v":""}]
["PHONE/FAX:",null,{"$f":"IF(Coversheet!L8=\"\",\"\",Coversheet!L8)","v":""},null,"EMAIL: ",{"$f":"IF(Coversheet!L9=\"\",\"\",Coversheet!L9)","v":""}]
["AED Accreditation Program Analysis & Application"]
[null,null,"PLEASE NOTE: 1. At the top of each column in the yellow cell fill the the course name or course number for each to be considered.                                                                                                                                                                                                                                                                                                               2. For additional courses, use Tab2 titled Application by Block Classes 2.                                                                                                                                                                                                                                                                                                                                                                                                             3. To make a note next to a row, insert a number in the \"NO. FOR FOOT NOTE\" column AI. ",{"$nulls":31},"NO. FOR FOOT NOTE"]
[null,"Course Names --->"]
[null,null,"Theory","Hands-on","Theory","Hands-on","Theory","Hands-on","Theory","Hands-on","Theory","Hands-on","Theory","Hands-on","Theory","Hands-on","Theory","Hands-on","Theory","Hands-on","Theory","Hands-on","Theory","Hands-on","Theory","Hands-on","Theory","Hands-on","Theory","Hands-on"]
["Section 1","Safety/Administration - Pgs. 14  - 24"]
["1a","Theory and Operation"]
[null,"Use of hand tools",{"$nulls":30},{"$f":"SUM(C12:AD12)","v":0}]
[null,"Use of electric tools",{"$nulls":30},0]
[null,"Use of air tools",{"$nulls":30},0]
[null,"Use of hydraulic tools",{"$nulls":30},0]
[null,"Use of lifting equipment",{"$nulls":30},0]
[null,"Use of various cleaning equipment",{"$nulls":30},0]
[null,"Use of metal cutting and welding equipment",{"$nulls":30},0]
[null,"Use of media type blasting equipment",{"$nulls":30},0]
[null,"Fluid pressure testing equipment",{"$nulls":30},0]
[null,"Environment of service facility",{"$nulls":30},0]
[null,"Machinery operation and identification",{"$nulls":30},0]
[null,"Federal and State OSHA and MSHA mandated regulations",{"$nulls":30},0]
[null,"Shop and in-field practices",{"$nulls":30},0]
[null,"Hazard identification and prevention",{"$nulls":30},0]
[null,"Total Hours Spent",{"$f":"SUM(C12:C25)","v":0},0,0,0,0,0,0,{"$f":"SUM(J10:J25)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[null,null,"Hands-On",{"$f":"D26+F26+H26+J26+L26+N26+P26+R26+T26+V26+X26+Z26+AB26+AD26","v":0},"Theory",{"$f":"C26+E26+G26+I26+K26+M26+O26+Q26+S26+U26+W26+Y26+AA26+AC26","v":0}]
[]
["1b","Adminstrative"]
[null,"comprehend basic academic functions",{"$nulls":30},{"$f":"SUM(C30:AD30)","v":0}]
[null,"utilize industry software and electronic communication systems and reference resources",{"$nulls":30},0]
[null,"demonstrate an awareness of expected company goals and objectives",{"$nulls":30},0]
[null,"define basic business practices",{"$nulls":30},0]
[null,"explain department goals and procedures",{"$nulls":30},0]
[null,"Total Hours Spent",{"$f":"SUM(C30:C34)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,null,{"$f":"AG35+AG26","v":0}]
[null,null,"Hands-On",{"$f":"D35+F35+H35+J35+L35+N35+P35+R35+T35+V35+X35+Z35+AB35+AD35","v":0},"Theory",{"$f":"C35+E35+G35+I35+K35+M35+O35+Q35+S35+U35+W35+Y35+AA35+AC35","v":0},{"$nulls":28},{"$f":"(AG35+AG26)/C372","v":{"$error":"#DIV/0!"}}]
[]
["Section 2","Electronics/Electrical Systems - Pgs. 27- 32"]
[2.1,"Fundamental Knowledge"]
[null,"Atomic structure",{"$nulls":30},{"$f":"SUM(C40:AD40)","v":0}]
[null,"Electron theory of electricity",{"$nulls":30},{"$f":"SUM(C41:AD41)","v":0}]
[null,"Telematics-remote monitoring",{"$nulls":30},{"$f":"SUM(C42:AD42)","v":0}]
[null,"Total Hours Spent",{"$f":"SUM(C40:C42)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(C43:AD43)","v":0}]
[null,null,"Hands-On",{"$f":"D43+F43+H43+J43+L43+N43+P43+R43+T43+V43+X43+Z43+AB43+AD43","v":0},"Theory",{"$f":"C43+E43+G43+I43+K43+M43+O43+Q43+S43+U43+W43+Y43+AA43+AC43","v":0}]
[]
[2.2,"Ohm's Law"]
[null,"Ohm’s Law theory",{"$nulls":30},{"$f":"SUM(C47:AD47)","v":0}]
[null,"applications to series, parallel and series/parallel DC Circuits",{"$nulls":30},{"$f":"SUM(C48:AD48)","v":0}]
[null,"Total Hours Spent",{"$f":"SUM(C47:C48)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(C49:AD49)","v":0}]
[null,null,"Hands-On",{"$f":"D49+F49+H49+J49+L49+N49+P49+R49+T49+V49+X49+Z49+AB49+AD49","v":0},"Theory",{"$f":"C49+E49+G49+I49+K49+M49+O49+Q49+S49+U49+W49+Y49+AA49+AC49","v":0}]
[]
[2.3,"12 and 24 Volt Cranking Systems"]
[null,"Components",{"$nulls":30},{"$f":"SUM(C53:AD53)","v":0}]
[null,"Operation",{"$nulls":30},{"$f":"SUM(C54:AD54)","v":0}]
[null,"Troubleshooting",{"$nulls":30},{"$f":"SUM(C55:AD55)","v":0}]
[null,"Repair",{"$nulls":30},{"$f":"SUM(C56:AD56)","v":0}]
[null,"Total Hours Spent",{"$f":"SUM(C53:C56)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(C57:AD57)","v":0}]
[null,null,"Hands-On",{"$f":"D57+F57+H57+J57+L57+N57+P57+R57+T57+V57+X57+Z57+AB57+AD57","v":0},"Theory",{"$f":"C57+E57+G57+I57+K57+M57+O57+Q57+S57+U57+W57+Y57+AA57+AC57","v":0}]
[]
[2.4,"12 and 24 Volt Charging Systems"]
[null,"Components",{"$nulls":30},{"$f":"SUM(C61:AD61)","v":0}]
[null,"Operation",{"$nulls":30},{"$f":"SUM(C62:AD62)","v":0}]
[null,"Troubleshooting",{"$nulls":30},{"$f":"SUM(C63:AD63)","v":0}]
[null,"Repair",{"$nulls":30},{"$f":"SUM(C64:AD64)","v":0}]
[null,"Total Hours Spent",{"$f":"SUM(C61:C64)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(C65:AD65)","v":0}]
[null,null,"Hands-On",{"$f":"D65+F65+H65+J65+L65+N65+P65+R65+T65+V65+X65+Z65+AB65+AD65","v":0},"Theory",{"$f":"C65+E65+G65+I65+K65+M65+O65+Q65+S65+U65+W65+Y65+AA65+AC65","v":0}]
[]
[2.5,"Lighting, Accessory and Control Systems"]
[null,"Components",{"$nulls":30},{"$f":"SUM(C69:AD69)","v":0}]
[null,"Operation",{"$nulls":30},{"$f":"SUM(C70:AD70)","v":0}]
[null,"Troubleshooting",{"$nulls":30},{"$f":"SUM(C71:AD71)","v":0}]
[null,"Repair",{"$nulls":30},{"$f":"SUM(C72:AD72)","v":0}]
[null,"Total Hours Spent",{"$f":"SUM(C69:C72)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(C73:AD73)","v":0}]
[null,null,"Hands-On",{"$f":"D73+F73+H73+J73+L73+N73+P73+R73+T73+V73+X73+Z73+AB73+AD73","v":0},"Theory",{"$f":"C73+E73+G73+I73+K73+M73+O73+Q73+S73+U73+W73+Y73+AA73+AC73","v":0}]
[]
[2.6,"Electrical Schematics/Diagrams"]
[null,"How to read schematics/diagrams",{"$nulls":30},{"$f":"SUM(C77:AD77)","v":0}]
[null,"How to use schematics/diagrams",{"$nulls":30},{"$f":"SUM(C78:AD78)","v":0}]
[null,"Total Hours Spent",{"$f":"SUM(C77:C78)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(C79:AD79)","v":0}]
[null,null,"Hands-On",{"$f":"D79+F79+H79+J79+L79+N79+P79+R79+T79+V79+X79+Z79+AB79+AD79","v":0},"Theory",{"$f":"C79+E79+G79+I79+K79+M79+O79+Q79+S79+U79+W79+Y79+AA79+AC79","v":0}]
[]
[2.7,"SAE Computer CAN-BUSS Standards"]
[null,"Understand communication standards",{"$nulls":30},{"$f":"SUM(C83:AD83)","v":0}]
[null,"Understand published error codes per SAE standards",{"$nulls":30},{"$f":"SUM(C84:AD84)","v":0}]
[null,"Total Hours Spent",{"$f":"SUM(C83:C84)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(C85:AD85)","v":0}]
[null,null,"Hands-On",{"$f":"D85+F85+H85+J85+L85+N85+P85+R85+T85+V85+X85+Z85+AB85+AD85","v":0},"Theory",{"$f":"C85+E85+G85+I85+K85+M85+O85+Q85+S85+U85+W85+Y85+AA85+AC85","v":0}]
[]
[2.8,"Diagnostics"]
[null,"Failure analysis on a required school owned engine driven simulator or machine",{"$nulls":30},{"$f":"SUM(C89:AD89)","v":0}]
[null,"Mastering use of all test equipment",{"$nulls":30},0]
[null,"Use of technical manuals",{"$nulls":30},0]
[null,"Use of schematic diagrams",{"$nulls":30},0]
[null,"Use of an interactive equipment diagnostic program",{"$nulls":30},0]
[null,"Demonstrate technical write-up competency",{"$nulls":30},0]
[null,"Total Hours Spent",{"$f":"SUM(C89:C94)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,null,{"$f":"AG95+AG85+AG79+AG73+AG65+AG57+AG49+AG43","v":0}]
[null,null,"Hands-On",{"$f":"D95+F95+H95+J95+L95+N95+P95+R95+T95+V95+X95+Z95+AB95+AD95","v":0},"Theory",{"$f":"C95+E95+G95+I95+K95+M95+O95+Q95+S95+U95+W95+Y95+AA95+AC95","v":0},{"$nulls":28},{"$f":"(AG95+AG85+AG79+AG73+AG65+AG57+AG49+AG43)/C372","v":{"$error":"#DIV/0!"}}]
[]
["Section 3","Hydraulics/Hydrostatics  - Pgs. 34 - 45"]
[3.1,"Theory and Operation of Hydraulics and Hydrostatics"]
[null,"Learn basic hydraulic principles",{"$nulls":30},{"$f":"SUM(C100:AD100)","v":0}]
[null,"Understand the difference between open and closed center systems",{"$nulls":30},0]
[null,"Applications of hydraulic systems",{"$nulls":30},0]
[null,"Basic hydrostatic principles and systems",{"$nulls":30},0]
[null,"The difference between hydrostatics & hydrodynamics ",{"$nulls":30},0]
[null,"The difference between the various displacement pumps",{"$nulls":30},0]
[null,"Identify various pumps, parts and operation",{"$nulls":30},0]
[null,"Identifying types of swash plate control",{"$nulls":30},{"$f":"SUM(C107:AD107)","v":0}]
[null,"The difference between fixed variable displacement and 2 speed motors",{"$nulls":30},0]
[null,"Identify various pump motors and operation of each; gear, vane, radial and axial piston motors and gerotors.",{"$nulls":30},0]
[null,"Function and uses electro-hydraulic valves, control systems",{"$nulls":30},0]
[null,"Function and use of types of hydraulic valves; pressure, control and volume",{"$nulls":30},0]
[null,"electro-hydraulics valves and control systems",{"$nulls":30},0]
[null,"Use of pressure control valves",{"$nulls":30},0]
[null,"Use of directional control valves",{"$nulls":30},0]
[null,"Use of volume control valves",{"$nulls":30},0]
[null,"Cylinder identification and operation",{"$nulls":30},0]
[null,"accumulator identification and operation",{"$nulls":30},0]
[null,"Total Hours Spent",{"$f":"SUM(C100:C117)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[null,null,"Hands-On",{"$f":"D118+F118+H118+J118+L118+N118+P118+R118+T118+V118+X118+Z118+AB118+AD118","v":0},"Theory",{"$f":"C118+E118+G118+I118+K118+M118+O118+Q118+S118+U118+W118+Y118+AA118+AC118","v":0}]
[]
[3.2,"Fluids, Transfer Components and Filtering"]
[null,"Know the function of hoses",{"$nulls":30},{"$f":"SUM(C122:AD122)","v":0}]
[null,"Knowledge and understanding of fittings",{"$nulls":30},{"$f":"SUM(C123:AD123)","v":0}]
[null,"Know the various use of filters",{"$nulls":30},{"$f":"SUM(C124:AD124)","v":0}]
[null,"Total Hours Spent",{"$f":"SUM(C122:C124)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(C125:AD125)","v":0}]
[null,null,"Hands-On",{"$f":"D125+F125+H125+J125+L125+N125+P125+R125+T125+V125+X125+Z125+AB125+AD125","v":0},"Theory",{"$f":"C125+E125+G125+I125+K125+M125+O125+Q125+S125+U125+W125+Y125+AA125+AC125","v":0}]
[]
[3.3,"Maintenance Procedures"]
[null,"Fluid - ISO cleanliness codes",{"$nulls":30},{"$f":"SUM(C129:AD129)","v":0}]
[null,"Proper flushing procedures",{"$nulls":30},0]
[null,"Prevening leaks and overheating",{"$nulls":30},0]
[null,"Identify worn or defective hoses",{"$nulls":30},0]
[null,"Various oil analysis",{"$nulls":30},0]
[null,"Various types of seals and gasket materials",{"$nulls":30},0]
[null,"Periodic maintenance & safety proceedures",{"$nulls":30},0]
[null,"Total Hours Spent",{"$f":"SUM(C129:C135)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[null,null,"Hands-On",{"$f":"D136+F136+H136+J136+L136+N136+P136+R136+T136+V136+X136+Z136+AB136+AD136","v":0},"Theory",{"$f":"C136+E136+G136+I136+K136+M136+O136+Q136+S136+U136+W136+Y136+AA136+AC136","v":0}]
[]
[3.4,"Hydraulic Component Rebuild and Replacement"]
[null,"Pumps",{"$nulls":30},{"$f":"SUM(C140:AD140)","v":0}]
[null,"Motors",{"$nulls":30},0]
[null,"Valves",{"$nulls":30},0]
[null,"Cylinders",{"$nulls":30},0]
[null,"Accumulators",{"$nulls":30},0]
[null,"Safety Practices",{"$nulls":30},0]
[null,"Total Hours Spent",{"$f":"SUM(C140:C145)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[null,null,"Hands-On",{"$f":"D146+F146+H146+J146+L146+N146+P146+R146+T146+V146+X146+Z146+AB146+AD146","v":0},"Theory",{"$f":"C146+E146+G146+I146+K146+M146+O146+Q146+S146+U146+W146+Y146+AA146+AC146","v":0}]
[]
[3.5,"Hydraulic Schematics"]
[null,"Identifying symbols",{"$nulls":30},{"$f":"SUM(C150:AD150)","v":0}]
[null,"Demonstrate use of schematics",{"$nulls":30},{"$f":"SUM(C151:AD151)","v":0}]
[null,"Follow fluid flow using schematics",{"$nulls":30},{"$f":"SUM(C152:AD152)","v":0}]
[null,"Total Hours Spent",{"$f":"SUM(C150:C152)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(C153:AD153)","v":0}]
[null,null,"Hands-On",{"$f":"D153+F153+H153+J153+L153+N153+P153+R153+T153+V153+X153+Z153+AB153+AD153","v":0},"Theory",{"$f":"C153+E153+G153+I153+K153+M153+O153+Q153+S153+U153+W153+Y153+AA153+AC153","v":0}]
[]
[3.6,"Diagnostics:Systems and Component Troubleshooting"]
[null,"Use of technical manuals to troubleshoot on selected pieces",{"$nulls":30},{"$f":"SUM(C157:AD157)","v":0}]
[null,"       Engine driven training equipment",{"$nulls":30},0]
[null,"Master the use of all test equipment",{"$nulls":30},0]
[null,"Demonstrate the ability to use schematic diagrams",{"$nulls":30},0]
[null,"Demonstrate the ability to follow an operational check proceedure",{"$nulls":30},0]
[null,"Technical write-up competency",{"$nulls":30},0]
[null,"Total Hours Spent",{"$f":"SUM(C157:C162)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,null,{"$f":"AG163+AG153+AG146+AG136+AG125+AG118","v":0}]
[null,null,"Hands-On",{"$f":"D163+F163+H163+J163+L163+N163+P163+R163+T163+V163+X163+Z163+AB163+AD163","v":0},"Theory",{"$f":"C163+E163+G163+I163+K163+M163+O163+Q163+S163+U163+W163+Y163+AA163+AC163","v":0},{"$nulls":28},{"$f":"(AG163+AG153+AG146+AG136+AG125+AG118)/C372","v":{"$error":"#DIV/0!"}}]
[]
["Section 4","Power Trains - Pgs. 47-59"]
[4.1,"Theory and Operation"]
[null,"Clutches",{"$nulls":30},{"$f":"SUM(C168:AD168)","v":0}]
[null,"Manual transmissions",{"$nulls":30},0]
[null,"Power shift transmission",{"$nulls":30},0]
[null,"Hydrostatic drives",{"$nulls":30},0]
[null,"Torque converters",{"$nulls":30},0]
[null,"Differentials",{"$nulls":30},0]
[null,"Dry brakes",{"$nulls":30},0]
[null,"Wet brakes",{"$nulls":30},0]
[null,"Final drives",{"$nulls":30},0]
[null,"Understanding of gear ratios",{"$nulls":30},0]
[null,"Types of gears",{"$nulls":30},0]
[null,"Anti-friction bearings and plain bearings",{"$nulls":30},0]
[null,"Torque converter; components, operation, testing and troubleshooting",{"$nulls":30},0]
[null,"Manual transmission",{"$nulls":30},0]
[null,"Power shift transmissions",{"$nulls":30},0]
[null,"Clutches",{"$nulls":30},0]
[null,"Electronic-controlled transmissions",{"$nulls":30},0]
[null,"Hydrostatic transmissions",{"$nulls":30},0]
[null,"Total Hours Spent",{"$f":"SUM(C168:C185)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[null,null,"Hands-On",{"$f":"D186+F186+H186+J186+L186+N186+P186+R186+T186+V186+X186+Z186+AB186+AD186","v":0},"Theory",{"$f":"C186+E186+G186+I186+K186+M186+O186+Q186+S186+U186+W186+Y186+AA186+AC186","v":0}]
[]
[4.2,"Drive Shaft Function and Construction"]
[null,"Recognizing components",{"$nulls":30},{"$f":"SUM(C190:AD190)","v":0}]
[null,"Drive line angles and failures",{"$nulls":30},0]
[null,"Differentials",{"$nulls":30},0]
[null,"Final drives",{"$nulls":30},0]
[null,"Perform adjustments to OEM Standards",{"$nulls":30},0]
[null,"Total Hours Spent",{"$f":"SUM(C190:C194)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[null,null,"Hands-On",{"$f":"D195+F195+H195+J195+L195+N195+P195+R195+T195+V195+X195+Z195+AB195+AD195","v":0},"Theory",{"$f":"C195+E195+G195+I195+K195+M195+O195+Q195+S195+U195+W195+Y195+AA195+AC195","v":0}]
[]
[4.3,"Theory of Hydraulic and Pneumatic Braking Systems"]
[null,"Components of hydraulic and pneumatic braking systems",{"$nulls":30},{"$f":"SUM(C199:AD199)","v":0}]
[null,"Hydraulic wheel cylinders",{"$nulls":30},0]
[null,"Master cylinders",{"$nulls":30},0]
[null,"Air system maintenance",{"$nulls":30},0]
[null,"Internal wet disc brakes and brake retarders",{"$nulls":30},0]
[null,"Total Hours Spent",{"$f":"SUM(C199:C203)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[null,null,"Hands-On",{"$f":"D204+F204+H204+J204+L204+N204+P204+R204+T204+V204+X204+Z204+AB204+AD204","v":0},"Theory",{"$f":"C204+E204+G204+I204+K204+M204+O204+Q204+S204+U204+W204+Y204+AA204+AC204","v":0}]
[]
[4.4,"Maintenane Practices"]
[null,"Keeping the work area clean",{"$nulls":30},{"$f":"SUM(C208:AD208)","v":0}]
[null,"Proper flushing procedures",{"$nulls":30},{"$f":"SUM(C209:AD209)","v":0}]
[null,"Scheduled oil sampling",{"$nulls":30},{"$f":"SUM(C210:AD210)","v":0}]
[null,"Total Hours Spent",{"$f":"SUM(C208:C210)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(C211:AD211)","v":0}]
[null,null,"Hands-On",{"$f":"D211+F211+H211+J211+L211+N211+P211+R211+T211+V211+X211+Z211+AB211+AD211","v":0},"Theory",{"$f":"C211+E211+G211+I211+K211+M211+O211+Q211+S211+U211+W211+Y211+AA211+AC211","v":0}]
[]
[4.5,"Power Train Schematics and flow diagrams"]
[null,"Identifying symbols",{"$nulls":30},{"$f":"SUM(C215:AD215)","v":0}]
[null,"Demonstrating use of schematics and flow diagrams",{"$nulls":30},{"$f":"SUM(C216:AD216)","v":0}]
[null,"Total Hours Spent",{"$f":"SUM(C215:C216)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(C217:AD217)","v":0}]
[null,null,"Hands-On",{"$f":"D217+F217+H217+J217+L217+N217+P217+R217+T217+V217+X217+Z217+AB217+AD217","v":0},"Theory",{"$f":"C217+E217+G217+I217+K217+M217+O217+Q217+S217+U217+W217+Y217+AA217+AC217","v":0}]
[]
[4.6,"Troubleshooting and failure analysis"]
[null,"Decision making",{"$nulls":30},{"$f":"SUM(C221:AD221)","v":0}]
[null,"Troubleshooting",{"$nulls":30},{"$f":"SUM(C222:AD222)","v":0}]
[null,"Failure analysis",{"$nulls":30},{"$f":"SUM(C223:AD223)","v":0}]
[null,"Technical write-up competency",{"$nulls":30},{"$f":"SUM(C224:AD224)","v":0}]
[null,"Total Hours Spent",{"$f":"SUM(C221:C224)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(C225:AD225)","v":0}]
[null,null,"Hands-On",{"$f":"D225+F225+H225+J225+L225+N225+P225+R225+T225+V225+X225+Z225+AB225+AD225","v":0},"Theory",{"$f":"C225+E225+G225+I225+K225+M225+O225+Q225+S225+U225+W225+Y225+AA225+AC225","v":0}]
[]
[4.7,"Component Rebuild and Analysis"]
[null,"Apply procedures to properly rebuild components",{"$nulls":30},{"$f":"SUM(C229:AD229)","v":0}]
[null,"Remove and replace power train components",{"$nulls":30},{"$f":"SUM(C230:AD230)","v":0}]
[null,"Service publications",{"$nulls":30},{"$f":"SUM(C231:AD231)","v":0}]
[null,"Parts reusability guidelines",{"$nulls":30},{"$f":"SUM(C232:AD232)","v":0}]
[null,"Total Hours Spent",{"$f":"SUM(C229:C232)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(C233:AD233)","v":0},null,{"$f":"AG233+AG225+AG217+AG211+AG204+AG195+AG186","v":0}]
[null,null,"Hands-On",{"$f":"D233+F233+H233+J233+L233+N233+P233+R233+T233+V233+X233+Z233+AB233+AD233","v":0},"Theory",{"$f":"C233+E233+G233+I233+K233+M233+O233+Q233+S233+U233+W233+Y233+AA233+AC233","v":0},{"$nulls":28},{"$f":"(AG233+AG225+AG217+AG211+AG204+AG195+AG186)/C372","v":{"$error":"#DIV/0!"}}]
[]
["Section 5","Diesel Engines - Pgs. 61-71"]
[5.1,"Safety"]
[null,"Safety specific to engines application including OSHA regulations",{"$nulls":30},{"$f":"SUM(C238:AD238)","v":0}]
[null,"Total Hours Spent",{"$f":"SUM(C238)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(C239:AD239)","v":0}]
[null,null,"Hands-On",{"$f":"D239+F239+H239+J239+L239+N239+P239+R239+T239+V239+X239+Z239+AB239+AD239","v":0},"Theory",{"$f":"C239+E239+G239+I239+K239+M239+O239+Q239+S239+U239+W239+Y239+AA239+AC239","v":0}]
[]
[5.2,"Identifying and use of basic tools"]
[null,"Care and safety on the proper use of hand tools",{"$nulls":30},{"$f":"SUM(C243:AD243)","v":0}]
[null,"Understanding regulations governing solvents",{"$nulls":30},0]
[null,"Demonstrate all torque and de-torque methods",{"$nulls":30},0]
[null,"Use of metrics",{"$nulls":30},0]
[null,"Use of measuring tools and gauges",{"$nulls":30},0]
[null,"Proper use of technical manuals/computers/laptops",{"$nulls":30},0]
[null,"Total Hours Spent",{"$f":"SUM(C243:C248)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[null,null,"Hands-On",{"$f":"D249+F249+H249+J249+L249+N249+P249+R249+T249+V249+X249+Z249+AB249+AD249","v":0},"Theory",{"$f":"C249+E249+G249+I249+K249+M249+O249+Q249+S249+U249+W249+Y249+AA249+AC249","v":0}]
[]
[5.3,"Theory and Operation"]
[null,"Four-stroke cycle; engine theory",{"$nulls":30},{"$f":"SUM(C253:AD253)","v":0}]
[null,"Cooling systems",{"$nulls":30},0]
[null,"Intake/exhaust systems",{"$nulls":30},0]
[null,"Lubrication systems",{"$nulls":30},0]
[null,"Fuel and governing systems",{"$nulls":30},0]
[null,"Emission controls",{"$nulls":30},0]
[null,"Gauges",{"$nulls":30},0]
[null,"Standard to metric conversion",{"$nulls":30},0]
[null,"Total Hours Spent",{"$f":"SUM(C253:C260)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[null,null,"Hands-On",{"$f":"D261+F261+H261+J261+L261+N261+P261+R261+T261+V261+X261+Z261+AB261+AD261","v":0},"Theory",{"$f":"C261+E261+G261+I261+K261+M261+O261+Q261+S261+U261+W261+Y261+AA261+AC261","v":0}]
[]
[5.4,"Maintenance Practices"]
[null,"Service literature",{"$nulls":30},{"$f":"SUM(C265:AD265)","v":0}]
[null,"Fluid analysis",{"$nulls":30},{"$f":"SUM(C266:AD266)","v":0}]
[null,"Fuel types and grades",{"$nulls":30},{"$f":"SUM(C267:AD267)","v":0}]
[null,"Filter dissection/inspection",{"$nulls":30},{"$f":"SUM(C268:AD268)","v":0}]
[null,"Total Hours Spent",{"$f":"SUM(C265:C268)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(C269:AD269)","v":0}]
[null,null,"Hands-On",{"$f":"D269+F269+H269+J269+L269+N269+P269+R269+T269+V269+X269+Z269+AB269+AD269","v":0},"Theory",{"$f":"C269+E269+G269+I269+K269+M269+O269+Q269+S269+U269+W269+Y269+AA269+AC269","v":0}]
[]
[5.5,"Component Rebuild"]
[null,"Use of service literature",{"$nulls":30},{"$f":"SUM(C273:AD273)","v":0}]
[null,"Cylinder block/head related components",{"$nulls":30},{"$f":"SUM(C274:AD274)","v":0}]
[null,"Parts reusability guidelines",{"$nulls":30},{"$f":"SUM(C275:AD275)","v":0}]
[null,"Total Hours Spent",{"$f":"SUM(C273:C275)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(C276:AD276)","v":0}]
[null,null,"Hands-On",{"$f":"D276+F276+H276+J276+L276+N276+P276+R276+T276+V276+X276+Z276+AB276+AD276","v":0},"Theory",{"$f":"C276+E276+G276+I276+K276+M276+O276+Q276+S276+U276+W276+Y276+AA276+AC276","v":0}]
[]
[5.6,"Engine Subsystem Components"]
[null,"Cooling",{"$nulls":30},{"$f":"SUM(C280:AD280)","v":0}]
[null,"Intake/exhaust",{"$nulls":30},0]
[null,"Lubrication",{"$nulls":30},0]
[null,"Emissions",{"$nulls":30},0]
[null,"Heat exchanger",{"$nulls":30},0]
[null,"Total Hours Spent",{"$f":"SUM(C280:C284)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[null,null,"Hands-On",{"$f":"D285+F285+H285+J285+L285+N285+P285+R285+T285+V285+X285+Z285+AB285+AD285","v":0},"Theory",{"$f":"C285+E285+G285+I285+K285+M285+O285+Q285+S285+U285+W285+Y285+AA285+AC285","v":0}]
[]
[5.7,"Fuel and Governing Systems"]
[null,"Mechanical",{"$nulls":30},{"$f":"SUM(C289:AD289)","v":0}]
[null,"Hydraulic/servo systems",{"$nulls":30},{"$f":"SUM(C290:AD290)","v":0}]
[null,"Electronic/electric",{"$nulls":30},{"$f":"SUM(C291:AD291)","v":0}]
[null,"Aneroid/smoke controls",{"$nulls":30},{"$f":"SUM(C292:AD292)","v":0}]
[null,"Total Hours Spent",{"$f":"SUM(C289:C292)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(C293:AD293)","v":0}]
[null,null,"Hands-On",{"$f":"D293+F293+H293+J293+L293+N293+P293+R293+T293+V293+X293+Z293+AB293+AD293","v":0},"Theory",{"$f":"C293+E293+G293+I293+K293+M293+O293+Q293+S293+U293+W293+Y293+AA293+AC293","v":0}]
[]
[5.8,"Diagnostics"]
[null,"Troubleshooting",{"$nulls":30},{"$f":"SUM(C297:AD297)","v":0}]
[null,"Failure analysis",{"$nulls":30},{"$f":"SUM(C298:AD298)","v":0}]
[null,"Use of tools ",{"$nulls":30},{"$f":"SUM(C299:AD299)","v":0}]
[null,"Technical write-up competency",{"$nulls":30},{"$f":"SUM(C300:AD300)","v":0}]
[null,"Total Hours Spent",{"$f":"SUM(C297:C300)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(C301:AD301)","v":0},null,{"$f":"AG301+AG293+AG285+AG276+AG269+AG261+AG239+AG249","v":0}]
[null,null,"Hands-On",{"$f":"D301+F301+H301+J301+L301+N301+P301+R301+T301+V301+X301+Z301+AB301+AD301","v":0},"Theory",{"$f":"C301+E301+G301+I301+K301+M301+O301+Q301+S301+U301+W301+Y301+AA301+AC301","v":0},{"$nulls":28},{"$f":"(AG301+AG293+AG285+AG276+AG269+AG261++AG239+AG249)/C372","v":{"$error":"#DIV/0!"}}]
[]
["Section 6","Air Conditioning and Heating Systems - Pgs. 74 - 80"]
[6.1,"Fundamental Knowledge"]
[null,"Heat and heat energy",{"$nulls":30},{"$f":"SUM(C306:AD306)","v":0}]
[null,"Pressure/temperature relationship of refrigerants",{"$nulls":30},0]
[null,"Refrigerants and refrigerant characteristics",{"$nulls":30},0]
[null,"Refrigerant oils",{"$nulls":30},0]
[null,"Refrigerant recovery, recycle, reclaim",{"$nulls":30},0]
[null,"Total Hours Spent",{"$f":"SUM(C306:C310)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[null,null,"Hands-On",{"$f":"D311+F311+H311+J311+L311+N311+P311+R311+T311+V311+X311+Z311+AB311+AD311","v":0},"Theory",{"$f":"C311+E311+G311+I311+K311+M311+O311+Q311+S311+U311+W311+Y311+AA311+AC311","v":0}]
[]
[6.2,"AC System Operation"]
[null,"Basic system components",{"$nulls":30},{"$f":"SUM(C315:AD315)","v":0}]
[null,"Refrigerant cycle",{"$nulls":30},{"$f":"SUM(C316:AD316)","v":0}]
[null,"Refrigerant state",{"$nulls":30},{"$f":"SUM(C317:AD317)","v":0}]
[null,"Total Hours Spent",{"$f":"SUM(C315:C317)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(C318:AD318)","v":0}]
[null,null,"Hands-On",{"$f":"D318+F318+H318+J318+L318+N318+P318+R318+T318+V318+X318+Z318+AB318+AD318","v":0},"Theory",{"$f":"C318+E318+G318+I318+K318+M318+O318+Q318+S318+U318+W318+Y318+AA318+AC318","v":0}]
[]
[6.3,"Servicing AC systems"]
[null,"System identification",{"$nulls":30},{"$f":"SUM(C322:AD322)","v":0}]
[null,"Connecting/disconnecting gauge manifold sets",{"$nulls":30},0]
[null,"System evacuation and dehydration",{"$nulls":30},0]
[null,"Refrigerant recovery and charging",{"$nulls":30},0]
[null,"Adding oil, dye and refrigerants to AC systems",{"$nulls":30},0]
[null,"Total Hours Spent",{"$f":"SUM(C322:C326)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[null,null,"Hands-On",{"$f":"D327+F327+H327+J327+L327+N327+P327+R327+T327+V327+X327+Z327+AB327+AD327","v":0},"Theory",{"$f":"C327+E327+G327+I327+K327+M327+O327+Q327+S327+U327+W327+Y327+AA327+AC327","v":0}]
[]
[6.4,"Testing, Troubleshooting and Repairing AC systems"]
[null,"Visual inspection of system",{"$nulls":30},{"$f":"SUM(C331:AD331)","v":0}]
[null,"Ability to visually identify coolant capacity",{"$nulls":30},0]
[null,"Identiry switches, valves and fusion plug locations  ",{"$nulls":30},0]
[null,"Interpreting pressure/temperature readings ",{"$nulls":30},0]
[null,"Metering devices and limit switches",{"$nulls":30},0]
[null,"Leak detection",{"$nulls":30},0]
[null,"Component replacement/repair",{"$nulls":30},0]
[null,"Performance testing",{"$nulls":30},0]
[null,"Technical write-up competency",{"$nulls":30},0]
[null,"Total Hours Spent",{"$f":"SUM(C331:C339)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[null,null,"Hands-On",{"$f":"D340+F340+H340+J340+L340+N340+P340+R340+T340+V340+X340+Z340+AB340+AD340","v":0},"Theory",{"$f":"C340+E340+G340+I340+K340+M340+O340+Q340+S340+U340+W340+Y340+AA340+AC340","v":0}]
[]
[6.5,"Heating System Operation"]
[null,"Basic system components ",{"$nulls":30},{"$f":"SUM(C344:AD344)","v":0}]
[null,"Water pumps",{"$nulls":30},{"$f":"SUM(C345:AD345)","v":0}]
[null,"Coolant flow",{"$nulls":30},{"$f":"SUM(C346:AD346)","v":0}]
[null,"Thermostats",{"$nulls":30},{"$f":"SUM(C347:AD347)","v":0}]
[null,"Total Hours Spent",{"$f":"SUM(C344:C347)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(C348:AD348)","v":0}]
[null,null,"Hands-On",{"$f":"D348+F348+H348+J348+L348+N348+P348+R348+T348+V348+X348+Z348+AB348+AD348","v":0},"Theory",{"$f":"C348+E348+G348+I348+K348+M348+O348+Q348+S348+U348+W348+Y348+AA348+AC348","v":0}]
[]
[6.6,"Servicing Heating Systems"]
[null,"Heater core replacement ",{"$nulls":30},{"$f":"SUM(C352:AD352)","v":0}]
[null,"Control valves",{"$nulls":30},0]
[null,"Thermostats",{"$nulls":30},0]
[null,"Component replacement/repair",{"$nulls":30},0]
[null,"Performance testing",{"$nulls":30},0]
[null,"Total Hours Spent",{"$f":"SUM(C352:C356)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[null,null,"Hands-On",{"$f":"D357+F357+H357+J357+L357+N357+P357+R357+T357+V357+X357+Z357+AB357+AD357","v":0},"Theory",{"$f":"C357+E357+G357+I357+K357+M357+O357+Q357+S357+U357+W357+Y357+AA357+AC357","v":0}]
[]
[6.7,"Pressurized Cabs"]
[null,"Purpose and function of pressurized cab systems",{"$nulls":30},{"$f":"SUM(C361:AD361)","v":0}]
[null,"How to remove, clean, and install cab air filters",{"$nulls":30},{"$f":"SUM(C362:AD362)","v":0}]
[null,"Total Hours Spent",{"$f":"SUM(C361:C362)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(C363:AD363)","v":0},null,{"$f":"AG363+AG357+AG348+AG340+AG318+AG311+AG327","v":0}]
[null,null,"Hands-On",{"$f":"D363+F363+H363+J363+L363+N363+P363+R363+T363+V363+X363+Z363+AB363+AD363","v":0},"Theory",{"$f":"C363+E363+G363+I363+K363+M363+O363+Q363+S363+U363+W363+Y363+AA363+AC363","v":0},{"$nulls":28},{"$f":"(AG363+AG357+AG348+AG340+AG318+AG311+AG327)/C372","v":{"$error":"#DIV/0!"}}]
[]
[null,"TOTALS FOR EACH COLUMN",{"$f":"SUM(C363,C357,C348,C340,C327,C318,C311,C301,C293,C285,C276,C269,C261,C249,C239,C233,C225,C217,C211,C204,C195,C186,C163,C153,C146,C136,C125,C118,C95,C85,C79,C73,C65,C57,C49,C43,C35,C26)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$nulls":4},{"$f":"SUM(C366:AD366)","v":0}]
[]
[]
[]
[null,"Total Program Hours Theory",{"$f":"C366+E366+G366+I366+K366+M366+O366+Q366+S366+U366+W366+Y366+AA366+AC366","v":0}]
[null,"Total Program Hours Hands On",{"$f":"D366+F366+H366+J366+L366+N366+P366+R366+T366+V366+X366+Z366+AB366+AD366","v":0}]
[null,"Total All Hours",{"$f":"SUM(C370:C371)","v":0}]