Manual latest. another Re: Easter egg Re: WS Correction Factors

[lemoene]

Hi Louis

Using Correction factors written up in the manual now, works on our complex formulas and all

Manual starting to gain more weight, also first    Health user manual pages, incl, Patients, Doctors, Clinical Cases

Scanning the Gaob Bika 3 manual - to finally get Analysis Services configuration done, stumble upon this easter egg,

Unit

    For super-scripts, use ^ char
    For sub-scripts, use _ char

Bests
l

Much to do...

Recently done

 

Hi Louis

Given budget and, notably, time constraints, we are going to work around the correction factor WS gap using the generic 2D results import newly inherited from Bika Cannabis in Senaite 1.2.2.

I'll be testing it with configuring a spreadsheet for the Correction factor to be (automatically) repeated with the other interims on each row to get to a flat 2D table that can be imported using the instrument import machinery. It should auto upload the file too and reference it as attachment to all the Analyses it includes.

Not the neatest, but beats manual data capturing. Will write up the story. Bika Senaite Tips and Tricks 201.

The design excercise was fun and it simmers on. The blank correction use case is the most common, and on its own should not be crazily difficult, but keeping it re-usable. For Inkosi Bika LIMS 2, I withdrew with a head-ache and Anneline hard coded the whole lot...

More soon
l

All of our environmental analysis will have blank corrections. Meaning we will run the same analysis with RO water and use the results as a correction factor for the final values. In this example I am setting up TSS (Total Suspended Solids). The blank calculation is simple:

[BlankCorrection] = ([FinalStableWeight]-[InitialWeight])*[Volume]*1000

For the rest of the analysis it needs to be:

([FinalStableWeight]-[InitialWeight]+[BlankCorrection])*[Volume]*1000

This is one of the cases we'll address. The others, in animal feeds chemistry, % protein, % fat, etc, become quite complex, with further extractions after weighing and certain intermediate results taking on further meaning. Am still wading through it but hope to reduce them to 3 or so templates, maybe a hard-coded one or two thrown in.

If we manage it with [BlankCorrection] defaulting to 0 initially we can re-use the formula, going into the design;-)

A tremendously enjoyable puzzle. Some of the formulas at our client are proprietary but I will try to share as much as possible.

Hope to have a design up later this week, on the top level it sees to be a confluence of:

• WS Templates with correction factors depending on the results in certain WS positions
  
  Any of positions 1, 2, and 3 I found in my examples. With this in hand we can expand on the Apply WS wide functionality
  
  
• In some cases Correction Factors are calculated from more than one WS row of QC results
  
  
• Up to five weights have to be measured up to a point where intermediary results are displayed to Analysts for QC before going ahead. These can be any of
  
      Bag
      Bag & Vessel
      Sample (& Bag & Vessel)
      Reagent
      Sample before 1st procedure
      Sample after 1st procedure
      Sample before 2nd procedure
      Sample after 2nd procedure 
  
  They have their balances interfaced;-)
  
  Sequential procedures are often Drying followed by Acid acid or hydrolyses extractions
  
  
• In many cases intermediate QC results are calculated and shown to Analysts mid way, all fine, but this calculation could be completely independent from the final results calculation. Bika currently does not allow 2 independent calculations on the same interim fields (and WS rows).
  
  Some Correction factor calculations also require accessing multiple WS rows, e.g. averaging QC results in the CF calculation

It took me a while to reduce it to the above..., have a design fermenting.

More soon

Indeed!
l

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot

_______________________________________________
Bika-Users mailing list
Bika-...@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bika-users

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot

_______________________________________________
Bika-Users mailing list
Bika-...@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bika-users