Skip to Content

Register Login

Industry Online Support

Technical Forum

Navigation

Excel formula to SCL

Created by: adrian_botez at: 6/29/2014 8:06 PM (7 Replies)

Rating (0)

Thanks 0

8 Entries

6/29/2014 8:06 PM	Rate (0)
adrian_botez Bronze Member Joined: 2/19/2013 Last visit: 10/27/2023 Posts: 184 Rating: (8)	Hello experts. I am trying to translate an Excel formula to SCL in Tia Portal V13 but it seems it doesn´t work. The formula to be translated is: =IF(E17<PI()C5;15/8(C4-C6)/(E17-C6/C12)-7/8360/PI()/C5;360/PI()/C5) I have it done in this way: if ( E17 < 3.14 C5) then resultado := (15/8) * ((C4 - C6) / (E17 - (C6/C12))) - (7/8) * ((360/3.14)/C5); else resultado := (360/3.14)/C5; end_if; Is that correct?
	Last edited by: adrian_botez at: 6/29/2014 9:44 PM
Suggestion To thank Quote Answer

6/29/2014 8:46 PM	Rate (0)
IBN-Service Posts: 8946 Rating: (998)	C4, C5, C6 ...are Excel - cells, SCL do not know about that cells....
IBN-Service Posts: 8946 Rating: (998)
Suggestion To thank Quote Answer

6/29/2014 9:14 PM	Rate (0)
adrian_botez Bronze Member Joined: 2/19/2013 Last visit: 10/27/2023 Posts: 184 Rating: (8)	Yes of course, but just imagine that in this case, C4 and al others are numbres, in this case REAL numbres like 365.0 , like PI (3.1416).
	Last edited by: adrian_botez at: 6/29/2014 9:35 PM Last edited by: adrian_botez at: 6/29/2014 9:33 PM
Suggestion To thank Quote Answer

6/29/2014 9:40 PM	Rate (0)
William_B Posts: 5225 Rating: (1182)	adrian_botez Yes of course, but just imagine that in this case, C4 and al others are numbres, in this case REAL numbres like 365.0 , like PI (3.1416). Adrian, I do not see much issue in the formula. (why did you not publish this with the original question?). Remember to have ":=" with the assignment. I recommend for you to convert all INT values to DINT and then to REAL. Work throughout with REAL. Where you have used constant values like "5", rather use "5.0" to show REAL value. The answer that comes out, you decide if you want to keep it REAL, or do you wish to convert back to (DINT first) INT. w
William_B Posts: 5225 Rating: (1182)
Suggestion To thank Quote Answer

6/29/2014 9:41 PM	Rate (0)
William_B Posts: 5225 Rating: (1182)	Late note.. You could have done the same in LADDER using the CALCULATE function. There remember the constants are also declared as inputs to the block. But in your case the SCL will work more easy.
William_B Posts: 5225 Rating: (1182)	Last edited by: William B. at: 6/29/2014 9:42 PM
Suggestion To thank Quote Answer

6/29/2014 9:43 PM	Rate (0)
adrian_botez Bronze Member Joined: 2/19/2013 Last visit: 10/27/2023 Posts: 184 Rating: (8)	This is a sort of a calculation of a moving object trough a conveyor. This is only a part of the formula, but this one is the only that doesn´t work . I doesn´t have nothing to do with the encoder RPM calculation.
	Last edited by: adrian_botez at: 6/29/2014 9:44 PM
Suggestion To thank Quote Answer

6/29/2014 9:51 PM	Rate (0)
William_B Posts: 5225 Rating: (1182)	[smile] /tf/WW/en/Posts/110659#top
William_B Posts: 5225 Rating: (1182)
Suggestion To thank Quote Answer

6/29/2014 10:01 PM	Rate (0)
adrian_botez Bronze Member Joined: 2/19/2013 Last visit: 10/27/2023 Posts: 184 Rating: (8)	Damn, I forgon allready that I have another post with the same question.

Suggestion To thank Quote Answer

|

Share this page:

Share this page on...

Follow us on