Metadata-Version: 2.4
Name: copy-n-launch-xlsx
Version: 0.2.9
Summary: Stable spreadsheet copy, renaming, and dating, for municipal wastewater operator daily data entry.
Author-email: George Clayton Bennett <george.bennett@memphistn.gov>
Maintainer-email: George Clayton Bennett <george.bennett@memphistn.gov>
Project-URL: Homepage, https://github.com/city-of-memphis-wastewater/copy-n-launch-xlsx
Project-URL: Repository, https://github.com/city-of-memphis-wastewater/copy-n-launch-xlsx
Project-URL: Issues, https://github.com/city-of-memphis-wastewater/copy-n-launch-xlsx/issues
Project-URL: Changelog, https://raw.githubusercontent.com/city-of-memphis-wastewater/copy-n-launch-xlsx/main/docs/CHANGELOG.md
Keywords: data entry,xlsx
Classifier: Programming Language :: Python :: 3
Classifier: Programming Language :: Python :: 3 :: Only
Classifier: Programming Language :: Python :: 3.9
Classifier: Programming Language :: Python :: 3.10
Classifier: Programming Language :: Python :: 3.11
Classifier: Programming Language :: Python :: 3.12
Classifier: Programming Language :: Python :: 3.13
Classifier: Programming Language :: Python :: 3.14
Classifier: Operating System :: OS Independent
Classifier: Development Status :: 5 - Production/Stable
Requires-Python: >=3.9
Description-Content-Type: text/markdown
License-File: LICENSE
Requires-Dist: pyhabitat>=1.3.2
Requires-Dist: rich>=14.2.0
Requires-Dist: typer>=0.20.0
Requires-Dist: click>=8.1.8
Requires-Dist: openpyxl>=3.1.5
Requires-Dist: dworshak-config>=0.2.8
Requires-Dist: dworshak-env>=0.1.8
Requires-Dist: typer-helptree>=0.2.10.5
Dynamic: license-file

# copy-n-launch-xlsx

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.


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

Any embedded spreadhseet is specific to the Maxson Wastewater Treatment Operator data input.

---

## How To:

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


---

## Helptree

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

```
cnlx helptree
```

<p align="center">
  <img src="https://raw.githubusercontent.com/City-of-Memphis-Wastewater/copy-n-launch-xlsx/main/assets/copy-n-launch-xlsx_v0.2.9_helptree.svg" width="100%" alt="Screenshot of the CLI helptree">
</p>
`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/

---
