I had a similar use case a few years ago, so I created a small package that converts trained XGBClassifier and XGBRegressor models into Excel formulas by exporting their decision trees. https://github.com/KalinNonchev/xgbexcel