search

Epsidon / Observatoire

Observatoire de la santé des francophones
2 stars 0 forks source link

Health Profiles - Data is wrong #48

Closed ebourdon closed 10 years ago

ebourdon commented 10 years ago

Some data in the popups are wrong.

Here is an example:

image

ghost commented 10 years ago

Hi Erik,

I think the data is correct:

In the Excel file "Health Profiles for Ava.xlsx" ,

for column "DifficulteAct_A" for region "3504" we have the value "29.3" for column "DifficulteAct_F" for region "3504" we have the value "28.01 E"

for column "AccessibiliteSante_F" for region "3504" we have the value"52.28"

for column "AccessibiliteComm_F" for region "3504" we have the value"53.88 E"

ebourdon commented 10 years ago

Hello,

I'm at work so I cannot look at the numbers but please double check. When I compared the numbers from the site with the numbers in the Excel documents there were differences.

Erik

On Tuesday, March 11, 2014, Ava Ahadipour notifications@github.com wrote:

Hi Erik,

I think the data is correct:

In the Excel file "Health Profiles for Ava.xlsx" ,

for column "DifficulteAct_A" for region "3504" we have the value "29.3" for column "DifficulteAct_F" for region "3504" we have the value "28.01 E"

for column "AccessibiliteSante_F" for region "3504" we have the value"52.28"

for column "AccessibiliteComm_F" for region "3504" we have the value"53.88 E"

Reply to this email directly or view it on GitHubhttps://github.com/Epsidon/Observatoire/issues/48#issuecomment-37324485 .

ebourdon commented 10 years ago

Hi Ava,

I just checked and no, the data on the website does not match the data in the Excel sheet. It actually does not match what you wrote above.

I think I understand the confusion. The picture I included in the Issue is a picture of the data in Excel but if you look at the data in the popup you get different results.

You wrote:

In the Excel file "Health Profiles for Ava.xlsx" , for column "DifficulteAct_A" for region "3504" we have the value "29.3" for column "DifficulteAct_F" for region "3504" we have the value "28.01 E"

Which is correct but in the popups for health region 3504 you get:

Participation and activity limitation, sometimes or often (%) French = 29.3 English = 86.26

ghost commented 10 years ago

This issue is fixed.

ebourdon commented 10 years ago

Data looks right except one cell is always empty, namely:

Regular medical doctor (%) - French

ghost commented 10 years ago

This issue is fixed.

On Thu, Mar 13, 2014 at 5:14 PM, ebourdon notifications@github.com wrote:

Data looks right except one cell is always empty, namely:

Regular medical doctor (%) - French

Reply to this email directly or view it on GitHubhttps://github.com/Epsidon/Observatoire/issues/48#issuecomment-37587684 .

ebourdon commented 10 years ago

Thank you.