CRITERION C (Creating the Solution)

Criterion C: Creating the Solution

Step by step plan in creating the product:

Steps	What to include and why?	Main functions/formulas	Time
1	Design a Main menu sheet. The client can see what sheets are present and must be able to navigate through them easily. It should have buttons of different colors, embedded text of different styles, a logo and a background image.	·      Macros ·      Hyperlinks ·      VBA (Visual Basic for Applications)	2nd October
2	Design the SCS (Stock Control System) sheet. The client must be able to see and analyze the product’s information effectively. It must have filters so that he/she can see a specific product’s information. Data labels will point out the important information in the graph.	·      DAYS	4th October
3	Design the Rating Sheet. The user must be able to see the rating of each product. It will have a 3D pie chart with data labels and a key/legend. It will also have an instar chart making it more presentable to the user.	·      SUBSTITUTE ·      COUNTIF ·      IF ·      MOD ·      ROUNDUP	6th October
4	Design the Marketing Information sheet. It must contain the current status of the stock inventory and calculations must be included in here. The table should look colorful appealing. Filters also must be included.	·      SUMPRODUCT ·      VLOOKUP ·      Goal Seek	8th October
5	Design the SCS (Pivot) sheet. The SCS sheet before must be in the form of a pivot table. This is a simplified report for the user. It must have three 3D graphs of different designs, colors and data labels. It must also have a slicer; similar to that of a filter.	-------	10th October

Screenshots of the product:

Main Menu:

Stock Control System:

                                         

Rating:

Marketing Information:

Part 1:

Part 2:

Stock Control System (Pivot):

Pivot Table:

Pivot Chart:

Here is the actual excel file, if you want to experience the features. Just click the top right icon to download the excel file.