{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Medical Bill Tracker"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Medical Bill Tracker","index":0,"n_rows":55,"n_cols":10,"rows_kept":55}
["Medical Bill Tracker"]
[]
[null,"Total billed",{"$f":"E55","v":{"v":4000,"d":"$4,000.00"}},"Total out-of-pocket paid",{"$f":"H55","v":{"v":1000,"d":"$1,000.00"}}]
[null,"Total paid by insurance",{"$f":"F55+G55","v":{"v":1000,"d":"$1,000.00"}},"Total due",{"$f":"J55","v":{"v":2000,"d":"$2,000.00"}}]
[]
[]
["Date of Bill","Billing Party\nName","Statement Number","Description\n of Services","Total Amount Billed","Insurance #1 Amount Paid","Insurance #2 Amount Paid","Out-of-Pocket\n Expenses Paid","Check Number","Amount Due"]
["2004-03-03",{"$nulls":3},{"v":4000,"d":"$4,000.00"},{"v":500,"d":"$500.00"},{"v":500,"d":"$500.00"},{"v":1000,"d":"$1,000.00"},null,{"$f":"E8-F8-G8-H8","v":{"v":2000,"d":"$2,000.00"}}]
[{"$nulls":9},{"$f":"E9-F9-G9-H9","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":9},{"v":0,"d":"$0.00"}]
[{"$nulls":9},{"v":0,"d":"$0.00"}]
[{"$nulls":9},{"v":0,"d":"$0.00"}]
[{"$nulls":9},{"v":0,"d":"$0.00"}]
[{"$nulls":9},{"v":0,"d":"$0.00"}]
[{"$nulls":9},{"v":0,"d":"$0.00"}]
[{"$nulls":9},{"v":0,"d":"$0.00"}]
[{"$nulls":9},{"v":0,"d":"$0.00"}]
[{"$nulls":9},{"v":0,"d":"$0.00"}]
[{"$nulls":9},{"v":0,"d":"$0.00"}]
[{"$nulls":9},{"v":0,"d":"$0.00"}]
[{"$nulls":9},{"v":0,"d":"$0.00"}]
[{"$nulls":9},{"v":0,"d":"$0.00"}]
[{"$nulls":9},{"v":0,"d":"$0.00"}]
[{"$nulls":9},{"v":0,"d":"$0.00"}]
[{"$nulls":9},{"v":0,"d":"$0.00"}]
[{"$nulls":9},{"v":0,"d":"$0.00"}]
[{"$nulls":9},{"v":0,"d":"$0.00"}]
[{"$nulls":9},{"v":0,"d":"$0.00"}]
[{"$nulls":9},{"v":0,"d":"$0.00"}]
[{"$nulls":9},{"v":0,"d":"$0.00"}]
[{"$nulls":9},{"v":0,"d":"$0.00"}]
[{"$nulls":9},{"v":0,"d":"$0.00"}]
[{"$nulls":9},{"v":0,"d":"$0.00"}]
[{"$nulls":9},{"v":0,"d":"$0.00"}]
[{"$nulls":9},{"v":0,"d":"$0.00"}]
[{"$nulls":9},{"v":0,"d":"$0.00"}]
[{"$nulls":9},{"v":0,"d":"$0.00"}]
[{"$nulls":9},{"v":0,"d":"$0.00"}]
[{"$nulls":9},{"v":0,"d":"$0.00"}]
[{"$nulls":9},{"v":0,"d":"$0.00"}]
[{"$nulls":9},{"v":0,"d":"$0.00"}]
[{"$nulls":9},{"v":0,"d":"$0.00"}]
[{"$nulls":9},{"v":0,"d":"$0.00"}]
[{"$nulls":9},{"v":0,"d":"$0.00"}]
[{"$nulls":9},{"v":0,"d":"$0.00"}]
[{"$nulls":9},{"v":0,"d":"$0.00"}]
[{"$nulls":9},{"v":0,"d":"$0.00"}]
[{"$nulls":9},{"v":0,"d":"$0.00"}]
[{"$nulls":9},{"v":0,"d":"$0.00"}]
[{"$nulls":9},{"v":0,"d":"$0.00"}]
[{"$nulls":9},{"v":0,"d":"$0.00"}]
[{"$nulls":9},{"v":0,"d":"$0.00"}]
[{"$nulls":9},{"v":0,"d":"$0.00"}]
[{"$nulls":9},{"v":0,"d":"$0.00"}]
[{"$nulls":3},"Totals",{"$f":"SUM(E8:E54)","v":{"v":4000,"d":"$4,000.00"}},{"$f":"SUM(F8:F54)","v":{"v":500,"d":"$500.00"}},{"$f":"SUM(G8:G54)","v":{"v":500,"d":"$500.00"}},{"$f":"SUM(H8:H54)","v":{"v":1000,"d":"$1,000.00"}},null,{"$f":"SUM(J8:J54)","v":{"v":2000,"d":"$2,000.00"}}]