July 2024 - August 2024
This project automates the process of logging water pressure levels by hand.
Working for a construction copmany over a summer, I was breifly tasked with monitoring water pressure as work in a comprised area was being performed.
There was a website with a handful of graphs, and every ~5 minutes the site would update the levels with data from the server, and I would have to write this level down and report if it exceeded a certain threshold.
I immediately wanted to automate this, so I created the following, script in a notepad file. Primarily Javascript, it runs in the Chrome console, fetches data from the server, cleans the data, and creates .csv formmated files that mimmicked the sheets I was tasked with filling out.
Apart from automation and saving time, this allowed for water levels to be measured even when the website (but not the API) was down, which was not something that could have been performed prior.
The Python code involed is merely for converting the large swath of .csv chained together in the output of the Javascript script into individual .xlxs files on disc.
As of last year, the job was finished and the server was shut down.