{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["DATA ENTRY","EAD TAGS","Sheet3"],"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":"DATA ENTRY","index":0,"n_rows":2,"n_cols":12,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
["LOCATOR NUMBER","BOX\nNUMBER","CONTAINER TYPE\nEnter the type of container when the container is not a box.  Enclose the type in quotation marks, e.g. \"reel\" or \"folder\"","COMPONENT LEVEL\nEnter \"series\" or \"subseries\" for highly complex descriptions -- when no physloc or container is recoded at the component level.  Enclose the level in quotation marks.","LEVEL 1 TITLE","LEVEL 2 TITLE","LEVEL 3 TITLE","LEVEL 4 TITLE","LEVEL 5 TITLE","DATE","QUANTITY","SCOPE NOTE"]

{"sheet":"EAD TAGS","index":1,"n_rows":2,"n_cols":46,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Formula =IF((B1)<>\"\",\"<c0\",\"\")","Formula =IF(O1<>\"\",5,IF(N1<>\"\",4,IF(M1<>\"\",3,IF(L1<>\"\",2,IF(K1<>\"\",1,\"\")))))","Formula =IF('DATA ENTRY'!D1<>\"\",\" level=\",\"\")","Formula =IF('DATA ENTRY'!D1<>\"\",'DATA ENTRY'!D1,\"\")","Formula =IF((B1)<>\"\",\" ><did>\",\"\")","Formula =IF((G1)<>\"\",\"<physloc>\",\"\")","Formula =IF('DATA ENTRY'!A1<>\"\",'DATA ENTRY'!A1,\"\")","Formula =IF( (G1)<>\"\",\"</physloc>\",\"\")","Formula =IF( (M1)<>\"\",\"<container\",\"\")","Formula =IF('DATA ENTRY'!C1<>\"\",\" type=\",\"\")","Formula =IF('DATA ENTRY'!C1<>\"\",'DATA ENTRY'!C1,\"\")","Formula =IF( (M1)<>\"\",\">\",\"\")","Formula =IF('DATA ENTRY'!B1<>\"\",'DATA ENTRY'!B1,\"\")","Formula =IF( (M1)<>\"\",\"</container>\",\"\")","Formula =IF(O1<>\"\",\"<unittitle>\",IF(N1<>\"\",\"<unittitle>\",IF(M1<>\"\",\"<unittitle>\",IF(L1<>\"\",\"<unittitle>\",IF(K1<>\"\",\"<unittitle>\",\"\")))))","Formula =IF('DATA ENTRY'!E1<>\"\",'DATA ENTRY'!E1,\"\")","Formula =IF('DATA ENTRY'!F1<>\"\",'DATA ENTRY'!F1,\"\")","Formula =IF('DATA ENTRY'!G1<>\"\",'DATA ENTRY'!G1,\"\")","Formula =IF('DATA ENTRY'!H1<>\"\",'DATA ENTRY'!F\\H1,\"\")","Formula =IF('DATA ENTRY'!I1<>\"\",'DATA ENTRY'!I1,\"\")","Formula =IF(O1<>\"\",\"</unittitle>\",\"\")","Formula Formula =IF( (W1)<>\"\",\"<unitdate>\",\"\")","Formula =IF('DATA ENTRY'!J1<>\"\",'DATA ENTRY'!J1,\"\")","Formula =IF((W1)<>\"\",\". </unitdate>\",\"\")","Formula =IF( (Z1)<>\"\",\"<physdesc>\",\"\")","Formula =IF('DATA ENTRY'!K1<>\"\",'DATA ENTRY'!K1,\"\")","Formula =IF( (Z1)<>\"\",\".</physdesc>\",\"\")","Formula =IF(O1<>\"\",\"</did>\",\"\")","Formula =IF( (AD1)<>\"\",\"<scopecontent><p>\",\"\")","Formula =IF('DATA ENTRY'!L1<>\"\",'DATA ENTRY'!L1,\"\")","Formula =IF( (AD1)<>\"\",\"</p></scopecontent>\",\"\")","Formula =IF(AG1<>\"\",\"</c0\",\"\")","Formula =IF(OR(B2=\"\",B2<=B1),B1,\"\")","Formula =IF(AG1<>\"\",\">\",\"\")","Formula =IF(AJ1<>\"\",\"</c0\",\"\")","Formula =IF(OR(AG1=\"\",AG1=1),\"\",IF(OR(AG1>B2,B2=\"\"),(AG1-1),\"\"))","Formula =IF(AJ1<>\"\",\">\",\"\")","Formula =IF(AM1<>\"\",\"</c0\",\"\")","Formula =IF(OR(AJ1=\"\",AJ1=1),\"\",IF(OR(AJ1>B2,B2=\"\"),(AJ1-1),\"\"))","Formula =IF(AM1<>\"\",\">\",\"\")","Formula =IF(AP1<>\"\",\"</c0\",\"\")","Formula =IF(OR(AM1=\"\",AM1=1),\"\",IF(OR(AM1>B2,B2=\"\"),(AM1-1),\"\"))","Formula =IF(AP1<>\"\",\">\",\"\")","Formula =IF(AS1<>\"\",\"</c0\",\"\")","Formula =IF(OR(AP1=\"\",AP1=1),\"\",IF(OR(AP1>B2,B2=\"\"),(AP1-1),\"\"))","Formula =IF(AS1<>\"\",\">\",\"\")"]
[{"$f":"IF((B2)<>\"\",\"<c0\",\"\")","v":"<c0"},{"$f":"IF(T2<>\"\",5,IF(S2<>\"\",4,IF(R2<>\"\",3,IF(Q2<>\"\",2,IF(P2<>\"\",1,\"\")))))","v":5},{"$f":"IF('DATA ENTRY'!D2<>\"\",\" level=\",\"\")","v":" level="},{"$f":"IF('DATA ENTRY'!D2<>\"\",'DATA ENTRY'!D2,\"\")","v":"COMPONENT LEVEL\nEnter \"series\" or \"subseries\" for highly complex descriptions -- when no physloc or container is recoded at the component level.  Enclose the level in quotation marks."},{"$f":"IF((B2)<>\"\",\"><did>\",\"\")","v":"><did>"},{"$f":"IF((G2)<>\"\",\"<physloc>\",\"\")","v":"<physloc>"},{"$f":"IF('DATA ENTRY'!A2<>\"\",'DATA ENTRY'!A2,\"\")","v":"LOCATOR NUMBER"},{"$f":"IF((G2)<>\"\",\"</physloc>\",\"\")","v":"</physloc>"},{"$f":"IF( (M2)<>\"\",\"<container\",\"\")","v":"<container"},{"$f":"IF('DATA ENTRY'!C2<>\"\",\" type=\",\"\")","v":" type="},{"$f":"IF('DATA ENTRY'!C2<>\"\",'DATA ENTRY'!C2,\"\")","v":"CONTAINER TYPE\nEnter the type of container when the container is not a box.  Enclose the type in quotation marks, e.g. \"reel\" or \"folder\""},{"$f":"IF( (M2)<>\"\",\">\",\"\")","v":">"},"BOX NUMBER",{"$f":"IF( (M2)<>\"\",\"</container>\",\"\")","v":"</container>"},{"$f":"IF(T2<>\"\",\"<unittitle>\",IF(S2<>\"\",\"<unittitle>\",IF(R2<>\"\",\"<unittitle>\",IF(Q2<>\"\",\"<unittitle>\",IF(P2<>\"\",\"<unittitle>\",\"\")))))","v":"<unittitle>"},"LEVEL 1 TITLE","LEVEL 2 TITLE","LEVEL 3 TITLE","LEVEL 4 TITLE","LEVEL 5 TITLE",{"$f":"IF(O2<>\"\",\"</unittitle>\",\"\")","v":"</unittitle>"},{"$f":"IF((W2)<>\"\",\"<unitdate>\",\"\")","v":"<unitdate>"},"DATE",{"$f":"IF((W2)<>\"\",\". </unitdate>\",\"\")","v":". </unitdate>"},{"$f":"IF( (Z2)<>\"\",\"<physdesc> \",\"\")","v":"<physdesc> "},{"$f":"IF('DATA ENTRY'!K2<>\"\",'DATA ENTRY'!K2,\"\")","v":"QUANTITY"},{"$f":"IF( (Z2)<>\"\",\".</physdesc>\",\"\")","v":".</physdesc>"},{"$f":"IF(O2<>\"\",\"</did>\",\"\")","v":"</did>"},{"$f":"IF( (AD2)<>\"\",\"<scopecontent><p>\",\"\")","v":"<scopecontent><p>"},{"$f":"IF('DATA ENTRY'!L2<>\"\",'DATA ENTRY'!L2,\"\")","v":"SCOPE NOTE"},{"$f":"IF( (AD2)<>\"\",\"</p></scopecontent>\",\"\")","v":"</p></scopecontent>"},{"$f":"IF(AG2<>\"\",\"</c0\",\"\")","v":"</c0"},{"$f":"IF(OR(B3=\"\",B3<=B2),B2,\"\")","v":5},{"$f":"IF(AG2<>\"\",\">\",\"\")","v":">"},{"$f":"IF(AJ2<>\"\",\"</c0\",\"\")","v":"</c0"},{"$f":"IF(OR(AG2=\"\",AG2=1),\"\",IF(OR(AG2>B3,B3=\"\"),(AG2-1),\"\"))","v":4},{"$f":"IF(AJ2<>\"\",\">\",\"\")","v":">"},{"$f":"IF(AM2<>\"\",\"</c0\",\"\")","v":"</c0"},{"$f":"IF(OR(AJ2=\"\",AJ2=1),\"\",IF(OR(AJ2>B3,B3=\"\"),(AJ2-1),\"\"))","v":3},{"$f":"IF(AM2<>\"\",\">\",\"\")","v":">"},{"$f":"IF(AP2<>\"\",\"</c0\",\"\")","v":"</c0"},{"$f":"IF(OR(AM2=\"\",AM2=1),\"\",IF(OR(AM2>B3,B3=\"\"),(AM2-1),\"\"))","v":2},{"$f":"IF(AP2<>\"\",\">\",\"\")","v":">"},{"$f":"IF(AS15<>\"\",\"</c0\",\"\")","v":""},{"$f":"IF(OR(AP2=\"\",AP2=1),\"\",IF(OR(AP2>B3,B3=\"\"),(AP2-1),\"\"))","v":1},{"$f":"IF(AS2<>\"\",\">\",\"\")","v":">"}]

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}