Substitute different equation parameters (e.g. slope) when batch processing raster calculator?

JacobNederend

This is a cross-post from the GIS StackExchange because it gained no traction there.

I have 15 multiband rasters for a total of 45 single-band images (5 dates x 3 sensors x 3 bands per sensor for which I need to apply a unique calibration equation. All the equations follow the format Y=A*exp(B*X), and I have a spreadsheet with all the corresponding A & B parameters for each.

Is there a feasible way for me to apply these functions iteratively using ModelBuilder to speed up the process? I am also willing to learn some ArcPy to make it work. Essentially, how would I specify the A * B variables in the calculator, and then tell it to search the spreadsheet to make the right substitutions? I couldn't turn up any forum or support site posts about this.

My current plan is:

1. Rename all the rasters to something logical like: "sensor_date.tif"
2. Split into temporary single-bands using "Make Raster Tool"
3. Feed output into raster calculator and output calibrated singlebands as .tif
4. Feed new singlebands into raster calculators to find several different indices (NDVI, NDRE, SAVI, etc.)

curtvprice

You could use map algebra to linearly scale your output from 0 to 1 (though 0 to 255 is often used).

ras1 = (ras - ras.minimum) / (ras.maximum - ras.minimum) 

However you may get better performance using Rescale by Function—Help | ArcGIS Desktop 

ras1 = RescaleByFunction(TfLinear(), from_scale=0.0, to_scale=1.0)