I am conducting an experiment where i need to output a variable amount of power from data contained within an excel spreadsheet. I need to replicate at a scaled down level the amount of power produced by a solar panel based on historical solar radiance data. I have the table calculated and know the amount of power per hour produced by the panel. I want to use the data to output a variable current proportional to the data. Any suggestions?