Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tracking the Trend of Occurrences
Below is my spreadsheet. It tracks the Service Availability of an Agency. My
question is this.. What function would I use to capture Service Agency Availability - if I wanted to identify Y=Yes, P=Partial. Yes for full days, Partial is for 1/2 days. Would it be Count? Match? Index? The Area is used in another report using the # of days. Agency Area Timeline type Days X B 3-Jul Accept 1 X C 3-Jul Accept 1 X C 4-Jul Close 1 X B 4-Jul Accept 1 X C 5-Jul Ref by Ref 1 X B 5-Jul Ref by Ref 1 X B 10-Jul Ref by Ref 1 X C 10-Jul Ref by Ref 0.5 X B 11-Jul Close 1 X C 11-Jul Close 0.5 VON Accept Ref by Ref Close 3-Jul 4-Jul 5-Jul 10-Jul 11-Jul thanks for any ideas you can share twith me -- bmac |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tracking the Trend of Occurrences
Not sure what you're asking.
For 3-Jul you have 2 full days. For 10-Jul you 1 full day and 1 half day. ??? -- Biff Microsoft Excel MVP "bmac" wrote in message ... Below is my spreadsheet. It tracks the Service Availability of an Agency. My question is this.. What function would I use to capture Service Agency Availability - if I wanted to identify Y=Yes, P=Partial. Yes for full days, Partial is for 1/2 days. Would it be Count? Match? Index? The Area is used in another report using the # of days. Agency Area Timeline type Days X B 3-Jul Accept 1 X C 3-Jul Accept 1 X C 4-Jul Close 1 X B 4-Jul Accept 1 X C 5-Jul Ref by Ref 1 X B 5-Jul Ref by Ref 1 X B 10-Jul Ref by Ref 1 X C 10-Jul Ref by Ref 0.5 X B 11-Jul Close 1 X C 11-Jul Close 0.5 VON Accept Ref by Ref Close 3-Jul 4-Jul 5-Jul 10-Jul 11-Jul thanks for any ideas you can share twith me -- bmac |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tracking the Trend of Occurrences
thank you Biff for your time...
The July 10 Ref by Ref 1.5 timeline skews things because it's missing the other .5 day that area C is available. If July 10 for Area C had a half day THEN they would have had a July 10 half day for either Accepted or Closed. The overall point of this is to track the trends and frequency of Weekend service availability. The end result is to identify the % of service availability in a Quarter April-June The agency gives us a weekly service updates with AM/PM availability. VON Accept Ref by Ref Close 3-Jul Yes Results: Yes service was accepted 10-Jul Partial Yes Results: having a Partial 1/2 day as well as Closed 1/2 day -- bmac "T. Valko" wrote: Not sure what you're asking. For 3-Jul you have 2 full days. For 10-Jul you 1 full day and 1 half day. ??? -- Biff Microsoft Excel MVP "bmac" wrote in message ... Below is my spreadsheet. It tracks the Service Availability of an Agency. My question is this.. What function would I use to capture Service Agency Availability - if I wanted to identify Y=Yes, P=Partial. Yes for full days, Partial is for 1/2 days. Would it be Count? Match? Index? The Area is used in another report using the # of days. Agency Area Timeline type Days X B 3-Jul Accept 1 X C 3-Jul Accept 1 X C 4-Jul Close 1 X B 4-Jul Accept 1 X C 5-Jul Ref by Ref 1 X B 5-Jul Ref by Ref 1 X B 10-Jul Ref by Ref 1 X C 10-Jul Ref by Ref 0.5 X B 11-Jul Close 1 X C 11-Jul Close 0.5 VON Accept Ref by Ref Close 3-Jul 4-Jul 5-Jul 10-Jul 11-Jul thanks for any ideas you can share twith me -- bmac |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tracking the Trend of Occurrences
Sorry, I'm lost on this.
-- Biff Microsoft Excel MVP "bmac" wrote in message ... thank you Biff for your time... The July 10 Ref by Ref 1.5 timeline skews things because it's missing the other .5 day that area C is available. If July 10 for Area C had a half day THEN they would have had a July 10 half day for either Accepted or Closed. The overall point of this is to track the trends and frequency of Weekend service availability. The end result is to identify the % of service availability in a Quarter April-June The agency gives us a weekly service updates with AM/PM availability. VON Accept Ref by Ref Close 3-Jul Yes Results: Yes service was accepted 10-Jul Partial Yes Results: having a Partial 1/2 day as well as Closed 1/2 day -- bmac "T. Valko" wrote: Not sure what you're asking. For 3-Jul you have 2 full days. For 10-Jul you 1 full day and 1 half day. ??? -- Biff Microsoft Excel MVP "bmac" wrote in message ... Below is my spreadsheet. It tracks the Service Availability of an Agency. My question is this.. What function would I use to capture Service Agency Availability - if I wanted to identify Y=Yes, P=Partial. Yes for full days, Partial is for 1/2 days. Would it be Count? Match? Index? The Area is used in another report using the # of days. Agency Area Timeline type Days X B 3-Jul Accept 1 X C 3-Jul Accept 1 X C 4-Jul Close 1 X B 4-Jul Accept 1 X C 5-Jul Ref by Ref 1 X B 5-Jul Ref by Ref 1 X B 10-Jul Ref by Ref 1 X C 10-Jul Ref by Ref 0.5 X B 11-Jul Close 1 X C 11-Jul Close 0.5 VON Accept Ref by Ref Close 3-Jul 4-Jul 5-Jul 10-Jul 11-Jul thanks for any ideas you can share twith me -- bmac |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting occurrences on a particular date | Excel Worksheet Functions | |||
Unique occurrences of a value Q | Excel Worksheet Functions | |||
sort 2 or more occurrences | Excel Worksheet Functions | |||
How to insert tracking numbers into my webpage for RMA tracking | Excel Discussion (Misc queries) | |||
# of occurrences | Excel Worksheet Functions |