Excel data manipulation and code for building titleunique web linksExcel数据处理和编码Web链接标题独特建筑.ppt

Slide 32 of 79 Now insert them in the new spreadsheet you’re currently working on. Slide 33 of 79 And here they are... The just-copied rows. If you’re just starting, you don’t have any spreadsheet from an earlier month. And... you can’t copy-and-insert last month’s top row into this month’s empty row. + In that case, just name the empty columns: Above this field Name the blank field this: TitleBibliographic TitleBibliographic Title Title Author Author Imprint Imprint Location Location LocationMeaning LocationMeaning Call # (bibliographic) CallNumber Note (order) AlsoUsefulFor Processing note GiftFrom Slide 34 of 79 “Freeze panes” under the top rows you want to see while scrolling through all records. (not necessary, but it’s convenient for data clean-up) Slide 35 of 79 Next: data clean-up. Start by bulk-deleting unneeded data. Highlight unneeded data and “delete”. Slide 36 of 79 In this example, earlier data (from the rows below) are now gone. Slide 37 of 79 Slide 38 of 79 These data remain: they’ll be in the Access database and data queries. Remember the cheat-sheet? Here it is again, this time applied to data clean-up... Slide 39 of 79 Cheat-sheet eliminates the burden of remembering how to replace each clunky-looking value. Using the same information every month also ensures data consistency in the whole database. Here’s an example of a home-grown informal value to be replaced with more formal wording to benefit library patrons. Slide 40 of 79 Throughout Excel, use the easy “find-and-place” function to edit any data in need of refining. “By Rows” is default. Change it to “by Columns”. Reason: you’re searching by column, within the same data field. Slide 41 of 79 Slide 42 of 79 Slide 43 of 79 Next: prepare for automatic search fields. The easiest way to do this is by lumping together all items to be searched by the same value. Example: cluster together everything to be searched by LC call# and non-LC call# T