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.
Create the following diagrams: a context diagram a workflow diagram an activity diagram a sequence diagram.
The Fibonacci numbers are a sequence of integers in which the first two elements are 1, and each following element is the sum of the two preceding elements
Identify 10 objects in your home that use semiconductors. What other kinds of materials with special electrical properties are found in all of these 10 objects (list at least one per item)
determine the FIRST sets of each of the RHSs of each of the productions. Assume that upper case letters are nonterminals and lower case letters are terminal symbols. A -> abD | acD | D D -> d | eD Apply the pairwise disjointness test to show that ..
What is the proportion of white cars driving past my house?
What aspects of the system do you think should be evaluated. Are those aspects considered in the evaluation. What is the experimental testbed used. What experiments were performed. Details of experimental results. What aspects of the system were n..
Write a program that reads an integer, n, and prints each of its digits from left to right, as an English word.
why does the label control that contains your name print above the page number?
What are some factors or requirements when designing an Active Directory Infrastructure. How do you gather the requirements for the design? Please explain in approximately in two paragraphs.
Write and explain the seven steps of information gathering.
Write a complete C++ program that reworks your Cellular Bill calculation program from Chapter 4. Give your source file a meaningful name, such as CellBillFun.cpp.
Redraw the ERD for this new situation using two entity types, and the redraw it again using one entity type. Which of these two versions do you prefer and why?
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