...
Pull extent and date range information from the CCA Tools description file.csv.
For disks that have multiple projects/buildings, a separate entry is made for each building. The total extent and date range are used for each entry, but when counted for the series total or collection size, the disk is only counted once. (If a disk that is 30 digital files and 15 MB and dates from 2005-2007 has information for both All Saints' Episcopal Church and Johns-Hamilton Building, individual entries are made under both subseries. The entries both say that they are 30 digital files, 15 MB, and range from 2005-2007. However, when the Series A extent total is calculated, the disk is only included once.)
...
This document is a supplementary finding aid that provides additional detail for patrons. There are 3 sheets, 1 for each series, and with 11 columns: Project Name, Project Description, Location, State, Date, Item Type, Item Number, Item Extent, Digital File Types, Separated Material, and File Tree.
...
File Tree contains the file trees for disks. File trees are generated as text files during CCA Tools analysis. In Excel, go to Insert>Object>Microsoft Word Document. Check "Display as Icon." Copy and paste the file tree into the word Word document. For any items with the same disk number, instead of inserting the tree again, highlight the box gray and write "See /cell where document is located/" (i.e, "See M60). For items in separate later sheets, mark that the tree is on another sheet (i.e, "See "Construction," M60").