{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["report2"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"report2","index":0,"n_rows":41,"n_cols":5,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,2,0,3],[0,4,0,5],[1,2,1,3],[1,4,1,5],[2,2,2,3],[2,4,2,5],[3,2,3,3],[4,2,4,3],[5,2,5,3],[6,2,6,3],[8,2,8,3],[9,2,9,3],[16,2,16,3],[16,4,16,5],[17,2,17,3],[17,4,17,5],[18,2,18,3],[18,4,18,5],[19,2,19,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[26,2,26,3],[28,2,28,3],[29,2,29,3],[33,2,33,3]],"flags":["formulas_cached_only"]}
[null,"1.","Record Nr.",null,"UNINA9910705813703321"]
[null,null,"Autore",null,"Streufert Siegfried"]
[null,null,"Titolo",null,"Aspects of cognitive complexity theory and research as applied to a managerial decision making simulation / / Siegfried Streufert and Robert W. Swezey"]
[null,null,"Pubbl/distr/stampa",null,"Alexandria, Virginia : , : U.S. Army Research Institute for the Behavioral and Social Science, , September 1985"]
[null,null,"Descrizione fisica",null,"1 online resource (126 unnumbered pages) : illustrations"]
[null,null,"Collana",null,"Research note ; ; 85-96"]
[null,null,"Soggetti",null,"Decision making - United States"]
[{"$nulls":4},"Measurement - United States"]
[null,null,"Lingua di pubblicazione",null,"Inglese"]
[null,null,"Formato",null,"Materiale a stampa"]
[null,null,null,"Livello bibliografico","Monografia"]
[null,null,null,"Note generali","\"September 1985.\""]
[{"$nulls":4},"\"Performing organization: Behavioral Sciences Research Center, Science Application, Inc.\"--Report documentation page."]
[{"$nulls":4},"\"John Mietus, contracting officer's representative\"--Report documentation page."]
[{"$nulls":4},"\"SAI-82-03-178\"--Report documentation page."]
[null,null,null,"Nota di bibliografia","Includes bibliographical references (pages [113-126])."]
[null,"2.","Record Nr.",null,"UNINA9910786702603321"]
[null,null,"Autore",null,"Hogarth Margaret"]
[null,null,"Titolo",null,"Data clean-up and management : a practical guide for librarians / / Margaret Hogarth with contributions from Kenneth Furuta"]
[null,null,"Pubbl/distr/stampa",null,"Oxford : , : Chandos Publishing, , 2012"]
[null,null,"ISBN",null,"1-78063-347-5"]
[null,null,"Edizione",null,"[1st edition]"]
[null,null,"Descrizione fisica",null,"1 online resource (579 p.)"]
[null,null,"Collana",null,"Chandos information professional series"]
[null,null,"Disciplina",null,"025"]
[{"$nulls":4},"025.210285"]
[null,null,"Soggetti",null,"Libraries - Data processing"]
[{"$nulls":4},"Data editing"]
[null,null,"Lingua di pubblicazione",null,"Inglese"]
[null,null,"Formato",null,"Materiale a stampa"]
[null,null,null,"Livello bibliografico","Monografia"]
[null,null,null,"Note generali","Description based upon print version of record."]
[null,null,null,"Nota di bibliografia","Includes bibliographical references and index."]
[null,null,"Nota di contenuto",null,"Cover; Data Clean-up and Management: A practical guide for librarians; Copyright; Contents; List of figures; List of tables; About the authors; 1 Introduction (why this book is needed); What makes this book unique?; Why library data is important; The book's outline; 2 Commonalities; Microsoft Office Excel; MarcEdit; Microsoft Access; XML; Commonalities; Capture and use; Standardization; Data import issues; Technical skills; Project management challenges; 3 Defining data; Rule 1: define data points; Rule 2: apply data point definitions; Rule 3: count the right apples"]
[{"$nulls":4},"Rule 4: avoid capturing redundant data4 Types of data issues; Microsoft Excel vs Microsoft Access; General data-handling edicts; Data issues: importing data; 5 Microsoft Excel techniques; Creating datasheets; Selecting cells; Copying; Sorting; Filter; AutoSum; Sum; Fill; 6 Data clean-up in Excel; Common dirty data scenarios; The usefulness of delimiting; System limitations; Removing extra characters; 7 Excel: combining data; IF statements; The TEXT function; PivotTables and filtering; VLOOKUP; HLOOKUP; MATCH; 8 Additional tools; PDFs; Notepad; Microsoft Word"]
[{"$nulls":4},"Global update in an integrated library systemRegular expressions; Excel; Access; Macros; XML; MarcEdit; The MARC tools window; 9 Access techniques; What is a database?; Access; Planning a database; Preparing data for a database; Adding a table to a database; 10 Access forms; Types of form; Parts to a form; Form controls; Validating data; Option buttons; Combo boxes; ActiveX controls; Tab control techniques; Multiple-table forms; Command buttons; 11 Access "]
[{"$nulls":4},"reports; Creating a report using the Report Wizard; Controls; Making additions to a report; AutoFormat a report"]
[{"$nulls":4},"Working with report propertiesInserting a control into a report; Conditional formatting; Sizing reports; Moving controls in Access; Publishing reports; Sorting and grouping options; Adding calculations to reports; Launching reports; Creating a subreport; 12 Access queries; Sorting in Access; Filtering in Access; Queries; Entering data; Query properties; Access relationships; 13 Data clean-up in Access; Prevention is the best cure; Extra characters; Access data upload errors; ISSN issues; 14 Access - combining data; Combining data from one or more data sources; Query with a sum"]
[{"$nulls":4},"Types of operatorsTotals queries; Parameter queries; Action queries; Update queries; Delete queries; Make-Table queries; Append queries; PivotTable queries; SQL in Access; Parameter Queries in SQL; Export data to Excel; Finding unique values in a dataset; Matching on ISSN; 15 Strategies for missing data; Resources are missing ISBNs; Resources are missing ISSNs; Richard Jackson's OCLC look-up strategy; 16 Qualitative data; The definition of qualitative data; Qualitative data is valuable; Types of qualitative data; Qualitative data techniques; SWOT analysis; Tools; The whole picture; 17 ROI"]
[{"$nulls":4},"18 Data collection and analysis"]
[null,null,null,"Sommario/riassunto","Data use in the library has specific characteristics and common problems. Data Clean-up and Management addresses these, and provides methods to clean up frequently-occurring data problems using readily-available applications. The authors highlight the importance and methods of data analysis and presentation, and offer guidelines and recommendations for a data quality policy. The book gives step-by-step how-to directions for common dirty data issues.Focused towards libraries and practicing librariansDeals with practical, real-life issues and addresses common problems th"]