The alignment in excel is even easier using the VLOOKUP function.
Here's good explanation from Danny Rocks: https://www.youtube.com/watch?v=809m6kLTfgI
Search found 8 matches
- January 4th, 2019, 7:38 am
- Forum: Application, Discussion, and Bug Report
- Topic: export complete component table
- Replies: 3
- Views: 14507
- January 4th, 2019, 5:23 am
- Forum: Application, Discussion, and Bug Report
- Topic: export complete component table
- Replies: 3
- Views: 14507
Re: export complete component table
Alignment in Excel: I found a formula on internet which can do the alignment trick: Suppose the component names of the template are put in column A and the blob table (names, volumes, ret. times etc.) are in column B, C, D, etc. Suppose you have 100 components in the template. The headers are in row...
- December 22nd, 2018, 7:09 am
- Forum: Application, Discussion, and Bug Report
- Topic: export complete component table
- Replies: 3
- Views: 14507
export complete component table
Hi, I've runned several samples and matched them against a template which contains a lot of target-components. Not every component is present every sample. In the blob table, target-components that were not detected are not reported. This results in the fact that all blob tables of the analysis are ...
- December 19th, 2018, 11:46 am
- Forum: Application, Discussion, and Bug Report
- Topic: Match MS problem
- Replies: 2
- Views: 9694
Re: Match MS problem
The first option works well: setting the upper and lower MS-match both at 600 in the 'configure' - 'template' setting.
The second option causes the retention time constrains (which were also in the qCLIC specification) being deleted.
So, the first option is the best method.
The second option causes the retention time constrains (which were also in the qCLIC specification) being deleted.
So, the first option is the best method.
- December 18th, 2018, 5:52 am
- Forum: Application, Discussion, and Bug Report
- Topic: Match MS problem
- Replies: 2
- Views: 9694
Match MS problem
Hi, When I make a template from an analysis, I used "create qualifier CLIC constraints When adding blobs to template". I flagged the "Match MS" checkbox and set the limits to min 600 and max 999. Then included identified target peaks from the blob table to the template table and ...
- December 13th, 2018, 12:28 am
- Forum: Application, Discussion, and Bug Report
- Topic: Blob table not available
- Replies: 2
- Views: 9908
Re: Blob table not available
Yes. indeed. That was the problem. At work I had two screens, at home only one.
- December 12th, 2018, 7:26 am
- Forum: Application, Discussion, and Bug Report
- Topic: Installation of updates failed due to corrupted "install.log"
- Replies: 1
- Views: 9287
Installation of updates failed due to corrupted "install.log"
When I try to install new updates (e.g. 2.8), I get the message that the installation failed due to a corrupted "install.log" file.
What should I do?
What should I do?
- December 12th, 2018, 7:17 am
- Forum: Application, Discussion, and Bug Report
- Topic: Blob table not available
- Replies: 2
- Views: 9908
Blob table not available
Since a few days I can not display the blob table anymore, not either via the button or the menu-option <view - blob table>. When pressed nothing happens. I have the GCxGC HRMS 2.7 version 1. When I am in "spectral-review" mode, I can still see the blob table, but when I close review mode,...