Logging Your Rides to Google Sheets

[anbuchelva]

This is my solution for the ride log issue.

Ather Ride log to Google Sheets

Tools used:

Telegram bot - for sharing the image and for cost free API.
Google Drive - to store the image
Google Sheets - to store the data for analysis
Google Docs - to run OCR

I’ll try to write the process of setting up this for individuals. It may be helpful for the community.

[arnab (Arnab Mohapatra)]

Waiting.

Ather should open up it’s api as well.

@abhishek.balaji

[syed.ishtiaq.apple (Syed Ishtiaq)]

Grate job

[anbuchelva]

I have tried to document all the steps here: Collect Ather Logs in Google Sheets via Telegram Bot

I know it is going to take lot of time for someone who has not used google sheets or telegram to setup completely. I hope it would be worth a try.

Please check and let me know the feedback.

btw, I have added few charts based on the ride logs and I like the way it turned out. Some samples are here:

[anbuchelva]

I created a public bot for those who has difficulties in following up all the instructions. You need to start and register; you will be able to use it once I approve it.

The bot link: Telegram: Contact @ev_log_bot

The bot can be accessed only by a limited set of people, as it uses only the free limit set by Google and Telegram.

If you want to set up your own bot get the source code and sample google sheets file from github repo: GitHub - anbuchelva/ev-log-bot

[nabinnaskar]

How can I get these ?

[anbuchelva]

Download Telegram
Create an account
Click this link which will open in Telegram Telegram: Contact @ev_log_bot
Start the bot
Use command /register
Once I approve, you can start sharing your ride logs as explained in the video on the first post.
Use menu on the bot to get charts.

[anbuchelva]

Released version 3 of the bot, which brings edit the ride logs generated from OCR and various bug fixes.

EV Log Bot - Version 3

Telegram bot URL: Telegram: Contact @ev_log_bot
Github URL: GitHub - anbuchelva/ev-log-bot

[whomever97]

You are doing far better job than Ather software team

[anbuchelva]

I have been tracking the ride statistics for last 30 days. Here are the results.

[saalamsaifi (Shahdab Aalam Saifi)]

Thank you @anbuchelva for sharing this information. This Telegram bot is quite good and easy to use.

[venkanna.garimella (GARIMELLA VENKATA RAMANA)]

Iam using Ather 450s Iam very much disappointed by purchasing this vehicle now Iam repenting why I have purchased Iam getting range of 56 to 60 on full charging Can body tell me this my vehicle problem or In general vehicle performance will be like this

[manasChandran]

Share the screenshot of your recent ride insights from the app please

Also check this post

Tips on how to get good range from your Ather 450X

I have heard many people complain about the range they get in different modes (Eco/Ride/Sports). I have a fair understanding on how the battery is utilized based on my riding styles and my observations. I have achieved ~100kms in SPORTS / RIDE modes and not in ECO mode on my Ather 450 and I will explain how. [Ather 450 range speed info] As per the above image, Ather has provided us the numbers for each mode. These ranges are not the maximum that you can achieve. ECO mode: 75 kms range with…

[Omkar_Bochgire]

Low model is just made for low experience and power why you choosed low model choose top model instead.

[venkanna.garimella (GARIMELLA VENKATA RAMANA)]

[manasChandran]

Your throttling is bit on the harsh side i guess seeing the efficiency figures ,please go through the link i shared it will help

[venkanna.garimella (GARIMELLA VENKATA RAMANA)]

Have you shared link in the community

[anushkkrastogi (Anushk Rastogi)]

try riding in sport mode.

[venkanna.garimella (GARIMELLA VENKATA RAMANA)]

Please clarify whether it is my vehicle problem or general probelm in 450s

[psprabu_in (Prabu P S)]

For short trips efficiency will be always high only. Try to see on some logger trip. All these trips are just 1+ KM so you cannot judge your Vehicle performance.