{"@context":"http://iiif.io/api/presentation/3/context.json","id":"https://weareavp.aviaryplatform.com/iiif/s17sn01c93/manifest","type":"Manifest","label":{"en":["Managing Data in Spreadsheets"]},"logo":"https://d9jk7wjtjpu5g.cloudfront.net/organizations/logo_images/000/000/007/original/avp-logo-login_2x.png?1692278773","metadata":[{"label":{"en":["Agent"]},"value":{"en":["Kathryn Gronsbell (Presenter)"]}},{"label":{"en":["Language"]},"value":{"en":["English (Primary)"]}},{"label":{"en":["Description"]},"value":{"en":["\u003cp\u003eIn this tutorial, spreadsheets are positioned as a mechanism to help practitioners manage metadata more accurately, efficiently, and effectively. Limited resources create a reality where spreadsheets are an interim alternative to preferred metadata management tools like databases and database applications, and become the default for capturing, editing, storing and reporting information.\u003c/p\u003e\r\n\u003cp\u003e \u003c/p\u003e\r\n\u003cp\u003eThere are many opportunities to leverage sophisticated features in spreadsheet applications that allow you to work faster, smarter, and with greater accuracy towards a more robust metadata management system. The tutorial features instruction using Microsoft Excel.\u003c/p\u003e (general)"]}},{"label":{"en":["Keyword"]},"value":{"en":["data management","spreadsheets","tutorial"]}},{"label":{"en":["Duration"]},"value":{"en":["00:11:54"]}}],"summary":{"en":["\u003cp\u003eIn this tutorial, spreadsheets are positioned as a mechanism to help practitioners manage metadata more accurately, efficiently, and effectively. Limited resources create a reality where spreadsheets are an interim alternative to preferred metadata management tools like databases and database applications, and become the default for capturing, editing, storing and reporting information.\u003c/p\u003e\r\n\u003cp\u003e\u0026nbsp;\u003c/p\u003e\r\n\u003cp\u003eThere are many opportunities to leverage sophisticated features in spreadsheet applications that allow you to work faster, smarter, and with greater accuracy towards a more robust metadata management system. The tutorial features instruction using Microsoft Excel.\u003c/p\u003e"]},"provider":[{"id":"https://weareavp.aviaryplatform.com/aboutus","type":"Agent","label":{"en":["AVP"]},"homepage":[{"id":"https://weareavp.aviaryplatform.com/","type":"Text","label":{"en":["AVP"]},"format":"text/html"}],"logo":[{"id":"https://d9jk7wjtjpu5g.cloudfront.net/organizations/logo_images/000/000/007/original/avp-logo-login_2x.png?1692278773","type":"Image"}]}],"thumbnail":[{"id":"https://d9jk7wjtjpu5g.cloudfront.net/collection_resource_files/thumbnails/000/035/619/small/open-uri20190409-9168-x4sqrz?1554841302","type":"Image","format":"image/jpeg"}],"items":[{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619","type":"Canvas","label":{"en":["Media File 1 of 1 - AVPreserve Tutorial: Managing Data in Spreadsheets"]},"duration":714.0,"width":640,"height":360,"thumbnail":[{"id":"https://d9jk7wjtjpu5g.cloudfront.net/collection_resource_files/thumbnails/000/035/619/small/open-uri20190409-9168-x4sqrz?1554841302","type":"Image","format":"image/jpeg"}],"items":[{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/content/1","type":"AnnotationPage","items":[{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/content/1/annotation/1","type":"Annotation","motivation":"painting","body":{"id":"https://player.vimeo.com/video/125910054","type":"Video","format":"video/vimeo","duration":714.0,"width":640,"height":360},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619","metadata":[]}]}],"annotations":[{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738","type":"AnnotationPage","label":{"en":["English [Transcript]"]},"items":[{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/1","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"In this video,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=2.3,2.871"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/2","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"we will explore useful metadata management features within Excel spreadsheets","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=2.871,6.71"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/3","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"including the generation capture, editing, importing, and exporting of data.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=6.89,11.57"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/4","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"This tutorial is designed to help people manage metadata more accurately,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=12.2,15.95"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/5","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"efficiently, and effectively.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=15.98,17.69"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/6","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"Databases and database applications are widely recognized as being the most","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=18.5,22.46"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/7","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"effective for management and use of metadata. However, for a variety of reasons,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=22.461,27.35"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/8","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"organizations continue to use spreadsheets for capturing, editing, storing,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=27.62,31.88"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/9","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"and reporting information.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=31.94,33.32"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/10","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"There are many caveats if you choose to manage and manipulate your data in","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=34.77,37.95"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/11","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"spreadsheets, but if used,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=37.951,39.78"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/12","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"there are also many opportunities to leverage sophisticated features that allow","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=39.81,43.38"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/13","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"you to work faster, smarter,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=43.381,45.18"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/14","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"and with greater accuracy that you should know about.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=45.181,47.49"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/15","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"Problems can occur easily and inadvertently.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=49.14,51.66"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/16","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"You may have noticed issues when using Excel or spreadsheets and Google docs for","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=51.96,55.53"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/17","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"capturing, editing, managing, and importing or exporting metadata.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=55.531,59.25"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/18","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"Some common issues are the removal of necessary leading zeros,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=60.15,64.38"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/19","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"altering date formatting,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=65.37,66.93"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/20","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"converting numbers to scientific notation or the misinterpretation of separators","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=67.53,72.53"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/21","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"causing misalignment of data and cells.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=72.631,74.94"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/22","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"These are all caused because of assumptions that the spreadsheet applications","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=77.4,80.61"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/23","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"make about data and they may seem innocuous enough with small datasets in a","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=80.611,84.42"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/24","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"single spreadsheet,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=84.421,85.32"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/25","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"but they become exponentially more problematic when you talk about large amounts","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=85.53,88.98"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/26","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"of data dispersed across various spreadsheets and systems.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=88.981,92.13"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/27","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"Problems can occur in several places and for multiple reasons.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=93.75,97.29"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/28","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"Primarily issues occur either at the point of data entry or at the point of","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=97.41,101.4"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/29","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"opening an existing document.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=101.401,102.99"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/30","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"Let's walk through each of these scenarios and examine them further.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=103.32,106.71"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/31","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"With the right set of validation rules,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=108.01,109.78"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/32","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"your organization can employ spreadsheets as a practical data capture mechanism.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=109.81,113.65"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/33","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"Let's examine what this looks like using Excel.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=113.98,116.14"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/34","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"In this spreadsheet we see three tabs, MARC data,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=118.01,120.71"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/35","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"entry vocabularies and inherited row one on the data entry tab includes column","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=120.711,125.711"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/36","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"headers for name and contact information including details about birthdays","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=126.651,130.73"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/37","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"without any validation filled out over time and perhaps by different people.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=131.18,135.23"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/38","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"This spreadsheet may very well end up looking something like this resulting in","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=135.44,139.31"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/39","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"poor data quality. Let's take a look at one,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=139.311,142.43"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/40","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"how we can avoid this type of issue by controlling data entry from the start and","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=142.46,146.48"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/41","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"to how we can work with data like this when we inherit it.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=146.93,149.66"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/42","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"One way to do this is to use controlled vocabularies.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=151.95,154.68"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/43","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"When we click the vocabularies tab,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=155.16,156.96"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/44","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"we can see a list of vocabularies including a list of first and last names,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=157.02,160.8"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/45","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"state abbreviations and month and date terms.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=160.92,163.59"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/46","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"In thinking about controlling input at the point of data capture,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=165.11,168.05"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/47","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"we can highlight the cells we want to apply rules to and select validation by","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=168.17,172.43"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/48","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"selecting list and using the vocabulary for States and the vocabularies tab.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=172.431,176.54"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/49","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"We make sure that only values from our controlled are entered.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=176.78,179.77"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/50","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"However, in many cases you may inherit data that looks something like this.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=187.11,190.89"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/51","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"Again,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=191.22,192.0"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/52","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"we can use validation and vocabularies to help identify and begin cleaning up","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=192.0,195.54"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/53","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"the data.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=195.541,196.374"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/54","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"You will notice that there is some overlap between the vocabulary lists and the","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=196.77,200.19"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/55","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"data I entered, but all of it does not match.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=200.191,202.77"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/56","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"We can use the validation to validate this existing data against the","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=203.16,206.19"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/57","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"vocabularies. For instance,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=206.191,209.13"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/58","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"I want to see if the way I entered state names matches our vocabularies.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=209.131,212.52"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/59","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"After I select the column containing the state entries,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=212.94,215.61"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/60","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"I go through the same process as before for controlling the data entry.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=215.64,219.39"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/61","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"Doing this tells me where my existing data on States does not match up with my","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=220.08,223.74"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/62","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"vocabularies.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=223.741,224.76"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/63","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"The results show us that while some of my data entries validate against the","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=225.72,228.9"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/64","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"sample vocabularies,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=228.901,230.13"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/65","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"some outliers like non abbreviated state names and typos are invalid in this","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=230.16,234.54"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/66","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"short list. It's an easily fixable problem in larger datasets.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=234.541,238.95"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/67","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"This is a time intensive process.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=238.98,240.69"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/68","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"Features within Excel such as finding replace and filtering can be used to go","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=240.96,245.04"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/69","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"through and clean this data up,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=245.041,246.45"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/70","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"but with a lot of data is a labor intensive process.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=246.51,249.27"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/71","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"Later in the series we will have a tutorial on opener fine,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=250.41,253.59"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/72","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"which is a more sophisticated tool for performing data cleanup on large","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=253.62,257.4"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/73","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"datasets. However,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=258.24,259.53"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/74","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"under any circumstance you can imagine the problems that could arise from this","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=259.56,263.04"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/75","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"batch data making its way through your databases and systems.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=263.041,266.25"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/76","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"CSV files are the currency of data exchange for spreadsheet data or data in","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=266.88,271.23"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/77","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"tabular farm. They're used everywhere for exporting, editing,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=271.231,275.13"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/78","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"importing and reporting as widely as they are used.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=275.19,278.58"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/79","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"Few people understand exactly what they are, how they work,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=278.64,281.79"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/80","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"and how spreadsheet applications,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=282.15,283.77"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/81","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"which are the most commonly used tool to work with CSV files handle them.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=283.8,287.49"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/82","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"Because of this,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=288.06,288.99"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/83","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"they are commonly used in ways that degrade the integrity of the data they carry","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=289.02,292.71"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/84","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"often with big implications to data quality.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=292.95,295.35"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/85","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"CSV files are loosely defined but common exchange format between systems and as","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=295.83,300.83"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/86","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"you may have guessed,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=301.111,302.01"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/87","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"have data that is delimited by a specific character most often the comma,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=302.16,306.15"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/88","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"but the sea could also stand for character if another character is used to","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=306.3,309.78"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/89","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"separate data.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=309.781,310.62"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/90","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"The text in between two commas is the text that will show up in a cell and each","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=311.37,315.42"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/91","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"comma represents a new column. Each line break represents a new row.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=315.421,319.5"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/92","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"A CSV is elegant in its simplicity and is extremely effective as long as it's","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=320.07,324.48"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/93","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"managed properly. As with most files,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=324.481,328.2"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/94","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"people typically open CSV files by double clicking them.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=328.201,331.26"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/95","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"This opens them in the default application,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=331.71,333.72"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/96","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"which is typically a spreadsheet application.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=333.75,335.82"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/97","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"If you make any changes and save this file or even if you don't make any changes","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=336.27,340.05"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/98","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"and simply save it as another format,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=340.051,341.85"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/99","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"chances are that you have sacrificing integrity of your data.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=341.94,344.7"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/100","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"Let's walk through how to avoid this happening. First,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=345.6,350.02"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/101","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"I'll open my sample CSV file by double clicking it.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=350.14,352.69"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/102","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"It's a basic inventory of pneumatic tapes with metadata including identifiers,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=353.32,357.41"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/103","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"titles and durations. Note that even though I am scrolling around,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=357.411,361.22"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/104","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"I am not making any changes.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=361.25,362.87"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/105","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"Now I'll save this file as an Excel document adding underscore open to the end","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=363.38,367.4"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/106","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"of the file name so that we can identify it later and save it as an Excel file.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=367.401,371.81"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/107","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"In the data tab. Under get external data,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=375.66,377.94"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/108","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"I'll select from text and navigate to my original CSV file activity_2.csv.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=378.15,382.26"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/109","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"Clicking import.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=384.99,385.89"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/110","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"I select the delimited radio button and then next followed by choosing comma and","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=385.98,390.98"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/111","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"making sure no other items under the delimiter section are selected. Another.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=391.171,396.03"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/112","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"Next and I highlight all of the columns by scrolling all the way to the right","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=396.031,399.48"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/113","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"within the dialogue window and holding down the shift key.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=399.481,402.45"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/114","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"I choose text which tells Excel not to alter the data at all upon import and","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=403.32,407.91"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/115","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"then finish.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=407.911,408.99"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/116","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"I want this to go into a new worksheet so I choose the option and click okay.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=409.5,413.64"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/117","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"I'll save this newly minted version by adding an underscore import after the","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=414.69,418.53"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/118","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"file name. Now let's compare the two,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=418.531,421.53"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/119","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"but first let's look at what our original data looks like by viewing it in a","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=421.56,424.83"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/120","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"text editor.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=424.831,425.67"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/121","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"Let's take special note of the system ID record dates and upload dates.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=426.51,430.77"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/122","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"Now let's look at the two files we created. One scrolling through the two files,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=431.16,435.51"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/123","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"we can start to take note of the differences of opening versus importing and the","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=435.511,440.19"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/124","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"very first column there is an obvious difference in the occurrence of leading","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=440.191,443.67"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/125","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"zeros in the system ID with imported data,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=444.12,446.43"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/126","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"maintaining zeros from the original CSV, an hour open file removing them.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=446.431,451.11"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/127","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"This can lead to disastrous problems for data management and collection","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=452.22,455.61"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/128","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"management.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=455.611,456.444"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/129","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"This same leading zeros issue can be seen in the duration column where there's","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=457.25,460.77"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/130","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"only a single character for leading zeros in the open file and two leading zeros","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=460.771,465.0"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/131","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"in the imported data for record date. You can see the dates entered for.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=465.001,469.89"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/132","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"All of these videos have been maintained upon import,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=469.891,472.41"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/133","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"but the date formatting has been altered on the open version.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=472.59,475.86"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/134","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"More serious date alteration can be seen on the upload date where ISO eight six","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=476.7,481.26"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/135","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"Oh one format has been changed to a date format that has less interoperable","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=481.261,485.1"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/136","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"between systems. Again, these may seem like rather harmless alterations,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=485.101,489.54"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/137","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"but recognizing the extent to which your organization's workflows,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=489.72,492.81"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/138","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"resources or content might be affected by corrupted or inaccurate data is","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=492.96,497.37"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/139","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"crucial. To round out this tutorial,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=497.371,500.31"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/140","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"we will play around with existing datasets to see how spreadsheets can work in","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=500.311,503.82"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/141","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"our favor.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=503.821,504.654"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/142","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"I have a collection of metadata about the bestselling single volume books and","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=505.08,508.5"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/143","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"books series to date with information about the authors release and sales.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=508.73,512.91"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/144","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"I'll use the text to columns function in Excel to map data contained in one","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=513.69,517.47"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/145","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"field to multiple fields and arrange it in a layout of my choice.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=517.471,521.04"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/146","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"What I have now is a list of first and last names of bestselling authors with","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=521.91,525.96"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/147","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"some middle names dumped into a single field in the column titled authors.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=525.961,530.13"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/148","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"I want to separate out the first middle and last names into three distinct","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=530.73,534.69"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/149","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"fields. I have better control over this dataset.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=534.691,537.27"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/150","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"Say I need to be able to start this list alphabetically by last name with the","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=538.32,542.31"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/151","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"data arrange as it is now sorting my last name is impossible to do so let's","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=542.311,546.99"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/152","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"change that. First. I will select the row I want to change.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=546.991,550.53"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/153","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"Then in the data menu I select text to columns,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=550.77,553.77"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/154","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"then delimited and next","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=556.97,561.16"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/155","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"and choose spaces. In the delimiters checkbox list,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=563.26,566.32"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/156","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"I want to make sure of that treat consecutive delimiters as one is also checked.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=567.25,571.78"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/157","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"You can see that our data is now split into three columns in the preview window","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=572.38,576.07"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/158","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"before clicking next. At the top of each column,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=576.1,579.25"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/159","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"the word general appears indicating the formatting of the cells.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=579.251,583.0"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/160","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"I'm going to select all the columns seen here, highlighted in black.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=583.33,586.57"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/161","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"Now I'll select text under column data format.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=587.2,590.02"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/162","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"You can see that the general changes to text at the top of each column on the","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=590.14,595.14"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/163","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"same screen destination will say dollar sign, B dollar sign,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=595.421,598.66"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/164","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"one to the right of dollar sign B dollar sign one.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=598.661,601.51"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/165","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"I'll select this little icon and then sell F1 which is blank and hit enter.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=601.72,606.22"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/166","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"Destination is now populated with dollar sign F dollar sign one.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=606.88,610.81"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/167","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"The dollar sign allows you to create an absolute or fixed reference to either","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=611.2,614.68"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/168","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"the row, the column or both for any cell.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=614.681,617.71"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/169","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"I'll finish this up to reveal all of our author names split into columns F, G,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=618.55,622.84"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/170","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"and. H.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=622.9,623.733"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/171","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"I'll rename the three columns with more appropriate headings and make them bold","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=624.22,627.88"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/172","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"so they're easier to see.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=627.881,629.14"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/173","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"Next I want to easily see if these columns are working as I expect with the last","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=629.86,634.06"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/174","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"names in the last name column instead of in the middle name column as it","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=634.061,637.3"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/175","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"appears. Now after selecting all populated columns,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=637.301,641.23"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/176","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"I choose data then sort and make sure that my data has headers.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=641.26,645.52"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/177","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"In the top right of the dialog window is checked in the dialogue window.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=645.521,649.33"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/178","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"I select the area under column where it says sort by and select last name and","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=649.54,654.52"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/179","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"click okay.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=654.521,655.354"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/180","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"Now there's only text in my first and middle name columns for most of my list,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=656.44,660.43"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/181","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"so we aren't done yet.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=660.46,661.6"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/182","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"The unpopulated cells in the last name column represent instances of authors who","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=662.41,666.55"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/183","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"have no middle name,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=666.551,667.57"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/184","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"so I will cut and paste these values into their correct last name column.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=667.99,671.38"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/185","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"Now I want to put these names back where the original authors column was,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=671.95,675.61"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/186","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"so I will cut and paste the three rows over. Column B are bolded.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=675.7,679.99"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/187","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"Header rows indicate our newly arranged author names separated by first middle","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=679.991,684.49"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/188","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"and last name.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=684.491,685.36"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/189","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"Now I am able to sort my bestsellers alphabetically by last name with just a few","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=686.17,690.73"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/190","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"simple maneuvers.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=690.731,691.6"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/191","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"I'm able to leverage the extensive data collected about these books in a way","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=691.87,695.62"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/192","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"that wasn't possible before.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=695.621,697.06"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/193","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"While we have just brushed the surface of how to manage data in spreadsheets,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=698.32,701.44"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/194","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"it is our hope that this tutorial will provide some important fundamental tools","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=701.65,705.61"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/195","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"that will support the development of a more comprehensive approach to importing,","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=705.82,709.63"},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/196","type":"Annotation","motivation":"transcribing","body":{"type":"TextualBody","value":"manipulating, and handling metadata in your organization.","format":"text/plain"},"target":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619#t=709.66,712.75"}]},{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738","type":"AnnotationPage","label":{"en":["English [Transcript]"]},"items":[{"id":"https://weareavp.aviaryplatform.com/collections/6/collection_resources/4733/file/35619/transcript/6738/annotation/197","type":"Annotation","motivation":"subtitling","body":{"type":"TextualBody","value":"https://d9jk7wjtjpu5g.cloudfront.net/file_transcripts/associated_files/000/006/738/original/AVP_Tutorial_Managing_Data_in_Spreadsheets.vtt?1580404856","format":"text/vtt","language":"en"},"target":"https://d9jk7wjtjpu5g.cloudfront.net/file_transcripts/associated_files/000/006/738/original/AVP_Tutorial_Managing_Data_in_Spreadsheets.vtt?1580404856"}]}]}]}