{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Start Here","Configuration and Help"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Start Here","index":0,"n_rows":16,"n_cols":1,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Pull list Macro version 6.16PLS (11/1/2023)"]
["Tell Chris Hennes if something is broken"]

{"sheet":"Configuration and Help","index":1,"n_rows":103,"n_cols":4,"rows_kept":103,"cut":false,"hidden":false,"merged":[[94,0,94,8],[95,0,95,8],[90,0,90,8],[91,0,91,8],[92,1,92,8],[25,0,89,0],[10,0,10,8],[12,0,12,8],[13,0,13,8],[21,0,21,8],[20,0,20,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Configuration"]
[]
["Column widths"]
["Adjust these if needed to make the pull list fit on your printer page size. Some trial and error may be required."]
["Collection Code",7]
["Filed under",13]
["Title",40]
["Author",11]
["Call #",15]
[]
["Pull lists"]
["Each column lists the title and collection codes for a pull list. Any code not found in either list is put in an \"Other\" sheet when the macro is run (the column here is just for reference). To update the collection codes just add or remove them from the appropriate column and update the \"Number of codes\" field to specify how many of them are there."]
["Number of pull lists",2]
["Lists","Adult","Children","Other"]
["Number of codes",{"$f":"COUNTA(B26:B90)","v":48},{"$f":"COUNTA(C26:C90)","v":31},{"$f":"COUNTA(D26:D90)","v":6}]
["Codes","AB","BR","ED"]
[null,"AF","CB","EQ"]
[null,"AFG","CBB","ER"]
[null,"AFM","CBR","ILL"]
[null,"AFS","CCB","NB"]
[null,"AFW","CE","PA"]
[null,"ALB","CEP"]
[null,"ALF","CEPD"]
[null,"ALN","CEPH"]
[null,"AM","CF"]
[null,"AN","CFS"]
[null,"ANF","CL"]
[null,"ANFF","CM"]
[null,"ANFG","CNF"]
[null,"AOC","CT"]
[null,"AOR","CWB"]
[null,"ARG","CWL"]
[null,"DAB","CWLF"]
[null,"DVDAB","CWLJ"]
[null,"DVDAD","CWLS"]
[null,"DVDAF","CWLV"]
[null,"DVDAN","DCB"]
[null,"DVDBD","DCK"]
[null,"DVDBF","DCM"]
[null,"DVDBN","DVDBCF"]
[null,"DVDS","DVDBCN"]
[null,"DYB","DVDCB"]
[null,"FL","DVDCF"]
[null,"FLS","DVDCN"]
[null,"KAB","KL"]
[null,"KTH","NWC"]
[null,"LIT"]
[null,"NNP"]
[null,"NWB"]
[null,"NWLP"]
[null,"NWYF"]
[null,"STC"]
[null,"SZ"]
[null,"SZZ"]
[null,"VAB"]
[null,"WL"]
[null,"WLF"]
[null,"WLJ"]
[null,"WLS"]
[null,"WLV"]
[null,"YF"]
[null,"YGN"]
[null,"YS"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Statistics"]
["The number of items on the pull list can be placed into another Excel sheet. This is the path to that sheet."]
["Sheet","U:\\Norman\\IS Desk\\Pull List Stats.xlsx"]
[]
["Code Maps"]
["If a number of collection codes are all shelved together it can be useful to have them appear together in the pull list as well, instead of sorted into separate categories."]
["Number of Maps",5]
["Collection Code","Sorts with"]
["AFM","AF"]
["AFR","AF"]
["DVDAN","ANF"]
["DVDCN","CNF"]
["DVDCB","CB"]