copy-n-launch-xlsx 0.2.11

Stable spreadsheet copy, renaming, and dating, for municipal wastewater operator daily data entry.

copy-n-launch-xlsx

The best way to launch this application is to install the CLI using pipx, or to download a release binary.

pipx install copy-n-launch-xlsx
cnlx gui

Download binaries here: Releases

---

Purpose

This program:

• Copies a blank spreadsheet file.

• Renames it, with the date in the filename.

• Moves the new renamed file to a target folder

In this way, the stable file can be updated in a centralized way. Users can safely launch new daily data entry sheets, without needing to choose a file to launch directly.

---

Blurb

Spreadsheet templating isn't a new problem.

It's been solved many different ways over the years.

This is just one more solution—built around a very simple workflow that's now used every day by operators at my wastewater treatment plant.

Bring your own spreadsheet.

Click one button.

Get today's dated copy, ready for data entry.

The code is open source (thank you, Memphis taxpayers), and it's been tested on macOS, Windows 11, WSL, and Termux on Android.

---

XLSX Best Practices

Sheets should use Name Manager variable names and possibly tables, for reference and data aggregation. Variable names allow the cell locations to be adjusted and not referenced.

---

How To

• Place a spreadsheet named daily_blank.xlsx in the filepath: ~/.copy-n-launch-xlsx/blank/

Blank template:

~/.copy-n-launch-xlsx/blank/daily_blank.xlsx

• Hit the single green button.

Automatically generated files:

~/.copy-n-launch-xlsx/filled/daily-YYYY-MM-DD.xlsx

---

Helptree

See the copy-n-launch-xlsx Typer CLI structure.

cnlx helptree

`helptree` is a utility function for Typer CLIs, imported from the `typer-helptree` library.

• GitHub: https://github.com/City-of-Memphis-Wastewater/typer-helptree
• PyPI: https://pypi.org/project/typer-helptree/

---

Source code

Source code: Repository