Using lambda file to create VBA macro

[Greg W]

Hi,

I'm creating a model regarding distribution of an invasive species.  Since not everyone who may be using my model will have access to or understand R or Maxent, I'm using the the lambda file to create an Excel VB macro that will allow the user to put in the data and see if the lake is potentially a suitable habitat or not.

I've got the macro coded, but when checking the value returned against a Maxent background prediction, its off by a quite a bit, so I went back in and coded a spreadsheet for just one sample.  I'm attaching an Excel file that shows how I'm doing the calculations, along with the background predictions.

I'm obviously doing something wrong, but I have no idea what it is.

Any ideas?

Thanks,

Greg W.