Spreadsheet for tracking thread
Posted: Thu Jul 08, 2010 9:10 pm
Hi everyone,
I don't know if this has been tried before but I've been thinking about it for quite some time. I believe it would be quite useful (anecdotally, not scientifically) to create a chart that shows the results reported in the tracking thread "at a glance." To show you what I mean, I humbly submit this example showing only the first 3 posts, to get your feedback (click to download spreadsheet):
tracking thread spreadsheet
Please allow me to explain my logic for the various headings although some are self-explanatory. I think it would get really complex to list all symptoms or even every improvement; it's already here in the forum if you want to read it. I simply propose reporting whether results are positive (it helped), no change, or negative (patient got worse)... see tracking thread for more details. It's just a snapshot and needs to be interpreted as such.
Page - to be able to quickly find the page in the tracking thread
Username
Name
M/F
Age
Dx/Date - This is the diagnosis (e.g. RRMS) followed by the year
Lesions - Locations (brain, spine)
DMDs (CRABs/Tysabri) - I'm thinking we should limit this to the main DMDs, yes means one or more were tried at one point
Relapses - reported relapses pre-op
IBT - Inclined Bed Therapy
Date M/D/Y - date of procedure
Location
Study - MRI/MRV/US (Doppler Ultrasound)
Dx - Diagnosis (stenosis, occlusion, narrowing...)
Where - e.g., left/right jugulars
Procedure - stents and/or angio
Post-Op - any issues (pain, etc.)
Relapses - since procedure
First Rept - first date impact reported
Impact - initial impact (positive/negative/no change)
Last Rept - last date impact reported
Impact - last reported impact (positive/negative/no change)
EDSS - before / after
FSS - before / after
MSIS - before / after
----
Once the above is fine-tuned I will provide a key. ALL input, good and bad, is welcome. It could even be a really bad idea for some reason, for example, maybe being too general is going to give people the wrong idea (look how many positives!) when maybe some of those positives are subtle or even no longer relevant because the person's condition declined later and they never came back to update. Did I mention this is not scientific?
It's not for any particular purpose other than to be able to visualize our own informal data without having to scan the entire tracking thread.
I'm not sure how I'll find the time to complete this but if interest is high I will make it a priority. I've ordered "Dragon Naturally Speaking" to help with my typing issues since my speed has slowed to a crawl.
Pam
I don't know if this has been tried before but I've been thinking about it for quite some time. I believe it would be quite useful (anecdotally, not scientifically) to create a chart that shows the results reported in the tracking thread "at a glance." To show you what I mean, I humbly submit this example showing only the first 3 posts, to get your feedback (click to download spreadsheet):
tracking thread spreadsheet
Please allow me to explain my logic for the various headings although some are self-explanatory. I think it would get really complex to list all symptoms or even every improvement; it's already here in the forum if you want to read it. I simply propose reporting whether results are positive (it helped), no change, or negative (patient got worse)... see tracking thread for more details. It's just a snapshot and needs to be interpreted as such.
Page - to be able to quickly find the page in the tracking thread
Username
Name
M/F
Age
Dx/Date - This is the diagnosis (e.g. RRMS) followed by the year
Lesions - Locations (brain, spine)
DMDs (CRABs/Tysabri) - I'm thinking we should limit this to the main DMDs, yes means one or more were tried at one point
Relapses - reported relapses pre-op
IBT - Inclined Bed Therapy
Date M/D/Y - date of procedure
Location
Study - MRI/MRV/US (Doppler Ultrasound)
Dx - Diagnosis (stenosis, occlusion, narrowing...)
Where - e.g., left/right jugulars
Procedure - stents and/or angio
Post-Op - any issues (pain, etc.)
Relapses - since procedure
First Rept - first date impact reported
Impact - initial impact (positive/negative/no change)
Last Rept - last date impact reported
Impact - last reported impact (positive/negative/no change)
EDSS - before / after
FSS - before / after
MSIS - before / after
----
Once the above is fine-tuned I will provide a key. ALL input, good and bad, is welcome. It could even be a really bad idea for some reason, for example, maybe being too general is going to give people the wrong idea (look how many positives!) when maybe some of those positives are subtle or even no longer relevant because the person's condition declined later and they never came back to update. Did I mention this is not scientific?
It's not for any particular purpose other than to be able to visualize our own informal data without having to scan the entire tracking thread.
I'm not sure how I'll find the time to complete this but if interest is high I will make it a priority. I've ordered "Dragon Naturally Speaking" to help with my typing issues since my speed has slowed to a crawl.
Pam