Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

How to extract test data from blue button to spreadsheet

I am a Hepatitis C patient who is able to download my health info and blood test results from the VA xxxxxxx.bluebutton

I would like a way to auto import certain test data in to a spreadsheet to view, create graphs and apply math formulas. Windows 7 ultimate 64bit LibreOffice 4.15

Partial text version of that file with personal info redacted located https://www.dropbox.com/sh/5wx8qlp4g5gx5io/oLCtuz35NU/Bluebutton%20data%20text%20sample.txt

Partial description of what you will find on that file test are separated by long ===line test type, who ordered, date are between long ===line and long --- If more than 1 test name next is separated by short line--. If there are comments then there is a long ---line before the comments and the next long ===line that separates this from the next test type, who ordered, date

========================================================================

This area has type of test who ordered date etc

long ---

This area has test name, results, reference range and other info Result: 36.4 High - will show high or low if abnormal after the numerical number

If there are more test under the same type who ordered and date then

short line-- separates etc.

I would like a way to auto import at least as much as I can to display a spreadsheet time line

test --------------- date ----- date
1st test name --- result --- result
2nd test name --- result --- result

Ability to plot graphs of results over time display Red if high black if normal or purple if low

Add clinical calculators to auto take specific test results from 2 to 5 test same date and use predetermined math formula to get a result.

http://www.healthit.gov/patients-families/blue-button/about-blue-button

I realize i am asking a lot with limited knowledge. Don't have money to pay a programmer. 66 retired on ss but have a lot of time to learn slowly. Had some experience with early excel versions in the mid nineties creating estimating spreadsheets. If anyone has suggestions or links that may help me learn more it would be greatly appreciated.

Regards, OM

How to extract test data from blue button to spreadsheet

I am a Hepatitis C patient who is able to download my health info and blood test results from the VA xxxxxxx.bluebutton

I would like a way to auto import certain test data in to a spreadsheet to view, create graphs and apply math formulas. Windows 7 ultimate 64bit LibreOffice 4.15

Partial text version of that the blue button file as a text file with personal info redacted located https://www.dropbox.com/sh/5wx8qlp4g5gx5io/oLCtuz35NU/Bluebutton%20data%20text%20sample.txt

Partial description of what you will find on that file test are separated by long ===line test type, who ordered, date are between long ===line and long --- If more than 1 test name next is separated by short line--. If there are comments then there is a long ---line before the comments and the next long ===line that separates this from the next test type, who ordered, date

========================================================================

This area has type of test who ordered *date etc* (The date etcis always extracted from here for all test listed between the top ====line and the next ====line. There may be 1, 2 or more listed)

long ---

This area has test name, results, *test name, results, reference range and other info * Result: 36.4 High 36.4 High - will show high or low if abnormal after the numerical number

number extract test name: results (high, low or empty) Ref range date from above If there are more test names listed after then get the same info under the same type who ordered and date then

then short line-- separates etc.

Next ===== starts next test type and or date (at least 1 of these will be different)

I would like a way to auto import at least as much as I can to display a spreadsheet time line (Q1 most important ===line separates test type from another test type

test --------------- date X ----- date X reference range 1st test name --- result H --- result H
1st 2nd test name --- result L--- result N 3rd test name --- result
2nd test name ---
N--- result --- result

N Ability to plot graphs of results over time display Red if high black if normal or purple if lowlow. Could have another column next to r4esults to show H for High L for Low and N for normal(empty) reference range could a column at the far right. this specific format just gives an idea of what I would like feel free to change if easier .

Add clinical calculators to auto take specific test results from 2 to 5 test same date and use predetermined math formula to get a result.

http://www.healthit.gov/patients-families/blue-button/about-blue-buttonresult. (This is Q 2 optional to answer and can wait for now)

http://www.healthit.gov/patients-families/blue-button/about-blue-button MAJOR edit to add more detail 9PM EST 2-23

I realize i am asking a lot with limited knowledge. Don't have money to pay a programmer. 66 retired on ss but have a lot of time to learn slowly. Had some experience with early excel versions in the mid nineties creating estimating spreadsheets. If anyone has suggestions or links that may help me learn more it would be greatly appreciated.

Regards, OM

My question explains the blue button layout for blood lab results shown in the sample . All the information in my sample above the first long ===line is not needed. I describe the limited information i want to extract to add to a spreadsheet and/or data base. Other wise my question would be even much longer.

How to extract test data from blue button to spreadsheet

I am a Hepatitis C patient who is able to download my health info and blood test results from the VA xxxxxxx.bluebuttonxxxxxxx.bluebutton MAJOR edit to add more detail 9;30 PM EST 2-23

I would like a way to auto import certain test data in to a spreadsheet to view, create graphs and apply math formulas. Windows 7 ultimate 64bit LibreOffice 4.15

Partial text version of the blue button file as a text file with personal info redacted located https://www.dropbox.com/sh/5wx8qlp4g5gx5io/oLCtuz35NU/Bluebutton%20data%20text%20sample.txt

Partial description of what you will find on that file test are separated by long ===line test type, who ordered, date are between long ===line and long --- If more than 1 test name next is separated by short line--. If there are comments then there is a long ---line before the comments and the next long ===line that separates this from the next test type, who ordered, date

========================================================================

This area has type of test who ordered *date etc* (The date is always extracted from here for all test listed between the top ====line and the next ====line. There may be 1, 2 or more listed)

long ---

This area has *test name, results, reference range and other info* Result: 36.4 High - will show high or low if abnormal after the numerical number number

extract test name: results (high, low or empty) Ref range date from above If there are more test names listed after then get the same info under the same type who ordered and date then short line-- separates etc.

Next ===== starts next test type and or date (at least 1 of these will be different)

I would like a way to auto import at least as much as I can to display a spreadsheet time line (Q1 most important ===line separates test type from another test type

test --------------- date X ----- date X reference range range

1st test name --- result H --- result H

2nd test name --- result L--- result N N

3rd test name --- result N--- result N N

Ability to plot graphs of results over time display Red if high black if normal or purple if low. Could have another column next to r4esults to show H for High L for Low and N for normal(empty) reference range could a column at the far right. this specific format just gives an idea of what I would like feel free to change if easier .

Add clinical calculators to auto take specific test results from 2 to 5 test same date and use predetermined math formula to get a result. (This is Q 2 optional to answer and can wait for now)

http://www.healthit.gov/patients-families/blue-button/about-blue-button MAJOR edit to add more detail 9PM EST 2-23

I realize i am asking a lot with limited knowledge. Don't have money to pay a programmer. 66 retired on ss but have a lot of time to learn slowly. Had some experience with early excel versions in the mid nineties creating estimating spreadsheets. If anyone has suggestions or links that may help me learn more it would be greatly appreciated.

Regards, OM

My question explains the blue button layout for blood lab results shown in the sample . All the information in my sample above the first long ===line is not needed. I describe the limited information i want to extract to add to a spreadsheet and/or data base. Other wise my question would be even much longer.

How to extract test data from blue button to spreadsheet

I am a Hepatitis C patient who is able to download my health info and blood test results from the VA xxxxxxx.bluebutton MAJOR edit to add more detail 9;30 PM EST 2-23

I would like a way to auto import certain test data in to a spreadsheet to view, create graphs and apply math formulas. Windows 7 ultimate 64bit LibreOffice 4.15

Partial text version of the blue button file as a text file with personal info redacted located https://www.dropbox.com/sh/5wx8qlp4g5gx5io/oLCtuz35NU/Bluebutton%20data%20text%20sample.txt

Partial description of what you will find on that file test are separated by long ===line test type, who ordered, date are between long ===line and long --- If more than 1 test name next is separated by short line--. If there are comments then there is a long ---line before the comments and the next long ===line that separates this from the next test type, who ordered, date

========================================================================

This area has type of test who ordered *date etc* (The date is always extracted from here for all test listed between the top ====line and the next ====line. There may be 1, 2 or more listed)

long ---

This area has *test name, results, reference range and other info* Result: 36.4 High - will show high or low if abnormal after the numerical number

extract test name: results (high, low or empty) Ref range date from above If there are more test names listed after then get the same info under the same type who ordered and date then short line-- separates etc.

Next ===== starts next test type and or date (at least 1 of these will be different)

I would like a way to auto import at least as much as I can to display a spreadsheet time line (Q1 most important ===line separates test type from another test type

test --------------- date X ----- date X reference range

1st test name --- result H --- result H

2nd test name --- result L--- result N

3rd test name --- result N--- result N

Ability to plot graphs of results over time display Red if high black if normal or purple if low. Could have another column next to r4esults results to show H for High L for Low and N for normal(empty) reference range could a column at the far right. this specific format just gives an idea of what I would like feel free to change if easier .

Add clinical calculators to auto take specific test results from 2 to 5 test same date and use predetermined math formula to get a result. (This is Q 2 optional to answer and can wait for now)

http://www.healthit.gov/patients-families/blue-button/about-blue-button

I realize i am asking a lot with limited knowledge. Don't have money to pay a programmer. 66 retired on ss but have a lot of time to learn slowly. Had some experience with early excel versions in the mid nineties creating estimating spreadsheets. If anyone has suggestions or links that may help me learn more it would be greatly appreciated.

Regards, OM

My question explains the blue button layout for blood lab results shown in the sample . All the information in my sample above the first long ===line is not needed. I describe the limited information i want to extract to add to a spreadsheet and/or data base. Other wise my question would be even much longer.

How to extract test data from blue button to spreadsheet

I am a Hepatitis C patient who is able to download my health info and blood test results from the VA xxxxxxx.bluebutton MAJOR edit to add more detail 9;30 PM EST 2-23

I would like a way to auto import certain test data in to a spreadsheet to view, create graphs and apply math formulas. Windows 7 ultimate 64bit LibreOffice 4.15

Partial text version of the blue button file as a text file with personal info redacted located https://www.dropbox.com/sh/5wx8qlp4g5gx5io/oLCtuz35NU/Bluebutton%20data%20text%20sample.txt

Partial description of what you will find on that file test are separated by long ===line test type, who ordered, date are between long ===line and long --- If more than 1 test name next is separated by short line--. If there are comments then there is a long ---line before the comments and the next long ===line that separates this from the next test type, who ordered, date

========================================================================

This area has type of test who ordered *date etc* (The date is always extracted from here for all test listed between the top ====line and the next ====line. There may be 1, 2 or more listed)

long ---

This area has *test name, results, reference range and other info* Result: 36.4 High - will show high or low if abnormal after the numerical number

extract test name: results (high, low or empty) Ref range date from above If there are more test names listed after then get the same info under the same type who ordered and date then short line-- separates etc.

Next ===== starts next test type and or date (at least 1 of these will be different)

I would like a way to auto import at least as much as I can to display a spreadsheet time line (Q1 most important ===line separates test type from another test type

test --------------- date X ----- date X reference range

1st test name --- result H --- result H

2nd test name --- result L--- result N

3rd test name --- result N--- result N

Ability to plot graphs of results over time display Red if high black if normal or purple if low. Could have another column next to results to show H for High L for Low and N for normal(empty) reference range could a column at the far right. this specific format just gives an idea of what I would like feel free to change if easier .

Add clinical calculators to auto take specific test results from 2 to 5 test same date and use predetermined math formula to get a result. (This is Q 2 optional to answer and can wait for now)

http://www.healthit.gov/patients-families/blue-button/about-blue-button

I realize i am asking a lot with limited knowledge. Don't have money to pay a programmer. 66 retired on ss but have a lot of time to learn slowly. Had some experience with early excel versions in the mid nineties creating estimating spreadsheets. If anyone has suggestions or links that may help me learn more it would be greatly appreciated.

Regards, OM

My question explains the blue button layout for blood lab results shown in the sample . All the information in my sample above the first long ===line is not needed. I describe the limited information i want to extract to add to a spreadsheet and/or data base. Other wise my question would be even much longer.