View attachment 3512653
Example for 4x4
If we average all the numbers we get 572, which is wrong in my opinion.
The Green area is 1sqft. So multiply average PPF in this green area with 1 weighing coefficient.
The Blue area is 3 sqft. So multiply average PPF in this blue area with 3 weighing coefficient.
The Orange area is 5 sqft. So multiply average PPF in this orange area with 5 weighing coefficient.
The yellow area is 7 sqft. So multiply average PPF in this yellow area with 7 weighing coefficient.
Now add all and divide by total weighing coefficient (1+3+5+7= 16)
Why yellow 7sqft?
4x4sqft - 3*3sqft = 16-9=7
All formulas are in the attached excel
for Data1 column I will explain for row #1 (900+840)/2= 870
for Data2 column I will explain for row #1 (900+810)/2= 855
for Data1 column I will explain for row #2 (840+720)/2= 780
for Data2 column I will explain for row #2 (810+570)/2= 690
@guod
View attachment 3512656
Let me know if you see anything wrong with this approach.
@Stephenj37826 Thanks for letting me use your data to explain this.