Late coming identify
- Thread starter sms2luv
- Start date
- Status
Have You (=sms2luv) ever seen views like below?
Have You (=sms2luv) wanted to get times for those 'Reason Code Names'?
Can You see (=sms2luv) that there have used 12 (twelve) of those Codes?
Have You noticed that number six is 'missing' or not named?
Do You (=sms2luv) know, is there more of those codes?
Do we use same file?
If any answer (which seems to challenge to get form You (=sms2luv))
will be 'NO' of those questions ...
then 'Take Care and Have a nice day!'
Have You (=sms2luv) wanted to get times for those 'Reason Code Names'?
Can You see (=sms2luv) that there have used 12 (twelve) of those Codes?
Have You noticed that number six is 'missing' or not named?
Do You (=sms2luv) know, is there more of those codes?
Do we use same file?
If any answer (which seems to challenge to get form You (=sms2luv))
will be 'NO' of those questions ...
then 'Take Care and Have a nice day!'
Q) Have You (=sms2luv) wanted to get times for those 'Reason Code Names?
A) Need to know Duration of Reason Code Name in Minutes (Day Wise).
Q) Can You see (=sms2luv) that there have used 12 (twelve) of those Codes?
A) There are only 12 reasons code.
Q) Have You noticed that number six is 'missing' or not named?
A) Number 6 is deliberately removed as company does like number for codes.
Q) Do You (=sms2luv) know, is there more of those codes?
A) These are the only codes we have.
Q) Do we use same file?
A) we use the same file everyday.
You asked several question related to the file, whenever I missed out giving information, you sometimes replied in a Harsh way. I still felt and said good about you.
You can point out my mistakes easily, but if I am not wrong, we do have a word "Thanks" or "Welcome" as an acknowledgement.
Any way its fine, neither I am expecting anything that you will say something.
I am just writing to say that the file is not working at all.
All fields are completely improper, Only the roster is getting correctly.
First login time and other things values are incorrect.
Check attachment, there are no such terms which you are unaware of.
Mods, requesting you if you can check the entire history of the conversation.
A) Need to know Duration of Reason Code Name in Minutes (Day Wise).
Q) Can You see (=sms2luv) that there have used 12 (twelve) of those Codes?
A) There are only 12 reasons code.
Q) Have You noticed that number six is 'missing' or not named?
A) Number 6 is deliberately removed as company does like number for codes.
Q) Do You (=sms2luv) know, is there more of those codes?
A) These are the only codes we have.
Q) Do we use same file?
A) we use the same file everyday.
You asked several question related to the file, whenever I missed out giving information, you sometimes replied in a Harsh way. I still felt and said good about you.
You can point out my mistakes easily, but if I am not wrong, we do have a word "Thanks" or "Welcome" as an acknowledgement.
Any way its fine, neither I am expecting anything that you will say something.
I am just writing to say that the file is not working at all.
All fields are completely improper, Only the roster is getting correctly.
First login time and other things values are incorrect.
Check attachment, there are no such terms which you are unaware of.
Mods, requesting you if you can check the entire history of the conversation.
Attachments
QA1) As I have written SO FAR NOT MINUTES!
QA2) How many days took to get answer? ... okay 12
QA3) as QA2
QA4) as QA2
Q5) Do we use same file?
A5) we use the same file everyday. But now different!
I need answers, I have to ask same question many times because NO answers!
If no answer then nothing change!
I would say 'Thanks' if there could come reason to that.
File no work:
1) Different file!
2) 'Roster'-sheet;
2a) [ code ] was 4-characters - now not fixed width
>> not work >> if this information is unknown then Output will be mess!
2b) 'Login'-sheet;
'my file' [Agent] is like C243_Kumar (ID and _ and Name)
new file [Agent] is like FUT_284_Sunil_Gupta
>> where comes FUT? 284 is CTI Login (=ID) and Name
There are rules what have to find and where!
If those informations structure has changed
then Output will be mess! >> not work >>
>>> File works fine! <<<
If same file then same kind of information.
I cannot ask/guess all details ...
and normally, I didn't get none answers!
If You need help then
You should be active to get help!
as Mods, requesting you if you can check the entire history of the conversation.
If You could even try give needed information about
Login-sheet's [Agent] and Roster-sheet's [ID]?
Rules: how to know which part is which part?
Rules: 'my file' has two parts, Your file has three parts!
Rules: which part is CODE and which part is NAME?
I could try to figure, what those would need to do?
> Filter option with file - check 'Roster's top row <
QA2) How many days took to get answer? ... okay 12
QA3) as QA2
QA4) as QA2
Q5) Do we use same file?
A5) we use the same file everyday. But now different!
I need answers, I have to ask same question many times because NO answers!
If no answer then nothing change!
I would say 'Thanks' if there could come reason to that.
File no work:
1) Different file!
2) 'Roster'-sheet;
2a) [ code ] was 4-characters - now not fixed width
>> not work >> if this information is unknown then Output will be mess!
2b) 'Login'-sheet;
'my file' [Agent] is like C243_Kumar (ID and _ and Name)
new file [Agent] is like FUT_284_Sunil_Gupta
>> where comes FUT? 284 is CTI Login (=ID) and Name
There are rules what have to find and where!
If those informations structure has changed
then Output will be mess! >> not work >>
>>> File works fine! <<<
If same file then same kind of information.
I cannot ask/guess all details ...
and normally, I didn't get none answers!
If You need help then
You should be active to get help!
as Mods, requesting you if you can check the entire history of the conversation.
If You could even try give needed information about
Login-sheet's [Agent] and Roster-sheet's [ID]?
Rules: how to know which part is which part?
Rules: 'my file' has two parts, Your file has three parts!
Rules: which part is CODE and which part is NAME?
I could try to figure, what those would need to do?
> Filter option with file - check 'Roster's top row <
Last edited:
Yes, You have written about updates -
that's good,
but many times it makes challenges too!
My Q1: Do we use same file?
>Two different files ... 'Your' new-1.xlsb and 'Mine' raw.xlsb - okay?
'Roster'-sheet:
'raw's ID has four character ID-code! I use code!
'new's ID has three-four character code
It do not work - so far my code needs four characters! - okay?
'Login'-sheet:
Now You have told that, 'IT-team' has add 'FUT_' in front of Agent-name.
More challenge to find 'Code' from Agent-column - Okay?
If cannot find correct code from 'Agent'-column then
that rows data cannot add anywhere or it would go to 'wrong' place.
And that 'FUT_' ...
if that would be in front of ID-code and
if I would know that ID-code is not always 4-characters long,
it would work!
You now mobile phone ... yes!
If You try to phone to that IT-team, You would press correct numbers and after that they would be online ...
if You select 'different' or wrong number - who knows who would answer?
that's good,
but many times it makes challenges too!
My Q1: Do we use same file?
>Two different files ... 'Your' new-1.xlsb and 'Mine' raw.xlsb - okay?
'Roster'-sheet:
'raw's ID has four character ID-code! I use code!
'new's ID has three-four character code
It do not work - so far my code needs four characters! - okay?
'Login'-sheet:
Now You have told that, 'IT-team' has add 'FUT_' in front of Agent-name.
More challenge to find 'Code' from Agent-column - Okay?
If cannot find correct code from 'Agent'-column then
that rows data cannot add anywhere or it would go to 'wrong' place.
And that 'FUT_' ...
if that would be in front of ID-code and
if I would know that ID-code is not always 4-characters long,
it would work!
You now mobile phone ... yes!
If You try to phone to that IT-team, You would press correct numbers and after that they would be online ...
if You select 'different' or wrong number - who knows who would answer?
hmm ... You could ask from that IT-team ...
You need to find how to create
(as I tried to explain with snapshot and text too in #56)
with 'Roster'-sheet's [ID] and [Name]
unique 'Login'-sheet [Agent]
ex 'old' | C245 | Bhim | >> | C245_Bhim |
ex 'new' | 165 | Shayan Shaikh | >> | FUT_489_Shayan_Shaihk |
with all data!
ALL CHARACTERS MATTERS!
and
if ex IT-team or anyone takes/modifies that 'FUT_' ... no work any more!
There have to be clear rule how to create it!
That is the key to connect 'Login' - 'Roster' to create 'Output'!
btw ... how do you count Post # in this forum (#57). ... what would that mean?
You need to find how to create
(as I tried to explain with snapshot and text too in #56)
with 'Roster'-sheet's [ID] and [Name]
unique 'Login'-sheet [Agent]
ex 'old' | C245 | Bhim | >> | C245_Bhim |
ex 'new' | 165 | Shayan Shaikh | >> | FUT_489_Shayan_Shaihk |
with all data!
ALL CHARACTERS MATTERS!
and
if ex IT-team or anyone takes/modifies that 'FUT_' ... no work any more!
There have to be clear rule how to create it!
That is the key to connect 'Login' - 'Roster' to create 'Output'!
btw ... how do you count Post # in this forum (#57). ... what would that mean?
Maybe You're trying to get information from IT-team.
I checked this again
'Login' - 'Roster'
a) There isn't any connection with after FUT number with CTI Login!
b) some Emp Names missed from 'Login'
( Left, list from 'Login' and right, list from 'Roster')
>> challenges >> it take more time! >> gotta be rule!
Anyway, I tried to continue ...
As I have written ...
'Roster' should be okay before run 'Login' with code.
a) previous days 'Roster' is missing; unknown night shift!
b) 'roster' should last one day longer than 'Login'; night shift's 00-08.
c) Someway, it would be okay
if employees do work also then 'Roster' has 'OFF', Leave or '-'.
You have also wrote about 60min breaks per shift ... yes!
>> I add some colors there, looks better that just black and white.
This time just 'PDF'-output, because no new information
about those code/names which (rules) has changed.
I checked this again
'Login' - 'Roster'
a) There isn't any connection with after FUT number with CTI Login!
b) some Emp Names missed from 'Login'
( Left, list from 'Login' and right, list from 'Roster')
>> challenges >> it take more time! >> gotta be rule!
Anyway, I tried to continue ...
As I have written ...
'Roster' should be okay before run 'Login' with code.
a) previous days 'Roster' is missing; unknown night shift!
b) 'roster' should last one day longer than 'Login'; night shift's 00-08.
c) Someway, it would be okay
if employees do work also then 'Roster' has 'OFF', Leave or '-'.
You have also wrote about 60min breaks per shift ... yes!
>> I add some colors there, looks better that just black and white.
This time just 'PDF'-output, because no new information
about those code/names which (rules) has changed.
I work for company and company doesn't work for.
I cannot tell the company that they should not change the format or cannot tell them that no.6 is missing.
I had provided feedback to IT team, that the current version is stable and no more changes are required.
As far as I'd goes, I had changed it for security reasons, but made mistakes in changing them properly.
Rather then pointing out mistakes and error, can we work on the file to get it fixed.
I guess this forum has gone very long.
I cannot tell the company that they should not change the format or cannot tell them that no.6 is missing.
I had provided feedback to IT team, that the current version is stable and no more changes are required.
As far as I'd goes, I had changed it for security reasons, but made mistakes in changing them properly.
Rather then pointing out mistakes and error, can we work on the file to get it fixed.
I guess this forum has gone very long.
Few questions here.
Is there any color coding, I mean some cells are colour.
What's the meaning of comments (some numbers as comments)
Shift time is coming in a different row(check screen shot).
I checked the roster, when you made a note that filter can be done normally.
However I was earlier talking about drop down list on Output sheet.
Can we add a new button to display horizontally or vertically.
Is there any color coding, I mean some cells are colour.
What's the meaning of comments (some numbers as comments)
Shift time is coming in a different row(check screen shot).
I checked the roster, when you made a note that filter can be done normally.
However I was earlier talking about drop down list on Output sheet.
Can we add a new button to display horizontally or vertically.
Attachments
Colors:
as I wrote in #61 and You could notice same coding
if You just check connection of those colors and data.
Comments: Number of rows from 'Login'
Filtering: Use that 'Roster's filtering then You can control 'Output'.
Dropdown: Yes, I remember. With above filter-option, You can do more!
... and after press OutPut's-button - everything old will clear away from 'Output'.
H/V-button: I have answered this too.
From You writings that would mean
5000-columns and at least two times wider columns than now >> W - I - D - E!
It is possible but not .... idea to do!
I can do it, but so far I won't do it!
You can do it and then You would see it.
as I wrote in #61 and You could notice same coding
if You just check connection of those colors and data.
Comments: Number of rows from 'Login'
Filtering: Use that 'Roster's filtering then You can control 'Output'.
Dropdown: Yes, I remember. With above filter-option, You can do more!
... and after press OutPut's-button - everything old will clear away from 'Output'.
H/V-button: I have answered this too.
From You writings that would mean
5000-columns and at least two times wider columns than now >> W - I - D - E!
It is possible but not .... idea to do!
I can do it, but so far I won't do it!
You can do it and then You would see it.
Y: How can I check post# 61.
Your previous Reply was #68 - okay.
Then You have to scroll up -up until You'll see #61.
It's same, where You can find that PDF-file.
Y: I mean there is no such indication, should we count it manually?
Which indication is missing?
What should someone count?
Your previous Reply was #68 - okay.
Then You have to scroll up -up until You'll see #61.
It's same, where You can find that PDF-file.
Y: I mean there is no such indication, should we count it manually?
Which indication is missing?
What should someone count?
- Status