I've thought about this one for years. At present, the plots in the Excel Plot file are somewhat fixed (with adding new ones not easily done).
It would be nice if there was a way for users to somewhat easily add new plots, possibly adding a new tab for them. Here is an idea I have:
- There is currently an EMG sub-folder used for various EMG setup. Have a similar sub-folder for motion plot setup, possibly named "Motion".
- In this "Motion" folder, there'd be an Excel file. This Excel file would have tabs (with plots) that would be added to the standard Excel Plot file upon creation. It might be named "Additional Excel Plots.xlsx".
- Creating these new plots is not entirely trivial. And the actual plot information would need to already be in the main Excel Plot file when it was created.
- In addition to the new tab and new plots, there'd need to be information about the patient's data column, the name of the plot, and other details.
- When the database creates a new Excel Plot file. It adds any new tabs found in the "Additional Excel Plots.xlsx" file, possibly based on the additional plot information found.
- The database would then adjust these plots to read all the information needed to make them a "live" plot.
To summarize, so long as data is in the standard Excel Plot file, these procedures would make it possible to plot this data, possibly making reorganized plot pages for printing.
Also, some of these routines could ease the work necessary when new plots are added to the standard Excel Plot file. Currently, it's a bit of a tedious job to individually create these new plots.
Regards,
Elroy