![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
I outsmarted myself!
Apr. 7th, 2020 10:54 amBecause of the Coronavirus Emergency, my work has gone to 2 12-hour shifts a day instead of 3 8-hour shifts - 8 AM to 8 PM and 8 PM to 8 AM.
Among my jobs is to track the production of... we call it "solids"... every day. (My workplace is a wastewater treatment facility. You can guess what "solids" might be and you'd be about half right.) My bosses want that production pro-rated so that instead of the "day" running 8 pm to 8 pm (which would match the production totals I'm getting from the operators) I chop off 4 hours of each day and assign it to the previous day.
This has mostly proven easier than one might imagine. Mostly.
I changed the timestamp on the Afternoon shift data entry to be 8 pm instead of 4 pm, because it reflects, accurately, an 8 hour shift, a 12 hour shift, and a 4 hour shift every day. The reports that summarize the solids production operations are still looking at 4 pm instead of 8 pm, so it's adding the day shift value in a second time instead of adding the afternoon shift value.
Well heck.
...and because of the way data is stored in the database, it will be so much easier to reprogram the reports. Which I can't do from home. And so much easier is still not easy.
"well heck" indeed.
Among my jobs is to track the production of... we call it "solids"... every day. (My workplace is a wastewater treatment facility. You can guess what "solids" might be and you'd be about half right.) My bosses want that production pro-rated so that instead of the "day" running 8 pm to 8 pm (which would match the production totals I'm getting from the operators) I chop off 4 hours of each day and assign it to the previous day.
This has mostly proven easier than one might imagine. Mostly.
I changed the timestamp on the Afternoon shift data entry to be 8 pm instead of 4 pm, because it reflects, accurately, an 8 hour shift, a 12 hour shift, and a 4 hour shift every day. The reports that summarize the solids production operations are still looking at 4 pm instead of 8 pm, so it's adding the day shift value in a second time instead of adding the afternoon shift value.
Well heck.
...and because of the way data is stored in the database, it will be so much easier to reprogram the reports. Which I can't do from home. And so much easier is still not easy.
"well heck" indeed.
