asteer

Has the person had a formal assessment. If so I would have expected them to have had a written report giving them tips/guidance on strategies or tools to implement. I had my assessment 17 years ago, but I got a report that can be used, if i need to, to help support my specific needs. Though in all fareness I would have thought any occupational help/HR provider would be able to do this kind of thing

Thanks for that, just tried that and it does work as you have mentioned. This might help to make the pronoun visable when viewing the student record. I still think reprots will be a nightmare,, but we will just have to do them on a case by case basis

If its got wooden floorboards its likely then got spacers underneather and airbricks on the outside of the house for ventilation. The fact you said that the plaster when you took off the boards was powder, makes me think it was affected by damp. The bricks do look a darker colour than you would expect for a 'dry' wall. https://www.ecologicalbuildingsystems.com/post/best-practice-approach-insulating-suspended-timber-floors I would go with wooden spacers and not filling in the gap, as there must have been a reason why the plaster had turned to powder

Is this a ground floor? and what is the floor under the wood laminate? It may be best to leave the gap and put any new skirting board over it. You do not want to plaster all the way to the floor as this could bridge your damp proof (if its a ground floor) and cause issues further down the line (moisture in a floor would "jump" the bridged gap and cause damp issues on the wall). We had a damp issue in our front room (caused by debris behind a fireplace and bridging plaster) that due to covid and material shortages has taken over 3 years to get sorted.

If you/partner/someone you know works for a blue light service (plus some other random services), you can get a memebership for the company shop. You can also go with a member and be their +1. Though whenever Ive gone ive just bought kilo bags of sweets, which probably isnt good. https://www.companyshopgroup.co.uk/profile/freemembership

We have been asked if we can record the pronouns for our LGBTQ+ students in our SIMS system. I know we can create a UDF filed to allow thsi to be recorded, but on the studetn records its right at the bottom, and im not sure of the viability of adding it to reports/registers and marksheets (mainly having to go through every single one and adding it) Does anyone else record pronouns of students in their SIMS systems and also display it on registers, reports and marksheets?

Ive been making "packlunch" for work for several years now, Im also on slimming world so the meals are also healthy as well as being cost effective as we make 10 lunchs a week, bacth cooking on a Sunday. Some stuff Ive made is Tuna Pasta - Tuna, Sweetcorn, Leeks, Pasta with Greek Fat free yogurt and Quark as the "sauce" with Aromat for flavouring Veggie Pasta - Pasta, Peppers, Green Beans, Aubergine, Courgette, Passata, herbs and spices Orzo Pork - Orzo Pasta , Pork loin steak (fat removed), Cherry tomatoes, cucumber, beetroot with a bit of whitewine vinegar and mint for flavour Tikka Turkey and Rice - Turkey marinated in (Curry Powder, Ginger, Garlic, Lemon Juice), wild rice, cherry tomatoes, cucumber with mint and lemon juice to loosen it up (also meant to be served with a mint tzatziki, but dont do that for work) The Tikka Turkey and Rice is this weeks meals, though the prices of Turkey has gone up quite a bit as it used to be a "cheaper" meat. Most of the meat elements could be replaced with a meat substitute with no detrement really

Not a drone person myself, but the drone in image 4 and 5 looks like a DJI Flame Wheel F550 - a basic kit seems to retail about £230, depending on the extras it looks like they sell (new) for a bit more - https://www.buildyourowndrone.co.uk/dji-f550-flame-wheel-e305-artf-v2[h=1][/h]

https://www.dudley.gov.uk/news/dark-fibre-sees-the-light-of-day-in-dudley/ Dudley council are doing it for their own network. They are renting the line from Virgin, but it seems in your case that there will be a dedicated fibre line between yourself and the LA. The LA would decide the speeds that you get but in theory the max could be whatever a fibre line can take (in theory 2/3 the speed of light). Leasing for 25 years locks you in for a long time. I suppose in that time everyone else could improve their speeds, so its really if you want to take the risk

Dark fibre is pretty much a point to point dedicated fibre line. Its not "managed" by anyone so you have to have your own company/equipment to "light" the fibre, no one else would use it other than yourself

Finally, able to find proof that my house wasn’t bombed flat in WW2 from this (Rumour on the street is that a block of houses, including mine were bomb damaged (they were bombed and people next door died) and had to be demolished), an aerial picture from 1950 shows the house intact (though houses at the end of the street are gone. So dont think they will have re built the house exactly as it was in 5 years

It looks like I will need to go into one of the Secondary schools in our MAT and help support them with their SIMS system. This is due to staff loss/ability/knowledge of current staff. Im trying to come up with a bulletpoint list of things to check as a starter and Im just looking for any suggestions on the top things to check.

Cheers for that, I've been through the Scholarpack attendance reports and while they work fine internally for a school, I cannot find anything that easily gives me a flat file format for any period over 30 days that will allow me to extract the information for further analysis. Scholarpack do offer a MAT version of the system, but it will have a cost so I want to see what I can engineer first (I'm a big fan of the KISS principle (Keep it Simple, Stupid)) Back to the origional post @Leia, what is the format of the Bromcom spreadsheets that you need to use. Ive been sucessfull* in taking a report from Scholarpack and then converting it into a format that is semi-reasonable for further data translation The extract comes out of Scholarpack like the below. [TABLE=class: grid, width: 500] [TR] [TD]First Name[/TD] [TD]Surname[/TD] [TD]Year[/TD] [TD]01/02/2022[/TD] [TD]02/02/2022[/TD] [TD]03/02/2022[/TD] [/TR] [TR] [TD]Test[/TD] [TD]Student[/TD] [TD]3[/TD] [TD]/\[/TD] [TD]/\[/TD] [TD]/\[/TD] [/TR] [TR] [TD]Bob[/TD] [TD]Smith[/TD] [TD]3[/TD] [TD]/\[/TD] [TD]L\[/TD] [TD]M\[/TD] [/TR] [/TABLE] I then use an ArrayFormula with Flatten and Split functions in Google Sheets to format the above data as the below [TABLE=class: grid, width: 500] [TR] [TD]Name[/TD] [TD]Date[/TD] [TD]Period[/TD] [TD]Mark[/TD] [/TR] [TR] [TD]Test Student[/TD] [TD]01/02/2022[/TD] [TD]AM[/TD] [TD]/[/TD] [/TR] [TR] [TD]Test Student[/TD] [TD]01/02/2022[/TD] [TD]PM[/TD] [TD]\[/TD] [/TR] [TR] [TD]Test Student[/TD] [TD]02/02/2022[/TD] [TD]AM[/TD] [TD]/[/TD] [/TR] [TR] [TD]Test Student[/TD] [TD]02/02/2022[/TD] [TD]PM[/TD] [TD]\[/TD] [/TR] [TR] [TD]Test Student[/TD] [TD]03/02/2022[/TD] [TD]AM[/TD] [TD]/[/TD] [/TR] [TR] [TD]Test Student[/TD] [TD]03/02/2022[/TD] [TD]PM[/TD] [TD]\[/TD] [/TR] [TR] [TD]Bob Smith[/TD] [TD]01/02/2022[/TD] [TD]AM[/TD] [TD]/[/TD] [/TR] [TR] [TD]Bob Smith[/TD] [TD]01/02/2022[/TD] [TD]PM[/TD] [TD]\[/TD] [/TR] [TR] [TD]Bob Smith[/TD] [TD]02/02/2022[/TD] [TD]AM[/TD] [TD]L[/TD] [/TR] [TR] [TD]Bob Smith[/TD] [TD]02/02/2022[/TD] [TD]PM[/TD] [TD]\[/TD] [/TR] [TR] [TD]Bob Smith[/TD] [TD]03/02/2022[/TD] [TD]AM[/TD] [TD]M[/TD] [/TR] [TR] [TD]Bob Smith[/TD] [TD]03/02/2022[/TD] [TD]PM[/TD] [TD]\[/TD] [/TR] [/TABLE] A couple of caveats on this: I can only find a report that runs for a 30 day period, so if you want a couple of years worth of data, you have to re-run this report for multiple 30 day periods in the bigger timescale You need to have a another extract of student information to allow you to create the concatenated student name (the actual data im using will use either the UPN or the primary id within Scholarpack to do the matching) The code has been bashed together by me from a couple of sources, with additional support from some "random" person on Stackoverflow so may have some unintended consequences. Ive desinged this in Google Sheets as I have plans further down the line to use the data, in could be done in Excel, but the code would need reverse enginerring If you need any help with this, let me know *I got about 99% of the way there and then someone of Stackoverflow helped me the rest of the way - https://stackoverflow.com/q/71323530/9606612

As an aside, the elements of number:number works for values that arent even valid times i.e. 56:15 will return a automatic value of 02/01/1900 08:15:00 The number value for a date/time is based on a sequential element from 01/01/1900 which has a number of 1, while 02/01/1900 has a number of 2. Today (02/03/2022) has a number of 44622, so is forty four thousand sixhundred and twenty two days after 01/01/1900, but there is an error with this if you try and calculate dates back. There is an known bug in the calculation that dates after 28th Feb 1900 are one day out, this is because the Microsoft date format was designed to be compatable with Lotus 1-2-3, and the Lotus 1-2-3 programmers through that 1900 was a leap year, which it wasent, so 29/02/1900 is number value of 60. So while today (02/03/2022) is shown in excel as 44622, it should actually be 44621 When you do a date calucation in excel, all it does is convert the dates to numbers and then calculates it that way and then formats the number as a date i.e. today plus 5 days is 44622+5 = 44627 formatted as a date

Its not the colon itsself that causes the issue, but how excel is interpreting the entire element that your wanting to use the substitute on. Using your substitute formula on test:test to get test.test would work perfectly fine. The issue is excel thinks that any element that is a two digit number, a colon, then a two digit number is a time. While we as humans can say it looks like a time, but it isnt a time, excel can only say it looks like a time, so it is a time.