Post reply

Warning: this topic has not been posted in for at least 360 days.
Unless you're sure you want to reply, please consider starting a new topic.
Name:
Email:
Subject:
Message icon:
Attach:
(Clear Attachment)
(more attachments)
Restrictions: 4 per post, maximum total size 192KB, maximum individual size 128KB
Verification:
Type the letters shown in the picture
Listen to the letters / Request another image

Type the letters shown in the picture:
What are the three letters (lower case) often used to denote Shriners Hospitals?:

shortcuts: hit alt+s to submit/post or alt+p to preview


Topic Summary

Posted by: elroy
« on: September 14, 2016, 01:47:44 PM »

Hi Adam,

Yes, this was really a note to me more than anything.  It's never completely trivial to produce new plots (and some of what's in that first post is notes-to-self).

However, it could be easier to add plots than it currently is.  The first criteria is that the data would need to be placed into the Excel plot file.  But there's already several columns of data in these files that are not being plotted. 

What this is about is allowing you (the user) a mechanism to have additional plots in the Excel files when they're produced by the Patients & Services program.  Again, we'd need to make sure the Kinematic, Kinetic, etc. data is in the file, but producing additional plot tabs should be easier than it currently is.

Elroy
Posted by: Adam Graf
« on: September 13, 2016, 11:50:34 AM »

I'm not sure I completely follow this, but if this would be a way to customize the plots shown and make available the knee varus/valgus moments plot, then I would be for it. I think the customization of the pages becomes more valuable when more users are involved.
Posted by: elroy
« on: September 11, 2016, 11:43:43 AM »

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