Hoist worksheet / Database

[BRSebbe]

Hello

As im not really used to working with worksheets/excel in general i now turn to the community. 

I am trying to make a worksheet template for hoists, to make an automatic X/Y list for sending out to riggers onsite. 

The idea im trying to make happen is that once imported into the current document im working on it displays the hoists i put in the drawing, sorted on +-/XY, and also if i delete a hoist it will also disappear from there

Any help or pointers as to how to get there, or if my idea just isnt doable would be much appreciated! 

Kind Regards
Sebbe

[BRSebbe]

So I've gotten this far, the issue i have now is how to properly sort it the way i want to. 

That being i want it to sort on the "Origin Y" But to sort it as + or - so that every - is on one half and all the + is on the other half, as you go about chalking it out. 

 

 

 

 

 

[Mike Rock]

 

One way to achieve this would be to sort by a 2nd value. I filled in the Position field with SL, C, or SR to allow me to do all the points on center first, then all the SL points in order according to the origin Y value, I didn't bother but in theory you could filter the Origin X row to make sure you have the point closest to center first. Notice the small 1 under the filter arrow for position and the small 2 under the Origin Y filter. this tells you in what order the filtering is applied. 

Someone a little more clever might have another solution...

[Mike Rock]

I can be more clever...

 

I inserted column B and put '=IF((C2<0),SR,SL)' in cell B2, that assigned each point to SR or SL without taking up the position field on the record. The edge case for points on the center line getting assigned to SL doesn't seem too bad for the ease of implementation...

 

 

Edited February 29 by Mike Rock

[jcogdell]

Another option is the create hoist report command from the Rigging/Braceworks section of the Spotlight menu
This is a specialised command that will generate a list like above with a number of sort options, including hoist id's, y- position, straight path and the specialised antways. Antways calculates the most efficient path for the onsite riggers to use when hanging the hoists and will order list accordingly.

[BRSebbe]

Fine suggestions all of it, although not quite what im after! 
I've gotten closer to the goal, now i just need help to figure out how to sort these 3 columns the way i want. 

 

So i want column "C" To display only -X numbers
Column "D" to go from positive 420 to 0 to -420 
And column "E" To display only positive numbers i've manually created a non working example, see attached image #2

 

 

 

 

 

[Mike Rock]

Try this formula in C2 '=IF(('BrxHoist'.'OriginX'<=0), 'BrxHoist'.'OriginX', ' ')'

 

As for your Y values not sorting correctly it looks like you might be using Origin y (formatted) try changing that to Origin Y. 

Edited February 29 by Mike Rock

[BRSebbe]

1 hour ago, Mike Rock said:

Try this formula in C2 '=IF(('BrxHoist'.'OriginX'<=0), 'BrxHoist'.'OriginX', ' ')'

 

As for your Y values not sorting correctly it looks like you might be using Origin y (formatted) try changing that to Origin Y. 

That seems to have done the trick for the Y origing

Although i messed up the formula or it was wrong as i am getting this! 

 

KR 
Sebbe

 

 

 

 

[Mike Rock]

7 minutes ago, BRSebbe said:

That seems to have done the trick for the Y origing

Although i messed up the formula or it was wrong as i am getting this! 

 

KR 
Sebbe

 

You need to provide the value for if the IF statement was false. It will go between the last comma and ) In the formula I supplied I used an empty string ' '  You could also put some text there. To learn more with the worksheet open click Insert>Function and select If and it will tell you how to structure the formula.

[BRSebbe]

2 hours ago, Mike Rock said:

You need to provide the value for if the IF statement was false. It will go between the last comma and ) In the formula I supplied I used an empty string ' '  You could also put some text there. To learn more with the worksheet open click Insert>Function and select If and it will tell you how to structure the formula.

 

 

 

Thank you! Will play around with that