This video gives an example how to turn your Excel into an automated SAP reporting tool. The script in this video extracts information from SAP into CSV, loads the data into Excel, calculate and present stats based on this data.
basics, recording a script and running it from MS Excel using my example.
I built a simple scheduler in Telegram where I can schedule various device to turn on and off at certain times. Simple scheduler interface, nothing fancy.
Get my flow from here: https://github.com/nygma2004/km/wiki/Node-Red-Examples#simple-scheduler-in-telegram
Chapters:
0:00 Intro
1:39 Live example
2:36 Flow overview
3:10 Configure the options
6:14 The scheduler
9:42 The "UI"
19:02 Design thoughts
21:11 Outro
...
https://www.youtube.com/watch?v=rfiW2LU0Fbs
After Sonoff L1, a new product L1 Lite was also released which as far as I can tell is the indoor version. Same controller, same IR remote, but the LED strip is IP20 and not IP67 rated.
https://bit.ly/3icEUfG
Chapters:
0:00 Intro
1:44 L1 vs L1 Lite
3:48 LED strips 101, tips and tricks
12:58 Unboxing
15:16 App features
21:41 Schedule and Timer
22:55 Settings
23:52 Scenes
25:22 Google Home
26:49 Outro
...
https://www.youtube.com/watch?v=qNQjGfb-X8A
This product is set to replace the existing zigbee door and window sensor from Sonoff, giving it bigger battery for more battery life (up to 5 years), stronger adhesive to keep on doors and windows, a new case design making it easier to change the battery and a tamper switch to notify you if the sensor is removed from the door.
Purchasing link will be added once the product is released.
If you like what I do here, you can support me with Youtube Thanks, or Patreon:
https://patreon.com/csongorvarga
TikTok channel most on trains, big and small: https://www.tiktok.com/@frontendfriday
And same in Instagram: https://www.instagram.com/hamptongardenrailway/
Chapters:
0:00 Intro
0:57 Old and new model
1:24 Design and documentation
2:55 Initial setup
4:26 App view
5:30 Settings
7:10 Scene options
10:46 Final thoughts
...
https://www.youtube.com/watch?v=mdm_BVO_1QY
I am starting something, new a hobby, new way of passing time: melting metals.
This is a first video to show my kit, the furnace and all the accessories I purchased for it.
Furnace manual: https://drive.google.com/file/d/1bE4A7BsyaNrMB52ftXR_zW_BL4dVI1Bj/view?usp=sharing
Aliexpress listings:
Induction furnace: https://www.aliexpress.com/item/1005004032751328.html
Long nose pliers: https://www.aliexpress.com/item/1005003978773306.html
Graphite molds: https://www.aliexpress.com/item/1005003977535286.html
Gloves: https://www.aliexpress.com/item/1005003973089640.html
Graphite blocks: https://www.aliexpress.com/item/1005001839435167.html
Fancy shaped molds: https://www.aliexpress.com/item/1005002073688474.html
Graphite rod: https://www.aliexpress.com/item/1005001586145437.html
Letter/number punch kit: https://www.aliexpress.com/item/33029949290.html
Chapters:
0:00 Intro
0:53 What I got here?
2:21 What is an induction furnace?
4:47 The melting furnace
7:58 Accessories
12:09 Aliexpress listings
19:30 First melt
25:01 Outro
...
https://www.youtube.com/watch?v=wmLWGxVi_ls
This is a review of an audio module from IC Station:
http://www.icstation.com/voice-playback-module-music-player-development-board-p-6148.html
This supports WAV or MP3 files stored on micro SD card. It has 9 pins to trigger the playback of the first 9 sounds. It drivers speakers directly, or have an external line output.
ICStation provides up to 40% OFF Discount now and for more information: http://www.icstation.com/newsletter/promotion.html
...
https://www.youtube.com/watch?v=jhaDoMnTXnY
Sonoff made it easy to use the DIY mode with version 2.0. It is easy to get the devices into DIY mode and almost start using in straight away in your DIY home automation. The API has not changed, that is still same as it was before.
My full review of the DIY mode when it was 1.0: https://youtu.be/HjzCxA9Fal8
API documentation: https://bit.ly/2VazuXt
Itead's tutorial article: https://bit.ly/2Ve1ucC
Itead's tutorial video: https://bit.ly/34pNkJD
...
https://www.youtube.com/watch?v=dU9AKpwANfo
This is an unnarrated version of my videos from the Open Day at the Hungarian Railway Museum at 15.06.2019.
You find my narrated version here: https://youtu.be/73aydsZaSIs
...
https://www.youtube.com/watch?v=Kc2R258feH8
You asked for it, and I have tested it. I paired my Sonoff Zigbee sensors with the Blitzwolf Zigbee Gateway to see how they work in the Tuya app:
The Sonoff button does not work at all, but the temperature, motion and door sensors work great, and to some extent even better than in eWelink.
Blitzwolf BW IS1 Zigbee Gateway: https://bit.ly/3lnpUfy and it's review video: https://youtu.be/P_VUojrXxqI
Sonoff Zigbee bridge with the zigbee sensors: https://shrsl.com/2lf2s
Sonoff Zigbee gateway review: https://youtu.be/hWxMDdh70mk
Chapters:
0:00 Intro, what is working as what is not
2:49 Zigbee button
5:11 Temperature and humidity sensor
8:10 Door sensor
12:20 Motion sensor
16:54 Battery life
18:12 Outro
...
https://www.youtube.com/watch?v=Bh2HKnFH1Io