See
this post on how to handle creating and plotting in apparent magnitudes.
The data columns are described at the end of the
Extended AIJ paper. The definitions are also available within AIJ at Multi-Plot Main > Help > "Data naming convention...", although it appears that the built in list is a little out of date.
As you surmised, AIJ does not currently implement a power spectrum analysis, but it is on our medium term development schedule. Python could do the analysis. You'd just need to load the measurements table as tab delimited file and analyze the data column of interest.
Others may have alternate tools to suggest until we implement directly in AIJ.
Karen