Find the tool here: https://github.com/ronmarco/home-assistant-config/tree/master/tracker
This video is about the tool I use to manage my Home Assistant configuration. I tried to make the video quick to save you time. If you want to following along with your own setup, you can pause the video as you go through the steps.
Timestamps:
0:51 Intro
0:58 Overview of the Tool
1:44 How to Use
2:40 How to Use: States Tab
4:33 How to Use: Customize Tab
6:19 How to Use: Group Tab
8:06 How to Use: …code Tabs
8:30 How the Tool Works - how it generates code
9:06 How to Use: YAML processing tab
9:59 Wrap-Up
Detail and Links
****************************************
0:51 Intro
0:58 Overview of the Tool
1:44 How to Use
-- Here are some helpful links to learn about customizations and groups --
Customize info: https://home-assistant.io/docs/configuration/customizing-devices/
Group info: https://home-assistant.io/components/group/
Video by diyAutomate: https://www.youtube.com/watch?v=fpiVMLNuxSs
Video by BRUH Automation: https://www.youtube.com/watch?v=EsBtyF5tZQ4
-- Information about includes --
Includes info: https://home-assistant.io/docs/configuration/splitting_configuration/
Video I made: https://www.youtube.com/watch?v=Ili8B4hgQ-g
2:40 How to Use: States Tab
Process data pasted from Home Assistant
More info about developer tools: https://home-assistant.io/docs/tools/dev-tools/
4:33 How to Use: Customize Tab
Define customizations for entities
Information on possible attributes: https://home-assistant.io/docs/configuration/customizing-devices/#possible-values
6:19 How to Use: Group Tab
Tell the tool how to group entities into cards or views
8:06 How to Use: …code Tabs
Formats information from other tabs into YAML code for Home Assistant
8:30 How the Tool Works - how it generates code
Formulas organize entity IDs (e.g., device names) and pieces of common code into columns. Then the CONCATENATE function combines the columns into a single line of code.
-- Here are links to some of the functions and techniques I used --
CONCATENATE function: https://support.office.com/en-us/article/CONCATENATE-function-8f8ae884-2ca8-4f7a-b093-75d702bea31d
VLOOKUP function: https://support.office.com/en-us/article/VLOOKUP-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1
INDEX MATCH function: https://www.deskbright.com/excel/using-index-match/
OFFSET function: https://support.office.com/en-us/article/OFFSET-function-c8de19ae-dd79-4b9b-a14e-b4d906d11b66
COUNTIF function: https://support.office.com/en-us/article/COUNTIF-function-e0de10c6-f885-4e71-abb4-1f464816df34
Array formulas: https://support.office.com/en-us/article/Guidelines-and-examples-of-array-formulas-7d94a64e-3ff3-4686-9372-ecfd5caa57c7
Excel tables: https://support.office.com/en-us/article/Overview-of-Excel-tables-7ab0bb7d-3a9e-4b56-a3c9-6c94334e492c
Conditional formatting: https://support.office.com/en-ie/article/Use-formulas-with-conditional-formatting-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f?ui=en-US&rs=en-IE&ad=IE
9:06 How to Use: YAML processing tab
Formats YAML code to make it easier to use the tool. It parses the code so it can be pasted into tables on other tabs.
9:59 Wrap-Up
My final thoughts. Feel free to change or improve on the tool!
I hope this video was helpful. Let me know what else you’re interested in!
Additional Materials
****************************************
I talk about my Home Automation setup in this video: https://www.youtube.com/watch?v=JZrYzSamEps
Find my configuration code on Github: https://github.com/ronmarco/home-assistant-config
