Brewometer kickstarter thoughts - digital bluetooth hydrometer

[EmDubeu]

Anyone know how to use Google Sheets Importxml and parse the data into a worksheet cell?

 

[Bigfly]

How much headspace in the fermenter does the tilt need?

 

[doug293cz]

How much headspace in the fermenter does the tilt need?

Only about an inch. It rides pretty low in the liquid.

Brew on

 

[EmDubeu]

Looks like a great project for someone! importxml function isn't super simple in google docs, but maybe it's just me.

Almost got the import xml working... Just need to narrow down a Google sheets issue. Works pretty slick though.

 

[Bigfly]

Only about an inch. It rides pretty low in the liquid.

Thanks Doug I am definitely intrigued.

 

[EmDubeu]

I just updated my tilt/Brewometer cloud sheet with a script that sends emails if the data has stopped logging, temperature is too high, or the SG has achieved a certain level.There is also a cool published sheet that you can pull up on your mobile device to check in on the progress.

Here's a shared version of my brewometer cloud sheet... I've also added a Notes Sheet that describes some of the features...

https://docs.google.com/spreadsheets/d/1B25fiij8GTRIVZ09Pd-DzAoV-dK2d6YYwdlCxIEzXQE/edit?usp=sharing

Here's my published status page, which is monitoring my current brew. https://docs.google.com/spreadsheet...8lTid0ckVPQ/pubhtml?gid=601246909&single=true


Enjoy!

Updated the sheet to fix the email alert issue. Download and use this one (version 3.16):

https://docs.google.com/spreadsheet...d-DzAoV-dK2d6YYwdlCxIEzXQE/edit#gid=734290882

I'm also testing a low temperature alert to go along with the high temperature alert. You'll define the setpoint, which determines your high and low temp alert. I've got it working now, just need to make sure it's all good before I update the above shared sheet.

Also, I've given up on importing an xml recipe into the sheet. Unless someone wants to help, I'm done. I tried to use IMPORTXML, however it requires the xml file to be hosted somewhere online. The xml file can't be hosted/shared from google drive, One Drive or Dropbox...

Cheers!

 

[geoff400]

I had the misfortune to have to rebuild my Beersmith as it forgot I had registered and when I re-registered it wiped out my recipes. Now I have it back I will spend some time looking at this as it would be good to have it implemented. Thanks for your work so far it is appreciated.

 

[EmDubeu]

Updated the sheet to add some new alert functionality.
1. Added a high and low temp alert.
2. Updated the specific gravity alerts with an option to only send 1 alert if a certain specific gravity is met. (read Sheet Notes tab for more info).
3. Changed how to set a gravity alert setpoint (more clear).
4. Split the ingredients and some other values out of the "settings" tab. Now those values are in an Ingredients tab.

Download and use this one (version 3.19):
https://docs.google.com/spreadsheet...-DzAoV-dK2d6YYwdlCxIEzXQE/edit#gid=1034347503

 

[wmartino]

Hello EmDubeu,

I am trying to run your spreadsheet. I make made a copy and publish it to the web. However when I test the app I get the following error.

{"result":"error","error":{"message":"Invalid argument: id","name":"Exception","fileName":"Code","lineNumber":36,"stack":"\tat Code:36 (handleResponse)\n\tat Code:19 (doGet)\n"}}

Not sure how to troubleshoot this. Any thoughts?

Thanks

 

[EmDubeu]

Hello EmDubeu,

I am trying to run your spreadsheet. I make made a copy and publish it to the web. However when I test the app I get the following error.



Not sure how to troubleshoot this. Any thoughts?

Thanks

Did you run the setup script like the instructions say in the original cloud sheet script? Looks like the error eludes to a missing sheet id, which gets placed in the sheet user properties when the Setup script gets ran.

If you didn't run the "setup" script, you'll need to get into the script editor from your copy of the spreadsheet. (Tools Menu > Script Editor). Once there, click on the Code.gs script, then click Run menu and select setup. You may need to re-publish.

Once published, you'll need to add your sheet id, found in the url of your opened spreadsheet, and apply the id to every reference in TempAlert.gs, sgAlert.gs, and statusAlert.gs. Look for references in each script "YOUR SHEET ID HERE". Add your id in-between the single quotes.

Pm me and I'll help you get it going.

 

[wmartino]

Did you run the setup script like the instructions say in the original cloud sheet script? Looks like the error eludes to a missing sheet id, which gets placed in the sheet user properties when the Setup script gets ran.

If you didn't run the "setup" script, you'll need to get into the script editor from your copy of the spreadsheet. (Tools Menu > Script Editor). Once there, click on the Code.gs script, then click Run menu and select setup. You may need to re-publish.

Once published, you'll need to add your sheet id, found in the url of your opened spreadsheet, and apply the id to every reference in TempAlert.gs, sgAlert.gs, and statusAlert.gs. Look for references in each script "YOUR SHEET ID HERE". Add your id in-between the single quotes.

Pm me and I'll help you get it going.

Thanks EmDubeu!

Not sure how I missed that. Looks like everything is working right now.

 

[EmDubeu]

Updated my shared tilt/Brewometer cloud sheet with the following:

1. Altered Alert display to show whether or not alerts are on or off from the Main Published Sheet. Orange font means the alert setting is turned On. Grey font means alert setting is turned off.
2. Updated TempAlert, sgAlert, and StatusAlert scripts to read in the sheet id from script properties rather than need the user manually entering the ID in the script. Removed old functionality specified in v3.16.
3. Added a link to the Main Published sheet in the alert emails for easy reference to shared sheet when you get an alert.
4. Fixed an issue with tempAlert.gs not sending emails when some conditions were met. Issue introduced in v3.19.
5. Updated Recipe sheet to read BeerXML recipe data. Refer to Sheet Note; XML Conversion and Import, for further information.

Version 3.21 can be accessed here.

 

[EmDubeu]

Anyone know how to use Google Sheets Importxml and parse the data into a worksheet cell?

Never mind, figured it out....

 

[EmDubeu]

This is great EmDubeu, I am having a lot of fun with it. Just using my Tilt hydrometers for the first time, I have 2.

This gives me 2 questions, firstly can I use the same sheet to make 2 Main Published Sheet pages, one for each color? I want to send each one to a webpage I can keep track of.

My other question is about the Recipe Tab, can the details be imported from something like Beersmith or are they manually added.

Thanks for the great work

Finally got the Beersmith beerXML file to import. Check out the latest copy of the cloud sheet, if you like. v3.21

 

[allanmorgan]

Finally got the Beersmith beerXML file to import. Check out the latest copy of the cloud sheet, if you like. v3.21

Dude you are killing me with your updates! JK! Keep up the excellent work.

 

[geoff400]

Great work EmDubeu!

My 2 special requests would be adding a ABV Sparkline in Report!B30 and adding the ability to report several Tilt Hydrometers simultaneously ;-)

 

[raysmithtx]

Updated my shared tilt/Brewometer cloud sheet with the following:

1. Altered Alert display to show whether or not alerts are on or off from the Main Published Sheet. Orange font means the alert setting is turned On. Grey font means alert setting is turned off.
2. Updated TempAlert, sgAlert, and StatusAlert scripts to read in the sheet id from script properties rather than need the user manually entering the ID in the script. Removed old functionality specified in v3.16.
3. Added a link to the Main Published sheet in the alert emails for easy reference to shared sheet when you get an alert.
4. Fixed an issue with tempAlert.gs not sending emails when some conditions were met. Issue introduced in v3.19.
5. Updated Recipe sheet to read BeerXML recipe data. Refer to Sheet Note; XML Conversion and Import, for further information.

Version 3.21 can be accessed here.

Just want to say thank you for the spreadsheet. It works flawlessly. If you have a Tilt/Brewometer then this is a vast improvement on the standard spreadsheet that comes with the device.

 

[EmDubeu]

Just want to say thank you for the spreadsheet. It works flawlessly. If you have a Tilt/Brewometer then this is a vast improvement on the standard spreadsheet that comes with the device.

Thank you. I've enjoyed working on it. Personally, I love how I got google sheets to automatically send emails when certain criteria is met. Totally blown away that it can do this.

Btw, I just added abv% trend data to the Log and Report sheets. I think I'm going to rework the Report sheet a bit, and I need to clean up the script code a bit. I've see that it's not super efficient, and uses too much computer time to process. Once this is done, I'll be pushing out another updated sheet.

 

[thekraken]

This is an awesome spreadsheet, EmDubeu! I'll try it out.

So is the idea here that you keep logs for all brews in this file together, or reset it for new brews? Is there a reset or 'clear data' button?

 

[raysmithtx]

You can show data based on a date range or the Brew Name so I'm guessing you could keep all of your brew data for all of your brews on this spreadsheet.

 

[newtonfb]

Thank you. I've enjoyed working on it. Personally, I love how I got google sheets to automatically send emails when certain criteria is met. Totally blown away that it can do this.

Btw, I just added abv% trend data to the Log and Report sheets. I think I'm going to rework the Report sheet a bit, and I need to clean up the script code a bit. I've see that it's not super efficient, and uses too much computer time to process. Once this is done, I'll be pushing out another updated sheet.

I see you got the beersmith import working but I was looking at your recipe and it seems like your hops schedule might be messed up. For your boil they all say 0.

 

[EmDubeu]

I see you got the beersmith import working but I was looking at your recipe and it seems like your hops schedule might be messed up. For your boil they all say 0.

0 minute hop additions are basically flame-out/whirlpool hops. They are noted in beersmith as 0 min hops.

 

[newtonfb]

0 minute hop additions are basically flame-out/whirlpool hops. They are noted in beersmith as 0 min hops.

Gotcha. Ya I whirlpool all the time. I just figured it would have said "steep/whirlpool". Either way, I like the recipe.

 

[pullapint]

It'd like to throw a big thanks to EmDubeu for your work on this too. Can't wait to try it out.

 

[EmDubeu]

Gotcha. Ya I whirlpool all the time. I just figured it would have said "steep/whirlpool". Either way, I like the recipe.

The xml file produced from Beersmith unfortunately do not contain Steep/Whirlpool descriptions. Currently, they are tagged as "Aroma". Also, when using Dry Hops, the xml file shows the DISPLAY_TIME as minutes, not days. I've reported this to beersmith.com, but I haven't heard back yet. I just manually go into the xml file and manually make the corrections.

 

[EmDubeu]

Updated my cloud sheet. There were so many little changes here and there that I published a new shared file (Fermenator Cloud v3). You can copy it from here. The older v2 is still shared.

I added the following:
v3.3
1. Updated Report sheet with more organized display of data. Updated scripts to reflect the various cell location changes in the Report sheet.
2. Added ABV content to Report and a new ABV sparkline.@geoff400
3. Renamed 'Main Published Sheet' to 'Dashboard'

 

[thekraken]

This is awesome, I really appreciate all the work you're doing. As a noob I would love to see a step by step instruction sheet to get up and running as I was a little overwhelmed at first glance.

 

[EDF713]

With all the posts related to EmDubeu's new and improved Google sheets I hate to change the subject, but I wanted to say a word about the awesome customer service from the guys at Tilt. Back in February I pulled the trigger and bought the Tilt. Things were too busy to brew when I bought it, but I calibrated and tested my model, and found it would only connect intermittently. I thought maybe the battery was old, in fact posted some questions to this thread about it, so I replaced the battery. Once again, it would not connect consistently, but did some. This is where I should have contacted the guys at Tilt, but things were busy and I stored it for use later. Fast forward to last Friday, I brewed up a Bohemian Pilsner and dropped in my Tilt, which I found would no longer would connect.

I emailed the issue and some questions to the guys at Tilt, and within an hour received an email from Marcus apologizing for the issues, said they were giving me grace on the 30 day return policy, and had sent a replacement Tilt with a return envelope for the old Tilt! Not only that, after sending a note Saturday morning I got my Tilt on Monday. My Pilsner still had a good krausen last night, so after calibrating and sanitizing I dropped in the new Tilt, fished out the old one to return, and I'm in business!

If there is anyone out there considering a purchase of the Tilt, these guys really care about their product and customer service. I can say with confidence from my experience that in the off chance you have a problem, they will fix it and make it right. Kudos to the Tilt Hydrometer team!

 

[allanmorgan]

@EmDubeu Your new sheets looks awesome! Thanks again for all the work you have put into this and sharing it out to everyone!

Question about clearing the data. I can remove all the data for Sheet1 without issue. However, on the Report sheet, the pinkish cells in the Heartbeat column don't clear. Any way to clear that color out of those cells when starting a new brew?

 

[EmDubeu]

I completely agree with your assessment of the Tilt team, @EDG715. They are super responsive and they have a great product. In my opinion, they have one of the greatest technological advancements that the home brewing community has seen in a long time, if ever. The Tilt isn't required to make great beer, although it makes monitoring your brew so much easier, and it's fun, too! If for some odd, unexpected reason my Tilt dies, I will most certainly be buying another one. I recommend this device to everyone I interact with who makes beer.