Forum Replies Created
2 weeks, 2 days ago jordanParticipant
I also have to export data for others, and I have found the notes to be extremely valuable in the data table. This does get exported, and you can give detailed comments on how you calculate each column.
I would also like to export the group names, but I think that would difficult in a csv format… I can’t think of a good solution there to suggest… and I do think the export should work the same between csv and excel if possible.in reply to: Export options2 months, 2 weeks ago jordanParticipant
I guess I took the request another way. It sounded like for every data point, there were two values.
The method I chose was to mask the data with a if statement that checks the reminder of a number divided by 2. This separates the peaks and troughs, and then you can plot them individually.in reply to: How can I separate a column data by odd/even rows?8 months, 1 week ago jordanParticipant
Yes Fig 4 is very nice. Great work! I would like to see more of the approach you used! Thanks!
jordan8 months, 2 weeks ago jordanParticipant
Yep, that is another way to do it, but hand jamming those equations is cumbersome and a little mistake prone. Not a problem, it does work, just have to take care you get all the parenthesis in proper place.
jordanin reply to: Column of averages of other columns9 months ago jordanParticipant
You can also do this in a more spreadsheet like way using the defined “mean” function as shown in this screen shot:
Be aware that there is not a standard deviation function defined, so if you would like that statistic, you will need to use the pivot command. I think that in a future version a defined stdev function would be very useful , and that function would be sufficient for many users.
in reply to: Column of averages of other columns10 months, 1 week ago jordanParticipant
- This reply was modified 9 months ago by jordan. Reason: terminology
This is a great step in the right direction. For my work flow, I would like to highlight multiple columns in the definitions table and the right click to show or hide the multiple columns. Thanks for the updates! I will check out the latest beta!in reply to: Show/hide multiple columns at once