In this simple 3 column dataset shown below, one can see the month wise demand and energy charge for 2 years – 2017 and 2018. The objective is to compute the month wise demand charge for x months ended a certain user defined Year and Month. So, if a user selects the Year as 2018, […]
Read More →
Here’s a simple Sales data of a retail Store which sells Apple Products. Since a customer can transact multiple times, there will be repetitions in the Cust ID column. While Cust ID 123 and 782 purchased multiple products from the same Store in one transaction, Cust ID 53 purchased multiple products from different stores (Store […]
Read More →
Assume a three column dataset with Patient ID, Smoking Status and Review Date PatientID SmokingStatus ReviewDate P1 10-03-2018 P1 9 09-03-2018 P1 1 08-03-2018 P1 4 07-03-2018 P2 9 10-03-2018 P2 9 09-03-2018 P2 9 08-03-2018 P2 9 07-03-2018 P3 2 10-03-2018 P3 09-03-2018 P3 9 08-03-2018 P4 9 10-03-2018 P4 1 09-03-2018 P4 4 […]
Read More →
Visualise a 5 column dataset as show below. This is a very small sample of the actual dataset. It shows the date on which supplies were received for each item from Vendors and whether those supplies had errors in them. Finally those identified errors have been bucketed into relevant categories. The Item ID# is a […]
Read More →
Here is a simple 3 column dataset showing Categories, Date and Value Catagorie Date Value Fish 08-12-2015 6 Crab 05-12-2015 7 Crab 04-12-2015 6 Bird 27-11-2015 4 Snow 25-11-2015 10 Cat 21-11-2015 7 Dog 12-11-2015 5 Dog 28-10-2015 5 Fish 12-10-2015 3 Bird 11-10-2015 9 Dog 22-09-2015 9 Crab 17-08-2015 8 Cat 11-08-2015 1 Fish […]
Read More →
Imagine a multi column exam invigilation schedule with the following information S. No. Name of staff Designation of staff member Two columns for each day on which there is an exam – one for Morning and another for Afternoon A * under each column if that particular staff member has to be an invigilator during […]
Read More →
Here’s a dataset with 3 columns – Patient Name, Date of admission and Duration (days). Patient Date of admission Duration (day) A 10-10-2017 25 B 20-10-2017 6 C 23-10-2017 12 D 29-10-2017 9 The objective is to split the hospitalization per patient into different months to determine each month’s revenue accrual. The expected result is […]
Read More →
{ 0 Comments }
Here’s a simple 3 column table showing Date, Project name (Cat.) and Status of the project. Each project can have multiple status entries on different dates. So as you can observe, project “alpha_9383993” was In Progress on Oct 2, 2017, remained so on October 5, 2017 but was completed on October 6, 2017. Date Cat. […]
Read More →
Here’s a simple dataset showing the Date of sale, Customer Name and Sales amount. Date Customer Name Sales amount 12-03-2017 A 1 12-03-2017 A 2 12-03-2017 A 3 12-03-2017 B 4 12-03-2017 B 5 12-03-2017 B 6 12-03-2017 B 7 12-03-2017 B 8 13-03-2017 A 1 13-03-2017 A 1 The objective is to determine Customer […]
Read More →
Here’s a simple two column dataset Comment Identifier Intervals A 3pm-6pm A 9pm-12pm S 3pm-6pm S 3pm-6pm S 9pm-12pm A 9pm-12pm S 9pm-12pm D 3pm-6pm A 9pm-12pm A 9pm-12pm A 9pm-12pm A 3pm-6pm A 3pm-6pm For identifiers listed in column A, there are time intervals in column B. Note that for a certain identifier, a […]
Read More →
Flex a Pivot Table to show data for x months ended a certain user defined month
{ 4 Comments }