Website Search
In a previous post we noted the increasing importance of biologics as therapeutic agents, with 37% of the drugs approved by the FDA in 2017 being biologic entities. A recent article in Chemical & ...
When updating an existing chemical catalog which is stored in ChemBioFinder, users usually have some data in chemical format (SDFile) and some data in Excel spreadsheets. This video demonstrates how to merge in chemical structure changes and price changes, using Alfa Aesar’s chemical catalog. Our steps include: Price list updates are listed in an Excel spreadsheet (exported as TXT). Merge into ChemBioFinder to implement all price changes specified in Excel. Observing any errors (unmatched prices or structures). Structure updates are listed in an Excel spreadsheet (exported as SDF). Merge into ChemBioFinder to implement all structure changes specified in Excel. Observing “tabs” in ChemBioFinder for each new data source.
When updating an existing chemical catalog which is stored in ChemBioFinder, users usually have some data in chemical format (SDFile) and some data in Excel spreadsheets. This video demonstrates how to merge in chemical structure changes and price changes, using Alfa Aesar’s chemical catalog. Our steps include:
This catalog keeps pricing information in an Excel spreadsheet, but the same method would apply for any data in an Excel spreadsheet. In other settings, the Excel data might be empirical data about each substance; or assay data in multiple dimensions.
This Feature Clip is part 4 of a series. Please see the other features of the series:
Part 1: Merging Excel spreadsheets into chemical databases
Part 2: Chemical structure database cleanup: Building a catalog in ChemBioFinder
Part 3: Using chemical catalogs in ChemFinder: Creating customer-requested lists
To watch the full video, choose from the available formats below, and simply click on the corresponding link. You must have the appropriate player to play the file. For more info on video players, here. You may also download the video file, depending on your OS & browser, by right clicking or alt-clicking and choosing save link as.
To download a file, right click on the corresponding link and choose "Save Links As" or "Save Target As".