|
Association of
Ameritech/SBC Retirees
Association of Ameritech/SBC Retirees
Blue Bulletin - Vol. 1, No. 9 Posted
1/3/2007
If you have trouble printing out this bulletin, check your
browser page margin settings. You probably have page margins set too large
which is cutting off the page. Try this to correct the problem.
Open Internet Explorer, on the top line menu go to: "File" then
"Page Setup", Be sure that page margins are set as follows:
"Top, Left, Right to 0.25", "Bottom to 0.5" These margin settings
should work for most inkjet and laser printers.
|
(December 20, 2006)
Proudly
representing retirees from the new AT&T Midwest Region, SBC Midwest
Region,
Ameritech, as well as the five Bell Companies in
Illinois, Indiana, Michigan, Ohio, and Wisconsin
Explanation for the AASBCR
Medical
and Insurance
Costs
for 2007 Spreadsheet
The 2006 Medical Insurance survey
showed some shocking results. Many of us did not fully participate
because we couldn’t recreate our medical costs for the year. We did
not keep, or could not find ALL our medical records since January.
To alleviate this problem for 2007,
we have created an Excel spreadsheet to record medical costs. It
should be self-explanatory. So we will explain it.
The sample data
presented in this spreadsheet is purely for explanatory purposes.
It is not intended to make sense or to balance to anything in the
real world. It is an example of various costs (with and without
Medicare) that may be incurred in a year. It is by NO means
inclusive!
TO USE THIS SPREADSHEET TO TRACK YOU PERSONAL
MEDICAL EXPENSES YOU MUST
FIRST DOWNLOAD THE SPREADSHEET TO YOUR PC AND EDIT IT LOCALLY ON
YOUR PC!
Once downloaded, to open and use this spreadsheet you will need to have Microsoft
Excel installed on your PC.
TO DOWNLOAD THE
EXCEL SPREADSHEET TO YOUR COMPUTER, CLICK ON THIS LINK, THEN CLICK
ON "SAVE"
Following is an example of the dialog box you
will see when clicking the above link
First, all cells that are shaded are
automatically calculated by the spreadsheet. These calculations go through
the 32nd row.
The top data line/Row is the total
for each column. (Except the Deductible – there it is the starting
point.) They are currently set to accumulate totals to the 32nd row.
|
Col #
|
Column.
Name
|
Column
Description
|
|
1
|
Date
|
Date service rendered
|
|
2
|
Patient
|
Self, Spouse, Other dependent
|
|
3
|
Service
Provider
|
Dr, X-ray, ER, Specialist, Caremark, etc.
|
|
4
|
Provider
Charges
|
What the Service Provider billed.
|
|
5
|
Authorized Charges
|
What our insurance pays
|
|
6
|
Adjustment
|
The difference between the two. (Calculated)
|
|
7
|
Medicare
Payment
|
How much Medicare pays (if applicable).
|
|
8
|
AT&T
Insurance Payment
|
How much our insurance pays.
|
|
9
|
Patient
Payment
|
Whatever is left – our out-of-pocket. (Calculated)
|
|
10
|
Deductible
|
Subtract what we paid from the previous deductible (When it
gets down to zero, we will have paid our deductible.)
|
|
11
|
Vision
and Dental
|
A place to keep track of these, although They do not reduce
the deductible.
|
For “tech support”, please send
an e-mail to
newsletter@aasbcr.org.
Please include your phone number for quicker response.
AASBCR, a non-profit organization, was formed in 2002 to represent
Ameritech retiree issues to SBC, renamed AT&T as part of the recent
merger of SBC and AT&T. For more information on the organization
please check the web site at
www.aasbcr.org.
Please share this newsletter by e-mail with your Retiree and
Near-Retiree friends. Send
them to
www.aasbcr.org
to join. We need volunteers to help carry out our work.
|
|