{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Template","2021 Budget","Sheet1"],"read":"whole","date_system":"1900"}

{"sheet":"Template","index":0,"n_rows":44,"n_cols":15,"rows_kept":44}
[{"$nulls":3},"McGregor Medical Center Neurology Department Expense Report "]
[{"$nulls":3},"Date"]
[]
[{"$nulls":9},"Type of Expenses "]
["Date","Payee","Ch.No","Total amount ","Rent ","Utilities ","Postage ","Lab/X-ray","Medical","Office supplies ","Wages","Insurance ","Taxes ","Travel  ","MISC. "]
["2023-01-01","LaJolla Property Management ",101,{"v":1700,"d":"$1,700.00"},1700]
["2023-01-01","Anderson Janitoria",102,{"v":850,"d":"$850.00"},{"$nulls":10},850]
["2023-01-01","Office Depot ",103,{"v":37.89,"d":"$37.89"},{"$nulls":5},{"v":37.89,"d":"$37.89"}]
["2023-01-04","Pacific Telephone ",104,{"v":384.57,"d":"$384.57"},null,{"v":384.57,"d":"$384.57"}]
["2023-01-07","Pacific Gas Company ",105,{"v":683.84,"d":"$683.84"},null,{"v":683.84,"d":"$683.84"}]
["2023-01-10","Cash for stamps at the post office",106,{"v":32,"d":"$32.00"},null,null,{"v":32,"d":"$32.00"}]
["2023-02-01","Uni Lab ",107,{"v":55,"d":"$55.00"},{"$nulls":3},{"v":55,"d":"$55.00"}]
["2023-02-04","Harris Medical Supply ",108,{"v":75,"d":"$75.00"},{"$nulls":4},{"v":75,"d":"$75.00"}]
["2023-02-05","MediQuik X-Ray",109,{"v":32.5,"d":"$32.50"},{"$nulls":3},{"v":32.5,"d":"$32.50"}]
["2023-02-08","Staples Office Suppl",110,{"v":68.24,"d":"$68.24"},{"$nulls":5},{"v":68.24,"d":"$68.24"}]
["2023-02-12","City Laundry ",111,{"v":125,"d":"$125.00"},{"$nulls":10},{"v":125,"d":"$125.00"}]
["2023-03-01","Toni Guzzi (payroll)",112,{"v":176.08,"d":"$176.08"},{"$nulls":6},{"v":176.08,"d":"$176.08"}]
["2023-03-04","Terri Smart (payroll)",113,{"v":289.84,"d":"$289.84"},{"$nulls":6},{"v":289.84,"d":"$289.84"}]
["2023-03-07","Janet Garcia (payroll)",114,{"v":125,"d":"$125.00"},{"$nulls":6},{"v":125,"d":"$125.00"}]
["2023-03-12","James Smith (payroll),",115,{"v":278.76,"d":"$278.76"},{"$nulls":6},{"v":278.76,"d":"$278.76"}]
["2023-03-15"," Toni Guzzi ",116,{"v":12.5,"d":"$12.50"},{"$nulls":9},{"v":12.5,"d":"$12.50"}]
["2023-03-20","Post Office ",117,{"v":64,"d":"$64.00"},null,null,{"v":64,"d":"$64.00"}]
["2023-03-21","MediQuik X-Ray",118,{"v":35.87,"d":"$35.87"},{"$nulls":3},{"v":35.87,"d":"$35.87"}]
["2023-03-25","World Wide Insurance",119,{"v":189,"d":"$189.00"},{"$nulls":7},{"v":189,"d":"$189.00"}]
["2023-03-30","IRS ",120,{"v":537,"d":"$537.00"},{"$nulls":8},{"v":537,"d":"$537.00"}]
[]
[]
[]
[]
[null,null,"Total",5751.59]
{"$rows_empty":10}
[null,{"v":4544.04,"d":"4,544.04"}]
[null,1263.42]
[null,160.87]
[null,278.78]

{"sheet":"2021 Budget","index":1,"n_rows":29,"n_cols":5,"rows_kept":29,"merged":[[2,0,4,7]]}
["Westshore University Hospital Cardiology Department  -  2021 Budget Development"]
[]
["After looking at the total revenue and the total income of the cardiology department they are over spending which means they need to stick to a bueget so that they can pay for allt eht hings they owe money to. They also need to make sure that any purchases will benefit the company and will help them make money in the end. i think this is a good starting point for them and it will help them get on the right track. I think if things dont change they may have to make somestaffing cuts to make sure they have enough money. "]
[]
[]
[]
["BUDGET"]
[]
[]
[null,null,"Revenue"]
[null,null,"Net patient service revenue ",null,{"v":20000000,"d":"20,000,000"}]
[null,null,"Total operating revenue ",null,{"v":2000000,"d":"2,000,000"}]
[]
[]
[]
[null,"Operating Expenses"]
[null,"Costs of Sales",null,{"v":600000,"d":"600,000"}]
[null,"Medical/surgical services ",null,{"v":860000,"d":"860,000"}]
[null,"In office procedures ",null,{"v":80000,"d":"80,000"}]
[null,"Professional Services ",null,{"v":220000,"d":"220,000"}]
[null,"Support Services ",null,{"v":176000,"d":"176,000"}]
[null,"Total Costs of Sales",null,{"v":240000,"d":"240,000"}]
[]
[null,"Net Nonoperating Gains (Losses)",null,{"v":5000,"d":"5,000"}]
[]
[]
[null,"Increase (Decrease) in Unrestricted Fund Balance ",null,{"v":120000,"d":"120,000"}]
[]
[null,"End of Year Unrestricted Fund Balance",null,{"v":418000,"d":"418,000"}]

{"sheet":"Sheet1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}