Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
A 1 2 3 4 5 6 7 8 9 10 fx 1 2 3 4 5 6 fx Months 7 8 9 10 11 12 Grand Total A fx A 1 2 3 4 5 6 7 8 Months 7 8 9 10 11 tant A A 1 Consultant 2 3 4 5 6 7 8 Enter text or formula here A B Company 1 Anderson, Brant Johnson, Andrea Smith, Kade Stewart, Travis Grand Total A Months 167.9 691.9 859.8 C D E Company 2 Company 3 Company 4 Company 5 84.3 161.9 7 9 8 10 11 12 Links Disabled - Links to external workbooks are not supported and have been disabled. B 87.2 167.9 458.7 Enter text or formula here Grand Total Company 1 87.2 458.7 545.9 B 364.1 598.8 652.6 Hour totals by Consultant 1615.5 Enter text or formula here total hours by consultant by mo 24 172.1 178 184 168 с D E Company 2 Company 3 Company 4 Company 5 84.3 161.9 178.7 904.8 246.2 Links Disabled - Links to external workbooks are not supported and have been disabled. C 364.1 598.8 652.6 D Anderson, Brant Johnson, Andrea Smith, Kade 36 167.9 171.7 184.4 167.9 176.2 904.1 89.4 F 197.1 171.6 181.2 639.3 1.7 1.7 B C D E Sum of Billable Hours Sum of Non-Billable Hours Sum of Travel Hours Sum of PTO Hours 533.8 320.7 45.7 270.4 357.4 4 595 289.6 19.5 480 295.9 48 1879.2 1263.6 117.2 Company 6 Links Disabled - Links to external workbooks are not supported and have been disabled. Total Sales By Month By Custome E F Total Hours By Category 24.3 169.4 176.3 179 119.1 155.8 823.9 G 4.6 7.5 0 0 12.1 F Stewart, Travis Grand Total 84.3 598.8 526 744.5 626.6 691.9 3272.1 3 3 1.7 G Company 6 Grand Total 84.3 526 598.8 744.5 626.6 691.9 3272.1 H H G Tota F V

A 1 2 3 4 5 6 7 8 9 10 fx 1 2 3 4 5 6 fx Months 7 8 9 10 11 12 Grand Total A fx A 1 2 3 4 5 6 7 8 Months 7 8 9 10 11 tant A A 1 Consultant 2 3 4 5 6 7 8 Enter text or formula here A B Company 1 Anderson, Brant Johnson, Andrea Smith, Kade Stewart, Travis Grand Total A Months 167.9 691.9 859.8 C D E Company 2 Company 3 Company 4 Company 5 84.3 161.9 7 9 8 10 11 12 Links Disabled - Links to external workbooks are not supported and have been disabled. B 87.2 167.9 458.7 Enter text or formula here Grand Total Company 1 87.2 458.7 545.9 B 364.1 598.8 652.6 Hour totals by Consultant 1615.5 Enter text or formula here total hours by consultant by mo 24 172.1 178 184 168 с D E Company 2 Company 3 Company 4 Company 5 84.3 161.9 178.7 904.8 246.2 Links Disabled - Links to external workbooks are not supported and have been disabled. C 364.1 598.8 652.6 D Anderson, Brant Johnson, Andrea Smith, Kade 36 167.9 171.7 184.4 167.9 176.2 904.1 89.4 F 197.1 171.6 181.2 639.3 1.7 1.7 B C D E Sum of Billable Hours Sum of Non-Billable Hours Sum of Travel Hours Sum of PTO Hours 533.8 320.7 45.7 270.4 357.4 4 595 289.6 19.5 480 295.9 48 1879.2 1263.6 117.2 Company 6 Links Disabled - Links to external workbooks are not supported and have been disabled. Total Sales By Month By Custome E F Total Hours By Category 24.3 169.4 176.3 179 119.1 155.8 823.9 G 4.6 7.5 0 0 12.1 F Stewart, Travis Grand Total 84.3 598.8 526 744.5 626.6 691.9 3272.1 3 3 1.7 G Company 6 Grand Total 84.3 526 598.8 744.5 626.6 691.9 3272.1 H H G Tota F V

Database System Concepts
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
See similar textbooks
icon
Related questions
Question

Provide a suitable chart for the 4 spread 

Instructions For this assignment, there are four different types of charts that you will need to create. also have needed to have determined which chart type fits the best for each question (there could be more than one answer, but you only need to choose one for each question). You will also need to create the chart based upon the data in the Excel spreadsheet. There are four tabs in the worksheet below. NNNNNNNN 18 19 20 21 23 24 25 Design Development 26 Documentation www 1 Hourly Category 2 Attend Training 3 Conduct Training 4 Configuration 5 Content Development 6 CRM Configuration 7 CRM Data Migration 8 CRM Design 9 10 11 12 CRM Integration Implementation 13 CRM Project Management 14 CRM Report Customization 15 CRM Scoping 16 CRM Support 17 CRM Testing CRM Upgrade Installation CRM Upgrade Scoping CRM Workflow Customization Data Migration 1. For the "Hour Totals By Consultant" tab, I need for you to pick a chart type that will allow me to see the distribution of the types of time entries entered by consultant. There are four types of possible hour types, "PTO", "Travel Hours", "Non-Billable Hours", and "Billable Hours". The title of the chart should be "Total Hours by Consultant by Hour Type". Please create this chart and put it on that tab. You can format it however you like. However, make sure that the format you choose accomplishes the goal of the chart. 2. For the "total hours by consultant by mo" tab, I need for you to pick a chart type that shows the trend by month. The chart should show the months in the correct order. Also, I need to see that trend by consultant. Create this chart on the same tab. You can format it however you like. However, make sure that the format you choose accomplishes the goal of the chart. 3. For the "total hours by category" tab, I need for you to pick a chart type that will allow for me to determine the total hours by category and its percentage of the whole. Make sure the chart is easy to read. You can choose whatever format you like. However, make sure that the format you choose accomplishes the goal of the chart. 4. For the "totals sales by month by cust." tab, I need for you to create a chart that looks like this: Total Sales by Month by Customer 31 800 700 600 500 400 Links Disabled - Links to external wo 22 Database/Company Set Up Demonstration 300 200 100 fx 0 27 Form Customization 28 Holiday 29 Installation 30 U A CRM Development CRM Form Customization CRM Installation fx 32 33 34 35 36 37 38 Research 39 Sales Support 40 Scoping 41 Scribe Installation Integration Design Office Time Onsite Support Preparation/Planning LO Project Management PTO 42 Scribe Integration Support 43 Self Study 44 Status Meeting 45 Subject Matter Expert Consulting 46 Support 47 48 49 50 51 Upgrade Testing 52 Workflow Customization 53 Grand Total 54 Remote Service Pack Deployment Report Customization System Administration Team Meeting Testing Upgrade Installation 7 1 Months 2 7 3 8 4 9 5 10 6 11 7 12 8 Grand Total 9 10 A 1 Months 2 7 3 8 4 9 5 10 6 11 fx tant A Company 1 # Company 2 Company 3 Company 4 Enter text or formula | Links Disabled - Links to external workbooks are not supported and have been disabled. A B Sum of total Hours 149.2 38.9 20.5 182.3 44.8 10.4 57.2 25.3 42.7 0.5 6.6 164.2 12.6 34.9 349.9 19.7 12 1.3 23.8 10.6 5.6 16.3 5.9 1.6 27.3 49.5 136 20.5 1.3 687.1 14.5 8.7 76.4 117.2 2.3 56.4 8.7 4.5 64.2 0.4 0.8 113.7 15.4 1 Consultant 2 Anderson, Brant 3 Johnson, Andrea 4 5 Total Hours By Category Smith, Kade Stewart, Travis 6 Grand Total 7 8 fx 107.3 379.7 7.1 35.4 54.3 2.3 38.3 6 3272.1 A 1 Months 2 3 4 C B 10 Company 1 7 9 8 10 11 12 5 6 7 8 Grand Total fx 167.9 691.9 859.8 II Enter text or formula here Company 5 Company 6 D B 11 Company 1 E B с D E Company 2 Company 3 Company 4 Company 5 84.3 161.9 Links Disabled - Links to external workbooks are not supported and have been disabled. 87.2 458.7 Enter text or formula here 87.2 458.7 545.9 167.9 12 24 172.1 178 184 168 178.7 904.8 Hour totals by Consultant 364.1 598.8 652.6 1615.5 Enter text or formula here total hours by consultant by mo C D E Company 2 Company 3 Company 4 Company 5 84.3 161.9 Links Disabled - Links to external workbooks are not supported and have been disabled. C 246.2 Hour totals by Consultant 364.1 598.8 652.6 89.4 197.1 171.6 181.2 639.3 Enter text or formula here F B с D E Sum of Billable Hours Sum of Non-Billable Hours Sum of Travel Hours Sum of PTO Hours 533.8 320.7 45.7 4 270.4 357.4 595 289.6 19.5 480 295.9 48 1879.2 1263.6 117.2 Links Disabled - Links to external workbooks are not supported and have been disabled. D 1.7 1.7 F Anderson, Brant Johnson, Andrea Smith, Kade Stewart, Travis Grand Total 84.3 598.8 526 744.5 626.6 691.9 3272.1 36 167.9 171.7 184.4 167.9 176.2 904.1 Company 6 Total Sales By Month By Custome E F Total Hours By Category G 24.3 169.4 176.3 179 119.1 155.8 823.9 4.6 7.5 0 0 12.1 3 1.7 G Company 6 Grand Total 84.3 526 598.8 744.5 626.6 691.9 3272.1 H H G F + > Tota + > |
Transcribed Image Text:Instructions For this assignment, there are four different types of charts that you will need to create. also have needed to have determined which chart type fits the best for each question (there could be more than one answer, but you only need to choose one for each question). You will also need to create the chart based upon the data in the Excel spreadsheet. There are four tabs in the worksheet below. NNNNNNNN 18 19 20 21 23 24 25 Design Development 26 Documentation www 1 Hourly Category 2 Attend Training 3 Conduct Training 4 Configuration 5 Content Development 6 CRM Configuration 7 CRM Data Migration 8 CRM Design 9 10 11 12 CRM Integration Implementation 13 CRM Project Management 14 CRM Report Customization 15 CRM Scoping 16 CRM Support 17 CRM Testing CRM Upgrade Installation CRM Upgrade Scoping CRM Workflow Customization Data Migration 1. For the "Hour Totals By Consultant" tab, I need for you to pick a chart type that will allow me to see the distribution of the types of time entries entered by consultant. There are four types of possible hour types, "PTO", "Travel Hours", "Non-Billable Hours", and "Billable Hours". The title of the chart should be "Total Hours by Consultant by Hour Type". Please create this chart and put it on that tab. You can format it however you like. However, make sure that the format you choose accomplishes the goal of the chart. 2. For the "total hours by consultant by mo" tab, I need for you to pick a chart type that shows the trend by month. The chart should show the months in the correct order. Also, I need to see that trend by consultant. Create this chart on the same tab. You can format it however you like. However, make sure that the format you choose accomplishes the goal of the chart. 3. For the "total hours by category" tab, I need for you to pick a chart type that will allow for me to determine the total hours by category and its percentage of the whole. Make sure the chart is easy to read. You can choose whatever format you like. However, make sure that the format you choose accomplishes the goal of the chart. 4. For the "totals sales by month by cust." tab, I need for you to create a chart that looks like this: Total Sales by Month by Customer 31 800 700 600 500 400 Links Disabled - Links to external wo 22 Database/Company Set Up Demonstration 300 200 100 fx 0 27 Form Customization 28 Holiday 29 Installation 30 U A CRM Development CRM Form Customization CRM Installation fx 32 33 34 35 36 37 38 Research 39 Sales Support 40 Scoping 41 Scribe Installation Integration Design Office Time Onsite Support Preparation/Planning LO Project Management PTO 42 Scribe Integration Support 43 Self Study 44 Status Meeting 45 Subject Matter Expert Consulting 46 Support 47 48 49 50 51 Upgrade Testing 52 Workflow Customization 53 Grand Total 54 Remote Service Pack Deployment Report Customization System Administration Team Meeting Testing Upgrade Installation 7 1 Months 2 7 3 8 4 9 5 10 6 11 7 12 8 Grand Total 9 10 A 1 Months 2 7 3 8 4 9 5 10 6 11 fx tant A Company 1 # Company 2 Company 3 Company 4 Enter text or formula | Links Disabled - Links to external workbooks are not supported and have been disabled. A B Sum of total Hours 149.2 38.9 20.5 182.3 44.8 10.4 57.2 25.3 42.7 0.5 6.6 164.2 12.6 34.9 349.9 19.7 12 1.3 23.8 10.6 5.6 16.3 5.9 1.6 27.3 49.5 136 20.5 1.3 687.1 14.5 8.7 76.4 117.2 2.3 56.4 8.7 4.5 64.2 0.4 0.8 113.7 15.4 1 Consultant 2 Anderson, Brant 3 Johnson, Andrea 4 5 Total Hours By Category Smith, Kade Stewart, Travis 6 Grand Total 7 8 fx 107.3 379.7 7.1 35.4 54.3 2.3 38.3 6 3272.1 A 1 Months 2 3 4 C B 10 Company 1 7 9 8 10 11 12 5 6 7 8 Grand Total fx 167.9 691.9 859.8 II Enter text or formula here Company 5 Company 6 D B 11 Company 1 E B с D E Company 2 Company 3 Company 4 Company 5 84.3 161.9 Links Disabled - Links to external workbooks are not supported and have been disabled. 87.2 458.7 Enter text or formula here 87.2 458.7 545.9 167.9 12 24 172.1 178 184 168 178.7 904.8 Hour totals by Consultant 364.1 598.8 652.6 1615.5 Enter text or formula here total hours by consultant by mo C D E Company 2 Company 3 Company 4 Company 5 84.3 161.9 Links Disabled - Links to external workbooks are not supported and have been disabled. C 246.2 Hour totals by Consultant 364.1 598.8 652.6 89.4 197.1 171.6 181.2 639.3 Enter text or formula here F B с D E Sum of Billable Hours Sum of Non-Billable Hours Sum of Travel Hours Sum of PTO Hours 533.8 320.7 45.7 4 270.4 357.4 595 289.6 19.5 480 295.9 48 1879.2 1263.6 117.2 Links Disabled - Links to external workbooks are not supported and have been disabled. D 1.7 1.7 F Anderson, Brant Johnson, Andrea Smith, Kade Stewart, Travis Grand Total 84.3 598.8 526 744.5 626.6 691.9 3272.1 36 167.9 171.7 184.4 167.9 176.2 904.1 Company 6 Total Sales By Month By Custome E F Total Hours By Category G 24.3 169.4 176.3 179 119.1 155.8 823.9 4.6 7.5 0 0 12.1 3 1.7 G Company 6 Grand Total 84.3 526 598.8 744.5 626.6 691.9 3272.1 H H G F + > Tota + > |
Expert Solution
Step 1

Let's do the chart one by one from the beginning

 

steps

Step by step

Solved in 5 steps with 8 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Fundamentals of Robotics
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS