Brief introduction

This file includes an Excel Macro code for executing a lake evaporation model to simulate surface energy balance and water temperature, which was developed and published by Nakajima, Adachi, and Yamanaka (2026); see "Citation" section below for full infomation of the literature.

The model is executed with shortcut keys "Ctrl + k" on the "Comp" sheet. Results will be given in the same sheet.

Input data (indicated by green cells) should be given by users.

License Agreement

This code is licensed under a Creative Commons Attribution 4.0 International License (CC-BY 4.0). To view a copy of this license, please visit http://creativecommons.org/licenses/by/4.0/. By downloading and using the code the user agrees to the terms and conditions of this license. Notwithstanding this free license, we ask users to refrain from redistributing the code in whole in its original format on other websites without the explicit written permission from the authors.

Sharing policy

Citation to the paper is adequate if you simply use this code. If you asked help for additional handling/editing of the code, or your research outcome highly depends on the product, the developer would request co-authorship.

Citation

Nakajima, K., I. Adachi, and T. Yamanaka (2026): Refining isotopic estimates of the evaporation-to-inflow ratio: The role of lake-atmosphere interactions. Journal of Hydrology, 672, 135361, doi:10.1016/j.jhydrol.2026.135361.