Share
Explore BrainMass

Excel spreadsheet to format Jane Doe's medical expenses

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.

Attachments

Solution Preview

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 ...

Solution Summary

Shows how to create an excel spreadsheet for recording medical expenses in a PI case.

$2.19