LinkBack URL
About LinkBacks
Hi all,
I've put below requirements into attached instruction.pdf.
1. An excel file with Input, Run, Output and Package Type worksheets.
2. User will copy and paste the data from other csv file into Input worksheet.
3. Four buttons and one field appear in Run worksheet as below
* Generate TOP explained in step 4
* Generate BOTTOM explained in step 4
* Clear Input clear the contents of Input Worksheet
* Clear Output clear the contents of Output Worksheet
* Depanel Tab a numeric value will be needed in step 8
with a script that autorun the process below
4. Whenever Generate TOP button is clicked, run process (4a) or Generate Bottom button is clicked, run process (4b)
In Input worksheet:-
(4a) if file name ends with _P then delete all rows with BOTTOM (Mirror column)
(4b) If file name ends with _S then delete all rows with TOP (Mirror column) and add –ve sign into CentroidX column.
5. Starting from this step onwards, apply to both Generate TOP and Generate Bottom buttons.
In Input worksheet:-
In Geometry column, If the value contains same characters with the one in Package Type worksheet, copy the package type value into Grid Location column.
But for FID in Geometry, the grid location will be based on Refdes column (ex: F1, F2, F3 and F4), if F1 then in grid location will be FID1
Example see attached pack. jpg
6. Refer to duplicate row.pdf
7. Delete rows with empty value in Grid Location column.
8. All value in CentroidY adds the numeric value in Depanel Tab field in Run worksheet.
Eg: If Refdes U1 with CentroidY 12.3456 and the numeric value in Depanel Tab is 5.08
12.3456 + 5.08 = 17.4256
Thus the result 17.4256 will replace in that field.
Example see attached depanel tab. jpg
9. Arrange the column into this format and output it in Output worksheet,
CentroidX CentroidY CentroidRotation Refdes GridLocation
10. The script will auto delete Row 1.
11. End
Register To Reply
Bookmarks