SpreadsheetJockey

People in your school. When you run a report in Bromcom, there is (usually) a bright green "live data feed" button from which you can get a link that can be used to bring the report's data into Excel via Get and Transform (AKA Power Query) in the data tab ("From Web").

Can your people not just write/run a report and use a live data feed into Excel? I have the add-in installed but I never use it - in fact I have it disabled because it makes Excel take bloody ages to load.

Is it listed (and therefore ticked) in Excel on the developer tab under COM Add-ins?

I vaguely recall you can group data to only show the most recent entry, which might solve the problem you mention (with a bit of faffing around). However, Bromcom does need to update their feeds, especially the non-Vision odata feed which is hugely behind the Vision one in terms of added functionality and information. Nothing has been changed in the regular feed for at least a year - I assume because they are trying to sell Vision to everyone.

Could you make a custom unique key in power query out of the available data e.g. studentid&date&period (or whatever) in both your current data and the subcode report data and use that to link them up in the schema?

Stab in the dark - when you edit a permission role, and go to the module "reporting", you get a button appear next to the module name that says "Report Design Permission" - when you click on it you get a whole load of other checkboxes related to (I assume) what people are allowed to report out of the system. Wondering if perhaps yours are all unchecked?

You can use Reports > Student List > Registration Group List and pick a group (or multiple). Then when the list appears, on the right hand side dropdown menus choose Academic, and Timetable. Then you drag 'All periods' into your list to make an excel friendly timetable for the group. You can then save this and use it again whenever you need it. Choose 'General Student List' rather than 'Registration Group List' if you want an adhoc group (like Pupil Premium or SEND etc.) - it works the same way. We don't use SIMS any more, so this assumes it is still the same - but its SIMS so it probably is.

I think you need to enable "show file extensions" in order not to get that .zip.zip file name. You can do that via the "File Name Extensions" check box in the View menu of File Explorer. This should allow you to rename it properly with .zip and open it.

You can make a basic adhoc report using Reports > Adhoc > View Reports > New > Table Report > School > Roles From there you would add Role Name, Module Description, Permission Description, Access, New, Edit, Delete and Save, and then save and run the report and export it to csv (or whatever). I think this would get you all the info you're after, although you'd probably need to stick it in a spreadsheet and/or power query it, to get whatever relevant format you are wanting.

Can you create a column with a CONCAT formula (concatenating A & C), and then use your UNIQUE formula on that column?

Anecdotally we have found that users with significant speed issues have kept their browser open all day long, and closing the browser and reopening, then relogging into Bromcom seems to bring the speed back within normal ranges. We have also found that having two users on the same page (e.g. the same student record) causes things to hang sometimes. These may be specific to our school/set-up but figured I'd mention just in case it helps.

From recollection, you can search up UPN numbers on Key to Success (part of DfE Secure Access) and it will create a CTF for you to download (as well as the usual csv spreadsheets). That CTF can then be imported for just assessment data, which would update any students you have included in your search.

@Pink_Panda Right there with you friend.

If you're using Individual Reports, then I think generated pronouns are available in the right click menu under Student Details.

How about this? Dim FileLoop As Integer Dim SrcWkBkX As Object Set SrcWkBkX = CreateObject("Scripting.Dictionary") SrcWkBkX(1) = "1-11810-24-1015k-nm.xlsx" SrcWkBkX(2) = "etc." For FileLoop = 1 To 20 MsgBox SrcWkBkX(FileLoop) Next FileLoop

Hi, Here's one way I know of getting that information: SIMS: Tools > Cover > Statistics > Absence Select the relevant date range and reason for absence (and any other details) and press search Shift + Select all the staff members that appear in the list below Click the yellow folder to the right of the list You can then export that list of absences to Excel or print it Not sure if the subsequent list is exactly what you're after but it does do the job more or less I think.

I think the 2016 version might be KB3085538, or possibly KB4475554, which was published quite recently.

We recently solved a problem with individual reports refusing to run, by installing Windows Security Update KB3039734 which was missing for some reason - just in case you are having a similar issue.

Hi, Not sure which forum to post this in, but I've heard that some BTEC information has not been sent over to the DFE (e.g. First Awards) causing the early provisional performance table summaries out on restricted release today to be significantly incorrect in some cases. This seems to be true of our data, so just thought I'd mention it here for anyone with an SLT team religiously looking out for those progress 8 figures. Can anyone else confirm this has happened with your data?

Have you tried setting one of them as a desktop background or opening them in MSPaint? I think possibly you can use the alpha channel in photoshop to make something appear transparent that isn't.

Not exactly sure what you're after, but just an if statement in your mergefield e.g. {IF {mergefield} = "1" "X" ""} etc. might accomplish it? You'd need to CTRL+A & F9 (refresh) the page to see the results of an edited mergefield.

If it's only been in the last few weeks, perhaps your DM or equivalent may have been running bulk updates to student records etc. in relation to the school census?

Not sure if this helps, but our timetable has an NCC code created called "part time" which we then assign to the relevant staff members, for the days (or parts of days) that they aren't available. This stops them appearing as free to be used on the days that they aren't in. You can also reserve facilities available per day, per subject via the facilities timetable I believe, by clicking (or right clicking) the number just under the period name.

I've recently been mucking about with PowerBI and it's great fun. It's easy enough to pick up the basics with just some googlefu. It can pull together some useful visuals easily, but I feel like I'm going to be picking up bits of its related languages as I go along, when it comes to things like cumulative totals (I think people will be cobbling things together in the same manner that many of us accidentally acquired VBA skills). I do think its going to be increasingly popular in the near future (if not a complete excel replacement), as its a recognisably Microsoft Office-ish looking product that is palatable to schools. I've definitely begun thinking of it as a future essential employment skill for people in school data roles.

Just on the off chance, is this affected by selecting 'Prompt at runtime' in the filter condition(s) of your linked areas?