Download site of Excel macro for simulation of coloration of mountanous
small lake, e.g., Ao-ike Pond, Aomori Prefecture, Japan
This version can run in 64/32 bit Excel.
The VBA source code is open to the public and VC++ code can be seen as
the pdf file.
Usage
1. Download zip file containing macro from the below link.
2. Unzip the zip file to obtain the Excel macro file.
3. Before open the Excel file, security check should be checked in "Property"
of the file, by Windows Explorer.
4. Open the Excel file, activate the "Content", and then carry
out the macro "Test_Refl_ES". Detailed usage is explained in
worksheets belonging to the Excel file. Explanatioons of 4 macros are given
in readme. To do fast calculations, user is requested to run a macro which
designates a directory containing an executable file. You can simulate
the blue coloration of Ao-ike Pond under the conditon of direct solar radiation
without any shileding above the pond, by assuming 3 mechanisms, including
irregular reflection at the pond bottom, molecular scattering by water,
and Mie scattering by suspended solids.