Revised
eLearning

The following modules have been reviewed and revised by subject matter experts and are reloaded to their location on our CIBMTR website Online Training page:


eDBtC TIPS and Tricks
Split Excel Code/Value Columns from decoded data download spreadsheets 
 
The new Data Download (decoded) tab of enhanced Data back to Center (eDBtC) now gives you columns that contain both the encoded data and the value string of the same data. Here are some examples of code/value columns:


You can use the Data feature in Excel to parse these data types into separate columns. Once you have downloaded the data into an Excel spreadsheet, follow the steps below using Transplant Type as an example to separate its code value (1) from its string description value ("ALLO - Allogeneic"):
  1. Select the column that contains the text you want to split.
  2. Insert an empty column to the right of the column that contains the values you want to split or identify two empty columns where you'd like the split values to go.
  3. Click the Data menu item followed by Text to Columns.

  1. The 'Convert Text to Columns Wizard' will appear. Select the Delimited radio button and click the Next button.
  2. Click the Semicolon option under the Delimiters checkbox selection area. Click the Next button.
  3. In the following step, select either General or Text in the Column data format selection area. If you leave the default value in the Destination: text box the code value will remain in the current column and the Description or Value will be copied into the adjacent empty column to the right. Otherwise, modify the cell reference to suit your preference for placement of the Value column contents. If you have two empty columns where you'd like the split columns to be placed for example at the end of the spreadsheet, type that reference into the Destination: text box. If your spreadsheet goes from column "A" through column "F" and you want the split values to go into columns "G" and "H", type $G$1 into the Destination: text box. 
  4. Click the Finish button to complete the split.
  5. The results should look like the following: 

You can modify the column headings to suit requirements for definition of the column values: 


CIBMTR Data Management Guide

Last June we introduced the Data Management GuideWe created this searchable resource for data managers from content that was on our website and further enhanced it with detailed information.

Examples of what you will find:
Our next step
Having had time to familiarize everyone to the new location of these instructional materials within the Data Management Guide, they will soon be removed from the website.

Feedback
We would appreciate your feedback and ideas. Tell us what else you would like to see included in the Data Management Guide. Email:  CIBMTRtraining@nmdp.org

The following forms are being revised / developed for the next release:
Forms
Anticipated Release Date
2018 / 2118 - Lymphoma Forms
January 2018
2402 - Disease Classification
January 2018
2150/4150  - Viral Infection Form*
January 2018
Recipient Eligibility Form 2500*
January 2018
Sickle Cell 2030/2130  TBD (not started yet)
Thalassemia* (20XX/21XX) TBD (not started yet)
* New Form
For more information about the upcoming release, or current form revisions, please contact: Tiffany Hunt ( thunt@mcw.edu).

CIBMTR on Facebook and Twitter 
Like us on Facebook and follow us on Twitter to stay up-to-date with important news and events. We promote our publications, share important content from other organizations, and advertise our key meetings and events. Join us today! 
CIBMTR® (Center for International Blood and Marrow Transplant  Research®) is a research collaboration between the National  Marrow Donor Program®/Be The Match® and Medical College of  Wisconsin.