Sat 26 Aug 2017

Downloads 18 - Sample CSV Files / Data Sets for Testing (till 1.5 Million Records) - Sales

By |Saturday, August 26th, 2017|Categories: Downloads, VBA|Tags: , , , , , , , , , , , , , , , , , , , , , |0 Comments

Disclaimer - The datasets are generated through random logic in VBA. These are not real sales data and should not be used for any other purpose other than testing.

You can download sample csv files ranging from 100 records to 1500000 records. 1.5 Million records will cross 1 million limit of Excel. But 1.5 Million Records are useful for Power Query / Power Pivot. These csv files contain data in various formats like Text and Numbers which should satisfy your need for testing.

This data set can be categorized under "Sales" category.

Below are the fields which appear as part of these csv files as first line.

(more…)

Mon 14 Sep 2015

Solution - Challenge 23 – Make Bar Chart to Show Performance

By |Monday, September 14th, 2015|Categories: Solutions|Tags: , , , , |0 Comments

-- The solution workbook related to this challenge solution can be downloaded from Solution - Challenge 23 – Make Bar Chart to Show Performance --

Below is a possible solution to the challenge Challenge 23 – Make Bar Chart to Show Performance

1. Download the workbook from Salesman Performance Challenge
2. Select range A1:C7
3. Insert > Chart > Choose the appropriate bar chart. You will get the chart like below -

(more…)

Sat 15 Aug 2015

Challenge 23 - Make Bar Chart to Show Performance

By |Saturday, August 15th, 2015|Categories: Challenges|Tags: , , , , |1 Comment

This time challenge is to create a bar chart like below to show the Target Planned and Target Achievement.

Related Excel you can download here Salesman Performance Challenge

Salesman Performance

You may post your solution in comments section.

Note - Solution to this challenge will be published after 1 month i.e. on 14-Sep-15.

Mon 13 Jul 2015

Solution - Challenge 12 – Student Scoring Maximum Total Score

By |Monday, July 13th, 2015|Categories: Solutions|Tags: , , , , , , , |0 Comments

Below is a proposed solution for the challenge Challenge 12 – Student Scoring Maximum Total Score

Put following Array formula in N2

=INDEX(A2:A20,MATCH(MAX(MMULT(B2:K20,TRANSPOSE(COLUMN(B2:K20)^0))),
MMULT(B2:K20,TRANSPOSE(COLUMN(B2:K20)^0)),0))

Put following Array formula in N3

=MAX(MMULT(B2:K20,TRANSPOSE(COLUMN(B2:K20)^0)))

The solution sheet for this can be downloaded from Solution - Challenge 12 – Student Scoring Maximum Total Score