NELA risk score validation

What to check Check

Many users at once for a set time. Every answer is still checked against the spreadsheet, and speed is measured.

Two browsers open the same record with collaboration on: one makes a record from the first selected row, both edit it, and each promise of the room is checked - who is here, changes and the score reaching the other copy without a second request, saves in turn with nothing lost, and two drafts of one patient noticing each other. Needs COLLAB.enabled on the form.

Put load on

Every row is sent straight to the risk service and the score it returns is compared with the spreadsheet.

Every row is typed into the calculator, one field at a time, and the score the page shows is read back.

Fill it in using

A real browser fills the NELA risk section of the Crown Audit form for every row and reads the score it shows.

Spreadsheet File Excel (.xlsx, .xls), OpenDocument (.ods) or CSV. The reference sheet, a Crown Audit extract, or any table of the inputs with expected scores; columns this tool does not recognise can be mapped in a dialog.

sim_data_v4 2024 05 31 with data dictionary.xlsx, the sheet the model was signed off against. Download it to check a copy yourself.

Where Environment Risk API URL Calculator URL Crown Audit database

Forms to check

All four EmLap V13 EmLap V12 NoLap V3 NoLap V2

Another form Scores to check NoLap forms have no operation, so they are checked pre-op whichever is chosen. Each ticked form is checked in turn with the same rows; the results for every form stay in the run panel.

Sign in on Crown Audit's own page, shown here in a frame. The session stays on this server for twelve hours and is used for every run you start, headless or in the frame.

Or give the session directly

Paste the cookie header from a signed-in browser, or give an account without MFA. Used only for the run you start.

Cookie header

Username Password

The second person

Another account, so the room has two names. Left empty, the first person is signed in twice: every check still runs except the one that needs two names.

Cookie header

Username Password

How

Mode Concurrent users Browsers at once Seconds Rows all, a number, a-b, or a list like 5,725,1465-1470 Browsers Save each record (switching tabs saves a draft anyway; this finishes the save so the record number is in the report) Collaboration Require every score to be shown to one decimal place (0.0%, never 0% or 3%); unticked, a score shown otherwise is noted on its row but does not fail it Tolerance

Recordings The whole-run video tiles every browser side by side; a workbook with several sheets gets one video per sheet too. Large runs take a lot of disk. Recordings Your browser will ask to share this tab; the recording is made here and never leaves your machine unless you save it.

Nothing checked yet

Choose the spreadsheet, pick an environment and run the check. Every row is compared with the score the spreadsheet expects, and the whole run stays on this page: what was sent, what came back, and what the browser saw.

Or open a report a run has written The .json report from a run started outside this page (the command line, a scheduled run). Its verdict, the list of errors and every row open here as for a run of this page.

NELA risk score validation

Runs on this server

Nothing checked yet

Checking

Rows so far

The run did not produce any rows

The calculator, in this browser

Browsers

Excel workbook

PDF report

JSON

Recordings