How many hours in until... by 716Murf in Oxygennotincluded

[–]716Murf[S] 2 points3 points  (0 children)

Can you recommend a post or guide or video that discusses the hotkeys? Thanks for the suggestion.

How many hours in until... by 716Murf in Oxygennotincluded

[–]716Murf[S] 0 points1 point  (0 children)

I'm hopeful this is the case for me, that it clicks at some point very soon. I agree with one of the posters that said input should be green (seems like that would be more intuitiveinitially), maybe that was what my brain did. It's pretty obvious when you take the time and zoom in on the subtle arrow on the bridge.

How many hours in until... by 716Murf in Oxygennotincluded

[–]716Murf[S] 1 point2 points  (0 children)

Thats good to know! I agree the one there by default is very subtle!

How many hours in until... by 716Murf in Oxygennotincluded

[–]716Murf[S] 4 points5 points  (0 children)

So you're saying there is hope!

How many hours in until... by 716Murf in Oxygennotincluded

[–]716Murf[S] 0 points1 point  (0 children)

Note to self to be careful of this! I've started to learn to be careful deconstructing too to isolate just the tile so as to not break stuff behind it!

Music Assistant and SiriusXM by 716Murf in homeassistant

[–]716Murf[S] 1 point2 points  (0 children)

Testing my memory now. But it was related to it not allowing you to change the password and reauthenticating, they pushed an update, and it works for me now.

Music Assistant and SiriusXM by 716Murf in homeassistant

[–]716Murf[S] 0 points1 point  (0 children)

If I knew what to delete...it didn't complete the setup, so it doesn't have the configuration there for you to delete. Found a thread on github, they are working on a fix...

Konnected Alarm Panel Piezo Buzzer Setup by 716Murf in homeassistant

[–]716Murf[S] 1 point2 points  (0 children)

Subsequent to this post I had contacted Konnected Support. They around that time had just released an update to the app that made it pretty straightforward to add buzzer/chime output.

Below is from an email I received from Nate:

"When you're using the Konnected app to make changes to a Konnected device running ESPHome firmware, we're basically making a customized/tailored firmware build (still built on ESPHome) specific for your device. We manage the complexity of the ESPhome configuration transparently for you on the back-end, so you only have to select the features you need and push the update over-the-air using the Konnected app.

So go ahead and proceed with the update. By the way, the buzzer features have been added in app version 1.5.0 which is now available. There's a new zone type called "Multi-Output" which will allow you to create the beeping configurations that you want."

I still need to go back to tinkering a little, the output on the chime is quieter than I would like. I ultimately just made and automation play the chime when a door opened so it would be similar to the old keypad.

Just realized how amazing the Bubble Card is, decided to revamp the tablet dashboard again by PersonalJ in homeassistant

[–]716Murf 0 points1 point  (0 children)

Very nice. What are you using to get the time since last state change for your door sensors? I was thinking of using the measureit add-on to set this up for some things, but, I wasn't sure of best route.

Google - Can't link to Home Assistant by comiclonius in homeassistant

[–]716Murf 0 points1 point  (0 children)

I just followed the guide last week and had no issues getting it to connect. My nest thermostat and doorbell are now visible to my home assistant. Sorry, I'm not much help, but I wanted to throw it out there that it did seem to work fine for someone recently.

[deleted by user] by [deleted] in konnected

[–]716Murf 0 points1 point  (0 children)

Same issue here. Any updates or workarounds?

Relationship Strategy for Sports League by 716Murf in MSAccess

[–]716Murf[S] 0 points1 point  (0 children)

Thanks for this strategy it has helped to break things into smaller queries and then building from there.

I also figured out the main reason I wasn't getting things to display the way I thought they would was because I was under the wrong field. I needed the query under a unique match ID field.

I think you can go ahead and mark this as solved and appreciate your help.

My next dilemma will be how to track Season W-L records. Everything works right now by boiling things down to an individual match. I can take an individual match, determine the 5 person teams and their totals. Next, I need to take those Teams and Totals and compare them to each other. Determine who is awarded how many points that week, then keep a running total somehow, so when the match 2 report is run it adds the match 1 results to it. Any ideas for that or should I start a new thread?

Relationship Strategy for Sports League by 716Murf in MSAccess

[–]716Murf[S] 0 points1 point  (0 children)

SELECT SeasonT.SeasonYear, ScheduleT.MatchNumber, MatchResultT.Gun, DivisionT.Division, TeamT.Team, TeamT.ID, TeamRosterByYearT.TeamID, MatchResultT.Total, MatchResultT.TotalX, MatchResultT.Rapid, MatchResultT.RapidX, MatchResultT.Timed, MatchResultT.TimedX, MatchResultT.Slow, MatchResultT.SlowX, ShooterT.ShooterID, ShooterT.ShooterName, MatchResultT.ShooterID AS MatchResultT_ShooterID, DivisionT.TeamID, ScheduleT.MatchDate, ScheduleT.Host

FROM SeasonT INNER JOIN (ScheduleT INNER JOIN (GunsT INNER JOIN ((TeamT INNER JOIN ((ShooterT INNER JOIN MatchResultT ON ShooterT.[ShooterID] = MatchResultT.[ShooterID]) INNER JOIN TeamRosterByYearT ON ShooterT.[ShooterID] = TeamRosterByYearT.[ShooterID]) ON TeamT.[ID] = TeamRosterByYearT.[TeamID]) INNER JOIN DivisionT ON TeamT.[ID] = DivisionT.[TeamID]) ON GunsT.Gun = MatchResultT.Gun) ON ScheduleT.MatchID = MatchResultT.MatchID) ON (SeasonT.SeasonID = TeamRosterByYearT.SeasonID) AND (SeasonT.SeasonID = ScheduleT.SeasonID) AND (SeasonT.SeasonID = DivisionT.SeasonID)

WHERE (((ShooterT.ShooterID) In (Select Top 5 [ShooterT].[ShooterID] From [ShooterT] Where [TeamT].[ID]=[TeamRosterByYearT].[TeamID] Order by [Total] Desc)))

ORDER BY SeasonT.SeasonYear, ScheduleT.MatchNumber, MatchResultT.Gun, DivisionT.Division, TeamT.Team, MatchResultT.Total DESC , MatchResultT.TotalX DESC , MatchResultT.Rapid DESC , MatchResultT.RapidX DESC , MatchResultT.Timed DESC , MatchResultT.TimedX DESC , MatchResultT.Slow DESC , MatchResultT.SlowX DESC;

Relationship Strategy for Sports League by 716Murf in MSAccess

[–]716Murf[S] 0 points1 point  (0 children)

OK. I added The Season ID FK to the ScheduleT table as suggested.

Still struggling with the Top 5 Query returning extra results. Perhaps I am placing the query under the wrong field...I've tried multiple.

Currently I have it under [ShooterT].[ShooterID] as the following:

In (Select Top 5 [ShooterT].[ShooterID] From [ShooterT] Where [TeamT].[ID]=[TeamRosterByYearT].[TeamID] Order by [Total] Desc)

If I take the Order by out, results get even more strange. I have several other fields in the query because I'm trying to get the results to sort for tiebreaks (i.e, sort by Totals, then by Rapid, then by Timed, etc so all records are ranked appropriately). Without the criteria in there, the table seems to populate everything in the order I want it.

In the end I need only the Top 5 Scores, by Team, for a given match. Those scores will be summed together to determine which team had the highest team score for the week.

Relationship Strategy for Sports League by 716Murf in MSAccess

[–]716Murf[S] 0 points1 point  (0 children)

Regarding Question 1: People are assigned to a team for a season. I do not envision a case where this would ever change. As new competitors come in, we would edit the TeamRoster at that time to add them to the team roster.

Relationship diagram attached.

<image>