zlacker

[parent] [thread] 7 comments
1. andi99+(OP)[view] [source] 2021-06-04 10:31:31
Just take your excel sheet of funded project, filter by country then filter by city....
replies(1): >>cptski+yk
2. cptski+yk[view] [source] 2021-06-04 13:46:59
>>andi99+(OP)
This amuses me because some people are going to incredulously think "you would never keep such important information in excel" and others are going to skeptically say "there's no way they've managed to consolidate that down to just one excel file".
replies(2): >>marcos+zo >>andi99+qG
◧◩
3. marcos+zo[view] [source] [discussion] 2021-06-04 14:12:49
>>cptski+yk
I'm on the team thinking that there is no chance they got the city name correct and searchable on those Excel files.
replies(3): >>splith+jA >>cptski+QP >>cecilp+nR
◧◩◪
4. splith+jA[view] [source] [discussion] 2021-06-04 15:24:32
>>marcos+zo
Or the person searching it ctrl+f’d a typo. Or a Chinese intern who helped compile the spreadsheet deleted that row on “accident”.

People are too quick to notice conflicts of interest. Everyone of us lives a life filled with such conflicts, yet we manage somehow to rise above, for the most part. Fauci seems like a nice guy to me.

◧◩
5. andi99+qG[view] [source] [discussion] 2021-06-04 15:55:41
>>cptski+yk
I am in the camp believing that there are actually at least 2 full time positions just for compiling/maintaining these excel files.
replies(1): >>cptski+sQ
◧◩◪
6. cptski+QP[view] [source] [discussion] 2021-06-04 16:41:10
>>marcos+zo
I inherited a application for grants tracking database last year and the grants themselves do not have a location. There are persons and institutions associated with each Application/Grant, and each of those has a location.

Interestingly, the application is designed for a very specific workflow, audit and review as part of the intake, but has no facilities for auditing after the fact. The data and relationships exist and there is a wealth of information in the database including known conflicts of interest but there's no easy way to query or browse this data from the application unless you're reviewing a specific grant or application.

For example:

The application doesn't allow you to search for persons by location and doesn't show you grants associated with persons. Rather you can only see persons associated with grants.

You can search for institution by address but again, it doesn't show you grants associated with an institution.

These interfaces were designed to just update Persons or Institutions when changes occur. They weren't intended as a way to back into a Grant or Application.

◧◩◪
7. cptski+sQ[view] [source] [discussion] 2021-06-04 16:44:28
>>andi99+qG
In our org there's an entire team in the Research department dedicated to maintaining grants/applications and they rely on staff in IT and Finance for continuous support. If I had to hazard a guess, I would say it's at least 15 people.
◧◩◪
8. cecilp+nR[view] [source] [discussion] 2021-06-04 16:47:42
>>marcos+zo
They did filter, but the details for that lab showed the country as "Wuhan" and the city as "Chona".
[go to top]