idaholab / raven

RAVEN is a flexible and multi-purpose probabilistic risk analysis, validation and uncertainty quantification, parameter optimization, model reduction and data knowledge-discovering framework.
https://raven.inl.gov/
Apache License 2.0
216 stars 132 forks source link

[TASK] Add a version control for excel file and the regression testing for a excel file #2278

Open wenchichenginl opened 5 months ago

wenchichenginl commented 5 months ago

Issue Description

Is your feature request related to a problem? Please describe. There is a need to diff the excel file to have a better version control capabilities considering that the current RAVEN framework cannot diff the excel file directly. Also, after the user making some changes of the excel file, there should be a tool to perform the testing and make sure the formula or calculations is not messed up.

Describe the solution you'd like Two python codes should be generated to deal with this issue. The first code is to diff the excel files and the second code is to test the excel if the formula is messed up.

Describe alternatives you've considered N/A.


For Change Control Board: Issue Review

This review should occur before any development is performed as a response to this issue.


For Change Control Board: Issue Closure

This review should occur when the issue is imminently going to be closed.