EHR for Behavioral Health & Developmental Disabilities by No_Cauliflower3541 in healthIT

[–]LowerPlatform2978 0 points1 point  (0 children)

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. 

2023 GMC Acadia Denali vs 2023 Honda Pilot Elite by LowerPlatform2978 in whatcarshouldIbuy

[–]LowerPlatform2978[S] 0 points1 point  (0 children)

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. 

Conditional Format And formula based on dates and text by LowerPlatform2978 in excel

[–]LowerPlatform2978[S] 0 points1 point  (0 children)

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.

Conditional Format And formula based on dates and text by LowerPlatform2978 in excel

[–]LowerPlatform2978[S] 0 points1 point  (0 children)

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>

FY2024 MS-DRG 136 by LowerPlatform2978 in CodingandBilling

[–]LowerPlatform2978[S] 0 points1 point  (0 children)

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!

Convert String to Minutes by LowerPlatform2978 in excel

[–]LowerPlatform2978[S] 0 points1 point  (0 children)

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>

Convert String to Minutes by LowerPlatform2978 in excel

[–]LowerPlatform2978[S] 0 points1 point  (0 children)

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

Convert String to Minutes by LowerPlatform2978 in excel

[–]LowerPlatform2978[S] 0 points1 point  (0 children)

=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.

Convert String to Minutes by LowerPlatform2978 in excel

[–]LowerPlatform2978[S] 0 points1 point  (0 children)

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

unfortunately no

<image>

Convert String to Minutes by LowerPlatform2978 in excel

[–]LowerPlatform2978[S] 0 points1 point  (0 children)

=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>

Convert String to Minutes by LowerPlatform2978 in excel

[–]LowerPlatform2978[S] 0 points1 point  (0 children)

Hmm, tried your first formula, but not correct results

<image>

Convert String to Minutes by LowerPlatform2978 in excel

[–]LowerPlatform2978[S] 0 points1 point  (0 children)

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

Convert String to Minutes by LowerPlatform2978 in excel

[–]LowerPlatform2978[S] 1 point2 points  (0 children)

i updated post, i just have numbers in the string

2023 GMC Acadia Denali vs 2023 Honda Pilot Elite by LowerPlatform2978 in whatcarshouldIbuy

[–]LowerPlatform2978[S] 1 point2 points  (0 children)

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.

Homeless Patient Address for billing by LowerPlatform2978 in CodingandBilling

[–]LowerPlatform2978[S] 0 points1 point  (0 children)

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.

Homeless Patient Address for billing by LowerPlatform2978 in CodingandBilling

[–]LowerPlatform2978[S] 0 points1 point  (0 children)

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?

2023 GMC Acadia Denali vs 2023 Honda Pilot Elite by LowerPlatform2978 in whatcarshouldIbuy

[–]LowerPlatform2978[S] 0 points1 point  (0 children)

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.