Avatar

Level 2

Tables:
/------------------/
/adinstance /
/----------------/

/--------------------------/-----------------------------------/    /----------------------------/---------------------------/
/ DROP DOWN   /      Power Rating          /     /  # of 110 circuits / # of 208 circuits /
/ (110 or 208)     / (input any #, eg 500)    /      /-----------------------------/-------------------------/

/----------------------/-----------------------------------/      /        x                   /              y         /
                                                                 /----------------------------/-------------------------/

I got the math function to determine the # of 110 and 208 circuits and thats OK:

Math.ceil ((Table2.Row2.Cell(1 or 2).rawValue / 110 or 208)   / 20 (for 110) or 30 (for 208)

Its getting quite difficult for me because of the drop down box thing since on the first instance suppose you get (3) 110 circuits, when you add another instance and it gives you another 2 circuits, those two results would add up and be 5 110 circuits, the same thing with the 208 circuits and so on...

I need general guidelines please!!! I included a test file with the basic layout just in case. Thanks!