I need assistance with following (Visual Basic .Net) VB.NET program. I can build the GUI, however I need help with the

calculation for the box office average against the movies.

List your employees names in a drop down combo box. When the user selects a employee, display in a text area all of their

previous work performed under code name James Bond 007. In a single text area, output the data in this order:

Year Name of Mission Adjusted total box office

Obtain the required information from attached "Program 3 Data.txt".

1. Ensure that when a employee is selected, any text area is cleared and the new employee data is displayed.

2. Create a clear button that clears all of the text in the text area, clears the summary area and resets the combo box to its

default setting.

3. Create an exit button.

4. Ensure to provide instruction to the user of how to use the program. Create a menu bar item which contains a help function.

5. Use a single text area for the display.

6. Create a 'Summary' area on the GUI that allows for quick reference.

7. In the summary area, create a check box for each employee so that a user can either select any number of employees.

8. When an employee is selected, display the Adjusted Box average of all missions the employee participated in on a new

label.

9. When two or more employees are selected, display the most profitable employees name and averaged adjusted box office.

10. To average the adjusted box office, average the total box office against the number of movies the employee worked.

Year          Title                                            Actor                       Inflation Adjusted Total Box Office

1962        Dr. No                                          Sean Connery              $425,488,741

1963        From Russia with Love                    Sean Connery              $555,909,803

1964        Goldfinger                                     Sean Connery              $868,659,354

1965        Thunderball                                   Sean Connery              $966,435,555

1967        You Only Live Twice                        Sean Connery               $720,388,023

1969        On Her Majesty's Secret Service        George Lazenby            $513,445,231

1971        Diamonds Are Forever                     Sean Connery              $617,520,987

1973        Live and Let Die                              Roger Moore                $785,677,477

1974        The Man with the Golden Gun            Roger Moore                $426,826,774

1977         The Spy Who Loved Me                    Roger Moore               $666,367,656

1979         Moonraker                                       Roger Moore                $624,527,272

1981         For Your Eyes Only                            Roger Moore                $481,005,579

1983         Octopussy                                        Roger Moore                $405,873,493

1985         A View to a Kill                                   Roger Moore                 $316,186,616

1987        The Living Daylights                            Timothy Dalton              $362,876,056

1989          Licence to Kill                                    Timothy Dalton               $271,586,451

1995         GoldenEye                                          Pierce Brosnan               $499,954,330

1997        Tomorrow Never Dies                             Pierce Brosnan               $465,588,535

1999        The World Is Not Enough                        Pierce Brosnan               $504,705,882

2002         Die Another Day                                   Pierce Brosnan               $546,490,272

2006        Casino Royale                                       Daniel Craig                   $640,803,677

2008        Quantum of Solace                                 Daniel Craig                    586,090,727