-
Posts
5,084 -
Joined
-
Last visited
Content Type
Forums
News
20th
EduGeek EDIT Conference
Blogs
Everything posted by Koldov
-
And is that (GPO for Edge to stop Extensions from being installed/used) a Computer or User GPO?
-
Coronavirus: General discussion (see opening post for rules)
Koldov replied to Dos_Box's topic in General Chat
But actually legal! I remember the case of someone spitting at a Railway worker and saying he had Covid. Turns out that there was no proof of the spitting (?) or that the spitter had Covid. But in theory does anyone ever get prosecuted for knowingly spreading infectious diseases? Also, how deadly or infectious does it have to be (and to whom) before it will be deemed an offence? I mean I know posting Anthrax to someone is frowned upon... but there are cases of transmitting HIV being a criminal offence. The thing is it might be tough to draw parallels, or at least the fact that HIV requires bodily fluid transmission (like Ebola/Lassa) and Covid mainly from just breathing... so in actual fact more transmissible, but possibly less fatal (6m estimated for Covid versus over 30 million - although now HIV has a proven medical treatment regime - once you aware you are infected) as Covid usually has a more marked effect on those in particular demographics. -
Glad you've got it sorted, or at least you're getting there!
-
You could look at stopping it automatically formatting that workbook, I'm not sure how the data was entered into it, but it might work in future** https://support.microsoft.com/en-us/office/undo-automatic-formatting-in-excel-54eba206-110c-445a-89f1-c4eb67a36bd4 **Disclaimer: I haven't tried this so YMMV...
-
Yes, the thing is, it isn't really about how the 'substitute function' interprets colons. It is more to do with how Excel helpfully interprets the data that is entered into it. Once Excel has decided that you have entered a time, it changes the cell formatting to accommodate that and make it easier for you... Obviously the unhelpful part is then if you want to manipulate that data using a function designed for changing 'text'. EDIT: Beaten to it... but this is basically the issue.
-
Yes, that is to be expected because as @asteer says Excel stores time as a decimal. You can prove this by typing in the decimal number (0.630555556) in a blank cell and changing the format of the cell to 'Time', it will change to 15:08. Also you can verify this by right-clicking and using the format dialogue to show you what will be returned in whatever format you choose in the drop down box. Therefore the cell contents will always be either the decimal number or the time (or something else), depending of the format of the cell. But you can change it to text and output the required format using the formula provided.
-
Yes, what he said.... Just to note, the forum formatting messed up the formula and put a blank space in the 2nd TEXT command: =CONCATENATE(LEFT(TEXT(C2,"hh:mm"),2),".",RIGHT(TEXT(C2,"hh:mm"),2)) You can drag this down, just don't forget to copy and paste as values afterwards.
-
Individually, you could convert it to text into cell D2: =TEXT(C2,"hh:mm") Then have your substitute in E2: =SUBSTITUTE(D2,":",".",1) I'm sure someone will come along soon with something more eloquent and joined together in one sum to rule them all...
-
Sorry I'm not going to be a lot of help with the actual answer to your issue, but I think that your problem will come from the format of the cells. Excel might have automatically formatted the original cell as 'time', so there isn't really 'text' or a 'number' as such to replace.
-
I'm a little confused... Do you mean a teacher bought a license for an app worth £200 and is now giving it to the school? Or did they purchase it on a personal account with school money?
-
I've never really noticed 'Shorts' before on Youtube. Is this what you mean? We use restricted mode and 'approve' buttons for normal Youtube videos. But, these don't appear and it doesn't seem we have any control over #shorts... I can't seem to find much information about them though.
-
This might help (plenty of other advice on the internet obviously) I haven't read through all of it, but it is from a fencing company (who should know their stuff, but also might just want you to buy a fence from them)... https://knight-fencing.co.uk/wp-content/uploads/Fencing-and-boundary-guide.pdf and this: https://www.lawsons.co.uk/blog/fencing/fencing-and-the-law-know-your-rights-before-choosing-new-fencing Just bear in mind that moving the fence more onto your property caused the gap she has had to fill, also that her original fence would have attached to yours somehow... So even a new small panel will. I know a door is unsightly, but she may not have had the money to have anything done professionally...? EDIT: Just to say if it is an interior door it will deteriorate quite quickly (most are just hollow MDF board or similar) if you cut it down and that makes it open to the elements it will fall apart even quicker...
-
Wow! I do not envy you... Neighbourly disputes can quickly escalate unfortunately and there may be few things you should have done differently in hindsight. I'm sure you know what to look for on your deeds, but this thread has some details: http://www.edugeek.net/forums/general-chat/226447-storm-dudley-eunice-franklin-how-you-doing-3.html#post1942014 There is also this from one of the links in that thread: "There are various notions that the way a wall or fence is constructed indicates ownership, for example that the posts and arris rails of a fence are on the owner’s side. There is, however, no legal foundation for such beliefs" I (hopefully not to jinx it) have OK neighbours at the moment, I think I would have a really hard time coping with ones that aren't... As for moving the fence towards your house, it probably wasn't a good idea as it seems this is what left the gap she has had to block? This will also alter your boundary and in future you may lose the rights to it (I know it's only 6 inches)... If it was your responsibility to maintain, you probably should have just had it repaired/replace in-situ. If it wasn't your responsibility, I might have been tempted to build a new fence 6 inches back from the old one and leave the old one as it was. Tough decision though as you obviously wanted it fixed before you had the deeds, but I might have done something a little more temporary until I knew for certain. It might also have been worth asking neighbours either side of you if they knew who is responsible for their rear fence? As for attaching things to it, I know it may seem annoying, but are there ways you can mitigate it? Say, planting a tree in that corner or put some trellis up... As it is a boundary fence between gardens I don't know if there is any law stating what you can or cannot attach to it from the 'other' non-owner side. I mean would it be bad if she attached some garden ornaments or lights on her side (I know it is a big white gloss door)?
-
Holy thread necro Batman! But how strange it appears to be the exact same thing mentioned here (earlier post in this thread): http://www.edugeek.net/forums/general-chat/126632-name-connector-part-3-a-2.html#post1082829 Don't think @laserblazer has been active for quite some time though... so hopefully someone else knows how this this ancient monolith connects.
-
I'm surprised they even know what that is for... We have the exact opposite problem! I seem to be getting more issues getting called to classroom or with the teacher coming to the office with their laptop saying they can't log on or get to a shared drive, print etc. When I investigate the wi-fi is off or just hasn't connected for some reason... and they haven't noticed.
-
Is this just user setting or computer, or both? Can you try creating a fresh test OU, then a GPO and move a client into it (or a user)?
-
This... as always (and Group Policy section), also what happens when you GPUDATE /FORCE on one of the affected machines? Does RSOP/GPRESULT show anything?
-
Looking at that, it does appear to be the same as the HP250G6 then... Must be how HP makes laptops these days...? I miss the old days of 1 or 2 screws and a clip off ribbon cable to pop the keyboard out and replace! Slightly cheaper at HP Parts Store - but they have no stock, so not much help. https://parts.hp.com/hppartsIGSO/Search_Results.aspx?mscssid=9652051D3ABA4B5BA7C0FD8474401DC7&SearchIn=PartNumber&SearchPN=L50000-031
-
Coronavirus: General discussion (see opening post for rules)
Koldov replied to Dos_Box's topic in General Chat
Really?! That's interesting, how many days have you tested positive for? We were given the following advice from the LEA: "If you get COVID symptoms then you should, take a PCR test as soon as possible and stay at home until you get the result. If the test comes back positive then you should remain at home for 5 days from the day you first had the symptoms. If you test negative then you should return to work immediately." I'll have to go and ask the Head for clarification... what happens if you're still testing positive on day 6? -
Not this particular model but at least it seems from the above post the keyboard is replaceable. We have a fleet of HP250G6 and for a recent repair (hinges snapped off both lid and base) it appears that the upper section of the base where the keyboard is has to be replaced. But I noticed when I ordered the part, that it comes with keyboard and mousepad... Strange I thought, but on closer inspection the keyboard is mounted on the top part with plastic lugs (melted to hold it on), the mousepad looks like a right pain to remove too. So basically if those parts fail you would have to purchase the whole top part of the base which (it appears is similar to yours), also holds all the motherboard and other components...
-
Coronavirus: General discussion (see opening post for rules)
Koldov replied to Dos_Box's topic in General Chat
But let's not cloud everything with facts and figures (or damn statistics)... Because it is really a matter of sociology (social ethics and social dynamics) and altruism. There are things we actually know. It's a virus, it spreads through the usual means (but its spread is predominantly airborne). The spread is mitigated by ventilation, mask wearing, hand-washing, distance (this is obviously common sense). By that logic, the less close contact (in say a small classroom with no mask wearing and poor ventilation) infected person A has with person B, the less likely person B is to contract the virus (again common sense). What is less crystal clear to me is the effectiveness of the vaccine to reduce not just hospitalisation/death, but viral load (as we already see reinfection of previously infected/vaccinated individuals, we cannot say anti-bodies or a vaccine completely stops one becoming infected). However, if the viral load produced from the infection and therefore risk of spread is reduced by being vaccinated, then that should indicate it as the correct thing to do regardless of whether that be a child or an adult. In the early days of the discussion about children being vaccinated, it was widely noted that almost no children suffer very badly from Covid infection. This was given as the reason for not vaccinating, but personal health is only part of the reason for vaccinating against Covid, the other being to prevent onward transmission (interestingly vaccinations such as the MMR is seen as a personal vaccine to help prevent your child getting infected/ill, but it also mitigates spread, as a possibly unwitting effect which is not generally given as a reason to have your child immunised against those diseases). We've all seen the infographic and remember the R number, but now in the case of our particular place of work the initial spreader is more than likely a child (or multiple children) as a vast number of adults (not only being the minority 1:30) will have been vaccinated... But as stated above, previous infection or being vaccinated doesn't protect the adult 100%, so there are 30 potential vectors of infection for them. Let alone the fact that they are all still spreading it between themselves and then back at home to siblings/parents/carers/grand-parents... I'm not aware of their children's age, but notably one or two posters here indicate that although avoiding infection themselves thus far, infection was introduced by means of their children. Now, with vaccination apparently playing a large part in lower hospitalisation/death and in any case most of those (if fit and healthy) in the infographic will be OK (and if they were all unvaccinated children 99.9% of them would be anyway), except from possibly one of those at the end of the chain. But imagine the initial infection starter being a child, the next row siblings, the next row parents and the last being immuno-suppressed/unvaccinated for medical reasons or just elderly/susceptible... Having said that, I'm aware of course there are as always mitigating factors (medically speaking) that preclude certain individuals from being able to have the vaccine (as noted in a previous post). I hate to be the one that brings in the old chestnut of 'you could be hit by a bus tomorrow', but risk (vaccine) aversion is simply a personalised (possibly uneducated) risk assessment and fear of individual consequence (which appears to have been proven to be very low). How many of those unwilling to vaccinate their children let them walk/cycle to school, go out to play unsupervised, or do various other things that could 'possibly' have life threatening/altering outcomes? It may be completely unrealistic to expect total altruism as the reason to get vaccinated and I'm sure many people as I have, got vaccinated for mostly personal reasons (with a decent helping of vulnerable Mother-In-Law). People are generally good (and a few are truly selfless), but faced with one's personal issues versus someone else's most people will eventually choose themselves (especially if they feel their life or especially that of their own kin is somehow in peril)... This obviously applies to those both for and against. Against: Nobody in my family is vulnerable and we are all healthy, I don't see any point in putting us at risk from vaccine side-effects! For: I have a vulnerable family member, everybody should get vaccinated to help protect them. Side-effects are less likely than death from Covid! I doubt many arguments will change either the 'for' or the 'against' person's mind...
