{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Index","Defaults","How to use this workbook","SQL Base","SQL Out","All index text out"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":6,"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":"Index","index":0,"n_rows":1302,"n_cols":9,"rows_kept":1302,"cut":false,"hidden":false,"merged":[]}
["Page no","Index part 2 Index part 1",1,"Index part 2 Index part","Person","Chapter","Number\nignore","Seq No"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,1]

{"sheet":"Defaults","index":1,"n_rows":60,"n_cols":10,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
["Last row","Levels","no_levels","size_bunch",null,1,{"$f":"\"If no_levels >= \"&TEXT(F1,\"#\")&\" Then\"","v":"If no_levels >= 1 Then"},null,1,{"$f":"\"Private Sub CommandButton\"&TEXT(I1,\"0\")&\"_Click()\"","v":"Private Sub CommandButton1_Click()"}]
[{"$f":"COUNTA(Index!B:B)","v":1},"Person",{"$f":"COUNTA(B:B)-1","v":9},5000,null,null,{"$f":"+\"    CommandButton\"&TEXT(F1+1,\"#\")&\".Caption = levels(\"&TEXT(F1,\"#\")&\")\"","v":"    CommandButton2.Caption = levels(1)"},null,null,{"$f":"\"my_sel = \"&TEXT(I1-1,\"0\")","v":"my_sel = 0"}]
[null,"Place",null,null,null,null,{"$f":"+\"    CommandButton\"&TEXT(F1+1,\"#\")&\".Visible = True\"","v":"    CommandButton2.Visible = True"},null,null,"Howtoindex.Hide"]
[null,"Author",null,null,null,null,"Else",null,null,"End Sub"]
[null,"Article title",null,null,null,null,{"$f":"\"    CommandButton\"&TEXT(F1+1,\"#\")&\".Visible = False\"","v":"    CommandButton2.Visible = False"},null,{"$f":"1+I1","v":2},{"$f":"\"Private Sub CommandButton\"&TEXT(I5,\"0\")&\"_Click()\"","v":"Private Sub CommandButton2_Click()"}]
[null,"Event",null,null,null,null,"End If",null,null,{"$f":"\"my_sel = \"&TEXT(I5-1,\"0\")","v":"my_sel = 1"}]
[null,"Ship",null,null,null,{"$f":"1+F1","v":2},{"$f":"\"If no_levels >= \"&TEXT(F7,\"#\")&\" Then\"","v":"If no_levels >= 2 Then"},null,null,"Howtoindex.Hide"]
[null,"Publication",null,null,null,null,{"$f":"+\"    CommandButton\"&TEXT(F7+1,\"#\")&\".Caption = levels(\"&TEXT(F7,\"#\")&\")\"","v":"    CommandButton3.Caption = levels(2)"},null,null,"End Sub"]
[null,"Institution",null,null,null,null,{"$f":"+\"    CommandButton\"&TEXT(F7+1,\"#\")&\".Visible = True\"","v":"    CommandButton3.Visible = True"},null,{"$f":"1+I5","v":3},{"$f":"\"Private Sub CommandButton\"&TEXT(I9,\"0\")&\"_Click()\"","v":"Private Sub CommandButton3_Click()"}]
[null,"Other",null,null,null,null,"Else",null,null,{"$f":"\"my_sel = \"&TEXT(I9-1,\"0\")","v":"my_sel = 2"}]
[null,null,null,null,null,null,{"$f":"\"    CommandButton\"&TEXT(F7+1,\"#\")&\".Visible = False\"","v":"    CommandButton3.Visible = False"},null,null,"Howtoindex.Hide"]
[null,null,null,null,null,null,"End If",null,null,"End Sub"]
[null,null,null,null,null,{"$f":"1+F7","v":3},{"$f":"\"If no_levels >= \"&TEXT(F13,\"#\")&\" Then\"","v":"If no_levels >= 3 Then"},null,{"$f":"1+I9","v":4},{"$f":"\"Private Sub CommandButton\"&TEXT(I13,\"0\")&\"_Click()\"","v":"Private Sub CommandButton4_Click()"}]
[null,null,null,null,null,null,{"$f":"+\"    CommandButton\"&TEXT(F13+1,\"#\")&\".Caption = levels(\"&TEXT(F13,\"#\")&\")\"","v":"    CommandButton4.Caption = levels(3)"},null,null,{"$f":"\"my_sel = \"&TEXT(I13-1,\"0\")","v":"my_sel = 3"}]
[null,null,null,null,null,null,{"$f":"+\"    CommandButton\"&TEXT(F13+1,\"#\")&\".Visible = True\"","v":"    CommandButton4.Visible = True"},null,null,"Howtoindex.Hide"]
[null,null,null,null,null,null,"Else",null,null,"End Sub"]
[null,null,null,null,null,null,{"$f":"\"    CommandButton\"&TEXT(F13+1,\"#\")&\".Visible = False\"","v":"    CommandButton4.Visible = False"},null,{"$f":"1+I13","v":5},{"$f":"\"Private Sub CommandButton\"&TEXT(I17,\"0\")&\"_Click()\"","v":"Private Sub CommandButton5_Click()"}]
[null,null,null,null,null,null,"End If",null,null,{"$f":"\"my_sel = \"&TEXT(I17-1,\"0\")","v":"my_sel = 4"}]
[null,null,null,null,null,{"$f":"1+F13","v":4},{"$f":"\"If no_levels >= \"&TEXT(F19,\"#\")&\" Then\"","v":"If no_levels >= 4 Then"},null,null,"Howtoindex.Hide"]
[null,null,null,null,null,null,{"$f":"+\"    CommandButton\"&TEXT(F19+1,\"#\")&\".Caption = levels(\"&TEXT(F19,\"#\")&\")\"","v":"    CommandButton5.Caption = levels(4)"},null,null,"End Sub"]
[null,null,null,null,null,null,{"$f":"+\"    CommandButton\"&TEXT(F19+1,\"#\")&\".Visible = True\"","v":"    CommandButton5.Visible = True"},null,{"$f":"1+I17","v":6},{"$f":"\"Private Sub CommandButton\"&TEXT(I21,\"0\")&\"_Click()\"","v":"Private Sub CommandButton6_Click()"}]
[null,null,null,null,null,null,"Else",null,null,{"$f":"\"my_sel = \"&TEXT(I21-1,\"0\")","v":"my_sel = 5"}]
[null,null,null,null,null,null,{"$f":"\"    CommandButton\"&TEXT(F19+1,\"#\")&\".Visible = False\"","v":"    CommandButton5.Visible = False"},null,null,"Howtoindex.Hide"]
[null,null,null,null,null,null,"End If",null,null,"End Sub"]
[null,null,null,null,null,{"$f":"1+F19","v":5},{"$f":"\"If no_levels >= \"&TEXT(F25,\"#\")&\" Then\"","v":"If no_levels >= 5 Then"},null,{"$f":"1+I21","v":7},{"$f":"\"Private Sub CommandButton\"&TEXT(I25,\"0\")&\"_Click()\"","v":"Private Sub CommandButton7_Click()"}]
[null,null,null,null,null,null,{"$f":"+\"    CommandButton\"&TEXT(F25+1,\"#\")&\".Caption = levels(\"&TEXT(F25,\"#\")&\")\"","v":"    CommandButton6.Caption = levels(5)"},null,null,{"$f":"\"my_sel = \"&TEXT(I25-1,\"0\")","v":"my_sel = 6"}]
[null,null,null,null,null,null,{"$f":"+\"    CommandButton\"&TEXT(F25+1,\"#\")&\".Visible = True\"","v":"    CommandButton6.Visible = True"},null,null,"Howtoindex.Hide"]
[null,null,null,null,null,null,"Else",null,null,"End Sub"]
[null,null,null,null,null,null,{"$f":"\"    CommandButton\"&TEXT(F25+1,\"#\")&\".Visible = False\"","v":"    CommandButton6.Visible = False"},null,{"$f":"1+I25","v":8},{"$f":"\"Private Sub CommandButton\"&TEXT(I29,\"0\")&\"_Click()\"","v":"Private Sub CommandButton8_Click()"}]
[null,null,null,null,null,null,"End If",null,null,{"$f":"\"my_sel = \"&TEXT(I29-1,\"0\")","v":"my_sel = 7"}]
[null,null,null,null,null,{"$f":"1+F25","v":6},{"$f":"\"If no_levels >= \"&TEXT(F31,\"#\")&\" Then\"","v":"If no_levels >= 6 Then"},null,null,"Howtoindex.Hide"]
[null,null,null,null,null,null,{"$f":"+\"    CommandButton\"&TEXT(F31+1,\"#\")&\".Caption = levels(\"&TEXT(F31,\"#\")&\")\"","v":"    CommandButton7.Caption = levels(6)"},null,null,"End Sub"]
[null,null,null,null,null,null,{"$f":"+\"    CommandButton\"&TEXT(F31+1,\"#\")&\".Visible = True\"","v":"    CommandButton7.Visible = True"},null,{"$f":"1+I29","v":9},{"$f":"\"Private Sub CommandButton\"&TEXT(I33,\"0\")&\"_Click()\"","v":"Private Sub CommandButton9_Click()"}]
[null,null,null,null,null,null,"Else",null,null,{"$f":"\"my_sel = \"&TEXT(I33-1,\"0\")","v":"my_sel = 8"}]
[null,null,null,null,null,null,{"$f":"\"    CommandButton\"&TEXT(F31+1,\"#\")&\".Visible = False\"","v":"    CommandButton7.Visible = False"},null,null,"Howtoindex.Hide"]
[null,null,null,null,null,null,"End If",null,null,"End Sub"]
[null,null,null,null,null,{"$f":"1+F31","v":7},{"$f":"\"If no_levels >= \"&TEXT(F37,\"#\")&\" Then\"","v":"If no_levels >= 7 Then"},null,{"$f":"1+I33","v":10},{"$f":"\"Private Sub CommandButton\"&TEXT(I37,\"0\")&\"_Click()\"","v":"Private Sub CommandButton10_Click()"}]
[null,null,null,null,null,null,{"$f":"+\"    CommandButton\"&TEXT(F37+1,\"#\")&\".Caption = levels(\"&TEXT(F37,\"#\")&\")\"","v":"    CommandButton8.Caption = levels(7)"},null,null,{"$f":"\"my_sel = \"&TEXT(I37-1,\"0\")","v":"my_sel = 9"}]
[null,null,null,null,null,null,{"$f":"+\"    CommandButton\"&TEXT(F37+1,\"#\")&\".Visible = True\"","v":"    CommandButton8.Visible = True"},null,null,"Howtoindex.Hide"]
[null,null,null,null,null,null,"Else",null,null,"End Sub"]
[null,null,null,null,null,null,{"$f":"\"    CommandButton\"&TEXT(F37+1,\"#\")&\".Visible = False\"","v":"    CommandButton8.Visible = False"},null,{"$f":"1+I37","v":11},{"$f":"\"Private Sub CommandButton\"&TEXT(I41,\"0\")&\"_Click()\"","v":"Private Sub CommandButton11_Click()"}]
[null,null,null,null,null,null,"End If",null,null,{"$f":"\"my_sel = \"&TEXT(I41-1,\"0\")","v":"my_sel = 10"}]
[null,null,null,null,null,{"$f":"1+F37","v":8},{"$f":"\"If no_levels >= \"&TEXT(F43,\"#\")&\" Then\"","v":"If no_levels >= 8 Then"},null,null,"Howtoindex.Hide"]
[null,null,null,null,null,null,{"$f":"+\"    CommandButton\"&TEXT(F43+1,\"#\")&\".Caption = levels(\"&TEXT(F43,\"#\")&\")\"","v":"    CommandButton9.Caption = levels(8)"},null,null,"End Sub"]
[null,null,null,null,null,null,{"$f":"+\"    CommandButton\"&TEXT(F43+1,\"#\")&\".Visible = True\"","v":"    CommandButton9.Visible = True"}]
[null,null,null,null,null,null,"Else"]
[null,null,null,null,null,null,{"$f":"\"    CommandButton\"&TEXT(F43+1,\"#\")&\".Visible = False\"","v":"    CommandButton9.Visible = False"}]
[null,null,null,null,null,null,"End If"]
[null,null,null,null,null,{"$f":"1+F43","v":9},{"$f":"\"If no_levels >= \"&TEXT(F49,\"#\")&\" Then\"","v":"If no_levels >= 9 Then"}]
[null,null,null,null,null,null,{"$f":"+\"    CommandButton\"&TEXT(F49+1,\"#\")&\".Caption = levels(\"&TEXT(F49,\"#\")&\")\"","v":"    CommandButton10.Caption = levels(9)"}]
[null,null,null,null,null,null,{"$f":"+\"    CommandButton\"&TEXT(F49+1,\"#\")&\".Visible = True\"","v":"    CommandButton10.Visible = True"}]
[null,null,null,null,null,null,"Else"]
[null,null,null,null,null,null,{"$f":"\"    CommandButton\"&TEXT(F49+1,\"#\")&\".Visible = False\"","v":"    CommandButton10.Visible = False"}]
[null,null,null,null,null,null,"End If"]
[null,null,null,null,null,{"$f":"1+F49","v":10},{"$f":"\"If no_levels >= \"&TEXT(F55,\"#\")&\" Then\"","v":"If no_levels >= 10 Then"}]
[null,null,null,null,null,null,{"$f":"+\"    CommandButton\"&TEXT(F55+1,\"#\")&\".Caption = levels(\"&TEXT(F55,\"#\")&\")\"","v":"    CommandButton11.Caption = levels(10)"}]
[null,null,null,null,null,null,{"$f":"+\"    CommandButton\"&TEXT(F55+1,\"#\")&\".Visible = True\"","v":"    CommandButton11.Visible = True"}]
[null,null,null,null,null,null,"Else"]
[null,null,null,null,null,null,{"$f":"\"    CommandButton\"&TEXT(F55+1,\"#\")&\".Visible = False\"","v":"    CommandButton11.Visible = False"}]
[null,null,null,null,null,null,"End If"]

{"sheet":"How to use this workbook","index":2,"n_rows":9,"n_cols":1,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["How to use this workbook"]
["This work book is set up to process information in the clipboad.  You select some text in a PDF file then go to this workbook and press {ctrl}{shift}D to start a menu selection process."]
["You can use {alt}{tab} to move between windows.  The selection prcesses are set up so you can mahe selections using {tab} key.  This makes the indexing very quick."]
["Up to 10 first level index terms can be set on the \"Defaults\" worksheet.  The buttons appear in the order the levels are in the column on the \"Defaults\" worksheet."]
["The second selection process allows you to split a name so that the family name appears in the \"Index Text\" column and the \"Index Text 2\"  column."]
["You can edit entries in the index if the automated processes do not give what is needed."]
["You can type the entry to be indexed in a cell in column B and press {shift}{ctrl}S to index it."]
["Typing an term in both colum C and D and then pressing {shift}{ctrl}M will index them and provide merged text in column B."]
["Try it out and let me know of any issues."]

{"sheet":"SQL Base","index":3,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"CREATE TABLE TAS_new (",{"$f":"\"INSERT INTO TAS_new (\"","v":"INSERT INTO TAS_new ("}]
[0,"Idx_no","Idx_no",{"$f":"C3&\" INT NOT NULL AUTO_INCREMENT PRIMARY KEY, \"","v":"Idx_no INT NOT NULL AUTO_INCREMENT PRIMARY KEY, "},{"$f":"C3&\", \"","v":"Idx_no, "}]
[1,"Page no",{"$f":"SUBSTITUTE(B4,\" \",\"_\")","v":"Page_no"},{"$f":"C4&\" TEXT, \"","v":"Page_no TEXT, "},{"$f":"C4&\", \"","v":"Page_no, "}]
[2,"Raw text",{"$f":"SUBSTITUTE(B5,\" \",\"_\")","v":"Raw_text"},{"$f":"C5&\" TEXT, \"","v":"Raw_text TEXT, "},"Raw_text, "]
[3,"Index pt 1","Index_pt_1","Index_pt_1 TEXT, ","Index_pt_1, "]
[4,"Index pt 2","Index_pt_2","Index_pt_2 TEXT, ","Index_pt_2, "]
[5,"Limit_search","Limit_search","Limit_search TEXT, ","Limit_search, "]
[6,"Volume","Volume","Volume TEXT, ","Volume, "]
[7,"Number","Number",{"$f":"C10&\" TEXT) DEFAULT CHARACTER SET UTF8;\"","v":"Number TEXT) DEFAULT CHARACTER SET UTF8;"},{"$f":"C10&\") VALUES (\"","v":"Number) VALUES ("}]
[]
[null,null,null,{"$f":"D2&D3&D4&D5&D6&D7&D8&D9&D10","v":"CREATE TABLE TAS_new (Idx_no INT NOT NULL AUTO_INCREMENT PRIMARY KEY, Page_no TEXT, Raw_text TEXT, Index_pt_1 TEXT, Index_pt_2 TEXT, Limit_search TEXT, Volume TEXT, Number TEXT) DEFAULT CHARACTER SET UTF8;"},{"$f":"E2&E3&E4&E5&E6&E7&E8&E9&E10","v":"INSERT INTO TAS_new (Idx_no, Page_no, Raw_text, Index_pt_1, Index_pt_2, Limit_search, Volume, Number) VALUES ("}]
[]
[]
[null,"Article title"]
[null,"Author"]
[null,"Event"]
[null,"Institution"]
[null,"Other"]
[null,"Person"]
[null,"Place"]
[null,"Publication"]
[null,"Ship"]

{"sheet":"SQL Out","index":4,"n_rows":1,"n_cols":5,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["SQL – 1","SQL – 2","SQL – 3","SQL – 4","SQL – 5"]

{"sheet":"All index text out","index":5,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Index"]