Resources:
Instructions
The "Initial Mapping Spreadsheet" has just one tab/sheet,
...
If you have a 1–* map (as in the exemplar Nasal spray, solution) please add an extra row to the spreadsheet
Rows 2-13 give a set of example maps that I have done; they may not be correct, so as you look at them, please feel free to add comments in Column I, with your initials if possible.
Please would all mappers have a go at "the first five rows 15-19" - which I have put in with space for each of you
Then
- Tara - rows 15-19 and 39-43
- Olivier - rows 21-25 and 45-49
- Olivier Martha - rows 27-31 and 51-55
- Martha Catherine - rows 33-37 Catherine - rows 39-43and 57-61
Anyone else wanting to "have a go" - please do so; please copy some rows onto a second sheet further tab/worksheet and do your mapping there 
If at all possible, please could everyone have completed this initial assignment by our meeting on 23rd September - thank you!
Tips and Tricks 
You can either use the EDQM Browser https://standardterms.edqm.eu/ (remember you need a log-in) and/or the EDQM PDF spreadsheet attached above to look at the PDFs that you are mapping FROM
Similarly, you can use the SNOMED CT Browser https://browser.ihtsdotools.org/ and/or the SNOMED CT PDF spreadsheet attached above to look at the PDFs that you are mapping TO
The spreadsheets should be formatted such that all the IDs save as text and we don't "lose" any to exponential numbers - let me know if it looks as if something is saving incorrectly
As well as text searching, it can be helpful to use filters on the spreadsheet to see if there are some similar concepts to suggest a map - or to be as sure as you can that there is nothing suitable to map to
I suggest that you download the spreadsheet - I haven't managed to find a way to work with it directly in Confluence - but I think that's me! Then, please email your version to Julie and Linda, and we will upload to this list at the bottom of this page.
| Attachments |
|---|