need to calculate materials

[chrisRosco]

I need to determine how much liner feet of different products with varying widths I need, based on dimensions provided. Excel 2003.

My spreadsheet has:

□ A number assigned to each part in the job (windows in this case, ie: window 1, window 2)
□ A Validation drop down list of the materials pulled from columns for each material with product codes and widths
□ Dimensions of each window, width and height


Worksheet #1, the Window numbers are assigned and dimensions are entered.
Worksheet #2, the Window numbers are automatically entered from WS#1 and the user chooses which material from the Validation drop down

At this point in a group of cels in Worksheet #3, based on the Window number and the chosen material from WS#2 I would like to:

□ look at the dimensions from WS#1, take the height and divide by the selected materials width, rounding up to multiples of the material width (eg: material width is 60 inches, window height is 95 inches, it will take 2 section widths of the material to cover that area)
□ multiply the rounded number of sections by the width (this gives me the linear feet required for that window
□ but... if the window width is less than the selected material width I want to invert the material and do a straight linear footage calculation based on window height. I need the formula to recognize this based on the material selected in WS#2

There will be multiple materials, so this will generate a list of materials selected and how much linear footage is required for each. At this point I can take the linear footage and calculate costs.


Kind of complex but I hope someone can offer some ideas. Thanks.

[arthurbr]

Hi and welcome to the board.Unfortunately

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST

[chrisRosco]

I will delete my post. I thought this site would be of help to those who are not experts with Excel and know what their results need to be but not the way to get there. Wrong community I guess.