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...