![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
When I ran the annual report queries for Lambert House yesterday afternoon, numbers that were supposed to add up according to the director failed to do so. And some of them had already been reported to the funding agency at the city. Uh oh.
Basically, I have to count youth* that use different services – the many support groups and recreational activities, dinner and the clothing bank in the Before Times – and I need to keep different statistics with different conditions for different groups of services. This is all in Microsoft Access's pidgin SQL, which often forces me to write more code in order to get things to run at all. Writing more code, as Bill Gates has said, is bad.
Not only were the groups of services not consistent for some queries in which they needed to be; some of them were completely unreported because the director had forgotten to tell me about several new services that had been introduced since the start of the pandemic. So we both screwed up.
The director gets to grovel to the city for forgiveness, I guess, but most if not all reports we've sent to the city since the start of the pandemic contained at least some inaccuracies. In years past we could count on them not to look at them even though we were contractually required to send them. Things have tightened up in recent years. The good news is that we can now redo them accurately if need be.
I just got to spend three hours of a lovely Sunday afternoon freezing my butt off in an unheated house debugging and running database queries. I didn't really warm up until I got into my front door. If there's such a thing as queer karma, I've got hot lesbian sex coming soon.
*We don't call them kids because they don't like it, at least not to their faces.
Basically, I have to count youth* that use different services – the many support groups and recreational activities, dinner and the clothing bank in the Before Times – and I need to keep different statistics with different conditions for different groups of services. This is all in Microsoft Access's pidgin SQL, which often forces me to write more code in order to get things to run at all. Writing more code, as Bill Gates has said, is bad.
Not only were the groups of services not consistent for some queries in which they needed to be; some of them were completely unreported because the director had forgotten to tell me about several new services that had been introduced since the start of the pandemic. So we both screwed up.
The director gets to grovel to the city for forgiveness, I guess, but most if not all reports we've sent to the city since the start of the pandemic contained at least some inaccuracies. In years past we could count on them not to look at them even though we were contractually required to send them. Things have tightened up in recent years. The good news is that we can now redo them accurately if need be.
I just got to spend three hours of a lovely Sunday afternoon freezing my butt off in an unheated house debugging and running database queries. I didn't really warm up until I got into my front door. If there's such a thing as queer karma, I've got hot lesbian sex coming soon.
*We don't call them kids because they don't like it, at least not to their faces.
no subject
Date: 2022-01-11 06:29 am (UTC)From:no subject
Date: 2022-01-11 05:28 pm (UTC)From: