4 Replies Latest reply: Oct 5, 2015 7:45 PM by DataExploiter _ RSS

    Model troubles

    Tyler Richardson

      Hello all,

       

      This is my first post, but I could really use some help sorting out a monarch model.  I have a document that lists maintenance discrepancies and corresponding corrective actions (CA).  The problem is that the discrepancies and correction actions are in the same column and sometimes a discrepancies does not yet have a corrective action.  As a result, the way I have the model set up now, it's automatically pulling the next available corrective action and applying it to the previous discrepancy that does not in fact have a corrective action yet.  Hopefully that makes sense, here is a sample of what the data looks like:

       

      A5059 15274 932    02        73F             2 152740195                [OAS] CMC 340AA5 TFACU 1 H/W FAIL 

      A5059 15274 932    02        73D             2 152740196                041-2 [OAS] RS2 RRT IS INTERMITTENT UNABLE TO TF. 

                                                  73DCF                               001 001 RELOADED TFACUS OPS CHECK GOOD                                   

      A5059 15274 932    02        73F             2 152740197                [OAS] CMC 343062 RDT 2 ALTM ANLG FAIL

       

      So the first line and the last line do not have corrective actions. Whereas the second lines discrepancy is: 041-2 [OAS] RS2 RRT IS INTERMITTENT UNABLE TO TF with a corrective action of: RELOADED TFACUS OPS CHECK GOOD

       

      As a result this is what I'm getting when throwing them in to table view.  The first line below should not have a CA but it's pulling it from the next available CA which is RELOADED TFACUS....

       

      A5059 932  15274 73F 2 152740195 [OAS] CMC 340AA5 TFACU 1 H/W FAIL                                     RELOADED TFACUS OPS CHECK GOOD

      A5059 932  15274 73D 2 152740196 041-2 [OAS] RS2 RRT IS INTERMITTENT UNABLE TO TF.      RELOADED TFACUS OPS CHECK GOOD

       

      Any help would be greatly appreciated.

       

      Thanks,

       

      Tyler