Javascript Disabled Detected

You currently have javascript disabled. Several functions may not work. Please re-enable javascript to access full functionality.

Spreadsheets/graphs

Started by Johnc , May 04 2012 10:52 AM

Please log in to reply

6 replies to this topic

#1 Johnc

New Member

Members
0 posts

Posted 04 May 2012 - 10:52 AM

I plan to track my lab results and look at weekly variance along with graphs. However, I was curious if anyone has created these already and would like to share the?

Thanks,

John

Back to top

#2 PhilB

Advanced Member

Members
130 posts

Posted 04 May 2012 - 11:08 AM

Hi John,

Various people have done this, but it does tend to get very dull very quickly for most. Most people's blood counts normalise in a very short period and then the CBC pretty much ceases to be relevant and you are just tracking 3 monthly FISH and/or PCR. Unless you are one of the unlucky few who suffer with persistent dangerously low counts it really isn't worth the hassle - unless you really, really like doing graphs.

Phil

Back to top

#3 CallMeLucky

Advanced Member

Members
216 posts

LocationCT

Posted 04 May 2012 - 12:46 PM

I actually built an Access database to track everything. But as Phil said, it does get pretty old pretty quick. (that reminds me I have to go update it with my last two set of results )

Date - Lab - Scale - Drug - Dosage MG - PCR

2010/Jul - MSKCC - Non-IS - Gleevec - 400 - 1.2%

2010/Oct - MSKCC - Non-IS - Gleevec - 400 - 0.25%

2010/Dec - MSKCC - Non-IS - Gleevec - 400 - 0.367%

2011/Mar - MSKCC - Non-IS - Gleevec - 400 - 0.0081%

2011/Jun - MSKCC - Non-IS - Gleevec - 400 - 0%

2011/Sep - MSKCC - Non-IS - Gleevec - 400 - 0.00084%

2011/Dec - MSKCC - Non-IS - Gleevec - 400 - 0%

2012/Mar - MSKCC - Non-IS - Gleevec - 400 - 0.004%

2012/Jun - MSKCC - Non-IS - Gleevec - 400 - 0%

2012/Sep - MSKCC - Non-IS - Gleevec - 400 - 0%

2012/Dec - MSKCC - Non-IS - Sprycel - 100 - 0%

2013/Jan - Quest - IS - Sprycel - 50-60-70 - 0%

2013/Mar - Quest - IS - Sprycel - 60-70 - 0%

2013/Apr - CUMC - Non-IS - Sprycel - 50 - 0.036%

2013/May - CUMC - Non-IS - Sprycel - 50 - 0.046%

2013/Jun - Genoptix - IS - Sprycel - 50 - 0.0239%

2013/Jul - Genoptix - IS - Sprycel - 70 - 0.0192%

2013/Jul - Genoptix - IS - Sprycel - 70 - 0.0034%

2013/Oct - Genoptix - IS - Sprycel - 70 - 0.0054%

2014/Jan - Genoptix - IS - Sprycel - 70 - 0.0093%

2014/Mar - Genoptix - IS - Sprycel - 100 - 0.013%

2014/Apr - Genoptix - IS - Sprycel - 100 - 0.0048%

2014/Jul - Genoptix - IS - Sprycel - 100 - 0%

2014/Nov - Genoptix - IS - Sprycel - 100 - 0.047%

2014/Dec - Genoptix - IS - Sprycel - 100 - 0%

2015/Mar - Genoptix - IS - Sprycel - 100 - 0%

2015/Jun - Genoptix - IS - Sprycel - 100 - 0%

2015/Sep - Genoptix - IS - Sprycel - 100 - 0%

2015/Dec - Genoptix - IS - Sprycel - 100 - 0%

2016/Mar - Genoptix - IS - Sprycel - 100 - 0.0228%

2016/Jun - Genoptix - IS - Sprycel - 100 - 0%

2016/Sep - Genoptix - IS - Sprycel - 100 - 0%

2016/Dec - Genoptix - IS - Sprycel - 100 - 0%

2017/Mar - Genoptix - IS - Sprycel - 100 - 0%

2017/Jun - Genoptix - IS - Sprycel - 100 - 0%

2017/Sep - Genoptix - IS - Sprycel - 100 - 0%

2017/Dec - Genoptix - IS - Sprycel - 100 - 0%

Back to top

#4 Happycat

New Member

Members
5 posts

Posted 04 May 2012 - 08:09 PM

Wow, you actually made a database for it? I just muddle along with Excel.

Phil is right. It's fun to watch stuff drop in the beginning, but then they stabilize and it becomes busy work to update it.

If I follow anything now, it's just a few main numbers.

Traci

Back to top

#5 gunner

New Member

Members
0 posts

Posted 05 May 2012 - 12:07 PM

Here is a link to some charts that I used several years ago. http://community.lls.org/thread/1936

Back to top

#6 hannibellemo

Advanced Member

Members
728 posts

LocationNorth Central Iowa

Posted 06 May 2012 - 08:23 AM

I agree with everyone else. I set up an excel spreadsheet (after Gunner started talking about his) that tracks everything they do with my blood and marrow, from simple CBCs to BMBs and PCR results. Very boring usually, but now, since I'm off Sprycel for a PE it's interesting to go back and compare from when I was off Gleevec with liver toxicity. Gee, talk about OCD!

I can also make "8 x 10 color glossy graphs with circles and arrows and a paragraph on the back of each one explaining what each one means" (A little tribute to Arlo)

Pat

"You can't change the direction of the wind but you can adjust your sails."

DX 12/08; Gleevec 400mg; liver toxicity; Sprycel 100mg.; CCyR 4/10; MMR 8/10; Pleural Effusion 2/12; Sprycel 50mg. Maintaining MMR; 2/15 PCRU; 8/16 drifting in and out of undetected like a wave meeting the shore. Retired 12/23/2016! 18 months of PCRU, most recent at Mayo on 7/25/17 was negative at their new sensitivity reporting of 0.003.<p>

Back to top

#7 cberwick

New Member

Members
0 posts

Posted 17 May 2012 - 05:18 PM

Hi John,

I created a spreadsheet that tracks lab results and has a chart for tracking trends. It also has formatting to call out high or low results. I don't see a way to upload an Excel file here. If you would like the spreadsheet, send me an email:

chris_berwick @ yahoo.com (remove the spaces)

Cheers,

Chris.