mech contractor
New Member
- Joined
- Sep 24, 2008
- Messages
- 10
[TABLE="width: 500"]
<TBODY>[TR]
[TD]Total Lin Ft[/TD]
[TD]Wk-1[/TD]
[TD]Wk-2[/TD]
[TD]Wk-3[/TD]
[TD]Wk-4[/TD]
[TD]Wk-5[/TD]
[TD]Wk-6[/TD]
[TD]Production LF Over Under[/TD]
[/TR]
[TR]
[TD]300[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]400[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]200[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1120[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]I just can’t seem to develop a formula for this; any help would be much appreciated.
<o> </o>
I am trying to develop a production / installation tracking sheet given a total linear footage of material to be installed in 6 weeks.
<o> </o>
The formula will need to be based on installation footages, wk-1, then Wk-2 up to 6 weeks. Based on the average linear feet installed each week I need the productivity column to indicate given the averages each week what is the linear footage that will be either ahead or behind at 6 weeks
<o> </o>
Thanks much all
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]
<TBODY>[TR]
[TD]Total Lin Ft[/TD]
[TD]Wk-1[/TD]
[TD]Wk-2[/TD]
[TD]Wk-3[/TD]
[TD]Wk-4[/TD]
[TD]Wk-5[/TD]
[TD]Wk-6[/TD]
[TD]Production LF Over Under[/TD]
[/TR]
[TR]
[TD]300[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]400[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]200[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1120[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]I just can’t seem to develop a formula for this; any help would be much appreciated.
<o> </o>
I am trying to develop a production / installation tracking sheet given a total linear footage of material to be installed in 6 weeks.
<o> </o>
The formula will need to be based on installation footages, wk-1, then Wk-2 up to 6 weeks. Based on the average linear feet installed each week I need the productivity column to indicate given the averages each week what is the linear footage that will be either ahead or behind at 6 weeks
<o> </o>
Thanks much all
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]