Hi All,
I have excel files whith lots of worksheets, To organise them Id like a tree diagram. Does anyone know of an add-in/or how to do this, so far ive been making VB coded buttons but its still a bit cumbersome.
Cheers
Duncan
Hi Greg,
Yes they are basically flat sheets of plate that intersect, each surface is usually defined with 3 or 4 points. aeach point is able to be located with x,y,z co-ordinates.
cheers
duncan
hi all,
Im trying to simply work out the surface area and volume of 3-D shapes. they are for transfer chutes between conveyors. Im struggling to make an algorithum that works, concavities are the main hassel.
cheers
duncan
Hi All,
I am investigating angles that are connected through one leg in truss arragements, part of this is to use the british method to work out capacities for australian sections. To do this i need to work out how the values in table 24 of BS 5950 (british steel code) were derived.
cheers
duncan
im looking for a more efficient way to specify two variables (row and column heading) and then having excel return a value from an array of numbers. presently i am using H&VLOOKUP functions but they seem to put a limit on the number of rows that are allowed in the array.
cheers
duncs
the other two guys are right here, the principle is called archimeedies (not sure on the spelling), the buoyancy force (upward) is equall to the weight of the water displaced. it not uncommon for tanks to float out of the ground if they are not properly anchored.
just looking for some comment on practical issues in dealing with fluctuating live loads leading to fatigue cracking in the mining and heavy industry sectors. it seems all the australian codes have responded to fatigue with a high level of mathmatical sophisication. i am interested in practical...
to further englishmuffin you should think of a wire accross a tennis net (a catenery), from experiance u will know that even if u tighten it as much as u can the wire will never be straight and eventually u will rip the post's out or the wire will break. if u look around there are some forumula...
i have a steel tank to patch up. it is 8meters high and 8 meters diameter. i need to perform a calculation on how large a patch i can remove before the tank buckles.Does anyone have any ideas on how to go about this.
