You could do it in Google Sheets (free)
iSpindel - digital WiFi hydrometer
- Thread starter anders
- Start date
Help Support The Homebrew Forum:
Google Sheets doesn't seem to support the Macro. I've tried putting the results in but the formula doesn't change.
Here is a link to my Sheets spreadsheet. You can make a copy and then edit the data.
https://docs.google.com/spreadsheets/d/10FCWwj4ZidkdduUekYgbUPmpic9x7QbgDb_Lxbws6cE/edit?usp=sharing
https://docs.google.com/spreadsheets/d/10FCWwj4ZidkdduUekYgbUPmpic9x7QbgDb_Lxbws6cE/edit?usp=sharing
Lovely. Thanks.
I've put the results in and I'm getting a third-order polynomial. Ubidots is reporting 'Gravity' as 0.14 in water, I presume that is the Plato Value not the S.G.?
I thought I had asked you whether you took your measurements at the same temperature each time and whether you corrected them for temperature? I can't find those questions in my post so I must not have posted them, my bad.
My iSpindel does not report Plato any more - I set it to report Gravity in the configuration. Or it happened when I entered the equation in the iSpindel configuration.
Have you done this? iSpindle Documentation
Water should give zero degrees Plato = no sugars
My iSpindel does not report Plato any more - I set it to report Gravity in the configuration. Or it happened when I entered the equation in the iSpindel configuration.
Have you done this? iSpindle Documentation
Water should give zero degrees Plato = no sugars
Last edited:
Yep, followed the calibration procedure. Made up a sugar solution and brought it back to room temp, used room temp water to dilute it to get the OG reading.
Ubidots just gives the parameter as 'Gravity' so I'm not sure if it means Plato or OG
Do you have the ifttt instructions, and what settings would you use for an ipa?
Good progress on my build today. Everything seems to be working with ubidots, I've got that feeding triggers into IFTTT to turn a warming pad on/off (powered by a smart plug) via webhooks based on high/low temp events. I needed to add a single 5g sugru pack to the base of the cylinder for ballast and to secure the pcb, and then pushed a spare button and screw into that to get 25deg float in water by trial and error (reading 25.2deg in 25C tap water - good enough for me!).
Just need to calibrate in a sugar solution, then try an actual brew!
Most people seem to focus on the gravity readings with ispendel... But I'm most looking forward to being able to monitor and control fermentation temperator through winter in my garage!
I'm planning on putting a guide together on this at some point, in case others are interested.
- Joined
- Aug 9, 2019
- Messages
- 388
- Reaction score
- 161
I've taken a few screenshots from the various apps and will aim to get something written up in the next day or two. As for IPA... I'm no brewing expert and I'm sure others will know more about temps... But I'm quite a simple soul and just set my boundaries to 21-23C.
- Joined
- Aug 9, 2019
- Messages
- 388
- Reaction score
- 161
Here goes - really keen to get comments/feedback on this. Its easy to assume knowledge or miss bits out! I am sure there will be small differences between Android/iOS apps etc, but hopefully this is enough to get you started!
https://docs.google.com/presentation/d/11C50OE74af2jVFBVQfVMndSCAaEpy0WBq0OtAfjMEzk/
https://docs.google.com/presentation/d/11C50OE74af2jVFBVQfVMndSCAaEpy0WBq0OtAfjMEzk/
Harry Bloomfield
Regular.
- Joined
- Oct 29, 2019
- Messages
- 238
- Reaction score
- 47
iSpindel failing to report data.
This has happened to me twice now, in my previous and current brew. The first time it occurred in mid brew, the second time it happened at the beginning of the brew, before I had even put it in the FV. The fix each time seems to be to go into the configuration and without changing anything, to simply save the configuration and get it to reboot. Rebooting (powering down and back up) alone, does not get it working again.
My present theory as to the cause, is that it relies on the router to give it an IP, once it has been given an IP the iSpindel remembers its IP, not hearing from the iSpindel for a while, a router might decide to reallocate that IP to something else on the LAN, so the iSpindel's data bursts will be ignored, due to the IP clash.
I will admit I have a lot of various items on my local LAN all demanding IP's, many of which use DHCP, requesting to be dynamically allocated an IP by the router. The past few days, I have been trying to sort out my mess of dynamically supplied IP's, to give everything which occasionally connects and needs IP, a static IP address.
I have set all of these IP static allocations in my main router. All that was needed was to know the MAC of each device, the iSpindels MAC number can be found in the configuration. Fill the MAC in the routers form, plus decide on what IP address you want it to have. Likewise everything else which connects to your home LAN - every item will have a unique MAC number of the form ww:xx:yy:zz
This has happened to me twice now, in my previous and current brew. The first time it occurred in mid brew, the second time it happened at the beginning of the brew, before I had even put it in the FV. The fix each time seems to be to go into the configuration and without changing anything, to simply save the configuration and get it to reboot. Rebooting (powering down and back up) alone, does not get it working again.
My present theory as to the cause, is that it relies on the router to give it an IP, once it has been given an IP the iSpindel remembers its IP, not hearing from the iSpindel for a while, a router might decide to reallocate that IP to something else on the LAN, so the iSpindel's data bursts will be ignored, due to the IP clash.
I will admit I have a lot of various items on my local LAN all demanding IP's, many of which use DHCP, requesting to be dynamically allocated an IP by the router. The past few days, I have been trying to sort out my mess of dynamically supplied IP's, to give everything which occasionally connects and needs IP, a static IP address.
I have set all of these IP static allocations in my main router. All that was needed was to know the MAC of each device, the iSpindels MAC number can be found in the configuration. Fill the MAC in the routers form, plus decide on what IP address you want it to have. Likewise everything else which connects to your home LAN - every item will have a unique MAC number of the form ww:xx:yy:zz
- Joined
- Aug 9, 2019
- Messages
- 388
- Reaction score
- 161
This is really interesting... I'd be amazed if the ispindel didn't request an ip through dhcp every time it wakes. However, I can see how the developers may just use the same ip to save on battery and assume its still free. Very risky approach though!
It'll also depend on the router. A dhcp lease would usually be valid for several hours after it was last used - maybe if the lease time is very short, the router could reassign it to another mac and therefore cause the clash of the ispindel just reuses the last one. What router are you using, and can you just increase the default lease time?
It'll also depend on the router. A dhcp lease would usually be valid for several hours after it was last used - maybe if the lease time is very short, the router could reassign it to another mac and therefore cause the clash of the ispindel just reuses the last one. What router are you using, and can you just increase the default lease time?
