Report Bobcat Status to Google Sheets

Jasmit Tarang

Last update: Sep 22, 2021

Related tags

General Utilities bobcat-status-reporter

Overview

bobcat-status-reporter

Report Bobcat Status to Google Sheets

Why?

I recently relocated my miner from my root into the attic. Bobcat recommends operating temperature be below 60C. I just wanted to make sure the temp did not exceed that.

Requirements

Python 3.9.*
Bobcat Miner
Google Sheets API Service Account

Setup Environment

Install Requirements pip install -r requirements.txt

Arguments

Usage: report_miner_status.py [OPTIONS] MINER_IP_ADDRESS
                              GOOGLE_SHEETS_CREDENTIALS_FILE_PATH
                              GOOGLE_SHEET_ID

Arguments:
  MINER_IP_ADDRESS                [required]
  GOOGLE_SHEETS_CREDENTIALS_FILE_PATH
                                  [required]
  GOOGLE_SHEET_ID                 [required]

Options:
  --worksheet-id INTEGER
  --clear-worksheet / --no-clear-worksheet
                                  [default: False]
  --timezone TEXT
  --help                          Show this message and exit.

Find your timezone string by searching for it here If no timezone is passed UTC is the default.

Usage

python report_miner_status.py 192.168.50.155 ./.credentials/bobcat-miner-service-account.json BobcatMinerReport

I would set this up as a cronjob and run it every minute.

Crontab for *nix systems
Task Scheduler for Windows

Example Output

Google Sheets

Future Features

Alert via Text Message if exceed temp threshold

Fairstructure - Structure your data in a FAIR way using google sheets or TSVs

Fairstructure - Structure your data in a FAIR way using google sheets or TSVs. These are then converted to LinkML, and from there other formats

23 Dec 1, 2022

Discord bot that displays Jazz Jackrabbit 2 server status, current gamemode as "Playing.." status

JJ2-server-status-discord-bot Discord bot that displays Jazz Jackrabbit 2 server status, current gamemode as "Playing.." status How to setup: 0. Downl

2 Dec 9, 2021

A simple python script that parses the MSFT Teams log file for the users current Teams status and then outputs the status color to a MQTT connected light.

Description A simple python script that parses the MSFT Teams log file for the users current Teams status and then outputs the status color to a MQTT

8 Dec 16, 2022

First Party data integration solution built for marketing teams to enable audience and conversion onboarding into Google Marketing products (Google Ads, Campaign Manager, Google Analytics).

Megalista Sample integration code for onboarding offline/CRM data from BigQuery as custom audiences or offline conversions in Google Ads, Google Analy

76 Dec 29, 2022

A post-processing tool for scanned sheets of paper.

unpaper Originally written by Jens Gulden — see AUTHORS for more information. Licensed under GNU GPL v2 — see COPYING for more information. Overview u

27 Dec 7, 2022

Official Matplotlib cheat sheets

6.7k Jan 9, 2023

Official Matplotlib cheat sheets

6.7k Jan 9, 2023

Make visual music sheets for thatskygame (graphical representations of the Sky keyboard)

sky-python-music-sheet-maker This program lets you make visual music sheets for Sky: Children of the Light. It will ask you a few questions, and does

21 Aug 26, 2022

A Python tool used to automate the execution of the following tools : Nmap , Nikto and Dirsearch but also to automate the report generation during a Web Penetration Testing

📡 WebMap A Python tool used to automate the execution of the following tools : Nmap , Nikto and Dirsearch but also to automate the report generation

274 Jan 1, 2023

daily report of @arkinvest ETF activity + data collection

ark_invest daily weekday report of @arkinvest ETF activity + data collection This script was created to: Extract and save daily csv's from ARKInvest's

27 Jan 2, 2023

Participants of Bertelsmann Technology Scholarship created an awesome list of resources and they want to share it with the world, if you find illegal resources please report to us and we will remove.

Participants of Bertelsmann Technology Scholarship created an awesome list of resources and they want to share it with the world, if you find illegal

29 Nov 28, 2022

Combining Automatic Labelers and Expert Annotations for Accurate Radiology Report Labeling Using BERT

CheXbert: Combining Automatic Labelers and Expert Annotations for Accurate Radiology Report Labeling Using BERT CheXbert is an accurate, automated dee

51 Dec 8, 2022

Code for technical report "An Improved Baseline for Sentence-level Relation Extraction".

RE_improved_baseline Code for technical report "An Improved Baseline for Sentence-level Relation Extraction". Requirements torch = 1.8.1 transformers

74 Nov 29, 2022

Produces a summary CSV report of an Amber Electric customer's energy consumption and cost data.

Amber Electric Usage Summary This is a command line tool that produces a summary CSV report of an Amber Electric customer's energy consumption and cos

12 May 26, 2022

Analyse a forensic target (such as a directory) to find and report files found and not found from CIRCL hashlookup public service

Analyse a forensic target (such as a directory) to find and report files found and not found from CIRCL hashlookup public service. This tool can help a digital forensic investigator to know the context, origin of specific files during a digital forensic investigation.

96 Dec 20, 2022

Easily report Instagram pages and close the page

Program Features - 📌 Delete target post on Instagram. - 📌 Delete Media Target post on Instagram - 📌 Complete deletion of the target account on Inst

11 Nov 25, 2022

Developed a website to analyze and generate report of students based on the curriculum that represents student’s academic performance.

Developed a website to analyze and generate report of students based on the curriculum that represents student’s academic performance. We have developed the system such that, it will automatically parse data onto the database from excel file, which will in return reduce time consumption of analysis of data.

3 Nov 8, 2022

A weather report application build with Python, Flask, and Geopy.

A weather report application build with Python, Flask, and Geopy. Requirements Python 3

6 May 7, 2022

GitHub Usage Report

github-analytics from github_analytics import analyze pr_analysis = analyze.PRAnalyzer( "organization/repo", "organization", "team-name",

1 Oct 26, 2021

Comments

Allow other time zone timestamps

Current timestamp only shows in UTC which comes from the miner itself. Would be great to be able to have option to convert it to my local time with daily savings taken into consideration. 👍

opened by tslastff 6

Report Bobcat Status to Google Sheets

Related tags

Overview

bobcat-status-reporter

Why?

Requirements

Setup Environment

Arguments

Usage

Example Output

Future Features

You might also like...

Fairstructure - Structure your data in a FAIR way using google sheets or TSVs

Discord bot that displays Jazz Jackrabbit 2 server status, current gamemode as "Playing.." status

A simple python script that parses the MSFT Teams log file for the users current Teams status and then outputs the status color to a MQTT connected light.

First Party data integration solution built for marketing teams to enable audience and conversion onboarding into Google Marketing products (Google Ads, Campaign Manager, Google Analytics).

A post-processing tool for scanned sheets of paper.

Official Matplotlib cheat sheets

Official Matplotlib cheat sheets

Make visual music sheets for thatskygame (graphical representations of the Sky keyboard)

A Python tool used to automate the execution of the following tools : Nmap , Nikto and Dirsearch but also to automate the report generation during a Web Penetration Testing

daily report of @arkinvest ETF activity + data collection

Participants of Bertelsmann Technology Scholarship created an awesome list of resources and they want to share it with the world, if you find illegal resources please report to us and we will remove.

Combining Automatic Labelers and Expert Annotations for Accurate Radiology Report Labeling Using BERT

Code for technical report "An Improved Baseline for Sentence-level Relation Extraction".

Produces a summary CSV report of an Amber Electric customer's energy consumption and cost data.

Analyse a forensic target (such as a directory) to find and report files found and not found from CIRCL hashlookup public service

Easily report Instagram pages and close the page

Developed a website to analyze and generate report of students based on the curriculum that represents student’s academic performance.

A weather report application build with Python, Flask, and Geopy.

GitHub Usage Report

Comments

Allow other time zone timestamps

Owner

Jasmit Tarang

Report-snapchat - Report Snapchat acc with python

Google Sheets Python API

Google Sheets Python API v4

Google Sheets Python API v4

ProPublica's collaborative tip-gathering framework. Import and manage CSV, Google Sheets and Screendoor data with ease.

ProPublica's collaborative tip-gathering framework. Import and manage CSV, Google Sheets and Screendoor data with ease.

A Discord BOT that uses Google Sheets for storing the roles and permissions of a discord server.

Autodrive is designed to make it as easy as possible to interact with the Google Drive and Sheets APIs via Python

A discord bot that utilizes Google's Rest API for Calendar, Drive, and Sheets

Peloton Stats to Google Sheets with Data Visualization through Seaborn and Plotly