VBA project 123- Text me Only If U need this Answer! Text Only!!! I will not Upload the Answer Here! It is a big File!

The following project is to be completed on your own.  You may discuss the project with your classmates.  The final coding is to be done alone.  Code duplication is a violation of the honor code and will be treated as such.  The project is due by the start of class on April.................(NO EXCEPTIONS).

You have been tasked with examining data from your regional Scout packs.  The data file that is in Isidore has the following data:

1.       Scout Name

2.       Scout Den

3.       Badge Earned

4.       Date Earned

The following is needed

1.       Read the data in the file (of arbitrary length) to an array (10 Points)

a.       Use a file dialog to retrieve the data file

2.       Create a record for each scout in the pack with the following information  (25 Points)

a.       Scout Name

b.      Scout Den

c.       Badges Earned (no more than 300 can be earned) THIS NEEDS TO BE AN ARRAY

                                                               i.      .BadgeEarned(300)

d.      Date Earned

e.      Number of awards earned  (THIS IS NEW AND WILL HELP YOU)

Type Scout

    Name As String

     Other data herer

End Type

3.       Output to an Excel Sheet with a column for each scout the  (25 Points)

a.       badges earned by each scout

b.      The header of each column will be the Scout’s name

4.       Output file  (30 Points)

a.       Has the following information

                                                               i.      Number of scout in the pack

                                                             ii.      The total number of awards earned

                                                            iii.      The average number of awards earned per scout

                                                           iv.      The standard deviation of award earned

                                                             v.      The probability of earning 10 awards

b.      Use a file dialog to ask for the file name for output

5.       The input and output sections should check for file name errors. (10 Points)

The program will be tested with a separate dataset from the one included after submission.