AnsweredAssumed Answered

How can i get the wire numbers in ODD or Even Numbering?

Question asked by Harshith K. S. on Apr 10, 2018
Latest reply on Apr 17, 2018 by Harshith K. S.

Like • Show 0 Likes0
Comment • 7

I am using a wire group with 2 wires, the first phase wire and another is neutral/ ground.

I want the wire numbering in such a fashion that the single phase wire must be all odd. And ground wires must be even.

I tried modifying from our end and got a result that all phase wires are in odd and ground wires are in even. But the problem is for the first wire under even is undefined. I used the following formula.

IIF(EVEN(EQUIPOTENTIAL_ORDERNO)==true,EQUIPOTENTIAL_ORDERNO)

IIF(ODD(EQUIPOTENTIAL_ORDERNO)==true,EQUIPOTENTIAL_ORDERNO)

So here I got to know that this "IIF" statement works with a syntax 'IIF(CONDITION, TRUE STATEMENT, FALSE STATEMENT)'

Hence we modified the formulae as IIF(ODD(EQUIPOTENTIAL_ORDERNO)==true,EQUIPOTENTIAL_ORDERNO,EQUIPOTENTIAL_ORDERNO+1) and respectively.

So from this above formula, I was getting the things as per the requirement in the 'TEST' window.

But this result is not replicated on schematics.

No one else has this question

Outcomes

Lord Fly Apr 12, 2018 2:33 PM

My only guess would be that you are putting it in the Wire formula rather than the Equipotential formula

Especially if it is working in the test window.

Actions

Harshith K. S. @ Lord Fly on Apr 13, 2018 12:18 AM

Hi,

Thank you for your reply.

No I have modified in both formulae and tried with respective changes. Same results.

One more thing I observed, if I change equipotential formula to 'EQUIPOTENTIAL_ORDER+1' then in the test window I am getting the results as per the inputs. If the input is 1, the result is 2. But in scheme it will be 11.

Check out by changing the above formula for any of the wire and see the changes, and can you please update me.

Thank you in advance. Looking forward for your reply

Actions

Lord Fly @ Harshith K. S. on Apr 13, 2018 8:32 AM

You are definitely right. It seems to think that +1 is the same as + "1". I tried a few things to get around this. The only one that seems to work is to give it a ridiculous formula that is the same as just adding 1. I used this (EQUIPOTENTIAL_ORDERNO*1)+1 and it seems to do that trick. It's a bit stupid, but it works.

Actions

Harshith K. S. @ Lord Fly on Apr 16, 2018 1:08 AM

Hi,

Thank you for your reply.

I was checking this out which you have sent. This is working very much fine with respect to the ODD number of wires. But these are not working with EVEN.

You can see the above image for the result.

I have given the above formula for the Equipotential number formula with some integration to convert to ODD or Even, as you suggested. Can you please check this put under even numbers

Actions

Brian Cooke @ Lord Fly on Apr 16, 2018 1:06 PM

VAL(EQUIPOTENTIAL_ORDERNO)+1 should do the same thing. Convert's the string to a number so that it adds 1 instead of appending 1.

Actions

Brian Cooke Apr 16, 2018 1:20 PM

I'm not sure how using a formula that adds 1 would work. Wouldn't wire 1 = 1, wire 2 = 3, and wire 3 = 3? so you would end up with multiple equipotentials of the same number?

For the wirestyles that you want to be even, just set the formula to =EQUIPOTENTIAL_ORDERNO*2

For the wirestyles you want to be odd, set to =EQUIPOTENTIAL_ORDERNO*2 - 1

No IF statements necessary.

Now for the caveat: If all your wirestyles are in the same group, you'll end up with some numbers getting skipped, but it's an easy fix. In your wire style manage put all the even numbered wire styles in one group and the odd in another. That way the ordernumbers will start over for each group, and all the odds will use all available ordernumbers, and the same with the even styles.

Edit: i missed that it was a multi-wire style, so you couldn't put them in separate groups. Not sure what to do about that. I'll have to think on it.

Actions

Harshith K. S. @ Brian Cooke on Apr 17, 2018 5:58 AM

Hi Cooke,

Many many thanks for your reply,

I am able to reach my requirement for now.

Actions

7 Replies

Lord Fly Apr 12, 2018 2:33 PM
Mark Correct
Correct Answer
My only guess would be that you are putting it in the Wire formula rather than the Equipotential formula

Especially if it is working in the test window.
Like • Show 0 Likes0
Actions
- Harshith K. S. @ Lord Fly on Apr 13, 2018 12:18 AM
  Mark Correct
  Correct Answer
  Hi,
  
  Thank you for your reply.
  
  No I have modified in both formulae and tried with respective changes. Same results.
  One more thing I observed, if I change equipotential formula to 'EQUIPOTENTIAL_ORDER+1' then in the test window I am getting the results as per the inputs. If the input is 1, the result is 2. But in scheme it will be 11.
  Check out by changing the above formula for any of the wire and see the changes, and can you please update me.
  
  Thank you in advance. Looking forward for your reply
  Like • Show 0 Likes0
  Actions
  - Lord Fly @ Harshith K. S. on Apr 13, 2018 8:32 AM
    Mark Correct
    Correct Answer
    You are definitely right. It seems to think that +1 is the same as + "1". I tried a few things to get around this. The only one that seems to work is to give it a ridiculous formula that is the same as just adding 1. I used this (EQUIPOTENTIAL_ORDERNO*1)+1 and it seems to do that trick. It's a bit stupid, but it works.
    Like • Show 0 Likes0
    Actions
    - Harshith K. S. @ Lord Fly on Apr 16, 2018 1:08 AM
      Mark Correct
      Correct Answer
      Hi,
      Thank you for your reply.
      
      I was checking this out which you have sent. This is working very much fine with respect to the ODD number of wires. But these are not working with EVEN.
      
      You can see the above image for the result.
      
      I have given the above formula for the Equipotential number formula with some integration to convert to ODD or Even, as you suggested. Can you please check this put under even numbers
      Like • Show 0 Likes0
      Actions
    - Brian Cooke @ Lord Fly on Apr 16, 2018 1:06 PM
      Mark Correct
      Correct Answer
      VAL(EQUIPOTENTIAL_ORDERNO)+1 should do the same thing. Convert's the string to a number so that it adds 1 instead of appending 1.
      Like • Show 0 Likes0
      Actions
Brian Cooke Apr 16, 2018 1:20 PM
Mark Correct
Correct Answer
I'm not sure how using a formula that adds 1 would work. Wouldn't wire 1 = 1, wire 2 = 3, and wire 3 = 3? so you would end up with multiple equipotentials of the same number?

For the wirestyles that you want to be even, just set the formula to =EQUIPOTENTIAL_ORDERNO*2
For the wirestyles you want to be odd, set to =EQUIPOTENTIAL_ORDERNO*2 - 1
No IF statements necessary.
Now for the caveat: If all your wirestyles are in the same group, you'll end up with some numbers getting skipped, but it's an easy fix. In your wire style manage put all the even numbered wire styles in one group and the odd in another. That way the ordernumbers will start over for each group, and all the odds will use all available ordernumbers, and the same with the even styles.

Edit: i missed that it was a multi-wire style, so you couldn't put them in separate groups. Not sure what to do about that. I'll have to think on it.
Like • Show 0 Likes0
Actions
- Harshith K. S. @ Brian Cooke on Apr 17, 2018 5:58 AM
  Mark Correct
  Correct Answer
  Hi Cooke,
  
  Many many thanks for your reply,
  I am able to reach my requirement for now.
  Like • Show 0 Likes0
  Actions

How can i get the wire numbers in ODD or Even Numbering?

Outcomes

Related Content

Recommended Content