[This article was first published on T. Moudiki's Webpage - R, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here)Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.=TECHTO_RESERVING and =TECHTO_MLRESERVING in Excel are based on R and Python code from the Techtonique project’s claims triangle reserving functions.Here’s a unified way to use =TECHTO_RESERVING and =TECHTO_MLRESERVING directly and easily in Excel through xlwings Lite: If you haven’t done it yet, install xlwings Lite https://lite.xlwings.org/installation and click on its icon in the top right corner to open the editor Get a token from https://www.techtonique.net/token In the xlwings Lite editor, click on the dropdown menu > Environment variables Name the environment variable TECHTONIQUE_TOKEN, provide its token value, and push “Save” In the main xlwings Lite code editor (main.py), paste: from techtonique_apis import TECHTO_RESERVINGfrom techtonique_apis import TECHTO_MLRESERVING In xlwings Lite’s requirements.txt, paste:xlwings==0.33.14 # requiredpython-dotenv==1.1.0 # requiredpyodide-http # requiredblack # requiredtechtonique_apis Click Restart (or click “Restart” in the dropdown menu) Now you can close the xlwings Lite task pane, and Type =TECHTO_RESERVING and =TECHTO_MLRESERVING in a cell and select an input range (link to examples https://github.com/Techtonique/techtonique-apis/blob/main/examples/excel_formulas.xlsx). as long as the token is valid, it will work. It’s valid for 1 hour. Help for each function is here: https://docs.techtonique.net/techtonique_api_py/techtonique_apis.html. Or use Excel help for the function If you suddenly get VALUE error every time, check if the token is still valid (https://www.techtonique.net/token). It’s valid for 1 hour To leave a comment for the author, please follow the link and comment on their blog: T. Moudiki's Webpage - R.R-bloggers.com offers daily e-mail updates about R news and tutorials about learning R and many other topics. Click here if you're looking to post or find an R/data-science job.Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.Continue reading: Calling =TECHTO_RESERVING and =TECHTO_MLRESERVING for claims triangle reserving in Excel is just a matter of copying and pasting