Method list correction

[hrlee1202]

1.2 Main Method
— Separator has been updated.
Still it is difficult to machine-process the column as there are many malformed answers

Examples (and desired correction):
"Integrated Model including InVEST model" -> "56; 57"
"InVEST Recreation Model (Sharp et al. 2016, linked to 57)" -> "57"
"Questionnaire" -> "91"
".... linked to 22" -> "22"
..

Ultimately, only numbers with semicolon should exist. No malformed values are allowed. When a method does not fit at all the list of methods (SOD Appendix 2), that can be present and list up in the end.

[hrlee1202]

1.4. Additional Method

It is same as above..

I wonder if it is necessary to make a 'Needchecking' list, It looks to me that Good doc seems fine to work directly?

[hrlee1202]

https://docs.google.com/spreadsheets/d/1JwuWl4ZbsqyYOdJvpGGwQWhrXxcuKHvzxWHyNhVEVpY/edit?ts=5f8d41dc#gid=730503165

[hrlee1202]

• Heera provides an updated NeedChecking table

[hrlee1202]

@Sander-Jacobs
Please find the attached excel files. I rechecked the table and you're right! it would be easier for her to have this list. It was more complicated that it looks. I realised that Luiza's table is not a full list of the step3_single. So I matched paperID and applicationID to correct the answer.

Anyway, these are the list:

Using Luiza's table - All
Step3_1.2_all_2020-10-20.xlsx

NeedChekcing= Yes
Step3_1.2_needchecking_only_ 2020-10-20.xlsx

If you have further question or find errors or etc, please let me know!

Thanks,

[Sander-Jacobs]

Hi, this is cool!! I will send it to her. She also did the additional methods question. Does this table have additional ones too? if yes, it would be better to add a column with additional/main if not, let's ake a separate one for additional so she can start on these I'll await your answer before sending it!

…

On Tue, Oct 20, 2020 at 11:04 AM Heera Lee ***@***.***> wrote: @Sander-Jacobs <https://github.com/Sander-Jacobs> Please find the attached excel files. I rechecked the table and you're right! it would be easier for her to have this list. It was more complicated that it looks. I realised that Luiza's table is not a full list of the step3_single. So I matched paperID and applicationID to correct the answer. Anyway, these are the list: Using Luiza's table - All Step3_1.2_all_2020-10-20.xlsx <https://github.com/RCinbo/IPBESValueAssessment/files/5407577/Step3_1.2_all_2020-10-20.xlsx> NeedChekcing= Yes Step3_1.2_needchecking_only_ 2020-10-20.xlsx <https://github.com/RCinbo/IPBESValueAssessment/files/5407576/Step3_1.2_needchecking_only_.2020-10-20.xlsx> If you have further question or find errors or etc, please let me know! Thanks, — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#21 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AREM7L5MHDZLIZXBTORC4NDSLVHATANCNFSM4SWWZZ6Q> .

[hrlee1202]

Hello @Sander-Jacobs,

I think it's better to start with the main methods first. It would be easier to create a separate list for the additional methods. I can do it at the second nap time for Ewon or in the evening ;-) But the problem I saw in her table is that she put '/' or '0' for the empty cells, which she actually did not need to.. I would rather delete them before I proceed. I guess she intended to put '/' but accidentally I saw '0' as well, which is confusing. And it is not always the case that a study is listed as 'needchecking' for the main method and for the additional method at the same time. One could be needed to check for the main methods, but not for the additional ones, vice versa. I will have a look. but please go ahead with the main one first if you don't mind.

Thanks,

[hrlee1202]

• Heera needs to provide a list for the NeedChecking Additional list

[Sander-Jacobs]

Ok heera! i wil send her the main one now, so take your time on the additionals - about the / or 0=> you are probably right - about the completeness: YES this is complete, because i gave her the whole column from the step 3 table, not the 'needchecking' first table. Is this clear? thanks!! (and also thank you boy for sleeping so well, and you husband for being so flexible ;-))

…

On Tue, Oct 20, 2020 at 2:38 PM Heera Lee ***@***.***> wrote: Hello @Sander-Jacobs <https://github.com/Sander-Jacobs>, I think it's better to start with the main methods first. It would be easier to create a separate list for the additional methods. I can do it at the second nap time for Ewon or in the evening ;-) But the problem I saw in her table is that she put '/' or '0' for the empty cells, which she actually did not need to.. I would rather delete them before I proceed. I guess she intended to put '/' but accidentally I saw '0' as well, which is confusing. And it is not always the case that a study is listed as 'needchecking' for the main method and for the additional method at the same time. One could be needed to check for the main methods, but not for the additional ones, vice versa. I will have a look. but please go ahead with the main one first if you don't mind. Thanks, — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#21 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AREM7L33UBD5SSSACNNA4TDSLWAFJANCNFSM4SWWZZ6Q> .

[hrlee1202]

Hello @Sander-Jacobs

Please find the attached files for the additional methods:

All for the question 1.4
Step3_1.4_all_2020-10-21.xlsx

Need checking = Y
Step3_1.4_needchecking_only_ 2020-10-21.xlsx

Unlike the main methods, there are many '0' (no data is entered), which is assigned as 'Needchecking = N'.
If you have any further question or find an error, please let me know.

Thanks,

[Sander-Jacobs]

great! I sent it to Luiza! thx a lot!! Sander

[hrlee1202]

Main Method list (corrected) : work in progress..

Main_Method_list_correxted24Nov.pdf