{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Machine","Examples","Machine setup"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":3,"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":"Machine","index":0,"n_rows":39,"n_cols":36,"rows_kept":39,"cut":false,"hidden":false,"merged":[[7,28,7,31],[4,28,4,31],[2,28,2,31],[3,28,3,31],[5,28,5,31],[6,28,6,31]]}
[]
[null,null,"German Army Enigma Machine",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chris Rae (chrisrae.com)",null,null,"Hover over comment tags to read:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Why? Why, why why?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Where did you get the specs?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"How does it work?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"How well does it work?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"What can I edit?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Is it all cunning macros?"]
[]
[]
[null,null,null,null,{"$f":"FIND(LOWER(F11),AI13)","v":13},{"$f":"AD14","v":"m"},null,{"$f":"FIND(LOWER(I11),AI13)","v":22},{"$f":"AD15","v":"v"},null,{"$f":"FIND(LOWER(L11),AI13)","v":17},{"$f":"AD16","v":"q"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ring"]
[null,{"$f":"MID($AJ$17,MOD(ROW()-2,26)+1,1)","v":"n"},{"$f":"MID($AI$17,MOD(ROW()-2,26)+1,1)","v":"k"},{"$f":"MATCH(OFFSET(F$12:F$37,G12-1,0,1,1),E$12:E$37,FALSE)","v":10},{"$f":"MID($AI$14,MOD(ROW()+E$11-$AF$14-2,26)+1,1)","v":"z"},{"$f":"MID($AJ$14,MOD(ROW()+E$11-$AF$14-2,26)+1,1)","v":"b"},{"$f":"MATCH(OFFSET(I$12:I$37,J12-1,0,1,1),H$12:H$37,FALSE)","v":13},{"$f":"MID($AI$15,MOD(ROW()+H$11-$AF$15-2,26)+1,1)","v":"o"},{"$f":"MID($AJ$15,MOD(ROW()+H$11-$AF$15-2,26)+1,1)","v":"l"},{"$f":"MATCH(OFFSET(L$12:L$37,M12-1,0,1,1),K$12:K$37,FALSE)","v":3},{"$f":"MID($AI$16,MOD(ROW()+K$11-$AF$16-2,26)+1,1)","v":"f"},{"$f":"MID($AJ$16,MOD(ROW()+K$11-$AF$16-2,26)+1,1)","v":"l"},{"$f":"MATCH(InLet,O12:O37,FALSE)","v":25},{"$f":"UPPER(MID($AI$13,MOD(ROW()-2,26)+1,1))","v":"K"},{"$f":"IF(ISNA(MATCH(N12,R$26:R$37,FALSE)),IF(ISNA(MATCH(N12,S$26:S$37,FALSE)),N12,OFFSET(R$26:R$37,MATCH(N12,S$26:S$37,FALSE)-1,0,1,1)),OFFSET(S$26:S$37,MATCH(N12,R$26:R$37,FALSE)-1,0,1,1))","v":"E"},"B",null,"Bulbs",null,null,null,null,null,null,null,null,null,null,"Item"," Position"," Ring","Num","Rotor","Knock-on","Wire from","Wire to"]
[null,"g","l",null,"a","e",null,"p","x",null,"g","c",null,"L","W",null,null,"Q","W","E","R","T","Z","U","I","O",null,null,"entry disc","N/A","N/A","N/A","N/A","N/A","abcdefghijklmnopqrstuvwxyz"]
[null,"o","m",null,"b","s",null,"q","a",null,"h","p",null,"M","J",null,null,null,"A","S","D","F","G","H","J","K",null,null,"left","m","x",{"$f":"FIND(LOWER(AE14),$AI$13)","v":24},"IV",{"$f":"VLOOKUP(AG14,'Machine setup'!$B$3:$F$12,4,FALSE)","v":"k"},{"$f":"VLOOKUP(AG14,'Machine setup'!$B$3:$E$7,2,FALSE)","v":"abcdefghijklmnopqrstuvwxyz"},{"$f":"VLOOKUP(AG14,'Machine setup'!$B$3:$E$7,3,FALSE)","v":"esovpzjayquirhxlnftgkdcmwb"}]
[null,"k","n",null,"c","o",null,"r","w",null,"i","r",null,"N","Z",null,null,"P","Y","X","C","V","B","N","M","L",null,null,"middle","p","r",{"$f":"FIND(LOWER(AE15),$AI$13)","v":18},"V",{"$f":"VLOOKUP(AG15,'Machine setup'!$B$3:$F$12,4,FALSE)","v":"a"},{"$f":"VLOOKUP(AG15,'Machine setup'!$B$3:$E$7,2,FALSE)","v":"abcdefghijklmnopqrstuvwxyz"},{"$f":"VLOOKUP(AG15,'Machine setup'!$B$3:$E$7,3,FALSE)","v":"vzbrgityupsdnhlxawmjqofeck"}]
[null,"m","o",null,"d","v",null,"s","m",null,"j","t",null,"O","R",null,null,null,null,null,null,null,null,null,null,null,null,null,"right","y","v",{"$f":"FIND(LOWER(AE16),$AI$13)","v":22},"III",{"$f":"VLOOKUP(AG16,'Machine setup'!$B$3:$F$12,4,FALSE)","v":"w"},{"$f":"VLOOKUP(AG16,'Machine setup'!$B$3:$E$7,2,FALSE)","v":"abcdefghijklmnopqrstuvwxyz"},{"$f":"VLOOKUP(AG16,'Machine setup'!$B$3:$E$7,3,FALSE)","v":"bdfhjlcprtxvznyeiwgakmusqo"}]
[null,"i","p",null,"e","p",null,"t","j",null,"k","x",null,"P","V",null,null,null,null,null,null,null,null,null,null,null,null,null,"reflector","N/A","N/A","N/A","B","N/A",{"$f":"VLOOKUP(AG17,'Machine setup'!$B$10:$D$11,2,FALSE)","v":"abcdefghijklmnopqrstuvwxyz"},{"$f":"VLOOKUP(AG17,'Machine setup'!$B$10:$D$11,3,FALSE)","v":"yruhqsldpxngokmiebfzcwvjat"}]
[null,"e","q",null,"f","z",null,"u","q",null,"l","v",null,"Q","U",null,null,"Keyboard"]
[null,"b","r",null,"g","j",null,"v","o",null,"m","z",null,"R","O"]
[null,"f","s",null,"h","a",null,"w","f",null,"n","n",null,"S","Y"]
[null,"z","t",null,"i","y",null,"x","e",null,"o","y",null,"T","T"]
[null,"c","u",null,"j","q",null,"y","c",null,"p","e",null,"U","Q"]
[null,"w","v",null,"k","u",null,"z","k",null,"q","i",null,"V","P"]
[null,"v","w",null,"l","i",null,"a","v",null,"r","w",null,"W","L",null,null,"Stecker (Plug Board)"]
[null,"j","x",null,"m","r",null,"b","z",null,"s","g",null,"X","X",null,null," From"," To"]
[null,"a","y",null,"n","h",null,"c","b",null,"t","a",null,"Y","S",null,1,"S","Y",null,"There isn't much error checking in the"]
[null,"t","z",null,"o","x",null,"d","r",null,"u","k",null,"Z","N",null,{"$f":"Q26+1","v":2},"E","K",null,"stecker, so make sure they're right."]
[null,"y","a",null,"p","l",null,"e","g",null,"v","m",null,"A","A",null,{"$f":"Q27+1","v":3},"N","Z"]
[null,"r","b",null,"q","n",null,"f","i",null,"w","u",null,"B","I",null,4,"O","R"]
[null,"u","c",null,"r","f",null,"g","t",null,"x","s",null,"C","G",null,5,"C","G"]
[null,"h","d",null,"s","t",null,"h","y",null,"y","q",null,"D","D",null,6,"J","M"]
[null,"q","e",null,"t","g",null,"i","u",null,"z","o",null,"E","K",null,7,"Q","U"]
[null,"s","f",null,"u","k",null,"j","p",null,"a","b",null,"F","F",null,8,"P","V"]
[null,"l","g",null,"v","d",null,"k","s",null,"b","d",null,"G","C",null,9,"B","I",null,"Text in:","UFJZS NKIRA CGTPF UONXD GQMPU QXUGF OWEZS TCBJD JLFME AZQRM NZZYI CGSSR YOFQX ADSPU QIMXM MELYR XKXYI MDEEW ISKDP RSTFR TCOKB GGQTQ KPKMP NCCGH YUVJO TIVMA IVIGK WQKWJ FOYMR VFBVY RKEZF SYCBY QQSOQ CIZUU SUTB"]
[null,"d","h",null,"w","c",null,"l","d",null,"c","f",null,"H","H",null,{"$f":"Q34+1","v":10},"L","W",null,"Text out:"]
[null,"p","i",null,"x","m",null,"m","n",null,"d","h",null,"I","B",null,{"$f":"Q35+1","v":11}]
[null,"x","j",{"$f":"MATCH(OFFSET(C$12:C$37,D12-1,0,1,1),B$12:B$37,FALSE)","v":16},"y","w",{"$f":"MATCH(OFFSET(E$12:E$37,D37-1,0,1,1),F$12:F$37,FALSE)","v":4},"n","h",{"$f":"MATCH(OFFSET(H$12:H$37,G37-1,0,1,1),I$12:I$37,FALSE)","v":16},"e","j",{"$f":"MATCH(OFFSET(K$12:K$37,J37-1,0,1,1),L$12:L$37,FALSE)","v":18},"J","M",{"$f":"UPPER(OFFSET(O$12:O$37,M37-1,0,1,1))","v":"I"},{"$f":"Q36+1","v":12}]
[]
[null,{"$f":"\"Setting: \" & $AG$17","v":"Setting: B"},"Reflector",null,{"$f":"\"Setting: \" & $AG$14","v":"Setting: IV"},"Left rotor",null,{"$f":"\"Setting: \" & $AG$15","v":"Setting: V"},"Middle rotor",null,{"$f":"\"Setting: \" & $AG$16","v":"Setting: III"},"Right rotor",null,"Entry disc","Stecker"]

{"sheet":"Examples","index":1,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Some examples:"]
[]
["From","URL","Rotors","Reflector","Ring settings","Rotor settings","Plugboard","Message"]
["Tony Sale's \"Enigma\" film codes","http://www.codesandciphers.org.uk/index.htm","III, V, IV","B","RXO","XAT","NP JV LY IX KQ AO DZ CR FT EM","YEWUM VQIGC ZTHOK JEOFJ ZXKDA IGUEN XDFMJ XPFUF VVBJM BZQPQ BDWSY BZXGF UPHHG QWDZX AYQGO HGAOF WBWEE EKNAI LJW"]
[]
["Codebreaking and Secret Weapons","http://home.earthlink.net/~nbrass1/1enigma.htm","II, I, III","B","ZWD","AGI","EZ, BL, XP, WR, IU, VM, JO ","QKRQ WUQTZ KFXZO MJFOY RHYZW VBXYS IWMMV WBLEB DMWUW BTVHM RFLKS DCCEX IYPAH RMPZI OVBBR VLNHZ UPOSY EIPWJ TUGYO SLAOX RHKVC HQOSV DTRBP DJEUK SBBXH TYGVH GFICA CVGUV OQFAQ WBKXZ JSQJF ZPEVJ RO "]
[null,null,null,null,null,"YBE",null,"YBDO DMVWQ KWJPZ OCZJW XOFWP XWGAR KLRLX TOFCD SZHEV INQWI NRMBS QPTCK LKCQR MTYVG UQODM EIEUT VSQFI MWORP RPLHG XKMCM PASOM YRORP CVICA HUEAF BZNVR VZWXX MTWOE GIEBS ZZQIU JAPGN FJXDK I"]
[null,null,null,null,null,"LUN",null,"WQQM BMHTT YFBHK YYXJK IXKDF RTSHB HLUEJ MFLAC ZRJDL CJZVK HFBYL GFSEW NRSGS KHLFW JKLLZ TFMWD QDQQV JUTJS VPRDE MUVPM BPBXX USOPG IVHFC ISGPY IYKST VQUIO CAVCW AKEQQ EFRVM XSLQC FPFTF SPIIU ENLUW"]
[]
[null,null,"IV, V, III","B","XRV","MPY","SY, EK, NZ, OR, CG, JM, QU, PV, BI, LW","UFJZS NKIRA CGTPF UONXD GQMPU QXUGF OWEZS TCBJD JLFME AZQRM NZZYI CGSSR YOFQX ADSPU QIMXM MELYR XKXYI MDEEW ISKDP RSTFR TCOKB GGQTQ KPKMP NCCGH YUVJO TIVMA IVIGK WQKWJ FOYMR VFBVY RKEZF SYCBY QQSOQ CIZUU SUTB"]

{"sheet":"Machine setup","index":2,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Rotor","Wire From","Wire to","Knock-on"]
[null,"I","abcdefghijklmnopqrstuvwxyz","ekmflgdqvzntowyhxuspaibrcj","r"]
[null,"II","abcdefghijklmnopqrstuvwxyz","ajdksiruxblhwtmcqgznpyfvoe","f"]
[null,"III","abcdefghijklmnopqrstuvwxyz","bdfhjlcprtxvznyeiwgakmusqo","w"]
[null,"IV","abcdefghijklmnopqrstuvwxyz","esovpzjayquirhxlnftgkdcmwb","k"]
[null,"V","abcdefghijklmnopqrstuvwxyz","vzbrgityupsdnhlxawmjqofeck","a"]
[]
[null,"Reflector","Wire From","Wire to"]
[null,"B","abcdefghijklmnopqrstuvwxyz","yruhqsldpxngokmiebfzcwvjat"]
[null,"C","abcdefghijklmnopqrstuvwxyz","fvpjiaoyedrzxwgctkuqsbnmhl"]