[% META title = 'BCR ABL data' %] [% # PROCESS dumper.tt dump = data %]

BCR ABL ratio data summary [% IF data.size; '[' _ data.size _ ']'; END %]

[% IF data.size %]
[% FOREACH entry IN data.keys.sort; # PROCESS dumper.tt dump = data.item(entry).copy_number; patient = data.item(entry).request_data.patient_case.patient; ABL = data.item(entry).copy_number.ABL; BCR_ABL = data.item(entry).copy_number.${'BCR ABL'}; # reset defaults for loop: class = 'normal'; status = 'normal'; ratio = 0; %] [% IF patient.last_name != data.item(entry).sample_name; status = 'error'; ELSIF data.item(entry).error; status = 'warning'; END; %] [% class = BCR_ABL AND BCR_ABL <= 10 ? 'red' : 'normal' %] [% class = ABL < 10000 ? 'blue' : ABL >= 10000 AND ABL < 20000 ? 'warning' : 'normal' %] [% END %]
LabNo Name BCR ABL ABL Result
[% loop.count %] [% entry %] [% data.item(entry).sample_name | upper %] [% IF status == 'error' %] [[% patient.last_name | upper %]] [% END %] [% BCR_ABL %] [% ABL %] [% messages = c.messages('file_upload').bcr_abl; IF ABL < 10000; messages.poor_quality.summary; ELSIF BCR_ABL; # ie not zero ratio = ( BCR_ABL / ABL ) * 100 | format('%.3f'); ratio _ '%'; ELSE; # no bcr abl expression = 1 / ABL | format('%.6f'); '<' _ expression | html; END; %] [% result = []; result.push(entry); # labno for template summary result.push(data.item(entry).request_data.id); result.push(ABL); result.push(BCR_ABL); result.push(ratio); %] [% previous_result = data.item(entry).existing_result.results_summary; IF previous_result; %] WARNING: has previous result [% END %]
[% site.html.submit %]
[% ELSE %]

Error: unable to extract any data from data file(s). Check:

  1. data file is an xls file, or a zip file containing at least 1 xls file
  2. data file contains ABL & BCR ABL data
  3. the 'Experiment File Name' field contains the string 'Q922'
  4. the 'Sample Name' field contains the LabNo & Name data

[% site.html.back_button %]

[% END %]