Hi Paul,
Added Column "D" as unique id & what needed as result is in "Result" sheet.
It would require per month-per slot-per name >> 3 samples.
VBA Macro looks a great idea to work with this. PFA for your reference. My
apologies & promise no other modification would be required after this.
O
I think I better understand what your data means.You're wanting a random sample
of (4) records for each of the names in the "Name" column.and you're wanting
the (4) samples to be in each if (4) time ranges.
The attached file takes care of THAT,
but your additional requirement, that of what to do
Paul, apologies for bothering you so much & unable to interpret the
expectation. Please refer sheet 2 in attached file for results per agent.
Also, I have taken duration as example of selecting sample.
On Monday, February 1, 2016 at 6:37:46 PM UTC+5:30, Paul Schreiner wrote:
>
> I'm not sure what
I'm not sure what you are expecting, or how this does not meet your
expectations.
For January, you have (9) entries in the 0-10 minute range.So each of your (4)
agents will get one of the samples.
But you only have (3) entries in the 10-20 minute range.So, the 4th agent does
not receive an entry
Hi Paul,
I really appreciate your help. Apologies for all the confusion.
I have added some more data in this file. I just need if i select Jan
Month, so who ever agents has 4 calls with duration as per the slab must
come in sample & if less than 4, still it would come with number of calls
it
See below:Paul-
On Friday, January 29, 2016 3:19 AM, SG wrote:
Hi Paul, I got the sheet. Thankyou so much for all your effort in this
sampling. I'm really thankful.
Only one thing i observed is that, in raw data , there are 4 entries of Rohit
i
Hi Paul, I got the sheet. Thankyou so much for all your effort in this
sampling. I'm really thankful.
Only one thing i observed is that, in raw data , there are 4 entries of
Rohit in Jan but in Random Sampling section, only two are coming as sample
for Rohit whereas it should be 4calls,per pers
No Paul, I didn't get it. Can you please share it again.
On Thursday, January 28, 2016 at 6:36:10 PM UTC+5:30, Paul Schreiner wrote:
>
> Yeesss.. and responded with an update.
> Did you not receive it?
>
> *Paul*
> -
>
>
>
>
>
>
>
> *“Do all the good you c
Yeesss.. and responded with an update.Did you not receive it?
Paul-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John
Paul, have you checked it?
On Wednesday, January 27, 2016 at 6:45:26 PM UTC+5:30, SG wrote:
>
> Thanks for your quick response Paul. The line ""In case, any slot not
> available, it should pick so on" means that in case any slot is not
> available, it should skip it & choose the call from next s
Thanks for your quick response Paul. The line ""In case, any slot not
available, it should pick so on" means that in case any slot is not
available, it should skip it & choose the call from next slab. Your trick
is helping me very much. One more modification i need is per person
sampling. That
Here's a possible solution.Basically, you need to determine which "set" the
record falls into.I used:
IF(AND(G2>0,G2<=TIME(0,10,0)),1,
IF(AND(G2>TIME(0,10,0),G2<=TIME(0,20,0)),2,
IF(AND(G2>TIME(0,20,0),G2<=TIME(0,30,0)),3,
IF(AND(G2>TIME(0,30,0),G2<=TIME(0,60,0)),4,0this says that if t
Hi Experts
I need your help in choosing the samples for quality check. The only idea
in my mind is the Random function but this wouldn’t suffice as there are
2-3 conditions on basis of which sampling should be done.
It should be done for 4 calls per month per type (column A for type).
Diffe
Please attach sample file explaining your requirement in brief.
Regards,
C.G.Kumar
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of summu
Sent: 24/February/2010 6:47 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros
I have 500 coloumns in that I want to take every 5th coloumn .Can
anybody help me to take sample (every 5th coloumn)
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
htt
15 matches
Mail list logo
