Explore BrainMass

Explore BrainMass

    Excel spreadsheet to format Jane Doe's medical expenses

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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.

    © BrainMass Inc. brainmass.com June 4, 2020, 1:02 am ad1c9bdddf
    https://brainmass.com/statistics/descriptive-statistics/excel-spreadsheet-format-jane-does-medical-expenses-375148

    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

    ADVERTISEMENT