1 страниц (7 вхождений)
SMath sheet interference question - Not only share data between different sheets. Run a existing sheet within a developing sheet - Сообщения
#1 Опубликовано: 21.07.2015 11:36:55
If I want to run an existing smath sheet in smath sheet again and again, which way I can do that?
Can we make an existing smath sheet as a plugin in like a function input? if so, we can run it in a new sheet again and again. Do we have easier way to make a plugin?
I don't know VB or any other language.
Any help will be appreciate.
Can we make an existing smath sheet as a plugin in like a function input? if so, we can run it in a new sheet again and again. Do we have easier way to make a plugin?
I don't know VB or any other language.
Any help will be appreciate.
#2 Опубликовано: 21.07.2015 12:42:05
Several ways you can do this, it really depends on how much work you want to put into it.
1 - You can create an "if" loop and return the result as a vector for each iteration.
2 - Turn the operation into a function.
3 - Use the operation as is, then copy it and paste it lower on the sheet to reuse it. Only convenient if you use it a few times only.
1 - You can create an "if" loop and return the result as a vector for each iteration.
2 - Turn the operation into a function.
3 - Use the operation as is, then copy it and paste it lower on the sheet to reuse it. Only convenient if you use it a few times only.
#3 Опубликовано: 21.07.2015 12:53:04
Thank you for your reply. The developed sheet is a bit complicated, and I don't want to do any modification there. The thing is that I have a bunch of data inout need to be run in a loop, and I want to run the developed sheet in a loop, and write output as a list or table.
I know your way 3. It is fine for just a few times only.
how can I turn the developed smath sheet as a function if I understand correctly in way 2?
I know your way 3. It is fine for just a few times only.
how can I turn the developed smath sheet as a function if I understand correctly in way 2?
#4 Опубликовано: 21.07.2015 13:03:10
#5 Опубликовано: 21.07.2015 18:07:14
#6 Опубликовано: 21.07.2015 18:48:39
Kind of hard to follow, but the first thing is seems like you are trying to define a function "PROPERTY(Connect):=BS". What is in the parenthesis is the variable, but that variable is not in the function. "BS" is also undefined. So this doesn't do anything at all.
Then you use "Connect" in the next part, but it is undefined, so there is an error. This part tries to match what is in the "Connect" variable to some numbers, "BS-20" for example. But you will never get a match because the data you imported is in a different format, "BS-20(B )" for example.
You define "Connect" at the end and use it in this function. The function variable should be different. Define it as "PROPERTY(x):= x*3" For example. BS needs to be defined, otherwise include another variable in the function "PROPERTY(x,y):= x*3-y^2". Then you can use it later on as intended "PROPERTY(Connect,BS)= "
Save yourself some complexity and import the data starting from cell C2 instead of C1, this will simplify your loops and matrix indexing.
Before moving on to see if this will work, the above has to be addressed first.
Then you use "Connect" in the next part, but it is undefined, so there is an error. This part tries to match what is in the "Connect" variable to some numbers, "BS-20" for example. But you will never get a match because the data you imported is in a different format, "BS-20(B )" for example.
You define "Connect" at the end and use it in this function. The function variable should be different. Define it as "PROPERTY(x):= x*3" For example. BS needs to be defined, otherwise include another variable in the function "PROPERTY(x,y):= x*3-y^2". Then you can use it later on as intended "PROPERTY(Connect,BS)= "
Save yourself some complexity and import the data starting from cell C2 instead of C1, this will simplify your loops and matrix indexing.
Before moving on to see if this will work, the above has to be addressed first.
#7 Опубликовано: 22.07.2015 01:58:21
WroteIf I want to run an existing smath sheet in smath sheet again and again, which way I can do that?
Can we make an existing smath sheet as a plugin in like a function input? if so, we can run it in a new sheet again and again. Do we have easier way to make a plugin?
I don't know VB or any other language.
Any help will be appreciate.
Try to use include() function for this purpose.
Russia ☭ forever, Viacheslav N. Mezentsev
1 страниц (7 вхождений)
-
Новые сообщения
-
Нет новых сообщений