chelseafan1989
New Member
- Joined
- Jul 22, 2013
- Messages
- 16
Hello
As per usual you have been wonderful with my other questions and I thank you immensely!
Here's an odd one.
My data analysis system throws out a lot of data in CSV format for us once a week and we've been asked to work out something.
The shops are required to count twice a day a selection of lines. However, the system throws this out as follows:
<tbody>
</tbody>
Assume the following:
* Each store only had 4 counts to do per day
* If counted correctly, status is COUNTED
* If not counted at all, status is EXPIRED
* Even if EXPIRED appears more than once, it only counts once per day (i.e. no store should have any EXPIRED counts on any days, but having more than 1 still only means they have failed one day)
How, using this mix of data, can I check how many DAYS they have missed (i.e. using the example above they have 2 days with expired counts however have missed 4 items across those 2 days).
I've tried putting this into a pivot table with no luck (although it very kindly summarizes the data for me and tells me in total how many counts were required (COUNTED + EXPIRED) and how many were completed (COUNTED). I would then use this data to tell me how many days have been successfully counted (6 - Number of days with EXPIRED).
Also, there are 4 stores so this data will be muliplied by 4 and there will be around 100 rows for each store, with some having up to 300!
Hope this helps, should you need any further information then let me know
Thanking you!
As per usual you have been wonderful with my other questions and I thank you immensely!
Here's an odd one.
My data analysis system throws out a lot of data in CSV format for us once a week and we've been asked to work out something.
The shops are required to count twice a day a selection of lines. However, the system throws this out as follows:
Date | Store Name | Count Type | Exception Status |
29/12/2013 | Store 1 | Standard Count | COUNTED |
29/12/2013 | Store 1 | Standard Count | COUNTED |
29/12/2013 | Store 1 | Standard Count | COUNTED |
29/12/2013 | Store 1 | Standard Count | EXPIRED |
30/12/2013 | Store 1 | Standard Count | COUNTED |
30/12/2013 | Store 1 | Standard Count | EXPIRED |
30/12/2013 | Store 1 | Standard Count | EXPIRED |
30/12/2013 | Store 1 | Standard Count | EXPIRED |
31/12/2013 | Store 1 | Standard Count | COUNTED |
31/12/2013 | Store 1 | Standard Count | COUNTED |
31/12/2013 | Store 1 | Standard Count | COUNTED |
31/12/2013 | Store 1 | Standard Count | COUNTED |
<tbody>
</tbody>
Assume the following:
* Each store only had 4 counts to do per day
* If counted correctly, status is COUNTED
* If not counted at all, status is EXPIRED
* Even if EXPIRED appears more than once, it only counts once per day (i.e. no store should have any EXPIRED counts on any days, but having more than 1 still only means they have failed one day)
How, using this mix of data, can I check how many DAYS they have missed (i.e. using the example above they have 2 days with expired counts however have missed 4 items across those 2 days).
I've tried putting this into a pivot table with no luck (although it very kindly summarizes the data for me and tells me in total how many counts were required (COUNTED + EXPIRED) and how many were completed (COUNTED). I would then use this data to tell me how many days have been successfully counted (6 - Number of days with EXPIRED).
Also, there are 4 stores so this data will be muliplied by 4 and there will be around 100 rows for each store, with some having up to 300!
Hope this helps, should you need any further information then let me know
Thanking you!