Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
The sheet "Customers" contains data from City Health Club. Customers are listed by a customer ID with the plan they signed up for and the date that they paid for the period starting on July 1st. You are given a spreadsheet with the data using a code for the plan.
The codes for the plans are as follows:P = PlatinumG = GoldS = SilverThe Platinum plan costs $99 per period, the Gold plan costs $75 per period and the Silver plan costs $50 per period. If a customer does not want to sign up for a plan and has a no-frills membership, he/she pays $20 per period.Customers can get a discount for paying their dues early according to the following rules:Customers who payReceive a discount of0 <= days < 7 early0%7 <= days <14 early5%14 <= days < 30 early10%30 <= days early15%You are asked to fill in the spreadsheet with the full text for each customer's plan, theLabE2CS11002 of 4discount offered and the amount paid.1. Download, save, and then open the cs1100.e2.xlsx workbook.2. Create a lookup table for the plan codes and prices that will use an exact match. Put your table in the worksheet titled "Health Club Tables" and name the table PlansTable.3. Create an interval lookup table for the discount that will use an inexact match. Put your table in the worksheet titled "Health Club Tables" and name the table DiscountTable.4. Fill in the column for "Discount" using a VLOOKUP function. (Hint: You can find the difference between the dates by subtracting Payment Date from Start Date.)5. Fill in the columns for "Fees" and "Plan" using a VLOOKUP function6. Calculate the total amount due after the discount7. Use IFERROR to strengthen your VLOOKUP formulas so that your model will work even if a customer has no plan listed.8. Using an IF statement, filter the data for each plan. You should be able to copy the IF statement down and across.9. Using SUM calculate the total number of customers in each plan.10. Make sure all of your formulas are copyable and resilient to changes in data.11. Format the worksheet as shown in the figure below:
Attachment:- 351123_1_cs1100.e2.xlsx
Attachment:- cs1100.e2.pdf
Verified Expert
This paper is about use of the excel functions approximately. It is to basically provide a complete knowledge about the use of functions in the ms office , ms excel. This task involved insertion of tables.
Just need to express gratitude toward the expert for such a superb work my paper. It's right on target the subject. Much obliged to you at the end of the day! Will without a doubt request from ExpertsMind later on.
Everything is mentioned in the requirement. Go through requirement again. In Point 2, Create a lookup table for the plan codes and prices that will use an exact match. Put your table in the worksheet titled "Health Club Tables. You need to go through requirement 1 (mentioned in point 2) and do accordingly in the solution file. A sheet named "Health Club Tables" you need to work there. you need to complete the sheet in the format given in the question or only the tables are to be put.? The question asked to insert a table, you have done that and revised it.
Use Euler's Method with (a) h=.5, (b) h=.25, and (c) h=.05 to solve dy/dx=yx^3-2.3y over the interval from x=0 to 2, where y(0)=1.
revise the solution to the balanced-braces problem so that the expression can contain three types of delimiters ( ), [ ], and { }: Thus {ab(c[d])e} is valid, but {ab(c))is not.
An AC inductor motor is rated at 1750 rpm with a line frequency of 60hz. If the motor is operated on a 50 hz line, what will be its approximate speed in rpm.
Section Number is an integer (such as 1 or 2) that distringuishes one section from another for the same course but does not uniquely identify a section. How did you model SECTION? Why did you choose this way versus alternative ways to model SECTIO..
Write down the functions and steps involved in various window applications. What is mail merge? Enumerate the steps involved in mail merge.
How to add validation to a web application
Write a For loop such that the loop till iterate from 1000 to 1 decrementing the counter by 1 each time through the loop. Inside the loop, write a statement to print the counter's value to the Output window.
When the output of some units can be used as inputs to othe units, or if two organizations pools markets and expertise that results in lower costs and generate profits it is often referred to as creating?
Research the simple computer games "Snake" and "Tron."
Include any information you believe adds to the material in the text. Describe any areas where you see disagreement between the two authors.
What is infrastructure? In what was do hardware and system software qualify as infrastructure? What basic strategic planning questions should be addressed with respect to infrastructure?
Describe the effect of an organization's strategic planning on the IT systems it uses. Address how strategic planning simplifies and complicates IT system development and use. This only has to be 200 words.
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd