Export averages generated for making graphs.

[schreejf]

Is there a way to export the averages generated for making graphs? I'm using the absolute and relative graphs to see changes for different marker ranges. I've been doing this visually, but would like to export the data used to generate the graphs so I can calculate the average for a whole marker range to compare averages from other marker ranges.

So, in the end I'd have something like this for averages for each brain wave for each marker range.

M1 M2 M3 M4
Gamma 0.8 0.6 0.9 0.5
Beta 0.7 0.5 0.8 0.5
Alpha 0.5 0.8 0.6 0.9
Theta 0.7 0.8 0.5 0.8
Delta 0.8 0.9 0.7 0.8

And then I could make a simple graph to compare how brain waves change, on average, for each marker range.

[James]

Create a chart, then open the chrome console and run "chartData.toJSON()"
At the bottom click the little "copy" button.

Remove the leading and trailing quote marks, and there's all the chart data in JSON format to tinker with as you wish.

Or, you could just run the Excel macro, but that just does simple brainwave averages.

[schreejf]

Thanks for the quick response.

For removing leading and trailing quotes, is it all quotes (single and double) or just the single quotes at the beginning and end? I tried both by coping to excel and word and exporting as txt file and changing the suffix to json. I'm new to json files.

Then I tried importing the json file to excel via the "get data (power query)", but can't get this to work.

Steps
Open Excel
Select the Data tab
Click Get Data
Select From File
Select From JSON
Find the JSON file you want to import and click Open
Excel will open the Power Query Editor
Preview the data and decide how to load it into the spreadsheet
Click Transform and select To Table to convert the data into a table
Select the columns you want to display
Click Load to import the table into Excel

[James]

Just the first and last single quote as it's being expressed as a string in the console.
To test just paste into http://jsonviewer.stack.hu/
I've never tried json in Excel, so can't comment on that.. The data structure will likely need some more code to flatten the row data structure in to more excel like rows.
Honestly, this is probably more hassle than it's worth. All the chartData has are averages, and you can calculate those from the original data in Excel with simple formula's. Just run the macro on the website to filter out the blinks and you're 90% there.

[schreejf]

Great. Thanks. I'll give the macro a try.

[schreejf]

Just setup the macro and when I run it, excel seems to lock up. Does it take a long time for the macro to run? When I import the same results to the mindmonitor website it only take a few seconds to generate the graph.

[James]

That's why I switched to the online charts
Excel isn't great at very large data sets. If you just wait and it should finish. If there was an error with the Excel macro, you'd get a popup warning.
It's probably just struggling with the data set size and available ram/cpu.