Member Avatar for Grimmic

I need to make an array using the following info.

Salesperson January February March
1 2400 3500 2000
2 1500 7000 1000
3 600 450 2100
4 790 240 500
5 1000 1000 1000
6 6300 7000 8000
7 1300 450 700
8 2700 5500 6000
9 4700 4800 4900
10 1200 1300 400

I am making an application that will calculate a bonus of whatever percentage value for all 10 people based on their sales for the three months above. The text box display will show what the bonus will be for all the sales people and how much is paid in bonus total for all.
Thanks in advance for any help.

Rob

  • 2 Contributors
  • 1 Reply
  • 128 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by Sheryl99
Member Avatar for Sheryl99

Hi there. I hope this will help! ~ Sheryl

Dim aRay(9, 3)
        aRay(0, 0) = "John Salesman"
        aRay(0, 1) = 2400
        aRay(0, 2) = 3500
        aRay(0, 3) = 2000
        aRay(1, 0) = "Sue Seller"
        aRay(1, 1) = 1500
        aRay(1, 2) = 7000
        aRay(1, 3) = 1000
fill in the remaining items here...

        Dim x, y As Integer
        Dim sales As Double = 0
        For x = 0 To aRay.GetUpperBound(0)
            sales = 0
            For y = 1 To 3
                sales += aRay(x, y)
            Next
            Debug.Print(aRay(x, 0) & " Sales: " & sales)
        Next
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.