| Macros [message #124] |
Wed, 09 December 2015 18:18  |
KatChem
Messages: 1
Registered: December 2015
|
Junior Member |
|
|
I have saved a macro to incorporate all the tasks I'd like to do with project data - pivot data, show the mean IC50 value for each assay, set the background colour for the mean IC50 values, insert a column showing selectivity for one assay over another and show all the data rounded to 2 significant figures.
On running the macro, only the pivot and calculated column insertion work. The background colour gets added for the last column. Multiple values are not shown as the mean and none of the data is rounded. Saving each task as a separate macro and then using the macro editor to combine them into one macro only pivots the data - all the other macros result in errors (the rounding macros say: macro does not have any tasks, the background colour macros say: column not found, the calculate new column macro says: unrecognised symbol and the rounding macros say: macro does not have any tasks).
I've also tried recording a macro sequence from already pivoted data but this results in the same output as the first macro I recorded. Is it possible to set up a macro to combine these tasks?
|
|
|
|
| Re: Macros [message #127 is a reply to message #124] |
Sat, 12 December 2015 14:54  |
thomas
Messages: 715
Registered: June 2014
|
Senior Member |
|
|
Macro tasks in general belong architecturally to the trickiest, least tested and newest functionality. As you have discovered, there is still some functionality that cannot be done in a macro. If you try recording some of these and the following task depend on the oputcome of the non-existing tasks, you get errors as you describe. Still missing tasks are mainly the 'append file', 'combichem library' and some column related tasks. Despite macros are rarely used, I believe that macros have a huge potential and since the last public release I have already fixed lots of macro related issues.
If you can send me a small example, e.g. source file (can be a mockup) and one how it should look like after running the macro, then I promise you that I will make sure that all the needed macro tasks will exist and work well for the next public release. Altogether, most of it should work already. Do you want the mean() function to calculate the mean value of all values of a particular column? This does not yet exist, but could be easily implemented as sum(), median(), max(), min(). Depending on the logMode of the column, the mean would be a normal or an geometrical one.
|
|
|
|
Search
Help
Members
Register
Login
Home
