devnul, you didn't tell us if the individual reports gave you any clues that you might be able to match to the dump from the same data set record.

Failing that, a combination of recursive brute force and success pruning (aka 'genetic') is the answer. I'm hoping you can assume that the data in the variables does have a constant format, so that once you find a solution that works for one set (within rounding deltas), it should work for every set. Where you'll have problems is if there are late payments with penalties and interest charges which are only stored in aggregate totals. That possibility would increase the scary factor immensely. :(

Best of luck; this looks like a case of Interesting TimesTM.

Don Wilde
"There's more than one level to any answer."

In reply to Re: Reverse engineering a formula... by samizdat
in thread Reverse engineering a formula... by devnul

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.