1"use strict";(self.webpackChunk_N_E=self.webpackChunk_N_E||[]).push([[8565],{58565:function(e,a,t){t.r(a),t.d(a,{ProformaSpreadsheet:function(){return g}});var r=t(57437),o=t(2265),n=t(62012),s=t(75701),i=t(15239),p=t(70797);t(95636);var d=t(93e3);let c=[{code:"4000",name:"Revenue",category:"revenue",isHeader:!0,isTotal:!1,ppdEligible:!1,formatType:"currency"},{code:"4100",name:"Non-Skilled Revenue",category:"revenue",subcategory:"non_skilled",isHeader:!0,isTotal:!1,ppdEligible:!1,formatType:"currency"},{code:"4110",name:"Medicaid Revenue",shortName:"Medicaid",category:"revenue",subcategory:"non_skilled",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"non_skilled_days",formatType:"currency",mappingKeys:["medicaid_revenue","medicaid_daily_rate","mcaid_rev"]},{code:"4120",name:"Managed Medicaid Revenue",shortName:"Mngd Medicaid",category:"revenue",subcategory:"non_skilled",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"non_skilled_days",formatType:"currency",mappingKeys:["managed_medicaid","mco_medicaid","mngd_mcaid"]},{code:"4130",name:"Private Pay Revenue",shortName:"Private",category:"revenue",subcategory:"non_skilled",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"non_skilled_days",formatType:"currency",mappingKeys:["private_pay","private_revenue","private"]},{code:"4140",name:"Veterans Revenue",shortName:"VA",category:"revenue",subcategory:"non_skilled",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"non_skilled_days",formatType:"currency",mappingKeys:["va_revenue","veterans","va"]},{code:"4150",name:"Hospice Revenue",shortName:"Hospice",category:"revenue",subcategory:"non_skilled",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"non_skilled_days",formatType:"currency",mappingKeys:["hospice_revenue","hospice"]},{code:"4199",name:"Total Non-Skilled Revenue",shortName:"Tot Non-Skill",category:"revenue",subcategory:"non_skilled",isHeader:!1,isTotal:!0,parentCode:"4100",ppdEligible:!0,ppdDenominator:"non_skilled_days",formatType:"currency"},{code:"4200",name:"Skilled Revenue",category:"revenue",subcategory:"skilled",isHeader:!0,isTotal:!1,ppdEligible:!1,formatType:"currency"},{code:"4210",name:"Medicare Part A Revenue",shortName:"Medicare A",category:"revenue",subcategory:"skilled",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"skilled_days",formatType:"currency",mappingKeys:["medicare_revenue","medicare_a","mcr_part_a","pdpm"]},{code:"4215",name:"Medicare Advantage Revenue",shortName:"Medicare Adv",category:"revenue",subcategory:"skilled",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"skilled_days",formatType:"currency",mappingKeys:["medicare_advantage","ma_revenue","mcr_advantage"]},{code:"4220",name:"Managed Medicaid Revenue - Skilled",shortName:"Mngd Mcaid Sk",category:"revenue",subcategory:"skilled",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"skilled_days",formatType:"currency",mappingKeys:["managed_medicaid_skilled","mco_skilled"]},{code:"4230",name:"Medicaid Complex Care Revenue",shortName:"Mcaid Complex",category:"revenue",subcategory:"skilled",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"skilled_days",formatType:"currency",mappingKeys:["medicaid_complex","complex_care"]},{code:"4235",name:"Medicaid Bariatric Revenue",shortName:"Mcaid Bariatric",category:"revenue",subcategory:"skilled",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"skilled_days",formatType:"currency",mappingKeys:["medicaid_bariatric","bariatric"]},{code:"4240",name:"Veterans Revenue - Skilled",shortName:"VA Skilled",category:"revenue",subcategory:"skilled",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"skilled_days",formatType:"currency",mappingKeys:["va_skilled","veterans_skilled"]},{code:"4250",name:"HMO/Commercial Insurance Revenue",shortName:"HMO/Comm",category:"revenue",subcategory:"skilled",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"skilled_days",formatType:"currency",mappingKeys:["hmo_revenue","commercial","insurance"]},{code:"4260",name:"ISNP Revenue",shortName:"ISNP",category:"revenue",subcategory:"skilled",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"skilled_days",formatType:"currency",mappingKeys:["isnp_revenue","isnp"]},{code:"4299",name:"Total Skilled Revenue",shortName:"Tot Skilled",category:"revenue",subcategory:"skilled",isHeader:!1,isTotal:!0,parentCode:"4200",ppdEligible:!0,ppdDenominator:"skilled_days",formatType:"currency"},{code:"4300",name:"Vent/Trach Revenue",category:"revenue",subcategory:"vent",isHeader:!0,isTotal:!1,ppdEligible:!1,formatType:"currency"},{code:"4310",name:"Medicaid Revenue - Vent",shortName:"Mcaid Vent",category:"revenue",subcategory:"vent",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"vent_days",formatType:"currency",mappingKeys:["medicaid_vent","vent_medicaid"]},{code:"4320",name:"Managed Medicaid Revenue - Vent",shortName:"Mngd Mcaid Vent",category:"revenue",subcategory:"vent",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"vent_days",formatType:"currency",mappingKeys:["managed_medicaid_vent","mco_vent"]},{code:"4330",name:"Private Revenue - Vent",shortName:"Private Vent",category:"revenue",subcategory:"vent",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"vent_days",formatType:"currency",mappingKeys:["private_vent"]},{code:"4340",name:"Veterans Revenue - Vent",shortName:"VA Vent",category:"revenue",subcategory:"vent",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"vent_days",formatType:"currency",mappingKeys:["va_vent","veterans_vent"]},{code:"4350",name:"Hospice Revenue - Vent",shortName:"Hospice Vent",category:"revenue",subcategory:"vent",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"vent_days",formatType:"currency",mappingKeys:["hospice_vent"]},{code:"4360",name:"Medicare Revenue - Vent",shortName:"Medicare Vent",category:"revenue",subcategory:"vent",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"vent_days",formatType:"currency",mappingKeys:["medicare_vent"]}
1,{code:"4370",name:"HMO Revenue - Vent",shortName:"HMO Vent",category:"revenue",subcategory:"vent",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"vent_days",formatType:"currency",mappingKeys:["hmo_vent"]},{code:"4399",name:"Total Vent Revenue",shortName:"Tot Vent",category:"revenue",subcategory:"vent",isHeader:!1,isTotal:!0,parentCode:"4300",ppdEligible:!0,ppdDenominator:"vent_days",formatType:"currency"},{code:"4400",name:"Other Revenue",category:"revenue",subcategory:"other_revenue",isHeader:!0,isTotal:!1,ppdEligible:!1,formatType:"currency"},{code:"4410",name:"Medicare Part B Revenue",shortName:"Medicare B",category:"revenue",subcategory:"other_revenue",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["medicare_b","mcr_part_b","part_b"]},{code:"4415",name:"Telehealth Revenue - MCR B",shortName:"Telehealth",category:"revenue",subcategory:"other_revenue",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["telehealth","telehealth_revenue"]},{code:"4420",name:"Therapy - Outpatient Revenue",shortName:"Outpt Therapy",category:"revenue",subcategory:"other_revenue",isHeader:!1,isTotal:!1,ppdEligible:!1,formatType:"currency",mappingKeys:["outpatient_therapy","op_therapy"]},{code:"4430",name:"UPL/Quality Enhancement Revenue",shortName:"UPL/QE",category:"revenue",subcategory:"other_revenue",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["upl","quality_enhancement","igp"]},{code:"4440",name:"COVID Expense Reimbursement",shortName:"COVID Reimb",category:"revenue",subcategory:"other_revenue",isHeader:!1,isTotal:!1,ppdEligible:!1,formatType:"currency",mappingKeys:["covid_reimbursement","prf","provider_relief"]},{code:"4450",name:"State/Federal COVID Grants",shortName:"COVID Grants",category:"revenue",subcategory:"other_revenue",isHeader:!1,isTotal:!1,ppdEligible:!1,formatType:"currency",mappingKeys:["covid_grants","state_covid"]},{code:"4460",name:"Interest Income",shortName:"Interest Inc",category:"revenue",subcategory:"other_revenue",isHeader:!1,isTotal:!1,ppdEligible:!1,formatType:"currency",mappingKeys:["interest_income"]},{code:"4470",name:"Miscellaneous Revenue",shortName:"Misc Rev",category:"revenue",subcategory:"other_revenue",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["misc_revenue","other_revenue","sundry"]},{code:"4480",name:"Cafeteria/Gift Shop Revenue",shortName:"Cafe/Gift",category:"revenue",subcategory:"other_revenue",isHeader:!1,isTotal:!1,ppdEligible:!1,formatType:"currency",mappingKeys:["cafeteria","gift_shop"]},{code:"4499",name:"Total Other Revenue",shortName:"Tot Other Rev",category:"revenue",subcategory:"other_revenue",isHeader:!1,isTotal:!0,parentCode:"4400",ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency"},{code:"4999",name:"Total Revenue",shortName:"Total Rev",category:"revenue",isHeader:!1,isTotal:!0,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency"},{code:"5100",name:"Ancillary Expenses",category:"ancillary_expense",isHeader:!0,isTotal:!1,ppdEligible:!1,formatType:"currency"},{code:"5110",name:"Therapy Expenses",category:"ancillary_expense",subcategory:"therapy",isHeader:!0,isTotal:!1,ppdEligible:!1,formatType:"currency"},{code:"5111",name:"Therapy Wages - PT",shortName:"PT Wages",category:"ancillary_expense",subcategory:"therapy",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"skilled_days",formatType:"currency",mappingKeys:["pt_wages","physical_therapy_wages"]},{code:"5112",name:"Therapy Wages - OT",shortName:"OT Wages",category:"ancillary_expense",subcategory:"therapy",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"skilled_days",formatType:"currency",mappingKeys:["ot_wages","occupational_therapy_wages"]},{code:"5113",name:"Therapy Wages - SLP",shortName:"SLP Wages",category:"ancillary_expense",subcategory:"therapy",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"skilled_days",formatType:"currency",mappingKeys:["slp_wages","speech_therapy_wages"]},{code:"5114",name:"Therapy Wages - Assistants (PTA/COTA)",shortName:"Asst Wages",category:"ancillary_expense",subcategory:"therapy",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"skilled_days",formatType:"currency",mappingKeys:["pta_wages","cota_wages","assistant_wages"]},{code:"5115",name:"Therapy Benefits",shortName:"Therapy Ben",category:"ancillary_expense",subcategory:"therapy",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"skilled_days",formatType:"currency",mappingKeys:["therapy_benefits"]},{code:"5116",name:"Therapy Contract/Agency",shortName:"Therapy Contract",category:"ancillary_expense",subcategory:"therapy",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"skilled_days",formatType:"currency",mappingKeys:["therapy_contract","therapy_agency","contract_therapy"]},{code:"5117",name:"Therapy Supplies",shortName:"Therapy Suppl",category:"ancillary_expense",subcategory:"therapy",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"skilled_days",formatType:"currency",mappingKeys:["therapy_supplies"]},{code:"5118",name:"Therapy Other",shortName:"Therapy Other",category:"ancillary_expense",subcategory:"therapy",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"skilled_days",formatType:"currency",mappingKeys:["therapy_other","therapy_misc"]},{code:"5119",name:"Total Therapy Expenses",shortName:"Tot Therapy",category:"ancillary_expense",subcategory:"therapy",isHeader:!1,isTotal:!0,parentCode:"5110",ppdEligible:!0,ppdDenominator:"skilled_days",formatType:"currency"},{code:"5150",name:"Non-Therapy Ancillary",category:"ancillary_expense",subcategory:"non_therapy",isHeader:!0,isTotal:!1,ppdEligible:!1,formatType:"currency"},{code:"5151",name:"Pharmacy Expense",shortName:"Pharmacy",category:"ancillary_expense",subcategory:"non_therapy",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["pharmacy","drugs","medications"]}
1,{code:"5152",name:"Lab Expense",shortName:"Lab",category:"ancillary_expense",subcategory:"non_therapy",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["lab","laboratory"]},{code:"5153",name:"Radiology/X-Ray Expense",shortName:"Radiology",category:"ancillary_expense",subcategory:"non_therapy",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["radiology","xray","imaging"]},{code:"5154",name:"Oxygen/Respiratory Supplies",shortName:"O2/Resp",category:"ancillary_expense",subcategory:"non_therapy",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["oxygen","respiratory","o2"]},{code:"5155",name:"Medical Director Fees",shortName:"Med Director",category:"ancillary_expense",subcategory:"non_therapy",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["medical_director","med_director"]},{code:"5156",name:"Physician Services",shortName:"Physician Svc",category:"ancillary_expense",subcategory:"non_therapy",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["physician_services","doctor_fees"]},{code:"5157",name:"Dentist/Podiatrist/Optometry",shortName:"Dental/Pod/Opt",category:"ancillary_expense",subcategory:"non_therapy",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["dental","podiatry","optometry"]},{code:"5158",name:"Other Ancillary",shortName:"Other Ancillary",category:"ancillary_expense",subcategory:"non_therapy",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["other_ancillary"]},{code:"5159",name:"Total Non-Therapy Ancillary",shortName:"Tot Non-Ther",category:"ancillary_expense",subcategory:"non_therapy",isHeader:!1,isTotal:!0,parentCode:"5150",ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency"},{code:"5199",name:"Total Ancillary Expenses",shortName:"Tot Ancillary",category:"ancillary_expense",isHeader:!1,isTotal:!0,parentCode:"5100",ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency"},{code:"5200",name:"Nursing Expenses",category:"nursing_expense",isHeader:!0,isTotal:!1,ppdEligible:!1,formatType:"currency"},{code:"5210",name:"Nursing Wages - RN",shortName:"RN Wages",category:"nursing_expense",subcategory:"wages",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["rn_wages","registered_nurse_wages"]},{code:"5211",name:"Nursing Wages - LPN/LVN",shortName:"LPN Wages",category:"nursing_expense",subcategory:"wages",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["lpn_wages","lvn_wages"]},{code:"5212",name:"Nursing Wages - CNA/Aide",shortName:"CNA Wages",category:"nursing_expense",subcategory:"wages",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["cna_wages","aide_wages","nursing_aide"]},{code:"5213",name:"Nursing Wages - DON/ADON",shortName:"DON Wages",category:"nursing_expense",subcategory:"wages",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["don_wages","adon_wages","nursing_admin"]},{code:"5214",name:"Nursing Wages - Unit Clerks/Other",shortName:"Clerk Wages",category:"nursing_expense",subcategory:"wages",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["unit_clerk_wages","nursing_clerk"]},{code:"5220",name:"Nursing Benefits",shortName:"Nursing Ben",category:"nursing_expense",subcategory:"benefits",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["nursing_benefits"]},{code:"5221",name:"Nursing Payroll Taxes",shortName:"Nursing PR Tax",category:"nursing_expense",subcategory:"benefits",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["nursing_payroll_tax"]},{code:"5230",name:"Nursing Agency/Contract - RN",shortName:"Agency RN",category:"nursing_expense",subcategory:"agency",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["agency_rn","contract_rn","travel_rn"]},{code:"5231",name:"Nursing Agency/Contract - LPN",shortName:"Agency LPN",category:"nursing_expense",subcategory:"agency",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["agency_lpn","contract_lpn","travel_lpn"]},{code:"5232",name:"Nursing Agency/Contract - CNA",shortName:"Agency CNA",category:"nursing_expense",subcategory:"agency",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["agency_cna","contract_cna","travel_cna"]},{code:"5240",name:"Nursing Purchased Services/Consulting",shortName:"Nurs Consulting",category:"nursing_expense",subcategory:"purchased_services",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["nursing_consulting","nursing_purchased"]},{code:"5250",name:"Nursing Patient Supplies - Incontinent",shortName:"Incont Suppl",category:"nursing_expense",subcategory:"supplies",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["incontinent_supplies","briefs","incontinence"]}
1,{code:"5251",name:"Nursing Patient Supplies - Wound Care",shortName:"Wound Suppl",category:"nursing_expense",subcategory:"supplies",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["wound_care","wound_supplies"]},{code:"5252",name:"Nursing Patient Supplies - IV/Tube Feeding",shortName:"IV/Tube Suppl",category:"nursing_expense",subcategory:"supplies",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["iv_supplies","tube_feeding","enteral"]},{code:"5253",name:"Nursing Patient Supplies - Other",shortName:"Other Suppl",category:"nursing_expense",subcategory:"supplies",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["other_nursing_supplies","nursing_supplies_other"]},{code:"5260",name:"Nursing Resource Fee",shortName:"Resource Fee",category:"nursing_expense",subcategory:"other",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["resource_fee","nursing_resource"]},{code:"5270",name:"Nursing Education/Training",shortName:"Nurs Training",category:"nursing_expense",subcategory:"other",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["nursing_training","nursing_education"]},{code:"5280",name:"Nursing Other",shortName:"Nursing Other",category:"nursing_expense",subcategory:"other",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["nursing_other","nursing_misc"]},{code:"5299",name:"Total Nursing Expenses",shortName:"Tot Nursing",category:"nursing_expense",isHeader:!1,isTotal:!0,parentCode:"5200",ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency"},{code:"5300",name:"Vent/Respiratory Expenses",category:"vent_expense",isHeader:!0,isTotal:!1,ppdEligible:!1,formatType:"currency"},{code:"5310",name:"Vent Wages - RN",shortName:"Vent RN Wages",category:"vent_expense",subcategory:"wages",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"vent_days",formatType:"currency",mappingKeys:["vent_rn_wages"]},{code:"5311",name:"Vent Wages - RT",shortName:"RT Wages",category:"vent_expense",subcategory:"wages",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"vent_days",formatType:"currency",mappingKeys:["rt_wages","respiratory_therapist"]},{code:"5312",name:"Vent Wages - Other",shortName:"Vent Other Wages",category:"vent_expense",subcategory:"wages",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"vent_days",formatType:"currency",mappingKeys:["vent_other_wages"]},{code:"5320",name:"Vent Benefits",shortName:"Vent Benefits",category:"vent_expense",subcategory:"benefits",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"vent_days",formatType:"currency",mappingKeys:["vent_benefits"]},{code:"5330",name:"Vent Purchased Services/Consulting",shortName:"Vent Consulting",category:"vent_expense",subcategory:"purchased_services",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"vent_days",formatType:"currency",mappingKeys:["vent_consulting","vent_purchased"]},{code:"5340",name:"Vent Patient Supplies",shortName:"Vent Supplies",category:"vent_expense",subcategory:"supplies",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"vent_days",formatType:"currency",mappingKeys:["vent_supplies","respiratory_supplies"]},{code:"5350",name:"Vent Equipment Lease/Rental",shortName:"Vent Equip",category:"vent_expense",subcategory:"other",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"vent_days",formatType:"currency",mappingKeys:["vent_equipment","vent_lease"]},{code:"5360",name:"Vent Other",shortName:"Vent Other",category:"vent_expense",subcategory:"other",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"vent_days",formatType:"currency",mappingKeys:["vent_other","vent_misc"]},{code:"5399",name:"Total Vent Expenses",shortName:"Tot Vent Exp",category:"vent_expense",isHeader:!1,isTotal:!0,parentCode:"5300",ppdEligible:!0,ppdDenominator:"vent_days",formatType:"currency"},{code:"5400",name:"Plant/Maintenance Expenses",category:"plant_expense",isHeader:!0,isTotal:!1,ppdEligible:!1,formatType:"currency"},{code:"5410",name:"Plant Wages",shortName:"Plant Wages",category:"plant_expense",subcategory:"wages",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["plant_wages","maintenance_wages"]},{code:"5420",name:"Plant Benefits",shortName:"Plant Benefits",category:"plant_expense",subcategory:"benef
1its",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["plant_benefits"]},{code:"5430",name:"Utilities - Electric",shortName:"Electric",category:"plant_expense",subcategory:"utilities",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["electric","electricity"]},{code:"5431",name:"Utilities - Gas",shortName:"Gas",category:"plant_expense",subcategory:"utilities",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["gas","natural_gas"]},{code:"5432",name:"Utilities - Water/Sewer",shortName:"Water/Sewer",category:"plant_expense",subcategory:"utilities",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["water","sewer","water_sewer"]},{code:"5433",name:"Utilities - Trash Removal",shortName:"Trash",category:"plant_expense",subcategory:"utilities",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["trash","waste","garbage"]},{code:"5440",name:"Minor Equipment",shortName:"Minor Equip",category:"plant_expense",subcategory:"maintenance",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["minor_equipment","small_equipment"]},{code:"5441",name:"Repairs & Maintenance - Building",shortName:"R&M Building",category:"plant_expense",subcategory:"maintenance",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["building_repairs","building_maintenance"]},{code:"5442",name:"Repairs & Maintenance - Equipment",shortName:"R&M Equipment",category:"plant_expense",subcategory:"maintenance",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["equipment_repairs","equipment_maintenance"]},{code:"5443",name:"Repairs & Maintenance - Grounds",shortName:"R&M Grounds",category:"plant_expense",subcategory:"maintenance",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["grounds","landscaping","lawn"]},{code:"5450",name:"Plant Contract Services",shortName:"Plant Contract",category:"plant_expense",subcategory:"purchased_services",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["plant_contract","maintenance_contract"]},{code:"5460",name:"Plant Supplies",shortName:"Plant Supplies",category:"plant_expense",subcategory:"supplies",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["plant_supplies","maintenance_supplies"]},{code:"5470",name:"Plant Other",shortName:"Plant Other",category:"plant_expense",subcategory:"other",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["plant_other","plant_misc"]},{code:"5499",name:"Total Plant Expenses",shortName:"Tot Plant",category:"plant_expense",isHeader:!1,isTotal:!0,parentCode:"5400",ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency"},{code:"5500",name:"Housekeeping Expenses",category:"housekeeping_expense",isHeader:!0,isTotal:!1,ppdEligible:!1,formatType:"currency"},{code:"5510",name:"Housekeeping Wages",shortName:"HK Wages",category:"housekeeping_expense",subcategory:"wages",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["housekeeping_wages","hk_wages"]},{code:"5520",name:"Housekeeping Benefits",shortName:"HK Benefits",category:"housekeeping_expense",subcategory:"benefits",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["housekeeping_benefits","hk_benefits"]},{code:"5530",name:"Housekeeping Supplies",shortName:"HK Supplies",category:"housekeeping_expense",subcategory:"supplies",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["housekeeping_supplies","cleaning_supplies"]},{code:"5540",name:"Housekeeping Contract Services",shortName:"HK Contract",category:"housekeeping_expense",subcategory:"purchased_services",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["housekeeping_contract"]},{code:"5550",name:"Housekeeping Other",shortName:"HK Other",category:"housekeeping_expense",subcategory:"other",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["housekeeping_other"]},{code:"5599",name:"Total Housekeeping Expenses",shortName:"Tot HK",category:"housekeeping_expense",isHeader:!1,isTotal:!0,parentCode:"5500",ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency"},{code:"5600",name:"Laundry Expenses",category:"laundry_expense",isHeader:!0,isTotal:!1,ppdEligible:!1,formatType:"currency"},{code:"5610",name:"Laundry Wages",shortName:"Laundry Wages",category:"laundry_expense",subcategory:"wages",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["laundry_wages"]},{code:"5620",name:"Laundry Benefits",shortName:"Laundry Ben",category:"laundry_expense",subcategory:"benef
1its",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["laundry_benefits"]},{code:"5630",name:"Laundry Supplies",shortName:"Laundry Suppl",category:"laundry_expense",subcategory:"supplies",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["laundry_supplies"]},{code:"5640",name:"Laundry Contract/Outside Services",shortName:"Laundry Contract",category:"laundry_expense",subcategory:"purchased_services",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["laundry_contract","linen_service"]},{code:"5650",name:"Laundry Other",shortName:"Laundry Other",category:"laundry_expense",subcategory:"other",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["laundry_other"]},{code:"5699",name:"Total Laundry Expenses",shortName:"Tot Laundry",category:"laundry_expense",isHeader:!1,isTotal:!0,parentCode:"5600",ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency"},{code:"5700",name:"Dietary Expenses",category:"dietary_expense",isHeader:!0,isTotal:!1,ppdEligible:!1,formatType:"currency"},{code:"5710",name:"Dietary Wages",shortName:"Dietary Wages",category:"dietary_expense",subcategory:"wages",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["dietary_wages","food_service_wages"]},{code:"5720",name:"Dietary Benefits",shortName:"Dietary Ben",category:"dietary_expense",subcategory:"benefits",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["dietary_benefits"]},{code:"5730",name:"Dietary Contract Services",shortName:"Dietary Contract",category:"dietary_expense",subcategory:"purchased_services",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["dietary_contract","food_management"]},{code:"5740",name:"Food Cost - Raw Food",shortName:"Raw Food",category:"dietary_expense",subcategory:"food",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["raw_food","food_cost","groceries"]},{code:"5741",name:"Food Cost - Supplements/Thickeners",shortName:"Supplements",category:"dietary_expense",subcategory:"food",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["supplements","thickeners","nutritional_supplements"]},{code:"5750",name:"Dietary Supplies",shortName:"Dietary Suppl",category:"dietary_expense",subcategory:"supplies",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["dietary_supplies","kitchen_supplies"]},{code:"5760",name:"Dietary Equipment",shortName:"Dietary Equip",category:"dietary_expense",subcategory:"other",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["dietary_equipment","kitchen_equipment"]},{code:"5770",name:"Dietary Other",shortName:"Dietary Other",category:"dietary_expense",subcategory:"other",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["dietary_other","dietary_misc"]},{code:"5799",name:"Total Dietary Expenses",shortName:"Tot Dietary",category:"dietary_expense",isHeader:!1,isTotal:!0,parentCode:"5700",ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency"},{code:"5800",name:"Social Services Expenses",category:"social_services_expense",isHeader:!0,isTotal:!1,ppdEligible:!1,formatType:"currency"},{code:"5810",name:"Social Services Wages",shortName:"SS Wages",category:"social_services_expense",subcategory:"wages",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["social_services_wages","social_worker_wages"]},{code:"5820",name:"Social Services Benefits",shortName:"SS Benefits",category:"social_services_expense",subcategory:"benefits",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["social_services_benefits"]},{code:"5830",name:"Social Services Other",shortName:"SS Other",category:"social_services_expense",subcategory:"other",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["social_services_other"]},{code:"5899",name:"Total Social Services Expenses",shortName:"Tot SS",category:"social_services_expense",isHeader:!1,isTotal:!0,parentCode:"5800",ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency"},{code:"5900",name:"Activities Expenses",category:"activities_expense",isHeader:!0,isTotal:!1,ppdEligible:!1,formatType:"currency"},{code:"5910",name:"Activities Wages",shortName:"Act Wages",category:"activities_expense",subcategory:"wages",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["activities_wages"]},{code:"5920",name:"Activities Benefits",shortName:"Act Benefits",category:"activities_expense",subcategory:"benef
1its",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["activities_benefits"]},{code:"5930",name:"Activities Supplies",shortName:"Act Supplies",category:"activities_expense",subcategory:"supplies",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["activities_supplies"]},{code:"5940",name:"Activities Other",shortName:"Act Other",category:"activities_expense",subcategory:"other",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["activities_other"]},{code:"5999",name:"Total Activities Expenses",shortName:"Tot Activities",category:"activities_expense",isHeader:!1,isTotal:!0,parentCode:"5900",ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency"},{code:"6000",name:"Medical Records Expenses",category:"medical_records_expense",isHeader:!0,isTotal:!1,ppdEligible:!1,formatType:"currency"},{code:"6010",name:"Medical Records Wages",shortName:"MR Wages",category:"medical_records_expense",subcategory:"wages",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["medical_records_wages","him_wages"]},{code:"6020",name:"Medical Records Benefits",shortName:"MR Benefits",category:"medical_records_expense",subcategory:"benefits",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["medical_records_benefits"]},{code:"6030",name:"Medical Records Supplies",shortName:"MR Supplies",category:"medical_records_expense",subcategory:"supplies",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["medical_records_supplies"]},{code:"6040",name:"Medical Records Other",shortName:"MR Other",category:"medical_records_expense",subcategory:"other",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["medical_records_other"]},{code:"6099",name:"Total Medical Records Expenses",shortName:"Tot MR",category:"medical_records_expense",isHeader:!1,isTotal:!0,parentCode:"6000",ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency"},{code:"6100",name:"Administration Expenses",category:"administration_expense",isHeader:!0,isTotal:!1,ppdEligible:!1,formatType:"currency"},{code:"6110",name:"Admin Wages - Administrator",shortName:"Admin Wages",category:"administration_expense",subcategory:"wages",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["administrator_salary","admin_wages","nha_salary"]},{code:"6111",name:"Admin Wages - Business Office",shortName:"Bus Office Wages",category:"administration_expense",subcategory:"wages",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["business_office_wages","billing_wages"]},{code:"6112",name:"Admin Wages - Reception/Clerical",shortName:"Clerical Wages",category:"administration_expense",subcategory:"wages",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["reception_wages","clerical_wages"]},{code:"6113",name:"Admin Wages - HR/Staffing",shortName:"HR Wages",category:"administration_expense",subcategory:"wages",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["hr_wages","staffing_wages"]},{code:"6114",name:"Admin Wages - Marketing/Admissions",shortName:"Marketing Wages",category:"administration_expense",subcategory:"wages",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["marketing_wages","admissions_wages"]},{code:"6120",name:"Admin Benefits",shortName:"Admin Benefits",category:"administration_expense",subcategory:"benefits",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["admin_benefits"]},{code:"6130",name:"Admin Purchased Services/Consulting",shortName:"Admin Consulting",category:"administration_expense",subcategory:"purchased_services",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["admin_consulting","consulting_fees"]},{code:"6140",name:"IT/Computer Expense",shortName:"IT Expense",category:"administration_expense",subcategory:"it",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["it_expense","computer","software"]},{code:"6141",name:"EHR/EMR Software",shortName:"EHR/EMR",category:"administration_expense",subcategory:"it",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["ehr","emr","pointclickcare","pcc"]},{code:"6150",name:"Insurance - General Liability",shortName:"GL Insurance",category:"administration_expense",subcategory:"insurance",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["general_liability","liability_insurance"]},{code:"6151",name:"Insurance - Professional Liability",shortName:"Prof Liability",category:"administration_expense",subcategory:"insurance",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["professional_liability","malpractice"]},{code:"6152",name:"Insurance - Workers Compensation",shortName:"Workers Comp",category:"administration_expense",subcategory:"insurance",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["workers_comp","workerscomp"]},{code:"6153",name:"Insurance - Property/Casualty",shortName:"Prop Insurance",category:"administration_expense",subcategory:"insurance",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["property_insurance","casualty_insurance"]},{code:"6154",name:"Insurance - Other",shortName:"Other Insurance",category:"administration_expense",subcategory:"insurance",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["other_insurance"]},{code:"6160",name:"Telecom/Communications",shortName:"Telecom",category:"administration_expense",subcategory:"other",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["telecom","phone","communications"]}
1,{code:"6170",name:"Legal Fees",shortName:"Legal",category:"administration_expense",subcategory:"legal",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["legal_fees","legal","attorney"]},{code:"6171",name:"Accounting/Audit Fees",shortName:"Accounting",category:"administration_expense",subcategory:"other",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["accounting","audit","cpa"]},{code:"6180",name:"Recruitment/Advertising",shortName:"Recruitment",category:"administration_expense",subcategory:"other",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["recruitment","advertising","job_posting"]},{code:"6181",name:"Marketing/Community Relations",shortName:"Marketing",category:"administration_expense",subcategory:"other",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["marketing","community_relations"]},{code:"6182",name:"Travel & Entertainment",shortName:"Travel",category:"administration_expense",subcategory:"other",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["travel","entertainment","t_and_e"]},{code:"6183",name:"Office Supplies",shortName:"Office Supplies",category:"administration_expense",subcategory:"supplies",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["office_supplies"]},{code:"6184",name:"Printing/Postage",shortName:"Print/Postage",category:"administration_expense",subcategory:"other",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["printing","postage"]},{code:"6185",name:"Dues & Subscriptions",shortName:"Dues/Subs",category:"administration_expense",subcategory:"other",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["dues","subscriptions","memberships"]},{code:"6186",name:"Education & Training",shortName:"Education",category:"administration_expense",subcategory:"other",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["education","training","continuing_education"]},{code:"6187",name:"Licenses & Permits",shortName:"Licenses",category:"administration_expense",subcategory:"other",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["licenses","permits","regulatory"]},{code:"6188",name:"Resource Fee",shortName:"Resource Fee",category:"administration_expense",subcategory:"other",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["resource_fee","admin_resource"]},{code:"6190",name:"Admin Other",shortName:"Admin Other",category:"administration_expense",subcategory:"other",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["admin_other","admin_misc"]},{code:"6199",name:"Total Administration Expenses",shortName:"Tot Admin",category:"administration_expense",isHeader:!1,isTotal:!0,parentCode:"6100",ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency"},{code:"6200",name:"Bad Debt Expense",category:"bad_debt",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["bad_debt","uncollectible","write_off"]},{code:"6300",name:"Provider Tax/Bed Tax",category:"bed_tax",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["bed_tax","provider_tax","quality_assessment"]},{code:"6499",name:"Total Operating Expenses",shortName:"Tot Op Exp",category:"administration_expense",isHeader:!1,isTotal:!0,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency"},{code:"6500",name:"Management Fee",category:"management_fee",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["management_fee","mgmt_fee"],description:"Typically 4-6% of revenue"},{code:"6600",name:"EBITDAR",category:"revenue",isHeader:!1,isTotal:!0,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",de
1scription:"Revenue - Operating Expenses - Management Fee"},{code:"7000",name:"Property Expenses",category:"property_expense",isHeader:!0,isTotal:!1,ppdEligible:!1,formatType:"currency"},{code:"7010",name:"Rent/Lease Expense",shortName:"Rent",category:"property_expense",subcategory:"rent",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["rent","lease_expense","facility_lease"]},{code:"7020",name:"Property Taxes",shortName:"Prop Tax",category:"property_expense",subcategory:"taxes",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["property_taxes","real_estate_taxes"]},{code:"7030",name:"Property Insurance",shortName:"Prop Insurance",category:"property_expense",subcategory:"insurance",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["property_insurance"]},{code:"7099",name:"Total Property Expenses",shortName:"Tot Property",category:"property_expense",isHeader:!1,isTotal:!0,parentCode:"7000",ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency"},{code:"7100",name:"EBITDA",category:"revenue",isHeader:!1,isTotal:!0,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",description:"EBITDAR - Property Expenses"},{code:"8000",name:"Other Expenses",category:"other_expense",isHeader:!0,isTotal:!1,ppdEligible:!1,formatType:"currency"},{code:"8010",name:"Depreciation",shortName:"Depreciation",category:"other_expense",subcategory:"depreciation",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["depreciation"]},{code:"8020",name:"Amortization",shortName:"Amortization",category:"other_expense",subcategory:"depreciation",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["amortization"]},{code:"8030",name:"Interest Expense",shortName:"Interest",category:"other_expense",subcategory:"interest",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["interest_expense","interest"]},{code:"8040",name:"Gain/Loss on Asset Disposal",shortName:"G/L Assets",category:"other_expense",subcategory:"other",isHeader:!1,isTotal:!1,ppdEligible:!1,formatType:"currency",mappingKeys:["gain_loss_assets","asset_disposal"]},{code:"8050",name:"Other Misc Expense",shortName:"Misc Expense",category:"other_expense",subcategory:"other",isHeader:!1,isTotal:!1,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",mappingKeys:["misc_expense","other_misc"]},{code:"8099",name:"Total Other Expenses",shortName:"Tot Other Exp",category:"other_expense",isHeader:!1,isTotal:!0,parentCode:"8000",ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency"},{code:"9000",name:"Net Income",category:"revenue",isHeader:!1,isTotal:!0,ppdEligible:!0,ppdDenominator:"total_days",formatType:"currency",description:"EBITDA - Other Expenses"},{code:"9100",name:"Patient Days",category:"patient_days",isHeader:!0,isTotal:!1,ppdEligible:!1,formatType:"days"},{code:"9110",name:"Non-Skilled Patient Days",category:"patient_days",subcategory:"non_skilled",isHeader:!0,isTotal:!1,ppdEligible:!1,formatType:"days"},{code:"9111",name:"Medicaid Days",shortName:"Mcaid Days",category:"patient_days",subcategory:"non_skilled",isHeader:!1,isTotal:!1,ppdEligible:!1,formatType:"days",mappingKeys:["medicaid_days"]},{code:"9112",name:"Managed Medicaid Days",shortName:"Mngd Mcaid Days",category:"patient_days",subcategory:"non_skilled",isHeader:!1,isTotal:!1,ppdEligible:!1,formatType:"days",mappingKeys:["managed_medicaid_days","mco_days"]},{code:"9113",name:"Private Pay Days",shortName:"Private Days",category:"patient_days",subcategory:"non_skilled",isHeader:!1,isTotal:!1,ppdEligible:!1,formatType:"days",mappingKeys:["private_days","private_pay_days"]},{code:"9114",name:"Veterans Days",shortName:"VA Days",category:"patient_days",subcategory:"non_skilled",isHeader:!1,isTotal:!1,ppdEligible:!1,formatType:"days",mappingKeys:["va_days","veterans_days"]},{code:"9115",name:"Hospice Days",shortName:"Hospice Days",category:"patient_days",subcategory:"non_skilled",isHeader:!1,isTotal:!1,ppdEligible:!1,formatType:"days",mappingKeys:["hospice_days"]}
1,{code:"9119",name:"Total Non-Skilled Days",shortName:"Tot NS Days",category:"patient_days",subcategory:"non_skilled",isHeader:!1,isTotal:!0,parentCode:"9110",ppdEligible:!1,formatType:"days"},{code:"9120",name:"Skilled Patient Days",category:"patient_days",subcategory:"skilled",isHeader:!0,isTotal:!1,ppdEligible:!1,formatType:"days"},{code:"9121",name:"Medicare Part A Days",shortName:"Medicare Days",category:"patient_days",subcategory:"skilled",isHeader:!1,isTotal:!1,ppdEligible:!1,formatType:"days",mappingKeys:["medicare_days","mcr_days"]},{code:"9122",name:"Medicare Advantage Days",shortName:"MA Days",category:"patient_days",subcategory:"skilled",isHeader:!1,isTotal:!1,ppdEligible:!1,formatType:"days",mappingKeys:["medicare_advantage_days","ma_days"]},{code:"9123",name:"Managed Medicaid Skilled Days",shortName:"Mngd Sk Days",category:"patient_days",subcategory:"skilled",isHeader:!1,isTotal:!1,ppdEligible:!1,formatType:"days",mappingKeys:["managed_medicaid_skilled_days"]},{code:"9124",name:"Medicaid Complex Days",shortName:"Complex Days",category:"patient_days",subcategory:"skilled",isHeader:!1,isTotal:!1,ppdEligible:!1,formatType:"days",mappingKeys:["medicaid_complex_days","complex_days"]},{code:"9125",name:"Medicaid Bariatric Days",shortName:"Bariatric Days",category:"patient_days",subcategory:"skilled",isHeader:!1,isTotal:!1,ppdEligible:!1,formatType:"days",mappingKeys:["medicaid_bariatric_days","bariatric_days"]},{code:"9126",name:"Veterans Skilled Days",shortName:"VA Sk Days",category:"patient_days",subcategory:"skilled",isHeader:!1,isTotal:!1,ppdEligible:!1,formatType:"days",mappingKeys:["veterans_skilled_days","va_skilled_days"]},{code:"9127",name:"HMO/Commercial Days",shortName:"HMO Days",category:"patient_days",subcategory:"skilled",isHeader:!1,isTotal:!1,ppdEligible:!1,formatType:"days",mappingKeys:["hmo_days","commercial_days"]},{code:"9128",name:"ISNP Days",shortName:"ISNP Days",category:"patient_days",subcategory:"skilled",isHeader:!1,isTotal:!1,ppdEligible:!1,formatType:"days",mappingKeys:["isnp_days"]},{code:"9129",name:"Total Skilled Days",shortName:"Tot Sk Days",category:"patient_days",subcategory:"skilled",isHeader:!1,isTotal:!0,parentCode:"9120",ppdEligible:!1,formatType:"days"},{code:"9130",name:"Vent Patient Days",category:"patient_days",subcategory:"vent",isHeader:!0,isTotal:!1,ppdEligible:!1,formatType:"days"},{code:"9131",name:"Vent Days - All Payers",shortName:"Vent Days",category:"patient_days",subcategory:"vent",isHeader:!1,isTotal:!1,ppdEligible:!1,formatType:"days",mappingKeys:["vent_days","ventilator_days"]},{code:"9139",name:"Total Vent Days",shortName:"Tot Vent Days",category:"patient_days",subcategory:"vent",isHeader:!1,isTotal:!0,parentCode:"9130",ppdEligible:!1,formatType:"days"},{code:"9199",name:"Total Patient Days",shortName:"Tot Pat Days",category:"patient_days",isHeader:!1,isTotal:!0,ppdEligible:!1,formatType:"days"},{code:"9200",name:"Census & Statistics",category:"census",isHeader:!0,isTotal:!1,ppdEligible:!1,formatType:"number"},{code:"9210",name:"Licensed Beds",shortName:"Licensed Beds",category:"census",isHeader:!1,isTotal:!1,ppdEligible:!1,formatType:"number",mappingKeys:["licensed_beds","total_beds"]},{code:"9211",name:"Operational Beds",shortName:"Op Beds",category:"census",isHeader:!1,isTotal:!1,ppdEligible:!1,formatType:"number",mappingKeys:["operational_beds","staffed_beds"]},{code:"9220",name:"Average Daily Census",shortName:"ADC",category:"census",isHeader:!1,isTotal:!1,ppdEligible:!1,formatType:"number",mappingKeys:["adc","average_daily_census"]}
1,{code:"9230",name:"Licensed Occupancy %",shortName:"Lic Occ %",category:"census",isHeader:!1,isTotal:!1,ppdEligible:!1,formatType:"percent",mappingKeys:["licensed_occupancy"]},{code:"9231",name:"Operational Occupancy %",shortName:"Op Occ %",category:"census",isHeader:!1,isTotal:!1,ppdEligible:!1,formatType:"percent",mappingKeys:["operational_occupancy"]},{code:"9240",name:"Skilled Mix %",shortName:"Skill Mix %",category:"census",isHeader:!1,isTotal:!1,ppdEligible:!1,formatType:"percent",mappingKeys:["skilled_mix","skill_mix"]},{code:"9241",name:"Medicare Mix %",shortName:"MCR Mix %",category:"census",isHeader:!1,isTotal:!1,ppdEligible:!1,formatType:"percent",mappingKeys:["medicare_mix","mcr_mix"]},{code:"9250",name:"HPPD - RN",shortName:"RN HPPD",category:"census",isHeader:!1,isTotal:!1,ppdEligible:!1,formatType:"number",mappingKeys:["rn_hppd","rn_hours"],description:"RN Hours Per Patient Day"},{code:"9251",name:"HPPD - Total Nursing",shortName:"Total HPPD",category:"census",isHeader:!1,isTotal:!1,ppdEligible:!1,formatType:"number",mappingKeys:["total_hppd","nursing_hours"],description:"Total Nursing Hours Per Patient Day"}];function l(e){return({prior_actuals:"Prior Owner Actuals",budget:"Budget",forecast:"Forecast",acquisition:"Acquisition Pro Forma"})[e]}(0,s.t9)();let y=function(){let e=[];return c.forEach(a=>{let t;let r=function(e){let a=c.find(a=>a.code===e);return a&&(!a.isHeader||a.parentCode)?a.isHeader?1:a.isTotal&&!a.parentCode?0:a.isTotal?1:a.parentCode?2:1:0}(a.code),o="input";a.isHeader?(o="header",t=({revenue:"#dbeafe",ancillary_expense:"#fef3c7",nursing_expense:"#fef3c7",vent_expense:"#fef3c7",plant_expense:"#fef3c7",housekeeping_expense:"#fef3c7",laundry_expense:"#fef3c7",dietary_expense:"#fef3c7",social_services_expense:"#fef3c7",activities_expense:"#fef3c7",medical_records_expense:"#fef3c7",administration_expense:"#fef3c7",bad_debt:"#fef3c7",bed_tax:"#fef3c7",management_fee:"#fef3c7",property_expense:"#fce7f3",other_expense:"#e5e7eb",patient_days:"#e0f2fe",census:"#f3e8ff"})[a.category]||"#f3f4f6"):a.isTotal&&(o="formula",t="4999"===a.code||"6600"===a.code||"7100"===a.code||"9000"===a.code?"#d1fae5":void 0),["4000","5100","5200","5300","5400","5500","5600","5700","5800","5900","6000","6100","6200","6300","6500","7000","8000","9100","9200"].includes(a.code)&&e.push({coaCode:"",label:"",type:"spacer",format:"currency"}),e.push({coaCode:a.code,label:a.name,type:o,key:a.code,format:a.formatType,indent:r,bold:a.isTotal||a.isHeader,bg:t,ppdDenominator:a.ppdDenominator,ppdEligible:a.ppdEligible}),a.code,"6600"===a.code&&e.push({coaCode:"6600.M",label:"EBITDAR Margin %",type:"formula",format:"percent",bold:!0,ppdEligible:!1}),"7100"===a.code&&e.push({coaCode:"7100.M",label:"EBITDA Margin %",type:"formula",format:"percent",bold:!0,ppdEligible:!1}),"9000"===a.code&&e.push({coaCode:"9000.M",label:"Net Income Margin %",type:"formula",format:"percent",bold:!0,ppdEligible:!1})}),e}(),m=function(e){let a=new Map;return e.forEach((e,t)=>{e.coaCode&&a.set(e.coaCode,t+3)}),a}(y);function g(e){let{facilityType:a,facilityName:t,initialAssumptions:s,scenario:g,startDate:u,onDataChange:_,coaMappedData:h}=e,T=(0,o.useRef)(null),[b,f]=(0,o.useState)(!1),x=function(e){let a=[];for(let t=0;t<12;t++){let r=new Date(e.getFullYear(),e.getMonth()+t,1);a.push({month:r,label:r.toLocaleDateString("en-US",{month:"short",year:"2-digit"}),days:new Date(r.getFullYear(),r.getMonth()+1,0).getDate()})}return a}(u),E=new Date(u.getFullYear(),u.getMonth()+11,1),v="".concat(u.toLocaleDateString("en-US",{month:"short",year:"numeric"})," - ").concat(E.toLocaleDateString("en-US",{month:"short",year:"numeric"})),D=s||d.c6[a],N=(0,o.useCallback)((e,a,t)=>{var r,o,n;if(h&&h[e]){let a=x[t].label;if(void 0!==h[e][a])return h[e][a]}let s=D.licensedBeds,i=Math.round(s*D.targetOccupancy*x[t].days),p=Math.round(.35*i),d=Math.round(.55*i),c=Math.round(.1*i),l={4110:Math.round(.55*d*D.medicaidPPD),4120:Math.round(.15*d*D.managedMedicaidPPD),4130:Math.round(.15*d*D.privatePPD),4140:Math.round(.05*d*D.veteransPPD),4150:Math.round(.1*d*D.hospicePPD),4210:Math.round(.4*p*D.medicarePPD),4215:Math.round(72*p),4220:Math.round(.15*p*D.managedMedicaidPPD*1.3),4230:Math.round(32*p),4235:Math.round(19*p),4240:Math.round(.05*p*D.veteransPPD*1.2),4250:Math.round(.07*p*D.hmoPPD),4260:Math.round(.03*p*D.isnpPPD),4310:Math.round(260*c),4320:Math.round(120*c),4330:Math.round(120*c),4340:Math.round(58*c),4350:Math.round(21*c),4360:Math.round(57.6*c),4370:Math.round(11*c),4410:Math.round(8*i),4415:Math.round(2*i),4420:8e3,4430:15e3,4440:0,4450:0,4460:500,4470:3e3,4480:1500},y={5111:Math.round(12*p),5112:Math.round(10*p),5113:Math.round(6*p),5114:Math.round(8*p),5115:Math.round(7*p),5116:Math.round(5*p),5117:Math.round(2*p),5118
1:Math.round(1*p),5151:Math.round(12*i),5152:Math.round(2*i),5153:Math.round(1.5*i),5154:Math.round(3*i),5155:Math.round(150*s),5156:Math.round(2*i),5157:Math.round(1*i),5158:Math.round(.5*i),5210:Math.round(28*i),5211:Math.round(22*i),5212:Math.round(35*i),5213:Math.round(200*s),5214:Math.round(50*s),5220:Math.round(18*i),5221:Math.round(8*i),5230:Math.round(8*i),5231:Math.round(5*i),5232:Math.round(6*i),5240:Math.round(30*s),5250:Math.round(4*i),5251:Math.round(3*i),5252:Math.round(2*i),5253:Math.round(2*i),5260:Math.round(25*s),5270:Math.round(15*s),5280:Math.round(10*s),5310:Math.round(45*c),5311:Math.round(35*c),5312:Math.round(15*c),5320:Math.round(20*c),5330:Math.round(10*c),5340:Math.round(25*c),5350:Math.round(15*c),5360:Math.round(5*c),5410:Math.round(200*s),5420:Math.round(44*s),5430:Math.round(80*s),5431:Math.round(40*s),5432:Math.round(25*s),5433:Math.round(10*s),5440:Math.round(15*s),5441:Math.round(30*s),5442:Math.round(20*s),5443:Math.round(10*s),5450:Math.round(25*s),5460:Math.round(10*s),5470:Math.round(5*s),5510:Math.round(180*s),5520:Math.round(40*s),5530:Math.round(25*s),5540:Math.round(15*s),5550:Math.round(5*s),5610:Math.round(100*s),5620:Math.round(22*s),5630:Math.round(15*s),5640:Math.round(30*s),5650:Math.round(5*s),5710:Math.round(350*s),5720:Math.round(77*s),5730:Math.round(20*s),5740:Math.round(12*i),5741:Math.round(3*i),5750:Math.round(15*s),5760:Math.round(10*s),5770:Math.round(5*s),5810:Math.round(80*s),5820:Math.round(18*s),5830:Math.round(5*s),5910:Math.round(100*s),5920:Math.round(22*s),5930:Math.round(15*s),5940:Math.round(5*s),6010:Math.round(70*s),6020:Math.round(15*s),6030:Math.round(5*s),6040:Math.round(3*s),6110:Math.round(150*s),6111:Math.round(120*s),6112:Math.round(60*s),6113:Math.round(50*s),6114:Math.round(80*s),6120:Math.round(100*s),6130:Math.round(40*s),6140:Math.round(50*s),6141:Math.round(35*s),6150:Math.round(60*s),6151:Math.round(80*s),6152:Math.round(120*s),6153:Math.round(40*s),6154:Math.round(20*s),6160:Math.round(25*s),6170:Math.round(30*s),6171:Math.round(20*s),6180:Math.round(35*s),6181:Math.round(25*s),6182:Math.round(15*s),6183:Math.round(10*s),6184:Math.round(8*s),6185:Math.round(10*s),6186:Math.round(15*s),6187:Math.round(12*s),6188:Math.round(20*s),6190:Math.round(10*s),6200:Math.round(i*D.medicaidPPD*.35*.015),6300:Math.round(15*i),6500:Math.round(i*D.medicaidPPD*.35*.05),7010:Math.round(s*D.rentRate),7020:Math.round(D.propertyTaxes/12),7030:Math.round(25*s),8010:Math.round(120*s),8020:Math.round(30*s),8030:Math.round(80*s),8040:0,8050:Math.round(10*s)};return null!==(n=null!==(o=null!==(r=l[e])&&void 0!==r?r:y[e])&&void 0!==o?o:({9111:Math.round(.55*d),9112:Math.round(.15*d),9113:Math.round(.15*d),9114:Math.round(.05*d),9115:Math.round(.1*d),9121:Math.round(.4*p),9122:Math.round(.15*p),9123:Math.round(.15*p),9124:Math.round(.1*p),9125:Math.round(.05*p),9126:Math.round(.05*p),9127:Math.round(.07*p),9128:Math.round(.03*p),9131:c,9210:s,9211:Math.round(.95*s)})[e])&&void 0!==n?n:0},[D,x,h]),H=(0,o.useCallback)((e,a)=>{if(!c.find(a=>a.code===e))return"0";if("6600"===e){let e=m.get("4999"),t=m.get("6499"),r=m.get("6500");return"".concat(a).concat(e,"-").concat(a).concat(t,"-").concat(a).concat(r)}if("7100"===e){let e=m.get("6600"),t=m.get("7099");return"".concat(a).concat(e,"-").concat(a).concat(t)}if("9000"===e){let e=m.get("7100"),t=m.get("8099");return"".concat(a).concat(e,"-").concat(a).concat(t)}if("6600.M"===e){let e=m.get("6600"),t=m.get("4999");return"".concat(a).concat(e,"/").concat(a).concat(t)}if("7100.M"===e){let e=m.get("7100"),t=m.get("4999");return"".concat(a).concat(e,"/").concat(a).concat(t)}if("9000.M"===e){let e=m.get("9000"),t=m.get("4999");return"".concat(a).concat(e,"/").concat(a).concat(t)}if("9220"===e){let e=m.get("9199");return"".concat(a).concat(e,"/30")}
1if("9230"===e){let e=m.get("9199"),t=m.get("9210");return"".concat(a).concat(e,"/(").concat(a).concat(t,"*30)")}if("9231"===e){let e=m.get("9199"),t=m.get("9211");return"".concat(a).concat(e,"/(").concat(a).concat(t,"*30)")}if("9240"===e){let e=m.get("9129"),t=m.get("9199");return"".concat(a).concat(e,"/").concat(a).concat(t)}if("9241"===e){let e=m.get("9121"),t=m.get("9122"),r=m.get("9199");return"(".concat(a).concat(e,"+").concat(a).concat(t,")/").concat(a).concat(r)}let t={4199:["4110","4120","4130","4140","4150"],4299:["4210","4215","4220","4230","4235","4240","4250","4260"],4399:["4310","4320","4330","4340","4350","4360","4370"],4499:["4410","4415","4420","4430","4440","4450","4460","4470","4480"],4999:["4199","4299","4399","4499"],5119:["5111","5112","5113","5114","5115","5116","5117","5118"],5159:["5151","5152","5153","5154","5155","5156","5157","5158"],5199:["5119","5159"],5299:["5210","5211","5212","5213","5214","5220","5221","5230","5231","5232","5240","5250","5251","5252","5253","5260","5270","5280"],5399:["5310","5311","5312","5320","5330","5340","5350","5360"],5499:["5410","5420","5430","5431","5432","5433","5440","5441","5442","5443","5450","5460","5470"],5599:["5510","5520","5530","5540","5550"],5699:["5610","5620","5630","5640","5650"],5799:["5710","5720","5730","5740","5741","5750","5760","5770"],5899:["5810","5820","5830"],5999:["5910","5920","5930","5940"],6099:["6010","6020","6030","6040"],6199:["6110","6111","6112","6113","6114","6120","6130","6140","6141","6150","6151","6152","6153","6154","6160","6170","6171","6180","6181","6182","6183","6184","6185","6186","6187","6188","6190"],6499:["5199","5299","5399","5499","5599","5699","5799","5899","5999","6099","6199","6200","6300"],7099:["7010","7020","7030"],8099:["8010","8020","8030","8040","8050"],6600:[],7100:[],9e3:[],9119:["9111","9112","9113","9114","9115"],9129:["9121","9122","9123","9124","9125","9126","9127","9128"],9139:["9131"],9199:["9119","9129","9139"]}[e];if(!t||0===t.length)return"0";let r=t.map(e=>{let t=m.get(e);return t?"".concat(a).concat(t):null}).filter(Boolean);return r.length>0?r.join("+"):"0"},[]),M=(0,o.useCallback)(()=>{let e=[],a=["","",l(g)];for(let e=0;e<12;e++)a.push(l(g));a.push("T12 Total","T12 PPD"),e.push(a);let t=["COA","Line Item"];return x.forEach(e=>
1t.push(e.label)),t.push(v,"Per Day"),e.push(t),y.forEach((a,t)=>{let r=t+3,o=[a.coaCode,a.label];if("header"===a.type||"subheader"===a.type||"spacer"===a.type)for(let e=0;e<14;e++)o.push("");else if("input"===a.type){for(let e=0;e<12;e++){let t=N(a.coaCode,a.format,e);o.push(t)}if("percent"===a.format?o.push("=AVERAGE(".concat("C").concat(r,":").concat("N").concat(r,")")):o.push("=SUM(".concat("C").concat(r,":").concat("N").concat(r,")")),a.ppdEligible&&a.ppdDenominator){let e="9199";"skilled_days"===a.ppdDenominator?e="9129":"non_skilled_days"===a.ppdDenominator?e="9119":"vent_days"===a.ppdDenominator&&(e="9139");let t=m.get(e);o.push(t?"=".concat("O").concat(r,"/").concat("O").concat(t):"")}else o.push("")}else if("formula"===a.type){for(let e=0;e<12;e++){let t=String.fromCharCode(67+e),r=H(a.coaCode,t);o.push(r?"=".concat(r):"")}if("percent"===a.format?o.push("=AVERAGE(C".concat(r,":N").concat(r,")")):o.push("=SUM(C".concat(r,":N").concat(r,")")),a.ppdEligible&&a.ppdDenominator){let e="9199";"skilled_days"===a.ppdDenominator?e="9129":"non_skilled_days"===a.ppdDenominator?e="9119":"vent_days"===a.ppdDenominator&&(e="9139");let t=m.get(e);o.push(t?"=".concat("O").concat(r,"/").concat("O").concat(t):"")}else o.push("")}else if("kpi"===a.type)for(let e=0;e<14;e++)o.push("");else for(let e=0;e<14;e++)o.push("");e.push(o)}),e},[D,g,x,v,N,H]),[K,k]=(0,o.useState)(()=>M()),P=(0,o.useCallback)((e,a,t,r,o,n,s)=>{if(i.ZP.renderers.TextRenderer(e,a,t,r,o,n,s),0===t)return a.style.fontWeight="bold",a.style.backgroundColor="#1e40af",a.style.color="white",a.style.textAlign=r<=1?"left":"center",a.style.fontSize="11px",a;if(1===t)return a.style.fontWeight="bold",a.style.backgroundColor="#f3f4f6",a.style.textAlign=r<=1?"left":"center",a.style.borderBottom="2px solid #d1d5db",a.style.fontSize="10px",a;let p=y[t-2];if(!p)return a;if(0===r)return a.style.fontSize="9px",a.style.color="#6b7280",a.style.textAlign="left",a.style.paddingLeft="4px",a;if(p.bold&&(a.style.fontWeight="bold"),p.bg&&(a.style.backgroundColor=p.bg),"header"===p.type&&(a.style.fontWeight="bold",a.style.fontSize="11px",a.style.borderTop="2px solid #d1d5db"),"subheader"===p.type&&(a.style.fontWeight="600",a.style.fontStyle="italic",a.style.fontSize="10px"),"spacer"===p.type&&(a.style.height="6px",a.style.backgroundColor="#ffffff"),r>1&&""!==n&&null!=n){let e="string"==typeof n&&n.startsWith("=")?null:Number(n);null!==e&&!isNaN(e)&&("currency"===p.format?a.textContent=new Intl.NumberFormat("en-US",{style:"currency",currency:"USD",minimumFractionDigits:0,maximumFractionDigits:0}).format(e):"percent"===p.format?a.textContent=new Intl.NumberFormat("en-US",{style:"percent",minimumFractionDigits:1,maximumFractionDigits:1}).format(e):("days"===p.format||"number"===p.format)&&(a.textContent=new Intl.NumberFormat("en-US",{minimumFractionDigits:0,maximumFractionDigits:"days"===p.format?0:2}).format(e)),a.style.textAlign="right",e<0&&(a.style.color="#dc2626"))}if(14===r&&(a.style.backgroundColor=a.style.backgroundColor||"#f0fdf4",a.style.borderLeft="2px solid #16a34a",a.style.fontWeight="bold"),15===r){a.style.backgroundColor="#fef3c7",a.style.borderLeft="1px solid #fcd34d",a.style.fontWeight="500",a.style.fontSize="10px";let e="string"==typeof n&&n.startsWith("=")?null:Number(n);null===e||isNaN(e)||0===e||"currency"!==p.format||(a.textContent="$".concat(e.toFixed(2)))}if(1===r){a.style.textAlign="left";let e=p.indent||0;a.style.paddingLeft="".concat(12*e+4,"px"),a.style.fontSize="10px"}return a},[]),C=[55,220,...Array(12).fill(75),90,70],S=(0,o.useCallback)((e,a)=>{if("loadData"!==a&&T.current&&T.current.hotInstance){let e=T.current.hotInstance.getData();k(e),null==_||_(e)}},[_]);return((0,o.useEffect)(()=>{f(!0)},[]),b)?(0,r.jsxs)("div",{className:"card overflow-hidden",children:[(0,r.jsx)("div",{className:"p-3 border-b border-[var(--color-border-muted)] bg-[var(--gray-50)]",children:(0,r.jsxs)("div",{className:"flex items-center justify-between",children:[(0,r.jsxs)("div",{children:[(0,r.jsxs)("h3",{className:"font-semibold text-[var(--color-text-primary)] text-sm",children:[t," Proforma - Full P&L with COA & PPD"]}),(0,r.jsxs)("p",{className:"text-xs text-[var(--color-text-tertiary)] mt-0.5",children:["T12: ",v," | Scenario: ",l(g)," | ",y.length," line items"]})]}),(0,r.jsxs)("div",{className:"flex items-center gap-2",children:[(0,r.jsx)("span",{className:"px-2 py-0.5 text-xs font-medium rounded bg-amber-100 text-amber-800",children:"PPD"}),(0,r.jsx)("span",{className:"px-2 py-0.5 text-xs font-medium rounded bg-blue-100 text-blue-800",children:a.toUpperCase()})]})]})}),(0,r.jsx)("div",{className:"overflow-auto",style:{maxHeight:"calc(100vh - 240px)"},children:(0,r.jsx)(n.sZ,{ref:T,data:K,colWidths:C,rowHeights:22,colHeaders:!1,rowHeaders:!1,manualColumnResize:!0,manualRowResize:!0,contextMenu:!0,copyPaste:!0,formulas:{engine:p.GP},afterChange:S,cells:(e,a)=>{let t={};e<=1&&(t.readOnly=!0),a<=1&&(t.readOnly=!0),a>=14&&(t.readOnly=!0);let r=y[e-2];return r&&("header"===r.type||"subheader"===r.type||"spacer"===r.type||"formula"===r.type||"kpi"===r.type)&&(t.readOnly=!0),t.renderer=P,t},licenseKey:"non-commercial-and-evaluation",className:"htCustomStyles"})}),(0,r.jsxs)("div",{className:"p-2 border-t border-[var(--color-border-muted)] bg-[var(--gray-50)] text-xs text-[var(--color-text-tertiary)] flex justify-between",children:[(0,r.jsx)("span",{children:"Click any editable cell to modify. Formulas auto-calculate. Copy/paste from Excel supported."}),(0,r.jsxs)("span",{className:"flex gap-4",children:[(0,r.jsxs)("span",{className:"flex items-center gap-1",children:[(0,r.jsx)("span",{className:"w-3 h-3 bg-green-100 border border-green-500 rounded"}),"T12 Total"]}),(0,r.jsxs)("span",{className:"flex items-center gap-1",children:[(0,r.jsx)("span",{className:"w-3 h-3 bg-amber-100 border border-amber-400 rounded"}),"PPD"]})]})]})]}):(0,r.jsx)("div",{className:"card p-8 flex items-center justify-center",children:(0,r.jsx)("div",{className:"text-[var(--color-text-tertiary)]",children:"Loading proforma spreadsheet..."})})}}}]);
Line numbers count LF bytes from the start of the resource, as the search results do. Vendor segments are library code the classifier recognised; they are stored but not indexed. Bytes are shown as Latin1 characters, one per byte.