To perform an interpolation of the missing cells in the given matrix

[dabohra]

Hi

Request your help in developing an excel formula via which i can populate the empty portion of the provided excel model. Please take a look and let me know if it is possible.

Thanks,
Amit

[TABLE="class: grid, width: 2984"]
<TBODY>[TR]
[TD]Average Floor Area</SPAN>[/TD]
[TD]100</SPAN>[/TD]
[TD]125</SPAN>[/TD]
[TD]150</SPAN>[/TD]
[TD]175</SPAN>[/TD]
[TD]200</SPAN>[/TD]
[TD]250</SPAN>[/TD]
[TD]300</SPAN>[/TD]
[TD]350</SPAN>[/TD]
[TD]400</SPAN>[/TD]
[TD]450</SPAN>[/TD]
[TD]500</SPAN>[/TD]
[TD]600</SPAN>[/TD]
[TD]700</SPAN>[/TD]
[TD]800</SPAN>[/TD]
[TD]900</SPAN>[/TD]
[TD]1000</SPAN>[/TD]
[TD]1100</SPAN>[/TD]
[TD]1200</SPAN>[/TD]
[TD]1300</SPAN>[/TD]
[TD]1400</SPAN>[/TD]
[TD]1500</SPAN>[/TD]
[TD]1600</SPAN>[/TD]
[TD]1700</SPAN>[/TD]
[TD]1800</SPAN>[/TD]
[TD]1900</SPAN>[/TD]
[TD]2000</SPAN>[/TD]
[TD]2200</SPAN>[/TD]
[TD]2400</SPAN>[/TD]
[TD]2600</SPAN>[/TD]
[TD]3000</SPAN>[/TD]
[/TR]
[TR]
[TD]1,000</SPAN>[/TD]
[TD]1.252</SPAN>[/TD]
[TD]1.360</SPAN>[/TD]
[TD]1.468</SPAN>[/TD]
[TD]1.576</SPAN>[/TD]
[TD]1.684</SPAN>[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1,500</SPAN>[/TD]
[TD]1.112</SPAN>[/TD]
[TD]1.182</SPAN>[/TD]
[TD]1.252</SPAN>[/TD]
[TD]1.323</SPAN>[/TD]
[TD]1.395</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]2,000</SPAN>[/TD]
[TD][/TD]
[TD]1.095</SPAN>[/TD]
[TD]1.147</SPAN>[/TD]
[TD]1.199</SPAN>[/TD]
[TD]1.252</SPAN>[/TD]
[TD]1.360</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]2,500</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]1.083</SPAN>[/TD]
[TD]1.125</SPAN>[/TD]
[TD]1.168</SPAN>[/TD]
[TD]1.252</SPAN>[/TD]
[TD]1.340</SPAN>[/TD]
[TD]1.430</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3,000</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1.077</SPAN>[/TD]
[TD]1.112</SPAN>[/TD]
[TD]1.182</SPAN>[/TD]
[TD]1.252</SPAN>[/TD]
[TD]1.323</SPAN>[/TD]
[TD]1.395</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]4,000</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1.013</SPAN>[/TD]
[TD]1.040</SPAN>[/TD]
[TD]1.094</SPAN>[/TD]
[TD]1.147</SPAN>[/TD]
[TD]1.199</SPAN>[/TD]
[TD]1.252</SPAN>[/TD]
[TD]1.306</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]5,000</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.996</SPAN>[/TD]
[TD]1.040</SPAN>[/TD]
[TD]1.083</SPAN>[/TD]
[TD]1.125</SPAN>[/TD]
[TD]1.168</SPAN>[/TD]
[TD]1.210</SPAN>[/TD]
[TD]1.252</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]6,000</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1.004</SPAN>[/TD]
[TD]1.040</SPAN>[/TD]
[TD]1.077</SPAN>[/TD]
[TD]1.112</SPAN>[/TD]
[TD]1.147</SPAN>[/TD]
[TD]1.182</SPAN>[/TD]
[TD]1.252</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]7,000</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1.008</SPAN>[/TD]
[TD]1.040</SPAN>[/TD]
[TD]1.071</SPAN>[/TD]
[TD]1.102</SPAN>[/TD]
[TD]1.132</SPAN>[/TD]
[TD]1.192</SPAN>[/TD]
[TD]1.252</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]8,000</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.984</SPAN>[/TD]
[TD]1.013</SPAN>[/TD]
[TD]1.040</SPAN>[/TD]
[TD]1.068</SPAN>[/TD]
[TD]1.094</SPAN>[/TD]
[TD]1.147</SPAN>[/TD]
[TD]1.199</SPAN>[/TD]
[TD]1.252</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]10,000</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.972</SPAN>[/TD]
[TD]0.996</SPAN>[/TD]
[TD]1.019</SPAN>[/TD]
[TD]1.040</SPAN>[/TD]
[TD]1.083</SPAN>[/TD]
[TD]1.125</SPAN>[/TD]
[TD]1.168</SPAN>[/TD]
[TD]1.210</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]12,000</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.965</SPAN>[/TD]
[TD]0.984</SPAN>[/TD]
[TD]1.003</SPAN>[/TD]
[TD]1.040</SPAN>[/TD]
[TD]1.077</SPAN>[/TD]
[TD]1.112</SPAN>[/TD]
[TD]1.147</SPAN>[/TD]
[TD]1.182</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]14,000</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.945</SPAN>[/TD]
[TD]0.961</SPAN>[/TD]
[TD]0.977</SPAN>[/TD]
[TD]1.008</SPAN>[/TD]
[TD]1.040</SPAN>[/TD]
[TD]1.071</SPAN>[/TD]
[TD]1.102</SPAN>[/TD]
[TD]1.132</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]16,000</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.943</SPAN>[/TD]
[TD]0.957</SPAN>[/TD]
[TD]0.984</SPAN>[/TD]
[TD]1.013</SPAN>[/TD]
[TD]1.040</SPAN>[/TD]
[TD]1.068</SPAN>[/TD]
[TD]1.094</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]18,000</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.929</SPAN>[/TD]
[TD]0.942</SPAN>[/TD]
[TD]0.967</SPAN>[/TD]
[TD]0.991</SPAN>[/TD]
[TD]1.016</SPAN>[/TD]
[TD]1.040</SPAN>[/TD]
[TD]1.065</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]20,000</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.926</SPAN>[/TD]
[TD]0.949</SPAN>[/TD]
[TD]0.972</SPAN>[/TD]
[TD]0.996</SPAN>[/TD]
[TD]1.019</SPAN>[/TD]
[TD]1.040</SPAN>[/TD]
[TD]1.062</SPAN>[/TD]
[TD]1.083</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]25,000</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.907</SPAN>[/TD]
[TD]0.924</SPAN>[/TD]
[TD]0.942</SPAN>[/TD]
[TD]0.959</SPAN>[/TD]
[TD]0.977</SPAN>[/TD]
[TD]0.996</SPAN>[/TD]
[TD]1.015</SPAN>[/TD]
[TD]1.032</SPAN>[/TD]
[TD]1.049</SPAN>[/TD]
[TD]1.066</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]30,000</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.907</SPAN>[/TD]
[TD]0.921</SPAN>[/TD]
[TD]0.935</SPAN>[/TD]
[TD]0.949</SPAN>[/TD]
[TD]0.965</SPAN>[/TD]
[TD]0.980</SPAN>[/TD]
[TD]0.995</SPAN>[/TD]
[TD]1.010</SPAN>[/TD]
[TD]1.025</SPAN>[/TD]
[TD]1.040</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]35,000</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.896</SPAN>[/TD]
[TD]0.907</SPAN>[/TD]
[TD]0.919</SPAN>[/TD]
[TD]0.932</SPAN>[/TD]
[TD]0.945</SPAN>[/TD]
[TD]0.957</SPAN>[/TD]
[TD]0.969</SPAN>[/TD]
[TD]0.982</SPAN>[/TD]
[TD]0.995</SPAN>[/TD]
[TD]1.008</SPAN>[/TD]
[TD]1.021</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]40,000</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.899</SPAN>[/TD]
[TD]0.907</SPAN>[/TD]
[TD]0.916</SPAN>[/TD]
[TD]0.926</SPAN>[/TD]
[TD]0.937</SPAN>[/TD]
[TD]0.949</SPAN>[/TD]
[TD]0.961</SPAN>[/TD]
[TD]0.972</SPAN>[/TD]
[TD]0.984</SPAN>[/TD]
[TD]0.995</SPAN>[/TD]
[TD]1.007</SPAN>[/TD]
[TD]1.019</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]45,000</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.898</SPAN>[/TD]
[TD]0.907</SPAN>[/TD]
[TD]0.916</SPAN>[/TD]
[TD]0.926</SPAN>[/TD]
[TD]0.935</SPAN>[/TD]
[TD]0.945</SPAN>[/TD]
[TD]0.955</SPAN>[/TD]
[TD]0.965</SPAN>[/TD]
[TD]0.975</SPAN>[/TD]
[TD]0.985</SPAN>[/TD]
[TD]0.995</SPAN>[/TD]
[TD]1.005</SPAN>[/TD]
[TD]1.015</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]50,000</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.891</SPAN>[/TD]
[TD]0.898</SPAN>[/TD]
[TD]0.907</SPAN>[/TD]
[TD]0.916</SPAN>[/TD]
[TD]0.924</SPAN>[/TD]
[TD]0.933</SPAN>[/TD]
[TD]0.942</SPAN>[/TD]
[TD]0.950</SPAN>[/TD]
[TD]0.959</SPAN>[/TD]
[TD]0.968</SPAN>[/TD]
[TD]0.977</SPAN>[/TD]
[TD]0.986</SPAN>[/TD]
[TD]0.996</SPAN>[/TD]
[TD]1.015</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]60,000</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.889</SPAN>[/TD]
[TD]0.895</SPAN>[/TD]
[TD]0.901</SPAN>[/TD]
[TD]0.907</SPAN>[/TD]
[TD]0.914</SPAN>[/TD]
[TD]0.921</SPAN>[/TD]
[TD]0.928</SPAN>[/TD]
[TD]0.935</SPAN>[/TD]
[TD]0.942</SPAN>[/TD]
[TD]0.949</SPAN>[/TD]
[TD]0.957</SPAN>[/TD]
[TD]0.965</SPAN>[/TD]
[TD]0.980</SPAN>[/TD]
[TD]0.995</SPAN>[/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]70,000</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.877</SPAN>[/TD]
[TD]0.884</SPAN>[/TD]
[TD]0.890</SPAN>[/TD]
[TD]0.896</SPAN>[/TD]
[TD]0.902</SPAN>[/TD]
[TD]0.907</SPAN>[/TD]
[TD]0.913</SPAN>[/TD]
[TD]0.919</SPAN>[/TD]
[TD]0.925</SPAN>[/TD]
[TD]0.932</SPAN>[/TD]
[TD]0.939</SPAN>[/TD]
[TD]0.945</SPAN>[/TD]
[TD]0.957</SPAN>[/TD]
[TD]0.969</SPAN>[/TD]
[TD]0.982</SPAN>[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]80,000</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.869</SPAN>[/TD]
[TD]0.875</SPAN>[/TD]
[TD]0.881</SPAN>[/TD]
[TD]0.887</SPAN>[/TD]
[TD]0.893</SPAN>[/TD]
[TD]0.898</SPAN>[/TD]
[TD]0.903</SPAN>[/TD]
[TD]0.907</SPAN>[/TD]
[TD]0.911</SPAN>[/TD]
[TD]0.916</SPAN>[/TD]
[TD]0.921</SPAN>[/TD]
[TD]0.926</SPAN>[/TD]
[TD]0.937</SPAN>[/TD]
[TD]0.949</SPAN>[/TD]
[TD]0.961</SPAN>[/TD]
[TD]0.984</SPAN>[/TD]
[/TR]
[TR]
[TD]100,000</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.863</SPAN>[/TD]
[TD]0.868</SPAN>[/TD]
[TD]0.872</SPAN>[/TD]
[TD]0.877</SPAN>[/TD]
[TD]0.882</SPAN>[/TD]
[TD]0.887</SPAN>[/TD]
[TD]0.891</SPAN>[/TD]
[TD]0.895</SPAN>[/TD]
[TD]0.899</SPAN>[/TD]
[TD]0.903</SPAN>[/TD]
[TD]0.907</SPAN>[/TD]
[TD]0.916</SPAN>[/TD]
[TD]0.924</SPAN>[/TD]
[TD]0.933</SPAN>[/TD]
[TD]0.950</SPAN>[/TD]
[/TR]
[TR]
[TD]120,000</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.856</SPAN>[/TD]
[TD]0.859</SPAN>[/TD]
[TD]0.863</SPAN>[/TD]
[TD]0.867</SPAN>[/TD]
[TD]0.871</SPAN>[/TD]
[TD]0.875</SPAN>[/TD]
[TD]0.879</SPAN>[/TD]
[TD]0.883</SPAN>[/TD]
[TD]0.887</SPAN>[/TD]
[TD]0.891</SPAN>[/TD]
[TD]0.895</SPAN>[/TD]
[TD]0.901</SPAN>[/TD]
[TD]0.907</SPAN>[/TD]
[TD]0.914</SPAN>[/TD]
[TD]0.928</SPAN>[/TD]
[/TR]
[TR]
[TD]140,000</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.851</SPAN>[/TD]
[TD]0.854</SPAN>[/TD]
[TD]0.857</SPAN>[/TD]
[TD]0.860</SPAN>[/TD]
[TD]0.863</SPAN>[/TD]
[TD]0.867</SPAN>[/TD]
[TD]0.871</SPAN>[/TD]
[TD]0.874</SPAN>[/TD]
[TD]0.877</SPAN>[/TD]
[TD]0.880</SPAN>[/TD]
[TD]0.884</SPAN>[/TD]
[TD]0.890</SPAN>[/TD]
[TD]0.896</SPAN>[/TD]
[TD]0.902</SPAN>[/TD]
[TD]0.913</SPAN>[/TD]
[/TR]
[TR]
[TD]160,000</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.850</SPAN>[/TD]
[TD]0.853</SPAN>[/TD]
[TD]0.855</SPAN>[/TD]
[TD]0.858</SPAN>[/TD]
[TD]0.860</SPAN>[/TD]
[TD]0.863</SPAN>[/TD]
[TD]0.866</SPAN>[/TD]
[TD]0.869</SPAN>[/TD]
[TD]0.872</SPAN>[/TD]
[TD]0.875</SPAN>[/TD]
[TD]0.881</SPAN>[/TD]
[TD]0.887</SPAN>[/TD]
[TD]0.893</SPAN>[/TD]
[TD]0.903</SPAN>[/TD]
[/TR]
[TR]
[TD]180,000</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.846</SPAN>[/TD]
[TD]0.849</SPAN>[/TD]
[TD]0.851</SPAN>[/TD]
[TD]0.854</SPAN>[/TD]
[TD]0.856</SPAN>[/TD]
[TD]0.858</SPAN>[/TD]
[TD]0.860</SPAN>[/TD]
[TD]0.863</SPAN>[/TD]
[TD]0.866</SPAN>[/TD]
[TD]0.869</SPAN>[/TD]
[TD]0.874</SPAN>[/TD]
[TD]0.879</SPAN>[/TD]
[TD]0.884</SPAN>[/TD]
[TD]0.895</SPAN>[/TD]
[/TR]
[TR]
[TD]200,000</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.846</SPAN>[/TD]
[TD]0.848</SPAN>[/TD]
[TD]0.850</SPAN>[/TD]
[TD]0.853</SPAN>[/TD]
[TD]0.855</SPAN>[/TD]
[TD]0.857</SPAN>[/TD]
[TD]0.859</SPAN>[/TD]
[TD]0.861</SPAN>[/TD]
[TD]0.863</SPAN>[/TD]
[TD]0.868</SPAN>[/TD]
[TD]0.873</SPAN>[/TD]
[TD]0.877</SPAN>[/TD]
[TD]0.887</SPAN>[/TD]
[/TR]
[TR]
[TD]225,000</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.845</SPAN>[/TD]
[TD]0.847</SPAN>[/TD]
[TD]0.849</SPAN>[/TD]
[TD]0.851</SPAN>[/TD]
[TD]0.853</SPAN>[/TD]
[TD]0.855</SPAN>[/TD]
[TD]0.856</SPAN>[/TD]
[TD]0.858</SPAN>[/TD]
[TD]0.862</SPAN>[/TD]
[TD]0.867</SPAN>[/TD]
[TD]0.871</SPAN>[/TD]
[TD]0.879</SPAN>[/TD]
[/TR]
[TR]
[TD]250,000</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.842</SPAN>[/TD]
[TD]0.844</SPAN>[/TD]
[TD]0.846</SPAN>[/TD]
[TD]0.848</SPAN>[/TD]
[TD]0.849</SPAN>[/TD]
[TD]0.851</SPAN>[/TD]
[TD]0.853</SPAN>[/TD]
[TD]0.855</SPAN>[/TD]
[TD]0.858</SPAN>[/TD]
[TD]0.862</SPAN>[/TD]
[TD]0.866</SPAN>[/TD]
[TD]0.873</SPAN>[/TD]
[/TR]
[TR]
[TD]275,000</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.839</SPAN>[/TD]
[TD]0.841</SPAN>[/TD]
[TD]0.843</SPAN>[/TD]
[TD]0.845</SPAN>[/TD]
[TD]0.847</SPAN>[/TD]
[TD]0.848</SPAN>[/TD]
[TD]0.850</SPAN>[/TD]
[TD]0.852</SPAN>[/TD]
[TD]0.855</SPAN>[/TD]
[TD]0.858</SPAN>[/TD]
[TD]0.862</SPAN>[/TD]
[TD]0.868</SPAN>[/TD]
[/TR]
[TR]
[TD]300,000</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.839</SPAN>[/TD]
[TD]0.841</SPAN>[/TD]
[TD]0.842</SPAN>[/TD]
[TD]0.844</SPAN>[/TD]
[TD]0.846</SPAN>[/TD]
[TD]0.847</SPAN>[/TD]
[TD]0.849</SPAN>[/TD]
[TD]0.852</SPAN>[/TD]
[TD]0.855</SPAN>[/TD]
[TD]0.857</SPAN>[/TD]
[TD]0.863</SPAN>[/TD]
[/TR]
[TR]
[TD]350,000</SPAN>[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0.835</SPAN>[/TD]
[TD]0.836</SPAN>[/TD]
[TD]0.839</SPAN>[/TD]
[TD]0.840</SPAN>[/TD]
[TD]0.841</SPAN>[/TD]
[TD]0.843</SPAN>[/TD]
[TD]0.845</SPAN>[/TD]
[TD]0.847</SPAN>[/TD]
[TD]0.850</SPAN>[/TD]
[TD]0.853</SPAN>[/TD]
[TD]0.857</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL span=4><COL><COL><COL><COL span=2><COL><COL span=4></COLGROUP>[/TABLE]

 

[p45cal]

There may be a couple of ways to try to do this, the value in any particuar cell might be calculated from the values in the leftmost column in the same row and the uppermost row in the same column, or perhaps the trend can be looked at from all the other values in the same row (or is it column? (I'd need an answer to this one)).
So if you could give a clue as to what these figures represent and how they might be calculated…

 

[dabohra]

I would like to calculate or forecast for cell where row value is 2000 and column value is 100 and it considers the value of 1.252 and 1.112. This is one way to look at it. Other way is to look at row value 1000 and all the value beside that and also take the value header from 100 - 200 to get a value for cell where it meets 250 & 1000. Let me know if this helps.

 

[p45cal]

I would like to calculate or forecast for cell where row value is 2000 and column value is 100 and it considers the value of 1.252 and 1.112.

Two points isn't much to go on, but:

*	A	B
Average Floor Area

<tbody>
[TD="bgcolor: #cacaca, align: center"]1[/TD]

[TD="align: right"]100[/TD]

[TD="bgcolor: #cacaca, align: center"]2[/TD]
[TD="align: right"]1,000[/TD]
[TD="bgcolor: #ccffff, align: right"]1.252[/TD]

[TD="bgcolor: #cacaca, align: center"]3[/TD]
[TD="align: right"]1,500[/TD]
[TD="bgcolor: #ccffff, align: right"]1.112[/TD]

[TD="bgcolor: #cacaca, align: center"]4[/TD]
[TD="align: right"]2,000[/TD]
[TD="align: right"]0.972
[/TD]

</tbody>

Spreadsheet Formulas

Cell Formula B4 =TREND($B$2:$B$3,$A$2:$A$3,A4,TRUE) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

This is a linear extrapolation which isn't likely to be very reliable since if we look at other vertical series we see a curve rather than a straight line. That's why I'd like some clue as to what these figures represent and how they might be calculated.

Other way is to look at row value 1000 and all the value beside that and also take the value header from 100 - 200 to get a value for cell where it meets 250 & 1000.

With this:

*	A	B	C	D	E	F	G
Average Floor Area

<tbody>
[TD="bgcolor: #cacaca, align: center"]1[/TD]

[TD="align: right"]100[/TD]
[TD="align: right"]125[/TD]
[TD="align: right"]150[/TD]
[TD="align: right"]175[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]250[/TD]

[TD="bgcolor: #cacaca, align: center"]2[/TD]
[TD="align: right"]1,000[/TD]
[TD="bgcolor: #ccffff, align: right"]1.252[/TD]
[TD="bgcolor: #ccffff, align: right"]1.36[/TD]
[TD="bgcolor: #ccffff, align: right"]1.468[/TD]
[TD="bgcolor: #ccffff, align: right"]1.576[/TD]
[TD="bgcolor: #ccffff, align: right"]1.684[/TD]
[TD="align: right"]1.9[/TD]

</tbody>

Spreadsheet Formulas

Cell Formula G2 =TREND($B$2:$F$2,$B$1:$F$1,G1,TRUE) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

again a linear trend (best straight line) is used. This time the value will be a little more reliable as (a) the existing values are almost in a straight line and (b) there are more than two points, however, the relation is not likely to be linear as examination of row series further down the table reveals.

Using the same technique to get the value for 2000/100 yields:

*	A	B	C	D	E	F	G

<colgroup><col style="width:30px; "><col style="width:130px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"></colgroup><tbody>
[TD="bgcolor: #cacaca, align: center"]4[/TD]
[TD="align: right"]2,000[/TD]
[TD="align: right"]1.041[/TD]
[TD="bgcolor: #ccffff, align: right"]1.095[/TD]
[TD="bgcolor: #ccffff, align: right"]1.147[/TD]
[TD="bgcolor: #ccffff, align: right"]1.199[/TD]
[TD="bgcolor: #ccffff, align: right"]1.252[/TD]
[TD="bgcolor: #ccffff, align: right"]1.36[/TD]

</tbody>

Spreadsheet Formulas

Cell Formula B4 =TREND($C$4:$G$4,$C$1:$G$1,B1,TRUE) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

instead of 0.972

Let me know if this helps.

Not a lot. Again, if you could give a clue as to what these figures represent and how they might be calculated then…