| From : | nfmtc <nfmtc@nilc.org.ge> |
| To : | Laura Inglin <laura.inglin@uef.fi>; TELLO, Juan <telloj@who.int> |
| Subject : | RE: [EXT] RE: Forms |
| Cc : | KLIMIASHVILI, Rusudan <klimiashvilir@who.int>; FARRINGTON, Jill Louise <farringtonj@who.int>; Dylan Collins <drjc.ubc@gmail.com>; Laatikainen Tiina <tiina.laatikainen@thl.fi>; Nato Shengelia <natoshengelia@gmail.com>; Marina Shikhashvili <m.shikhashvili@yahoo.com>; ანა ქარელი <kareliana2007@gmail.com>; Ketevan Goginashvili <kgoginashvili@moh.gov.ge> |
| Received On : | 02.07.2020 06:52 |
| Attachments : |
From: nfmtc [mailto:nfmtc@nilc.org.ge]
Sent: Thursday, July 2, 2020 10:16 AM
To: 'Laura Inglin'
Cc: 'KLIMIASHVILI, Rusudan'
Subject: RE: [EXT] RE: Forms
Dear Juan, Laura and colleagues,
I am sending you the final corrected versions of Excels. It was good to look again and correct if anything was missing.
I think that’s all.
If you have any questions, we are ready to answer them.
Thank you so much for your cooperation and support. It was another great experience for us.
With respect and best wishes,
Irina Karosanidze
From: Laura Inglin [mailto:laura.inglin@uef.fi]
Sent: Wednesday, July 1, 2020 9:52 AM
To: nfmtc <nfmtc@nilc.org.ge>; 'TELLO, Juan' <telloj@who.int>
Cc: 'KLIMIASHVILI, Rusudan' <klimiashvilir@who.int>; 'FARRINGTON, Jill Louise' <farringtonj@who.int>; 'Dylan Collins' <drjc.ubc@gmail.com>; Laatikainen Tiina <tiina.laatikainen@thl.fi>; 'Nato Shengelia' <natoshengelia@gmail.com>; 'Marina Shikhashvili' <m.shikhashvili@yahoo.com>; 'ანა ქარელი' <kareliana2007@gmail.com>; 'Ketevan Goginashvili' <kgoginashvili@moh.gov.ge>
Subject: Re: [EXT] RE: Forms
Dear Irina,
Excellent!
Have a nice day,
Laura
From: nfmtc <nfmtc@nilc.org.ge>
Sent: Wednesday, July 1, 2020 08:47
To: Laura Inglin <laura.inglin@uef.fi>; 'TELLO, Juan' <telloj@who.int>
Cc: 'KLIMIASHVILI, Rusudan' <klimiashvilir@who.int>; 'FARRINGTON, Jill Louise' <farringtonj@who.int>; 'Dylan Collins' <drjc.ubc@gmail.com>; Laatikainen Tiina <tiina.laatikainen@thl.fi>; 'Nato Shengelia' <natoshengelia@gmail.com>; 'Marina Shikhashvili' <m.shikhashvili@yahoo.com>; 'ანა ქარელი' <kareliana2007@gmail.com>; 'Ketevan Goginashvili' <kgoginashvili@moh.gov.ge>
Subject: RE: [EXT] RE: Forms
Dear Laura, Good Morning!
Yesterday we started to collect the missing information and will finish for tomorrow at the latest.
Thus, we will send you the completed files according to the request, no later then July 3rd (deadline for our task)
The Best,
Irina
From: Laura Inglin [mailto:laura.inglin@uef.fi]
Sent: Wednesday, July 1, 2020 9:32 AM
To: nfmtc <nfmtc@nilc.org.ge>; 'TELLO, Juan' <telloj@who.int>
Cc: 'KLIMIASHVILI, Rusudan' <klimiashvilir@who.int>; 'FARRINGTON, Jill Louise' <farringtonj@who.int>; 'Dylan Collins' <drjc.ubc@gmail.com>; Laatikainen Tiina <tiina.laatikainen@thl.fi>; Nato Shengelia <natoshengelia@gmail.com>; Marina Shikhashvili <m.shikhashvili@yahoo.com>; ანა ქარელი <kareliana2007@gmail.com>; Ketevan Goginashvili <kgoginashvili@moh.gov.ge>
Subject: Re: [EXT] RE: Forms
Dear Irina,
Yes, I think question 46 might be a copy-paste mistake (duplicate of the first LDL-related question).
Dylan and Juan, would you advise to collect the missing information?
Irina, would it be feasible to do this until the end of the week? We would need the data the latest by Sunday.
Kind regards,
Laura
From: nfmtc <nfmtc@nilc.org.ge>
Sent: Tuesday, June 30, 2020 18:54
To: 'TELLO, Juan' <telloj@who.int>; Laura Inglin <laura.inglin@uef.fi>
Cc: 'KLIMIASHVILI, Rusudan' <klimiashvilir@who.int>; 'FARRINGTON, Jill Louise' <farringtonj@who.int>; 'Dylan Collins' <drjc.ubc@gmail.com>; Laatikainen Tiina <tiina.laatikainen@thl.fi>; Nato Shengelia <natoshengelia@gmail.com>; Marina Shikhashvili <m.shikhashvili@yahoo.com>; ანა ქარელი <kareliana2007@gmail.com>; Ketevan Goginashvili <kgoginashvili@moh.gov.ge>
Subject: RE: [EXT] RE: Forms
Dear colleagues,
Are the questions 40 and 46 the same? or it is HDL?
Please, let me know.
The Best,
Irina
From: nfmtc [mailto:nfmtc@nilc.org.ge]
Sent: Tuesday, June 30, 2020 6:27 PM
To: 'TELLO, Juan' <telloj@who.int>; 'Laura Inglin' <laura.inglin@uef.fi>
Cc: 'KLIMIASHVILI, Rusudan' <klimiashvilir@who.int>; 'FARRINGTON, Jill Louise' <farringtonj@who.int>; 'Dylan Collins' <drjc.ubc@gmail.com>; 'Laatikainen Tiina (THL)' <tiina.laatikainen@thl.fi>; Nato Shengelia (natoshengelia@gmail.com) <natoshengelia@gmail.com>; Marina Shikhashvili <m.shikhashvili@yahoo.com>; ანა ქარელი <kareliana2007@gmail.com>; Ketevan Goginashvili <kgoginashvili@moh.gov.ge>
Subject: RE: [EXT] RE: Forms
Dear Juan, Dear Laura,
We’ve just received your mail.
I am sorry. When we started working (22th of June) the information manager had already loaded the old Excel files (sent from you in previous e-mails) into the computers and collectors were working on those files as well. There were 56 questions in those forms and missed DM medications and LDL values. As the forms were very similar we couldn’t notice the difference and continued to collect data based on the old one.
It does not matter if this is essential, we will check all our medical charts with the diagnosis of diabetes and cholesterol, as for the LDL values (it is too expensive) we used formula from lipid profile.
So, we can extract all those charts with the diagnosis of diabetes and total cholesterol is measured and collect data as requested. It is achievable in a short time because we have good trace ability of charts.
I think we might need more couple of days for finishing this task.
Thanks a lot for the cooperation.
Irina
From: TELLO, Juan [mailto:telloj@who.int]
Sent: Tuesday, June 30, 2020 5:10 PM
To: Karosanidze Irina <nfmtc@nilc.org.ge>; Laura Inglin <laura.inglin@uef.fi>
Cc: KLIMIASHVILI, Rusudan <klimiashvilir@who.int>; FARRINGTON, Jill Louise <farringtonj@who.int>; 'Dylan Collins' <drjc.ubc@gmail.com>; 'Laatikainen Tiina (THL)' <tiina.laatikainen@thl.fi>
Subject: RE: [EXT] RE: Forms
Dear Irina
Thanks once again for the data. I put you in contact with Laura Inglin who will be processing the data.
She already spotted that data sent do not include the additional items related to diabetes, e.g. DM medication (yes/no), what kind of DM medication (categories), LDL values.
Can you kindly clarify.
Best regards,
Juan
From: nfmtc <nfmtc@nilc.org.ge>
Sent: Tuesday, June 30, 2020 8:59 AM
To: TELLO, Juan <telloj@who.int>
Cc: KLIMIASHVILI, Rusudan <klimiashvilir@who.int>; FARRINGTON, Jill Louise <farringtonj@who.int>; 'Dylan Collins' <drjc.ubc@gmail.com>; 'Laatikainen Tiina (THL)' <tiina.laatikainen@thl.fi>
Subject: RE: [EXT] RE: Forms
Dear Juan,
I am sending the report, excel files and Photos.
I’ll send a letter later for permission from the ethics committee.
Please, Let me know if anything else.
Thanks a lot for your support.
Best Wishes,
Irina
From: TELLO, Juan [mailto:telloj@who.int]
Sent: Tuesday, June 23, 2020 6:25 AM
To: Karosanidze Irina <nfmtc@nilc.org.ge>
Subject: RE: [EXT] RE: Forms
Dear Irina
It is great to hear this.
Thank you and best regards,
Juan
From: nfmtc <nfmtc@nilc.org.ge>
Sent: Monday, June 22, 2020 12:26 PM
To: TELLO, Juan <telloj@who.int>
Cc: KLIMIASHVILI, Rusudan <klimiashvilir@who.int>; FARRINGTON, Jill Louise <farringtonj@who.int>; 'Laatikainen Tiina (THL)' <tiina.laatikainen@thl.fi>; 'Dylan Collins' <drjc.ubc@gmail.com>
Subject: [EXT] RE: Forms
Dear Juan,
We have started data collection on Saturday. I am sending today’s fotos. Please, see attached file.
Yes, we have managed to create random sampling in other clinics as well.
We’ll try to keep deadline.
I’ll be in touch with you in case we need support from your side or ask questions.
Best wishes,
Irina
From: TELLO, Juan [mailto:telloj@who.int]
Sent: Monday, June 22, 2020 12:52 PM
To: Karosanidze Irina <nfmtc@nilc.org.ge>
Cc: KLIMIASHVILI, Rusudan <klimiashvilir@who.int>; FARRINGTON, Jill Louise <farringtonj@who.int>; 'Laatikainen Tiina (THL)' <tiina.laatikainen@thl.fi>; 'Dylan Collins' <drjc.ubc@gmail.com>; TELLO, Juan <telloj@who.int>
Subject: Forms
Importance: High
Dear Irina
I hope this finds you well and the work is proceeding.
Did you manage to create random sampling for all the clinics?
In order to start the records review and data collection, I attach:
1. Frequently asked questions (FAQ) summarising the discussions and questions raised during the training.
2. The data collection form in Word format.
3. The data collection form in Excel format.
Kindly let me know if more is needed and when exactly your colleagues will start the review. We expect that on 3 July the 1000 records are finalized.
Best regards,
Juan
From: nfmtc <nfmtc@nilc.org.ge>
Sent: Thursday, June 18, 2020 12:01 PM
To: 'Dylan Collins' <drjc.ubc@gmail.com>
Cc: TELLO, Juan <telloj@who.int>; KLIMIASHVILI, Rusudan <klimiashvilir@who.int>; FARRINGTON, Jill Louise <farringtonj@who.int>; 'Laatikainen Tiina (THL)' <tiina.laatikainen@thl.fi>
Subject: RE: [EXT] logistics
Thank you, Dylan!
Yes, I ‘am informed that they have the same excel-based information, I ‘m waiting data from them and let you know as soon as I’ll have them.
Thanks again for your support. Irina
From: Dylan Collins [mailto:drjc.ubc@gmail.com]
Sent: Thursday, June 18, 2020 12:10 AM
To: nfmtc <nfmtc@nilc.org.ge>
Cc: TELLO, Juan <telloj@who.int>; KLIMIASHVILI, Rusudan <klimiashvilir@who.int>; FARRINGTON, Jill Louise <farringtonj@who.int>; Laatikainen Tiina (THL) <tiina.laatikainen@thl.fi>
Subject: Re: [EXT] logistics
Dear Irina,
The first step is to create your two list of patients: 1. Adults aged 40 or older who visited in the last year; 2. Adults aged 18 or older with diabetes who have visited in the last year. The second step is the random selection.
Here is one method that you can use to randomly select rows of data in Excel:
1. Create a new column
2. In the new column, for every row, use the formula “=RAND()”. This will give you a random number between 0 and 1.
3. Now every row of data will have a random number.
4. Sort the data by the random numbers you generated from smallest to largest.
5. Once sorted by random number, select the first 300 patient IDs (the sample size is only 250 but we need to provide the team with some extras incase they need them).
Do you know if the other two clinics also have excel-based visit registers to sample from?
Dylan
On Jun 17, 2020, at 4:38 AM, nfmtc <nfmtc@nilc.org.ge> wrote:
Dear Juan, Thank you.
Now we ‘ll wait for Dylan’s support and instructions.
Best Wishes,
Irina
From: TELLO, Juan [mailto:telloj@who.int]
Sent: Wednesday, June 17, 2020 2:47 PM
To: Karosanidze Irina <nfmtc@nilc.org.ge>
Cc: KLIMIASHVILI, Rusudan <klimiashvilir@who.int>; FARRINGTON, Jill Louise <farringtonj@who.int>
Subject: RE: [EXT] RE: logistics
Dear Irina
Many thanks for the clarifications.
We have estimated that 3 July (Friday) you should have been able to submit the Excel file/s with the 1000 records. That is about 100 records per day.
Best regards,
Juan
From: nfmtc <nfmtc@nilc.org.ge>
Sent: Wednesday, June 17, 2020 10:09 AM
To: TELLO, Juan <telloj@who.int>
Cc: KLIMIASHVILI, Rusudan <klimiashvilir@who.int>; FARRINGTON, Jill Louise <farringtonj@who.int>
Subject: [EXT] RE: logistics
Dear Juan,
Thanks so much for the explanation.
At 2 p.m. I‘ll have meeting with experts involved in the project to draw up an action plan and we will talk about which institution we’ll select from several options, most likely we will use the same system as ours and let you know.
Of course, we need Dylan’s help to clarify the features for the Excel files for the random sampling.
Data collectors/experts know the details of the contract, which is established with NFMTC, as well we ‘ll discuss with them the payment related issues.
It is important to know the time table of the project in order to plan how intensively we have to work, so we need a deadline.
Thank you very much for taking into account organizational/taxes/other costs in the budget.
I think everything is clear at the moment. The main thing is to comply with deadlines and perform quality work.
Thank you for your support.The Best,
Irina Karosanidze
From: TELLO, Juan [mailto:telloj@who.int]
Sent: Wednesday, June 17, 2020 11:19 AM
To: Karosanidze Irina <nfmtc@nilc.org.ge>
Cc: KLIMIASHVILI, Rusudan <klimiashvilir@who.int>; FARRINGTON, Jill Louise <farringtonj@who.int>
Subject: logistics
Dear Irina
Thank you for approving the TORs and budget. We will now proceed with the contract.
I have asked Dylan to clarify the features for the Excel files needed for the random sampling. As soon as Dylan sends, I will share.
May I kindly ask to find out with the other 2 health facilities their system. Do they have a daily journal, what level of detail they record, do they use excel o we just for random records in their archives.
Following the training this morning, it will be important to clarify with your team the payment related issues. For WHO is important they understand the agreement is with the Centre/you.
As background, we estimated 100 records per day x 10 days would be the 1000 records needed. We estimated USD7 dollars per record/15-20min but definitively this is our estimation and we leave in your hands the negotiations with the individuals of the Team.
We also acknowledged additional expenses for IT support for example, creating the needed Excel files or inserting data etc.
Finally, we also included extra hours to interpret the findings, for example, yesterday you provided us with important contextual information about BBP, etc. We can discuss more details when the data collection is finalised.
I hope this clarifies. Let me know if you prefer to discuss over Whatsapp or similar today or tomorrow.
Thank you for your partnership.
Best regards,
Juan
From: nfmtc <nfmtc@nilc.org.ge>
Sent: Wednesday, June 17, 2020 6:54 AM
To: TELLO, Juan <telloj@who.int>
Cc: KLIMIASHVILI, Rusudan <klimiashvilir@who.int>; MILLER, Sharon <millers@who.int>; STRANDSBJERG, Anita <strandsbjerga@who.int>; FARRINGTON, Jill Louise <farringtonj@who.int>
Subject: [EXT] RE: your approval
Dear Juan,
I am sending signed document.
The best
Irina
From: TELLO, Juan [mailto:telloj@who.int]
Sent: Wednesday, June 17, 2020 8:19 AM
To: Karosanidze Irina <nfmtc@nilc.org.ge>
Cc: KLIMIASHVILI, Rusudan <klimiashvilir@who.int>; MILLER, Sharon <millers@who.int>; STRANDSBJERG, Anita <strandsbjerga@who.int>; FARRINGTON, Jill Louise <farringtonj@who.int>
Subject: your approval
Dear Irina
In order to proceed with the contract, we will appreciate your prompt approval of the terms of reference and budget attached to this email.
Thank you and best regards,
Juan
…………………………………………………………………………………………..
Juan Tello | NCD Integrated Prevention and Control Programme
Mobile: +45 5168 5105
Office: +45 4533 6868
GPN: 76868
Twitter: @Juan_E_Tello
Linkedin: https://www.linkedin.com/in/juan-tello/
Division of Country Health Programmes
World Health Organization Regional Office for Europe