Author Topic: Tilt Google Sheet Import  (Read 945 times)

Offline ultrasmallbatch

  • BeerSmith Apprentice Brewer
  • **
  • Posts: 3
  • BeerSmith 2 Rocks!
Tilt Google Sheet Import
« on: July 27, 2021, 08:54:46 PM »
I have been using the tilt data import from goggle sheets in my session tab for about 10 different brews (6 months or so). I started a new file for my latest on 6/9/2021. For some odd reason it will not import anything beyond 7/9/2021 (it is currently 7/27/2021). I thought it might be some kind of data limit, so I deleted some data in my google sheets file that brought the number of points that beersmith imported down from 47 to 44. No change except that the data got a little sparser. I deleted all of the data in my beersmith file, and reloaded it using the google link. I got the same result. I haven't had any problems like this on other earlier sessions. Any ideas how I might be able to fix this? I think this is my longest session to date. Is there a date limit for import?

Offline BeerSmith

  • Brewer, Author, Patriot
  • BeerSmith Administrator
  • BeerSmith Grandmaster Brewer
  • *****
  • Posts: 5561
  • BeerSmith - take the guesswork out of brewing!
    • BeerSmith
Re: Tilt Google Sheet Import
« Reply #1 on: July 28, 2021, 01:20:37 PM »
There is filtering based on how close two samples are together which you can adjust when you import - is it possible the last few are very close together?'

Brad
Get a free trial of BeerSmith 3 here

Offline ultrasmallbatch

  • BeerSmith Apprentice Brewer
  • **
  • Posts: 3
  • BeerSmith 2 Rocks!
Re: Tilt Google Sheet Import
« Reply #2 on: July 28, 2021, 07:25:25 PM »
After 7/9, I have data on 7/14, 7/19, 7/27. Filter is set at 120 min. It just stops plotting. The values are 1.

Offline brewfun

  • BeerSmith Grandmaster Brewer
  • *****
  • Posts: 2288
  • Malt dust is just alcohol's glitter
Re: Tilt Google Sheet Import
« Reply #3 on: July 31, 2021, 07:40:20 AM »
The graph won't plot data beyond the timescale you've laid out. Make sure that your brew date is accurate and your fermentation profile has enough days to cover your fermentation cycle through those dates.
Beer Appreciation is the space between pints.

Offline Brew Bama

  • BeerSmith Master Brewer
  • ****
  • Posts: 65
Re: Tilt Google Sheet Import
« Reply #4 on: August 01, 2021, 05:37:55 AM »
The graph won't plot data beyond the timescale you've laid out. Make sure that your brew date is accurate and your fermentation profile has enough days to cover your fermentation cycle through those dates.

That?s the problem I had. I fixed the dates and it fixed it.

Offline ultrasmallbatch

  • BeerSmith Apprentice Brewer
  • **
  • Posts: 3
  • BeerSmith 2 Rocks!
Re: Tilt Google Sheet Import
« Reply #5 on: August 02, 2021, 08:09:39 AM »
I just transferred my mead to secondary to back sweeten. I decided to see if the plotting would work one last time. Wonder of wonders, my tilt data started plotting again.

Offline BeerSmith

  • Brewer, Author, Patriot
  • BeerSmith Administrator
  • BeerSmith Grandmaster Brewer
  • *****
  • Posts: 5561
  • BeerSmith - take the guesswork out of brewing!
    • BeerSmith
Re: Tilt Google Sheet Import
« Reply #6 on: August 06, 2021, 09:51:15 AM »
I did make a bunch of fixes to the import on 3.2.7.

You also need to make sure the date range is proper for the recipe - it will only show data points between the brew date for the recipe and end of your fermentation profile.
Get a free trial of BeerSmith 3 here

 

modification