I am not sure how many people here are familiar with Bill of Materials but here is my question.

I need to find out how to get the values in column cost.


Level
1 2 3 4 Part Number Qty Cost Extended Cost
1.0 A 2 =(6*1)+((10*2)+(4*3)+(3*6)*4)*5+(7*1) =((6*1)+((10*2)+(4*3)+(3*6)*4)*5+(7*1))*2
0.2 B 1 6 =6*1
0.2 C 5 =(10*2)+(4*3)+(3*6)*4 =((10*2)+(4*3)+(3*6)*4)*5
0.3 D 2 10 =10*2
0.3 E 3 4 =4*3
0.3 F 4 =3*6 =(3*6)*4
0.4 G 6 3 =3*6
0.2 H 1 7 =7*1
1.0 I 7 =(5*1)*2 =((5*1)*2)*7
0.3 J 2 =5*1 =(5*1)*2
0.4 K 1 5 =5*1


EggHeadCafe - Software Developer Portal of Choice
WPF And The Model View View Model Pattern
http://www.eggheadcafe.com/tutorials...l-view-vi.aspx

Nick
The people reading your post know Excel and most of us are quite
familiar with a bill of materials. What we don't know is your business, or
any part of it. Post back and explain what you have (in generic terms),
what you want to have, and how you would like to get from one to the other.
HTH Otto
<nick masonn> wrote in message news:(E-Mail Removed)...
>I am not sure how many people here are familiar with Bill of Materials but
>here is my question.
>
> I need to find out how to get the values in column cost.
>
>
> Level
> 1 2 3 4 Part Number Qty Cost Extended Cost
> 1.0 A 2 =(6*1)+((10*2)+(4*3)+(3*6)*4)*5+(7*1)
> =((6*1)+((10*2)+(4*3)+(3*6)*4)*5+(7*1))*2
> 0.2 B 1 6 =6*1
> 0.2 C 5 =(10*2)+(4*3)+(3*6)*4 =((10*2)+(4*3)+(3*6)*4)*5
> 0.3 D 2 10 =10*2
> 0.3 E 3 4 =4*3
> 0.3 F 4 =3*6 =(3*6)*4
> 0.4 G 6 3 =3*6
> 0.2 H 1 7 =7*1
> 1.0 I 7 =(5*1)*2 =((5*1)*2)*7
> 0.3 J 2 =5*1 =(5*1)*2
> 0.4 K 1 5 =5*1
>
>
> EggHeadCafe - Software Developer Portal of Choice
> WPF And The Model View View Model Pattern
> http://www.eggheadcafe.com/tutorials...l-view-vi.aspx