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.
What is chained exceptions in java? Explain different layout manager in Java.
Probe into resulting consequence between stakeholders and management as a result of security incidents. Who are the stakeholders?
In April of 1990, entire concept of domain was born, and email addresses "opened up". What might be the prediction about more open standards which may change our world again?
StoreItRite is interviewing candidates for position of Chief Information Officer (CIO). They are asking candidates to describe briefly how they would satisfy StoreItRite's requirements as stated above. How would a successful candidate respond?
Compare the differences between MAC and H-MAC.
Assume the existence of a Window class with methods getWidth and getHeight, and a subclass TitledWindow, with a constructor accepts a string corresponding to the title of the window.
Using a Truth Table or equivalent determine
You should write each functionality from 1-7 in separate functions. You should provide a menu to the user as following:For inputs:
What are some of the reasons that RMO decided to build supply chain management system previous to customer support system?
what the next state of the machine should be as a function of the current state. then produce a combinational circuit using gates and D-flipflops that implements this state machine. label the least and most significant bit.
What would be the pros and cons of selecting in-house development versus a packaged solution for the R/Way system?
Variable cost per pound of fertilizer is $0.15. Evergreen sells fertilizer for $0.40 per pound. Find out the monthly break-even volume for company.
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