This Instant And Moment - 2023!

Status
Not open for further replies.
Really annoying that you can't ignore OcUK staff members on this forum... They aren't moderators, so whats the problem?
 
Think i've got insomnia again, second day in a row wide awake at 3/4AM :(

Ever since COVID, don't think it is coincidence, my sleeping has been atrocious - often I get home and just have to crash but only sleep for 1.5 hours then wide awake and then maybe get another 3 hours before I have to get up for work :( which becomes a bit of a vicious cycle. My work schedule at the moment doesn't help either with overtime front loaded in the day rather than finishing later, hopefully things calm down after Christmas into a shift pattern more amenable to sleep.
 
Ever since COVID, don't think it is coincidence, my sleeping has been atrocious - often I get home and just have to crash but only sleep for 1.5 hours then wide awake and then maybe get another 3 hours before I have to get up for work :( which becomes a bit of a vicious cycle. My work schedule at the moment doesn't help either with overtime front loaded in the day rather than finishing later, hopefully things calm down after Christmas into a shift pattern more amenable to sleep.
IIRC you're in distribution same as me?

Are you on shifts still? I'molucky in that I moved to office based a while back and my sleep improved dramatically on a 9-5 - just a lot going on right now and don't think my brain can switch off.
 
IIRC you're in distribution same as me?

Are you on shifts still? I'molucky in that I moved to office based a while back and my sleep improved dramatically on a 9-5 - just a lot going on right now and don't think my brain can switch off.

Yeah I work in distribution, I do a regular evening/night shift with a fixed finish time though rather than alternating days and nights, but the start time can vary depending on how busy we are - which isn't great for sleeping around.

9-5 doesn't work for me personally either though - my natural pattern is 3am to 11am if left to my own devices.
 
Last edited:
Yeah I work in distribution, I do a regular evening/night shift with a fixed finish time though rather than alternating days and nights, but the start time can vary depending on how busy we are - which isn't great for sleeping around.

9-5 doesn't work for me personally either though - my natural pattern is 3am to 11am if left to my own devices.
A set shift isn't too bad then, I used to do 7-3 / 3-11 and every other weekend I was a total zombie.

However, I got confirmation of redundancy yesterday after 16 years so will likely take the opportunity to reskill - just no idea what to go into.
 
However, I got confirmation of redundancy yesterday after 16 years so will likely take the opportunity to reskill - just no idea what to go into.

Hopefully something better comes along.

I dunno about redundancy but there is a certain amount of uncertainty where I work to the future with potential restructuring and lots of companies going to the wall which indirectly affects us, yet in the short term we are the busiest we've ever been which is kind of crazy.
 
A set shift isn't too bad then, I used to do 7-3 / 3-11 and every other weekend I was a total zombie.

However, I got confirmation of redundancy yesterday after 16 years so will likely take the opportunity to reskill - just no idea what to go into.

Sometimes an enforced employment change can be good, I've just been made redundant again so using my lieu pay to chill and think things over, also visited my parents in Yorkshire (my dads had bad heath news)
The last redundancy i ended up walking the Camino, something i go on about now and again.
Think i am sleeping too much though, 11 hours last night and i tend to use sleep as an escape (as well as red wine) so need to keep an eye on it
edit/ guess i walked 3 hours yesterday up hills mostly but 11 hours seems high
 
Last edited:
Trying to buy on fleabay a dvd or rather blu-ray got one major seller (musicmagpie) fail to honour their deal (didn't send item had to escalate sent email spiel about so sorry blah blah item not up to our standards/out of stock blah blah). They've got plenty of listings for exactly the same item - at much higher prices. Probably an old listing and didn't want to sell at that (low) price funnily enough they ended the listing immediately after I purchased and they still had more to sell. Go figure. Ordered again from another seller at a low price yet again another no show - still got to wait a couple more days before can raise a dispute. Due to xmas coming up and it being an xmas disc it seems everyones upping their prices. Funnily enough another same item on watch just got an automated offer from seller for a wait for it - £2 off a very expensive deal the buy it now listing ends in a day and the sellers getting nervous its not going to sell for its overinflated price I imagine.

All these bloody shenanigans and all I want is a reasonable deal on a darn disc that actually arrives before xmas. Got two more private listings on watch theres already interest from presumably business buyers who have put in derisory but placeholder bids. Wonder how much of a scramble there will be come the end of auction to grab the item at a not ridiculous price from overenthusiastic xmas buyers. Why bother you say? Well the discs no longer on sale they're all used items and I'm not paying ludicrous prices for already opened and possibly abused discs just because its xmas. Come new year and the market will be flooded with the darn things at 99p offers but its too late for presents by then.
 
Grrr, i hate software which doesn't make sense. I'm trying to get a formula to work to look at 12 months rolling revenue.

The syntax lets you choose the period, but i can't seem to get it to work for multiple ranges.

If i base it monthly, then i can get the formula to say =sum(This.period to This period-12), if i run for September 23 it correctly gives me 12 months work of data, however if i run it for the quarter of Q3 23, it gives me 12 quarters worth of data.

There just doesn't seem to be a way to have it dynamic enough to work for different time periods and it's ******* me off! :mad:
 
Last edited:
If i base it monthly, then i can get the formula to say =sum(This.period to This period-12), if i run for September 23 it correctly gives me 12 months work of data, however if i run it for the quarter of Q3 23, it gives me 12 quarters worth of data.

That makes sense to me: you're not giving a unit to the -12 so it's going to have to base it on the type of date. What's the software?
 
That makes sense to me: you're not giving a unit to the -12 so it's going to have to base it on the type of date. What's the software?

It's Adaptive Planning

It does make sense as you say. The problem is even if i assign a unit like "ACCT.ProfServices_NetRevenue[time=this.qtr-3]+ACCT.ProfServices_NetRevenue[time=this.qtr-2]+ACCT.ProfServices_NetRevenue[time=this.qtr-1]+ACCT.ProfServices_NetRevenue" it just goes mental and starts duplicating values and takes a quarter value for every month within the last 12 months and ends up with 12 times the values.

I don't think it'd be too bad if the help resource was any good
 
Last edited:
Status
Not open for further replies.
Back
Top Bottom