Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
PerlMonks  

Re^2: [OT] Finding similar program code

by afoken (Chancellor)
on Aug 27, 2021 at 11:51 UTC ( [id://11136129]=note: print w/replies, xml ) Need Help??


in reply to Re: [OT] Finding similar program code
in thread [OT] Finding similar program code

I can tell from your posts here that you are experienced enough to know this, so for the benefit of other readers I'll just mention that sometimes the smartest approach is to burn the entire edifice to the ground, let its ashes be dispersed by the four winds and start afresh.

That is exactly our intention (no refactoring in VBA), but the mathematics hidden in the Excel files has to be reproduced exactly.

Some background (as much as I can tell without risking a lot of trouble): Measurement results from several days of running a device on a test rig under varying conditions are written to CSV files, then read into the first Excel file, processed, saved, passed along to next N Excel files, and finally results in a set of calibration parameters that will be written back to the device. The various Excel files could generates a lot of printouts that are already disabled in the code, because nobody cares. But whatever replacement we will build, it must generate exactly the same calibration parameters given the same measurement results. It must be bug-compatible with whatever happens in the Excel files.

And, you may have guessed it: The entire mess is strictly confidential. I can't show the VBA code, I can't explain more details.

Alexander

--
Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)

Replies are listed 'Best First'.
Re^3: [OT] Finding similar program code
by BillKSmith (Monsignor) on Aug 27, 2021 at 18:26 UTC
    If your definition of "exactly the same calibration parameters" does not allow for differences due to the quirks of optimization and floating-point arithmetic, your project is probably doomed. Now is the time to start work on a validation procedure. How else might you convince your employer that the job is done?
    Bill
Re^3: [OT] Finding similar program code
by karlgoethebier (Abbot) on Aug 30, 2021 at 09:28 UTC
    «…The entire mess is strictly confidential…»

    Any thread deserves a song.

    «The Crux of the Biscuit is the Apostrophe»

      Any thread deserves a song. [Ray Charles - Mess Around (Live)]

      He! I know that guy! That's exactly how it looked when he wrote that VBA code. I somehow must have missed the mic and the camera, but I'm pretty sure that shows how he wrote it.

      *SCNR*

      Alexander

      --
      Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)
        "...I know that guy!..."

        I guess if Ray would have been a programmer he would have chosen Perl as his favorite language and not VBA. As he didn't jump to the conclusion to make Marschmusik his favorite thing. Best regards, Karl

        Update: Difficult to explain/translate: "Er entschied sich nicht..." i meant...

        «The Crux of the Biscuit is the Apostrophe»

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://11136129]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others browsing the Monastery: (8)
As of 2024-03-28 23:59 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found