Rank: Advanced Member Groups: Registered, Advanced Member Joined: 13/01/2012(UTC) Posts: 2,647 Location: Italy Was thanked: 1329 time(s) in 875 post(s)
|
|
If you like my plugins consider to support SMath Studio buying a plan; to offer me a coffee: paypal.me/dcprojects |
5 users thanked Davide Carpi for this useful post.
|
on 12/04/2016(UTC), on 12/04/2016(UTC), on 12/04/2016(UTC), on 13/04/2016(UTC), on 13/04/2016(UTC)
|
|
Rank: Advanced Member Groups: Registered
Joined: 05/03/2009(UTC) Posts: 433 Location: USA Was thanked: 17 time(s) in 15 post(s)
|
Will this allow us to transfer data? SWEET! Only thing better would be not needing to use data propagation between the worksheets (e.g. using rfile, wfile, importData, exportData, ...). Edited by user 12 April 2016 22:35:15(UTC)
| Reason: Not specified
|
|
|
|
Rank: Advanced Member Groups: Registered, Advanced Member Joined: 13/01/2012(UTC) Posts: 2,647 Location: Italy Was thanked: 1329 time(s) in 875 post(s)
|
Originally Posted by: ElSid Will this allow us to transfer data? SWEET! Is more targeted to process data "remotely"; data transfer is driven by existing functions (also include()); Originally Posted by: ElSid Only thing better would be not needing to use data propagation between the worksheets (e.g. using rfile, wfile, importData, exportData, ...). I think the only other way, in the scenario drawn in the example of the first post, would be to transfer data via functions, that is not a feasible way as for now. Also, I have to improve the log system to better recognize if there are errors in the target worksheets. Edited by user 13 April 2016 20:23:39(UTC)
| Reason: Not specified |
If you like my plugins consider to support SMath Studio buying a plan; to offer me a coffee: paypal.me/dcprojects |
|
|
|
Rank: Advanced Member Groups: Registered
Joined: 05/03/2009(UTC) Posts: 433 Location: USA Was thanked: 17 time(s) in 15 post(s)
|
How is this different than "Include" plug in by Uni?
|
|
|
|
Rank: Advanced Member Groups: Registered, Advanced Member Joined: 13/01/2012(UTC) Posts: 2,647 Location: Italy Was thanked: 1329 time(s) in 875 post(s)
|
Originally Posted by: ElSid How is this different than "Include" plug in by Uni? Mainly: include() loads the SMath variables/functions from the target worksheet into the one in use, while in Run() each worksheet is indipendent; include() can't run non-math regions (ComboBoxList, etc...) while Run() execute everything; |
If you like my plugins consider to support SMath Studio buying a plan; to offer me a coffee: paypal.me/dcprojects |
|
|
|
Rank: Advanced Member Groups: Registered
Joined: 05/06/2014(UTC) Posts: 348 Location: Colombo Was thanked: 125 time(s) in 82 post(s)
|
Originally Posted by: Davide Carpi requirements: SMath Studio 0.98.5935 or later; installation: SMath Studio: Tools Problem in 98.6081? |
Look within!... The secret is inside you. Best Regards Eng. NDTM Amarasekera - Sri Lanka |
|
|
|
Rank: Guest
Groups: Registered
Joined: 04/07/2015(UTC) Posts: 6,866 Was thanked: 981 time(s) in 809 post(s)
|
Hello collab ndtma,
Don't take my comment bad. Your snippets are always blurry [not comfortable]. You can "PrintScreen" paste in Paint to select the portion. That results in huge BMP... then reduce to 256 via IrfanView: superfreeware of multiuse ... mostly: sharpen image, superbe Lanczos zoon [square/rectangular] gray/color images ++++ . I use this technique as well as capture a selected region from WinGrab [freeware]. Wingrag has more options to reduce 256 colors, in many difficult cases of better quality than IrfanView, though is does not apply to Smath snippets.
Cheers, Jean
|
|
|
|
Rank: Advanced Member Groups: Registered
Joined: 05/06/2014(UTC) Posts: 348 Location: Colombo Was thanked: 125 time(s) in 82 post(s)
|
Hello Jean,
Thanks for your valuable suggestions.
|
Look within!... The secret is inside you. Best Regards Eng. NDTM Amarasekera - Sri Lanka |
|
|
|
Rank: Advanced Member Groups: Registered, Advanced Member Joined: 13/01/2012(UTC) Posts: 2,647 Location: Italy Was thanked: 1329 time(s) in 875 post(s)
|
Originally Posted by: ndtma Problem in 98.6081? Hello ndtma, yes, seems there are isSies with the process handle. I'm looking to find the cause and if I can solve it Edited by user 27 August 2016 23:56:46(UTC)
| Reason: typo |
If you like my plugins consider to support SMath Studio buying a plan; to offer me a coffee: paypal.me/dcprojects |
|
|
|
Rank: Advanced Member Groups: Registered, Advanced Member Joined: 13/01/2012(UTC) Posts: 2,647 Location: Italy Was thanked: 1329 time(s) in 875 post(s)
|
Issue found. edit: fixed in SS 0.98.6179Edited by user 02 December 2016 02:42:03(UTC)
| Reason: fix not included in latest relase |
If you like my plugins consider to support SMath Studio buying a plan; to offer me a coffee: paypal.me/dcprojects |
|
|
|
Rank: Newbie
Groups: Registered
Joined: 11/01/2017(UTC) Posts: 6 Location: Vancouver, BC
|
Hi Davide, I created my own example with a 3x3 excel table and it takes about 6 seconds for the "Run" function to execute each row of test data during the for loop. The smath sheet it's running contains 2 variables multiplied together and output as a variable 'd'. Your entire example runs in 22 seconds, with definitely a bit more complexity, but not much. Any ideas here? I'd like to run 400 rows of data (load cases for different members) through a calc sheet and collect the results, just like you've done (except only one calc sheet, not 3 like you've done). thx! Edited by user 02 November 2018 20:02:00(UTC)
| Reason: Not specified
|
|
|
|
Rank: Advanced Member Groups: Registered, Advanced Member Joined: 13/01/2012(UTC) Posts: 2,647 Location: Italy Was thanked: 1329 time(s) in 875 post(s)
|
Currently each Run function triggers a new instance of SMath Studio; this means that all the initialization process must be done every time, rising the execution time. What you can try is to change the logic to start a single run with multiple worksheets, and init/finalize each loop step in a dedicated file. new loopSheet.sm initCalc.sm handleCalcResults.sm Edited by user 02 November 2018 14:25:30(UTC)
| Reason: Not specified |
If you like my plugins consider to support SMath Studio buying a plan; to offer me a coffee: paypal.me/dcprojects |
1 user thanked Davide Carpi for this useful post.
|
|
|
Rank: Newbie
Groups: Registered
Joined: 11/01/2017(UTC) Posts: 6 Location: Vancouver, BC
|
Thanks for the response Davide. So I went ahead and tried out your idea, it does solve the only 'running' once issue and finishes the script in 6 seconds no matter what. But now I have the issue where the Run(exec) command does not seem to be running all the scripts in the exec matrix, or somehow it's only saving the first 'calcResults' in 'allResults'. That said, I was successful in manually looping the 3 sheets, so I thin something is going on incorrectly in the run(exec) line. You can see what I did in the gifs below if you open them full size in a new tab.. Thoughts? Calc completed successfully by manually looping the 3 sheets:Calc running with loop sheet, only records first row result:
|
|
|
|
Rank: Guest
Groups: Registered
Joined: 04/07/2015(UTC) Posts: 6,866 Was thanked: 981 time(s) in 809 post(s)
|
Originally Posted by: ksullivan so I think something is going on incorrectly in the run(exec) line. That I don't understand the idea/purpose of run does not indicate it is useless. Do you mean run would calculate in a cash of some sort a selection of work sheets and then would show all calculated by clicking "Open file" ?
|
|
|
|
Rank: Advanced Member Groups: Registered
Joined: 28/08/2014(UTC) Posts: 1,356 Was thanked: 815 time(s) in 516 post(s)
|
Originally Posted by: ksullivan Thanks for the response Davide. ... You can see what I did in the gifs below if you open them full size in a new tab..
Thoughts? ... Hi K. Gif shows that you modify iniCalc.sm (disabling some calcs) but don't save it, so others SMath files read the original iniCalc.sm, not the modified. Is this the issue or I'm are not understanding something else? Best regards. Alvaro.
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 11/01/2017(UTC) Posts: 6 Location: Vancouver, BC
|
|
|
|
|
Rank: Advanced Member Groups: Registered, Advanced Member Joined: 13/01/2012(UTC) Posts: 2,647 Location: Italy Was thanked: 1329 time(s) in 875 post(s)
|
You are right, I have to investigate it. |
If you like my plugins consider to support SMath Studio buying a plan; to offer me a coffee: paypal.me/dcprojects |
|
|
|
Rank: Guest
Groups: Registered
Joined: 04/07/2015(UTC) Posts: 6,866 Was thanked: 981 time(s) in 809 post(s)
|
Originally Posted by: ksullivan I reran it after saving everything and the same thing happened Document calcSheet calculates nothing [no maths/formula(s)/result(s)] Certainly no gadget will retrieve something from nothing, is it ? If calcSheet calculates something, save to file and retrieve from any other Smath work sheet. On the other hand, you may save formula(s) in calcsheet and retrieve from any other Smath work sheet then modify the formula(s) in the working document ... per say change parameters. You say nothing about what you have in mind.
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 11/01/2017(UTC) Posts: 6 Location: Vancouver, BC
|
Originally Posted by: Jean Giraud Document calcSheet calculates nothing [no maths/formula(s)/result(s)]
I know in this case calcSheet.sm is not "calculating" anything. The whole problem we're trying to solve is looping a large data set through the calcSheet, row by row, which processes the data with whatever formulas we want, in this case it's 1*data my previous example actually took one of the values in the 'current row' and multiplied it by 3. I just wanted to make the example here as simple as possible so we could hone in on the problem.
|
|
|
|
Rank: Guest
Groups: Registered
Joined: 04/07/2015(UTC) Posts: 6,866 Was thanked: 981 time(s) in 809 post(s)
|
Originally Posted by: ksullivan I know in this case calcSheet.sm is not "calculating" anything. The whole problem we're trying to solve is looping a large data set through the calcSheet, row by row, which processes the data with whatever formulas we want, in this case it's 1*data my previous example actually took one of the values in the 'current row' and multiplied it by 3.I just wanted to make the example here as simple as possible so we could hone in on the problem. Simply attach the basic project and describe the next part of the project. As you explain, it looks weird from maybe baby simple.
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.