Hey guys formula works great, just throwing this out there any ideas on how to simply...I thought about maybe a UDF any thoughts?
<CODE>
=SUM(OFFSET('l-curve'!$B$41,SUM(INDIRECT(ADDRESS(6,4,,,"D-Sche")):INDIRECT(ADDRESS(6+F3,4,,,"D-Sche"))),0,-INDIRECT(ADDRESS(6+F3,4,,,"D-Sche")),1))+SUM(OFFSET('l-curve'!$E$41,SUM(INDIRECT(ADDRESS(6,7,,,"D-Sche")):INDIRECT(ADDRESS(6+F3,7,,,"D-Sche"))),0,-INDIRECT(ADDRESS(6+F3,7,,,"D-Sche")),1))+SUM(OFFSET('l-curve'!$H$41,SUM(INDIRECT(ADDRESS(6,10,,,"D-Sche")):INDIRECT(ADDRESS(6+F3,10,,,"D-Sche"))),0,-INDIRECT(ADDRESS(6+F3,10,,,"D-Sche")),1))+SUM(OFFSET('l-curve'!$K$41,SUM(INDIRECT(ADDRESS(6,13,,,"D-Sche")):INDIRECT(ADDRESS(6+F3,13,,,"D-Sche"))),0,-INDIRECT(ADDRESS(6+F3,13,,,"D-Sche")),1))+SUM(OFFSET('l-curve'!$N$41,SUM(INDIRECT(ADDRESS(6,16,,,"D-Sche")):INDIRECT(ADDRESS(6+F3,16,,,"D-Sche"))),0,-INDIRECT(ADDRESS(6+F3,16,,,"D-Sche")),1))+SUM(OFFSET('l-curve'!$Q$41,SUM(INDIRECT(ADDRESS(6,19,,,"D-Sche")):INDIRECT(ADDRESS(6+F3,19,,,"D-Sche"))),0,-INDIRECT(ADDRESS(6+F3,19,,,"D-Sche")),1))
</CODE>
This is basically 6 products on 6 seperate learning curves and I am summing the values based on its position in the learning curve according to deliveries. So if in a month I am on unit 10, and delivery 6, I only want the values for 10-16, not 1-6, if you don't know what a learning curve is basically its you get more efficient as you build more. Any thoughts on a simplier formula?
<CODE>
=SUM(OFFSET('l-curve'!$B$41,SUM(INDIRECT(ADDRESS(6,4,,,"D-Sche")):INDIRECT(ADDRESS(6+F3,4,,,"D-Sche"))),0,-INDIRECT(ADDRESS(6+F3,4,,,"D-Sche")),1))+SUM(OFFSET('l-curve'!$E$41,SUM(INDIRECT(ADDRESS(6,7,,,"D-Sche")):INDIRECT(ADDRESS(6+F3,7,,,"D-Sche"))),0,-INDIRECT(ADDRESS(6+F3,7,,,"D-Sche")),1))+SUM(OFFSET('l-curve'!$H$41,SUM(INDIRECT(ADDRESS(6,10,,,"D-Sche")):INDIRECT(ADDRESS(6+F3,10,,,"D-Sche"))),0,-INDIRECT(ADDRESS(6+F3,10,,,"D-Sche")),1))+SUM(OFFSET('l-curve'!$K$41,SUM(INDIRECT(ADDRESS(6,13,,,"D-Sche")):INDIRECT(ADDRESS(6+F3,13,,,"D-Sche"))),0,-INDIRECT(ADDRESS(6+F3,13,,,"D-Sche")),1))+SUM(OFFSET('l-curve'!$N$41,SUM(INDIRECT(ADDRESS(6,16,,,"D-Sche")):INDIRECT(ADDRESS(6+F3,16,,,"D-Sche"))),0,-INDIRECT(ADDRESS(6+F3,16,,,"D-Sche")),1))+SUM(OFFSET('l-curve'!$Q$41,SUM(INDIRECT(ADDRESS(6,19,,,"D-Sche")):INDIRECT(ADDRESS(6+F3,19,,,"D-Sche"))),0,-INDIRECT(ADDRESS(6+F3,19,,,"D-Sche")),1))
</CODE>
This is basically 6 products on 6 seperate learning curves and I am summing the values based on its position in the learning curve according to deliveries. So if in a month I am on unit 10, and delivery 6, I only want the values for 10-16, not 1-6, if you don't know what a learning curve is basically its you get more efficient as you build more. Any thoughts on a simplier formula?
Last edited:
