Arthur Eschenlauer eschen42

Funded Ratio Calculation in SQL

by @eschen42 (https://github.com/eschen42)
Version 0.1.3 - 5 February 2026

Not financial advice

This is not financial advice, of course. This code is provided AS IS, with no guarantee that the calculations are correct or that the results are reliable for any particular purpose. If you don't fully understand what to do with this code or the results, pay a professional to get guidance; you'll probably be very glad that you did.

Why compute the funded ratio?

Broadband 10m–20m Balanced Dipole with Z-Match ATU

This is my lightly edited dialog with Microsoft Copilot. Initially, I ran "Deep Research" against the first prompt.

1. Prompt for Broadband 10m–20m Balanced Dipole with Z-Match ATU

I want to create an electrical schematic for a broad band (10m - 20m) balanced amateur radio antenna with a balanced feed line that is connected to the transceiver at via a Z-match antenna tuner unit (ATU).

There will be two 50 foot long LMR 240 coax cables whose cores ("C+" and "C-") will feed two the two antenna radiators ("R+" and "R-", each 29 ft long and horizontal, oriented anti-parallel to one another, fed at the "proximal" end with no connection at the "distal" end).
Label the ends of coax as "T" for transciever and "A" for antenna.

ABANDONED DESIGN! please ignore (or laugh)

Design of a 10.20 m Center-Fed Folded Dipole with Shunt-Connected Open Stubs

This is a discussion of designing a multiband trapless low-SWR antenna for the upper HF amateur radio bands. Responses are from Microsoft Copilot <https://copilot.microsoft.com>.

**Design an 10.2 meter center fed folded dipole antenna for the 20m (14.0-14.35 MHz), 17m (18.068-18.168 MHz), 15m (21.0-21.45 MHz), 12m (24.89-24.99 MHz), 11m (26.96-27.41 MHz), and 10m (28.0-29.7 MHz) amateur radio bands using a 20 gauge silicone insulated antenna wire with a 1.8mm outside diameter, fed by a 200 ohm balanced feedline. For each band, show the expected ranges of SWRs and impedances, and break down each impedance into its reactive and resistive components. To minimize the SWRs, design symmetrical open circuit stubs that are shunt-connected at the feedpoint and each composed of two identical lengths of antenna wire; add three stubs to the design to redu

Open Powershell or Cmd as Administrator and run the following commands

wsl --shutdown
netsh winsock reset
netsh int ip reset all
netsh winhttp reset proxy
ipconfig /flushdns

	#!/usr/local/bin/icon

	############################################################################
	#
	# File: ulogd2sql.icn
	#
	# Subject: Parse ulogd syslog lines to SQLite insertion statements
	#
	# Author: Art Eschenlauer, adapted from rough-in by Microsoft Copilot
	#

	# LCTboot_inspect - TestCor::LCTboot modified:
	# - to return a "reportables" data.frame as an attribute of the result
	# - (for estimating the adjusted and unadjusted p-values)
	# - to return the function environment as an attribute of the result
	# - (for debugging reportables)
	# - to use the normal approximation when Nboot == 0
	# - (so that the same code base may be used for LCT-N and LCT-B)
	# ref: https://github.com/cran/TestCor/blob/9d5d2a9a1ac284e3346bd144776559cbd82a8b52/R/FdrMethods.R
	#' Bootstrap procedure LCT-B proposed by Cai & Liu (2016) for correlation testing.
	#'

	procedure co_foo(state, args[])
	return .(state[args[1]] +:= args[2])
	end

	procedure co_new()
	local state, foo, msg
	state := table()
	state["something"] := 1
	@(
	foo := create (

	#!/bin/env icon
	############################################################################
	#
	# File: pingstat.icn
	#
	# Subject: pingstat.icn - compute statistics for unix ping output
	#
	# Author: Arthur Eschenlauer (https://orcid.org/0000-0002-2882-0508)
	#
	# Date: 21 August, 2022

	############################################################################
	#
	# File: [progname].icn
	#
	# Subject: [progname].icn - [subtitle succinctly describing what progname.icn is or does]
	#
	# Author: Arthur Eschenlauer (https://orcid.org/0000-0002-2882-0508)
	#
	# Date: [e.g. 26 March, 2020]
	#

	#' Emulate fgrep, i.e., is any of needles found in any of haystacks
	#'
	#' This should perform adequately for a few needles.
	#'
	#' If performance for many needles is inadequate, use
	#' `0 < length(AhoCorasickTrie::AhoCorasickSearch(needles, haystacks)[[1]])`
	#' as the implementation for a more realistic emulation of fgrep.
	#'
	#' @param needles A character vector of length 1 or more
	#' @param search_strings A character of length 1 or more