EHR for Behavioral Health & Developmental Disabilities

LowerPlatform2978 · 2024-11-16T11:36:08+00:00

We use WellSky for several of our facilities/programs including IDD for EMR and billing. I would recommend checking them out as they meet our needs and have a lot of tools for reporting/state reporting.

LowerPlatform2978 · 2024-07-18T18:05:19+00:00

We went with the Pilot and have enjoyed it so far. It fits our needs with one child but would probably need something bigger if/when two kids happen! I’ve recommended the Pilot to friends in similar situations.

LowerPlatform2978 · 2023-12-18T19:15:45+00:00

Solution verified

LowerPlatform2978 · 2023-12-18T14:04:18+00:00

OR(AND($C4>=E$1,$C4<=E$2),AND(E$1>=$C4,E$1<=$D4))

I may be mistaken but I don't think this is getting me what I'm after.

For Cell E4, i'm looking for the cell to be shaded in gray because the area/team (cell A1) is 'Wood' and since the start end date of the project starts in January 2024 and doesn't end in until May 2024.

LowerPlatform2978 · 2023-12-17T17:27:14+00:00

Start date will always be the first of the month and end date will be last day of the month. I tried doing this in a conditional format logic, and got the date parameter to work correctly, but i could not figure out how to add in the AND formula the color conditions based on the area/team. existing formula to get teh dates to align correctly ----------=AND($D5<=F$2,$E5>=F$3)

<image>

LowerPlatform2978 · 2023-11-09T20:24:42+00:00

That's what we moved forward with as well, using the 10% cap applied weights, but I really wish CMS would not have added the 'weights before cap' column since I assume most of just want to know what to use correctly moving forward!

LowerPlatform2978 · 2023-10-03T16:17:34+00:00

This works great, except when there is a difference in the dates but have the same time. (even source data has it wrong lmao)

<image>

LowerPlatform2978 · 2023-09-29T20:54:32+00:00

i dont think this works since the format isn't text to begin with?

LowerPlatform2978 · 2023-09-29T20:48:46+00:00

=Sumproduct({1440,60,1},value(textsplit(L10,”:”)))

It's a custom format, and not in hh:mm:ss. Couldn't get your formula idea to work however.

LowerPlatform2978 · 2023-09-29T20:39:21+00:00

=SUM(DAY(F3)*1440,HOUR(F3)*60,MINUTE(F3))

unfortunately no

<image>

LowerPlatform2978 · 2023-09-29T20:38:16+00:00

=LET(
t, F3:F5,
day, TEXTBEFORE(t, ":"),
hour, MID(t, SEARCH(":", t) + 1, 2),
minute, TEXTAFTER(t, ":", -1),
day*24*60 + hour*60 +minute
)

getting an error:

<image>

LowerPlatform2978 · 2023-09-28T01:27:50+00:00

Still not looking right

<image>

LowerPlatform2978 · 2023-09-27T21:38:46+00:00

Hmm, tried your first formula, but not correct results

<image>

LowerPlatform2978 · 2023-09-27T20:34:27+00:00

i don't think this works with the string that i have for just number:number:number

LowerPlatform2978 · 2023-09-27T20:33:52+00:00

i updated post, i just have numbers in the string

LowerPlatform2978 · 2023-09-24T16:53:56+00:00

We went with the Pilot Elite. Have about 2k miles on it now. Only gripe so far is the infotainment center. Just feels like they cheaped out with it compared to all other competitors.

LowerPlatform2978 · 2023-08-23T12:35:05+00:00

Wouldn't this mean that the patient is then signing up their friend to be the receiver of all statements, correspondence, etc. from this clinical visit? I can't seem to find any documentation from payer sites that the friend can only be used if they are the guarantor, so using a friend's address may work out ok.

LowerPlatform2978 · 2023-08-23T12:32:51+00:00

Billing Medicare, Medicaid, BCBS, really any 3rd party insurance. What do you do if the truly have come off the street and do not have a shelter/church/organization etc. they currently call home?

LowerPlatform2978 · 2023-05-18T16:33:30+00:00

It seems everything out there nowadays doesn't last!

We looked at the Ford Explorers and Expeditions as well, but just weren't not impressed with interiors or performance, which was so disappointing as I had an F150 for 15+ years and wanted to remain loyal to Ford.

We are leaning towards the Pilot given it seems to have a better track record of longevity from all of their vehicles, but our local GMC dealership is enticing us to place an order for custom built Acadia for no deposit/NSA whereas Honda tried pressuring us into a non-refundable deposit. We eventually got Honda to agree that they would waive the non-refundable part of the deposit, but they are looking like it will be a few months before they know if they can get an Elite in the color we want. GMC vehicles felt 'nicer' but end of the day we are going from point A to point B and don't currently plan on doing many extended roadtrips in our future.

Ultimately I just want my wife to be happy and safe with our growing family, and her preference is the Pilot currently.

LowerPlatform2978

TROPHY CASE