• 1 Post
  • 23 Comments
Joined 1 year ago
cake
Cake day: July 4th, 2023

help-circle
rss















  • I use Google sheets on my personal projects.

    • tracking expenses
    • tracking my ride logs from my ev

    Google app script pickup email received from banks and update the transaction automatically. I modify it using web based form of needed.

    The ev company has api. It will be called on periodic basis to get the ride details and update the sheets. I use telegram api to interact, by triggering the api webhook, getting charts, etc.,

    Initially I setup OCR to extract the ride information, so the process was like

    • send an image that has ride details to a telegram bot
    • the bot saves the image in Google drive
    • the image would be opened in docs
    • the text would get extracted and stored in Google sheets as data
    • edits can be done using telegram webapp
    • sheets provide charts for analysis
    • built a process using sheets to handle telegram bot for maintaining users, approvals, etc.,

    It would be hard if I have used any other services… setting up OCR preparing charts etc.,






  • Was an AVP in a bank moved to a different company to work as a software consultant with a 10% hike. I would be earning more than what I'm earning if I had stayed, but I'm happy now.

    The company I worked for had installed software that tracks keyboard and mouse movements, it considers I'm idle if I don't touch them for 180 seconds. Sometimes I lose more than 50% of the time because of attending meetings, it would report I was unproductive.

    It always gave me a feeling like someone constantly standing behind my back and watching.

    I usually work fast and complete things well in advance and spend time in the thought process of solving problems and enhancing existing process. Though I delivered more than what was expected from me, I was feeling insecure by someone gauging my performance by the amount of time I spent on computers.