{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Cover","BS Assets","BS Liab","Income Statement","Statistics Summary","Definitions","Explanation Sheet","Reconciliation"],"not_rendered":{"charts":0,"images":12,"macros":1,"external_links":0,"defined_names":6,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cover","index":0,"n_rows":49,"n_cols":23,"rows_kept":49,"cut":false,"hidden":false,"merged":[[4,6,4,22],[5,6,5,22],[6,6,6,22],[7,6,7,13],[7,14,7,18],[7,19,7,20],[7,21,7,22],[11,6,11,22],[12,6,12,22],[13,6,13,22],[14,6,14,22],[8,6,8,13],[8,14,8,18],[8,19,8,20],[8,21,8,22],[33,2,33,22],[17,6,17,22],[18,6,18,22],[19,6,19,22],[20,6,20,22]]}
[{"$f":"COLUMN()","v":1},{"$f":"COLUMN()","v":2},{"$f":"COLUMN()","v":3},{"$f":"COLUMN()","v":4},{"$f":"COLUMN()","v":5},{"$f":"COLUMN()","v":6},{"$f":"COLUMN()","v":7},{"$f":"COLUMN()","v":8},{"$f":"COLUMN()","v":9},{"$f":"COLUMN()","v":10},{"$f":"COLUMN()","v":11},{"$f":"COLUMN()","v":12},{"$f":"COLUMN()","v":13},{"$f":"COLUMN()","v":14},{"$f":"COLUMN()","v":15},{"$f":"COLUMN()","v":16},{"$f":"COLUMN()","v":17},{"$f":"COLUMN()","v":18},{"$f":"COLUMN()","v":19},{"$f":"COLUMN()","v":20},{"$f":"COLUMN()","v":21},{"$f":"COLUMN()","v":22},{"$f":"COLUMN()","v":23}]
[" ","IAAF Report"]
[]
[null,"I. Facility Information"]
[null,null,null,null,null,"Organization Name "]
[null,null,null,null,null,"Medicaid Participant # "]
[null,null,null,null,null,"Operating Certificate # "]
[null,null,null,null,null,null,"Address",null,null,null,null,null,null,null,"City",null,null,null,null,"State",null,"Zip"]
[null,null,null,null,null,"Address ",null,null,null,null,null,null,null,null,null,null,null,null,null,"NY"]
[]
[null,"II.1. Primary Contact Information"]
[null,null,null,null,null,"Contact Person "]
[null,null,null,null,null,"Title "]
[null,null,null,null,null,"Contact Phone "]
[null,null,null,null,null,"Contact Email "]
[]
[null,"II.2. Secondary Contact Information "]
[null,null,null,null,null,"Contact Person "]
[null,null,null,null,null,"Title "]
[null,null,null,null,null,"Contact Phone "]
[null,null,null,null,null,"Contact Email "]
[]
[null,"III. Table of Contents"]
[null,"Content",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tab Name"]
[null,"Statement of Financial Position (ASSETS)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BS Assets"]
[null,"Statement of Financial Position (LIABILITIES AND EQUITY)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BS Liab"]
[null,"Statement of Operations (P&L)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Income Statement"]
[null,"Statement of Statistics Inpatient and Outpatient",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FS Summary"]
["D","Definitions of Terms",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Definitions"]
[null,"Explanation Sheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Explanation Sheet"]
[]
[]
["C","IV. Certified (Click the button below once you agree.)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34]
[null,null,35]
[null,"02 Certify the accuracy of the information for 01/31/2014"]
[null,"03 Certify the accuracy of the information for 02/28/2014"]
[null,"04 Certify the accuracy of the information for 03/31/2014"]
[null,"05 Certify the accuracy of the information for 04/30/2014"]
[null,"06 Certify the accuracy of the information for 05/31/2014"]
[null,"07 Certify the accuracy of the information for 06/30/2014"]
[null,"08 Certify the accuracy of the information for 07/31/2014"]
[null,"09 Certify the accuracy of the information for 08/31/2014"]
[null,"10 Certify the accuracy of the information for 09/30/2014"]
[null,"11 Certify the accuracy of the information for 10/31/2014"]
[null,"12 Certify the accuracy of the information for 11/30/2014"]
[null,"13 Certify the accuracy of the information for 12/31/2014"]
[null,"14 Certify the accuracy of the information for 01/31/2015"]
[null,"15 Certify the accuracy of the information for 02/28/2015"]
[null,"16 Certify the accuracy of the information for 03/31/2015"]

{"sheet":"BS Assets","index":1,"n_rows":30,"n_cols":40,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["←","Statement of Financial Position (ASSETS)",null,{"$f":"COLUMN()","v":4},{"$f":"COLUMN()","v":5},{"$f":"COLUMN()","v":6},{"$f":"COLUMN()","v":7},{"$f":"COLUMN()","v":8},{"$f":"COLUMN()","v":9},{"$f":"COLUMN()","v":10},{"$f":"COLUMN()","v":11},{"$f":"COLUMN()","v":12},{"$f":"COLUMN()","v":13},{"$f":"COLUMN()","v":14},{"$f":"COLUMN()","v":15},{"$f":"COLUMN()","v":16},{"$f":"COLUMN()","v":17},{"$f":"COLUMN()","v":18},{"$f":"COLUMN()","v":19},{"$f":"COLUMN()","v":20},{"$f":"COLUMN()","v":21},{"$f":"COLUMN()","v":22},{"$f":"COLUMN()","v":23},{"$f":"COLUMN()","v":24},{"$f":"COLUMN()","v":25},{"$f":"COLUMN()","v":26},{"$f":"COLUMN()","v":27},{"$f":"COLUMN()","v":28},{"$f":"COLUMN()","v":29},{"$f":"COLUMN()","v":30},{"$f":"COLUMN()","v":31},{"$f":"COLUMN()","v":32},{"$f":"COLUMN()","v":33},{"$f":"COLUMN()","v":34},{"$f":"COLUMN()","v":35},{"$f":"COLUMN()","v":36},{"$f":"COLUMN()","v":37},{"$f":"COLUMN()","v":38},{"$f":"COLUMN()","v":39},{"$f":"COLUMN()","v":40}]
[{"$f":"IF(Cover!$G$5=\"\",\"\",Cover!$G$5)","v":""},null,null,null,null,"2014-01-31","2014-02-28","2014-03-31","2014-04-30","2014-05-31","2014-06-30","2014-06-30",{"$f":"+L2","v":"2014-06-30"},"2014-07-31","2014-07-31",{"$f":"+O2","v":"2014-07-31"},"2014-08-31","2014-08-31",{"$f":"+R2","v":"2014-08-31"},"2014-09-30","2014-09-30",{"$f":"+U2","v":"2014-09-30"},"2014-10-31","2014-10-31",{"$f":"+X2","v":"2014-10-31"},"2014-11-30","2014-11-30",{"$f":"+AA2","v":"2014-11-30"},"2014-12-31","2014-12-31",{"$f":"+AD2","v":"2014-12-31"},"2015-01-31","2015-01-31",{"$f":"+AG2","v":"2015-01-31"},"2015-02-28","2015-02-28",{"$f":"+AJ2","v":"2015-02-28"},"2015-03-31","2015-03-31",{"$f":"+AM2","v":"2015-03-31"}]
["ASSETS",null,null,"Definition Help",null,"Actual","Actual","Actual","Actual","Actual","Projected","Actual","Difference","Projected","Actual","Difference","Projected","Actual","Difference","Projected","Actual","Difference","Projected","Actual","Difference","Projected","Actual","Difference","Projected","Actual","Difference","Projected","Actual","Difference","Projected","Actual","Difference","Projected","Actual","Difference"]
["Current Assets"]
[null,"Cash and cash equivalents",null,null,null,null,null,null,null,null,null,null,{"$f":"+L5-K5","v":0},null,null,{"$f":"+O5-N5","v":0},null,null,{"$f":"+R5-Q5","v":0},null,null,{"$f":"+U5-T5","v":0},null,null,{"$f":"+X5-W5","v":0},null,null,{"$f":"+AA5-Z5","v":0},null,null,{"$f":"+AD5-AC5","v":0},null,null,{"$f":"+AG5-AF5","v":0},null,null,{"$f":"+AJ5-AI5","v":0},null,null,{"$f":"+AM5-AL5","v":0}]
[null,"Malpractice/Savings Fund",null,null,null,null,null,null,null,null,null,null,{"$f":"+L6-K6","v":0},null,null,{"$f":"+O6-N6","v":0},null,null,0,null,null,{"$f":"+U6-T6","v":0},null,null,{"$f":"+X6-W6","v":0},null,null,{"$f":"+AA6-Z6","v":0},null,null,{"$f":"+AD6-AC6","v":0},null,null,{"$f":"+AG6-AF6","v":0},null,null,{"$f":"+AJ6-AI6","v":0},null,null,{"$f":"+AM6-AL6","v":0}]
[null,"Accounts receivable",null,null,null,null,null,null,null,null,null,null,{"$f":"+L7-K7","v":0},null,null,{"$f":"+O7-N7","v":0},null,null,0,null,null,{"$f":"+U7-T7","v":0},null,null,{"$f":"+X7-W7","v":0},null,null,{"$f":"+AA7-Z7","v":0},null,null,{"$f":"+AD7-AC7","v":0},null,null,{"$f":"+AG7-AF7","v":0},null,null,{"$f":"+AJ7-AI7","v":0},null,null,{"$f":"+AM7-AL7","v":0}]
[null,"Less Allowances (Negative)",null,null,null,null,null,null,null,null,null,null,{"$f":"+L8-K8","v":0},null,null,{"$f":"+O8-N8","v":0},null,null,0,null,null,{"$f":"+U8-T8","v":0},null,null,{"$f":"+X8-W8","v":0},null,null,{"$f":"+AA8-Z8","v":0},null,null,{"$f":"+AD8-AC8","v":0},null,null,{"$f":"+AG8-AF8","v":0},null,null,{"$f":"+AJ8-AI8","v":0},null,null,{"$f":"+AM8-AL8","v":0}]
[null,"Net accounts receivable",null,null,null,{"$f":"+F7+F8","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Grants & other receivable",null,null,null,null,null,null,null,null,null,null,{"$f":"+L10-K10","v":0},null,null,{"$f":"+O10-N10","v":0},null,null,0,null,null,{"$f":"+U10-T10","v":0},null,null,{"$f":"+X10-W10","v":0},null,null,{"$f":"+AA10-Z10","v":0},null,null,{"$f":"+AD10-AC10","v":0},null,null,{"$f":"+AG10-AF10","v":0},null,null,{"$f":"+AJ10-AI10","v":0},null,null,{"$f":"+AM10-AL10","v":0}]
[null,"Inventories",null,null,null,null,null,null,null,null,null,null,{"$f":"+L11-K11","v":0},null,null,{"$f":"+O11-N11","v":0},null,null,{"$f":"+R11-Q11","v":0},null,null,{"$f":"+U11-T11","v":0},null,null,{"$f":"+X11-W11","v":0},null,null,{"$f":"+AA11-Z11","v":0},null,null,{"$f":"+AD11-AC11","v":0},null,null,{"$f":"+AG11-AF11","v":0},null,null,{"$f":"+AJ11-AI11","v":0},null,null,{"$f":"+AM11-AL11","v":0}]
[null,"Prepaid Expenses ",null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,"Other current assets ",null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,"Assets limited as to use-current portion",null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,"Total current assets",null,{"$f":"SUM(F5:F14)-F7-F8","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Fixed (Long-Term) Assets"]
[null,"Assets limited as to use"]
[null,null,"Marketable securities under bond indenture",null,null,null,null,null,null,null,null,null,{"$f":"+L18-K18","v":0},null,null,{"$f":"+O18-N18","v":0},null,null,{"$f":"+R18-Q18","v":0},null,null,{"$f":"+U18-T18","v":0},null,null,{"$f":"+X18-W18","v":0},null,null,{"$f":"+AA18-Z18","v":0},null,null,{"$f":"+AD18-AC18","v":0},null,null,{"$f":"+AG18-AF18","v":0},null,null,{"$f":"+AJ18-AI18","v":0},null,null,{"$f":"+AM18-AL18","v":0}]
[null,null,"Self Insured malpractice fund",null,null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,"Board-designated investments",null,null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,"Total Assets Limited as to use",null,null,null,{"$f":"+SUM(F18:F20)","v":0},{"$f":"+SUM(G18:G20)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Less assets limited as to use-current portion",null,null,null,{"$f":"+F14","v":0},0,0,0,0,{"$f":"+K14","v":0},{"$f":"+L14","v":0},{"$f":"+L22-K22","v":0},{"$f":"+N14","v":0},{"$f":"+O14","v":0},{"$f":"+O22-N22","v":0},{"$f":"+Q14","v":0},{"$f":"+R14","v":0},{"$f":"+R22-Q22","v":0},{"$f":"+T14","v":0},{"$f":"+U14","v":0},{"$f":"+U22-T22","v":0},{"$f":"+W14","v":0},{"$f":"+X14","v":0},{"$f":"+X22-W22","v":0},{"$f":"+Z14","v":0},{"$f":"+AA14","v":0},{"$f":"+AA22-Z22","v":0},{"$f":"+AC14","v":0},{"$f":"+AD14","v":0},{"$f":"+AD22-AC22","v":0},{"$f":"+AF14","v":0},{"$f":"+AG14","v":0},{"$f":"+AG22-AF22","v":0},{"$f":"+AI14","v":0},{"$f":"+AJ14","v":0},{"$f":"+AJ22-AI22","v":0},{"$f":"+AL14","v":0},{"$f":"+AM14","v":0},{"$f":"+AM22-AL22","v":0}]
[null,"Asset Limited to use noncurrent portion",null,null,null,{"$f":"+F21-F22","v":0},{"$f":"+G21-G22","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Total fixed assets",null,{"$f":"+SUM(F18:F20)-F22","v":0},0,0,0,0,0,0,0,{"$f":"+SUM(N18:N20)-N22","v":0},{"$f":"+SUM(O18:O20)-O22","v":0},0,{"$f":"+SUM(Q18:Q20)-Q22","v":0},{"$f":"+SUM(R18:R20)-R22","v":0},0,{"$f":"+SUM(T18:T20)-T22","v":0},{"$f":"+SUM(U18:U20)-U22","v":0},0,{"$f":"+SUM(W18:W20)-W22","v":0},{"$f":"+SUM(X18:X20)-X22","v":0},0,{"$f":"+SUM(Z18:Z20)-Z22","v":0},{"$f":"+SUM(AA18:AA20)-AA22","v":0},0,{"$f":"+SUM(AC18:AC20)-AC22","v":0},{"$f":"+SUM(AD18:AD20)-AD22","v":0},0,{"$f":"+SUM(AF18:AF20)-AF22","v":0},{"$f":"+SUM(AG18:AG20)-AG22","v":0},0,{"$f":"+SUM(AI18:AI20)-AI22","v":0},{"$f":"+SUM(AJ18:AJ20)-AJ22","v":0},0,{"$f":"+SUM(AL18:AL20)-AL22","v":0},{"$f":"+SUM(AM18:AM20)-AM22","v":0},0]
["Other Assets"]
[null,"Deferred financing costs",null,null,null,null,null,null,null,null,null,null,{"$f":"+L26-K26","v":0},null,null,{"$f":"+O26-N26","v":0},null,null,{"$f":"+R26-Q26","v":0},null,null,{"$f":"+U26-T26","v":0},null,null,{"$f":"+X26-W26","v":0},null,null,{"$f":"+AA26-Z26","v":0},null,null,{"$f":"+AD26-AC26","v":0},null,null,{"$f":"+AG26-AF26","v":0},null,null,{"$f":"+AJ26-AI26","v":0},null,null,{"$f":"+AM26-AL26","v":0}]
[null,"Property, buildings and equipment-net",null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,"Other long term assets",null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,"Total other Assets",null,{"$f":"+SUM(F26:F28)","v":0},{"$f":"+SUM(G26:G28)","v":0},{"$f":"+SUM(H26:H28)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Assets",null,null,null,null,{"$f":"+F15+F24+F29","v":0},0,0,0,0,{"$f":"+K15+K24+K29","v":0},{"$f":"+L15+L24+L29","v":0},0,{"$f":"+N15+N24+N29","v":0},{"$f":"+O15+O24+O29","v":0},0,{"$f":"+Q15+Q24+Q29","v":0},{"$f":"+R15+R24+R29","v":0},0,{"$f":"+T15+T24+T29","v":0},{"$f":"+U15+U24+U29","v":0},0,{"$f":"+W15+W24+W29","v":0},{"$f":"+X15+X24+X29","v":0},0,{"$f":"+Z15+Z24+Z29","v":0},{"$f":"+AA15+AA24+AA29","v":0},0,{"$f":"+AC15+AC24+AC29","v":0},{"$f":"+AD15+AD24+AD29","v":0},0,{"$f":"+AF15+AF24+AF29","v":0},{"$f":"+AG15+AG24+AG29","v":0},0,{"$f":"+AI15+AI24+AI29","v":0},{"$f":"+AJ15+AJ24+AJ29","v":0},0,{"$f":"+AL15+AL24+AL29","v":0},{"$f":"+AM15+AM24+AM29","v":0},0]

{"sheet":"BS Liab","index":2,"n_rows":29,"n_cols":40,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["←","Statement of Financial Position (LIABILITIES AND EQUITY)",null,{"$f":"COLUMN()","v":4},{"$f":"COLUMN()","v":5},{"$f":"COLUMN()","v":6},{"$f":"COLUMN()","v":7},{"$f":"COLUMN()","v":8},{"$f":"COLUMN()","v":9},{"$f":"COLUMN()","v":10},{"$f":"COLUMN()","v":11},{"$f":"COLUMN()","v":12},{"$f":"COLUMN()","v":13},{"$f":"COLUMN()","v":14},{"$f":"COLUMN()","v":15},{"$f":"COLUMN()","v":16},{"$f":"COLUMN()","v":17},{"$f":"COLUMN()","v":18},{"$f":"COLUMN()","v":19},{"$f":"COLUMN()","v":20},{"$f":"COLUMN()","v":21},{"$f":"COLUMN()","v":22},{"$f":"COLUMN()","v":23},{"$f":"COLUMN()","v":24},{"$f":"COLUMN()","v":25},{"$f":"COLUMN()","v":26},{"$f":"COLUMN()","v":27},{"$f":"COLUMN()","v":28},{"$f":"COLUMN()","v":29},{"$f":"COLUMN()","v":30},{"$f":"COLUMN()","v":31},{"$f":"COLUMN()","v":32},{"$f":"COLUMN()","v":33},{"$f":"COLUMN()","v":34},{"$f":"COLUMN()","v":35},{"$f":"COLUMN()","v":36},{"$f":"COLUMN()","v":37},{"$f":"COLUMN()","v":38},{"$f":"COLUMN()","v":39},{"$f":"COLUMN()","v":40}]
[{"$f":"IF(Cover!$G$5=\"\",\"\",Cover!$G$5)","v":""},null,null,null,null,"2014-01-31","2014-02-28","2014-03-31","2014-04-30","2014-05-31","2014-06-30","2014-06-30",{"$f":"+L2","v":"2014-06-30"},"2014-07-31","2014-07-31",{"$f":"+O2","v":"2014-07-31"},"2014-08-31","2014-08-31",{"$f":"+R2","v":"2014-08-31"},"2014-09-30","2014-09-30",{"$f":"+U2","v":"2014-09-30"},"2014-10-31","2014-10-31",{"$f":"+X2","v":"2014-10-31"},"2014-11-30","2014-11-30",{"$f":"+AA2","v":"2014-11-30"},"2014-12-31","2014-12-31",{"$f":"+AD2","v":"2014-12-31"},"2015-01-31","2015-01-31",{"$f":"+AG2","v":"2015-01-31"},"2015-02-28","2015-02-28",{"$f":"+AJ2","v":"2015-02-28"},"2015-03-31","2015-03-31",{"$f":"+AM2","v":"2015-03-31"}]
["LIABILITIES AND EQUITIES",null,null,"Definition Help",null,"Actual","Actual","Actual","Actual","Actual","Projected","Actual","Difference","Projected","Actual","Difference","Projected","Actual","Difference","Projected","Actual","Difference","Projected","Actual","Difference","Projected","Actual","Difference","Projected","Actual","Difference","Projected","Actual","Difference","Projected","Actual","Difference","Projected","Actual","Difference"]
["Current Liabilities"]
[null,"Account Payable",null,null,null,null,null,null,null,null,null,null,{"$f":"+L5-K5","v":0},null,null,{"$f":"+O5-N5","v":0},null,null,{"$f":"+R5-Q5","v":0},null,null,{"$f":"+U5-T5","v":0},null,null,{"$f":"+X5-W5","v":0},null,null,{"$f":"+AA5-Z5","v":0},null,null,{"$f":"+AD5-AC5","v":0},null,null,{"$f":"+AG5-AF5","v":0},null,null,{"$f":"+AJ5-AI5","v":0},null,null,{"$f":"+AM5-AL5","v":0}]
[null,"Other accrued expenses",null,null,null,null,null,null,null,null,null,null,{"$f":"+L6-K6","v":0},null,null,{"$f":"+O6-N6","v":0},null,null,{"$f":"+R6-Q6","v":0},null,null,{"$f":"+U6-T6","v":0},null,null,{"$f":"+X6-W6","v":0},null,null,{"$f":"+AA6-Z6","v":0},null,null,{"$f":"+AD6-AC6","v":0},null,null,{"$f":"+AG6-AF6","v":0},null,null,{"$f":"+AJ6-AI6","v":0},null,null,{"$f":"+AM6-AL6","v":0}]
[null,"Accrued salaries and related withholdings",null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,"Accrued pension payable",null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,"Accrued interest payable",null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,"Current portion of long term debt",null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,"Due to third party payers",null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,"Current portion of estimated professional liabilities",null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,"Due to (From) related organizations",null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,"Reserve for Impaired Receivable",null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,"Deferred revenue",null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,"Total current liabilities",null,{"$f":"SUM(F5:F15)","v":0},{"$f":"SUM(G5:G15)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Noncurrent Liabilities"]
[null,"Long-term debt, less current installments",null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,"Estimated professional liabilities, less current portion",null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,"Other",null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,"Other",null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,"Other",null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,"Total noncurrent liabilities",null,{"$f":"SUM(F18:F22)","v":0},0,0,0,0,{"$f":"SUM(K18:K22)","v":0},{"$f":"SUM(L18:L22)","v":0},0,{"$f":"SUM(N18:N22)","v":0},{"$f":"SUM(O18:O22)","v":0},0,{"$f":"SUM(Q18:Q22)","v":0},{"$f":"SUM(R18:R22)","v":0},0,{"$f":"SUM(T18:T22)","v":0},{"$f":"SUM(U18:U22)","v":0},0,{"$f":"SUM(W18:W22)","v":0},{"$f":"SUM(X18:X22)","v":0},0,{"$f":"SUM(Z18:Z22)","v":0},{"$f":"SUM(AA18:AA22)","v":0},0,{"$f":"SUM(AC18:AC22)","v":0},{"$f":"SUM(AD18:AD22)","v":0},0,{"$f":"SUM(AF18:AF22)","v":0},{"$f":"SUM(AG18:AG22)","v":0},0,{"$f":"SUM(AI18:AI22)","v":0},{"$f":"SUM(AJ18:AJ22)","v":0},0,{"$f":"SUM(AL18:AL22)","v":0},{"$f":"SUM(AM18:AM22)","v":0},0]
[null,null,null,"Total Liabilities",null,{"$f":"F16+F23","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Net Assets"]
[null,"Other funds available/deficient (Attach explanation sheet)",null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,"Other restricted/unrestricted funds",null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,"Total Net Assets",null,{"$f":"+SUM(F26:F27)","v":0},0,0,0,0,0,0,0,{"$f":"+SUM(N26:N27)","v":0},{"$f":"+SUM(O26:O27)","v":0},0,{"$f":"+SUM(Q26:Q27)","v":0},{"$f":"+SUM(R26:R27)","v":0},0,{"$f":"+SUM(T26:T27)","v":0},{"$f":"+SUM(U26:U27)","v":0},0,{"$f":"+SUM(W26:W27)","v":0},{"$f":"+SUM(X26:X27)","v":0},0,{"$f":"+SUM(Z26:Z27)","v":0},{"$f":"+SUM(AA26:AA27)","v":0},0,{"$f":"+SUM(AC26:AC27)","v":0},{"$f":"+SUM(AD26:AD27)","v":0},0,{"$f":"+SUM(AF26:AF27)","v":0},{"$f":"+SUM(AG26:AG27)","v":0},0,{"$f":"+SUM(AI26:AI27)","v":0},{"$f":"+SUM(AJ26:AJ27)","v":0},0,{"$f":"+SUM(AL26:AL27)","v":0},{"$f":"+SUM(AM26:AM27)","v":0},0]
["Total Liabilities and Net Assets",null,null,null,null,{"$f":"F24+F28","v":0},0,0,0,0,0,0,0,{"$f":"N24+N28","v":0},{"$f":"O24+O28","v":0},0,{"$f":"Q24+Q28","v":0},{"$f":"R24+R28","v":0},0,{"$f":"T24+T28","v":0},{"$f":"U24+U28","v":0},0,{"$f":"W24+W28","v":0},{"$f":"X24+X28","v":0},0,{"$f":"Z24+Z28","v":0},{"$f":"AA24+AA28","v":0},0,{"$f":"AC24+AC28","v":0},{"$f":"AD24+AD28","v":0},0,{"$f":"AF24+AF28","v":0},{"$f":"AG24+AG28","v":0},0,{"$f":"AI24+AI28","v":0},{"$f":"AJ24+AJ28","v":0},0,{"$f":"AL24+AL28","v":0},{"$f":"AM24+AM28","v":0},0]

{"sheet":"Income Statement","index":3,"n_rows":37,"n_cols":50,"rows_kept":37,"cut":false,"hidden":false,"merged":[[29,1,29,2]]}
[null,"Statement of Operations (P&L) ( Cash Basis)",null,{"$f":"COLUMN()","v":4},{"$f":"COLUMN()","v":5},{"$f":"COLUMN()","v":6},{"$f":"COLUMN()","v":7},{"$f":"COLUMN()","v":8},{"$f":"COLUMN()","v":9},{"$f":"COLUMN()","v":10},{"$f":"COLUMN()","v":11},{"$f":"COLUMN()","v":12},{"$f":"COLUMN()","v":13},{"$f":"COLUMN()","v":14},{"$f":"COLUMN()","v":15},{"$f":"COLUMN()","v":16},{"$f":"COLUMN()","v":17},{"$f":"COLUMN()","v":18},{"$f":"COLUMN()","v":19},{"$f":"COLUMN()","v":20},{"$f":"COLUMN()","v":21},{"$f":"COLUMN()","v":22},{"$f":"COLUMN()","v":23},{"$f":"COLUMN()","v":24},{"$f":"COLUMN()","v":25},{"$f":"COLUMN()","v":26},{"$f":"COLUMN()","v":27},{"$f":"COLUMN()","v":28},{"$f":"COLUMN()","v":29},{"$f":"COLUMN()","v":30},{"$f":"COLUMN()","v":31},{"$f":"COLUMN()","v":32},{"$f":"COLUMN()","v":33},{"$f":"COLUMN()","v":34},{"$f":"COLUMN()","v":35},{"$f":"COLUMN()","v":36},{"$f":"COLUMN()","v":37},{"$f":"COLUMN()","v":38},{"$f":"COLUMN()","v":39},{"$f":"COLUMN()","v":40},{"$f":"COLUMN()","v":41},{"$f":"COLUMN()","v":42},{"$f":"COLUMN()","v":43},{"$f":"COLUMN()","v":44},{"$f":"COLUMN()","v":45},{"$f":"COLUMN()","v":46},{"$f":"COLUMN()","v":47},{"$f":"COLUMN()","v":48},{"$f":"COLUMN()","v":49},{"$f":"COLUMN()","v":50}]
[{"$f":"IF(Cover!$G$5=\"\",\"\",Cover!$G$5)","v":""},null,null,null,null,"2014-01-31","2014-02-28","2014-03-31","2014-04-30","2014-05-31","2014-06-30","2014-06-30",{"$f":"+L2","v":"2014-06-30"},"Reviewer's","2014-07-31","2014-07-31",{"$f":"+P2","v":"2014-07-31"},"Reviewer's","2014-08-31","2014-08-31",{"$f":"+T2","v":"2014-08-31"},"Reviewer's","2014-09-30","2014-09-30",{"$f":"+X2","v":"2014-09-30"},"Reviewer's","2014-10-31","2014-10-31",{"$f":"+AB2","v":"2014-10-31"},"Reviewer's","2014-11-30","2014-11-30",{"$f":"+AF2","v":"2014-11-30"},"Reviewer's","2014-12-31","2014-12-31",{"$f":"+AJ2","v":"2014-12-31"},"Reviewer's","2015-01-31","2015-01-31",{"$f":"+AN2","v":"2015-01-31"},"Reviewer's","2015-02-28","2015-02-28",{"$f":"+AR2","v":"2015-02-28"},"Reviewer's","2015-03-31","2015-03-31",{"$f":"+AV2","v":"2015-03-31"},"Reviewer's"]
["REVENUE AND EXPENSES",null,null,"Definition Help",null,"Actual","Actual","Actual","Actual","Actual","Projected","Actual","Difference","Adjustment","Projected","Actual","Difference","Adjustment","Projected","Actual","Difference","Adjustment","Projected","Actual","Difference","Adjustment","Projected","Actual","Difference","Adjustment","Projected","Actual","Difference","Adjustment","Projected","Actual","Difference","Adjustment","Projected","Actual","Difference","Adjustment","Projected","Actual","Difference","Adjustment","Projected","Actual","Difference","Adjustment"]
["Revenue"]
[null,"Patient Service Revenue"]
[null,null,"Inpatient revenue",null,null,null,null,null,null,null,null,null,{"$f":"+L6-K6","v":0},null,null,null,{"$f":"+P6-O6","v":0},null,null,null,{"$f":"+T6-S6","v":0},null,null,null,{"$f":"+X6-W6","v":0},null,null,null,{"$f":"+AB6-AA6","v":0},null,null,null,{"$f":"+AF6-AE6","v":0},null,null,null,{"$f":"+AJ6-AI6","v":0},null,null,null,{"$f":"+AN6-AM6","v":0},null,null,null,{"$f":"+AR6-AQ6","v":0},null,null,null,{"$f":"+AV6-AU6","v":0}]
[null,null,"Outpatient revenue",null,null,null,null,null,null,null,null,null,{"$f":"+L7-K7","v":0},null,null,null,{"$f":"+P7-O7","v":0},null,null,null,{"$f":"+T7-S7","v":0},null,null,null,{"$f":"+X7-W7","v":0},null,null,null,{"$f":"+AB7-AA7","v":0},null,null,null,{"$f":"+AF7-AE7","v":0},null,null,null,{"$f":"+AJ7-AI7","v":0},null,null,null,{"$f":"+AN7-AM7","v":0},null,null,null,{"$f":"+AR7-AQ7","v":0},null,null,null,{"$f":"+AV7-AU7","v":0}]
[null,null,"Provision for bad debt (Negative)",null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,"Net patient revenue - Less provision for bad debts",null,null,null,{"$f":"+SUM(F6:F8)","v":0},{"$f":"+SUM(G6:G8)","v":0},0,0,0,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0]
[null,"Other operating revenue",null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,"Non-operating revenue ",null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,"Total revenue",null,{"$f":"+F9+F10+F11","v":0},0,0,0,0,0,0,{"$f":"L12-K12","v":0},null,{"$f":"+O9+O10+O11","v":0},{"$f":"+P9+P10+P11","v":0},0,null,{"$f":"+S9+S10+S11","v":0},{"$f":"+T9+T10+T11","v":0},0,null,{"$f":"+W9+W10+W11","v":0},{"$f":"+X9+X10+X11","v":0},0,null,{"$f":"+AA9+AA10+AA11","v":0},{"$f":"+AB9+AB10+AB11","v":0},0,null,{"$f":"+AE9+AE10+AE11","v":0},{"$f":"+AF9+AF10+AF11","v":0},0,null,{"$f":"+AI9+AI10+AI11","v":0},{"$f":"+AJ9+AJ10+AJ11","v":0},0,null,{"$f":"+AM9+AM10+AM11","v":0},{"$f":"+AN9+AN10+AN11","v":0},0,null,{"$f":"+AQ9+AQ10+AQ11","v":0},{"$f":"+AR9+AR10+AR11","v":0},0,null,{"$f":"+AU9+AU10+AU11","v":0},{"$f":"+AV9+AV10+AV11","v":0},0]
["Expenses"]
[null,"Salaries and wages",null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,"Employee benefits",null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,"Physician fees",null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,"Contract labor/Purchased Services",null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,"Consultant fees",null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,"Utilities",null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,"Lease/Rental",null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,"Repairs/Maintenance",null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,"Medical supplies",null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,"Other supplies",null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,"Other expenses",null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,"Other Insurance & Est Malpractice",null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,"Interest & mortgage fees",null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,"Depreciation & amortization",null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,"Total operating expenses",null,{"$f":"SUM(F14:F27)","v":0},0,0,0,0,0,0,0,null,0,0,0,null,{"$f":"SUM(S14:S27)","v":0},{"$f":"SUM(T14:T27)","v":0},{"$f":"SUM(U14:U27)","v":0},null,{"$f":"SUM(W14:W27)","v":0},{"$f":"SUM(X14:X27)","v":0},{"$f":"SUM(Y14:Y27)","v":0},null,{"$f":"SUM(AA14:AA27)","v":0},{"$f":"SUM(AB14:AB27)","v":0},{"$f":"SUM(AC14:AC27)","v":0},null,{"$f":"SUM(AE14:AE27)","v":0},{"$f":"SUM(AF14:AF27)","v":0},{"$f":"SUM(AG14:AG27)","v":0},null,{"$f":"SUM(AI14:AI27)","v":0},{"$f":"SUM(AJ14:AJ27)","v":0},{"$f":"SUM(AK14:AK27)","v":0},null,{"$f":"SUM(AM14:AM27)","v":0},{"$f":"SUM(AN14:AN27)","v":0},{"$f":"SUM(AO14:AO27)","v":0},null,{"$f":"SUM(AQ14:AQ27)","v":0},{"$f":"SUM(AR14:AR27)","v":0},{"$f":"SUM(AS14:AS27)","v":0},null,{"$f":"SUM(AU14:AU27)","v":0},{"$f":"SUM(AV14:AV27)","v":0},{"$f":"SUM(AW14:AW27)","v":0}]
[null,null,null,"Total operating expenses less depreciation",null,{"$f":"F28-F27","v":0},0,0,0,0,0,0,0,null,{"$f":"O28-O27","v":0},{"$f":"P28-P27","v":0},{"$f":"Q28-Q27","v":0},null,{"$f":"S28-S27","v":0},{"$f":"T28-T27","v":0},{"$f":"U28-U27","v":0},null,{"$f":"W28-W27","v":0},{"$f":"X28-X27","v":0},{"$f":"Y28-Y27","v":0},null,{"$f":"AA28-AA27","v":0},{"$f":"AB28-AB27","v":0},{"$f":"AC28-AC27","v":0},null,{"$f":"AE28-AE27","v":0},{"$f":"AF28-AF27","v":0},{"$f":"AG28-AG27","v":0},null,{"$f":"AI28-AI27","v":0},{"$f":"AJ28-AJ27","v":0},{"$f":"AK28-AK27","v":0},null,{"$f":"AM28-AM27","v":0},{"$f":"AN28-AN27","v":0},{"$f":"AO28-AO27","v":0},null,{"$f":"AQ28-AQ27","v":0},{"$f":"AR28-AR27","v":0},{"$f":"AS28-AS27","v":0},null,{"$f":"AU28-AU27","v":0},{"$f":"AV28-AV27","v":0},{"$f":"AW28-AW27","v":0}]
[null,"Non-Operating Expenses( Please break out the expenses using the attached input button)",null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,{"$f":"+AB30-AA30","v":0},null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Net profit/(loss) from operations",null,null,null,null,{"$f":"+F12-F11-F28","v":0},0,0,0,0,0,0,0,null,{"$f":"+O12-O11-O28","v":0},{"$f":"+P12-P11-P28","v":0},{"$f":"+Q12-Q11-Q28","v":0},null,{"$f":"+S12-S11-S28","v":0},{"$f":"+T12-T11-T28","v":0},{"$f":"+U12-U11-U28","v":0},null,{"$f":"+W12-W11-W28","v":0},{"$f":"+X12-X11-X28","v":0},{"$f":"+Y12-Y11-Y28","v":0},null,{"$f":"+AA12-AA11-AA28","v":0},{"$f":"+AB12-AB11-AB28","v":0},{"$f":"+AC12-AC11-AC28","v":0},null,{"$f":"+AE12-AE11-AE28","v":0},{"$f":"+AF12-AF11-AF28","v":0},{"$f":"+AG12-AG11-AG28","v":0},null,{"$f":"+AI12-AI11-AI28","v":0},{"$f":"+AJ12-AJ11-AJ28","v":0},{"$f":"+AK12-AK11-AK28","v":0},null,{"$f":"+AM12-AM11-AM28","v":0},{"$f":"+AN12-AN11-AN28","v":0},{"$f":"+AO12-AO11-AO28","v":0},null,{"$f":"+AQ12-AQ11-AQ28","v":0},{"$f":"+AR12-AR11-AR28","v":0},{"$f":"+AS12-AS11-AS28","v":0},null,{"$f":"+AU12-AU11-AU28","v":0},{"$f":"+AV12-AV11-AV28","v":0},{"$f":"+AW12-AW11-AW28","v":0}]
["Net profit/(loss) from operations less depreciation",null,null,null,null,{"$f":"+F12-F11-F29","v":0},0,0,0,0,0,0,0,null,{"$f":"+O12-O11-O29","v":0},{"$f":"+P12-P11-P29","v":0},{"$f":"+Q12-Q11-Q29","v":0},null,{"$f":"+S12-S11-S29","v":0},{"$f":"+T12-T11-T29","v":0},{"$f":"+U12-U11-U29","v":0},null,{"$f":"+W12-W11-W29","v":0},{"$f":"+X12-X11-X29","v":0},{"$f":"+Y12-Y11-Y29","v":0},null,{"$f":"+AA12-AA11-AA29","v":0},{"$f":"+AB12-AB11-AB29","v":0},{"$f":"+AC12-AC11-AC29","v":0},null,{"$f":"+AE12-AE11-AE29","v":0},{"$f":"+AF12-AF11-AF29","v":0},{"$f":"+AG12-AG11-AG29","v":0},null,{"$f":"+AI12-AI11-AI29","v":0},{"$f":"+AJ12-AJ11-AJ29","v":0},{"$f":"+AK12-AK11-AK29","v":0},null,{"$f":"+AM12-AM11-AM29","v":0},{"$f":"+AN12-AN11-AN29","v":0},{"$f":"+AO12-AO11-AO29","v":0},null,{"$f":"+AQ12-AQ11-AQ29","v":0},{"$f":"+AR12-AR11-AR29","v":0},{"$f":"+AS12-AS11-AS29","v":0},null,{"$f":"+AU12-AU11-AU29","v":0},{"$f":"+AV12-AV11-AV29","v":0},{"$f":"+AW12-AW11-AW29","v":0}]
["Total Expenses",null,null,null,null,{"$f":"+F28+F30","v":0},0,0,0,0,0,0,0,null,{"$f":"+O28+O30","v":0},{"$f":"+P28+P30","v":0},{"$f":"+Q28+Q30","v":0},null,{"$f":"+S28+S30","v":0},{"$f":"+T28+T30","v":0},{"$f":"+U28+U30","v":0},null,{"$f":"+W28+W30","v":0},{"$f":"+X28+X30","v":0},{"$f":"+Y28+Y30","v":0},null,{"$f":"+AA28+AA30","v":0},{"$f":"+AB28+AB30","v":0},{"$f":"+AC28+AC30","v":0},null,{"$f":"+AE28+AE30","v":0},{"$f":"+AF28+AF30","v":0},{"$f":"+AG28+AG30","v":0},null,{"$f":"+AI28+AI30","v":0},{"$f":"+AJ28+AJ30","v":0},{"$f":"+AK28+AK30","v":0},null,{"$f":"+AM28+AM30","v":0},{"$f":"+AN28+AN30","v":0},{"$f":"+AO28+AO30","v":0},null,{"$f":"+AQ28+AQ30","v":0},{"$f":"+AR28+AR30","v":0},{"$f":"+AS28+AS30","v":0},null,{"$f":"+AU28+AU30","v":0},{"$f":"+AV28+AV30","v":0},{"$f":"+AW28+AW30","v":0}]
["Total Expenses Less Depreciation",null,null,null,null,{"$f":"F33-F27","v":0},0,0,0,0,0,0,0,null,{"$f":"O33-O27","v":0},{"$f":"P33-P27","v":0},{"$f":"Q33-Q27","v":0},null,{"$f":"S33-S27","v":0},{"$f":"T33-T27","v":0},{"$f":"U33-U27","v":0},null,{"$f":"W33-W27","v":0},{"$f":"X33-X27","v":0},{"$f":"Y33-Y27","v":0},null,{"$f":"AA33-AA27","v":0},{"$f":"AB33-AB27","v":0},{"$f":"AC33-AC27","v":0},null,{"$f":"AE33-AE27","v":0},{"$f":"AF33-AF27","v":0},{"$f":"AG33-AG27","v":0},null,{"$f":"AI33-AI27","v":0},{"$f":"AJ33-AJ27","v":0},{"$f":"AK33-AK27","v":0},null,{"$f":"AM33-AM27","v":0},{"$f":"AN33-AN27","v":0},{"$f":"AO33-AO27","v":0},null,{"$f":"AQ33-AQ27","v":0},{"$f":"AR33-AR27","v":0},{"$f":"AS33-AS27","v":0},null,{"$f":"AU33-AU27","v":0},{"$f":"AV33-AV27","v":0},{"$f":"AW33-AW27","v":0}]
["Excess Revenue Over Expenses",null,null,null,null,{"$f":"+F12-F33","v":0},0,0,0,0,0,0,0,null,{"$f":"+O12-O33","v":0},{"$f":"+P12-P33","v":0},{"$f":"+Q12-Q33","v":0},null,{"$f":"+S12-S33","v":0},{"$f":"+T12-T33","v":0},{"$f":"+U12-U33","v":0},null,{"$f":"+W12-W33","v":0},{"$f":"+X12-X33","v":0},{"$f":"+Y12-Y33","v":0},null,{"$f":"+AA12-AA33","v":0},{"$f":"+AB12-AB33","v":0},{"$f":"+AC12-AC33","v":0},null,{"$f":"+AE12-AE33","v":0},{"$f":"+AF12-AF33","v":0},{"$f":"+AG12-AG33","v":0},null,{"$f":"+AI12-AI33","v":0},{"$f":"+AJ12-AJ33","v":0},{"$f":"+AK12-AK33","v":0},null,{"$f":"+AM12-AM33","v":0},{"$f":"+AN12-AN33","v":0},{"$f":"+AO12-AO33","v":0},null,{"$f":"+AQ12-AQ33","v":0},{"$f":"+AR12-AR33","v":0},{"$f":"+AS12-AS33","v":0},null,{"$f":"+AU12-AU33","v":0},{"$f":"+AV12-AV33","v":0},{"$f":"+AW12-AW33","v":0}]
["Excess Revenue Over Expenses Less Depreciation",null,null,null,null,{"$f":"(F35+F27)","v":0},0,0,0,0,0,0,0,null,{"$f":"(O35+O27)","v":0},{"$f":"(P35+P27)","v":0},{"$f":"(Q35+Q27)","v":0},null,{"$f":"(S35+S27)","v":0},{"$f":"(T35+T27)","v":0},{"$f":"(U35+U27)","v":0},null,{"$f":"(W35+W27)","v":0},{"$f":"(X35+X27)","v":0},{"$f":"(Y35+Y27)","v":0},null,{"$f":"(AA35+AA27)","v":0},{"$f":"(AB35+AB27)","v":0},{"$f":"(AC35+AC27)","v":0},null,{"$f":"(AE35+AE27)","v":0},{"$f":"(AF35+AF27)","v":0},{"$f":"(AG35+AG27)","v":0},null,{"$f":"(AI35+AI27)","v":0},{"$f":"(AJ35+AJ27)","v":0},{"$f":"(AK35+AK27)","v":0},null,{"$f":"(AM35+AM27)","v":0},{"$f":"(AN35+AN27)","v":0},{"$f":"(AO35+AO27)","v":0},null,{"$f":"(AQ35+AQ27)","v":0},{"$f":"(AR35+AR27)","v":0},{"$f":"(AS35+AS27)","v":0},null,{"$f":"(AU35+AU27)","v":0},{"$f":"(AV35+AV27)","v":0},{"$f":"(AW35+AW27)","v":0}]
["Need State Assistance in the Amount of",null,null,null,null,null,null,null,null,null,{"$f":"IF(K36>0,0,ABS(K36))","v":0},{"$f":"IF(L36>0,0,ABS(L36))","v":0},{"$f":"+L37-K37","v":0},null,{"$f":"IF(O36>0,0,ABS(O36))","v":0},{"$f":"IF(P36>0,0,ABS(P36))","v":0},{"$f":"+P37-O37","v":0},null,{"$f":"IF(S36>0,0,ABS(S36))","v":0},{"$f":"IF(T36>0,0,ABS(T36))","v":0},{"$f":"+T37-S37","v":0},null,{"$f":"IF(W36>0,0,ABS(W36))","v":0},{"$f":"IF(X36>0,0,ABS(X36))","v":0},{"$f":"+X37-W37","v":0},null,{"$f":"IF(AA36>0,0,ABS(AA36))","v":0},{"$f":"IF(AB36>0,0,ABS(AB36))","v":0},{"$f":"+AB37-AA37","v":0},null,{"$f":"IF(AE36>0,0,ABS(AE36))","v":0},{"$f":"IF(AF36>0,0,ABS(AF36))","v":0},{"$f":"+AF37-AE37","v":0},null,{"$f":"IF(AI36>0,0,ABS(AI36))","v":0},{"$f":"IF(AJ36>0,0,ABS(AJ36))","v":0},{"$f":"+AJ37-AI37","v":0},null,{"$f":"IF(AM36>0,0,ABS(AM36))","v":0},{"$f":"IF(AN36>0,0,ABS(AN36))","v":0},{"$f":"+AN37-AM37","v":0},null,{"$f":"IF(AQ36>0,0,ABS(AQ36))","v":0},{"$f":"IF(AR36>0,0,ABS(AR36))","v":0},{"$f":"+AR37-AQ37","v":0},null,{"$f":"IF(AU36>0,0,ABS(AU36))","v":0},{"$f":"IF(AV36>0,0,ABS(AV36))","v":0},{"$f":"+AV37-AU37","v":0}]

{"sheet":"Statistics Summary","index":4,"n_rows":55,"n_cols":40,"rows_kept":55,"cut":false,"hidden":false,"merged":[[42,1,42,2],[43,1,43,2],[48,1,48,2]]}
["←","Statement of Statistics Inpatient and Outpatient",null,{"$f":"COLUMN()","v":4},null,{"$f":"COLUMN()","v":6},{"$f":"COLUMN()","v":7},{"$f":"COLUMN()","v":8},{"$f":"COLUMN()","v":9},{"$f":"COLUMN()","v":10},{"$f":"COLUMN()","v":11},{"$f":"COLUMN()","v":12},{"$f":"COLUMN()","v":13},{"$f":"COLUMN()","v":14},{"$f":"COLUMN()","v":15},{"$f":"COLUMN()","v":16},{"$f":"COLUMN()","v":17},{"$f":"COLUMN()","v":18},{"$f":"COLUMN()","v":19},{"$f":"COLUMN()","v":20},{"$f":"COLUMN()","v":21},{"$f":"COLUMN()","v":22},{"$f":"COLUMN()","v":23},{"$f":"COLUMN()","v":24},{"$f":"COLUMN()","v":25},{"$f":"COLUMN()","v":26},{"$f":"COLUMN()","v":27},{"$f":"COLUMN()","v":28},{"$f":"COLUMN()","v":29},{"$f":"COLUMN()","v":30},{"$f":"COLUMN()","v":31},{"$f":"COLUMN()","v":32},{"$f":"COLUMN()","v":33},{"$f":"COLUMN()","v":34},{"$f":"COLUMN()","v":35},{"$f":"COLUMN()","v":36},{"$f":"COLUMN()","v":37},{"$f":"COLUMN()","v":38},{"$f":"COLUMN()","v":39},{"$f":"COLUMN()","v":40}]
[{"$f":"IF(Cover!$G$5=\"\",\"\",Cover!$G$5)","v":""},null,null,null,null,"2014-01-31","2014-02-28","2014-03-31","2014-04-30","2014-05-31","2014-06-30","2014-06-30",{"$f":"+L2","v":"2014-06-30"},"2014-07-31","2014-07-31",{"$f":"+O2","v":"2014-07-31"},"2014-08-31","2014-08-31",{"$f":"+R2","v":"2014-08-31"},"2014-09-30","2014-09-30",{"$f":"+U2","v":"2014-09-30"},"2014-10-31","2014-10-31",{"$f":"+X2","v":"2014-10-31"},"2014-11-30","2014-11-30",{"$f":"+AA2","v":"2014-11-30"},"2014-12-31","2014-12-31",{"$f":"+AD2","v":"2014-12-31"},"2015-01-31","2015-01-31",{"$f":"+AG2","v":"2015-01-31"},"2015-02-28","2015-02-28",{"$f":"+AJ2","v":"2015-02-28"},"2015-03-31","2015-03-31",{"$f":"+AM2","v":"2015-03-31"}]
["STATISTICS SUMMARY",null,null,null,null,"Actual","Actual","Actual","Actual","Actual","Projected","Actual","Difference","Projected","Actual","Difference","Projected","Actual","Difference","Projected","Actual","Difference","Projected","Actual","Difference","Projected","Actual","Difference","Projected","Actual","Difference","Projected","Actual","Difference","Projected","Actual","Difference","Projected","Actual","Difference"]
["Inpatient Statistics"]
[null,"Discharges"]
[null,null,"Medicine",null,null,null,null,null,null,null,null,null,{"$f":"+L6-K6","v":0},null,null,{"$f":"+O6-N6","v":0},null,null,{"$f":"+R6-Q6","v":0},null,null,{"$f":"+U6-T6","v":0},null,null,{"$f":"+X6-W6","v":0},null,null,{"$f":"+AA6-Z6","v":0},null,null,{"$f":"+AD6-AC6","v":0},null,null,{"$f":"+AG6-AF6","v":0},null,null,{"$f":"+AJ6-AI6","v":0},null,null,{"$f":"+AM6-AL6","v":0}]
[null,null,"Surgery",null,null,null,null,null,null,null,null,null,{"$f":"+L7-K7","v":0},null,null,{"$f":"+O7-N7","v":0},null,null,{"$f":"+R7-Q7","v":0},null,null,{"$f":"+U7-T7","v":0},null,null,{"$f":"+X7-W7","v":0},null,null,{"$f":"+AA7-Z7","v":0},null,null,{"$f":"+AD7-AC7","v":0},null,null,{"$f":"+AG7-AF7","v":0},null,null,{"$f":"+AJ7-AI7","v":0},null,null,{"$f":"+AM7-AL7","v":0}]
[null,null,"GYN",null,null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,"Pediatrics",null,null,null,null,null,null,null,null,null,{"$f":"+L9-K9","v":0},null,null,{"$f":"+O9-N9","v":0},null,null,{"$f":"+R9-Q9","v":0},null,null,{"$f":"+U9-T9","v":0},null,null,{"$f":"+X9-W9","v":0},null,null,{"$f":"+AA9-Z9","v":0},null,null,{"$f":"+AD9-AC9","v":0},null,null,{"$f":"+AG9-AF9","v":0},null,null,{"$f":"+AJ9-AI9","v":0},null,null,{"$f":"+AM9-AL9","v":0}]
[null,null,"OB",null,null,null,null,null,null,null,null,null,{"$f":"+L10-K10","v":0},null,null,{"$f":"+O10-N10","v":0},null,null,{"$f":"+R10-Q10","v":0},null,null,{"$f":"+U10-T10","v":0},null,null,{"$f":"+X10-W10","v":0},null,null,{"$f":"+AA10-Z10","v":0},null,null,{"$f":"+AD10-AC10","v":0},null,null,{"$f":"+AG10-AF10","v":0},null,null,{"$f":"+AJ10-AI10","v":0},null,null,{"$f":"+AM10-AL10","v":0}]
[null,null,"NICU",null,null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,"Newborn",null,null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,"Other (Please specify)",null,null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,"Total discharges",null,{"$f":"+SUM(F6:F13)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Daily Census"]
[null,"Average Length of Stay per discharge"]
[null,null,"Medicine",null,null,null,null,null,null,null,null,null,0,null,null,{"$f":"+O17-N17","v":0},null,null,{"$f":"+R17-Q17","v":0},null,null,{"$f":"+U17-T17","v":0},null,null,{"$f":"+X17-W17","v":0},null,null,{"$f":"+AA17-Z17","v":0},null,null,{"$f":"+AD17-AC17","v":0},null,null,{"$f":"+AG17-AF17","v":0},null,null,{"$f":"+AJ17-AI17","v":0},null,null,{"$f":"+AM17-AL17","v":0}]
[null,null,"Surgery",null,null,null,null,null,null,null,null,null,0,null,null,{"$f":"+O18-N18","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,"GYN",null,null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,"Pediatrics",null,null,null,null,null,null,null,null,null,0,null,null,{"$f":"+O20-N20","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,"OB",null,null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,"NICU",null,null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,"Newborn",null,null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,"Other (Please specify)",null,null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[]
["CMI"]
[null,"MedSurg/GYN",null,null,null,null,null,null,null,null,null,null,{"$f":"+L27-K27","v":0},null,null,{"$f":"+O27-N27","v":0},null,null,{"$f":"+R27-Q27","v":0},null,null,{"$f":"+U27-T27","v":0},null,null,{"$f":"+X27-W27","v":0},null,null,{"$f":"+AA27-Z27","v":0},null,null,{"$f":"+AD27-AC27","v":0},null,null,{"$f":"+AG27-AF27","v":0},null,null,{"$f":"+AJ27-AI27","v":0},null,null,{"$f":"+AM27-AL27","v":0}]
[null,"Pediatrics",null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,"OB",null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,"NICU",null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,"Other (Please Specify)",null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[]
["Payor Mix"]
[null,"Medicare (Combine Managed Care & FFS)",null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,"Medicaid (Combine Managed Care & FFS)",null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,"Commercial & Other",null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,"Self Pay",null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,"Charity Care",null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,"Total",null,{"$f":"+SUM(F34:F38)","v":0},{"$f":"+SUM(G34:G38)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Outpatient Statistics"]
[null,"ER Visits - including admits",null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,"ER Specific FTEs",null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,"Amb Surgery Procedures",null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,"Amb Surgery Specific FTEs",null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,"Clinic Visits",null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,"Clinic Specific FTEs",null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,"Total Visits",null,{"$f":"+F41+F45","v":0},{"$f":"+G41+G45","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Total Procedures",null,{"$f":"+F43","v":0},{"$f":"+G43","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Total FTES",null,{"$f":"+F42+F44+F46","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Common Financial Ratios"]
[null,"Debt Ratio (Total Liabilities / Total Assets)",null,null,null,{"$f":"IF('BS Assets'!F30>0, ('BS Liab'!F16+'BS Liab'!F23)/'BS Assets'!F30, \"\")","v":""},{"$f":"IF('BS Assets'!G30>0, ('BS Liab'!G16+'BS Liab'!G23)/'BS Assets'!G30, \"\")","v":""},{"$f":"IF('BS Assets'!H30>0, ('BS Liab'!H16+'BS Liab'!H23)/'BS Assets'!H30, \"\")","v":""},{"$f":"IF('BS Assets'!I30>0, ('BS Liab'!I16+'BS Liab'!I23)/'BS Assets'!I30, \"\")","v":""},{"$f":"IF('BS Assets'!J30>0, ('BS Liab'!J16+'BS Liab'!J23)/'BS Assets'!J30, \"\")","v":""},{"$f":"IF('BS Assets'!K30>0, ('BS Liab'!K16+'BS Liab'!K23)/'BS Assets'!K30, \"\")","v":""},{"$f":"IF('BS Assets'!L30>0, ('BS Liab'!L16+'BS Liab'!L23)/'BS Assets'!L30, \"\")","v":""},{"$f":"IF(AND(L51<>\"\", K51<>\"\"), L51-K51,0)","v":0},{"$f":"IF('BS Assets'!N30>0, ('BS Liab'!N16+'BS Liab'!N23)/'BS Assets'!N30, \"\")","v":""},{"$f":"IF('BS Assets'!O30>0, ('BS Liab'!O16+'BS Liab'!O23)/'BS Assets'!O30, \"\")","v":""},{"$f":"IF(AND(O51<>\"\", N51<>\"\"), O51-N51,0)","v":0},{"$f":"IF('BS Assets'!Q30>0, ('BS Liab'!Q16+'BS Liab'!Q23)/'BS Assets'!Q30, \"\")","v":""},{"$f":"IF('BS Assets'!R30>0, ('BS Liab'!R16+'BS Liab'!R23)/'BS Assets'!R30, \"\")","v":""},{"$f":"IF(AND(R51<>\"\", Q51<>\"\"), R51-Q51,0)","v":0},{"$f":"IF('BS Assets'!T30>0, ('BS Liab'!T16+'BS Liab'!T23)/'BS Assets'!T30, \"\")","v":""},{"$f":"IF('BS Assets'!U30>0, ('BS Liab'!U16+'BS Liab'!U23)/'BS Assets'!U30, \"\")","v":""},{"$f":"IF(AND(U51<>\"\", T51<>\"\"), U51-T51,0)","v":0},{"$f":"IF('BS Assets'!W30>0, ('BS Liab'!W16+'BS Liab'!W23)/'BS Assets'!W30, \"\")","v":""},{"$f":"IF('BS Assets'!X30>0, ('BS Liab'!X16+'BS Liab'!X23)/'BS Assets'!X30, \"\")","v":""},{"$f":"IF(AND(X51<>\"\", W51<>\"\"), X51-W51,0)","v":0},{"$f":"IF('BS Assets'!Z30>0, ('BS Liab'!Z16+'BS Liab'!Z23)/'BS Assets'!Z30, \"\")","v":""},{"$f":"IF('BS Assets'!AA30>0, ('BS Liab'!AA16+'BS Liab'!AA23)/'BS Assets'!AA30, \"\")","v":""},{"$f":"IF(AND(AA51<>\"\", Z51<>\"\"), AA51-Z51,0)","v":0},{"$f":"IF('BS Assets'!AC30>0, ('BS Liab'!AC16+'BS Liab'!AC23)/'BS Assets'!AC30, \"\")","v":""},{"$f":"IF('BS Assets'!AD30>0, ('BS Liab'!AD16+'BS Liab'!AD23)/'BS Assets'!AD30, \"\")","v":""},{"$f":"IF(AND(AD51<>\"\", AC51<>\"\"), AD51-AC51,0)","v":0},{"$f":"IF('BS Assets'!AF30>0, ('BS Liab'!AF16+'BS Liab'!AF23)/'BS Assets'!AF30, \"\")","v":""},{"$f":"IF('BS Assets'!AG30>0, ('BS Liab'!AG16+'BS Liab'!AG23)/'BS Assets'!AG30, \"\")","v":""},{"$f":"IF(AND(AG51<>\"\", AF51<>\"\"), AG51-AF51,0)","v":0},{"$f":"IF('BS Assets'!AI30>0, ('BS Liab'!AI16+'BS Liab'!AI23)/'BS Assets'!AI30, \"\")","v":""},{"$f":"IF('BS Assets'!AJ30>0, ('BS Liab'!AJ16+'BS Liab'!AJ23)/'BS Assets'!AJ30, \"\")","v":""},{"$f":"IF(AND(AJ51<>\"\", AI51<>\"\"), AJ51-AI51,0)","v":0},{"$f":"IF('BS Assets'!AL30>0, ('BS Liab'!AL16+'BS Liab'!AL23)/'BS Assets'!AL30, \"\")","v":""},{"$f":"IF('BS Assets'!AM30>0, ('BS Liab'!AM16+'BS Liab'!AM23)/'BS Assets'!AM30, \"\")","v":""},{"$f":"IF(AND(AM51<>\"\", AL51<>\"\"), AM51-AL51,0)","v":0}]
[null,"Current Ratio (Current Assets / Current Liabilities)",null,null,null,{"$f":"+IF('BS Liab'!F16>0,'BS Assets'!F15/'BS Liab'!F16,\"\")","v":""},{"$f":"+IF('BS Liab'!G16>0,'BS Assets'!G15/'BS Liab'!G16,\"\")","v":""},{"$f":"+IF('BS Liab'!H16>0,'BS Assets'!H15/'BS Liab'!H16,\"\")","v":""},{"$f":"+IF('BS Liab'!I16>0,'BS Assets'!I15/'BS Liab'!I16,\"\")","v":""},{"$f":"+IF('BS Liab'!J16>0,'BS Assets'!J15/'BS Liab'!J16,\"\")","v":""},{"$f":"+IF('BS Liab'!K16>0,'BS Assets'!K15/'BS Liab'!K16,\"\")","v":""},{"$f":"+IF('BS Liab'!L16>0,'BS Assets'!L15/'BS Liab'!L16,\"\")","v":""},{"$f":"IF(AND(L52<>\"\", K52<>\"\"), L52-K52,0)","v":0},{"$f":"+IF('BS Liab'!N16>0,'BS Assets'!N15/'BS Liab'!N16,\"\")","v":""},{"$f":"+IF('BS Liab'!O16>0,'BS Assets'!O15/'BS Liab'!O16,\"\")","v":""},{"$f":"IF(AND(O52<>\"\", N52<>\"\"), O52-N52,0)","v":0},{"$f":"+IF('BS Liab'!Q16>0,'BS Assets'!Q15/'BS Liab'!Q16,\"\")","v":""},{"$f":"+IF('BS Liab'!R16>0,'BS Assets'!R15/'BS Liab'!R16,\"\")","v":""},{"$f":"IF(AND(R52<>\"\", Q52<>\"\"), R52-Q52,0)","v":0},{"$f":"+IF('BS Liab'!T16>0,'BS Assets'!T15/'BS Liab'!T16,\"\")","v":""},{"$f":"+IF('BS Liab'!U16>0,'BS Assets'!U15/'BS Liab'!U16,\"\")","v":""},{"$f":"IF(AND(U52<>\"\", T52<>\"\"), U52-T52,0)","v":0},{"$f":"+IF('BS Liab'!W16>0,'BS Assets'!W15/'BS Liab'!W16,\"\")","v":""},{"$f":"+IF('BS Liab'!X16>0,'BS Assets'!X15/'BS Liab'!X16,\"\")","v":""},{"$f":"IF(AND(X52<>\"\", W52<>\"\"), X52-W52,0)","v":0},{"$f":"+IF('BS Liab'!Z16>0,'BS Assets'!Z15/'BS Liab'!Z16,\"\")","v":""},{"$f":"+IF('BS Liab'!AA16>0,'BS Assets'!AA15/'BS Liab'!AA16,\"\")","v":""},{"$f":"IF(AND(AA52<>\"\", Z52<>\"\"), AA52-Z52,0)","v":0},{"$f":"+IF('BS Liab'!AC16>0,'BS Assets'!AC15/'BS Liab'!AC16,\"\")","v":""},{"$f":"+IF('BS Liab'!AD16>0,'BS Assets'!AD15/'BS Liab'!AD16,\"\")","v":""},{"$f":"IF(AND(AD52<>\"\", AC52<>\"\"), AD52-AC52,0)","v":0},{"$f":"+IF('BS Liab'!AF16>0,'BS Assets'!AF15/'BS Liab'!AF16,\"\")","v":""},{"$f":"+IF('BS Liab'!AG16>0,'BS Assets'!AG15/'BS Liab'!AG16,\"\")","v":""},{"$f":"IF(AND(AG52<>\"\", AF52<>\"\"), AG52-AF52,0)","v":0},{"$f":"+IF('BS Liab'!AI16>0,'BS Assets'!AI15/'BS Liab'!AI16,\"\")","v":""},{"$f":"+IF('BS Liab'!AJ16>0,'BS Assets'!AJ15/'BS Liab'!AJ16,\"\")","v":""},{"$f":"IF(AND(AJ52<>\"\", AI52<>\"\"), AJ52-AI52,0)","v":0},{"$f":"+IF('BS Liab'!AL16>0,'BS Assets'!AL15/'BS Liab'!AL16,\"\")","v":""},{"$f":"+IF('BS Liab'!AM16>0,'BS Assets'!AM15/'BS Liab'!AM16,\"\")","v":""},{"$f":"IF(AND(AM52<>\"\", AL52<>\"\"), AM52-AL52,0)","v":0}]
[null,"Working Capital (Current Assets - Current Liabilities)",null,null,null,{"$f":"IF('BS Assets'!F15>0,'BS Assets'!F15-'BS Liab'!F16,\"\")","v":""},{"$f":"IF('BS Assets'!G15>0,'BS Assets'!G15-'BS Liab'!G16,\"\")","v":""},{"$f":"IF('BS Assets'!H15>0,'BS Assets'!H15-'BS Liab'!H16,\"\")","v":""},{"$f":"IF('BS Assets'!I15>0,'BS Assets'!I15-'BS Liab'!I16,\"\")","v":""},{"$f":"IF('BS Assets'!J15>0,'BS Assets'!J15-'BS Liab'!J16,\"\")","v":""},{"$f":"IF('BS Assets'!K15>0,'BS Assets'!K15-'BS Liab'!K16,\"\")","v":""},{"$f":"IF('BS Assets'!L15>0,'BS Assets'!L15-'BS Liab'!L16,\"\")","v":""},0,{"$f":"IF('BS Assets'!N15>0,'BS Assets'!N15-'BS Liab'!N16,\"\")","v":""},{"$f":"IF('BS Assets'!O15>0,'BS Assets'!O15-'BS Liab'!O16,\"\")","v":""},0,{"$f":"IF('BS Assets'!Q15>0,'BS Assets'!Q15-'BS Liab'!Q16,\"\")","v":""},{"$f":"IF('BS Assets'!R15>0,'BS Assets'!R15-'BS Liab'!R16,\"\")","v":""},0,{"$f":"IF('BS Assets'!T15>0,'BS Assets'!T15-'BS Liab'!T16,\"\")","v":""},{"$f":"IF('BS Assets'!U15>0,'BS Assets'!U15-'BS Liab'!U16,\"\")","v":""},0,{"$f":"IF('BS Assets'!W15>0,'BS Assets'!W15-'BS Liab'!W16,\"\")","v":""},{"$f":"IF('BS Assets'!X15>0,'BS Assets'!X15-'BS Liab'!X16,\"\")","v":""},0,{"$f":"IF('BS Assets'!Z15>0,'BS Assets'!Z15-'BS Liab'!Z16,\"\")","v":""},{"$f":"IF('BS Assets'!AA15>0,'BS Assets'!AA15-'BS Liab'!AA16,\"\")","v":""},0,{"$f":"IF('BS Assets'!AC15>0,'BS Assets'!AC15-'BS Liab'!AC16,\"\")","v":""},{"$f":"IF('BS Assets'!AD15>0,'BS Assets'!AD15-'BS Liab'!AD16,\"\")","v":""},0,{"$f":"IF('BS Assets'!AF15>0,'BS Assets'!AF15-'BS Liab'!AF16,\"\")","v":""},{"$f":"IF('BS Assets'!AG15>0,'BS Assets'!AG15-'BS Liab'!AG16,\"\")","v":""},0,{"$f":"IF('BS Assets'!AI15>0,'BS Assets'!AI15-'BS Liab'!AI16,\"\")","v":""},{"$f":"IF('BS Assets'!AJ15>0,'BS Assets'!AJ15-'BS Liab'!AJ16,\"\")","v":""},0,{"$f":"IF('BS Assets'!AL15>0,'BS Assets'!AL15-'BS Liab'!AL16,\"\")","v":""},{"$f":"IF('BS Assets'!AM15>0,'BS Assets'!AM15-'BS Liab'!AM16,\"\")","v":""},0]
[null,"Debt-to-Equity Ratio (Total Liabilities / Total Net Assets)",null,null,null,{"$f":"IF('BS Liab'!F28>0,('BS Liab'!F16+'BS Liab'!F23)/'BS Liab'!F28,\"\")","v":""},{"$f":"IF('BS Liab'!G28>0,('BS Liab'!G16+'BS Liab'!G23)/'BS Liab'!G28,\"\")","v":""},{"$f":"IF('BS Liab'!H28>0,('BS Liab'!H16+'BS Liab'!H23)/'BS Liab'!H28,\"\")","v":""},{"$f":"IF('BS Liab'!I28>0,('BS Liab'!I16+'BS Liab'!I23)/'BS Liab'!I28,\"\")","v":""},{"$f":"IF('BS Liab'!J28>0,('BS Liab'!J16+'BS Liab'!J23)/'BS Liab'!J28,\"\")","v":""},{"$f":"IF('BS Liab'!K28>0,('BS Liab'!K16+'BS Liab'!K23)/'BS Liab'!K28,\"\")","v":""},{"$f":"IF('BS Liab'!L28>0,('BS Liab'!L16+'BS Liab'!L23)/'BS Liab'!L28,\"\")","v":""},0,{"$f":"IF('BS Liab'!N28>0,('BS Liab'!N16+'BS Liab'!N23)/'BS Liab'!N28,\"\")","v":""},{"$f":"IF('BS Liab'!O28>0,('BS Liab'!O16+'BS Liab'!O23)/'BS Liab'!O28,\"\")","v":""},0,{"$f":"IF('BS Liab'!Q28>0,('BS Liab'!Q16+'BS Liab'!Q23)/'BS Liab'!Q28,\"\")","v":""},{"$f":"IF('BS Liab'!R28>0,('BS Liab'!R16+'BS Liab'!R23)/'BS Liab'!R28,\"\")","v":""},0,{"$f":"IF('BS Liab'!T28>0,('BS Liab'!T16+'BS Liab'!T23)/'BS Liab'!T28,\"\")","v":""},{"$f":"IF('BS Liab'!U28>0,('BS Liab'!U16+'BS Liab'!U23)/'BS Liab'!U28,\"\")","v":""},0,{"$f":"IF('BS Liab'!W28>0,('BS Liab'!W16+'BS Liab'!W23)/'BS Liab'!W28,\"\")","v":""},{"$f":"IF('BS Liab'!X28>0,('BS Liab'!X16+'BS Liab'!X23)/'BS Liab'!X28,\"\")","v":""},0,{"$f":"IF('BS Liab'!Z28>0,('BS Liab'!Z16+'BS Liab'!Z23)/'BS Liab'!Z28,\"\")","v":""},{"$f":"IF('BS Liab'!AA28>0,('BS Liab'!AA16+'BS Liab'!AA23)/'BS Liab'!AA28,\"\")","v":""},0,{"$f":"IF('BS Liab'!AC28>0,('BS Liab'!AC16+'BS Liab'!AC23)/'BS Liab'!AC28,\"\")","v":""},{"$f":"IF('BS Liab'!AD28>0,('BS Liab'!AD16+'BS Liab'!AD23)/'BS Liab'!AD28,\"\")","v":""},0,{"$f":"IF('BS Liab'!AF28>0,('BS Liab'!AF16+'BS Liab'!AF23)/'BS Liab'!AF28,\"\")","v":""},{"$f":"IF('BS Liab'!AG28>0,('BS Liab'!AG16+'BS Liab'!AG23)/'BS Liab'!AG28,\"\")","v":""},0,{"$f":"IF('BS Liab'!AI28>0,('BS Liab'!AI16+'BS Liab'!AI23)/'BS Liab'!AI28,\"\")","v":""},{"$f":"IF('BS Liab'!AJ28>0,('BS Liab'!AJ16+'BS Liab'!AJ23)/'BS Liab'!AJ28,\"\")","v":""},0,{"$f":"IF('BS Liab'!AL28>0,('BS Liab'!AL16+'BS Liab'!AL23)/'BS Liab'!AL28,\"\")","v":""},{"$f":"IF('BS Liab'!AM28>0,('BS Liab'!AM16+'BS Liab'!AM23)/'BS Liab'!AM28,\"\")","v":""},0]
[null,"Operating Profit Margins (Operating Profit/Total Revenue)",null,null,null,{"$f":"IF(('Income Statement'!F12-'Income Statement'!F11)>0,(('Income Statement'!F12-'Income Statement'!F11)-'Income Statement'!F28)/('Income Statement'!F12-'Income Statement'!F11),\"\")","v":""},{"$f":"IF(('Income Statement'!G12-'Income Statement'!G11)>0,(('Income Statement'!G12-'Income Statement'!G11)-'Income Statement'!G28)/('Income Statement'!G12-'Income Statement'!G11),\"\")","v":""},{"$f":"IF(('Income Statement'!H12-'Income Statement'!H11)>0,(('Income Statement'!H12-'Income Statement'!H11)-'Income Statement'!H28)/('Income Statement'!H12-'Income Statement'!H11),\"\")","v":""},{"$f":"IF(('Income Statement'!I12-'Income Statement'!I11)>0,(('Income Statement'!I12-'Income Statement'!I11)-'Income Statement'!I28)/('Income Statement'!I12-'Income Statement'!I11),\"\")","v":""},{"$f":"IF(('Income Statement'!J12-'Income Statement'!J11)>0,(('Income Statement'!J12-'Income Statement'!J11)-'Income Statement'!J28)/('Income Statement'!J12-'Income Statement'!J11),\"\")","v":""},{"$f":"IF(('Income Statement'!K12-'Income Statement'!K11)>0,(('Income Statement'!K12-'Income Statement'!K11)-'Income Statement'!K28)/('Income Statement'!K12-'Income Statement'!K11),\"\")","v":""},{"$f":"IF(('Income Statement'!L12-'Income Statement'!L11)>0,(('Income Statement'!L12-'Income Statement'!L11)-'Income Statement'!L28)/('Income Statement'!L12-'Income Statement'!L11),\"\")","v":""},0,{"$f":"IF(('Income Statement'!O12-'Income Statement'!O11)>0,(('Income Statement'!O12-'Income Statement'!O11)-'Income Statement'!O28)/('Income Statement'!O12-'Income Statement'!O11),\"\")","v":""},{"$f":"IF(('Income Statement'!P12-'Income Statement'!P11)>0,(('Income Statement'!P12-'Income Statement'!P11)-'Income Statement'!P28)/('Income Statement'!P12-'Income Statement'!P11),\"\")","v":""},0,{"$f":"IF(('Income Statement'!S12-'Income Statement'!S11)>0,(('Income Statement'!S12-'Income Statement'!S11)-'Income Statement'!S28)/('Income Statement'!S12-'Income Statement'!S11),\"\")","v":""},{"$f":"IF(('Income Statement'!T12-'Income Statement'!T11)>0,(('Income Statement'!T12-'Income Statement'!T11)-'Income Statement'!T28)/('Income Statement'!T12-'Income Statement'!T11),\"\")","v":""},0,{"$f":"IF(('Income Statement'!W12-'Income Statement'!W11)>0,(('Income Statement'!W12-'Income Statement'!W11)-'Income Statement'!W28)/('Income Statement'!W12-'Income Statement'!W11),\"\")","v":""},{"$f":"IF(('Income Statement'!X12-'Income Statement'!X11)>0,(('Income Statement'!X12-'Income Statement'!X11)-'Income Statement'!X28)/('Income Statement'!X12-'Income Statement'!X11),\"\")","v":""},0,{"$f":"IF(('Income Statement'!AA12-'Income Statement'!AA11)>0,(('Income Statement'!AA12-'Income Statement'!AA11)-'Income Statement'!AA28)/('Income Statement'!AA12-'Income Statement'!AA11),\"\")","v":""},{"$f":"IF(('Income Statement'!AB12-'Income Statement'!AB11)>0,(('Income Statement'!AB12-'Income Statement'!AB11)-'Income Statement'!AB28)/('Income Statement'!AB12-'Income Statement'!AB11),\"\")","v":""},0,{"$f":"IF(('Income Statement'!AE12-'Income Statement'!AE11)>0,(('Income Statement'!AE12-'Income Statement'!AE11)-'Income Statement'!AE28)/('Income Statement'!AE12-'Income Statement'!AE11),\"\")","v":""},{"$f":"IF(('Income Statement'!AF12-'Income Statement'!AF11)>0,(('Income Statement'!AF12-'Income Statement'!AF11)-'Income Statement'!AF28)/('Income Statement'!AF12-'Income Statement'!AF11),\"\")","v":""},0,{"$f":"IF(('Income Statement'!AI12-'Income Statement'!AI11)>0,(('Income Statement'!AI12-'Income Statement'!AI11)-'Income Statement'!AI28)/('Income Statement'!AI12-'Income Statement'!AI11),\"\")","v":""},{"$f":"IF(('Income Statement'!AJ12-'Income Statement'!AJ11)>0,(('Income Statement'!AJ12-'Income Statement'!AJ11)-'Income Statement'!AJ28)/('Income Statement'!AJ12-'Income Statement'!AJ11),\"\")","v":""},0,{"$f":"IF(('Income Statement'!AM12-'Income Statement'!AM11)>0,(('Income Statement'!AM12-'Income Statement'!AM11)-'Income Statement'!AM28)/('Income Statement'!AM12-'Income Statement'!AM11),\"\")","v":""},{"$f":"IF(('Income Statement'!AN12-'Income Statement'!AN11)>0,(('Income Statement'!AN12-'Income Statement'!AN11)-'Income Statement'!AN28)/('Income Statement'!AN12-'Income Statement'!AN11),\"\")","v":""},0,{"$f":"IF(('Income Statement'!AQ12-'Income Statement'!AQ11)>0,(('Income Statement'!AQ12-'Income Statement'!AQ11)-'Income Statement'!AQ28)/('Income Statement'!AQ12-'Income Statement'!AQ11),\"\")","v":""},{"$f":"IF(('Income Statement'!AR12-'Income Statement'!AR11)>0,(('Income Statement'!AR12-'Income Statement'!AR11)-'Income Statement'!AR28)/('Income Statement'!AR12-'Income Statement'!AR11),\"\")","v":""},0,{"$f":"IF(('Income Statement'!AU12-'Income Statement'!AU11)>0,(('Income Statement'!AU12-'Income Statement'!AU11)-'Income Statement'!AU28)/('Income Statement'!AU12-'Income Statement'!AU11),\"\")","v":""},{"$f":"IF(('Income Statement'!AV12-'Income Statement'!AV11)>0,(('Income Statement'!AV12-'Income Statement'!AV11)-'Income Statement'!AV28)/('Income Statement'!AV12-'Income Statement'!AV11),\"\")","v":""},0]

{"sheet":"Definitions","index":5,"n_rows":68,"n_cols":29,"rows_kept":68,"cut":false,"hidden":false,"merged":[[38,1,38,28],[32,1,32,28],[33,1,33,28],[34,1,34,28],[35,1,35,28],[37,1,37,28],[27,1,27,28],[28,1,28,28],[29,1,29,28],[30,1,30,28],[31,1,31,28],[20,1,20,28],[22,1,22,28],[23,1,23,28],[24,1,24,28],[26,1,26,28],[14,1,14,28],[15,1,15,28],[16,1,16,28],[18,1,18,28],[19,1,19,28],[1,0,5,28],[12,1,12,28],[13,1,13,28],[9,1,9,28],[10,1,10,28],[11,1,11,28]]}
["←","Definitions of Terms",null,null,null,{"$f":"COLUMN()","v":6},{"$f":"COLUMN()","v":7},{"$f":"COLUMN()","v":8},{"$f":"COLUMN()","v":9},{"$f":"COLUMN()","v":10},{"$f":"COLUMN()","v":11},{"$f":"COLUMN()","v":12},{"$f":"COLUMN()","v":13},{"$f":"COLUMN()","v":14},{"$f":"COLUMN()","v":15},{"$f":"COLUMN()","v":16},{"$f":"COLUMN()","v":17},{"$f":"COLUMN()","v":18},{"$f":"COLUMN()","v":19},{"$f":"COLUMN()","v":20},{"$f":"COLUMN()","v":21},{"$f":"COLUMN()","v":22},{"$f":"COLUMN()","v":23},{"$f":"COLUMN()","v":24},{"$f":"COLUMN()","v":25},{"$f":"COLUMN()","v":26},{"$f":"COLUMN()","v":27},{"$f":"COLUMN()","v":28},{"$f":"COLUMN()","v":29}]
["The definitions for the following accounts should be followed when filling out the application and all submissions to the New York State Department of Health. The common set of account principals, standards and procedures that companies, hospitals, and facilities use to compile their financial statements.  GAAP are a combination of authoritative standards, prouncements, opinions and FASB Interpretations under the Statement on Auditing Standards (SAS #69), and simply the commonly accepted ways of recording and reporting accounting information.  (Please be advised that any distortions or unscrupulous deviations from GAAP will be heavily scrutinized and may cause the discontinuation of grant funds.)"]
[]
[]
[]
[]
[]
["Balance Sheet Accounts:"]
["Current Assets"]
[null,"Cash and Cash Equivalents - It is the most liquid asset, which includes currency, deposit accounts, and negotiable instruments."]
[null,"Malpractice/Savings Funds – The amount of the Malpractice funds that are needed and restricted to a Malpractice Fund which is current and possible liquid."]
[null,"Patient Accounts Receivable (net of uncollectable) - usually reported as net of allowance for non-collectable accounts."]
[null,"Accounts Receivable (Grants & Other) – Money that is current that is booked, allocated and foreseeable in the short term.  Usually accompanied by a document that indicates award or allocation is going to be made."]
[null,"Due from Third Parties (Accounts Receivable) – Booked current assets that are current and owed to the facility from a non-patient source.  "]
[null,"Inventories - trading these assets is a normal business of a company. The inventory value reported on the balance sheet is usually the historical cost or fair market value, whichever is lower. This is known as the \"lower of cost or market\" rule."]
[null,"Prepaid and other current assets – these are expenses paid in cash and recorded as assets before they are used or consumed."]
[null,"Assets limited as to use-current portion – This is defined as a current asset that are restricted to use and not available to be used for other purposes except for what it was intended.  "]
["Fixed (Long-Term) Assets"]
[null,"Marketable Securities under bond indenture - Bonds secured by trust indenture; provisions in resolution or trust indenture; annual audit; pledging eligible marketable securities as collateral security."]
[null,"Self-Insured Malpractice Insured Fund – Mandatory funding used to self-insure funds."]
[null,"Board Designated Investments – Endowment or Board Designated funds, usually not restricted. "]
["Other Assets"]
[null,"Deferred Financing Costs - Costs incurred in connection with financing activities are deferred and amortized over the terms of the related debt agreements."]
[null,"Property, Buildings and Equipment-net - A company asset that is vital to business operations but cannot be easily liquidated. The value of property, plant and equipment is typically depreciated."]
[null,"Other Long Term Assets - Long-term assets are those held on a company's balance sheet for more than one year."]
["CURRENT LIABILITIES"]
[null,"Accounts Payable - Accounts payable is the debt a business owes for goods or services."]
[null,"Other Accrued Expenses – Other liabilities or obligations payable."]
[null,"Accrued Salaries and related withholdings – Salaries/Benefits/taxes."]
[null,"Accrued Pension Payable – The amount the company records on the balance sheet to allocate for the total amount of money involved in company pension plans."]
[null,"Accrued Interest Payable - Interest payable is the interest that has not yet been paid to the customer on the deposit."]
[null,"Current Portion of Long Term Debt - A portion of the balance sheet that represents the total amount of long-term debt that must be paid within the next year."]
[null,"Due to third party payers – The current portion of monies owned."]
[null,"Current portion of estimated professional liabilities – The current portion of professional liability due."]
[null,"Due to (From) related organizations – An interagency transfer of funds from related companies."]
[null,"Deferred Revenue - Deferred revenue is not yet revenue. It is an amount that was received by a company in advance of earning. "]
["NONCURRENT LIABILITIES"]
[null,"Long-Term debt, less current installments – Noncurrent portion of long-term debt including capital leases, and mortgage notes payable."]
[null,"Estimated Professional Liabilities, Less Current Portion – The cost of insuring one self, taxes, staff, etc."]
["INCOME STATEMENT"]
["REVENUE"]
[null,"Patient Service Revenue – Revenue earned from patient services minus free care."]
[null,"Provisions for Bad Debt (Negative) – The allocation un-paid amounts that are earned. "]
[null,"Net Patient Revenues – The amount of actual revenue after Bad Debt and free care are subtracted."]
[null,"Other Operating Revenues – Hospitals activities related to ongoing business activities, café, garage, space equipment rental, gift shop."]
[null,"Non-operating Revenues - Grants, endowments and donations. Money received from foundations and parent affiliations, etc."]
[null,"Total Revenue – The total amount of revenue the Hospital receives."]
["OPERATING EXPENSES (Expenses in the normal course of business)."]
[null,"Salaries and Wages"]
[null,"Employee Benefits"]
[null,"Physician Fees"]
[null,"Contract Labor/Purchased Services - Contract labor and vendor related expenses which contribute to day-to-day operations; do not include consultant fees."]
[null,"Consultant fees -Not part of the day-to-day operations of the facility, e.g. auditors, attorneys, architects etc."]
[null,"Utilities"]
[null,"Lease/Rental"]
[null,"Repairs/Maintenance"]
[null,"Medical Supplies"]
[null,"Other Supplies"]
[null,"Other Expenses"]
[null,"Other Insurance & Estimated Malpractice"]
[null,"Interest & Mortgage Fees"]
[null,"Depreciation & Amortization"]
[null,"OPERATING INCOME/LOSS  (Total Revenue – Operating Expenses)"]
[null,"Non-operating Gain/Losses (Other Revenues and Expenses, please list on separate page)"]
[null,"Net increase in unrestricted net assets"]
[null,"Fund Balance/Equity - The net worth of a fund, measured by total assets minus total liabilities."]
[null,"Net Deficit in unrestricted fund balance"]
[null,"Net Assets gain/ Deficiency"]

{"sheet":"Explanation Sheet","index":6,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Use this sheet to provide any additional explanations regarding information in the previous sheets"]

{"sheet":"Reconciliation","index":7,"n_rows":37,"n_cols":11,"rows_kept":37,"cut":false,"hidden":true,"merged":[[32,2,32,4],[33,2,33,4],[34,2,34,4],[35,2,35,4],[36,2,36,4],[31,2,31,4],[26,2,26,4],[27,2,27,4],[28,2,28,4],[29,2,29,4],[30,2,30,4]]}
[]
[null,null,"Reconciliation Sheet"]
[]
[null,"2014-06-30","2014-07-31","2014-08-31","2014-09-30","2014-10-31","2014-11-30","2014-12-31","2015-01-31","2015-02-28","2015-03-31"]
["Total IAAF Award Left",null,{"$f":"B21","v":0},0,0,0,0,0,0,0,0]
["Projected Monthly IAAF Award Need"]
["Projected Monthly Award plus last month's adjustment",{"$f":"B6","v":0},{"$f":"C6+B17","v":0},0,0,0,0,0,0,0,0]
[]
["Excess Revenue Over Expenses Less Depreciation",{"$f":"'Income Statement'!L36","v":0},{"$f":"'Income Statement'!P36","v":0},{"$f":"'Income Statement'!T36","v":0},{"$f":"'Income Statement'!X36","v":0},{"$f":"'Income Statement'!AB36","v":0},{"$f":"'Income Statement'!AF36","v":0},{"$f":"'Income Statement'!AJ36","v":0},{"$f":"'Income Statement'!AN36","v":0},{"$f":"'Income Statement'!AR36","v":0},{"$f":"'Income Statement'!AV36","v":0}]
["Actual Monthly IAAF Award Need",{"$f":"IF(B9>0,0,(IF(ABS(B9)<B7,ABS(B9),B7)))","v":0},0,0,0,0,0,0,0,0,0]
[]
["Adjusted Monthly Payment before Reviewer adjustment",{"$f":"B10","v":0},0,0,0,0,0,0,0,0,0]
["Reviewer's Adjustment"]
["Adjusted Actual monthly payment with reviewer adjustment",{"$f":"+B12+B13","v":0},0,0,0,0,0,0,0,{"$f":"+J12+J13","v":0},0]
["Difference in IAAF Need",{"$f":"B14-B7","v":0},0,0,0,0,0,0,0,0,0]
[]
["Next Months Payment Adjustment (Carried forward)",{"$f":"-B15","v":0},{"$f":"-C15","v":0},{"$f":"-D15","v":0},{"$f":"-E15","v":0},{"$f":"-F15","v":0},{"$f":"-G15","v":0},{"$f":"-H15","v":0},{"$f":"-I15","v":0},{"$f":"-J15","v":0},{"$f":"-K15","v":0}]
[]
["IAAF Award Remaining Projected",{"$f":"B5-B6","v":0},{"$f":"B19-C6","v":0},{"$f":"C19-D6","v":0},{"$f":"D19-E6","v":0},{"$f":"E19-F6","v":0},{"$f":"F19-G6","v":0},{"$f":"G19-H6","v":0},{"$f":"H19-I6","v":0},{"$f":"I19-J6","v":0},{"$f":"J19-K6","v":0}]
["IAAF Award Given to Date",{"$f":"B14","v":0},{"$f":"B20+C14","v":0},{"$f":"C20+D14","v":0},{"$f":"D20+E14","v":0},{"$f":"E20+F14","v":0},{"$f":"F20+G14","v":0},{"$f":"G20+H14","v":0},{"$f":"H20+I14","v":0},{"$f":"I20+J14","v":0},{"$f":"J20+K14","v":0}]
["IAAF Award Remaining Actual",{"$f":"$B$5-B20","v":0},{"$f":"$B$5-C20","v":0},{"$f":"$B$5-D20","v":0},{"$f":"$B$5-E20","v":0},{"$f":"$B$5-F20","v":0},{"$f":"$B$5-G20","v":0},{"$f":"$B$5-H20","v":0},{"$f":"$B$5-I20","v":0},{"$f":"$B$5-J20","v":0},{"$f":"$B$5-K20","v":0}]
[]
["DASNY Payments made"]
[]
[]
["Notes For Reviewer Adjustment"]
["Month","Amount","Explanation"]
[{"$f":"B4","v":"2014-06-30"},{"$f":"B13","v":0}]
[{"$f":"C4","v":"2014-07-31"},{"$f":"C13","v":0}]
[{"$f":"D4","v":"2014-08-31"},{"$f":"D13","v":0}]
[{"$f":"E4","v":"2014-09-30"},{"$f":"E13","v":0}]
[{"$f":"F4","v":"2014-10-31"},{"$f":"F13","v":0}]
[{"$f":"G4","v":"2014-11-30"},{"$f":"G13","v":0}]
[{"$f":"H4","v":"2014-12-31"},{"$f":"H13","v":0}]
[{"$f":"I4","v":"2015-01-31"},{"$f":"I13","v":0}]
[{"$f":"J4","v":"2015-02-28"},{"$f":"J13","v":0}]
[{"$f":"K4","v":"2015-03-31"},{"$f":"K13","v":0}]