This challenge is interesting for a number of reasons:
Easy to use and learn, somewhat, VBA coding (Excel code) is useable for programming because the file format is csv.
There doesn’t seem to be many variables.
It seems to me they want a fast result when they get new data in order to draw attention quick enough to redirect subsequent work, rather than struggle getting likely excess data and having to process it.
It's like they want a way to get the sampler plate of the main menu, but only if it comes with meat. I like food metaphors.
Am I close?
I fear I'm not close. After reading more about the contest, it seems to me they want a full-blown data analysis program that addresses the "whole enchilada". The data provided is simple: time, temperature, m/z, abundance.
But each sample is heated over time, so time and temperature are correlated. Some of this is intuitive. For instance, the m/z, for most compounds, will likely get binned (detected) only when they get hot enough since the greater the mass (and higher m/z ratio) the hotter it must be for it to get ionized enough for detection.
Identification of the compound falls into about 10 types (basalt, etc.), though you can add your own if you like. This suggests that weight (value) must be assigned to them and I think ratios of these can also play a big role.
This looks very involved, with only 5 weeks left. They do have a forum (
here) that gets into it a little deeper, but you won't find much activity.
I hope someone will look at this closer and discover they really do want something that will snag key data points much quicker than they are accustomed, but it looks to me like they want something they already should have. These spectrometers have been around for a while and scientists, even those for the mfg., likely have these programs already. So what am I missing?
I did notice they do have 11 teams working on this, though one person might be an entire team. This is such a cool project and also very important, so I wish them the best.