LEADER 05078nam 2200673 a 450 001 9910451195003321 005 20200520144314.0 010 $a1-281-23789-2 010 $a9786611237899 010 $a0-470-37749-6 035 $a(CKB)1000000000406327 035 $a(EBL)333786 035 $a(OCoLC)808678717 035 $a(SSID)ssj0000151680 035 $a(PQKBManifestationID)11153274 035 $a(PQKBTitleCode)TC0000151680 035 $a(PQKBWorkID)10337690 035 $a(PQKB)11756338 035 $a(MiAaPQ)EBC333786 035 $a(CaSebORM)9780470132296 035 $a(Au-PeEL)EBL333786 035 $a(CaPaEBR)ebr10226865 035 $a(CaONFJC)MIL123789 035 $a(EXLCZ)991000000000406327 100 $a20070330d2007 uy 0 101 0 $aeng 135 $aurunu||||| 181 $ctxt 182 $cc 183 $acr 200 10$aExcel 2007 data analysis$b[electronic resource] $eyour visual blueprint for creating and analyzing data, charts and PivotTables /$fby Denise Etheridge 205 $a1st edition 210 $aHoboken, N.J. $cWiley$dc2007 215 $a1 online resource (305 p.) 225 1 $aRead less-learn more 300 $aIncludes index. 311 $a0-470-13229-9 327 $aExcel 2007 Data Analysis: Your visual blueprint for creating and analyzing data, charts, and Pivot Tables; Credits; About the Author; Author's Acknowledgments; TABLE OF CONTENTS; HOW TO USE THIS BOOK; Chapter 1: Getting Started; Introduction to Data Analysis with Excel; Understanding the Excel Window; Enter Data; Format Numbers; Format Cells; Select Data; Copy, Cut, and Paste Cells; Copy with the Office Clipboard; Insert and Delete Cells; Find and Replace; Find and Replace Formats; Chapter 2: Creating Formulas; Understanding Formulas; Create Formulas; Edit Formulas; Name Cells and Ranges 327 $aDefine and Display Constants Create Formulas that Include Names; Check Formulas for Errors; Trace Precedents and Dependents; Chapter 3: Creating and Using Functions; Understanding the Function Wizard; Round a Number; Determine the Nth Largest Value; Create a Conditional Formula; Calculate a Conditional Sum; Calculate Products and Square Roots; Look Up Information; Determine the Location of a Value; Perform Time Calculations; Perform Date Calculations; Chapter 4: Using Financial Functions; Calculate Future Value; Calculate Present Value; Calculate Loan Payments; Calculate Principal or Interest 327 $aCalculate the Interest Rate Calculate the Internal Rate of Return; Calculate Straight-Line Depreciation; Calculate Declining Balance Depreciation; Calculate Double-Declining Balance Depreciation; Calculate Sum-of-the-Years-Digits Depreciation; Chapter 5: Using Statistical Functions and Tools; Calculate an Average; Calculate the Median or the Mode; Calculate Rank; Calculate Frequency; Calculate Variance and Standard Deviation; Find the Correlation; Install Excel Add-Ins; Calculate a Moving Average; Compare Variances; Using the Data Analysis Toolpak to Determine Rank and Percentile 327 $aCalculate Descriptive Statistics Chapter 6: Organizing Worksheet Data; Enter Data with a Form; Filter Duplicate Records; Perform Simple Sorts and Filters; Perform Complex Sorts; Sort by Cell Color, Font Color, or Icon; Perform Complex Filters; Enter Criteria to Find Records; Filter by Multiple Criteria; Subtotal Sorted Data; Count Filtered Records; Define Data as a Table; Modify a Table Style; Chapter 7: Working with PivotTables; Create a PivotTable; Modify PivotTable Data and Layout; Compute Subtotals and Grand Totals; Create a Pivot Table Calculated Field; Hide Rows or Columns in a PivotTable 327 $aSort a PivotTable Retrieve Values from a PivotTable; Chapter 8: Charting Data; Create a Chart; Add Chart Details; Change the Chart Type; Add a Trendline; Add and Remove Chart Data; Add Error Bars; Create a Histogram; Chart Filtered Data; Create a PivotChart; Create a Combination Chart; Chapter 9: Working with External Data; Paste Link into Word; Embed a Worksheet; Hyperlink a Worksheet; Query a Web Site; Import a Text File; Import an Access Database; Query an Access Database; Chapter 10: Useful Data Analysis Tools and Techniques; Perform What-If Analysis; Optimize a Result with Goal Seek 327 $aSolve a Formula with a Data Table 330 $aProvides instructions on using Excel to analyze data, covering such topics as creating formulas, using financial functions, organizing worksheet data, working with PivotTables, and automating with macros. 410 0$aVisual read less, learn more. 606 $aBusiness$xComputer software$2sears 606 $aSpreadsheet software$2sears 608 $aElectronic books. 615 7$aBusiness$xComputer software. 615 7$aSpreadsheet software. 676 $a005.54 700 $aEtheridge$b Denise$0886700 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910451195003321 996 $aExcel 2007 data analysis$92106427 997 $aUNINA LEADER 04752nam 2200649Ia 450 001 9910145834403321 005 20230721004939.0 010 $a1-282-00933-8 010 $a9786612009334 010 $a1-4443-0255-8 010 $a1-4443-0256-6 035 $a(CKB)1000000000715936 035 $a(EBL)416382 035 $a(OCoLC)437096833 035 $a(SSID)ssj0000119079 035 $a(PQKBManifestationID)11131636 035 $a(PQKBTitleCode)TC0000119079 035 $a(PQKBWorkID)10056815 035 $a(PQKB)10243166 035 $a(MiAaPQ)EBC416382 035 $a(Au-PeEL)EBL416382 035 $a(CaPaEBR)ebr10279131 035 $a(CaONFJC)MIL200933 035 $a(EXLCZ)991000000000715936 100 $a20070907d2008 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aCDM regulations 2007$b[electronic resource] $eprocedures manual /$fStuart D. Summerhayes 205 $a3rd ed., Rev. 210 $aOxford, UK ;$aMalden, MA $cBlackwell Pub.$d2008 215 $a1 online resource (203 p.) 300 $aDescription based upon print version of record. 311 $a1-4051-4002-X 320 $aIncludes bibliographical references (p. [191]) and index. 327 $aContents; HOW THIS MANUAL WORKS; Section 1: INTRODUCTION; Section 2: APPLICATION AND INTERPRETATION; 2.1 Application; Table 2.1 THE MAIN RESPONSIBILITIES OF DUTY HOLDERS; 2.2 Interpretation; 2.3 Additional exclusions; Section 3: ALL DUTY HOLDERS; 3.1 Introduction; Table 3.1 PROJECT MANAGEMENT DESCRIPTORS FOUND IN THE REGULATIONS; Figure 3.1 HOLISTIC DIAGRAM; Section 4: THE CLIENT; 4.1 CLIENT FLOWCHART: ALL PROJECTS; 4.2 CLIENT FLOWCHART: NOTIFIABLE PROJECTS, ADDITIONAL DUTIES; 4.3: CLIENT CHECKLIST; 4.4: CLIENT CHECKLIST: NOTIFIABLE PROJECTS; Section 5: THE DESIGNER; 5.1 Introduction 327 $aFigure 5.1 REGULATIONS TO BE DISCHARGED BY DESIGNERS5.2 All projects; 5.3 Identification; 5.4 Evaluation; 5.5 Contribution; 5.6 Design change; Figure 5.2 SYSTEMS APPROACH FOR THE DESIGNER; 5.1 DESIGNER FLOWCHART: ALL PROJECTS; 5.2 DESIGNER FLOWCHART: NOTIFIABLE PROJECTS, ADDITIONAL DUTIES; 5.3 DESIGNER CHECKLIST: ALL PROJECTS; 5.4 DESIGNER CHECKLIST: ADDITIONAL DUTIES FOR NOTIFIABLE PROJECTS; Section 6: THE CONTRACTOR; Figure 6.1 CONTRACTOR DUTIES: ALL PROJECTS; 6.1 CONTRACTOR FLOWCHART: ALL PROJECTS; Figure 6.2 CONTRACTOR: ADDITIONAL DUTIES ON NOTIFIABLE PROJECTS 327 $a6.2 CONTRACTOR FLOWCHART: NOTIFIABLE PROJECTS, ADDITIONAL DUTIES6.3 CONTRACTOR CHECKLIST: ALL PROJECTS; 6.4 CONTRACTOR CHECKLIST: NOTIFIABLE PROJECTS, ADDITIONAL DUTIES; Section 7: THE CDM CO-ORDINATOR; 7.1 Introduction; 7.2 Appointment; Figure 7.1 CDM CO-ORDINATION DUTIES; 7.1 CDM CO-ORDINATOR FLOWCHART; 7.2 CDM CO-ORDINATOR CHECKLIST; Section 8: THE PRINCIPAL CONTRACTOR; Figure 8.1 REGULATIONS TO BE DISCHARGED BY PRINCIPAL CONTRACTOR; 8.1 PRINCIPAL CONTRACTOR FLOWCHART; 8.2 PRINCIPAL CONTRACTOR CHECKLIST; Section 9: DOCUMENTATION; 9.1 Introduction; 9.2 Pre-construction information 327 $aFigure 9.1 FLOW OF PRE-CONSTRUCTION INFORMATION9.3 Construction phase plan; 9.4 Health and safety file; 9.5 Project risk register; 9.1 PROJECT RISK REGISTER (HEALTH AND SAFETY); Section 10: CHECKLISTS AND AGENDAS; 10.1 CHECKLIST FOR NON-NOTIFIABLE PROJECTS; 10.2 CHECKLIST OF ADDITIONAL DUTIES FOR NOTIFIABLE PROJECTS; 10.3 INITIAL DESIGN/CLIENT MEETING: PROMPT LIST; 10.4 PRE-START MEETING: PROMPT LIST (NON NOTIFIABLE PROJECTS); 10.5 PRE-START MEETINGS: PROMPT LIST (NOTIFIABLE PROJECTS) AND ADDITIONAL POINTS; 10.6 PROGRESS MEETING: PROMPT LIST; Section 11: COMPETENCE; WEB PAGE DIRECTORY 327 $aBibliographyINDEX 330 $aThis Procedures Manual provides a documentation system which has been developed by a practising CDM co-ordinator for use with the Construction (Design and Management) Regulations 2007.It addresses the full range of obligations on all parties for compliance with the statutory requirements and features:* flow charts* checklists* model formsThe revised Third Edition of the Manual reflects the extensive changes to the CDM Regulations 2007, including:* the new role of CDM co-ordinator* wider and more onerous duties on clients* changes 606 $aConstruction industry$xSafety regulations$zGreat Britain 606 $aIndustrial safety$zGreat Britain 615 0$aConstruction industry$xSafety regulations 615 0$aIndustrial safety 676 $a343.41/078624 676 $a363.119624 700 $aSummerhayes$b Stuart$0879121 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910145834403321 996 $aCDM regulations 2007$92154189 997 $aUNINA