Hi All,
I have a notepad file that will not properly convert to Excel. Can anyone help?
DATE 10/01/05 611 NORTH SHORE UNIVERSITY HOSPITAL KLF PATIENT REVENUE AND USAGE STATISTICS ACC PER 09 PAGE 1
----TOTAL---- ----OTHER---- ---MEDICARE-- --TITLE XIX-- -BLUE CROSS- ---POINT---- ----POINT---- ----POINT----
FREQ REVENUE FREQ REVENUE FREQ REVENUE FREQ REVENUE FREQ REVENUE VALUE 1 VALUE 2 VALUE 3
************************************************************************************************************************************
611-0007 CVP CATH 14 OR 17 .0000 .0000 .0000
CUR 1 1 0 0 0
7.00 7.00 0.00 0.00 0.00 0.0000 0.0000 0.0000
IP 1 1 0 0 0
7.00 7.00 0.00 0.00 0.00 0.0000 0.0000 0.0000
OP 0 0 0 0 0
0.00 0.00 0.00 0.00 0.00 0.0000 0.0000 0.0000
YTD 4 4 0 0 0
28.00 28.00 0.00 0.00 0.00 0.0000 0.0000 0.0000
IP 4 4 0 0 0
28.00 28.00 0.00 0.00 0.00 0.0000 0.0000 0.0000
OP 0 0 0 0 0
0.00 0.00 0.00 0.00 0.00 0.0000 0.0000 0.0000
************************************************************************************************************************************
611-0008 CVP CATH 16 .0000 .0000 .0000
CUR 1 1 0 0 0
7.00 7.00 0.00 0.00 0.00 0.0000 0.0000 0.0000
IP 1 1 0 0 0
7.00 7.00 0.00 0.00 0.00 0.0000 0.0000 0.0000
OP 0 0 0 0 0
0.00 0.00 0.00 0.00 0.00 0.0000 0.0000 0.0000
YTD 4 4 0 0 0
28.00 28.00 0.00 0.00 0.00 0.0000 0.0000 0.0000
IP 4 4 0 0 0
28.00 28.00 0.00 0.00 0.00 0.0000 0.0000 0.0000
OP 0 0 0 0 0
0.00 0.00 0.00 0.00 0.00 0.0000 0.0000 0.0000
************************************************************************************************************************************
611-0009 CATH TRAY 14-16 .0000 .0000 .0000
CUR 51 39 0 1 11
255.00 195.00 0.00 5.00 55.00 0.0000 0.0000 0.0000
IP 51 39 0 1 11
255.00 195.00 0.00 5.00 55.00 0.0000 0.0000 0.0000
OP 0 0 0 0 0
0.00 0.00 0.00 0.00 0.00 0.0000 0.0000 0.0000
YTD 657 458 0 6 193
3,285.00 2,290.00 0.00 30.00 965.00 0.0000 0.0000 0.0000
IP 657 458 0 6 193
3,285.00 2,290.00 0.00 30.00 965.00 0.0000 0.0000 0.0000
OP 0 0 0 0 0
0.00 0.00 0.00 0.00 0.00 0.0000 0.0000 0.0000
************************************************************************************************************************************
611-0010 CATH TRAY FOLEY .0000 .0000 .0000
CUR 269 175 0 3 91
1,883.00 1,225.00 0.00 21.00 637.00 0.0000 0.0000 0.0000
IP 269 175 0 3 91
1,883.00 1,225.00 0.00 21.00 637.00 0.0000 0.0000 0.0000
OP 0 0 0 0 0
0.00 0.00 0.00 0.00 0.00 0.0000 0.0000 0.0000
YTD 2,506 1,628 3 70 805
17,542.00 11,396.00 21.00 490.00 5,635.00 0.0000 0.0000 0.0000
IP 2,506 1,628 3 70 805
17,542.00 11,396.00 21.00 490.00 5,635.00 0.0000 0.0000 0.0000
OP 0 0 0 0 0
0.00 0.00 0.00 0.00 0.00 0.0000 0.0000 0.0000
DATE 10/01/05 611 NORTH SHORE UNIVERSITY HOSPITAL KLF PATIENT REVENUE AND USAGE STATISTICS ACC PER 09 PAGE 2
----TOTAL---- ----OTHER---- ---MEDICARE-- --TITLE XIX-- -BLUE CROSS- ---POINT---- ----POINT---- ----POINT----
FREQ REVENUE FREQ REVENUE FREQ REVENUE FREQ REVENUE FREQ REVENUE VALUE 1 VALUE 2 VALUE 3
************************************************************************************************************************************
611-0029 PLEURAVAC ADULT .0000 .0000 .0000
CUR 1 0 1 0 0
144.00 0.00 144.00 0.00 0.00 0.0000 0.0000 0.0000
IP 1 0 1 0 0
144.00 0.00 144.00 0.00 0.00 0.0000 0.0000 0.0000
OP 0 0 0 0 0
0.00 0.00 0.00 0.00 0.00 0.0000 0.0000 0.0000
YTD 1 0 1 0 0
144.00 0.00 144.00 0.00 0.00 0.0000 0.0000 0.0000
IP 1 0 1 0 0
144.00 0.00 144.00 0.00 0.00 0.0000 0.0000 0.0000
OP 0 0 0 0 0
0.00 0.00 0.00 0.00 0.00 0.0000 0.0000 0.0000
************************************************************************************************************************************
I have a notepad file that will not properly convert to Excel. Can anyone help?
DATE 10/01/05 611 NORTH SHORE UNIVERSITY HOSPITAL KLF PATIENT REVENUE AND USAGE STATISTICS ACC PER 09 PAGE 1
----TOTAL---- ----OTHER---- ---MEDICARE-- --TITLE XIX-- -BLUE CROSS- ---POINT---- ----POINT---- ----POINT----
FREQ REVENUE FREQ REVENUE FREQ REVENUE FREQ REVENUE FREQ REVENUE VALUE 1 VALUE 2 VALUE 3
************************************************************************************************************************************
611-0007 CVP CATH 14 OR 17 .0000 .0000 .0000
CUR 1 1 0 0 0
7.00 7.00 0.00 0.00 0.00 0.0000 0.0000 0.0000
IP 1 1 0 0 0
7.00 7.00 0.00 0.00 0.00 0.0000 0.0000 0.0000
OP 0 0 0 0 0
0.00 0.00 0.00 0.00 0.00 0.0000 0.0000 0.0000
YTD 4 4 0 0 0
28.00 28.00 0.00 0.00 0.00 0.0000 0.0000 0.0000
IP 4 4 0 0 0
28.00 28.00 0.00 0.00 0.00 0.0000 0.0000 0.0000
OP 0 0 0 0 0
0.00 0.00 0.00 0.00 0.00 0.0000 0.0000 0.0000
************************************************************************************************************************************
611-0008 CVP CATH 16 .0000 .0000 .0000
CUR 1 1 0 0 0
7.00 7.00 0.00 0.00 0.00 0.0000 0.0000 0.0000
IP 1 1 0 0 0
7.00 7.00 0.00 0.00 0.00 0.0000 0.0000 0.0000
OP 0 0 0 0 0
0.00 0.00 0.00 0.00 0.00 0.0000 0.0000 0.0000
YTD 4 4 0 0 0
28.00 28.00 0.00 0.00 0.00 0.0000 0.0000 0.0000
IP 4 4 0 0 0
28.00 28.00 0.00 0.00 0.00 0.0000 0.0000 0.0000
OP 0 0 0 0 0
0.00 0.00 0.00 0.00 0.00 0.0000 0.0000 0.0000
************************************************************************************************************************************
611-0009 CATH TRAY 14-16 .0000 .0000 .0000
CUR 51 39 0 1 11
255.00 195.00 0.00 5.00 55.00 0.0000 0.0000 0.0000
IP 51 39 0 1 11
255.00 195.00 0.00 5.00 55.00 0.0000 0.0000 0.0000
OP 0 0 0 0 0
0.00 0.00 0.00 0.00 0.00 0.0000 0.0000 0.0000
YTD 657 458 0 6 193
3,285.00 2,290.00 0.00 30.00 965.00 0.0000 0.0000 0.0000
IP 657 458 0 6 193
3,285.00 2,290.00 0.00 30.00 965.00 0.0000 0.0000 0.0000
OP 0 0 0 0 0
0.00 0.00 0.00 0.00 0.00 0.0000 0.0000 0.0000
************************************************************************************************************************************
611-0010 CATH TRAY FOLEY .0000 .0000 .0000
CUR 269 175 0 3 91
1,883.00 1,225.00 0.00 21.00 637.00 0.0000 0.0000 0.0000
IP 269 175 0 3 91
1,883.00 1,225.00 0.00 21.00 637.00 0.0000 0.0000 0.0000
OP 0 0 0 0 0
0.00 0.00 0.00 0.00 0.00 0.0000 0.0000 0.0000
YTD 2,506 1,628 3 70 805
17,542.00 11,396.00 21.00 490.00 5,635.00 0.0000 0.0000 0.0000
IP 2,506 1,628 3 70 805
17,542.00 11,396.00 21.00 490.00 5,635.00 0.0000 0.0000 0.0000
OP 0 0 0 0 0
0.00 0.00 0.00 0.00 0.00 0.0000 0.0000 0.0000
DATE 10/01/05 611 NORTH SHORE UNIVERSITY HOSPITAL KLF PATIENT REVENUE AND USAGE STATISTICS ACC PER 09 PAGE 2
----TOTAL---- ----OTHER---- ---MEDICARE-- --TITLE XIX-- -BLUE CROSS- ---POINT---- ----POINT---- ----POINT----
FREQ REVENUE FREQ REVENUE FREQ REVENUE FREQ REVENUE FREQ REVENUE VALUE 1 VALUE 2 VALUE 3
************************************************************************************************************************************
611-0029 PLEURAVAC ADULT .0000 .0000 .0000
CUR 1 0 1 0 0
144.00 0.00 144.00 0.00 0.00 0.0000 0.0000 0.0000
IP 1 0 1 0 0
144.00 0.00 144.00 0.00 0.00 0.0000 0.0000 0.0000
OP 0 0 0 0 0
0.00 0.00 0.00 0.00 0.00 0.0000 0.0000 0.0000
YTD 1 0 1 0 0
144.00 0.00 144.00 0.00 0.00 0.0000 0.0000 0.0000
IP 1 0 1 0 0
144.00 0.00 144.00 0.00 0.00 0.0000 0.0000 0.0000
OP 0 0 0 0 0
0.00 0.00 0.00 0.00 0.00 0.0000 0.0000 0.0000
************************************************************************************************************************************