Code quicker using spreadsheets: Automatically generate Home Assistant YAML code!

Published: 06 May 2017
on channel: Ron Mar

7,020

185

Find the tool here: https://github.com/ronmarco/home-assi...

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/config...
Group info: https://home-assistant.io/components/...
Video by diyAutomate:    • Home Assistant For Beginners Part 4: ...
Video by BRUH Automation:    • How to Manage the Home Assistant User...

-- Information about includes --
Includes info: https://home-assistant.io/docs/config...
Video I made:    • Home Assistant: Split Up Configuratio...

2:40 How to Use: States Tab
Process data pasted from Home Assistant
More info about developer tools: https://home-assistant.io/docs/tools/...

4:33 How to Use: Customize Tab
Define customizations for entities
Information on possible attributes: https://home-assistant.io/docs/config...

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/arti...
VLOOKUP function: https://support.office.com/en-us/arti...
INDEX MATCH function: https://www.deskbright.com/excel/usin...
OFFSET function: https://support.office.com/en-us/arti...
COUNTIF function: https://support.office.com/en-us/arti...
Array formulas: https://support.office.com/en-us/arti...
Excel tables: https://support.office.com/en-us/arti...
Conditional formatting: https://support.office.com/en-ie/arti...

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:    • A Home with a Mind of Its Own! Home A...

Find my configuration code on Github: https://github.com/ronmarco/home-assi...

On this page of the site you can watch the video online Code quicker using spreadsheets: Automatically generate Home Assistant YAML code! with a duration of hours minute second in good quality, which was uploaded by the user Ron Mar 06 May 2017, share the link with friends and acquaintances, this video has already been watched 7,020 times on youtube and it was liked by 185 viewers. Enjoy your viewing!

38,835

566