{"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":29,"n_cols":5,"rows_kept":29,"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],[5,2,5,3],[6,2,6,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[13,2,13,3],[19,2,19,3],[19,4,19,5],[20,2,20,3],[20,4,20,5],[21,2,21,3],[21,4,21,5],[22,2,22,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[27,2,27,3]],"flags":["formulas_cached_only"]}
[null,"1.","Record Nr.",null,"UNINA9910814810603321"]
[null,null,"Autore",null,"Collie Rob"]
[null,null,"Titolo",null,"Power Pivot alchemy : patterns and techniques for Excel / / Rob Collie and Bill Jelen ; cover design, Jocelyn Hellyer ; indexing, Nellie J. Liwam"]
[null,null,"Pubbl/distr/stampa",null,"Uniontown, Ohio : , : Holy Macro! Books, , 2014"]
[{"$nulls":4},"©2014"]
[null,null,"ISBN",null,"1-61547-214-2"]
[null,null,"Descrizione fisica",null,"1 online resource (257 p.)"]
[null,null,"Disciplina",null,"005.54"]
[null,null,"Soggetti",null,"Electronic spreadsheets - Computer programs"]
[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","Includes index."]
[null,null,"Nota di contenuto",null,"Cover; Title page; Copyright; Table of Contents; Dedications; A Note on Hyperlinks; Acknowledgements; Foreword; Introduction; Chapter 1: Dashboard Tricks and Visualization Techniques; Adding a \"Last Refreshed Date\" Readout; Normalizing Your Measures to First/Average/Max Values for Charts; Bubbling Up Exceptions with \"Sarah Problem\"; Ranks and Exceptions That Bubble Up to Subtotals; Chapter 2: Slicers: The Gateway to Interactivity; \"Initializing\" Slicers That Contain Too Many Values to Scroll; Wingdings and Other Symbolic Fonts in Slicers; Using Macros to Change Slicer Fonts"]
[{"$nulls":4},"A Simple Trick for Combatting \"Stale\" SlicersUser-Friendly Report Sorting with Slicers; Adding State Alpha Sorting to the Sort-by-Slicer Trick; Conditional Formatting Controlled via Slicers; Catching Slicer Selections in a Formula; Chapter 3: Conquering Common Calculated Column Conundrums; An Excel Pro's Primer on Calculated Columns; Subtotaling Calc Columns and the EARLIER() Function; Referencing the Previous Row and Similar Calcs; Referencing Rows \"Within Range\" of the Current Row; Totaling Data Table Values in Lookup Tables; CONTAINSX: Finding Matching Values in Two Tables"]
[{"$nulls":4},"CONTAINSX Revisited: What Is the Match?Common Calendar Conundrums; Custom Calendar Conundrums; Chapter 4: Modeling and Portable Formulas; Integrating Data of Different \"Grains\"; A Mystifying and Awesome Solution for the Many-to-Many Problem; Calculating Same-Store Sales in Power Pivot; Same-Store Sales Continued: Using Store Open/Close Dates; Campaign Analysis: Seasonally Adjusted Measures; A/B Campaign Analysis with Start and End Date Slicers; Customers and Website Visitors: Percentage Who Return; Calculating "]
[{"$nulls":4},"Average Customer Age; Moving Averages, Sums, etc"]
[{"$nulls":4},"Moving Averages Controlled by a SlicerChapter 5: Power Query; Combining Multiple Worksheets or Workbooks into a Single Power Pivot Table; Using Power Query to Merge CSV Files; Using Power Query to \"Unpivot\" a Table; Using Power Query to Create a Lookup Table from a Data Table; Creating a Calendar Table: Advanced Usage of Power Query; Chapter 6: Power View; How to Use Power View; Chapter 7: Power Map; Thank you; Index; More from Holy Macro! Books"]
[null,null,null,"Sommario/riassunto","PowerPivot is an amazing new add-in for Excel 2013 that allows business intelligence pros to process large amounts data. Although it is simple to use in a demo environment, analysts are likely to run into real-life scenarios that are difficult to solve. This guide, dedicated solely to the PowerPivot tool, provides techniques and solutions to real-world problems, including showing the Top N customers by using slicer filters, comparing budget to actuals, drilling across data instead of through data, and joining data from two different sources in a"]
[null,"2.","Record Nr.",null,"UNISALENTO991004346131207536"]
[null,null,"Autore",null,"Laspro, Valerio"]
[null,null,"Titolo",null,"Epistola pastoralis episcopi Lyciensis ecclesiae Gallipolitanae adminstratoris / [Valerius Laspro]"]
[null,null,"Pubbl/distr/stampa",null,"[S.l.] : Ex Typis Raphaelis Tortora, 1872"]
[null,null,"Descrizione fisica",null,"31 p. ; 33 cm"]
[null,null,"Disciplina",null,"252.6"]
[null,null,"Soggetti",null,"Diocesi di Gallipoli - Lettere pastorali"]
[null,null,"Lingua di pubblicazione",null,"Latino"]
[null,null,"Formato",null,"Materiale a stampa"]
[null,null,null,"Livello bibliografico","Monografia"]