See attached file.
I need help calculating medical expenses that have been paid for Jane Doe (the plaintiff in a personal injury case). Using Excel.
I have attached medical invoices for 5 companies that have paid expenses for Jane Doe.
Jefferson has 2-pages of expenses paid
Shannon has 1-page of expenses paid
Bradley Bartholomew has 2-pages of expenses paid
Advance Medical is 1-page(we are only using the total of $5,588
and the date range for those is expenses are 02/14/09-07/29/09)
Travelers has 1-page of expenses paid
Instructions are on the first page of attachment.
See the attached file. Formatting here may not be correct.
Date Procedure/ Code Plaintiff's Name Healthcare Provider Amount for each visit
4/8/2009 99205 Jane Doe Jefferson Orthopedic CL $230.00
4/8/2009 99080 Jane Doe Jefferson Orthopedic CL $85.00
4/8/2009 73030-RT Jane Doe Jefferson Orthopedic CL $90.00
4/8/2009 72040 Jane Doe Jefferson Orthopedic CL $102.00
4/17/2009 99214 Jane Doe Jefferson Orthopedic CL $125.00
Jefferson Orthopedic CL Total $632.00
7/26/2010 99203 Jane Doe Shannon Orthopedic CL $175.00
7/26/2010 73030 Jane Doe Shannon Orthopedic CL $133.00
8/20/2010 99213 Jane ...
Shows how to create an excel spreadsheet for recording medical expenses in a PI case.