Download site of Excel macro for simulation of coloration of mountanous
small lake, e.g., Ao-ike Pond, Aomori Prefecture, Japan
Now, only VBA version (including no DLL file) is available.
This version can run in 64/32 bit Excel.
The VBA source code is open to the public.
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. 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 three mechanism, including irregular
reflection at the pond bottom, density fluctuation scattering by water
(molecular scattering), and Mie scattering by supended solids.