Reference no: EM133127408

Lottery Game

Goal: To demonstrate mastery of input & message boxes, conditionals, and variable types & declaration.

Your program should do the following:
• Ask user for name
• Ask user for their lottery numbers (4 digits)
o What if they don't give 4 digits?
• Generate a random winning number that the user doesn't see
(4 digits)
o Use a built-in random number generator to generate 4 random integers between 0 & 9, then concatenate them into a string
o Be sure that the randomly generated winning number cannot be "0000"
• Check that the lottery numbers are numbers
• If the user cancels (x's out of the input box) they should "GoTo" the "did not win" output with lottery #0000
• If not, give the user one chance to enter new numbers
• If they still do not give you numbers, make sure they go to the "did not win" option below
• If it is a number, convert it to a string
• Check to see if their given number string matches
o If it matches the entire winning number string in order, this results in a double bonus
o If any 3-4 numbers match in any order, this is a regular (1.25x) bonus
o If only 1-2 numbers match, the winnings have no bonus
o If no numbers match, no win.
• Tell the user, in a personalized message, that they either did or did not win.
o Make sure you reference their lottery number and name in the message for posterity, as well as how much the user won

NOTES:
- The regular jackpot amount is $1,000,000
- The input & message boxes should have titles
- Look up the "GoTo:" command in the cookbook
- Be sure you run through several cases to see that your program does what you expect it to!
- This should be run from a button on the worksheet. The button should say "Play the Lottery" and the worksheet should be named "Assignment2", as well as the sub.
- Repeated numbers will be difficult to deal with (potentially). Make a plan for how you will treat them.

You will be turning in your Exce1NBA (.xlsm) file and a short word document describing at a high level what the different parts of your code does - this description should showcase your understanding of the process and your logic for how your code runs; it does not need to be a line-by-line description. Your code should be broken up into sections using comments, and should contain enough comments that someone looking at it for the first time could follow what is going on. Code without comments will be given a 0.

Use the data set MarketStreetData.xlsx and answer the following questions.

1. What is the average wholesale price of all items?

2. How many items (SKU's) are currently for sale between $7.50 - $10?

3. Create a list of item names that are eligible for a price update and start with "C" OR are less than $6 for their actual updated price

4. Show a list of the stores names and the days of the week and hours they are open

5. Make a unique list of all out of stock items (SKUs) across all stores. Any item that is out of stock anywhere should be on this list.

6. Make a list of all out of stock items (names) and the store (name) they are out of stock at

7. Determine the current stock volume (using the per-item volumes & the number of items in stock)

Attachment:- Lottery Game.rar