{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["MEL","Types"],"not_rendered":{"defined_names":1,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"MEL","index":0,"n_rows":209,"n_cols":17,"rows_kept":209,"merged":[[0,0,0,15],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,8,2,8],[1,9,2,9],[1,10,2,10],[1,11,2,14],[1,15,2,15],[27,0,27,15],[28,11,28,14],[53,0,53,15],[54,11,54,14],[79,0,79,15],[80,11,80,14],[105,0,105,15],[106,11,106,14],[131,0,131,15],[132,11,132,14],[157,0,157,15],[158,11,158,14],[183,0,183,15],[184,11,184,14]]}
["2019-01-01"]
["Ser.\n(a)","Start \n(b)","End\n(c)","Time\n(d)","Dress\n(e)","Category\n(f)","Event\n(g)",{"$nulls":3},"DTG (start)\n(h)","IC/Instructors\n(i)",{"$nulls":3},"Location\n(j)","Notes"]
[{"$nulls":16},{"$f":"IF(Q2<>\"\", \"(k)\", \"\")","v":"(k)"}]
[{"$f":"IF(B4>0, 1, \"\")","v":{"v":1,"d":"01"}},{"v":830,"d":"0830"},{"$f":"IF(D4>0,IF(RIGHT(B4+I4, 2)*1<60, B4+I4, B4+I4+40)+H4*100, \"\")","v":1010},100,"No 2","Practical","Example Event",{"$f":"TEXT(D4/60-MID(TEXT(D4/60,\"0.00\"),2,100),0)","v":"1"},{"$f":"(D4/60-H4)*60","v":{"v":40.00000000000001,"d":"40"}},{"$f":"A1","v":43466},{"$f":"IF(B4<>\"\", TEXT(J4,\"DD\")&TEXT(B4, \"0000\")&UPPER(TIMEZONE) &TEXT(J4,\" mmm yy\"),  \"\")","v":"010830Z Jan 19"},"EI","E2",null,null,"EL"]
[{"$f":"IF(D5>0, A4+1, \"\")","v":{"v":2,"d":"02"}},{"$f":"IF(D5>0, C4, \"\")","v":1010},1140,90,"No 3","Theory","Example 2","1",30,{"$f":"A1","v":43466},{"$f":"IF(B5<>\"\", TEXT(J5,\"DD\")&TEXT(B5, \"0000\")&UPPER(TIMEZONE) &TEXT(J5,\" mmm yy\"), IF(C4<>\"\", TEXT(J5,\"DD\")&C4&UPPER(TIMEZONE) &TEXT(J5,\" mmm yy\"), \"\"))","v":"011010Z Jan 19"},"E2",{"$nulls":3},"EL"]
[{"$f":"IF(D6>0, A5+1, \"\")","v":{"v":3,"d":"03"}},{"$f":"IF(D6>0, C5, \"\")","v":1140},1230,50,"CEFO","Break",null,"0",50,{"$f":"A1","v":43466},"011140Z Jan 19"]
[{"v":4,"d":"04"},1230,1350,80,"CEFO","Admin",null,"1",{"v":19.999999999999996,"d":"20"},{"$f":"A1","v":43466},"011230Z Jan 19"]
["","","",{"$nulls":4},"0",0,{"$f":"A1","v":43466},"011350Z Jan 19"]
["","","",{"$nulls":4},"0",0,{"$f":"A1","v":43466},""]
["","","",{"$nulls":4},"0",0,{"$f":"A1","v":43466},""]
["","","",{"$nulls":4},"0",0,{"$f":"A1","v":43466},""]
["","","",{"$nulls":4},"0",0,{"$f":"A1","v":43466},""]
["","","",{"$nulls":4},"0",0,{"$f":"A1","v":43466},""]
["","","",{"$nulls":4},"0",0,{"$f":"A1","v":43466},""]
["","","",{"$nulls":4},"0",0,{"$f":"A1","v":43466},""]
["","","",{"$nulls":4},"0",0,{"$f":"A1","v":43466},""]
["","","",{"$nulls":4},"0",0,{"$f":"A1","v":43466},""]
["","","",{"$nulls":4},"0",0,{"$f":"A1","v":43466},""]
["","","",{"$nulls":4},"0",0,{"$f":"A1","v":43466},""]
["","","",{"$nulls":4},"0",0,{"$f":"A1","v":43466},""]
["","","",{"$nulls":4},"0",0,{"$f":"A1","v":43466},""]
["","","",{"$nulls":4},"0",0,{"$f":"A1","v":43466},""]
["","","",{"$nulls":4},"0",0,{"$f":"A1","v":43466},""]
["","","",{"$nulls":4},"0",0,{"$f":"A1","v":43466},""]
["","","",{"$nulls":4},"0",0,{"$f":"A1","v":43466},""]
["","","",{"$nulls":4},"0",0,{"$f":"A1","v":43466},""]
["","","",{"$nulls":4},"0",0,{"$f":"A1","v":43466},""]
[{"$f":"IF(B30>0, A1+1, \"\")","v":""}]
["Ser.\n(a)","Start \n(b)","End\n(c)","Time\n(d)","Dress\n(e)","Category\n(f)","Event\n(g)",{"$nulls":3},"DTG (start)\n(h)","IC/Instructors\n(i)",{"$nulls":3},"Location\n(j)",{"$f":"IF($Q$2<>\"\", $Q$2& CHAR(10) &$Q$3, \"\")","v":"Notes\n(k)"}]
[{"$f":"IF(D30>0, MAX(A4:A27)+1, \"\")","v":""},null,{"$f":"IF(D30>0,IF(RIGHT(B30+I30, 2)*1<60, B30+I30, B30+I30+40)+H30*100, \"\")","v":""},{"$nulls":4},{"$f":"TEXT(D30/60-MID(TEXT(D30/60,\"0.00\"),2,100),0)","v":"0"},{"$f":"(D30/60-H30)*60","v":0},{"$f":"A28","v":""},{"$f":"IF(B30<>\"\", TEXT(J30,\"DD\")&TEXT(B30, \"0000\")&UPPER(TIMEZONE) &TEXT(J30,\" mmm yy\"),  \"\")","v":""}]
[{"$f":"IF(D31>0, A30+1, \"\")","v":""},{"$f":"IF(D31>0, C30, \"\")","v":""},"",{"$nulls":4},"0",0,{"$f":"A28","v":""},{"$f":"IF(B31<>\"\", TEXT(J31,\"DD\")&TEXT(B31, \"0000\")&UPPER(TIMEZONE) &TEXT(J31,\" mmm yy\"), IF(C30<>\"\", TEXT(J31,\"DD\")&C30&UPPER(TIMEZONE) &TEXT(J31,\" mmm yy\"), \"\"))","v":""}]
[{"$f":"IF(D32>0, A31+1, \"\")","v":""},{"$f":"IF(D32>0, C31, \"\")","v":""},"",{"$nulls":4},"0",0,{"$f":"A28","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A28","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A28","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A28","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A28","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A28","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A28","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A28","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A28","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A28","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A28","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A28","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A28","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A28","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A28","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A28","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A28","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A28","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A28","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A28","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A28","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A28","v":""},""]
[{"$f":"IF(B56>0, A28+1, \"\")","v":""}]
["Ser.\n(a)","Start \n(b)","End\n(c)","Time\n(d)","Dress\n(e)","Category\n(f)","Event\n(g)",{"$nulls":3},"DTG (start)\n(h)","IC/Instructors\n(i)",{"$nulls":3},"Location\n(j)",{"$f":"IF($Q$2<>\"\", $Q$2& CHAR(10) &$Q$3, \"\")","v":"Notes\n(k)"}]
[{"$f":"IF(D56>0, MAX(A30:A53)+1, \"\")","v":""},null,{"$f":"IF(D56>0,IF(RIGHT(B56+I56, 2)*1<60, B56+I56, B56+I56+40)+H56*100, \"\")","v":""},{"$nulls":4},{"$f":"TEXT(D56/60-MID(TEXT(D56/60,\"0.00\"),2,100),0)","v":"0"},{"$f":"(D56/60-H56)*60","v":0},{"$f":"A54","v":""},{"$f":"IF(B56<>\"\", TEXT(J56,\"DD\")&TEXT(B56, \"0000\")&UPPER(TIMEZONE) &TEXT(J56,\" mmm yy\"),  \"\")","v":""}]
[{"$f":"IF(D57>0, A56+1, \"\")","v":""},{"$f":"IF(D57>0, C56, \"\")","v":""},"",{"$nulls":4},"0",0,{"$f":"A54","v":""},{"$f":"IF(B57<>\"\", TEXT(J57,\"DD\")&TEXT(B57, \"0000\")&UPPER(TIMEZONE) &TEXT(J57,\" mmm yy\"), IF(C56<>\"\", TEXT(J57,\"DD\")&C56&UPPER(TIMEZONE) &TEXT(J57,\" mmm yy\"), \"\"))","v":""}]
[{"$f":"IF(D58>0, A57+1, \"\")","v":""},{"$f":"IF(D58>0, C57, \"\")","v":""},"",{"$nulls":4},"0",0,{"$f":"A54","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A54","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A54","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A54","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A54","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A54","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A54","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A54","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A54","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A54","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A54","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A54","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A54","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A54","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A54","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A54","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A54","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A54","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A54","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A54","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A54","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A54","v":""},""]
[{"$f":"IF(B82>0, A54+1, \"\")","v":""}]
["Ser.\n(a)","Start \n(b)","End\n(c)","Time\n(d)","Dress\n(e)","Category\n(f)","Event\n(g)",{"$nulls":3},"DTG (start)\n(h)","IC/Instructors\n(i)",{"$nulls":3},"Location\n(j)",{"$f":"IF($Q$2<>\"\", $Q$2& CHAR(10) &$Q$3, \"\")","v":"Notes\n(k)"}]
[{"$f":"IF(D82>0, MAX(A56:A79)+1, \"\")","v":""},null,{"$f":"IF(D82>0,IF(RIGHT(B82+I82, 2)*1<60, B82+I82, B82+I82+40)+H82*100, \"\")","v":""},{"$nulls":4},{"$f":"TEXT(D82/60-MID(TEXT(D82/60,\"0.00\"),2,100),0)","v":"0"},{"$f":"(D82/60-H82)*60","v":0},{"$f":"A80","v":""},{"$f":"IF(B82<>\"\", TEXT(J82,\"DD\")&TEXT(B82, \"0000\")&UPPER(TIMEZONE) &TEXT(J82,\" mmm yy\"),  \"\")","v":""}]
[{"$f":"IF(D83>0, A82+1, \"\")","v":""},{"$f":"IF(D83>0, C82, \"\")","v":""},"",{"$nulls":4},"0",0,{"$f":"A80","v":""},{"$f":"IF(B83<>\"\", TEXT(J83,\"DD\")&TEXT(B83, \"0000\")&UPPER(TIMEZONE) &TEXT(J83,\" mmm yy\"), IF(C82<>\"\", TEXT(J83,\"DD\")&C82&UPPER(TIMEZONE) &TEXT(J83,\" mmm yy\"), \"\"))","v":""}]
[{"$f":"IF(D84>0, A83+1, \"\")","v":""},{"$f":"IF(D84>0, C83, \"\")","v":""},"",{"$nulls":4},"0",0,{"$f":"A80","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A80","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A80","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A80","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A80","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A80","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A80","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A80","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A80","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A80","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A80","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A80","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A80","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A80","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A80","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A80","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A80","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A80","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A80","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A80","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A80","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A80","v":""},""]
[{"$f":"IF(B108>0, A80+1, \"\")","v":""}]
["Ser.\n(a)","Start \n(b)","End\n(c)","Time\n(d)","Dress\n(e)","Category\n(f)","Event\n(g)",{"$nulls":3},"DTG (start)\n(h)","IC/Instructors\n(i)",{"$nulls":3},"Location\n(j)",{"$f":"IF($Q$2<>\"\", $Q$2& CHAR(10) &$Q$3, \"\")","v":"Notes\n(k)"}]
[{"$f":"IF(D108>0, MAX(A82:A105)+1, \"\")","v":""},null,{"$f":"IF(D108>0,IF(RIGHT(B108+I108, 2)*1<60, B108+I108, B108+I108+40)+H108*100, \"\")","v":""},{"$nulls":4},{"$f":"TEXT(D108/60-MID(TEXT(D108/60,\"0.00\"),2,100),0)","v":"0"},{"$f":"(D108/60-H108)*60","v":0},{"$f":"A106","v":""},{"$f":"IF(B108<>\"\", TEXT(J108,\"DD\")&TEXT(B108, \"0000\")&UPPER(TIMEZONE) &TEXT(J108,\" mmm yy\"),  \"\")","v":""}]
[{"$f":"IF(D109>0, A108+1, \"\")","v":""},{"$f":"IF(D109>0, C108, \"\")","v":""},"",{"$nulls":4},"0",0,{"$f":"A106","v":""},{"$f":"IF(B109<>\"\", TEXT(J109,\"DD\")&TEXT(B109, \"0000\")&UPPER(TIMEZONE) &TEXT(J109,\" mmm yy\"), IF(C108<>\"\", TEXT(J109,\"DD\")&C108&UPPER(TIMEZONE) &TEXT(J109,\" mmm yy\"), \"\"))","v":""}]
[{"$f":"IF(D110>0, A109+1, \"\")","v":""},{"$f":"IF(D110>0, C109, \"\")","v":""},"",{"$nulls":4},"0",0,{"$f":"A106","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A106","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A106","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A106","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A106","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A106","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A106","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A106","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A106","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A106","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A106","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A106","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A106","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A106","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A106","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A106","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A106","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A106","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A106","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A106","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A106","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A106","v":""},""]
[{"$f":"IF(B134>0, A106+1, \"\")","v":""}]
["Ser.\n(a)","Start \n(b)","End\n(c)","Time\n(d)","Dress\n(e)","Category\n(f)","Event\n(g)",{"$nulls":3},"DTG (start)\n(h)","IC/Instructors\n(i)",{"$nulls":3},"Location\n(j)",{"$f":"IF($Q$2<>\"\", $Q$2& CHAR(10) &$Q$3, \"\")","v":"Notes\n(k)"}]
[{"$f":"IF(D134>0, MAX(A108:A131)+1, \"\")","v":""},null,{"$f":"IF(D134>0,IF(RIGHT(B134+I134, 2)*1<60, B134+I134, B134+I134+40)+H134*100, \"\")","v":""},{"$nulls":4},{"$f":"TEXT(D134/60-MID(TEXT(D134/60,\"0.00\"),2,100),0)","v":"0"},{"$f":"(D134/60-H134)*60","v":0},{"$f":"A132","v":""},{"$f":"IF(B134<>\"\", TEXT(J134,\"DD\")&TEXT(B134, \"0000\")&UPPER(TIMEZONE) &TEXT(J134,\" mmm yy\"),  \"\")","v":""}]
[{"$f":"IF(D135>0, A134+1, \"\")","v":""},{"$f":"IF(D135>0, C134, \"\")","v":""},"",{"$nulls":4},"0",0,{"$f":"A132","v":""},{"$f":"IF(B135<>\"\", TEXT(J135,\"DD\")&TEXT(B135, \"0000\")&UPPER(TIMEZONE) &TEXT(J135,\" mmm yy\"), IF(C134<>\"\", TEXT(J135,\"DD\")&C134&UPPER(TIMEZONE) &TEXT(J135,\" mmm yy\"), \"\"))","v":""}]
[{"$f":"IF(D136>0, A135+1, \"\")","v":""},{"$f":"IF(D136>0, C135, \"\")","v":""},"",{"$nulls":4},"0",0,{"$f":"A132","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A132","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A132","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A132","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A132","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A132","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A132","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A132","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A132","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A132","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A132","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A132","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A132","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A132","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A132","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A132","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A132","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A132","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A132","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A132","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A132","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A132","v":""},""]
[{"$f":"IF(B160>0, A132+1, \"\")","v":""}]
["Ser.\n(a)","Start \n(b)","End\n(c)","Time\n(d)","Dress\n(e)","Category\n(f)","Event\n(g)",{"$nulls":3},"DTG (start)\n(h)","IC/Instructors\n(i)",{"$nulls":3},"Location\n(j)",{"$f":"IF($Q$2<>\"\", $Q$2& CHAR(10) &$Q$3, \"\")","v":"Notes\n(k)"}]
[{"$f":"IF(D160>0, MAX(A134:A157)+1, \"\")","v":""},null,{"$f":"IF(D160>0,IF(RIGHT(B160+I160, 2)*1<60, B160+I160, B160+I160+40)+H160*100, \"\")","v":""},{"$nulls":4},{"$f":"TEXT(D160/60-MID(TEXT(D160/60,\"0.00\"),2,100),0)","v":"0"},{"$f":"(D160/60-H160)*60","v":0},{"$f":"A158","v":""},{"$f":"IF(B160<>\"\", TEXT(J160,\"DD\")&TEXT(B160, \"0000\")&UPPER(TIMEZONE) &TEXT(J160,\" mmm yy\"),  \"\")","v":""}]
[{"$f":"IF(D161>0, A160+1, \"\")","v":""},{"$f":"IF(D161>0, C160, \"\")","v":""},"",{"$nulls":4},"0",0,{"$f":"A158","v":""},{"$f":"IF(B161<>\"\", TEXT(J161,\"DD\")&TEXT(B161, \"0000\")&UPPER(TIMEZONE) &TEXT(J161,\" mmm yy\"), IF(C160<>\"\", TEXT(J161,\"DD\")&C160&UPPER(TIMEZONE) &TEXT(J161,\" mmm yy\"), \"\"))","v":""}]
[{"$f":"IF(D162>0, A161+1, \"\")","v":""},{"$f":"IF(D162>0, C161, \"\")","v":""},"",{"$nulls":4},"0",0,{"$f":"A158","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A158","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A158","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A158","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A158","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A158","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A158","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A158","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A158","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A158","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A158","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A158","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A158","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A158","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A158","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A158","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A158","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A158","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A158","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A158","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A158","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A158","v":""},""]
[{"$f":"IF(B186>0, A158+1, \"\")","v":""}]
["Ser.\n(a)","Start \n(b)","End\n(c)","Time\n(d)","Dress\n(e)","Category\n(f)","Event\n(g)",{"$nulls":3},"DTG (start)\n(h)","IC/Instructors\n(i)",{"$nulls":3},"Location\n(j)",{"$f":"IF($Q$2<>\"\", $Q$2& CHAR(10) &$Q$3, \"\")","v":"Notes\n(k)"}]
[{"$f":"IF(D186>0, MAX(A160:A183)+1, \"\")","v":""},null,{"$f":"IF(D186>0,IF(RIGHT(B186+I186, 2)*1<60, B186+I186, B186+I186+40)+H186*100, \"\")","v":""},{"$nulls":4},{"$f":"TEXT(D186/60-MID(TEXT(D186/60,\"0.00\"),2,100),0)","v":"0"},{"$f":"(D186/60-H186)*60","v":0},{"$f":"A184","v":""},{"$f":"IF(B186<>\"\", TEXT(J186,\"DD\")&TEXT(B186, \"0000\")&UPPER(TIMEZONE) &TEXT(J186,\" mmm yy\"),  \"\")","v":""}]
[{"$f":"IF(D187>0, A186+1, \"\")","v":""},{"$f":"IF(D187>0, C186, \"\")","v":""},"",{"$nulls":4},"0",0,{"$f":"A184","v":""},{"$f":"IF(B187<>\"\", TEXT(J187,\"DD\")&TEXT(B187, \"0000\")&UPPER(TIMEZONE) &TEXT(J187,\" mmm yy\"), IF(C186<>\"\", TEXT(J187,\"DD\")&C186&UPPER(TIMEZONE) &TEXT(J187,\" mmm yy\"), \"\"))","v":""}]
[{"$f":"IF(D188>0, A187+1, \"\")","v":""},{"$f":"IF(D188>0, C187, \"\")","v":""},"",{"$nulls":4},"0",0,{"$f":"A184","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A184","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A184","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A184","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A184","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A184","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A184","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A184","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A184","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A184","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A184","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A184","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A184","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A184","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A184","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A184","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A184","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A184","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A184","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A184","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A184","v":""},""]
["","","",{"$nulls":4},"0",0,{"$f":"A184","v":""},""]

{"sheet":"Types","index":1,"n_rows":30,"n_cols":14,"rows_kept":30,"merged":[[2,0,2,1],[3,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1]]}
["Time Zone:","Z",{"$nulls":7}," "]
[]
["Training Type",null,"Time","Percentage",{"$nulls":4},"Dress","Time","Percentage"]
["Practical",null,{"$f":"IF(A4<>\"\",IF(F4>0, F4& \"h \", \"\") & IF(G4>0, G4& \"m\", \"\"),\"\")","v":"1h 40m"},{"$f":"IF(E4>0, IF(A4<>\"\", E4/SUM(E$4:E$15), \"\"), \"\")","v":{"v":0.3125,"d":"31%"}},{"$f":" SUMIF(MEL!F$4:F$1000, Types!A4, MEL!D$4:D$1000)","v":100},{"$f":"ROUNDDOWN(E4/60,0)","v":1},{"$f":" E4-F4*60","v":40},null,"No 2",{"$f":"IF(I4<>\"\",IF(M4>0, M4& \"h \", \"\") & IF(N4>0, N4& \"m\", \"\"),\"\")","v":"1h 40m"},{"$f":"IF(L4>0, IF(I4<>\"\", L4/SUM(L$4:L$15), \"\"), \"\")","v":{"v":0.3125,"d":"31%"}},{"$f":" SUMIF(MEL!E$4:E$1000, Types!I4, MEL!D$4:D$1000)","v":100},{"$f":"ROUNDDOWN(L4/60,0)","v":1},{"$f":" L4-M4*60","v":40}]
["Theory",null,{"$f":"IF(A5<>\"\",IF(F5>0, F5& \"h \", \"\") & IF(G5>0, G5& \"m\", \"\"),\"\")","v":"1h 30m"},{"$f":"IF(E5>0, IF(A5<>\"\", E5/SUM(E$4:E$15), \"\"), \"\")","v":{"v":0.28125,"d":"28%"}},{"$f":" SUMIF(MEL!F$4:F$1000, Types!A5, MEL!D$4:D$1000)","v":90},{"$f":"ROUNDDOWN(E5/60,0)","v":1},{"$f":" E5-F5*60","v":30},null,"No 2A",{"$f":"IF(I5<>\"\",IF(M5>0, M5& \"h \", \"\") & IF(N5>0, N5& \"m\", \"\"),\"\")","v":""},{"$f":"IF(L5>0, IF(I5<>\"\", L5/SUM(L$4:L$15), \"\"), \"\")","v":""},{"$f":" SUMIF(MEL!E$4:E$1000, Types!I5, MEL!D$4:D$1000)","v":0},{"$f":"ROUNDDOWN(L5/60,0)","v":0},{"$f":" L5-M5*60","v":0}]
["Break",null,"50m",{"v":0.15625,"d":"16%"},{"$f":" SUMIF(MEL!F$4:F$1000, Types!A6, MEL!D$4:D$1000)","v":50},0,50,null,"No 2C","","",{"$f":" SUMIF(MEL!E$4:E$1000, Types!I6, MEL!D$4:D$1000)","v":0},0,0]
["Admin",null,"1h 20m",{"v":0.25,"d":"25%"},{"$f":" SUMIF(MEL!F$4:F$1000, Types!A7, MEL!D$4:D$1000)","v":80},1,20,null,"No 3","1h 30m",{"v":0.28125,"d":"28%"},{"$f":" SUMIF(MEL!E$4:E$1000, Types!I7, MEL!D$4:D$1000)","v":90},1,30]
[null,null,"","",{"$f":" SUMIF(MEL!F$4:F$1000, Types!A8, MEL!D$4:D$1000)","v":0},0,0,null,"No 3A","","",{"$f":" SUMIF(MEL!E$4:E$1000, Types!I8, MEL!D$4:D$1000)","v":0},0,0]
[null,null,"","",{"$f":" SUMIF(MEL!F$4:F$1000, Types!A9, MEL!D$4:D$1000)","v":0},{"$f":"ROUNDDOWN(E9/60,0)","v":0},{"$f":" E9-F9*60","v":0},null,"Belt Order","","",{"$f":" SUMIF(MEL!E$4:E$1000, Types!I9, MEL!D$4:D$1000)","v":0},{"$f":"ROUNDDOWN(L9/60,0)","v":0},{"$f":" L9-M9*60","v":0}]
[null,null,"","",{"$f":" SUMIF(MEL!F$4:F$1000, Types!A10, MEL!D$4:D$1000)","v":0},0,0,null,"CEFO","2h 10m",{"v":0.40625,"d":"41%"},{"$f":" SUMIF(MEL!E$4:E$1000, Types!I10, MEL!D$4:D$1000)","v":130},2,10]
[null,null,"","",{"$f":" SUMIF(MEL!F$4:F$1000, Types!A11, MEL!D$4:D$1000)","v":0},0,0,null,"CEMO","","",{"$f":" SUMIF(MEL!E$4:E$1000, Types!I11, MEL!D$4:D$1000)","v":0},0,0]
[null,null,"","",{"$f":" SUMIF(MEL!F$4:F$1000, Types!A12, MEL!D$4:D$1000)","v":0},0,0,null,"Civvies","","",{"$f":" SUMIF(MEL!E$4:E$1000, Types!I12, MEL!D$4:D$1000)","v":0},0,0]
[null,null,"","",{"$f":" SUMIF(MEL!F$4:F$1000, Types!A13, MEL!D$4:D$1000)","v":0},0,0,null,"Sports kit","","",{"$f":" SUMIF(MEL!E$4:E$1000, Types!I13, MEL!D$4:D$1000)","v":0},0,0]
[null,null,"","",{"$f":" SUMIF(MEL!F$4:F$1000, Types!A14, MEL!D$4:D$1000)","v":0},0,0,null,null,"","",{"$f":" SUMIF(MEL!E$4:E$1000, Types!I14, MEL!D$4:D$1000)","v":0},0,0]
[null,null,"","",{"$f":" SUMIF(MEL!F$4:F$1000, Types!A15, MEL!D$4:D$1000)","v":0},0,0,null,null,"","",{"$f":" SUMIF(MEL!E$4:E$1000, Types!I15, MEL!D$4:D$1000)","v":0},0,0]
["Total",null,"5h 20m",null,{"$f":"ROUNDDOWN(SUM(G4:G15)/60,0)","v":2},{"$f":"SUM(F4:F15)+E16","v":5},{"$f":"SUM(G4:G15)-E16*60","v":20},null,null,"","",{"$f":" SUMIF(MEL!E$4:E$1000, Types!I16, MEL!D$4:D$1000)","v":0},{"$f":"ROUNDDOWN(L16/60,0)","v":0},{"$f":" L16-M16*60","v":0}]
[]
["Instructor","Code","Time","Percentage",{"$nulls":4},"Location","Code"]
["Example Instructor","EI",{"$f":"IF(A19<>\"\",IF(F19>0, F19& \"h \", \"\") & IF(G19>0, G19& \"m\", \"\"),\"\")","v":"1h 40m"},{"$f":"IF(E19>0, IF(A19<>\"\", E19/SUM(E$4:E$15), \"\"), \"\")","v":{"v":0.3125,"d":"31%"}},{"$f":" SUMIF(MEL!L$4:L$999, Types!B19, MEL!D$4:D$1000) + SUMIF(MEL!M$4:M$999, Types!B19, MEL!D$4:D$1000) +SUMIF(MEL!N$4:N$999, Types!B19, MEL!D$4:D$1000) + SUMIF(MEL!O$4:O$999, Types!B19, MEL!D$4:D$1000)","v":100},{"$f":"ROUNDDOWN(E19/60,0)","v":1},{"$f":" E19-F19*60","v":40},null,"Example location","EL"]
["Example Instructor 2","E2",{"$f":"IF(A20<>\"\",IF(F20>0, F20& \"h \", \"\") & IF(G20>0, G20& \"m\", \"\"),\"\")","v":"3h 10m"},{"$f":"IF(E20>0, IF(A20<>\"\", E20/SUM(E$4:E$15), \"\"), \"\")","v":{"v":0.59375,"d":"59%"}},{"$f":" SUMIF(MEL!L$4:L$999, Types!B20, MEL!D$4:D$1000) + SUMIF(MEL!M$4:M$999, Types!B20, MEL!D$4:D$1000) +SUMIF(MEL!N$4:N$999, Types!B20, MEL!D$4:D$1000) + SUMIF(MEL!O$4:O$999, Types!B20, MEL!D$4:D$1000)","v":190},{"$f":"ROUNDDOWN(E20/60,0)","v":3},{"$f":" E20-F20*60","v":10}]
[null,null,"","",{"$f":" SUMIF(MEL!L$4:L$999, Types!B21, MEL!D$4:D$1000) + SUMIF(MEL!M$4:M$999, Types!B21, MEL!D$4:D$1000) +SUMIF(MEL!N$4:N$999, Types!B21, MEL!D$4:D$1000) + SUMIF(MEL!O$4:O$999, Types!B21, MEL!D$4:D$1000)","v":0},0,0]
[null,null,"","",{"$f":" SUMIF(MEL!L$4:L$999, Types!B22, MEL!D$4:D$1000) + SUMIF(MEL!M$4:M$999, Types!B22, MEL!D$4:D$1000) +SUMIF(MEL!N$4:N$999, Types!B22, MEL!D$4:D$1000) + SUMIF(MEL!O$4:O$999, Types!B22, MEL!D$4:D$1000)","v":0},0,0]
[null,null,"","",{"$f":" SUMIF(MEL!L$4:L$999, Types!B23, MEL!D$4:D$1000) + SUMIF(MEL!M$4:M$999, Types!B23, MEL!D$4:D$1000) +SUMIF(MEL!N$4:N$999, Types!B23, MEL!D$4:D$1000) + SUMIF(MEL!O$4:O$999, Types!B23, MEL!D$4:D$1000)","v":0},{"$f":"ROUNDDOWN(E23/60,0)","v":0},0]
[null,null,"","",{"$f":" SUMIF(MEL!L$4:L$999, Types!B24, MEL!D$4:D$1000) + SUMIF(MEL!M$4:M$999, Types!B24, MEL!D$4:D$1000) +SUMIF(MEL!N$4:N$999, Types!B24, MEL!D$4:D$1000) + SUMIF(MEL!O$4:O$999, Types!B24, MEL!D$4:D$1000)","v":0},0,0]
[null,null,"","",{"$f":" SUMIF(MEL!L$4:L$999, Types!B25, MEL!D$4:D$1000) + SUMIF(MEL!M$4:M$999, Types!B25, MEL!D$4:D$1000) +SUMIF(MEL!N$4:N$999, Types!B25, MEL!D$4:D$1000) + SUMIF(MEL!O$4:O$999, Types!B25, MEL!D$4:D$1000)","v":0},0,0]
[null,null,"","",{"$f":" SUMIF(MEL!L$4:L$999, Types!B26, MEL!D$4:D$1000) + SUMIF(MEL!M$4:M$999, Types!B26, MEL!D$4:D$1000) +SUMIF(MEL!N$4:N$999, Types!B26, MEL!D$4:D$1000) + SUMIF(MEL!O$4:O$999, Types!B26, MEL!D$4:D$1000)","v":0},0,0]
[null,null,"","",{"$f":" SUMIF(MEL!L$4:L$999, Types!B27, MEL!D$4:D$1000) + SUMIF(MEL!M$4:M$999, Types!B27, MEL!D$4:D$1000) +SUMIF(MEL!N$4:N$999, Types!B27, MEL!D$4:D$1000) + SUMIF(MEL!O$4:O$999, Types!B27, MEL!D$4:D$1000)","v":0},0,0]
[null,null,"","",{"$f":" SUMIF(MEL!L$4:L$999, Types!B28, MEL!D$4:D$1000) + SUMIF(MEL!M$4:M$999, Types!B28, MEL!D$4:D$1000) +SUMIF(MEL!N$4:N$999, Types!B28, MEL!D$4:D$1000) + SUMIF(MEL!O$4:O$999, Types!B28, MEL!D$4:D$1000)","v":0},0,0]
[null,null,"","",{"$f":" SUMIF(MEL!L$4:L$999, Types!B29, MEL!D$4:D$1000) + SUMIF(MEL!M$4:M$999, Types!B29, MEL!D$4:D$1000) +SUMIF(MEL!N$4:N$999, Types!B29, MEL!D$4:D$1000) + SUMIF(MEL!O$4:O$999, Types!B29, MEL!D$4:D$1000)","v":0},0,0]
[null,null,"","",{"$f":" SUMIF(MEL!L$4:L$999, Types!B30, MEL!D$4:D$1000) + SUMIF(MEL!M$4:M$999, Types!B30, MEL!D$4:D$1000) +SUMIF(MEL!N$4:N$999, Types!B30, MEL!D$4:D$1000) + SUMIF(MEL!O$4:O$999, Types!B30, MEL!D$4:D$1000)","v":0},0,0]