{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Pupil List","Print Template","School List","Barcodes"],"not_rendered":{"charts":4,"images":1,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,0,9]]}
["INSTRUCTIONS"]
[]
[null,"1. OPEN the Excel Document attached (RunnersNames2015)."]
[null,"2. Select the sheet, \"Pupil List\""]
[null,"3. Select your school name in the box D7, this will automatically select your school code and prepare your numbers."]
[null,"4. Each school may use numbers from 01 to 99"]
[]
[]
[null,"5. Start to enter your students     ",null,null,null,"1. You may copy names from last years spreadsheet"]
[null,null,null,null,null,"2. Remove any students who have left (ie last years year 6 or 13), or who are no longer running"]
[null,null,null,null,null,"3. Enter the school year for each runner and whether boy or girl. "]
[null,null,null,null,null,"4. Add any new runners to the spaces that are free."]
[]
[null,"6. Enter the email adress for the main school contact, and update the date each time you change the list"]
[]
[null,"7. Print a copy of the list and bring it to each race, so you can ensure students use the correct numbers."]
[]
[null,"8.  Use the inbuilt function to print numbers you can attach to runners.  This is set to print two numbers per A4 sheet."]
[null,"Set the range of numbers you want to print in boxes E3 and E4"]
[null,"This will format the numbers to make recording at the finish line easier, and also discretely print the runners name in the bottom right corner."]
[null,"You may need to select \"Enable Content\" at the top when you open the file for this function to work."]
[]
[null,"9. Please then save the document titled \" YOUR SCHOOL NAME RunnersNames2015\""]
[null,"eg \"ParksideSchool RunnersNames2015\" and email to geofft@cotec.freeserve.co.uk  attaching the saved file."]
[]
[null,"10. To add new runners during the year choose an unused number. Do not change the number of any runner who has run. They must keep the same number throughout this season."]
[null,"Email the changed list before the start of each race."]
[]
["Rev 2 29/09/2015"]

{"sheet":"Pupil List","index":1,"n_rows":109,"n_cols":6,"rows_kept":109,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null," "," "]
[null,null,null,"Start Number",1]
[null,null,null,"End Number",2]
[]
[null,null,"Date Updated","2015-09-09"]
[null,null,"School Name","Not Listed","Code",{"$f":"VLOOKUP(D7,'School List'!B3:C42,2,FALSE)","v":"xx"}]
[null,null,"School Contact"]
[]
["Number ","Runners Number","Pupil Name","School","Year","Gender"]
[1,{"$f":"CONCATENATE(Code,TEXT(A11,\"00\"))","v":"xx01"},null,{"$f":"School","v":"Not Listed"}]
[2,"xx02",null,"Not Listed"]
[3,"xx03",null,"Not Listed"]
[4,"xx04",null,"Not Listed"]
[5,"xx05",null,"Not Listed"]
[6,"xx06",null,"Not Listed"]
[7,"xx07",null,"Not Listed"]
[8,"xx08",null,"Not Listed"]
[9,"xx09",null,"Not Listed"]
[10,"xx10",null,"Not Listed"]
[11,"xx11"," ","Not Listed"]
[12,"xx12",null,"Not Listed"]
[13,"xx13",null,"Not Listed"]
[14,"xx14",null,"Not Listed"]
[15,"xx15",null,"Not Listed"]
[16,"xx16",null,"Not Listed"]
[17,"xx17",null,"Not Listed"]
[18,"xx18",null,"Not Listed"]
[19,"xx19",null,"Not Listed"]
[20,"xx20",null,"Not Listed"]
[21,"xx21",null,"Not Listed"]
[22,"xx22",null,"Not Listed"]
[23,"xx23",null,"Not Listed"]
[24,"xx24",null,"Not Listed"]
[25,"xx25",null,"Not Listed"]
[26,"xx26",null,"Not Listed"]
[27,"xx27",null,"Not Listed"]
[28,"xx28",null,"Not Listed"]
[29,"xx29",null,"Not Listed"]
[30,"xx30",null,"Not Listed"]
[31,"xx31",null,"Not Listed"]
[32,"xx32",null,"Not Listed"]
[33,{"$f":"CONCATENATE(Code,TEXT(A43,\"00\"))","v":"xx33"},null,{"$f":"School","v":"Not Listed"}]
[34,"xx34",null,"Not Listed"]
[35,"xx35",null,"Not Listed"]
[36,"xx36",null,"Not Listed"]
[37,"xx37",null,"Not Listed"]
[38,"xx38",null,"Not Listed"]
[39,"xx39",null,"Not Listed"]
[40,"xx40",null,"Not Listed"]
[41,"xx41",null,"Not Listed"]
[42,"xx42",null,"Not Listed"]
[43,"xx43",null,"Not Listed"]
[44,"xx44",null,"Not Listed"]
[45,"xx45",null,"Not Listed"]
[46,"xx46",null,"Not Listed"]
[47,"xx47",null,"Not Listed"]
[48,"xx48",null,"Not Listed"]
[49,"xx49",null,"Not Listed"]
[50,"xx50",null,"Not Listed"]
[51,"xx51",null,"Not Listed"]
[52,"xx52",null,"Not Listed"]
[53,"xx53",null,"Not Listed"]
[54,"xx54",null,"Not Listed"]
[55,"xx55",null,"Not Listed"]
[56,"xx56",null,"Not Listed"]
[57,"xx57",null,"Not Listed"]
[58,"xx58",null,"Not Listed"]
[59,"xx59",null,"Not Listed"]
[60,"xx60",null,"Not Listed"]
[61,"xx61",null,"Not Listed"]
[62,"xx62",null,"Not Listed"]
[63,"xx63",null,"Not Listed"]
[64,"xx64",null,"Not Listed"]
[65,{"$f":"CONCATENATE(Code,TEXT(A75,\"00\"))","v":"xx65"},null,{"$f":"School","v":"Not Listed"}]
[66,"xx66",null,"Not Listed"]
[67,"xx67",null,"Not Listed"]
[68,"xx68",null,"Not Listed"]
[69,"xx69",null,"Not Listed"]
[70,"xx70",null,"Not Listed"]
[71,"xx71",null,"Not Listed"]
[72,"xx72",null,"Not Listed"]
[73,"xx73",null,"Not Listed"]
[74,"xx74",null,"Not Listed"]
[75,"xx75",null,"Not Listed"]
[76,"xx76",null,"Not Listed"]
[77,"xx77",null,"Not Listed"]
[78,"xx78",null,"Not Listed"]
[79,"xx79",null,"Not Listed"]
[80,"xx80",null,"Not Listed"]
[81,"xx81",null,"Not Listed"]
[82,"xx82",null,"Not Listed"]
[83,"xx83",null,"Not Listed"]
[84,"xx84",null,"Not Listed"]
[85,"xx85",null,"Not Listed"]
[86,"xx86",null,"Not Listed"]
[87,"xx87",null,"Not Listed"]
[88,"xx88",null,"Not Listed"]
[89,"xx89",null,"Not Listed"]
[90,"xx90",null,"Not Listed"]
[91,"xx91",null,"Not Listed"]
[92,"xx92",null,"Not Listed"]
[93,"xx93",null,"Not Listed"]
[94,"xx94",null,"Not Listed"]
[95,"xx95",null,"Not Listed"]
[96,"xx96",null,"Not Listed"]
[97,{"$f":"CONCATENATE(Code,TEXT(A107,\"00\"))","v":"xx97"},null,"Not Listed"]
[98,"xx98",null,"Not Listed"]
[99,"xx99",null,"Not Listed"]

{"sheet":"Print Template","index":2,"n_rows":15,"n_cols":1,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Keighley and Craven Schools Cross Country 2015-2016"]
[]
["xx01"]
[]
[]
[]
["Year ?? ??s"]
[]
["Keighley and Craven Schools Cross Country 2015-2016"]
[]
["xx02"]
[]
[]
[]
["Year ?? s"]

{"sheet":"School List","index":3,"n_rows":43,"n_cols":3,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[null,null,"School code"]
[]
[null,"Not Listed","xx"]
[1,"Bingley Grammar","Bi"]
[2,"Bradford GS","BGS"]
[3,"Ermysted's GS","E"]
[4,"Holy Family","HF"]
[5,"Ilkley GS","IGS"]
[6,"Oakbank","Oak"]
[7,"Parkside","P"]
[8,"Skipton Girls HS","SGH"]
[9,"South Craven","SC "]
[10,"Thornton GS","Th"]
[11,"Grange","G"]
[12,"Upper Wharfdale","UW"]
[1,"Baildon CE","BCE"]
[2,"Bradley Both","BR"]
[3,"Cononley","Con"]
[4,"East Morton","EM"]
[5,"Eastburn","Eb"]
[6,"Eastwood","Ea"]
[7,"Haworth","Ha "]
[8,"Harden","Har"]
[9,"Holycroft","Hol"]
[10,"Hothfield","Hot"]
[11,"Merlin Top","MT"]
[12,"Nessfield","Ne"]
[13,"Oakworth","Oa "]
[14,"Oxenhope","Ox"]
[15,"St Annes","StA"]
[16,"St Josephs","StJ"]
[17,"St Stephen","StS"]
[18,"Stanbury","Stan"]
[19,"Steeton","Ste"]
[20,"Thackley","Thack"]
[21,"Wilsden","Wi"]
[1,"Home Schooled","HS"]
[2,"Skipton Academy","SkA"]
[3,"Immanuel College","Im"]
[4,"UAK","UAK"]
[5,"Ingrow","In"]
[6,"Crossflatts","XF"]
[null,null," "]

{"sheet":"Barcodes","index":4,"n_rows":144,"n_cols":25,"rows_kept":144,"cut":false,"hidden":true,"merged":[[112,23,113,23],[112,24,113,24],[108,18,108,20],[109,18,109,20],[110,18,110,20],[111,18,111,20],[112,17,113,17],[112,18,112,20],[113,18,113,20],[112,21,113,21],[112,22,113,22]]}
[]
[]
[]
[]
[]
[null,{"$f":"'Print Template'!A3","v":"xx01"},null,{"$f":"'Print Template'!A11","v":"xx02"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,"space"," ",0,"0032 or 0212 / 252","Space or Ô / ü",11011001100,212222]
[null,"Barcode 1",null,"Barcode 2",null,null,null,null,null,null,null,null,null,null,null,null,null,1," !"," !",1,33," !",11001101100,222122]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"\"","\"",2,34,"\"",11001100110,222221]
[null,{"$f":"CONCATENATE(B6,\"       \")","v":"xx01       "},null,{"$f":"CONCATENATE(D6,\"       \")","v":"xx02       "},null,null,null,null,null,null,null,null,null,null,null,null,null,3,"#","#",3,35,"#",10010011000,121223]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"$","$",4,36,"$",10010001100,121322]
[null,"Blank",0,"Blank",0,null,null,null,null,null,null,null,null,null,null,null,null,5," %"," %",5,37," %",10001001100,131222]
[null,"0000000000",0,"0000000000",0,null,null,null,null,null,null,null,null,null,null,null,null,6,"&","&",6,38,"&",10011001000,122213]
[null,null,0,null,0,null,null,null,null,null,null,null,null,null,null,null,null,7,"'","'",7,39,"'",10011000100,122312]
[null,null,0,null,0,null,null,null,null,null,null,null,null,null,null,null,null,8,"(","(",8,40,"(",10001100100,132212]
[null,null,0,null,0,null,null,null,null,null,null,null,null,null,null,null,null,9,")",")",9,41,")",11001001000,221213]
[null,null,0,null,0,null,null,null,null,null,null,null,null,null,null,null,null,10,"*","*",10,42,"*",11001000100,221312]
[null,null,0,null,0,null,null,null,null,null,null,null,null,null,null,null,null,11,"+","+",11,43,"+",11000100100,231212]
[null,null,0,null,0,null,null,null,null,null,null,null,null,null,null,null,null,12,",",",",12,44,",",10110011100,112232]
[null,null,0,null,0,null,null,null,null,null,null,null,null,null,null,null,null,13,"-","-",13,45,"-",10011011100,122132]
[null,null,0,null,0,null,null,null,null,null,null,null,null,null,null,null,null,14,".",".",14,46,".",10011001110,122231]
[null,null,0,null,0,null,null,null,null,null,null,null,null,null,null,null,null,15,"/","/",15,47,"/",10111001100,113222]
[null,"Start B",{"$f":"VALUE(LEFT(B23,1))","v":1},"Start B",{"$f":"VALUE(LEFT(D23,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,16,0,"0",16,48,0,10011101100,123122]
[null,11010010000,{"$f":"VALUE(MID(B23,2,1))","v":1},11010010000,{"$f":"VALUE(MID(D23,2,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,17,1,"1",17,49,1,10011100110,123221]
[null,"1",{"$f":"VALUE(MID(B23,3,1))","v":0},"1",{"$f":"VALUE(MID(D23,3,1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,18,2,"2",18,50,2,11001110010,223211]
[null,104,{"$f":"VALUE(MID(B23,4,1))","v":1},104,{"$f":"VALUE(MID(D23,4,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,19,3,"3",19,51,3,11001011100,221132]
[null,{"$f":"B24*B25","v":104},{"$f":"VALUE(MID(B23,5,1))","v":0},{"$f":"D24*D25","v":104},{"$f":"VALUE(MID(D23,5,1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,20,4,"4",20,52,4,11001001110,221231]
[null,null,{"$f":"VALUE(MID(B23,6,1))","v":0},null,{"$f":"VALUE(MID(D23,6,1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,21,5,"5",21,53,5,11011100100,213212]
[null,null,{"$f":"VALUE(MID(B23,7,1))","v":1},null,{"$f":"VALUE(MID(D23,7,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,22,6,"6",22,54,6,11001110100,223112]
[null,null,{"$f":"VALUE(MID(B23,8,1))","v":0},null,{"$f":"VALUE(MID(D23,8,1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,23,7,"7",23,55,7,11101101110,312131]
[null,null,{"$f":"VALUE(MID(B23,9,1))","v":0},null,{"$f":"VALUE(MID(D23,9,1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,24,8,"8",24,56,8,11101001100,311222]
[null,null,{"$f":"VALUE(MID(B23,10,1))","v":0},null,{"$f":"VALUE(MID(D23,10,1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,25,9,"9",25,57,9,11100101100,321122]
[null,null,{"$f":"VALUE(MID(B23,11,1))","v":0},null,{"$f":"VALUE(MID(D23,11,1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,26," :"," :",26,58," :",11100100110,321221]
[null,{"$f":"MID($B$9,1,1)","v":"x"},{"$f":"VALUE(LEFT(B34,1))","v":1},{"$f":"MID($D$9,1,1)","v":"x"},{"$f":"VALUE(LEFT(D34,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,27," ;"," ;",27,59," ;",11101100100,312212]
[null,{"$f":"VLOOKUP(B33,$T$6:$Y$108,5,FALSE)","v":11100010110},{"$f":"VALUE(MID(B34,2,1))","v":1},{"$f":"VLOOKUP(D33,$T$6:$Y$108,5,FALSE)","v":11100010110},{"$f":"VALUE(MID(D34,2,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,28,"<","<",28,60,"<",11100110100,322112]
[null,1,{"$f":"VALUE(MID(B34,3,1))","v":1},1,{"$f":"VALUE(MID(D34,3,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,29,"=","=",29,61,"=",11100110010,322211]
[null,{"$f":"VLOOKUP(B33,$T$6:$Y$108,2,FALSE)","v":56},{"$f":"VALUE(MID(B34,4,1))","v":0},{"$f":"VLOOKUP(D33,$T$6:$Y$108,2,FALSE)","v":56},{"$f":"VALUE(MID(D34,4,1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,30,">",">",30,62,">",11011011000,212123]
[null,{"$f":"B35*B36","v":56},{"$f":"VALUE(MID(B34,5,1))","v":0},{"$f":"D35*D36","v":56},{"$f":"VALUE(MID(D34,5,1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,31," ?"," ?",31,63," ?",11011000110,212321]
[null,null,{"$f":"VALUE(MID(B34,6,1))","v":0},null,{"$f":"VALUE(MID(D34,6,1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,32,"@","@",32,64,"@",11000110110,232121]
[null,null,{"$f":"VALUE(MID(B34,7,1))","v":1},null,{"$f":"VALUE(MID(D34,7,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,33,"A","A",33,65,"A",10100011000,111323]
[null,null,{"$f":"VALUE(MID(B34,8,1))","v":0},null,{"$f":"VALUE(MID(D34,8,1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,34,"B","B",34,66,"B",10001011000,131123]
[null,null,{"$f":"VALUE(MID(B34,9,1))","v":1},null,{"$f":"VALUE(MID(D34,9,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,35,"C","C",35,67,"C",10001000110,131321]
[null,null,{"$f":"VALUE(MID(B34,10,1))","v":1},null,{"$f":"VALUE(MID(D34,10,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,36,"D","D",36,68,"D",10110001000,112313]
[null,null,{"$f":"VALUE(MID(B34,11,1))","v":0},null,{"$f":"VALUE(MID(D34,11,1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,37,"E","E",37,69,"E",10001101000,132113]
[null,{"$f":"MID($B$9,2,1)","v":"x"},{"$f":"VALUE(LEFT(B45,1))","v":1},{"$f":"MID(D$9,2,1)","v":"x"},{"$f":"VALUE(LEFT(D45,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,38,"F","F",38,70,"F",10001100010,132311]
[null,{"$f":"VLOOKUP(B44,$T$6:$Y$108,5,FALSE)","v":11100010110},{"$f":"VALUE(MID(B45,2,1))","v":1},{"$f":"VLOOKUP(D44,$T$6:$Y$108,5,FALSE)","v":11100010110},{"$f":"VALUE(MID(D45,2,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,39,"G","G",39,71,"G",11010001000,211313]
[null,"2",{"$f":"VALUE(MID(B45,3,1))","v":1},"2",{"$f":"VALUE(MID(D45,3,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,40,"H","H",40,72,"H",11000101000,231113]
[null,{"$f":"VLOOKUP(B44,$T$6:$Y$108,2,FALSE)","v":56},{"$f":"VALUE(MID(B45,4,1))","v":0},{"$f":"VLOOKUP(D44,$T$6:$Y$108,2,FALSE)","v":56},{"$f":"VALUE(MID(D45,4,1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,41,"I","I",41,73,"I",11000100010,231311]
[null,{"$f":"B46*B47","v":112},{"$f":"VALUE(MID(B45,5,1))","v":0},{"$f":"D46*D47","v":112},{"$f":"VALUE(MID(D45,5,1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,42,"J","J",42,74,"J",10110111000,112133]
[null,null,{"$f":"VALUE(MID(B45,6,1))","v":0},null,{"$f":"VALUE(MID(D45,6,1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,43,"K","K",43,75,"K",10110001110,112331]
[null,null,{"$f":"VALUE(MID(B45,7,1))","v":1},null,{"$f":"VALUE(MID(D45,7,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,44,"L","L",44,76,"L",10001101110,132131]
[null,null,{"$f":"VALUE(MID(B45,8,1))","v":0},null,{"$f":"VALUE(MID(D45,8,1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,45,"M","M",45,77,"M",10111011000,113123]
[null,null,{"$f":"VALUE(MID(B45,9,1))","v":1},null,{"$f":"VALUE(MID(D45,9,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,46,"N","N",46,78,"N",10111000110,113321]
[null,null,{"$f":"VALUE(MID(B45,10,1))","v":1},null,{"$f":"VALUE(MID(D45,10,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,47,"O","O",47,79,"O",10001110110,133121]
[null,null,{"$f":"VALUE(MID(B45,11,1))","v":0},null,{"$f":"VALUE(MID(D45,11,1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,48,"P","P",48,80,"P",11101110110,313121]
[null,{"$f":"MID($B$9,3,1)","v":"0"},{"$f":"VALUE(LEFT(B56,1))","v":1},{"$f":"MID(D$9,3,1)","v":"0"},{"$f":"VALUE(LEFT(D56,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,49,"Q","Q",49,81,"Q",11010001110,211331]
[null,{"$f":"VLOOKUP(B55,$T$6:$Y$108,5,FALSE)","v":10011101100},{"$f":"VALUE(MID(B56,2,1))","v":0},{"$f":"VLOOKUP(D55,$T$6:$Y$108,5,FALSE)","v":10011101100},{"$f":"VALUE(MID(D56,2,1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,50,"R","R",50,82,"R",11000101110,231131]
[null,{"$f":"B46+1","v":3},{"$f":"VALUE(MID(B56,3,1))","v":0},{"$f":"D46+1","v":3},{"$f":"VALUE(MID(D56,3,1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,51,"S","S",51,83,"S",11011101000,213113]
[null,{"$f":"VLOOKUP(B55,$T$6:$Y$108,2,FALSE)","v":16},{"$f":"VALUE(MID(B56,4,1))","v":1},{"$f":"VLOOKUP(D55,$T$6:$Y$108,2,FALSE)","v":16},{"$f":"VALUE(MID(D56,4,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,52,"T","T",52,84,"T",11011100010,213311]
[null,{"$f":"B57*B58","v":48},{"$f":"VALUE(MID(B56,5,1))","v":1},{"$f":"D57*D58","v":48},{"$f":"VALUE(MID(D56,5,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,53,"U","U",53,85,"U",11011101110,213131]
[null,null,{"$f":"VALUE(MID(B56,6,1))","v":1},null,{"$f":"VALUE(MID(D56,6,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,54,"V","V",54,86,"V",11101011000,311123]
[null,null,{"$f":"VALUE(MID(B56,7,1))","v":0},null,{"$f":"VALUE(MID(D56,7,1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,55,"W","W",55,87,"W",11101000110,311321]
[null,null,{"$f":"VALUE(MID(B56,8,1))","v":1},null,{"$f":"VALUE(MID(D56,8,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,56,"X","X",56,88,"X",11100010110,331121]
[null,null,{"$f":"VALUE(MID(B56,9,1))","v":1},null,{"$f":"VALUE(MID(D56,9,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,57,"Y","Y",57,89,"Y",11101101000,312113]
[null,null,{"$f":"VALUE(MID(B56,10,1))","v":0},null,{"$f":"VALUE(MID(D56,10,1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,58,"Z","Z",58,90,"Z",11101100010,312311]
[null,null,{"$f":"VALUE(MID(B56,11,1))","v":0},null,{"$f":"VALUE(MID(D56,11,1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,59,"[","[",59,91,"[",11100011010,332111]
[null,{"$f":"MID($B$9,4,1)","v":"1"},{"$f":"VALUE(LEFT(B67,1))","v":1},{"$f":"MID(D$9,4,1)","v":"2"},{"$f":"VALUE(LEFT(D67,1))","v":1},null,{"$f":"1+D66","v":3},null,null,null,null,null,null,null,null,null,null,60,"\\","\\",60,92,"\\",11101111010,314111]
[null,{"$f":"VLOOKUP(B66,$T$6:$Y$108,5,FALSE)","v":10011100110},{"$f":"VALUE(MID(B67,2,1))","v":0},{"$f":"VLOOKUP(D66,$T$6:$Y$108,5,FALSE)","v":11001110010},{"$f":"VALUE(MID(D67,2,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,61,"]","]",61,93,"]",11001000010,221411]
[null,{"$f":"B57+1","v":4},{"$f":"VALUE(MID(B67,3,1))","v":0},{"$f":"D57+1","v":4},{"$f":"VALUE(MID(D67,3,1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,62,"^","^",62,94,"^",11110001010,431111]
[null,{"$f":"VLOOKUP(B66,$T$6:$Y$108,2,FALSE)","v":17},{"$f":"VALUE(MID(B67,4,1))","v":1},{"$f":"VLOOKUP(D66,$T$6:$Y$108,2,FALSE)","v":18},{"$f":"VALUE(MID(D67,4,1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,63,"_","_",63,95,"_",10100110000,111224]
[null,{"$f":"B68*B69","v":68},{"$f":"VALUE(MID(B67,5,1))","v":1},{"$f":"D68*D69","v":72},{"$f":"VALUE(MID(D67,5,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,64,"NUL","`",64,96,"`",10100001100,111422]
[null,null,{"$f":"VALUE(MID(B67,6,1))","v":1},null,{"$f":"VALUE(MID(D67,6,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,65,"SOH","a",65,97,"a",10010110000,121124]
[null,null,{"$f":"VALUE(MID(B67,7,1))","v":0},null,{"$f":"VALUE(MID(D67,7,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,66,"STX","b",66,98,"b",10010000110,121421]
[null,null,{"$f":"VALUE(MID(B67,8,1))","v":0},null,{"$f":"VALUE(MID(D67,8,1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,67,"ETX","c",67,99,"c",10000101100,141122]
[null,null,{"$f":"VALUE(MID(B67,9,1))","v":1},null,{"$f":"VALUE(MID(D67,9,1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,68,"EOT","d",68,100,"d",10000100110,141221]
[null,null,{"$f":"VALUE(MID(B67,10,1))","v":1},null,{"$f":"VALUE(MID(D67,10,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,69,"ENQ","e",69,101,"e",10110010000,112214]
[null,null,{"$f":"VALUE(MID(B67,11,1))","v":0},null,{"$f":"VALUE(MID(D67,11,1))","v":0},null,null,null,null,"\"\"","\"\"",null,null,null,null,null,null,70,"ACK","f",70,102,"f",10110000100,112412]
[null,{"$f":"MID($B$9,5,1)","v":" "},{"$f":"VALUE(LEFT(B78,1))","v":1},{"$f":"MID(D$9,5,1)","v":" "},{"$f":"VALUE(LEFT(D78,1))","v":1},null,null,null,1,"a",{"$f":"VLOOKUP(D88,I77:J85,2,FALSE)","v":"d"},null,null,null,null,null,null,71,"BEL","g",71,103,"g",10011010000,122114]
[null,{"$f":"VLOOKUP(B77,$T$6:$Y$108,5,FALSE)","v":11011001100},{"$f":"VALUE(MID(B78,2,1))","v":1},{"$f":"VLOOKUP(D77,$T$6:$Y$108,5,FALSE)","v":11011001100},{"$f":"VALUE(MID(D78,2,1))","v":1},null,null,null,2,"b",null,null,null,null,null,null,null,72,"BS","h",72,104,"h",10011000010,122411]
[null,{"$f":"B68+1","v":5},{"$f":"VALUE(MID(B78,3,1))","v":0},{"$f":"D68+1","v":5},{"$f":"VALUE(MID(D78,3,1))","v":0},null,null,null,3,"c",null,null,null,null,null,null,null,73,"HT","i",73,105,"i",10000110100,142112]
[null,{"$f":"VLOOKUP(B77,$T$6:$Y$108,2,FALSE)","v":0},{"$f":"VALUE(MID(B78,4,1))","v":1},{"$f":"VLOOKUP(D77,$T$6:$Y$108,2,FALSE)","v":0},{"$f":"VALUE(MID(D78,4,1))","v":1},null,null,null," ","d",null,null,null,null,null,null,null,74,"LF","j",74,106,"j",10000110010,142211]
[null,{"$f":"B79*B80","v":0},{"$f":"VALUE(MID(B78,5,1))","v":1},{"$f":"D79*D80","v":0},{"$f":"VALUE(MID(D78,5,1))","v":1},null,null,null,5,"e",null,null,null,null,null,null,null,75,"VT","k",75,107,"k",11000010010,241211]
[null,null,{"$f":"VALUE(MID(B78,6,1))","v":0},null,{"$f":"VALUE(MID(D78,6,1))","v":0},null,null,null,6,"f",null,null,null,null,null,null,null,76,"FF","l",76,108,"l",11001010000,221114]
[null,null,{"$f":"VALUE(MID(B78,7,1))","v":0},null,{"$f":"VALUE(MID(D78,7,1))","v":0},null,null,null,7,"g",null,null,null,null,null,null,null,77,"CR","m",77,109,"m",11110111010,413111]
[null,null,{"$f":"VALUE(MID(B78,8,1))","v":1},null,{"$f":"VALUE(MID(D78,8,1))","v":1},null,null,null,8,"h",null,null,null,null,null,null,null,78,"SO","n",78,110,"n",11000010100,241112]
[null,null,{"$f":"VALUE(MID(B78,9,1))","v":1},null,{"$f":"VALUE(MID(D78,9,1))","v":1},null,null,null,8,"i",null,null,null,null,null,null,null,79,"SI","o",79,111,"o",10001111010,134111]
[null,null,{"$f":"VALUE(MID(B78,10,1))","v":0},null,{"$f":"VALUE(MID(D78,10,1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,80,"DLE","p",80,112,"p",10100111100,111242]
[null,null,{"$f":"VALUE(MID(B78,11,1))","v":0},null,{"$f":"VALUE(MID(D78,11,1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,81,"DC1","q",81,113,"q",10010111100,121142]
[null,{"$f":"MID($B$9,6,1)","v":" "},{"$f":"VALUE(LEFT(B89,1))","v":1},{"$f":"MID(D$9,6,1)","v":" "},{"$f":"VALUE(LEFT(D89,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,82,"DC2","r",82,114,"r",10010011110,121241]
[null,{"$f":"VLOOKUP(B88,$T$6:$Y$108,5,FALSE)","v":11011001100},{"$f":"VALUE(MID(B89,2,1))","v":1},{"$f":"VLOOKUP(D88,$T$6:$Y$108,5,FALSE)","v":11011001100},{"$f":"VALUE(MID(D89,2,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,83,"DC3","s",83,115,"s",10111100100,114212]
[null,{"$f":"B79+1","v":6},{"$f":"VALUE(MID(B89,3,1))","v":0},{"$f":"D79+1","v":6},{"$f":"VALUE(MID(D89,3,1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,84,"DC4","t",84,116,"t",10011110100,124112]
[null,{"$f":"VLOOKUP(B88,$T$6:$Y$108,2,FALSE)","v":0},{"$f":"VALUE(MID(B89,4,1))","v":1},{"$f":"VLOOKUP(D88,$T$6:$Y$108,2,FALSE)","v":0},{"$f":"VALUE(MID(D89,4,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,85,"NAK","u",85,117,"u",10011110010,124211]
[null,{"$f":"B90*B91","v":0},{"$f":"VALUE(MID(B89,5,1))","v":1},{"$f":"D90*D91","v":0},{"$f":"VALUE(MID(D89,5,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,86,"SYN","v",86,118,"v",11110100100,411212]
[null,null,{"$f":"VALUE(MID(B89,6,1))","v":0},null,{"$f":"VALUE(MID(D89,6,1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,87,"ETB","w",87,119,"w",11110010100,421112]
[null,null,{"$f":"VALUE(MID(B89,7,1))","v":0},null,{"$f":"VALUE(MID(D89,7,1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,88,"CAN","x",88,120,"x",11110010010,421211]
[null,null,{"$f":"VALUE(MID(B89,8,1))","v":1},null,{"$f":"VALUE(MID(D89,8,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,89,"EM","y",89,121,"y",11011011110,212141]
[null,null,{"$f":"VALUE(MID(B89,9,1))","v":1},null,{"$f":"VALUE(MID(D89,9,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,90,"SUB","z",90,122,"z",11011110110,214121]
[null,null,{"$f":"VALUE(MID(B89,10,1))","v":0},null,{"$f":"VALUE(MID(D89,10,1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,91,"ESC","{",91,123,"{",11110110110,412121]
[null,null,{"$f":"VALUE(MID(B89,11,1))","v":0},null,{"$f":"VALUE(MID(D89,11,1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,92,"FS","|",92,124,"|",10101111000,111143]
[null,{"$f":"MID($B$9,7,1)","v":" "},{"$f":"VALUE(LEFT(B100,1))","v":1},{"$f":"MID(D$9,7,1)","v":" "},{"$f":"VALUE(LEFT(D100,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,93,"GS","}",93,125,"}",10100011110,111341]
[null,{"$f":"VLOOKUP(B99,$T$6:$Y$108,5,FALSE)","v":11011001100},{"$f":"VALUE(MID(B100,2,1))","v":1},{"$f":"VLOOKUP(D99,$T$6:$Y$108,5,FALSE)","v":11011001100},{"$f":"VALUE(MID(D100,2,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,94,"RS","~",94,126,"~",10001011110,131141]
[null,{"$f":"B90+1","v":7},{"$f":"VALUE(MID(B100,3,1))","v":0},{"$f":"D90+1","v":7},{"$f":"VALUE(MID(D100,3,1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,95,"US","DEL",95,"200 / 240","È / ð",10111101000,114113]
[null,{"$f":"VLOOKUP(B99,$T$6:$Y$108,2,FALSE)","v":0},{"$f":"VALUE(MID(B100,4,1))","v":1},{"$f":"VLOOKUP(D99,$T$6:$Y$108,2,FALSE)","v":0},{"$f":"VALUE(MID(D100,4,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,96,"FNC 3","FNC 3",96,"201 / 241","É / ñ",10111100010,114311]
[null,{"$f":"B101*B102","v":0},{"$f":"VALUE(MID(B100,5,1))","v":1},{"$f":"D101*D102","v":0},{"$f":"VALUE(MID(D100,5,1))","v":1},null,"=",null,null,null,null,null,null,null,null,null,null,97,"FNC 2","FNC 2",97,"202 / 242","Ê / ò",11110101000,411113]
[null,null,{"$f":"VALUE(MID(B100,6,1))","v":0},null,{"$f":"VALUE(MID(D100,6,1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,98,"Shift B","Shift A",98,"203 / 243","Ë / ó",11110100010,411311]
[null,null,{"$f":"VALUE(MID(B100,7,1))","v":0},null,{"$f":"VALUE(MID(D100,7,1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,99,"Code C","Code C",99,"204 / 244","Ì / ô",10111011110,113141]
[null,null,{"$f":"VALUE(MID(B100,8,1))","v":1},null,{"$f":"VALUE(MID(D100,8,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,100,"Code B","FNC 4","Code B","205 / 245","Í / õ",10111101110,114131]
[null,null,{"$f":"VALUE(MID(B100,9,1))","v":1},null,{"$f":"VALUE(MID(D100,9,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,101,"FNC 4","Code A","Code A","206 / 246","Î / ö",11101011110,311141]
[null,null,{"$f":"VALUE(MID(B100,10,1))","v":0},null,{"$f":"VALUE(MID(D100,10,1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,102,"FNC 1","FNC 1","FNC 1","207 / 247","Ï / ÷",11110101110,411131]
[null,null,{"$f":"VALUE(MID(B100,11,1))","v":0},null,{"$f":"VALUE(MID(D100,11,1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,103,"Start Code A",null,null,"208 / 248","Ð / ø",11010000100,211412]
[null,"Checksum",{"$f":"VALUE(LEFT(B113,1))","v":1},"Checksum",{"$f":"VALUE(LEFT(D113,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,104,"Start Code B",null,null,"209 / 249","Ñ / ù",11010010000,211214]
[null,{"$f":"B26+B37+B48+B59+B70+B81+B92+B103","v":388},{"$f":"VALUE(MID(B113,2,1))","v":0},{"$f":"D26+D37+D48+D59+D70+D81+D92+D103","v":392},{"$f":"VALUE(MID(D113,2,1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,105,"Start Code C",null,null,"210 / 250","Ò / ú",11010011100,211232]
[null,{"$f":"MOD(B111,103)","v":79},{"$f":"VALUE(MID(B113,3,1))","v":0},{"$f":"MOD(D111,103)","v":83},{"$f":"VALUE(MID(D113,3,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,106,"Stop (7 bars/spaces)",null,null,"211 / 251","Ó / û","1100011101011",2331112]
[null,{"$f":"VLOOKUP(B112,$R$6:$Y$108,7,FALSE)","v":10001111010},{"$f":"VALUE(MID(B113,4,1))","v":0},{"$f":"VLOOKUP(D112,$R$6:$Y$108,7,FALSE)","v":10111100100},{"$f":"VALUE(MID(D113,4,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,"—","Reverse Stop",null,null,"—","—",11010111000,211133]
[null,null,{"$f":"VALUE(MID(B113,5,1))","v":1},null,{"$f":"VALUE(MID(D113,5,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,"used to detect reading right to left"]
[null,null,{"$f":"VALUE(MID(B113,6,1))","v":1},null,{"$f":"VALUE(MID(D113,6,1))","v":1}]
[null,null,{"$f":"VALUE(MID(B113,7,1))","v":1},null,{"$f":"VALUE(MID(D113,7,1))","v":0}]
[null,null,{"$f":"VALUE(MID(B113,8,1))","v":1},null,{"$f":"VALUE(MID(D113,8,1))","v":0}]
[null,null,{"$f":"VALUE(MID(B113,9,1))","v":0},null,{"$f":"VALUE(MID(D113,9,1))","v":1}]
[null,null,{"$f":"VALUE(MID(B113,10,1))","v":1},null,{"$f":"VALUE(MID(D113,10,1))","v":0}]
[null,null,{"$f":"VALUE(MID(B113,11,1))","v":0},null,{"$f":"VALUE(MID(D113,11,1))","v":0}]
[null,"Stop",{"$f":"VALUE(LEFT(B122,1))","v":1},"Stop",{"$f":"VALUE(LEFT(D122,1))","v":1}]
[null,"1100011101011",{"$f":"VALUE(MID(B122,2,1))","v":1},"1100011101011",{"$f":"VALUE(MID(D122,2,1))","v":1}]
[null,null,{"$f":"VALUE(MID(B122,3,1))","v":0},null,{"$f":"VALUE(MID(D122,3,1))","v":0}]
[null,null,{"$f":"VALUE(MID(B122,4,1))","v":0},null,{"$f":"VALUE(MID(D122,4,1))","v":0}]
[null,null,{"$f":"VALUE(MID(B122,5,1))","v":0},null,{"$f":"VALUE(MID(D122,5,1))","v":0}]
[null,null,{"$f":"VALUE(MID(B122,6,1))","v":1},null,{"$f":"VALUE(MID(D122,6,1))","v":1}]
[null,null,{"$f":"VALUE(MID(B122,7,1))","v":1},null,{"$f":"VALUE(MID(D122,7,1))","v":1}]
[null,null,{"$f":"VALUE(MID(B122,8,1))","v":1},null,{"$f":"VALUE(MID(D122,8,1))","v":1}]
[null,null,{"$f":"VALUE(MID(B122,9,1))","v":0},null,{"$f":"VALUE(MID(D122,9,1))","v":0}]
[null,null,{"$f":"VALUE(MID(B122,10,1))","v":1},null,{"$f":"VALUE(MID(D122,10,1))","v":1}]
[null,null,{"$f":"VALUE(MID(B122,11,1))","v":0},null,{"$f":"VALUE(MID(D122,11,1))","v":0}]
[null,null,{"$f":"VALUE(MID(B122,12,1))","v":1},null,{"$f":"VALUE(MID(D122,12,1))","v":1}]
[null,null,{"$f":"VALUE(MID(B122,13,1))","v":1},null,{"$f":"VALUE(MID(D122,13,1))","v":1}]
[null,"Blank",0,"Blank",0]
[null,"0000000000",0,"0000000000",0]
[null,null,0,null,0]
[null,null,0,null,0]
[null,null,0,null,0]
[null,null,0,null,0]
[null,null,0,null,0]
[null,null,0,null,0]
[null,null,0,null,0]
[null,null,0,null,0]
[null,null,0,null,0]