I’m developing a “simple” calculator, for a roofing product company, that will compute our client’s project requirements, based on three different variables: roof pitch, panel length and product type. I have everything under control except the roof pitch and run, but let me try to clarify.
There are 10 different roof pitches and unlimited run lengths, the number of product required increases with pitch and run increases. See picture below.
Without defining every product increase manually (as there are many products I will have to use this with,) is there a way to incrementally increase the product per roof pitch and run, or does anyone have a better solution?
Thanks for your help and contributions on this.
