Maradona_10
02-17-2012, 07:16 PM
Hi all,
This is my first post on the forum and I'm really excited.:hi:
So here it goes: I would like to have an advice ( to have a more efficient coding) on how to store data using arrays. I have an excel sheet with conductor types (rows) and its characteristics ( diameter, unit weight, strength etc... columns)
I was thinking to use many one dimension array (as many columns there are in the excel sheet) to do this:
arrayConductor ( "drake", "Curlew", etc.....)
arrayDiameter (15,30,32, etc....)
arrayUnitWeight (19,36,21, etc...)
arrayetc....
My problem is that:
1) Probably there is a more efficient way to do this (multi-dimensional arrays?)
2) It will be very hard to verify/correct if all the characteristics are on the right conductor. For example, for the conductor Curlew all data about it (diameter, unit weight, etc...) is on the second item on all array, but what about the 32th conductor? You gotta count the 32th data on every array. To me this is a great way to make errors.
Thank you in advance for your help.:thumb
This is my first post on the forum and I'm really excited.:hi:
So here it goes: I would like to have an advice ( to have a more efficient coding) on how to store data using arrays. I have an excel sheet with conductor types (rows) and its characteristics ( diameter, unit weight, strength etc... columns)
I was thinking to use many one dimension array (as many columns there are in the excel sheet) to do this:
arrayConductor ( "drake", "Curlew", etc.....)
arrayDiameter (15,30,32, etc....)
arrayUnitWeight (19,36,21, etc...)
arrayetc....
My problem is that:
1) Probably there is a more efficient way to do this (multi-dimensional arrays?)
2) It will be very hard to verify/correct if all the characteristics are on the right conductor. For example, for the conductor Curlew all data about it (diameter, unit weight, etc...) is on the second item on all array, but what about the 32th conductor? You gotta count the 32th data on every array. To me this is a great way to make errors.
Thank you in advance for your help.:thumb