biogenie007
New Member
- Joined
- Jul 27, 2009
- Messages
- 8
Hi,
I have a huge challenge of converting an excel table into a word formatted table something like creating a booklet out of the data from excel table.
I am doing it manually (painstakingly 3+ weeks of formatting) right now by copying the table from html into word and formatting it accordingly.
Would require to compare 2 or 3 plans maintaining similar numbered sections together.
ANY IDEAS HOW TO AUTOMATE THIS PROCESS WOULD BE GREATLY APPRECIATED.
THE ORIGINAL TABLE is a HTML page which looks like the following when copied to excel (have copies sample data-set):
THE COMPLETED BOOKLET LOOKS LIKE THE FOLLOWING IN WORD:
I have a huge challenge of converting an excel table into a word formatted table something like creating a booklet out of the data from excel table.
I am doing it manually (painstakingly 3+ weeks of formatting) right now by copying the table from html into word and formatting it accordingly.
Would require to compare 2 or 3 plans maintaining similar numbered sections together.
ANY IDEAS HOW TO AUTOMATE THIS PROCESS WOULD BE GREATLY APPRECIATED.
THE ORIGINAL TABLE is a HTML page which looks like the following when copied to excel (have copies sample data-set):
| Excel Workbook | |||||
|---|---|---|---|---|---|
| A | B | C | |||
| 1 | If you have any questions about this plan's benefits or costs, please contact Health Plan for details. | ||||
| 2 | SECTION II - SUMMARY OF BENEFITS | ||||
| 3 | Benefit | Original Medicare | Health Plan | ||
| 4 | IMPORTANT INFORMATION | ||||
| 5 | 1 - Premium and Other Important Information | In 2008 the monthly Part B Premium was $96.40 and will change for 2009 and the yearly Part B deductible amount was $135 and will change for 2009. OR | General | ||
| 6 | $0 monthly plan premium in addition to your monthly Medicare Part B premium. | ||||
| 7 | In 2009 the monthly Part B Premium is $___ and the yearly Part B deductible amount is $___. | In-Network | |||
| 8 | $3,350 in-network out-of-pocket limit. | ||||
| 9 | If a doctor or supplier does not accept assignment, their costs are often higher, which means you pay more. | Not all plan services are covered under the out-of-pocket limit. Contact plan for a detailed list of non-covered services. | |||
| 10 | 2 - Doctor and Hospital Choice | You may go to any doctor, specialist or hospital that accepts Medicare. | In-Network | ||
| 11 | No referral required for network doctors, specialists, and hospitals. | ||||
| 12 | (For more information, see Emergency - #15 and Urgently Needed Care - #16.) | You may have to pay a separate copay for certain doctor office visits. | |||
| 13 | SUMMARY OF BENEFITS | ||||
| 14 | INPATIENT CARE | ||||
| 15 | 3 - Inpatient Hospital Care | In 2008 the amounts for each benefit period were: Days 1 - 60: $1024 deductible Days 61 - 90: $256 per day Days 91 - 150: $512 per lifetime reserve day These amounts will change for 2009. OR | In-Network | ||
| 16 | For Medicare-covered hospital stays: | ||||
| 17 | (includes Substance Abuse and Rehabilitation Services) | In 2009 the amounts for each benefit period are: Days 1 - 60: $___ deductible Days 61 - 90: $___ per day Days 91 - 150: $___ per lifetime reserve day | Days 1 - 7: $350 copay per day | ||
| 18 | Call 1-800-MEDICARE (1-800-633-4227) for information about lifetime reserve days. | Days 8 - 90: $0 copay per day | |||
| 19 | Lifetime reserve days can only be used once. | Plan covers 60 lifetime reserve days. Cost per lifetime reserve day:* | |||
| 20 | A "benefit period" starts the day you go into a hospital or skilled nursing facility. It ends when you go for 60 days in a row without hospital or skilled nursing care. If you go into the hospital after one benefit period has ended, a new benefit period begins. You must pay the inpatient hospital deductible for each benefit period. There is no limit to the number of benefit periods you can have. | Days 1 - 60: $0 copay per day | |||
| 21 | Plan covers 90 days each benefit period. | ||||
| 22 | Except in an emergency, your doctor must tell the plan that you are going to be admitted to the hospital. | ||||
| 23 | 4 - Inpatient Mental Health Care | Same deductible and copay as inpatient hospital care (see "Inpatient Hospital Care" above). | In-Network | ||
| 24 | For hospital stays: | ||||
| 25 | 190 day lifetime limit in a Psychiatric Hospital. | Days 1 - 7: $300 copay per day | |||
| 26 | Days 8 - 90: $0 copay per day | ||||
| 27 | Plan covers 60 lifetime reserve days. Cost per lifetime reserve day: | ||||
| 28 | Days 1 - 60: $0 copay per day | ||||
| 29 | You get up to 190 days in a Psychiatric Hospital in a lifetime. | ||||
| 30 | Except in an emergency, your doctor must tell the plan that you are going to be admitted to the hospital. | ||||
| 31 | 5 - Skilled Nursing Facility | In 2008 the amounts for each benefit period after at least a 3-day covered hospital stay were: Days 1 - 20: $0 per day Days 21 - 100: $128 per day These amounts will change for 2009. OR | General | ||
| 32 | Authorizaton rules may apply. | ||||
| 33 | (in a Medicare-certified skilled nursing facility) | In 2009 the amounts for each benefit period after at least a 3-day covered hospital stay are: Days 1 - 20: $___ per day Days 21 - 100: $___ per day | In-Network | ||
| 34 | For SNF stays: | ||||
| 35 | 100 days for each benefit period. | Days 1 - 10: $0 copay per day | |||
| 36 | A "benefit period" starts the day you go into a hospital or SNF. It ends when you go for 60 days in a row without hospital or skilled nursing care. If you go into the hospital after one benefit period has ended, a new benefit period begins. You must pay the inpatient hospital deductible for each benefit period. There is no limit to the number of benefit periods you can have. | Days 11 - 100: $100 copay per day | |||
| 37 | Plan covers up to 100 days each benefit period | ||||
| 38 | No prior hospital stay is required. | ||||
Sheet4 | |||||
THE COMPLETED BOOKLET LOOKS LIKE THE FOLLOWING IN WORD:
| Excel Workbook | |||||||
|---|---|---|---|---|---|---|---|
| A | B | C | D | E | |||
| 1 | BENEFIT | ORIGINAL MEDICARE | PLAN1 | PLAN2 | PLAN3 | ||
| 2 | IMPORTANT INFORMATION | ||||||
| 3 | 1 - Premium and Other Important Information | In 2008 the monthly Part B Premium was $96.40 and will change for 2009 and the yearly Part B deductible amount was $135 and will change for 2009. OR | General | General | General | ||
| 4 | $0 monthly plan premium in addition to your monthly Medicare Part B premium. | $0 monthly plan premium in addition to your monthly Medicare Part B premium. | $0 monthly plan premium in addition to your monthly Medicare Part B premium. | ||||
| 5 | In 2009 the monthly Part B Premium is $___ and the yearly Part B deductible amount is $___. | ||||||
| 6 | In-Network | In-Network | In-Network | ||||
| 7 | If a doctor or supplier does not accept assignment, their costs are often higher, which means you pay more. | $3,350 in-network out-of-pocket limit. | $2,500 in-network out-of-pocket limit. | $3,350 in-network out-of-pocket limit. | |||
| 8 | |||||||
| 9 | Not all plan services are covered under the out-of-pocket limit. Contact plan for a detailed list of non-covered services. | Not all plan services are covered under the out-of-pocket limit. Contact plan for a detailed list of non-covered services. | Not all plan services are covered under the out-of-pocket limit. Contact plan for a detailed list of non-covered services. | ||||
| 10 | 2 - Doctor and Hospital Choice | You may go to any doctor, specialist or hospital that accepts Medicare. | In-Network | In-Network | In-Network | ||
| 11 | (For more information, see Emergency - #15 and Urgently Needed Care - #16.) | Referral required for network hospitals and specialists (for certain benefits). | Referral required for network hospitals and specialists (for certain benefits). | No referral required for network doctors, specialists, and hospitals. | |||
| 12 | |||||||
| 13 | You may have to pay a separate copay for certain doctor office visits. | You may have to pay a separate copay for certain doctor office visits. | You may have to pay a separate copay for certain doctor office visits. | ||||
| 14 | SUMMARY OF BENEFITS | ||||||
| 15 | INPATIENT CARE | ||||||
| 16 | 3 - Inpatient Hospital Care | In 2008 the amounts for each benefit period were: Days 1 - 60: $1024 deductible Days 61 - 90: $256 per day Days 91 - 150: $512 per lifetime reserve day | In-Network | In-Network | In-Network | ||
| 17 | (includes Substance Abuse and Rehabilitation Services) | For Medicare-covered hospital stays: | For Medicare-covered hospital stays: | For Medicare-covered hospital stays: | |||
| 18 | 3 - Inpatient Hospital Care | These amounts will change for 2009. OR In 2009 the amounts for each benefit period are: Days 1 - 60: $___ deductible Days 61 - 90: $___ per day Days 91 - 150: $___ per lifetime reserve day | Days 1 - 10: $175 copay per day | Days 1 - 7: $75 copay per day | Days 1 - 7: $350 copay per day | ||
| 19 | (continued) | ||||||
| 20 | Call 1-800-MEDICARE (1-800-633-4227) for information about lifetime reserve days. | Days 11 - 90: $0 copay per day | Days 8 - 90: $0 copay per day | Days 8 - 90: $0 copay per day | |||
| 21 | |||||||
| 22 | Lifetime reserve days can only be used once. | Plan covers 60 lifetime reserve days. Cost per lifetime reserve day: | Plan covers 60 lifetime reserve days. Cost per lifetime reserve day: | Plan covers 60 lifetime reserve days. Cost per lifetime reserve day: | |||
| 23 | |||||||
| 24 | A "benefit period" starts the day you go into a hospital or skilled nursing facility. It ends when you go for 60 days in a row without hospital or skilled nursing care. If you go into the hospital after one benefit period has ended, a new benefit period begins. You must pay the inpatient hospital deductible for each benefit period. There is no limit to the number of benefit periods you can have.* | Days 1 - 60: $0 copay per day | Days 1 - 60: $0 copay per day | Days 1 - 60: $0 copay per day | |||
| 25 | Plan covers 90 days each benefit period. | Plan covers 90 days each benefit period. | Plan covers 90 days each benefit period. | ||||
| 26 | |||||||
| 27 | Except in an emergency, your doctor must tell the plan that you are going to be admitted to the hospital. | Except in an emergency, your doctor must tell the plan that you are going to be admitted to the hospital. | Except in an emergency, your doctor must tell the plan that you are going to be admitted to the hospital. | ||||
| 28 | 4 - Inpatient Mental Health Care | Same deductible and copay as inpatient hospital care (see "Inpatient Hospital Care" above). | In-Network | In-Network | In-Network | ||
| 29 | For hospital stays: | For hospital stays: | For hospital stays: | ||||
| 30 | 190 day lifetime limit in a Psychiatric Hospital. | ||||||
| 31 | Days 1 - 10: $175 copay per day | Days 1 - 7: $75 copay per day | Days 1 - 7: $300 copay per day | ||||
| 32 | |||||||
| 33 | Days 11 - 90: $0 copay per day | Days 8 - 90: $0 copay per day | Days 8 - 90: $0 copay per day | ||||
| 34 | |||||||
| 35 | Plan covers 60 lifetime reserve days. Cost per lifetime reserve day: | Plan covers 60 lifetime reserve days. Cost per lifetime reserve day: | Plan covers 60 lifetime reserve days. Cost per lifetime reserve day: | ||||
| 36 | *4 - Inpatient Mental Health Care | Days 1 - 60: $0 copay per day | Days 1 - 60: $0 copay per day | Days 1 - 60: $0 copay per day | |||
| 37 | (continued)* | ||||||
| 38 | You get up to 190 days in a Psychiatric Hospital in a lifetime. | You get up to 190 days in a Psychiatric Hospital in a lifetime. | You get up to 190 days in a Psychiatric Hospital in a lifetime. | ||||
| 39 | |||||||
| 40 | Except in an emergency, your doctor must tell the plan that you are going to be admitted to the hospital. | Except in an emergency, your doctor must tell the plan that you are going to be admitted to the hospital. | Except in an emergency, your doctor must tell the plan that you are going to be admitted to the hospital. | ||||
| 41 | 5 - Skilled Nursing Facility | In 2008 the amounts for each benefit period after at least a 3-day covered hospital stay were: Days 1 - 20: $0 per day Days 21 - 100: $128 per day These amounts will change for 2009. OR | General | General | General | ||
| 42 | (in a Medicare-certified skilled nursing facility) | Authorization rules may apply. | Authorization rules may apply. | Authorization rules may apply. | |||
| 43 | In 2009 the amounts for each benefit period after at least a 3-day covered hospital stay are: Days 1 - 20: $___ per day Days 21 - 100: $___ per day | In-Network | In-Network | In-Network | |||
| 44 | 100 days for each benefit period. | For SNF stays: | For SNF stays: | For SNF stays: | |||
| 45 | A "benefit period" starts the day you go into a hospital or SNF. It ends when you go for 60 days in a row without hospital or skilled nursing care. If you go into the hospital after one benefit period has ended, a new benefit period begins. You must pay the inpatient hospital deductible for each benefit period. There is no limit to the number of benefit periods you can have. | Days 1 - 10: $0 copay per day | Days 1 - 7: $0 copay per day | Days 1 - 10: $0 copay per day | |||
| 46 | Days 11 - 100: $100 copay per day | Days 8 - 100: $75 copay per day | Days 11 - 100: $100 copay per day | ||||
| 47 | |||||||
| 48 | Plan covers up to 100 days each benefit period | Plan covers up to 100 days each benefit period | Plan covers up to 100 days each benefit period | ||||
| 49 | No prior hospital stay is required | No prior hospital stay is required | |||||
| 50 | No prior hospital stay is required | ||||||
| 51 | |||||||
| 52 | |||||||
| 53 | |||||||
| 54 | |||||||
Sheet5 | |||||||
