mc3k’s gists

mc3k / heatindex-function.sql

Last active June 5, 2025 12:32

Creates a function in MariaDB for the computation of the heat index

	CREATE OR REPLACE FUNCTION CalcHeatIndex(IN T FLOAT, IN RH FLOAT) RETURNS FLOAT

	BEGIN
	# https://www.wpc.ncep.noaa.gov/html/heatindex_equation.shtml
	DECLARE HI, HI2, HI2a, HI3 float;
	SET T = ((T*9/5)+32 ); # convert C to F
	SET HI = (0.5(T + 61.0 + ((T-68.0)1.2) + (RH*0.094)));
	SET HI2 = (-42.379 + 2.04901523T + 10.14333127RH - 0.22475541TRH - 0.00683783TT - 0.05481717RHRH + 0.00122874TTRH + 0.00085282TRHRH - 0.00000199TTRHRH);
	SET HI2a = - ((13-RH)/4)*sqrt((17-abs(T-95))/17);
	SET HI3 = CASE WHEN (HI < 80) THEN HI

mc3k / rpi_models.sql

Last active January 2, 2025 21:03

	DROP TABLE IF EXISTS rpi_models;

	CREATE TABLE "RPI_Models" (
	'Family' TEXT,
	'Model' TEXT,
	'SoC' TEXT,
	'Memory' REAL,
	'Formfactor' TEXT,
	'Ethernet' TEXT,
	'Wireless' TEXT,

mc3k / elevplot.sh

Created January 1, 2025 01:20

Plot the elevation profile of GPX profile using GNUPlot and GPXPlot3.py

	#!/bin/bash
	SCRIPT=$(readlink -f $0)
	SCRIPTPATH=`dirname $SCRIPT`
	cd "$SCRIPTPATH"

	python3 gpxplot3.py -y elevation -x distance $1 > gpx.dat & pid1=$!
	wait $pid1

	echo "
	set output '$1.png'

mc3k / heatindex.py

Last active December 31, 2024 23:41

Calculate Heat Index from Temperature and Relative Humidity

	import math, sys, os


	def heat_index_wpc(temp,humid):
	# https://www.wpc.ncep.noaa.gov/html/heatindex_equation.shtml
	T = float(temp)*9/5 +32
	RH = float(humid)
	HI = -42.379 + 2.04901523T + 10.14333127RH - .22475541TRH - .00683783TT - .05481717RHRH + .00122874TTRH + .00085282TRHRH - .00000199TTRHRH
	if RH < 13 and T > 80 and T < 112 :
	HI = HI - ((13-RH)/4)*math.sqrt((17-abs(T-95))/17)

mc3k / log-tp350s.py

Last active December 31, 2024 17:33

Log ThermoPro TP350S temperature and humidity in Linux

	import sys, os, logging, datetime
	from tp357tool import *

	temp, humid = None, None
	mac = 'MY:MA:CA:DD:RE:SS'

	# Read data from ThermoPro
	device, read, write = bt_setup(mac)
	temp, humid = wait_for_temp(read, write)

mc3k / fit-to-gpx-win-fancy.bat

Last active December 22, 2024 14:10

	@echo off
	Title Batch convert fit to gpx
	for %%i in (*.fit) do "C:\Program Files\GPSBabel\gpsbabel.exe" -rt -i garmin_fit -f %%i -x track,course,speed -o gpx -F %%~ni.gpx && echo [32m%%i[0m converted to [35m%%~ni.gpx[33m
	pause

mc3k / LoanPaymentScheduleCalculator.sql

Created November 9, 2017 16:33

	-- ====================================================================================================================
	-- Author: Martin Childs
	-- Create date: 2017-11-09
	-- Description: Calculates a mortgage style annuity loan payment schedule
	-- Version: v001
	-- ====================================================================================================================


	Print'Create numbered list'
	--http://sqlperformance.com/2013/01/t-sql-queries/generate-a-set-1

mc3k / StaticRamdom().vba

Last active November 6, 2017 00:45

	Function StaticRandom(Input1 As String, Optional Rand_Input As Double = 0) As Variant
	' Create a pseudo random number which doesn't change for a given input
	' Martin Childs, 2016-07-05
	' v001
	'
	Prime = 9973

	'Checksum
	checksum = Len(Input1)

mc3k / Trendlineparse().vba

Created November 6, 2017 00:10

	Public Function TrendlineParse(Eqtn As String, Optional xVal As Variant = "eq", Optional xType As Variant = 0) As Variant
	'Function Convert trendline equations into formulas
	' (c) Martin Childs 2017

	Eqtn = Replace(Eqtn, " ", "")

	'Return equation
	If xVal = "eq" Then
	TrendlineParse = Eqtn
	Exit Function

mc3k / clock.py

Created October 28, 2017 23:26

	#!/usr/bin/env python

	from lib_oled96 import ssd1306
	import time
	#import sys
	from PIL import ImageFont, ImageDraw#, Image

	from smbus import SMBus
	i2cbus = SMBus(1) # 1 = Raspberry Pi but NOT early REV1 board

marty mc3k